Dear trey braid,
Please open vmcategoriesaccordionreader.php(yoursite/modules/mod_sj_vm_categories_accordion/core/vmcategoriesaccordionreader.php) and find:
$query = "
SELECT
p1.virtuemart_product_id AS id,
p1.product_name AS title,
p1.product_s_desc AS description,
p1.slug AS slug,
p2.product_sku AS sku,
p2.product_in_stock,
p2.product_ordered,
p2.product_sales,
p2.created_on,
price.product_price,
price.product_currency,
(
SELECT m.file_url
FROM #__virtuemart_medias m
INNER JOIN #__virtuemart_product_medias pm ON pm.virtuemart_media_id=m.virtuemart_media_id
WHERE pm.virtuemart_product_id=p2.virtuemart_product_id AND m.published=1
ORDER BY pm.ordering
LIMIT 0, 1
) AS image,
(SELECT COUNT(pr.virtuemart_rating_review_id) FROM #__virtuemart_rating_reviews pr WHERE pr.virtuemart_product_id=p2.virtuemart_product_id AND pr.published=1) AS reviews,
GROUP_CONCAT(pcx.virtuemart_category_id) AS categories
FROM #__virtuemart_products_$lang AS p1
JOIN #__virtuemart_products AS p2 USING (virtuemart_product_id)
LEFT JOIN #__virtuemart_product_prices AS price ON price.virtuemart_product_id=p1.virtuemart_product_id
JOIN #__virtuemart_product_categories AS pcx ON pcx.virtuemart_product_id=p1.virtuemart_product_id
WHERE
p2.published=1
$category_filter
$source_filter
GROUP BY p2.virtuemart_product_id
$source_order_by
$source_limit
";
add "price.product_override_price":
$query = "
SELECT
p1.virtuemart_product_id AS id,
p1.product_name AS title,
p1.product_s_desc AS description,
p1.slug AS slug,
p2.product_sku AS sku,
p2.product_in_stock,
p2.product_ordered,
p2.product_sales,
p2.created_on,
price.product_price,
price.product_override_price,
price.product_currency,
(
SELECT m.file_url
FROM #__virtuemart_medias m
INNER JOIN #__virtuemart_product_medias pm ON pm.virtuemart_media_id=m.virtuemart_media_id
WHERE pm.virtuemart_product_id=p2.virtuemart_product_id AND m.published=1
ORDER BY pm.ordering
LIMIT 0, 1
) AS image,
(SELECT COUNT(pr.virtuemart_rating_review_id) FROM #__virtuemart_rating_reviews pr WHERE pr.virtuemart_product_id=p2.virtuemart_product_id AND pr.published=1) AS reviews,
GROUP_CONCAT(pcx.virtuemart_category_id) AS categories
FROM #__virtuemart_products_$lang AS p1
JOIN #__virtuemart_products AS p2 USING (virtuemart_product_id)
LEFT JOIN #__virtuemart_product_prices AS price ON price.virtuemart_product_id=p1.virtuemart_product_id
JOIN #__virtuemart_product_categories AS pcx ON pcx.virtuemart_product_id=p1.virtuemart_product_id
WHERE
p2.published=1
$category_filter
$source_filter
GROUP BY p2.virtuemart_product_id
$source_order_by
$source_limit
";
Then:
Open file layout1.php(yoursite/modules/mod_sj_vm_categories_accordion/tmpl/layout1.php) find code:
<?php if($options->item_show_price == 1){?>
<div class="item-price">
<?php
if ($item->prices['discountAmount'] > 0 ){
$price_before_discount = $item->prices['salesPrice'] + $item->prices['discountAmount']; ?>
<div class="sale-price-before"><?php echo $vm_currency_display->priceDisplay($price_before_discount); ?></div>
<?php
} ?>
<div class="sale-price"><?php echo $vm_currency_display->priceDisplay($item->prices['salesPrice']);?></div>
</div><!--end item-price-->
<?php }?>
and edit:
<?php if($options->item_show_price == 1){?>
<div class="item-price">
<?php
//var_dump($item);
if ($item->product_override_price > 0 ){?>
<div style="text-decoration: line-through !important; font-size: 14px; color: #003366;">Regular Price:<?php echo $vm_currency_display->priceDisplay($item->prices['salesPrice']);?></div>
<div class="sale-price">Sales Price:<?php echo $vm_currency_display->priceDisplay($item->product_override_price);?></div>
<?php $youSave = $item->prices['salesPrice'] - $item->product_override_price; ?>
<div class="PricediscountAmount"><?php echo 'You Save: '.$vm_currency_display->priceDisplay($youSave); ?></div>
<?php
} else{?>
<div class="sale-price">Regular Price:<?php echo $vm_currency_display->priceDisplay($item->prices['salesPrice']);?></div>
<?php
}?>
</div><!--end item-price-->
<?php }?>
P/S: I edited on your site, please check it again
Thanks
