<?php

/**
 * @package    JD Builder
 * @author     Team Joomdev <info@joomdev.com>
 * @copyright  2020 www.joomdev.com
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */
// No direct access.
defined('_JEXEC') or die;

jimport('joomla.application.component.modelitem');
jimport('joomla.event.dispatcher');

use Joomla\CMS\Factory;
use Joomla\Utilities\ArrayHelper;

/**
 * Jdbuilder model.
 *
 * @since  1.6
 */
class JdbuilderModelPage extends JModelItem {

   public $_item;

   /**
    * Method to auto-populate the model state.
    *
    * Note. Calling getState in this method will result in recursion.
    *
    * @return void
    *
    * @since    1.6
    *
    */
   protected function populateState() {
      $app = Factory::getApplication('com_jdbuilder');
      $user = Factory::getUser();

      // Check published state
      if ((!$user->authorise('core.edit.state', 'com_jdbuilder')) && (!$user->authorise('core.edit', 'com_jdbuilder'))) {
         $this->setState('filter.published', 1);
         //$this->setState('filter.archived', 2);
      }

      // Load state from the request userState on edit or from the passed variable on default
      if (Factory::getApplication()->input->get('layout') == 'edit') {
         $id = Factory::getApplication()->getUserState('com_jdbuilder.edit.page.id');
      } else {
         $id = Factory::getApplication()->input->get('id');
         Factory::getApplication()->setUserState('com_jdbuilder.edit.page.id', $id);
      }

      $this->setState('page.id', $id);

      // Load the parameters.
      $params = $app->getParams();
      $params_array = $params->toArray();

      if (isset($params_array['item_id'])) {
         $this->setState('page.id', $params_array['item_id']);
      }

      $this->setState('params', $params);
   }

   /**
    * Method to get an object.
    *
    * @param   integer $id The id of the object to get.
    *
    * @return  mixed    Object on success, false on failure.
    *
    * @throws Exception
    */
   public function getItem($id = null) {
      if ($this->_item === null) {
         $this->_item = false;

         if (empty($id)) {
            $id = $this->getState('page.id');
         }

         // Get a level row instance.
         $table = $this->getTable();

         // Attempt to load the row.
         if ($table->load($id)) {


            // Check published state.
            if(!JDB_LIVE_PREVIEW && !JDB_PREVIEW){
               if ($published = $this->getState('filter.published')) {
                  if (isset($table->state) && $table->state != $published) {
                     throw new Exception(JText::_('COM_JDBUILDER_ITEM_NOT_LOADED'), 403);
                  }
               }
            }

            // Convert the JTable to a clean JObject.
            $properties = $table->getProperties(1);
            $this->_item = ArrayHelper::toObject($properties, 'JObject');
         }
      }



      if (isset($this->_item->category_id) && $this->_item->category_id != '') {
         if (is_object($this->_item->category_id)) {
            $this->_item->category_id = ArrayHelper::fromObject($this->_item->category_id);
         }

         if (is_array($this->_item->category_id)) {
            $this->_item->category_id = implode(',', $this->_item->category_id);
         }

         $db = Factory::getDbo();
         $query = $db->getQuery(true);

         $query
                 ->select($db->quoteName('title'))
                 ->from($db->quoteName('#__categories'))
                 ->where('FIND_IN_SET(' . $db->quoteName('id') . ', ' . $db->quote($this->_item->category_id) . ')');

         $db->setQuery($query);

         $result = $db->loadColumn();

         $this->_item->category_id = !empty($result) ? implode(', ', $result) : '';
      }

      if (isset($this->_item->created_by)) {
         $this->_item->created_by_name = Factory::getUser($this->_item->created_by)->name;
      }

      if (isset($this->_item->modified_by)) {
         $this->_item->modified_by_name = Factory::getUser($this->_item->modified_by)->name;
      }

      return $this->_item;
   }

   /**
    * Get an instance of JTable class
    *
    * @param   string $type   Name of the JTable class to get an instance of.
    * @param   string $prefix Prefix for the table class name. Optional.
    * @param   array  $config Array of configuration values for the JTable object. Optional.
    *
    * @return  JTable|bool JTable if success, false on failure.
    */
   public function getTable($type = 'Page', $prefix = 'JdbuilderTable', $config = array()) {
      $this->addTablePath(JPATH_ADMINISTRATOR . '/components/com_jdbuilder/tables');

      return JTable::getInstance($type, $prefix, $config);
   }

   /**
    * Get the id of an item by alias
    *
    * @param   string $alias Item alias
    *
    * @return  mixed
    */
   public function getItemIdByAlias($alias) {
      $table = $this->getTable();
      $properties = $table->getProperties();
      $result = null;

      if (key_exists('alias', $properties)) {
         $table->load(array('alias' => $alias));
         $result = $table->id;
      }

      return $result;
   }

   /**
    * Method to check in an item.
    *
    * @param   integer $id The id of the row to check out.
    *
    * @return  boolean True on success, false on failure.
    *
    * @since    1.6
    */
   public function checkin($id = null) {
      // Get the id.
      $id = (!empty($id)) ? $id : (int) $this->getState('page.id');

      if ($id) {
         // Initialise the table
         $table = $this->getTable();

         // Attempt to check the row in.
         if (method_exists($table, 'checkin')) {
            if (!$table->checkin($id)) {
               return false;
            }
         }
      }

      return true;
   }

   /**
    * Method to check out an item for editing.
    *
    * @param   integer $id The id of the row to check out.
    *
    * @return  boolean True on success, false on failure.
    *
    * @since    1.6
    */
   public function checkout($id = null) {
      // Get the user id.
      $id = (!empty($id)) ? $id : (int) $this->getState('page.id');


      if ($id) {
         // Initialise the table
         $table = $this->getTable();

         // Get the current user object.
         $user = Factory::getUser();

         // Attempt to check the row out.
         if (method_exists($table, 'checkout')) {
            if (!$table->checkout($user->get('id'), $id)) {
               return false;
            }
         }
      }

      return true;
   }

   /**
    * Publish the element
    *
    * @param   int $id    Item id
    * @param   int $state Publish state
    *
    * @return  boolean
    */
   public function publish($id, $state) {
      $table = $this->getTable();

      $table->load($id);
      $table->state = $state;

      return $table->store();
   }

   /**
    * Method to delete an item
    *
    * @param   int $id Element id
    *
    * @return  bool
    */
   public function delete($id) {
      $table = $this->getTable();


      return $table->delete($id);
   }

}