public function actionToRest()
{
$transaction = Yii::$app->db->beginTransaction();
try {
$sql = 'UPDATE {{%store}} SET status=:status WHERE auto_toggle=:auto_toggle AND status<>:status_where AND toggle_type IN (:type_rest, :type_both)';
$count = Yii::$app->db->createCommand($sql, [':status' => Store::STATUS_REST, ':auto_toggle' => '1', ':status_where' => Store::STATUS_DISABLED, ':type_rest' => Store::TOGGLE_TYPE_REST, ':type_both' => Store::TOGGLE_TYPE_BOTH])->execute();
$transaction->commit();
echo "{$count} of stores affected by the execution.\n";
return static::EXIT_CODE_NORMAL;
} catch (\Exception $e) {
$transaction->rollBack();
echo $e->getMessage();
return static::EXIT_CODE_ERROR;
}
}