I have:
$('#createStockOrder').click(function () { modal('create-stock-order', {}, function () { var $modal = $(this); var submitted = false; var model = []; $('.glyphicon-plus').click(function () { var product_id = $('#productSelect option:selected').text(), size_id = $('#sizeSelect option:selected').text(), colour_id = $('#colourSelect option:selected').text(), quantity = $('#quantity').val(); // Get index of the element where all the fields matches var index = getObjectIndex(model, product_id, size_id, colour_id); // If object found in the array if (index !== false) { // Update the quantity in the same element model[index].quantity = quantity; } else { // Add the element in the array model.push({ product_id: product_id, size_id: size_id, colour_id: colour_id, quantity: quantity }); } printStock(model); }); var form = document.getElementById('create_sale'); var $form = $(form); $form.on('submit', function (e) { e.preventDefault(); if (!submitted) { submitted = true; $('#create_sale .btn-primary').addClass('disabled'); var formData = new FormData(form); qwest.post(form.action, formData) .then(function (resp) { $modal.modal('hide'); }) .catch(function (xhr, response, e) { var html = ''; $.each(response, function (i, v) { html += '<p>' + v + '</p>'; }); $('#create_sale .alert').html(html).removeClass('hide'); $('#create_sale .btn-primary').removeClass('disabled'); submitted = false; }); } }) }, {width: 1000}); }); // Currently the function is Static, but it can be changed to dynamic // by using nested loop and a flag to store the match status function getObjectIndex(arr, product_id, size_id, colour_id) { // Loop over array to find the matching element/object for (var i = 0; i < arr.length; i++) { var obj = arr[i]; if (obj.product_id === product_id && obj.size_id === size_id && obj.colour_id === colour_id) { // When all key-value matches return the array index return i; } } // When no match found, return false return false; } function printStock(model) { var html = ''; var total_row_quantity = 0; var total_row_value = 0; $.each(model, function (i1, v1) { html += '<tr>'; $.each(v1, function (i2, v2) { html += '<td>' + v2 + '</td>'; $('#product_totals tr').each(function(i3, v3){ var product_code = $('td', v3).eq(0).html(); if(product_code == v2) { total_row_quantity += parseInt(model[i1].quantity); total_row_value += parseFloat($('td', v3).eq(2).html()*model[i1].quantity); $('td', v3).eq(1).html(total_row_quantity); $('td', v3).eq(3).html(accounting.formatMoney(total_row_value, '')); } else { total_row_quantity = 0; total_row_value = 0; } }) }); html += '</tr>'; }); $('#stock_order tbody').html(html); }
HTML:
<tbody id="product_totals"> <tr data-id="1"> <td>JW1501</td> <td class="code-quantity-total">0</td> <td>79.00</td> <td class="code-cost-total">0</td> </tr> <tr data-id="2"> <td>JW1502</td> <td class="code-quantity-total">0</td> <td>99.00</td> <td class="code-cost-total">0</td> </tr> <tr data-id="3"> <td>JW1501-1</td> <td class="code-quantity-total">0</td> <td>20.00</td> <td class="code-cost-total">0</td> </tr> <tr data-id="4"> <td>JW1502-2</td> <td class="code-quantity-total">0</td> <td>25.00</td> <td class="code-cost-total">0</td> </tr> </tbody>
The list of strings (JW1501, JW1502) is dynamic.
The problem that I am facing is that if an option, for example, Adds JW1502, only the total quantity and value is calculated for this. Any previous various versions of the JW1502 are ignored.
How can i fix this?
An example of the contents of the var model:
[ {"product_id":"JW1501","size_id":"70A","colour_id":"ๅฐ่ฑน็บน","quantity":"1"}, {"product_id":"JW1501","size_id":"75B","colour_id":"ๅฐ่ฑน็บน","quantity":"2"}, {"product_id":"JW1502","size_id":"85A","colour_id":"้ป่ฒ","quantity":"1"} ]
The above for JW1501 shows the wrong number 2, not 3.
... $('#product_totals tr').each(function (i3, v3) { console.log(v1, v2, v3) ...
Outputs:
Object {product_id: "JW1501", size_id: "70A", colour_id: "ๅฐ่ฑน็บน", quantity: "2"} "JW1501" <tr data-id=โ"1">โ<td>โJW1501โ</td>โ<td class=โ"code-quantity-total">โ2โ</td>โ<td>โ79.00โ</td>โ<td class=โ"code-cost-total">โ158.00โ</td>โ</tr>โ