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

osCommerce

The e-commerce.

New Demo
Our Partners

Contribution 2795 - Product Listing

Susan Carembeu

By Susan Carembeu
in General Add-Ons Support

 Share

Recommended Posts

Susan Carembeu

Susan Carembeu

Posted
Posted

Hi, Claudio and folks!

 

I need your help! This contribution is pretty good, i love it but...

 

If i have subcategories and parent categories it shows me just the sub categories.

 

F. ex.:

 

Mainboards (parent)

- AMD (sub 1)

- Asus (sub 2)

- MSI (sub 2)

- Intel (sub 1)

- Asus (sub 2)

- Abit (sub 2)

 

It shows me:

AMD (the sub1 category) - Asus (the manufacturer)

 

I tried to achieve something like this:

 

Mainboards - AMD - Asus

**table product list

 

Mainboards - AMD - MSI

**table product list

 

etc.

 

but I could not... :(

 

Would you be so good and help me out?

Please...

 

Susan

Link to comment
Share on other sites
Susan Carembeu

Susan Carembeu

Posted
  • Author
Posted

Hi!

OK. Cuz nobody answered til now I try to explain my problem again...

 

Here is the code of "report-txt.php" file:

<html>
<head>
<style type="text/css">
table.report {
 border: 1px solid Black;
 page-break-after: auto;
 page: auto;
 border-collapse: collapse; 
 font-family: Arial, Verdana, sans-serif;
 font-size: 12px;
 padding: 6px;
}
h2.report {
 font-family: Arial, Verdana, sans-serif;
 font-size: 16px;
}
td.price {
 font-family: Arial, Verdana, sans-serif;
 font-size: 14px;
 text-align: right;
 border: 1px solid;
 padding: 3px;
}
td.report {
 border: 1px solid;
 padding: 3px;
}
</style>
</head>
<body>


<?php
//	$records = tep_db_query("SELECT * FROM products_to_categories ORDER BY categories_id");
$qry = "select distinct c.categories_name, pd.products_name, pd.products_description, p.products_price, p.products_image, m.manufacturers_name" . 
    	 " from " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m" . 
    	 " where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and pc.categories_id = c.categories_id AND c.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "'" . 
    	 " order by trim(c.categories_name), m.manufacturers_name, trim(pd.products_name) asc";
   $records = tep_db_query($qry);
$num_records = tep_db_num_rows($records);
 
   ?>
 <table width=600>
	 <TR>
	 <td align="center">
   <p> </p>
   <p> </p>
   <h2><b><i>Price List: </i></b></h2> 
   <p><?   echo $num_records; ?> products
 <?
 $i = 0;              
 $table = mysql_fetch_array($records);
 while ($table) {
	 $category1 = $table['categories_name'];
	 $manufacturer1 = $table['manufacturers_name'];
	 
 ?>
 
	 
 <h2 class="report" align="left"> <? echo $category1 . ": " . $manufacturer1; ?> </h2>
   <table class="report">
   <TR>
  	 <TH width=500 align="left" class="report">Product</TH>
  	 <th width=80 align="left" class="report">Price</th>
   </TR>
 <?
	 do {
   $category = $table['categories_name'];
   $manufacturer = $table['manufacturers_name'];
   $product = $table['products_name'];
   $price = $table['products_price'];
   $description = $table['products_description'];
   if ($category != $category1 || $manufacturer != $manufacturer1) {
  	 ?> </table> <?
       break;
   }
   
   if (!($i%2)) {$color = "BGCOLOR = #FFFF99";}
   else { $color = "BGCOLOR = #FFFFFF";}         	 
   ?>  <tr>
     <td class="report">
    	 <? echo $product;?>
     </td>
     <td class="price">
    	 <? echo number_format ($price,2,',','.');?> 
     </td>
  	 </tr>
   <?	
   $i++;
	 }	while ($table = mysql_fetch_array($records));
 }
?>
	 </td>
	 </tr>
 </table>	
 
</body>
</html>

 

If i use this code on a shop where are just main categories and products in them its ok. But when Ive got parent cat. - sub categories - products the $category1 returns the sub category-s name. And I need to change this code to show the path.

 

For example:

 

Motherboards (this is the top category)

Intel (this is under motherb.)

AMD (this is under motherb.)

 

ASUS (this is under motherb./Intel)

Abit (this is under motherb./Intel)

 

ASUS(this is under motherb./AMD)

MSI(this is under motherb./Intel)

 

 

So when i run the php file Ive got for the category1 = Intel (then products) and AMD (then products) and if I have lot of categories with subcateg. its quite confusing wher is what.

 

I need something like:

 

Motherboards - AMD - ASUS

//* product list of ASUS motherboards, with AMD socket

 

Motherboards - AMD - Abit

//* product list of Abit motherboards, with AMD socket

 

Motherboards - Intel - ASUS

//* product list of ASUS motherboards, with Intel socket

 

etc.

 

Please help me!

Link to comment
Share on other sites
Susan Carembeu

Susan Carembeu

Posted
  • Author
Posted
I found a nice contribution it called Box_categories_pro_V1.1  just do a search for it.

 

Thank you,

Hmmm... Im not sure if i need that. Im trying to make a price list, or product list. The report-txt.php file is pretty good. Its almost perfect for me, just i need to change it a little bit - to show the parent categories.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

You need to add parent_id and TABLE_CATEGORIES to your query, then use something like this:

 

 <?
$i = 0;              
$table = mysql_fetch_array($records);
while ($table) {
 $parent_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd. categories_id = c.categories_id where c.categories_id = '"  . $table['parent_id'] . "'");
 $parent_result = tep_db_fetch_array($parent_query);
 $parent = $parent_result['categories_name'];
 
 $category1 = $table['categories_name'];
 $manufacturer1 = $table['manufacturers_name'];
 
?>

 

You can echo the result with $parent :D

 

Matti

Link to comment
Share on other sites
Susan Carembeu

Susan Carembeu

Posted
  • Author
Posted
You need to add parent_id and TABLE_CATEGORIES to your query, then use something like this:

 

 <?
$i = 0; ? ? ? ? ? ? ?
$table = mysql_fetch_array($records);
while ($table) {
?$parent_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd. categories_id = c.categories_id where c.categories_id = '" ?. $table['parent_id'] . "'");
?$parent_result = tep_db_fetch_array($parent_query);
?$parent = $parent_result['categories_name'];
?
?$category1 = $table['categories_name'];
?$manufacturer1 = $table['manufacturers_name'];
?
?>

 

You can echo the result with $parent  :D

 

Matti

 

Thanx! Ive almost got it! I was looking for some codes like yours and Ive found a price list contribution - heres the code:

 

<?php

define('TITLE_PRICE', 'Title');

define('SHOW_QUANTITY',false); // true - show, false - hide quantity
define('SHOW_MARKED_OUT_STOCK',false); // show marked out of stock (true - show, false - hide)
define('TAX_INCREASE', 0); // 0 - No increase, 1 - Add 1%, 5 - Add 5%, Any number - add number%
define('SHOW_MODEL',true); // true - show model, false - hide model

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
	 }
 }
}
?>

<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<title><?php echo TITLE; ?> - Cenn?k <?php echo date("Y"); ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">


	 <table border="0" cellspacing="0" cellpadding="2">
	 
     
     <tr>
       <td>  
<?
// group 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);
$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 width=\"100\" align=\"right\" class=\"productListing-data\">(".$products_price['products_quantity'].")</td>";
 if(SHOW_MODEL)
	 $model = "<td width=\"100\" align=\"right\" class=\"productListing-data\">[".$products_price['products_model']."]</td>";
 print "<tr bgcolor=\"".$col."\">".$model."<td width=\"1000\" class=\"productListing-data\">        <a href=\"" . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "\">".$products_price['products_name']."</a></td><td width=\"150\" align=\"right\" class=\"productListing-data\">".$currencies->display_price($cell,TAX_INCREASE)."</td></tr>";
}
}

// get all groups
function get_group($id_parent,$position){
$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.sort_order");
while ($groups_price = tep_db_fetch_array($groups_price_query)){
 $str = "";
 for($i = 0; $i < $position; $i++){
	 $str = $str . "        ";
 }
 $class = "productListing-heading";
 if($position == 0) {
	 $class = "headerNavigation";
	 print "<tr><td colspan=\"4\" width=\"1000\" class=\"productListing-data\"> </td></tr>";
 }
 if(check_products($groups_price['categories_id']) || $position == 0){
	 print "<tr><td colspan=\"4\" width=\"1000\" class=\"".$class."\"><strong><font color=\"#000000\">".$str.$groups_price['categories_name']."</font></strong></td></tr>";
	 get_products($groups_price['categories_id']);
 }
 get_group($groups_price['categories_id'],$position+1);
}
}
?>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<?

 get_group(0,0);
?>

</table>
    	 
</td>

     </tr>
	 </table>

 

I was searching for smthg like this!

Just 2 things to change and im the most happiest person at the osc forum! :D

 

So what should I change here to list the products based not on their ID number but on their letters? (im not native so forgive my english pls!) But I hope you will know what I mean!

 

Snd. thing is to print the products description!

I learned that its in the:

$products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_ etc..)

 

And that i have to print the products_description. But in this case its declared in a way which I do not understand... Like products_description.products_name - what? Everywere it was like p.products_name, pd.products_description and so on, but here it is pretty complicated for me...

 

Oh, yes - thank you Mr. Johnson!

Link to comment
Share on other sites
Guest

Guest

Posted
Posted (edited)

You already have the products description in the first code you posted - to display it:

 

<?php echo $description; ?>

 

:D

 

Matti

Edited by Johnson
Link to comment
Share on other sites
Guest

Guest

Posted
Posted (edited)

This works for me :D

 

<?php
/*
?$Id: report.php Exp $

?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

?Copyright (c) 2003 osCommerce
?
?Suomedia - Dynamic Content Management
?http://suomedia.com
?
?Copyright (c) 2005 Suomedia
?

?Released under the GNU General Public License
*/
?require('includes/application_top.php');
?>
<html>
<head>
<style type="text/css">
table.report {
border: 1px solid Black;
page-break-after: auto;
page: auto;
border-collapse: collapse; 
font-family: Arial, Verdana, sans-serif;
font-size: 12px;
padding: 6px;
}
h2.report {
font-family: Arial, Verdana, sans-serif;
font-size: 16px;
}
td.price {
font-family: Arial, Verdana, sans-serif;
font-size: 14px;
text-align: right;
border: 1px solid;
padding: 3px;
}
td.report {
border: 1px solid;
padding: 3px;
}
</style>
</head>
<body>


<?php
$qry = "select distinct c.categories_name, a.parent_id, pd.products_name, pd.products_description, p.products_price, p.products_image, m.manufacturers_name" . 
? ? ?" from " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_CATEGORIES . " a, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m" . 
? ? ?" where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and pc.categories_id = c.categories_id AND c.categories_id = a.categories_id AND c.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "'" . 
? ? ?" order by trim(c.categories_name), m.manufacturers_name, trim(pd.products_name) asc";
? $records = tep_db_query($qry);
$num_records = tep_db_num_rows($records);

? ?>
<table width=600>
?<TR>
?<td align="center">
? <p> </p>
? <p> </p>
? <h2><b><i>Price List: </i></b></h2> 
? <p><? ? echo $num_records; ?> products
<?
$i = 0; ? ? ? ? ? ? ?
$table = mysql_fetch_array($records);
while ($table) {
?$parent_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd. categories_id = c.categories_id where c.categories_id = '" ?. $table['parent_id'] . "'");
?$parent_result = tep_db_fetch_array($parent_query);
?$parent = $parent_result['categories_name'];
?
?$category1 = $table['categories_name'];
?$manufacturer1 = $table['manufacturers_name'];
?
?>

?
<h2 class="report" align="left"> <? echo $parent . ": " . $category1 . ": " . $manufacturer1; ?> </h2>
? <table class="report">
? <TR>
? ?<TH width=500 align="left" class="report">Product</TH>
? ?<th width=80 align="left" class="report">Price</th>
? </TR>
<?
?do {
? $category = $table['categories_name'];
? $manufacturer = $table['manufacturers_name'];
? $product = $table['products_name'];
? $price = $table['products_price'];
? $description = $table['products_description'];
? if ($category != $category1 || $manufacturer != $manufacturer1) {
? ??> </table> <?
? ? ? break;
? }
? 
? if (!($i%2)) {$color = "BGCOLOR = #FFFF99";}
? else { $color = "BGCOLOR = #FFFFFF";} ? ? ? ? ? 
? ?> ?<tr>
? ? <td class="report">
? ? ?<? echo '<b>' . $product . '</b><br><br>' . $description;?>
? ? </td>
? ? <td class="price">
? ? ?<? echo number_format ($price,2,',','.');?> 
? ? </td>
? ?</tr>
? <? 
? $i++;
?} while ($table = mysql_fetch_array($records));
}
?>
?</td>
?</tr>
</table> 

</body>
</html>

Edited by Johnson
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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...