/** * 礼包卡号统计 */ public function actionLibaoCardState() { if (!$_REQUEST['game_type_id']) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'not game_type_id', 'data' => null)); } if (!$_REQUEST['server_mark']) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'not server_mark', 'data' => null)); } if (!$_REQUEST['type_id']) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'not type_id', 'data' => null)); } if (!$_REQUEST['time']) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'not time', 'data' => null)); } $this->_modelGameSerList = $this->_getGlobalData('Model_GameSerList', 'object'); $serverDetail = $this->_modelGameSerList->findByMarking($_REQUEST['game_type_id'], $_REQUEST['server_mark']); if (!$serverDetail) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'game server non-existent')); } $cardId = $_REQUEST['type_id']; $time = $_REQUEST['time']; $this->_utilApiFrg = $this->_getGlobalData('Util_ApiFrg', 'object'); $getArr = array('c' => 'Card', 'a' => 'ImportCard', 'doaction' => 'state'); $postArr = array('type_id' => $cardId, 'DateTime' => $time); $this->_utilApiFrg->addHttp($serverDetail['Id'], $getArr, $postArr); $this->_utilApiFrg->send(); $data = $this->_utilApiFrg->getResult(); if ($data) { $this->_returnAjaxJson(array('status' => 1, 'info' => null, 'data' => $data)); } else { $this->_returnAjaxJson(array('status' => 0, 'info' => 'game server error', 'data' => null)); } }
public function actionWorkOrderList() { $userInfo = array('user_account' => trim($_REQUEST['user_account']), 'game_user_id' => trim($_REQUEST['user_id']), 'user_nickname' => trim(urldecode($_REQUEST['user_nickname']))); $userInfo = array_filter($userInfo); //检查用户信息是否都为空 if (!$userInfo) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'player empty', 'data' => null)); } $gameId = intval($_REQUEST['game_id']); if (!$gameId) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'error game_id', 'data' => null)); } $serverMarking = trim($_REQUEST['server_marking']); if (empty($serverMarking)) { $this->_returnAjaxJson(array('status' => 0, 'info' => 'server_marking empty', 'data' => null)); } $this->_modelGameSerList = $this->_getGlobalData('Model_GameSerList', 'object'); $gameServerList = $this->_modelGameSerList->findByMarking($gameId, $serverMarking); if (!$gameServerList) { //未找到服务器 $this->_returnAjaxJson(array('status' => 0, 'info' => 'game server non-existent', 'data' => null)); } $status = intval($_REQUEST['status']); $ev = trim($_REQUEST['ev']); $page = max(1, intval($_REQUEST['page'])); $pageSize = intval($_REQUEST['page_size']); if ($pageSize < 1 || $pageSize > 100) { $pageSize = 10; } $this->_loadCore('Help_SqlSearch'); //载入sql工具 $this->_modelWorkOrder = $this->_getGlobalData('Model_WorkOrder', 'object'); $helpSqlSearch = new Help_SqlSearch(); $helpSqlSearch->set_tableName($this->_modelWorkOrder->tName()); $helpSqlSearch->set_field('Id as id,question_type as type,title,create_time as update_time,evaluation_status as ev,status,evaluation_desc as ev_desc,is_read'); //指定玩家 $helpSqlSearch->set_conditions(key($userInfo) . "='" . current($userInfo) . "'"); //来自游戏的工单 $helpSqlSearch->set_conditions('source=2'); //来自哪个游戏 $helpSqlSearch->set_conditions("is_vip='0'"); $helpSqlSearch->set_conditions("game_type={$gameId}"); //确定某个服务器 $helpSqlSearch->set_conditions("game_server_id={$gameServerList['Id']}"); //处理状态,0:待受理(包括:1未受理,2受理中),3:已答复 ,4:删除的 ,-1: 表示全部 if ($status != -1) { if ($status == 0) { $helpSqlSearch->set_conditions('status>=1'); $helpSqlSearch->set_conditions('status<=2'); } else { $helpSqlSearch->set_conditions('status=3'); } } else { $helpSqlSearch->set_conditions('status<>4'); } //评价状态 if ($ev == '0') { $helpSqlSearch->set_conditions('evaluation_status=0'); } elseif ($ev) { $helpSqlSearch->set_conditions('evaluation_status=' . intval($ev)); } //分页 $helpSqlSearch->setPageLimit($page, $pageSize); //排序 $helpSqlSearch->set_orderBy('is_read,Id desc'); $sql = $helpSqlSearch->createSql(); $conditions = $helpSqlSearch->get_conditions(); $dataList = $this->_modelWorkOrder->select($sql); $total = $this->_modelWorkOrder->findCount($conditions); $returnData = array('list' => $dataList, 'query_status' => $status, 'total' => $total, 'page' => $page); $this->_returnAjaxJson(array('status' => 1, 'info' => CONTROL . '_' . ACTION, 'data' => $returnData)); }
/** * 游戏内提问 */ private function _saveSource2() { $orderArr = array(); $orderArr['game_type'] = $_POST['game_id']; $orderArr['user_account'] = $_POST['user_account']; $orderArr['user_nickname'] = $_POST['user_nickname']; $orderArr['money'] = $_POST['money_total']; $orderArr['source'] = $_POST['source']; //工单来源 $orderArr['title'] = $_POST['title']; $orderArr['question_type'] = $_POST['question_type']; $orderArr['question_num'] = 1; $orderArr['create_time'] = CURRENT_TIME; if ($_FILES['image']) { $updateInfo = $this->_upload(); } //如果有上传图片就上传文件 $serverMarking = $_POST['server_marking']; $gameServerList = $this->_modelGameSerList->findByMarking($_POST['game_id'], $serverMarking); if (!$gameServerList) { //未找到服务器 $this->_returnAjaxJson(array('status' => 0, 'info' => 'game server non-existent', 'data' => null)); } $this->_modelGameOperator = $this->_getGlobalData('Model_GameOperator', 'object'); $gameOperatorIndex = $this->_modelGameOperator->findByGidOId($_POST['game_id'], $gameServerList['operator_id']); //找到此运营商的详细 资料. if (!$gameOperatorIndex) { //未找到游戏与运营商的索引 $this->_returnAjaxJson(array('status' => 0, 'info' => 'game server non-existent', 'data' => null)); } $orderArr['vip_level'] = $this->_modelGameOperator->getVipLevel($gameOperatorIndex['vip_setup']['vip_pay'], $_POST['money_total']); $orderArr['timeout'] = $this->_modelGameOperator->getTimeOut($gameOperatorIndex['vip_setup']['vip_timeout'], $orderArr['vip_level']); $orderArr['timeout'] *= 60; //换成秒 $orderArr['operator_id'] = $gameServerList['operator_id']; $orderArr['game_server_id'] = $gameServerList['Id']; if ($gameServerList['room_id']) { $orderArr['room_id'] = $gameServerList['room_id']; } if (!$this->_modelWorkOrder->add($orderArr)) { //创建表单失败 $this->_returnAjaxJson(array('status' => 0, 'info' => 'Failure to create order', 'data' => null)); } #------为房间工单数加1------# if ($orderArr['room_id']) { $this->_utilRooms = $this->_getGlobalData('Util_Rooms', 'object'); $roomCLass = $this->_utilRooms->getRoom($orderArr['room_id']); $roomCLass->addOrderNum(1); $roomCLass->setUpdateInfo(1); $roomCLass = null; } #------为房间工单数加1------# $workOrderId = $this->_modelWorkOrder->returnLastInsertId(); //获取工单id #------增加新的工单到队列------# if ($orderArr['room_id']) { $addOrder = array('Id' => $workOrderId, 'vip_level' => $orderArr['vip_level'], 'room_id' => $orderArr['room_id'], 'game_type_id' => $orderArr['game_type'], 'operator_id' => $orderArr['operator_id']); $this->_utilWorkOrder = $this->_getGlobalData('Util_WorkOrder', 'object'); $orderManageClass = $this->_utilWorkOrder->getOrderManage(); $orderManageClass->addOrder($addOrder); $orderManageClass->setUpdateInfo(1); $orderManageClass = null; } #------增加新的工单到队列------# $orderDetail = array(); $orderDetail['form_detail'] = array(); $orderDetail['user_data'] = array('user_id' => $_POST['user_id'], 'user_account' => $_POST['user_account'], 'user_nickname' => $_POST['user_nickname'], 'money_total' => $_POST['money_total'], 'money_month' => $_POST['money_month'], 'register_date' => $_POST['register_date'], 'ip' => $_POST['ip']); $orderDetail = serialize($orderDetail); $this->_modelWorkOrderDetail = $this->_getGlobalData('Model_WorkOrderDetail', 'object'); $this->_modelWorkOrderDetail->add(array('work_order_id' => $workOrderId, 'content' => $orderDetail)); #-----插入对话表------# $this->_modelWorkOrderQa = $this->_getGlobalData('Model_WorkOrderQa', 'object'); $content = $_POST['content']; if ($updateInfo['web_path']) { $content .= "<br>玩家截图:<br> <img src='{$updateInfo['web_path']}' />"; } $orderDialog = array('game_type_id' => $_POST['game_id'], 'operator_id' => $orderArr['operator_id'], 'work_order_id' => $workOrderId, 'qa' => '0', 'content' => $content, 'create_time' => CURRENT_TIME); $this->_modelWorkOrderQa->add($orderDialog); // if (!Tools::isUtf8($content))echo 'is not utf8'; #-----插入对话表------# $this->_returnAjaxJson(array('status' => 1, 'info' => null, 'data' => array('order_id' => $workOrderId, 'image_path' => $updateInfo['web_path']))); }
private function _saveSource4() { $orderArr = array(); $orderArr['game_type'] = intval($_POST['game_id']); $orderArr['is_vip'] = intval($_GET['is_vip']); $orderArr['user_account'] = $_POST['user_account'] ? $_POST['user_account'] : 0; $orderArr['user_nickname'] = trim($_POST['user_nickname']); $orderArr['money'] = intval($_POST['money_total']); $orderArr['source'] = intval(4); //工单来源 $orderArr['title'] = strip_tags($_POST['title']); $orderArr['question_type'] = intval($_POST['question_type']); $orderArr['question_num'] = 1; $orderArr['create_time'] = CURRENT_TIME; $orderArr['game_user_id'] = trim($_POST['user_id']); if ($_FILES['image']) { $updateInfo = $this->_upload(); //如果有上传图片就上传文件 } $serverMarking = trim($_POST['server_marking']); $gameServerList = $this->_modelGameSerList->findByMarking($_POST['game_id'], $serverMarking, $_POST['server_name']); if (!$gameServerList) { //未找到服务器 $this->_utilMsg->showMsg("game server non-existent", 1); // $this->_returnAjaxJson ( array ('status' => 0, 'info' => 'game server non-existent', 'data' => null ) ); } $this->_modelGameOperator = $this->_getGlobalData('Model_GameOperator', 'object'); $gameOperatorIndex = $this->_modelGameOperator->findByGidOId($_POST['game_id'], $gameServerList['operator_id']); //找到此运营商的详细 资料. if (!$gameOperatorIndex) { //未找到游戏与运营商的索引 $this->_utilMsg->showMsg("game server or operator non-existent", 1); // $this->_returnAjaxJson ( array ('status' => 0, 'info' => 'game server or operator non-existent', 'data' => null ) ); } //vip等级,如果从游戏中有传$_POST['vip_level']过来,就使用$_POST['vip_level'],否则使用配置值 $orderArr['vip_level'] = isset($_REQUEST['vip']) ? intval($_REQUEST['vip']) : $this->_modelGameOperator->getVipLevel($gameOperatorIndex['vip_setup']['vip_pay'], $_POST['money_total']); $orderArr['vip_level'] = min(6, $orderArr['vip_level']); $orderArr['timeout'] = $this->_modelGameOperator->getTimeOut($gameOperatorIndex['vip_setup']['vip_timeout'], $orderArr['vip_level']); $orderArr['timeout'] *= 60; //换成秒 $orderArr['is_verify'] = 0; $orderArr['operator_id'] = $gameServerList['operator_id']; $orderArr['game_server_id'] = $gameServerList['Id']; $orderArr['is_read'] = 0; if ($gameServerList['room_id']) { $orderArr['room_id'] = $gameServerList['room_id']; } if (!$this->_modelWorkOrder->add($orderArr)) { //创建表单失败 $this->_returnAjaxJson(array('status' => 0, 'info' => 'Failure to create order', 'data' => null)); } $workOrderId = $this->_modelWorkOrder->returnLastInsertId(); //获取工单id #------追加日志------# $this->_modelOrderLog = $this->_getGlobalData('Model_OrderLog', 'object'); $this->_modelOrderLog->addLog(array('game_type_id' => $orderArr['game_type'], 'operator_id' => $orderArr['operator_id'], 'server_id' => $orderArr['game_server_id'], 'Id' => $workOrderId), Model_OrderLog::ASK); #------追加日志------# #------增加新的工单到队列------# if ($orderArr['room_id']) { $addOrder = array('Id' => $workOrderId, 'vip_level' => $orderArr['vip_level'], 'room_id' => $orderArr['room_id'], 'game_type_id' => $orderArr['game_type'], 'operator_id' => $orderArr['operator_id']); $this->_utilWorkOrder = $this->_getGlobalData('Util_WorkOrder', 'object'); $orderManageClass = $this->_utilWorkOrder->getOrderManage(); $orderManageClass->addOrder($addOrder); $orderManageClass = null; } #------增加新的工单到队列------# $orderDetail = array(); $orderDetail['form_detail'] = array(); $orderDetail['user_data'] = array('user_id' => $_POST['user_id'], 'user_account' => $_POST['user_account'], 'user_nickname' => $_POST['user_nickname'], 'money_total' => isset($_POST['money_total']) ? $_POST['money_total'] : -1, 'money_month' => isset($_POST['money_month']) ? $_POST['money_month'] : -1, 'register_date' => !$_POST['register_date'] || $_POST['register_date'] == 'null' ? null : $_POST['register_date'], 'ip' => $_POST['ip']); //钻类型 if (isset($_POST['flatType'])) { $orderDetail['ext']['flatType']['desc'] = '钻类型'; switch ($_POST['flatType']) { case '1': $orderDetail['ext']['flatType']['value'] = '<font color="#FF9900">黄钻</font>'; break; case '10': $orderDetail['ext']['flatType']['value'] = '<font color="#0000FF">蓝钻</font>'; break; default: $orderDetail['ext']['flatType']['value'] = '<font color="#999999">无</font>'; } } //钻等级 if (isset($_POST['diamondLevel'])) { $orderDetail['ext']['diamondLevel'] = array('desc' => '钻等级', 'value' => $_POST['diamondLevel']); } //是否年费黄钻 if (isset($_POST['yearDiamond'])) { $orderDetail['ext']['yearDiamond'] = array('desc' => '是否年费', 'value' => $_POST['yearDiamond'] ? '是' : '否'); } //游戏VIP等级 if (isset($_POST['vip'])) { $orderDetail['ext']['vip'] = array('desc' => '游戏VIP等级', 'value' => $_POST['vip']); } $orderDetail = serialize($orderDetail); $this->_modelWorkOrderDetail = $this->_getGlobalData('Model_WorkOrderDetail', 'object'); $this->_modelWorkOrderDetail->add(array('work_order_id' => $workOrderId, 'content' => $orderDetail)); #-----插入对话表------# $retArr = array('order_id' => $workOrderId); $this->_modelWorkOrderQa = $this->_getGlobalData('Model_WorkOrderQa', 'object'); $content = strip_tags($_POST['content']); $content = str_replace(array('\\r\\n', '\\r'), chr(10), $content); $orderDialog = array('user_id' => 0, 'game_type_id' => $_POST['game_id'], 'operator_id' => $orderArr['operator_id'], 'work_order_id' => $workOrderId, 'qa' => '0', 'content' => $content, 'create_time' => CURRENT_TIME); if ($updateInfo && is_array($updateInfo)) { $_imgArr = array(); $i = ''; foreach ($updateInfo as $img) { $retArr["image_path{$i}"] = $img['web_path']; $i++; $_imgArr[] = str_replace(__ROOT__, '', $img["web_path"]); } $orderDialog['image'] = json_encode($_imgArr); } $this->_modelWorkOrderQa->add($orderDialog); //$orderArr["room_id"] if ($orderArr['room_id'] && $gameServerList['server_url'] && $_POST['user_id']) { $this->_autoreply($orderArr, $gameServerList['server_url']); } #-----插入对话表------# eaccelerator_rm('question_' . $orderArr['user_account']); eaccelerator_put('question_' . $orderArr['user_account'], md5($orderArr['user_account'] . $orderArr['title']), 60); $this->_utilMsg->showMsg("提交成功", 1); }