Medidas de la sombra de tu equipo:";
if ( mysql_num_rows( $result ) == 0 ) {
print "
No hay mediciones reportadas todavía
";
}
else {
print "
";
print "| Fecha | Hora Local | Latitud | Longitud | Elevación | Altura de Nomon | Longitud de la Sombra |
|---|
";
while ( $shadow = mysql_fetch_assoc( $result ) ) {
$datetime = strtotime( $shadow[Datetime] );
$date = date( "M j, 2007", $datetime );
$time = date( "g:i a", $datetime );
print "| $date | $time | $shadow[Latitude] | $shadow[Longitude] | $shadow[Elevation] | $shadow[Gnomon] | $shadow[Shadow] |
";
}
print "
";
}
print "
Medidas de la sombra de tus colaboradores:
";
$result_partners = get_partners( $db, $team["ID"] );
if ( mysql_num_rows( $result_partners ) == 0 ) print "
No se ha encontrado asociados
";
else {
print "
";
print "| Team | Fecha | Hora Local | Latitud | Longitud | Elevación | Altura de Nomon | Longitud de la Sombra |
|---|
";
while ($partners = mysql_fetch_row( $result_partners )) {
for ( $i=0; $i<6; $i++ ) {
if ( $partners[ $i ] ==0 or $partners[ $i ] == $team["ID"] ) continue;
$result_team = get_team_by_id( $db, $partners[ $i ] );
if ( $result_team === false or mysql_num_rows( $result_team ) == 0 ) $msg = "Sorry, could not retrieve partner information ". mysql_error(); // remove mysql_error when live
else {
$pteam = mysql_fetch_assoc( $result_team );
$result_shadow = get_shadow( $db, $partners[ $i ] );
$rows = mysql_num_rows( $result_shadow );
$rows1 = ($rows == 0 ? 1 : $rows );
print "| $pteam[Name] | ";
if ( $rows == 0 ) {
print "No hay mediciones reportadas todavía | ";
}
else {
while ( $shadow = mysql_fetch_assoc( $result_shadow ) ) {
$datetime = strtotime( $shadow[Datetime] );
$date = date( "M j, 2007", $datetime );
$time = date( "g:i a", $datetime );
print "$date | $time | $shadow[Latitude] | $shadow[Longitude] | $shadow[Elevation] | $shadow[Gnomon] | $shadow[Shadow] |
";
}
}
}
}
}
print "
";
}
}
}
if ( $msg or ! $_POST["Submit"] ) {
?>
