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']);