unset($scheduleAssociation); unset($gradeAssociation); $tot_seat = $_REQUEST['tables']['course_periods'][$_REQUEST['course_period_id']]['TOTAL_SEATS']; $does_attn = $_REQUEST['tables']['course_period_var'][$_REQUEST['course_period_id']]['DOES_ATTENDANCE']; if ($tot_seat != '') { $seat_num = DBGet(DBQuery('SELECT FILLED_SEATS FROM course_periods WHERE COURSE_PERIOD_ID=\'' . $_REQUEST['course_period_id'] . '\' LIMIT 0,1 ')); if ($seat_num[1]['FILLED_SEATS'] > $tot_seat) { $tot_seat = 'error'; } } $update = true; if ($tot_seat != '' && $does_attn != '') { if (scheduleAssociation($id)) { $scheduleAssociation = true; } if (gradeAssociation($id)) { $gradeAssociation = true; } } if ($tot_seat != 'error') { if (!$scheduleAssociation && !$gradeAssociation) { if ($table_name == 'courses' && $columns['SUBJECT_ID'] && $columns['SUBJECT_ID'] != $_REQUEST['subject_id']) { $_REQUEST['subject_id'] = $columns['SUBJECT_ID']; } $sql = "UPDATE {$table_name} SET "; if ($table_name == 'course_periods') { $current = DBGet(DBQuery("SELECT TEACHER_ID,MARKING_PERIOD_ID,SHORT_NAME,TOTAL_SEATS,CALENDAR_ID FROM course_periods WHERE " . $where[$table_name] . "='{$id}'")); if ($scheduleAssociation) { $cur_total_seat = $current[1]['TOTAL_SEATS']; } if ($columns['TEACHER_ID']) {
} if ($check_attn['ATTENDANCE'] == 'Y') { $sql .= $column . "='" . str_replace("'", "''", str_replace("\\'", "'", $value)) . "',"; $go = true; } } } else { $sql .= $column . "='" . str_replace("'", "''", str_replace("\\'", "'", $value)) . "',"; $go = true; } } else { if (!gradeAssociation($id) && ($column == 'COURSE_WEIGHT' || $column == 'GRADE_SCALE_ID' || $column == 'SECONDARY_TEACHER_ID' || $column == 'TEACHER_ID' || $column == 'CREDITS' || $column == 'DOES_BREAKOFF' || $column == 'DOES_HONOR_ROLL' || $column == 'HALF_DAY' || $column == 'DOES_CLASS_RANK')) { $sql .= $column . "='" . str_replace("'", "''", $value) . "',"; $go = true; } else { if (gradeAssociation($id) && ($column == 'TEACHER_ID' || $column == 'SECONDARY_TEACHER_ID' || $column == 'GRADE_SCALE_ID' || $column == 'CREDITS' || $column == 'DOES_BREAKOFF' || $column == 'DOES_HONOR_ROLL' || $column == 'HALF_DAY' || $column == 'DOES_CLASS_RANK')) { $flag_err = 'Y'; } if (scheduleAssociation($id) && ($column == 'ROOM_ID' || $column == 'DAYS' || $column == 'PERIOD_ID' || $column == 'MARKING_PERIOD_ID')) { $flag_err = 'Y'; } if ($table_name == 'courses' || $table_name == 'course_subjects') { $sql .= $column . "='" . str_replace("'", "''", $value) . "',"; $go = true; } if (!scheduleAssociation($id) && ($column == 'MARKING_PERIOD_ID' || $column == 'MP' || $column == 'GENDER_RESTRICTION' || $column == 'PARENT_ID')) { $sql .= $column . "='" . str_replace("'", "''", $value) . "',"; $go = true; } if (!scheduleAssociation($id) && ($column == 'BEGIN_DATE' || $column == 'END_DATE')) { $sql .= $column . "='" . str_replace("'", "''", date('Y-m-d', strtotime($value))) . "',";