<?php 
/**
 * @version     $Id$
 * @author      OvaTheme
 * @package     Joomla.Site
 * @subpackage  com_ovacomposer
 * @copyright   Copyright (C) 2013 OvaTheme. All rights reserved.
 * @license     License GNU General Public License version 2 or later; see LICENSE.txt, see LICENSE.
 */

class OvaData{
	public $doc=null;
	private $version="";
	public function __construct(){
		$this->doc = JFactory::getDocument();
		$arr = explode('.',JVERSION);
		$this->version = $arr[0];
	}

	public static function addLayout($file){
		jimport( 'joomla.filesystem.file' );
		$tpl 		= JFactory::getApplication()->getTemplate();
		$override_tem 	= JPATH_BASE.'/templates/'.$tpl.'/html/ova_layout/'.$file.'.php';
		$origin_tem 	= JPATH_PLUGINS . "/system/ova/ova_layout/".$file.'.php';
		if(JFile::exists($override_tem)){
			return array("check"=>true,"src"=>$override_tem);
		}else if(JFile::exists($origin_tem)){
			return array("check"=>true,"src"=>$origin_tem);
		}else{
			return array("check"=>false,"src"=>"");
		}
	}

	public function checkSidebar(){
		$app        = JFactory::getApplication();
		$template   = $app->getTemplate(true);
		$params     = $template->params;
		return $params->get('type');
	}

	public function getContentRecent($id=0,$limit='ALL'){
		$db = JFactory::getDbo();
		$query=$db->getQuery(true);
		$where = array('a.state=1');
		if($id!=0){
			$where[]='catid='.$id;
		}
		$query 		->select('a.id,a.title,a.alias,a.catid,a.introtext,a.created,a.images,b.alias AS categoryalias')
					->from('#__content AS a')
					->join('INNER','#__categories AS b ON (a.catid = b.id)')
					->where($where)
					->order('created DESC');
		$db->setQuery($query,0,$limit);
		return $db->loadObjectList();
	}

	public function getContentById($id){
		$db = JFactory::getDbo();
		$query=$db->getQuery(true);
		$where = array('a.state=1','a.id='.$id);
		$query 		->select('a.id,a.title,a.alias,a.catid,a.introtext,a.images,b.alias AS categoryalias')
					->from('#__content AS a')
					->join('INNER','#__categories AS b ON (a.catid = b.id)')
					->where($where);
		$db->setQuery($query);
		return $db->loadObject();
	}

	public function isImagesContent($array){
		$array = json_decode($array);
		if($array->image_intro==''){
			return false;
		}
		return true;
	}

	public function getImageContent($array){
		return json_decode($array)->image_intro;
	}

	public function getContentlink($item){
		require_once (JPATH_SITE.'/components/com_content/helpers/route.php');
		return JRoute::_(ContentHelperRoute::getArticleRoute($item->id.':'.$item->alias, $item->categoryalias));
	}


	public function getK2Recent($id=0,$limit="ALL"){
		$db = JFactory::getDbo();
		$query=$db->getQuery(true);
		$where = array('a.published=1');
		if($id!=0){
			$where[]='catid='.$id;
		}
		$query 		->select('a.id,a.title,a.alias,a.catid,a.introtext,a.extra_fields,a.created,b.name AS catname,b.alias AS categoryalias')
					->from('#__k2_items AS a')
					->join('INNER', '#__k2_categories AS b ON (a.catid = b.id)')
					->where($where)
					->order('created DESC');
		$db->setQuery($query,0,$limit);

		return $db->loadObjectList();
	}

	public function getK2byId($id){
		$db = JFactory::getDbo();
		$query=$db->getQuery(true);
		$where = array('a.published=1','a.id='.$id);
		$query 		->select('a.id,a.title,a.alias,a.catid,a.extra_fields,a.introtext,b.alias AS categoryalias')
					->from('#__k2_items AS a')
					->join('INNER','#__k2_categories AS b ON (a.catid = b.id)')
					->where($where);
		$db->setQuery($query);
		return $db->loadObject();

	}

	public function getImageK2($id,$size='XS'){
		return JURI::root().'media/k2/items/cache/'.md5("Image".$id).'_'.$size.'.jpg';
	}

	public function isImagesK2($id){
		jimport('joomla.filesystem.file') ;
		if(!JFile::exists(JPATH_SITE.'/media/k2/items/cache/'.md5("Image".$id).'_XS.jpg')){
			return false;
		}else{
			return true;
		}
	}

	public function getRouteOva($id){
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select('extension_id')->from('#__extensions')->where("element='com_ovacomposer'");
		$db->setQuery($query);
		$extenid = $db->loadResult();

		$query= $db->getQuery(true);
		$query->select('id,params')->from('#__menu')->where("component_id=".$extenid." and published = 1");
		$db->setQuery($query);
		$items = $db->loadObjectList();
		$menuid = 0;
		foreach ($items as $key => $item) {
			if(json_decode($item->params)->designid == $id){
				$menuid=$item->id;
				break;
			}
		}
		if($menuid!=0){
			return JRoute::_('index.php?option=com_ovacomposer&view=page&Itemid='.$menuid);
		}else{
			return JRoute::_('index.php?option=com_ovacomposer&view=page&id='.$id);
		}
	}

	public function getK2link($id,$alias,$catid,$categoryalias){
		require_once (JPATH_SITE.'/components/com_k2/helpers/route.php');
		return urldecode(JRoute::_(K2HelperRoute::getItemRoute($id.':'.urlencode($alias), $catid.':'.urlencode($categoryalias))));
	}

	public function loadModule($position,$count=0,$style="none"){
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select("*")->from("#__modules")->where('position=\''.$position.'\'');
		$db->setQuery($query);
		$result = $db->loadObjectList();
		if(count($result)==1){
			$title = $result[0]->title;
			$mod = $result[0]->module;
		}else{
			$title = $result[$count]->title;
			$mod = $result[$count]->module;
		}
		$module = JModuleHelper::getModule( $mod, $title );
		$attribs['style'] = $style;
		return JModuleHelper::renderModule( $module,$attribs);
	}

	public function loadModuleId($id){
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select("*")->from("#__modules")->where('id=\''.$id.'\'');
		$db->setQuery($query);
		$result = $db->loadObject();
		$title = $result->title;
		$mod = $result->module;
		$module = JModuleHelper::getModule( $mod, $title );
		$module->content = JModuleHelper::renderModule( $module,array('style'=>'none'));
		return $module;
		//return JModuleHelper::renderModule( $module );
	}

    public function getk2Category($id=0,$limit="ALL"){
        $db = JFactory::getDbo();
        $query=$db->getQuery(true);
        $where = array('a.published=1');
        if($id!=0){
            $where[]='catid='.$id;
        }
        $query 		->select('a.id,a.title,a.alias,a.extra_fields,a.introtext, a.ordering, a.extra_fields_search')
            ->from('#__k2_items AS a')
            ->join('INNER', '#__k2_categories AS b ON (a.catid = b.id)')
            ->where($where)
            ->order('a.ordering DESC');
        $db->setQuery($query,0,$limit);

        return $db->loadObjectList();
    }

    // Load values of extrafield
    public function getvalextrafield($id){
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$where	= array('a.published=1');
		if($id!=0){
			$where[]='a.id='.$id;
		}
		$query 		->select('a.value, a.name')
            ->from('#__k2_extra_fields AS a')            
            ->where($where)
            ->order('ordering DESC');
        $db->setQuery($query);
        return $db->loadObject();
    }

    // Load values of extrafield
    public function getextraname($id){
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$where	= array('a.published=1');
		if($id!=0){
			$where[]='a.id='.$id;
		}
		$query 		->select('a.name,a.value')
            ->from('#__k2_extra_fields AS a')            
            ->where($where)
            ->order('ordering DESC');
        $db->setQuery($query);
        return $db->loadObject();
    }

}