--- a/myway/myway_timeliness_reconcile.php
+++ b/myway/myway_timeliness_reconcile.php
@@ -17,7 +17,7 @@
include ('../include/common.inc.php');
auth();
foreach ($_REQUEST as $key => $value) {
- if (strstr($key, "route") && !strstr($value, "Select")) {
+ if (strstr($key, "route") && !strstr($value, "Select")) {
$myway_route = str_replace("route", "", $key);
$route_id = $value;
$query = "update myway_routes set route_id = :route_id where myway_route = :myway_route";
@@ -100,6 +100,46 @@
';
echo '
';
}
+echo 'Routes
';
+/* routes
+ remove alpha char, search present dropdown */
+$query = "Select * from myway_routes where route_short_name is NUll;";
+debug($query, "database");
+$query = $conn->prepare($query);
+$query->execute();
+if (!$query) {
+ databaseError($conn->errorInfo());
+ return Array();
+}
+foreach ($query->fetchAll() as $myway_route) {
+ echo "{$myway_route[0]}
";
+ $query = "Select * from myway_observations where myway_route = :route order by time";
+ debug($query, "database");
+ $query = $conn->prepare($query);
+ $query->bindParam(":route", $myway_route[0]);
+ $query->execute();
+ if (!$query) {
+ databaseError($conn->errorInfo());
+ return Array();
+ }
+ foreach ($query->fetchAll() as $myway_obvs) {
+ echo $myway_obvs['myway_stop'] . $myway_obvs['time'] . "
";
+ }
+ $searchRouteNo = preg_replace("/[A-Z]/", "", $myway_route[0]);
+ echo $searchRouteNo;
+ echo '";
+ echo '
';
+}
include_footer();
?>