LP#1587639 Vandelay authority update editor/edit_date

Update the editor and edit_date of authority records when modified by
Vandelay merge/overlay.

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

JBAS-1417 New authority linker --modified-since

--modified-since implicitly includes --new-since because
edit_date=create_date on new authority records.  However, if both are
specified, the script OR's the queries.

If --modified-since and --new-since are used to gether, it creates an OR
of the 2 clauses.

Added a help() function.  Added CRONTAB entry.

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

os-update.sh gets a reboot option

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

eg-updater.sh: Apache control repairs/additions

1. If apache is already running when start-apache is called, stop it
first.  This is useful when calling start-apache (or start-all) directly
after a reboot, where Apache may have started automatically at boot.

2. Force a call to 'detach' when stop-apache is called directly as a
safety measure.

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

Reporter statement timeout 6 hours

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

JBAS-1378 Purge user activity ; apply transience

Remove all but the most recent actor.usr_activity row per etype and per
user, except keep all of the lynda and hoopla SIP login events.

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

90c2418 Nightly authority linking CRON entry repair

When running jobs past midnight, be sure to search for records modified
the previous day, not just today, for linking.

Signed-off-by: Your Name <you@example.com>

JBAS-1417 Nightly authority linking CRON entry

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

JBAS-1417 New authority record linking script

Runs auth-to-auth and bib-to-auth linking for authority records created
since a specified date.

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

JBAS-1417 Bib linking supports --modified-since

Plus some minor cleanup.

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

JBAS-1390 Connexion authority imports

Authority import merge profile and vandelay queue.

Updated marc_stream_importer script to handle authority imports.

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

CAT-61 MARC Advanced Search Add Row fix

Initialize expert_row_template variable
Refactor code to take into account new variable

Signed-off-by: Billy Horn <bhorn@catalystdevworks.com>
  Changes to be committed:
modified:   Open-ILS/web/js/ui/default/opac/simple.js

CAT-62 Patron Reg. Dupes Sorting

Remove penalties from pre-sort filter

Signed-off-by: Kyle Huckins <khuckins@catalystdevworks.com>

JBAS-953 Add CC number clear to CRONTAB

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

JBAS-953 Drop CC cols local SQL

Column mods and print/email template updates.

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

LP#1474051 Stamping upgrade script for drop-cc-data

Signed-off-by: Kathy Lussier <klussier@masslnc.org>

LP#1474051 Release/Upgrade Notes on dropped CC fields

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>

LP#1474051 Drop unneeded CC payment fields

Avoid storing the following credit card fields:

expire month
expire year
first name
last name
credit card type

Print and email receipts for credit card data modified to avoid
referencing these fields.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>

KMAIN-1919 Copy Quality Labels

Set Possible Values for Copy Quality to
"Standard" and "No Supplemental."

Change dialogue on "Set Copy Quality" to reflect
change from "Good" to "Standard."

Signed-off-by: khuckins <khuckins@catalystdevworks.com>

CAT-58 Bill Interface Print Additions

Add locale settings for Printing selected item.
Add context menu to Bill/Payment History interface.
Add Print Selected Item to Bill/Payment History Context menu.
Change Payment History Interface Print button to print all
items in list.

Signed-off-by: Kyle Huckins <khuckins@catalystdevworks.com>
modified:   Open-ILS/web/opac/locale/en-US/lang.dtd
modified:   Open-ILS/xul/staff_client/server/patron/bill2.xul
modified:   Open-ILS/xul/staff_client/server/patron/bill_history.js
modified:   Open-ILS/xul/staff_client/server/patron/bill_history.xul

JBAS-518 (KMAIN-1917) Repairs

1. Set bills printer context to current_bills instead of items_out.
2. Avoid rendering the payment details when clicking Print in the
   payment details UI
3. Style consistency repairs.
4. Remove pesky Windows newlines

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Conflicts:
Open-ILS/xul/staff_client/server/patron/bill2.js

KMAIN-1917 Patron payments print selected items

You can now print selected line items from the Payments window

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

KMAIN 1917 Patron bills print selected items

Patron Bills Window Now Supports The Option To Print Selected Line Items

Signed-off-by: Nick Duncan <nDuncan@catalystitservices.com>
Conflicts:
Open-ILS/xul/staff_client/server/patron/bill2.js

CAT-51 Patron editor profile group sorting refactor

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

CAT-51 Patron Reg. Perm Group Ordering

Reordered Permission Group choices in drop down
of Edit screen on Patron Registration page.

Signed-off-by: Victoria Lewis <vlewis@catalystdevworks.com>
 On branch dev/catalyst-vlewis/CAT-51-patron_reg_perm_group_ordering
modified:   Open-ILS/web/js/ui/default/actor/user/register.js

KMAIN 1939 Rename Daytime/Evening Phone

Change instances of "Daytime/Evening Phone" to
"Primary/Secondary Phone."

Signed-off-by: khuckins <khuckins@catalystdevworks.com>

KMAIN-1918 Emphasize PC Only Patrons

Goal: Give PC Only Patron name a yellow border

Solution:
Add new CSS class PATRON_PC_ONLY
Add handling for removing and adding PATRON_PC_ONLY

Signed-off-by: Kyle Huckins <khuckins@catalystdevworks.com>
modified:   Open-ILS/xul/staff_client/server/patron/display.js
modified:   Open-ILS/xul/staff_client/server/patron/util.js
modified:   Open-ILS/xul/staff_client/server/skin/patron_display.css

KMAIN-1830 Backspace clears on barcode only

Only apply backspace-clears-barcode handling to the barcode input.  As
it was, it was defaulting to all text inputs (e.g. stat cat values).

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

JBAS-533 Org units get their own mailing addresses

Give each org unit currently using address ID 1 as its mailing address a
copy of address ID 1 so that it can be edited w/o modifying the
addresses of other org units.

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

CAT-46 Bib Call Number Also Uses 99a; Avoid Undefined

Add option for Bib Call Numbers to be populated from the 099a
subfield, rather than just the 092a subfield.

Avoid returning an 'undef' value fro the bib call number, which results
in 'undefined' labels in Javascript.  Default to empty string.

Signed-off-by: khuckins <khuckins@catalystdevworks.com>

CAT-49  Copy View/Edit Links in Catalog

Add view and edit link next to each copy in the copy gird.
Cross-ported this feature.
https://bugs.launchpad.net/evergreen/+bug/1346421

Signed-off-by: Victoria Lewis <vlewis@catalystitservices.com>
On branch dev/catalyst-vlewis/CAT-49-copy_view_edit_links_in_catalog
modified:   var/templates_kcls/opac/parts/record/summary.tt2

KMAIN 1938 F8 Action on Patron Registration

Modify the Stash on patron registration in uEditFinishSave();
to set the newly created patron as last_patron.

Signed-off-by: khuckins <khuckins@catalystdevworks.com>

KMAIN-1920 Holds Notes print on slip

Change checked="false" to checked="true" in hold_details.js
for the "Print on Slip" checkbox, so hold notes automatically
set to print when you print the holds slip.

Signed-off-by: khuckins <khuckins@catalystdevworks.com>

CAT-48 Deactivate 'Missing' status

Add "Missing" state from config.copy_status to magical_status
constant.

Signed-off-by: khuckins <khuckins@catalystdevworks.com>
 Changes to be committed:
modified:   Open-ILS/xul/staff_client/chrome/content/main/constants.js

Include bib record fingerprint configs in sample DB export

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

JBAS-1466 Host patron card images locally; juggle images

Remove some cards, add some new ones.  Host them all on the EG servers
under web/images/patron_cards/*.png

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

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>