Build a PHP Calendar from MSSQL Data

Attachments include full details of the project and sample source data. You must review the attachments and confirm your understanding when you submit your bid. 1. Create a PHP based calendar that includes filters for date range, resource name, department, and availability. The availability filter will limit the view to only resources with more than 0 hours of availability. The calendar will include the total assignments (booked), and remaining capacity (available) in each day for each associate. The calendar will also include a week-to-date summary for each resource. A mock calendar example is shown and should be used as the basis of the design. When booked hours are less than 75% of capacity hours, the cell should be highlighted as yellow. When booked hours are between 75% and 100% of capacity hours, the cell should be highlighted as green. When booked hours are more than 100% of capacity hours, the cell should be highlighted as red. When clicking the resource name for a week, a popup (modal or separate window) will display a summary of assignments for that resource for that week. An example is provided. 2. The data for the calendar will be provided by MSSQL. Sample data is provided. 3. Database credentials will be configurable. 4. All source code will be delivered with the final product before payment is released. 5. Payment will not be released for partial work. Payment will only be released for the final deliverable.