Сопутствующие товары на странице категории - Разработки и улучшения

class plgJshoppingProductsStarkman_relatedInCategory extends JPlugin{

    function onBeforeQueryGetProductList($type, &$adv_result, &$adv_from, &$adv_query, &$order_query, &$filters){

    	if ($type == "category"){
    		$adv_result .= ", GROUP_CONCAT(relation.product_related_id) as rel";
	        $adv_from .= "LEFT JOIN `#__jshopping_products_relations` AS relation ON relation.product_id = prod.product_id";
	        $adv_query .= " group by prod.product_id";
	    }

    }

    function onBeforeDisplayProductListView(&$view){

        foreach ($view->rows as $k => $product) {
        	$k==0 ? $products_in_page = $product->product_id : $products_in_page .= ',' . $product->product_id;
        }
		
        $adv_query = "";
        $adv_from = "";
        $adv_result = JTableAvto::getBuildQueryListProductDefaultResult();
        $filters = array();

        $jshopConfig = JSFactory::getConfig();
        $user = JFactory::getUser();

        $groups = implode(',', $user->getAuthorisedViewLevels());
        $adv_query .=' AND prod.access IN ('.$groups.') AND cat.access IN ('.$groups.')';
        
        if ($jshopConfig->hide_product_not_avaible_stock){
            $adv_query .= " AND prod.product_quantity > 0";
        }
        if ($jshopConfig->show_delivery_time){
            $adv_result .= ", prod.delivery_times_id";
        }
        if ($jshopConfig->admin_show_product_extra_field){
            $adv_result .= getQueryListProductsExtraFields();
        }
        if ($jshopConfig->product_list_show_vendor){
            $adv_result .= ", prod.vendor_id";
        }
        if ($jshopConfig->product_list_show_qty_stock){
            $adv_result .= ", prod.unlimited";
        }

        $order_query = "";

        $query = "SELECT $adv_result FROM `#__jshopping_products_relations` AS relation
                INNER JOIN `#__jshopping_products` AS prod ON relation.product_related_id = prod.product_id
                LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = relation.product_related_id
                LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
                $adv_from
                WHERE relation.product_id IN (" . $products_in_page . ") AND cat.category_publish='1' AND prod.product_publish = '1' ".$adv_query." group by prod.product_id ".$order_query;
        

        $db = &JFactory::getDBO();
		$db->setQuery($query);
		$rel = $db->loadObjectList();
        
        foreach($rel as $key=>$value) {
            $rel[$key]->product_link = SEFLink('index.php?option=com_jshopping&controller=product&task=view&category_id='.$value->category_id.'&product_id='.$value->product_id, 1);
        }
        $rel = listProductUpdateData($rel, 1);

        $view->assign('related', $rel);
    }
}

$tProduct = JTable::getInstance('Product', 'jshop');
$adv_result = $tProduct->getBuildQueryListProductDefaultResult()

    function onBeforeDisplayProductListView(&$view){

        foreach ($view->rows as $k => $product) {
        	$k==0 ? $products_in_page = $product->product_id : $products_in_page .= ',' . $product->product_id;
        }

        $adv_query = "";
        $adv_from = "";
        $filters = array();
        $order_query = "";

        $tProduct = JTable::getInstance('Product', 'jshop');
		$adv_result = $tProduct->getBuildQueryListProductDefaultResult();
        $tProduct->getBuildQueryListProductSimpleList("related", null, $filters, $adv_query, $adv_from, $adv_result);

        $adv_result .= ", GROUP_CONCAT(relation.product_id) as rel";

        $query = "SELECT $adv_result FROM `#__jshopping_products_relations` AS relation
                INNER JOIN `#__jshopping_products` AS prod ON relation.product_related_id = prod.product_id
                LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = relation.product_related_id
                LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
                $adv_from
                WHERE relation.product_id IN (" . $products_in_page . ") AND cat.category_publish='1' AND prod.product_publish = '1' ".$adv_query." group by prod.product_id ".$order_query;

        $db = &JFactory::getDBO();
		$db->setQuery($query);
		$rel = $db->loadObjectList();
        
        $rel = listProductUpdateData($rel, 1);

        $view->assign('related', $rel);
    }