<?php
error_reporting(0);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
session_start();
include '../../../include/conf.php';
include '../../../include/generate_inv_no.php';
$bill_id = $_REQUEST['id'];

if(isset($bill_id)){
    $get_main = mysqli_query($conn, "SELECT * FROM tbl_online_sales_missed_log WHERE id='$bill_id'");
    $set_main = mysqli_fetch_assoc($get_main);
    $data = json_decode($set_main['user_meta'], true);
    $get_user = mysqli_query($conn, "SELECT * FROM shop_user where user_id='".$data['user_id']."'");
    $set_user = mysqli_fetch_assoc($get_user);
$browsessionid = session_id();

$objcorderid    = mysqli_query($conn, "SELECT * from tbl_confirmorder ");
$nosnewcid=mysqli_num_rows($objcorderid);
$Fetcorderid      = mysqlI_fetch_array($objcorderid, MYSQLI_ASSOC);

$objcorderid_new    = mysqli_query($conn, "SELECT * FROM `tbl_confirmorder` WHERE varstatus!='Cash' and company_name='Energy Foods' and `orid` in (select orderid from tbl_order)  ");
$nosnewcid_new=mysqli_num_rows($objcorderid_new);
$nosnewcid_new_1=$nosnewcid_new+11;
// $orderid_new_s='HC'.$nosnewcid_new_1;
$orderid_new_s = generate('2', $conn);

if($nosnewcid=='0')
{
    $maxcorderid='1';
    $maxcorderid1='HC'.$maxcorderid;
}
else
{
$objmaxcorder    = mysqli_query($conn, "SELECT max(orid)+1 as newordid from tbl_confirmorder ");
$Fetmaxcorder      = mysqli_fetch_array($objmaxcorder, MYSQLI_ASSOC);
$maxcorderid=$Fetmaxcorder['newordid'];
$maxcorderid1='HC'.$maxcorderid;	
}
  
$Insert_memberord = "INSERT INTO tbl_confirmorder
(userid, res_id, intsessionid, `type`, refid, deliverydate, deliverytime, delivery_date1, delivery_time1, varstatus, order_tc_id, orderstatus, order_date_time, order_afterdate_time, contry, city, state, address, pin, couriername, courier_no, refund_time, d_stat, paypalamount, company_name, offer, country_id, dif_name, dif_phone, packing, packing_date, no_note, returned_reason, need_shipping, custom_charge, courier_amount, passport_file)
VALUES('".$data['user_id']."', 14, '".$data['session_id']."', '', '$orderid_new_s', '', '', '', '', 'Razorpay', '0', 0, '".$data['order_date']."', '', '".$data['country']."', '".$data['city']."', '".$data['state']."', '".$data['address']."', '".$data['pincode']."', '', '', '', 0, 0, 'Energy Foods', 0, 0, '".$data['cust_name']."', '".$data['phone']."', 0, '0000-00-00 00:00:00', 'nonote', '', NULL, NULL, '', '');";

$data_prod = json_decode($set_main['product_meta'], true);

if(mysqli_query($conn, $Insert_memberord)){
    $attachmentfileid = mysqli_insert_id($conn);
    $Updatecart	=	mysqli_query($conn, "UPDATE  tbl_confirmorder SET `orderid`='$attachmentfileid' where orid='$attachmentfileid'");
    foreach ($data_prod as $data_prods){
        $insert_sub = "INSERT INTO tbl_order
           (price, totprice, orderdate, ordertime, user_id, res_id, `type`, productid, session_id, orderid, qty, batchno, freeqty, need_shipping, custom_charge)
          VALUES('".$data_prods['price']."', '".$data_prods['tot_price']."', '".$data['order_date']."', '".date('H:i:s', strtotime($data['order_date']))."', '".$data['user_id']."', 0, '', '".$data_prods['product_id']."', '".$data['session_id']."', '$attachmentfileid', '".$data_prods['qty']."', 'va', '0', '', '');";
       mysqli_query($conn, $insert_sub);
      }
    $curl = curl_init();

    curl_setopt_array($curl, array(
      CURLOPT_URL => 'https://drganbuganapathi.com/superadmin/order-admin/phpaction/test_ajax_api.php',
      CURLOPT_RETURNTRANSFER => true,
      CURLOPT_ENCODING => '',
      CURLOPT_MAXREDIRS => 10,
      CURLOPT_TIMEOUT => 3,
      CURLOPT_FOLLOWLOCATION => true,
      CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
      CURLOPT_CUSTOMREQUEST => 'POST',
      CURLOPT_POSTFIELDS =>'{
        "refid" : "'.$orderid_new_s.'"
    }',
      CURLOPT_HTTPHEADER => array(
        'Content-Type: application/json'
      ),
    ));
    
    curl_exec($curl);
    
    curl_close($curl);
    echo '
<div class="alert alert-success alert-dismissable" style="font-size:15px">
<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
Energy Food order placed successfully with refid <b>'.$orderid_new_s.'</b>
</div>';  
}else{
    echo '
<div class="alert alert-danger alert-dismissable">
<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
Energy Food order not created, contact contact Tech Team.
</div>';    
}

}else{
 echo '
<div class="alert alert-damger alert-dismissable">
<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
Bill Id not set to create bill, contact Tech Team.
</div>';   
}
?>