huahuibao/console/controllers/StockRecordController.php

<?php

namespace console\controllers;

use bizGhs\product\classes\ProductClass;
use bizGhs\stock\classes\StockRecordClass;
use yii\console\Controller;

/**
 * 脚本
 */
class StockRecordController extends Controller
{

    //  ./yii stock-record/update-product-id
    public function actionUpdateProductId()
    {
        $list = StockRecordClass::getAllByCondition(['productId' => 0], null, '*', null, true);
        if (!empty($list)) {
            foreach ($list as $item) {
                $itemId = $item->itemId ?? 0;
                $shopId = $item->shopId ?? 0;
                $p = ProductClass::getByCondition(['itemId' => $itemId, 'shopId' => $shopId], true);
                $productId = $p->id ?? 0;
                if (!empty($productId)) {
                    $item->productId = $productId;
                    $item->save();
                }
                echo "id:" . $item->id . " 已经更新productId：" . $productId . "\n";
            }
        }
    }

}