--- a/stop.php +++ b/stop.php @@ -1,90 +1,207 @@ <?php -include ('common.inc.php'); -$stopid = filter_var($_REQUEST['stopid'], FILTER_SANITIZE_NUMBER_INT); -$stopcode = filter_var($_REQUEST['stopcode'], FILTER_SANITIZE_STRING); -$url = $APIurl . "/json/stop?stop_id=" . $stopid; -$stop = json_decode(getPage($url)); -if ($stopcode != "" && $stop[5] != $stopcode) { - $url = $APIurl . "/json/stopcodesearch?q=" . $stopcode; - $stopsearch = json_decode(getPage($url)); - $stopid = $stopsearch[0][0]; - $url = $APIurl . "/json/stop?stop_id=" . $stopid; - $stop = json_decode(getPage($url)); -} -if (!startsWith($stop[5], "Wj") && strpos($stop[1],"Platform") === false) { - // expand out to all platforms -} + +/* + * Copyright 2010,2011 Alexander Sadleir + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + */ +include ('include/common.inc.php'); +if (isset($stopid)) { + $stop = getStop($stopid); +} +/* if ($stopcode != "" && $stop[5] != $stopcode) { + $url = $APIurl . "/json/stopcodesearch?q=" . $stopcode; + $stopsearch = json_decode(getPage($url)); + $stopid = $stopsearch[0][0]; + $url = $APIurl . "/json/stop?stop_id=" . $stopid; + $stop = json_decode(getPage($url)); + } + if (!startsWith($stop[5], "Wj") && strpos($stop[1], "Platform") === false) { + // expand out to all platforms + + } */ + $stops = Array(); $stopPositions = Array(); +$stopNames = Array(); $tripStopNumbers = Array(); $allStopsTrips = Array(); +$fetchedTripSequences = Array(); $stopLinks = ""; -if (isset($_REQUEST['stopids'])) { - $stopids = explode(",",filter_var($_REQUEST['stopids'], FILTER_SANITIZE_STRING)); +if (isset($stopids)) { foreach ($stopids as $sub_stopid) { - $url = $APIurl . "/json/stop?stop_id=" . $sub_stopid; - $stop = json_decode(getPage($url)); - $stops[] = $stop; + $stops[] = getStop($sub_stopid); } $stop = $stops[0]; - $stopid = $stops[0][0]; - $stopLinks .= "Individual stop pages: "; + $stopid = $stops[0]["stop_id"]; + $stopLinks.= "Individual stop pages: <br>"; foreach ($stops as $key => $sub_stop) { - $stopLinks .= '<a href="stop.php?stopid='.$sub_stop[0].'&stopcode='.$sub_stop[5].'">'.$sub_stop[1].' Stop #'.($key+1).'</a> '; - $stopPositions[$key] = Array($sub_stop[2],$sub_stop[3]); - $url = $APIurl . "/json/stoptrips?stop=" . $sub_stop[0] . "&time=" . midnight_seconds() . "&service_period=" . service_period(); - $trips = json_decode(getPage($url)); + + $stopNames[$key] = $sub_stop["stop_name"]; + $stopLinks.= '<a href="stop.php?stopid=' . $sub_stop["stop_id"] . '&stopcode=' . $sub_stop["stop_code"] . '">' . $sub_stop["stop_name"] . '</a> '; + + $stopPositions[$key] = Array( + $sub_stop["stop_lat"], + $sub_stop["stop_lon"] + ); + $trips = getStopTrips($sub_stop["stop_id"]); + $tripSequence = ""; foreach ($trips as $trip) { - if (!isset($allStopTrips[$row[1][0]])) $allStopTrips[$row[1][0]] = $trip; - $tripStopNumbers[$row[1][0]][] = $key; + $tripSequence.= "{$trip['trip_id']},"; + $tripStopNumbers[$trip['trip_id']][] = $key; } - } -} - -include_header($stop[1], "stop"); - -if (isMetricsOn()) { - // Create a new Instance of the tracker - $owa = new owa_php(); - // Set the ID of the site being tracked - $owa->setSiteId($owaSiteID); - // Create a new event object - $event = $owa->makeEvent(); - // Set the Event Type, in this case a "video_play" - $event->setEventType('view_stop'); - // Set a property - $event->set('stop_id', $stopid); - // Track the event - $owa->trackEvent($event); -} -timePlaceSettings(); -echo '<div data-role="content" class="ui-content" role="main">'; + if (!in_array($tripSequence, $fetchedTripSequences)) { + // only fetch new trip sequences + $fetchedTripSequences[] = $tripSequence; + $trips = getStopTripsWithTimes($sub_stop["stop_id"]); + foreach ($trips as $trip) { + if (!isset($allStopsTrips[$trip["trip_id"]])) + $allStopsTrips[$trip["trip_id"]] = $trip; + } + } + //else { + // echo "skipped sequence $tripSequence"; + //} + } +} +if (sizeof($stops) > 0) { + $stopDescParts = explode("<br>", $stop['stop_desc']); + include_header(trim(str_replace("Street: ", "", $stopDescParts[0])), "stop"); +} else { + include_header($stop['stop_name'], "stop"); +} +/* $serviceAlerts = json_decode(getPage(curPageURL() . "/servicealerts_api.php?filter_class=stop&filter_id=".$stopid) , true); + + foreach($serviceAlerts['entities'] as $serviceAlert) { + echo '<div id="servicewarning">'.$serviceAlert['alert']['description']['translation'].'</div>'; + } */ + +echo '<div class="content-secondary">'; echo $stopLinks; if (sizeof($stops) > 0) { - echo '<p>' . staticmap($stopPositions) . '</p>'; -} else { - echo '<p>' . staticmap(Array( - 0 => Array( - $stop[2], - $stop[3] - ) -)) . '</p>'; -} + trackEvent("View Stops", "View Combined Stops", $stop["stop_name"], $stop["stop_id"]); + echo staticmap($stopPositions); +} else { + trackEvent("View Stops", "View Single Stop", $stop["stop_name"], $stop["stop_id"]); + echo staticmap(Array( + 0 => Array( + $stop["stop_lat"], + $stop["stop_lon"] + ) + )); +} + +timeSettings(); + +echo '</div><div class="content-primary">'; echo ' <ul data-role="listview" data-inset="true">'; -$url = $APIurl . "/json/stoptrips?stop=" . $stopid . "&time=" . midnight_seconds() . "&service_period=" . service_period(); -$trips = json_decode(getPage($url)); -foreach ($trips as $row) { - echo '<li>'; - echo '<h3><a href="trip.php?stopid=' . $stopid . '&tripid=' . $row[1][0] . '">' . $row[1][1]; - if (isFastDevice()) { - $viaPoints = viaPointNames($row[1][0], $stopid); - if ($viaPoints != "") echo '<br><small>Via: ' . $viaPoints . '</small> </a></h3>'; - } - echo '<p class="ui-li-aside"><strong>' . midnight_seconds_to_time($row[0]) . '</strong></p>'; - echo '</li>'; -} -if (sizeof($trips) == 0) echo "<li> <center>No trips in the near future.</center> </li>"; -echo '</ul></div>'; +if (sizeof($allStopsTrips) > 0) { + sktimesort($allStopsTrips, "arrival_time", true); + $trips = $allStopsTrips; +} else { + $trips = getStopTripsWithTimes($stopid, "", "", "", (isset($filterIncludeRoutes) || isset($filterHasStop) ? "75" : "")); +} + +echo "<div class='ui-header' style='overflow: visible; height: 2.5em'>"; +// if we have too many trips, cut down to size. +if (!isset($filterIncludeRoutes) && !isset($filterHasStop) && sizeof($trips) > 10) { + $trips = array_splice($trips, 0, 10); +} + +// later/earlier button setup +if (sizeof($trips) == 0) { + $time = isset($_REQUEST['time']) ? strtotime($_REQUEST['time']) : time(); + $earlierTime = $time - (90 * 60); + $laterTime = $time + (90 * 60); +} else { + $tripsKeys = array_keys($trips); + $earlierTime = strtotime($trips[$tripsKeys[0]]['arrival_time']) - (90 * 60); + $laterTime = strtotime($trips[$tripsKeys[sizeof($trips) - 1]]['arrival_time']) - 60; +} +if (isset($stopids) && sizeof($stopids) > 0) { + $stopidurl = "stopids=" . implode(",", $stopids); +} else { + $stopidurl = "stopid=$stopid"; +} +if (sizeof($trips) >= 10) { + echo '<a href="stop.php?' . $stopidurl . '&service_period=' . service_period() . '&time=' . date("H:i", $laterTime) . '" data-icon="arrow-r" class="ui-btn-right">Later Trips</a>'; +} +echo '<a href="stop.php?' . $stopidurl . '&service_period=' . service_period() . '&time=' . date("H:i", $earlierTime) . '" data-icon="arrow-l" class="ui-btn-left">Earlier Trips</a>'; +echo "</div>"; +if (sizeof($trips) == 0) { + echo "<li style='text-align: center;'>No trips in the near future.</li>"; +} else { + if (isset($labs)) { +// ETA calculation + + $tripETA = Array(); + // max/min delay instead of stddev? + $query = $query = "select 'lol', avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas where extract(hour from time) between ".date("H", $earlierTime)." and ".date("H", $laterTime); + //select 'lol', stop_id,extract(hour from time), avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas where stop_id = '5501' group by stop_id, extract(hour from time) order by extract(hour from time) + $query = $conn->prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + $ETAparams = Array(); + foreach ($query->fetchAll() as $row) { + $ETAparams[$row[0]] = Array("avg"=> $row[1], "stddev"=>floor($row[2]),"count"=>$row[3]); + }; + //print_r($ETAparams); + foreach ($trips as $trip) { + $tripETA[$trip['trip_id']] = date("H:i",strtotime($trip['arrival_time']." - ".(floor($ETAparams['lol']['stddev']))." seconds"))." to ". + date("H:i",strtotime($trip['arrival_time']." + ".(floor($ETAparams['lol']['stddev']))." seconds")); + } + //print_r($tripETA); +} + foreach ($trips as $trip) { + if ( + isset($filterHasStop) && (getTripHasStop($trip['trip_id'], $filterHasStop) == 1) + || (isset($filterIncludeRoutes) && in_array($trip["route_short_name"], $filterIncludeRoutes)) + || (!isset($filterIncludeRoutes) && !isset($filterHasStop)) + ) { + echo '<li>'; + + $destination = getTripDestination($trip['trip_id']); + echo '<a href="trip.php?stopid=' . $stopid . '&tripid=' . $trip['trip_id'] . '"><h3>' . $trip['route_short_name'] . " towards " . $destination['stop_name'] . "</h3><p>"; + $viaPoints = viaPointNames($trip['trip_id'], $trip['stop_sequence']); +if (isset($labs)) { + echo '<br><span class="eta">ETA: ' . $tripETA[$trip['trip_id']] . '</span>'; + } + if ($viaPoints != "") + echo '<br><span class="viaPoints">Via: ' . $viaPoints . '</span>'; + if (sizeof($tripStopNumbers) > 0) { + echo '<br><small>Boarding At: '; + if (sizeof($tripStopNumbers[$trip['trip_id']]) == sizeof($stopids)) { + echo "All Stops"; + } else { + foreach ($tripStopNumbers[$trip['trip_id']] as $key) { + echo $stopNames[$key] . ', '; + } + } + echo '</small>'; + } + echo '</p>'; + echo '<p class="ui-li-aside"><strong>' . $trip['arrival_time'] . '</strong></p>'; + echo '</a></li>'; + flush(); + @ob_flush(); + } + } +} +echo '</ul>'; +echo '</div>'; include_footer(); ?>