public function index($mode = '')
{
// 加载分类数据
$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";
// 过滤题组子题目，在题组页面管理
$mode = $mode == 'trash' ? 'trash' : '';
if ($mode == 'trash') {
$where[] = "q.is_delete = 1";
} else {
$where[] = "q.is_delete <> 1";
}
/* 用户信息 */
$admin_info = $this->session->all_userdata();
if (empty($admin_info['admin_id'])) {
message('获取管理员数据失败，请从新登陆后重试！');
} else {
$where[] = "q.admin_id={$admin_info['admin_id']}";
$param[] = "admin_id={$admin_info['admin_id']}";
$search['admin_id'] = $admin_info['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[] = "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'];
}
}
$where[] = "q.ques_id IN (SELECT DISTINCT ques_id FROM rd_relate_class) ";
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 ';
//echo $where;
// 统计数量
$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']);
$row['has_edit_power'] = true;
/*
* 检查是否有关联信息
* 非题组：关联技能
* 题组：题干关联技能、知识点，子题必须要全部添加知识点
*/
$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;
//获取回收站信息
if ($mode == 'trash') {
$recycle = RecycleModel::get_recycle_list(array('type' => RECYCLE_QUESTION, 'obj_id' => $row['ques_id']), null, null, 'ctime asc');
$row['recycle'] = $recycle;
} else {
$row['recycle'] = array();
}
$list[] = $row;
}
}
$data['list'] =& $list;
// 分页
$purl = site_url('admin/question_external/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'] = true;
$data['priv_trash'] = true;
$data['priv_manage'] = true;
$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');
$data['is_english_admin'] = true;
// 模版
$this->load->view('question_external/index', $data);
}
/**
* 删除分类信息，及其下属信息条目
*
* @param int/array 分类id
* @return boolean
*/
public static function delete($id)
{
$db = Fn::db();
$bOk = false;
if ($db->beginTransaction()) {
$tableInfo = $this->db->dbprefix('rd_comparison_info');
$tableItem = $this->db->dbprefix('rd_comparison_item');
if (is_array($id)) {
$db->delete('rd_comparison_item', "cmp_info_id IN (SELECT cmp_info_id FROM rd_comparison_info WHERE cmp_type_id IN (" . my_implode($id) . "))");
$db->delete('rd_comparison_info', "cmp_type_id = {$id}");
$db->delete('rd_comparison_type', "cmp_type_id = {$id}");
} else {
$db->delete('rd_comparison_item', "cmp_info_id IN (SELECT cmp_info_id FROM rd_comparison_info WHERE cmp_type_id = {$id})");
$db->delete('rd_comparison_info', "cmp_type_id = {$id}");
$db->delete('rd_comparison_type', "cmp_type_id = {$id}");
}
$bOk = $db->commit();
if (!$bOk) {
$db->rollBack();
}
}
return $bOk;
}
public function question_count()
{
$result = array('error' => '', 'count' => array(), 'group_count' => array());
$type = intval($this->input->post('type'));
$subject_id = intval($this->input->post('subject_id'));
$grade_id = intval($this->input->post('grade_id'));
$class_id = intval($this->input->post('class_id'));
$subject_type = intval($this->input->post('subject_type'));
$is_original = intval($this->input->post('is_original'));
if (empty($subject_id) || empty($grade_id) || empty($class_id)) {
$result['error'] = '请选择学科、年级、类型';
die(json_encode($result));
}
if ($grade_id < 11 || $subject_id > 3 || !in_array($class_id, array(2, 3))) {
$subject_type = '-1';
}
// 范围知识点
$knowledge_ids = trim($this->input->post('knowledge_ids'));
$knowledge_ids = explode(',', $knowledge_ids);
$knowledge_id_arr = array();
foreach ($knowledge_ids as $id) {
$id = intval($id);
$id && array_push($knowledge_id_arr, $id);
}
if ($type > 0 && empty($knowledge_id_arr)) {
$result['error'] = '请选择知识点范围';
die(json_encode($result));
}
// 重点知识点
$rule_knowledge = intval($this->input->post('rule_knowledge'));
$children_ids = array();
if ($type == 2) {
if ($rule_knowledge) {
$pid = KnowledgeModel::get_knowledge($rule_knowledge, 'pid');
if ($pid === false) {
$rule_knowledge = 0;
} else {
if ($pid == 0) {
// 一级知识点
$children = KnowledgeModel::get_knowledge_list(0, $rule_knowledge, 0);
foreach ($knowledge_id_arr as $kid) {
if (isset($children[$kid])) {
$children_ids[] = $kid;
}
}
} else {
// 二级知识点
if (!in_array($rule_knowledge, $knowledge_id_arr)) {
$rule_knowledge = 0;
}
}
}
}
if (empty($rule_knowledge)) {
$result['error'] = '请选择重点知识点';
die(json_encode($result));
}
}
$where = array();
$where[] = "q.is_delete<>1 AND q.parent_id=0";
$where[] = "q.subject_id={$subject_id}";
$where[] = "q.start_grade<={$grade_id} AND q.end_grade>={$grade_id}";
$where[] = "q.ques_id IN (SELECT distinct ques_id FROM {pre}relate_class \n\t\t WHERE grade_id={$grade_id} AND class_id={$class_id} AND subject_type={$subject_type})";
if ($is_original > 0) {
$where[] = "q.is_original={$is_original}";
}
//认知过程
$know_process = intval($this->input->post('know_process'));
//die(json_encode( $know_process));
$know_process_sql = !$know_process ? '' : "and know_process={$know_process}";
if ($type) {
// 范围知识点 $knowledge_id_arr
// $except_ids = array();
// $query = $this->db->select('id')->get_where('knowledge', array('subject_id'=>$subject_id,'pid >'=>'0'));
// foreach ($query->result_array() as $row)
// {
// if ( !in_array($row['id'], $knowledge_id_arr))
// $except_ids[] = $row['id'];
// }
if ($type == 2) {
if ($children_ids) {
$where[] = "q.ques_id IN (SELECT ques_id FROM {pre}relate_knowledge \n where knowledge_id IN(" . my_implode($children_ids) . ") {$know_process_sql} and is_child=0)";
} else {
$where[] = "q.ques_id IN (SELECT ques_id FROM {pre}relate_knowledge \n where knowledge_id={$rule_knowledge} {$know_process_sql} and is_child=0)";
}
} else {
$where[] = "q.ques_id IN (SELECT ques_id FROM {pre}relate_knowledge \n where knowledge_id IN(" . implode(',', $knowledge_id_arr) . ") {$know_process_sql} and is_child=0)";
}
// if ($except_ids)
// {
// $where[] = "q.ques_id NOT IN (SELECT ques_id FROM {pre}relate_knowledge
// where knowledge_id IN(".implode(',', $except_ids).") {$know_process_sql} and is_child=0)";
// }
}
if ($type < 2) {
// 总数量
$sql = "SELECT COUNT(ques_id) nums FROM {pre}question q WHERE " . implode(' AND ', $where);
$query = $this->db->query($sql);
$row = $query->row_array();
$result['count'][0] = $row['nums'];
//--------------------------------------------//
// 统计关联试题数
// = 无分组试题数 + 分组数量
//--------------------------------------------//
$result['group_count'][0] = 0;
// 独立试题数（无分组）
$sql2 = "SELECT COUNT(q.ques_id) nums FROM {pre}question q \n WHERE " . implode(' AND ', $where) . " AND q.group_id=0";
$query = $this->db->query($sql2);
foreach ($query->result_array() as $row) {
$result['group_count'][0] = $row['nums'];
}
// 不同分组数
$sql2 = "SELECT COUNT(distinct q.group_id) nums FROM {pre}question q \n WHERE " . implode(' AND ', $where) . " AND q.group_id>0";
$query = $this->db->query($sql2);
foreach ($query->result_array() as $row) {
$result['group_count'][0] += $row['nums'];
}
die(json_encode($result));
}
// 重点知识点统计：按题型、难易度区间分组
$areas = C('difficulty_area');
if ($subject_id == 3) {
$result['count'] = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$result['group_count'] = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
} else {
$result['count'] = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$result['group_count'] = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
}
foreach ($areas as $k => $area) {
$new_where = $where;
$new_where[] = "qd.difficulty between {$area['0']} AND {$area['1']}";
$sql = "SELECT q.type, COUNT(q.ques_id) nums FROM {pre}question q \n LEFT JOIN {pre}relate_class qd ON q.ques_id=qd.ques_id AND qd.grade_id={$grade_id} AND qd.class_id={$class_id}\n WHERE " . implode(' AND ', $new_where) . " GROUP BY q.type";
//echo $sql ;die;
$query = $this->db->query($sql);
foreach ($query->result_array() as $row) {
if ($row['type'] > 9) {
continue;
}
$result['count'][$row['type'] * 3 + $k] = $row['nums'];
}
// 独立试题数
$sql2 = "SELECT q.type,COUNT(q.ques_id) nums FROM {pre}question q \n LEFT JOIN {pre}relate_class qd ON q.ques_id=qd.ques_id AND qd.grade_id={$grade_id} AND qd.class_id={$class_id}\n WHERE " . implode(' AND ', $new_where) . " AND q.group_id=0 GROUP BY q.type";
$query = $this->db->query($sql2);
foreach ($query->result_array() as $row) {
if ($row['type'] > 9) {
continue;
}
$result['group_count'][$row['type'] * 3 + $k] = $row['nums'];
}
// 分组试题数
$sql2 = "SELECT q.type, COUNT(distinct q.group_id) nums FROM {pre}question q \n LEFT JOIN {pre}relate_class qd ON q.ques_id=qd.ques_id AND qd.grade_id={$grade_id} AND qd.class_id={$class_id}\n WHERE " . implode(' AND ', $new_where) . " AND q.group_id>0 GROUP BY q.type";
$query = $this->db->query($sql2);
foreach ($query->result_array() as $row) {
if ($row['type'] > 9) {
continue;
}
$result['group_count'][$row['type'] * 3 + $k] += $row['nums'];
}
}
// echo $this->db->last_query();die;
die(json_encode($result));
}
function WriteCronScript($restore_values = false)
{
global $nl, $config, $databases, $cron_db_array, $cron_dbpraefix_array, $cron_db_cbd_array, $cron_db_cad_array, $dontBackupDatabases;
if (!isset($databases['db_selected_index'])) {
$databases['db_selected_index'] = 0;
}
if (!isset($databases['praefix'][$databases['db_selected_index']])) {
$databases['praefix'][$databases['db_selected_index']] = "";
}
if (!isset($databases['db_actual_cronindex'])) {
$databases['db_actual_cronindex'] = $databases['db_selected_index'];
}
if (!isset($config['email_maxsize'])) {
$config['email_maxsize'] = $config['email_maxsize1'] * ($config['email_maxsize2'] == 1 ? 1024 : 1024 * 1024);
}
$cron_dbname = $databases['db_actual'];
// -2 = Multidump configuration
// -3 = all databases - nothing to do
// get standard values for all databases
$cron_db_array = $databases['Name'];
$cron_dbpraefix_array = $databases['praefix'];
$cron_command_before_dump = $databases['command_before_dump'];
$cron_command_after_dump = $databases['command_after_dump'];
if (!isset($config['cron_dbindex'])) {
$config['cron_dbindex'] = -3;
}
if (intval($config['cron_dbindex']) == -2) {
// get selected dbs from multidump-settings
$cron_db_array = $databases['multi'];
$cron_dbpraefix_array = $databases['multi_praefix'];
$cron_command_before_dump = $databases['multi_commandbeforedump'];
$cron_command_after_dump = $databases['multi_commandafterdump'];
}
// we need to correct the index of the selected database after we cleaned
// the db-array from information_schema and mysql if it points to a db-name
if ($config['cron_dbindex'] >= 0) {
$cronDbIndexDbName = $databases['Name'][$config['cron_dbindex']];
} else {
$cronDbIndex = $config['cron_dbindex'];
}
$newDbNames = $databases['Name'];
//remove database we don't want to backup
// from newDbNames
foreach ($databases['Name'] as $k => $v) {
if (in_array($v, $dontBackupDatabases)) {
unset($newDbNames[$k]);
}
}
// and from cron (cron_db_array has different length to newDbNames: at least mysql and information_schema are missing)
foreach ($cron_db_array as $k => $v) {
if (in_array($v, $dontBackupDatabases)) {
unset($cron_db_array[$k], $cron_dbpraefix_array[$k], $cron_command_before_dump[$k], $cron_command_after_dump[$k]);
}
}
// find new index
if ($config['cron_dbindex'] >= 0) {
sort($newDbNames);
$dbNames = array_flip($newDbNames);
if (isset($dbNames[$cronDbIndexDbName])) {
$cronDbIndex = $dbNames[$cronDbIndexDbName];
} else {
$cronDbIndex = 0;
}
}
$r = str_replace("\\\\", "/", $config['paths']['root']);
$r = str_replace("@", "\\@", $r);
$p1 = $r . $config['paths']['backup'];
$p2 = $r . $config['files']['perllog'] . ($config['logcompression'] == 1 ? '.gz' : '');
$p3 = $r . $config['files']['perllogcomplete'] . ($config['logcompression'] == 1 ? '.gz' : '');
// auf manchen Server wird statt 0 ein leerer String gespeichert -> fuehrt zu einem Syntax-Fehler
// hier die entsprechenden Ja/Nein-Variablen sicherheitshalber in intvalues aendern
$int_array = array('dbport', 'cron_compression', 'cron_printout', 'multi_part', 'multipart_groesse', 'email_maxsize', 'auto_delete', 'max_backup_files', 'perlspeed', 'optimize_tables_beforedump', 'logcompression', 'log_maxsize', 'cron_completelog', 'cron_use_sendmail', 'cron_smtp_port');
foreach ($int_array as $i) {
if (is_array($i)) {
foreach ($i as $key => $val) {
$int_array[$key] = intval($val);
}
} else {
$config[$i] = intval($config[$i]);
}
}
if ($config['dbport'] == 0) {
$config['dbport'] = 3306;
}
$cronscript = "<?php\n#Vars - written at " . date("Y-m-d") . $nl;
$cronscript .= '$dbhost="' . $config['dbhost'] . '";' . $nl;
$cronscript .= '$dbname="' . $cron_dbname . '";' . $nl;
$cronscript .= '$dbuser="******";' . $nl;
$cronscript .= '$dbpass="******";' . $nl;
$cronscript .= '$dbport=' . $config['dbport'] . ';' . $nl;
$cronscript .= '$dbsocket="' . escape_specialchars($config['dbsocket']) . '";' . $nl;
$cronscript .= '$compression=' . $config['cron_compression'] . ';' . $nl;
$cronscript .= '$backup_path="' . $p1 . '";' . $nl;
$cronscript .= '$logdatei="' . $p2 . '";' . $nl;
$cronscript .= '$completelogdatei="' . $p3 . '";' . $nl;
$cronscript .= '$sendmail_call="' . escape_specialchars($config['cron_sendmail']) . '";' . $nl;
$cronscript .= '$nl="\\n";' . $nl;
$cronscript .= '$cron_dbindex=' . $cronDbIndex . ';' . $nl;
$cronscript .= '$cron_printout=' . $config['cron_printout'] . ';' . $nl;
$cronscript .= '$cronmail=' . $config['send_mail'] . ';' . $nl;
$cronscript .= '$cronmail_dump=' . $config['send_mail_dump'] . ';' . $nl;
$cronscript .= '$cronmailto="' . escape_specialchars($config['email_recipient']) . '";' . $nl;
$cronscript .= '$cronmailto_cc="' . escape_specialchars($config['email_recipient_cc']) . '";' . $nl;
$cronscript .= '$cronmailfrom="' . escape_specialchars($config['email_sender']) . '";' . $nl;
$cronscript .= '$cron_use_sendmail=' . $config['cron_use_sendmail'] . ';' . $nl;
$cronscript .= '$cron_smtp="' . escape_specialchars($config['cron_smtp']) . '";' . $nl;
$cronscript .= '$cron_smtp_port="' . $config['cron_smtp_port'] . '";' . $nl;
$cronscript .= '@cron_db_array=' . my_implode($cron_db_array);
$cronscript .= '@cron_dbpraefix_array=' . my_implode($cron_dbpraefix_array);
$cronscript .= '@cron_command_before_dump=' . my_implode($cron_command_before_dump);
$cronscript .= '@cron_command_after_dump=' . my_implode($cron_command_after_dump);
$cronscript .= '@ftp_server=' . my_implode($config['ftp_server']);
$cronscript .= '@ftp_port=' . my_implode($config['ftp_port'], 1);
$cronscript .= '@ftp_mode=' . my_implode($config['ftp_mode'], 1);
$cronscript .= '@ftp_user='******'ftp_user']);
$cronscript .= '@ftp_pass='******'ftp_pass']);
$cronscript .= '@ftp_dir=' . my_implode($config['ftp_dir']);
$cronscript .= '@ftp_timeout=' . my_implode($config['ftp_timeout'], 1);
$cronscript .= '@ftp_useSSL=' . my_implode($config['ftp_useSSL'], 1);
$cronscript .= '@ftp_transfer=' . my_implode($config['ftp_transfer'], 1);
$cronscript .= '$mp=' . $config['multi_part'] . ';' . $nl;
$cronscript .= '$multipart_groesse=' . $config['multipart_groesse'] . ';' . $nl;
$cronscript .= '$email_maxsize=' . $config['email_maxsize'] . ';' . $nl;
$cronscript .= '$auto_delete=' . $config['auto_delete'] . ';' . $nl;
$cronscript .= '$max_backup_files=' . $config['max_backup_files'] . ';' . $nl;
$cronscript .= '$perlspeed=' . $config['perlspeed'] . ';' . $nl;
$cronscript .= '$optimize_tables_beforedump=' . $config['optimize_tables_beforedump'] . ';' . $nl;
$cronscript .= '$logcompression=' . $config['logcompression'] . ';' . $nl;
$cronscript .= '$log_maxsize=' . $config['log_maxsize'] . ';' . $nl;
$cronscript .= '$complete_log=' . $config['cron_completelog'] . ';' . $nl;
$cronscript .= '$my_comment="' . escape_specialchars(stripslashes($config['cron_comment'])) . '";' . $nl;
$cronscript .= "?>";
// Save config
$ret = true;
$sfile = $config['paths']['config'] . $config['config_file'] . '.conf.php';
if (file_exists($sfile)) {
@unlink($sfile);
}
if ($fp = fopen($sfile, "wb")) {
if (!fwrite($fp, $cronscript)) {
$ret = false;
}
if (!fclose($fp)) {
$ret = false;
}
@chmod("{$sfile}", 0777);
} else {
$ret = false;
}
// if standard config was deleted -> restore it with the actual values
if (!file_exists($config['paths']['config'] . "mysqldumper.conf.php")) {
$sfile = $config['paths']['config'] . 'mysqldumper.conf.php';
if ($fp = fopen($sfile, "wb")) {
if (!fwrite($fp, $cronscript)) {
$ret = false;
}
if (!fclose($fp)) {
$ret = false;
}
@chmod("{$sfile}", 0777);
} else {
$ret = false;
}
}
return $ret;
}
/**
* 添加 考场 监考人员
*/
public function insert()
{
if (!$this->check_power('exam_manage')) {
return;
}
$place_id = (int) $this->input->post('place_id');
if ($place_id) {
$query = $this->db->select('p.*')->from('exam_place p')->join('exam e', 'p.exam_pid=e.exam_id')->join('school sch', 'p.school_id=sch.school_id')->where(array('p.place_id' => $place_id))->get();
$place = $query->row_array();
}
if (empty($place)) {
message('考场信息不存在', 'admin/exam/index');
return;
}
$ids = $this->input->post('id');
if (empty($ids) or !is_array($ids)) {
message('请至少选择一项');
return;
}
//控制考场只能在未开始考试操作
$no_start = ExamPlaceModel::place_is_no_start($place_id);
if (!$no_start) {
message('该考场正在考试或已结束，无法做此操作');
}
$ids = my_intval($ids);
$inserts = array();
//获取未被分配考场的监考人员
/*
* 同一个监考人员不能同时出现在 相同时段的考场中
*/
$place['start_time'] = $place['start_time'] + 1;
$place['end_time'] = $place['end_time'] - 1;
$sql = "SELECT i.invigilator_id FROM {pre}invigilator i \n WHERE i.invigilator_flag=1 AND i.invigilator_id IN(" . my_implode($ids) . ")\n AND NOT EXISTS(SELECT ps.invigilator_id FROM {pre}exam_place_invigilator ps,{pre}exam_place p WHERE ps.place_id=p.place_id AND ps.invigilator_id=i.invigilator_id and ((p.start_time >= {$place['start_time']} and p.start_time <= {$place['end_time']}) OR (p.end_time >= {$place['start_time']} and p.end_time <= {$place['end_time']}) OR (p.start_time <= {$place['start_time']} and p.end_time >= {$place['end_time']})))";
//已经分配有考场的监考人员列表
$failed_ids = array();
$success_ids = array();
$result = $this->db->query($sql)->result_array();
foreach ($result as $row) {
$inserts[] = array('place_id' => $place_id, 'invigilator_id' => $row['invigilator_id']);
$success_ids[] = $row['invigilator_id'];
}
$failed_ids = array_diff($ids, $success_ids);
$res = 0;
if ($inserts) {
// 关闭错误信息，防止 unique index 冲突出错
$this->db->db_debug = false;
$this->db->insert_batch('exam_place_invigilator', $inserts);
$res = $this->db->affected_rows();
}
$back_url = 'admin/place_invigilator/index/' . $place_id;
if ($res < 1) {
message('监考人员添加失败', $back_url);
} else {
$failed_i_names = array();
foreach ($failed_ids as $id) {
$i_name = ExamInvigilatorModel::get_invigilator_by_id($id, 'name');
if ($i_name) {
$failed_i_names[] = $i_name;
}
}
$msg = array('监考人员添加成功');
if (count($failed_i_names)) {
$msg[] = '<hr/>以下监考人员已经分配了考场:<br/>' . implode('<br/>', $failed_i_names);
}
message(implode('', $msg), $back_url);
}
}
/**
* 将已取到的试题关联的方法策略分类对应的试题数 进行升序排，
* 试题不够时，用这些方法策略分类关联的其他试题来补齐
*/
private static function _get_inserted_question_method_tactics($ques_ids)
{
$method_tactics = Fn::db()->fetchAll("SELECT method_tactic_id, COUNT(*) AS `count`\n \t FROM rd_relate_method_tactic\n \t WHERE ques_id IN (" . my_implode($ques_ids) . ")\n \t GROUP BY method_tactic_id ORDER BY `count` ASC LIMIT 10");
$method_tactic_ids = array();
foreach ($method_tactics as $row) {
$method_tactic_ids[] = $row['method_tactic_id'];
}
return $method_tactic_ids;
}
/**
* 试卷加入试题
*
* @param int $paper_id 试卷id
* @param int $ques_ids 试题id
* @return void
*/
public function insert()
{
if (!$this->check_power('exam_manage')) {
return;
}
$paper_id = intval($this->input->post('paper_id'));
$ques_ids = trim($this->input->post('ques_ids'));
if (empty($ques_ids)) {
message('请选择要添加的试题');
return;
}
$paper = ExamPaperModel::detail($paper_id);
if (empty($paper)) {
message('试卷不存在');
return;
}
$exam = ExamModel::get_exam($paper['exam_id'], 'exam_pid,subject_id,grade_id,class_id');
if (empty($exam)) {
message('考试不存在');
return;
}
//判断该试卷已经被考试过 或 正在被考
$is_mini_test = ExamModel::is_mini_test($exam['exam_pid']);
if (!$is_mini_test) {
$be_tested = QuestionModel::paper_has_test_action($paper_id);
if ($be_tested) {
message('该试卷已经被考生考过 或者 正在被考， 无法修改');
}
}
$ques_ids = my_intval(explode(',', $ques_ids));
$this->check_total_score($paper_id, $ques_ids);
$sql = "SELECT q.ques_id,q.group_id FROM {pre}question q,{pre}relate_class rc\n WHERE q.ques_id=rc.ques_id AND q.subject_id={$exam['subject_id']} AND rc.grade_id={$exam['grade_id']}\n AND rc.class_id={$exam['class_id']} AND q.ques_id IN (" . my_implode($ques_ids) . ")";
$query = $this->db->query($sql);
$inserts = array();
$fail = $success = 0;
$msg = array();
foreach ($query->result_array() as $row) {
if (in_array($row['ques_id'], $paper['ques_ids']) or $row['group_id'] && in_array($row['group_id'], $paper['group_ids'])) {
$fail++;
$msg[] = '该试卷同一试题已存在或者同一分组中的试题已存在！';
continue;
}
$success++;
$item = array('paper_id' => $paper['paper_id'], 'exam_id' => $paper['exam_id'], 'ques_id' => $row['ques_id']);
$inserts[] = $item;
$paper['ques_ids'][] = $row['ques_id'];
if ($row['group_id']) {
$paper['group_ids'][] = $row['group_id'];
}
}
if ($inserts) {
$this->db->insert_batch('exam_question', $inserts);
ExamPaperModel::renew($paper_id);
if ($is_mini_test) {
SummaryModel::summary_paper($exam['exam_pid'], 0, $paper_id, true);
}
}
$msg = '成功' . $success . '个,失败' . $fail . '个失败原因:<br>' . implode('<br>', $msg);
message('试卷试题添加成功' . $msg, 'admin/exam_question/index/' . $paper_id);
}
/**
* 计算知识点关联的试题数量，返回知识点信息数组
* @param mixed 知识点数组/知识点id
* @return array
*/
public static function get_konwledge_ques_num($knowledge = array())
{
if (!is_array($knowledge) && $knowledge) {
$knowledge = self::get_knowledge(intval($knowledge));
}
if (empty($knowledge)) {
return array();
}
$id = $knowledge['id'];
$pid = $knowledge['pid'];
$where = array();
$where[] = "q.ques_id = rk.ques_id";
$where[] = "q.is_delete <> 1";
$where[] = "q.parent_id = 0";
// 如果是一级知识点，获取下级知识点id
if ($pid == 0) {
$ids = self::get_knowledge_list(0, $id, 0);
$ids = array_keys($ids);
$knowledge['children'] = count($ids);
}
//--------------------------------------------//
// 统计试题数
//--------------------------------------------//
if ($pid || empty($ids)) {
$where[] = "rk.knowledge_id = {$id}";
} else {
if (count($ids) == 1) {
$where[] = "rk.knowledge_id = {$ids['0']}";
} else {
$where[] = "rk.knowledge_id IN (" . my_implode($ids) . ")";
}
}
$sql = "SELECT COUNT(DISTINCT q.ques_id) nums FROM rd_question q, rd_relate_knowledge rk \n WHERE " . implode(' AND ', $where) . ' AND rk.is_child = 0';
$row = Fn::db()->fetchRow($sql);
$knowledge['ques_num'] = (int) $row['nums'];
//--------------------------------------------//
// 统计关联试题数
// = 无分组试题数 + 分组数量
//--------------------------------------------//
// 独立试题数
$sql = "SELECT COUNT(DISTINCT q.ques_id) nums FROM rd_question q, rd_relate_knowledge rk \n WHERE " . implode(' AND ', $where) . " AND q.group_id = 0 AND rk.is_child = 0";
$row = Fn::db()->fetchRow($sql);
$knowledge['relate_ques_num'] = (int) $row['nums'];
// 分组数
$sql = "SELECT COUNT(distinct q.group_id) nums FROM rd_question q,rd_relate_knowledge rk \n WHERE " . implode(' AND ', $where) . " AND q.group_id > 0 AND rk.is_child = 0";
$row = Fn::db()->fetchRow($sql);
$knowledge['relate_ques_num'] += (int) $row['nums'];
return $knowledge;
}
/**
* @description 添加期次科目试卷
* @author
* @final
* @param int $exam_id 考试期次id
* @param array $ids 试卷id
*/
public function insert()
{
if (!$this->check_power('exam_manage')) {
return;
}
$exam_id = (int) $this->input->post('exam_id');
$exam_id && ($exam = ExamModel::get_exam($exam_id, 'exam_id,exam_pid,grade_id,class_id'));
if (empty($exam)) {
message('考试期次科目不存在', 'admin/exam/index');
return;
}
$ids = $this->input->post('ids');
if (empty($ids) or !is_array($ids)) {
message('请至少选择一项');
return;
}
//检查该学科考试状态
$has_tested = ExamPlaceSubjectModel::exam_subject_has_test_action($exam_id);
if ($has_tested) {
message('该期次科目已经被考生考过 或者 正在被考中,因此无法操作');
}
$ids = my_intval($ids);
/* ------------------------------- */
/* 补全外部新试卷信息 */
foreach ($ids as $paper_id) {
/* 查询试卷信息 */
$paper = PaperModel::get_paper_by_id($paper_id, 'paper_id,admin_id,question_sort');
/* 判定是否为外部试卷 */
if ($paper['admin_id'] > 0) {
$questions = json_decode($paper['question_sort'], true);
$qtype_ques_num = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$question_difficulty = array();
$this->db->trans_start();
$sql = "DELETE FROM rd_exam_question WHERE paper_id={$paper_id} \n AND exam_id={$exam_id}";
Fn::db()->query($sql);
if (count($questions) > 0) {
foreach ($questions as $ques_id) {
/* 补全exam_question信息 */
$data = array();
$data['paper_id'] = $paper_id;
$data['exam_id'] = $exam_id;
$data['ques_id'] = $ques_id;
$this->db->insert('exam_question', $data);
$sql = "select q.ques_id,q.type,rc.difficulty from\n {pre}question q left join {pre}relate_class rc on q.ques_id=rc.ques_id\n where q.ques_id={$ques_id} and rc.grade_id={$exam['grade_id']} and rc.class_id={$exam['class_id']}";
$question = $this->db->query($sql)->row_array();
if (empty($question)) {
$this->db->trans_rollback();
message('当前试卷中存在不属于当前考试期次年级的试题！请检查试题！');
exit;
}
/* 各个类型试题数量 */
$qtype_ques_num[$question['type']]++;
/* 试题难易度 */
$question_difficulty[] = $question['difficulty'];
}
}
/* 补全exam_pager信息 */
$data = array();
$data['exam_id'] = $exam_id;
$data['qtype_ques_num'] = implode(',', $qtype_ques_num);
$data['difficulty'] = array_sum($question_difficulty) / count($question_difficulty);
PaperModel::update_paper($paper_id, $data);
$this->db->trans_complete();
}
}
/* -------------------------------------- */
$inserts = array();
$sql = "SELECT p.paper_id,e.subject_id FROM {pre}exam_paper p,{pre}exam e\n WHERE p.exam_id=e.exam_id AND p.paper_id IN (" . my_implode($ids) . ")\n AND p.is_delete=0 AND p.exam_id={$exam_id}";
$query = $this->db->query($sql);
foreach ($query->result_array() as $row) {
$inserts[] = array('exam_pid' => $exam['exam_pid'], 'exam_id' => $exam['exam_id'], 'paper_id' => $row['paper_id'], 'subject_id' => $row['subject_id']);
}
$res = 0;
if ($inserts) {
// 关闭错误信息，防止 unique index 冲突出错
$this->db->db_debug = false;
$this->db->insert_batch('exam_subject_paper', $inserts);
$res = $this->db->affected_rows();
}
$back_url = 'admin/subject_paper/add/' . $exam_id;
if ($res < 1) {
message('试卷添加失败', $back_url);
} else {
message('试卷添加成功', $back_url);
}
}
public function insert()
{
if (!$this->check_power('exam_manage')) {
return;
}
$place_id = (int) $this->input->post('place_id');
if ($place_id) {
$query = $this->db->select('p.*,e.exam_name,e.exam_id,e.exam_pid,e.grade_id,sch.school_name')->from('exam_place p')->join('exam e', 'p.exam_pid=e.exam_id')->join('school sch', 'p.school_id=sch.school_id')->where(array('p.place_id' => $place_id))->get();
$place = $query->row_array();
}
if (empty($place)) {
message('考场信息不存在', 'admin/exam/index');
return;
}
$ids = $this->input->post('ids');
if (empty($ids) or !is_array($ids)) {
message('请至少选择一项');
return;
}
// 控制考场只能在未开始考试操作
$no_start = ExamPlaceModel::place_is_no_start($place_id);
if (!$no_start) {
message('该考场正在考试或已结束，无法做此操作');
}
$ids = my_intval($ids);
$school_id = (int) $this->input->post('school_id');
$inserts = array();
// 该考场所考到的学科
$subject_ids = array();
$query = $this->db->select('subject_id')->from('exam_place_subject')->where(array('place_id' => $place['place_id']))->get();
$subjects = $query->row_array();
$subject_ids = array();
foreach ($subjects as $subject) {
$subject_ids[] = $subject['subject_id'];
}
$subject_ids = count($subject_ids) ? implode(',', $subject_ids) : '""';
$place['start_time'] = $place['start_time'] + 1;
$place['end_time'] = $place['end_time'] - 1;
$not_exists_sql = "SELECT uid FROM {pre}exam_place_student ps,{pre}exam_place p WHERE ps.place_id=p.place_id AND p.place_index={$place['place_index']} AND ps.uid=u.uid AND (((p.start_time >= {$place['start_time']} and p.start_time <= {$place['end_time']}) OR (p.end_time >= {$place['start_time']} and p.end_time <= {$place['end_time']}) OR (p.start_time <= {$place['start_time']} and p.end_time >= {$place['end_time']})) OR p.place_id IN(select distinct(place_id) from {pre}exam_place_subject eps where eps.subject_id in({$subject_ids}) and eps.exam_pid={$place['exam_id']}))";
$sql = "SELECT u.uid FROM {pre}student u\n WHERE u.school_id={$school_id} AND u.grade_id={$place['grade_id']} AND u.is_delete=0 AND u.uid IN(" . my_implode($ids) . ")\n AND NOT EXISTS({$not_exists_sql})";
$query = $this->db->query($sql);
foreach ($query->result_array() as $row) {
$inserts[] = array('place_id' => $place_id, 'uid' => $row['uid']);
}
// 添加学生时分配试卷
$this->load->model('cron/cron_place_student_paper_model', 'cron_place_student_paper_model');
$uids = array();
foreach ($inserts as $key => $val) {
$uids[] = $val['uid'];
$place_id = $val['place_id'];
}
$insert_data = array('place_id' => $place_id, 'uid_data' => json_encode($uids));
$this->cron_place_student_paper_model->insert($insert_data);
// end
$res = 0;
if ($inserts) {
// 关闭错误信息，防止 unique index 冲突出错
$this->db->db_debug = false;
$this->db->insert_batch('exam_place_student', $inserts);
$res = $this->db->affected_rows();
}
$back_url = 'admin/place_student/add/manual/' . $place_id;
if ($res < 1) {
message('考生添加失败', $back_url);
} else {
message('考生添加成功', $back_url);
}
}
