huahuibao/console/controllers/InitController.php

<?php

namespace console\controllers;

use bizHd\order\classes\OrderClass;
use bizHd\order\models\Order;
use common\components\util;
use Yii;
use yii\console\Controller;

class InitController extends Controller
{

    public function actionChange()
    {
        global $argv;
        $shopId = $argv[2] ?? 0;
        if (empty($shopId)) {
            util::stop('没有门店');
        }
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $list = OrderClass::getAllByCondition(['shopId' => $shopId, 'fromType' => 3, 'reachDate>' => '2022-08-01'], null, '*', null, true);
        if (!empty($list)) {
            foreach ($list as $order) {
                echo $order['reachDate'] . "\n";
            }
        }
    }

    //供应商和花店历史订单和历史结账单 payStatus payTime更新
    // ./yii init/pay-status
    public function actionPayStatus()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);

        $sql = "UPDATE `xhOrder` SET `payStatus`=0;";
        Yii::$app->db->createCommand($sql)->execute();
        $sql = "UPDATE `xhGhsOrder` SET `payStatus`=0;";
        Yii::$app->db->createCommand($sql)->execute();

        $query = new \yii\db\Query();
        $query->from(Order::tableName());
        $query->where(['in', 'status', [2, 3, 4]]);
        $query->orderBy('deadline ASC');
        foreach ($query->batch() as $batchOrder) {
            foreach ($batchOrder as $hdOrder) {
                $addTime = $hdOrder['addTime'] ?? '';
                $id = $hdOrder['id'] ?? 0;
                OrderClass::updateById($id, ['payTime' => $addTime, 'payStatus' => 1]);
            }
        }

        $query = new \yii\db\Query();
        $query->from(\bizGhs\order\models\Order::tableName());
        $query->where(['in', 'status', [2, 3, 4]]);
        $query->orderBy('deadline ASC');
        foreach ($query->batch() as $batchOrder) {
            foreach ($batchOrder as $ghsOrder) {
                $addTime = $ghsOrder['addTime'] ?? '';
                $id = $ghsOrder['id'] ?? 0;
                \bizGhs\order\classes\OrderClass::updateById($id, ['payTime' => $addTime, 'payStatus' => 1]);
            }
        }

        $sql = "UPDATE `xhClear` SET `payTime`=`addTime` where `status`=2;";
        Yii::$app->db->createCommand($sql)->execute();

    }

}