<?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\CMS\Table\Table;
use Joomla\CMS\Factory;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Application\ApplicationHelper;
class Djcatalog2TableProducers extends Table
{
	public function __construct(&$db)
	{
		parent::__construct('#__djc2_producers', 'id', $db);
	}
	function bind($array, $ignore = '')
	{	
		if(empty($array['alias'])) {
			$array['alias'] = $array['name'];
		}
		$array['alias'] = ApplicationHelper::stringURLSafe($array['alias']);
		if(trim(str_replace('-','',$array['alias'])) == '') {
			$array['alias'] = Factory::getDate()->format('Y-m-d-H-i-s');
		}
		
		return parent::bind($array, $ignore);
	}
	public function store($updateNulls = false)
	{
		$date	= Factory::getDate();
		$user	= Factory::getUser();
		$app = Factory::getApplication();
		$db = Factory::getDbo();
		
		if (!$this->id) {
			if (!intval($this->created)) {
				$this->created = $date->toSql();
			}
			if (empty($this->created_by)) {
				$this->created_by = $user->get('id');
			}
		}	
		
		$task = $app->input->get('task');
		$table = Table::getInstance('Producers', 'Djcatalog2Table');
		
		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_producers where id != '.$this->id.' and alias like '.$db->quote($db->escape($this->alias).'%').' order by alias asc');
				$aliases = $db->loadColumn();
				$suffix = 2;
				while(in_array($this->alias.'-'.$suffix, $aliases)) {
					$suffix++;
				}
				$this->alias = $this->alias.'-'.$suffix;
			}
		} else {
			if ($this->language == '*') {
				if ($table->load(array('alias'=>$this->alias)) && ($table->id != $this->id || $this->id==0)) {
					$this->setError(Text::_('COM_DJCATALOG2_ERROR_UNIQUE_ALIAS'));
					return false;
				}
			} else {
				$query = $db->getQuery(true);
				$query->select('COUNT(*)')
					->from('#__djc2_producers')
					->where('alias LIKE ' . $db->quote($this->alias))
					->where('id != '.(int)$this->id)
					->where('(language = '. $db->quote($this->language).' OR language = '.$db->quote('*').')');

				$db->setQuery($query);
				$result = $db->loadResult();
				if ($result) {
					$this->setError(Text::_('COM_DJCATALOG2_ERROR_UNIQUE_ALIAS'));
					return false;
				}
				
			}
		}
		
		return parent::store($updateNulls);
	}
}