<?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'){
    extract($_POST);
    date_default_timezone_set('Asia/Kolkata');
    $created_at = date( 'Y-m-d h:i:s A', time () );    
    $payment_status="completed";
    $statuss=1;
$sql_pay ="UPDATE  user_payment SET payment_method='$payment_method',pay_status='$payment_status',payable_status='$statuss',created_date='$created_at' WHERE order_id='".$order_id."'"; 
if  (mysqli_query($conn, $sql_pay))
{  $sql_pet="select * from user_payment where order_id='".$order_id."'";
    $relt_ptm = mysqli_query($conn, $sql_pet);
    $res_pt= mysqli_fetch_array($relt_ptm);
    $id=$res_pt['id'];
    $user_id=$res_pt['user_id'];
    $order_id=$res_pt['order_id'];
    $cart_id=$res_pt['cart_id'];
     $rid = explode(",",$cart_id);
    foreach($rid as $pm_id){
     $stat="1";
     $statuss="0";
     $sql_paytmss ="UPDATE  addto_cart SET payment_status='$stat',invoice_id='$statuss' WHERE id='".$pm_id."'"; 
     $result_ptmss=mysqli_query($conn,$sql_paytmss) or die(mysqli_error());
     }
         $sqqq="select * from user_profile where id=".$user_id;
    $sql1=mysqli_query($conn, $sqqq);
    $row1=mysqli_fetch_array($sql1);
    $total_price = $res_pt['total_price'];
    $email = $row1['email'];
    $name = $row1['fname'];
    $date = date("d-m-Y");
    $from_team = "Orange Groceries";
    $from_website = "https://orangegroceries.com/index.php";
    $to = $email;
    $message = "<table>
    <tr>
    <td>
    <h3>Hi ".$name."</h3>
    <p> Welcome to ". $from_team ." :</p>
     
      <p><span> Your Order Placed with RS. ".$total_price." , Pay On Delivery : </span></p>
      <p><span>Thankyou!!! </span></p>
    </td>
  </tr>
  
</table>";

$email = new PHPMailer();
$email->Body      =  ($message);
$email->SetFrom('support@orangegroceries.com', 'Orange Groceries'); //Name is optional
$email->Subject   ="Order Placed With Orange Groceries";
$email->IsHTML(true);
$email->Body      =  ($message);
$email->AddAddress($to);
   if (! $email->Send()) {
      // echo "Problem in sending email!";
       //  echo "Mailer Error: " . $email->ErrorInfo;
   // echo 'Not sent: <pre>'.print_r(error_get_last(), true).'</pre>';
    } else {
        $message = "<table>
    <tr>
    <td>
    <h3>Hi Team</h3>
    <p> Order Placed By ". $name ."</p>
      <p><span>with RS.".$total_price." , </span></p>
      <p><span>Payment method Is Cash On Delivery... </span></p>
    </td>
  </tr>
</table>";

  $email = new PHPMailer();
$email->Body      =  ($message);
$email->SetFrom('support@orangegroceries.com', 'Orange Groceries'); //Name is optional
$email->Subject   = "Order Placed 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['id']=$id; 
    $response['status']=1;
}else{
$response['status']=0;
}
	echo json_encode($response);
	mysqli_close($conn);
}

?>