<?php StaffWidgets('fsa_status_active'); StaffWidgets('fsa_barcode'); StaffWidgets('fsa_exists_Y'); Search('staff_id', $extra); if ($_REQUEST['modfunc'] == 'submit') { if ($_REQUEST['submit']['cancel']) { if (DeletePromptX(_('Sale'), _('Cancel'))) { unset($_SESSION['FSA_sale']); } } elseif ($_REQUEST['submit']['save']) { if (count($_SESSION['FSA_sale'])) { $items_RET = DBGet(DBQuery("SELECT DESCRIPTION,SHORT_NAME,PRICE_STAFF FROM FOOD_SERVICE_ITEMS WHERE SCHOOL_ID='" . UserSchool() . "'"), array(), array('SHORT_NAME')); // get next transaction id $id = DBGet(DBQuery('SELECT ' . db_seq_nextval('FOOD_SERVICE_STAFF_TRANSACTIONS_SEQ') . ' AS SEQ_ID ' . FROM_DUAL)); $id = $id[1]['SEQ_ID']; $item_id = 0; foreach ($_SESSION['FSA_sale'] as $item_sn) { $price = $items_RET[$item_sn][1]['PRICE_STAFF']; $fields = 'ITEM_ID,TRANSACTION_ID,AMOUNT,SHORT_NAME,DESCRIPTION'; $values = "'" . $item_id++ . "','" . $id . "','-" . $price . "','" . $items_RET[$item_sn][1]['SHORT_NAME'] . "','" . $items_RET[$item_sn][1]['DESCRIPTION'] . "'"; $sql = "INSERT INTO FOOD_SERVICE_STAFF_TRANSACTION_ITEMS (" . $fields . ") values (" . $values . ")"; DBQuery($sql); } $sql1 = "UPDATE FOOD_SERVICE_STAFF_ACCOUNTS SET TRANSACTION_ID='" . $id . "',BALANCE=BALANCE+(SELECT sum(AMOUNT) FROM FOOD_SERVICE_STAFF_TRANSACTION_ITEMS WHERE TRANSACTION_ID='" . $id . "') WHERE STAFF_ID='" . UserStaffID() . "'"; $fields = 'TRANSACTION_ID,STAFF_ID,SYEAR,SCHOOL_ID,BALANCE,TIMESTAMP,SHORT_NAME,DESCRIPTION,SELLER_ID'; $values = "'" . $id . "','" . UserStaffID() . "','" . UserSyear() . "','" . UserSchool() . "',(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID='" . UserStaffID() . "'),CURRENT_TIMESTAMP,'" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "','" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . ' - ' . DBDate() . "','" . User('STAFF_ID') . "'"; $sql2 = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTIONS (' . $fields . ') values (' . $values . ')'; DBQuery('BEGIN; ' . $sql1 . '; ' . $sql2 . '; COMMIT'); unset($_SESSION['FSA_sale']);
if ($go) { DBQuery($sql); } } } } } unset($_REQUEST['modfunc']); } if ($_REQUEST['modfunc'] == 'remove') { if ($_REQUEST['tab_id'] != 'new') { if (DeletePromptX('Report Card Grade')) { DBQuery("DELETE FROM REPORT_CARD_GRADES WHERE ID='{$_REQUEST['id']}'"); } } else { if (DeletePromptX('Report Card Grading Scale')) { DBQuery("DELETE FROM REPORT_CARD_GRADES WHERE GRADE_SCALE_ID='{$_REQUEST['id']}'"); DBQuery("DELETE FROM REPORT_CARD_GRADE_SCALES WHERE ID='{$_REQUEST['id']}'"); unset($_SESSION['GR_scale_id']); } } } if (!$_REQUEST['modfunc']) { if (User('PROFILE') == 'admin') { $grade_scales_RET = DBGet(DBQuery('SELECT ID,TITLE FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER'), array(), array('ID')); if (!$_REQUEST['tab_id']) { if (!$_SESSION['GR_scale_id']) { if (count($grade_scales_RET)) { $_REQUEST['tab_id'] = $_SESSION['GR_scale_id'] = key($grade_scales_RET); } else { $_REQUEST['tab_id'] = 'new';
<?php require_once 'modules/Grades/DeletePromptX.fnc.php'; DrawHeader(ProgramTitle()); if ($_REQUEST['modfunc'] == 'delete' && AllowEdit()) { //modif Francois: add translation if ($dp = DeletePromptX(_('Final Grade'))) { DBQuery("DELETE FROM STUDENT_REPORT_CARD_GRADES WHERE SYEAR='" . UserSyear() . "' AND STUDENT_ID='" . $_REQUEST['student_id'] . "' AND COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "' AND MARKING_PERIOD_ID='" . $_REQUEST['marking_period_id'] . "'"); DBQuery("DELETE FROM STUDENT_REPORT_CARD_COMMENTS WHERE SYEAR='" . UserSyear() . "' AND STUDENT_ID='" . $_REQUEST['student_id'] . "' AND COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "' AND MARKING_PERIOD_ID='" . $_REQUEST['marking_period_id'] . "'"); $_REQUEST['modfunc'] = 'save'; } elseif ($dp === false) { $_REQUEST['modfunc'] = 'save'; } } if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'save') { if (count($_REQUEST['mp_arr']) && count($_REQUEST['st_arr'])) { $mp_list = '\'' . implode('\',\'', $_REQUEST['mp_arr']) . '\''; $last_mp = end($_REQUEST['mp_arr']); $st_list = '\'' . implode('\',\'', $_REQUEST['st_arr']) . '\''; $extra['WHERE'] = " AND s.STUDENT_ID IN ({$st_list})"; $extra['SELECT'] .= ",rpg.TITLE as GRADE_TITLE,sg1.GRADE_PERCENT,sg1.COMMENT as COMMENT_TITLE,sg1.STUDENT_ID,sg1.COURSE_PERIOD_ID,sg1.MARKING_PERIOD_ID,c.TITLE as COURSE_TITLE,rc_cp.TITLE AS TEACHER,sp.SORT_ORDER"; if ($_REQUEST['elements']['period_absences'] == 'Y') { //modif: SQL error fix: operator does not exist: character varying = integer, add explicit type casts $extra['SELECT'] .= ",rc_cp.DOES_ATTENDANCE,\n\t\t\t\t\t(SELECT count(*) FROM ATTENDANCE_PERIOD ap,ATTENDANCE_CODES ac\n\t\t\t\t\t\tWHERE ac.ID=ap.ATTENDANCE_CODE AND ac.STATE_CODE='A' AND ap.COURSE_PERIOD_ID=sg1.COURSE_PERIOD_ID AND ap.STUDENT_ID=ssm.STUDENT_ID) AS YTD_ABSENCES,\n\t\t\t\t\t(SELECT count(*) FROM ATTENDANCE_PERIOD ap,ATTENDANCE_CODES ac\n\t\t\t\t\t\tWHERE ac.ID=ap.ATTENDANCE_CODE AND ac.STATE_CODE='A' AND ap.COURSE_PERIOD_ID=sg1.COURSE_PERIOD_ID AND cast(sg1.MARKING_PERIOD_ID as integer)=ap.MARKING_PERIOD_ID AND ap.STUDENT_ID=ssm.STUDENT_ID) AS MP_ABSENCES"; } if ($_REQUEST['elements']['comments'] == 'Y') { $extra['SELECT'] .= ',sg1.MARKING_PERIOD_ID AS COMMENTS_RET'; } //modif Francois: multiple school periods for a course period /*$extra['FROM'] .= ",STUDENT_REPORT_CARD_GRADES sg1 LEFT OUTER JOIN REPORT_CARD_GRADES rpg ON (rpg.ID=sg1.REPORT_CARD_GRADE_ID), COURSE_PERIODS rc_cp,COURSES c,SCHOOL_PERIODS sp";*/
//$header = ""; //DrawHeader(($_REQUEST['type']=='staff'?'User ':'******').ProgramTitle(),'<TABLE bgcolor=#ffffff><TR><TD>'.$header.'</TD></TR></TABLE>'); DrawBC("Food Service >> " . ProgramTitle()); if ($_REQUEST['modfunc'] == 'delete') { require_once 'modules/Food_Service/includes/DeletePromptX.fnc.php'; if ($_REQUEST['item_id'] != '') { if (DeletePromptX('transaction item')) { require_once 'modules/Food_Service/includes/DeleteTransactionItem.fnc.php'; DeleteTransactionItem($_REQUEST['transaction_id'], $_REQUEST['item_id'], $_REQUEST['type']); unset($_REQUEST['modfunc']); unset($_REQUEST['delete_ok']); unset($_SESSION['_REQUEST_vars']['modfunc']); unset($_SESSION['_REQUEST_vars']['delete_ok']); } } else { if (DeletePromptX('transaction')) { require_once 'modules/Food_Service/includes/DeleteTransaction.fnc.php'; DeleteTransaction($_REQUEST['transaction_id'], $_REQUEST['type']); unset($_REQUEST['modfunc']); unset($_REQUEST['delete_ok']); unset($_SESSION['_REQUEST_vars']['modfunc']); unset($_SESSION['_REQUEST_vars']['delete_ok']); } } } if (!$_REQUEST['modfunc']) { $types = array('DEPOSIT' => 'Deposit', 'CREDIT' => 'Credit', 'DEBIT' => 'Debit'); $menus_RET = DBGet(DBQuery('SELECT TITLE FROM FOOD_SERVICE_MENUS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER')); $type_select = 'Type<SELECT name=type_select><OPTION value=\'\'>Not Specified</OPTION>'; foreach ($types as $short_name => $type) { $type_select .= '<OPTION value=' . $short_name . ($_REQUEST['type_select'] == $short_name ? ' SELECTED' : '') . '>' . $type . '</OPTION>';
<?php require_once 'modules/Grades/DeletePromptX.fnc.php'; if ($_REQUEST['modfunc'] == 'delete') { if ($dp = DeletePromptX('final grade')) { DBQuery("DELETE FROM STUDENT_REPORT_CARD_GRADES WHERE SYEAR='" . UserSyear() . "' AND STUDENT_ID='" . $_REQUEST['student_id'] . "' AND COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "' AND MARKING_PERIOD_ID='" . $_REQUEST['marking_period_id'] . "'"); DBQuery("DELETE FROM STUDENT_REPORT_CARD_COMMENTS WHERE SYEAR='" . UserSyear() . "' AND STUDENT_ID='" . $_REQUEST['student_id'] . "' AND COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "' AND MARKING_PERIOD_ID='" . $_REQUEST['marking_period_id'] . "'"); $_REQUEST['modfunc'] = 'save'; } elseif ($dp === false) { $_REQUEST['modfunc'] = 'save'; } } if ($_REQUEST['modfunc'] == 'save') { if (count($_REQUEST['mp_arr']) && count($_REQUEST['st_arr'])) { $mp_list = '\'' . implode('\',\'', $_REQUEST['mp_arr']) . '\''; $last_mp = end($_REQUEST['mp_arr']); $st_list = '\'' . implode('\',\'', $_REQUEST['st_arr']) . '\''; $extra['WHERE'] = " AND s.STUDENT_ID IN ({$st_list})"; $extra['SELECT'] .= ",rpg.TITLE as GRADE_TITLE,sg1.GRADE_PERCENT,sg1.COMMENT as COMMENT_TITLE,sg1.STUDENT_ID,sg1.COURSE_PERIOD_ID,sg1.MARKING_PERIOD_ID,c.TITLE as COURSE_TITLE,rc_cp.TITLE AS TEACHER,sp.SORT_ORDER"; if ($_REQUEST['elements']['period_absences'] == 'Y') { $extra['SELECT'] .= ",rc_cp.DOES_ATTENDANCE,\n\t\t\t\t(SELECT count(*) FROM ATTENDANCE_PERIOD ap,ATTENDANCE_CODES ac\n\t\t\t\t\tWHERE ac.ID=ap.ATTENDANCE_CODE AND ac.STATE_CODE='A' AND ap.COURSE_PERIOD_ID=sg1.COURSE_PERIOD_ID AND ap.STUDENT_ID=ssm.STUDENT_ID) AS YTD_ABSENCES,\n\t\t\t\t(SELECT count(*) FROM ATTENDANCE_PERIOD ap,ATTENDANCE_CODES ac\n\t\t\t\t\tWHERE ac.ID=ap.ATTENDANCE_CODE AND ac.STATE_CODE='A' AND ap.COURSE_PERIOD_ID=sg1.COURSE_PERIOD_ID AND sg1.MARKING_PERIOD_ID=ap.MARKING_PERIOD_ID AND ap.STUDENT_ID=ssm.STUDENT_ID) AS MP_ABSENCES"; } if ($_REQUEST['elements']['comments'] == 'Y') { $extra['SELECT'] .= ',sg1.MARKING_PERIOD_ID AS COMMENTS_RET'; } $extra['FROM'] .= ",STUDENT_REPORT_CARD_GRADES sg1 LEFT OUTER JOIN REPORT_CARD_GRADES rpg ON (rpg.ID=sg1.REPORT_CARD_GRADE_ID),\n\t\t\t\t\tCOURSE_PERIODS rc_cp,COURSES c,SCHOOL_PERIODS sp"; $extra['WHERE'] .= " AND sg1.MARKING_PERIOD_ID IN (" . $mp_list . ")\n\t\t\t\t\tAND rc_cp.COURSE_PERIOD_ID=sg1.COURSE_PERIOD_ID AND c.COURSE_ID = rc_cp.COURSE_ID AND sg1.STUDENT_ID=ssm.STUDENT_ID AND sp.PERIOD_ID=rc_cp.PERIOD_ID"; $extra['ORDER'] .= ",sp.SORT_ORDER,c.TITLE"; $extra['functions']['TEACHER'] = '_makeTeacher'; if ($_REQUEST['elements']['comments'] == 'Y') { $extra['functions']['COMMENTS_RET'] = '_makeComments';
} } unset($_REQUEST['modfunc']); } if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') { $has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_REPORT_CARD_COMMENTS WHERE REPORT_CARD_COMMENT_ID='{$_REQUEST['id']}'")); $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED']; if ($has_assigned > 0) { UnableDeletePromptX('Cannot delete because report card comments are associated.'); } else { if ($_REQUEST['tab_id'] != 'new') { if (DeletePromptX('Report Card Comment')) { DBQuery("DELETE FROM REPORT_CARD_COMMENTS WHERE ID='{$_REQUEST['id']}'"); } } else { if (DeletePromptX('Report Card Comment')) { DBQuery("DELETE FROM REPORT_CARD_COMMENTS WHERE ID='{$_REQUEST['id']}'"); } } } } if (!$_REQUEST['modfunc']) { if (User('PROFILE') == 'admin') { $courses_RET = DBGet(DBQuery("SELECT TITLE,COURSE_ID FROM COURSES WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND COURSE_ID IN (SELECT DISTINCT COURSE_ID FROM COURSE_PERIODS WHERE GRADE_SCALE_ID IS NOT NULL) ORDER BY TITLE")); if (!$_REQUEST['course_id']) { $_REQUEST['course_id'] = $courses_RET[1]['COURSE_ID']; } $course_select = '<SELECT name=course_id onchange="document.location.href=\'Modules.php?modname=' . $_REQUEST['modname'] . '&course_id=\'+this.options[selectedIndex].value">'; foreach ($courses_RET as $course) { $course_select .= '<OPTION value=' . $course['COURSE_ID'] . ($_REQUEST['course_id'] == $course['COURSE_ID'] ? ' SELECTED' : '') . '>' . $course['TITLE'] . '</OPTION>'; }
<?php if ($_REQUEST['modfunc'] == 'update') { if (UserStaffID() && AllowEdit()) { if ($_REQUEST['submit']['delete']) { if (DeletePromptX('User Account')) { DBQuery('DELETE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=' . UserStaffID()); } //unset($_REQUEST['submit']); } else { if (count($_REQUEST['food_service'])) { $sql = 'UPDATE FOOD_SERVICE_STAFF_ACCOUNTS SET '; foreach ($_REQUEST['food_service'] as $column_name => $value) { $sql .= $column_name . '=\'' . str_replace("\\'", "''", str_replace("`", "''", trim($value))) . '\','; } $sql = substr($sql, 0, -1) . ' WHERE STAFF_ID=' . $_REQUEST['staff_id']; DBQuery($sql); } unset($_REQUEST['modfunc']); } } else { unset($_REQUEST['modfunc']); } } if ($_REQUEST['modfunc'] == 'create') { if (UserStaffID() && AllowEdit()) { if (count($_REQUEST['food_service'])) { $fields = 'STAFF_ID,BALANCE,TRANSACTION_ID,'; $values = UserStaffID() . ',0.00,0,'; foreach ($_REQUEST['food_service'] as $column_name => $value) { $fields .= $column_name . ',';
if ($column != 'ASSIGNMENT_TYPE_ID' && $column != 'ASSIGNED_DATE' && $column != 'DUE_DATE') { $go = true; } } } $sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')'; if ($go) { DBQuery($sql); } } } } unset($_REQUEST['modfunc']); } if ($_REQUEST['modfunc'] == 'remove') { if (DeletePromptX($_REQUEST['tab_id'] != 'new' ? 'assignment' : 'assignment type')) { if ($_REQUEST['tab_id'] != 'new') { DBQuery("DELETE FROM GRADEBOOK_GRADES WHERE ASSIGNMENT_ID='{$_REQUEST['id']}'"); DBQuery("DELETE FROM GRADEBOOK_ASSIGNMENTS WHERE ASSIGNMENT_ID='{$_REQUEST['id']}'"); } else { $assignments_RET = DBGet(DBQuery("SELECT ASSIGNMENT_ID FROM GRADEBOOK_ASSIGNMENTS WHERE ASSIGNMENT_TYPE_ID='{$_REQUEST['id']}'")); if (count($assignments_RET)) { foreach ($assignments_RET as $assignment_id) { DBQuery("DELETE FROM GRADEBOOK_GRADES WHERE ASSIGNMENT_ID='" . $assignment_id['ASSIGNMENT_ID'] . "'"); } } DBQuery("DELETE FROM GRADEBOOK_ASSIGNMENTS WHERE ASSIGNMENT_TYPE_ID='{$_REQUEST['id']}'"); DBQuery("DELETE FROM GRADEBOOK_ASSIGNMENT_TYPES WHERE ASSIGNMENT_TYPE_ID='{$_REQUEST['id']}'"); } unset($_REQUEST['id']); unset($_REQUEST['modfunc']);
if ($value) { $fields .= $column . ','; $values .= '\'' . str_replace("\\'", "''", $value) . '\','; $go = true; } } $sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')'; if ($go && trim($columns['NAME'])) { DBQuery($sql); } } } unset($_REQUEST['modfunc']); } if ($_REQUEST['modfunc'] == 'remove') { if (DeletePromptX('History Marking Period')) { DBQuery('DELETE FROM history_marking_periods WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['id'] . '\''); } } if (!$_REQUEST['modfunc']) { echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=update&tab_id=" . strip_tags(trim($_REQUEST[tab_id])) . "&mp_id={$mp_id} method=POST>"; DrawHeader('', SubmitButton('Save', '', 'class=btn_medium')); echo '<BR>'; $sql = 'SELECT * FROM history_marking_periods WHERE SCHOOL_ID = ' . UserSchool() . ' ORDER BY POST_END_DATE'; $functions = array('MP_TYPE' => 'makeSelectInput', 'NAME' => 'makeTextInput', 'POST_END_DATE' => 'makeDateInput', 'SYEAR' => 'makeSchoolYearSelectInput'); $LO_columns = array('MP_TYPE' => 'Type', 'NAME' => 'Name', 'POST_END_DATE' => 'Grade Post Date', 'SYEAR' => 'School Year'); $link['add']['html'] = array('MP_TYPE' => makeSelectInput('', 'MP_TYPE'), 'NAME' => makeTextInput('', 'NAME'), 'POST_END_DATE' => makeDateInput('', 'POST_END_DATE'), 'SYEAR' => makeSchoolYearSelectInput('', 'SYEAR')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove"; //&mp_id=$mp_id"; $link['remove']['variables'] = array('id' => 'MARKING_PERIOD_ID'); $link['add']['html']['remove'] = button('add');
if ($go) { DBQuery($sql); } } } } } unset($_REQUEST['modfunc']); } if ($_REQUEST['modfunc'] == 'remove') { if ($_REQUEST['tab_id'] != 'new') { if (DeletePromptX(_('Meal Item'))) { DBQuery("DELETE FROM FOOD_SERVICE_MENU_ITEMS WHERE MENU_ID='{$_REQUEST['tab_id']}' AND MENU_ITEM_ID='{$_REQUEST['menu_item_id']}'"); } } else { if (DeletePromptX(_('Item'))) { DBQuery("DELETE FROM FOOD_SERVICE_MENU_ITEMS WHERE ITEM_ID='{$_REQUEST['item_id']}'"); DBQuery("DELETE FROM FOOD_SERVICE_ITEMS WHERE ITEM_ID='{$_REQUEST['item_id']}'"); } } } if (!$_REQUEST['modfunc']) { $menus_RET = DBGet(DBQuery('SELECT MENU_ID,TITLE FROM FOOD_SERVICE_MENUS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'), array(), array('MENU_ID')); if ($_REQUEST['tab_id']) { if ($_REQUEST['tab_id'] != 'new') { if ($menus_RET[$_REQUEST['tab_id']]) { $_SESSION['FSA_menu_id'] = $_REQUEST['tab_id']; } elseif (count($menus_RET)) { $_REQUEST['tab_id'] = $_SESSION['FSA_menu_id'] = key($menus_RET); } else { $_REQUEST['tab_id'] = 'new';
$fields .= $column . ','; $values .= '\'' . str_replace("\\'", "''", str_replace("'", "\\'", $value)) . '\','; $go = true; } } $sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')'; if ($go) { DBQuery($sql); } } } } unset($_REQUEST['modfunc']); } if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') { if (DeletePromptX('Honor Roll')) { DBQuery("DELETE FROM honor_roll WHERE id='{$_REQUEST['id']}'"); } } if (!$_REQUEST['modfunc']) { $sql = 'SELECT TITLE,VALUE, id as ID FROM honor_roll WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY VALUE'; $functions = array('TITLE' => '_makeTextInput', 'VALUE' => 'makeTextInputt'); $LO_columns = array('TITLE' => 'Honor Roll', 'VALUE' => 'Breakoff'); $link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'VALUE' => makeTextInputt('', 'VALUE')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove"; $link['remove']['variables'] = array('id' => 'ID'); $link['add']['html']['remove'] = button('add'); $LO_ret = DBGet(DBQuery($sql), $functions); $tabs = array(); $tabs[] = array('title' => 'Honor Roll Setup'); echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
<?php StaffWidgets('fsa_barcode'); StaffWidgets('fsa_exists_Y'); Search('staff_id', $extra); if ($_REQUEST['modfunc'] == 'modify') { if (UserStaffID() && AllowEdit()) { if ($_REQUEST['submit']['cancel']) { if (DeletePromptX('Sale', 'Cancel')) { unset($_SESSION['SALE']); } unset($_REQUEST['submit']); } elseif ($_REQUEST['submit']['complete']) { if (count($_SESSION['SALE'])) { // get next transaction id $id = DBGet(DBQuery('SELECT ' . db_seq_nextval('FOOD_SERVICE_STAFF_TRANSACTIONS_SEQ') . ' AS SEQ_ID ' . FROM_DUAL)); $id = $id[1]['SEQ_ID']; foreach ($_SESSION['SALE'] as $key => $item) { $sql = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTION_ITEMS'; $fields = 'ITEM_ID,TRANSACTION_ID,AMOUNT,SHORT_NAME,DESCRIPTION'; $values = $key . ',' . $id . ',-' . $item['PRICE'] . ',\'' . $item['SHORT_NAME'] . '\',\'' . $item['DESCRIPTION'] . '\''; $sql = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTION_ITEMS (' . $fields . ') values (' . $values . ')'; DBQuery($sql); } $sql1 = 'UPDATE FOOD_SERVICE_STAFF_ACCOUNTS SET TRANSACTION_ID=' . $id . ',BALANCE=BALANCE+(SELECT sum(AMOUNT) FROM FOOD_SERVICE_STAFF_TRANSACTION_ITEMS WHERE TRANSACTION_ID=' . $id . ') WHERE STAFF_ID=' . UserStaffID(); $fields = 'TRANSACTION_ID,STAFF_ID,SYEAR,BALANCE,TIMESTAMP,SHORT_NAME,DESCRIPTION,SELLER_ID'; $values = $id . ',' . UserStaffID() . ',' . UserSyear() . ',(SELECT BALANCE FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=' . UserStaffID() . '),CURRENT_TIMESTAMP,\'LUNCH\',\'Lunch\',' . User('STAFF_ID'); $sql2 = 'INSERT INTO FOOD_SERVICE_STAFF_TRANSACTIONS (' . $fields . ') values (' . $values . ')'; DBQuery('BEGIN; ' . $sql1 . '; ' . $sql2 . '; COMMIT'); unset($_SESSION['SALE']); }
WHERE s.marking_period_id=\'' . $stu_val['MARKING_PERIOD_ID'] . '\' AND s.course_period_id IS NULL AND s.gpa_cal=\'Y\' AND s.student_id=\'' . $stu_val['STUDENT_ID'] . '\') gg ON gg.student_id=g.student_id SET g.cum_unweighted_factor=gg.cum_unweighted_factor WHERE g.student_id=\'' . $stu_val['STUDENT_ID'] . '\''); $stu_gpa_cal = DBGet(DBQuery('SELECT COUNT(*) AS COUNT FROM student_gpa_calculated WHERE marking_period_id=\'' . $stu_val['MARKING_PERIOD_ID'] . '\' AND student_id=\'' . $stu_val['STUDENT_ID'] . '\'')); if ($stu_gpa_cal[1]['COUNT'] != 0) { DBQuery('UPDATE student_gpa_calculated SET gpa=\'' . $res[1]['GPA'] . '\', weighted_gpa=\'' . $res[1]['WEIGHTED_GPA'] . '\',unweighted_gpa=\'' . $res[1]['UNWEIGHTED_GPA'] . '\' WHERE marking_period_id=\'' . $stu_val['MARKING_PERIOD_ID'] . '\' AND student_id=\'' . $stu_val['STUDENT_ID'] . '\''); } else { DBQuery('INSERT INTO student_gpa_calculated(student_id,marking_period_id,mp,gpa,weighted_gpa,unweighted_gpa,grade_level_short) VALUES(\'' . $stu_val['STUDENT_ID'] . '\',\'' . $stu_val['MARKING_PERIOD_ID'] . '\',\'' . $stu_val['MARKING_PERIOD_ID'] . '\',\'' . $res[1]['GPA'] . '\',\'' . $res[1]['WEIGHTED_GPA'] . '\', \'' . $res[1]['unweighted_gpa'] . '\',\'' . $res[1]['GRADE_LEVEL_SHORT'] . '\')'); } unset($stu_val); } if ($_REQUEST['modfunc'] == 'remove') { if (DeletePromptX('Student Grade')) { DBQuery('DELETE FROM student_report_card_grades WHERE ID=\'' . $_REQUEST['id'] . '\''); } } if (!$_REQUEST['modfunc']) { $stuRET = DBGet(DBQuery('SELECT LAST_NAME, FIRST_NAME, MIDDLE_NAME, NAME_SUFFIX from students where STUDENT_ID = ' . $student_id . '')); $stuRET = $stuRET[1]; $displayname = $stuRET['LAST_NAME'] . ($stuRET['NAME_SUFFIX'] ? $stuRET['suffix'] . ' ' : '') . ', ' . $stuRET['FIRST_NAME'] . ' ' . $stuRET['MIDDLE_NAME']; $gquery = 'SELECT mp.syear, mp.marking_period_id as mp_id, mp.title as mp_name, mp.post_end_date as posted, sgc.grade_level_short as GRADE_LEVEL, sgc.weighted_gpa, sgc.unweighted_gpa FROM marking_periods mp, student_gpa_calculated sgc, schools s WHERE sgc.marking_period_id = mp.marking_period_id and s.id = mp.school_id and sgc.student_id = ' . $student_id . ' AND mp.marking_period_id IN (SELECT marking_period_id FROM history_marking_periods) AND mp.school_id = \'' . UserSchool() . '\' order by mp.post_end_date'; $GRET = DBGet(DBQuery($gquery)); $last_posted = null;
$sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')'; if ($go) { DBQuery($sql); } } } } unset($_REQUEST['modfunc']); } if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') { $has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_standards WHERE grade_id={$_REQUEST['id']}")); $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED']; if ($has_assigned > 0) { UnableDeletePromptX('Cannot delete because standard grade is associated.'); } else { if (DeletePromptX('Standard Grade')) { DBQuery("DELETE FROM standard_grades WHERE ID='{$_REQUEST['id']}'"); unset($_SESSION['GR_scale_id']); } } } if (!$_REQUEST['modfunc']) { $sql = "SELECT ID,GRADE,DESCRIPTION,SORT_ORDER FROM standard_grades WHERE school_id='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY sort_order,grade"; $functions = array('GRADE' => '_makeTextInput', 'DESCRIPTION' => '_makeTextInput', 'SORT_ORDER' => '_makeIntInput'); $LO_columns = array('GRADE' => 'Grade', 'DESCRIPTION' => 'Description', 'SORT_ORDER' => 'Order'); $link['add']['html'] = array('GRADE' => _makeTextInput('', 'GRADE'), 'DESCRIPTION' => _makeTextInput('', 'DESCRIPTION'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove"; $link['remove']['variables'] = array('id' => 'ID'); $link['add']['html']['remove'] = button('add'); $LO_ret = DBGet(DBQuery($sql), $functions); echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
DBQuery($sql); } } } } } unset($_REQUEST['modfunc']); } if ($_REQUEST['modfunc'] == 'remove') { if ($_REQUEST['tab_id'] != 'new') { if (DeletePromptX('Category')) { DBQuery("UPDATE FOOD_SERVICE_MENU_ITEMS SET CATEGORY_ID=NULL WHERE CATEGORY_ID='{$_REQUEST['category_id']}'"); DBQuery("DELETE FROM FOOD_SERVICE_CATEGORIES WHERE CATEGORY_ID='{$_REQUEST['category_id']}'"); } } else { if (DeletePromptX('Meal')) { DBQuery("DELETE FROM FOOD_SERVICE_MENU_ITEMS WHERE MENU_ID='{$_REQUEST['menu_id']}'"); DBQuery("DELETE FROM FOOD_SERVICE_CATEGORIES WHERE MENU_ID='{$_REQUEST['menu_id']}'"); DBQuery("DELETE FROM FOOD_SERVICE_MENUS WHERE MENU_ID='{$_REQUEST['menu_id']}'"); } } } if (!$_REQUEST['modfunc']) { $menus_RET = DBGet(DBQuery('SELECT MENU_ID,TITLE FROM FOOD_SERVICE_MENUS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'), array(), array('MENU_ID')); if ($_REQUEST['tab_id']) { if ($_REQUEST['tab_id'] != 'new') { if ($menus_RET[$_REQUEST['tab_id']]) { $_SESSION['FSA_menu_id'] = $_REQUEST['tab_id']; } elseif (count($menus_RET)) { $_REQUEST['tab_id'] = $_SESSION['FSA_menu_id'] = key($menus_RET); } else {
} else { $tabcolor_s = Preferences('HEADER'); $textcolor_s = '#FFFFFF'; $tabcolor_u = '#DFDFDF'; $textcolor_u = '#999999'; }*/ $header = '<TABLE class="cellpadding-0 cellspacing-0" style="height:14px;"><TR>'; //modif Francois: remove DrawTab params $header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Students'), "Modules.php?modname={$_REQUEST['modname']}&type=student") . '</TD>'; $header .= '<TD style="width:10px;"></TD><TD>' . DrawTab(_('Users'), "Modules.php?modname={$_REQUEST['modname']}&type=staff") . '</TD>'; $header .= '<TD style="width:10px;"></TD></TR></TABLE>'; DrawHeader(($_REQUEST['type'] == 'staff' ? _('User') : _('Student')) . ' − ' . ProgramTitle(), User('PROFILE') == 'student' ? '' : '<TABLE style="background-color:#ffffff;"><TR><TD>' . $header . '</TD></TR></TABLE>'); if ($_REQUEST['modfunc'] == 'delete' && AllowEdit()) { require_once 'modules/Food_Service/includes/DeletePromptX.fnc.php'; //modif Francois: add translation if (DeletePromptX(_('Transaction'))) { require_once 'modules/Food_Service/includes/DeleteTransaction.fnc.php'; DeleteTransaction($_REQUEST['id'], $_REQUEST['type']); unset($_REQUEST['modfunc']); unset($_REQUEST['delete_ok']); unset($_SESSION['_REQUEST_vars']['modfunc']); unset($_SESSION['_REQUEST_vars']['delete_ok']); } } if (empty($_REQUEST['modfunc'])) { include 'modules/Food_Service/' . ($_REQUEST['type'] == 'staff' ? 'Users' : 'Students') . '/Transactions.php'; } function red($value) { if ($value < 0) { return '<span style="color:red">' . $value . '</span>';