<?php
if (!defined('ABSPATH')) {
    exit; // Exit if accessed directly
}

// Add the admin menu for Sell Enquiries
function sell_enquiry_admin_page() {
    add_menu_page(
        'Sell Enquiries',
        'Sell Enquiries',
        'manage_options',
        'sell-enquiry-admin',
        'sell_enquiry_admin_list',
        'dashicons-list-view',
        25
    );
}
add_action('admin_menu', 'sell_enquiry_admin_page');

// Function to display the enquiry list using DataTables
function sell_enquiry_admin_list() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'sell_enquiry';
    $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY created_at DESC");
    ?>
    <div class="wrap">
        <br>
        <h1>Sell Enquiries</h1>
        <table id="sellEnquiriesTable" class="wp-list-table widefat fixed striped" style="width:100%;">
            <thead>
                <tr>
                    <th>Sr. No.</th>
                    <th>Name</th>
                    <th>Email</th>
                    <th>Phone</th>
                    <th>Location</th>
                    <th>Product</th>
                    <th>Additional Equipment</th>
                    <th>Remarks</th>
                    <th>Images</th>
                    <th>Date</th>
                </tr>
            </thead>
            <tbody>
                <?php 
                $sr_no = 1;
                foreach ($results as $row) : ?>
                    <tr>
                        <td><?php echo $sr_no++; ?></td>
                        <td><?php echo esc_html($row->full_name); ?></td>
                        <td><?php echo esc_html($row->email); ?></td>
                        <td><?php echo esc_html($row->phone); ?></td>
                        <td><?php echo esc_html($row->location); ?></td>
                        <td><?php echo esc_html($row->product_name); ?></td>
                        <td><?php echo esc_html($row->additional_equipment); ?></td>
                        <td><?php echo esc_html($row->remarks); ?></td>
                        <td>
                            <?php 
                            if (!empty($row->images)) {
                                $images = explode(',', $row->images);
                                foreach ($images as $img) {
                                    $img = esc_url(trim($img));
                                    echo "<a href='$img' class='enq-image' target='_blank'>
                                            <img src='$img' style='width:50px; height:50px; object-fit:cover; margin:3px; border:1px solid #ccc; border-radius:4px;'>
                                          </a>";
                                }
                            } else {
                                echo "—";
                            }
                            ?>
                        </td>
                        <td><?php echo date('d-m-Y', strtotime($row->created_at)); ?></td>
                    </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>

    <!-- Include jQuery + DataTables -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">

    <!-- Simple Lightbox (for popup image) -->
    <link href="https://cdnjs.cloudflare.com/ajax/libs/lightbox2/2.11.4/css/lightbox.min.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/lightbox2/2.11.4/js/lightbox.min.js"></script>

    <script>
    jQuery(document).ready(function($) {
        $('#sellEnquiriesTable').DataTable({
            "paging": true,
            "searching": true,
            "ordering": true,
            "autoWidth": false,
            "responsive": true
        });

        // Attach lightbox
        lightbox.option({
            'resizeDuration': 200,
            'wrapAround': true
        })
    });
    </script>
    <?php
}