/**
* 新增/编辑授课教师页面
* @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);
}
