Municipalidad de
Pozo del Tigre
Pozo del Tigre
Calle Tomán Albarracín
set_file(array(
"consultas_home" => "consultas_home.html",
"una_opcion_car" => "una_opcion_car.html",
"una_opcion_organismo" => "una_opcion_organismo.html",
));
/*Alias de tablas*/
$tbl_organismos="sys_form_04_arb_formal";
$tbl_det_usuarios_organismos="sys_form_07_det_usuarios_organismos";
$tbl_usuarios="sys_form_03_arb_usuarios";
$tbl_caracter="consultas.sys_form_09_cab_caracter";
/*Cargo los organismos*/
$qr="Select DISTINCT sys_form_04_arb_formal.* from sys_form_04_arb_formal
inner join sys_form_07_det_usuarios_organismos on rela_sysform04=id_sysform04
inner join sys_form_03_arb_usuarios on rela_sysform03=id_sysform03";
//$qr="Select * from $tbl_organismos";
$result_cat = pg_query($link_pg, $qr);
//echo $qr;
while ($row = pg_fetch_assoc($result_cat))
{
$t->set_var("ORGANISMO",$row['id_sysform04']);
$t->set_var("NOMBRE_ORGANISMO",$row['sysform04_descripcion']);
$t->parse("ORGANISMOS","una_opcion_organismo",true);
}
/*Cargo los caracteres*/
/*Cargo los organismos*/
$qr="Select * from $tbl_caracter" ;
$result_cat = pg_query($link_pg, $qr);
while ($row = pg_fetch_assoc($result_cat))
{
$t->set_var("CARACTER_ID",$row['id_sysform09']);
$t->set_var("CARACTER_NOMBRE",$row['sysform09_descripcion']);
$t->parse("CARACTERES","una_opcion_car",true);
}
$captcha = new Captcha();
$filename = time()."_".$captcha->createRandString(20);
$_SESSION['image_code'] = $captcha->createRandString(6);
$captcha->deleteOldImages();
$_SESSION['image_name'] =
$captcha->createImage($_SESSION['image_code'], $filename);
$t->set_var("IMG_CODE","modulos/consultas/tmp/" . $_SESSION['image_name']);
$t->pparse("OUT", "consultas_home");
?>
