huahuibao/app-ghs/controllers/ConsoleController.php

<?php

namespace ghs\controllers;

use biz\stat\classes\StatSaleClass;
use biz\stat\services\StatOutService;
use bizGhs\clear\classes\ClearClass;
use bizGhs\order\classes\OrderClass;
use bizHd\order\classes\OrderClass as HdOrderClass;
use bizHd\stat\classes\StatVisitClass;
use common\components\dict;
use common\components\util;
use Yii;

class ConsoleController extends BaseController
{

    public $guestAccess = ['init', 'profile'];

    //今日实收统计和欠款统计等
    public function actionStat()
    {
        $todayDate = date('Y-m-d');
        $todayStartTime = $todayDate . ' 00:00:00';
        $todayEndTime = $todayDate . ' 23:59:59';
        $where = ['shopId' => $this->shopId, 'debt' => 0, 'debtPrice' => '0.00'];
        $where['status'] = ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]];
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $todayActIncome = OrderClass::sum($where, 'actPrice'); // 今日实收
        $todayActIncome = $todayActIncome === null ? 0 : $todayActIncome;

        $where = ['shopId' => $this->shopId, 'debt' => 1]; // 查询条件重新赋值
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $todayDebt = OrderClass::sum($where, 'remainDebtPrice'); // 今日欠款
        $todayDebt = $todayDebt === null ? 0 : $todayDebt;

        $where = ['shopId' => $this->shopId, 'debt' => 1]; // 重新赋值
        $totalDebt = OrderClass::sum($where, 'remainDebtPrice'); // 总欠款
        $totalDebt = $totalDebt === null ? 0 : $totalDebt;

        util::success(['todayActIncome' => $todayActIncome, 'todayDebt' => $todayDebt, 'totalDebt' => $totalDebt]);
    }

    //今日笔数和总金额
    public function actionStrokeCount()
    {
        $todayDate = date('Y-m-d');
        $todayStartTime = $todayDate . ' 00:00:00';
        $todayEndTime = $todayDate . ' 23:59:59';

        //线上收入 180笔  12000元
        //xhGhsOrder actPrice 字段，条件：debtPrice=0 and status in (2,3,4)  and payWay in (0,1)
        //xhOrder    actPrice 字段，条件 status in (2,3,4)  and payWay in (0,1)
        $where = ['shopId' => $this->shopId, 'debt' => 0, 'debtPrice' => '0.00'];
        $where['status'] = ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]];
        $where['payWay'] = ['in', [0, 1]];
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $ghsOnlineCount = OrderClass::getCount($where); // 批发今日收入总笔数
        $ghsActIncome = OrderClass::sum($where, 'actPrice'); // 批发今日实收总数
        Yii::info('批发今日收入总笔数:' . $ghsOnlineCount . ', 批发今日实收总数:' . $ghsActIncome);

        $where['shopId'] = $this->shop['lsShopId'];
        $where['onlinePay'] = 2; // 花店 xhOrder 表的 onlinePay 字段是指：钱是否进入公司的帐户 --  1不是 2是
        unset($where['debt']);
        unset($where['debtPrice']);
        $hdActualCount = HdOrderClass::getCount($where); // 花店今日收入总笔数
        $hdActualIncome = HdOrderClass::sum($where, 'actPrice'); // 花店今日收入金额总数
        Yii::info('花店今日收入总笔数:' . $hdActualCount . ', 花店今日收入金额总数:' . $hdActualIncome);
        $systemCount = $ghsOnlineCount + $hdActualCount;
        $systemIncome = floatval(bcadd($ghsActIncome, $hdActualIncome, 2)); // 扫码收入

        //现金收入 23笔  5980元
        //xhGhsOrder actPrice 字段，条件：debtPrice=0 and status in (2,3,4)  and payWay=4
        //xhOrder    actPrice 字段，条件 status in (2,3,4)  and payWay=4
        $where = ['shopId' => $this->shopId, 'debt' => 0, 'debtPrice' => '0.00'];
        $where['status'] = ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]];
        $where['payWay'] = 4;
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $ghsCashCount = OrderClass::getCount($where); // 批发今日现金总笔数
        $ghsCashIncome = OrderClass::sum($where, 'actPrice'); // 批发今日现金金额总数
        Yii::info('批发今日现金总笔数:' . $ghsCashCount . ', 批发今日现金金额总数:' . $ghsCashIncome);

        $where['shopId'] = $this->shop['lsShopId'];
        unset($where['debt']);
        unset($where['debtPrice']);
        $hdCashCount = HdOrderClass::getCount($where); // 花店今日现金总笔数
        $hdCashIncome = HdOrderClass::sum($where, 'actPrice'); // 花店今日现金金额总数
        Yii::info('花店今日现金总笔数:' . $hdCashCount . ', 花店今日现金金额总数:' . $hdCashIncome);
        $cashCount = $ghsCashCount + $hdCashCount;
        $cashIncome = floatval(bcadd($ghsCashIncome, $hdCashIncome, 2)); // 现金收入

        //批发欠款 39笔 13980元
        $where = ['shopId' => $this->shopId, 'debt' => 1];
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $debtCount = OrderClass::getCount($where); // 批发今日欠款总笔数
        $debtAmount = OrderClass::sum($where, 'remainDebtPrice'); // 欠款 // 批发今日总欠款
        $debtAmount = floatval($debtAmount);

        //结帐收入
        $where = ['ghsShopId' => $this->shopId];
        $where['status'] = 2;
        $where['onlinePay'] = 2;
        $where['addTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $clearCount = ClearClass::getCount($where);
        $clearIncome = ClearClass::sum($where, 'actPrice');
        $clearIncome = empty($clearIncome) ? 0 : floatval($clearIncome);

        $actTotalCount = $cashCount + $systemCount + $clearCount;
        $actTotalIncome = bcadd($cashIncome, $systemIncome, 2);
        $actTotalIncome = floatval(bcadd($actTotalIncome, $clearIncome, 2)); // 收入合计 = 扫码收入 + 现金收入 + 结帐收入

        util::success([
            'systemCount' => $systemCount,
            'systemIncome' => $systemIncome, // 扫码收入
            'cashCount' => $cashCount,
            'cashIncome' => $cashIncome, // 现金收入
            'clearCount' => $clearCount,
            'clearIncome' => $clearIncome, // 结帐收入
            'actTotalCount' => $actTotalCount,
            'actTotalIncome' => $actTotalIncome, // 收入合计
            'debtCount' => $debtCount,
            'debtAmount' => $debtAmount, // 欠款
        ]);
    }

    //概况 ssh 2019.12.19
    public function actionProfile()
    {
        $get = Yii::$app->request->get();
        $isMini = $get['isMini'] ?? 0;
        $notice = [];
        $admin = $this->admin;
        if ($isMini == 1 && !empty($admin)) {
            $miniOpenId = $admin['ghsMiniOpenId'] ?? '';
            if (empty($miniOpenId)) {
                $notice = [['title' => '绑定微信，下次自动登录后台', 'action' => '去绑定', 'page' => '/admin/staff/miniAutoLogin']];
            }
        }

        //今天销售
        $sale = StatSaleClass::getByCondition(['mainId' => $this->mainId, 'time' => date('Ymd')]);
        $todaySale = $sale['amount'] ?? 0;
        $orderNum = $sale['num'] ?? 0;

        //2021.4.14 lqh 今日支出
        $outData = StatOutService::getTodayNum($this->mainId);
        $todayOut = $outData['amount'] ?? '0.00';

        //访客数
        $visitCustom = StatVisitClass::getVisitNum($this->mainId);

        $todayData = ['income' => $todaySale, 'order' => $orderNum, 'expend' => $todayOut, 'visitCustom' => $visitCustom];

        $incomeStat = [];

        $menu = [
            ["name" => "商城", "img" => "ghs/home/shop.png", "url" => "/admin/home/mall"],
            ["name" => "改价", "img" => "ghs/home/gj.png", "url" => "/admin/changePrice/list"],
            ["name" => "花材", "img" => "ghs/home/hcgl.png", "url" => "/admin/item/list"],
            ["name" => "供应商", "img" => "ghs/home/icon_ghs.png", "url" => "/pagesPurchase/supplier"],
            ["name" => "采购单", "img" => "ghs/home/icon_caigou.png", "url" => "/pagesPurchase/order"],
            ["name" => "报损单", "img" => "ghs/home/kcyjs.png", "url" => "/admin/breakage/list"],
            ["name" => "预订单", "img" => "ghs/home/kcyjs.png", "url" => "/admin/order/statBook"],
            ["name" => "新增出库", "img" => "ghs/home/dbck.png", "url" => "/admin/shop/selectShop"],
            ["name" => "出库记录", "img" => "ghs/home/dbck.png", "url" => "/pagesStorehouse/allot/allotEx"],
            ["name" => "入库记录", "img" => "ghs/home/dbrk.png", "url" => "/pagesStorehouse/allot/allotPut"],
            ["name" => "销售结账单", "img" => "ghs/home/kcyjs.png", "url" => "/admin/clear/customList"],
            ["name" => "支出登记", "img" => "ghs/home/kcyjs.png", "url" => "/admin/expend/addExpend"],
        ];

        util::success(['asset' => $this->main, 'notice' => $notice, 'todayData' => $todayData, 'incomeStat' => $incomeStat, 'menu' => $menu,]);
    }

    //常用初始化
    public function actionInit()
    {
        $dict = dict::get();
        $shop = isset($this->shop) && !empty($this->shop) ? $this->shop->attributes : [];
        util::success(['dict' => $dict, 'shop' => $shop]);
    }

}