<?php
/**
 * @package DJ-Catalog2
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 */

// No direct access.
defined('_JEXEC') or die;
use Joomla\Registry\Registry;
use Joomla\CMS\Factory;
use Joomla\CMS\Component\ComponentHelper;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\CMS\Table\Table;
use Joomla\CMS\MVC\Model\FormModel;
jimport('joomla.application.component.modelform');

class Djcatalog2ModelQuery extends FormModel
{
	protected $_item = null;

	protected $_context = 'com_djcatalog2.query';

	public function __construct($config = array()) {
		parent::__construct($config);
	}

	protected function populateState()
	{
		$table = $this->getTable();
		$key = 'qid';

		// Get the pk of the record from the request.
		$pk = Factory::getApplication()->input->getInt($key);
		$this->setState($this->getName() . '.id', $pk);

		// Load the parameters.
		$value = ComponentHelper::getParams('com_djcatalog2');
		$this->setState('params', $value);
	}

	public function getTable($type = 'Quotes', $prefix = 'Djcatalog2Table', $config = array())
	{
		return Table::getInstance($type, $prefix, $config);
	}

	public function getItem($pk = null)
	{
		$pk = (!empty($pk)) ? $pk : (int) $this->getState($this->getName() . '.id');
		$table = $this->getTable();

		if ($pk > 0)
		{
			// Attempt to load the row.
			$return = $table->load($pk);

			// Check for a table object error.
			if ($return === false && $table->getError())
			{
				$this->setError($table->getError());
				return false;
			}
		}

		// Convert to the JObject before adding other data.
		$properties = $table->getProperties(1);

		$item = Joomla\Utilities\ArrayHelper::toObject($properties, 'JObject');

		if (!is_array($item->items)) {
			if (isset($item->id)) {
				$this->_db->setQuery('SELECT * FROM #__djc2_quote_items WHERE quote_id=\''.$item->id.'\'');
				$item->items = $this->_db->loadObjectList();
			} else {
				$item->items = array();
			}
		}

		if (property_exists($item, 'params'))
		{
			$registry = new Registry();
			$registry->loadString($item->params);
			$item->params = $registry->toArray();
		}

		$name = array();
		if (!empty($item->firstname)) {
			$name[] = $item->firstname;
		}
		if (!empty($item->lastname)) {
			$name[] = $item->lastname;
		}

		$item->_name = (count($name) > 0) ? implode(' ', $name) : '';

		return $item;
	}

	public function getForm($data = array(), $loadData = true)
	{
		// Get the form.
		$form = $this->loadForm('com_djcatalog2.query', Djcatalog2HelperUser::getUserFormXML('com_djcatalog2.query', $data), array('control' => 'jform', 'load_data' => $loadData));
		if (empty($form)) {
			return false;
		}


		return $form;
	}

	protected function preprocessForm(Joomla\CMS\Form\Form $form, $data, $group = 'content') {
		if (!($form instanceof JForm))
		{
			$this->setError('JERROR_NOT_A_FORM');
			return false;
		}

		$app = Factory::getApplication();
		$params = ComponentHelper::getParams('com_djcatalog2');
		$user = Factory::getUser();
		$language = Factory::getApplication()->getLanguage();


		$form->removeGroup('djcatalog2delivery');
		$form->removeGroup('djcatalog2orderdetails');

		$form->removeField('user_id', 'djcatalog2profile');
		//$form->removeField('client_type', 'djcatalog2profile');
		//$form->removeField('customer_group_id', 'djcatalog2profile');

		$plugin = Factory::getApplication()->getParams()->get('cart_query_captcha', Factory::getConfig()->get('captcha'));

		if ($user->guest == false || ($plugin === 0 || $plugin === '0' || $plugin === '' || $plugin === null)) {
			$form->removeField('captcha', 'djcatalog2captcha');
		} else {
			Factory::getApplication()->getParams()->set('captcha', $plugin);
		}

		$group = 'djcatalog2profile';

		if ($user->guest == false) {
			$form->setValue('email', $group, $user->email);
			$form->setFieldAttribute('email', 'readonly', 'true', $group);
			$form->setFieldAttribute('email', 'class', $form->getFieldAttribute('email', 'class').' readonly', $group);
		}

		//$form->removeField('client_type', 'djcatalog2profile');
		$form->removeField('customer_group_id', 'djcatalog2profile');

		if ($params->get('cart_queryfield_customer_note', '0') == '0') {
			$form->removeField('customer_note', 'djcatalog2message');
		} else {
			if ($params->get('cart_queryfield_customer_note', '0') == '2') {
				$form->setFieldAttribute('customer_note', 'required', 'required', $group);
				$form->setFieldAttribute('customer_note', 'class', $form->getFieldAttribute('customer_note', 'class', '', 'djcatalog2message').' required', 'djcatalog2message');
			} else {
				$form->setFieldAttribute('customer_note', 'required', false, 'djcatalog2message');

				$class = $form->getFieldAttribute('customer_note', 'class', '', 'djcatalog2message');
				$class = str_replace('required', '', $class);

				$form->setFieldAttribute('customer_note', 'class', $class, 'djcatalog2message');
			}
		}

		/*
		$fields = array('firstname', 'lastname', 'company', 'position', 'address', 'city', 'postcode', 'country_id', 'state_id', 'vat_id', 'phone', 'fax', 'www', 'customer_note');
		//$delivery = array('company', 'address', 'city', 'postcode', 'country_id', 'phone');
		$message = array('customer_note');
		
		$formFields = array(
				'djcatalog2profile' => $fields,
				//'djcatalog2delivery' => $delivery,
				'djcatalog2message' => $message
		);
		
		foreach ($formFields as $group => $fields) {
			$paramSfx = '';
			switch ($group) {
				case 'djcatalog2profile' :
				case 'djcatalog2message' : $paramSfx = 'queryfield'; break;
		
				case 'djcatalog2delivery' : $paramSfx = 'deliveryfield'; break;
				default: break;
			}
			
			foreach ($fields as $field) {
				// in case config is broken - using defaults from XML file
				if ($params->get('cart_'.$paramSfx.'_'.$field, false) === false) {
					continue;
				}
					
				if ($params->get('cart_'.$paramSfx.'_'.$field, '0') == '0') {
					$form->removeField($field, $group);
				} else {
					if ($params->get('cart_'.$paramSfx.'_'.$field, '0') == '2') {
						$form->setFieldAttribute($field, 'required', 'required', $group);
						$form->setFieldAttribute($field, 'class', $form->getFieldAttribute($field, 'class').' required', $group);
					} else {
						$form->setFieldAttribute($field, 'required', false, $group);
							
						$class = $form->getFieldAttribute($field, 'class', '', $group);
						$class = str_replace('required', '', $class);
							
						$form->setFieldAttribute($field, 'class', $class, $group);
					}
				}
			}
		}
		
		$tos_field = $params->get('cart_tos_field', true);
		if (!$tos_field) {
			$form->removeField('tos', 'djcatalog2statements');
		} else {
			$tos_link = $params->get('cart_tos_link', '');
			$tos_link = Uri::isInternal($tos_link) ? Route::_($tos_link) : $tos_link;
			if ($tos_link) {
				$form->setFieldAttribute('tos', 'label', Text::sprintf('COM_DJCATALOG2_TOS_WITH_LINK', $tos_link), 'djcatalog2statements');
			}
		}
		
		$gdpr_policy = $params->get('cart_gdpr_policy');
		if ($gdpr_policy) {
			$policy_info = Text::sprintf('COM_DJCATALOG2_GDPR_POLICY_AGREE', $app->get('sitename'));
			if (trim((string)$params->get('cart_gdpr_policy_info')) != '') {
				$policy_info = $params->get('cart_gdpr_policy_info');
				if ($language->hasKey($policy_info)) {
					$policy_info = Text::_($policy_info);
				}
			}
			$form->setFieldAttribute('gdpr_policy', 'label', $policy_info, 'djcatalog2statements');
		} else {
			$form->removeField('gdpr_policy', 'djcatalog2statements');
		}
		
		$gdpr_agreement = $params->get('cart_gdpr_agreement');
		if ($gdpr_agreement) {
			$agreement_info = Text::sprintf('COM_DJCATALOG2_GDPR_AGREE', $app->get('sitename'));
			if (trim((string)$params->get('cart_gdpr_agreement_info')) != '') {
				$agreement_info = $params->get('cart_gdpr_agreement_info');
				if ($language->hasKey($agreement_info)) {
					$agreement_info = Text::_($agreement_info);
				}
			}
			$form->setFieldAttribute('gdpr_agreement', 'label', $agreement_info, 'djcatalog2statements');
		} else {
			$form->removeField('gdpr_agreement', 'djcatalog2statements');
		}
		
		*/
	}

	protected function loadFormData()
	{
		$userProfile = Djcatalog2HelperUser::getUserProfile();
		$data = (isset($userProfile->djcatalog2profile)) ? array('djcatalog2profile' => Joomla\Utilities\ArrayHelper::fromObject($userProfile->djcatalog2profile, true)) : array();

		$post_data = (array)Factory::getApplication()->getUserState('com_djcatalog2.query.data', array());

		if (!empty($post_data)) {
			foreach($post_data as $k=>$v) {
				$data[$k] = $v;
			}
		}

		$this->preprocessData('com_djcatalog2.query', $data);

		return $data;
	}

	protected function preprocessData($context, &$data, $group = 'content')
	{
		// Get the dispatcher and load the users plugins.
		//$dispatcher = Joomla\CMS\Factory::getApplication()->getDispatcher();
		PluginHelper::importPlugin('content');

		// Trigger the data preparation event.
		$results = Joomla\CMS\Factory::getApplication()->triggerEvent('onContentPrepareData', array($context, $data));

		// Check for errors encountered while preparing the data.
		if (count($results) > 0 && in_array(false, $results, true))
		{
			//$this->setError($dispatcher->getError());
			// TODO
			$this->setError('Dispatcher error!');

		}
	}

	protected function getReorderConditions($table = null)
	{
		$condition = array();
		return $condition;
	}

	protected function prepareTable(&$table)
	{
	}

	public function save($data)
	{

		$table = $this->getTable();

		$key = $table->getKeyName();
		$pk = (!empty($data[$key])) ? $data[$key] : (int) $this->getState($this->getName() . '.id');
		$isNew = true;

		// Allow an exception to be thrown.
		try
		{
			// Load the row if saving an existing record.
			if ($pk > 0)
			{
				$table->load($pk);
				$isNew = false;
			}

			// Bind the data.
			if (!$table->bind($data))
			{
				$this->setError($table->getError());

				return false;
			}

			// Prepare the row for saving
			$this->prepareTable($table);

			// Check the data.
			if (!$table->check())
			{
				$this->setError($table->getError());
				return false;
			}

			// Store the data.
			if (!$table->store())
			{
				$this->setError($table->getError());
				return false;
			}

			// Clean the cache.
			$this->cleanCache();

		}
		catch (Exception $e)
		{
			$this->setError($e->getMessage());

			return false;
		}

		$pkName = $table->getKeyName();

		if (isset($table->$pkName))
		{
			$this->setState($this->getName() . '.id', $table->$pkName);
		}

		$this->setState($this->getName() . '.new', $isNew);

		return true;
	}

	public function sendNewQueryEmail($data)
	{
		$app		= Factory::getApplication();
		$params 	= ComponentHelper::getParams('com_djcatalog2');
		$notifyOwners = (bool)($params->get('cart_query_notifyowners', 0) == '1');

		$user = Factory::getUser();

		$mailfrom	= $app->getCfg('mailfrom');
		$fromname	= $app->getCfg('fromname');
		$sitename	= $app->getCfg('sitename');

		$vendors = Djcatalog2Helper::getVendors($user->id);

		$contact_list = $params->get('contact_list', false);
		$recipient_list = array();
		if ($contact_list !== false) {
			$recipient_list = explode(PHP_EOL, $params->get('contact_list', ''));
		}

		$list_is_empty = true;
		foreach ($recipient_list as $r) {
			if (strpos($r, '@') !== false) {
				$list_is_empty = false;
				break;
			}
		}

		if ($list_is_empty) {
			$recipient_list[] = $mailfrom;
		}

		if ($user->authorise('djcatalog2.salesman', 'com_djcatalog2')) {
			$recipient_list[] = $user->email;
		}

		if (count($vendors) > 0) {
			foreach($vendors as $vendor) {
				$recipient_list[] = $vendor->email;
			}
		}

		$recipient_list = array_unique($recipient_list);

		$subject = Text::sprintf('COM_DJCATALOG2_EMAIL_NEW_QUOTE_SUBJECT', $sitename);
		$admin_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'admin.quote', $attachments);
		$client_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'quote', $attachments);

		if (!$admin_body) {
			return false;
		}

		// Send admin's email first
		$mail = Factory::getMailer();

		foreach ($recipient_list as $k=> $recipient) {
			$mail = Factory::getMailer();
			$mail->addRecipient(trim((string)$recipient));
			$mail->setSender(array($mailfrom, $fromname));
			$mail->addReplyTo($data['email'], $data['firstname'].' '.$data['lastname']);
			$mail->setSubject($subject . ' - '.$data['firstname'].' '.$data['lastname']);
			$mail->setBody($admin_body);
			$mail->isHtml(true);

			if (is_array($attachments) && count($attachments)) {
				foreach($attachments as $file) {
					$name = basename($file);
					$mail->addAttachment($file, $name);
				}
			}

			$admin_sent = $mail->Send() ? true : $admin_sent;
		}

		// Send an email to customer
		$mail = Factory::getMailer();

		//$mail->addRecipient($mailfrom);
		$mail->addRecipient($data['email']);

		$mail->setSender(array($mailfrom, $fromname));
		$mail->setSubject($subject);
		$mail->setBody($client_body);
		$mail->isHtml(true);
		$mail->Send();

		if ($notifyOwners) {
			$db = Factory::getDbo();
			$itemIds = array();
			foreach($data['items'] as $item) {
				$itemIds[] = $item['item_id'];
			}

			$query = $db->getQuery(true);
			$query->select('u.email, i.email as alt_email, u.id, u.name, i.id as item_id');
			$query->from('#__djc2_items AS i');
			$query->join('LEFT', '#__users AS u ON i.created_by = u.id');
			$query->where('i.id IN ('.implode(',', $itemIds).')');
			$db->setQuery($query);

			$owners = $db->loadObjectList('item_id');
			if (count($owners) > 0) {
				$allItems = $data['items'];
				$ownerItems = array();
				foreach($owners as $item_id => $owner) {
					if (!array_key_exists($owner->id, $ownerItems)) {
						$ownerItems[$owner->id] = array('owner'=>$owner, 'items'=>array());
					}
					foreach($allItems as $item) {
						if ($item['item_id'] == $item_id) {
							$ownerItems[$owner->id]['items'][] = $item;
						}
					}
				}

				$owner_attachments = array();

				foreach ($ownerItems as $ownerData) {
					if (empty($ownerData['items'])) {
						continue;
					}

					$owner_email = $ownerData['owner']->alt_email ? $ownerData['owner']->alt_email : $ownerData['owner']->email;
					if (trim((string)$owner_email) == '') {
						continue;
					}

					$data['items'] = $ownerData['items'];
					$data['isOwner'] = true;

					$ownerBody = DJCatalog2HtmlHelper::getEmailTemplate($data, 'admin.quote', $owner_attachments);

					$mail = Factory::getMailer();
					$mail->setSender(array($mailfrom, $fromname));
					$mail->addRecipient(trim((string)$owner_email));
					$mail->addReplyTo($data['email'], $data['firstname'].' '.$data['lastname']);
					$mail->setSubject($subject . ' - '.$data['firstname'].' '.$data['lastname']);
					$mail->setBody($ownerBody);
					$mail->isHtml(true);

					if (is_array($owner_attachments) && count($owner_attachments)) {
						foreach($owner_attachments as $file) {
							$name = basename($file);
							$mail->addAttachment($file, $name);
						}
					}

					$mail->Send();
				}
			}

		}
		return $admin_sent;
	}
}