<?php
session_start();
require_once "config.php";

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

function sanitizeInput($input) {
    return htmlspecialchars(strip_tags(trim($input)));
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $action = $_GET['action'];

    $employee_id = sanitizeInput($_POST['employee_id']);
    $ltyp = sanitizeInput($_POST['ltyp']);
    $startdate = sanitizeInput($_POST['startdate']);
    $enddate = sanitizeInput($_POST['enddate']);
    $reason = sanitizeInput($_POST['reason']);
    $remarks = sanitizeInput($_POST['remarks']);
    
    function dateDiffInDays($date1, $date2) {
        $datetime1 = new DateTime($date1);
        $datetime2 = new DateTime($date2);
    
        // Calculate the difference using DateTime diff method
        $interval = $datetime1->diff($datetime2);
    
        // Return the difference in days
        return $interval->days;
    }


   if ($action == 'add') {

        // $duration = sanitizeInput($_POST['duration']);
        // $duration = '1';
        $leave_status = 'Pending';
        
       
        $duration = dateDiffInDays($startdate, $enddate);


        $sql = "INSERT INTO leaves (employee_id, leave_type, start_date, end_date, duration, leave_status, reason, remarks, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "iissssssss", $employee_id, $ltyp, $startdate, $enddate, $duration, $leave_status, $reason, $remarks, $date, $date);

        if (mysqli_stmt_execute($stmt)) {
            $_SESSION['success_message'] = "Leave added successfully.";
        } else {
            $_SESSION['error_message'] = "Error adding leave: " . mysqli_error($conn);
        }

        mysqli_stmt_close($stmt);
        mysqli_close($conn);
       
        header("location: leave.php");
        exit();
        
    } elseif ($action == 'edit') {
        $leave_id = sanitizeInput($_POST['leave_id']);
        $duration = dateDiffInDays($startdate, $enddate);
        $leave_status = 'Pending';


        $sql = "UPDATE leaves SET employee_id=?, leave_type=?, start_date=?, end_date=?, duration=?, leave_status=?, reason=?, remarks=?, updated_at=NOW() WHERE id=?";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "iissssssi", $employee_id, $ltyp, $startdate, $enddate, $duration, $leave_status, $reason, $remarks, $leave_id);

        if (mysqli_stmt_execute($stmt)) {
            $_SESSION['success_message'] = "Leave updated successfully.";
        } else {
            $_SESSION['error_message'] = "Error updating leave: " . mysqli_error($conn);
        }

        mysqli_stmt_close($stmt);
        header("location: leave.php");
        exit();
        
    } elseif ($action == 'delete') {
        $leave_id = sanitizeInput($_POST['leave_id']);

        $sql = "DELETE FROM leaves WHERE id=?";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "i", $leave_id);

        if (mysqli_stmt_execute($stmt)) {
            $_SESSION['success_message'] = "Leave deleted successfully.";
        } else {
            $_SESSION['error_message'] = "Error deleting leave: " . mysqli_error($conn);
        }

        mysqli_stmt_close($stmt);
        header("location: leave.php");
        exit();
        
    } elseif ($action == 'update_status') {
        $leave_id = sanitizeInput($_POST['leave_id']);
        $status = sanitizeInput($_POST['status']);
    
        $sql = "UPDATE leaves SET leave_status=? WHERE id=?";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "si", $status, $leave_id);
    
        if (mysqli_stmt_execute($stmt)) {
            $_SESSION['success_message'] = "Leave status updated successfully.";
        } else {
            $_SESSION['error_message'] = "Error updating leave status: " . mysqli_error($conn);
        }
    
        mysqli_stmt_close($stmt);
        mysqli_close($conn);
    
        header("location: leave.php");
        exit();
    }

}
?>
