$inp_price = $sa_price + $sp_price;
$final_price = $inp_price * $_POST['qTY'];
$sql_data_array = array('products_price' => olc_db_prepare_input($inp_price));
$update_sql_data = array('final_price' => olc_db_prepare_input($final_price));
$sql_data_array = olc_array_merge($sql_data_array, $update_sql_data);
olc_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array, 'update', 'orders_products_id = \'' . olc_db_input($_POST['opID']) . '\'');
olc_redirect(olc_href_link(FILENAME_ORDERS_EDIT, 'edit_action=options&oID=' . $_POST['oID'] . '&cID=' . $_POST['cID'] . '&pID=' . $_POST['pID'] . '&pTX=' . $_POST['pTX'] . '&aTX=' . $_POST['aTX'] . '&qTY=' . $_POST['qTY'] . '&opID=' . $_POST['opID']));
}
// Produkt Optionen bearbeiten Ende
// Produkt Optionen Einfügen Anfang
if ($_GET['action'] == "product_option_ins") {
$allow_tax = $_POST['aTX'];
$customers_status = olc_oe_get_customers_status($_POST['cID']);
$products_attributes_query = olc_db_query("select\n products_attributes_id,\n products_id,\n options_id,\n options_values_id,\n options_values_price,\n price_prefix,\n attributes_model,\n attributes_stock,\n options_values_weight,\n weight_prefix,\n sortorder\n from\n " . TABLE_PRODUCTS_ATTRIBUTES . "\n where\n products_attributes_id = '" . $_POST['aID'] . APOS);
$products_attributes = olc_db_fetch_array($products_attributes_query);
$products_options = olc_oe_get_options_name($products_attributes['options_id']);
$products_options_values = olc_oe_get_options_values_name($products_attributes['options_values_id']);
$sql_data_array = array('orders_id' => olc_db_prepare_input($_POST['oID']), 'orders_products_id' => olc_db_prepare_input($_POST['opID']), 'products_options' => olc_db_prepare_input($products_options), 'products_options_values' => olc_db_prepare_input($products_options_values), 'options_values_price' => olc_db_prepare_input($products_attributes['options_values_price']));
$insert_sql_data = array('price_prefix' => olc_db_prepare_input($products_attributes['price_prefix']));
$sql_data_array = olc_array_merge($sql_data_array, $insert_sql_data);
olc_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array);
$products_query = olc_db_query("select products_id, products_price, products_tax_class_id from " . TABLE_PRODUCTS . " where products_id = '" . $_POST['pID'] . APOS);
$products = olc_db_fetch_array($products_query);
$products_a_query = olc_db_query("select options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . $_POST['oID'] . "' and orders_products_id = '" . $_POST['opID'] . APOS);
while ($products_a = olc_db_fetch_array($products_a_query)) {
$total_price += $products_a['price_prefix'] . $products_a['options_values_price'];
}
$sa_price = olc_oe_get_products_attribute_price($total_price, $products['products_tax_class_id'], $price_special = '0', 1, $_POST['prefix'], $calculate_currencies = TRUE_STRING_S, $customers_status);
$sp_price = olc_oe_products_price($_POST['pID'], $price_special = '0', 1, $customers_status);
$inp_price = $sa_price + $sp_price;
$final_price = $inp_price * $_POST['qTY'];
echo olc_draw_hidden_field('qTY', $_GET['qTY']);
echo olc_draw_hidden_field('opID', $_GET['opID']);
echo olc_draw_hidden_field('aID', $products['products_attributes_id']);
$brutto = PRICE_IS_BRUTTO;
if ($brutto == TRUE_STRING_S) {
$options_values_price = olc_round($products['options_values_price'] * (1 + $_GET['pTX'] / 100), PRICE_PRECISION);
} else {
$options_values_price = olc_round($products['options_values_price'], PRICE_PRECISION);
}
?>
<td class="dataTableContent"><?php
echo $products['products_attributes_id'];
?>
</td>
<td class="dataTableContent"><?php
echo olc_oe_get_options_name($products['options_id']);
?>
</td>
<td class="dataTableContent"><?php
echo olc_oe_get_options_values_name($products['options_values_id']);
?>
</td>
<td class="dataTableContent">
<?php
echo olc_draw_hidden_field('options_values_price', $products['options_values_price']);
echo $options_values_price;
?>
</td>
<td class="dataTableContent">
<?php
echo olc_image_submit('button_insert.gif', TEXT_EDIT, 'style="cursor:hand" ');