Viewing file: modificar.php (17.77 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
/**
* UserEdit.php
*
* This page is for users to edit their account information
* such as their password, email address, etc. Their
* usernames can not be edited. When changing their
* password, they must first confirm their current password.
*
* Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
* Last Updated: August 26, 2004
*/
include("../usuarios/include/session.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html class="noI firefox" xmlns="http://www.w3.org/1999/xhtml"><head>
<link rel="shortcut icon" href="../../images/favicon.ico">
<title>Modulo Administración</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../index_files/style.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="../../js/popcalendar.js"></script>
<SCRIPT LANGUAGE="JavaScript">
function popup(page) {
window.open(page,'popup','width=800,height=600,toolbar=false,scrollbars=yes,top=0,left=10');
}
</SCRIPT>
</head>
<!-- CSS -->
<link rel="stylesheet" href="../css/dynamic.css" type="text/css">
<link rel="stylesheet" href="../css/creation.css" type="text/css">
</head><body id="creation">
<?php
/**
* User has submitted form without errors and user's
* account has been edited successfully.
*/
if(isset($_SESSION['useredit'])){
unset($_SESSION['useredit']);
echo "<h1>User Account Edit Success!</h1>";
echo "<p><b>$session->username</b>, tu cuenta ha sido actualizada satisfactoriamente. "
."<a href=\"../index.php\">Inicio</a>.</p>";
}
else{
?>
<?php
/**
* If user is not logged in, then do not display anything.
* If user is logged in, then display the form to edit
* account information, with the current email address
* already in the field.
*/
if($session->logged_in){
?>
<div id="container" class="clearfix">
<?php include("../../conex.php");
if ($_POST['tipo'] == 'AUTO')
{
$tabla = 'AUTOS';
}
else{
$tabla = 'RESOLUCIONES';
}
if( $_POST['consulta'] ){
$sql = "select * from $tabla where id ='$_POST[id]'";
$cursor = mysql_query( $sql, $conexion );
if( $row = mysql_fetch_array( $cursor ) ){
$no = $row["no"];
$fecha = $row["fecha"];
$resuelve = $row["resuelve"];
$sector = $row["sector"];
$subsector = $row["subsector"];
$usuario = $row["usuario"];
$expediente = $row["expediente"];
$abogado = $row["abogado"];
$direccion = $row["direccion"];
$id = $row["id"];
$tipo = $row["tipo"];
}
}
if( $_POST['modifica'] ){
$sql = "update $tabla set no='$_POST[no]',fecha='$_POST[fecha]',resuelve='$_POST[resuelve]',sector='$_POST[sector]',subsector='$_POST[subsector]',usuario='$_POST[usuario]',expediente='$_POST[expediente]',abogado='$_POST[abogado]',direccion='$_POST[direccion]',tipo='$_POST[tipo]' where id = '$_POST[id]'";
if(mysql_query($sql,$conexion)){
echo "<script language='JavaScript' type='text/javascript'>
alert('Registro modificado correctamente') </script>";
}
else
echo "<script language='JavaScript' type='text/javascript'>
alert('Error al modificar registro') </script>";
}
?>
<div id="container">
<div>
<div> <img src="../../images/cabezote BLEGAL.jpg" width="891" height="168" border="0" usemap="#Map">
<map name="Map"><area shape="poly" coords="395,94" href="#"><area shape="poly" coords="626,180" href="#"></map></div>
<div>
<FORM id=form1 name=form1 method=post>
<TABLE border=2 style="BORDER-LEFT-COLOR: green; BORDER-BOTTOM-COLOR: green; BORDER-TOP-COLOR: green; BORDER-RIGHT-COLOR: green" align="center">
<TBODY>
<TR>
<TD width="766" style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">
<div>
<TABLE>
<TBODY>
<TR>
<TD style="FONT-SIZE: 10pt; COLOR: black; HEIGHT: 18px; BACKGROUND-COLOR: #cccccc"><strong>Formulario de Modificación Actos Administrativos: <span class="Estilo3">Seleccione el auto o la resolución a modificar y luego oprima el boton consultar, realice la modificacion seguido del boton modificar. </span></strong><span style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana"><strong></strong></span> <BR></TD>
</TR>
<TR>
<TD style="COLOR: white; BACKGROUND-COLOR: #8EE910"> </TD></TR>
<TR>
<TD
style="FONT-SIZE: 12pt; COLOR: red; BACKGROUND-COLOR: gainsboro; TEXT-ALIGN: center"><p><SPAN
style="FONT-SIZE: 10pt">Si usted ya se encuentra en este modulo es porque tiene acceso a el. El ingreso de información no autorizado a este modulo est prohibido y puede estar sujeto a acciones civiles y penales.</SPAN> </p> </TD>
</TR>
<TR>
<TD style="TEXT-ALIGN: center">
<TABLE width="100%">
<TBODY>
<TR> </TR></TBODY></TABLE> </TD></TR>
<TR>
<TD
style="FONT-SIZE: 8pt; COLOR: white; BACKGROUND-COLOR: #8EE910"><TABLE width="100%">
<TBODY>
<TR>
<TD style="HEIGHT: 15px"
align=middle><div align="left"><STRONG>Solicitud Concepto Jurídico </STRONG></div></TD>
<TD style="HEIGHT: 15px" align=right><A
id=linAyudaNombre
title="">Ayuda</A><input name="id" type="hidden" class="iceReadOnly" id="id" style="" onFocus="setFocus(this.id);" onBlur="setFocus('');" onKeyPress="iceSubmit(form,this,event);" value="<?php echo $id; ?>" size="5" maxlength="5" readonly="readonly"></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD
style="HEIGHT: 42px; BACKGROUND-COLOR: activeborder; TEXT-ALIGN: center; background-color:#FFFFFF"><TABLE width="100%">
<TBODY>
<TR>
<TD width="201" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>No. </strong></TD>
<TD colspan="2" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Fecha * </strong></TD>
<TD width="261" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Titulo*</strong></TD>
<TD width="231" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Tipo</strong>* </TD>
</TR>
<TR>
<TD
align=middle bgcolor="#D4D0C8" style="WIDTH: 198px; HEIGHT: 26px"><INPUT name=no id=no tabIndex=1 value="<?php echo $no; ?>" size="12"
maxLength=12>
<img src="../../images/search.gif" width="20" height="20" border="0" onClick="popup('mostrar.php')"/></TD>
<TD width="74" align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><input name="fecha" type="text" id="fecha" onBlur="return document.MM_returnValue" value="<?php echo $fecha; ?>" size="12" maxlength="10" readonly=""></TD>
<TD width="58" align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><input name="button" type="button" onclick='popUpCalendar(this,fecha_entrada, "yyyy/mm/dd")' value=""></TD>
<TD
align=middle bgcolor="#D4D0C8" style="WIDTH: 214px; HEIGHT: 26px"><span style="HEIGHT: 26px">
<INPUT
name=resuelve
id=resuelve tabIndex=4 value="<?php echo $resuelve; ?>" size="30" maxLength=200>
</span></TD>
<TD align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><INPUT
name=tipo
id=tipo tabIndex=4 value="<?php echo $tipo; ?>" maxLength=200>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD
style="FONT-SIZE: 8pt; COLOR: white; BACKGROUND-COLOR: #8EE910"><TABLE width="100%">
<TBODY>
<TR>
<TD style="HEIGHT: 15px"
align=middle><div align="left"><STRONG>Concepto</STRONG></div></TD>
<TD style="HEIGHT: 15px" align=right><A
id=linAyudaNombre
title="">Ayuda</A></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD
style="HEIGHT: 42px; BACKGROUND-COLOR: activeborder; TEXT-ALIGN: center; background-color:#FFFFFF"><TABLE width="100%">
<TBODY>
<TR>
<TD width="215" bgcolor="#D4D0C8" style="WIDTH: 198px; HEIGHT: 15px; BACKGROUND-COLOR: activeborder" ><strong>Sector*</strong></TD>
<TD width="72" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Subsector</strong> </TD>
<TD width="232" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Usuario *</strong> </TD>
<TD width="137" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Expediente</strong> </TD>
<TD width="126" bgcolor="#D4D0C8" style="HEIGHT: 15px ; BACKGROUND-COLOR: activeborder "><strong>Abogado </strong></TD>
</TR>
<TR>
<TD
align=middle bgcolor="#D4D0C8" style="WIDTH: 198px; HEIGHT: 26px"><select size="1" name="sector" id="sector">
<?php echo "<option value='$sector' selected='selected'>$sector</option>"; ?>
<option value=""></option>
<option value="Competencia-Estructura">COMPETENCIA-ESTRUCTURA</option>
<option value="SILVICULTURA">SILVICULTURA</option>
<option value="VERTIMIENTOS">VERTIMIENTOS</option>
<option value="PEV">PUBLICIDAD EXTERIOR VISUAL</option>
<option value="AIRE">AIRE</option>
<option value="RUIDO">RUIDO</option>
<option value="RESIDUOS">RESIDUOS</option>
<option value="MINERIA">MINERIA</option>
</select></TD>
<TD align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><input name="subsector" type="text" id="subsector" onBlur="return document.MM_returnValue" value="<?php echo $subsector; ?>" size="10" maxlength="10" ></TD>
<TD
align=middle bgcolor="#D4D0C8" style="WIDTH: 214px; HEIGHT: 26px"><span style="HEIGHT: 26px">
<INPUT
name=usuario
id=usuario tabIndex=4 value="<?php if( $_POST['consulta'] || $_POST['modifica' ){ echo $usuario; }?>" size="30" maxLength=100>
</span></TD>
<TD align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><INPUT
name=expediente
id=expediente tabIndex=4 value="<?php echo $expediente; ?>" maxLength=50>
<a href="file://///pc-p12-1000380-/Documentos/NORMAS AMBIENTALES/NORMAS AMBIENTALES"></a></TD>
<TD align=middle bgcolor="#D4D0C8" style="HEIGHT: 26px"><INPUT
name=abogado
id=abogado tabIndex=4 value="<?php echo $abogado; ?>" maxLength=200>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD
style="FONT-SIZE: 8pt; COLOR: white; BACKGROUND-COLOR: #8EE910"><TABLE width="100%">
<TBODY>
<TR>
<TD style="HEIGHT: 15px"
align=middle><div align="left"></div></TD>
<TD style="HEIGHT: 15px" align=right><A
id=linAyudaNombre
title="">Ayuda</A></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD
style="HEIGHT: 42px; BACKGROUND-COLOR: activeborder; TEXT-ALIGN: center; background-color:#FFFFFF"><TABLE width="100%">
<TBODY>
<TR>
<TD bgcolor="#D4D0C8" style="WIDTH: 150px; HEIGHT: 15px; BACKGROUND-COLOR: activeborder "><strong>Dependencia que firma*</strong> <div align="center"></div></TD>
</TR>
<TR>
<TD
align=middle bgcolor="#D4D0C8" style="WIDTH: 198px; HEIGHT: 26px"><div align="left">
<INPUT name=direccion id=direccion tabIndex=1 value="<?php echo $direccion; ?>" size="100"
maxLength=60>
</div> <div align="center"></div></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD style="COLOR: white; BACKGROUND-COLOR: #8EE910"><TABLE width="100%">
<TBODY>
<TR>
<TD align=middle><div align="left"><STRONG>Observaciones</STRONG></div></TD>
<TD align=right><A id=HyperLink3
title="Ayuda ">Ayuda</A></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD style="TEXT-ALIGN: center"><TABLE width="100%">
<TBODY>
<TR>
<TD
style="WIDTH: 163px; HEIGHT: 15px; BACKGROUND-COLOR: activeborder"> </TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD bgcolor="#8EE910" style="COLOR: white; BACKGROUND-COLOR: #8EE910">
<TABLE>
<TBODY>
<TR>
<TD align=middle> </TD>
<TD align=right><A id=HyperLink1
title="Diligencie los datos solicitados">Ayuda</A></TD></TR></TBODY></TABLE><strong></strong></TD></TR>
<TR>
<TD style="TEXT-ALIGN: center">
<TABLE width="100%">
<TBODY>
<TR>
<TD
style="BACKGROUND-COLOR: activeborder"> </TD>
<TD
style="BACKGROUND-COLOR: activeborder"><span>
<input name="consulta" type="submit" id="consulta" value="Consultar" >
<input name="modifica" type="submit" id="modifica" value="Modificar" >
<input type="button" name="limpiar" value="Limpiar" onClick="location.href='modificar.php'">
</span></TD><TD width="115"
colSpan=2 style="BACKGROUND-COLOR: activeborder"><input type="button" name="limpiar2" value="Volver al menu principal" onClick="location.href='../admin.php'"></TD>
</TR>
</TBODY></TABLE> </TD>
</TR></TBODY>
</TABLE>
</div></TD></TR></TBODY></TABLE>
</form>
</div>
</div>
<?php
}
}
?>
<div class="footer">
<i class="c1">·</i>
Copyright © 2011
<i class="c1">·</i><strong>Secretaria de Ambiente </strong><b>.</b>
<i class="c1">·</i>Todos los derechos reservados <i class="c1">·</i></div>
</div><!--container-->
</body></html>
|