ehhhh, holas de nuevo,
hice esta funcion q deberia recorrerme la tabla como si fuese una matriz, pero creo q se queda cono guindada con el bucle do, no se solo creo (nada q sea cierto), les muestro a ver si me ayudan un poquito..
modificar.js
Código PHP:
function cambiar()
{
fila = document.getElementById("tabla");
filas= fila.rows.length;
for (j=0;j<10;j++)
for (i=0;i<=filas;i++)
{
cant=fila.rows[i].cells[j].childNodes[0].innerText;
document.write(cant);
}
}
Codigo completo..
Código PHP:
<html>
<head>
<title>Hoja de Tiempo Semanal</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/javascript">
function modificar() {
for (i=0; ele=document.fcalen.elements[i]; i++)
ele.disabled=false;
}
function cambiar()
{
fila = document.getElementById("tabla");
filas= fila.rows.length;
for (j=0;j<10;j++)
for (i=0;i<=filas;i++)
{
cant=fila.rows[i].cells[j].childNodes[0].innerText;
document.write(cant);
}
}
</script>
</head>
<body onLoad="setDefaults1(document.fcalen.fecha_del, document.fcalen.fecha_al)">
<form name="fcalen" method="post" action="hoja_semanal2.php">
<table width="800" height="600" border="0">
<tr>
<td height="19" colspan="4" ><div align="center" class="style2">HOJA DE TIEMPO SEMANAL</div></td>
<td width="103" rowspan="4"><img src="images/Logo Incostas Documentos.jpg" width="100" height="82"></td>
</tr>
<tr>
<td height="20" colspan="4" > </td>
</tr>
<tr>
<td width="163" height="9" ><div align="center" class="style1">C.I:
<?
//DB
Include("Conectarse1.php");
$conn=Conectarse1();
//Declaracion y optencion de vaiables
$cedula=$_POST['cedula'];
$fecha_del=$_POST['fecha_del'];
$fecha_al=$_POST['fecha_al'];
?>
</div></td>
<td width="217"><div align="center" class="style1">Nombre:</strong></div></td>
<td width="158"><div align="left" class="style1">Del: </div></td>
<td width="148" height="9"><div align="left" class="style1">Al:</div></td>
</tr>
<tr>
<td height="10" ><div align="center">
<input name="cedula" type="text" value="<? echo $cedula; ?>">
</div></td>
<td width="217"><div align="center">
<input name="nombre" type="text" value="<? echo $nombre; echo " "; echo $apellido; ?>">
</div></td>
<td width="158"><input type="text" name="fecha_del" value="<? echo $fecha_del; ?>"> </td>
<td height="10"><input type="text" name="fecha_al" value="<? echo $fecha_al; ?>"> </td>
</tr>
<tr>
<td height="29" colspan="5"> </td>
</tr> <tr>
<td height="13" colspan="5"><div align="center" class="style3">HORAS TRABAJADAS </div></td>
</tr>
<tr>
<td height="14" colspan="5"> </td>
</tr>
<tr>
<td colspan="5" valign="top">
<table width="800" border="0">
<tr>
<td height="26" colspan="8"><div align="center">
<?
//consulta a la db
$query = "SELECT contrato, actividad, descripcion, SUM(CASE fecha WHEN '$fecha_del1' THEN horas ELSE 0 END) as lun, SUM(CASE fecha WHEN '$fecha_del2' THEN horas ELSE 0 END) as mar, SUM(CASE fecha WHEN '$fecha_del3' THEN horas ELSE 0 END) as mier, SUM(CASE fecha WHEN '$fecha_del4' THEN horas ELSE 0 END) as jue, SUM(CASE fecha WHEN '$fecha_del5' THEN horas ELSE 0 END) as vier, SUM(CASE fecha WHEN '$fecha_del6' THEN horas ELSE 0 END) as sab, SUM(CASE fecha WHEN '$fecha_del7' THEN horas ELSE 0 END) as dom FROM maestro WHERE cedula='$cedula' and fecha BETWEEN '$fecha_del' AND '$fecha_al' GROUP BY descripcion, actividad, contrato order by contrato, actividad, descripcion";
$result = pg_Exec($conn,$query);
$filas=pg_num_rows($result);
if($row=pg_fetch_array($result))
{
echo"<TABLE width='800' BORDER=0 CELLPADDING=1 CELLSPACING=1 bordercolor='#003399'>";
echo" <tr><td colspan='2' width='250'><div align='center' class='style4'>
CODIGOS
</div></td>
<td width='150' rowspan='2'><div align='center' class='style4'>DESCRIPCION DE ACTIVIDAD</div> </td>
<td colspan='7' width='350'><div align='center' class='style4'>DIAS DE LA SEMANA</div> </td>
<td width='45'><div align='center' class='style4'></div></td>
</tr>
<tr>
<td width='100' height='29'><div align='center' class='style4'>Proy/Dpto</div></td>
<td width='150'><div align='center' class='style4'>Actividad</div></td>
<td width='45'><div align='center' class='style4'>LUN</div></td>
<td width='45'><div align='center' class='style4'>MAR</div></td>
<td width='45'><div align='center' class='style4'>MIER</div></td>
<td width='45'><div align='center' class='style4'>JUE</div></td>
<td width='45'><div align='center' class='style4'>VIE</div></td>
<td width='45'><div align='center' class='style4'>SAB</div></td>
<td width='45'><div align='center' class='style4'>DOM</div></td>
<td width='45'><div align='center' class='style4'>Aprob</div></td></tr>";
echo" </TABLE>";
echo"<TABLE width='800' BORDER=0 CELLPADDING=1 CELLSPACING=1 bordercolor='#003399'>";
echo "<tbody id='tabla'>";
do
{
printf("<tr><td><div align='center'><input type='text' name='contrato' value='%s' onChange='cambiar()' size='10' disabled></div></td>
<td><div align='center'><input type='text' name='actividad' value='%s' onChange='cambiar()' size='10' disabled></div></td>
<td><div align='center'><input type='text' name='descripcion' value='%s' onChange='cambiar()' size='15' disabled></div></td>
<td><div align='center'><input type='text' name='lun' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='mar' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='mier' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='jue' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='vier' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='sab' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='text' name='dom' value='%d' size='2' onChange='cambiar()' disabled></div></td>
<td><div align='center'><input type='checkbox' id='aprob' disabled></div></td>
</tr>",$row["contrato"],$row["actividad"], $row["descripcion"], $row["lun"], $row["mar"], $row["mier"], $row["jue"], $row["vier"], $row["sab"], $row["dom"],"");
}
while($row=pg_fetch_array($result));
echo "</tbody>";
echo" </TABLE>";
?>
<input type="button" onClick="modificar()" value="modificar" style="background-color:#003399;color:#ffffff;font-family:Verdana;font-weight:bold; background-color:#003399">
<input name="guardar" type="submit" value="Guardar" style="background-color:#003399;color:#ffffff;font-family:Verdana;font-weight:bold; background-color:#003399">
<?
}
else
{
echo "<div align='center'><h4 class='style1'>¡ No se han registrado horas para esta semana !</h4></div>";
}
pg_close($conn);
?>
</div>
</td>
</tr>
<tr>
<td colspan="8">
</td>
</tr>
<tr>
<td width="11" height="26"> </td>
<td width="11" height="26"> </td>
<td width="11" height="26"> </td>
<td width="110" height="26"> </td>
<td width="242" height="26"></td>
<td width="177" height="26"> </td>
<td width="1" height="26"> </td>
<td width="203" height="26"> </td>
</tr>
<tr>
<td height="26" colspan="8"> </td>
</tr>
<tr>
<td height="26" colspan="8"><div align="right"><a href="salir.php" class="style6">Salir</a></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5" valign="top"> </td>
</tr>
</table>
</form>
</body>
</html>