console\controllers\StoreController::actionToActive PHP Метод

    public function actionToActive()
    {
        $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_active, :type_both)';
            $count = Yii::$app->db->createCommand($sql, [':status' => Store::STATUS_ACTIVE, ':auto_toggle' => '1', ':status_where' => Store::STATUS_DISABLED, ':type_active' => Store::TOGGLE_TYPE_ACTIVE, ':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;
        }
    }