试图实现查询以获取作业代码、作业描述、当前状态不等于到期日前2天打包或发货的客户代码-
$query = new Query;
$todo = (new yii\db\Query())
->SELECT(['status','job_code','job_description','client_code'])
->from('create_job')
->where('status' LIKE 'PACKING' OR 'DISPATCH' AND 'approved_date' >= 'CURRENT_DATE' AND 'deadline' < 'CURRENT_DATE' + 'INTERVAL 2 DAY')
->all();
如何做到这一点?
最佳答案
试试这个
(new Query())->select(['status','job_code','job_description','client_code'])
->from('create_job')
->andWhere("status != 'PACKING'")
->andWhere("status != 'DISPATCH'")
->andWhere('deadline < (CURRENT_DATE + INTERVAL 2 DAY)')
->all();