laravel on多条件的写法实例

追影

1. $process = DB::connection('mysql_ads')->table('workflow')
   
2.                 ->join('workprocess',function($join) use($v,$last_finish){
   
3.                     $join->on('workprocess.flow_id','=','workflow.id')
   
4.                         ->whereRaw('(ads_workprocess.worker_uid is null or ads_workprocess.worker_uid=?)',[$v->worker_uid])
   
5.                         ->whereRaw('(ads_workprocess.customer_id is null or ads_workprocess.customer_id=?)',[$v->customer_id])
   
6.                         ->whereRaw('(ads_workprocess.finish_time is null or ads_workprocess.finish_time>=?)',[$last_finish]);
   
7.                 }, null,null,'left')
   
8.                 ->where('workflow.belong_week', '<=', $cur_week)
   
9.                 ->orderBy('workflow.sort','asc')->get()->toArray();
   
10.             $list[$k]->process = $process;

复制代码