<?php

namespace console\controllers;

use bizGhs\custom\classes\CustomBalanceChangeClass;
use bizGhs\custom\classes\CustomClass;
use bizGhs\custom\classes\CustomDebtChangeClass;
use bizGhs\custom\models\CustomBalanceChange;
use bizGhs\ghs\classes\GhsClass;
use bizGhs\ghs\models\GhsBalanceChange;
use bizGhs\shop\models\Shop;
use bizHd\ghs\classes\GhsBalanceChangeClass;
use yii\console\Controller;
use Yii;

class BalanceChangeController extends Controller
{

    public function actionShop()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $query = new \yii\db\Query();
        $query->from(Shop::tableName());
        $query->where(['ptStyle' => 2]);
        foreach ($query->batch() as $changeList) {
            foreach ($changeList as $shop) {
                $shopId = $shop['id'] ?? 0;
                $sjId = $shop['sjId'] ?? 0;
                CustomDebtChangeClass::updateByCondition(['sjId' => $sjId], ['shopId' => $shopId]);
                echo $sjId;die;
            }
        }
    }

    public function actionCustom()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $query = new \yii\db\Query();
        $query->from(CustomBalanceChange::tableName());
        $query->where(['>', 'id', 0]);
        foreach ($query->batch() as $changeList) {
            foreach ($changeList as $change) {
                $id = $change['id'] ?? 0;
                $customId = $change['customId'] ?? 0;
                $custom = CustomClass::getById($customId, true);
                $customName = $custom->name ?? '';
                CustomBalanceChangeClass::updateById($id, ['customName' => $customName]);
            }
        }
    }

    public function actionGhs()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $query = new \yii\db\Query();
        $query->from(GhsBalanceChange::tableName());
        $query->where(['>', 'id', 0]);
        foreach ($query->batch() as $changeList) {
            foreach ($changeList as $change) {
                $id = $change['id'];
                $ghsId = $change['ghsId'];
                $ghs = GhsClass::getById($ghsId, true);
                $ghsName = $ghs->name;
                GhsBalanceChangeClass::updateById($id, ['ghsName' => $ghsName]);
            }
        }
    }

}