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