<?php
session_start();
error_reporting(0);
include("../config/database.php");
$orderDate = date('Y-m-d');
$name = mysqli_real_escape_string($cn,$_POST['name']);
$mobile = mysqli_real_escape_string($cn,$_POST['mobile']);
$email = mysqli_real_escape_string($cn,$_POST['email']);
$notes = mysqli_real_escape_string($cn,$_POST['notes']);//mysqli_real_escape_string($cn,$_POST['address']);
$address = "";//mysqli_real_escape_string($cn,$_POST['address']);
$country = mysqli_real_escape_string($cn,$_POST['country']);
$city = mysqli_real_escape_string($cn,$_POST['city']);
$landmark = "";//mysqli_real_escape_string($cn,$_POST['landmark']);
$alt_mobile = "";//mysqli_real_escape_string($cn,$_POST['alt_mobile']);
$orderId = 1;
$sqlReg = mysqli_query($cn, "select max(order_id) from `tbl_order`");
if(mysqli_num_rows($sqlReg)>0)
{
$sqlRegData = mysqli_fetch_array($sqlReg);
$orderId = $sqlRegData['max(order_id)']+1;
}
if(isset($_SESSION['kxproductList']) && count($_SESSION['kxproductList'])>0)
{
$subTotal = 0; $deliveryCharges = 0; $orderTotal = 0; $loop = 0;
$loop = 0;
foreach($_SESSION['kxproductList'] as $pL)
{
$remark = ""; $sizeId = ""; $polishId = "";
$sqlProductCart = mysqli_query($cn,"select * from `tbl_product` where `id`='".$pL['productId']."'");
$sqlProductCartData = mysqli_fetch_array($sqlProductCart);
if(isset($_SESSION['adInfo'])){ $remark = $_SESSION['adInfo'][$loop];}
if(!empty($pL['sizeId'])){
$sizeId = sizeName($pL['sizeId']);
}
if(!empty($pL['polishId'])){
$polishId = polishName($pL['polishId']);
}
$sqlOrder = mysqli_query($cn, "INSERT INTO `tbl_order` SET `order_date`='".$orderDate."', `order_id`='".$orderId."', `customer_id`=' ', `product_id`='".$pL['productId']."', `size`='".$sizeId."', `polish`='".$polishId."', `product_name`='".$sqlProductCartData['name']."', `price`=0, `qty`='".$pL['qty']."', `total`=0, `delivery_charge`=0, `order_total`=0, `remark`='".$remark."', `notes`='".$notes."', `discount_amount`=0, `status`=0, `name`='".$name."', `phone`='".$mobile."', `email`='".$email."', `address`='".$address."', `country`='".$country."', `city`='".$city."', `landmark`='".$landmark."', `alternate_mobile`='".$alt_mobile."', `date`=Now()");
}
$arr = array('status'=>true, 'orderId'=>$orderId);
unset($_SESSION['kxproductList']);
unset($_SESSION['adInfo']);
}
else
{
$_SESSION['placeError'] = "Somthing Went Wrong Try Again.";
$arr = array('status'=>false);
}
echo json_encode($arr);
?>