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';
}
