public function recount($kindId) { $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $count = $this->_modelPlayerFaq->findCount("kind_id={$kindId}"); parent::update(array('count' => $count), "Id={$kindId}"); return array('status' => 1, 'msg' => '更新计数器成功', 'href' => 1); }
/** * searchFAQ */ public function actionSearch() { $this->_loadCore('Help_SqlSearch'); $this->_helpSqlSearch = new Help_SqlSearch(); $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $gameTypeId = abs(intval($_REQUEST['game_id'])); $keyWords = $_REQUEST['keywords']; $page = abs(intval($_REQUEST['p'])); if (!$page) { $page = 1; } $pageSize = abs(intval($_REQUEST['ps'])); if (!$pageSize) { $pageSize = 8; } $this->_helpSqlSearch->set_tableName($this->_modelPlayerFaq->tName()); $this->_helpSqlSearch->set_field('Id,ratio,game_type_id,kind_id,question'); $this->_helpSqlSearch->set_conditions("game_type_id={$gameTypeId}"); $this->_helpSqlSearch->set_conditions("question like '%{$keyWords}%'"); $this->_helpSqlSearch->setPageLimit($page, $pageSize); $conditions = $this->_helpSqlSearch->get_conditions(); $sql = $this->_helpSqlSearch->createSql(); $dataList = $this->_modelPlayerFaq->select($sql); if (!$dataList) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'NO_FIND', 'data' => null)); } //无数据返回出错. $count = $this->_modelPlayerFaq->findCount($conditions); $toalPgae = ceil($count / $pageSize); $this->_returnAjaxJson(array('status' => 1, 'info' => null, 'data' => array('page' => array('total' => $count, 'total_page' => $toalPgae, 'page' => $page, 'page_size' => $pageSize), 'list' => $dataList))); }
/** * faq列表 */ public function actionList() { $this->_loadCore('Help_SqlSearch'); $this->_helpSqlSearch = new Help_SqlSearch(); $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $kindId = abs(intval($_GET['kind_id'])); $page = $_GET['page'] ? abs(intval($_GET['page'])) : abs(intval($_GET['p'])); if (!$page) { $page = 1; } $pageSize = abs(intval($_GET['ps'])); if (!$pageSize) { $pageSize = 8; } $this->_helpSqlSearch->set_tableName($this->_modelPlayerFaq->tName()); $this->_helpSqlSearch->set_field('Id,ratio,game_type_id,kind_id,question'); $this->_helpSqlSearch->set_conditions("kind_id={$kindId}"); $this->_helpSqlSearch->set_conditions('status!=1'); $this->_helpSqlSearch->setPageLimit($page, $pageSize); $sql = $this->_helpSqlSearch->createSql(); $dataList = $this->_modelPlayerFaq->select($sql); if (false === $dataList) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'NO_FIND', 'data' => null)); } //无数据返回出错. $count = $this->_modelPlayerFaq->findCount("kind_id={$kindId} and status!=1"); $toalPgae = ceil($count / $pageSize); $this->_returnAjaxJson(array('status' => 1, 'info' => 'InterfaceFaq_List', 'data' => array('page' => array('total' => $count, 'total_page' => $toalPgae, 'page' => $page, 'page_size' => $pageSize), 'list' => $dataList))); }
/** * 玩家faq管理 */ public function actionPlayerIndex() { switch ($_GET['doaction']) { case 'ratioedit': //编辑点击率 $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $data = $this->_modelPlayerFaq->ratioEdit($_POST); $this->_utilMsg->showMsg($data['msg'], $data['status'], $data['href']); break; case 'ratio': //点击率 $this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object'); $this->_loadCore('Help_SqlSearch'); $helpSqlSearch = new Help_SqlSearch(); $helpSqlSearch->set_tableName($this->_modelPlayerFaq->tName()); if ($_GET['game_type_id'] != '') { $helpSqlSearch->set_conditions("game_type_id={$_GET['game_type_id']}"); $this->_view->assign('selectedGameTypeId', $_GET['game_type_id']); } $conditions = $helpSqlSearch->get_conditions(); $helpSqlSearch->set_orderBy('ratio desc'); $helpSqlSearch->setPageLimit($_GET['page']); $sql = $helpSqlSearch->createSql(); $dataList = $this->_modelPlayerFaq->select($sql); if ($dataList) { foreach ($dataList as &$list) { $list['word_game_type_id'] = $this->_faqKind[$list['game_type_id']]; $list['question'] = strip_tags($list['question']); $list['answer'] = strip_tags($list['answer']); } $this->_view->assign('dataList', $dataList); $this->_loadCore('Help_Page'); $helpPage = new Help_Page(array('total' => $this->_modelPlayerFaq->findCount($conditions), 'perpage' => PAGE_SIZE)); $this->_view->assign('pageBox', $helpPage->show()); } $this->_view->assign('game_type', $this->_faqKind); $this->_view->assign('gameTypeKind', $this->_faqKind); $this->_utilMsg->createNavBar(); $this->_view->set_tpl(array('body' => 'Faq/PlayerFaqRatio.html')); $this->_view->display(); break; default: //显示主页 $this->_view->assign('gameTypeKind', $this->_faqKind); $this->_view->assign('css', $this->_view->get_curCss()); $this->_view->assign('js', $this->_view->get_curJs()); $this->_utilMsg->createNavBar(); $this->_view->display(); } }
/** * 修复FAQ分类下的FAQ数量不对的接口 */ public function actionXiuFu() { $game_id = intval($_GET['game_id']); if (!$game_id) { echo 'field'; exit; } $faqKindTable = $this->_modelPlayerKindFaq->tName(); $kindIds = $this->_modelPlayerKindFaq->select("select Id from {$faqKindTable} where game_type_id = {$game_id}"); foreach ($kindIds as $key => $val) { $faqCount = $this->_modelPlayerFaq->findCount("kind_id={$val['Id']} and status !=1"); $this->_modelPlayerKindFaq->update(array('count' => $faqCount), "Id={$val['Id']}"); } echo 'ok'; }