or
THE HTML: <div id="treeviewLeft"></div>THE CONTROLLER CODE: // Get Treeview data from database; ABL & nonABL var mySpecSheetData = new SpecSheetData(); mySpecSheetData.GetTreeviewNodes('170', successFunction, failureFunction); function successFunction() { $('#loadingIndicator').remove(); intializeTreeView(); } function failureFunction() { console.log("********** ERROR **********"); } function intializeTreeView() { var specData = new kendo.data.HierarchicalDataSource(); specData = mySpecSheetData.GetTreeviewData(); console.log(JSON.stringify(specData, null, 1)); alert("Get TreeviewNodeData Success!"); var treeView = $("#treeviewLeft").kendoTreeView({ autoBind: false, expanded: true, datasource: specData, dataTextField: 'displayName' }).data("kendoTreeView"); }THE MODEL CODE:function SpecSheetData() { var treeNodes = [];}SpecSheetData.prototype.GetTreeviewNodes = function (repNumber, successFunction, failureFunction) { var that = this; $.ajax({ //Call for data goes here type: 'GET', url: 'SGLibraryDataService.svc/GetTreeviewDataByRepNum', data: { RepNumber: repNumber }, dataType: 'json', async: true, success: function (returnedTreeNodeData) { that.treeNodes = returnedTreeNodeData; successFunction(); }, failure: function (e) { failureFunction(); } });}SpecSheetData.prototype.GetTreeviewData = function (){ return this.treeNodes;}{ "series": [{ "name": "Incident", "data": [21, 16, 41, 6] }, { "name": "Change", "data": [7, 6, 2, 0] }], "categories": ["/Date(1367391600000-0700)/", "/Date(1370070000000-0700)/", "/Date(1372662000000-0700)/", "/Date(1375340400000-0700)/"], "trendCategories": [], "KendoChartType": "line", "LineWidth": 3, "TooltipDateFormat": "MMM yyyy", "categoryAxis_Type": "date"}series: result.series,categoryAxis: { categories: result.categories, majorGridLines: { visible: false }, type: "date"} <div id="example" class="k-content"> <div id="grid"></div><divclass="console"></div> <script> $(document).ready(function (options) { var company= '<?php echo $_GET["workingcompany"]; ?>'; var crudServiceBaseUrl = "../../data", dataSource = new kendo.data.DataSource({ transport: { read: { url: "http://www.northpier.org/data/fetchcap.php?company="+company, dataType: "json" },update: { url: "http://www.northpier.org/data/Updatecap.php?company="+company, type: "PUT", dataType: "jsonp" }, destroy: { url: crudServiceBaseUrl + "/destroy.php", dataType: "json" }, create: { url: crudServiceBaseUrl + "/create.php", dataType: "json" }, parameterMap: function(options, operation) { if (operation !== "read" && options.models) { return {models: kendo.stringify(options.models)}; } } }, batch: true, pageSize: 30, schema: { model: { id: "id", fields: { id: { type: "string", editable: false }, date_time: { type: "string"}, Name: { type: "string", editable: true }, Common: { type: "number", validation: { required: true, min: 0} }, SeriesA: { type: "number", validation: { required: true, min: 0} }, SeriesB: { type: "number", validation: { required: true, min: 0} }, SeriesC: { type: "number", validation: { required: true, min: 0} }, } } } }); $("#grid").kendoGrid({ dataSource: dataSource,filterable:true,groupable:true, navigatable: true, pageable: true, height: 400, toolbar: ["create", "save", "update", "cancel"], columns: [{ field: "Name", title: "Name", editable: true, }, { field: "Common", title: "Common", }, { field: "SeriesA", title: "Series A", }, { field: "SeriesB", title: "Series B", }, { field: "SeriesC", title: "Series C", }], columnMenu:{ messages:{ columns:"Choose columns", filter:"Apply filter", sortAscending:"Sort (asc)", sortDescending:"Sort (desc)" } }, editable: true, change: function() { console.log("change event"); }, edit: function() { console.log("edit event"); }, save: function() { console.log("save event"); }, saveChanges: function() { console.log("saveChanges event"); $('#grid').data().kendoGrid.refresh(); }, remove: function() { console.log("remove event"); } }); }); </script> </div><?php$dbhost = 'localhost:3036';$dbuser = 'XXXXXXXXXXXXX';$dbpass = 'XXXXXXXXXXXXXXX';$conn = mysql_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die('Could not connect: ' . mysql_error());}parse_str(file_get_contents("php://input"),$post_vars);$comp = $_GET['company'];$mod = $_GET['models'];$request = json_decode($mod);foreach ($request as $product) {$sql = "UPDATE captable SET Name='$product->Name', Common='$product->Common', SeriesA='$product->SeriesA', SeriesB='$product->SeriesB', SeriesC='$product->SeriesC' WHERE id='$product->id'";mysql_select_db('XXXXXXXXXXX');$retval = mysql_query( $sql, $conn );if(!$retval ){ echo "OUCH!"; //die('Could not update data: ' . mysql_error());}else{ $result3 = null;echo $result3;}}mysql_close($conn);?>Country Project Product DatePhilippines Project1 Product A 1-May-13Philippines Project1 Product B 1-May-13Philippines Project1 Product C 1-May-13Japan Project2 Product D 3-Jun-13Japan Project2 Product E 3-Jun-13