Пример #1
0
                             $up_cpv_sql = substr($up_cpv_sql, 0, -1);
                             $up_cpv_sql .= " WHERE ID='" . $period['ID'] . "'";
                             //                                    echo '<br>';
                             if ($not_pass_update == false) {
                                 DBQuery($up_cpv_sql);
                             }
                         }
                     }
                 }
                 if ($error) {
                     echo $error;
                 }
             }
             if (($scheduleAssociation || $gradeAssociation) && is_array($asso_err)) {
                 foreach ($asso_err as $err) {
                     ShowErrPhp($err);
                 }
             }
         }
     } else {
         echo "<font color=red><b>Cannot Modify this course period as it has association. </b></font>";
     }
 } else {
     $update = false;
     $sql = "INSERT INTO {$table_name} ";
     if ($table_name == 'course_subjects') {
         $id = DBGet(DBQuery("SHOW TABLE STATUS LIKE 'course_subjects'"));
         $id[1]['ID'] = $id[1]['AUTO_INCREMENT'];
         $fields = 'SCHOOL_ID,SYEAR,';
         $values = "'" . UserSchool() . "','" . UserSyear() . "',";
         $_REQUEST['subject_id'] = $id[1]['ID'];
Пример #2
0
                }
            }
        }
        if ($_REQUEST['values'][$note_id]['PUBLISHED_PROFILES']) {
            $_REQUEST['values'][$note_id]['PUBLISHED_PROFILES'] .= ',';
        }
    }
}
if (clean_param($_REQUEST['values'], PARAM_NOTAGS) && ($_POST['values'] || $_REQUEST['ajax']) && AllowEdit() && !$_REQUEST['portal_search']) {
    foreach ($_REQUEST['values'] as $id => $columns) {
        if (!(isset($columns['TITLE']) && trim($columns['TITLE']) == '')) {
            if ($id != 'new') {
                $portal_RET = DBGet(DBQuery('SELECT START_DATE,END_DATE FROM portal_notes WHERE ID=\'' . $id . '\''));
                $portal_RET = $portal_RET[1];
                if (strtotime($columns['START_DATE']) > strtotime($columns['END_DATE']) && $columns['END_DATE'] != '' || strtotime($columns['START_DATE']) > strtotime($portal_RET['END_DATE']) && $portal_RET['END_DATE'] != '' || strtotime($portal_RET['START_DATE']) > strtotime($columns['END_DATE']) && $columns['END_DATE'] != '' || isset($columns['START_DATE']) && $columns['START_DATE'] == '' && $columns['END_DATE'] != '') {
                    ShowErrPhp('Data not saved because  date range is not valid');
                } else {
                    $sql = 'UPDATE portal_notes SET ';
                    if ($allschool == 'Y') {
                        $sql .= 'SCHOOL_ID=NULL, ';
                    }
                    #################### code differ for windows and Linux machine ########################
                    foreach ($columns as $column => $value) {
                        $value = paramlib_validation($column, $value);
                        //                                                        if(stripos($_SERVER['SERVER_SOFTWARE'], 'linux')){
                        $value = str_replace("'", "\\'", $value);
                        //                                                        }
                        #$sql .= $column."='".str_replace("'", "\'",$value)."',"; // for linux Machine
                        $sql .= $column . "='" . trim($value) . "',";
                        // for Windows Machine
                        #$values .= "'".$value."',";
Пример #3
0
        $extra['ORDER'] = ' ,sa.ID';
        $RET = GetStuList($extra);
        if (count($RET)) {
            $column_name = array('STUDENT_ID' => 'Student ID', 'ALT_ID' => 'Alternate ID', 'FULL_NAME' => 'Student', 'CONTACT_TYPE' => 'Type', 'RELATION' => 'Relation', 'RELATION_NAME' => 'Relation\'s Name', 'STREET' => 'Street', 'ADDRESS' => 'Address', 'CITY' => 'City', 'STATE' => 'State', 'ZIP' => 'Zip', 'WORK_PHONE' => 'Work Phone', 'HOME_PHONE' => 'Home Phone', 'CELL_PHONE' => 'Cell Phone', 'EMAIL_ID' => 'Email Address');
            $singular = 'Student Contact';
            $plural = 'Student Contacts';
            $options = array('search' => false);
            echo '<div style="overflow:auto; width:820px; overflow-x:scroll;">';
            ListOutput($RET, $column_name, $singular, $plural, $link = false, $group = false, $options);
            echo '</div>';
        } else {
            ShowErrPhp('No Contacts were found.');
            for_error();
        }
    } else {
        ShowErrPhp('You must choose at least one student.');
        for_error();
    }
    unset($_SESSION['student_id']);
    $_REQUEST['modfunc'] = true;
}
if (!$_REQUEST['modfunc']) {
    DrawBC("Students >> " . ProgramTitle());
    if ($_REQUEST['search_modfunc'] == 'list') {
        echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_search_all_schools={$_REQUEST['_search_all_schools']} method=POST>";
    }
    $extra['link'] = array('FULL_NAME' => false);
    $extra['SELECT'] = ',s.STUDENT_ID AS CHECKBOX';
    $extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
    $extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller checked onclick="checkAll(this.form,this.form.controller.checked,\'st_arr\');"><A>');
    $extra['options']['search'] = false;
Пример #4
0
                $values = '\'' . UserSyear() . '\',';
                $go = 0;
                foreach ($columns as $column => $value) {
                    if (trim($value)) {
                        $value = paramlib_validation($column, $value);
                        $fields .= $column . ',';
                        $values .= '\'' . str_replace("'", " \\'", $value) . '\',';
                        $go = true;
                    }
                }
                $sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
                if ($go) {
                    DBQuery($sql);
                }
            } else {
                ShowErrPhp('You can\'t add any enrollment code in this type');
            }
        }
    }
}
DrawBC("Students > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
    $select_enroll = DBGet(DBQuery('SELECT TYPE FROM student_enrollment_codes WHERE ID=\'' . $_REQUEST[id] . '\''));
    if ($select_enroll[1][TYPE] != 'Roll' && $select_enroll[1][TYPE] != 'TrnD' && $select_enroll[1][TYPE] != 'TrnE') {
        $has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_enrollment WHERE  ENROLLMENT_CODE=\'' . $_REQUEST[id] . '\''));
        $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
        if ($has_assigned > 0) {
            UnableDeletePrompt('Cannot delete because enrollment codes are associated.');
        } else {
            if (DeletePromptMod('enrollment code', $_REQUEST['modname'])) {
                DBQuery('DELETE FROM student_enrollment_codes WHERE ID=\'' . $_REQUEST[id] . '\'');
Пример #5
0
             } elseif ($column == 'COURSE_ID' && $table == 'gradebook_assignments') {
                 $column = 'COURSE_PERIOD_ID';
                 $value = $course_period_id;
                 $sql .= 'COURSE_ID=NULL,';
             }
             $value = paramlib_validation($column, $value);
             if (stripos($_SERVER['SERVER_SOFTWARE'], 'linux')) {
                 $value = mysql_real_escape_string($value);
                 $value = str_replace('%u201D', "\"", $value);
             }
             $sql .= $column . '=\'' . $value . ' \',';
         }
         $sql = substr($sql, 0, -1) . ' WHERE ' . substr($table, 10, -1) . '_ID=\'' . $id . '\'';
         $go = true;
     } else {
         ShowErrPhp(_('Title Cannot be Blank'));
     }
 } else {
     $sql = 'INSERT INTO ' . $table . ' ';
     if ($table == 'gradebook_assignments') {
         if ($columns['ASSIGNMENT_TYPE_ID']) {
             $_REQUEST['assignment_type_id'] = $columns['ASSIGNMENT_TYPE_ID'];
             unset($columns['ASSIGNMENT_TYPE_ID']);
         }
         //$id = DBGet(DBQuery("SELECT ".db_seq_nextval('GRADEBOOK_ASSIGNMENTS_SEQ').' AS ID '.FROM_DUAL));
         $id = DBGet(DBQuery('SHOW TABLE STATUS LIKE \'gradebook_assignments\''));
         $id[1]['ID'] = $id[1]['AUTO_INCREMENT'];
         $id = $id[1]['ID'];
         $fields = 'ASSIGNMENT_TYPE_ID,STAFF_ID,MARKING_PERIOD_ID,';
         $values = "'" . $_REQUEST['assignment_type_id'] . "','" . User('STAFF_ID') . "','" . UserMP() . "',";
         $_REQUEST['assignment_id'] = $id;
Пример #6
0
                    DBQuery('INSERT INTO teacher_reassignment(course_period_id,teacher_id,assign_date,pre_teacher_id,modified_date,modified_by)VALUES(\'' . $id . '\',\'' . $staff_id . '\',\'' . $assign_date . '\',\'' . $pre_staff_id . '\',\'' . $today . '\',\'' . User('STAFF_ID') . '\')');
                    $_SESSION['undo'] = 'DELETE FROM teacher_reassignment WHERE course_period_id=\'' . $id . '\' AND teacher_id=\'' . $staff_id . '\' AND assign_date=\'' . $assign_date . '\'';
                }
                $undo_possible = true;
                $title_RET = DBGet(DBQuery('SELECT TITLE FROM course_periods WHERE COURSE_PERIOD_ID=\'' . $id . '\''));
                $_SESSION['undo_title'] = $title_RET[1]['TITLE'];
                DBQuery('CALL TEACHER_REASSIGNMENT()');
                //UpdateMissingAttendance($id);
            } else {
                ShowErrPhp(_('There is no associations in this Course Period. You can delete it from School Set Up>> Course Manager'));
            }
        } else {
            ShowErrPhp(_('Assigned date cannot be lesser than today\'s date'));
        }
    } else {
        ShowErrPhp(_('Please enter proper date'));
    }
}
if ($_REQUEST['action'] == 'undo') {
    DBQuery($_SESSION['undo']);
    DBQuery('UPDATE course_periods set title=\'' . $_SESSION['undo_title'] . '\',teacher_id=\'' . $_SESSION['undo_teacher'] . '\' WHERE course_period_id=\'' . $_REQUEST['course_period_id'] . '\'');
    //UpdateMissingAttendance($_REQUEST['course_period_id']);
    unset($_SESSION['undo']);
    unset($_SESSION['undo_teacher']);
    unset($_SESSION['undo_title']);
}
if ((!$_REQUEST['modfunc'] || clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'choose_course') && !$_REQUEST['course_modfunc']) {
    if ($_REQUEST['modfunc'] != 'choose_course') {
        DrawBC("" . _('Scheduling') . " > " . ProgramTitle());
    }
    $sql = 'SELECT SUBJECT_ID,TITLE FROM course_subjects WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY TITLE';