<?php

/*
 * @version     4.6.2
 * @package     com_mymaplocations
 * @copyright   JoomUnited (C) 2011. All rights reserved.
 * @license     http://www.gnu.org/copyleft/gpl.html GNU/GPL
 * ***@author      Created by JoomUnited (C)
 */

defined('_JEXEC') or die;
jimport('joomla.version');
// import Joomla Categories Library
jimport('joomla.application.categories');
if (!(class_exists('MyMapLocationsHelper'))) {

    $helper = JPATH_SITE . '/components/com_mymaplocations/helpers/mymaplocations.php';
    if (file_exists($helper)) {
        require_once($helper);
    }
}



$lang = JFactory::getLanguage();
$app = JFactory::getApplication();
$mapid = $params->get('mapid');
$height = $params->get('height');
$width = $params->get('width');
$zoom = $params->get('zoom');
$type = $params->get('type');
$mode = $params->get('map_mode', 1);
$order=$params->get('filter_order','a.view');
$limit=$params->get('limit',0);
$cat_id=$params->get('cat_id','');
$map_display=$params->get('map_display',0);
$db = JFactory::getDBO();
$nullDate = $db->getNullDate();
$now=JFactory::getDate()->toSql();
$query = $db->getQuery(true);
$query->select('a.name as nom');
				$query->select('a.id as extra_id');
    				$query->select('a.*');
				$query->select('c.alias as c_alias');
				$query->select('u.name as username');
				$query->where('a.published=1');
                $query->where("(a.date_exp	 = ".$db->Quote($nullDate)." OR a.date_exp	 >= ".$db->Quote($now).")");

if(!empty($cat_id))
{
    $query->where('a.cat_id IN('.implode(",",$cat_id).')');
     
     }
    $query->from('#__djcf_items AS a');
	$query->join('LEFT', '#__djcf_categories AS c ON a.cat_id = c.id');
	$query->join('LEFT', '#__users u ON u.id = a.user_id');

 if($order=="rdate")
 {
 $query->order( $db->escape( 'extra_id desc'  ) );
 }
else if($order=="date")
 {
 $query->order( $db->escape( 'extra_id asc'  ) );
 }
else if($order=="alpha")
 {
 $query->order( $db->escape( 'name asc'  ) );
 }
 else if($order=="rdate")
 {
 $query->order( $db->escape( 'name desc'  ) );
 }
  
 if($limit==0)
 {
$db->setQuery($query);
 }
 else
{
$db->setQuery($query,0,$limit);
     
 }

$result = $db->loadObjectList();
if (empty($result)) {
    return;
}

MyMaplocationsHelper::loadLanguage();
$result[0]->google_maptype = $params->get('google_maptype', 'ROADMAP');
$result[0]->bing_maptype = $params->get('bing_maptype', 'road');
$result[0]->openmapstyle=$params->get('openmapstyle', 1);
$result[0]->map_design=$params->get('map_design', 1);
$result[0]->map_layer=$params->get('map_layer',1);
$result[0]->maplayer_url=$params->get('maplayer_url','');
$result[0]->component='com_djclassifieds';
$show_toolbar=$params->get('show_toolbar',1);

require JModuleHelper::getLayoutPath('mod_dj_mymaplocationsmaps', $params->get('layout', 'default'));