57 lines
1.6 KiB
PHP
57 lines
1.6 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$school_num = 503;
|
|
$schedule_num = 6129;
|
|
$supplier_num = 4015;
|
|
|
|
$product_type = 'Product';
|
|
$package_qty = 1;
|
|
$package_cost = 0.00;
|
|
$taxable_product = 'N';
|
|
$added_date = date("Y-m-d",time());
|
|
$special_price1 = 0.00;
|
|
$special_price2 = 0.00;
|
|
$special_price3 = 0.00;
|
|
$bc_guideline_rating = 'N/A';
|
|
$status = 'Active';
|
|
|
|
$items = db_query("SELECT hlmi.* AS date_num FROM hotlunch_menu_items AS hlmi, hotlunch_menu_dates AS hlmd " .
|
|
"WHERE hlmi.school_num = $school_num " .
|
|
"AND hlmd.record_num = hlmi.menu_num " .
|
|
"AND hlmd.schedule_num = $schedule_num " .
|
|
"ORDER BY hlmd.sequence,hlmi.sequence");
|
|
|
|
$sequence = 1;
|
|
|
|
$sp = new Table("supplier_products");
|
|
|
|
while ($row = db_fetch_array($items)) {
|
|
extract($row);
|
|
|
|
$product_name = $item_title;
|
|
$product_description = $item_description;
|
|
$label_name = $label_title;
|
|
$standard_online_price = $online_price;
|
|
$standard_offline_price = $offline_price;
|
|
|
|
$results = db_query("SELECT * FROM supplier_products WHERE school_num = $school_num AND product_name = '" . db_escape_string($product_name) . "'");
|
|
if (db_num_rows($results) == 0) {
|
|
$query = $sp->BuildInsert();
|
|
db_query($query);
|
|
$product_num = db_insert_id();
|
|
|
|
db_query("INSERT INTO hotlunch_menu_products VALUES ($school_num,$record_num,1,$product_num,1)");
|
|
$sequence++;
|
|
}
|
|
else {
|
|
$row = db_fetch_array($results);
|
|
$product_num = $row['record_num'];
|
|
db_query("INSERT INTO hotlunch_menu_products VALUES ($school_num,$record_num,1,$product_num,1)");
|
|
}
|
|
}
|
|
|
|
?>
|