ASxcel is a small tool for the browser game AirlineSim (www.airlinesim.aero) by simulogics. It helps the player keep track of the routes he offers or plans to offer.
Countries are already implemented in the game, but at this point neither can they be assigned nor do they get displayed. How about adding a little flag to the airports name, or even an additional field so that you can sort by country.
Looking in the database with external tools some irregularities are visible, which should be avoided in the future. Implement tests to validate the correct behavior of database operations.
To minimize the number of displayed airports only airports should be listed that were created by the current enterprise. In the background no real creation should happen but an association should be made between enterprises and airports.
If you create a route that another enterprise already uses the route gets displayed for both enterprises, and no new route is created for the second one. This should get fixed ASAP.
The attribute is already there, what's missing is the option to set a route to scheduled, a filter and the renderer to highlight those rows accordingly. This would be a great improvement regarding usability.
When changing a value from an airport that is listed multiple times, the other entries do not get updated automatically. The new value is shown only after a restart.
It should be possible to delete enterprises, and with them all routes that have been created, and possibly even all airports that are only referenced by this one enterprise.
In the current version no mechanisms exist to handle exceptions, display error messages and possibly recover from them. Most importantly the user has no way to understand why the application crashes and aid in the troubleshooting process by providing information about the nature of the crash.
Provide a way to view and export stacktraces and to possibly handle exceptions in a better way then now.
The user should have the possibility to manually adjust which airport belongs to which enterprise. Of course an airport can belong to multiple enterprises, but no matter what, it should be customizable without manipulating the database.
To provide more overview the routes could be separated by their distance, categorized by short-, medium- and long-haul. For this a tabbed pane could be used, with one tab where all routes are displayed.
Right now the user can input what he wants in the field, only limited by the class of input (String, Integer, Boolean). For some field additional parameter should be checked, like the length of the String for IATA codes or the value of integer for sizes, distance and loads.