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) {