huahuibao/console/controllers/InitController.php

<?php

namespace console\controllers;

use biz\admin\classes\AdminClass;
use biz\item\classes\UnitClass;
use biz\product\classes\ProductClass;
use biz\shop\classes\ShopClass;
use bizGhs\ghs\classes\GhsClass;
use bizGhs\order\classes\StockInOrderClass;
use bizGhs\order\classes\StockOutOrderClass;
use bizGhs\order\classes\StockOutOrderItemClass;
use yii\console\Controller;

class InitController extends Controller
{

    public function actionShop()
    {
        $list = ShopClass::getAllByCondition(['adminId' => 0], null, '*', null, true);
        if (!empty($list)) {
            foreach ($list as $shop) {
                $mobile = $shop->mobile;
                if (!empty($mobile)) {
                    $admin = AdminClass::getByCondition(['mobile' => $mobile], true);
                    $adminId = $admin->id;
                    if (!empty($adminId)) {
                        $shop->adminId = $adminId;
                        $shop->save();
                        echo $shop->id . ' ' . $adminId . "\n";
                    }
                }
            }
        }
    }

    public function actionOut()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $list = StockOutOrderClass::getAllByCondition(['addTime>' => '2022-11-10 00:00:00'], null, '*', null, true);
        if (empty($list)) {
            return false;
        }
        foreach ($list as $out) {
            $orderSn = $out->orderSn ?? '';
            $inOrderSn = $out->inOrderSn ?? '';
            $in = StockInOrderClass::getByCondition(['orderSn' => $inOrderSn], true);
            if (empty($in)) {
                echo $orderSn . " 没有找到入库记录\n";
            }
            $itemList = StockOutOrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
            $totalCost = 0;
            if (!empty($itemList)) {
                foreach ($itemList as $item) {
                    $itemNum = $item->itemNum ?? 0;
                    $itemPrice = $item->itemPrice ?? 0;
                    $current = bcmul($itemNum, $itemPrice, 2);
                    $totalCost = bcadd($totalCost, $current, 2);
                }
            }
            $in->price = $totalCost;
            $in->save();
            $out->price = $totalCost;
            $out->save();
            echo $orderSn . " 总成本{$totalCost}\n";
        }
    }

}