<?php

namespace console\controllers;

use biz\stat\classes\StatCgGhsClass;
use bizGhs\order\classes\PurchaseOrderClass;
use bizGhs\order\models\PurchaseOrder;
use yii\console\Controller;
use Yii;

class StatCgGhsController extends Controller
{

    // ./yii stat-cg-ghs/bc
    public function actionBc()
    {

        ini_set('memory_limit', '2045M');
        set_time_limit(0);

        $sql = 'TRUNCATE `xhStatCgGhs`;TRUNCATE `xhStatCgGhsMonth`;';
        Yii::$app->db->createCommand($sql)->execute();

        $query = new \yii\db\Query();
        $query->from(PurchaseOrder::tableName());

        foreach ($query->batch() as $batch) {
            foreach ($batch as $cgInfo) {
                $id = $cgInfo['id'] ?? 0;
                $date = date('Ymd', strtotime($cgInfo['addTime']));
                $current = PurchaseOrderClass::getById($id, true);
                if (empty($current)) {
                    continue;
                }
                StatCgGhsClass::ghsReplace($current, $date);
            }
        }

    }

}