function m_showProductDetails()
{
$this->libFunc->obDb = $this->obDb;
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
if (!isset($this->request['mode']) || $this->libFunc->m_isNull($this->request['mode'])) {
$this->request['mode'] = 0;
}
if (isset($this->request['id']) && !empty($this->request['id'])) {
$this->obDb->query = 'SELECT * FROM ' . PRODUCTS . ' WHERE iProdid_PK="' . $this->request['id'] . '"';
} else {
#TO DISPLAY THE HEAD NAME
$this->obDb->query = "SELECT * FROM " . PRODUCTS . ", " . FUSIONS . " F WHERE iProdid_PK =iSubId_FK AND vtype='product' AND iState=1 AND vSeoTitle='" . $this->request['mode'] . "'";
}
$rowHead = $this->obDb->fetchQuery();
#MARGIN CALCULATOR
switch (MARGINSTATUS) {
case "increase":
$rowHead[0]->fPrice = $rowHead[0]->fPrice * MARGINPERCENT / 100 + $rowHead[0]->fPrice;
break;
case "decrease":
$rowHead[0]->fPrice = $rowHead[0]->fPrice - $rowHead[0]->fPrice * MARGINPERCENT / 100;
break;
default:
$rowHead[0]->fPrice = $rowHead[0]->fPrice;
break;
}
#END MARGIN CALCULATOR
//--- Switch to retail price if Retail customer
if ($comFunc->m_checkCustomerType() == 1 && ENABLE_WHOLESALE == 1 && $rowHead[0]->fRetailPrice > 0) {
$rowHead[0]->fPrice = $rowHead[0]->fRetailPrice;
}
//----End switch price
if ($this->libFunc->m_isNull($rowHead[0]->vTemplate)) {
$errrorUrl = SITE_URL . "index.php?action=error&mode=product";
$this->libFunc->m_mosRedirect($this->libFunc->m_safeUrl($errrorUrl));
exit;
}
//SETTING COOKIES FOR RECENTLY VIEWED PRODUCTS
if (RECENTVIEWED == 1) {
$productSEO = stripslashes($rowHead[0]->vSeoTitle);
//check to see if cookie already set
if (!isset($_COOKIE['jimbeam'])) {
setcookie('jimbeam[0]', $productSEO, 0, "/");
} else {
$i = count($_COOKIE['jimbeam']);
if (!in_array($productSEO, $_COOKIE['jimbeam'])) {
setcookie('jimbeam[' . $i . ']', $productSEO, 0, "/");
}
}
}
$this->ObTpl = new template();
$this->ObTpl->set_file("TPL_DETAILS_FILE", $this->templatePath . "product/" . $rowHead[0]->vTemplate);
$this->ObTpl->set_var("TPL_VAR_PRODUCTTITLE", $this->libFunc->m_displayContent($rowHead[0]->vTitle));
//UPDATE PRODUCT VIEW COUNT.
$ViewCount = $rowHead[0]->iViewCount + 1;
$this->obDb->query = "UPDATE " . PRODUCTS . " SET iViewCount='" . $ViewCount . "' WHERE iProdId_PK='" . $rowHead[0]->iProdid_PK . "'";
$this->obDb->updateQuery();
$this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_URL);
$this->ObTpl->set_var("TPL_VAR_GRAPHICSURL", GRAPHICS_PATH);
$this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY);
#SETTING TEMPLATE BLOCKS
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_MAINPRODUCT_BLK", "mainproduct_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_IMAGE_GALLERY_BLK", "image_gallery_blk");
$this->ObTpl->set_block("TPL_IMAGE_GALLERY_BLK", "TPL_IMAGE_LIST_BLK", "image_list_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_HIDDEN_BLK", "hidden_blk");
$this->ObTpl->set_block("TPL_MAINPRODUCT_BLK", "TPL_PRODUCT_BLK", "dspproduct_blk");
$this->ObTpl->set_block("TPL_PRODUCT_BLK", "TPL_PDESC_BLK", "productdesc_blk");
$this->ObTpl->set_block("TPL_PRODUCT_BLK", "TPL_RRPPRICE_BLK", "rrp_price_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_REVIEWCONTAINER_BLK", "reviewcontainer_blk");
$this->ObTpl->set_block("TPL_REVIEWCONTAINER_BLK", "TPL_REVIEWLINK_BLK", "reviewlink_blk");
$this->ObTpl->set_block("TPL_REVIEWCONTAINER_BLK", "TPL_REVIEW_BLK", "dspreview_blk");
$this->ObTpl->set_block("TPL_REVIEW_BLK", "TPL_LINK_BLK", "link_blk");
$this->ObTpl->set_block("TPL_REVIEWCONTAINER_BLK", "TPL_REVIEWFORM_BLK", "reviewform_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_BASKET_BLK", "basket_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_WISHLIST_BLK", "wishlist_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_COMPARE_BLK", "compare_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_ENQUIRY_BLK", "enquiry_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_SUPPLIERIMG_BLK", "supplierimg_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_ONSALELBL_BLK", "onsalelbl_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_RRPLBL_BLK", "rrplbl_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_REVIEWRANK_BLK", "reviewrank_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_QTY_BLK", "qty_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_PDETAILS_BLK", "pdetail_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_MAINCONTENT_BLK", "dspmaincontent_blk");
$this->ObTpl->set_block("TPL_MAINCONTENT_BLK", "TPL_CONTENT_BLK", "dspcontent_blk");
$this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_ATTRIBUTETABLE_BLK", "attributetable_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_WIDTH_BLK", "itemwidth_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_HEIGHT_BLK", "itemheight_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_DEPTH_BLK", "itemdepth_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_WEIGHT_BLK", "itemweight_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_ASIN_BLK", "itemasin_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_ISBN_BLK", "itemisbn_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_MPN_BLK", "itemmpn_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_UPC_BLK", "imtemupc_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ITEM_SKU_BLK", "imtemsku_blk");
$this->ObTpl->set_block("TPL_ATTRIBUTETABLE_BLK", "TPL_ATTRIBUTEFIELD_BLK", "attributefield_blk");
$this->ObTpl->halt_on_error = "no";
#TO CHECK KIT BLOCK
$this->kitBlk = $this->ObTpl->set_block("TPL_DETAILS_FILE", "TPL_KIT_BLK", "kit_blk");
if ($this->kitBlk) {
$this->ObTpl->set_block("TPL_KIT_BLK", "TPL_KITELEMENT_BLK", "kitElement_blk");
}
#INTIALIZING
$this->ObTpl->set_var("mainproduct_blk", "");
$this->ObTpl->set_var("image_gallery_blk", "");
$this->ObTpl->set_var("image_list_blk", "");
$this->ObTpl->set_var("dspproduct_blk", "");
$this->ObTpl->set_var("productdesc_blk", "");
$this->ObTpl->set_var("hidden_blk", "");
$this->ObTpl->set_var("rrp_price_blk", "");
$this->ObTpl->set_var("dspmaincontent_blk", "");
$this->ObTpl->set_var("dspcontent_blk", "");
$this->ObTpl->set_var("reviewlink_blk", "");
$this->ObTpl->set_var("reviewform_blk", "");
$this->ObTpl->set_var("reviewcontainer_blk", "");
$this->ObTpl->set_var("reviewrank_blk", "");
$this->ObTpl->set_var("dspreview_blk", "");
$this->ObTpl->set_var("link_blk", "");
$this->ObTpl->set_var("basket_blk", "");
$this->ObTpl->set_var("wishlist_blk", "");
$this->ObTpl->set_var("compare_blk", "");
$this->ObTpl->set_var("enquiry_blk", "");
$this->ObTpl->set_var("attributetable_blk", "");
$this->ObTpl->set_var("itemwidth_blk", "");
$this->ObTpl->set_var("itemheight_blk", "");
$this->ObTpl->set_var("itemdepth_blk", "");
$this->ObTpl->set_var("itemweight_blk", "");
$this->ObTpl->set_var("itemasin_blk", "");
$this->ObTpl->set_var("itemisbn_blk", "");
$this->ObTpl->set_var("itemmpn_blk", "");
$this->ObTpl->set_var("imtemupc_blk", "");
$this->ObTpl->set_var("imtemsku_blk", "");
$this->ObTpl->set_var("attributefield_blk", "");
$this->ObTpl->set_var("supplierimg_blk", "");
$this->ObTpl->set_var("onsalelbl_blk", "");
$this->ObTpl->set_var("rrplbl_blk", "");
$this->ObTpl->set_var("qty_blk", "");
$this->ObTpl->set_var("pdetail_blk", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("kitElement_blk", "");
$this->ObTpl->set_var("TPL_VAR_RRP", "");
$this->ObTpl->set_var("TPL_VAR_MAINOPTIONS", "");
$this->ObTpl->set_var("TPL_VAR_MAINCHOICES", "");
$this->ObTpl->set_var("TPL_VAR_SUPPLIERIMAGE", "");
$this->ObTpl->set_var("TPL_VAR_ONSALE", "");
$this->ObTpl->set_var("TPL_VAR_SHIPNOTES", "");
$this->ObTpl->set_var("TPL_VAR_FREEPOSTAGE", "");
$this->ObTpl->set_var("TPL_VAR_STATUS", "");
#defining language pack variables.
$this->ObTpl->set_var("LANG_VAR_ADDTOBASKET", LANG_ADDTO_BASKET);
$this->ObTpl->set_var("LANG_VAR_ENQUIRENOW", LANG_ENQUIRE_NOW);
$this->ObTpl->set_var("LANG_VAR_PRICE", LANG_PRICE);
$this->ObTpl->set_var("LANG_VAR_QTY", LANG_QTY);
$this->ObTpl->set_var("LANG_VAR_OPTIONS", LANG_OPTIONS);
$this->ObTpl->set_var("LANG_VAR_LATESTNEWS", LATEST_NEWS);
$this->ObTpl->set_var("LANG_VAR_CUSTOMERREVIEWS", LANG_CUSTOMER_REVIEWS);
$this->ObTpl->set_var("LANG_VAR_ADDWISHLIST", LANG_WISH_LISTADD);
$this->ObTpl->set_var("LANG_VAR_PRODUCTDETAILS", LANG_PRODUCTDETAILS);
$this->ObTpl->set_var("LANG_VAR_MAYWESUGGEST", LANG_MAYWESUGGEST);
#DISPLAY IMAGE FOR SELECTED PRODUCT
if (!$this->libFunc->m_isNull($rowHead[0]->vImage2)) {
$img = $this->libFunc->m_checkFile($rowHead[0]->vImage2, "product", $this->libFunc->m_displayContent($rowHead[0]->vTitle), 1);
if ($img) {
$this->ObTpl->set_var("TPL_VAR_IMAGE", $img);
} else {
$this->ObTpl->set_var("TPL_VAR_IMAGE", MSG_NOIMG);
}
} else {
$this->ObTpl->set_var("TPL_VAR_IMAGE", MSG_NOIMG);
}
if (!$this->libFunc->m_isNull($rowHead[0]->vImage3)) {
if ($this->libFunc->m_checkFileExist($rowHead[0]->vImage3, "product")) {
$this->ObTpl->set_var("TPL_VAR_IMGPATH", "{TPL_VAR_REAL_PATH}images/product/" . $rowHead[0]->vImage3);
$this->ObTpl->set_var("TPL_VAR_VIEWLARGEIMAGE", "View Large Image");
} else {
$this->ObTpl->set_var("TPL_VAR_VIEWLARGEIMAGE", "");
}
} else {
$this->ObTpl->set_var("TPL_VAR_VIEWLARGEIMAGE", "");
}
#IMAGE GALLERY
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
$imagearray = explode(",", $rowHead[0]->tImages);
$imagecount = count($imagearray);
if ($imagecount > 0) {
for ($i = 0; $i < $imagecount; $i++) {
if ($imagearray[$i] != "") {
$content[$i] = SITE_URL . "libs/timthumb.php?src=/images/product/" . $imagearray[$i] . "&h=" . GALLERY_LARGEHEIGHT . "&w=" . GALLERY_LARGEWIDTH . "&zc=1 alt='" . $imagearray[$i] . "'";
$hidden[$i] = "<input type=\"hidden\" id=\"hidden" . $i . "\" value=\"{TPL_VAR_CONTENT" . $i . "}\"><br />";
$this->ObTpl->set_var("TPL_VAR_HIDDEN", $hidden[$i]);
$this->ObTpl->set_var("TPL_VAR_CONTENT" . $i, $content[$i]);
$this->ObTpl->parse("hidden_blk", "TPL_HIDDEN_BLK", true);
}
}
for ($i = 0; $i < $imagecount; $i++) {
if ($imagearray[$i] != "") {
if ($this->libFunc->m_checkFileExist($imagearray[$i], "product")) {
$this->ObTpl->set_var("TPL_VAR_IMAGE_URL", "<img src='" . SITE_URL . "libs/timthumb.php?src=/images/product/" . $imagearray[$i] . "&h=" . GALLERY_THUMBNAILHEIGHT . "&w=" . GALLERY_THUMBNAILWIDTH . "&zc=1' alt='" . $imagearray[$i] . "' />");
$this->ObTpl->set_var("imagenumber", "imagenumber" . $i);
$this->ObTpl->set_var("TPL_VAR_IMAGENUMBER", $i);
$this->ObTpl->set_var("TPL_VAR_THUMBNAILIMAGE", "/images/product/" . $imagearray[$i]);
$this->ObTpl->parse("image_list_blk", "TPL_IMAGE_LIST_BLK", true);
}
}
}
$this->ObTpl->parse("image_gallery_blk", "TPL_IMAGE_GALLERY_BLK");
}
if ($rowHead[0]->iSale == 1) {
$this->ObTpl->set_var("TPL_VAR_ONSALE", "<p class=\"onSale\">On Sale</p>");
$this->ObTpl->parse("onsalelbl_blk", "TPL_ONSALELBL_BLK");
}
if (!$this->libFunc->m_isNull($rowHead[0]->vShipNotes)) {
$this->ObTpl->set_var("TPL_VAR_SHIPNOTES", "<p>" . $this->libFunc->m_displayContent($rowHead[0]->vShipNotes) . "</p>");
}
#CHECK TO DISPLAY WISHLIST - MANAGED BY ADMIN
if (USEWISHLIST == 1) {
##WISHLIST URL
$wishListUrl = SITE_URL . "ecom/index.php?action=wishlist.add&mode=" . $rowHead[0]->iProdid_PK;
$this->ObTpl->set_var("TPL_VAR_WISHLISTLINK", $this->libFunc->m_safeUrl($wishListUrl));
$this->ObTpl->parse("wishlist_blk", "TPL_WISHLIST_BLK");
}
#CHECK TO DISPLAY COMPARELIST - MANAGED BY ADMIN
if (USECOMPARE == 1) {
$compareListUrl = SITE_URL . "ecom/index.php?action=compare.add&mode=" . $rowHead[0]->iProdid_PK;
$this->ObTpl->set_var("TPL_VAR_COMPARELINK", $this->libFunc->m_safeUrl($compareListUrl));
$this->ObTpl->parse("compare_blk", "TPL_COMPARE_BLK");
}
##OVERALL PRODUCT STAR RANKING
$this->obDb->query = "SELECT SUM(vRank) as total, COUNT(iItemid_FK) as reviewcount FROM " . REVIEWS . " WHERE iItemid_FK ='" . $rowHead[0]->iProdid_PK . "'";
$OverallReviewRating = $this->obDb->fetchQuery();
$ReviewRating = $OverallReviewRating[0]->total / $OverallReviewRating[0]->reviewcount;
$ReviewRating = number_format($ReviewRating, 0, '.', '');
switch ($ReviewRating) {
case "0":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating0\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "1":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating1\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "2":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating2\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "3":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating3\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "4":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating4\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "5":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating5\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "6":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating6\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "7":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating7\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "8":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating8\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "9":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating9\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
case "10":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating10\">" . $OverallReviewRating[0]->reviewcount . " reviews</p>");
break;
}
#TO DISPLAY QUANTITY
if (STOCK_CHECK == 1 && $rowHead[0]->iUseinventory == 1) {
$this->ObTpl->set_var("TPL_VAR_QTY", $this->libFunc->m_displayContent($rowHead[0]->iInventory));
$this->ObTpl->parse("qty_blk", "TPL_QTY_BLK");
}
#TO CHECK FREE POSTAGE
if ($rowHead[0]->iFreeShip == 1) {
$this->ObTpl->set_var("TPL_VAR_FREEPOSTAGE", "<p>" . LBL_FREEPP . "</p>");
}
#TO DISPLAY SUPPLIER LOGO
if ($rowHead[0]->iVendorid_FK != 0) {
$this->obDb->query = "SELECT vImage,vCompany FROM " . SUPPLIERS . " WHERE iVendorid_PK='" . $rowHead[0]->iVendorid_FK . "'";
$rowImage = $this->obDb->fetchQuery();
#DISPLAY IMAGE/NAME
$img = $this->libFunc->m_checkFile($rowImage[0]->vImage, "suppliers", "Supplier " . $this->libFunc->m_displayContent($rowImage[0]->vCompany));
$this->ObTpl->set_var("TPL_VAR_SUPPLIERIMAGE", $img);
$this->ObTpl->set_var("TPL_VAR_SUPPLIERNAME", $this->libFunc->m_displayContent($rowImage[0]->vCompany));
$this->ObTpl->parse("supplierimg_blk", "TPL_SUPPLIERIMG_BLK");
}
#*******************DISPLAY MAIN PRODUCT*****************************
##CHECK FOR RRP PRICE
if (!$this->libFunc->m_isNull($rowHead[0]->fListPrice) && $rowHead[0]->fListPrice > 0) {
$this->ObTpl->set_var("TPL_VAR_RRP", RRP_TEXT . " <strike>" . CONST_CURRENCY . number_format($rowHead[0]->fListPrice, 2, '.', '') . "</strike>");
$this->ObTpl->parse("rrplbl_blk", "TPL_RRPLBL_BLK");
}
##CHECK FOR BASKET BUTTON
if ($rowHead[0]->iCartButton == 1) {
$cartUrl = SITE_URL . "ecom/index.php?action=ecom.addtocart";
$this->ObTpl->set_var("TPL_VAR_CARTLINK", $this->libFunc->m_safeUrl($cartUrl));
$this->ObTpl->parse("basket_blk", "TPL_BASKET_BLK");
}
if ($rowHead[0]->iEnquiryButton == 1) {
##ENQUIRY URL
$enquiryUrl = SITE_URL . "ecom/index.php?action=enquiry.dspForm&mode=" . $rowHead[0]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_ENQUIRYLINK", $this->libFunc->m_safeUrl($enquiryUrl));
$this->ObTpl->parse("enquiry_blk", "TPL_ENQUIRY_BLK");
}
#*****DETAILS FOR SELECT PRODUCT / KIT
$this->ObTpl->set_var("TPL_VAR_MAINID", $rowHead[0]->iProdid_PK);
$this->ObTpl->set_var("TPL_VAR_SEOTITLE", $this->libFunc->m_displayContent($rowHead[0]->vSeoTitle));
$this->ObTpl->set_var("TPL_VAR_QTY", $this->libFunc->m_displayContent($rowHead[0]->iInventory));
#TO DISPLAY DESCRIPTION
if (!$this->libFunc->m_isNull($rowHead[0]->tContent)) {
$this->ObTpl->set_var("TPL_VAR_LONGDESCMAIN", $this->libFunc->m_displayContent1($rowHead[0]->tContent));
$this->ObTpl->parse("pdetail_blk", "TPL_PDETAILS_BLK");
}
if (!$this->libFunc->m_isNull($rowHead[0]->tShortDescription)) {
$this->ObTpl->set_var("TPL_VAR_SHORTDESCMAIN", $this->libFunc->m_displayContent($rowHead[0]->tShortDescription));
} else {
$this->ObTpl->set_var("TPL_VAR_SHORTDESCMAIN", "");
}
#PRODUCT ID FOR COMMON FUNCTION CLASS
$comFunc->productId = $rowHead[0]->iProdid_PK;
#CHECKING WHEATHER SELECTED PRODUCT IS KIT OR NOT
#IF YES THEN NO CHOICES AND OPTIONS TO DISPLAY ARE ALL THE PRODUCTS IN KIT
#IF NO ALL CHOICES AND OPTIONS FOR SELECTED PRODUCT TO DISPALY
if ($rowHead[0]->iKit == 1 && $this->kitBlk == 1) {
$this->obDb->query = "SELECT iProdId_FK,iQty,vTitle,vSeoTitle FROM " . PRODUCTKITS . "," . PRODUCTS . " WHERE iProdId_FK=iProdId_PK AND iKitId ='" . $rowHead[0]->iProdid_PK . "'";
$rsKit = $this->obDb->fetchQuery();
$rsKitCount = $this->obDb->record_count;
if ($rsKitCount > 0) {
for ($i = 0; $i < $rsKitCount; $i++) {
$kitElementUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rsKit[$i]->vSeoTitle;
$comFunc->productId = $rsKit[$i]->iProdId_FK;
#GET OPTIONS**************************************************
$this->ObTpl->set_var("TPL_VAR_OPTIONS", $comFunc->m_getOptions('1'));
$this->ObTpl->set_var("TPL_VAR_KITELEMENT_URL", $this->libFunc->m_safeUrl($kitElementUrl));
$this->ObTpl->set_var("TPL_VAR_KITELEMENT", $this->libFunc->m_displayContent($rsKit[$i]->vTitle));
$this->ObTpl->set_var("TPL_VAR_QTY", $rsKit[$i]->iQty);
$this->ObTpl->parse("kitElement_blk", "TPL_KITELEMENT_BLK", true);
}
#END FOR I LOOP
$this->ObTpl->parse("kit_blk", "TPL_KIT_BLK");
}
#END IF
} else {
#GET OPTIONS
$this->ObTpl->set_var("TPL_VAR_MAINOPTIONS", $comFunc->m_getOptions('0'));
#GET CHOICES
$this->ObTpl->set_var("TPL_VAR_MAINCHOICES", $comFunc->m_getChoices());
}
#GET DISCOUNTS
$this->ObTpl->set_var("TPL_VAR_VOLDISCOUNTS", $comFunc->m_getVolDiscount());
#DISPLAY PRODUCT ATTRIBUTE
$this->obDb->query = "SELECT * FROM " . PRODUCTATTRIBUTES . " WHERE iProductid_FK ='" . $rowHead[0]->iProdid_PK . "'";
$attributerow = $this->obDb->fetchQuery();
$attcount = $this->obDb->record_count;
if ($attcount > 0) {
$this->obDb->query = "SELECT A.*,AV.* FROM " . ATTRIBUTES . " A INNER JOIN " . ATTRIBUTEVALUES . " as AV ON AV.iAttributesid_FK = A.iAttributesid_PK WHERE A.iAttributesid_PK = " . $attributerow[0]->iAttributeid_FK;
$attribute = $this->obDb->fetchQuery();
if ($attribute[0]->vAttributeTitle != "") {
$this->ObTpl->set_var("TPL_VAR_ATTRIBUTETITLE", $attribute[0]->vAttributeTitle);
//$attdesc = explode("<!>",$attribute[0]->tValues);
$attfieldname = explode("<!>", $attribute[0]->vFieldname);
$prefix = explode("<!>", $this->libFunc->m_displayContent2($attribute[0]->vPrefix));
$suffix = explode("<!>", $attribute[0]->vSuffix);
for ($i = 0; $i < $attribute[0]->iFieldnumber; $i++) {
$this->ObTpl->set_var("TPL_VAR_FILEDNAME", $attfieldname[$i]);
$this->ObTpl->set_var("TPL_VAR_FIELDVALUE", $attribute[$i]->tValues);
$this->ObTpl->set_var("TPL_VAR_PREFIX", $this->libFunc->m_displayContent2($prefix[$i]));
$this->ObTpl->set_var("TPL_VAR_SUFFIX", $this->libFunc->m_displayContent2($suffix[$i]));
$this->ObTpl->parse("attributefield_blk", "TPL_ATTRIBUTEFIELD_BLK", true);
}
#DISPLAY PRODUCT IDS AND WIDTH/HEIGHT/DEPTH
if (!empty($rowHead[0]->fItemWidth)) {
$this->ObTpl->set_var("TPL_VAR_ITEM_WIDTH", $rowHead[0]->fItemWidth);
$this->ObTpl->parse("itemwidth_blk", "TPL_ITEM_WIDTH_BLK");
}
if (!empty($rowHead[0]->fItemHeight)) {
$this->ObTpl->set_var("TPL_VAR_ITEM_HEIGHT", $rowHead[0]->fItemHeight);
$this->ObTpl->parse("itemheight_blk", "TPL_ITEM_HEIGHT_BLK");
}
if (!empty($rowHead[0]->fItemDepth)) {
$this->ObTpl->set_var("TPL_VAR_ITEM_DEPTH", $rowHead[0]->fItemDepth);
$this->ObTpl->parse("itemdepth_blk", "TPL_ITEM_DEPTH_BLK");
}
if (!empty($rowHead[0]->vASIN)) {
$this->ObTpl->set_var("TPL_VAR_ASIN", $rowHead[0]->vASIN);
$this->ObTpl->parse("itemasin_blk", "TPL_ITEM_ASIN_BLK");
}
if (!empty($rowHead[0]->vISBN)) {
$this->ObTpl->set_var("TPL_VAR_ISBN", $rowHead[0]->vISBN);
$this->ObTpl->parse("itemisbn_blk", "TPL_ITEM_ISBN_BLK");
}
if (!empty($rowHead[0]->vMPN)) {
$this->ObTpl->set_var("TPL_VAR_MPN", $rowHead[0]->vMPN);
$this->ObTpl->parse("itemmpn_blk", "TPL_ITEM_MPN_BLK");
}
if (!empty($rowHead[0]->vUPC)) {
$this->ObTpl->set_var("TPL_VAR_UPC", $rowHead[0]->vUPC);
$this->ObTpl->parse("imtemupc_blk", "TPL_ITEM_UPC_BLK");
}
if (!empty($rowHead[0]->vSku)) {
$this->ObTpl->set_var("TPL_VAR_SKU", $rowHead[0]->vSku);
$this->ObTpl->parse("imtemsku_blk", "TPL_ITEM_SKU_BLK");
}
if (!empty($rowHead[0]->fItemWeight)) {
$this->ObTpl->set_var("TPL_VAR_ITEM_WEIGHT", $rowHead[0]->fItemWeight);
$this->ObTpl->parse("imtemweight_blk", "TPL_ITEM_WEIGHT_BLK");
}
$this->ObTpl->parse("attributetable_blk", "TPL_ATTRIBUTETABLE_BLK");
}
}
#DISPALY PRICE FOR SELECTED PRODUCT
$this->ObTpl->set_var("TPL_VAR_PRICEMAIN", $comFunc->m_Format_Price($rowHead[0]->fPrice));
#CHECK CUSTOMER REVIEWS ENABLE /DISABLE MANAGED BY ADMIN
if (CUSTOMER_REVIEWS == 1) {
$reviewFormUrl = SITE_URL . "ecom/index.php?action=ecom.reviewForm&mode=" . $rowHead[0]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_REVIEWFORM", $this->libFunc->m_safeUrl($reviewFormUrl));
$reviewPostUrl = SITE_URL . "ecom/index.php?action=ecom.reviewAdd&mode=" . $rowHead[0]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_REVIEWPOST", $this->libFunc->m_safeUrl($reviewPostUrl));
if ($this->request['action'] == "ecom.reviewForm") {
$this->ObTpl->parse("reviewform_blk", "TPL_REVIEWFORM_BLK");
}
#QUERY TO GET CONTENTS UNDER SELECTED
$this->obDb->query = "SELECT * FROM " . REVIEWS . " WHERE iState=1 AND iItemid_FK='" . $rowHead[0]->iProdid_PK . "'";
$rowContent = $this->obDb->fetchQuery();
$reviewCount = $this->obDb->record_count;
if ($reviewCount > 0) {
for ($i = 0; $i < $reviewCount; $i++) {
$this->ObTpl->set_var("link_blk", "");
$this->ObTpl->set_var("TPL_VAR_DELETE_REVIEWURL", "");
if (isset($_SESSION['uid']) && isset($_SESSION['uname']) && !$this->libFunc->m_isNull($_SESSION['uid'])) {
$deleteReviewUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.deletereview&mode=" . $rowContent[$i]->iCustRevid_PK . "&id=" . $rowHead[0]->iProdid_PK);
$this->ObTpl->set_var("TPL_VAR_DELETE_REVIEWURL", "<p class=\"deleteReview\">[ <a href='" . $deleteReviewUrl . "'>DELETE</a> ]</p>");
} else {
$this->ObTpl->set_var("TPL_VAR_DELETE_REVIEWURL", "");
}
$helpUrl = SITE_URL . "ecom/index.php?action=ecom.help&mode=" . $rowContent[$i]->iCustRevid_PK . "&id=" . $rowHead[0]->iProdid_PK;
$this->ObTpl->set_var("TPL_VAR_HELPURL", $this->libFunc->m_safeUrl($helpUrl));
$noHelpUrl = SITE_URL . "ecom/index.php?action=ecom.noHelp&mode=" . $rowContent[$i]->iCustRevid_PK . "&id=" . $rowHead[0]->iProdid_PK;
$this->ObTpl->set_var("TPL_VAR_NOHELPURL", $this->libFunc->m_safeUrl($noHelpUrl));
$this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rowContent[$i]->vTitle));
$this->ObTpl->set_var("TPL_VAR_COMMENT", $this->libFunc->m_displayContent($rowContent[$i]->vComment));
$this->ObTpl->set_var("TPL_VAR_DATE", trim($this->libFunc->dateFormat2($rowContent[$i]->tmDateAdd)));
##OVERALL PRODUCT STAR RANKING
$this->obDb->query = "SELECT SUM(vRank) as total, COUNT(iItemid_FK) as reviewcount FROM " . REVIEWS . " WHERE iItemid_FK ='" . $rowHead[0]->iProdid_PK . "'";
$OverallReviewRating = $this->obDb->fetchQuery();
$ReviewRating = $OverallReviewRating[0]->total / $OverallReviewRating[0]->reviewcount;
$ReviewRating = number_format($ReviewRating, 0, '.', '');
switch ($rowContent[$i]->vRank) {
case "0":
$this->ObTpl->set_var("TPL_VAR_OVERALLRANK", "<p class=\"review rating0\"><strong>Rating: 1/10</strong></p>");
break;
case "1":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating1\"><strong>Rating: 1/10</strong></p>");
break;
case "2":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating2\"><strong>Rating: 2/10</p></strong>");
break;
case "3":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating3\"><strong>Rating: 3/10</p></strong>");
break;
case "4":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating4\"><strong>Rating: 4/10</strong></p>");
break;
case "5":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating5\"><strong>Rating: 5/10</strong></p>");
break;
case "6":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating6\"><strong>Rating: 6/10</strong></p>");
break;
case "7":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating7\"><strong>Rating: 7/10</strong></p>");
break;
case "8":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating8\"><strong>Rating: 8/10</strong></p>");
break;
case "9":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating9\"><strong>Rating: 9/10</p></strong>");
break;
case "10":
$this->ObTpl->set_var("TPL_VAR_RANK", "<p class=\"review rating10\"><strong>Rating: 10/10</strong></p>");
break;
}
if (isset($_SESSION['userid'])) {
$this->obDb->query = "SELECT COUNT(*) as cnt FROM " . REVIEWHELP . " WHERE iCustId_FK='" . $_SESSION['userid'] . "' AND iReviewId_FK='" . $rowContent[$i]->iCustRevid_PK . "'";
$rs = $this->obDb->fetchQuery();
if ($rs[0]->cnt == 0) {
$this->ObTpl->parse("link_blk", "TPL_LINK_BLK");
}
}
$this->obDb->query = "SELECT COUNT(*) as cnt FROM " . REVIEWHELP . " WHERE iReviewId_FK='" . $rowContent[$i]->iCustRevid_PK . "'";
$rsCnt = $this->obDb->fetchQuery();
$this->obDb->query = "SELECT COUNT(*) as cnt FROM " . REVIEWHELP . " WHERE iReviewId_FK='" . $rowContent[$i]->iCustRevid_PK . "' AND iStatus=1";
$rsCntYes = $this->obDb->fetchQuery();
#CHECK WHEATHER DISPLAY NAME OR NOT
if (!$this->libFunc->m_isNull($rowContent[$i]->iDisplay)) {
$this->ObTpl->set_var("TPL_VAR_BY", "<p class=\"reviewAuthor\"><strong>Posted by: " . $this->libFunc->m_displayContent($this->libFunc->m_getName($rowContent[$i]->iCustomerid_FK)) . "</strong></p>");
} else {
$this->ObTpl->set_var("TPL_VAR_BY", "");
}
$this->ObTpl->set_var("TPL_VAR_LBLREVIEW", LBL_REVIEW);
$this->ObTpl->parse("dspreview_blk", "TPL_REVIEW_BLK", true);
}
} else {
$this->ObTpl->set_var("TPL_VAR_LBLREVIEW", LBL_FIRST_REVIEW);
}
$this->ObTpl->parse("reviewrank_blk", "TPL_REVIEWRANK_BLK");
$this->ObTpl->parse("reviewlink_blk", "TPL_REVIEWLINK_BLK", true);
$this->ObTpl->parse("reviewcontainer_blk", "TPL_REVIEWCONTAINER_BLK");
}
#FUNCTION TO DISPLAY ATTACHED PRODUCT LIST
$this->m_attachedProduct($rowHead[0]->iProdid_PK, "product");
#FUNCTION TO DISPLAY ATTACHED CONTENT LIST
$this->m_dspAttachedContent($rowHead[0]->iProdid_PK, "product");
return $this->ObTpl->parse("return", "TPL_DETAILS_FILE");
}
