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