$tmpcontent .= '<td> </td>'; $tmpcontent .= '<td> </td>'; $tmpcontent .= '<td> </td>'; $tmpcontent .= '</tr>'; if (!isset($this->get['edit_product'])) { $tmpcontent .= '<tr><td colspan="' . $colspan . '" style="text-align:left;"><a href="#" id="button_manual_new_product" class="btn btn-success">' . $this->pi_getLL('add_manual_product', 'ADD ITEM') . '</a></td></tr>'; } } else { $colspan = 7; } // $tmpcontent.='<tr><td colspan="'.$colspan.'"><hr class="hr"></td></tr>'; $orders_tax_data = unserialize($orders['orders_tax_data']); $tmpcontent .= '<tr><td align="right" colspan="' . $colspan . '" class="">'; if ($this->ms['MODULES']['ORDER_EDIT'] and !$orders['is_locked']) { $payment_method = mslib_fe::getPaymentMethod($orders['payment_method'], 'p.code'); $shipping_method = mslib_fe::getShippingMethod($orders['shipping_method'], 's.code'); if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $shipping_costs = mslib_fe::currency() . ' <input type="text" id="display_shipping_method_cost" value="' . round($orders['shipping_method_costs'] + $orders_tax_data['shipping_tax'], 4) . '" class="align_right" style="width:60px"> <input name="tx_multishop_pi1[shipping_method_costs]" type="hidden" value="' . $orders['shipping_method_costs'] . '"> <input type="hidden" id="shipping_method_tax_id" value="' . $shipping_method['tax_id'] . '" class="align_right" style="width:60px">'; $payment_costs = mslib_fe::currency() . ' <input type="text" id="display_payment_method_cost" value="' . round($orders['payment_method_costs'] + $orders_tax_data['payment_tax'], 4) . '" class="align_right" style="width:60px"> <input name="tx_multishop_pi1[payment_method_costs]" type="hidden" value="' . $orders['payment_method_costs'] . '"> <input type="hidden" id="payment_method_tax_id" value="' . $payment_method['tax_id'] . '" class="align_right" style="width:60px"> '; } else { $shipping_costs = '<input name="tx_multishop_pi1[shipping_method_costs]" type="text" value="' . round($orders['shipping_method_costs'], 4) . '" class="align_right" style="width:60px">'; $payment_costs = '<input name="tx_multishop_pi1[payment_method_costs]" type="text" value="' . round($orders['payment_method_costs'], 4) . '" class="align_right" style="width:60px">'; } } else { if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $shipping_costs = mslib_fe::amount2Cents($orders['shipping_method_costs'] + $orders_tax_data['shipping_tax'], 0);
} if (count($mapped_shipping_methods)) { $available_sid = array(); foreach ($mapped_shipping_methods as $shipping_method_name => $mapped_shipping_method) { $available_sid[] = $mapped_shipping_method['id']; } } // if (count($available_sid) > 0) { //if (!$this->ms['MODULES']['PRODUCT_EDIT_METHOD_FILTER']) { if (!$this->post['tx_multishop_pi1']['sid'] or !in_array($this->post['tx_multishop_pi1']['sid'], $available_sid)) { // if the posted shipping id is not in the available shipping method array then select the first valid shipping method $this->post['tx_multishop_pi1']['sid'] = $available_sid[0]; } //} $shipping_method = mslib_fe::getShippingMethod($this->post['tx_multishop_pi1']['sid'], 's.id', $countries_id, true); $shipping_method_code = $shipping_method['code']; if (strlen($shipping_method['name']) > 1) { $char = substr($shipping_method['name'], 1, 1); if ($char == mslib_befe::strtolower($char)) { $shipping_method['name'] = $shipping_method['name']; } } else { $shipping_method['name'] = $shipping_method['name']; } $shipping_method_label = $shipping_method['name']; // shipping $price = ''; $priceArray = mslib_fe::getShippingCosts($countries_id, $this->post['tx_multishop_pi1']['sid']); if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $data['shipping_cost'] = '';
function setShippingMethod($shipping_method) { if (!$shipping_method) { return 0; } if (isset($this->cart['user']['delivery_countries_id']) && !empty($this->cart['user']['delivery_countries_id'])) { $priceArray = mslib_fe::getShippingCosts($this->cart['user']['delivery_countries_id'], $shipping_method); } else { $priceArray = mslib_fe::getShippingCosts($this->cart['user']['countries_id'], $shipping_method); } $price = $priceArray['shipping_costs']; if ($price) { $this->cart['user']['shipping_method_costs'] = $price; } else { $this->cart['user']['shipping_method_costs'] = 0; } if (isset($this->cart['user']['delivery_countries_id']) && !empty($this->cart['user']['delivery_countries_id'])) { $shipping_method = mslib_fe::getShippingMethod($shipping_method, 's.id', $this->cart['user']['delivery_countries_id']); } else { $shipping_method = mslib_fe::getShippingMethod($shipping_method, 's.id', $this->cart['user']['countries_id']); } if ($shipping_method['tax_id'] && $this->cart['user']['shipping_method_costs']) { $this->cart['user']['shipping_total_tax_rate'] = $shipping_method['tax_rate']; if ($shipping_method['country_tax_rate']) { $this->cart['user']['shipping_country_tax_rate'] = $shipping_method['country_tax_rate']; $this->cart['user']['shipping_country_tax'] = mslib_fe::taxDecimalCrop($this->cart['user']['shipping_method_costs'] * $shipping_method['country_tax_rate']); } else { $this->cart['user']['shipping_country_tax_rate'] = 0; $this->cart['user']['shipping_country_tax'] = 0; } if ($shipping_method['region_tax_rate']) { $this->cart['user']['shipping_region_tax_rate'] = $shipping_method['region_tax_rate']; $this->cart['user']['shipping_region_tax'] = mslib_fe::taxDecimalCrop($this->cart['user']['shipping_method_costs'] * $shipping_method['region_tax_rate']); } else { $this->cart['user']['shipping_region_tax_rate'] = 0; $this->cart['user']['shipping_region_tax'] = 0; } if ($this->cart['user']['shipping_region_tax'] && $this->cart['user']['shipping_country_tax']) { $this->cart['user']['shipping_tax'] = $this->cart['user']['shipping_country_tax'] + $this->cart['user']['shipping_region_tax']; } else { $this->cart['user']['shipping_tax'] = mslib_fe::taxDecimalCrop($this->cart['user']['shipping_method_costs'] * $shipping_method['tax_rate']); } } else { $this->cart['user']['shipping_tax'] = 0; $this->cart['user']['shipping_country_tax'] = 0; $this->cart['user']['shipping_region_tax'] = 0; $this->cart['user']['shipping_total_tax_rate'] = 0; $this->cart['user']['shipping_country_tax_rate'] = 0; $this->cart['user']['shipping_region_tax_rate'] = 0; } $this->cart['user']['shipping_method'] = $shipping_method['code']; $this->cart['user']['shipping_method_label'] = $shipping_method['name']; // hook to rewrite the whole methods if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['setShippingMethodPreSaveHook'])) { $params = array('cart_user' => &$this->cart['user']); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['setShippingMethodPreSaveHook'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } tx_mslib_cart::storeCart($this->cart); }
'; } if (count($shipping_methods)) { $content .= ' <div id="multishopShippingMethodWrapper"> <div class="main-heading"><h2>' . $this->pi_getLL('choose_shipping_method') . '</h2></div> <ul id="multishopShippingMethod" class="row">'; $count = 0; $delivery_country = $cart['user']['country']; if (isset($cart['user']['different_delivery_address']) && !empty($cart['user']['different_delivery_address']) && isset($cart['user']['delivery_country']) && !empty($cart['user']['delivery_country'])) { $delivery_country = $cart['user']['delivery_country']; } $tmp_countries = mslib_fe::getCountryByName($delivery_country); $countries_id = $tmp_countries['cn_iso_nr']; foreach ($shipping_methods as $code => $item) { $shipping_method = mslib_fe::getShippingMethod($item['id'], 's.id', $countries_id); // custom hook that can be controlled by third-party plugin $shipping_method_description = ''; if (!empty($item['description'])) { $shipping_method_description = '<div class="description">' . $item['description'] . '</div>'; } if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/front_pages/includes/checkout/multistep/checkout_shipping_payment_method']['checkoutMultistepShippingMethodSelectionHook'])) { $params = array('shipping_method' => &$shipping_method, 'item' => &$item, 'shipping_method_description' => &$shipping_method_description); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/front_pages/includes/checkout/multistep/checkout_shipping_payment_method']['checkoutMultistepShippingMethodSelectionHook'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } $count++; // costs $price_wrap = ''; $priceArray = mslib_fe::getShippingCosts($countries_id, $item['id']);
public function productFeedGeneratorGetShippingCosts($products, $countries_id, $shipping_method_id) { if (!is_array($products) && count($products)) { return false; } if (!is_numeric($countries_id)) { return false; } if (!is_numeric($shipping_method_id)) { return false; } $str3 = $GLOBALS['TYPO3_DB']->SELECTquery('sm.shipping_costs_type, sm.handling_costs, c.price, c.override_shippingcosts, c.zone_id', 'tx_multishop_shipping_methods sm, tx_multishop_shipping_methods_costs c, tx_multishop_countries_to_zones c2z', 'sm.id=c.shipping_method_id and c.zone_id=c2z.zone_id and c.shipping_method_id=\'' . $shipping_method_id . '\' and (sm.page_uid=0 or sm.page_uid=\'' . $this->shop_pid . '\') and c2z.cn_iso_nr=\'' . $countries_id . '\'', '', '', ''); $qry3 = $GLOBALS['TYPO3_DB']->sql_query($str3); if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry3)) { $row3 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry3); $shipping_method = mslib_fe::getShippingMethod($shipping_method_id, 's.id', $countries_id); //hook to let other plugins further manipulate the settings if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_fe.php']['productFeedGeneratorGetShippingCosts'])) { foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_fe.php']['productFeedGeneratorGetShippingCosts'] as $funcRef) { $params['row3'] =& $row3; $params['shipping_method'] =& $shipping_method; $params['countries_id'] =& $countries_id; \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } if ($row3['shipping_costs_type'] == 'weight') { $total_weight = $products['products_weight']; $steps = explode(",", $row3['price']); $current_price = ''; foreach ($steps as $step) { $cols = explode(":", $step); if (isset($cols[1])) { $current_price = $cols[1]; } if ($total_weight <= $cols[0]) { $current_price = $cols[1]; break; } } $shipping_cost = $current_price; $shipping_cost_method_box = $current_price; } elseif ($row3['shipping_costs_type'] == 'quantity') { $total_quantity = 1; $steps = explode(",", $row3['price']); $current_price = ''; foreach ($steps as $step) { $cols = explode(":", $step); if (isset($cols[1])) { $current_price = $cols[1]; } if ($total_quantity <= $cols[0]) { $current_price = $cols[1]; break; } } $shipping_cost = $current_price; $shipping_cost_method_box = $current_price; } else { if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_fe.php']['productFeedGeneratorGetShippingCostsCustomType'])) { foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_fe.php']['productFeedGeneratorGetShippingCostsCustomType'] as $funcRef) { $params['products'] =& $products; $params['row3'] =& $row3; $params['countries_id'] =& $countries_id; $params['shipping_method'] =& $shipping_method; $params['shipping_method_id'] =& $shipping_method_id; $params['shipping_cost'] =& $shipping_cost; $params['shipping_cost_method_box'] =& $shipping_cost_method_box; \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } else { $shipping_cost = $row3['price']; $shipping_cost_method_box = $row3['price']; } } // // calculate total costs $subtotal = $products['final_price']; if (strstr($subtotal, ",")) { $subtotal = str_replace(',', '.', $subtotal); } // if (!empty($row3['override_shippingcosts'])) { $old_shipping_costs = $shipping_cost; $shipping_cost = $row3['override_shippingcosts']; // custom code to change the shipping costs based on cart amount if (strstr($shipping_cost, ",") || strstr($shipping_cost, ":")) { $steps = explode(",", $shipping_cost); $count = 0; if (is_array($steps) && count($steps)) { foreach ($steps as $step) { // example: the value 200:15 means below 200 euro the shipping costs are 15 euro, above and equal 200 euro the shipping costs are 0 euro // example setting: 0:6.95,50:0 $split = explode(":", $step); if (is_numeric($split[0])) { if ($subtotal > $split[0] and isset($split[1])) { $shipping_cost = $split[1]; $shipping_cost_method_box = $split[1]; continue; } else { $shipping_cost = $old_shipping_costs; $shipping_cost_method_box = $old_shipping_costs; } } $count++; } } } } // custom code to change the shipping costs based on cart amount if (strstr($shipping_cost, ",") || strstr($shipping_cost, ":")) { $steps = explode(",", $shipping_cost); $count = 0; foreach ($steps as $step) { // example: the value 200:15 means below 200 euro the shipping costs are 15 euro, above and equal 200 euro the shipping costs are 0 euro // example setting: 0:6.95,50:0 $split = explode(":", $step); if (is_numeric($split[0])) { if ($count == 0) { if (isset($split[1])) { $shipping_cost = $split[1]; $shipping_cost_method_box = $split[1]; } else { $shipping_cost = $split[0]; $shipping_cost_method_box = $split[0]; continue; } } if ($subtotal > $split[0] and isset($split[1])) { $shipping_cost = $split[1]; $shipping_cost_method_box = $split[0]; continue; } } $count++; } } // custom code to change the shipping costs based on cart amount if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $shipping_cost = round($shipping_cost, 2); $shipping_cost_method_box = round($shipping_cost_method_box, 2); } // shipping costs only for shipping method box display if ($shipping_cost_method_box) { if ($shipping_method['tax_id'] && $shipping_cost_method_box) { $shipping_method_box_total_tax_rate = $shipping_method['tax_rate']; if ($shipping_method['country_tax_rate']) { $shipping_method_box_country_tax_rate = $shipping_method['country_tax_rate']; $shipping_method_box_country_tax = mslib_fe::taxDecimalCrop($shipping_cost_method_box * $shipping_method['country_tax_rate']); } else { $shipping_method_box_country_tax_rate = 0; $shipping_method_box_country_tax = 0; } if ($shipping_method['region_tax_rate']) { $shipping_method_box_region_tax_rate = $shipping_method['region_tax_rate']; $shipping_method_box_region_tax = mslib_fe::taxDecimalCrop($shipping_cost_method_box * $shipping_method['region_tax_rate']); } else { $shipping_method_box_region_tax_rate = 0; $shipping_method_box_region_tax = 0; } if ($shipping_method_box_region_tax && $shipping_method_box_country_tax) { $shipping_method_box_tax = $shipping_method_box_country_tax + $shipping_method_box_region_tax; } else { $shipping_method_box_tax = mslib_fe::taxDecimalCrop($shipping_cost_method_box * $shipping_method['tax_rate']); } } } if ($shipping_cost) { if ($shipping_method['tax_id'] && $shipping_cost) { $shipping_total_tax_rate = $shipping_method['tax_rate']; if ($shipping_method['country_tax_rate']) { $shipping_country_tax_rate = $shipping_method['country_tax_rate']; $shipping_country_tax = mslib_fe::taxDecimalCrop($shipping_cost * $shipping_method['country_tax_rate']); } else { $shipping_country_tax_rate = 0; $shipping_country_tax = 0; } if ($shipping_method['region_tax_rate']) { $shipping_region_tax_rate = $shipping_method['region_tax_rate']; $shipping_region_tax = mslib_fe::taxDecimalCrop($shipping_cost * $shipping_method['region_tax_rate']); } else { $shipping_region_tax_rate = 0; $shipping_region_tax = 0; } if ($shipping_region_tax && $shipping_country_tax) { $shipping_tax = $shipping_country_tax + $shipping_region_tax; } else { $shipping_tax = mslib_fe::taxDecimalCrop($shipping_cost * $shipping_method['tax_rate']); } } } $handling_cost = 0; $handling_tax = 0; if (!empty($row3['handling_costs'])) { $handling_cost = $row3['handling_costs']; if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $handling_cost = round($row3['handling_costs'], 2); } $percentage_handling_cost = false; if (strpos($handling_cost, '%') !== false) { $handling_cost = str_replace('%', '', $handling_cost); $percentage_handling_cost = true; } if ($percentage_handling_cost) { $tmp_handling_cost = $handling_cost; if ($products['tax_rate'] && $this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $products['final_price'] = $products['final_price'] * (1 + $products['tax_rate']); } $subtotal = $products['final_price']; if ($subtotal) { $handling_cost = $subtotal / 100 * $tmp_handling_cost; if ($total_include_vat && $shipping_method['tax_rate']) { $handling_cost = $handling_cost / (1 + $shipping_method['tax_rate']); } } } //var_dump($shipping_method['tax_rate']); //die(); if ($shipping_method['tax_id'] && $handling_cost) { $handling_total_tax_rate = $shipping_method['tax_rate']; if ($shipping_method['country_tax_rate']) { $handling_country_tax_rate = $shipping_method['country_tax_rate']; $handling_country_tax = mslib_fe::taxDecimalCrop($handling_cost * $shipping_method['country_tax_rate']); } else { $handling_country_tax_rate = 0; $handling_country_tax = 0; } if ($shipping_method['region_tax_rate']) { $handling_region_tax_rate = $shipping_method['region_tax_rate']; $handling_region_tax = mslib_fe::taxDecimalCrop($handling_cost * $shipping_method['region_tax_rate']); } else { $handling_region_tax_rate = 0; $handling_region_tax = 0; } if ($handling_region_tax && $handling_country_tax) { $handling_tax = $handling_country_tax + $handling_region_tax; } else { $handling_tax = mslib_fe::taxDecimalCrop($handling_cost * $shipping_method['tax_rate']); } } } $shipping_cost += $handling_cost; $shipping_tax += $handling_tax; $shipping_cost_method_box += $handling_cost; $shipping_method_box_tax += $handling_tax; $shipping_method['shipping_costs_method_box'] = $shipping_cost_method_box; $shipping_method['shipping_costs_method_box_including_vat'] = $shipping_cost_method_box + $shipping_method_box_tax; $shipping_method['shipping_costs'] = $shipping_cost; $shipping_method['shipping_costs_including_vat'] = $shipping_cost + $shipping_tax; return $shipping_method; } else { return false; } }
function repairOrder($orders_id) { if (is_numeric($orders_id)) { $this->conf['order_id'] = (int) $orders_id; $tax_separation = array(); $sql = "select orders_id, orders_tax_data, payment_method_costs, shipping_method_costs, discount, shipping_method, payment_method, billing_region, billing_country, billing_vat_id from tx_multishop_orders where orders_id='" . $orders_id . "' order by orders_id asc"; $qry = $GLOBALS['TYPO3_DB']->sql_query($sql); while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry)) { $sub_total_tax = 0; $sub_total = 0; $sub_total_excluding_vat = 0; $shipping_tax = 0; $payment_tax = 0; $grand_total = 0; $order_tax_data['shipping_tax'] = '0'; $order_tax_data['shipping_country_tax'] = '0'; $order_tax_data['shipping_region_tax'] = '0'; $order_tax_data['shipping_total_tax_rate'] = '0'; $order_tax_data['shipping_country_tax_rate'] = '0'; $order_tax_data['shipping_region_tax_rate'] = '0'; $order_tax_data['payment_tax'] = '0'; $order_tax_data['payment_country_tax'] = '0'; $order_tax_data['payment_region_tax'] = '0'; $order_tax_data['payment_total_tax_rate'] = '0'; $order_tax_data['payment_country_tax_rate'] = '0'; $order_tax_data['payment_region_tax_rate'] = '0'; $order_tax_data['grand_total'] = '0'; $order_tax_data['total_orders_tax'] = '0'; // get shipping method by code $this->tta_user_info['default']['country'] = $row['billing_country']; $iso_customer = mslib_fe::getCountryByName($this->tta_user_info['default']['country']); $iso_customer['country'] = $iso_customer['cn_short_en']; // if store country is different from customer country and user provided valid VAT id, change VAT rate to zero //$this->ms['MODULES']['DISABLE_VAT_RATE']=0; if (!$this->ms['MODULES']['DISABLE_VAT_RATE'] && $this->ms['MODULES']['DISABLE_VAT_FOR_FOREIGN_CUSTOMERS_WITH_COMPANY_VAT_ID'] and $row['billing_vat_id']) { if (strtolower($row['billing_country']) != strtolower($this->tta_shop_info['country'])) { $this->ms['MODULES']['DISABLE_VAT_RATE'] = 1; } } // get shipping tax rate $shipping_method = mslib_fe::getShippingMethod($row['shipping_method'], 's.code', $iso_customer['cn_iso_nr']); $tax_rate = mslib_fe::taxRuleSet($shipping_method['tax_id'], 0, $iso_customer['cn_iso_nr'], 0); if (!$tax_rate['total_tax_rate']) { $tax_rate['total_tax_rate'] = $this->ms['MODULES']['INCLUDE_VAT_OVER_METHOD_COSTS']; } if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $tax_rate['total_tax_rate'] = 0; } $shipping_tax_rate = $tax_rate['total_tax_rate'] / 100; // get payment tax rate $payment_method = mslib_fe::getPaymentMethod($row['payment_method'], 'p.code', $iso_customer['cn_iso_nr']); $tax_rate = mslib_fe::taxRuleSet($payment_method['tax_id'], 0, $iso_customer['cn_iso_nr'], 0); if (!$tax_rate['total_tax_rate']) { $tax_rate['total_tax_rate'] = $this->ms['MODULES']['INCLUDE_VAT_OVER_METHOD_COSTS']; } if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $tax_rate['total_tax_rate'] = 0; } $payment_tax_rate = $tax_rate['total_tax_rate'] / 100; if ($shipping_tax_rate > 0 or $payment_tax_rate > 0) { // disable rounding to prevent cents short issue $shipping_tax = $row['shipping_method_costs'] * $shipping_tax_rate; $payment_tax = $row['payment_method_costs'] * $payment_tax_rate; /*if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $shipping_tax=round($row['shipping_method_costs']*$shipping_tax_rate, 2); $payment_tax=round($row['payment_method_costs']*$payment_tax_rate, 2); } else { $shipping_tax=$row['shipping_method_costs']*$shipping_tax_rate; $payment_tax=$row['payment_method_costs']*$payment_tax_rate; }*/ $order_tax_data['shipping_total_tax_rate'] = (string) number_format($shipping_tax_rate, 2, '.', ','); $order_tax_data['payment_total_tax_rate'] = (string) number_format($payment_tax_rate, 2, '.', ','); $order_tax_data['shipping_tax'] = (string) $shipping_tax; $order_tax_data['payment_tax'] = (string) $payment_tax; //$total_tax+=$shipping_tax+$payment_tax; //$grand_total+=(($row['shipping_method_costs']+$row['payment_method_costs'])+($shipping_tax+$payment_tax)); } else { //$grand_total+=($row['shipping_method_costs']+$row['payment_method_costs']); } $tax_separation[$shipping_tax_rate * 100]['shipping_tax'] += $shipping_tax; $tax_separation[$payment_tax_rate * 100]['payment_tax'] += $payment_tax; $tax_separation[$shipping_tax_rate * 100]['shipping_costs'] = $row['shipping_method_costs']; $tax_separation[$payment_tax_rate * 100]['payment_costs'] = $row['payment_method_costs']; // $product_tax_data['country_tax_rate'] = '0'; $product_tax_data['region_tax_rate'] = '0'; $product_tax_data['total_tax_rate'] = '0'; $product_tax_data['country_tax'] = '0'; $product_tax_data['region_tax'] = '0'; $product_tax_data['total_tax'] = '0'; $product_tax_data['total_attributes_tax'] = '0'; $sql_prod = "select * from tx_multishop_orders_products where orders_id = " . $row['orders_id']; $qry_prod = $GLOBALS['TYPO3_DB']->sql_query($sql_prod); while ($row_prod = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry_prod)) { $tax_rate = $row_prod['products_tax'] / 100; $product_tax = unserialize($row_prod['products_tax_data']); // attributes tax $sql_attr = "select * from tx_multishop_orders_products_attributes where orders_products_id = " . $row_prod['orders_products_id'] . " and orders_id = " . $row_prod['orders_id']; $qry_attr = $GLOBALS['TYPO3_DB']->sql_query($sql_attr); $attributes_tax = 0; $tmp_attributes_price = 0; $tmp_attributes_tax = 0; while ($row_attr = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry_attr)) { if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { // remove the rounding to prevent cents short //$tmp_attributes_tax=round(($row_attr['price_prefix'].$row_attr['options_values_price'])*($tax_rate), 2); $tmp_attributes_tax = ($row_attr['price_prefix'] . $row_attr['options_values_price']) * $tax_rate; } else { $tmp_attributes_tax = mslib_fe::taxDecimalCrop(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $tax_rate); } $attributes_tax += $tmp_attributes_tax; $tmp_attributes_price += $row_attr['price_prefix'] . $row_attr['options_values_price'] * $row_prod['qty']; $sub_total += ($row_attr['price_prefix'] . $row_attr['options_values_price']) * $row_prod['qty']; $sub_total_excluding_vat += $row_attr['price_prefix'] . $row_attr['options_values_price'] * $row_prod['qty']; $grand_total += $row_attr['price_prefix'] . $row_attr['options_values_price'] * $row_prod['qty']; // set the attributes tax data $attributes_tax_data = array(); if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $attributes_tax_data['country_tax'] = round(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $product_tax['country_tax_rate'], 2); $attributes_tax_data['region_tax'] = round(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $product_tax['region_tax_rate'], 2); if ($attributes_tax_data['country_tax'] && $attributes_tax_data['region_tax']) { $attributes_tax_data['tax'] = $attributes_tax_data['country_tax'] + $attributes_tax_data['region_tax']; } else { $attributes_tax_data['tax'] = round(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $tax_rate, 2); } } else { $attributes_tax_data['country_tax'] = mslib_fe::taxDecimalCrop(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $product_tax['country_tax_rate']); $attributes_tax_data['region_tax'] = mslib_fe::taxDecimalCrop(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $product_tax['region_tax_rate']); if ($attributes_tax_data['country_tax'] && $attributes_tax_data['region_tax']) { $attributes_tax_data['tax'] = $attributes_tax_data['country_tax'] + $attributes_tax_data['region_tax']; } else { $attributes_tax_data['tax'] = mslib_fe::taxDecimalCrop(($row_attr['price_prefix'] . $row_attr['options_values_price']) * $tax_rate); } } $serial_product_attributes_tax = serialize($attributes_tax_data); $sql_update = "update tx_multishop_orders_products_attributes set attributes_tax_data = '" . $serial_product_attributes_tax . "' where orders_products_attributes_id='" . $row_attr['orders_products_attributes_id'] . "' and orders_products_id = " . $row_attr['orders_products_id'] . " and orders_id = " . $row_attr['orders_id']; $GLOBALS['TYPO3_DB']->sql_query($sql_update); } $sub_total_tax += $attributes_tax * $row_prod['qty']; $sub_total += $attributes_tax * $row_prod['qty']; // subtotal including vat $grand_total += $attributes_tax * $row_prod['qty']; $product_tax_data['total_attributes_tax'] = (string) $attributes_tax; $product_tax_data['total_tax_rate'] = (string) number_format($tax_rate, 2, '.', ','); $final_price = $row_prod['final_price']; /*if ($this->ms['MODULES']['ENABLE_DISCOUNT_ON_EDIT_ORDER_PRODUCT']) { if (!empty($row_prod['discount_amount'])) { $final_price-=$row_prod['discount_amount']; } }*/ //print_r($row_prod); // b2b mode 1 cent bugfix: 2013-05-09 cbc in grand total. this came from the products final price that must be round first // I have fixed the b2b issue by updating all the products prices in the database to have max 2 decimals // therefore I disabled below bugfix, cause thats a ducktape solution that can break b2c sites //$final_price=round($final_price,2); /* * the rounding for excluding vat price is causing cents short */ /*if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $tax=round($final_price*$tax_rate, 2); } else { $tax=$final_price*$tax_rate; } */ $tax = $final_price * $tax_rate; $product_tax_data['total_tax'] = (string) $tax; $sub_total_tax += $tax * $row_prod['qty']; $sub_total += ($final_price + $tax) * $row_prod['qty']; $sub_total_excluding_vat += $final_price * $row_prod['qty']; $grand_total += ($final_price + $tax) * $row_prod['qty']; $serial_prod = serialize($product_tax_data); $sql_update = "update tx_multishop_orders_products set products_tax_data = '" . $serial_prod . "' where orders_products_id = " . $row_prod['orders_products_id'] . " and orders_id = " . $row['orders_id']; $GLOBALS['TYPO3_DB']->sql_query($sql_update); // separation of tax $tax_separation[$row_prod['products_tax'] / 100 * 100]['products_total_tax'] += ($tax + $attributes_tax) * $row_prod['qty']; $tax_separation[$row_prod['products_tax'] / 100 * 100]['products_sub_total_excluding_vat'] += ($final_price + $tmp_attributes_price) * $row_prod['qty']; $tax_separation[$row_prod['products_tax'] / 100 * 100]['products_sub_total'] += $final_price + $tmp_attributes_price + ($tax + $attributes_tax) * $row_prod['qty']; } $order_tax_data['total_orders_tax_including_discount'] = $order_tax_data['total_orders_tax']; $order_tax_data['sub_total'] = (string) $sub_total; $order_tax_data['sub_total_excluding_vat'] = (string) $sub_total_excluding_vat; // discount //echo "<pre>"; //echo $sub_total."<br/>"; //echo $sub_total_excluding_vat."<br/>"; if ($row['discount'] < 0 || $row['discount'] > 0) { if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $discount_price = round($row['discount'], 2); //$sub_total_excluding_vat-=$discount_price; $discount_percentage = $discount_price / $sub_total_excluding_vat * 100; //$tmp_sub_total=(($sub_total_excluding_vat)/100*(100-$discount_percentage)); if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $sub_total_tax = round((1 - $discount_price / $sub_total) * $sub_total_tax, 2); } else { $sub_total_tax = ($sub_total - $sub_total_excluding_vat) / 100 * (100 - $discount_percentage); } } else { $discount_price = $row['discount']; //$sub_total-=$discount_price; $discount_percentage = $discount_price / $sub_total * 100; //$tmp_sub_total=(($sub_total)/100*(100-$discount_percentage)); // if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $sub_total_tax = round((1 - $discount_price / $sub_total) * $sub_total_tax, 2); } else { $sub_total_tax = ($sub_total - $sub_total_excluding_vat) / 100 * (100 - $discount_percentage); } } if (count($tax_separation) > 1) { $tax_separation = array(); } } //echo $discount_percentage."<br/>"; //echo $discount_price."<br/>"; //echo $sub_total_tax."<br/>"; //die(); $order_tax_data['total_orders_tax'] = (string) $sub_total_tax + $shipping_tax + $payment_tax; if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $order_tax_data['grand_total'] = (string) ($sub_total_excluding_vat - $discount_price + $sub_total_tax) + ($row['shipping_method_costs'] + $shipping_tax) + ($row['payment_method_costs'] + $payment_tax); } else { $order_tax_data['grand_total'] = (string) ($sub_total - $discount_price) + ($row['shipping_method_costs'] + $shipping_tax) + ($row['payment_method_costs'] + $payment_tax); } $order_tax_data['grand_total_excluding_vat'] = (string) ($sub_total_excluding_vat - $discount_price) + $row['shipping_method_costs'] + $row['payment_method_costs']; // $order_tax_data['tax_separation'] = $tax_separation; //print_r($order_tax_data); $serial_orders = serialize($order_tax_data); // update orders $updateArray = array(); $updateArray['grand_total'] = round($order_tax_data['grand_total'], 2); $updateArray['grand_total_excluding_vat'] = round($order_tax_data['grand_total_excluding_vat'], 2); $updateArray['orders_tax_data'] = $serial_orders; if ($row['discount'] > 0) { $updateArray['discount'] = $discount_price; } $updateArray['orders_last_modified'] = time(); $query = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_orders', 'orders_id=\'' . $row['orders_id'] . '\'', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); //$sql_update="update tx_multishop_orders set grand_total='".round($order_tax_data['grand_total'], 2)."', orders_tax_data = '".$serial_orders."' where orders_id = ".$row['orders_id']; //$GLOBALS['TYPO3_DB']->sql_query($sql_update); } } }
<div class="radio radio-success radio-inline input_label_wrapper"><input type="radio" name="enable_on_default" value="0" id="enable_on_default_no" /><label for="enable_on_default_no">' . $this->pi_getLL('no') . '</label></div> </div> </div> <div class="form-group"> <div class="col-md-10 col-md-offset-2"> <input name="shipping_method_code" type="hidden" value="' . htmlspecialchars($this->get['shipping_method_code']) . '" /> <input name="sub" type="hidden" value="add_shipping_method" /> <button name="Submit" class="btn btn-success" type="submit" value=""><i class="fa fa-save"></i> ' . $this->pi_getLL('save') . '</button> </div> </div> </form>'; $content .= mslib_fe::returnBoxedHTML($shipping_method['name'], $tmpcontent); $tmpcontent = ''; } } elseif ($this->get['edit']) { $row = mslib_fe::getShippingMethod($this->get['shipping_method_id'], 's.id'); $str = "SELECT * from tx_multishop_shipping_methods_description where id='" . $row['id'] . "'"; $qry = $GLOBALS['TYPO3_DB']->sql_query($str); $lngproduct = array(); while (($tmprow = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry)) != false) { $lngproduct[$tmprow['language_id']] = $tmprow; } $psp = $shipping_methods[$row['provider']]; $inner_content = mslib_fe::parseShippingMethodEditForm($psp, unserialize($row['vars']), 1); $tmpcontent .= ' <div class="panel panel-default"> <div class="panel-body"> <form id="add_payment_form" class="form-horizontal" action="' . mslib_fe::typolink($this->shop_pid . ',2003', '&tx_multishop_pi1[page_section]=' . $this->ms['page']) . '" method="post"> <input name="sub" type="hidden" value="update_shipping_method" /> <input name="shipping_method_id" type="hidden" value="' . $row['id'] . '" />'; foreach ($this->languages as $key => $language) {
$insertArray['status'] = 1; $insertArray['provider'] = 'cod'; $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_shipping_methods', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); $id = $GLOBALS['TYPO3_DB']->sql_insert_id(); if ($id) { $updateArray = array(); $updateArray['name'] = $record['shipping_method']; $updateArray['description'] = ''; $updateArray['id'] = $id; $updateArray['language_id'] = 0; $updateArray = mslib_befe::rmNullValuedKeys($updateArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_shipping_methods_description', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); $shipping_method = mslib_fe::getShippingMethod($record['shipping_method'], 'd.name'); } } $row['shipping_method'] = $shipping_method['code']; $row['shipping_method_label'] = $shipping_method['name']; } // $row['billing_name']=$record['last_modified']; $row['crdate'] = strtotime($record['date_purchased']); if ($record['shipping_cost']) { // calculate price excluding vat $record['shipping_cost'] = $record['shipping_cost'] / (100 + $this->ms['MODULES']['INCLUDE_VAT_OVER_METHOD_COSTS']) * 100; $row['shipping_method_costs'] = $record['shipping_cost']; } if ($record['payment_cost']) { // calculate price excluding vat $record['payment_cost'] = $record['payment_cost'] / (100 + $this->ms['MODULES']['INCLUDE_VAT_OVER_METHOD_COSTS']) * 100;
$tmpcontent .= '</tbody>'; } } } //echo '<pre>'; //print_r($order_products_table); //die(); // $tmpcontent.='<tr><td colspan="'.$colspan.'"><hr class="hr"></td></tr>'; $orders_tax_data = unserialize($orders['orders_tax_data']); $tmpcontent .= '<tfoot><tr><td colspan="' . $colspan . '" class="order_total_data text-right">'; if ($this->ms['MODULES']['ORDER_EDIT'] and $settings['enable_edit_orders_details']) { $iso_customer = mslib_fe::getCountryByName($orders['billing_country']); $iso_customer['country'] = $iso_customer['cn_short_en']; // $payment_method = mslib_fe::getPaymentMethod($orders['payment_method'], 'p.code', $iso_customer['cn_iso_nr']); $shipping_method = mslib_fe::getShippingMethod($orders['shipping_method'], 's.code', $iso_customer['cn_iso_nr']); // if ($iso_customer['cn_iso_nr'] > 0) { $payment_tax_ruleset = mslib_fe::taxRuleSet($payment_method['tax_id'], 0, $iso_customer['cn_iso_nr'], 0); $shipping_tax_ruleset = mslib_fe::taxRuleSet($shipping_method['tax_id'], 0, $iso_customer['cn_iso_nr'], 0); if (!$payment_tax_ruleset) { $payment_method['tax_id'] = 0; } if (!$shipping_tax_ruleset) { $shipping_method['tax_id'] = 0; } } if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $shipping_costs = '<div class="input-group pull-right" style="width:140px;"> <span class="input-group-addon">' . mslib_fe::currency() . '</span> <input name="tx_multishop_pi1[shipping_method_costs]" id="shipping_method_costs" type="text" class="form-control text-right priceInputDisplay" value="' . number_format($orders['shipping_method_costs'] + $orders_tax_data['shipping_tax'], 4, $this->ms['MODULES']['CUSTOMER_CURRENCY_ARRAY']['cu_decimal_point'], '') . '" class="align_right" />