{template show.js} {php} include_once(Core.'/class/pages_ajax_class_phpapp.php'); $uid=$this->uid; $task=$this->GetMysqlOne('uid,money,tid,serviceuid,hidedraft'," ".$this->GetTable('task')." WHERE tid='$this->tid'"); if(!empty($this->GET['did'])){ $did=intval($this->GET['did']); $order=" AND a.did='$did' ORDER BY topbid DESC ,did DESC"; }else{ $order=' AND a.process=0 ORDER BY topbid DESC,did DESC'; } if($this->GET['type']==1 || $this->GET['type']==4){ if($this->GET['type']==4){ $usersql=" AND a.uid='$this->uid' "; }else{ $usersql=' AND a.process>0 '; } //已审核的投标 $order='ORDER BY a.topbid DESC,a.process DESC'; $ajaxpage=new AjaxPages(10,$this->GET['page'],$this->tid,$this->GET['sqlorder'],$this->GET['iforder'],'DraftPage',"SELECT a.*,b.username,b.dateline AS regtime,b.logintime,c.certificate,d.credit,d.wealth,credits,credittype,f.tasknum,f.draftnum,f.successnum,g.speed,g.attitude,g.quality FROM (((((".$this->GetTable('task_draft')." AS a LEFT JOIN ".$this->GetTable('member')." AS b ON a.uid=b.uid)LEFT JOIN ".$this->GetTable('member_info')." AS c ON b.uid=c.uid)LEFT JOIN ".$this->GetTable('member_account')." AS d ON b.uid=d.uid) LEFT JOIN ( SELECT type AS credittype,credit AS credits,uid FROM ".$this->GetTable('credit')." WHERE type=1 ) AS e ON b.uid=e.uid )LEFT JOIN ".$this->GetTable('task_total')." AS f ON b.uid=f.uid) LEFT JOIN ".$this->GetTable('credit_score')." AS g ON c.uid=g.uid WHERE a.tid='$this->tid' $usersql $order"); }else{ $ajaxpage=new AjaxPages(10,$this->GET['page'],$this->tid,$this->GET['sqlorder'],$this->GET['iforder'],'DraftPage',"SELECT a.*,b.username,b.dateline AS regtime,b.logintime,c.certificate,d.credit,d.wealth,credits,credittype,f.tasknum,f.draftnum,f.successnum,g.speed,g.attitude,g.quality FROM (((((".$this->GetTable('task_draft')." AS a LEFT JOIN ".$this->GetTable('member')." AS b ON a.uid=b.uid)LEFT JOIN ".$this->GetTable('member_info')." AS c ON b.uid=c.uid)LEFT JOIN ".$this->GetTable('member_account')." AS d ON b.uid=d.uid) LEFT JOIN ( SELECT type AS credittype,credit AS credits,uid FROM ".$this->GetTable('credit')." WHERE type=1 ) AS e ON b.uid=e.uid )LEFT JOIN ".$this->GetTable('task_total')." AS f ON b.uid=f.uid)LEFT JOIN ".$this->GetTable('credit_score')." AS g ON c.uid=g.uid WHERE a.tid='$this->tid' AND a.process=0 $order"); } $list=$ajaxpage->ShowResult(); {/php} {if !empty($list)}
该稿件已隐藏,只有雇主和投标本人登录后可见!
该稿件已隐藏,只有雇主和投标本人登录后可见!
目前暂时没有投标!
{/if}