<?php

namespace console\controllers;

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

class InitController extends Controller
{

    //供应商和花店历史订单和历史结账单 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();

    }

}