MySQL / PHP join 6 tables and display results in a dynamic table for matches

General information for the website: See below
Description of requirements/features: We have 6 tables which are joined:

table 1 is employees
table 2 is jobs
table 3 is requiredDocuments
table 4 is requiredTraining
table 5 is employeeDocuments
table 6 is employeeTraining

employees is joined to job by foreign key linking the employees job to the job table

Jobs is "joined" to requiredDocuments and requiredTraining by values (comma separated list) so for each job we can know what requiredDocuments and requiredTraining there needs to be (can't be a simple MySQL join due to comma list in jobs column?)

requiredDocuments is then joined to employeeDocuments so we can see what actual documents we have for the employee and reference these - likewise for training

At the end I need a list of all employees and then the result for each of their requiredTraining and requiredDocuments in a table with "colours" depending on the output logic (present, not present, expired, valid, passed, failed etc)

This is not a simple as it first looks - see the attached for an example of input data and structures along with the expected output and explanation on why the output is as it is

You will not have any system access and there is no additional code - you will need to be able create these tables yourself, develop locally, test and show it to until it works then send the finalised code to me

Expectation is to receive PHP and MySQL code to produce the output table from an input list of employees
Extra notes: