[Решено] Сортировка товара по значению параметра типа в текущей категории V1.1.3 - [VM1] Решенные вопросы

SELECT a.`product_id` , a.`product_name` , b.`nvsh_mex` 
FROM `jos_vm_product` AS a, `jos_vm_product_type_1` AS b, `jos_vm_product_category_xref` AS c
WHERE a.`product_id` = b.`product_id` 
AND a.`product_id` = c.`product_id` 
AND c.`category_id` =1
AND a.`product_publish` = 'Y'
ORDER BY b.`nvsh_mex`

$query = "SELECT distinct a.product_type_id,a.parameter_name,a.parameter_label FROM #__{vm}_product_type_parameter AS a ";
$query .= "ORDER BY a.parameter_label ASC";
$db = new ps_DB;
$db->query( $query );
$myres = $db->record;
foreach ($myres as $param) {
$selected = '';
if( @$_REQUEST['orderby'] == $param->parameter_name )	{
$selected = "selected=\"selected\"";
}
echo "<option value=\"".$param->parameter_name."\" $selected>". $param->parameter_label."</option>\n";
	}

$table_names = '`#__{vm}_product`, `#__{vm}_category`, `#__{vm}_product_category_xref`,`#__{vm}_shopper_group`,`jos_vm_product_type_1`';

switch( $orderby ) {
	case 'product_list':
		$orderbyField = '`#__{vm}_product_category_xref`.`product_list`'; break;
	case 'product_name':
	    $orderbyField = '`#__{vm}_product_type_1`.`nvsh_mex`'; break;
//		$orderbyField = '`#__{vm}_product`.`product_name`'; break;
	case 'product_price':
		$orderbyField = '`#__{vm}_product_price`.`product_price`'; break;
	case 'product_sku':
		$orderbyField = '`#__{vm}_product`.`product_sku`'; break;
	case 'product_cdate':
		$orderbyField = '`#__{vm}_product`.`cdate`'; break;
	case 'nvsh_mex':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_mex`'; break;
	case 'nvsh_model':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_model`'; break;
	case 'nvsh_dlina':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_dlina`'; break;
	case 'nvsh_cena':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_cena`'; break;
	case 'nvsh_magazin':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_magazin`'; break;
	case 'nvsh_cvet':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_cvet`'; break;
	case 'nvsh_vibor':
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_vibor`'; break;

	default:
		//$orderbyField = '`#__{vm}_product`.`product_name`'; break;
		$orderbyField = '`#__{vm}_product_type_1`.`nvsh_mex`'; break;
}

$where_clause[] = "`product_parent_id`=0 ";
if( !$perm->check("admin,storeadmin") ) {
	$where_clause[] = "`product_publish`='Y' ";
	$where_clause[] = "`category_publish`='Y' ";
 $where_clause[] = "`jos_vm_product_type_1`.`product_id`= `jos_vm_product`.`product_id`";

$table_names = '`#__{vm}_product`, `#__{vm}_category`, `#__{vm}_product_category_xref`,`#__{vm}_shopper_group`';

$products[$i]['id'] = $db_browse->f('product_id');
$products[$i]['product_name'] = shopMakeHtmlSafe( $product_name );
$products[$i]['product_s_desc'] = $product_s_desc;
$products[$i]['product_details'] = $product_details;
$products[$i]['product_rating'] = $product_rating;
$products[$i]['product_price'] = $product_price;
$products[$i]['product_price_raw'] = $product_price_raw;
$products[$i]['product_sku'] = $db_browse->f("product_sku");
$products[$i]['product_weight'] = $db_browse->f("product_weight");
$products[$i]['product_weight_uom'] = $db_browse->f("product_weight_uom");
$products[$i]['product_length'] = $db_browse->f("product_length");
$products[$i]['product_width'] = $db_browse->f("product_width");
$products[$i]['product_height'] = $db_browse->f("product_height");
$products[$i]['product_lwh_uom'] = $db_browse->f("product_lwh_uom");
$products[$i]['product_in_stock'] = $db_browse->f("product_in_stock");
$products[$i]['product_available_date'] = $VM_LANG->convert( vmFormatDate($db_browse->f("product_available_date"), $VM_LANG->_('DATE_FORMAT_LC') ));
$products[$i]['product_availability'] = $db_browse->f("product_availability");
$products[$i]['cdate'] = $VM_LANG->convert( vmFormatDate($db_browse->f("cdate"), $VM_LANG->_('DATE_FORMAT_LC') ));
$products[$i]['mdate'] = $VM_LANG->convert( vmFormatDate($db_browse->f("mdate"), $VM_LANG->_('DATE_FORMAT_LC') ));
$products[$i]['product_url'] = $db_browse->f("product_url");

$test=$product_type_param; // Дополнительная перемення для проверки
$cursortfd=$_REQUEST['orderby']; // Получаем параметр по которому происходит сортировка
if ($cursortfd=="") $cursortfd="nvsh_model"; // Если сортировки нет устанавливаем сами тот который по умолчанию
$query1="SELECT `product_id`,".$cursortfd; // Запрос к базе отбираем значение нужного параметра
$query1.="\n FROM `#__{vm}_product_type_1`";
$query1.="\n WHERE product_id=".$products[$i]['id'];
$db = new ps_DB;
$db->query( $query1);
$myres = $db->record;
foreach ($myres as $param1){
$product_type_param=$param1->$cursortfd;
	}
if ($test<>$product_type_param) // Проверяем если значение раньше не выводилось то выводим его
$products[$i]['product_type_param'] = $product_type_param;
else $products[$i]['product_type_param']="<p>&nbsp;</p>";// Если значение уже выводилось вставляем абзац а то иначе будет неровная таблица

<h2>
    <a style="font-size: 16px; font-weight: bold;" href="<?php echo $product_flypage ?>"><?php echo $product_name ?></a>
  </h2>

<h1>
     <?php echo $product_type_param;?>
 </h1>

$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 );
$search_string .= empty($orderby) ? '' : '&orderby='.$orderby;