real_escape_string(strip_tags($_REQUEST['deleted_cart_item']))); $ab -> query($query); header("Location: /kosaram"); } if(isset($_POST['name'])) { $cookie_name = "order_id"; $cookie_value = "false"; setcookie($cookie_name, $cookie_value, time() - 3600, '/'); $order_uniqid = ($ab -> real_escape_string(strip_tags($_COOKIE['order_id']))); $query = "INSERT INTO `form_orders` VALUES(NULL, '".$order_uniqid."', '_id', '".$order_uniqid."')"; $ab -> query($query); $query = "INSERT INTO `form_orders` VALUES(NULL, '".$order_uniqid."', 'timestamp', CURRENT_TIMESTAMP)"; $ab -> query($query); foreach($_POST as $opt_key => $opt_val) { $query = "INSERT INTO `form_orders` VALUES(NULL, '".$order_uniqid."', '".($ab->real_escape_string(strip_tags($opt_key)))."', '".($ab->real_escape_string(strip_tags($opt_val)))."')"; $ab -> query($query); } $message = "
Rendelés státusza - feldolgozás alatt (A pontos kiszállítás időpontjáról e-mail értesítést küldünk)

A rendelését a következő adatokkal vettük fel:

"; $message.= "
Név: "; $message.= $_POST["name"]; $message.= "
Számlázási cím: "; $message.= $_POST["address_zip"]." ".$_POST["address_city"].", ".$_POST["address_street"]; $message.= "
Szállítási cím: "; $message.= (($_POST["invoice_address_zip"] != '')?($_POST["invoice_address_zip"]." ".$_POST["invoice_address_city"].", ".$_POST["invoice_address_street"]):($_POST["address_zip"]." ".$_POST["address_city"].", ".$_POST["address_street"])); $message.= "
Telefonszám: "; $message.= $_POST["phone"]; $message.= "
E-mail cím: "; $message.= $_POST["mail"]; $message.= "
Megjegyzés: "; $message.= $_POST["message"]; $message.= "



"; $message.= ""; $sum_price = 0; $sum_weight = 0; $query = "SELECT * FROM `form_order_carts` WHERE `order_id` = '".$order_uniqid."'"; $result = $ab -> query($query); while($cart_data = $result -> fetch_assoc()) { $item_query = "SELECT * FROM `cms_items` WHERE `item_id` = '".$cart_data['item_id']."'"; $item_result = $ab -> query($item_query); while($item_details = $item_result -> fetch_assoc()) { $item_data[$item_details['option_name']] = $item_details['option_value']; } $item_query = "SELECT * FROM `cms_item_prices` WHERE `item_id` = '".$cart_data['item_id']."' ORDER BY `min_qty` ASC"; $item_result = $ab -> query($item_query); $price_buffer = 0; while($item_details = $item_result -> fetch_assoc()) { $item_price[$price_buffer]['min_qty'] = $item_details['min_qty']; $item_price[$price_buffer]['price'] = $item_details['price']; $price_buffer++; } $price_check_buffer = 0; while(($price_check_buffer < $price_buffer) && ($item_price[$price_check_buffer]['min_qty'] <= $cart_data['item_qty'])) { $actual_price = $item_price[$price_check_buffer]['price']; $price_check_buffer++; } $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $sum_price = $sum_price + $cart_data['item_qty']*$actual_price; $sum_weight = $sum_weight + $item_data['item_weight']*$cart_data['item_qty']/$item_data['item_package_qty']; } $shipping_price = "Nem elérhető"; $shipping_price_vat = "Nem elérhető"; $shipping_price_int = 0; if($_POST['shipping_type'] != 'personal') { $shipping_method = (($_POST['shipping_type'] == 'dpd')?('_shipping_dpd'):('_shipping_custom')); $shipping_method_name = (($_POST['shipping_type'] == 'dpd')?('Kiszállítás DPD-vel (Magyarország)'):('Kiszállítás saját futárral (Budapest)')); $item_query = "SELECT * FROM `cms_item_prices` WHERE `item_id` = '".$shipping_method."' AND ".$sum_weight." < `min_qty` ORDER BY `min_qty` ASC LIMIT 1"; $item_result = $ab -> query($item_query); while($item_details = $item_result -> fetch_assoc()) { $shipping_price = number_format($item_details['price'], 0, '', '.')." Ft"; $shipping_price_vat = number_format($item_details['price']*1.27, 0, '', '.')." Ft"; $shipping_price_int = $item_details['price']; } } else { $shipping_price = "Ingyenes"; $shipping_price_vat = "Ingyenes"; $shipping_method_name = "Személyes átvétel"; } $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message.= ""; $message = wordwrap($message, 70); $from ="From: Best3alga rendszer <".$_POST['mail'].">" . "\r\n"; $from.="Content-Type: text/html; charset=utf-8\n"; $from.="Content-Disposition: inline\n"; $from.="Content-Transfer-Encoding: 8bit\n"; mail($global_options['contact_email'], "Rendelés érkezett", $message, $from); $from ="From: Best3alga rendszer <".$global_options['contact_email'].">" . "\r\n"; $from.="Content-Type: text/html; charset=utf-8\n"; $from.="Content-Disposition: inline\n"; $from.="Content-Transfer-Encoding: 8bit\n"; mail($_POST['mail'], "Rendelés visszaigazolás", $message, $from); } ?>
real_escape_string(strip_tags($_COOKIE['order_id'])))."'"; $result = $ab -> query($query); if($result -> num_rows !== 0) { echo "
Megrendelt tételek
Megrendelt termék:Nettó ár:Mennyiség:Nettó:Bruttó:
".$item_data['item_name']."".number_format($actual_price, 2, ',', '.')." Ft".number_format($cart_data['item_qty'], 0, '', '.')." db".number_format($cart_data['item_qty']*$actual_price, 0, '', '.')." Ft".number_format($cart_data['item_qty']*$actual_price*1.27, 0, '', '.')." Ft
Szállítási költség - ".$shipping_method_name."".$shipping_price."".$shipping_price_vat."
Összesen".number_format($sum_price+$shipping_price_int, 0, '', '.')." Ft".number_format(($sum_price+$shipping_price_int)*1.27, 0, '', '.')." Ft
"; $sum_price = 0; $sum_weight = 0; while($cart_data = $result -> fetch_assoc()) { $item_query = "SELECT * FROM `cms_items` WHERE `item_id` = '".$cart_data['item_id']."'"; $item_result = $ab -> query($item_query); while($item_details = $item_result -> fetch_assoc()) { $item_data[$item_details['option_name']] = $item_details['option_value']; } $item_query = "SELECT * FROM `cms_item_prices` WHERE `item_id` = '".$cart_data['item_id']."' ORDER BY `min_qty` ASC"; $item_result = $ab -> query($item_query); $price_buffer = 0; while($item_details = $item_result -> fetch_assoc()) { $item_price[$price_buffer]['min_qty'] = $item_details['min_qty']; $item_price[$price_buffer]['price'] = $item_details['price']; $price_buffer++; } $price_check_buffer = 0; while(($price_check_buffer < $price_buffer) && ($item_price[$price_check_buffer]['min_qty'] <= $cart_data['item_qty'])) { $actual_price = $item_price[$price_check_buffer]['price']; $price_check_buffer++; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $sum_price = $sum_price + $cart_data['item_qty']*$actual_price; $sum_weight = $sum_weight + $item_data['item_weight']*$cart_data['item_qty']/$item_data['item_package_qty']; $shipping_price_custom = "Nem elérhető"; $shipping_price_dpd = "Nem elérhető"; $item_query = "SELECT * FROM `cms_item_prices` WHERE `item_id` = '_shipping_custom' AND ".$sum_weight." < `min_qty` ORDER BY `min_qty` ASC LIMIT 1"; $item_result = $ab -> query($item_query); while($item_details = $item_result -> fetch_assoc()) { $shipping_price_custom = number_format($item_details['price'], 0, '', '.')." Ft"; $shipping_price_custom_int = $item_details['price']; } $item_query = "SELECT * FROM `cms_item_prices` WHERE `item_id` = '_shipping_dpd' AND ".$sum_weight." < `min_qty` ORDER BY `min_qty` ASC LIMIT 1"; $item_result = $ab -> query($item_query); while($item_details = $item_result -> fetch_assoc()) { $shipping_price_dpd = ($item_details['price'] > 0 ) ? (number_format($item_details['price'], 0, '', '.')." Ft") : ("Ingyenes"); $shipping_price_dpd_int = $item_details['price']; } } echo "

".$item_data['item_name']."

Termékeink > ".$item_data['item_name']."

".number_format($cart_data['item_qty'], 0, '', '.')." dbÖsszesen:
".number_format($cart_data['item_qty']*$actual_price, 0, '', '.')." Ft
Súly:
".number_format($item_data['item_weight']*$cart_data['item_qty']/$item_data['item_package_qty'], 2, ',', '.')." kg

"; ?>
Szállítási költség
Kiszállítás futárral (Magyarország területére)

Fizetési mód
Banki átutalásIngyenes
Kártyás fizetéss (Paylike) Ingyenes

Kupon felhasználása
Kupon kedvezmény0 Ft

Megrendelt tételek
"; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

Összesen fizetendő:

Nettó ár:
".number_format($sum_price, 0, '', '.')." Ft
Bruttó ár:
".number_format($sum_price*1.27, 0, '', '.')." Ft
Súly:
".number_format($sum_weight, 2, ',', '.')." kg
Megrendelő neve:
Számlázási cím:
Szállítási cím (ha nem azonos a számlázási címmel):
E-mail cím:
Telefonszám:
Megjegyzés:
 
  A rendelés elküldésével tudomásul veszem és elfogadom az Általános Szerződési Feltételekben valamint az Adatkezelési Tájékoztatóban foglaltakat.
 

Kedves !

Köszönjük megrendelését! Kollégáink igyekeznek összekészíteni a megrendelt termékeket. A megrendeléséről rendszerünk azonnal visszaigazolást küld a megadott e-mail címre.

Köszönettel,
INITIUMLUX Kft.