Forum | Appery.io

hi,
.

.
Above mention is the database table,

in this table i have to change the avl column with the Remaning Units as shown in below screen
.

.
as shown in above screen, i need to update the Avaliable Units with the Remaining Units on clicking Place Order Button, all those avaliable units are coming for database in loop, how tocall service pack for each entry in the database, please help me.

replay please....................

Hi Prudhvi,

If I understand you correctly, available amt = sum of all avl from Database, right?
Ordo you want to obtain a value on record click and save it to "available amt ?" Please check here: http://devcenter.appery.io/documentat...

Hi Katya,

not that,

I'll tell u the flow see,
This is my Opening screen
.

.
All the Goods are comes from Database in loop,
my database as showen below.
.

.
in this When i select the number of Required Units
on the base of Required Units and Avaliable Unit
the Remaining Units are calculated,
as Remaining Units =Avaliable Unit-Required units

as show in below screen
.

.

now i want that on clicking Place Order Button, Avaliable Unit value has to change with Remaining Units in database, why because when i place order the Avaliable Unit have to decrease ..

please help me....................................

Hi Prudhvi,

In case you've described above you need:

1 Add to your project "update items" service.

2 on "success" event of service which is "place the order" you need to run following code:

pre

//Note you should replace "shoppingItemsTable" with your shopping item table name.
var shoppingItems = Apperyio("shoppingItemsTable");

for(var i = 0; i < shoppingItems&#46;length; i++){

 var currentItem = jQuery(shoppingItems[i]); 

 //Note: you should replace "itemIdLabelName" with label name which is inside item and contain item id. 
 var currentItemId = currentItem.find("itemIdLabelName").text(); 
 console.log("currentItemId = " + currentItemId); 

 //Note: you should replace "itemRemaningLabelName" with your label name which is inside item and contain item Remaning Units. 
 var currentItemAvaliableItems = currentItem.find("itemRemaningLabelName").text(); 
 console.log("currentItemAvaliableItems = " + currentItemAvaliableItems); 

 //Note you should replace "yourUpdateService" with your update service datasource name. 
 yourUpdateService.execute({ data: {"_id": currentItemId, "avl": currentItemAvaliableItems} }); 

};

/pre

This code will iterate through your all items sends update request for each item.

Also this code has some "console.log" debug information. Please checkut your console if you will have some problems.

Regards.

Hi Yurii,

its now working
i user this on success event

var shoppingItems = Apperyio("items");
for(var i = 0; i < shoppingItems.length; i++){
var currentItem = jQuery(shoppingItems);
var currentItemId = currentItem.find("id").text();
console.log("id = " + currentItemId);

 var currentItemAvaliableItems = currentItem.find("remUnit").text(); 
 console.log("currentItemAvaliableItems = " + currentItemAvaliableItems); 

 itemUpdateServices.execute({ data: {"_id": currentItemId, "avl": currentItemAvaliableItems} }); 

};

Hi Prudhvi,

Glad to hear that! Let us know if you need any further help.

Sorry Sorry Sorry Sorry Sorry Sorry spell mistake not working ....

Hello!

Are there any errors? Please clarify what exactly doesn't work?

Hi Maryna,

I'll tell u the flow see,
This is my Opening screen
.

.
All the Goods are comes from Database in loop,
my database as shown below.
.

.
in this When i select the number of Required Units
on the base of Required Units and Avaliable Unit
the Remaining Units are calculated,
as Remaining Units =Avaliable Unit-Required units

as show in below screen
.

.

now i want that on clicking Place Order Button, Avaliable Unit value has to change with Remaining Units in database, why because when i place order the Avaliable Unit have to decrease ..

i tried above code on my success event but it does't works,
please help me for this....................................