<?php
error_reporting(0);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
$date = date('Y-m-d H:i:s');
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
session_start();
include '../../../include/conf.php';
$id=$_REQUEST['id'];
$get_det = mysqli_query($conn, "SELECT * FROM tbl_missed_dc_log where id='$id'");
$set_det = mysqli_fetch_assoc($get_det);
$app_date=date('Y-m-d', strtotime($set_det['app_date']));

$exp = explode(":", $set_det['time_id']);
$hour_date = ltrim($exp[0], '0');
$exp1 = explode(" ", $exp[1]);
if($exp1[0]=='00'){
    $min_date = '0';
}else{
    $min_date = $exp1[0];
}
$am_date=$exp1[1];

$insert = "INSERT INTO tbl_appointment_office (mem_id,appointment_date,added_date,hour_date,min_date,am_date,des,mobile_no,name,location,amount,order_id,payment_type,status,quoted_by,razid,payment,paid_amount,app_id) VALUES
	 (6,'$app_date','".$set_det['created_at']."','$hour_date','$min_date','$am_date','".$set_det['consulting_for']."','".$set_det['whatsapp']."','".$set_det['cust_name']."','".$set_det['location']."','".$set_det['age']."','".$set_det['raz_order_id']."','def','1','patient','".$set_det['reference']."', 'RAZORPAY','".$set_det['amount']."','".$set_det['app_id']."');";

if(mysqli_query($conn, $insert)){
    $message = "Hi ".$set_det['cust_name']." your direct consultation with Dr.ANBUGANAPATHI on ".$set_det['app_date']." at ".$set_det['app_time']." is booked. 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=DRANBU&Message='.$message.'&MobileNumbers='.$set_det['whatsapp'].'&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);

    $msg = array("icon"=>"success", "title"=>"Success..", "text"=>"Order successfully Created");
    echo json_encode($msg);
}else{
    $msg = array("icon"=>"error", "title"=>"Error contact admin", "text"=>"Error".mysqli_error($conn));
    echo json_encode($msg);
}
?>