@@ -, +, @@ --- C4/Acquisition.pm | 9 ++++++++- acqui/histsearch.pl | 3 +++ .../prog/en/includes/acquisitions-search.inc | 1 + .../prog/en/modules/acqui/histsearch.tt | 6 ++++++ 4 files changed, 18 insertions(+), 1 deletion(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -1941,6 +1941,7 @@ sub GetHistory { my $from_placed_on = $params{from_placed_on}; my $to_placed_on = $params{to_placed_on}; my $basket = $params{basket}; + my $purchaseordernumber = $params{purchaseordernumber}; my $booksellerinvoicenumber = $params{booksellerinvoicenumber}; my $basketgroupname = $params{basketgroupname}; my @order_loop; @@ -1969,7 +1970,8 @@ sub GetHistory { aqorders.invoiceid, aqinvoices.invoicenumber, aqbooksellers.id as id, - aqorders.biblionumber + aqorders.biblionumber, + aqorders.purchaseordernumber FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid=aqbasketgroups.id @@ -2034,6 +2036,11 @@ sub GetHistory { push @query_params, "%$booksellerinvoicenumber%"; } + if ($purchaseordernumber) { + $query .= " AND aqorders.purchaseordernumber LIKE ? "; + push @query_params, "%$purchaseordernumber%"; + } + if ($basketgroupname) { $query .= " AND aqbasketgroups.name LIKE ? "; push @query_params, "%$basketgroupname%"; --- a/acqui/histsearch.pl +++ a/acqui/histsearch.pl @@ -67,6 +67,7 @@ my $ean = $input->param('ean'); my $basket = $input->param( 'basket' ); my $basketgroupname = $input->param('basketgroupname'); my $booksellerinvoicenumber = $input->param( 'booksellerinvoicenumber' ); +my $purchaseordernumber = $input->param( 'purchaseordernumber' ); my $do_search = $input->param('do_search') || 0; my $from_placed_on = C4::Dates->new($input->param('from')); my $to_placed_on = C4::Dates->new($input->param('to')); @@ -110,6 +111,7 @@ if ($do_search) { basket => $basket, booksellerinvoicenumber => $booksellerinvoicenumber, basketgroupname => $basketgroupname, + purchaseordernumber => $purchaseordernumber, ); } @@ -129,6 +131,7 @@ $template->param( name => $name, basket => $basket, booksellerinvoicenumber => $booksellerinvoicenumber, + purchaseordernumber => $purchaseordernumber, basketgroupname => $basketgroupname, from_placed_on => $from_date, to_placed_on => $to_date, --- a/koha-tmpl/intranet-tmpl/prog/en/includes/acquisitions-search.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/acquisitions-search.inc @@ -20,6 +20,7 @@ --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/histsearch.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/histsearch.tt @@ -49,6 +49,10 @@ +
  • + + +
  • [% INCLUDE 'date-format.inc' %]
    @@ -71,6 +75,7 @@ Basket group Invoice number Order number + Purchase ordernumber Summary Vendor Placed on @@ -97,6 +102,7 @@ [% END %] [% suggestions_loo.ordernumber %] + [% suggestions_loo.purchaseordernumber %] [% suggestions_loo.title |html %]
    [% suggestions_loo.author %]
    [% suggestions_loo.isbn %] [% suggestions_loo.name %] --