Скидка группы на товар, имеющий специальную цену для этой группы

/**    * Returns the price for a specific shopper group,    * Returns nothing, when the shopper group has no price    *    * @param int $product_id    * @param int $shopper_group_id    * @param boolean $check_multiple_prices    * @param string $additionalSQL    * @return mixed    */    function getPriceByShopperGroup( $product_id, $shopper_group_id, $check_multiple_prices=false, $additionalSQL='' )    {        global $auth;        static $resultcache = array();        $db = new ps_DB;        $vendor_id = $_SESSION['ps_vendor_id'];        if( empty( $shopper_group_id )) {            ps_shopper_group::makeDefaultShopperGroupInfo();            $shopper_group_id = $GLOBALS['vendor_info'][$vendor_id]['default_shopper_group_id'];        }          $whereClause='WHERE product_id=%s AND shopper_group_id=%s ';        $whereClause = sprintf( $whereClause, intval($product_id), intval($shopper_group_id) );        $q = "SELECT `product_price`, `product_price_id`, `product_currency` FROM `#__{vm}_product_price` $whereClause $additionalSQL";              $sig = sprintf("%u\n", crc32($q));        if( !isset($resultcache[$sig]))        {            $db->query($q);            if( !$db->next_record() ) return false;                                  $discount_info = $this->get_discount( $product_id );            if ($discount_info [amount] > 0 )            {            $price_info["product_price"]= $db->f("product_price");            }            else            {            $price_info["product_price"]= $db->f("product_price") * ((100 - $auth["shopper_group_discount"])/100);            }                  $price_info["product_currency"] = $db->f("product_currency");            $price_info["product_base_price"]= $db->f("product_price") * ((100 - $auth["shopper_group_discount"])/100);            $price_info["product_has_multiple_prices"] = $db->num_rows() > 1;            $price_info["product_price_id"] = $db->f("product_price_id");                              $price_info["item"]=true;            $GLOBALS['product_info'][$product_id]['price'] = $price_info;            // Store the result for later            $resultcache[$sig] = $price_info;                      return $GLOBALS['product_info'][$product_id]['price'];        }        else        {        return $resultcache[$sig];        }    }

/** * Get the price of product $product_id for the shopper group associated * with $auth['user_id'] - including shopper group discounts * * @param int $product_id * @param boolean $check_multiple_prices Check if the product has more than one price for that shopper group? * @return array The product price information */ function get_price($product_id, $check_multiple_prices=false, $overrideShopperGroup='' ) { if( empty( $product_id)) return array(); $auth = $_SESSION['auth']; $cart = $_SESSION['cart']; if( empty( $GLOBALS['product_info'][$product_id]['price'] ) || !empty($GLOBALS['product_info'][$product_id]['price']["product_has_multiple_prices"]) || $check_multiple_prices) { $db = new ps_DB; $vendor_id = $this->get_vendor_id($product_id); if( $overrideShopperGroup === '') { $shopper_group_id = $auth["shopper_group_id"]; $shopper_group_discount = $auth["shopper_group_discount"]; } else { $shopper_group_id = $overrideShopperGroup; $shopper_group_discount = 0; } ps_shopper_group::makeDefaultShopperGroupInfo(); // Get the product_parent_id for this product/item $product_parent_id = $this->get_field($product_id, "product_parent_id"); if( !$check_multiple_prices ) { /* Added for Volume based prices */ // This is an important decision: we add up all product quantities with the same product_id, // regardless to attributes. This gives "real" volume based discount, because our simple attributes // depend on one and the same product_id $quantity = 0; $parent_id = ""; if ($product_parent_id) { $parent = true; } else { $parent = false; } for ($i=0;$i<$cart["idx"];$i++) { if ($cart[$i]["product_id"] == $product_id) { if ($parent) { $parent_id = $cart[$i]["parent_id"]; } else { $quantity += $cart[$i]["quantity"]; } } } if ($parent) { for ($i=0;$i<$cart["idx"];$i++) { if (@$cart[$i]['parent_id'] == $parent_id) { $quantity += $cart[$i]["quantity"]; } } } $volume_quantity_sql = " ORDER BY price_quantity_start"; if( $quantity > 0 ) { $volume_quantity_sql = " AND (('$quantity' >= price_quantity_start AND '$quantity' <= price_quantity_end) OR (price_quantity_end='0') OR ('$quantity' > price_quantity_end)) ORDER BY price_quantity_end DESC"; } } else { $volume_quantity_sql = " ORDER BY price_quantity_start"; } // Get the price array $price = $this->getPriceByShopperGroup( $product_id, $shopper_group_id, $check_multiple_prices, $volume_quantity_sql ); if( !$price && $product_parent_id ) { // If this is a child product and it has not a price for the requested shopper group, get the price for the default shopper group $price = $this->getPriceByShopperGroup( $product_parent_id, $GLOBALS['vendor_info'][$vendor_id]['default_shopper_group_id'], $check_multiple_prices, $volume_quantity_sql ); if( !$price ) { // if the child product has no priceat all, get the price of the parent product for that shopper group $price = $this->getPriceByShopperGroup( $product_parent_id, $shopper_group_id, $check_multiple_prices, $volume_quantity_sql ); } if( !$price ) { // if the parent product has no price for the requested shopper group, get the price of the default shopper group $price = $this->getPriceByShopperGroup( $product_parent_id, $shopper_group_id, $check_multiple_prices, $volume_quantity_sql ); } } elseif( !$price ) { // if the product has no price for the requested shopper group, get the price of the default shopper group $price = $this->getPriceByShopperGroup( $product_id, $GLOBALS['vendor_info'][$vendor_id]['default_shopper_group_id'], $check_multiple_prices, $volume_quantity_sql ); } return $price; } else { return $GLOBALS['product_info'][$product_id]['price']; } }

/** * Returns the price for a specific shopper group, * Returns nothing, when the shopper group has no price * * @param int $product_id * @param int $shopper_group_id * @param boolean $check_multiple_prices * @param string $additionalSQL * @return mixed */ function getPriceByShopperGroup( $product_id, $shopper_group_id, $check_multiple_prices=false, $additionalSQL='' ) { global $auth; static $resultcache = array(); $db = new ps_DB; $vendor_id = $_SESSION['ps_vendor_id']; if( empty( $shopper_group_id )) { ps_shopper_group::makeDefaultShopperGroupInfo(); $shopper_group_id = $GLOBALS['vendor_info'][$vendor_id]['default_shopper_group_id']; } $whereClause='WHERE product_id=%s AND shopper_group_id=%s '; $whereClause = sprintf( $whereClause, intval($product_id), intval($shopper_group_id) ); $q = "SELECT `product_price`, `product_price_id`, `product_currency` FROM `#__{vm}_product_price` $whereClause $additionalSQL"; $sig = sprintf("%u\n", crc32($q)); if( !isset($resultcache[$sig])) { $db->query($q); if( !$db->next_record() ) return false; $discount_info = $this->get_discount( $product_id ); if ($discount_info [amount] > 0 ) { $price_info["product_price"]= $db->f("product_price"); } else { $price_info["product_price"]= $db->f("product_price") * ((100 - $auth["shopper_group_discount"])/100); } $price_info["product_currency"] = $db->f("product_currency"); $price_info["product_base_price"]= $db->f("product_price") * ((100 - $auth["shopper_group_discount"])/100); $price_info["product_has_multiple_prices"] = $db->num_rows() > 1; $price_info["product_price_id"] = $db->f("product_price_id"); $price_info["item"]=true; $GLOBALS['product_info'][$product_id]['price'] = $price_info; // Store the result for later $resultcache[$sig] = $price_info; return $GLOBALS['product_info'][$product_id]['price']; } else { return $resultcache[$sig]; } }