/home/desid573/public_html/test_api
NameSizeModeActions
lib/-0755rm
twilio-php-master/-0755rm
vendor/-0755rm
after_booking_page.php25950644editdlrm
booking.php107160644editdlrm
booking_28-04-2017.php9470644editdlrm
booking_29-04-2017.php37170644editdlrm
cancel_booking.php56210644editdlrm
checkPrice.php13060644editdlrm
composer.json650644editdlrm
composer.lock23550644editdlrm
confirmsend.php26820644editdlrm
contact_us_mail.php9030644editdlrm
dispatch.php8770644editdlrm
emailConfirmReset.php4860644editdlrm
error_log59222470644editdlrm
generate_credit.php31870644editdlrm
generate_referall.php27790644editdlrm
getuser_byid.php23410644editdlrm
getuser_bymail.php19680644editdlrm
get_all_booking.php7790644editdlrm
get_booking_bybooking_id.php8130644editdlrm
get_booking_byuser.php10570644editdlrm
get_booking_status.php22190644editdlrm
get_completed_bookings.php7270644editdlrm
get_directions.php8130644editdlrm
get_lead_message.php6730644editdlrm
get_open_bookings.php15270644editdlrm
get_payment_byuser.php10640644editdlrm
homekey_img.png140370644editdlrm
index.php142720644editdlrm
index_backup.php47910644editdlrm
lib_tr.zip1050470644editdlrm
login_api.php84050644editdlrm
login_api_old.php56530644editdlrm
noteconfirm.php92590644editdlrm
passwordResetLink.php51950644editdlrm
pay_file.php73020644editdlrm
pay_file_back.php53260644editdlrm
placehold.html21840644editdlrm
reset_email.php17550644editdlrm
send_bulk_notif.php16920644editdlrm
test_222.php8450644editdlrm
update_api.php63180644editdlrm
update_api_on_mail.php46770644editdlrm
validatecode.php10940644editdlrm
validatephone.php10340644editdlrm
Edit: /home/desid573/public_html/test_api/booking.php (10716B)
query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $customer[] = $row; $sql = "SELECT * FROM `customer_details` where `cid` = '".$row["id"]."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_details = $result->fetch_assoc()) { $cust_detail[] = $row_details; } } $sql = "SELECT * FROM `customer_tokens` where `cid` = '".$row["id"]."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_token = $result->fetch_assoc()) { $cust_token[] = $row_token; } } } $cus = $customer[0]["name"]; $mob = str_replace(" ", "", $customer[0]["mobile"]); $cid = $customer[0]['id']; $date = $_REQUEST['booking_date']; if($date == "") { $bookingdate = date("Y-m-d"); $bookingtime = date("H:i:s"); } else { $date = str_replace("/","-",$date); $format = 'd-m-Y'; $datetime = DateTime::createFromFormat($format, $date); $bookingdate = $datetime->format('Y-m-d'); $time=$_REQUEST['booking_time']; $time24 = date("G:i", strtotime($time)); $bookingtime = $time24; $timeUTC = date("c", strtotime("$bookingdate $time24")); $timeString = '{ "key": "deliverBy", "value": "' . $timeUTC . '" },'; } $timeUpper = date("H:i:s", strtotime($_REQUEST['booking_date']." ".$_REQUEST['booking_time']) + 900); $timeLower = date("H:i:s", strtotime($_REQUEST['booking_date']." ".$_REQUEST['booking_time']) - 900); $sql = "SELECT * FROM `booking` where `cid` = '".$cid."' and `status` != 'cancelled' and `booking_date` = '".$bookingdate."' and `booking_time` between '".$timeLower."' and '".$timeUpper."'"; $result = $conn->query($sql); if (!$result) { error_log("find booking error".$conn->error); } if ($result->num_rows > 0) { error_log("found double"); $Res["message"] = "You already have a booking within 15 mins of this time, please check the Open Bookings tab"; $Res["status"] = "error"; } else { function send_mail($to, $from, $title, $message) { $headers = "From: DesiDriversApp < admin@desidrivers.com.au >\n"; $headers .= "X-Sender: DesiDriversApp < admin@desidrivers.com.au >\n"; $headers .= 'X-Mailer: PHP/' . phpversion(); $headers .= "X-Priority: 1\n"; // Urgent message! $headers .= "Return-Path: admin@desidrivers.com.au\n"; // Return path for errors $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=iso-8859-1\n"; return mail($to, $title, $message, $headers); } $fullnameencode = urlencode($cus); $pickupencode = urlencode($_REQUEST["pickup_addr"]); $dropoffencode = urlencode($_REQUEST["pickoff_addr"]); $reference = time().rand(10,5000); $price = $_REQUEST['quote']; $price = str_replace("$","", "$price"); $tokencustomerid = $cust_token[0]["access_token_value"]; $type = $_REQUEST['type']; if($type == "DD") { $type = "SI"; } if($type == "HK") { $price = checkPrice($_REQUEST["dist"], $_REQUEST["time"], "HK"); } $shortLink = get_object_vars($json); $paymentlink = $shortLink['id']; $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, 'https://api.fleeteng.com.au/v2/graph/role/jobs?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs'); 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, '[{"name": "' .$type.' ' . $cus . '", "campaign": {"id": 5622549795}, "contact": {"name": "' . $cus . '","phone": "' .$mob . '","email": "' . $_REQUEST["email"] . '"},"tasks": [{"zone": {"name": "Pick Up","address": "' . $_REQUEST["pickup_addr"] . '","coords": {"lat": ' . $_REQUEST["pickup_lat"] . ',"lon": ' . $_REQUEST["pickup_long"] . '},"radius": 100}},{"zone": {"name": "Home","address": "' . $_REQUEST["pickoff_addr"] . '","coords": {"lat": ' . $_REQUEST["pickoff_lat"] . ',"lon": ' . $_REQUEST["pickoff_long"] . '},"radius": 100}}],"attr": ['.$timeString.'{ "key": "Payment Link", "value": "' . $paymentlink . '" }]}]'); //$response = curl_exec($curlObj); //error_log($response); $json = json_decode($response, true); curl_close($curlObj); $query = "SELECT * FROM holding_link WHERE id = 1"; $result = mysqli_query($conn, $query); if(!$result) { error_log("link error".$conn->error); } $row = mysqli_fetch_assoc($result); $link = $row["link"]; $spatulalink = $link; //$json['items'][0]['tracking']; $spatulaid = ""; //$json['items'][0]['id']; $pickupx = str_replace("'", "", $_REQUEST['pickup_addr']); $dropoffx = str_replace("'", "", $_REQUEST['pickoff_addr']); $sql = "INSERT INTO `desid573_eway_codes`.`place_coords`(`id`, `name`, `lat`, `lon`, `date_added`) VALUES (NULL,'".$pickupx."',".$_REQUEST["pickup_lat"].",".$_REQUEST["pickup_long"].",NOW())"; $result = $conn->query($sql); if(!$result) { error_log($sql); error_log("Error inserting coords ".$conn->error); } $sql = "INSERT INTO `desid573_eway_codes`.`place_coords`(`id`, `name`, `lat`, `lon`, `date_added`) VALUES (NULL,'".$dropoffx."',".$_REQUEST["pickoff_lat"].",".$_REQUEST["pickoff_long"].",NOW())"; $result = $conn->query($sql); if(!$result) { error_log($sql); error_log("Error inserting coords ".$conn->error); } $sql = "INSERT INTO `booking` (`id`, `cid`, `email`, `booking_date`, `booking_time`, `pickup_addr`, `pickup_lat`, `pickup_long`, `pickoff_addr`, `pickoff_lat`, `pickoff_long`,`spatula_id`,`spatula_link`, `reference`, `type`, `quote`, `quote_km`, `quote_time`, `xero_inv`, `payment_eway`, `status`, `driver`) VALUES (NULL, '".$cid."', '".$_REQUEST["email"]."', '".$bookingdate."', '".$bookingtime."', '".$pickupx."', '".$_REQUEST["pickup_lat"]."', '".$_REQUEST["pickup_long"]."', '".$dropoffx."', '".$_REQUEST["pickoff_lat"]."', '".$_REQUEST["pickoff_long"]."', '".$spatulaid."', '".$spatulalink."', '".$reference."', '".$type."', '".$price."', '".$_REQUEST['dist']."', '".$_REQUEST['time']."', '', '', '', '')"; if($conn->query($sql)) { $bid = $conn->insert_id; if($time24 == "") { $time24 = "ASAP"; } $slackmessage = " for $cus \n$bookingdate $time24\n$pickupx\n$dropoffx"; error_log($slackmessage); $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": "'.$slackmessage.'"}'); $response = curl_exec($curlObj); error_log($response); curl_close($curlObj); $url = "https://desidrivers.com.au/newJob.php?type=$type&ref=$reference"; $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_HTTPHEADER, array('Accept: application/json')); $response = curl_exec($curlObj); curl_close($curlObj); $message = '

Hi '.$cus.',

Thanks for your booking. Please check the details below for your booking and location :

Details:


Type '.$type.'
Date '.$bookingdate.'
Token Customer Id '.$cust_token[0]["access_token_value"].'
Name '.$cus.'
Phone '.$mob.'
Pick Up '.$_REQUEST["pickup_addr"].'
To Drop '.$_REQUEST["pickoff_addr"].'
Pick up Long '.$_REQUEST["pickup_long"].'
Pick up Lat '.$_REQUEST["pickup_lat"].'
Drop of Long '.$_REQUEST["pickoff_long"].'
Drop of Lat '.$_REQUEST["pickoff_lat"].'
Reference '.$reference.'
'; $to = "lewis@perthdesignateddrivers.com.au"; $from = "homekey@perthdesignateddrivers.com.au"; $title = "Booking Details"; if(send_mail($to, $from, $title, $message)) { $Res["message"] = "booking successfully done"; $Res["status"] = "ok"; $Res["bid"] = $bid; $Res["spatula_link"] = "$spatulalink"; } else { $Res["message"] = "booking successfully But email has some issue Not send"; $Res["status"] = "ok"; } } else { $Res["message"] = "booking Not done"; $Res["status"] = "error"; error_log("booking error: ".$conn->error); } } } else { $Res["message"] = "user is not found "; $Res["status"] = "error"; } } echo json_encode(new ArrayObject($Res)); //echo "
";
//print_r($data);
//print_r($Res);
//echo "
"; $conn->close(); ?>