1#@!#!123s

: / home / schoolcampuserp / erp.nationalacademykotwa.com / api / app_api3-4-26 /
Filename : add_attendance.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve values from POST request
    $date = $_POST["date"];
    $student_session_id = $_POST["student_session_id"];
    $att_type_id = $_POST["att_type_id"];

    // Check if data for the given session ID and date already exists
    $checkQuery = "SELECT * FROM `student_attendences`
    WHERE `student_session_id` = '$student_session_id' AND `date` = '$date'";
    $result = $con->query($checkQuery);

    if ($result && $result->num_rows > 0) {
        // Data already exists for the given session ID and date, perform update
        $updateQuery = "UPDATE `student_attendences` SET `attendence_type_id` = '$att_type_id'
        WHERE `student_session_id` = '$student_session_id' AND `date` = '$date'";
        
        if ($con->query($updateQuery)) {
            $response = array("status" => "1", "message" => "Data updated successfully");
        } else {
            $response = array("status" => "0", "message" => "Error updating data: " . $con->error);
        }
    } else {
        // Data doesn't exist for the given session ID and date, perform insert
        $insertQuery = "INSERT INTO `student_attendences` (`id`, `student_session_id`, 
        `biometric_attendence`, `date`, `attendence_type_id`, `remark`, `biometric_device_data`, 
        `is_active`, `created_at`, `updated_at`)
        VALUES (NULL, '$student_session_id', '0', '$date', '$att_type_id', '', NULL, 'no', 
        CURRENT_TIMESTAMP, NULL)";

        if ($con->query($insertQuery)) {
            $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);
}
?>