function process($order_id, $status_id = '', $comments = '')
{
global $osC_Database;
if (empty($status_id) || is_numeric($status_id) === false) {
$status_id = DEFAULT_ORDERS_STATUS_ID;
}
$Qstatus = $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)');
$Qstatus->bindTable(':table_orders_status_history', TABLE_ORDERS_STATUS_HISTORY);
$Qstatus->bindInt(':orders_id', $order_id);
$Qstatus->bindInt(':orders_status_id', $status_id);
$Qstatus->bindInt(':customer_notified', SEND_EMAILS == '1' ? '1' : '0');
$Qstatus->bindInt(':sms_customer_notified', SEND_SMS_NEW_OREDER_TO_USER == '1' ? '1' : '0');
$Qstatus->bindValue(':comments', $comments);
$Qstatus->execute();
$Qupdate = $osC_Database->query('update :table_orders set orders_status = :orders_status where orders_id = :orders_id');
$Qupdate->bindTable(':table_orders', TABLE_ORDERS);
$Qupdate->bindInt(':orders_status', $status_id);
$Qupdate->bindInt(':orders_id', $order_id);
$Qupdate->execute();
$Qproducts = $osC_Database->query('select orders_products_id, products_id, products_quantity from :table_orders_products where orders_id = :orders_id');
$Qproducts->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS);
$Qproducts->bindInt(':orders_id', $order_id);
$Qproducts->execute();
while ($Qproducts->next()) {
osC_Product::updateStock($order_id, $Qproducts->valueInt('orders_products_id'), $Qproducts->valueInt('products_id'), $Qproducts->valueInt('products_quantity'));
}
$order_status = self::getOrderStatusData($status_id);
if ($order_status['downloads_flag'] == 1) {
self::activeDownloadables($order_id);
}
if ($order_status['gift_certificates_flag'] == 1) {
self::activeGiftCertificates($order_id);
}
osC_Order::sendEmail($order_id);
//start sms by persian support Group
osC_Order::sendSms($order_id);
// end sms by persian support Group
unset($_SESSION['prepOrderID']);
}
