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

// Filter Products by Category
$where_clause[] = "`#__{vm}_product_category_xref`.`product_id`=`#__{vm}_product`.`product_id`";
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=`#__{vm}_category`.`category_id`";

<!-- PAGE NAVIGATION AT THE TOP -->
    <br/>
    <div style="text-align:center;"><?php 
    	$pagenav->writePagesLinks( $search_string );
    	echo '<br />';
    	$pagenav->writePagesCounter();
      ?>
    </div>

	<?php 
	if( $show_limitbox ) { ?>
		<br/><br/>
		<form action="<?php echo $search_string ?>" method="post">
			<?php echo $VM_LANG->_('PN_DISPLAY_NR')?>&nbsp;&nbsp;
			<?php $pagenav->writeLimitBox( $search_string ); ?>
			
			<noscript><input class="button" type="submit" value="<?php echo $VM_LANG->_('PHPSHOP_SUBMIT')?>" /></noscript>
		
		</form>

$count_name = "COUNT(DISTINCT `#__{vm}_product`.`product_sku`) as num_rows";

if(!empty( $category_childs )){
$count_name = "COUNT(ALL `#__{vm}_product`.`product_sku`) as num_rows";
}else{
$count_name = "COUNT(DISTINCT `#__{vm}_product`.`product_sku`) as num_rows";
}

$list  = "SELECT DISTINCT $fieldnames FROM ($table_names) ";

if(!empty( $category_childs )){
$list  = "SELECT ALL $fieldnames FROM ($table_names) ";
}else{
$list  = "SELECT DISTINCT $fieldnames FROM ($table_names) ";
}

$q .= "\n GROUP BY `#__{vm}_product`.`product_sku` ";

if(empty( $category_childs )){
$q .= "\n GROUP BY `#__{vm}_product`.`product_sku` ";
}

	<?php 
	if( $show_limitbox ) { ?>
		<br/><br/>
		<form action="<?php echo $search_string ?>" method="post">
			<?php echo $VM_LANG->_('PN_DISPLAY_NR')?>&nbsp;&nbsp;
			<?php $pagenav->writeLimitBox( $search_string ); ?>
			
			<noscript><input class="button" type="submit" value="<?php echo $VM_LANG->_('PHPSHOP_SUBMIT')?>" /></noscript>
		
		</form>
	<?php
	} ?>

<?php if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );
mm_showMyFileName(__FILE__); ?>

<?php echo $browsepage_header // The heading, the category description ?>
<?php echo $parameter_form // The Parameter search form ?>
<?php echo $orderby_form // The sort-by, order-by form PLUS top page navigation ?>


<?php

$data =array(); // Holds the rows of products
$i = 1; $row = 0; // Counters

// Table header


if ($category_id == 10 || $category_id == 1 || $category_id == 9 ) {

// Table header
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_NAME').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_SKU').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('IGROK_VES').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('IGROK_AMPLUA').'</center>';

// Creates a new HTML_Table object that will help us
// to build a table holding all the products
$table =& new HTML_Table('width="100%"');

$table->addRow( $tableheader, 'class="sectiontableheader"', 'th', true );

    foreach( $products as $product ) {
		
		foreach( $product as $attr => $val ) {
			// Using this we make all the variables available in the template
			// translated example: $this->set( 'product_name', $product_name );
			$this->set( $attr, $val );
		}
		
		$data[$row][] = '<a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'.$product['product_name'].'</a>';
		$data[$row][] = '<center>'.$product['product_sku'].'</center>';
		$data[$row][] = '<center>'.$product['product_ves'].'</center>';
		$data[$row][] = '<center>'.$product['product_amplua'].'</center>';

		$row++;
    }
}

elseif ($category_id == 8 ) {

// Table header
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_NAME').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_SKU').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('IGROK_VES').'</center>';


// Creates a new HTML_Table object that will help us
// to build a table holding all the products
$table =& new HTML_Table('width="100%"');

$table->addRow( $tableheader, 'class="sectiontableheader"', 'th', true );

    foreach( $products as $product ) {
		
		foreach( $product as $attr => $val ) {
			// Using this we make all the variables available in the template
			// translated example: $this->set( 'product_name', $product_name );
			$this->set( $attr, $val );
		}
		
		$data[$row][] = '<a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'.$product['product_name'].'</a>';
		$data[$row][] = '<center>'.$product['product_sku'].'</center>';
		$data[$row][] = '<center>'.$product['product_ves'].'</center>';


		$row++;
    }
}

else  {

// Table header
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_NAME').'</center>';
$tableheader[] = '<center>'.$VM_LANG->_('PHPSHOP_CART_SKU').'</center>';

// Creates a new HTML_Table object that will help us
// to build a table holding all the products
$table =& new HTML_Table('width="100%"');

$table->addRow( $tableheader, 'class="sectiontableheader"', 'th', true );

    foreach( $products as $product ) {
		
		foreach( $product as $attr => $val ) {
			// Using this we make all the variables available in the template
			// translated example: $this->set( 'product_name', $product_name );
			$this->set( $attr, $val );
		}
		
		$data[$row][] = '<a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'.$product['product_name'].'</a>';
		$data[$row][] = '<center>'.$product['product_sku'].'</center>';

		$row++;
    }
}


// Loop through each row and build the table
foreach($data as $key => $value) {
	
	$table->addRow( $data[$key], 'class="sectiontableentry'.$i.'"', 'td', true );
	$i = $i == 1 ? 2 : 1;
}
// Display the table
echo $table->toHtml();

?>

<br class="clr" /><br />
<?php echo $browsepage_footer ?>
<?php 
// Show Featured Products
if( $this->get_cfg( 'showFeatured', 1 )) {
    /* featuredproducts(random, no_of_products,category_based) no_of_products 0 = all else numeric amount
    edit featuredproduct.tpl.php to edit layout */
    echo $ps_product->featuredProducts(true,10,true);
} ?>
<?php echo $recent_products ?>

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`.`product_id`=`#__{vm}_product`.`product_id`";

$childs = $ps_product_category->get_child_list($category_id);
$where_clause[] = "`#__{vm}_product_category_xref`.`category_id` IN (".$category_id.",".implode(',',$childs).")";