FM / fc

/home/desid573/public_html/fc_api

Name	Size	Mode	Actions
lib/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
appoff.php	4782	0644	edit dl rm
booking.php	17680	0644	edit dl rm
booking_edit_request.php	10196	0644	edit dl rm
cancel_booking.php	6064	0644	edit dl rm
check_open.php	0	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2983	0644	edit dl rm
confirm_booking_change.php	6305	0644	edit dl rm
confirm_booking_change_ajax.php	6696	0644	edit dl rm
contact_us_mail.php	890	0644	edit dl rm
copy_account_to_homekey.php	4338	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
emailConfirmReset.php	486	0644	edit dl rm
error_log	30761021	0644	edit dl rm
family-cab_small.jpg	98853	0644	edit dl rm
generate_credit.php	3098	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getuser_byid.php	2341	0644	edit dl rm
getuser_bymail.php	3419	0644	edit dl rm
get_all_booking.php	779	0644	edit dl rm
get_booking_bybooking_id.php	813	0644	edit dl rm
get_booking_byuser.php	1057	0644	edit dl rm
get_booking_status.php	3246	0644	edit dl rm
get_completed_bookings.php	710	0644	edit dl rm
get_ETA.php	5013	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1537	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
get_price.php	41	0644	edit dl rm
get_recipes.php	6361	0644	edit dl rm
get_request_details.php	976	0644	edit dl rm
get_TE.php	1217	0644	edit dl rm
index.php	13722	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	8679	0644	edit dl rm
noteconfirm.php	9228	0644	edit dl rm
off.php	2854	0644	edit dl rm
passwordResetLink.php	5170	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2147	0644	edit dl rm
reset_email.php	1755	0644	edit dl rm
reset_phone.php	5717	0644	edit dl rm
test2.php	0	0644	edit dl rm
test_222.php	845	0644	edit dl rm
update_api.php	5910	0644	edit dl rm
update_api_on_mail.php	4723	0644	edit dl rm
validatecode.php	1094	0644	edit dl rm
validatephone.php	1034	0644	edit dl rm

Edit: /home/desid573/public_html/fc_api/confirm_booking_change.php (6305B)

<?php

require("lib/config.php");

$request_id = $_REQUEST["request_id"];

$sql = "SELECT * FROM `booking_edit_request` WHERE id = ".$request_id;

$query = $conn->query($sql);
if(!$query) {
    echo $conn->error;
    
}

if($query->num_rows > 0) {
    
    $result = $query->fetch_assoc();
    $bid = $result["bid"];
    
    $sql = "SELECT * FROM booking WHERE id = '".$bid."'";
    
    $booking = $conn->query($sql);
    
    if($booking->num_rows > 0) {
        
        $row = $booking->fetch_assoc();
        
        $detailsArray = [];
        
        $spatula_id = $row['spatula_id'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		
        		$xero = $row['xero_inv'];
        		if($xero == "") {
			$xero = "none";
			}
        		array_push($detailsArray, "Date/Time: ".$row['booking_date']." ".$row['booking_time']);
  
        		array_push($detailsArray, "Pickup: ".$row['pickup_addr']);
        		array_push($detailsArray, "Dropoff: ".$row['pickoff_addr']);
        		if($row['flight_num'] != "") {
        		array_push($detailsArray, "Flight :".$row['flight_num']." + ".$row['mins_to']."mins");
        		}
        		array_push($detailsArray, "Book Pax: ".$row['book_pax']);
        		array_push($detailsArray, "Book RF: ".$row['book_rf']);
        		array_push($detailsArray, "Book FF: ".$row['book_ff']);
        		array_push($detailsArray, "Book B: ".$row['book_b']);
        		array_push($detailsArray, "Luggage: ".$row['luggage']);
        		$assignedDriver = $row["driver"];
        		$quote = $row['quote'];
        		$cid = $row['cid'];
        		$result1 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
			$row = mysqli_fetch_assoc($result1);
			array_unshift($detailsArray, "Name: ".$name = $row['name']);
			$email = $row['email'];
			$phone = $row['mobile'];
			error_log($conn->error);
			
        
        
    }
    
    
} 
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
      
    <title>Confirm Edit Request</title>

</style>
</head>
<body>

<div class="container">
    <div id="over">
    <span class="Centerer"></span>
    <img class="Centered" src="family-cab_small.jpg" style="max-height:60px;">
    </div>
    <h3>Current Booking</h3>
    <div class="row">
        <div class="col-xs-12">
            
            <?php
            foreach($detailsArray as $line) {
                
                echo $line."<br>";
                
            }
            ?>
            </div>
        
    </div>
    <h3>Changes Requested</h3>
            <div class="row">
                <div class="col-xs-12">
                    <?php
                    
                    $array = ["id", "bid", "approved"];
                    
                    if($result["approved"] == 0) {
                        
                        foreach($result as $key => $value) {
                            if($value != "" & array_search($key, $array) === false) {
                            echo "<label for='$key'>$key</label><input class='form-control' type='text' id='$key' value='$value'>";
                            }
                            
                        }
                        
                    } else {
                        $request_id = "none";
                        echo "Booking Already Updated";
                    }
                    
                    ?>
                    
                </div>
                
            </div>
            
            
<div class="row" style="margin-top:10px;">
            <div class="col-xs-12">
                
                    <input type="button" class="btn-block btn btn-primary"  name="button" id="checkButton" value="Confirm Changes">
            </div>
</div>
<div class="col-xs-12 col-md-12 no-padding" style="text-align:center">
 
 On Click  <span style="color:#FF0000;font-size: 150%;text-align: center;" id="test"></span><br>
  </div>
<br><br>

</div>

$("#checkButton").on("click", function() {
   
   var request_id = "<?php echo $request_id ?>";
   
   if(request_id != "none") {
   
        data = {request_id: request_id};
        console.log(data);
        $.ajax({
                type: "POST",
                url: "confirm_booking_change_ajax.php",
                data: data, 
                dataType: 'json',
                success: function (data) {
        
        
                        console.log(data);
                        if(data.status == "ok"){
                        $("#test").text(data.message);
                        $("#test").attr('style', 'color:#00FF00;font-size: 150%;text-align: center;background-color: #ffffff;');
                        dispatch(driver_id, data.id);  
                        } else {
                        $("#test").text(data.message);
                        $("#test").attr('style', 'color:#FF0000;font-size: 150%;text-align: center;background-color: #ffffff;');
                        }
                        
                }
                       
                        
                        
        })   
        
   } else {
       
       alert("already updated");
   }
    
    
});

</script>
</body>
</html>

query($sql); if(!$query) { echo $conn->error; } if($query->num_rows > 0) { $result = $query->fetch_assoc(); $bid = $result["bid"]; $sql = "SELECT * FROM booking WHERE id = '".$bid."'"; $booking = $conn->query($sql); if($booking->num_rows > 0) { $row = $booking->fetch_assoc(); $detailsArray = []; $spatula_id = $row['spatula_id']; $quote_km = $row['quote_km']; $quote_time = $row['quote_time']; $xero = $row['xero_inv']; if($xero == "") { $xero = "none"; } array_push($detailsArray, "Date/Time: ".$row['booking_date']." ".$row['booking_time']); array_push($detailsArray, "Pickup: ".$row['pickup_addr']); array_push($detailsArray, "Dropoff: ".$row['pickoff_addr']); if($row['flight_num'] != "") { array_push($detailsArray, "Flight :".$row['flight_num']." + ".$row['mins_to']."mins"); } array_push($detailsArray, "Book Pax: ".$row['book_pax']); array_push($detailsArray, "Book RF: ".$row['book_rf']); array_push($detailsArray, "Book FF: ".$row['book_ff']); array_push($detailsArray, "Book B: ".$row['book_b']); array_push($detailsArray, "Luggage: ".$row['luggage']); $assignedDriver = $row["driver"]; $quote = $row['quote']; $cid = $row['cid']; $result1 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'"); $row = mysqli_fetch_assoc($result1); array_unshift($detailsArray, "Name: ".$name = $row['name']); $email = $row['email']; $phone = $row['mobile']; error_log($conn->error); } } ?> Confirm Edit Request

Current Booking

"; } ?>

Changes Requested

$value) { if($value != "" & array_search($key, $array) === false) { echo "$key"; } } } else { $request_id = "none"; echo "Booking Already Updated"; } ?>

On Click