/** * 我被质检过的回复 */ public function actionMyReplyQulity() { #------初始化------# $this->_loadCore('Help_Page'); $this->_loadCore('Help_SqlSearch'); $this->_helpSqlSearch = new Help_SqlSearch(); $this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object'); $this->_modelReplyQulity = $this->_getGlobalData('Model_ReplyQulity', 'object'); $qualityStatus = $this->_getGlobalData('quality_status'); $qualityOptions = $this->_getGlobalData('quality_options'); #------初始化------# $allUser = $this->_getGlobalData('user'); $userClass = $this->_utilRbac->getUserClass(); $this->_helpSqlSearch->set_tableName($this->_modelReplyQulity->tName()); $this->_helpSqlSearch->set_conditions("user_id='{$userClass['_id']}'"); if ($_GET['option']) { $this->_helpSqlSearch->set_conditions("option_id={$_GET['option']}"); $this->_view->assign('selectedOption', $_GET['option']); } if ($_GET['status']) { $this->_helpSqlSearch->set_conditions("status={$_GET['status']}"); $this->_view->assign('selectedStatus', $_GET['status']); } if ($_GET['is_timeout'] != '') { $this->_helpSqlSearch->set_conditions("is_timeout={$_GET['is_timeout']}"); $this->_view->assign('selectedTimeout', $_GET['is_timeout']); } if ($_GET['scores']) { $this->_view->assign('selectedSource', $_GET['scores']); if ($_GET['scores'] == 1) { $this->_helpSqlSearch->set_conditions("scores<0"); } else { $this->_helpSqlSearch->set_conditions("scores>=0"); } } $this->_helpSqlSearch->set_orderBy('create_time desc'); $this->_helpSqlSearch->setPageLimit($_GET['page'], 20); $allConditions = $this->_helpSqlSearch->get_conditions(); //返回所有条件 $helpPage = new Help_Page(array('total' => $this->_modelReplyQulity->findCount($allConditions), 'perpage' => 20)); $sql = $this->_helpSqlSearch->createSql(); $dataList = $this->_modelReplyQulity->select($sql); if ($dataList) { Tools::import('Util_FontColor'); foreach ($dataList as &$value) { $value['create_time'] = date('Y-m-d H:i:s', $value['create_time']); $value['url_detail'] = Tools::url('QualityCheck', 'QualityDetail', array('work_order_id' => $value['work_order_id'], 'qa_id' => $value['qa_id'])); $value['word_quality_user_id'] = $allUser[$value['quality_user_id']]['nick_name']; $value['word_status'] = Util_FontColor::getQualityStatus($value['status'], $qualityStatus[$value['status']]); $value['content'] = strip_tags($value['content']); $value['word_option_id'] = $qualityOptions[$value['option_id']]; } $this->_view->assign('dataList', $dataList); } $qualityStatus[''] = Tools::getLang('ALL', 'Common'); $qualityOptions[''] = Tools::getLang('ALL', 'Common'); $this->_view->assign('qualityStatus', $qualityStatus); $this->_view->assign('qualityOptions', $qualityOptions); $this->_view->assign('scores', Tools::getLang('SOURCE', __CLASS__)); $this->_view->assign('timeout', Tools::getLang('TIMEOUT', __CLASS__)); $this->_view->assign('pageBox', $helpPage->show()); $this->_view->assign('js', $this->_view->get_curJs()); $this->_utilMsg->createNavBar(); $this->_view->display(); }
/** * 运营商按天数统计 */ public function actionOperatorDay() { $operatorList = $this->_getGlobalData('operator_list'); $operatorList = Model::getTtwoArrConvertOneArr($operatorList, 'Id', 'operator_name'); $gameTypeList = $this->_getGlobalData('game_type'); $gameTypeList = Model::getTtwoArrConvertOneArr($gameTypeList, 'Id', 'name'); $this->_modelGameOperator = $this->_getGlobalData('Model_GameOperator', 'object'); $gameOperatorIndex = $this->_modelGameOperator->findAll(); foreach ($gameOperatorIndex as &$value) { $value['word_operator_id'] = $operatorList[$value['operator_id']]; } if ($this->_isPost()) { if (empty($_POST['date'])) { $this->_utilMsg->showMsg('统计日期不能为空', -2); } if (empty($_POST['game_type_id']) || !count($_POST['operator_id'])) { $this->_utilMsg->showMsg('请选译游戏,和运营商', -2); } $curDate = $_POST['date']; $this->_view->assign('selectedGameTypeId', $_POST['game_type_id']); $selectedOperatorList = array(); foreach ($_POST['operator_id'] as $operatorId) { if (array_key_exists($operatorId, $operatorList)) { $selectedOperatorList[$operatorId] = $operatorList[$operatorId]; } } $this->_view->assign('selectedOperatorIds', $_POST['operator_id']); $this->_view->assign('selectedOperatorList', $selectedOperatorList); $this->_view->assign('selectedDate', $curDate); $date['start'] = strtotime($curDate); $date['end'] = $date['start'] + 24 * 60 * 60 - 1; $this->_modelWorkOrder = $this->_getGlobalData('Model_WorkOrder', 'object'); $this->_modelWorkOrderQa = $this->_getGlobalData('Model_WorkOrderQa', 'object'); $this->_modelReplyQulity = $this->_getGlobalData('Model_ReplyQulity', 'object'); $workOrderTotal = $this->_modelWorkOrder->getOperatorDayStatsNum($_POST['game_type_id'], $_POST['operator_id'], $date); $workOrderQaTotal = $this->_modelWorkOrderQa->getOperatorDayStatsNum($_POST['game_type_id'], $_POST['operator_id'], $date); $replyQulityTotal = $this->_modelReplyQulity->getOperatorDayStatsNum($_POST['game_type_id'], $_POST['operator_id'], $date); if (is_array($workOrderQaTotal) && is_array($replyQulityTotal) && is_array($workOrderTotal)) { $total = array(); for ($i = 0; $i <= 23; $i++) { if (!$workOrderQaTotal[$i]) { $workOrderQaTotal[$i] = array(); } if (!$replyQulityTotal[$i]) { $replyQulityTotal[$i] = array(); } if (!$workOrderTotal[$i]) { $workOrderTotal[$i] = array(); } $total[$i] = array_merge($workOrderQaTotal[$i], $replyQulityTotal[$i], $workOrderTotal[$i]); } if (!$workOrderQaTotal['total']) { $workOrderQaTotal['total'] = array(); } if (!$replyQulityTotal['total']) { $replyQulityTotal['total'] = array(); } if (!$workOrderTotal['total']) { $workOrderTotal['total'] = array(); } $total['total'] = array_merge($workOrderQaTotal['total'], $replyQulityTotal['total'], $workOrderTotal['total']); } $this->_view->assign('total', $total); $this->_view->assign('displayTrue', true); } $this->_view->assign('js', $this->_view->get_curJs()); $this->_view->assign('gameOperatorIndex', json_encode($gameOperatorIndex)); $this->_view->assign('gameTypeList', $gameTypeList); $this->_utilMsg->createNavBar(); $this->_view->display(); }