<?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
 *
 */

use Joomla\Registry\Registry;
use Joomla\CMS\Table\Table;

// No direct access
defined('_JEXEC') or die;

class Djcatalog2TableItems extends Table
{
	public function __construct(&$db)
	{
		parent::__construct('#__djc2_items', 'id', $db);
	}
	function bind($array, $ignore = '')
	{
		if (isset($array['params']) && is_array($array['params'])) {
			$registry = new Registry();
			$registry->loadArray($array['params']);
			$array['params'] = (string)$registry;
		}


		if (isset($array['config_dimensions']) && is_array($array['config_dimensions'])) {
			$registry = new Registry();
			$registry->loadArray($array['config_dimensions']);
			$array['config_dimensions'] = (string)$registry;
		} else if (!isset($array['config_dimensions'])) {
			$array['config_dimensions'] = '';
		}
		
		if (isset($array['config_dimensions_settings']) && is_array($array['config_dimensions_settings'])) {
			$registry = new Registry();
			$registry->loadArray($array['config_dimensions_settings']);
			$array['config_dimensions_settings'] = (string)$registry;
		} else if (!isset($array['config_dimensions_settings'])) {
			$array['config_dimensions_settings'] = '';
		}
		
		if (isset($array['sections']) && is_array($array['sections'])) {
			$registry = new Registry();
			$registry->loadArray($array['sections']);
			$array['sections'] = (string)$registry;
		} else if (!isset($array['sections'])) {
			$array['sections'] = '';
		}
		
		if (isset($array['location']) && is_array($array['location'])) {
			foreach ($array['location'] as $k=>$v) {
				$array[$k] = $v;
			}
			unset($array['location']);
		}
		
		if (isset($array['grant_usergroups']) && is_array($array['grant_usergroups'])) {
			$registry = new Registry();
			$registry->loadArray($array['grant_usergroups']);
			$array['grant_usergroups'] = (string)$registry;
		}

		if(empty($array['alias'])) {
			$array['alias'] = $array['name'];
		}
		$array['alias'] = JApplicationHelper::stringURLSafe($array['alias']);
		if(trim(str_replace('-','',$array['alias'])) == '') {
			$array['alias'] = JFactory::getDate()->format('Y-m-d-H-i-s');
		}
		
		return parent::bind($array, $ignore);
	}
	/*
	public function load($keys=null, $reset=true) {
		if ($ret = parent::load($keys, $reset)) {
			if (!isset($this->categories)){
				$this->_db->setQuery('SELECT category_id FROM #__djc2_items_categories WHERE item_id=\''.$this->id.'\'');
				$this->categories = $this->_db->loadResultArray();
			}
			return $ret;
		} else {
			return false;
		}
	}*/
	public function store($updateNulls = false)
	{
		$date	= JFactory::getDate();
		$user	= JFactory::getUser();
		$app = JFactory::getApplication();
		$db = JFactory::getDbo();
		
		$this->modified = $date->toSql();
		
		$params = JComponentHelper::getParams('com_djcatalog2');
		
		if (!$this->created) {
			$this->created = $date->toSql();
		}
		
		if (!$this->id) {
			if (empty($this->created_by)) {
				$this->created_by = $user->get('id');
			}
		} else {
			$this->modified_by = $user->get('id');
		}

		$table = JTable::getInstance('Items', 'Djcatalog2Table');
		
		$task = $app->input->get('task');
		
		if ($this->parent_id == 0) {
			if ($app->isClient('site') || $task == 'import' || $task == 'save2copy') {
				if ($table->load(array('alias'=>$this->alias)) && ($table->id != $this->id || $this->id==0)) {
					$db->setQuery('select alias from #__djc2_items where id != '.$this->id.' and alias like '.$db->quote($db->escape($this->alias).'%').' order by alias asc');
					$aliases = $db->loadColumn();
					$suffix = 1;
					while(in_array($this->alias.'-'.$suffix, $aliases)) {
						$suffix++;
					}
					$this->alias = $this->alias.'-'.$suffix;
				}
			} else {
				if ($params->get('seo_advanced', 0) == '1') {
					if ($table->load(array('alias'=>$this->alias)) && ($table->id != $this->id || $this->id==0)) {
						$this->setError(JText::_('COM_DJCATALOG2_ERROR_UNIQUE_ALIAS'));
						return false;
					}
				} else {
					if ($table->load(array('alias'=>$this->alias,'cat_id'=>$this->cat_id)) && ($table->id != $this->id || $this->id==0)) {
						$this->setError(JText::_('COM_DJCATALOG2_ERROR_UNIQUE_ALIAS'));
						return false;
					}
				}
			}
		}
		if ($this->parent_id > 0) {
			$loaded = $table->load(array('id'=>$this->parent_id));
			if (!$loaded || (@$table->parent_id > 0)) {
				$this->parent_id = 0;
			}
			if ($this->id > 0) {
				$loaded = $table->load(array('parent_id'=>$this->id));
				if ($loaded) {
					$this->parent_id = 0;
				}
				
				if ($this->parent_id == $this->id) {
					$this->parent_id = 0;
				}
			}
		}
		
		return parent::store($updateNulls);
	}
}