function getGrid($autor, $estado, $isbn, $tema, $titulo)
{
$ob = "6";
if (isset($_REQUEST["ob"])) {
$ob = $_REQUEST["ob"];
}
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$sb = false;
if (isset($_REQUEST["sb"])) {
if ($_REQUEST["sb"] == "T") {
$sb = true;
}
}
$showProcessMsg = false;
$params = array();
$where = "";
if ($autor != "") {
$params[":autor"] = "%" . $autor . "%";
$where .= " AND UPPER(li_autor) LIKE UPPER(:autor)";
}
if ($estado != "") {
$params[":estado"] = "%" . $estado . "%";
$where .= " AND UPPER(li_estado) LIKE UPPER(:estado)";
}
if ($isbn != "") {
$params[":isbn"] = "%" . $isbn . "%";
$where .= " AND UPPER(li_ibsn) LIKE UPPER(:isbn)";
}
if ($tema != "") {
$params[":tema"] = "%" . $tema . "%";
$where .= " AND UPPER(li_tema) LIKE UPPER(:tema)";
}
if ($titulo != "") {
$params[":titulo"] = "%" . $titulo . "%";
$where .= " AND UPPER(li_titulo) LIKE UPPER(:titulo)";
}
$sql = "SELECT li_id ¿id?,\n\t\t\t\t\t\tpr_id ¿id2?,\n\t\t\t\t\t\tpr_id ¿id3?,\n\t\t\t\t\t\tli_id ¿id4?,\n\t\t\t\t\t\tli_autor ¿autor?,\n\t\t\t\t\t\tli_titulo ¿titulo?,\n\t\t\t\t\t\tli_tema ¿tema?,\n\t\t\t\t\t\tli_ibsn ¿isbn?,\n\t\t\t\t\t pr_idusuario ¿usuario?,\n\t\t\t\t\t\tli_estado ¿estado?,\n\t\t\t\t\t\tpr_fechavencimiento ¿fechavencimiento?,\n\t\t\t\t\t\tli_fechabaja ¿baja?\n\t\t\t\t\t\tDECODE(li_estado, 'LIBRE', 'F', 'T') ¿hidecol1?,\n\t\t\t\t\t\tDECODE(li_estado, 'RESERVA', DECODE(" . (HasPermiso(60) ? 1 : 0) . ", 1, 'F', 'T'), 'T') ¿hidecol2?,\n\t\t\t\t\t\tDECODE(li_estado, 'PRESTADO', DECODE(" . (HasPermiso(60) ? 1 : 0) . ", 1, 'F', 'T'), 'T') ¿hidecol3?,\n\t\t\t\t\t\tDECODE(" . (HasPermiso(60) ? 1 : 0) . ", 1, 'F', 'T') ¿hidecol4?,\n\t\t\t\t\t\t'Reservar' ¿reservar?,\n\t\t\t\t\t\t'Entregar' ¿entregar?,\n\t\t\t\t\t\t'Devolver' ¿devolver?,\n\t\t\t\t\t\t'Modificar' ¿modificar?\n\t\t\t FROM rrhh.bli_libro, rrhh.bpr_prestamo\n\t\t\tWHERE li_id = pr_idlibro(+)\n\t\t\t\tAND (pr_id IN(SELECT maximo\n\t\t\t\t\t\t\t\t\t\t\t\tFROM (SELECT pr_idlibro, MAX(pr_id) maximo\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM rrhh.bpr_prestamo\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY pr_idlibro))\n\t\t\t\t\t\tOR pr_id IS NULL)" . $where;
$grilla = new Grid(15, 5);
$grilla->addColumn(new Column("R", 8, true, false, 17, "btnReservar", "/modules/biblioteca/accion_grilla.php?accion=R", "", -1, true, -1, "Reservar"));
$grilla->addColumn(new Column("E", 8, true, false, 18, "btnEntregar", "/modules/biblioteca/accion_grilla.php?accion=E", "", -1, true, -1, "Entregar"));
$grilla->addColumn(new Column("D", 8, true, false, 19, "btnDevolver", "/modules/biblioteca/accion_grilla.php?accion=D", "", -1, true, -1, "Devolver"));
$grilla->addColumn(new Column("M", 8, true, false, 20, "btnModificar", "/modules/biblioteca/accion_grilla.php?accion=M", "", -1, true, -1, "Modificar"));
$grilla->addColumn(new Column("Autor"));
$grilla->addColumn(new Column("Título"));
$grilla->addColumn(new Column("Tema"));
$grilla->addColumn(new Column("I.S.B.N."));
$grilla->addColumn(new Column("Usuario Préstamo"));
$grilla->addColumn(new Column("Estado"));
$grilla->addColumn(new Column("F. Vencimiento"));
$grilla->addColumn(new Column("", 0, false, true));
$grilla->addColumn(new Column("", 0, false, false, -1, "", "", "", -1, true, 1));
$grilla->addColumn(new Column("", 0, false, false, -1, "", "", "", -1, true, 2));
$grilla->addColumn(new Column("", 0, false, false, -1, "", "", "", -1, true, 3));
$grilla->addColumn(new Column("", 0, false, false, -1, "", "", "", -1, true, 4));
$grilla->addColumn(new Column("", 0, false));
$grilla->addColumn(new Column("", 0, false));
$grilla->addColumn(new Column("", 0, false));
$grilla->addColumn(new Column("", 0, false));
$grilla->setBaja(12, $sb, false);
$grilla->setColsSeparator(true);
$grilla->setFieldBaja("li_fechabaja");
$grilla->setOrderBy($ob);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparator(true);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(true);
return $grilla->Draw(true);
}
stm_aix("p1i7","p1i0",[0,"Diccionarios","","",-1,-1,0,"/index.php?pageid=51","_self"]);
stm_mc("p1",[11,"#000000",0,5,"",0]);
stm_ep();
stm_aix("p0i1","p0i0",[0," BENEFICIOS ","","",-1,-1,0,"/index.php?pageid=43","frameMain","","","","",0,0,0,"","",0,0]);
stm_bpx("p2","p1",[]);
stm_ep();
stm_aix("p0i2","p0i0",[0," RECURSOS HUMANOS ","","",-1,-1,0,"","_self","","","","",0,0,0,"","",-1,-1,0,0,1,"#FFFFF7",1,"#FFFFF7",1,"","",3,3,1,1,"#999999","#FFFFF7"]);
stm_bpx("p3","p1",[1,4,0,2,4,0,0,0,100,"stEffect(\"slip\")",-2,"stEffect(\"slip\")",-2,40]);
stm_aix("p3i0","p1i0",[0,"Novedades","","",-1,-1,0,"/index.php?pageid=6","frameMain","","","","",0,0,0,"","",0,0,0,0,1,"#FFFFF7",1,"#FFFFF7",1,"","",3,3,0,0,"#6699FF","#FFFFF7"]);
stm_aix("p3i1","p3i0",[0,"Ausentismo","","",-1,-1,0,"/index.php?pageid=7"]);
stm_aix("p3i2","p3i0",[0,"Búsquedas Laborales","","",-1,-1,0,"/index.php?pageid=61"]);
stm_aix("p3i3","p3i0",[0,"Organigrama","","",-1,-1,0,"/index.php?pageid=54","frameMain","","","","",0,0,0,"","",0,0]);
stm_aix("p3i4","p3i0",[0,"Obras Sociales","","",-1,-1,0,"/index.php?pageid=45"]);
stm_aix("p3i5","p3i0",[0,"Formación","","",-1,-1,0,"/index.php?pageid=65"]);
<?
if (HasPermiso(11)) {
?>
stm_aix("p3i7","p3i0",[0,"Mantenimiento","","",-1,-1,0,"/index.php?pageid=11"]);
<?
}
?>
stm_aix("p3i6","p3i0",[0,"Autogestión","","",-1,-1,0,"http://10.60.1.3/rhprox2/ess/index2.asp","_blank"]);
stm_ep();
stm_aix("p0i3","p0i2",[0," NOTICIAS "]);
stm_bpx("p4","p1",[1,4,0]);
stm_aix("p4i0","p3i0",[0,"Institucionales","","",-1,-1,0,"/index.php?pageid=25"]);
stm_aix("p4i1","p3i0",[0,"Arteria Noticias","","",-1,-1,0,"/index.php?pageid=52"]);
stm_aix("p4i2","p3i0",[0,"Síntesis de Prensa","","",-1,-1,0,"/index.php?pageid=12"]);
stm_aix("p4i3","p3i0",[0,"Boletín Oficial","","",-1,-1,0,"/index.php?pageid=14"]);
stm_aix("p4i4","p3i0",[0,"Normativa","","",-1,-1,0,"/index.php?pageid=31"]);
stm_aix("p4i5","p3i0",[0,"Seguridad Informática","","",-1,-1,0,"http://www.artprov.com.ar/SegInfo/index.html","_blank"]);
</tr>
<tr>
<td class="FormLabelAzul" width="200" align="right"> </td>
<td width="32"> </td>
<td><input class="BotonBlanco" type="submit" value="Buscar"></td>
</tr>
<tr>
<td class="FormLabelAzul" align="right" colspan="3"><hr color="#C0C0C0" size="1"></td>
</tr>
</table>
</form>
</div>
<div align="center" id="divContent" name="divContent">
<?
if ((isset($_REQUEST["buscar"])) and ($_REQUEST["buscar"] = "yes"))
getGrid($autor, $estado, $isbn, $tema, $titulo);
?>
</div>
<?
if (HasPermiso(60)) {
?>
<div>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center"><input class="BotonBlanco" type="button" value="Agregar Libros" onClick="window.location.href='/index.php?pageid=60'"></td>
</tr>
</table>
</div>
<?
}
?>
require_once $_SERVER["DOCUMENT_ROOT"] . "/../Common/database/db.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/../Common/miscellaneous/error.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/../Common/miscellaneous/general.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/functions/general.php";
// ** INICIO VALIDACIÓN CONEXIÓN CON BASE DE DATOS **
$sql = "SELECT 1 FROM DUAL";
$stmt = DBExecSql($conn, $sql);
if (!$stmt) {
header("Location: mantenimiento.html");
}
// ** FIN VALIDACIÓN **
$pageid = -1;
if (isset($_REQUEST["pageid"])) {
$pageid = intval($_REQUEST["pageid"]);
}
$hasPermiso = HasPermiso($pageid);
if ($pageid != -1 and !$hasPermiso) {
ShowError(GetPageName($pageid), "Usted no tiene permiso para ingresar a esta página.");
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<?php
echo GetHead(GetPageTitle($pageid), array("style.css", "new_style.css"));
?>
<script>
var _x_en_div;
var _y_en_div;
var _x;
