/** * 所有被质检的回复 */ 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 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(); }