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"); }