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