I require a simple mobile application developed for Android which polls a "notifications" table in a MySQL Database. The only other table is a users table for authentication into the application.
The notifications table includes; id, datetime, clientID, severity, description, client, technician, updated, status.
There are 4 interfaces to the application;
1. Login form.
2. Notifications Form; which displays a vertically scrolling list of the most recent entries in the notification table, colour coded based on severity (datetime, description, client, technician, updated). Ordered by date desc and colour coded to denote notification, warning, alert. The Alert messages triggers a pager-type notification to the mobile phone so that the user can attend to this; action (assigns the job to the user + time stamp), ignore (pages again after 7 minutes), resolved (updates the job to that user, time stamps and marks resolved.
3. Online Administrators Form; displays the current users' statistics, who is online, how many jobs attended to and an internal (to the application) messaging function. When a name is selected, it takes them to the 3rd form.
4. Jobs in Progress Form; displays, for the selected user, the current jobs in progress by that user. selecting the job displays an option to mark as Action (which assigns the job to the current user + timestamp), or resolved (updates the job to that current user, time stamps and marks resolved.
Screen mock-ups attached.
I have posted this as a one-time project, but if successful then I have more mobile applications for development also.
Please provide examples of past work which you have done, along with an estimate on time and cost for completion of this project.