request); $where['date'] = $this->request->param('date'); $where['data'] = $this->request->param('data'); $where['export'] = $this->request->param('export'); $trans = StatisticsModel::trans();//最近交易 $seckill = StatisticsModel::getSeckill($where);//秒杀商品 $ordinary = StatisticsModel::getOrdinary($where);//普通商品 $pink = StatisticsModel::getPink($where);//拼团商品 $recharge = StatisticsModel::getRecharge($where);//充值 $extension = StatisticsModel::getExtension($where);//推广金 $orderCount = [ urlencode('微信支付') => StatisticsModel::getTimeWhere($where, StatisticsModel::statusByWhere('weixin'))->count(), urlencode('余额支付') => StatisticsModel::getTimeWhere($where, StatisticsModel::statusByWhere('yue'))->count(), urlencode('线下支付') => StatisticsModel::getTimeWhere($where, StatisticsModel::statusByWhere('offline'))->count(), ]; $Statistic = [ ['name' => '营业额', 'type' => 'line', 'data' => []], ['name' => '支出', 'type' => 'line', 'data' => []], ['name' => '盈利', 'type' => 'line', 'data' => []], ]; $orderinfos = StatisticsModel::getOrderInfo($where); $orderinfo = $orderinfos['orderinfo']; $orderDays = []; if (empty($orderinfo)) { $orderDays[] = date('Y-m-d', time()); $Statistic[0]['data'][] = 0; $Statistic[1]['data'][] = 0; $Statistic[2]['data'][] = 0; } foreach ($orderinfo as $info) { $orderDays[] = $info['pay_time']; $Statistic[0]['data'][] = $info['total_price'] + $info['pay_postage']; $Statistic[1]['data'][] = $info['coupon_price'] + $info['deduction_price'] + $info['cost']; $Statistic[2]['data'][] = ($info['total_price'] + $info['pay_postage']) - ($info['coupon_price'] + $info['deduction_price'] + $info['cost']); } $price = $orderinfos['price'] + $orderinfos['postage']; $cost = $orderinfos['deduction'] + $orderinfos['coupon'] + $orderinfos['cost']; $Consumption = StatisticsModel::getConsumption($where)['number']; $header = [ ['name' => '总营业额', 'class' => 'fa-line-chart', 'value' => '¥' . $price, 'color' => 'red'], ['name' => '总支出', 'class' => 'fa-area-chart', 'value' => '¥' . ($cost + $extension), 'color' => 'lazur'], ['name' => '总盈利', 'class' => 'fa-bar-chart', 'value' => '¥' . bcsub($price, $cost, 0), 'color' => 'navy'], ['name' => '新增消费', 'class' => 'fa-pie-chart', 'value' => '¥' . ($Consumption == 0 ? 0 : $Consumption), 'color' => 'yellow'] ]; $data = [ ['value' => $orderinfos['cost'], 'name' => '商品成本'], ['value' => $orderinfos['coupon'], 'name' => '优惠券抵扣'], ['value' => $orderinfos['deduction'], 'name' => '积分抵扣'], ['value' => $extension, 'name' => '推广人佣金'] ]; $this->assign(StatisticsModel::systemTable($where)); $this->assign(compact('where', 'trans', 'orderCount', 'orderDays', 'header', 'Statistic', 'ordinary', 'pink', 'recharge', 'data', 'seckill')); $this->assign('price', StatisticsModel::getOrderPrice($where)); return $this->fetch(); } }