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 ''; } }
/** * 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&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("'", ''', str_replace('"', '”', $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("'", "'", $value))) . "</TEXTAREA>" . ($title != '' ? "<BR><small>" . str_replace("'", ''', (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("'", ''', (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);
$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; }
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('"', '"', $option) . '\\"' . (strpos($value[$column], '||' . $option . '||') !== false ? ' CHECKED' : '') . '><small>' . $option . '</small></TD>'; } else { echo '<TD><INPUT type=checkbox name=' . $request . '[' . $column . '][] value="' . str_replace('"', '"', $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('"', '”', str_replace('||', ', ', substr($value[$column], 2, -2))) : '-') . "</div></DIV>"; } } else { echo $value[$column] != '' ? str_replace('"', '”', 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>'; } }
$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'] . ' ' . ($RET[1]['MIDDLE_NAME'] ? $RET[1]['MIDDLE_NAME'] . ' ' : '') . $RET[1]['LAST_NAME'] . ' ' . ' (<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'] . ' ' . ($RET[1]['MIDDLE_NAME'] ? $RET[1]['MIDDLE_NAME'] . ' ' : '') . $RET[1]['LAST_NAME'] . ' ' . ' (<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;
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(' ', ' ', 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>·', ' : ', str_replace(' ', ' ', $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) . " <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;"> '; 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;} '> <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(' ', ' ', 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(' ', ' ', $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 ' '; } 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(' ', ' ', $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 ' '; } 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>'; } } }
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; }
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("'", ''', _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 . '>'; }
<?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>';
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']); } }
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
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("'", ''', (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("'", ''', (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>' : ''); } }
// $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>
} $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 . ' <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);
$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 = ' › ' . $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;'> {$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
} } $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];
} $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\',';
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>" . " " . "<INPUT type=checkbox name='tables[course_periods][" . $_REQUEST['course_period_id'] . "][PARENT_ID]' value='" . $_REQUEST['course_period_id'] . "' > 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'] : '·') . ')'; } $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("'", '´', $comment[1]['TITLE']) . '<BR />'; } $tipmessage = button('comment', _('Comment Codes'), '"#" onmouseover=\'stm(["' . _('Report Card Comments') . '","' . str_replace('"', '\\"', str_replace("'", ''', $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 . ' <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>"; } }
$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> {$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 = ' › ' . 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> {$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>';