}
}
$exceptions_RET = DBGet(DBQuery("SELECT MODNAME,CAN_USE,CAN_EDIT FROM STAFF_EXCEPTIONS WHERE USER_ID='{$user_id}'"), array(), array('MODNAME'));
unset($tmp_menu);
unset($_REQUEST['modfunc']);
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_REQUEST['can_edit']);
unset($_SESSION['_REQUEST_vars']['can_edit']);
unset($_REQUEST['can_use']);
unset($_SESSION['_REQUEST_vars']['can_use']);
}
if (UserStaffID() && !$_REQUEST['modfunc']) {
$staff_RET = DBGet(DBQuery("SELECT FIRST_NAME,LAST_NAME,PROFILE,PROFILE_ID FROM STAFF WHERE STAFF_ID='" . UserStaffID() . "'"));
if (!$staff_RET[1]['PROFILE_ID']) {
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
DrawHeader(_('Select the programs with which this user can use and save information.'), SubmitButton(_('Save')));
echo '<BR>';
PopTable('header', _('Permissions'));
echo '<TABLE border=0 cellspacing=0>';
foreach ($menu as $modcat => $profiles) {
$values = $profiles[$staff_RET[1]['PROFILE']];
echo '<TR><TD valign=top align=right>';
echo "<BR><b><font color=gray>" . str_replace('_', ' ', $modcat) . "</font></b></TD><TD width=3> </TD>";
echo "<TH bgcolor=#FFFFFF><small><font color=gray>Can Use" . (AllowEdit() ? "<INPUT type=checkbox name=can_use_{$modcat} onclick='checkAll(this.form,this.form.can_use_{$modcat}.checked,\"can_use[{$modcat}\");'>" : '') . "</font></small></TH><TH bgcolor=#FFFFFF> <small><font color=gray>Can Edit" . (AllowEdit() ? "<INPUT type=checkbox name=can_edit_{$modcat} onclick='checkAll(this.form,this.form.can_edit_{$modcat}.checked,\"can_edit[{$modcat}\");'>" : '') . "</font></small></TH><TH bgcolor=#FFFFFF></TH></TR>";
if (count($values)) {
foreach ($values as $file => $title) {
if (!is_numeric($file)) {
$can_use = $exceptions_RET[$file][1]['CAN_USE'];
$can_edit = $exceptions_RET[$file][1]['CAN_EDIT'];
echo "<TR><TD></TD><TD></TD>";
echo "<TD align=center bgcolor=#DDDDDD><INPUT type=checkbox name=can_use[" . str_replace('.', '_', $file) . "] value=true" . ($can_use == 'Y' ? ' CHECKED' : '') . (AllowEdit() ? '' : ' DISABLED') . "></TD>";
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
if (!$_REQUEST['modfunc']) {
$start_date = '01-' . strtoupper(date('M-y'));
$end_date = DBDate();
echo "<br><FORM name=log id=log action=Modules.php?modname={$_REQUEST['modname']}&modfunc=generate method=POST>";
PopTable('header', 'Log Details');
echo '<div align=center style="padding-top:20px; font-size:12px;"><strong>Please Select Date Range</strong></div>
<TABLE border=0 width=100% align=center><tr><TD valign=top style=padding-top:14px;>';
echo '<strong>From :</strong> </TD><TD valign=middle>';
DrawHeader(PrepareDate($start_date, '_start'));
echo '</TD><TD valign=top style=padding-top:14px;><strong>To :</strong> </TD><TD valign=middle>';
DrawHeader(PrepareDate($end_date, '_end'));
echo '</TD></TR></TABLE><div style=height:10px></div>';
echo '<center><input type="submit" class=btn_medium value="Generate" name="generate"></center>';
PopTable('footer');
echo '</FORM>';
}
if ($_REQUEST['day_start'] && $_REQUEST['month_start'] && $_REQUEST['year_start']) {
$start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . substr($_REQUEST['year_start'], 2, 4);
$org_start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . $_REQUEST['year_start'];
$conv_st_date = con_date($org_start_date);
}
if ($_REQUEST['day_end'] && $_REQUEST['month_end'] && $_REQUEST['year_end']) {
$end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . substr($_REQUEST['year_end'], 2, 4);
$org_end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . $_REQUEST['year_end'];
$conv_end_date = con_date_end($org_end_date);
}
}
$sql = substr($sql, 0, -1) . ',school_id=\'' . UserSchool() . '\'';
DBQuery($sql);
}
$sys_pref = DBGet(DBQuery('SELECT * FROM system_preference WHERE SCHOOL_ID=' . UserSchool()));
$sys_pref = $sys_pref[1];
PopTable('header', _('Half-day and full-day minutes'));
if ($sys_pref == '') {
echo "<FORM name=sys_pref id=sys_pref action=Modules.php?modname={$_REQUEST['modname']}&action=insert&page_display=system_preference method=POST>";
} else {
echo "<FORM name=sys_pref id=sys_pref action=Modules.php?modname={$_REQUEST['modname']}&action=update&page_display=system_preference method=POST>";
}
echo "<table width=300px><tr><td><table border=0 cellpadding=4 align=center>";
echo "<tr><td><strong>" . _('Full day minutes') . " :</strong> </td><td>" . TextInput($sys_pref['FULL_DAY_MINUTE'], 'values[FULL_DAY_MINUTE]', '', 'class=cell_floating size=5') . "</td></tr><tr><td><strong>" . _('Half day minutes') . " :</strong></td><td>" . TextInput($sys_pref['HALF_DAY_MINUTE'], 'values[HALF_DAY_MINUTE]', '', 'class=cell_floating size=5') . "</td></tr>";
echo "</table></td></tr></table>";
DrawHeader('', '', "<INPUT TYPE=SUBMIT name=button id=button class=btn_medium VALUE='" . _('Save') . "'></CENTER>");
echo "</FORM>";
PopTable('footer');
} else {
if (clean_param($_REQUEST['page_display'], PARAM_ALPHAMOD) == 'MAINTENANCE') {
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'update') {
if (clean_param($_REQUEST['maintain'], PARAM_NOTAGS)) {
$check_sys_pref_misc = DBGet(DBQuery('SELECT COUNT(1) as TOTAL FROM system_preference_misc'));
if ($check_sys_pref_misc[1]['TOTAL'] > 0) {
$sql = 'UPDATE system_preference_misc SET ';
foreach ($_REQUEST['maintain'] as $column_name => $value) {
$sql .= '' . $column_name . '=\'' . str_replace("\\'", "''", str_replace("`", "''", $value)) . '\',';
}
$sql = substr($sql, 0, -1) . ' WHERE 1=1';
} else {
$sql = 'INSERT INTO system_preference_misc (SYSTEM_MAINTENANCE_SWITCH) VALUES (\'' . $_REQUEST['maintain']['SYSTEM_MAINTENANCE_SWITCH'] . '\') ';
<?php
if ($_REQUEST[modfunc] == '') {
if (defined('PRINT_LETTER')) {
$title = 'Student Billing Notifications';
} else {
$title = 'Student Billing Invoices';
}
DrawHeader($title);
echo '<BR>';
PopTable('header', 'Search');
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=list method=POST>";
echo '<TABLE>';
Warehouse('searchstu');
echo '<TR><TD>Balance Between</TD><TD><INPUT type=text name=balance_low> & <INPUT type=text name=balance_high></TD></TR>';
echo '<TR><TD>Balance Not Zero</TD><TD><INPUT type=checkbox name=not_zero value=Y></TD></TR>';
echo '<TR><TD>Invoice</TD><TD>';
echo '<SELECT name=editor>
<OPTION value=both>Student Billing & Lunch</OPTION>
<OPTION value=stubilling SELECTED>Student Billing</OPTION>
<OPTION value=lunch>Lunch</OPTION>
</SELECT>';
echo '</TD></TR>';
PrepareSchool(SessionSchool(), '', SessionCurSchool());
Warehouse('searchgrade');
Warehouse('searchyear');
if (defined('PRINT_LETTER')) {
echo '<TR><TD>Letter Text</TD><TD>';
echo '<TEXTAREA name=letter rows=10 cols=50>
Dear __PARENTS__,
unset($_REQUEST['modfunc']);
}
$schools_RET = DBGet(DBQuery("SELECT ID,SYEAR,TITLE FROM SCHOOLS"), array(), array('SYEAR'));
//echo '<pre>'; var_dump($schools_RET); echo '</pre>';
foreach ($schools_RET as $syear => $schools) {
foreach ($schools as $school) {
$schools_select[$syear][$school['ID']] = $school['TITLE'];
}
}
//echo '<pre>'; var_dump($schools_select); echo '</pre>';
$students_RET = DBGet(DBQuery("SELECT fst.TRANSACTION_ID,fst.ACCOUNT_ID,fst.SYEAR," . db_case(array('fst.STUDENT_ID', "''", 'NULL', "(SELECT FIRST_NAME||' '||LAST_NAME FROM STUDENTS WHERE STUDENT_ID=fst.STUDENT_ID)")) . " AS FULL_NAME,fst.ACCOUNT_ID AS STUDENTS,fst.SCHOOL_ID FROM FOOD_SERVICE_TRANSACTIONS fst WHERE fst.SCHOOL_ID IS NULL"), array('STUDENTS' => '_students', 'SCHOOL_ID' => '_make_school'));
$staff_RET = DBGet(DBQuery("SELECT fst.TRANSACTION_ID,fst.STAFF_ID,fst.SYEAR,(SELECT FIRST_NAME||' '||LAST_NAME FROM STAFF WHERE STAFF_ID=fst.STAFF_ID) AS FULL_NAME,fst.SCHOOL_ID FROM FOOD_SERVICE_STAFF_TRANSACTIONS fst WHERE fst.SCHOOL_ID IS NULL"), array('SCHOOL_ID' => '_make_staff_school'));
//echo '<pre>'; var_dump($students_RET); echo '</pre>';
//echo '<pre>'; var_dump($users_RET); echo '</pre>';
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
DrawHeader('', SubmitButton(_('Save')));
$columns = array('TRANSACTION_ID' => _('ID'), 'ACCOUNT_ID' => _('Account ID'), 'SYEAR' => _('School Year'), 'FULL_NAME' => _('Student'), 'STUDENTS' => _('Students'), 'SCHOOL_ID' => _('School'));
ListOutput($students_RET, $columns, _('Student Transaction w/o School'), _('Student Transactions w/o School'), false, array(), array('save' => false, 'search' => false));
$columns = array('TRANSACTION_ID' => _('ID'), 'SYEAR' => _('School Year'), 'FULL_NAME' => _('User'), 'SCHOOL_ID' => _('School'));
ListOutput($staff_RET, $columns, _('User Transaction w/o School'), _('User Transactions w/o School'), false, array(), array('save' => false, 'search' => false));
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
echo '</FORM>';
function _students($value, $column)
{
$RET = DBGet(DBQuery("SELECT s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fsa WHERE s.STUDENT_ID=fsa.STUDENT_ID AND fsa.ACCOUNT_ID='" . $value . "'"));
foreach ($RET as $student) {
$ret .= $student['FULL_NAME'] . '<br>';
}
$ret = substr($ret, 0, -4);
return $ret;
}
}
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
DrawHeader(ProgramTitle(), '<INPUT type=submit value=' . _('Update') . '>');
if ($REQ_codes) {
foreach ($REQ_codes as $code) {
$code_pulldowns .= _makeCodeSearch($code);
}
} elseif ($abs) {
$code_pulldowns = _makeCodeSearch('A');
} else {
$code_pulldowns = _makeCodeSearch();
}
if (UserStudentID()) {
$current_student_link = "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=student&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}&year_date={$_REQUEST['year_date']}&student_id=" . UserStudentID() . ">Current Student</A></TD><TD>";
}
DrawHeader(PrepareDate($date, '_date'), '<TABLE><TR><TD>' . $current_student_link . button('add', '', "# onclick='javascript:addHTML(\"" . str_replace('"', '\\"', _makeCodeSearch()) . "\",\"code_pulldowns\"); return false;'") . '</TD><TD><DIV id=code_pulldowns>' . $code_pulldowns . '</DIV></TD></TR></TABLE>');
$_REQUEST['search_modfunc'] = 'list';
Search('student_id', $extra);
echo "</FORM>";
}
function _makePhone($value, $column)
{
global $THIS_RET, $contacts_RET;
if (count($contacts_RET[$THIS_RET['STUDENT_ID']])) {
foreach ($contacts_RET[$THIS_RET['STUDENT_ID']] as $person) {
if ($person[1]['FIRST_NAME'] || $person[1]['LAST_NAME']) {
$tipmessage .= '<B>' . $person[1]['STUDENT_RELATION'] . ': ' . $person[1]['FIRST_NAME'] . ' ' . $person[1]['LAST_NAME'] . '</B><BR>';
}
$tipmessage .= '<TABLE>';
if ($person[1]['PHONE']) {
$tipmessage .= '<TR><TD align=right><font color=gray size=1 face=Verdana,Arial,Helvetica>' . _('Home Phone') . '</font> </TD><TD><font size=1 face=Verdana,Arial,Helvetica>' . $person[1]['PHONE'] . '</font></TD></TR>';
}
}
}
}
if (count($_REQUEST['mp_arr']) == 1 && AllowEdit()) {
$link['remove']['link'] = PreparePHP_SELF($_REQUEST, array(), array('modfunc' => 'delete'));
$link['remove']['variables'] = array('student_id' => 'STUDENT_ID', 'course_period_id' => 'COURSE_PERIOD_ID', 'marking_period_id' => 'MARKING_PERIOD_ID');
}
if (!isset($_REQUEST['_ROSARIO_PDF'])) {
$commentsB_RET = DBGet(DBQuery("SELECT ID,TITLE,SORT_ORDER FROM REPORT_CARD_COMMENTS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND COURSE_ID IS NULL ORDER BY SORT_ORDER"), array(), array('ID'));
if (count($commentsB_RET)) {
foreach ($commentsB_RET as $comment) {
$tipmessage .= $comment[1]['SORT_ORDER'] . ' - ' . str_replace("'", '´', $comment[1]['TITLE']) . '<BR />';
}
$tipmessage = button('comment', _('Comment Codes'), '"#" onmouseover=\'stm(["' . _('Report Card Comments') . '","' . str_replace('"', '\\"', str_replace("'", ''', $tipmessage)) . '"],tipmessageStyle);\' onmouseout=\'htm()\'', 24);
DrawHeader('', $tipmessage);
}
}
ListOutput($grades_RET, $columns, '.', '.', $link);
} else {
$error[] = _('No Students were found.');
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_REQUEST['modfunc']);
}
} else {
$error[] = _('You must choose at least one student and one marking period.');
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_REQUEST['modfunc']);
}
}
if (empty($_REQUEST['modfunc'])) {
$_REQUEST['table'] = '0';
}
$category_select = "<SELECT name=table onChange='this.form.submit();'><OPTION value='0'" . ($_REQUEST['table'] == '0' ? ' SELECTED' : '') . ">" . _('Attendance') . "</OPTION>";
foreach ($categories_RET as $category) {
$category_select .= "<OPTION value={$category['ID']}" . ($_REQUEST['table'] == $category['ID'] ? ' SELECTED' : '') . ">" . $category['TITLE'] . "</OPTION>";
}
$category_select .= "</SELECT>";
$QI = DBQuery("SELECT sp.PERIOD_ID,sp.TITLE FROM SCHOOL_PERIODS sp WHERE sp.SCHOOL_ID='" . UserSchool() . "' AND sp.SYEAR='" . UserSyear() . "' AND EXISTS (SELECT '' FROM COURSE_PERIODS WHERE SYEAR=sp.SYEAR AND PERIOD_ID=sp.PERIOD_ID AND position(',{$_REQUEST['table']},' IN DOES_ATTENDANCE)>0) ORDER BY sp.SORT_ORDER");
$periods_RET = DBGet($QI, array(), array('PERIOD_ID'));
$period_select = "<SELECT name=period onChange='this.form.submit();'><OPTION value=''>" > _('All') . "</OPTION>";
foreach ($periods_RET as $id => $period) {
$period_select .= "<OPTION value={$id}" . ($_REQUEST['period'] == $id ? ' SELECTED' : '') . ">" . $period[1]['TITLE'] . "</OPTION>";
}
$period_select .= "</SELECT>";
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
DrawHeader(PrepareDate($date, '_date', false, array('submit' => true)) . ' - ' . $period_select, $category_select);
echo '</FORM>';
$daysWeek = _('SuMoTuWeThFrSa');
/// Days of the week
$sql = "SELECT s.STAFF_ID,s.LAST_NAME||', '||s.FIRST_NAME AS FULL_NAME,sp.TITLE,cp.PERIOD_ID,cp.TITLE AS COURSE_TITLE,\n\t\t(SELECT 'Y' FROM ATTENDANCE_COMPLETED ac WHERE ac.STAFF_ID=cp.TEACHER_ID AND ac.SCHOOL_DATE=acc.SCHOOL_DATE AND ac.PERIOD_ID=sp.PERIOD_ID AND TABLE_NAME='{$_REQUEST['table']}') AS COMPLETED\n\t\tFROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp,ATTENDANCE_CALENDAR acc\n\t\tWHERE\n\t\t\tsp.PERIOD_ID = cp.PERIOD_ID AND position(',{$_REQUEST['table']},' IN cp.DOES_ATTENDANCE)>0\n\t\t\tAND cp.TEACHER_ID=s.STAFF_ID AND cp.MARKING_PERIOD_ID IN (" . GetAllMP('QTR', GetCurrentMP('QTR', $date)) . ")\n\t\t\tAND cp.SYEAR='" . UserSyear() . "' AND cp.SCHOOL_ID='" . UserSchool() . "' AND s.PROFILE='teacher'\n\t\t\t" . ($_REQUEST['period'] ? " AND cp.PERIOD_ID='{$_REQUEST['period']}'" : '') . " AND acc.CALENDAR_ID=cp.CALENDAR_ID AND acc.SCHOOL_DATE='{$date}'\n\t\t\tAND acc.SYEAR='" . UserSyear() . "' AND (acc.MINUTES IS NOT NULL AND acc.MINUTES>0)\n\t\t\tAND (sp.BLOCK IS NULL AND position(substring('{$daysWeek}' FROM cast(extract(DOW FROM acc.SCHOOL_DATE) AS INT)*2+1 FOR 2) IN cp.DAYS)>0\n\t\t\tOR sp.BLOCK IS NOT NULL AND acc.BLOCK IS NOT NULL AND sp.BLOCK=acc.BLOCK)\n\t\tORDER BY FULL_NAME";
$RET = DBGet(DBQuery($sql), array(), array('STAFF_ID'));
if (!$_REQUEST['period']) {
foreach ($RET as $staff_id => $periods) {
$i++;
$staff_RET[$i]['FULL_NAME'] = $periods[1]['FULL_NAME'];
foreach ($periods as $period) {
if (!$_REQUEST['_CENTRE_PDF']) {
$staff_RET[$i][$period['PERIOD_ID']] .= button($period['COMPLETED'] == 'Y' ? 'check' : 'x', '', '# onMouseOver=\'stm(["Course Title","' . $period['COURSE_TITLE'] . '"],["white","#006699","","","",,"black","#e8e8ff","","","",,,,2,"#006699",2,,,,,"",,,,]);\' onMouseOut=\'htm()\'') . ' ';
} else {
$staff_RET[$i][$period['PERIOD_ID']] = ($period['COMPLETED'] == 'Y' ? _('Yes') : _('No')) . " ";
}
$columns = $LO_columns;
}
if (count($students_RET) > 0) {
echo '<TABLE><TR><TD>Drop Date</TD><TD>' . PrepareDate(DBDate(), '') . '</TD></TR></TABLE>';
}
if (count($students_RET) > 1 || $link['add'] || !$link['FULL_NAME'] || $extra['columns_before'] || $extra['columns_after'] || $extra['BackPrompt'] == false && count($students_RET) == 0 || $extra['Redirect'] === false && count($students_RET) == 1) {
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['expanded_view']);
if ($_REQUEST['expanded_view'] != 'true' && !UserStudentID() && count($students_RET) != 0) {
DrawHeader("<div><A HREF=" . PreparePHP_SELF($tmp_REQUEST) . "&expanded_view=true class=big_font ><img src=\"themes/blue/expanded_view.png\" />Expanded View</A></div><div class=break ></div>", $extra['header_right']);
DrawHeader(str_replace('<BR>', '<BR> ', substr($_openSIS['SearchTerms'], 0, -4)));
} elseif (!UserStudentID() && count($students_RET) != 0) {
DrawHeader("<div><A HREF=" . PreparePHP_SELF($tmp_REQUEST) . "&expanded_view=false class=big_font><img src=\"themes/blue/expanded_view.png\" />Original View</A></div><div class=break ></div>", $extra['header_right']);
DrawHeader(str_replace('<BR>', '<BR> ', substr($_openSIS['Search'], 0, -4)));
}
DrawHeader($extra['extra_header_left'], $extra['extra_header_right']);
if ($_REQUEST['LO_save'] != '1' && !$extra['suppress_save']) {
$_SESSION['List_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars']);
echo '<script language=JavaScript>parent.help.location.reload();</script>';
}
if (!$extra['singular'] || !$extra['plural']) {
$extra['singular'] = 'Student';
}
$extra['plural'] = 'Students';
echo "<div id='students' >";
ListOutput($students_RET, $columns, $extra['singular'], $extra['plural'], $link, $extra['LO_group'], $extra['options']);
echo "</div>";
}
if (count($students_RET) > 0) {
echo '<BR><CENTER>' . SubmitButton('', '', 'class=btn_group_drops onclick=\'formload_ajax("ww");\'') . '</CENTER>';
echo "</FORM>";
}
foreach ($custom_RET1[$category['ID']] as $field) {
$fields_list[$category['TITLE']]['CUSTOM_' . $field['ID']] = $field['TITLE'];
}
}
}
$periods_RET = DBGet(DBQuery("SELECT TITLE,PERIOD_ID FROM SCHOOL_PERIODS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
foreach ($periods_RET as $period) {
$fields_list['Schedule']['PERIOD_' . $period['PERIOD_ID']] = $period['TITLE'] . ' Teacher - Room';
}
if ($openSISModules['Food_Service']) {
$fields_list['Food_Service'] = array('FS_ACCOUNT_ID' => 'Account ID', 'FS_DISCOUNT' => 'Discount', 'FS_STATUS' => 'Status', 'FS_BARCODE' => 'Barcode', 'FS_BALANCE' => 'Balance');
}
DrawHeader('<OL><SPAN id=names_div></SPAN></OL>');
echo '<TABLE><TR><TD valign=top>';
DrawHeader("<div><a class=big_font><img src=\"themes/Blue/expanded_view.png\" />Select Fields To Generate Report</a></div>", $extra['header_right']);
PopTable_wo_header('header');
echo '<TABLE><TR>';
foreach ($fields_list as $category => $fields) {
echo '<TD colspan=2 class=break_headers ><b>' . $category . '<BR></b></TD></TR><TR>';
foreach ($fields as $field => $title) {
$i++;
echo '<TD><INPUT type=checkbox onclick="addHTML(\'<LI>' . $title . '</LI>\',\'names_div\',false);addHTML(\'<INPUT type=hidden name=fields[' . $field . '] value=Y>\',\'fields_div\',false);this.disabled=true">' . $title . ($field == 'PARENTS' ? '<BR>(<small>Relation: </small><input type=text id=relation name=relation size=8>)' : '') . '</TD>';
if ($i % 2 == 0) {
echo '</TR><TR>';
}
}
if ($i % 2 != 0) {
echo '<TD></TD></TR><TR>';
$i++;
}
if ($_SCHEDULER['student_id']) {
$link = "<A HREF=Modules.php?modname=Scheduling/Schedule.php>View this student's Schedule</A>";
} else {
$link = "<A HREF=Modules.php?modname=Scheduling/ScheduleReport.php>View the Schedule Report</A>";
}
DrawHeader($message, $link);
} elseif ($_SCHEDULER['student_id']) {
if (!$count) {
$message = "<IMG SRC=assets/check.gif>All of this student's requests can be filled";
}
DrawHeader($message, "<A HREF=Modules.php?modname=Scheduling/Scheduler.php&run=true&_SCHEDULER_student_id={$_SCHEDULER['student_id']}>Run the Scheduler for this student</A>");
} else {
if (!$count) {
$message = '<IMG SRC=assets/check.gif>All students\' requests can be filled';
}
DrawHeader($message, "<A HREF=Modules.php?modname=Scheduling/Scheduler.php&run=true>Run the Scheduler</A>");
}
}
function findMatch($matches, $request_id, $request)
{
global $insert, $requests_done, $requests_undone, $periods_RET, $mp_RET, $periods_done;
// FIND THE BEST MATCH
if (count($matches)) {
$best = $matches[0];
foreach ($matches as $period) {
if ($period[1]['AVAILABLE_SEATS'] > $best[1]['AVAILABLE_SEATS']) {
$best = $period;
}
}
// PERIOD HAS MEET ALL OF THE CRITERIA, SO ADD IT.
$periods_RET[$request['COURSE_ID']][$request['COURSE_WEIGHT']][$best[1]['COURSE_PERIOD_ID']][1]['AVAILABLE_SEATS']--;
DrawHeaderHome(ProgramTitle());
if ($today > $END_DAY || $today < $START_DAY || $today == $START_DAY && date('Gi') < $START_HOUR . $START_MINUTE || $today == $END_DAY && date('Gi') > $END_HOUR . $END_MINUTE) {
if ($START_HOUR > 12) {
$START_HOUR -= 12;
$START_M = 'PM';
} else {
$START_M = 'AM';
}
if ($END_HOUR > 12) {
$END_HOUR -= 12;
$END_M = 'PM';
} else {
$END_M = 'AM';
}
echo ErrorMessage(array('You can only enter eligibility from ' . $days[$START_DAY] . ' ' . $START_HOUR . ':' . $START_MINUTE . ' ' . $START_M . ' to ' . $days[$END_DAY] . ' ' . $END_HOUR . ':' . $END_MINUTE . ' ' . $END_M), 'error');
} else {
DrawHeader("<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=gradebook>Use Gradebook Grades</A>", '<INPUT type=submit class=btn_medium value=Save>');
$LO_columns = array('FULL_NAME' => 'Student', 'STUDENT_ID' => 'Student ID', 'GRADE_ID' => 'Grade') + $columns;
ListOutput($stu_RET, $LO_columns, 'Student', 'Students');
echo '<br><CENTER><INPUT type=submit class=btn_medium value=Save></CENTER>';
}
echo "</FORM>";
function makeRadio($value, $title)
{
global $THIS_RET, $current_RET;
if (isset($current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE']) && $current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE'] == $title || $title == 'PASSING' && !$current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE']) {
return "<INPUT type=radio name=values[" . $THIS_RET['STUDENT_ID'] . "] value='{$title}' CHECKED>";
} else {
return "<INPUT type=radio name=values[" . $THIS_RET['STUDENT_ID'] . "] value='{$title}'>";
}
}
# This program is released under the terms of the GNU General Public License as
# published by the Free Software Foundation, version 2 of the License.
# See license.txt.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include '../../Redirect_modules.php';
DrawBC("" . _('Attendance') . " > " . ProgramTitle());
$message = '<TABLE><TR><TD colspan=7 align=center>' . _('From') . ' ' . PrepareDate(DBDate(), '_min') . ' ' . _('to') . ' ' . PrepareDate(DBDate(), '_max') . '</TD></TR></TABLE>';
if (Prompt_Home(_('Confirm'), _('When do you want to recalculate the daily attendance?'), $message)) {
$current_RET = DBGet(DBQuery('SELECT DISTINCT DATE_FORMAT(SCHOOL_DATE,\'%d-%m-%Y\') as SCHOOL_DATE FROM attendance_calendar WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\''), array(), array('SCHOOL_DATE'));
$students_RET = GetStuList();
$begin = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_min'], 'to_num'), $_REQUEST['day_min'] * 1, $_REQUEST['year_min']) + 43200;
$end = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_max'], 'to_num'), $_REQUEST['day_max'] * 1, $_REQUEST['year_max']) + 43200;
for ($i = $begin; $i <= $end; $i += 86400) {
if ($current_RET[strtoupper(date('d-M-y', $i))]) {
foreach ($students_RET as $student) {
UpdateAttendanceDaily($student['STUDENT_ID'], date('d-M-y', $i));
}
}
}
unset($_REQUEST['modfunc']);
DrawHeader('<table><tr><td><IMG SRC=assets/check.gif></td><td>' . _('The Daily Attendance for that timeframe has been recalculated.') . '</td></tr></table>');
}
$semesters_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE FROM SCHOOL_SEMESTERS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
$quarters_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE FROM SCHOOL_QUARTERS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
echo "<OPTION value=" . $year_RET[1]['MARKING_PERIOD_ID'] . ">" . $year_RET[1]['TITLE'] . '</OPTION>';
foreach ($semesters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
foreach ($quarters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
echo '</SELECT>';
echo '</TD></TR>';
echo '</TABLE>';
PopTable('footer');
}
if ($note) {
DrawHeader('<table><tr><td><IMG SRC=assets/check.gif></td><td>GPA and class rank for ' . $note . '</td></tr></table>');
}
}
if (!$_REQUEST['modfunc']) {
if ($_REQUEST['search_modfunc'] != 'list') {
unset($_SESSION['MassDrops.php']);
}
$extra['link'] = array('FULL_NAME' => false);
$extra['SELECT'] = ",CAST(NULL AS CHAR(1)) AS CHECKBOX";
$extra['functions'] = array('CHECKBOX' => '_makeChooseCheckbox');
$extra['columns_before'] = array('CHECKBOX' => '</A><INPUT type=checkbox value=Y name=controller onclick="checkAll(this.form,this.form.controller.checked,\'student\');"><A>');
$extra['new'] = true;
Widgets('course');
Widgets('request');
Widgets('activity');
Search('student_id', $extra);
foreach ($_REQUEST['values'] as $key => $value) {
if (isset(${$key})) {
DBQuery("UPDATE PROGRAM_CONFIG SET VALUE='{$value}' WHERE PROGRAM='eligibility' AND TITLE='{$key}' AND SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'");
} else {
DBQuery("INSERT INTO PROGRAM_CONFIG (SYEAR,SCHOOL_ID,PROGRAM,TITLE,VALUE) values('" . UserSyear() . "','" . UserSchool() . "','eligibility','{$key}','{$value}')");
}
}
}
$start_end_RET = DBGet(DBQuery("SELECT TITLE,VALUE FROM PROGRAM_CONFIG WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND PROGRAM='eligibility'"));
if (count($start_end_RET)) {
foreach ($start_end_RET as $value) {
${$value}['TITLE'] = $value['VALUE'];
}
}
}
DrawHeader(ProgramTitle());
echo '<BR>';
$days = array(_('Sunday'), _('Monday'), _('Tuesday'), _('Wednesday'), _('Thursday'), _('Friday'), _('Saturday'));
for ($i = 0; $i < 7; $i++) {
$day_options[$i] = $days[$i];
}
for ($i = 1; $i <= 11; $i++) {
$hour_options[$i] = $i;
}
$hour_options['0'] = '12';
for ($i = 0; $i <= 9; $i++) {
$minute_options[$i] = '0' . $i;
}
for ($i = 10; $i <= 59; $i++) {
$minute_options[$i] = $i;
}
$header .= '<TR><td class=lable>Short Name</td><TD>' . TextInput($RET['SHORT_NAME'], 'tables[' . $_REQUEST['marking_period_id'] . '][SHORT_NAME]', '', 'class=cell_floating') . '</TD></tr>';
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown="return numberOnly(event);"') . '</TD></tr>';
} else {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown=\\"return numberOnly(event);\\"') . '</TD></tr>';
}
$header .= '<TR><td class=lable>Graded</td><TD>' . CheckboxInput($RET['DOES_GRADES'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
$header .= '<TR><td class=lable>Exam</td><TD>' . CheckboxInput($RET['DOES_EXAM'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_EXAM]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
$header .= '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
$header .= '<TR><td class=lable>Begins</td><TD>' . DateInput($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', '') . '</TD></tr>';
$header .= '<TR><td class=lable>Ends</td><TD>' . DateInput($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', '') . '</TD></tr>';
$header .= '<TR><td class=lable>Grade Posting Begins</td><TD>' . DateInput($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', '') . '</TD></tr>';
$str_srch = '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>') . '</TD></tr>';
$header .= '<TR><td class=lable>Grade Posting Ends</td><TD>' . DateInput($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', '') . '</TD></tr>';
$header .= '</TABLE>';
DrawHeader($header);
PopTable('footer');
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit value=Save class="btn_medium" onclick="formcheck_school_setup_marking();">' : '');
} elseif ($_REQUEST['mp_term'] != 'FY') {
DrawHeaderHome('', '', AllowEdit() ? $delete_button . ' <INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">' : '');
} else {
DrawHeaderHome('', '', '<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">');
}
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['marking_period_id']);
unset($_SESSION['_REQUEST_vars']['mp_term']);
}
// DISPLAY THE MENU
$LO_options = array('save' => false, 'search' => false);
echo '<TABLE cellpadding=3 width=100%><tr><td align="center"><br>';
echo '</td></tr></table>';
echo "<div style=\"page-break-before: always;\"></div>";
}
}
/*
if(count($ret))
{
foreach($ret as $s_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;\">Course Catalog</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 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>';
echo '<tr><td colspan="2" valign="top" align="right"><table border="0" width="97%"><tr><td>';
echo '</td></tr></table></td></tr></table></td></tr></table></td></tr>';
echo '</table></div>';
echo "<div style=\"page-break-before: always;\"></div>";
}
}
*/
} else {
PopTable('header', 'Print all Courses', 'width=700');
DrawHeader('<div align="center">Report Generated</div>');
echo "<FORM name=exp id=exp action=for_export.php?modname={$_REQUEST['modname']}&modfunc=print_all&_openSIS_PDF=true&report=true method=POST target=_blank>";
echo '<table width=100%><tr><td align="center"><INPUT type=submit class=btn_medium value=\'Print\'></td></tr></table>';
echo '</form>';
PopTable('footer');
}
function mySearch($extra)
{
// echo "<FORM action=Modules.php?modname=$_REQUEST[modname]&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST>";
// echo "<FORM name=exp id=exp action=for_export.php?modname=$_REQUEST[modname]&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST target=_blank>";
echo "<FORM name=exp id=exp action=for_export.php?modname={$_REQUEST['modname']}&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST target=_blank>";
echo '<DIV id=fields_div></DIV>';
DrawHeader('', $extra['header_right']);
DrawHeader($extra['extra_header_left'], $extra['extra_header_right']);
if (User('PROFILE') == 'admin') {
if ($_REQUEST['teacher_id']) {
$where .= " AND cp.TEACHER_ID='{$_REQUEST['teacher_id']}'";
}
if ($_REQUEST['first']) {
$where .= " AND UPPER(s.FIRST_NAME) LIKE '" . strtoupper($_REQUEST['first']) . "%'";
}
if ($_REQUEST['w_course_period_id'] && $_REQUEST['w_course_period_id_which'] != 'course') {
$where .= " AND cp.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "'";
}
if ($_REQUEST['subject_id']) {
$from .= ",COURSES c";
$where .= " AND c.COURSE_ID=cp.COURSE_ID AND c.SUBJECT_ID='" . $_REQUEST['subject_id'] . "'";
}
if ($_REQUEST['period_id']) {
$where .= " AND cp.PERIOD_ID='" . $_REQUEST['period_id'] . "'";
}
$sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE FROM COURSE_PERIODS cp{$from} WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "'{$where}";
} else {
$sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE FROM COURSE_PERIODS cp WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "' AND cp.TEACHER_ID='" . User('STAFF_ID') . "'";
}
$sql .= ' ORDER BY (SELECT SORT_ORDER FROM SCHOOL_PERIODS WHERE PERIOD_ID=cp.PERIOD_ID)';
$course_periods_RET = DBGet(DBQuery($sql), array('COURSE_PERIOD_ID' => '_makeChooseCheckbox'));
$LO_columns = array('COURSE_PERIOD_ID' => '</A><INPUT type=checkbox value=Y name=controller checked onclick="checkAll(this.form,this.form.controller.checked,\'cp_arr\');"><A>', 'TITLE' => 'Course Period');
echo '<INPUT type=hidden name=relation>';
ListOutput($course_periods_RET, $LO_columns, 'Course Period', 'Course Periods');
// echo '<BR><CENTER><INPUT type=submit class=btn_xxlarge value=\'Create Class Lists for Selected Course Periods\' onclick=\'formload_ajax("exp");\'></CENTER>';
echo '<BR><CENTER><INPUT type=submit class=btn_xxlarge value=\'Create Class Lists for Selected Course Periods\'></CENTER>';
echo "</FORM>";
}
$period_select .= "<OPTION value='na' selected>N/A</OPTION>";
foreach ($RET as $period) {
//
$period_select .= "<OPTION value={$period['ID']}" . (CpvId() == $period['ID'] ? ' SELECTED' : '') . ">" . $period['SHORT_NAME'] . ($period['MARKING_PERIOD_ID'] != $fy_id ? ' ' . GetMP($period['MARKING_PERIOD_ID'], 'SHORT_NAME') : '') . (strlen($period['DAYS']) < 5 ? ' ' . $period['DAYS'] : '') . ' - ' . $period['COURSE_TITLE'] . "</OPTION>";
//
if (CpvId() == $period['ID']) {
$_SESSION['UserPeriod'] = $period['PERIOD_ID'];
}
}
$period_select .= "</SELECT>";
}
}
}
$profile = DBGet(DBQuery('SELECT PROFILE FROM staff WHERE STAFF_ID=' . UserID()));
if ($profile[1]['PROFILE'] == "admin") {
DrawHeader($period_select);
}
echo '</FORM><BR>';
unset($_openSIS['DrawHeader']);
$_openSIS['allow_edit'] = AllowEdit($_REQUEST['modname']);
$_openSIS['User'] = array(1 => array('STAFF_ID' => UserStaffID(), 'NAME' => GetTeacher(UserStaffID()), 'USERNAME' => GetTeacher(UserStaffID(), '', 'USERNAME'), 'PROFILE' => 'teacher', 'SCHOOLS' => ',' . UserSchool() . ',', 'SYEAR' => UserSyear()));
echo '<CENTER><TABLE width=100% ><TR><TD>';
include 'modules/' . $_REQUEST['include'];
echo '</TD></TR></TABLE></CENTER>';
}
}
?>
<script type="text/javascript">
function close_window()
{
window.close();
if (is_array($extra['columns_after'])) {
$columns = $LO_columns + $extra['columns_after'];
}
if (!$extra['columns_before'] && !$extra['columns_after']) {
$columns = $LO_columns;
}
if (count($students_RET) > 1 || $link['add'] || !$link['FULL_NAME'] || $extra['columns_before'] || $extra['columns_after'] || $extra['BackPrompt'] == false && count($students_RET) == 0 || $extra['Redirect'] === false && count($students_RET) == 1) {
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['expanded_view']);
if ($_REQUEST['expanded_view'] != 'true' && !UserStudentID() && count($students_RET) != 0) {
DrawHeader("<div><A HREF=" . PreparePHP_SELF($tmp_REQUEST) . "&expanded_view=true class=big_font ><img src=\"themes/Blue/expanded_view.png\" />Expanded View</A></div><div class=break ></div>", $extra['header_right']);
} elseif (!UserStudentID() && count($students_RET) != 0) {
DrawHeader("<div><A HREF=" . PreparePHP_SELF($tmp_REQUEST) . "&expanded_view=false class=big_font><img src=\"themes/Blue/expanded_view.png\" />Original View</A></div><div class=break ></div>", $extra['header_right']);
}
DrawHeader($extra['extra_header_left'], $extra['extra_header_right']);
DrawHeader(str_replace('<BR>', '<BR> ', substr($_CENTRE['SearchTerms'], 0, -4)));
if ($_REQUEST['LO_save'] != '1' && !$extra['suppress_save']) {
$_SESSION['List_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars']);
echo '<script language=JavaScript>parent.help.location.reload();</script>';
}
if (!$extra['singular'] || !$extra['plural']) {
if ($_REQUEST['address_group']) {
$extra['singular'] = 'Family';
$extra['plural'] = 'Families';
} else {
$extra['singular'] = 'Student';
$extra['plural'] = 'Students';
}
}
echo "<div id='students' >";
ListOutput($students_RET, $columns, $extra['singular'], $extra['plural'], $link, $extra['LO_group'], $extra['options']);
$semesters_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE,NULL AS SEMESTER_ID FROM SCHOOL_SEMESTERS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
$quarters_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE,SEMESTER_ID FROM SCHOOL_QUARTERS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
echo '<SELECT name=marking_period_id><OPTION value=' . $years_RET[1]['MARKING_PERIOD_ID'] . '>' . $years_RET[1]['TITLE'] . '</OPTION>';
foreach ($semesters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
foreach ($quarters_RET as $mp) {
echo "<OPTION value={$mp['MARKING_PERIOD_ID']}>" . $mp['TITLE'] . '</OPTION>';
}
echo '</SELECT>';
echo '</TD></TR>';
echo '</TABLE>';
PopTable('footer');
}
if ($note) {
DrawHeader('<IMG SRC=assets/check.gif>' . $note);
}
if ($check_seats <= 0 && $no_seat) {
DrawHeaderHome('<IMG SRC=assets/warning_button.gif>' . $no_seat);
}
if ($clash) {
DrawHeaderHome('<IMG SRC=assets/warning_button.gif>' . $clash . " is already in the schedule");
}
if ($request_exists) {
DrawHeaderHome('<IMG SRC=assets/warning_button.gif>' . $request_clash . ' already have unscheduled requests');
}
}
if (!$_REQUEST['modfunc']) {
if ($_REQUEST['search_modfunc'] != 'list') {
unset($_SESSION['MassSchedule.php']);
}
}
$RET = DBGet(DBQuery("SELECT 'completed' AS COMPLETED FROM ELIGIBILITY_COMPLETED WHERE STAFF_ID='" . User('STAFF_ID') . "' AND SCHOOL_DATE BETWEEN '{$start_date}' AND '{$end_date}' AND PERIOD_ID='" . UserPeriod() . "'"));
if (!count($RET)) {
DBQuery("INSERT INTO ELIGIBILITY_COMPLETED (STAFF_ID,SCHOOL_DATE,PERIOD_ID) values('" . User('STAFF_ID') . "','" . DBDate() . "','" . UserPeriod() . "')");
}
$current_RET = DBGet(DBQuery("SELECT ELIGIBILITY_CODE,STUDENT_ID FROM ELIGIBILITY WHERE SCHOOL_DATE BETWEEN '{$start_date}' AND '{$end_date}' AND PERIOD_ID='" . UserPeriod() . "'"), array(), array('STUDENT_ID'));
}
$extra['SELECT'] .= ",'' AS PASSING,'' AS BORDERLINE,'' AS FAILING,'' AS INCOMPLETE";
$extra['functions'] = array('PASSING' => 'makeRadio', 'BORDERLINE' => 'makeRadio', 'FAILING' => 'makeRadio', 'INCOMPLETE' => 'makeRadio');
$columns = array('PASSING' => _('Passing'), 'BORDERLINE' => _('Borderline'), 'FAILING' => _('Failing'), 'INCOMPLETE' => _('Incomplete'));
$stu_RET = GetStuList($extra);
echo "<FORM ACTION=Modules.php?modname={$_REQUEST['modname']} method=POST>";
DrawHeader(ProgramTitle());
if ($today > $END_DAY || $today < $START_DAY || $today == $START_DAY && date('Gi') < $START_HOUR . $START_MINUTE || $today == $END_DAY && date('Gi') > $END_HOUR . $END_MINUTE) {
echo ErrorMessage(array(sprintf(_('You can only enter eligibility from %s %s to %s %s.'), $days[$START_DAY], Localize('time', array('hour' => $START_HOUR, 'minute' => $START_MINUTE)), $days[$END_DAY], Localize('time', array('hour' => $END_HOUR, 'minute' => $END_MINUTE)))), 'error');
} else {
DrawHeader("<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=gradebook>" . _('Use Gradebook Grades') . "</A>", '<INPUT type=submit value="' . _('Save') . '">');
$LO_columns = array('FULL_NAME' => _('Student'), 'STUDENT_ID' => _('Centre ID'), 'GRADE_ID' => _('Grade')) + $columns;
ListOutput($stu_RET, $LO_columns, _('Student'), _('Students'));
echo '<CENTER><INPUT type=submit value="' . _('Save') . '"></CENTER>';
}
echo "</FORM>";
function makeRadio($value, $title)
{
global $THIS_RET, $current_RET;
if (isset($current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE']) && $current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE'] == $title || $title == 'PASSING' && !$current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE']) {
return "<INPUT type=radio name=values[" . $THIS_RET['STUDENT_ID'] . "] value='{$title}' CHECKED>";
} else {
return "<INPUT type=radio name=values[" . $THIS_RET['STUDENT_ID'] . "] value='{$title}'>";
}
}
<?php
DrawHeader('Pre-Defined Student Billing Fees');
if ($_REQUEST[modfunc] == 'update') {
$_REQUEST['date'] = $_REQUEST['day'] . '-' . $_REQUEST['month'] . '-' . $_REQUEST['year'];
if ($_REQUEST['date'] == '--') {
$_REQUEST['date'] = '';
}
$effective_date = DBDate();
$sql = "INSERT INTO STU_BILLING_DEFINED_FEES (ID,ACCOUNT_ID,TITLE,AMOUNT,DUE_DATE,SYEAR,SCHOOL,GRADE) \n\t\t\tvalues(" . db_seq_nextval('STU_BILLING_DEFINED_FEES_SEQ') . ",'{$_REQUEST['account_id']}','{$_REQUEST['title']}','{$_REQUEST['amount']}','{$_REQUEST['date']}','{$_REQUEST['syear']}','{$_REQUEST['school']}','{$_REQUEST['grade']}')";
DBQuery($sql);
$note[] = 'That Pre-Defined Fee has been added';
unset($_REQUEST[modfunc]);
}
if ($_REQUEST[modfunc] == 'delete') {
if (DeletePrompt('pre-defined fee')) {
DBQuery("DELETE FROM STU_BILLING_DEFINED_FEES WHERE ID='{$_REQUEST['id']}'");
$note[] = "That Pre-Defined Fee has been Deleted";
unset($_REQUEST[modfunc]);
}
}
if (!$_REQUEST[modfunc]) {
// LIST
if ($note) {
echo '<TABLE width=100%><TR><TD bgcolor=#E8E8E9><font size=-1>';
ErrorMessage($note, 'note');
echo '</font></TD></TR></TABLE>';
}
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update METHOD=POST>";
$functions = array('AMOUNT' => 'Currency', 'ACCOUNT_ID' => 'getAccount', 'DUE_DATE' => 'ProperDate', 'SYEAR' => 'DispYear', 'SCHOOL' => 'GetSchool', 'GRADE' => 'GetGrade');
$RET = DBGet(DBQuery('SELECT DISTINCT sb.ID,sb.TITLE,sb.AMOUNT,
unset($_openSIS['User']);
echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
}
}
$extra['SELECT'] = ',LAST_LOGIN';
$extra['columns_after'] = array('LAST_LOGIN' => 'Last Login');
$extra['functions'] = array('LAST_LOGIN' => 'makeLogin');
if (basename($_SERVER['PHP_SELF']) != 'index.php') {
if ($_REQUEST['staff_id'] == 'new') {
DrawBC("Users > Add a User");
} else {
DrawBC("Users > " . ProgramTitle());
}
SearchStaff('staff_id', $extra);
} else {
DrawHeader('Create Account');
}
if ($_REQUEST['modfunc'] == 'delete' && basename($_SERVER['PHP_SELF']) != 'index.php' && AllowEdit()) {
# ------------------------------------ For Certification Start ------------------------------------------- #
if (DeletePrompt('certification')) {
DBQuery("DELETE FROM staff_certification WHERE STAFF_CERTIFICATION_ID='{$_REQUEST['certification_id']}'");
unset($_REQUEST['modfunc']);
$_REQUEST['certification_id'] = 'new';
}
}
if ((UserStaffID() || $_REQUEST['staff_id'] == 'new') && (basename($_SERVER['PHP_SELF']) != 'index.php' || !$_REQUEST['staff']['USERNAME']) && $_REQUEST['modfunc'] != 'delete' && $_SESSION['fn'] != 'user' && $_REQUEST['modfunc'] != 'remove') {
if ($_REQUEST['modfunc'] != 'delete' || $_REQUEST['delete_ok'] == '1') {
if ($_REQUEST['staff_id'] != 'new') {
$sql = "SELECT * FROM staff WHERE STAFF_ID='" . UserStaffID() . "'";
$QI = DBQuery($sql);
$staff = DBGet($QI);
$values = "'" . $id . "','" . UserStaffID() . "','" . UserSyear() . "','" . UserSchool() . "',(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID='" . UserStaffID() . "'),CURRENT_TIMESTAMP,'" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "','" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . ' - ' . DBDate() . "','" . User('STAFF_ID') . "'";
$sql2 = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTIONS (' . $fields . ') values (' . $values . ')';
DBQuery('BEGIN; ' . $sql1 . '; ' . $sql2 . '; COMMIT');
unset($_SESSION['FSA_sale']);
}
unset($_REQUEST['modfunc']);
} else {
unset($_REQUEST['modfunc']);
}
unset($_REQUEST['submit']);
}
if (UserStaffID() && !$_REQUEST['modfunc']) {
$staff = DBGet(DBQuery("SELECT s.STAFF_ID,s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME,(SELECT STAFF_ID FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS ACCOUNT_ID,(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS BALANCE FROM STAFF s WHERE s.STAFF_ID='" . UserStaffID() . "'"));
$staff = $staff[1];
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=submit&menu_id={$_REQUEST['menu_id']} method=POST>";
DrawHeader('', SubmitButton(_('Cancel Sale'), 'submit[cancel]') . SubmitButton(_('Complete Sale'), 'submit[save]'));
echo '</FORM>';
echo '<TABLE width=100%><TR>';
echo '<TD valign=top>' . NoInput($staff['FULL_NAME'], $staff['STAFF_ID']) . '</TD>';
echo '<TD valign=top>' . NoInput(red($staff['BALANCE']), _('Balance')) . '</TD>';
echo '</TR></TABLE>';
echo '<HR>';
if ($staff['ACCOUNT_ID'] && $staff['BALANCE'] != '') {
echo '<TABLE border=0 width=100%>';
echo '<TR><TD width=100% valign=top>';
$RET = DBGet(DBQuery("SELECT fsti.DESCRIPTION,fsti.AMOUNT FROM FOOD_SERVICE_STAFF_TRANSACTIONS fst,FOOD_SERVICE_STAFF_TRANSACTION_ITEMS fsti WHERE fst.STAFF_ID='" . UserStaffID() . "' AND fst.SYEAR='" . UserSyear() . "' AND fst.SHORT_NAME='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' AND fst.TIMESTAMP BETWEEN CURRENT_DATE AND CURRENT_DATE+1 AND fsti.TRANSACTION_ID=fst.TRANSACTION_ID"));
$columns = array('DESCRIPTION' => _('Item'), 'AMOUNT' => _('Amount'));
$singular = sprintf(_('Earlier %s Sale'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
$plural = sprintf(_('Earlier %s Sales'), $menus_RET[$_REQUEST['menu_id']][1]['TITLE']);
ListOutput($RET, $columns, $singular, $plural, $link, false, array('save' => false, 'search' => false));
// IMAGE
$prev_mp = $prev_mp[1];
if ($prev_mp) {
$gb_header .= " | <A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=grades&mp={$_REQUEST['mp']}&prev_mp={$prev_mp['MARKING_PERIOD_ID']}&use_percents=false>Get {$prev_mp['TITLE']} Grades</A>";
$gb_header .= " | <A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=comments&mp={$_REQUEST['mp']}&prev_mp={$prev_mp['MARKING_PERIOD_ID']}&use_percents=false>Get {$prev_mp['TITLE']} Comments</A>";
}
}
$bar = ' | ';
if (substr($_REQUEST['mp'], 0, 1) == 'E' && $not_graded == true) {
$bar = '';
}
$gb_header .= "{$bar}<A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=clearall&mp={$_REQUEST['mp']}&use_percents={$_REQUEST['use_percents']}>Clear All</A>";
}
DrawHeader($gb_header, $tipmessage);
} else {
DrawHeader($course_title);
DrawHeader(GetMP(UserMP()));
}
$columns = array('FULL_NAME' => 'Student', 'STUDENT_ID' => 'Student ID');
if ($_REQUEST['include_inactive'] == 'Y') {
$columns += array('ACTIVE' => 'School Status', 'ACTIVE_SCHEDULE' => 'Course Status');
}
if ($_REQUEST['use_percents'] != 'true') {
$columns += array('GRADE_PERCENT' => 'Percent', 'REPORT_CARD_GRADE' => 'Assign Grade');
} elseif ($not_graded) {
$columns += array('GRADE_PERCENT' => 'Assign Percent');
} else {
$columns += array('REPORT_CARD_GRADE' => 'Grade', 'GRADE_PERCENT' => 'Assign Percent');
}
/////////////////sg customization/////////////////////
if ($course_RET[1]['USE_STANDARDS'] == "Y") {
$columns += array('STANDARDS' => 'Standards');
if ($START_HOUR > 12) {
$START_HOUR -= 12;
$START_M = 'PM';
} else {
$START_M = 'AM';
}
if ($END_HOUR > 12) {
$END_HOUR -= 12;
$END_M = 'PM';
} else {
$END_M = 'AM';
}
echo ErrorMessage(array('' . _('You can only enter eligibility from') . '' . $days[$START_DAY] . ' ' . $START_HOUR . ':' . $START_MINUTE . ' ' . $START_M . ' ' . _('to') . ' ' . $days[$END_DAY] . ' ' . $END_HOUR . ':' . $END_MINUTE . ' ' . $END_M), 'error');
} else {
if (count($stu_RET) != 0) {
DrawHeader("<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=gradebook>" . _('Use Gradebook Grades') . "</A>", '<INPUT type=submit class=btn_medium value=' . _("Save") . '>');
}
$LO_columns = array('FULL_NAME' => '' . _('Student') . '', 'STUDENT_ID' => '' . _('Student ID') . '', 'GRADE_ID' => '' . _('Grade') . '') + $columns;
ListOutput($stu_RET, $LO_columns, _('Student'), _('Students'));
if (count($stu_RET) != 0) {
echo '<br><CENTER><INPUT type=submit class=btn_medium value=' . _('Save') . '></CENTER>';
}
}
echo "</FORM>";
function makeRadio($value, $title)
{
$colors = array('PASSING' => '#00FF00', 'BORDERLINE' => '#FF0000', 'FAILING' => '#FFCC00', 'INCOMPLETE' => '#0000FF');
global $THIS_RET, $current_RET;
if (isset($current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE']) && $current_RET[$THIS_RET['STUDENT_ID']][1]['ELIGIBILITY_CODE'] == $title) {
return "<TABLE align=center" . ($colors[$title] ? ' bgcolor=' . $colors[$title] : '') . "><TR><TD><INPUT type=radio name=values[" . $THIS_RET['STUDENT_ID'] . "] value='{$title}' CHECKED></TD></TR></TABLE>";
} else {
<?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));
}
}
// if(!$weight)
// {
// $error[] = "No weight was selectd for ".$courses_RET[$course][1]['TITLE'];
// continue;
// }
// if(!$weights_RET[$course][$weight])
// {
// $error[] = $courses_RET[$course][1]['TITLE'].' does not have a weight of '.$weight;
// unset($courses[$i]);
// continue;
// }
$sql = "INSERT INTO SCHEDULE_REQUESTS (SYEAR,SCHOOL_ID,STUDENT_ID,SUBJECT_ID,COURSE_ID,MARKING_PERIOD_ID,WITH_TEACHER_ID,NOT_TEACHER_ID,WITH_PERIOD_ID,NOT_PERIOD_ID)\r\n\t\t\t\t\t\tvalues('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $courses_RET[$course][1]['SUBJECT_ID'] . "','" . $course . "',NULL,'" . $_REQUEST['with_teacher'][$subject][$i] . "','" . $_REQUEST['without_teacher'][$subject][$i] . "','" . $_REQUEST['with_period'][$subject][$i] . "','" . $_REQUEST['without_period'][$subject][$i] . "')";
DBQuery($sql);
}
}
echo ErrorMessage($error, 'Error');
$_SCHEDULER['student_id'] = UserStudentID();
$_SCHEDULER['dont_run'] = true;
include 'modules/Scheduling/Scheduler.php';
$_REQUEST['modfunc'] = 'choose';
}
if ($_REQUEST['modfunc'] == 'choose') {
$functions = array('WITH_PERIOD_ID' => '_makeWithSelects', 'NOT_PERIOD_ID' => '_makeWithoutSelects');
$requests_RET = DBGet(DBQuery("SELECT sr.COURSE_ID,c.COURSE_TITLE,sr.WITH_PERIOD_ID,sr.NOT_PERIOD_ID,sr.WITH_TEACHER_ID,\r\n\t\t\t\t\t\t\t\t\t\tsr.NOT_TEACHER_ID FROM SCHEDULE_REQUESTS sr,COURSES c\r\n\t\t\t\t\t\t\t\t\tWHERE sr.SYEAR='" . UserSyear() . "' AND sr.STUDENT_ID='" . UserStudentID() . "' AND sr.COURSE_ID=c.COURSE_ID"), $functions);
echo "<FORM name=vary id=vary action=Modules.php?modname={$_REQUEST['modname']}&modfunc=verify method=POST>";
DrawHeader('', SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("vary");\''));
$columns = array('');
ListOutput($requests_RET, $columns, 'Request', 'Requests');
echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("vary");\'') . '</CENTER></FORM>';
}
if ($_REQUEST['search_modfunc'] == 'list') {
$PHP_tmp_SELF = PreparePHP_SELF();
echo '<FORM action="' . $PHP_tmp_SELF . '" method="POST">';
DrawHeader(PrepareDate($date, '_date') . ' : <INPUT type=submit value=' . _('Go') . '>');
echo '</FORM>';
include 'modules/Food_Service/' . ($_REQUEST['type'] == 'staff' ? 'Users' : 'Students') . '/BalanceReport.php';
}
$extra['new'] = true;
$extra['force_search'] = true;
$extra['SELECT'] = ",fsa.ACCOUNT_ID,fst.BALANCE";
//$extra['SELECT'] .= ",(SELECT BALANCE FROM FOOD_SERVICE_TRANSACTIONS WHERE ACCOUNT_ID=fsa.ACCOUNT_ID AND TIMESTAMP<date '".$date."'+1 ORDER BY TIMESTAMP DESC LIMIT 1) AS BALANCE";
$extra['FROM'] = ",FOOD_SERVICE_STUDENT_ACCOUNTS fsa,FOOD_SERVICE_TRANSACTIONS fst";
$extra['WHERE'] = " AND fsa.STUDENT_ID=ssm.STUDENT_ID AND fst.ACCOUNT_ID=fsa.ACCOUNT_ID AND fst.BALANCE>'0' AND fst.TRANSACTION_ID=(SELECT TRANSACTION_ID FROM FOOD_SERVICE_TRANSACTIONS WHERE ACCOUNT_ID=fsa.ACCOUNT_ID AND TIMESTAMP<date '" . $date . "'+1 ORDER BY TIMESTAMP DESC LIMIT 1)";
$extra['functions'] = array('ACCOUNT_ID' => '_total');
$extra['columns_before'] = array('ACCOUNT_ID' => _('Account ID'));
$extra['columns_after'] = array('BALANCE' => _('Balance'));
$extra['group'] = $extra['LO_group'] = array('ACCOUNT_ID');
$extra['link'] = array('FULL_NAME' => false);
Search('student_id', $extra);
if ($_REQUEST['search_modfunc'] == 'list') {
echo DrawHeader(_('Total of Balances') . ' = ' . number_format($total, 2));
}
function _total($value)
{
global $THIS_RET, $account_id, $total;
if (!$account_id[$value]) {
$total += $THIS_RET['BALANCE'];
$account_id[$value] = true;
}
return $value;
}
