<?php
/**
 ------------------------------------------------------------------------
 SOLIDRES - Accommodation booking extension for Joomla
 ------------------------------------------------------------------------
 * @author    Solidres Team <contact@solidres.com>
 * @website   https://www.solidres.com
 * @copyright Copyright (C) 2013 - 2019 Solidres. All Rights Reserved.
 * @license   GNU General Public License version 3, or later
 ------------------------------------------------------------------------
 */

defined('_JEXEC') or die;

class plgSolidresExperienceInstallerScript
{
	public function install($adapter)
	{
		$plugins = JFolder::folders($adapter->getParent()->getPath('source') . '/experiencepayment', '[^\.]', false, true);
		$db      = JFactory::getDbo();
		$query   = $db->getQuery(true)
			->update($db->qn('#__extensions'))
			->set('enabled = 1')
			->where($db->qn('type') . ' = ' . $db->q('plugin'))
			->where($db->qn('folder') . ' = ' . $db->q('solidres'))
			->where($db->qn('element') . ' = ' . $db->q('experience'));
		$db->setQuery($query)
			->execute();

		foreach ($plugins as $plugin)
		{
			$installer = new JInstaller;
			$installer->setPath('source', $plugin);
			$newAdapter = $installer->setupInstall('install', true);

			if (is_object($newAdapter) && $newAdapter->install())
			{
				$pluginName = trim(basename($plugin));
				$query->clear()
					->update($db->qn('#__extensions'))
					->set('enabled = 1')
					->where($db->qn('type') . ' = ' . $db->q('plugin'))
					->where($db->qn('folder') . ' = ' . $db->q('experiencepayment'))
					->where($db->qn('element') . ' = ' . $db->q($pluginName));
				$db->setQuery($query)
					->execute();
			}
		}

		$query->clear();
		$query->select('COUNT(*)')
			->from($db->quoteName('#__sr_customfields'))
			->where($db->quoteName('context') . ' = ' . $db->quote('com_solidres.experience.customer'));
		$count = $db->setQuery($query)->loadResult();

		if ($count < 1)
		{
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Title', 'customer_title', '1', 'select', '1', '2015-12-03 07:28:48', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{\"multiple\":\"0\",\"options\":[{\"text\":\"Mr.\",\"value\":\"Mr.\"},{\"text\":\"Mrs.\",\"value\":\"Mrs.\"},{\"text\":\"Ms.\",\"value\":\"Ms.\"}],\"format\":\"dd-mm-yy\"}', '17', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'First name', 'customer_firstname', '1', 'text', '0', '2015-12-03 09:06:03', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '18', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Middlename', 'customer_middlename', '1', 'text', '1', '2015-12-03 09:06:35', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '19', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Last name', 'customer_lastname', '1', 'text', '0', '2015-12-03 09:07:18', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '20', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Email', 'customer_email', '1', 'email', '0', '2015-12-03 09:07:37', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '21', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Confirm Email', 'customer_email2', '1', 'email', '0', '2015-12-03 09:07:37', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '22', '0', 'Confirm your email address.', 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Landline number', 'customer_phonenumber', '1', 'text', '0', '2015-12-03 09:08:03', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '23', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Mobile phone', 'customer_mobilephone', '1', 'text', '1', '2015-12-03 09:08:13', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '24', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Company', 'customer_company', '1', 'text', '1', '2015-12-03 09:08:26', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '25', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Address 1', 'customer_address1', '1', 'text', '0', '2015-12-03 09:08:46', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '26', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Address 2', 'customer_address2', '1', 'text', '1', '2015-12-03 09:09:14', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '27', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'VAT number', 'customer_vat_number', '1', 'text', '1', '2015-12-03 09:09:38', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '28', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'City', 'customer_city', '1', 'text', '0', '2015-12-03 09:09:54', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '29', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Zip/Postal code', 'customer_zipcode', '1', 'text', '1', '2015-12-03 09:10:07', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '30', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Country', 'customer_country_id', '1', 'country', '0', '2015-12-03 09:10:49', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '31', '0', NULL, 0) ")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'State/Province', 'customer_geo_state_id', '1', 'zone_state', '1', '2015-12-03 09:11:23', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '32', '0', NULL, 0)")->execute();
			$db->setQuery("INSERT INTO " . $db->quoteName('#__sr_customfields') . " VALUES ('0', 'Note', 'customer_note', '1', 'textarea', '1', '2015-12-03 09:11:49', '0', '0', '0000-00-00 00:00:00', '1', 'com_solidres.experience.customer', '{}', '33', '0', NULL, 0)")->execute();
		}

		$contentElementPath = JPATH_ADMINISTRATOR . '/components/com_falang/contentelements';

		if (JFolder::exists($contentElementPath))
		{
			$path           = $adapter->getParent()->getPath('source') . '/administrator/components/com_solidres/falang';
			$translateFiles = JFolder::files($path, '\.xml', false, true);

			foreach ($translateFiles as $file)
			{
				JFile::copy($file, $contentElementPath . '/' . basename($file));
			}
		}
	}

	public function update($adapter)
	{
		$this->install($adapter);
		$db = JFactory::getDbo();

		if ((string) $adapter->getManifest()->version == '0.3.0')
		{
			$query = $db->getQuery(true)
				->select($db->qn('id'))
				->from($db->qn('#__sr_experience_reservations'));
			$db->setQuery($query);

			if (($pks = $db->loadColumn()) && SRPlugin::isEnabled('experience'))
			{
				foreach ($pks as $pk)
				{
					SRExperienceHelper::updateCustomerName($pk);
				}
			}
		}

		$query = $db->getQuery(true)
			->select('COUNT(*)')
			->from($db->qn('#__sr_experience_date_xref'));
		$db->setQuery($query);

		if (!$db->loadResult())
		{
			$query->clear()
				->select('a.id, a.available_dates', 'a')
				->from($db->qn('#__sr_experiences', 'a'));
			$db->setQuery($query);

			if ($rows = $db->loadObjectList())
			{
				$nowDate = JFactory::getDate();
				$values  = array();

				foreach ($rows as $row)
				{
					$pk    = (int) $row->id;
					$dates = json_decode($row->available_dates, true);

					if (!empty($dates))
					{
						foreach ($dates as $date)
						{
							try
							{
								$date = JFactory::getDate($date);

								if ((int) $nowDate->diff($date)->format('%R%a') >= 0)
								{
									$values[] = $pk . ',' . $db->q($date->toSql());
								}
							}
							catch (Exception $e)
							{

							}
						}
					}
				}

				if ($values)
				{
					$query->clear()
						->insert($db->qn('#__sr_experience_date_xref'))
						->columns($db->qn(array('experience_id', 'date')))
						->values(\Joomla\Utilities\ArrayHelper::arrayUnique($values));
					$db->setQuery($query)
						->execute();
				}
			}
		}

		// Update add new confirm email field if not exists
		$query = $db->getQuery(true)
			->select('*')
			->from($db->quoteName('#__sr_customfields'))
			->where($db->quoteName('context') . ' = ' . $db->quote('com_solidres.experience.customer'))
			->order($db->quoteName('ordering') . ' ASC');
		$db->setQuery($query);
		$willUpdateFields = [];
		$ordering         = 0;

		foreach ($db->loadObjectList() as $field)
		{
			if ($field->field_name === 'customer_email2')
			{
				$willUpdateFields = false;
				break;
			}

			// Update ordering
			$field->ordering    = ++$ordering;
			$willUpdateFields[] = $field;

			if ($field->field_name === 'customer_email')
			{
				$confirmEmailField              = clone $field;
				$confirmEmailField->id          = 0;
				$confirmEmailField->title       = 'Confirm Email';
				$confirmEmailField->description = 'Confirm your email address.';
				$confirmEmailField->field_name  = 'customer_email2';
				$confirmEmailField->ordering    = ++$ordering;
				$willUpdateFields[]             = $confirmEmailField;
			}
		}

		if (false !== $willUpdateFields)
		{
			foreach ($willUpdateFields as $willUpdateField)
			{
				if ($willUpdateField->id)
				{
					$db->updateObject('#__sr_customfields', $willUpdateField, 'id');
				}
				else
				{
					$db->insertObject('#__sr_customfields', $willUpdateField, 'id');
				}
			}
		}
	}

	public function uninstall($adapter)
	{
		$db    = JFactory::getDbo();
		$query = $db->getQuery(true)
			->update($db->qn('#__extensions'))
			->set('enabled = 0')
			->where($db->qn('type') . ' = ' . $db->q('plugin'))
			->where($db->qn('folder') . ' = ' . $db->q('experiencepayment'));
		$db->setQuery($query)
			->execute();

		$query->clear('where')
			->where($db->qn('type') . ' = ' . $db->q('module'))
			->where($db->qn('element') . ' LIKE ' . $db->q('mod_sr_experience%'));
		$db->setQuery($query)
			->execute();

		$query->clear()
			->update($db->qn('#__modules'))
			->set('published = 0')
			->where($db->qn('module') . ' LIKE ' . $db->q('mod_sr_experience%'));
		$db->setQuery($query)
			->execute();

		$query->clear()
			->delete($db->quoteName('#__sr_customfield_values'))
			->where($db->quoteName('context') . ' LIKE ' . $db->quote('com_solidres.experience.customer%'));
		$db->setQuery($query)
			->execute();

		$query->clear()
			->delete($db->quoteName('#__sr_customfields'))
			->where($db->quoteName('context') . ' = ' . $db->quote('com_solidres.experience.customer'));
		$db->setQuery($query)
			->execute();

	}

	public function preflight($type, $parent)
	{
		if (!JComponentHelper::isEnabled('com_solidres'))
		{
			$msg = "<p>Experience installed failed. Please make sure that Solidres Component is installed then try again.</p>";
			JLog::add($msg, JLog::WARNING, 'jerror');
		}

		$isCustomFieldInstalled = JPluginHelper::isEnabled('solidres', 'customfield');

		if (!$isCustomFieldInstalled)
		{
			$msg = "<p>Experience installed failed. Please make sure that Solidres Custom Field plugin is installed and enabled then try again.</p>";
			JLog::add($msg, JLog::WARNING, 'jerror');

			return false;
		}

		/** @var  JTableMenu $table */
		$table       = JTable::getInstance('menu');
		$componentId = (int) JComponentHelper::getComponent('com_solidres')->id;
		$db          = $table->getDbo();
		$query       = $db->getQuery(true);

		if ($table->load(array(
			'client_id'    => 1,
			'parent_id'    => 1,
			'type'         => 'component',
			'menutype'     => 'main',
			'link'         => 'index.php?option=com_solidres&view=experiences',
			'component_id' => $componentId,
		)))
		{
			$menuId = (int) $table->id;
			$db     = $table->getDbo();
			$query->delete($db->qn('#__menu'))
				->where('(' . $db->qn('id') . ' = ' . $menuId . ' OR ' . $db->qn('parent_id') . ' = ' . $menuId . ')');
			$db->setQuery($query)
				->execute();
		}

		if ($type === 'uninstall')
		{
			$query->clear()
				->select('a.extension_id')
				->from($db->qn('#__extensions', 'a'))
				->where('a.type = ' . $db->q('plugin'))
				->where('a.folder = ' . $db->q('solidres'))
				->where('a.element = ' . $db->q('experienceinvoice'));
			$db->setQuery($query);

			if ($eid = $db->loadResult())
			{
				$jInstaller = new JInstaller;
				$jInstaller->uninstall('plugin', $eid);
			}

			return;
		}

		$data                 = array();
		$data['menutype']     = 'main';
		$data['title']        = 'SR_SUBMENU_EXPERIENCES';
		$data['alias']        = 'solidres-experiences';
		$data['link']         = 'index.php?option=com_solidres&view=experiences';
		$data['type']         = 'component';
		$data['img']          = 'class:component';
		$data['component_id'] = $componentId;
		$data['client_id']    = 1;
		$data['published']    = 1;
		$data['parent_id']    = 1;
		$data['home']         = 0;
		$data['path']         = '';
		$data['params']       = '';

		if ($parentId = $this->createAdminMenuItem($data, 1))
		{
			$data['parent_id'] = $parentId;
			$subMenus          = array(
				array('SR_EXPERIENCES_LABEL', 'sr-experiences', 'index.php?option=com_solidres&view=experiences'),
				array('SR_CATEGORIES_LABEL', 'sr-expcategories', 'index.php?option=com_solidres&view=expcategories'),
				array('SR_TRANSPORTATIONS_LABEL', 'sr-transportations', 'index.php?option=com_solidres&view=transportations'),
				array('SR_EXP_EXTRAS', 'sr-expextras', 'index.php?option=com_solidres&view=expextras'),
				array('SR_SUBMENU_COUPONS_LIST', 'sr-expcoupons', 'index.php?option=com_solidres&view=expcoupons'),
				array('SR_EXP_GUIDES_LABEL', 'sr-expguides', 'index.php?option=com_solidres&view=expguides'),
				array('SR_CUSTOM_FIELDS_LABEL', 'sr-experience-fields', 'index.php?option=com_solidres&view=customfields&context=com_solidres.experience.customer'),
				array('SR_RESERVATIONS_LABEL', 'sr-expreservations', 'index.php?option=com_solidres&view=expreservations'),
				array('SR_EXPERIENCE_INVOICES', 'sr-expinvoices', 'index.php?option=com_solidres&view=expinvoices'),
				array('SR_STATUSES', 'sr-statuses', 'index.php?option=com_solidres&view=statuses&scope=1'),
				array('SR_ORIGINS', 'sr-origins', 'index.php?option=com_solidres&view=origins&scope=1'),
				array('SR_EXP_CALENDARS', 'sr-expcalendars', 'index.php?option=com_solidres&view=expcalendars'),
				array('SR_EXP_REPORT_N_STATISTICS', 'sr-expdashboard', 'index.php?option=com_solidres&view=expdashboard'),
			);

			foreach ($subMenus as $subMenu)
			{
				$data['title'] = $subMenu[0];
				$data['alias'] = $subMenu[1];
				$data['link']  = $subMenu[2];
				$this->createAdminMenuItem($data, $parentId);
			}
		}

		$files = array(
			JPATH_ROOT . '/media/plg_solidres_experience/assets/css/datepicker.css',
			JPATH_ROOT . '/media/plg_solidres_experience/assets/css/datepicker.min.css',
			JPATH_ROOT . '/media/plg_solidres_experience/assets/js/datepicker.js',
			JPATH_ROOT . '/media/plg_solidres_experience/assets/js/datepicker.min.js',
			JPATH_PLUGINS . '/solidres/experience/administrator/components/com_solidres/models/fields/date.php',
		);

		foreach ($files as $file)
		{
			if (JFile::exists($file))
			{
				@JFile::delete($file);
			}
		}

		if (JFolder::exists(JPATH_ROOT . '/media/plg_solidres_experience/assets/js/i18n'))
		{
			@JFolder::delete(JPATH_ROOT . '/media/plg_solidres_experience/assets/js/i18n');
		}
	}

	protected function createAdminMenuItem($data, $parentId)
	{
		/** @var  JTableMenu $table */
		$table = JTable::getInstance('menu');
		$db    = $table->getDbo();

		try
		{
			$table->setLocation($parentId, 'last-child');
		}
		catch (InvalidArgumentException $e)
		{
			JLog::add($e->getMessage(), JLog::WARNING, 'jerror');

			return false;
		}

		if (!$table->bind($data) || !$table->check() || !$table->store())
		{
			$query = $db->getQuery(true)
				->select('id')
				->from('#__menu')
				->where('menutype = ' . $db->q($data['menutype']))
				->where('client_id = 1')
				->where('link = ' . $db->q($data['link']))
				->where('type = ' . $db->q($data['type']))
				->where('parent_id = ' . $db->q($data['parent_id']))
				->where('home = ' . $db->q($data['home']));
			$db->setQuery($query);
			$menuId = $db->loadResult();

			if (!$menuId)
			{
				throw new RuntimeException($table->getError());
			}
			else
			{
				/** @var  JTableMenu $temporaryTable */
				$temporaryTable = JTable::getInstance('menu');
				$temporaryTable->delete($menuId, true);
				$temporaryTable->rebuild($data['parent_id']);

				// Retry creating the menu item
				$table->setLocation($parentId, 'last-child');

				if (!$table->bind($data) || !$table->check() || !$table->store())
				{
					// Install failed, warn user and rollback changes
					throw new RuntimeException($table->getError());
				}
			}
		}

		return $table->id;
	}
}