huahuibao/console/controllers/SaleController.php

<?php

namespace console\controllers;

use biz\shop\classes\MainClass;
use biz\shop\classes\ShopClass;
use biz\stat\classes\StatSaleClass;
use bizGhs\order\classes\OrderClass;
use common\components\util;
use yii\console\Controller;
use Yii;

class SaleController extends Controller
{

    //销售数据更新 ./yii sale/update
    public function actionUpdate()
    {
        $list = OrderClass::getAllByCondition(['status' => ['in', [2, 3, 4]]], 'id asc', '*', null, true);
        if (!empty($list)) {
            foreach ($list as $item) {
                $orderSn = $item->orderSn ?? '';
                $shopId = $item->shopId ?? 0;
                $addTime = $item->addTime ?? '';

                $connection = Yii::$app->db;
                $transaction = $connection->beginTransaction();

                $actPrice = $item->actPrice ?? 0;

                try {

                    $shop = ShopClass::getLockById($shopId);
                    if (empty($shop)) {
                        echo '没有找到店铺 ' . $shopId . ' ' . $orderSn . "\n";
                        continue;
                    }
                    $mainId = $shop->mainId ?? 0;
                    $main = MainClass::getById($mainId, true);
                    if (empty($main)) {
                        util::fail('没有找到main信息');
                    }
                    $totalSale = bcadd($actPrice, $main->totalSale, 2);
                    $main->totalSale = $totalSale;
                    $main->totalOrderNum += 1;
                    $main->save();
                    $date = date("Ymd", strtotime($addTime));
                    StatSaleClass::replace($main, $shop, $actPrice, $date);
                    $transaction->commit();

                } catch (\Exception $e) {
                    $transaction->rollBack();
                    $msg = $e->getMessage();
                    echo "报错了：" . $msg . "\n";
                }
            }
        }
    }

}