Attachment 149485 Details for Bug 33103 – Bug 33103: Make vendors searchable by aliases

[patch] Bug 33103: Make vendors searchable by aliases

Bug-33103-Make-vendors-searchable-by-aliases.patch (text/plain), 1.17 KB, created by Katrin Fischer on 2023-04-11 21:01:12 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2023-04-11 21:01:12 UTC

Size: 1.17 KB

patch

obsolete

>From c0911ba8b782c29418fb6fe11356a71afbeb6340 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 1 Mar 2023 12:31:17 +0100
>Subject: [PATCH] Bug 33103: Make vendors searchable by aliases
>
>Signed-off-by: Jonathan Field <jonathan.field@ptfs-europe.com>
>---
> acqui/booksellers.pl | 11 +++++++++--
> 1 file changed, 9 insertions(+), 2 deletions(-)
>
>diff --git a/acqui/booksellers.pl b/acqui/booksellers.pl
>index 43407ddad8..c9476f6179 100755
>--- a/acqui/booksellers.pl
>+++ b/acqui/booksellers.pl
>@@ -82,8 +82,15 @@ if ($booksellerid) {
>     push @suppliers, Koha::Acquisition::Booksellers->find( $booksellerid );
> } else {
>     @suppliers = Koha::Acquisition::Booksellers->search(
>-                        { name => { -like => "%$supplier%" } },
>-                        { order_by => { -asc => 'name' } } )->as_list;
>+        [
>+            { name => { -like => "%$supplier%" } },
>+            { 'aqbookseller_aliases.alias' => { -like => "%$supplier%" } },
>+        ],
>+        {
>+            order_by => { -asc => 'name' },
>+            join     => 'aqbookseller_aliases',
>+        }
>+    )->as_list;
> }
> 
> my $supplier_count = @suppliers;
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 33103: 147621 | 147622 | 147623 | 147624 | 147625 | 147626 | 147627 | 147628 | 147629 | 147630 | 147645 | 147646 | 147647 | 147648 | 147649 | 147650 | 147651 | 147652 | 147653 | 147654 | 147827 | 148448 | 148449 | 148450 | 148451 | 148452 | 148453 | 148454 | 148455 | 148456 | 148457 | 148458 | 149414 | 149419 | 149479 | 149480 | 149481 | 149482 | 149483 | 149484 | 149485 | 149486 | 149487 | 149488 | 149489 | 149490 | 149491 | 149606 | 149607 | 149608 | 149609 | 149629 | 149630 | 149788