Script needed to do the following:
Database of employees
Empoyees - Employee #, ID #, Name, Payrate, Availability, Declared Tips, Position, Active
Availibility would be by day and time (choice of approx five time frames each day i.e. 10a - 8p, 4p - 8p, 5p - 8p, 5p - 1a, Custom Timeframe)
Page per each day of week with list of employees with checkboxes to add them to that day's schedule. Should be able to do schedule up to 3 weeks in advance.
Form with all employees in list with text fields to add hours for pay period and declared tips for pay period (bi weekly)
Displays each day of week, employees scheduled, and for what time
Admin Report Section:
Prints out table of each employee's information with ID #/Name/Hours Worked/Tips
Calculates how many hours expected x payrate for each employee separated by position.
Sounds a little complicated but only about 4 pages with a few compounded math problems. Main thing is how the database is setup.
Does not need to be "pretty" for it would only be used in house and not viewed by public