|
|
0) {
// Get set of items to update
$items = "";
while ($row = db_fetch_array($results)) {
if (strlen($items)) $items .= ", ";
$items .= $row['record_num'];
}
// Create SQL statement
$set = "";
// Post the item_title
if (array_key_exists('post_title', $_POST) && $_POST['post_title'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "item_title = '" . db_escape_string($product['product_name']) . "'";
}
// Post the item_description
if (array_key_exists('post_description', $_POST) && $_POST['post_description'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "item_description = '" . db_escape_string($product['product_description']) . "'";
}
// Post the label
if (array_key_exists('post_label', $_POST) && $_POST['post_label'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "label_title = '" . db_escape_string($product['label_name']) . "'";
}
// Post the online price
if (array_key_exists('post_online', $_POST) && $_POST['post_online'] == 'Y') {
if (strlen($set)) $set .= ", ";
$price = floatval($product['standard_online_price']);
$set .= "online_price = $price";
if ($school_record['implement_multiple_item_prices'] == 'Y') {
$num = intval($product['number_of_alternate_prices']);
$set .= ", number_of_alternate_prices = $num";
for ($n = 1; $n <= 10; $n++) {
$price = floatval($product["alternate_price$n"]);
$set .= ", alternate_price$n = $price";
}
}
}
// Post the paper price
if (array_key_exists('post_paper', $_POST) && $_POST['post_paper'] == 'Y') {
if (strlen($set)) $set .= ", ";
$price = $product['standard_offline_price'];
if ($price == '') $price = '0';
$set .= "offline_price = $price";
}
// Post the special price 1
if (array_key_exists('post_special1', $_POST) && $_POST['post_special1'] == 'Y') {
if (strlen($set)) $set .= ", ";
$price = $product['special_price1'];
if ($price == '') $price = '0';
$set .= "special_price1 = $price";
}
// Post the special price 2
if (array_key_exists('post_special2', $_POST) && $_POST['post_special2'] == 'Y') {
if (strlen($set)) $set .= ", ";
$price = $product['special_price2'];
if ($price == '') $price = '0';
$set .= "special_price2 = $price";
}
// Post the special price 3
if (array_key_exists('post_special3', $_POST) && $_POST['post_special3'] == 'Y') {
if (strlen($set)) $set .= ", ";
$price = $product['special_price3'];
if ($price == '') $price = '0';
$set .= "special_price3 = $price";
}
// Post the taxable flag
if (array_key_exists('post_taxable', $_POST) && $_POST['post_taxable'] == 'Y') {
if (strlen($set)) $set .= ", ";
$taxable = $product['taxable_product'];
$set .= "taxable_item = '$taxable'";
}
// Post the options
if (array_key_exists('post_options', $_POST) && $_POST['post_options'] == 'Y') {
if (strlen($set)) $set .= ", ";
$min = intval($product['min_options'],0);
$max = intval($product['max_options'],0);
$min2 = intval($product['min_options2'],0);
$max2 = intval($product['max_options2'],0);
$min3 = intval($product['min_options3'],0);
$max3 = intval($product['max_options3'],0);
$set .= "options_title = '" . db_escape_string($product['options_title']) . "'," .
"options = '" . db_escape_string($product['product_options']) . "'," .
"default_options = '" . db_escape_string($product['default_options']) . "'," .
"min_options = $min, max_options = $max, " .
"options2_title = '" . db_escape_string($product['options2_title']) . "'," .
"options2 = '" . db_escape_string($product['product_options2']) . "'," .
"default_options2 = '" . db_escape_string($product['default_options2']) . "'," .
"min_options2 = $min2, max_options2 = $max2, " . "options3_title = '" . db_escape_string($product['options3_title']) . "'," .
"options3 = '" . db_escape_string($product['product_options3']) . "'," .
"default_options3 = '" . db_escape_string($product['default_options3']) . "'," .
"min_options3 = $min3, max_options3 = $max3";
}
// Post the nutritional info
if (array_key_exists('post_nutritional', $_POST) && $_POST['post_nutritional'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "nutritional_info = '" . db_escape_string($product['nutritional_info']) . "'";
}
// Post the image
if (array_key_exists('post_image', $_POST) && $_POST['post_image'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "image = '" . db_escape_string($product['image']) . "'";
}
// Post the hot_cold_food
if (array_key_exists('post_hot_cold_food', $_POST) && $_POST['post_hot_cold_food'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "hot_cold_food = '" . $product['hot_cold_food'] . "'";
}
// Post the item message
if (array_key_exists('post_message', $_POST) && $_POST['post_message'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "item_message = '" . db_escape_string($product['item_message']) . "'";
}
// Post the Food rating
if (array_key_exists('post_rating', $_POST) && $_POST['post_rating'] == 'Y') {
if (strlen($set)) $set .= ", ";
$set .= "bc_guideline_rating = '" . db_escape_string($product['bc_guideline_rating']) . "'";
}
if (strlen($set)) $set .= ", ";
$set .= "sales_summary_item = '" . $product['sales_summary_item'] . "'";
$query = "UPDATE hotlunch_menu_items SET $set WHERE record_num IN ($items)";
db_query($query);
echo("\n");
}
$class = 'data-even';
if ($i % 2) $class = 'data-odd';
?>
|
|
|