Guriddo » Topic: Post dynamically additional data to the editurl

Post dynamically additional data to the editurl

Guriddo
Post dynamically additional data to the editurl

This topic has 14 replies, 3 voices, and was last updated 17 years, 7 months ago by Shimon.

Creator

Topic
August 12, 2008 at 9:18 am #71967

Shimon
Participant

(Newbee… appologies)

I need a qualifier that is changed by the user for all loads, reloads, edit, add, and delete of the grid. I have set up a var MemNo globally and used sccessfully in load, reload, edit and add: specified as postData:{wmemno:MemNo} in load, reload apears to pick it up dynamically and correctly, beforeSubmit function(row){row.wmemno=MemNo;} on the navGrid edit options (works on add as well without specifying it specifically for add), and tried to do the same for delete and it is not working.

I have tried editData in the navigator options… did not seem to respond, and delData in the delete options… did not respond. I realized that the input to beforeSubmit on edit and add are an object to which I have added my property but for delete it is just the row id and not an object.

I attach the load function and ask: how do I pass the MemNo dynamically to the editurl so that I can qualify the delete sql statement by this number in addition to the row id?

Many Thanks for any help!!
Creator

Topic

Viewing 14 replies - 1 through 14 (of 14 total)

Author

Replies
August 13, 2008 at 5:09 am #83029

tony
Keymaster

Refer to documentation how to use delData.

You should use onclickSubmit event for this – something like

// for delete options

onclickSubmit : function(params}

return {wmemno:MemNo}

}

August 13, 2008 at 6:40 am #83035

Shimon
Participant

Thank you Tony,

I have tried the onclickSubmit before and the value received in wmemno was null, I tried it again now and still the value passed is null. There is a value in MemNo.

August 14, 2008 at 3:14 am #83039

tony
Keymaster

To resolve this make alert for the variable before the return in the event

September 18, 2008 at 8:29 am #83508

Shimon
Participant

I have added the alert to all three (edit, add, delete) onclickSubmit and none shows up. How is it that my event function is not executed?

September 18, 2008 at 10:24 am #83515

tony
Keymaster

Hello,

What values are posted when you use delete?

It is very strange, since the approach is the same as those in edit.

Regards

Tony

September 18, 2008 at 12:55 pm #83520

Shimon
Participant

My grid displays all records of one membership, the table has records of multiple memberships. Each row is one record with an id assigned within the same membership number. The row_id is unique to the grid but not to the table. In the table in order to delete a row I need the membership number plus the row_id. For edit and add the grid is passing all the values of the row in the posted data, for delete it passes only the row_id and the action {oper: “del”}. Therefore, in edit and add I attach an additional property to the row and thus the jsp receives the membership number, in delete attaching a membership number as an additional property does not make it available to the jsp since the row is not passed as posted data. I thought that the delData property of the grid would accomplish this but I tried both static in the construction of the grid and dynamic in the beforeSubmit with no success.

If onclickSubmit is not called, in my case, and then if I use the beforeSubmit to set the delData with {wmemno: MemNo} and it is not posted to the editurl then how can I post the data for delete? I could have added it to the url as Get data but it would be static and once the membership number is changed it would stick to the first one set.

The only other way I can think of is: in the beforeSubmit, call (ajax or similar) the editurl jsp direclty with the row_id and membership number posted to it.

September 18, 2008 at 1:06 pm #83521

tony
Keymaster

Hello,

maybe this will help. (for delete)

onclickSubmit: function(params){

var gsr = $(“#grid_id”).getGridParam('selrow');

var sdata = $(“#grid_id”).getRowData(gsr);

return {wmemno: sdata.MemNo}

}

In my project this work

September 18, 2008 at 1:15 pm #83522

Renso
Participant

Shimon I had a similar issue, however and I am not sure if this solves your problem, if the membership number is embedded in the HTML somewhere can you not just get it via a jQuery selector?

/Membership/Delete?memNo='+$(currentRow '+ input#memNo').val()

meaning currentRow could be set up to look for the current row's key (of course if button on each row other wise if check box with delete button at bottom of page will change selector slightly):

currentRow = $(this).parent().parent (as button in td in tr)

Let me know if this helps.

September 18, 2008 at 2:12 pm #83525

Shimon
Participant

Hi Tony,

The MemNo is a global variable to the page and if my onclickSubmit was invoked then the return {wmemno: MemNo} would have worked. The MemNo is not a field in the row. If I can get onclickSubmit to work I should hope that the returned value is added to the posted data.

Could you give me a hint to look for why my onclickSubmit is not invoked?

Renso: MemNo is a global variable and I have it through the page but it is the ajax invoked url that needs it as an input. However your suggestion made me see that I can add it to the editurl and every time it changes I should setGridParam({editurl: 'myjsp.jsp?wmemno='+MemNo}) and it works

Thank you Tony and Renso. I still think that the onclickSubmit is a nicer looking solution if I can make it to work.

September 18, 2008 at 4:25 pm #83526

Renso
Participant

Shimon, right on! Thanks for gettnig back to us.

September 19, 2008 at 12:56 am #83531

tony
Keymaster

Hello,

Really very strange. To test find delGridRow method, then find

if( typeof p.onclickSubmit === 'function' )

p.delData = p.onclickSubmit(p) || {};

after this make

alert(p.delData.wmemno) ;

After this find

var postd = $.extend({oper:”del”, id:postdata},p.delData);

and then make the same

alert(postd.wmemno)

See the results.

I will try to test this again.

Regards

Tony

September 19, 2008 at 6:18 am #83538

Shimon
Participant

Hi Tony,

I found the method delGridRow in grid.formedit.js but there is no if( typeofp.onclickSubmit === 'function') in it. Yes, there is beforeSubmit and afterSubmit but no onclickSubmit… I guess I should download again. I can't see any version identifier in the file to send you. Should I mail you the file?

I thank you and appreciate your involvement,

Shimon

September 19, 2008 at 7:20 am #83541

tony
Keymaster

Hello,

you should download the latest version for

Download section here (3.2.4)

Regards

Tony

September 19, 2008 at 10:17 am #83545

Shimon
Participant

Thank you Tony, it works and the bonus is the tree grid. I can see now the line with the if (typeof onclickSubmit…
Author

Replies