Improve myway timeliness based on new GTFS feed accuracy
[busui.git] / myway / myway_timeliness_route.json.php
blob:a/myway/myway_timeliness_route.json.php -> blob:b/myway/myway_timeliness_route.json.php
--- a/myway/myway_timeliness_route.json.php
+++ b/myway/myway_timeliness_route.json.php
@@ -21,12 +21,12 @@
 header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE');
 ?>
 {
-"label": "<?php echo $_REQUEST['routeid']; ?>",
+"label": "<?php echo $routename; ?>",
 "data": <?php
-$query = "select * from myway_timingdeltas where route_name = :route_name AND abs(timing_delta) < 2*(select stddev(timing_delta) from myway_timingdeltas)  order by stop_sequence;";
+$query = "select * from myway_timingdeltas where route_name = :route_name 
+AND abs(timing_delta) < 2*(select stddev(timing_delta) from myway_timingdeltas)  order by stop_sequence;";
 $query = $conn->prepare($query);
-$_REQUEST['routeid'].=" ";
-$query->bindParam(':route_name', $_REQUEST['routeid'], PDO::PARAM_STR);
+$query->bindParam(':route_name', $routename, PDO::PARAM_STR);
 
 $query->execute();
 if (!$query) {
@@ -36,6 +36,8 @@
 foreach ($query->fetchAll() as $delta) {
     $points[] = "[{$delta['stop_sequence']}, {$delta['timing_delta']}]";
 };
-echo "[" . implode(",", $points) . "]";
+echo "[" . implode(",", $points) . '],';
 ?>
+"points": { "show" : true }
 }
+