EXCELIA_DBARR/custom/voucher/class/helper.class.php

<?php

class VoucherHelper
{
    public $db;
    /**
     * Class constructor.
     */
    public function __construct()
    {
        global $db;
        $this->db = $db;
    }

    function showInputField($fk_product)
    {
        $inputFieldString = '';
        $sql = "SELECT pr.rowid, pr.label FROM llx_product as pr
            INNER JOIN llx_product_extrafields as pre ON pre.fk_object = pr.rowid
            WHERE pre.is_in_bundle IS null
            AND pre.hotelsales is null
            ORDER BY pr.label";
        $result = $this->db->query($sql);
        $inputFieldString .= '<select class="flat minwidth100" id="fk_product" name="fk_product" data-select2-id="fk_product" tabindex="-1" aria-hidden="true">';
        $inputFieldString .= '<option value="-1" data-select2-id="4">&nbsp;</option>';
        if ($this->db->num_rows($result) > 0) {
            while ($row = $this->db->fetch_object($result)) {
                $selected = $row->rowid == $fk_product ? 'selected' : '';
                $inputFieldString .= '<option value="' . $row->rowid . '" ' . $selected . '>' . $row->label . '</option>';
            }
        }

        $inputFieldString .= '</select>';
        return $inputFieldString;
    }
}
?>