<?php
session_start();
if(isset($_SESSION['dealer_id'])){
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);
$message = "Hi ".$set_dealer['name']." Your Order ".$ref_no." confirmed.  Once dispatched you will get courier details by SMS. Check order status on our website. ANBUDR"; //enter Your Message 
 $message = urlencode($message);
 $curl = curl_init();
 curl_setopt_array($curl, array(
   CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=ANBUDR&Message='.$message.'&MobileNumbers='.$set_dealer['phone'].'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb',
   CURLOPT_RETURNTRANSFER => true,
   CURLOPT_ENCODING => '',
   CURLOPT_MAXREDIRS => 10,
   CURLOPT_TIMEOUT => 0,
   CURLOPT_FOLLOWLOCATION => true,
   CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
   CURLOPT_CUSTOMREQUEST => 'GET',
 ));
 
 $response = curl_exec($curl);
 
 curl_close($curl);
 mysqli_close($conn);
    $msg = array('icon'=>'success', 'title'=>'Success', 'text'=>'Order '.$ref_no.' placed 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;  
    }
}else{
    mysqli_close($conn);
    $msg = array('icon'=>'error', 'title'=>'Error', 'text'=>'Session expired, Relogin', 'status'=>3);
        echo json_encode($msg);
        exit;  
}
?>