[409af27] | 1 | <?php |
---|
[3ec149c] | 2 | // **************************************************************************************************** |
---|
| 3 | // Aplicación WEB: ogAdmWebCon |
---|
| 4 | // Autor: José Manuel Alonso (E.T.S.I.I.) Universidad de Sevilla |
---|
| 5 | // Fecha Creación: Año 2009-2010 |
---|
| 6 | // Fecha Última modificación: Agosto-2010 |
---|
| 7 | // Nombre del fichero: propiedades_ordenadores.php |
---|
| 8 | // Descripción : |
---|
| 9 | // Presenta el formulario de captura de datos de un ordenador para insertar,modificar y eliminar |
---|
| 10 | // **************************************************************************************************** |
---|
| 11 | include_once("../includes/ctrlacc.php"); |
---|
| 12 | include_once("../includes/opciones.php"); |
---|
| 13 | include_once("../includes/constantes.php"); |
---|
| 14 | include_once("../includes/CreaComando.php"); |
---|
| 15 | include_once("../includes/TomaDato.php"); |
---|
| 16 | include_once("../includes/HTMLSELECT.php"); |
---|
[58d08a2] | 17 | include_once("../includes/HTMLCTESELECT.php"); |
---|
[3ec149c] | 18 | include_once("../clases/AdoPhp.php"); |
---|
| 19 | include_once("../idiomas/php/".$idioma."/propiedades_ordenadores_".$idioma.".php"); |
---|
[6459703] | 20 | include_once("../idiomas/php/".$idioma."/avisos_".$idioma.".php"); |
---|
[3ec149c] | 21 | //________________________________________________________________________________________________________ |
---|
| 22 | $opcion=0; |
---|
| 23 | $opciones=array($TbMsg[0],$TbMsg[1],$TbMsg[2],$TbMsg[3]); |
---|
| 24 | //________________________________________________________________________________________________________ |
---|
| 25 | $idordenador=0; |
---|
| 26 | $nombreordenador=""; |
---|
| 27 | $ip=""; |
---|
| 28 | $mac=""; |
---|
| 29 | $idperfilhard=0; |
---|
| 30 | $idrepositorio=0; |
---|
| 31 | $idmenu=0; |
---|
| 32 | $idprocedimiento=0; |
---|
| 33 | $idaula=0; |
---|
| 34 | $grupoid=0; |
---|
[58d08a2] | 35 | ######################## ADV |
---|
| 36 | $netiface=""; |
---|
| 37 | $netdriver=""; |
---|
[49313a5] | 38 | ######################## UHU |
---|
| 39 | $validacion=0; |
---|
| 40 | $paginalogin=""; |
---|
| 41 | $paginavalidacion=""; |
---|
[8c2a78c] | 42 | ######################## Ramón |
---|
| 43 | $arranque=""; |
---|
[3ec149c] | 44 | |
---|
| 45 | if (isset($_GET["opcion"])) $opcion=$_GET["opcion"]; // Recoge parametros |
---|
| 46 | if (isset($_GET["idordenador"])) $idordenador=$_GET["idordenador"]; |
---|
| 47 | if (isset($_GET["idaula"])) $idaula=$_GET["idaula"]; |
---|
| 48 | if (isset($_GET["grupoid"])) $grupoid=$_GET["grupoid"]; |
---|
| 49 | if (isset($_GET["identificador"])) $idordenador=$_GET["identificador"]; |
---|
| 50 | //________________________________________________________________________________________________________ |
---|
| 51 | $cmd=CreaComando($cadenaconexion); // Crea objeto comando |
---|
| 52 | if (!$cmd) |
---|
| 53 | Header('Location: '.$pagerror.'?herror=2'); // Error de conexión con servidor B.D. |
---|
| 54 | if ($opcion!=$op_alta){ |
---|
| 55 | $resul=TomaPropiedades($cmd,$idordenador); |
---|
| 56 | if (!$resul) |
---|
| 57 | Header('Location: '.$pagerror.'?herror=3'); // Error de recuperación de datos. |
---|
| 58 | } |
---|
| 59 | //________________________________________________________________________________________________________ |
---|
| 60 | ?> |
---|
[8c2a78c] | 61 | <html> |
---|
| 62 | <title>Administración web de aulas</title> |
---|
| 63 | <head> |
---|
| 64 | <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> |
---|
| 65 | <link rel="stylesheet" type="text/css" href="../estilos.css" /> |
---|
[2772884] | 66 | <SCRIPT language="javascript" src="../jscripts/validators.js"></SCRIPT> |
---|
[8c2a78c] | 67 | <script language="javascript" src="../jscripts/propiedades_ordenadores.js"></script> |
---|
| 68 | <script language="javascript" src="../jscripts/opciones.js"></script> |
---|
| 69 | <?php echo '<script language="javascript" src="../idiomas/javascripts/'.$idioma.'/propiedades_ordenadores_'.$idioma.'.js"></script>'?> |
---|
[5fb6914] | 70 | <script language=javascript> |
---|
| 71 | function abrir_ventana(URL){ |
---|
| 72 | window.open('../images/ver.php','Imagenes','scrollbars=yes,resizable=yes,width=950,height=640') |
---|
| 73 | } |
---|
| 74 | </script> |
---|
[49313a5] | 75 | |
---|
[8c2a78c] | 76 | </head> |
---|
| 77 | <body> |
---|
| 78 | <form name="fdatos" action="../gestores/gestor_ordenadores.php" method="post" enctype="multipart/form-data"> |
---|
| 79 | <input type="hidden" name="opcion" value="<?php echo $opcion?>" /> |
---|
| 80 | <input type="hidden" name="idordenador" value="<?php echo $idordenador?>" /> |
---|
| 81 | <input type="hidden" name="grupoid" value="<?php echo $grupoid?>" /> |
---|
| 82 | <input type="hidden" name="idaula" value="<?php echo $idaula?>" /> |
---|
| 83 | <input type="hidden" name="arranque" value="<?php echo $arranque?>" /> |
---|
| 84 | <p align="center" class="cabeceras"><?echo $TbMsg[4]?><br /> |
---|
| 85 | <span align="center" class="subcabeceras"><? echo $opciones[$opcion]?></span></p> |
---|
[3ec149c] | 86 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[c31a439] | 87 | <table align="center" border="0" cellPadding="1" cellSpacing="1" class="tabla_datos"> |
---|
[70ed85d] | 88 | <tr> |
---|
[8c2a78c] | 89 | <th align="center"> <?php echo $TbMsg[5]?> <sup>*</sup> </th> |
---|
[409af27] | 90 | <?php if ($opcion==$op_eliminacion) |
---|
| 91 | echo '<td>'.$nombreordenador.'</td>'; |
---|
[df440ce] | 92 | else |
---|
[409af27] | 93 | echo '<td><input class="formulariodatos" name=nombreordenador type=text value="'.$nombreordenador.'"></td>'; |
---|
| 94 | if (empty ($fotoordenador)) { |
---|
| 95 | $fotoordenador="fotoordenador.gif"; |
---|
| 96 | } |
---|
| 97 | $fotomenu=$fotoordenador; |
---|
| 98 | $dirfotos="../images/fotos"; |
---|
[3ec149c] | 99 | ?> |
---|
[49313a5] | 100 | <td colspan="2" valign="top" align="left" rowspan="3"> |
---|
| 101 | <img border="2" style="border-color:#63676b" src="<?php echo $dirfotos.'/'.$fotoordenador?>" /> |
---|
| 102 | <?php if ($opcion!=$op_eliminacion) { |
---|
| 103 | echo '<br />(150X110)-(jpg - gif - png) ---- '.$TbMsg[5091].'><br />'; |
---|
| 104 | echo '<input name="archivo" type="file" id="archivo" size="16" />'; |
---|
| 105 | } |
---|
| 106 | ?> |
---|
| 107 | </td> |
---|
[6459703] | 108 | </tr> |
---|
[3ec149c] | 109 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[49313a5] | 110 | <tr> |
---|
[8c2a78c] | 111 | <th align="center"> <?php echo $TbMsg[6]?> </th> |
---|
[49313a5] | 112 | <?php if ($opcion==$op_eliminacion) |
---|
| 113 | echo '<td>'.$ip.'</td>'; |
---|
[3ec149c] | 114 | else |
---|
[49313a5] | 115 | echo '<td><input class="formulariodatos" name=ip type=text value="'.$ip.'"></td>'; |
---|
[3ec149c] | 116 | ?> |
---|
[49313a5] | 117 | </tr> |
---|
[3ec149c] | 118 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[49313a5] | 119 | <tr> |
---|
[8c2a78c] | 120 | <th align="center"> <?php echo $TbMsg[7]?> </th> |
---|
[49313a5] | 121 | <?php if ($opcion==$op_eliminacion) |
---|
[8c2a78c] | 122 | echo '<td><input type="hidden" name="mac" value="'.$mac.'" />'.$mac.'</td>'; |
---|
[3ec149c] | 123 | else |
---|
[49313a5] | 124 | echo '<td><input class="formulariodatos" name=mac type=text value="'. $mac.'"></td>'; |
---|
[3ec149c] | 125 | ?> |
---|
[49313a5] | 126 | </tr> |
---|
[5fb6914] | 127 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[49313a5] | 128 | <TR> |
---|
[c31a439] | 129 | <th align=center> <?echo $TbMsg[509]?> </th> |
---|
[5fb6914] | 130 | <? |
---|
| 131 | if ($opcion==$op_eliminacion) |
---|
| 132 | echo '<TD colspan=3>'.$fotoordenador.'</TD>'; |
---|
| 133 | else { |
---|
| 134 | if ($fotoordenador=="") |
---|
| 135 | $fotoordenador="../images/fotos/fotoordenador.gif"; |
---|
| 136 | $fotoordenador; |
---|
| 137 | |
---|
| 138 | ?> |
---|
| 139 | <TD colspan=3><SELECT class="formulariodatos" name="fotoordenador" > |
---|
| 140 | <?php if($fotomenu==""){ |
---|
| 141 | echo '<option value="fotoordenador.gif"></option>';}else{ |
---|
| 142 | echo '<option value="'.$fotomenu.'">'.$fotomenu.'</option>';} |
---|
| 143 | if ($handle = opendir("../images/fotos")) { |
---|
| 144 | while (false !== ($entry = readdir($handle))) { |
---|
| 145 | if ($entry != "." && $entry != "..") {?> |
---|
| 146 | |
---|
| 147 | <option value="<? echo $entry ?>"><? echo $entry ?></option> |
---|
| 148 | <?} |
---|
| 149 | } |
---|
| 150 | closedir($handle); |
---|
| 151 | } |
---|
| 152 | ?> |
---|
| 153 | </SELECT> |
---|
| 154 | <a href="javascript:abrir_ventana('../images/ver.php')" onClick="MM_openBrWindow('../images/ver.php','Imagenes','scrollbars=yes,resizable=yes,width=950,height=640')"><? echo $TbMsg[5092] ?></a> |
---|
| 155 | </TD> |
---|
| 156 | <? |
---|
| 157 | } |
---|
| 158 | ?> |
---|
| 159 | |
---|
| 160 | </TR> |
---|
[3ec149c] | 161 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
| 162 | <TR> |
---|
[c31a439] | 163 | <th align=center> <?echo $TbMsg[8]?> </th> |
---|
[3ec149c] | 164 | <? |
---|
| 165 | if ($opcion==$op_eliminacion) |
---|
| 166 | echo '<TD colspan=3>'.TomaDato($cmd,$idcentro,'perfileshard',$idperfilhard,'idperfilhard','descripcion').'</TD>'; |
---|
| 167 | else |
---|
| 168 | echo '<TD colspan=3>'.HTMLSELECT($cmd,$idcentro,'perfileshard',$idperfilhard,'idperfilhard','descripcion',250).'</TD>'; |
---|
| 169 | ?> |
---|
| 170 | </TR> |
---|
| 171 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
| 172 | <TR> |
---|
[c31a439] | 173 | <th align=center> <?echo $TbMsg[10]?> </th> |
---|
[3ec149c] | 174 | <? |
---|
| 175 | if ($opcion==$op_eliminacion) |
---|
| 176 | echo '<TD colspan=3>'.TomaDato($cmd,$idcentro,'repositorios',$idrepositorio,'idrepositorio','nombrerepositorio').'</TD>'; |
---|
| 177 | else |
---|
| 178 | echo '<TD colspan=3>'.HTMLSELECT($cmd,$idcentro,'repositorios',$idrepositorio,'idrepositorio','nombrerepositorio',250).'</TD>'; |
---|
| 179 | ?> |
---|
| 180 | </TR> |
---|
| 181 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
| 182 | <TR> |
---|
[c31a439] | 183 | <th align=center> <?echo $TbMsg[11]?> </th> |
---|
[3ec149c] | 184 | <? |
---|
| 185 | if ($opcion==$op_eliminacion) |
---|
| 186 | echo '<TD colspan=3>'.TomaDato($cmd,$idcentro,'menus',$idmenu,'idmenu','descripcion').'</TD>'; |
---|
| 187 | else |
---|
| 188 | echo '<TD colspan=3>'.HTMLSELECT($cmd,$idcentro,'menus',$idmenu,'idmenu','descripcion',250).'</TD>'; |
---|
| 189 | ?> |
---|
| 190 | </TR> |
---|
| 191 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
| 192 | <TR> |
---|
[c31a439] | 193 | <th align=center> <?echo $TbMsg[9]?> </th> |
---|
[3ec149c] | 194 | <? |
---|
| 195 | if ($opcion==$op_eliminacion) |
---|
| 196 | echo '<TD colspan=3>'.TomaDato($cmd,$idcentro,'procedimientos',$idprocedimiento,'idprocedimiento','descripcion').' </TD>'; |
---|
| 197 | else |
---|
| 198 | echo '<TD colspan=3>'.HTMLSELECT($cmd,$idcentro,'procedimientos',$idprocedimiento,'idprocedimiento','descripcion',250).'</TD>'; |
---|
| 199 | ?> |
---|
| 200 | </TR> |
---|
[58d08a2] | 201 | <!-----ADV --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[aa337dc] | 202 | <tr> |
---|
| 203 | <th align=center > <?echo $TbMsg[13]?> </th> |
---|
[49313a5] | 204 | <?php if ($opcion==$op_eliminacion) { |
---|
| 205 | echo '<td colspan="3">'.$netiface.'</td>'; |
---|
| 206 | } else { |
---|
| 207 | echo '<td colspan="3">'; |
---|
| 208 | $iface="eth0=eth0".chr(13); |
---|
| 209 | $iface.="eth1=eth1".chr(13); |
---|
| 210 | $iface.="eth2=eth2"; |
---|
| 211 | echo HTMLCTESELECT($iface,"netiface","estilodesple","",$netiface,100).'</td>'; |
---|
| 212 | } |
---|
[58d08a2] | 213 | ?> |
---|
[aa337dc] | 214 | </tr> |
---|
[58d08a2] | 215 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
| 216 | |
---|
[aa337dc] | 217 | <tr> |
---|
[cb94611] | 218 | <th align="center"> <?echo $TbMsg[14]?> </th> |
---|
[49313a5] | 219 | <?php if ($opcion==$op_eliminacion) { |
---|
| 220 | echo '<td colspan="3">'.$netdriver.'</td>'; |
---|
| 221 | } else { |
---|
| 222 | echo '<td colspan="3">'; |
---|
| 223 | $driver="generic=generic"; |
---|
| 224 | echo HTMLCTESELECT($driver,"netdriver","estilodesple","",$netdriver,100).'</td>'; |
---|
| 225 | } |
---|
[58d08a2] | 226 | ?> |
---|
[aa337dc] | 227 | </tr> |
---|
[58d08a2] | 228 | |
---|
| 229 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[df440ce] | 230 | <!--------------------------------------------------------------UHU comprobar si se requiere validacion -------------------------------------------------------------------------------> |
---|
| 231 | |
---|
[49313a5] | 232 | <tr> |
---|
| 233 | <th align=center ><? echo $TbMsg[15]; ?> </th> |
---|
| 234 | <?php if ($opcion==$op_eliminacion) { |
---|
| 235 | echo '<td colspan="3">'.$validacion.'</td>'; |
---|
| 236 | } else { |
---|
| 237 | echo '<TD colspan="3">'; |
---|
| 238 | $validaciones="1=Si".chr(13); |
---|
| 239 | $validaciones.="0=No"; |
---|
| 240 | echo HTMLCTESELECT($validaciones,"validacion","estilodesple","",$validacion,100).'</TD>'; |
---|
| 241 | } |
---|
[df440ce] | 242 | ?> |
---|
[49313a5] | 243 | </tr> |
---|
| 244 | <tr> |
---|
| 245 | <th align=center> <?echo $TbMsg[16]?> </th> |
---|
| 246 | <?php if ($opcion==$op_eliminacion) |
---|
| 247 | echo '<td colspan="3">'.$paginalogin.'</td>'; |
---|
[df440ce] | 248 | else |
---|
[49313a5] | 249 | echo '<td colspan="3"><input class="formulariodatos" name=paginalogin type=text value="'.$paginalogin.'" /></td>'; |
---|
[df440ce] | 250 | ?> |
---|
[49313a5] | 251 | </tr> |
---|
| 252 | <tr> |
---|
| 253 | <th align=center> <?echo $TbMsg[17]?> </th> |
---|
| 254 | <?php if ($opcion==$op_eliminacion) |
---|
| 255 | echo '<td colspan="3">'.$paginavalidacion.'</td>'; |
---|
[df440ce] | 256 | else |
---|
[49313a5] | 257 | echo '<td colspan="3"><input class="formulariodatos" name=paginavalidacion type=text value="'.$paginavalidacion.'" /></td>'; |
---|
[df440ce] | 258 | ?> |
---|
[49313a5] | 259 | </tr> |
---|
[df440ce] | 260 | |
---|
| 261 | <!-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> |
---|
[49313a5] | 262 | <?php if ($opcion!=$op_eliminacion) { ?> |
---|
[70ed85d] | 263 | <tr> |
---|
[8c2a78c] | 264 | <th colspan="4" align="center"> <sup>*</sup> <?php echo $TbMsg["WARN_NAMELENGTH"]?> </th> |
---|
[49313a5] | 265 | </tr> |
---|
| 266 | <?php } ?> |
---|
[c31a439] | 267 | </table> |
---|
[8c2a78c] | 268 | </form> |
---|
[49313a5] | 269 | <?php |
---|
[3ec149c] | 270 | //________________________________________________________________________________________________________ |
---|
| 271 | include_once("../includes/opcionesbotonesop.php"); |
---|
| 272 | //________________________________________________________________________________________________________ |
---|
| 273 | ?> |
---|
[8c2a78c] | 274 | <br /> |
---|
| 275 | <?php |
---|
[3ec149c] | 276 | //________________________________________________________________________________________________________ |
---|
| 277 | // |
---|
| 278 | // Frame con la información de la configuración |
---|
[23c49a9] | 279 | // Si es la opcion insertar no muestra nada -> opcion=$op_alta |
---|
| 280 | if ($opcion!=$op_alta) { |
---|
| 281 | echo '<div align="center">'; |
---|
| 282 | echo '<iframe scrolling="auto" height="500" width="90%" frameborder="0" |
---|
[8c2a78c] | 283 | src="../principal/configuraciones.php?swp=1&idambito='.$idordenador.'&ambito='.$AMBITO_ORDENADORES.'"></iframe>'; |
---|
[23c49a9] | 284 | echo '</div>'; |
---|
| 285 | } |
---|
[3ec149c] | 286 | //________________________________________________________________________________________________________ |
---|
| 287 | ?> |
---|
[8c2a78c] | 288 | </body> |
---|
| 289 | </html> |
---|
| 290 | <?php |
---|
[3ec149c] | 291 | //________________________________________________________________________________________________________ |
---|
| 292 | // Recupera los datos de un ordenador |
---|
| 293 | // Parametros: |
---|
| 294 | // - cmd: Una comando ya operativo (con conexión abierta) |
---|
| 295 | // - id: El identificador del ordenador |
---|
| 296 | //________________________________________________________________________________________________________ |
---|
| 297 | function TomaPropiedades($cmd,$id){ |
---|
| 298 | global $idordenador; |
---|
| 299 | global $nombreordenador; |
---|
| 300 | global $ip; |
---|
| 301 | global $mac; |
---|
[5fb6914] | 302 | global $fotoordenador; |
---|
[3ec149c] | 303 | global $idperfilhard; |
---|
| 304 | global $idrepositorio; |
---|
| 305 | global $idmenu; |
---|
| 306 | global $idprocedimiento; |
---|
[58d08a2] | 307 | global $netiface; |
---|
| 308 | global $netdriver; |
---|
[df440ce] | 309 | ########################### UHU |
---|
| 310 | global $validacion; |
---|
| 311 | global $paginalogin; |
---|
| 312 | global $paginavalidacion; |
---|
[8c2a78c] | 313 | ########################### Ramón |
---|
| 314 | global $arranque; |
---|
[df440ce] | 315 | |
---|
[3ec149c] | 316 | $rs=new Recordset; |
---|
| 317 | $cmd->texto="SELECT * FROM ordenadores WHERE idordenador=".$id; |
---|
| 318 | $rs->Comando=&$cmd; |
---|
| 319 | if (!$rs->Abrir()) return(false); // Error al abrir recordset |
---|
| 320 | $rs->Primero(); |
---|
| 321 | if (!$rs->EOF){ |
---|
| 322 | $nombreordenador=$rs->campos["nombreordenador"]; |
---|
| 323 | $ip=$rs->campos["ip"]; |
---|
| 324 | $mac=$rs->campos["mac"]; |
---|
| 325 | $idperfilhard=$rs->campos["idperfilhard"]; |
---|
| 326 | $idrepositorio=$rs->campos["idrepositorio"]; |
---|
| 327 | $idmenu=$rs->campos["idmenu"]; |
---|
| 328 | $idprocedimiento=$rs->campos["idproautoexec"]; |
---|
[58d08a2] | 329 | $netiface=$rs->campos["netiface"]; |
---|
[5fb6914] | 330 | $fotoordenador=$rs->campos["fotoord"]; //Creado para foto |
---|
[58d08a2] | 331 | $netdriver=$rs->campos["netdriver"]; |
---|
[df440ce] | 332 | ########################### UHU |
---|
| 333 | $validacion=$rs->campos["validacion"]; |
---|
| 334 | $paginalogin=$rs->campos["paginalogin"]; |
---|
| 335 | $paginavalidacion=$rs->campos["paginavalidacion"]; |
---|
[8c2a78c] | 336 | ########################### Ramón |
---|
| 337 | $arranque=$rs->campos["arranque"]; |
---|
[df440ce] | 338 | |
---|
[3ec149c] | 339 | $rs->Cerrar(); |
---|
| 340 | return(true); |
---|
| 341 | } |
---|
| 342 | else |
---|
| 343 | return(false); |
---|
| 344 | } |
---|
| 345 | ?> |
---|
[df440ce] | 346 | |
---|