Сортировка товара по производителям (Virtuemart 1.1.x) - черновик - страница 2 - [VM1] Модификации и хаки

<?php $query = "SELECT distinct a.manufacturer_id,a.mf_name FROM #__{vm}_manufacturer AS a ";
if (!empty( $navigation_childlist ) ) {
$query .= ", #__{vm}_product_category_xref AS d, "
. " #__{vm}_product AS b, "
. " #__{vm}_product_mf_xref AS c, "
." #__{vm}_category_xref AS e "
. "WHERE e.category_parent_id='$category_id'"
. " AND d.category_id=e.category_child_id"
. " AND d.product_id = b.product_id "
. " AND b.product_id = c.product_id AND c.manufacturer_id = a.manufacturer_id ";
} elseif (!empty( $category_id )) {
$query .= ", #__{vm}_product_category_xref AS d, "
. " #__{vm}_product AS b, "
. " #__{vm}_product_mf_xref AS c "
. " WHERE d.category_id='$category_id'"
. " AND d.product_id = b.product_id "
. " AND b.product_id = c.product_id AND c.manufacturer_id = a.manufacturer_id ";
}
$query .= "ORDER BY mf_name ASC";

<select class="inputbox" name="manufacturer_id" onchange="order.submit()">
 <option value="product_list" ><?php echo $VM_LANG->_('PHPSHOP_SELECT')?></option> 
            <!--<option value=""><?php echo _CMN_SELECT ?></option>-->
        <?php  		$query  = "SELECT distinct a.manufacturer_id,a.mf_name FROM #__{vm}_manufacturer AS a ";
		if (!empty( $category_id ) ) {
		    $query .= ", #__{vm}_product_category_xref AS d, "
		    . " #__{vm}_product AS b, "
		    . " #__{vm}_product_mf_xref AS c "
		    . " WHERE d.category_id='$category_id'"
		    . " AND d.product_id = b.product_id "
		    . " AND b.product_id = c.product_id AND c.manufacturer_id = a.manufacturer_id ";
		}
		$query .= "ORDER BY mf_name ASC";
		$db = new ps_DB;
		$db->query( $query );

		$res = $db->record;
		
			foreach ($res as $manufacturer) { 
					$selected = '';
					if( @$_REQUEST['manufacturer_id'] == $manufacturer->manufacturer_id ) {
							$selected = 'selected="selected"';      
					}
					echo "<option value=\"".$manufacturer->manufacturer_id ."\" $selected>". $manufacturer->mf_name ."</option>\n";

			} 
        ?>
</select><br/><br/>

<select class="inputbox" name="manufacturer_id" onchange="order.submit()">
        <?php  		$query  = "SELECT distinct a.manufacturer_id,a.mf_name FROM #__{vm}_manufacturer AS a ";
		if (!empty( $category_id ) ) {
		    $query .= ", #__{vm}_product_category_xref AS d, "
		    . " #__{vm}_product AS b, "
		    . " #__{vm}_product_mf_xref AS c "
		    . " WHERE d.category_id='$category_id'"
		    . " AND d.product_id = b.product_id "
		    . " AND b.product_id = c.product_id AND c.manufacturer_id = a.manufacturer_id ";
		}
		$query .= "ORDER BY mf_name ASC";
		$db = new ps_DB;
		$db->query( $query );

		$res = $db->record;
		
			foreach ($res as $manufacturer) { 
					
					echo '<a href="index.php?DescOrderBy=ASC&manufacturer_id=' . $manufacturer->manufacturer_id . '&amp;option=com_virtuemart&amp;Itemid='. $Itemid . '&amp;category_id=' . $category_id . '&amp;page=shop.browse">' . $manufacturer->mf_name . '</a>|<br />';
					

			} 
        ?>
<br/><br/>

<?php 

if( sizeof($VM_BROWSE_FILTERBY_MF) < 2 ) {
	// return;
}
?>
<?php
	if( empty( $keyword ) ) {
		echo '<br/>Производители:&nbsp';
	}
?>
<?php
if( empty( $keyword ) ) {
  		$query  = "SELECT distinct a.manufacturer_id,a.mf_name FROM #__{vm}_manufacturer AS a ";
		if (!empty( $category_id ) ) {
		    $query .= ", #__{vm}_product_category_xref AS d, "
		    . " #__{vm}_product AS b, "
		    . " #__{vm}_product_mf_xref AS c "
		    . " WHERE d.category_id='$category_id'"
		    . " AND d.product_id = b.product_id "
		    . " AND b.product_id = c.product_id AND c.manufacturer_id = a.manufacturer_id ";
		}
		$query .= "ORDER BY mf_name ASC";
		$db = new ps_DB;
		$db->query( $query );

		$res = $db->record;
		
		
	if( $manufacturer_id === 0 ) {
		echo '<b>Все</b>';
	} else {
		echo '<a href="index.php?orderby=' . $orderby . '&amp;DescOrderBy=' . $asc_desc[0] . '&amp;manufacturer_id=0&limit=' . $limit . '&amp;limitstart='. $limitstart . '&amp;Itemid='. $Itemid . '&amp;option=com_virtuemart&page=shop.browse&category_id=' . $category_id . '&amp;keyword=&keyword1=&keyword2=">Все</a>';
	}		

	
			foreach ($res as $manufacturer) { 
    if( @$_REQUEST['manufacturer_id'] == $manufacturer->manufacturer_id ) {
        echo '&nbsp●&nbsp<b>' . $manufacturer->mf_name . '</b>';
	} else { 
         echo '&nbsp●&nbsp<a href="index.php?orderby=' . $orderby . '&amp;DescOrderBy=' . $asc_desc[0] . '&amp;manufacturer_id=' . $manufacturer->manufacturer_id . '&amp;limit=' . $limit . '&amp;limitstart='. $limitstart . '&amp;Itemid='. $Itemid . '&amp;option=com_virtuemart&page=shop.browse&category_id=' . $category_id . '&amp;keyword=&keyword1=&keyword2=">' . $manufacturer->mf_name . '</a>';
    }		
  }
}        
?>
<br/><br/>