if ($movement == "dep") { $msg .= mysql_result($querymodal, 0, 'slottime'); } else { $msg .= '<span style="color: red;">' . timeOperation(mysql_result($querymodal, 0, 'slottime'), flighttime(mysql_result($querymodal, 0, 'origin'), mysql_result($querymodal, 0, 'destination'), mysql_result($querymodal, 0, 'acft')), "diff") . '</span>'; } $msg .= '</span><br/><span style="font-size: 10px;">'; if ($movement == "dep") { $msg .= "ZULU"; } else { $msg .= '<span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span>'; } $msg .= '</span></td><td style="vertical-align: middle;"><span style="font-size: 30px;">'; if ($movement == "arr") { $msg .= mysql_result($querymodal, 0, 'slottime'); } else { $msg .= '<span style="color: red;">' . timeOperation(mysql_result($querymodal, 0, 'slottime'), flighttime(mysql_result($querymodal, 0, 'origin'), mysql_result($querymodal, 0, 'destination'), mysql_result($querymodal, 0, 'acft')), "add") . '</span>'; } $msg .= '</span><br/><span style="font-size: 10px;">'; if ($movement == "arr") { $msg .= "ZULU"; } else { $msg .= '<span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span>'; } $msg .= '</span></td> </tr> <tr style="border-bottom: 1px solid #444"> <td style="border-bottom: 1px solid #444"><b>Gate</b></td> <td style="border-bottom: 1px solid #444" colspan="2"><b>Route</b> <span style="font-size: 12px;">(extracted from FlightAware - double-check it)</span></td> </tr> <tr height="50px"> <td style="vertical-align: middle;"><span style="font-size: 30px; font-weight: bold;background-color: #F2EF30; padding: 0 10px;">TBD</span></td>
</span><br/><span style="font-size: 10px;"><?php if (mysql_result($querymodal, 0, 'deptime') != "----") { echo "ZULU"; } else { ?> <span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span><?php } ?> </span> <td style="vertical-align: middle;"><span style="font-size: 30px; margin-top: 10px;"><?php if (mysql_result($querymodal, 0, 'arrtime') != "----") { echo mysql_result($querymodal, 0, 'arrtime'); } else { ?> <span style="color: red;"><?php echo timeOperation(mysql_result($querymodal, 0, 'deptime'), flighttime(mysql_result($querymodal, 0, 'origin'), mysql_result($querymodal, 0, 'destination'), mysql_result($querymodal, 0, 'acft')), "add"); ?> </span><?php } ?> </span><br/><span style="font-size: 10px;"><?php if (mysql_result($querymodal, 0, 'arrtime') != "----") { echo "ZULU"; } else { ?> <span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span><?php } ?> </span> </tr> <tr style="border-bottom: 1px solid #444">
</span><br/><span style="font-size: 10px;"><?php if ($movement == 'dep') { echo "ZULU"; } else { ?> <span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span><?php } ?> </span></td> <td style="vertical-align: middle;"><span style="font-size: 30px; margin-top: 10px;"><?php if ($movement == 'arr') { echo mysql_result($queryprvdet, $j, 'slottime'); } else { ?> <span style="color: red;"><?php echo timeOperation(mysql_result($queryprvdet, $j, 'slottime'), flighttime(mysql_result($queryprvdet, $j, 'origin'), mysql_result($queryprvdet, $j, 'destination'), mysql_result($queryprvdet, $j, 'acft')), "add"); ?> </span><?php } ?> </span><br/><span style="font-size: 10px;"><?php if ($movement == 'arr') { echo "ZULU"; } else { ?> <span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span><?php } ?> </span></td> </tr> <tr style="border-bottom: 1px solid #444">