public function __construct()
{
$this->_template_name = 'admin_order_status_updated';
$this->_keywords = array('%%order_number%%', '%%invoice_link%%', '%%date_ordered%%', '%%order_comment%%', '%%new_order_status%%', '%%customer_name%%', '%%store_name%%', '%%store_owner_email_address%%');
parent::__construct($this->_template_name);
}
public function update_status($id, $data)
{
$ci =& get_instance();
$error = FALSE;
$this->db->trans_begin();
$orders_status = $this->orders_status->get_data($data['status_id']);
if (isset($orders_status['downloads_flag']) && $orders_status['downloads_flag'] == 1) {
// $this->order->active_downloadables($id);
}
if (isset($orders_status['gift_certificates_flag']) && $orders_status['gift_certificates_flag'] == 1) {
// $this->order->active_gift_certificates($id);
}
if ($data['status_id'] == ORDERS_STATUS_CANCELLED && $data['restock_products'] == true) {
$Qproducts = $this->db->select('orders_products_id, products_id, products_type, products_quantity')->from('orders_products')->where('orders_id', $id)->get();
if ($Qproducts->num_rows() > 0) {
foreach ($Qproducts->result_array() as $product) {
$result = $this->product->restock($id, $product['orders_products_id'], $product['products_id'], $product['products_quantity']);
if ($result == FALSE) {
$error = TRUE;
break;
}
}
}
}
if ($error === FALSE) {
$this->db->update('orders', array('orders_status' => $data['status_id'], 'last_modified' => date('Y-m-d h:i:s')), array('orders_id' => $id));
if ($this->db->trans_status() === FALSE) {
$error = TRUE;
}
}
if ($error === FALSE) {
$this->db->insert('orders_status_history', array('orders_id' => $id, 'orders_status_id' => $data['status_id'], 'date_added' => date('Y-m-d h:i:s'), 'customer_notified' => $data['notify_customer'] === true ? '1' : '0', 'comments' => $data['comment']));
if ($this->db->trans_status() === FALSE) {
$error = TRUE;
}
}
if ($error === FALSE && $data['notify_customer'] === TRUE) {
$Qorder = $this->db->select('o.customers_name, o.customers_email_address, s.orders_status_name, o.date_purchased')->from('orders o')->join('orders_status s', 'o.orders_status = s.orders_status_id')->where(array('s.language_id' => lang_id(), 'o.orders_id' => $id))->get();
$order = $Qorder->row_array();
Email_Templates::get_email_template('admin_order_status_updated');
if (is_object($ci->admin_order_status_updated)) {
$ci->admin_order_status_updated->set_data($id, 'www.tomatocart.com', mdate('%Y/%m/%d', human_to_unix($order['date_purchased'])), $data['append_comment'], $data['comment'], $order['orders_status_name'], $order['customers_name'], $order['customers_email_address']);
$ci->admin_order_status_updated->build_message();
$ci->admin_order_status_updated->send_email();
}
}
if ($error === FALSE) {
$this->db->trans_commit();
return TRUE;
}
$this->db->trans_rollback();
return FALSE;
}
