function m_addProductForm() { $comFunc = new c_commonFunctions(); $comFunc->obDb = $this->obDb; $this->ObTpl = new template(); $this->ObTpl->set_file("TPL_ADDPRODUCT_FILE", $this->addTemplate); $this->ObTpl->set_block("TPL_ADDPRODUCT_FILE", "TPL_KIT_BLK", "kit_blk"); $this->ObTpl->set_block("TPL_KIT_BLK", "TPL_KITELEMENT_BLK", "kitElement_blk"); if (!isset($this->request['orderid']) || !isset($this->request['productid'])) { $this->libFunc->m_mosRedirect(SITE_URL . "order/adminindex.php?action=orders.home"); exit; } $query = "SELECT vTitle,vSku,fPrice,iKit FROM " . PRODUCTS . " WHERE iProdId_PK='" . $this->request['productid'] . "'"; $this->obDb->query = $query; $queryResult = $this->obDb->fetchQuery(); #SETTING TEMPLATE VARIABLE $this->ObTpl->set_var("TPL_VAR_MAINOPTIONS", ""); $this->ObTpl->set_var("TPL_VAR_MAINCHOICES", ""); $this->ObTpl->set_var("TPL_VAR_ISKIT", "0"); $this->ObTpl->set_var("kit_blk", ""); $this->ObTpl->set_var("kitElement_blk", ""); $this->ObTpl->set_var("GRAPHICSMAINPATH", GRAPHICS_PATH); $this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_URL); $this->ObTpl->set_var("TPL_VAR_ORDERID", $this->request['orderid']); $this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY); $this->ObTpl->set_var("TPL_VAR_PRODUCTID", $this->request['productid']); $this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($queryResult[0]->vSku)); $this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($queryResult[0]->vTitle)); $this->ObTpl->set_var("TPL_VAR_PRICE", number_format($queryResult[0]->fPrice)); #PRODUCT ID FOR COMMON FUNCTION CLASS $comFunc->productId = $this->request['productid']; if ($queryResult[0]->iKit == 1) { $this->ObTpl->set_var("TPL_VAR_ISKIT", "1"); $this->obDb->query = "SELECT iProdId_FK,iQty,vTitle,vSeoTitle,vSku FROM " . PRODUCTKITS . "," . PRODUCTS . " WHERE iProdId_FK=iProdId_PK AND iKitId ='" . $this->request['productid'] . "'"; $rsKit = $this->obDb->fetchQuery(); $rsKitCount = $this->obDb->record_count; if ($rsKitCount > 0) { for ($i = 0; $i < $rsKitCount; $i++) { $this->ObTpl->set_var("TPL_VAR_COUNT", $i + 1); $kitElementUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rsKit[$i]->vSeoTitle; $comFunc->productId = $rsKit[$i]->iProdId_FK; $this->ObTpl->set_var("TPL_VAR_KITSKU", $rsKit[$i]->vSku); $this->ObTpl->set_var("TPL_VAR_QTY", $rsKit[$i]->iQty); #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->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()); } return $this->ObTpl->parse("return", "TPL_ADDPRODUCT_FILE"); }
function m_attachedProduct($ownerId, $ownerType) { $comFunc = new c_commonFunctions(); $comFunc->obDb = $this->obDb; $attCondition = ""; if ($this->request['sort'] == 'attribute') { $this->ObTpl->set_var("TPL_VAR_ATTRIBUTESELECTED", "class=\"selected\""); $attCondition = " AND iAttrValueId_FK <> 0 "; } else { $this->ObTpl->set_var("TPL_VAR_OPTIONSELECTED", "class=\"selected\""); } if (isset($this->request['listview']) && $this->request['listview'] == "gridview") { $_SESSION['listview'] = $this->request['listview']; } else { unset($_SESSION['listview']); } if ($_SESSION['listview'] == "gridview") { $this->ObTpl->set_var("TPL_VAR_PRODUCTCLASS", "class=\"products grid\""); $this->ObTpl->set_var("TPL_VAR_IMGONLYSELECTED", "selected"); } else { $this->ObTpl->set_var("TPL_VAR_PRODUCTCLASS", "class=\"products\""); } if (!isset($_SESSION['sort'])) { $_SESSION['sort'] = "ORDER BY iSort"; } if (isset($this->request['sortbyprice'])) { if ($this->request['sortbyprice'] == "ASC" || $this->request['sortbyprice'] == "DESC") { $_SESSION['sort'] = "ORDER BY fPrice " . $this->request['sortbyprice']; $_SESSION['pricedirect'] = $this->request['sortbyprice']; unset($_SESSION['alphadirect']); } } if (isset($this->request['alphasort'])) { if ($this->request['alphasort'] == '0') { $_SESSION['sort'] = ""; $_SESSION['alphadirect'] = ""; } elseif ($this->request['alphasort'] == 'ASC') { $_SESSION['sort'] = "ORDER BY vTitle " . $this->request['alphasort']; $_SESSION['alphadirect'] = $this->request['alphasort']; } elseif ($this->request['alphasort'] == 'DESC') { $_SESSION['sort'] = "ORDER BY vTitle " . $this->request['alphasort']; $_SESSION['alphadirect'] = $this->request['alphasort']; } unset($_SESSION['pricedirect']); } if (isset($_SESSION['pricedirect'])) { if ($_SESSION['pricedirect'] == "ASC") { $this->ObTpl->set_var("TPL_VAR_ASC2", "selected = \"selected\""); } if ($_SESSION['pricedirect'] == "DESC") { $this->ObTpl->set_var("TPL_VAR_DESC2", "selected = \"selected\""); } } if (isset($_SESSION['alphadirect'])) { if ($_SESSION['alphadirect'] == "ASC") { $this->ObTpl->set_var("TPL_VAR_ASC1", "selected = \"selected\""); } if ($_SESSION['alphadirect'] == "DESC") { $this->ObTpl->set_var("TPL_VAR_DESC1", "selected = \"selected\""); } } if (isset($this->request['prodperpage']) && $this->request['prodperpage'] != '0' && is_numeric($this->request['prodperpage'])) { $_SESSION['pageSize'] = $this->request['prodperpage']; $this->pageSize = $_SESSION['pageSize']; } elseif (isset($_SESSION['pageSize']) && !empty($_SESSION['pageSize'])) { $this->pageSize = $_SESSION['pageSize']; } if (!isset($this->request['attkey'])) { $query = "SELECT vTitle,iProdid_PK,iAttrValueId_FK,vSeoTitle,tShortDescription,fPrice,fRetailPrice,fListPrice,iTaxable,vImage1,iSale "; $query .= " FROM " . PRODUCTS . " D, " . FUSIONS . " F WHERE iProdid_PK =iSubId_FK AND vtype='product' AND "; $query .= " iOwner_FK='" . $ownerId . "' AND vOwnerType='" . $ownerType . "' AND iState=1 " . $attCondition . $_SESSION['sort']; } else { $query = "SELECT vTitle,iProdid_PK,iAttrValueId_FK,vSeoTitle,tShortDescription,fPrice,fRetailPrice,fListPrice,iTaxable,vImage1,iSale "; $query .= "FROM " . PRODUCTS . ", " . PRODUCTATTRIBUTES . ", " . ATTRIBUTEVALUES; $query .= " WHERE iValueId_PK = iValueid_FK AND iProductid_FK = iProdid_PK"; $query .= " AND tValues LIKE '%?" . $this->request['attkey'] . "?%'"; } $pn = new PrevNext($this->pageTplPath, $this->pageTplFile, $this->obDb); if ($ownerType == "product") { $extraStr = "ecom/index.php?action=ecom.pdetails&mode=" . $this->request['mode']; } elseif ($ownerType == "department") { $extraStr = "ecom/index.php?action=ecom.details&mode=" . $this->request['mode']; } $pn->formno = 1; $navArr = $pn->create($query, $this->pageSize, $extraStr, $this->noPaging); $pn2 = new PrevNext($this->pageTplPath, $this->pageTplFile, $this->obDb); $pn2->formno = 2; $navArr2 = $pn2->create($query, $this->pageSize, $extraStr, $this->noPaging); $rowProduct = $navArr['qryRes']; $totalRecords = $navArr['totalRecs']; $productCount = $navArr['fetchedRecords']; $attributeexistFlag = 0; if ($productCount > 0) { for ($i = 0; $i < $productCount; $i++) { #MARGIN CALCULATOR switch (MARGINSTATUS) { case "increase": $rowProduct[$i]->fPrice = $rowProduct[$i]->fPrice * MARGINPERCENT / 100 + $rowProduct[$i]->fPrice; break; case "decrease": $rowProduct[$i]->fPrice = $rowProduct[$i]->fPrice - $rowProduct[$i]->fPrice * MARGINPERCENT / 100; break; default: $rowProduct[$i]->fPrice = $rowProduct[$i]->fPrice; break; } #END MARGIN CALCULATOR //--- Switch to retail price if Retail customer if ($comFunc->m_checkCustomerType() == 1 && ENABLE_WHOLESALE == 1 && $rowProduct[$i]->fRetailPrice > 0) { $rowProduct[$i]->fPrice = $rowProduct[$i]->fRetailPrice; } //----End switch price # CHECK IF THE DEPARTMENT HAS PRODUCTS WITH ATTRIBUTES if ($rowProduct[$i]->iAttrValueId_FK != 0) { $attributeexistFlag = 1; } # $this->ObTpl->set_var("TPL_VAR_LISTOPTIONS", ""); $this->ObTpl->set_var("TPL_VAR_LISTCHOICES", ""); $this->ObTpl->set_var("TPL_VAR_ONSALE", ""); $this->ObTpl->set_var("rrp_price_blk", ""); $comFunc->productId = $rowProduct[$i]->iProdid_PK; $shopUrl = SITE_URL . "ecom/index.php?action=ecom.addmulticart&mode=" . $rowProduct[$i]->vSeoTitle; $this->ObTpl->set_var("TPL_VAR_SHOPURL", $this->libFunc->m_safeUrl($shopUrl)); if ($rowProduct[$i]->iSale == 1) { $this->ObTpl->set_var("TPL_VAR_ATTACHED_ONSALE", "<p class=\"onSale\">On Sale!</p>"); } else { $this->ObTpl->set_var("TPL_VAR_ATTACHED_ONSALE", ""); } $productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rowProduct[$i]->vSeoTitle; $_SESSION['own'] = $ownerId; $this->ObTpl->set_var("TPL_VAR_PRODUCTURL", $this->libFunc->m_safeUrl($productUrl)); $this->ObTpl->set_var("TPL_VAR_ID", $this->libFunc->m_displayContent($rowProduct[$i]->iProdid_PK)); $this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rowProduct[$i]->vTitle)); ##TO CHECK WHEATHER TO DISPLAY WISHLIST OR NOT MANAGED BY ADMIN if (USEWISHLIST == 1) { //if ($this->request['listview']=="gridview"){ //$this->ObTpl->set_var("attached_wishlist_blk",""); //}else{ $wishListUrl = SITE_URL . "ecom/index.php?action=wishlist.add&mode=" . $rowProduct[$i]->iProdid_PK; $this->ObTpl->set_var("TPL_VAR_ATTACHED_WISHLISTLINK", "<p id=\"addWishlistAttached\"><a href=\"" . $this->libFunc->m_safeUrl($wishListUrl) . "\">Add to Wish List</a></p>"); //$this->ObTpl->parse("attached_wishlist_blk", "TPL_ATTACHED_WISHLIST_BLK"); //} } else { $this->ObTpl->set_var("TPL_VAR_ATTACHED_WISHLISTLINK", ""); } #TO CHECK WHETHER TO DISPLAY COMPARELIST OR NOT MANAGED BY ADMIN if (USECOMPARE == 1) { //if ($this->request['listview']=="gridview"){ //$this->ObTpl->set_var("attached_compare_blk",""); //}else{ $compareListUrl = SITE_URL . "ecom/index.php?action=compare.add&mode=" . $rowProduct[$i]->iProdid_PK; $this->ObTpl->set_var("TPL_VAR_ATTACHED_COMPARELINK", "<p id=\"addComparisonAttached\"><a href=\"" . $this->libFunc->m_safeUrl($compareListUrl) . "\">Add to Comparison List</a></p>"); //$this->ObTpl->parse("attached_compare_blk", "TPL_ATTACHED_COMPARE_BLK"); //} } else { $this->ObTpl->set_var("TPL_VAR_ATTACHED_COMPARELINK", ""); } if ($rowProduct[$i]->tShortDescription != "") { if ($this->request['listview'] == "gridview") { $this->ObTpl->set_var("productdesc_blk", ""); } else { $this->ObTpl->set_var("TPL_VAR_DESC", nl2br($this->libFunc->m_displayContent($rowProduct[$i]->tShortDescription))); $this->ObTpl->parse("productdesc_blk", "TPL_PDESC_BLK"); } } else { if ($this->request['listview'] == "gridview") { $this->ObTpl->set_var("productdesc_blk", ""); } else { $this->ObTpl->set_var("TPL_VAR_DESC", ""); $this->ObTpl->parse("productdesc_blk", "TPL_PDESC_BLK"); } } # MANIPULATE NETGROSS & INC_VAT DISPLAY if ($rowProduct[$i]->iTaxable == 1) { $this->ObTpl->set_var("TPL_VAR_PRICE", $comFunc->m_Format_Price($rowProduct[$i]->fPrice)); } else { $this->ObTpl->set_var("TPL_VAR_PRICE", number_format($rowProduct[$i]->fPrice, 2)); } ##CHECK FOR RRP PRICE if (!$this->libFunc->m_isNull($rowProduct[$i]->fListPrice) && $rowProduct[$i]->fListPrice > 0) { $this->ObTpl->set_var("TPL_VAR_RRP_AMOUNT", RRP_TEXT . ": <strike>" . CONST_CURRENCY . number_format($rowProduct[$i]->fListPrice, 2, '.', '') . "</strike>"); $this->ObTpl->parse("rrp_price_blk", "TPL_RRPPRICE_BLK"); } if (!$this->libFunc->m_isNull($rowProduct[$i]->vImage1)) { $img = $this->libFunc->m_checkFile($rowProduct[$i]->vImage1, "product", $this->libFunc->m_displayContent($rowProduct[$i]->vTitle)); if ($img) { $this->ObTpl->set_var("TPL_VAR_IMG", $img); } else { $this->ObTpl->set_var("TPL_VAR_IMG", MSG_NOIMG); } } else { $this->ObTpl->set_var("TPL_VAR_IMG", MSG_NOIMG); } if (CUSTOMER_REVIEWS == 1) { ##OVERALL PRODUCT STAR RANKING $this->obDb->query = "SELECT SUM(vRank) as total, COUNT(iItemid_FK) as reviewcount FROM " . REVIEWS . " WHERE iItemid_FK ='" . $rowProduct[$i]->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; } $this->ObTpl->parse("reviewrank_blk", "TPL_REVIEWRANK_BLK"); } #GET OPTIONS $this->ObTpl->set_var("TPL_VAR_LISTOPTIONS", $comFunc->m_getOptions('0')); #GET CHOICES $this->ObTpl->set_var("TPL_VAR_LISTCHOICES", $comFunc->m_getChoices()); $this->ObTpl->parse("dspproduct_blk", "TPL_PRODUCT_BLK", true); } # END FOR LOOP # DISPLAY "SORT BY ATTRIBUTES" TAB IF THE DEPARTMENT HAS PRODUCTS WITH ATTRIBUTE if ($attributeexistFlag == 1) { $this->ObTpl->parse("sortattributetab_blk", "TPL_SORTATTRIBUTETAB_BLK"); } if ($this->request["sort"] == "attribute") { $this->ObTpl->parse("sortattribute_blk", "TPL_SORTATTRIBUTE_BLK"); } else { $this->ObTpl->parse("sortoptions_blk", "TPL_SORTOPTIONS_BLK"); } $this->ObTpl->parse("mainproduct_blk", "TPL_MAINPRODUCT_BLK"); } # END IF PRODUCT COUNT > 0 if ($totalRecords > $this->pageSize) { #PAGINATION $this->ObTpl->set_var("PagerBlock1", $navArr['pnContents']); $this->ObTpl->set_var("PagerBlock2", $navArr2['pnContents']); } else { $this->ObTpl->set_var("PagerBlock1", ""); $this->ObTpl->set_var("PagerBlock2", ""); } }