request->isAjax && Yii::$app->request->isGet) { $where = [['=', 'mall_id', $this->mall_id]]; $select = ['sum(card_num) card_num', 'sum(browse_num) browse_num']; $allData = BusinessCardStatistics::getList($where, $select, 'mall_id'); $list['allData'] = $allData[0]; return $this->success('success', $list); } return $this->render('index'); } /** * 图表数据 * * @param int date 天数 defalut 7 * @author hpei * @return array */ public function actionChart() { $list = []; if (Yii::$app->request->isAjax && Yii::$app->request->isGet) { $date = Yii::$app->request->get('date'); $date = $date == '' ? 7 : $date; $start_time = strtotime("-$date day 0:0:0"); $start_time += 86400; $end_time = $start_time + ($date * 86400) - 1; $where = [['>=', 'created_at', $start_time], ['<=', 'created_at', $end_time], ['=', 'mall_id', $this->mall_id]]; $list = BusinessCardStatistics::getList($where, ['card_num', 'browse_num', 'created_at']); $data['date'] = []; $user_views = [];//浏览量 $card_num = [];//名片总数 //初始化统计 for ($i = $start_time; $i < $end_time; $i += 86400) { $data['date'][] = date('Y-m-d', $i); array_push($user_views, 0); array_push($card_num, 0); } if (!empty($list)) { foreach ($list as $val) { if (in_array(date('Y-m-d', $val['created_at']), $data['date'])) { $index = array_search(date('Y-m-d', $val['created_at']), $data['date']); $user_views[$index] += $val['browse_num']; $card_num[$index] += $val['card_num']; } } } $data['series'] = compact(['clue_num', 'user_views', 'card_num', 'order_num', 'order_money']); } return $this->success('操作成功', $data); } public function setData($users, $data, $s) { var_dump($data); } }