if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = trim($teacher['LAST_NAME']) . ', ' . $teacher['FIRST_NAME'] . ' ' . $teacher['MIDDLE_NAME'];
}
}
// ECHO 'SELECT TEACHER FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='.$_REQUEST['course_period_id'].'';
if ($_REQUEST['course_period_id'] != 'new') {
$qr = DBGET(DBQuery('SELECT TEACHER_ID FROM course_periods WHERE COURSE_PERIOD_ID=' . $_REQUEST['course_period_id'] . ''));
$teacher_id = $qr[1]['TEACHER_ID'];
$qr1 = DBGet(DBQuery('SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM staff WHERE STAFF_ID=' . $qr[1]['TEACHER_ID'] . ''));
$k = $qr1[1]['STAFF_ID'];
$teachers[$k] = trim($qr1[1]['LAST_NAME']) . ', ' . $qr1[1]['FIRST_NAME'] . ' ' . $qr1[1]['MIDDLE_NAME'];
}
//
if ($RET['AVAILABLE_SEATS'] != $RET['TOTAL_SEATS']) {
$header .= '<TD>' . SelectInputDisabledMsg($RET['TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TEACHER_ID]', 'Teacher / 任课教师', $teachers, 'N/A', '', $div, "Not allowed") . '</TD>';
} else {
$header .= '<TD>' . SelectInput($RET['TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TEACHER_ID]', 'Teacher / 任课教师', $teachers, 'N/A', '', $div) . '</TD>';
}
//$header .= '<TD>' . SelectInput($RET['SECONDARY_TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][SECONDARY_TEACHER_ID]', 'Secondary Teacher', $teachers,'N/A','',$div) . '</TD>';
$header .= '<TD>' . TextInput($RET['TOTAL_SEATS'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TOTAL_SEATS]', 'Seats / 课程人数', 'size=4 class=cell_floating', $div) . '</TD>';
if ($_REQUEST['course_period_id'] != 'new') {
$header .= '<TD><FONT color=green>' . $RET['AVAILABLE_SEATS'] . '</FONT><BR><FONT color=gray><SMALL>Available Seats / 空位</SMALL></FONT></TD>';
} else {
$header .= '<TD> </TD>';
}
$header .= '</TR>';
$header .= '<TR>';
$options_RET = DBGet(DBQuery("SELECT TITLE,ID FROM report_card_grade_scales WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
$options = array();
foreach ($options_RET as $option) {
if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = trim($teacher['LAST_NAME']) . ', ' . $teacher['FIRST_NAME'] . ' ' . $teacher['MIDDLE_NAME'];
}
}
// ECHO 'SELECT TEACHER FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='.$_REQUEST['course_period_id'].'';
if ($_REQUEST['course_period_id'] != 'new') {
$qr = DBGET(DBQuery('SELECT TEACHER_ID FROM course_periods WHERE COURSE_PERIOD_ID=' . $_REQUEST['course_period_id'] . ''));
$teacher_id = $qr[1]['TEACHER_ID'];
$qr1 = DBGet(DBQuery('SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM staff WHERE STAFF_ID=' . $qr[1]['TEACHER_ID'] . ''));
$k = $qr1[1]['STAFF_ID'];
$teachers[$k] = trim($qr1[1]['LAST_NAME']) . ', ' . $qr1[1]['FIRST_NAME'] . ' ' . $qr1[1]['MIDDLE_NAME'];
}
//
if ($RET['AVAILABLE_SEATS'] != $RET['TOTAL_SEATS']) {
$header .= '<TD>' . SelectInputDisabledMsg($RET['TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TEACHER_ID]', 'Primary Teacher', $teachers, 'N/A', '', $div, "To Change teacher go to School Setup->Courses->Teacher Re-Assignment") . '</TD>';
} else {
$header .= '<TD>' . SelectInput($RET['TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TEACHER_ID]', 'Primary Teacher', $teachers, 'N/A', '', $div) . '</TD>';
}
$header .= '<TD>' . SelectInput($RET['SECONDARY_TEACHER_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][SECONDARY_TEACHER_ID]', 'Secondary Teacher', $teachers, 'N/A', '', $div) . '</TD>';
$header .= '<TD>' . TextInput($RET['TOTAL_SEATS'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][TOTAL_SEATS]', 'Seats', 'size=4 class=cell_floating', $div) . '</TD>';
if ($_REQUEST['course_period_id'] != 'new') {
$header .= '<TD><FONT color=green>' . $RET['AVAILABLE_SEATS'] . '</FONT><BR><FONT color=gray><SMALL>Available Seats</SMALL></FONT></TD>';
} else {
$header .= '<TD> </TD>';
}
$header .= '</TR>';
$header .= '<TR>';
$options_RET = DBGet(DBQuery("SELECT TITLE,ID FROM report_card_grade_scales WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
$options = array();
foreach ($options_RET as $option) {
