/** * 资讯显示列表 */ 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); }