FM / book.familycab.com.au

/home/desid573/book.familycab.com.au/

/home/desid573/book.familycab.com.au

Name	Size	Mode	Actions
.well-known/	-	0755	rm
1ifeopl/	-	0755	rm
1vtgpkl/	-	0755	rm
1xlhcgu/	-	0755	rm
acimluq/	-	0755	rm
agbqyik/	-	0755	rm
ajdp1oe/	-	0755	rm
ar1qkuw/	-	0755	rm
assets/	-	0755	rm
awsjqb1/	-	0755	rm
b1pmevt/	-	0755	rm
brucyjx/	-	0755	rm
bwtazo1/	-	0755	rm
cfiqthx/	-	0755	rm
cgi-bin/	-	0755	rm
ckbhyn1/	-	0755	rm
cmql1xt/	-	0755	rm
cpqtvye/	-	0755	rm
cyuikhw/	-	0755	rm
czoympn/	-	0755	rm
dpe1msh/	-	0755	rm
e1aduzo/	-	0755	rm
ecn1kzo/	-	0755	rm
eisjtoh/	-	0755	rm
ekutqaf/	-	0755	rm
eowzyaj/	-	0755	rm
esfrdjo/	-	0755	rm
eway-rapid-php-master/	-	0755	rm
ewbclgx/	-	0755	rm
faezcdi/	-	0755	rm
fc1eyqm/	-	0755	rm
fehmgn1/	-	0755	rm
fjkiwpb/	-	0755	rm
fkzmswv/	-	0755	rm
fowmltn/	-	0755	rm
fpeoas1/	-	0755	rm
fqwcrxh/	-	0755	rm
fwbplmu/	-	0755	rm
fxlwiuo/	-	0755	rm
gcuweka/	-	0755	rm
gihfzex/	-	0755	rm
gocpwtk/	-	0755	rm
gpzkqnd/	-	0755	rm
hazeqlx/	-	0755	rm
hbzyflo/	-	0755	rm
hlijrak/	-	0755	rm
invoice/	-	0755	rm
iobvhqs/	-	0755	rm
iukswev/	-	0755	rm
izlvoyc/	-	0755	rm
k1jhpry/	-	0755	rm
kbuhaft/	-	0755	rm
kdjculq/	-	0755	rm
khsempt/	-	0755	rm
kiptrxl/	-	0755	rm
kpmiayb/	-	0755	rm
ksyi1wf/	-	0755	rm
kuziqsr/	-	0755	rm
kvhomft/	-	0755	rm
kvspioh/	-	0755	rm
kyazxvb/	-	0755	rm
l1mdfzg/	-	0755	rm
lcbqay1/	-	0755	rm
libmaoy/	-	0755	rm
lmkcady/	-	0755	rm
ltjvghp/	-	0755	rm
lwkybqp/	-	0755	rm
lxwuhba/	-	0755	rm
lxzsonj/	-	0755	rm
lyamwrd/	-	0755	rm
mcyopga/	-	0755	rm
mlypcnw/	-	0755	rm
mnujfkg/	-	0755	rm
msuvgzx/	-	0755	rm
mvowifa/	-	0755	rm
nebu1ig/	-	0755	rm
ngb1lri/	-	0755	rm
ngrfdyv/	-	0755	rm
nhxemyo/	-	0755	rm
njgetuh/	-	0755	rm
nraew1v/	-	0755	rm
obetkgw/	-	0755	rm
ohygxje/	-	0755	rm
optvuxe/	-	0755	rm
ouacyrp/	-	0755	rm
ouazltg/	-	0755	rm
pbyvsdh/	-	0755	rm
pckvltu/	-	0755	rm
pcxdgnk/	-	0755	rm
pdd/	-	0755	rm
pibv1jm/	-	0755	rm
pmndzux/	-	0755	rm
pnebgzw/	-	0755	rm
psn1gcb/	-	0755	rm
ptxqyma/	-	0755	rm
pwcsebh/	-	0755	rm
pwdmlg1/	-	0755	rm
px1dcng/	-	0755	rm
qfwbhay/	-	0755	rm
qncasyj/	-	0755	rm
qrcmnpk/	-	0755	rm
qrocy1l/	-	0755	rm
rhcnpij/	-	0755	rm
rmtpqko/	-	0755	rm
rvliyco/	-	0755	rm
sbx1cpv/	-	0755	rm
sjenvyi/	-	0755	rm
sm1avot/	-	0755	rm
spjtgqa/	-	0755	rm
swtrvog/	-	0755	rm
t1cfjix/	-	0755	rm
tdpkgnw/	-	0755	rm
tjmdfnu/	-	0755	rm
tn1hlkq/	-	0755	rm
tpdwaqu/	-	0755	rm
tqaemlu/	-	0755	rm
tqyxunl/	-	0755	rm
varpmnh/	-	0755	rm
vgowufb/	-	0755	rm
vjrq1ip/	-	0755	rm
vkxfdjo/	-	0755	rm
vnqmzk1/	-	0755	rm
vptbcoe/	-	0755	rm
vtouxfl/	-	0755	rm
vtwlfym/	-	0755	rm
vxp1ksj/	-	0755	rm
w1mcglu/	-	0755	rm
warqlcu/	-	0755	rm
wfckxgu/	-	0755	rm
wgdlrkp/	-	0755	rm
wnbpquk/	-	0755	rm
wnkvyli/	-	0755	rm
wtmszjf/	-	0755	rm
wxmghvb/	-	0755	rm
wygopan/	-	0755	rm
x1nplhc/	-	0755	rm
xaowdes/	-	0755	rm
xhowiec/	-	0755	rm
xhrijfn/	-	0755	rm
xl1aqrg/	-	0755	rm
xlcpwtr/	-	0755	rm
xltyzbe/	-	0755	rm
xogw1qk/	-	0755	rm
xswglcp/	-	0755	rm
xzhklj1/	-	0755	rm
yfzbear/	-	0755	rm
ygeudjh/	-	0755	rm
ygvrifj/	-	0755	rm
ylnauij/	-	0755	rm
ynwzeit/	-	0755	rm
ys1jxwo/	-	0755	rm
yvmbqag/	-	0755	rm
yxanzgs/	-	0755	rm
yxzeaf1/	-	0755	rm
z1dlsxy/	-	0755	rm
zbus1om/	-	0755	rm
zelwjnd/	-	0755	rm
zfdeaxm/	-	0755	rm
zjcryep/	-	0755	rm
zmbkt1s/	-	0755	rm
zodpbuf/	-	0755	rm
ztqg1sb/	-	0755	rm
.htaccess	281	0644	edit dl rm
10.php	1941	0644	edit dl rm
11.php	1176	0644	edit dl rm
22.php	9106	0644	edit dl rm
array.php	2141	0644	edit dl rm
a_name_address.php	959	0644	edit dl rm
brisbaneInvoice.php	11845	0644	edit dl rm
class.phpmailer.php	80046	0644	edit dl rm
class.pop3.php	10385	0644	edit dl rm
class.smtp.php	24586	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
driverInvoice.php	12708	0644	edit dl rm
driverlocation.php	14585	0644	edit dl rm
eCrypt.js	68424	0644	edit dl rm
edit.php	780	0644	edit dl rm
eway-rapid-php-master.zip	57270	0644	edit dl rm
eWay.php	42697	0644	edit dl rm
family-cab_small.jpg	98853	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
index.php	198358	0644	edit dl rm
index1apr2019.php	92844	0644	edit dl rm
index3.php	60677	0644	edit dl rm
index4.php	91500	0644	edit dl rm
index15thMay.php	92640	0644	edit dl rm
indexJune10.php	93053	0644	edit dl rm
indextest.php	91391	0644	edit dl rm
indexTraffic.php	86040	0644	edit dl rm
index_preSydney.php	60350	0644	edit dl rm
index_sydney.php	74126	0644	edit dl rm
melbAuditReport.php	34176	0644	edit dl rm
melbreport.php	7758	0644	edit dl rm
monthly.php	12046	0644	edit dl rm
perthAuditReport.php	34918	0644	edit dl rm
perthReport.php	7587	0644	edit dl rm
pre-sydneyquote.php	39158	0644	edit dl rm
promo.php	765	0644	edit dl rm
qldreport.php	7544	0644	edit dl rm
quote.php	52358	0644	edit dl rm
quote2.php	38831	0644	edit dl rm
quote_sydney.php	51912	0644	edit dl rm
report.php	10447	0644	edit dl rm
search.php	854	0644	edit dl rm
serialize.php	132	0644	edit dl rm
style.json	1014	0644	edit dl rm
sydneydispatch.php	12177	0644	edit dl rm
sydneyreport.php	7758	0644	edit dl rm
test.php	3851	0644	edit dl rm
thankyou.php	32003	0644	edit dl rm
wp-cron-cwhi.php	1659	0644	edit dl rm

Edit: /home/desid573/book.familycab.com.au/sydneydispatch.php (12177B)

<?php
error_reporting(E_ALL ^ E_NOTICE ^ E_DEPRECATED ^ E_STRICT);
date_default_timezone_set("Australia/Sydney");

$dt = new DateTime();
    $dt->setTimestamp($period);
    $periodString = date_format($dt, "jS M, Y H:i a");
    $dt = new DateTime();
    $dt->setTimestamp($periodLower);
    $periodStringLower = date_format($dt, "jS M, Y H:i a");

require_once('class.phpmailer.php');
require_once('class.smtp.php');
$dbhost = "localhost";
	    $dbuser = "desid573_famcab";
	    $dbpass = "C]+6wQySxov(";
	    $dbname = "desid573_familycab";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    date_default_timezone_set("Australia/Perth");
	    
	    $yesterday = "Last ".$periodString." Days";
	    
	    $lastDriver = "";
	    $lastDriverTotal = "";
	    $lastDriverTollTotal = "";
	    
	    if($_GET["date"] == "") {
	        $chosen = "Today";
	    } else {
	        $chosen = $_GET["date"];
	    }
	    
	    $jobDate = date("d M, Y", strtotime($chosen));

$query1 = "SELECT * FROM jobs WHERE job_city = 'sydney' AND job_date = '".$jobDate."'";
	error_log($query1);
        $result = mysqli_query($conn, $query1);
        if(!$result) {
            
            error_log("jobs error".$conn->error);
        }
         $array = array();
	    $status = "";
	    while($rowSQL = mysqli_fetch_assoc($result)){
	     $time = date("h:i a", strtotime($rowSQL["job_time"]));
	     
	     if($rowSQL["job_dropoff"] == "cancelled") {
	         $status = "cancelled";
	     } else {
	         $status = "";
	     }
	     $array[] = ["name" => $rowSQL["job_name"], "time" => $time, "pickup" => $rowSQL["job_pickup"], "dropoff" => $rowSQL["job_dropoff"], "spat_ref" => $rowSQL["spat_ref"], "driver" => $rowSQL["driver"], "status" => $status];  
	        
	    }
        
        $dbhost = "localhost";
	    $dbuser = "desid573_fam_app";
	    $dbpass = "TW#7CCqKReDn";
		$dbname = "desid573_famcab_api";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    
	   
        $appDate = date("Y-m-d", strtotime($chosen));
        
        $query2 = "SELECT * FROM booking WHERE type='SA' AND booking_date = '".$appDate."'";
        error_log($query2);
        $result2 = mysqli_query($conn, $query2);
        if(!$result2) {
            
            error_log("booking error".$conn->error);
        }
        while($rowSQL = mysqli_fetch_assoc($result2)){
	     
	     $cust = "SELECT * FROM customers WHERE id = ".$rowSQL["cid"];
	     $custQuery = mysqli_query($conn, $cust);
	     $custRow = mysqli_fetch_assoc($custQuery);
	     $name = $custRow["name"];
	     $time = date("h:i a", strtotime($rowSQL["booking_time"]));
	     $array[] = ["name" => $name, "time" => $time, "pickup" => $rowSQL["pickup_addr"], "dropoff" => $rowSQL["pickoff_addr"], "spat_ref" => $rowSQL["spatula_id"], "driver" => $rowSQL["driver"], "status" => $rowSQL["status"]];
	        
	    }
	    
	    usort($array, function($a, $b) {
            return $a['time'] > $b['time'];
            });
	    
	    //print_r($array);
        $lastDriver = "";
        $quotetotal = 0;
        $acttotal = 0;
       ?>
       
       <!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>Daily Report</title>
    <link async href='../assets/css/bootstrap.min.css' rel='stylesheet'>
       <style type='text/css'>
       table {
            
            display: block;
            border-collapse: collapse;
            
          
        }
        tr {
        height:30px;
        
        
        }
        td {
        padding:3px;
        }
       
        .hideextra {
        
        white-space: nowrap; 
        overflow: hidden; 
        text-overflow:ellipsis; 
            
            
        }
        table tr:nth-child(odd) td{
        background-color: #d3d3d3; 
	}
table tr:nth-child(even) td{
	}
	.bgloader {
        display: none;
        position: fixed;
        width: 100%;
        height: 100%;
        background-color:#f26f18;
        opacity : 0.4;
        z-index: 100;
        }
        .loader {
        display: none;
        position: fixed;
        left: 50%;
        top: 50%;
        z-index: 101;
        margin: -60px 0 0 -60px;
            border: 16px solid #f3f3f3; /* Light grey */
            border-top: 16px solid #000080; /* Blue */
            border-radius: 50%;
            width: 120px;
            height: 120px;
            animation: spin 2s linear infinite;
        }
        @keyframes spin {
            0% { transform: rotate(0deg); }
            100% { transform: rotate(360deg); }
            
        }
       
       </style>
       </head>
       <body>
       <div class='loader'></div>
	<div class='bgloader'></div>
	<div class='bootstrap-iso'>
	<div class='container'>
       <h2>Dispatch report In Sydney</h2><br>
        <div class='row'>
       			<div class='col-xs-6'>
       			    
                    <input class='form-control' id='date' name='date' value='<?=$chosen?>'>
                    
                </div>
                </div>
                <br>
                <div class='row'>
                <div class='col-xs-6'>
       				<input type='button' class='form-control btn btn-primary' id='submit' value='Submit'>
       			</div>
        </div>
        <br><table><tbody><tr><td><span style='font-size: 150%; font-weight: bold;'>FamilyCab</span></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
       <tr><td>Customer Name</td><td>Time</td><td>Pick Up</td><td>Destination</td><td></td><td></td><td>Driver</td></tr>
       <?
       $x = 0;
        foreach($array as $row) {
       
       
        if($row["driver"] == "" && $row["status"] != "cancelled") {
            $result = $conn->query("SELECT id, driver FROM desid573_eway_codes.drivers WHERE city = 'sydney' ");
            
            $x = $x + 1;
            $drivermessage = "<select id='driver_id".$x."' name='id'>";

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

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

}

$drivermessage.= "</select><button id='dispatch' onClick='checkJob(".$row["spat_ref"].", `#driver_id".$x."`);' >Dispatch</button>";
        } else if($row["status"] == "cancelled") {
            $drivermessage = "cancelled";
        } else {
            $drivermessage = $row["driver"];
        }
        
            $message .= "<tr><td style='white-space: nowrap;' >".$row['name']."</td><td>".$row['time']."</td><td>".$row['pickup']."</td><td><div>".$row['dropoff']."</div></td><td>".$row['tollAmount']."</td><td>".$row['paidby']."</td><td><span>".$drivermessage."</span></td></tr>";
        
        
        }
        echo $message;
        ?>

</tbody></table>
        
        
        On Click  <span style="color:#FF0000;font-size: 150%;text-align: center;" id="test"></span><br>
        
        </div>
        </div>
        </body>
        </html>
<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>
      <script type='text/javascript' src='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js'></script>
<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css'/>

setTimestamp($period); $periodString = date_format($dt, "jS M, Y H:i a"); $dt = new DateTime(); $dt->setTimestamp($periodLower); $periodStringLower = date_format($dt, "jS M, Y H:i a"); require_once('class.phpmailer.php'); require_once('class.smtp.php'); $dbhost = "localhost"; $dbuser = "desid573_famcab"; $dbpass = "C]+6wQySxov("; $dbname = "desid573_familycab"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); date_default_timezone_set("Australia/Perth"); $yesterday = "Last ".$periodString." Days"; $lastDriver = ""; $lastDriverTotal = ""; $lastDriverTollTotal = ""; if($_GET["date"] == "") { $chosen = "Today"; } else { $chosen = $_GET["date"]; } $jobDate = date("d M, Y", strtotime($chosen)); $query1 = "SELECT * FROM jobs WHERE job_city = 'sydney' AND job_date = '".$jobDate."'"; error_log($query1); $result = mysqli_query($conn, $query1); if(!$result) { error_log("jobs error".$conn->error); } $array = array(); $status = ""; while($rowSQL = mysqli_fetch_assoc($result)){ $time = date("h:i a", strtotime($rowSQL["job_time"])); if($rowSQL["job_dropoff"] == "cancelled") { $status = "cancelled"; } else { $status = ""; } $array[] = ["name" => $rowSQL["job_name"], "time" => $time, "pickup" => $rowSQL["job_pickup"], "dropoff" => $rowSQL["job_dropoff"], "spat_ref" => $rowSQL["spat_ref"], "driver" => $rowSQL["driver"], "status" => $status]; } $dbhost = "localhost"; $dbuser = "desid573_fam_app"; $dbpass = "TW#7CCqKReDn"; $dbname = "desid573_famcab_api"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $appDate = date("Y-m-d", strtotime($chosen)); $query2 = "SELECT * FROM booking WHERE type='SA' AND booking_date = '".$appDate."'"; error_log($query2); $result2 = mysqli_query($conn, $query2); if(!$result2) { error_log("booking error".$conn->error); } while($rowSQL = mysqli_fetch_assoc($result2)){ $cust = "SELECT * FROM customers WHERE id = ".$rowSQL["cid"]; $custQuery = mysqli_query($conn, $cust); $custRow = mysqli_fetch_assoc($custQuery); $name = $custRow["name"]; $time = date("h:i a", strtotime($rowSQL["booking_time"])); $array[] = ["name" => $name, "time" => $time, "pickup" => $rowSQL["pickup_addr"], "dropoff" => $rowSQL["pickoff_addr"], "spat_ref" => $rowSQL["spatula_id"], "driver" => $rowSQL["driver"], "status" => $rowSQL["status"]]; } usort($array, function($a, $b) { return $a['time'] > $b['time']; }); //print_r($array); $lastDriver = ""; $quotetotal = 0; $acttotal = 0; ?> Daily Report

Dispatch report In Sydney

query("SELECT id, driver FROM desid573_eway_codes.drivers WHERE city = 'sydney' "); $x = $x + 1; $drivermessage = ""; } else if($row["status"] == "cancelled") { $drivermessage = "cancelled"; } else { $drivermessage = $row["driver"]; } $message .= ""; } echo $message; ?>

FamilyCab
Customer Name	Time	Pick Up	Destination			Driver
".$row['name']."	".$row['time']."	".$row['pickup']."	".$row['dropoff']."	".$row['tollAmount']."	".$row['paidby']."	".$drivermessage."

On Click