Усовершенствованный mod_jshopping_label_products - Модули и Аддоны

require_once (JPATH_SITE . DS . 'components' . DS . 'com_jshopping' . DS . "lib" . DS . "functions.php");

require_once (JPATH_SITE . DS . 'components' . DS . 'com_jshopping' . DS . "tables" . DS . "product.php");

$jshopConfig = &JSFactory::getConfig();

class JSProductCategories extends jshopProduct {

  function getBuildQueryListProductDefaultResult() {
    $lang = &JSFactory::getLang();
    return "prod.product_id, pr_cat.category_id, cat.`" . $lang->get('name'). "` as catname, prod.`" . $lang->get('name'). "` as name, prod.`" . $lang->get('short_description'). "` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices";
  }

}

$product = &JTable::getInstance('product', 'jshop');

$product = &JTable::getInstance('categories', 'JSProduct');

$query = "SELECT prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_id, prod.product_ean, prod.product_thumb_image, prod.product_price, pr_cat.category_id, prod.product_tax_id as tax_id , prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.product_weight, prod.min_price, prod.product_quantity, prod.different_prices $adv_result
                  FROM `#__jshopping_products` AS prod
                  INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id
                  LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
                  WHERE prod.product_publish = '1' and prod.label_id!=0 AND cat.category_publish='1' ".$where_add."
                  GROUP BY prod.product_id ORDER BY name LIMIT ".$count;

$query = "SELECT prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_id, prod.product_ean, prod.product_thumb_image, prod.product_price, pr_cat.category_id, prod.product_tax_id as tax_id , prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.product_weight, prod.min_price, prod.product_quantity, prod.different_prices $adv_result
                  FROM `#__jshopping_products` AS prod
                  INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id
                  LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
                  WHERE prod.product_publish = '1' and prod.label_id!=0 AND cat.category_publish='1' ".$where_add."
                  GROUP BY prod.product_id ORDER BY rand() LIMIT ".$count;

<img src = "<?php print $jshopConfig->image_product_live_path?>/<?php if ($curr->product_thumb_image) print $curr->product_thumb_image; else print $noimage?>" alt="" />

<?php print $curr->name?>

<?php print _JSHOP_WEIGHT?>: <span><?php print formatweight($curr->product_weight)?></span>

require_once (JPATH_SITE.'/components/com_jshopping/tables/category.php');
$category = JTable::getInstance('category', 'jshop');
$category->load();
$catname = $category->getName();

<?php var_dump($catname); ?>

               <?php 
                    $table_product = JTable::getInstance('product', 'jshop');
                    $table_product->load($curr->product_id);
                    $table_category = JTable::getInstance('category', 'jshop');
                    $table_category->load($table_product->getCategory());
                    print $table_category->getName();
                ?>