PHP oos_get_products_special_price函数代码示例

/**
 * Return the base price plus the special price
 *
 * @param $products_id
 * @return string
 */
function oos_get_products_base_price_special_total($products_id)
{
    if (oos_get_products_special_price($products_id) > 0) {
        $the_final_price = oos_get_products_special_price($products_id) + oos_get_products_base_price($products_id);
    } else {
        $the_final_price = 0;
    }
    return $the_final_price;
}

        $product_info = $product_info_result->fields;

        $info_product_price = '';
        $info_product_special_price = '';
        $info_product_discount = 0;
        $info_product_discount_price = '';
        $info_base_product_price = '';
        $info_base_product_special_price = '';
        $info_product_price_list = 0;
        $info_special_price = '';
        $info_product_special_price = '';

        if ($_SESSION['member']->group['show_price'] == 1 ) {
            $info_product_price = $oCurrencies->display_price($product_info['products_price'], oos_get_tax_rate($product_info['products_tax_class_id']));

            if ($info_special_price = oos_get_products_special_price($product_info['products_id'])) {
                $info_product_special_price = $oCurrencies->display_price($info_special_price, oos_get_tax_rate($product_info['products_tax_class_id']));
            } else {
                $info_product_discount = min($product_info['products_discount_allowed'], $_SESSION['member']->group['discount']);

                if ($info_product_discount != 0 ) {
                    $info_product_special_price = $product_info['products_price']*(100-$info_product_discount)/100;
                    $info_product_discount_price = $oCurrencies->display_price($info_product_special_price, oos_get_tax_rate($product_info['products_tax_class_id']));
                }

            }

            if ($product_info['products_base_price'] != 1) {
                $info_base_product_price = $oCurrencies->display_price($product_info['products_price'] * $product_info['products_base_price'], oos_get_tax_rate($product_info['products_tax_class_id']));

                if ($info_product_special_price != '') {

 $output .= '<channel>' . "\n";
 $output .= '<title>' . $feed_title . '</title>' . "\n";
 $output .= '<description>' . $feed_description . '</description>' . "\n";
 $output .= '<link>' . $site_url . '</link>' . "\n";
 $limit = 0;
 $limit_step = 1000;
 do {
     $nLanguageID = intval($_SESSION['language_id']);
     $productstable = $oostable['products'];
     $products_descriptiontable = $oostable['products_description'];
     $sql = "SELECT p.products_id, p.products_model, p.products_image, p.products_price,\n                         p.products_tax_class_id, p.products_quantity, pd.products_name, pd.products_description\n                    FROM {$productstable} p,\n                         {$products_descriptiontable} pd\n                   WHERE p.products_id = pd.products_id\n                     AND p.products_status >= '1'\n                     AND p.products_access = '0'\n                     AND pd.products_languages_id = '" . intval($nLanguageID) . "'";
     $products_result = $dbconn->SelectLimit($sql, $limit_step, $limit);
     $count = $products_result->RecordCount();
     if ($count > 0) {
         while ($products = $products_result->fields) {
             if ($specialprice = oos_get_products_special_price($products['products_id'])) {
                 $price = $specialprice;
             } else {
                 $price = $products['products_price'];
             }
             if ($price > 0) {
                 $tax = (100 + oos_get_tax_rate($products['products_tax_class_id'])) / 100;
                 $price = number_format($price * $tax, 2, ".", "");
                 $products_description = $products['products_description'];
                 $products_description = trim($products_description);
                 $products_description = strip_tags($products_description);
                 $products_description = utf8_encode($products_description);
                 /*
                                $output.='      <item>'."\n";
                                $output.='            <title>' . xmlentities(strip_tags($products['products_name']). " - " . $products['products_model']) . '</title>'."\n";
                                $output.='            <description>' . xmlentities($products_description) . '</description>'."\n";

$customer_info = $customer_result->fields;
$customer = $customer_info['customers_firstname'] . ' ' . $customer_info['customers_lastname'] . ': ';
$aWishlist = array();
while ($wishlist = $wishlist_result->fields) {
    $wl_products_id = oos_get_product_id($wishlist['products_id']);
    $sql = "SELECT p.products_id, pd.products_name, pd.products_description, p.products_model,\n                   p.products_image, p.products_price, p.products_base_price, p.products_base_unit,\n                   p.products_discount_allowed, p.products_tax_class_id, p.products_units_id\n            FROM " . $oostable['products'] . " p,\n                 " . $oostable['products_description'] . " pd\n            WHERE p.products_id = '" . intval($wl_products_id) . "'\n              AND pd.products_id = p.products_id\n              AND pd.products_languages_id = '" . intval($nLanguageID) . "'";
    $wishlist_product = $dbconn->GetRow($sql);
    $wishlist_product_price = '';
    $wishlist_product_special_price = '';
    $wishlist_product_discount = 0;
    $wishlist_product_discount_price = '';
    $wishlist_base_product_price = '';
    $wishlist_base_product_special_price = '';
    $wishlist_special_price = '';
    $wishlist_product_price = $oCurrencies->display_price($wishlist_product['products_price'], oos_get_tax_rate($wishlist_product['products_tax_class_id']));
    if ($wishlist_special_price = oos_get_products_special_price($wl_products_id)) {
        $wishlist_product_special_price = $oCurrencies->display_price($wishlist_special_price, oos_get_tax_rate($wishlist_product['products_tax_class_id']));
    } else {
        $wishlist_product_discount = min($wishlist_product['products_discount_allowed'], $_SESSION['member']->group['discount']);
        if ($wishlist_product_discount != 0) {
            $wishlist_special_price = $wishlist_product['products_price'] * (100 - $wishlist_product_discount) / 100;
            $wishlist_product_discount_price = $oCurrencies->display_price($wishlist_special_price, oos_get_tax_rate($wishlist_product['products_tax_class_id']));
        }
    }
    if ($wishlist_product['products_base_price'] != 1) {
        $wishlist_base_product_price = $oCurrencies->display_price($wishlist_product['products_price'] * $wishlist_product['products_base_price'], oos_get_tax_rate($wishlist_product['products_tax_class_id']));
        if ($wishlist_special_price != '') {
            $wishlist_base_product_special_price = $oCurrencies->display_price($wishlist_special_price * $wishlist_product['products_base_price'], oos_get_tax_rate($wishlist_product['products_tax_class_id']));
        }
    }
    $sql = "SELECT products_options_id, products_options_value_id\n            FROM " . $oostable['customers_wishlist_attributes'] . "\n            WHERE customers_wishlist_link_id = '" . oos_db_input($wlid) . "'\n              AND products_id = '" . $wishlist['products_id'] . "'";

        $productstable = $oostable['products'];
        $products_descriptiontable = $oostable['products_description'];
        $sql6 = "SELECT p.products_price AS price,
                        p.products_model AS model,
                        pd.products_name AS name
                   FROM $productstable p,
                        $products_descriptiontable pd
                  WHERE p.products_id = '" . (int)$inrec['pid'] . "' AND
                        pd.products_id = p.products_id AND
                        pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'";
        $result6 = $dbconn->Execute($sql6);

        $inrec6 = $result6->fields;

        // Check to see if the product is on special, and if so use that pricing
        $sprice = oos_get_products_special_price($inrec['pid']);
        if ($sprice < 1) {
          $sprice = $inrec6['price'];
        }

        // BEGIN OF ATTRIBUTE DB CODE
        $prodAttribs = ''; // DO NOT DELETE

        if (RCS_SHOW_ATTRIBUTES == '1') {
          $customers_basket_attributestable = $oostable['customers_basket_attributes'];
          $products_optionstable = $oostable['products_options'];
          $products_options_valuestable = $oostable['products_options_values'];
          $attrib_sql = "SELECT cba.products_id AS pid,
                                po.products_options_name AS poname,
                                pov.products_options_values_name AS povname
                           FROM $customers_basket_attributestable cba,

    $aFeatured = array();
    while ($featured = $featured_result->fields)
    {

        $featured_product_price = '';
        $featured_product_special_price = '';
        $featured_max_product_discount = 0;
        $featured_product_discount_price = '';
        $featured_base_product_price = '';
        $featured_base_product_special_price = '';
        $featured_special_price = '';

        $featured_units = UNITS_DELIMITER . $products_units[$featured['products_units_id']];

        $featured_product_price = $oCurrencies->display_price($featured['products_price'], oos_get_tax_rate($featured['products_tax_class_id']));
        $featured_special_price = oos_get_products_special_price($featured['products_id']);

        if (!empty($featured_special_price)) {
            $featured_product_special_price = $oCurrencies->display_price($featured_special_price, oos_get_tax_rate($featured['products_tax_class_id']));
        } else {
            $featured_max_product_discount = min($featured['products_discount_allowed'],$_SESSION['member']->group['discount']);
            if ($featured_max_product_discount != 0 ) {
                $featured_special_price = $featured['products_price']*(100-$featured_max_product_discount)/100;
                $featured_product_discount_price = $oCurrencies->display_price($featured_special_price, oos_get_tax_rate($featured['products_tax_class_id']));
            }
        }

        if ($featured['products_base_price'] != 1) {
            $featured_base_product_price = $oCurrencies->display_price($featured['products_price'] * $featured['products_base_price'], oos_get_tax_rate($featured['products_tax_class_id']));

            if ($featured_special_price != '') {

 function products_price_actual($product_id, $actual_price, $products_qty)
 {
     $new_price = $actual_price;
     if ($new_special_price = oos_get_products_special_price($product_id)) {
         $new_price = $new_special_price;
     }
     if ($new_discounts_price = oos_get_products_price_quantity_discount($product_id, $products_qty, $new_price)) {
         $new_price = $new_discounts_price;
     }
     return $new_price;
 }

   Based on:

   WebMakers.com Added: Discount Quantity
   Written by Linda McGrath osCOMMERCE@WebMakers.com
   http://www.thewebmakerscorner.com

   BOF: WebMakes.com Added: Discount Quantity
   ----------------------------------------------------------------------
   Released under the GNU General Public License
   ---------------------------------------------------------------------- */
/** ensure this file is being included by a parent file */
defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.');
if (!isset($nProductsId)) {
    $nProductsId = oos_get_product_id($_GET['products_id']);
}
$the_special = oos_get_products_special_price($nProductsId);
$q0 = $product_info['products_quantity_order_min'];
$q1 = $product_info['products_discount1_qty'];
$q2 = $product_info['products_discount2_qty'];
$q3 = $product_info['products_discount3_qty'];
$q4 = $product_info['products_discount4_qty'];
$col_cnt = 1;
if ($product_info['products_discount1'] > 0) {
    $col_cnt = $col_cnt + 1;
}
if ($product_info['products_discount2'] > 0) {
    $col_cnt = $col_cnt + 1;
}
if ($product_info['products_discount3'] > 0) {
    $col_cnt = $col_cnt + 1;
}

}
$whats_new_block = '0';
$productstable = $oostable['products'];
$query = "SELECT products_id, products_image, products_tax_class_id, products_units_id, products_price,\n                 products_base_price, products_base_unit, products_discount_allowed\n          FROM {$productstable}\n          WHERE products_status >= '1'\n            AND (products_access = '0' OR products_access = '" . intval($nGroupID) . "')\n          ORDER BY products_date_added DESC";
if ($random_product = oos_random_select($query, MAX_RANDOM_SELECT_NEW)) {
    $whats_new_block = '1';
    $random_product['products_name'] = oos_get_products_name($random_product['products_id']);
    $whats_new_product_price = '';
    $whats_new_product_special_price = '';
    $whats_new_max_product_discount = 0;
    $whats_new_product_discount_price = '';
    $whats_new_base_product_price = '';
    $whats_new_base_product_special_price = '';
    $whats_new_special_price = '';
    if ($_SESSION['member']->group['show_price'] == 1) {
        $whats_new_special_price = oos_get_products_special_price($random_product['products_id']);
        $whats_new_product_price = $oCurrencies->display_price($random_product['products_price'], oos_get_tax_rate($random_product['products_tax_class_id']));
        if (oos_is_not_null($whats_new_product_price)) {
            $whats_new_product_special_price = $oCurrencies->display_price($whats_new_special_price, oos_get_tax_rate($random_product['products_tax_class_id']));
        } else {
            $whats_new_max_product_discount = min($random_product['products_discount_allowed'], $_SESSION['member']->group['discount']);
            if ($whats_new_max_product_discount != 0) {
                $whats_new_special_price = $random_product['products_price'] * (100 - $whats_new_max_product_discount) / 100;
                $whats_new_product_discount_price = $oCurrencies->display_price($whats_new_special_price, oos_get_tax_rate($random_product['products_tax_class_id']));
            }
        }
        if ($random_product['products_base_price'] != 1) {
            $whats_new_base_product_price = $oCurrencies->display_price($random_product['products_price'] * $random_product['products_base_price'], oos_get_tax_rate($random_product['products_tax_class_id']));
            if ($whats_new_special_price != '') {
                $whats_new_base_product_special_price = $oCurrencies->display_price($whats_new_special_price * $random_product['products_base_price'], oos_get_tax_rate($random_product['products_tax_class_id']));
            }

   OOS [OSIS Online Shop]
   http://www.oos-shop.de/

   Copyright (c) 2003 - 2009 by the OOS Development Team.
   ----------------------------------------------------------------------
   Based on:

   Written by Linda McGrath osCOMMERCE@WebMakers.com
   http://www.thewebmakerscorner.com
   ----------------------------------------------------------------------
   Released under the GNU General Public License
   ---------------------------------------------------------------------- */
/** ensure this file is being included by a parent file */
defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.');
if (!($pInfo->products_discount1_qty == 0 and $pInfo->products_discount2_qty == 0 and $pInfo->products_discount3_qty == 0 and $pInfo->products_discount4_qty == 0)) {
    $the_special = oos_get_products_special_price($_GET['pID']);
    $q0 = $pInfo->products_quantity_order_min;
    $q1 = $pInfo->products_discount1_qty;
    $q2 = $pInfo->products_discount2_qty;
    $q3 = $pInfo->products_discount3_qty;
    $q4 = $pInfo->products_discount4_qty;
    $col_cnt = 1;
    if ($pInfo->products_discount1 > 0) {
        $col_cnt = $col_cnt + 1;
    }
    if ($pInfo->products_discount2 > 0) {
        $col_cnt = $col_cnt + 1;
    }
    if ($pInfo->products_discount3 > 0) {
        $col_cnt = $col_cnt + 1;
    }