试图实现查询以获取作业代码、作业描述、当前状态不等于到期日前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();

09-30 14:55
查看更多