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

function getShopItemid() {
 

if( empty( $_REQUEST['shopItemid'] )) {
$db = new ps_DB;
$db->query( "SELECT id FROM #__menu WHERE link='index.php?option=com_virtuemart' AND published=1");
if( $db->next_record() ) {
$_REQUEST['shopItemid'] = $db->f("id");
}
else {
if( !empty( $_REQUEST['Itemid'] )) {
$_REQUEST['shopItemid'] = intval( $_REQUEST['Itemid'] );
}
else {
$_REQUEST['shopItemid'] = 1;
}
}
}

return intval($_REQUEST['shopItemid']);

}

function getShopItemid() {

if( empty( $_REQUEST['shopItemid'] )) {
if( !empty( $_REQUEST['Itemid'] )) {
$_REQUEST['shopItemid'] = intval( $_REQUEST['Itemid'] );
}
else {
$db = new ps_DB;
$db->query( "SELECT id FROM #__menu WHERE link='index.php?option=com_virtuemart' AND published=1");
if( $db->next_record() ) {
$_REQUEST['shopItemid'] = $db->f("id");
}
else {
$_REQUEST['shopItemid'] = 1;
}
}
}
return intval($_REQUEST['shopItemid']);
}

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






<?php 

if( sizeof($VM_BROWSE_FILTERBY_MF) < 2 ) {
	// return;
}
?>
<br>
<?php echo "производители" ?>:<br> 

        
        <?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( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' ); 
mm_showMyFileName(__FILE__);

$iCol = 1;
if( !isset( $categories_per_row )) {
	$categories_per_row = 4;
}
$cellwidth = intval( 100 / $categories_per_row );

if( empty( $categories )) {
	return; // Do nothing, if there are no child categories!
}
?>
<br/>
<table width="100%" cellspacing="1" cellpadding="5">
<?php
foreach( $categories as $category ) {
	if ($iCol == 1) { // this is an indicator wether a row needs to be opened or not
		echo "<tr>\n";
	}
	?>
	
	
	<td bgcolor=d0d0d0 ff417f align="center" width=25% idth="<?php echo $cellwidth ?>%">

         <a  title="<?php echo $category["category_name"] ?>" href="<?php $sess->purl(URL."index.php?option=com_virtuemart&amp;page=shop.browse&amp;category_id=".$category["category_id"])?>"> 
			<?php
			if ( $category["category_thumb_image"] ) {
				echo ps_product::image_tag( $category["category_thumb_image"], "alt=\"".$category["category_name"]."\"", 0, "category");
				echo "<br/>\n";
			}
			echo $category["category_name"];
			echo $category['number_of_products'];
			
			?>
		 </a><br/>
	</td>
	
	
	<?php
	// Do we need to close the current row now?
	if ($iCol == $categories_per_row) { // If the number of products per row has been reached
		echo "</tr>\n";
		$iCol = 1;
	}
	else {
		$iCol++;
	}
}
// Do we need a final closing row tag?
if ($iCol != 1) {
	echo "</tr>\n";
}
?>
</table>
<br>