[guruParticipant]

Hi Dimitar,
I have checked that already but in that example entire row will disable, but i want to disable only one cell in a row,
is that possible?, please let me know if any possible way for that

thanks,

Regards,
Guruprasad

[guruParticipant]

please explain get the jqwidget employees data and how to grouping the following grid

var employees =
[
{
“EmployeeID”: 1,
“FirstName”: “Nancy”,
“LastName”: “Davolio”,
“ReportsTo”: 2,
“Country”: “USA”,
“Title”: “Sales Representative”,
“HireDate”: “1992-05-01 00:00:00”,
“BirthDate”: “1948-12-08 00:00:00”,
“City”: “Seattle”,
“Address”: “507 – 20th Ave. E.Apt. 2A”
},
{
“EmployeeID”: 2,
“FirstName”: “Andrew”,
“LastName”: “Fuller”,
“ReportsTo”: null,
“Country”: “USA”,
“Title”: “Vice President, Sales”,
“HireDate”: “1992-08-14 00:00:00”,
“BirthDate”: “1952-02-19 00:00:00”,
“City”: “Tacoma”,
“Address”: “908 W. Capital Way”
},
{
“EmployeeID”: 3,
“FirstName”: “Janet”,
“LastName”: “Leverling”,
“ReportsTo”: 2,
“Country”: “USA”,
“Title”: “Sales Representative”,
“HireDate”: “1992-04-01 00:00:00”,
“BirthDate”: “1963-08-30 00:00:00”,
“City”: “Kirkland”,
“Address”: “722 Moss Bay Blvd.”
},
{
“EmployeeID”: 4,
“FirstName”: “Margaret”,
“LastName”: “Peacock”,
“ReportsTo”: 2,
“Country”: “USA”,
“Title”: “Sales Representative”,
“HireDate”: “1993-05-03 00:00:00”,
“BirthDate”: “1937-09-19 00:00:00”,
“City”: “Redmond”,
“Address”: “4110 Old Redmond Rd.”
},
{
“EmployeeID”: 5,
“FirstName”: “Steven”,
“LastName”: “Buchanan”,
“ReportsTo”: 2,
“Country”: “UK”,
“Title”: “Sales Manager”,
“HireDate”: “1993-10-17 00:00:00”,
“BirthDate”: “1955-03-04 00:00:00”,
“City”: “London”,
“Address”: “14 Garrett Hill”
},
{
“EmployeeID”: 6,
“FirstName”: “Michael”,
“LastName”: “Suyama”,
“ReportsTo”: 5,
“Country”: “UK”,
“Title”: “Sales Representative”,
“HireDate”: “1993-10-17 00:00:00”,
“BirthDate”: “1963-07-02 00:00:00”,
“City”: “London”,
“Address”: “Coventry House Miner Rd.”
},
{
“EmployeeID”: 7,
“FirstName”: “Robert”,
“LastName”: “King”,
“ReportsTo”: 5,
“Country”: “UK”,
“Title”: “Sales Representative”,
“HireDate”: “1994-01-02 00:00:00”,
“BirthDate”: “1960-05-29 00:00:00”,
“City”: “London”,
“Address”: “Edgeham Hollow Winchester Way”
},
{
“EmployeeID”: 8,
“FirstName”: “Laura”,
“LastName”: “Callahan”,
“ReportsTo”: 2,
“Country”: “USA”,
“Title”: “Inside Sales Coordinator”,
“HireDate”: “1994-03-05 00:00:00”,
“BirthDate”: “1958-01-09 00:00:00”,
“City”: “Seattle”,
“Address”: “4726 – 11th Ave. N.E.”
},
{
“EmployeeID”: 9,
“FirstName”: “Anne”,
“LastName”: “Dodsworth”,
“ReportsTo”: 5,
“Country”: “UK”,
“Title”: “Sales Representative”,
“HireDate”: “1994-11-15 00:00:00”,
“BirthDate”: “1966-01-27 00:00:00”,
“City”: “London”,
“Address”: “7 Houndstooth Rd.”
}
];

var source =
{
dataType: “json”,
dataFields: [
{ name: ‘EmployeeID’, type: ‘number’ },
{ name: ‘ReportsTo’, type: ‘number’ },
{ name: ‘FirstName’, type: ‘string’ },
{ name: ‘LastName’, type: ‘string’ },
{ name: ‘Country’, type: ‘string’ },
{ name: ‘City’, type: ‘string’ },
{ name: ‘Address’, type: ‘string’ },
{ name: ‘Title’, type: ‘string’ },
{ name: ‘HireDate’, type: ‘date’ },
{ name: ‘BirthDate’, type: ‘date’ }
],
hierarchy:
{
keyDataField: { name: ‘EmployeeID’ },
parentDataField: { name: ‘ReportsTo’ }
},
id: ‘EmployeeID’,
localData: employees
};
var dataAdapter = new $.jqx.dataAdapter(source);
// create Tree Grid
$(“#treeGrid”).jqxTreeGrid(
{
width: 600,
source: dataAdapter,
sortable: true,
ready: function()
{
$(“#treeGrid”).jqxTreeGrid(‘expandRow’, ‘2’);
},
columns: [
{ text: ‘FirstName’, columnGroup: ‘Name’, dataField: ‘FirstName’, width: 150 },
{ text: ‘LastName’, columnGroup: ‘Name’, dataField: ‘LastName’, width: 120 },
{ text: ‘Title’, dataField: ‘Title’, width: 160 },
{ text: ‘Birth Date’, dataField: ‘BirthDate’, cellsFormat: ‘d’, width: 120 },
{ text: ‘Hire Date’, dataField: ‘HireDate’, cellsFormat: ‘d’, width: 120 },
{ text: ‘Address’, dataField: ‘Address’, width: 250 },
{ text: ‘City’, dataField: ‘City’, width: 120 },
{ text: ‘Country’, dataField: ‘Country’ }
],
columnGroups: [
{ text: ‘Name’, name: ‘Name’ }
]
});

[guruParticipant]

hi
You provided the link .

this example adds new row not a child row. i want to add child row against parent row.

can you please change and let me know the source code.

[guruParticipant]

i can use json data ,its hirachy only children it have any problem to add record to child

[guruParticipant]

i can try that one but it will ad parent node only or add new row i can attached my code here

var source =
{
dataType: “json”,
dataFields: [
{name: ‘fpcId’, type: ‘number’},
{name: ‘programId’, type: ‘number’},
{name: “children”, type: “array”},
{name: ‘program’, type: ‘string’},
{name: ‘programid’, type: ‘string’},
{name: ‘Ad Duration’, type: ‘string’},
{name: ‘Caption’, type: ‘string’},
{name: ‘Commercial’, type: ‘string’},
{name: ‘Remarks’, type: ‘string’},
{name: ‘Brk Duration’, type: ‘string’},
{name: ‘Start Time’, type: ‘date’},
{name: ‘End Time’, type: ‘date’},
{name: ‘Ad Start Time’, type: ‘date’},
{name: ‘Ad End Time’, type: ‘date’},
{name: ‘Release Order No’, type: ‘date’},
{name: ‘Ro Start Time’, type: ‘date’},
{name: ‘Bi Line No’, type: ‘date’},
{name: ‘Ro Time’, type: ‘date’},
{name: ‘Spot Pos’, type: ‘date’},
{name: ‘CAT’, type: ‘date’},
{name: ‘Spot Id’, type: ‘date’},
{name: ‘Spot Note’, type: ‘date’},
{name: ‘Amount’, type: ‘date’},
{name: ‘Alias’, type: ‘date’},
{name: ‘Node Key’, type: ‘date’},
{name: ‘Pattern Id’, type: ‘date’},
{name: ‘Bill No’, type: ‘date’},
{name: ‘Fis Year’, type: ‘date’},
{name: ‘Tape Id’, type: ‘date’},
{name: ‘Bill Proce’, type: ‘date’}

],
hierarchy:
{
root: “children”
},
id: ‘fpcId’,
localdata: data,
addRow: function(rowID, rowData, position, parentID, commit) {
// synchronize with the server – send insert command
// call commit with parameter true if the synchronization with the server is successful
// and with parameter false if the synchronization failed.
// you can pass additional argument to the commit callback which represents the new ID if it is generated from a DB.
commit(true);
newRowID = rowID;
}

};

for (var i = 0; i < bucketPrgId.length; i++) {
if (bucketPrgId[i] !== undefined) {
var finalrows = $(“#finalizationGrid”).jqxTreeGrid(‘getRows’);
for (var j = 0; j < finalrows.length; j++) {
var finalPrgId = $(“#finalizationGrid”).jqxTreeGrid(‘getKey’, finalrows[j]);
alert(bucketPrgId[i] + “===” + finalPrgId);
if (bucketPrgId[i] === finalPrgId) {
var rec = finalrows[j].records;
for (var k = 0; k < rec.length; k++) {
var childKey = $(“#finalizationGrid”).jqxTreeGrid(‘getKey’, rec[k]);

// $(“#finalizationGrid”).jqxTreeGrid(‘expandRow’, childKey);
$(“#finalizationGrid”).jqxTreeGrid(‘addRow’, null, {}, ‘first’, childKey);
// $(“#finalizationGrid”).jqxTreeGrid(‘clearSelection’);
// $(“#finalizationGrid”).jqxTreeGrid(‘selectRow’, childKey);
// edit the new row.
// $(“#finalizationGrid”).jqxTreeGrid(‘beginRowEdit’, childKey);
// $(“#finalizationGrid”).jqxTreeGrid(‘endRowEdit’, childKey, false);
//

}

}

}
}
}

in the above code all values are passed correctly but it will not worked

[guruParticipant]

its not working it throws Cannot read property ‘records’ of undefined in the browser please help me

[guruParticipant]

thanks peter

[guruParticipant]

thanks for u r reply peter but i want to add scheduler in my application so, how i can add that,is there any other plugins for that

[Author]

Posts