function ResetButton($value = 'Reset', $options = '')
{
    if (AllowEdit()) {
        return "<INPUT type=reset value='{$value}'" . ($options ? ' ' . $options : '') . '>';
    } else {
        return '';
    }
}
function ResetButton($value = 'Reset', $options = '')
{
    if (AllowEdit()) {
        return '<INPUT type="reset" value="' . $value . '"' . ($options ? ' ' . $options : '') . ' />';
    } else {
        return '';
    }
}
Beispiel #3
0
/**
 * Reports module Bottom Buttons.
 * Messaging new messages note.
 *
 * @uses Bottom.php|bottom_buttons hook
 *
 * @return true if bottom button, else false.
 */
function ReportsBottomButtons()
{
    if (!User('PROFILE') === 'admin' || !AllowEdit('Reports/SavedReports.php') || !isset($_SESSION['List_PHP_SELF'])) {
        return false;
    }
    ?>
	<a href="Modules.php?modname=Reports/SavedReports.php&amp;modfunc=new" class="BottomButton">
		<img src="assets/themes/<?php 
    echo Preferences('THEME');
    ?>
/btn/download.png" />
		<span><?php 
    echo _('Save Report');
    ?>
</span>
	</a>
	<?php 
    return true;
}
function TextAreaInputOrg($value, $name, $title = '', $options = '', $div = true, $divwidth = '500px')
{
    if (Preferences('HIDDEN') != 'Y') {
        $div = false;
    }
    if (AllowEdit() && !$_REQUEST['_openSIS_PDF']) {
        $value = str_replace("'", '&#39;', str_replace('"', '&rdquo;', $value));
        if (strpos($options, 'cols') === false) {
            $options .= ' cols=30';
        }
        if (strpos($options, 'rows') === false) {
            $options .= ' rows=4';
        }
        $rows = substr($options, strpos($options, 'rows') + 5, 2) * 1;
        $cols = substr($options, strpos($options, 'cols') + 5, 2) * 1;
        if ($value == '' || $div == false) {
            return "<TEXTAREA name={$name} {$options}>{$value}</TEXTAREA>" . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
        } else {
            return "<DIV id='div{$name}'><div style='width:500px;' onclick='javascript:addHTML(\"<TEXTAREA id=textarea{$name} name={$name} {$options}>" . ereg_replace("[\n\r]", '\\u000D\\u000A', str_replace("\r\n", '\\u000D\\u000A', str_replace("'", "&#39;", $value))) . "</TEXTAREA>" . ($title != '' ? "<BR><small>" . str_replace("'", '&#39;', (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '')) . "</small>" : '') . "\",\"div{$name}\",true); document.getElementById(\"textarea{$name}\").value=unescape(document.getElementById(\"textarea{$name}\").value);'><TABLE class=LO_field height=100%><TR><TD>" . (substr_count($value, "\r\n") > $rows ? '<DIV style="overflow:auto; height:' . 15 * $rows . 'px; width:' . $cols * 10 . '; padding-right: 16px;">' . nl2br($value) . '</DIV>' : '<DIV style="overflow:auto; width:' . $divwidth . '; padding-right: 16px;">' . nl2br($value) . '</DIV>') . '</TD></TR></TABLE>' . ($title != '' ? '<BR><small>' . str_replace("'", '&#39;', (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '')) . '</small>' : '') . '</div></DIV>';
        }
    } else {
        return ($value != '' ? nl2br($value) : '-') . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
    }
}
            DBQuery("DELETE FROM STAFF_EXCEPTIONS WHERE MODNAME='Students/Student.php&category_id={$_REQUEST['category_id']}'");
            $_REQUEST['modfunc'] = '';
            unset($_REQUEST['category_id']);
        }
    }
}
if (empty($_REQUEST['modfunc'])) {
    //modif Francois: fix SQL bug invalid sort order
    if (isset($error)) {
        echo $error;
    }
    // CATEGORIES
    $sql = "SELECT ID,TITLE,SORT_ORDER FROM STUDENT_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE";
    $QI = DBQuery($sql);
    $categories_RET = DBGet($QI);
    if (AllowEdit() && $_REQUEST['id'] != 'new' && $_REQUEST['category_id'] != 'new' && ($_REQUEST['id'] || $_REQUEST['category_id'] > 4)) {
        $delete_button = '<INPUT type="button" value="' . _('Delete') . '" onClick="javascript:window.location=\'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=delete&category_id=' . $_REQUEST['category_id'] . '&id=' . $_REQUEST['id'] . '\'" />';
    }
    // ADDING & EDITING FORM
    if ($_REQUEST['id'] && $_REQUEST['id'] != 'new') {
        $sql = "SELECT CATEGORY_ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,SORT_ORDER,REQUIRED,REQUIRED,(SELECT TITLE FROM STUDENT_FIELD_CATEGORIES WHERE ID=CATEGORY_ID) AS CATEGORY_TITLE FROM CUSTOM_FIELDS WHERE ID='{$_REQUEST['id']}'";
        $RET = DBGet(DBQuery($sql));
        $RET = $RET[1];
        $title = ParseMLField($RET['CATEGORY_TITLE']) . ' - ' . ParseMLField($RET['TITLE']);
    } elseif ($_REQUEST['category_id'] && $_REQUEST['category_id'] != 'new' && $_REQUEST['id'] != 'new') {
        $sql = "SELECT TITLE,SORT_ORDER,INCLUDE,COLUMNS\n\t\t\t\tFROM STUDENT_FIELD_CATEGORIES\n\t\t\t\tWHERE ID='{$_REQUEST['category_id']}'";
        $RET = DBGet(DBQuery($sql));
        $RET = $RET[1];
        $title = ParseMLField($RET['TITLE']);
    } elseif ($_REQUEST['id'] == 'new') {
        $title = _('New Student Field');
    if (DeletePrompt($table)) {
        foreach ($sql as $query) {
            DBQuery($query);
        }
        unset($_REQUEST['modfunc']);
    }
}
if ((!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == '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";
    $QI = DBQuery($sql);
    $subjects_RET = DBGet($QI);
    if ($_REQUEST['modfunc'] != 'choose_course') {
        if (AllowEdit()) {
            $delete_button = "<INPUT type=button class=btn_medium value=" . _('Delete') . " onClick='javascript:window.location=\"for_window.php?modname={$_REQUEST['modname']}&modfunc=delete&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&course_period_id={$_REQUEST['course_period_id']}\"'> ";
        }
        // ADDING & EDITING FORM
        if ($_REQUEST['course_period_id']) {
            if ($_REQUEST['course_period_id'] != 'new') {
                $sql = "SELECT PARENT_ID,TITLE,SHORT_NAME,PERIOD_ID,DAYS,\n\t\t\t\t\t\t\t\tMP,MARKING_PERIOD_ID,TEACHER_ID,CALENDAR_ID,\n\t\t\t\t\t\t\t\tROOM,TOTAL_SEATS,DOES_ATTENDANCE,\n\t\t\t\t\t\t\t\tGRADE_SCALE_ID,DOES_HONOR_ROLL,DOES_CLASS_RANK,\n\t\t\t\t\t\t\t\tGENDER_RESTRICTION,HOUSE_RESTRICTION,CREDITS,\n\t\t\t\t\t\t\t\tHALF_DAY,DOES_BREAKOFF\n\t\t\t\t\t\tFROM course_periods\n\t\t\t\t\t\tWHERE COURSE_PERIOD_ID='{$_REQUEST['course_period_id']}'";
                $QI = DBQuery($sql);
                $RET = DBGet($QI);
                $RET = $RET[1];
                $title = $RET['TITLE'];
                $new = false;
            } else {
                $sql = "SELECT TITLE\n\t\t\t\t\t\tFROM courses\n\t\t\t\t\t\tWHERE COURSE_ID='{$_REQUEST['course_id']}'";
                $QI = DBQuery($sql);
                $RET = DBGet($QI);
Beispiel #7
0
         $teacher_id = $course_period_RET[1]['TEACHER_ID'];
         $config_RET = DBGet(DBQuery("SELECT TITLE,VALUE FROM PROGRAM_USER_CONFIG WHERE USER_ID='{$teacher_id}' AND PROGRAM='Gradebook'"), array(), array('TITLE'));
     }
     $_REQUEST['tab_id'] = key($grade_scales_RET);
 }
 $tabs = array();
 $grade_scale_select = array();
 foreach ($grade_scales_RET as $id => $grade_scale) {
     $tabs[] = array('title' => $grade_scale[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id={$id}");
     $grade_scale_select += array($id => $grade_scale[1]['TITLE']);
 }
 if ($_REQUEST['tab_id'] != 'new') {
     $sql = 'SELECT * FROM REPORT_CARD_GRADES WHERE GRADE_SCALE_ID=\'' . $_REQUEST['tab_id'] . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY BREAK_OFF IS NOT NULL DESC,BREAK_OFF DESC, SORT_ORDER';
     $functions = array('TITLE' => 'makeGradesInput', 'BREAK_OFF' => 'makeGradesInput', 'SORT_ORDER' => 'makeGradesInput', 'GPA_VALUE' => 'makeGradesInput', 'COMMENT' => 'makeGradesInput');
     $LO_columns = array('TITLE' => 'Title', 'BREAK_OFF' => 'Breakoff', 'GPA_VALUE' => 'GPA Value', 'SORT_ORDER' => 'Order', 'COMMENT' => 'Comment');
     if (User('PROFILE') == 'admin' && AllowEdit()) {
         $functions += array('GRADE_SCALE_ID' => 'makeGradesInput');
         $LO_columns += array('GRADE_SCALE_ID' => 'Grade Scale');
     }
     $link['add']['html'] = array('TITLE' => makeGradesInput('', 'TITLE'), 'BREAK_OFF' => makeGradesInput('', 'BREAK_OFF'), 'GPA_VALUE' => makeGradesInput('', 'GPA_VALUE'), 'SORT_ORDER' => makeGradesInput('', 'SORT_ORDER'), 'COMMENT' => makeGradesInput('', 'COMMENT'));
     $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id={$_REQUEST['tab_id']}";
     $link['remove']['variables'] = array('id' => 'ID');
     $link['add']['html']['remove'] = button('add');
     if (User('PROFILE') == 'admin') {
         $tabs[] = array('title' => button('add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
     }
 } else {
     //BJJ modifications to $functions array and $LO_columns array to handle scale value GP_SCALE
     $sql = 'SELECT * FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER,ID';
     $functions = array('TITLE' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'SORT_ORDER' => 'makeTextInput');
     $LO_columns = array('TITLE' => 'Gradescale', 'GP_SCALE' => 'Scale Value', 'COMMENT' => 'Comment', 'SORT_ORDER' => 'Sort Order');
function _makeRemove($value, $column)
{
    global $THIS_RET;
    $return = '';
    if (AllowEdit()) {
        if ($THIS_RET['USAGE_ID']) {
            $return = button('remove', _('Don\'t use'), '"Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=delete_usage&id=' . $THIS_RET['USAGE_ID'] . '"');
            $return .= button('remove', _('Delete'), '"Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=delete&id=' . $THIS_RET['ID'] . '"');
        } else {
            $return = button('add', _('Use at this school'), '"Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=add_usage&id=' . $THIS_RET['ID'] . '"');
        }
    }
    return $return;
}
Beispiel #9
0
function _makeMultipleInput($column, $name, $request = 'staff')
{
    global $value, $field, $_openSIS;
    if ((AllowEdit() || $_openSIS['allow_edit']) && !$_REQUEST['_openSIS_PDF']) {
        $field['SELECT_OPTIONS'] = str_replace("\n", "\r", str_replace("\r\n", "\r", $field['SELECT_OPTIONS']));
        $select_options = explode("\r", $field['SELECT_OPTIONS']);
        if (count($select_options)) {
            foreach ($select_options as $option) {
                $options[$option] = $option;
            }
        }
        if ($value[$column] != '') {
            echo "<DIV id='div" . $request . "[" . $column . "]'><div onclick='javascript:addHTML(\"";
        }
        echo '<TABLE border=0 cellpadding=3>';
        if (count($options) > 12) {
            echo '<TR><TD colspan=2>';
            echo '<small><FONT color=' . Preferences('TITLES') . '>' . $name . '</FONT></small>';
            if ($value[$column] != '') {
                echo '<TABLE width=100% height=7 style=\\"border:1;border-style: solid solid none solid;\\"><TR><TD></TD></TR></TABLE>';
            } else {
                echo '<TABLE width=100% height=7 style="border:1;border-style: solid solid none solid;"><TR><TD></TD></TR></TABLE>';
            }
            echo '</TD></TR>';
        }
        echo '<TR>';
        $i = 0;
        foreach ($options as $option) {
            if ($i % 2 == 0) {
                echo '</TR><TR>';
            }
            if ($value[$column] != '') {
                echo '<TD><INPUT TYPE=hidden name=' . $request . '[' . $column . '][] value=\\"\\"><INPUT type=checkbox name=' . $request . '[' . $column . '][] value=\\"' . str_replace('"', '&quot;', $option) . '\\"' . (strpos($value[$column], '||' . $option . '||') !== false ? ' CHECKED' : '') . '><small>' . $option . '</small></TD>';
            } else {
                echo '<TD><INPUT type=checkbox name=' . $request . '[' . $column . '][] value="' . str_replace('"', '&quot;', $option) . '"' . (strpos($value[$column], '||' . $option . '||') !== false ? ' CHECKED' : '') . '><small>' . $option . '</small></TD>';
            }
            $i++;
        }
        echo '</TR><TR><TD colspan=2>';
        if ($value[$column] != '') {
            echo '<TABLE width=100% height=7 style=\\"border:1;border-style: none solid solid solid;\\"><TR><TD></TD></TR></TABLE>';
        } else {
            echo '<TABLE width=100% height=7 style="border:1;border-style: none solid solid solid;"><TR><TD></TD></TR></TABLE>';
        }
        echo '</TD></TR></TABLE>';
        if ($value[$column] != '') {
            echo "\",\"div" . $request . "[" . $column . "]" . "\",true);' >" . ($value[$column] != '' ? str_replace('"', '&rdquo;', str_replace('||', ', ', substr($value[$column], 2, -2))) : '-') . "</div></DIV>";
        }
    } else {
        echo $value[$column] != '' ? str_replace('"', '&rdquo;', str_replace('||', ', ', substr($value[$column], 2, -2))) : '-<BR>';
    }
    echo '<small><FONT color=' . Preferences('TITLES') . '>' . $name . '</FONT></small>';
}
function _makeRadioSelected($value, $title)
{
    global $THIS_RET, $current_RET;
    $colors = array('P' => '#00FF00', 'A' => '#FF0000', 'H' => '#FFCC00', 'T' => '#0000FF');
    $colors1 = array('P' => '#DDFFDD', 'A' => '#FFDDDD', 'H' => '#FFEEDD', 'T' => '#DDDDFF');
    if ($current_RET[$THIS_RET['STUDENT_ID']][1]['ATTENDANCE_TEACHER_CODE'] != '') {
        if ($current_RET[$THIS_RET['STUDENT_ID']][1]['ATTENDANCE_TEACHER_CODE'] == mb_substr($title, 5)) {
            return '<TABLE style="margin:0 auto; ' . ($current_RET[$THIS_RET['STUDENT_ID']][1]['COURSE_PERIOD_ID'] == UserCoursePeriod() ? $colors[$value] ? ' background-color:' . $colors[$value] . ';' : '' : ' background-color:#000000;') . '"><TR><TD><INPUT type="radio" name="attendance[' . $THIS_RET['STUDENT_ID'] . ']" value="' . $title . '" checked /></TD></TR></TABLE>';
        } else {
            return '<TABLE style="margin:0 auto;"><TR><TD><INPUT type="radio" name="attendance[' . $THIS_RET['STUDENT_ID'] . ']" value="' . $title . '"' . (AllowEdit() ? '' : ' disabled') . '></TD></TR></TABLE>';
        }
    } else {
        return '<TABLE style="margin:0 auto; ' . ($colors1[$value] ? ' background-color:' . $colors1[$value] . ';' : '') . '"><TR><TD><INPUT type="radio" name="attendance[' . $THIS_RET['STUDENT_ID'] . ']" value="' . $title . '" checked /></TD></TR></TABLE>';
    }
}
Beispiel #11
0
        $RET = DBGet(DBQuery('SELECT FIRST_NAME,LAST_NAME,MIDDLE_NAME,NAME_SUFFIX FROM students WHERE STUDENT_ID=\'' . UserStudentID() . '\''));
    }
    $count_student_RET = DBGet(DBQuery('SELECT COUNT(*) AS NUM FROM students'));
    if ($count_student_RET[1]['NUM'] > 1) {
        DrawHeaderHome('Selected Student: ' . $RET[1]['FIRST_NAME'] . '&nbsp;' . ($RET[1]['MIDDLE_NAME'] ? $RET[1]['MIDDLE_NAME'] . ' ' : '') . $RET[1]['LAST_NAME'] . '&nbsp;' . ' (<A HREF=Side.php?student_id=new&modcat=' . clean_param($_REQUEST['modcat'], PARAM_NOTAGS) . '><font color=red>Search Again</font></A>) | <A HREF=Modules.php?modname=' . clean_param($_REQUEST['modname'], PARAM_NOTAGS) . '&search_modfunc=list&next_modname=Students/Student.php&ajax=true&bottom_back=true&return_session=true target=body>Back to Student List</A>');
    } else {
        if ($count_student_RET[1]['NUM'] == 1) {
            DrawHeaderHome('Selected Student: ' . $RET[1]['FIRST_NAME'] . '&nbsp;' . ($RET[1]['MIDDLE_NAME'] ? $RET[1]['MIDDLE_NAME'] . ' ' : '') . $RET[1]['LAST_NAME'] . '&nbsp;' . ' (<A HREF=Side.php?student_id=new&modcat=' . clean_param($_REQUEST['modcat'], PARAM_NOTAGS) . '><font color=red>Search Again</font></A>) ');
        }
    }
}
if ($_REQUEST['modfunc'] == 'add' && AllowEdit()) {
    DBQuery('INSERT INTO student_eligibility_activities (STUDENT_ID,ACTIVITY_ID,SYEAR) values(\'' . UserStudentID() . '\',\'' . $_REQUEST['new_activity'] . '\',\'' . UserSyear() . '\')');
    unset($_REQUEST['modfunc']);
}
if ($_REQUEST['modfunc'] == 'remove' && AllowEdit()) {
    if (DeletePromptMod('activity')) {
        DBQuery('DELETE FROM student_eligibility_activities WHERE STUDENT_ID=\'' . UserStudentID() . '\' AND ACTIVITY_ID=\'' . $_REQUEST['activity_id'] . '\' AND SYEAR=\'' . UserSyear() . '\'');
        unset($_REQUEST['modfunc']);
    }
}
if (UserStudentID() && !$_REQUEST['modfunc']) {
    $start_end_RET = DBGet(DBQuery('SELECT TITLE,VALUE FROM program_config WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND PROGRAM=\'eligibility\' AND TITLE IN (\'' . 'START_DAY' . '\',\'' . 'END_DAY' . '\')'));
    if (count($start_end_RET)) {
        foreach ($start_end_RET as $value) {
            ${$value}['TITLE'] = $value['VALUE'];
        }
    }
    switch (date('D')) {
        case 'Mon':
            $today = 1;
Beispiel #12
0
function ListOutputGrade($result, $column_names, $singular = '', $plural = '', $link = false, $group = false, $options = false, $for_window = '')
{
    if (!isset($options['save'])) {
        $options['save'] = true;
    }
    if (!isset($options['print'])) {
        $options['print'] = true;
    }
    if (!isset($options['search'])) {
        $options['search'] = true;
    }
    if (!isset($options['center'])) {
        $options['center'] = true;
    }
    if (!isset($options['count'])) {
        $options['count'] = true;
    }
    if (!isset($options['sort'])) {
        $options['sort'] = true;
    }
    if (!$link) {
        $link = array();
    }
    if (isset($_REQUEST['page'])) {
        if ($_REQUEST['list_type'] == $singular) {
            $Request_page = $_REQUEST['page'];
        }
    }
    if (!isset($options['add'])) {
        if (!AllowEdit() || $_REQUEST['_openSIS_PDF']) {
            if ($link) {
                unset($link['add']);
                unset($link['remove']);
            }
        }
    }
    // PREPARE LINKS ---
    $result_count = $display_count = count($result);
    $num_displayed = 100000;
    $extra = "page={$_REQUEST['page']}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']);
    $tmp_REQUEST = $_REQUEST;
    unset($tmp_REQUEST['page']);
    unset($tmp_REQUEST['LO_sort']);
    unset($tmp_REQUEST['LO_direction']);
    unset($tmp_REQUEST['LO_search']);
    unset($tmp_REQUEST['remove_prompt']);
    unset($tmp_REQUEST['remove_name']);
    unset($tmp_REQUEST['LO_save']);
    unset($tmp_REQUEST['PHPSESSID']);
    //$PHP_tmp_SELF = PreparePHP_SELF($tmp_REQUEST);
    $PHP_tmp_SELF = str_replace('>', '', PreparePHP_SELF($tmp_REQUEST));
    // END PREPARE LINKS ---
    // UN-GROUPING
    $group_count = count($group);
    if (!is_array($group)) {
        $group_count = false;
    }
    //$side_color = Preferences('COLOR');
    $side_color = 'class=odd';
    if ($group_count && $result_count) {
        $color = 'class=even';
        $group_result = $result;
        unset($result);
        $result[0] = '';
        foreach ($group_result as $item1) {
            if ($group_count == 1) {
                if ($color == 'class=even') {
                    $color = $side_color;
                } else {
                    $color = 'class=even';
                }
            }
            foreach ($item1 as $item2) {
                if ($group_count == 1) {
                    $i++;
                    if (count($group[0]) && $i != 1) {
                        foreach ($group[0] as $column) {
                            $item2[$column] = str_replace('<!-- <!--', '<!--', '<!-- ' . str_replace('-->', '--><!--', $item2[$column])) . ' -->';
                        }
                    }
                    $item2['row_color'] = $color;
                    $result[] = $item2;
                } else {
                    if ($group_count == 2) {
                        if ($color == 'class=even') {
                            $color = $side_color;
                        } else {
                            $color = 'class=even';
                        }
                    }
                    foreach ($item2 as $item3) {
                        if ($group_count == 2) {
                            $i++;
                            if (count($group[0]) && $i != 1) {
                                foreach ($group[0] as $column) {
                                    $item3[$column] = '<!-- ' . $item3[$column] . ' -->';
                                }
                            }
                            if (count($group[1]) && $i != 1) {
                                foreach ($group[1] as $column) {
                                    $item3[$column] = '<!-- ' . $item3[$column] . ' -->';
                                }
                            }
                            $item3['row_color'] = $color;
                            $result[] = $item3;
                        } else {
                            if ($group_count == 3) {
                                if ($color == 'class=even') {
                                    $color = $side_color;
                                } else {
                                    $color = 'class=even';
                                }
                            }
                            foreach ($item3 as $item4) {
                                if ($group_count == 3) {
                                    $i++;
                                    if (count($group[2]) && $i != 1) {
                                        foreach ($group[2] as $column) {
                                            unset($item4[$column]);
                                        }
                                    }
                                    $item4['row_color'] = $color;
                                    $result[] = $item4;
                                }
                            }
                        }
                    }
                }
            }
            $i = 0;
        }
        unset($result[0]);
        $result_count = count($result);
        unset($_REQUEST['LO_sort']);
    }
    // END UN-GROUPING
    $_LIST['output'] = true;
    // PRINT HEADINGS, PREPARE PDF, AND SORT THE LIST ---
    if ($_LIST['output'] != false) {
        if ($result_count != 0) {
            $count = 0;
            $remove = count($link['remove']['variables']);
            $cols = count($column_names);
            // HANDLE SEARCHES ---
            if ($result_count && $_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search') {
                $_REQUEST['LO_search'] = $search_term = str_replace('\\\\"', '"', $_REQUEST['LO_search']);
                $_REQUEST['LO_search'] = $search_term = ereg_replace('[^a-zA-Z0-9 _"]*', '', strtolower($search_term));
                if (substr($search_term, 0, 0) != '"' && substr($search_term, -1) != '"') {
                    $search_term = ereg_replace('"', '', $search_term);
                    while ($space_pos = strpos($search_term, ' ')) {
                        $terms[strtolower(substr($search_term, 0, $space_pos))] = 1;
                        $search_term = substr($search_term, $space_pos + 1);
                    }
                    $terms[trim($search_term)] = 1;
                } else {
                    $search_term = ereg_replace('"', '', $search_term);
                    $terms[trim($search_term)] = 1;
                }
                unset($terms['of']);
                unset($terms['the']);
                unset($terms['a']);
                unset($terms['an']);
                unset($terms['in']);
                foreach ($result as $key => $value) {
                    $values[$key] = 0;
                    foreach ($value as $name => $val) {
                        $val = ereg_replace('[^a-zA-Z0-9 _]+', '', strtolower($val));
                        if (strtolower($_REQUEST['LO_search']) == $val) {
                            $values[$key] += 25;
                        }
                        foreach ($terms as $term => $one) {
                            if (ereg($term, $val)) {
                                $values[$key] += 3;
                            }
                        }
                    }
                    if ($values[$key] == 0) {
                        unset($values[$key]);
                        unset($result[$key]);
                        $result_count--;
                        $display_count--;
                    }
                }
                if ($result_count) {
                    array_multisort($values, SORT_DESC, $result);
                    $result = ReindexResults($result);
                    $values = ReindexResults($values);
                    $last_value = 1;
                    $scale = 100 / $values[$last_value];
                    for ($i = $last_value; $i <= $result_count; $i++) {
                        $result[$i]['RELEVANCE'] = '<!--' . (int) ($values[$i] * $scale) . '--><IMG SRC="assets/pixel_grey.gif" width=' . (int) ($values[$i] * $scale) . ' height=10>';
                    }
                }
                $column_names['RELEVANCE'] = "" . _('Relevance') . "";
                if (is_array($group) && count($group)) {
                    $options['count'] == false;
                    $display_zero = true;
                }
            }
            // END SEARCHES ---
            if ($_REQUEST['LO_sort']) {
                $r = array();
                $a = array();
                $t = array();
                $c = 0;
                for ($i = 1; $i <= count($result); $i++) {
                    if (array_key_exists("FULL_NAME", $result[$i])) {
                        array_push($a, $i);
                    }
                }
                $l = 0;
                $k = 0;
                foreach ($result as $column => $value) {
                    for ($n = 0; $n < count($a); $n++) {
                        if ($column == $a[$n]) {
                            $k = $k + 1;
                        }
                    }
                    $t[$k][$l] = $value;
                    $l++;
                }
                for ($h = 1; $h <= count($a); $h++) {
                    foreach ($t[$h] as $sort) {
                        if (substr($sort[$_REQUEST['LO_sort']], 0, 4) != '<!--') {
                            $sort_array[] = $sort[$_REQUEST['LO_sort']];
                        } else {
                            $sort_array[] = substr($sort[$_REQUEST['LO_sort']], 4, strpos($sort[$_REQUEST['LO_sort']], '-->') - 5);
                        }
                    }
                    if ($_REQUEST['LO_direction'] == -1) {
                        $dir = SORT_DESC;
                    } else {
                        $dir = SORT_ASC;
                    }
                    if (count($t) > 1) {
                        if (is_int($sort_array[1]) || is_double($sort_array[1])) {
                            array_multisort($sort_array, $dir, SORT_NUMERIC, $t[$h]);
                        } else {
                            array_multisort($sort_array, $dir, $t[$h]);
                        }
                        // print_r($t[$h]);
                        $inc = 0;
                        $pos = 0;
                        $flag = true;
                        $inc = 0;
                        $select = $_REQUEST['LO_sort'];
                        for ($c = 0; $c < count($t[$h]); $c++) {
                            if (array_key_exists($_REQUEST['LO_sort'], $t[$h][$c])) {
                                $temp = $t[$h][$c];
                                if ($temp[$select]) {
                                    $inc++;
                                    if ($flag) {
                                        $pos = $c;
                                        $flag = false;
                                    }
                                }
                            }
                        }
                        $abc = array_slice($t[$h], $pos, $inc);
                        if ($pos == 0) {
                            $cde = array_slice($t[$h], $inc, count($t[$h]) - 1);
                        } else {
                            $cde = array_slice($t[$h], 0, $pos);
                        }
                        if ($inc != 0) {
                            $t[$h] = array_merge($abc, $cde);
                        }
                        echo "<br/>";
                        array_push($result, $t[$h]);
                    }
                    for ($i = $result_count - 1; $i >= 0; $i--) {
                        $result[$i + 1] = $result[$i];
                    }
                    unset($result[0]);
                    $sort_array = "";
                }
                // $name_sort=array();
                $bgcolor_sort = array();
                for ($h = 1; $h <= count($t); $h++) {
                    for ($n = 0; $n < count($t[$h]); $n++) {
                        if ($_REQUEST['LO_sort'] == "FULL_NAME") {
                            if (array_key_exists("FULL_NAME", $t[$h][$n])) {
                                $name_sort[] = array_shift($t[$h][$n]);
                            }
                            if (array_key_exists("bgcolor", $t[$h][$n])) {
                                $bgcolor_sort[] = array_shift($t[$h][$n]);
                            }
                        } else {
                            if (array_key_exists("FULL_NAME", $t[$h][$n])) {
                                $FULL_NAME = array_shift($t[$h][$n]);
                            }
                            if (array_key_exists("bgcolor", $t[$h][$n])) {
                                $bgcolor = array_shift($t[$h][$n]);
                            }
                            $t[$h][0][FULL_NAME] = $FULL_NAME;
                            $t[$h][0][bgcolor] = $bgcolor;
                        }
                    }
                }
                for ($h = 1; $h <= count($t); $h++) {
                    for ($n = 0; $n < count($t[$h]); $n++) {
                        if (array_key_exists("0", $t[$h][$n])) {
                            $mkperiod = $t[$h][$n]['MARKING_PERIOD_ID'];
                            $t[$h][$n][$mkperiod] = $t[$h][$n][0];
                        }
                    }
                }
                //print_r($name_sort);
                if ($_REQUEST['LO_sort'] == "FULL_NAME") {
                    array_multisort($name_sort, $dir);
                    for ($h = 1; $h <= count($t); $h++) {
                        $t[$h][0][FULL_NAME] = $name_sort[$h - 1];
                    }
                }
                $result = "";
                for ($n = 1; $n <= count($a); $n++) {
                    $result = array_merge((array) $result, $t[$n]);
                }
            }
        }
        // HANDLE SAVING THE LIST ---
        if ($_REQUEST['LO_save'] == '1') {
            if (!$options['save_delimiter'] && Preferences('DELIMITER') == 'CSV') {
                $options['save_delimiter'] = 'comma';
            }
            switch ($options['save_delimiter']) {
                case 'comma':
                    $extension = 'csv';
                    break;
                case 'xml':
                    $extension = 'xml';
                    break;
                default:
                    $extension = 'xls';
                    break;
            }
            ob_end_clean();
            if ($options['save_delimiter'] != 'xml') {
                foreach ($column_names as $key => $value) {
                    $output .= str_replace('&nbsp;', ' ', eregi_replace('<BR>', ' ', ereg_replace('<!--.*-->', '', $value))) . ($options['save_delimiter'] == 'comma' ? ',' : "\t");
                }
                $output .= "\n";
            }
            foreach ($result as $item) {
                foreach ($column_names as $key => $value) {
                    if ($options['save_delimiter'] == 'comma' && !$options['save_quotes']) {
                        $item[$key] = str_replace(',', ';', $item[$key]);
                    }
                    $item[$key] = eregi_replace('<SELECT.*SELECTED\\>([^<]+)<.*</SELECT\\>', '\\1', $item[$key]);
                    $item[$key] = eregi_replace('<SELECT.*</SELECT\\>', '', $item[$key]);
                    $output .= ($options['save_quotes'] ? '"' : '') . ($options['save_delimiter'] == 'xml' ? '<' . str_replace(' ', '', $value) . '>' : '') . ereg_replace('<[^>]+>', '', ereg_replace("<div onclick='[^']+'>", '', ereg_replace(' +', ' ', ereg_replace('&[^;]+;', '', str_replace('<BR>&middot;', ' : ', str_replace('&nbsp;', ' ', $item[$key])))))) . ($options['save_delimiter'] == 'xml' ? '</' . str_replace(' ', '', $value) . '>' . "\n" : '') . ($options['save_quotes'] ? '"' : '') . ($options['save_delimiter'] == 'comma' ? ',' : "\t");
                }
                $output .= "\n";
            }
            header("Cache-Control: public");
            header("Pragma: ");
            header("Content-Type: application/{$extension}");
            header("Content-Disposition: inline; filename=\"" . ProgramTitle() . ".{$extension}\"\n");
            if ($options['save_eval']) {
                eval($options['save_eval']);
            }
            echo $output;
            exit;
        }
        // END SAVING THE LIST ---
        if ($options['center']) {
            #echo '<CENTER>';
            if ($result_count > $num_displayed || ($options['count'] || $display_zero) && (($result_count == 0 || $display_count == 0) && $plural || ($result_count == 0 || $display_count == 0))) {
                #echo "<TABLE border=0 cellspacing=3 cellpadding=6>" ;
                if (isset($_REQUEST['_openSIS_PDF'])) {
                    #echo " width=98%";
                    echo " <TR><TD align=center>";
                }
            }
        }
        if ($options['count'] || $display_zero) {
            if (($result_count == 0 || $display_count == 0) && $plural) {
                echo "<div style=text-align:left><table cellpadding=5 cellspacing=5 class=alert_box ><tr><td class=alert></td><td class=alert_msg ><b>" . _('No') . " {$plural} " . _('were found.') . "</b></td></tr><tr><td colspan=2 class=clear></td></tr></table></div>";
            } elseif ($result_count == 0 || $display_count == 0) {
                echo '<div style=text-align:left><table cellpadding=5 cellspacing=5 class=alert_box ><tr><td class=alert></td><td class=alert_msg ><b>' . _('None were found.') . '</b></td></tr><tr><td colspan=2 class=clear></td></tr></table></div>';
            }
        }
        if ($result_count != 0 || $_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search') {
            if (!isset($_REQUEST['_openSIS_PDF'])) {
                if (!$Request_page) {
                    $Request_page = 1;
                }
                if (!$_REQUEST['LO_direction']) {
                    $_REQUEST['LO_direction'] = 1;
                }
                $start = ($Request_page - 1) * $num_displayed + 1;
                $stop = $start + ($num_displayed - 1);
                if ($stop > $result_count) {
                    $stop = $result_count;
                }
                if ($result_count > $num_displayed) {
                    echo $where_message = "<strong><br>\n\t\t\t\t\t\t\t\t\t    {$start} " . _('through') . " {$stop}</strong>";
                    echo "<div style=text-align:right;margin-top:-14px;padding-right:15px><strong>" . _('Go to Page') . " ";
                    if (ceil($result_count / $num_displayed) <= 10) {
                        for ($i = 1; $i <= ceil($result_count / $num_displayed); $i++) {
                            if ($i != $Request_page) {
                                if ($for_window == 'for_window') {
                                    $pages .= "<A HREF=" . str_replace('Modules.php', 'for_window.php', $PHP_tmp_SELF) . "&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}&list_type={$singular}>{$i}</A>, ";
                                } else {
                                    $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}&list_type={$singular}>{$i}</A>, ";
                                }
                            } else {
                                $pages .= "{$i}, ";
                            }
                        }
                        $pages = substr($pages, 0, -2);
                    } else {
                        for ($i = 1; $i <= 7; $i++) {
                            if ($i != $Request_page) {
                                $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}>{$i}</A>, ";
                            } else {
                                $pages .= "{$i}, ";
                            }
                        }
                        $pages = substr($pages, 0, -2) . " ... ";
                        for ($i = ceil($result_count / $num_displayed) - 2; $i <= ceil($result_count / $num_displayed); $i++) {
                            if ($i != $Request_page) {
                                $pages .= "<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page={$i}>{$i}</A>, ";
                            } else {
                                $pages .= "{$i}, ";
                            }
                        }
                        $pages = substr($pages, 0, -2) . " &nbsp;<A HREF={$PHP_tmp_SELF}&LO_sort={$_REQUEST['LO_sort']}&LO_direction={$_REQUEST['LO_direction']}&LO_search=" . urlencode($_REQUEST['LO_search']) . "&page=" . ($Request_page + 1) . ">" . _('Next Page') . "</A><BR>";
                    }
                    echo $pages;
                    //echo '</td></tr></table></div>';
                    echo '</strong></div>';
                    //echo '<BR>';
                }
            } else {
                $start = 1;
                $stop = $result_count;
                if ($cols > 8 || $_REQUEST['expanded_view']) {
                    $_SESSION['orientation'] = 'landscape';
                    $repeat_headers = 16;
                } else {
                    $repeat_headers = 27;
                }
                if ($options['print']) {
                    $html = explode('<!-- new page -->', strtolower(ob_get_contents()));
                    $html = $html[count($html) - 1];
                    echo '</TD></TR></TABLE>';
                    $br = substr_count($html, '<br>') + substr_count($html, '</p>') + substr_count($html, '</tr>') + substr_count($html, '</h1>') + substr_count($html, '</h2>') + substr_count($html, '</h3>') + substr_count($html, '</h4>') + substr_count($html, '</h5>');
                    if ($br % 2 != 0) {
                        $br++;
                        echo '<BR>';
                    }
                } else {
                    echo '</TD></TR></TABLE>';
                }
            }
            // END MISC ---
            // WIDTH = 100%
            echo '<TABLE width=98% border=0 cellspacing=0 cellpadding=0><TR>';
            // SEARCH BOX & MORE HEADERS
            if ($where_message || $singular && $plural || !isset($_REQUEST['_openSIS_PDF']) && $options['search']) {
                echo '<TD align=center>';
                echo '<TABLE cellpadding=1 width=100% border=0 class=\\"grid\\">';
                echo "<TR><TD align=left valign=middle>";
                if ($singular && $plural && $options['count']) {
                    if ($display_count > 1) {
                        echo "<table cellpadding=5 cellspacing=5 class=alert_box align=left ><tr><td class=notice></td><td class=notice_msg ><b>{$display_count} {$plural} " . _('were found.') . "</b></td></tr></table>";
                    } elseif ($display_count == 1) {
                        echo "<table cellpadding=5 cellspacing=5 class=alert_box align=left ><tr><td class=notice></td><td class=notice_msg ><b>" . _('1') . " {$singular} " . _('was found.') . "</b></td></tr></table>";
                    }
                    #if($where_message)
                    #	echo '<br>'.$where_message;
                }
                if ($options['save'] && !isset($_REQUEST['_openSIS_PDF']) && $result_count > 0) {
                    //echo str_replace("Modules.php", "for_export.php", $PHP_tmp_SELF);
                    echo "<table cellpadding=0 cellspacing=0 class=download align=left ><tr><td><A HREF=" . str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF) . "&{$extra}&LO_save=1&_openSIS_PDF=true ><IMG SRC=assets/download.png border=0 alt=\"Download\" title=\"" . _('Download') . "\"></a></td></tr></table>";
                }
                //echo "<br><br><table class=download ><tr><td><A HREF=".str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF)."&$extra&_openSIS_PDF=true ><IMG SRC=assets/download.png border=0></a></td><td><A HREF=".str_replace('Modules.php', 'for_export.php', $PHP_tmp_SELF)."&$extra&_openSIS_PDF=true >Download</A></td></tr></table>";
                echo '</TD>';
                $colspan = 1;
                if (!isset($_REQUEST['_openSIS_PDF']) && $options['search']) {
                    $_REQUEST['portal_search'] = 'true';
                    $tmp_REQUEST = $_REQUEST;
                    unset($tmp_REQUEST['LO_search']);
                    unset($tmp_REQUEST['page']);
                    echo '<TD height="50" align=right valign=middle style="white-space:nowrap;">&nbsp;&nbsp;';
                    echo "<INPUT type=text class='cell_medium'  id=LO_search name=LO_search value='" . ($_REQUEST['LO_search'] && $_REQUEST['LO_search'] != 'Search' ? $_REQUEST['LO_search'] : 'Search\' style=\'color:BBBBBB\''), "' onfocus='if(this.value==\"Search\") this.value=\"\"; this.style.color=\"000000\";' onblur='if(this.value==\"\") {this.value=\"Search\"; this.style.color=\"BBBBBB\";}' onkeypress='if(event.keyCode==13){document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&LO_search=\"+this.value; return false;} '>&nbsp;&nbsp;<INPUT type=button class='btn_go' value=" . _('Go') . " onclick='document.location.href=\"" . PreparePHP_SELF($tmp_REQUEST) . "&LO_search=\"+document.getElementById(\"LO_search\").value;'></TD>";
                    $colspan++;
                }
                echo "</TR>";
                echo '<TR style="height:0;"><TD width=100% align=center colspan=' . $colspan . '><DIV id=LOx' . (count($column_names) + ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0) + ($remove && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0)) . ' style="width:0; position: relative; height:0;"></DIV></TD></TR></TABLE>';
            } else {
                echo '<TD width=100% align=right><DIV id=LOx' . (count($column_names) + ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0) + ($remove && !isset($_REQUEST['_openSIS_PDF']) ? 1 : 0)) . ' style="width:0; position: relative; height:0;"></DIV>';
            }
            // END SEARCH BOX ----
            echo '</TD></TR><TR><TD>';
            // SHADOW
            if (!isset($_REQUEST['_openSIS_PDF'])) {
                //echo "<link rel='stylesheet' type='text/css' href='styles/paging.css' />\n";
                echo '<div id="pagerNavPosition"></div>';
                echo '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>';
            }
            echo "<TABLE id='results' cellpadding=6 width=96% cellspacing=1 class=\"grid\" align=center>";
            if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) {
                echo '<THEAD>';
            }
            if (!isset($_REQUEST['_openSIS_PDF'])) {
                echo '<TR>';
            }
            $i = 1;
            if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $result_count != 0) {
                //THIS LINE IS FOR COLUMN HEADING
                echo "<TD class=subtabs><DIV id=LOx{$i} style='position: relative;'></DIV></TD>";
                $i++;
            }
            if ($result_count != 0 && $cols && !isset($_REQUEST['_openSIS_PDF'])) {
                foreach ($column_names as $key => $value) {
                    if ($_REQUEST['LO_sort'] == $key) {
                        $direction = -1 * $_REQUEST['LO_direction'];
                    } else {
                        $direction = 1;
                    }
                    //THIS LINE IS FOR COLUMN HEADING
                    echo "<TD class=subtabs><DIV id=LOx{$i} style='position: relative;'></DIV>";
                    echo "<A ";
                    if ($options['sort']) {
                        if ($for_window == 'for_window') {
                            echo "HREF=#";
                        } else {
                            echo "HREF={$PHP_tmp_SELF}&page={$_REQUEST['page']}&LO_sort={$key}&LO_direction={$direction}&LO_search=" . urlencode($_REQUEST['LO_search']);
                        }
                    }
                    echo " class=column_heading><b>{$value}</b></A>";
                    if ($i == 1) {
                        echo "<DIV id=LOy0 style='position: relative;'></DIV>";
                    }
                    echo "</TD>";
                    $i++;
                }
                //echo '<TD width=0><DIV id=LO'.$i.'></DIV></TD>';
                echo "</TR>";
            }
            $color = 'class=even';
            //style="height: 300px; overflow: auto; padding-right: 16px;"
            if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) {
                echo '</THEAD><TBODY>';
            }
            // mab - enable add link as first or last
            if ($result_count != 0 && $link['add']['first'] && $stop - $start >= $link['add']['first']) {
                //if($remove && !isset($_REQUEST['_openSIS_PDF']))
                //	$cols++;
                if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) {
                    echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add', $link['add']['title'], $link['add']['link']) . "</TD></TR>";
                } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) {
                    echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add') . $link['add']['span'] . "</TD></TR>";
                } elseif ($link['add']['html'] && $cols) {
                    echo "<TR {$color}>";
                    if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $link['add']['html']['remove']) {
                        echo "<TD class=even align=left>" . $link['add']['html']['remove'] . "</TD>";
                    } elseif ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
                        echo "<TD class=even align=left>" . button('add') . "</TD>";
                    }
                    foreach ($column_names as $key => $value) {
                        echo "<TD class=even align=left >" . $link['add']['html'][$key] . "</TD>";
                    }
                    echo "</TR>";
                    $count++;
                }
            }
            for ($i = $start; $i <= $stop; $i++) {
                $item = $result[$i];
                if (isset($_REQUEST['_openSIS_PDF']) && $options['print'] && count($item)) {
                    foreach ($item as $key => $value) {
                        $value = eregi_replace('<SELECT.*SELECTED\\>([^<]+)<.*</SELECT\\>', '\\1', $value);
                        $value = eregi_replace('<SELECT.*</SELECT\\>', '', $value);
                        if (strpos($value, 'LO_field') === false) {
                            $item[$key] = str_replace(' ', '&nbsp;', ereg_replace("<div onclick='[^']+'>", '', $value));
                        } else {
                            $item[$key] = ereg_replace("<div onclick='[^']+'>", '', $value);
                        }
                    }
                }
                if ($item['row_color']) {
                    $color = $item['row_color'];
                } elseif ($color == 'class=even') {
                    $color = $side_color;
                } else {
                    $color = 'class=even';
                }
                //$color = '#EDF3FE';
                if (isset($_REQUEST['_openSIS_PDF']) && $count % $repeat_headers == 0) {
                    if ($count != 0) {
                        echo '</TABLE><TABLE cellpadding=6 width=820 class=\\"grid\\">';
                        echo '<!-- NEW PAGE -->';
                    }
                    echo "<TR>";
                    if ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
                        echo "<TD class=grid></TD>";
                    }
                    if ($cols) {
                        foreach ($column_names as $key => $value) {
                            echo "<TD class=grid >" . str_replace(' ', '&nbsp;', $value) . "</TD>";
                        }
                    }
                    echo "</TR>";
                }
                if ($count == 0) {
                    $count = $br;
                }
                echo "<TR {$color}>";
                $count++;
                if ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
                    $button_title = $link['remove']['title'];
                    //if(!$button_title)
                    //$button_title = 'Remove';
                    $button_link = $link['remove']['link'];
                    if (count($link['remove']['variables'])) {
                        foreach ($link['remove']['variables'] as $var => $val) {
                            $button_link .= "&{$var}=" . $item[$val];
                        }
                    }
                    echo "<TD {$color}>" . button('remove', $button_title, $button_link) . "</TD>";
                }
                if ($cols) {
                    foreach ($column_names as $key => $value) {
                        if ($link[$key] && !isset($_REQUEST['_openSIS_PDF'])) {
                            echo "<TD {$color} >";
                            if ($key == 'FULL_NAME') {
                                echo '<DIV id=LOy' . ($count - $br) . ' style="height: 100%; min-height: 100%; position: relative;">';
                            }
                            if ($link[$key]['js'] === true) {
                                echo "<A HREF=# onclick='window.open(\"{$link[$key][link]}";
                                if (count($link[$key]['variables'])) {
                                    foreach ($link[$key]['variables'] as $var => $val) {
                                        echo "&{$var}=" . urlencode($item[$val]);
                                    }
                                }
                                echo "\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'";
                                if ($link[$key]['extra']) {
                                    echo ' ' . $link[$key]['extra'];
                                }
                                echo ">";
                            } else {
                                echo "<A HREF={$link[$key][link]}";
                                if (count($link[$key]['variables'])) {
                                    foreach ($link[$key]['variables'] as $var => $val) {
                                        echo "&{$var}=" . urlencode($item[$val]);
                                    }
                                }
                                if ($link[$key]['extra']) {
                                    echo ' ' . $link[$key]['extra'];
                                }
                                echo " onclick='grabA(this); return false;'>";
                            }
                            if ($color == Preferences('HIGHLIGHT')) {
                                echo '';
                            } else {
                                echo '<b>';
                            }
                            echo $item[$key];
                            echo '</b>';
                            if (!$item[$key]) {
                                echo '***';
                            }
                            echo "</A>";
                            if ($key == 'FULL_NAME') {
                                echo '</DIV>';
                            }
                            echo "</TD>";
                        } else {
                            echo "<TD {$color} >";
                            if ($key == 'FULL_NAME') {
                                echo '<DIV id=LOy' . ($count - $br) . '  style="position: relative;">';
                            }
                            if ($color == Preferences('HIGHLIGHT')) {
                                echo '';
                            }
                            echo $item[$key];
                            if (!$item[$key]) {
                                echo '&nbsp;';
                            }
                            if ($key == 'FULL_NAME') {
                                echo '<DIV>';
                            }
                            echo "</TD>";
                        }
                    }
                }
                echo "</TR>";
            }
            if ($result_count != 0 && (!$link['add']['first'] || $link['add']['first'] && $stop - $start < $link['add']['first'])) {
                //if($remove && !isset($_REQUEST['_openSIS_PDF']))
                //	$cols++;
                if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) {
                    echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add', $link['add']['title'], $link['add']['link']) . "</TD></TR>";
                } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) {
                    echo "<TR><TD colspan=" . ($remove ? $cols + 1 : $cols) . " align=left class=even>" . button('add') . $link['add']['span'] . "</TD></TR>";
                } elseif ($link['add']['html'] && $cols) {
                    if ($count % 2) {
                        $color = 'class=even';
                    } else {
                        $color = $side_color;
                    }
                    echo "<TR {$color}>";
                    if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $link['add']['html']['remove']) {
                        echo "<TD class=even align=left>" . $link['add']['html']['remove'] . "</TD>";
                    } elseif ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
                        echo "<TD class=even align=left class=grid_button>" . button('add') . "</TD>";
                    }
                    foreach ($column_names as $key => $value) {
                        echo "<TD class=even align=left  valign=top>" . $link['add']['html'][$key] . "</TD>";
                    }
                    echo "</TR>";
                }
            }
            if ($result_count != 0) {
                if (!isset($_REQUEST['_openSIS_PDF']) && $stop - $start > 10) {
                    echo '</TBODY>';
                }
                echo "</TABLE>";
                // SHADOW
                if (!isset($_REQUEST['_openSIS_PDF'])) {
                    echo '</TD ></TR></TABLE>';
                    echo "<script language='javascript' type='text/javascript'>\n";
                    #echo "alert('calling pager');\n";
                    $number_rec = 100;
                    echo "var pager = new Pager('results',{$number_rec});\n";
                    echo "pager.init();\n";
                    echo "pager.showPageNav('pager', 'pagerNavPosition');\n";
                    echo "pager.showPage(1);\n";
                    echo "</script>\n";
                }
                echo "</TD ></TR>";
                echo "</TABLE>";
                if ($options['center']) {
                    echo '';
                }
            }
            // END PRINT THE LIST ---
        }
        if ($result_count == 0) {
            // mab - problem with table closing if not opened above - do same conditional?
            if ($result_count > $num_displayed || ($options['count'] || $display_zero) && (($result_count == 0 || $display_count == 0) && $plural || ($result_count == 0 || $display_count == 0))) {
                #echo '<td>'; //edited for Search in parents (user>> associate student with parents)
                if ($link['add']['link'] && !isset($_REQUEST['_openSIS_PDF'])) {
                    echo '<table width=120px cellspacing=8 cellpadding=6 ><tr><TD align=left class=lone_add >' . button('add', $link['add']['title'], $link['add']['link']) . '</td></tr></table>';
                } elseif (($link['add']['html'] || $link['add']['span']) && count($column_names) && !isset($_REQUEST['_openSIS_PDF'])) {
                    $color = $side_color;
                    if ($options['center']) {
                        #echo '<CENTER>';
                        // WIDTH=100%
                        //echo "<TABLE cellpadding=1 bgcolor=#f8f8f9 width=100%><TR><TD>";
                        // SHADOW
                        echo '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>';
                    }
                    if ($link['add']['html']) {
                        /*Here also change the colour for left corner*/
                        echo "<TABLE cellpadding=6 cellspacing=1 width=96% class=\"grid\"><TR><TD class=subtabs></TD>";
                        foreach ($column_names as $key => $value) {
                            //Here to change the ListOutput Header Colour
                            echo "<TD class=subtabs><A><b>" . str_replace(' ', '&nbsp;', $value) . "</b></A></TD>";
                        }
                        echo "</TR>";
                        echo "<TR class=odd>";
                        if ($link['add']['html']['remove']) {
                            echo "<TD >" . $link['add']['html']['remove'] . "</TD>";
                        } else {
                            echo "<TD>" . button('add') . "</TD>";
                        }
                        foreach ($column_names as $key => $value) {
                            echo "<TD >" . $link['add']['html'][$key] . "</TD>";
                        }
                        echo "</TR>";
                        echo "</TABLE>";
                    } elseif ($link['add']['span'] && !isset($_REQUEST['_openSIS_PDF'])) {
                        echo "<TABLE><TR><TD align=center>" . button('add') . $link['add']['span'] . "</TD></TR></TABLE>";
                    }
                    // SHADOW
                    //echo '</TD></TR></TABLE>';
                    echo "</TD></TR></TABLE>";
                    if ($options['center']) {
                        echo '</CENTER>';
                    }
                }
            }
        }
        if ($result_count != 0) {
            if ($options['yscroll']) {
                echo '<div id="LOy_layer" style="position: absolute; top: 0; left: 0; visibility:hidden;">';
                echo '<TABLE cellpadding=6 id=LOy_table>';
                $i = 1;
                if ($cols && !isset($_REQUEST['_openSIS_PDF'])) {
                    $color = $side_color;
                    foreach ($result as $item) {
                        echo "<TR><TD {$color}  id=LO_row{$i}>";
                        if ($color == Preferences('HIGHLIGHT')) {
                            echo '';
                        }
                        echo $item['FULL_NAME'];
                        if (!$item['FULL_NAME']) {
                            echo '&nbsp;';
                        }
                        if ($color == Preferences('HIGHLIGHT')) {
                            echo '';
                        }
                        echo "</TD></TR>";
                        $i++;
                        if ($item['row_color']) {
                            $color = $item['row_color'];
                        } elseif ($color == 'class=even') {
                            $color = $side_color;
                        } else {
                            $color = 'class=even';
                        }
                    }
                }
                echo '</TABLE>';
                echo '</div>';
            }
            echo '<div id="LOx_layer" style="position: absolute; top: 0; left: 0; visibility:hidden;">';
            echo '<TABLE cellpadding=6 id=LOx_table><TR>';
            $i = 1;
            if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $result_count != 0) {
                echo "<TD class=grid id=LO_col{$i}></TD>";
                $i++;
            }
            if ($cols && !isset($_REQUEST['_openSIS_PDF'])) {
                foreach ($column_names as $key => $value) {
                    echo '<TD class=grid id=LO_col' . $i . '><A class=column_heading><b>' . str_replace('controller', '', $value) . '</b></A></TD>';
                    $i++;
                }
            }
            echo '</TR></TABLE>';
            echo '</div>';
        }
    }
}
Beispiel #13
0
function _makeCommentsA($value, $column)
{
    global $THIS_RET, $current_commentsA_RET, $import_commentsA_RET, $commentsA_select, $tabindex;
    if ($import_commentsA_RET[$THIS_RET['STUDENT_ID']][$value]) {
        $select = $import_commentsA_RET[$THIS_RET['STUDENT_ID']][$value][1]['COMMENT'];
        $div = false;
    } else {
        if (!$current_commentsA_RET[$THIS_RET['STUDENT_ID']] && !$import_commentsA_RET[$THIS_RET['STUDENT_ID']] && AllowEdit()) {
            $select = Preferences('COMMENT_A', 'Gradebook');
            $div = false;
        } else {
            $select = $current_commentsA_RET[$THIS_RET['STUDENT_ID']][$value][1]['COMMENT'];
            $div = true;
        }
    }
    if (!isset($_REQUEST['_openSIS_PDF'])) {
        $return = SelectInput($select, 'values[' . $THIS_RET['STUDENT_ID'] . '][commentsA][' . $value . ']', '', $commentsA_select, 'N/A', 'tabindex=' . ($tabindex += 100), $div);
    } else {
        $return = $select != ' ' ? $select : 'o';
    }
    return $return;
}
Beispiel #14
0
             echo '</TR>';
         }
     } else {
         if (count($info_RET)) {
             foreach ($info_RET as $info) {
                 echo '<TR>';
                 if (AllowEdit()) {
                     echo '<TD width=20>' . button('remove', '', "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&address_id={$_REQUEST['address_id']}&person_id={$_REQUEST['person_id']}&contact_id=" . $info['ID']) . '</TD>';
                 } else {
                     echo '<TD></TD>';
                 }
                 echo '<TD><DIV id=info_' . $info['ID'] . '><div onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', TextInput($info['VALUE'], 'values[people_join_contacts][' . $info['ID'] . '][VALUE]', '', '', false) . '<BR>' . str_replace("'", '&#39;', _makeAutoSelectInputX($info['TITLE'], 'TITLE', 'people_join_contacts', '', $info_options, $info['ID'], false))) . '</TD></TR></TABLE>","info_' . $info['ID'] . '",true);\'>' . $info['VALUE'] . '<BR><small><FONT color=' . ($info_options_x[$info['TITLE']] ? Preferences('TITLES') : 'blue') . '>' . $info['TITLE'] . '</FONT></small></div></DIV></TD>';
                 echo '</TR>';
             }
         }
         if (AllowEdit() && $use_contact) {
             echo '<TR>';
             echo '</TR>';
         }
     }
     echo '</TABLE>';
     echo '</TD></TR>';
     echo '</TABLE>';
     #echo '</FIELDSET>';
     echo '</TD></TR>';
     echo '</TABLE>';
     // close 3e
 } else {
     echo '<TABLE border=0><TR><TD colspan=3><table><tr><td>' . CheckboxInput($this_contact['EMERGENCY'], 'values[students_join_people][EMERGENCY]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD><TD>' . _('This is an Emergency Contact') . '</TD></TR></table></TD></TR><tr><td colspan=3 class=break></td></tr>';
     echo '<TR><td style="width:120px" style=white-space:nowrap><span class=red>*</span>' . _('Relationship to Student') . '</td><td>:</td><TD>' . SelectInput($this_contact['STUDENT_RELATION'], 'values[students_join_people][STUDENT_RELATION]', '', $relation_options, 'N/A') . '</TD></TR>';
     echo '<TR><TD><span class=red>*</span>' . _('First Name') . '</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput('', 'FIRST_NAME', '', 'class=cell_medium')) . '</TD></tr><tr><td ><span class=red>' . _('*') . '</span>' . _('Last Name') . '</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput($this_contact['LAST_NAME'], 'LAST_NAME', '', 'class=cell_medium')) . '</TD></TR>';
function _makeLock($value, $column)
{
    global $THIS_RET;
    if ($value == 'Y') {
        $img = 'locked';
    } else {
        $img = 'unlocked';
    }
    return '<IMG SRC=assets/' . $img . '.gif ' . (AllowEdit() ? 'onclick="if(this.src.indexOf(\'assets/locked.gif\')!=-1) {this.src=\'assets/unlocked.gif\'; document.getElementById(\'lock' . $THIS_RET['COURSE_PERIOD_ID'] . '-' . $THIS_RET['START_DATE'] . '\').value=\'\';} else {this.src=\'assets/locked.gif\'; document.getElementById(\'lock' . $THIS_RET['COURSE_PERIOD_ID'] . '-' . $THIS_RET['START_DATE'] . '\').value=\'Y\';}"' : '') . '><INPUT type=hidden name=schedule[' . $THIS_RET['COURSE_PERIOD_ID'] . '][' . $THIS_RET['START_DATE'] . '][SCHEDULER_LOCK] id=lock' . $THIS_RET['COURSE_PERIOD_ID'] . '-' . $THIS_RET['START_DATE'] . ' value=' . $value . '>';
}
Beispiel #16
0
<?php

if ($_REQUEST['modfunc'] == 'update') {
    if (UserStudentID() && AllowEdit()) {
        if (count($_REQUEST['food_service'])) {
            $sql = "UPDATE FOOD_SERVICE_STUDENT_ACCOUNTS SET ";
            foreach ($_REQUEST['food_service'] as $column_name => $value) {
                $sql .= $column_name . "='" . str_replace("\\'", "''", trim($value)) . "',";
            }
            $sql = substr($sql, 0, -1) . " WHERE STUDENT_ID='" . UserStudentID() . "'";
            DBQuery($sql);
        }
    }
    //unset($_REQUEST['modfunc']);
    unset($_REQUEST['food_service']);
    unset($_SESSION['_REQUEST_vars']['food_service']);
}
if (!$_REQUEST['modfunc'] && UserStudentID()) {
    $student = DBGet(DBQuery("SELECT s.STUDENT_ID," . (Preferences('NAME') == 'Common' ? 'coalesce(s.CUSTOM_200000002,s.FIRST_NAME)' : 's.FIRST_NAME') . "||' '||s.LAST_NAME AS FULL_NAME,fssa.ACCOUNT_ID,fssa.STATUS,fssa.DISCOUNT,fssa.BARCODE,(SELECT BALANCE FROM FOOD_SERVICE_ACCOUNTS WHERE ACCOUNT_ID=fssa.ACCOUNT_ID) AS BALANCE FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE s.STUDENT_ID='" . UserStudentID() . "' AND fssa.STUDENT_ID=s.STUDENT_ID"));
    $student = $student[1];
    // find other students associated with the same account
    $xstudents = DBGet(DBQuery("SELECT s.STUDENT_ID," . (Preferences('NAME') == 'Common' ? 'coalesce(s.CUSTOM_200000002,s.FIRST_NAME)' : 's.FIRST_NAME') . "||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE fssa.ACCOUNT_ID='" . $student['ACCOUNT_ID'] . "' AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!='" . UserStudentID() . "'"));
    echo '<TABLE width=100%>';
    echo '<TR>';
    echo '<TD valign=top>';
    echo '<TABLE width=100%><TR>';
    echo '<TD valign=top>' . NoInput(($student['BALANCE'] < 0 ? '<FONT color=red>' : '') . $student['BALANCE'] . ($student['BALANCE'] < 0 ? '</FONT>' : ''), _('Balance')) . '</TD>';
    echo '</TR></TABLE>';
    echo '</TD></TR></TABLE>';
    echo '<HR>';
    echo '<TABLE width=100% border=0 cellpadding=0 cellspacing=0>';
Beispiel #17
0
            include "modules/{$module}/Menu.php";
        }
    }
    $profile = User('PROFILE');
    if ($profile != 'student') {
        if (User('PROFILE_ID') != '') {
            $can_use_RET = DBGet(DBQuery("SELECT MODNAME FROM profile_exceptions WHERE PROFILE_ID='" . User('PROFILE_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
        } else {
            $can_use_RET = DBGet(DBQuery("SELECT MODNAME FROM staff_exceptions WHERE USER_ID='" . User('STAFF_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
        }
    } else {
        $can_use_RET = DBGet(DBQuery("SELECT MODNAME FROM profile_exceptions WHERE PROFILE_ID='3' AND CAN_USE='Y'"), array(), array('MODNAME'));
        $profile = 'parent';
    }
    foreach ($menu as $modcat => $profiles) {
        $menuprof = $menu;
        $programs = $profiles[$profile];
        foreach ($programs as $program => $title) {
            if (!is_numeric($program)) {
                if ($can_use_RET[$program] && ($profile != 'admin' || !$exceptions[$modcat][$program] || AllowEdit($program))) {
                    $_openSIS['Menu'][$modcat][$program] = $title;
                }
            } else {
                $_openSIS['Menu'][$modcat][$program] = $title;
            }
        }
    }
    if (User('PROFILE') == 'student') {
        unset($_openSIS['Menu']['Users']);
    }
}
Beispiel #18
0
     unset($disp_error);
 }
 $extra['SELECT'] = ',LAST_LOGIN';
 $extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
 if (basename($_SERVER['PHP_SELF']) != 'index.php') {
     if ($_REQUEST['staff_id'] == 'new') {
         DrawBC("Users > Add a User");
     } else {
         DrawBC("Users > " . ProgramTitle());
     }
     unset($_SESSION['staff_id']);
     Search('staff_id', $extra);
 } else {
     DrawHeader('Create Account');
 }
 if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'delete' && basename($_SERVER['PHP_SELF']) != 'index.php' && AllowEdit()) {
     if (DeletePrompt('user')) {
         DBQuery('DELETE FROM program_user_config WHERE USER_ID=\'' . UserStaffID() . '\'');
         DBQuery('DELETE FROM students_join_people WHERE PERSON_ID=\'' . UserStaffID() . '\'');
         DBQuery('DELETE FROM staff WHERE STAFF_ID=\'' . UserStaffID() . '\'');
         unset($_SESSION['staff_id']);
         unset($_REQUEST['staff_id']);
         unset($_REQUEST['modfunc']);
         echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
         Search('staff_id', $extra);
     }
 }
 if ((UserStaffID() || $_REQUEST['staff_id'] == 'new') && (basename($_SERVER['PHP_SELF']) != 'index.php' || !$_REQUEST['staff']['USERNAME']) && $_REQUEST['modfunc'] != 'delete' && $_SESSION['fn'] != 'staff') {
     if ($_REQUEST['staff_id'] != 'new') {
         $sql = 'SELECT s.TITLE,s.STAFF_ID,s.FIRST_NAME,s.LAST_NAME,s.MIDDLE_NAME,
                             USERNAME,PASSWORD,up.TITLE AS PROFILE,s.PROFILE_ID,s.HOME_PHONE,s.EMAIL,LAST_LOGIN,IS_DISABLE
Beispiel #19
0
function CheckboxInput_No($value, $name, $title = '', $checked = '', $new = false, $yes = 'Yes', $no = 'No', $div = true, $extra = '')
{
    // $checked has been deprecated -- it remains only as a placeholder
    if (Preferences('HIDDEN') != 'Y') {
        $div = false;
    }
    if ($div == false || $new == true) {
        if ($value && $value != 'N') {
            $checked = 'CHECKED';
        } else {
            $checked = '';
        }
    }
    if (AllowEdit() && !$_REQUEST['_openSIS_PDF']) {
        if ($new || $div == false) {
            return "<INPUT type=checkbox name={$name} value=Y  {$extra}>" . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
        } else {
            return "<DIV id='div{$name}'><div onclick='javascript:addHTML(\"<INPUT type=hidden name={$name} value=\\\"N\\\"><INPUT type=checkbox name={$name} " . ($value == 'Y' ? 'checked' : '') . " value=Y " . str_replace('"', '\\"', $extra) . ">" . ($title != '' ? '<BR><small>' . str_replace("'", '&#39;', (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '')) . '</small>' : '') . "\",\"div{$name}\",true)'>" . ($value != 'N' ? $yes : $no) . ($title != '' ? "<BR><small>" . str_replace("'", '&#39;', (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '')) . "</small>" : '') . "</div></DIV>";
        }
    } else {
        return ($value != 'N' ? $yes : $no) . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
    }
}
Beispiel #20
0
                        //
                        $period_select .= "<OPTION value={$period['ID']}" . (CpvId() == $period['ID'] ? ' SELECTED' : '') . ">" . $period['SHORT_NAME'] . ($period['MARKING_PERIOD_ID'] != $fy_id ? ' ' . GetMP($period['MARKING_PERIOD_ID'], 'SHORT_NAME') : '') . (strlen($period['DAYS']) < 5 ? ' ' . $period['DAYS'] : '') . ' - ' . $period['COURSE_TITLE'] . "</OPTION>";
                        //
                        if (CpvId() == $period['ID']) {
                            $_SESSION['UserPeriod'] = $period['PERIOD_ID'];
                        }
                    }
                    $period_select .= "</SELECT>";
                }
            }
        }
        $profile = DBGet(DBQuery('SELECT PROFILE FROM staff WHERE STAFF_ID=' . UserID()));
        if ($profile[1]['PROFILE'] == "admin") {
            DrawHeader($period_select);
        }
        echo '</FORM><BR>';
        unset($_openSIS['DrawHeader']);
        $_openSIS['allow_edit'] = AllowEdit($_REQUEST['modname']);
        $_openSIS['User'] = array(1 => array('STAFF_ID' => UserStaffID(), 'NAME' => GetTeacher(UserStaffID()), 'USERNAME' => GetTeacher(UserStaffID(), '', 'USERNAME'), 'PROFILE' => 'teacher', 'SCHOOLS' => ',' . UserSchool() . ',', 'SYEAR' => UserSyear()));
        echo '<CENTER><TABLE width=100% ><TR><TD>';
        include 'modules/' . $_REQUEST['include'];
        echo '</TD></TR></TABLE></CENTER>';
    }
}
?>
<script type="text/javascript">
    function close_window()
    {
        window.close();
    }
</script>
Beispiel #21
0
     }
     $header .= '<TR><td class=lable>Graded</td><TD>' . CheckboxInput($RET['DOES_GRADES'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
     $header .= '<TR><td class=lable>Exam</td><TD>' . CheckboxInput($RET['DOES_EXAM'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_EXAM]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
     $header .= '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
     $header .= '<TR><td class=lable>Begins</td><TD>' . DateInput($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', '') . '</TD></tr>';
     $header .= '<TR><td class=lable>Ends</td><TD>' . DateInput($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', '') . '</TD></tr>';
     $header .= '<TR><td class=lable>Grade Posting Begins</td><TD>' . DateInput($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', '') . '</TD></tr>';
     $str_srch = '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
     $header .= '<TR><td class=lable>Grade Posting Ends</td><TD>' . DateInput($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', '') . '</TD></tr>';
     $header .= '</TABLE>';
     DrawHeader($header);
     PopTable('footer');
     if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
         DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit value=Save class="btn_medium" onclick="formcheck_school_setup_marking();">' : '');
     } elseif ($_REQUEST['mp_term'] != 'FY') {
         DrawHeaderHome('', '', AllowEdit() ? $delete_button . '&nbsp;&nbsp;<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">' : '');
     } else {
         DrawHeaderHome('', '', '<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">');
     }
     echo '</FORM>';
     unset($_SESSION['_REQUEST_vars']['marking_period_id']);
     unset($_SESSION['_REQUEST_vars']['mp_term']);
 }
 // DISPLAY THE MENU
 $LO_options = array('save' => false, 'search' => false);
 echo '<TABLE cellpadding=3 width=100%><tr><td align="center"><br>';
 echo '<TABLE><TR>';
 // FY
 $sql = 'SELECT MARKING_PERIOD_ID,TITLE FROM school_years WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER';
 $QI = DBQuery($sql);
 $fy_RET = DBGet($QI);
Beispiel #22
0
                         $can_edit = $exceptions_RET[$file][1]['CAN_EDIT'];
                         echo "<TR><TD></TD><TD></TD>";
                         echo "<TD align=left style='padding:0px 0px 0px 47px'><INPUT type=checkbox name=can_use[" . str_replace('.', '_', $file) . "] value=true" . ($can_use == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD align=left style='padding:0px 0px 0px 47px'><INPUT type=checkbox name=can_edit[" . str_replace('.', '_', $file) . "] value=true" . ($can_edit == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD >{$title}</TD></TR><TR><TD></TD><TD></TD><TD colspan=3 class=break_headers></TR>";
                     }
                 } elseif ($modcat == 'Users' && $file == 'Users/User.php') {
                     $categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM STAFF_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE"));
                     foreach ($categories_RET as $category) {
                         $file = 'Users/User.php&category_id=' . $category['ID'];
                         $title = ' &nbsp; &nbsp; &rsaquo; ' . $category['TITLE'];
                         $can_use = $exceptions_RET[$file][1]['CAN_USE'];
                         $can_edit = $exceptions_RET[$file][1]['CAN_EDIT'];
                         echo "<TR><TD></TD><TD></TD>";
                         echo "<TD align=left style='padding:0px 0px 0px 47px'><INPUT type=checkbox name=can_use[" . str_replace('.', '_', $file) . "] value=true" . ($can_use == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD align=left style='padding:0px 0px 0px 47px'><INPUT type=checkbox name=can_edit[" . str_replace('.', '_', $file) . "] value=true" . ($can_edit == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD style='white-space: nowrap;'> &nbsp; &nbsp;{$title}</TD></TR><TR><TD></TD><TD></TD><TD colspan=3 class=break_headers></TR>";
                     }
                 }
             } else {
                 echo '<TR><TD></TD><TD></TD><TD colspan=3 style=background-color:#bee6f2 align=right><b> ' . $title . ' </b></TD></TR>';
             }
         }
     }
     echo '<TR><TD colspan=5 align=center height=20></TD></TR>';
 }
 echo '</TABLE>';
 #PopTable('footer');
 //	echo '<CENTER>'.SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("pref_form");\'').'</CENTER>';
 echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium') . '</CENTER>';
 // pref_form
Beispiel #23
0
    }
}
$extra['SELECT'] = ',LAST_LOGIN';
$extra['columns_after'] = array('LAST_LOGIN' => 'Last Login');
$extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
if (basename($_SERVER['PHP_SELF']) != 'index.php') {
    if ($_REQUEST['staff_id'] == 'new') {
        DrawBC("Users > Add a User");
    } else {
        DrawBC("Users > " . ProgramTitle());
    }
    SearchStaff('staff_id', $extra);
} else {
    DrawHeader('Create Account');
}
if ($_REQUEST['modfunc'] == 'delete' && basename($_SERVER['PHP_SELF']) != 'index.php' && AllowEdit()) {
    # ------------------------------------  For Certification Start ------------------------------------------- #
    if (DeletePrompt('certification')) {
        DBQuery("DELETE FROM staff_certification WHERE STAFF_CERTIFICATION_ID='{$_REQUEST['certification_id']}'");
        unset($_REQUEST['modfunc']);
        $_REQUEST['certification_id'] = 'new';
    }
}
if ((UserStaffID() || $_REQUEST['staff_id'] == 'new') && (basename($_SERVER['PHP_SELF']) != 'index.php' || !$_REQUEST['staff']['USERNAME']) && $_REQUEST['modfunc'] != 'delete' && $_SESSION['fn'] != 'user' && $_REQUEST['modfunc'] != 'remove') {
    if ($_REQUEST['modfunc'] != 'delete' || $_REQUEST['delete_ok'] == '1') {
        if ($_REQUEST['staff_id'] != 'new') {
            $sql = "SELECT * FROM staff  WHERE STAFF_ID='" . UserStaffID() . "'";
            $QI = DBQuery($sql);
            $staff = DBGet($QI);
            $staff = $staff[1];
            $email = $staff[EMAIL];
Beispiel #24
0
                }
                $sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
                $validate_title = DBGet(DBQuery('SELECT *  FROM rooms WHERE  TITLE=\'' . $title . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
                if (count($validate_title) != 0) {
                    echo "<font color='red'><b>Unable to save data, because title already exists.</b></font>";
                } else {
                    if ($go) {
                        DBQuery($sql);
                    }
                }
            }
        }
    }
}
DrawBC("School Setup > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove' && AllowEdit()) {
    $room_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]);
    $has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM course_period_var WHERE room_id='{$room_id}'"));
    $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
    if ($has_assigned > 0) {
        $qs = 'Modules.php?modname=schoolsetup/Rooms.php';
        UnableDeletePromptMod('Cannot delete because room are associated.', 'delete', $qs);
    } else {
        $qs = 'Modules.php?modname=schoolsetup/Rooms.php';
        if (DeletePromptMod('room', $qs)) {
            DBQuery("DELETE FROM rooms WHERE room_id='{$room_id}'");
            unset($_REQUEST['modfunc']);
        }
    }
}
if ($_REQUEST['modfunc'] != 'remove') {
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
    $date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'];
} else {
    $date = DBDate();
}
$current_RET = DBGet(DBQuery('SELECT ATTENDANCE_TEACHER_CODE,ATTENDANCE_CODE,ATTENDANCE_REASON,STUDENT_ID,ADMIN,COURSE_PERIOD_ID FROM attendance_period WHERE SCHOOL_DATE=\'' . $date . '\''), array(), array('STUDENT_ID', 'COURSE_PERIOD_ID'));
if ($_REQUEST['attendance'] && ($_POST['attendance'] || $_REQUEST['ajax']) && AllowEdit()) {
    foreach ($_REQUEST['attendance'] as $student_id => $values) {
        foreach ($values as $period => $columns) {
            if ($current_RET[$student_id][$period]) {
                $sql = 'UPDATE attendance_period SET ADMIN=\'Y\',';
                foreach ($columns as $column => $value) {
                    $sql .= $column . '=\'' . str_replace("\\'", "''", $value) . '\',';
                }
                $sql = substr($sql, 0, -1) . ' WHERE SCHOOL_DATE=\'' . $date . '\' AND COURSE_PERIOD_ID=\'' . $period . '\' AND STUDENT_ID=\'' . $student_id . '\'';
                DBQuery($sql);
            } else {
                $period_id = DBGet(DBQuery('SELECT PERIOD_ID FROM course_periods WHERE COURSE_PERIOD_ID=\'' . $period . '\''));
                $period_id = $period_id[1]['PERIOD_ID'];
                $sql = 'INSERT INTO attendance_period ';
                $fields = 'STUDENT_ID,SCHOOL_DATE,PERIOD_ID,MARKING_PERIOD_ID,COURSE_PERIOD_ID,ADMIN,';
                $values = '\'' . $student_id . '\',\'' . $date . '\',\'' . $period_id . '\',\'' . GetCurrentMP('QTR', $date) . '\',\'' . $period . '\',\'Y\',';
Beispiel #26
0
 if ($_REQUEST['course_period_id'] != 'new' && $RET['PARENT_ID'] != $_REQUEST['course_period_id']) {
     $parent = DBGet(DBQuery("SELECT cp.TITLE as CP_TITLE,c.TITLE AS C_TITLE FROM course_periods cp,courses c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.COURSE_PERIOD_ID='" . $RET['PARENT_ID'] . "'"));
     $parent = $parent[1]['C_TITLE'] . ' : ' . $parent[1]['CP_TITLE'];
 } elseif ($_REQUEST['course_period_id'] != 'new') {
     $children = DBGet(DBQuery("SELECT COURSE_PERIOD_ID FROM course_periods WHERE PARENT_ID='" . $_REQUEST['course_period_id'] . "' AND COURSE_PERIOD_ID!='" . $_REQUEST['course_period_id'] . "'"));
     if (count($children)) {
         $parent = 'N/A';
     } else {
         $parent = 'None';
     }
 }
 //		--------------------------------------------- Temp Coment ------------------------------------------------- 	//
 if ($_REQUEST['course_period_id'] != 'new' && $RET['PARENT_ID'] != $_REQUEST['course_period_id']) {
     $header .= "<TD colspan=2><DIV id=course_div>" . $parent . "</DIV> " . ($parent != 'N/A' && AllowEdit() ? "<A HREF=# onclick='window.open(\"for_window.php?modname=misc/ChooseParentCourse.php\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'>Choose</A>" . "&nbsp;&nbsp;" . "<INPUT type=checkbox name='tables[course_periods][" . $_REQUEST['course_period_id'] . "][PARENT_ID]' value='" . $_REQUEST['course_period_id'] . "' >&nbsp;Remove" . "<BR>" : '') . "<small><FONT color=" . Preferences('TITLES') . ">Parent Period</FONT></small></TD>";
 } else {
     $header .= "<TD colspan=2><DIV id=course_div>" . $parent . "</DIV> " . ($parent != 'N/A' && AllowEdit() ? "<A HREF=# onclick='window.open(\"for_window.php?modname=misc/ChooseParentCourse.php\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'>Choose</A><BR>" : '') . "<small><FONT color=" . Preferences('TITLES') . ">Parent Period</FONT></small></TD>";
 }
 $header .= '<TD>' . CheckboxInput($RET['DOES_BREAKOFF'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_BREAKOFF]', 'Allow Teacher Gradescale', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', $div) . '</TD>';
 $header .= '</TR><TR>';
 $header .= '<TD>' . CheckboxInput($RET['COURSE_WEIGHT'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][COURSE_WEIGHT]', 'Course is Weighted', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', $div) . '</TD>';
 $header .= '<TD>' . CheckboxInput($RET['USE_STANDARDS'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][USE_STANDARDS]', 'Use Standards', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', true, 'onclick="show_stadard_div()" id="cp_use_standards" ') . '</TD>';
 //sg
 //  $standard_gard_scales =DBGet(DBQuery('SELECT DISTINCT rcgs.ID,rcgs.TITLE FROM report_card_grade_scales rcgs,report_card_grades rcg WHERE rcgs.SYEAR=\''.UserSyear().'\' AND rcgs.SCHOOL_ID=\''.UserSchool().'\' AND rcgs.ID=rcg.GRADE_SCALE_ID AND concat("",rcg.TITLE * 1) = rcg.TITLE '));
 $standard_gard_scales = DBGet(DBQuery('SELECT ID,TITLE FROM report_card_grade_scales WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND STANDARD_GRADE_SCALE="Y" '));
 foreach ($standard_gard_scales as $standard_option) {
     $standard_options[$standard_option['ID']] = $standard_option['TITLE'];
 }
 $header .= '<TD><DIV ID="standards_option" ' . ($RET['USE_STANDARDS'] == 'Y' ? '' : ' style="display:none" ') . ' >' . SelectInput($RET['STANDARD_SCALE_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][STANDARD_SCALE_ID]', 'Standard Grade Scale', $standard_options, 'Select Standard Grade', 'id="cp_standard_scale" ') . '</DIV></TD>';
 $header .= '<TD valign=top>' . CheckboxInput($RET['DOES_HONOR_ROLL'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_HONOR_ROLL]', 'Affects Honor Roll', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', $div) . '</TD>';
 $header .= '<TD valign=top>' . CheckboxInput($RET['HALF_DAY'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][HALF_DAY]', 'Half Day', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', $div) . '</TD>';
 $header .= '<TD>' . CheckboxInput($RET['DOES_CLASS_RANK'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_CLASS_RANK]', 'Affects Class Rank', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', $div) . '</TD>';
             if ($_REQUEST['elements']['comments'] == 'Y') {
                 $sep = '';
                 foreach ($mps[$last_mp][1]['COMMENTS_RET'] as $comment) {
                     $grades_RET[$i]['COMMENT'] .= $sep . $comments_RET[$comment['REPORT_CARD_COMMENT_ID']][1]['SORT_ORDER'];
                     if ($comment['COMMENT']) {
                         $grades_RET[$i]['COMMENT'] .= '(' . ($comment['COMMENT'] != ' ' ? $comment['COMMENT'] : '&middot;') . ')';
                     }
                     $sep = ', ';
                 }
                 if ($mps[$last_mp][1]['COMMENT_TITLE']) {
                     $grades_RET[$i]['COMMENT'] .= $sep . $mps[$last_mp][1]['COMMENT_TITLE'];
                 }
             }
         }
     }
     if (count($_REQUEST['mp_arr']) == 1 && AllowEdit()) {
         $link['remove']['link'] = PreparePHP_SELF($_REQUEST, array(), array('modfunc' => 'delete'));
         $link['remove']['variables'] = array('student_id' => 'STUDENT_ID', 'course_period_id' => 'COURSE_PERIOD_ID', 'marking_period_id' => 'MARKING_PERIOD_ID');
     }
     if (!isset($_REQUEST['_ROSARIO_PDF'])) {
         $commentsB_RET = DBGet(DBQuery("SELECT ID,TITLE,SORT_ORDER FROM REPORT_CARD_COMMENTS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND COURSE_ID IS NULL ORDER BY SORT_ORDER"), array(), array('ID'));
         if (count($commentsB_RET)) {
             foreach ($commentsB_RET as $comment) {
                 $tipmessage .= $comment[1]['SORT_ORDER'] . ' - ' . str_replace("'", '&acute;', $comment[1]['TITLE']) . '<BR />';
             }
             $tipmessage = button('comment', _('Comment Codes'), '"#" onmouseover=\'stm(["' . _('Report Card Comments') . '","' . str_replace('"', '\\"', str_replace("'", '&#39;', $tipmessage)) . '"],tipmessageStyle);\' onmouseout=\'htm()\'', 24);
             DrawHeader('', $tipmessage);
         }
     }
     ListOutput($grades_RET, $columns, '.', '.', $link);
 } else {
     $header .= '<TR><td class=lable>Begins</td><TD>' . DateInputAY($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', 1) . '</TD></tr>';
     $header .= '<TR><td class=lable>Ends</td><TD>' . DateInputAY($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', 2) . '</TD></tr>';
     $header .= '<TR><td class=lable colspan=2><div id=grade_div style="' . ($RET['DOES_GRADES'] == 'Y' ? "display:block" : "display:none") . '"><table>';
     $header .= '<tr><td class=lable>Grade Posting Begins</td><td>' . DateInputAY($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', 3) . '</td></tr>';
     $header .= '<tr><td class=lable>Grade Posting Ends</td><td>' . DateInputAY($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', 4) . '</td></tr>';
     $header .= '</table></div></td></TR>';
     $str_srch = '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
     $header .= '</TABLE>';
     DrawHeader($header);
     PopTable('footer');
     if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
         DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit value=Save class="btn_medium" onclick="formcheck_school_setup_marking();">' : '');
     } elseif ($_REQUEST['mp_term'] != 'FY') {
         DrawHeaderHome('', '', AllowEdit() ? $delete_button . '&nbsp;&nbsp;<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">' : '');
     } else {
         DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium" >' : '');
     }
     echo '</FORM>';
     unset($_SESSION['_REQUEST_vars']['marking_period_id']);
     unset($_SESSION['_REQUEST_vars']['mp_term']);
 }
 // DISPLAY THE MENU
 $LO_options = array('save' => false, 'search' => false);
 echo '<TABLE cellpadding=3 width=100%><tr><td align="center"><br>';
 echo '<TABLE><TR>';
 // FY
 $sql = 'SELECT MARKING_PERIOD_ID,TITLE FROM school_years WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER';
 $QI = DBQuery($sql);
 $fy_RET = DBGet($QI);
 if (count($fy_RET)) {
     if ($_REQUEST['mp_term']) {
function _makeRadio($value, $name)
{
    global $THIS_RET;
    if ($THIS_RET['ID']) {
        $id = $THIS_RET['ID'];
    } else {
        $id = 'new';
    }
    if ($THIS_RET[$name] == 'Y') {
        return "<TABLE align=center><TR><TD><INPUT type=radio name=val[" . $name . "] value=" . $id . "," . $name . " CHECKED></TD></TR></TABLE>";
    } else {
        return "<TABLE align=center><TR><TD><INPUT type=radio name=val[" . $name . "] value=" . $id . "," . $name . "" . (AllowEdit() ? '' : ' ') . "></TD></TR></TABLE>";
    }
}
Beispiel #30
0
                         $can_edit = $exceptions_RET[$file][1]['CAN_EDIT'];
                         echo "<TR><TD></TD><TD></TD>";
                         echo "<TD align=center bgcolor=#DDDDDD><INPUT type=checkbox name=can_use[" . str_replace('.', '_', $file) . "] value=true" . ($can_use == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD align=center bgcolor=#DDDDDD><INPUT type=checkbox name=can_edit[" . str_replace('.', '_', $file) . "] value=true" . ($can_edit == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD bgcolor=#DDDDDD> &nbsp; &nbsp;{$title}</TD></TR><TR><TD></TD><TD></TD><TD colspan=3 height=1 bgcolor=#000000></TR>";
                     }
                 } elseif ($modcat == 'Users' && $file == 'Users/User.php') {
                     $categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM STAFF_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE"));
                     foreach ($categories_RET as $category) {
                         $file = 'Users/User.php&category_id=' . $category['ID'];
                         $title = ' &nbsp; &nbsp; &rsaquo; ' . ParseMLField($category['TITLE']);
                         $can_use = $exceptions_RET[$file][1]['CAN_USE'];
                         $can_edit = $exceptions_RET[$file][1]['CAN_EDIT'];
                         echo "<TR><TD></TD><TD></TD>";
                         echo "<TD align=center bgcolor=#DDDDDD><INPUT type=checkbox name=can_use[" . str_replace('.', '_', $file) . "] value=true" . ($can_use == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD align=center bgcolor=#DDDDDD><INPUT type=checkbox name=can_edit[" . str_replace('.', '_', $file) . "] value=true" . ($can_edit == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
                         echo "<TD bgcolor=#DDDDDD> &nbsp; &nbsp;{$title}</TD></TR><TR><TD></TD><TD></TD><TD colspan=3 height=1 bgcolor=#000000></TR>";
                     }
                 }
             } else {
                 echo '<TR><TD></TD><TD></TD><TD bgcolor=#FFFFFF colspan=3 align=center><small><b>- ' . $title . ' -</b></small></TD></TR>';
             }
         }
     }
     echo '<TR><TD colspan=5 align=center height=20></TD></TR>';
 }
 echo '</TABLE>';
 PopTable('footer');
 echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
 echo '</DIV>';
 echo '</TD></TR></TABLE>';