<?php
 error_reporting(0);
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
session_start();
include '../../../include/conf.php';
include '../../../include/generate_inv_no.php';
$bill_id = $_REQUEST['bill_id'];
$option_ef = $_REQUEST['option_ef'];
$option_ap = $_REQUEST['option_ap'];
$ef_cash = array();
$ef_gst = array();
$ap_cash = array();
$ap_gst = array();

function splitOffer($paidQty, $freeQty) {
    $total = $paidQty + $freeQty;

    // Detect offer type based on expected free quantity
    $expected_2p1 = floor($total / 3);
    $expected_4p1 = floor($total / 5);

    if ($expected_2p1 == $freeQty) {
        $offerType = '2+1';
        $divided = $paidQty / 3;
        $adjusted = $divided + 1;
        $denominator = 2;
    } elseif ($expected_4p1 == $freeQty) {
        $offerType = '4+1';
        $divided = $paidQty / 3;
        $adjusted = $divided + 2;
        $denominator = 4;
    } else {
        // fallback: assume 2+1
        $offerType = '2+1';
        $divided = $paidQty / 3;
        $adjusted = $divided + 1;
        $denominator = 2;
    }

    // Nearest lower even integer
    $evenQty = floor($adjusted);
    if ($evenQty % 2 != 0) {
        $evenQty--;
    }

    // GST part
    $gstQty = $evenQty;
    $gstFree = $gstQty / $denominator;

    // Cash part
    $cashQty = $paidQty - $gstQty;
    $cashFree = $freeQty - $gstFree;

    return array(
        'gst' => array('qty' => $gstQty, 'free_qty' => $gstFree),
        'cash' => array('qty' => $cashQty, 'free_qty' => $cashFree),
        'offer' => $offerType . ' (Even GST logic)'
    );
}


if(isset($bill_id)){
    $get_main = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_main WHERE id='$bill_id'");
    $set_main = mysqli_fetch_assoc($get_main);

    $get_user = mysqli_query($conn, "SELECT * FROM shop_user where user_id='".$set_main['dealer_id']."'");
    $set_user = mysqli_fetch_assoc($get_user);

    if($set_user['discount'] == '' || $set_user['discount'] == 0){
        $discount = '0';
    }else{
      $discount = $set_user['discount'];
    }

if(!empty($option_ef)){
   foreach($option_ef as $option){
    $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '$option' and order_id='$bill_id'");
    $check_rows = mysqli_num_rows($get_sub);
    if($check_rows > 0){
        $set_sub = mysqli_fetch_assoc($get_sub);
     if($set_sub['free_qty'] == 0){
        $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$set_sub['qty'], "free_qty"=>$set_sub['free_qty']);
        array_push($ef_cash, $arr);
     }elseif($set_sub['free_qty'] == 1){
        $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$set_sub['qty'], "free_qty"=>$set_sub['free_qty']);
        array_push($ef_cash, $arr);
     }elseif($set_sub['free_qty'] == 2){
        $quotient = floor($set_sub['qty'] / 2);  
        $remainder = $set_sub['qty'] % 2;  
        $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$quotient, "free_qty"=>1);
        array_push($ef_cash, $arr);
        $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$quotient, "free_qty"=>1);
        array_push($ef_gst, $arr);
     }else{
// --- Usge Example ---
$split = splitOffer($set_sub['qty'], $set_sub['free_qty']); // Example for "6+3" (2+1 offer)

  array_push($ef_gst, [
            "prod_id" => $set_sub['prod_id'],
            "qty" => $split['gst']['qty'],
            "free_qty" => $split['gst']['free_qty']
        ]);
 array_push($ef_cash, [
            "prod_id" => $set_sub['prod_id'],
            "qty" => $split['cash']['qty'],
            "free_qty" => $split['cash']['free_qty']
        ]);

     }
    }
   }
   
// process Energy Foods Cash Order
 if(count($ef_cash) > 0){
    $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 `orderid` in (select orderid from tbl_order)");
    $nosnewcid_new=mysqli_num_rows($objcorderid_new);
    $orderid_new_s='CO'.($nosnewcid_new);
    $dt2=date('Y-m-d H:i:s' );
    $time = date('H:i:s', strtotime($dt2));
    $address = mysqli_real_escape_string($conn, $set_user['address']);
    $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('".$set_main['dealer_id']."', 14, '$browsessionid', '', '$orderid_new_s', '', '', '', '', 'Cash', '1', 0, '$dt2', '', '".$set_user['country']."', '".$set_user['city']."', '".$set_user['state']."', '$address', '".$set_user['postcode']."', '', '', '', 0, 0, 'Energy Foods', '$discount', 0, '".$set_user['name']."', '".$set_user['phone']."', 0, '0000-00-00 00:00:00', 'nonote', '', NULL, NULL, '', '');";
    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($ef_cash as $option){
            $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '".$option['prod_id']."' and order_id='$bill_id'");
            $check_rows = mysqli_num_rows($get_sub);
            if($check_rows > 0){
                $set_sub = mysqli_fetch_assoc($get_sub);
                $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('".$set_sub['price']."', '".($set_sub['price'] * $option['qty'])."', '$dt2', '$time', '".$set_main['dealer_id']."', 0, '', '".$option['prod_id']."', '$browsessionid', '$attachmentfileid', '".$option['qty']."', 'va', '".$option['free_qty']."', '', '');";
               mysqli_query($conn, $insert_sub);
    
               $update_sub = "UPDATE tbl_dealer_ef_sub set ref_order_id = '$attachmentfileid' where prod_id = '".$option['prod_id']."' and order_id='$bill_id'";
               mysqli_query($conn, $update_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 Cash 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 Cash order not created, contact contact Tech Team.
    </div>';    
    }    
 }
 // Process Energy Foods GST Order
 if(count($ef_gst) > 0){
    $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;	
    }
    
    $dt2=date('Y-m-d H:i:s' );
    $time = date('H:i:s', strtotime($dt2));
    $address = mysqli_real_escape_string($conn, $set_user['address']);
    $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('".$set_main['dealer_id']."', 14, '$browsessionid', '', '$orderid_new_s', '', '', '', '', 'Bank Transfer', '1', 0, '$dt2', '', '".$set_user['country']."', '".$set_user['city']."', '".$set_user['state']."', '$address', '".$set_user['postcode']."', '', '', '', 0, 0, 'Energy Foods', '$discount', 0, '".$set_user['name']."', '".$set_user['phone']."', 0, '0000-00-00 00:00:00', 'nonote', '', NULL, NULL, '', '');";
    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($ef_gst as $option){
            $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '".$option['prod_id']."' and order_id='$bill_id'");
            $check_rows = mysqli_num_rows($get_sub);
            if($check_rows > 0){
                $set_sub = mysqli_fetch_assoc($get_sub);
                $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('".$set_sub['price']."', '".($set_sub['price'] * $option['qty'])."', '$dt2', '$time', '".$set_main['dealer_id']."', 0, '', '".$option['prod_id']."', '$browsessionid', '$attachmentfileid', '".$option['qty']."', 'va', '".$option['free_qty']."', '', '');";
               mysqli_query($conn, $insert_sub);
               $stm = $set_sub['ref_order_id'].' '.$attachmentfileid;
               $update_sub = "UPDATE tbl_dealer_ef_sub set ref_order_id = '$stm' where prod_id = '".$option['prod_id']."' and order_id='$bill_id'";
               mysqli_query($conn, $update_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 Cash 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 Cash order not created, contact contact Tech Team.
    </div>';    
    }
 }
}
if(!empty($option_ap)){
    foreach($option_ap as $option){
        $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '$option' and order_id='$bill_id'");
        $check_rows = mysqli_num_rows($get_sub);
        if($check_rows > 0){
            $set_sub = mysqli_fetch_assoc($get_sub);
         if($set_sub['free_qty'] == 0){
            $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$set_sub['qty'], "free_qty"=>$set_sub['free_qty']);
            array_push($ap_cash, $arr);
         }elseif($set_sub['free_qty'] == 1){
            $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$set_sub['qty'], "free_qty"=>$set_sub['free_qty']);
            array_push($ap_cash, $arr);
         }elseif($set_sub['free_qty'] == 2){
            $quotient = floor($set_sub['qty'] / 2);  
            $remainder = $set_sub['qty'] % 2;  
            $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$quotient, "free_qty"=>1);
            array_push($ap_cash, $arr);
            $arr = array("prod_id"=>$set_sub['prod_id'], "qty"=>$quotient, "free_qty"=>1);
            array_push($ap_gst, $arr);
         }else{
            $split = splitOffer($set_sub['qty'], $set_sub['free_qty']); // Example for "6+3" (2+1 offer)

  array_push($ap_gst, [
            "prod_id" => $set_sub['prod_id'],
            "qty" => $split['gst']['qty'],
            "free_qty" => $split['gst']['free_qty']
        ]);
 array_push($ap_cash, [
            "prod_id" => $set_sub['prod_id'],
            "qty" => $split['cash']['qty'],
            "free_qty" => $split['cash']['free_qty']
        ]);
         }
        }
       }
     
    // Processing AP Cash Order
    $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 `orderid` in (select orderid from tbl_order)");
    $nosnewcid_new=mysqli_num_rows($objcorderid_new);
    $orderid_new_s='CO'.($nosnewcid_new);
    $dt2=date('Y-m-d H:i:s' );
    $time = date('H:i:s', strtotime($dt2));
    $address = mysqli_real_escape_string($conn, $set_user['address']);
    $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('".$set_main['dealer_id']."', 14, '$browsessionid', '', '$orderid_new_s', '', '', '', '', 'Cash', '1', 0, '$dt2', '', '".$set_user['country']."', '".$set_user['city']."', '".$set_user['state']."', '$address', '".$set_user['postcode']."', '', '', '', 0, 0, 'Anbu Phaarmaa', '$discount', 0, '".$set_user['name']."', '".$set_user['phone']."', 0, '0000-00-00 00:00:00', 'nonote', '', NULL, NULL, '', '');";
    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($ap_cash as $option){
            $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '".$option['prod_id']."' and order_id='$bill_id'");
            $check_rows = mysqli_num_rows($get_sub);
            if($check_rows > 0){
                $set_sub = mysqli_fetch_assoc($get_sub);
                $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('".$set_sub['price']."', '".($set_sub['price'] * $option['qty'])."', '$dt2', '$time', '".$set_main['dealer_id']."', 0, '', '".$option['prod_id']."', '$browsessionid', '$attachmentfileid', '".$option['qty']."', 'va', '".$option['free_qty']."', '', '');";
               mysqli_query($conn, $insert_sub);
    
               $update_sub = "UPDATE tbl_dealer_ef_sub set ref_order_id = '$attachmentfileid' where prod_id = '".$option['prod_id']."' and order_id='$bill_id'";
               mysqli_query($conn, $update_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>
    Anbu Phaarmaa Cash 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>
    Anbu Phaarmaa Cash order not created, contact contact Tech Team.
    </div>';    
    }
    // Process AP GST Order
    if(count($ap_gst) > 0){
        $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='Anbu Phaarmaa' and `orid` in (select orderid from tbl_order)  ");
    $nosnewcid_new=mysqli_num_rows($objcorderid_new);
    $nosnewcid_new_1=$nosnewcid_new+1;
    // $orderid_new_s='APA'.$nosnewcid_new_1;
    $orderid_new_s = generate('10', $conn);
    $dt2=date('Y-m-d H:i:s' );
    $address = mysqli_real_escape_string($conn, $set_user['address']);
    if($nosnewcid=='0')
    {
        $maxcorderid='1';
        $maxcorderid1='APA'.$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='APA'.$maxcorderid;	
    }
        $dt2=date('Y-m-d H:i:s' );
        $time = date('H:i:s', strtotime($dt2));
        
        $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('".$set_main['dealer_id']."', 14, '$browsessionid', '', '$orderid_new_s', '', '', '', '', 'Bank Transfer', '1', 0, '$dt2', '', '".$set_user['country']."', '".$set_user['city']."', '".$set_user['state']."', '$address', '".$set_user['postcode']."', '', '', '', 0, 0, 'Anbu Phaarmaa', '$discount', 0, '".$set_user['name']."', '".$set_user['phone']."', 0, '0000-00-00 00:00:00', 'nonote', '', NULL, NULL, '', '');";
        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($ap_gst as $option){
                $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub where prod_id = '".$option['prod_id']."' and order_id='$bill_id'");
                $check_rows = mysqli_num_rows($get_sub);
                if($check_rows > 0){
                    $set_sub = mysqli_fetch_assoc($get_sub);
                    $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('".$set_sub['price']."', '".($set_sub['price'] * $option['qty'])."', '$dt2', '$time', '".$set_main['dealer_id']."', 0, '', '".$option['prod_id']."', '$browsessionid', '$attachmentfileid', '".$option['qty']."', 'va', '".$option['free_qty']."', '', '');";
                   mysqli_query($conn, $insert_sub);
        
                $atm = $set_sub['ref_order_id'].' '.$attachmentfileid;
                   $update_sub = "UPDATE tbl_dealer_ef_sub set ref_order_id = '$atm' where prod_id = '".$option['prod_id']."' and order_id='$bill_id'";
                   mysqli_query($conn, $update_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>
        Anbu Phaarmaa Cash 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>
        Anbu Phaarmaa Cash order not created, contact contact Tech Team.
        </div>';    
        }
    }
}
exit;
}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>';   
   }
?>