--- a/labs/myway_timeliness_calculate.php +++ b/labs/myway_timeliness_calculate.php @@ -1,6 +1,8 @@ <?php include ('../include/common.inc.php'); include_header("MyWay Delta Calculate", "mywayDeltaCalc"); +flush(); +ob_flush(); function abssort($a, $b) { if ($a['timeDiff'] == $b['timeDiff']) { @@ -40,8 +42,10 @@ echo "error, route '{$obsv['myway_route']}' unknown"; continue; } - // :convert timestamp into time of day and date + // convert timestamp into time of day and date +// timezones from http://www.postgresql.org/docs/8.0/static/datetime-keywords.html $time = date("H:i:s", strtotime($obsv['time'])); + $time_tz = date("H:i:s", strtotime($obsv['time']))." AESST"; $search_time = date("H:i:s", strtotime($obsv['time'])-(30*60)); // 30 minutes margin $date = date("c", strtotime($obsv['time'])); $timing_period = service_period(strtotime($date)); @@ -87,7 +91,8 @@ //work out time delta, put into array with index of delta $timeDeltas[] = Array( "timeDiff" => $timeDiff, - "stop_code" => $potentialStop['stop_code'] + "stop_code" => $potentialStop['stop_code'], + "stop_sequence" => $timedTrip['stop_sequence'] ); echo "Found trip {$trip['trip_id']} at stop {$potentialStop['stop_code']} (#{$potentialStop['stop_id']}, sequence #{$trip['stop_sequence']})<br>"; echo "Arriving at {$timedTrip['arrival_time']}, difference of " . round($timeDiff / 60, 2) . " minutes<br>"; @@ -101,6 +106,8 @@ //print out that stops/does not stop echo "No matching routes found at {$potentialStop['stop_code']}<br>"; var_dump($stopRoutes); + flush(); + } } // lowest delta is recorded delta @@ -110,24 +117,25 @@ echo "Lowest difference of " . round($lowestDelta / 60, 2) . " minutes will be recorded for this observation<br>"; $observation_id = $obsv['observation_id']; $route_full_name = $obsv['route_full_name']; - $myway_route = $obsv['myway_stop']; $stop_code = $timeDeltas[0]["stop_code"]; - $stmt = $conn->prepare("insert into myway_timingdeltas (observation_id, route_full_name, myway_route, stop_code, timing_delta, time, date, timing_period) - values (:observation_id, :route_full_name, :myway_route, :stop_code, :timing_delta, :time, :date, :timing_period)"); + $stop_sequence = $timeDeltas[0]["stop_sequence"]; + $stmt = $conn->prepare("insert into myway_timingdeltas (observation_id, route_full_name, stop_code, timing_delta, time, date, timing_period, stop_sequence) + values (:observation_id, :route_full_name, :stop_code, :timing_delta, :time, :date, :timing_period, :stop_sequence)"); $stmt->bindParam(':observation_id', $observation_id); $stmt->bindParam(':route_full_name', $route_full_name); - $stmt->bindParam(':myway_route', $myway_route); $stmt->bindParam(':stop_code', $stop_code); $stmt->bindParam(':timing_delta', $lowestDelta); - $stmt->bindParam(':time', $time); + $stmt->bindParam(':time', $time_tz); $stmt->bindParam(':date', $date); $stmt->bindParam(':timing_period', $timing_period); + $stmt->bindParam(':stop_sequence', $stop_sequence); // insert a record $stmt->execute(); if ($stmt->rowCount() > 0) { echo "Recorded.<br>"; } var_dump($conn->errorInfo()); + flush(); } flush(); }