|
- $process = DB::connection('mysql_ads')->table('workflow')
- ->join('workprocess',function($join) use($v,$last_finish){
- $join->on('workprocess.flow_id','=','workflow.id')
- ->whereRaw('(ads_workprocess.worker_uid is null or ads_workprocess.worker_uid=?)',[$v->worker_uid])
- ->whereRaw('(ads_workprocess.customer_id is null or ads_workprocess.customer_id=?)',[$v->customer_id])
- ->whereRaw('(ads_workprocess.finish_time is null or ads_workprocess.finish_time>=?)',[$last_finish]);
- }, null,null,'left')
- ->where('workflow.belong_week', '<=', $cur_week)
- ->orderBy('workflow.sort','asc')->get()->toArray();
- $list[$k]->process = $process;
复制代码
|
|