<?php |
<?php |
|
|
function getRoute($routeID) { |
function getRoute($routeID) { |
/* |
$query = "Select * from routes where route_id = '$routeID' LIMIT 1"; |
def handle_json_GET_routerow(self, params): |
debug($query,"database"); |
schedule = self.server.schedule |
$result = pg_query($conn, $query); |
route = schedule.GetRoute(params.get('route', None)) |
if (!$result) { |
return [transitfeed.Route._FIELD_NAMES, route.GetFieldValuesTuple()] |
databaseError(pg_result_error($result)); |
*/ |
return Array(); |
|
} |
|
return pg_fetch_assoc($result); |
} |
} |
function getRoutes() { |
function getRoutes() { |
/* def handle_json_GET_routes(self, params): |
global $conn; |
"""Return a list of all routes.""" |
$conditions = Array(); |
schedule = self.server.schedule |
if ($timingPointsOnly) $conditions[] = "substr(stop_code,1,2) != 'Wj'"; |
result = [] |
if ($firstLetter != "") $conditions[] = "substr(stop_name,1,1) = '$firstLetter'"; |
for r in schedule.GetRouteList(): |
$query = "Select * from routes"; |
servicep = None |
if (sizeof($conditions) > 0) { |
for t in schedule.GetTripList(): |
if (sizeof($conditions) > 1) { |
if t.route_id == r.route_id: |
$query .= " Where ".implode(" AND ",$conditions)." "; |
servicep = t.service_period |
} |
break |
else { |
result.append( (r.route_id, r.route_short_name, r.route_long_name, servicep.service_id) ) |
$query .= " Where ".$conditions[0]." "; |
result.sort(key = lambda x: x[1:3]) |
} |
return result |
} |
*/ |
$query .= " order by route_short_name;"; |
|
debug($query,"database"); |
|
$result = pg_query($conn, $query); |
|
if (!$result) { |
|
databaseError(pg_result_error($result)); |
|
return Array(); |
|
} |
|
return pg_fetch_all($result); |
} |
} |
|
|
function findRouteByNumber($routeNumber) { |
function findRouteByNumber($routeNumber) { |
/* |
global $conn; |
def handle_json_GET_routesearch(self, params): |
$query = "Select * from routes where route_short_name = '$routeNumber';"; |
"""Return a list of routes with matching short name.""" |
debug($query,"database"); |
schedule = self.server.schedule |
$result = pg_query($conn, $query); |
routeshortname = params.get('routeshortname', None) |
if (!$result) { |
result = [] |
databaseError(pg_result_error($result)); |
for r in schedule.GetRouteList(): |
return Array(); |
if r.route_short_name == routeshortname: |
} |
servicep = None |
return pg_fetch_all($result); |
for t in schedule.GetTripList(): |
|
if t.route_id == r.route_id: |
|
servicep = t.service_period |
|
break |
|
result.append( (r.route_id, r.route_short_name, r.route_long_name, servicep.service_id) ) |
|
result.sort(key = lambda x: x[1:3]) |
|
return result |
|
*/ |
|
} |
} |
|
|
function getRouteNextTrip($routeID) { |
function getRouteNextTrip($routeID) { |
/* |
$query = "select * from routes join trips on trips.route_id = routes.route_id |
def handle_json_GET_routetrips(self, params): |
join stop_times on stop_times.trip_id = trips.trip_id where |
""" Get a trip for a route_id (preferablly the next one) """ |
arrival_time > CURRENT_TIME and routes.route_id = '$routeID' order by |
schedule = self.server.schedule |
arrival_time limit 1"; |
query = params.get('route_id', None).lower() |
debug($query,"database"); |
result = [] |
$result = pg_query($conn, $query); |
for t in schedule.GetTripList(): |
if (!$result) { |
if t.route_id == query: |
databaseError(pg_result_error($result)); |
try: |
return Array(); |
starttime = t.GetStartTime() |
} |
except: |
return pg_fetch_assoc($result); /* |
print "Error for GetStartTime of trip #" + t.trip_id + sys.exc_info()[0] |
} |
else: |
|
cursor = t._schedule._connection.cursor() |
|
cursor.execute( |
|
'SELECT arrival_secs,departure_secs FROM stop_times WHERE ' |
|
'trip_id=? ORDER BY stop_sequence DESC LIMIT 1', (t.trip_id,)) |
|
(arrival_secs, departure_secs) = cursor.fetchone() |
|
if arrival_secs != None: |
|
endtime = arrival_secs |
|
elif departure_secs != None: |
|
endtime = departure_secs |
|
else: |
|
endtime =0 |
|
result.append ( (starttime, t.trip_id, endtime) ) |
|
return sorted(result, key=lambda trip: trip[2]) |
|
*/ |
|
} |
|
|
|
?> |
?> |