huahuibao/console/controllers/PtItemController.php

<?php

namespace console\controllers;

use biz\item\classes\PtItemCatClass;
use biz\item\classes\PtItemCatRelateClass;
use biz\item\classes\PtItemClass;
use biz\product\classes\ProductClass;
use bizGhs\item\classes\ItemClass;
use bizGhs\item\classes\ItemClassClass;
use yii\console\Controller;
use Yii;

class PtItemController extends Controller
{

    //认证
    public function actionAuthItem()
    {
        $relationList = PtItemCatRelateClass::getAllByCondition(['id>' => 0], null, '*', null, true);
        if (!empty($relationList)) {
            foreach ($relationList as $relation) {
                $itemId = $relation->itemId;
                PtItemClass::updateById($itemId, ['auth' => 1]);
            }
        }
    }

    //平台花材更新 ssh 20231125
    public function actionUseNum()
    {
        ini_set('memory_limit', '5045M');
        set_time_limit(0);
        $ptItemList = PtItemClass::getAllByCondition(['id>' => 0], null, '*', null, true);
        if (!empty($ptItemList)) {
            foreach ($ptItemList as $ptItem) {
                $ptItemId = $ptItem->id ?? 0;
                $count = ItemClass::getCount(['itemId' => $ptItemId]);
                $ptItem->useNum = $count;
                $ptItem->save();
            }
        }
    }

    // ./yii pt-item/init
    public function actionInit()
    {
        $sjId = 12715;
        $shopId = 36225;
        if (getenv('YII_ENV') == 'production') {
            $sjId = 12568;
            $shopId = 214;
        }
        $sql = 'TRUNCATE `xhPtItemCat`;TRUNCATE `xhPtItemCatRelate`;';
        Yii::$app->db->createCommand($sql)->execute();
        $classData = ItemClassClass::getAllByCondition(['sjId' => $sjId], null, '*', null, true);
        if (empty($classData)) {
            echo "没有找到分类";
            Yii::$app->end();
        }
        foreach ($classData as $key => $classInfo) {
            $classId = $classInfo->id ?? 0;
            $name = $classInfo->name ?? '';
            $inTurn = $classInfo->inTurn ?? 0;
            $params = [
                'name' => $name,
                'inTurn' => $inTurn,
            ];
            $productData = ProductClass::getAllByCondition(['shopId' => $shopId, 'classId' => $classId], null, '*', null, true);
            if (empty($productData)) {
                continue;
            }
            $ptClass = PtItemCatClass::add($params, true);
            $ptClassId = $ptClass->id ?? 0;
            if (empty($ptClassId)) {
                continue;
            }
            foreach ($productData as $product) {
                $itemId = $product->itemId ?? 0;
                $relateData = [
                    'catId' => $ptClassId,
                    'itemId' => $itemId,
                ];
                PtItemCatRelateClass::add($relateData);
            }
        }
    }

}