use C4::Debug;
use C4::Templates qw(gettemplate);
use Koha::DateUtils qw( dt_from_string output_pref );
+use Koha::Acquisition::Baskets;
use Koha::Acquisition::Booksellers;
use Koha::Acquisition::Orders;
use Koha::Biblios;
if ( @$ordernumbers ) {
$query .= ' AND (aqorders.ordernumber IN ( ' . join (',', ('?') x @$ordernumbers ) . '))';
push @query_params, @$ordernumbers;
+ }
if ( @$additional_fields ) {
- my $matching_record_ids_for_additional_fields = Koha::AdditionalField->get_matching_record_ids( {
- fields => $additional_fields,
- tablename => 'aqbasket',
- exact_match => 0,
- } );
- return [] unless @$matching_record_ids_for_additional_fields;
+ my @baskets = Koha::Acquisition::Baskets->filter_by_additional_fields($additional_fields);
+
+ return [] unless @baskets;
# No parameterization because record IDs come directly from DB
- $query .= ' AND aqbasket.basketno IN ( ' . join( ',', @$matching_record_ids_for_additional_fields ) . ' )';
+ $query .= ' AND aqbasket.basketno IN ( ' . join( ',', map { $_->basketno } @baskets ) . ' )';
}
if ( C4::Context->preference("IndependentBranches") ) {