<?php
ob_start(); 
include_once("include/head.php");

$equipmentName = $serialNumber = $modelNumber = $dimensions = $color = $location = $assignedTo = $warrantyExpiry = $lastService = $serviceDetails = $notes = $attachments = $invoiceImage = $equipmentImage = "";

if (isset($_GET['id'])) {
    $equipment_id = $_GET['id'];

    $sql = "SELECT * FROM equipment_inventory WHERE id = $equipment_id";
    $result = $conn->query($sql);
    
    if ($result && $row = $result->fetch_assoc()) {
        $equipmentName = $row['equipment_name'];
        $serialNumber = $row['serial_number'];
        $modelNumber = $row['model_number'];
        $dimensions = $row['dimensions'];
        $color = $row['color'];
        $location = $row['location'];
        $assignedTo = $row['assigned_to'];
        $warrantyExpiry = $row['warranty_expiry'];
        $lastService = $row['last_service'];
        $serviceDetails = $row['service_details'];
        $notes = $row['notes'];
        $attachments = $row['attachments'];
        $invoiceImage = $row['invoice_image'];
        $equipmentImage = $row['equipment_image'];
    } else {
        $_SESSION['error_message'] = "Equipment not found.";
        header("Location: purchase.php");
        exit();
    }
} else {
    $_SESSION['error_message'] = "Invalid equipment ID.";
    header("Location: purchase.php");
    exit();
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $equipmentName = $_POST['equipmentName'];
    $serialNumber = $_POST['serial_number'];
    $modelNumber = $_POST['model_number'];
    $dimensions = $_POST['dimensions'];
    $color = $_POST['color'];
    $location = $_POST['location'];
    $assignedTo = $_POST['assignedTo'];
    $warrantyExpiry = $_POST['warrantyExpiry'];
    $lastService = $_POST['lastService'];
    $serviceDetails = $_POST['serviceDetails'];
    $notes = $_POST['notes'];

    $newEquipmentImage = $equipmentImage;
    $newAttachments = $attachments;
    $newInvoiceImage = $invoiceImage;

    if (isset($_FILES['equipmentImage']) && $_FILES['equipmentImage']['error'] == 0) {
        $equipmentTmpPath = $_FILES['equipmentImage']['tmp_name'];
        $equipmentFileName = $_FILES['equipmentImage']['name'];
        $equipmentFileExtension = pathinfo($equipmentFileName, PATHINFO_EXTENSION);
        $timestamp = time();
        $newEquipmentFileName = "eqp-" . $timestamp . "." . $equipmentFileExtension;
        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);  
        }
        $newEquipmentImage = $uploadDir . $newEquipmentFileName;
        if (!move_uploaded_file($equipmentTmpPath, $newEquipmentImage)) {
            $_SESSION['error_message'] = "Failed to upload the equipment image.";
            header("Location: purchase.php");
            exit();
        }
    }

    if (isset($_FILES['attachments']) && $_FILES['attachments']['error'] == 0) {
        $fileTmpPath = $_FILES['attachments']['tmp_name'];
        $fileName = $_FILES['attachments']['name'];
        $fileExtension = pathinfo($fileName, PATHINFO_EXTENSION);
        $timestamp = time();
        $newFileName = "attachment-" . $timestamp . "." . $fileExtension;
        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);  
        }
        $destination = $uploadDir . $newFileName;
        if (move_uploaded_file($fileTmpPath, $destination)) {
            $newAttachments = $destination;
        } else {
            $_SESSION['error_message'] = "Failed to upload the attachment.";
            header("Location: purchase.php");
            exit();
        }
    }

    if (isset($_FILES['invoiceImage']) && $_FILES['invoiceImage']['error'] == 0) {
        $fileTmpPath = $_FILES['invoiceImage']['tmp_name'];
        $fileName = $_FILES['invoiceImage']['name'];
        $fileExtension = pathinfo($fileName, PATHINFO_EXTENSION);
        $timestamp = time();
        $newFileName = "invoice-" . $timestamp . "." . $fileExtension;
        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);  
        }
        $destination = $uploadDir . $newFileName;
        if (move_uploaded_file($fileTmpPath, $destination)) {
            $newInvoiceImage = $destination;
        } else {
            $_SESSION['error_message'] = "Failed to upload the invoice image.";
            header("Location: purchase.php");
            exit();
        }
    }

    $sql = "UPDATE equipment_inventory 
            SET equipment_name = ?, serial_number = ?, model_number = ?, dimensions = ?, 
                color = ?, location = ?, assigned_to = ?, warranty_expiry = ?, 
                last_service = ?, service_details = ?, notes = ?, attachments = ?, invoice_image = ?, equipment_image = ? 
            WHERE id = ?";

    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("sssssssssssssssi", $equipmentName, $serialNumber, $modelNumber, $dimensions, 
                          $color, $location, $assignedTo, $warrantyExpiry, $lastService, $serviceDetails, 
                          $notes, $newAttachments, $newInvoiceImage, $newEquipmentImage, $equipment_id);
        
        if ($stmt->execute()) {
            $_SESSION['success_message'] = "Equipment information updated successfully.";
            header("Location: purchase.php");
            exit();
        } else {
            $_SESSION['error_message'] = "There was an error updating the information. Please try again.";
            header("Location: purchase.php");
            exit();
        }

        $stmt->close();
    }
}

$conn->close();
?>

<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 Equipment</h4>
                    </div>
                </div>

                <div class="row">
                    <div class="col-12">
                        <form class="cmxform" id="commentForm" method="post" action="" enctype="multipart/form-data">
                            <fieldset>
                                <div class="row form-section">
                                    <div class="form-group col-md-4">
                                        <label for="equipmentName">Equipment Name</label>
                                        <input class="form-control" type="text" name="equipmentName" id="equipmentName"
                                            placeholder="Equipment name" value="<?php echo htmlspecialchars($equipmentName); ?>" required>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="serial_number">Serial Number</label>
                                        <input class="form-control" type="text" name="serial_number" id="serial_number"
                                            placeholder="Serial Number" value="<?php echo htmlspecialchars($serialNumber); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="model_number">Model Number</label>
                                        <input class="form-control" type="text" name="model_number" id="model_number"
                                            placeholder="Model Number" value="<?php echo htmlspecialchars($modelNumber); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="dimensions">Dimensions (L x W x H)</label>
                                        <input class="form-control" type="text" name="dimensions" id="dimensions"
                                            placeholder="Dimensions" value="<?php echo htmlspecialchars($dimensions); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="color">Color</label>
                                        <input class="form-control" type="text" name="color" id="color"
                                            placeholder="Color" value="<?php echo htmlspecialchars($color); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="location">Location</label>
                                        <input class="form-control" type="text" name="location" id="location"
                                            placeholder="Location" value="<?php echo htmlspecialchars($location); ?>" required>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="assignedTo">Assigned To</label>
                                        <input class="form-control" type="text" name="assignedTo" id="assignedTo"
                                            placeholder="Assigned To" value="<?php echo htmlspecialchars($assignedTo); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="warrantyExpiry">Warranty Expiry Date</label>
                                        <input class="form-control" type="date" name="warrantyExpiry" id="warrantyExpiry"
                                            value="<?php echo htmlspecialchars($warrantyExpiry); ?>">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="lastService">Last Service Date</label>
                                        <input class="form-control" type="date" name="lastService" id="lastService"
                                            value="<?php echo htmlspecialchars($lastService); ?>">
                                    </div>
                                    <div class="form-group col-md-12">
                                        <label for="serviceDetails">Service Details</label>
                                        <textarea class="form-control" name="serviceDetails" id="serviceDetails"
                                            placeholder="Service Details"><?php echo htmlspecialchars($serviceDetails); ?></textarea>
                                    </div>
                                    <div class="form-group col-md-12">
                                        <label for="notes">Additional Notes</label>
                                        <textarea class="form-control" name="notes" id="notes"
                                            placeholder="Additional Notes"><?php echo htmlspecialchars($notes); ?></textarea>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="attachments">Upload Attachments (e.g., warranty)</label>
                                        <input type="file" class="form-control" name="attachments" id="attachments">
                                        <?php if ($attachments): ?>
                                            <img src="<?php echo htmlspecialchars($attachments); ?>" height="200">
                                            <br><a href="<?php echo htmlspecialchars($attachments); ?>" target="_blank">View current attachment</a>
                                        <?php endif; ?>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="invoiceImage">Upload Invoice</label>
                                        <input type="file" class="form-control" name="invoiceImage" id="invoiceImage">
                                        <?php if ($invoiceImage): ?>
                                            <img src="<?php echo htmlspecialchars($invoiceImage); ?>" height="200">
                                            <br><a href="<?php echo htmlspecialchars($invoiceImage); ?>" target="_blank">View current invoice</a>
                                        <?php endif; ?>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="equipmentImage">Upload Equipment Image</label>
                                        <input type="file" class="form-control" name="equipmentImage" id="equipmentImage">
                                        <?php if ($equipmentImage): ?>
                                            <img src="<?php echo htmlspecialchars($equipmentImage); ?>" height="200">
                                            <br><a href="<?php echo htmlspecialchars($equipmentImage); ?>" target="_blank">View current equipment image</a>
                                        <?php endif; ?>
                                    </div>
                                </div>
                                <button type="submit" class="btn btn-primary">Update</button>
                            </fieldset>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include_once("include/footer.php"); ?>
