FM / drivers

/home/desid573/public_html/drivers

Name	Size	Mode	Actions
training/	-	0755	rm
twilio-php-master/	-	0755	rm
avail.php	19359	0644	edit dl rm
cancel_booking.php	4537	0644	edit dl rm
checkDetails.php	1568	0644	edit dl rm
checkDetailsId.php	1774	0644	edit dl rm
cleaning_record.pdf	117117	0644	edit dl rm
contractor_conduct.pdf	110192	0644	edit dl rm
create.php	2610	0644	edit dl rm
createbilling.php	8952	0644	edit dl rm
createdriver.php	5278	0644	edit dl rm
createSMS.php	1844	0644	edit dl rm
daily.php	9342	0644	edit dl rm
default.php	16383	0644	edit dl rm
delete.php	935	0644	edit dl rm
deletedriver.php	3619	0644	edit dl rm
driverBilling.php	8378	0644	edit dl rm
driver_check_qld.php	3907	0644	edit dl rm
drugs_policy.pdf	78742	0644	edit dl rm
error_log	390475	0644	edit dl rm
getDailyAvailability.php	3065	0644	edit dl rm
getDefaultAvailability.php	1102	0644	edit dl rm
getDriverAvailability.php	1642	0644	edit dl rm
home.php	5517	0644	edit dl rm
incident.php	1871	0644	edit dl rm
incident_report.php	6179	0644	edit dl rm
index1.php	3937	0644	edit dl rm
licence_file_qld.php	1768	0644	edit dl rm
list.php	2046	0644	edit dl rm
login.php	7782	0644	edit dl rm
loginDriver.php	1214	0644	edit dl rm
medical.pdf	32899	0644	edit dl rm
new.php	835	0644	edit dl rm
off.php	3502	0644	edit dl rm
qld_report.php	1109	0644	edit dl rm
register.php	8676	0644	edit dl rm
setDefaultAvailability.php	3257	0644	edit dl rm
setDriverAvailability.php	3365	0644	edit dl rm
setDriverPin.php	2189	0644	edit dl rm
smsregister.php	1564	0644	edit dl rm
updateDetails.php	4527	0644	edit dl rm
updateDetailsDriver.php	5101	0644	edit dl rm

Edit: /home/desid573/public_html/drivers/getDailyAvailability.php (3065B)

<?php

$date = $_REQUEST['date'];
$dateArray = ["Sun" => "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);
    		
    		?>

"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); ?>