$camb){ if($camb != ''){ $total_discounts[] = $camb; } } //change $BCOUNTRY = strtoupper($BCOUNTRY); $SCOUNTRY = strtoupper($SCOUNTRY); $BSTATE = strtoupper($BSTATE); $SSTATE = strtoupper($SSTATE); $HTML = "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "

\n"; $HTML .= "".lang("BILLING INFORMATION")."

\n"; $HTML .= "$BFIRSTNAME $BLASTNAME
"; if ($BCOMPANY != "") { $HTML .= "$BCOMPANY
\n"; } $HTML .= "$BADDRESS1
\n"; if ($BADDRESS2 != "") { $HTML .= "$BADDRESS2
\n"; } $HTML .= "$BCITY, $BSTATE $BZIPCODE
\n"; $HTML .= "$BCOUNTRY

\n"; $HTML .= "$BPHONE
\n"; $HTML .= "$BEMAILADDRESS\n"; $HTML .= "

\n"; $HTML .= "".lang("SHIPPING INFORMATION")."

\n"; $HTML .= "$SFIRSTNAME $SLASTNAME
"; if ($SCOMPANY != "") { $HTML .= "$SCOMPANY
\n"; } $HTML .= "$SADDRESS1
\n"; if ($SADDRESS2 != "") { $HTML .= "$SADDRESS2
\n"; } $HTML .= "$SCITY, $SSTATE $SZIPCODE
\n"; $tmpSC = split(" - ",$SCOUNTRY); $HTML .= "$tmpSC[0] - $tmpSC[1]

\n"; $HTML .= "$SPHONE
\n"; $HTML .= "

\n\n"; # Show view/edit cart link? $cartpref = new userdata("cart"); if ( $cartpref->get("invoice_viewedit_link") == "yes" ) { $HTML .= "\n\n"; } ############################################################################################ // Show invoice notice for offline shipping calculation ############################################################################################ if ( $SHIPPING_OPTS['SHIP_METHOD'] == "Offline" ) { $HTML .= "\n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= "

\n"; $HTML .= " \n"; $HTML .= " ".$SHIPPING_OPTS[NOTICE]; $HTML .= " \n"; $HTML .= "

\n"; $HTML .= "
\n"; } if ( $cartpref->get("invoice_custom_message") == "yes" ) { $HTML .= "

".$cartpref->get("invoice_custom_message_text")."

\n"; } ############################################################################################ // ----------------------------------------------------------------------------------------- // NOW DISPLAY ACTUAL INVOICE LINE ITEMS // ----------------------------------------------------------------------------------------- ############################################################################################ $HTML .= "\n"; $tmp_formdata = split(":p:", $CART_FORMDATA); $tmp_keyid = split(";", $CART_KEYID); $tmp_qty = split(";", $CART_QTY); $tmp_skuno = split(";", $CART_SKUNO); $tmp_catno = split(";", $CART_CATNO); $tmp_name = split(";", $CART_PRODNAME); $tmp_subcat = split(";", $CART_SUBCAT); $tmp_varname = split(";", $CART_VARNAME); $tmp_price = split(";", $CART_UNITPRICE); $tmp_sub = split(";", $CART_UNITSUBTOTAL); $display_subtotal = 0; // Reset Display sub_total; we'll calculate that on the fly $line_items = count($tmp_qty); // Count the number of array vars we have after split $line_items = $line_items - 2; // Subtract 2 because (a)we start count at 0 (b) we always have a trailing semi-colon; # Alternate row bg color if ($sep == "row-altbg") { $sep = "row-normalbg"; } else { $sep = "row-altbg"; } /*--Test session data---* $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; /*--Test session data---*/ $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; if(count($total_discounts) > 0){ $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; #change $discounttotal = 0; #change for ($z=0;$z<=$line_items;$z++) { $display_subtotal = $display_subtotal + $tmp_sub[$z]; // Add Unit Sub Total to Total Sub Total ??? Confused yet? if ($sep == "row-altbg") { $sep = "row-normalbg"; } else { $sep = "row-altbg"; } if (strlen($tmp_subcat[$z]) > 2) { $tmp_varname[$z] = "- " . $tmp_varname[$z]; } // Format for proper display // ----------------------------------------------------------- // Build display for sku number and catalog number in invoice // ----------------------------------------------------------- $ref_id_display = "

"; if ($tmp_skuno[$z] != "") { $ref_id_display .= "[Sku: $tmp_skuno[$z]] "; } if ($tmp_catno[$z] != "") { $ref_id_display .= "[Cat: $tmp_catno[$z]] "; } $ref_id_display .= "

"; $ref_id_display = strtoupper($ref_id_display); // ----------------------------------------------------------- $tmp_name[$z] = str_replace("#Q#", """, $tmp_name[$z]); // Fix for quotes not appearing in product name $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; #CHANGE if(count($total_discounts) > 0){ $HTML .= "\n"; } #CHANGE if(count($total_discounts) > 0){ $HTML .= "\n"; $HTML .= "\n"; #change $discounttotal = $_SESSION['unitsub_array'][$z] + $discounttotal; #change } // End of $z Loop eval(hook("prod_cust_invoice.inc:before-tax")); // ======================================================================================== // DISPLAY ORDER SUB-TOTAL // ======================================================================================== if ($sep == "row-altbg") { $sep = "row-normalbg"; } else { $sep = "row-altbg"; } #change $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; if(count($total_discounts) > 0){ $HTML .= "\n"; $HTML .= "\n"; } else { //$HTML .= "\n"; eval(hook("prod_cust_invoice.inc:in-shipping-calc-1")); $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; # Country tax if ( $taxpref->get("taxwhen") != "aftershipping" && $cthisTax != "" && $cthisTax > 0 ) { $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; } # Vat item tax if ( $vatSub != "" && $vatSub != "0.00" ){ $HTML .= "\n"; // $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; } # State tax: Process here here if "taxwhen" option is set to charge tax AFTER shipping if ( $sthisTax != "" && $sthisTax != "0.00" && $taxpref->get("taxwhen") != "aftershipping" ) { $HTML .= "\n"; // $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; } # Update tax total to include shipping? # Include shipping charges in tax calculation? //echo $taxpref->get("taxwhen")."[$cthisTax]"; if ( $taxpref->get("taxwhen") == "aftershipping" && ($sthisTax > 0 || $cthisTax > 0) ) { $tax_subtotal = $tax_subtotal + $SHIPPING_TOTAL; if ($cthisTax > 0 ) { $sthisTax = $ccalcTax * $tax_subtotal; $taxtype = 'country'; } else { $sthisTax = $scalcTax * $tax_subtotal; $taxtype = 'state'; } //$HTML .= "
New taxed total: [".$tax_subtotal."]
"; //$HTML .= "
New tax amount: [".$taxed_shipping."]
"; # Display tax total after shipping charges $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; $HTML .= " \n"; } eval(hook("prod_cust_invoice.inc:after-tax")); ########################################################################################### // DISPLAY TOTAL SALE COST ########################################################################################### //more testing //echo "SHIPPING_TOTAL >> ($SHIPPING_TOTAL)
\n"; //$ORDER_TOTAL = $display_subtotal + $sthisTax + $cthisTax + $vatSub + $SHIPPING_TOTAL; if ( $taxpref->get("taxwhen") == "aftershipping" && ($sthisTax > 0 || $cthisTax > 0)) { if ( $taxpref->get("vat_calculation_method") != 'included' ) { $ORDER_TOTAL = $display_subtotal + $sthisTax + $vatSub + $SHIPPING_TOTAL; } else { $ORDER_TOTAL = $display_subtotal + $sthisTax + $SHIPPING_TOTAL; } } else { if ( $taxpref->get("vat_calculation_method") != 'included' ) { $ORDER_TOTAL = $display_subtotal + $sthisTax + $cthisTax + $vatSub + $SHIPPING_TOTAL; } else { $ORDER_TOTAL = $display_subtotal + $SHIPPING_TOTAL; } } //echo "ORDER_TOTAL = display_subtotal($display_subtotal) + display_tax($display_tax) + SHIPPING_TOTAL($SHIPPING_TOTAL)
\n"; $ORDER_TOTAL = sprintf ("%01.2f", $ORDER_TOTAL); //echo "FINAL ORDER_TOTAL ----->> $ORDER_TOTAL\n"; $HTML .= "\n"; $HTML .= "\n"; #change $HTML .= "\n"; $HTML .= "\n"; $HTML .= "\n"; // Register ORDER_TOTAL with our session for databasing and payment processing // ------------------------------------------------------------------------------------- $_SESSION['ORDER_TOTAL'] = $ORDER_TOTAL; $HTML .= "

\n"; $HTML .= " Order Number: ".$ORDER_NUMBER."\n"; $HTML .= "
\n"; $HTML .= " Order Total: ".$ORDER_TOTAL."\n"; $HTML .= "
\n"; $HTML .= "".lang("Product Name")."\n"; $HTML .= "	\n"; $HTML .= "".lang("Unit Price")."\n"; $HTML .= "	\n"; $HTML .= "".lang("Quantity")."\n"; $HTML .= "	\n"; $HTML .= "".lang("Discount")."\n"; $HTML .= "	\n"; } else { $HTML .= "	\n"; } $HTML .= "".lang("Sub-Total")."\n"; $HTML .= "
\n"; //Do we need to display special VAT rate? $specVat = ""; if ($getVat['SPECIAL_TAX'] != "" && $OPTIONS['CHARGE_VAT'] == "yes" && $OPTIONS['VAT_REG'] != "vatnum") { $specVat = "(VAT ".$getVat['SPECIAL_TAX']."%)"; } $HTML .= "$ref_id_display".$tmp_name[$z]." ".$specVat." ".$tmp_subcat[$z]." ".$tmp_varname[$z]."\n"; $HTML .= ""; //format form data into line-items $form_line = split(":br:", $tmp_formdata[$z]); $num_fl = count($form_line); for ($f=0;$f<=$num_fl;$f++) { $HTML .= $form_line[$f] . " \n"; } eval(hook("pgm-more_information.php:dispinv")); $HTML .= ""; $HTML .= "	\n"; $HTML .= $dSign."".sprintf ("%01.2f", $tmp_price[$z])."\n"; $HTML .= "	\n"; $HTML .= "[".$tmp_qty[$z]."]\n"; $HTML .= "	\n"; $HTMLz = ''; if($_SESSION['unitsub_array'][$z] != 0) { if($_SESSION['discount_ammounts'][$z] != '') { $_SESSION['unitsub_array'][$z] = $_SESSION['unitsub_array'][$z] * -1; $HTMLz .= "- ".$dSign.sprintf ("%01.2f", $_SESSION['unitsub_array'][$z]); $HTMLz .= " (".$_SESSION['discount_ammounts'][$z].")"; } else { $_SESSION['unitsub_array'][$z] = $_SESSION['unitsub_array'][$z] * -1; $HTMLz .= "- ".$dSign.sprintf ("%01.2f", $_SESSION['unitsub_array'][$z]); //$HTML .= " (".$_SESSION['discount_ammounts'][$z].")"; } } $HTML .= $HTMLz; $HTML .= "	\n"; } else { $HTML .= "	\n"; } $tmp_sub[$z] = $tmp_sub[$z] - $_SESSION['unitsub_array'][$z]; $tmp_sub[$z] = sprintf ("%01.2f", $tmp_sub[$z]); $HTML .= $dSign."$tmp_sub[$z]\n"; $HTML .= "
\n"; $HTML .= "\n"; $HTML .= "
\n"; $HTML .= lang("Sub-Total").":\n"; $HTML .= "				\n"; $display_subtotal = sprintf ("%01.2f", $display_subtotal); $HTML .= $dSign."$display_subtotal\n"; $HTML .= "
\n"; $disct = $discounttotal; $discounttotal = $discounttotal * -1; $HTML .= "Discounts:					- ".$dSign.sprintf ("%01.2f", $disct)."\n"; $HTML .= "
\n"; } #change // ======================================================================================== // DISPLAY TAX TOTAL // ======================================================================================== $taxpref = new userdata("tax_rate_options"); if ( $taxpref->get("taxby") == "" ) { $taxpref->set("taxby", "SCOUNTRY"); } // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // Read Tax Table to determine if current ship-to state/country needs // to be charged sales tax // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ //Make sure tax variables are upper case $BSTATE = strtoupper($BSTATE); $SSTATE = strtoupper($SSTATE); $BCOUNTRY = strtoupper($BCOUNTRY); $SCOUNTRY = strtoupper($SCOUNTRY); $state_to_tax = ${str_replace('COUNTRY', 'STATE', $taxpref->get("taxby"))}; $stax_perc = "$stax_perc"; $result = mysql_query("SELECT * FROM cart_tax"); while ($TAX = mysql_fetch_array($result)) { if($state_to_tax == $TAX['state']) { $stax_perc = $TAX['rate']; } elseif($OPTIONS['DISPLAY_STATE']=='tfield'){ $txstate = explode(' - ', $TAX['state']); if($state_to_tax == $txstate['0']){ $stax_perc = $TAX['rate']; } elseif($state_to_tax == $txstate['1']){ $stax_perc = $TAX['rate']; } } } //====================== //Check for VAT tax //====================== # Make sure there's a VAT number if ($OPTIONS['CHARGE_VAT'] == "yes" && $OPTIONS['VAT_REG'] != "vatnum") { $ctax_perc = "$ctax_perc"; $result = mysql_query("SELECT * FROM cart_vat"); # Set default if no value while ( $VAT = mysql_fetch_assoc($result) ) { if ( ${$taxpref->get("taxby")} == $VAT['country'] && $ctax_perc=='') { $ctax_perc = $VAT['rate']; } if ( ${str_replace('COUNTRY','STATE',$taxpref->get("taxby"))} == $VAT['country'] ) { $ctax_perc = $VAT['rate']; } } } // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // If so, calculate tax // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ if ( ($stax_perc != "") \|\| ($ctax_perc != "") ) { $staxrate = $stax_perc; $ctaxrate = $ctax_perc; $scalcTax = $staxrate / 100; $ccalcTax = $ctaxrate / 100; $exempt = 0; // Bugzilla #38 $vatSub = 0; // Euro Stuff - 040408 $numSkus = count($tmp_skuno); // Bugzilla #38 // Account for "tax exempt" items in calculation - Bugzilla #38 // 2004-04-08: Also account for items with special VAT rate // 2004-08-02: Check new "SPECIAL_TAX" field and leave SHIPC alone for ($m=0;$m<=$numSkus;$m++) { $result = mysql_query("SELECT * FROM cart_products WHERE PROD_SKU = '$tmp_skuno[$m]'"); $getProd = mysql_fetch_array($result); if ($getProd[OPTION_CHARGETAX] == "N" ) { $exempt += $tmp_sub[$m]; } if ($getProd[SPECIAL_TAX] != "") { $vatRate = $getProd[SPECIAL_TAX]; $calcVat = $vatRate / 100; $vatSub += $calcVat * $tmp_sub[$m]; } } $tax_subtotal = $display_subtotal - $exempt; // Bugzilla #38 $sthisTax = $tax_subtotal * $scalcTax; // Bugzilla #38 $cthisTax = $tax_subtotal * $ccalcTax; // Bugzilla #38 $stax = number_format($sthisTax,2); $ctax = number_format($cthisTax,2); $staxrate = "( $stax_perc% )"; if ( $ctax_perc == "" ){ $ctaxrate = "( 0% )"; } else { $ctaxrate = "( $ctax_perc% )"; } } else { $staxrate = ""; $ctaxrate = ""; // Account for Special Tax items when no tax is charged - Bugzilla #38 $numSkus = count($tmp_skuno); // Bugzilla #38 for ($s=0;$s<=$numSkus;$s++) { $result = mysql_query("SELECT * FROM cart_products WHERE PROD_SKU = '$tmp_skuno[$s]'"); $getSpecial = mysql_fetch_array($result); if ($getSpecial[SPECIAL_TAX] != "") { $vatRate = $getSpecial[SPECIAL_TAX]; $calcVat = $vatRate / 100; $vatSub += $calcVat * $tmp_sub[$s]; } } //$sdisplay_tax = "0.00"; //$cdisplay_tax = "0.00"; } ########################################################################################### // DISPLAY SHIPPING TOTAL ########################################################################################### $HTML .= "
\n"; $HTML .= " $SHIPPING_INSTRUCTIONS ".lang("Shipping & Handling").":\n"; $HTML .= "				\n"; $sshiptax = 0; $cshiptax = 0; // Do not echo price value if using Offline Shipping // =================================================== if ( $SHIPPING_OPTS[SHIP_METHOD] == "Offline" ) { // Pending Calculation $HTML .= " Pending Calculation\n"; } else { # Account for shipping option to disable charging shipping for individual products # Note: Only for non-subtotal shipping charge method. SubTotal-based shipping charges calculated in pgm-checkout.php:825 if ( $SHIPPING_OPTS['SHIP_METHOD'] != "SubTotal" ) { for ($m=0;$m<=$numSkus;$m++) { $result = mysql_query("SELECT * FROM cart_products WHERE PROD_SKU = '$tmp_skuno[$m]'"); $getProd = mysql_fetch_array($result); if ($getProd['OPTION_CHARGESHIPPING'] == "N") { $amoutToDel = $getProd['PROD_SHIPA']$tmp_qty[$m]; $SHIPPING_TOTAL = $SHIPPING_TOTAL - $amoutToDel; // # Testing - Items with disabled shipping // echo "shipping for sku num(".$getProd[PROD_SKU].") and prikey (".$getProd[PRIKEY].") is (".$getProd[PROD_SHIPA].") "; // echo "The current row is (".$m.") "; // echo "qty in session (".$tmp_qty[$m].") "; // echo "This is the amount to delete (".$amoutToDel.") "; } } } $SHIPPING_TOTAL = sprintf ("%01.2f", $SHIPPING_TOTAL); $HTML .= " ".$dSign.$SHIPPING_TOTAL."\n"; // $SHIPPING_TAX = $SHIPPING_TOTAL .125; // wtf is this for? MM 3/5/12 $SHIPPING_TAX = 0; // Setting to zero for now, because it seems to only do harm } eval(hook("prod_cust_invoice.inc:in-shipping-calc-2")); $HTML .= "
\n"; $HTML .= " ".${$taxpref->get("taxby")}." Tax ".$ctaxrate."\n"; if ( $taxpref->get("vat_calculation_method") == 'included' ) { $HTML .= " (".$taxpref->get("vat-or-gst")." included in price)"; } $HTML .= ": \n"; $HTML .= "				\n"; $cthisTax = sprintf ("%01.2f", $cthisTax); $ttax = sprintf ("%01.2f", $cthisTax + $SHIPPING_TAX); $HTML .= $dSign.$ttax."\n"; $HTML .= "
\n"; // $HTML .= "\n"; // $HTML .= "	\n"; $HTML .= "Special Tax ".$getVat[SPECIAL_TAX]."%: \n"; $HTML .= "				\n"; $vatSub = sprintf ("%01.2f", $vatSub); $HTML .= $dSign."$vatSub\n"; $HTML .= "
\n"; // $HTML .= " \n"; // $HTML .= "	\n"; $HTML .= $BSTATE." ".lang("Tax")." ".$staxrate.": \n"; $HTML .= "	\n"; $sthisTax = sprintf ("%01.2f", $sthisTax); $HTML .= $dSign."".$sthisTax."\n"; $HTML .= "
\n"; if ( $taxtype == 'state' ) { $HTML .= $state_to_tax." ".lang("Tax")." ".$staxrate.": \n"; } else { $HTML .= $BCOUNTRY." ".lang("Tax")." ".$ctaxrate.""; if ( $taxpref->get("vat_calculation_method") == 'included' ) { $HTML .= " (".$taxpref->get("vat-or-gst")." included in price)"; } $HTML .= ": \n"; } $HTML .= "	\n"; $sthisTax = sprintf ("%01.2f", $sthisTax); $HTML .= $dSign."".$sthisTax."\n"; $HTML .= "
\n"; $HTML .= "\n"; $HTML .= "	\n"; $ORDER_TOTAL = $ORDER_TOTAL + $discounttotal; #change $HTML .= "".lang("Total").":\n"; $HTML .= "			\n"; $ORDER_TOTAL = sprintf ("%01.2f", $ORDER_TOTAL); $HTML .= "".$dSign.$ORDER_TOTAL."\n"; $HTML .= "

\n\n"; echo $HTML; ?>