<?php

 
ob_start(); 

include_once("include/head.php");

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'];

    $equipmentImage = null;
    $invoiceImage = null;

    if (isset($_FILES['equipmentImage']) && $_FILES['equipmentImage']['error'] == 0) {
        $equipmentTmpPath = $_FILES['equipmentImage']['tmp_name'];
        $equipmentFileName = $_FILES['equipmentImage']['name'];
        $equipmentFileType = $_FILES['equipmentImage']['type'];

        $timestamp = time();
        $equipmentFileExtension = pathinfo($equipmentFileName, PATHINFO_EXTENSION);
        $newEquipmentFileName = "eqp-" . $timestamp . "." . $equipmentFileExtension;

        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);  
        }

        $equipmentImage =  $newEquipmentFileName;
        if (move_uploaded_file($equipmentTmpPath, $equipmentImage)) {
            echo "Equipment Image uploaded successfully!<br>"; 
        } else {
            echo "Failed to upload Equipment Image.<br>"; 
        }
    } else {
        echo "No Equipment Image uploaded or there was an error.<br>"; 
    }

    if (isset($_FILES['invoiceImage']) && $_FILES['invoiceImage']['error'] == 0) {
        $invoiceTmpPath = $_FILES['invoiceImage']['tmp_name'];
        $invoiceFileName = $_FILES['invoiceImage']['name'];
        $invoiceFileType = $_FILES['invoiceImage']['type'];

        $timestamp = time();
        $invoiceFileExtension = pathinfo($invoiceFileName, PATHINFO_EXTENSION);
        $newInvoiceFileName = "invoice-" . $timestamp . "." . $invoiceFileExtension;

        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true); 
        }

        $invoiceImage = $newInvoiceFileName;
        if (move_uploaded_file($invoiceTmpPath, $invoiceImage)) {
            echo "Invoice Image uploaded successfully!<br>"; 
        } else {
            echo "Failed to upload Invoice Image.<br>"; 
        }
    } else {
        echo "No Invoice Image uploaded or there was an error.<br>"; 
    }

    $attachments = null;
    if (isset($_FILES['attachments']) && $_FILES['attachments']['error'] == 0) {
        $fileTmpPath = $_FILES['attachments']['tmp_name'];
        $fileName = $_FILES['attachments']['name'];
        $fileSize = $_FILES['attachments']['size'];
        $fileType = $_FILES['attachments']['type'];

        $timestamp = time();
        $fileExtension = pathinfo($fileName, PATHINFO_EXTENSION);
        $newFileName = "attachment-" . $timestamp . "." . $fileExtension;

        $uploadDir = 'assets/images/equipments/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);  
        }

        $attachments =  $newFileName;  
        if (move_uploaded_file($fileTmpPath, $attachments)) {
            echo "Attachment uploaded successfully!<br>";  
        } else {
            echo "Failed to upload Attachment.<br>"; 
        }
    }

    $sql = "INSERT INTO equipment_inventory (equipment_name, serial_number, model_number, dimensions, color, location, assigned_to, warranty_expiry, last_service, service_details, notes, equipment_image, invoice_image, attachments)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("ssssssssssssss", $equipmentName, $serialNumber, $modelNumber, $dimensions, $color, $location, $assignedTo, $warrantyExpiry, $lastService, $serviceDetails, $notes, $equipmentImage, $invoiceImage, $attachments);
        
        if ($stmt->execute()) {
            $_SESSION['success_message'] = "Equipment information submitted successfully.";
            header("Location: purchase.php");  
            exit;
        } else {
            $_SESSION['error_message'] = "There was an error submitting 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">Equipment Inventory</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" 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">
                                    </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">
                                    </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">
                                    </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">
                                    </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" 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">
                                    </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">
                                    </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">
                                    </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"></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"></textarea>
                                    </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">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label for="invoiceImage">Upload Invoice Image</label>
                                        <input type="file" class="form-control" name="invoiceImage" id="invoiceImage">
                                    </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">
                                    </div>
                                </div>
                                <button type="submit" class="btn btn-primary">Submit</button>
                            </fieldset>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include_once("include/footer.php"); ?>
