<?php
class Page {
	private $page_id;
	private $pagetitle;
	private $menu;

  	public function __construct($registry) {
  	$this->config = $registry->get('config');
		$this->db = $registry->get('db');
		$this->request = $registry->get('request');

}
public function pages() {
  		$page_query = $this->db->query("SELECT * FROM site_content");
			
			if ($page_query->num_rows) {
				$this->page_id = $page_query->row['id'];
				$this->pagetitle = $page_query->row['pagetitle'];
				
				return $page_query->rows;
  	}
  	}
public function page($q) {
  		$page_query = $this->db->query("SELECT c.*,t.static_file 
  		FROM site_content c 
  		JOIN site_templates t
  		ON t.id=c.template
  		WHERE alias='$q'");
			
			if ($page_query->num_rows) {
			return $page_query->row;
  	}
  	}  	
public function nav($menu,$q,$parent='',$ul_class='') {  	
	if(!empty($parent)){
		$query_string="AND c.id=(SELECT parent FROM site_content WHERE alias='$parent')";
	}
	else{
		$query_string='';
	}
	$nav = $this->db->query("
	SELECT pagetitle,c.id,alias,isfolder ,menutitle
	FROM site_content c
	JOIN site_menus m
	ON c.id_menu=m.id
	WHERE parent=0
	AND hidemenu=0
	AND published=1
	AND menu='$menu'
	$query_string
	ORDER BY menuindex
	");
	//return $nav;
	
echo '<ul class="'.$ul_class.'">';
foreach($nav->rows as $link){
$id=$link['id'];
if($q==$link['alias']){
	$class=' class="active"';
}
else{
	$class='';
}
echo '<li'.$class.'>';

if($link['isfolder'] < 1){ 
echo '<a href="'.$link['alias'].'">'.utf8_encode($link['menutitle']).'</a>';
}
else{
echo '<span>'.$link['pagetitle'].'</span>';	
}
$subs=$this->db->query("
SELECT menutitle,alias FROM site_content
WHERE parent='$id'
AND hidemenu=0
AND published=1
ORDER BY menuindex
");
if($subs->num_rows > 0){
echo '<ul>';
foreach($subs->rows as $sub){
echo '<li><a href="'.$sub['alias'].'">'.utf8_encode($sub['menutitle']).'</a></li>';
}
echo '</ul>';	
}
echo '</li>';
}
echo '</ul>';
	
}

public function meta($q){
	$query_meta=$this->db->query("SELECT sm.keywords,sm.description FROM site_meta sm
JOIN site_content sc
ON
sm.id_page=sc.id
WHERE sc.alias='$q'");
if($query_meta->num_rows > 0){
$meta=$query_meta->row;
}
else{
	$meta='';
}
return $meta;
}

public function images($grupo,$q){
	$query_images=$this->db->query("SELECT image,text 
	FROM site_images i
	JOIN site_content c
	ON i.id_page=c.id
	WHERE id_group='$grupo' 
	AND c.alias='$q'
	AND i.state=1");
	$images=$query_images->rows;

return $images;	
}
}