function m_sendMail() { $libFunc = new c_libFunctions(); $this->ObTpl = new template(); $this->ObTpl->set_file("TPL_VAR_CMS", MODULES_PATH . "default/templates/main/contactmail.tpl.htm"); $this->ObTpl->set_var("TPL_VAR_NAME", $this->libFunc->m_displayContent($this->request['sName'])); $this->ObTpl->set_var("TPL_VAR_ADDRESS1", $this->libFunc->m_displayContent($this->request['sAddress1'])); $this->ObTpl->set_var("TPL_VAR_ADDRESS2", $this->libFunc->m_displayContent($this->request['sAddress2'])); $this->ObTpl->set_var("TPL_VAR_PHONE", $this->libFunc->m_displayContent($this->request['sWorkPhone'])); $this->ObTpl->set_var("TPL_VAR_COUNTRY", $this->libFunc->m_displayContent($this->request['sCountry'])); $this->ObTpl->set_var("TPL_VAR_COMMENTS", nl2br($this->libFunc->m_displayContent($this->request['sComments']))); $message = "========================================<br />"; $message .= "Contact request from " . SITE_NAME . "<br />"; $message .= "========================================<br />"; $message .= $this->ObTpl->parse("return", "TPL_VAR_CMS"); $this->request['sName'] . "<" . $this->libFunc->m_displayContent1($this->request['sEmail']) . ">"; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $this->libFunc->m_displayContent($this->request['sName']) . "<" . $this->libFunc->m_displayContent1($this->request['sEmail']) . ">"; $obMail->setFrom($this->libFunc->m_displayContent1("\"" . $this->request['sName'] . "\"") . "<" . $this->libFunc->m_displayContent1($this->request['sEmail']) . ">"); $obMail->setSubject("Contact request from " . 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(); $result = $obMail->send(array(ENQUIRY_EMAIL)); }
function m_reviewAdd() { $this->request['display'] = $this->libFunc->ifSet($this->request, "display"); $timestamp = time(); $this->obDb->query = "SELECT iProdid_PK FROM " . PRODUCTS . " WHERE iProdid_PK='" . $this->request['productid'] . "'"; $rs = $this->obDb->fetchQuery(); if ($this->obDb->record_count > 0) { #inserting to departments $this->obDb->query = "SELECT iCustRevid_PK FROM " . REVIEWS . " WHERE iCustomerid_FK='" . $_SESSION['userid'] . "' AND iItemid_FK='" . $this->request['productid'] . "'"; $rs = $this->obDb->fetchQuery(); $rsCnt = $this->obDb->record_count; if ($rsCnt == 0) { $this->obDb->query = "INSERT INTO " . REVIEWS . "\n\t\t\t\t\t\t\t\t\t\t(vTitle,vComment,vRank,iDisplay,iItemid_FK,tmDateAdd,iCustomerid_FK,iState) \n\t\t\t\t\t\t\t\t\t\t\tvalues('" . $this->libFunc->m_addToDB($this->request['title']) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['comment']) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['rank']) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $this->request['display'] . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $this->request['productid'] . "',\n\t\t\t\t\t\t\t\t\t\t\t'{$timestamp}','" . $_SESSION['userid'] . "',1)"; $this->obDb->updateQuery(); } else { $this->obDb->query = "UPDATE " . REVIEWS . " SET vTitle='" . $this->libFunc->m_addToDB($this->request['title']) . "',\n\t\t\t\t\t\t\t\t\t\tvComment='" . $this->libFunc->m_addToDB($this->request['comment']) . "',\n\t\t\t\t\t\t\t\t\t\tvRank='" . $this->libFunc->m_addToDB($this->request['rank']) . "',\n\t\t\t\t\t\t\t\t\t\tiDisplay='" . $this->request['display'] . "',\n\t\t\t\t\t\t\t\t\t\tiItemid_FK='" . $this->request['productid'] . "',\n\t\t\t\t\t\t\t\t\t\ttmDateAdd='{$timestamp}' WHERE iCustRevid_PK='" . $rs[0]->iCustRevid_PK . "'"; $this->obDb->updateQuery(); } # additional functionality to e-mail admin on new submission of new product review - MCB, 26/09/2008 $this->obDb->query = "SELECT vFirstName, vLastName FROM " . CUSTOMERS . " WHERE iCustmerid_PK=" . $_SESSION['userid']; $name_row = $this->obDb->fetchQuery(); $customername = $name_row[0]->vFirstName . " " . $name_row[0]->vLastName; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject("New product review"); $obMail->setCrlf("\n"); //to handle mails in Outlook Express $message = "Somebody has posted a new product review on your on-line store.<br>Details of this review are listed below.<br><br>"; $message .= $customername . " submitted the following at " . date('g:ia') . " on " . date('l, d F Y') . ":<br><br>"; $message .= $this->libFunc->m_displayContent($this->request['comment']) . "<br><br>"; $message .= "To view this comment, please visit the following URL:<br>"; $message .= "<a href=\"" . SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $this->request['mode'] . "\">" . SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $this->request['mode'] . "</a>"; $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)) { $result = $obMail->send(array(ADMIN_EMAIL)); } } # redirect on posting and e-mailing of comment ... $retUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $this->request['seotitle']); $this->libFunc->m_mosRedirect($retUrl); exit; }
function m_sendConfirmation() { $this->comFunc->obDb = $this->obDb; $this->obDb->query = "SELECT vFirstName,vLastName,vEmail FROM " . ORDERS . " WHERE iOrderid_PK = '" . $this->request['orderid'] . "'"; $qryResult = $this->obDb->fetchQuery(); $rCount = $this->obDb->record_count; // $uniqID=uniqid (3); if ($rCount > 0) { $name = $this->libFunc->m_displayContent($qryResult[0]->vFirstName) . " " . $this->libFunc->m_displayContent($qryResult[0]->vLastName); $this->ObTpl = new template(); $this->ObTpl->set_file("TPL_MAIL_FILE", $this->mailTemplate); $this->ObTpl->set_var("TPL_VAR_NAME", $name); $this->ObTpl->set_var("TPL_VAR_INVOICE", $this->request['invoice']); $this->ObTpl->set_var("TPL_VAR_METHOD", $this->request['shipper']); $this->ObTpl->set_var("TPL_VAR_TRACKNUM", $this->request['tracking']); $orderUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=checkout.receipt&mode=" . $this->request['orderid']); $this->ObTpl->set_var("TPL_VAR_URL", $orderUrl); $this->ObTpl->set_var("TPL_VAR_MAILFOOTER", $this->comFunc->m_mailFooter()); $message = $this->ObTpl->parse("return", "TPL_MAIL_FILE"); $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); #11-05-07 $obMail->setSubject("Your order from " . SITE_NAME . " has shipped!"); $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(); $result = $obMail->send(array($qryResult[0]->vEmail)); } }
function m_sendPassword() { $this->obDb->query = "select iCustmerid_PK,vFirstName,vEmail,tmSignupDate FROM " . CUSTOMERS . " WHERE vEmail = '" . $this->request['email'] . "' AND iRegistered='1'"; $qryResult = $this->obDb->fetchQuery(); $rCount = $this->obDb->record_count; if (isset($this->cart)) { $action = "ecom/index.php?action=checkout.loginForm"; } else { $action = "user/index.php?action=user.loginForm"; } if ($rCount > 0) { $requesttime = time(); $recoveryid = md5($qryResult[0]->iCustmerid_PK . $qryResult[0]->vFirstName . $qryResult[0]->vEmail . $qryResult[0]->tmSignupDate . $requesttime); $this->obDb->query = "UPDATE " . CUSTOMERS . " SET vRecovery='" . $recoveryid . "',tRequestTime='" . $requesttime . "' WHERE iCustmerid_PK='" . $qryResult[0]->iCustmerid_PK . "' AND iRegistered='1'"; $this->obDb->updateQuery(); // $uniqID=uniqid (3); $message = "Hi " . $this->libFunc->m_displayContent($qryResult[0]->vFirstName); $message .= "<br><br>You requested to reset your login details for Username: " . $qryResult[0]->vEmail; $message .= "<br><br>You can do so by visiting this <a href='" . SITE_URL . "user/index.php?action=user.recover&id=" . $recoveryid . "'>link</a>."; $message .= "<br>If the link is not clickable, copy and paste this url into your browser: " . SITE_URL . "user/index.php?action=user.recover&id=" . $recoveryid; $message .= "<br>You must click the above password within 24 hours of your request or the link will be deactivated."; $message .= "<br><br>If you didn't request to reset your password, then please disregard this message."; $message .= "<br><br>Best Regards,"; $message .= "<br><a href='" . SITE_URL . "'>" . SITE_NAME . "</a>"; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject("Login details from " . 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(); $result = $obMail->send(array($qryResult[0]->vEmail)); $retUrl = $this->libFunc->m_safeUrl(SITE_URL . $action . "&mode=sent&msg=1"); $this->libFunc->m_mosRedirect($retUrl); exit; } else { $retUrl = $this->libFunc->m_safeUrl(SITE_URL . $action . "&mode=lost&msg=2"); $this->libFunc->m_mosRedirect($retUrl); exit; } }
function m_sendEmail() { $this->ObTpl = new template(); $this->ObTpl->set_file("TPL_VAR_ENQUIRYEMAIL", $this->templatePath . "enquiryMail.tpl.htm"); $this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_URL); $this->ObTpl->set_var("TPL_VAR_SITENAME", SITE_NAME); $this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY); $this->ObTpl->set_var("TPL_VAR_PRODUCTNAME", $this->libFunc->m_displayContent($this->request['productName'])); $this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($this->request['sku'])); $productUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $this->request['seoTitle']); $this->ObTpl->set_var("TPL_VAR_PRODUCTURL", $productUrl); $this->ObTpl->set_var("TPL_VAR_SKU", $this->libFunc->m_displayContent($this->request['sku'])); $this->ObTpl->set_var("TPL_VAR_NAME", $this->libFunc->m_displayContent($this->request['custname'])); $this->ObTpl->set_var("TPL_VAR_EMAIL", $this->libFunc->m_displayContent($this->request['email'])); $this->ObTpl->set_var("TPL_VAR_ADDRESS1", $this->libFunc->m_displayContent($this->request['address1'])); $this->ObTpl->set_var("TPL_VAR_ADDRESS2", $this->libFunc->m_displayContent($this->request['address2'])); $this->ObTpl->set_var("TPL_VAR_PHONE", $this->libFunc->m_displayContent($this->request['Phone'])); $this->ObTpl->set_var("TPL_VAR_COUNTRY", $this->libFunc->m_displayContent($this->request['sCountry'])); $this->ObTpl->set_var("TPL_VAR_COMMENTS", nl2br($this->libFunc->m_displayContent($this->request['comments']))); $message = $this->ObTpl->parse("return", "TPL_VAR_ENQUIRYEMAIL"); $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom($this->libFunc->m_displayContent($this->request['custname']) . "<" . $this->request['email'] . ">"); $obMail->setSubject(SITE_NAME . " Product Enquiry"); $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(); $result = $obMail->send(array(ADMIN_EMAIL)); $retUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=enquiry.status"); $this->libFunc->m_mosRedirect($retUrl); exit; }
function m_sendMail() { $timestamp = time(); $accounturl = $this->libFunc->m_safeUrl(SITE_URL . "user/index.php?action=user.home"); $htmlfooter = "<br /><br />=================================================="; $htmlfooter .= "<br />You have requested to receive emails from " . SITE_NAME . " <br />\t\tIf you do not wish to receive any emails of this nature please <br />\t\t<a href='" . $accounturl . "'>Click here</a> to be removed from our list.\n\t\t<br />"; $htmlfooter .= "==================================================<br />"; $this->obDb->query = "select vSid,vSubject,tHtmlMail,tTextMail,vUserList,vVisitorList FROM " . EMAILS . " WHERE iMailid_PK = '" . $this->request['id'] . "'"; $qryResult = $this->obDb->fetchQuery(); $rCount = $this->obDb->record_count; if ($rCount > 0) { if (!isset($this->request['to'])) { if ($qryResult[0]->vUserList != "All") { $this->obDb->query = "SELECT vFirstName,vEmail,iMailList FROM " . LEADLIST . "," . CUSTOMERS . "\tWHERE iCustomerid_FK=iCustmerid_PK AND iLeadId_FK='" . $qryResult[0]->vUserList . "'"; } else { $this->obDb->query = "SELECT vFirstName,vEmail,iMailList FROM " . CUSTOMERS . "\tWHERE iStatus =1 && iMailList!='0'"; } $qryResult1 = $this->obDb->fetchQuery(); $rCount1 = $this->obDb->record_count; if ($qryResult[0]->vVisitorList == "1") { $this->obDb->query = "SELECT * FROM " . NEWSLETTERS; $qryVs = $this->obDb->fetchQuery(); } $start = count($qryResult1); $a = 0; if (isset($qryVs)) { foreach ($qryVs as $k => $v) { $qryResult1[$start]->vFirstName = ""; $qryResult1[$start]->vEmail = $v->vEmail; $qryResult1[$start]->iMailList = 1; $qryResult1[$start]->PKVisitor = $v->iSignup_PK; $start = $start + 1; $a = $a + 1; } $rCount1 = $rCount1 + $a; } $this->obDb->query = "SELECT '' as vFirstName, '' as iMailList, vEmail FROM " . NEWSLETTERS; $newsletters = $this->obDb->fetchQuery(); $newsletterscount = $this->obDb->record_count; $totalcount = $newsletterscount + $rCount1; $qryResult1 = $qryResult1 + $newsletters; if ($totalcount > 0) { for ($i = 0; $i < $rCount1; $i++) { if ($qryResult1[$i]->vFirstName != '') { $message = "Hi " . $qryResult1[$i]->vFirstName; } else { $message = "Hi Customer "; } if (!empty($qryResult[0]->vSid)) { $message .= "<br /><br /><a href=" . SITE_URL . "sid/" . $this->libFunc->m_displayContent($qryResult[0]->vSid) . ">" . SITE_URL . "sid/" . $this->libFunc->m_displayContent($qryResult[0]->vSid) . "</a><br />"; } $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject($qryResult[0]->vSubject); $obMail->setCrlf("\n"); //to handle mails in Outlook Express if (isset($qryResult1[$i]->PKVisitor)) { $accounturl = $this->libFunc->m_safeUrl(SITE_URL . "index.php?action=contactus.unsubscribe&mode=" . $qryResult1[$i]->PKVisitor); $htmlfooter = "<br /><br />=================================================="; $htmlfooter .= "<br />You have requested to receive emails from " . SITE_NAME . " <br />\t\tIf you do not wish to receive any emails of this nature please <br />\t\t<a href='" . $accounturl . "'>Click here</a> to be removed from our list.<br />"; $htmlfooter .= "==================================================<br />"; } if ($qryResult1[$i]->iMailList != 1) { $htmlcontent = $message . "<br /><br />" . $this->libFunc->m_displayContent($qryResult[0]->tTextMail); $htmlcontent .= $htmlfooter; } else { $htmlcontent = $message . "<br />" . $this->libFunc->m_displayContent1($qryResult[0]->tHtmlMail); $htmlcontent .= $htmlfooter; } $plaintxt = $message . "<br />" . $this->libFunc->m_displayContent($qryResult[0]->tTextMail); $txtcontent = preg_replace("/<([^>]+)>/", "", preg_replace("/<br(\\/{0,1})>/", "\r\n", $plaintxt)); $obMail->setHtml(nl2br($htmlcontent), $txtcontent); $obMail->buildMessage(); $result = $obMail->send(array($qryResult1[$i]->vEmail)); } } $this->obDb->query = "UPDATE " . EMAILS . " SET \n\t\t\t\ttmSentDate ='{$timestamp}' \n\t\t\t\tWHERE iMailid_PK = '" . $this->request['id'] . "'"; $qryResult2 = $this->obDb->updateQuery(); } elseif ($this->request['to'] == 'test') { $message = "Hi Admin"; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject($qryResult[0]->vSubject); $obMail->setCrlf("\n"); //to handle mails in Outlook Express if (!empty($qryResult[0]->vSid)) { $message .= "<br /><br /><a href=" . SITE_URL . "sid/" . $this->libFunc->m_displayContent($qryResult[0]->vSid) . ">" . SITE_URL . "sid/" . $this->libFunc->m_displayContent($qryResult[0]->vSid) . "</a><br />"; } $htmlcontent1 = $message . "<br>" . $this->libFunc->m_displayContent($qryResult[0]->tTextMail); $htmlcontent1 .= $htmlfooter; $htmlcontent2 = $message . "<br>" . $this->libFunc->m_displayContent1($qryResult[0]->tHtmlMail); $htmlcontent2 .= $htmlfooter; $plaintxt = $message . "<br>" . $qryResult[0]->tTextMail; $txtcontent = preg_replace("/<([^>]+)>/", "", preg_replace("/<br(\\/{0,1})>/", "\r\n", $plaintxt)); $obMail->setHtml(nl2br($htmlcontent1), $txtcontent); $obMail->buildMessage(); $result = $obMail->send(array($this->request['email'])); $obMail->setHtml(nl2br($htmlcontent2), $txtcontent); $obMail->buildMessage(); $result = $obMail->send(array($this->request['email'])); } $this->libFunc->m_mosRedirect(SITE_URL . "sales/adminindex.php?action=email.home&msg=5"); exit; } else { $this->libFunc->m_mosRedirect(SITE_URL . "sales/adminindex.php?action=email.home&msg=6"); exit; } }
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_sendEmail() { $this->ObTpl = new template(); $this->ObTpl->set_file("TPL_VAR_WISHEMAIL", $this->templatePath . "wishlistEmail.tpl.htm"); $this->ObTpl->set_block("TPL_VAR_WISHEMAIL", "TPL_PRODUCT_BLK", "product_blk"); $this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_URL); $this->ObTpl->set_var("TPL_VAR_SITENAME", SITE_NAME); $this->ObTpl->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY); $this->ObTpl->set_var("product_blk", ""); $this->obDb->query = "SELECT vFirstName,vLastName,vEmail FROM " . CUSTOMERS . " WHERE iCustmerid_PK ='" . $_SESSION['userid'] . "'"; $rsCustomer = $this->obDb->fetchQuery(); $rsCustomer[0]->vFirstName; $senderName = $this->libFunc->m_displayContent($rsCustomer[0]->vFirstName) . " " . $this->libFunc->m_displayContent($rsCustomer[0]->vLastName); $this->ObTpl->set_var("TPL_VAR_SENDERNAME", $senderName); $this->ObTpl->set_var("TPL_VAR_MESSAGE", nl2br($this->libFunc->m_displayContent($this->request['comment']))); $this->obDb->query = "SELECT iShopWishid_PK,vTitle,vQuantity,vSeoTitle,iTaxable,fPrice FROM " . PRODUCTS . "," . WISHLIST . " WHERE iProductid_FK=iProdid_PK AND iCustomerid_FK='" . $_SESSION['userid'] . "'"; $rowProduct = $this->obDb->fetchQuery(); $productCount = $this->obDb->record_count; if ($productCount > 0) { for ($i = 0; $i < $productCount; $i++) { $productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rowProduct[$i]->vSeoTitle; $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]->iShopWishid_PK)); $this->ObTpl->set_var("TPL_VAR_TITLE", $this->libFunc->m_displayContent($rowProduct[$i]->vTitle)); if ($rowProduct[$i]->iTaxable == 1) { #GETTING VAT PRICE $vatPercent = $this->libFunc->m_vatCalculate(); $vatPrice = number_format($vatPercent * $rowProduct[$i]->fPrice / 100 + $rowProduct[$i]->fPrice, 2); $this->ObTpl->set_var("TPL_VAR_PRICE", $this->libFunc->m_displayContent($rowProduct[$i]->fPrice) . " (" . CONST_CURRENCY . $vatPrice . " inc. Vat)"); } else { $this->ObTpl->set_var("TPL_VAR_PRICE", $this->libFunc->m_displayContent($rowProduct[$i]->fPrice)); } $this->ObTpl->parse("product_blk", "TPL_PRODUCT_BLK", true); } } $message = $this->ObTpl->parse("return", "TPL_VAR_WISHEMAIL"); $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom($this->libFunc->m_displayContent(SITE_NAME) . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject("Wishlist from " . $senderName . " 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(); $this->obDb->query = "SELECT iWishid_PK,vEmail FROM " . WISHEMAILS . " WHERE iCustomerid_FK='" . $_SESSION['userid'] . "'"; $rsWishEmail = $this->obDb->fetchQuery(); $rsCount = $this->obDb->record_count; if ($rsCount > 0) { $toArray = array(); for ($i = 0; $i <= $rsCount - 1; $i++) { $toArray[$i] = $rsWishEmail[$i]->vEmail; } $result = $obMail->send($toArray); } $retUrl = $this->libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=wishlist.display&mode=dspmsg"); $this->libFunc->m_mosRedirect($retUrl); }
function m_forgetPassword() { $this->obDb->query = "select iAdminid_PK,vUsername,vPassword,vEmail FROM " . ADMINUSERS . " WHERE vUsername = '******'username']) . "' AND vEmail='" . trim($this->request['email']) . "'"; $qryResult = $this->obDb->fetchQuery(); $rCount = $this->obDb->record_count; $uniqID = uniqid(3); if ($rCount > 0) { $this->libFunc->obDb = $this->obDb; $this->libFunc->m_removeBans($qryResult[0]->vUsername); $message = "Hi " . $qryResult[0]->vUsername; $message .= "<br><br>Here are your login details:"; $message .= "<br><br>Username: " . $qryResult[0]->vUsername; $message .= "<br>Password: " . $uniqID; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ADMIN_EMAIL . ">"); $obMail->setSubject("Login details from " . 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(); $result = $obMail->send(array($qryResult[0]->vEmail)); $this->obDb->query = "UPDATE " . ADMINUSERS . " SET vPassword=password('" . $uniqID . "') WHERE iAdminid_PK=" . $qryResult[0]->iAdminid_PK; $qryResult = $this->obDb->updateQuery(); $this->libFunc->m_mosRedirect(SITE_URL . "adminindex.php?msg=3"); } else { $this->libFunc->m_mosRedirect(SITE_URL . "adminindex.php?action=forget&msg=4"); } }
function m_sendStockMail() { $this->obDb->query = "SELECT vSku,vTitle,iInventory,iUseinventory FROM " . PRODUCTS . " WHERE iProdId_PK='" . $this->productId . "'"; $rs = $this->obDb->fetchQuery(); #TO CHECK STOCK CONTROL ENABLED if ($rs[0]->iUseinventory == 1) { if ($rs[0]->iInventory < 1) { $message = "========================================<br />"; $message .= "Low stock levels for " . $this->libFunc->m_displayContent($rs[0]->vTitle) . "<br />"; $message .= "========================================<br />"; $message .= "The quantity for the following product has reached reorder levels:<br />"; $message .= "<br>Product Code: " . $this->libFunc->m_displayContent($rs[0]->vSku); $message .= "<br>Product Title: " . $this->libFunc->m_displayContent($rs[0]->vTitle); $message .= "<br>Quantity on hand: " . $rs[0]->iInventory; $obMail = new htmlMimeMail(); $obMail->setReturnPath(ADMIN_EMAIL); $obMail->setFrom(SITE_NAME . "<" . ORDER_EMAIL . ">"); $obMail->setSubject("Stocks Low for " . $rs[0]->vTitle); $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(); $result = $obMail->send(array(ADMIN_EMAIL)); } } }