LP#1695007 All-circulations slim DB VIEW
authorBill Erickson <berickxx@gmail.com>
Thu, 1 Jun 2017 14:56:11 +0000 (10:56 -0400)
committerMike Rylander <mrylander@gmail.com>
Wed, 9 Aug 2017 19:34:43 +0000 (15:34 -0400)
commit4a244416e1d5cc01104fb583c58b6a8d816cec95
tree088ecf0cb564dc3d85f2e5a3593305e993b5aca8
parent2621af6377970470e347559d67f0da5de47aaa9f
LP#1695007 All-circulations slim DB VIEW

Adds a new view action.all_circulation_slim which collects all
action.circulation and action.aged_circulation rows into a single set,
without the added joins for copy and patron data imposed by the existing
action.aged_circulation view.

The new leaner view is now used by various other views and APIs in place
of the all_circulation view:

DB:  action.all_circ_chain()
DB:  action.summarize_all_circ_chain()
DB:  rating.percent_time_circulating()
API: open-ils.circ.retrieve
API: open-ils.circ.copy_checkout_history.retrieve
API: open-ils.circ.copy_details.retrieve
API: open-ils.circ.renewal_chain.retrieve_by_circ[.summary]
API: open-ils.circ.prev_renewal_chain.retrieve_by_circ[.summary]

To Test (webstaff style):

[1] Open a copy in the web staff Item Status / Detail View interface
    that has live and aged circulations.
[2] Open the Recent Circ History tab
[3] Confirm relevent fields for both types of circs display as expected
    and that the Patron field for the aged circulation shows a value of
    <Aged Circulation>

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/perlmods/lib/OpenILS/Application/Circ.pm
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/220.schema.rating.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.all-circs-slim.sql [new file with mode: 0644]
Open-ILS/web/js/ui/default/staff/cat/item/app.js