working/Evergreen.git
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>
6 years agoJBAS-1554 Patron C/O history migration phase 1
Bill Erickson [Thu, 1 Sep 2016 20:37:39 +0000 (16:37 -0400)]
JBAS-1554 Patron C/O history migration phase 1

New circ history table and functions, plus script to migrate circ
history in batches.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1736 Remove unused, stranded transaction in LI fetcher
Bill Erickson [Tue, 25 Apr 2017 20:23:55 +0000 (16:23 -0400)]
JBAS-1736 Remove unused, stranded transaction in LI fetcher

Remove unnecessary and un-closed xact=>1 in custom lineitem fetching code.
This avoids leaving cstore backends stranded.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1736 Prevent barcode changes on items in controlled statuses
Bill Erickson [Fri, 17 Feb 2017 21:14:31 +0000 (16:14 -0500)]
JBAS-1736 Prevent barcode changes on items in controlled statuses

Disable barcode edit text input when a copy is in a non-editable
status in the "Update Items" and "Create Or Re-Barcode Items" interfaces.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-103 Clean up pauseComp()
Kyle Huckins [Tue, 3 Jan 2017 23:20:08 +0000 (15:20 -0800)]
CAT-103 Clean up pauseComp()

Remove instances of pauseComp() in copy_browser.js
and cat/util.js in favor of .authoritative calls.

Make open-ils.search.asset.copy.batch.retrieve
authoritative.

Signed-off-by: Kyle Huckins <khuckins@catalystdevworks.com>
6 years agoCAT-47 Checkout receipt shows due date time for hourly checkouts
Victoria Lewis [Thu, 25 Feb 2016 17:05:33 +0000 (12:05 -0500)]
CAT-47 Checkout receipt shows due date time for hourly checkouts

Due date time (hour and minute) shows on checkout receipts
when the circulation duration for the checked out item
is less than a day.

Signed-off-by: Victoria Lewis <vLewis@catalystdevworks.com>
modified:   Open-ILS/xul/staff_client/chrome/content/util/print.js

6 years agoJBAS-826 Revert custom hold counts part I
Bill Erickson [Mon, 6 Feb 2017 21:36:16 +0000 (16:36 -0500)]
JBAS-826 Revert custom hold counts part I

Teach the API to call the stock holds-per-record counting code,
bypassing the custom KCLS code.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1405 Revert custom hold queue stats code
Bill Erickson [Mon, 6 Feb 2017 22:11:53 +0000 (17:11 -0500)]
JBAS-1405 Revert custom hold queue stats code

Return to using the custom hold queue position calculation code.
This merely moves the logic from the DB back into the Perl code.  The
query logic is unchanged.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1619703 Transfer ACQ lineitem XUL UI
Bill Erickson [Fri, 17 Mar 2017 20:32:38 +0000 (16:32 -0400)]
LP#1619703 Transfer ACQ lineitem XUL UI

Support for marking a bib record as a lineitem transfer destination for
the XUL client.  Adds a new menu entry under the 'Actions For This
Record' menu in the main bib record UI.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1619703 Transfer ACQ lineitem browser UI
Bill Erickson [Fri, 17 Mar 2017 19:36:35 +0000 (15:36 -0400)]
LP#1619703 Transfer ACQ lineitem browser UI

Supports marking a bib record as a lineitem transfer destination in the
web staff bib record detail interface.  Found in the 'Mark For:' selector
menu.

Supports inititiating the transfer from the embedded ACQ purchase order
interface.  ACQ action is found in the Actions selector for each
lineitem.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1619703 Transfer ACQ lineitem to bib API
Bill Erickson [Tue, 4 Oct 2016 19:23:22 +0000 (15:23 -0400)]
LP#1619703 Transfer ACQ lineitem to bib API

New open-ils.acq API call for transfering a lineitem and its assets
to a new bib record.

Any asset.call_number's created from the lineitem are migrated to the
new target bib record.

Any monograph parts linked to copies created from the lineitem are
duplicated (if need) on the target bib record and part copy maps are
modified to use the new parts.

API: open-ils.acq.lineitem.transfer_to_bib(auth, li_id, target_bib_id)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1767 PG 9.6 replace connect-by (perm funcs)
Bill Erickson [Thu, 20 Apr 2017 19:37:31 +0000 (15:37 -0400)]
JBAS-1767 PG 9.6 replace connect-by (perm funcs)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-80 Set focus to distribution formula
Kyle Huckins [Tue, 20 Sep 2016 21:12:23 +0000 (14:12 -0700)]
CAT-80 Set focus to distribution formula

Refactor focusCopyLibSelector to accept a boolean
parameter and have the option to move foucs onto
the distribution formula field instead of the first
copy's owning library selector.

Signed-off-by: Kyle Huckins <khuckins@catalystdevworks.com>
6 years agoJBAS-1767 PG 9.6 remove connect-by
Bill Erickson [Mon, 20 Mar 2017 16:09:07 +0000 (12:09 -0400)]
JBAS-1767 PG 9.6 remove connect-by

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoeg-updater -a start-util starts edi_webrick process
Bill Erickson [Mon, 24 Apr 2017 19:14:35 +0000 (15:14 -0400)]
eg-updater -a start-util starts edi_webrick process

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Self-reg kiosk mode additions (submit another, etc.)
Bill Erickson [Thu, 30 Mar 2017 18:41:34 +0000 (14:41 -0400)]
JBAS-1665 Self-reg kiosk mode additions (submit another, etc.)

* Hide submit-another button in kiosk mode
* Adds a black border around the verification requirements "wall of
  text"
* Clicking on a card image now selects the image -- no longer necessary
  to click exactly on the radio input.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1732 Lake Washington school/classroom cards
Bill Erickson [Mon, 6 Mar 2017 21:55:31 +0000 (13:55 -0800)]
JBAS-1732 Lake Washington school/classroom cards

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1761 Skykomish school cards
Bill Erickson [Fri, 10 Mar 2017 20:27:23 +0000 (12:27 -0800)]
JBAS-1761 Skykomish school cards

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1760 Mark claims-returned voids overdues with 'void'
Bill Erickson [Mon, 13 Mar 2017 20:38:50 +0000 (16:38 -0400)]
JBAS-1760 Mark claims-returned voids overdues with 'void'

Revert 2.9-era change that resulted in using Account Adjustment
payments to void overdues when an item is marked claims returned.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoRemove base schema manual HSTORE definitions
Bill Erickson [Fri, 2 Dec 2016 15:43:35 +0000 (10:43 -0500)]
Remove base schema manual HSTORE definitions

As of PG 9.1, we no longer need to create all of the hstore components
(operators, etc.) in the schema.  A simple "create extension hstore"
handles that for us.  Removing the manual operator creation also avoids
deprecation warnings when buliding new databases.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1739 ADP file management script
Bill Erickson [Tue, 28 Feb 2017 17:43:39 +0000 (12:43 -0500)]
JBAS-1739 ADP file management script

Script to archive daily ADP files and alert when a daily file is not
delivered.  Runs on the SFTP server.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1760 Mark lost voids overdues with 'void'
Bill Erickson [Thu, 9 Mar 2017 17:50:07 +0000 (12:50 -0500)]
JBAS-1760 Mark lost voids overdues with 'void'

Revert 2.9-era change that resulted in using Account Adjustment payments
to void overdues when an item is marked lost.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 SCKO return-to timeout before login
Bill Erickson [Wed, 8 Mar 2017 20:13:25 +0000 (15:13 -0500)]
JBAS-1665 SCKO return-to timeout before login

Allow SCKO to timeout and return to the return-to URL (if set) even
if the patron login process never completes.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1705 New headings defaults to yesterday repair
Bill Erickson [Tue, 7 Mar 2017 16:51:17 +0000 (11:51 -0500)]
JBAS-1705 New headings defaults to yesterday repair

Avoid clobbering the default date value when the first query is run.
Use the values (yesterday) set in the init function.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1705 New headings search excludes 12am next day
Bill Erickson [Thu, 2 Feb 2017 17:25:01 +0000 (12:25 -0500)]
JBAS-1705 New headings search excludes 12am next day

Search for headings with dates < end-date + 1 day, instead of <= (or
between) so that 12am next day is not included.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1705 New heading does not fire at load
Bill Erickson [Mon, 23 Jan 2017 16:25:11 +0000 (11:25 -0500)]
JBAS-1705 New heading does not fire at load

Avoid starting the report until the user has initiated the report.
Report date range defaults to yesterday.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1705 New heading remove TCN href
Bill Erickson [Mon, 23 Jan 2017 15:15:32 +0000 (10:15 -0500)]
JBAS-1705 New heading remove TCN href

Display TCN as a regular text value instead of a link, since it's mainly
used for copy/paste.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 SCKO fix return-to from timeout
Bill Erickson [Mon, 27 Feb 2017 17:23:02 +0000 (12:23 -0500)]
JBAS-1665 SCKO fix return-to from timeout

Fix the return-to URL handling when accessed from the various
auto-timeout operations.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 return-to=self option; timeout repairs
Bill Erickson [Wed, 15 Feb 2017 17:33:56 +0000 (12:33 -0500)]
JBAS-1665 return-to=self option; timeout repairs

Adds a special ?return-to=self parameter, telling the UI to return to
its own URL after completion / timeout / exit.

Rely solely on JS activity checker for page timeouts.  Otherwise, the
refresh simply overrides the activity checker.

Put all timeout value configuration into the template so no JS changes
are required for timeout changes.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Field validation CSS repair
Bill Erickson [Mon, 30 Jan 2017 15:21:16 +0000 (10:21 -0500)]
JBAS-1665 Field validation CSS repair

Use jquery to set/remove classes during field validation tests to ensure
other classes on the elements are not accidentally removed.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Kiosk defaults to pickup at lib
Bill Erickson [Wed, 25 Jan 2017 17:47:51 +0000 (09:47 -0800)]
JBAS-1665 Kiosk defaults to pickup at lib

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Self-reg docs on success page; raise suc. timeout
Bill Erickson [Thu, 19 Jan 2017 21:53:05 +0000 (16:53 -0500)]
JBAS-1665 Self-reg docs on success page; raise suc. timeout

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Selfreg no-wrapper=>kiosk; inline docs WIP
Bill Erickson [Thu, 12 Jan 2017 17:34:13 +0000 (12:34 -0500)]
JBAS-1665 Selfreg no-wrapper=>kiosk; inline docs WIP

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1665 Self-register no-wrapper hides sidebar
Bill Erickson [Thu, 12 Jan 2017 17:06:40 +0000 (12:06 -0500)]
JBAS-1665 Self-register no-wrapper hides sidebar

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