/** * 详细统计 * @param array $date * @param array $users */ public function statsDetail($date, $users, $gameIds = NULL, $operators = null) { #------获取工单总数统计------# $sql = "select evaluation_status,evaluation_desc,create_time,owner_user_id,is_verify,status from {$this->tName()} where create_time between {$date['start']} and {$date['end']} and owner_user_id in (" . implode(',', $users) . ")"; if ($gameIds) { if (is_array($gameIds)) { $gameIds = implode(',', $gameIds); } $sql .= " and game_type in ({$gameIds})"; } if ($operators) { if (is_array($operators)) { $operators = implode(',', $operators); } $sql .= " and operator_id in ({$operators})"; } // echo "<p>".$sql; $dataList = $this->select($sql); if ($dataList) { $evArr = array(); //1游戏BUG //2游戏设置不满意 //3回复不清晰 //4回复错误 //5客服服务态度恶劣 //6其他 $evaluationDesc = array(1 => 32, 2 => 32, 3 => 3, 4 => 3, 5 => 3, 6 => 32, '' => 3); //32扩展为游戏差评、3保留为服务差评 $workOrderList = array(); foreach ($dataList as $list) { $workOrderList['total']['total']['total']++; // $workOrderList['total']['total']['ev_'.$list['evaluation_status']]++; $workOrderList['total'][date('Y-m-d', $list['create_time'])]['total']++; // $workOrderList['total'][date('Y-m-d',$list['create_time'])]['ev_'.$list['evaluation_status']]++; if ($list['is_verify'] && in_array($list['status'], array(3, 4))) { $workOrderList['total']['total']['verify']++; $workOrderList['total'][date('Y-m-d', $list['create_time'])]['verify']++; $workOrderList[$list['owner_user_id']]['total']['verify']++; $workOrderList[$list['owner_user_id']][date('Y-m-d', $list['create_time'])]['verify']++; } $workOrderList[$list['owner_user_id']]['total']['total']++; // $workOrderList[$list['owner_user_id']]['total']['ev_'.$list['evaluation_status']]++; $workOrderList[$list['owner_user_id']][date('Y-m-d', $list['create_time'])]['total']++; // $workOrderList[$list['owner_user_id']][date('Y-m-d',$list['create_time'])]['ev_'.$list['evaluation_status']]++; //对差评进行扩展 if ($list['evaluation_status'] == 3) { $tmpEv = $evaluationDesc[$list['evaluation_desc']]; $workOrderList['total']['total']['ev_' . $tmpEv]++; $workOrderList[$list['owner_user_id']]['total']['ev_' . $tmpEv]++; $workOrderList['total'][date('Y-m-d', $list['create_time'])]['ev_' . $tmpEv]++; $workOrderList[$list['owner_user_id']][date('Y-m-d', $list['create_time'])]['ev_' . $tmpEv]++; } else { $workOrderList['total']['total']['ev_' . $list['evaluation_status']]++; $workOrderList[$list['owner_user_id']]['total']['ev_' . $list['evaluation_status']]++; $workOrderList['total'][date('Y-m-d', $list['create_time'])]['ev_' . $list['evaluation_status']]++; $workOrderList[$list['owner_user_id']][date('Y-m-d', $list['create_time'])]['ev_' . $list['evaluation_status']]++; } } } $allDay = Tools::getdateArr($date['start'], $date['end']); foreach ($users as $user) { foreach ($allDay as $key => $value) { if (!isset($workOrderList['total'][$key])) { $workOrderList['total'][$key] = array(); } if (!isset($workOrderList[$user][$key])) { $workOrderList[$user][$key] = array(); } } krsort($workOrderList[$user]); } krsort($workOrderList['total']); #------获取工单总数统计------# #------获取回复总记录数------# $this->_modelWorkOrderQa = $this->_getGlobalData('Model_WorkOrderQa', 'object'); $sql = "select is_timeout,user_id,create_time from {$this->_modelWorkOrderQa->tName()} where create_time between {$date['start']} and {$date['end']} and qa=1 and user_id in (" . implode(',', $users) . ")"; if ($gameIds) { $sql .= " and game_type_id in ({$gameIds})"; } if ($operators) { if (is_array($operators)) { $operators = implode(',', $operators); } $sql .= " and operator_id in ({$operators})"; } // echo "<p>".$sql; $dataList = $this->_modelWorkOrderQa->select($sql); if ($dataList) { $qaList = array(); foreach ($dataList as $list) { $qaList['total']['total']['total_reply']++; $qaList['total']['total']['timeout_' . $list['is_timeout']]++; $qaList['total'][date('Y-m-d', $list['create_time'])]['total_reply']++; $qaList['total'][date('Y-m-d', $list['create_time'])]['timeout_' . $list['is_timeout']]++; $qaList[$list['user_id']]['total']['total_reply']++; $qaList[$list['user_id']]['total']['timeout_' . $list['is_timeout']]++; $qaList[$list['user_id']][date('Y-m-d', $list['create_time'])]['total_reply']++; $qaList[$list['user_id']][date('Y-m-d', $list['create_time'])]['timeout_' . $list['is_timeout']]++; } } $allDay = Tools::getdateArr($date['start'], $date['end']); foreach ($users as $user) { foreach ($allDay as $key => $value) { if (!isset($qaList['total'][$key])) { $qaList['total'][$key] = array(); } if (!isset($qaList[$user][$key])) { $qaList[$user][$key] = array(); } } krsort($qaList[$user]); } krsort($qaList['total']); #------获取回复总记录数------# #------质检统计------# $this->_modelQuality = $this->_getGlobalData('Model_Quality', 'object'); $sql = "select quality_user_id,reply_user_id,scores,quality_time from {$this->_modelQuality->tName()} where quality_time between {$date['start']} and {$date['end']} and (quality_user_id in (" . implode(',', $users) . ") or reply_user_id in (" . implode(',', $users) . ")) "; if ($gameIds) { $sql .= " and game_type_id in ({$gameIds})"; } if ($operators) { $sql .= " and operator_id in ({$operators})"; } // echo "<p>".$sql; $dataList = $this->_modelQuality->select($sql); if ($dataList) { $qualityList = array(); foreach ($dataList as $list) { $qualityList['total']['total']['total_quality']++; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['total_quality']++; $qualityList['total']['total']['quality_num']++; $qualityList['total']['total']['reply_num']++; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['quality_num']++; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['reply_num']++; $qualityList[$list['quality_user_id']]['total']['quality_num']++; //质检回复量 $qualityList[$list['quality_user_id']][date('Y-m-d', $list['quality_time'])]['quality_num']++; $qualityList[$list['reply_user_id']]['total']['reply_num']++; //被质检回复量 $qualityList[$list['reply_user_id']][date('Y-m-d', $list['quality_time'])]['reply_num']++; if ($list['scores'] > 0) { $qualityList['total']['total']['bonus_num']++; $qualityList['total']['total']['bonus'] += $list['scores']; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['bonus_num']++; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['bonus'] += $list['scores']; $qualityList[$list['reply_user_id']]['total']['bonus_num']++; $qualityList[$list['reply_user_id']]['total']['bonus'] += $list['scores']; $qualityList[$list['reply_user_id']][date('Y-m-d', $list['quality_time'])]['bonus_num']++; $qualityList[$list['reply_user_id']][date('Y-m-d', $list['quality_time'])]['bonus'] += $list['scores']; } elseif ($list['scores'] < 0) { $qualityList['total']['total']['deduction_num']++; $qualityList['total']['total']['deduction'] += $list['scores']; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['deduction_num']++; $qualityList['total'][date('Y-m-d', $list['quality_time'])]['deduction'] += $list['scores']; $qualityList[$list['reply_user_id']]['total']['deduction_num']++; $qualityList[$list['reply_user_id']]['total']['deduction'] += $list['scores']; $qualityList[$list['reply_user_id']][date('Y-m-d', $list['quality_time'])]['deduction_num']++; $qualityList[$list['reply_user_id']][date('Y-m-d', $list['quality_time'])]['deduction'] += $list['scores']; } } } $allDay = Tools::getdateArr($date['start'], $date['end']); foreach ($users as $user) { foreach ($allDay as $key => $value) { if (!isset($qualityList['total'][$key])) { $qualityList['total'][$key] = array(); } if (!isset($qualityList[$user][$key])) { $qualityList[$user][$key] = array(); } } krsort($qualityList[$user]); } krsort($qualityList['total']); #------质检统计------# #------BUGLIST------# $this->_modelVerify = $this->_getGlobalData('Model_Verify', 'object'); $sql = "select user_id,finish_user_id,create_time from {$this->_modelVerify->tName()} where create_time between {$date['start']} and {$date['end']} and (user_id in (" . implode(',', $users) . ") or finish_user_id in (" . implode(',', $users) . "))"; if ($gameIds) { $sql .= " and game_type_id in ({$gameIds})"; } if ($operators) { $sql .= " and operator_id in ({$operators})"; } // echo "<p>".$sql; $dataList = $this->_modelVerify->select($sql); if ($dataList) { $bugList = array(); foreach ($dataList as $list) { $curTime = date('Y-m-d', $list['create_time']); $bugList['total']['total']['submit']++; $bugList['total'][$curTime]['submit']++; $bugList[$list['user_id']]['total']['submit']++; $bugList[$list['user_id']][$curTime]['submit']++; if ($list['finish_user_id']) { $bugList['total']['total']['finish']++; $bugList['total'][$curTime]['finish']++; $bugList[$list['finish_user_id']]['total']['finish']++; $bugList[$list['finish_user_id']][$curTime]['finish']++; } } } $allDay = Tools::getdateArr($date['start'], $date['end']); foreach ($users as $user) { foreach ($allDay as $key => $value) { if (!isset($bugList['total'][$key])) { $bugList['total'][$key] = array(); } if (!isset($bugList[$user][$key])) { $bugList[$user][$key] = array(); } } krsort($bugList[$user]); } krsort($bugList['total']); #------BUGLIST------# $arrayList = array(); $arrayList['total'] = array_merge_recursive($workOrderList['total'], $qaList['total'], $qualityList['total'], $bugList['total']); foreach ($users as $user) { $arrayList[$user] = array_merge_recursive($workOrderList[$user], $qaList[$user], $qualityList[$user], $bugList[$user]); } return $arrayList; }
/** * 我的查证处理 */ public function actionMyVerify() { $this->_loadCore('Help_SqlSearch'); $this->_loadCore('Help_Page'); $this->_helpSqlSearch = new Help_SqlSearch(); $this->_modelVerify = $this->_getGlobalData('Model_Verify', 'object'); $this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object'); $userClass = $this->_utilRbac->getUserClass(); $users = $this->_getGlobalData('user'); $users = Model::getTtwoArrConvertOneArr($users, 'Id', 'nick_name'); $verifyStatus = $this->_getGlobalData('verify_status'); $verifyType = $this->_getGlobalData('verify_type'); $verifyLevel = $this->_getGlobalData('verify_level'); $verifySource = $this->_getGlobalData('verify_source'); $gameType = $this->_getGlobalData('game_type'); $gameType = Model::getTtwoArrConvertOneArr($gameType, 'Id', 'name'); $operatorList = $this->_getGlobalData('operator_list'); $operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name'); $gameServerList = $this->_getGlobalData('gameser_list'); $gameServerListOneArr = Model::getTtwoArrConvertOneArr($gameServerList, 'Id', 'server_name'); $department = $this->_modelVerify->getDep(); $this->_helpSqlSearch->set_tableName($this->_modelVerify->tName()); $this->_helpSqlSearch->set_conditions("user_id={$userClass['_id']}"); if ($_REQUEST['Id']) { $this->_view->assign('selectedId', $_REQUEST['Id']); $this->_helpSqlSearch->set_conditions("Id={$_REQUEST['Id']}"); } if ($_REQUEST['department_id']) { $this->_view->assign('selectedDepartment', $_REQUEST['department_id']); $this->_helpSqlSearch->set_conditions("department_id={$_REQUEST['department_id']}"); } if ($_REQUEST['game_type_id']) { $this->_view->assign('selectedGameTypeId', $_REQUEST['game_type_id']); $this->_helpSqlSearch->set_conditions("game_type_id={$_REQUEST['game_type_id']}"); } if ($_REQUEST['operator_id']) { $this->_view->assign('selectedOperatorId', $_REQUEST['operator_id']); $this->_helpSqlSearch->set_conditions("operator_id={$_REQUEST['operator_id']}"); } if ($_REQUEST['game_server_id']) { $this->_view->assign('selectedGameServerId', $_REQUEST['game_server_id']); $this->_helpSqlSearch->set_conditions("game_server_id={$_REQUEST['game_server_id']}"); } if ($_REQUEST['status']) { $this->_view->assign('selectedStatus', $_REQUEST['status']); $this->_helpSqlSearch->set_conditions("status={$_REQUEST['status']}"); } if ($_REQUEST['type']) { $this->_view->assign('selectedType', $_REQUEST['type']); $this->_helpSqlSearch->set_conditions("type={$_REQUEST['type']}"); } if ($_REQUEST['level']) { $this->_view->assign('selectedLevel', $_REQUEST['level']); $this->_helpSqlSearch->set_conditions("level={$_REQUEST['level']}"); } $this->_helpSqlSearch->set_orderBy("Id desc"); $this->_helpSqlSearch->setPageLimit($_GET['page'], 20); $helpPage = new Help_Page(array('total' => $this->_modelVerify->findCount($this->_helpSqlSearch->get_conditions()), 'perpage' => 20)); $sql = $this->_helpSqlSearch->createSql(); $dataList = $this->_modelVerify->select($sql); if ($dataList) { Tools::import('Util_FontColor'); foreach ($dataList as &$value) { $verifyTypeToGameType = $this->_getVerifyTypeByGameType($value['game_type_id']); $value['word_game_type_id'] = $gameType[$value['game_type_id']]; $value['word_operator_id'] = $operatorList[$value['operator_id']]; $value['word_game_server_id'] = $gameServerListOneArr[$value['game_server_id']]; $value['word_status'] = $verifyStatus[$value['status']]; $value['word_type'] = $verifyTypeToGameType[$value['type']]; $value['word_level'] = Util_FontColor::getVerifyLevel($value['level'], $verifyLevel[$value['level']]); $value['create_time'] = date('Y-m-d H:i:s', $value['create_time']); $value['word_department_id'] = $department[$value['department_id']]; $value['url_detail'] = Tools::url(CONTROL, 'Detail', array('Id' => $value['Id'], 'work_order_id' => $value['work_order_id'])); $value['url_order_detail'] = Tools::url('WorkOrder', 'Detail', array('Id' => $value['work_order_id'])); $value['work_user_id'] = $users[$value['user_id']]; $value['word_source'] = Util_FontColor::getVerifySource($value['source'], $verifySource[$value['source']]); $value['content'] = strpos($value['content'], '\\') ? str_replace('\\', '', $value['content']) : $value['content']; if ($value['log']) { $value['log'] = unserialize($value['log']); } } $this->_view->assign('dataList', $dataList); } $this->_view->set_tpl(array('body' => 'Verify/Index.html')); $this->_view->assign('gameServerList', json_encode($gameServerList)); $this->_view->assign('department', $department); $this->_view->assign('verifyStatus', $verifyStatus); $this->_view->assign('verifyTypeJson', json_encode($verifyType)); $this->_view->assign('verifyLevel', $verifyLevel); $this->_view->assign('gameType', $gameType); $this->_view->assign('operatorList', $operatorList); $this->_view->assign('js', 'Verify/Index.js.html'); $this->_view->assign('pageBox', $helpPage->show()); $this->_utilMsg->createNavBar(); $this->_view->display(); }