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

osCommerce

The e-commerce.

New Demo
Our Partners

attributes in price list code

Guest

By Guest
in General Support

Recommended Posts

Guest

Guest

Posted
Posted

ok what i am wondering is can anyone code so that the products attributes of each product are also included on the price list (html) contribution.

 

***attributes to be shown just under name of product***

 

Code is as follows for the file:

 

<?php

// Begin configuration

define('TITLE_PRICE_LIST', 'Price List'); // This is the title for your price page
define('DATE_PRICE_LIST', '- jS M, Y'); // date format (empty - none, M - month, jS - day of month, Y - year; see www.php.net/date)
define('PRINT_VIEW', 'Printable View'); // text for link to printable view 
define('FULL_VIEW', 'Full View'); // text for link to normal view
define('TAX_INCREASE', 0); // 0 - No increase, 1 - Add 1%, 5 - Add 5%, Any number - add number%
define('NO_PRICE', 'Contact Us'); // show when product has no price or zero price (blank -   , or e.g. Call for Price)
define('SHOW_QUANTITY',false); // true - show, false - hide quantity
define('QUANTITY_TEXT', 'Qty.'); // This is the heading for quantity column
define('SHOW_MARKED_OUT_STOCK',false); // show marked out of stock (true - show, false - hide)
define('SHOW_MODEL',true); // true - show model, false - hide model
define('WIDTH_PRICE_LIST', '750'); // width of price list in pixels (0 - tight, 1000 - loose)
define('INDENT_PRICE_LIST', '20'); // width of identation subcategories in pixels (0 - none, 30 - wide)
define('INDENT_PRICE_LIST_COLOR', 'b6b7cb'); // colour of the indentation 

// End configuration

require('includes/application_top.php');
// the following cPath references come from application_top.php
$category_depth = 'top';
if (isset($cPath) && tep_not_null($cPath)) {
	$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
	$cateqories_products = tep_db_fetch_array($categories_products_query);
	if ($cateqories_products['total'] > 0) {
		$category_depth = 'products'; // display products
	} else {
		$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
		$category_parent = tep_db_fetch_array($category_parent_query);
		if ($category_parent['total'] > 0) {
			$category_depth = 'nested'; // navigate through the categories
		} else {
			$category_depth = 'products'; // category has no products, but display the 'no products' message
		}
	}
}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
$breadcrumb->add(TITLE_PRICE_LIST, tep_href_link("price_list.php", '', 'SSL')); 
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
td.priceListWidth{
 width:<?php echo WIDTH_PRICE_LIST; ?>px;
} 
td.priceListIndent {
 background-color:<?php echo INDENT_PRICE_LIST_COLOR; ?>;
 width:<?php echo INDENT_PRICE_LIST; ?>;
} 
--></style>

</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<tr>
 <td width="100%" align="center" valign="top">    <table width="998" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
       <tr>

       <td align="center" valign="top">          <table width="100%" border="0" cellpadding="0" cellspacing="0">
         <tr>
           <td align="center"><table border="0" cellspacing="0" cellpadding="2">
             <tr>
               <td class="pageHeading"><?php echo TITLE_PRICE_LIST ?> <?php echo date(DATE_PRICE_LIST); ?><sup>
                 <?php  // print function and edit remove by willross
if ($print=="yes"){?>
                 <font style="font-size:10px"><a href="price_list.php">[<?php echo FULL_VIEW ?>]</a></font>
                 <?php } else {?>
                 <font style="font-size:10px"><a href="price_list.php?print=yes">[<?php echo PRINT_VIEW ?>]</a></font>
                 <?php }?>
               </sup> </td>
             </tr>
             <tr>
               <td class="pageHeading"><?
// groups have products?
function check_products($id_group){
$products_price_query = tep_db_query("select products_to_categories.products_id FROM products_to_categories where products_to_categories.categories_id = ".$id_group." LIMIT 0,1");
if($products_price = tep_db_fetch_array($products_price_query)){
	return true;	
}
return false;
}

// list products determined group 
function get_products($id_group){
global $currencies;
	$query = "";
if(!SHOW_MARKED_OUT_STOCK){
	$query = " and products.products_status = 1";
}
$products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_quantity <> 0".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group." ORDER BY products_description.products_name");
	$x=0;
while ($products_price = tep_db_fetch_array($products_price_query)){
	$cell = tep_get_products_special_price($products_price['products_id']);
	if($cell == 0)
		$cell = $products_price['products_price'];
	if($x==1) {
		$col = "#F8F8F9";
		$x = 0;	
	}else{
		$col = "#FFFFFF";
		$x++;
	}
	$quantity = "";
	$model = "";
	if(SHOW_QUANTITY) 
		$quantity = "<td  align=\"right\" class=\"productListing-data\"> (".$products_price['products_quantity'].")</td>";
	if(SHOW_MODEL)
		$model = "<td align=\"LEFT\" class=\"productListing-data\">".$products_price['products_model']."</td>";
	print "<tr bgcolor=\"".$col."\"><td class=\"productListing-data\"><table align=\"LEFT\" cellpadding=\"1\" cellspacing=\"0\" ><tr><td  class=\"priceListIndent\" ></td><td class=\"productListing-data\" > </td></tr></table></td>".$model."<td class=\"productListing-data\" ><a href=" . tep_href_link( FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "> ".$products_price['products_name']."</td><td align=\"right\" class=\"productListing-data\"> " . (($products_price['products_price'] > 0) ? $currencies->display_price($cell,TAX_INCREASE) : NO_PRICE ) ."</td>".$quantity."</tr>";
}
}

// get all groups
function get_group($id_parent,$position){
	$qty_text = "";
if(SHOW_QUANTITY) {
	$qty_text = "".QUANTITY_TEXT."";
}else{
	$qty_text = " ";
}
$groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." ORDER BY categories_description.categories_name");
while ($groups_price = tep_db_fetch_array($groups_price_query)){
	$str = "";
	for($i = 0; $i < $position; $i++){
		$str = $str . "<table align=\"LEFT\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td  class=\"priceListIndent\" ></td><td class=\"productListing-heading\" > </td></tr></table>";
	}
	$class = "productListing-heading";
	if($position == 0) {
		$class = "headerNavigation";
		print "<tr><td colspan=\"5\" class=\"priceListWidth\"><table align=\"right\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td class=\"productListing-data\">".$qty_text."</td></tr></table></td></tr>"; // dónnr? nndîer
	}
	if(check_products($groups_price['categories_id']) || $position == 0){
		print "<tr><td colspan=\"5\" class=\"".$class."\"><strong><font color=\"#FFFFFF\">".$str.$groups_price['categories_name']."</font></strong></td></tr>";
		get_products($groups_price['categories_id']);
	}
	get_group($groups_price['categories_id'],$position+1); // nëläótur? adóddr
}
}
?>
                   <table width="100%" border="0" cellspacing="1" cellpadding="0">
                     <?
 get_group(0,0);
?>
                     <tr>
                       <?php  // print function and edit remove by willross
if ($print=="yes"){?>
                       <!-- column_right disabled for print //-->
                       <?php } else {?>
                       <td colspan="5"> </td>
                     </tr>
                 </table></td>
             </tr>
           </table></td>
         </tr>
       </table>
         <!-- header_eof //-->
           <!-- body //-->
           </td>
	<!-- body_text //-->
 <!-- body_text_eof //-->
     </tr>

</table>        <!-- body_eof //-->

<?php }?>
 <br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

this is from the price list (html) contribution.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

ok so i have managed to code so it now takes into account tax if applicable which i will update on the contribution but can anyone help with the attributes???

 

I have tried and failed to get this right. if someone knows code it would only take a minute or so from what i can see.

 

Just a matter of gettin the order correct.

 

please :)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

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