<?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('Restricted access');

class DjclassifiedsModelUserPlans extends DJClassifiedsModel
{
	function getPlans($where_type)
	{
		$app = JFactory::getApplication();
		$db	= JFactory::getDBO();
		$user = JFactory::getUser();
		
		$query = "SELECT *, ps.id as id, p.name as plan_name, p.description as plan_description "
				."FROM #__djcf_plans_subscr ps "
				."INNER JOIN #__djcf_plans p ON ps.user_id=".$user->id." AND p.id=ps.plan_id "
				."WHERE ".($where_type == 'active' ? $this->getPlanActiveWhere() : $this->getPlanExpiredWhere())." "
				."ORDER BY ps.date_start DESC";
		$db->setQuery($query);
		$plans = $db->loadObjectList();
		
		foreach($plans as $key => $plan){
			$query = "SELECT p.item_name, p.item_id, p.`date`, p.is_renew, i.name as i_name, i.alias as i_alias, i.cat_id, i.c_name, i.c_alias, i.region_id, i.r_name, i.r_alias "
					."FROM (SELECT subscr_id, item_id, item_name, `date`, 0 is_renew FROM #__djcf_plans_subscr_items UNION SELECT subscr_id, item_id, '', `date`, 1 is_renew FROM #__djcf_plans_subscr_items_renew) p "
					."LEFT JOIN (SELECT i.*, c.name c_name, c.alias c_alias, r.id r_id, r.name r_name, r.alias r_alias FROM #__djcf_items i LEFT JOIN #__djcf_categories c ON c.id=i.cat_id LEFT JOIN #__djcf_regions r ON r.id=i.region_id) i ON i.id=p.item_id " 
					."WHERE p.subscr_id=".$plan->id." "
					."ORDER BY p.`date` DESC";
			$app->triggerEvent('onDJClassifiedsUserplansItemsQuery', array(&$query));
			$db->setQuery($query);
			$plan->items = $db->loadObjectList();

			$plans[$key]->show_labels = count(explode(',', $plan->hidden_labels)) < 16 ? true : false;

			// view backward compatibility START
			$registry = new JRegistry();
			$registry->loadString($plan->plan_params);
			$registry->set('days_limit', ($plan->date_exp == '0000-00-00 00:00:00' ? '0' : 'X'));
			$plan->plan_params = json_encode($registry);
			// view backward compatibility END
		}

		return $plans;
	}
}