/**
* 控制界面首页
*/
public function index($exam_pid = 0)
{
Fn::ajax_call($this, 'regenerateExamRecord', 'regenerateExamResults', 'endPlaceExam', 'regenerateSummaryReportData', 'regenerateReport', 'removeCronTaskReport');
$exam_pid = intval($exam_pid);
$param['exam_pid'] = 0;
$param['exam_isfree'] = 0;
$examlist = ExamModel::get_exam_list_all($param);
$exam = array();
if ($exam_pid > 0) {
$exam = ExamModel::get_exam($exam_pid);
}
if (!$exam) {
$exam = current($examlist);
}
$db = Fn::db();
/////////////////////////考试记录是否生成/////////////
$sql = "SELECT uid_data FROM rd_cron_task_place_student_paper ctps\n LEFT JOIN rd_exam_place ep ON ep.place_id = ctps.place_id\n WHERE ep.exam_pid ={$exam['exam_id']} AND ctps.status=2";
$uid_arr = $db->fetchCol($sql);
$paper_count = 0;
foreach ($uid_arr as $item) {
$paper_count += count(json_decode($item));
}
$sql = "SELECT COUNT(*) FROM rd_exam_place_student eps\n LEFT JOIN rd_exam_place ep ON ep.place_id = eps.place_id\n WHERE ep.exam_pid = {$exam['exam_id']}";
$student_count = $db->fetchOne($sql);
if ($paper_count == $student_count) {
$data['paper_status'] = true;
//考试记录是否完全生成
} else {
$data['paper_status'] = false;
}
/////////////////////////////////////////
$sql = "SELECT status FROM rd_cron_task_exam_result \n WHERE exam_pid = {$exam['exam_id']}";
$data['cter_status'] = $db->fetchOne($sql);
//////////////////////////////////////////
$sql = "SELECT DISTINCT(status) FROM rd_cron_task_report ctr \n LEFT JOIN rd_evaluate_rule er ON er.id = ctr.rule_id \n WHERE exam_pid = {$exam['exam_id']}";
$data['ctr_status'] = $db->fetchCol($sql);
////////////////////////////////////////
$data['exam'] = $exam;
$data['demo_exam'] = $this->demo_exam_list();
$data['examlist'] = $examlist;
$data['place'] = ExamPlaceModel::get_exam_place($exam_pid, 'MAX(end_time) as end_time');
$data['crontaskexamresult'] = ReportCommandModel::cronTaskExamResultInfo($exam['exam_id']);
$data['evaluerulelist'] = ReportCommandModel::cronTaskReportLists($exam['exam_id']);
$this->load->view('report_command/index', $data);
}
public function index()
{
Fn::ajax_call($this, 'removeExamRelate', 'setExamRelateFlag');
$data = array();
$cond_param = array('er_exampid' => 0);
$size = 15;
$page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $size;
$list = array();
$total = ZmossModel::examRelatelistCount($cond_param);
if ($total) {
$list = ZmossModel::examRelatelist($cond_param, $page, $size);
$er_exampid = array();
foreach ($list as $k => $val) {
$er_exampid[] = $val['er_examid'];
unset($list[$k]);
$list[$val['er_examid']] = $val;
}
$cond_param['er_exampid'] = implode(',', $er_exampid);
$list2 = ZmossModel::examRelatelist($cond_param);
$zmoss_examid = array();
foreach ($list2 as $item) {
$list[$item['er_exampid']]['child'][] = $item;
$zmoss_examid[] = $list[$item['er_exampid']]['er_zmoss_examid'];
}
$zmoss_examid = array_unique($zmoss_examid);
$data['examrelatelist'] = ZmossModel::examlist('*', array('exam_id' => implode(',', $zmoss_examid)));
}
$data['list'] = $list;
$data['admin_list'] = CpUserModel::get_cpuser_list();
// 分页
$purl = site_url('admin/zmoss/index/');
$data['pagination'] = multipage($total, $size, $page, $purl);
$data['er_flag'] = array('未同步', '进行中', '同步失败', '同步成功');
$data['is_setexamrelate_priv'] = $this->check_power_new('zmoss_setexamrelate', false);
$data['is_setexamrelatequestion_priv'] = $this->check_power_new('zmoss_setexamrelatequestion', false);
$data['is_sync_result_priv'] = $this->check_power_new('zmoss_sync', false);
$data['is_remove_priv'] = $this->check_power_new('zmoss_remove', false);
$data['is_showresult_priv'] = $this->check_power_new('exam_index', false);
// 模版
$this->load->view('zmoss/index', $data);
}
/**
* 编辑校区表单页面
* @param int $tc_id 要编辑的校区ID
*/
public function settcinfo($tc_id)
{
Fn::ajax_call($this, 'setTC');
$tc_id = intval($tc_id);
$data = array();
if ($tc_id) {
$data['tc_info'] = TrainingInstitutionModel::trainingCampusInfo($tc_id);
}
if (empty($data['tc_info'])) {
message('查询无记录', '/admin/traininginstitution/tilist');
}
$data['province_list'] = RegionModel::get_regions(1);
$data['city_list'] = RegionModel::get_regions($data['tc_info']['tc_provid'], FALSE, 2);
$data['area_list'] = RegionModel::get_regions($data['tc_info']['tc_cityid'], FALSE, 3);
$this->load->view('traininginstitution/settcinfo', $data);
}
/**
* @description 编辑学生信息表单页面
* @author
* @final
* @param int $uid 学生id
*/
public function edit($uid)
{
if (!$this->check_power('student_manage')) {
return;
}
Fn::ajax_call($this, 'baseFetchTIList', 'baseFetchCORSList', 'baseFetchCTeacherList');
/*
* 基本信息
*/
$uid = intval($uid);
$student = StudentModel::get_student($uid);
$school_id = array();
$volunteer = array();
if (empty($student)) {
message('信息不存在');
return;
}
$school = SchoolModel::schoolInfo($student['school_id'], 'school_id, school_name');
$student['school_name'] = $school['school_name'];
$student['birthday'] = date('Y-m-d', $student['birthday']);
if ($uid) {
$db = Fn::db();
$sbinfo = $db->fetchRow("SELECT * FROM t_student_base WHERE sb_uid = {$uid}");
if ($sbinfo) {
$student = array_merge($student, $sbinfo);
}
$sql = <<<EOT
SELECT sbs_stunumtype FROM t_student_base_stunumtype WHERE sbs_uid = {$uid}
EOT;
$student['sbs_stunumtype'] = $db->fetchCol($sql);
$sql = <<<EOT
SELECT sbclassid_classid FROM t_student_base_classid WHERE sbclassid_uid = {$uid}
EOT;
$student['sbclassid_classid'] = $db->fetchCol($sql);
$sql = <<<EOT
SELECT a.*,
b.ti_id, b.ti_name, b.ti_typeid, b.ti_flag, b.ti_provid, b.ti_cityid, b.ti_areaid,
c.cors_id, c.cors_cmid, c.cors_name, c.cors_flag, c.cors_tiid, c.cors_stunumtype
FROM t_student_base_course a
LEFT JOIN v_training_institution b ON a.sbc_tiid = b.ti_id
LEFT JOIN v_course c ON a.sbc_corsid = c.cors_id
WHERE a.sbc_uid = {$uid} AND a.sbc_idx = 0
EOT;
$sbcinfo = $db->fetchRow($sql);
if (is_array($sbcinfo)) {
$student = array_merge($student, $sbcinfo);
$student['no_tiid'] = 0;
} else {
$student['no_tiid'] = 1;
}
}
$data['student'] = $student;
$data['act'] = 'edit';
/*
* 学校列表
* 根据当前学生的年级获取拥有该年级的所有学校
*/
$grade_period = get_grade_period($student['grade_id']);
$query = $this->db->select('school_id,school_name')->like('grade_period', $grade_period)->get('school');
$data['school_list'] = $query->result_array();
$data['school_list'] || ($data['school_list'] = array());
/*
* 成绩排名
*/
$sql = <<<EOT
SELECT * FROM rd_student_ranking WHERE uid = ? ORDER BY grade_id ASC
EOT;
$data['score_ranks'] = Fn::db()->fetchAll($sql, $uid);
/*
* 竞赛成绩
*/
$sql = <<<EOT
SELECT * FROM rd_student_awards WHERE uid = ?
EOT;
$rows = Fn::db()->fetchAll($sql, $uid);
$awards_list = array();
foreach ($rows as $row) {
$awards_list[$row['typeid']][] = $row;
}
$data['awards_list'] = $awards_list;
/*
* 社会实践
*/
$sql = <<<EOT
SELECT * FROM rd_student_practice WHERE uid = ?
EOT;
$data['practice'] = Fn::db()->fetchRow($sql, $uid);
/*
* 学生意愿
*/
$sql = <<<EOT
SELECT * FROM rd_student_wish WHERE uid = ?
EOT;
$data['student_wish'] = Fn::db()->fetchRow($sql, $uid);
/*
* 家长意愿
*/
$sql = <<<EOT
SELECT * FROM rd_student_parent_wish WHERE uid = ?
EOT;
$data['parent_wish'] = Fn::db()->fetchRow($sql, $uid);
if (empty($data['parent_wish'])) {
// 初始化，防止模版notice错误
$data['parent_wish'] = array('family_bg' => '', 'upmethod' => '', 'wish' => '');
}
$school_id_arr = array();
$swv = Fn::db()->fetchOne("SELECT volunteer FROM rd_student_wish WHERE uid = {$uid}");
$school_id_arr = json_decode($swv);
if ($swv) {
foreach ($school_id_arr as $k => $v) {
$school_id[$k] = $v;
if ($v != 0) {
$volunteer[$k] = Fn::db()->fetchOne("SELECT school_name FROM rd_school WHERE school_id = {$v}");
}
}
}
//选考学考
$sql = <<<EOT
SELECT * FROM rd_xuekao_xuankao WHERE uid = ?
EOT;
$data['xuekao_xuankao'] = Fn::db()->fetchRow($sql, $uid);
// 公共数据
$specs = array('0' => '哲学', '1' => '经济学', '2' => '法学', '3' => '教育学', '4' => '文学', '5' => '历史学', '6' => '理学', '7' => '工学', '8' => '农学', '9' => '医学', '10' => '军事学', '11' => '管理学', '12' => '艺术类', '13' => '不清楚');
$data['grades'] = C('grades');
$data['grade_periods'] = C('grade_periods');
$data['subject_list'] = C('subject');
$data['awards_types'] = C('awards_type');
$data['awards_levels'] = C('awards_level');
$data['family_bg_list'] = C('family_bg');
$data['subjects'] = C('subject');
$data['specs'] = $specs;
$data['ranks'] = array('1' => 'A', '2' => 'B', '3' => 'C', '4' => 'E');
$data['school_id'] = $school_id;
$data['volunteer'] = $volunteer;
$data['province_list'] = RegionModel::get_regions(1);
$data['city_list'] = RegionModel::get_regions($student['sb_addr_provid'], FALSE, 2);
$data['area_list'] = RegionModel::get_regions($student['sb_addr_cityid'], FALSE, 3);
// 班级类型
$data['stunumtype_list'] = CourseModel::courseStuNumTypeList();
// 考试类型
$data['class_list'] = ClassModel::get_class_list($student['grade_id']);
// 培训机构类型
$data['tit_list'] = TrainingInstitutionModel::trainingInstitutionTypeList();
// 课程授课模式
$data['cm_list'] = CourseModel::courseModeList();
// 模版
$this->load->view('student/edit', $data);
}
/**
* 培训课程教师来源列表
*/
public function ctflist()
{
Fn::ajax_call($this, 'removeCTF', 'setCTF');
$data = array();
$data['ctf_list'] = CourseModel::courseTeachfromList();
$this->load->view('course/ctflist', $data);
}
/**
* 新增/编辑授课教师页面
* @param int $scht_schid 学校ID
* @param int $ct_id 授课教师ID,若为0表新增,否则表编辑
*/
public function editteacher($scht_schid = 0, $ct_id = 0)
{
if (!$scht_schid) {
message('参数错误');
}
$data = array();
$data['scht_schid'] = $scht_schid;
Fn::ajax_call($this, 'setSchoolTeacher');
$ct_id = intval($ct_id);
if ($ct_id) {
$data['ct_info'] = CTeacherModel::CTeacherInfo($ct_id);
if (empty($data['ct_info'])) {
message('查询无记录', 'admin/school/teacherlist/' . $scht_schid);
}
} else {
$data['ct_info'] = array('ct_id' => 0, 'ct_flag' => time());
}
$data['subject_map'] = C('subject');
$data['grade_map'] = C('grades');
$v = CTeacherModel::CTeacherGradeIDPairs($ct_id);
if (isset($v[$ct_id])) {
$v = $v[$ct_id];
} else {
$v = array();
}
$data['cteacher_gradeid'] = $v;
$v = CTeacherModel::CTeacherSubjectIDPairs($ct_id);
if (isset($v[$ct_id])) {
$v = $v[$ct_id];
} else {
$v = array();
}
$data['cteacher_subjectid'] = $v;
// 模版
$this->load->view('school/editteacher', $data);
}
/**
* 考试成绩查询
*/
public function examresult()
{
Fn::ajax_call($this, 'logout', 'login');
$uid = $this->_uinfo['uid'];
$data = array();
$data['page_title'] = '考试成绩';
$data['uinfo'] = $this->_uinfo;
if (!$uid) {
redirect('student/exam/index');
} else {
$data['student'] = StudentModel::get_student($this->_uinfo['uid']);
// 检查学生信息是否完善
// $check_message = $this->check_perfect_student();
if ($check_message) {
$data['check_message'] = $check_message;
} else {
$sql = <<<EOT
SELECT DISTINCT(e.exam_id), e.exam_name
FROM rd_exam e
JOIN rd_exam_result_publish erp ON e.exam_id = erp.exam_pid
JOIN rd_exam_place ep ON e.exam_id = ep.exam_pid
JOIN rd_exam_place_student eps ON ep.place_id = eps.place_id
WHERE eps.uid = {$uid}
EOT;
$exam_list = Fn::db()->fetchAssoc($sql);
if (!empty($exam_list)) {
$exam_pid_str = implode(',', array_keys($exam_list));
$sql = <<<EOT
SELECT exam_pid, id, subject_id FROM rd_evaluate_rule
WHERE exam_pid IN ({$exam_pid_str})
ORDER BY subject_id
EOT;
$rule_list = Fn::db()->fetchAll($sql);
foreach ($rule_list as $v) {
$source_path = $v['id'] . "/{$uid}.zip";
$filepath = realpath(dirname(APPPATH)) . "/cache/zip/report/" . $source_path;
if (!file_exists($filepath)) {
//continue;
}
if (!isset($exam_list[$v['exam_pid']]['list'])) {
$exam_list[$v['exam_pid']]['list'] = array();
}
$v['subject_name'] = $this->_subject_name($uid, $v['exam_pid'], $v['subject_id']);
$exam_list[$v['exam_pid']]['list'][] = $v;
}
asort($exam_list);
}
$data['exam_result_list'] = array_values($exam_list);
$data['subject'] = C('subject');
$data['subject'][0] = '总结';
if (C('sfe_data_gz')) {
$sql = <<<EOT
SELECT sfe_uid, sfe_exampid, sfe_placeid, sfe_starttime, sfe_endtime,
sfe_report_status, sfe_subjectid,
b.exam_name, c.place_name
FROM t_student_free_exam a
LEFT JOIN rd_exam b ON a.sfe_exampid = b.exam_id
LEFT JOIN rd_exam_place c ON a.sfe_placeid = c.place_id
WHERE sfe_uid = {$uid}
ORDER BY sfe_exampid DESC, sfe_placeid ASC
EOT;
$rows = Fn::db()->fetchAll($sql);
$exam_free_list = array();
$exam_free_map = array();
foreach ($rows as $row) {
$exam_pid = $row['sfe_exampid'];
$exam_free_list[] = $exam_pid;
if (!isset($exam_free_map[$exam_pid])) {
$exam_free_map[$exam_pid] = array();
}
$row['subject'] = explode(',', trim($row['sfe_subjectid']));
$exam_free_map[$exam_pid][] = $row;
}
$data['exam_free_list'] = array_unique($exam_free_list);
$data['exam_free_map'] = $exam_free_map;
} else {
$sql = <<<EOT
SELECT sfe_uid, sfe_exampid, sfe_placeid, sfe_starttime, sfe_endtime,
sfe_report_status, sfe_data,
b.exam_name, c.place_name
FROM t_student_free_exam a
LEFT JOIN rd_exam b ON a.sfe_exampid = b.exam_id
LEFT JOIN rd_exam_place c ON a.sfe_placeid = c.place_id
WHERE sfe_uid = {$uid}
ORDER BY sfe_exampid DESC, sfe_placeid ASC
EOT;
$rows = Fn::db()->fetchAll($sql);
$exam_free_list = array();
$exam_free_map = array();
foreach ($rows as $row) {
$exam_pid = $row['sfe_exampid'];
$exam_free_list[] = $exam_pid;
if (!isset($exam_free_map[$exam_pid])) {
$exam_free_map[$exam_pid] = array();
}
$v = json_decode($row['sfe_data'], true);
$row['subject'] = array_keys($v);
$exam_free_map[$exam_pid][] = $row;
}
$data['exam_free_list'] = array_unique($exam_free_list);
$data['exam_free_map'] = $exam_free_map;
}
}
}
$this->load->view('exam/examresult', $data);
}
/**
* 新增/编辑授课教师页面
* @param int $ct_id 授课教师ID,若为0表新增,否则表编辑
*/
public function setctinfo($ct_id)
{
Fn::ajax_call($this, 'setCT');
$ct_id = intval($ct_id);
$data = array();
if ($ct_id) {
$data['ct_info'] = CTeacherModel::CTeacherInfo($ct_id);
if (empty($data['ct_info'])) {
message('查询无记录', 'admin/cteacher/ctlist');
}
} else {
$data['ct_info'] = array('ct_id' => 0, 'ct_flag' => time());
}
$data['subject_map'] = C('subject');
$data['grade_map'] = C('grades');
//$data['subject_map'][0] = '[全部学科]';
//$data['grade_map'][0] = '[全部年级]';
$v = CTeacherModel::CTeacherGradeIDPairs($ct_id);
if (isset($v[$ct_id])) {
$v = $v[$ct_id];
} else {
$v = array();
}
$data['cteacher_gradeid'] = $v;
$v = CTeacherModel::CTeacherSubjectIDPairs($ct_id);
if (isset($v[$ct_id])) {
$v = $v[$ct_id];
} else {
$v = array();
}
$data['cteacher_subjectid'] = $v;
if ($ct_id) {
$sql = <<<EOT
SELECT a.cc_id, a.tc_name, b.ti_name, b.cors_name
FROM v_course_campus a
LEFT JOIN v_course b on a.cc_corsid = b.cors_id
WHERE a.cc_id IN (
SELECT cct_ccid FROM t_course_campus_teacher WHERE cct_ctid = {$ct_id})
EOT;
$data['cteacher_cclist'] = Fn::db()->fetchAll($sql);
}
$this->load->view('cteacher/setctinfo', $data);
}
public function resetpwd()
{
Fn::ajax_call($this, 'login', 'logout');
$hash = $this->input->get('code');
$uid = email_hash('decode', $hash, 1800);
$uid && ($student = StudentModel::get_student($uid));
if (!$student) {
message('重置链接已失效，请重新提交申请', 'student/index/forget');
}
if ($this->input->post('act') == 'submit') {
$password = $this->input->post('password');
$newpwd_confirm = $this->input->post('password_confirm');
if (is_string($passwd_msg = is_password($password))) {
message($passwd_msg);
}
if ($password != $newpwd_confirm) {
message('您两次输入密码不一致，返回请确认！');
}
$this->db->update('student', array('password' => my_md5($password)), array('uid' => $uid));
$now_time = time() - 1800;
$sql = "UPDATE {pre}user_resetpassword SET expiretime='{$now_time}' WHERE uid='{$uid}' and hash = '{$hash}'";
$row = $this->db->query($sql);
message('您的新密码已设置成功.', 'student/index/login', 'success');
} else {
$data = array();
$data['uinfo'] = StudentModel::studentLoginUInfo();
$data['hash'] = $hash;
// 模版
$this->load->view('index/resetpwd', $data);
}
}
/**
* 修改密码
*/
public function editpwd()
{
Fn::ajax_call($this, 'login', 'logout');
if (!$this->_uinfo['uid']) {
redirect('student/index/login');
}
$data = array();
$data['uinfo'] = $this->_uinfo;
$uid = $this->_uinfo['uid'];
if ($oldpwd = $this->input->post('oldpwd')) {
$newpwd = $this->input->post('newpwd');
$newpwd_confirm = $this->input->post('newpwd_confirm');
if (is_string($passwd_msg = is_password($newpwd))) {
message($passwd_msg);
}
if ($newpwd != $newpwd_confirm) {
message('新密码两次输入不一致！');
}
$query = $this->db->select('password')->get_where('student', array('uid' => $uid));
$user = $query->row_array();
if ($user['password'] !== my_md5($oldpwd)) {
message('原密码错误！');
}
$this->db->update('student', array('password' => my_md5($newpwd)), array('uid' => $uid));
message('密码修改成功！', 'student/profile/preview', 'success');
} else {
$this->load->view('profile/editpwd', $data);
}
}
