<?php

/**
 * @package     MokoJoomBackup
 * @author      Moko Consulting <hello@mokoconsulting.tech>
 * @copyright   Copyright (C) 2026 Moko Consulting. All rights reserved.
 * @license     GNU General Public License version 3 or later; see LICENSE
 */

defined('_JEXEC') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\Installer\InstallerAdapter;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Router\Route;

class Pkg_MokoJoomBackupInstallerScript
{
	/**
	 * Minimum Joomla version required
	 *
	 * @var string
	 */
	protected $minimumJoomla = '4.0.0';

	/**
	 * Minimum PHP version required
	 *
	 * @var string
	 */
	protected $minimumPhp = '8.1.0';

	/**
	 * Called before any install/update/uninstall action.
	 *
	 * @param   string            $type    Action type (install, update, uninstall)
	 * @param   InstallerAdapter  $parent  Installer adapter
	 *
	 * @return  bool
	 */
	public function preflight(string $type, InstallerAdapter $parent): bool
	{
		if (version_compare(PHP_VERSION, $this->minimumPhp, '<')) {
			Factory::getApplication()->enqueueMessage(
				Text::sprintf('PKG_MOKOJOOMBACKUP_PHP_VERSION_ERROR', $this->minimumPhp),
				'error'
			);

			return false;
		}

		// Save download key before Joomla re-registers the update site
		if ($type === 'update') {
			$this->preflight_saveKey();
		}

		return true;
	}

	/**
	 * Called after install/update.
	 *
	 * @param   string            $type    Action type
	 * @param   InstallerAdapter  $parent  Installer adapter
	 *
	 * @return  void
	 */
	/**
	 * Called before install/update to preserve the download key.
	 *
	 * Joomla re-registers update sites from the manifest on every update,
	 * which can reset the extra_query (download key). We save it here
	 * and restore it in postflight.
	 */
	private ?string $savedDownloadKey = null;

	public function preflight_saveKey(): void
	{
		try {
			$db    = Factory::getDbo();
			$query = $db->getQuery(true)
				->select($db->quoteName('us.extra_query'))
				->from($db->quoteName('#__update_sites', 'us'))
				->join(
					'INNER',
					$db->quoteName('#__update_sites_extensions', 'use')
					. ' ON ' . $db->quoteName('use.update_site_id') . ' = ' . $db->quoteName('us.update_site_id')
				)
				->join(
					'INNER',
					$db->quoteName('#__extensions', 'e')
					. ' ON ' . $db->quoteName('e.extension_id') . ' = ' . $db->quoteName('use.extension_id')
				)
				->where($db->quoteName('e.element') . ' = ' . $db->quote('pkg_mokojoombackup'))
				->where($db->quoteName('e.type') . ' = ' . $db->quote('package'))
				->setLimit(1);
			$db->setQuery($query);
			$key = $db->loadResult();

			if (!empty($key)) {
				$this->savedDownloadKey = $key;
			}
		} catch (\Throwable $e) {
			error_log('MokoJoomBackup: Could not save download key: ' . $e->getMessage());
		}
	}

	public function postflight(string $type, InstallerAdapter $parent): void
	{
		// Restore download key if it was saved before update
		if ($this->savedDownloadKey !== null) {
			$this->restoreDownloadKey();
		}

		if ($type === 'install') {
			// Enable the system plugin automatically on fresh install
			$db    = Factory::getDbo();
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('system'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the quickicon plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('quickicon'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the task plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('task'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the webservices plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('webservices'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the console plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('console'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the content plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('content'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Enable the actionlog plugin automatically
			$query = $db->getQuery(true)
				->update($db->quoteName('#__extensions'))
				->set($db->quoteName('enabled') . ' = 1')
				->where($db->quoteName('type') . ' = ' . $db->quote('plugin'))
				->where($db->quoteName('folder') . ' = ' . $db->quote('actionlog'))
				->where($db->quoteName('element') . ' = ' . $db->quote('mokojoombackup'));

			$db->setQuery($query);
			$db->execute();

			// Create default backup directory
			$backupDir = JPATH_ADMINISTRATOR . '/components/com_mokojoombackup/backups';

			if (!is_dir($backupDir)) {
				mkdir($backupDir, 0755, true);

				// Protect backup directory with .htaccess
				file_put_contents($backupDir . '/.htaccess', "# Apache 2.4+\n<IfModule mod_authz_core.c>\n  Require all denied\n</IfModule>\n# Apache 2.2\n<IfModule !mod_authz_core.c>\n  Order deny,allow\n  Deny from all\n</IfModule>\n");
				file_put_contents($backupDir . '/index.html', '<!DOCTYPE html><title></title>');
			}
		}

		// Sync submenu icons in #__menu (Joomla doesn't update icons on upgrades)
		$this->syncMenuIcons();

		// Warn if no license key configured (skip on uninstall)
		if ($type !== 'uninstall') {
			$this->warnMissingLicenseKey();
		}
	}

	private function syncMenuIcons(): void
	{
		$iconMap = [
			'view=dashboard' => 'class:home',
			'view=backups'   => 'class:database',
			'view=profiles'  => 'class:cog',
		];

		try {
			$db = Factory::getDbo();

			foreach ($iconMap as $linkFragment => $icon) {
				$query = $db->getQuery(true)
					->update($db->quoteName('#__menu'))
					->set($db->quoteName('img') . ' = ' . $db->quote($icon))
					->where($db->quoteName('client_id') . ' = 1')
					->where($db->quoteName('link') . ' LIKE ' . $db->quote('%com_mokojoombackup%' . $linkFragment . '%'));
				$db->setQuery($query);
				$db->execute();
			}

			// Set top-level component menu icon
			$query = $db->getQuery(true)
				->update($db->quoteName('#__menu'))
				->set($db->quoteName('img') . ' = ' . $db->quote('class:archive'))
				->where($db->quoteName('client_id') . ' = 1')
				->where($db->quoteName('link') . ' LIKE ' . $db->quote('index.php?option=com_mokojoombackup'))
				->where($db->quoteName('level') . ' = 1');
			$db->setQuery($query);
			$db->execute();
		} catch (\Throwable $e) {
			error_log('MokoJoomBackup: syncMenuIcons() failed: ' . $e->getMessage());
		}
	}

	/**
	 * Restore the download key to the (possibly new) update site record.
	 */
	private function restoreDownloadKey(): void
	{
		try {
			$db    = Factory::getDbo();
			$query = $db->getQuery(true)
				->select($db->quoteName('us.update_site_id'))
				->from($db->quoteName('#__update_sites', 'us'))
				->join(
					'INNER',
					$db->quoteName('#__update_sites_extensions', 'use')
					. ' ON ' . $db->quoteName('use.update_site_id') . ' = ' . $db->quoteName('us.update_site_id')
				)
				->join(
					'INNER',
					$db->quoteName('#__extensions', 'e')
					. ' ON ' . $db->quoteName('e.extension_id') . ' = ' . $db->quoteName('use.extension_id')
				)
				->where($db->quoteName('e.element') . ' = ' . $db->quote('pkg_mokojoombackup'))
				->where($db->quoteName('e.type') . ' = ' . $db->quote('package'))
				->setLimit(1);
			$db->setQuery($query);
			$updateSiteId = (int) $db->loadResult();

			if ($updateSiteId > 0) {
				$query = $db->getQuery(true)
					->update($db->quoteName('#__update_sites'))
					->set($db->quoteName('extra_query') . ' = ' . $db->quote($this->savedDownloadKey))
					->where($db->quoteName('update_site_id') . ' = ' . $updateSiteId);
				$db->setQuery($query);
				$db->execute();
			}
		} catch (\Throwable $e) {
			error_log('MokoJoomBackup: Could not restore download key: ' . $e->getMessage());
		}
	}

	private function warnMissingLicenseKey(): void
	{
		try
		{
			$db = Factory::getDbo();
			$db->setQuery(
				$db->getQuery(true)
					->select([$db->quoteName('update_site_id'), $db->quoteName('extra_query')])
					->from($db->quoteName('#__update_sites'))
					->where('(' . $db->quoteName('name') . ' LIKE ' . $db->quote('%MokoJoomBackup%') . ' OR ' . $db->quoteName('location') . ' LIKE ' . $db->quote('%MokoJoomBackup%') . ')')
					->setLimit(1)
			);
			$site = $db->loadObject();

			if ($site)
			{
				$eq = (string) ($site->extra_query ?? '');
				if (!empty($eq) && strpos($eq, 'dlid=') !== false) { parse_str($eq, $p); if (!empty($p['dlid'])) { return; } }
				$editUrl = 'index.php?option=com_installer&task=updatesite.edit&update_site_id=' . (int) $site->update_site_id;
			}
			else
			{
				$editUrl = 'index.php?option=com_installer&view=updatesites';
			}

			Factory::getApplication()->enqueueMessage(
				'<strong>Moko Consulting License Key Required</strong> — '
				. 'No download key is configured. Updates will not be available until a valid license key is entered. '
				. '<a href="' . $editUrl . '" class="btn btn-sm btn-warning ms-2">Enter License Key</a>',
				'warning'
			);
		}
		catch (\Throwable $e) {
			error_log('MokoJoomBackup: License key check failed: ' . $e->getMessage());
		}
	}
}