function ErrorMessage($errors, $code = 'error')
{
if ($errors) {
$return = "<TABLE border=0><TR><TD align=left>";
if (count($errors) == 1) {
if ($code == 'error' || $code == 'fatal') {
$return .= '<b><font color=#CC0000>' . Localize('colon', _('Error')) . '</font></b> ';
} else {
$return .= '<b><font color=#00CC00>' . Localize('colon', _('Note')) . '</font></b> ';
}
$return .= $errors[0] ? $errors[0] : $errors[1];
} else {
if ($code == 'error' || $code == 'fatal') {
$return .= "<b><font color=#CC0000>" . Localize('colon', _('Errors')) . "</font></b>";
} else {
$return .= '<b><font color=#00CC00>' . Localize('colon', _('Note')) . '</font></b>';
}
$return .= '<ul>';
foreach ($errors as $value) {
$return .= "<LI><font size=-1>{$value}</font></LI>\n";
}
$return .= '</ul>';
}
$return .= "</TD></TR></TABLE><br>";
if ($code == 'fatal') {
echo $return;
if (!$_REQUEST['_CENTRE_PDF']) {
Warehouse('footer');
}
exit;
}
return $return;
}
}
function MyWidgets($item)
{
global $extra, $_CENTRE;
switch ($item) {
case 'birthmonth':
$options = array('1' => _('January'), '2' => _('February'), '3' => _('March'), '4' => _('April'), '5' => _('May'), '6' => _('June'), '7' => _('July'), '8' => _('August'), '9' => _('September'), '10' => _('October'), '11' => _('November'), '12' => _('December'));
if ($_REQUEST['birthmonth']) {
$extra['SELECT'] .= ",to_char(s.CUSTOM_200000004,'Mon DD') AS BIRTHMONTH";
$extra['WHERE'] .= " AND extract(month from s.CUSTOM_200000004)='{$_REQUEST['birthmonth']}'";
$extra['columns_after']['BIRTHMONTH'] = _('Birth Month Day');
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('Birth Month')) . ' </b></font>' . $options[$_REQUEST['birthmonth']] . '<BR>';
}
}
$extra['search'] .= '<TR><TD align=right width=120>' . _('Birth Month') . '</TD><TD><SELECT name=birthmonth><OPTION value="">' . _('N/A');
foreach ($options as $key => $val) {
$extra['search'] .= '<OPTION value="' . $key . '">' . $val;
}
$extra['search'] .= '</SELECT></TD></TR>';
break;
}
}
function MyWidgets($item)
{
global $extra, $_ROSARIO;
switch ($item) {
case 'birthmonth':
$options = array('1' => _('January'), '2' => _('February'), '3' => _('March'), '4' => _('April'), '5' => _('May'), '6' => _('June'), '7' => _('July'), '8' => _('August'), '9' => _('September'), '10' => _('October'), '11' => _('November'), '12' => _('December'));
if ($_REQUEST['birthmonth']) {
$extra['SELECT'] .= ",to_char(s.CUSTOM_200000004,'Mon DD') AS BIRTHMONTH";
$extra['WHERE'] .= " AND extract(month from s.CUSTOM_200000004)='{$_REQUEST['birthmonth']}'";
$extra['columns_after']['BIRTHMONTH'] = _('Birth Month');
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Birth Month')) . ' </b></span>' . $options[$_REQUEST['birthmonth']] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:"><label for="birthmonth">' . _('Birth Month') . '</label></TD><TD><SELECT name="birthmonth" id="birthmonth"><OPTION value="">' . _('N/A');
foreach ($options as $key => $val) {
$extra['search'] .= '<OPTION value="' . $key . '">' . $val;
}
$extra['search'] .= '</SELECT></TD></TR>';
break;
case 'birthday':
$options = array('1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7', '8' => '8', '9' => '9', '10' => '10', '11' => '11', '12' => '12', '13' => '13', '14' => '14', '15' => '15', '16' => '16', '17' => '17', '18' => '18', '19' => '19', '20' => '20', '21' => '21', '22' => '22', '23' => '23', '24' => '24', '25' => '25', '26' => '26', '27' => '27', '28' => '28', '29' => '29', '30' => '30', '31' => '31');
if ($_REQUEST['birthday']) {
$extra['SELECT'] .= ",to_char(s.CUSTOM_200000004,'DD') AS BIRTHDAY";
$extra['WHERE'] .= " AND extract(day from s.CUSTOM_200000004)='{$_REQUEST['birthday']}'";
$extra['columns_after']['BIRTHDAY'] = _('Birth Day');
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Birth Day')) . ' </b></span>' . $options[$_REQUEST['birthday']] . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:"><label for="birthday">' . _('Birth Day') . '</label></TD><TD><SELECT name="birthday" id="birthday"><OPTION value="">' . _('N/A');
foreach ($options as $key => $val) {
$extra['search'] .= '<OPTION value="' . $key . '">' . $val;
}
$extra['search'] .= '</SELECT></TD></TR>';
break;
}
}
function _makeExtra($value, $title = '')
{
global $THIS_RET;
if ($THIS_RET['WITH_TEACHER_ID']) {
$return .= Localize('colon', _('With')) . ' ' . GetTeacher($THIS_RET['WITH_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['NOT_TEACHER_ID']) {
$return .= Localize('colon', _('Not With')) . ' ' . GetTeacher($THIS_RET['NOT_TEACHER_ID']) . '<BR>';
}
if ($THIS_RET['WITH_PERIOD_ID']) {
$return .= Localize('colon', _('On')) . ' ' . GetPeriod($THIS_RET['WITH_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['NOT_PERIOD_ID']) {
$return .= Localize('colon', _('Not On')) . ' ' . GetPeriod($THIS_RET['NOT_PERIOD_ID']) . '<BR>';
}
if ($THIS_RET['PRIORITY']) {
$return .= Localize('colon', _('Priority')) . ' ' . $THIS_RET['PRIORITY'] . '<BR>';
}
if ($THIS_RET['MARKING_PERIOD_ID']) {
$return .= Localize('colon', _('Marking Period')) . ' ' . GetMP($THIS_RET['MARKING_PERIOD_ID']) . '<BR>';
}
return $return;
}
function ErrorMessage($errors, $code = 'error')
{
if ($errors) {
//modif Francois: css WPadmin
if (count($errors) == 1) {
if ($code == 'error' || $code == 'fatal') {
$return .= '<div class="error"><p><IMG SRC="assets/x.png" class="alignImg"> <b>' . Localize('colon', _('Error')) . '</b> ';
} else {
$return .= '<div class="updated"><p><b>' . Localize('colon', _('Note')) . '</b> ';
}
$return .= ($errors[0] ? $errors[0] : $errors[1]) . '</p>';
} else {
if ($code == 'error' || $code == 'fatal') {
$return .= '<div class="error"><p><IMG SRC="assets/x.png" class="alignImg"> <b>' . Localize('colon', _('Errors')) . "</b></p>";
} else {
$return .= '<div class="updated"><p> <b>' . Localize('colon', _('Note')) . '</b></p>';
}
$return .= '<ul>';
foreach ($errors as $value) {
$return .= '<LI><span class="size-1">' . $value . '</span></LI>' . "\n";
}
$return .= '</ul>';
}
$return .= '</div><BR />';
if ($code == 'fatal') {
echo $return;
if (!isset($_REQUEST['_ROSARIO_PDF'])) {
Warehouse('footer');
} else {
global $print_data;
PDFStop($print_data);
}
exit;
}
return $return;
}
}
function MyWidgets($item)
{
global $extra, $_CENTRE;
switch ($item) {
case 'ly_course':
if ($_REQUEST['w_ly_course_period_id']) {
if ($_REQUEST['w_ly_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_ly_course_period_id'] . "'"));
$extra['WHERE'] .= " AND exists(SELECT '' FROM SCHEDULE WHERE STUDENT_ID=ssm.STUDENT_ID AND COURSE_ID='" . $course[1]['COURSE_ID'] . "')";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>Last Year Course: </b></font>' . $course[1]['COURSE_TITLE'] . '<BR>';
}
} else {
$extra['WHERE'] .= " AND exists(SELECT '' FROM SCHEDULE WHERE STUDENT_ID=ssm.STUDENT_ID AND COURSE_PERIOD_ID='" . $_REQUEST['w_ly_course_period_id'] . "')";
$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_ly_course_period_id'] . "'"));
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('Last Year Course Period')) . ' </b></font>' . $course[1]['COURSE_TITLE'] . ' - ' . $course[1]['TITLE'] . '<BR>';
}
}
}
$extra['search'] .= "<TR><TD align=right width=120>" . _('Last Year Course') . "</TD><TD><DIV id=ly_course_div></DIV> <A HREF=# onclick='window.open(\"Modules.php?modname=misc/ChooseCourse.php&last_year=true\",\"\",\"scrollbars=yes,resizable=yes,width=800,height=400\");'><SMALL>" . _('Choose') . "</SMALL></A></TD></TR>";
break;
}
}
function MyWidgets($item)
{
global $extra, $_ROSARIO;
switch ($item) {
case 'ly_course':
if ($_REQUEST['w_ly_course_period_id']) {
if ($_REQUEST['w_ly_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_ly_course_period_id'] . "'"));
$extra['WHERE'] .= " AND exists(SELECT '' FROM SCHEDULE WHERE STUDENT_ID=ssm.STUDENT_ID AND COURSE_ID='" . $course[1]['COURSE_ID'] . "')";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>Last Year Course: </b></span>' . $course[1]['COURSE_TITLE'] . '<BR />';
}
} else {
$extra['WHERE'] .= " AND exists(SELECT '' FROM SCHEDULE WHERE STUDENT_ID=ssm.STUDENT_ID AND COURSE_PERIOD_ID='" . $_REQUEST['w_ly_course_period_id'] . "')";
$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_ly_course_period_id'] . "'"));
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Last Year Course Period')) . ' </b></span>' . $course[1]['COURSE_TITLE'] . ' - ' . $course[1]['TITLE'] . '<BR />';
}
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Last Year Course') . '</TD><TD><DIV id="ly_course_div"></DIV> <A HREF="#" onclick=\'window.open("Modules.php?modname=misc/ChooseCourse.php&last_year=true","","scrollbars=yes,resizable=yes,width=800,height=400");\'>' . _('Choose') . '</A></TD></TR>';
break;
}
}
function BuildViewer($forDwf = true)
{
global $debug, $webLayoutDefinition, $cmds, $locale;
global $sessionId, $username, $password, $orgSessionId;
global $mapName;
global $product;
SetLocalizedFilesPath(GetLocalizationPath());
try {
// Initialize web tier with the site configuration file.
InitializeWebTier();
//fetch the parameters for this request
//
GetRequestParameters();
//Open a connection with the server
//
$createSession = true;
$cred = new MgUserInformation();
if ($sessionId != '') {
$cred->SetMgSessionId($sessionId);
$createSession = false;
} else {
if ($username != '') {
$cred->SetMgUsernamePassword($username, $password);
} else {
requestAuthentication();
return;
}
}
$site = new MgSiteConnection();
$cred->SetLocale($locale);
$cred->SetClientIp(GetClientIp());
$cred->SetClientAgent(GetClientAgent());
$site->Open($cred);
if ($createSession) {
$site1 = $site->GetSite();
$sessionId = $site1->CreateSession();
if ($forDwf == false) {
$orgSessionId = $sessionId;
}
}
//Get a MgWebLayout object initialized with the specified web layout definition
//
$webLayout = null;
try {
$resourceSrvc = $site->CreateService(MgServiceType::ResourceService);
$webLayoutId = new MgResourceIdentifier($webLayoutDefinition);
$webLayout = new MgWebLayout($resourceSrvc, $webLayoutId);
} catch (MgUnauthorizedAccessException $e) {
requestAuthentication();
return;
} catch (MgException $e) {
$shortError = $e->GetExceptionMessage();
$longErrorMsg = EscapeForHtml($e->GetDetails());
header("HTTP/1.1 559 ");
header('Content-Type: text/html; charset=utf-8');
header("Status: 559 {$shortError}");
echo "<html>\n<body>\n";
echo $longErrorMsg;
echo "</body>\n</html>\n";
return;
}
//calculate the size of the variable elements of the viewer
//
$toolBar = $webLayout->GetToolBar();
$statusBar = $webLayout->GetStatusBar();
$taskPane = $webLayout->GetTaskPane();
$infoPane = $webLayout->GetInformationPane();
$taskBar = $taskPane->GetTaskBar();
$mapDef = $webLayout->GetMapDefinition();
$startupScriptCode = $webLayout->GetStartupScript();
$selectionColor = $webLayout->GetSelectionColor();
$mapImgFormat = $webLayout->GetMapImageFormat();
$selImgFormat = $webLayout->GetSelectionImageFormat();
$pointBuffer = $webLayout->GetPointSelectionBuffer();
$showTaskPane = $taskPane->IsVisible();
$showTaskBar = $taskBar->IsVisible();
$showStatusbar = $statusBar->IsVisible();
$showToolbar = $toolBar->IsVisible();
$taskPaneWidth = $taskPane->GetWidth();
$toolbarHeight = 30;
$taskbarHeight = 30;
$statusbarHeight = 26;
$taskWidth = $showTaskPane ? $taskPaneWidth : 0;
$toolbarHeight = $showToolbar ? $toolbarHeight : 0;
$taskbarHeight = $showTaskBar ? $taskbarHeight : 0;
$statusbarHeight = $showStatusbar ? $statusbarHeight : 0;
//Encode the initial url so that it does not trip any sub-frames (especially if this url has parameters)
$taskPaneUrl = urlencode($taskPane->GetInitialTaskUrl());
$vpath = GetSurroundVirtualPath();
$defHome = false;
if ($taskPaneUrl == "") {
$taskPaneUrl = "gettingstarted.php";
$defHome = true;
}
$mapDefinitionUrl = urlencode($mapDef);
// NOTE:
//
// We don't open a MgMap because it is being created by mapframe.php that is also probably running
// as this script is running. However the naming convention is fixed enough that we can figure out
// what to pass to the Task Pane
$resId = new MgResourceIdentifier($mapDef);
$mapName = $resId->GetName();
$title = $webLayout->GetTitle();
$enablePingServer = $webLayout->GetEnablePingServer();
$showLegend = $infoPane->IsLegendBandVisible();
$showProperties = $infoPane->IsPropertiesBandVisible();
if ($showLegend || $showProperties) {
if ($infoPane->IsVisible()) {
$infoWidth = $infoPane->GetWidth();
if ($infoWidth < 5) {
$infoWidth = 5;
}
//ensure visible
} else {
$showProperties = $showLegend = false;
$infoWidth = 0;
}
} else {
$infoWidth = 0;
}
//calculate the url of the inner pages
//
$srcToolbar = $showToolbar ? 'src="' . $vpath . 'toolbar.php?LOCALE=' . $locale . '"' : '';
$srcStatusbar = $showStatusbar ? 'src="' . $vpath . 'statusbar.php?LOCALE=' . $locale . '"' : "";
$srcTaskFrame = $showTaskPane ? 'src="' . $vpath . 'taskframe.php?MAPNAME=' . $mapName . '&WEBLAYOUT=' . urlencode($webLayoutDefinition) . '&DWF=' . ($forDwf ? "1" : "0") . '&SESSION=' . ($sessionId != "" ? $sessionId : "") . '&LOCALE=' . $locale . '"' : '';
$srcTaskBar = 'src="' . $vpath . 'taskbar.php?LOCALE=' . $locale . '"';
//view center
//
$ptCenter = $webLayout->GetCenter();
if ($ptCenter == null) {
$center = "null";
} else {
$coord = $ptCenter->GetCoordinate();
$center = sprintf("new Point(%f, %f)", $coord->GetX(), $coord->GetY());
}
//Process commands and declare command objects
//
$commands = $webLayout->GetCommands();
$cmdObjects = "";
$cmdObject = "";
$navCmdIndex = 0;
$searchCmdIndex = 0;
$measureCmdIndex = 0;
$printCmdIndex = 0;
$scriptCmdIndex = 0;
$userCode = "";
$userCodeCalls = "\nswitch(funcIndex)\n{\n";
$selAwareCmdCount = 0;
$selAwareCmds = "";
for ($i = 0; $i < $commands->GetCount(); $i++) {
$cmd = $commands->GetItem($i);
if (!$cmd->IsUsed()) {
continue;
}
$tgtViewer = $cmd->GetTargetViewerType();
if (($tgtViewer == MgWebTargetViewerType::Dwf) != ($forDwf == true) && $tgtViewer != MgWebTargetViewerType::All) {
continue;
}
$name = $cmd->GetName();
$action = $cmd->GetAction();
if ($action == MgWebActions::Search) {
$cols = "var resCols" . $searchCmdIndex . " = new Array();\n";
if ($cmd->GetResultColumnCount() > 0) {
for ($j = 0; $j < $cmd->GetResultColumnCount(); $j++) {
$col = sprintf("resCols%d[%d] = new ResultColumn(\"%s\", \"%s\");\n", $searchCmdIndex, $j, StrEscape($cmd->GetColumnDisplayNameAt($j)), StrEscape($cmd->GetColumnPropertyNameAt($j)));
$cols = $cols . $col;
}
}
$cmdObjects = $cmdObjects . $cols;
// declare a new search command object
$cmdObject = sprintf("commands[%d] = new SearchCommand(\"%s\", \"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", resCols%d, \"%s\", %d, %d, \"%s\");\n", $i, StrEscape($name), StrEscape($cmd->GetLabel()), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $cmd->GetLayer(), StrEscape($cmd->GetPrompt()), $searchCmdIndex, StrEscape($cmd->GetFilter()), $cmd->GetMatchLimit(), $cmd->GetTarget(), $cmd->GetTargetName());
$searchCmdIndex++;
} else {
if ($action == MgWebActions::InvokeUrl) {
// create the parameter objects
$params = "var navParams" . $navCmdIndex . " = new Array();\n";
$layers = "var layers" . $navCmdIndex . " = new Array();\n";
if ($cmd->GetParameterCount() > 0) {
for ($j = 0; $j < $cmd->GetParameterCount(); $j++) {
$param = sprintf("navParams%d[%d] = new NavParam(\"%s\", \"%s\");\n", $navCmdIndex, $j, $cmd->GetParameterNameAt($j), $cmd->GetParameterValueAt($j));
$params = $params . $param;
}
}
for ($j = 0; $j < $cmd->GetLayerCount(); $j++) {
$layer = sprintf("layers%d[%d] = \"%s\";\n", $navCmdIndex, $j, $cmd->GetLayerNameAt($j));
$layers = $layers . $layer;
}
$cmdObjects = $cmdObjects . $params . $layers;
if ($cmd->DisabledIfSelectionEmpty() || $cmd->GetLayerCount() > 0) {
$selAwareCmds = $selAwareCmds . sprintf("selectionAwareCmds[%d] = %d;\n", $selAwareCmdCount, $i);
$selAwareCmdCount++;
}
// declare a new invokeurl command object
$cmdObject = sprintf("commands[%d] = new InvokeUrlCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", navParams%d, %s, layers%d, %d, \"%s\");\n", $i, StrEscape($name), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $cmd->GetUrl(), $navCmdIndex, $cmd->DisabledIfSelectionEmpty() ? "true" : "false", $navCmdIndex, $cmd->GetTarget(), $cmd->GetTargetName());
$navCmdIndex++;
} else {
if ($action == MgWebActions::Buffer || $action == MgWebActions::SelectWithin || $action == MgWebActions::Measure || $action == MgWebActions::ViewOptions || $action == MgWebActions::GetPrintablePage) {
if ($action == MgWebActions::Measure) {
if ($measureCmdIndex != 0) {
throw new Exception(GetLocalizedString("ALREADYINMEASURE", $locale));
}
$measureCmdIndex = $i;
} else {
if ($action == MgWebActions::SelectWithin) {
$selAwareCmds = $selAwareCmds . sprintf("selectionAwareCmds[%d] = %d;\n", $selAwareCmdCount, $i);
$selAwareCmdCount++;
}
}
// declare a new ui target command object
$cmdObject = sprintf("commands[%d] = new UiTargetCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", %d, \"%s\");\n", $i, StrEscape($name), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $cmd->GetTarget(), $cmd->GetTargetName());
} else {
if ($action == MgWebActions::Help) {
// declare a new help command object
$cmdObject = sprintf("commands[%d] = new HelpCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", %d, \"%s\");\n", $i, StrEscape($name), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $cmd->GetUrl(), $cmd->GetTarget(), $cmd->GetTargetName());
} else {
if ($action == MgWebActions::PrintMap) {
// declare the print layouts
$layouts = "var layouts" . $printCmdIndex . " = new Array();\n";
for ($j = 0; $j < $cmd->GetPrintLayoutCount(); $j++) {
$layout = "";
$layout = sprintf("layouts%d[%d] = \"%s\";\n", $printCmdIndex, $j, $cmd->GetPrintLayoutAt($j));
$layouts = $layouts . $layout;
}
$cmdObjects = $cmdObjects . $layouts;
// declare a new print command object
$cmdObject = sprintf("commands[%d] = new PrintCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", layouts%d);\n", $i, StrEscape($name), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $printCmdIndex);
$printCmdIndex++;
} else {
if ($action == MgWebActions::InvokeScript) {
// declare a new basic command object
$cmdObject = sprintf("commands[%d] = new InvokeScriptCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\", %d);\n", $i, StrEscape($name), $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()), $scriptCmdIndex);
$userCode = $userCode . "\nfunction UserFunc" . $scriptCmdIndex . "()\n{\n" . $cmd->GetScriptCode() . "\n}\n";
$userCodeCalls = $userCodeCalls . sprintf("case %d: UserFunc%d(); break;\n", $scriptCmdIndex, $scriptCmdIndex);
$scriptCmdIndex++;
} else {
// declare a new basic command object
$cmdObject = sprintf("commands[%d] = new BasicCommand(\"%s\", %d, \"%s\", \"%s\", \"%s\", \"%s\");\n", $i, $name, $cmd->GetAction(), $cmd->GetIconUrl(), $cmd->GetDisabledIconUrl(), StrEscape($cmd->GetTooltip()), StrEscape($cmd->GetDescription()));
}
}
}
}
}
}
$cmdObjects = $cmdObjects . $cmdObject;
$cmds[$name] = $i;
}
$userCodeCalls = $userCodeCalls . "\n}\n";
//Declare toolbar items
//
$toolbarDef = DeclareUiItems($toolBar->GetWidgets(), "toolbarItems");
//Declare task items
$taskListDef = DeclareUiItems($taskBar->GetTaskList(), "taskItems");
//Declare context menu items
$ctxMenu = $webLayout->GetContextMenu();
if ($ctxMenu->IsVisible()) {
$ctxMenuDef = DeclareUiItems($ctxMenu, "ctxMenuItems");
} else {
$ctxMenuDef = "";
}
//task items texts
//
$taskItemTexts = "";
$taskButtons = $taskBar->GetTaskButtons();
for ($i = 0; $i < 4; $i++) {
$btn = $taskButtons->GetWidget($i);
if ($i > 0) {
$taskItemTexts = $taskItemTexts . ",";
}
$taskItemTexts = $taskItemTexts . '"' . StrEscape($btn->GetName()) . '",' . '"' . StrEscape($btn->GetTooltip()) . '",' . '"' . StrEscape($btn->GetDescription()) . '",' . '"' . StrEscape($btn->GetIconUrl()) . '",' . '"' . StrEscape($btn->GetDisabledIconUrl()) . '"';
}
//transmit the session to the map pane if one was specified to this request
if ($orgSessionId != "") {
$sessionParam = "&SESSION=" . $orgSessionId;
} else {
$sessionParam = "";
}
//load the frameset template and format it
$frameset = "";
$viewerType = $forDwf ? "DWF" : "HTML";
if ($showTaskBar) {
$frameSetTempl = file_get_contents("../viewerfiles/framesettaskbar.templ");
$frameset = sprintf($frameSetTempl, $statusbarHeight, $taskWidth, $toolbarHeight, $srcToolbar, $vpath . "mapframe.php", $mapDefinitionUrl, $viewerType, $showLegend ? 1 : 0, $showProperties ? 1 : 0, $infoWidth, $locale, $webLayout->GetHyperlinkTarget(), $webLayout->GetHyperlinkTargetFrame(), $webLayout->IsZoomControlVisible() ? 1 : 0, $selectionColor, $mapImgFormat, $selImgFormat, $pointBuffer, $sessionParam, $vpath . "formframe.php", $taskbarHeight + 1, $srcTaskBar, $srcTaskFrame, $srcStatusbar);
} else {
$frameSetTempl = file_get_contents("../viewerfiles/framesetnotaskbar.templ");
$frameset = sprintf($frameSetTempl, $toolbarHeight, $statusbarHeight, $srcToolbar, $taskWidth, $vpath . "mapframe.php", $mapDefinitionUrl, $viewerType, $showLegend ? 1 : 0, $showProperties ? 1 : 0, $infoWidth, $locale, $webLayout->GetHyperlinkTarget(), $webLayout->GetHyperlinkTargetFrame(), $webLayout->IsZoomControlVisible() ? 1 : 0, $selectionColor, $mapImgFormat, $selImgFormat, $pointBuffer, $sessionParam, $srcTaskFrame, $vpath . "formframe.php", $srcStatusbar);
}
$homePageUrl = urldecode($taskPaneUrl);
if (strlen($homePageUrl) < 8 || strncasecmp($homePageUrl, "http://", 7) != 0) {
$homePageUrl = $vpath . $homePageUrl;
}
//load the HTML template and format it
//
$templ = Localize(file_get_contents("../viewerfiles/mainframe.templ"), $locale, GetClientOS());
print sprintf($templ, $title, GetRootVirtualFolder() . "/mapagent/mapagent.fcgi", $enablePingServer ? 1 : 0, $site->GetSite()->GetSessionTimeout(), $locale, $showToolbar ? 1 : 0, $showStatusbar ? 1 : 0, $showTaskPane ? 1 : 0, $showTaskPane ? 0 : ($showTaskBar ? 1 : 0), $homePageUrl, $defHome ? "1" : "0", $webLayoutDefinition, $mapDef, $taskWidth, $center, $webLayout->GetScale(), StrEscape($title), $forDwf ? "1" : "0", $cmdObjects, $toolbarDef, $taskListDef, $ctxMenuDef, $userCode, $taskItemTexts, $selAwareCmds, $startupScriptCode, $vpath . "quickplotpanel.php", $vpath . "measureui.php", $vpath . "searchprompt.php", $vpath . "bufferui.php", $vpath . "selectwithinui.php", $userCodeCalls, $vpath . "viewoptions.php", $frameset);
} catch (MgUserNotFoundException $e) {
requestAuthentication();
} catch (MgAuthenticationFailedException $e) {
requestAuthentication();
} catch (MgException $e) {
// This should be a 500 error of some sort, but
// in order to give a nice custom error message, it looks as
// if we shortcut things by using a 200 status.
$shortError = $e->GetExceptionMessage();
$longErrorMsg = EscapeForHtml($e->GetDetails());
header("HTTP/1.1 200 ");
header('Content-Type: text/html; charset=utf-8');
header("Status: 200 {$shortError}");
echo "<html>\n<body>\n";
echo $longErrorMsg;
echo "</body>\n</html>\n";
} catch (Exception $ne) {
$errorMsg = EscapeForHtml($ne->GetMessage());
echo $errorMsg;
}
}
function StaffWidgets($item, &$myextra = NULL)
{
global $extra, $_ROSARIO, $RosarioModules;
if (isset($myextra)) {
$extra =& $myextra;
}
if (!is_array($_ROSARIO['StaffWidgets'])) {
$_ROSARIO['StaffWidgets'] = array();
}
if (!is_array($extra['functions'])) {
$extra['functions'] = array();
}
if ((User('PROFILE') == 'admin' || User('PROFILE') == 'teacher') && !$_ROSARIO['StaffWidgets'][$item]) {
switch ($item) {
case 'all':
//modif Francois: css WPadmin
// $extra['search'] .= '<TR><TD>';
$extra['search'] .= '<TR><TD><TABLE style="border-collapse:separate; border-spacing:2px" class="width-100p cellpadding-2">';
if ($RosarioModules['Users'] && !$_ROSARIO['StaffWidgets']['permissions']) {
$extra['search'] .= '<TR><TD colspan="2"> <A onclick="switchMenu(\'users_table\');" href="#"><IMG SRC="assets/arrow_right.gif" id="users_table_arrow" height="12"> <B>' . _('Users') . '</B></A><BR /><TABLE id="users_table" style="display:none;" class="widefat width-100p cellspacing-0">';
StaffWidgets('permissions', $extra);
$extra['search'] .= '</TABLE></TD></TR>';
}
if ($RosarioModules['Food_Service'] && (!$_ROSARIO['StaffWidgets']['fsa_balance'] || !$_ROSARIO['StaffWidgets']['fsa_status'] || !$_ROSARIO['StaffWidgets']['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">';
StaffWidgets('fsa_balance', $extra);
StaffWidgets('fsa_status', $extra);
StaffWidgets('fsa_barcode', $extra);
StaffWidgets('fsa_exists', $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='StaffWidgetsSearch'" . (count($_ROSARIO['StaffWidgets']) ? " AND TITLE NOT IN ('" . implode("','", array_keys($_ROSARIO['StaffWidgets'])) . "')" : '')));
foreach ($widgets_RET as $widget) {
StaffWidgets($widget['TITLE'], $extra);
}
break;
case 'permissions_Y':
case 'permissions_N':
$value = mb_substr($item, 12);
$item = 'permissions';
case 'permissions':
if ($RosarioModules['Users']) {
if ($_REQUEST['permissions']) {
$extra['WHERE'] .= " AND s.PROFILE_ID IS " . ($_REQUEST['permissions'] == 'Y' ? 'NOT' : '') . " NULL AND s.PROFILE!='none'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Permissions')) . ' </b></span>' . ($_REQUEST['permissions'] == 'Y' ? _('Profile') : _('Custom')) . '<BR />';
}
}
//modif Francois: add <label> on radio
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Permissions') . '</TD><TD><label><INPUT type="radio" name="permissions" value=""' . (!$value ? ' checked' : '') . '> ' . _('All') . '</label> <label><INPUT type="radio" name="permissions" value="Y"' . ($value == 'Y' ? ' checked' : '') . '> ' . _('Profile') . '</label> <label><INPUT type="radio" name="permissions" value="N"' . ($value == 'N' ? ' checked' : '') . '> ' . _('Custom') . '</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_STAFF_ACCOUNTS fssa';
$extra['WHERE'] .= ' AND fssa.STAFF_ID=s.STAFF_ID';
}
$extra['WHERE'] .= " AND fssa.BALANCE" . ($_REQUEST['fsa_bal_gt'] == 'Y' ? '>=' : '<') . "'" . round($_REQUEST['fsa_balance'], 2) . "'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Food Service Balance')) . ' </b></span><span class="sizep2">' . ($_REQUEST['fsa_bal_ge'] == 'Y' ? '≥' : '<') . '</span>' . number_format($_REQUEST['fsa_balance'], 2) . '<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 . '"' : '') . '></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_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_STAFF_ACCOUNTS fssa';
$extra['WHERE'] .= ' AND fssa.STAFF_ID=s.STAFF_ID';
}
if ($_REQUEST['fsa_status'] == 'Active') {
$extra['WHERE'] .= ' AND fssa.STATUS IS NULL';
} else {
$extra['WHERE'] .= ' AND fssa.STATUS=\'' . $_REQUEST['fsa_status'] . '\'';
}
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Food Service Status')) . ' </b></span>' . $_REQUEST['fsa_status'] . '<BR />';
}
}
$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_STAFF_ACCOUNTS fssa';
$extra['WHERE'] .= ' AND fssa.STAFF_ID=s.STAFF_ID';
}
$extra['WHERE'] .= ' AND fssa.BARCODE=\'' . $_REQUEST['fsa_barcode'] . '\'';
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Food Service Barcode')) . ' </b></span>' . $_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_exists_N':
case 'fsa_exists_Y':
$value = mb_substr($item, 11);
$item = 'fsa_exists';
case 'fsa_exists':
if ($RosarioModules['Food_Service']) {
if ($_REQUEST['fsa_exists']) {
$extra['WHERE'] .= ' AND ' . ($_REQUEST['fsa_exists'] == 'N' ? 'NOT ' : '') . 'EXISTS (SELECT \'exists\' FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID)';
if (!$extra['NoSearchTerms']) {
//modif Francois: add translation
$_ROSARIO['SearchTerms'] .= Localize('colon', _('Food Service Account Exists')) . ' ' . ($_REQUEST['fsa_exists'] == 'Y' ? _('Yes') : _('No')) . '<BR />';
}
}
$extra['search'] .= '<TR><TD style="text-align:right; width:120px:">' . _('Has Account') . '</TD><TD><label><INPUT type="radio" name="fsa_exists" value=""' . (!$value ? ' checked' : '') . '>' . _('All') . '</label> <label><INPUT type="radio" name="fsa_exists" value="Y"' . ($value == 'Y' ? ' checked' : '') . '>' . _('Yes') . '</label> <label><INPUT type="radio" name="fsa_exists" value="N"' . ($value == 'N' ? ' checked' : '') . '>' . _('No') . '</label></TD></TR>';
}
break;
}
$_ROSARIO['StaffWidgets'][$item] = true;
}
}
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
//modif Francois: remove LO_field
$return = '<TABLE class="cellpadding-0 cellspacing-0"><TR><TD><b>' . Localize('colon', _('Visible Between')) . '</b></TD><TD style="text-align:right">';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD><TD> ' . _('to') . ' </TD><TD>';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
//modif Francois: css WPadmin
$return .= '<TR><TD colspan="4" style="padding:0">';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM USER_PROFILES ORDER BY ID WHERE"));
}
$return .= '<TABLE class="width-100p cellspacing-0 cellpadding-0"><TR><TD colspan="4"><b>' . Localize('colon', _('Visible To')) . '</b></TD></TR><TR>';
foreach (array('admin' => _('Administrator w/Custom'), 'teacher' => _('Teacher w/Custom'), 'parent' => _('Parent w/Custom')) as $profile_id => $profile) {
//modif Francois: add <label> on checkbox
$return .= '<TD><label><INPUT type="checkbox" name="profiles[$id][' . $profile_id . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' checked' : '') . ' /> ' . $profile . '</label></TD>';
}
//modif Francois: Portal Polls add students teacher
$teachers_RET = DBGet(DBQuery("SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM STAFF WHERE (SCHOOLS IS NULL OR STRPOS(SCHOOLS,'," . UserSchool() . ",')>0) AND SYEAR='" . UserSyear() . "' AND PROFILE='teacher' ORDER BY LAST_NAME,FIRST_NAME"));
if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = $teacher['LAST_NAME'] . ', ' . $teacher['FIRST_NAME'];
}
}
$i = 0;
foreach ($profiles_RET as $profile) {
$i++;
if ($profile['ID'] == 0) {
//student
$return .= '</TR><TR>';
}
$return .= '<TD><label><INPUT type="checkbox" name="profiles[' . $id . '][' . $profile['ID'] . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' checked' : '') . ' /> ' . _($profile['TITLE']);
//modif Francois: Portal Polls add students teacher
if ($profile['ID'] == 0) {
$return .= ': </label></TD>';
$return .= '<TD colspan="2">' . SelectInput($THIS_RET['STUDENTS_TEACHER_ID'], 'values[' . $id . '][STUDENTS_TEACHER_ID]', _('Limit to Teacher'), $teachers, true, '', true) . '</TD>';
$i = $i + 2;
} else {
$return .= '</label></TD>';
}
if ($i % 3 == 0 && $i != count($profile)) {
$return .= '</TR><TR>';
}
}
for (; $i % 3 != 0; $i++) {
$return .= '<TD> </TD>';
}
$return .= '</TR>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
function _makePeriod($value, $column)
{
global $THIS_RET;
return ($value ? Localize('colon', _('On')) . ' ' . GetPeriod($value) : '') . ($THIS_RET['NOT_PERIOD_ID'] ? ($value ? '<BR />' : '') . Localize('colon', _('Not on')) . ' ' . GetPeriod($THIS_RET['NOT_PERIOD_ID']) : '');
}
function appendSQL($sql, $extra = array())
{
global $_ROSARIO;
if ($_REQUEST['stuid']) {
//modif Francois: allow comma separated list of student IDs
$stuid_array = explode(',', $_REQUEST['stuid']);
$stuids = array();
foreach ($stuid_array as $stuid) {
if (is_numeric($stuid)) {
$stuids[] = $stuid;
}
}
if (!empty($stuids)) {
$stuids = implode(',', $stuids);
//$sql .= " AND ssm.STUDENT_ID IN '".$_REQUEST['stuid']."'";
$sql .= " AND ssm.STUDENT_ID IN (" . $stuids . ")";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('RosarioSIS ID')) . ' </b></span>' . $stuids . '<BR />';
}
}
}
if ($_REQUEST['last']) {
$sql .= " AND LOWER(s.LAST_NAME) LIKE '" . mb_strtolower($_REQUEST['last']) . "%'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Last Name starts with')) . ' </b></span>' . str_replace("''", "'", $_REQUEST['last']) . '<BR />';
}
}
if ($_REQUEST['first']) {
$sql .= " AND LOWER(s.FIRST_NAME) LIKE '" . mb_strtolower($_REQUEST['first']) . "%'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('First Name starts with')) . ' </b></span>' . str_replace("''", "'", $_REQUEST['first']) . '<BR />';
}
}
if ($_REQUEST['grade']) {
$sql .= " AND ssm.GRADE_ID = '{$_REQUEST['grade']}'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Grade Level')) . ' </b></span>' . GetGrade($_REQUEST['grade']) . '<BR />';
}
}
if (count($_REQUEST['grades'])) {
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', ngettext('Grade', 'Grades', sizeof($_REQUEST['grades']))) . ' </b></span>' . ($_REQUEST['grades_not'] == 'Y' ? _('Excluded') . ' ' : '');
}
$list = $sep = '';
foreach ($_REQUEST['grades'] as $id => $y) {
$list .= "{$sep}'{$id}'";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= $sep . GetGrade($id);
}
$sep = ',';
}
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<BR />';
}
$sql .= " AND ssm.GRADE_ID " . ($_REQUEST['grades_not'] == 'Y' ? 'NOT ' : '') . " IN ({$list})";
}
if ($_REQUEST['addr']) {
$sql .= " AND (LOWER(a.ADDRESS) LIKE '%" . mb_strtolower($_REQUEST['addr']) . "%' OR LOWER(a.CITY) LIKE '" . mb_strtolower($_REQUEST['addr']) . "%' OR LOWER(a.STATE)='" . mb_strtolower($_REQUEST['addr']) . "' OR ZIPCODE LIKE '" . $_REQUEST['addr'] . "%')";
if (!$extra['NoSearchTerms']) {
$_ROSARIO['SearchTerms'] .= '<span style="color:gray"><b>' . Localize('colon', _('Address contains')) . ' </b></span>' . str_replace("''", "'", $_REQUEST['addr']) . '<BR />';
}
}
return $sql;
}
function reminder($student, $teacher, $xstudents, $target, $last_deposit, $note)
{
$payment = $target - $student['BALANCE'];
if ($_REQUEST['year_end'] == 'Y') {
$payment = floor($payment * 2 + 0.99) / 2;
}
if ($payment <= 0) {
return;
}
$payment = number_format($payment, 2);
echo '<TABLE class="width-100p">';
echo '<TR><TD colspan="3" class="center"><span class="sizep1"><I><B>* * * ' . ($_REQUEST['year_end'] == 'Y' ? _('Year End') . ' ' : '') . _('Lunch Payment Reminder') . ' * * *</B></I></span></TD></TR>';
echo '<TR><TD colspan="3" class="center"><B>' . $student['SCHOOL'] . '</B></TD></TR>';
echo '<TR><TD style="width:33%;">';
echo ($student['NICKNAME'] ? $student['NICKNAME'] : $student['FIRST_NAME']) . ' ' . $student['LAST_NAME'] . '<BR />';
echo '' . $student['STUDENT_ID'] . '';
if (count($xstudents)) {
echo '<BR />' . Localize('colon', _('Other students on this account'));
foreach ($xstudents as $xstudent) {
echo '<BR /> ' . ($xstudent['NICKNAME'] ? $xstudent['NICKNAME'] : $xstudent['FIRST_NAME']) . ' ' . $xstudent['LAST_NAME'];
}
echo '';
}
echo '</TD><TD style="width:33%;">';
echo $student['GRADE'] . '<BR />';
echo 'Grade';
echo '</TD><TD style="width:33%;">';
echo $teacher['FULL_NAME'] . '<BR />';
echo '' . $teacher['TITLE'] . ' ' . _('Teacher') . '';
echo '</TD></TR>';
echo '<TR><TD style="width:33%;">';
echo ProperDate(DBDate()) . '<BR />';
echo '' . _('Today\'s Date') . '';
echo '</TD><TD style="width:34%;">';
echo ($last_deposit ? $last_deposit['DATE'] : _('None')) . '<BR />';
echo '' . _('Date of Last Deposit') . '';
echo '</TD><TD style="width:33%;">';
echo ($last_deposit ? $last_deposit['AMOUNT'] : _('None')) . '<BR />';
echo '' . _('Amount of Last Deposit') . '';
echo '</TD></TR>';
echo '<TR><TD style="width:33%;">';
echo ($student['BALANCE'] < 0 ? '<B>' . Currency($student['BALANCE']) . '</B>' : Currency($student['BALANCE'])) . '<BR />';
echo '' . _('Balance') . '';
echo '</TD><TD style="width:34%;">';
echo '<B>' . Currency($payment) . '</B><BR />';
echo '<B>' . ($_REQUEST['year_end'] == 'Y' ? _('Requested Payment') : _('Mimimum Payment')) . ' </B>';
echo '</TD><TD style="width:33%;">';
echo $student['ACCOUNT_ID'] . '<BR />';
echo '' . _('Account ID') . '';
echo '</TD></TR>';
$note = str_replace('%N', $student['NICKNAME'] ? $student['NICKNAME'] : $student['FIRST_NAME'], $note);
$note = str_replace('%F', $student['FIRST_NAME'], $note);
$note = str_replace('%g', $student['GENDER'] ? mb_substr($student['GENDER'], 0, 1) == 'F' ? 'she' : 'he' : 'he/she', $note);
$note = str_replace('%G', $student['GENDER'] ? mb_substr($student['GENDER'], 0, 1) == 'F' ? 'She' : 'He' : 'He/she', $note);
$note = str_replace('%h', $student['GENDER'] ? mb_substr($student['GENDER'], 0, 1) == 'F' ? 'her' : 'his' : 'his/her', $note);
$note = str_replace('%H', $student['GENDER'] ? mb_substr($student['GENDER'], 0, 1) == 'F' ? 'Her' : 'His' : 'His/her', $note);
// $note = str_replace('%P',money_format('%i',$payment),$note);
$note = str_replace('%P', Currency($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>';
}
$keys = array_keys($language);
usort($keys, function ($a, $b) {
return strlen($b) - strlen($a);
});
IncludeJSBlock('
window.Language.Instance=new Language({' . "\n" . implode(",\n", array_map(function ($k) use($language) {
return ' ' . json_encode($k) . ':' . json_encode($language[$k]);
}, $keys)) . "\n" . '});
');
Core::LibDir() . DS . 'easycsv' . DS . 'EasyCsv.php';
//print_r($language);
Localize(function () {
Scaffold('scheduled.workspace');
Scaffold('addendum.workspace');
Scaffold('quarterly.workspace');
}, $language);
Scaffold('list.scheduled');
$q = (int) ((date('n') - 1) / 3);
$quarters = array('1st', '2nd', '3rd', '4th');
$quarter = $quarters[$q];
IncludeJSBlock('
window.addEvent("load",function(){
var ajaxUrl=' . json_encode($params['url']) . ';
UIFormManager.setAjaxUrl(ajaxUrl);
}
$events_RET = DBGet(DBQuery("SELECT ce.TITLE,ce.DESCRIPTION,ce.SCHOOL_DATE,to_char(ce.SCHOOL_DATE,'Dy') AS DAY,s.TITLE AS SCHOOL FROM CALENDAR_EVENTS ce,SCHOOLS s WHERE ce.SCHOOL_DATE BETWEEN CURRENT_DATE AND CURRENT_DATE+6 AND ce.SYEAR='" . UserSyear() . "' AND position(','||ce.SCHOOL_ID||',' IN (SELECT SCHOOLS FROM STAFF WHERE STAFF_ID='" . User('STAFF_ID') . "'))>0 AND s.ID=ce.SCHOOL_ID AND s.SYEAR=ce.SYEAR ORDER BY ce.SCHOOL_DATE,s.TITLE"), array('SCHOOL_DATE' => 'ProperDate'), array('SCHOOL_DATE'));
if (count($events_RET)) {
echo '<p>';
ListOutput($events_RET, array('DAY' => _('Day'), 'SCHOOL_DATE' => _('Date'), 'TITLE' => _('Event'), 'DESCRIPTION' => _('Description'), 'SCHOOL' => _('School')), _('Day With Upcoming Events'), _('Days With Upcoming Events'), array(), array('SCHOOL_DATE'), array('save' => false, 'search' => false));
echo '</p>';
}
if (Preferences('HIDE_ALERTS') != 'Y') {
// warn if missing attendances
$categories_RET = DBGet(DBQuery("SELECT '0' AS ID,'Attendance' AS TITLE,0,NULL AS SORT_ORDER UNION SELECT ID,TITLE,1,SORT_ORDER FROM ATTENDANCE_CODE_CATEGORIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY 3,SORT_ORDER"));
foreach ($categories_RET as $category) {
$daysWeek = _('SuMoTuWeThFrSa');
/// Days of the week
$RET = DBGET(DBQuery("SELECT cp.COURSE_PERIOD_ID,acc.SCHOOL_DATE,cp.TITLE FROM ATTENDANCE_CALENDAR acc,COURSE_PERIODS cp,SCHOOL_PERIODS sp WHERE acc.SYEAR='" . UserSyear() . "' AND (acc.MINUTES IS NOT NULL AND acc.MINUTES>0) AND cp.SCHOOL_ID=acc.SCHOOL_ID AND cp.SYEAR=acc.SYEAR AND acc.SCHOOL_DATE<'" . DBDate() . "' AND cp.CALENDAR_ID=acc.CALENDAR_ID AND cp.TEACHER_ID='" . User('STAFF_ID') . "'\n AND cp.MARKING_PERIOD_ID IN (SELECT MARKING_PERIOD_ID FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE UNION SELECT MARKING_PERIOD_ID FROM SCHOOL_MARKING_PERIODS WHERE MP='SEM' AND SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE UNION SELECT MARKING_PERIOD_ID FROM SCHOOL_MARKING_PERIODS WHERE MP='QTR' AND SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE)\n\t\t\tAND sp.PERIOD_ID=cp.PERIOD_ID AND (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\t\tOR sp.BLOCK IS NOT NULL AND acc.BLOCK IS NOT NULL AND sp.BLOCK=acc.BLOCK)\n\t\t\tAND NOT exists(SELECT '' FROM ATTENDANCE_COMPLETED ac WHERE ac.SCHOOL_DATE=acc.SCHOOL_DATE AND ac.STAFF_ID=cp.TEACHER_ID AND ac.PERIOD_ID=cp.PERIOD_ID AND TABLE_NAME='{$category['ID']}') AND position(',{$category['ID']},' IN cp.DOES_ATTENDANCE)>0 ORDER BY cp.TITLE,acc.SCHOOL_DATE"), array('SCHOOL_DATE' => 'ProperDate'), array('COURSE_PERIOD_ID'));
if (count($RET)) {
echo '<p><font color=red><b>' . _('Warning!') . '</b></font> - ' . sprintf(Localize('colon', _('You have missing <b>%s</b> attendance data')), $category['TITLE']);
ListOutput($RET, array('SCHOOL_DATE' => _('Date'), 'TITLE' => _('Period - Teacher')), sprintf(_('Period with missing %s attendance data'), $category['TITLE']), sprintf(_('Periods with missing %s attendance data'), $category['TITLE']), array(), array('COURSE_PERIOD_ID'), array('save' => false, 'search' => false));
echo '</p>';
}
}
}
if ($CentreModules['Food_Service'] && Preferences('HIDE_ALERTS') != 'Y') {
// warn if negative food service balance
$staff = DBGet(DBQuery('SELECT (SELECT STATUS FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS STATUS,(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=s.STAFF_ID) AS BALANCE FROM STAFF s WHERE s.STAFF_ID=' . User('STAFF_ID')));
$staff = $staff[1];
if ($staff['BALANCE'] && $staff['BALANCE'] < 0) {
echo '<p><font color=red><b>' . _('Warning!') . '</b></font> - ' . sprintf(_('You have a <b>negative</b> food service balance of <font color=red>%s</font>'), $staff['BALANCE']) . '</p>';
}
}
echo '<p> ' . _('Happy teaching...') . '</p>';
break;
// This library is free software; you can redistribute it and/or
// modify it under the terms of version 2.1 of the GNU Lesser
// General Public License as published by the Free Software Foundation.
//
// This library 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
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
//
include 'common.php';
$locale = "";
GetRequestParameters();
SetLocalizedFilesPath(GetLocalizationPath());
print Localize(file_get_contents("../viewerfiles/tasklist.templ"), $locale, GetClientOS());
function GetParameters($params)
{
global $locale;
$locale = ValidateLocaleString(GetParameter($params, 'LOCALE'));
}
function GetRequestParameters()
{
if ($_SERVER['REQUEST_METHOD'] == "POST") {
GetParameters($_POST);
} else {
GetParameters($_GET);
}
}
<?php
$max_cols = 3;
$max_rows = 10;
$to_family = Localize('colon', _('To the parents of'));
if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'save') {
if (count($_REQUEST['st_arr'])) {
$st_list = '\'' . implode('\',\'', $_REQUEST['st_arr']) . '\'';
$extra['WHERE'] = " AND s.STUDENT_ID IN ({$st_list})";
$_REQUEST['mailing_labels'] = 'Y';
if ($_REQUEST['to_address']) {
$_REQUEST['residence'] = 'Y';
}
Widgets('mailing_labels');
$extra['SELECT'] .= ",s.FIRST_NAME AS NICK_NAME";
$extra['group'] = array('ADDRESS_ID');
$RET = GetStuList($extra);
if (count($RET)) {
$handle = PDFstart();
//echo '<!-- MEDIA SIZE 8.5x11in -->';
echo '<!-- MEDIA TOP 0.5in -->';
echo '<!-- MEDIA BOTTOM 0.25in -->';
echo '<!-- MEDIA LEFT 0.25in -->';
echo '<!-- MEDIA RIGHT 0.25in -->';
echo '<!-- FOOTER RIGHT "" -->';
echo '<!-- FOOTER LEFT "" -->';
echo '<!-- FOOTER CENTER "" -->';
echo '<!-- HEADER RIGHT "" -->';
echo '<!-- HEADER LEFT "" -->';
echo '<!-- HEADER CENTER "" -->';
echo '<table style="height: 100%" class="width-100p cellspacing-0 cellpadding-0">';
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$return = '<TABLE><TR><TD class=LO_field><b>' . Localize('colon', _('Visible Between')) . '</b></TD><TD align=right>';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD><TD width=1> ' . _('to') . ' </TD><TD>';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
$return .= '<TR><TD width=100% colspan=4 bgcolor=black height=1></TD></TR><TR><TD colspan=4>';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM USER_PROFILES ORDER BY ID"));
}
$return .= '<TABLE border=0 cellspacing=0 cellpadding=0 class=LO_field><TR><TD colspan=4><b>' . Localize('colon', _('Visible To')) . '</b></TD></TR>';
foreach (array('admin' => _('Administrator w/Custom'), 'teacher' => _('Teacher w/Custom'), 'parent' => _('Parent w/Custom')) as $profile_id => $profile) {
$return .= "<TD><INPUT type=checkbox name=profiles[{$id}][{$profile_id}] value=Y" . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' CHECKED' : '') . "> {$profile}</TD>";
}
$i = 3;
foreach ($profiles_RET as $profile) {
$i++;
$return .= '<TD><INPUT type=checkbox name=profiles[' . $id . '][' . $profile['ID'] . '] value=Y' . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' CHECKED' : '') . ">" . _($profile[TITLE]) . "</TD>";
if ($i % 4 == 0 && $i != count($profile)) {
$return .= '</TR><TR>';
}
}
for (; $i % 4 != 0; $i++) {
$return .= '<TD></TD>';
}
$return .= '</TR>';
//<TR><TD colspan=4><B><A HREF=#>Schools: ...</A></B></TD></TR></TABLE>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
function OnError($title, $msg)
{
global $target;
$templ = Localize(file_get_contents("../viewerfiles/errorpage.templ"), $locale, GetClientOS());
print sprintf($templ, "0", $title, $msg);
}
</script>
<!-- /TinyMCE -->
<?php
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=save&include_inactive=' . $_REQUEST['include_inactive'] . '&_ROSARIO_PDF=true" method="POST">';
$extra['header_right'] = SubmitButton(_('Create Honor Roll for Selected Students'));
$extra['extra_header_left'] = '<TABLE>';
//modif Francois: add <label> on radio
$extra['extra_header_left'] .= '<TR><TD><label><INPUT type="radio" name="list" value="list"> ' . _('List') . '</label></TD></TR>';
$extra['extra_header_left'] .= '<TR><TD><label><INPUT type="radio" name="list" value="" checked /> ' . _('Certificates') . ':</label></TD></TR>';
//modif Francois: add TinyMCE to the textarea
$extra['extra_header_left'] .= '<TR><TD> </TD></TR><TR><TD style="text-align:right; vertical-align: top;">' . _('Text') . '</TD><TD colspan="4"><TEXTAREA cols="97" rows="27" name="honor_roll_text" class="tinymce">';
//modif Francois: add Template
$templates = DBGet(DBQuery("SELECT TEMPLATE, STAFF_ID FROM TEMPLATES WHERE MODNAME = '" . $_REQUEST['modname'] . "' AND STAFF_ID IN (0,'" . User('STAFF_ID') . "')"), array(), array('STAFF_ID'));
$extra['extra_header_left'] .= str_replace(array('<', '>', '"'), array('<', '>', '"'), $templates[User('STAFF_ID')] ? $templates[User('STAFF_ID')][1]['TEMPLATE'] : $templates[0][1]['TEMPLATE']);
$extra['extra_header_left'] .= '</TEXTAREA></TD></TR>';
$extra['extra_header_left'] .= '<TR><TD style="text-align:right; vertical-align: top;">' . Localize('colon', _('Substitutions')) . '</TD><TD><TABLE><TR>';
$extra['extra_header_left'] .= '<TD>__FULL_NAME__</TD><TD>= ' . _('Last, First M') . '</TD><TD> </TD>';
$extra['extra_header_left'] .= '<TD>__LAST_NAME__</TD><TD>= ' . _('Last Name') . '</TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD>__FIRST_NAME__</TD><TD>= ' . _('First Name') . '</TD><TD> </TD>';
$extra['extra_header_left'] .= '<TD>__MIDDLE_NAME__</TD><TD>= ' . _('Middle Name') . '</TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD>__SCHOOL_ID__</TD><TD>= ' . _('School') . '</TD><TD> </TD>';
$extra['extra_header_left'] .= '<TD>__GRADE_ID__</TD><TD>= ' . _('Grade Level') . '</TD>';
$extra['extra_header_left'] .= '</TR></TABLE></TD></TR>';
//modif Francois: add frames choice
$frames = array();
if (is_dir('assets/Frames/')) {
$frames = scandir('assets/Frames/');
}
//no frame first and checked
function appendStaffSQL($sql, $extra)
{
global $_CENTRE;
if ($_REQUEST['usrid']) {
$sql .= " AND s.STAFF_ID='" . $_REQUEST['usrid'] . "'";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('User ID')) . ' </b></font>' . $_REQUEST['usrid'] . '<BR>';
}
}
if ($_REQUEST['last']) {
$sql .= " AND UPPER(s.LAST_NAME) LIKE '" . strtoupper($_REQUEST['last']) . "%'";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('Last Name starts with')) . ' </b></font>' . $_REQUEST['last'] . '<BR>';
}
}
if ($_REQUEST['first']) {
$sql .= " AND UPPER(s.FIRST_NAME) LIKE '" . strtoupper($_REQUEST['first']) . "%'";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('First Name starts with')) . ' </b></font>' . $_REQUEST['first'] . '<BR>';
}
}
if ($_REQUEST['profile']) {
$sql .= " AND s.PROFILE='" . $_REQUEST['profile'] . "'";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('Profile')) . ' </b></font>' . $_REQUEST['profile'] . '<BR>';
}
}
if ($_REQUEST['username']) {
$sql .= " AND UPPER(s.USERNAME) LIKE '" . strtoupper($_REQUEST['username']) . "%'";
if (!$extra['NoSearchTerms']) {
$_CENTRE['SearchTerms'] .= '<font color=gray><b>' . Localize('colon', _('UserName starts with')) . ' </b></font>' . $_REQUEST['username'] . '<BR>';
}
}
return $sql;
}
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;
}
}
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
//
include 'common.php';
$locale = "";
GetRequestParameters();
SetLocalizedFilesPath(GetLocalizationPath());
//This detection assumed 2 browsers, IE and Mozilla.
//Because Mozilla cannot render properly the border within the cell, we show this border only on IE
$user_agent = strtolower($_SERVER['HTTP_USER_AGENT']);
if (strpos($user_agent, "msie")) {
$borderColor = "#c0c0c0";
} else {
$borderColor = "#dfdfdf";
}
// Load the HTML template, format it and returns it to the client
//
print Localize(file_get_contents("../viewerfiles/statusbar.templ"), $locale, GetClientOS());
function GetParameters($params)
{
global $locale;
$locale = ValidateLocaleString(GetParameter($params, 'LOCALE'));
}
function GetRequestParameters()
{
if ($_SERVER['REQUEST_METHOD'] == "POST") {
GetParameters($_POST);
} else {
GetParameters($_GET);
}
}
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
include 'common.php';
include 'constants.php';
$locale = GetDefaultLocale();
$scaleDenominator;
$annotations;
$args = GetRequestMethod();
GetParameters($args);
$templ = file_get_contents("../viewerfiles/quickplotpreviewinner.templ");
SetLocalizedFilesPath(GetLocalizationPath());
// Localize the page
$templ = Localize($templ, $locale, GetClientOS());
// Set some annotation labels in the page by replacing the placeholders in the html code
$templ = str_replace(array_keys($annotations), array_values($annotations), $templ);
// Set the date annotation according to its format mask
$pattern = "/\\{date:.*\\[php=(.+?)\\].+?\\}/";
$matches = array();
if (preg_match($pattern, $templ, $matches)) {
$mask = $matches[1];
$date = date($mask);
$templ = preg_replace($pattern, $date, $templ);
}
$jsPath = "../viewerfiles/";
print sprintf($templ, $jsPath);
?>
<?php
echo '<TABLE width=100% border=0 cellpadding=0 cellspacing=0>';
echo '<TR><TD valign=top>';
echo '<TABLE border=0 cellpadding=6 width=100%>';
echo '<TR>';
echo '<TD>';
// warn if account non-existent (balance query failed)
if ($student['BALANCE'] == '') {
echo TextInput(array($student['ACCOUNT_ID'], '<FONT color=red>' . $student['ACCOUNT_ID'] . '</FONT>'), 'food_service[ACCOUNT_ID]', _('Account ID'), 'size=12 maxlength=10');
$warning = 'Non-existent account!';
echo button('warning', '', '# onMouseOver=\'stm(["Warning","' . $warning . '"],["white","#006699","","","",,"black","#e8e8ff","","","",,,,2,"#006699",2,,,,,"",,,,]);\' onMouseOut=\'htm()\'');
} else {
echo TextInput($student['ACCOUNT_ID'], 'food_service[ACCOUNT_ID]', 'Account ID', 'size=12 maxlength=10');
}
// warn if other students associated with the same account
if (count($xstudents)) {
$warning = Localize('colon', _('Other students associated with the same account')) . '<BR>';
foreach ($xstudents as $xstudent) {
$warning .= ' ' . str_replace('\'', ''', $xstudent['FULL_NAME']) . '<BR>';
}
echo button('warning', '', '# onMouseOver=\'stm(["Warning","' . $warning . '"],["white","#006699","","","",,"black","#e8e8ff","","","",,,,2,"#006699",2,,,,,"",,,,]);\' onMouseOut=\'htm()\'');
}
echo '</TD>';
$options = array('Inactive' => _('Inactive'), 'Disabled' => _('Disabled'), 'Closed' => _('Closed'));
echo '<TD>' . SelectInput($student['STATUS'], 'food_service[STATUS]', _('Status'), $options, _('Active')) . '</TD>';
echo '</TR><TR>';
$options = array('Reduced' => 'Reduced', 'Free' => 'Free');
echo '<TD>' . SelectInput($student['DISCOUNT'], 'food_service[DISCOUNT]', _('Discount'), $options, _('Full')) . '</TD>';
echo '<TD>' . TextInput($student['BARCODE'], 'food_service[BARCODE]', _('Barcode'), 'size=12 maxlength=25') . '</TD>';
echo '</TR>';
echo '</TABLE>';
echo '</TD></TR>';
}
//echo '</body></html>';
echo '</body>';
PDFstop($handle);
} else {
BackPrompt(_('No Students were found.'));
}
}
}
if (!$_REQUEST['modfunc']) {
DrawHeader(ProgramTitle());
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save&include_inactive={$_REQUEST['include_inactive']}&_search_all_schools={$_REQUEST['_search_all_schools']}" . (User('PROFILE') == 'admin' ? "&w_course_period_id_which={$_REQUEST['w_course_period_id_which']}&w_course_period_id={$_REQUEST['w_course_period_id']}" : '') . "&_CENTRE_PDF=true method=POST>";
$extra['header_right'] = '<INPUT type=submit value="' . _('Create Labels for Selected Students') . '">';
$extra['extra_header_left'] = '<TABLE>';
$extra['extra_header_left'] .= '<TR><TD colspan=4><b>' . Localize('colon', _('Include On Labels')) . '</b></TD></TR>';
$extra['extra_header_left'] .= '<TR>';
if (Preferences('NAME') == 'Common') {
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value="" checked><small>' . _('Last, Common') . '</small></TD>';
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value=given><small>' . _('Last, Given Middle') . '</small></TD>';
} else {
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value="" checked><small>' . _('Last, Given Middle') . '</small></TD>';
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value=common><small>' . _('Last, Common') . '</small></TD>';
}
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value=given_natural><small>' . _('Given Last') . '</small></TD>';
$extra['extra_header_left'] .= '<TD><INPUT type=radio name=full_name value=common_natural><small>' . _('Common Last') . '</small></TD></TR>';
if (User('PROFILE') == 'admin') {
if ($_REQUEST['w_course_period_id_which'] == 'course_period' && $_REQUEST['w_course_period_id']) {
$course_RET = DBGet(DBQuery("SELECT s.FIRST_NAME||' '||s.LAST_NAME AS TEACHER,cp.ROOM FROM STAFF s,COURSE_PERIODS cp WHERE s.STAFF_ID=cp.TEACHER_ID AND cp.COURSE_PERIOD_ID='{$_REQUEST['w_course_period_id']}'"));
$extra['extra_header_left'] .= '<TR><TD colspan=4><INPUT type=checkbox name=teacher value=Y>' . _('Teacher') . ' (' . $course_RET[1]['TEACHER'] . ')</TD></TR>';
$extra['extra_header_left'] .= '<TR><TD colspan=4><INPUT type=checkbox name=room value=Y>' . _('Room') . ' (' . $course_RET[1]['ROOM'] . ')</TD></TR>';
DBQuery($sql);
}
$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}'>";
}
}
PDFStop($handle);
} else {
BackPrompt(_('No Students were found.'));
}
} else {
BackPrompt(_('You must choose at least one student and marking period'));
}
}
if (!$_REQUEST['modfunc']) {
DrawHeader(ProgramTitle());
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM action=modules/Grades/gentranscript.php method=POST>";
$extra['header_right'] = '<INPUT type=submit value="' . _('Create Transcripts for Selected Students') . '">';
$extra['extra_header_left'] = '<TABLE>';
$extra['extra_header_left'] .= '<TR><TD colspan=2><b>' . Localize('colon', _('Include on Transcript')) . '</b><INPUT type=hidden name=SCHOOL_ID value=' . UserSchool() . '><BR></TD></TR>';
$mp_types = DBGet(DBQuery("SELECT DISTINCT MP_TYPE FROM MARKING_PERIODS WHERE NOT MP_TYPE IS NULL AND SCHOOL_ID = " . UserSchool()), array(), array());
$extra['extra_header_left'] .= '<TR><TD align=right>' . _('Marking Periods') . '</TD><TD><TABLE><TR><TD><TABLE>';
foreach ($mp_types as $mp_type) {
$extra['extra_header_left'] .= '<TR>';
$extra['extra_header_left'] .= '<TD><INPUT type=checkbox name=mp_type_arr[] value=' . $mp_type['MP_TYPE'] . '>' . _(ucwords($mp_type['MP_TYPE'])) . '</TD>';
$extra['extra_header_left'] .= '</TR>';
}
$extra['extra_header_left'] .= '</TABLE></TD>';
$extra['extra_header_left'] .= '<INPUT type=hidden name=syear value=' . UserSyear() . '>';
$extra['extra_header_left'] .= '<TD align=right width=20> </TD>';
$extra['extra_header_left'] .= '<TD align=right> ' . _('Other Options') . '</TD>';
$extra['extra_header_left'] .= '<TD><TABLE>';
$extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=showstudentpic value=1>' . _('Student Photo') . '</TD></TR>';
//$extra['extra_header_left'] .= '<TR><TD><INPUT type=checkbox name=showsat value=1>SAT Scores</TD></TR>';
$extra['extra_header_left'] .= '</TABLE></TD>';
//modif Francois: add <label> on checkbox
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[teacher]" value="Y" checked /> ' . _('Teacher') . '</label></TD>';
$extra['extra_header_left'] .= '<TD></TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[comments]" value="Y" checked /> ' . _('Comments') . '</label></TD>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[percents]" value="Y"> ' . _('Percents') . '</label></TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[ytd_absences]" value="Y" checked /> ' . _('Year-to-date Daily Absences') . '</label></TD>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[mp_absences]" value="Y"' . (GetMP(UserMP(), 'SORT_ORDER') != 1 ? ' checked' : '') . '> ' . _('Daily Absences this quarter') . '</label></TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[ytd_tardies]" value="Y"> ' . Localize('colon', _('Other Attendance Year-to-date')) . '</label> <SELECT name="ytd_tardies_code">';
foreach ($attendance_codes as $code) {
$extra['extra_header_left'] .= '<OPTION value=' . $code['ID'] . '>' . $code['TITLE'] . '</OPTION>';
}
$extra['extra_header_left'] .= '</SELECT></TD>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[mp_tardies]" value="Y"> ' . Localize('colon', _('Other Attendance Year-to-date')) . '</label> <SELECT name="mp_tardies_code">';
foreach ($attendance_codes as $code) {
$extra['extra_header_left'] .= '<OPTION value=' . $code['ID'] . '>' . $code['TITLE'] . '</OPTION>';
}
$extra['extra_header_left'] .= '</SELECT></TD>';
$extra['extra_header_left'] .= '</TR><TR>';
$extra['extra_header_left'] .= '<TD><label><INPUT type="checkbox" name="elements[period_absences]" value="Y"> ' . _('Period-by-period absences') . '</label></TD>';
$extra['extra_header_left'] .= '<TD></TD>';
$extra['extra_header_left'] .= '</TR>';
$extra['extra_header_left'] .= '</TABLE></TD></TR>';
//modif Francois: get the title instead of the short marking period name
$mps_RET = DBGet(DBQuery("SELECT PARENT_ID,MARKING_PERIOD_ID,SHORT_NAME,TITLE FROM SCHOOL_MARKING_PERIODS WHERE MP='QTR' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"), array(), array('PARENT_ID'));
$extra['extra_header_left'] .= '<TR><TD style="text-align:right">' . _('Marking Periods') . ':</TD><TD><TABLE><TR><TD><TABLE>';
foreach ($mps_RET as $sem => $quarters) {
$extra['extra_header_left'] .= '<TR>';
foreach ($quarters as $qtr) {
} else {
if ($attendance_RET[$month][$day]) {
$attendance = $attendance_RET[$month][$day][1];
echo '<TD class="center" style="background-color:#e80000;">' . $attendance['STATE_CODE'] . '</TD>';
} else {
echo '<TD class="center" style="background-color:#FFDDDD;"> </TD>';
}
}
}
echo '<TD style="text-align:right">' . number_format($abs, 1) . '</TD><TD style="text-align:right">' . number_format($tdy, 0) . '</TD><TD style="text-align:right">' . number_format($pos, 1) . '</TD></TR>';
$abs_tot += $abs;
$tdy_tot += $tdy;
$pos_tot += $pos;
}
}
echo '<TR><TD colspan="28"></TD><TD colspan="4" style="text-align:right;"><B>' . Localize('colon', _('YTD Totals')) . '</B></TD>';
echo '<TD style="text-align:right">' . number_format($abs_tot, 1) . '</TD><TD style="text-align:right">' . number_format($tdy_tot, 0) . '</TD><TD style="text-align:right">' . number_format($pos_tot, 1) . '</TD></TR>';
echo '</TABLE></TD></TR>';
echo '</TABLE>';
echo '</TD><TR>';
echo '</TABLE>';
echo '<div style="page-break-after: always;"></div>';
}
PDFStop($handle);
} else {
BackPrompt(_('No Students were found.'));
}
} else {
BackPrompt(_('You must choose at least one student.'));
}
}
