<?php
/**
 * @package DJ-Classifieds
 * @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
 */

defined('_JEXEC') or die;

class DJClassifiedsModelPlan extends DJClassifiedsAdminModel
{
	public function __construct($config = array())
	{
		$config['event_after_save'] = 'onProducerAfterSave';
		$config['event_after_delete'] = 'onProducerAfterDelete';
		parent::__construct($config);
	}

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

	public function getForm($data = array(), $loadData = true)
	{
		// Initialise variables.
		$app	= JFactory::getApplication();

		// Get the form.
		$form = $this->loadForm('com_djclassifieds.plan', 'plan', array('control' => 'jform', 'load_data' => $loadData));
		if (empty($form)) {
			return false;
		}

		return $form;
	}

	protected function loadFormData()
	{
		$data = JFactory::getApplication()->getUserState('com_djclassifieds.edit.plan.data', array());

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

			if($data->id){
				$data->usergroup_access = $this->getUgAccess($data->id);
				$data->hidden_labels = explode(',', $data->hidden_labels);
				$data->groups_assignment = explode(',', $data->groups_assignment);
				$data->groups_deassignment = explode(',', $data->groups_deassignment);
				$data->groups_assignment_exp = explode(',', $data->groups_assignment_exp);
			}
		}

		return $data;
	}
	
	private function getUgAccess($plan_id)
	{
		$db = JFactory::getDBO();			
		$query = "SELECT group_id FROM #__djcf_plans_groups WHERE plan_id=".$plan_id;
		$db->setQuery($query);
		$ug_arr = $db->loadColumn();

		return $ug_arr;
	}
	
	protected function prepareTable($table)
	{
		$table->name = htmlspecialchars_decode($table->name, ENT_QUOTES);

		if (empty($table->id)) {
			if (empty($table->ordering)) {
				$db = JFactory::getDbo();
				$db->setQuery('SELECT MAX(ordering) FROM #__djcf_plans');
				$max = $db->loadResult();

				$table->ordering = $max+1;
			}
		}

		$table->hidden_labels = is_array($table->hidden_labels) ? implode(',', $table->hidden_labels) : '';
		$table->groups_restriction = $table->groups_restriction ? $table->groups_restriction : '';
		$table->groups_assignment = is_array($table->groups_assignment) ? implode(',', $table->groups_assignment) : '';
		$table->groups_deassignment = is_array($table->groups_deassignment) ? implode(',', $table->groups_deassignment) : '';
		$table->groups_assignment_exp = is_array($table->groups_assignment_exp) ? implode(',', $table->groups_assignment_exp) : '';
	}

	protected function getReorderConditions($table = null)
	{
		$condition = array();
		return $condition;
	}

}