huahuibao/console/controllers/GlobalController.php

<?php

namespace console\controllers;

use biz\ghs\classes\GhsClass;
use biz\market\classes\TjFlClass;
use biz\shop\classes\ShopClass;
use biz\sj\classes\SjClass;
use biz\stat\classes\StatItemClass;
use bizGhs\custom\classes\CustomClass;
use bizGhs\custom\services\CustomService;
use bizGhs\order\classes\OrderClass;
use bizGhs\order\classes\OrderItemClass;
use bizGhs\product\classes\ProductClass;
use bizHd\stat\classes\StatVisitClass;
use common\components\dict;
use Yii;
use yii\console\Controller;

/**
 * 全局脚本
 */
class GlobalController extends Controller
{

    // ./yii global/run
    public function actionRun()
    {

        //库存预警每天下午3点通知一次
        $hour = date("Hi");
        if ($hour == '1500') {
            ProductClass::allShopStockWarningFromQueue();
        }

        //if ((int)date('i') % 30 == 0) {
            //不知道为什么线上付的结账单，老是会被取消，要恢复回来！！！！！！！！！！！！！！！！！！！！
            $sql = "update xhClear set status=2 where status=3 and thirdNo!=''";
            Yii::$app->db->createCommand($sql)->execute();
        //}

        //if ($hour == '0030') {
            //惠雅鲜花 花样年华 显示库存
            $sql = "UPDATE xhGhsCustom SET showStock=1 WHERE ownShopId IN (520,1489,1585,1596);";
            Yii::$app->db->createCommand($sql)->execute();
            $sql = "update xhGhs set showStock=1 where shopId in (520,1489,1585,1596);";
            Yii::$app->db->createCommand($sql)->execute();
        //}

        //每3分钟进行已完成支付订单处理：花材销量统计
        if ((int)date('i') % 3 == 0) {

            $ghs = dict::getDict('ptStyle', 'ghs');
            $shopList = ShopClass::getAllByCondition(['ptStyle' => $ghs], null, '*', null, true);
            if (!empty($shopList)) {
                foreach ($shopList as $key => $shop) {
                    $ids = [];
                    $shopId = $shop->id ?? 0;
                    $newOrderKey = 'ghsNewOrder_' . $shopId;
                    while ($count = Yii::$app->redis->executeCommand('LLEN', [$newOrderKey])) {
                        $id = Yii::$app->redis->executeCommand('RPOP', [$newOrderKey]);
                        if (is_numeric($id)) {
                            $ids[] = $id;
                        }
                    }
                    if (empty($ids)) {
                        continue;
                    }
                    $list = OrderClass::getAllByCondition(['id' => ['in', $ids]], null, '*', null, true);
                    if (empty($list)) {
                        continue;
                    }
                    foreach ($list as $key => $order) {
                        $orderSn = $order->orderSn ?? '';
                        if (empty($orderSn)) {
                            continue;
                        }
                        $itemList = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
                        if (empty($itemList)) {
                            continue;
                        }
                        //花材销量统计
                        foreach ($itemList as $itemKey => $itemVal) {
                            $mainId = $itemVal->mainId ?? 0;
                            $itemId = $itemVal->productId ?? 0;
                            $num = $itemVal->num ?? 0;
                            $price = $itemVal->price ?? 0;
                            $params = [
                                'mainId' => $mainId,
                                'itemId' => $itemId,
                                'price' => $price,
                                'num' => $num,
                            ];
                            StatItemClass::replace($params);
                        }
                    }
                }
            }

        }

        //每天凌晨00:10保存昨天访客数
        if ($hour == '0010') {
            $shopList = ShopClass::getAllByCondition(['ptStyle' => 2], null, '*', null, true);
            if (!empty($shopList)) {
                foreach ($shopList as $shop) {
                    //昨天
                    $date = date("Ymd", strtotime("-1 day"));
                    //今天
                    //$date = date("Ymd");
                    $visitNum = StatVisitClass::getVisitNum($shop, $date);
                    $currentNum = bcadd($shop->totalVisit, $visitNum, 2);
                    $shop->totalVisit = $currentNum;
                    $shop->save();

                    StatVisitClass::saveVisit($shop, $visitNum, $date);
                }
            }
        }

    }

}