huahuibao/app-hd/controllers/StatController.php

<?php

namespace hd\controllers;

use biz\stat\classes\StatCgClass;
use biz\stat\classes\StatRefundClass;
use biz\stat\classes\StatSaleClass;
use biz\stat\classes\StatStockInClass;
use biz\stat\classes\StatStockOutClass;
use common\components\dateUtil;
use Yii;
use common\components\util;

class StatController extends BaseController
{

    //利润表 ssh 20210829
    public function actionProfit()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $this->mainId;
        $searchTime = $get['searchTime'] ?? 'today';
        if (!empty($searchTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
            $where['time'] = ['between', [$period['startTime'], $period['endTime']]];
        }

        //开单
        $sale = StatSaleClass::getSum($where);

        //调拨出库
        $stockOut = StatStockOutClass::getSum($where);
        //盘盈
        //$pdAdd = StatPdAddClass::getSum($where);

        //采购入库
        $cg = StatCgClass::getSum($where);
        //报损
        //$wast = StatWastClass::getSum($where);
        //调拨入库
        $stockIn = StatStockInClass::getSum($where);
        //盘亏
        //$pdSub = StatPdSubClass::getSum($where);
        //退款
        $refund = StatRefundClass::getSum($where);

        $in = $sale;
        $in = bcadd($in, $stockOut, 2);
        //$in = bcadd($in, $pdAdd, 2);
        $out = $cg;
        //$out = bcadd($out, $wast, 2);
        $out = bcadd($out, $stockIn, 2);
        //$out = bcadd($out, $pdSub, 2);
        $out = bcadd($out, $refund, 2);
        $balance = bcsub($in, $out, 2);

        $out = [
            'income' => [
                ['name' => '销售', 'amount' => $sale],
                ['name' => '调拨出库', 'amount' => $stockOut],
                //['name' => '盘盈', 'amount' => $pdAdd],
            ],
            'expend' => [
                ['name' => '采购', 'amount' => $cg],
                //['name' => '报损', 'amount' => $wast],
                ['name' => '调拨入库', 'amount' => $stockIn],
                //['name' => '盘亏', 'amount' => $pdSub],
                ['name' => '退款', 'amount' => $refund],
            ],
            'balance' => $balance,
        ];

        util::success($out);

    }

    //统计列表 ssh 2020.1.5
    public function actionList()
    {
        $type = Yii::$app->request->get('type', 1);
        $incomeStat = [
            'total' => (185 + 381 + 662 + 443),
            'list' => [
                ['name' => '2.6', 'num' => 185],
                ['name' => '2.7', 'num' => 381],
                ['name' => '2.8', 'num' => 662],
                ['name' => '2.9', 'num' => 443],
            ],
        ];
        $visitStat = [
            'total' => (115 + 341 + 622 + 423),
            'list' => [
                ['name' => '2.6', 'num' => 115],
                ['name' => '2.7', 'num' => 341],
                ['name' => '2.8', 'num' => 622],
                ['name' => '2.9', 'num' => 423],
            ],
        ];
        $userStat = [
            'total' => (185 + 341 + 622 + 423),
            'list' => [
                ['name' => '2.6', 'num' => 185],
                ['name' => '2.7', 'num' => 341],
                ['name' => '2.8', 'num' => 622],
                ['name' => '2.9', 'num' => 423],
            ],
        ];
        $fansStat = [
            'total' => (185 + 241 + 322 + 553),
            'list' => [
                ['name' => '2.6', 'num' => 185],
                ['name' => '2.7', 'num' => 241],
                ['name' => '2.8', 'num' => 322],
                ['name' => '2.9', 'num' => 553],
            ],
        ];
        $incomeSourceStat = [
            'total' => (299 + 366 + 2995),
            'list' => [
                ['name' => '门店', 'num' => 299],
                ['name' => '微信朋友圈', 'num' => 366],
                ['name' => '美团', 'num' => 2995],
            ],
        ];
        $categoryStat = [
            'total' => (552 + 155 + 295 + 365 + 600 + 504),
            'list' => [
                ['name' => '花束', 'num' => 552],
                ['name' => '花篮', 'num' => 155],
                ['name' => '蝴蝶兰', 'num' => 295],
                ['name' => '绿植', 'num' => 365],
                ['name' => '永生花', 'num' => 600],
                ['name' => '散花', 'num' => 504],
            ],
        ];
        $useStat = [
            'total' => (552 + 155 + 295 + 365 + 600 + 504),
            'list' => [
                ['name' => '年销花', 'num' => 552],
                ['name' => '送爱人', 'num' => 155],
                ['name' => '婚庆', 'num' => 295],
                ['name' => '开业', 'num' => 365],
                ['name' => '送母亲', 'num' => 600],
                ['name' => '生日', 'num' => 504],
            ]
        ];
        $data = ['incomeStat' => $incomeStat,
            'visitStat' => $visitStat,
            'userStat' => $userStat,
            'fansStat' => $fansStat,
            'incomeSourceStat' => $incomeSourceStat,
            'categoryStat' => $categoryStat,
            'useStat' => $useStat,
        ];
        util::success($data);
    }

}