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;