huahuibao/console/controllers/InitController.php

<?php

namespace console\controllers;

use biz\pt\classes\PtYeChangeClass;
use biz\recharge\classes\RechargeClass;
use biz\shop\classes\MainClass;
use biz\shop\classes\ShopAdminClass;
use biz\shop\classes\ShopCapitalClass;
use biz\shop\classes\ShopClass;
use biz\shop\classes\ShopYeChangeClass;
use biz\sj\classes\CashClass;
use biz\stat\classes\StatCgClass;
use biz\stat\classes\StatCgGhsClass;
use biz\stat\classes\StatCgGhsMonthClass;
use biz\stat\classes\StatCgMonthClass;
use biz\stat\classes\StatOrderCountClass;
use biz\stat\classes\StatOutClass;
use biz\stat\classes\StatOutMonthClass;
use biz\stat\classes\StatSaleClass;
use biz\stat\classes\StatSaleMonthClass;
use bizGhs\item\classes\ItemClass;
use bizGhs\item\classes\ItemClassClass;
use bizGhs\order\classes\StockWastageOrderClass;
use bizGhs\order\classes\StockWastageOrderItemClass;
use bizGhs\stat\classes\StatYjClass;
use bizGhs\stat\classes\StatYjMonthClass;
use bizHd\goods\classes\CategoryClass;
use bizHd\goods\classes\GoodsCategoryClass;
use bizHd\goods\classes\GoodsClass;
use bizHd\stat\classes\StatOrderClass;
use bizHd\stat\classes\StatOrderMonthClass;
use bizHd\stat\classes\StatUserClass;
use bizHd\stat\classes\StatUserMonthClass;
use bizHd\stat\classes\StatVisitClass;
use bizHd\stat\classes\StatVisitMonthClass;
use Yii;
use yii\console\Controller;

class InitController extends Controller
{

    //执行供货商资产中央化 ./yii init/ghs-center
    // shish 20220313
    public function actionGhsCenter()
    {

        //批发
        $shopList = ShopClass::getAllByCondition(['ptStyle' => 2], null, '*', null, true);
        if (empty($shopList)) {
            return false;
        }
        foreach ($shopList as $shop) {
            $mainId = $shop->mainId ?? 0;
            if (empty($mainId)) {
                $main = MainClass::add(['id' => null], true);
                $mainId = $main->id ?? 0;
                if (empty($mainId)) {
                    echo "mainId没有生成 \n";
                    exit();
                }
                $shop->mainId = $mainId;
                $shop->save();
            }

            $shopId = $shop->id ?? 0;

            StatSaleClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatSaleMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatUserClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatUserMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatVisitClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatVisitMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatOutClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatOutMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            PtYeChangeClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            ShopYeChangeClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            CashClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            ShopCapitalClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            RechargeClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatYjClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatYjMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            ShopAdminClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatOrderClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatOrderMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            StatOrderCountClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            //采购统计的中央化
            StatCgClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatCgMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatCgGhsClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            StatCgGhsMonthClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);


            /********琦海 start ************/

            //报损中央化
            StockWastageOrderClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            $wastageList = StockWastageOrderClass::getAllByCondition(['mainId' => $mainId], null, '*', null, true);
            if (!empty($wastageList)) {
                foreach ($wastageList as $wastage) {
                    $wastageOrderSn = $wastage->orderSn ?? 0;
                    StockWastageOrderItemClass::updateByCondition(['orderSn' => $wastageOrderSn], ['mainId' => $mainId]);
                }
            }


            //花材中央化
            ItemClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);
            //花材分类
            ItemClassClass::updateByCondition(['sjId' => $shop->sjId], ['mainId' => $mainId]);


            /********琦海 end ************/


        }

        //零售
        $shopList = ShopClass::getAllByCondition(['ptStyle' => 1], null, '*', null, true);
        if (empty($shopList)) {
            return false;
        }
        foreach ($shopList as $shop) {
            $mainId = $shop->mainId ?? 0;
            if (empty($mainId)) {
                $main = MainClass::add(['id' => null], true);
                $mainId = $main->id ?? 0;
                if (empty($mainId)) {
                    echo "mainId没有生成 \n";
                    exit();
                }
                $shop->mainId = $mainId;
                $shop->save();
            }

            $sjId = $shop->sjId ?? 0;
            $shopId = $shop->id ?? 0;
            GoodsClass::updateByCondition(['sjId' => $sjId], ['mainId' => $mainId]);
            GoodsCategoryClass::updateByCondition(['sjId' => $sjId], ['mainId' => $mainId]);

            CategoryClass::updateByCondition(['sjId' => $sjId], ['mainId' => $mainId]);

            /********琦海 start ************/

            //花材中央化
            ItemClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);


            /********琦海 end ************/

        }

    }

}