Post Views: 53
1. Use updateAll() to update the value of prev_status to the value of status, and update the value of status to 4, the table structure is shown in Figure 1
Figure 1
2. Based on the query builder, the code is as follows
self::updateAll(['prev_status' => 'status', 'status' => self::PLAN_TASK_STATUS_CLOSE], ['in', 'plan_id', $planId]);
3. However, it does not meet the expectations. The values of prev_status are updated with 0, and the final SQL statement is as follows
UPDATE `pa_plan_task` SET `prev_status`=0, `status`=4 WHERE `plan_id` IN (1, 2)
4. Based on yii\db\expression, it means a db expression that does not need to be escaped or referenced, the code is as follows
use yii\db\Expression;
self::updateAll(['prev_status' => new Expression('status'), 'status' => self::PLAN_TASK_STATUS_CLOSE], ['in', 'plan_id', $planId]);
5. The result is as expected, and the final generated SQL statement is as follows
UPDATE `pa_plan_task` SET `prev_status`=status, `status`=4 WHERE `plan_id` IN (1, 2)
6. The operation result is as expected, as shown in Figure 2
Figure 2 
Leave a Reply