Basically we are wanting a solution that we can used to schedule our employees. The center manager would go online to this website. From there they will see all of their employees which should be automatically pulled from active directory by location. From there they will see the current days of the week, Monday - Sunday. Below that there will be an IN / OUT time for the employee. There will be a weekly total of hours for each employee and a daily total of hours for all employees. The daily total will be compared to our allowed hours based on another query of a database.See the attached sample.
I would like for each week to have the data stored so the manager could go back and look at it and schedule into the future. We can tweak it as needed.
Additional Project Description:
03/27/2013 at 20:50 IST
Pre-meeting stuff. Todd you can look at this and ponder the challenges with getting what we need. We have the the idea, and some design, it is just getting the back pieces to work. Infopath gets us close, but not close enough. Visual Studio is the next option. .ASP, .NET. You may know someone who can do this for a reasonable price, or thoughts.
Here is a screen shot of a mock up of what I think we are looking to do. Whether, or not I can accomplish this myself, or have someone outside create it. Something like this would work I believe.
Location: Default location is selected for manager. If the user is in a certain AD management group for the location like CA016-Management then they would see that in the drop down box. If they are an RD, or see more than one location they would have the open to select another location and input data.
Week of: It would be great to have the weeks information stored in a database. If changes are made then you can easily go back and make a change, or go back and see what actually happened for that week. You could go forward in time a week or two, but amkai data would not be as accurate till it gets closer.
Cases: Shown under the day of the week. Updated automatically from SQL. We may have to create a process, or script to run a query on the AE database to populate / update a new table on changes based on date so we can easily get this information and store it.
Staff Hours: Each employee has hours totalled for the week on the right. All staff hours are totalled for the day at the bottom. Daily hours could be green by default. If it goes over it could turn red.
Ultimately the manager could save this form, or print it out for the week.