private function _spActivityIndex() { #------初始化------# $this->_createServerList(); $serverList = $this->_getGlobalData('gameser_list'); $this->_modelFrgSpecialActivity = $this->_getGlobalData('Model_FrgSpecialActivity', 'object'); $this->_loadCore('Help_SqlSearch'); $this->_loadCore('Help_Page'); #------初始化------# $helpSqlSearch = new Help_SqlSearch(); $helpSqlSearch->set_tableName($this->_modelFrgSpecialActivity->tName()); $_REQUEST['operator_id'] = intval($_REQUEST['operator_id']); if ($_REQUEST['operator_id']) { $helpSqlSearch->set_conditions("operator_id={$_REQUEST['operator_id']}"); $this->_view->assign('selectedOperatorId', $_REQUEST['operator_id']); } if ($_REQUEST['title']) { $helpSqlSearch->set_conditions("(Title like '%{$_REQUEST['title']}%' )"); $this->_view->assign('selectedTitle', $_REQUEST['title']); } if ($_REQUEST['is_group']) { // $helpSqlSearch->set_groupBy('Title,IdentifierValue,StartTime,EndTime'); $helpSqlSearch->set_groupBy('Title,IdentifierValue'); $helpSqlSearch->set_field('count(*) as server_num,Id,operator_id,server_id,special_activity_id,Identifier,IdentifierValue,Img,IsOpen,Title,Content,AwardDesc,StartTime,EndTime,CheckType,AwardIds,Awards,GetCond,Status,MsgTitle,MsgContent,MsgContent,IsShow'); $this->_view->assign('selectedGroupBy', true); } $open = array('0' => Tools::getLang('CLOSE', 'Common'), '1' => Tools::getLang('OPEN', 'Common')); $show = array('0' => Tools::getLang('NOT_DISPLAY', 'Common'), '1' => Tools::getLang('DISPLAY', 'Common')); $helpSqlSearch->setPageLimit($_GET['page'], PAGE_SIZE); $helpSqlSearch->set_orderBy('server_id'); $conditions = $helpSqlSearch->get_conditions(); $sql = $helpSqlSearch->createSql(); $dataList = $this->_modelFrgSpecialActivity->select($sql); if ($dataList) { foreach ($dataList as $key => &$val) { $val['URL_edit'] = Tools::url(CONTROL, ACTION, array('zp' => self::PACKAGE, 'doaction' => 'edit', 'title' => $val['Title'], 'IdentifierValue' => $val['IdentifierValue'], 'StartTime' => $val['StartTime'], 'EndTime' => $val['EndTime'], 'operator_id' => $_REQUEST['operator_id'], 'server_id' => $val['server_id'], 'special_activity_id' => $val['special_activity_id'])); } } $serverListFullName = Model::getTtwoArrConvertOneArr($serverList, 'Id', 'full_name'); $this->_view->assign('serverListFullName', $serverListFullName); if ($_REQUEST['is_group']) { $FiledGroupBy = $helpSqlSearch->getFiledGroupBy(); $count = $this->_modelFrgSpecialActivity->countGroupBy($conditions, $FiledGroupBy); } else { $count = $this->_modelFrgSpecialActivity->findCount($conditions); } $helpPage = new Help_Page(array('total' => $count, 'perpage' => PAGE_SIZE)); $this->_view->assign('pageBox', $helpPage->show()); $this->_view->assign('dataList', $dataList); $this->_view->assign('is_open', $open); $this->_view->assign('is_show', $show); $this->_utilMsg->createNavBar(); $this->_view->display(); }