php - Yii2:mysql 查询以获取有关待处理作业的提醒？

Question

尝试执行查询以获取当前状态不等于 PACKING 或 DISPATCH 的 job_code、job_description、client_code 在其截止日期前 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();

如何实现？

Answer 1

试试这个

(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();