huahuibao/console/controllers/TestController.php

<?php

namespace console\controllers;

use biz\cp\classes\PtCpItemClass;
use biz\item\classes\PtItemCatRelateClass;
use biz\item\classes\PtItemClass;
use biz\main\classes\MainClass;
use biz\shop\classes\ShopClass;
use biz\sj\classes\SjClass;
use bizGhs\item\classes\ItemClass;
use bizGhs\item\classes\ItemClassClass;
use bizGhs\order\classes\OrderItemClass;
use bizGhs\order\classes\PurchaseOrderItemClass;
use bizGhs\product\classes\ProductClass;
use bizHd\custom\classes\CustomClass;
use bizHd\ghs\classes\GhsClass;
use bizHd\order\classes\OrderClass;
use common\components\stringUtil;
use common\components\util;
use Yii;
use yii\console\Controller;

class TestController extends Controller
{

    //更新时间
    public function actionExpendTime()
    {
        $sql = "UPDATE xhGhsCustom SET recentExpend='2024-02-01 01:01:00'";
        Yii::$app->db->createCommand($sql)->execute();
        $sql = "UPDATE xhGhs SET recentExpend='2024-02-01 01:01:00'";
        Yii::$app->db->createCommand($sql)->execute();
        $list = \bizGhs\order\classes\OrderClass::getAllByCondition(['payTime>' => '2024-04-01 23:35:00'], null, '*', 'payTime asc', true);
        if (!empty($list)) {
            foreach ($list as $info) {
                $customId = $info->customId ?? 0;
                $ghsId = $info->ghsId ?? 0;
                $custom = \bizGhs\custom\classes\CustomClass::getById($customId, true);
                $payTime = $info->payTime;
                $orderSn = $info->orderSn ?? '';
                if (!empty($custom)) {
                    $custom->recentExpend = $payTime;
                    $custom->save();
                    echo $orderSn . ' ' . $payTime . " custom {$custom->id} ok \n";
                }
                $ghs = \bizGhs\ghs\classes\GhsClass::getById($ghsId, true);
                if (!empty($ghs)) {
                    $ghs->recentExpend = $payTime;
                    $ghs->save();
                    echo $orderSn . ' ' . $payTime . " ghs {$ghs->id} ok \n";
                }
            }
        }
    }

    public function actionBelong()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $shopList = ShopClass::getAllByCondition(['id' => ['in', [23580, 11094, 520, 1489, 8596, 4608, 7855, 21486, 1585, 10649, 10768, 8249, 447, 763, 1421]]], null, '*', null, true);
        if (!empty($shopList)) {
            foreach ($shopList as $shop) {
                $mainId = $shop->mainId ?? 0;
                $list = ItemClassClass::getAllByCondition(['mainId' => $mainId], null, '*', null, true);
                if (!empty($list)) {
                    foreach ($list as $class) {
                        $classId = $class->id ?? 0;
                        $productList = ProductClass::getAllByCondition(['classId' => $classId], null, '*');
                        if (!empty($productList)) {
                            $ids = array_column($productList, 'id');
                            if (!empty($ids)) {
                                $o = OrderItemClass::getAllByCondition(['productId' => ['in', $ids]], null, '*', null, true);
                                if (!empty($o)) {
                                    echo "销售单\n";
                                    foreach ($o as $oa) {
                                        $oa->classId = $classId;
                                        $oa->save();
                                    }
                                }
                                $i = \bizHd\order\classes\OrderItemClass::getAllByCondition(['itemId' => ['in', $ids]], null, '*', null, true);
                                if (!empty($i)) {
                                    echo "花店单\n";
                                    foreach ($i as $ia) {
                                        $ia->classId = $classId;
                                        $ia->save();
                                    }
                                }
                                $n = PurchaseOrderItemClass::getAllByCondition(['productId' => ['in', $ids]], null, '*', null, true);
                                if (!empty($n)) {
                                    echo "采购单\n";
                                    foreach ($n as $na) {
                                        $na->classId = $classId;
                                        $na->save();
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }

    public function actionHdCustom()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);
        $customList = CustomClass::getAllByCondition(['id>' => 0], null, '*', null, true);
        if (!empty($customList)) {
            foreach ($customList as $custom) {
                $mobile = $custom->mobile;
                $custom->originName = $mobile;
                $custom->name = $mobile;
                $custom->py = $mobile;
                $custom->save();
                OrderClass::updateByCondition(['customId' => $custom->id], ['customName' => $mobile, 'customNamePy' => $mobile]);
            }
        }
    }

    //老油花材单位比修改 ssh 20240411
    public function actionLy()
    {
        if (getenv('YII_ENV') == 'production') {
            $mainId = 20528;
        } else {
            $mainId = 644;
        }
        $list = ItemClass::getAllByCondition(['mainId' => $mainId, 'delStatus' => 0], null, '*', null, true);
        if (!empty($list)) {
            foreach ($list as $item) {
                $name = $item->name ?? '';
                $has = false;
                if (strstr($name, '100支') != false) {
                    $ptItemId = $item->itemId ?? 0;
                    $ptItem = PtItemClass::getById($ptItemId, true);
                    if (!empty($ptItem)) {
                        $item->ratio = 100;
                        $item->smallUnit = '支';
                        $item->smallUnitId = 2;
                        $item->save();
                        $ptItem->ratio = 100;
                        $ptItem->smallUnit = '支';
                        $ptItem->smallUnitId = 2;
                        $ptItem->save();
                        $has = true;
                    }
                }

                if (strstr($name, '200支') != false) {
                    $ptItemId = $item->itemId ?? 0;
                    $ptItem = PtItemClass::getById($ptItemId, true);
                    if (!empty($ptItem)) {
                        $item->ratio = 200;
                        $item->smallUnit = '支';
                        $item->smallUnitId = 2;
                        $item->save();
                        $ptItem->ratio = 200;
                        $ptItem->smallUnit = '支';
                        $ptItem->smallUnitId = 2;
                        $ptItem->save();
                        $has = true;
                    }
                }
                if ($has) {
                    echo $name . "\n";
                }
            }
        }
    }

    public function actionItem()
    {
        $list = PtItemCatRelateClass::getAllByCondition(['id>' => 0], 'id asc', '*', null, true);
        if (!empty($list)) {
            foreach ($list as $item) {
                $ptItemId = $item->itemId ?? 0;
                $ptItem = PtItemClass::getById($ptItemId, true);
                echo $ptItem->name . "\n";
            }
        }
    }

    public function actionCp()
    {
        $list = PtCpItemClass::getAllByCondition(['id>' => 0], 'id asc', '*', null, true);
        foreach ($list as $cp) {
            $ptItemId = $cp->itemId ?? 0;
            $ptItem = PtItemClass::getById($ptItemId, true);
            $ptItem->hasCpId = 1;
            $ptItem->save();
        }
    }

}