<?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 DJClassifiedsModelPromotion extends DJClassifiedsAdminModel
{
	protected $form_name = 'promotion';

	public function __construct($config = array())
	{
		$config['event_after_save'] = 'onDJClassifiedsModelAdminAfterSave';
		$config['event_after_delete'] = 'onDJClassifiedsModelAdminAfterDelete';
		parent::__construct($config);
	}

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

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

		return $form;
	}

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

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

			$data->label = JText::_($data->label);
			$data->description = JText::_($data->description);

			$prom_prices = $this->getPromotionPrices($data->id);
			$subform_arr = array();
			foreach($prom_prices as $key => $prom_price){
				$subform_arr['prices'.$key] = array(
					'prom_pd_days' => $prom_price->days,
					'prom_pd_price' => $prom_price->price,
					'prom_pd_points' => $prom_price->points,
					'prom_pd_usergroup' => $this->getPromotionPricesUsergroups($prom_price->id)
				);
			}
			$data->set('prices', $subform_arr);
		}

		return $data;
	}
	
	function getPromotionPrices($id)
	{
		$db = JFactory::getDBO();
		$query = "SELECT * FROM #__djcf_promotions_prices WHERE prom_id=".$id." ORDER BY days";
		$db->setQuery($query);
		$prices = $db->loadObjectList();

		return $prices;
	}

	function getPromotionPricesUsergroups($id)
	{
		$db = JFactory::getDBO();
		$query = "SELECT usergroup_id FROM #__djcf_promotions_prices_usergroups WHERE prom_price_id=".$id;
		$db->setQuery($query);
		$ug_arr = $db->loadColumn();

		return $ug_arr;
	}
}