/home/desid573/public_html
Edit: /home/desid573/public_html/confirm_check.php (6257B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$dateFormatted = date("Y-m-d H:i:s", strtotime("-1 week"));
$sql = "SELECT * FROM `jobs` WHERE `date_added` > '".$dateFormatted."' AND `conf_sms_sent` = '' AND job_dropoff != 'cancelled' AND driver = ''";
//error_log($sql);
$result = $conn->query($sql);
if(!$result) {
echo $conn->error;
} else {
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$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);
if($convertTime > strtotime("now")) {
$jobCity = $row["job_city"];
if($jobCity == "sydney") {
$type = "SF";
date_default_timezone_set("Australia/Sydney");
$url = "https://hooks.slack.com/services/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";
} else if($jobCity == "melbourne") {
$type = "MF";
date_default_timezone_set("Australia/Melbourne");
$url = "https://hooks.slack.com/services/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";
} else if($jobCity == "queensland") {
$type = "BF";
date_default_timezone_set("Australia/Brisbane");
$url = "https://hooks.slack.com/services/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";
$pick = checkLocalCoords($row["job_pickup"]);
$drop = checkLocalCoords($row["job_dropoff"]);
error_log(json_encode($pick, true));
$dist = getDistance($pick['lat'], $pick['lon']);
error_log($dist);
if($dist <= 35) {
$goldCoast = true;
$type = "GC";
$url = "https://hooks.slack.com/services/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";
}
} else {
$type = "FC";
date_default_timezone_set("Australia/Perth");
$url = 'https://hooks.slack.com/services/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';
}
$ref = $row["reference"];
$link = "https://desidrivers.com.au/smsconfirm.php?type=".$type."&ref=".$ref;
$cal = checkCalendar($type, $ref);
if(!$cal) {
$calText = "*Not Found on Calendar*";
} else {
$calText = "Found on Calendar";
}
$slackmessage = "*Unconfirmed Job*\n".$row["job_name"]." ".$row["job_date"]." ".$row["job_time"]." <".$link." | Confirm> ".$calText;
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, $url);
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curlObj, CURLOPT_HEADER, 0);
curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
curl_setopt($curlObj, CURLOPT_POST, 1);
curl_setopt($curlObj, CURLOPT_POSTFIELDS, '{"text": "'.$slackmessage.'"}');
$response = curl_exec($curlObj);
curl_close($curlObj);
if($response == "ok") {
error_log("Slack Sent");
} else {
error_log("Slack not sent");
}
}
}
} else {
echo "none found";
}
}
function getDistance($latitude1, $longitude1) {
$latitude2 = -28.015748;
$longitude2 = 153.401148;
$earth_radius = 6371;
$dLat = deg2rad($latitude2 - $latitude1);
$dLon = deg2rad($longitude2 - $longitude1);
$a = sin($dLat/2) * sin($dLat/2) + cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * sin($dLon/2) * sin($dLon/2);
$c = 2 * asin(sqrt($a));
$d = $earth_radius * $c;
return $d;
}
function checkLocalCoords($place) {
error_log("checkLocalCoords called");
$dbhost = "localhost";
$dbuser = "desid573_famcab";
$dbpass = "C]+6wQySxov(";
$dbname = "desid573_eway_codes";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$sql = "SELECT * FROM terminal_details WHERE name = '".$place."'";
$result = $conn->query($sql);
if($result->num_rows > 0) {
$row = $result->fetch_assoc();
return array("name"=> $row["name"], "lat" => $row["lat"], "lon" => $row["long"]);
}
$sql = "SELECT * FROM place_coords WHERE name = '".$place."'";
$result = $conn->query($sql);
if($result->num_rows > 0) {
$row = $result->fetch_assoc();
return array("name"=> $row["name"], "lat" => $row["lat"], "lon" => $row["lon"]);
} else {
return false;
}
}
?>
