<?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") {
    $asset_name = sanitizeInput($_POST['asset_name']);
    $asset_type = sanitizeInput($_POST['asset_type']);
    $serial_number = sanitizeInput($_POST['serial_number']);
    $model_number = sanitizeInput($_POST['model_number']);
    $assigned_to = sanitizeInput($_POST['assigned_to']);
    $assigned_date = sanitizeInput($_POST['assigned_date']);
    $description = sanitizeInput($_POST['description']);
    $status = sanitizeInput($_POST['status']);
    $date = date("Y-m-d H:i:s");

    if (isset($_GET['action'])) {
        $action = $_GET['action'];

        if ($action == 'add') {
            $sql = "INSERT INTO assets (name, type, serial_no, model_no, assigned_to, date, description, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "ssssssssss", $asset_name, $asset_type, $serial_number, $model_number, $assigned_to, $assigned_date, $description, $status, $date, $date);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Asset added successfully.";
                    header("location: assets.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        }

        if ($action == 'edit') {
            $asset_id = sanitizeInput($_POST['asset_id']);
            $sql = "UPDATE assets SET name=?, type=?, serial_no=?, model_no=?, assigned_to=?, date=?, description=?, status=?, updated_at=? WHERE id=?";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "sssssssssi", $asset_name, $asset_type, $serial_number, $model_number, $assigned_to, $assigned_date, $description, $status, $date, $asset_id);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Asset updated successfully.";
                    header("location: assets.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        }

        if ($action == 'delete') {
            $asset_id = sanitizeInput($_POST['asset_id']);
            $sql = "DELETE FROM assets WHERE id=?";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "i", $asset_id);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Asset deleted successfully.";
                    header("location: assets.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            }
        }
    }
}
?>
