access:track2013stories
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
access:track2013stories [2013/11/23 00:37] mjallison [Story 1 - Base line] |
access:track2013stories [2014/02/26 23:14] (current) mjallison |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| To support SmartTrack and Trackwork applications, the AGTEK Access server needs to change to accommodate new requirements. The first version of the server, written by external consultants, was a C++/Linux based server which had several issues. The second version of the server, written in Java/Linux, has been in production since 2009. A modified server implementation starting in 2014 is anticipated to support the track applications. | To support SmartTrack and Trackwork applications, the AGTEK Access server needs to change to accommodate new requirements. The first version of the server, written by external consultants, was a C++/Linux based server which had several issues. The second version of the server, written in Java/Linux, has been in production since 2009. A modified server implementation starting in 2014 is anticipated to support the track applications. | ||
| - | ===== Story 0 - Leveling the base ===== | + | ===== Story 1 - Leveling the base ===== |
| We are anticipating that the trackwork will be significantly less than the original Java server implementation (2009) and should be less effort than the license extensions (2011). To prepare for the track extensions, the server needs to be in a relatively clean state. This will prevent any lingering server issues from introducing challenges to the track implementation. | We are anticipating that the trackwork will be significantly less than the original Java server implementation (2009) and should be less effort than the license extensions (2011). To prepare for the track extensions, the server needs to be in a relatively clean state. This will prevent any lingering server issues from introducing challenges to the track implementation. | ||
| Line 28: | Line 28: | ||
| * 4 - Framework for purging licenselog, don't deploy | * 4 - Framework for purging licenselog, don't deploy | ||
| - | ===== Story 1 - Base line ===== | + | ===== Story 2 - Base line ===== |
| Provide the server base to support, at least, the capabilities required in SmartTrack. | Provide the server base to support, at least, the capabilities required in SmartTrack. | ||
| Line 47: | Line 47: | ||
| * API extensions | * API extensions | ||
| * Define constants for machine type | * Define constants for machine type | ||
| - | * SmartTrack Management interface, CRUD directives | + | * Scraper |
| - | * TrackAPI.CreateTrackerDirective( SerialNumber, StoredProject, StoredFile ) | + | * Bulldozer |
| - | * <del>TrackAPI.DeleteTrackerDirective(int directiveId )</del> | + | * Excavator |
| - | * <del>TrackAPI.updateTrackerDirective(TrackerDirective newDirective) - May only be updated if NOT acknowledged</del> | + | |
| - | * List<TrackerDirective> TrackApi.getTrackerDirective(StoredProject) | + | |
| - | * TrackerDirective TrackApi.getTrackerDirective(StoredProject, SerialNumber) | + | |
| - | * TrackApi.acknowledgeTrackerDirective(int directiveNumber) | + | |
| - | * All directives are permanent until project is archived | + | |
| - | * Tracker directives can be superceeded, and will not be usable, only newest one is available. | + | |
| - | * Add new client side data object<code>TrackerDirective | + | |
| - | { | + | |
| - | int handle; | + | |
| - | long time; | + | |
| - | String trackerSerialNumber; | + | |
| - | StoredProject project; | + | |
| - | StoredFile job_file; | + | |
| - | boolean isAcknowledged; | + | |
| - | }</code> | + | |
| - | * Add database table for directive <code>tracker_directives | + | |
| - | +--------------------+------------+------+-----+---------+----------------+ | + | |
| - | | Field | Type | Null | Key | Default | Extra | | + | |
| - | +--------------------+------------+------+-----+---------+----------------+ | + | |
| - | | handle | int(16) | NO | PRI | | auto_increment | | + | |
| - | | time | int(16) | NO | | | | | + | |
| - | | project | int(16) | NO | | | | | + | |
| - | | job_file | int(16) | NO | | | | | + | |
| - | | acknowledged | tinyint(1) | NO | | 0 | | | + | |
| - | +--------------------+------------+------+-----+---------+----------------+ | + | |
| - | </code> | + | |
| * Remove Track fields; ''rejected_dop''. fix support display | * Remove Track fields; ''rejected_dop''. fix support display | ||
| * Add Track field ''statistics | int(16)'' Add support tool display options for stats | * Add Track field ''statistics | int(16)'' Add support tool display options for stats | ||
| Line 88: | Line 62: | ||
| int cycle_count; | int cycle_count; | ||
| boolean is_metric; | boolean is_metric; | ||
| - | double volume; // CY for non-metric, M**3 for metric | + | double amount; // CY for non-metric, M**3 for metric |
| - | double average_speed; // MPH for non-metric, KPH for metric | + | double average_speed; // MPH for non-metric, KPH for metric |
| } </code> Add a new table to the customer database<code>TrackStatistics | } </code> Add a new table to the customer database<code>TrackStatistics | ||
| +--------------------+------------+------+-----+---------+----------------+ | +--------------------+------------+------+-----+---------+----------------+ | ||
| Line 103: | Line 77: | ||
| | cycle_count | int(16) | NO | | | | | | cycle_count | int(16) | NO | | | | | ||
| | is_metric | tinyint(1) | NO | | | | | | is_metric | tinyint(1) | NO | | | | | ||
| - | | volume | float | NO | | | | | + | | amount | float | NO | | | | |
| | average_speed | float | NO | | | | | | average_speed | float | NO | | | | | ||
| +--------------------+------------+------+-----+---------+----------------+</code> | +--------------------+------------+------+-----+---------+----------------+</code> | ||
| Line 121: | Line 95: | ||
| * Add ''TrackAPI.getGPSStats(String serialNumber )'' for a single serial number. Return instance of GPS Stats or null, if not found. | * Add ''TrackAPI.getGPSStats(String serialNumber )'' for a single serial number. Return instance of GPS Stats or null, if not found. | ||
| * Add ''TrackAPI.updateGPSStats( GPSStats statObject )'' application to set stats + latest_version | * Add ''TrackAPI.updateGPSStats( GPSStats statObject )'' application to set stats + latest_version | ||
| - | * ProjectApi | ||
| - | * Add ProjectAPI.archiveProject - packages documents, tracks, directives into a ZIP file and stores it the Project directory. Will only work on an inactive project. | ||
| - | * Add ProjectApi.deleteProject - Deletes all project related DB entries, and files. Only works if project in inactive (or does not exist inside of the project table). | ||
| - | * HaulSim | ||
| - | * Add login dialog to HaulSim | ||
| - | * Modify HaulSim to be able to write GPX files. | ||
| * GPSSim may need some changes. | * GPSSim may need some changes. | ||
| * AccessSupport program | * AccessSupport program | ||
| Line 136: | Line 104: | ||
| * Remove Device oriented methods from SupportAPI and drop protobuf items for those. | * Remove Device oriented methods from SupportAPI and drop protobuf items for those. | ||
| * Delete DeviceDB from storageDB | * Delete DeviceDB from storageDB | ||
| + | * Delete RTK panels | ||
| + | |||
| + | ===== Story 3 - Supervisory level ===== | ||
| + | * HaulSim | ||
| + | * Add login dialog to HaulSim | ||
| + | * Modify HaulSim to be able to write GPX files. | ||
| + | * SmartTrack Management interface, CRUD directives | ||
| + | * See [[android:jobsite:SmartSuiteConfiguration|Smartsuite Configuration]] for directive file information | ||
| + | * TrackAPI.CreateTrackerDirective( SerialNumber, StoredProject, StoredFile ) | ||
| + | * <del>TrackAPI.DeleteTrackerDirective(int directiveId )</del> | ||
| + | * <del>TrackAPI.updateTrackerDirective(TrackerDirective newDirective) - May only be updated if NOT acknowledged</del> | ||
| + | * List<TrackerDirective> TrackApi.getTrackerDirective(StoredProject) | ||
| + | * TrackerDirective TrackApi.getTrackerDirective(StoredProject, SerialNumber) | ||
| + | * TrackApi.acknowledgeTrackerDirective(int directiveNumber) | ||
| + | * All directives are permanent until project is archived | ||
| + | * Tracker directives can be superceeded, and will not be usable, only newest one is available. | ||
| + | * Add new client side data object, configuratuion policy, possibly attached to vehicle table | ||
| + | <code>TrackerDirective | ||
| + | { | ||
| + | int handle; | ||
| + | long time; | ||
| + | String trackerSerialNumber; | ||
| + | StoredProject project; | ||
| + | StoredFile job_file; | ||
| + | boolean isAcknowledged; | ||
| + | }</code> | ||
| + | * (MAYBE) Add database table for directive, could be extension of vehicle table <code>tracker_directives | ||
| + | +--------------------+------------+------+-----+---------+----------------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +--------------------+------------+------+-----+---------+----------------+ | ||
| + | | handle | int(16) | NO | PRI | | auto_increment | | ||
| + | | time | int(16) | NO | | | | | ||
| + | | project | int(16) | NO | | | | | ||
| + | | job_file | int(16) | NO | | | | | ||
| + | | acknowledged | tinyint(1) | NO | | 0 | | | ||
| + | +--------------------+------------+------+-----+---------+----------------+ | ||
| + | </code> | ||
| + | * ProjectApi | ||
| + | * Add ProjectAPI.archiveProject - packages documents, tracks, directives into a ZIP file and stores it the Project directory. Will only work on an inactive project. | ||
| + | * Add ProjectApi.deleteProject - Deletes all project related DB entries, and files. Only works if project in inactive (or does not exist inside of the project table). | ||
| + | |||
access/track2013stories.1385167031.txt.gz · Last modified: 2013/11/23 00:37 by mjallison
Page Tools
