大米CMS官网论坛,大米站长联盟,大米站长之家,大米开发者社区
标题:
laravel on多条件的写法实例
[打印本页]
作者:
追影
时间:
2021-12-23 15:08
标题:
laravel on多条件的写法实例
$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;
复制代码
欢迎光临 大米CMS官网论坛,大米站长联盟,大米站长之家,大米开发者社区 (https://www.damicms.com/bbs/)
Powered by Discuz! X3.1