/** * 新增/编辑授课教师页面 * @param int $scht_schid 学校ID * @param int $ct_id 授课教师ID,若为0表新增,否则表编辑 */ public function editteacher($scht_schid = 0, $ct_id = 0) { if (!$scht_schid) { message('参数错误'); } $data = array(); $data['scht_schid'] = $scht_schid; Fn::ajax_call($this, 'setSchoolTeacher'); $ct_id = intval($ct_id); if ($ct_id) { $data['ct_info'] = CTeacherModel::CTeacherInfo($ct_id); if (empty($data['ct_info'])) { message('查询无记录', 'admin/school/teacherlist/' . $scht_schid); } } else { $data['ct_info'] = array('ct_id' => 0, 'ct_flag' => time()); } $data['subject_map'] = C('subject'); $data['grade_map'] = C('grades'); $v = CTeacherModel::CTeacherGradeIDPairs($ct_id); if (isset($v[$ct_id])) { $v = $v[$ct_id]; } else { $v = array(); } $data['cteacher_gradeid'] = $v; $v = CTeacherModel::CTeacherSubjectIDPairs($ct_id); if (isset($v[$ct_id])) { $v = $v[$ct_id]; } else { $v = array(); } $data['cteacher_subjectid'] = $v; // 模版 $this->load->view('school/editteacher', $data); }
/** * 新增/编辑授课教师页面 * @param int $ct_id 授课教师ID,若为0表新增,否则表编辑 */ public function setctinfo($ct_id) { Fn::ajax_call($this, 'setCT'); $ct_id = intval($ct_id); $data = array(); if ($ct_id) { $data['ct_info'] = CTeacherModel::CTeacherInfo($ct_id); if (empty($data['ct_info'])) { message('查询无记录', 'admin/cteacher/ctlist'); } } else { $data['ct_info'] = array('ct_id' => 0, 'ct_flag' => time()); } $data['subject_map'] = C('subject'); $data['grade_map'] = C('grades'); //$data['subject_map'][0] = '[全部学科]'; //$data['grade_map'][0] = '[全部年级]'; $v = CTeacherModel::CTeacherGradeIDPairs($ct_id); if (isset($v[$ct_id])) { $v = $v[$ct_id]; } else { $v = array(); } $data['cteacher_gradeid'] = $v; $v = CTeacherModel::CTeacherSubjectIDPairs($ct_id); if (isset($v[$ct_id])) { $v = $v[$ct_id]; } else { $v = array(); } $data['cteacher_subjectid'] = $v; if ($ct_id) { $sql = <<<EOT SELECT a.cc_id, a.tc_name, b.ti_name, b.cors_name FROM v_course_campus a LEFT JOIN v_course b on a.cc_corsid = b.cors_id WHERE a.cc_id IN ( SELECT cct_ccid FROM t_course_campus_teacher WHERE cct_ctid = {$ct_id}) EOT; $data['cteacher_cclist'] = Fn::db()->fetchAll($sql); } $this->load->view('cteacher/setctinfo', $data); }