<?php
error_reporting(0);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
$date = date('Y-m-d H:i:s');
session_start();
include '../../../include/conf.php';
include '../../../include/generate_oc_no.php';
$id =  $_REQUEST['id'];
$get_oc = mysqli_query($conn, "SELECT * FROM tbl_missed_oc_log WHERE id='$id'");
$set_oc = mysqli_fetch_assoc($get_oc);

$get_main = mysqli_query($conn, "SELECT * FROM tbl_appointment where mem_id='".$set_oc['mem_id']."'");
$check_rows = mysqli_num_rows($get_main);

$get_mem = mysqli_query($conn, "SELECT * FROM tbl_member where id='".$set_oc['mem_id']."'");
$set_mem = mysqli_fetch_assoc($get_mem);
if($check_rows > 0){
    // generate order id here
	$login_12 = "SELECT * from tbl_appointment WHERE  order_id!= ''";
	$resqry_12 = mysqli_query($conn, $login_12);
	$numrows_12 = mysqli_num_rows($resqry_12);
	// $tot_order_id=($numrows_12+1);
	$tot_order_id=generate($conn);
	
$update = "UPDATE tbl_appointment set 
	added_date='".$set_oc['created_at']."',  
	order_id='$tot_order_id', 
	`status`='1', 
	razid='".$set_oc['razid']."', 
	appointment_date='".$set_oc['app_date']."', 
	hour_date='".$set_oc['hour_date']."', 
	min_date='".$set_oc['min_date']."', 
	am_date='".$set_oc['am_date']."',
	session_id='".$set_oc['session_id']."',
	consulting_for='".$set_oc['consulting_for']."',
	amount='".$set_oc['amount']."',
	payment_type='Razorpay',
	razid='".$set_oc['razid']."',
	vehicle='".$set_oc['reference']."'
	where mem_id='".$set_oc['mem_id']."'";

	if(mysqli_query($conn, $update)){

		$update_mem = "UPDATE tbl_member
SET name='".$set_oc['cust_name']."', phone='".$set_oc['phone']."',  dob='".$set_oc['dob']."', status=0, country='".$set_oc['country']."', location_city='".$set_oc['location_city']."', 
WHERE id='".$set_oc['mem_id']."'";
mysqli_query($conn, $update_mem);

		$ap_hour= sprintf("%02d",$set_oc['hour_date']);
		$ap_min=  sprintf("%02d",$set_oc['min_date']); 
		 $ap_sec=  $set_oc['am_date'];
		 $mobss = $set_oc['phone'];

		$message =  "Hi ".$set_mem['name']." your video consultation with Dr.ANBUGANAPATHI on ".$ap_date." at ".$ap_hour.":".$ap_min.":".$ap_sec." is booked. Call 9884382200 ten mins before your timing. 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='.$mobss.'&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);	
	}	

}else{
	$msg = array("icon"=>"error", "title"=>"Error contact admin", "text"=>"Error".mysqli_error($conn));
    echo json_encode($msg);
}
?>