试图在截止日期前2天内实现查询以获取当前状态不等于PACKING或DISPATCH的job_code,job_description,client_code -
$query = new Query;
$todo = (new yiidbQuery())
->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();
SELECT status,job_code,job_description,client_code
from create_job
where((status ='PACKING' OR status='DISPATCH') AND
(approved_date >= CURRENT_DATE AND deadline < date_add(CURRENT_DATE ,INTERVAL 2 DAY))