The gantt chart from fusioncharts should be installed in the app/views/service_tickets/[login to view URL] page at the top as defined in the instructions below!
Show gantt chart here, should have a width of 900px.<p/>
The gantt chart should look like the one <a href="[login to view URL]">here</a>.<br/>
The column that says "What to do?" should be called "Technician" <br/>
and all of the values under that should be the names of technicians <br/>
who have records returned with the criteria (more on that in a minute!)<p/>
The fields "Q1", "Q2", etc... should not exist, take them out. ? The months "Feb", <br/>
"mar", "Apr", etc, should be replaced with hours of the day, as in "1am", "2am", etc.<p/>
Essentially, I want this Gantt chart to show every record in the table below to give<br/>
the user a visual estimate of what is going on. ? It should show all installs with an 'Open'<br/>
status. ? The field 'Service Type' can have two valus: 'Install' or 'Service' - it should<br/>
show them with different colors to let hte user know if it's an install or service record.
<p/>
Basically, I? want? to load records from the service table in the Gantt chart dynamically. ? Make it happen! ? This is just one chart...