How to count total sum jquery?

Question

I have table with the price of quantity. I need count total sum if i write quantity in input and select the colors from dropdown and select product with the price. Firstly i need array of quantity and colors price. Second, check number is in table quantity column. Input must be smallest 30. For ex.: if number 299 - quantity is 200, if 4300 - quantity is 3000 and etc. to smaller. There is my table and jquery:

var total = $("#Total").val();
var table = Array();
$("table.quantity tr td:nth-child(1)").each(function (i, v) {
    table[i] = $(this).text();
});

console.log(table);
$('#Quantity').on("input", function () {
    var quantity = this.value;
    var count = 0;

    if (quantity >= 30) {
        $.each(table, function (i, value) {
            if (quantity >= parseInt(value)) {
                count = value;
            };
        });
        console.log(count);
    }
});
$('#select-model').on('change', function(){
    var price = $('option:selected', this).data('price');
    if (total == '') {
        total = 1;
    }
    $("#Total").val(price * total);
});

i think array must be like:

Array 
( 
    [30] => Array 
        ( 
            [1] => 1.4 
            [2] => 1.7
...
            [8] => 
        ) 
    [50] => Array 
        ( 
            [1] => 1.1 
            [2] => 1.3
...
            [8] => 2.4
        ) 
...
    [5000] => Array 
        ( 
            [1] => 0.3 
            [2] => 0.35
...
            [8] => 1
        ) 
)

there is my code: http://jsfiddle.net/Dewilas/cz69vL8u/

total result to be:

for ex.: 6.59 * 5000 * 0.3 (product1 * quantity 5000 * color 1)

Domain · Accepted Answer · 2015-06-19 07:50:58Z

1

I think, you want multiplication and not sum -

See if the following helps you -

You can add a common class selector to all of your inputs and then do the calculation. I have assumed it to be 'myinput'.

$('.myinput').on('change', function () {

        var total = 1;
        var input_val;

        $('.myinput').each(function(){

            if($(this).attr("id") == "select-model"){
                input_val = $('option:selected', this).data('price');
            }
            else{
                input_val =  $(this).val();
            }

            if (input_val == '' || input_val == 0) {
                input_val = 1;
            }

           total = total * input_val;

        });

        $("#Total").val(total);
    });

Note: I have considered the quantity as 1 by default so that value for other inputs can be seen by default in the total box, so you can change that if you want.

JS Fiddle: http://jsfiddle.net/cz69vL8u/22/

answered Jun 19, 2015 at 7:50

Domain

11.8k3 gold badges26 silver badges45 bronze badges

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

1 Comment

Haroldas Over a year ago

thanks but is not correct. you count quantity * color count (for ex.: 30 * color2 = 60) but i need count quantity * color2 value (30 * 1.7). and why i need array with colums value

Collectives™ on Stack Overflow

How to count total sum jquery?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related