We currently have a SQL7 with an asp/html front end database that tracks service orders from open to close. We want to make some improvements to it and get the code ready for copyright submission.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. 1. Design a Technician login area that allows technicians to view thier work order information and adminisrtaration sections to add and delete technicians login rights. 2. For Accounting: redesign accounting entry section to allow for multiple types of billable hours (maybe selectable by pull down menu). Also accomadate reporting area to allow for these types of hours to be reported properly for cost analysis 3. Change our current Custom Query generator to allow editing and sharing of saved reports. 4. On all custom queries let it select which date you are pulling by according to vareying types of dates (opened, closed, etc...) 5. Make a notes system for sub-contractors and techs that are time stamped and viewable/searchable by date. 6. Redo the notes on the workorder edit form/summary pages to allow for better note taking & searching according to who entered and date stamping. 7. Provide a single line totals report for each contractor that includes profit percentages adn various other criteria.
## Deadline information
We are currently using the system and we need these improvements within 3 weeks. I would like bids from anyone in the Near the eastern kentucky area if possible