function sendEmailAdmin($order_ids, $status = null)
{
global $sess, $VM_LANG, $vmLogger;
$urls = array();
foreach ($order_ids as $order_id) {
$urls[$order_id]['site'] = SECUREURL . "index.php?option=com_virtuemart&page=account.order_details&order_id=" . $order_id . '&order_key=' . md5('AIR' . $order_id . 'SOFT' . $order_id . 'STORE') . '&Itemid=' . $sess->getShopItemid();
$urls[$order_id]['admin'] = SECUREURL . '/administrator/index.php?page=order.order_print&limitstart=0&order_id=' . $order_id . '&option=com_virtuemart';
}
$db = new ps_DB();
$dbv = new ps_DB();
$q = "SELECT vendor_name,contact_email FROM #__{vm}_vendor ";
$q .= "WHERE vendor_id='" . $_SESSION['ps_vendor_id'] . "'";
$dbv->query($q);
$dbv->next_record();
// $q = "SELECT first_name,last_name,user_email,order_status_name FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";
// $q .= "WHERE #__{vm}_orders.order_id = '" . $db->getEscaped($order_id) . "' ";
// $q .= "AND #__{vm}_orders.user_id = #__{vm}_order_user_info.user_id ";
// $q .= "AND #__{vm}_orders.order_id = #__{vm}_order_user_info.order_id ";
// $q .= "AND order_status = order_status_code ";
// $db->query($q);
// $db->next_record();
/*
$providerlist = $this->getProviderlist();
$tracking = $this->getTracking($order_id);
if ($tracking->provider) {
$provider = $this->getProvider($tracking->provider);
$provider->setData($tracking);
}
$siteTrackingUrl = $provider->getSiteUrlTracking();
$provider = $tracking->provider;
$tracknumber = $tracking->tracknumber;
$date = $tracking->date;
if (!$tracknumber) {
return false;
}
*
*/
$statusText = '';
$statusText = 'Следующие заказы были доставлены: ';
ob_start();
require CLASSPATH . 'sc_trackingpost/tmpl/email/admin_email_tracking.php';
$message = ob_get_contents();
ob_end_clean();
$mail_Body = $message;
// $mail_Body = html_entity_decode($message);
//$mail_Subject = 'Данные для отслеживания посылки по к заказу№' . $order_id;
//Inf Временная заглушка
// $admin_email = $dbv->f("contact_email");
$admin_email = '*****@*****.**';
$result = vmMail($admin_email, 'admin', $admin_email, $status, $mail_Body, '', true);
return $result;
}
/**
* Create a receipt for the current order and email it to
* the customer and the vendor.
* @author gday
* @author soeren
* @param int $order_id
* @return boolean True on success, false on failure
*/
function email_receipt($order_id)
{
global $sess, $ps_product, $VM_LANG, $CURRENCY_DISPLAY, $vmLogger, $mosConfig_fromname, $mosConfig_lang, $database;
$ps_vendor_id = vmGet($_SESSION, 'ps_vendor_id', 1);
$auth = $_SESSION["auth"];
require_once CLASSPATH . 'ps_order_status.php';
require_once CLASSPATH . 'ps_userfield.php';
require_once CLASSPATH . 'ps_product.php';
$ps_product = new ps_product();
// Connect to database and gather appropriate order information
$db = new ps_DB();
$q = "SELECT * FROM #__{vm}_orders WHERE order_id='{$order_id}'";
$db->query($q);
$db->next_record();
$user_id = $db->f("user_id");
$customer_note = $db->f("customer_note");
$order_status = ps_order_status::getOrderStatusName($db->f("order_status"));
$dbbt = new ps_DB();
$dbst = new ps_DB();
$qt = "SELECT * FROM #__{vm}_user_info WHERE user_id='" . $user_id . "' AND address_type='BT'";
$dbbt->query($qt);
$dbbt->next_record();
$qt = "SELECT * FROM #__{vm}_user_info WHERE user_info_id='" . $db->f("user_info_id") . "'";
$dbst->query($qt);
$dbst->next_record();
$dbv = new ps_DB();
$qt = "SELECT * from #__{vm}_vendor ";
/* Need to decide on vendor_id <=> order relationship */
$qt .= "WHERE vendor_id = '" . $ps_vendor_id . "'";
$dbv->query($qt);
$dbv->next_record();
$dboi = new ps_DB();
$q_oi = "SELECT * FROM #__{vm}_product, #__{vm}_order_item, #__{vm}_orders ";
$q_oi .= "WHERE #__{vm}_product.product_id=#__{vm}_order_item.product_id ";
$q_oi .= "AND #__{vm}_order_item.order_id='{$order_id}' ";
$q_oi .= "AND #__{vm}_orders.order_id=#__{vm}_order_item.order_id";
$dboi->query($q_oi);
$db_payment = new ps_DB();
$q = "SELECT op.payment_method_id, pm.payment_method_name FROM #__{vm}_order_payment as op, #__{vm}_payment_method as pm\n WHERE order_id='{$order_id}' AND op.payment_method_id=pm.payment_method_id";
$db_payment->query($q);
$db_payment->next_record();
if ($auth["show_price_including_tax"] == 1) {
$order_shipping = $db->f("order_shipping");
$order_shipping += $db->f("order_shipping_tax");
$order_shipping_tax = 0;
$order_tax = $db->f("order_tax") + $db->f("order_shipping_tax");
} else {
$order_shipping = $db->f("order_shipping");
$order_shipping_tax = $db->f("order_shipping_tax");
$order_tax = $db->f("order_tax");
}
$order_total = $db->f("order_total");
$order_discount = $db->f("order_discount");
$coupon_discount = $db->f("coupon_discount");
// Email Addresses for shopper and vendor
// **************************************
$shopper_email = $dbbt->f("user_email");
$shopper_name = $dbbt->f("first_name") . " " . $dbbt->f("last_name");
$from_email = $dbv->f("contact_email");
$shopper_subject = $dbv->f("vendor_name") . " " . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_LBL', false) . " - " . $db->f("order_id");
$vendor_subject = $dbv->f("vendor_name") . " " . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_LBL', false) . " - " . $db->f("order_id");
$shopper_order_link = $sess->url(SECUREURL . "index.php?page=account.order_details&order_id={$order_id}", true, false);
$vendor_order_link = $sess->url(SECUREURL . "index2.php?page=order.order_print&order_id={$order_id}&pshop_mode=admin", true, false);
/**
* Prepare the payment information, including Credit Card information when not empty
*/
$payment_info_details = $db_payment->f("payment_method_name");
if (!empty($_SESSION['ccdata']['order_payment_name']) && !empty($_SESSION['ccdata']['order_payment_number'])) {
$payment_info_details .= '<br />' . $VM_LANG->_('PHPSHOP_CHECKOUT_CONF_PAYINFO_NAMECARD', false) . ': ' . $_SESSION['ccdata']['order_payment_name'] . '<br />';
$payment_info_details .= $VM_LANG->_('PHPSHOP_CHECKOUT_CONF_PAYINFO_CCNUM', false) . ': ' . $this->asterisk_pad($_SESSION['ccdata']['order_payment_number'], 4) . '<br />';
$payment_info_details .= $VM_LANG->_('PHPSHOP_CHECKOUT_CONF_PAYINFO_EXDATE', false) . ': ' . $_SESSION['ccdata']['order_payment_expire_month'] . ' / ' . $_SESSION['ccdata']['order_payment_expire_year'] . '<br />';
if (!empty($_SESSION['ccdata']['credit_card_code'])) {
$payment_info_details .= 'CVV code: ' . $_SESSION['ccdata']['credit_card_code'] . '<br />';
}
}
// Convert HTML into Text
$payment_info_details_text = str_replace('<br />', "\n", $payment_info_details);
// Get the Shipping Details
$shipping_arr = explode("|", urldecode(vmGet($_REQUEST, "shipping_rate_id")));
// Headers and Footers
// ******************************
// Shopper Header
$shopper_header = $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER1', false) . "\n";
$legal_info_title = '';
$legal_info_html = '';
// Get the legal information about the returns/order cancellation policy
if (@VM_ONCHECKOUT_SHOW_LEGALINFO == '1') {
$article = intval(@VM_ONCHECKOUT_LEGALINFO_LINK);
if ($article > 0) {
$db_legal = new ps_DB();
// Get the content article, which contains the Legal Info
$db_legal->query('SELECT id, title, introtext FROM #__content WHERE id=' . $article);
$db_legal->next_record();
if ($db_legal->f('introtext')) {
$legal_info_title = $db_legal->f('title');
$legal_info_text = strip_tags(str_replace('<br />', "\n", $db_legal->f('introtext')));
$legal_info_html = $db_legal->f('introtext');
}
}
}
//Shopper Footer
$shopper_footer = "\n\n" . $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER2', false) . "\n";
if (VM_REGISTRATION_TYPE != 'NO_REGISTRATION') {
$shopper_footer .= "\n\n" . $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER5', false) . "\n";
$shopper_footer .= $shopper_order_link;
}
$shopper_footer .= "\n\n" . $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER3', false) . "\n";
$shopper_footer .= "Email: " . $from_email;
// New in version 1.0.5
if (@VM_ONCHECKOUT_SHOW_LEGALINFO == '1' && !empty($legal_info_title)) {
$shopper_footer .= "\n\n____________________________________________\n";
$shopper_footer .= $legal_info_title . "\n";
$shopper_footer .= $legal_info_text . "\n";
}
// Vendor Header
$vendor_header = $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER4', false) . "\n";
// Vendor Footer
$vendor_footer = "\n\n" . $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER5', false) . "\n";
$vendor_footer .= $vendor_order_link;
$vendor_email = $from_email;
/////////////////////////////////////
// set up text mail
//
// Main Email Message Purchase Order
// *********************************
$shopper_message = "\n" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_LBL', false) . "\n";
$shopper_message .= "------------------------------------------------------------------------\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER', false) . ": " . $db->f("order_id") . "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_DATE', false) . ": ";
$shopper_message .= strftime($VM_LANG->_('DATE_FORMAT_LC'), $db->f("cdate")) . "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_STATUS', false) . ": ";
$shopper_message .= $order_status . "\n\n";
// BillTo Fields
$registrationfields = ps_userfield::getUserFields('registration', false, '', false, true);
foreach ($registrationfields as $field) {
if ($field->name == 'email') {
$field->name = 'user_email';
}
if ($field->name == 'delimiter_sendregistration' || $field->type == 'captcha') {
continue;
}
if ($field->type == 'delimiter') {
$shopper_message .= ($VM_LANG->_($field->title) != '' ? $VM_LANG->_($field->title) : $field->title) . "\n";
$shopper_message .= "--------------------\n\n";
} else {
$shopper_message .= ($VM_LANG->_($field->title) != '' ? $VM_LANG->_($field->title) : $field->title) . ': ';
$shopper_message .= $dbbt->f($field->name) . "\n";
}
}
// Shipping Fields
$shopper_message .= "\n\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIP_TO_LBL') . "\n";
$shopper_message .= "-------\n\n";
$shippingfields = ps_userfield::getUserFields('shipping', false, '', false, true);
foreach ($shippingfields as $field) {
if ($field->type == 'delimiter') {
$shopper_message .= ($VM_LANG->_($field->title) != '' ? $VM_LANG->_($field->title) : $field->title) . "\n";
$shopper_message .= "--------------------\n\n";
} else {
$shopper_message .= ($VM_LANG->_($field->title) != '' ? $VM_LANG->_($field->title) : $field->title) . ': ';
$shopper_message .= $dbst->f($field->name) . "\n";
}
}
$shopper_message .= "\n\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_ITEMS_LBL', false) . "\n";
$shopper_message .= "-----------";
$sub_total = 0.0;
while ($dboi->next_record()) {
$shopper_message .= "\n\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_PRODUCT', false) . " = ";
if ($dboi->f("product_parent_id")) {
$shopper_message .= $dboi->f("order_item_name") . "\n";
$shopper_message .= "SERVICE = ";
}
$shopper_message .= $dboi->f("product_name") . "; " . $dboi->f("product_attribute") . "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_QUANTITY', false) . " = ";
$shopper_message .= $dboi->f("product_quantity") . "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SKU', false) . " = ";
$shopper_message .= $dboi->f("order_item_sku") . "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_PRICE', false) . " = ";
if ($auth["show_price_including_tax"] == 1) {
$sub_total += $dboi->f("product_quantity") * $dboi->f("product_final_price");
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($dboi->f("product_final_price"), '', $db->f('order_currency'));
} else {
$sub_total += $dboi->f("product_quantity") * $dboi->f("product_final_price");
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($dboi->f("product_item_price"), '', $db->f('order_currency'));
}
}
$shopper_message .= "\n\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SUBTOTAL', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($sub_total, '', $db->f('order_currency')) . "\n";
if (PAYMENT_DISCOUNT_BEFORE == '1') {
if (!empty($order_discount)) {
if ($order_discount > 0) {
$shopper_message .= $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT', false) . " = ";
$shopper_message .= "- " . $CURRENCY_DISPLAY->getFullValue(abs($order_discount), '', $db->f('order_currency')) . "\n";
} else {
$shopper_message .= $VM_LANG->_('PHPSHOP_FEE', false) . " = ";
$shopper_message .= "+ " . $CURRENCY_DISPLAY->getFullValue(abs($order_discount), '', $db->f('order_currency')) . "\n";
}
}
if (!empty($coupon_discount)) {
/* following 2 lines added by Erich for coupon hack */
$shopper_message .= $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT', false) . ": ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($coupon_discount, '', $db->f('order_currency')) . "\n";
}
}
if ($auth["show_price_including_tax"] != 1) {
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($order_tax, '', $db->f('order_currency')) . "\n";
}
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($order_shipping, '', $db->f('order_currency')) . "\n";
if (!empty($order_shipping_tax)) {
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_TAX', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($order_shipping_tax, '', $db->f('order_currency'));
}
$shopper_message .= "\n\n";
if (PAYMENT_DISCOUNT_BEFORE != '1') {
if (!empty($order_discount)) {
if ($order_discount > 0) {
$shopper_message .= $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT', false) . " = ";
$shopper_message .= "- " . $CURRENCY_DISPLAY->getFullValue(abs($order_discount), '', $db->f('order_currency')) . "\n";
} else {
$shopper_message .= $VM_LANG->_('PHPSHOP_FEE', false) . " = ";
$shopper_message .= "+ " . $CURRENCY_DISPLAY->getFullValue(abs($order_discount), '', $db->f('order_currency')) . "\n";
}
}
if (!empty($coupon_discount)) {
/* following 2 lines added by Erich for coupon hack */
$shopper_message .= $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT', false) . ": ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($coupon_discount, '', $db->f('order_currency')) . "\n";
}
}
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($order_total, '', $db->f('order_currency'));
if ($auth["show_price_including_tax"] == 1) {
$shopper_message .= "\n---------------";
$shopper_message .= "\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX', false) . " = ";
$shopper_message .= $CURRENCY_DISPLAY->getFullValue($order_tax, '', $db->f('order_currency')) . "\n";
}
if ($db->f('order_tax_details')) {
$shopper_message .= str_replace('<br />', "\n", ps_checkout::show_tax_details($db->f('order_tax_details'), $db->f('order_currency')));
}
// Payment Details
$shopper_message .= "\n\n------------------------------------------------------------------------\n";
$shopper_message .= $payment_info_details_text;
// Shipping Details
if (is_object($this->_SHIPPING)) {
$shopper_message .= "\n\n------------------------------------------------------------------------\n";
$shopper_message .= $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_LBL', false) . ":\n";
$shopper_message .= $shipping_arr[1] . " (" . $shipping_arr[2] . ")";
}
// Customer Note
$shopper_message .= "\n\n------------------------------------------------------------------------\n";
$shopper_message .= "\n" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUSTOMER_NOTE', false) . "\n";
$shopper_message .= "---------------";
$shopper_message .= "\n";
if (!empty($customer_note)) {
$shopper_message .= $customer_note . "\n";
} else {
$shopper_message .= " ./. \n";
}
$shopper_message .= "------------------------------------------------------------------------\n";
// Decode things like € => €
$shopper_message = vmHtmlEntityDecode($shopper_message);
// End of Purchase Order
// *********************
//
//END: set up text mail
/////////////////////////////////////
// Send text email
//
if (ORDER_MAIL_HTML == '0') {
$msg = $shopper_header . $shopper_message . $shopper_footer;
// Mail receipt to the shopper
vmMail($from_email, $mosConfig_fromname, $shopper_email, $shopper_subject, $msg, "");
$msg = $vendor_header . $shopper_message . $vendor_footer;
// Mail receipt to the vendor
vmMail($from_email, $mosConfig_fromname, $vendor_email, $vendor_subject, $msg, "");
} elseif (ORDER_MAIL_HTML == '1') {
$dboi->query($q_oi);
// Create Template Object
$template = vmTemplate::getInstance();
if ($order_discount > 0) {
$order_discount_lbl = $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');
$order_discount_plusminus = '-';
} else {
$order_discount_lbl = $VM_LANG->_('PHPSHOP_FEE');
$order_discount_plusminus = '+';
}
if ($coupon_discount > 0) {
$coupon_discount_lbl = $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');
$coupon_discount_plusminus = '-';
} else {
$coupon_discount_lbl = $VM_LANG->_('PHPSHOP_FEE');
$coupon_discount_plusminus = '+';
}
if (is_object($this->_SHIPPING)) {
$shipping_info_details = stripslashes($shipping_arr[1]) . " (" . stripslashes($shipping_arr[2]) . ")";
} else {
$shipping_info_details = ' ./. ';
}
// These are a lot of vars to import for the email confirmation
$template->set_vars(array('is_email_to_shopper' => true, 'db' => $db, 'dboi' => $dboi, 'dbbt' => $dbbt, 'dbst' => $dbst, 'ps_product' => $ps_product, 'shippingfields' => $shippingfields, 'registrationfields' => $registrationfields, 'order_id' => $order_id, 'order_discount' => $order_discount, 'order_discount_lbl' => $order_discount_lbl, 'order_discount_plusminus' => $order_discount_plusminus, 'coupon_discount' => $coupon_discount, 'coupon_discount_lbl' => $coupon_discount_lbl, 'coupon_discount_plusminus' => $coupon_discount_plusminus, 'order_date' => $VM_LANG->convert(vmFormatDate($db->f("cdate"), $VM_LANG->_('DATE_FORMAT_LC'))), 'order_status' => $order_status, 'legal_info_title' => $legal_info_title, 'legal_info_html' => $legal_info_html, 'order_link' => $shopper_order_link, 'payment_info_lbl' => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYINFO_LBL'), 'payment_info_details' => $payment_info_details, 'shipping_info_lbl' => $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_LBL'), 'shipping_info_details' => $shipping_info_details, 'from_email' => $from_email, 'customer_note' => nl2br($customer_note), 'order_header_msg' => $shopper_header, 'order_subtotal' => $CURRENCY_DISPLAY->getFullValue($sub_total, '', $db->f('order_currency')), 'order_shipping' => $CURRENCY_DISPLAY->getFullValue($order_shipping, '', $db->f('order_currency')), 'order_tax' => $CURRENCY_DISPLAY->getFullValue($order_tax, '', $db->f('order_currency')) . ps_checkout::show_tax_details($db->f('order_tax_details'), $db->f('order_currency')), 'order_total' => $CURRENCY_DISPLAY->getFullValue($order_total, '', $db->f('order_currency'))));
$shopper_html = $template->fetch('order_emails/confirmation_email.tpl.php');
// Reset the list of order items for use in the vendor email
$dboi->reset();
// Override some vars for the vendor email, so we can use the same template
$template->set_vars(array('order_header_msg' => $vendor_header, 'order_link' => $vendor_order_link, 'is_email_to_shopper' => false));
$vendor_html = $template->fetch('order_emails/confirmation_email.tpl.php');
/*
* Add the text, html and embedded images.
* The name of the image should match exactly
* (case-sensitive) to the name in the html.
*/
$shopper_mail_Body = $shopper_html;
$shopper_mail_AltBody = $shopper_header . $shopper_message . $shopper_footer;
$vendor_mail_Body = $vendor_html;
$vendor_mail_AltBody = $vendor_header . $shopper_message . $vendor_footer;
$imagefile = pathinfo($dbv->f("vendor_full_image"));
$extension = $imagefile['extension'] == "jpg" ? "jpeg" : "jpeg";
$EmbeddedImages[] = array('path' => IMAGEPATH . "vendor/" . $dbv->f("vendor_full_image"), 'name' => "vendor_image", 'filename' => $dbv->f("vendor_full_image"), 'encoding' => "base64", 'mimetype' => "image/" . $extension);
$shopper_mail = vmMail($from_email, $mosConfig_fromname, $shopper_email, $shopper_subject, $shopper_mail_Body, $shopper_mail_AltBody, true, null, null, $EmbeddedImages);
$vendor_mail = vmMail($from_email, $mosConfig_fromname, $vendor_email, $vendor_subject, $vendor_mail_Body, $vendor_mail_AltBody, true, null, null, $EmbeddedImages, null, $shopper_email);
if (!$shopper_mail || !$vendor_mail) {
$vmLogger->debug('Something went wrong while sending the order confirmation email to ' . $from_email . ' and ' . $shopper_email);
return false;
}
//
// END: set up and send the HTML email
////////////////////////////////////////
}
return true;
}
function sendRecommendation(&$d)
{
global $vmLogger, $VM_LANG, $vendor_store_name;
if (!$this->validate($d)) {
return false;
}
$subject = sprintf($VM_LANG->_('VM_RECOMMEND_SUBJECT', false), $vendor_store_name);
$msg = vmRequest::getVar('recommend_message', '', 'post');
$send = vmMail($d['sender_mail'], $d['sender_name'], $d['recipient_mail'], $subject, $msg, '');
if ($send) {
$vmLogger->info($VM_LANG->_('VM_RECOMMEND_DONE', false));
} else {
$vmLogger->warning($VM_LANG->_('VM_RECOMMEND_FAILED', false));
return false;
}
unset($_REQUEST['sender_name']);
unset($_REQUEST['sender_mail']);
unset($_REQUEST['recipient_mail']);
unset($_REQUEST['recommend_message']);
return true;
}
function notify_list($product_id)
{
global $sess, $mosConfig_fromname, $VM_LANG;
$option = vmGet($_REQUEST, 'option');
$product_id = intval($product_id);
if ($product_id == 0) {
return False;
}
$dbv = new ps_DB();
$qt = "SELECT contact_email from #__{vm}_vendor ";
$qt .= "WHERE vendor_id='1'";
$dbv->query($qt);
$dbv->next_record();
$from_email = $dbv->f("contact_email");
$db = new ps_DB();
$q = 'SELECT notify_email FROM #__{vm}_waiting_list WHERE ';
$q .= 'notified="0" AND product_id=' . $product_id;
$db->query($q);
require_once CLASSPATH . 'ps_product.php';
$ps_product = new ps_product();
while ($db->next_record()) {
// get the product name for the e-mail
$product_name = $ps_product->get_field($product_id, "product_name");
// lets make the e-mail up from the info we have
$notice_subject = sprintf($VM_LANG->_('PRODUCT_WAITING_LIST_EMAIL_SUBJECT'), $product_name);
$flypage = $ps_product->get_flypage($product_id);
// now get the url information
$url = URL . "index.php?page=shop.product_details&flypage={$flypage}&product_id={$product_id}&option={$option}&Itemid=" . $sess->getShopItemid();
$notice_body = sprintf($VM_LANG->_('PRODUCT_WAITING_LIST_EMAIL_TEXT'), $product_name, $url);
// send the e-mail
$shopper_email = $db->f("notify_email");
vmMail($from_email, $mosConfig_fromname, $shopper_email, $notice_subject, $notice_body, "");
$this->update($shopper_email, $product_id);
}
return True;
}
/**
* Sends new/updated user notification emails
*
* @param string $name - The name of the newly created/updated user
* @param string $email - The email address of the newly created/updated user
* @param string $username - The username of the newly created/updated user
* @param string $password - The plain text password of the newly created/updated user
*/
function _sendMail($name, $email, $username, $pwd, $activation_link = '')
{
global $database, $acl, $VM_LANG;
global $mosConfig_sitename, $mosConfig_live_site, $mosConfig_useractivation;
global $mosConfig_mailfrom, $mosConfig_fromname;
$subject = sprintf($VM_LANG->_('SEND_SUB', false), $name, $mosConfig_sitename);
$subject = vmHtmlEntityDecode($subject, ENT_QUOTES);
if ($mosConfig_useractivation == "1") {
$message = sprintf($VM_LANG->_('USEND_MSG_ACTIVATE', false), $name, $mosConfig_sitename, $activation_link, $mosConfig_live_site, $username, $pwd);
} else {
$message = sprintf($VM_LANG->_('PHPSHOP_USER_SEND_REGISTRATION_DETAILS', false), $name, $mosConfig_sitename, $mosConfig_live_site, $username, $pwd);
}
$message = vmHtmlEntityDecode($message, ENT_QUOTES);
// Send email to user
if ($mosConfig_mailfrom != "" && $mosConfig_fromname != "") {
$adminName2 = $mosConfig_fromname;
$adminEmail2 = $mosConfig_mailfrom;
} else {
$query = "SELECT name, email" . "\n FROM #__users" . "\n WHERE LOWER( usertype ) = 'superadministrator'" . "\n OR LOWER( usertype ) = 'super administrator'";
$database->setQuery($query);
$rows = $database->loadObjectList();
$row2 = $rows[0];
$adminName2 = $row2->name;
$adminEmail2 = $row2->email;
}
if (VM_REGISTRATION_TYPE != 'NO_REGISTRATION' || VM_REGISTRATION_TYPE == 'OPTIONAL_REGISTRATION' && !empty($d['register_account'])) {
vmMail($adminEmail2, $adminName2, $email, $subject, $message);
}
// Send notification to all administrators
$subject2 = sprintf($VM_LANG->_('SEND_SUB', false), $name, $mosConfig_sitename);
$message2 = sprintf($VM_LANG->_('ASEND_MSG', false), $adminName2, $mosConfig_sitename, $name, $email, $username);
$subject2 = vmHtmlEntityDecode($subject2, ENT_QUOTES);
$message2 = vmHtmlEntityDecode($message2, ENT_QUOTES);
// get superadministrators id
$admins = $acl->get_group_objects(25, 'ARO');
if (empty($admins['users'])) {
return;
}
foreach ($admins['users'] as $id) {
$query = "SELECT email, sendEmail" . "\n FROM #__users" . "\n WHERE id = {$id}";
$database->setQuery($query);
$rows = $database->loadObjectList();
$row = $rows[0];
if ($row->sendEmail) {
vmMail($adminEmail2, $adminName2, $row->email, $subject2, $message2);
}
}
}
} else {
//----------------------------------------------------------------------
// If the payment_status is not Completed... do nothing but mail
//----------------------------------------------------------------------
// UPDATE THE ORDER STATUS to 'INVALID'
$d['order_status'] = PAYPAL_INVALID_STATUS;
require_once CLASSPATH . 'ps_order.php';
$ps_order = new ps_order();
$ps_order->order_status_update($d);
$mailsubject = "PayPal IPN Transaction on your site";
$mailbody = "Hello,\r\n a Failed PayPal Transaction on {$mosConfig_live_site} requires your attention.\r\n -----------------------------------------------------------\r\n Order ID: " . $d['order_id'] . "\r\n User ID: " . $db->f("user_id") . "\r\n Payment Status returned by PayPal: {$payment_status} \r\n \r\n {$error_description}";
vmMail($mosConfig_mailfrom, $mosConfig_fromname, $debug_email_address, $mailsubject, $mailbody);
}
} elseif (eregi("INVALID", $res)) {
$mailsubject = "Invalid PayPal IPN Transaction on your site";
$mailbody = "Hello,\n\n";
$mailbody .= "An Invalid PayPal Transaction requires your attention.\n";
$mailbody .= "-----------------------------------------------------------\n";
$mailbody .= "REMOTE IP ADDRESS: " . $_SERVER['REMOTE_ADDR'] . "\n";
$mailbody .= "REMOTE HOST NAME: {$remote_hostname}\n";
$mailbody .= "Order ID: " . $d['order_id'] . "\n";
$mailbody .= "User ID: " . $db->f("user_id") . "\n";
$mailbody .= $error_description;
vmMail($mosConfig_mailfrom, $mosConfig_fromname, $debug_email_address, $mailsubject, $mailbody);
} else {
$mailsubject = "PayPal IPN Transaction on your Site";
$mailbody = "Hello,\r\n An error occured while processing a paypal transaction.\r\n ----------------------------------\r\n {$error_description}";
vmMail($mosConfig_mailfrom, $mosConfig_fromname, $debug_email_address, $mailsubject, $mailbody);
}
}
}
/**
* notifies the customer that the Order Status has been changed
*
* @param array $d
*/
function notify_customer(&$d)
{
global $sess, $VM_LANG, $vmLogger;
$url = SECUREURL . "index.php?option=com_virtuemart&page=account.order_details&order_id=" . urlencode($d["order_id"]) . '&Itemid=' . $sess->getShopItemid();
$db = new ps_DB();
$dbv = new ps_DB();
$q = "SELECT vendor_name,contact_email FROM #__{vm}_vendor ";
$q .= "WHERE vendor_id='" . $_SESSION['ps_vendor_id'] . "'";
$dbv->query($q);
$dbv->next_record();
$q = "SELECT first_name,last_name,user_email,order_status_name FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";
$q .= "WHERE #__{vm}_orders.order_id = '" . $db->getEscaped($d["order_id"]) . "' ";
$q .= "AND #__{vm}_orders.user_id = #__{vm}_order_user_info.user_id ";
$q .= "AND #__{vm}_orders.order_id = #__{vm}_order_user_info.order_id ";
$q .= "AND order_status = order_status_code ";
$db->query($q);
$db->next_record();
// MAIL BODY
$message = $VM_LANG->_('HI', false) . ' ' . $db->f("first_name") . ($db->f("middle_name") ? ' ' . $db->f("middle_name") : '') . ' ' . $db->f("last_name") . ",\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_1', false) . "\n\n";
if (!empty($d['include_comment']) && !empty($d['order_comment'])) {
$message .= $VM_LANG->_('PHPSHOP_ORDER_HISTORY_COMMENT_EMAIL', false) . ":\n";
$message .= $d['order_comment'];
$message .= "\n____________________________________________________________\n\n";
}
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2', false) . "\n";
$message .= "____________________________________________________________\n\n";
$message .= $db->f("order_status_name");
if (VM_REGISTRATION_TYPE != 'NO_REGISTRATION') {
$message .= "\n____________________________________________________________\n\n";
$message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_3', false) . "\n";
$message .= $url;
}
$message .= "\n\n____________________________________________________________\n";
$message .= $dbv->f("vendor_name") . " \n";
$message .= URL . "\n";
$message .= $dbv->f("contact_email");
$message = str_replace("{order_id}", $d["order_id"], $message);
$mail_Body = html_entity_decode($message);
$mail_Subject = str_replace("{order_id}", $d["order_id"], $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_SUBJ', false));
$result = vmMail($dbv->f("contact_email"), $dbv->f("vendor_name"), $db->f("user_email"), $mail_Subject, $mail_Body, '');
/* Send the email */
if ($result) {
$vmLogger->info($VM_LANG->_('PHPSHOP_DOWNLOADS_SEND_MSG', false) . " " . $db->f("first_name") . " " . $db->f("last_name") . ", " . $db->f("user_email"));
} else {
$vmLogger->warning($VM_LANG->_('PHPSHOP_DOWNLOADS_ERR_SEND', false) . ' ' . $db->f("first_name") . " " . $db->f("last_name") . ", " . $db->f("user_email") . " (" . $result->ErrorInfo . ")");
}
}
/**
* Sends new/updated user notification emails
*
* @param string $name - The name of the newly created/updated user
* @param string $email - The email address of the newly created/updated user
* @param string $username - The username of the newly created/updated user
* @param string $password - The plain text password of the newly created/updated user
*/
function _sendMail($name, $email, $username, $password)
{
global $database, $VM_LANG;
global $my, $mosConfig_mailfrom, $mosConfig_fromname, $mosConfig_sitename, $mosConfig_live_site;
$query = "SELECT email" . "\n FROM #__users" . "\n WHERE id = {$my->id}";
$database->setQuery($query);
$adminEmail = $database->loadResult();
$subject = $VM_LANG->_('NEW_USER_MESSAGE_SUBJECT', false);
$message = sprintf($VM_LANG->_('NEW_USER_MESSAGE', false), $name, $mosConfig_sitename, $mosConfig_live_site, $username, $password);
if ($mosConfig_mailfrom != "" && $mosConfig_fromname != "") {
$adminName = $mosConfig_fromname;
$adminEmail = $mosConfig_mailfrom;
} else {
$query = "SELECT name, email" . "\n FROM #__users" . "\n WHERE gid = 25";
$database->setQuery($query);
$admins = $database->loadObjectList();
$admin = $admins[0];
$adminName = $admin->name;
$adminEmail = $admin->email;
}
vmMail($adminEmail, $adminName, $email, $subject, $message);
}