bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
require_once __DIR__ .'/vendor/autoload.php';
include 'lib/core.php';
$id=$_POST['booking_id'];
if(auth())
{
    if($_SERVER['REQUEST_METHOD']=="POST")
    {
        if(isset($_POST['booking_id']))
        {
			$booking_id=test_input($_POST['booking_id']);
			
			//get user information 
			$sql="update bookings set status='completed' where id=$booking_id";
			if($conn->query($sql)===true)
			{
			    $sql="select agent_id,admin_commission from bookings where id=$booking_id";
			    $result = $conn->query($sql);
                if ($result->num_rows > 0) 
                {
                    // output data of each row
                    $row = $result->fetch_assoc();
                    
                    if($row['agent_id']!=0)
                    {
                        $amount=$row['admin_commission'];
                        $agent_id=$row['agent_id'];
                        $sql="update agents set wallet_money=wallet_money+$amount-100 where id=$agent_id";
                        if($conn->query($sql)===true)
                        {
                            $time=date("Y-mm-dd H:i:s");
                            $txn_id=$agent_id.time().uniqid(mt_rand(),true);
                            $sql="insert into agent_payment_log (txn_id,txn_amount,agent_id,status,record,txn_type,time_stamp) values('$txn_id',$amount-100,$agent_id,'success','Amount added for ride completation','credit','$time')";
                            if($conn->query($sql)===true)
                            {
                                $response['msg']="ok";
                            }
                        }
                    }
                    else
                    {
                        $response['msg']="ok";
                    }
                      
                }
			    
			}
			else
			{
			    $response['msg']="err";
			}

$q="SELECT *,users.email as user_email,users.contact as user_contact,vendor_login.contact as vendor_contact,drivers.contact as driver_contact,drivers.driver_name,bookings.id as bk_id from bookings INNER JOIN users ON users.id=bookings.user_id INNER JOIN vendor_login ON vendor_login.id=bookings.vendor_id INNER JOIN cabs ON cabs.id=bookings.cab_id INNER JOIN drivers ON drivers.id=bookings.driver_id WHERE bookings.id=$id";               
        $result=$conn->query($q);
          $data = mysqli_fetch_array($result);
        $email=$data['email'];
        $booking_to = $data['booking_to'];

$msg = "Hi  ".$data['name']." 
that Booking ID  ROW".$id."  
From - ".$data['booking_from']." 
To - ".$booking_to." 
Trip Type - ".$data['trip_type']." 
Pickup Date - ".$data['pickup_date']." 
Pickup Time - ".$data['pickup_time']."

Congratulatinos 🥳 BOOKING has been Completed.

Booking Amount: Rup. ".$data['price']."/-

Welcome to 
Rock On Wheels Travels
Contact number 
      👇
8630825351, 9634364240 
      👇
🚕Book now taxi 🚕

https://www.rockonwheelstravels.in/";
whatsapp($data['user_contact'],$msg);

$msg = "Hi  ".$data['name']." 
that Booking ID  ROW".$id."  
From - ".$data['booking_from']." 
To - ".$booking_to." 
Cab No. - ".$data['rc_no']." 
Driver - ".$data['driver_name']."

Please Review our service
           👇
https://g.page/r/CZ1N_4uc14R5EBM/review

Welcome to 
Rock On Wheels Travels
Contact number 
      👇
8630825351, 9634364240 
      👇
🚕Book now taxi 🚕

https://www.rockonwheelstravels.in/";

whatsapp($data['user_contact'],$msg);

$msg = "Hi  ".$data['driver_name']." 
that Booking ID  ROW".$id."  
From - ".$data['booking_from']." 
To - ".$booking_to."  
Trip Type - ".$data['trip_type']." 
Pickup Date - ".$data['pickup_date']." 
Pickup Time - ".$data['pickup_time']."

Congratulatinos 🥳 BOOKING has been Completed.

Booking Amount: Rup. ".$data['price']."/-

Please Review our service
https://g.page/r/CZ1N_4uc14R5EBM/review

Rock On Wheels Travels
Contact number 
      👇
8630825351, 9634364240 
      👇
🚕Book now taxi 🚕

https://www.rockonwheelstravels.in/";

if($data['driver_id']!=0){
whatsapp($data['driver_contact'],$msg);
}

$msg = "Hi  ".$data['full_name']." 
that Booking ID  ROW".$id."  
From - ".$data['booking_from']." 
To - ".$booking_to." 
Trip Type - ".$data['trip_type']." 
Pickup Date - ".$data['pickup_date']." 
Pickup Time - ".$data['pickup_time']."

Congratulatinos 🥳 BOOKING has been Completed.

Booking Amount: Rup. ".$data['price']."/-

Please Review our service
https://g.page/r/CZ1N_4uc14R5EBM/review

Rock On Wheels Travels
Contact number 
      👇
8630825351, 9634364240 
      👇
🚕Book now taxi 🚕

https://www.rockonwheelstravels.in/";

whatsapp($data['vendor_contact'],$msg);

$msg = "Hi Admin
that Booking ID  ROW".$id."  
From - ".$data['booking_from']." 
To - ".$booking_to."  
Trip Type - ".$data['trip_type']." 
Pickup Date - ".$data['pickup_date']." 
Pickup Time - ".$data['pickup_time']."

Congratulatinos 🥳 BOOKING has been Completed.

Booking Amount: Rup. ".$data['price']."/-

Please Review our service
https://g.page/r/CZ1N_4uc14R5EBM/review

Welcome to 
Rock On Wheels Travels
Contact number 
      👇
8630825351, 9634364240 
      👇
🚕Book now taxi 🚕

https://www.rockonwheelstravels.in/";

whatsapp('8630825351',$msg);

$url="https://rockonwheelstravels.in/admin/invoice.php?id=$id";
if (ini_get('allow_url_fopen')) {
    $html=file_get_contents($url);

} else {
    $ch=curl_init($url);
    curl_setopt($ch, CURLOPT_HEADER, );
    curl_setopt ( $ch , CURLOPT_RETURNTRANSFER , 1 );
    $html=curl_exec($ch);
    curl_close($ch);
}
$mpdf=new \Mpdf\Mpdf();
// $html = str_replace('{_booking_id}', $booking_id, $html);
$mpdf->SetDisplayMode('fullwidth');
$mpdf->SetDisplayPreferences('FullScreen');
$mpdf->CSSselectMedia='mpdf';
$mpdf->setBasePath($url);
$mpdf->WriteHTML($html);
$pdf = $mpdf->Output("bill_pdf/".date("m-d H-i-s") . ".pdf",'F');
$bill_pdf = "bill_pdf/".date("m-d H-i-s") . ".pdf";

include('smtp/PHPMailerAutoload.php');
    $mail=new PHPMailer();
    $mail->isSMTP();
    $mail->Host='smtp.hostinger.com';
     $mail->Port=465;
    $mail->SMTPSecure="ssl";
    $mail->SMTPAuth=true;
     $mail->Username="info@rockonwheelstravels.in";
    $mail->Password="Rock@2022";
    $mail->setFrom("info@rockonwheelstravels.in");
    $mail->addAddress($data['user_email']);
    $mail->isHTML(true);
    $mail->Subject="Billing";
    $mail->Body="Completed";
    $mail->addAttachment($bill_pdf);
    $mail->SMTPOptions=array("ssl"=>array(
        "verify_peer"=>false,
        "verify_peer_name"=>false,
        "allow_self_signed"=>false,
    ));
    if($mail->send()){
        $response['msg']="mail send";
    }else{
        $response['msg']="mail error";
    }
            
            echo json_encode($response);
            
        }
    }
}
?>