<?php
/**
 * @package     Sven.Bluege
 * @subpackage  com_eventgallery
 *
 * @copyright   Copyright (C) 2005 - 2019 Sven Bluege All rights reserved.
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();

jimport( 'joomla.application.component.modeladmin' );

class EventgalleryModelImagetypeset extends JModelAdmin
{
    protected $text_prefix = 'COM_EVENTGALLERY';

    public function getTable($type = 'imagetypeset', $prefix = 'EventgalleryTable', $config = array())
    {
        return JTable::getInstance($type, $prefix, $config);
    }

    /**
     * Method to get the record form.
     *
     * @param array $data An optional array of data for the form to interogate.
     * @param boolean $loadData True if the form is to load its own data (default case), false if not.
     * @return JForm A JForm object on success, false on failure
     */
    public function getForm($data = array(), $loadData = true)
    {
        // Get the form.
        $form = $this->loadForm('com_eventgallery.imagetypeset', 'imagetypeset', array('control' => 'jform', 'load_data' => $loadData));

        if (empty($form)) {
            return false;
        }
        return $form;
    }

    protected function loadFormData()
    {
        // Check the session for previously entered form data.
        $data = JFactory::getApplication()->getUserState('com_eventgallery.edit.imagetypeset.data', array());

        if (empty($data))
        {
            $data = $this->getItem();
        }

		if (method_exists($this, 'preprocessData')){
        	$this->preprocessData('com_eventgallery.imagetypeset', $data);
		}
        return $data;
    }


    /**
     * save the imagetypeset
     *
     * @param array $data
     * @return bool|void
     */
    public function save($data) {
        $result = parent::save($data);

        if ($result===false) {
            return $result;
        }

        $id = $data['id'];
        if ($id==0) {
            $id = $this->getState('imagetypeset.id');
        }

        $default_imagetypeid = $data['imagetypesdefault'];


        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->delete('#__eventgallery_imagetypeset_imagetype');
        $query->where('imagetypesetid = '.$db->quote($id));
        $db->setQuery($query);
        $db->execute();

        if (count($data['imagetypes'])>0) {
            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->insert('#__eventgallery_imagetypeset_imagetype');
            $query->columns('imagetypesetid, imagetypeid, ordering');
            foreach($data['imagetypes'] as $i=>$imagetypeid) {

                $query->values($db->quote($id).','.$db->quote($imagetypeid).','.$i);
            }
            $db->setQuery($query);
            $db->execute();

            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->update('#__eventgallery_imagetypeset_imagetype');
            $query->set($db->quoteName('default') . ' = 0');
            $query->where('imagetypesetid = '.$db->quote($id));

            $db->setQuery($query);
            $db->execute();

            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->update('#__eventgallery_imagetypeset_imagetype');
            $query->set($db->quoteName('default') . ' = 1');
            $query->where('imagetypeid='.$db->quote($default_imagetypeid));
            $query->where('imagetypesetid = '.$db->quote($id));
            $db->setQuery($query);
            $db->execute();

        }
        return true;
    }

    public function delete(&$pks) {
        if (!parent::delete($pks)) {
            return false;
        }


        foreach($pks as $pk) {
            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->update('#__eventgallery_folder');
            $query->set('imagetypesetid = null');
            $query->where('imagetypesetid = '.$db->quote($pk));
            $db->setQuery($query);
            $db->execute();
        }

        return true;

    }

    public function setDefault($pks, $value) {

        $id = $pks[0];
        if ($value==1) {

            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->update('#__eventgallery_imagetypeset');
            $query->set($db->quoteName('default') . ' = 0');
            $db->setQuery($query);
            $db->execute();

            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->update('#__eventgallery_imagetypeset');
            $query->set($db->quoteName('default') . ' = 1');
            $query->where('id='.$db->quote($id));

            $db->setQuery($query);
            $db->execute();

        }
        return true;

    }



}
