View | Details | Raw Unified | Return to bug 29099
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt (-1 / +1 lines)
Lines 159-165 Link Here
159
                <select id="items_bundle" name="items_bundle">
159
                <select id="items_bundle" name="items_bundle">
160
                    <option value=""></option>
160
                    <option value=""></option>
161
                    [% FOREACH item_bundle IN item_bundles %]
161
                    [% FOREACH item_bundle IN item_bundles %]
162
                        <option value="[% item_bundle.itemnumber | html %]">[% item_bundle.biblio.title | html %]</option>
162
                        <option value="[% item_bundle.host | html %]">[% item_bundle.host_item.biblio.title | html %]</option>
163
                    [% END %]
163
                    [% END %]
164
                </select>
164
                </select>
165
            </li>
165
            </li>
(-)a/tools/inventory.pl (-13 / +5 lines)
Lines 42-47 use Koha::AuthorisedValues; Link Here
42
use Koha::BiblioFrameworks;
42
use Koha::BiblioFrameworks;
43
use Koha::ClassSources;
43
use Koha::ClassSources;
44
use Koha::Items;
44
use Koha::Items;
45
use Koha::Item::Bundles;
45
46
46
use List::MoreUtils qw( none );
47
use List::MoreUtils qw( none );
47
48
Lines 70-87 my ( $template, $borrowernumber, $cookie ) = get_template_and_user( Link Here
70
    }
71
    }
71
);
72
);
72
73
73
my $schema = Koha::Database->new()->schema();
74
my @item_bundles = Koha::Item::Bundles->search(
74
my $item_bundles_rs = Koha::Items->search(
75
    {},
75
    {
76
    { group_by => [ 'host' ], columns => [ 'host' ] },
76
        'item_bundles_hosts.item' => { '!=' => undef },
77
)->as_list;
77
    },
78
    {
79
        join => 'item_bundles_hosts',
80
        group_by => 'itemnumber',
81
    }
82
);
83
84
my @item_bundles = $item_bundles_rs->as_list;
85
78
86
my @authorised_value_list;
79
my @authorised_value_list;
87
my $authorisedvalue_categories = '';
80
my $authorisedvalue_categories = '';
88
- 

Return to bug 29099