<?php

include 'lib/core.php';
if(auth())
{
	if($_SERVER['REQUEST_METHOD']=="POST")
	{
		if(isset($_POST['booking_id']))
		{
			$booking_id=test_input($_POST['booking_id']);

			$date=date('Y-m-d h:i:s');
                $admin_user_id=$_SESSION['session_login'];
                $sql=$conn->query("INSERT INTO user_role_activity(booking_id,user_id,type,created_at) VALUES ('$booking_id','$admin_user_id','Information Pass','$date')");
                
			
			$result = $conn->query("SELECT *,bookings.id as booking_id,users.contact as user_contact,drivers.contact as driver_contact,vendor_login.contact as vendor_contact FROM bookings 
								    LEFT JOIN drivers ON drivers.id=bookings.driver_id 
								    LEFT JOIN users ON users.id=bookings.user_id 
								    LEFT JOIN vendor_login ON vendor_login.id=bookings.vendor_id 
								    LEFT JOIN payment_log ON payment_log.booking_id=bookings.id 
								    LEFT JOIN cabs ON cabs.id=bookings.cab_id
								    WHERE bookings.id='$booking_id'");

			if ($result->num_rows > 0) {
				$row=$result->fetch_assoc();

				$driver_contact=$row['driver_contact'];
				$cash_amount = $row['price']-$row['txn_amount'];
					// driver whatsapp
				 $included_exclude='';
     if ($row['toll_tax']==0) {
        $included_exclude.="Toll Tax - Included \n";
    }else{
        $included_exclude.="Toll Tax - Excluded \n";
    }
    if ($row['state_tax']==0) {
        $included_exclude.="State Tax - Included \n";
    }else{
        $included_exclude.="State tax - Excluded \n";
    }
    if ($row['parking']==1) {
        $included_exclude.="Parking - Included \n";
    }else{
        $included_exclude.="Parking - Excluded";
    }

$msg = "Hi 👋 ".$row['driver_name']." Your new ride
BOOKING ID: C4U".$booking_id."  
From - ".$row['booking_from']." 
To - ".$row['booking_to']." 
Cab Type - ".$row['cab_type']." 
Trip Type - ".$row['trip_type']." 
Pickup Date - ".$row['pickup_date']." 
Pickup Time - ".$row['pickup_time']."

Allocate Customer Details...

Customer Name - ".$row['name']."
Contact No: ".$row['user_contact']."

".$included_exclude."
Night Charge - Rs.".$row['night_charge']."/-

अधिक से अधिक बुकिंग के लिए
Vendor app download करें 👇
https://play.google.com/store/apps/details?id=com.cabz4u.vendor

Authorise by  cabz4you";


whatsapp($driver_contact,$msg);

$msg = "Hi 👋 ".$row['driver_name']." Your new ride
BOOKING ID: C4U".$booking_id."  
From - ".$row['booking_from']." 
To - ".$row['booking_to']." 
Cab Type - ".$row['cab_type']." 
Trip Type - ".$row['trip_type']." 
Pickup Date - ".$row['pickup_date']." 
Pickup Time - ".$row['pickup_time']."

Allocate Customer Details...

Customer Name - ".$row['name']."
Contact No: ".$row['user_contact']."

".$included_exclude."
Night Charge - Rs.".$row['night_charge']."/-

Authorise by  cabz4you";

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

$msg = "Hi👋 ".$row['name']." inform that 
Booking ID is C4U".$booking_id." 
From - ".$row['booking_from']." 
To - ".$row['booking_to']." 
Trip Type - ".$row['trip_type']." 
Pickup Date - ".$row['pickup_date']." 
Pickup Time - ".$row['pickup_time']."

".$included_exclude."

Allocate CAB And Driver Details 

Cab Number - ".$row['rc_no']." 
CabType - ".$row['cab_type']." 
Driver Name - ".$row['driver_name']." 

Please Contact Driver 
".$row['driver_contact']." 

Please pay the rest Amount Driver 

Welcome to 
cabz4U Taxi Service 
Contact number 
      👇
7830530004 7060000113 7830530005 
      👇
🚕Book now taxi 🚕

http://www.cabz4you.com/";
whatsapp($row['user_contact'],$msg);
				$response['msg']="ok";
                 }    // $success=true;

// ================================================================================            

			//get driver information
//                  $sql="select * from drivers,cabs where drivers.id=(select driver_id from bookings where id=$booking_id) and cabs.id =(select cab_id from bookings where id=$booking_id)";
//                  $result=$conn->query($sql);
//                  if ($result->num_rows > 0) 
//                  {
//                  	$driver_data=$result->fetch_assoc();


//                  	$driver_name=$driver_data['driver_name'];
//                  	$driver_contact=$driver_data['contact'];
//                  	$cab_name=$driver_data['cab_name'];
//                  	$rc_no=$driver_data['rc_no'];

//                  	$sql = "SELECT * ,bookings.id as book_id,drivers.contact as driver_contact,users.contact as user_contact FROM bookings INNER JOIN users ON users.id=bookings.user_id INNER JOIN drivers ON drivers.id=bookings.driver_id INNER JOIN cabs ON cabs.id=bookings.cab_id  INNER JOIN cab_types ON cab_types.id=cabs.cab_type_id WHERE bookings.id='".$booking_id."'";

//                  	$result=$conn->query($sql);
//                  	$user_data=$result->fetch_assoc();
//                  	$contact=$user_data['user_contact'];
// 					//pass information to user

//          		// customer whatsapp
// $msg = "Booking : ".$user_data['booking_from']." to ".$user_data['booking_to']."
// Booking id : ".$user_data['book_id']."
// Driver name : ".$user_data['driver_name']."
// Driver contact : ".$user_data['driver_contact']."
// Cab no :  ".$user_data['rc_no']."
// Cab modal : ".$user_data['type']."

// Welcome to 
// cabz4U Taxi Service 
// Contact number 
//       👇
// 7830530004 7060000113 7830530005 
//       👇
// 🚕Book now taxi 🚕

// http://www.cabz4you.com/";

// whatsapp($contact,$msg);
                 	
//                  	$response['msg']="ok";
//                  }
                 echo json_encode($response);

             }
         }
     }
 ?>