chamilo / chamilo-lms

     * @param int $itemId The item ID

     * @return array The beneficiries. Otherwise return false

     */

    public function getItemBeneficiaries($itemId)

    {

        $beneficiaryTable = Database::get_main_table(self::TABLE_ITEM_BENEFICIARY);

        return Database::select(

            '*',

            $beneficiaryTable,

            ['where' => [

                'item_id = ?' => intval($itemId)

            ]]

        );

    }

    /**

     * Delete a item with its beneficiaries

     * @param int $itemId The user ID

     * @return int The number of affected rows. Otherwise return false

     */

    public function deleteItemBeneficiaries($itemId)

    {

        $beneficiaryTable = Database::get_main_table(BuyCoursesPlugin::TABLE_ITEM_BENEFICIARY);

        return Database::delete(

            $beneficiaryTable,

            ['item_id = ?' => intval($itemId)]

        );

    }

    /**

     * Register the beneficiaries users with the sale of item