private function _index()
{
#------初始化------#
$this->_loadCore('Help_Page');
$this->_modelWorkOrder = $this->_getGlobalData('Model_WorkOrder', 'object');
$this->_modelSysconfig = $this->_getGlobalData('Model_Sysconfig', 'object');
$this->_modelQuestionType = $this->_getGlobalData('Model_QuestionType', 'object');
$this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object');
$this->_utilRooms = $this->_getGlobalData('Util_Rooms', 'object');
$this->_utilOnline = $this->_getGlobalData('Util_Online', 'object');
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache('workorder_status');
$verifyStatusArr = $this->_getGlobalData('verify_status');
//bug 状态
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$operatorList = $this->_getGlobalData('operator_list');
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$evArr = $this->_modelWorkOrder->getEvArr();
//获取评价数组
$badEvArr = $this->_getGlobalData('player_evaluation');
$badEvArr = $badEvArr[3]['Description'];
//差评数组
#------初始化------#
$userClass = $this->_utilRbac->getUserClass();
$roomId = $userClass['_roomId'];
if ($roomId) {
$roomClass = $this->_utilRooms->getRoom($roomId);
$this->_view->assign('roomClass', $roomClass);
}
$userGameTypes = $userClass->getUserGameTypeIds();
//获取用户能控制的游戏ids
$userOperatorIds = $userClass->getUserOperatorIds();
//获取用户能控制的运营商ids
if (!count($userGameTypes) && !count($userOperatorIds)) {
$this->_utilMsg->showMsg(Tools::getLang('SET_OPERATOR_ERROR', __CLASS__), -1, Tools::url('Group', 'Room'));
}
//如果用户没有权限将退出
$questionTypes = $this->_getGlobalData('question_types');
$questionSelect = array();
foreach ($questionTypes as $question) {
if (in_array($question['game_type_id'], $userGameTypes)) {
$questionSelect[$question['Id']] = '<b>[' . $gameTypeArr[$question['game_type_id']] . ']</b>' . $question['title'];
}
}
$questionSelect[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('questionSelect', $questionSelect);
$questionTypes = Model::getTtwoArrConvertOneArr($questionTypes, 'Id', 'title');
$onlineUsers = $this->_utilOnline->getOnlineUser('user_id');
//在线用户,一维数组,value值为user_id
#------分页生成sql------#
$this->_loadCore('Help_SqlSearch');
$helpSqlSearch = new Help_SqlSearch();
$helpSqlSearch->set_tableName($this->_modelWorkOrder->tName());
if (!$_GET['view_type']) {
$_GET['view_type'] = 1;
}
$this->_view->assign('selectedViewType', $_GET['view_type']);
if ($_GET['view_type'] == 1) {
$helpSqlSearch->set_conditions("owner_user_id={$userClass['_id']}");
} else {
if (count($userGameTypes) == 1) {
$gameTypeId = reset($userGameTypes);
$helpSqlSearch->set_conditions("game_type = {$gameTypeId}");
//只能处理的所有工单
} else {
$helpSqlSearch->set_conditions("game_type in (" . implode(',', $userGameTypes) . ")");
//只能处理的所有工单
}
if (count($userOperatorIds) == 1) {
$operatorId = reset($userOperatorIds);
$helpSqlSearch->set_conditions("operator_id = {$operatorId}");
} else {
$helpSqlSearch->set_conditions("operator_id in (" . implode(',', $userOperatorIds) . ")");
}
}
if ($_GET['Id']) {
$helpSqlSearch->set_conditions('Id=' . intval($_GET['Id']));
$this->_view->assign('selectedId', $_GET['Id']);
}
if ($_GET['question_type']) {
$helpSqlSearch->set_conditions("question_type={$_GET['question_type']}");
$this->_view->assign('selectedQuestion', $_GET['question_type']);
}
if ($_GET['vip_level'] != '') {
//如果设置了vip等级,将显示等级
$helpSqlSearch->set_conditions("vip_level={$_GET['vip_level']}");
$this->_view->assign('selectedVipLevel', $_GET['vip_level']);
}
if ($_GET['evaluation_status'] != '') {
$helpSqlSearch->set_conditions("evaluation_status={$_GET['evaluation_status']}");
$this->_view->assign('selectedEv', $_GET['evaluation_status']);
if ($_GET['evaluation_status'] == 3) {
//如果为差评
$this->_view->assign('badev_display', true);
}
}
if ($_GET['evaluation_desc'] != '') {
$helpSqlSearch->set_conditions("evaluation_desc={$_GET['evaluation_desc']}");
$this->_view->assign('selectedBadEv', $_GET['evaluation_desc']);
}
if ($_GET['is_verify'] != '') {
$helpSqlSearch->set_conditions("is_verify={$_GET['is_verify']}");
$this->_view->assign('selectedIsVerify', $_GET['is_verify']);
}
if ($_GET['order_status']) {
$helpSqlSearch->set_conditions("status={$_GET['order_status']}");
$this->_view->assign('selectedOrderStatus', $_GET['order_status']);
$helpSqlSearch->set_orderBy('create_time desc');
} else {
$helpSqlSearch->set_orderBy('status asc,create_time desc');
}
if ($_GET['user_nickname']) {
$helpSqlSearch->set_conditions("user_nickname='{$_GET['user_nickname']}'");
$this->_view->assign('selectedUserNickname', $_GET['user_nickname']);
$_GET['user_nickname'] = urlencode($_GET['user_nickname']);
}
if ($_GET['user_account']) {
$helpSqlSearch->set_conditions("user_account='{$_GET['user_account']}'");
$this->_view->assign('selectedUserAccount', $_GET['user_account']);
$_GET['user_account'] = urlencode($_GET['user_account']);
}
if ($_GET['title']) {
$helpSqlSearch->set_conditions("title like '%{$_GET['title']}%'");
$this->_view->assign('selectedTitle', $_GET['title']);
$_GET['title'] = urlencode($_GET['title']);
}
$helpSqlSearch->setPageLimit($_GET['page'], PAGE_SIZE);
$sql = $helpSqlSearch->createSql();
$conditions = $helpSqlSearch->get_conditions();
$helpPage = new Help_Page(array('total' => $this->_modelWorkOrder->findCount($conditions), 'perpage' => PAGE_SIZE));
#------分页生成sql------#
$dataList = $this->_modelWorkOrder->select($sql);
#------载入缓存------#
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache('workorder_source');
$vipLevel = Tools::getLang('VIP_LEVEL', 'Common');
$users = $this->_getGlobalData('user');
$serverList = $this->_getGlobalData('gameser_list');
#------载入缓存------#
if ($dataList) {
Tools::import('Util_FontColor');
$timeInterval = array();
//定时器计时
foreach ($dataList as &$list) {
$list['url_dialog'] = Tools::url(CONTROL, 'OrderDialog', array('Id' => $list['Id']));
$list['word_game_type'] = Util_FontColor::getGameTypeColor($list['game_type'], $gameTypeArr[$list['game_type']]);
$list['word_source'] = Util_FontColor::getWorkOrderSource($list['source'], $workOrderSourceArr[$list['source']]);
$list['word_status'] = Util_FontColor::getWorkOrderStatus($list['status'], $workOrderStatusArr[$list['status']]);
$list['word_status'] .= $list['is_verify'] ? Tools::getLang('VERIFY_STATUS', 'Common') : '';
$list['word_operator_id'] = $operatorList[$list['operator_id']];
$list['word_question_type'] = $questionTypes[$list['question_type']] ? $questionTypes[$list['question_type']] : ' ';
$list['url_detail'] = Tools::url('WorkOrder', 'Detail', array('Id' => $list['Id']));
$list['word_owner_user_id'] = $users[$list['owner_user_id']]['nick_name'];
$list['word_game_server_id'] = $serverList[$list['game_server_id']]['server_name'];
$list['word_ev'] = Util_FontColor::getPlayerEvaluation($list['evaluation_status'], $evArr[$list['evaluation_status']]);
//提问类型
if ($list['evaluation_status'] == 3) {
$list['word_ev_desc'] = $badEvArr[$list['evaluation_desc']];
}
if ($list['status'] == 1) {
$isTimeout = Tools::isTimeOut($list['create_time'], $list['timeout']);
if ($isTimeout === true) {
//已超时
$list['time_out_true'] = true;
} else {
//未超时
$list['lost_time'] = Tools::getTimeFormat($isTimeout);
$timeInterval[$list['Id']]['div'] = $list['Id'];
$timeInterval[$list['Id']]['time'] = $isTimeout;
}
}
if ($serverList[$list['game_server_id']]['time_zone'] != 0) {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time'] + $serverList[$list['game_server_id']]['time_zone'] * 3600);
} else {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time']);
}
if ($list['word_owner_user_id']) {
$list['word_owner_user_id'] .= in_array($list['owner_user_id'], $onlineUsers) ? Util_FontColor::getOnline(1) : Util_FontColor::getOnline(0);
}
$verifyInfo = $this->_modelWorkOrder->select('select status from ' . DB_PREFIX . 'verify ' . 'where work_order_id =' . $list['Id'], 1);
$verifyStatus = $verifyInfo['status'];
$list['word_verify_status'] = $verifyStatusArr[$verifyStatus];
}
$this->_view->assign('dataList', $dataList);
}
$evArr[''] = Tools::getLang('ALL', 'Common');
$badEvArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('verify', $this->_modelWorkOrder->getVerify());
$this->_view->assign('badEvArr', $badEvArr);
$this->_view->assign('evArr', $evArr);
$this->_view->assign('timeInterval', json_encode($timeInterval));
$userOperator = $userClass['_operatorIds'];
foreach ($userOperator as &$value) {
$value['word_operator_id'] = $operatorList[$value['operator_id']];
$value['word_game_type_id'] = $gameTypeArr[$value['game_type_id']];
}
$this->_view->assign('lastYmd', date('Ymd', strtotime('-1 day')));
$this->_view->assign('viewType', Tools::getLang('VIEW_TYPE', __CLASS__));
$this->_view->assign('userClass', $userClass);
$this->_view->assign('userOperator', $userOperator);
$this->_view->assign('vipLevel', $vipLevel);
$workOrderStatusArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('workOrderStatusArr', $workOrderStatusArr);
$this->_view->assign('js', $this->_view->get_curJs());
$this->_view->assign('pageBox', $helpPage->show());
$this->_utilMsg->createNavBar();
$this->_view->display();
}
/**
* 工单显示列表
*/
public function actionIndex()
{
#------初始化------#
$this->_utilOnline = $this->_getGlobalData('Util_Online', 'object');
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache('workorder_status');
$verifyStatusArr = $this->_getGlobalData('verify_status');
//bug 状态
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$operatorList = $this->_getGlobalData('operator_list');
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$this->_modelUser = $this->_getGlobalData('Model_User', 'object');
$orgList = $this->_getGlobalData('org');
$evArr = $this->_modelWorkOrder->getEvArr();
//获取评价数组
$badEvArr = $this->_getGlobalData('player_evaluation');
$badEvArr = $badEvArr[3]['Description'];
//差评数组
$questionTypes = $this->_getGlobalData('question_types');
foreach ($orgList as &$value) {
$curOrgUser = $this->_modelUser->findByOrgId($value['Id']);
if ($curOrgUser) {
$curOrgUser = Model::getTtwoArrConvertOneArr($curOrgUser, 'Id', 'nick_name');
$value['user'] = $curOrgUser;
}
}
$this->_modelRooms = $this->_getGlobalData('Model_Rooms', 'object');
$roomList = $this->_modelRooms->findAll();
$roomList = Model::getTtwoArrConvertOneArr($roomList, 'Id', 'name');
$roomList[''] = Tools::getLang('All', 'Common');
$this->_utilWorkOrder = $this->_getGlobalData('Util_WorkOrder', 'object');
$orderManage = $this->_utilWorkOrder->getOrderManage();
$orderVipNum = $orderManage['_orderNum'];
$orderVipNum[''] = array_sum($orderVipNum);
#------初始化------#
$onlineUsers = $this->_utilOnline->getOnlineUser('user_id');
//在线用户,一维数组,value值为user_id
#------分页生成sql------#
$helpSqlSearch = $this->_loadCore('Help_SqlSearch');
$helpSqlSearch = new Help_SqlSearch();
$helpSqlSearch->set_tableName($this->_modelWorkOrder->tName());
if ($_GET['game_type_id'] != '') {
$helpSqlSearch->set_conditions("game_type={$_GET['game_type_id']}");
$this->_view->assign('selectedGameTypeId', $_GET['game_type_id']);
#------提问类型------#
$qTypes = array();
foreach ($questionTypes as $key => $list) {
if ($list['game_type_id'] == $_GET['game_type_id']) {
$qTypes[$key] = $list['title'];
}
}
$qTypes[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('qType', $qTypes);
if ($_GET['question_type']) {
$helpSqlSearch->set_conditions("question_type={$_GET['question_type']}");
$this->_view->assign('selectedQtype', $_GET['question_type']);
}
#------提问类型------#
#------运营商------#
$operatorListTemp = array();
$gameOperatorIndex = $this->_getGlobalData('Model_GameOperator', 'object')->findByGameTypeId($_GET['game_type_id']);
foreach ($gameOperatorIndex as $value) {
if (array_key_exists($value['operator_id'], $operatorList)) {
$operatorListTemp[$value['operator_id']] = $operatorList[$value['operator_id']];
}
}
$operatorList = $operatorListTemp;
unset($operatorListTemp);
#------运营商------#
}
if ($_GET['operator_id'] != '') {
$helpSqlSearch->set_conditions("operator_id={$_GET['operator_id']}");
$this->_view->assign('selectedOperatorId', $_GET['operator_id']);
}
//增加服务器选择列表
if ($_GET['game_type_id'] != '' && $_GET['operator_id'] != '') {
$gameOptServerLists = $this->_getServers($_GET['game_type_id'], $_GET['operator_id']);
if ($_GET['server_id'] != '') {
$helpSqlSearch->set_conditions('game_server_id=' . intval($_GET['server_id']));
}
$this->_view->assign('gameOptServerLists', $gameOptServerLists);
}
if ($_GET['Id']) {
$helpSqlSearch->set_conditions("Id={$_GET['Id']}");
$this->_view->assign('selectedId', $_GET['Id']);
}
if ($_GET['room_id']) {
$helpSqlSearch->set_conditions("room_id={$_GET['room_id']}");
$this->_view->assign('selectedRoomId', $_GET['room_id']);
}
if ($_GET['evaluation_status'] != '') {
$helpSqlSearch->set_conditions("evaluation_status={$_GET['evaluation_status']}");
$this->_view->assign('selectedEv', $_GET['evaluation_status']);
if ($_GET['evaluation_status'] == 3) {
//如果为差评
$this->_view->assign('badev_display', true);
}
}
if ($_GET['is_verify'] != '') {
$helpSqlSearch->set_conditions("is_verify={$_GET['is_verify']}");
$this->_view->assign('selectedIsVerify', $_GET['is_verify']);
}
if ($_GET['evaluation_desc'] != '') {
$helpSqlSearch->set_conditions("evaluation_desc={$_GET['evaluation_desc']}");
$this->_view->assign('selectedBadEv', $_GET['evaluation_desc']);
}
if ($_GET['vip_level'] != '') {
//如果设置了vip等级,将显示等级
$helpSqlSearch->set_conditions("vip_level={$_GET['vip_level']}");
$this->_view->assign('selectedVipLevel', $_GET['vip_level']);
}
$helpSqlSearch->setPageLimit($_GET['page'], 20);
if ($_GET['order_status']) {
$helpSqlSearch->set_conditions("status={$_GET['order_status']}");
$this->_view->assign('selectedOrderStatus', $_GET['order_status']);
}
if ($_GET['user_nickname']) {
$helpSqlSearch->set_conditions("user_nickname='{$_GET['user_nickname']}'");
$this->_view->assign('selectedUserNickname', $_GET['user_nickname']);
$_GET['user_nickname'] = urlencode($_GET['user_nickname']);
}
if ($_GET['user_account']) {
$helpSqlSearch->set_conditions("user_account='{$_GET['user_account']}'");
$this->_view->assign('selectedUserAccount', $_GET['user_account']);
$_GET['user_account'] = urlencode($_GET['user_account']);
}
if ($_GET['title']) {
$helpSqlSearch->set_conditions("title like '%{$_GET['title']}%'");
$this->_view->assign('selectedTitle', $_GET['title']);
$_GET['title'] = urlencode($_GET['title']);
}
if ($_GET['service_ids']) {
//如果选择了客服
$this->_view->assign('selectedServiceIds', $_GET['service_ids']);
$serviceIds = implode(',', $_GET['service_ids']);
$helpSqlSearch->set_conditions("owner_user_id in ({$serviceIds})");
}
if ($_GET['start_time'] && $_GET['end_time']) {
$this->_view->assign('selectedStartTime', $_GET['start_time']);
$this->_view->assign('selectedEndTime', $_GET['end_time']);
$helpSqlSearch->set_conditions('create_time between ' . strtotime($_GET['start_time']) . ' and ' . strtotime($_GET['end_time']));
}
$helpSqlSearch->set_orderBy('status asc,create_time desc');
$sql = $helpSqlSearch->createSql();
$conditions = $helpSqlSearch->get_conditions();
$this->_loadCore('Help_Page');
$helpPage = new Help_Page(array('total' => $this->_modelWorkOrder->findCount($conditions), 'perpage' => 20));
$this->_view->assign('pageBox', $helpPage->show());
#------分页生成sql------#
$dataList = $this->_modelWorkOrder->select($sql);
#------载入缓存------#
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache('workorder_source');
$vipLevel = Tools::getLang('VIP_LEVEL', 'Common');
foreach ($vipLevel as $key => &$vipCount) {
$vipCount .= " [<font color='#ff0000'>" . intval($orderVipNum[$key]) . "</font>]";
}
$users = $this->_getGlobalData('user_all');
$serverList = $this->_getGlobalData('gameser_list');
#------载入缓存------#
if ($dataList) {
Tools::import('Util_FontColor');
$timeInterval = array();
//定时器计时
foreach ($dataList as &$list) {
$TimeDifference = intval($serverList[$list['game_server_id']]['time_zone']);
//时差
$list['url_dialog'] = Tools::url('QualityCheck', 'OrderDialog', array('Id' => $list['Id'], 'TimeDifference' => $TimeDifference));
$list['word_game_type'] = Util_FontColor::getGameTypeColor($list['game_type'], $gameTypeArr[$list['game_type']]);
$list['word_source'] = Util_FontColor::getWorkOrderSource($list['source'], $workOrderSourceArr[$list['source']]);
$list['word_status'] = Util_FontColor::getWorkOrderStatus($list['status'], $workOrderStatusArr[$list['status']]);
$list['word_status'] .= $list['is_verify'] ? Tools::getLang('VERIFY_STATUS', 'Common') : '';
$list['word_operator_id'] = $operatorList[$list['operator_id']];
$list['word_question_type'] = $questionTypes[$list['question_type']]['title'] ? $questionTypes[$list['question_type']]['title'] : Tools::getLang('NOT_QUESTION_TYPE', 'Common');
$list['url_detail'] = Tools::url('WorkOrder', 'Detail', array('Id' => $list['Id']));
$list['word_owner_user_id'] = $users[$list['owner_user_id']]['nick_name'];
$list['word_game_server_id'] = $serverList[$list['game_server_id']]['server_name'];
$list['word_ev'] = Util_FontColor::getPlayerEvaluation($list['evaluation_status'], $evArr[$list['evaluation_status']]);
//提问类型
$list['url_reply_detail'] = Tools::url(CONTROL, 'ReplyIndex', array('user_id' => $list['owner_user_id']));
$list['word_room_id'] = $list['room_id'] ? $roomList[$list['room_id']] : '<font color="#666666">' . Tools::getLang('NOT', 'Common') . '</font>';
if ($list['evaluation_status'] == 3) {
$list['word_ev_desc'] = $badEvArr[$list['evaluation_desc']];
}
if ($list['status'] == 1) {
$isTimeout = Tools::isTimeOut($list['create_time'], $list['timeout']);
if ($isTimeout === true) {
//已超时
$list['time_out_true'] = true;
} else {
//未超时
$list['lost_time'] = Tools::getTimeFormat($isTimeout);
$timeInterval[$list['Id']]['div'] = $list['Id'];
$timeInterval[$list['Id']]['time'] = $isTimeout;
}
}
if ($TimeDifference != 0) {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time'] + $TimeDifference * 3600);
$list['create_time'] .= '(' . Tools::getLang('GAME_SERVER_TIME', 'Common') . ')';
} else {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time']);
}
if ($list['word_owner_user_id']) {
$list['word_owner_user_id'] .= in_array($list['owner_user_id'], $onlineUsers) ? Util_FontColor::getOnline(1) : Util_FontColor::getOnline(0);
}
$verifyInfo = $this->_modelWorkOrder->select('select status from ' . DB_PREFIX . 'verify ' . 'where work_order_id =' . $list['Id'], 1);
$verifyStatus = $verifyInfo['status'];
$list['word_verify_status'] = $verifyStatusArr[$verifyStatus];
}
$this->_view->assign('dataList', $dataList);
}
$evArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('statusurl', Tools::url(CONTROL, 'ChangetheStatus'));
$badEvArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('verify', $this->_modelWorkOrder->getVerify());
$this->_view->assign('badEvArr', $badEvArr);
$this->_view->assign('evArr', $evArr);
$this->_view->assign('roomList', $roomList);
$this->_view->assign('timeInterval', json_encode($timeInterval));
$gameTypeArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('gameTypeList', $gameTypeArr);
$operatorList[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('operatorList', $operatorList);
$this->_view->assign('orgList', $orgList);
$this->_view->assign('vipLevel', $vipLevel);
$workOrderStatusArr[''] = Tools::getLang('ALL', 'Common');
$this->_view->assign('workOrderStatusArr', $workOrderStatusArr);
$this->_view->assign('js', $this->_view->get_curJs());
$this->_utilMsg->createNavBar();
$this->_view->display();
}