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/noteconfirm.php (9228B)

<?php   
	require("lib/config.php");
    	$sql = "SELECT * FROM `booking` where id = '".$_GET['ref']."'";
	$result = $conn->query($sql);
	
	if ($result->num_rows > 0) {
	while($row_details = $result->fetch_assoc()) {
		$booking_detail[] = $row_details;
	}
	$sql = "SELECT * FROM `customers` where id = '".$booking_detail[0]['cid']."'";
	$result = $conn->query($sql);
	if ($result->num_rows > 0) 
	{
		while($row_detail = $result->fetch_assoc()) 
		{
			$booking_details[] = $row_detail;
		}
		
	}
	
	$name = $booking_details[0]['name'];
	$date = $booking_detail[0]['booking_date'];
	$time = $booking_detail[0]['booking_time'];
	$time = date("g:i A", strtotime($time));
	$datetime = "$date $time";
	$pickup = $booking_detail[0]['pickup_addr'];
	$dropoff = $booking_detail[0]['pickoff_addr'];
	$spatulaid = $booking_detail[0]['spatula_id'];
	$type = $booking_detail[0]['type'];
	$referenceNotId = $booking_detail[0]['reference'];
	if($spatulaid == "") {
	    $spatulaid = "none";
	}
	
	}
	
?>
<!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>SMS Sender</title>

<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">

<style>
        #map {
            height:300px;
        }
        body{
            background-color: #ffffff;
        }
        *
{
    padding: 0;
    margin: 0;
}
#over
{
    //position:absolute;
    width:100%;
    height:100%;
    text-align: center; /*handles the horizontal centering*/
}
/*handles the vertical centering*/
.Centerer
{
    display: inline-block;
    height: 100%;
    vertical-align: middle;
}
.Centered
{
    display: inline-block;
    vertical-align: middle;
}

</style>
</head>
<body>
<div id="over">
    <span class="Centerer"></span>
    <img class="Centered" src="family-cab_small.jpg" style="max-height:60px;">
    
<div class="container">
    
    </div>
            <div class="row">
                <div class="col-xs-12 col-md-6 no-padding">
                    <input type="text" required data-validation="required"  class="form-control" placeholder="Reference" value="<?=$name?>" name="name" id="reference" readonly>
                    <input type="text" required data-validation="required"  class="form-control" placeholder="Phone" value="<?=$datetime?>" name="datetime" id="phone" readonly>
                    <input type="text" required data-validation="required"  class="form-control" placeholder="Type" value="<?=$pickup?>" name="pickup" id="type" readonly>
                    <input type="text" required data-validation="required"  class="form-control" placeholder="Type" value="<?=$dropoff?>" name="dropoff" id="type" readonly>
                    
                </div>
                
            </div>
            
            <div class="row">
            <div class="col-xs-12 col-md-6 no-padding">
                
                    <input type="button" name="myButton" style="background: rgb(2, 117, 216) none repeat scroll 0% 0%;padding-top:10px;color:#FFFFFF;" class="btn-block col-xs-12 col-md-6  name="button id="button" value="Submit">
            </div>
</div>
<div class="row">
            <div class="col-xs-12 col-md-6 no-padding">
                
                    <input type="button" name="checkButton" style="background: rgb(2, 117, 216) none repeat scroll 0% 0%;padding-top:10px;color:#FFFFFF;" class="btn-block col-xs-12 col-md-6  name="button id="checkButton" value="Check if Sent">
            </div>
</div>
<div class="col-xs-12 col-md-6 no-padding" style="text-align:center">
 Current Status <span style="" id="test2"></span><br>
 On Click  <span style="color:#FF0000;font-size: 150%;text-align: center;" id="test"></span><br>
  </div>
<br><br>
<div class="row">
        <div class="col-lg-12 text-center">
        <br><br>

<?php $result = $conn->query("SELECT id, driver FROM desid573_eway_codes.drivers");
            
            echo "Dispatch to: &nbsp <select id='driver_id' name='id'>";

while ($row = $result->fetch_assoc()) {

unset($id, $name);
                  $id = $row['id'];
                  $name = $row['driver']; 
                  echo '<option value="'.$id.'">'.$name.'</option>';

}

echo "</select>"; ?>
    <br><br>
    
    
        
        <input type="button" name="dispatch" style="background: rgb(2, 117, 216) none repeat scroll 0% 0%;padding-top:10px;color:#FFFFFF;" class="btn-block col-xs-12 col-md-6" id="dispatch" value="Dispatch">
        
            Status  <span style="color:#FF0000;font-size: 150%;text-align: center;" id="dispatchtxt"></span><br>
        <br>
    </div>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>

var reference = <?=$_GET['ref']?>;
var spat_ref = "<?php echo $spatulaid ?>";
var type = "<?=$type?>";
var ref = <?=$referenceNotId?>;
function checkSent() {

$.post("confirmsend.php", {ref: reference, check: "check"}, function (data) {
                console.log(data);
                if(data != "no"){
                $("#test2").text(data);
                $("#test2").attr('style', 'color:#f26f18;font-size: 150%;text-align: center;');
                }
                if(data == "no"){
                $("#test2").text("NOT CONFIRMED");
                $("#test2").attr('style', 'color:#FF0000;font-size: 150%;text-align: center;');
                }
                })
                
}

$(document).ready(function(){
checkSent();
})
$("#checkButton").click(function(){
checkSent();
})

$("#button").click(function(){

var reference = <?=$_GET['ref']?>;

console.log(reference);

$.post("confirmsend.php", {ref: reference, check: "send"}, function (data) {
                console.log(data);
                if(data == "yes"){
                $("#test").text("Processed");
                $("#test").attr('style', 'color:#00FF00;font-size: 150%;text-align: center;background-color: #ffffff;');
                }
                if(data != "yes"){
                $("#test").text("Error");
                $("#test").attr('style', 'color:#FF0000;font-size: 150%;text-align: center;background-color: #ffffff;');
                }
               
                
                
})
})
$("#dispatch").click(function(){

var driver_id = $("#driver_id").val();

if(spat_ref != "none") {

dispatch(driver_id, spat_ref);  
        
        
    } else {
        
        data = {type: type, ref: ref};
        console.log(data);
        $.ajax({
                type: "POST",
                url: "../new_spatula_job.php",
                data: data, 
                dataType: 'json',
                success: function (data) {
        
        
                        console.log(data);
                        if(data.status == "OK"){
                        $("#dispatchtxt").text("Job Created");
                        $("#dispatchtxt").attr('style', 'color:#00FF00;font-size: 150%;text-align: center;background-color: #ffffff;');
                        dispatch(driver_id, data.id);  
                        } else {
                        $("#dispatchtxt").text("Error creating Job");
                        $("#dispatchtxt").attr('style', 'color:#FF0000;font-size: 150%;text-align: center;background-color: #ffffff;');
                        }
                        
                }
                       
                        
                        
        })  
        
    }
})

function dispatch(driver_id, spat_ref) {

$.post("../dispatch.php", {driver_id: driver_id, spat_ref: spat_ref}, function (data) {
                console.log(data);
                if(data == "OK"){
                        $("#dispatchtxt").text("Dispatched");
                        $("#dispatchtxt").attr('style', 'color:#00FF00;font-size: 150%;text-align: center;background-color: #ffffff;');
                        } else {
                        $("#dispatchtxt").text("Error dispatching");
                        $("#dispatchtxt").attr('style', 'color:#FF0000;font-size: 150%;text-align: center;background-color: #ffffff;');
                        }
               
                
                
})
}

</script>

</body>
</html>

query($sql); if ($result->num_rows > 0) { while($row_details = $result->fetch_assoc()) { $booking_detail[] = $row_details; } $sql = "SELECT * FROM `customers` where id = '".$booking_detail[0]['cid']."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_detail = $result->fetch_assoc()) { $booking_details[] = $row_detail; } } $name = $booking_details[0]['name']; $date = $booking_detail[0]['booking_date']; $time = $booking_detail[0]['booking_time']; $time = date("g:i A", strtotime($time)); $datetime = "$date $time"; $pickup = $booking_detail[0]['pickup_addr']; $dropoff = $booking_detail[0]['pickoff_addr']; $spatulaid = $booking_detail[0]['spatula_id']; $type = $booking_detail[0]['type']; $referenceNotId = $booking_detail[0]['reference']; if($spatulaid == "") { $spatulaid = "none"; } } ?> SMS Sender

Current Status
On Click

query("SELECT id, driver FROM desid573_eway_codes.drivers"); echo "Dispatch to: "; ?>

Status