Hi there
I need a few ASP pages written that include date selection ranges and various lookups to be run on a private intranet
We have a number of field engineers accross the country. They are routinely required to work out of hours. One week they may be on twighlight cover between Mon-Fri 17:00-20:00 on other weeks they might be the out of ours duty engineer; 20:00-09:00 the following day.
Some weekends they may be on nights and on others days, 09:00-17:00 or 17:00-09:00
I record the various standby catgories in a database table called ME_CFStandBy, this contains the StandbyCode, Descritption, RetainerValue, etc
A table ME_Standby records the EngineerID, StandbyCode, StandbyDate, LastEdit.
I will provide more lookup SQL details on awarding project.
Page 1
Default to view of current date (If time between 0:00 AND 09:00 show yesterday)
For Each Engineering Area AND each record in ME_CFStandby (Catagories) show what engineer is currently assigend for current date. Show BOLD Red note for NULL entries
Allow filter of past and furture dates
Details to show Engineering Area description, Date, Standby description, engineer name, engineer mobile number.
Page 2
Add, Edit, Delete Entries in ME_Standby.
Look up Engineering Area, Lookup Standby type, Lookup Engineer, Add date range to be assigned to standby duty.
Add & Edit Provide calender controls to select date range to be assigned to standby type or allow entry of dates.
For each day, add speparate record, i.e. if date range is 3 days, add 3 records, one for each day in date range.
If record exists for specific date, report to page but allow duplicate as we might want to assign two people. Provide delete existing, abort current addition, or Overide options.
Page 3
Basic management of ME_CFStandby table, Add/Edit/Delete
Will provide more details of table when project awarded.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP to use External UDL file for database connection string.
All tables held in same database.
Require ASP as easy to edit and alter in future as required.
To run in IIS Win 2000 or Win 2003