function get_store($config, $id)
{
if ($this->mode != 'com_virtuemart') {
return array("price" => '', "cart" => '');
} else {
// if the VM is available
if (!class_exists('VmConfig')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php';
}
VmConfig::loadConfig();
// Load the language file of com_virtuemart.
JFactory::getLanguage()->load('com_virtuemart');
// load necessary classes
if (!class_exists('calculationHelper')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'calculationh.php';
}
if (!class_exists('CurrencyDisplay')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VirtueMartModelVendor')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'vendor.php';
}
if (!class_exists('VmImage')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'image.php';
}
if (!class_exists('shopFunctionsF')) {
require JPATH_SITE . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
if (!class_exists('calculationHelper')) {
require JPATH_COMPONENT_SITE . DS . 'helpers' . DS . 'cart.php';
}
if (!class_exists('VirtueMartModelProduct')) {
JLoader::import('product', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models');
}
// load the base
$productModel = new VirtueMartModelProduct();
$product = $productModel->getProduct($id, 100, true, true, true);
$currency = CurrencyDisplay::getInstance();
$price = '<strong>' . $currency->createPriceDiv($config['vm_show_price_type'], '', $product->prices, true) . '</strong>';
if ($config['vm_add_to_cart'] == 1) {
vmJsApi::jPrice();
vmJsApi::writeJS();
}
$news_price = '<div class="PricebasePriceWithTax">';
//
if ($config['vm_show_price_type'] != 'none') {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= '<span class="PricebasePriceWithTax">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_PRICE') . ' ' . $price . '</span>';
} else {
$news_price .= '<span class="PricebasePriceWithTax">' . $price . '</span>';
}
}
$news_price .= '</div>';
// display discount
if ($config['vm_show_discount_amount'] == 1) {
$disc_amount = $currency->priceDisplay($product->prices['discountAmount'], $currency->getId());
$news_price .= '<div class="PricetaxAmount">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_DISCOUNT_AMOUNT') . $disc_amount . '</div>';
}
// display tax
if ($config['vm_show_tax'] == 1) {
$taxAmount = $currency->priceDisplay($product->prices['taxAmount'], $currency->getId());
$news_price .= '<div class="PricetaxAmount">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_TAX_AMOUNT') . $taxAmount . '</div>';
}
$news_cart = '';
// 'Add to cart' button
if ($config['vm_add_to_cart'] == 1) {
$code = '<div class="addtocart-area">';
$code .= '<form method="post" class="product" action="index.php">';
$code .= '<div class="addtocart-bar">';
$code .= '<span class="quantity-box" style="display: none"><input type="text" class="quantity-input" name="quantity[]" value="1" /></span>';
$addtoCartButton = '';
if ($product->addToCartButton) {
$addtoCartButton = $product->addToCartButton;
} else {
$addtoCartButton = shopFunctionsF::getAddToCartButton($product->orderable);
}
$code .= $addtoCartButton;
$code .= '</div>
<input type="hidden" class="pname" value="' . $product->product_name . '"/>
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="view" value="cart" />
<input type="hidden" name="task" value="add" />
<input type="hidden" name="virtuemart_product_id[]" value="' . $product->virtuemart_product_id . '" />
<input type="hidden" name="virtuemart_category_id[]" value="' . $product->virtuemart_category_id . '" />
</form>';
$code .= '</div>';
$news_cart .= $code;
}
// results
return array("price" => $news_price, "cart" => $news_cart);
}
}
}
// Get product ids
//$productIds = $product->sortSearchListQuery ($onlyPublished = TRUE, $product->virtuemart_category_id = FALSE, $group = FALSE, $nbrReturnProducts);
$productIds = $product->sortSearchListQuery_Lang($onlyPublished = TRUE, $product->virtuemart_category_id = FALSE, $group = FALSE, $nbrReturnProducts, 'de_de');
$current_id = 0;
$prod_count = 0;
//Print Header
print "name;desc;price;msrp;currency;sizes;category;images_url;gender;brand;product_url;internal_id;fabric;color;mpn\n";
// Go trough all products
foreach ($productIds as $id) {
// Display products in current page
if ($pagination == "on" && ($prod_count < $_start || $prod_count > $_end)) {
$prod_count++;
continue;
}
if ($productItem = $product->getProduct((int) $id, $front = TRUE, $withCalc = TRUE, $onlyPublished = TRUE)) {
$image_url = "";
if (is_array($productItem->virtuemart_media_id) && !empty($productItem->virtuemart_media_id)) {
foreach ($productItem->virtuemart_media_id as $immagine) {
$image->setId($immagine);
//var_dump($image);
$image_url = $image_url . $image->getFile()->file_url . '|';
}
//$image_url = $image->getFile()->file_url;
} else {
$image_url = "";
}
$categorie = array();
$categoria = array();
$categorie = $product->getProductCategories((int) $productItem->virtuemart_product_id, FALSE);
$categoria[] = $categorie[2];
static function store($config, $item)
{
// Load the language file of com_virtuemart.
JFactory::getLanguage()->load('com_virtuemart');
// Load path constant
if (!defined('VMPATH_ADMIN')) {
define('VMPATH_ADMIN', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart');
}
// Load VM configuration if necessary
if (!class_exists('VmConfig')) {
require JPATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php';
VmConfig::loadConfig();
}
// load necessary classes
if (!class_exists('calculationHelper')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'calculationh.php';
}
if (!class_exists('CurrencyDisplay')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VirtueMartModelVendor')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'vendor.php';
}
if (!class_exists('VmImage')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'image.php';
}
if (!class_exists('shopFunctionsF')) {
require JPATH_SITE . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
if (!class_exists('calculationHelper')) {
require JPATH_COMPONENT_SITE . DS . 'helpers' . DS . 'cart.php';
}
if (!class_exists('VirtueMartModelProduct')) {
JLoader::import('product', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models');
}
// load the base
$productModel = new VirtueMartModelProduct();
$product = $productModel->getProduct($item['id'], 100, true, true, true);
$currency = CurrencyDisplay::getInstance();
$price = '<strong>' . $currency->createPriceDiv($config['vm_show_price_type'], '', $product->prices, true) . '</strong>';
if ($config['vm_add_to_cart'] == 1 && JRequest::getCmd('option') != 'com_virtuemart') {
vmJsApi::jPrice();
vmJsApi::addJScript('facebox');
vmJsApi::css('facebox');
vmJsApi::writeJS();
}
$news_price = '<div>';
//
if ($config['vm_show_price_type'] != 'none') {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= '<span>' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_PRICE') . ' ' . $price . '</span>';
} else {
$news_price .= '<span>' . $price . '</span>';
}
}
// 'Add to cart' button
if ($config['vm_add_to_cart'] == 1) {
if (isset($product->customfields) && count($product->customfields)) {
foreach ($product->customfields as $field) {
if (isset($field->is_cart_attribute) && $field->is_cart_attribute == 1 || isset($field->layout_pos) && $field->layout_pos == 'addtocart') {
$product->orderable = 0;
break;
}
}
}
$code = '<div class="addtocart-area">';
if ($product->orderable != 0) {
$code .= '<form method="post" class="product" action="index.php">';
} else {
$code .= '<form method="post" class="product-variant" action="' . static::itemLink($item, $config) . '">';
}
$code .= '<div class="addtocart-bar">';
$code .= '<span class="quantity-box" style="display: none"><input type="text" class="quantity-input" name="quantity[]" value="1" /></span>';
$addtoCartButton = '';
if ($product->addToCartButton) {
$addtoCartButton = $product->addToCartButton;
} else {
$addtoCartButton = shopFunctionsF::getAddToCartButton($product->orderable);
}
$code .= str_replace('addtocart-button-disabled"', 'addtocart-button" type="submit"', $addtoCartButton);
if ($product->orderable != 0) {
$code .= '</div>
<input type="hidden" class="pname" value="' . $product->product_name . '"/>
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="view" value="cart" />
<noscript><input type="hidden" name="task" value="add" /></noscript>
<input type="hidden" name="virtuemart_product_id[]" value="' . $product->virtuemart_product_id . '" />
<input type="hidden" name="virtuemart_category_id[]" value="' . $product->virtuemart_category_id . '" />
</form>';
} else {
$code .= '</div></form>';
}
$code .= '</div>';
$news_price .= $code;
}
// display discount
if ($config['vm_show_discount_amount'] == 1) {
$disc_amount = $currency->priceDisplay($product->prices['discountAmount'], $currency->getId());
$news_price .= '<small class="nspDiscount">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_DISCOUNT_AMOUNT') . $disc_amount . '</small>';
}
// display tax
if ($config['vm_show_tax'] == 1) {
$taxAmount = $currency->priceDisplay($product->prices['taxAmount'], $currency->getId());
$news_price .= '<small class="nspTax">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_TAX_AMOUNT') . $taxAmount . '</small>';
}
// results
return $news_price != '<div>' ? $news_price . '</div>' : '';
}
function get_store($config, $id)
{
// if the VM is available
if (!class_exists('VmConfig')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php';
}
VmConfig::loadConfig();
// Load the language file of com_virtuemart.
JFactory::getLanguage()->load('com_virtuemart');
// load necessary classes
if (!class_exists('calculationHelper')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'calculationh.php';
}
if (!class_exists('CurrencyDisplay')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VirtueMartModelVendor')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'vendor.php';
}
if (!class_exists('VmImage')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'image.php';
}
if (!class_exists('shopFunctionsF')) {
require JPATH_SITE . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
if (!class_exists('calculationHelper')) {
require JPATH_COMPONENT_SITE . DS . 'helpers' . DS . 'cart.php';
}
if (!class_exists('VirtueMartModelProduct')) {
JLoader::import('product', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models');
}
// load the base
$mainframe = JFactory::getApplication();
$virtuemart_currency_id = $mainframe->getUserStateFromRequest("virtuemart_currency_id", 'virtuemart_currency_id', JRequest::getInt('virtuemart_currency_id', 0));
$currency = CurrencyDisplay::getInstance();
$cSymbol = $currency->getSymbol();
$cDecimals = $currency->getNbrDecimals();
$cDecSymbol = $currency->getDecimalSymbol();
//
$productModel = new VirtueMartModelProduct();
$product = $productModel->getProduct($id, 100, true, true, true);
$price = strip_tags($currency->createPriceDiv($config['vm_show_price_type'], '', $product->prices));
// remove currency
$price = str_replace($cSymbol, '', $price);
// prepare price - apply correct format and decimal separator
$price = str_replace('.', $cDecSymbol, $price);
if ($config['vm_currency_position'] == 'before') {
$price = $cSymbol . ' ' . $price;
} else {
$price = $price . ' ' . $cSymbol;
}
//
if ($config['vm_add_to_cart'] == 1) {
vmJsApi::jQuery();
vmJsApi::jPrice();
}
$news_price = '<div class="PricebasePriceWithTax">';
//
if ($config['vm_show_price_type'] != 'none') {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= '<span class="PricebasePriceWithTax">' . JText::_('MOD_NEWS_PRO_GK5_PRODUCT_PRICE') . ' ' . $price . '</span>';
} else {
$news_price .= '<span class="PricebasePriceWithTax">' . $price . '</span>';
}
}
$news_price .= '</div>';
// display discount
if ($config['vm_show_discount_amount'] == 1) {
$news_price .= '<div class="PricetaxAmount">';
$disc_amount = str_replace('.', $cDecSymbol, number_format($product->prices['discountAmount'], $cDecimals));
if ($config['vm_currency_position'] == 'before') {
$disc_amount = $cSymbol . ' ' . $disc_amount;
} else {
$disc_amount = $disc_amount . ' ' . $cSymbol;
}
$news_price .= JText::_('MOD_NEWS_PRO_GK5_PRODUCT_DISCOUNT_AMOUNT') . $disc_amount;
$news_price .= '</div>';
}
// display tax
if ($config['vm_show_tax'] == 1) {
$news_price .= '<div class="PricetaxAmount">';
$taxAmount = str_replace('.', $cDecSymbol, number_format($product->prices['taxAmount'], $cDecimals));
if ($config['vm_currency_position'] == 'before') {
$taxAmount = $cSymbol . ' ' . $taxAmount;
} else {
$taxAmount = $taxAmount . ' ' . $cSymbol;
}
$news_price .= JText::_('MOD_NEWS_PRO_GK5_PRODUCT_TAX_AMOUNT') . $taxAmount;
$news_price .= '</div>';
}
// 'Add to cart' button
$news_cart = '';
//if($config['vm_add_to_cart'] == 1) {
$code = '<form method="post" class="product" action="index.php">';
$code .= '<div class="addtocart-bar">';
$code .= '<span class="quantity-box" style="display: none"><input type="text" class="quantity-input" name="quantity[]" value="1" /></span>';
$button_lbl = JText::_('MOD_NEWS_PRO_GK5_COM_VIRTUEMART_CART_ADD_TO');
$button_cls = '';
$stockhandle = VmConfig::get('stockhandle', 'none');
$code .= '<span class="addtocart-button"><input type="submit" name="addtocart" class="addtocart-button" value="' . $button_lbl . '" title="' . $button_lbl . '" /></span>';
$code .= '</div>
<input type="hidden" class="pname" value="' . $product->product_name . '"/>
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="view" value="cart" />
<noscript><input type="hidden" name="task" value="add" /></noscript>
<input type="hidden" name="virtuemart_product_id[]" value="' . $product->virtuemart_product_id . '" />
<input type="hidden" name="virtuemart_category_id[]" value="' . $product->virtuemart_category_id . '" />
</form>';
$news_cart .= $code;
//}
// restults
return array("price" => $news_price, "cart" => $news_cart);
}
function store_vm($config, $news_id, $news_cid, $news_price, $news_price_currency, $news_discount_amount, $news_discount_is_percent, $news_discount_start, $news_discount_end, $news_tax, $news_manufacturer)
{
//
if (!class_exists('VmConfig')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php';
}
VmConfig::loadConfig();
// Load the language file of com_virtuemart.
JFactory::getLanguage()->load('com_virtuemart');
if (!class_exists('calculationHelper')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'calculationh.php';
}
if (!class_exists('CurrencyDisplay')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VirtueMartModelVendor')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'vendor.php';
}
if (!class_exists('VmImage')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'image.php';
}
if (!class_exists('shopFunctionsF')) {
require JPATH_SITE . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
if (!class_exists('calculationHelper')) {
require JPATH_COMPONENT_SITE . DS . 'helpers' . DS . 'cart.php';
}
if (!class_exists('VirtueMartModelProduct')) {
JLoader::import('product', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models');
}
$mainframe = Jfactory::getApplication();
$virtuemart_currency_id = $mainframe->getUserStateFromRequest("virtuemart_currency_id", 'virtuemart_currency_id', JRequest::getInt('virtuemart_currency_id', 0));
$currency = CurrencyDisplay::getInstance();
$productModel = new VirtueMartModelProduct();
$product = $productModel->getProduct($news_id, 100, true, true, true);
if ($config['vm_add_to_cart'] == 1) {
vmJsApi::jQuery();
vmJsApi::jPrice();
vmJsApi::cssSite();
}
$news_price = '';
if ($config['vm_show_price_type'] != 'none' && $config['vm_show_price_type'] == 'base') {
if ($config['vm_show_price_with_tax'] == 1) {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= $currency->createPriceDiv('basePriceWithTax', 'MOD_NEWS_PRO_GK4_PRODUCT_BASEPRICE_WITHTAX', $product->prices);
} else {
$news_price .= $currency->createPriceDiv('basePriceWithTax', '', $product->prices);
}
} else {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= $currency->createPriceDiv('priceWithoutTax', 'MOD_NEWS_PRO_GK4_PRODUCT_BASEPRICE_WITHOUTTAX', $product->prices);
} else {
$news_price .= $currency->createPriceDiv('priceWithoutTax', '', $product->prices);
}
}
}
if ($config['vm_show_price_type'] != 'none' && $config['vm_show_price_type'] == 'sale') {
if ($config['vm_show_price_with_tax'] == 1) {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= $currency->createPriceDiv('salesPrice', 'MOD_NEWS_PRO_GK4_PRODUCT_SALESPRICE', $product->prices);
} else {
$news_price .= $currency->createPriceDiv('salesPrice', '', $product->prices);
}
} else {
if ($config['vm_display_type'] == 'text_price') {
$news_price .= $currency->createPriceDiv('priceWithoutTax', 'MOD_NEWS_PRO_GK4_PRODUCT_SALESPRICE_WITHOUT_TAX', $product->prices);
} else {
$news_price .= $currency->createPriceDiv('priceWithoutTax', '', $product->prices);
}
}
}
if ($config['vm_add_to_cart'] == 1) {
$code = '';
$code .= '<form method="post" class="product" action="index.php">';
$code .= '<div class="addtocart-bar">';
$code .= '<span class="quantity-box" style="display: none">
<input type="text" class="quantity-input" name="quantity[]" value="1" />
</span>';
$button_lbl = JText::_('COM_VIRTUEMART_CART_ADD_TO');
$button_cls = '';
$stockhandle = VmConfig::get('stockhandle', 'none');
$code .= '<span class="addtocart-button">
<input type="submit" name="addtocart" class="addtocart-button" value="' . $button_lbl . '" title="' . $button_lbl . '" /></span>';
$code .= '<div class="clear"></div></div>
<input type="hidden" class="pname" value="' . $product->product_name . '"/>
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="view" value="cart" />
<noscript><input type="hidden" name="task" value="add" /></noscript>
<input type="hidden" name="virtuemart_product_id[]" value="' . $product->virtuemart_product_id . '" />
<input type="hidden" name="virtuemart_category_id[]" value="' . $product->virtuemart_category_id . '" />
</form>';
$news_price .= $code;
}
if ($config['vm_show_discount_amount'] == 1) {
$disc_amount = $currency->createPriceDiv('discountAmount', 'MOD_NEWS_PRO_GK4_PRODUCT_DISCOUNT_AMOUNT', $product->prices);
$disc_amount = strip_tags($disc_amount, '<div>');
$news_price .= $disc_amount;
}
if ($config['vm_show_tax'] == 1) {
$taxAmount = $currency->createPriceDiv('taxAmount', 'MOD_NEWS_PRO_GK4_PRODUCT_TAX_AMOUNT', $product->prices);
$taxAmount = strip_tags($taxAmount, '<div>');
$news_price .= $taxAmount;
}
return $news_price != '' ? '<div class="nspVmStore">' . $news_price . '</div>' : '';
}
function getData($number)
{
nextendimport('nextend.database.database');
$db = NextendDatabase::getInstance();
require_once JPATH_ADMINISTRATOR . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_virtuemart' . DIRECTORY_SEPARATOR . 'helpers' . DIRECTORY_SEPARATOR . 'config.php';
VmConfig::loadConfig();
$language = $this->_data->get('virtuemartproductssourcelanguage', 'en_gb');
if (!$language) {
$language = VMLANG;
}
$data = array();
$category = array_map('intval', explode('||', $this->_data->get('virtuemartproductssourcecategory', '')));
$query = 'SELECT ';
$query .= 'prod.virtuemart_product_id AS id, ';
$query .= 'prod.product_sku AS sku, ';
$query .= 'prod_ext.product_name AS name, ';
$query .= 'prod_ext.product_s_desc AS short_description, ';
$query .= 'prod_ext.product_desc AS description, ';
$query .= 'prod_ext.slug AS slug, ';
$query .= 'cat.virtuemart_category_id AS category_id, ';
$query .= 'cat.category_name, ';
$query .= 'cat.category_description, ';
$query .= 'cat.slug AS category_slug, ';
$query .= 'man.virtuemart_manufacturer_id AS manufacturer_id, ';
$query .= 'man.mf_name AS manufacturer_name, ';
$query .= 'man.mf_email AS manufacturer_email, ';
$query .= 'man.mf_desc AS manufacturer_description, ';
$query .= 'man.mf_url AS manufacturer_url, ';
$query .= 'man.slug AS manufacturer_slug, ';
$query .= 'med.file_url AS image, ';
$query .= 'med.file_url_thumb AS thumbnail, ';
$query .= 'prod.hits ';
$query .= 'FROM #__virtuemart_products AS prod ';
$query .= 'LEFT JOIN #__virtuemart_products_' . $language . ' AS prod_ext ON prod.virtuemart_product_id = prod_ext.virtuemart_product_id ';
$query .= 'LEFT JOIN #__virtuemart_product_categories AS cat_x ON cat_x.virtuemart_product_id = prod.virtuemart_product_id ';
$query .= 'LEFT JOIN #__virtuemart_categories_' . $language . ' AS cat ON cat_x.virtuemart_category_id = cat.virtuemart_category_id ';
$query .= 'LEFT JOIN #__virtuemart_product_manufacturers AS man_x ON man_x.virtuemart_product_id = prod.virtuemart_product_id ';
$query .= 'LEFT JOIN #__virtuemart_manufacturers_' . $language . ' AS man ON man_x.virtuemart_manufacturer_id = man.virtuemart_manufacturer_id ';
$query .= 'LEFT JOIN #__virtuemart_product_medias AS med_x ON med_x.virtuemart_product_id = prod.virtuemart_product_id ';
$query .= 'LEFT JOIN #__virtuemart_medias AS med ON med_x.virtuemart_media_id = med.virtuemart_media_id ';
$where = array();
if (!in_array(0, $category) && count($category) > 0) {
$where[] = 'cat_x.virtuemart_category_id IN (' . implode(',', $category) . ') ';
}
if ($this->_data->get('virtuemartproductssourcepublished', 1)) {
$where[] = ' prod.published = 1 ';
}
if ($this->_data->get('virtuemartproductssourcespecial', 0)) {
$where[] = ' prod.product_special = 1 ';
}
if ($this->_data->get('virtuemartproductssourceinstock', 0)) {
$where[] = ' prod.product_in_stock > 0 ';
}
$where[] = ' med.file_is_downloadable = 0 ';
$where[] = ' med.file_is_forSale = 0 ';
if (count($where) > 0) {
$query .= 'WHERE ' . implode(' AND ', $where) . ' ';
}
$order = NextendParse::parse($this->_data->get('virtuemartproductsorder1', 'prod_ext.product_name|*|asc'));
if ($order[0]) {
$query .= 'ORDER BY ' . $order[0] . ' ' . $order[1] . ' ';
$order = NextendParse::parse($this->_data->get('virtuemartproductsorder2', 'prod_ext.product_name|*|asc'));
if ($order[0]) {
$query .= ', ' . $order[0] . ' ' . $order[1] . ' ';
}
}
$query .= 'LIMIT 0, ' . $number . ' ';
$db->setQuery($query);
$result = $db->loadAssocList();
require_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
require_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'product.php';
$currency = CurrencyDisplay::getInstance();
for ($i = 0; $i < count($result); $i++) {
$result[$i]['title'] = $result[$i]['name'];
$productModel = new VirtueMartModelProduct();
$p = $productModel->getProduct($result[$i]['id'], TRUE, TRUE, TRUE, 1, false);
$result[$i]['price'] = $result[$i]['cost_price'] = $currency->createPriceDiv('costPrice', '', $p->prices, true);
$result[$i]['base_price'] = $currency->createPriceDiv('basePrice', '', $p->prices, true);
$result[$i]['base_price_variant'] = $currency->createPriceDiv('basePriceVariant', '', $p->prices, true);
$result[$i]['base_price_with_tax'] = $currency->createPriceDiv('basePriceWithTax', '', $p->prices, true);
$result[$i]['discounted_price_without_tax'] = $currency->createPriceDiv('discountedPriceWithoutTax', '', $p->prices, true);
$result[$i]['price_before_tax'] = $currency->createPriceDiv('priceBeforeTax', '', $p->prices, true);
$result[$i]['sales_price'] = $currency->createPriceDiv('salesPrice', '', $p->prices, true);
$result[$i]['tax_amount'] = $currency->createPriceDiv('taxAmount', '', $p->prices, true);
$result[$i]['sales_price_with_discount'] = $currency->createPriceDiv('salesPriceWithDiscount', '', $p->prices, true);
$result[$i]['sales_price_temp'] = $currency->createPriceDiv('salesPriceTemp', '', $p->prices, true);
$result[$i]['unit_price'] = $currency->createPriceDiv('unitPrice', '', $p->prices, true);
$result[$i]['price_without_tax'] = $currency->createPriceDiv('priceWithoutTax', '', $p->prices, true);
$result[$i]['discount_amount'] = $currency->createPriceDiv('discountAmount', '', $p->prices, true);
$result[$i]['variant_modification'] = $currency->createPriceDiv('variantModification', '', $p->prices, true);
$result[$i]['addtocart'] = $result[$i]['url'] = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $result[$i]['id'] . '&virtuemart_category_id=' . $result[$i]['category_id'];
$result[$i]['addtocart_label'] = 'View product';
$result[$i]['category_url'] = 'index.php?option=com_virtuemart&view=category&virtuemart_category_id=' . $result[$i]['category_id'];
$result[$i]['image'] = JURI::root(false) . '/' . $result[$i]['image'];
$result[$i]['thumbnail'] = JURI::root(false) . '/' . $result[$i]['thumbnail'];
}
return $result;
}
function get_store($config, $id)
{
// if the VM is available
if (!class_exists('VmConfig')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php';
}
VmConfig::loadConfig();
// Load the language file of com_virtuemart.
JFactory::getLanguage()->load('com_virtuemart');
// load necessary classes
if (!class_exists('calculationHelper')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'calculationh.php';
}
if (!class_exists('CurrencyDisplay')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VirtueMartModelVendor')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models' . DS . 'vendor.php';
}
if (!class_exists('VmImage')) {
require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'image.php';
}
if (!class_exists('shopFunctionsF')) {
require JPATH_SITE . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
if (!class_exists('calculationHelper')) {
require JPATH_COMPONENT_SITE . DS . 'helpers' . DS . 'cart.php';
}
if (!class_exists('VirtueMartModelProduct')) {
JLoader::import('product', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'models');
}
// load the base
$mainframe = JFactory::getApplication();
$virtuemart_currency_id = $mainframe->getUserStateFromRequest("virtuemart_currency_id", 'virtuemart_currency_id', JRequest::getInt('virtuemart_currency_id', 0));
$currency = CurrencyDisplay::getInstance();
$productModel = new VirtueMartModelProduct();
$product = $productModel->getProduct($id, 100, true, true, true);
//if($config['vm_add_to_cart'] == 1) {
vmJsApi::jQuery();
vmJsApi::jPrice();
vmJsApi::cssSite();
//}
$news_price = '';
$news_price .= $currency->createPriceDiv('basePriceWithTax', '', $product->prices);
// calculate tax
$taxAmount = $currency->createPriceDiv('taxAmount', 'MOD_NEWS_PRO_GK5_PRODUCT_TAX_AMOUNT', $product->prices);
$taxAmount = strip_tags($taxAmount, '<div>');
$news_price .= $taxAmount;
// 'Add to cart' button
$news_cart = '';
//if($config['vm_add_to_cart'] == 1) {
$code = '<form method="post" class="product" action="index.php">';
$code .= '<div class="addtocart-bar">';
$code .= '<span class="quantity-box" style="display: none"><input type="text" class="quantity-input" name="quantity[]" value="1" /></span>';
$button_lbl = JText::_('MOD_NEWS_PRO_GK5_COM_VIRTUEMART_CART_ADD_TO');
$button_cls = '';
$stockhandle = VmConfig::get('stockhandle', 'none');
$code .= '<span class="addtocart-button"><input type="submit" name="addtocart" class="addtocart-button" value="' . $button_lbl . '" title="' . $button_lbl . '" /></span>';
$code .= '</div>
<input type="hidden" class="pname" value="' . $product->product_name . '"/>
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="view" value="cart" />
<noscript><input type="hidden" name="task" value="add" /></noscript>
<input type="hidden" name="virtuemart_product_id[]" value="' . $product->virtuemart_product_id . '" />
<input type="hidden" name="virtuemart_category_id[]" value="' . $product->virtuemart_category_id . '" />
</form>';
$news_cart .= $code;
//}
// restults
return array("price" => $news_price, "cart" => $news_cart);
}
