[linekerParticipant]

Dear Dimitar,

I of course know sql commands for CRUD. But I can not write CRUD operations to commeted area because it is javascript

updaterow: function (rowid, rowdata, commit) {
// synchronize with the server – send update command
// call commit with parameter true if the synchronization with the server was successful
// and with parameter false if the synchronization has failed.
commit(true);
}

I want CRUD operations at a php file, for example crud.php, then how will I redirect to this file?

[linekerParticipant]

Hi Dmitar,

Thank you very much for help.
Now I can get other fields with your method:

As for getting other fields, you can achieve it in the cellendedit event:

$("#jqxGrid").on('cellendedit', function (event) 
{
    var row = args.rowindex;
    var data = $('#jqxGrid').jqxGrid('getrowdata', row);
    var CarID = data.CarID;
});

But I could not use updaterow. I added it to my code but API does not explain how to synchtonise with database. It only writes follwing info:
There are commented areas

updaterow: function (rowid, rowdata, commit) {
// synchronize with the server – send update command
// call commit with parameter true if the synchronization with the server was successful
// and with parameter false if the synchronization has failed.
commit(true);
}

[linekerParticipant]

Hi,

I solved it by using updateBoundData.
When I select value from city filter, it makes Ajax request to server for datatable data and gets new data
But at paging, it still writes old number

For example

All data count is 83
I select a city from city filter, and new data is 26.
I see 26 at datatable but it still writes 83 at paging

[linekerParticipant]

Hi Peter,

You are right, I set autoheight property thinking that that it is for cell height.

[linekerParticipant]

Hi Peter,

I found problem.
I removed following ones and it worked

root: “Products”,
record: “Product”,

[linekerParticipant]

Hi Peter,

I am also sending json demo data.
I can see that it reaches to grid because when I alerted (data.total at beforeprocessing function) number of record I see ‘5’ at popup

{“success”:true,”prd_rec”:[{“B.Branch”:”Ankara”,”R.RecordDate”:”2014-04-22″,”R.RecordID”:”308″},{“B.Branch”:”Ankara”,”R.RecordDate”:”2014-04-22″,”R.RecordID”:”309″},{“B.Branch”:”Ankara”,”R.RecordDate”:”2014-04-22″,”R.RecordID”:”310″},{“B.Branch”:”Ankara”,”R.RecordDate”:”2014-04-22″,”R.RecordID”:”311″},{“B.Branch”:”Ankara”,”R.RecordDate”:”2014-04-22″,”R.RecordID”:”312″}],”total”:5}

[linekerParticipant]

Hi Peter,

Do you mean that position of gif image can be changed but position of loading text can not be changed?

[linekerParticipant]

Hi Peter,

But what is the meaning of below css located at file jqx.base.css?

/*applied to the Grid when its loading the data.*/
.jqx-grid-load
{
padding-right: 0px;
background-image: url(../resources/loader.gif);
background-position: 50% 50%; // center top, 10% 50%, 10 50
background-repeat: no-repeat;
z-index: 9999;
}

[linekerParticipant]

Hi,

Nothing changed although I changed position below css located in file jqx.base.css
When pagesize is big like 50, I am not using scroll bar and I dont see loading image

/*applied to the Grid when its loading the data.*/
.jqx-grid-load
{
padding-right: 0px;
background-image: url(../resources/loader.gif);
background-position: 50% 50%; // center top, 10% 50%, 10 50
background-repeat: no-repeat;
z-index: 9999;
}

[linekerParticipant]

Hi Peter I found solution at virtual mode.
I will calculate Stock+ (stock_plus) and Stock- (stock_minus) from sql and assign as follow:

aggregates: [{ ‘Stock +’:
function (aggregatedValue, currentValue) {
return stock_plus;
}
},
{ ‘Stock -‘:
function (aggregatedValue, currentValue) {
return stock_minus;
}
}
]
},

[linekerParticipant]

Hi Peter,

Can not I assign manıel value?
I will calculate min vakue, max value and assing myself

[linekerParticipant]

Hi Peter,

I am using virtualmode.
I want to assign manual value but it does not work
My aggregate code is below:
I use a counter and assing harccode value, 155 when counter value is 25 but it does not work, why?
If it works I can apply aggregate at virtual mode

var counter = 0;

{ text: RS.Stock, datafield: ‘R.Stock’, width: 50, cellsalign: ‘center’, cellsrenderer: cellsrenderer,
aggregates: [{ ‘S+’:
function (aggregatedValue, currentValue) {
counter += 1;
if (counter == 25) {
return aggregatedValue + 155;
}
return aggregatedValue;
}
},
{ ‘S-‘:
function (aggregatedValue, currentValue) {
if (currentValue == 1) {
return aggregatedValue + 1;
}
return aggregatedValue;
}
}
]
},

[linekerParticipant]

Hi,

I have another problem.
agrregate function finds the number of records from the records displayed at grid
But I am using virtual mode. How can I display number of all records as aggregate value?

[linekerParticipant]

Hi,

I added Status bar and aggregagte row is placed on it, there is no problem now

[linekerParticipant]

Hi Peter,

It is hard to send code because my directory pathes are mixed.
Unfortutanetly there is problem at chrome.
I am using last version of chrome.
I am using 2.8.1 but I tried with 2.8.3, nothing changed.
Although default is true I again set it to true but calendar button is not displayed at chrome

var startDate = spanStartDate.jqxDateTimeInput({ width: ‘120px’,
height: ’25px’,
showCalendarButton: true,
culture: lang,
formatString: “dd/MM/yyyy”
});
container.append(startDate);
container.append(line);
var endDate = spanEndDate.jqxDateTimeInput({ width: ‘120px’,
height: ’25px’,
showCalendarButton: true,
culture: lang,
formatString: “dd/MM/yyyy”
});

[Author]

Posts