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();
 }
 /**
  * 我申请的卡号
  */
 public function actionMyApplyCard()
 {
     $this->_checkOperatorAct(2);
     $this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object');
     $userClass = $this->_utilRbac->getUserClass();
     $payType = Tools::getLang('CARD_TYPE', __CLASS__);
     $cardType = $this->_getGlobalData('frg_gold_card_type');
     $serverList = $this->_getGlobalData('gameser_list');
     $this->_modelGoldCard = $this->_getGlobalData('Model_GoldCard', 'object');
     $helpSqlSearch = $this->_loadCore('Help_SqlSearch');
     $helpSqlSearch = new Help_SqlSearch();
     $helpSqlSearch->set_tableName($this->_modelGoldCard->tName());
     $helpSqlSearch->set_conditions('game_type=' . self::GAME_ID);
     $helpSqlSearch->set_conditions("apply_user_id={$userClass['_id']}");
     if ($_GET['is_use'] != '') {
         $helpSqlSearch->set_conditions("is_use='{$_GET['is_use']}'");
         $this->_view->assign('selectedIsUse', $_GET['is_use']);
     }
     if ($_GET['card_type']) {
         $helpSqlSearch->set_conditions("card_type={$_GET['card_type']}");
         $this->_view->assign('selectedCardType', $_GET['card_type']);
     }
     if ($_GET['type'] != '') {
         $helpSqlSearch->set_conditions("type={$_GET['type']}");
         $this->_view->assign('selectedPayType', $_GET['type']);
     }
     if ($_GET['operator_id']) {
         $helpSqlSearch->set_conditions("operator_id={$_GET['operator_id']}");
         $this->_view->assign('selectedOperatorId', $_GET['operator_id']);
     }
     if ($_GET['card']) {
         $helpSqlSearch->set_conditions("card='{$_GET['card']}'");
         $this->_view->assign('selectedCard', $_GET['card']);
     }
     if ($_GET['batch_num']) {
         $helpSqlSearch->set_conditions("batch_num='{$_GET['batch_num']}'");
         $this->_view->assign('selectedBatchnum', $_GET['batch_num']);
     }
     if ($_GET['group_batch']) {
         $helpSqlSearch->set_groupBy("batch_num");
         $this->_view->assign('selectedGroupBatch', true);
     }
     $helpSqlSearch->setPageLimit($_GET['page'], PAGE_SIZE);
     $conditions = $helpSqlSearch->get_conditions();
     $helpSqlSearch->set_orderBy('Id desc');
     $sql = $helpSqlSearch->createSql();
     $dataList = $this->_modelGoldCard->select($sql);
     if ($dataList) {
         $operatorList = Model::getTtwoArrConvertOneArr($this->_getGlobalData('operator_list'), 'Id', 'operator_name');
         foreach ($dataList as &$list) {
             Tools::import('Util_FontColor');
             $list['word_operator_id'] = $operatorList[$list['operator_id']];
             $list['word_is_use'] = Util_FontColor::getFrgPayCardStatus($list['is_use']);
             $list['user_ip'] = $list['user_ip'] ? long2ip($list['user_ip']) : '';
             $list['word_type'] = Util_FontColor::getFrgCardType($list['type']);
             $list['word_card_type'] = $cardType[$list['card_type']];
             $list['word_use_server_id'] = $serverList[$list['use_server_id']]['full_name'];
             $list['start_time'] = $list['start_time'] ? date('Y-m-d H:i:s', $list['start_time']) : '';
             $list['end_time'] = $list['end_time'] ? date('Y-m-d H:i:s', $list['end_time']) : '';
             $list['create_time'] = date('Y-m-d H:i:s', $list['create_time']);
             $list['use_time'] = $list['use_time'] ? date('Y-m-d H:i:s', $list['use_time']) : '';
             $list['url_export'] = Tools::url(CONTROL, 'Export', array('batch_num' => $list['batch_num']));
             $list['word_apply_user_id'] = $userClass['_nickName'];
         }
         $this->_view->assign('dataList', $dataList);
         $this->_loadCore('Help_Page');
         $helpPage = new Help_Page(array('total' => $this->_modelGoldCard->findCount($conditions), 'perpage' => PAGE_SIZE));
         $this->_view->assign('pageBox', $helpPage->show());
     }
     $this->_view->assign('cardStatus', array('0' => Tools::getLang('NOT_USE', 'Common'), '1' => Tools::getLang('USE', 'Common'), '' => Tools::getLang('ALL', 'Common')));
     $this->_view->assign('payType', $payType);
     $cardType[''] = Tools::getLang('ALL', 'Common');
     $this->_view->assign('cardType', $cardType);
     $this->_view->set_tpl(array('body' => self::PACKAGE . '/' . self::GOLD . '/Card.html'));
     $this->_utilMsg->createPackageNavBar();
     $this->_view->display();
 }