@Rey:

Thanks!

Hey Dan,

I had a need to use parenthesis to indicate negative numbers in an app. To still use the calc plugin, I added a replace to the parseNumber function so that the parenthesis would be replaced with a minus sign. This seems to do the trick. Just thought I would mention it to you.

v=$el[sMethod]().replace('(','-').replace(')','').match(defaults.reNumbers,"");

Thanks,
Dave

@Philipp:

In your code, you have the selector:

$('span[id^=price_item_]')

This is going to grab each element that has an id that starts with "price_item_". So the the code's doing exactly what you're telling it to do.

You're going to need to change things up so that it only grabs the selected value.

@Nick:

First, I would ignore any value coming through in the grandTotal field. You never want to trust pricing information coming through a JS form--it's too easy for a user to overwrite these values or post their own data to your server. The calc plug-in should purely be used to provide UI feedback to the user. You should always be calculating pricing on the backend based upon quantity and a unique identifier for the product (so that you can look up pricing via the database.)

However, to answer your question, you have 2 elements with the "id" of "grandTotal"--a div and an input element. Each element should have a unique id (which is per the W3C spec.) What's happening in your situation is that since the first element with the grandTotal id is the div, it's html is being replaced with the calculated value--which is removing the input element from the DOM.

What you want is to move the input element directly under your form element and change it to:

<input type="hidden" name="grandTotal" id="grandTotalHidden" value="$0.00" size="8" />

Now change the selector in your recalc() function to:

$("#grandTotalHidden").calc( [option here] );

This will pass the grandTotal named form element. However, as I stated earlier, since you can't trust this value--I wouldn't even include it.

Hello Dan,

I am trying to get the grand total to work, but jquery 1.3.2 gives me an error.

Is there somethin I need to do to get it to work? Like adding extra code for the grandTotal?

Thanks

Hi Dan,

I'm trying use Brazilian/European format, but I haven't success.
I paste the code below on my page.

$.Calculation.setDefaults({
   reNumbers: /(-|-\$)?(\d+(\.\d{3})*(,\d{1,})?|,\d{1,})?/g
   , cleanseNumber: function (v){
   return v.replace(/[^0-9,\-]/g, "").replace(/,/g, ".");
   }
})

The result is ok, but this don't change "." to "," in the final value.
And consequently, the result that sum the results values (#valorTotal), appears wrong, without decimal values.

What can I do?

Here is my full script:
<script type="text/javascript" >
$(document).ready(function(){
   
   $.Calculation.setDefaults({
      // a regular expression for detecting European-style formatted numbers
      reNumbers: /(-|-\$)?(\d+(\.\d{3})*(,\d{1,})?|,\d{1,})?/g
      // define a procedure to convert the string number into an actual usable number
      , cleanseNumber: function (v){
         // cleanse the number one more time to remove extra data (like commas and dollar signs)
         // use this for European numbers: v.replace(/[^0-9,\-]/g, "").replace(/,/g, ".")
         return v.replace(/[^0-9,\-]/g, "").replace(/,/g, ".");
      }
   })
   
   $("input[name^=orcitem_quantidade]").bind("keyup", recalc);
   $("input[name^=orcitem_vu_]").bind("keyup", recalc);
   
   function recalc(){
      $("input[id^=orcitem_vu_total]").calc("qty * price",{ qty:$("input[id^=orcitem_quantidade]"),price:$("input[id^=orcitem_vu_material]")},function (s){ return s.toFixed(2); })
      $("input[id^=orcitem_valor_total]").calc("servico + material",{ servico:$("input[id^=orcitem_vu_servico]"),material:$("input[id^=orcitem_vu_total]")},function (s){ return s.toFixed(2); },
      function ($this){
var sum = $this.sum();
         $("#orc_valor_total").val(sum.toFixed(2));
         $("#valorTotal").text(sum.toFixed(2))
      })
   };   
});
</script>

Thanks!

[]'s
Gustavo

i need to deduct number from the grand total??

@Carsten:

I'd recommend using jQuery's trigger() method on the keyup event--which will run any keyup event handlers defined for the field.