API tools faq
paste
Guest User

Untitled

a guest
Feb 27th, 2018
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.63 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. class ModelCheckoutOrder extends Model {
  3. public function addOrder($data) {
  4. $this->db->query("INSERT INTO `" . DB_PREFIX . "order` SET invoice_prefix = '" . $this->db->escape($data['invoice_prefix']) . "', store_id = '" . (int)$data['store_id'] . "', store_name = '" . $this->db->escape($data['store_name']) . "', store_url = '" . $this->db->escape($data['store_url']) . "', customer_id = '" . (int)$data['customer_id'] . "', customer_group_id = '" . (int)$data['customer_group_id'] . "', firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', custom_field = '" . $this->db->escape(isset($data['custom_field']) ? json_encode($data['custom_field']) : '') . "', payment_firstname = '" . $this->db->escape($data['payment_firstname']) . "', payment_lastname = '" . $this->db->escape($data['payment_lastname']) . "', payment_company = '" . $this->db->escape($data['payment_company']) . "', payment_address_1 = '" . $this->db->escape($data['payment_address_1']) . "', payment_address_2 = '" . $this->db->escape($data['payment_address_2']) . "', payment_city = '" . $this->db->escape($data['payment_city']) . "', payment_postcode = '" . $this->db->escape($data['payment_postcode']) . "', payment_country = '" . $this->db->escape($data['payment_country']) . "', payment_country_id = '" . (int)$data['payment_country_id'] . "', payment_zone = '" . $this->db->escape($data['payment_zone']) . "', payment_zone_id = '" . (int)$data['payment_zone_id'] . "', payment_address_format = '" . $this->db->escape($data['payment_address_format']) . "', payment_custom_field = '" . $this->db->escape(isset($data['payment_custom_field']) ? json_encode($data['payment_custom_field']) : '') . "', payment_method = '" . $this->db->escape($data['payment_method']) . "', payment_code = '" . $this->db->escape($data['payment_code']) . "', shipping_firstname = '" . $this->db->escape($data['shipping_firstname']) . "', shipping_lastname = '" . $this->db->escape($data['shipping_lastname']) . "', shipping_company = '" . $this->db->escape($data['shipping_company']) . "', shipping_address_1 = '" . $this->db->escape($data['shipping_address_1']) . "', shipping_address_2 = '" . $this->db->escape($data['shipping_address_2']) . "', shipping_city = '" . $this->db->escape($data['shipping_city']) . "', shipping_postcode = '" . $this->db->escape($data['shipping_postcode']) . "', shipping_country = '" . $this->db->escape($data['shipping_country']) . "', shipping_country_id = '" . (int)$data['shipping_country_id'] . "', shipping_zone = '" . $this->db->escape($data['shipping_zone']) . "', shipping_zone_id = '" . (int)$data['shipping_zone_id'] . "', shipping_address_format = '" . $this->db->escape($data['shipping_address_format']) . "', shipping_custom_field = '" . $this->db->escape(isset($data['shipping_custom_field']) ? json_encode($data['shipping_custom_field']) : '') . "', shipping_method = '" . $this->db->escape($data['shipping_method']) . "', shipping_code = '" . $this->db->escape($data['shipping_code']) . "', comment = '" . $this->db->escape($data['comment']) . "', total = '" . (float)$data['total'] . "', affiliate_id = '" . (int)$data['affiliate_id'] . "', commission = '" . (float)$data['commission'] . "', marketing_id = '" . (int)$data['marketing_id'] . "', tracking = '" . $this->db->escape($data['tracking']) . "', language_id = '" . (int)$data['language_id'] . "', currency_id = '" . (int)$data['currency_id'] . "', currency_code = '" . $this->db->escape($data['currency_code']) . "', currency_value = '" . (float)$data['currency_value'] . "', ip = '" . $this->db->escape($data['ip']) . "', forwarded_ip = '" . $this->db->escape($data['forwarded_ip']) . "', user_agent = '" . $this->db->escape($data['user_agent']) . "', accept_language = '" . $this->db->escape($data['accept_language']) . "', date_added = NOW(), date_modified = NOW()");
  5.  
  6. $order_id = $this->db->getLastId();
  7.  
  8. // Products
  9. if (isset($data['products'])) {
  10. foreach ($data['products'] as $product) {
  11. $this->db->query("INSERT INTO " . DB_PREFIX . "order_product SET order_id = '" . (int)$order_id . "', product_id = '" . (int)$product['product_id'] . "', name = '" . $this->db->escape($product['name']) . "', model = '" . $this->db->escape($product['model']) . "', quantity = '" . (int)$product['quantity'] . "', price = '" . (float)$product['price'] . "', total = '" . (float)$product['total'] . "', tax = '" . (float)$product['tax'] . "', reward = '" . (int)$product['reward'] . "'");
  12.  
  13. $order_product_id = $this->db->getLastId();
  14.  
  15. foreach ($product['option'] as $option) {
  16. $this->db->query("INSERT INTO " . DB_PREFIX . "order_option SET order_id = '" . (int)$order_id . "', order_product_id = '" . (int)$order_product_id . "', product_option_id = '" . (int)$option['product_option_id'] . "', product_option_value_id = '" . (int)$option['product_option_value_id'] . "', name = '" . $this->db->escape($option['name']) . "', `value` = '" . $this->db->escape($option['value']) . "', `type` = '" . $this->db->escape($option['type']) . "'");
  17. }
  18. }
  19. }
  20.  
  21. // Gift Voucher
  22. $this->load->model('extension/total/voucher');
  23.  
  24. // Vouchers
  25. if (isset($data['vouchers'])) {
  26. foreach ($data['vouchers'] as $voucher) {
  27. $this->db->query("INSERT INTO " . DB_PREFIX . "order_voucher SET order_id = '" . (int)$order_id . "', description = '" . $this->db->escape($voucher['description']) . "', code = '" . $this->db->escape($voucher['code']) . "', from_name = '" . $this->db->escape($voucher['from_name']) . "', from_email = '" . $this->db->escape($voucher['from_email']) . "', to_name = '" . $this->db->escape($voucher['to_name']) . "', to_email = '" . $this->db->escape($voucher['to_email']) . "', voucher_theme_id = '" . (int)$voucher['voucher_theme_id'] . "', message = '" . $this->db->escape($voucher['message']) . "', amount = '" . (float)$voucher['amount'] . "'");
  28.  
  29. $order_voucher_id = $this->db->getLastId();
  30.  
  31. $voucher_id = $this->model_extension_total_voucher->addVoucher($order_id, $voucher);
  32.  
  33. $this->db->query("UPDATE " . DB_PREFIX . "order_voucher SET voucher_id = '" . (int)$voucher_id . "' WHERE order_voucher_id = '" . (int)$order_voucher_id . "'");
  34. }
  35. }
  36.  
  37. // Totals
  38. if (isset($data['totals'])) {
  39. foreach ($data['totals'] as $total) {
  40. $this->db->query("INSERT INTO " . DB_PREFIX . "order_total SET order_id = '" . (int)$order_id . "', code = '" . $this->db->escape($total['code']) . "', title = '" . $this->db->escape($total['title']) . "', `value` = '" . (float)$total['value'] . "', sort_order = '" . (int)$total['sort_order'] . "'");
  41. }
  42. }
  43.  
  44. return $order_id;
  45. }
  46.  
  47. public function editOrder($order_id, $data) {
  48. // Void the order first
  49. $this->addOrderHistory($order_id, 0);
  50.  
  51. $this->db->query("UPDATE `" . DB_PREFIX . "order` SET invoice_prefix = '" . $this->db->escape($data['invoice_prefix']) . "', store_id = '" . (int)$data['store_id'] . "', store_name = '" . $this->db->escape($data['store_name']) . "', store_url = '" . $this->db->escape($data['store_url']) . "', customer_id = '" . (int)$data['customer_id'] . "', customer_group_id = '" . (int)$data['customer_group_id'] . "', firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', custom_field = '" . $this->db->escape(json_encode($data['custom_field'])) . "', payment_firstname = '" . $this->db->escape($data['payment_firstname']) . "', payment_lastname = '" . $this->db->escape($data['payment_lastname']) . "', payment_company = '" . $this->db->escape($data['payment_company']) . "', payment_address_1 = '" . $this->db->escape($data['payment_address_1']) . "', payment_address_2 = '" . $this->db->escape($data['payment_address_2']) . "', payment_city = '" . $this->db->escape($data['payment_city']) . "', payment_postcode = '" . $this->db->escape($data['payment_postcode']) . "', payment_country = '" . $this->db->escape($data['payment_country']) . "', payment_country_id = '" . (int)$data['payment_country_id'] . "', payment_zone = '" . $this->db->escape($data['payment_zone']) . "', payment_zone_id = '" . (int)$data['payment_zone_id'] . "', payment_address_format = '" . $this->db->escape($data['payment_address_format']) . "', payment_custom_field = '" . $this->db->escape(json_encode($data['payment_custom_field'])) . "', payment_method = '" . $this->db->escape($data['payment_method']) . "', payment_code = '" . $this->db->escape($data['payment_code']) . "', shipping_firstname = '" . $this->db->escape($data['shipping_firstname']) . "', shipping_lastname = '" . $this->db->escape($data['shipping_lastname']) . "', shipping_company = '" . $this->db->escape($data['shipping_company']) . "', shipping_address_1 = '" . $this->db->escape($data['shipping_address_1']) . "', shipping_address_2 = '" . $this->db->escape($data['shipping_address_2']) . "', shipping_city = '" . $this->db->escape($data['shipping_city']) . "', shipping_postcode = '" . $this->db->escape($data['shipping_postcode']) . "', shipping_country = '" . $this->db->escape($data['shipping_country']) . "', shipping_country_id = '" . (int)$data['shipping_country_id'] . "', shipping_zone = '" . $this->db->escape($data['shipping_zone']) . "', shipping_zone_id = '" . (int)$data['shipping_zone_id'] . "', shipping_address_format = '" . $this->db->escape($data['shipping_address_format']) . "', shipping_custom_field = '" . $this->db->escape(json_encode($data['shipping_custom_field'])) . "', shipping_method = '" . $this->db->escape($data['shipping_method']) . "', shipping_code = '" . $this->db->escape($data['shipping_code']) . "', comment = '" . $this->db->escape($data['comment']) . "', total = '" . (float)$data['total'] . "', affiliate_id = '" . (int)$data['affiliate_id'] . "', commission = '" . (float)$data['commission'] . "', date_modified = NOW() WHERE order_id = '" . (int)$order_id . "'");
  52.  
  53. $this->db->query("DELETE FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
  54. $this->db->query("DELETE FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "'");
  55.  
  56. // Products
  57. if (isset($data['products'])) {
  58. foreach ($data['products'] as $product) {
  59. $this->db->query("INSERT INTO " . DB_PREFIX . "order_product SET order_id = '" . (int)$order_id . "', product_id = '" . (int)$product['product_id'] . "', name = '" . $this->db->escape($product['name']) . "', model = '" . $this->db->escape($product['model']) . "', quantity = '" . (int)$product['quantity'] . "', price = '" . (float)$product['price'] . "', total = '" . (float)$product['total'] . "', tax = '" . (float)$product['tax'] . "', reward = '" . (int)$product['reward'] . "'");
  60.  
  61. $order_product_id = $this->db->getLastId();
  62.  
  63. foreach ($product['option'] as $option) {
  64. $this->db->query("INSERT INTO " . DB_PREFIX . "order_option SET order_id = '" . (int)$order_id . "', order_product_id = '" . (int)$order_product_id . "', product_option_id = '" . (int)$option['product_option_id'] . "', product_option_value_id = '" . (int)$option['product_option_value_id'] . "', name = '" . $this->db->escape($option['name']) . "', `value` = '" . $this->db->escape($option['value']) . "', `type` = '" . $this->db->escape($option['type']) . "'");
  65. }
  66. }
  67. }
  68.  
  69. // Gift Voucher
  70. $this->load->model('extension/total/voucher');
  71.  
  72. $this->model_extension_total_voucher->disableVoucher($order_id);
  73.  
  74. // Vouchers
  75. $this->db->query("DELETE FROM " . DB_PREFIX . "order_voucher WHERE order_id = '" . (int)$order_id . "'");
  76.  
  77. if (isset($data['vouchers'])) {
  78. foreach ($data['vouchers'] as $voucher) {
  79. $this->db->query("INSERT INTO " . DB_PREFIX . "order_voucher SET order_id = '" . (int)$order_id . "', description = '" . $this->db->escape($voucher['description']) . "', code = '" . $this->db->escape($voucher['code']) . "', from_name = '" . $this->db->escape($voucher['from_name']) . "', from_email = '" . $this->db->escape($voucher['from_email']) . "', to_name = '" . $this->db->escape($voucher['to_name']) . "', to_email = '" . $this->db->escape($voucher['to_email']) . "', voucher_theme_id = '" . (int)$voucher['voucher_theme_id'] . "', message = '" . $this->db->escape($voucher['message']) . "', amount = '" . (float)$voucher['amount'] . "'");
  80.  
  81. $order_voucher_id = $this->db->getLastId();
  82.  
  83. $voucher_id = $this->model_extension_total_voucher->addVoucher($order_id, $voucher);
  84.  
  85. $this->db->query("UPDATE " . DB_PREFIX . "order_voucher SET voucher_id = '" . (int)$voucher_id . "' WHERE order_voucher_id = '" . (int)$order_voucher_id . "'");
  86. }
  87. }
  88.  
  89. // Totals
  90. $this->db->query("DELETE FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "'");
  91.  
  92. if (isset($data['totals'])) {
  93. foreach ($data['totals'] as $total) {
  94. $this->db->query("INSERT INTO " . DB_PREFIX . "order_total SET order_id = '" . (int)$order_id . "', code = '" . $this->db->escape($total['code']) . "', title = '" . $this->db->escape($total['title']) . "', `value` = '" . (float)$total['value'] . "', sort_order = '" . (int)$total['sort_order'] . "'");
  95. }
  96. }
  97. }
  98.  
  99. public function deleteOrder($order_id) {
  100. // Void the order first
  101. $this->addOrderHistory($order_id, 0);
  102.  
  103. $this->db->query("DELETE FROM `" . DB_PREFIX . "order` WHERE order_id = '" . (int)$order_id . "'");
  104. $this->db->query("DELETE FROM `" . DB_PREFIX . "order_product` WHERE order_id = '" . (int)$order_id . "'");
  105. $this->db->query("DELETE FROM `" . DB_PREFIX . "order_option` WHERE order_id = '" . (int)$order_id . "'");
  106. $this->db->query("DELETE FROM `" . DB_PREFIX . "order_voucher` WHERE order_id = '" . (int)$order_id . "'");
  107. $this->db->query("DELETE FROM `" . DB_PREFIX . "order_total` WHERE order_id = '" . (int)$order_id . "'");
  108. $this->db->query("DELETE FROM `" . DB_PREFIX . "order_history` WHERE order_id = '" . (int)$order_id . "'");
  109. $this->db->query("DELETE `or`, ort FROM `" . DB_PREFIX . "order_recurring` `or`, `" . DB_PREFIX . "order_recurring_transaction` `ort` WHERE order_id = '" . (int)$order_id . "' AND ort.order_recurring_id = `or`.order_recurring_id");
  110. $this->db->query("DELETE FROM `" . DB_PREFIX . "affiliate_transaction` WHERE order_id = '" . (int)$order_id . "'");
  111.  
  112. // Gift Voucher
  113. $this->load->model('extension/total/voucher');
  114.  
  115. $this->model_extension_total_voucher->disableVoucher($order_id);
  116. }
  117.  
  118. public function getOrder($order_id) {
  119. $order_query = $this->db->query("SELECT *, (SELECT os.name FROM `" . DB_PREFIX . "order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `" . DB_PREFIX . "order` o WHERE o.order_id = '" . (int)$order_id . "'");
  120.  
  121. if ($order_query->num_rows) {
  122. $country_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "country` WHERE country_id = '" . (int)$order_query->row['payment_country_id'] . "'");
  123.  
  124. if ($country_query->num_rows) {
  125. $payment_iso_code_2 = $country_query->row['iso_code_2'];
  126. $payment_iso_code_3 = $country_query->row['iso_code_3'];
  127. } else {
  128. $payment_iso_code_2 = '';
  129. $payment_iso_code_3 = '';
  130. }
  131.  
  132. $zone_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "zone` WHERE zone_id = '" . (int)$order_query->row['payment_zone_id'] . "'");
  133.  
  134. if ($zone_query->num_rows) {
  135. $payment_zone_code = $zone_query->row['code'];
  136. } else {
  137. $payment_zone_code = '';
  138. }
  139.  
  140. $country_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "country` WHERE country_id = '" . (int)$order_query->row['shipping_country_id'] . "'");
  141.  
  142. if ($country_query->num_rows) {
  143. $shipping_iso_code_2 = $country_query->row['iso_code_2'];
  144. $shipping_iso_code_3 = $country_query->row['iso_code_3'];
  145. } else {
  146. $shipping_iso_code_2 = '';
  147. $shipping_iso_code_3 = '';
  148. }
  149.  
  150. $zone_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "zone` WHERE zone_id = '" . (int)$order_query->row['shipping_zone_id'] . "'");
  151.  
  152. if ($zone_query->num_rows) {
  153. $shipping_zone_code = $zone_query->row['code'];
  154. } else {
  155. $shipping_zone_code = '';
  156. }
  157.  
  158. $this->load->model('localisation/language');
  159.  
  160. $language_info = $this->model_localisation_language->getLanguage($order_query->row['language_id']);
  161.  
  162. if ($language_info) {
  163. $language_code = $language_info['code'];
  164. } else {
  165. $language_code = $this->config->get('config_language');
  166. }
  167.  
  168. return array(
  169. 'order_id' => $order_query->row['order_id'],
  170. 'invoice_no' => $order_query->row['invoice_no'],
  171. 'invoice_prefix' => $order_query->row['invoice_prefix'],
  172. 'store_id' => $order_query->row['store_id'],
  173. 'store_name' => $order_query->row['store_name'],
  174. 'store_url' => $order_query->row['store_url'],
  175. 'customer_id' => $order_query->row['customer_id'],
  176. 'firstname' => $order_query->row['firstname'],
  177. 'lastname' => $order_query->row['lastname'],
  178. 'email' => $order_query->row['email'],
  179. 'telephone' => $order_query->row['telephone'],
  180. 'fax' => $order_query->row['fax'],
  181. 'custom_field' => json_decode($order_query->row['custom_field'], true),
  182. 'payment_firstname' => $order_query->row['payment_firstname'],
  183. 'payment_lastname' => $order_query->row['payment_lastname'],
  184. 'payment_company' => $order_query->row['payment_company'],
  185. 'payment_address_1' => $order_query->row['payment_address_1'],
  186. 'payment_address_2' => $order_query->row['payment_address_2'],
  187. 'payment_postcode' => $order_query->row['payment_postcode'],
  188. 'payment_city' => $order_query->row['payment_city'],
  189. 'payment_zone_id' => $order_query->row['payment_zone_id'],
  190. 'payment_zone' => $order_query->row['payment_zone'],
  191. 'payment_zone_code' => $payment_zone_code,
  192. 'payment_country_id' => $order_query->row['payment_country_id'],
  193. 'payment_country' => $order_query->row['payment_country'],
  194. 'payment_iso_code_2' => $payment_iso_code_2,
  195. 'payment_iso_code_3' => $payment_iso_code_3,
  196. 'payment_address_format' => $order_query->row['payment_address_format'],
  197. 'payment_custom_field' => json_decode($order_query->row['payment_custom_field'], true),
  198. 'payment_method' => $order_query->row['payment_method'],
  199. 'payment_code' => $order_query->row['payment_code'],
  200. 'shipping_firstname' => $order_query->row['shipping_firstname'],
  201. 'shipping_lastname' => $order_query->row['shipping_lastname'],
  202. 'shipping_company' => $order_query->row['shipping_company'],
  203. 'shipping_address_1' => $order_query->row['shipping_address_1'],
  204. 'shipping_address_2' => $order_query->row['shipping_address_2'],
  205. 'shipping_postcode' => $order_query->row['shipping_postcode'],
  206. 'shipping_city' => $order_query->row['shipping_city'],
  207. 'shipping_zone_id' => $order_query->row['shipping_zone_id'],
  208. 'shipping_zone' => $order_query->row['shipping_zone'],
  209. 'shipping_zone_code' => $shipping_zone_code,
  210. 'shipping_country_id' => $order_query->row['shipping_country_id'],
  211. 'shipping_country' => $order_query->row['shipping_country'],
  212. 'shipping_iso_code_2' => $shipping_iso_code_2,
  213. 'shipping_iso_code_3' => $shipping_iso_code_3,
  214. 'shipping_address_format' => $order_query->row['shipping_address_format'],
  215. 'shipping_custom_field' => json_decode($order_query->row['shipping_custom_field'], true),
  216. 'shipping_method' => $order_query->row['shipping_method'],
  217. 'shipping_code' => $order_query->row['shipping_code'],
  218. 'comment' => $order_query->row['comment'],
  219. 'total' => $order_query->row['total'],
  220. 'order_status_id' => $order_query->row['order_status_id'],
  221. 'order_status' => $order_query->row['order_status'],
  222. 'affiliate_id' => $order_query->row['affiliate_id'],
  223. 'commission' => $order_query->row['commission'],
  224. 'language_id' => $order_query->row['language_id'],
  225. 'language_code' => $language_code,
  226. 'currency_id' => $order_query->row['currency_id'],
  227. 'currency_code' => $order_query->row['currency_code'],
  228. 'currency_value' => $order_query->row['currency_value'],
  229. 'ip' => $order_query->row['ip'],
  230. 'forwarded_ip' => $order_query->row['forwarded_ip'],
  231. 'user_agent' => $order_query->row['user_agent'],
  232. 'accept_language' => $order_query->row['accept_language'],
  233. 'date_added' => $order_query->row['date_added'],
  234. 'date_modified' => $order_query->row['date_modified']
  235. );
  236. } else {
  237. return false;
  238. }
  239. }
  240.  
  241. public function addOrderHistory($order_id, $order_status_id, $comment = '', $notify = false, $override = false) {
  242. $order_info = $this->getOrder($order_id);
  243.  
  244. if ($order_info) {
  245. // Fraud Detection
  246. $this->load->model('account/customer');
  247.  
  248. $customer_info = $this->model_account_customer->getCustomer($order_info['customer_id']);
  249.  
  250. if ($customer_info && $customer_info['safe']) {
  251. $safe = true;
  252. } else {
  253. $safe = false;
  254. }
  255.  
  256. // Only do the fraud check if the customer is not on the safe list and the order status is changing into the complete or process order status
  257. if (!$safe && !$override && in_array($order_status_id, array_merge($this->config->get('config_processing_status'), $this->config->get('config_complete_status')))) {
  258. // Anti-Fraud
  259. $this->load->model('extension/extension');
  260.  
  261. $extensions = $this->model_extension_extension->getExtensions('fraud');
  262.  
  263. foreach ($extensions as $extension) {
  264. if ($this->config->get($extension['code'] . '_status')) {
  265. $this->load->model('extension/fraud/' . $extension['code']);
  266.  
  267. $fraud_status_id = $this->{'model_fraud_' . $extension['code']}->check($order_info);
  268.  
  269. if ($fraud_status_id) {
  270. $order_status_id = $fraud_status_id;
  271. }
  272. }
  273. }
  274. }
  275.  
  276. // If current order status is not processing or complete but new status is processing or complete then commence completing the order
  277. if (!in_array($order_info['order_status_id'], array_merge($this->config->get('config_processing_status'), $this->config->get('config_complete_status'))) && in_array($order_status_id, array_merge($this->config->get('config_processing_status'), $this->config->get('config_complete_status')))) {
  278. // Redeem coupon, vouchers and reward points
  279. $order_total_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total` WHERE order_id = '" . (int)$order_id . "' ORDER BY sort_order ASC");
  280.  
  281. foreach ($order_total_query->rows as $order_total) {
  282. $this->load->model('extension/total/' . $order_total['code']);
  283.  
  284. if (property_exists($this->{'model_extension_total_' . $order_total['code']}, 'confirm')) {
  285. // Confirm coupon, vouchers and reward points
  286. $fraud_status_id = $this->{'model_extension_total_' . $order_total['code']}->confirm($order_info, $order_total);
  287.  
  288. // If the balance on the coupon, vouchers and reward points is not enough to cover the transaction or has already been used then the fraud order status is returned.
  289. if ($fraud_status_id) {
  290. $order_status_id = $fraud_status_id;
  291. }
  292. }
  293. }
  294.  
  295. // Add commission if sale is linked to affiliate referral.
  296. if ($order_info['affiliate_id'] && $this->config->get('config_affiliate_auto')) {
  297. $this->load->model('affiliate/affiliate');
  298.  
  299. $this->model_affiliate_affiliate->addTransaction($order_info['affiliate_id'], $order_info['commission'], $order_id);
  300. }
  301.  
  302. // Stock subtraction
  303. $order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
  304.  
  305. foreach ($order_product_query->rows as $order_product) {
  306. $this->db->query("UPDATE " . DB_PREFIX . "product SET quantity = (quantity - " . (int)$order_product['quantity'] . ") WHERE product_id = '" . (int)$order_product['product_id'] . "' AND subtract = '1'");
  307.  
  308. $order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product['order_product_id'] . "'");
  309.  
  310. foreach ($order_option_query->rows as $option) {
  311. $this->db->query("UPDATE " . DB_PREFIX . "product_option_value SET quantity = (quantity - " . (int)$order_product['quantity'] . ") WHERE product_option_value_id = '" . (int)$option['product_option_value_id'] . "' AND subtract = '1'");
  312. }
  313. }
  314. }
  315.  
  316. // Update the DB with the new statuses
  317. $this->db->query("UPDATE `" . DB_PREFIX . "order` SET order_status_id = '" . (int)$order_status_id . "', date_modified = NOW() WHERE order_id = '" . (int)$order_id . "'");
  318.  
  319. $this->db->query("INSERT INTO " . DB_PREFIX . "order_history SET order_id = '" . (int)$order_id . "', order_status_id = '" . (int)$order_status_id . "', notify = '" . (int)$notify . "', comment = '" . $this->db->escape($comment) . "', date_added = NOW()");
  320.  
  321. // If old order status is the processing or complete status but new status is not then commence restock, and remove coupon, voucher and reward history
  322. if (in_array($order_info['order_status_id'], array_merge($this->config->get('config_processing_status'), $this->config->get('config_complete_status'))) && !in_array($order_status_id, array_merge($this->config->get('config_processing_status'), $this->config->get('config_complete_status')))) {
  323. // Restock
  324. $product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
  325.  
  326. foreach($product_query->rows as $product) {
  327. $this->db->query("UPDATE `" . DB_PREFIX . "product` SET quantity = (quantity + " . (int)$product['quantity'] . ") WHERE product_id = '" . (int)$product['product_id'] . "' AND subtract = '1'");
  328.  
  329. $option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
  330.  
  331. foreach ($option_query->rows as $option) {
  332. $this->db->query("UPDATE " . DB_PREFIX . "product_option_value SET quantity = (quantity + " . (int)$product['quantity'] . ") WHERE product_option_value_id = '" . (int)$option['product_option_value_id'] . "' AND subtract = '1'");
  333. }
  334. }
  335.  
  336. // Remove coupon, vouchers and reward points history
  337. $this->load->model('account/order');
  338.  
  339. $order_total_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total` WHERE order_id = '" . (int)$order_id . "' ORDER BY sort_order ASC");
  340.  
  341. foreach ($order_total_query->rows as $order_total) {
  342. $this->load->model('extension/total/' . $order_total['code']);
  343.  
  344. if (property_exists($this->{'model_extension_total_' . $order_total['code']}, 'unconfirm')) {
  345. $this->{'model_extension_total_' . $order_total['code']}->unconfirm($order_id);
  346. }
  347. }
  348.  
  349. // Remove commission if sale is linked to affiliate referral.
  350. if ($order_info['affiliate_id']) {
  351. $this->load->model('affiliate/affiliate');
  352.  
  353. $this->model_affiliate_affiliate->deleteTransaction($order_id);
  354. }
  355. }
  356.  
  357. $this->cache->delete('product');
  358.  
  359. // If order status is 0 then becomes greater than 0 send main html email
  360. if (!$order_info['order_status_id'] && $order_status_id) {
  361. // Check for any downloadable products
  362. $download_status = false;
  363.  
  364. $order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
  365.  
  366. foreach ($order_product_query->rows as $order_product) {
  367. // Check if there are any linked downloads
  368. $product_download_query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "product_to_download` WHERE product_id = '" . (int)$order_product['product_id'] . "'");
  369.  
  370. if ($product_download_query->row['total']) {
  371. $download_status = true;
  372. }
  373. }
  374.  
  375. // Load the language for any mails that might be required to be sent out
  376. $language = new Language($order_info['language_code']);
  377. $language->load($order_info['language_code']);
  378. $language->load('mail/order');
  379.  
  380. $order_status_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_status WHERE order_status_id = '" . (int)$order_status_id . "' AND language_id = '" . (int)$order_info['language_id'] . "'");
  381.  
  382. if ($order_status_query->num_rows) {
  383. $order_status = $order_status_query->row['name'];
  384. } else {
  385. $order_status = '';
  386. }
  387.  
  388. $subject = sprintf($language->get('text_new_subject'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'), $order_id);
  389.  
  390. // HTML Mail
  391. $data = array();
  392.  
  393. $data['title'] = sprintf($language->get('text_new_subject'), $order_info['store_name'], $order_id);
  394.  
  395. $data['text_greeting'] = sprintf($language->get('text_new_greeting'), $order_info['store_name']);
  396. $data['text_link'] = $language->get('text_new_link');
  397. $data['text_download'] = $language->get('text_new_download');
  398. $data['text_order_detail'] = $language->get('text_new_order_detail');
  399. $data['text_instruction'] = $language->get('text_new_instruction');
  400. $data['text_order_id'] = $language->get('text_new_order_id');
  401. $data['text_date_added'] = $language->get('text_new_date_added');
  402. $data['text_payment_method'] = $language->get('text_new_payment_method');
  403. $data['text_shipping_method'] = $language->get('text_new_shipping_method');
  404. $data['text_email'] = $language->get('text_new_email');
  405. $data['text_telephone'] = $language->get('text_new_telephone');
  406. $data['text_ip'] = $language->get('text_new_ip');
  407. $data['text_order_status'] = $language->get('text_new_order_status');
  408. $data['text_payment_address'] = $language->get('text_new_payment_address');
  409. $data['text_shipping_address'] = $language->get('text_new_shipping_address');
  410. $data['text_product'] = $language->get('text_new_product');
  411. $data['text_model'] = $language->get('text_new_model');
  412. $data['text_quantity'] = $language->get('text_new_quantity');
  413. $data['text_price'] = $language->get('text_new_price');
  414. $data['text_total'] = $language->get('text_new_total');
  415. $data['text_footer'] = $language->get('text_new_footer');
  416.  
  417. $data['logo'] = $this->config->get('config_url') . 'image/' . $this->config->get('config_logo');
  418. $data['store_name'] = $order_info['store_name'];
  419. $data['store_url'] = $order_info['store_url'];
  420. $data['customer_id'] = $order_info['customer_id'];
  421. $data['link'] = $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id;
  422.  
  423. if ($download_status) {
  424. $data['download'] = $order_info['store_url'] . 'index.php?route=account/download';
  425. } else {
  426. $data['download'] = '';
  427. }
  428.  
  429. $data['order_id'] = $order_id;
  430. $data['date_added'] = date($language->get('date_format_short'), strtotime($order_info['date_added']));
  431. $data['payment_method'] = $order_info['payment_method'];
  432. $data['shipping_method'] = $order_info['shipping_method'];
  433. $data['email'] = $order_info['email'];
  434. $data['telephone'] = $order_info['telephone'];
  435. $data['ip'] = $order_info['ip'];
  436. $data['order_status'] = $order_status;
  437.  
  438. if ($comment && $notify) {
  439. $data['comment'] = nl2br($comment);
  440. } else {
  441. $data['comment'] = '';
  442. }
  443.  
  444. if ($order_info['payment_address_format']) {
  445. $format = $order_info['payment_address_format'];
  446. } else {
  447. $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}';
  448. }
  449.  
  450. $find = array(
  451. '{firstname}',
  452. '{lastname}',
  453. '{company}',
  454. '{address_1}',
  455. '{address_2}',
  456. '{city}',
  457. '{postcode}',
  458. '{zone}',
  459. '{zone_code}',
  460. '{country}'
  461. );
  462.  
  463. $replace = array(
  464. 'firstname' => $order_info['payment_firstname'],
  465. 'lastname' => $order_info['payment_lastname'],
  466. 'company' => $order_info['payment_company'],
  467. 'address_1' => $order_info['payment_address_1'],
  468. 'address_2' => $order_info['payment_address_2'],
  469. 'city' => $order_info['payment_city'],
  470. 'postcode' => $order_info['payment_postcode'],
  471. 'zone' => $order_info['payment_zone'],
  472. 'zone_code' => $order_info['payment_zone_code'],
  473. 'country' => $order_info['payment_country']
  474. );
  475.  
  476. $data['payment_address'] = str_replace(array("\r\n", "\r", "\n"), '<br />', preg_replace(array("/\s\s+/", "/\r\r+/", "/\n\n+/"), '<br />', trim(str_replace($find, $replace, $format))));
  477.  
  478. if ($order_info['shipping_address_format']) {
  479. $format = $order_info['shipping_address_format'];
  480. } else {
  481. $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}';
  482. }
  483.  
  484. $find = array(
  485. '{firstname}',
  486. '{lastname}',
  487. '{company}',
  488. '{address_1}',
  489. '{address_2}',
  490. '{city}',
  491. '{postcode}',
  492. '{zone}',
  493. '{zone_code}',
  494. '{country}'
  495. );
  496.  
  497. $replace = array(
  498. 'firstname' => $order_info['shipping_firstname'],
  499. 'lastname' => $order_info['shipping_lastname'],
  500. 'company' => $order_info['shipping_company'],
  501. 'address_1' => $order_info['shipping_address_1'],
  502. 'address_2' => $order_info['shipping_address_2'],
  503. 'city' => $order_info['shipping_city'],
  504. 'postcode' => $order_info['shipping_postcode'],
  505. 'zone' => $order_info['shipping_zone'],
  506. 'zone_code' => $order_info['shipping_zone_code'],
  507. 'country' => $order_info['shipping_country']
  508. );
  509.  
  510. $data['shipping_address'] = str_replace(array("\r\n", "\r", "\n"), '<br />', preg_replace(array("/\s\s+/", "/\r\r+/", "/\n\n+/"), '<br />', trim(str_replace($find, $replace, $format))));
  511.  
  512. $this->load->model('tool/upload');
  513.  
  514. // Products
  515. $data['products'] = array();
  516.  
  517. foreach ($order_product_query->rows as $product) {
  518. $option_data = array();
  519.  
  520. $order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
  521.  
  522. foreach ($order_option_query->rows as $option) {
  523. if ($option['type'] != 'file') {
  524. $value = $option['value'];
  525. } else {
  526. $upload_info = $this->model_tool_upload->getUploadByCode($option['value']);
  527.  
  528. if ($upload_info) {
  529. $value = $upload_info['name'];
  530. } else {
  531. $value = '';
  532. }
  533. }
  534.  
  535. $option_data[] = array(
  536. 'name' => $option['name'],
  537. 'value' => (utf8_strlen($value) > 20 ? utf8_substr($value, 0, 20) . '..' : $value)
  538. );
  539. }
  540.  
  541. $data['products'][] = array(
  542. 'name' => $product['name'],
  543. 'model' => $product['model'],
  544. 'option' => $option_data,
  545. 'quantity' => $product['quantity'],
  546. 'stock' => $this->db->query("SELECT IFNULL(ss.name, \"Fora de Estoque\") as stock FROM `".DB_PREFIX."product` p RIGHT JOIN `".DB_PREFIX."stock_status` ss ON (ss.stock_status_id = p.stock_status_id) WHERE ss.language_id = ".$this->config->get('config_language')." AND product_id = ".$product["id"].";")->row["stock"],
  547. 'price' => $this->currency->format($product['price'] + ($this->config->get('config_tax') ? $product['tax'] : 0), $order_info['currency_code'], $order_info['currency_value']),
  548. 'total' => $this->currency->format($product['total'] + ($this->config->get('config_tax') ? ($product['tax'] * $product['quantity']) : 0), $order_info['currency_code'], $order_info['currency_value'])
  549. );
  550. }
  551.  
  552. // Vouchers
  553. $data['vouchers'] = array();
  554.  
  555. $order_voucher_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_voucher WHERE order_id = '" . (int)$order_id . "'");
  556.  
  557. foreach ($order_voucher_query->rows as $voucher) {
  558. $data['vouchers'][] = array(
  559. 'description' => $voucher['description'],
  560. 'amount' => $this->currency->format($voucher['amount'], $order_info['currency_code'], $order_info['currency_value']),
  561. );
  562. }
  563.  
  564. // Order Totals
  565. $data['totals'] = array();
  566.  
  567. $order_total_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total` WHERE order_id = '" . (int)$order_id . "' ORDER BY sort_order ASC");
  568.  
  569. foreach ($order_total_query->rows as $total) {
  570. $data['totals'][] = array(
  571. 'title' => $total['title'],
  572. 'text' => $this->currency->format($total['value'], $order_info['currency_code'], $order_info['currency_value']),
  573. );
  574. }
  575.  
  576. // Text Mail
  577. $text = sprintf($language->get('text_new_greeting'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8')) . "\n\n";
  578. $text .= $language->get('text_new_order_id') . ' ' . $order_id . "\n";
  579. $text .= $language->get('text_new_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n";
  580. $text .= $language->get('text_new_order_status') . ' ' . $order_status . "\n\n";
  581.  
  582. if ($comment && $notify) {
  583. $text .= $language->get('text_new_instruction') . "\n\n";
  584. $text .= $comment . "\n\n";
  585. }
  586.  
  587. // Products
  588. $text .= $language->get('text_new_products') . "\n";
  589.  
  590. foreach ($order_product_query->rows as $product) {
  591. $text .= $product['quantity'] . 'x ' . $product['name'] . ' (' . $product['model'] . ') ' . html_entity_decode($this->currency->format($product['total'] + ($this->config->get('config_tax') ? ($product['tax'] * $product['quantity']) : 0), $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";
  592.  
  593. $order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . $product['order_product_id'] . "'");
  594.  
  595. foreach ($order_option_query->rows as $option) {
  596. if ($option['type'] != 'file') {
  597. $value = $option['value'];
  598. } else {
  599. $upload_info = $this->model_tool_upload->getUploadByCode($option['value']);
  600.  
  601. if ($upload_info) {
  602. $value = $upload_info['name'];
  603. } else {
  604. $value = '';
  605. }
  606. }
  607.  
  608. $text .= chr(9) . '-' . $option['name'] . ' ' . (utf8_strlen($value) > 20 ? utf8_substr($value, 0, 20) . '..' : $value) . "\n";
  609. }
  610. }
  611.  
  612. foreach ($order_voucher_query->rows as $voucher) {
  613. $text .= '1x ' . $voucher['description'] . ' ' . $this->currency->format($voucher['amount'], $order_info['currency_code'], $order_info['currency_value']);
  614. }
  615.  
  616. $text .= "\n";
  617.  
  618. $text .= $language->get('text_new_order_total') . "\n";
  619.  
  620. foreach ($order_total_query->rows as $total) {
  621. $text .= $total['title'] . ': ' . html_entity_decode($this->currency->format($total['value'], $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";
  622. }
  623.  
  624. $text .= "\n";
  625.  
  626. if ($order_info['customer_id']) {
  627. $text .= $language->get('text_new_link') . "\n";
  628. $text .= $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id . "\n\n";
  629. }
  630.  
  631. if ($download_status) {
  632. $text .= $language->get('text_new_download') . "\n";
  633. $text .= $order_info['store_url'] . 'index.php?route=account/download' . "\n\n";
  634. }
  635.  
  636. // Comment
  637. if ($order_info['comment']) {
  638. $text .= $language->get('text_new_comment') . "\n\n";
  639. $text .= $order_info['comment'] . "\n\n";
  640. }
  641.  
  642. $text .= $language->get('text_new_footer') . "\n\n";
  643.  
  644. $mail = new Mail();
  645. $mail->protocol = $this->config->get('config_mail_protocol');
  646. $mail->parameter = $this->config->get('config_mail_parameter');
  647. $mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');
  648. $mail->smtp_username = $this->config->get('config_mail_smtp_username');
  649. $mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');
  650. $mail->smtp_port = $this->config->get('config_mail_smtp_port');
  651. $mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');
  652.  
  653. $mail->setTo($order_info['email']);
  654. $mail->setFrom($this->config->get('config_email'));
  655. $mail->setSender(html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'));
  656. $mail->setSubject(html_entity_decode($subject, ENT_QUOTES, 'UTF-8'));
  657. $mail->setHtml($this->load->view('mail/order', $data));
  658. $mail->setText($text);
  659. $mail->send();
  660.  
  661. // Admin Alert Mail
  662. if (in_array('order', (array)$this->config->get('config_mail_alert'))) {
  663. $subject = sprintf($language->get('text_new_subject'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'), $order_id);
  664.  
  665. // HTML Mail
  666. $data['text_greeting'] = $language->get('text_new_received');
  667.  
  668. if ($comment) {
  669. if ($order_info['comment']) {
  670. $data['comment'] = nl2br($comment) . '<br/><br/>' . $order_info['comment'];
  671. } else {
  672. $data['comment'] = nl2br($comment);
  673. }
  674. } else {
  675. if ($order_info['comment']) {
  676. $data['comment'] = $order_info['comment'];
  677. } else {
  678. $data['comment'] = '';
  679. }
  680. }
  681.  
  682. $data['text_download'] = '';
  683.  
  684. $data['text_footer'] = '';
  685.  
  686. $data['text_link'] = '';
  687. $data['link'] = '';
  688. $data['download'] = '';
  689.  
  690. // Text
  691. $text = $language->get('text_new_received') . "\n\n";
  692. $text .= $language->get('text_new_order_id') . ' ' . $order_id . "\n";
  693. $text .= $language->get('text_new_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n";
  694. $text .= $language->get('text_new_order_status') . ' ' . $order_status . "\n\n";
  695. $text .= $language->get('text_new_products') . "\n";
  696.  
  697. foreach ($order_product_query->rows as $product) {
  698. $text .= $product['quantity'] . 'x ' . $product['name'] . ' (' . $product['model'] . ') ' . html_entity_decode($this->currency->format($product['total'] + ($this->config->get('config_tax') ? ($product['tax'] * $product['quantity']) : 0), $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";
  699.  
  700. $order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . $product['order_product_id'] . "'");
  701.  
  702. foreach ($order_option_query->rows as $option) {
  703. if ($option['type'] != 'file') {
  704. $value = $option['value'];
  705. } else {
  706. $value = utf8_substr($option['value'], 0, utf8_strrpos($option['value'], '.'));
  707. }
  708.  
  709. $text .= chr(9) . '-' . $option['name'] . ' ' . (utf8_strlen($value) > 20 ? utf8_substr($value, 0, 20) . '..' : $value) . "\n";
  710. }
  711. }
  712.  
  713. foreach ($order_voucher_query->rows as $voucher) {
  714. $text .= '1x ' . $voucher['description'] . ' ' . $this->currency->format($voucher['amount'], $order_info['currency_code'], $order_info['currency_value']);
  715. }
  716.  
  717. $text .= "\n";
  718.  
  719. $text .= $language->get('text_new_order_total') . "\n";
  720.  
  721. foreach ($order_total_query->rows as $total) {
  722. $text .= $total['title'] . ': ' . html_entity_decode($this->currency->format($total['value'], $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";
  723. }
  724.  
  725. $text .= "\n";
  726.  
  727. if ($order_info['comment']) {
  728. $text .= $language->get('text_new_comment') . "\n\n";
  729. $text .= $order_info['comment'] . "\n\n";
  730. }
  731.  
  732. $mail = new Mail();
  733. $mail->protocol = $this->config->get('config_mail_protocol');
  734. $mail->parameter = $this->config->get('config_mail_parameter');
  735. $mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');
  736. $mail->smtp_username = $this->config->get('config_mail_smtp_username');
  737. $mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');
  738. $mail->smtp_port = $this->config->get('config_mail_smtp_port');
  739. $mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');
  740.  
  741. $mail->setTo($this->config->get('config_email'));
  742. $mail->setFrom($this->config->get('config_email'));
  743. $mail->setSender(html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'));
  744. $mail->setSubject(html_entity_decode($subject, ENT_QUOTES, 'UTF-8'));
  745. $mail->setHtml($this->load->view('mail/order', $data));
  746. $mail->setText($text);
  747. $mail->send();
  748.  
  749. // Send to additional alert emails
  750. $emails = explode(',', $this->config->get('config_alert_email'));
  751.  
  752. foreach ($emails as $email) {
  753. if ($email && filter_var($email, FILTER_VALIDATE_EMAIL)) {
  754. $mail->setTo($email);
  755. $mail->send();
  756. }
  757. }
  758. }
  759. }
  760.  
  761. // If order status is not 0 then send update text email
  762. if ($order_info['order_status_id'] && $order_status_id && $notify) {
  763. $language = new Language($order_info['language_code']);
  764. $language->load($order_info['language_code']);
  765. $language->load('mail/order');
  766.  
  767. $subject = sprintf($language->get('text_update_subject'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'), $order_id);
  768.  
  769. $message = $language->get('text_update_order') . ' ' . $order_id . "\n";
  770. $message .= $language->get('text_update_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n\n";
  771.  
  772. $order_status_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_status WHERE order_status_id = '" . (int)$order_status_id . "' AND language_id = '" . (int)$order_info['language_id'] . "'");
  773.  
  774. if ($order_status_query->num_rows) {
  775. $message .= $language->get('text_update_order_status') . "\n\n";
  776. $message .= $order_status_query->row['name'] . "\n\n";
  777. }
  778.  
  779. if ($order_info['customer_id']) {
  780. $message .= $language->get('text_update_link') . "\n";
  781. $message .= $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id . "\n\n";
  782. }
  783.  
  784. if ($comment) {
  785. $message .= $language->get('text_update_comment') . "\n\n";
  786. $message .= strip_tags($comment) . "\n\n";
  787. }
  788.  
  789. $message .= $language->get('text_update_footer');
  790.  
  791. $mail = new Mail();
  792. $mail->protocol = $this->config->get('config_mail_protocol');
  793. $mail->parameter = $this->config->get('config_mail_parameter');
  794. $mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');
  795. $mail->smtp_username = $this->config->get('config_mail_smtp_username');
  796. $mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');
  797. $mail->smtp_port = $this->config->get('config_mail_smtp_port');
  798. $mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');
  799.  
  800. $mail->setTo($order_info['email']);
  801. $mail->setFrom($this->config->get('config_email'));
  802. $mail->setSender(html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'));
  803. $mail->setSubject(html_entity_decode($subject, ENT_QUOTES, 'UTF-8'));
  804. $mail->setText($message);
  805. $mail->send();
  806. }
  807. }
  808. }
  809. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!