mobilitylab / transitscreen Goto Github PK

View Code? Open in Web Editor NEW

131.0 131.0 21.0 2.96 MB

Transit screen configuration and display.

Home Page: http://mobilitylab.org/2012/01/05/experimental-real-time-transit-screens-come-to-arlington-and-dc/

License: MIT License

PHP 92.39% JavaScript 7.49% Perl 0.12%

transitscreen's People

Contributors

Stargazers

Watchers

transitscreen's Issues

Update DB schema

This bug was originally filed by @joalpeca1:

To start working this software with php and mysql you need do these changes:

In user_model.php in the function validate. You are calling $user->username = $row->username; but username doesn’t exits in the database I changed it for $user->username = $row->email; and start to working.

Plus you need add some columns in the tables that don’t exist in the database:

Table: "agency_stop" you need add a column "exclusions” because is call in a select inside the system if you don’t add this it will fail.

I wasn’t sure about the type so I just declare as "exclusions varchar(100)"
No sure is the correct type but so far it works.

Table: "blocks" you need add a column "limits" because is call in a select inside the system if you don’t add this it will fail.

I wasn’t sure about the type either here so I just declare as "limits int"
No sure is the correct type but so far it works.

You need this modification in your php.

Add list of Metrorail station names and codes to the admin interface

There are only a limited set of Metrorail station names and codes. The admin interface could have that list handy so that someone setting up a screen does not need to make an API request for the list.

Anonymize screen IDs for privacy

Currently screen IDs are generated sequentially which is fine for public screens.

For personal screens, we should give them a short hash-tag based on the user ID.

Support other transit agencies using NextBus

These include: PG The Bus, University of Maryland, GMU, Fairfax CUE, etc.

A few of these need to be supported with changes in TransitScreen code.

Others need to be asked to provide open API through NextBus.

See the list of local agencies here: https://github.com/MobilityLab/TransitScreen/wiki/Local-Transit-APIs

Host admin interface

What site will be used for hosting the admin interface?

I just grabbed TransitScreen.com (and TransitScreens.com) so unless we have other plans, we should use those. I can transfer them to Mobility Lab, or can redirect as required.

Research other user models

Research and consider switching to another user model with functionality matching the project needs.

Connexionz (ART) API throws various warnings when no predictions are available

Probably because nothing is in the array. This is probably not critical? Example:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: out

Filename: helpers/transit_functions_helper.php

Line Number: 409

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: helpers/transit_functions_helper.php

Line Number: 409

A PHP Error was encountered

Severity: Warning

Message: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag

Filename: helpers/transit_functions_helper.php

Line Number: 415

Devise a more granular implementation of sleep hours

The current model uses the same sleep and wake hours for Mondays - Thursdays, Fridays, Saturdays, and Sundays. Ideally, each day of the week should be customizable and there should be better handling of the fact that some screens may need to go to sleep early in the morning rather than before midnight.

Don't show "No Passenger" trains on Metro

Currently line = "NO".

Increase position maximum value to 9

Separate the agency-stop id pairs into a separate table.

Handle intrusion with redirection

Unauthorized visitors to the admin area need to be redirected to the login screen with a message.

Support transit agencies using GTFS-realtime (GTFS-RT) via SIRI 2.0

According to our agencies table, both Ride-On and VRE offer GTFS realtime arrival information.

GTFS-RT is growing in popularity. We should support both of these agencies and any others using it.

3rd column does not work

Currently if you try to add a 3rd column, the screen displays only 1 column.

iframe attribute bug

And one additional thing in the application/views/screen_wrapper.php

They create an iframe with jquery but the problem they add the attribute class which is not allow for iframe.

My solution for achieve the same result they want to do was the follow:

Old code:

        $('<iframe />', {
          id:     'frame-' + versionval,
          class:  frameclass,
          src:    '<?php print $callurl; ?>?' + now
        }).appendTo('body');

        frameclass = 'hidden';

My code:

        $('<iframe />', {
          id:     'frame-' + versionval,

          src:    '<?php print $callurl; ?>?' + now
        }).appendTo('body');

        if(frameclass.length>0)
        {
            $('#frame-' + versionval).show(); 
        }
        if (frameclass== 'hidden')
        {
            $('#frame-' + versionval).hide(); 
        }


        frameclass = 'hidden';

when NextBus has no predictions, XML isn't handled properly

This causes the screen to show up empty because of the lack of error-handling.

The XML looks like:

<body copyright="All data copyright DC Circulator 2012."><predictions agencyTitle="DC Circulator" routeTitle="Georgetown - Union Station" routeTag="yellow" stopTitle="K Street NW And 24th Street NW" stopTag="k24th_w" dirTitleBecauseNoPredictions="Westbound">
</predictions><predictions agencyTitle="DC Circulator" routeTitle="Georgetown - Union Station Night" routeTag="gtownpm" stopTitle="K Street NW And 24th Street NW" stopTag="k24th_w" dirTitleBecauseNoPredictions="Westbound">
</predictions></body>

in transit_functions_helper we want something like:

$destination = (string) $busxml->predictions->dirTitleBecauseNoPredictions;

instead of:

$destination = (string) $busxml->predictions->direction[0]->attributes()->title;

Make TransitScreen work on Internet Explorer

Currently TransitScreen doesn't show anything on IE - not even the "loading" message.

At least iframe issue #54 is preventing it from working. There may be other incompatibilities.

Minimum target version is IE8+.

Internet Explorer issue

For see the styles in internet explorer you guys need add the

in the file application/views/include/screen_header.php

when you dont specify what kind of document is ie will not read as one so it will no have render very well in ie.

Add custom block ability

Handle multiple CaBi stations in one block

Add 'MINUTES' to the Metro train arrivals

The label should appear under the number as per the mockup.

Replace simplexml_load_file with safer call

A number of hosting providers disable simplexml_load_file() for security, but TransitScreen uses it extensively in helpers/transit_functions_helper.php. It should be replaced.

Possible solution: http://php.net/manual/en/book.curl.php

Show error message for failed login attempts

Improve password storage security

We should switch from md5 to bcrypt with salt for password storage.

see e.g. http://stackoverflow.com/questions/4795385/how-do-you-use-bcrypt-for-hashing-passwords-in-php

Sleep time assumes server time zone and screen time zone are identical.

I dont know if you guy advice about this but for the sleeping and awake time people need have in consideration the time of the server with the time of the client.

Because i have 3 hours delay with my server and i setup the awake a 6:00 am but it didnt work until 8:00 am so becareful with that

Support mysql database, not just postgresql

TransitScreen's database schema is pretty simple and doesn't require postgresql.

Someone should create a version of the schema for mysql.

Allow setting up screen in one step instead of 2

When adding a new screen, one cannot define the screen properties and list the stops at the same time. Adding blocks requires that the code know the new screen's ID.

Add a user creation form

Support individual screen API keys in user interface, database

For now, each user should bring their own API key

Validate time input

For the screen admin page.

Add alternative refresh code & infrastructure

Log a timestamp whenever a screen checks in

Add support for weather APIs

Weather would be nice to have when determining whether to use bikeshare or transit.

Public weather APIs include:

http://www.wunderground.com/weather/api

http://developer.yahoo.com/weather/

Add bus listing limit for blocks

This can be done in the JS code.

Can't delete just one of a set of paired stops

When removing the second of two paired stops, the second stop doesn't appear to get deleted.

Fix vertical block ordering in the Javascript code

Make transit screens non-crawlable

We probably don't want Googlebot or other robots hitting the transit screens and causing server/API load.

http://googlewebmastercentral.blogspot.com/2007/03/using-robots-meta-tag.html

"Sleep mode" blanks out screen editor interface, not just screen

Firefox admin looks skewed

The edit and view buttons are not on the same line in the admin when viewed in Windows Firefox

Add API for car2go

Car2Go's API is here: https://code.google.com/p/car2go/wiki/index_v2_1

The method we care about is called vehicles. It returns a list including all vehicle lat/longs in either KML or JSON:

http://www.car2go.com/api/v2.1/vehicles

Each screen would have to filter based on distance from its own lat/long location.

I contacted car2go about getting a (API) consumer key on 9/16. As of 10/3 I have heard nothing.

Validate queries for fictitious screen admin requests

Add support for images in addition to custom text

This would allow the addition of the Mobility Lab logo to screens, or a QR code directing passers-by to a webpage about the screens.

Cooler feature: automatically produce a QR code from each screen's web address and display it in the bottom corner. You could then "take the screen with you" and use it in a neighboring location, at your desk in a building, etc.

Save individual screen latitude and longitude coordinates

This is needed for some APIs such as car2go, as well as possibly weather

Add mobile app features to webpage

Borrowing from https://github.com/MobilityLab/TransitNearMe/blob/master/tnm/templates/client/leaflet.html:

in head

<link rel="shortcut icon" href="/favicon.ico" />
<link rel="apple-touch-icon" href="{{ STATIC_URL }}images/CPlogo.png" />

in body

<noscript>
<div id="noscript-padding"></div>
<div id="noscript-warning">Transit Screen requires a JavaScript-enabled browser. <a href="https://www.google.com/support/adsense/bin/answer.py?answer=12654" target="_blank">Not sure how to enable it?</a></div>
</noscript>
<script type="text/javascript">
  if( navigator.userAgent.match(/Mobile/i) &&
      navigator.userAgent.match(/Safari/i)
    ) {
         document.title = "Transit Screen";
      }
</script>

Select all text in login box when first focused

Right now you have to remove the text "email" which is a mild annoyance.

User_ID isn't recorded correctly in Screens

Screens aren't linked with their creators. User_ID is supposed to store this, but doesn't.

Allow Metro lines to be separated by direction

Currently we can't separate Metro lines by direction. It would be nice to have one row display westbound service and another eastbound (for example.) We could use the existing exclusions rule to do this.

Implement a directional user interface layout

The current transit screen UI doesn't lend itself to directional guidance, but it's very natural to want (for example) westbound services on the left, eastbound services on the right.

One design idea is a 3x3 grid where the outer 8 squares are taken up by blocks of directional services, while the center square is for nondirectional services (e.g. Bikeshare, Car2Go).

Westbou  | Northbound 1
nd1      | Northbound 2
Westbou  -------------------
nd2      |NonDir1| Eastbou
         |NonDir2| nd1
 ----------------- Eastbou
    Southbound 1 | nd2
    Southbound 2 |

The major issue with this design is that column widths are not equal (WB and EB are narrow, NB and SB are wide). The current UI handles three different column widths by wrapping text, which should work.

A further question is whether to left or right justify the text in each square.

Add link and instructions to help find bus stops

Add a link to the WMATA API and to the ART GTFS to assist in finding the IDs of bus stops.

mobilitylab / transitscreen Goto Github PK

transitscreen's People

Contributors

Stargazers

Watchers

Forkers

transitscreen's Issues

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

Recommend Projects

Recommend Topics

Recommend Org