/home/desid573/public_html/family
Edit: /home/desid573/public_html/family/melbAuditReport.php (10458B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
global $vromo;
$query1 = "SELECT * FROM `invoices` WHERE `type` = 'MF' AND `driver` != 'Shebah' AND `date_created` BETWEEN '2021-07-01 00:00:00' AND '2021-12-31 23:59:59'";
$result = mysqli_query($conn, $query1);
$bigArray = [];
if($result->num_rows > 0) {
while($rowSQL = mysqli_fetch_assoc($result)) {;
$array = array();
$array[0] = "";
$array[1] = $rowSQL["reference"];
$array[19] = $rowSQL["amount"];
$driver = driversLicence($rowSQL["driver"]);
$array[3] = $driver[0];
$array[4] = $driver[1];
$sql = "SELECT * FROM jobs WHERE reference = '".$rowSQL["reference"]."'";
$result2 = mysqli_query($conn, $sql);
$rowSQL2 = mysqli_fetch_assoc($result2);
$booking_date = $rowSQL2["job_date"];
$d = date_create_from_format("jS M, Y", $booking_date);
$date24 = date_format($d, "Y-m-d");
$booking_time = $rowSQL2["job_time"];
$time24 = date("G:i", strtotime($booking_time));
$array[2] = date("Y-m-d G:i:s P", strtotime($date24." ".$time24));
$pickup = $rowSQL2["job_pickup"];
$pickupL = strtolower($pickup);
if(strpos($pickupL, 'airport') !== false) {
$array[6] = "";
$array[7] = "Melbourne Airport";
$array[8] = "Vic";
$array[9] = "3045";
} else {
$pickupA = explode(",", $pickup);
$array[6] = $pickupA[0];
$suburb = trim($pickupA[1]);
$suburbS = explode(" ", $suburb);
$suburb = $suburbS[0];
$array[7] = $suburb;
$array[8] = "Vic";
$array[9] = $pickupA[3];
}
$dropoff = $rowSQL2["job_dropoff"];
$dropoffL = strtolower($dropoff);
if(strpos($dropoffL, 'airport') !== false) {
$array[15] = "";
$array[16] = "Melbourne Airport";
$array[17] = "Vic";
$array[18] = "3045";
} else {
$dropoffA = explode(",", $dropoff);
$array[15] = $dropoffA[0];
$suburb = trim($dropoffA[1]);
$suburbS = explode(" ", $suburb);
$suburb = $suburbS[0];
$array[16] = $suburb;
$array[17] = "Vic";
$array[18] = $dropoffA[3];
}
$array[22] = $rowSQL2["quote_km"];
$spatula_id = $rowSQL2["spat_ref"];
$url = "https://api.vromo.io/v2/graph/role/jobs/$spatula_id?access_token=".$vromo;
error_log($url);
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, $url);
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
$response = curl_exec($curlObj);
curl_close($curlObj);
error_log($response);
$spat = json_decode($response, true);
$start = $spat["tasks"]["items"][0]["completed"]["time"]/1000;
$array[5] = date("Y-m-d G:i:s P", $start);
$array[10] = $spat["tasks"]["items"][0]["completed"]["coords"]["lat"];
$array[11] = $spat["tasks"]["items"][0]["completed"]["coords"]["lon"];
$array[12] = $spat["tasks"]["items"][1]["completed"]["coords"]["lat"];
$array[13] = $spat["tasks"]["items"][1]["completed"]["coords"]["lon"];
$end = $spat["tasks"]["items"][1]["completed"]["time"]/1000;
$array[14] = date("Y-m-d G:i:s P", $end);
array_push($bigArray, $array);
}
}
return $bigArray;
}
function checkApp() {
$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);
global $vromo;
$query1 = "SELECT * FROM `invoices` WHERE `type` = 'MA' AND `driver` != 'Shebah' AND `date_created` BETWEEN '2020-07-01 00:00:0' AND '2020-12-31 23:59:59'";
$result = mysqli_query($conn, $query1);
$bigArray = [];
if($result->num_rows > 0) {
while($rowSQL = mysqli_fetch_assoc($result)) {;
$array = array();
$array[0] = "";
$array[1] = $rowSQL["reference"];
$array[19] = $rowSQL["amount"];
$driver = driversLicence($rowSQL["driver"]);
$array[3] = $driver[0];
$array[4] = $driver[1];
$sql = "SELECT * FROM booking WHERE reference = '".$rowSQL["reference"]."'";
$result2 = mysqli_query($conn, $sql);
$rowSQL2 = mysqli_fetch_assoc($result2);
$array[2] = date("Y-m-d G:i:s P", strtotime($rowSQL2["booking_date"]." ".$rowSQL2["booking_time"]));
$pickup = $rowSQL2["pickup_addr"];
$pickupL = strtolower($pickup);
if(strpos($pickupL, 'airport') !== false) {
$array[6] = "";
$array[7] = "Melbourne Airport";
$array[8] = "Vic";
$array[9] = "3045";
} else {
$pickupA = explode(",", $pickup);
$array[6] = $pickupA[0];
$suburb = trim($pickupA[1]);
$suburbS = explode(" ", $suburb);
$array[7] = $suburbS[0];
$array[8] = $suburbS[1];
$array[9] = $suburbS[2];
}
$dropoff = $rowSQL2["pickoff_addr"];
$dropoffL = strtolower($dropoff);
if(strpos($dropoffL, 'airport') !== false) {
$array[15] = "";
$array[16] = "Melbourne Airport";
$array[17] = "Vic";
$array[18] = "3045";
} else {
$pickupA = explode(",", $dropoff);
$array[15] = $dropoffL[0];
$suburb = trim($pickupA[1]);
$suburbS = explode(" ", $suburb);
$array[16] = $suburbS[0];
$array[17] = $suburbS[1];
$array[18] = $suburbS[2];
}
$array[22] = $rowSQL2["quote_km"];
$spatula_id = $rowSQL2["spatula_id"];
$url = "https://api.vromo.io/v2/graph/role/jobs/$spatula_id?access_token=".$vromo;
error_log($url);
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, $url);
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
$response = curl_exec($curlObj);
curl_close($curlObj);
error_log($response);
$spat = json_decode($response, true);
$start = $spat["tasks"]["items"][0]["completed"]["time"]/1000;
$array[5] = date("Y-m-d G:i:s", $start)."+08:00";
$array[10] = $spat["tasks"]["items"][0]["completed"]["coords"]["lat"];
$array[11] = $spat["tasks"]["items"][0]["completed"]["coords"]["lon"];
$array[12] = $spat["tasks"]["items"][1]["completed"]["coords"]["lat"];
$array[13] = $spat["tasks"]["items"][1]["completed"]["coords"]["lon"];
$end = $spat["tasks"]["items"][1]["completed"]["time"]/1000;
$array[14] = date("Y-m-d G:i:s", $end)."+08:00";
array_push($bigArray, $array);
}
}
return $bigArray;
}
$message = "
Daily Report
";
//echo $message;
$array1 = checkWeb();
foreach($array1 as $array) {
echo $array[1].",".$array[2].",".$array[3].",".$array[4].",".$array[5].",".$array[6].",".$array[7].",".$array[8].",".$array[9].",".$array[10].",".$array[11].",".$array[12].",".$array[13].",".$array[14].",".$array[15].",".$array[16].",".$array[17].",".$array[18].",".$array[19].",".",,
";
}
$array2 = checkApp();
foreach($array2 as $array) {
echo $array[1].",".$array[2].",".$array[3].",".$array[4].",".$array[5].",".$array[6].",".$array[7].",".$array[8].",".$array[9].",".$array[10].",".$array[11].",".$array[12].",".$array[13].",".$array[14].",".$array[15].",".$array[16].",".$array[17].",".$array[18].",".$array[19].",".",,
";
}
// echo "";
?>
