52 lines
6.2 KiB
HTML
52 lines
6.2 KiB
HTML
|
|
<!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>
|
|
<script src="../../codebase/connector.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">mysql_connect</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>
|