<?php

include_once("common.php");
require_once("Config.php");
require_once("DB.php");
require_once("ecMisc.php");
require_once("ecAPP.php");
require_once("HTML/Template/Flexy.php");
require_once("ecAuth.php");
require_once("ecAuth/db.php");
require_once("ecMisc.php");
require_once("ecDDL.php");

$app = new ecAPP($config);
$options = array(
'templateDir'    => $app->settings["ecAPI"]["TEMPLATE_DIR"],
'compileDir'    => $app->settings["ecAPI"]["COMPILE_DIR"]
);


$_REQUEST["index"] = (int) $_REQUEST["index"];
if ( $_REQUEST["index"] == 0  )
	$_REQUEST["index"] = (-1);

$tpl = new tpl();
//PISAR ID DE FOTGRAFOS DE CEREMONIAS POR LOS DE FIESTAS
if($_REQUEST["index"]=="3092"){
$_REQUEST["index"] = "3072";	
}

// 2010-08 URL Amigables
if ( !$_REQUEST["furl"]  )
{
	if ( is_numeric($_REQUEST["index"])  ) 
	{
		$data = $tpl->linkcat( $_REQUEST["index"]  );
		if ( $data   )
		{
			Header( "HTTP/1.1 301 Moved Permanently" );
			Header( "Location: ".$data ); 
		}
	}
}

// Reglas Especiales
if ( $_REQUEST["index"] == "3052"  )
{
	include("buscadorIglesias.php");
	exit();
}
if ( $_REQUEST["index"] == "3054"  )
{
	$_REQUEST["cat"] = urldecode("Matrimonio%20Civil%20-%20La\%20Ley");
	$_GET["cat"] = urldecode("Matrimonio%20Civil%20-%20La%20Ley");
	include("reportajes.php");
	exit();
}
if ( $_REQUEST["index"] == "3056"  )
{
	$_REQUEST["cat"] = urldecode("Matrimonio%20Civil%20-%20Contrato");
	$_GET["cat"] = urldecode("Matrimonio%20Civil%20-%20Contrato");
	include("reportajes.php");
	exit();
}
if ( $_REQUEST["index"] == "3058"  )
{
	$_REQUEST["cat"] = urldecode("Matrimonio%20Religioso");
	$_GET["cat"] = urldecode("Matrimonio%20Religioso");
	include("reportajes.php");
	exit();
}
if ( $_REQUEST["index"] == "3088" )
{
	include("buscadorEspecifico.php");
}
if ( $_REQUEST["index"] == "3036"  )
{
	/*
	$_REQUEST["cat"] = urldecode("Matrimonio%20Religioso");
	$_GET["cat"] = urldecode("Matrimonio%20Religioso");
	include("reportajes.php");
	*/
	Header("Location: /herramientas/mercado-novias");
	exit();
}


include("auth.php");

if("http://".$_SERVER["SERVER_NAME"]."/" != "http://www.denovios.com/") {
	Header("Location: http://www.denovios.com". $_SERVER["REQUEST_URI"]);
	exit;
}


$app->do_query(" UPDATE categorias SET visitas_cat = visitas_cat + 1 WHERE id______cat = '".(int) $_REQUEST["index"]  ."'  ");

$tpl->addParams($app->readRecord("CATEGORIAS", "ID______CAT='" . $app->quotesql($_REQUEST["index"]) . "'"));
$tpl->INDEX = (int)$_REQUEST["index"]; 
if ( $tpl->ACTGALERCAT == "S" )
{
	$tpl->ACTIVAR_GALERIA = true;
}

/*
	Old
$_SESSION["cat"] = $tpl->ID______CAT;
setcookie("cat", $tpl->ID______CAT, time()+3600*3600, "/");
*/
// Guardamos la ultima categoria que visito la novia

$_SESSION["lastCatVisited"] = (int)$_REQUEST["index"];
$_REQUEST["CATEGORIA"] = (int)$_REQUEST["index"];

$tpl->breadcrumbs = array();

$tmp["PADRE___CAT"] = $tpl->PADRE___CAT;
$tmp["ID______CAT"] = $tpl->ID______CAT;

while($tmp["PADRE___CAT"] != $tmp["ID______CAT"]) {	

	$tmp = $app->readRecord("CATEGORIAS", "ID______CAT='" . $app->quotesql($tmp["PADRE___CAT"]) . "'");
	$tpl->breadcrumbs[] = $tmp;
}
foreach( $tpl->breadcrumbs as $k => $v )
{
	if ( $v["ID______CAT"] == -1  )
		unset( $tpl->breadcrumbs[$k] );
}
$tpl->breadcrumbs = array_reverse($tpl->breadcrumbs);


function childrenCategory( $cat , &$children  )
{
	global $app;
	static $i;
	
	if ( $i < 1000 )
	{	
		$query = $app->do_query(" SELECT ID______CAT FROM categorias WHERE padre___cat = '".$app->quotesql( $cat )."' " );
		while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
		{
		
			$children[] = $reg["ID______CAT"];
			childrenCategory( $reg["ID______CAT"]  , $children );
		}
	}
	else
	{
		return false;
	}
	
	if ( $i>10000 )
		die("no paro");
	
	$i++;
}


// Genero el Select de Proveedores Tree
$model = new ecDDL();

include($app->settings["ecAPI"]["DATAMODEL"]);

$modelArray["PROVEEDORES"]["fields"]["CATEGORIPRO"]["inputType"] = str_replace("]","|multiple=no]",$modelArray["PROVEEDORES"]["fields"]["CATEGORIPRO"]["inputType"]);


$model->createFromArray($modelArray);
$table = "PROVEEDORES";
$field = "CATEGORIPRO";
$thisfield=$model->getTableField($field,$table);
$options_widget="";
if(eregi("\\[(.*)\\]$",$thisfield->inputType,$regTags))
{
	$options_widget=$regTags[1];
}
$fieldtype=ereg_replace("\\[.*$","",$thisfield->inputType);

require_once("ecInputWidget/$fieldtype.php");
$classname="ecInputWidget_${fieldtype}";
$widget = new $classname($thisfield,$app->db,$field,$table,(int)$_REQUEST["index"]);
if($options_widget)
{
	$widget->setOptions($options_widget);
}
//$widget->setValue = 46;
$tpl->SERVICIOS = str_replace('CATEGORIPRO[]','index',$widget->getHTML());
$js = 	$widget->getJS();


// JS de Comunas
/*
$js = "
comunas =
{
";
$query = $app->do_query(" SELECT * FROM comunas ORDER BY region__com ASC , nombre__com  " );
while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
{
	$region[ $reg["REGION__COM"] ][] = $reg;
}

foreach ( $region as $k => $v )
{
	
	$js .= "  \"".$k."\": [ ";	
	
	for( $i=0;$i<count($v);$i++)
	{	
		if ( $i == 0 )
			$js .=  " \"".$v[$i]["NOMBRE__COM"]."|".$v[$i]["ID______COM"]."\" ";
		else
			$js .=  " ,  \"".$v[$i]["NOMBRE__COM"]."|".$v[$i]["ID______COM"]."\" ";
	}
	$js .= " ] , ";
}


$js .= "
}
";

flog('/tmp/comunas.js' , $js);
*/

//Categorias
// Paginamos si son mas de 16 Categorias
if ( !isset($limit) )
	$limit = 64;
// Existe la Pagina
if ( isset( $_REQUEST['pag'] )  )
{
	$pag = (int)$_REQUEST['pag'];
	$offset = ($pag-1)*$limit;
}
else
{
	$pag = 1;
	$offset = 0;
}

// Filtro para Categorias
if ( eregi('51-', $_SERVER["REQUEST_URI"]  ) )
	$filtrocat = " AND  ID______CAT NOT IN ( 51 ) ";
if ( eregi('60-', $_SERVER["REQUEST_URI"]  ) )
	$filtrocat = " AND  ID______CAT NOT IN ( 60 ) ";

if ( eregi('0-Productos', $_SERVER["REQUEST_URI"]  ) )
	$filtrocat = " AND  ID______CAT NOT IN ( -1 , 3081 , 3112 ) ";

if($_REQUEST["index"]=="-1"){
	
	$filtrocat = " AND  ID______CAT NOT IN ( 3112 ) ";
	
}


$qid = $app->initReadLoop("CATEGORIAS", "PADRE___CAT='" . $app->quotesql($_REQUEST["index"]) . "' $filtrocat   "," random()  LIMIT $limit  ");
$i=0;
if ( $tpl->TEMPLATECAT == "categoria_lunademiel.html"  )
	$itemColum = 4;
else
	$itemColum = 3;
while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {

	if ( $i%2 == 0 )	
		$row['CLASS'] = 'block3';
	else
		$row['CLASS'] = 'block5';

	if ( $i == 2 OR $i == 6 OR $i == 10 OR $i == 14 OR $i == 18 OR $i == 22 )
	{
		$i++;
	}

	$tpl->categorias[floor($count/$itemColum)][$count%$itemColum] = $row;
	$count++;
	$i++;
	//print_r($tpl->categorias);
}
// Paginamos Categorias
// Contamos Registros
$query = $app->do_query("SELECT COUNT(ID______CAT) FROM categorias WHERE PADRE___CAT='" . $app->quotesql($_REQUEST["index"]) . "'" );
while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
{
	$total = $reg["COUNT"];
	
	$paginas = ceil((int)$total/$limit);
	for($i=1;$i<=$paginas;$i++)
	{
	
		if ( $i == $paginas )
			$label = $i;
		else
			$label = $i.' -';
		
	
		if (  $pag == $i )
		{
			$tpl->pag[ $i ]['ACTIVE'] = true;
			$tpl->pag[ $i ]['LABEL'] = $label;						
		}
		else
			$tpl->pag[ $i ]['LABEL'] = $label;
		
	}
	// Analizamos Siguiente y Atras
	if (  isset( $tpl->pag[ $pag + 1 ] )  )
		$tpl->next = $pag+1;
	if (  isset( $tpl->pag[ $pag - 1 ] )  )
		$tpl->prev = $pag-1;
}

$tpl->region = $_REQUEST["region"];
$tpl->{"region_" . $_REQUEST["region"]} = "selected";
$tpl->comuna = $_REQUEST["comuna"];

$qid = $app->initReadLoop("SERVICIOS", "", "NOMBRE__SER ASC");
while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
	if($row["ID______SER"] == $_REQUEST["servicios"]) $row["selected"] = "selected";
	$tpl->servicios[] = $row;
}
# POR MIENTRAS
if($_REQUEST["servicio"]) {
	# 
}
if(isset($_REQUEST["comuna"]) AND $_REQUEST["comuna"] != "0" )
	$filtro .= " AND UPPER(COMUNA__PRO) LIKE '%" . $app->quotesql(preg_replace("/[^A-Z0-9_]+/", "%", strtoupper($_REQUEST["comuna"]))) . "%'";

if(isset($_REQUEST["region"]) AND $_REQUEST["region"] != '%')
{ 
	$filtro .= " AND UPPER(REGION__PRO) LIKE '%" . $app->quotesql(preg_replace("/[^A-Z0-9_]+/", "%", strtoupper($_REQUEST["region"]))) . "%'";
}
if(isset($_REQUEST["disenador"]) AND $_REQUEST["disenador"] != '%')
{
	$filtro .= " AND UPPER(NOMBRE__PRO) LIKE '%" . $app->quotesql( strtoupper($_REQUEST["disenador"])  ) . "%'";
}

if(isset($_REQUEST["coleccion"]) AND $_REQUEST["coleccion"] != '%')
{
	$filtro .= " AND    id______pro || '_' || '".$app->quotesql( $_REQUEST["coleccion"] )."' IN ( SELECT proveedoprd || '_' || coleccioprd FROM productos WHERE coleccioprd = '".$app->quotesql( $_REQUEST["coleccion"] )."'  )  ";
}

// Busco dentro de los Hijos Tambien
if ( $_REQUEST["search"] == "1" )
{
	
	$cateshijas = array();
	childrenCategory( (int)$_REQUEST[index] , $cateshijas );
	if ( is_array( $cateshijas ) )
	{
		foreach ( $cateshijas as $k => $v )
		{
			$newfiltro .= "  OR  ".likeCheckbox("CATEGORIPRO",  $v  )."   ";	
		}
	}
	// Tengo que cambiar Filtro para el Orden Aleatorio
	$filtro .= "  AND  '".$app->quotesql( $_REQUEST[index] )."' = '".$app->quotesql( $_REQUEST[index] )."'   ";
	
	$tpl->varsurl = '&region='.$_REQUEST["region"].'&comuna='.$_REQUEST["comuna"]."&search=1";
	
	
}


$total = $app->readRecord("PROVEEDORES", likeCheckbox("CATEGORIPRO", $app->quotesql($tpl->ID______CAT),$newfiltro) . " $filtro AND ACTIVO__PRO = 'S' AND CADUCA__PRO >= NOW()", "", "COUNT(*) AS C");
$total = $total["C"];
$PERPAGE = 16;
$count = 0;
if($_REQUEST["pagina"] < 1) $_REQUEST["pagina"] = 1;
$skip = ($_REQUEST["pagina"] - 1) * $PERPAGE;
if($skip > 0) $tpl->PAGINA_ANTERIOR = $_REQUEST["pagina"] - 1;
if($total > $PERPAGE * $_REQUEST["pagina"]) $tpl->PAGINA_SIGUIENTE = $_REQUEST["pagina"] + 1;
$tpl->paginas = array();
if($total) {
	$total_paginas = floor(($total + $PERPAGE - 1) / $PERPAGE);
	if($total_paginas > 5) {
		$pivote = $_REQUEST["pagina"] - 2;
		if($pivote < 2) $pivote = 2;
		$tpl->paginas[] = 1;
		$tpl->paginas[] = $pivote;
		$tpl->paginas[] = $pivote + 1;
		$tpl->paginas[] = $pivote + 2;
		$tpl->paginas[] = $pivote + 3;
		$tpl->paginas[] = $pivote + 4;
		$tpl->paginas[] = $total_paginas;
		foreach($tpl->paginas as $k => $v) {
			if($v < 1 || $v > $total_paginas) {
				unset($tpl->paginas[$k]);
			}
		}
	} else {
		for($i = 1; $i <= $total_paginas; $i++) {
			$tpl->paginas[] = $i;
		}
	}
}
#$_SESSION = array();
// Existe Orden Aleatorio por Session PARA ESTA CATEGORIA
if (  !isset($_SESSION['orden'][$tpl->ID______CAT.$filtro]) )
{
	
	
	$qid = $app->do_query("SELECT ID______PRO FROM PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT , $newfiltro ) . "  AND  activo__pro = 'S'  AND  asociadopro = 'S' $filtro   ORDER BY RANDOM()");
	
	
	//$qid = $app->do_query("SELECT ID______PRO FROM PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT , $newfiltro ) . "  AND  activo__pro = 'S'  AND CADUCA__PRO >= NOW() AND  asociadopro = 'S' ORDER BY RANDOM()");
	
	
#	print "SELECT ID______PRO FROM PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT , $newfiltro ) . "  AND  activo__pro = 'S'  AND  asociadopro = 'S' $filtro   ORDER BY RANDOM()";
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))
	{
		$_SESSION['orden'][$tpl->ID______CAT.$filtro][ $row["ID______PRO"] ] = true;
	}
}


// Seleciono los Elementos en el Limit y Offset
$i = 0;
#print_r($_SESSION['orden']);
#print_r($_SESSION['orden'][$tpl->ID______CAT.$filtro] );
if ( is_array( $_SESSION['orden'][$tpl->ID______CAT.$filtro] ) ){
	$ids = array_keys($_SESSION['orden'][$tpl->ID______CAT.$filtro]);
	for( $i = 0 ; $i < count( $ids ) ; $i++ )
		if ( $i == 0 )	
			$values = "  (  ".$ids[$i]." , ".$i."  )   ";	
		else
			$values = $values . "  ,  (  ".$ids[$i]." , ".$i."  )   ";
		
}


// Los que Pagan

if ( $_REQUEST["op"] == "NOP" )
	$extra = " LIMIT 8  ";
$extra = " LIMIT 8  ";
$filtro = "AND  activo__pro = 'S' AND CADUCA__PRO >= NOW()";
#$_SESSION =array();	

#print "$tpl->ID______CAT.$filtro.$extra";	

if ( !isset(  $_SESSION['proveedores'][$tpl->ID______CAT.$filtro.$extra]  )    ) {
	$provs=array();
	$qid = $app->do_query("SELECT * from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT , $newfiltro  ) . "    AND asociadopro = 'S'  $filtro  ORDER BY RANDOM()   $extra  ");
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))
		$provs[] = $row;
	$_SESSION['proveedores'][$tpl->ID______CAT.$filtro.$extra] = $provs;
#	print "QUERY!";
#	print "SELECT * from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT , $newfiltro  ) . "  AND  activo__pro = 'S'  AND  asociadopro = 'S'  $filtro    ORDER BY RANDOM()  $extra  ";
}
else {
	$provs = $_SESSION['proveedores'][$tpl->ID______CAT.$filtro.$extra];
#	print "CACHE!<br><br>";
}
#print_r($provs);
if ( is_array( $provs )  )
	foreach ( $provs as $row )
	{
		$tpl->tiene_proveedores = 1;
		#$tpl->proveedores[floor($count/4)][$count%4] = $row;
		$row["count"] = $count;
		$row["NOMBRE__PRO_con_guion"] = str_replace(" ","-",$row["NOMBRE__PRO"]);
		// ¿ La Foto Existe ?
		if ( !is_file( $app->settings['ecAPI']['UPLOAD_DIR'].'/'.$row['IMAGEN__PRO'] ) )
		{
			// Tiene Productos ?
			$query = $app->do_query("SELECT * FROM PRODUCTOS WHERE proveedoprd = '".$app->quotesql( (int) $row['ID______PRO'] )."' ORDER BY random() ");
			if( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
			{
				$row['IMAGEN__PRO'] = $reg['FOTO____PRD'];
			}
			else
			{
				$row['IMAGEN__PRO'] = 'avatar_anonymous.jpg';	
			}
	
		}
		// Solo si es Pagado tiene Foto
		if ( $row["ASOCIADOPRO"] == "S" )
		{
			
			//$tpl->proveedores[  floor( $kkkkk/3)  ][] = $row;
			$tpl->proveedores[] = $row;
			$kkkkk++;
		}
		$count++;
	}
/*	
}
*/

if ( $tpl->proveedores == null  )
{
	$_REQUEST["op"] = "NOP";
	$_GET["op"] = "NOP";

	$tpl->noshowboton = true;
	
}

$PERPAGENOP = 10;

// Existe la Pagina
if ( isset( $_REQUEST['pag'] )  )
{
	$pag = (int)$_REQUEST['pag'];
	$SKIPNOP = ($pag-1)*$limit;
}
else
{
	$pag = 1;
	$SKIPNOP = 0;
}

// Los que No Pagan


// ¿  Tiene Proveedores de No Pago ?
$qid = $app->do_query(" SELECT count(*) AS COUNT from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT ,$newfiltro  ) . " AND CADUCA__PRO >= NOW() AND  activo__pro = 'S'  AND  asociadopro = 'N'  $filtro  ");
while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))
{
	
	if ( $row["COUNT"] > 0 )
	{
		$tpl->showNext = true;
	}
}	


if ( isset($_REQUEST['op']) )
{	
	
	$qid = $app->do_query(" SELECT * from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT ,$newfiltro  ) . "  AND  activo__pro = 'S'  AND CADUCA__PRO >= NOW() AND asociadopro = 'N'  $filtro  ORDER BY RANDOM() ");


	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))
	{
		
		
		if ( strlen( trim($row["WEB_____PRO"]) ) > 7  )
			$row["WEB"] = true;
		if ( strlen( trim($row["EMAIL___PRO"]) ) > 4  )
			$row["EMAIL"] = true;
	
		
		$row["PAGA"] = FALSE;
	
		$tpl->proveedoresNoPaga[] = $row;
	}
	
	
	$tpl->antes = true;
	
}
else
{
	//PROVEDORES LISTADO	
	$qid = $app->do_query(" SELECT * from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT ,$newfiltro  ) . "  AND  activo__pro = 'S'  $filtro   AND CADUCA__PRO >= NOW() AND  asociadopro = 'S'  ORDER BY ORDEN___PRO DESC , NOMBRE__PRO ASC ");
#	print " SELECT * from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT ,$newfiltro  ) . "  AND  activo__pro = 'S'  $filtro    AND  asociadopro = 'S'  ORDER BY ORDEN___PRO DESC , NOMBRE__PRO ASC ";


	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))
	{
		$row["NOMBRE__PRO_con_guion"] = str_replace(" ","-",$row["NOMBRE__PRO"]);
	
		if ( strlen( trim($row["WEB_____PRO"]) ) > 7  )
			$row["WEB"] = true;
		if ( strlen( trim($row["EMAIL___PRO"]) ) > 4  )
			$row["EMAIL"] = true;
		
		$row["PAGA"] = TRUE;
		
	
		$tpl->proveedoresNoPaga[] = $row;
	}

}


/*
// Cuento los que no Pagan
$query = $app->do_query("  SELECT COUNT(*) from PROVEEDORES WHERE " . likeCheckbox("CATEGORIPRO", $tpl->ID______CAT  ,$newfiltro ) . "  AND  activo__pro = 'S'  AND  asociadopro = 'N' ");

while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
{
	$total = $reg["COUNT"];
	$paginas = ceil((int)$total/$limit);
	for($i=1;$i<=$paginas;$i++)
	{
	
		if ( $i == $paginas )
			$label = $i;
		else
			$label = $i.' -';
		
	
		if (  $pag == $i )
		{
			$tpl->pag[ $i ]['ACTIVE'] = true;
			$tpl->pag[ $i ]['LABEL'] = $label;						
		}
		else
			$tpl->pag[ $i ]['LABEL'] = $label;
		
	}
	// Analizamos Siguiente y Atras
	if (  isset( $tpl->pag[ $pag + 1 ] )  )
		$tpl->next = $pag+1;
	if (  isset( $tpl->pag[ $pag - 1 ] )  )
		$tpl->prev = $pag-1;
}


*/

if ( /*cualesmiPadre( $_REQUEST["index"]) == "Novia"*/  $_REQUEST["index"] == 3035  )
{
	$tpl->buscadorNovia = true;
	$qid = $app->do_query("SELECT nombre__pro FROM proveedores WHERE ( categoripro LIKE '3035' OR categoripro LIKE '%|3035|%' OR categoripro LIKE '%|3035' OR categoripro LIKE '3035|%' ) AND CADUCA__PRO >= NOW() AND asociadopro = 'S' ORDER BY RANDOM()");
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))			
	{
		if ( $row["NOMBRE__PRO"] == $_REQUEST["disenador"] )
			$checked = true;
		else
			$checked = false;
	
		$tpl->disenador[ ] = array( "NOMBRE" =>  $row["NOMBRE__PRO"] , "SELECTED" => $checked  );
	}
	
	
	$qid = $app->do_query(" SELECT coleccioprd AS COLE FROM productos WHERE coleccioprd != '' GROUP BY coleccioprd ");
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))			
	{
		if ( $row["COLE"] == $_REQUEST["coleccion"] )
			$checked = true;
		else
			$checked = false;

		$tpl->coleccion[ ] = array("NOMBRE" => $row["COLE"] , "SELECTED" => $checked);
	}
	
	
}

// Templates por Categoria
if ( $tpl->TEMPLATECAT == "categoria_lunademiel.html"  )
{
	// Cargamos todos los Proveedores por cada Categoria
	if ( is_array( $tpl->categorias ) )
	foreach ( $tpl->categorias as $k => $v  )
	{
		// Recorremos
		foreach ( $v as $kk => $vv )
		{
			// Estoy en la Categoria
			//$qid = $app->initLimitedReadLoop("LOCALIDADES", likeCheckbox("CATEGORILOC", $app->quotesql($vv["ID______CAT"],$newfiltro)) , "NOMBRE__LOC ASC");
			$qid = $app->do_query(" SELECT ID______LOC , COUNT(localidades) , NOMBRE__LOC FROM LOCALIDADES , DESTINOS WHERE localidades = id______loc AND   ".likeCheckbox("CATEGORILOC", $app->quotesql($vv["ID______CAT"],$newfiltro))." GROUP BY ID______LOC , NOMBRE__LOC  ORDER BY RANDOM() ");
			while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC))			
			{
				$tpl->categorias[$k][$kk]['LOCALIDADES'][] = $row;
			}
		}
	}
	// Cargamos Categorias del Padre
	$query = $app->do_query(" SELECT  nombre__cat , id______cat FROM categorias WHERE padre___cat = '".$app->quotesql( $tpl->PADRE___CAT )."' ORDER BY RANDOM() ");
	while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
	{
	      $tpl->MIS_HERMANOS_DE_CATEGORIA_Y_YO[] = $reg;
	}
	
	
}


if ( $_REQUEST['noPagan'] )
{
	$output = new HTML_Template_Flexy($options);
	$output->compile( "categoria_nopagan.html"  );
	$tpl->CONTENT=$output->bufferedOutputObject($tpl);
	echo utf8_encode($tpl->CONTENT);
	die();
}
else
{
	$output = new HTML_Template_Flexy($options);
	$output->compile( "categoria_nopagan.html"  );
	$tpl->CATEGORIA_NOPAGAN=$output->bufferedOutputObject($tpl);
}


$output = new HTML_Template_Flexy($options);
$output->compile( $tpl->TEMPLATECAT  );
$tpl->CONTENT=$output->bufferedOutputObject($tpl);

#$tpl->TITLE=$tpl->NOMBRE__CAT;
if ( !$_REQUEST["op"] OR count($tpl->categorias) > 0  )
{
	$tpl->TITLE = $tpl->linkcat( $tpl->ID______CAT , "MTITLE"  );
	$tpl->DESCRIPTION = $tpl->linkcat( $tpl->ID______CAT , "MDSC"  );
	$tpl->META = $tpl->linkcat( $tpl->ID______CAT , "MTAG"  );
}
else
{
	$tpl->TITLE = $tpl->linkcat2( $tpl->ID______CAT , "MTITLE"  );
        $tpl->DESCRIPTION = $tpl->linkcat2( $tpl->ID______CAT , "MDSC"  );
        $tpl->META = $tpl->linkcat2( $tpl->ID______CAT , "MTAG"  );
}


include("container.php");


?>