/**
* 详细统计
* @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();
}
