I am looking for bids for a Pilots electronic logbook on the iPhone, the app must be able to sync with an Sqlite database on a Mac and preferably a PC. I currently have a version on Windows Mobile which can be used to get an idea of the requirement.
There needs to be a home page on the app where users can select whether to add flights duties or flight allowances as well as a tools page to edit user data.
The main page of the logbook is where the user can add flights, there should also be a facility to automatically retrieve defaults from the db like the aircraft type, the airport they usually fly from, their name, their operating capacity, i can provide exact criteria.
On the WM versions along with the Mac and PC there is a function to allow automatic day and night flight time calculation, i have the code for this in vb.net and also realbasic to assist, so the algorithm is correct this would just need to be converted.
Flight allowances should automatically be calculated either based upon duty or flights, once again i have the logic and code in vb.net.
There should also be a duty entry page simply calculating duty times and adding to the db, the adding of duties should also check for duplicate entries prior to adding a duty and informing the user if one exists.
A search flight page should also be available to see the stored flights along with search criteria i.e. searching flights by date, by pilot, by airport etc. This page should also allow to for editing of flights, in the past i have redirected to the add flight page above with the data to be edited.
A totals page is also required where totals for each aircraft type and each capacity are provided, operating capacities allow the user to track whether they are pilot in command, copilot, a trainee an instructor, the pc versions allow the user to define custom capacities.
A tools area is required where pilots can edit any user data i.e. pilots name, add airports, edit allowances, edit aircraft tpyes, aircraft registrations or duty times.
A general settings area is required where the user can edit any defaults i.e their home airport or the automatic allowance choice.
This app needs to be able to sync with the users mac which is also using an sqlite database, edits, deleted entries and new entries will need to be handled. The Mac version is written in realbasic if this helps.
I would like the app to sync with my windows application which is written in VB.net and uses an Access db which i am considering changing to sqlite but not definite
Once complete, i would like to be able to maintain and add to the code for future releases.
If i have been too vague, then please email me.