huahuibao/console/controllers/InitController.php

<?php

namespace console\controllers;

use biz\product\classes\XjClass;
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\StatRefundClass;
use biz\stat\classes\StatRefundMonthClass;
use biz\stat\classes\StatSaleClass;
use biz\stat\classes\StatSaleMonthClass;
use biz\stat\classes\StatStockInClass;
use biz\stat\classes\StatStockInMonthClass;
use biz\stat\classes\StatStockOutClass;
use biz\stat\classes\StatStockOutMonthClass;
use bizGhs\cg\classes\CgClass;
use bizGhs\custom\classes\CustomClass;
use bizGhs\item\classes\ItemClass;
use bizGhs\item\classes\ItemClassClass;
use bizGhs\order\classes\RefundOrderClass;
use bizGhs\order\classes\StockWastageOrderClass;
use bizGhs\order\classes\StockWastageOrderItemClass;
use bizGhs\stat\classes\StatYjClass;
use bizGhs\stat\classes\StatYjMonthClass;
use bizHd\ghs\classes\GhsClass;
use bizHd\goods\classes\CategoryClass;
use bizHd\goods\classes\GoodsCategoryClass;
use bizHd\goods\classes\GoodsClass;
use bizHd\goods\classes\GoodsSettingClass;
use bizHd\saas\classes\FestRiseClass;
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
    // ssh 20220313
    public function actionGhsCenter()
    {

        //欠款处理
//        $sql = 'UPDATE xhGhsOrder SET debtPrice=actPrice,remainDebtPrice=actPrice WHERE debt=1';
//        Yii::$app->db->createCommand($sql)->execute();
//        $sql ='UPDATE xhCg SET debtPrice=actPrice,remainDebtPrice=actPrice WHERE debt=1;';
//        Yii::$app->db->createCommand($sql)->execute();

        //批发
        $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]);

            RefundOrderClass::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]);

            CustomClass::updateByCondition(['ownShopId' => $shopId], ['ownMainId' => $mainId]);

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

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

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

            //ghs专有的
            CgClass::updateByCondition(['shopId' => $shopId], ['mainId' => $mainId]);

            XjClass::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]);
                }
            }

            //todo 分店需要建立自己独立的分类 和 花材与分类关系 --待测试
            //花材分类
//            $sjId = $shop->sjId;
//            if($mainId){
//                //判断花材分类是否存在
//                $itemClassResByMainId = ItemClassClass::getAllByCondition(['mainId'=>$mainId,'sjId'=>$sjId],null,"*");
//                if(empty($itemClassResByMainId)){
//                    //无，则要新增花材分类，根据sjId
//                    $itemClassResBySjId = ItemClassClass::getAllByCondition(['sjId'=>$sjId],null,"*");
//                    if($itemClassResBySjId){
//                        foreach ($itemClassResBySjId as $itemClass){
//                            $data = $itemClass;
//                            $oldItemClassId = $data['id'];
//                            unset($data['id']);
//                            unset($data['addTime']);
//                            unset($data['updateTime']);
//                            $data['mainId'] = $mainId;
//                            $save = ItemClassClass::add($data);
//                            $newItemClassId = $save['id'];
//                            ItemClass::updateByCondition(['shopId' => $shopId,'classId'=>$oldItemClassId], ['mainId' => $mainId,'classId'=>$newItemClassId]);
//                        }
//                    }
//                }
//            }


            /********琦海 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]);

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

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

            GhsClass::updateByCondition(['ownShopId' => $shopId], ['ownMainId' => $mainId]);


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

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

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

        }

    }

}