<?php
namespace Opencart\Catalog\Controller\Mail;
/**
 * Class Subscription
 *
 * @package Opencart\Catalog\Controller\Mail
 */
class Subscription extends \Opencart\System\Engine\Controller {
	/**
	 * Index
	 *
	 * @param string            $route
	 * @param array<int, mixed> $args
	 * @param array<mixed>      $output
	 *
	 * @return void
	 */
	public function index(string &$route, array &$args, &$output): void {
		if (isset($args[0])) {
			$subscription_id = $args[0];
		} else {
			$subscription_id = 0;
		}

		if (isset($args[1]['subscription'])) {
			$subscription = $args[1]['subscription'];
		} else {
			$subscription = [];
		}

		if (isset($args[2])) {
			$comment = $args[2];
		} else {
			$comment = '';
		}

		if (isset($args[3])) {
			$notify = $args[3];
		} else {
			$notify = '';
		}
		/*
		$subscription['order_product_id']
		$subscription['customer_id']
		$subscription['order_id']
		$subscription['subscription_plan_id']
		$subscription['customer_payment_id'],
		$subscription['name']
		$subscription['description']
		$subscription['trial_price']
		$subscription['trial_frequency']
		$subscription['trial_cycle']
		$subscription['trial_duration']
		$subscription['trial_remaining']
		$subscription['trial_status']
		$subscription['price']
		$subscription['frequency']
		$subscription['cycle']
		$subscription['duration']
		$subscription['remaining']
		$subscription['date_next']
		$subscription['status']


		if ($subscription['trial_duration'] && $subscription['trial_remaining']) {
			$date_next = date('Y-m-d', strtotime('+' . $subscription['trial_cycle'] . ' ' . $subscription['trial_frequency']));
		} elseif ($subscription['duration'] && $subscription['remaining']) {
			$date_next = date('Y-m-d', strtotime('+' . $subscription['cycle'] . ' ' . $subscription['frequency']));
		}

		// Subscription
		$this->load->model('account/subscription');

		$filter_data = [
			'filter_subscription_id' => $subscription_id,
			'filter_date_next' => $date_next,
			'filter_subscription_status_id' => $this->config->get('config_subscription_active_status_id'),
			'start' => 0,
			'limit' => 1
		];

		$subscriptions = $this->model_account_subscription->getSubscriptions($filter_data);

		if ($subscriptions) {
			$this->load->language('mail/subscription');

			foreach ($subscriptions as $value) {
				// Only match the latest order ID of the same customer ID
				// since new subscriptions cannot be re-added with the same
				// order ID; only as a new order ID added by an extension
				if ($value['customer_id'] == $subscription['customer_id'] && $value['order_id'] == $subscription['order_id']) {
					// Subscription
					$this->load->model('checkout/subscription');

					$payment_method = $this->model_checkout_subscription->getTotalSubscriptions(['filter_customer_id' => $value['customer_id']]);

					if ($payment_method) {
						$subscription_order_product = $this->model_checkout_subscription->getSubscriptionByOrderProductId($value['order_product_id']);

						if ($subscription_order_product) {
							// Order
							$this->load->model('account/order');

							// Order Products
							$order_product = $this->model_account_order->getProduct($value['order_id'], $value['order_product_id']);

							if ($order_product && $order_product['order_product_id'] == $subscription['order_product_id']) {
								$products = $this->cart->getProducts();

								$description = '';

								foreach ($products as $product) {
									if ($product['product_id'] == $order_product['product_id']) {


										if ($product['subscription']['trial_status']) {
											$trial_price = $this->currency->format($this->tax->calculate($value['trial_price'], $product['tax_class_id'], $this->config->get('config_tax')), $this->config->get('config_currency'));
											$trial_cycle = $value['trial_cycle'];
											$trial_frequency = $this->language->get('text_' . $value['trial_frequency']);
											$trial_duration = $value['trial_duration'];

											$description .= sprintf($this->language->get('text_subscription_trial'), $trial_price, $trial_cycle, $trial_frequency, $trial_duration);
										}

										$price = $this->currency->format($this->tax->calculate($value['price'], $product['tax_class_id'], $this->config->get('config_tax')), $this->config->get('config_currency'));
										$cycle = $value['cycle'];
										$frequency = $this->language->get('text_' . $value['frequency']);
										$duration = $value['duration'];

										if ($duration) {
											$description .= sprintf($this->language->get('text_subscription_duration'), $price, $cycle, $frequency, $duration);
										} else {
											$description .= sprintf($this->language->get('text_subscription_cancel'), $price, $cycle, $frequency);
										}
									}
								}

								// Order
								$this->load->model('checkout/order');

								$order_info = $this->model_checkout_order->getOrder($value['order_id']);

								if ($order_info) {
									// Store
									$this->load->model('setting/store');

									// Setting
									$this->load->model('setting/setting');

									$store_info = $this->model_setting_store->getStore($order_info['store_id']);

									if ($store_info) {
										$store_logo = html_entity_decode($this->model_setting_setting->getValue('config_logo', $store_info['store_id']), ENT_QUOTES, 'UTF-8');
										$store_name = html_entity_decode($store_info['name'], ENT_QUOTES, 'UTF-8');

										$store_url = $store_info['url'];
									} else {
										$store_logo = html_entity_decode($this->config->get('config_logo'), ENT_QUOTES, 'UTF-8');
										$store_name = html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8');

										$store_url = HTTP_SERVER;
									}

									// Subscription Status
									$subscription_status_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "subscription_status` WHERE `subscription_status_id` = '" . (int)$value['subscription_status_id'] . "' AND `language_id` = '" . (int)$order_info['language_id'] . "'");

									if ($subscription_status_query->num_rows) {
										$data['order_status'] = $subscription_status_query->row['name'];
									} else {
										$data['order_status'] = '';
									}

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

									$language_info = $this->model_localisation_language->getLanguage($order_info['language_id']);

									// We need to compare both language IDs as they both need to match.
									if ($language_info) {
										$language_code = $language_info['code'];
									} else {
										$language_code = $this->config->get('config_language');
									}

									// Load the language for any mails using a different country code and prefixing it so it does not pollute the main data pool.
									$this->load->language('default', 'mail', $language_code);
									$this->load->language('mail/order_add', 'mail', $language_code);

									// Add language vars to the template folder
									$results = $this->language->all('mail');

									foreach ($results as $key => $value) {
										$data[$key] = $value;
									}

									$subject = sprintf($this->language->get('mail_text_subject'), $store_name, $order_info['order_id']);

									// Image
									$this->load->model('tool/image');

									if (is_file(DIR_IMAGE . $store_logo)) {
										$data['logo'] = $store_url . 'image/' . $store_logo;
									} else {
										$data['logo'] = '';
									}

									$data['title'] = sprintf($this->language->get('mail_text_subject'), $store_name, $order_info['order_id']);

									$data['text_greeting'] = sprintf($this->language->get('mail_text_greeting'), $order_info['store_name']);

									$data['store'] = $store_name;
									$data['store_url'] = $order_info['store_url'];

									$data['customer_id'] = $order_info['customer_id'];
									$data['link'] = $order_info['store_url'] . 'index.php?route=account/subscription.info&subscription_id=' . $subscription_id;

									$data['order_id'] = $order_info['order_id'];
									$data['date_added'] = date($this->language->get('date_format_short'), strtotime($value['date_added']));
									$data['payment_method'] = $order_info['payment_method'];
									$data['email'] = $order_info['email'];
									$data['telephone'] = $order_info['telephone'];
									$data['ip'] = $order_info['ip'];

									// Order Totals
									$data['totals'] = [];

									$order_totals = $this->model_checkout_order->getTotals($subscription['order_id']);

									foreach ($order_totals as $order_total) {
										$data['totals'][] = [
											'title' => $order_total['title'],
											'text' => $this->currency->format($order_total['value'], $order_info['currency_code'], $order_info['currency_value']),
										];
									}

									// Subscription
									if ($comment && $notify) {
										$data['comment'] = nl2br($comment);
									} else {
										$data['comment'] = '';
									}

									$data['description'] = $value['description'];

									// Order Products
									$data['name'] = $order_product['name'];
									$data['quantity'] = $order_product['quantity'];
									$data['price'] = $this->currency->format($order_product['price'], $order_info['currency_code'], $order_info['currency_value']);
									$data['total'] = $this->currency->format($order_product['total'], $order_info['currency_code'], $order_info['currency_value']);

									$data['order'] = $this->url->link('account/order.info', 'order_id=' . $value['order_id']);
									$data['product'] = $this->url->link('product/product', 'product_id=' . $value['product_id']);

									// Settings
									$from = $this->model_setting_setting->getValue('config_email', $order_info['store_id']);

									if (!$from) {
										$from = $this->config->get('config_email');
									}

									if ($this->config->get('payment_' . $payment_info['code'] . '_status')) {
										// Payment Method
										$this->load->model('extension/payment/' . $payment_info['code']);

										// Promotion
										if (isset($this->{'model_extension_payment_' . $payment_info['code']}->promotion)) {
											$subscription_status_id = $this->{'model_extension_payment_' . $payment_info['code']}->promotion($value['subscription_id']);

											if ($store_info) {
												$config_subscription_active_status_id = $this->model_setting_setting->getValue('config_subscription_active_status_id', $store_info['store_id']);
											} else {
												$config_subscription_active_status_id = $this->config->get('config_subscription_active_status_id');
											}

											if ($config_subscription_active_status_id == $subscription_status_id) {
												$subscription_info = $this->model_account_subscription->getSubscription($value['subscription_id']);

												// Validate the latest subscription values with the ones edited
												// by promotional extensions
												if ($subscription_info && $subscription_info['status'] && $subscription_info['customer_id'] == $value['customer_id'] && $subscription_info['order_id'] == $value['order_id'] && $subscription_info['order_product_id'] == $value['order_product_id']) {
													// Customer
													$this->load->model('account/customer');

													$customer_info = $this->model_account_customer->getCustomer($subscription_info['customer_id']);

													$frequencies = [
														'day',
														'week',
														'semi_month',
														'month',
														'year'
													];

													// We need to validate frequencies in compliance of the admin subscription plans
													// as with the use of the APIs
													if ($customer_info && (int)$subscription_info['cycle'] >= 0 && $subscription_info['cycle'] == $value['cycle'] && in_array($subscription_info['frequency'], $frequencies)) {
														if ($subscription_info['frequency'] == 'semi_month') {
															$period = strtotime("2 weeks");
														} else {
															$period = strtotime($subscription_info['cycle'] . ' ' . $subscription_info['frequency']);
														}

														// New customer once the trial period has ended
														$customer_period = strtotime($customer_info['date_added']);

														$trial_period = 0;
														$validate_trial = 0;

														// Trial
														if ($subscription_info['trial_cycle'] && $subscription_info['trial_frequency'] && $subscription_info['trial_cycle'] == $value['trial_cycle'] && $subscription_info['trial_frequency'] == $value['trial_frequency']) {
															if ($subscription_info['trial_frequency'] == 'semi_month') {
																$trial_period = strtotime("2 weeks");
															} else {
																$trial_period = strtotime($subscription_info['trial_cycle'] . ' ' . $subscription_info['trial_frequency']);
															}

															$trial_period = ($trial_period - $customer_period);
															$validate_trial = round($trial_period / (60 * 60 * 24));
														}

														// Calculates the remaining days between the subscription
														// promotional period and the date added period
														$period = ($period - $customer_period);

														// Calculate remaining period of each features
														$period = round($period / (60 * 60 * 24));

														// Promotional features description must be identical
														// until the time period has exceeded. Therefore, the current
														// period must be matched as well
														if (($period == 0 && ($validate_trial > 0 || !$validate_trial)) && $value['description'] == $description && $subscription_info['subscription_plan_id'] == $value['subscription_plan_id']) {
															// Product
															$this->load->model('catalog/product');

															$product_subscription_info = $this->model_catalog_product->getSubscription($order_product['product_id'], $subscription_info['subscription_plan_id']);

															if ($product_subscription_info) {
																// For the next billing cycle
																$this->model_account_subscription->addTransaction($value['subscription_id'], $value['order_id'], $this->language->get('text_promotion'), $subscription_info['amount'], $subscription_info['type'], $subscription_info['payment_method'], $subscription_info['payment_code']);
															}
														}
													}
												}
											}
										}
									}

									// Mail
									if ($this->config->get('config_mail_engine')) {
										$mail_option = [
											'parameter' => $this->config->get('config_mail_parameter'),
											'smtp_hostname' => $this->config->get('config_mail_smtp_hostname'),
											'smtp_username' => $this->config->get('config_mail_smtp_username'),
											'smtp_password' => html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8'),
											'smtp_port' => $this->config->get('config_mail_smtp_port'),
											'smtp_timeout' => $this->config->get('config_mail_smtp_timeout')
										];

										$mail = new \Opencart\System\Library\Mail($this->config->get('config_mail_engine'), $mail_option);
										$mail->setTo($order_info['email']);
										$mail->setFrom($from);
										$mail->setSender($store_name);
										$mail->setSubject($subject);
										$mail->setHtml($this->load->view('mail/subscription', $data));
										$mail->send();
									}
								}
							}
						}
					}
				}
			}
		}
		*/
	}

	// catalog/model/checkout/order/addHistory/before

	/**
	 * Alert
	 *
	 * @param string            $route
	 * @param array<int, mixed> $args
	 *
	 * @throws \Exception
	 *
	 * @return void
	 */
	public function alert(string &$route, array &$args): void {
		if (isset($args[0])) {
			$order_id = $args[0];
		} else {
			$order_id = 0;
		}

		if (isset($args[1])) {
			$order_status_id = $args[1];
		} else {
			$order_status_id = 0;
		}

		if (isset($args[2])) {
			$comment = $args[2];
		} else {
			$comment = '';
		}

		if (isset($args[3])) {
			$notify = $args[3];
		} else {
			$notify = '';
		}

		$order_info = $this->model_checkout_order->getOrder($order_id);

		if ($order_info && !$order_info['order_status_id'] && $order_status_id && in_array('order', (array)$this->config->get('config_mail_alert'))) {
			$this->load->language('mail/order_alert');

			$subject = html_entity_decode(sprintf($this->language->get('text_subject'), $this->config->get('config_name'), $order_info['order_id']), ENT_QUOTES, 'UTF-8');

			$data['order_id'] = $order_info['order_id'];
			$data['date_added'] = date($this->language->get('date_format_short'), strtotime($order_info['date_added']));

			$order_status_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_status` WHERE `order_status_id` = '" . (int)$order_status_id . "' AND `language_id` = '" . (int)$this->config->get('config_language_id') . "'");

			if ($order_status_query->num_rows) {
				$data['order_status'] = $order_status_query->row['name'];
			} else {
				$data['order_status'] = '';
			}

			// Upload
			$this->load->model('tool/upload');

			$data['products'] = [];

			$order_products = $this->model_checkout_order->getProducts($order_id);

			foreach ($order_products as $order_product) {
				$option_data = [];

				$order_options = $this->model_checkout_order->getOptions($order_info['order_id'], $order_product['order_product_id']);

				foreach ($order_options as $order_option) {
					if ($order_option['type'] != 'file') {
						$value = $order_option['value'];
					} else {
						$upload_info = $this->model_tool_upload->getUploadByCode($order_option['value']);

						if ($upload_info) {
							$value = $upload_info['name'];
						} else {
							$value = '';
						}
					}

					$option_data[] = ['value' => (oc_strlen($value) > 20 ? oc_substr($value, 0, 20) . '..' : $value)] + $order_option;
				}

				$description = '';

				// Subscription
				$this->load->model('checkout/subscription');

				$subscription_info = $this->model_checkout_order->getSubscription($order_info['order_id'], $order_product['order_product_id']);

				if ($subscription_info) {
					if ($subscription_info['trial_status']) {
						$trial_price = $this->currency->format($subscription_info['trial_price'] + ($this->config->get('config_tax') ? $subscription_info['trial_tax'] : 0), $this->session->data['currency']);
						$trial_cycle = $subscription_info['trial_cycle'];
						$trial_frequency = $this->language->get('text_' . $subscription_info['trial_frequency']);
						$trial_duration = $subscription_info['trial_duration'];

						$description .= sprintf($this->language->get('text_subscription_trial'), $trial_price, $trial_cycle, $trial_frequency, $trial_duration);
					}

					$price = $this->currency->format($subscription_info['price'] + ($this->config->get('config_tax') ? $subscription_info['tax'] : 0), $this->session->data['currency']);
					$cycle = $subscription_info['cycle'];
					$frequency = $this->language->get('text_' . $subscription_info['frequency']);
					$duration = $subscription_info['duration'];

					if ($duration) {
						$description .= sprintf($this->language->get('text_subscription_duration'), $price, $cycle, $frequency, $duration);
					} else {
						$description .= sprintf($this->language->get('text_subscription_cancel'), $price, $cycle, $frequency);
					}
				}

				$data['products'][] = [
					'option'       => $option_data,
					'subscription' => $description,
					'total'        => html_entity_decode($this->currency->format($order_product['total'] + ($this->config->get('config_tax') ? $order_product['tax'] * $order_product['quantity'] : 0), $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8')
				] + $order_product;
			}

			$data['totals'] = [];

			$order_totals = $this->model_checkout_order->getTotals($order_id);

			foreach ($order_totals as $order_total) {
				$data['totals'][] = ['value' => html_entity_decode($this->currency->format($order_total['value'], $order_info['currency_code'], $order_info['currency_value']), ENT_NOQUOTES, 'UTF-8')] + $order_total;
			}

			$data['comment'] = nl2br($order_info['comment']);

			$data['store'] = html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8');
			$data['store_url'] = $order_info['store_url'];

			if ($this->config->get('config_mail_engine')) {
				$mail_option = [
					'parameter'     => $this->config->get('config_mail_parameter'),
					'smtp_hostname' => $this->config->get('config_mail_smtp_hostname'),
					'smtp_username' => $this->config->get('config_mail_smtp_username'),
					'smtp_password' => html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8'),
					'smtp_port'     => $this->config->get('config_mail_smtp_port'),
					'smtp_timeout'  => $this->config->get('config_mail_smtp_timeout')
				];

				$mail = new \Opencart\System\Library\Mail($this->config->get('config_mail_engine'), $mail_option);
				$mail->setTo($this->config->get('config_email'));
				$mail->setFrom($this->config->get('config_email'));
				$mail->setSender(html_entity_decode($order_info['store_name'], ENT_QUOTES, 'UTF-8'));
				$mail->setSubject($subject);
				$mail->setHtml($this->load->view('mail/order_alert', $data));
				$mail->send();

				// Send to additional alert emails
				$emails = explode(',', (string)$this->config->get('config_mail_alert_email'));

				foreach ($emails as $email) {
					if ($email && filter_var($email, FILTER_VALIDATE_EMAIL)) {
						$mail->setTo(trim($email));
						$mail->send();
					}
				}
			}
		}
	}
}
