function m_reviewCheckout()
{
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
if (count($_SESSION) == 0) {
$retUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.viewcart");
$this->libFunc->m_mosRedirect($retUrl);
}
#**Start: Reverify if the selected country carries correct shipping charges for international postage**
if ($_SESSION['postagedropdown'] == "1" && DEFAULT_POSTAGE_METHOD == 'zones') {
$postagePacking = $comFunc->m_recalculate_postage($_SESSION['ship_country_id']);
if ($postagePacking[0] != "") {
$_SESSION['postagePrice'] = $postagePacking[0];
if ($postagePacking[1] != "") {
$_SESSION['zoneSpecialDelivery'] = $postagePacking[1];
}
}
}
if ($_SESSION['postagedropdown'] == "1" && DEFAULT_POSTAGE_METHOD == 'cities') {
$postagePacking = $comFunc->m_recalculate_postage($_SESSION['ship_country_id'], $_SESSION['ship_state_id']);
if ($postagePacking[0] != "") {
$_SESSION['postagePrice'] = $postagePacking[0];
if ($postagePacking[1] != "") {
$_SESSION['citySpecialDelivery'] = $postagePacking[1];
}
}
}
#**End: Reverify if the selected country carries correct shipping charges for international postage**
#QUERY TEMPARARY CART & PRODUCT TABLE
$this->obDb->query = "SELECT vTitle,vSeoTitle,fPrice,fRetailPrice,vSku,iQty,iTmpCartId_PK,iProdId_FK,vImage1,";
$this->obDb->query .= "iKit,iGiftWrap,fVolDiscount,iTaxable,fItemWeight,iFreeShip,iOnorder,";
$this->obDb->query .= "vShipCode,vShipNotes,tmDuedate ";
#EXTRA SPACE IN FRONT OF FROM
$this->obDb->query .= " FROM " . TEMPCART . " T," . PRODUCTS . " P WHERE ";
#EXTRA SPACE
$this->obDb->query .= " iProdId_FK=iProdId_PK AND vSessionId='" . SESSIONID . "'";
#FLAG TO INDICATE SEPERATE BACKORDER AND NORMAL ORDER
$_SESSION['backOrderSeperate'] = $this->libFunc->ifSet($_SESSION, 'backOrderSeperate', '0');
#FLAG TO INDICATE WHETHER PROCESSING BACKORDER OR NOT
$_SESSION['backOrderProcess'] = $this->libFunc->ifSet($_SESSION, 'backOrderProcess', '0');
if ($_SESSION['backOrderSeperate'] == 1 && $_SESSION['backOrderProcess'] == 1) {
$this->obDb->query .= " AND T.iBackOrder='1'";
} elseif ($_SESSION['backOrderSeperate'] == 1) {
$this->obDb->query .= " AND T.iBackOrder<>'1'";
}
$rowCart = $this->obDb->fetchQuery();
$rowCartCount = $this->obDb->record_count;
$this->ObTpl = new template();
$this->ObTpl->set_file("TPL_REVIEW_FILE", $this->reviewTemplate);
#SETTING BLOCKS
$this->ObTpl->set_block("TPL_REVIEW_FILE", "TPL_CART_BLK", "cart_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VAR_CARTPRODUCTS", "cartproduct_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_DELIVERY_BLK", "delivery_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_GIFTCERT_BLK", "giftcert_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_DISCOUNT_BLK", "discount_blk");
$this->ObTpl->set_block("TPL_VAR_CARTPRODUCTS", "TPL_KIT_BLK", "kit_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_MPOINTS_BLK", "memberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_CARTWEIGHT_BLK", "cartWeight_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_USEDMEMBERPOINTS_BLK", "usedMemberPoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_COD_BLK", "cod_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_PROMODISCOUNTS_BLK", "promodiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VOLDISCOUNTS_BLK", "volDiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_POSTAGE_BLK", "postage_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VAT_BLK", "vat_blk");
#INTIALIZING
$this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_SAFEURL);
$this->ObTpl->set_var("TPL_VAR_GRAPHICSURL", GRAPHICS_PATH);
$this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY);
$this->ObTpl->set_var("TPL_VAR_VAT", '');
$this->ObTpl->set_var("TPL_VAR_TAXNAME", VAT_TAX_TEXT);
$this->ObTpl->set_var("delivery_blk", "");
$this->ObTpl->set_var("cart_blk", "");
$this->ObTpl->set_var("cartWeight_blk", "");
$this->ObTpl->set_var("giftcert_blk", "");
$this->ObTpl->set_var("discount_blk", "");
$this->ObTpl->set_var("memberpoint_blk", "");
$this->ObTpl->set_var("usedMemberPoint_blk", "");
$this->ObTpl->set_var("promodiscounts_blk", "");
$this->ObTpl->set_var("volDiscounts_blk", "");
$this->ObTpl->set_var("postage_blk", "");
$this->ObTpl->set_var("cod_blk", "");
$this->ObTpl->set_var("gift_blk", "");
$this->ObTpl->set_var("cartproduct_blk", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("vat_blk", "");
$this->ObTpl->set_var("TPL_VAR_MSG", "");
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "");
$this->ObTpl->set_var("TPL_VAR_MESSAGE", "");
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", "");
//defining language variables
$this->ObTpl->set_var("LANG_VAR_REVIEWYOURORDER", LANG_REVIEWORDERTXT);
$this->ObTpl->set_var("LANG_VAR_PAYMENTMETHOD", LANG_PAYMENTMETHODTXT);
$this->ObTpl->set_var("LANG_VAR_POSTAGEMETHOD", LANG_POSTAGEMETHODTXT);
$this->ObTpl->set_var("LANG_VAR_BILLINGADDRESS", LANG_BILLINGADDRESS);
$this->ObTpl->set_var("LANG_VAR_DELIVERYADDRESS", LANG_DELIVERYADDRESS);
$this->ObTpl->set_var("LANG_VAR_QUANTITY", LANG_QUANTITY);
$this->ObTpl->set_var("LANG_VAR_PRODUCT", LANG_PRODUCT);
$this->ObTpl->set_var("LANG_VAR_PRICE", LANG_PRICE);
$this->ObTpl->set_var("LANG_VAR_TOTAL", LANG_TOTAL);
$this->ObTpl->set_var("LANG_VAR_ACCUMULATES", LANG_ACCUMULATE);
$this->ObTpl->set_var("LANG_VAR_MEMPOINTS", LANG_REWARDPOINTS);
$this->ObTpl->set_var("LANG_VAR_SUBTOTAL", LANG_SUBTOTAL);
$this->ObTpl->set_var("LANG_VAR_VOLUME", LANG_VOLUMEDISCOUNT);
$this->ObTpl->set_var("LANG_VAR_PRODUCTWEIGHT", LANG_PRODUCTWEIGT);
$this->ObTpl->set_var("LANG_VAR_VIEWCARTIMAGES", LANG_VIEWCARTIMAGE);
$_SESSION['alt_ship'] = $this->libFunc->ifSet($_SESSION, "alt_ship", 0);
if ($_SESSION['alt_ship'] == 1) {
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", MSG_SAMEASBILLING);
} else {
$this->ObTpl->parse("delivery_blk", "TPL_DELIVERY_BLK");
}
#MESSAGE HANDLING
$mode = $this->libFunc->ifSet($this->request, 'mode', '0');
$mode1 = $this->libFunc->ifSet($this->request, 'mode1', '0');
$hsbcerr = $this->libFunc->ifSet($this->request, 'errhsbc', '0');
$securetraderr = $this->libFunc->ifSet($this->request, 'securetrad', '0');
if ($hsbcerr == 1) {
$msg = $this->hsbcmessages();
$this->ObTpl->set_var("TPL_VAR_MESSAGE", $msg);
} elseif ($mode == 'cancel' || $mode1 == 'cancel') {
$this->ObTpl->set_var("TPL_VAR_MESSAGE", MSG_PAYPAL_CANCEL);
} elseif (!empty($this->errMsg)) {
$this->ObTpl->set_var("TPL_VAR_MESSAGE", $this->errMsg);
}
#FORM URL
$formUrl = $this->libFunc->m_safeUrl(SITE_SAFEURL . "ecom/index.php?action=checkout.saveorder");
$this->ObTpl->set_var("TPL_VAR_FORMURL", $formUrl);
#SETTING BILL STATENAME
if ($this->libFunc->ifSet($_SESSION, 'bill_state_id', '0')) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $_SESSION['bill_state_id'] . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $_SESSION['bill_state']);
}
#SETTING BILL COUNTRY NAME
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $_SESSION['bill_country_id'] . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
#SETTING SHIP STATENAME
if ($this->libFunc->ifSet($_SESSION, 'ship_state_id', '0')) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $_SESSION['ship_state_id'] . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $_SESSION['ship_state']);
}
#SETTING SHIP COUNTRYNAME
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $_SESSION['ship_country_id'] . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
#SETTING BILLLING INFO
$this->ObTpl->set_var("TPL_VAR_FIRSTNAME", $this->libFunc->m_displayContent($_SESSION['first_name']));
$this->ObTpl->set_var("TPL_VAR_LASTNAME", $this->libFunc->m_displayContent($_SESSION['last_name']));
$this->ObTpl->set_var("TPL_VAR_EMAIL", $this->libFunc->m_displayContent($_SESSION['email']));
$this->ObTpl->set_var("TPL_VAR_ADDRESS1", $this->libFunc->m_displayContent($_SESSION['address1']));
$this->ObTpl->set_var("TPL_VAR_ADDRESS2", $this->libFunc->m_displayContent($_SESSION['address2']));
$this->ObTpl->set_var("TPL_VAR_CITY", $this->libFunc->m_displayContent($_SESSION['city']));
$this->ObTpl->set_var("TPL_VAR_ZIP", $this->libFunc->m_displayContent($_SESSION['zip']));
$this->ObTpl->set_var("TPL_VAR_COMPANY", $this->libFunc->m_displayContent($_SESSION['company']));
$this->ObTpl->set_var("TPL_VAR_PHONE", $this->libFunc->m_displayContent($_SESSION['phone']));
$this->ObTpl->set_var("TPL_VAR_HOMEPAGE", $this->libFunc->m_displayContent($_SESSION['company']));
$this->ObTpl->set_var("TPL_VAR_MPOINTS", "");
#SETTING SHIPPING INFO
$this->ObTpl->set_var("TPL_VAR_ALTNAME", $this->libFunc->m_displayContent($_SESSION['alt_name']));
$this->ObTpl->set_var("TPL_VAR_ALTADDR1", $this->libFunc->m_displayContent($_SESSION['alt_address1']));
$this->ObTpl->set_var("TPL_VAR_ALTADDR2", $this->libFunc->m_displayContent($_SESSION['alt_address2']));
$this->ObTpl->set_var("TPL_VAR_ALTCITY", $this->libFunc->m_displayContent($_SESSION['alt_city']));
$this->ObTpl->set_var("TPL_VAR_ALTCOMPANY", $this->libFunc->m_displayContent($_SESSION['alt_company']));
$this->ObTpl->set_var("SHIP_STATE", "");
$this->ObTpl->set_var("TPL_VAR_ALTZIP", $this->libFunc->m_displayContent($_SESSION['alt_zip']));
$this->ObTpl->set_var("TPL_VAR_ALTPHONE", $this->libFunc->m_displayContent($_SESSION['alt_phone']));
#POST VARIABLES**********************************************
$this->request['paymethod'] = $_SESSION['payMethod'];
$_SESSION['payMethod'] = $this->libFunc->ifSet($_SESSION, 'payMethod', 'none');
if ($this->libFunc->ifSet($this->request, 'paymethod', '0')) {
$_SESSION['payMethod'] = $this->request['paymethod'];
}
if ($this->libFunc->ifSet($this->request, 'mail_list', '0')) {
$_SESSION['mail_list'] = $this->request['mail_list'];
}
#PAYMENT METHOD
if ($this->libFunc->ifSet($this->request, 'comments', '0')) {
$_SESSION['comments'] = $this->libFunc->m_displayContent($this->request['comments']);
}
if ($_SESSION['comments'] == 'special requirements') {
$_SESSION['comments'] = '';
}
if ($this->libFunc->ifSet($_SESSION, 'discountCode', '')) {
$discountstring = $comFunc->m_calculateDiscount($_SESSION['discountCode']);
$discountarray = explode(",", $discountstring);
$this->discountPrice = $discountarray[0];
$this->offertype = $discountarray[1];
$this->minAmount = $discountarray[2];
}
if ($this->libFunc->ifSet($_SESSION, 'giftCertCode', '')) {
$this->giftCertPrice = $comFunc->m_calculateGiftCertPrice($_SESSION['giftCertCode']);
}
// Begin Card Holder Protx Modification
if ($this->libFunc->ifSet($this->request, 'cardholder_name', '')) {
$_SESSION['cardholder_name'] = $this->request['cardholder_name'];
} else {
$_SESSION['cardholder_name'] = $this->libFunc->ifSet($_SESSION, 'cardholder_name', '');
}
// End Card Holder Protx Modification
if ($this->libFunc->ifSet($this->request, 'cc_number', '')) {
$_SESSION['cc_number'] = $this->request['cc_number'];
} else {
$_SESSION['cc_number'] = $this->libFunc->ifSet($_SESSION, 'cc_number', '');
}
if ($this->libFunc->ifSet($this->request, 'cc_type', '')) {
$_SESSION['cc_type'] = $this->request['cc_type'];
} else {
$_SESSION['cc_type'] = $this->libFunc->ifSet($_SESSION, 'cc_type', '');
}
if ($this->libFunc->ifSet($this->request, 'cv2', '')) {
$_SESSION['cv2'] = $this->request['cv2'];
} else {
$_SESSION['cv2'] = $this->libFunc->ifSet($_SESSION, 'cv2', '');
}
if ($this->libFunc->ifSet($this->request, 'cc_year', '')) {
$_SESSION['cc_year'] = $this->request['cc_year'];
} else {
$_SESSION['cc_year'] = $this->libFunc->ifSet($_SESSION, 'cc_year', '');
}
if ($this->libFunc->ifSet($this->request, 'cc_month', '0')) {
$_SESSION['cc_month'] = $this->request['cc_month'];
} else {
$_SESSION['cc_month'] = $this->libFunc->ifSet($_SESSION, 'cc_month', '');
}
if ($this->libFunc->ifSet($this->request, 'cc_start_year', '0')) {
$_SESSION['cc_start_year'] = $this->request['cc_start_year'];
} else {
$_SESSION['cc_start_year'] = $this->libFunc->ifSet($_SESSION, 'cc_start_year', '');
}
if ($this->libFunc->ifSet($this->request, 'cc_start_month', '0')) {
$_SESSION['cc_start_month'] = $this->request['cc_start_month'];
} else {
$_SESSION['cc_start_month'] = $this->libFunc->ifSet($_SESSION, 'cc_start_month', '');
}
if ($this->libFunc->ifSet($this->request, 'issuenumber', '0')) {
$_SESSION['issuenumber'] = $this->request['issuenumber'];
} else {
$_SESSION['issuenumber'] = $this->libFunc->ifSet($_SESSION, 'issuenumber', '');
}
if ($this->libFunc->ifSet($this->request, 'acct', '0')) {
$_SESSION['acct'] = $this->request['acct'];
} else {
$_SESSION['acct'] = $this->libFunc->ifSet($_SESSION, 'acct', '0');
}
if ($this->libFunc->ifSet($this->request, 'aba', '0')) {
$_SESSION['aba'] = $this->request['aba'];
} else {
$_SESSION['aba'] = $this->libFunc->ifSet($_SESSION, 'aba', '0');
}
#*************************************************************
$this->ObTpl->set_var("TPL_VAR_PAYMENTMETHOD", $comFunc->m_paymentMethod($_SESSION['payMethod'], $_SESSION['codPrice']));
$this->ObTpl->set_var("TPL_VAR_PAYMETHOD", $_SESSION['payMethod']);
$this->ObTpl->set_var("TPL_VAR_CCNUMBER", $_SESSION['cc_number']);
$this->ObTpl->set_var("TPL_VAR_CCTYPE", $_SESSION['cc_type']);
$this->ObTpl->set_var("TPL_VAR_CV2", $_SESSION['cv2']);
$this->ObTpl->set_var("TPL_VAR_CCYEAR", $_SESSION['cc_year']);
$this->ObTpl->set_var("TPL_VAR_CCMONTH", $_SESSION['cc_month']);
$this->ObTpl->set_var("TPL_VAR_STARTYEAR", $_SESSION['cc_start_year']);
$this->ObTpl->set_var("TPL_VAR_STARTMONTH", $_SESSION['cc_start_month']);
$this->ObTpl->set_var("TPL_VAR_ISSUENUMBER", $_SESSION['issuenumber']);
$this->ObTpl->set_var("TPL_VAR_ACCTNUMBER", $_SESSION['acct']);
$this->ObTpl->set_var("TPL_VAR_ABA_ACCT", $_SESSION['aba']);
#DISPLAY CART PRODUCT
if ($rowCartCount > 0) {
if (!is_null($_SESSION['totalVendor']) && $_SESSION['totalVendor'] > 0) {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", $_SESSION['totalVendor']);
} else {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", "");
}
for ($i = 0; $i < $rowCartCount; $i++) {
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "");
$this->ObTpl->set_var("TPL_VAR_BACKORDER", "");
$this->ObTpl->set_var("TPL_VAR_OPTIONS", "");
$this->ObTpl->set_var("TPL_VAR_CHOICES", "");
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "");
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "");
$this->ObTpl->set_var("TPL_VAR_SHIPNOTES", "");
$this->ObTpl->set_var("kit_blk", "");
$this->price = 0;
#INTIALIZING
$this->total = 0;
#MARGIN CALCULATOR
switch (MARGINSTATUS) {
case "increase":
$rowCart[$i]->fPrice = $rowCart[$i]->fPrice * MARGINPERCENT / 100 + $rowCart[$i]->fPrice;
break;
case "decrease":
$rowCart[$i]->fPrice = $rowCart[$i]->fPrice - $rowCart[$i]->fPrice * MARGINPERCENT / 100;
break;
default:
$rowCart[$i]->fPrice = $rowCart[$i]->fPrice;
break;
}
#END MARGIN CALCULATOR
//--- Switch to retail price if Retail customer
if ($comFunc->m_checkCustomerType() == 1 && ENABLE_WHOLESALE == 1 && $rowCart[$i]->fRetailPrice > 0) {
$rowCart[$i]->fPrice = $rowCart[$i]->fRetailPrice;
}
//----End switch price
#BACK ORDERED
if (isset($_SESSION['backorder'][$rowCart[$i]->iProdId_FK]) && $_SESSION['backorder'][$rowCart[$i]->iProdId_FK] == 1) {
$strBackOrder = "This item is on backorder";
if ($rowCart[$i]->iOnorder > 0) {
$strBackOrder .= "<br />On Order: " . $rowCart[$i]->iOnorder;
}
if (!empty($rowCart[$i]->tmDuedate)) {
$formatedDueDate = $this->libFunc->dateFormat2($rowCart[$i]->tmDuedate);
$strBackOrder .= " (Due date: " . $formatedDueDate . ")";
}
$this->ObTpl->set_var("TPL_VAR_BACKORDER", $strBackOrder);
}
$this->ObTpl->set_var("TPL_VAR_CARTID", $rowCart[$i]->iTmpCartId_PK);
$comFunc->cartId = $rowCart[$i]->iTmpCartId_PK;
#FOR POSTAGE-CODES
$comFunc->productId = $rowCart[$i]->iProdId_FK;
$comFunc->qty = $rowCart[$i]->iQty;
$comFunc->price = $this->price;
##GIFTWRAP URL
if ($rowCart[$i]->iGiftWrap != 0) {
$this->ObTpl->set_var("gift_blk", "");
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", $comFunc->m_dspGiftWrap($rowCart[$i]->iGiftWrap, $rowCart[$i]->iTmpCartId_PK));
} else {
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", "");
$giftWrapUrl = SITE_SAFEURL . "ecom/index.php?action=ecom.giftwrap&mode=" . $rowCart[$i]->iTmpCartId_PK;
$this->ObTpl->set_var("TPL_VAR_GIFTWRAPURL", $this->libFunc->m_safeUrl($giftWrapUrl));
$this->ObTpl->parse("gift_blk", "TPL_GIFTWRAP_BLK");
}
if ($rowCart[$i]->iKit == 1) {
$this->obDb->query = "SELECT vTitle,iProdId_FK,vSku FROM " . PRODUCTKITS . "," . PRODUCTS . " WHERE iProdId_FK=iProdId_PK AND iKitId='" . $rowCart[$i]->iProdId_FK . "'";
$rsKit = $this->obDb->fetchQuery();
$rsKitCount = $this->obDb->record_count;
for ($j = 0; $j < $rsKitCount; $j++) {
$comFunc->kitProductId = $rsKit[$j]->iProdId_FK;
#GET KIT OPTIONS
$kitOptions = $comFunc->m_dspCartProductKitOptions();
if ($kitOptions == ' ') {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", "");
} else {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", $kitOptions);
}
$this->ObTpl->set_var("TPL_VAR_KITSKU", $this->libFunc->m_displayContent($rsKit[$j]->vSku));
$this->ObTpl->set_var("TPL_VAR_KITTITLE", $this->libFunc->m_displayContent($rsKit[$j]->vTitle));
$this->ObTpl->parse("kit_blk", "TPL_KIT_BLK", true);
}
} else {
#GET CART OPTIONS
$this->ObTpl->set_var("TPL_VAR_OPTIONS", $comFunc->m_dspCartProductOptions());
#GET CART CHOICES
$this->ObTpl->set_var("TPL_VAR_CHOICES", $comFunc->m_dspCartProductChoices());
}
# (OPTION And choice effected amount)
$this->price = $comFunc->price;
#VOLUME DISCOUNT**************************************************
#DISCOUNT ACCORDING TO QTY
$vDiscoutPerItem = number_format($rowCart[$i]->fVolDiscount, 2, '.', '');
if ($vDiscoutPerItem > 0) {
$vDiscountPerCartElement = number_format($rowCart[$i]->iQty * $vDiscoutPerItem, 2, '.', '');
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "Volume Discount: " . CONST_CURRENCY . $vDiscoutPerItem . " each - Total: " . CONST_CURRENCY . $vDiscountPerCartElement . "<br />");
$this->volDiscount = $this->volDiscount + $vDiscountPerCartElement;
}
$this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rowCart[$i]->vTitle));
//$this->ObTpl->set_var("TPL_VAR_CARTIMAGE",$this->libFunc->m_displayContent($rowCart[$i]->vImage1));
if ($this->libFunc->m_displayContent($rowCart[$i]->vImage1) != "") {
$this->ObTpl->set_var("TPL_VAR_CARTIMAGE_TAG", "<img src=\"" . SITE_SAFEURL . "libs/timthumb.php?src=/images/product/" . $this->libFunc->m_displayContent($rowCart[$i]->vImage1) . "&h=70&w=70&zc=r\" alt=\"" . $this->libFunc->m_displayContent($rowCart[$i]->vTitle) . "\" />");
} else {
$this->ObTpl->set_var("TPL_VAR_CARTIMAGE_TAG", "No image available");
}
$this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($rowCart[$i]->vSku));
$this->price = $this->price + $rowCart[$i]->fPrice;
$fullprice = $this->price;
if ($rowCart[$i]->iTaxable == 1) {
if (NETGROSS == 1) {
$vatPercent = $this->libFunc->m_vatCalculate();
$actualprice = $this->price * ($vatPercent / 100 + 1);
$vatAmount = $this->price * ($vatPercent / 100) * $rowCart[$i]->iQty;
//$this->price = $actualprice;
}
}
$this->ObTpl->set_var("TPL_VAR_PRICE", number_format($this->price, 2, '.', ''));
$this->ObTpl->set_var("TPL_VAR_QTY", $rowCart[$i]->iQty);
$this->totalQty += $rowCart[$i]->iQty;
$this->total += $rowCart[$i]->iQty * $this->price;
$this->ObTpl->set_var("TPL_VAR_TOTAL", number_format($this->total, 2, '.', ''));
if ($rowCart[$i]->iFreeShip != 1) {
$this->postageTotal += $this->total;
} else {
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "<em>Free P&P</em><br />");
}
if ($rowCart[$i]->iTaxable == 1) {
if (NETGROSS == 1) {
$this->taxTotal += $vatAmount;
} else {
$this->taxTotal += $this->price * $rowCart[$i]->iQty;
}
if ($comFunc->m_checkCustomerType() == 1 && ENABLE_WHOLESALE == 1 && $rowCart[$i]->fRetailPrice > 0) {
$this->taxTotal = $this->taxTotal - ($rowCart[$i]->fPrice - $rowCart[$i]->fRetailPrice) * $rowCart[$i]->iQty;
}
} else {
if (HIDENOVAT != 1) {
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "<em>" . LBL_NOTAX . "</em><br />");
} else {
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "");
}
}
//Quantity Multiplied
if ($rowCart[$i]->fItemWeight > 0) {
$this->cartWeight += $rowCart[$i]->fItemWeight * $rowCart[$i]->iQty;
}
$this->subTotal = $this->subTotal + $this->total;
#SAFE URLS
$removeUrl = SITE_SAFEURL . "ecom/index.php?action=ecom.remove&mode=" . $rowCart[$i]->iTmpCartId_PK;
$this->ObTpl->set_var("TPL_VAR_REMOVEURL", $this->libFunc->m_safeUrl($removeUrl));
$cartUpdateUrl = SITE_SAFEURL . "ecom/index.php?action=ecom.updateCart";
$this->ObTpl->set_var("TPL_VAR_UPDATEURL", $this->libFunc->m_safeUrl($cartUpdateUrl));
$productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rowCart[$i]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_PRODUCTURL", $this->libFunc->m_safeUrl($productUrl));
if (!empty($rowCart[$i]->vShipNotes)) {
$this->ObTpl->set_var("TPL_VAR_SHIPNOTES", "Notes: " . $this->libFunc->m_displayContent($rowCart[$i]->vShipNotes) . "<br />");
}
$this->ObTpl->parse("cartproduct_blk", "TPL_VAR_CARTPRODUCTS", true);
}
//echo $this->taxTotal."<br/>";
$this->ObTpl->set_var("TPL_VAR_SUBTOTAL", number_format($this->subTotal, 2, '.', ''));
$this->grandTotal = $this->subTotal;
#***************MEMBER POINTS ON SUB TOTAL****************
if (OFFERMPOINT == 1) {
$this->memPoints = MPOINTCALCULATION * $this->subTotal;
$_SESSION['memberPointsEarned'] = floor($this->memPoints);
$this->ObTpl->set_var("TPL_VAR_MPOINTS", floor($this->memPoints));
$this->ObTpl->parse("memberpoint_blk", "TPL_MPOINTS_BLK");
}
#************************* PROMOTION DISCOUNTS*********
$this->promotionDiscount = $comFunc->m_calculatePromotionDiscount($this->subTotal);
if ($this->promotionDiscount >= 0) {
if ($this->promotionDiscount == 0) {
$displayDiscount = 'No Charge';
} else {
$displayDiscount = "-" . CONST_CURRENCY . number_format($this->promotionDiscount, 2, '.', '');
}
if (isset($comFunc->PromotionDesc) && !empty($comFunc->PromotionDesc)) {
$this->ObTpl->set_var("TPL_VAR_PROMOTIONDESC", $comFunc->PromotionDesc);
} else {
$this->ObTpl->set_var("TPL_VAR_PROMOTIONDESC", "Promotion Discounts");
}
$this->ObTpl->set_var("TPL_VAR_PDISCOUNTS", $displayDiscount);
$_SESSION['promotionDiscountPrice'] = $this->promotionDiscount;
$this->grandTotal -= $this->promotionDiscount;
$this->taxTotal -= $this->promotionDiscount;
//echo $this->taxTotal."<br/>";
$this->ObTpl->parse("promodiscounts_blk", "TPL_PROMODISCOUNTS_BLK");
} else {
$_SESSION['promotionDiscountPrice'] = 0;
}
if ($this->volDiscount > 0) {
$this->ObTpl->set_var("TPL_VAR_VOLDISCOUNT", number_format($this->volDiscount, 2, '.', ''));
$this->grandTotal -= $this->volDiscount;
$this->taxTotal -= $this->volDiscount;
$this->ObTpl->parse("volDiscounts_blk", "TPL_VOLDISCOUNTS_BLK");
}
#COD PRICE(PAYMENT GATEWAY ADDITIONAL PRICE)
if ($_SESSION['codPrice'] > 0) {
$this->ObTpl->set_var("TPL_VAR_CODPRICE", number_format($_SESSION['codPrice'], 2, '.', ''));
$this->grandTotal += number_format($_SESSION['codPrice'], 2, '.', '');
$this->ObTpl->parse("cod_blk", "TPL_COD_BLK");
}
$this->ObTpl->set_var("TPL_VAR_DISCOUNTCODE", "");
$this->ObTpl->set_var("TPL_VAR_GIFTCODE", "");
#CHECK FOR DISCOUNTS
if ($this->discountPrice != 0) {
if ($this->grandTotal > $this->minAmount) {
if ($this->offertype == "percent") {
$discountedPrice = round($this->discountPrice * ($this->grandTotal / 100), 2);
} else {
if ($this->discountPrice > $this->grandTotal) {
$this->discountPrice = $this->grandTotal;
}
$discountedPrice = round($this->discountPrice, 2);
}
$this->ObTpl->set_var("TPL_VAR_DISCOUNTCODE", "(" . $_SESSION['discountCode'] . ")");
$this->ObTpl->set_var("TPL_VAR_DISCOUNTPRICE", number_format($discountedPrice, 2, '.', ''));
if ($this->taxTotal > 0) {
$this->taxTotal -= $discountedPrice;
$this->grandTotal -= $discountedPrice;
} else {
$this->grandTotal -= $discountedPrice;
//No VAT on order so do not adjust the VAT
}
//echo $this->taxTotal."<br/>";
$_SESSION['discountPrice'] = $discountedPrice;
$this->ObTpl->parse("discount_blk", "TPL_DISCOUNT_BLK");
} else {
$this->ObTpl->set_var("TPL_VAR_DISCOUNTCODE", "(" . $_SESSION['discountCode'] . ") Discount minimum is not reached ");
$this->ObTpl->set_var("TPL_VAR_DISCOUNTPRICE", "0.00");
$this->ObTpl->parse("discount_blk", "TPL_DISCOUNT_BLK");
}
} elseif ($this->libFunc->ifSet($_SESSION, 'discountCode', '0') && $_SESSION['discountCode'] != 'discount code') {
$this->ObTpl->set_var("TPL_VAR_DISCOUNTCODE", "(" . $_SESSION['discountCode'] . ") not found");
$this->ObTpl->set_var("TPL_VAR_DISCOUNTPRICE", "0.00");
$this->ObTpl->parse("discount_blk", "TPL_DISCOUNT_BLK");
}
#CHECK FOR GIFTCERTIFICATES
if ($this->giftCertPrice != 0) {
if ($this->grandTotal < $this->giftCertPrice) {
$this->giftCertPrice = $this->grandTotal;
}
if ($this->grandTotal <= 0) {
$this->giftCertPrice = 0;
$this->grandTotal = 0;
}
$this->taxTotal -= $this->giftCertPrice;
//echo $this->taxTotal."<br/>";
$this->grandTotal -= $this->giftCertPrice;
$_SESSION['giftCertPrice'] = $this->giftCertPrice;
$this->ObTpl->set_var("TPL_VAR_GIFTCERTPRICE", number_format($this->giftCertPrice, 2, '.', ''));
$this->ObTpl->parse("giftcert_blk", "TPL_GIFTCERT_BLK");
} elseif ($this->libFunc->ifSet($_SESSION, 'giftCertCode', '0') && $_SESSION['giftCertCode'] != 'gift certificate number') {
$this->ObTpl->set_var("TPL_VAR_GIFTCODE", "(" . $_SESSION['giftCertCode'] . ") not found");
$this->ObTpl->set_var("TPL_VAR_GIFTCERTPRICE", "0.00");
$this->ObTpl->parse("giftcert_blk", "TPL_GIFTCERT_BLK");
}
#TO USE MEMBER POINTS*****************************************
if (isset($_SESSION['useMemberPoints']) && $_SESSION['useMemberPoints'] == 'yes' && OFFERMPOINT == 1) {
//Get the total points that will be enough to use in order.
## OrderAmount = 100
## PointValue = 5
## TotalPointsEnough = 20
//Deduct only these points on checkout process and leave the rest of the points
if (MPOINTVALUE > 0) {
$pointsRequired = $this->grandTotal / MPOINTVALUE;
} else {
$pointsRequired = 0;
}
if ($_SESSION['memberPoints'] >= $pointsRequired) {
$_SESSION['usedMemberPoints'] = $pointsRequired;
} else {
$_SESSION['usedMemberPoints'] = $_SESSION['memberPoints'];
}
#Amount using member Points
$_SESSION['memberPointsUsedAmount'] = $_SESSION['usedMemberPoints'] * MPOINTVALUE;
#SETTING TEMPLATE VARIABLE FOR MEMBER POINTS
if (isset($_SESSION['memberPointsUsedAmount']) && isset($_SESSION['usedMemberPoints'])) {
$this->ObTpl->set_var("TPL_VAR_MPOINTSAVAIABLE", floor($_SESSION['usedMemberPoints']));
$this->ObTpl->set_var("TPL_VAR_MPOINTSPRICE", number_format($_SESSION['memberPointsUsedAmount'], 2, '.', ''));
#Modified Total
$this->grandTotal -= $_SESSION['memberPointsUsedAmount'];
#SUBTRACTING MEMBERPOINTS
$this->taxTotal -= $_SESSION['memberPointsUsedAmount'];
//echo $this->taxTotal."<br/>";
$this->ObTpl->parse("usedMemberPoint_blk", "TPL_USEDMEMBERPOINTS_BLK");
}
}
if ($this->taxTotal < 0) {
$this->taxTotal = 0;
}
#POSTAGE CALCULATION**************************
$this->ObTpl->set_var("TPL_VAR_POSTAGEPRICE", number_format($_SESSION['postagePrice2'], 2, '.', ''));
$this->grandTotal += $_SESSION['postagePrice2'];
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", $_SESSION['postagemethodname']);
$this->ObTpl->parse("postage_blk", "TPL_POSTAGE_BLK");
$temp = $comFunc->m_Calculate_Tax($this->taxTotal, $_SESSION['postagePrice2'], $_SESSION['ship_country_id'], $_SESSION['ship_state_id']);
$this->vatTotal = $temp[0];
$this->ObTpl->set_var("TPL_VAR_VAT", $temp[1]);
if ($this->vatTotal > 0) {
$this->ObTpl->set_var("TPL_VAR_VATPRICE", number_format($this->vatTotal, 2, '.', ''));
$this->grandTotal += $this->vatTotal;
$this->ObTpl->parse("vat_blk", "TPL_VAT_BLK");
}
$_SESSION['vatTotal'] = $this->vatTotal;
$_SESSION['VAT'] = $temp[1];
$_SESSION['totalQty'] = $this->totalQty;
$this->grandTotal = ceil($this->grandTotal * 1000) / 1000;
$_SESSION['grandTotal'] = $this->grandTotal;
$this->ObTpl->set_var("TPL_VAR_CURRENTTOTAL", number_format($this->grandTotal, 2, '.', ''));
$this->ObTpl->parse("cart_blk", "TPL_CART_BLK");
} else {
$returnUrl = SITE_URL . "index.php";
$this->ObTpl->set_var("TPL_VAR_MSG", MSG_CART_EMPTY . " <a href=" . $this->libFunc->m_safeUrl($returnUrl) . ">" . MSG_RETURN . "</a>");
}
return $this->ObTpl->parse("return", "TPL_REVIEW_FILE");
}
function m_sendOrdersDetails()
{
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
#INTIALIZING TEMPLATES
$this->ObTpl = new template();
$this->ObTpl->set_file("TPL_ORDERMAIL_FILE", MODULES_PATH . "order/templates/admin/orderMailDownload.tpl.htm");
#SETTING BLOCKS
$this->ObTpl->set_block("TPL_ORDERMAIL_FILE", "TPL_CART_BLK", "cart_blk");
$this->ObTpl->set_block("TPL_ORDERMAIL_FILE", "TPL_DELIVERY_BLK", "delivery_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VAR_CARTPRODUCTS", "cartproduct_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_GIFTCERT_BLK", "giftcert_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_DISCOUNT_BLK", "discount_blk");
$this->ObTpl->set_block("TPL_VAR_CARTPRODUCTS", "TPL_KIT_BLK", "kit_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_COD_BLK", "cod_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_PROMODISCOUNTS_BLK", "promodiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VOLDISCOUNTS_BLK", "volDiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_POSTAGE_BLK", "postage_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_MPOINTS_BLK", "memberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_EMPOINTS_BLK", "earnedmemberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_TMPOINTS_BLK", "totalmemberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_CARTWEIGHT_BLK", "cartWeight_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VAT_BLK", "vat_blk");
#INTIALIZING
$this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_SAFEURL);
$this->ObTpl->set_var("TPL_VAR_GRAPHICSURL", GRAPHICS_PATH);
$this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY);
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "");
#INTAILAIZING
$this->ObTpl->set_var("delivery_blk", "");
$this->ObTpl->set_var("cart_blk", "");
$this->ObTpl->set_var("cartWeight_blk", "");
$this->ObTpl->set_var("giftcert_blk", "");
$this->ObTpl->set_var("discount_blk", "");
$this->ObTpl->set_var("cartproduct_blk", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("promodiscounts_blk", "");
$this->ObTpl->set_var("volDiscounts_blk", "");
$this->ObTpl->set_var("postage_blk", "");
$this->ObTpl->set_var("cod_blk", "");
$this->ObTpl->set_var("memberpoint_blk", "");
$this->ObTpl->set_var("earnedmemberpoint_blk", "");
$this->ObTpl->set_var("totalmemberpoint_blk", "");
$this->ObTpl->set_var("vat_blk", "");
$this->ObTpl->set_var("TPL_VAR_MSG", "");
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", "");
$this->ObTpl->set_var("TPL_VAR_COMPANY_DETAILS", $comFunc->m_mailFooter());
$downloadVariable = "";
#QUERY ORDER TABLE
$this->obDb->query = "SELECT tmOrderDate,vPayMethod,vShipDescription,fShipTotal,";
$this->obDb->query .= "vFirstName,vLastName,vEmail,vAddress1,vAddress2,vCity,iInvoice,";
$this->obDb->query .= "vState,vStateName,vCountry,vZip,vCompany,vPhone,vHomepage,";
$this->obDb->query .= "vAltName,vAltAddress1,vAltAddress2,vAltCity,vAltState,vAltCountry,";
$this->obDb->query .= "vAltStateName,vAltZip,vAltPhone,fCodCharge,fPromoValue,";
$this->obDb->query .= "vDiscountCode,fDiscount,iGiftcert_FK,fGiftcertTotal,fMemberPoints,";
$this->obDb->query .= "fShipByWeightPrice,fShipByWeightKg,iSameAsBilling,";
$this->obDb->query .= "fTaxRate,fTaxPrice,tComments,vStatus,iPayStatus,fTotalPrice,iEarnedPoints,iCustomerid_FK";
$this->obDb->query .= " FROM " . ORDERS . " WHERE iOrderid_PK='" . $this->request['orderid'] . "'";
$qryResult = $this->obDb->fetchQuery();
//echo "<pre>";print_r($qryResult);exit;
$rCount = $this->obDb->record_count;
if ($rCount != 1) {
$errrorUrl = SITE_URL . "index.php?action=error&mode=order";
$this->libFunc->m_mosRedirect($this->libFunc->m_safeUrl($errrorUrl));
}
if ($rCount > 0) {
$this->ObTpl->set_var("TPL_VAR_INVOICE", $qryResult[0]->iInvoice);
$this->ObTpl->set_var("TPL_VAR_ORDERDATE", $this->libFunc->dateFormat2($qryResult[0]->tmOrderDate));
if ($qryResult[0]->vPayMethod == 'cod') {
$vPayMethod = $comFunc->m_paymentMethod($qryResult[0]->vPayMethod, $qryResult[0]->fCodCharge);
} else {
$vPayMethod = $comFunc->m_paymentMethod($qryResult[0]->vPayMethod);
}
$this->ObTpl->set_var("TPL_VAR_PAYMENTMETHOD", $vPayMethod);
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", $qryResult[0]->vShipDescription);
$this->ObTpl->set_var("TPL_VAR_ORDERSTATUS", $this->request['status']);
if (empty($qryResult[0]->tComments)) {
$this->ObTpl->set_var("TPL_VAR_COMMENTS", "None");
} else {
$this->ObTpl->set_var("TPL_VAR_COMMENTS", $qryResult[0]->tComments);
}
if (isset($qryResult[0]->vState) && !empty($qryResult[0]->vState)) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $qryResult[0]->vState . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $qryResult[0]->vStateName);
}
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $qryResult[0]->vCountry . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
if (isset($qryResult[0]->vAltState) && !empty($qryResult[0]->vAltState)) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $qryResult[0]->vAltState . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $qryResult[0]->vAltStateName);
}
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $qryResult[0]->vAltCountry . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
$this->ObTpl->set_var("TPL_VAR_FIRSTNAME", $this->libFunc->m_displayContent($qryResult[0]->vFirstName));
$this->ObTpl->set_var("TPL_VAR_LASTNAME", $this->libFunc->m_displayContent($qryResult[0]->vLastName));
$this->ObTpl->set_var("TPL_VAR_COMPANY", "(" . $this->libFunc->m_displayContent($qryResult[0]->vCompany) . ")");
$this->ObTpl->set_var("TPL_VAR_EMAIL", $this->libFunc->m_displayContent($qryResult[0]->vEmail));
$this->ObTpl->set_var("TPL_VAR_ADDRESS1", $this->libFunc->m_displayContent($qryResult[0]->vAddress1));
$this->ObTpl->set_var("TPL_VAR_ADDRESS2", $this->libFunc->m_displayContent($qryResult[0]->vAddress2));
$this->ObTpl->set_var("TPL_VAR_CITY", $this->libFunc->m_displayContent($qryResult[0]->vCity));
$this->ObTpl->set_var("TPL_VAR_ZIP", $this->libFunc->m_displayContent($qryResult[0]->vZip));
$this->ObTpl->set_var("TPL_VAR_COMPANY", $this->libFunc->m_displayContent($qryResult[0]->vCompany));
$this->ObTpl->set_var("TPL_VAR_PHONE", $this->libFunc->m_displayContent($qryResult[0]->vPhone));
$this->ObTpl->set_var("TPL_VAR_HOMEPAGE", $this->libFunc->m_displayContent($qryResult[0]->vHomepage));
$this->ObTpl->set_var("TPL_VAR_MPOINTS", "");
if ($this->libFunc->ifSet($_SESSION, "cssSelectedFile", "")) {
$this->ObTpl->set_var("TPL_VAR_CSSFILE", trim($_SESSION['cssSelectedFile']));
} else {
$this->ObTpl->set_var("TPL_VAR_CSSFILE", trim(DEFAULT_CSS));
}
$this->ObTpl->set_var("TPL_VAR_CSSFILE", "");
if ($qryResult[0]->iSameAsBilling == 1) {
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", MSG_SAMEASBILLING);
} else {
$this->ObTpl->parse("delivery_blk", "TPL_DELIVERY_BLK");
}
$this->ObTpl->set_var("TPL_VAR_ALTNAME", $this->libFunc->m_displayContent($qryResult[0]->vAltName));
$this->ObTpl->set_var("TPL_VAR_ALTADDR1", $this->libFunc->m_displayContent($qryResult[0]->vAltAddress1));
$this->ObTpl->set_var("TPL_VAR_ALTADDR2", $this->libFunc->m_displayContent($qryResult[0]->vAltAddress2));
$this->ObTpl->set_var("TPL_VAR_ALTCITY", $this->libFunc->m_displayContent($qryResult[0]->vAltCity));
$this->ObTpl->set_var("TPL_VAR_ALTZIP", $this->libFunc->m_displayContent($qryResult[0]->vAltZip));
$this->ObTpl->set_var("TPL_VAR_ALTPHONE", $this->libFunc->m_displayContent($qryResult[0]->vAltPhone));
$this->obDb->query = "SELECT iOrderProductid_PK,iProductid_FK,iQty,iGiftwrapFK,fPrice,";
$this->obDb->query .= "fDiscount,vTitle,vSku,iKit,tShortDescription,seo_title,iTaxable,iFreeship,vPostageNotes ";
$this->obDb->query .= " FROM " . ORDERPRODUCTS . " WHERE iOrderid_FK='" . $this->request['orderid'] . "'";
$rsOrderProduct = $this->obDb->fetchQuery();
$rsOrderProductCount = $this->obDb->record_count;
foreach ($rsOrderProduct as $key => $value) {
$this->obDb->query = "SELECT vDownloadablefile FROM " . PRODUCTS . " WHERE iProdid_PK = '" . $rsOrderProduct[$key]->iProductid_FK . "'";
$downloadProduct = $this->obDb->fetchQuery();
$rsOrderProduct[$key]->vDownloadablefile = $downloadProduct[0]->vDownloadablefile;
}
if ($rsOrderProductCount > 0) {
$id_rows = array();
for ($iSup = 0; $iSup < $rsOrderProductCount; $iSup++) {
$id_rows[$iSup] = $rsOrderProduct[$iSup]->iProductid_FK;
}
#GETTING SUPPLIERS FROM PRODUCT TABLE
$this->obDb->query = " SELECT distinct iVendorid_FK FROM " . PRODUCTS . " WHERE iVendorid_FK>0 AND iProdid_PK IN (" . implode(",", $id_rows) . ")";
$row = $this->obDb->fetchQuery();
$totalVendor = $this->obDb->record_count;
if ($totalVendor > 0) {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", $totalVendor);
} else {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", "");
}
$comFunc->orderId = $this->request['orderid'];
for ($i = 0; $i < $rsOrderProductCount; $i++) {
$this->ObTpl->set_var("TPL_VAR_OPTIONS", "");
$this->ObTpl->set_var("TPL_VAR_CHOICES", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "");
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "");
$this->ObTpl->set_var("TPL_VAR_NOTES", "");
$this->price = 0;
#INTIALIZING
$this->total = 0;
$comFunc->orderProductId = $rsOrderProduct[$i]->iOrderProductid_PK;
$comFunc->qty = $rsOrderProduct[$i]->iQty;
$comFunc->price = $this->price;
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", "");
##GIFTWRAP URL
if ($rsOrderProduct[$i]->iGiftwrapFK != 0) {
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", $comFunc->m_dspGiftWrap($rsOrderProduct[$i]->iGiftwrapFK));
}
if ($rsOrderProduct[$i]->iKit == 1) {
$this->obDb->query = "SELECT iKitItem_title,iProductid_FK FROM " . ORDERKITS . " WHERE iKitId='" . $rsOrderProduct[$i]->iProductid_FK . "' AND iProductOrderid_FK='" . $rsOrderProduct[$i]->iOrderProductid_PK . "'";
$rsKit = $this->obDb->fetchQuery();
$rsKitCount = $this->obDb->record_count;
for ($j = 0; $j < $rsKitCount; $j++) {
$comFunc->kitProductId = $rsKit[$j]->iProductid_FK;
#GET CART OPTIONS
$kitOptions = $comFunc->m_orderKitProductOptions();
if ($kitOptions == ' ') {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", "");
} else {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", $kitOptions);
}
$this->ObTpl->set_var("TPL_VAR_KITTITLE", $this->libFunc->m_displayContent($rsKit[$j]->iKitItem_title));
$this->ObTpl->parse("kit_blk", "TPL_KIT_BLK", true);
}
} else {
#GET ORDERED PRODUCT OPTIONS
$this->ObTpl->set_var("TPL_VAR_OPTIONS", $comFunc->m_orderProductOptions());
#GET ORDERED PRODUCT CHOICES
$this->ObTpl->set_var("TPL_VAR_CHOICES", $comFunc->m_orderProductChoices());
}
# (OPTION And choice effected amount)
$this->price = $comFunc->price;
#CHECK FOR DOWNLOADABLE FILE
if ($qryResult[0]->vPayMethod == "mail" || $qryResult[0]->vPayMethod == "cod") {
if (!empty($rsOrderProduct[$i]->vDownloadablefile)) {
$downloadVariable = 1;
$this->libFunc->m_checkFileExist($rsOrderProduct[$i]->vDownloadablefile, "files");
if ($this->libFunc->m_checkFileExist($rsOrderProduct[$i]->vDownloadablefile, "files")) {
$downloadUrl = $this->libFunc->m_safeUrl(SITE_URL . "index.php?action=download&mode=" . $rsOrderProduct[$i]->iProductid_FK);
$this->fileLink = "<a href='" . $downloadUrl . "'>Click here to download</a>";
$this->ObTpl->set_var("TPL_VAR_FILELINK", $this->fileLink);
$this->ObTpl->parse("download_blk", "TPL_DOWNLOAD_BLK");
}
} else {
$this->ObTpl->set_var("TPL_VAR_FILELINK", "");
$this->ObTpl->parse("download_blk", "TPL_DOWNLOAD_BLK");
}
} else {
$this->ObTpl->set_var("TPL_VAR_FILELINK", "");
$this->ObTpl->parse("download_blk", "TPL_DOWNLOAD_BLK");
}
#VOLUME DISCOUNT
#DISCOUNT ACCORDING TO QTY
$vDiscountPerCartElement = number_format($rsOrderProduct[$i]->fDiscount, 2, '.', '');
if ($vDiscountPerCartElement > 0) {
$totalDiscountItem = $vDiscountPerCartElement * $rsOrderProduct[$i]->iQty;
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "Volume Discount: " . CONST_CURRENCY . $vDiscountPerCartElement . " each Total: " . CONST_CURRENCY . $totalDiscountItem . "<br />");
$this->volDiscount = $this->volDiscount + $totalDiscountItem;
}
$productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rsOrderProduct[$i]->seo_title;
$this->ObTpl->set_var("TPL_VAR_PRODUCTURL", $this->libFunc->m_safeUrl($productUrl));
$this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rsOrderProduct[$i]->vTitle));
$this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($rsOrderProduct[$i]->vSku));
$this->price = $this->price + $rsOrderProduct[$i]->fPrice;
$this->ObTpl->set_var("TPL_VAR_PRICE", number_format($this->price, 2, '.', ''));
$this->ObTpl->set_var("TPL_VAR_QTY", $rsOrderProduct[$i]->iQty);
$this->totalQty += $rsOrderProduct[$i]->iQty;
$this->total += $rsOrderProduct[$i]->iQty * $this->price;
$this->ObTpl->set_var("TPL_VAR_TOTAL", number_format($this->total, 2, '.', ''));
$this->subTotal = $this->subTotal + $this->total;
if ($rsOrderProduct[$i]->iFreeship == 1) {
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "<em>" . LBL_FREEPP . "</em><br />");
}
if ($rsOrderProduct[$i]->iTaxable != 1) {
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "<em>" . LBL_NOTAX . "</em><br />");
}
if (!empty($rsOrderProduct[$i]->vPostageNotes)) {
$this->ObTpl->set_var("TPL_VAR_NOTES", "Notes: " . $this->libFunc->m_displayContent($rsOrderProduct[$i]->vPostageNotes) . "<br />");
}
$this->ObTpl->parse("cartproduct_blk", "TPL_VAR_CARTPRODUCTS", true);
}
#END PRODUCT DISPLAY
#******************** SUB TOTAL **************** *************
$this->ObTpl->set_var("TPL_VAR_SUBTOTAL", number_format($this->subTotal, 2, '.', ''));
$this->grandTotal = $this->subTotal;
#******************** PROMOTION CODE ************************
if ($qryResult[0]->fPromoValue > 0) {
$this->ObTpl->set_var("TPL_VAR_PDISCOUNTS", number_format($qryResult[0]->fPromoValue, 2, '.', ''));
$this->grandTotal -= number_format($qryResult[0]->fPromoValue, 2, '.', '');
$this->ObTpl->parse("promodiscounts_blk", "TPL_PROMODISCOUNTS_BLK");
}
#******************** VOLUME DISCOUNT ************************
if ($this->volDiscount > 0) {
$this->ObTpl->set_var("TPL_VAR_VOLDISCOUNT", number_format($this->volDiscount, 2, '.', ''));
$this->grandTotal -= $this->volDiscount;
$this->ObTpl->parse("volDiscounts_blk", "TPL_VOLDISCOUNTS_BLK");
}
#CART WEIGHT *******
if ($qryResult[0]->fShipByWeightPrice > 0 && ISACTIVE_ITEMWEIGHT == 1) {
$this->ObTpl->set_var("TPL_VAR_WEIGHT", $qryResult[0]->fShipByWeightKg);
$this->ObTpl->set_var("TPL_VAR_WEIGHTPRICE", number_format($qryResult[0]->fShipByWeightPrice, 2, '.', ''));
$this->grandTotal += $qryResult[0]->fShipByWeightPrice;
$this->ObTpl->parse("cartWeight_blk", "TPL_CARTWEIGHT_BLK");
}
if ($qryResult[0]->fMemberPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_MPOINTS", number_format($qryResult[0]->fMemberPoints, 2, '.', ''));
$this->grandTotal -= number_format($qryResult[0]->fMemberPoints, 2, '.', '');
$this->ObTpl->parse("memberpoint_blk", "TPL_MPOINTS_BLK");
}
# code added for getting total earned points
if ($qryResult[0]->iEarnedPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_EMPOINTS", number_format($qryResult[0]->iEarnedPoints));
$this->ObTpl->parse("earnedmemberpoint_blk", "TPL_EMPOINTS_BLK");
}
# code added for getting total points
$this->obDb->query = "SELECT fMemberPoints FROM " . CUSTOMERS . " WHERE iCustmerid_PK=" . $qryResult[0]->iCustomerid_FK;
$rsCust = $this->obDb->fetchQuery();
if ($rsCust[0]->fMemberPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_TMPOINTS", number_format($rsCust[0]->fMemberPoints, 0));
$memberpoint_price = MPOINTVALUE * $rsCust[0]->fMemberPoints;
$this->ObTpl->set_var("TPL_VAR_TMPOINTS_PRICE", number_format($memberpoint_price, 2, '.', ''));
$this->ObTpl->parse("totalmemberpoint_blk", "TPL_TMPOINTS_BLK");
}
#POSTAGE CALCULATION**************************
if ($qryResult[0]->fShipTotal > 0) {
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", "Postage method (" . $qryResult[0]->vShipDescription . ")");
$this->ObTpl->set_var("TPL_VAR_POSTAGEPRICE", CONST_CURRENCY . number_format($qryResult[0]->fShipTotal, 2, '.', ''));
$this->grandTotal += number_format($qryResult[0]->fShipTotal, 2, '.', '');
$this->ObTpl->parse("postage_blk", "TPL_POSTAGE_BLK");
} elseif ($qryResult[0]->vShipDescription == "Free P&P") {
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", $qryResult[0]->vShipDescription);
$this->ObTpl->set_var("TPL_VAR_POSTAGEPRICE", "No Charge");
$this->ObTpl->parse("postage_blk", "TPL_POSTAGE_BLK");
}
#COD PRICE(PAYMENT GATEWAY ADDITIONAL PRICE)
if ($qryResult[0]->fCodCharge > 0) {
$this->ObTpl->set_var("TPL_VAR_CODPRICE", number_format($qryResult[0]->fCodCharge, 2, '.', ''));
$this->grandTotal += number_format($qryResult[0]->fCodCharge, 2, '.', '');
$this->ObTpl->parse("cod_blk", "TPL_COD_BLK");
}
#CHECK FOR DISCOUNTS
if ($qryResult[0]->fDiscount != 0) {
$this->ObTpl->set_var("TPL_VAR_DISCOUNTPRICE", number_format($qryResult[0]->fDiscount, 2, '.', ''));
$this->grandTotal -= number_format($qryResult[0]->fDiscount, 2, '.', '');
$this->ObTpl->parse("discount_blk", "TPL_DISCOUNT_BLK");
$curTime = time();
$this->obDb->query = "UPDATE " . DISCOUNTS . " SET iState=0 WHERE vCode='" . $qryResult[0]->vDiscountCode . "' AND tmStartDate<{$curTime} AND tmEndDate>{$curTime} AND iUseonce=1";
$this->obDb->updateQuery();
}
#CHECK FOR GIFTCERTIFICATES
if ($qryResult[0]->fGiftcertTotal != 0) {
$this->grandTotal -= number_format($qryResult[0]->fGiftcertTotal, 2, '.', '');
$this->ObTpl->set_var("TPL_VAR_GIFTCERTPRICE", number_format($qryResult[0]->fGiftcertTotal, 2, '.', ''));
$this->ObTpl->parse("giftcert_blk", "TPL_GIFTCERT_BLK");
}
if ($qryResult[0]->fTaxPrice > 0) {
$this->ObTpl->set_var("TPL_VAR_TAXNAME", VAT_TAX_TEXT);
$this->ObTpl->set_var("TPL_VAR_VAT", number_format($qryResult[0]->fTaxRate, 2, '.', ''));
$this->ObTpl->set_var("TPL_VAR_VATPRICE", number_format($qryResult[0]->fTaxPrice, 2, '.', ''));
$this->ObTpl->parse("vat_blk", "TPL_VAT_BLK");
}
$this->grandTotal += number_format($qryResult[0]->fDiscount, 2, '.', '');
$this->ObTpl->set_var("TPL_VAR_CURRENTTOTAL", number_format($qryResult[0]->fTotalPrice, 2, '.', ''));
$this->ObTpl->parse("cart_blk", "TPL_CART_BLK");
}
}
#END ORDERS IF CONDITION
$message = $this->ObTpl->parse("return", "TPL_ORDERMAIL_FILE");
$obMail = new htmlMimeMail();
$obMail->setReturnPath(ADMIN_EMAIL);
$obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">");
$obMail->setSubject("Thank You for your order at " . SITE_NAME);
$obMail->setCrlf("\n");
//to handle mails in Outlook Express
$htmlcontent = $message;
$txtcontent = preg_replace("/<([^>]+)>/", "", preg_replace("/<br(\\/{0,1})>/", "\r\n", $message));
$obMail->setHtml($htmlcontent, $txtcontent);
$obMail->buildMessage();
if (preg_match("/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})\$/i", ADMIN_EMAIL)) {
if ($downloadVariable == "1" && ($qryResult[0]->vPayMethod == "mail" || $qryResult[0]->vPayMethod == "cod")) {
$result = $obMail->send(array($qryResult[0]->vEmail));
}
}
$obMail->setSubject("Thank You for your order at " . SITE_NAME);
$this->ObTpl->set_var("customer_blk", "");
$this->ObTpl->parse("admin_blk", "TPL_ADMIN_BLK");
$obMail->setSubject(SITE_NAME . " Invoice " . $qryResult[0]->iInvoice);
$obMail->setCrlf("\n");
//to handle mails in Outlook Express
$message = $this->ObTpl->parse("return", "TPL_ORDERMAIL_FILE");
$htmlcontent = $message;
$txtcontent = preg_replace("/<([^>]+)>/", "", preg_replace("/<br(\\/{0,1})>/", "\r\n", $message));
$obMail->setHtml($htmlcontent, $txtcontent);
$obMail->buildMessage();
if (preg_match("/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})\$/i", ORDER_EMAIL)) {
$result = $obMail->send(array(ORDER_EMAIL));
}
#WIRELESS EMAIL
$Name = $this->libFunc->m_displayContent($qryResult[0]->vFirstName) . " " . $this->libFunc->m_displayContent($qryResult[0]->vLastName);
$obMail->setSubject(SITE_NAME . " Invoice " . $qryResult[0]->iInvoice);
$obMail->setCrlf("\n");
//to handle mails in Outlook Express
$wirelesscontent = "Invoice: " . $qryResult[0]->iInvoice . "<br />";
$wirelesscontent .= "Customer: " . $Name . "<br />";
$wirelesscontent .= "Total: " . CONST_CURRENCY . number_format($qryResult[0]->fTotalPrice, 2, '.', '');
$txtcontent = preg_replace("/<([^>]+)>/", "", preg_replace("/<br(\\/{0,1})>/", "\r\n", $wirelesscontent));
$obMail->setHtml($wirelesscontent, $txtcontent);
$obMail->buildMessage();
if (preg_match("/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})\$/i", WIRELESS_EMAIL)) {
$result = $obMail->send(array(WIRELESS_EMAIL));
}
}
function m_dspreceipt()
{
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
if (!isset($this->request['mode']) || empty($this->request['mode'])) {
$errrorUrl = SITE_URL . "index.php?action=error&mode=order";
$this->libFunc->m_mosRedirect($this->libFunc->m_safeUrl($errrorUrl));
}
$this->ObTpl = new template();
$this->ObTpl->set_file("TPL_REVIEW_FILE", $this->receiptTemplate);
#SETTING BLOCKS
$this->ObTpl->set_block("TPL_REVIEW_FILE", "TPL_CART_BLK", "cart_blk");
$this->ObTpl->set_block("TPL_REVIEW_FILE", "TPL_DELIVERY_BLK", "delivery_blk");
$this->ObTpl->set_block("TPL_REVIEW_FILE", "TPL_VAR_CARTPRODUCTS", "cartproduct_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_GIFTCERT_BLK", "giftcert_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_DISCOUNT_BLK", "discount_blk");
$this->ObTpl->set_block("TPL_VAR_CARTPRODUCTS", "TPL_KIT_BLK", "kit_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_COD_BLK", "cod_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_PROMODISCOUNTS_BLK", "promodiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VOLDISCOUNTS_BLK", "volDiscounts_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_POSTAGE_BLK", "postage_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_MPOINTS_BLK", "memberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_EMPOINTS_BLK", "earnedmemberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_TMPOINTS_BLK", "totalmemberpoint_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_CARTWEIGHT_BLK", "cartWeight_blk");
$this->ObTpl->set_block("TPL_CART_BLK", "TPL_VAT_BLK", "vat_blk");
#INTIALIZING
$this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_SAFEURL);
$this->ObTpl->set_var("TPL_VAR_GRAPHICSURL", GRAPHICS_PATH);
$this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY);
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "");
$this->ObTpl->set_var("TPL_VAR_VAUTHCODE", "-");
#INTAILAIZING
$this->ObTpl->set_var("delivery_blk", "");
$this->ObTpl->set_var("cart_blk", "");
$this->ObTpl->set_var("cartWeight_blk", "");
$this->ObTpl->set_var("giftcert_blk", "");
$this->ObTpl->set_var("discount_blk", "");
$this->ObTpl->set_var("cartproduct_blk", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("promodiscounts_blk", "");
$this->ObTpl->set_var("volDiscounts_blk", "");
$this->ObTpl->set_var("postage_blk", "");
$this->ObTpl->set_var("cod_blk", "");
$this->ObTpl->set_var("memberpoint_blk", "");
$this->ObTpl->set_var("earnedmemberpoint_blk", "");
$this->ObTpl->set_var("totalmemberpoint_blk", "");
$this->ObTpl->set_var("vat_blk", "");
$this->ObTpl->set_var("TPL_VAR_MSG", "");
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", "");
// [DRK][MODIFIED BY NSI]
$this->ObTpl->set_var("TPL_VAR_COMPANY_DETAILS", $comFunc->m_mailFooter());
// [/DRK]
#QUERY ORDER TABLE
$this->obDb->query = "SELECT tmOrderDate,vPayMethod,vShipDescription,fShipTotal,";
$this->obDb->query .= "vFirstName,vLastName,vEmail,vAddress1,vAddress2,vCity,iInvoice,";
$this->obDb->query .= "vState,vStateName,vCountry,vZip,vCompany,vPhone,vHomepage,";
$this->obDb->query .= "vAltCompany,vAltName,vAltAddress1,vAltAddress2,vAltCity,vAltState,vAltCountry,";
$this->obDb->query .= "vAltStateName,vAltZip,vAltPhone,fCodCharge,fPromoValue,";
$this->obDb->query .= "vDiscountCode,fDiscount,iGiftcert_FK,fGiftcertTotal,fMemberPoints,";
$this->obDb->query .= "fShipByWeightPrice,fShipByWeightKg,iSameAsBilling,vAuthCode,";
$this->obDb->query .= "fTaxRate,fTaxPrice,tComments,vStatus,iPayStatus,fTotalPrice,iEarnedPoints,iCustomerid_FK";
$this->obDb->query .= " FROM " . ORDERS . " WHERE iOrderid_PK='" . $this->request['mode'] . "'";
if (isset($_SESSION['userid']) && !empty($_SESSION['userid'])) {
$this->obDb->query .= " AND iCustomerid_FK='" . $_SESSION['userid'] . "'";
} else {
$this->obDb->query .= " AND vEmail='" . $_SESSION['email'] . "'";
}
$rsOrder = $this->obDb->fetchQuery();
$rsOrderCount = $this->obDb->record_count;
$this->ObTpl->set_var("TPL_VAR_VAUTHCODE", $rsOrder[0]->vAuthCode);
if ($rsOrderCount != 1) {
$errrorUrl = SITE_URL . "index.php?action=error&mode=order";
$this->libFunc->m_mosRedirect($this->libFunc->m_safeUrl($errrorUrl));
}
if ($rsOrderCount > 0) {
$this->ObTpl->set_var("TPL_VAR_INVOICE", $rsOrder[0]->iInvoice);
$this->ObTpl->set_var("TPL_VAR_ORDERDATE", $this->libFunc->dateFormat2($rsOrder[0]->tmOrderDate));
if ($rsOrder[0]->vPayMethod == 'cod') {
$vPayMethod = $comFunc->m_paymentMethod($rsOrder[0]->vPayMethod, $rsOrder[0]->fCodCharge);
} else {
$vPayMethod = $comFunc->m_paymentMethod($rsOrder[0]->vPayMethod);
}
$this->ObTpl->set_var("TPL_VAR_PAYMENTMETHOD", $vPayMethod);
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", $rsOrder[0]->vShipDescription);
$this->ObTpl->set_var("TPL_VAR_ORDERSTATUS", ucfirst($rsOrder[0]->vStatus));
if (empty($rsOrder[0]->tComments)) {
$this->ObTpl->set_var("TPL_VAR_COMMENTS", "None");
} else {
$this->ObTpl->set_var("TPL_VAR_COMMENTS", $rsOrder[0]->tComments);
}
if (isset($rsOrder[0]->vState) && !empty($rsOrder[0]->vState)) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $rsOrder[0]->vState . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_BILLSTATE", $rsOrder[0]->vStateName);
}
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $rsOrder[0]->vCountry . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_BILLCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
if (isset($rsOrder[0]->vAltState) && !empty($rsOrder[0]->vAltState)) {
$this->obDb->query = "SELECT vStateName FROM " . STATES . " where iStateId_PK = '" . $rsOrder[0]->vAltState . "'";
$row_state = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $this->libFunc->m_displayContent($row_state[0]->vStateName));
} else {
$this->ObTpl->set_var("TPL_VAR_SHIPSTATE", $rsOrder[0]->vAltStateName);
}
$this->obDb->query = "SELECT vCountryName FROM " . COUNTRY . " where iCountryId_PK = '" . $rsOrder[0]->vAltCountry . "'";
$row_country = $this->obDb->fetchQuery();
$this->ObTpl->set_var("TPL_VAR_SHIPCOUNTRY", $this->libFunc->m_displayContent($row_country[0]->vCountryName));
$this->ObTpl->set_var("TPL_VAR_FIRSTNAME", $this->libFunc->m_displayContent($rsOrder[0]->vFirstName));
$this->ObTpl->set_var("TPL_VAR_LASTNAME", $this->libFunc->m_displayContent($rsOrder[0]->vLastName));
$this->ObTpl->set_var("TPL_VAR_EMAIL", $this->libFunc->m_displayContent($rsOrder[0]->vEmail));
$this->ObTpl->set_var("TPL_VAR_ADDRESS1", $this->libFunc->m_displayContent($rsOrder[0]->vAddress1));
$this->ObTpl->set_var("TPL_VAR_ADDRESS2", $this->libFunc->m_displayContent($rsOrder[0]->vAddress2));
$this->ObTpl->set_var("TPL_VAR_CITY", $this->libFunc->m_displayContent($rsOrder[0]->vCity));
$this->ObTpl->set_var("TPL_VAR_ZIP", $this->libFunc->m_displayContent($rsOrder[0]->vZip));
$this->ObTpl->set_var("TPL_VAR_COMPANY", $this->libFunc->m_displayContent($rsOrder[0]->vCompany));
$this->ObTpl->set_var("TPL_VAR_PHONE", $this->libFunc->m_displayContent($rsOrder[0]->vPhone));
$this->ObTpl->set_var("TPL_VAR_HOMEPAGE", $this->libFunc->m_displayContent($rsOrder[0]->vHomepage));
$this->ObTpl->set_var("TPL_VAR_MPOINTS", "");
# ADD EDIT AND MY ACCOUNT LINK
$url_editOrder = SITE_URL . "ecom/index.php?action=checkout.editOrder&mode=" . $this->request['mode'];
$this->ObTpl->set_var("TPL_VAR_MYACCOUNT_URL", SITE_URL . "user/index.php?action=user.home");
$this->ObTpl->set_var("TPL_VAR_EDITORDER_URL", $url_editOrder);
if ($rsOrder[0]->iSameAsBilling == 1) {
$this->ObTpl->set_var("TPL_VAR_SAMEASBILLING", MSG_SAMEASBILLING);
} else {
$this->ObTpl->parse("delivery_blk", "TPL_DELIVERY_BLK");
}
if (isset($rsOrder[0]->vAltCompany) && !empty($rsOrder[0]->vAltCompany)) {
$this->ObTpl->set_var("TPL_VAR_ALTCOMPANY", $this->libFunc->m_displayContent($rsOrder[0]->vAltCompany));
} else {
$this->ObTpl->set_var("TPL_VAR_ALTCOMPANY", "");
}
$this->ObTpl->set_var("TPL_VAR_ALTNAME", $this->libFunc->m_displayContent($rsOrder[0]->vAltName));
$this->ObTpl->set_var("TPL_VAR_ALTADDR1", $this->libFunc->m_displayContent($rsOrder[0]->vAltAddress1));
$this->ObTpl->set_var("TPL_VAR_ALTADDR2", $this->libFunc->m_displayContent($rsOrder[0]->vAltAddress2));
$this->ObTpl->set_var("TPL_VAR_ALTCITY", $this->libFunc->m_displayContent($rsOrder[0]->vAltCity));
$this->ObTpl->set_var("TPL_VAR_ALTZIP", $this->libFunc->m_displayContent($rsOrder[0]->vAltZip));
$this->ObTpl->set_var("TPL_VAR_ALTPHONE", $this->libFunc->m_displayContent($rsOrder[0]->vAltPhone));
$this->obDb->query = "SELECT iOrderProductid_PK,iProductid_FK,iQty,iGiftwrapFK,fPrice,";
$this->obDb->query .= "fDiscount,vTitle,vSku,iKit,tShortDescription,vSeoTitle,iTaxable,iFreeship,vPostageNotes,seo_title ";
$this->obDb->query .= " FROM " . ORDERPRODUCTS . " WHERE iOrderid_FK='" . $this->request['mode'] . "'";
$rsOrderProduct = $this->obDb->fetchQuery();
$rsOrderProductCount = $this->obDb->record_count;
if ($rsOrderProductCount > 0) {
$id_rows = array();
for ($iSup = 0; $iSup < $rsOrderProductCount; $iSup++) {
$id_rows[$iSup] = $rsOrderProduct[$iSup]->iProductid_FK;
}
$this->obDb->query = " SELECT distinct iVendorid_FK FROM " . PRODUCTS . " WHERE iVendorid_FK>0 AND iProdid_PK IN (" . implode(",", $id_rows) . ")";
$row = $this->obDb->fetchQuery();
$totalVendor = $this->obDb->record_count;
if ($totalVendor > 0) {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", $totalVendor);
} else {
$this->ObTpl->set_var("TPL_VAR_TOTAL_SUPPLIER", "");
}
$comFunc->orderId = $this->request['mode'];
for ($i = 0; $i < $rsOrderProductCount; $i++) {
$this->ObTpl->set_var("TPL_VAR_OPTIONS", "");
$this->ObTpl->set_var("TPL_VAR_CHOICES", "");
$this->ObTpl->set_var("kit_blk", "");
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "");
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "");
$this->ObTpl->set_var("TPL_VAR_NOTES", "");
$this->price = 0;
#INTIALIZING
$this->total = 0;
$comFunc->orderProductId = $rsOrderProduct[$i]->iOrderProductid_PK;
$comFunc->qty = $rsOrderProduct[$i]->iQty;
$comFunc->price = $this->price;
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", "");
##GIFTWRAP URL
if ($rsOrderProduct[$i]->iGiftwrapFK != 0) {
$this->ObTpl->set_var("TPL_VAR_GIFTWRAP", $comFunc->m_dspGiftWrap($rsOrderProduct[$i]->iGiftwrapFK));
}
if ($rsOrderProduct[$i]->iKit == 1) {
$this->obDb->query = "SELECT iKitItem_title,iProductid_FK FROM " . ORDERKITS . " WHERE iKitId='" . $rsOrderProduct[$i]->iProductid_FK . "' AND iProductOrderid_FK='" . $rsOrderProduct[$i]->iOrderProductid_PK . "'";
$rsKit = $this->obDb->fetchQuery();
$rsKitCount = $this->obDb->record_count;
for ($j = 0; $j < $rsKitCount; $j++) {
$comFunc->kitProductId = $rsKit[$j]->iProductid_FK;
#GET CART OPTIONS
$kitOptions = $comFunc->m_orderKitProductOptions();
if ($kitOptions == ' ') {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", "");
} else {
$this->ObTpl->set_var("TPL_VAR_KITOPTIONS", $kitOptions);
}
$this->ObTpl->set_var("TPL_VAR_KITTITLE", $this->libFunc->m_displayContent($rsKit[$j]->iKitItem_title));
$this->ObTpl->parse("kit_blk", "TPL_KIT_BLK", true);
}
} else {
#GET ORDERED PRODUCT OPTIONS
$this->ObTpl->set_var("TPL_VAR_OPTIONS", $comFunc->m_orderProductOptions());
#GET ORDERED PRODUCT CHOICES
$this->ObTpl->set_var("TPL_VAR_CHOICES", $comFunc->m_orderProductChoices());
}
# (OPTION And choice effected amount)
$this->price = $comFunc->price;
#VOLUME DISCOUNT
#DISCOUNT ACCORDING TO QTY
$vDiscountPerCartElement = number_format($rsOrderProduct[$i]->fDiscount, 2, '.', '');
if ($vDiscountPerCartElement > 0) {
$totalDiscountItem = $vDiscountPerCartElement * $rsOrderProduct[$i]->iQty;
$this->ObTpl->set_var("TPL_VAR_CART_VOLDISCOUNT", "Volume Discount: " . CONST_CURRENCY . $vDiscountPerCartElement . " each Total: " . CONST_CURRENCY . $totalDiscountItem . "<br />");
$this->volDiscount = $this->volDiscount + $totalDiscountItem;
}
$productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rsOrderProduct[$i]->seo_title;
$this->ObTpl->set_var("TPL_VAR_PRODUCTURL", $this->libFunc->m_safeUrl($productUrl));
$this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rsOrderProduct[$i]->vTitle));
$this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($rsOrderProduct[$i]->vSku));
$this->price = $this->price + $rsOrderProduct[$i]->fPrice;
$this->ObTpl->set_var("TPL_VAR_PRICE", number_format($this->price, 2, '.', ''));
$this->ObTpl->set_var("TPL_VAR_QTY", $rsOrderProduct[$i]->iQty);
$this->totalQty += $rsOrderProduct[$i]->iQty;
$this->total += $rsOrderProduct[$i]->iQty * $this->price;
$this->ObTpl->set_var("TPL_VAR_TOTAL", number_format($this->total, 2, '.', ''));
$this->subTotal = $this->subTotal + $this->total;
if ($rsOrderProduct[$i]->iFreeship == 1) {
$this->ObTpl->set_var("TPL_VAR_FREESHIPMSG", "<em>" . LBL_FREEPP . "</em><br />");
}
if ($rsOrderProduct[$i]->iTaxable != 1) {
if (HIDENOVAT != 1) {
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "<em>" . LBL_NOTAX . "</em><br />");
} else {
$this->ObTpl->set_var("TPL_VAR_TAXABLE", "");
}
}
if (!empty($rsOrderProduct[$i]->vPostageNotes)) {
$this->ObTpl->set_var("TPL_VAR_NOTES", "Notes: " . $this->libFunc->m_displayContent($rsOrderProduct[$i]->vPostageNotes) . "<br />");
}
$this->ObTpl->parse("cartproduct_blk", "TPL_VAR_CARTPRODUCTS", true);
}
#END PRODUCT DISPLAY
#******************** SUB TOTAL **************** *************
$this->ObTpl->set_var("TPL_VAR_SUBTOTAL", number_format($this->subTotal, 2, '.', ''));
$this->grandTotal = $this->subTotal;
#******************** PROMOTION CODE ************************
if ($rsOrder[0]->fPromoValue > 0) {
$this->ObTpl->set_var("TPL_VAR_PDISCOUNTS", number_format($rsOrder[0]->fPromoValue, 2, '.', ''));
$this->grandTotal -= number_format($rsOrder[0]->fPromoValue, 2, '.', '');
$this->ObTpl->parse("promodiscounts_blk", "TPL_PROMODISCOUNTS_BLK");
}
#******************** VOLUME DISCOUNT ************************
if ($this->volDiscount > 0) {
$this->ObTpl->set_var("TPL_VAR_VOLDISCOUNT", number_format($this->volDiscount, 2, '.', ''));
$this->grandTotal -= $this->volDiscount;
$this->ObTpl->parse("volDiscounts_blk", "TPL_VOLDISCOUNTS_BLK");
}
#CART WEIGHT *******
if ($rsOrder[0]->fShipByWeightPrice > 0 && ISACTIVE_ITEMWEIGHT == 1) {
$this->ObTpl->set_var("TPL_VAR_WEIGHT", $rsOrder[0]->fShipByWeightKg);
$this->ObTpl->set_var("TPL_VAR_WEIGHTPRICE", number_format($rsOrder[0]->fShipByWeightPrice, 2, '.', ''));
$this->grandTotal += $rsOrder[0]->fShipByWeightPrice;
$this->ObTpl->parse("cartWeight_blk", "TPL_CARTWEIGHT_BLK");
}
if ($rsOrder[0]->fMemberPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_MPOINTS", number_format($rsOrder[0]->fMemberPoints, 2, '.', ''));
$this->grandTotal -= number_format($rsOrder[0]->fMemberPoints, 2, '.', '');
$this->ObTpl->parse("memberpoint_blk", "TPL_MPOINTS_BLK");
}
# code added for getting total earned points
if ($rsOrder[0]->iEarnedPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_EMPOINTS", $rsOrder[0]->iEarnedPoints);
$this->ObTpl->parse("earnedmemberpoint_blk", "TPL_EMPOINTS_BLK");
}
# code added for getting total points
$this->obDb->query = "SELECT fMemberPoints FROM " . CUSTOMERS . " WHERE iCustmerid_PK=" . $rsOrder[0]->iCustomerid_FK;
$rsCust = $this->obDb->fetchQuery();
if ($rsCust[0]->fMemberPoints > 0) {
$this->ObTpl->set_var("TPL_VAR_TMPOINTS", number_format($rsCust[0]->fMemberPoints, 0));
$memberpoint_price = MPOINTVALUE * $rsCust[0]->fMemberPoints;
$this->ObTpl->set_var("TPL_VAR_TMPOINTS_PRICE", number_format($memberpoint_price, 2, '.', ''));
$this->ObTpl->parse("totalmemberpoint_blk", "TPL_TMPOINTS_BLK");
}
#POSTAGE CALCULATION**************************
if ($rsOrder[0]->fShipTotal > 0) {
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", "Postage method (" . $rsOrder[0]->vShipDescription . ")");
$this->ObTpl->set_var("TPL_VAR_POSTAGEPRICE", CONST_CURRENCY . number_format($rsOrder[0]->fShipTotal, 2, '.', ''));
$this->grandTotal += number_format($rsOrder[0]->fShipTotal, 2, '.', '');
$this->ObTpl->parse("postage_blk", "TPL_POSTAGE_BLK");
} elseif ($rsOrder[0]->vShipDescription == "Free P&P") {
$this->ObTpl->set_var("TPL_VAR_POSTAGEMETHOD", $rsOrder[0]->vShipDescription);
$this->ObTpl->set_var("TPL_VAR_POSTAGEPRICE", "No Charge");
$this->ObTpl->parse("postage_blk", "TPL_POSTAGE_BLK");
}
#COD PRICE(PAYMENT GATEWAY ADDITIONAL PRICE)
if ($rsOrder[0]->fCodCharge > 0) {
$this->ObTpl->set_var("TPL_VAR_CODPRICE", number_format($rsOrder[0]->fCodCharge, 2, '.', ''));
$this->grandTotal += number_format($rsOrder[0]->fCodCharge, 2, '.', '');
$this->ObTpl->parse("cod_blk", "TPL_COD_BLK");
}
#CHECK FOR DISCOUNTS
if ($rsOrder[0]->fDiscount != 0) {
$this->ObTpl->set_var("TPL_VAR_DISCOUNTPRICE", number_format($rsOrder[0]->fDiscount, 2, '.', ''));
$this->grandTotal -= number_format($rsOrder[0]->fDiscount, 2, '.', '');
$this->ObTpl->parse("discount_blk", "TPL_DISCOUNT_BLK");
}
#CHECK FOR GIFTCERTIFICATES
if ($rsOrder[0]->fGiftcertTotal != 0) {
$this->grandTotal -= number_format($rsOrder[0]->fGiftcertTotal, 2, '.', '');
$this->ObTpl->set_var("TPL_VAR_GIFTCERTPRICE", number_format($rsOrder[0]->fGiftcertTotal, 2, '.', ''));
$this->ObTpl->parse("giftcert_blk", "TPL_GIFTCERT_BLK");
}
if ($rsOrder[0]->fTaxPrice > 0) {
$this->ObTpl->set_var("TPL_VAR_TAXNAME", VAT_TAX_TEXT);
$this->ObTpl->set_var("TPL_VAR_VAT", number_format($rsOrder[0]->fTaxRate, 2, '.', ''));
$this->ObTpl->set_var("TPL_VAR_VATPRICE", number_format($rsOrder[0]->fTaxPrice, 2, '.', ''));
$this->ObTpl->parse("vat_blk", "TPL_VAT_BLK");
}
$this->grandTotal += number_format($rsOrder[0]->fDiscount, 2, '.', '');
$this->ObTpl->set_var("TPL_VAR_CURRENTTOTAL", number_format($rsOrder[0]->fTotalPrice, 2, '.', ''));
$this->ObTpl->parse("cart_blk", "TPL_CART_BLK");
}
}
#END ORDERS IF CONDITION
return $this->ObTpl->parse("return", "TPL_REVIEW_FILE");
}