--- 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(); ?>