468 lines
32 KiB
PHP
468 lines
32 KiB
PHP
<?php
|
|
$AllowedUserTypes = array('SuperUser','System Administrator','Application Administrator','Application Volunteer','Schedule Volunteer','Administration Team','Schedule Team','Supplier','Financial Team');
|
|
if (checkPermission($AllowedUserTypes) != 1) return;
|
|
|
|
|
|
if (!isset($schedule_num)) return;
|
|
if (!isset($hotlunch_schedule)) $hotlunch_schedule = db_getVal("SELECT * FROM hotlunch_schedules WHERE school_num = $school_num AND record_num = $schedule_num");
|
|
|
|
$printButtons = 'Included';
|
|
|
|
$numSuppliers = db_getVal("SELECT count(*) FROM suppliers WHERE school_num = $supplier_school_num AND status = 'Active'");
|
|
$numOrders = db_getVal("SELECT count(*) FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_type != 'Concession'");
|
|
$numMenus = db_getVal("SELECT count(*) FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num");
|
|
|
|
$numItems = 0;
|
|
$sDate = '';
|
|
$eDate = '';
|
|
|
|
if ($numMenus > 0) {
|
|
$query = "SELECT count(*) FROM hotlunch_menu_items " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND menu_num IN (SELECT record_num FROM hotlunch_menu_dates " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND schedule_num = $schedule_num)";
|
|
$numItems = db_getVal($query);
|
|
|
|
$sDate = db_getVal("SELECT min(menu_date) FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num");
|
|
$eDate = db_getVal("SELECT max(menu_date) FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num");
|
|
}
|
|
|
|
?>
|
|
<?php if ($school_record['navigation_mode'] == 'Select') { ?>
|
|
<br>
|
|
<center>
|
|
<table width='90%' cellpadding='1' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='left'>
|
|
<select name='selected_additional_action' id='selected_additional_action' class='navigation-select select-width200'>
|
|
<option value=''><?php displayLanguageText('TEXT-ADDITIONAL-ACTIONS'); ?></option>
|
|
<option value='?action=multi-menu-delivery&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MULTI-MENU-DELIVERY-REPORT'); ?></option>
|
|
<option value='?action=multi-item-delivery&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MULTI-ITEM-DELIVERY-REPORT'); ?></option>
|
|
<option value='?action=multi-menu-csv-form&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MULTIPLE-MENU-SPREADSHEET'); ?></option>
|
|
<option value='?action=schedule-receipts&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-RECEIPTS'); ?></option>
|
|
<option value='?action=hotlunch-tickets&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-TICKETS'); ?></option>
|
|
<option value='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDERS-SUMMARY'); ?></option>
|
|
<option value='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Paid'><?php displayLanguageText('TEXT-ORDERS-PAID'); ?></option>
|
|
<option value='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Unpaid'><?php displayLanguageText('TEXT-ORDERS-UNPAID'); ?></option>
|
|
<option value='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Inactive'><?php displayLanguageText('TEXT-ORDERS-INACTIVE'); ?></option>
|
|
<option value='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Complimentary'><?php displayLanguageText('TEXT-ORDERS-COMPLIMENTARY'); ?></option>
|
|
<option value='?action=orders-list-all-csv&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ALL-ORDERS-CSV'); ?></option>
|
|
<option value='?action=orders-list-all-csv&schedule_num=<?php echo($schedule_num) ?>&sortby=Class'><?php displayLanguageText('TEXT-ORDERS-BY-CLASS-CSV'); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ALL-ORDERS'); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=student&schedule_num=<?php echo($schedule_num) ?>'><?php echo($GlobalText['OrdersByStudent']); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=student-class&schedule_num=<?php echo($schedule_num) ?>'><?php echo($GlobalText['OrdersByClass']); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=account&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDERS-BY-USER-ACCOUNT'); ?></option>
|
|
<option value='?action=menu-order-check&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MENU-ORDERS'); ?></option>
|
|
<option value='?action=menu-order-check&schedule_num=<?php echo($schedule_num) ?>&mode=class'><?php displayLanguageText('TEXT-MENUI-ORDERS-BY-CLASS'); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=date&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDERS-BY-DATE'); ?></option>
|
|
<?php if ($hotlunch_schedule['schedule_type'] != 'Hot Lunch' && in_array($siteType,array('hotlunch','yearbook','tickets','fundraising'))) { ?>
|
|
<option value='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>&delivered=Y'><?php displayLanguageText('TEXT-DELIVERED'); ?></option>
|
|
<option value='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>&delivered=N'><?php displayLanguageText('TEXT-NOT-DELIVERED'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=orders-print-list-special&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SPECIAL-PRICE-ORDERS'); ?></option>
|
|
<option value='?action=sales-summary-csv&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SALES-SUMMARY'); ?></option>
|
|
<option value='?action=order-notes&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-NOTES-REPORT'); ?></option>
|
|
<option value='?action=orders-list-notes-csv&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-NOTES-CSV'); ?></option>
|
|
<option value='?action=menu-price-update&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-UPDATE-ALL-MENU-PRICES'); ?></option>
|
|
<?php if ($_SESSION['UserInfo']['type'] != 'FinancialTeam') { ?>
|
|
<?php if ($school_record['special_item_prices'] == 'Y') { ?>
|
|
<option value='?action=menu-price-update-special&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-UPDATE-SPECIAL-MENU-PRICES'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=menu-item-update&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MENU-DESCRIPTION-UPDATE'); ?></option>
|
|
<?php if ($numSuppliers > 0 && 1 == 2) { ?>
|
|
<option value='?action=menu-product-update&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-UPDATE-MENU-PRODUCTS'); ?></option>
|
|
<?php } ?>
|
|
<?php if (1 == 2) { ?>
|
|
<option value='?action=schedule-discounts&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-DISCOUNTS'); ?></option>
|
|
<?php } ?>
|
|
<?php if (in_array($_SESSION['UserInfo']['type'],array('SuperUser','System Administrator','Application Administrator'))) { ?>
|
|
<option value='?action=schedule-order-deletion&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-DELETE-ALL-ORDERS'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=order-recovery&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-RECOVERY'); ?></option>
|
|
<option value='?action=order-recalc&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-UPDATE'); ?></option>
|
|
<option value='?action=order-verify&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-ORDER-CHECK'); ?></option>
|
|
<option value='#' id='multi-order-discounts-button' schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MULTI-ORDER-DISCOUNTS'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=menu-details-print&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MENU-DETAILS-REPORT'); ?></option>
|
|
<?php if ($numSuppliers > 0) { ?>
|
|
<option value='?action=menu-details-print&mode=products&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-MENU-PRODUCTS-REPORT'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=volunteer-print&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-PRINT-VOLUNTEER-LIST'); ?></option>
|
|
<option value='?action=orders-print-form&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-PAPER-ORDER-FORM'); ?></option>
|
|
<?php if ($_SESSION['UserInfo']['type'] != 'FinancialTeam') { ?>
|
|
<?php if ($numSuppliers > 0) { ?>
|
|
<option value='?action=schedule-products-csv&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-PRODUCTS-SPREADSHEET'); ?></option>
|
|
<option value='?action=schedule-supplier-orders&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-SUPPLIER-ORDERS'); ?></option>
|
|
<?php } ?>
|
|
<option value='?action=schedule-totals-csv&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-TOTALS-SPREADSHEET'); ?></option>
|
|
<option value='?action=schedule-print-totals&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-SUMMARY'); ?></option>
|
|
<?php if (in_array($school_record['reseller'], array('esns','backpac'))) { ?>
|
|
<option value='?action=schedule-print-margins&schedule_num=<?php echo($schedule_num) ?>'><?php displayLanguageText('TEXT-SCHEDULE-MARGINS'); ?></option>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</select>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</center>
|
|
<br>
|
|
<?php } else { ?>
|
|
|
|
<br>
|
|
<?php if ($numOrders > 0) { ?>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=multi-menu-delivery&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MULTI-MENU-DELIVERY-REPORT'); ?></span></a></td>
|
|
<td align='center'><a href='?action=multi-item-delivery&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MULTI-ITEM-DELIVERY-REPORT'); ?></span></a></td>
|
|
<td align='center'><a href='?action=multi-menu-csv-form&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MULTIPLE-MENU-SPREADSHEET'); ?></span></a></td>
|
|
<td align='center'><a href='?action=schedule-receipts&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-RECEIPTS'); ?></span></a></td>
|
|
<td align='center'><a href='?action=hotlunch-tickets&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-TICKETS'); ?></span></a></td>
|
|
</tr>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-SUMMARY'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Paid' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-PAID'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Unpaid' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-UNPAID'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Inactive' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-INACTIVE'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list&schedule_num=<?php echo($schedule_num) ?>&show_status=Complimentary' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-COMPLIMENTARY'); ?></span></a></td>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<td align='center'><a href='?action=orders-list-all-csv&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ALL-ORDERS-CSV'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-list-all-csv&schedule_num=<?php echo($schedule_num) ?>&sortby=Class' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-BY-CLASS-CSV'); ?></span></a></td>
|
|
<td align='center'><a href='#' id='schedule-details-csv-btn' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-DETAILS-CSV'); ?></span></a></td>
|
|
<td align='center'><a href='#' id='ordered-items-csv-btn' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERED-ITEMS-CSV'); ?></span></a></td>
|
|
</tr>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ALL-ORDERS'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=student&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php echo($GlobalText['OrdersByStudent']); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=student-class&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php echo($GlobalText['OrdersByClass']); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=account&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-BY-USER-ACCOUNT'); ?></span></a></td>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<td align='center'><a href='?action=menu-order-check&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MENU-ORDERS'); ?></span></a></td>
|
|
<td align='center'><a href='?action=menu-order-check&schedule_num=<?php echo($schedule_num) ?>&mode=class' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MENUI-ORDERS-BY-CLASS'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=date&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDERS-BY-DATE'); ?></span></a></td>
|
|
<?php if ($hotlunch_schedule['schedule_type'] != 'Hot Lunch' && in_array($siteType,array('hotlunch','yearbook','tickets','fundraising'))) { ?>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>&delivered=Y' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-DELIVERED'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-list-all&sortby=student&show=All&schedule_num=<?php echo($schedule_num) ?>&delivered=N' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-NOT-DELIVERED'); ?></span></a></td>
|
|
<?php } ?>
|
|
<td align='center'><a href='?action=orders-print-list-special&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SPECIAL-PRICE-ORDERS'); ?></span></a></td>
|
|
<td align='center'><a href='?action=sales-summary-csv&schedule_num=<?php echo($schedule_num) ?>' id='sales-summary-csv' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SALES-SUMMARY'); ?></span></a></td>
|
|
<?php if ($school_record['implement_multiple_item_prices'] == 'Y') { ?>
|
|
<td align='center'><a id='pwycBtn' snum='<?php echo($schedule_num) ?>' href='?action=pwyc-details-csv&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-PAY-WHAT-YOU-CAN-CSV'); ?></span></a></td>
|
|
<?php } ?>
|
|
</tr>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=order-notes&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-NOTES-REPORT'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-list-notes-csv&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-NOTES-CSV'); ?></span></a></td>
|
|
</tr>
|
|
</table>
|
|
<?php } ?>
|
|
<?php if ((!isset($numItems) || $numItems > 0) && $_SESSION['UserInfo']['type'] != 'FinancialTeam') { ?>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=menu-price-update&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-UPDATE-ALL-MENU-PRICES'); ?></span></a></td>
|
|
<?php if (in_array($_SESSION['UserInfo']['type'],array('SuperUser'))) { ?>
|
|
<td align='center'><span id='clear-all-menu-item-active-dates' schedule_num='<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-CLEAR-ACTIVE-UNTIL-DATES'); ?></span></td>
|
|
<?php } ?>
|
|
<?php if ($school_record['special_item_prices'] == 'Y') { ?>
|
|
<td align='center'><a href='?action=menu-price-update-special&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-UPDATE-SPECIAL-MENU-PRICES'); ?></span></a></td>
|
|
<?php } ?>
|
|
<td align='center'><a href='?action=menu-item-update&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MENU-DESCRIPTION-UPDATE'); ?></span></a></td>
|
|
<?php if ($numSuppliers > 0 && 1 == 2) { ?>
|
|
<td align='center'><a href='?action=menu-product-update&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-UPDATE-MENU-PRODUCTS'); ?></span></a></td>
|
|
<?php } ?>
|
|
<?php if (1 == 2) { ?>
|
|
<td align='center'><a href='?action=schedule-discounts&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-DISCOUNTS'); ?></span></a></td>
|
|
<?php } ?>
|
|
<?php if (in_array($_SESSION['UserInfo']['type'],array('SuperUser','System Administrator','Application Administrator'))) { ?>
|
|
<?php if ($numOrders > 0) { ?>
|
|
<td align='center'><a href='?action=schedule-order-deletion&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-DELETE-ALL-ORDERS'); ?></span></a></td>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</tr>
|
|
</table>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=order-recovery&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-RECOVERY'); ?></span></a></td>
|
|
<td align='center'><a href='?action=order-recalc&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-UPDATE'); ?></span></a></td>
|
|
<td align='center'><a href='?action=order-verify&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-ORDER-CHECK'); ?></span></a></td>
|
|
<td align='center'><a href='#' id='multi-order-discounts-button' schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MULTI-ORDER-DISCOUNTS'); ?></span></a></td>
|
|
</tr>
|
|
</table>
|
|
<?php } ?>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<td align='center'><a href='?action=menu-details-print&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MENU-DETAILS-REPORT'); ?></span></a></td>
|
|
<?php if ($numSuppliers > 0) { ?>
|
|
<td align='center'><a href='?action=menu-details-print&mode=products&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-MENU-PRODUCTS-REPORT'); ?></span></a></td>
|
|
<?php } ?>
|
|
<td align='center'><a href='?action=volunteer-print&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-PRINT-VOLUNTEER-LIST'); ?></span></a></td>
|
|
<td align='center'><a href='?action=orders-print-form&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-PAPER-ORDER-FORM'); ?></span></a></td>
|
|
</tr>
|
|
</table>
|
|
<?php if ($_SESSION['UserInfo']['type'] != 'FinancialTeam') { ?>
|
|
<table cellpadding='3' cellspacing='1' border='0'>
|
|
<tr>
|
|
<?php if ($numSuppliers > 0) { ?>
|
|
<td align='center'><a href='?action=schedule-products-csv&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-PRODUCTS-SPREADSHEET'); ?></span></a></td>
|
|
<td align='center'><a href='?action=schedule-supplier-orders&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-SUPPLIER-ORDERS'); ?></span></a></td>
|
|
<?php } ?>
|
|
<?php if ($numOrders > 0) { ?>
|
|
<td align='center'><a href='?action=schedule-totals-csv&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-TOTALS-SPREADSHEET'); ?></span></a></td>
|
|
<td align='center'><a href='?action=schedule-print-totals&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-SUMMARY'); ?></span></a></td>
|
|
<?php if (in_array($school_record['reseller'], array('esns','backpac'))) { ?>
|
|
<td align='center'><a href='?action=schedule-print-margins&schedule_num=<?php echo($schedule_num) ?>' class='btn btn--outline btn--xsmall'><span><?php displayLanguageText('TEXT-SCHEDULE-MARGINS'); ?></span></a></td>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</tr>
|
|
</table>
|
|
<?php } ?>
|
|
<br>
|
|
<?php } ?>
|
|
|
|
<script>
|
|
$(document).ready(function() {
|
|
|
|
<?php include "include/ajax.Setup.php"; ?>
|
|
|
|
$("#schedule-details-dialog").dialog({
|
|
autoOpen: false,
|
|
minWidth: 200,
|
|
minHeight: 200,
|
|
modal: true,
|
|
position: { my: 'center', at: 'center' }
|
|
});
|
|
|
|
$("#ordered-items-dialog").dialog({
|
|
autoOpen: false,
|
|
minWidth: 300,
|
|
minHeight: 300,
|
|
modal: true,
|
|
position: { my: 'center', at: 'center' }
|
|
});
|
|
|
|
$("#pwyc-dialog").dialog({
|
|
autoOpen: false,
|
|
minWidth: 200,
|
|
minHeight: 200,
|
|
modal: true,
|
|
position: { my: 'center', at: 'center' }
|
|
});
|
|
|
|
$("#sales-summary-csv-dialog").dialog({
|
|
autoOpen: false,
|
|
minWidth: 300,
|
|
minHeight: 300,
|
|
modal: true,
|
|
position: { my: 'center', at: 'center' }
|
|
});
|
|
|
|
$("#schedule-details-csv-btn").click(function(e) {
|
|
e.preventDefault();
|
|
|
|
$("#schedule-details-dialog").dialog('open');
|
|
});
|
|
|
|
$("#schedule-details-by-menu-item").click(function() {
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var menu_num = 0;
|
|
|
|
$("#schedule-details-dialog").dialog('close');
|
|
location.href = '?action=menu-details&next_form_action=menu-items-details-csv&schedule_num='+schedule_num+'&menu_num='+menu_num;
|
|
});
|
|
|
|
$("#schedule-price-variations").click(function() {
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var menu_num = 0;
|
|
|
|
$("#schedule-details-dialog").dialog('close');
|
|
location.href = '?action=menu-details&next_form_action=menu-items-details-csv&mode=Variations&schedule_num='+schedule_num+'&menu_num='+menu_num;
|
|
});
|
|
|
|
$("#pwycBtn").click(function(e) {
|
|
$("#pwyc-dialog").dialog('open');
|
|
return(false);
|
|
});
|
|
|
|
$("#pwycGenerateBtn").click(function(e) {
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var include_special = $("#include_special_prices").val();
|
|
var items = $("#alternate_price_items_only").val();
|
|
|
|
$("#pwyc-dialog").dialog('close');
|
|
location.href = '?action=pwyc-details-csv&schedule_num='+schedule_num+'&alternate_price_items_only='+items+'&include_special_prices='+include_special;
|
|
});
|
|
|
|
$("#ordered-items-csv-btn").click(function(e) {
|
|
e.preventDefault();
|
|
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
$("#ordered-items-dialog").dialog('open');
|
|
});
|
|
|
|
$("#ordered-items-GenerateBtn").click(function(e) {
|
|
e.preventDefault();
|
|
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var selected_menus = $("#selected_menus").val();
|
|
|
|
if (selected_menus.length == 0) {
|
|
alert("<?php displayLanguageText('ERRORMSG-NO-MENU-DATES-SELECTED'); ?>");
|
|
return;
|
|
}
|
|
|
|
$("#ordered-items-dialog").dialog('close');
|
|
$("#selected_menus").val(0);
|
|
location.href = '?action=ordered-item-summary-csv-generate&schedule_num=<?php echo($schedule_num) ?>&selected_menus='+selected_menus;
|
|
});
|
|
|
|
$("#ordered-items-dialog-close").click(function(e) {
|
|
e.preventDefault();
|
|
$("#ordered-items-dialog").dialog('close');
|
|
});
|
|
|
|
$("#sales-summary-csv").click(function(e) {
|
|
e.preventDefault();
|
|
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var sdate = "<?php echo($sDate) ?>";
|
|
var edate = "<?php echo($eDate) ?>";
|
|
|
|
<?php if ($numMenus == 0) { ?>
|
|
alert("<?php displayLanguageText('ERRORMSG-NO-MENU-DATES'); ?>");
|
|
return;
|
|
|
|
<?php } ?>
|
|
$("#report_start_date").val(sdate);
|
|
$("#report_end_date").val(edate);
|
|
$("#report_include_items").val('Flagged');
|
|
$("#sales-summary-csv-dialog").dialog('open');
|
|
});
|
|
|
|
$("#salesSummaryGenerateBtn").click(function() {
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var form_data = $("#sales-summary-csv-form").serialize();
|
|
|
|
$("#sales-summary-csv-dialog").dialog('close');
|
|
location.href = 'hotlunch.sales-summary.csv.php?schedule_num='+schedule_num+'&'+form_data;
|
|
});
|
|
|
|
$("#salesSummaryGeneratePDFBtn").click(function() {
|
|
var schedule_num = <?php echo($schedule_num) ?>;
|
|
var form_data = $("#sales-summary-csv-form").serialize();
|
|
|
|
$("#sales-summary-csv-dialog").dialog('close');
|
|
location.href = 'hotlunch.sales-summary.pdf.php?schedule_num='+schedule_num+'&'+form_data;
|
|
});
|
|
|
|
$("#salesSummaryCloseBtn").click(function() {
|
|
$("#sales-summary-csv-dialog").dialog('close');
|
|
});
|
|
|
|
});
|
|
</script>
|
|
|
|
<div id='schedule-details-dialog' title="<?php displayLanguageText('TEXT-DETAILS-SPREADSHEET'); ?>">
|
|
<center>
|
|
<p><button id='schedule-details-by-menu-item' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-DETAILS-BY-MENU-ITEM-PRICE'); ?></button></p>
|
|
<?php if ($school_record['implement_multiple_item_prices'] == 'Y' || $school_record['special_item_prices'] == 'Y') { ?>
|
|
<p><button id='schedule-price-variations' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-PRICE-VARIATION-CSV'); ?></button></p>
|
|
<?php } ?>
|
|
</center>
|
|
</div>
|
|
|
|
<div id='pwyc-dialog' title="<?php displayLanguageText('TEXT-PAY-WHAT-YOU-CAN-CSV'); ?>">
|
|
<center>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<p><b><?php displayLanguageText('TEXT-INCLUDE-SPECIAL-PRICES'); ?>:</b><br>
|
|
<select name='include_special_prices' id='include_special_prices'>
|
|
<?php BuildFileList("yn.txt",'N') ?>
|
|
</select></p>
|
|
<p><b><?php displayLanguageText('TEXT-INCLUDE-ALL-MENU-ITEMS'); ?>:</b><br>
|
|
<select name='alternate_price_items_only' id='alternate_price_items_only'>
|
|
<?php BuildFileList("include_menu_items.txt",'Alternate') ?>
|
|
</select></p>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p><button id='pwycGenerateBtn' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-GENERATE-CSV'); ?></button></p>
|
|
</center>
|
|
</div>
|
|
|
|
<div id='ordered-items-dialog' title="<?php displayLanguageText('TEXT-ORDERED-ITEMS-CSV'); ?>">
|
|
<center>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<?php
|
|
$query = "SELECT * FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num ORDER BY sequence";
|
|
$results = db_query($query);
|
|
$numMenus = db_num_rows($results);
|
|
if ($numMenus > 10) $numMenus = 10;
|
|
?>
|
|
<p><b><?php displayLanguageText('TEXT-SELECTED-MENU-DATES'); ?></b><br>
|
|
<select name='selected_menus' id='selected_menus' multiple size='<?php echo($numMenus) ?>' class='select-width200 form-field ui-widget-content ui-corner-all'>
|
|
<?php
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$rnum = $row['record_num'];
|
|
$mtitle = $row['menu_title'];
|
|
$mdate = $row['menu_date'];
|
|
echo(" <option value='$rnum'>$mtitle - $mdate</option>\n");
|
|
}
|
|
|
|
?>
|
|
</select></p>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p><button id='ordered-items-GenerateBtn' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-GENERATE-CSV'); ?></button>
|
|
<button id='ordered-items-dialog-close' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-CLOSE'); ?></button></p>
|
|
</center>
|
|
</div>
|
|
|
|
<?php
|
|
$sp1_checked = 'checked';
|
|
$sp2_checked = 'checked';
|
|
$sp3_checked = 'checked';
|
|
?>
|
|
<div id='sales-summary-csv-dialog' title="<?php displayLanguageText('TEXT-SALES-SUMMARY'); ?>">
|
|
<center>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<form id='sales-summary-csv-form'>
|
|
<p><b><?php displayLanguageText('TEXT-ITEMS'); ?>:</b><br>
|
|
<select name='report_include_items' id='report_include_items'>
|
|
<option value='Flagged'><?php displayLanguageText('TEXT-SUMMARY-ITEMS'); ?></option>
|
|
<option value='All'><?php displayLanguageText('TEXT-INCLUDE-ALL-MENU-ITEMS'); ?></option>
|
|
</select></p>
|
|
<p><b><?php displayLanguageText('TEXT-START-DATE'); ?></b><br>
|
|
<input type='text' name='report_start_date' id='report_start_date' size='12' class='form-field ui-widget-content ui-corner-all date-field'></p>
|
|
<p><b><?php displayLanguageText('TEXT-END-DATE'); ?></b><br>
|
|
<input type='text' name='report_end_date' id='report_end_date' size='12' class='form-field ui-widget-content ui-corner-all date-field'></p>
|
|
<p><b><?php displayLanguageText('TEXT-INCLUDE'); ?></b><br>
|
|
<input type='checkbox' name='include_special1' id='include_special1' value='Y' <?php echo($sp1_checked) ?>> <?php echo($Special1_Title) ?><br>
|
|
<input type='checkbox' name='include_special2' id='include_special2' value='Y' <?php echo($sp2_checked) ?>> <?php echo($Special2_Title) ?><br>
|
|
<input type='checkbox' name='include_special3' id='include_special3' value='Y' <?php echo($sp3_checked) ?>> <?php echo($Special3_Title) ?></p>
|
|
<br>
|
|
</form>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p>
|
|
<button id='salesSummaryCloseBtn' class='btn btn--outline btn--xsmall'><?php displayLanguageText('TEXT-CLOSE'); ?></button>
|
|
<button id='salesSummaryGenerateBtn' class='btn btn--primary btn--xsmall'><?php displayLanguageText('TEXT-GENERATE-CSV'); ?></button>
|
|
<button id='salesSummaryGeneratePDFBtn' class='btn btn--primary btn--xsmall'><?php displayLanguageText('TEXT-PDF'); ?></button>
|
|
</p>
|
|
</center>
|
|
</div>
|