working/Evergreen.git
6 years agoCAT-119 Implement print Holds and Ready for Pick-up
Victoria Lewis [Thu, 30 Mar 2017 21:48:31 +0000 (14:48 -0700)]
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

6 years agoCAT-117 Emailed receipts in SCKO
Kyle Huckins [Tue, 9 May 2017 17:58:34 +0000 (10:58 -0700)]
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

6 years agoAdd org unit phone numbers
Bill Erickson [Wed, 22 Nov 2017 16:29:03 +0000 (11:29 -0500)]
Add org unit phone numbers

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoActivate Lake Washington teacher accounts
Bill Erickson [Tue, 21 Nov 2017 14:47:29 +0000 (09:47 -0500)]
Activate Lake Washington teacher accounts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAdd library phone # to XUL checkout receipts
Bill Erickson [Mon, 20 Nov 2017 15:09:08 +0000 (10:09 -0500)]
Add library phone # to XUL checkout receipts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAdd LIBRARY_PHONE XUL receipt template macro
Bill Erickson [Fri, 17 Nov 2017 20:54:12 +0000 (15:54 -0500)]
Add LIBRARY_PHONE XUL receipt template macro

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1919 UMS monthly user balance export script/cron
Bill Erickson [Fri, 10 Nov 2017 16:51:23 +0000 (11:51 -0500)]
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>
6 years agoEnable Issaquah teacher card imports
Bill Erickson [Wed, 15 Nov 2017 19:06:35 +0000 (14:06 -0500)]
Enable Issaquah teacher card imports

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoadded KCLS brandmark, used in PO print template.
Bradley Bonner [Tue, 17 Oct 2017 17:48:05 +0000 (10:48 -0700)]
added KCLS brandmark, used in PO print template.

Bradley Bonner
bbonner@kcls.org

6 years agoLP#1713138 EDI buyer codes from RFF+API
Bill Erickson [Fri, 25 Aug 2017 19:46:31 +0000 (15:46 -0400)]
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>
6 years agoStudent importer too-many-new warning
Bill Erickson [Mon, 16 Oct 2017 14:38:27 +0000 (10:38 -0400)]
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>
6 years agoEnable Vashon (402) teacher account imports
Bill Erickson [Fri, 13 Oct 2017 17:54:10 +0000 (13:54 -0400)]
Enable Vashon (402) teacher account imports

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1891 Remove 2.10-era hold copy count columns (LP#1402770)
Bill Erickson [Wed, 11 Oct 2017 18:35:37 +0000 (14:35 -0400)]
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>
6 years agoJBAS-1786 2.10 SQL upgrade add missing pieces
Bill Erickson [Wed, 4 Oct 2017 16:10:20 +0000 (12:10 -0400)]
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>
6 years agoSIP test script to quickly check all prod servers
Bill Erickson [Thu, 28 Sep 2017 16:54:50 +0000 (12:54 -0400)]
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>
6 years agoJBAS-1787 EG 2.10 SQL sample data
Bill Erickson [Thu, 28 Sep 2017 16:21:23 +0000 (09:21 -0700)]
JBAS-1787 EG 2.10 SQL sample data

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1787 Add password type table for data exports
Bill Erickson [Thu, 28 Sep 2017 16:17:28 +0000 (09:17 -0700)]
JBAS-1787 Add password type table for data exports

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1787 More SQL insert wrappers
Bill Erickson [Thu, 28 Sep 2017 16:40:56 +0000 (12:40 -0400)]
JBAS-1787 More SQL insert wrappers

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-537 Mark missing pieces in-transit items
Bill Erickson [Mon, 5 Jun 2017 22:05:50 +0000 (18:05 -0400)]
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>
6 years agoJBAS-1850 Reset lineitem selection every page
Bill Erickson [Mon, 28 Aug 2017 21:35:23 +0000 (17:35 -0400)]
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>
6 years agoJBAS-1850 ACQ vlagent falls back to browser localStorage
Bill Erickson [Mon, 28 Aug 2017 18:12:04 +0000 (14:12 -0400)]
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>
6 years agoJBAS-1799 Skip 2.10 SQL reingests
Bill Erickson [Wed, 13 Sep 2017 14:20:12 +0000 (10:20 -0400)]
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>
6 years agoSample user data address cleanup
Bill Erickson [Tue, 12 Sep 2017 15:35:09 +0000 (11:35 -0400)]
Sample user data address cleanup

Scrub some interesting auto-generated sample data addresses.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoTeacher cards short username handles characters
Bill Erickson [Mon, 11 Sep 2017 18:25:13 +0000 (14:25 -0400)]
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>
6 years agoRenton Risdon Middle classroom cards
Bill Erickson [Fri, 8 Sep 2017 17:35:25 +0000 (10:35 -0700)]
Renton Risdon Middle classroom cards

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

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1786 Remote auth 2.10-style password test
Bill Erickson [Mon, 14 Aug 2017 15:28:55 +0000 (11:28 -0400)]
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>
6 years agoJBAS-1788 KCLS 2.10 Release Notes
Bill Erickson [Tue, 6 Jun 2017 18:37:27 +0000 (14:37 -0400)]
JBAS-1788 KCLS 2.10 Release Notes

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1768 X-port XSS login form repairs
Bill Erickson [Mon, 3 Jul 2017 15:22:16 +0000 (11:22 -0400)]
JBAS-1768 X-port XSS login form repairs

Cross-porting 472bd5ae1486fc0349581b02e666d0e8b8d5c143 to our custom
login form.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1786 Protect Stripe org settings
Bill Erickson [Mon, 3 Jul 2017 14:13:12 +0000 (10:13 -0400)]
JBAS-1786 Protect Stripe org settings

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1786 KCLS 2.9 -> 2.10 SQL Upgrade
Bill Erickson [Mon, 26 Jun 2017 19:40:20 +0000 (15:40 -0400)]
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>
6 years agoJBAS-1790 SIP uses adopt-syslog, applies syslog ident
Bill Erickson [Mon, 7 Aug 2017 20:27:31 +0000 (16:27 -0400)]
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>
6 years agoJBAS-1792 Remote auth logging handles barcodes
Bill Erickson [Wed, 23 Aug 2017 15:22:51 +0000 (11:22 -0400)]
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>
6 years agoJBAS-1741 Targeter SQL wrap inserts
Bill Erickson [Fri, 30 Jun 2017 18:36:46 +0000 (14:36 -0400)]
JBAS-1741 Targeter SQL wrap inserts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1741 Targeter fetches holds in batches
Bill Erickson [Tue, 30 May 2017 16:57:07 +0000 (12:57 -0400)]
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>
6 years agoJBAS-1741 Hold targeter v2 SQL updates
Bill Erickson [Fri, 10 Mar 2017 16:59:26 +0000 (11:59 -0500)]
JBAS-1741 Hold targeter v2 SQL updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1741 Hold targeter v2 gets KCLS has-checked-out-copy
Bill Erickson [Fri, 24 Jun 2016 20:56:58 +0000 (16:56 -0400)]
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>
6 years agoLP#1596595: Stamping upgrade scripts for hold targeter refactoring
Kathy Lussier [Fri, 17 Feb 2017 06:12:08 +0000 (01:12 -0500)]
LP#1596595: Stamping upgrade scripts for hold targeter refactoring

Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1596595 AOUS lookup batch by org id
Bill Erickson [Tue, 7 Feb 2017 17:25:01 +0000 (12:25 -0500)]
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>
6 years agoLP#1596595 Hold targeter release notes
Bill Erickson [Fri, 1 Jul 2016 15:26:26 +0000 (11:26 -0400)]
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>
6 years agoLP#1596595 Hold targeter refactoring and optimization.
Bill Erickson [Tue, 7 Jun 2016 21:32:14 +0000 (17:32 -0400)]
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>
6 years agoJBAS-1581 Backstage cron updates and docs
Bill Erickson [Thu, 11 May 2017 20:37:52 +0000 (16:37 -0400)]
JBAS-1581 Backstage cron updates and docs

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1874 Merge patron checkout history
Bill Erickson [Wed, 23 Aug 2017 19:59:26 +0000 (15:59 -0400)]
JBAS-1874 Merge patron checkout history

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

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Circ history delete untracked
Bill Erickson [Tue, 15 Aug 2017 14:21:36 +0000 (10:21 -0400)]
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>
6 years agoJBAS-1554 Circ history checker log cleanup
Bill Erickson [Mon, 14 Aug 2017 18:03:08 +0000 (14:03 -0400)]
JBAS-1554 Circ history checker log cleanup

Log each affected user once (instead of once per circ) for ease of
manual cleanup.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Circ history checker log correct offset
Bill Erickson [Mon, 14 Aug 2017 16:12:01 +0000 (12:12 -0400)]
JBAS-1554 Circ history checker log correct offset

Log the correct 0-based offset when reporting patrons that have
un-migrated circulations.  This makes manually repairing them easier.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Circ history migration check script
Bill Erickson [Mon, 14 Aug 2017 15:48:46 +0000 (11:48 -0400)]
JBAS-1554 Circ history migration check script

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1867 Disable lost.auto event creation
Bill Erickson [Mon, 7 Aug 2017 14:19:29 +0000 (10:19 -0400)]
JBAS-1867 Disable lost.auto event creation

Piling lost.auto event creation on top of checkout.due events for auto
mark lost often results dying A/T drone processes.  Cause is still
unknown.  Since we're not currently using lost.auto events, disable
lost.auto creation pending a resolution.

This primarily affects the 28-day auto mark lost reactor.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1817 Hide BC screen reader links via local CSS
Bill Erickson [Thu, 29 Jun 2017 14:58:05 +0000 (10:58 -0400)]
JBAS-1817 Hide BC screen reader links via local CSS

BC screen reader links are not hidden as expected using only the code
delivered by their API.  Add some custom local CSS to hide them.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1817 BC header/footer API updates
Bill Erickson [Thu, 29 Jun 2017 14:44:24 +0000 (10:44 -0400)]
JBAS-1817 BC header/footer API updates

Update self-reg (patron card app) to use the new BC header/footer/etc
API.

TODO: resolve issue where screen reader navigation is visible.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoBackstage quarterly bib export count email
Bill Erickson [Mon, 17 Jul 2017 19:15:31 +0000 (15:15 -0400)]
Backstage quarterly bib export count email

Send an email after the quarterly bib export file has been generated and
uploaded with the count of bib records in the file.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoBackstage monthly authority CRONTAB updates
Bill Erickson [Fri, 23 Jun 2017 16:15:37 +0000 (12:15 -0400)]
Backstage monthly authority CRONTAB updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Aged circ SQL update drop repair cont.
Bill Erickson [Wed, 21 Jun 2017 19:57:07 +0000 (12:57 -0700)]
JBAS-1554 Aged circ SQL update drop repair cont.

Avoid trying to drop functions that may not yet exist.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoEDI pusher always uses passive FTP
Bill Erickson [Thu, 15 Jun 2017 19:08:30 +0000 (15:08 -0400)]
EDI pusher always uses passive FTP

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1148 Set cat date on new vandelay records
Bill Erickson [Wed, 7 Jun 2017 21:22:55 +0000 (17:22 -0400)]
JBAS-1148 Set cat date on new vandelay records

Set bre.cataloging_date = now for all bib records created as new from
the MARC Batch Import UI.

API supports setting this optionally via new set_cat_date option.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 User circ history transitional API
Bill Erickson [Tue, 6 Jun 2017 21:49:22 +0000 (17:49 -0400)]
JBAS-1554 User circ history transitional API

Retain dummy versions of the old circ history API calls to avoid any
unexpected explosions during the 2.9.003 upgrade and BC circ history
code migration.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Custom purge circs SQL params repair
Bill Erickson [Mon, 5 Jun 2017 15:22:52 +0000 (11:22 -0400)]
JBAS-1554 Custom purge circs SQL params repair

Update action.purge_circulations_custom definition to include the start
and end time function parameters to ensure the existing function is
replaced instead of creating a new function.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Aged circ SQL update drop repair
Bill Erickson [Fri, 2 Jun 2017 14:36:59 +0000 (10:36 -0400)]
JBAS-1554 Aged circ SQL update drop repair

DROP some functions before a view they depend on is replaced.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1792 Log remoteauth (ezproxy) login failures
Bill Erickson [Mon, 15 May 2017 20:44:06 +0000 (16:44 -0400)]
JBAS-1792 Log remoteauth (ezproxy) login failures

Log all of the reasons a remoteauth login might have failed, including
bad passwords.  Useful for debugging student e-card authentication
issues.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Create aged circ index concurrently
Bill Erickson [Tue, 18 Apr 2017 14:38:29 +0000 (10:38 -0400)]
JBAS-1554 Create aged circ index concurrently

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Avoid duplicate circ_ids vars
Bill Erickson [Mon, 17 Apr 2017 16:00:03 +0000 (12:00 -0400)]
JBAS-1554 Avoid duplicate circ_ids vars

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Aged circ index timeout
Bill Erickson [Mon, 17 Apr 2017 15:23:19 +0000 (08:23 -0700)]
JBAS-1554 Aged circ index timeout

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Aged circ parent circ index
Bill Erickson [Tue, 17 Jan 2017 18:35:07 +0000 (13:35 -0500)]
JBAS-1554 Aged circ parent circ index

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 Apply 1 year circ purge config
Bill Erickson [Thu, 13 Oct 2016 19:53:49 +0000 (15:53 -0400)]
JBAS-1554 Apply 1 year circ purge config

Also avoid overwriting the config within the nightly purge script.
That's confusing.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 C/O history tpac display repair (kcls template)
Bill Erickson [Fri, 2 Sep 2016 14:16:51 +0000 (10:16 -0400)]
JBAS-1554 C/O history tpac display repair (kcls template)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 C/O history phase 2 SQL
Bill Erickson [Thu, 1 Sep 2016 21:35:16 +0000 (17:35 -0400)]
JBAS-1554 C/O history phase 2 SQL

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1419 CO history deployment SQL tweaks
Bill Erickson [Wed, 31 Aug 2016 15:00:25 +0000 (11:00 -0400)]
JBAS-1419 CO history deployment SQL tweaks

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1419 CO history statement timeout
Bill Erickson [Wed, 31 Aug 2016 14:40:04 +0000 (10:40 -0400)]
JBAS-1419 CO history statement timeout

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1419 CO history usr index (LP#1615736)
Bill Erickson [Wed, 31 Aug 2016 14:31:09 +0000 (10:31 -0400)]
JBAS-1419 CO history usr index (LP#1615736)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1419 CO history handles serials copies
Bill Erickson [Wed, 31 Aug 2016 14:28:05 +0000 (10:28 -0400)]
JBAS-1419 CO history handles serials copies

Cross-port 6479b578.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1419 Aged circ API/SQL cross-port
Bill Erickson [Thu, 25 Aug 2016 14:18:51 +0000 (10:18 -0400)]
JBAS-1419 Aged circ API/SQL cross-port

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoStamping upgrade scripts for aged circs display branch
Mike Rylander [Wed, 24 Aug 2016 22:32:02 +0000 (18:32 -0400)]
Stamping upgrade scripts for aged circs display branch

Signed-off-by: Mike Rylander <mrylander@gmail.com>
6 years agoLP#1497335 Aged/All circulation API access
Bill Erickson [Wed, 3 Aug 2016 17:34:29 +0000 (13:34 -0400)]
LP#1497335 Aged/All circulation API access

Various SQL, IDL, and API changes for accessing aged circulations,
primarily via all_circulation objects, for imporoved staff client
integration.

*. Support open-ils.pcrud access to the action.all_circulation DB view /
   'combcirc' class.

*. Add missing parent_circ, checkin_scan_time, checkin_workstation to
   combcirc class.

*. Add 'usr' field to combcirc.  The action.all_circulation VIEW will
   return NULL as the 'usr' column value when returning data for an
   aged_circulation.

*. Add virtual 'active_circ' and 'aged_circ' fields to combcirc for
   fleshing the related action.circulation or action.aged_circulation
   object.

* Adds SQL functions for action.all_circ_chain and
  action.summarize_all_circ_chain, which pull data from
  aged_circulation.

*. API calls
open-ils.circ.[prev_]renewal_chain.retrieve_by_circ[.summary] now return
data for active and aged circulations by using action.all_circ_chain and
action.summarize_all_circ_chain.  When using these APIs, a null value
in the 'usr' column is the indication that a given circulation or circ
chain summary represents an aged circulation.

* API open-ils.circ.copy_details.retrieve will now optionally return
  aged circ data within the copy circ history.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1326 C/O history TPAC cross-port
Bill Erickson [Mon, 16 May 2016 14:22:57 +0000 (10:22 -0400)]
JBAS-1326 C/O history TPAC cross-port

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1326 C/O History SQL Backport
Bill Erickson [Fri, 13 May 2016 20:09:43 +0000 (16:09 -0400)]
JBAS-1326 C/O History SQL Backport

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1312699: Minor modifications to patron checkout history deletions
Jake Litrell [Tue, 1 Mar 2016 22:22:28 +0000 (17:22 -0500)]
LP#1312699: Minor modifications to patron checkout history deletions

Minor modifications to make patron checkout history deletions work with
the new table.  open-ils.actor.history.circ.clear
extended to take an optional list of circ_ids, to limit what's deleted
from the history.

Signed-off-by: Jake Litrell <jake@masslnc.org>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1312699 - Add feature to allow user to edit their checkout history.
Dan Pearl [Tue, 20 Oct 2015 21:05:07 +0000 (17:05 -0400)]
LP#1312699 - Add feature to allow user to edit their checkout history.

In the checkout history page, a new column and action selector is provided to allow
the paton to indicate items they would just as soon not want to see again in the
history list for whatever reason.  NOTE: This is not a PURGE function; it simply
suppresses display of items in the history list (and exported history files).
Internally, the circulations are kept by Evergreen for several reasons which are
not affected by this functionality.

Signed-off-by: Dan Pearl <dpearl@cwmars.org>
Signed-off-by: Josh Stompro <stomproj@larl.org>
Signed-off-by: Jake Litrell <jake@masslnc.org>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1564079 Stamping upgrade script
Kathy Lussier [Wed, 27 Apr 2016 14:35:49 +0000 (10:35 -0400)]
LP#1564079 Stamping upgrade script

Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1564079 Checkout history skips nonexistent items
Bill Erickson [Wed, 30 Mar 2016 21:57:59 +0000 (17:57 -0400)]
LP#1564079 Checkout history skips nonexistent items

Modify the user checkout history migration process
(2.9.3-2.10.0-upgrade-db.sql and 0960.schema.decouple_co_history.sql) to
avoid inserting history rows for circulations whose copies do not
exist in the database.

For reference, this is a rare condition that cannot be recreated in a
modern EG system short of modifying constraints.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1564079 Checkout history handles serials
Bill Erickson [Wed, 30 Mar 2016 21:49:26 +0000 (17:49 -0400)]
LP#1564079 Checkout history handles serials

Remove the target_copy foreign key constraint on action.usr_circ_history
so that it does not prevent creation of rows from circulation's that
link to serial.unit objects.  Similar to action.circulation, the foreign
key constraint is enforced via a evergreen.fake_fkey_tgr trigger
instead.

This modifies the 2.9.3-2.10.0-upgrade-db.sql and 0960 upgrade scripts,
since without this change, the scripts may fail.

A separate upgrade script is added to drop the constraint for those who
have already successfully run the the 2.9.3-2.10.0-upgrade-db.sql script
(i.e. those who don't use serials).  For simplicity, the
evergreen.fake_fkey_tgr trigger is only applied in this separate upgrade
script (in addition to the base schema, of course).

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Conflicts:
Open-ILS/src/sql/Pg/version-upgrade/2.9.3-2.10.0-upgrade-db.sql

6 years agoLP#1527342 Stamping upgrade script decouple checkout history
Kathy Lussier [Fri, 26 Feb 2016 00:30:05 +0000 (19:30 -0500)]
LP#1527342 Stamping upgrade script decouple checkout history

Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1527342 Patron checkout history table release notes
Bill Erickson [Mon, 28 Dec 2015 17:22:57 +0000 (12:22 -0500)]
LP#1527342 Patron checkout history table release notes

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1527342 Patron co history remove on purge
Bill Erickson [Wed, 30 Dec 2015 16:53:52 +0000 (11:53 -0500)]
LP#1527342 Patron co history remove on purge

Delete checkout history rows when purging a user.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoLP#1527342 Patron checkout history SQL/IDL
Bill Erickson [Fri, 18 Dec 2015 23:09:16 +0000 (18:09 -0500)]
LP#1527342 Patron checkout history SQL/IDL

Adds a new table action.usr_circ_history for tracking opt-in checkout
history.  History is maintained via trigger on action.circulation.

Includes updates to html/email/csv checkout history templates to
gracefully handle NULL checkin_time values, since history starts as soon
as an item is checked out.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
6 years agoJBAS-1581 Backstage docs continued
Bill Erickson [Mon, 15 May 2017 15:39:43 +0000 (11:39 -0400)]
JBAS-1581 Backstage docs continued

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1722 Automate backstage bib collisions processing
Bill Erickson [Mon, 15 May 2017 15:32:38 +0000 (11:32 -0400)]
JBAS-1722 Automate backstage bib collisions processing

Adds a separate command for processing bib collisions files.

./backstage-agent.sh -p <admin-pass> -c

Leaving as a separate command for now so that I can run it manually the
first time or two.  Will later integrate this into the quarterly results
processing task.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1581 Backstage cron updates and docs
Bill Erickson [Thu, 11 May 2017 20:37:52 +0000 (16:37 -0400)]
JBAS-1581 Backstage cron updates and docs

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-826 Revert custom hold counts part II
Bill Erickson [Mon, 6 Feb 2017 21:37:18 +0000 (16:37 -0500)]
JBAS-826 Revert custom hold counts part II

Remove all traces of the custom holds-per-bib count code.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1766 More insert-on-deploy wrappers
Bill Erickson [Fri, 14 Apr 2017 19:51:09 +0000 (15:51 -0400)]
JBAS-1766 More insert-on-deploy wrappers

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1766 KCLS 2.9 sample SQL data update
Bill Erickson [Fri, 14 Apr 2017 19:01:58 +0000 (12:01 -0700)]
JBAS-1766 KCLS 2.9 sample SQL data update

Updated sample bib record set and new data export for 2.9 data.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1766 2.9 SQL upgrade wrap inserts
Bill Erickson [Mon, 20 Mar 2017 15:55:52 +0000 (11:55 -0400)]
JBAS-1766 2.9 SQL upgrade wrap inserts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1742 2.9 authority ingest after 2.9.002 SQL
Bill Erickson [Thu, 4 May 2017 14:50:56 +0000 (10:50 -0400)]
JBAS-1742 2.9 authority ingest after 2.9.002 SQL

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-103 Add missing API call to XUL constants files
Bill Erickson [Mon, 12 Jun 2017 22:04:31 +0000 (18:04 -0400)]
CAT-103 Add missing API call to XUL constants files

FM_ACP_BATCH_RETRIEVE_VIA_ACN_LIST.authoritative is referenced by XUL
but not defined.  Add it to the constants file.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-673 Post 2.9 multi-page repairs
Bill Erickson [Mon, 12 Jun 2017 21:33:52 +0000 (17:33 -0400)]
JBAS-673 Post 2.9 multi-page repairs

Only attempt to render copy details for lineitems that are part of the
currently displayed page of lineitems.  Alt fix for LP#1208613.

To ease debugging and eventual support by the browser client, use the
borwser's localStorage object when not in XUL mode.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoRevert "LP#1208613: Reset lineitem cache when resetting table"
Bill Erickson [Mon, 12 Jun 2017 21:19:02 +0000 (17:19 -0400)]
Revert "LP#1208613: Reset lineitem cache when resetting table"

Avoid clearing the lineitem cache on each page of lineitems.  We need
the cache to for multi-page selection-to-PO support.  If the original
bugs addressed by this commit resurface, we can resolve it by
maintaining 2 caches, the stock liCache and a separate parallel cache
used just for multi-page actions.

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

https://kcevergreen.atlassian.net/browse/JBAS-673

This reverts commit 341babf860a20539529e29db252545031b01ed5f.

6 years agoAuthority linking scripts CRONTAB synchronization
Bill Erickson [Mon, 5 Jun 2017 14:57:10 +0000 (10:57 -0400)]
Authority linking scripts CRONTAB synchronization

Update the sample CRONTAB to match how linking new/modified authority
records scripts are run in production.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoStudent importer now uses Tukwila (not Foster)
Bill Erickson [Fri, 2 Jun 2017 20:06:45 +0000 (16:06 -0400)]
Student importer now uses Tukwila (not Foster)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoDisable SIP stderr logging by default
Bill Erickson [Tue, 23 May 2017 14:44:42 +0000 (10:44 -0400)]
Disable SIP stderr logging by default

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-826 Record hold counts for bib-level only
Bill Erickson [Mon, 22 May 2017 18:21:05 +0000 (14:21 -0400)]
JBAS-826 Record hold counts for bib-level only

Modify the holds-per-record counting code to only look at title-level
holds, for now anyway.  This is makes the query a lot faster, which
is a concern given that we still see several million API calls to
open-ils.circ.bre.holds.count per day.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 C/O history logging mods
Bill Erickson [Thu, 1 Sep 2016 21:23:33 +0000 (17:23 -0400)]
JBAS-1554 C/O history logging mods

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1554 C/O history deployment script mods
Bill Erickson [Thu, 1 Sep 2016 21:22:03 +0000 (14:22 -0700)]
JBAS-1554 C/O history deployment script mods

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