LP#1789679: Provide ROLLUP support in report output In Postgres 9.5 and newer, it is simple to generate group subtotal and grand total rows for aggregate queries. The simplest thing would be to spell the grouping clause as GROUP BY ROLLUP (...) rather than GROUP BY ... when there is a mix of aggregate and non-aggregate columns in a report. This branch does just that. The report definition UI now has a checkbox labeled "Calculate grouping subtotals" which enables use of the ROLLUP functionality. Signed-off-by: Mike Rylander <mrylander@gmail.com>
LP#1845706: Missing/Damaged from Items Out Marking items Missing or Damaged from the patron Items Out interface is sometimes necessary. This commit adds that ability. Signed-off-by: Mike Rylander <mrylander@gmail.com> Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu> Signed-off-by: Dawn Dale <ddale@georgialibraries.org>
LP#1863386: link ADMIN_CAROUSEL permission to appropriate OU context This patch restricts prcrud retrieval and modification of templates to users who have ADMIN_CAROUSEL in the relevant carousel owner OU rather than requiring global_required. To test ------- [1] Apply the patch. [2] Ensure that a user with ADMIN_CAROUSEL privileges at a depth lower than "Consortium" can only view and edit carousel definitions at OUs applicable to their working libraries. Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org> Signed-off-by: Mike Rylander <mrylander@gmail.com> Signed-off-by: Jennifer Weston <jennifer.weston@equinoxinitiative.org>
LP1854197 Add Vols and Copies honors owning lib Fixes a bug in the Add Volumes and Copies action where there vol/copy editor was unable to extract the owning library of the selected volumes, thus leading to no differentation between owning libraries in the editor and having all of the new volumes/copies linked (by default) to the first owning library in the list. To test: 1. Navigate to Item Status UI 2. Scan multiple (say, 3) barcodes, each with a different owning lib. 3. Select all 3 items and chose "Add Callnumbers and Items" 4. The holdings edit page that results should show one volume and copy row per owning library instead of all rows linked to the first owning library in the set. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Jessica Woolford <jwoolford@biblio.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP#1849736 Add action trigger for email/sms for patron self registration Removed double blank lines at the top of the stock AT Email template. Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP#1849736 Add action trigger for email/sms for patron self registration Setup a new A/T Hook. Includes: 1. New row in action_trigger.hook 2. New row in action_trigger.event_definition 3. New clause in action_trigger_filters.json.example 4. Link XML clause for oils_obj:fieldmapper="staging::user_stage" on fm_IDL.xml 4. pgTAP Test 5. Release Documentation Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP#1761222: Replace bib "quality" with item "mint_condition" I originally misunderstood the XUL item field labeled "quality" and pulled in the bib record "overall quality" score. But upon checking the XUL holdings maintenance screen again, we clearly want the item's "mint_condition" field instead. This commit makes that correction and converts the 't' or 'f' values into "Good" or "Damaged", to match the item editor labels. Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Tiffany Little <tlittle@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP1761222 Holdings batch circ retrieval Fetch non-checked-in circulations for copies in the Holdings maintenance grid (for due date display) in batch instead firing a potentially vary large parallel batch of pcrud API calls. This also limits due date display to items that have open circulations, consistent with the XUL client. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Tiffany Little <tlittle@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP#1761222: Add four columns available in XUL client The XUL client had these columns but they hadn't been added to the web client yet. This commit adds them: - Classification - Due Date - OPAC visible? - Quality Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Tiffany Little <tlittle@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP#1761222: Add Fine Level, Loan Duration to Holdings View grid Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Tiffany Little <tlittle@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
lp1760193 - Action Rewording - Rename "Add Items to Bucket/Record Bucket" and "Add Items/Item Records to Bucket" to "Add to Item/Record Bucket" Signed-off-by: Kyle Huckins <khuckins@catalyte.io> modified: Open-ILS/src/templates/staff/cat/item/index.tt2 modified: Open-ILS/src/templates/staff/cat/item/t_list.tt2 Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
lp1760193 Add to Record Bucket from Item Status - Add "Add Items to Record Bucket" option in Item Status UI - Refactor Add Copy to Bucket functionality to support adding to Copy Buckets or to Record Buckets depending on optional bucket_type parameter Signed-off-by: Kyle Huckins <khuckins@catalyte.io> Changes to be committed: modified: Open-ILS/src/templates/staff/cat/item/index.tt2 modified: Open-ILS/src/templates/staff/cat/item/t_list.tt2 modified: Open-ILS/web/js/ui/default/staff/cat/item/app.js modified: Open-ILS/web/js/ui/default/staff/circ/services/item.js Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
LP1850546 Record detail shelf browse Adds support for browsing call numbers directly from a record detail page, similar to the TPAC's 'Shelf Browser' tab in its detail page. Add support for jumping to a record detail page or a new author search from each shelf browse entry. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Ruth Frasur <rfrasur@gmail.com>
LP1850546 Call number browse grid Return to grid-shaped call number browse with denser data display for main CN browse UI. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Ruth Frasur <rfrasur@gmail.com>
LP1859241 Angular holds patron search dialog Implements a patron search dialog which may be instantiated directly from the staff catalog holds placement interface. Includes: 1. New patron module (which absorbs the existing PatronService) 2. New patron search component 3. Patron search component dialog wrapper. 4. Patron profile selector component which understands custom group display trees. 4. Fixes an issue with the grid where the 'datatype' was not always propagated to IDL fields. 5. Modifies the combobox to allow the caller to clear the value by passing a null value for the selectedId. To Test: [1] Navigate to the Angular staff catalog [2] Perform a bib search [3] Click 'Place Hold' next to a title. [4] Click the 'Patron Search' button. [5] Search for patrons and either double-click a search result row or single click then chose the 'Select' button. [6] Confirm the selected patron is now chosen for holds placement. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Ruth Frasur <rfrasur@gmail.com>
LP1860044 Angular catalog search result highlights Support search field highlighting in the Angular staff catalog search result and record detail pages. Adds a new <eg-bib-display-field /> component for rendering the highlighted content. Move the catalog-common module import into the staff common module so the bib-summary component has access to the new display-field component. Drop the default search result page size to 10 for consistency with other catalogs (and to speed up rendering). Note users can still set the page size of their choice via user settings. Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Ruth Frasur <rfrasur@gmail.com>