1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| public function getCaipanOrder($id,$no,$uid,$productno,
$play,$time,$winorlose,$type,$order,
$issimulate,$usercategory,$agent_class,
$createtime_starttime, $createtime_endtime,$closetime_starttime,$closetime_endtime){
$m=M('caipan_order');
if($id){
$con['caipanorder_id']=$id;
}
if($no){
$con['caipanorder_no']=$no;
}
if($uid){
$con['caipanorder_uid']=$uid;
}
if($productno){
$con['caipanorder_productno']=$productno;
}
if($play){
$con['caipanorder_play']=$play;
}
if($time){
$con['caipanorder_time']=$time;
}
if($winorlose){
$con['caipanorder_winorlose']=$winorlose;
}
if($type!==null){
$con['caipanorder_type']=$type;
}
if($issimulate!==null){
$con['user_issimulate_user']=$issimulate;
}
if($usercategory!==null){
$con['user_catgoryid']=$usercategory;
}
if($agent_class!==null){
$con['user_agent_class']=$agent_class;
}
if($createtime_starttime){
$con['caipanorder_buytime']=array(array('egt',$createtime_starttime),
array('elt',$createtime_endtime),'and') ;
}
if($closetime_starttime){
$con['caipanorder_sellingtime']=array(array('egt',$closetime_starttime),
array('elt',$closetime_endtime),'and') ;
}
return $r=$m->where($con)->order($order)
->join("LEFT JOIN x_user ON x_user.user_id=x_caipan_order.caipanorder_uid")
->join("LEFT JOIN x_user_category ON x_user_category.usercategory_id=x_user.user_catgoryid")
->select();
} |