Viewing file: esta.php (13.52 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Módulo General de Estadísticas</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
button {
font-family: "Times New Roman", Times, serif;
font-size: 12px;
color: #000000;
background-color: #99CCFF;
}
input {
font-family: "Times New Roman", Times, serif;
font-size: 14px;
color: #000000;
background-color: #E6F2FF;
border: 1px solid #999999;
}
select {
font-family: "Times New Roman", Times, serif;
font-size: 14px;
color: #000000;
background-color: #E6F2FF;
}
textarea {
font-family: "Times New Roman", Times, serif;
font-size: 14px;
color: #000000;
background-color: #E6F2FF;
}
a {
color: #0099CC;
text-decoration: none;
}
a:hover {
color: #0099CC;
text-decoration: underline;
}<strong></strong>
-->
</style>
</head>
<body text="#000000" link="#0099CC" vlink="#0099CC" alink="#0099CC" topmargin="0">
<table width="100%" border="0" cellpadding="5">
<tr>
<td width="100%" colspan="2"><div align="center">
<p><img src="esta/1.gif" width="750" height="135"></p>
<table width="750" border="1" cellpadding="4" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<?php
require('hoy.php');
$today1 = $mday . "/" . $montho . "/" . $year;
$today = $mday . "/" . $month . "/" . $year;
?>
<td width="50%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Estadísticas
para el día:<strong> <?php echo $today; ?></strong></font></td>
<td width="50%"><div align="right"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Contador
general de visitas para Internet: </font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><img
src="http://fastcounter.linkexchange.com/fastcounter?619753+1239513" border="0" width="90"
height="16"></font></div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<table width="750" border="1" cellpadding="5" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="5%" bgcolor="#FFCC00"> <div align="center"><font color="#FFFFFF" size="5" face="Verdana, Arial, Helvetica, sans-serif">1</font></div></td>
<td width="95%"><table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#CCCCCC">
<tr bgcolor="#F2F2F2">
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Quejas
y Reclamos vía Web.</strong></font></td>
</tr>
<tr>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM esta where fecha='$today1' and codigo='1'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f = $myrow["numero"];
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='1'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
?>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de quejas para hoy:<strong> <?php echo $f; ?></strong></font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de quejas en el mes: <strong><?php echo $f2; ?></strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td width="5%" bgcolor="#FF9900"> <div align="center"><font color="#FFFFFF" size="5" face="Verdana, Arial, Helvetica, sans-serif">2</font></div></td>
<td width="95%"><table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#CCCCCC">
<tr bgcolor="#F2F2F2">
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Autoliquidación</strong></font></td>
</tr>
<tr>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM esta where fecha='$today1' and codigo='6'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f = $myrow["numero"];
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='6'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
$consul = "SELECT *
FROM vali"
. " order by cons DESC";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f4 = $myrow["cons"];
?>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de recibos en el día: <strong><?php echo $f; ?></strong></font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de recibos en el mes: <strong><?php echo $f2; ?></strong></font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Ultimo
recibo generado: <strong><?php echo $f4; ?></strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td width="5%" bgcolor="#FF3300"> <div align="center"><font color="#FFFFFF" size="5" face="Verdana, Arial, Helvetica, sans-serif">3</font></div></td>
<td width="95%"><table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#CCCCCC">
<tr bgcolor="#F2F2F2">
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Tráfico
por Secciones</strong></font></td>
</tr>
<tr>
<td><table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999">
<tr bgcolor="#CCCCCC">
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Nombre</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tráfico/Día</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tráfico/Mes</font></td>
</tr>
<tr>
<td width="50%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Ecosistemas
estratégicos</font></td>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM esta where fecha='$today1' and codigo='3'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f = $myrow["numero"];
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='3'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
?>
<td width="25%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f; ?>
h</strong></font></td>
<td width="25%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f2; ?>
h</strong></font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Incendios
forestales</font></td>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM esta where fecha='$today1' and codigo='4'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f = $myrow["numero"];
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='4'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
?>
<td width="25%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f; ?>
h</strong></font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f2; ?>
h</strong></font></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999">
<tr bgcolor="#CCCCCC">
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Nombre</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tráfico/Día</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tráfico/Mes</font></td>
</tr>
<tr>
<td width="50%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Noticias
Ambientales</font></td>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM esta where fecha='$today1' and codigo='5'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$f = $myrow["numero"];
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='5'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
?>
<td width="25%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f; ?>
h</strong></font></td>
<td width="25%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $f2; ?>
h</strong></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">Incendios
forestales</font></td>
<td width="25%"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>3
h</strong></font></td>
<td><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>3
h</strong></font></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="5%" bgcolor="#993300"> <div align="center"><font color="#FFFFFF" size="5" face="Verdana, Arial, Helvetica, sans-serif">4</font></div></td>
<td width="95%"><table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#CCCCCC">
<tr bgcolor="#F2F2F2">
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Legislación
Ambiental Colombiana</strong></font></td>
</tr>
<tr>
<?php
$f = 0;
require('conexion3.php');
$consul = "SELECT *
FROM legis";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f3 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f3++;
}
$chain = $montho . "/" . $year;
$consul = "SELECT *
FROM esta where fecha like '%$chain%' and codigo='2'";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$f2 = 0;
while ($myrow = mysql_fetch_array($result))
{
$f1 = $myrow["numero"];
$f2 = $f2 + $f1;
}
?>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de normas en la base de datos: <?php echo $f3; ?> </font></td>
<td width="50%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Hits
mes: <?php echo $f2; ?> </font></td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="2"><div align="center"><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">
Todos los Derechos Reservados para el DAMA<br>
Departamento Técnico Administrativo del Medio Ambiente.<br>
Su hbsistema del Sistema de Información Ambiental SIA-DAMA<br>
<strong>2003 - 2004</strong></font></div></td>
</tr>
</table>
<p> </p>
</body>
</html>
|