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']]]; } //惠雅鲜花员工不能看利润表 $shopAdmin = $this->shopAdmin; $adminId = $shopAdmin->adminId ?? 0; if (in_array($adminId, [3405, 2812, 4004,2812])) { util::fail('暂无权限'); } //开单 $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); } }