I'm looking for the rapid development of an iPhone application that can perform the following task.
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 and belong to the current user that is signed in. Touching an Open Ticket from the list takes the user to a new page, Open Ticket Detail, 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, the amount of time the ticket has been open and 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 and the total amount of time the ticket has been opened displayed on the Open Ticket Detail page.
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 using the Start / Stop button.
The Search tab allows any open or closed tickets to be searched for using a Search box or by click on two buttons labelled, All Open or All Closed.