Выписка счета на оплату - страница 2 - [VM1] Оплата и доставка

	// Shipping address based TAX
		if ( !$this->tax_based_on_vendor_address () ) {
			$q = "SELECT state, country FROM #__{vm}_user_info ";
			$q .= "WHERE user_info_id='".@$_REQUEST["ship_to_info_id"] . "'";
			$db->query($q);
			$db->next_record();
			$state = $db->f("state");
			$country = $db->f("country");
			$q = "SELECT * FROM #__{vm}_tax_rate WHERE tax_country='$country' ";
			if( $state ) {
				$q .= "AND tax_state='$state'";
			}
			$db->query($q);
			if ($db->next_record()) {
				$rate = $order_taxable * floatval( $db->f("tax_rate") );
				if (empty($rate)) {
					$order_tax = 0.0;
				}
				else {
					$order_tax = $rate;
				}
			}
			else {
				$order_tax = 0.0;
			}
			$order_tax_details[$db->f('tax_rate')] = $order_tax;
		}
		
		else {
			/*// Store Owner Address based TAX
			if (MULTIPLE_TAXRATES_ENABLE != '1' ) {
				$q = "SELECT `tax_rate` FROM #__{vm}_vendor, #__{vm}_tax_rate ";
				$q .= "WHERE tax_country=vendor_country ";
				$q .= "AND #__{vm}_vendor.vendor_id='1' ";
				$q .= "ORDER BY `tax_rate` DESC";
				$db->query($q);
				if ($db->next_record()) {
					$tax_rate = $db->f("tax_rate");
					$rate = $order_taxable * $tax_rate;
					
					if (empty($rate)) {
						$order_tax = 0.0;
					}
					else {
						$order_tax = $rate;
					}
				}
				else {
					$order_tax = 0.0;
				}
				$order_tax_details[$db->f('tax_rate')] = $order_tax;
			}
			else {*/
				// Calculate the Tax with a tax rate for every product
				$cart = $_SESSION['cart'];
				$order_tax = 0.0;
				$total = 0.0;
				if( (!empty( $_SESSION['coupon_discount'] ) || !empty( $d['payment_discount'] ))
					&& PAYMENT_DISCOUNT_BEFORE == '1' ) {
					// We need to recalculate the tax details when the discounts are applied
					// BEFORE taxes - because they affect the product subtotals then
					$order_tax_details = array();
				}
				require_once(CLASSPATH.'ps_product.php');
				$ps_product= new ps_product;
				require_once(CLASSPATH.'ps_shipping_method.php');

				for($i = 0; $i < $cart["idx"]; $i++) {
					$item_weight = ps_shipping_method::get_weight($cart[$i]["product_id"]) * $cart[$i]['quantity'];

					if ($item_weight !=0 or TAX_VIRTUAL) {
						$price = $ps_product->get_adjusted_attribute_price($cart[$i]["product_id"], $cart[$i]["description"]);
						$tax_rate = $ps_product->get_product_taxrate($cart[$i]["product_id"]);
						
						if( (!empty( $_SESSION['coupon_discount'] ) || !empty( $d['payment_discount'] ))
							&& PAYMENT_DISCOUNT_BEFORE == '1' ) {
							// Reduce the product subtotals by the factor the complete subtotal is reduced/raised by the discounts
							$use_coupon_discount= @$_SESSION['coupon_discount'];
							if( !empty( $_SESSION['coupon_discount'] )) {
								if( $auth["show_price_including_tax"] == 1 ) {
									$use_coupon_discount = $_SESSION['coupon_discount'] / ($tax_rate+1);
								}
							}
							$factor = (100 * ($use_coupon_discount + @$d['payment_discount'])) / $this->_subtotal;
							$price["product_price"] = $price["product_price"] - ($factor * $price["product_price"] / 100);
							@$order_tax_details[$tax_rate] += $price["product_price"] * $tax_rate * $cart[$i]["quantity"];
						}
						
						//echo "$order_tax += {$price["product_price"]} * $tax_rate * {$cart[$i]["quantity"]}";
						$order_tax += $price["product_price"] * $tax_rate * $cart[$i]["quantity"];
						$total += $price["product_price"] * $cart[$i]["quantity"];
					}
				}

				if( (!empty( $_SESSION['coupon_discount'] ) || !empty( $d['payment_discount'] ))
					&& PAYMENT_DISCOUNT_BEFORE != '1' ) {
						
					// Here we need to re-calculate the Discount
					// because we assume the Discount is "including Tax"
					$discounted_total = $d['order_subtotal_withtax'] - @$_SESSION['coupon_discount'] - $d['payment_discount'];
					
					if( $discounted_total != $d['order_subtotal_withtax'] ) {
						$discount_factor = $discounted_total / $d['order_subtotal_withtax'];
						
						foreach( $order_tax_details as $rate => $value ) {
							$order_tax_details[$rate] = $value * $discount_factor;
						}
					}
					
				}
				if( $this->_SHIPPING ) {
					$taxrate = $this->_SHIPPING->get_tax_rate();
					if( $taxrate ) {
						$rate = $this->_SHIPPING->get_rate( $d );
						if( $auth["show_price_including_tax"] == 1 ) {
							@$order_tax_details[$taxrate] += $rate - ($rate / ($taxrate+1));
						}
						else {
							@$order_tax_details[$taxrate] += $rate * $taxrate;
						}
					}
				}
			//}

		}
		return( round( $order_tax, 2 ) );
	}
  

// Shipping address based TAX
		IF (TAX_MODE == '0') {
			$q = "SELECT state, country FROM #__{vm}_user_info ";
			$q .= "WHERE user_info_id='".@$_REQUEST["ship_to_info_id"] . "'";
			$db->query($q);
			$db->next_record();
			$state = $db->f("state");
			$country = $db->f("country");
			$q = "SELECT * FROM #__{vm}_tax_rate WHERE tax_country='$country' ";
			IF( $state ) {
				$q .= "AND tax_state='$state'";
			}
			$db->query($q);
			IF ($db->next_record()) {
				$rate = $order_taxable * floatval( $db->f("tax_rate") );
				IF (EMPTY($rate)) {
					$order_tax = 0.0;
				}
				ELSE {
					$order_tax = $rate;
				}
			}
			ELSE {
				$order_tax = 0.0;
			}
			$order_tax_details[$db->f('tax_rate')] = $order_tax;
		}
		// Store Owner Address based TAX
		ELSEIF (TAX_MODE == '1') {

			IF (MULTIPLE_TAXRATES_ENABLE != '1' ) {
				$q = "SELECT `tax_rate` FROM #__{vm}_vendor, #__{vm}_tax_rate ";
				$q .= "WHERE tax_country=vendor_country ";
				$q .= "AND #__{vm}_vendor.vendor_id='1' ";
				$q .= "ORDER BY `tax_rate` DESC";
				$db->query($q);
				IF ($db->next_record()) {
					$tax_rate = $db->f("tax_rate");
					$rate = $order_taxable * $tax_rate;
					
					IF (EMPTY($rate)) {
						$order_tax = 0.0;
					}
					ELSE {
						$order_tax = $rate;
					}
				}
				ELSE {
					$order_tax = 0.0;
				}
				$order_tax_details[$db->f('tax_rate')] = $order_tax;
			}
			ELSE {
				// Calculate the Tax with a tax rate for every product
				$cart = $_SESSION['cart'];
				$order_tax = 0.0;
				$total = 0.0;
				IF( (!EMPTY( $_SESSION['coupon_discount'] ) || !EMPTY( $d['payment_discount'] ))
					&& PAYMENT_DISCOUNT_BEFORE == '1' ) {
					// We need to recalculate the tax details when the discounts are applied
					// BEFORE taxes - because they affect the product subtotals then
					$order_tax_details = ARRAY();
				}
				REQUIRE_ONCE(CLASSPATH.'ps_product.php');
				$ps_product= NEW ps_product;
				REQUIRE_ONCE(CLASSPATH.'ps_shipping_method.php');

				FOR($i = 0; $i < $cart["idx"]; $i++) {
					$item_weight = ps_shipping_method::get_weight($cart[$i]["product_id"]) * $cart[$i]['quantity'];

					IF ($item_weight !=0 OR TAX_VIRTUAL) {
						$price = $ps_product->get_adjusted_attribute_price($cart[$i]["product_id"], $cart[$i]["description"]);
						$tax_rate = $ps_product->get_product_taxrate($cart[$i]["product_id"]);
						
						IF( (!EMPTY( $_SESSION['coupon_discount'] ) || !EMPTY( $d['payment_discount'] ))
							&& PAYMENT_DISCOUNT_BEFORE == '1' ) {
							// Reduce the product subtotals by the factor the complete subtotal is reduced/raised by the discounts
							$factor = (100 * ($_SESSION['coupon_discount'] + $d['payment_discount'])) / $this->_subtotal;
							$price["product_price"] = $price["product_price"] - ($factor * $price["product_price"] / 100);
							@$order_tax_details[$tax_rate] += $price["product_price"] * $tax_rate * $cart[$i]["quantity"];
						}
						
						$order_tax += $price["product_price"] * $tax_rate * $cart[$i]["quantity"];
						$total += $price["product_price"] * $cart[$i]["quantity"];
					}
				}

				IF( (!EMPTY( $_SESSION['coupon_discount'] ) || !EMPTY( $d['payment_discount'] ))
					&& PAYMENT_DISCOUNT_BEFORE != '1' ) {
						
					// Here we need to re-calculate the Discount
					// because we assume the Discount is "including Tax"
					$discounted_total = $d['order_subtotal_withtax'] - $_SESSION['coupon_discount'] - $d['payment_discount'];
					
					IF( $discounted_total != $d['order_subtotal_withtax'] ) {
						$discount_factor = $discounted_total / $d['order_subtotal_withtax'];
						
						FOREACH( $order_tax_details as $rate => $value ) {
							$order_tax_details[$rate] = $value * $discount_factor;
						}
					}
					
				}
				IF( $this->_SHIPPING ) {
					$taxrate = $this->_SHIPPING->get_tax_rate();
					IF( $taxrate ) {
						$rate = $this->_SHIPPING->get_rate( $d );
						IF( $auth["show_price_including_tax"] == 1 ) {
							@$order_tax_details[$taxrate] += $rate - ($rate / ($taxrate+1));
						}
						ELSE {
							@$order_tax_details[$taxrate] += $rate * $taxrate;
						}
					}
				}
			}

		}
		RETURN( round( $order_tax, 2 ) );
	}