<?php
    include 'db.php';

    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);

    $bpid = json_decode($_POST['bpid'], true); // Array

    if (!empty($bpid)) {
        $ids = implode(",", array_map('intval', $bpid));

        $sql = "SELECT bppaid FROM bulkpackage WHERE bpid IN ($ids)";
        $result = mysqli_query($con, $sql);

        $allPackageIds = [];

        while ($row = mysqli_fetch_assoc($result)) {
            $idsArray = explode(',', $row['bppaid']);
            foreach ($idsArray as $id) {
                $trimmedId = trim($id);
                if (is_numeric($trimmedId)) {
                    $allPackageIds[] = (int)$trimmedId;
                }
            }
        }

        $uniquePackageIds = array_unique($allPackageIds);

        if (!empty($uniquePackageIds)) {
            $finalIds = implode(",", $uniquePackageIds);
            $packageQuery = "SELECT paid, name FROM package WHERE paid IN ($finalIds)";
            $packageResult = mysqli_query($con, $packageQuery);

            echo "<option value=''>Select Package</option>";
            while ($package = mysqli_fetch_assoc($packageResult)) {
                echo "<option value='{$package['paid']}'>{$package['name']}</option>";
            }
        } else {
            echo "<option>No Result found</option>";
        }
    } else {
        echo "<option></option>";
    }
    ?>