<?php
/**
 * @package	HikaShop for Joomla!
 * @version	6.1.0
 * @author	hikashop.com
 * @copyright	(C) 2010-2025 HIKARI SOFTWARE. All rights reserved.
 * @license	GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><?php
$jversion = preg_replace('#[^0-9\.]#i','',JVERSION);
if(version_compare($jversion,'5.0.0','>=')) {
	include_once(__DIR__.'/hikashop_j5.php');
} elseif(version_compare($jversion,'4.0.0','>=')) {
	include_once(__DIR__.'/hikashop_j4.php');
} else {
	include_once(__DIR__.'/hikashop_j3.php');
}

class plgFinderHikashop extends plgFinderHikashopBridge
{
	protected $context = 'Product';
	protected $extension = 'com_hikashop';
	protected $layout = 'product';
	protected $type_title = 'Product';
	protected $table = '#__hikashop_product';
	protected $state_field = 'product_published';
	protected $item = null;
	protected $elementBeingDeleted = null;

	protected function handleOtherLanguages(&$item) {
		$translationHelper = hikashop_get('helper.translation');
		if($translationHelper->isMulti()){
			$languages = $translationHelper->loadLanguages();

			$mainColumns = array(
				'title' => 'product_name',
				'summary' => 'product_description',
				'metakey' => 'product_keywords',
				'metadesc' => 'product_meta_description',
				'product_alias' => 'product_alias'
			);
			$fields = $this->params->get('fields');
			if(!is_array($fields)){
				$fields = explode(',',(string)$fields);
			}
			if(!empty($fields) && count($fields)) {
				$columns = array_merge($mainColumns, $fields);
			} else {
				$columns = $mainColumns;
			}
			foreach($languages as $language) {
				if(method_exists($item, 'serialize')) {
					$serialize = $item->serialize();
					$class = $this->resultClass;
					$copy = new $class();
					@$copy->unserialize($serialize);
				} else {
					$copy = hikashop_copy($item);
				}
				$copy->language = $language->code;
				$copy->addTaxonomy('Language', $copy->language);
				$copy->addTaxonomy('Type', 'Product');

				if($translationHelper->falang) {
					$db = JFactory::getDBO();
					$dbColumns = array();
					foreach($columns as $column) {
						$dbColumns[] = $db->Quote($column);
					}
					$query = 'SELECT * FROM #__falang_content WHERE published=1 AND language_id = '.(int)$language->id.' AND reference_table=\'hikashop_product\' AND reference_id = '.(int)$item->id.' AND reference_field IN ('.implode(',', $dbColumns).')';
					$db->setQuery($query);
					$translations = $db->loadObjectList();
					if(!empty($translations)) {
						foreach($translations as  $t) {
							if(empty($t->value))
								continue;
							$column = $t->reference_field;
							$copy->$column = $t->value;

							if(in_array($column, $mainColumns)) {
								$key = array_search($column, $mainColumns);
								if($key == 'summary') {
									$copy->summary = $this->prepareContent($copy->$column, $copy->params);
								} else {
									$copy->$key = $copy->$column;
								}
							}
						}
					}
				} else {
					$originals = array();
					foreach($columns as $column) {
						if(!empty($item->$column)) {
							$originals[$column] = $item->$column;
						}
					}
					if(count($originals)) {
						$translations = hikashop_translate($originals, $language->code);
						foreach($originals as $k => $o) {
							if($o == $translations[$k])
								continue;
							$copy->$k = $translations[$k];

							foreach($columns as $column) {
								if(in_array($column, $mainColumns)) {
									$key = array_search($column, $mainColumns);
									if($key == 'summary') {
										$copy->summary = $this->prepareContent($copy->$column, $copy->params);
									} else {
										$copy->$key = $copy->$column;

									}
								}
							}
						}
					}
				}

				$copy->alias = '';
				$this->addAlias($copy);

				$extra = $this->_getElementMenuItem($copy);
				$SEFlanguages = JLanguageHelper::getLanguages('sef');
				foreach ($SEFlanguages as $sef => $lang) {
					if($lang->lang_code == $language->code) {
						$extra .= '&lang='.$sef;
						break;
					}
				}

				$copy->url   = "index.php?option=com_hikashop&ctrl=product&task=show&cid=" . $copy->id."&name=".$copy->alias.$extra;
				$copy->route = "index.php?option=com_hikashop&ctrl=product&task=show&cid=" . $copy->id."&name=".$copy->alias.$extra;
				$this->indexer->index($copy);
			}
			return true;
		}
		return false;
	}

	public function _onFinderGarbageCollection()
	{
		$db      = $this->db;
		$type_id = $this->getTypeId();

		$query    = $db->getQuery(true);
		$subquery = $db->getQuery(true);
		$subquery->select('CONCAT(' . $db->quote($this->getUrl('%', $this->extension, $this->layout)) . ', product_id)')
			->from($db->quoteName($this->table));
		$query->select($db->quoteName('l.link_id'))
			->from($db->quoteName('#__finder_links', 'l'))
			->where($db->quoteName('l.type_id') . ' = ' . $type_id)
			->where($db->quoteName('l.url') . ' LIKE ' . $db->quote($this->getUrl('%', $this->extension, $this->layout)))
			->where($db->quoteName('l.url') . ' NOT IN (' . $subquery . ')');
		$db->setQuery($query);
		$items = $db->loadColumn();

		foreach ($items as $item) {
			$this->indexer->remove($item);
		}

		return count($items);
	}

	public function _onFinderCategoryChangeState($extension, $pks, $value)
	{
		if ($extension == 'com_hikashop')
		{
			$this->categoryStateChange($pks, $value);
		}
	}

	public function _onFinderAfterDelete($context, $table)
	{
		$this->elementBeingDeleted = $table;
		if ($context == 'com_hikashop.product' && !empty($table->product_id))
		{
			$id = $table->product_id;
		}
		else if ($context == 'com_finder.index' && !empty($table->link_id))
		{
			$id = $table->link_id;
		}
		else
		{
			return true;
		}
		$translationHelper = hikashop_get('helper.translation');
		if($translationHelper->isMulti()){
			$languages = $translationHelper->loadLanguages();
			$result = true;
			foreach($languages as $language) {
				$SEFlanguages = JLanguageHelper::getLanguages('sef');
				foreach ($SEFlanguages as $sef => $lang) {
					if($lang->lang_code == $language->code) {
						$this->elementBeingDeleted->currentLanguage = '&lang='.$sef;
						$result = $result && $this->remove($id);
						break;
					}
				}
			}
			$this->elementBeingDeleted = null;
			return true;
		}

		$result = $this->remove($id);
		$this->elementBeingDeleted = null;
		return $result;
	}

	public function _onFinderAfterSave($context, $row, $isNew)
	{
		if ($context == 'com_hikashop.product' && !is_null($row))
		{

			$index_variants = $this->params->get('index_variants', 1);
			if(!$index_variants) {
				if((isset($row->product_type) && $row->product_type == 'variant') || (isset($row->old) && isset($row->old->product_type) && $row->old->product_type == 'variant')) {
					return true;
				}
			}

			if(isset($row->old->product_published) && isset($row->product_published) && $row->old->product_published != $row->product_published) {
				$this->itemStateChange(array($row->product_id), $row->product_published);
			}

			if(isset($row->old->product_access) && isset($row->product_access) && $row->old->product_access != $row->product_access) {
				$public_access = in_array($row->product_access, array('', 'all')) || strpos($row->product_access, ',9,') !== false;
				if(!$public_access) {
					$this->itemStateChange(array($row->product_id), 0);
				} else if((!isset($row->product_published) && $row->old->product_published > 0 ) || $row->product_published > 0) {
					$this->itemStateChange(array($row->product_id), 1);
				}
			}
			if(!empty($row->categories) && (!isset($row->product_parent_id) || empty($row->product_parent_id))) {
				$query = 'SELECT category_id FROM #__hikashop_category WHERE category_id IN('.implode(',', $row->categories).') AND category_published=1;';
				$db = JFactory::getDBO();
				$db->setQuery($query);
				$res = $db->loadResult();

				if(!$res) {
					return $this->remove($row->product_id);
				}
			}

			$this->reindex($row->product_id);
		}

		return true;
	}

	public function _onFinderBeforeSave($context, $row, $isNew)
	{
		return true;
	}
	public function _onFinderChangeState($context, $pks, $value)
	{
		if ($context == 'com_hikashop.product')
		{
			$this->itemStateChange($pks, $value);
		}
		if ($context == 'com_plugins.plugin' && $value === 0)
		{
			$this->pluginDisable($pks);
		}
	}

	protected function translateState($item, $category = null)
	{
		if(!empty($this->item->product_parent_id)) {
			$index_variants = $this->params->get('index_variants', 1);
			if(!$index_variants) {
				return 0;
			}

			$productClass = hikashop_get('class.product');
			$parentProduct = $productClass->get($this->item->product_parent_id);
			$public_access = isset($parentProduct) && (in_array($parentProduct->product_access, array('', 'all')) || strpos($parentProduct->product_access, ',9,') !== false);
			if(empty($parentProduct) || $parentProduct->product_published < 1 || !$public_access) {
				return 0;
			}

			$db = JFactory::getDBO();
			$query = 'SELECT c.category_id FROM #__hikashop_category AS c LEFT JOIN #__hikashop_product_category AS pc ON pc.category_id = c.category_id WHERE c.category_published=1 AND pc.product_id ='.(int)$parentProduct->product_id;
			$db->setQuery($query);
			$res = $db->loadResult();
			if($res)
				$category = 1;
			else
				$category = 0;
		}elseif(!empty($this->item->id)) {
			$public_access = in_array($this->item->product_access, array('', 'all')) || strpos($this->item->product_access, ',9,') !== false;
			if($this->item->product_published < 1  || !$public_access) {
				return 0;
			}
			$query = 'SELECT c.category_id FROM #__hikashop_category AS c LEFT JOIN #__hikashop_product_category AS pc ON pc.category_id = c.category_id WHERE c.category_published=1 AND pc.product_id ='.$this->item->id;
			$db = JFactory::getDBO();
			$db->setQuery($query);
			$res = $db->loadResult();
			if($res)
				$category = 1;
			else
				$category = 0;
		}

		return parent::translatestate($item, $category);
	}


	protected function setup()
	{
		$this->_setup();
		return true;
	}

	protected function _setup() {

		if(!defined('DS'))
			define('DS', DIRECTORY_SEPARATOR);
		include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php');
	}

	protected function getUrl($id, $extension, $view)
	{
		$url = 'index.php?option=' . $extension . '&ctrl=' . $view . '&task=show&cid=';
		if(!empty($id)) {
			if(is_numeric($id)) {
				$productClass = hikashop_get('class.product');
				if(!empty($this->elementBeingDeleted) && $this->elementBeingDeleted->product_id == $id) {
					$item = $this->elementBeingDeleted;
					$productClass->addAlias($item);
				} else {
					$item = $productClass->get($id);
				}

				if(empty($item)) {
					$url .= $id;
					return $url;
				}

				$this->_setup();
				$extra = $this->_getElementMenuItem($item);
				if(!empty($this->elementBeingDeleted->currentLanguage)) {
					$extra .= $this->elementBeingDeleted->currentLanguage;
				}

				if($item->product_type == 'variant') {
					$parent = $productClass->get($item->product_parent_id);
					if($parent)
						$item->alias = $parent->alias;
				}
				$url .= $id ."&name=".$item->alias. $extra;
			} elseif($id === '%') {
				$url .= $id;
			}
		}

		return $url;
	}

	protected function _getElementMenuItem(&$item) {
		$config = hikashop_config();
		if($config->get('auto_search_menu_item_based_on_main_category', 1)) {
			$database = JFactory::getDBO();
			static $menuItems = null;
			if(is_null($menuItems)) {
				$filters = array(
					'a.type=\'component\'',
					'a.published=1',
					'b.title IS NOT NULL',
				);

				if(hikashop_isClient('client')) {
					$user = JFactory::getUser();
					$accesses = JAccess::getAuthorisedViewLevels(@$user->id);
					if(!empty($accesses)){
						$filters[]='a.access IN ('.implode(',',$accesses).')';
					}
				}

				$filters[] = 'a.client_id=0';
				$filters[] = '(a.link='.$database->Quote('index.php?option=com_hikashop&view=category&layout=listing').' OR a.link='.$database->Quote('index.php?option=com_hikashop&view=product&layout=listing').')';

				$lang = JFactory::getLanguage();
				$tag = $lang->getTag();
				$filters[] = "a.language IN ('*', '', ".$database->Quote($tag).")";

				$query="SELECT a.id, a.link, a.params FROM ".hikashop_table('menu',false).' AS a ' .
					'INNER JOIN `#__menu_types` AS b ON a.menutype = b.menutype ' .
					'WHERE ' .  implode(' AND ',$filters);
				$database->setQuery($query);
				$menuItems = $database->loadObjectList();
			}

			if (!empty($menuItems)) {
				$database->setQuery('SELECT c.category_id ' .
					'FROM '.hikashop_table('product_category') . ' AS pc ' .
					'INNER JOIN '.hikashop_table('category') . ' AS c ' .
					'ON c.category_id = pc.category_id ' .
					'AND c.category_published = 1 ' .
					'WHERE pc.product_id = ' . ((@$item->product_type == 'variant' && !empty($item->product_parent_id)) ? (int)$item->product_parent_id : (int)$item->product_id) . ' ' .
					"ORDER BY pc.product_category_id ASC");
				$category = $database->loadObject();

				if(!empty($category)) {
					foreach($menuItems as $menuItem) {
						$params = json_decode($menuItem->params);
						if ($menuItem->link == 'index.php?option=com_hikashop&view=category&layout=listing' && !empty($params->hk_category->category) && $category->category_id == $params->hk_category->category) {
							$extra = '&Itemid='.$menuItem->id;
							break;
						}
						if ($menuItem->link == 'index.php?option=com_hikashop&view=product&layout=listing' && !empty($params->hk_product->category) && $category->category_id == $params->hk_product->category) {
							$extra = '&Itemid='.$menuItem->id;
							break;
						}
					}
				}
			}
		}
		if(empty($extra)) {
			$menusClass = hikashop_get('class.menus');
			$itemid = $menusClass->getPublicMenuItemId();
			if($itemid)
				$extra = '&Itemid='.$itemid;
			else
				$extra = '';
		}
		return $extra;
	}

	protected function getListQuery($query = null)
	{
		$category = (bool)$this->params->get('index_per_category');
		$db = JFactory::getDbo();
		$query = $query instanceof JDatabaseQuery ? $query : $db->getQuery(true)
			->select('a.*')
			->select('a.product_id AS id, a.product_name AS title, a.product_alias AS alias, "" AS link, a.product_description AS summary')
			->select('a.product_keywords AS metakey, a.product_meta_description AS metadesc, "" AS metadata, a.product_access AS access')
			->select('"" AS created_by_alias, a.product_modified AS modified, "" AS modified_by')
			->select($this->getStateColumn().' AS state, a.product_sale_start AS start_date, 1 AS access')
			->select('brand.category_name AS brand, brand.category_alias as brandalias, brand.category_published AS brand_state, 1 AS brand_access');
		if($category) {
			$query->select('c.category_name AS category, c.category_alias as categoryalias, c.category_published AS cat_state, 1 AS cat_access');
		}

		$case_when_item_alias = ' CASE WHEN a.product_alias != "" THEN a.product_alias ELSE a.product_name END as slug';
		$query->select($case_when_item_alias);
		if($category) {
			$case_when_category_alias = 'c.category_id AS catid, CASE WHEN c.category_alias != "" THEN c.category_alias ELSE c.category_name END as catslug';
			$query->select($case_when_category_alias);
		}

		$query->from('#__hikashop_product AS a')
			->join('LEFT', '#__hikashop_category AS brand ON a.product_manufacturer_id = brand.category_id');

		if($category) {
			$query->join('LEFT', '#__hikashop_product_category AS pc ON a.product_id = pc.product_id')
				->join('LEFT', '#__hikashop_category AS c ON pc.category_id = c.category_id');
		}
		return $query;
	}
	protected function getItem($id)
	{
		$query = $this->getListQuery();
		$query->where('a.product_id = ' . (int) $id);

		$this->db->setQuery($query);
		$row = $this->db->loadAssoc();

		if(empty($row))
			$row = array();

		$item = $this->toObject($row);

		$item->type_id = $this->type_id;

		$item->layout = $this->layout;

		return $item;
	}

	protected function categoryStateChange($pks, $value)
	{
		foreach ($pks as $pk)
		{
			$query = clone $this->getStateQuery();
			$query->where('c.category_id = ' . (int) $pk);

			$this->db->setQuery($query);
			$items = $this->db->loadObjectList();

			foreach ($items as $item)
			{
				$temp = $this->translateState($item->state, $value);

				$this->change($item->id, 'state', $temp);

				$this->reindex($item->id);
			}
		}
	}

	protected function checkItemAccess($row)
	{
		$query = $this->db->getQuery(true)
			->select($this->db->quoteName('access'))
			->from($this->db->quoteName($this->table))
			->where($this->db->quoteName('product_id') . ' = ' . (int) $row->id);
		$this->db->setQuery($query);

		$this->old_access = $this->db->loadResult();
	}
	protected function itemStateChange($pks, $value)
	{
		foreach ($pks as $pk)
		{
			$query = clone $this->getStateQuery();
			$query->where('a.product_id = ' . (int) $pk);

			$this->db->setQuery($query);
			$item = $this->db->loadObject();

			$temp = $this->translateState($value, $item->cat_state);

			$this->change($pk, 'state', $temp);

			$this->reindex($pk);

			if(empty($this->item->product_parent_id)) {
				$index_variants = $this->params->get('index_variants', 1);
				if($index_variants) {
					$db = JFactory::getDBO();
					$db->setQuery('SELECT product_id FROM #__hikashop_product WHERE product_parent_id = '.(int)$pk);
					$variants = $db->loadColumn();
					foreach($variants as $variant) {
						$this->reindex($variant);
					}
				}
			}
		}
	}

	protected function getUpdateQueryByTime($time)
	{
		$query = $this->db->getQuery(true)
			->where('a.product_modified >= ' . $this->db->quote($time));

		return $query;
	}

	protected function getUpdateQueryByIds($ids)
	{
		$query = $this->db->getQuery(true)
			->where('a.product_id IN(' . implode(',', $ids) . ')');

		return $query;
	}

	protected function getStateQuery()
	{
		$query = $this->db->getQuery(true);

		$query->select('a.*, a.product_id AS id, c.category_id AS catid');

		$query->select($this->getStateColumn().' AS state, c.category_published AS cat_state');
		$query->select('1 AS access,  1 AS cat_access')
			->from($this->table . ' AS a')
			->join('LEFT', '#__hikashop_product_category AS pc ON a.product_id = pc.product_id')
			->join('LEFT', '#__hikashop_category AS c ON pc.category_id = c.category_id');

		return $query;
	}

	protected function getStateColumn() {
		$conditions = array(
			'WHEN a.product_type = \'trash\' THEN 0',
			'WHEN a.product_access NOT IN (\'all\', \'\') AND a.product_access NOT LIKE \'%,9,%\' THEN 0',
		);
		if(!function_exists('hikashop_config'))
			$this->setup();
		$config = hikashop_config();
		$out_of_stock = (int)$config->get('show_out_of_stock','1');
		if(!$out_of_stock){
			$conditions[] = 'WHEN a.product_quantity = 0 THEN 0';
		}
		return '(CASE '.implode(' ', $conditions).' ELSE a.product_published END)';
	}
}