365 lines
12 KiB
PHP
365 lines
12 KiB
PHP
<?php
|
|
require_once("include/globals.php");
|
|
|
|
if (SessionActive() != 1 || ! UserLoggedIn()) {
|
|
header("Location: /");
|
|
exit();
|
|
}
|
|
|
|
|
|
// Start the template and output buffering
|
|
startTemplate();
|
|
$templatePageTitle = getLanguageText('TEXT-RESELLER-PANEL');
|
|
|
|
$reseller_code = $school_record['reseller'];
|
|
|
|
?>
|
|
|
|
<script>
|
|
$(document).ready(function() {
|
|
|
|
<?php include "include/ajax.Setup.php" ?>
|
|
|
|
$("#main-tabs").tabs();
|
|
|
|
$("#menu-date-select").hide();
|
|
$("#report-select").hide();
|
|
$("#report-generate").hide();
|
|
|
|
$("#schedule-select").hide();
|
|
|
|
$("#search_field").autocomplete({
|
|
source: "ajax.resellerSearch.php",
|
|
minLength: 2,
|
|
width: 750,
|
|
selectFirst: false,
|
|
select: function( event, results ) {
|
|
var school_num = results.item.school_num;
|
|
var user_num = results.item.user_num;
|
|
$("#school_num").val(school_num);
|
|
getUserInfo(school_num,user_num);
|
|
}
|
|
});
|
|
|
|
function getUserInfo(school_num, user_num) {
|
|
var data = "table_name=users"+
|
|
"&sequence_flag=N"+
|
|
"&action=user-info"+
|
|
"&reseller_school="+school_num+
|
|
"&user_num="+user_num;
|
|
$.getJSON("ajax.DataTable.Fetch.php",data,
|
|
function(results) {
|
|
// Display data
|
|
$("#user-info-span").html(results.content);
|
|
$("#search_field").val('');
|
|
}
|
|
);
|
|
}
|
|
|
|
$(document).on('change', '#selected_school', function() {
|
|
var school_num = $("#selected_school").val();
|
|
loadMenuDates(school_num);
|
|
});
|
|
|
|
$("#view-selected-school").click(function(e) {
|
|
e.preventDefault();
|
|
var school_num = $("#selected_school").val();
|
|
loadMenuDates(school_num);
|
|
});
|
|
|
|
function loadMenuDates(school_num) {
|
|
$("#report-select").hide();
|
|
$("#report-generate").hide();
|
|
|
|
if (school_num == 0) {
|
|
$("#menu-date-select").hide();
|
|
return;
|
|
}
|
|
|
|
$.getJSON("ajax.DataSet.Fetch.php",
|
|
{
|
|
dataset: 'reseller-menu-dates',
|
|
school_num: school_num
|
|
},
|
|
function(results) {
|
|
var data = results.data;
|
|
var optgroup_started = false;
|
|
|
|
$("#selected_menu_date").empty();
|
|
|
|
$("#selected_menu_date").append($("<option disabled='disabled' selected></option>").attr("value","").text("<?php displayLanguageText('TEXT-MENU-DATE'); ?>"));
|
|
|
|
$.each(data, function(key, entry) {
|
|
if (entry.value == 0) {
|
|
if (!optgroup_started) $("#selected_menu_date").append($("</optgroup>"));
|
|
$("#selected_menu_date").append($("<optgroup label='"+entry.text+"'>"));
|
|
}
|
|
else {
|
|
$("#selected_menu_date").append($("<option></option>").attr("value",entry.value).text(' - '+entry.text));
|
|
}
|
|
});
|
|
$("#selected_menu_date").append($("</optgroup>"));
|
|
|
|
$("#menu-date-select").show();
|
|
}
|
|
);
|
|
}
|
|
|
|
$(document).on('change', '#selected_menu_date', function() {
|
|
var school_num = $("#selected_school").val();
|
|
var menu_num = $("#selected_menu_date").val();
|
|
|
|
if (school_num == 0) {
|
|
$("#menu-date-select").hide();
|
|
$("#report-select").hide();
|
|
$("#report-generate").hide();
|
|
return;
|
|
}
|
|
|
|
if (menu_num == 0) {
|
|
$("#report-select").hide();
|
|
$("#report-generate").hide();
|
|
return;
|
|
}
|
|
|
|
if (menu_num == -1) {
|
|
alert("<?php displayLanguageText('ERRORMSG-NO-ORDERS-FOR-MENU-DATE'); ?>");
|
|
$("#report-select").hide();
|
|
$("#report-generate").hide();
|
|
return;
|
|
}
|
|
|
|
$("#selected_report").val('');
|
|
$("#report-select").show();
|
|
$("#report-generate").show();
|
|
});
|
|
|
|
$("#report-generate").click(function(e) {
|
|
e.preventDefault();
|
|
|
|
var school_num = $("#selected_school").val();
|
|
var menu_num = $("#selected_menu_date").val();
|
|
var selected_report = $("#selected_report").val();
|
|
|
|
switch (selected_report) {
|
|
case 'delivery-report':
|
|
window.location = "hotlunch_menu_details.print.php?reseller_school="+school_num+"&reseller_menu_num="+menu_num;
|
|
break;
|
|
|
|
case 'order-details-report':
|
|
window.location = "hotlunch.order_details.generate.php?reseller_school="+school_num+"&reseller_menu_num="+menu_num;
|
|
break;
|
|
|
|
case 'order-details-csv':
|
|
window.location = "hotlunch.order_details.csv.php?reseller_school="+school_num+"&reseller_menu_num="+menu_num;
|
|
break;
|
|
|
|
case 'item-labels':
|
|
window.location = "hotlunch.labels.generate.php?reseller_school="+school_num+"&reseller_menu_num="+menu_num;
|
|
break;
|
|
|
|
case 'order-labels':
|
|
window.location = "hotlunch.meal.labels.generate.php?reseller_school="+school_num+"&reseller_menu_num="+menu_num;
|
|
break;
|
|
}
|
|
});
|
|
|
|
|
|
$(document).on('change', '#selected_schedule_school', function() {
|
|
var school_num = $("#selected_schedule_school").val();
|
|
|
|
if (school_num == 0) {
|
|
$("#schedule-select").hide();
|
|
return;
|
|
}
|
|
|
|
$.getJSON("ajax.DataSet.Fetch.php",
|
|
{
|
|
dataset: 'reseller-schedules',
|
|
school_num: school_num
|
|
},
|
|
function(results) {
|
|
var data = results.data;
|
|
var num_schedules = results.count;
|
|
var schedule_num = results.schedule_num;
|
|
|
|
$("#selected_schedule").empty();
|
|
|
|
$("#selected_schedule").append($("<option disabled='disabled' selected></option>").attr("value","").text("<?php displayLanguageText('TEXT-SCHEDULE'); ?>"));
|
|
|
|
$.each(data, function(key, entry) {
|
|
$("#selected_schedule").append($("<option></option>").attr("value",entry.value).text(entry.text));
|
|
});
|
|
|
|
$("#schedule-select").show();
|
|
|
|
loadScheduleInfo(schedule_num);
|
|
}
|
|
);
|
|
});
|
|
|
|
function loadScheduleInfo(schedule_num) {
|
|
alert('Coming soon - '+schedule_num);
|
|
}
|
|
|
|
});
|
|
</script>
|
|
|
|
<br>
|
|
<table width='850' class='content-table'>
|
|
<tr>
|
|
<td>
|
|
<div id='main-tabs'>
|
|
<ul>
|
|
<li id='search-div-tab'><a href='#search-div'><?php displayLanguageText('TEXT-SEARCH'); ?></a></li>
|
|
<li id='reports-div-tab'><a href='#reports-div'><?php displayLanguageText('TEXT-SCHOOL-REPORTS'); ?></a></li>
|
|
<!-- <li id='schedules-div-tab'><a href='#global-reports-div'><?php displayLanguageText('TEXT-REPORTS'); ?></a></li> -->
|
|
</ul>
|
|
<div id='search-div'>
|
|
<table width='100%'>
|
|
<tr>
|
|
<td>
|
|
<center>
|
|
<h2><?php displayLanguageText('TEXT-SEARCH'); ?></h2>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<p><b><?php displayLanguageText('TEXT-SEARCH-TEXT'); ?>:</b><br>
|
|
<input type='text' name='search_field' id='search_field' size='50' class='form-field'></p>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<span id='user-info-span'></span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</center>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
</div>
|
|
<div id='reports-div'>
|
|
<table width='100%'>
|
|
<tr>
|
|
<td>
|
|
<center>
|
|
<h2><?php displayLanguageText('TEXT-REPORTS'); ?></h2>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<p><b><?php displayLanguageText('TEXT-SCHOOLS'); ?>:</b><br>
|
|
<select name='selected_school' id='selected_school' class='form-field select-width400'>
|
|
<option value='0'><?php displayLanguageText('TEXT-SCHOOL-SELECT'); ?></option>
|
|
<?php
|
|
$query = "SELECT * FROM schools WHERE status = 'Active' AND reseller = '$reseller_code' ORDER BY school_name";
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$school_name = $row['school_name'];
|
|
$school_number = $row['record_num'];
|
|
echo(" <option value='$school_number'>$school_name</option>\n");
|
|
}
|
|
?>
|
|
</select>
|
|
<button id='view-selected-school' class='btn btn--outline btn--xsmall'> <?php displayLanguageText('TEXT-VIEW'); ?> </button></p>
|
|
<p id='menu-date-select'><b><?php displayLanguageText('TEXT-MENU-DATE'); ?>:</b><br>
|
|
<select name='selected_menu_date' id='selected_menu_date' class='form-field select-width400'>
|
|
</select></p>
|
|
<p id='report-select'><b><?php displayLanguageText('TEXT-REPORT'); ?>:</b><br>
|
|
<select name='selected_report' id='selected_report' class='form-field select-width400'>
|
|
<option value='' disabled='disabled' selected></option>
|
|
<option value='delivery-report'><?php displayLanguageText('TEXT-DELIVERY-REPORT'); ?></option>
|
|
<option value='order-details-report'><?php displayLanguageText('TEXT-ORDER-DETAILS-REPORT'); ?> (PDF)</option>
|
|
<option value='order-details-csv'><?php displayLanguageText('TEXT-ORDER-DETAILS-CSV'); ?></option>
|
|
<option value='item-labels'><?php displayLanguageText('TEXT-ITEM-LABELS'); ?></option>
|
|
<option value='order-labels'><?php displayLanguageText('TEXT-ORDER-LABELS'); ?></option>
|
|
</select></p>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<button id='report-generate' class='btn btn--outline btn--xsmall'> <?php displayLanguageText('TEXT-GENERATE'); ?> </button>
|
|
<span id='menu-results-span'></span>
|
|
</center>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
</div>
|
|
<!--
|
|
<div id='global-reports-div'>
|
|
<table width='100%'>
|
|
<tr>
|
|
<td>
|
|
<center>
|
|
<h2><?php displayLanguageText('TEXT-REPORTS'); ?></h2>
|
|
<table>
|
|
<tr>
|
|
<td align='left'>
|
|
<p><b><?php displayLanguageText('TEXT-SCHOOLS'); ?>:</b><br>
|
|
<select name='selected_schedule_school' id='selected_schedule_school' class='form-field select-width400'>
|
|
<option value='0'><?php displayLanguageText('TEXT-SCHOOL-SELECT'); ?></option>
|
|
<?php
|
|
$query = "SELECT * FROM schools WHERE status = 'Active' AND reseller = '$reseller_code' ORDER BY school_name";
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$school_name = $row['school_name'];
|
|
$school_number = $row['record_num'];
|
|
echo(" <option value='$school_number'>$school_name</option>\n");
|
|
}
|
|
?>
|
|
</select></p>
|
|
<p id='schedule-select'><b><?php displayLanguageText('TEXT-SCHEDULE'); ?>:</b><br>
|
|
<select name='selected_schedule' id='selected_schedule' class='form-field select-width400'>
|
|
</select></p>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<span id='menu-results-span'></span>
|
|
</center>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
<p><br></p>
|
|
</div>
|
|
-->
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
<?php
|
|
endTemplate();
|
|
?>
|