Example #1
0
 /**
  * 点击率统计
  */
 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();
     }
 }
Example #2
0
 /**
  * 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));
         //无数据返回出错
     }
 }