Example #1
0
 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']) {
Example #2
0
             }
             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))) . "',";