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';
$conn->set_charset("utf8");

if (!isset($_REQUEST['LOCAL'])) {
    
    $user_id = $_REQUEST['vendor_id'];
    $lat1 = $_REQUEST['lat1'];
    $lng1 = $_REQUEST['lng1'];
    $lat2 = $_REQUEST['lat2'];
    $lng2 = $_REQUEST['lng2'];
    $origin = $_REQUEST['origin'];
    $destination = $_REQUEST['destination'];
    $pickup_date = $_REQUEST['pickup_date'];
    $drop_date = $_REQUEST['drop_date'];
    $pickup_time = $_REQUEST['pickup_time'];
    $drop_time = $_REQUEST['drop_time'];
    $pickup_address = $_REQUEST['origin'];
    $drop_address = $_REQUEST['destination'];
    $distance = $_REQUEST['distance'];
    $trip_type = $_REQUEST['trip_type'];
    $cab_type = $_REQUEST['cab_type'];
    $total_amount = $_REQUEST['total_amount'];
    $pay_amount = $_REQUEST['pay_amount'];
    $toll_tax = $_REQUEST['toll_tax'];
    $vendor_commission = $_REQUEST['vendor_commission'];
    $tax = $_REQUEST['tax'];
    $driver_allowance = $_REQUEST['driver_allowance'];
    
    $cust_name = $_REQUEST['customer_name'];
    $cust_mob = $_REQUEST['customer_number'];
    $number_of_passenger = $_REQUEST['no_of_people'];
    $booking_days = $_REQUEST['booking_days'];
    $remark = $_REQUEST['remark'];
    
    $wallet_amount = $_REQUEST['wallet_amount'];
    
    $response['msg']['etat'] = 2;
    $response['msg']['message'] = 'Booking Unsuccefull';
    
    
    $sql="select * from users where contact='".$cust_mob."' "; 
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) 
    {
        // output data of each row
        $row = $result->fetch_assoc(); 
        
        $cust_id = $row['id'];
        
    } else {
        $sql="insert into users (contact,name) values('$cust_mob','$cust_name')";
        
        $query=mysqli_query($conn,$sql);
        $cust_id = $conn->insert_id;
        if($query){
            $cust_id = $conn->insert_id;
        }else{
            echo mysqli_error($conn);
        }
    }
    
    
    $sql = "INSERT INTO `bookings` (`user_id`,`post_by_id`,`vendor_id`,`booking_from`, `booking_to`, `pickup_date`, `drop_date`,
    `pickup_time`, `drop_time`, `cab_type`, `trip_type`, `price`, `pickup_address`, `drop_add`, `status`,
    `distance`, `latitude_from`,`longitude_from`,`latitude_to`,`longitude_to`
    ,`driver_allowance`,`tax`,`vendor_commission`,`toll_tax`,`cust_name`,`number_of_passenger`,`booking_days`,`remark`,`cust_mob`,`booking_type`
    ) 
    VALUES ('$cust_id','$user_id','$user_id','$origin', '$destination', '$pickup_date', '$drop_date', '$pickup_time', '$drop_time',
    '$cab_type', '$trip_type', '$total_amount','$pickup_address', '$drop_address', 'booked',
    '$distance', '$lat1',  '$lng1', '$lat2', '$lng2'
    ,'$driver_allowance','$tax','$vendor_commission','$toll_tax','$cust_name','$number_of_passenger','$booking_days','$remark','$cust_mob','Vendor App'
    )";
    
    if ($conn->query($sql) == true) {
        $booking_id = $conn->insert_id;
        $ORDER_ID = $user_id . time() . uniqid(mt_rand(), true);
        
        $sql = "insert into payment_log(booking_id,txn_id,txn_amount,txn_status) values('$booking_id','$ORDER_ID','$pay_amount',1)";
        $query=mysqli_query($conn,$sql);
        $response['msg']['etat'] = 1;
        $response['msg']['message'] = 'Booking Succefully Sent!';
        echo json_encode($response);
        
        $title = "New Booking!";
        $content = "New Booking (Id: " . $booking_id . "), From " .  $pickup_address . ", to " .  $drop_address . " has been created. \n You can check the Booking in Your Ayan Admin App!";
        $content      = array("en" => $content,);
        $heading      = array( "en" => $title,);
        $hashes_array = array();
        array_push($hashes_array, array(
            "id" => "like-button",
            "text" => "Like",
            "icon" => "http://credinopos.in/chandelcabs/images/logo_v1.png",
            "url" => "http://credinopos.in/chandelcabs/"
        ));
        array_push($hashes_array, array(
            "id" => "like-button-2",
            "text" => "Like2",
            "icon" => "http://credinopos.in/chandelcabs/images/logo_v1.png",
            "url" => $link
        ));
        $fields = array(
            'app_id' => "f233ae3e-a403-46dc-8dee-a3c2f4681f9a",
            'included_segments' => array( 'All' ),
            'data' => array( "foo" => "bar" ),
            'contents' => $content,
            'headings' => $heading,
            'android_sound'=>'alarm',
            'android_channel_id' =>"3a296c7c-32b2-457c-a348-3c1039dc0bb3",
            'large_icon'=>'http://credinopos.in/chandelcabs/images/logo_v1.png',
            'big_picture' => $image,
            'isAndroid'=>true,
            'priority'=>10,
            'isChromeWeb'=>false,
            'web_buttons' => $hashes_array
        );
        
        $fields = json_encode($fields);
        print("\nJSON sent:\n");
        print($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',
            'Authorization: Basic YTlkOWRiMDktNzFjNC00ZGFiLThjMTUtNmI5OGYwYTdmNzMz'
        ));
        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);
        
        curl_exec($ch);
        curl_close($ch);
        
        
        $sql = "select bookings.id,bookings.booking_from,bookings.booking_to,bookings.pickup_date,bookings.pickup_time,users.contact,users.name from bookings,users where bookings.id=$booking_id and bookings.user_id=users.id";
        $result = $conn->query($sql);
        
        if ($result->num_rows > 0) {
            
            // output data of each row
            $row = $result->fetch_assoc();
            $contact = $row['contact'];
            // $done=true;
            
            $msg = "Dear " . $row['name'] . ", your Booking ID " . $row['id'] . " on" . $row['pickup_date'] . " @ " . $row['pickup_time'] . " from " . $row['booking_from'] . " to " . $row['booking_to'] . " is confirmed. Driver and Cab details will be sent before 1 hr. of pickup time. Thanks For Booking, Ayan Cab.";
            $paramArr['postData']['mobiles'] = $row['contact'];
            
            $api_key = '461D98E6FF1061';
            $from = 'AYANTX';
            $template_id = '1207164061525497297';
            //TODO change template id from lolo
            //Submit to server
            
            $ch = curl_init();
            curl_setopt($ch, CURLOPT_URL, "http://sms.creativedigitalinfotech.com/app/smsapi/index.php");
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            curl_setopt($ch, CURLOPT_POST, 1);
            curl_setopt($ch, CURLOPT_POSTFIELDS, "key=" . $api_key . "&campaign=30&routeid=30&type=text&contacts=" . $contact . "&senderid=" . $from . "&msg=" . $msg . "&template_id=" . $template_id);
            curl_exec($ch);
            curl_close($ch);
            
            $title = "New Booking!";
            
        }
        
    }
    
    
}else{
    $response['msg']['etat'] = 0;
    $response['msg']['message'] = 'Booking NOT Sent!';
    echo json_encode($response);
}