dhtmlx甘特图使用jquery动态加载数据

Question

试图让dhtmlx甘特图在加载页面时加载json数据。

$colors = array(1=>"red", 2=>"green", 3=>"blue", 4=>"yellow", 5=>"orange", 6=>"grey");
$aryData = array();
if($project_tasks) {
    foreach($project_tasks as $aryTask) {
        $aryData[] =  array(
          "id" => $aryTask["pt_id"],
          "text" => $aryTask["pt_name"],
          "start_date" => date("d-m-Y", strtotime($aryTask["pt_start_date"])),
          "duration" => round((strtotime($aryTask["pt_end_date"]) - strtotime($aryTask["pt_start_date"]))/(60*60)),
          "open" => true,
          "color" => $colors[rand(1,6)]
        );
    }
}

$strData = json_encode($aryData, JSON_UNESCAPED_SLASHES);
header("Content-type:application/json;");
echo "\"data\" : ".$strData;

提供如下内容（从chrome控制台）：

"data" : [{"id":"152","text":"test3","start_date":"01-09-2015","duration":600,"open":true,"color":"yellow"},{"id":"153","text":"test1","start_date":"23-09-2015","duration":72,"open":true,"color":"grey"},{"id":"154","text":"test2","start_date":"15-09-2015","duration":264,"open":true,"color":"red"}]

var data_url = basePath + "system/data_file.php?project_id=" + projectID;
$(".gantt").dhx_gantt({
scale_unit:"week",
step:1,
date_scale:"%W"
});
// var tasks = $(".gantt").dhx_gantt().load(data_url);
$(".gantt").dhx_gantt().load(data_url);
gantt.parse(tasks);

我尝试“提醒（任务）；”结果为“未定义”或null。

我尝试过同步ajax加载数据：

var tasks = null;

$.ajax({
    url: data_url,
    async: false,
    dataType: 'json',
    success: function(data) {
        tasks = data;
    }
});

结果是一样的

所以我明白了为什么甘特图不会加载数据-tasks变量中没有数据。

有人举过一个例子吗？

亲切的问候

拉斯

Answer 1

Soo...我玩了一下代码...

这就是我到目前为止的想法。似乎JSON必须以特定的方式出现。。

JS：

/* Gantt Start */

        var data_url = basePath + "system/print_gantt_project_data.php?project_id=" + projectID;

        gantt.config.readonly = true;
        gantt.config.scale_unit = "month"; 
        gantt.config.step = 1;
        gantt.config.date_scale = "%M";

        gantt.init("gantt_div");
        gantt.load(data_url, "json");
        gantt.render();
/* Gantt End */

到目前为止，这种方法唯一的问题是dhtmlx\U甘特图最初并没有呈现任务。似乎需要一种更新。（我尝试了API中可用的功能(http://docs.dhtmlx.com/gantt/api__gantt_render.html)

还在努力修复那个...

哦，还有创建json数据的PHP文件：

/开始/

/* Create JSON array and print it for /js/system_project.js */
$colors = array(1=>"red", 2=>"green", 3=>"blue", 4=>"yellow", 5=>"orange", 6=>"grey");
$aryData = array();
if($project_tasks) {
    foreach($project_tasks as $aryTask) {
        $aryData[] =  array(
          "id" => $aryTask["pt_id"],
          "text" => $aryTask["pt_name"],
          "start_date" => date("d-m-Y", strtotime($aryTask["pt_start_date"])),
          "duration" => round((strtotime($aryTask["pt_end_date"]) - strtotime($aryTask["pt_start_date"]))/(60*60)),
          "open" => "true",
          "color" => $colors[rand(1,6)],
          "parent" => $aryTask["pt_parent"]
        );
    }
}

$strData = json_encode($aryData, JSON_UNESCAPED_SLASHES);
header("Content-type:application/json;");
echo "{\"data\":".$strData."}";

任何关于正确工作的知识，请不要犹豫，进入；-）

/Lars