JBAS-1324 Use BCMS link for Privacy Policy

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

JBAS-1324 PDF links; avoid dupe notice

And move FAQ up to the top.

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

JBAS-1324 Limit state to WA; activation notice

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

JBAS-1324 Patron reg downloadable forms ; tweaks

* Create panel along the right for links to printable forms
* Change page title
* Add note about mailed cards delivery time
* Link to BCMS versions of card images

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

JBAS-1295 EDI invoice LI note requestor repair

Create LI notes using 'admin' as the creator for EDI invoices, since
there is no 'requestor' value in this context, but one is required.

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

JBAS-1259 Hoopla/Lynda user login activity types

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

JBAS-1259 SIP test code API updates

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

JBAS-1132 Remove fonts testing block

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

JBAS-1132 Card app success blurb fonts/spacing

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

JBAS-1132 Card app submit-another button

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

JBAS-1132 Center form

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

JBAS-1132 Biblio CMS remote header/footer

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

JBAS-1132 Self-contained page / doctype

Avoid using the standard TPAC wrapper so the card app form can define
its own <DOCTYPE> to avoid IE quirks mode.  Also, the wrapper loaded
some stuff the page doesn't need.

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

JBAS-1132 Default to no home library selected

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

JBAS-1132 TT org_selector onchange / none_label

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

JBAS-1132 SQL sequence copy/paste repair

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

JBAS-1132 Card app PDF link; avoid bibliocms links

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

JBAS-1132 Card style stat cat; delivery method field

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

JBAS-1132 Save (Clone) from staged users repairs

* Avoid trying to re-register the same staged patron after saving a
  staged patron and reloading the form.

* Avoid trying to remove a staged patron from the pending user grid if
  the patron row has already been removed.

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

JBAS-1132 Self-reg fire onchange for post_code

Force onchange for post_code to execute post code alerts /
auto-complete.

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

JBAS-1132 Self-reg clear values on page load

Clear all text form values on page load to prevent browser-back from
leaking sensitive information.

Avoid unchecking checkboxes on self-register page load to that billing
address == mailing address can be set by default.

Note, page is SSL and caching is disabled.  This was not enough to
prevent the browser (Chrome, anyway) from caching the form values...

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

JBAS-1132 Self-reg avoid empty stat cats

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

JBAS-1132 Self-register inactivity timeout mods

* 5 minute inactivity timeout.
* 30 second timeout before redirect after successful registration.

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

JBAS-1132 Pending patrons squish DoB column

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

JBAS-1132 Staged user dupe search repair

Duplicate searches from staged users were failing due to incorrect use
of new_patron_tab within staged.js.

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

JBAS-1132 success page; activity timeout

On success hide the registration form for privacy and provide link to
docs on what forms of identification will be necessary.

Support inacitivty timeout during registration and for automatic
redirect after successfull registration.

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

CAT-44: Support copy-to-clipboard in Pending Patrons Interface

Add right-click copy-to-clipboard behavior to rows
in the Pending Patron interface.

Signed-off-by: Victoria Lewis <vlewis@catalystitservices.com>
modified:   Open-ILS/xul/staff_client/server/patron/staged.js
modified:   Open-ILS/xul/staff_client/server/patron/staged.xul

JBAS-1132 Pending users columns cleanup + addresses

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

JBAS-1132 Self-register patron edit mods

* Fire on-change handler for various fields after a staged user is
  loaded to apply various rules:
  ** setting juvenile flag from dob
  ** running duplicate patron searches
  ** creating password from phone
  ** Setting expire date base on profile
* Support for loading stat cats data

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

JBAS-1132 Self-register UI, KCLS-style

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

JBAS-1132 OPAC org selector no_root/no_indent options

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

JBAS-1132 Self-register EGCatLoader API mods

* Upper-case most patron fields before inserting stage users.
* Normalize addresses
* De-duplicate addresses
* Handle KCLS-specific stat cats
* Honor opac.self_register.profile org setting

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

JBAS-1132 Self-register SQL / IDL

* Adds card_style and ident_value2 columns
* Creates org setting opac.self_register.profile
* Sets values for org settings opac.self_register.profile,
  opac.allow_pending_user, and ui.patron.edit.au.ident_value2.show
* Modifies address IDL labels

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

Orphan browse entry cleanup repair

Clean up subject entries, not author entries twice.

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

JBAS-1264 Highline added sftp agent script

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

JBAS-1264 Highline school cards

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

JBAS-1243 Push user expire_date's to future

Fixes issue where transactions (circs/holds) are not created because all
users are expired.

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

JBAS-1243 Remove nested BEGIN/COMMIT on sample data

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

JBAS-1243 2.7 SQL upgrade INSERT wrapping

1. Wrap INSERTs in insert_on_deploy() test.
2. Avoid unnecessary inserts, e.g. upgrade log versions

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

JBAS-1243 Dev DB exports for 2.7

Updated dev server sample data export for 2.7 series release.

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

JBAS-1243 Add export table config.composite_attr_entry_definition

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

JBAS-1185 Patron edit missing 2.7 2ndry grps button

Add the missing button to the KCLS template.  Also, remove the local
copy of the register.tt2 file, since it contained no local
customizations.

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

eg-updater uses --settings-startup-pause 5 (typo)

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

eg-updater uses --settings-startup-pause 5

Avoid rare, but annoying cases of the C services starting before
opensrf-settings as completed its login to ejabberd.

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

JBAS-1263 Browse entry cleanup utility SQL

SQL to delete un-referenced (dangling) browse entries.

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

JBAS-1284 Strip apostrophes in search normalize

Test case is title search for both forms:

ha-na'arah she-sihkah ba-esh
ha-Naʻarah she-śiḥḳah ba-esh

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

JBAS-1263 'Other Author' index no longer creates browse entries

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

JBAS-1185 Picklist fund selector perm repairs

Enusre the fund search filter has a value set for the location org
units, based on picklist access permissions, otherwise zero funds
will be returned.

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

JBAS-1246 Call number search configs continued

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

JBAS-1246 create call_number search config

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

JBAS-1245 2.7 SQL upgrade repair call-number extracts; part 2

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

JBAS-1245 2.7 SQL upgrade repair call-number extracts

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

JBAS-1164 apply subject dash fix before auth reingest

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

Revert "KMAIN-1510" (excess browse dashes)

This reverts commit 6c9cae946710ed9ed828daf78480c3b3f497c6a5.

JBAS-1164 Subject browse dashes repair

Only add dashes before subject browse subfields v, x, y, and z.

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

JBAS-984 Student account imports crontab entry

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

JBAS-984 Addr normalizer shortens road/avenue

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

JBAS-1161 Tahoma classroom cards address repair

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

JBAS-984 Address normalizer street => st

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

Student cards expire age universally 21

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

JBAS-1161 Add district name to classroom card data

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

JBAS-984 Student importer uses kcls addr normalizer

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

JBAS-984 KCLS Address normalizer

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

JBAS-984 Student cards automation scripts

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

JBAS-1161 Map districts to org units; remove --assume-new

1. District codes are mapped to org unit ID's within the script so the
caller does not have to know the org unit.

2. Remove the --assume-new option, since it serves little purpose.

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

JBAS-1161 Tahoma classroom cards data

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

eg-updater defaults to 20 second service start wait time

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

JBAS-980 auth-to-auth clear links once

Only delete auth-to-auth links for a given subfield once per record.
Otherwise, we could only create one link per tag.

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

JBAS-980 local thes. falls back to Other

When a controlled field specifies its source as local (ind2=7), consider
a link to an authority record whose thesaurus value is z=Other as always
valid.

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

JBAS-980 repair ind2=z remapping logic (lcgft)

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

JBAS-980 Make auth-2-auth more aggressive

Remove all existing links for each processed auth-2-auth field before
rebuilding the links.  This lets us remove bogus links.

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

JBAS-980 auth linking repairs/consistency

1. Use consistent DB connection logic -- removes a lot of
   unnecessary DB connection settings logic.

2. Set log traces via OSRF_LOG_CLIENT

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

JBAS-980 auth2auth link repairs/consistency

1. Use consistent DB connection logic -- removes a lot of
   unnecessary DB connection settings logic.

2. Use existing clean_marc utility function instead of inline version.

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

JBAS-980 auth batcher DB params consistency

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

JBAS-980 throttle_disbatcher.pl time printing fix

Code previously displayed "Time::tm=ARRAY(0xe1e4f8)" instead of a time
string.

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

JBAS-980 bib/auth batch repairs / consistency

1. Use consistent DB connection logic -- removes a lot of unnecessary
   DB connection settings logic.

2. Repair logic on building batch files to avoid warnings about writing
   to closed file handles.

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

JBAS-980 Extra del. record sanity check in bib/auth linker

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

JBAS-980 authority batch setup uses opensrf

Assign ownership of authority batch files to opensrf instead of making
the directories world-writable.

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

JBAS-980 bib linking minor repairs and logging updates

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

JBAS-980 bib linking force thesaurus; local thesaurus

Preliminary support for mapping local thesaurus values (ind2=7) to one
of the supported authority leader/11 options.

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

JBAS-980 readability; remove stale links

If auth record A links to record B, but they use a different thesaurus,
unlink them.

When 2 records use a different thesaurus, exit early to avoid
unnecessary processing.

Various readability and style modifications.

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

JBAS-980 auth-to-auth uses correct leader position

008 indexes are zero-based.  We want index 11, not 10.

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

KMAIN 1911 Auth-to-auth audience linking

Authority Records Now Only Link To Other Authority Records With The Same 008/11 (Audience)

Signed-off-by: Nick Duncan <nDuncan@catalystitservices.com>

JBAS-980 auth-to-bib linking repairs continued

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

KMAIN-1897 Fix Authority Linking Script

Authority Linking Script Now Recognizes Matches From Bib 65X to Auth 008/11

Signed-off-by: Nick Duncan <nDuncan@catalystitservices.com>

JBAS-944 2.7 sql upgrade dupe holds cleanup

2.7 adds an index that prevents 2 captured, unfulfilled, uncanceled
holds from targeting the same copy.  Before the index is created,
cancel any such dupe-copy holds that have expired on the shelf and reset
any such holds that are otherwise unfulfilled (i.e. in transit or on the
holds shelf).

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

eg-updater installs admin scripts to /openils/bin

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

eg-updater.sh stop/start-util handles reporter

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

JBAS-944 2.7 auth reingest clear statement timeout

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

JBAS-944 2.7 upgrade statement timeout

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

JBAS-1129 Remove KCLS custom language filter SQL

No need to track a separate language_filter table, since we have the
same data available via coded value maps.

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

JBAS-944 Add extend_reporter changes for 2.7 upgrade

These changes were not included in the version upgrade scripts, since
they were optional.  We need them locally.

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

JBAS-944 browse entry constraint also checks value

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

JBAS-944 Auth changes update browse_entry_* values

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

JBAS-944 Move auth updates to 2ndry transaction

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

JBAS-944 avoid modifying local series index

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

JBAS-944 update ACQ cancel reason labels

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

JBAS-944 remove unneeded PO print template mods

These updates won't apply anyway since we have local changes.  Removing
them to de-clutter the upgrade script some.

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

JBAS-944 replace ROLLBACK with COMMIT

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

JBAS-944 SQL functions comparison tool

Tool to generate diffs for a set of SQL functions.  Useful for analyzing
SQL upgrade scripts.

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