public function baseFetchCORSListFunc($param) { $resp = new AjaxResponse(); $param = Func::param_copy($param, 'grade_id', 'cors_tiid', 'cors_name', 'cors_cmid'); $grade_id = $param['grade_id']; unset($param['grade_id']); if (empty($param['cors_tiid'])) { $resp->alert('请先选择培训机构'); return $resp; } if ($param['cors_name'] == '') { unset($param['cors_name']); } if ($param['cors_cmid'] == '') { unset($param['cors_cmid']); } try { $cors_list = CourseModel::courseList('cors_id,cors_name,cors_cmid', $param); if (!empty($cors_list)) { $cors_id_arr = array(); foreach ($cors_list as $v) { $cors_id_arr[] = $v['cors_id']; } $cors_id_str = implode(',', $cors_id_arr); $sql = <<<EOT SELECT DISTINCT cg_corsid FROM t_course_gradeid WHERE cg_corsid IN ({$cors_id_str}) AND (cg_gradeid = 0 OR cg_gradeid = {$grade_id}) EOT; $cors_id2_arr = Fn::db()->fetchCol($sql); if (!empty($cors_id2_arr)) { $cors_id2_str = implode(',', $cors_id2_arr); $sql = <<<EOT SELECT cors_id, cors_name, cors_cmid FROM t_course WHERE cors_id IN ({$cors_id2_str}) EOT; $cors_list2 = Fn::db()->fetchAll($sql); $resp->call('fnSetCORSListDiv', $cors_list2); } else { $resp->call('fnSetCORSListDiv', $cors_list); } } else { $resp->call('fnSetCORSListDiv', array()); } } catch (Exception $e) { $resp->alert($e->getMessage()); } return $resp; }
/** * 选择课程校区列表页面 */ public function selcorscampuslist() { $param = array(); if (isset($_GET['page'])) { $page = intval($_GET['page']); if ($page < 1) { $page = 1; } } else { $page = 1; } $param['cors_name'] = $this->input->get('cors_name'); $param['ti_name'] = $this->input->get('ti_name'); $param['cors_cmid'] = $this->input->get('cors_cmid'); $param['grade_id_str'] = $this->input->get('grade_id_str'); $param['subject_id_str'] = $this->input->get('subject_id_str'); $param['class_id_str'] = $this->input->get('class_id_str'); $data = array(); $data['param'] = $param; $data['mode_list'] = CourseModel::courseModeList(); $data['cors_list'] = CourseModel::courseList('*', $param, $page); $data['cors_list_count'] = CourseModel::courseListCount($param); $cors_id_arr = array(); if (!empty($data['cors_list'])) { foreach ($data['cors_list'] as $v) { $cors_id_arr[] = $v['cors_id']; } } $cors_id_str = implode(',', $cors_id_arr); unset($cors_id_arr); $data['subject_map'] = C('subject'); $data['grade_map'] = C('grades'); $data['subject_map'][0] = '[全部学科]'; $data['grade_map'][0] = '[全部年级]'; $sql = <<<EOT SELECT class_id, class_name FROM rd_question_class ORDER BY sort_order EOT; $data['classid_map'] = Fn::db()->fetchPairs($sql); if ($cors_id_str) { $data['cors_gradeid'] = CourseModel::courseGradeIDPairs($cors_id_str); $data['cors_subjectid'] = CourseModel::courseSubjectIDPairs($cors_id_str); $data['cors_classid'] = CourseModel::courseClassIDPairs($cors_id_str); } else { $data['cors_gradeid'] = array(); $data['cors_subjectid'] = array(); $data['cors_classid'] = array(); } if ($cors_id_str) { $cors_campus_list = CourseModel::courseCampusList('*', array('cc_corsid' => $cors_id_str)); } else { $cors_campus_list = array(); } $cors_campus_map = array(); foreach ($cors_campus_list as $v) { if (!isset($cors_campus_map[$v['cc_corsid']])) { $cors_campus_map[$v['cc_corsid']] = array(); } $cors_campus_map[$v['cc_corsid']][] = $v; } unset($cors_campus_list); $data['cors_campus_map'] = $cors_campus_map; $this->load->view('course/selcorscampuslist', $data); }