/home/desid573/public_html/angel/drivers
Edit: /home/desid573/public_html/angel/drivers/getDailyAvailability.php (3065B)
"day1", "Mon" => "day2", "Tue" => "day3", "Wed" => "day4", "Thu" => "day5", "Fri" => "day6", "Sat" => "day7"];
$weekend = date("Y-m-d", strtotime($date." this Saturday"));
$day = $dateArray[date("D", strtotime($date))];
if($weekend != "" && $day != "") {
$dbhost = "localhost";
$dbuser = "desid573_famcab";
$dbpass = "C]+6wQySxov(";
$dbname = "desid573_eway_codes";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM driver_avail WHERE week_ending = '".$weekend."'";
$success = $conn->query($query);
$drivers = [];
if (!$success) {
error_log("Couldn't get data: ".$conn->error);
}
if($success->num_rows > 0) {
while($row = $success->fetch_assoc()) {
$query1 = "SELECT * FROM drivers WHERE id = ".$row["driver"];
$success1 = $conn->query($query1);
if (!$success1) {
error_log("Couldn't get driver data: ".$conn->error);
}
$driver_details = $success1->fetch_assoc();
array_push($drivers, ["id" => $row["driver"], "name" => $driver_details["driver"], "phone" => $driver_details["driver_phone"], "availibility" => $row[$day]] );
}
$response["status"] = "OK";
$response["message"] = "Availability found";
$response["drivers"] = $drivers;
}
$query = "SELECT * FROM driver_default_avail";
$success = $conn->query($query);
if (!$success) {
error_log("Couldn't enter data: ".$conn->error);
}
$driver_col = array_column($drivers, "id");
if($success->num_rows > 0) {
while($row = $success->fetch_assoc()) {
$key = array_search($row["driver"], $driver_col);
if($key === false) {
$query1 = "SELECT * FROM drivers WHERE id = ".$row["driver"];
$success1 = $conn->query($query1);
if (!$success1) {
error_log("Couldn't get driver data: ".$conn->error);
}
$driver_details = $success1->fetch_assoc();
array_push($drivers, ["id" => $row["driver"], "name" => $driver_details["driver"], "phone" => $driver_details["driver_phone"], "availibility" => $row[$day]] );
}
}
}
$response["status"] = "OK";
$response["message"] = "Availability found";
$response["drivers"] = $drivers;
} else {
$response["status"] = "error";
$response["message"] = "Not enough data";
}
echo json_encode($response, true);
?>