JBAS-1969 Bib merge tracking sql port

Cross-porting SQL from LP#1744996.

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

LP#1744996 Track bib record merges

Adds "merge_date" and "merged_to" fields for bib records.  Merge date
is applied to all records involved in a record merge at merge time.
merged_to is applied to all subordinate (merged) records and points to
the target record.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Remington Steed <rjs7@calvin.edu>
Signed-off-by: Dan Wells <dbw2@calvin.edu>

JBAS-1969 Disable sqitch verify

Disable the 'verify' option and remove all of the stub verify scripts.
We've never used it.

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

JBAS-1998 Sftp client process selected district code

Fixes a bug where selecting a specific district code using -d would
process the selected code plus all college codes.

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

Revert "JBAS-2012 Hide acq cost value in item summaries"

Didn't mean to commit here...

This reverts commit 7bc02e398a74b4b2fbe83a465454234972660f5d.

JBAS-2012 Hide acq cost value in item summaries

This version just hides the value, but leaves the fields.

Includes web client and XUL client.

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

JBAS-1998 College barcodes upper case district code

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

JBAS-1998 Sftp client looks for college files

Teach the SFTP client script to add college districts to its list of
district codes to loop over when looking in batch for new files to
process.

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

JBAS-1998 College cards import tweaks

* 4-year expire
* sftp file checks updates

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

JBAS-1998 LWT school and teacher accounts

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

JBAS-2019 Vand preserve spec keeps all fields

Adjust the new vandelay.replace_field function so that it copies all
"preserved" fields from the source record to the target record, not just
those that have matching spot on the target record.

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

Tahoma Maple View school cards

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

JBAS-1803 Wrap outreach grp SQL for insert_on_deploy

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

JBAS-1803 Add public to call_number_class search_path

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

JBAS-1803 Update sample data from 2.12 prod data

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

JBAS-1803 Update sample bibs from current production

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

JBAS-1803 Drop sample rec export count from 750 to 500

To speed up building dev machines.

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

JBAS-1803 Add org closed dates to sample exports

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

JBAS-2007 Vandelay import/overlay updates edit date

Configure all merge profiles, except for match-only merge, to result in
an update of the bib record editor (when available) and edit date values.

Recover KCLS customization that caused edit_date to be updated
regardless of whether an editor value is supplied.

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

JBAS-2008 Search strip apostrophes recover

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

JBAS-2005 Hold queue pos API uses rhrr

Consistent with BC hold queue pos function, we now determine the hold
queue position by comparing holds that target the same bib.  Uses the
newly materialized (as of 2.12) reporter.hold_request_record table.

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

JBAS-2005 BC hold queue position uses 'rhrr' class

Queue is now defined as holds which target the same bib record, not
necessarily those that share a targetable copy.

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

JBAS-2006 Hold shelf expire date speed up

Move the hold shelf expire date calculation into a new set of utility
functions and refactor to avoid excess DB calls for overall speedups.

Adds a new open-ils.actor.org_unit.open_day_range API call for testing
the new code and for possible future use.

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

Copy location API for BC OpenSRF 2.5 repair

Override the default OpenSRF message chunking settings by setting
max_chunk_size => 0 on the copy location fetch-all API, which returns a
large collection of data.

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

Hold shelf expire cstore keepalive

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

Remove canceled transit from magic statuses to allow editing

Note setting disable_in_copy_editor=false did not suffice to allow
editing.  The whole like had to be removed.

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

JBAS-1997 Prevent sequential scans in hold queue pos func

Brute-force the PG planner to make it use index scans instead of
sequential scans in the hold queue position stored proc.  This resolves
a problem where the planner starts using seq scans over time as the
stats morph in the presence of lots of active, large-queue holds.

Avoidin the seq scan shows consistently better performance.

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

JBAS-1802 2.12 SQL upgrade commits

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

JBAS-1923 Add Outreach SI profile

1. New profile group under Outreach
2. checkout max set to 100
3. Add group to user editor

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

JBAS-1984 Large screen scan box btm border padding

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

CAT-184 - SCKO Button Size Increase

-Slight increase in button size for btn-repsonsive and
scko-footer-btn

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/css/skin/kcls/selfcheck.css

CAT-184 SCKO Fonts Continued

- Create new btn-responsive css class to handle button sizes
based on screen size
- Apply font size change to scko-footer-btn when under specific
resolutions, to keep text inside the button.

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

JBAS-1984 SCKO more misc. tewaks

Add enter PIN instructions

JBAS-1984 Hi-contrast text color tweaks

JBAS-1984 V-align SCKO go/cancel buttons w/ text

Top of go/cancel buttons lines up with top of PIN text input.

JBAS-1984 Increase vert padding for logout buttons

JBAS-1984 SCKO font css consolidation

Migrate font-embiggening into the default and high-contrast css files
using @media params.

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

SCKO Unaccent checkout items labels

The hard-coded 'black' color on the checkout list labels makes the
appear too bold.  Use default color to match the items-out list.

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

JBAS-1981 SCKO Misc tweaks

Total/Session counts move to tab

Move the counts down into the checkouts tab so it's always visible.

SCKO label change Pickup -> Pick-up

JBAS-1984 SCKO Fines table extends horizontally

Remove unnecessary call to show() the fines tbody, since it
(unkowningly) changed the display attribute to 'block', breaking the
table flow.

JBAS-1984 SCKO Remove refs to undefined div

Avoid JS errors by avoiding attempts to dereference an undefined DOM
node with id 'oils-selfck-status-div3'.

JBAS-1984 SCKO Larger font-d option

JBAS-1984 SCKO unable to process message tweaks

Show original "unable to process item XYZ" message in non-batch checkout
and renewal mode.  Show generic see staff message for batch equivalents.

JBAS-1984 Bump high-contrast font sizes

JBAS-1984 More font tweaks for size d

JBAS-1984 SCKO bold item details during checkout

CAT-176 SCKO Font Size Tweaks

- Provide three options for font sizes. Does not include changes to
High Contrast Mode

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/circ/selfcheck/style.css
modified:   Open-ILS/web/css/skin/kcls/selfcheck-default.css
new file:   Open-ILS/web/css/skin/kcls/selfcheck-font-b.css
new file:   Open-ILS/web/css/skin/kcls/selfcheck-font-c.css

CAT-182 SCKO Fine Tab Outline

- Apply CSS outline to Fines tab when a positive
fine exists.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
Signed-off-by: Alex Cautley <acautley@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/css/skin/kcls/selfcheck.css
modified:   Open-ILS/web/js/ui/kcls/circ/selfcheck/selfcheck.js

CAT-180 SCKO Checkbox Styling

- Embiggen Checkboxes

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/css/skin/kcls/selfcheck.css

CAT-181 SCKO Wording Tweaks

- Change "Fees" to "Fines."
- Unbold Table Labels.
- Bold table contents.
- Add callnumber to Items ready for pickup.

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

CAT-178 Login Tweaks

- Remove "Steps" text.
- Move "Enter" instructions to top of login barcode box.
- Move Example text into input boxes.
- Match example barcode to barcode in image.

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

CAT-177 SCKO Button Tweaks

- Increase space between Sidebar buttons.
- Make Login nad sidebar buttons bigger.
- Bold text on Sidebar buttons.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>

JBAS-1979 SCKO Google analytics base

Base GA code.  No action-specific triggers are included.

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

JBAS-1983 SCKO dedicated high-contrast mode

Append ?high-contrast=1 to the URL to have always-on high contrast.

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

JBAS-1981 SCKO Total/session items out count

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

JBAS-1980 SCKO already-processed for success only

Only display the "item already processed" message for sucessful
checkouts.  Checkout failures are always allowed to re-process so the
user can see the real error message.

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

JBAS-1997 Hold queue position stored procedure

Primarily created for use by BC, but could be used in other contexts.

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

Self-register add pride/rainbow card option

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

Recover local Google Analytics code

Even though GA is imported via the BC headers, they do not work the way
we need them to for tracking the self-reg pages.  Recovering the old GA
headers.

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

Revert "LP#1464709: teach QP about is_available statuses"

Retaining previous availabilty filtering behavior because KCLS uses
is_available (previously checkout_ok) more liberally than suits a search
availability filter.  E.g. 'missing' is is_available=true

This reverts commit fed65df3c669e1337f187d533e9033a697d6b263.

JBAS-1975 Archive ADPToJDE files same as ADP

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

JBAS-1975 Merge latest adp file mgt script changes

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

LP#1704819 Fine generator avoids int() rounding

Avoid using the Perl int() function for rounding in the fine generator,
since it can have unexpected outcomes.

For example:

$ perl -e 'print "230 = " . int(100 * 2.30) . "\n"'
230 = 229

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

JBAS-1804 2.12 SQL upgrade testing additions

DROP tablefunc as suggested by script.
Avoid creating the full reporter.hold_request_table twice.
Avoid creating various user name indexes twice.
Adds some more timing logs.

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

JBAS-1804 2.12 SQL wrap perm updates w/ insert check

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

JBAS-1972 - add 245$n to pull list alternate print title

.. and CHS, as side benefit.

Bradley Bonner
bbonner@kcls.org

JBAS-1804 KCLS 2.11 + 2.12 staff release notes

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

JBAS-1804 KCLS 2.11 + 2.12 staff release notes

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

JBAS-1802 2.10->2.12 SQL Upgrade

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

JBAS-1470 Bib linking uses 700/710m,o,r,s subfields

Add back 700 and 710 $m, $o, $r, $s subfields for link matching.  These
should never have been removed.

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

JBAS-1926 Patron edit print non-free-text statcats

Add support for printing values for non-free-text stat cats, whose
values have to be extracted differently from those of free-text cats
in the patron edit interface.

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

JBAS-1929 Expand mattype filtered browse bounds

Look farther and wider for matching browse records when filtering by
mattype to improve likelihood of finding a full page of results.

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

JBAS-1929 Filter bib links at vis check time

Filter all bibs that don't match the requested mattype during the
visibility checking stage instead of the link-finding stage to ensure
all related bib links are scanned for viability.

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

JBAS-1932 New headings mattype filter label tweak

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

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>