[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|19.11                       |master
             Status|NEW                         |In Discussion
                 CC|                            |katrin.fischer at bsz-bw.de

--- Comment #3 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
When the "library" filter on the invoice page is set, a JOIN is done on the
borrowers table using the branchcode of this patron.

And aqbasket.authorisedby is the borrowernumber of the librarian who created
the basket.

BUT if the patron is removed, the column will be set to NULL, and the JOIN will
not return the invoices created by this (now deleted) patron.

There is a "Managing library" (aqbasket.branch) at basket level, maybe we
should use it instead of borrowers.branchcode.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.