function toC_Sms_Template_new_order_created()
{
parent::toC_Sms_Template($this->_template_name);
}
function outstocksmsAlert($products_name, $stock)
{
require_once 'includes/classes/sms_template.php';
$sms_template = toC_Sms_Template::getSmsTemplate('out_of_stock_alerts');
$sms_template->setData($products_name, $stock);
$sms_template->buildMessage();
$sms_template->sendSms();
}
function sendSms($id)
{
require_once 'sms_template.php';
if (SEND_SMS_NEW_OREDER_TO_USER == '1') {
$sms_template = toC_Sms_Template::getSmsTemplate('new_order_created');
$sms_template->setData($id);
$sms_template->buildMessage();
$sms_template->sendSms();
}
if (SEND_SMS_NEW_OREDER_TO_ADMIN == '1' and SMS_ADMIN_MOBILE_NUMBER != '') {
$sms_template = toC_Sms_Template::getSmsTemplate('new_order_created_admin');
$sms_template->setData($id);
$sms_template->addRecipient(SMS_ADMIN_MOBILE_NUMBER);
$sms_template->buildMessage();
$sms_template->sendSms();
}
}
function toC_Sms_Template_admin_order_status_updated()
{
parent::toC_Sms_Template($this->_template_name);
}
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, sms_customer_notified, comments) values (:orders_id, :orders_status_id, now(), :customer_notified, :sms_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->bindInt(':sms_customer_notified', $data['sms_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();
}
//start sms by persian support Group
if ($data['sms_notify_customer'] === true and SEND_SMS_ORDER_STATUS_UPDATED == '1') {
$Qorder = $osC_Database->query('select o.billing_telephone, s.orders_status_name 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/sms_template.php';
$sms_template = toC_Sms_Template::getSmsTemplate('admin_order_status_updated');
$sms_template->setData($id, $Qorder->value('orders_status_name'), $Qorder->value('billing_telephone'));
$sms_template->buildMessage();
$sms_template->sendSms();
}
// end sms by persian support Group
} else {
$error = true;
}
if ($error === false) {
$osC_Database->commitTransaction();
return true;
}
$osC_Database->rollbackTransaction();
return false;
}
function toC_Sms_Template_out_of_stock_alerts()
{
parent::toC_Sms_Template($this->_template_name);
}
