<?php  use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
require '../PHPMailer/Exception.php';
require '../PHPMailer/PHPMailer.php';
require '../PHPMailer/SMTP.php';
include("db_config.php");  
if($_SERVER['REQUEST_METHOD']=='POST'){
	 date_default_timezone_set('Asia/Kolkata');
     $date = date('Y-m-d H:i:s');
     $user_id = $_POST['user_id'];
     $order_id = $_POST['order_id'];
     $message = $_POST['message']; 
     $order_status = $_POST['order_status'];
     $query ="UPDATE user_payment SET order_status='$order_status',message='$message',cancel_date='$date' WHERE order_id='$order_id' and user_id='$user_id'"; 
	// $query="select * from user_payment where order_id='$order_id' and user_id='$user_id'";
	 $result = mysqli_query($conn, $query);
	if($result){
	$sql_ptm="select * from user_payment where order_id='$order_id' and user_id='$user_id'";
    $result_ptm = mysqli_query($conn, $sql_ptm);
    $res_ptm= mysqli_fetch_array($result_ptm);
	$sql_usr=mysqli_query($conn,"select * from user_profile where id='$user_id'");
    $res_usr= mysqli_fetch_array($sql_usr);
	  $response['data']=$res_ptm;
	  $order_status=$res_ptm['order_status'];
	  $order_id=$res_ptm['order_id'];
	  $messagess=$res_ptm['message'];
	  $cancel_date=$res_ptm['cancel_date'];
	  $name=$res_usr['fname'];
	$message = "<table>
    <tr> 
    <td>
    <h3>Hi Team</h3>
    <p> Order Cancel By ". $name ."</p>
    <p> Order Id Is ". $order_id ."</p>
      <p><span>Order Cancel Reason : ".$messagess." , </span></p>
      <p><span>Cancel date : ".$cancel_date." , </span></p>
    </td>
  </tr>
</table>";
$email = new PHPMailer();
$email->Body      =  ($message);
$email->SetFrom('support@orangegroceries.com', 'Orange Groceries'); //Name is optional
$email->Subject   = "Order Cancel By " .$name ;
$email->IsHTML(true);
$email->Body      =  ($message);
$email->AddAddress('support@orangegroceries.com');
   if (! $email->Send()) {
      // echo "Problem in sending email!";
       //  echo "Mailer Error: " . $mail->ErrorInfo;

    } else {
              // echo "email sended!";

    }
	  $response['status']=1;
	}
	else {
		$response['status']=0;
	}
	echo json_encode($response);
	mysqli_close($conn);
}