2njenn

05-24-2005, 11:55 PM

I'm having difficulty modifying a free script and am hoping someone can help me out! I want to add subtotal and discount calculations to the script posted below.

I am trying to add the following conditions and I want the fields order_subtotal and order_discount to do a running total, just like the original total field. I'm pretty new to this and I think I am missing something really obvious... Thanks for any help!

My attempt is listed at bottom of post.

The form is located at:

http://www.gotbusch.com/dev/dqp/orderinfo/order.html

The original unmodified script is as follows:

<script language="JavaScript" type="text/javascript">

<!--

/* This script is Copyright (c) Paul McFedries and

Logophilia Limited (http://www.mcfedries.com/).

Permission is granted to use this script as long as

this Copyright notice remains in place.*/

function CalculateTotal(frm) {

var order_total = 0

// Run through all the form fields

for (var i=0; i < frm.elements.length; ++i) {

// Get the current field

form_field = frm.elements[i]

// Get the field's name

form_name = form_field.name

// Is it a "product" field?

if (form_name.substring(0,4) == "PROD") {

// If so, extract the price from the name

item_price = parseFloat(form_name.substring(form_name.lastIndexOf("_") + 1))

// Get the quantity

item_quantity = parseInt(form_field.value)

// Update the order total

if (item_quantity >= 0) {

order_total += item_quantity * item_price

}

}

}

// Display the total rounded to two decimal places

frm.TOTAL.value = round_decimals(order_total, 2)

}

function round_decimals(original_number, decimals) {

var result1 = original_number * Math.pow(10, decimals)

var result2 = Math.round(result1)

var result3 = result2 / Math.pow(10, decimals)

return pad_with_zeros(result3, decimals)

}

function pad_with_zeros(rounded_value, decimal_places) {

// Convert the number to a string

var value_string = rounded_value.toString()

// Locate the decimal point

var decimal_location = value_string.indexOf(".")

// Is there a decimal point?

if (decimal_location == -1) {

// If no, then all decimal places will be padded with 0s

decimal_part_length = 0

// If decimal_places is greater than zero, tack on a decimal point

value_string += decimal_places > 0 ? "." : ""

}

else {

// If yes, then only the extra decimal places will be padded with 0s

decimal_part_length = value_string.length - decimal_location - 1

}

// Calculate the number of decimal places that need to be padded with 0s

var pad_total = decimal_places - decimal_part_length

if (pad_total > 0) {

// Pad the string with 0s

for (var counter = 1; counter <= pad_total; counter++)

value_string += "0"

}

return value_string

}

//-->

</script>

=======================================================

here are my proposed additions that do not work...

var order_subtotal = 0

var order_discount = 0

var order_total = 0

// Update the order subtotal

if (item_quantity >= 0) {

order_subtotal += item_quantity * item_price

if (order_subtotal >= 100) {

order_discount += item_quantity * item_price * 0.20

}

else

if (order_subtotal >= 30) {

order_discount += item_quantity * item_price * 0.10

}

else

if (order_subtotal < 30) {

order_discount += item_quantity * item_price}

if (order_subtotal >= 100) {

order_total += item_quantity * item_price * 0.80

}

else

if (order_subtotal >= 30) {

order_total += item_quantity * item_price * 0.90

}

else

if (order_subtotal < 30) {

order_total += item_quantity * item_price

}

// Display the total rounded to two decimal places

frm.subtotal.value = round_decimals(order_subtotal, 2)

// Display the total rounded to two decimal places

frm.discount.value = round_decimals(order_discount, 2)

I am trying to add the following conditions and I want the fields order_subtotal and order_discount to do a running total, just like the original total field. I'm pretty new to this and I think I am missing something really obvious... Thanks for any help!

My attempt is listed at bottom of post.

The form is located at:

http://www.gotbusch.com/dev/dqp/orderinfo/order.html

The original unmodified script is as follows:

<script language="JavaScript" type="text/javascript">

<!--

/* This script is Copyright (c) Paul McFedries and

Logophilia Limited (http://www.mcfedries.com/).

Permission is granted to use this script as long as

this Copyright notice remains in place.*/

function CalculateTotal(frm) {

var order_total = 0

// Run through all the form fields

for (var i=0; i < frm.elements.length; ++i) {

// Get the current field

form_field = frm.elements[i]

// Get the field's name

form_name = form_field.name

// Is it a "product" field?

if (form_name.substring(0,4) == "PROD") {

// If so, extract the price from the name

item_price = parseFloat(form_name.substring(form_name.lastIndexOf("_") + 1))

// Get the quantity

item_quantity = parseInt(form_field.value)

// Update the order total

if (item_quantity >= 0) {

order_total += item_quantity * item_price

}

}

}

// Display the total rounded to two decimal places

frm.TOTAL.value = round_decimals(order_total, 2)

}

function round_decimals(original_number, decimals) {

var result1 = original_number * Math.pow(10, decimals)

var result2 = Math.round(result1)

var result3 = result2 / Math.pow(10, decimals)

return pad_with_zeros(result3, decimals)

}

function pad_with_zeros(rounded_value, decimal_places) {

// Convert the number to a string

var value_string = rounded_value.toString()

// Locate the decimal point

var decimal_location = value_string.indexOf(".")

// Is there a decimal point?

if (decimal_location == -1) {

// If no, then all decimal places will be padded with 0s

decimal_part_length = 0

// If decimal_places is greater than zero, tack on a decimal point

value_string += decimal_places > 0 ? "." : ""

}

else {

// If yes, then only the extra decimal places will be padded with 0s

decimal_part_length = value_string.length - decimal_location - 1

}

// Calculate the number of decimal places that need to be padded with 0s

var pad_total = decimal_places - decimal_part_length

if (pad_total > 0) {

// Pad the string with 0s

for (var counter = 1; counter <= pad_total; counter++)

value_string += "0"

}

return value_string

}

//-->

</script>

=======================================================

here are my proposed additions that do not work...

var order_subtotal = 0

var order_discount = 0

var order_total = 0

// Update the order subtotal

if (item_quantity >= 0) {

order_subtotal += item_quantity * item_price

if (order_subtotal >= 100) {

order_discount += item_quantity * item_price * 0.20

}

else

if (order_subtotal >= 30) {

order_discount += item_quantity * item_price * 0.10

}

else

if (order_subtotal < 30) {

order_discount += item_quantity * item_price}

if (order_subtotal >= 100) {

order_total += item_quantity * item_price * 0.80

}

else

if (order_subtotal >= 30) {

order_total += item_quantity * item_price * 0.90

}

else

if (order_subtotal < 30) {

order_total += item_quantity * item_price

}

// Display the total rounded to two decimal places

frm.subtotal.value = round_decimals(order_subtotal, 2)

// Display the total rounded to two decimal places

frm.discount.value = round_decimals(order_discount, 2)