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);
?>