diamond_filter.php

<?php
// diamond_filter.php
include 'header.php';
include 'sidebar.php';

// --- Fetch data for filter dropdowns ---
$customers_result = $conn->query("SELECT id, customer_name, contact_no FROM customers WHERE status='Enable' ORDER BY customer_name");
$customers_data = [];
while ($row = $customers_result->fetch_assoc()) {
    $customers_data[] = $row;
}
// Determine current customer when logged in as customer
$current_customer_id = '';
$current_customer_name = '';
if (isset($_SESSION['role']) && $_SESSION['role'] === 'customer') {
    // $_SESSION['userid'] should contain the customer's id or name from login
    $sessId = $_SESSION['userid'] ?? '';
    // try to match by id first
    foreach ($customers_data as $c) {
        if ($sessId !== '' && is_numeric($sessId) && $c['id'] == $sessId) {
            $current_customer_id = $c['id'];
            $current_customer_name = $c['customer_name'];
            break;
        }
        // fallback match by name
        if ($sessId !== '' && !is_numeric($sessId) && strcasecmp($c['customer_name'], $sessId) === 0) {
            $current_customer_id = $c['id'];
            $current_customer_name = $c['customer_name'];
            break;
        }
    }
}
$shapes = $conn->query("SELECT shape_name FROM shapes WHERE status='Enable' ORDER BY shape_name");
$colors = $conn->query("SELECT color_name FROM colors WHERE status='Enable' ORDER BY color_name");
$clarities = $conn->query("SELECT clarity_name FROM clarities WHERE status='Enable' ORDER BY clarity_name");
$cuts = $conn->query("SELECT cut_name FROM cuts WHERE status='Enable' ORDER BY cut_name");

// --- Filtering Logic ---
$sql = "SELECT * FROM diamonds WHERE 1=1";
$params = [];
$types = '';

if (!empty($_GET['shape'])) {
    $sql .= " AND shape = ?";
    $params[] = $_GET['shape'];
    $types .= 's';
}
if (!empty($_GET['color'])) {
    $sql .= " AND color = ?";
    $params[] = $_GET['color'];
    $types .= 's';
}
if (!empty($_GET['clarity'])) {
    $sql .= " AND clarity = ?";
    $params[] = $_GET['clarity'];
    $types .= 's';
}
if (!empty($_GET['cut'])) {
    $sql .= " AND cut = ?";
    $params[] = $_GET['cut'];
    $types .= 's';
}
if (!empty($_GET['size_from'])) {
    $sql .= " AND size >= ?";
    $params[] = $_GET['size_from'];
    $types .= 'd';
}
if (!empty($_GET['size_to'])) {
    $sql .= " AND size <= ?";
    $params[] = $_GET['size_to'];
    $types .= 'd';
}

$sql .= " AND status = 'Available' ORDER BY id DESC";

$stmt = $conn->prepare($sql);
if (!empty($params)) {
    $stmt->bind_param($types, ...$params);
}
$stmt->execute();
$result = $stmt->get_result();
?>
<style>
    /* Custom styles for radio and checkbox */
    .custom-radio input,
    .custom-checkbox input {
        display: none;
    }

    .custom-radio label,
    .custom-checkbox label {
        display: inline-flex;
        align-items: center;
        cursor: pointer;
        color: #4a5568;
    }

    .custom-radio label:before,
    .custom-checkbox label:before {
        content: '';
        display: inline-block;
        width: 18px;
        height: 18px;
        margin-right: 0.5rem;
        border: 2px solid #cbd5e0;
        background-color: white;
    }

    .custom-radio label:before {
        border-radius: 50%;
    }

    .custom-checkbox label:before {
        border-radius: 4px;
    }

    .custom-radio input:checked+label:before {
        background-color: #ec4899;
        border-color: #ec4899;
        box-shadow: inset 0 0 0 3px white;
    }

    .custom-checkbox input:checked+label:before {
        background-color: #ec4899;
        border-color: #ec4899;
        background-image: url("data:image/svg+xml,%3csvg viewBox='0 0 16 16' fill='white' xmlns='http://www.w3.org/2000/svg'%3e%3cpath d='M12.207 4.793a1 1 0 010 1.414l-5 5a1 1 0 01-1.414 0l-2-2a1 1 0 011.414-1.414L6.5 9.086l4.293-4.293a1 1 0 011.414 0z'/%3e%3c/svg%3e");
    }
</style>

<!-- Main Content -->
<div class="bg-white p-8 rounded-lg shadow-md w-full">
    <h4 class="text-2xl font-bold text-gray-700 mb-6">Customer Details</h4>

    <!-- Filter Form -->
    <form action="diamond_filter.php" method="GET">
        <div class="grid grid-cols-1 md:grid-cols-4 gap-6 mb-8">
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Customer Contact</label>
                <select name="customer_contact" id="customer_contact"
                    class="shadow border rounded w-full py-2 px-3 text-gray-700" <?php echo (isset($_SESSION['role']) && $_SESSION['role'] === 'customer') ? 'disabled' : ''; ?>>
                        <option value="">Select an option</option>
                        <?php foreach ($customers_data as $customer) {
                            $sel = ($current_customer_id && $current_customer_id == $customer['id']) ? ' selected' : '';
                            echo "<option value='" . $customer['id'] . "' data-name='" . $customer['customer_name'] . "'" . $sel . ">" . $customer['contact_no'] . "</option>";
                        } ?>
                </select>
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Customer Name</label>
                <input type="text" name="customer_name" id="customer_name"
                    class="shadow border rounded w-full py-2 px-3 text-gray-700 bg-gray-100" readonly value="<?php echo htmlspecialchars($current_customer_name); ?>">
            </div>
        <script>
            (function() {
                var contactSelect = document.getElementById('customer_contact');
                var nameInput = document.getElementById('customer_name');
                // If the select is disabled (customer logged in), don't add listener or allow changes
                if (contactSelect.disabled) {
                    // ensure name is already set server-side; nothing to do
                    return;
                }

                contactSelect.addEventListener('change', function() {
                    var sel = this.options[this.selectedIndex];
                    var name = sel ? (sel.getAttribute('data-name') || '') : '';
                    nameInput.value = name;
                });
            })();
        </script>
            <!-- Other filters -->
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Shape</label>
                <select name="shape" class="shadow border rounded w-full py-2 px-3 text-gray-700">
                    <option value="">All</option>
                    <?php mysqli_data_seek($shapes, 0);
                    while ($row = $shapes->fetch_assoc())
                        echo "<option value='" . $row['shape_name'] . "' " . ((!empty($_GET['shape']) && $_GET['shape'] == $row['shape_name']) ? 'selected' : '') . ">" . $row['shape_name'] . "</option>"; ?>
                </select>
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Color</label>
                <select name="color" class="shadow border rounded w-full py-2 px-3 text-gray-700">
                    <option value="">All</option>
                    <?php mysqli_data_seek($colors, 0);
                    while ($row = $colors->fetch_assoc())
                        echo "<option value='" . $row['color_name'] . "' " . ((!empty($_GET['color']) && $_GET['color'] == $row['color_name']) ? 'selected' : '') . ">" . $row['color_name'] . "</option>"; ?>
                </select>
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Clarity</label>
                <select name="clarity" class="shadow border rounded w-full py-2 px-3 text-gray-700">
                    <option value="">All</option>
                    <?php mysqli_data_seek($clarities, 0);
                    while ($row = $clarities->fetch_assoc())
                        echo "<option value='" . $row['clarity_name'] . "' " . ((!empty($_GET['clarity']) && $_GET['clarity'] == $row['clarity_name']) ? 'selected' : '') . ">" . $row['clarity_name'] . "</option>"; ?>
                </select>
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Cut</label>
                <select name="cut" class="shadow border rounded w-full py-2 px-3 text-gray-700">
                    <option value="">All</option>
                    <?php mysqli_data_seek($cuts, 0);
                    while ($row = $cuts->fetch_assoc())
                        echo "<option value='" . $row['cut_name'] . "' " . ((!empty($_GET['cut']) && $_GET['cut'] == $row['cut_name']) ? 'selected' : '') . ">" . $row['cut_name'] . "</option>"; ?>
                </select>
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Size From</label>
                <input type="number" step="0.01" name="size_from"
                    value="<?php echo isset($_GET['size_from']) ? htmlspecialchars($_GET['size_from']) : ''; ?>"
                    class="shadow border rounded w-full py-2 px-3 text-gray-700">
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Size To</label>
                <input type="number" step="0.01" name="size_to"
                    value="<?php echo isset($_GET['size_to']) ? htmlspecialchars($_GET['size_to']) : ''; ?>"
                    class="shadow border rounded w-full py-2 px-3 text-gray-700">
            </div>
        </div>
        <div class="flex justify-end"><button type="submit"
                class="bg-pink-600 hover:bg-pink-700 text-white font-bold py-2 px-6 rounded">Filter</button></div>
    </form>
    <hr class="my-8">

    <!-- Results Table & Action Form -->
    <form action="diamond_filter_action.php" method="POST">
        <div class="overflow-x-auto">
            <table class="min-w-full bg-white">
                <thead class="bg-gray-200 text-gray-600 uppercase text-sm leading-normal">
                    <tr>
                        <th class="py-3 px-6 text-left"><input type="checkbox" id="select_all"></th>
                        <th class="py-3 px-6 text-left">SRNO</th>
                        <th class="py-3 px-6 text-left">Stock</th>
                        <th class="py-3 px-6 text-left">Shape</th>
                        <th class="py-3 px-6 text-left">Size</th>
                        <th class="py-3 px-6 text-left">Color</th>
                        <th class="py-3 px-6 text-left">Clarity</th>
                        <th class="py-3 px-6 text-center">Actions</th>
                    </tr>
                </thead>
                <tbody class="text-gray-600 text-sm font-light">
                    <?php
                    if ($result && $result->num_rows > 0) {
                        $sr_no = 1;
                        while ($row = $result->fetch_assoc()) {
                            echo "<tr class='border-b border-gray-200 hover:bg-gray-100'>";
                            echo "<td class='py-3 px-6 text-left'><input type='checkbox' name='diamond_ids[]' value='" . $row['id'] . "' class='diamond_checkbox'></td>";
                            echo "<td class='py-3 px-6 text-left'>" . $sr_no++ . "</td>";
                            echo "<td class='py-3 px-6 text-left font-semibold'>" . htmlspecialchars($row["stock_no"]) . "</td>";
                            echo "<td class='py-3 px-6 text-left'>" . htmlspecialchars($row["shape"]) . "</td>";
                            echo "<td class='py-3 px-6 text-left'>" . htmlspecialchars($row["size"]) . "</td>";
                            echo "<td class='py-3 px-6 text-left'>" . htmlspecialchars($row["color"]) . "</td>";
                            echo "<td class='py-3 px-6 text-left'>" . htmlspecialchars($row["clarity"]) . "</td>";
                            echo "<td class='py-3 px-6 text-center'><div class='flex items-center justify-center gap-2'><button type='button' class='bg-blue-500 text-white py-1 px-3 rounded text-xs'>Long</button><button type='button' class='bg-gray-500 text-white py-1 px-3 rounded text-xs'>Short</button></div></td>";
                            echo "</tr>";
                        }
                    } else {
                        echo "<tr><td colspan='8' class='text-center py-4'>No diamonds match the filter criteria.</td></tr>";
                    }
                    ?>
                </tbody>
            </table>
        </div>

        <!-- Configurations & Action Button -->
        <div class="mt-8 p-6 bg-gray-50 rounded-lg">
            <h5 class="text-xl font-bold text-gray-700 mb-4">CONFIGURATIONS</h5>
            <div class="space-y-4">
                <div class="flex items-center">
                    <strong class="w-40">SHOW VIDEO</strong>
                    <div class="custom-radio flex items-center gap-4">
                        <input type="radio" id="video_yes" name="show_video" value="YES" checked><label
                            for="video_yes">Yes</label>
                        <input type="radio" id="video_no" name="show_video" value="NO"><label for="video_no">No</label>
                    </div>
                </div>
                <div class="flex items-center">
                    <strong class="w-40">SHOW IMAGES</strong>
                    <div class="custom-radio flex items-center gap-4">
                        <input type="radio" id="images_yes" name="show_images" value="YES" checked><label
                            for="images_yes">Yes</label>
                        <input type="radio" id="images_no" name="show_images" value="NO"><label
                            for="images_no">No</label>
                    </div>
                </div>
                <div class="flex items-center">
                    <strong class="w-40">SHOW DATA SHEET</strong>
                    <div class="custom-radio flex items-center gap-4">
                        <input type="radio" id="sheet_yes" name="show_sheet" value="YES" checked><label
                            for="sheet_yes">Yes</label>
                        <input type="radio" id="sheet_no" name="show_sheet" value="NO"><label for="sheet_no">No</label>
                    </div>
                </div>
                <div class="flex items-center">
                    <strong class="w-40">SHOW CERTIFICATE</strong>
                    <div class="custom-radio flex items-center gap-4">
                        <input type="radio" id="cert_yes" name="show_certificate" value="YES" checked><label
                            for="cert_yes">Yes</label>
                        <input type="radio" id="cert_no" name="show_certificate" value="NO"><label
                            for="cert_no">No</label>
                    </div>
                </div>
                <div class="flex items-center">
                    <strong class="w-40">SHARE LINK</strong>
                    <div class="custom-checkbox flex items-center gap-4">
                        <input type="checkbox" id="link_long" name="share_link[]" value="Long" checked><label
                            for="link_long">Long</label>
                        <input type="checkbox" id="link_short" name="share_link[]" value="Short"><label
                            for="link_short">Short</label>
                    </div>
                </div>
            </div>
            <div class="mt-6 text-center">
                <input type="hidden" name="customer_id_for_action" id="customer_id_for_action">
                <button type="submit"
                    class="bg-pink-600 hover:bg-pink-700 text-white font-bold py-3 px-8 rounded-lg">Share &
                    Download</button>
            </div>
        </div>
    </form>
</div>

<script>
    document.getElementById('select_all').addEventListener('click', function (event) {
        document.querySelectorAll('.diamond_checkbox').forEach(checkbox => checkbox.checked = event.target.checked);
    });

    const customerSelect = document.getElementById('customer_contact');
    const customerNameInput = document.getElementById('customer_name');
    const customerIdForActionInput = document.getElementById('customer_id_for_action');

    customerSelect.addEventListener('change', function () {
        const selectedOption = this.options[this.selectedIndex];
        customerNameInput.value = selectedOption.dataset.name || '';
        customerIdForActionInput.value = this.value; // Pass customer ID to the action form
    });
</script>

<?php
$conn->close();
include 'footer.php';
?>