huahuibao/app-ghs/controllers/StatController.php

<?php

namespace ghs\controllers;

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

class StatController extends BaseController
{

    //利润表 shish 20210829
    public function actionProfit()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['shopId'] = $this->shopId;
        if (isset($get['shopId']) && !empty($get['shopId'])) {
            $where['shopId'] = $get['shopId'];
        }
        $selectTime = $get['selectTime'] ?? '';
        if (!empty($selectTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($selectTime, $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);

        $balance = ($sale * 100 + $stockOut * 100 + $pdAdd * 100 - $cg * 100 - $wast * 100 - $stockIn * 100 - $pdSub * 100 - $refund * 100) / 100;

        $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()
    {
        $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);
    }

}