//EOF Web28 - 2010-12-06 - read customer status earlier
// Errechne neue Zwischensumme für Artikel Anfang
$products_query = xtc_db_query("select SUM(final_price) as subtotal_final from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int) $_POST['oID'] . "' ");
$products = xtc_db_fetch_array($products_query);
$subtotal_final = $products['subtotal_final'];
$subtotal_text = $xtPrice->xtcFormat($subtotal_final, true);
xtc_db_query("update " . TABLE_ORDERS_TOTAL . " set text = '" . $subtotal_text . "', value = '" . $subtotal_final . "' where orders_id = '" . (int) $_POST['oID'] . "' and class = 'ot_subtotal' ");
// Errechne neue Zwischensumme für Artikel Ende
//BOF####### Produkte #######//
$products_query = xtc_db_query("select final_price, products_tax, allow_tax from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int) $_POST['oID'] . "' ");
while ($products = xtc_db_fetch_array($products_query)) {
$tax_rate = $products['products_tax'];
if ($products['allow_tax'] == '1') {
$bprice = $products['final_price'];
$nprice = $xtPrice->xtcRemoveTax($bprice, $tax_rate);
$tax = $xtPrice->calcTax($nprice, $tax_rate);
} else {
$nprice = $products['final_price'];
$bprice = $xtPrice->xtcAddTax($nprice, $tax_rate);
$tax = $xtPrice->calcTax($nprice, $tax_rate);
}
$sql_data_array = array('orders_id' => (int) $_POST['oID'], 'n_price' => xtc_db_prepare_input($nprice), 'b_price' => xtc_db_prepare_input($bprice), 'tax' => xtc_db_prepare_input($tax), 'tax_rate' => xtc_db_prepare_input($products['products_tax']));
$insert_sql_data = array('class' => 'products');
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_ORDERS_RECALCULATE, $sql_data_array);
}
//EOF####### Produkte #######//
//BOF####### Produkte Steuersätze #######//
$tax_query = xtc_db_query("SELECT tax_rate, SUM(tax) as tax_value\n FROM " . TABLE_ORDERS_RECALCULATE . "\n WHERE orders_id = '" . (int) $_POST['oID'] . "'\n AND class = 'products'\n GROUP BY tax_rate\n ");
while ($tax = xtc_db_fetch_array($tax_query)) {
$sql_data_array = array('orders_id' => (int) $_POST['oID'], 'tax' => xtc_db_prepare_input($tax['tax_value']), 'tax_rate' => xtc_db_prepare_input($tax['tax_rate']), 'class' => 'ot_tax');
