Viewing file:  mostrar.php (6.9 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">
<link rel="StyleSheet" href="../../tabla_files/orangebrownie.css" type="text/css">
<script language="JavaScript">
function enviar(){
document.forms.norma.submit();
}
</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">
<div> <img src="../index_files/header.png" width="100%" height="228" border="0"></div>
<TABLE width="764" border=0 style="BORDER-LEFT-COLOR: green; BORDER-BOTTOM-COLOR: green; BORDER-TOP-COLOR: green; BORDER-RIGHT-COLOR: green" align="center">
<TR>
<TD>
<div id='boundary'>
<div id='content'>
<div id='itsthetable'>
<FORM name=f1 action="mostrar.php" method="post">
<SELECT name="ano" onChange="f1.submit();" style="font-family: Tahoma; color: #006600; font-size: 8pt; font-weight: bold; border: 1px solid #006600; background-color: #E2E2E2;">
<option value=''>Seleccione el año ...</option>
<?php
include("../../conex.php");
$sql = 'SELECT distinct YEAR(fecha_concepto) ano FROM conceptos order by fecha_concepto';
$res=mysql_query($sql,$conexion);
while ( $myrow=mysql_fetch_array($res)){
$ano=$myrow["ano"];
printf ("<option value='%s'>%s</option>",$ano, $ano);
}
?>
</SELECT><input type="button" name="limpiar2" value="Volver al menu principal" onClick="location.href='../admin.php'">
</FORM>
<table width='100%'>
<thead>
<tr>
<th width='91' scope='col'>Solicitud</th>
<th width='139' scope='col'>Radicado</th>
<th width='85' scope='col'>Fecha Radicado</th>
<th width='129' scope='col'>Solicitante</th>
<th width='186' scope='col'>No. Concepto Juridico y Fecha</th>
<th width='100' scope='col'>Seleccionar</th>
</tr>
</thead>
<?php include("../../conex.php");
$sql = "select id,radicado_entrada,fecha_entrada,solicitante,cargo,entidad,no,fecha_concepto,objeto,abogado,radicado_salida,fecha_salida,observaciones,publicacion,vinculo from conceptos where YEAR(fecha_concepto)= '$_POST[ano]' order by id asc";
//echo "$sql";
//id='$id'";
$cursor = mysql_query( $sql, $conexion );
$num_rows = mysql_num_rows($cursor);
$change=0;
while( $row = mysql_fetch_array( $cursor ) ){
$id = $row["id"];
$radicado_entrada = $row["radicado_entrada"];
$fecha_entrada = $row["fecha_entrada"];
$solicitante = $row["solicitante"];
$cargo = $row["cargo"];
$entidad = $row["entidad"];
$no = $row["no"];
$fecha_concepto = $row["fecha_concepto"];
$objeto = $row["objeto"];
$abogado = $row["abogado"];
$radicado_salida = $row["radicado_salida"];
$fecha_salida = $row["fecha_salida"];
$observaciones = $row["observaciones"];
$publicacion = $row["publicacion"];
$vinculo = $row["vinculo"];
$con = $con+1;
$year1=date("Y", strtotime($fecha_concepto));
if ($no <> '0') {
$nos = $nos + 1;
}
?>
<form name="<?php echo "form$con"; ?>" method="post" action="../conceptos/modificar.php">
<tbody>
<tr <?php if ($change == 1) {echo "class='odd'";} ?>>
<td><input name='id' type='text' onFocus='setFocus(this.id);' onBlur='setFocus(' value='<?php echo "$id"; ?>' size="4"');'></td>
<td><input type='text' name='radicado_entrada' value='<?php echo "$radicado_entrada"; ?>' onFocus='setFocus(this.id);' onBlur='setFocus('');'></td>
<td><?php echo "$fecha_entrada"; ?></td>
<td><?php echo "$solicitante"; ?></td>
<td><?php echo "Concepto $no del $year1";?>
<input name="ver" type="button" id="ver" value="+" onclick="pepe=window.open('detalle.php?id=<?php echo "$id"; ?> ','pepe')"/></td>
<td><INPUT id=creTercero:_id468 onBlur="setFocus('');" onfocus=setFocus(this.id); onClick="window.opener.document.getElementById('radicado_entrada').value = window.document.<?php echo "form$con"; ?>.radicado_entrada.value;
window.opener.document.getElementById('id').value = window.document.<?php echo "form$con"; ?>.id.value; window.opener.focus(); self.close(); return false;" type=button value=Aceptar name=creTercero:_id468>
</INPUT>
</INPUT></td>
</tr>
</form>
<?php
if ($change == 0){
$change=1;
}
else if ($change == 1){
$change=0;
}
}
?>
<tfoot>
<tr>
<td>Total Solicitudes :</td>
<td><?php echo "$num_rows"; ?></td>
<td >Total Conceptos :</td>
<td ><?php echo "$nos"; ?></td>
<td >Indicador de Eficiencia:</td>
<td ><?php echo $nos/$num_rows*100; ?></td>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</TD>
</TR>
</TBODY></TABLE> </TD>
</TR></TBODY>
</TABLE>
</FORM>
<?php
}
}
?>
<div class="footer">
<i class="c1">·</i>
Copyright © 2010
<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>
|