/home/desid573/public_html/family
Edit: /home/desid573/public_html/family/tmrReport.php (2431B)
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");
$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 = "";
$query1 = "SELECT * FROM jobs WHERE job_city = 'queensland'";
$result = mysqli_query($conn, $query1);
$array = array();
while($rowSQL = mysqli_fetch_assoc($result)){
$array[] = $rowSQL;
}
foreach($array as $row) {
$time24 = date("G:i", strtotime($row['job_time']));
$d = date_create_from_format("jS M, Y", $row['job_date']);
$date24 = date_format($d, "Y-m-d");
$convertTime = strtotime($date24." ".$time24);
$driver = $row["driver"];
//echo $convertTime."
";
$dropoff = $row["job_dropoff"];
if($convertTime > $period && $convertTime < $periodLower && $driver != "Shebah" && $dropoff != "cancelled" && $driver != "") {
$job_duration = $row["quote_time"] * 60;
$mins = $row["mins_post"] * 60;
//
$driverSQL = mysqli_query($conn, "SELECT * FROM `desid573_eway_codes`.`driver_compliance` WHERE `driver_name` = '".$driver."'");
$driver_compliance = mysqli_fetch_assoc($driverSQL);
$driver_number = $driver_compliance["licence"];
if($driver_number == "") { $driver_number = $driver;}
$endTime = $convertTime + $job_duration + $mins ;
echo "146642, ".$driver_number.", ".date("Y-m-d H:i", $convertTime).", ".date("Y-m-d H:i", $endTime)."
";
}
}
