Time dependant functions coding help please.

[maverickalex]

Hi all, I am trying to create a "Flights Display Table" which grabs schedules from a database. I am trying to add some time dependant strings. So that when a schedule reaches the one hour to go time the string reads "proceed to gate" when less that 15 minute string says "final call".

 

Same sort of thing for arrival statistics.

 

I have the table displaying and i can get "proceed to gate" and "scheduled departure" to show. heres my code so far, im just struggling to get the right code to show the "Final Call" and any in between strings.

 

$query = "SELECT * FROM phpvms_schedules ORDER BY deptime + 0 ASC";  
$list = DB::get_results($query);  
echo '<h3>Expected Departures - Current Time is '.date('G:i').'</h3>';  
echo '<table width="90%" border="1">';  
echo '<tr><td><b>Flight Number</b></td><td><b>Departure</b></td><td><b>Arrival</b></td><td><b>Departure Time</b></td><td><b>Aircraft</b></td><td><b>Status</b></td></tr>';  
$count = 0;  
foreach($list as $flight)  
{  
        if(date('G:i') >= '23')  
        {$time = '0';}  
        else  
        {$time = date('G:i');}  
                if(($flight->deptime + 0) > $time)  
                {  
        if($count < 5)  
        {  
                $aircraft = OperationsData::getAircraftInfo($flight->aircraft);  
                echo '<tr><td>'.$flight->flightnum.'</td><td>'.$flight->depicao.'</td><td>'.$flight->arricao.'</td><td>'.$flight->deptime.'</td><td>'.$aircraft->fullname.'</td>';  
                echo '<td>';  
                if(($flight->deptime - date('G:i')) <= 1 / 60 * 15)  
                {  
                echo 'Final Call';  
                }  
                 
                if(($flight->deptime - date('G:i')) <= 1)  
                {  
                echo 'Proceed to Gate';  
                }  
                 
   else 
                {  
                echo 'Scheduled Departure';  
                }  
                echo '</td></tr>';  
                $count++;  
        }  
        }  
}  
echo '</table>'; 

echo '<h3>Expected Arrivals - Current Time is '.date('G:i').'</h3>';  
echo '<table width="90%" border="1">';  
echo '<tr><td><b>Flight Number</b></td><td><b>Departure</b></td><td><b>Arrival</b></td><td><b>Arrival Time</b></td><td><b>Aircraft</b></td><td><b>Status</b></td></tr>';  
$count = 0;  
foreach($list as $flight)  
{  
        if(date('G:i') >= '23')  
        {$time = '0';}  
        else  
        {$time = date('G:i');}  
                if(($flight->arrtime + 0) > $time)  
                {  
        if($count < 5)  
        {  
                $aircraft = OperationsData::getAircraftInfo($flight->aircraft);  
                echo '<tr><td>'.$flight->flightnum.'</td><td>'.$flight->depicao.'</td><td>'.$flight->arricao.'</td><td>'.$flight->arrtime.'</td><td>'.$aircraft->fullname.'</td>';  
                echo '<td>'; 
                 if(($flight->arrtime - date('G:i')) <= 1 / 60 * 1)  
                {  
                echo 'Landed';  
                } 
                 
                if(($flight->arrtime - date('G:i')) <= 1 / 60 * 15)  
                {  
                echo 'On Approach';  
                }  
                else  
                {  
                echo 'On Time';  
                }  
                echo '</td></tr>';  
                $count++;  
        }  
        }  
}  
echo '</table>';  

 

Any help would be appreciated Thanks

[kalivos]

I'm going to make an assumption here. I'm going to assume that $flight->deptime returns in the format of date('G:i').

 

I wasn't sure how PHP handled subtraction in that format, so I wrote a small script.

<?php
$depart = "10:30";
$now = date('G:i');	 //02:45 at time of writing
echo $depart - $now;
?>

 

The above code displayed 8. This is because PHP stops at a non-numeric value. It seems like it only calculates 10-02. To get around this, you can try using strtotime()

 

example:

$to_time=strtotime("2010-05-26 10:30:00");
$from_time=strtotime("2010-05-26 02:45:00");
echo round(abs($to_time - $from_time) / 60,2)

 

Hope that helps,

-Kalivos

[maverickalex]

Thanks, The actual time side of things works fine. Its trying to display anything in the status field of the table which has a value in between 1 hour and o minutes. If you look at the code, i have split 1 hour into minutes by 1/60 *15 (for 15minutes).

 

I have used the <= to display less than 1 hour, im sure i need a >= somewhere and/or properly coding the "if" function.

 

You can view the table on the dev site front page here as it is,

 

www.atlasvirtualairlines.com/dev/index.php

[kalivos]

I understand your thinking, but I don't think that will work in the current format.

 

Lets break this into two pieces:

 if(($flight->deptime - date('G:i')) <= 1 / 60 * 15) 

 

1) $flight->deptime - date('G:i'))

This will round to a whole hour. If it's 8:50 - 8:45, it will return 0 (8-. If it's 09:00-8:55, it will return 1(9-. This does not return 00:05.

 

2) 1 / 60 * 15

This is the same as .25

 

Because the first part will round to an hour, it will only pass this test if the first part < .25

Because it will be a whole number, it will need to be 0 or a negative value to pass this test.

 

-Kalivos

[maverickalex]

Could you give an example so i can get my head around it? Thanks for taking the time.

[maverickalex]

so what the code should be should be

 

if(($flight->deptime - date('G:i')) <=0.25)

 

is that correct?

[maverickalex]

Does this code appear to be correct in relation to the above advice?

 

if(($flight->deptime - date('G:i')) <= 0.25)   
                {   
                echo 'Final Call';   
                }   
                  
                if(($flight->deptime - date('G:i')) >= 0.25 && $flight->deptime - date('G:i') <=1)   
                {   
                echo 'Proceed to Gate';   
                }   

               if(($flight->deptime - date('G:i')) >= 1)  
                {   
                echo 'Scheduled to Depart On time';   
                }