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

		$db->query( "SELECT manufacturer_id, mf_name, mf_desc FROM #__{vm}_manufacturer WHERE manufacturer_id='$manufacturer_id'");

		$db->query( "SELECT manufacturer_id, mf_name FROM #__{vm}_manufacturer WHERE manufacturer_id='$manufacturer_id'");

	if ( $num_rows > 1 && @$_REQUEST['output'] != "pdf") {
		if ( $num_rows > 5 ) { // simplified logic
			$search_string = $mm_action_url."index.php?option=com_virtuemart&Itemid=$Itemid&category_id=$category_id&page=$modulename.browse";
			$search_string .= empty($manufacturer_id)? '' : "&manufacturer_id=$manufacturer_id";
			$search_string .= empty($keyword)? '' : '&keyword='.urlencode( $keyword );
			if (!empty($keyword1)) {
				$search_string.="&keyword1=".urlencode($keyword1);
				$search_string.="&search_category=".urlencode($search_category);
				$search_string.="&search_limiter=$search_limiter";
				if (!empty($keyword2)) {
					$search_string.="&keyword2=".urlencode($keyword2);
					$search_string.="&search_op=".urlencode($search_op);
				}
			}

	if ( $num_rows > 1 && @$_REQUEST['output'] != "pdf") {
		if ( $num_rows > $limit  || $num_rows > 5 ) {
			$search_string = $mm_action_url."index.php?option=com_virtuemart&page=$modulename.browse&category_id=$category_id&keyword=".urlencode( $keyword )."&manufacturer_id=$manufacturer_id&Itemid=$Itemid";
			$search_string .= !empty($orderby)? "&orderby=".urlencode($orderby) : "";
			if (!empty($keyword1)) {
				$search_string.="&keyword1=".urlencode($keyword1);
				$search_string.="&search_category=$search_category";
				$search_string.="&search_limiter=$search_limiter";
				if (!empty($keyword2)) {
					$search_string.="&keyword2=".urlencode($keyword2);
					$search_string.="&search_op=$search_op";
				}
			}

					if (substr($key, 0,13) == "product_type_"){

			if (substr($key, 0,13) == "product_type_" || substr($key, 0,5) == "price"){

		$tpl->set( 'orderby_form', $orderby_form );

		//CHANGES FOR MANUFACTURER FILTER
		$orderby_form = $tpl->fetch( 'browse/includes/browse_filterbymf.tpl.php' );
		$tpl->set( 'filterby_mf', $orderby_form );		
		//END CHANGES FOR MANUFACTURER FILTER

    	$tpl->set( 'orderby_form', '' );

	//CHANGES FOR MANUFACTURER FILTER
	$tpl->set( 'filterby_mf', '' );
	//END CHANGES FOR MANUFACTURER FILTER

// Descending or Ascending Order? possible values: [ASC|DESC]
$DescOrderBy = strtoupper($vm_mainframe->getUserStateFromRequest( "browse{$keyword}{$category_id}{$manufacturer_id}DescOrderBy", 'DescOrderBy', "ASC" ));
$DescOrderBy == 'ASC' ? 'ASC' : 'DESC';

// Descending or Ascending Order? possible values: [ASC|DESC]
$DescOrderBy = $vmInputFilter->safeSQL( $vm_mainframe->getUserStateFromRequest( "browse{$keyword}{$category_id}{$manufacturer_id}DescOrderBy", 'DescOrderBy', "ASC" ) );

// 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 )) {

// 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;
	//MODIFIED FOR FILTER MANUFACTURER 
	//} elseif( empty( $keyword ) && empty( $manufacturer_id )) {
	} elseif( empty( $keyword )) {
	//END MODIFIED FOR FILTER MANUFACTURER 

$count  = "SELECT $count_name FROM ($table_names) ";

if( $perm->is_registered_customer($auth['user_id']) ) {	

//DEBUG x FILTER MANUFACTURER
//echo '<br />'.'--------------------'.'<br />';
//echo 'list='.$list.'<br />';
//echo '<br />'.'--------------------'.'<br />';
//echo 'count='.$count.'<br />';
//$where_clause[] = "`#__{vm}_product_category_xref`.`category_id`=16 ";

$where_clause[] = "`product_parent_id`=0 ";

$where_clause[] = "((`product_parent_id`='0') OR (`product_parent_id`='')) ";

$q .= "\n ORDER BY $orderbyField $DescOrderBy";

//DEBUG x FILTER MANUFACTURER
//echo '<br />'.'--------------------'.'<br />';
//echo 'q='.$q.'<br />';

        <input class="button" type="submit" value="'.$VM_LANG->_('PHPSHOP_SUBMIT').'" />');
}

    //CHANGES FOR FILTER MANUFACTURER
    echo $this->fetch( 'browse/includes/browse_filterbymf.tpl.php');
    //END CHANGES FOR FILTER MANUFACTURER

    <input type="hidden" name="manufacturer_id" value="<?php echo $manufacturer_id ?>" />

    <!--  CHANGES FOR FILTER MANUFACTURER
        <input type="hidden" name="manufacturer_id" value="<?php echo $manufacturer_id ?>" />
        -->
    <input type="hidden" name="limitstart" value="0" />

	echo '<input type="hidden" name="product_type_id" value="'.$product_type_id.'" />'; 

if( $show_top_navigation ) {
	?>
	&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $VM_LANG->_('PN_DISPLAY_NR')?>&nbsp;&nbsp;

	<?php $pagenav->writeLimitBox(); ?>
	<noscript><input type="submit" value="<?php echo $VM_LANG->_('PHPSHOP_SUBMIT')?>" /></noscript>
	
    <!-- PAGE NAVIGATION AT THE TOP -->
    <br/ >
    <div style="text-align:center;"><?php 
    	$pagenav->writePagesLinks( $search_string );
    	echo '<br />';
    	$pagenav->writePagesCounter();
      ?>
    </div>
    
	<?php
	
}
?>

//if( $show_top_navigation ) {
	?>
<!--	<form action="<?php echo $mm_action_url."index.php" ?>" method="get" name="order">
	&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $VM_LANG->_('PN_DISPLAY_NR')?>&nbsp;&nbsp;

	<?php $pagenav->writeLimitBox( $search_string ); ?>
	<noscript><input type="submit" value="<?php echo $VM_LANG->_('PHPSHOP_SUBMIT')?>" /></noscript>
-->  	
    <!-- PAGE NAVIGATION AT THE TOP -->
<!--    <br />
    <div style="text-align:center;"><?php 
    	$pagenav->writePagesLinks( $search_string );
    	echo '<br />'; 
    	$pagenav->writePagesCounter();
      ?>
    </div>
-->    
	<?php
	
// }
?>

			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";

			} 

			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 />';
					

			}