public function edit($id = 0) { if (!$this->check_power('skill_manage')) { return; } $id = intval($id); $id && ($row = SkillModel::get_skill($id)); if (empty($row)) { message('技能不存在'); return; } if (!QuestionModel::check_subject_power($row['subject_id'], 'w')) { return; } $data['row'] = $row; $data['subjects'] = CpUserModel::get_allowed_subjects(); // 模版 $this->load->view('skill/edit', $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); }
public function index($type_id = 0) { if (!$this->check_power('comparison_list,comparison_manage')) { return; } if ($type_id = intval($type_id)) { $type_detail = ComparisonTypeModel::get_comparison_type_by_id($type_id); } if (empty($type_detail)) { message('对比信息分类不存在!', site_url('admin/comparison_type/index')); } $size = C('admin_page_size'); $page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1; $order_by = 'cmp_info_year DESC'; $select_what = 'cmp_info_id,cmp_info_year,cmp_info_score,updatetime,addtime'; // 查询条件 $condition = $param = $search = array(); $condition['cmp_type_id'] = $type_id; // 获取数据 $total = ComparisonInfoModel::get_comparison_info_count($condition); $list = array(); if ($total) { $list = ComparisonInfoModel::get_comparison_info_list($condition, $page, $size, $order_by, $select_what); } $data['type_detail'] =& $type_detail; $data['list'] =& $list; $data['search'] =& $search; // 分页 $purl = site_url('admin/comparison_info/index/' . $type_id) . ($param ? '?' . implode('&', $param) : ''); $data['pagination'] = multipage($total, $size, $page, $purl); // 学科、类型 $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['class_list'] = ClassModel::get_class_list(); $data['priv_manage'] = $this->check_power('comparison_manage', FALSE); // 模版 $this->load->view('comparison_info/index', $data); }
/** * @description 修改组题规则 * * @param int $id 规则id * @return void */ public function edit($id = 0) { if ($id = intval($id)) { $query = $this->db->get_where('exam_rule', array('rule_id' => $id)); $rule = $query->row_array(); $rule['is_original'] = explode(',', $rule['is_original']); } if (empty($rule)) { message('规则不存在'); return; } $rule['ques_num'] = explode(',', $rule['ques_num']); /** 组题规则限制 */ $rule_limits = $this->db->get_where('exam_rule_qtype_limit', array('exam_rule_id' => $id))->result_array(); $rule_limit = array(); if ($rule_limits) { foreach ($rule_limits as $key => $item) { $rule_limit[$item['qtype']][] = $item; } } /* * 读取知识点名称,以及相应试题数量 */ $knowledge_list = array(); $knowledge_parents = array(); $knowledge_ids = explode(',', $rule['knowledge_ids']); foreach ($knowledge_ids as $kid) { $knowledge = KnowledgeModel::get_konwledge_ques_num($kid); $knowledge_list[$kid] = $knowledge; if ($knowledge['pid'] && !isset($knowledge_parents[$knowledge['pid']])) { $knowledge_parents[$knowledge['pid']] = KnowledgeModel::get_konwledge_ques_num($knowledge['pid']); } } if ($rule['subject_id'] == 11) { $sql = "SELECT distinct(subject_id) FROM {pre}knowledge WHERE id IN ({$rule['knowledge_ids']})"; foreach ($this->db->query($sql)->result_array() as $item) { $data['subject_ids'][] = $item['subject_id']; } } /* * 重点知识点 */ $sub_rules = array(); $query = $this->db->get_where('exam_rule_knowledge', array('rule_id' => $id)); foreach ($query->result_array() as $row) { $row['pid'] = isset($knowledge_list[$row['knowledge_id']]['pid']) ? $knowledge_list[$row['knowledge_id']]['pid'] : 0; $row['nums'] = explode(',', $row['setting']); $sub_rules[] = $row; } usort($knowledge_list, 'cmp_knowledge'); foreach ($knowledge_list as $val) { $knowledge_parents[$val['pid']]['next'][] = $val; } usort($knowledge_parents, 'cmp_knowledge'); unset($knowledge_list); // 加载分类数据 $class_list = ClassModel::get_class_list(); $grades = C('grades'); $subjects = CpUserModel::get_allowed_subjects(); $data['act'] = 'edit'; $data['rule'] = $rule; $data['rule_limit'] = $rule_limit; $data['sub_rules'] = $sub_rules; $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['all_subjects'] = C('subject'); $data['grades'] = C('grades'); $data['subject_types'] = C('subject_type'); $data['class_list'] = $class_list; $data['knowledge_list'] = $knowledge_parents; $data['know_process'] = C('know_process'); $data['q_tags'] = C('q_tags'); // 模版 $this->load->view('exam_rule/edit', $data); }
/** * 试题列表 * * @return void */ public function index() { // 加载分类数据 $class_list = ClassModel::get_class_list(); //限制只能查看所属学科 $subjects = CpUserModel::get_allowed_subjects(); $grades = C('grades'); $qtypes = C('qtype'); $knowledge_list = KnowledgeModel::get_knowledge_list(); // 查询条件 $where = array(); $param = array(); $search = array(); $where[] = "q.parent_id=0"; // 过滤题组子题目,在题组页面管 $where[] = "q.is_delete <> 1"; /* 真题不需要审核 */ $where[] = "q.is_original <> 2"; // 录入人员 if ($search['admin_id'] = intval($this->input->get('admin_id'))) { $where[] = "q.admin_id={$search['admin_id']}"; $param[] = "admin_id={$search['admin_id']}"; } //限制只能查看自己创建的试题 if (!$this->is_super_user() && !CpUserModel::is_action_type_all('question', 'r') && !CpUserModel::is_action_type_subject('question', 'r') && CpUserModel::is_action_type_self('question', 'r')) { $c_uid = $this->session->userdata('admin_id'); $search['admin_id'] = $c_uid; $param[] = "admin_id={$c_uid}"; $where[] = "q.admin_id='{$c_uid}'"; } // 操作时间 $begin_time = $this->input->get('begin_time'); $end_time = $this->input->get('end_time'); if ($btime = (int) strtotime($begin_time)) { $search['begin_time'] = $begin_time; $where[] = "q.addtime >= {$btime}"; $param[] = "begin_time={$begin_time}"; } else { $search['begin_time'] = ''; } if ($etime = (int) strtotime($end_time)) { $etime += 86400; $search['end_time'] = $end_time; $where[] = "q.addtime < {$etime}"; $param[] = "end_time={$end_time}"; } else { $search['end_time'] = ''; } // 分组 if ($search['group_id'] = intval($this->input->get('group_id'))) { $where[] = "q.group_id={$search['group_id']}"; $param[] = "group_id={$search['group_id']}"; } // 题型 $search['type'] = $this->input->get('qtype'); if (strlen($search['type']) > 0) { $search['type'] = intval($search['type']); $where[] = "q.type={$search['type']}"; $param[] = "qtype={$search['type']}"; } // 考试方式 $search['test_way'] = $this->input->get('test_way'); if (strlen($search['test_way']) > 0) { $search['test_way'] = intval($search['test_way']); $where[] = "q.test_way IN ({$search['test_way']}, 3)"; $param[] = "test_way={$search['test_way']}"; } // 审核 $search['check'] = $this->input->get('check'); if (strlen($search['check']) > 0) { $search['check'] = intval($search['check']); $where[] = "q.check={$search['check']}"; $param[] = "check={$search['check']}"; } if ($search['subject_id'] = intval($this->input->get('subject_id'))) { $where[] = "q.subject_id={$search['subject_id']}"; $param[] = "subject_id={$search['subject_id']}"; $knowledge_parents = KnowledgeModel::get_knowledge_list($search['subject_id'], 0); } //信息提取方式 if ($search['group_type_id'] = intval($this->input->get('group_type_id'))) { $where[] = "q.group_type LIKE '%," . $search['group_type_id'] . ",%'"; $param[] = "group_type_id=" . $search['group_type_id']; } if ($search['group_type_pid'] = intval($this->input->get('group_type_pid'))) { $param[] = "group_type_pid=" . $search['group_type_pid']; if (isset($group_type_list[$search['group_type_pid']]['childlist']) && !$search['group_type_id']) { $group_type = $group_type_list[$search['group_type_pid']]['childlist']; $tmp_str = ''; foreach ($group_type as $item) { if ($tmp_str) { $tmp_str .= " OR q.group_type LIKE '%," . $item['id'] . ",%'"; } else { $tmp_str .= "q.group_type LIKE '%," . $item['id'] . ",%'"; } } $where[] = "(" . $tmp_str . ")"; } } // 题目类型 $search['is_original'] = $this->input->get('is_original'); $search['exam_year'] = $this->input->get('exam_year'); $search['remark'] = $this->input->get('remark'); if ($search['is_original'] > 0) { $search['is_original'] = intval($search['is_original']); $where[] = "q.is_original={$search['is_original']}"; $param[] = "is_original={$search['is_original']}"; //真题年份 if ($search['is_original'] == 2 && strlen($search['exam_year']) > 0) { $search['exam_year'] = intval($search['exam_year']); $where[] = "q.exam_year='{$search['exam_year']}'"; $param[] = "exam_year={$search['exam_year']}"; } // 真题备注关键词 if ($search['is_original'] == 2 && strlen($search['remark']) > 0) { $search['remark'] = $search['remark']; $where[] = "q.remark like '%" . $search['remark'] . "%'"; $param[] = "remark={$search['remark']}"; } } //标签 if ($search['tags'] = $this->input->get('tags')) { $tmp_item = explode('-', $search['tags']); if (strlen($search['type']) > 0) { $where[] = "q.tags = " . $tmp_item[1]; $param[] = "tags=" . $search['tags']; } else { $where[] = "q.type = " . $tmp_item[0] . " AND q.tags = " . $tmp_item[1]; $param[] = "tags=" . $search['tags']; } } //限制只能查看所属学科 if (!$this->is_super_user() && !$this->is_all_subject_user() && !CpUserModel::is_action_type_all('question', 'r') && CpUserModel::is_action_type_subject('question', 'r')) { $c_subject_id = rtrim($this->session->userdata('subject_id'), ','); if ($c_subject_id != '') { $c_subject_id = explode(',', $c_subject_id); $c_subject_id = array_values(array_filter($c_subject_id)); $c_subject_id = implode(',', $c_subject_id); $where[] = "q.subject_id in({$c_subject_id})"; } } //限制只能查看所属年级 if (!$this->is_super_user() && !$this->is_all_grade_user()) { $c_grade_id = rtrim($this->session->userdata('grade_id'), ','); if ($c_grade_id != '') { $c_grade_id = explode(',', $c_grade_id); $c_grade_id = array_values(array_filter($c_grade_id)); $c_grade_id = implode(',', $c_grade_id); $where_3 = " grade_id in({$c_grade_id})"; } else { $where_3 = '1=1'; } } else { $where_3 = '1=1'; } //限制只能查看所属类型 if (!$this->is_super_user() && !$this->is_all_q_type_user()) { $c_q_type_id = rtrim($this->session->userdata('q_type_id'), ','); if ($c_q_type_id != '') { $c_q_type_id = explode(',', $c_q_type_id); $c_q_type_id = array_values(array_filter($c_q_type_id)); $c_q_type_id = implode(',', $c_q_type_id); $where_4 = "class_id in ({$c_q_type_id})"; } else { $where_4 = '1=1'; } } else { $where_4 = '1=1'; } if ($where_3 != '1=1' || $where_4 != '1=1') { $where[] = "q.ques_id IN (SELECT DISTINCT ques_id FROM rd_relate_class WHERE {$where_3} AND {$where_4}) "; } if ($search['subject_id_str'] = $this->input->get('subject_str')) { $param[] = implode('&subject_str[]=', $search['subject_id_str']); $search['subject_id_str'] = implode(',', $search['subject_id_str']); $where[] = "q.subject_id_str = '," . $search['subject_id_str'] . ",'"; } //-----------------------------------------// // 年级区间、试题类型、难易度区间、文理科 //-----------------------------------------// $search['start_grade'] = intval($this->input->get('start_grade')); $search['end_grade'] = intval($this->input->get('end_grade')); $search['class_id'] = $this->input->get('class_id'); $search['start_difficulty'] = floatval($this->input->get('start_difficulty')); $search['end_difficulty'] = floatval($this->input->get('end_difficulty')); $search['subject_type'] = trim($this->input->get('subject_type')); if (is_array($search['class_id'])) { $search['class_id'] = my_intval($search['class_id']); } else { $search['class_id'] = array(); } if ($search['class_id'] or $search['start_difficulty'] or $search['end_difficulty'] or is_numeric($search['subject_type'])) { $class_where = array(); if ($search['end_grade']) { $class_where[] = "grade_id BETWEEN {$search['start_grade']} AND {$search['end_grade']}"; } elseif ($search['start_grade']) { $class_where[] = "grade_id >= {$search['start_grade']}"; } if ($search['class_id']) { if (count($search['class_id']) == 1) { $class_where[] = "class_id='" . $search['class_id'][0] . "'"; } else { $class_where[] = "class_id IN (" . my_implode($search['class_id']) . ")"; } } //文理科 if (is_numeric($search['subject_type'])) { $class_where[] = "subject_type='" . $search['subject_type'] . "'"; } if ($search['end_difficulty']) { $class_where[] = "difficulty BETWEEN {$search['start_difficulty']} AND {$search['end_difficulty']}"; } elseif ($search['start_difficulty']) { $class_where[] = "difficulty >= {$search['start_difficulty']}"; } if ($class_where) { $where[] = "q.ques_id IN (SELECT DISTINCT ques_id FROM {pre}relate_class WHERE " . implode(' AND ', $class_where) . ")"; } } elseif ($search['start_grade'] && $search['end_grade']) { if ($search['start_grade'] <= $search['end_grade']) { $where[] = "q.start_grade <= {$search['end_grade']} AND q.end_grade>= {$search['start_grade']}"; } } elseif ($search['start_grade']) { $where[] = "q.start_grade <= {$search['start_grade']} AND q.end_grade>= {$search['start_grade']}"; } elseif ($search['end_grade']) { $where[] = "q.start_grade <= {$search['end_grade']} AND q.end_grade>= {$search['end_grade']}"; } // url参数 if ($search['start_grade']) { $param[] = "start_grade=" . $search['start_grade']; } else { $search['start_grade'] = ''; } if ($search['end_grade']) { $param[] = "end_grade=" . $search['end_grade']; } else { $search['end_grade'] = ''; } if ($search['class_id']) { $param[] = "class_id[]=" . implode('&class_id[]=', $search['class_id']); } if (is_numeric($search['subject_type'])) { $param[] = "subject_type=" . $search['subject_type']; } if ($search['start_difficulty']) { $param[] = "start_difficulty=" . $search['start_difficulty']; } else { $search['start_difficulty'] = ''; } if ($search['end_difficulty']) { $param[] = "end_difficulty=" . $search['end_difficulty']; } else { $search['end_difficulty'] = ''; } // 试题技能 $search['skill_id'] = $this->input->get('skill_id'); if ($search['skill_id'] && is_array($search['skill_id'])) { foreach ($search['skill_id'] as $sid) { $sid = intval($sid); $where[] = "q.skill LIKE '%,{$sid},%'"; $param[] = "skill_id[]={$sid}"; } } else { $search['skill_id'] = array(); } // 试题方法策略 $method_tactic_ids = trim($this->input->get('method_tactic_ids')); $method_tactic_arr = my_intval(explode(',', $method_tactic_ids)); $search['method_tactic_ids'] = implode(',', $method_tactic_arr); if ($search['method_tactic_ids']) { $param[] = "method_tactic_ids=" . $search['method_tactic_ids']; $where[] = "exists(select ques_id from {pre}relate_method_tactic rmt WHERE q.ques_id=rmt.ques_id AND rmt.method_tactic_id IN ({$search['method_tactic_ids']}) and rmt.is_child=0)"; } // 试题知识点 $knowledge_ids = trim($this->input->get('knowledge_ids')); $knowledge_arr = my_intval(explode(',', $knowledge_ids)); $search['knowledge_ids'] = implode(',', $knowledge_arr); $know_processes = $this->input->get('know_process'); $search['know_process'] = my_intval($know_processes); if ($search['knowledge_ids']) { $param[] = "knowledge_ids=" . $search['knowledge_ids']; if ($search['know_process']) { $tmp_know_process = implode(',', $search['know_process']); $param[] = "know_process[]=" . implode('&know_process[]=', $search['know_process']); $where[] = "exists(select ques_id from {pre}relate_knowledge rk WHERE q.ques_id=rk.ques_id AND rk.knowledge_id IN ({$search['knowledge_ids']}) AND rk.know_process IN ({$tmp_know_process}) AND rk.is_child=0)"; } else { $where[] = "exists(select ques_id from {pre}relate_knowledge rk WHERE q.ques_id=rk.ques_id AND rk.knowledge_id IN ({$search['knowledge_ids']}) AND rk.is_child=0)"; } } else { if ($search['know_process']) { $tmp_know_process = implode(',', $search['know_process']); $param[] = "know_process[]=" . implode('&know_process[]=', $search['know_process']); $where[] = "exists(select ques_id from {pre}relate_knowledge rk WHERE q.ques_id=rk.ques_id AND rk.know_process IN ({$tmp_know_process}) AND rk.is_child=0)"; } } if ($search['keyword'] = trim($this->input->get('keyword'))) { $escape_keyword = $this->db->escape_like_str($search['keyword']); $where[] = "q.title LIKE '%" . $escape_keyword . "%'"; $param[] = "keyword=" . urlencode($search['keyword']); } if ($ques_id = intval($this->input->get('ques_id'))) { $search['ques_id'] = $ques_id; $where[] = "q.ques_id={$ques_id}"; $param[] = "ques_id={$ques_id}"; } $where = $where ? ' WHERE ' . implode(' AND ', $where) : ' 1 '; // 统计数量 $nums = QuestionModel::get_question_nums($where); $total = $nums['total']; // 读取数据 $size = 15; $page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1; $offset = ($page - 1) * $size; $list = array(); if ($total) { $sql = "SELECT q.*,a.admin_user,a.realname FROM {pre}question q\n LEFT JOIN {pre}admin a ON a.admin_id=q.admin_id\n {$where} ORDER BY q.ques_id DESC LIMIT {$offset},{$size}"; $res = $this->db->query($sql); foreach ($res->result_array() as $row) { $row_cids = explode(',', trim($row['class_id'], ',')); $row_cname = array(); foreach ($row_cids as $cid) { $row_cname[] = isset($class_list[$cid]['class_name']) ? $class_list[$cid]['class_name'] : ''; } if ($row['exam_year'] == 0) { $row['exam_year'] = ''; } if ($row['related'] == 0) { $row['related'] = ''; } $row['class_name'] = implode(',', $row_cname); $row['qtype'] = isset($qtypes[$row['type']]) ? $qtypes[$row['type']] : ''; $row['start_grade'] = isset($grades[$row['start_grade']]) ? $grades[$row['start_grade']] : ''; $row['end_grade'] = isset($grades[$row['end_grade']]) ? $grades[$row['end_grade']] : ''; $row['subject_name'] = isset($subjects[$row['subject_id']]) ? $subjects[$row['subject_id']] : ''; $row['addtime'] = date('Y-m-d H:i', $row['addtime']); //判断该试题已经被考试过 或 正在被考 $row['be_tested'] = QuestionModel::question_has_test_action($row['ques_id']); //判断试题已经被考过 $row['be_tested_1'] = QuestionModel::question_has_be_tested($row['ques_id']); /* * 检查是否有关联信息 * 非题组:关联技能 * 题组:题干关联技能、知识点,子题必须要全部添加知识点 */ $no_relate_info = false; $q_type = $row['type']; if ($q_type > 0) { //非题组 $no_relate_info = $row['skill'] == ''; } else { //题组 //判断是否所有子题都已添加知识点 $tmp_ques_id = $row['ques_id']; $child_questions = $this->db->query("select count(*) as `count` from {pre}question where parent_id={$tmp_ques_id}")->row_array(); $count_child = $child_questions['count']; $child_count_result = $this->db->query("select count(*) as `count` from {pre}question where parent_id={$tmp_ques_id} and knowledge != ''")->row_array(); $tmp_count = $child_count_result['count']; if ($count_child == $tmp_count && $row['skill'] == '' && $row['knowledge'] == '') { $no_relate_info = true; } } $row['no_relate_info'] = $no_relate_info; $row['has_edit_power'] = QuestionModel::check_question_power($row['ques_id'], 'w', false); $row['recycle'] = array(); $list[] = $row; } } $data['list'] =& $list; // 分页 $purl = site_url('admin/question_audit/index/' . $mode) . ($param ? '?' . implode('&', $param) : ''); $data['pagination'] = multipage($total, $size, $page, $purl, '', $nums['relate_num']); if ($search['group_id'] && $list) { $row = array_pop($list); $data['relate_ques_id'] = $row['ques_id']; } $data['mode'] = $mode; $data['search'] = $search; $data['grades'] = $grades; $data['subjects'] = $subjects; $data['qtypes'] = $qtypes; $data['q_tags'] = C('q_tags'); $data['class_list'] = $class_list; $data['all_grade_class'] = ClassModel::all_grade_class(); $data['relate_class'] = array(); $data['knowledge_list'] = $knowledge_list; $data['priv_delete'] = $this->check_power('question_delete', FALSE); $data['priv_trash'] = $this->check_power('question_trash', FALSE); $data['priv_manage'] = $this->check_power('question_manage', FALSE); if (!$this->is_super_user() && !$this->is_all_subject_user() && CpUserModel::is_action_type_all('question', 'r')) { $query = $this->db->select('admin_id,admin_user,realname')->get_where('admin', array('is_delete' => 0)); } else { if (!$this->is_super_user() && !$this->is_all_subject_user() && CpUserModel::is_action_type_subject('question', 'r')) { $c_subject_id = $this->session->userdata('subject_id'); $c_subject_id = explode(',', $c_subject_id); $c_subject_id = array_values(array_filter($c_subject_id)); $where_11 = array(); foreach ($c_subject_id as $val) { $where_11[] = "find_in_set({$val},b.subject_id)"; } $where_12 = implode(' or ', $where_11); $sql = "SELECT admin_id,admin_user,realname FROM {pre}admin\n WHERE admin_id in(select admin_id from {pre}admin_role a,{pre}role b\n WHERE a.role_id=b.role_id and ({$where_12})) and is_delete=0 "; $query = $this->db->query($sql); /* $query = $this->db->select('admin_id,admin_user,realname')->where('subject_id', $c_subject_id)->get_where('admin', array('is_delete'=>0)); */ } else { if (!$this->is_super_user() && !$this->is_all_subject_user() && CpUserModel::is_action_type_self('question', 'r')) { $c_uid = $this->session->userdata('admin_id'); $query = $this->db->select('admin_id,admin_user,realname')->where('admin_id', $c_uid)->get_where('admin'); } else { $query = $this->db->select('admin_id,admin_user,realname')->get_where('admin', array('is_delete' => 0)); } } } $data['admin_list'] = $query->result_array(); //文理科 $data['subject_types'] = C('subject_type'); $data['all_subjects'] = C('subject'); //认知过程 $data['know_processes'] = C('know_process'); if ($this->is_super_user() || $this->is_all_subject_user() || $this->is_subject_user(3) || CpUserModel::is_action_type_all('question', 'w')) { $data['is_english_admin'] = true; } // 模版 $this->load->view('question_audit/index', $data); }
public function edit($id = 0) { if (!$this->check_power('comparison_manage')) { return; } $id = intval($id); $id && ($detail = ComparisonTypeModel::get_comparison_type_by_id($id)); if (empty($detail)) { message('分类不存在'); } $data['act'] = 'edit'; $data['detail'] =& $detail; // 学科、类型 $data['grades'] = C('grades'); $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['class_list'] = ClassModel::get_class_list(); // 模版 $this->load->view('comparison_type/edit', $data); }
/** * @description 重置密码 * @author * @final * @param int $uid 管理员id * @param string $password 密码 * @param string $password_confirm 确认密码 */ public function reset_password() { $new_password = $this->input->post('new_password'); $new_confirm_password = $this->input->post('confirm_password'); $admin_id = intval($this->input->post('uid')); if (is_string($passwd_msg = is_password($new_password))) { output_json(CODE_ERROR, $passwd_msg); } if (!strlen(trim($new_confirm_password))) { output_json(CODE_ERROR, '确认密码不能为空.'); } if ($new_confirm_password != $new_password) { output_json(CODE_ERROR, '两次密码输入不一致.'); } //检查旧密码是否正确 $passwd = CpUserModel::get_cpuser($admin_id, 'password'); if (!count($passwd)) { output_json(CODE_ERROR, '不存在该管理员.'); } //检查帐号密码是否正确 $flag = $this->db->update('admin', array('password' => my_md5($new_password)), array('admin_id' => $admin_id)); if (!$flag) { output_json(CODE_ERROR, '密码修改失败,请重试'); } output_json(CODE_SUCCESS, '密码修改成功.'); }
/** * 题库管理员密码重置 * from 后台管理员批量导入 */ public function resetpwd() { $hash = $this->input->get('code'); $admin_id = admin_email_hash('decode', $hash, 1800); $admin_id && ($admin = CpUserModel::get_cpuser($admin_id)); if (!$admin) { message('重置链接已失效,请重新提交申请', 'admin/index/login'); } 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('admin', array('password' => my_md5($password)), array('admin_id' => $admin_id)); message('您的新密码已设置成功.', 'admin/index/login', 'success'); } else { // 模版 $this->load->view('cpuser/resetpwd', array('hash' => $hash)); } }
/** * 知识点同步 * @param int $pid = 0 父知识点ID * @param int $_GET['subject_id'] 学科ID * @param string $_GET['subject_name'] 学科名称 */ public function synclist() { header('Content-Type:text/javascript;charset=UTF-8'); $data = array(); while (true) { $subject_id = intval($this->input->get('subject_id')); $subject_name = trim($this->input->get('subject_name')); $subject_list = C('subject'); if (!$subject_id && $subject_name != '') { $subject_id = array_search($subject_name, $subject_list); } if (!isset($subject_list[$subject_id])) { $data['error'] = '错误的学科参数'; break; } $subject_name = $subject_list[$subject_id]; $subjects = CpUserModel::get_allowed_subjects(); if (!isset($subjects[$subject_id])) { $data['error'] = '您没有指定学科权限'; break; } $data['subject_id'] = $subject_id; $data['subject_name'] = $subject_name; $sql = <<<EOT SELECT id AS k_id, knowledge_name AS k_name, pid AS k_pid FROM rd_knowledge WHERE subject_id = {$subject_id} ORDER BY pid EOT; $data['ktree_list'] = Fn::db()->fetchAll($sql); break; } echo 'var zmte_ktree = '; echo json_encode($data); exit; }
/** * 评估规则页面 * * @return void */ public function index() { if (!$this->check_power('evaluate_rule_list,evaluate_rule_manage')) { return; } // 查询条件 $query = array(); $param = array(); $search = array(); $page = intval($this->input->get('page')); $page = $page ? $page : 1; $per_page = intval($this->input->get('per_page')); $per_page = $per_page ? $per_page : 15; $selectWhat = null; //拼接查询条件 $query_exam_pid = $this->input->get('exam_pid'); if ($query_exam_pid) { $query['exam_pid'] = trim($query_exam_pid); $search['exam_pid'] = $query_exam_pid; $param[] = "exam_pid={$query_exam_pid}"; } else { $search['exam_pid'] = ''; } $query_place_id = $this->input->get('place_id'); if ($query_place_id) { $query['place_id'] = trim($query_place_id); $search['place_id'] = $query_place_id; $param[] = "place_id={$query_place_id}"; } else { $search['place_id'] = ''; } $query_subject_id = $this->input->get('subject_id'); if ($query_subject_id) { $query['subject_id'] = trim($query_subject_id); $search['subject_id'] = $query_subject_id; $param[] = "subject_id={$query_subject_id}"; } else { $search['subject_id'] = ''; } $query_is_trash = (int) $this->input->get('trash'); if ($query_is_trash) { $query['is_delete'] = '1'; $search['trash'] = $query_is_trash; $param[] = "trash={$query_is_trash}"; } else { $query['is_delete'] = '0'; } // 按照时间排序,最新的在最前边 $order = 'id desc'; $result = EvaluateRuleModel::get_evaluate_rule_list($query, $page, $per_page, $order, $selectWhat); //附加信息 $list = array(); $this->load->model('cron/report/task_report_model'); foreach ($result as &$item) { $exam_pid = $item['exam_pid']; $place_id = $item['place_id']; $subject_id = $item['subject_id']; $exam_name = ExamModel::get_exam($exam_pid, 'exam_name'); $item['exam_name'] = !count($exam_name) ? '--' : $exam_name; $place_name = ExamPlaceModel::get_place($place_id, 'place_name'); $item['place_name'] = !($place_name && count($place_name)) ? $place_id == 0 ? '所有考场' : '--' : $place_name; $item['subject_name'] = $subject_id > 0 ? SubjectModel::get_subject($subject_id, 'subject_name') : '总结'; //关联一级知识点数量 $item['count_knowledges'] = EvaluateRuleModel::count_knowledge_lists(array('er_id' => $item['id']), 'count(distinct(knowledge_id))'); //检查该规则的生成报告状态 $task = $this->task_report_model->get_task($item['id']); $item['task_status'] = isset($task['status']) ? $task['status'] : '-1'; //检查考试期次是否生成成绩 //if ($subject_id == 0) //{ $exam_result = $this->db->select('status')->get_where('cron_task_exam_result', array('exam_pid' => $exam_pid))->row_array(); if ($exam_result && $exam_result['status'] >= 1) { $item['is_exam_result'] = true; } //} //检查是否已生html页面 $exist_html = $this->db->select('id')->get_where('rd_convert2pdf', array('rule_id' => $item['id'], 'html_status' => 1))->row_array(); if ($exist_html) { $item['is_exist_html'] = true; } /* 面试报告状态 1.未关联评分标准不显示生成面试结果按钮 2.正在处理状态 3.生成完毕,显示查看生成报告按钮*/ /* rd_evaluation_standard_exam 评分标准关联考试期次 1 */ $sql = "select id from {pre}evaluation_standard_exam where exam_id={$exam_pid}"; $interview_result = $this->db->query($sql)->row_array(); if ($interview_result && !empty($interview_result)) { $item['is_interview'] = true; /* rd_cron_interview_task_report 报告生成结果 1:正在处理 2:部分处理完成 3:全部处理完成 */ $sql = "select status from {pre}cron_interview_task_report where rule_id={$item['id']}"; $interview_task_status = $this->db->query($sql)->row_array(); $item['interview_task_status'] = isset($interview_task_status['status']) ? $interview_task_status['status'] : '-1'; } //添加管理员信息 $item['admin_name'] = CpUserModel::get_cpuser($item['admin_id'], 'realname'); $list[] = $item; } // 分页 $purl = site_url('admin/evaluate_rule/index/') . (count($param) ? '?' . implode('&', $param) : ''); $total = EvaluateRuleModel::count_lists($query); $data['pagination'] = multipage($total, $per_page, $page, $purl); $data['detail'] =& $search; $data['list'] =& $list; $data['comparison_levels'] = C('evaluate_comparison_level'); $data['priv_manage'] = $this->check_power('evaluate_rule_manage', FALSE); $data['has_report_command_priv'] = $this->check_power_new('report_command_index', FALSE); // 模版 $this->load->view('evaluate_rule/index', $data); }
/** * 编辑考试学科 * * @param int $id 考试学科id * @return void */ public function edit_subject($id = 0) { if (!$this->check_power('exam_manage')) { return; } $id = intval($id); $id && ($exam = ExamModel::get_exam($id)); if (empty($exam) or $exam['exam_pid'] == 0) { message('考试学科不存在', 'admin/exam/index'); return; } $parent = ExamModel::get_exam($exam['exam_pid'], 'exam_id,exam_name,exam_pid,grade_id,class_id,creator_id,managers'); if (empty($parent)) { message('考试期次不存在', 'admin/exam/index'); return; } $managers = $parent['managers'] ? json_decode($parent['managers'], true) : array(); $this->check_exam_manager_power($parent['creator_id'], $managers, $exam['creator_id']); $class_list = ClassModel::get_class_list(); $grades = C('grades'); $parent['grade_name'] = isset($grades[$parent['grade_id']]) ? $grades[$parent['grade_id']] : ''; $parent['class_name'] = isset($class_list[$parent['class_id']]['class_name']) ? $class_list[$parent['class_id']]['class_name'] : ''; $exam['qtype_score'] = explode(',', $exam['qtype_score']); for ($i = 0; $i < 9; $i++) { if (!isset($exam['qtype_score'][$i])) { $exam['qtype_score'][$i] = ''; } } $data['act'] = 'edit'; $data['exam'] = $exam; $data['parent'] = $parent; $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['subject_types'] = C('subject_type'); $data['referer'] = empty($_SERVER['HTTP_REFERER']) ? '' : $_SERVER['HTTP_REFERER']; $this->load->view('exam/edit_subject', $data); }
public function edit_combination($id = 0) { if (!$this->check_power('question_manage')) { return; } if (!QuestionModel::check_question_power($id, 'w')) { return; } $id = intval($id); $id && ($question = QuestionModel::get_question($id)); if ($question['related'] == 0) { $question['related'] = ''; } if ($question['exam_year'] == 0) { $question['exam_year'] = ''; } if (empty($question)) { message('组合题不存在'); return; } //判断该试题已经被考试过 或 正在被考 $be_tested = QuestionModel::question_has_test_action($id); if ($be_tested) { message('该试题已经被考生考过 或者 正在被考, 无法操作'); } // 不是组合题,做相应跳转 if ($question['type'] != 15 || $question['parent_id']) { redirect('admin/question/edit/' . $id); } // 试题类型 $relate_class = array(); $query = $this->db->get_where('relate_class', array('ques_id' => $id)); foreach ($query->result_array() as $row) { $relate_class[$row['grade_id']][$row['class_id']] = $row; } $data['relate_class'] = $relate_class; $data['paper_diy'] = $this->paper_diy; $data['act'] = 'edit'; $data['question'] = $question; $data['grades'] = CpUserModel::get_allowed_grades($q = 2); $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['all_subjects'] = C('subject'); $data['subject_types'] = C('subject_type'); $data['all_grade_class'] = ClassModel::all_grade_class(); // 模版 $this->load->view('question/edit_group', $data); }
/** * @description 添加期次科目样卷 * @author * @final * @param int $exam_id 考试期次id * @param array $ids 试卷id */ public function add_demo($exam_id = 0) { if (!$this->check_power('exam_manage')) { return; } $exam_id = intval($exam_id); $exam_id && ($exam = ExamModel::get_exam($exam_id, 'exam_name,exam_id,exam_pid,subject_id')); if (empty($exam)) { message('考试期次科目不存在', 'admin/exam/index'); return; } //样卷,跳到样卷选择 if ($exam['exam_pid'] > 1) { redirect('admin/subject_paper/add/' . $exam_id); } //检查该学科考试状态 $has_tested = ExamPlaceSubjectModel::exam_subject_has_test_action($exam_id); if ($has_tested) { message('该期次科目已经被考生考过 或者 正在被考中,因此无法操作'); } $subject_id = $exam['subject_id']; $subjects = CpUserModel::get_allowed_subjects(); $exam['subject_name'] = $subjects[$subject_id]; $demo_subject_papers = C('demo_subject_paper', 'app/admin/exam/demo'); $paper_list = array(); $size = 30; $page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1; $offset = ($page - 1) * $size; $total = 0; if (isset($demo_subject_papers[$subject_id]) && count($demo_subject_papers[$subject_id])) { $total = count($demo_subject_papers[$subject_id]); $sql = "SELECT * FROM {pre}exam_paper p WHERE p.exam_id={$exam_id} AND p.is_delete=0 AND p.paper_id in(" . implode(',', $demo_subject_papers[$subject_id]) . ") LIMIT {$offset},{$size}"; $query = $this->db->query($sql); foreach ($query->result_array() as $row) { $row['qtype_ques_num'] = explode(',', $row['qtype_ques_num']); $paper_list[] = $row; } } $data['exam'] =& $exam; $data['paper_list'] =& $paper_list; // 分页 $purl = site_url('admin/subject_paper/add_demo/' . $exam_id); $data['pagination'] = multipage($total, $size, $page, $purl); // 模版 $this->load->view('subject_paper/add', $data); }
public function index() { if (!$this->check_power('question_difficulty_list')) { return; } $page = intval($this->input->get('page')); $per_page = intval($this->input->get('per_page')); $id = intval($this->input->get('id')); $ques_id = intval($this->input->get('ques_id')); $grade_id = intval($this->input->get('grade_id')); $class_id = $this->input->get('class_id'); $subject_type = $this->input->get('subject_type'); $from_question_list = intval($this->input->get('from_question_list')); $difficulty_start = intval($this->input->get('difficulty_start')); $difficulty_end = intval($this->input->get('difficulty_end')); $copy_difficulty_start = intval($this->input->get('copy_difficulty_start')); $copy_difficulty_end = intval($this->input->get('copy_difficulty_end')); // 查询条件 $query = array(); $param = array(); $search = array('id' => '', 'ques_id' => '', 'grade_id' => '', 'subject_type' => '', 'class_id' => array(), 'difficulty_start' => '', 'difficulty_end' => '', 'copy_difficulty_start' => '', 'copy_difficulty_end' => ''); $grades = C('grades'); $subjects = CpUserModel::get_allowed_subjects(); $qtypes = C('qtype'); $subject_types = C('subject_type'); $class_list = ClassModel::get_class_list(); $data['grades'] = $grades; $data['subjects'] = $subjects; $data['qtypes'] = $qtypes; $data['subject_types'] = $subject_types; $data['class_list'] = $class_list; if ($id) { $query['id'] = $id; $param[] = "id={$id}"; $search['id'] = $id; } if ($ques_id) { $query['ques_id'] = $ques_id; $param[] = "ques_id={$ques_id}"; $search['ques_id'] = $ques_id; } if ($grade_id) { $query['grade_id'] = $grade_id; $param[] = "grade_id={$grade_id}"; $search['grade_id'] = $grade_id; } if (is_numeric($subject_type)) { $query['subject_type'] = $subject_type; $param[] = "subject_type={$subject_type}"; $search['subject_type'] = $subject_type; } if (is_array($class_id)) { $class_id = my_intval($class_id); if (count($class_id) == 1) { $query['class_id'] = $class_id[0]; } else { $query['class_id'] = $class_id; } $param[] = implode('&class_id[]=', $search['class_id']); $search['class_id'] = $class_id; } if ($difficulty_start) { $query['difficulty']['>='] = $difficulty_start; $param[] = "difficulty_start={$difficulty_start}"; $search['difficulty_start'] = $difficulty_start; } if ($difficulty_end) { $query['difficulty']['<='] = $difficulty_end; $param[] = "difficulty_end={$difficulty_end}"; $search['difficulty_end'] = $difficulty_end; } if ($copy_difficulty_start) { $query['copy_difficulty']['>='] = $copy_difficulty_start; $param[] = "copy_difficulty_start={$copy_difficulty_start}"; $search['copy_difficulty_start'] = $copy_difficulty_start; } if ($copy_difficulty_end) { $query['copy_difficulty']['<='] = $copy_difficulty_end; $param[] = "copy_difficulty_end={$copy_difficulty_end}"; $search['copy_difficulty_end'] = $copy_difficulty_end; } if ($from_question_list) { $param[] = "from_question_list={$from_question_list}"; $search['from_question_list'] = $from_question_list; } else { $search['from_question_list'] = '0'; } //限制只能查看所属学科 if (!$this->is_super_user() && !$this->is_all_subject_user() && !CpUserModel::is_action_type_all('question', 'r') && CpUserModel::is_action_type_subject('question', 'r')) { $c_subject_id = rtrim($this->session->userdata('subject_id'), ','); if ($c_subject_id != '') { $c_subject_id = explode(',', $c_subject_id); $c_subject_id = array_values(array_filter($c_subject_id)); $c_subject_id = implode(',', $c_subject_id); $where0 = " q.subject_id in({$c_subject_id})"; } else { $where0 = " 1=1"; } } else { $where0 = " 1=1"; } //限制只能查看所属年级 if (!$this->is_super_user() && !$this->is_all_grade_user()) { $c_grade_id = rtrim($this->session->userdata('grade_id'), ','); if ($c_grade_id != '') { $c_grade_id = explode(',', $c_grade_id); $c_grade_id = array_values(array_filter($c_grade_id)); $c_grade_id = implode(',', $c_grade_id); $where1 = " rc.grade_id in ({$c_grade_id})"; } else { $where1 = " 1=1"; } } else { $where1 = " 1=1"; } //限制只能查看所属类型 if (!$this->is_super_user() && !$this->is_all_q_type_user()) { $c_q_type_id = rtrim($this->session->userdata('q_type_id'), ','); if ($c_q_type_id != '') { $c_q_type_id = explode(',', $c_q_type_id); $c_q_type_id = array_values(array_filter($c_q_type_id)); $c_q_type_id = implode(',', $c_q_type_id); $where2 = " rc.class_id in ({$c_q_type_id})"; } else { $where2 = " 1=1"; } } else { $where2 = " 1=1"; } $where = $where0 . ' and (' . $where1 . ' and ' . $where2 . ')'; $select_what = 'rc.*'; $page = $page <= 0 ? 1 : $page; $per_page = $per_page <= 0 ? 10 : $per_page; $list = array(); if (!is_null($query)) { $list = RelateClassModel::get_relate_class_list($query, $page, $per_page, 'ques_id desc', $select_what, $group_by = null, $where); } //获取试题信息 $tmp_list = array(); foreach ($list as $k => $item) { $question = QuestionModel::get_question($item['ques_id'], 'title, subject_id, admin_id, addtime, type, is_parent'); if (!count($question)) { continue; } $admin = $this->db->query("SELECT a.realname FROM {pre}admin a where a.admin_id={$question['admin_id']}")->result_array(); $question['admin_name'] = count($admin) ? $admin[0]['realname'] : '--'; $question['subject_name'] = $subjects[$question['subject_id']]; $item['grade_name'] = $grades[$item['grade_id']]; $item['subject_type_name'] = $subject_types[$item['subject_type']]; $item['addtime'] = date('Y-m-d H:i:s', $question['addtime']); $question['type'] = $qtypes[$question['type']]; //获取试题类型 $item['class_name'] = isset($class_list[$item['class_id']]) ? $class_list[$item['class_id']]['class_name'] : '--'; //学科/试题相关权限 $has_question_power = QuestionModel::check_question_power($item['ques_id'], 'w', false); $has_subject_power = true; $item['has_edit_power'] = $has_question_power && $has_subject_power; $tmp_list[$k] = array_merge($item, $question); } $data['list'] =& $tmp_list; $data['search'] =& $search; $data['flags'] =& $flags; //难易度更新全新 $data['priv_manage'] = $this->check_power('update_system_difficulty', FALSE); $data['priv_question_manage'] = $this->check_power('question_manage', FALSE); // 分页 $purl = site_url('admin/relate_class/index/') . (count($param) ? '?' . implode('&', $param) : ''); $total = RelateClassModel::count_list($query, $where); $data['pagination'] = multipage($total, $per_page, $page, $purl); $this->load->view('relate_class/index', $data); }
/** * 检查当前用户是否有 查看/编辑某个学科的权限 */ public static function check_subject_power($subject_id = 0, $power_type = 'w', $output = true) { $subject_id = intval($subject_id); if (!$subject_id) { return true; } //管理员 或者 有查看所有权限 $is_super_user = Fn::sess()->userdata('is_super'); if ($is_super_user || CpUserModel::is_action_type_all('question', $power_type)) { return true; } //当前学科 $is_action = CpUserModel::is_action_type_subject('question', $power_type, $subject_id); if ($output && !$is_action) { message('您没权限!'); } else { return $is_action; } }
/** * 编辑信息提取方式 * @param int $id = 0 * @see update() */ public function edit($id = 0) { if (!$this->check_power('group_type_manage')) { return; } $id = intval($id); $id && ($row = GroupTypeModel::get_group_type($id)); if (empty($row)) { message('信息提取方式不存在'); return; } if ($row['pid']) { $parent = GroupTypeModel::get_group_type($row['pid']); $data['parent'] = $parent; } if (!QuestionModel::check_subject_power($row['subject_id'], 'w')) { return; } $data['row'] = $row; $data['subjects'] = CpUserModel::get_allowed_subjects(); // 模版 $this->load->view('group_type/edit', $data); }
function admin_email_hash($operation, $key, $validate_time = 0) { if ($operation == 'encode') { $admin_id = intval($key); $CI =& get_instance(); //$CI->load->model('admin/cpuser_model'); $addtime = CpUserModel::get_cpuser($admin_id, 'addtime'); $hash = substr(md5($admin_id . C('hash_code') . $addtime), 16, 8); return base64_encode($admin_id . ',' . $hash . ',' . time()); } else { $hash = base64_decode(trim($key)); $row = explode(',', $hash); if (count($row) != 3) { return FALSE; } $admin_id = intval($row[0]); $salt = trim($row[1]); $time = intval($row[2]); if ($admin_id <= 0 || $validate_time && time() - $time > $validate_time) { return FALSE; } $CI =& get_instance(); $query = $CI->db->select('addtime')->get_where('admin', array('admin_id' => $admin_id)); $row = $query->row_array(); $pre_salt = substr(md5($admin_id . C('hash_code') . $row['addtime']), 16, 8); if ($pre_salt == $salt) { return $admin_id; } else { return FALSE; } } }
public function group($group_id = 0) { if (!$this->check_power('question_manage')) { return; } $group_id = intval($group_id); if ($group_id) { $query = $this->db->get_where('relate_group', array('group_id' => $group_id)); $group = $query->row_array(); } if (empty($group)) { $site_url = site_url('/admin/question/index'); header("location: {$site_url}"); // message('关联分组不存在。','/admin/question/index'); return; } $cpusers = CpUserModel::get_cpuser_list(); // 加载分类数据 $class_list = ClassModel::get_class_list(); $subjects = CpUserModel::get_allowed_subjects(); $grades = C('grades'); $qtypes = C('qtype'); $periods = C('grade_period'); $langs = C('interview_lang'); $types = C('interview_type'); $list_ques = $list_interview = array(); $query = $this->db->get_where('question', array('group_id' => $group_id, 'parent_id' => 0, 'is_delete' => 0)); foreach ($query->result_array() as $row) { $row_cids = explode(',', trim($row['class_id'], ',')); $row_cname = array(); foreach ($row_cids as $cid) { $row_cname[] = isset($class_list[$cid]['class_name']) ? $class_list[$cid]['class_name'] : ''; } $row['class_name'] = implode(',', $row_cname); $row['start_grade'] = isset($grades[$row['start_grade']]) ? $grades[$row['start_grade']] : ''; $row['qtype'] = isset($qtypes[$row['type']]) ? $qtypes[$row['type']] : ''; $row['end_grade'] = isset($grades[$row['end_grade']]) ? $grades[$row['end_grade']] : ''; $row['subject_name'] = isset($subjects[$row['subject_id']]) ? $subjects[$row['subject_id']] : ''; $row['addtime'] = date('Y-m-d H:i', $row['addtime']); $row['cpuser'] = isset($cpusers[$row['admin_id']]['realname']) ? $cpusers[$row['admin_id']]['realname'] : ''; $row['has_edit_power'] = QuestionModel::check_question_power($row['ques_id'], 'w', false); //判断该试题已经被考试过 或 正在被考 $row['be_tested'] = QuestionModel::question_has_test_action($row['ques_id']); $list_ques[] = $row; } $query2 = $this->db->get_where('interview_question', array('group_id' => $group_id, 'is_delete' => 0)); foreach ($query2->result_array() as $row) { // 类型 $row_cids = explode(',', trim($row['class_id'], ',')); $row_cname = array(); foreach ($row_cids as $cid) { $row_cname[] = isset($class_list[$cid]['class_name']) ? $class_list[$cid]['class_name'] : ''; } // 年段 $row_pids = explode(',', trim($row['grade_period'], ',')); $row_pname = array(); foreach ($row_pids as $pid) { $row_pname[] = isset($periods[$pid]) ? $periods[$pid] : ''; } $row['class_name'] = implode(',', $row_cname); $row['period_name'] = implode(',', $row_pname); $row['language'] = isset($langs[$row['lang']]) ? $langs[$row['lang']] : ''; $row['type_name'] = isset($types[$row['interview_type']]['type_name']) ? $types[$row['interview_type']]['type_name'] : ''; $row['addtime'] = date('Y-m-d H:i', $row['addtime']); $row['cpuser'] = isset($cpusers[$row['admin_id']]['realname']) ? $cpusers[$row['admin_id']]['realname'] : ''; $list_interview[] = $row; } $priv = array('delete_question' => $this->check_power('question_delete', FALSE), 'delete_interview_question' => $this->check_power('invterview_question_delete', FALSE)); $data['group_id'] = $group_id; $data['list_ques'] = $list_ques; $data['list_interview'] = $list_interview; $data['priv'] = $priv; $data['has_edit_power'] = QuestionModel::check_question_power($group['group_name'], 'w', false); $data['has_interview_question_manage'] = $this->check_power('interview_question_manage', false); // 模版 $this->load->view('relate_group/group', $data); }
/** * @description 管理员操作日志列表 * @author * @final * @param int $admin_id 管理员id * @param date $begin_time 开始时间 * @param date $end_time 结束时间 */ public function index() { if (!$this->check_power('admin_log_list')) { return; } $cpusers = CpUserModel::get_cpuser_list(); // 查询条件 $where = array(); $param = array(); $search = array(); if ($search['admin_id'] = intval($this->input->get('admin_id'))) { $where[] = "admin_id='{$search['admin_id']}'"; $param[] = "admin_id={$search['admin_id']}"; } // 操作时间 $begin_time = $this->input->get('begin_time'); $end_time = $this->input->get('end_time'); if ($btime = (int) strtotime($begin_time)) { $search['begin_time'] = $begin_time; $where[] = "log_time >= {$btime}"; $param[] = "begin_time={$begin_time}"; } if ($etime = (int) strtotime($end_time)) { $etime += 86400; $search['end_time'] = $end_time; $where[] = "log_time < {$etime}"; $param[] = "end_time={$end_time}"; } $where = $where ? implode(' AND ', $where) : ' 1 '; /* * 统计当前数据条数 */ $sql = "SELECT COUNT(id) nums FROM {pre}admin_log WHERE {$where}"; $res = $this->db->query($sql); $row = $res->row_array(); $total = $row['nums']; /* * 分页读取数据列表,并处理相关数据 */ $size = 15; $page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1; $offset = ($page - 1) * $size; $list = array(); if ($total) { $sql = "SELECT *\n FROM {pre}admin_log \n WHERE {$where} ORDER BY id DESC LIMIT {$offset},{$size}"; $res = $this->db->query($sql); foreach ($res->result_array() as $row) { $row['admin_user'] = isset($cpusers[$row['admin_id']]['admin_user']) ? $cpusers[$row['admin_id']]['admin_user'] : ''; $row['log_time'] = date('Y-m-d H:i:s', $row['log_time']); $list[] = $row; } } $data['list'] = $list; // 分页 $purl = site_url('admin/admin_log/index') . ($param ? '?' . implode('&', $param) : ''); $data['pagination'] = multipage($total, $size, $page, $purl); $data['cpusers'] = $cpusers; $data['search'] = $search; // 模版 $this->load->view('admin_log/index', $data); }
/** * 听力题-编辑 * * @return void */ public function edit_correct($id = 0) { $id = intval($id); $this->examine_permission($id); $id && ($question = QuestionModel::get_question($id)); if ($question['related'] == 0) { $question['related'] = ''; } if ($question['exam_year'] == 0) { $question['exam_year'] = ''; } if (empty($question)) { message('试题不存在'); return; } //判断该试题已经被考试过 或 正在被考 $be_tested = QuestionModel::question_has_test_action($id); if ($be_tested) { message('该试题已经被考生考过 或者 正在被考, 无法操作'); } // 试题类型 $relate_class = array(); $query = $this->db->get_where('relate_class', array('ques_id' => $id)); foreach ($query->result_array() as $row) { $relate_class[$row['grade_id']][$row['class_id']] = $row; } $data['relate_class'] = $relate_class; $data['act'] = 'edit'; $data['question'] = $question; $data['grades'] = C('grades'); $data['subjects'] = CpUserModel::get_allowed_subjects(); $data['all_subjects'] = C('subject'); $data['subject_types'] = C('subject_type'); $data['all_grade_class'] = ClassModel::all_grade_class(); // 模版 $this->load->view('question_external/edit_correct', $data); }
/** * 选择试题 * * @return void **/ public function select_question($paper_id = 0) { /* 查询条件 */ $where = array(); $param = array(); /* 过滤题组子题目,在题组页面管理 */ $where[] = "q.parent_id=0"; /* 未禁用试题 */ $where[] = "q.is_delete<>1"; /* 纸质考试试题 */ //$where[] = "q.test_way IN (1, 2, 3)"; /* 录入人员 只能查看自己录入的题目 管理员可以看到所有题目 */ $admin_id = $this->session->userdata('admin_id'); if (!$admin_id) { message('获取管理员数据失败,请从新登陆后重试!'); } //$where[] = "q.admin_id='{$admin_id}'"; //限制只能查看自己创建的试题 if (!$this->is_super_user() && !CpUserModel::is_action_type_all('question', 'r') && !CpUserModel::is_action_type_subject('question', 'r') && CpUserModel::is_action_type_self('question', 'r')) { $where[] = "q.admin_id='{$admin_id}'"; } else { $where[] = "q.admin_id>0"; } //限制只能查看所属学科 $c_subject_id = array(); if (!$this->is_super_user() && !CpUserModel::is_action_type_all('question', 'r') && CpUserModel::is_action_type_subject('question', 'r')) { $c_subject_id = rtrim($this->session->userdata('subject_id'), ','); if ($c_subject_id != '') { $c_subject_id = explode(',', $c_subject_id); $c_subject_id = array_values(array_filter($c_subject_id)); $c_subject_id = implode(',', $c_subject_id); $where[] = "q.subject_id in({$c_subject_id})"; } } //限制只能查看所属年级 $c_grade_id = array(); if (!$this->is_super_user() && !$this->is_all_grade_user()) { $c_grade_id = rtrim($this->session->userdata('grade_id'), ','); if ($c_grade_id != '') { $c_grade_id = explode(',', $c_grade_id); $c_grade_id = array_values(array_filter($c_grade_id)); $c_grade_id = implode(',', $c_grade_id); $where_3 = " grade_id in({$c_grade_id})"; } else { $where_3 = '1=1'; } } else { $where_3 = '1=1'; } //限制只能查看所属类型 $c_class_id = array(); if (!$this->is_super_user() && !$this->is_all_q_type_user()) { $c_q_type_id = rtrim($this->session->userdata('q_type_id'), ','); if ($c_q_type_id != '') { $c_q_type_id = explode(',', $c_q_type_id); $c_q_type_id = array_values(array_filter($c_q_type_id)); $c_class_id = $c_q_type_id; $c_q_type_id = implode(',', $c_q_type_id); $where_4 = " class_id in ({$c_q_type_id})"; } else { $where_4 = '1=1'; } } else { $where_4 = '1=1'; } if ($where_3 != '1=1' || $where_4 != '1=1') { $where[] = "q.ques_id IN (SELECT DISTINCT ques_id FROM rd_relate_class WHERE {$where_3} AND {$where_4}) "; } if ($paper_id) { $paper = ExamPaperModel::get_paper_by_id($paper_id); $where[] = "q.subject_id = {$paper['subject_id']}"; $param[] = "subject_id={$paper['subject_id']}"; $data['subject_id'] = $paper['subject_id']; if ($paper['exam_id']) { $exam = ExamModel::get_exam($paper['exam_id'], 'grade_id, class_id'); list($grade_id, $class_id) = array_values($exam); $where[] = "q.start_grade <= {$grade_id} AND q.end_grade >= {$grade_id}"; $param[] = "grade_id={$grade_id}"; $data['grade_id'] = $exam['grade_id']; $where[] = "q.class_id LIKE '%,{$class_id},%'"; $param[] = "class_id={$class_id}"; $data['class_id'] = $exam['class_id']; } } else { if ($subject_id = $this->input->get('subject_id')) { $where[] = "q.subject_id = {$subject_id}"; $param[] = "subject_id={$subject_id}"; } if ($grade_id = $this->input->get('grade_id')) { $where[] = "q.start_grade <= {$grade_id} AND q.end_grade >= {$grade_id}"; $param[] = "grade_id={$grade_id}"; } if ($class_id = $this->input->get('class_id')) { $where[] = "q.class_id LIKE '%,{$class_id},%'"; $param[] = "class_id={$class_id}"; } } $type = $this->input->get('type'); if (strlen($type) > 0 && $type >= 0) { $type = intval($type); $where[] = "q.type = {$type}"; $param[] = "type={$type}"; } if ($is_original = $this->input->get('is_original')) { $where[] = "q.is_original = {$is_original}"; $param[] = "is_original={$is_original}"; } if (Validate::isJoinedIntStr($this->input->get('ques_id'))) { $search_quesid = $this->input->get('ques_id'); $where[] = "q.ques_id IN ({$search_quesid})"; $param[] = "ques_id={$search_quesid}"; } if ($remark = $this->input->get('remark')) { $where[] = "q.remark LIKE '%{$remark}%'"; $param[] = "remark={$remark}"; } $where = $where ? ' WHERE ' . implode(' AND ', $where) : ' 1 '; /* 统计数量 */ $nums = QuestionModel::get_question_nums($where); $total = $nums['total']; /* 读取数据 */ $size = 15; $page = $this->input->get('page') ? intval($this->input->get('page')) : 1; $offset = ($page - 1) * $size; $list = array(); /* 学科 */ $qtypes = C('q_type'); /* 试题类型 */ $subjects = C('subject'); if ($total) { $sql = "SELECT q.*,a.admin_user,a.realname FROM {pre}question q\n LEFT JOIN {pre}admin a ON a.admin_id=q.admin_id\n {$where} ORDER BY q.ques_id DESC LIMIT {$offset},{$size}"; $res = $this->db->query($sql); foreach ($res->result_array() as $row) { $row['title'] = strip_tags($row['title']); $row['qtype'] = isset($qtypes[$row['type']]) ? $qtypes[$row['type']] : ''; $row['subject_name'] = isset($subjects[$row['subject_id']]) ? $subjects[$row['subject_id']] : ''; $row['addtime'] = date('Y-m-d H:i', $row['addtime']); $list[] = $row; } } $data['list'] =& $list; $data['q_class'] = $this->db->get_where('question_class')->result_array(); $data['c_subject_id'] = $c_subject_id ? explode(',', $c_subject_id) : array(); $data['c_class_id'] = $c_class_id; $data['c_grade_id'] = $c_grade_id ? explode(',', $c_grade_id) : array(); $data['search_data'] = $_GET; /* 分页 */ $purl = site_url('admin/paper_diy/select_question/' . ($param ? '?' . implode('&', $param) : '')); $data['pagination'] = multipage($total, $size, $page, $purl, '', $nums['relate_num']); /* 模版 */ $this->load->view('paper_diy/question_list', $data); }