/** * 点击率统计 */ public function actionRatio() { $gameTypes = $this->_getGlobalData('game_type'); $gameTypes = Model::getTtwoArrConvertOneArr($gameTypes, 'Id', 'name'); $sources = $this->_getGlobalData('workorder_source'); $lang = $this->_getGlobalData('lang'); $statsType = array('day' => '按天', 'hour' => '按小时'); $selected = array(); //统计数组 $selected['stats_type'] = $_POST['stats_type'] ? $_POST['stats_type'] : 'day'; //统计类型默认天 $selected['game_type_id'] = $_POST['game_type_id']; $selected['source'] = $_POST['source']; $selected['start_time'] = $_POST['start_time']; $selected['end_time'] = $_POST['end_time']; $selected['lang_id'] = $_POST['lang_id']; if ($this->_isPost()) { $this->_modelPlayerKindFaq = $this->_getGlobalData('Model_PlayerKindFaq', 'object'); $kindList = $this->_modelPlayerKindFaq->findListAll($_POST['game_type_id'], $_POST['lang_id']); $this->_modelStatsFaq = $this->_getGlobalData('Model_StatsFaq', 'object'); if (empty($_POST['start_time']) || empty($_POST['end_time'])) { $this->_utilMsg->showMsg('请选择开始时间与结束时间', -1, 2); } if ($_POST['stats_type'] == 'day') { //按天 $this->_view->assign('allDay', Tools::getdateArr($_POST['start_time'], $_POST['end_time'])); $stats = $this->_modelStatsFaq->statsDay(array('start_time' => $_POST['start_time'], 'end_time' => $_POST['end_time']), $_POST['game_type_id'], $_POST['source'], $_POST['lang_id']); } else { //按小时 $this->_view->assign('allHour', range(0, 23)); $stats = $this->_modelStatsFaq->statsHour(array('start_time' => $_POST['start_time'], 'end_time' => $_POST['end_time']), $_POST['game_type_id'], $_POST['source'], $_POST['lang_id']); } } else { $selected["start_time"] = date("Y-m-d", time()) . " 00:00:00"; $selected["end_time"] = date("Y-m-d", time()) . " 23:59:59"; } $this->_view->assign('kindList', $kindList); $this->_view->assign('dataList', $stats); $gameTypes[''] = '所有'; $sources[''] = '所有'; $lang[''] = '所有'; $this->_view->assign('selected', $selected); $this->_view->assign('statsType', $statsType); $this->_view->assign('gameTypes', $gameTypes); $this->_view->assign('sources', $sources); $this->_view->assign('lang', $lang); $this->_utilMsg->createPackageNavBar(); if ($_POST['xls']) { //导出excel Tools::import('Util_ExportExcel'); $this->_utilExportExcel = new Util_ExportExcel('faq统计', 'Excel/StatsFaq', $stats); $this->_utilExportExcel->outPutExcel(); } else { $this->_view->display(); } }
/** * faq详细 */ public function actionDetail() { $id = abs(intval($_GET['id'])); $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $data = $this->_modelPlayerFaq->findById($id); $data['answer'] = $data['answer_g']; unset($data['answer_g'], $data['answer_s']); if (empty($data['answer'])) { unset($data['answer']); } if ($data) { $this->_modelStatsFaq = $this->_getGlobalData('Model_StatsFaq', 'object'); $statArr = array('game_type_id' => $data['game_type_id'], 'source' => 2, 'kind_id' => $data['kind_id'], 'lang_id' => $data['lang_id']); $this->_modelStatsFaq->add($statArr); //增加统计量 $this->_modelPlayerFaq->execute("update {$this->_modelPlayerFaq->tName()} set `ratio`=ratio+1 where Id={$id}"); //增加点击率 $this->_returnAjaxJson(array('status' => 1, 'info' => 'InterfaceFaq_Detail', 'data' => $data)); } else { $this->_returnAjaxJson(array('status' => 0, 'info' => 'NO_FIND', 'data' => null)); //无数据返回出错 } }