<?php
/**
* @package RSFeedback!
* @copyright (C) 2010-2018 www.rsjoomla.com
* @license GPL, http://www.gnu.org/copyleft/gpl.html
*/
// No direct access
defined( '_JEXEC' ) or die( 'Restricted access' );

use Joomla\Registry\Registry;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Table\Table;

class RSFeedbackTableStatus extends Table
{
	public function __construct(& $db) {
		parent::__construct('#__rsfeedback_statuses', 'id', $db);
	}

	public function check() {
		if (!$this->id)
			$this->ordering = self::getNextOrder();
		
		if (isset($this->permissions) && is_array($this->permissions)) {
			$registry = new Registry;
			$registry->loadArray($this->permissions);
			$this->permissions = (string) $registry;
		} else {
			$this->permissions = '';
		}
		
		return true;
	}
	
	public function store($updateNulls = false) {
		$db		= $this->getDbo();
		$query	= $db->getQuery(true);
		
		$query->clear()
			->select($db->qn('id'))
			->from($db->qn('#__rsfeedback_statuses'))
			->where('LOWER('.$db->qn('name').') = '.$db->q(strtolower($this->name)));
			
		if ($this->id) $query->where($db->qn('id').' != '.$db->q($this->id));
		$db->setQuery($query);
		if ((int) $db->loadResult()) {
			throw new Exception(Text::_('COM_RSFEEDBACK_DUPLICATE_STATUS_NAME'));
			return false;
		}
		
		return parent::store($updateNulls);
	}
	
	public function delete($pk = null, $children = false) {
		if (!$this->default) {
			return parent::delete($pk, $children);
		}
		
		return true;
	}
}