How do I calculate the total of the qty and price in a dynamic created html table row

Question

I need help I have no Idea how to get the price and qty subtotals also I'm getting an undefined in the type field which is a drop down input I found this code here in this forum it calculates the total of the price column put not multiplying the qty and price to give a subtotal I'm very new at this jquery and java script How can I add a function that would multiply the qty * price

function row(Id, Code, Client, Quantity, Price) {
	  this.Id = Id;
	  this.Code = Code;
	  this.Client = Client;
	  //this.DebitCredit = DebitCredit;
	  this.Quantity = Quantity;
	  this.Price = Price;
}

function model() {
  this.rows = [];
}

var mymodel = new model();

$(document).ready(function() {
	  $("body").on("click", ".delete", function() {
		var id = $(this).data('id');
		for (i = 0; i < mymodel.rows.length; i++) {
		  console.log(mymodel.rows[i].Id);
		  if (mymodel.rows[i].Id == id) {
			mymodel.rows.splice(i, 1);
		  }
		}
		draw();
});

$('#add').click(function() {
		mymodel.rows.push(new row(
		  $('#Id').val(),
		  $('#Code').val(),
		  $('#Client').val(),
		  Number($('#Quantity').val()),
		  Number($('#Price').val())
		))
		draw();
	  });
})

function draw() {
  $('tbody').empty();
  var totalQuantity = 0;
  var totalPrice = 0;
  $.each(mymodel.rows, function(i, row) {
  totalQuantity += row.Quantity;
  totalPrice += row.Price;
  var myrow = ''
  $.each(row, function(key, value) {
    myrow += '' + value + ''
  });
  myrow += ''
  myrow += ''
  $('tbody').append(myrow);
  });
  $('#totalQuantity').text(totalQuantity)
  $('#totalPrice').text(totalPrice)
}


	
	
		
		
	
		
	
	

	
	

	
	  
		
		  Part #
		  Part Name
		  Type
		  Quantity
		  Price
		  Delete
		
	  
	  

	  
	  
		
		  Total Quantity:
			 Total Price:
			
		  

		
	  
	

	
	  
		Part #:
		
	  
	  
		Part Name:
		
	  
	  
		Type:
		
	  
	  
		Quantity:
		
	  
	  
		Price:

Alain Cruz · Accepted Answer

You were missing a small detail. When setting the total price, you were using this code totalPrice += row.Price;. All you needed to do, was changing the code, so that instead of just adding up the price, you would multiply it by the row quantity, totalPrice += row.Price * row.Quantity;.

function row(Id, Code, Client, Quantity, Price) {
	  this.Id = Id;
	  this.Code = Code;
	  this.Client = Client;
	  //this.DebitCredit = DebitCredit;
	  this.Quantity = Quantity;
	  this.Price = Price;
    this.Total = Quantity * Price;
	}

	function model() {
	  this.rows = [];
	}

	var mymodel = new model();

	$(document).ready(function() {

	  $("body").on("click", ".delete", function() {
		var id = $(this).data('id');
		for (i = 0; i < mymodel.rows.length; i++) {
		  console.log(mymodel.rows[i].Id);
		  if (mymodel.rows[i].Id == id) {
			mymodel.rows.splice(i, 1);
		  }
		}
		draw();
	  });

	  $('#add').click(function() {
		mymodel.rows.push(new row(
		  $('#Id').val(),
		  $('#Code').val(),
		  $('#cliente').val(),
		  Number($('#Quantity').val()),
		  Number($('#Price').val())
		))
		draw();
	  });
	})

	function draw() {
	  $('tbody').empty();
	  var totalQuantity = 0;
	  var totalPrice = 0;
	  $.each(mymodel.rows, function(i, row) {
		totalQuantity += row.Quantity;
		totalPrice += row.Price * row.Quantity;
		var myrow = '';
		$.each(row, function(key, value) {
		  myrow += '' + value + ''
		});
		myrow += ''
		myrow += ''
		$('tbody').append(myrow);
	  });
	  $('#totalQuantity').text(totalQuantity)
	  $('#totalPrice').text(totalPrice)
	}



	
	
		
		
	
		
	
	

	
	

	
	  
		
		  Part #
		  Part Name
		  Type
		  Quantity
		  Price
      Total
		  Delete
		
	  
	  

	  
	  
		
		  Total Quantity:
			 Total Price:
			
		  

		
	  
	

	
	  
		Part #:
		
	  
	  
		Part Name:
		
	  
	  
		Type:
		
	  
	  
		Quantity:
		
	  
	  
		Price:

Please, let me know if you need anything else. Also, there was a typo in #Cliente, the c was on lower case, so I changed it to #cliente.

How do I calculate the total of the qty and price in a dynamic created html table row

Answers (1)

Related Questions