You have chosen to sponsor your bid up to a maximum amount of .
iPhone application required to login based on username / password combo and authenticate against remote MySQL database. Once logged in, a Tab Page is displayed with 3 tabs (New Ticket, Open Tickets, Search).
New Ticket tab allows a user to submit a new ticket to a database. A new ticket will consist of a textbox for the ticket number, two drop down menus with four options each to be defined at a later date and a timestamp all submitted to a remote database.
The Open Tickets table will poll the database and list all tickets that are not flagged as closed. Touching an Open Ticket from the list takes the user to a new page which shows the details of the ticket, Ticket Number, the two pieces of information from the drop down menus on the New Ticket page, the time the ticket was created, a Stop and Close button.
The stop button will add an entry to the database for that ticket indicating the time the Ticket was stopped. The stop button will then turn into a Start button, allowing the user to re-start the ticket. Each entry of Stop / Start per ticket must be logged in the database.
The Close button stops the ticket and puts a Closed flag in the database. The ticket is now closed and can not be re-started.
The Search tab allows any open or closed tickets to be searched for using a Search box.