foreach ($_cart_opt_2['data'] as $key => $value) {
if ($key && $_SESSION[CART_KEY]['options2'][$prod_id][$opt1_id][$opt2_id] == $key) {
$value = get_shop_option_value($value);
$value_opt2_float = $value[1];
$opt2_txt = $value[0] . $value['option'];
$opt2_numbr = $value[2];
}
}
}
//add option's prize to normal prize
$row['shopprod_price'] = $row_shopprod_price + $value_opt1_float + $value_opt2_float;
//add option to article order number
$row['shopprod_ordernumber'] = $row_shopprod_numbr . $opt1_numbr . $opt2_numbr;
$total[$prod_id]['quantity'] = $_SESSION[CART_KEY]['products'][$prod_id][$opt1_id][$opt2_id];
$total[$prod_id]['vat'] = (double) $row['shopprod_vat'];
$total[$prod_id]['vat_decimals'] = dec_num_count($total[$prod_id]['vat']);
if ($total[$prod_id]['vat_decimals'] < $_tmpl['config']['vat_decimals']) {
$total[$prod_id]['vat_decimals'] = $_tmpl['config']['vat_decimals'];
}
if ($row['shopprod_netgross'] == 1) {
// price given is GROSS price, including VAT
$total[$prod_id]['net'] = $row['shopprod_price'] / (1 + $row['shopprod_vat'] / 100);
$total[$prod_id]['gross'] = $row['shopprod_price'];
} else {
// price given is NET price, excluding VAT
$total[$prod_id]['net'] = $row['shopprod_price'];
$total[$prod_id]['gross'] = $row['shopprod_price'] * (1 + $row['shopprod_vat'] / 100);
}
$subtotal['net'] += $total[$prod_id]['quantity'] * $total[$prod_id]['net'];
$subtotal['vat'] += $total[$prod_id]['quantity'] * ($total[$prod_id]['gross'] - $total[$prod_id]['net']);
$subtotal['gross'] += $total[$prod_id]['quantity'] * $total[$prod_id]['gross'];
}
// FE language
$sql .= SHOP_FELANG_SQL;
$_tmpl['config']['cat_list_sort_by'] = trim($_tmpl['config']['cat_list_sort_by']);
if ($_tmpl['config']['cat_list_sort_by'] !== '') {
$sql .= ' ORDER BY ' . aporeplace($_tmpl['config']['cat_list_sort_by']);
}
$data = _dbQuery($sql);
if (isset($data[0])) {
$x = 0;
$entry = array();
$shop_prod_detail = rel_url(array(), array('shop_detail'));
$_tmpl['config']['init_lightbox'] = false;
foreach ($data as $row) {
$row['vat'] = (double) $row['shopprod_vat'];
$row['vat_decimals'] = dec_num_count($row['vat']);
if ($row['vat_decimals'] < $_tmpl['config']['vat_decimals']) {
$row['vat_decimals'] = $_tmpl['config']['vat_decimals'];
}
if ($row['shopprod_netgross'] == 1) {
// price given is GROSS price, including VAT
$row['net'] = $row['shopprod_price'] / (1 + $row['vat'] / 100);
$row['gross'] = $row['shopprod_price'];
} else {
// price given is NET price, excluding VAT
$row['net'] = $row['shopprod_price'];
$row['gross'] = $row['shopprod_price'] * (1 + $row['vat'] / 100);
}
$row['vat'] = number_format($row['vat'], $row['vat_decimals'], $_tmpl['config']['dec_point'], $_tmpl['config']['thousands_sep']);
$row['net'] = number_format($row['net'], $_tmpl['config']['price_decimals'], $_tmpl['config']['dec_point'], $_tmpl['config']['thousands_sep']);
$row['gross'] = number_format($row['gross'], $_tmpl['config']['price_decimals'], $_tmpl['config']['dec_point'], $_tmpl['config']['thousands_sep']);
