Zen Cart 源代码 products_quantity

Zen Cart 源代码 products_quantity_discounts.php

下载文件

文件名: products_quantity_discounts.php
文件类型: PHP文件
文件大小: 6.14 KiB
MD5: 4fdff60997aff591456d129f0eac83ee

products_quantity_discounts.php - 打开高亮: <?php /** * products_quantity_discounts module * * @package modules * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: products_quantity_discounts.php 6477 2007-06-09 04:38:22Z ajeh $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php')); // if customer authorization is on do not show discounts $zc_hidden_discounts_on = false; $zc_hidden_discounts_text = ''; switch (true) { case (CUSTOMERS_APPROVAL == '1' and $_SESSION['customer_id'] == ''): // customer must be logged in to browse $zc_hidden_discounts_on = true; $zc_hidden_discounts_text = 'MUST LOGIN'; break; case (STORE_STATUS == 1 || CUSTOMERS_APPROVAL == '2' and $_SESSION['customer_id'] == ''): // customer may browse but no prices $zc_hidden_discounts_on = true; $zc_hidden_discounts_text = TEXT_LOGIN_FOR_PRICE_PRICE; break; case (CUSTOMERS_APPROVAL == '3' and TEXT_LOGIN_FOR_PRICE_PRICE_SHOWROOM != ''): // customer may browse but no prices $zc_hidden_discounts_on = true; $zc_hidden_discounts_text = TEXT_LOGIN_FOR_PRICE_PRICE_SHOWROOM; break; case (CUSTOMERS_APPROVAL_AUTHORIZATION != '0' and $_SESSION['customer_id'] == ''): // customer must be logged in to browse $zc_hidden_discounts_on = true; $zc_hidden_discounts_text = TEXT_AUTHORIZATION_PENDING_PRICE; break; case ((CUSTOMERS_APPROVAL_AUTHORIZATION != '0' and CUSTOMERS_APPROVAL_AUTHORIZATION != '3') and $_SESSION['customers_authorization'] > '0'): // customer must be logged in to browse $zc_hidden_discounts_on = true; $zc_hidden_discounts_text = TEXT_AUTHORIZATION_PENDING_PRICE; break; default: // proceed normally break; } // create products discount output table // find out the minimum quantity for this product $products_min_query = $db->Execute("select products_quantity_order_min from " . TABLE_PRODUCTS . " where products_id='" . (int)$products_id_current . "'"); $products_quantity_order_min = $products_min_query->fields['products_quantity_order_min']; // retrieve the list of discount levels for this product $products_discounts_query = $db->Execute("select * from " . TABLE_PRODUCTS_DISCOUNT_QUANTITY . " where products_id='" . (int)$products_id_current . "' and discount_qty !=0 " . " order by discount_qty"); $discount_col_cnt = DISCOUNT_QUANTITY_PRICES_COLUMN; $display_price = zen_get_products_base_price($products_id_current); $display_specials_price = zen_get_products_special_price($products_id_current, true); // set first price value if ($display_specials_price == false) { $show_price = $display_price; } else { $show_price = $display_specials_price; } switch (true) { case ($products_discounts_query->fields['discount_qty'] <= 2): $show_qty = '1'; break; case ($products_quantity_order_min == ($products_discounts_query->fields['discount_qty']-1) || $products_quantity_order_min == ($products_discounts_query->fields['discount_qty'])): $show_qty = $products_quantity_order_min; break; default: $show_qty = $products_quantity_order_min . '-' . number_format($products_discounts_query->fields['discount_qty']-1); break; } //$discounted_price = $products_discounts_query->fields['discount_price']; // $currencies->display_price($discounted_price, zen_get_tax_rate(1), 1) $display_price = zen_get_products_base_price($products_id_current); $display_specials_price = zen_get_products_special_price($products_id_current, true); $disc_cnt = 1; $quantityDiscounts = array(); $columnCount = 0; while (!$products_discounts_query->EOF) { $disc_cnt++; switch ($products_discount_type) { // none case '0': $quantityDiscounts[$columnCount]['discounted_price'] = 0; break; // percentage discount case '1': if ($products_discount_type_from == '0') { $quantityDiscounts[$columnCount]['discounted_price'] = $display_price - ($display_price * ($products_discounts_query->fields['discount_price']/100)); } else { if (!$display_specials_price) { $quantityDiscounts[$columnCount]['discounted_price'] = $display_price - ($display_price * ($products_discounts_query->fields['discount_price']/100)); } else { $quantityDiscounts[$columnCount]['discounted_price'] = $display_specials_price - ($display_specials_price * ($products_discounts_query->fields['discount_price']/100)); } } break; // actual price case '2': if ($products_discount_type_from == '0') { $quantityDiscounts[$columnCount]['discounted_price'] = $products_discounts_query->fields['discount_price']; } else { $quantityDiscounts[$columnCount]['discounted_price'] = $products_discounts_query->fields['discount_price']; } break; // amount offprice case '3': if ($products_discount_type_from == '0') { $quantityDiscounts[$columnCount]['discounted_price'] = $display_price - $products_discounts_query->fields['discount_price']; } else { if (!$display_specials_price) { $quantityDiscounts[$columnCount]['discounted_price'] = $display_price - $products_discounts_query->fields['discount_price']; } else { $quantityDiscounts[$columnCount]['discounted_price'] = $display_specials_price - $products_discounts_query->fields['discount_price']; } } break; } $quantityDiscounts[$columnCount]['show_qty'] = number_format($products_discounts_query->fields['discount_qty']); $products_discounts_query->MoveNext(); if ($products_discounts_query->EOF) { $quantityDiscounts[$columnCount]['show_qty'] .= '+'; } else { if (($products_discounts_query->fields['discount_qty']-1) != $show_qty) { if ($quantityDiscounts[$columnCount]['show_qty'] < $products_discounts_query->fields['discount_qty']-1) { $quantityDiscounts[$columnCount]['show_qty'] .= '-' . number_format($products_discounts_query->fields['discount_qty']-1); } } } $disc_cnt=0; $columnCount++; } ?>