Databases
StackOverflow2013
Postsdbo
POJQuery GanttChart - Apply Data
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJQuery GanttChart - Apply Data
    text
    copied!<p>I tried to use the gantview jquery plugin (<a href="https://github.com/thegrubbsian/jquery.ganttView" rel="nofollow">https://github.com/thegrubbsian/jquery.ganttView</a>)</p> <p>So the needed data is like:</p> <pre><code> { id: 1, name: "Feature 1", series: [ { name: "Planned", start: new Date(2010,00,01), end: new Date(2010,00,03) }, { name: "Actual", start: new Date(2010,00,02), end: new Date(2010,00,05), color: "#f0f0f0" } ] }, { id: 2, name: "Feature 2", series: [ { name: "Planned", start: new Date(2010,00,05), end: new Date(2010,00,20) }, { name: "Actual", start: new Date(2010,00,06), end: new Date(2010,00,17), color: "#f0f0f0" }, { name: "Projected", start: new Date(2010,00,06), end: new Date(2010,00,17), color: "#e0e0e0" } ] }, { id: 3, name: "Feature 3", series: [ { name: "Planned", start: new Date(2010,00,11), end: new Date(2010,01,03) }, { name: "Actual", start: new Date(2010,00,15), end: new Date(2010,01,03), color: "#f0f0f0" } ] }, { id: 4, name: "Feature 4", series: [ { name: "Planned", start: new Date(2010,01,01), end: new Date(2010,01,03) }, { name: "Actual", start: new Date(2010,01,01), end: new Date(2010,01,05), color: "#f0f0f0" } ] } </code></pre> <p>Ok I think its JSON :-) So I built it in php, my funcs output is:</p> <pre><code>SERIES DATA Array ( [name] =&gt; Krank [start] =&gt; 1317420000 [end] =&gt; 1320102000 ) DATA Array ( [id] =&gt; 1 [name] =&gt; 15 [series] =&gt; Array ( [name] =&gt; Krank [start] =&gt; 1317420000 [end] =&gt; 1320102000 ) ) JSON {"id":1,"name":15,"series":{"name":"Krank","start":1317420000,"end":1320102000}} </code></pre> <p>Of course I submit only the json part to the plugin ;)</p> <p>I built an array and encode it to json.</p> <p>So with this data the plugin doesn't work. I have no idea how to rebuild this data with php. </p> <p>some hints? ;)</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload