JBAS-1929 Browse mattype filter see link counts

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1470 Multi target replaces only subfields

When performing wholesale replacement of a bib field, only replace as
many target fields as exist on the source record.  I.e. avoid
propagating and repating the same whole field multiple times into the
target record.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1470 Support multiple target field replacements

Allow a single (e.g. authority) record field to act as the basis for
replacing multiple like values on a target bib record.

E.g. replace multiple bib 700a values from a single authority 100a
value.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1764 A/T purge sql speed improvements

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1929 Catalog browse mattype sql repairs

Remove errant mattype filter on authority simple heading sub-filter in
the browse query.  Authority records don't have mattypes.

Improve speed of mattype filter by referencing
metabib.record_attr_vector_list directly instead of using the nested
record_attr view.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1932 New headings mattype sql speed improvements

Join the mattype data via a more direct path instead of the nested
views.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1764 A/T purge SQL COMMIT

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1764 A/T purge CRON script

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1764 A/T purge SQL repairs

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1764 A/T purge schema and data updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>

LP#1672775 Action/Trigger retention interval SQL/IDL

Adds a new 'retention_interval' column for Action/Trigger Event
Definitions and an action_trigger.purge_events() function for deleting
events that have exceeded their configured retention time, including any
outputs linked to those events.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>

LP#712490 Vandelay field merge x-port (pending review)

See JBAS-1470

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1470 Bib2Auth link to fullest form of heading

Allow a bib field to link to an authority field even when the bib field
has more controlled subfields than the authority field.  Matching is
based on finding the authority record with the closest ("left-anchored")
heading match.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1470 Auth propatation supports partial matches

Avoid deleting controlled subfields within a controlled bib field when
the linked authority record record field has no values for the subfields
in question.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1470 Bib linking script minor cleanup

Avoid updating each bib record until all linkining work is done.
Minor logging improvements.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1890 Patron self-reg allow state changes

Allow patrons to select any state value for the billing (primary)
address, instead of locking it down to WA.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

CAT-60 Patron editor and item summary print additions

- Add new template item_status_detailed to print
most of the data from quick summary
- Make an array to hold the data to print in alternate_copy_summary.js
- Make a new template called item_status_detailed for the print
additions
- Add print-detailed button to alternate_copy_summary.xul
- Add print functionality to patron edit screen
- Add print functionality to item quick summary
- Add experimental node exploration and testing to copy_status.js
Signed-off-by: Billy Horn <bhorn@catalystdevworks.com>
Signed-off-by: Skye Howard <showard@catalyte.io>
Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/actor/user/register.js
modified:   Open-ILS/xul/staff_client/chrome/content/util/print.js
modified:   Open-ILS/xul/staff_client/server/circ/alternate_copy_summary.js
modified:   Open-ILS/xul/staff_client/server/circ/alternate_copy_summary.xul
modified:   Open-ILS/xul/staff_client/server/skin/print_list_templates

Return receipt template file to pretty-printed JSON format to avoid
clobbering the whole file.  -- Bill.

JBAS-1929 Catalog browse mattype filter

Adds a 'format' selector to the catalog browse UI.  When a format is
selected, only browse results linked to bibs using the selected format
will be displayed.

Code heavily inspired by Catalyst code posted in
https://catalystit.atlassian.net/browse/KMAIN-1513.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1929 Catalog browse mattype filter SQL

Adds an optional 'mattype' filter for the metabib.browse() function.
When applied, only browse results linked to bibs with the specified
mattype will be returned.

Code heavily inspired by Catalyst code posted in
https://catalystit.atlassian.net/browse/KMAIN-1513.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1932 New headings UI mattype filter

Adds a new mattype (format) exclusion filter for the New Headings Report
interface.

Also adds a new 'Format' field to the headings list display.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1932 New headings report SQL mattype field

Adds a new 'mattype' field to the new headings report views and IDL
definition.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Remove 75-year card option from patron reg.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Hide ACQ picklist order ident apply-all link

Apply-all action is no longer used and has problems with multi-page
selection lists.  Hide now.  Remove later.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Backstage quarterly export query improvement

Tweak the holdings-exists part of the query to use a JOIN instead of an
IN check.  Though the exact cause of the recent slow-down is unknown,
this change allows the query to complete in minutes instead of hours.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Remove '12' library card option from patron self-reg

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Remove four line breaks from hold and hold transit slips

... to make them shorter (after adding foundation wording that
made them longer)

Bradley Bonner
bbonner@kcls.org

Force mismatched copy location batch updates

Temporarily disable the DB trigger preventing copy location updates
during the nightly KCLS batch copy location / circ lib rescyn update.
This primarily affects copies whose circ_lib does not match their call
number owning lib (e.g. floating copies).

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Do not extend expire date for 'No CKO' patrons

Avoid updating the expire date of patrons in the "No CKO" group (16) who
have recently logged in.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1951 Checkout-OK copy status 2.10 repair

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Receipt changes to add Foundation donation wording/link.

JBAS-1936

Bradley Bonner
bbonner@kcls.org

JBAS-1728 SCKO Focus login after contrast mode click

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Focus input after dbl-click login button

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Re-focus SCKO barcode input after printing

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-JBAS-1728 SCKO email receipt lib phone

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO email receipts passive repairs

Avoid firing passive (SCKO receipt) email events in real time.  Create
the events, then let the regular A/T processor handle firing the emails.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO Renew failure hides count

Avoid showing the count of failed renewals.  Show instead a generic
"Some items failed to renew" message.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Use installed common jquery files

Signed-off-by: Bill Erickson <berickxx@gmail.com>

LP#1642086 TPAC Jquery path repair, .gitignore, karma

* Repair JS path in TPAC jquery import.

* Tell git to ignore Open-ILS/web/js/ui/default/common/build/ since it
  only contains generated files.

* Add jquery to Karma unit test dependencies.  This is not strictly
  required, since angular includes a slim jquery shim, but having the
  unit tests load the same base JS as the UI is probably best.
  Confirmed tests still pass.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>

JBAS-1728 SCKO login examples / placeholders

Make examples look less like headers by making them less prominent and
moving them under each's input.

Make the input placeholder text larger for login username/password.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO Login return button clears BC entry

window.reload() appears to leave the value in the barcode entry box
after the user clicks Return To Login.  It also takes a long time, since
it's reloading.  Teach the link to use the same href setting code that
the auto-return-to-login-page code uses.  It clears the barcode box and
runs much faster.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO billing type labels avoid misc

When a billing type is available, use it as-is without prepending
"miscallaneous - ..."

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO btype; pickup lib display

Show last billing type for circ fines.
Display pickup library for ready-for-pickup holds.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO thanks page wording tweaks

Capital changes, remove periods.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO misc. additions and repairs

* Display batch renewal status info within the items out page
* Adds a login page cancel button
* Fixes various issues with the already-seen barcode handling
* Prevent batch renewal attempst on already seen barcodes
* Avoid displaying batch-renewed circs in the session circs list

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO Fines receipt xacts with >0 balance

Only list open transactions with non-zero balances, specifically those
with positive balances.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO Batch renew messages; holds style; etc.

Display a summary of message of number of items successfully renewed or
failed during batch renewal.

Only process batch notification info in batch mode.

Style the holds lists headers all the same.

Fix bug where batch renewals would use the wrong circ if items have been
added to the circ list since the patron logged in.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Prevent noisy floating.js console errors

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO clear notices on navigation

Remove the patron checkout and renewal event notifications from the UI
any time navigation occurs.

Fix HTML syntax error for back_button onlick handler.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Check remaining renewals < 1

IOW, handle cases where renewals have been forced and remaining renewals
is less than 0.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO SQL deploy/revert repairs

* Fix syntax errors on revert script
* Fix formatting of email so the 'Subject:' line starts at the front of
  the line, which is required for it to appear as a subject in email.
* Minor reformatting for eye-ease.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Avoid null email/print on batch renew fail

Avoid trying to email/print info about failed batch renewals, otherwise
the page gets stuck on logout.

Print/email info on failed batch renewals could be added, but to do so
means propagating circ IDs into the renewal functions.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 Hide logout-email button when no email set

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1728 SCKO post-dev repairs

Avoid use of 'this' in nested functions, use the main checkout manager
object ref.

More logout code consolidation.

Move new timeout values to variables declared along the top of the
script.

Remove deprecated function.

More code comments.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

CAT-131 Items Out Renew Items functionality

Add a checkbox before each entry in Items Out/Renew Items
interfaces.
Add button for renewing items to Items Out/Renew Items interface.
Add count of remaining renewals to item table.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/circ_page.tt2
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-112 High Contrast wording change.

High contrast text to change between "Turn on High Contrast
Mode" and "Turn off High Contrast Mode" depending on current
stylesheet in use.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/patron_login.tt2
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-112 Unified SCKO

Refactor SCKO interface with bootstrap styling and scaffolding.
Separate different portions of the interface out into their own
files for readability.
Refactor sidebar into bottom button bar.
Remove pay fines front-end functionality.
Remove unnecessary images.
Replace images with newer, updated ones.
Cleanup selfcheck.js.
Add thank-you page with a 5-second timeout.
Create scrollable tables in data itnerfaces.
Convert tabs to spaces.
Display message when there are no available holds.
Center and style "Staff Login Required" text.
Prevent Double-scan of Checkout barcodes.
Doesn't show transactions in the fines list that have a negative balance.
Doesn't show total balance owed.
Separate Theme-based css information into selfcheck-default.css.
Add High contrast theme css file.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
Signed-off-by: Victoria Lewis <vlewis@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/banner.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/circ_page.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/fines.tt2
new file:   KCLS/openils/var/templates_kcls/circ/selfcheck/footer.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/holds_page.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/main.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/patron_login.tt2
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/summary.tt2
modified:   Open-ILS/src/templates/base.tt2
new file:   Open-ILS/web/css/skin/kcls/selfcheck-default.css
new file:   Open-ILS/web/css/skin/kcls/selfcheck-high-contrast.css
modified:   Open-ILS/web/css/skin/kcls/selfcheck.css
deleted:    Open-ILS/web/images/selfcheck/arrow.gif
new file:   Open-ILS/web/images/selfcheck/arrow.png
new file:   Open-ILS/web/images/selfcheck/kcls-logo.png
new file:   Open-ILS/web/images/selfcheck/libcard.jpg
modified:   Open-ILS/web/images/selfcheck/libcard_barcode.jpg
modified:   Open-ILS/web/js/dojo/openils/circ/nls/selfcheck.js
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-125 Suspended Holds Display

Display a separate section for suspended holds.
The holds display has three fields: title, author, and status.
Heading and body are in gray font.

Signed-off-by: Victoria Lewis <vlewis@catalystdevworks.com>
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/main.tt2
modified:   Open-ILS/web/css/skin/kcls/selfcheck.css
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-119 Implement print Holds and Ready for Pick-up

Implement 'Print List' actions under "Hold" and
"Items Ready For Pickup"

Signed-off-by: Victoria Lewis <vlewis@catalystdevworks.com>
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/main.tt2
modified:   Open-ILS/web/js/dojo/openils/circ/nls/selfcheck.js
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-117 Emailed receipts in SCKO

Add email self-checkout receipt functionality, including
sql hooks into deploy and revert folder for getting circ
data under email-selfcheck-receipt.sql

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
Signed-off-by: Skye Howard <showard@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/main.tt2
new file:   KCLS/sql/schema/deploy/selfcheck-email-receipts.sql
new file:   KCLS/sql/schema/revert/selfcheck-email-receipts.sql
modified:   KCLS/sql/schema/sqitch.plan
new file:   KCLS/sql/schema/verify/selfcheck-email-receipts.sql
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

Add org unit phone numbers

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Activate Lake Washington teacher accounts

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Add library phone # to XUL checkout receipts

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Add LIBRARY_PHONE XUL receipt template macro

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1919 UMS monthly user balance export script/cron

Generate a monthly user balance export for retrieval by UMS.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Enable Issaquah teacher card imports

Signed-off-by: Bill Erickson <berickxx@gmail.com>

added KCLS brandmark, used in PO print template.

Bradley Bonner
bbonner@kcls.org

LP#1713138 EDI buyer codes from RFF+API

Support extracting buyer code (AKE edi_account.vendcode) values directly
from the EDI RFF+API field.  This provides better matching to
edi_accounts based on vendcode values for inbound EDI messages.

The code will still fall back to extracting vendcodes appended to the SAN,
when no RFF+API is present.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Student importer too-many-new warning

Logs a warning message and exits when the number of new students to
import exceeds the configured warning threshold (currently 500).  Such
files can be forcably processed via a new --force-new option.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Enable Vashon (402) teacher account imports

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1891 Remove 2.10-era hold copy count columns (LP#1402770)

This paritally reverts LP bug #1402770.

Avoid displaying or fetching data for the 2.10-era copy hold_count columns.
The data is unused locally and adds unnecessary API calls.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1786 2.10 SQL upgrade add missing pieces

Merge the 2.10.0->2.10.1,...,2.10.11->2.10.12 upgrade scripts.  Note
most of these are no-ops.  There were a few function repairs though.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

SIP test script to quickly check all prod servers

Read-only script that makes SIP request to all production SIP servers
plus the production load balancer host.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1787 EG 2.10 SQL sample data

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1787 Add password type table for data exports

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1787 More SQL insert wrappers

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-537 Mark missing pieces in-transit items

Cancel active transits before checking an item back out to the most
recent patron during mark-missing-pieces.  Otherwise, the checkout will
fail.

Commit also removes an unnecessary transaction from the first half of
the API and its associated FIXME messages.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1850 Reset lineitem selection every page

Clear the list of selected lineitems with every lineitem list page
(selection list, PO, etc.).  This prevents an error where lineitems from
a different selection list would be selected for inclusion in a new PO,
leading the undefined JS errors referencing nonexisting lineitems.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1850 ACQ vlagent falls back to browser localStorage

Not related specifically to JBAS-1850, just uncovered during testing.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1799 Skip 2.10 SQL reingests

Skip the partial reingests that came as part of the 2.9->2.10 SQL
upgrade.  Together they are no faster than a full re-ingest, which we
can run with more fine-grained control.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Sample user data address cleanup

Scrub some interesting auto-generated sample data addresses.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Teacher cards short username handles characters

Fixes bug in teacher account generator so that it properly handles
student_id values less than 4 characters for both numbers and letters.

Previously it would fail padding non-numeric IDs.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

Renton Risdon Middle classroom cards

Also remove some errant spaces from the Renton classroom info file.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1786 Remote auth 2.10-style password test

Teach our custom version of remoteauth.cgi to use the new 2.10-style
in-database password check.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1788 KCLS 2.10 Release Notes

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1768 X-port XSS login form repairs

Cross-porting 472bd5ae1486fc0349581b02e666d0e8b8d5c143 to our custom
login form.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1786 Protect Stripe org settings

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1786 KCLS 2.9 -> 2.10 SQL Upgrade

Of note, using iter_count 8 for password encryption.

All inserts are wrapped.

Composed of 2 upgrades, a main, and a data reingest.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1790 SIP uses adopt-syslog, applies syslog ident

Be sure syslog settings applied to the SIP server persist through
OpenSRF configuring its on syslog client.  Apply a specific 'sip' syslog
identity.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1792 Remote auth logging handles barcodes

Fix an issue in remoteauth.cgi logging where it failed to log barcodes
when they were passed via the generic "user" parameter.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1741 Targeter SQL wrap inserts

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1741 Targeter fetches holds in batches

Avoid clobbering the jabber servers with hundreds of thousands of hold
ID messages by grouping the hold IDs into messages of 10k IDs each.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1741 Hold targeter v2 SQL updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1741 Hold targeter v2 gets KCLS has-checked-out-copy

Cross-port code to implement KCLS policy of leaving holds alive so long
as a checked out copy exists regardless of whether the targeter has
reached max org unit target attempt loops.

Signed-off-by: Bill Erickson <berickxx@gmail.com>

LP#1596595: Stamping upgrade scripts for hold targeter refactoring

Signed-off-by: Kathy Lussier <klussier@masslnc.org>

LP#1596595 AOUS lookup batch by org id

Org unit setting value lookup for batches of org units, instead of the
traditional batches by setting name.

Perl live test included.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>

LP#1596595 Hold targeter release notes

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>

LP#1596595 Hold targeter refactoring and optimization.

* New open-ils.hold-targeter service

* Ports hold targeter code to a Perl utility function, communicating w/
  the DB via cstore instead of storage.

* Adds a new global flag 'circ.holds.retarget_interval' for configuring
  the hold retarget interval in the database.

* Adds a new DB function to regenerating hold copy maps to make map
  deletion and creation more efficient.

* Adds an option for targeting holds in newest to oldest order.

* Caches all org unit settings per targeter run.

* Adds support for "skip_viable" option.  This tells the hold targeter
  to avoid modifying any holds that target viable copies.  AKA "fix
  broken" mode.

  For example, you might run in skip_viable mode with a retarget
  interval of 24hr once a day to repair non-viable holds, then also run
  the targeter in regular mode once a day with a retarget interval of 48
  hours to give staff 2 days to process viable holds.

* Hold target loops logic changes:

 ** Org units with fewer target attempts are prioritized during loop
    processing.  So, instead of segregating org units into 2 categetories,
    those attempted in the current loop and those not attempted, sort those
    not attempted by the number number of times they have been attempted.
    Within each grouping, prioritize by target weight/proximity as before.

 ** All org units that have been attempted less than the max configured
    amount are on the table for targeting, not just those that have been
    targeted less than the current loop max.  If no orgs with
    less-than-current-max attempts are found, try orgs that match the
    current max (but are still less than the configured max).

 ** When activated, target looping treats the pickup lib like any
    other org unit.  If a targeted copy at the pickup lib remains
    un-captured, at re-target time, a copy at a different branch is
    chosen (if one is available) even if other copies at the pickup
    lib are targetable.

* Parallel targeting support baked into service.

  Teach the targeter to process a subset of holds based on the number of
  parallel targeters at play and the parallel targeting slot each targeter
  instance occupies.

  As with the existing hold targeter, group holds by their metarecord to
  avoid multiple targeter processes targeting the same sets of potential
  copies.

* Logging / code refactoring and clean up.

* New hold_targeter_v2.pl script for batch hold targeting.  Existing
  targeter remains for backwards-compat.

hold_targeter_v2.pl options:

--verbose
    Print process counts

--parallel <parallel-process-count>
    Number of parallel hold processors to run.  This overrides any
    value found in opensrf.xml

--target-all
    Target all active holds, regardless of when they were last targeted.

--skip-viable
    Avoid modifying holds that currently target viable copies.
    In other words, only (re)target holds in a non-viable state.

--retarget-interval
    Override the 'circ.holds.retarget_interval' global_flag value.

--parallel-init-sleep
    Time to wait between starting each parallel instance.  Useful for
    avoiding dog-piling the DB.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>

JBAS-1581 Backstage cron updates and docs

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1874 Merge patron checkout history

https://bugs.launchpad.net/evergreen/+bug/1712657

Signed-off-by: Bill Erickson <berickxx@gmail.com>

JBAS-1554 Circ history delete untracked

Script to find and delete circulation history rows for patrons who
disabled circ history after the initial migration but before the new
history delete code was deployed.

Signed-off-by: Bill Erickson <berickxx@gmail.com>