Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Quantity Price Break - Tweaking

Sigma Matt

By Sigma Matt
in General Add-Ons Support

 Share

Recommended Posts

Sigma Matt

Sigma Matt

Posted
Posted

I successfully installed the Quantity Price Break on my site, and a couple of interesting things happened that I want to fix.

 

As a default, it's letting me leave pricing for 1 item+. I'd like to omit the price of the item at 1, and then just go to my table, how do I do this?

 

Also, when I've been testing, it randomly changes the number of actual products in the shopping cart, for instance, I typed in 100, and it put 105. Why is it doing this and how can I fix it?

 

Lastly, which might be the easiest question, ha, how do I change the positioning of this table from being at the top of the product listing?

 

 

 

Thanks for all of your help, I am relatively new and any help would be most appreciated!

Sigma Matt

Sigma Matt

Posted
  • Author
Posted 

<?php
/*
 $Id: PriceFormatter.php admin version,v 1.7 2006/12/23 JanZ Exp $
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2003 osCommerce
 Released under the GNU General Public License
*/
/*
   PriceFormatter.php - module to support quantity pricing
   Created 2003, Beezle Software based on some code mods by WasaLab Oy (Thanks!)

   Refactored 2008, Moved pricebreak data into dedicated table
*/
class PriceFormatter {
 function PriceFormatter() {
   $this->thePrice = -1;
   $this->taxClass = -1;
   $this->qtyBlocks = 1;
   $this->price_breaks = array();
   $this->hasQuantityPrice = false; 
   $this->hiPrice = -1;
   $this->lowPrice = -1;
   $this->hasSpecialPrice = false; //tep_not_null($this->specialPrice);
   $this->specialPrice = NULL; //$prices['specials_new_products_price'];
 }
 function loadProduct($product_id, $products_price, $products_tax_class_id, $qtyBlocks, $price_breaks_array = NULL)
 {
   //Collect required data
   //Price-breaks
   if (!tep_not_null($price_breaks_array)) {
  $price_breaks_array = array();
  $price_breaks_query = tep_db_query("select products_price, products_qty from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id = '" . tep_db_input($product_id) . "' order by products_qty");
  while ($price_break = tep_db_fetch_array($price_breaks_query)) {
    $price_breaks_array[] = $price_break;
  }
   }

   //Specials
   $products_special_price = NULL;
   $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . tep_db_input($product_id) . "'");
   if($special = tep_db_fetch_array($specials_query)) {
  $products_special_price = $special['specials_new_products_price'];
   }

   //Compose cachable structure
   $price_formatter_data = array(
  'products_price' => $products_price,
  'products_special_price' => $products_special_price,
  'products_tax_class_id' => $products_tax_class_id,
  'price_breaks' => $price_breaks_array,
  'qtyBlocks' => $qtyBlocks);

   //Assign members
   $this->thePrice = $price_formatter_data['products_price'];
   $this->taxClass = $price_formatter_data['products_tax_class_id'];
   $this->qtyBlocks = $price_formatter_data['qtyBlocks'];
   $this->price_breaks = $price_formatter_data['price_breaks'];
   $this->specialPrice = $price_formatter_data['products_special_price'];
   $this->hasSpecialPrice = tep_not_null($this->specialPrice);
   //Custom	 
   $this->hasQuantityPrice = false;
   $this->hiPrice = $this->thePrice;
   $this->lowPrice = $this->thePrice;
   if (count($this->price_breaks) > 0) {
  $this->hasQuantityPrice = true;
  foreach($this->price_breaks as $price_break) {
    $this->hiPrice = max($this->hiPrice, $price_break['products_price']);
    $this->lowPrice = min($this->lowPrice, $price_break['products_price']);
  }
   }
   /*
   Change support special prices
   If any price level has a price greater than the special
   price lower it to the special price
   */
   if (true == $this->hasSpecialPrice) {
  foreach($this->price_breaks as $price_break) {
    $price_break['products_price'] = min($price_break['products_price'], $this->specialPrice);
  }
   }
   //end changes to support special prices
 }

 function computePrice($qty, $nof_other_items_in_cart_same_cat = 0)
 {
   $qty = $this->adjustQty($qty);
   // Add the number of other items in the cart from the same category to see if a price break is reached
   $qty += $nof_other_items_in_cart_same_cat;
   // Compute base price, taking into account the possibility of a special
   $price = (true == $this->hasSpecialPrice) ? $this->specialPrice : $this->thePrice;
   foreach($this->price_breaks as $price_break) {
  if($qty >= $price_break['products_qty']) {
    $price = $price_break['products_price'];
  }
   }
   return $price;
 }
 function adjustQty($qty, $qtyBlocks = NULL) {
   // Force QTY_BLOCKS granularity
   if(!tep_not_null($qtyBlocks))
   {
  $qtyBlocks = $this->getQtyBlocks();
   }

   if ($qty < 1)
  $qty = 1;
   if ($qtyBlocks >= 1)
   {
  if ($qty < $qtyBlocks)
    $qty = $qtyBlocks;
  if (($qty % $qtyBlocks) != 0)
    $qty += ($qtyBlocks - ($qty % $qtyBlocks));
   }
   return $qty;
 }

 function getQtyBlocks() {
   return $this->qtyBlocks;
 }
 function getPrice() {
   return $this->thePrice;
 }
 function getLowPrice() {
   return $this->lowPrice;
 }
 function getHiPrice() {
   return $this->hiPrice;
 }
 function hasSpecialPrice() {
   return $this->hasSpecialPrice;
 }
 function hasQuantityPrice() {
   return $this->hasQuantityPrice;
 }
 function getDiscountSaving($original_price, $discount_price) {
   $difference = $original_price - $discount_price;
   return round (($difference / $original_price) * 100) . '%';
 }
 function getPriceString($style='productPriceInBox') {
   global $currencies;
   // If you want to change the format of the price/quantity table
   // displayed on the product information page, here is where you do it.
   if(true == $this->hasQuantityPrice) {
  $lc_text = '<table border="0" cellspacing="0" cellpadding="0" class="infoBox" align="right">
		  <tr valign="top">
		  <td>
		  <table border="0" cellspacing="1" cellpadding="4" class="infobox">';
  $lc_text .= '<tr valign="top"><td width="120" class="infoBoxHeading">' . TEXT_ENTER_QUANTITY .'</td><td align="center" class="infoBoxHeading">1+'
		 . '</td>';
  foreach($this->price_breaks as $price_break) {
    $lc_text .= '<td align="center" width="50" class="infoBoxHeading">'
	  . $price_break['products_qty']
	  .'+ </td>';
  }
  $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_PRICE_PER_PIECE . '</td><td align="center" width="50" class="infoBoxContents">';
  if (true == $this->hasSpecialPrice) {
    $lc_text .= '<s>'
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</s>  <span class="productSpecialPrice">'
    . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
    . '</span> '
    .'</td>';
  } else {
    $lc_text .= ''
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</td>';
  }
  foreach($this->price_breaks as $price_break) {
    $lc_text .= '<td align="center" width="50" class="infoBoxContents">'
	  . $currencies->display_price($price_break['products_price'], tep_get_tax_rate($this->taxClass))
	  .'</td>';
  }
  $lc_text .= '</tr>';

  // Begin saving calculation
  $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_SAVINGS . '</td>';
  if (true == $this->hasSpecialPrice) {
    $lc_text .= '<td align="center" class="infoBoxContents">'
    . $this->getDiscountSaving($this->thePrice, $this->specialPrice)
    .'</td>';
  } else {
    $lc_text .= '<td align="center" class="infoBoxContents">- </td>';
  }
  foreach($this->price_breaks as $price_break) {
    $lc_text .= '<td align="center" width="50" class="infoBoxContents">'
    . $this->getDiscountSaving($this->thePrice, $price_break['products_price'])
    .'</td>';
  }
  $lc_text .= '</tr></table></td></tr></table>';
   } else {
  if (true == $this->hasSpecialPrice) {
    $lc_text = ' <s>'
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</s>  <span class="productSpecialPrice">'
    . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
    . '</span> ';
  } else {
    $lc_text = ' '
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . ' ';
  }
   }
   return $lc_text;
 }
 function getPriceStringShort() {
   global $currencies;
   if(true == $this->hasQuantityPrice) {
 $lc_text = ' <big>' . TEXT_PRICE_BREAKS . ' '
 . $currencies->display_price($this->lowPrice, tep_get_tax_rate($this->taxClass))
 . ' </big><br><br><br>';
   } else {
  if (true == $this->hasSpecialPrice) {
    $lc_text = ' <big><s>'
   . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
   . '</s>  <br><span class="productSpecialPrice">' . TEXT_ON_SALE . ' '
    . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
   . '</big></span> <br><br><br>';
  } else {
   $lc_text = ' <big>'
   . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
   . ' </big><br><br><br>';
  }
   }
   return $lc_text;
 }
/* Old (original formatting)
 function getPriceString($style='"productPriceInBox"') {
   global $currencies;
   if (true == $this->hasSpecialPrice) {
  $lc_text = '<table align="top" border="1" cellspacing="0" cellpadding="0">';
  $lc_text .= '<tr><td align="center" class=' . $style. ' colspan="2">';
  $lc_text .= ' <s>'
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</s>  <span class="productSpecialPrice">'
    . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
    . '</span> '
    .'</td></tr>';
   }
   else
   {
  $lc_text = '<table align="top" border="1" cellspacing="0" cellpadding="0">';
  $lc_text .= '<tr><td align="center" class=' . $style. ' colspan="2">'
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</td></tr>';
   }

   // If you want to change the format of the price/quantity table
   // displayed on the product information page, here is where you do it.
   if(true == $this->hasQuantityPrice) {
  foreach($this->price_breaks as $price_break) {
    $lc_text .= '<tr><td class='.$style.'>'
	  . $price_break['products_qty']
	  .'+ </td><td class='.$style.'>'
	  . $currencies->display_price($price_break['products_price'], tep_get_tax_rate($this->taxClass))
	  .'</td></tr>';
  }
  $lc_text .= '</table>';
   } else {
  if (true == $this->hasSpecialPrice) {
    $lc_text = ' <s>'
	  . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
	  . '</s>  <span class="productSpecialPrice">'
	  . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
	  . '</span> ';
  } else {
    $lc_text = ' '
	  . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
	  . ' ';
  }
   }
   return $lc_text;
 }
 function getPriceStringShort() {
   global $currencies;
   if (true == $this->hasSpecialPrice) {
  $lc_text = ' <s>'
    . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
    . '</s>  <span class="productSpecialPrice">'
    . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass))
    . '</span> ';
   } else {
  if(true == $this->hasQuantityPrice) {
    $lc_text = ' '
	  . $currencies->display_price($this->lowPrice, tep_get_tax_rate($this->taxClass))
	  . ' - '
	  . $currencies->display_price($this->hiPrice, tep_get_tax_rate($this->taxClass))
	  . ' ';
  } else {
    $lc_text = ' '
	  . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass))
	  . ' ';
  }
   }
   return $lc_text;
 }
 */
}
?>

 

I'm not entirely sure what it is I am looking at. Can you help?

Sigma Matt

Sigma Matt

Posted
  • Author
Posted

the reason it was acting up for the quantities was something I could fix from the admin area, the big thing I gotta figure out is how to not make it go 1+,100+, etc., but just make it start at 100+.

Sigma Matt

Sigma Matt

Posted
  • Author
Posted

Not to sound rude, but what exactly would I need to say to get it to not show that first block of information? I am relatively new to this and am not sure which item(s) would need to be removed or not to get this to work.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...