Hello.
A year or so ago, I managed to get the background of a row to turn red if the checkbox finished was not ticked after 60 days, or yellow if it was not ticked after 30 days.
if ((strtotime("now")-strtotime($data["Order_Date"]))/(60*60*24)>28 && !$data["Job_Finished"])
$row["rowstyle"]='style="background:#ffff33"';
if ((strtotime("now")-strtotime($data["Order_Date"]))/(60*60*24)>48 && !$data["Job_Finished"])
$row["rowstyle"]='style="background:#ff3300"';
What I am looking to do now, is, I have two tables, job and report. report is a child to job and in the job list, if there is a report for that job, the report displays Report (1)
Now, I have a checkbox called export. I am looking to do this.
The user ticks the export box and saves the job, so in the job -list it displays the date the job was added and a tick in the export box.
If after 5 days, there is no report, I want this row to change color
Can this be done and if so, a nudge in the right direction would be great.
Thanks
Paul.
