<?php

namespace console\controllers;

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

class BalanceChangeController extends Controller
{

    public function actionCustom()
    {
        $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()
    {
        $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]);
            }
        }
    }

}