/**
* 资讯显示列表
*/
public function cIndex()
{
$this->_modelNews = $this->getGlobal('model/News', 'Model_News');
$users = params('adminuser/id_vuser');
$sqlSearch = $this->_modelNews->getFindClass();
$sqlSearch->clearAll();
$sqlSearch->set_tableName($this->_modelNews->tName());
$search = $this->getR('s');
$sqlSearch->addConditions(array('type' => $search['type'], 'game_type' => $search['game_type'], 'is_top' => $search['is_top'], 'user_id' => $search['user_id']));
if ($search['start_time'] && $search['end_time']) {
$search['start_time'] = strtotime($search['start_time']);
$search['end_time'] = strtotime($search['end_time']);
$sqlSearch->set_conditions("time between {$search['start_time']} and {$search['end_time']}");
}
$sqlSearch->setPageLimit($this->getR('page'));
$sqlSearch->set_orderBy('is_top desc, time desc');
$conditions = $sqlSearch->get_conditions();
$sql = $sqlSearch->createSql();
$dataList = $this->_modelNews->select($sql);
if ($dataList) {
foreach ($dataList as &$val) {
$val['word_type'] = $this->_type[$val['type']];
$val['word_game_type'] = $this->_gameTypes[$val['game_type']];
$val['word_is_top'] = $this->_isTop[$val['is_top']];
$val['time'] = $val['time'] ? date('Y-m-d H:i:s', $val['time']) : '';
$val['word_user_id'] = $users[$val['user_id']];
}
$this->assign('dataList', $dataList);
loadCore('help/Page');
$page = new Page(array('total' => $this->_modelNews->findCount($conditions)));
$this->assign('pageBox', $page->show());
}
$this->_type[''] = '所有';
$this->_isTop[''] = '所有';
$this->assign('users', $users);
$this->assign('type', $this->_type);
$this->assign('isTop', $this->_isTop);
$this->display(VIEW_PAGE);
}
