JBAS-1426 Enumclaw classroom cards

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

JBAS-1426 Classroom cards generator improve error handling

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

JBAS-1375 Classroom cards set to juvenile=false

Classroom cards have a DoB of 1900-01-01, which means the juvenile flag
is set to false for all classroom cards after one day of production
deployment.  Avoid the unnecessary update by setting the cards to
juvenile=false on import.

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

JBAS-1375 Auburn school/classroom cards

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

JBAS-1439 Swap Ingram vendcode/vendacct values

Invoicing requires the vendor code and account values on the EDI
messages be in the proper location.  This also rolls back a change to
the EDI order template which swapped them directly within the template.

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

JBAS-1379 Card app usability improvements

* Set state field to 'readonly' instead of 'disabled' in patron card form
so that the value will be passed to the server.

* Require phone to have the format /^\d{3}-\d{3}-\d{4}/ if any value is
present.

* Show warning style for missing values on street, city, post code.

* Validate fields onkeyup so it's obvious when a field is newly valid.

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

JBAS-1379 Avoid dupe stat cats for stage users (WHD #5007215)

Ensure at most one copy of each stat cat is represented when saving a
staged user.

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

JBAS-1379 Stage address uses dynamic virtual ID

Avoid using hard-coded ID for staged user addresses, using the dynamic
ID instead.  This resolves a problem where creating a new address
appeared to clone an existing staged address.

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

Updated sample data export, dropped to 750 bibs

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

Convenience script for running OS updates

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

JBAS-1324 Minor UI repairs; w3 lang images

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

JBAS-1345 Add Renton/Issaquah to SFTP client script

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

JBAS-1345 Renton/Issaquah school cards

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

JBAS-1132 (etc.) Avoid data inserts on new DB builds

Repair some Sqitch SQL scripts so they don't insert or verify on data
that should not exist yet.

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

JBAS-1324 Typos; image borders

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

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>