huahuibao/app-ghs/controllers/StatController.php

<?php

namespace ghs\controllers;

use bizGhs\order\classes\StockWastageOrderItemClass;
use bizGhs\stat\classes\StatSaleClass;
use common\components\imgUtil;
use Yii;
use common\components\util;
use common\components\dateUtil;

class StatController extends BaseController
{

    public function actionProfit()
    {
        $mainId = $this->mainId;
        $respond = StatSaleClass::profile($mainId);
        $income = $respond['income'] ?? 0;
        $expend = $respond['expend'] ?? 0;
        $balance = $respond['balance'] ?? 0;
        util::success(['income' => $income, 'expend' => $expend, 'balance' => floatval($balance)]);
    }

    public function actionWastage()
    {
        $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);
            $start = date("Y-m-d H:i:s", strtotime($period['startTime']));
            $end = date("Y-m-d H:i:s", strtotime($period['endTime']));
            $where['addTime'] = ['between', [$start, $end]];
        }
        $wastageList = StockWastageOrderItemClass::getAllByCondition($where, null, '*', null, true);
        $stat = [];
        if (!empty($wastageList)) {
            foreach ($wastageList as $waste) {
                $name = $waste->name ?? '';
                $shortCover = $waste->cover ?? '';
                $cover = imgUtil::groupImg($shortCover);
                $num = $waste->itemNum ?? 0;
                $productId = $waste->productId ?? 0;
                if (isset($stat[$productId]) == false) {
                    $stat[$productId]['name'] = $name;
                    $stat[$productId]['cover'] = $cover;
                    $stat[$productId]['num'] = 0;
                }
                $stat[$productId]['num'] = bcadd($stat[$productId]['num'], $num, 2);
            }
        }
        util::success(['stat' => $stat]);
    }

}