private function get_category_products($category_id, $count)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('id');
$query->select('name');
$query->select('images');
$query->from('#__ecommercewd_products');
$query->where('category_id = ' . $category_id);
$query->where('published = 1');
$query->order('ordering ASC');
if ($count) {
$db->setQuery($query, 0, $count);
} else {
$db->setQuery($query);
}
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
return false;
}
// additional data
foreach ($rows as $row) {
// url
$row->url = JRoute::_('index.php?option=com_' . WDFHelper::get_com_name() . '&controller=products&task=displayproduct&product_id=' . $row->id);
// image
$row->images = WDFJson::decode($row->images);
$row->image = empty($row->images) == false ? $row->images[0] : '';
}
return $rows;
}
private function add_product_related_products($product_rows)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
for ($i = 0; $i < count($product_rows); $i++) {
$product_row = $product_rows[$i];
$query->clear();
$query->select('T_PRODUCTS.id');
$query->select('T_PRODUCTS.name');
$query->select('T_PRODUCTS.images');
$query->from('#__ecommercewd_products AS T_PRODUCTS');
$query->where('T_PRODUCTS.category_id = ' . $product_row->category_id);
$query->where('T_PRODUCTS.id <> ' . $product_row->id);
$query->where('T_PRODUCTS.published = 1');
$query->order('RAND() LIMIT 0, 15');
$db->setQuery($query);
$related_product_rows = $db->loadObjectList();
if ($db->getErrorNum()) {
return false;
}
// add data
foreach ($related_product_rows as $related_product_row) {
// link
$related_product_row->link = JRoute::_('index.php?option=com_' . WDFHelper::get_com_name() . '&controller=products&task=displayproduct&product_id=' . $related_product_row->id);
// image
$related_product_row->images = WDFJson::decode($related_product_row->images);
$related_product_row->image = count($related_product_row->images) > 0 ? $related_product_row->images[0] : '';
}
$product_row->related_products = $related_product_rows;
}
}
?>
;
var wdShop_minicart = "<?php
echo Juri::base() . 'index.php?option=com_' . WDFHelper::get_com_name() . '&controller=shoppingcart&task=displayminicart&tmpl=component';
?>
";
var wdShop_minicart_js_path = "<?php
echo WDFUrl::get_site_url() . 'modules/mod_ecommercewd_minicart/js/main.js';
?>
";
var wdShop_urlAddToShoppingCart = "<?php
echo WDFUrl::get_site_url() . 'index.php?option=com_' . WDFHelper::get_com_name() . '&controller=shoppingcart&task=add';
?>
";
var wdShop_urlDisplayShoppingCart = "<?php
echo JRoute::_('index.php?option=com_' . WDFHelper::get_com_name() . '&controller=shoppingcart&task=displayshoppingcart');
?>
";
var wdShop_amount_in_stock = <?php
echo $product_row->amount_in_stock;
?>
;
var wdShop_product_unlimited = <?php
echo $product_row->unlimited;
?>
;
var wdShop_currency_code = "<?php
echo $row_default_currency->sign;
?>
";
var wdShop_currency_position = "<?php
