huahuibao/console/controllers/CustomDebtChangeController.php

<?php

namespace console\controllers;

use bizGhs\custom\classes\CustomDebtChangeClass;
use bizGhs\custom\models\CustomDebtChange;
use bizGhs\order\classes\OrderClass;
use bizGhs\order\classes\RefundOrderClass;
use yii\console\Controller;
use Yii;

class CustomDebtChangeController extends Controller
{

    public function actionChange()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $query = new \yii\db\Query();
        $query->from(CustomDebtChange::tableName());
        $query->where(['capitalType' => 40]);
        foreach ($query->batch() as $batch) {
            foreach ($batch as $change) {
                $changeId = $change['id'];
                $relateId = $change['relateId'] ?? 0;
                $refund = RefundOrderClass::getById($relateId, true);
                $relateOrderSn = $refund->relateOrderSn ?? '';
                if (empty($relateOrderSn)) {
                    continue;
                }
                echo $changeId.' '.$relateId.' '.$relateOrderSn;die;
                $order = OrderClass::getByCondition(['orderSn' => $relateOrderSn], true);
                if ($order->payStatus == 1) {
                    $payTime = $order->payTime;
                    CustomDebtChangeClass::updateById($changeId, ['payTime' => $payTime]);
                }
            }
        }
    }

}