I want to make a basic workflow manager to manage the production of report in accordance with deadlines.
In summary , I have two tables stored in MySql
Table 1: Report
Report Name
DeadlineGroup
Table 2 : Timeline
DeadlineGroup
Monthofthereport
Deadline
example
table 1
Analysis report 1
Inspection report 2
table 2
1 January 02/15/2014
1 February 03/15/2014
2 February 03/20/2014
...
in my simplified example above, the group reports 1 and 2 are required respectively for 15 and 20 the following month, but this is obviously not always the same dates
I do a join between the two tables to get the deadline of each report, but I would like to display the results in html as follows
Code: Select all
january february march ...
Analysis Report 15/02 15/03
inspection report 20/ 03
Thank you for your help