function DateInput_for_EndInput($value, $name, $title = '', $div = true, $allow_na = true)
{
if (Preferences('HIDDEN') != 'Y') {
$div = false;
}
if (AllowEdit() && !$_REQUEST['_openSIS_PDF']) {
if ($value == '' || $div == false) {
return PrepareDate_for_EndInput($value, "_{$name}", $allow_na) . ($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(\"" . str_replace('"', '\\"', PrepareDate_for_EndInput($value, "_{$name}", true, array('Y' => 1, 'M' => 1, 'D' => 1))) . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '') . "\",\"div{$name}\",true)'>" . ($value != '' ? ProperDate($value) : '-') . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '') . '</div></DIV>';
}
} else {
return ($value != '' ? ProperDate($value) : '-') . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
}
}
function DateInput($value, $name, $title = '', $div = true, $allow_na = true)
{
if (Preferences('HIDDEN') != 'Y') {
$div = false;
}
if (AllowEdit() && !$_REQUEST['_CENTRE_PDF']) {
if ($value == '' || $div == false) {
return PrepareDate($value, "_{$name}", $allow_na) . ($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(\"" . str_replace('"', '\\"', PrepareDate($value, "_{$name}", $allow_na, array('Y' => 1, 'M' => 1, 'D' => 1))) . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . str_replace(array("'", '"'), array(''', '\\"'), $title) . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '') . "\",\"div{$name}\",true)'><span style='border-bottom-style:dotted;border-bottom-width:1;border-bottom-color:" . Preferences('TITLES') . ";'>" . ($value != '' ? ProperDate($value) : '-') . '</span>' . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '') . '</div></DIV>';
}
} else {
return ($value != '' ? ProperDate($value) : '-') . ($title != '' ? '<BR><small>' . (strpos(strtolower($title), '<font ') === false ? '<FONT color=' . Preferences('TITLES') . '>' : '') . $title . (strpos(strtolower($title), '<font ') === false ? '</FONT>' : '') . '</small>' : '');
}
}
function DateInput($value, $name, $title = '', $div = true, $allow_na = true)
{
if (Preferences('HIDDEN') != 'Y') {
$div = false;
}
if (AllowEdit() && !isset($_REQUEST['_ROSARIO_PDF'])) {
if ($value == '' || $div == false) {
return PrepareDate($value, '_' . $name, $allow_na) . ($title != '' ? '<BR />' . (mb_strpos(mb_strtolower($title), '<span ') === false ? '<span class="legend-gray">' : '') . $title . (mb_strpos(mb_strtolower($title), '<span ') === false ? '</span>' : '') . '' : '');
} else {
$return = '<DIV id="div' . $name . '"><div class="onclick" onclick=\'javascript:addHTML("';
$toEscape = PrepareDate($value, '_' . $name, $allow_na, array('Y' => 1, 'M' => 1, 'D' => 1)) . ($title != '' ? '<BR />' . (mb_strpos(mb_strtolower($title), '<span ') === false ? '<span class="legend-gray">' : '') . str_replace("'", ''', $title) . (mb_strpos(mb_strtolower($title), '<span ') === false ? '</span>' : '') : '');
$return .= str_replace('"', '\\"', $toEscape);
$return .= '","div' . $name . '",true)\'><span class="underline-dots">' . ($value != '' ? ProperDate($value) : '-') . '</span>' . ($title != '' ? '<BR />' . (mb_strpos(mb_strtolower($title), '<span ') === false ? '<span class="legend-gray">' : '') . $title . (mb_strpos(mb_strtolower($title), '<span ') === false ? '</span>' : '') . '' : '') . '</div></DIV>';
return $return;
}
} else {
return ($value != '' ? ProperDate($value) : '-') . ($title != '' ? '<BR />' . (mb_strpos(mb_strtolower($title), '<span ') === false ? '<span class="legend-gray">' : '') . $title . (mb_strpos(mb_strtolower($title), '<span ') === false ? '</span>' : '') . '' : '');
}
}
function core_calendar_create_calendar_events_object()
{
//first, gather the necessary variables
global $columns;
//then, convert variables for the Moodle object:
/*
list of (
//event
object {
name string //event name
description string Default to "null" //Description
format int Default to "1" //description format (1 = HTML, 0 = MOODLE, 2 = PLAIN or 4 = MARKDOWN)
courseid int Default to "0" //course id
groupid int Default to "0" //group id
repeats int Default to "0" //number of repeats
eventtype string Default to "user" //Event type
timestart int Default to "1370827707" //timestart
timeduration int Default to "0" //time duration (in minutes)
visible int Default to "1" //visible
sequence int Default to "1" //sequence
}
)
*/
$name = $columns['TITLE'];
$description = (!empty($columns['ASSIGNED_DATE']) ? _('Assigned Date') . ': ' . ProperDate($columns['ASSIGNED_DATE']) . '<br />' : '') . $columns['DESCRIPTION'];
$format = 1;
//gather the Moodle course ID
$courseid = DBGet(DBQuery("SELECT moodle_id FROM moodlexrosario WHERE rosario_id='" . UserCoursePeriod() . "' AND \"column\"='course_period_id'"));
if (count($courseid)) {
$courseid = (int) $courseid[1]['MOODLE_ID'];
} else {
return null;
}
$eventtype = 'course';
$timestart = strtotime($columns['DUE_DATE']);
$events = array(array('name' => $name, 'description' => $description, 'format' => $format, 'courseid' => $courseid, 'timestart' => $timestart, 'eventtype' => $eventtype));
return array($events);
}
}
if ($_REQUEST[stuid]) {
$sql .= "AND ssm.STUDENT_ID='{$_REQUEST['stuid']}' ";
}
if ($_REQUEST[first]) {
$sql .= "AND s.FIRST_NAME LIKE '" . strtoupper($_REQUEST[first]) . "%' ";
}
if ($_REQUEST[last]) {
$sql .= "AND s.LAST_NAME LIKE '" . strtoupper($_REQUEST[last]) . "%' ";
}
$sql .= "ORDER BY s.LAST_NAME,s.FIRST_NAME,s.MIDDLE_NAME ";
$QI = DBQuery($sql);
$stubilling_RET = DBGet($QI, array('FIRST_NAME' => 'GetCapWords', 'LAST_NAME' => 'GetCapWords'));
$debits_table = 'STU_BILLING_ACT_LUNCH';
$credits_cond = " LUNCH_PAYMENT='Y' ";
$lunch_title = '<B>Lunch Purchases and Payments</B><BR>School Year: ' . DispYear($_REQUEST[year]) . '<BR>as of ' . ProperDate(DBDate());
$sql = "SELECT ssm.STUDENT_ID,ssm.SCHOOL,s.FIRST_NAME,s.LAST_NAME,s.MIDDLE_NAME ";
if (($_REQUEST[balance_low] || $_REQUEST[balance_low] === '0') && ($_REQUEST[balance_high] || $_REQUEST[balance_high] === '0')) {
$sql .= ",(SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ") as BALANCE ";
}
$sql .= "FROM STU_SCHOOL_MEETS ssm,STUDENTS s\n\t\t\tWHERE ssm.SYEAR='{$_REQUEST['year']}' AND s.STUDENT_ID=ssm.STUDENT_ID ";
if (($_REQUEST[balance_low] || $_REQUEST[balance_low] === '0') && ($_REQUEST[balance_high] || $_REQUEST[balance_high] === '0')) {
$sql .= "AND (SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ")\n\t\t\t\t BETWEEN '{$_REQUEST['balance_low']}' AND '{$_REQUEST['balance_high']}' ";
}
if ($_REQUEST[not_zero] == 'Y') {
$sql .= "AND (SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ")\n\t\t\t\t != '0' ";
}
if ($_REQUEST[sch]) {
$sql .= "AND ssm.SCHOOL='{$_REQUEST['sch']}' ";
}
if ($_REQUEST[grade]) {
<?php
DrawHeader(ProgramTitle());
$begin_date = $_REQUEST['day_begin'] . '-' . $_REQUEST[month_begin] . '-' . $_REQUEST[year_begin];
$end_date = $_REQUEST[day_end] . '-' . $_REQUEST[month_end] . '-' . $_REQUEST[year_end];
DrawHeader(ProperDate($begin_date) . ' - ' . ProperDate($end_date) . ' : ' . GetSchool($_REQUEST[sch]));
// LUNCH DEBITS
$sql = "SELECT MENU_ID," . db_case(array('FSC', "''", "'REG'", "'1'", "'FREE'", "'2'", "'REDUCED'")) . " as FSC,\n\t\t\tcount(*) as COUNT \n\t\tFROM STU_BILLING_ACT_LUNCH sba,STUDENT_ENROLLMENT se \n\t\tWHERE se.SYEAR=sba.SYEAR AND se.STUDENT_ID=sba.STUDENT_ID AND se.SCHOOL_ID='" . UserSchool() . "' AND ";
$sql .= "PAYMENT_DATE BETWEEN '{$begin_date}' AND '{$end_date}'\n\t\tGROUP BY MENU_ID,FSC";
$QI = DBQuery($sql);
$counts_RET = DBGet($QI, array(), array('MENU_ID', 'FSC'));
$sql = "SELECT ID,SCHOOL_ID,TITLE FROM LUNCH_MENU WHERE SCHOOL_ID='" . UserSchool() . "' ";
$QI = DBQuery($sql);
$menu_RET = DBGet($QI, array(), array('SCHOOL_ID'));
$columns = array('TITLE' => 'Lunch Item', 'REG_COUNT' => 'Regular Purchases', 'FREE_COUNT' => 'Free Purchases', 'REDUCED_COUNT' => 'Reduced Purchases', 'TOTAL' => 'Total');
foreach ($menu_RET as $school => $items) {
unset($RET);
$RET[] = '';
foreach ($items as $item) {
$total = $counts_RET[$item[ID]]['REG'][1]['COUNT'] + $counts_RET[$item[ID]]['FREE'][1]['COUNT'] + $counts_RET[$item[ID]]['REDUCED'][1]['COUNT'];
$RET[] = array('TITLE' => $item[TITLE], 'REG_COUNT' => $counts_RET[$item[ID]]['REG'][1]['COUNT'], 'FREE_COUNT' => $counts_RET[$item[ID]]['FREE'][1]['COUNT'], 'REDUCED_COUNT' => $counts_RET[$item[ID]]['REDUCED'][1]['COUNT'], 'TOTAL' => $total);
}
unset($RET[0]);
ListOutput($RET, $columns, '.', '.', '', array(), array('save' => false));
}
//// $extra['functions']['TEACHER'] = '_makeTeacher';
// $extra['group'] = array('STUDENT_ID');
// //$extra['group'] = array('STUDENT_ID','COURSE_PERIOD_ID');
// $RET = GetStuList($extra);
// print_r($RET);
$RET = DBGet(DBQuery("SELECT DISTINCT s.STUDENT_ID, CONCAT(s.LAST_NAME,', ',coalesce(s.COMMON_NAME,s.FIRST_NAME)) AS FULL_NAME FROM students s,student_standards ss, report_card_grades rcg, course_periods cp\r\n WHERE ss.GRADE_ID=rcg.ID AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND s.STUDENT_ID=ss.STUDENT_ID\r\n AND s.STUDENT_ID IN ({$st_list})\r\n "));
if (count($RET)) {
$grade_RET = DBGet(DBQuery("SELECT TITLE, COMMENT FROM report_card_grades WHERE SCHOOL_ID=" . UserSchool() . " AND SYEAR=" . UserSyear()));
$handle = PDFStart();
foreach ($RET as $student) {
/*echo "SELECT DISTINCT cp.COURSE_PERIOD_ID AS CP_ID, cp.TITLE AS CP_TITLE, cp.MARKING_PERIOD_ID, CONCAT(st.TITLE, ' ', st.LAST_NAME, ' ',st.FIRST_NAME) AS TEACHER FROM STUDENTS s,STUDENT_STANDARDS ss, REPORT_CARD_GRADES rcg, COURSE_PERIODS cp, MARKING_PERIODS mp, STAFF st
WHERE ss.GRADE_ID=rcg.ID AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND s.STUDENT_ID=ss.STUDENT_ID AND cp.MARKING_PERIOD_ID=mp.MARKING_PERIOD_ID AND cp.TEACHER_ID=st.STAFF_ID
AND s.STUDENT_ID=$student[STUDENT_ID]";*/
$periods = DBGet(DBQuery("SELECT DISTINCT cp.COURSE_PERIOD_ID AS CP_ID, cp.TITLE AS CP_TITLE, cp.MARKING_PERIOD_ID, CONCAT(st.TITLE, ' ', st.LAST_NAME, ' ',st.FIRST_NAME) AS TEACHER FROM students s,student_standards ss, report_card_grades rcg, course_periods cp, marking_periods mp, staff st\r\n WHERE ss.GRADE_ID=rcg.ID AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND s.STUDENT_ID=ss.STUDENT_ID AND cp.MARKING_PERIOD_ID=mp.MARKING_PERIOD_ID AND cp.TEACHER_ID=st.STAFF_ID\r\n AND s.STUDENT_ID={$student['STUDENT_ID']}"));
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Elementary Grades " . GetMp(UserMp()) . "</div><div style=\"font-size:12px;\">Student: " . $student[FULL_NAME] . " ( " . $student[STUDENT_ID] . " )</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=2 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo "<table >";
echo '<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDER="0" class="course_period_tbl">';
echo '<TR><TH align="left">Attendance</TH>';
$mp_RET = DBGet(DBQuery("SELECT DISTINCT mp.TITLE, mp.MARKING_PERIOD_ID FROM marking_periods mp, course_periods cp, attendance_period ap\r\n WHERE mp.MARKING_PERIOD_ID=cp.MARKING_PERIOD_ID\r\n AND cp.SCHOOL_ID=" . UserSchool() . " AND cp.SYEAR=" . UserSyear() . "\r\n AND cp.COURSE_PERIOD_ID=ap.COURSE_PERIOD_ID AND ap.STUDENT_ID={$student['STUDENT_ID']}"));
$mp_name = DBGet(DBQuery("SELECT DISTINCT mp.SHORT_NAME,mp.MARKING_PERIOD_ID FROM marking_periods mp WHERE mp.SCHOOL_ID=" . UserSchool() . " AND mp.SYEAR=" . UserSyear() . ""));
foreach ($mp_name as $mp1) {
echo '<TH align="center" width="60px">' . $mp1[SHORT_NAME] . '</TH>';
}
echo '</TR>';
$atteadance_code_RET = DBGet(DBQuery("SELECT ID, TITLE FROM attendance_codes WHERE SCHOOL_ID=" . UserSchool() . " AND SYEAR=" . UserSyear() . " ORDER BY SORT_ORDER, TITLE"));
foreach ($atteadance_code_RET as $ac) {
echo '<TR>';
echo '<TD class="course_period">' . $ac[TITLE] . '</TD>';
//echo '<TD class="course_period"></TD>';
//echo '<TD class="course_period"></TD>';
function makeLogin($value)
{
return ProperDate(substr($value, 0, 10)) . substr($value, 10);
}
$month = date('m', $_REQUEST['month']);
$year = date('Y', $_REQUEST['month']);
$time = mktime(0, 0, 0, $month, 1, $year);
$last = 31;
while (!checkdate(9, $last, 2012)) {
$last--;
}
$skip = date("w", $time);
if ($skip) {
$header .= "<td colspan=" . $skip . "></td>";
$return_counter = $skip;
}
for ($i = 1; $i <= $last; $i++) {
$day_time = mktime(0, 0, 0, $month, $i, $year);
$date = date('Y-m-d', $day_time);
$header .= "<TD title='" . ProperDate($date) . "' width=100 class=" . ($periods[$cpblocked_RET[$date][1]['PERIOD_ID']] ? 'calendar_active' : 'calendar_holiday') . " valign=top>\r\n <table width=100><tr><td width=5 valign=top>{$i}</td><td width=95 align=right></TD></TR>";
$header .= "</td></tr><tr><TD colspan=2 height=40 valign=top>";
if (in_array(date('D', $day_time), $caldays) && $date >= $begin && $date <= $end) {
$block_periods = DBGet(DBQuery("SELECT * FROM course_period_var WHERE course_period_id='" . $_REQUEST['course_period_id'] . "'\r\n AND course_period_date='" . $date . "'"));
$header .= $periods[$cpblocked_RET[$date][1]['PERIOD_ID']] . '<br>';
$header .= $rooms[$cpblocked_RET[$date][1]['ROOM_ID']] . '<br>';
if ($cpblocked_RET[$date][1]['PERIOD_ID'] == '') {
$header .= '<tr><td valign=bottom align=left>' . button('add', '', "# onclick='javascript:window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=detail&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&course_period_id={$_REQUEST['course_period_id']}&mode=add&calendar_id={$_REQUEST['calendar_id']}&meet_date={$date}\",\"blank\",\"width=600,height=400\"); return false;'") . "</td></tr>";
} else {
foreach ($block_periods as $ind => $data) {
$header .= '<table><tr><td>Attendance : ' . ($data['DOES_ATTENDANCE'] == 'Y' ? 'Yes' : 'No') . '</td>';
$header .= '<td valign=bottom align=left>' . button('edit', '', "# onclick='javascript:window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=detail&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&course_period_id={$_REQUEST['course_period_id']}&mode=edit&calendar_id={$_REQUEST['calendar_id']}&id={$data['ID']}&meet_date={$date}\",\"blank\",\"width=600,height=400\"); return false;'") . "</td></tr></table>";
}
$header .= '<tr><td valign=bottom align=left>' . button('add', '', "# onclick='javascript:window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=detail&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&course_period_id={$_REQUEST['course_period_id']}&mode=add&calendar_id={$_REQUEST['calendar_id']}&meet_date={$date}&add=new\",\"blank\",\"width=600,height=400\"); return false;'") . "</td></tr>";
}
}
function ShortDate($date = '', $column = '')
{
return ProperDate($date, 'short');
}
DrawHeader(Config('TITLE') . ' - ' . _('Student Requests'));
DrawHeader($address[1]['FULL_NAME'], $address[1]['STUDENT_ID']);
DrawHeader($address[1]['GRADE_ID']);
DrawHeader(GetSchool(UserSchool()));
DrawHeader(ProperDate(DBDate()));
echo '<BR><BR><TABLE width=100%><TR><TD width=50> </TD><TD>' . $address[1]['MAILING_LABEL'] . '</TD></TR></TABLE><BR>';
ListOutput($address, $columns, _('Request'), _('Requests'), array(), array(), array('center' => false, 'print' => false));
echo '<!-- NEW PAGE -->';
}
} else {
unset($_CENTRE['DrawHeader']);
DrawHeader(Config('TITLE') . ' - ' . _('Student Requests'));
DrawHeader($courses[1]['FULL_NAME'], $courses[1]['STUDENT_ID']);
DrawHeader($courses[1]['GRADE_ID']);
DrawHeader(GetSchool(UserSchool()));
DrawHeader(ProperDate(DBDate()));
ListOutput($courses, $columns, _('Request'), _('Requests'), array(), array(), array('center' => false, 'print' => false));
echo '<!-- NEW PAGE -->';
}
}
PDFStop($handle);
} else {
BackPrompt(_('No Students were found.'));
}
}
function _makeExtra($value, $title = '')
{
global $THIS_RET;
if ($THIS_RET['WITH_TEACHER_ID']) {
$return .= Localize('colon', _('With')) . ' ' . GetTeacher($THIS_RET['WITH_TEACHER_ID']) . '<BR>';
}
function _make($value, $column)
{
if (substr_count($value, '-') == 2 && VerifyDate($value)) {
$value = ProperDate($value);
} elseif (is_numeric($value)) {
$value = strpos($value, '.') === false ? $value : rtrim(rtrim($value, '0'), '.');
}
return str_replace('||', ',<BR>', trim($value, '|'));
}
function CustomFields($location, $table_arr = '', $exp = 0)
{
global $_openSIS;
if (count($_REQUEST['month_cust_begin'])) {
foreach ($_REQUEST['month_cust_begin'] as $field_name => $month) {
$_REQUEST['cust_begin'][$field_name] = $_REQUEST['day_cust_begin'][$field_name] . '-' . $_REQUEST['month_cust_begin'][$field_name] . '-' . $_REQUEST['year_cust_begin'][$field_name];
$_REQUEST['cust_end'][$field_name] = $_REQUEST['day_cust_end'][$field_name] . '-' . $_REQUEST['month_cust_end'][$field_name] . '-' . $_REQUEST['year_cust_end'][$field_name];
if (!VerifyDate($_REQUEST['cust_begin'][$field_name]) || !VerifyDate($_REQUEST['cust_end'][$field_name])) {
unset($_REQUEST['cust_begin'][$field_name]);
unset($_REQUEST['cust_end'][$field_name]);
}
}
unset($_REQUEST['month_cust_begin']);
unset($_REQUEST['year_cust_begin']);
unset($_REQUEST['day_cust_begin']);
unset($_REQUEST['month_cust_end']);
unset($_REQUEST['year_cust_end']);
unset($_REQUEST['day_cust_end']);
}
if (count($_REQUEST['cust'])) {
foreach ($_REQUEST['cust'] as $key => $value) {
if ($value == '') {
unset($_REQUEST['cust'][$key]);
}
}
}
switch ($location) {
case 'from':
break;
case 'where':
if (count($_REQUEST['cust']) || count($_REQUEST['cust_begin'])) {
$fields = DBGet(DBQuery('SELECT TITLE,ID,TYPE,SYSTEM_FIELD FROM custom_fields'), array(), array('ID'));
}
if (count($_REQUEST['cust'])) {
foreach ($_REQUEST['cust'] as $id => $value) {
$field_name = $id;
$id = substr($id, 7);
if ($fields[$id][1]['SYSTEM_FIELD'] == 'Y') {
$field_name = strtoupper(str_replace(' ', '_', $fields[$id][1]['TITLE']));
}
if ($value != '') {
switch ($fields[$id][1]['TYPE']) {
case 'radio':
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>';
if ($value == 'Y') {
$string .= ' and s.' . $field_name . '=\'' . $value . '\' ';
$_openSIS['SearchTerms'] .= 'Yes';
} elseif ($value == 'N') {
$string .= ' and (s.' . $field_name . '!=\'Y\' OR s.' . $field_name . ' IS NULL) ';
$_openSIS['SearchTerms'] .= 'No';
}
$_openSIS['SearchTerms'] .= '<BR>';
break;
case 'codeds':
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>';
if ($value == '!') {
$string .= ' and (s.' . $field_name . '=\'\' OR s.' . $field_name . ' IS NULL) ';
$_openSIS['SearchTerms'] .= 'No Value';
} else {
$string .= ' and s.' . $field_name . '=\'' . $value . '\' ';
$_openSIS['SearchTerms'] .= $value;
}
$_openSIS['SearchTerms'] .= '<BR>';
break;
case 'select':
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>';
if ($value == '!') {
$string .= ' and (s.' . $field_name . '=\'\' OR s.' . $field_name . ' IS NULL) ';
$_openSIS['SearchTerms'] .= 'No Value';
} else {
$string .= ' and s.' . $field_name . '=\'' . $value . '\' ';
$_openSIS['SearchTerms'] .= $value;
}
$_openSIS['SearchTerms'] .= '<BR>';
break;
case 'autos':
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>';
if ($value == '!') {
$string .= ' and (s.' . $field_name . '=\'\' OR s.' . $field_name . ' IS NULL) ';
$_openSIS['SearchTerms'] .= 'No Value';
} else {
$string .= ' and s.' . $field_name . '=\'' . $value . '\' ';
$_openSIS['SearchTerms'] .= $value;
}
$_openSIS['SearchTerms'] .= '<BR>';
break;
case 'edits':
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>';
if ($value == '!') {
$string .= ' and (s.' . $field_name . '=\'\' OR s.' . $field_name . ' IS NULL) ';
$_openSIS['SearchTerms'] .= 'No Value';
} elseif ($value == '~') {
$string .= " and position('\n'||s.{$field_name}||'\r' IN '\n'||(SELECT SELECT_OPTIONS FROM custom_fields WHERE ID='" . $id . "')||'\r')=0 ";
$_openSIS['SearchTerms'] .= 'Other';
} else {
$string .= ' and s.' . $field_name . '=\'' . $value . '\' ';
$_openSIS['SearchTerms'] .= $value;
}
$_openSIS['SearchTerms'] .= '<BR>';
break;
case 'text':
if (substr($value, 0, 2) == '\\"' && substr($value, -2) == '\\"') {
$string .= ' and s.' . $field_name . '=\'' . substr($value, 2, -2) . '\' ';
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ': </b></font>' . substr($value, 2, -2) . '<BR>';
} else {
$string .= ' and LOWER(s.' . $field_name . ') LIKE \'' . strtolower($value) . '%\' ';
if ($exp == 1) {
$_openSIS['Search'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ' starts with: </b></font>' . $value . '<BR>';
} elseif ($exp == 2) {
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ' starts with: </b></font>' . $value . '<BR>';
} else {
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ' starts with: </b></font>' . $value . '<BR>';
}
}
break;
}
}
}
}
if (count($_REQUEST['cust_begin'])) {
foreach ($_REQUEST['cust_begin'] as $id => $value) {
$field_name = $id;
$id = substr($id, 7);
$column_name = $field_name;
if ($fields[$id][1]['SYSTEM_FIELD'] == 'Y') {
$column_name = strtoupper(str_replace(' ', '_', $fields[$id][1]['TITLE']));
}
if ($fields[$id][1]['TYPE'] == 'numeric') {
$_REQUEST['cust_end'][$field_name] = ereg_replace('[^0-9.-]+', '', $_REQUEST['cust_end'][$field_name]);
$value = ereg_replace('[^0-9.-]+', '', $value);
}
if ($_REQUEST['cust_begin'][$field_name] != '' && $_REQUEST['cust_end'][$field_name] != '') {
if ($fields[$id][1]['TYPE'] == 'numeric' && $_REQUEST['cust_begin'][$field_name] > $_REQUEST['cust_end'][$field_name]) {
$temp = $_REQUEST['cust_end'][$field_name];
$_REQUEST['cust_end'][$field_name] = $value;
$value = $temp;
}
$string .= ' and s.' . $column_name . ' BETWEEN ' . $value . ' AND \'' . $_REQUEST['cust_end'][$field_name] . '\' ';
if ($fields[$id][1]['TYPE'] == 'date') {
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ' between: </b></font>' . ProperDate($value) . ' & ' . ProperDate($_REQUEST['cust_end'][$field_name]) . '<BR>';
} else {
$_openSIS['SearchTerms'] .= '<font color=gray><b>' . $fields[$id][1]['TITLE'] . ' between: </b></font>' . $value . ' & ' . $_REQUEST['cust_end'][$field_name] . '<BR>';
}
}
}
}
break;
}
return $string;
}
echo '</TD></TR>';
}
echo '<TR><TD colspan=2 align=center>';
Buttons('Find', 'Reset');
echo '</TD></TR>';
echo '</TABLE>';
PopTable('footer');
}
if ($_REQUEST[modfunc] == 'list') {
$begin_date = $_REQUEST[day_begin] . '-' . $_REQUEST[month_begin] . '-' . $_REQUEST[year_begin];
$end_date = $_REQUEST[day_end] . '-' . $_REQUEST[month_end] . '-' . $_REQUEST[year_end];
$account_title = DBGet(DBQuery("SELECT TITLE FROM STU_BILLING_ACCOUNTS WHERE ID='{$_REQUEST['account_id']}'"));
if ($account_title[1]) {
$account_title = ' : ' . $account_title[1]['TITLE'];
}
DrawHeader(ucwords(str_replace('stubilling', 'student billing ', str_replace('lunch', 'lunch ', $_REQUEST[type]))) . ' : ' . ProperDate($begin_date) . ' - ' . ProperDate($end_date) . ' : ' . GetSchool($_REQUEST[sch]) . $account_title);
echo '<BR>';
echo '<TABLE>';
switch ($_REQUEST[type]) {
case 'stubillingcredits':
// STUBILLING CREDITS
$sql = "SELECT s.LAST_NAME||', '||s.FIRST_NAME as FULL_NAME,sba.STUDENT_ID,sum(AMOUNT) as AMOUNT FROM STU_BILLING_ACT sba,STUDENTS s ";
if ($_REQUEST[sch]) {
$sql .= ",STU_SCHOOL_MEETS ssm WHERE ssm.SYEAR=sba.SYEAR AND ssm.STUDENT_ID=sba.STUDENT_ID AND ssm.SCHOOL='{$_REQUEST['sch']}' AND s.STUDENT_ID=ssm.STUDENT_ID AND ";
} else {
$sql .= "WHERE ";
}
$sql .= "s.STUDENT_ID=sba.STUDENT_ID AND sba.PAYMENT_DATE BETWEEN '{$begin_date}' AND '{$end_date}' AND (sba.LUNCH_PAYMENT!='Y' OR sba.LUNCH_PAYMENT IS NULL) " . ($_REQUEST[account_id] ? "AND ACCOUNT_ID='{$_REQUEST['account_id']}'" : '') . " GROUP BY sba.STUDENT_ID,FULL_NAME";
break;
case 'stubillingdebits':
// STUBILLING CREDITS
function PrepareDate($date, $title = '', $allow_na = true, $options = '')
{
global $_CENTRE;
if ($options == '') {
$options = array();
}
if (!$options['Y'] && !$options['M'] && !$options['D'] && !$options['C']) {
$options += array('Y' => true, 'M' => true, 'D' => true, 'C' => true);
}
if ($options['short'] == true) {
$extraM = "style='width:65;' ";
}
if ($options['submit'] == true) {
if ($options['C']) {
$e = "onchange='document.location.href=\"" . PreparePHP_SELF($_REQUEST, array('month' . $title, 'day' . $title, 'year' . $title)) . "&month{$title}=\"+this.form.month{$title}.value+\"&day{$title}=\"+this.form.day{$title}.value+\"&year{$title}=\"+this.form.year{$title}.value;'";
$extraM .= $e;
$extraD .= $e;
$extraY .= $e;
} else {
$extraM .= "onchange='document.location.href=\"" . PreparePHP_SELF($_REQUEST, array('month' . $title)) . "&month{$title}=\"+this.form.month{$title}.value;'";
$extraD .= "onchange='document.location.href=\"" . PreparePHP_SELF($_REQUEST, array('day' . $title)) . "&day{$title}=\"+this.form.day{$title}.value;'";
$extraY .= "onchange='document.location.href=\"" . PreparePHP_SELF($_REQUEST, array('year' . $title)) . "&year{$title}=\"+this.form.year{$title}.value;'";
}
}
if ($options['C']) {
$_CENTRE['PrepareDate']++;
}
if (strlen($date) == 9) {
$day = substr($date, 0, 2);
$month = substr($date, 3, 3);
$year = substr($date, 7, 2);
if ($year == '00' && ($month == '000' && $day == '00')) {
$year = '0000';
} else {
$year = ($year < 50 ? '20' : '19') . $year;
}
$return .= '<!-- ' . $year . MonthNWSwitch($month, 'tonum') . $day . ' -->';
} elseif (strlen($date) == 10) {
$day = substr($date, 8, 2);
$month = MonthNWSwitch(substr($date, 5, 2), 'tochar');
$year = substr($date, 0, 4);
$return .= '<!-- ' . $year . MonthNWSwitch($month, 'tonum') . $day . ' -->';
} else {
$day = substr($date, 0, 2);
$month = substr($date, 3, 3);
$year = substr($date, 7, 4);
$return .= '<!-- ' . $year . MonthNWSwitch($month, 'tonum') . $day . ' -->';
}
// MONTH ---------------
if ($options['M']) {
$return .= '<SELECT NAME=month' . $title . ' id=monthSelect' . $_CENTRE['PrepareDate'] . ' SIZE=1 ' . $extraM . '>';
if ($allow_na) {
if ($month == '000') {
$return .= '<OPTION value="" SELECTED>N/A';
} else {
$return .= '<OPTION value="">N/A';
}
}
foreach (array('JAN' => _('January'), 'FEB' => _('February'), 'MAR' => _('March'), 'APR' => _('April'), 'MAY' => _('May'), 'JUN' => _('June'), 'JUL' => _('July'), 'AUG' => _('August'), 'SEP' => _('September'), 'OCT' => _('October'), 'NOV' => _('November'), 'DEC' => _('December')) as $key => $name) {
$return .= '<OPTION VALUE=' . $key . ($month == $key ? ' SELECTED' : '') . '>' . $name;
}
$return .= '</SELECT>';
}
// DAY ---------------
if ($options['D']) {
$return .= '<SELECT NAME=day' . $title . ' id=daySelect' . $_CENTRE['PrepareDate'] . ' SIZE=1 ' . $extraD . '>';
if ($allow_na) {
if ($day == '00') {
$return .= '<OPTION value="" SELECTED>N/A';
} else {
$return .= '<OPTION value="">N/A';
}
}
for ($i = 1; $i <= 31; $i++) {
if (strlen($i) == 1) {
$print = '0' . $i;
} else {
$print = $i;
}
$return .= '<OPTION VALUE=' . $print . ($day == $print ? ' SELECTED' : '') . '>' . $i;
}
$return .= '</SELECT>';
}
// YEAR ---------------
if ($options['Y']) {
if (!$year || $year == '0000') {
$begin = date('Y') - 20;
$end = date('Y') + 5;
} else {
$begin = $year - 5;
$end = $year + 5;
}
$return .= '<SELECT NAME=year' . $title . ' id=yearSelect' . $_CENTRE['PrepareDate'] . ' SIZE=1 ' . $extraY . '>';
if ($allow_na) {
if ($year == '0000') {
$return .= '<OPTION value="" SELECTED>N/A';
} else {
$return .= '<OPTION value="">N/A';
}
}
for ($i = $begin; $i <= $end; $i++) {
$return .= '<OPTION VALUE=' . $i . ($year == $i ? ' SELECTED' : '') . '>' . $i;
}
$return .= '</SELECT>';
}
if ($options['C']) {
$return .= '<img src="assets/jscalendar/img.gif" id="trigger' . $_CENTRE['PrepareDate'] . '" style="cursor: pointer; cursor:hand; border: 1px solid red;" onmouseover=this.style.background="red"; onmouseout=this.style.background=""; />';
}
if ($_REQUEST['_CENTRE_PDF']) {
$return = ProperDate($date);
}
return $return;
}
} else {
echo '<DIV id=user_name><div onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', SelectInput($staff['TITLE'], 'staff[TITLE]', 'Title', array('Mr.' => '' . _('Mr') . '', 'Mrs.' => '' . _('Mrs.') . '', 'Ms.' => '' . _('Ms.') . '', 'Miss' => '' . _('Miss') . '', 'Dr' => '' . _('Dr') . '', 'Rev' => '' . _('Rev')), '', '', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($staff['FIRST_NAME'], 'staff[FIRST_NAME]', (!$staff['FIRST_NAME'] ? '<FONT color=red>' : '') . 'First' . (!$staff['FIRST_NAME'] ? '</FONT>' : ''), 'id=fname size=20 maxlength=50', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($staff['MIDDLE_NAME'], 'staff[MIDDLE_NAME]', 'Middle', 'size=18 maxlength=50', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($staff['LAST_NAME'], 'staff[LAST_NAME]', (!$staff['LAST_NAME'] ? '<FONT color=red>' : '') . 'Last' . (!$staff['LAST_NAME'] ? '</FONT>' : ''), 'id=lname size=20 maxlength=50', false)) . '</TD></TR></TABLE>","user_name",true);\'>' . (!$staff['TITLE'] && !$staff['FIRST_NAME'] && !$staff['MIDDLE_NAME'] && !$staff['LAST_NAME'] ? '-' : $staff['TITLE'] . ' ' . $staff['FIRST_NAME'] . ' ' . $staff['MIDDLE_NAME'] . ' ' . $staff['LAST_NAME']) . '</div></DIV><small>' . (!$staff['FIRST_NAME'] || !$staff['LAST_NAME'] ? '<FONT color=red>' : '<FONT color=' . Preferences('TITLES') . '>') . '</FONT></small>';
}
echo '</td></tr>';
echo '<tr><td>' . _('Email Address') . '</td><td>:</td><td>';
echo TextInput($staff['EMAIL'], 'staff[EMAIL]', '', 'size=25 maxlength=100 id=email class=cell_floating');
echo '</TD></tr>';
echo '<tr><td>' . _('Phone Number') . '</td><td>:</td><td><table cellpadding=0 cellspacing=0><tr><td>';
echo TextInput($staff['PHONE'], 'staff[PHONE]', '', 'size=25 maxlength=100 class=cell_floating');
echo '</td></tr></table></TD>';
if ($_REQUEST['staff_id'] != 'new') {
echo '<TR><TD>';
echo '' . _('Disable User') . '</TD><TD>:</TD><TD>' . CheckboxInput($staff['IS_DISABLE'], 'staff[IS_DISABLE]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>');
echo '</TD></TR>';
echo '<TR><TD>';
echo '' . _('Last Login') . '</TD><TD>:</TD><TD>' . NoInput(ProperDate(substr($staff['LAST_LOGIN'], 0, 10)) . substr($staff['LAST_LOGIN'], 10));
echo '</TD></TR>';
echo '<TR><TD>';
echo '' . _('Staff ID') . '</TD><TD>:</TD><TD>' . NoInput($staff['STAFF_ID']);
echo '</TD></TR>';
}
echo '</TR>';
echo '</table></td>';
echo '<TD>';
$UserPicturesPath = 'assets/UserPhotos/';
$profile = DBGet(DBQuery('SELECT PROFILE FROM staff WHERE STAFF_ID=\'' . UserStaffID() . '\' '));
if ($profile[1]['PROFILE'] != 'parent') {
if ($_REQUEST['staff_id'] != 'new' && $UserPicturesPath && (($file = @fopen($picture_path = $UserPicturesPath . '/' . UserStudentID() . '.JPG', 'r')) || ($file = @fopen($picture_path = $UserPicturesPath . '/' . UserStaffID() . '.JPG', 'r')))) {
fclose($file);
echo '<div width=150 align="center"><IMG SRC="' . $picture_path . '?id=' . rand(6, 100000) . '" width=150 class=pic>';
if (User('PROFILE') == 'admin' && User('PROFILE') != 'student' && User('PROFILE') != 'parent') {
} else {
$num_parent = $num_parent[1]['TOTAL_PARENTS'];
}
echo '<br/>';
echo '<div id="d"><TABLE align=center cellpadding=5 cellspacing=5>';
echo '<tr><td><b>Number of Institutions</b></td><td>:</td><td>  ' . $num_schools . '   </td></tr>';
echo '<tr><td><b>Number of Students</b></td><td>:</td><td>  ' . $num_students . '   </td><td>   Male : ' . $male . '  |  Female : ' . $female . '</td></tr>';
echo '<tr><td><b>Number of Teachers</b></td><td>:</td><td colspan=2>  ' . $num_teacher . '</td></tr>';
echo '<tr><td><b>Number of Staff</b></td><td>:</td><td colspan=2>  ' . $num_staff . '</td></tr>';
echo '<tr><td><b>Number of Parents</b></td><td>:</td><td colspan=2>  ' . $num_parent . '</td></tr>';
echo '</TABLE></div>';
}
if ($_REQUEST['func'] == 'Ins_r') {
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'save') {
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">Institute Reports</td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo "<table >";
$arr = array();
if ($_REQUEST['fields']) {
$i = 0;
foreach ($_REQUEST['fields'] as $field => $on) {
$columns .= $field . ',';
$arr[$field] = $field;
}
$columns = substr($columns, 0, -1);
foreach ($arr as $m => $n) {
// if($m=='SCH_TYPE')
// $arr[$m]='School Type';
// else
// if($m=='SCH_CAT_ID')
// $arr[$m]='School Category';
if (AllowEdit()) {
$description_RET = DBGet(DBQuery("SELECT DISTINCT DESCRIPTION FROM CALENDAR_EVENTS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' AND DESCRIPTION IS NOT NULL ORDER BY DESCRIPTION"));
if (count($description_RET)) {
$description_select = '<OPTION value="">' . _('or select previous meal') . '</OPTION>';
foreach ($description_RET as $description) {
$description_select .= '<OPTION value="' . $description['DESCRIPTION'] . '">' . $description['DESCRIPTION'] . '</OPTION>';
}
$description_select .= '</SELECT>';
}
}
$calendar_RET = DBGet(DBQuery("SELECT to_char(SCHOOL_DATE,'dd-MON-YY') as SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_DATE BETWEEN '" . date('d-M-y', $time) . "' AND '" . date('d-M-y', $time_last) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND CALENDAR_ID='{$calendar_id}' AND MINUTES>0 ORDER BY SCHOOL_DATE"), array(), array('SCHOOL_DATE'));
$events_RET = DBGet(DBQuery("SELECT ID,TITLE,DESCRIPTION,to_char(SCHOOL_DATE,'dd-MON-yy') AS SCHOOL_DATE FROM CALENDAR_EVENTS WHERE SCHOOL_DATE BETWEEN '" . date('d-M-y', $time) . "' AND '" . date('d-M-y', $time_last) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' ORDER BY SCHOOL_DATE"), array('DESCRIPTION' => 'makeDescriptionInput', 'SCHOOL_DATE' => 'ProperDate'));
$events_RET[0] = array();
// make sure indexing from 1
foreach ($calendar_RET as $school_date => $value) {
$events_RET[] = array('ID' => 'new', 'SCHOOL_DATE' => ProperDate($school_date), 'DESCRIPTION' => TextInput('', 'food_service[' . $school_date . '][text]', '', 'size=35') . ($description_select ? '<SELECT name="food_service[' . $school_date . '][select]">' . $description_select : ''));
}
unset($events_RET[0]);
$LO_columns = array('ID' => _('ID'), 'SCHOOL_DATE' => _('Date'), 'DESCRIPTION' => _('Description'));
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&menu_id=' . $_REQUEST['menu_id'] . '&month=' . $_REQUEST['month'] . '&year=' . $_REQUEST['year'] . '" METHOD="POST">';
DrawHeader(PrepareDate(mb_strtoupper(date("d-M-y", $time)), '', false, array('M' => 1, 'Y' => 1, 'submit' => true)), SubmitButton(_('Save'), 'submit[save]') . '<INPUT type="submit" value="' . _('Generate Menu') . '" name="submit[print]" />');
echo '<BR />';
$tabs = array();
foreach ($menus_RET as $id => $meal) {
$tabs[] = array('title' => $meal[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}&month={$_REQUEST['month']}&year={$_REQUEST['year']}");
}
$extra = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}&month={$_REQUEST['month']}&year={$_REQUEST['year']}"));
$singular = sprintf(_('%s Day'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
$plural = sprintf(_('%s Days'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
//modif Francois: add translation
ListOutput($events_RET, $LO_columns, $singular, $plural, array(), array(), $extra);
function reminder($staff, $school, $target, $last_deposit, $note)
{
$payment = $target - $staff['BALANCE'];
if ($payment < 0) {
return;
}
$payment = number_format($payment, 2);
echo '<TABLE width=100%>';
echo '<TR><TD colspan=3 align=center><FONT size=+1><I><B>' . _('Payment Reminder') . '</B></I></FONT></TD></TR>';
echo '<TR><TD colspan=3 align=center><B>' . $school . '</B></TD></TR>';
echo '<TR><TD width=33%>';
echo $staff['FIRST_NAME'] . ' ' . $staff['MIDDLE_NAME'] . ' ' . $staff['LAST_NAME'] . '<BR>';
echo '<small>' . $staff['STAFF_ID'] . '</small>';
echo '</TD><TD width=33%>';
echo ' <BR>';
echo '<small> </small>';
echo '</TD><TD width=33%>';
echo ' <BR>';
echo '<small> </small>';
echo '</TD></TR>';
echo '<TR><TD width=33%>';
echo ProperDate(DBDate()) . '<BR>';
echo '<small>' . _('Today\'s Date') . '</small>';
echo '</TD><TD width=34%>';
echo ($last_deposit ? $last_deposit['DATE'] : _('None')) . '<BR>';
echo '<small>' . _('Date of Last Deposit') . '</small>';
echo '</TD><TD width=33%>';
echo ($last_deposit ? $last_deposit['AMOUNT'] : _('None')) . '<BR>';
echo '<small>' . _('Amount of Last Deposit') . '</small>';
echo '</TD></TR>';
echo '<TR><TD width=33%>';
echo ($staff['BALANCE'] < 0 ? '<B>' . $staff['BALANCE'] . '</B>' : $staff['BALANCE']) . '<BR>';
echo '<small>' . _('Balance') . '</small>';
echo '</TD><TD width=33%>';
echo '<B>' . $payment . '</B><BR>';
echo '<small><B>' . _('Mimimum Payment') . '</B></small>';
echo '</TD><TD width=33%>';
echo ucfirst($staff['PROFILE']) . '<BR>';
echo '<small>' . _('Profile') . '</small>';
echo '</TD></TR>';
$note = str_replace('%F', $staff['FIRST_NAME'], $note);
$note = str_replace('%P', money_format('%i', $payment), $note);
$note = str_replace('%T', $target, $note);
echo '<TR><TD colspan=3>';
echo '<BR>' . $note . '<BR>';
echo '</TD></TR>';
echo '<TR><TD colspan=3><BR><BR><HR><BR><BR></TD></TR></TABLE>';
}
$QI = DBQuery("SELECT PERIOD_ID,TITLE FROM SCHOOL_PERIODS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER ");
$periods_RET = DBGet($QI);
$period_select = '<SELECT name="period"><OPTION value="">' . _('All') . '</OPTION>';
foreach ($periods_RET as $period) {
$period_select .= '<OPTION value="' . $period[PERIOD_ID] . '"' . ($_REQUEST['period'] == $period['PERIOD_ID'] ? ' SELECTED="SELECTED"' : '') . ">" . $period['TITLE'] . '</OPTION>';
}
$period_select .= '</SELECT>';
DrawHeader(ProgramTitle());
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">';
$begin_year = DBGet(DBQuery("SELECT min(date_part('epoch',SCHOOL_DATE)) as SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
$begin_year = $begin_year[1]['SCHOOL_DATE'];
if ($start && $begin_year) {
//modif: days display to locale
$date_select = '<OPTION value="' . $start . '">' . ProperDate(date('Y.m.d', $start)) . ' - ' . ProperDate(date('Y.m.d', $end)) . '</OPTION>';
for ($i = $start - 60 * 60 * 24 * 7; $i >= $begin_year; $i -= 60 * 60 * 24 * 7) {
$date_select .= '<OPTION value="' . $i . '"' . ($i + 86400 >= $start_time && $i - 86400 <= $start_time ? ' SELECTED="SELECTED"' : '') . '>' . ProperDate(date('Y.m.d', $i)) . ' - ' . ProperDate(date('Y.m.d', $i + 1 + ($END_DAY - $START_DAY) * 60 * 60 * 24)) . '</OPTION>';
}
}
DrawHeader(_('Timeframe') . ': <SELECT name="start_date">' . $date_select . '</SELECT> - ' . _('Period') . ': ' . $period_select, SubmitButton(_('Go')));
echo '</FORM>';
//modif Francois: multiple school periods for a course period
/*$sql = "SELECT s.LAST_NAME||', '||s.FIRST_NAME AS FULL_NAME,sp.TITLE,cp.PERIOD_ID,s.STAFF_ID
FROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp
WHERE
sp.PERIOD_ID = cp.PERIOD_ID
AND cp.TEACHER_ID=s.STAFF_ID AND cp.MARKING_PERIOD_ID IN (".GetAllMP('QTR',UserMP()).")
AND cp.SYEAR='".UserSyear()."' AND cp.SCHOOL_ID='".UserSchool()."' AND s.PROFILE='teacher'
".(($_REQUEST['period'])?" AND cp.PERIOD_ID='$_REQUEST[period]'":'')."
AND NOT EXISTS (SELECT '' FROM ELIGIBILITY_COMPLETED ac WHERE ac.STAFF_ID=cp.TEACHER_ID AND ac.PERIOD_ID = sp.PERIOD_ID AND ac.SCHOOL_DATE BETWEEN '$start_date' AND '$end_date')
";*/
$sql = "SELECT s.LAST_NAME||', '||s.FIRST_NAME AS FULL_NAME,sp.TITLE,cpsp.PERIOD_ID,s.STAFF_ID \n\t\tFROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp,COURSE_PERIOD_SCHOOL_PERIODS cpsp \n\t\tWHERE \n\t\t\tcp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID AND \n\t\t\tsp.PERIOD_ID = cpsp.PERIOD_ID\n\t\t\tAND cp.TEACHER_ID=s.STAFF_ID AND cp.MARKING_PERIOD_ID IN (" . GetAllMP('QTR', UserMP()) . ")\n\t\t\tAND cp.SYEAR='" . UserSyear() . "' AND cp.SCHOOL_ID='" . UserSchool() . "' AND s.PROFILE='teacher'\n\t\t\t" . ($_REQUEST['period'] ? " AND cpsp.PERIOD_ID='{$_REQUEST['period']}'" : '') . "\n\t\t\tAND NOT EXISTS (SELECT '' FROM ELIGIBILITY_COMPLETED ac WHERE ac.STAFF_ID=cp.TEACHER_ID AND ac.PERIOD_ID = sp.PERIOD_ID AND ac.SCHOOL_DATE BETWEEN '{$start_date}' AND '{$end_date}')\n\t\t";
echo '</td></tr>';
echo '</table>';
echo '</td></TR>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Access Information</b></td></tr><tr><td colspan="2">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Username</td><td>:</td><td>';
echo TextInput($student['USERNAME'], 'students[USERNAME]', '', 'class=cell_medium onkeyup="usercheck_init_student(this)"');
echo '<span id="ajax_output_st"></span>';
echo '</td></tr>';
echo '<tr><td>Password</td><td>:</td><td>';
echo TextInput(array($student['PASSWORD'], str_repeat('*', strlen($student['PASSWORD']))), 'students[PASSWORD]', '', 'class=cell_medium onkeyup=passwordStrength(this.value)', 'AUTOCOMPLETE = off');
echo '<div id="passwordStrength" style=display:none></div>';
echo '</td></tr>';
if ($_REQUEST['student_id'] != 'new') {
echo '<tr><td>Last Login</td><td>:</td><td>';
echo NoInput(ProperDate(substr($student['LAST_LOGIN'], 0, 10)) . substr($student['LAST_LOGIN'], 10), '');
echo '</td></tr>';
}
echo '</table>';
//jc
if (User('PROFILE') == 'admin') {
echo '<TABLE border=0>';
echo '<TR><td height="30px" ><b>Manage Student</b></td></tr><tr><td colspan="2">';
echo '<tr><td>Select to Delete Student</td><td>:</td><td>';
echo CheckboxInput($student['IS_DISABLE'], 'students[IS_DISABLE]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>');
echo '</td></tr>';
echo '<tr><td>';
echo "please only delete inactive student";
echo '</td></tr>';
echo '</table>';
}
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#**************************************************************************
if (!UserSyear()) {
$_SESSION['UserSyear'] = $DefaultSyear;
}
while (!UserSyear()) {
session_write_close();
session_start();
}
#DrawHeader(Config('TITLE'),'Centre v'.$CentreVersion);
$current_hour = date('H');
#DrawHeader('<FONT SIZE=+1>Good '.($current_hour<12?'Morning':($current_hour<18?'Afternoon':'Evening')).', '.User('NAME').'!</FONT>');
if ($_SESSION['LAST_LOGIN']) {
$welcome .= 'User: '******'NAME') . ' | Last login: '******'LAST_LOGIN'], 0, 10)) . ' at ' . substr($_SESSION['LAST_LOGIN'], 10);
}
if ($_REQUEST['failed_login']) {
$welcome .= ' | <span class=red >' . $_REQUEST['failed_login'] . '</b> failed login attempts</span>';
}
switch (User('PROFILE')) {
case 'admin':
DrawBC($welcome . ' | Role: Administrator');
$notes_RET = DBGet(DBQuery("SELECT s.TITLE AS SCHOOL,pn.PUBLISHED_DATE,CONCAT('<B>',pn.TITLE,'</B>') AS TITLE,pn.CONTENT FROM PORTAL_NOTES pn,SCHOOLS s,STAFF st WHERE pn.SYEAR='" . UserSyear() . "' AND pn.START_DATE<=CURRENT_DATE AND (pn.END_DATE>=CURRENT_DATE OR pn.END_DATE IS NULL) AND st.STAFF_ID='" . User('STAFF_ID') . "' AND (st.SCHOOLS IS NULL OR FIND_IN_SET(pn.SCHOOL_ID,st.SCHOOLS)>0) AND (st.PROFILE_ID IS NULL AND FIND_IN_SET('admin', pn.PUBLISHED_PROFILES)>0 OR st.PROFILE_ID IS NOT NULL AND FIND_IN_SET(st.PROFILE_ID,pn.PUBLISHED_PROFILES)>0) AND s.ID=pn.SCHOOL_ID ORDER BY pn.SORT_ORDER,pn.PUBLISHED_DATE DESC"), array('PUBLISHED_DATE' => 'ProperDate', 'CONTENT' => '_nl2br'));
if (count($notes_RET)) {
echo '<div>';
ListOutput($notes_RET, array('PUBLISHED_DATE' => 'Date Posted', 'TITLE' => 'Title', 'CONTENT' => 'Note', 'SCHOOL' => 'School'), 'Note', 'Notes', array(), array(), array('save' => false, 'search' => false));
echo '</div>';
}
$events_RET = DBGet(DBQuery("SELECT ce.TITLE,ce.DESCRIPTION,ce.SCHOOL_DATE,s.TITLE AS SCHOOL FROM CALENDAR_EVENTS ce,SCHOOLS s,STAFF st WHERE ce.SCHOOL_DATE BETWEEN CURRENT_DATE AND CURRENT_DATE+30 AND ce.SYEAR='" . UserSyear() . "' AND st.STAFF_ID='" . User('STAFF_ID') . "' AND (st.SCHOOLS IS NULL OR FIND_IN_SET(ce.SCHOOL_ID,st.SCHOOLS)>0) AND s.ID=ce.SCHOOL_ID ORDER BY ce.SCHOOL_DATE,s.TITLE"), array('SCHOOL_DATE' => 'ProperDate'));
if (count($events_RET)) {
function PrintCatalog($result, $column_names, $singular = '', $plural = '', $link = false, $group = false, $options = false)
{
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($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 = 'bgcolor="#f5f5f5"';
if ($group_count && $result_count) {
$color = 'style=" background-color:#fff; padding:3px 4px 3px 4px;"';
$group_result = $result;
unset($result);
$result[0] = '';
foreach ($group_result as $item1) {
if ($group_count == 1) {
if ($color == 'bgcolor="#f5f5f5"') {
$color = $side_color;
} else {
$color = 'bgcolor="#f5f5f5"';
}
}
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 == 'bgcolor="#ffffff"') {
$color = $side_color;
} else {
$color = 'bgcolor="#ffffff"';
}
}
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 == 'bgcolor="#ffffff"') {
$color = $side_color;
} else {
$color = 'bgcolor="#ffffff"';
}
}
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']) {
foreach ($result 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 ($result_count > 1) {
if (is_int($sort_array[1]) || is_double($sort_array[1])) {
array_multisort($sort_array, $dir, SORT_NUMERIC, $result);
} else {
array_multisort($sort_array, $dir, $result);
}
for ($i = $result_count - 1; $i >= 0; $i--) {
$result[$i + 1] = $result[$i];
}
unset($result[0]);
}
}
}
// 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=1 cellspacing=0 ><tr><td ></td><td ><b>No {$plural} were found.</b></td></tr><tr><td colspan=2 ></td></tr></table></div>";
} elseif ($result_count == 0 || $display_count == 0) {
echo '<div style=text-align:left><table cellpadding=1 cellspacing=0 ><tr><td ></td><td ><b>None were found.</b></td></tr><tr><td colspan=2></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) {
$where_message = "<SMALL>Displaying {$start} through {$stop}</SMALL>";
echo "" . _('Go to Page') . " ";
if (ceil($result_count / $num_displayed) <= 10) {
for ($i = 1; $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) . "<BR>";
} 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>';
echo '<BR>';
}
} else {
$start = 1;
$stop = $result_count;
if ($cols > 8 || $_REQUEST['expanded_view']) {
$_SESSION['orientation'] = 'landscape';
$repeat_headers = 16;
} else {
$repeat_headers = 26;
}
if ($options['print']) {
$html = explode('', 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=1 style="border-collapse:collapse" >';
//echo "<TR><TD align=left valign=middle>";
//if($singular && $plural && $options['count'])
//{
/*f($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']) {
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['LO_search']);
unset($tmp_REQUEST['page']);
echo '<TD height="50" align=right valign=middle>';
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 '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>';
}
echo "<TABLE cellpadding=6 width=100% cellspacing=1 border=\"1px solid #a9d5e9 \" style=\"border-collapse:collapse\" 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']) {
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 = 'bgcolor="#ffffff"';
//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 == 'bgcolor="#ffffff"') {
$color = $side_color;
} else {
$color = 'bgcolor="#ffffff"';
}
//$color = '#EDF3FE';
if (isset($_REQUEST['_openSIS_PDF']) && $count % $repeat_headers == 0) {
if ($count != 0) {
echo '</TABLE>';
echo "<div style=\"page-break-after: always;\"></div>";
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Student Advanced Report') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />" . _('Powered by openSIS') . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo '<TABLE cellpadding=6 width=100% cellspacing=1 border="1px solid #a9d5e9 " style="border-collapse:collapse" align=center>';
}
echo "<TR>";
if ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
echo "<TD bgcolor=#d3d3d3></TD>";
}
if ($cols) {
foreach ($column_names as $key => $value) {
echo "<TD bgcolor=#d3d3d3 >" . 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'];
$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 ($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 = 'bgcolor=#ffffff';
} else {
$color = $side_color;
}
echo "<TR {$color}>";
if ($remove && !isset($_REQUEST['_openSIS_PDF']) && $link['add']['html']['remove']) {
echo "<TD bgcolor=#ffffff align=left>" . $link['add']['html']['remove'] . "</TD>";
} elseif ($remove && !isset($_REQUEST['_openSIS_PDF'])) {
echo "<TD bgcolor=#ffffff align=left >" . button('add') . "</TD>";
}
foreach ($column_names as $key => $value) {
echo "<TD bgcolor=#ffffff 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>";
if (!isset($_REQUEST['_openSIS_PDF'])) {
echo '</TD ></TR></TABLE>';
}
echo "</TD ></TR>";
echo "</TABLE>";
if ($options['center']) {
echo '';
}
}
}
if ($result_count == 0) {
if ($result_count > $num_displayed || ($options['count'] || $display_zero) && (($result_count == 0 || $display_count == 0) && $plural || ($result_count == 0 || $display_count == 0))) {
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 '<TABLE width=100% cellpadding=0 cellspacing=0><TR><TD align=center>';
}
if ($link['add']['html']) {
echo "<TABLE cellpadding=6 cellspacing=1 width=96% class=\"grid\"><TR><TD class=subtabs></TD>";
foreach ($column_names as $key => $value) {
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>";
}
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 '<div style="page-break-before: inherit;"> </div>';
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 Widgets($item, &$myextra = null)
{
global $extra, $_ROSARIO, $RosarioModules;
if (isset($myextra)) {
$extra =& $myextra;
}
if (!is_array($_ROSARIO['Widgets'])) {
$_ROSARIO['Widgets'] = array();
}
if (!is_array($extra['functions'])) {
$extra['functions'] = array();
}
if ((User('PROFILE') == 'admin' || User('PROFILE') == 'teacher') && !$_ROSARIO['Widgets'][$item]) {
switch ($item) {
case 'all':
$extra['search'] .= '<TR><TD colspan="2"><TABLE class="width-100p cellpadding-2" style="border-collapse:separate; border-spacing: 2px">';
if ($RosarioModules['Students'] && (!$_ROSARIO['Widgets']['calendar'] || !$_ROSARIO['Widgets']['next_year'] || !$_ROSARIO['Widgets']['enrolled'] || !$_ROSARIO['Widgets']['rolled'])) {
//modif Francois: css WPadmin
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'enrollment_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="enrollment_table_arrow" height="12"> <B>' . _('Enrollment') . '</B></A><BR /><TABLE id="enrollment_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('calendar', $extra);
Widgets('next_year', $extra);
Widgets('enrolled', $extra);
Widgets('rolled', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Scheduling'] && (!$_ROSARIO['Widgets']['course'] || !$_ROSARIO['Widgets']['request']) && User('PROFILE') == 'admin') {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'scheduling_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="scheduling_table_arrow" height="12"> <B>' . _('Scheduling') . '</B></A><BR /><TABLE id="scheduling_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('course', $extra);
//Widgets('request',$extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Attendance'] && !$_ROSARIO['Widgets']['absences']) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'absences_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="absences_table_arrow" height="12"> <B>' . _('Attendance') . '</B></A><BR /><TABLE id="absences_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('absences', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Grades'] && (!$_ROSARIO['Widgets']['gpa'] || !$_ROSARIO['Widgets']['class_rank'] || !$_ROSARIO['Widgets']['letter_grade'])) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'grades_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="grades_table_arrow" height="12"> <B>' . _('Grades') . '</B></A><BR /><TABLE style="padding:5px;" id="grades_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('gpa', $extra);
Widgets('class_rank', $extra);
Widgets('letter_grade', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Eligibility'] && (!$_ROSARIO['Widgets']['eligibility'] || !$_ROSARIO['Widgets']['activity'])) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'eligibility_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="eligibility_table_arrow" height="12"> <B>' . _('Eligibility') . '</B></A><BR /><TABLE id="eligibility_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('eligibility', $extra);
Widgets('activity', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Food_Service'] && (!$_ROSARIO['Widgets']['fsa_balance'] || !$_ROSARIO['Widgets']['fsa_discount'] || !$_ROSARIO['Widgets']['fsa_status'] || !$_ROSARIO['Widgets']['fsa_barcode'])) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'food_service_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="food_service_table_arrow" height="12"> <B>' . _('Food Service') . '</B></A><BR /><TABLE id="food_service_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('fsa_balance', $extra);
Widgets('fsa_discount', $extra);
Widgets('fsa_status', $extra);
Widgets('fsa_barcode', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Discipline'] && !$_ROSARIO['Widgets']['discipline']) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'discipline_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="discipline_table_arrow" height="12"> <B>' . _('Discipline') . '</B></A><BR /><TABLE id="discipline_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('discipline', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Student_Billing'] && !$_ROSARIO['Widgets']['balance']) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'billing_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="billing_table_arrow" height="12"> <B>' . _('Student Billing') . '</B></A><BR /><TABLE id="billing_table" style="display:none;" class="widefat width-100p cellspacing-0">';
Widgets('balance', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
$extra['search'] .= '</TABLE></TD></TR>';
break;
case 'user':
$widgets_RET = DBGet(DBQuery("SELECT TITLE FROM PROGRAM_USER_CONFIG WHERE USER_ID='" . User('STAFF_ID') . "' AND PROGRAM='WidgetsSearch'" . (count($_ROSARIO['Widgets']) ? " AND TITLE NOT IN ('" . implode("','", array_keys($_ROSARIO['Widgets'])) . "')" : '')));
foreach ($widgets_RET as $widget) {
Widgets($widget['TITLE'], $extra);
}
break;
case 'course':
if ($RosarioModules['Scheduling'] && User('PROFILE') == 'admin') {
if ($_REQUEST['w_course_period_id']) {
if ($_REQUEST['w_course_period_id_which'] == 'course') {
$course = DBGet(DBQuery("SELECT c.TITLE AS COURSE_TITLE,cp.TITLE,cp.COURSE_ID FROM COURSE_PERIODS cp,COURSES c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "'"));
$extra['FROM'] .= ",SCHEDULE w_ss";
$extra['WHERE'] .= " AND w_ss.STUDENT_ID=s.STUDENT_ID AND w_ss.SYEAR=ssm.SYEAR AND w_ss.SCHOOL_ID=ssm.SCHOOL_ID AND w_ss.COURSE_ID='" . $course[1]['COURSE_ID'] . "' AND ('" . DBDate() . "' BETWEEN w_ss.START_DATE AND w_ss.END_DATE OR w_ss.END_DATE IS NULL)";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Course')) . ' </b>' . $course[1]['COURSE_TITLE'] . '<BR />';
}
} else {
$extra['FROM'] .= ",SCHEDULE w_ss";
$extra['WHERE'] .= " AND w_ss.STUDENT_ID=s.STUDENT_ID AND w_ss.SYEAR=ssm.SYEAR AND w_ss.SCHOOL_ID=ssm.SCHOOL_ID AND w_ss.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "' AND ('" . DBDate() . "' BETWEEN w_ss.START_DATE AND w_ss.END_DATE OR w_ss.END_DATE IS NULL)";
$course = DBGet(DBQuery("SELECT c.TITLE AS COURSE_TITLE,cp.TITLE,cp.COURSE_ID FROM COURSE_PERIODS cp,COURSES c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "'"));
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Course Period')) . ' </b>' . $course[1]['COURSE_TITLE'] . ': ' . $course[1]['TITLE'] . '<BR />';
}
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Course') . "</TD><TD><DIV id=course_div></DIV> <A HREF=# onclick='window.open(\"Modules.php?modname=misc/ChooseCourse.php\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'>" . _('Choose') . '</A></TD></TR>';
}
break;
case 'request':
if ($RosarioModules['Scheduling'] && User('PROFILE') == 'admin') {
// PART OF THIS IS DUPLICATED IN PrintRequests.php
if ($_REQUEST['request_course_id']) {
$course = DBGet(DBQuery("SELECT c.TITLE FROM COURSES c WHERE c.COURSE_ID='" . $_REQUEST['request_course_id'] . "'"));
if (!$_REQUEST['not_request_course']) {
$extra['FROM'] .= ",SCHEDULE_REQUESTS sr";
$extra['WHERE'] .= " AND sr.STUDENT_ID=s.STUDENT_ID AND sr.SYEAR=ssm.SYEAR AND sr.SCHOOL_ID=ssm.SCHOOL_ID AND sr.COURSE_ID='" . $_REQUEST['request_course_id'] . "' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Request')) . ' </b>' . $course[1]['TITLE'] . '<BR />';
}
} else {
$extra['WHERE'] .= " AND NOT EXISTS (SELECT '' FROM SCHEDULE_REQUESTS sr WHERE sr.STUDENT_ID=ssm.STUDENT_ID AND sr.SYEAR=ssm.SYEAR AND sr.COURSE_ID='" . $_REQUEST['request_course_id'] . "' ) ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Missing Request')) . ' </b>' . $course[1]['TITLE'] . '<BR />';
}
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px">' . _('Request') . '</TD><TD><DIV id="request_div"></DIV> <A HREF="#" onclick=\'window.open("Modules.php?modname=misc/ChooseRequest.php","","scrollbars=yes,resizable=yes,width=800,height=400");\'>' . _('Choose') . '</A></TD></TR>';
}
break;
case 'absences':
if ($RosarioModules['Attendance']) {
if (is_numeric($_REQUEST['absences_low']) && is_numeric($_REQUEST['absences_high'])) {
if ($_REQUEST['absences_low'] > $_REQUEST['absences_high']) {
$temp = $_REQUEST['absences_high'];
$_REQUEST['absences_high'] = $_REQUEST['absences_low'];
$_REQUEST['absences_low'] = $temp;
}
if ($_REQUEST['absences_low'] == $_REQUEST['absences_high']) {
$extra['WHERE'] .= " AND (SELECT sum(1-STATE_VALUE) AS STATE_VALUE FROM ATTENDANCE_DAY ad WHERE ssm.STUDENT_ID=ad.STUDENT_ID AND ad.SYEAR=ssm.SYEAR AND ad.MARKING_PERIOD_ID IN (" . GetChildrenMP($_REQUEST['absences_term'], UserMP()) . ")) = '{$_REQUEST['absences_low']}'";
} else {
$extra['WHERE'] .= " AND (SELECT sum(1-STATE_VALUE) AS STATE_VALUE FROM ATTENDANCE_DAY ad WHERE ssm.STUDENT_ID=ad.STUDENT_ID AND ad.SYEAR=ssm.SYEAR AND ad.MARKING_PERIOD_ID IN (" . GetChildrenMP($_REQUEST['absences_term'], UserMP()) . ")) BETWEEN '{$_REQUEST['absences_low']}' AND '{$_REQUEST['absences_high']}'";
}
switch ($_REQUEST['absences_term']) {
case 'FY':
$term = _('this school year to date');
break;
case 'SEM':
$term = _('this semester to date');
break;
case 'QTR':
$term = _('this marking period to date');
break;
}
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Days Absent') . ' ' . $term . ' ' . _('Between') . ' </b>' . $_REQUEST['absences_low'] . ' & ' . $_REQUEST['absences_high'] . '<BR />';
}
}
//modif Francois: add <label> on radio
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Days Absent') . '<BR /><label><INPUT type="radio" name="absences_term" value="FY" checked /> ' . _('YTD') . '</label> <label><INPUT type="radio" name="absences_term" value="SEM"> ' . GetMP(GetParentMP('SEM', UserMP()), 'SHORT_NAME') . '</label> <label><INPUT type="radio" name="absences_term" value="QTR"> ' . GetMP(UserMP(), 'SHORT_NAME') . '</label></TD><TD>' . _('Between') . ' <INPUT type="text" name="absences_low" size="3" maxlength="5"> & <INPUT type="text" name="absences_high" size="3" maxlength="5"></TD></TR>';
}
break;
case 'gpa':
if ($RosarioModules['Grades']) {
if (is_numeric($_REQUEST['gpa_low']) && is_numeric($_REQUEST['gpa_high'])) {
if ($_REQUEST['gpa_low'] > $_REQUEST['gpa_high']) {
$temp = $_REQUEST['gpa_high'];
$_REQUEST['gpa_high'] = $_REQUEST['gpa_low'];
$_REQUEST['gpa_low'] = $temp;
}
if ($_REQUEST['list_gpa']) {
//modif Francois: remove STUDENT_GPA_CALCULATED table
/*$extra['SELECT'] .= ',sgc.WEIGHTED_GPA,sgc.UNWEIGHTED_GPA';
$extra['columns_after']['WEIGHTED_GPA'] = _('Weighted GPA');
$extra['columns_after']['UNWEIGHTED_GPA'] = _('Unweighted GPA');*/
$extra['SELECT'] .= ',sms.CUM_WEIGHTED_FACTOR,sms.CUM_UNWEIGHTED_FACTOR';
$extra['columns_after']['CUM_WEIGHTED_FACTOR'] = _('Weighted GPA');
$extra['columns_after']['CUM_UNWEIGHTED_FACTOR'] = _('Unweighted GPA');
}
/*if(mb_strpos($extra['FROM'],'STUDENT_GPA_CALCULATED sgc')===false)
{
$extra['FROM'] .= ",STUDENT_GPA_CALCULATED sgc";
$extra['WHERE'] .= " AND sgc.STUDENT_ID=s.STUDENT_ID AND sgc.MARKING_PERIOD_ID='".$_REQUEST['gpa_term']."'";
}*/
if (mb_strpos($extra['FROM'], 'STUDENT_MP_STATS sms') === false) {
$extra['FROM'] .= ",STUDENT_MP_STATS sms";
$extra['WHERE'] .= " AND sms.STUDENT_ID=s.STUDENT_ID AND sms.MARKING_PERIOD_ID='" . $_REQUEST['gpa_term'] . "'";
}
//$extra['WHERE'] .= " AND sgc.".(($_REQUEST['weighted']=='Y')?'WEIGHTED_':'')."GPA BETWEEN '$_REQUEST[gpa_low]' AND '$_REQUEST[gpa_high]' AND sgc.MARKING_PERIOD_ID='".$_REQUEST['gpa_term']."'";
$extra['WHERE'] .= " AND sms.CUM_" . ($_REQUEST['weighted'] == 'Y' ? '' : 'UN') . "WEIGHTED_FACTOR*(SELECT GP_SCALE FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "') BETWEEN '{$_REQUEST['gpa_low']}' AND '{$_REQUEST['gpa_high']}'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . ($_REQUEST['gpa_weighted'] == 'Y' ? _('Weighted GPA') . ' ' : _('Unweighted GPA') . ' ') . Localize('colon', _('Between')) . ' </b>' . $_REQUEST['gpa_low'] . ' & ' . $_REQUEST['gpa_high'] . '<BR />';
}
}
//modif Francois: add <label> on checkbox
//modif Francois: replace Cumulative by Full Year
//$extra['search'] .= "<TR><TD style="text-align:right; width:120px:">"._('GPA')."<BR /><label><INPUT type=checkbox name=gpa_weighted value=Y> "._('Weighted').'</label><BR /><label><INPUT type="radio" name="gpa_term" value=CUM checked /> '._('Cumulative').'</label> <label><INPUT type="radio" name="gpa_term" value="'.GetParentMP('SEM',UserMP()).'"> '.GetMP(GetParentMP('SEM',UserMP()),'SHORT_NAME').'</label> <label><INPUT type="radio" name="gpa_term" value="'.UserMP().'"> '.GetMP(UserMP(),'SHORT_NAME')."</label></TD><TD>"._('Between')." <INPUT type="text" name=gpa_low size=3 maxlength=5> & <INPUT type="text" name=gpa_high size=3 maxlength=5></TD></TR>";
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('GPA') . '<BR /><label><INPUT type="checkbox" name="weighted" value="Y"> ' . _('Weighted') . '</label><BR />' . (GetMP($MPfy = GetParentMP('FY', GetParentMP('SEM', UserMP())), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="gpa_term" value="' . $MPfy . '" checked /> ' . GetMP($MPfy, 'SHORT_NAME') . '</label> ' : '') . (GetMP($MPsem = GetParentMP('SEM', UserMP()), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="gpa_term" value="' . $MPsem . '"> ' . GetMP($MPsem, 'SHORT_NAME') . '</label> ' : '') . (GetMP($MPtrim = UserMP(), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="gpa_term" value="' . $MPtrim . '" checked /> ' . GetMP($MPtrim, 'SHORT_NAME') . '</label>' : '') . '</TD><TD>' . _('Between') . ' <INPUT type="text" name="gpa_low" size="3" maxlength="5"> & <INPUT type="text" name="gpa_high" size="3" maxlength="5"></TD></TR>';
}
break;
case 'class_rank':
if ($RosarioModules['Grades']) {
if (is_numeric($_REQUEST['class_rank_low']) && is_numeric($_REQUEST['class_rank_high'])) {
if ($_REQUEST['class_rank_low'] > $_REQUEST['class_rank_high']) {
$temp = $_REQUEST['class_rank_high'];
$_REQUEST['class_rank_high'] = $_REQUEST['class_rank_low'];
$_REQUEST['class_rank_low'] = $temp;
}
//modif Francois: remove STUDENT_GPA_CALCULATED table
/*if(mb_strpos($extra['FROM'],'STUDENT_GPA_CALCULATED sgc')===false)
{
$extra['FROM'] .= ",STUDENT_GPA_CALCULATED sgc";
$extra['WHERE'] .= " AND sgc.STUDENT_ID=s.STUDENT_ID AND sgc.MARKING_PERIOD_ID='".$_REQUEST['class_rank_term']."'";
}*/
if (mb_strpos($extra['FROM'], 'STUDENT_MP_STATS sms') === false) {
$extra['FROM'] .= ",STUDENT_MP_STATS sms";
$extra['WHERE'] .= " AND sms.STUDENT_ID=s.STUDENT_ID AND sms.MARKING_PERIOD_ID='" . $_REQUEST['class_rank_term'] . "'";
}
//$extra['WHERE'] .= " AND sgc.CLASS_RANK BETWEEN '$_REQUEST[class_rank_low]' AND '$_REQUEST[class_rank_high]'";
$extra['WHERE'] .= " AND sms.CUM_RANK BETWEEN '{$_REQUEST['class_rank_low']}' AND '{$_REQUEST['class_rank_high']}'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Class Rank')) . ' ' . _('Between') . '</b>' . $_REQUEST['class_rank_low'] . ' & ' . $_REQUEST['class_rank_high'] . '<BR />';
}
}
//modif Francois: replace Cumulative by Full Year
//$extra['search'] .= "<TR><TD style="text-align:right; width:120px:">"._('Class Rank').'<BR /><label><INPUT type="radio" name="class_rank_term" value=CUM checked /> '._('Cumulative').'</label> <label><INPUT type="radio" name="class_rank_term" value="'.GetParentMP('SEM',UserMP()).'"> '.GetMP(GetParentMP('SEM',UserMP()),'SHORT_NAME').'</label> <label><INPUT type="radio" name="class_rank_term" value="'.UserMP().'"> '.GetMP(UserMP(),'SHORT_NAME');
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Class Rank') . '<BR />' . (GetMP($MPfy = GetParentMP('FY', GetParentMP('SEM', UserMP())), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="class_rank_term" value="' . $MPfy . '"> ' . GetMP($MPfy, 'SHORT_NAME') . '</label> ' : '') . (GetMP($MPsem = GetParentMP('SEM', UserMP()), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="class_rank_term" value="' . $MPsem . '"> ' . GetMP($MPsem, 'SHORT_NAME') . '</label> ' : '') . (GetMP($MPtrim = UserMP(), 'DOES_GRADES') == 'Y' ? '<label><INPUT type="radio" name="class_rank_term" value="' . $MPtrim . '" checked /> ' . GetMP($MPtrim, 'SHORT_NAME') . '</label>' : '');
if (mb_strlen($pros = GetChildrenMP('PRO', UserMP()))) {
$pros = explode(',', str_replace("'", '', $pros));
foreach ($pros as $pro) {
$extra['search'] .= '<label><INPUT type="radio" name="class_rank_term" value="' . $pro . '"> ' . GetMP($pro, 'SHORT_NAME') . '</label> ';
}
}
$extra['search'] .= '</TD><TD>' . _('Between') . ' <INPUT type="text" name="class_rank_low" size="3" maxlength="5"> & <INPUT type="text" name="class_rank_high" size="3" maxlength="5"></TD></TR>';
}
break;
case 'letter_grade':
if ($RosarioModules['Grades']) {
if (count($_REQUEST['letter_grade'])) {
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . ($_REQUEST['letter_grade_exclude'] == 'Y' ? _('Without') : _('With')) . ' ' . _('Report Card Grade') . ': </b>';
}
$letter_grades_RET = DBGet(DBQuery("SELECT ID,TITLE FROM REPORT_CARD_GRADES WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"), array(), array('ID'));
foreach ($_REQUEST['letter_grade'] as $grade => $Y) {
$letter_grades .= ",'{$grade}'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= $letter_grades_RET[$grade][1]['TITLE'] . ', ';
}
}
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] = mb_substr($_ROSARIO['SearchTerms'], 0, -2) . '<BR />';
}
$extra['WHERE'] .= " AND " . ($_REQUEST['letter_grade_exclude'] == 'Y' ? 'NOT ' : '') . "EXISTS (SELECT '' FROM STUDENT_REPORT_CARD_GRADES sg3 WHERE sg3.STUDENT_ID=ssm.STUDENT_ID AND sg3.SYEAR=ssm.SYEAR AND sg3.REPORT_CARD_GRADE_ID IN (" . mb_substr($letter_grades, 1) . ") AND sg3.MARKING_PERIOD_ID='" . $_REQUEST['letter_grade_term'] . "' )";
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Grade') . '<BR /><label><INPUT type="checkbox" name="letter_grade_exclude" value="Y"> ' . _('Did not receive') . '</label><BR /><label><INPUT type="radio" name="letter_grade_term" value="' . GetParentMP('SEM', UserMP()) . '"> ' . GetMP(GetParentMP('SEM', UserMP()), 'SHORT_NAME') . '</label> <label><INPUT type="radio" name="letter_grade_term" value="' . UserMP() . '"> ' . GetMP(UserMP(), 'SHORT_NAME') . '</label>';
if (mb_strlen($pros = GetChildrenMP('PRO', UserMP()))) {
$pros = explode(',', str_replace("'", '', $pros));
foreach ($pros as $pro) {
$extra['search'] .= '<label><INPUT type="radio" name="letter_grade_term" value="' . $pro . '"> ' . GetMP($pro, 'SHORT_NAME') . '</label> ';
}
}
$extra['search'] .= "</TD><TD>";
//modif Francois: fix error Invalid argument supplied for foreach()
if ($_REQUEST['search_modfunc'] == 'search_fnc' || !$_REQUEST['search_modfunc']) {
$letter_grades_RET = DBGet(DBQuery("SELECT rg.ID,rg.TITLE,rg.GRADE_SCALE_ID FROM REPORT_CARD_GRADES rg,REPORT_CARD_GRADE_SCALES rs WHERE rg.SCHOOL_ID='" . UserSchool() . "' AND rg.SYEAR='" . UserSyear() . "' AND rs.ID=rg.GRADE_SCALE_ID" . (User('PROFILE') == 'teacher' ? ' AND rg.GRADE_SCALE_ID=(SELECT GRADE_SCALE_ID FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID=\'' . UserCoursePeriod() . '\')' : '') . " ORDER BY rs.SORT_ORDER,rs.ID,rg.BREAK_OFF IS NOT NULL DESC,rg.BREAK_OFF DESC,rg.SORT_ORDER"), array(), array('GRADE_SCALE_ID'));
foreach ($letter_grades_RET as $grades) {
$i = 0;
if (count($grades)) {
foreach ($grades as $grade) {
if ($i % 9 == 0) {
$extra['search'] .= '<BR />';
}
$extra['search'] .= '<label><INPUT type="checkbox" value="Y" name="letter_grade[' . $grade['ID'] . ']"> ' . $grade['TITLE'] . '</label> ';
$i++;
}
}
}
}
$extra['search'] .= '</TD></TR>';
}
break;
case 'eligibility':
if ($RosarioModules['Eligibility']) {
if ($_REQUEST['ineligible'] == 'Y') {
$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;
break;
case 'Tue':
$today = 2;
break;
case 'Wed':
$today = 3;
break;
case 'Thu':
$today = 4;
break;
case 'Fri':
$today = 5;
break;
case 'Sat':
$today = 6;
break;
case 'Sun':
$today = 7;
break;
}
$start_date = mb_strtoupper(date('d-M-y', time() - ($today - $START_DAY) * 60 * 60 * 24));
$end_date = mb_strtoupper(date('d-M-y', time()));
$extra['WHERE'] .= " AND (SELECT count(*) FROM ELIGIBILITY e WHERE ssm.STUDENT_ID=e.STUDENT_ID AND e.SYEAR=ssm.SYEAR AND e.SCHOOL_DATE BETWEEN '{$start_date}' AND '{$end_date}' AND e.ELIGIBILITY_CODE='FAILING') > '0'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Eligibility')) . ' </b>' . _('Ineligible') . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:"></TD><TD><label><INPUT type="checkbox" name="ineligible" value="Y"> ' . _('Ineligible') . '</label></TD></TR>';
}
break;
case 'activity':
if ($RosarioModules['Eligibility']) {
if ($_REQUEST['activity_id']) {
$extra['FROM'] .= ",STUDENT_ELIGIBILITY_ACTIVITIES sea";
$extra['WHERE'] .= " AND sea.STUDENT_ID=s.STUDENT_ID AND sea.SYEAR=ssm.SYEAR AND sea.ACTIVITY_ID='" . $_REQUEST['activity_id'] . "'";
$activity = DBGet(DBQuery("SELECT TITLE FROM ELIGIBILITY_ACTIVITIES WHERE ID='" . $_REQUEST['activity_id'] . "'"));
if (!$extra['NoSearchTerms']) {
//modif Francois: add translation
$_ROSARIO['SearchTerms'] .= '<b>' . _('Activity') . ': </b>' . $activity[1]['TITLE'] . '<BR />';
}
}
if ($_REQUEST['search_modfunc'] == 'search_fnc' || !$_REQUEST['search_modfunc']) {
$activities_RET = DBGet(DBQuery("SELECT ID,TITLE FROM ELIGIBILITY_ACTIVITIES WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
}
$select = '<SELECT name="activity_id"><OPTION value="">' . _('Not Specified') . '</OPTION>';
if (count($activities_RET)) {
foreach ($activities_RET as $activity) {
$select .= '<OPTION value="' . $activity['ID'] . '">' . $activity['TITLE'] . '</OPTION>';
}
}
$select .= '</SELECT>';
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Activity') . '</TD><TD>' . $select . '</TD></TR>';
}
break;
case 'mailing_labels':
if ($_REQUEST['mailing_labels'] == 'Y') {
$extra['SELECT'] .= ',coalesce(sam.ADDRESS_ID,-ssm.STUDENT_ID) AS ADDRESS_ID,sam.ADDRESS_ID AS MAILING_LABEL';
$extra['FROM'] = " LEFT OUTER JOIN STUDENTS_JOIN_ADDRESS sam ON (sam.STUDENT_ID=ssm.STUDENT_ID AND sam.MAILING='Y'" . ($_REQUEST['residence'] == 'Y' ? " AND sam.RESIDENCE='Y'" : '') . ")" . $extra['FROM'];
$extra['functions'] += array('MAILING_LABEL' => 'MailingLabel');
}
$extra['search'] .= '<TR><TD style="text-align:right; width:130px"><label>' . _('Mailing Labels') . ' <INPUT type="checkbox" name="mailing_labels" value="Y"></label></TD>';
break;
case 'balance':
if ($RosarioModules['Student_Billing']) {
if (is_numeric($_REQUEST['balance_low']) && is_numeric($_REQUEST['balance_high'])) {
if ($_REQUEST['balance_low'] > $_REQUEST['balance_high']) {
$temp = $_REQUEST['balance_high'];
$_REQUEST['balance_high'] = $_REQUEST['balance_low'];
$_REQUEST['balance_low'] = $temp;
}
$extra['WHERE'] .= " AND (coalesce((SELECT sum(p.AMOUNT) FROM BILLING_PAYMENTS p WHERE p.STUDENT_ID=ssm.STUDENT_ID AND p.SYEAR=ssm.SYEAR AND (p.LUNCH_PAYMENT!='Y' OR p.LUNCH_PAYMENT IS NULL)),0)-coalesce((SELECT sum(f.AMOUNT) FROM BILLING_FEES f WHERE f.STUDENT_ID=ssm.STUDENT_ID AND f.SYEAR=ssm.SYEAR),0)) BETWEEN '{$_REQUEST['balance_low']}' AND '{$_REQUEST['balance_high']}' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Student Billing Balance')) . ' </b>' . _('Between') . ' ' . $_REQUEST['balance_low'] . ' & ' . $_REQUEST['balance_high'] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Balance') . '<BR /></TD><TD>' . _('Between') . ' <INPUT type="text" name="balance_low" size="5" maxlength="10"> & <INPUT type="text" name="balance_high" size="5" maxlength="10"></TD></TR>';
}
break;
case 'discipline':
if ($RosarioModules['Discipline']) {
if (is_array($_REQUEST['discipline'])) {
foreach ($_REQUEST['discipline'] as $key => $value) {
if (!$value) {
unset($_REQUEST['discipline'][$key]);
}
}
}
if ($_REQUEST['month_discipline_entry_begin'] && $_REQUEST['day_discipline_entry_begin'] && $_REQUEST['year_discipline_entry_begin']) {
$_REQUEST['discipline_entry_begin'] = $_REQUEST['day_discipline_entry_begin'] . '-' . $_REQUEST['month_discipline_entry_begin'] . '-' . $_REQUEST['year_discipline_entry_begin'];
if (!VerifyDate($_REQUEST['discipline_entry_begin'])) {
unset($_REQUEST['discipline_entry_begin']);
}
unset($_REQUEST['day_discipline_entry_begin']);
unset($_REQUEST['month_discipline_entry_begin']);
unset($_REQUEST['year_discipline_entry_begin']);
}
if ($_REQUEST['month_discipline_entry_end'] && $_REQUEST['day_discipline_entry_end'] && $_REQUEST['year_discipline_entry_end']) {
$_REQUEST['discipline_entry_end'] = $_REQUEST['day_discipline_entry_end'] . '-' . $_REQUEST['month_discipline_entry_end'] . '-' . $_REQUEST['year_discipline_entry_end'];
if (!VerifyDate($_REQUEST['discipline_entry_end'])) {
unset($_REQUEST['discipline_entry_end']);
}
unset($_REQUEST['day_discipline_entry_end']);
unset($_REQUEST['month_discipline_entry_end']);
unset($_REQUEST['year_discipline_entry_end']);
}
if ($_REQUEST['discipline_reporter'] || $_REQUEST['discipline_entry_begin'] || $_REQUEST['discipline_entry_end'] || count($_REQUEST['discipline']) || count($_REQUEST['discipline_begin']) || count($_REQUEST['discipline_end'])) {
$extra['WHERE'] .= ' AND dr.STUDENT_ID=ssm.STUDENT_ID AND dr.SYEAR=ssm.SYEAR AND dr.SCHOOL_ID=ssm.SCHOOL_ID ';
$extra['FROM'] .= ',DISCIPLINE_REFERRALS dr ';
}
$users_RET = DBGet(DBQuery("SELECT STAFF_ID,FIRST_NAME,LAST_NAME,MIDDLE_NAME FROM STAFF WHERE SYEAR='" . UserSyear() . "' AND (SCHOOLS IS NULL OR SCHOOLS LIKE '%," . UserSchool() . ",%') AND (PROFILE='admin' OR PROFILE='teacher') ORDER BY LAST_NAME,FIRST_NAME,MIDDLE_NAME"), array(), array('STAFF_ID'));
if ($_REQUEST['discipline_reporter']) {
$extra['WHERE'] .= " AND dr.STAFF_ID='{$_REQUEST['discipline_reporter']}' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Reporter') . ': </b>' . $users_RET[$_REQUEST['discipline_reporter']][1]['LAST_NAME'] . ', ' . $users_RET[$_REQUEST['discipline_reporter']][1]['FIRST_NAME'] . ' ' . $users_RET[$_REQUEST['discipline_reporter']][1]['MIDDLE_NAME'] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Reporter') . '</TD><TD>';
$extra['search'] .= '<SELECT name=discipline_reporter><OPTION value="">' . _('Not Specified') . '</OPTION>';
foreach ($users_RET as $id => $user) {
$extra['search'] .= '<OPTION value=' . $id . '>' . $user[1]['LAST_NAME'] . ', ' . $user[1]['FIRST_NAME'] . ' ' . $user[1]['MIDDLE_NAME'] . '</OPTION>';
}
$extra['search'] .= '</SELECT>';
$extra['search'] .= '</TD></TR>';
$discipline_entry_begin_for_ProperDate = $_REQUEST['discipline_entry_begin'];
if (mb_strlen($_REQUEST['discipline_entry_begin']) > 10) {
//date = LAST_LOGIN = date + time
$discipline_entry_begin_for_ProperDate = mb_substr($_REQUEST['discipline_entry_begin'], 0, 10);
}
if ($_REQUEST['discipline_entry_begin'] && $_REQUEST['discipline_entry_end']) {
$extra['WHERE'] .= " AND dr.ENTRY_DATE BETWEEN '{$_REQUEST['discipline_entry_begin']}' AND '{$_REQUEST['discipline_entry_end']}' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Incident Date') . ' ' . _('Between') . ': </b>' . ProperDate($discipline_entry_begin_for_ProperDate) . '<b> ' . _('and') . ' </b>' . ProperDate($_REQUEST['discipline_entry_end']) . '<BR />';
}
} elseif ($_REQUEST['discipline_entry_begin']) {
$extra['WHERE'] .= " AND dr.ENTRY_DATE>='{$_REQUEST['discipline_entry_begin']}' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Incident Entered') . ' ' . _('On or After') . ' </b>' . ProperDate($discipline_entry_begin_for_ProperDate) . '<BR />';
}
} elseif ($_REQUEST['discipline_entry_end']) {
$extra['WHERE'] .= " AND dr.ENTRY_DATE<='{$_REQUEST['discipline_entry_end']}' ";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Incident Entered') . ' ' . _('On or Before') . ' </b>' . ProperDate($_REQUEST['discipline_entry_end']) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Incident Date') . '</TD><TD><table class="cellpadding-0 cellspacing-0"><tr><td><span class="sizep2">≥</span> </td><td>' . PrepareDate('', '_discipline_entry_begin', true, array('short' => true)) . '</td></tr><tr><td><span class="sizep2">≤</span> </td><td>' . PrepareDate('', '_discipline_entry_end', true, array('short' => true)) . '</td></tr></table></TD></TR>';
}
/*break;
case 'discipline_categories':*/
if ($RosarioModules['Discipline']) {
$categories_RET = DBGet(DBQuery("SELECT f.ID,u.TITLE,f.DATA_TYPE,u.SELECT_OPTIONS FROM DISCIPLINE_FIELDS f,DISCIPLINE_FIELD_USAGE u WHERE u.DISCIPLINE_FIELD_ID=f.ID AND u.SYEAR='" . UserSyear() . "' AND u.SCHOOL_ID='" . UserSchool() . "' AND f.DATA_TYPE!='textarea'"));
foreach ($categories_RET as $category) {
if ($category['DATA_TYPE'] != 'date') {
$extra['search'] .= '<TR><TD width="150">' . $category['TITLE'] . '</TD><TD>';
switch ($category['DATA_TYPE']) {
case 'text':
$extra['search'] .= '<INPUT type="text" name="discipline[' . $category['ID'] . ']" />';
if ($_REQUEST['discipline'][$cateogory['ID']]) {
$extra['WHERE'] .= " AND dr.CATEGORY_" . $category['ID'] . " LIKE '" . $_REQUEST['discipline'][$cateogory['ID']] . "%' ";
}
break;
case 'checkbox':
$extra['search'] .= '<INPUT type="checkbox" name="discipline[' . $category['ID'] . ']" value="Y" />';
if ($_REQUEST['discipline'][$cateogory['ID']]) {
$extra['WHERE'] .= " AND dr.CATEGORY_" . $category['ID'] . " = 'Y' ";
}
break;
case 'numeric':
$extra['search'] .= '<small>' . _('Between') . ' </small><INPUT type="text" name="discipline_begin[' . $category['ID'] . ']" size="3" maxlength="11" /> & <INPUT type="text" name="discipline_end[' . $category['ID'] . ']" size="3" maxlength="11" />';
if ($_REQUEST['discipline_begin'][$cateogory['ID']] && $_REQUEST['discipline_begin'][$cateogory['ID']]) {
$extra['WHERE'] .= " AND dr.CATEGORY_" . $category['ID'] . " BETWEEN '" . $_REQUEST['discipline_begin'][$cateogory['ID']] . "' AND '" . $_REQUEST['discipline_end'][$cateogory['ID']] . "' ";
}
break;
case 'multiple_checkbox':
case 'multiple_radio':
case 'select':
$category['SELECT_OPTIONS'] = str_replace("\n", "\r", str_replace("\r\n", "\r", $category['SELECT_OPTIONS']));
$category['SELECT_OPTIONS'] = explode("\r", $category['SELECT_OPTIONS']);
$extra['search'] .= '<SELECT name="discipline[' . $category['ID'] . ']"><OPTION value="">' . _('N/A') . '</OPTION>';
foreach ($category['SELECT_OPTIONS'] as $option) {
$extra['search'] .= '<OPTION value="' . $option . '">' . $option . '</OPTION>';
}
$extra['search'] .= '</SELECT>';
if (($category['DATA_TYPE'] == 'multiple_radio' || $category['DATA_TYPE'] == 'select') && $_REQUEST['discipline'][$category['ID']]) {
$extra['WHERE'] .= " AND dr.CATEGORY_" . $category['ID'] . " = '" . $_REQUEST['discipline'][$category['ID']] . "' ";
} elseif ($category['DATA_TYPE'] == 'multiple_checkbox' && $_REQUEST['discipline'][$category['ID']]) {
$extra['WHERE'] .= " AND dr.CATEGORY_" . $category['ID'] . " LIKE '%||" . $_REQUEST['discipline'][$category['ID']] . "||%' ";
}
break;
}
$extra['search'] .= '</TD></TR>';
}
}
}
break;
case 'next_year':
if ($RosarioModules['Students']) {
$schools_RET = DBGet(DBQuery("SELECT ID,TITLE FROM SCHOOLS WHERE ID!='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"), array(), array('ID'));
if ($_REQUEST['next_year'] == '!') {
$extra['WHERE'] .= " AND ssm.NEXT_SCHOOL IS NULL";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Next Year')) . ' </b>' . _('No Value') . '<BR />';
}
} elseif ($_REQUEST['next_year'] != '') {
$extra['WHERE'] .= " AND ssm.NEXT_SCHOOL='" . $_REQUEST['next_year'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . Localize('colon', _('Next Year')) . ' </b>' . ($_REQUEST['next_year'] == UserSchool() ? 'Next grade at current school' : ($_REQUEST['next_year'] == '0' ? 'Retain' : ($_REQUEST['next_year'] == '-1' ? 'Do not enroll after this school year' : $schools_RET[$_REQUEST['next_year']][1]['TITLE']))) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Next Year') . '</TD><TD><SELECT name="next_year"><OPTION value="">' . _('N/A') . '</OPTION><OPTION value="!">' . _('No Value') . '</OPTION><OPTION value="' . UserSchool() . '">' . _('Next grade at current school') . '</OPTION><OPTION value="0">' . _('Retain') . '</OPTION><OPTION value="-1">' . _('Do not enroll after this school year') . '</OPTION>';
foreach ($schools_RET as $id => $school) {
$extra['search'] .= '<OPTION value=' . $id . '>' . $school[1]['TITLE'] . '</OPTION>';
}
$extra['search'] .= '</SELECT></TD></TR>';
}
break;
case 'calendar':
if ($RosarioModules['Students']) {
$calendars_RET = DBGet(DBQuery("SELECT CALENDAR_ID,TITLE FROM ATTENDANCE_CALENDARS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY DEFAULT_CALENDAR ASC"), array(), array('CALENDAR_ID'));
if ($_REQUEST['calendar'] == '!') {
$extra['WHERE'] .= " AND ssm.CALENDAR_ID IS " . ($_REQUEST['calendar_not'] == 'Y' ? 'NOT ' : '') . "NULL";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Calendar') . ': </b>' . ($_REQUEST['calendar_not'] == 'Y' ? _('Any Value') : _('No Value')) . '<BR />';
}
} elseif ($_REQUEST['calendar'] != '') {
$extra['WHERE'] .= " AND ssm.CALENDAR_ID" . ($_REQUEST['calendar_not'] == 'Y' ? '!' : '') . "='" . $_REQUEST['calendar'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Calendar') . ': </b>' . ($_REQUEST['calendar_not'] == 'Y' ? _('Not') . ' ' : '') . $calendars_RET[$_REQUEST['calendar']][1]['TITLE'] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Calendar') . '</TD><TD><label><INPUT type="checkbox" name="calendar_not" value="Y"> ' . _('Not') . ' </label><SELECT name="calendar"><OPTION value="">' . _('N/A') . '</OPTION><OPTION value="!">' . _('No Value') . '</OPTION>';
foreach ($calendars_RET as $id => $calendar) {
$extra['search'] .= '<OPTION value="' . $id . '">' . $calendar[1]['TITLE'] . '</OPTION>';
}
$extra['search'] .= '</SELECT></TD></TR>';
}
break;
case 'enrolled':
if ($RosarioModules['Students']) {
if ($_REQUEST['month_enrolled_begin'] && $_REQUEST['day_enrolled_begin'] && $_REQUEST['year_enrolled_begin']) {
$_REQUEST['enrolled_begin'] = $_REQUEST['day_enrolled_begin'] . '-' . $_REQUEST['month_enrolled_begin'] . '-' . $_REQUEST['year_enrolled_begin'];
if (!VerifyDate($_REQUEST['enrolled_begin'])) {
unset($_REQUEST['enrolled_begin']);
}
}
if ($_REQUEST['month_enrolled_end'] && $_REQUEST['day_enrolled_end'] && $_REQUEST['year_enrolled_end']) {
$_REQUEST['enrolled_end'] = $_REQUEST['day_enrolled_end'] . '-' . $_REQUEST['month_enrolled_end'] . '-' . $_REQUEST['year_enrolled_end'];
if (!VerifyDate($_REQUEST['enrolled_end'])) {
unset($_REQUEST['enrolled_end']);
}
}
if ($_REQUEST['enrolled_begin'] && $_REQUEST['enrolled_end']) {
$extra['WHERE'] .= " AND ssm.START_DATE BETWEEN '" . $_REQUEST['enrolled_begin'] . "' AND '" . $_REQUEST['enrolled_end'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Enrolled') . ' ' . _('Between') . ': </b>' . ProperDate($_REQUEST['enrolled_begin']) . ' and ' . ProperDate($_REQUEST['enrolled_end']) . '<BR />';
}
} elseif ($_REQUEST['enrolled_begin']) {
$extra['WHERE'] .= " AND ssm.START_DATE>='" . $_REQUEST['enrolled_begin'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Enrolled') . ' ' . _('On or After') . ': </b>' . ProperDate($_REQUEST['enrolled_begin']) . '<BR />';
}
}
if ($_REQUEST['enrolled_end']) {
$extra['WHERE'] .= " AND ssm.START_DATE<='" . $_REQUEST['enrolled_end'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Enrolled') . ' ' . _('On or Before') . ': </b>' . ProperDate($_REQUEST['enrolled_end']) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Attendance Start') . '</TD><TD><table class="cellpadding-0 cellspacing-0"><tr><td><span class="sizep2">≥</span> </td><td>' . PrepareDate('', '_enrolled_begin', true, array('short' => true)) . '</td></tr><tr><td><span class="sizep2">≤</span> </td><td>' . PrepareDate('', '_enrolled_end', true, array('short' => true)) . '</td></tr></table></TD></TR>';
}
break;
case 'rolled':
if ($RosarioModules['Students']) {
if ($_REQUEST['rolled']) {
$extra['WHERE'] .= " AND " . ($_REQUEST['rolled'] == 'Y' ? '' : 'NOT ') . "exists (SELECT '' FROM STUDENT_ENROLLMENT WHERE STUDENT_ID=ssm.STUDENT_ID AND SYEAR<ssm.SYEAR)";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Previously Enrolled') . ': </b>' . ($_REQUEST['rolled'] == 'Y' ? _('Yes') : _('No')) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Previously Enrolled') . '</TD><TD><label><INPUT type="radio" value="" name="rolled" checked /> ' . _('N/A') . '</label> <label><INPUT type="radio" value="Y" name="rolled"> ' . _('Yes') . '</label> <label><INPUT type="radio" value="N" name="rolled"> ' . _('No') . '</label></TD></TR>';
}
break;
case 'fsa_balance_warning':
$value = $GLOBALS['warning'];
$item = 'fsa_balance';
case 'fsa_balance':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_balance'] != '') {
if (!mb_strpos($extra['FROM'], 'fssa')) {
$extra['FROM'] .= ',FOOD_SERVICE_STUDENT_ACCOUNTS fssa';
$extra['WHERE'] .= ' AND fssa.STUDENT_ID=s.STUDENT_ID';
}
$extra['FROM'] .= ",FOOD_SERVICE_ACCOUNTS fsa";
$extra['WHERE'] .= " AND fsa.ACCOUNT_ID=fssa.ACCOUNT_ID AND fsa.BALANCE" . ($_REQUEST['fsa_bal_ge'] == 'Y' ? '>=' : '<') . "'" . round($_REQUEST['fsa_balance'], 2) . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Food Service Balance') . ': </b><span class="sizep2">' . ($_REQUEST['fsa_bal_ge'] == 'Y' ? '≥' : '<') . number_format($_REQUEST['fsa_balance'], 2) . '</span><BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Balance') . '</TD><TD><table class="cellpadding-0 cellspacing-0"><tr><td><label><span class="sizep2"><</span> <INPUT type="radio" name="fsa_bal_ge" value="" checked /></label></td><td rowspan="2"><INPUT type="text" name="fsa_balance" size=10' . ($value ? ' value="' . $value . '"' : '') . '></label></td></tr><tr><td><label><span class="sizep2">≥</span> <INPUT type="radio" name="fsa_bal_ge" value=Y></label></td></tr></table></TD></TR>';
}
break;
case 'fsa_discount':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_discount']) {
if (!mb_strpos($extra['FROM'], 'fssa')) {
$extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa";
$extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID";
}
if ($_REQUEST['fsa_discount'] == 'Full') {
$extra['WHERE'] .= " AND fssa.DISCOUNT IS NULL";
} else {
$extra['WHERE'] .= " AND fssa.DISCOUNT='" . $_REQUEST['fsa_discount'] . "'";
}
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Food Service Discount') . ': </b>' . $_REQUEST['fsa_discount'] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Discount') . '</TD><TD><SELECT name=fsa_discount><OPTION value="">' . _('Not Specified') . '</OPTION><OPTION value="Full">' . _('Full') . '</OPTION><OPTION value="Reduced">' . _('Reduced') . '</OPTION><OPTION value="Free">' . _('Free') . '</OPTION></SELECT></TD></TR>';
}
break;
case 'fsa_status_active':
$value = 'active';
$item = 'fsa_status';
case 'fsa_status':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_status']) {
if (!mb_strpos($extra['FROM'], 'fssa')) {
$extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa";
$extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID";
}
if ($_REQUEST['fsa_status'] == 'Active') {
$extra['WHERE'] .= " AND fssa.STATUS IS NULL";
} else {
$extra['WHERE'] .= " AND fssa.STATUS='" . $_REQUEST['fsa_status'] . "'";
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Account Status') . '</TD><TD><SELECT name=fsa_status><OPTION value="">' . _('Not Specified') . '</OPTION><OPTION value="Active"' . ($value == 'active' ? ' SELECTED="SELECTED"' : '') . '>' . _('Active') . '</OPTION><OPTION value="Inactive">' . _('Inactive') . '</OPTION><OPTION value="Disabled">' . _('Disabled') . '</OPTION><OPTION value="Closed">' . _('Closed') . '</OPTION></SELECT></TD></TR>';
}
break;
case 'fsa_barcode':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_barcode']) {
if (!mb_strpos($extra['FROM'], 'fssa')) {
$extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa";
$extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID";
}
$extra['WHERE'] .= " AND fssa.BARCODE='" . $_REQUEST['fsa_barcode'] . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Food Service Barcode') . ': </b>' . $_REQUEST['fsa_barcode'] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Barcode') . '</TD><TD><INPUT type="text" name="fsa_barcode" size="15"></TD></TR>';
}
break;
case 'fsa_account_id':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_account_id']) {
if (!mb_strpos($extra['FROM'], 'fssa')) {
$extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa";
$extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID";
}
$extra['WHERE'] .= " AND fssa.ACCOUNT_ID='" . ($_REQUEST['fsa_account_id'] + 0) . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<b>' . _('Food Service Account ID') . ': </b>' . ($_REQUEST['fsa_account_id'] + 0) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Account ID') . '</TD><TD><INPUT type="text" name="fsa_account_id" size="15"></TD></TR>';
}
break;
}
$_ROSARIO['Widgets'][$item] = true;
}
}
$RET = GetStuList($extra);
if (count($RET)) {
include 'modules/Students/includes/functions.php';
//------------Comment Heading -----------------------------------------------------
//$categories_RET = DBGet(DBQuery("SELECT ID,TITLE,INCLUDE FROM STUDENT_FIELD_CATEGORIES ORDER BY SORT_ORDER,TITLE"),array(),array('ID'));
// get the address and contacts custom fields, create the select lists and expand select and codeds options
$address_categories_RET = DBGet(DBQuery("SELECT c.ID AS CATEGORY_ID,c.TITLE AS CATEGORY_TITLE,c.RESIDENCE,c.MAILING,c.BUS,f.ID,f.TITLE,f.TYPE,f.SELECT_OPTIONS,f.DEFAULT_SELECTION,f.REQUIRED FROM ADDRESS_FIELD_CATEGORIES c,ADDRESS_FIELDS f WHERE f.CATEGORY_ID=c.ID ORDER BY c.SORT_ORDER,c.TITLE,f.SORT_ORDER,f.TITLE"), array(), array('CATEGORY_ID'));
$people_categories_RET = DBGet(DBQuery("SELECT c.ID AS CATEGORY_ID,c.TITLE AS CATEGORY_TITLE,c.CUSTODY,c.EMERGENCY,f.ID,f.TITLE,f.TYPE,f.SELECT_OPTIONS,f.DEFAULT_SELECTION,f.REQUIRED FROM PEOPLE_FIELD_CATEGORIES c,PEOPLE_FIELDS f WHERE f.CATEGORY_ID=c.ID ORDER BY c.SORT_ORDER,c.TITLE,f.SORT_ORDER,f.TITLE"), array(), array('CATEGORY_ID'));
explodeCustom($address_categories_RET, $address_custom, 'a');
explodeCustom($people_categories_RET, $people_custom, 'p');
unset($_REQUEST['modfunc']);
$handle = PDFStart();
foreach ($RET as $student) {
$_SESSION['student_id'] = $student['STUDENT_ID'];
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Student Information Report</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=2 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo "<table cellspacing=0 border=\"0\" style=\"border-collapse:collapse\">";
echo "<tr><td colspan=3 style=\"height:18px\"></td></tr>";
if ($StudentPicturesPath && (($file = @fopen($picture_path = $StudentPicturesPath . UserSyear() . '/' . UserStudentID() . '.JPG', 'r')) || ($file = @fopen($picture_path = $StudentPicturesPath . (UserSyear() - 1) . '/' . UserStudentID() . '.JPG', 'r')))) {
echo '<tr><td width=300><IMG SRC="' . $picture_path . '?id=' . rand(6, 100000) . '" width=150 style="padding:4px; background-color:#fff; border:1px solid #333" ></td><td width=12px></td>';
} else {
echo '<tr><td width=300><IMG SRC="assets/noimage.jpg?id=' . rand(6, 100000) . '" width=144 style="padding:4px; background-color:#fff; border:1px solid #333"></td><td width=12px></td>';
}
fclose($file);
#$sql=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 AS HOSPITAL,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
# ---------------- Sql Including Comment ------------------------------- #
#$sql=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 AS HOSPITAL,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING, smc.comment AS COMMENT FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec, STUDENT_MP_COMMENTS smc WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND s.STUDENT_ID=smc.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
#$sql=DBGet(DBQuery("SELECT s.CUSTOM_200000000 AS GENDER, s.CUSTOM_200000001 AS ETHNICITY, s.CUSTOM_200000002 AS COMMON_NAME, s.CUSTOM_200000003 AS SOCIAL_SEC_NO, s.CUSTOM_200000004 AS BIRTHDAY, s.CUSTOM_200000005 AS LANGUAGE, s.CUSTOM_200000006 AS PHYSICIAN_NAME, s.CUSTOM_200000007 AS PHYSICIAN_PHONO,s.custom_200000008 AS HOSPITAL,s.custom_200000009 AS MCOMNT,s.custom_200000011 AS DNOTE,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING, smc.comment AS COMMENT FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec, STUDENT_MP_COMMENTS smc WHERE s.STUDENT_ID='".$_SESSION['student_id']."' AND s.STUDENT_ID=se.STUDENT_ID AND s.STUDENT_ID=smc.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
$sql = DBGet(DBQuery("SELECT s.gender AS GENDER, s.ethnicity AS ETHNICITY, s.common_name AS COMMON_NAME, s.social_security AS SOCIAL_SEC_NO, s.birthdate AS BIRTHDAY, s.email AS EMAIL, s.phone AS PHONE, s.language AS LANGUAGE, s.physician AS PHYSICIAN_NAME, s.physician_phone AS PHYSICIAN_PHONO,s.preferred_hospital AS HOSPITAL,se.START_DATE AS START_DATE,sec.TITLE AS STATUS, se.NEXT_SCHOOL AS ROLLING FROM STUDENTS s, STUDENT_ENROLLMENT se,STUDENT_ENROLLMENT_CODES sec WHERE s.STUDENT_ID='" . $_SESSION['student_id'] . "' AND s.STUDENT_ID=se.STUDENT_ID AND se.SYEAR=sec.SYEAR"));
$sql = $sql[1];
$medical_note = DBGet(DBQuery("SELECT doctors_note_date AS MCOMNT,doctors_note_comments AS DNOTE FROM STUDENT_MEDICAL_NOTES WHERE STUDENT_ID='" . $_SESSION['student_id'] . "' "));
$where = ' AND MARKING_PERIOD_ID=' . $_REQUEST['marking_period_id'];
}
$sql = 'select distinct
(select title from course_subjects where subject_id=(select subject_id from courses where course_id=course_periods.course_id)) as subject,
(select title from courses where course_id=course_periods.course_id) as COURSE_TITLE,course_id
from course_periods where school_id=\'' . UserSchool() . '\' and syear=\'' . UserSyear() . '\' ' . $where . ' order by subject,COURSE_TITLE';
$ret = DBGet(DBQuery($sql));
if (count($ret)) {
foreach ($ret as $s_id) {
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
$mark_name_rp = DBGet(DBQuery('SELECT TITLE,SHORT_NAME,\'2\' FROM school_quarters WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT TITLE,SHORT_NAME,\'1\' FROM school_semesters WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' UNION SELECT TITLE,SHORT_NAME,\'0\' FROM school_years WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['marking_period_id'] . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY 3'));
$mark_name_rpt = $mark_name_rp[1]['TITLE'];
if ($mark_name_rpt != '') {
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Course catalog by Term: " . $mark_name_rpt . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
} else {
echo "<tr><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">Course catalog by Term: All</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
}
echo '<div align="center">';
echo '<table border="0" width="97%" align="center"><tr><td><font face=verdana size=-1><b>' . $s_id['SUBJECT'] . '</b></font></td></tr>';
echo '<tr><td align="right"><table border="0" width="97%"><tr><td><font face=verdana size=-1><b>' . $s_id['COURSE_TITLE'] . '</b></font></td></tr>';
if (!$_REQUEST['marking_period_id']) {
$sql_periods = 'SELECT cp.SHORT_NAME,(SELECT TITLE FROM school_periods WHERE period_id=cpv.period_id) AS PERIOD,r.TITLE as ROOM,cpv.DAYS,(SELECT CONCAT(LAST_NAME,\' \',FIRST_NAME,\' \') from staff where staff_id=cp.TEACHER_ID) as TEACHER from course_periods cp,course_period_var cpv,rooms r where cp.course_id=' . $s_id['COURSE_ID'] . ' and cp.syear=\'' . UserSyear() . '\' and cp.course_period_id=cpv.course_period_id and cpv.room_id=r.room_id and cp.school_id=\'' . UserSchool() . '\'';
} else {
$sql_periods = 'SELECT distinct cp.SHORT_NAME,(select CONCAT(START_TIME,\' - \',END_TIME,\' \') from school_periods where period_id=cpv.period_id) as PERIOD,r.TITLE as ROOM,cpv.DAYS,(select CONCAT(LAST_NAME,\' \',FIRST_NAME,\' \') from staff where staff_id=cp.TEACHER_ID) as TEACHER from course_periods cp,course_period_var cpv,rooms r where cp.course_id=' . $s_id['COURSE_ID'] . ' and cp.syear=\'' . UserSyear() . '\' and cp.course_period_id=cpv.course_period_id and cpv.room_id=r.room_id and cp.school_id=\'' . UserSchool() . '\' and cp.marking_period_id=\'' . $_REQUEST['marking_period_id'] . '\'';
}
$period_list = DBGet(DBQuery($sql_periods));
##############################################List Output Generation##################################################
$columns = array('SHORT_NAME' => 'Course', 'PERIOD' => 'Time', 'DAYS' => 'Days', 'ROOM' => 'Location', 'TEACHER' => 'Teacher');
echo '<tr><td colspan="2" valign="top" align="right">';
PrintCatalog($period_list, $columns, 'Course', 'Courses', '', '', array('search' => false));
echo '</td></tr></table></td></tr></table></td></tr>';
(select CONCAT(LAST_NAME,' ',FIRST_NAME,' ',MIDDLE_NAME,' ') from staff where staff_id=course_periods.teacher_id) as teacher,
room as location,days,course_period_id,course_id
from course_periods where school_id='".UserSchool()."' and syear='".UserSyear()."' ".$where." order by subject,COURSE_TITLE";
$ret = DBGet(DBQuery($sql));
*
*/
$sql_subject = 'SELECT SUBJECT_ID,TITLE FROM course_subjects WHERE
SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear();
$sql_subject_ret = DBGet(DBQuery($sql_subject));
if (count($sql_subject_ret)) {
foreach ($sql_subject_ret as $subject) {
echo "<table width=100% style=\" font-family:Arial; font-size:12px;\" >";
echo "<tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">All Courses</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br />Powered by openSIS</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo '<table border="0" width="100%" align="center"><tr><td><font face=verdana size=-1><b>' . $subject['TITLE'] . '</b></font></td></tr><tr>';
$sql_course = 'SELECT COURSE_ID,TITLE FROM courses WHERE
SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear() . ' AND SUBJECT_ID=' . $subject['SUBJECT_ID'];
$sql_course_ret = DBGet(DBQuery($sql_course));
foreach ($sql_course_ret as $course) {
echo '<table border="0"><tr><td style=padding-left:40px;><font face=verdana size=-1><b>' . $course['TITLE'] . '</b></font></td></tr></table>';
$sql_course_period = 'SELECT TITLE FROM course_periods WHERE
SCHOOL_ID=' . UserSchool() . ' AND SYEAR= ' . UserSyear() . ' AND COURSE_ID=' . $course['COURSE_ID'];
$sql_course_period_ret = DBGet(DBQuery($sql_course_period));
foreach ($sql_course_period_ret as $course_period) {
echo '<table border="0" width="100%"><tr><td style=padding-left:80px;><font face=verdana size=-1><b>' . $course_period['TITLE'] . '</b></font></td></tr></table>';
}
}
echo '</tr><tr><td colspan="2" valign="top" align="right">';
echo '</td></tr></table>';
function _removeSpaces($value, $column)
{
if ($column == 'ASSIGNED_DATE' || $column == 'DUE_DATE') {
$value = ProperDate($value);
}
return str_replace(' ', ' ', str_replace('&', '&', $value));
}
}
if ($_REQUEST['room']) {
$extra['SELECT'] .= ',(SELECT cp.ROOM FROM course_periods cp WHERE cp.COURSE_PERIOD_ID=\'' . UserCoursePeriod() . '\') AS ROOM';
}
}
$RET = GetStuList($extra);
if (count($RET)) {
$skipRET = array();
for ($i = ($_REQUEST['start_row'] - 1) * $max_cols + $_REQUEST['start_col']; $i > 1; $i--) {
$skipRET[-$i] = array('LAST_NAME' => ' ');
}
$handle = PDFstart();
$cols = 0;
$rows = 0;
echo "<meta charset='UTF-8'><table width=100% border=0 style=\" font-family:Arial; font-size:12px;\" >";
echo "<meta charset='UTF-8'><tr><td width=105>" . DrawLogo() . "</td><td style=\"font-size:15px; font-weight:bold; padding-top:20px;\">" . GetSchool(UserSchool()) . "<div style=\"font-size:12px;\">" . _('Student Labels') . "</div></td><td align=right style=\"padding-top:20px;\">" . ProperDate(DBDate()) . "<br \\>" . _('Powered by openSIS') . "</td></tr><tr><td colspan=3 style=\"border-top:1px solid #333;\"> </td></tr></table>";
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0" style=font-family:Arial; font-size:12px;>';
foreach ($skipRET + $RET as $i => $student) {
if ($cols < 1) {
echo '<tr>';
}
echo '<td width="33.3%" height="86" align="center" valign="middle">';
echo '<table border=0 align=center>';
echo '<tr>';
echo '<td align=center>' . $student['NICK_NAME'] . ' ' . $student['LAST_NAME'] . '</td></tr>';
if ($_REQUEST['teacher']) {
echo '<tr><td align=center>' . _('Teacher') . ':';
echo '' . $student['TEACHER'] . '</td></tr>';
}
if ($_REQUEST['room']) {
echo '<tr><td align=center>' . _('Room No :') . '';
function _makeViewDate($value, $column)
{
if ($value) {
return ProperDate($value);
} else {
return '<center>n/a</center>';
}
}
