<?php
session_start();
require 'db.connect.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$addr = nl2br($_POST['cust_address']);
$cust_address =  mysqli_real_escape_string($conn, $addr);
$cust_name =  mysqli_real_escape_string($conn, $_POST['cust_name']);
$cust_phone =  mysqli_real_escape_string($conn, $_POST['cust_phone']);
$cust_country =  mysqli_real_escape_string($conn, $_POST['cust_country']);
$cust_state =  mysqli_real_escape_string($conn, $_POST['cust_state']);
// $cust_pin =  mysqli_real_escape_string($conn, $_POST['cust_pin']);
$gst_no =  mysqli_real_escape_string($conn, $_POST['gst_no']);
$cust_discount =  mysqli_real_escape_string($conn, $_POST['cust_discount']);
$date = mysqli_real_escape_string($conn, $_POST['my_date']);
$mod = date('H:i:s');
$my_date= $date.' '.$mod;
if($cust_country!=99){
    $cust_state = NULL;
}
$get_prod = mysqli_query($conn, "select * from tbl_dealer_sales_temp where dealer_id = '".$_SESSION['dealer_id']."'");
$check_rows = mysqli_num_rows($get_prod);
if($check_rows <= 0){
    $msg = array('icon'=>'error', 'title'=>'Error', 'text'=>'Cart empty, you cant place the order', 'status'=>1);
    echo json_encode($msg);
    exit;
}else{
    $check_bill = mysqli_query($conn, "select * from tbl_dealer_order where dealer_id = '".$_SESSION['dealer_id']."'");
    $num_rows = mysqli_num_rows($check_bill);
    $bill_id = $num_rows + 1;
   $create_main = "INSERT INTO tbl_dealer_order
    (dealer_id, bill_id, cust_name, cust_phone, cust_address, cust_country, cust_state, gst_no, cust_discount, created_at, updated_at, order_status)
    VALUES('".$_SESSION['dealer_id']."', '$bill_id', '$cust_name ', '$cust_phone', '$cust_address','$cust_country', '$cust_state', '$gst_no', '$cust_discount', '$my_date', '$my_date', '0');";
   if(mysqli_query($conn, $create_main)){
    $pkey = mysqli_insert_id($conn);

    $get_temp = mysqli_query($conn, "select * from tbl_dealer_sales_temp where dealer_id = '".$_SESSION['dealer_id']."'");
   //insert purchased products
    while($set_temp = mysqli_fetch_array($get_temp, MYSQLI_ASSOC)){

        $insert_sales = "INSERT INTO tbl_dealer_sales
        (dealer_id, pkey, bill_id, prod_id, price, qty, created_at, updated_at)
        VALUES('".$_SESSION['dealer_id']."', '$pkey', '$bill_id', '".$set_temp['prod_id']."', '".$set_temp['price']."', '".$set_temp['qty']."', '$my_date', '$my_date');";
        mysqli_query($conn, $insert_sales);
    }
    //delete cart
    $temp_delete = "delete from tbl_dealer_sales_temp where dealer_id='".$_SESSION['dealer_id']."'";
    mysqli_query($conn, $temp_delete);
    mysqli_close($conn);
    $msg = array('icon'=>'success', 'title'=>'Success', 'text'=>'Bill Created Successfully', 'status'=>2);
    echo json_encode($msg);
  
    exit;
    }else{
        mysqli_close($conn);
        $msg = array('icon'=>'error', 'title'=>'Error', 'text'=>'Record Not Inserted, Contact Admin', 'status'=>3);
        echo json_encode($msg);
        exit;  
    }
  
}
?>