Updating a repeating section with data read from a list.

[Michael1954]

Hi

I am building a simple checkout. The user presses a button on a row in the list, I use this data to build/update the repeating section.

Checkout1.png

The picture above is the list, this list can be refreshed by changing location.
Alpha help me do this so there is no problem there.

Checkout2.png

Here I am showing the repeating section. The quantity available was found in the list and written to the repeating section.

var Available = {dialog.Object}.listGetValue('List_Daily','Available');


{dialog.Object}.setValue('Available',Available);

Should the customer decide to change collection location the refreshed list may show different values of "Available"

My question is, how do I iterate through the repeating section and update "Available"?

Checkout3.png

I use code of this style to move from the list to the repeating section.

var ContainerName = 'REPEAT';
var FieldName = 'Bagel';
var FieldValue = {dialog.object}.listGetValue('List_Daily','PK_Id');

var CurrentRow = {dialog.Object}.getRepeatingSectionActiveRow(ContainerName);
CurrentRow = {dialog.object}._repeatingSectionLogicalToPhysicalRow(ContainerName,CurrentRow);

var totalRows = {dialog.Object}._getRepeatingSectionRowCount(ContainerName);
for (var i=0;i<=totalRows;i++) {
var row = {dialog.object}._repeatingSectionLogicalToPhysicalRow(ContainerName,i);
var rowValue = {dialog.Object}.getValue(FieldName + ':' + row);



Michael

[Davidk]

Re: Updating a repeating section with data read from a list.

Michael,

When you change your pick-up location... what happens then? Are you making an Ajax Callback to go and get the Available qty for each product?
Also, do you have the PK_Id in the repeating section that would identity the bagel product?

If so, then once in that callback create an array or named object containing the PK_Id and Qty for that new pick-up location.
Return this data in a dialog namespace variable from the callback... along with the code to execute a Javacsript function.

Create that Javascript function to loop through the repeating section and update each qty.
This function will grab the dialog namespace variable which contains PK_Ids and Qtys

[Michael1954]

Re: Updating a repeating section with data read from a list.

Hi David

I use an Argument in the list control to filter on the location, so yes I think Alpha does a call back for me.
PK_Id is available in the repeating section; that and location defines my sales per product per location.

Question

I guess I need to pass in all PK_Id's and Qty at that location because the server knows nothing about the repeating section?

Server side I only need to call a Javascript function that I have defined in the "Code" area Javascript functions?

Thanks for the help

Michael

[Davidk]

Re: Updating a repeating section with data read from a list.

So when you select a new Location, you perform a List Refresh?

I guess I need to pass in all PK_Id's and Qty at that location because the server knows nothing about the repeating section?

It depends on how you want to do this... and on how many records are being returned.

If you were dealing with potentially thousands of records for a Location... then I'd want to take a quick run through the Repeating Section... grab the PK_Ids I need and then select those PK_Ids for the new Location from the table.

If you're dealing with 10 records, then does it matter? However, when dealing with PK_Ids, you'll be dealing with a few that you can't use... they're not in the Repeating Section. As you loop through the Repeating Section you'd grab the PK_Id from the RS, find that Id in the data you've got from the new Location, and then grab the corresponding Qty.

Server side I only need to call a Javascript function that I have defined in the "Code" area Javascript functions?

Yes. The Server side code that grabs the new Location data would return an array or object of the new Location data, and the call to the Javascript function that you would define in the Javascript functions of the Code area.

[Michael1954]

Re: Updating a repeating section with data read from a list.

Hi David

Thanks realistically there are only going to be 2 or 3 items in the cart. (Repeating section) The theoretical limit will never exceed 100.

I am just trying to come to terms with my primary key; It is going to be ProductId ||| LocationID ||| MealtimeId


Michael

[Davidk]

Re: Updating a repeating section with data read from a list.

If only 2 or 3 items in the cart... then I'd probably grab those IDs... the new Location... the Mealtime... go after the table for those records... and update your RS. I didn't see MealtimeId in your screenshots above... but adding another variable to the mix isn't an issue... as long as you have it available to use in the select when you go grab your new Location records.

[Michael1954]

Re: Updating a repeating section with data read from a list.

Yes David Mealtime is new.


You get most of the original brief working and then .... it would be nice if.

Thanks I will give it a try

Michael