JoomShopping - категории и товары - JoomShopping

<?php include(dirname(__FILE__)."/products.php");?>

<div class="jshop">


    
    <div class="jshop_list_category">
	<?php if (count($this->categories)){ ?>

        <?php foreach($this->categories as $k=>$category){?>
            <?php if ($k%$this->count_category_to_row==0) print "<tr>"; ?>
            <div class = "jshop_categ" style="width:<?php print (100/$this->count_category_to_row)?>%">
             
             
                <div class="image">
                    <a href = "<?php print $category->category_link;?>"><img class="jshop_img" src="<?php print $this->image_category_path;?>/<?php if ($category->category_image) print $category->category_image; else print $this->noimage;?>" alt="<?php print htmlspecialchars($category->name)?>" title="<?php print htmlspecialchars($category->name)?>" /></a>
                </div>
              
                  <h3> <a class = "product_link" href = "<?php print $category->category_link?>"><?php print $category->name?></a></h3>
                   <p class = "category_short_description"><?php print $category->short_description?></p>
             
             </div>
            
        <?php } ?>
        
    
    <?php }?>
    </div>
    <?php include(dirname(__FILE__)."/products.php");?>
	<h1><?php print $this->category->name?></h1>
    <?php print $this->category->description?>
</div>

<?php if ($this->display_list_products){?>
<table style="height: 100%; ; width: 100%;" border="0">
<tbody>
<tr>
<td>
<div class="jshop_list_product">    
<?php
    include(dirname(__FILE__)."/../".$this->template_block_form_filter);
    if (count($this->rows)){
        include(dirname(__FILE__)."/../".$this->template_block_list_product);
    }
    if ($this->display_pagination){
        include(dirname(__FILE__)."/../".$this->template_block_pagination);
    }
?>
</div>
 </td>
</tr>
</tbody>
</table>
<?php }?>

$query = "SELECT $adv_result FROM `#__jshopping_products` AS prod

LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)

$adv_from

WHERE pr_cat.category_id = '".$this->_db->getEscaped($this->category_id)."' AND prod.product_publish = '1' ".$adv_query." ".$order_query;

//\

$SubCat='';

foreach ($this->getSubCategories($this->_db->getEscaped($this->category_id), 'name', 'asc', 1) as $SubC) {

$SubCat.="'".$SubC->category_id."', ";

}

if ($SubCat!='') $SubCat=" IN (".$SubCat."'".$this->_db->getEscaped($this->category_id)."' ) ";

else $SubCat=" = '".$this->_db->getEscaped($this->category_id)."' ";



$query = "SELECT $adv_result FROM `#__jshopping_products` AS prod

LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)

$adv_from

WHERE pr_cat.category_id ".$SubCat." AND prod.product_publish = '1' ".$adv_query." ".$order_query;

//\