81 lines
3.2 KiB
PHP
81 lines
3.2 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 18609;
|
|
$schedule_num = 19293;
|
|
$menu_num = 249844;
|
|
|
|
// // Get Group A items
|
|
// $results = db_query("SELECT record_num FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND menu_group = 'A'");
|
|
// $groupA = array();
|
|
// while ($row = db_fetch_assoc($results)) {
|
|
// $groupA[] = $row['record_num'];
|
|
// }
|
|
// $GroupA = implode(",",$groupA);
|
|
// echo("$GroupA\n");
|
|
//
|
|
//
|
|
// // Get Group C items
|
|
// $results = db_query("SELECT record_num FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND menu_group = 'C'");
|
|
// $groupC = array();
|
|
// while ($row = db_fetch_assoc($results)) {
|
|
// $groupC[] = $row['record_num'];
|
|
// }
|
|
// $GroupC = implode(",",$groupC);
|
|
// echo("$GroupC\n");
|
|
//
|
|
// exit();
|
|
|
|
$query = "SELECT hloi.menu_item_num AS item1, hloi2.menu_item_num AS item2, hloi3.menu_item_num AS item3, COUNT(*) AS qty " .
|
|
"FROM hotlunch_order_items AS hloi, hotlunch_order_items AS hloi2, hotlunch_order_items AS hloi3 " .
|
|
"WHERE hloi.school_num = $school_num " .
|
|
"AND hloi.schedule_num = $schedule_num " .
|
|
"AND hloi.menu_num = $menu_num " .
|
|
"AND hloi.menu_item_num IN (SELECT record_num FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND menu_group IN ('A')) " .
|
|
"AND hloi2.school_num = $school_num " .
|
|
"AND hloi2.schedule_num = $schedule_num " .
|
|
"AND hloi2.menu_num = $menu_num " .
|
|
"AND hloi2.menu_item_num IN (SELECT record_num FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND menu_group = 'B') " .
|
|
"AND hloi.order_num = hloi2.order_num " .
|
|
"AND hloi3.school_num = $school_num " .
|
|
"AND hloi3.schedule_num = $schedule_num " .
|
|
"AND hloi3.menu_num = $menu_num " .
|
|
"AND hloi3.menu_item_num IN (SELECT record_num FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND menu_group = 'C') " .
|
|
"AND hloi.order_num = hloi3.order_num " .
|
|
"GROUP BY 1,2,3";
|
|
echo("$query\n\n");
|
|
$results = db_query($query);
|
|
|
|
$totals = array();
|
|
|
|
while ($row = db_fetch_assoc($results)) {
|
|
extract($row);
|
|
|
|
$item_title1 = db_getVal("SELECT item_title FROM hotlunch_menu_items " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND menu_num = $menu_num " .
|
|
"AND record_num = $item1");
|
|
|
|
$item_title2 = db_getVal("SELECT item_title FROM hotlunch_menu_items " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND menu_num = $menu_num " .
|
|
"AND record_num = $item2");
|
|
|
|
$item_title3 = db_getVal("SELECT item_title FROM hotlunch_menu_items " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND menu_num = $menu_num " .
|
|
"AND record_num = $item3");
|
|
|
|
printf("%-50s %10d\n","$item_title1 $item_title2 $item_title3",$qty);
|
|
|
|
if (isset($totals[$item_title3])) $totals[$item_title3] += $qty;
|
|
else $totals[$item_title3] = $qty;
|
|
}
|
|
echo("\n");
|
|
|
|
foreach ($totals AS $key => $val) {
|
|
echo("$key -> $val\n");
|
|
}
|
|
|
|
?>
|