/home/desid573/public_html
Edit: /home/desid573/public_html/cancel.php (8118B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM jobs WHERE reference = ".$ref;
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$name = $row['job_name'];
$booking_date = $row['job_date'];
$booking_time = $row['job_time'];
$pickup = $row["job_pickup"];
$dropoff = $row["job_dropoff"];
$spatula_ref = $row['spat_ref'];
$query = "UPDATE jobs SET `job_dropoff` = 'cancelled', `job_quote` = 0 WHERE `reference` = '".$ref."'";
$result = mysqli_query($conn, $query);
if(!$result) {
$status = "no";
error_log($conn->error);
} else {
$status = "OK";
}
$driver = "";
}
if($type == "FC" OR $type == "SF" or $type == "MF" or $type == "BF" or $type == "GC" or $type == "SC") {
$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);
$query = "SELECT * FROM jobs WHERE reference = ".$_POST['ref'];
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$spatula_ref = $row['spat_ref'];
$name = $row['job_name'];
$booking_date = $row['job_date'];
$booking_time = $row['job_time'];
$pickup = $row["job_pickup"];
$dropoff = $row["job_dropoff"];
$driver = $row["driver"];
$suffix = $row['job_pax']." pax ".$row['job_rf']." RF ".$row['job_ff']." FF ".$row['job_boost']." B";
$query = "UPDATE jobs SET `job_dropoff` = 'cancelled', `job_quote` = 0 WHERE `reference` = '".$ref."'";
$result = mysqli_query($conn, $query);
if(!$result) {
$status = "no";
error_log($conn->error);
} else {
$status = "OK";
}
}
if($type == "HK" OR $type == "SI") {
$dbhost = "localhost";
$dbuser = "desid573_inquiri";
$dbpass = "@G&{)0*&Ts^V";
$dbname = "desid573_new_pro_api";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM booking WHERE reference = ".$_POST['ref'];
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$spatula_ref = $row['spatula_id'];
$booking_date = $row['booking_date'];
$booking_time = $row['booking_time'];
$pickup = $row["pickup_addr"];
$dropoff = $row["pickoff_addr"];
$cid = $row['cid'];
$query = "SELECT * FROM customers WHERE id = ".$cid;
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$driver = "";
$name = $row['name'];
$query = "UPDATE booking SET `status` = 'cancelled', `pickoff_addr` = 'cancelled', `quote` = 0 WHERE `reference` = ".$ref."";
$result = mysqli_query($conn, $query);
if(!$result) {
$status = "no";
} else {
$status = "OK";
}
}
if($type == "FA" OR $type == "SA" or $type == "MA" or $type == "BA" or $type == "GA" or $type == "YA") {
$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);
$query = "SELECT * FROM booking WHERE reference = ".$_POST['ref'];
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$spatula_ref = $row['spatula_id'];
$booking_date = $row['booking_date'];
$booking_time = $row['booking_time'];
$pickup = $row["pickup_addr"];
$dropoff = $row["pickoff_addr"];
$cid = $row['cid'];
$driver = $row["driver"];
$query = "SELECT * FROM customers WHERE id = ".$cid;
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$name = $row['name'];
$query = "UPDATE booking SET `status` = 'cancelled', `pickoff_addr` = 'cancelled', `quote` = 0 WHERE `reference` = ".$ref."";
$result = mysqli_query($conn, $query);
if(!$result) {
$status = "no";
} else {
$status = "OK";
}
}
$url = "https://desidrivers.com.au/cancelJob.php?ref=$ref&type=$type";
$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'));
$response = curl_exec($curlObj);
curl_close($curlObj);
if($spatula_ref != "") {
$url = "https://api.vromo.io/v2/graph/role/jobs/".$spatula_ref."?access_token=".$vromo;
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL,$url);
// curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
// curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
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, '{"cancelled": {"note": "", "reason": {"id": 25102}}}');
$result = curl_exec($curlObj);
error_log($result);
curl_close($curlObj);
}
if($type == "DD" or $type == "HK" or $type == "SI") {
$url = 'https://hooks.slack.com/services/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';
} else if ($type == "SF" or $type == "SA"){
$url = "https://hooks.slack.com/services/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";
} else if ($type == "MF" or $type == "MA") {
$url = "https://hooks.slack.com/services/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";
} else if ($type == "BF" or $type == "BA") {
$url = "https://hooks.slack.com/services/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";
} else if($type == "GC" or $type == "GA") {
$url = "https://hooks.slack.com/services/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";
} else if($type == "SC" or $type == "YA") {
$url = "https://hooks.slack.com/services/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";
} else if($type == "FC" or $type == "FA") {
$url = 'https://hooks.slack.com/services/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';
}
if($driver == "") {
$driverMessage = "";
}else{
$driverMessage = "\nAssigned to ".$driver;
}
$slackmessage = "Cancelled by Admin:\n$name \n$booking_date $booking_time\n$pickup\n$dropoff".$driverMessage;
$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");
}
echo $status;
}
