Displaying all products under sub-categories too

[aurax]

any patch for 1.1?

i am getting:

Code: [Select]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/yifahaz1/public_html/shop/administrator/components/com_virtuemart/html/shop_browse_queries.php on line 25

[Colosimo]

i need the same for VM 1.1.2, that code is not working.
anyone?

c.

[Creb]

Helo again, I change this to VM 1.1.3 and Joomla 1.5.8
In administrator/components/com_virtuemart/classes/ps_product_category.php
add the "untreeCat" function at the end of the class, thanx haselnuss

Code: [Select]

/*
* Returns an array of the categories ids recursively for a given category
* untreeCat copy lashae (virtuemart forum http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=20837.0)
* @param int $kat
* @param int $container
* rewritten by haselnuss (to use ps_DB class and store the function in ps_product_category.php)
*/
function untreeCat($kat, &$container) {
$db = new ps_DB;
$q = "SELECT category_child_id FROM #__{vm}_category_xref WHERE category_parent_id='$kat'";
$db->query($q);
// if it is a leaf (no data underneath it) then return
if (!$db->num_rows()) {
return;
}
//else append the result, and recurse the function (so to speak)
else
{
while($db->next_record()) {
  $container[] = $db->f("category_child_id");
  $kat = $db->f("category_child_id");
  $this->untreeCat($kat, $container);
}
}
}

and in administrator/components/com_virtuemart/html/shop_browse_queries.php I add detect list categories page. I dont know, why can't detect untree function on product details page.
About line 63 change:

Code: [Select]

// Filter Products by Category
if( $category_id ) {
if( !empty( $search_this_category ) && (!empty( $keyword ) || !empty( $manufacturer_id ) )) {
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
} elseif( empty( $keyword ) && empty( $manufacturer_id )) {
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
}
}

to:

Code: [Select]

// Filter Products by Category
/*
* Returns an array of the categories ids recursively for a given category
* untreeCat copy lashae (virtuemart forum http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=20837.0)
* rewritten by Creb (to use shop.browse page detection)
*/
if( $category_id ) {
if( !empty( $search_this_category ) && (!empty( $keyword ) || !empty( $manufacturer_id ) )) {
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
} elseif( empty( $keyword ) && empty( $manufacturer_id )) {

if ($_GET["page"]=="shop.browse") {
  //$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
$kategoriListesi = array();
$ps_product_category->untreeCat($category_id, $kategoriListesi);
$qkat = " `#__{vm}_product_category_xref`.`category_id` IN(".$category_id . ",";
foreach ($kategoriListesi as $kat)
{
$qkat .= $kat . ',';
}
$qkat .= ")";

$qkat = str_replace(',)', ')', $qkat);
$where_clause[] = $qkat;
} else {
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
}

}
}

If we need hide category thumbnails comment line 106 in administrator/components/com_virtuemart/html/shop.browse.php

Code: [Select]

//$navigation_childlist = $tpl->fetch( 'common/categoryChildlist.tpl.php');
Hope this helps someone.

regards
Creb

[sizex]

wow thanks so much creb just what I was after.  thats great!

[jean-mouloud]

Thanx a lot Creb!
It was very helpful for me!
Thnx thnx thnx a lot! 

[CocoDen]

Hello! I don't understand how I may to make structure on one page (main page):

category1 (title):
- proguct1;
- product2;
- product3;

category2 (title):
- proguct4;
- product5;
- product6;

category3 (title):
- proguct7;
- product8;
- product9...

Which don't need click to link of categories or without categories.
Example: http://artflowers-sib.ru/

Please describe me this more in detail. I'm not professional.

I use Joomla 1.5.10 and VM 1.1.3

[CocoDen]

Nobody don't know?

[baggiesmad]

Nobody don't know?

did you find a way of sorting this?

[afterimage]

Hi all, I'm getting the following error, any idea what I'm doing wrong?

Code: [Select]

Fatal error: Call to undefined method ps_product_category::untreeCat() in (home directory)/administrator/components/com_virtuemart/html/shop_browse_queries.php  on line 148
I'm using 1.5.18 with 1.1.4

Thanks in advance.

[Creb]

Can You change administrator/components/com_virtuemart/classes/ps_product_category.php ?
You myst add function untreeCat after function sort_alphabetically.
End of teh class vm_ps_product_category.
Work fine for me.
Creb

[leonk]

I am using Virtuemart 1.1.4 with Joomla 1.5.18.
What is the code change in administrator/components/com_virtuemart/html/shop_browse.php?
I was unable to find
// Filter Products by Category

Thanks
Leon

[Creb]

sorry, this is my comment
You must looking for

Code: [Select]

if( !empty( $search_this_category ) && (!empty( $keyword ) || !empty( $manufacturer_id ) )) {
Creb

[leonk]

Thank you, Creb, I managed to change and add the codes in the 2 files

But the shop does not show what I expect to see:
Example:
Categorie A
Sub-categorie A1  2 articles
Sub-categorie A2  3 articles
Sub-categorie A3  5 articles

When I choose Categorie A in the tree I would like to see 10 articles (sorted in Sub-categories) and I see only the links with Sub-categorie A1, Sub-categorie A2 and Sub-categorie A2 and no articles.
When I choose a Sub-categorie in the tree, e.g. A3 I see the correct (5) articles.

How do I proceed?
Thanks
Leon

[Creb]

you have link to shop?
Creb

[leonk]

Think I managed it by through a walkaround: I linked a product to both a category and a sub-category