<?php
session_start();
require 'db.connect.php';
require 'send_mail.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
$date = date('Y-m-d H:i:s');
$dealer_id = $_SESSION['dealer_id'];

$get_dealer = mysqli_query($conn, "SELECT * FROM shop_user where user_id='$dealer_id'");
$set_dealer = mysqli_fetch_assoc($get_dealer);

$insert_main = "INSERT INTO tbl_dealer_ef_main
(dealer_id, order_date_time, payment_mode, company_code, order_status)
VALUES('$dealer_id', '$date', 'Cash', '2', '0');";
if(mysqli_query($conn, $insert_main)){
    $last = mysqli_insert_id($conn);
     $ref_no='DE'.str_pad($last, 4, "0", STR_PAD_LEFT);
    $get_ord = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_temp where dealer_id='$dealer_id'");
    while($set_ord = mysqli_fetch_assoc($get_ord)){
$get_v = mysqli_query($conn, "SELECT * FROM shop_product where product_id = '".$set_ord['prod_id']."'");
$set_v = mysqli_fetch_assoc($get_v);

        $insert_sub = "INSERT INTO drganbug_medine.tbl_dealer_ef_sub
(order_id, dealer_id, prod_id, qty, free_qty, price, tot_price, vstatus, stock_status, order_date_time)
VALUES('$last', '$dealer_id', '".$set_ord['prod_id']."', '".$set_ord['qty']."', '".$set_ord['free_qty']."', '".$set_ord['price']."', '".$set_ord['tot_price']."', '".$set_v['vstatus']."', 'ordered', '$date');";
mysqli_query($conn, $insert_sub);   
}
$delete = "DELETE FROM drganbug_medine.tbl_dealer_ef_temp
WHERE dealer_id='$dealer_id'";
mysqli_query($conn, $delete);
$subject_to_verify=$set_dealer['name']." Placed an Quote Order ".$ref_no;
$msg_to_verify='A Notification Message';
send_mail($subject_to_verify, $msg_to_verify);
    $msg = array('icon'=>'success', 'title'=>'Success', 'text'=>'Order '.$ref_no.' placed successfully', 'status'=>2);
    echo json_encode($msg);
    exit;
    }else{
        $msg = array('icon'=>'error', 'title'=>'Error', 'text'=>'Record Not Inserted, Contact Admin', 'status'=>3);
        echo json_encode($msg);
        exit;  
    }
  
?>