<?php
session_start();
require_once "config.php";
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Function to sanitize input
function sanitizeInput($input) {
    return htmlspecialchars(strip_tags(trim($input)));
}

// Check if asset_id is set
if (isset($_GET['id'])) {
    $asset_id = sanitizeInput($_GET['id']);

    // Fetch asset details
    $sql = "SELECT id, name, type, serial_no, model_no, assigned_to, date, description, status 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_bind_result($stmt, $id, $name, $type, $serial_no, $model_no, $assigned_to, $assigned_date, $description, $status);
            mysqli_stmt_fetch($stmt);
        } else {
            echo "Error: " . mysqli_error($conn);
            exit();
        }

        mysqli_stmt_close($stmt);
    } else {
        echo "Error: " . mysqli_error($conn);
        exit();
    }
} else {
    echo "Invalid asset ID.";
    exit();
}

include_once("include/head.php");
?>

<div class="main-panel">
    <div class="content-wrapper">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-3">
                        <h4 class="card-title">EDIT ASSET</h4>
                    </div>
                </div>

                <div class="row">
                    <div class="col-12">
                        <form class="cmxform" id="commentForm" method="post" action="process_assets.php?action=edit" enctype="multipart/form-data">
                            <fieldset>
                                <input type="hidden" name="asset_id" value="<?php echo $id; ?>">
                                <div class="row">
                                    <div class="form-group col-md-6">
                                        <label for="asset_name">Asset Name</label>
                                        <input class="form-control" type="text" name="asset_name" value="<?php echo $name; ?>" required>
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="asset_type">Type</label>
                                        <select id="asset_type" class="form-control" name="asset_type" required>
                                            <option value="">Choose Type</option>
                                            <option value="A" <?php if ($type == 'A') echo 'selected'; ?>>A</option>
                                            <option value="B" <?php if ($type == 'B') echo 'selected'; ?>>B</option>
                                            <option value="C" <?php if ($type == 'C') echo 'selected'; ?>>C</option>
                                        </select>
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="serial_number">Serial Number</label>
                                        <input class="form-control" type="text" name="serial_number" value="<?php echo $serial_no; ?>">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="model_number">Model Number</label>
                                        <input class="form-control" type="text" name="model_number" value="<?php echo $model_no; ?>">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="assigned_to">Assigned To</label>
                                        <select id="assigned_to" class="form-control" name="assigned_to">
                                            <option value="">Choose Employee</option>
                                            <?php
                                            $sql = "SELECT employee_id, first_name, last_name FROM employees";
                                            $result = mysqli_query($conn, $sql);
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                $selected = ($assigned_to == $row['employee_id']) ? 'selected' : '';
                                                echo '<option value="' . $row['employee_id'] . '" ' . $selected . '>' . $row['first_name'] . ' ' . $row['last_name'] . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="assigned_date">Assigned Date</label>
                                        <input class="form-control" type="date" name="assigned_date" value="<?php echo $assigned_date; ?>">
                                    </div>
                                    <div class="form-group col-md-12">
                                        <label for="description">Description</label>
                                        <textarea class="form-control" name="description"><?php echo $description; ?></textarea>
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="status">Status</label>
                                        <select id="status" class="form-control" name="status" required>
                                            <option value="0" <?php if ($status == '0') echo 'selected'; ?>>Active</option>
                                            <option value="1" <?php if ($status == '1') echo 'selected'; ?>>Inactive</option>
                                        </select>
                                    </div>
                                </div>
                                <input class="btn btn-primary" type="submit" value="Update" name="submit">
                            </fieldset>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include_once("include/footer.php"); ?>
