<?
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");

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


include("auth.php");

$tpl->addParams(  $app->readRecord("CATEGORIAS", "ID______CAT='" . $app->quotesql($_REQUEST["categoria"]) . "'")  );

$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($_REQUEST["comuna"]) {
	$filtro .= " AND UPPER(CIUDAD__PRO) LIKE '%" . $app->quotesql(preg_replace("/[^A-Z0-9_]+/", "%", strtoupper($_REQUEST["comuna"]))) . "%'";
}


$qid = $app->initReadLoop("PROVEEDORES", likeCheckbox("CATEGORIPRO", $app->quotesql($tpl->ID______CAT)) . "' $filtro");
while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
	$tpl->proveedores[] = $row;
	$count++;
}
/* Insert your code here */

$output = new HTML_Template_Flexy($options);
$output->compile("proveedores.html");
$tpl->CONTENT=$output->bufferedOutputObject($tpl);
$tpl->TITLE="HELLO WORLD";

include("container.php");
?>