<?php include '../../../connector-php/codebase/gantt_connector.php'; // Mysql $dbtype = "MySQL"; $res = mysql_connect("192.168.1.6", "root", "root"); mysql_select_db("gantt"); $gantt = new JSONGanttConnector($res, $dbtype); $gantt->mix("open", 1); //$gantt->enable_order("sortorder"); $gantt->render_links("gantt_links", "id", "source,target,type"); $gantt->render_table("gantt_tasks", "id", "start_date,duration,text,progress,sortorder,parent", "");
<?php include 'config.php'; $gantt = new JSONGanttConnector($res, $dbtype); $parent_id = isset($_GET["parent_id"]) ? $_GET["parent_id"] : 0; $gantt->mix("open", 0); $gantt->mix("deep", 1); function check_children($row) { global $gantt; $task_id = $row->get_value('id'); $sql = "SELECT COUNT(id) AS has_children FROM gantt_tasks WHERE parent='{$task_id}'"; $children = $gantt->sql->query($sql); $child = $gantt->sql->get_next($children); $children_qty = $child['has_children']; $row->set_userdata('$has_child', $children_qty); } $gantt->event->attach("beforeRender", "check_children"); $gantt->filter("parent={$parent_id}"); $gantt->render_links("gantt_links", "id", "source,target,type"); $gantt->render_table("gantt_tasks", "id", "start_date,duration,text,progress,parent", "", "parent");