1#@!#!123s

: / home / schoolcampuserp / erp.nationalacademykotwa.com / api / app_api /
Filename : add_driver_current_location.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve values from POST request
    $route_id = $_POST["route_id"];
    $vehicles_id = $_POST["vehicles_id"];
    $current_location = $_POST["current_location"];
    $driver_id = $_POST["driver_id"];
    
    // Check if a record with the given route_id and vehicles_id already exists
    $checkQuery = "SELECT * FROM `driver_current_location` WHERE `route_id` = '$route_id' 
    AND `vehicles_id` = '$vehicles_id'";
    $result = $con->query($checkQuery);
    
    if ($result->num_rows > 0) {
        // If a record exists, update current_location and driver_id
        $updateQuery = "UPDATE `driver_current_location` SET `current_location` = '$current_location',
        `driver_id` = '$driver_id', `created_at` = CURRENT_TIMESTAMP 
        WHERE `route_id` = '$route_id' AND `vehicles_id` = '$vehicles_id'";
        
        if ($con->query($updateQuery) === TRUE) {
            $response = array("status" => "1", "message" => "Data updated successfully");
        } else {
            $response = array("status" => "0", "message" => "Error updating data: " . $con->error);
        }
    } else {
        // If no record exists, insert a new record
        $insertQuery = "INSERT INTO `driver_current_location` (`id`, `route_id`, `vehicles_id`, `current_location`, `driver_id`, `created_at`) 
        VALUES (NULL, '$route_id', '$vehicles_id', '$current_location', '$driver_id', CURRENT_TIMESTAMP)";
        
        if ($con->query($insertQuery) === TRUE) {
            $response = array("status" => "1", "message" => "Data inserted successfully");
        } else {
            $response = array("status" => "0", "message" => "Error inserting data: " . $con->error);
        }
    }

    echo json_encode($response);
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
    echo json_encode($response);
}
?>