public function actionUpdateSql()
{
$this->_modelSysconfig = $this->_getGlobalData('Model_Sysconfig', 'object');
$sql = array();
foreach ($sql as $list) {
$this->_modelSysconfig->execute($list);
}
}
public function __construct()
{
$this->_createView();
$this->_createUrl();
$this->_utilMsg = $this->_getGlobalData('Util_Msg', 'object');
$this->_modelPlayerFaq = $this->_getGlobalData('Model_PlayerFaq', 'object');
$this->_modelPlayerKindFaq = $this->_getGlobalData('Model_PlayerKindFaq', 'object');
$this->_modelServiceFaq = $this->_getGlobalData('Model_ServiceFaq', 'object');
$this->_modelServiceKindFaq = $this->_getGlobalData('Model_ServiceKindFaq', 'object');
$this->_modelSysconfig = $this->_getGlobalData('Model_Sysconfig', 'object');
#------更改faq主分类------#
$this->_faqKind = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
#------更改faq主分类------#
}
public function actionUpdateSql()
{
$this->_modelSysconfig = $this->_getGlobalData('Model_Sysconfig', 'object');
//在<<<EOF和EOF之间输入sql语句;
$sql = <<<EOF
\t\t
EOF;
$sql = trim($sql);
if (empty($sql)) {
return;
}
$sql = explode(';', $sql);
foreach ($sql as $list) {
$this->_modelSysconfig->execute($list);
}
}
/**
* 添加服务器
*/
private function _add()
{
if ($this->_isPost()) {
if ($_POST['batch_add']) {
$start = Tools::coerceInt($_POST['start']);
$end = Tools::coerceInt($_POST['end']);
$addArrs = array();
for ($i = $start; $i <= $end; $i++) {
$addArrs[$i] = array('game_type_id' => intval($_POST['game_type']), 'operator_id' => intval($_POST['operator_id']), 'ordinal' => $i, 'server_name' => str_replace('{$var}', $i, $_POST['server_name']), 'marking' => str_replace('{$var}', $i, $_POST['marking']), 'server_url' => str_replace('{$var}', $i, $_POST['server_url']), 'timezone' => trim($_POST['timezone']), 'time_zone' => trim($_POST['time_zone']), 'timer' => intval($_POST['timer']), 'data_url' => str_replace('{$var}', $i, $_POST['data_url']));
}
$reuslt = $this->_modelGameSerList->adds($addArrs);
} else {
$addArr = array('game_type_id' => intval($_POST['game_type']), 'operator_id' => intval($_POST['operator_id']), 'ordinal' => intval($_POST['ordinal']), 'server_name' => trim($_POST['server_name']), 'marking' => trim($_POST['marking']), 'server_url' => trim($_POST['server_url']), 'timezone' => trim($_POST['timezone']), 'time_zone' => trim($_POST['time_zone']), 'timer' => intval($_POST['timer']), 'data_url' => trim($_POST['data_url']));
$reuslt = $this->_modelGameSerList->add($addArr);
}
if ($reuslt) {
$this->_utilMsg->showMsg(Tools::getLang('ADD_SUCCESS', 'Common'), 1, Tools::url(CONTROL, ACTION));
} else {
$this->_utilMsg->showMsg(Tools::getLang('ADD_ERROR', 'Common'), -2);
}
} else {
$gameTypeList = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$operatorList = $this->_modelOperatorList->findAll();
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$this->_view->assign('operatorList', $operatorList);
$this->_view->assign('gameTypeList', $gameTypeList);
$timer = array('0' => '关闭', '1' => '开启');
$this->_view->assign('timer', $timer);
$this->_utilMsg->createNavBar();
$this->_view->set_tpl(array('body' => 'GameSerList/Add.html'));
$this->_view->display();
}
}
/**
* 添加服务器
*/
private function _add()
{
if ($this->_isPost()) {
$addArr = array('game_type_id' => $_POST['game_type'], 'operator_id' => $_POST['operator_id'], 'server_name' => $_POST['server_name'], 'marking' => $_POST['marking'], 'server_url' => $_POST['server_url'], 'send_msg_url' => $_POST['send_msg_url']);
if ($this->_modelGameSerList->add($addArr)) {
$this->_utilMsg->showMsg('添加成功', 1, Tools::url(CONTROL, ACTION));
} else {
$this->_utilMsg->showMsg('添加失败', -2);
}
} else {
$gameTypeList = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$operatorList = $this->_modelOperatorList->findAll();
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$this->_view->assign('operatorList', $operatorList);
$this->_view->assign('gameTypeList', $gameTypeList);
$this->_utilMsg->createNavBar();
$this->_view->set_tpl(array('body' => 'GameSerList/Add.html'));
$this->_view->display();
}
}
/**
* 选择了游戏,提交了问题名称之后进入的页面
*/
public function actionAsk()
{
if ($this->_isPost()) {
$gameTypeList = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$question = $this->_modelQuestionType->findById($_POST['question_type']);
//查找ID对应的问题
Tools::import('Util_QuickForm');
$quickForm = new Util_QuickForm();
$quickForm->set_selectedGameType($_POST['game_type']);
//设置用户提交过来的游戏类型,方便调用服务器列表
$quickForm->addManyElementArray($question['form_table']);
$this->_view->assign('questionHtml', $quickForm->get_formHtml());
$this->_view->assign('questionTitle', $question['title']);
//获取问题标题
$this->_view->assign('gameType', $_POST['game_type']);
$this->_view->assign('questionType', $_POST['question_type']);
$this->_view->assign('word_gameType', $gameTypeList[$_POST['game_type']]);
$this->_view->assign('title', $_POST['title']);
$this->_utilMsg->createNavBar();
$this->_view->display();
}
}
private function _ref()
{
#------初始化------#
if (!$this->_isAjax()) {
return;
}
parse_str($_POST['url'], $_GET);
$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');
$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();
$userGameTypes = $userClass->getUserGameTypeIds();
//获取用户能控制的游戏ids
$userOperatorIds = $userClass->getUserOperatorIds();
//获取用户能控制的运营商ids
$questionTypes = $this->_getGlobalData('question_types');
$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;
}
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['question_type']) {
$helpSqlSearch->set_conditions("question_type={$_GET['question_type']}");
}
if ($_GET['vip_level'] != '') {
$helpSqlSearch->set_conditions("vip_level={$_GET['vip_level']}");
}
if ($_GET['evaluation_status'] != '') {
$helpSqlSearch->set_conditions("evaluation_status={$_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']}");
}
if ($_GET['order_status']) {
$helpSqlSearch->set_conditions("status={$_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']}'");
}
if ($_GET['user_account']) {
$helpSqlSearch->set_conditions("user_account='{$_GET['user_account']}'");
}
if ($_GET['title']) {
$helpSqlSearch->set_conditions("title like '%{$_GET['title']}%'");
}
$helpSqlSearch->setPageLimit($_GET['page'], PAGE_SIZE);
$sql = $helpSqlSearch->createSql();
$dataList = $this->_modelWorkOrder->select($sql);
#------分页生成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);
}
}
}
$timeInterval = json_encode($timeInterval);
$this->_view->assign('dataList', $dataList);
$dataList = $this->_view->fetch('MyTask/Ref.html');
$output = array('dataList' => $dataList, 'timer' => $timeInterval);
$this->_returnAjaxJson(array('status' => 1, 'msg' => null, 'data' => $output));
}
public function genePayXML($bookid)
{
$model = new Model_Insurance_Booking($bookid);
if (!$model->loaded()) {
return false;
}
$curtime = time();
$configsBase = $this->getHuizheConfig();
$configModel = new Model_Sysconfig();
$configsArr = $configModel->getConfig(0);
$md5Str = md5($configsBase['key'] . $configsBase['partnerid'] . $model->ordersn);
$asyncResUrl = $GLOBALS['cfg_basehost'] . '/insurance/notify.php';
//生成判断部
$xml = '<?xml version="1.0" encoding="utf-8"?>
<OrderApplyRequest>
<TransrNo>' . $model->ordersn . '</TransrNo>
<CaseCode>' . $model->productcasecode . '</CaseCode>
<MD5Str>' . $md5Str . '</MD5Str>
<PartnerID>' . $configsBase['partnerid'] . '</PartnerID>';
//生成member
$xmlMember = '<Member>
<Name>' . $configsArr['cfg_huizhe_member_name'] . '</Name>
<Mobile>' . $configsArr['cfg_huizhe_member_mobile'] . '</Mobile>
<Email>' . $configsArr['cfg_huizhe_member_email'] . '</Email>
<Address>' . $configsArr['cfg_huizhe_member_address'] . '</Address>
<Company>' . $configsArr['cfg_huizhe_member_company'] . '</Company>
<CallBackUrl>' . $asyncResUrl . '</CallBackUrl>
</Member>';
//生成policy的XML
$xmlPolicy = '<Policy><ApplicationDate>' . date('Y-m-d', $curtime) . '</ApplicationDate>
<BeginDate>' . $model->begindate . '</BeginDate>
<EndDate>' . $model->enddate . '</EndDate>
<SinglePrice>' . $model->price . '</SinglePrice>
<Destination>' . $model->destination . '</Destination>
<TripPurposeId>' . $model->trippurposeid . '</TripPurposeId>
<VisaCity>' . $model->visacity . '</VisaCity></Policy>';
//生成applicant
$xmlApplicant = '<Applicant><Name>' . $configsArr['cfg_insurance_buyer_name'] . '</Name>
<NamePinYin>' . $configsArr['cfg_insurance_buyer_pinyin'] . '</NamePinYin>
<CardType>' . $configsArr['cfg_insurance_buyer_cardtype'] . '</CardType>
<CardCode>' . $configsArr['cfg_insurance_buyer_cardcode'] . '</CardCode>
<Sex>' . $configsArr['cfg_insurance_buyer_sex'] . '</Sex>
<Birthday>' . $configsArr['cfg_insurance_buyer_birthday'] . '</Birthday>
<Address>' . $configsArr['cfg_insurance_buyer_address'] . '</Address>
<PostCode>' . $configsArr['cfg_insurance_buyer_postcode'] . '</PostCode>
<Phone>' . $configsArr['cfg_insurance_buyer_phone'] . '</Phone>
<Mobile>' . $configsArr['cfg_insurance_buyer_mobile'] . '</Mobile>
<Fax>' . $configsArr['cfg_insurance_buyer_fax'] . '</Fax>
<Email>' . $configsArr['cfg_insurance_buyer_email'] . '</Email>
<HomeAddress>' . $configsArr['cfg_insurance_buyer_homeaddress'] . '</HomeAddress>
<JobCode>' . $configsArr['cfg_insurance_buyer_jobcode'] . '</JobCode>
<JobLevel>' . $configsArr['cfg_insurance_buyer_joblevel'] . '</JobLevel>
<Job>' . $configsArr['cfg_insurance_buyer_job'] . '</Job></Applicant>
';
//生成insured
$tourerModel = new Model_Insurance_Booking_Tourer();
$tourers = $tourerModel->where('orderid', '=', $model->id)->get_all();
$xmlInsured = '';
foreach ($tourers as $k => $v) {
$xmlInsured .= '<Insured>
<Name>' . $v['name'] . '</Name>
<NamePinYin>' . $v['pinyin'] . '</NamePinYin>
<Sex>' . $v['sex'] . '</Sex>
<CardType>' . $v['cardtype'] . '</CardType>
<CardCode>' . $v['cardcode'] . '</CardCode>
<Birthday>' . $v['birthday'] . '</Birthday>
<Mobile>' . $v['mobile'] . '</Mobile>
<JobCode>' . $v['jobcode'] . '</JobCode>
<JObLevel>' . $v['joblevel'] . '</JObLevel>
<Job>' . $v['job'] . '</Job>
<FltNo>' . $v['fltno'] . '</FltNo>
<City>' . $v['city'] . '</City>
<InsurantRelation>' . $v['insurantrelation'] . '</InsurantRelation>
<Count>' . $v['count'] . '</Count></Insured>';
}
$xml = $xml . $xmlMember . $xmlPolicy . $xmlInsured . $xmlApplicant . '</OrderApplyRequest>';
return $xml;
}
/**
* 查看工单详细
*/
public function actionDetail()
{
$dataList = $this->_modelWorkOrder->findByIdToDetail($_GET['Id']);
$dialogList = $this->_modelWorkOrderQa->findByWorkOrderId($_GET['Id']);
#------载入缓存------#
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
//游戏类型
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache('workorder_source');
//工单来源
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache('workorder_status');
//工单状态
$gameServerList = $this->_getGlobalData('gameser_list');
$gameServerList = Model::getTtwoArrConvertOneArr($gameServerList, 'Id', 'server_name');
$operatorList = $this->_getGlobalData('operator_list');
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$user = $this->_getGlobalData('user');
$departmentList = $this->_getGlobalData('department');
$departmentList = Model::getTtwoArrConvertOneArr($departmentList, 'Id', 'name');
#------载入缓存------#
#------跟椐ID转换文字显示------#
$dataList['word_status'] = $workOrderStatusArr[$dataList['status']];
$dataList['word_game_type'] = $gameTypeArr[$dataList['game_type']];
$dataList['word_source'] = $workOrderSourceArr[$dataList['source']];
$dataList['word_game_server_id'] = $gameServerList[$dataList['game_server_id']];
$dataList['word_operator_id'] = $operatorList[$dataList['operator_id']];
$dataList['create_time'] = date('Y-m-d H:i', $dataList['create_time']);
$dataList['word_quality_id'] = $dataList['quality_id'] < 0 ? $user[$dataList['quality_id']]['nick_name'] . "[{$departmentList[$user[$dataList['quality_id']]['department_id']]}]" : '未质检';
#------跟椐ID转换文字显示------#
$user = Model::getTtwoArrConvertOneArr($user, 'user_name', 'full_name');
foreach ($dialogList as &$list) {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time']);
$list['word_reply_name'] = $user[$list['reply_name']];
}
$workOrderDetailArr = unserialize($dataList['content']);
//获取工单的详细信息
$userData = $workOrderDetailArr['user_data'];
//获取提交工单用户的详细信息
$userData['register_date'] = $userData['register_date'] ? date('Y-m-d H:i:s', $userData['register_date']) : '';
if ($dataList['evaluation_status'] != 0) {
//如果已经评价
$playerEvaluation = $this->_getGlobalData('player_evaluation');
$evaluation = $playerEvaluation[$dataList['evaluation_status']];
$evaluation = $evaluation['title'];
if ($dataList['evaluation_status'] == 3) {
$evaluation .= '： ' . $workOrderDetailArr['other']['ev'];
}
$this->_view->assign('evaluation', $evaluation);
}
if ($dataList['source'] != 2) {
//如果工单不是从游戏里面来的话
$userQuestionDetail = $workOrderDetailArr['form_detail'];
//获取提问类型工单的值
$questionDetail = $this->_modelQuestionType->findById($dataList['question_type']);
//查找问题类型
$dataList['word_question_type'] = $questionDetail['title'];
//获取问题类型的中文名称以方便显示
$questionDetail = $questionDetail['form_table'];
//获取问题类型的表单配置值
$userQuestionDetailArr = array();
//初始化显示提交问题类型数组
if ($questionDetail) {
foreach ($questionDetail as $value) {
//将表单转换为key/value方式,方便显示
if ($value['type'] == 'game_server_list') {
continue;
}
//如果为服务器列表将跳过,因为已经在工单上面有了.
switch ($value['type']) {
case 'select':
$userQuestionDetailArr[$value['title']] = $value['options'][$userQuestionDetail[$value['name']]];
break;
default:
$userQuestionDetailArr[$value['title']] = $userQuestionDetail[$value['name']];
break;
}
}
}
}
unset($workOrderStatusArr[1]);
//删除待处理状态
unset($workOrderStatusArr[4]);
//删除被玩家删除状态
$this->_view->assign('workOrderStatusArr', $workOrderStatusArr);
$this->_view->assign('userData', $userData);
$this->_view->assign('userQuestionDetailArr', $userQuestionDetailArr);
//问题类型显示
$this->_view->assign('dialogArr', $dialogList);
//对话详细
$this->_view->assign('data', $dataList);
//表单详细信息
$this->_view->assign('js', $this->_view->get_curJs());
$this->_url['Verify_OrderVerify'] = Tools::url('Verify', 'OrderVerify', array('work_order_id' => $_GET['Id'], 'game_type_id' => $dataList['game_type'], 'operator_id' => $dataList['operator_id'], 'game_server_id' => $dataList['game_server_id'], 'game_user_id' => $userData['user_id'], 'user_account' => urlencode($userData['user_account']), 'user_nickname' => urlencode($userData['user_nickname'])));
$this->_view->assign('url', $this->_url);
$this->_utilMsg->createNavBar();
$this->_view->display();
/*
#----------第一种方式----------#
$dataList = $this->_modelWorkOrder->findByIdDetail ( $_GET ['Id'] ); //获取工单整个数组,包括关联表
$dialogArr = $dataList; //列表详细
$dataList = $dataList [0]; //客服与用户的对话数组
#------载入缓存------#
$gameTypeArr = Model::getTtwoArrConvertOneArr ( $this->_modelSysconfig->getValueToCache ( 'game_type' ), 'Id', 'name' ); //游戏类型
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache ( 'workorder_source' ); //工单来源
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache ( 'workorder_status' ); //工单状态
$gameSerList = $this->_modelGameSerList->findById ( $dataList ['game_server_id'] );
$operatorList = $this->_modelOperatorList->findById ( $dataList ['operator_id'] );
#------载入缓存------#
foreach ( $dialogArr as &$list ) {
$list ['qa_time'] = date ( 'Y-m-d H:i:s', $list ['qa_time'] );
}
$workOrderDetailArr = unserialize ( $dataList ['detail'] ); //获取工单的详细信息
$userData = $workOrderDetailArr ['user_data']; //获取提交工单用户的详细信息
$userQuestionDetail = $workOrderDetailArr ['form_detail']; //获取提问类型工单的值
$questionDetail = $this->_modelQuestionType->findById ( $dataList ['question_type'] ); //查找问题类型
$user=$this->_getGlobalData('user');
$departmentList=$this->_getGlobalData('department');
$departmentList=Model::getTtwoArrConvertOneArr($departmentList,'Id','name');
#------跟椐ID转换文字显示------#
$dataList ['word_question_type'] = $questionDetail ['title']; //获取问题类型的中文名称以方便显示
$dataList ['word_game_type'] = $gameTypeArr [$dataList ['game_type']];
$dataList ['word_source'] = $workOrderSourceArr [$dataList ['source']];
$dataList ['word_status'] = $workOrderStatusArr [$dataList ['status']];
$dataList ['word_game_server_id'] = $gameSerList ['server_name'];
$dataList ['word_operator_id'] = $operatorList ['operator_name'];
$dataList ['create_time'] = date ( 'Y-m-d H:i', $dataList ['create_time'] );
$dataList['word_quality_id']=($dataList['quality_id']<0)?$user[$dataList['quality_id']]['nick_name']."[{$departmentList[$user[$dataList['quality_id']]['department_id']]}]":'未质检';
#------跟椐ID转换文字显示------#
$questionDetail = $questionDetail ['form_table']; //获取问题类型的表单配置值
$userQuestionDetailArr = array (); //初始化显示提交问题类型数组
if ($questionDetail) {
foreach ( $questionDetail as $value ) { //将表单转换为key/value方式,方便显示
if ($value ['type'] == 'game_server_list')
continue; //如果为服务器列表将跳过,因为已经在工单上面有了.
switch ($value ['type']) {
case 'select' :
{
$userQuestionDetailArr [$value ['title']] = $value ['options'] [$userQuestionDetail [$value ['name']]];
break;
}
default :
{
$userQuestionDetailArr [$value ['title']] = $userQuestionDetail [$value ['name']];
break;
}
}
}
}
$this->_view->assign ( 'workOrderStatusArr', $workOrderStatusArr );
$this->_view->assign ( 'userData', $userData );
$this->_view->assign ( 'userQuestionDetailArr', $userQuestionDetailArr ); //问题类型显示
$this->_view->assign ( 'dialogArr', $dialogArr ); //对话详细
$this->_view->assign ( 'data', $dataList ); //表单详细信息
$this->_view->assign ( 'js', $this->_view->get_curJs () );
$this->_url ['Verify_OrderVerify']=Tools::url('Verify','OrderVerify',array('work_order_id'=>$_GET ['Id']));
$this->_view->assign('url',$this->_url);
$this->_view->display ();*/
#----------第一种方式----------#
}
/**
* 察看详细
*/
public function actionQualityDetail()
{
#------初始化------#
$this->_modelQuality = $this->_getGlobalData('Model_Quality', 'object');
#------初始化------#
if ($this->_isPost()) {
switch ($_POST['submit_type']) {
case '0':
//质检
$this->_utilMsg->showMsg(false);
break;
case '1':
//申诉
if ($this->_modelQuality->update(array('status' => $_POST['status'], 'complain_content' => $_POST['complain_content'], 'complain_time' => CURRENT_TIME), "Id={$_POST['Id']}")) {
$this->_utilMsg->showMsg(false);
} else {
$this->_utilMsg->showMsg('申请失败', -2);
}
break;
default:
//默认回复申诉
$updateArr = array('status' => $_POST['status'], 'reply_content' => $_POST['reply_content'], 'reply_time' => CURRENT_TIME);
if ($_POST['status'] == 3) {
$updateArr['scores'] = '0';
}
//如果申诉为同意申诉,将把扣分设置为0,不扣分;
if ($this->_modelQuality->update($updateArr, "Id={$_POST['Id']}")) {
$this->_utilMsg->showMsg(false);
} else {
$this->_utilMsg->showMsg('回复申诉失败', -2);
}
break;
}
} else {
#------初始化------#
$this->_modelWorkOrder = $this->_getGlobalData('Model_WorkOrder', 'object');
$this->_modelSysconfig = $this->_getGlobalData('Model_Sysconfig', 'object');
$this->_modelGameSerList = $this->_getGlobalData('Model_GameSerList', 'object');
$this->_modelOperatorList = $this->_getGlobalData('Model_OperatorList', 'object');
$this->_modelQuestionType = $this->_getGlobalData('Model_QuestionType', 'object');
$this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object');
$user = $this->_getGlobalData('user');
$this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object');
#------初始化------#
#------质检详细------#
$qualityOptions = $this->_getGlobalData('quality_options');
$qualityList = $this->_modelQuality->findByQaId($_GET['qa_id']);
$qualityList['word_option_id'] = $qualityOptions[$qualityList['option_id']];
$qualityList['word_status'] = $this->_statusOptions[$qualityList['status']];
$qualityList['word_quality_user_id'] = $user[$qualityList['quality_user_id']]['full_name'];
$qualityList['word_again_user_id'] = $user[$qualityList['again_user_id']]['full_name'];
$qualityList['reply_time'] = $qualityList['reply_time'] ? date('Y-m-d H:i:s', $qualityList['reply_time']) : '';
$qualityList['quality_time'] = $qualityList['quality_time'] ? date('Y-m-d H:i:s', $qualityList['quality_time']) : '';
$qualityList['complain_time'] = $qualityList['complain_time'] ? date('Y-m-d H:i:s', $qualityList['complain_time']) : '';
$qualityList['again_time'] = $qualityList['again_time'] ? date('Y-m-d H:i:s', $qualityList['again_time']) : '';
#------质检详细------#
$dataList = $this->_modelWorkOrder->findByIdDetail($_GET['work_order_id']);
//获取工单整个数组,包括关联表
if (!$dataList) {
$this->_utilMsg->showMsg('内容错误,请联系管理员', -2);
}
//防止错误
$dialogArr = $dataList;
//客服与用户的对话数组
$dataList = $dataList[0];
//列表详细
#------载入缓存------#
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
//游戏类型
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache('workorder_source');
//工单来源
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache('workorder_status');
//工单状态
$gameSerList = $this->_modelGameSerList->findById($dataList['game_server_id']);
$operatorList = $this->_modelOperatorList->findById($dataList['operator_id']);
#------载入缓存------#
$user = Model::getTtwoArrConvertOneArr($user, 'user_name', 'full_name');
foreach ($dialogArr as &$list) {
$list['qa_time'] = date('Y-m-d H:i:s', $list['qa_time']);
$list['word_reply_name'] = $user[$list['reply_name']];
}
$workOrderDetailArr = unserialize($dataList['detail']);
//获取工单的详细信息
$userData = $workOrderDetailArr['user_data'];
//获取提交工单用户的详细信息
$userData['register_date'] = date('Y-m-d H:i:s', $userData['register_date']);
$userQuestionDetail = $workOrderDetailArr['form_detail'];
//获取提问类型工单的值
$questionDetail = $this->_modelQuestionType->findById($dataList['question_type']);
//查找问题类型
#------跟椐ID转换文字显示------#
$dataList['word_question_type'] = $questionDetail['title'];
//获取问题类型的中文名称以方便显示
$dataList['word_game_type'] = $gameTypeArr[$dataList['game_type']];
$dataList['word_source'] = $workOrderSourceArr[$dataList['source']];
$dataList['word_status'] = $workOrderStatusArr[$dataList['status']];
$dataList['word_game_server_id'] = $gameSerList['server_name'];
$dataList['word_operator_id'] = $operatorList['operator_name'];
$dataList['create_time'] = date('Y-m-d H:i', $dataList['create_time']);
$dataList['word_quality_id'] = $user[$dataList['quality_id']]['full_name'];
#------跟椐ID转换文字显示------#
$questionDetail = $questionDetail['form_table'];
//获取问题类型的表单配置值
$userQuestionDetailArr = array();
//初始化显示提交问题类型数组
if (count($questionDetail)) {
foreach ($questionDetail as $value) {
//将表单转换为key/value方式,方便显示
if ($value['type'] == 'game_server_list') {
continue;
}
//如果为服务器列表将跳过,因为已经在工单上面有了.
switch ($value['type']) {
case 'select':
$userQuestionDetailArr[$value['title']] = $value['options'][$userQuestionDetail[$value['name']]];
break;
default:
$userQuestionDetailArr[$value['title']] = $userQuestionDetail[$value['name']];
break;
}
}
}
$this->_view->assign('qualityList', $qualityList);
$this->_view->assign('workOrderStatusArr', $workOrderStatusArr);
$this->_view->assign('userData', $userData);
$this->_view->assign('userQuestionDetailArr', $userQuestionDetailArr);
//问题类型显示
$this->_view->assign('dialogArr', $dialogArr);
//对话详细
$this->_view->assign('data', $dataList);
//表单详细信息
$this->_view->assign('userClass', $this->_utilRbac->getUserClass());
$this->_utilMsg->createNavBar();
$this->_view->display();
}
}
public function actionIndex()
{
#------初始化------#
$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');
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
$operatorList = $this->_getGlobalData('operator_list');
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
#------初始化------#
$userClass = $this->_utilRbac->getUserClass();
$roomId = $userClass['_roomId'];
if ($roomId) {
// $this->_utilMsg->showMsg('请先加入房间',-1,Tools::url('Group','Index'));
$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('请先设置用户运营商权限', -1, Tools::url('Group', 'Room'));
}
//如果用户没有权限将退出
$onlineUsers = $this->_utilOnline->getOnlineUser('user_id');
//在线用户,一维数组,value值为user_id
#------分页生成sql------#
$this->_loadCore('Help_SqlSearch');
$helpSqlSearch = new Help_SqlSearch();
$helpSqlSearch->set_tableName($this->_modelWorkOrder->tName());
// $helpSqlSearch->set_conditions("room_id={$roomId}"); //只显示房间内的
if ($_GET['Id']) {
$helpSqlSearch->set_conditions("Id={$_GET['Id']}");
$this->_view->assign('selectedId', $_GET['Id']);
}
if ($_GET['vip_level'] != '') {
//如果设置了vip等级,将显示等级
$helpSqlSearch->set_conditions("vip_level={$_GET['vip_level']}");
$this->_view->assign('selectedVipLevel', $_GET['vip_level']);
}
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');
}
$helpSqlSearch->set_conditions("owner_user_id={$userClass['_id']}");
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 = array('0' => '普通', '1' => '一级', '2' => '二级', '3' => '三级', '4' => '四级', '5' => '五级', '6' => '六级', '' => '所有');
$users = $this->_getGlobalData('user');
$serverList = $this->_getGlobalData('gameser_list');
$serverList = Model::getTtwoArrConvertOneArr($serverList, 'Id', 'server_name');
#------载入缓存------#
if ($dataList) {
Tools::import('Util_FontColor');
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_operator_id'] = $operatorList[$list['operator_id']];
$questionArr = $this->_modelQuestionType->findById($list['question_type']);
$list['word_question_type'] = $questionArr['title'] ? $questionArr['title'] : '游戏提问';
$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']];
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);
}
}
$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);
}
}
$this->_view->assign('dataList', $dataList);
}
$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('userClass', $userClass);
$this->_view->assign('userOperator', $userOperator);
$this->_view->assign('vipLevel', $vipLevel);
$workOrderStatusArr[''] = '所有';
$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 paySuccess($ordersn, $paySource, $params = null)
{
$sql = "select * from sline_member_order where ordersn='{$ordersn}'";
$arr1 = DB::query(1, $sql)->execute()->as_array();
$arr = $arr1[0];
if ($arr['status'] == 2) {
return true;
}
$configModel = new Model_Sysconfig();
$configs = $configModel->getConfig(0);
if (substr($ordersn, 0, 2) == 'dz') {
$ordertype = 'dz';
$updatesql = "update sline_dzorder set status=2,paysource='{$paySource}' where ordersn='{$ordersn}'";
} else {
$ordertype = 'sys';
$updatesql = "update sline_member_order set ispay=1,status=2,paysource='{$paySource}' where ordersn='{$ordersn}'";
//付款标志置为1,交易成功
}
DB::query(Database::UPDATE, $updatesql)->execute();
//logResult('更新成功');
//$subject='你成功预订'.$arr['productname'].'产品';
//$text="尊敬的{$arr['linkman']},你已经成功在{$GLOBALS['cfg_webname']}预订{$arr['productname']},数量{$arr['dingnum']}.";
//sendMsg($subject,$text,$arr['handletel'],$ordersn);
if ($ordertype != 'dz') {
$msgInfo = Common::getDefineMsgInfo($arr['typeid'], 3);
$memberModel = ORM::factory('member', $arr['memberid']);
$memberInfo = Common::getMemberInfo($arr['memberid']);
$nickname = !empty($memberInfo['nickname']) ? $memberInfo['nickname'] : $memberInfo['mobile'];
$orderAmount = Common::StatisticalOrderAmount($arr);
if (isset($msgInfo['isopen'])) {
$content = $msgInfo['msg'];
$content = str_replace('{#MEMBERNAME#}', $nickname, $content);
$content = str_replace('{#PRODUCTNAME#}', $arr['productname'], $content);
$content = str_replace('{#PRICE#}', $orderAmount['priceDescript'], $content);
$content = str_replace('{#NUMBER#}', $orderAmount['numberDescript'], $content);
$content = str_replace('{#TOTALPRICE#}', $orderAmount['totalPrice'], $content);
$content = str_replace('{#WEBNAME#}', $configs['cfg_webname'], $content);
$content = str_replace('{#ORDERSN#}', $ordersn, $content);
Common::sendMsg($memberInfo['mobile'], $nickname, $content);
//发送短信.
}
$emailInfo = Common::getEmailMsgConfig2($arr['typeid'], 3);
if ($emailInfo['isopen'] == 1 && !empty($memberInfo['email'])) {
// $nickname = !empty($memberInfo['nickname']) ? $memberInfo['nickname'] : $memberInfo['mobile'];
$title = "订单支付成功";
$content = $emailInfo['msg'];
$content = str_replace('{#MEMBERNAME#}', $nickname, $content);
$content = str_replace('{#PRODUCTNAME#}', $arr['productname'], $content);
$content = str_replace('{#PRICE#}', $orderAmount['priceDescript'], $content);
$content = str_replace('{#NUMBER#}', $orderAmount['numberDescript'], $content);
$content = str_replace('{#TOTALPRICE#}', $orderAmount['totalPrice'], $content);
$content = str_replace('{#WEBNAME#}', $configs['cfg_webname'], $content);
$content = str_replace('{#ORDERSN#}', $ordersn, $content);
$content = str_replace('{#EMAIL#}', $memberInfo['email'], $content);
Common::ordermaill($memberInfo['email'], $title, $content);
}
//支付成功后添加预订送积分
if (!empty($arr['jifenbook'])) {
$addjifen = intval($arr['jifenbook']);
$memberModel->jifen = $memberModel->jifen + $addjifen;
if ($memberModel->save()) {
Common::addJifenLog($arr['memberid'], "预订{$arr['productname']}获得积分{$addjifen}", $addjifen, 2);
}
}
//如果是酒店订单,则把子订单置为交易成功状态
if ($arr['typeid'] == 2) {
$s = "update sline_member_order set ispay=1,paysource='{$paySource}' where pid='{$arr['id']}'";
DB::query(Database::UPDATE, $s);
}
}
}
public static function ordermaill($maillto, $title, $content)
{
$configModel = new Model_Sysconfig();
$configs = $configModel->getConfig(0);
//如果没有自定义SMTP配置
if ($configs['cfg_mail_smtp'] == '') {
$configs['cfg_mail_smtp'] = "smtp.163.com";
}
if ($configs['cfg_mail_port'] == '') {
$configs['cfg_mail_port'] = 25;
}
if ($configs['cfg_mail_user'] == '') {
$configs['cfg_mail_user'] = "******";
$configs['cfg_mail_pass'] = "******";
}
$smtpserver = $configs['cfg_mail_smtp'];
//SMTP服务器
$smtpserverport = $configs['cfg_mail_port'];
//SMTP服务器端口
$smtpusermail = $configs['cfg_mail_user'];
//SMTP服务器的用户邮箱
$smtpemailto = $maillto;
//发送给谁
$smtpuser = $configs['cfg_mail_user'];
//SMTP服务器的用户帐号
$smtppass = $configs['cfg_mail_pass'];
//SMTP服务器的用户密码
$mailtype = "HTML";
//邮件格式（HTML/TXT）,TXT为文本邮件
##########################################
if ($smtpserverport == 25) {
$mailsubject = iconv('UTF-8', 'GB2312//IGNORE', $title);
//邮件主题
$mailbody = iconv('UTF-8', 'GB2312//IGNORE', $content);
//邮件内容
$smtp = new Smtp($smtpserver, $smtpserverport, true, $smtpuser, $smtppass);
//这里面的一个true是表示使用身份验证,否则不使用身份验证.
$smtp->debug = false;
//是否显示发送的调试信息
$status = $smtp->sendmail($smtpemailto, $smtpuser, $mailsubject, $mailbody, $mailtype);
} else {
$mail = new Mysendmail();
$mail->setServer($smtpserver, $smtpuser, $smtppass, 465, true);
//设置smtp服务器，到服务器的SSL连接
$mail->setFrom($smtpuser);
//设置发件人
$mail->setReceiver($smtpemailto);
//设置收件人，多个收件人，调用多次
$mail->setMail($title, $content);
//设置邮件主题、内容
$status = $mail->sendMail();
//发送
}
return $status;
}
/**
* 查看工单详细
*/
public function actionDetail()
{
$dataList = $this->_modelWorkOrder->findByIdToDetail($_GET['Id']);
$_REQUEST['operator_id'] = $dataList['operator_id'];
$this->_checkOperatorAct(true);
$dialogList = $this->_modelWorkOrderQa->findByWorkOrderId($_GET['Id']);
#------载入缓存------#
$gameTypeArr = Model::getTtwoArrConvertOneArr($this->_modelSysconfig->getValueToCache('game_type'), 'Id', 'name');
//游戏类型
$workOrderSourceArr = $this->_modelSysconfig->getValueToCache('workorder_source');
//工单来源
$workOrderStatusArr = $this->_modelSysconfig->getValueToCache('workorder_status');
//工单状态
$gameServerList = $this->_getGlobalData('gameser_list');
$TimeDifference = intval($gameServerList[$dataList['game_server_id']]['time_zone']) * 3600;
//时差
$gameServerList = Model::getTtwoArrConvertOneArr($gameServerList, 'Id', 'server_name');
$operatorList = $this->_getGlobalData('operator_list');
$operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name');
$user = $this->_getGlobalData('user_all');
$departmentList = $this->_getGlobalData('department');
$departmentList = Model::getTtwoArrConvertOneArr($departmentList, 'Id', 'name');
#------载入缓存------#
#------跟椐ID转换文字显示------#
$dataList['word_status'] = $workOrderStatusArr[$dataList['status']];
$dataList['word_game_type'] = $gameTypeArr[$dataList['game_type']];
$dataList['word_source'] = $workOrderSourceArr[$dataList['source']];
$dataList['word_game_server_id'] = $gameServerList[$dataList['game_server_id']];
$dataList['word_operator_id'] = $operatorList[$dataList['operator_id']];
$dataList['create_time'] = date('Y-m-d H:i:s', $dataList['create_time'] + $TimeDifference);
if ($TimeDifference) {
$dataList['create_time'] .= '(' . Tools::getLang('GAME_SERVER_TIME', 'Common') . ')';
}
$dataList['word_quality_id'] = $dataList['quality_id'] < 0 ? $user[$dataList['quality_id']]['nick_name'] . "[{$departmentList[$user[$dataList['quality_id']]['department_id']]}]" : '未质检';
$dataList['url_nick_name_detail_list'] = Tools::url('MyTask', 'Index', array('view_type' => 2, 'user_nickname' => $dataList['user_nickname']));
$dataList['url_change_verify'] = Tools::url(CONTROL, 'ChangeVerify', array('Id' => $dataList['Id'], 'verify' => $dataList['is_verify'] ? 0 : 1));
#------跟椐ID转换文字显示------#
foreach ($dialogList as &$list) {
$list['create_time'] = date('Y-m-d H:i:s', $list['create_time'] + $TimeDifference);
if ($TimeDifference) {
$list['create_time'] .= '(' . Tools::getLang('GAME_SERVER_TIME', 'Common') . ')';
}
$list["image"] = json_decode($list["image"], true);
$list['word_reply_name'] = $user[$list['user_id']]['full_name'];
}
$workOrderDetailArr = unserialize($dataList['content']);
//获取工单的详细信息
$userData = $workOrderDetailArr['user_data'];
//获取提交工单用户的详细信息
// $userData ['register_date'] =$userData ['register_date']? date ( 'Y-m-d H:i:s', $userData ['register_date'] ):'';
if ($userData['register_date']) {
$userData['register_date'] = date('Y-m-d H:i:s', $userData['register_date'] + $TimeDifference);
if ($TimeDifference) {
$userData['register_date'] .= '(' . Tools::getLang('GAME_SERVER_TIME', 'Common') . ')';
}
} else {
$userData['register_date'] = '';
}
if ($dataList['evaluation_status'] != 0) {
//如果已经评价
$playerEvaluation = $this->_getGlobalData('player_evaluation');
$evaluation = $playerEvaluation[$dataList['evaluation_status']];
$evaluation = $evaluation['title'];
if ($dataList['evaluation_status'] == 3) {
$evaluation .= '： ' . $playerEvaluation[3]['Description'][$dataList['evaluation_desc']];
}
$this->_view->assign('evaluation', $evaluation);
}
$userQuestionDetail = $workOrderDetailArr['form_detail'];
//获取提问类型工单的值
$questionDetail = $this->_modelQuestionType->findById($dataList['question_type']);
//查找问题类型
$dataList['word_question_type'] = $questionDetail['title'];
//获取问题类型的中文名称以方便显示
if ($dataList['source'] != 2) {
//如果工单不是从游戏里面来的话
$questionDetail = $questionDetail['form_table'];
//获取问题类型的表单配置值
$userQuestionDetailArr = array();
//初始化显示提交问题类型数组
if ($questionDetail) {
foreach ($questionDetail as $value) {
//将表单转换为key/value方式,方便显示
if ($value['type'] == 'game_server_list') {
continue;
}
//如果为服务器列表将跳过,因为已经在工单上面有了.
switch ($value['type']) {
case 'select':
$userQuestionDetailArr[$value['title']] = $value['options'][$userQuestionDetail[$value['name']]];
break;
default:
$userQuestionDetailArr[$value['title']] = $userQuestionDetail[$value['name']];
break;
}
}
}
}
#------发送短消息URL------#
$sendMsgUrl = array(1 => '', 2 => Tools::url('MasterFRG', 'SendMail', array('UserId[1]' => $userData['user_id'], 'server_id' => $dataList['game_server_id'], 'lock' => 1)), 3 => Tools::url('GmSftx', 'SendMsg', array('users[1]' => $userData['user_id'], 'server_id' => $dataList['game_server_id'], 'lock' => 1)));
$this->_view->assign('sendMsgUrl', $sendMsgUrl[$dataList['game_type']]);
//url
#------发送短消息URL------#
#------日志------#
$this->_modelOrderLog = $this->_getGlobalData('Model_OrderLog', 'object');
$this->_view->assign('log', $this->_modelOrderLog->getLog($_GET['Id']));
#------日志------#
unset($workOrderStatusArr[1]);
//删除待处理状态
unset($workOrderStatusArr[4]);
//删除被玩家删除状态
//玩家附加的信息(腾讯数据)
if (isset($workOrderDetailArr['ext'])) {
$this->_view->assign('userExt', $workOrderDetailArr['ext']);
}
$this->_view->assign('workOrderStatusArr', $workOrderStatusArr);
$this->_view->assign('userData', $userData);
$this->_view->assign('userQuestionDetailArr', $userQuestionDetailArr);
//问题类型显示
$this->_view->assign('dialogArr', $dialogList);
//对话详细
$this->_view->assign('data', $dataList);
//表单详细信息
$this->_view->assign('js', $this->_view->get_curJs());
$this->_url['Verify_OrderVerify'] = Tools::url('Verify', 'OrderVerify', array('work_order_id' => $_GET['Id'], 'game_type_id' => $dataList['game_type'], 'operator_id' => $dataList['operator_id'], 'game_server_id' => $dataList['game_server_id'], 'game_user_id' => $userData['user_id'], 'user_account' => urlencode($userData['user_account']), 'user_nickname' => urlencode($userData['user_nickname'])));
$this->_view->assign('url', $this->_url);
//加载游戏配置
$gameClass = $this->_getGlobalData($dataList['game_type'], 'game');
$isSendOrderReplay = true;
$isSendImage = false;
if ($gameClass) {
$isSendOrderReplay = $gameClass->_isSendOrderReplay;
$isSendImage = $gameClass->_sendImage;
}
$this->_view->assign('isSendOrderReplay', $isSendOrderReplay);
$this->_view->assign('isSendImage', $isSendImage);
$this->_utilMsg->createNavBar();
$this->_view->display();
}
private function _sysCreateCache()
{
$this->_modelSysconfig->createToCache();
$this->_utilMsg->showMsg('生成完成', 1);
}
public function action_ajax_saveconfig()
{
$model = new Model_Sysconfig();
$flag = $model->saveConfig($_POST);
echo json_encode(array('status' => $flag));
}
public static function createDefaultConfig($siteid)
{
$m = new Model_Sysconfig();
$m->writeConfig($siteid);
}
