if ($_REQUEST['modfunc'] == 'save') {
if (count($_REQUEST['st_arr'])) {
$st_list = "'" . implode("','", $_REQUEST['st_arr']) . "'";
$school = DBGet(DBQuery("SELECT TITLE FROM SCHOOLS WHERE ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
$school = $school[1]['TITLE'];
$staffs = DBGet(DBQuery("SELECT s.STAFF_ID,s.FIRST_NAME,s.LAST_NAME,s.MIDDLE_NAME,s.PROFILE,fsa.STATUS,fsa.BALANCE FROM STAFF s,FOOD_SERVICE_STAFF_ACCOUNTS fsa WHERE s.STAFF_ID IN (" . $st_list . ") AND fsa.STAFF_ID=s.STAFF_ID"));
$handle = PDFStart();
foreach ($staffs as $staff) {
$last_deposit = DBGet(DBQuery("SELECT (SELECT sum(AMOUNT) FROM FOOD_SERVICE_STAFF_TRANSACTION_ITEMS WHERE TRANSACTION_ID=fst.TRANSACTION_ID) AS AMOUNT,to_char(fst.TIMESTAMP,'YYYY-MM-DD') AS DATE FROM FOOD_SERVICE_STAFF_TRANSACTIONS fst WHERE fst.SHORT_NAME='DEPOSIT' AND fst.STAFF_ID='" . $staff['STAFF_ID'] . "' AND SYEAR='" . UserSyear() . "' ORDER BY fst.TRANSACTION_ID DESC LIMIT 1"), array('DATE' => 'ProperDate'));
$last_deposit = $last_deposit[1];
if ($staff['BALANCE'] < $minimum) {
reminder($staff, $school, $target, $last_deposit, $minimum_note);
} elseif ($staff['BALANCE'] < 0) {
reminder($staff, $school, $target, $last_deposit, $negative_note);
} elseif ($staff['BALANCE'] < $warning) {
reminder($staff, $school, $target, $last_deposit, $warning_note);
}
echo '<!-- NEED 3in -->';
}
PDFStop($handle);
} else {
BackPrompt(_('You must choose at least one user'));
}
}
if (!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == 'list') {
if ($_REQUEST['search_modfunc'] == 'list') {
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=save&_CENTRE_PDF=true method=POST>";
DrawHeader('', SubmitButton(_('Create Reminders for Selected Users')));
}
$extra['link'] = array('FULL_NAME' => false);
$extra['SELECT'] = ",s.STAFF_ID AS CHECKBOX";
foaf_password($config, $realm, $_GET['redirect']);
} else {
main();
}
}
}
} else {
switch ($action) {
case "FOAFpassword":
foaf_password($config, $realm, $authreqissuer);
break;
case "login":
login($authreqissuer);
break;
case "reminder":
reminder($config, $realm);
break;
case "forgotten":
forgotten();
break;
case "authn":
login($authreqissuer);
break;
default:
if (isset($_GET['webid']) && $_SERVER['HTTPS'] == 'on') {
naming_authority($config, $_GET['webid']);
} else {
if (isset($_POST['password'])) {
foaf_password($config, $realm, $_GET['redirect']);
} else {
main();
$teacher = $teacher[1];
//modif Francois: sql fix
$xstudents = DBGet(DBQuery("SELECT s.STUDENT_ID,s.FIRST_NAME,s.LAST_NAME,'' AS NICKNAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE fssa.ACCOUNT_ID='" . $student['ACCOUNT_ID'] . "' AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!='" . $student['STUDENT_ID'] . "' AND exists(SELECT '' FROM STUDENT_ENROLLMENT WHERE STUDENT_ID=s.STUDENT_ID AND SYEAR='" . UserSyear() . "' AND (START_DATE<=CURRENT_DATE AND (END_DATE IS NULL OR CURRENT_DATE<=END_DATE)))"));
$last_deposit = DBGet(DBQuery("SELECT (SELECT sum(AMOUNT) FROM FOOD_SERVICE_TRANSACTION_ITEMS WHERE TRANSACTION_ID=fst.TRANSACTION_ID) AS AMOUNT,to_char(fst.TIMESTAMP,'YYYY-MM-DD') AS DATE FROM FOOD_SERVICE_TRANSACTIONS fst WHERE fst.SHORT_NAME='DEPOSIT' AND fst.ACCOUNT_ID='" . $student['ACCOUNT_ID'] . "' AND SYEAR='" . UserSyear() . "' ORDER BY fst.TRANSACTION_ID DESC LIMIT 1"), array('DATE' => 'ProperDate'));
$last_deposit = $last_deposit[1];
if ($_REQUEST['year_end'] == 'Y') {
$xtarget = number_format($student['DAYS'] * $student['T_AMOUNT'] / $student['T_DAYS'], 2);
reminder($student, $teacher, $xstudents, $xtarget, $last_deposit, $year_end_note);
} else {
$xtarget = number_format($target * (count($xstudents) + 1), 2);
if ($student['BALANCE'] < $minimum) {
reminder($student, $teacher, $xstudents, $xtarget, $last_deposit, $minimum_note);
} elseif ($student['BALANCE'] < 0) {
reminder($student, $teacher, $xstudents, $xtarget, $last_deposit, $negative_note);
} elseif ($student['BALANCE'] < $warning) {
reminder($student, $teacher, $xstudents, $xtarget, $last_deposit, $warning_note);
}
}
echo '<!-- NEED 3in -->';
}
PDFStop($handle);
} else {
BackPrompt(_('You must choose at least one student.'));
}
}
if (empty($_REQUEST['modfunc'])) {
if ($_REQUEST['search_modfunc'] == 'list') {
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=save&_ROSARIO_PDF=true" method="POST">';
//DrawHeader('',SubmitButton('Create Reminders for Selected Students'));
//modif Francois: add translation
$extra['header_right'] = SubmitButton(_('Create Reminders for Selected Students'));
