/home/desid573/public_html
Edit: /home/desid573/public_html/newJob.php (9199B)
connect_error);
$sql = "SELECT * FROM `desid573_eway_codes`.`new_job` WHERE `reference` ='".$ref."'";
$result = $conn->query($sql);
if($result->num_rows == 0) {
if($ref != "" && $type != "") {
echo "OK";
$size = ob_get_length();
header("Content-Length: $size");
header('Connection: close');
ob_end_flush();
ob_flush();
flush(); // yes, you need to call all 3 flushes!
//if (session_id()) session_write_close();
} else {
die('error');
}
$url = shortenLink($ref, $type, "options");
//send to calendar
$baseUrl = "https://desidrivers.com.au/google/google-api-php-client-2.2.1/calendarAdd.php";
$ref = trim($ref);
$type = trim($type);
$url = trim($url);
$requestUrl = $baseUrl . '?' . http_build_query([
'ref' => $ref,
'type' => $type,
'url' => $url,
]);
error_log('Request URL: [' . $requestUrl . ']');
error_log('Request URL HEX: ' . bin2hex($requestUrl));
$curlObj = curl_init();
curl_setopt_array($curlObj, [
CURLOPT_URL => $requestUrl,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_HEADER => false,
CURLOPT_USERAGENT => 'Mozilla/5.0',
]);
$response = curl_exec($curlObj);
error_log('HTTP Code: ' . curl_getinfo($curlObj, CURLINFO_HTTP_CODE));
error_log('Effective URL: ' . curl_getinfo($curlObj, CURLINFO_EFFECTIVE_URL));
error_log('Curl Error: ' . curl_error($curlObj));
error_log('Response: ' . $response);
curl_close($curlObj);
if(!$response) {
error_log("Error with adding to calendar");
} else {
error_log($response);
}
//send to slack
require('typeConfig.php');
if($type == "FC" or $type == "SF" or $type == "MF" or $type == "BF" or $type == "DD" or $type == "GC" or $type == "SC") {
if($type == "DD") {
$url = 'https://hooks.slack.com/services/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';
} else if ($type == "SF"){
$url = "https://hooks.slack.com/services/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";
} else if ($type == "MF") {
$url = "https://hooks.slack.com/services/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";
} else if ($type == "BF") {
$url = "https://hooks.slack.com/services/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";
} else if ($type == "GC") {
$url = "https://hooks.slack.com/services/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";
} else if ($type == "SC") {
$url = "https://hooks.slack.com/services/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";
} else {
$url = 'https://hooks.slack.com/services/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';
}
$slackLink = shortenLink($ref, $type, "sms");
$slackmessage = "<$slackLink | Confirm Booking> for $name \n$booking_date $booking_time\n$pickup\n$dropoff";
$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");
}
}
//send to Contacts
$url = "https://desidrivers.com.au/google/google-api-php-client-2.2.1/contact.php?type=".$type."&name=".urlencode($name)."&phone=".urlencode($phone)."&email=".urlencode($email);
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);
curl_setopt($curlObj, CURLOPT_HEADER, 0);
curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
$response = curl_exec($curlObj);
error_log($repsonse);
curl_close($curlObj);
$response = json_decode($response, true);
//if($response["status"] != "OK") {
/*$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, 'https://hooks.slack.com/services/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');
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": "'.$name .' '.$response["message"].'"}');
$response = curl_exec($curlObj);
curl_close($curlObj);*/
//} else {
//error_log("Contacts OK");
//}
//send to Xero
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://desidrivers.com.au/xero/XeroOAuth-PHP-master/addContact.php?name=".urlencode($name)."&phone=".urlencode($phone)."&email=".urlencode($email));
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(!$response) {
error_log("Error with adding contact to Xero");
} else if($response == "OK") {
error_log("Xero Contact Add OK");
} else if($response == "error") {
error_log("Xero Contact Add error");
}
//add to Sheets
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://desidrivers.com.au/google/google-api-php-client-2.2.1/sheetsAdd.php?ref=$ref&type=$type");
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(!$response) {
error_log("Error with adding to spreadsheet");
} else {
error_log("Calendar OK");
}
//send to MailChip
if($email != "") {
$apiKey = "5a0105d5de282633ec0d0e11c8a43109-us15";
if($type == "SI" or $type == "HK") {
$list = "7c2f3d3fa5";
}
if($type == "FA" or $type == "FC" or $type == "SF" or $type == "SA" OR $type == "MA" OR $type == "MF" OR $type == "BF" OR $type == "BA" or $type == "GC" or $type == "GA" or $type = "YA") {
$list = "7f21679bb3";
}
if($type == "DD") {
$list = "1166069404";
}
$splitName = explode(" ", $name);
$postBody = '{
"email_address": "'.$email.'",
"status": "subscribed",
"merge_fields": {
"FNAME": "'.$splitName[0].'",
"LNAME": "'.$splitName[0].'"
}
}';
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://us15.api.mailchimp.com/3.0/lists/$list/members/");
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', 'Authorization: anyString '.$apiKey));
curl_setopt($curlObj, CURLOPT_POST, 1);
curl_setopt($curlObj, CURLOPT_POSTFIELDS, $postBody);
$response = curl_exec($curlObj);
curl_close($curlObj);
$json = json_decode($response, true);
if($json['status'] == 200) {
error_log("Email added to list
");
} else if($json['status'] == 400) {
error_log("Email already on list
");
} else {
error_log("Error subscribing email to MailChimp
");
}
//Email Confirmation
if($type == "FA" or $type == "FC" or $type == "SF" or $type == "SA" OR $type == "MA" OR $type == "MF" OR $type == "BF" OR $type == "BA" or $type == "GC" or $type == "GA" or $type == "SC" or $type == "YA") {
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://desidrivers.com.au/google/google-api-php-client-2.2.1/gmailBookingConfirmation.php?ref=$ref&type=$type");
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(!$response) {
error_log("Error with sending");
} else if ($response == "error") {
error_log("Email Not Sent");
} else if ($response == "OK") {
error_log("Email Sent");
}
}
}
$sql = "INSERT INTO `desid573_eway_codes`.`new_job`(`id`, `reference`, `date`) VALUES (NULL,'".$ref."', NOW())";
$result = $conn->query($sql);
if(!$result) {
error_log("new job add error ".$conn->error);
}
} else {
error_log("tried to add ".$ref." ".$type." a 2nd time");
}
if(!$result) {
error_log("job error ".$conn->error);
}
