153 lines
7.3 KiB
PHP
153 lines
7.3 KiB
PHP
|
<?php
|
|||
|
|
|
|||
|
|
include("seguridad.php");
|
|||
|
|
include("functions.php");
|
|||
|
|
if (!comprobar_permisos("AS")){
|
|||
|
|
header("Location: aplicacion.php?e=permiso");
|
|||
|
|
exit;
|
|||
|
|
}
|
|||
|
|
include_once("html/cabecera.php");
|
|||
|
|
|
|||
|
|
|
|||
|
|
/* ADMINISTRACI<43>N_ALARMAS.PHP */
|
|||
|
|
|
|||
|
|
menu_alarmas("");
|
|||
|
|
|
|||
|
|
echo "<h2>".$locale['300']."</h2>";
|
|||
|
|
echo "<br/>";
|
|||
|
|
echo "<p><b>".$locale['301']."</b></p>";
|
|||
|
|
$order = stripinput($_GET["order"]);
|
|||
|
|
$order_by = $order;
|
|||
|
|
$orden = stripinput($_GET["orden"]);
|
|||
|
|
$oid = stripinput($_GET["oid"]);
|
|||
|
|
$offset = stripinput($_GET["offset"]);
|
|||
|
|
$periodicidad = stripinput($_GET["periodicidad"]);
|
|||
|
|
|
|||
|
|
if ($order_by == "")
|
|||
|
|
$order_by = "rol, periodicidad";
|
|||
|
|
else if ($orden != "")
|
|||
|
|
$order_by .= " DESC";
|
|||
|
|
|
|||
|
|
if(!isset($offset) || $offset == ""){
|
|||
|
|
$offset = 0;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
$link = conectar();
|
|||
|
|
|
|||
|
|
echo '<ul id="tabnav">';
|
|||
|
|
echo '</ul>';
|
|||
|
|
|
|||
|
|
echo '<div id="ContTabul">';
|
|||
|
|
//Mostramos las alarmas.
|
|||
|
|
$consulta = "(select alarmas.prioridad as prioridad, alarmas.id as id, alarmas.nombre as nombre, alarmas.periodicidad as periodicidad, rol.id as rol from alarmas,rol where rol.oid = alarmas.rol) union (select alarmas.prioridad as prioridad, alarmas.id as id, alarmas.nombre as nombre, alarmas.periodicidad as periodicidad, alarmas.rol as rol from alarmas where alarmas.rol is NULL) order by ".$order_by;
|
|||
|
|
if ($resultado = mysql_query($consulta)){
|
|||
|
|
$cont = mysql_num_rows($resultado);
|
|||
|
|
$limit = constante("lista");
|
|||
|
|
$consulta .= " limit ".$offset.",".$limit;
|
|||
|
|
$resultado = mysql_query($consulta);
|
|||
|
|
$num = mysql_num_rows($resultado);
|
|||
|
|
|
|||
|
|
if($num > 0){
|
|||
|
|
//Mostramos la cabecera de la tabla.
|
|||
|
|
echo '<table width=100%>';
|
|||
|
|
echo '<tr class="encabezado">';
|
|||
|
|
echo '<td align="center">'.$locale['1521'].'<br/>
|
|||
|
|
<table><tr><td class=sinborde>
|
|||
|
|
<form action="administracion_alarmas.php?order=nombre" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/asc.png">';
|
|||
|
|
echo '</form></td><td class=sinborde>';
|
|||
|
|
echo '<form action="administracion_alarmas.php?order=nombre&orden=desc" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/desc.png">';
|
|||
|
|
echo '</form></td></tr></table>';
|
|||
|
|
echo '<td align="center">'.$locale['1022'].'<br/>
|
|||
|
|
<table><tr><td class=sinborde>
|
|||
|
|
<form action="administracion_alarmas.php?order=prioridad" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/asc.png">';
|
|||
|
|
echo '</form></td><td class=sinborde>';
|
|||
|
|
echo '<form action="administracion_alarmas.php?order=prioridad&orden=desc" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/desc.png">';
|
|||
|
|
echo '</form></td></tr></table>';
|
|||
|
|
echo '<td align="center">'.$locale['331'].'<br/>
|
|||
|
|
<table><tr><td class=sinborde>
|
|||
|
|
<form action="administracion_alarmas.php?order=periodicidad" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/asc.png">';
|
|||
|
|
echo '</form></td><td class=sinborde>';
|
|||
|
|
echo '<form action="administracion_alarmas.php?order=periodicidad&orden=desc" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/desc.png">';
|
|||
|
|
echo '</form></td></tr></table>';
|
|||
|
|
echo '<td align="center">'.$locale['1530'].'<br/>
|
|||
|
|
<table><tr><td class=sinborde>
|
|||
|
|
<form action="administracion_alarmas.php?order=rol" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/asc.png">';
|
|||
|
|
echo '</form></td><td class=sinborde>';
|
|||
|
|
echo '<form action="administracion_alarmas.php?order=rol&orden=desc" method="POST">';
|
|||
|
|
echo '<input type="image" name="menos" src="css/desc.png">';
|
|||
|
|
echo '</form></td></tr></table>';
|
|||
|
|
echo '</td>';
|
|||
|
|
echo '<td align="center" colspan="2">Acciones</td>';
|
|||
|
|
|
|||
|
|
while ($row = mysql_fetch_array($resultado)){
|
|||
|
|
$id = $row["id"];
|
|||
|
|
$nombre = $row["nombre"];
|
|||
|
|
$periodicidad = $row["periodicidad"];
|
|||
|
|
$rol = $row["rol"];
|
|||
|
|
$prioridad = $row["prioridad"];
|
|||
|
|
|
|||
|
|
if($rol == "") $rol = "GLOBAL";
|
|||
|
|
|
|||
|
|
//Escribimos los resultados
|
|||
|
|
echo "<tr>";
|
|||
|
|
echo '<td align="left">'.$nombre.'</td>';
|
|||
|
|
echo '<td align="left">'.discretiza_prioridad($prioridad).'</td>';
|
|||
|
|
echo '<td align="left">'.periodicidad($periodicidad).'</td>';
|
|||
|
|
echo '<td align="left">'.$rol.'</td>';
|
|||
|
|
echo '<td align="center">
|
|||
|
|
<form action="formulario_alarma.php?oid='.$id.'" method="post">
|
|||
|
|
<input type="image" src="css/edit.png"></td>';
|
|||
|
|
echo '</form>';
|
|||
|
|
echo '<form action="eliminar_alarma.php" method="POST">';
|
|||
|
|
echo '<input type="hidden" name="oid" value="'.$id.'">';
|
|||
|
|
echo '<td align="center"><input type="image" name="eliminar" src="css/eliminar.png" onclick="return eliminar_alarma(this)"></td>';
|
|||
|
|
echo '</form>';
|
|||
|
|
echo "</tr>";
|
|||
|
|
}
|
|||
|
|
echo '</table>';
|
|||
|
|
//Calculamos el n<>mero de p<>ginas y mostramos la navegaci<63>n
|
|||
|
|
$paginas = $cont / $limit;
|
|||
|
|
if($limit < $cont){
|
|||
|
|
echo '<br><center><table align="center"><tr class=encabezado>';
|
|||
|
|
if($limit <= $offset){
|
|||
|
|
echo '<form action="administracion_alarmas.php?orden='.$orden.'&order='.$order.'&offset='.($offset-$limit).'" method="POST">';
|
|||
|
|
echo '<td align="center"><input type="image" name="menos" src="css/flecha_menos.gif"></td>';
|
|||
|
|
echo '</form>';
|
|||
|
|
}
|
|||
|
|
for($i = 0; $i < $paginas; $i++){
|
|||
|
|
if(($i*$limit) == $offset){
|
|||
|
|
echo "<td>".($i+1)."</td>";
|
|||
|
|
}else{
|
|||
|
|
echo '<form action="administracion_alarmas.php?orden='.$orden.'&order='.$order.'&offset='.($i*$limit).'" method="POST">';
|
|||
|
|
echo '<td align="center"><input type="submit" class="paginado" name="menos" value="'.($i+1).'"></td>';
|
|||
|
|
echo '</form>';
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if(($limit*$offset+1) < $cont){
|
|||
|
|
echo '<form action="administracion_alarmas.php?orden='.$orden.'&order='.$order.'&offset='.($offset+$limit).'" method="POST">';
|
|||
|
|
echo '<td align="center"><input type="image" name="mas" src="css/flecha_mas.gif"></td>';
|
|||
|
|
echo '</form>';
|
|||
|
|
}
|
|||
|
|
echo '</tr></table></center>';
|
|||
|
|
}
|
|||
|
|
}else{
|
|||
|
|
echo "<p>".$locale['307']."</p>";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
echo '</div>';
|
|||
|
|
|
|||
|
|
echo '</div>';
|
|||
|
|
|
|||
|
|
include_once("html/pie.php");
|
|||
|
|
|
|||
|
|
?>
|