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'));