Viewing file:  legis5.php (15.4 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$sed = isset($user);
if ($sed == false) {
exit;
}else{
//require('conexion2.php');
//$stmt = Ociparse($c1, " SELECT EU_USERNAME FROM envista.env_users where EU_USERNAME='$user'");
//$result = OCIExecute($stmt);
//if ($result == false) {
//exit;
//}else{
//$cont = 0;
//while (OCIFetchInto($stmt, $value1)) {
//foreach ($value1 as $val1)
//{
//$cont++;
//}}
$cont = 1;
if ($cont == 1) {
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Legislación Ambiental Colombiana</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.textopequeno {
font-family: "Times New Roman", Times, serif;
font-size: 10px;
color: #333333;
}
select {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #666666;
background-color: #FFFFF9;
}
.in1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #666666;
background-color: #FFFFF9;
}
.in1Copia {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #333333;
background-color: #B9E7FD;
}
a {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #006699;
text-decoration: none;
}
a:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #006699;
text-decoration: underline;
}
-->
</style>
<script language="Javascript1.2">
//Directory must end with a '/'
//Examples:
// AK_editor_url = "TextAreaPro/";
AK_editor_url = "";
document.write('<scr' + 'ipt src="' + AK_editor_url+ 'wysiwyg.js" language="Javascript1.2"></scr' + 'ipt>');
</script>
</head>
<body topmargin="0">
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3"><div align="center"><img src="legis.gif" width="550" height="150"></div></td>
<td width="20%"> </td>
</tr>
<tr>
<td> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFF9"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="reqlegis.php?user=<?php echo $user; ?>">Volver
a Buscar...</a></div></td>
</tr>
</table></td>
<td bordercolor="#CCCCCC" bgcolor="#F2F2F2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="#">Agregar Normas...</a></div></td>
</tr>
</table>
</td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFF9"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="reqlegis3.php?user=<?php echo $user ?>">Agregar
Entidades...</a></div></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3" bordercolor="#CCCCCC" bgcolor="#FFFFF9"> <form action="" method="post" enctype="multipart/form-data" name="form1">
<p><font size="5"><strong><font size="2">>></font> Editar Legislación...</strong></font></p>
<?php
$sed = isset($acc);
if ($sed == true) {
if ($acc == 1) {
$fec = $mes . "/" . $ano;
$nas = $tipo . "_" . $numero . "_de_" . $fec;
require('conexion3.php');
$query ="UPDATE legis SET numero='$numero',fecha='$ano',entidad='$entidad',tipo='$tipo',etiqueta='$keywords',texto='$MyTextAreaName',titulo='$titulo',mes='$mes',regid='$regid' WHERE id='$id'";
$result = mysql_query($query,$db);
if ($result == 0) {
?>
<p><font color="#000000" size="3" face="Times New Roman, Times, serif">Error: No se pudo editar la norma, intente nuevamente.</font></p>
<?php
}else{
?>
<p><font color="#000000" size="3" face="Times New Roman, Times, serif">Se
edito con éxito la norma: <?php echo $nas; ?></font></p>
<?php
}}}
?>
<p>Ingrese todos los datos que se solicitan, para poder registrar una
norma en el sistema general de consulta de legislación ambiental.
Esta agregando <strong><?php echo $user; ?></strong></p>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<?php
require('conexion3.php');
$consul = "SELECT *
FROM legis where id=$id";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$numero = $myrow["numero"];
$fecha = $myrow["fecha"];
$entidad = $myrow["entidad"];
$tipo = $myrow["tipo"];
$etiqueta = $myrow["etiqueta"];
$texto = $myrow["texto"];
$titulo = $myrow["titulo"];
$link = $myrow["link"];
$mes = $myrow["mes"];
$regid = $myrow["regid"];
}
$prese= $tipo . " " . $numero . " de " . $fecha;
?>
<tr bgcolor="#FAFEE2">
<td width="50%"><strong> Tipo:
<select name="tipo" id="tipo">
<?php if($tipo == "Resolucion") { ?>
<option value="Resolucion" selected>Resolución</option>
<?php }else{ ?>
<option value="Resolucion">Resolución</option>
<?php } ?>
<?php if($tipo == "Decreto") { ?>
<option value="Decreto" selected>Decreto</option>
<?php }else{ ?>
<option value="Decreto">Decreto</option>
<?php } ?>
<?php if($tipo == "Ley") { ?>
<option value="Ley" selected>Ley</option>
<?php }else{ ?>
<option value="Ley">Ley</option>
<?php } ?>
<?php if($tipo == "Acuerdo") { ?>
<option value="Acuerdo" selected>Acuerdo</option>
<?php }else{ ?>
<option value="Acuerdo">Acuerdo</option>
<?php } ?>
<?php if($tipo == "Sentencia") { ?>
<option value="Sentencia" selected>Sentencia</option>
<?php }else{ ?>
<option value="Sentencia">Sentencia</option>
<?php } ?>
<?php if($tipo == "Accion Popular") { ?>
<option value="Accion Popular" selected>Accion Popular</option>
<?php }else{ ?>
<option value="Accion Popular">Accion Popular</option>
<?php } ?>
</select>
No.
<input name="numero" type="text" class="in1" id="numero" value="<?php echo $numero; ?>" size="6" maxlength="6">
</strong></td>
<td width="50%">De,<strong> Mes:
<select name="mes" id="mes">
<?php if($mes == "01") { ?>
<option value="01" selected>Enero</option>
<?php }else{ ?>
<option value="01">Enero</option>
<?php } ?>
<?php if($mes == "02") { ?>
<option value="02" selected>Febrero</option>
<?php }else{ ?>
<option value="02">Febrero</option>
<?php } ?>
<?php if($mes == "03") { ?>
<option value="03" selected>Marzo</option>
<?php }else{ ?>
<option value="03">Marzo</option>
<?php } ?>
<?php if($mes == "04") { ?>
<option value="04" selected>Abril</option>
<?php }else{ ?>
<option value="04">Abril</option>
<?php } ?>
<?php if($mes == "05") { ?>
<option value="05" selected>Mayo</option>
<?php }else{ ?>
<option value="05">Mayo</option>
<?php } ?>
<?php if($mes == "06") { ?>
<option value="06" selected>Junio</option>
<?php }else{ ?>
<option value="06">Junio</option>
<?php } ?>
<?php if($mes == "07") { ?>
<option value="07" selected>Julio</option>
<?php }else{ ?>
<option value="07">Julio</option>
<?php } ?>
<?php if($mes == "08") { ?>
<option value="08" selected>Agosto</option>
<?php }else{ ?>
<option value="08">Agosto</option>
<?php } ?>
<?php if($mes == "09") { ?>
<option value="09" selected>Septiembre</option>
<?php }else{ ?>
<option value="09">Septiembre</option>
<?php } ?>
<?php if($mes == "10") { ?>
<option value="10" selected>Octubre</option>
<?php }else{ ?>
<option value="10">Octubre</option>
<?php } ?>
<?php if($mes == "11") { ?>
<option value="11" selected>Noviembre</option>
<?php }else{ ?>
<option value="11">Noviembre</option>
<?php } ?>
<?php if($mes == "12") { ?>
<option value="12" selected>Diciembre</option>
<?php }else{ ?>
<option value="12">Diciembre</option>
<?php } ?>
<option value="01">Enero</option>
<option value="02">Febrero</option>
<option value="03">Marzo</option>
<option value="04">Abril</option>
<option value="05">Mayo</option>
<option value="06">Junio</option>
<option value="07">Julio</option>
<option value="08">Agosto</option>
<option value="09">Septiembre</option>
<option value="10">Octubre</option>
<option value="11">Noviembre</option>
<option value="12">Diciembre</option>
</select>
Año:
<input name="ano" type="text" class="in1" id="ano" value="<?php echo $fecha; ?>" size="4" maxlength="4">
</strong></td>
</tr>
<tr bgcolor="#FAFEE2">
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%"><strong>Emitida por:</strong></td>
<td><strong>
<select name="entidad" id="entidad">
<?php
require('conexion3.php');
$consul = "SELECT *
FROM entidad";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$ide = $myrow["id"];
$noe = $myrow["nomen"];
if ($ide == $entidad) {
echo "<option value=\"$ide\" selected>$noe</option>";
}else{
echo "<option value=\"$ide\">$noe</option>";
}
}
?>
</select>
</strong></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FAFEE2">
<td colspan="2"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%"><strong>Reglamenta:</strong></td>
<td><strong>
<select name="regid" id="regid">
<option value="0">Ninguna norma...</option>
<?php
require('conexion3.php');
$consul = "SELECT *
FROM legis"
. " order by tipo,numero,fecha";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$ide = $myrow["id"];
$tipoe = $myrow["tipo"];
$numeroe = $myrow["numero"];
$fechae = $myrow["fecha"];
$prex = $tipoe . " " . $numeroe . " de " . $fechae;
if ($ide == $regid) {
echo "<option value=\"$ide\" selected>$prex</option>";
}else{
echo "<option value=\"$ide\">$prex</option>";
}
}
?>
</select>
</strong></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FAFEE2">
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><strong>Palabras Id:</strong></td>
<td><strong>
<input name="keywords" type="text" class="in1Copia" id="keywords" value="<?php echo $etiqueta; ?>" size="40">
</strong><font size="1"><br>
</font><span class="textopequeno">* Escriba las palabras identificadoras
por las cuales quiere que se encuentre <br>
esta norma en el sistema, separadas por comas.</span></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FAFEE2">
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><strong>Titulo:</strong></td>
<td><strong>
<input name="titulo" type="text" class="in1Copia" id="titulo" value="<?php echo $titulo; ?>" size="40">
</strong><font size="1"><br>
</font><span class="textopequeno">* Incluya el considerando
de la norma o título.</span></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FAFEE2">
<td colspan="2"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><strong>Texto de la Norma:</strong></td>
<td><strong>
<textarea cols="70" rows="20" name="MyTextAreaName">
<?php echo $texto; ?>
</textarea>
<script language="JavaScript">
//comment any button that you want to hide
var AK_DisplayedButtons = Array(
'FontName',
'FontSize',
'SelectAll',
'Delete',
'Cut',
'Copy',
'Paste',
'SaveAs',
'Print',
'Separator',
'Bold',
'Italic',
'Underline',
'Strikethrough',
'Separator',
'JustifyLeft',
'JustifyCenter',
'JustifyRight',
'JustifyFull',
'Separator',
'InsertOrderedList',
'InsertUnorderedList',
'Outdent',
'Indent',
'Separator',
'SuperScript',
'SubScript',
'Separator',
'CreateLink',
'Unlink',
'Image',
'Separator',
'Forecolor',
'Backcolor',
'Separator'
//the last one has NO comma
);
var AK_width = 400;
var AK_height = 300;
// All fields are optional. Place "null" where you don't want to specify.
//ak_wysiwyg_generator(width, height, "TextAreaName", DisplayedButtonList);
ak_wysiwyg_generator(AK_width, AK_height, "MyTextAreaName", AK_DisplayedButtons);
//Examples:
// ak_wysiwyg_generator(null, null, "MyTextAreaName", AK_DisplayedButtons);
// ak_wysiwyg_generator(AK_width, AK_height, null, AK_DisplayedButtons);
// ak_wysiwyg_generator(AK_width, AK_height, "MyTextAreaName", null);
// It can be no parameter at all
// ak_wysiwyg_generator();
</script>
</strong></td>
</tr>
</table></td>
</tr>
</table>
<p align="center">
<input name="id" type="hidden" id="acc" value="<?php echo $id; ?>">
<input name="acc" type="hidden" id="user3" value="1">
<input name="user" type="hidden" id="user" value="<?php echo $user; ?>">
<input name="Submit" type="submit" class="in1" value="Editar la legislación...">
</p>
</form></td>
<td width="20%"> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3"><div align="center"><img src="legis2.gif" width="550" height="30">
<br>
<span class="textopequeno">© Copyright, DAMA 2003. Todos los Derechos
Reservados para<br>
El Departamento Técnico Administrativo del Medio Ambiente</span></div></td>
<td width="20%"> </td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
<?php
//}}
}
//$c2 = OciLogoff($c1);
}
?>
|