console\controllers\OrderController::actionRemind PHP Метод

    public function actionRemind()
    {
        $sql = "SELECT t1.cellphone, count(t0.id) AS count FROM {{%order}} AS t0 LEFT JOIN {{%store}} AS t1 ON t0.store_id = t1.id WHERE t0.status=:status AND t0.created_at < CURRENT_TIMESTAMP - 900 AND t0.created_at >= CURRENT_TIMESTAMP - 1800 GROUP BY t1.id;";
        $result = Yii::$app->db->createCommand($sql, [':status' => Order::STATUS_UNSHIPPED])->queryAll(\PDO::FETCH_BOTH);
        if ($result) {
            foreach ($result as $row) {
                Yii::$app->smser->send($row[0], "亲爱的店长，您有{$row[1]}笔订单等待发货，请您快去查看。");
                sleep(1);
            }
            echo "Reminded " . count($result) . " stores.\n";
        } else {
            echo "Nothing to do.\n";
        }
        return static::EXIT_CODE_NORMAL;
    }