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
include 'lib/config.php';
date_default_timezone_set("Asia/Kolkata");
if (isset($_REQUEST['get_avail_cars'])) {
    $vendor_id = $_REQUEST['vendor_id'];
    
    $response = array();
    $temp = array();
    
    $sql = "SELECT available_vehicle.*, vendor_profile.*, vendor_login.* FROM available_vehicle 
    JOIN vendor_profile ON available_vehicle.vendor_id=vendor_profile.vendor_id 
    JOIN vendor_login ON available_vehicle.vendor_id=vendor_login.id WHERE available_vehicle.status = 'pending' AND available_vehicle.vendor_id='$vendor_id'";
    
    $res = mysqli_query($conn, $sql);
    $num = mysqli_num_rows($res);
    while ($row = mysqli_fetch_assoc($res)) {
        array_push($temp, $row);
    }
    
    if ($num < 1) {
        $response['status'] = false;
        $response['message'] = "NO BOOKING FOUND";
        $response['error'] =  mysqli_error($conn);
        $response['sql'] =  $sql;
    } else {
        array_push($response, $temp);
        $response['status'] = True;
    }
    echo json_encode($response);
    exit;
}

if (isset($_REQUEST['get_all_avail_cars'])) {
    $id = $_REQUEST['vendor_id'];
    
    $response = array();
    $temp = array();
    
    $sql = "SELECT available_vehicle.*, vendor_profile.*, vendor_login.* FROM available_vehicle 
    JOIN vendor_profile ON available_vehicle.vendor_id=vendor_profile.vendor_id 
    JOIN vendor_login ON available_vehicle.vendor_id=vendor_login.id 
    WHERE available_vehicle.status = 'pending'";
    
    $res = mysqli_query($conn, $sql);
    $num = mysqli_num_rows($res);
    while ($row = mysqli_fetch_assoc($res)) {
        array_push($temp, $row);
    }
    
    if ($num < 1) {
        $response['status'] = false;
        $response['message'] = "NO BOOKING FOUND";
        $response['error'] =  mysqli_error($conn);
        $response['sql'] =  $sql;
    } else {
        array_push($response, $temp);
        $response['status'] = True;
    }
    echo json_encode($response);
    exit;
}

if (isset($_REQUEST['add_car'])) {
    if (!isset($_REQUEST['vendor_id'])) {
        $response['status'] = false;
        $response['message'] = 'Vendor id required';
        echo json_encode($response);
        exit();
    }
    
    $vendor_id = $_REQUEST['vendor_id'];
    $remark = $_REQUEST['remark'];
    $from = $_REQUEST['from'];
    $to = $_REQUEST['to'];
    $date = $_REQUEST['date'];
    $time = $_REQUEST['time'];
    $cab_type = $_REQUEST['cab_type'];
    
    $sql = "INSERT INTO `available_vehicle` (`vendor_id`,`from`, `to`, `date`, `time`, `cab_type`, `remark`) values ('$vendor_id','$from','$to','$date','$time','$cab_type','$remark')";

if($conn->query($sql)){	
        $response['status'] = True;
        $response['message'] = 'Updated';
    }else{
        $response['status'] = FALSE;
        $response['message'] = 'Not Updated';
        $response['error'] = mysqli_error($conn);
        $response['sql'] = $sql;
    }
    echo json_encode($response);
    exit();
}

// if (isset($_REQUEST['update_booking'])) {
//     $booking_id = $_REQUEST['booking_id'];
//     $status = $_REQUEST['status'];
//     $vendor_id = $_REQUEST['vendor_id'];
//     if (!isset($_REQUEST['vendor_id'])) {
//         $response['status'] = false;
//         $response['message'] = 'Vendor id required';
//         echo json_encode($response);
//         exit();
//     }
    
//     $sql = "SELECT * FROM bookings WHERE id=$booking_id";
//     $res = mysqli_query($conn, $sql);
//     $row = mysqli_fetch_array($res);
//     $st = $row['status'];
//     $title = "Your Post Booking Has Been ACCEPTED";
//     $content = "Your Post Booking (Id: " . $booking_id . "), From " .  $row['booking_from'] . ", to " .  $row['booking_to'] . " has been Accepted By A Vendor!";
//     $post_by_vendor_id = $row['post_by_id'];
//     if ($st != 'vendor_pass' and $st != 'cancelled' and $status != 'cancelled') {
//         $response['status'] = false;
//         $response['message'] = 'This Booking is Already Assign to Another Vendor';
//         echo json_encode($response);
//         exit();
//     }
//     $curr_dt = date('Y-m-d H:i:s');
    
//     if ($_REQUEST['status'] == 'confirmed') {
//         $sql = "UPDATE bookings SET status='$status' , accept_time='$curr_dt' , vendor_id='$vendor_id' WHERE id='$booking_id'";
//     } else {
//         $sql = "UPDATE bookings SET status='$status' , vendor_id='$vendor_id' WHERE id='$booking_id'";
//     }
//     $res = mysqli_query($conn, $sql);
//     if ($status == 'cancelled') {
//         if ($res) {
//             $sql1 = "CREATE TEMPORARY TABLE tmptable SELECT * FROM bookings where id='$booking_id'";
//             $res1 = mysqli_query($conn, $sql1);
//             $sql2 = "UPDATE tmptable SET id = 0 ,status='vendor_pass',vendor_id=0,driver_id=0,cab_id=0";
//             $res2 = mysqli_query($conn, $sql2);
//             $sql3 = "INSERT INTO bookings SELECT * FROM tmptable";
//             if($conn->query($sql3))
//             {	$insert_id = $conn->insert_id;
//                 $qry = "SELECT * FROM payment_log WHERE booking_id='$booking_id' LIMIT 1";
//                 $rs = mysqli_query($conn,$qry);
//                 $getrow = mysqli_fetch_assoc($rs);
                
                
//                 $advance=$getrow['txn_amount'];
//                 $ORDER_ID=$getrow['txn_id'];
                
//                 $q="insert into payment_log(booking_id,txn_id,txn_amount,txn_status) values('$insert_id','$ORDER_ID',$advance,1)";
//                 $res5 = mysqli_query($conn, $q);
//             }
//         }
//     }
//     $response['status'] = True;
//     $response['message'] = 'Updated';
//     echo json_encode($response);
//     if ($res) {
//         if ($_REQUEST['status'] == 'confirmed') {
//             if ($post_by_vendor_id != '0') {
//                 $query = "SELECT * FROM vendor_profile WHERE vendor_id='$post_by_vendor_id'";
//                 $result = $conn->query($query);
//                 $book = $result->fetch_assoc();
//                 $onesignalid = $book['onesignal_id'];
//                 $onesignal_id = array("$onesignalid");
//                 $content      = array(
//                     "en" => $content,
//                 );
//                 $heading      = array(
//                     "en" => $title,
//                 );
//                 $fields = array(
//                     'app_id' => "065a49b8-5e7c-48d6-a5d3-539855f3841e",
//                     'include_player_ids' => $onesignal_id,
//                     'data' => array("foo" => "bar"),
//                     'contents' => $content,
//                     'heading' => $heading
//                 );
//                 $fields = json_encode($fields);
                
//                 $ch = curl_init();
//                 curl_setopt($ch, CURLOPT_URL, "https://onesignal.com/api/v1/notifications");
//                 curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json; charset=utf-8'));
//                 curl_setopt($ch, CURLOPT_RETURNTRANSFER, FALSE);
//                 curl_setopt($ch, CURLOPT_HEADER, FALSE);
//                 curl_setopt($ch, CURLOPT_POST, TRUE);
//                 curl_setopt($ch, CURLOPT_POSTFIELDS, $fields);
//                 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
//                 $responsee = curl_exec($ch);
//                 curl_close($ch);
//             }
//         }
//         $query = "SELECT * FROM bookings WHERE id = '$booking_id'";
//         $res = mysqli_query($conn, $query);
//         $num = mysqli_num_rows($res);
//         $row = mysqli_fetch_array($res);
//         $user_id = $row['user_id'];
//         $title = "Your Booking Has Been". $_REQUEST['status'];
//         $content = "Booking (Id: " . $booking_id . "), From " .  $row['booking_from'] . ", to " .  $row['booking_to'] . " has been ". $_REQUEST['status'];
        
//         $query = "SELECT fcm_id FROM users WHERE id='$driver_id'";
//         $res = mysqli_query($conn, $query);
//         $num = mysqli_num_rows($res);
//         $row = mysqli_fetch_array($res);
//         $onesignalid = $row['fcm_id'];
//         $onesignal_id = array("$onesignalid");
        
//         $content      = array(
//             "en" => $content,
//         );
//         $heading      = array(
//             "en" => $title,
//         );
//         $fields = array(
//             'app_id' => "0064ad4d-3f3e-4863-b943-901dd3a0116e",
//             'include_player_ids' => $onesignal_id,
//             'data' => array("foo" => "bar"),
//             'contents' => $content,
//             'heading' => $heading
//         );
//         $fields = json_encode($fields);
        
//         $ch = curl_init();
//         curl_setopt($ch, CURLOPT_URL, "https://onesignal.com/api/v1/notifications");
//         curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json; charset=utf-8'));
//         curl_setopt($ch, CURLOPT_RETURNTRANSFER, FALSE);
//         curl_setopt($ch, CURLOPT_HEADER, FALSE);
//         curl_setopt($ch, CURLOPT_POST, TRUE);
//         curl_setopt($ch, CURLOPT_POSTFIELDS, $fields);
//         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
//         $responsee = curl_exec($ch);
//         curl_close($ch);
        
//     } else {
//         $response['status'] = False;
//         $response['message'] = 'Not Updated';
//         echo json_encode($response);
//     }
    
// }