Ver Mensaje Individual
  #4 (permalink)  
Antiguo 05/08/2008, 14:47
rgallardo
 
Fecha de Ingreso: agosto-2008
Mensajes: 38
Antigüedad: 15 años, 9 meses
Puntos: 0
Respuesta: Funciona en el pc pero no en el Servidor

Cita:
Iniciado por Marvin Ver Mensaje
Y tu codigo?... tal vez por ahi podemos empezar a ver cual seria el problema :D

Suerte!
Yo no quise centrarme en buscar errores en el codigo, porque de haber algun error, tampoco funcionaria de forma local, pero hai va el codigo

<html>
<head>
<link rel="STYLESHEET" type="text/css" href="estadistica.css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><style type="text/css">
<!--
body {
background-image: url(img/bg92.gif);
}
.Estilo1 {
color: #006699;
font-weight: bold;
font-size: 14px ;
}
-->
</style>
<h1 class="pag_tit">Boletin Estadistico Mensual - Consultas</h1>

</head>

<script language="JavaScript" type="text/JavaScript">
function Seleccionar() {
var a = document.f1.especiali.value;
if (a != "null") {
document.f1.action="";
document.f1.submit(); }
else { alert("Seleccione un valor."); }
}
</script>

<?
function tabla_encabezado($valor) {
echo "<table border='1' width='900'>";
echo "<tr>";
echo "<td><span class='Estilo1'>$valor</span></td>";
echo "<td class='tb_tit'>&nbsp;</td>";
echo "<td colspan='5' class='tb_tit'>NUEVO</td>";
echo "<td colspan='3' class='tb_tit'>CONTROL</td>";
echo "<td colspan='3' class='tb_tit'>NSP</td>";
echo "<td class='tb_tit'>&nbsp;</td>";
echo "<tr><td width='250' class='tb_tit'>Profesional</td>";
echo "<td width='50' class='tb_tit'>TOTAL</td>";
echo "<td width='50' class='tb_tit'>Total</td>";
echo "<td width='50' class='tb_tit'>Aps</td>";
echo "<td width='50' class='tb_tit'>Cae</td>";
echo "<td width='50' class='tb_tit'>Urg</td>";
echo "<td width='50' class='tb_tit'>% Aps</td>";
echo "<td width='50' class='tb_tit'>Total</td>";
echo "<td width='50' class='tb_tit'>Altas</td>";
echo "<td width='50' class='tb_tit'>% Altas</td>";
echo "<td width='50' class='tb_tit'>Total</td>";
echo "<td width='50' class='tb_tit'>Nuevo</td>";
echo "<td width='50' class='tb_tit'>Control</td>";
echo "<td width='50' class='tb_tit'>H.tra</td>";
echo "</tr>";
}

if(!(isset($_POST['envio'])))
{
?>
<form name="f1" action="boletin.php" method="POST">
<table border="0" width="600" align="center">
<tr>
<td width="150"><span class="Estilo1">Mes de Consulta:</span> </td>
<td width="150"><select name="mes">
<option value="1" <? if($mes=='1') echo " selected "; ?>>Enero</option>
<option value="2" <? if($mes=='2') echo " selected "; ?>>Febrero</option>
<option value="3" <? if($mes=='3') echo " selected "; ?>>Marzo</option>
<option value="4" <? if($mes=='4') echo " selected "; ?>>Abril</option>
<option value="5" <? if($mes=='5') echo " selected "; ?>>Mayo</option>
<option value="6" <? if($mes=='6') echo " selected "; ?>>Junio</option>
<option value="7" <? if($mes=='7') echo " selected "; ?>>Julio</option>
<option value="8" <? if($mes=='8') echo " selected "; ?>>Agosto</option>
<option value="9" <? if($mes=='9') echo " selected "; ?>>Septiembre</option>
<option value="10" <? if($mes=='10') echo " selected "; ?>>Octubre</option>
<option value="11" <? if($mes=='11') echo " selected "; ?>>Noviembre</option>
<option value="12" <? if($mes=='12') echo " selected "; ?>>Diciembre</option>
</select>
</td>
</tr>
<td width="150"><span class="Estilo1">Especialidad:</span> </td>
<td width="500"><select name="especiali" onChange="javascript:Seleccionar();">
<option selected value=' '>Selecciona una opcion</option>"
<?
include("conectar.php");
$sql = "SELECT Servicio from boletin group by servicio";
$result = mysql_query($sql, $conexion);
while ($myrow = mysql_fetch_array($result))
{
if($myrow[0] == $especiali)
{
echo "<option selected value='$myrow[0]'>$myrow[0]</option>";
}
else
{
echo '<option value="'.$myrow[0].'">'.$myrow[0].'</option>';
}
}
?>
</select></td>
</tr>
<td width="150"><span class="Estilo1">Sub Especialidad:</span> </td>
<td width="500"><select name="sub_espe">
<option selected value="0">Selecciona una opcion</option>
<?
include("conectar.php");
$sql = "SELECT Especialidad from boletin where servicio = '" . $especiali . "' group by especialidad";
$result = mysql_query($sql, $conexion);
while ($myrow = mysql_fetch_array($result))
{
echo "<option value='$myrow[0]'>$myrow[0]</option>";
}
?>
</select></td>
</tr>
<TR>
<td width="100"></td>
<td width="300"><input type="submit" name="envio" value="Consultar" /></td>
</TR>
</table>
</form>

<?
}
else
{
require("funciones.php");
$especiali = $_POST['especiali'];
$mes = $_POST['mes'];
$sub_espe = $_POST['sub_espe'];
$nommes = dice_mes($mes);

echo "<table border='1' width='400'>";
echo "<tr>";
echo "<td width='100' class='tb_tit'>Mes</td>";
echo "<td width='300' class='tb_tit'>$nommes</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100' class='tb_tit'>Especialidad</td>";
echo "<td width='300' class='tb_tit'>$especiali</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100' class='tb_tit'>Sub Especialidad</td>";
echo "<td width='300' class='tb_tit'>$sub_espe</td>";
echo "</tr>";
echo "</table>";
echo "<br>";

include("conectar.php");
$sql = "SELECT * from boletin where mes = '" . $mes . "' and especialidad = '" . $sub_espe . "' order by accion";
$result = mysql_query($sql, $conexion);
$myrow = mysql_fetch_array($result);
tabla_encabezado($myrow[accion]);
$accion_ant = $myrow[accion];

do {

if ($myrow[accion] <> $accion_ant) {
echo "</table>"; // cerrar la tabla anterior
tabla_encabezado($myrow[accion]);
$accion_ant = $myrow[accion];
}

$xtotal = $myrow[nvo_tot] + $myrow[ctrl_total];
$h_tra = $xtotal /4;
$aps_porcen = 0;
if (($myrow[nvo_tot]) > '0') {
$aps_porcen = ($myrow[nvo_aps] / $myrow[nvo_tot])*100;
$aps_porcen = redondear_dos_decimal($aps_porcen);
}

$altas_porcen = 0;
if (($myrow[ctrl_altas]) > '0') {
$altas_porcen = ($myrow[ctrl_altas] / $myrow[ctrl_total])*100;
$altas_porcen = redondear_dos_decimal($altas_porcen);
}

echo "<tr> ";
echo "<td width='250' class='tb_dat' >$myrow[nom_medico]</td>";
echo "<td width='50' class='tb_dat2'>$xtotal</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nvo_tot]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nvo_aps]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nvo_cae]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nvo_urg]</td>";
echo "<td width='50' class='tb_dat2'>$aps_porcen</td>";
echo "<td width='50' class='tb_dat2'>$myrow[ctrl_total]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[ctrl_altas]</td>";
echo "<td width='50' class='tb_dat2'>$altas_porcen</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nsp_total]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nsp_nvos]</td>";
echo "<td width='50' class='tb_dat2'>$myrow[nsp_ctrl]</td>";
echo "<td width='50' class='tb_dat2'>$h_tra</td>";
echo "</tr>";
} while($myrow = mysql_fetch_array($result));

echo "</table>";
}
?>