function _process() { global $osC_Language, $messageStack, $osC_Product; if (empty($_POST['from_name'])) { $messageStack->add('tell_a_friend', $osC_Language->get('error_tell_a_friend_customers_name_empty')); } if (!osc_validate_email_address($_POST['from_email_address'])) { $messageStack->add('tell_a_friend', $osC_Language->get('error_tell_a_friend_invalid_customers_email_address')); } if (empty($_POST['to_name'])) { $messageStack->add('tell_a_friend', $osC_Language->get('error_tell_a_friend_friends_name_empty')); } if (!osc_validate_email_address($_POST['to_email_address'])) { $messageStack->add('tell_a_friend', $osC_Language->get('error_tell_a_friend_invalid_friends_email_address')); } if ($messageStack->size('tell_a_friend') < 1) { include 'includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('tell_a_friend'); $email_template->setData($_POST['from_name'], $_POST['from_email_address'], $_POST['to_name'], $_POST['to_email_address'], $_POST['message'], $osC_Product->getTitle(), osc_href_link(FILENAME_PRODUCTS, $osC_Product->getID(), 'NONSSL', false, true, true)); $email_template->buildMessage(); $email_template->sendEmail(); $messageStack->add_session('header', sprintf($osC_Language->get('success_tell_a_friend_email_sent'), $osC_Product->getTitle(), osc_output_string_protected($_POST['to_name'])), 'success'); osc_redirect(osc_href_link(FILENAME_PRODUCTS, $osC_Product->getID())); } }
function createEntry($data, $restore_cart_contents = true, $send_email = true) { global $osC_Database, $osC_Session, $osC_Language, $osC_ShoppingCart, $osC_Customer, $osC_NavigationHistory, $toC_Wishlist; $Qcustomer = $osC_Database->query('insert into :table_customers (customers_firstname, customers_lastname, customers_email_address, customers_newsletter, customers_status, customers_ip_address, customers_password, customers_gender, customers_dob, number_of_logons, date_account_created) values (:customers_firstname, :customers_lastname, :customers_email_address, :customers_newsletter, :customers_status, :customers_ip_address, :customers_password, :customers_gender, :customers_dob, :number_of_logons, :date_account_created)'); $Qcustomer->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcustomer->bindValue(':customers_firstname', $data['firstname']); $Qcustomer->bindValue(':customers_lastname', $data['lastname']); $Qcustomer->bindValue(':customers_email_address', $data['email_address']); $Qcustomer->bindValue(':customers_newsletter', isset($data['newsletter']) && $data['newsletter'] == '1' ? '1' : ''); $Qcustomer->bindValue(':customers_status', '1'); $Qcustomer->bindValue(':customers_ip_address', osc_get_ip_address()); $Qcustomer->bindValue(':customers_password', osc_encrypt_string($data['password'])); $Qcustomer->bindValue(':customers_gender', ACCOUNT_GENDER > -1 && isset($data['gender']) && ($data['gender'] == 'm' || $data['gender'] == 'f') ? $data['gender'] : ''); $Qcustomer->bindValue(':customers_dob', ACCOUNT_DATE_OF_BIRTH == '1' ? date('Ymd', $data['dob']) : ''); $Qcustomer->bindInt(':number_of_logons', 0); $Qcustomer->bindRaw(':date_account_created', 'now()'); $Qcustomer->execute(); if ($Qcustomer->affectedRows() === 1) { $customer_id = $osC_Database->nextID(); $QcustomerGroup = $osC_Database->query('select customers_groups_id from :table_customers_groups where is_default = 1'); $QcustomerGroup->bindTable(':table_customers_groups', TABLE_CUSTOMERS_GROUPS); $QcustomerGroup->execute(); if ($QcustomerGroup->numberOfRows() == 1) { $osC_Database->simpleQuery('update ' . TABLE_CUSTOMERS . ' set customers_groups_id = ' . $QcustomerGroup->valueInt('customers_groups_id') . ' where customers_id = ' . $customer_id); } if (SERVICE_SESSION_REGENERATE_ID == '1') { $osC_Session->recreate(); } $osC_Customer->setCustomerData($customer_id); //restore cart contents if ($restore_cart_contents === true) { $osC_ShoppingCart->synchronizeWithDatabase(); } //restore wishlist contents $toC_Wishlist->synchronizeWithDatabase(); $osC_NavigationHistory->removeCurrentPage(); include 'email_template.php'; $email = toC_Email_Template::getEmailTemplate('create_account_email'); $email->setData($osC_Customer, $data['password']); $email->buildMessage(); $email->sendEmail(); return true; } return false; }
function setStatus($id, $flag) { global $osC_Database; $Qstatus = $osC_Database->query('update :table_orders_products_download set status = :status where orders_products_download_id = :orders_products_download_id'); $Qstatus->bindTable(':table_orders_products_download', TABLE_ORDERS_PRODUCTS_DOWNLOAD); $Qstatus->bindInt(':status', $flag); $Qstatus->bindInt(':orders_products_download_id', $id); $Qstatus->setLogging($_SESSION['module'], $id); $Qstatus->execute(); if (!$osC_Database->isError()) { if ($flag == '1') { require_once '../includes/classes/email_template.php'; $email = toC_Email_Template::getEmailTemplate('active_downloadable_product'); $data = self::getData($id); $email->setData($data['customers_name'], $data['customers_email_address'], $data['products_name']); $email->buildMessage(); $email->sendEmail(); } return true; } return false; }
function _process() { global $messageStack, $osC_Database, $osC_Language; $Qcheck = $osC_Database->query('select customers_id, customers_firstname, customers_lastname, customers_gender, customers_email_address, customers_password from :table_customers where customers_email_address = :customers_email_address limit 1'); $Qcheck->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcheck->bindValue(':customers_email_address', $_POST['email_address']); $Qcheck->execute(); if ($Qcheck->numberOfRows() === 1) { $password = osc_create_random_string(ACCOUNT_PASSWORD); if (osC_Account::savePassword($password, $Qcheck->valueInt('customers_id'))) { include 'includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('password_forgotten'); $email_template->setData($Qcheck->valueProtected('customers_firstname'), $Qcheck->valueProtected('customers_lastname'), getenv('REMOTE_ADDR'), $password, $Qcheck->valueProtected('customers_gender'), $Qcheck->valueProtected('customers_email_address')); $email_template->buildMessage(); $email_template->sendEmail(); $messageStack->add_session('login', $osC_Language->get('success_password_forgotten_sent'), 'success'); } osc_redirect(osc_href_link(FILENAME_ACCOUNT, 'login', 'SSL')); } else { $messageStack->add('password_forgotten', $osC_Language->get('error_password_forgotten_no_email_address_found')); } }
function sendEmail($customers_id, $addtional_message) { global $osC_Database, $osC_Language; $contents = self::getCartContents($customers_id); $Qcustomer = $osC_Database->query('select * from :table_customers where customers_id = :customers_id'); $Qcustomer->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcustomer->bindInt(':customers_id', $customers_id); $Qcustomer->execute(); include_once '../includes/classes/email_template.php'; $email = toC_Email_Template::getEmailTemplate('abandoned_cart_inquiry'); $email->setData($Qcustomer->value('customers_gender'), $Qcustomer->value('customers_firstname'), $Qcustomer->value('customers_lastname'), $contents, $addtional_message, $Qcustomer->value('customers_email_address')); $email->buildMessage(); $email->sendEmail(); $Qcustomer = $osC_Database->query('update :table_customers set abandoned_cart_last_contact_date = :abandoned_cart_last_contact_date where customers_id = :customers_id'); $Qcustomer->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcustomer->bindRaw(':abandoned_cart_last_contact_date', 'now()'); $Qcustomer->bindInt(':customers_id', $customers_id); $Qcustomer->setLogging($_SESSION['module'], $customers_id); $Qcustomer->execute(); if ($osC_Database->isError()) { return false; } return true; }
function setStatus($id, $flag) { global $osC_Database; $Qstatus = $osC_Database->query('update :table_gift_certificates set status = :gift_certificates_status where gift_certificates_id = :gift_certificates_id'); $Qstatus->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES); $Qstatus->bindInt(':gift_certificates_status', $flag); $Qstatus->bindInt(':gift_certificates_id', $id); $Qstatus->setLogging($_SESSION['module'], $id); $Qstatus->execute(); if (!$osC_Database->isError()) { $data = self::getData($id); if ($flag == '1' && $data['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { require_once 'includes/classes/currencies.php'; $osC_Currencies = new osC_Currencies_Admin(); require_once '../includes/classes/email_template.php'; $email = toC_Email_Template::getEmailTemplate('active_gift_certificate'); $email->setData($data['senders_name'], $data['senders_email'], $data['recipients_name'], $data['recipients_email'], $osC_Currencies->format($data['amount']), $data['gift_certificates_code'], $data['messages']); $email->buildMessage(); $email->sendEmail(); } return true; } return false; }
function _updateStatus($id, $data) { global $osC_Database, $osC_Language, $orders_status_array; $error = false; $osC_Database->startTransaction(); $orders_status = osC_OrdersStatus_Admin::getData($data['status_id']); if ($orders_status['downloads_flag'] == 1) { osC_Order::activeDownloadables($id); } if ($orders_status['gift_certificates_flag'] == 1) { osC_Order::activeGiftCertificates($id); } if ($data['status_id'] == ORDERS_STATUS_CANCELLED && $data['restock_products'] == true) { $Qproducts = $osC_Database->query('select orders_products_id, products_id, products_type, products_quantity from :table_orders_products where orders_id = :orders_id'); $Qproducts->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qproducts->bindInt(':orders_id', $id); $Qproducts->execute(); while ($Qproducts->next()) { $result = osC_Product::restock($id, $Qproducts->valueInt('orders_products_id'), $Qproducts->valueInt('products_id'), $Qproducts->valueInt('products_quantity')); if ($result == false) { $error = true; break; } } } $Qupdate = $osC_Database->query('update :table_orders set orders_status = :orders_status, last_modified = now() where orders_id = :orders_id'); $Qupdate->bindTable(':table_orders', TABLE_ORDERS); $Qupdate->bindInt(':orders_status', $data['status_id']); $Qupdate->bindInt(':orders_id', $id); $Qupdate->setLogging($_SESSION['module'], $id); $Qupdate->execute(); if (!$osC_Database->isError()) { $Qupdate = $osC_Database->query('insert into :table_orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values (:orders_id, :orders_status_id, now(), :customer_notified, :comments)'); $Qupdate->bindTable(':table_orders_status_history', TABLE_ORDERS_STATUS_HISTORY); $Qupdate->bindInt(':orders_id', $id); $Qupdate->bindInt(':orders_status_id', $data['status_id']); $Qupdate->bindInt(':customer_notified', $data['notify_customer'] === true ? '1' : '0'); $Qupdate->bindValue(':comments', $data['comment']); $Qupdate->setLogging($_SESSION['module'], $id); $Qupdate->execute(); if ($osC_Database->isError()) { $error = true; } if ($data['notify_customer'] === true) { $Qorder = $osC_Database->query('select o.customers_name, o.customers_email_address, s.orders_status_name, o.date_purchased from :table_orders o, :table_orders_status s where o.orders_status = s.orders_status_id and s.language_id = :language_id and o.orders_id = :orders_id'); $Qorder->bindTable(':table_orders', TABLE_ORDERS); $Qorder->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qorder->bindInt(':language_id', $osC_Language->getID()); $Qorder->bindInt(':orders_id', $id); $Qorder->execute(); require_once '../includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('admin_order_status_updated'); $email_template->setData($id, osc_href_link(FILENAME_ACCOUNT, 'orders=' . $id, 'SSL', false, true, true), osC_DateTime::getLong($Qorder->value('date_purchased')), $data['append_comment'], $data['comment'], $Qorder->value('orders_status_name'), $Qorder->value('customers_name'), $Qorder->value('customers_email_address')); $email_template->buildMessage(); $email_template->sendEmail(); } } else { $error = true; } if ($error === false) { $osC_Database->commitTransaction(); return true; } $osC_Database->rollbackTransaction(); return false; }
function outstockAlert($products_name, $stock, $variants_name = '') { require_once 'includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('out_of_stock_alerts'); $email_template->setData($products_name, $stock, $variants_name); $email_template->buildMessage(); $email_template->sendEmail(); }
function sendEmail($id) { require_once 'email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('new_order_created'); $email_template->setData($id); if (SEND_EXTRA_ORDER_EMAILS_TO != '') { $extra_emials = explode(',', SEND_EXTRA_ORDER_EMAILS_TO); if (is_array($extra_emials) && !osc_empty($extra_emials)) { foreach ($extra_emials as $email) { $email_template->addRecipient('', trim($email)); } } } $email_template->buildMessage(); $email_template->sendEmail(); }
function activeGiftCertificates($orders_id) { global $osC_Database; require_once 'includes/classes/currencies.php'; $osC_Currencies = new osC_Currencies_Admin(); //create email template object require_once '../includes/classes/email_template.php'; $email = toC_Email_Template::getEmailTemplate('active_gift_certificate'); //retrieve gift certifcates $Qcertificates = $osC_Database->query('select * from :table_gift_certificates where orders_id = :orders_id'); $Qcertificates->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES); $Qcertificates->bindInt(':orders_id', $orders_id); $Qcertificates->execute(); while ($Qcertificates->next()) { if ($Qcertificates->valueInt('status') == 0) { //update gift certificate status $Qupdate = $osC_Database->query('update :table_gift_certificates set status = :status where gift_certificates_id = :gift_certificates_id'); $Qupdate->bindTable(':table_gift_certificates', TABLE_GIFT_CERTIFICATES); $Qupdate->bindInt(':status', 1); $Qupdate->bindInt(':gift_certificates_id', $Qcertificates->valueInt('gift_certificates_id')); $Qupdate->setLogging($_SESSION['module'], $orders_id); $Qupdate->execute(); //send notification email if ($Qcertificates->valueInt('type') == GIFT_CERTIFICATE_TYPE_EMAIL) { $email->resetRecipients(); $email->setData($Qcertificates->value('senders_name'), $Qcertificates->value('senders_email'), $Qcertificates->value('recipients_name'), $Qcertificates->value('recipients_email'), $osC_Currencies->format($Qcertificates->value('amount')), $Qcertificates->value('gift_certificates_code'), $Qcertificates->value('messages')); $email->buildMessage(); $email->sendEmail(); } } } }
function _share_wishlist() { global $osC_Language, $messageStack, $toC_Wishlist; $data = array(); if (isset($_POST['wishlist_customer']) && !empty($_POST['wishlist_customer'])) { $data['wishlist_customer'] = $_POST['wishlist_customer']; } else { $messageStack->add($this->_module, $osC_Language->get('field_share_wishlist_customer_name_error')); } if (isset($_POST['wishlist_from_email']) && !empty($_POST['wishlist_from_email'])) { $data['wishlist_from_email'] = $_POST['wishlist_from_email']; } else { $messageStack->add($this->_module, $osC_Language->get('field_share_wishlist_customer_email_error')); } if (isset($_POST['wishlist_emails']) && !empty($_POST['wishlist_emails'])) { $data['wishlist_emails'] = $_POST['wishlist_emails']; } else { $messageStack->add($this->_module, $osC_Language->get('field_share_wishlist_emails_error')); } if (isset($_POST['wishlist_message']) && !empty($_POST['wishlist_message'])) { $data['wishlist_message'] = $_POST['wishlist_message']; } else { $messageStack->add($this->_module, $osC_Language->get('field_share_wishlist_message_error')); } if ($messageStack->size($this->_module) === 0) { include 'includes/classes/email_template.php'; $wishlist_url = osc_href_link(FILENAME_ACCOUNT, 'wishlist=display_wishlist&token=' . $toC_Wishlist->getToken(), 'NONSSL', true, true, true); $email = toC_Email_Template::getEmailTemplate('share_wishlist'); $email->setData($data['wishlist_customer'], $data['wishlist_from_email'], $data['wishlist_emails'], $data['wishlist_message'], $wishlist_url); $email->buildMessage(); $email->sendEmail(); osc_redirect(osc_href_link(FILENAME_ACCOUNT, 'wishlist', 'SSL')); } }
function saveBlance($data) { global $osC_Database, $osC_Language; $error = false; $osC_Database->startTransaction(); $Qcredits = $osC_Database->query('insert into :table_customers_credits_history (customers_id, date_added, action_type, amount, comments) values(:customers_id, now(), :action_type, :amount, :comments)'); $Qcredits->bindTable(':table_customers_credits_history', TABLE_CUSTOMERS_CREDITS_HISTORY); $Qcredits->bindInt(':customers_id', $data['customers_id']); $Qcredits->bindInt(':action_type', STORE_CREDIT_ACTION_TYPE_ADMIN); $Qcredits->bindRaw(':amount', $data['amount']); $Qcredits->bindValue(':comments', $data['comments']); $Qcredits->setLogging($_SESSION['module'], $data['customers_id']); $Qcredits->execute(); if ($osC_Database->isError()) { $error = true; } if ($error === false) { $Qcustomer = $osC_Database->query('update :table_customers set customers_credits = (customers_credits + :customers_credits) where customers_id = :customers_id'); $Qcustomer->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcustomer->bindRaw(':customers_credits', $data['amount']); $Qcustomer->bindInt(':customers_id', $data['customers_id']); $Qcustomer->setLogging($_SESSION['module'], $data['customers_id']); $Qcustomer->execute(); if (!$osC_Database->isError()) { $osC_Database->commitTransaction(); if ($data['notify'] == 1) { include '../includes/classes/email_template.php'; $data = osC_Customers_Admin::getData($data['customers_id']); $emailTemplate = toC_Email_Template::getEmailTemplate('admin_customer_credits_change_notification'); $emailTemplate->setData($data['customers_firstname'], $data['customers_lastname'], $data['customers_email_address'], $data['customers_gender'], $data['customers_credits']); $emailTemplate->buildMessage(); $emailTemplate->sendEmail(); } return true; } } $osC_Database->rollbackTransaction(); return false; }
function sendEmail($id) { require_once 'email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('new_order_created'); $email_template->setData($id); if (SEND_EXTRA_ORDER_EMAILS_TO != '') { $email_template->addRecipient('', SEND_EXTRA_ORDER_EMAILS_TO); } $email_template->buildMessage(); $email_template->sendEmail(); }
function createStoreCredit($data) { global $osC_Database, $osC_Language; $error = false; $osC_Database->startTransaction(); //order refund $Qinsert = $osC_Database->query('insert into :table_orders_refunds (orders_refunds_type, orders_id, credit_slips_id, sub_total, shipping, handling, refund_total, comments, date_added) values (:orders_refunds_type, :orders_id, :credit_slips_id, :sub_total, :shipping, :handling, :refund_total, :comments, now())'); $Qinsert->bindTable(':table_orders_refunds', TABLE_ORDERS_REFUNDS); $Qinsert->bindInt(':orders_refunds_type', ORDERS_RETURNS_TYPE_STORE_CREDIT); $Qinsert->bindInt(':orders_id', $data['orders_id']); $Qinsert->bindRaw(':credit_slips_id', 'null'); $Qinsert->bindValue(':sub_total', $data['sub_total']); $Qinsert->bindValue(':shipping', $data['shipping_fee']); $Qinsert->bindValue(':handling', $data['handling']); $Qinsert->bindValue(':refund_total', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qinsert->bindValue(':comments', $data['comments']); $Qinsert->setLogging($_SESSION['module'], null); $Qinsert->execute(); if ($osC_Database->isError()) { $error = true; } else { $orders_refunds_id = $osC_Database->nextID(); //orders refunds products $return_products = explode(';', $data['return_quantity']); foreach ($return_products as $product) { list($orders_products_id, $quantity) = explode(':', $product); $Qproduct = $osC_Database->query('insert into :table_orders_refunds_products (orders_refunds_id, orders_products_id, products_quantity) values (:orders_refunds_id, :orders_products_id, :products_quantity)'); $Qproduct->bindTable(':table_orders_refunds_products', TABLE_ORDERS_REFUNDS_PRODUCTS); $Qproduct->bindInt(':orders_refunds_id', $orders_refunds_id); $Qproduct->bindInt(':orders_products_id', $orders_products_id); $Qproduct->bindInt(':products_quantity', $quantity); $Qproduct->setLogging($_SESSION['module'], $orders_refunds_id); $Qproduct->execute(); if ($osC_Database->isError()) { $error = true; break; } if ($error === false) { $Qupdate = $osC_Database->query('update :table_orders_products set products_return_quantity = products_return_quantity + :products_return_quantity where orders_products_id = :orders_products_id'); $Qupdate->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qupdate->bindInt(':products_return_quantity', $quantity); $Qupdate->bindInt(':orders_products_id', $orders_products_id); $Qupdate->setLogging($_SESSION['module'], $orders_refunds_id); $Qupdate->execute(); if ($osC_Database->isError()) { $error = true; break; } } if ($error === false && $data['restock_quantity'] === true) { $Qcheck = $osC_Database->query('select products_id from :table_orders_products where orders_products_id = :orders_products_id and orders_id = :orders_id'); $Qcheck->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS); $Qcheck->bindInt(':orders_products_id', $orders_products_id); $Qcheck->bindInt(':orders_id', $data['orders_id']); $Qcheck->setLogging($_SESSION['module'], $orders_refunds_id); $Qcheck->execute(); $products_id = $Qcheck->valueInt('products_id'); if (!osC_Product::restock($data['orders_id'], $orders_products_id, $products_id, $quantity)) { $error = true; break; } } } } if ($error === false) { $Qreturn = $osC_Database->query('update :table_orders_returns set orders_returns_status_id = :orders_returns_status_id, admin_comments = :admin_comments, date_updated = now() where orders_returns_id = :id'); $Qreturn->bindTable(':table_orders_returns', TABLE_ORDERS_RETURNS); $Qreturn->bindInt(':orders_returns_status_id', ORDERS_RETURNS_STATUS_REFUNDED_STORE_CREDIT); $Qreturn->bindValue(':admin_comments', $data['comment']); $Qreturn->bindInt(':id', $data['orders_returns_id']); $Qreturn->setLogging($_SESSION['module'], $data['orders_returns_id']); $Qreturn->execute(); if ($osC_Database->isError()) { $error = true; } } if ($error === false) { $Qcustomer = $osC_Database->query('select customers_id from :table_orders where orders_id = :orders_id'); $Qcustomer->bindTable(':table_orders', TABLE_ORDERS); $Qcustomer->bindInt(':orders_id', $data['orders_id']); $Qcustomer->execute(); $customers_id = $Qcustomer->valueInt('customers_id'); $Qhistory = $osC_Database->query('insert into :table_customers_credits_history (customers_id, action_type, date_added, amount, comments) values (:customers_id, :action_type, now(), :amount, :comments)'); $Qhistory->bindTable(':table_customers_credits_history', TABLE_CUSTOMERS_CREDITS_HISTORY); $Qhistory->bindInt(':customers_id', $customers_id); $Qhistory->bindInt(':action_type', STORE_CREDIT_ACTION_TYPE_ORDER_REFUNDED); $Qhistory->bindValue(':amount', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qhistory->bindValue(':comments', sprintf($osC_Language->get('infomation_store_credit_from_order'), $data['orders_id'])); $Qhistory->execute(); if ($osC_Database->isError()) { $error = true; } if ($error === false) { $Qupdate = $osC_Database->query('update :table_customers set customers_credits = (customers_credits + :customers_credits) where customers_id = :customers_id'); $Qupdate->bindTable(':table_customers', TABLE_CUSTOMERS); $Qupdate->bindRaw(':customers_credits', $data['sub_total'] + $data['shipping_fee'] + $data['handling']); $Qupdate->bindInt(':customers_id', $customers_id); $Qupdate->setLogging($_SESSION['module'], $data['$orders_refunds_id']); $Qupdate->execute(); if ($osC_Database->isError()) { $error = true; } } } if ($error === false) { $osC_Database->commitTransaction(); $osC_Order = new osC_Order($data['orders_id']); $return_products_ids = array(); $return_products_qty = array(); $return_products = explode(';', $data['return_quantity']); foreach ($return_products as $product) { list($orders_products_id, $quantity) = explode(':', $product); $return_products_ids[] = $orders_products_id; $return_products_qty[$orders_products_id] = $quantity; } $products = array(); foreach ($osC_Order->getProducts() as $product) { if (in_array($product['orders_products_id'], $return_products_ids)) { $product_info = $return_products_qty[$product['orders_products_id']] . ' x ' . $product['name']; if ($product['type'] == PRODUCT_TYPE_GIFT_CERTIFICATE) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_name') . ': ' . $product['senders_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('senders_email') . ': ' . $product['senders_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_name') . ': ' . $product['recipients_name'] . '</i></nobr>'; if ($product['gift_certificates_type'] == GIFT_CERTIFICATE_TYPE_EMAIL) { $product_info .= '<br /><nobr> <i>' . $osC_Language->get('recipients_email') . ': ' . $product['recipients_email'] . '</i></nobr>'; } $product_info .= '<br /><nobr> <i>' . $osC_Language->get('messages') . ': ' . $product['messages'] . '</i></nobr>'; } if (isset($product['variants']) && is_array($product['variants']) && sizeof($product['variants']) > 0) { foreach ($product['variants'] as $variants) { $product_info .= '<br /><nobr> <i>' . $variants['groups_name'] . ': ' . $variants['values_name'] . '</i></nobr>'; } } $products[] = $product_info; } } $customers_name = $osC_Order->getCustomer('name'); $customers_email_address = $osC_Order->getCustomer('email_address'); require_once 'includes/classes/currencies.php'; $osC_Currencies = new osC_Currencies_Admin(); include '../includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('admin_create_order_store_credit'); $email_template->setData($customers_name, $customers_email_address, implode('<br />', $products), $data['orders_id'], $osC_Currencies->format($data['sub_total'] + $data['shipping_fee'] + $data['handling'])); $email_template->buildMessage(); $email_template->sendEmail(); return true; } $osC_Database->rollbackTransaction(); return false; }
function sendEmail() { global $toC_Json, $osC_Database, $osC_Language; $coupons_id = isset($_REQUEST['coupons_id']) && is_numeric($_REQUEST['coupons_id']) ? $_REQUEST['coupons_id'] : null; $customers_id = $_REQUEST['customers_id']; $message = $_REQUEST['message']; $Qcustomer = $osC_Database->query('select customers_email_address, customers_id, customers_firstname, customers_lastname, customers_gender from :table_customers where customers_id = :customers_id'); $Qcustomer->bindTable(':table_customers', TABLE_CUSTOMERS); $Qcustomer->bindInt(':customers_id', $customers_id); $Qcustomer->execute(); $Qcoupons = $osC_Database->query('select * from :table_coupons c, :table_coupons_description cd where c.coupons_id=cd.coupons_id and cd.language_id=:language_id and c.coupons_id = :coupons_id'); $Qcoupons->bindTable(':table_coupons', TABLE_COUPONS); $Qcoupons->bindTable(':table_coupons_description', TABLE_COUPONS_DESCRIPTION); $Qcoupons->bindInt(':language_id', $osC_Language->getID()); $Qcoupons->bindInt(':coupons_id', $coupons_id); $Qcoupons->execute(); if (!$osC_Database->isError) { $email = $Qcustomer->value('customers_email_address'); $customers_firstname = $Qcustomer->value('customers_firstname'); $customers_lastname = $Qcustomer->value('customers_lastname'); include '../includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('send_coupon'); $email_template->setData($Qcustomer->value('customers_gender'), $customers_firstname, $customers_lastname, $Qcoupons->value('coupons_code'), $message, $email); $email_template->buildMessage(); $email_template->sendEmail(); $response = array('success' => true, 'feedback' => $osC_Language->get('ms_success_action_performed')); } else { $response = array('success' => false, 'feedback' => $osC_Language->get('ms_error_action_not_performed')); } echo $toC_Json->encode($response); }
function generatePassword($email) { global $osC_Database; $password = osc_create_random_string(8); $Qpassword = $osC_Database->query('update :table_administrators set user_password = :user_password where email_address = :email_address'); $Qpassword->bindTable(':table_administrators', TABLE_ADMINISTRATORS); $Qpassword->bindValue(':user_password', osc_encrypt_string($password)); $Qpassword->bindValue(':email_address', $email); $Qpassword->execute(); if (!$osC_Database->isError()) { $Qadmin = $osC_Database->query('select id, user_name, email_address from :table_administrators where email_address = :email_address'); $Qadmin->bindTable(':table_administrators', TABLE_ADMINISTRATORS); $Qadmin->bindValue(':email_address', $email); $Qadmin->execute(); include '../includes/classes/email_template.php'; $email_template = toC_Email_Template::getEmailTemplate('admin_password_forgotten'); $email_template->setData($Qadmin->value('user_name'), osc_get_ip_address(), $password, $email); $email_template->buildMessage(); $email_template->sendEmail(); return true; } return false; }