function PopTable($action, $title = 'Search', $table_att = '', $cell_padding = '5')
{
global $_ROSARIO;
if ($action == 'header') {
//modif Francois: css WPadmin
if (!empty($_REQUEST['_ROSARIO_PDF'])) {
echo '<TABLE class="cellpadding-6" ' . $table_att . '>';
echo '<TR><TD class="width-100p center" style="background-color:' . Preferences('HEADER') . ';">';
} else {
echo '<TABLE class="postbox cellspacing-0 cellpadding-0" ' . $table_att . '>';
echo '<TR><TD class="center">';
}
if (is_array($title)) {
echo WrapTabs($title, $_ROSARIO['selected_tab']);
} else {
echo DrawTab($title);
}
echo '</TD></TR>
<TR><TD>';
// Start content table.
echo '<TABLE style="padding:' . $cell_padding . 'px;" class="width-100p cellspacing-0"><tr><td>';
} elseif ($action == 'footer') {
// Close embeded table.
echo '</td></tr></TABLE>';
echo '</TD>
</TR>
</TABLE>';
}
}
function DrawBlock($title, $content, $tabcolor = '#333366', $textcolor = '#FFFFFF')
{
global $user_id, $wstation, $DatabaseType, $block_table, $global_block_id;
$block_table = "";
$block_table .= "<center><TABLE border=\"0\" width=\"98%\" cellspacing=\"0\" cellpadding=\"0\"><TR><TD>";
$block_table .= DrawTab($title);
$block_table .= "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"1\" class=\"Box\">";
$block_table .= " <tr>";
$block_table .= " <td><table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" class=\"BoxContents\">";
$block_table .= " <tr>";
$block_table .= " <td><img src=\"assets/pixel_trans.gif\" border=\"0\" alt=\"\" width=\"100%\" height=\"1\"></td>";
$block_table .= " </tr>";
$block_table .= " <tr>";
$block_table .= " <td class=\"boxText\" align=left>";
$block_table .= $content;
$block_table .= "</td>";
$block_table .= " </tr>";
$block_table .= " <tr>";
$block_table .= " <td><img src=\"assets/pixel_trans.gif\" border=\"0\" alt=\"\" width=\"100%\" height=\"1\"></td>";
$block_table .= " </tr>";
$block_table .= "</table>";
$block_table .= "</td>";
$block_table .= " </tr>";
$block_table .= "</table>\n\n";
$block_table .= "</TD></TR></TABLE></centers>";
echo $block_table;
}
function PopTableCustom($action, $title = 'Search', $table_att = '', $cell_padding = '5')
{
global $_CENTRE;
if ($action == 'header') {
echo "<CENTER>\n\t\t\t<TABLE cellpadding=0 cellspacing=0 {$table_att}>";
echo "<TR><TD align=center colspan=3>";
if (is_array($title)) {
echo WrapTabs($title, $_CENTRE['selected_tab']);
} else {
echo DrawTab($title);
}
echo "</TD></TR>\n\t\t\t<TR><TD background=assets/left_shadow.gif width=4 rowspan=2> </TD><TD background=assets/bottom.gif height=7></TD><TD background=assets/right_shadow.gif width=4 rowspan=2></TD></TR><TR><TD bgcolor=white>";
// Start content table.
echo "<TABLE cellpadding=" . $cell_padding . " cellspacing=0 width=100%><tr><td bgcolor=white>";
} elseif ($action == 'footer') {
// Close embeded table.
echo "</td></tr></TABLE>";
// 2nd cell is for shadow.....
echo "</TD>\n\t\t</TR>\n\t\t<TR>\n\t\t\t<TD background=assets/left_corner_shadow.gif height=6 width=4></TD>\n\t\t\t<TD background=assets/bottom_shadow.gif height=6></TD>\n\t\t\t<TD height=6 width=4 background=assets/right_corner_shadow.gif></TD>\n\t\t</TR></TABLE></CENTER>";
}
}
function PopTableWindow($action, $title = 'Search', $table_att = '', $cell_padding = '0')
{
global $_CENTRE;
if ($action == 'header') {
echo "<CENTER>\n\t\t\t<TABLE align=left cellpadding=0 cellspacing=0 {$table_att}>";
echo "<TR><TD >";
if (is_array($title)) {
echo WrapTabs($title, $_CENTRE['selected_tab']);
} else {
echo DrawTab($title);
}
echo "</TD></TR>\n\t\t\t<TR><TD>";
// Start content table.
echo "<TABLE cellpadding=" . $cell_padding . " cellspacing=0 ><tr><td width=10></td><td >\n\t\t<div class='inside_block_top'></div>\n <div class='content_block'>";
} elseif ($action == 'footer') {
// Close embeded table.
echo "</div><div class='content_bottom'></div>";
echo "</td></tr></TABLE>";
// 2nd cell is for shadow.....
echo "</TD></TR></TABLE></CENTER>";
}
}
function WrapTabs($tabs, $selected = '', &$selected_key = '')
{
$row = 0;
$characters = 0;
//modif Francois: css WPadmin
if (count($tabs)) {
$rows[0] = '<div class="h3multi">';
foreach ($tabs as $key => $tab) {
if (mb_substr($tab['title'], 0, 1) != '<') {
$tab_len = mb_strlen($tab['title']);
} else {
$tab_len = 0;
}
if ($tab['link'] == PreparePHP_SELF() || $tab['link'] == $selected) {
$rows[$row] .= '<!--BOTTOM-->' . '<span class="h3selected">' . DrawTab($tab['title'], $tab['link']) . '</span>';
$selected_key = $key;
} else {
$rows[$row] .= DrawTab($tab['title'], $tab['link']);
}
$characters += $tab_len + 6;
}
}
$rows[$row] .= "\n\n";
$i = 0;
$row_count = count($rows) - 1;
for ($key = $row_count; $key >= 0; $key--) {
//modif Francois: remove ereg
// if(!ereg("<!--BOTTOM-->",$rows[$key]))
if (mb_strpos($rows[$key], "<!--BOTTOM-->") === FALSE) {
$table .= $rows[$key];
$i++;
} else {
$bottom = $key;
}
}
$table .= $rows[$bottom] . '</div>';
return $table;
}
function WrapTabs($tabs, $selected = '', $title = '', $use_blue = false, $type = '')
{
if ($color == '' || $color == '#FFFFFF') {
$color = "#FFFFCC";
}
$row = 0;
$characters = 0;
$rows[0] = "<TABLE border=0 cellpadding=0 cellspacing=0 class=><TR>";
if (count($tabs)) {
foreach ($tabs as $tab) {
if (substr($tab['title'], 0, 1) != '<') {
$tab_len = strlen($tab['title']);
} else {
$tab_len = 0;
}
if ($characters + $tab_len >= 180) {
$rows[$row] .= "</TR>\n</TABLE>\n\n";
$row++;
$rows[$row] .= "<TABLE border=0 cellpadding=0 cellspacing=0 >\n\t<TR>";
$characters = 0;
}
if ($tab['link'] == PreparePHP_SELF() || $tab['link'] == $selected) {
$rows[$row] .= "<!--BOTTOM-->\n\t\t<TD>" . DrawTab($tab['title'], $tab['link'], '#333366', '#436477', $type) . "</TD>";
} elseif ($use_blue !== true) {
$rows[$row] .= "\n\t\t<TD >" . DrawinactiveTab($tab['title'], $tab['link'], '#DDDDDD', '#000000', $type) . "</TD>";
} else {
$rows[$row] .= "\n\t\t<TD >" . DrawinactiveTab($tab['title'], $tab['link'], '#333366', '#f2a30b', $type) . "</TD>";
}
$characters += $tab_len + 6;
}
}
$rows[$row] .= "</TR>\n</TABLE>\n\n";
$i = 0;
$row_count = count($rows) - 1;
if ($use_blue === true) {
$table .= "<TABLE border=0 width=100% cellpadding=0 cellspacing=0 ><TR><TD width=100%></TD><TD align=right>";
} elseif ($use_blue == 'center') {
$table .= "<TABLE border=0 width=100% cellpadding=0 cellspacing=0 align=center><TR><TD align=center>";
}
for ($key = $row_count; $key >= 0; $key--) {
if (!ereg("<!--BOTTOM-->", $rows[$key])) {
$table .= "<TABLE border=0 width=0 cellpadding=0 cellspacing=0 ><TR><TD>";
$table .= "<IMG SRC=assets/pixel_trans.gif width=" . ($row_count - $i) * 6 . " height=1>";
if ($key != 0 || $bottom) {
$table .= "</TD><TD>{$rows[$key]}</TD><TD rowspan=2> </TD></TR><TR><TD height=1></TD><TD height=5 valign=top></TD></TR></TABLE>";
} else {
$table .= "</TD><TD>{$rows[$key]}</TD><TD rowspan=2></TD></TR><TR><TD height=0></TD><TD height=0 valign=top></TD></TR></TABLE>";
}
$i++;
} else {
$bottom = $key;
}
}
$table .= "<TABLE border=0 cellpadding=0 cellspacing=0 ><TR><TD></TD><TD>" . $rows[$bottom] . "</TD><TD></TD></TR></TABLE>";
if ($use_blue) {
$table .= "</TD></TR><TR><TD colspan=2>";
}
if ($title != '') {
$table .= "<TABLE width=100% bgcolor={$color} border=0 cellpadding=0 cellspacing=0><TR><TD bgcolor={$color} width=100%> <font class=FontBox>{$title}</font></TD></TR></TABLE>";
}
if ($use_blue) {
$table .= "</TD></TR></TABLE>";
}
return $table;
}
}
if ($_REQUEST['type'] == 'staff') {
$tabcolor_s = '#DFDFDF';
$textcolor_s = '#999999';
$tabcolor_u = Preferences('HEADER');
$textcolor_u = '#FFFFFF';
} else {
$tabcolor_s = Preferences('HEADER');
$textcolor_s = '#FFFFFF';
$tabcolor_u = '#DFDFDF';
$textcolor_u = '#999999';
}
$header = '<TABLE class="cellpadding-0 cellspacing-0" style="height:14px;"><TR>';
//modif Francois: remove DrawTab params
$header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Students'), "Modules.php?modname={$_REQUEST['modname']}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}&type=student") . '</TD>';
$header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Users'), "Modules.php?modname={$_REQUEST['modname']}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}&type=staff") . '</TD>';
$header .= '<TD style="width:10px;"></TD></TR></TABLE>';
DrawHeader(($_SESSION['FSA_type'] == 'staff' ? _('User') : _('Student')) . ' ' . ProgramTitle(), User('PROFILE') == 'student' ? '' : '<TABLE style="background-color:#ffffff;"><TR><TD>' . $header . '</TD></TR></TABLE>');
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)";
$_SESSION['_REQUEST_vars']['type'] = $_REQUEST['type'] = $_SESSION['FSA_type'];
}
/*if($_REQUEST['type']=='staff')
{
$tabcolor_s = '#DFDFDF'; $textcolor_s = '#999999';
$tabcolor_u = Preferences('HEADER'); $textcolor_u = '#FFFFFF';
}
else
{
$tabcolor_s = Preferences('HEADER'); $textcolor_s = '#FFFFFF';
$tabcolor_u = '#DFDFDF'; $textcolor_u = '#999999';
}*/
$header = '<TABLE class="cellpadding-0 cellspacing-0" style="height:14px;"><TR>';
//modif Francois: remove DrawTab params
$header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Students'), "Modules.php?modname={$_REQUEST['modname']}&modfunc=select&menu_id={$_REQUEST['menu_id']}&fsa_type=student") . '</TD>';
$header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Users'), "Modules.php?modname={$_REQUEST['modname']}&modfunc=select&menu_id={$_REQUEST['menu_id']}&fsa_type=staff") . '</TD>';
$header .= '<TD style="width:10px;"></TD></TR></TABLE>';
DrawHeader(($_SESSION['FSA_type'] == 'staff' ? _('User') : _('Student')) . ' − ' . ProgramTitle(), User('PROFILE') == 'student' ? '' : '<TABLE style="background-color:#ffffff;"><TR><TD>' . $header . '</TD></TR></TABLE>');
$menus_RET = DBGet(DBQuery('SELECT MENU_ID,TITLE FROM FOOD_SERVICE_MENUS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'), array(), array('MENU_ID'));
if (!$_REQUEST['menu_id']) {
if (!$_SESSION['FSA_menu_id']) {
if (count($menus_RET)) {
$_REQUEST['menu_id'] = $_SESSION['FSA_menu_id'] = key($menus_RET);
} else {
ErrorMessage(array(_('There are no menus yet setup.')), 'fatal');
}
} else {
$_REQUEST['menu_id'] = $_SESSION['FSA_menu_id'];
}
unset($_SESSION['FSA_sale']);
} else {
$_SESSION['_REQUEST_vars']['type'] = $_REQUEST['type'] = $_SESSION['FSA_type'];
}
if ($_REQUEST['type'] == 'staff') {
$tabcolor_s = '#DFDFDF';
$textcolor_s = '#999999';
$tabcolor_u = Preferences('HEADER');
$textcolor_u = '#FFFFFF';
} else {
$tabcolor_s = Preferences('HEADER');
$textcolor_s = '#FFFFFF';
$tabcolor_u = '#DFDFDF';
$textcolor_u = '#999999';
}
$header = '<TABLE border=0 cellpadding=0 cellspacing=0 height=14><TR>';
$header .= '<TD width=10></TD><TD>' . DrawTab('Students', "Modules.php?modname={$_REQUEST['modname']}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}&type=student", $tabcolor_s, $textcolor_s, '_circle', array('tabcolor' => Preferences('HEADER'), 'textcolor' => '#FFFFFF')) . '</TD>';
$header .= '<TD width=10></TD><TD>' . DrawTab('Users', "Modules.php?modname={$_REQUEST['modname']}&day_date={$_REQUEST['day_date']}&month_date={$_REQUEST['month_date']}&year_date={$_REQUEST['year_date']}&type=staff", $tabcolor_u, $textcolor_u, '_circle', array('tabcolor' => Preferences('HEADER'), 'textcolor' => '#FFFFFF')) . '</TD>';
$header .= '<TD width=10></TD></TR></TABLE>';
DrawHeader(($_SESSION['FSA_type'] == 'staff' ? _('User') : _('Student')) . ' ' . ProgramTitle(), User('PROFILE') == 'student' ? '' : '<TABLE bgcolor=#ffffff><TR><TD>' . $header . '</TD></TR></TABLE>');
if ($_REQUEST['modfunc'] == 'delete') {
require_once 'modules/Food_Service/includes/DeletePromptX.fnc.php';
if ($_REQUEST['item_id'] != '') {
if (DeletePromptX('transaction item')) {
require_once 'modules/Food_Service/includes/DeleteTransactionItem.fnc.php';
DeleteTransactionItem($_REQUEST['transaction_id'], $_REQUEST['item_id'], $_REQUEST['type']);
DBQuery('BEGIN; ' . $sql1 . '; ' . $sql2 . '; ' . $sql3 . '; COMMIT');
unset($_REQUEST['modfunc']);
unset($_REQUEST['delete_ok']);
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_SESSION['_REQUEST_vars']['delete_ok']);
}
} else {
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#000000';
}
$header .= '<TD width=10></TD><TD>' . DrawTab('Attendance', $tmp_PHP_SELF . '&table=0', $tabcolor, $textcolor, '_circle', array('textcolor' => '#000000')) . '</TD>';
foreach ($categories_RET as $category) {
if ($_REQUEST['table'] !== $category['ID']) {
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#000000';
}
$header .= '<TD>' . DrawTab($category['TITLE'], $tmp_PHP_SELF . '&table=' . $category['ID'], $tabcolor, $textcolor, '_circle', array('textcolor' => '#000000')) . '</TD>';
}
$header .= '</TR></TABLE>';
echo $header;
echo '<TABLE height=1><TR><TD height=1></TD></TR></TABLE>';
echo '</TD></TR></TABLE></div></center>';
}
#echo SubmitButton(LANG_UPDATE,'','class=btn_medium');
$_REQUEST['search_modfunc'] = 'list';
$extra['DEBUG'] = true;
PopTable_wo_header('header');
if ($_REQUEST['expanded_view'] == true) {
echo '<div style="width:800px; overflow-x:scroll;">';
} else {
echo '<div style="width:800px; overflow-x:scroll;">';
}
}*/
//modif Francois: remove DrawTab params
$headerl .= '<TD></TD><TD>' . DrawTab(_('Attendance'), $tmp_PHP_SELF . '&table=0', '_circle') . '</TD>';
foreach ($categories_RET as $category) {
/*if($_REQUEST['table']!==$category['ID'])
{
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
}
else
{
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#000';
}*/
//modif Francois: remove DrawTab params
$headerl .= '<TD style="width:10px;"></TD><TD>' . DrawTab($category['TITLE'], $tmp_PHP_SELF . '&table=' . $category['ID']) . '</TD>';
}
$headerl .= '</TR></TABLE>';
}
if (isset($_REQUEST['student_id']) && $_REQUEST['student_id'] != 'new') {
if (UserStudentID() != $_REQUEST['student_id']) {
$_SESSION['student_id'] = $_REQUEST['student_id'];
echo '<script type="text/javascript">parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
}
$functions = array('ATTENDANCE_CODE' => '_makeCodePulldown', 'ATTENDANCE_TEACHER_CODE' => '_makeCode', 'ATTENDANCE_REASON' => '_makeReasonInput', 'COMMENT' => '_makeReason');
//modif Francois: days numbered
//modif Francois: multiple school periods for a course period
if (SchoolInfo('NUMBER_DAYS_ROTATION') !== null) {
$schedule_RET = DBGet(DBQuery("SELECT\n\t\t\t\t\t\t\t\t\t\t\ts.STUDENT_ID,c.TITLE AS COURSE,cpsp.PERIOD_ID,cp.COURSE_PERIOD_ID,p.TITLE AS PERIOD_TITLE,\n\t\t\t\t\t\t\t\t\t\t\ts.STUDENT_ID AS ATTENDANCE_CODE,s.STUDENT_ID AS ATTENDANCE_TEACHER_CODE,s.STUDENT_ID AS ATTENDANCE_REASON,s.STUDENT_ID AS COMMENT\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\tSCHEDULE s,COURSES c,COURSE_PERIODS cp,SCHOOL_PERIODS p,ATTENDANCE_CALENDAR ac, COURSE_PERIOD_SCHOOL_PERIODS cpsp \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tcp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID AND\n\t\t\t\t\t\t\t\t\t\t\ts.SYEAR='" . UserSyear() . "' AND s.SCHOOL_ID='" . UserSchool() . "' AND s.MARKING_PERIOD_ID IN (" . $all_mp . ")\n\t\t\t\t\t\t\t\t\t\t\tAND s.COURSE_ID=c.COURSE_ID\n\t\t\t\t\t\t\t\t\t\t\tAND s.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cpsp.PERIOD_ID=p.PERIOD_ID AND position(',{$_REQUEST['table']},' IN cp.DOES_ATTENDANCE)>0\n\t\t\t\t\t\t\t\t\t\t\tAND s.STUDENT_ID='" . $_REQUEST['student_id'] . "' AND ('{$date}' BETWEEN s.START_DATE AND s.END_DATE OR (s.END_DATE IS NULL AND '{$date}'>=s.START_DATE))\n\t\t\t\t\t\t\t\t\t\t\tAND position(substring('MTWHFSU' FROM cast((SELECT CASE COUNT(school_date)% " . SchoolInfo('NUMBER_DAYS_ROTATION') . " WHEN 0 THEN " . SchoolInfo('NUMBER_DAYS_ROTATION') . " ELSE COUNT(school_date)% " . SchoolInfo('NUMBER_DAYS_ROTATION') . " END AS day_number FROM attendance_calendar WHERE school_date>=(SELECT start_date FROM school_marking_periods WHERE start_date<='{$date}' AND end_date>='{$date}' AND mp='QTR') AND school_date<='{$date}') AS INT) FOR 1) IN cpsp.DAYS)>0\n\t\t\t\t\t\t\t\t\t\t\tAND ac.CALENDAR_ID=cp.CALENDAR_ID AND ac.SCHOOL_DATE='{$date}' AND ac.MINUTES!='0'\n\t\t\t\t\t\t\t\t\t\tORDER BY p.SORT_ORDER"), $functions);
} else {
$schedule_RET = DBGet(DBQuery("SELECT\n\t\t\t\t\t\t\t\t\t\t\ts.STUDENT_ID,c.TITLE AS COURSE,cpsp.PERIOD_ID,cp.COURSE_PERIOD_ID,p.TITLE AS PERIOD_TITLE,\n\t\t\t\t\t\t\t\t\t\t\ts.STUDENT_ID AS ATTENDANCE_CODE,s.STUDENT_ID AS ATTENDANCE_TEACHER_CODE,s.STUDENT_ID AS ATTENDANCE_REASON,s.STUDENT_ID AS COMMENT\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\tSCHEDULE s,COURSES c,COURSE_PERIODS cp,SCHOOL_PERIODS p,ATTENDANCE_CALENDAR ac, COURSE_PERIOD_SCHOOL_PERIODS cpsp \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tcp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID AND\n\t\t\t\t\t\t\t\t\t\t\ts.SYEAR='" . UserSyear() . "' AND s.SCHOOL_ID='" . UserSchool() . "' AND s.MARKING_PERIOD_ID IN (" . $all_mp . ")\n\t\t\t\t\t\t\t\t\t\t\tAND s.COURSE_ID=c.COURSE_ID\n\t\t\t\t\t\t\t\t\t\t\tAND s.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cpsp.PERIOD_ID=p.PERIOD_ID AND position(',{$_REQUEST['table']},' IN cp.DOES_ATTENDANCE)>0\n\t\t\t\t\t\t\t\t\t\t\tAND s.STUDENT_ID='" . $_REQUEST['student_id'] . "' AND ('{$date}' BETWEEN s.START_DATE AND s.END_DATE OR (s.END_DATE IS NULL AND '{$date}'>=s.START_DATE))\n\t\t\t\t\t\t\t\t\t\t\tAND position(substring('UMTWHFS' FROM cast(extract(DOW FROM cast('{$date}' AS DATE)) AS INT)+1 FOR 1) IN cpsp.DAYS)>0\n\t\t\t\t\t\t\t\t\t\t\tAND ac.CALENDAR_ID=cp.CALENDAR_ID AND ac.SCHOOL_DATE='{$date}' AND ac.MINUTES!='0'\n\t\t\t\t\t\t\t\t\t\tORDER BY p.SORT_ORDER"), $functions);
$_SESSION['_REQUEST_vars']['type'] = $_REQUEST['type'] = $_SESSION['FSA_type'];
}
if ($_REQUEST['type'] == 'staff') {
$tabcolor_s = '#DFDFDF';
$textcolor_s = '#999999';
$tabcolor_u = Preferences('HEADER');
$textcolor_u = '#FFFFFF';
} else {
$tabcolor_s = Preferences('HEADER');
$textcolor_s = '#FFFFFF';
$tabcolor_u = '#DFDFDF';
$textcolor_u = '#999999';
}
$header = '<TABLE border=0 cellpadding=0 cellspacing=0 height=14><TR>';
$header .= '<TD width=10></TD><TD>' . DrawTab('Students', "Modules.php?modname={$_REQUEST['modname']}&modfunc=select&menu_id={$_REQUEST['menu_id']}&fsa_type=student", $tabcolor_s, $textcolor_s, '_circle', array('tabcolor' => Preferences('HEADER'), 'textcolor' => '#FFFFFF')) . '</TD>';
$header .= '<TD width=10></TD><TD>' . DrawTab('Users', "Modules.php?modname={$_REQUEST['modname']}&modfunc=select&menu_id={$_REQUEST['menu_id']}&fsa_type=staff", $tabcolor_u, $textcolor_u, '_circle', array('tabcolor' => Preferences('HEADER'), 'textcolor' => '#FFFFFF')) . '</TD>';
$header .= '<TD width=10></TD></TR></TABLE>';
DrawHeader(($_SESSION['FSA_type'] == 'staff' ? 'User ' : 'Student ') . ProgramTitle(), '<TABLE bgcolor=#ffffff><TR><TD>' . $header . '</TD></TR></TABLE>');
$menus_RET = DBGet(DBQuery('SELECT MENU_ID,TITLE FROM FOOD_SERVICE_MENUS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'), array(), array('MENU_ID'));
if (!$_REQUEST['menu_id']) {
if (!$_SESSION['FSA_menu_id']) {
if (count($menus_RET)) {
$_REQUEST['menu_id'] = $_SESSION['FSA_menu_id'] = key($menus_RET);
} else {
ErrorMessage(array('There are no menus yet setup.'), 'fatal');
}
} else {
$_REQUEST['menu_id'] = $_SESSION['FSA_menu_id'];
}
unset($_SESSION['FSA_sale']);
# Prefill the sale with all menu items and let them remove the ones they don't want
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#FFFFFF';
}
$header .= '<TD width=10></TD><TD>' . DrawTab('Attendance', $tmp_PHP_SELF . '&table=0', $tabcolor, $textcolor, '_circle', array('tabcolor' => Preferences('HIGHLIGHT'), 'textcolor' => '#FFFFFF')) . '</TD>';
foreach ($categories_RET as $category) {
if ($_REQUEST['table'] !== $category['ID']) {
$tabcolor = '#DFDFDF';
$textcolor = '#999999';
} else {
$tabcolor = Preferences('HIGHLIGHT');
$textcolor = '#FFFFFF';
}
$header .= '<TD width=10></TD><TD>' . DrawTab($category['TITLE'], $tmp_PHP_SELF . '&table=' . $category['ID'], $tabcolor, $textcolor, '_circle', array('tabcolor' => Preferences('HIGHLIGHT'), 'textcolor' => '#FFFFFF')) . '</TD>';
}
$header .= '</TR></TABLE>';
echo $header;
echo '<TABLE height=1><TR><TD height=1></TD></TR></TABLE>';
echo '</TD></TR></TABLE>';
}
echo SubmitButton(LANG_UPDATE, '', 'class=btn_medium');
$_REQUEST['search_modfunc'] = 'list';
$extra['DEBUG'] = true;
Search('student_id', $extra);
echo '<BR><CENTER>' . SubmitButton(LANG_UPDATE, '', 'class=btn_medium') . '</CENTER>';
echo "</FORM>";
}
function _makePhone($value, $column)
{
$content .= '</tr><tr>';
for ($i = 4; $i <= 6; $i++) {
$content .= '<td style="width:15px;" class="center">' . DrawTab($i, '#" onclick="insertItem(\'' . $i . '\',\'' . $type . '\'); return false;') . '</td>';
}
$content .= '</tr><tr>';
for ($i = 1; $i <= 3; $i++) {
$content .= '<td style="width:15px;" class="center">' . DrawTab($i, '#" onclick="insertItem(\'' . $i . '\',\'' . $type . '\'); return false;') . '</td>';
}
$content .= '</tr><tr><td class="center">' . DrawTab('.', '#" onclick="insertItem(\'.\',\'' . $type . '\'); return false;') . '</td><td class="center">' . DrawTab('0', '#" onclick="insertItem(\'0\',\'' . $type . '\'); return false;') . '</td><td></td></tr>';
$content .= '</table>';
break;
} else {
continue;
}
}
$content .= DrawTab($item, '#" onclick="insertItem(\'' . $item . '\',\'' . $type . '\'); return false;');
}
$content .= '</td></tr></table>';
echo PopTable('header', _('Fields'));
echo $content;
echo PopTable('footer');
echo '</td></tr></table><br />';
$birthdate_RET = DBGet(DBQuery("SELECT 1\n\t\tFROM CUSTOM_FIELDS\n\t\tWHERE TYPE='date'\n\t\tAND ID='200000004'"));
$fields_RET = DBGet(DBQuery("SELECT ID,TITLE\n\t\tFROM CUSTOM_FIELDS\n\t\tWHERE TYPE='select'\n\t\tORDER BY TITLE"));
$breakdown_options = array('school' => _('School'), 'grade' => _('Grade Level'), 'stuid' => dgettext('Reports', 'Student ID'));
// Check Birthdate original field exists and is DATE.
if ($birthdate_RET) {
$breakdown_options['age'] = _('Age');
}
foreach ((array) $fields_RET as $field) {
$breakdown_options['CUSTOM_' . $field['ID']] = ParseMLField($field['TITLE'], $locale);
