/** * 所有被质检的回复 */ public function actionAllReply() { $this->_modelQuality = $this->_getGlobalData('Model_Quality', 'object'); $qualityOptions = $this->_getGlobalData('quality_options'); //评价 $this->_modelQuality = $this->_getGlobalData('Model_Quality', 'object'); $this->_loadCore('Help_Page'); #------生成sql------# $this->_loadCore('Help_SqlSearch'); $helpSqlSearch = new Help_SqlSearch(); $helpSqlSearch->set_tableName($this->_modelQuality->tName()); if ($_REQUEST['quality_option']) { $helpSqlSearch->set_conditions("option_id={$_REQUEST['quality_option']}"); $this->_view->assign('selectedQualityOption', $_REQUEST['quality_option']); } if ($_REQUEST['status_option']) { $helpSqlSearch->set_conditions("status={$_REQUEST['status_option']}"); $this->_view->assign('selectedStatusOption', $_REQUEST['status_option']); } $conditions = $helpSqlSearch->get_conditions(); $helpSqlSearch->set_orderBy("Id desc"); $helpPage = new Help_Page(array('total' => $this->_modelQuality->findCount($conditions), 'perpage' => PAGE_SIZE)); $sql = $helpSqlSearch->createSql(); #------生成sql------# $dataList = $this->_modelQuality->select($sql); if ($dataList) { Tools::import('Util_FontColor'); foreach ($dataList as &$value) { $value['quality_time'] = date('Y-m-d H:i:s', $value['quality_time']); $value['complain_time'] = $value['complain_time'] ? date('Y-m-d H:i:s', $value['complain_time']) : ''; $value['word_option_id'] = $qualityOptions[$value['option_id']]; $value['word_status'] = Util_FontColor::getQualityStatus($value['status'], $this->_statusOptions[$value['status']]); $value['url_detail'] = Tools::url(CONTROL, 'QualityDetail', array('work_order_id' => $value['work_order_id'], 'qa_id' => $value['qa_id'])); $value['reply_time'] = $value['reply_time'] ? date('Y-m-d H:i:s', $value['reply_time']) : ''; $users = $this->_getGlobalData('user'); $users = Model::getTtwoArrConvertOneArr($users, 'Id', 'full_name'); $value['word_quality_user_id'] = $users[$value['quality_user_id']]; } $this->_view->assign('dataList', $dataList); } $this->_statusOptions[''] = '所有'; $qualityOptions[''] = '所有'; $this->_view->assign('qualityOptions', $qualityOptions); $this->_view->assign('statusOptions', $this->_statusOptions); $this->_view->assign('js', $this->_view->get_curJs()); $this->_view->assign('pageBox', $helpPage->show()); $this->_utilMsg->createNavBar(); $this->_view->display(); }
/** * 我被质检过的回复 */ 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 actionAgainList() { #------初始化------# $this->_loadCore('Help_Page'); $this->_loadCore('Help_SqlSearch'); $helpSqlSearch = new Help_SqlSearch(); $this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object'); $this->_modelQuality = $this->_getGlobalData('Model_Quality', 'object'); $qualityStatus = $this->_getGlobalData('quality_status'); $qualityOptions = $this->_getGlobalData('quality_options'); $gameTypes = $this->_getGlobalData('game_type'); $gameTypes = Model::getTtwoArrConvertOneArr($gameTypes, 'Id', 'name'); $operatorList = Model::getTtwoArrConvertOneArr($this->_getGlobalData('operator_list'), 'Id', 'operator_name'); $againStatus = array('0' => '未通过', '1' => '通过'); #------初始化------# $selected = array(); //模板默认值 $users = $this->_getGlobalData('user'); $helpSqlSearch->set_tableName($this->_modelQuality->tName()); $helpSqlSearch->set_conditions('again_user_id is not null'); if ($_REQUEST['quality_user_id'] != '') { //质检 $helpSqlSearch->set_conditions("quality_user_id={$_REQUEST['quality_user_id']}"); $selected['quality_user_id'] = $_REQUEST['quality_user_id']; } if ($_REQUEST['again_user_id'] != '') { //复检 $helpSqlSearch->set_conditions("again_user_id={$_REQUEST['again_user_id']}"); $selected['again_user_id'] = $_REQUEST['again_user_id']; } if ($_REQUEST['again_status'] != '') { //复检状态 $helpSqlSearch->set_conditions("again_status={$_REQUEST['again_status']}"); $selected['again_status'] = $_REQUEST['again_status']; } if ($_REQUEST['start_time'] && $_REQUEST['end_time']) { $startTime = strtotime($_REQUEST['start_time']); $endTime = strtotime($_REQUEST['end_time']); $helpSqlSearch->set_conditions("again_time between {$startTime} and {$endTime}"); $selected['start_time'] = $_REQUEST['start_time']; $selected['end_time'] = $_REQUEST['end_time']; } $helpSqlSearch->set_orderBy('again_time desc'); $helpSqlSearch->setPageLimit($_GET['page']); $allConditions = $helpSqlSearch->get_conditions(); //返回所有条件 $helpPage = new Help_Page(array('total' => $this->_modelQuality->findCount($allConditions), 'perpage' => PAGE_SIZE)); $sql = $helpSqlSearch->createSql(); $dataList = $this->_modelQuality->select($sql); if ($dataList) { Tools::import('Util_FontColor'); foreach ($dataList as &$value) { $value['word_game_type_id'] = $gameTypes[$value['game_type_id']]; $value['word_operator_id'] = $operatorList[$value['operator_id']]; $value['again_time'] = date('Y-m-d H:i:s', $value['again_time']); $value['quality_time'] = date('Y-m-d H:i:s', $value['quality_time']); $value['complain_time'] = $value['complain_time'] ? date('Y-m-d H:i:s', $value['complain_time']) : ''; $value['word_option_id'] = $qualityOptions[$value['option_id']]; $value['word_status'] = Util_FontColor::getQualityStatus($value['status'], $this->_statusOptions[$value['status']]); $value['url_detail'] = Tools::url(CONTROL, 'QualityDetail', array('work_order_id' => $value['work_order_id'], 'qa_id' => $value['qa_id'])); $value['url_document'] = Tools::url(CONTROL, 'Document', array('doaction' => 'add', 'Id' => $value['Id'], 'qa_id' => $value['qa_id'], 'work_order_id' => $value['work_order_id'])); $value['word_quality_user_id'] = $users[$value['quality_user_id']]['nick_name']; $value['word_again_user_id'] = $users[$value['again_user_id']]['nick_name']; $value['word_reply_user_id'] = $users[$value['reply_user_id']]['nick_name']; $value['reply_content'] = strip_tags($value['reply_content']); $value['quality_content'] = strip_tags($value['quality_content']); $value['complain_content'] = strip_tags($value['complain_content']); $value['again_content'] = strip_tags($value['again_content']); $value['word_again_status'] = $againStatus[$value['again_status']]; } $this->_view->assign('dataList', $dataList); } $againStatus[''] = '所有'; $gameTypes[''] = '所有'; $this->_view->assign('againStatus', $againStatus); $this->_view->assign('gameTypes', $gameTypes); $this->_view->assign('users', $users); $this->_view->assign('selected', $selected); $this->_view->assign('pageBox', $helpPage->show()); $this->_utilMsg->createNavBar(); $this->_view->display(); }