<?php
session_start();

require_once "config.php";

// Function to sanitize input
function sanitizeInput($input) {
    return htmlspecialchars(strip_tags(trim($input)));
}


if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $page_url = sanitizeInput($_POST['page_url']);
    $description = sanitizeInput($_POST['description']);
    

    if (!isset($_POST['permission_id'])) {
        
        $sql = "INSERT INTO permissions (page_url, description, created_at) VALUES (?, ?, ?)";
        if ($stmt = mysqli_prepare($conn, $sql)) {
            mysqli_stmt_bind_param($stmt, "sss", $page_url, $description, $date);
            
            if (mysqli_stmt_execute($stmt)) {
                mysqli_stmt_close($stmt);
                mysqli_close($conn);
                $_SESSION['success_message'] = "Permission added successfully.";
                header("location: add-permissions.php");
                exit();
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        } else {
            echo "Error: " . mysqli_error($conn);
        }
    } else {
        // Update existing employee
        $permission_id = sanitizeInput($_POST['permission_id']);
        $sql = "UPDATE permissions SET page_url=?, description=?, created_at=? WHERE id=?";
        
        if ($stmt = mysqli_prepare($conn, $sql)) {
            mysqli_stmt_bind_param($stmt, "sssi", $page_url, $description, $date, $permission_id);
            
            if (mysqli_stmt_execute($stmt)) {
                mysqli_stmt_close($stmt);
               
                mysqli_close($conn);
                $_SESSION['success_message'] = "Employee updated successfully.";
                header("location: add-permissions.php");
                exit();
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        } else {
            echo "Error: " . mysqli_error($conn);
        }
    }
}
?>