Looping through the Json data store extjs

Question

I need to looping through the Json data store and gather all the values. Finally, it should show the total amount of all price in alert window. I do not know how to looping through the Json data stoe, and I am interested if there's a quicker or easier way to do this. My idea is:

var myStore = new Ext.data.Store({
    id: 'ID_Store',
    proxy: new Ext.data.HttpProxy({
        url: 'get.php',
        method: 'POST'
    }),
    baseParams: {
        task: "LIST"
    },
    reader: new Ext.data.JsonReader({
        root: 'results',
        totalProperty: 'total',
        id: 'id'
    }, [{
        name: 'IDbook',
        type: 'int',
        mapping: 'id_book'
    }, {
        name: 'price',
        type: 'int',
        mapping: 'price'
    }])
});

var sum = 0;

myStore.load();
myStore.on('load', function () {
    for (var i = 0; i < myStore.getTotalCount(); i++) {
        sum = sum + myStore.price[i];
    }
});

alert("total sum is:", sum);

JSON is:

{success:true}{total:5,results:[{"id_book":"1","price":"10},{"id_book":"2","price":"15"},{"id_book":"3","price":"5"},{"id_book":"4","price":"7"},{"id_book":"5","price":"30"}]}

sha · Accepted Answer · 2012-05-09 21:24:39Z

7

Can't get much simpler then this:

var total = 0;
myStore.each(function(r) {
   total += r.get('price');
})

answered May 9, 2012 at 21:24

sha

17.9k6 gold badges65 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amol Katdare Over a year ago

Was about to post the same answer. +1

Matullaa · Accepted Answer · 2012-09-28 07:00:01Z

1

Think there a mistake in json first tag price is "price":"10 instead of

edited Sep 28, 2012 at 7:00

user647772

answered Sep 27, 2012 at 22:43

Matullaa

112 bronze badges

Collectives™ on Stack Overflow

Looping through the Json data store extjs

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related