<?php
header('Content-Type: application/json');
error_reporting(E_ALL);
ini_set('display_errors', 0); // Disable displaying errors directly to browser

try {
    include 'db.php'; // This includes your mysqli connection as $con

    if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['measurements'])) {
        $inputMeasurements = $_POST['measurements'];
        
        // Skip empty values
        $inputMeasurements = $inputMeasurements;
        
        if (empty($inputMeasurements)) {
            echo json_encode([]);
            exit;
        }

        // Mapping input to actual values in DB
        $measurementMap = [
            'Litre' => ['lt', 'ltr', 'liter'],
            'Kg' => ['kg', 'kilogram'],
            'Gram' => ['g', 'gram'],
            'ML' => ['ml', 'millilitre'],
            // Add more mappings as needed
        ];

        $searchTerms = [];

        foreach ($inputMeasurements as $selected) {
            if (isset($measurementMap[$selected])) {
                foreach ($measurementMap[$selected] as $mapped) {
                    $searchTerms[] = $mapped;
                }
            } else {
                $searchTerms[] = $selected;
            }
        }

        if (!empty($searchTerms)) {
            // Use simple LIKE conditions with OR
            $where = "";
            foreach ($searchTerms as $index => $term) {
                if ($index > 0) {
                    $where .= " OR ";
                }
                $where .= "name LIKE '%" . $con->real_escape_string($term) . "%'";
            }

            $sql = "SELECT bpid, name FROM bulkpackage WHERE " . $where;
            
            // Execute the query directly
            $result = $con->query($sql);
            
            if (!$result) {
                echo json_encode(['error' => 'Query failed', 'details' => $con->error]);
                exit;
            }
            
            // Fetch results
            $results = [];
            while ($row = $result->fetch_assoc()) {
                $results[] = $row;
            }
            
            // Free result
            $result->free();
            
            echo json_encode($results);
        } else {
            echo json_encode([]);
        }
    } else {
        echo json_encode(['error' => 'Invalid request']);
    }
} catch (Exception $e) {
    // Log error to a file instead of displaying
    error_log('Error in fetch_bulk_packages.php: ' . $e->getMessage());
    echo json_encode(['error' => 'Server error occurred', 'details' => $e->getMessage()]);
}
?>