PageRenderTime 56ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/catalog/model/checkout/order.php

https://bitbucket.org/monobasic/shop.volero.ch
PHP | 565 lines | 453 code | 104 blank | 8 comment | 52 complexity | a6e05e4cb997f096c4cd697ed43cff93 MD5 | raw file
    

  1. <?php

    2. 

  2. class ModelCheckoutOrder extends Model {	

    3. 

  3. 	public function create($data) {

    4. 

  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']) . "', 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_method = '" . $this->db->escape($data['shipping_method']) . "', 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_method = '" . $this->db->escape($data['payment_method']) . "', comment = '" . $this->db->escape($data['comment']) . "', total = '" . (float)$data['total'] . "', reward = '" . (float)$data['reward'] . "', affiliate_id = '" . (int)$data['affiliate_id'] . "', commission = '" . (float)$data['commission'] . "', 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']) . "', date_added = NOW(), date_modified = NOW()");

    5. 

  5. 

    6. 

  6. 		$order_id = $this->db->getLastId();

    7. 

  7. 

    8. 

  8. 		foreach ($data['products'] as $product) { 

    9. 

  9. 			$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'] . "'");

    10. 

  10.  

    11. 

  11. 			$order_product_id = $this->db->getLastId();

    12. 

  12. 

    13. 

  13. 			foreach ($product['option'] as $option) {

    14. 

  14. 				$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']) . "'");

    15. 

  15. 			}

    16. 

  16. 				

    17. 

  17. 			foreach ($product['download'] as $download) {

    18. 

  18. 				$this->db->query("INSERT INTO " . DB_PREFIX . "order_download SET order_id = '" . (int)$order_id . "', order_product_id = '" . (int)$order_product_id . "', name = '" . $this->db->escape($download['name']) . "', filename = '" . $this->db->escape($download['filename']) . "', mask = '" . $this->db->escape($download['mask']) . "', remaining = '" . (int)($download['remaining'] * $product['quantity']) . "'");

    19. 

  19. 			}	

    20. 

  20. 		}

    21. 

  21. 		

    22. 

  22. 		foreach ($data['totals'] as $total) {

    23. 

  23. 			$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']) . "', text = '" . $this->db->escape($total['text']) . "', `value` = '" . (float)$total['value'] . "', sort_order = '" . (int)$total['sort_order'] . "'");

    24. 

  24. 		}	

    25. 

  25. 

    26. 

  26. 		return $order_id;

    27. 

  27. 	}

    28. 

  28. 

    29. 

  29. 	public function getOrder($order_id) {

    30. 

  30. 		$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 . "'");

    31. 

  31. 			

    32. 

  32. 		if ($order_query->num_rows) {

    33. 

  33. 			$country_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "country` WHERE country_id = '" . (int)$order_query->row['shipping_country_id'] . "'");

    34. 

  34. 			

    35. 

  35. 			if ($country_query->num_rows) {

    36. 

  36. 				$shipping_iso_code_2 = $country_query->row['iso_code_2'];

    37. 

  37. 				$shipping_iso_code_3 = $country_query->row['iso_code_3'];

    38. 

  38. 			} else {

    39. 

  39. 				$shipping_iso_code_2 = '';

    40. 

  40. 				$shipping_iso_code_3 = '';				

    41. 

  41. 			}

    42. 

  42. 			

    43. 

  43. 			$zone_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "zone` WHERE zone_id = '" . (int)$order_query->row['shipping_zone_id'] . "'");

    44. 

  44. 			

    45. 

  45. 			if ($zone_query->num_rows) {

    46. 

  46. 				$shipping_zone_code = $zone_query->row['code'];

    47. 

  47. 			} else {

    48. 

  48. 				$shipping_zone_code = '';

    49. 

  49. 			}

    50. 

  50. 			

    51. 

  51. 			$country_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "country` WHERE country_id = '" . (int)$order_query->row['payment_country_id'] . "'");

    52. 

  52. 			

    53. 

  53. 			if ($country_query->num_rows) {

    54. 

  54. 				$payment_iso_code_2 = $country_query->row['iso_code_2'];

    55. 

  55. 				$payment_iso_code_3 = $country_query->row['iso_code_3'];

    56. 

  56. 			} else {

    57. 

  57. 				$payment_iso_code_2 = '';

    58. 

  58. 				$payment_iso_code_3 = '';				

    59. 

  59. 			}

    60. 

  60. 			

    61. 

  61. 			$zone_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "zone` WHERE zone_id = '" . (int)$order_query->row['payment_zone_id'] . "'");

    62. 

  62. 			

    63. 

  63. 			if ($zone_query->num_rows) {

    64. 

  64. 				$payment_zone_code = $zone_query->row['code'];

    65. 

  65. 			} else {

    66. 

  66. 				$payment_zone_code = '';

    67. 

  67. 			}

    68. 

  68. 

    69. 

  69. 			$this->load->model('localisation/language');

    70. 

  70. 			

    71. 

  71. 			$language_info = $this->model_localisation_language->getLanguage($order_query->row['language_id']);

    72. 

  72. 			

    73. 

  73. 			if ($language_info) {

    74. 

  74. 				$language_code = $language_info['code'];

    75. 

  75. 				$language_filename = $language_info['filename'];

    76. 

  76. 				$language_directory = $language_info['directory'];

    77. 

  77. 			} else {

    78. 

  78. 				$language_code = '';

    79. 

  79. 				$language_filename = '';

    80. 

  80. 				$language_directory = '';

    81. 

  81. 			}

    82. 

  82. 		 			

    83. 

  83. 			return array(

    84. 

  84. 				'order_id'                => $order_query->row['order_id'],

    85. 

  85. 				'invoice_no'              => $order_query->row['invoice_no'],

    86. 

  86. 				'invoice_prefix'          => $order_query->row['invoice_prefix'],

    87. 

  87. 				'store_id'                => $order_query->row['store_id'],

    88. 

  88. 				'store_name'              => $order_query->row['store_name'],

    89. 

  89. 				'store_url'               => $order_query->row['store_url'],				

    90. 

  90. 				'customer_id'             => $order_query->row['customer_id'],

    91. 

  91. 				'firstname'               => $order_query->row['firstname'],

    92. 

  92. 				'lastname'                => $order_query->row['lastname'],

    93. 

  93. 				'telephone'               => $order_query->row['telephone'],

    94. 

  94. 				'fax'                     => $order_query->row['fax'],

    95. 

  95. 				'email'                   => $order_query->row['email'],

    96. 

  96. 				'shipping_firstname'      => $order_query->row['shipping_firstname'],

    97. 

  97. 				'shipping_lastname'       => $order_query->row['shipping_lastname'],				

    98. 

  98. 				'shipping_company'        => $order_query->row['shipping_company'],

    99. 

  99. 				'shipping_address_1'      => $order_query->row['shipping_address_1'],

    100. 

  100. 				'shipping_address_2'      => $order_query->row['shipping_address_2'],

    101. 

  101. 				'shipping_postcode'       => $order_query->row['shipping_postcode'],

    102. 

  102. 				'shipping_city'           => $order_query->row['shipping_city'],

    103. 

  103. 				'shipping_zone_id'        => $order_query->row['shipping_zone_id'],

    104. 

  104. 				'shipping_zone'           => $order_query->row['shipping_zone'],

    105. 

  105. 				'shipping_zone_code'      => $shipping_zone_code,

    106. 

  106. 				'shipping_country_id'     => $order_query->row['shipping_country_id'],

    107. 

  107. 				'shipping_country'        => $order_query->row['shipping_country'],	

    108. 

  108. 				'shipping_iso_code_2'     => $shipping_iso_code_2,

    109. 

  109. 				'shipping_iso_code_3'     => $shipping_iso_code_3,

    110. 

  110. 				'shipping_address_format' => $order_query->row['shipping_address_format'],

    111. 

  111. 				'shipping_method'         => $order_query->row['shipping_method'],

    112. 

  112. 				'payment_firstname'       => $order_query->row['payment_firstname'],

    113. 

  113. 				'payment_lastname'        => $order_query->row['payment_lastname'],				

    114. 

  114. 				'payment_company'         => $order_query->row['payment_company'],

    115. 

  115. 				'payment_address_1'       => $order_query->row['payment_address_1'],

    116. 

  116. 				'payment_address_2'       => $order_query->row['payment_address_2'],

    117. 

  117. 				'payment_postcode'        => $order_query->row['payment_postcode'],

    118. 

  118. 				'payment_city'            => $order_query->row['payment_city'],

    119. 

  119. 				'payment_zone_id'         => $order_query->row['payment_zone_id'],

    120. 

  120. 				'payment_zone'            => $order_query->row['payment_zone'],

    121. 

  121. 				'payment_zone_code'       => $payment_zone_code,

    122. 

  122. 				'payment_country_id'      => $order_query->row['payment_country_id'],

    123. 

  123. 				'payment_country'         => $order_query->row['payment_country'],	

    124. 

  124. 				'payment_iso_code_2'      => $payment_iso_code_2,

    125. 

  125. 				'payment_iso_code_3'      => $payment_iso_code_3,

    126. 

  126. 				'payment_address_format'  => $order_query->row['payment_address_format'],

    127. 

  127. 				'payment_method'          => $order_query->row['payment_method'],

    128. 

  128. 				'comment'                 => $order_query->row['comment'],

    129. 

  129. 				'total'                   => $order_query->row['total'],

    130. 

  130. 				'order_status_id'         => $order_query->row['order_status_id'],

    131. 

  131. 				'order_status'            => $order_query->row['order_status'],

    132. 

  132. 				'language_id'             => $order_query->row['language_id'],

    133. 

  133. 				'language_code'           => $language_code,

    134. 

  134. 				'language_filename'       => $language_filename,

    135. 

  135. 				'language_directory'      => $language_directory,

    136. 

  136. 				'currency_id'             => $order_query->row['currency_id'],

    137. 

  137. 				'currency_code'           => $order_query->row['currency_code'],

    138. 

  138. 				'currency_value'          => $order_query->row['currency_value'],

    139. 

  139. 				'date_modified'           => $order_query->row['date_modified'],

    140. 

  140. 				'date_added'              => $order_query->row['date_added'],

    141. 

  141. 				'ip'                      => $order_query->row['ip']

    142. 

  142. 			);

    143. 

  143. 		} else {

    144. 

  144. 			return false;	

    145. 

  145. 		}

    146. 

  146. 	}	

    147. 

  147. 

    148. 

  148. 	public function confirm($order_id, $order_status_id, $comment = '', $notify = false) {

    149. 

  149. 		$order_info = $this->getOrder($order_id);

    150. 

  150. 		 

    151. 

  151. 		if ($order_info && !$order_info['order_status_id']) {

    152. 

  152. 			$this->db->query("UPDATE `" . DB_PREFIX . "order` SET order_status_id = '" . (int)$order_status_id . "', date_modified = NOW() WHERE order_id = '" . (int)$order_id . "'");

    153. 

  153. 

    154. 

  154. 			$this->db->query("INSERT INTO " . DB_PREFIX . "order_history SET order_id = '" . (int)$order_id . "', order_status_id = '" . (int)$order_status_id . "', notify = '1', comment = '" . $this->db->escape(($comment && $notify) ? $comment : '') . "', date_added = NOW()");

    155. 

  155. 

    156. 

  156. 			$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");

    157. 

  157. 			

    158. 

  158. 			foreach ($order_product_query->rows as $order_product) {

    159. 

  159. 				$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'");

    160. 

  160. 				

    161. 

  161. 				$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'] . "'");

    162. 

  162. 			

    163. 

  163. 				foreach ($order_option_query->rows as $option) {

    164. 

  164. 					$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'");

    165. 

  165. 				}

    166. 

  166. 			}

    167. 

  167. 			

    168. 

  168. 			$this->cache->delete('product');

    169. 

  169. 			

    170. 

  170. 			$order_total_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total` WHERE order_id = '" . (int)$order_id . "'");

    171. 

  171. 			

    172. 

  172. 			foreach ($order_total_query->rows as $order_total) {

    173. 

  173. 				$this->load->model('total/' . $order_total['code']);

    174. 

  174. 				

    175. 

  175. 				if (method_exists($this->{'model_total_' . $order_total['code']}, 'confirm')) {

    176. 

  176. 					$this->{'model_total_' . $order_total['code']}->confirm($order_info, $order_total);

    177. 

  177. 				}

    178. 

  178. 			}

    179. 

  179. 			

    180. 

  180. 			// Send out any gift voucher mails

    181. 

  181. 			if ($this->config->get('config_complete_status_id') == $order_status_id) {

    182. 

  182. 				$this->load->model('checkout/voucher');

    183. 

  183. 

    184. 

  184. 				$this->model_checkout_voucher->confirm($order_id);

    185. 

  185. 			}

    186. 

  186. 			

    187. 

  187. 			// Send out order confirmation mail

    188. 

  188. 			$language = new Language($order_info['language_directory']);

    189. 

  189. 			$language->load($order_info['language_filename']);

    190. 

  190. 			$language->load('mail/order');

    191. 

  191. 		 

    192. 

  192. 			$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'] . "'");

    193. 

  193. 			

    194. 

  194. 			if ($order_status_query->num_rows) {

    195. 

  195. 				$order_status = $order_status_query->row['name'];	

    196. 

  196. 			} else {

    197. 

  197. 				$order_status = '';

    198. 

  198. 			}

    199. 

  199. 							

    200. 

  200. 			$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");

    201. 

  201. 			$order_total_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' ORDER BY sort_order ASC");

    202. 

  202. 			$order_download_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_download WHERE order_id = '" . (int)$order_id . "'");

    203. 

  203. 			

    204. 

  204. 			$subject = sprintf($language->get('text_new_subject'), $order_info['store_name'], $order_id);

    205. 

  205. 		

    206. 

  206. 			// HTML Mail

    207. 

  207. 			$template = new Template();

    208. 

  208. 			

    209. 

  209. 			$template->data['title'] = sprintf($language->get('text_new_subject'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'), $order_id);

    210. 

  210. 			

    211. 

  211. 			$template->data['text_greeting'] = sprintf($language->get('text_new_greeting'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'));

    212. 

  212. 			$template->data['text_link'] = $language->get('text_new_link');

    213. 

  213. 			$template->data['text_download'] = $language->get('text_new_download');

    214. 

  214. 			$template->data['text_order_detail'] = $language->get('text_new_order_detail');

    215. 

  215. 			$template->data['text_instruction'] = $language->get('text_new_instruction');

    216. 

  216. 			$template->data['text_order_id'] = $language->get('text_new_order_id');

    217. 

  217. 			$template->data['text_date_added'] = $language->get('text_new_date_added');

    218. 

  218. 			$template->data['text_payment_method'] = $language->get('text_new_payment_method');	

    219. 

  219. 			$template->data['text_shipping_method'] = $language->get('text_new_shipping_method');

    220. 

  220. 			$template->data['text_email'] = $language->get('text_new_email');

    221. 

  221. 			$template->data['text_telephone'] = $language->get('text_new_telephone');

    222. 

  222. 			$template->data['text_ip'] = $language->get('text_new_ip');

    223. 

  223. 			$template->data['text_payment_address'] = $language->get('text_new_payment_address');

    224. 

  224. 			$template->data['text_shipping_address'] = $language->get('text_new_shipping_address');

    225. 

  225. 			$template->data['text_product'] = $language->get('text_new_product');

    226. 

  226. 			$template->data['text_model'] = $language->get('text_new_model');

    227. 

  227. 			$template->data['text_quantity'] = $language->get('text_new_quantity');

    228. 

  228. 			$template->data['text_price'] = $language->get('text_new_price');

    229. 

  229. 			$template->data['text_total'] = $language->get('text_new_total');

    230. 

  230. 			$template->data['text_footer'] = $language->get('text_new_footer');

    231. 

  231. 			$template->data['text_powered'] = $language->get('text_new_powered');

    232. 

  232. 			

    233. 

  233. 			$template->data['logo'] = 'cid:' . md5(basename($this->config->get('config_logo')));		

    234. 

  234. 			$template->data['store_name'] = $order_info['store_name'];

    235. 

  235. 			$template->data['store_url'] = $order_info['store_url'];

    236. 

  236. 			$template->data['customer_id'] = $order_info['customer_id'];

    237. 

  237. 			$template->data['link'] = $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id;

    238. 

  238. 			

    239. 

  239. 			if ($order_download_query->num_rows) {

    240. 

  240. 				$template->data['download'] = $order_info['store_url'] . 'index.php?route=account/download';

    241. 

  241. 			} else {

    242. 

  242. 				$template->data['download'] = '';

    243. 

  243. 			}

    244. 

  244. 			

    245. 

  245. 			$template->data['order_id'] = $order_id;

    246. 

  246. 			$template->data['date_added'] = date($language->get('date_format_short'), strtotime($order_info['date_added']));    	

    247. 

  247. 			$template->data['payment_method'] = $order_info['payment_method'];

    248. 

  248. 			$template->data['shipping_method'] = $order_info['shipping_method'];

    249. 

  249. 			$template->data['email'] = $order_info['email'];

    250. 

  250. 			$template->data['telephone'] = $order_info['telephone'];

    251. 

  251. 			$template->data['ip'] = $order_info['ip'];

    252. 

  252. 			

    253. 

  253. 			if ($comment && $notify) {

    254. 

  254. 				$template->data['comment'] = nl2br($comment);

    255. 

  255. 			} else {

    256. 

  256. 				$template->data['comment'] = '';

    257. 

  257. 			}

    258. 

  258. 									

    259. 

  259. 			if ($order_info['shipping_address_format']) {

    260. 

  260. 				$format = $order_info['shipping_address_format'];

    261. 

  261. 			} else {

    262. 

  262. 				$format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}';

    263. 

  263. 			}

    264. 

  264. 			

    265. 

  265. 			$find = array(

    266. 

  266. 				'{firstname}',

    267. 

  267. 				'{lastname}',

    268. 

  268. 				'{company}',

    269. 

  269. 				'{address_1}',

    270. 

  270. 				'{address_2}',

    271. 

  271. 				'{city}',

    272. 

  272. 				'{postcode}',

    273. 

  273. 				'{zone}',

    274. 

  274. 				'{zone_code}',

    275. 

  275. 				'{country}'

    276. 

  276. 			);

    277. 

  277. 		

    278. 

  278. 			$replace = array(

    279. 

  279. 				'firstname' => $order_info['shipping_firstname'],

    280. 

  280. 				'lastname'  => $order_info['shipping_lastname'],

    281. 

  281. 				'company'   => $order_info['shipping_company'],

    282. 

  282. 				'address_1' => $order_info['shipping_address_1'],

    283. 

  283. 				'address_2' => $order_info['shipping_address_2'],

    284. 

  284. 				'city'      => $order_info['shipping_city'],

    285. 

  285. 				'postcode'  => $order_info['shipping_postcode'],

    286. 

  286. 				'zone'      => $order_info['shipping_zone'],

    287. 

  287. 				'zone_code' => $order_info['shipping_zone_code'],

    288. 

  288. 				'country'   => $order_info['shipping_country']  

    289. 

  289. 			);

    290. 

  290. 		

    291. 

  291. 			$template->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))));

    292. 

  292. 

    293. 

  293. 			if ($order_info['payment_address_format']) {

    294. 

  294. 				$format = $order_info['payment_address_format'];

    295. 

  295. 			} else {

    296. 

  296. 				$format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}';

    297. 

  297. 			}

    298. 

  298. 			

    299. 

  299. 			$find = array(

    300. 

  300. 				'{firstname}',

    301. 

  301. 				'{lastname}',

    302. 

  302. 				'{company}',

    303. 

  303. 				'{address_1}',

    304. 

  304. 				'{address_2}',

    305. 

  305. 				'{city}',

    306. 

  306. 				'{postcode}',

    307. 

  307. 				'{zone}',

    308. 

  308. 				'{zone_code}',

    309. 

  309. 				'{country}'

    310. 

  310. 			);

    311. 

  311. 		

    312. 

  312. 			$replace = array(

    313. 

  313. 				'firstname' => $order_info['payment_firstname'],

    314. 

  314. 				'lastname'  => $order_info['payment_lastname'],

    315. 

  315. 				'company'   => $order_info['payment_company'],

    316. 

  316. 				'address_1' => $order_info['payment_address_1'],

    317. 

  317. 				'address_2' => $order_info['payment_address_2'],

    318. 

  318. 				'city'      => $order_info['payment_city'],

    319. 

  319. 				'postcode'  => $order_info['payment_postcode'],

    320. 

  320. 				'zone'      => $order_info['payment_zone'],

    321. 

  321. 				'zone_code' => $order_info['payment_zone_code'],

    322. 

  322. 				'country'   => $order_info['payment_country']  

    323. 

  323. 			);

    324. 

  324. 		

    325. 

  325. 			$template->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))));

    326. 

  326. 			

    327. 

  327. 			$template->data['products'] = array();

    328. 

  328. 				

    329. 

  329. 			foreach ($order_product_query->rows as $product) {

    330. 

  330. 				$option_data = array();

    331. 

  331. 				

    332. 

  332. 				$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'] . "'");

    333. 

  333. 				

    334. 

  334. 				foreach ($order_option_query->rows as $option) {

    335. 

  335. 					if ($option['type'] != 'file') {

    336. 

  336. 						$option_data[] = array(

    337. 

  337. 							'name'  => $option['name'],

    338. 

  338. 							'value' => (strlen($option['value']) > 20 ? substr($option['value'], 0, 20) . '..' : $option['value'])

    339. 

  339. 						);

    340. 

  340. 					} else {

    341. 

  341. 						$filename = substr($option['value'], 0, strrpos($option['value'], '.'));

    342. 

  342. 						

    343. 

  343. 						$option_data[] = array(

    344. 

  344. 							'name'  => $option['name'],

    345. 

  345. 							'value' => (strlen($filename) > 20 ? substr($filename, 0, 20) . '..' : $filename)

    346. 

  346. 						);	

    347. 

  347. 					}

    348. 

  348. 				}

    349. 

  349. 			  

    350. 

  350. 				$template->data['products'][] = array(

    351. 

  351. 					'name'     => $product['name'],

    352. 

  352. 					'model'    => $product['model'],

    353. 

  353. 					'option'   => $option_data,

    354. 

  354. 					'quantity' => $product['quantity'],

    355. 

  355. 					'price'    => $this->currency->format($product['price'], $order_info['currency_code'], $order_info['currency_value']),

    356. 

  356. 					'total'    => $this->currency->format($product['total'], $order_info['currency_code'], $order_info['currency_value'])

    357. 

  357. 				);

    358. 

  358. 			}

    359. 

  359. 	

    360. 

  360. 			$template->data['totals'] = $order_total_query->rows;

    361. 

  361. 			

    362. 

  362. 			if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/mail/order.tpl')) {

    363. 

  363. 				$html = $template->fetch($this->config->get('config_template') . '/template/mail/order.tpl');

    364. 

  364. 			} else {

    365. 

  365. 				$html = $template->fetch('default/template/mail/order.tpl');

    366. 

  366. 			}

    367. 

  367. 			

    368. 

  368. 			// Text Mail

    369. 

  369. 			$text  = sprintf($language->get('text_new_greeting'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8')) . "\n\n";

    370. 

  370. 			$text .= $language->get('text_new_order_id') . ' ' . $order_id . "\n";

    371. 

  371. 			$text .= $language->get('text_new_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n";

    372. 

  372. 			$text .= $language->get('text_new_order_status') . ' ' . $order_status . "\n\n";

    373. 

  373. 			

    374. 

  374. 			if ($comment && $notify) {

    375. 

  375. 				$text .= $language->get('text_new_instruction') . "\n\n";

    376. 

  376. 				$text .= $comment . "\n\n";

    377. 

  377. 			}

    378. 

  378. 			

    379. 

  379. 			$text .= $language->get('text_new_products') . "\n";

    380. 

  380. 			

    381. 

  381. 			foreach ($order_product_query->rows as $result) {

    382. 

  382. 				$text .= $result['quantity'] . 'x ' . $result['name'] . ' (' . $result['model'] . ') ' . html_entity_decode($this->currency->format($result['total'], $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";

    383. 

  383. 				

    384. 

  384. 				$order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . $result['order_product_id'] . "'");

    385. 

  385. 				

    386. 

  386. 				foreach ($order_option_query->rows as $option) {

    387. 

  387. 					$text .= chr(9) . '-' . $option['name'] . ' ' . (strlen($option['value']) > 20 ? substr($option['value'], 0, 20) . '..' : $option['value']) . "\n";

    388. 

  388. 				}

    389. 

  389. 			}

    390. 

  390. 			

    391. 

  391. 			$text .= "\n";

    392. 

  392. 			

    393. 

  393. 			$text .= $language->get('text_new_order_total') . "\n";

    394. 

  394. 			

    395. 

  395. 			foreach ($order_total_query->rows as $result) {

    396. 

  396. 				$text .= $result['title'] . ' ' . html_entity_decode($result['text'], ENT_NOQUOTES, 'UTF-8') . "\n";

    397. 

  397. 			}			

    398. 

  398. 			

    399. 

  399. 			$text .= "\n";

    400. 

  400. 			

    401. 

  401. 			if ($order_info['customer_id']) {

    402. 

  402. 				$text .= $language->get('text_new_link') . "\n";

    403. 

  403. 				$text .= $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id . "\n\n";

    404. 

  404. 			}

    405. 

  405. 		

    406. 

  406. 			if ($order_download_query->num_rows) {

    407. 

  407. 				$text .= $language->get('text_new_download') . "\n";

    408. 

  408. 				$text .= $order_info['store_url'] . 'index.php?route=account/download' . "\n\n";

    409. 

  409. 			}

    410. 

  410. 			

    411. 

  411. 			if ($order_info['comment']) {

    412. 

  412. 				$text .= $language->get('text_new_comment') . "\n\n";

    413. 

  413. 				$text .= $order_info['comment'] . "\n\n";

    414. 

  414. 			}

    415. 

  415. 			

    416. 

  416. 			$text .= $language->get('text_new_footer') . "\n\n";

    417. 

  417. 		

    418. 

  418. 			$mail = new Mail(); 

    419. 

  419. 			$mail->protocol = $this->config->get('config_mail_protocol');

    420. 

  420. 			$mail->parameter = $this->config->get('config_mail_parameter');

    421. 

  421. 			$mail->hostname = $this->config->get('config_smtp_host');

    422. 

  422. 			$mail->username = $this->config->get('config_smtp_username');

    423. 

  423. 			$mail->password = $this->config->get('config_smtp_password');

    424. 

  424. 			$mail->port = $this->config->get('config_smtp_port');

    425. 

  425. 			$mail->timeout = $this->config->get('config_smtp_timeout');			

    426. 

  426. 			$mail->setTo($order_info['email']);

    427. 

  427. 			$mail->setFrom($this->config->get('config_email'));

    428. 

  428. 			$mail->setSender($order_info['store_name']);

    429. 

  429. 			$mail->setSubject($subject);

    430. 

  430. 			$mail->setHtml($html);

    431. 

  431. 			$mail->setText(html_entity_decode($text, ENT_QUOTES, 'UTF-8'));

    432. 

  432. 			$mail->addAttachment(DIR_IMAGE . $this->config->get('config_logo'), md5(basename($this->config->get('config_logo'))));

    433. 

  433. 			$mail->send();

    434. 

  434. 

    435. 

  435. 			// Admin Alert Mail

    436. 

  436. 			if ($this->config->get('config_alert_mail')) {

    437. 

  437. 				$subject = sprintf($language->get('text_new_subject'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'), $order_id);

    438. 

  438. 				

    439. 

  439. 				// Text 

    440. 

  440. 				$text  = $language->get('text_new_received') . "\n\n";

    441. 

  441. 				$text .= $language->get('text_new_order_id') . ' ' . $order_id . "\n";

    442. 

  442. 				$text .= $language->get('text_new_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n";

    443. 

  443. 				$text .= $language->get('text_new_order_status') . ' ' . $order_status . "\n\n";

    444. 

  444. 				$text .= $language->get('text_new_products') . "\n";

    445. 

  445. 				

    446. 

  446. 				foreach ($order_product_query->rows as $result) {

    447. 

  447. 					$text .= $result['quantity'] . 'x ' . $result['name'] . ' (' . $result['model'] . ') ' . html_entity_decode($this->currency->format($result['total'], $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8') . "\n";

    448. 

  448. 					

    449. 

  449. 					$order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . $result['order_product_id'] . "'");

    450. 

  450. 					

    451. 

  451. 					foreach ($order_option_query->rows as $option) {

    452. 

  452. 						$text .= chr(9) . '-' . $option['name'] . ' ' . (strlen($option['value']) > 20 ? substr($option['value'], 0, 20) . '..' : $option['value']) . "\n";

    453. 

  453. 					}

    454. 

  454. 				}

    455. 

  455. 				

    456. 

  456. 				$text .= "\n";

    457. 

  457. 

    458. 

  458. 				$text .= $language->get('text_new_order_total') . "\n";

    459. 

  459. 				

    460. 

  460. 				foreach ($order_total_query->rows as $result) {

    461. 

  461. 					$text .= $result['title'] . ' ' . html_entity_decode($result['text'], ENT_NOQUOTES, 'UTF-8') . "\n";

    462. 

  462. 				}			

    463. 

  463. 				

    464. 

  464. 				$text .= "\n";

    465. 

  465. 				

    466. 

  466. 				if ($order_info['comment'] != '') {

    467. 

  467. 					$comment = ($order_info['comment'] .  "\n\n" . $comment);

    468. 

  468. 				}

    469. 

  469. 				

    470. 

  470. 				if ($comment) {

    471. 

  471. 					$text .= $language->get('text_new_comment') . "\n\n";

    472. 

  472. 					$text .= $comment . "\n\n";

    473. 

  473. 				}

    474. 

  474. 			

    475. 

  475. 				$mail = new Mail(); 

    476. 

  476. 				$mail->protocol = $this->config->get('config_mail_protocol');

    477. 

  477. 				$mail->parameter = $this->config->get('config_mail_parameter');

    478. 

  478. 				$mail->hostname = $this->config->get('config_smtp_host');

    479. 

  479. 				$mail->username = $this->config->get('config_smtp_username');

    480. 

  480. 				$mail->password = $this->config->get('config_smtp_password');

    481. 

  481. 				$mail->port = $this->config->get('config_smtp_port');

    482. 

  482. 				$mail->timeout = $this->config->get('config_smtp_timeout');

    483. 

  483. 				$mail->setTo($this->config->get('config_email'));

    484. 

  484. 				$mail->setFrom($this->config->get('config_email'));

    485. 

  485. 				$mail->setSender($order_info['store_name']);

    486. 

  486. 				$mail->setSubject($subject);

    487. 

  487. 				$mail->setText($text);

    488. 

  488. 				$mail->send();

    489. 

  489. 				

    490. 

  490. 				// Send to additional alert emails

    491. 

  491. 				$emails = explode(',', $this->config->get('config_alert_emails'));

    492. 

  492. 				

    493. 

  493. 				foreach ($emails as $email) {

    494. 

  494. 					if ($email && preg_match('/^[^\@]+@.*\.[a-z]{2,6}$/i', $email)) {

    495. 

  495. 						$mail->setTo($email);

    496. 

  496. 						$mail->send();

    497. 

  497. 					}

    498. 

  498. 				}				

    499. 

  499. 			}		

    500. 

  500. 		}

    501. 

  501. 	}

    502. 

  502. 	

    503. 

  503. 	public function update($order_id, $order_status_id, $comment = '', $notify = false) {

    504. 

  504. 		$order_info = $this->getOrder($order_id);

    505. 

  505. 

    506. 

  506. 		if ($order_info && $order_info['order_status_id']) {

    507. 

  507. 			$this->db->query("UPDATE `" . DB_PREFIX . "order` SET order_status_id = '" . (int)$order_status_id . "', date_modified = NOW() WHERE order_id = '" . (int)$order_id . "'");

    508. 

  508. 		

    509. 

  509. 			$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()");

    510. 

  510. 	

    511. 

  511. 			// Send out any gift voucher mails

    512. 

  512. 			if ($this->config->get('config_complete_status_id') == $order_status_id) {

    513. 

  513. 				$this->load->model('checkout/voucher');

    514. 

  514. 	

    515. 

  515. 				$this->model_checkout_voucher->confirm($order_id);

    516. 

  516. 			}	

    517. 

  517. 	

    518. 

  518. 			if ($notify) {

    519. 

  519. 				$language = new Language($order_info['language_directory']);

    520. 

  520. 				$language->load($order_info['language_filename']);

    521. 

  521. 				$language->load('mail/order');

    522. 

  522. 			

    523. 

  523. 				$subject = sprintf($language->get('text_update_subject'), html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'), $order_id);

    524. 

  524. 	

    525. 

  525. 				$message  = $language->get('text_update_order') . ' ' . $order_id . "\n";

    526. 

  526. 				$message .= $language->get('text_update_date_added') . ' ' . date($language->get('date_format_short'), strtotime($order_info['date_added'])) . "\n\n";

    527. 

  527. 				

    528. 

  528. 				$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'] . "'");

    529. 

  529. 				

    530. 

  530. 				if ($order_status_query->num_rows) {

    531. 

  531. 					$message .= $language->get('text_update_order_status') . "\n\n";

    532. 

  532. 					$message .= $order_status_query->row['name'] . "\n\n";					

    533. 

  533. 				}

    534. 

  534. 				

    535. 

  535. 				if ($order_info['customer_id']) {

    536. 

  536. 					$message .= $language->get('text_update_link') . "\n";

    537. 

  537. 					$message .= $order_info['store_url'] . 'index.php?route=account/order/info&order_id=' . $order_id . "\n\n";

    538. 

  538. 				}

    539. 

  539. 				

    540. 

  540. 				if ($comment) { 

    541. 

  541. 					$message .= $language->get('text_update_comment') . "\n\n";

    542. 

  542. 					$message .= $comment . "\n\n";

    543. 

  543. 				}

    544. 

  544. 					

    545. 

  545. 				$message .= $language->get('text_update_footer');

    546. 

  546. 

    547. 

  547. 				$mail = new Mail();

    548. 

  548. 				$mail->protocol = $this->config->get('config_mail_protocol');

    549. 

  549. 				$mail->parameter = $this->config->get('config_mail_parameter');

    550. 

  550. 				$mail->hostname = $this->config->get('config_smtp_host');

    551. 

  551. 				$mail->username = $this->config->get('config_smtp_username');

    552. 

  552. 				$mail->password = $this->config->get('config_smtp_password');

    553. 

  553. 				$mail->port = $this->config->get('config_smtp_port');

    554. 

  554. 				$mail->timeout = $this->config->get('config_smtp_timeout');				

    555. 

  555. 				$mail->setTo($order_info['email']);

    556. 

  556. 				$mail->setFrom($this->config->get('config_email'));

    557. 

  557. 				$mail->setSender($order_info['store_name']);

    558. 

  558. 				$mail->setSubject($subject);

    559. 

  559. 				$mail->setText(html_entity_decode($message, ENT_QUOTES, 'UTF-8'));

    560. 

  560. 				$mail->send();

    561. 

  561. 			}

    562. 

  562. 		}

    563. 

  563. 	}

    564. 

  564. }

    565. 

  565. ?>
    566.