Greetings, I am looking for some code to help with scheduling in my job. I would like to have a code that will read in a database of employees and their availability to work certain days. The code will read through the availability and place each employee on the days they can work. The boss will then be able to select one or more employees to work each shift. Once the selection is complete the program will then produce a schedule of the employees, their shifts, and the amount of hours they are working each week.
The shifts are split between day and night shift and require three employees for each shift. Ideally no employee can work more than 50 hours a week and no less than thirty, but it may happen due to scheduling constraints. I would like this code to be written in a java language and the database used will be Mysql. I do not need the database to be created, just the java code.