Looking to incorporate some jquery.gantt and it requires data in JSON format. The documentation can be found at ()
Here is the jQuery code snippet:
$(".gantt").gantt({
source: basePath + "system/print_gantt_project_data.php?project_id=" + projectID,
navigate: "scroll",
scale: "weeks",
maxScale: "months",
minScale: "days",
itemsPerPage: 10,
onItemClick: function(data) {
alert("Item clicked - show some details");
},
onAddClick: function(dt, rowId) {
alert("Empty space clicked - add an item!");
},
onRender: function() {
console.log("chart rendered");
}
});
Below is the script that generates the JSON data:
$aryOutput = array();
if($project_tasks) {
foreach($project_tasks as $aryTask) {
$aryOutput[] = array(
'name' => $aryTask['pt_name'],
'desc' => $aryTask['pt_name'],
'values' => array(array(
'to' => '/Date('.strtotime($aryTask['pt_end_date']).')/',
'from' => '/Date('.strtotime($aryTask['pt_start_date']).')/',
'desc' => $aryTask['pt_description'],
'label' => $aryTask['pt_description']
))
);
}
}
$strJSON = json_encode($aryOutput);
header('Content-type:application/json;charset=utf-8');
echo $strJSON;
When inspecting the delivered JSON:
[{"name":"test3","desc":"test3","values":[{"to":"\/Date(1442268000)\/","from":"\/Date(1442181600)\/","desc":"test3","label":"test3"}]},{"name":"test1","desc":"test1","values":[{"to":"\/Date(1442268000)\/","from":"\/Date(1442095200)\/","desc":"test1","label":"test1"}]},{"name":"test2","desc":"test2","values":[{"to":"\/Date(1442268000)\/","from":"\/Date(1442268000)\/","desc":"test2","label":"test2"}]}]
This output is from the console.log in Chrome. (according to the code inserted into jquery.fn.gantt.js:
// **Create the chart**
create: function (element) {
// Initialize data with a json object or fetch via an xhr
// request depending on `settings.source`
if (typeof settings.source !== "string") {
element.data = settings.source;
core.init(element);
} else {
$.getJSON(settings.source, function (jsData) {
element.data = jsData;
core.init(element);
})
.fail(function(jqXHR, textStatus, errorThrown) { console.log('getJSON request failed! ' + textStatus); })
}
},
)
"getJSON request failed! parsererror"
The JSON structure appears valid, but the parse error indicates otherwise.
Any ideas?