diff options
Diffstat (limited to 'samples/treegrid')
| -rw-r--r-- | samples/treegrid/01_basic.html | 45 | ||||
| -rw-r--r-- | samples/treegrid/01_basic_connector.php | 11 | ||||
| -rw-r--r-- | samples/treegrid/02_dynamic_loading.html | 43 | ||||
| -rw-r--r-- | samples/treegrid/02_dynamic_loading_connector.php | 12 | ||||
| -rw-r--r-- | samples/treegrid/03_sql_config.html | 42 | ||||
| -rw-r--r-- | samples/treegrid/03_sql_config_connector.php | 11 | ||||
| -rw-r--r-- | samples/treegrid/04_custom_styles.html | 50 | ||||
| -rw-r--r-- | samples/treegrid/04_custom_styles_connector.php | 19 | ||||
| -rw-r--r-- | samples/treegrid/05_live_update.html | 52 | ||||
| -rw-r--r-- | samples/treegrid/06_treegrid_group_connector.html | 48 | ||||
| -rw-r--r-- | samples/treegrid/06_treegrid_group_connector.php | 13 | ||||
| -rw-r--r-- | samples/treegrid/07_treegrid_multitable_connector.html | 69 | ||||
| -rw-r--r-- | samples/treegrid/07_treegrid_multitable_connector.php | 30 | ||||
| -rw-r--r-- | samples/treegrid/index.html | 32 |
14 files changed, 0 insertions, 477 deletions
diff --git a/samples/treegrid/01_basic.html b/samples/treegrid/01_basic.html deleted file mode 100644 index 6b4fd36..0000000 --- a/samples/treegrid/01_basic.html +++ /dev/null @@ -1,45 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.setColSorting("connector,connector") - mygrid.init(); - mygrid.loadXML("01_basic_connector.php"); - var dp = new dataProcessor("01_basic_connector.php"); - dp.init(mygrid); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"tasks"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskId"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskName,duration,complete"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"parentId"</span><span style="color: #007700">); -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div></body> -</html> diff --git a/samples/treegrid/01_basic_connector.php b/samples/treegrid/01_basic_connector.php deleted file mode 100644 index edc582a..0000000 --- a/samples/treegrid/01_basic_connector.php +++ /dev/null @@ -1,11 +0,0 @@ -<?php - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require("../../codebase/treegrid_connector.php"); - $tree = new TreeGridConnector($res, "PDO"); - - $tree->render_table("tasks","taskId","taskName,duration,complete","","parentId"); -?>
\ No newline at end of file diff --git a/samples/treegrid/02_dynamic_loading.html b/samples/treegrid/02_dynamic_loading.html deleted file mode 100644 index a5ef6a0..0000000 --- a/samples/treegrid/02_dynamic_loading.html +++ /dev/null @@ -1,43 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.init(); - mygrid.kidsXmlFile="02_dynamic_loading_connector.php"; - mygrid.loadXML("02_dynamic_loading_connector.php"); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"tasks"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskId"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskName,duration,complete"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"parentId"</span><span style="color: #007700">); -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div></body> -</html> diff --git a/samples/treegrid/02_dynamic_loading_connector.php b/samples/treegrid/02_dynamic_loading_connector.php deleted file mode 100644 index 87065dd..0000000 --- a/samples/treegrid/02_dynamic_loading_connector.php +++ /dev/null @@ -1,12 +0,0 @@ -<?php - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require("../../codebase/treegrid_connector.php"); - $tree = new TreeGridConnector($res, "PDO"); - - $tree->dynamic_loading(true); - $tree->render_table("tasks","taskId","taskName,duration,complete","","parentId"); -?>
\ No newline at end of file diff --git a/samples/treegrid/03_sql_config.html b/samples/treegrid/03_sql_config.html deleted file mode 100644 index 00e6cb5..0000000 --- a/samples/treegrid/03_sql_config.html +++ /dev/null @@ -1,42 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.setColSorting("connector,connector") - mygrid.init(); - mygrid.loadXML("03_sql_config_connector.php"); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT * from tasks WHERE complete>49"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskId"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskName,duration,complete"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"parentId"</span><span style="color: #007700">); -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div></body> -</html> diff --git a/samples/treegrid/03_sql_config_connector.php b/samples/treegrid/03_sql_config_connector.php deleted file mode 100644 index e4944cf..0000000 --- a/samples/treegrid/03_sql_config_connector.php +++ /dev/null @@ -1,11 +0,0 @@ -<?php - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require("../../codebase/treegrid_connector.php"); - $tree = new TreeGridConnector($res, "PDO"); - - $tree->render_sql("SELECT * from tasks WHERE complete>49","taskId","taskName,duration,complete","","parentId"); -?>
\ No newline at end of file diff --git a/samples/treegrid/04_custom_styles.html b/samples/treegrid/04_custom_styles.html deleted file mode 100644 index 45830d4..0000000 --- a/samples/treegrid/04_custom_styles.html +++ /dev/null @@ -1,50 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.setColSorting("connector,connector") - mygrid.init(); - mygrid.loadXML("04_custom_styles_connector.php"); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> -<br /> require_once(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> function </span><span style="color: #0000BB">custom_format</span><span style="color: #007700">(</span><span style="color: #0000BB">$item</span><span style="color: #007700">){ -<br /> </span><span style="color: #0000BB">$item</span><span style="color: #007700">-></span><span style="color: #0000BB">set_row_color</span><span style="color: #007700">(</span><span style="color: #0000BB">$item</span><span style="color: #007700">-></span><span style="color: #0000BB">get_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"complete"</span><span style="color: #007700">)<</span><span style="color: #0000BB">75</span><span style="color: #007700">?</span><span style="color: #DD0000">"#AAFFFF"</span><span style="color: #007700">:</span><span style="color: #DD0000">"#FFAAFF"</span><span style="color: #007700">); -<br /> if (</span><span style="color: #0000BB">$item</span><span style="color: #007700">-></span><span style="color: #0000BB">get_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"duration"</span><span style="color: #007700">)></span><span style="color: #0000BB">10</span><span style="color: #007700">) -<br /> </span><span style="color: #0000BB">$item</span><span style="color: #007700">-></span><span style="color: #0000BB">set_image</span><span style="color: #007700">(</span><span style="color: #DD0000">"true.gif"</span><span style="color: #007700">); -<br /> else -<br /> </span><span style="color: #0000BB">$item</span><span style="color: #007700">-></span><span style="color: #0000BB">set_image</span><span style="color: #007700">(</span><span style="color: #DD0000">"false.gif"</span><span style="color: #007700">); -<br /> } -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">event</span><span style="color: #007700">-></span><span style="color: #0000BB">attach</span><span style="color: #007700">(</span><span style="color: #DD0000">"beforeRender"</span><span style="color: #007700">,</span><span style="color: #0000BB">custom_format</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT * from tasks WHERE complete>49"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskId"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskName,duration,complete"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"parentId"</span><span style="color: #007700">); -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div></body> -</html> diff --git a/samples/treegrid/04_custom_styles_connector.php b/samples/treegrid/04_custom_styles_connector.php deleted file mode 100644 index 44de104..0000000 --- a/samples/treegrid/04_custom_styles_connector.php +++ /dev/null @@ -1,19 +0,0 @@ -<?php - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require_once("../../codebase/treegrid_connector.php"); - $tree = new TreeGridConnector($res, "PDO"); - - function custom_format($item){ - $item->set_row_color($item->get_value("complete")<75?"#AAFFFF":"#FFAAFF"); - if ($item->get_value("duration")>10) - $item->set_image("true.gif"); - else - $item->set_image("false.gif"); - } - $tree->event->attach("beforeRender",custom_format); - $tree->render_sql("SELECT * from tasks WHERE complete>49","taskId","taskName,duration,complete","","parentId"); -?>
\ No newline at end of file diff --git a/samples/treegrid/05_live_update.html b/samples/treegrid/05_live_update.html deleted file mode 100644 index c8550b6..0000000 --- a/samples/treegrid/05_live_update.html +++ /dev/null @@ -1,52 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>Live update mode</title> - - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.setColSorting("connector,connector") - mygrid.init(); - mygrid.loadXML("05_live_update_connector.php"); - - var dp = new dataProcessor("05_live_update_connector.php"); - dp.init(mygrid); - dp.setUpdateMode("off"); - dp.setAutoUpdate(2000); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'', 0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> - -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_live_update</span><span style="color: #007700">(</span><span style="color: #0000BB">"actions_table"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"tasks"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskId"</span><span style="color: #007700">,</span><span style="color: #DD0000">"taskName,duration,complete"</span><span style="color: #007700"></span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700"></span><span style="color: #007700">,</span><span style="color: #DD0000">"parentId"</span><span style="color: #007700">); -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div> - -</body> -</html> diff --git a/samples/treegrid/06_treegrid_group_connector.html b/samples/treegrid/06_treegrid_group_connector.html deleted file mode 100644 index 5b7ec7d..0000000 --- a/samples/treegrid/06_treegrid_group_connector.html +++ /dev/null @@ -1,48 +0,0 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> - <div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.init(); - mygrid.loadXML("06_treegrid_group_connector.php"); - - var dp = new dataProcessor("06_treegrid_group_connector.php"); - dp.init(mygrid); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'', 0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> - -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegridgroup_connector.php"</span><span style="color: #007700">); -<br /> -<br /> </span><span style="color: #0000BB">$treegrid </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridGroupConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"products"</span><span style="color: #007700">,</span><span style="color: #DD0000">"id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"product_name,scales,colour"</span><span style="color: #007700">,</span><span style="color: #DD0000">""<span style="color: #007700">,</span><span style="color: #DD0000">"category"<span style="color: #007700">); -<br /> -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div> - -</body> -</html> diff --git a/samples/treegrid/06_treegrid_group_connector.php b/samples/treegrid/06_treegrid_group_connector.php deleted file mode 100644 index e08e10d..0000000 --- a/samples/treegrid/06_treegrid_group_connector.php +++ /dev/null @@ -1,13 +0,0 @@ -<?php - - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require_once('../../codebase/treegridgroup_connector.php'); - $treegrid = new TreeGridGroupConnector($res, "PDO"); - - $treegrid->render_table("products", "id", "product_name,scales,colour", "", "category"); - -?>
\ No newline at end of file diff --git a/samples/treegrid/07_treegrid_multitable_connector.html b/samples/treegrid/07_treegrid_multitable_connector.html deleted file mode 100644 index 23379e2..0000000 --- a/samples/treegrid/07_treegrid_multitable_connector.html +++ /dev/null @@ -1,69 +0,0 @@ - -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<html> -<head> - <title>For demo purpose only :: &1</title> - - - - -<script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> -</head> -<body> -<div id="gridbox" width="450px" height="550px" style="background-color:white;overflow:hidden"></div> -<script> -if (!window.eXcell_tree) - alert("To check TreeGrid's samples you need to replace files in `dhtmlx` folder with ones from dhtmlx pro suite."); - - mygrid = new dhtmlXGridObject('gridbox'); - mygrid.setImagePath("../dhtmlx/imgs/"); - mygrid.setHeader("Tree, Column A, Column B"); - mygrid.setInitWidths("200,*,*") - mygrid.setColTypes("tree,ed,ed"); - mygrid.init(); - mygrid.kidsXmlFile = "07_treegrid_multitable_connector.php"; - mygrid.loadXML("07_treegrid_multitable_connector.php"); - - var dp = new dataProcessor("07_treegrid_multitable_connector.php"); - dp.init(mygrid); -</script> -<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'', 0); mygrid.showRow(id);"> -<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()"> - -<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php -<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); -<br /> require(</span><span style="color: #DD0000">"../../codebase/treegridmultitable_connector.php"</span><span style="color: #007700">); -<br /> -<br /> </span><span style="color: #0000BB">$treegrid </span><span style="color: #007700">= new </span><span style="color: #0000BB">TreeGridMultitableConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">setMaxLevel</span><span style="color: #007700">(</span><span style="color: #0000BB">3</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$level </span><span style="color: #007700">= </span><span style="color: #0000BB">$tree</span><span style="color: #007700">-></span><span style="color: #0000BB">get_level</span><span style="color: #007700">(); -<br /> -<br /> </span><span style="color: #0000BB">switch </span><span style="color: #007700">(</span><span style="color: #0000BB">$level</span><span style="color: #007700">) { -<br /> </span><span style="color: #0000BB">case 0</span><span style="color: #007700">: -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table(</span><span style="color: #DD0000">"projects"</span><span style="color: #007700">,</span><span style="color: #DD0000">"project_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"project_name, project_dsc"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">break</span><span style="color: #007700">; - -<br /> </span><span style="color: #0000BB">case 1</span><span style="color: #007700">: -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql(</span><span style="color: #DD0000">"SELECT teams.team_id, teams.team_name, project_team.project_id FROM teams INNER JOIN project_team ON teams.team_id=project_team.team_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"team_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"team_name"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"project_id"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">break</span><span style="color: #007700">; - -<br /> </span><span style="color: #0000BB">case 2</span><span style="color: #007700">: -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table(</span><span style="color: #DD0000">"developers"</span><span style="color: #007700">,</span><span style="color: #DD0000">"developer_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"developer_name,developer_email"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"developer_team"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">break</span><span style="color: #007700">; - -<br /> </span><span style="color: #0000BB">case 3</span><span style="color: #007700">: -<br /> </span><span style="color: #0000BB">$treegrid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table(</span><span style="color: #DD0000">"phones"</span><span style="color: #007700">,</span><span style="color: #DD0000">"phone_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"phone,phone_type"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">,</span><span style="color: #DD0000">"phone_developer"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">break</span><span style="color: #007700">; - -<br /> } -<br /></span><span style="color: #0000BB">?></span> -</span> -</code></div> - -</body> -</html> diff --git a/samples/treegrid/07_treegrid_multitable_connector.php b/samples/treegrid/07_treegrid_multitable_connector.php deleted file mode 100644 index 6dd0d9f..0000000 --- a/samples/treegrid/07_treegrid_multitable_connector.php +++ /dev/null @@ -1,30 +0,0 @@ -<?php - - require_once("../config.php"); - require_once('../../codebase/db_pdo.php'); - $res= new PDO($mysql_server,$mysql_user,$mysql_pass); - - - require("../../codebase/treegridmultitable_connector.php"); - - $treegrid = new TreeGridMultitableConnector($res, "PDO"); - - $treegrid->setMaxLevel(3); - $level = $treegrid->get_level(); - - switch ($level) { - case 0: - $treegrid->render_table("projects", "project_id", "project_name, project_dsc", "", ""); - break; - case 1: - $treegrid->render_sql("SELECT teams.team_id, teams.team_name, project_team.project_id FROM teams INNER JOIN project_team ON teams.team_id=project_team.team_id", "team_id", "team_name", "", "project_id"); - break; - case 2: - $treegrid->render_table("developers", "developer_id", "developer_name,developer_email", "", "developer_team"); - break; - case 3: - $treegrid->render_table("phones", "phone_id", "phone,phone_type", "", "phone_developer"); - break; - } - -?>
\ No newline at end of file diff --git a/samples/treegrid/index.html b/samples/treegrid/index.html deleted file mode 100644 index d8f5d8e..0000000 --- a/samples/treegrid/index.html +++ /dev/null @@ -1,32 +0,0 @@ -<html> - <head></head> - <style type="text/css" media="screen"> - *{ - font-family:Tahoma; - } - div,li{ - font-size:10pt; - } - div{ - padding-bottom:20px; - } - li{ - padding-left:50px; - padding-bottom:10px; - } - </style> - <body> - <h2>dhtmlxConnector for PHP :: Samples</h2> - - <div>Samples are based on standard edition, so to have working TreeGrid samples you need to update files in common folder with ones from dhtmlxSuite pro</div> - - <li><a href="01_basic.html">Basic init</a></li> - <li><a href="02_dynamic_loading.html">Dynamic loading</a></li> - <li><a href="03_sql_config.html">SQL config</a></li> - <li><a href="04_custom_styles.html">Custom styles</a></li> - <li><a href="06_treegrid_group_connector.html">Group connector</a></li> - <li><a href="07_treegrid_multitable_connector.html">Multitable connector</a></li> - - </body> -</html> - |