<?php
/**
 * @package SP Page Builder
 * @author JoomShaper http://www.joomshaper.com
 * @copyright Copyright (c) 2010 - 2022 JoomShaper
 * @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPLv2 or later
*/

use Joomla\CMS\Factory;
use Joomla\CMS\Table\Table;
use Joomla\CMS\Access\Rules;

//no direct accees
defined ('_JEXEC') or die ('restricted aceess');

class SppagebuilderTablePage extends Table {

	function __construct(&$db) {
		parent::__construct('#__sppagebuilder', 'id', $db);
	}

	public function bind($array, $ignore = ''){
		//$array['title'] = preg_replace("@/\s+/@", ' ', $array['title']);

		$date = Factory::getDate();
		$user = Factory::getUser();
		
		if (empty($array['id'])) {
			if (!(int) $array['created_on']) {
				$array['created_on'] = $date->toSql();
			}

			if (empty($array['created_by'])) {
				$array['created_by'] = $user->get('id');
			}
		}
		// Bind the rules.
		if (isset($array['rules']) && is_array($array['rules']))
		{
			$rules = new Rules($array['rules']);
			$this->setRules($rules);
		}

		if ($this->_db->getServerType() == 'postgresql')
		{
			if (empty($array['id']))
			{
				unset($array['id']);
			}

			if (empty($array['hits']))
			{
				unset($array['hits']);
			}
		}
		
		return parent::bind($array, $ignore);
	}

	public function store($updateNulls = false)
	{
		$user = Factory::getUser();
		$date = Factory::getDate()->toSql();

		if ($this->id) {
			$this->modified = (string)$date;
			$this->modified_by = $user->get('id');
		}

		if (empty($this->hits)) {
			$this->hits = 0;
		}

		return parent::store($updateNulls);
	}

	public function check()
	{
		if (trim($this->title) === '')
		{
			return false;
		}

		return true;
	}
	
	protected function _getAssetTitle()
	{
		return $this->title;
	}
	
	/**
	 * Redefined asset name, as we support action control
	 */
	protected function _getAssetName() {
		$k = $this->_tbl_key;

		return 'com_sppagebuilder.page.'.(int) $this->$k;
	}
	
  /**
   * We provide our global ACL as parent
	 * @see Table::_getAssetParentId()
   */
	protected function _getAssetParentId(Table $table = NULL, $id = NULL)
	{
		$asset = Table::getInstance('Asset');
		$asset->loadByName('com_sppagebuilder');

		return $asset->id;
	}
}