We need 2 applications:
The main one is for managing the checklists of different industrial vehicules.
The second one is very simple, just to manage the users login and passwords. It will work with the first one (and later with others).
Both should work in ASP and with SQL Server 2008 (for the database, you can propose a more simple DB if you prefer but you must explain what are the advantages)
The application should have 4 Types of users (can add some more later)
A - User entry / Operator
B - Finance user (export report "inspection checklist of the month")
C - Office user (full rights)
D - Admin (full rights + config of the program)
The main Functionnalities:
F1 - Create / Edit a checklist (for a vehicule)
F2 - Create / Edit a Vehicule
F3 - Create / Edit a Driver
F4 - List and view details of all existing checklists, able to validate or dismiss them
F5 - List and view details of all existing vehicules, able to inactivate them
F6 - List and view details of all existing drivers, able to inactivate them
F7 - Export a finance report (xls) by month by contract (report to be defined)
F8 - Report by vehicule (search by engine, search by number of vehicule)
Functionnalities for admin:
FA1 - Create users and give them access right (by functionnalities)
FA2 - Create types of Checklists
Print functionnality on reports and major screen will be requested
The checklists pages shoud be optimized to be usable with slow internet connection (close to 56k)
A checklist is made of (see attachment):
- some fields (date, driver, vehicule, and other text fields)
- some checkpoints (group name, name, 4 radio button: o Major fault | o Minor fault | o No fault | o N/A)
- a remarks field at the end
Note that depending on the checkpoint, the "major fault" and "minor fault" can be bold (or shaded or whatever) that has a different meaning (vehicule not allowed to move for example). This is entered by the admin when creating the checklist type.
Source code has to be provided with basic comments.
Serious only. Happy bidding.