[Решено] Вывод товаров из подкатегорий в родительскую категорию V1.0.15 V1.1.3 - страница 9 - [VM1] Решенные вопросы

$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;

function getCatergoryChildsList( $clist, $catid ){
	$res_list = array( $catid );
	$search_childs = true;
	while( $search_childs ){
		$search_childs = false;
		foreach( $clist as $c_catid => $val ){
			if( in_array( $val['category_parent_id'], $res_list ) ){
				$res_list[] = $c_catid;
				unset( $clist[ $c_catid ] );
				$search_childs = true;
			}
		}
	}
	return $res_list;
}
$category_childs = '';
	if ( $category_id && $ps_product_category->has_childs($category_id) ){
		$category_childs = getCatergoryChildsList( $ps_product_category->getCategoryTreeArray(), $category_id );
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN (".$category_id.",".implode(',',$category_childs).")";
	} else {
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
}

$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;

if (!function_exists('getCatergoryChildsList')) {

}

	if ($category_id1) $where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN(".$category_id1.")";
	else $where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$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(!empty( $category_childs ))
			$where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN (".$category_id.",".implode(',',$category_childs).")";
		else
			$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=".$category_id;
	}

$products[$i]['product_name'] = shopMakeHtmlSafe( $product_name );

$products[$i]['product_category'] = $db_browse->f("category_id");
$products[$i]['product_category_name'] = $ps_product_category->get_name( $db_browse->f("product_id") );

if(!empty( $category_childs )) $where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN (".$category_id.",".implode(',',$category_childs).")";

if(!empty( $category_childs )){
	$where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN (".$category_id.",".implode(',',$category_childs).")";
	$orderbyField = '`#__{vm}_category`.`category_id`,' . $orderbyField;
}

foreach( $products as $product ) {

$tmp_cur_subcategory = '';

/*** Now echo the filled cell ***/

if( $tmp_cur_subcategory != $product['product_category'] ){
	$row++;
	echo "\n</div><br class=\"clr\" />";
	echo '<h3>'.$product['product_category_name'].'</h3>';
	$tmp_cur_subcategory = $product['product_category'];
}

Product Listing wich a table