JBAS-1832 3.2 SQL rearrangements

Move more of the updates into the data file so they can run after the
main schema upgrade.

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

CAT-172 Additional AngJS patron edit fixes

Avoid setting a hold_notify prefence, since KCLS does not have that
user setting type present in the database.

Minor formatting/layout repairs.

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

CAT-172 patron edit reordered

Reordered patron edit form to match KCLS xul client ordering

--
Updates for current 3.2 applied by berick.

Signed-off-by: Katlyn Beck <kbeck@catalyte.io>
Changes to be committed:
modified:   Open-ILS/src/templates/staff/circ/patron/t_edit.tt2

JBAS-1832 Merge latest 3.2 SQL into upgrade

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

CAT-152 Update Items Interface

Rebase and squash of Catalyte AngularJS Update Items port.  See commits
below.  Original code:

kcls/dev/catalyst-khuckins/CAT-151-Update-Items-Webby-Port

Basic frontend for update items interface.

Access via one of the following paths:
1. Direct:
      [Hostname]/eg/staff/acq/update_items/[Record ID]
2. Through Catalog:
      On a record, Other Actions->Update Items

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
new file:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
new file:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/src/templates/staff/cat/catalog/t_catalog.tt2
new file:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Update Items App.js Map

Comment through and add TODOs in app.js to map out what we
can utilize and what we should strip out.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-153 Retrieve Record for Item Update Interface

Set record ID to dataKey from $routeParams.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-154 Lineitems Dropdown for Update Items

- Move record_id into service object.
- Add new directive egProductOrderDropdown to handle the dropdown.
- Add new function in itemSvc to fetch lineitems based on bib record.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-155 Display Lineitem Details

- Add service function to convert lineitem to object
- Add service function to fetch needed copy information
- Slight refactor to CAT-154 code to accomodate objectification
- Create egProductOrderVolumes directive to handle display of Org and Volume
information
- Create egProductOrderCopy directive to handle display of Copy information

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-163 Display Line Item Notes

- Add notes to lineitem object
- Display Lineitem notes for selected PO  under Line Item Notes section
of update items interface.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-158 Update Items Save Functionality

- Items that have had their Call Number or Barcode edited
update upon pressing the "Save Changes" or "Save & Exit"
buttons.
- "Save Changes" will reload the page upon saving.
- "Save & Exit" closes the page upon saving.
- If a volume's call number has changed, a call will be made
to find_or_create_volume, creating a new volume only if an
applicable one doesn't already exist.
- Addition to retrieve_lineitem API: Optional flag
flesh_li_details_copy to retrieve the acp object tied to a
lineitem.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/perlmods/lib/OpenILS/Application/Acq/Lineitem.pm
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-161 Update Items Add Notes Functionality

- Allow adding notes to lineitem directly from the Update Items
Interface.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-168 service.saveChanges Refactor

- Refactor service.saveChanges to handle saving changes to items
in different Orgs.

 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-159 Print Labels Functionality

- Ticking the print labels checkbox will open the Print
Item Labels interface for every item in the currently
selected lineitem upon saving changes. Any changes made
in the update items interface will be represented in the
Print Item Labels interface.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-160 Print Worksheet Functionality

- Ticking the Print Worksheet box will open the Worksheet for the selected
lineitem, ready for the user to print.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-166 Edit Items Section

- Edit Items Section now covers the saving of Circ Modifier,
Circulate?, Location/Collection, and Price. Upon saving changes,
those fields will be accounted for when updating each copy.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-166 Edit Items Template Selector

- Template Selector now applies changes to the circ modifier,
circulate?, location/collection, and price fields based on the
values in the selected template.
- Template Selection will be cleared upon changing Lineitem
selection.
- Whitespace cleanup for previous commit

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-165 Edit Item Attributes

- Edit Item Attributes button now leads to the copy editor for
each copy in the currently selected lineitem in a new tab.
- A prompt will appear on the Update Items interface after
activating the Edit Item Attributes button warning that without
a refresh, there could be inconsistancy between changes made in the
Copy Editor and changes made in the Edit Items portion of the Update
Items interface.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
        modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-156 Call Number Batch Apply

- The Apply button adjacent to the Call Number Batch Apply
field will now Apply the contents of that field to each volume
Call Number field.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 App.js cleanup & Polishing

- Remove unnecessary code from App.js
- Set controller for several Update Items directives to UpdateCtrl
- Disable input fields and buttons when no line item selected
- Add notices when no line items available, no lineitem selected, and
no notes to display
- Reduce amount of network calls made when fetching lineitems

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-169 Update Items Hotkeys

- Angular-Hotkeys implementation for required hotkeys.
- Minor refactors to better accomodate hotkey code.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/src/templates/staff/cat/catalog/t_catalog.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js
modified:   Open-ILS/web/js/ui/default/staff/cat/catalog/app.js

CAT-152 Template Readability Adjustments

- Break overly long lines into multiple lines.
- Remove unnecessary strings defined in index

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2

CAT-167 Only display on-order and received lis

- Remove extraneous console.log
- Ensure only lineitems that are on-order or received are
displayed

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-156 Autogenerate Barcodes & Checkdigit

- Implimentation of autogenerate barcodes with checkdidgets generation working
- Apply CSS changes and open ngToasts when Use Checkdigit
is checked and an invalid barcode is found.
- Consolidate egProductOrderCopies and egProductOrderVolumes
into t_update_items.tt2.

Signed-off-by: Alex Cautley <acautley@catalyte.io>
Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Checkdigit Patch

- Allow Barcodes that are only numbers to be recognized as
valid by the checkdigit validation function.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Color-blind Friendliness for Barcode Field

- Apply additional stylings and add glyphicon to Barcode field
when Use Checkdigit is enabled based on valid or invalid barcode.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Initial Progress Dialog

- Add an instance of egProgressDialog while fetching lineitems

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Save & Print Optimizations

- Move print option service logic into separate function.
- Adapt egItems print_spine_labels as separate function within egUpdateItems.
- Open Print Label and Worksheet windows after save, but before refresh, to better
handle large lineitems(1000+).
- Allow both Worksheet and Spine Label print windows to open without signifigant lag
time between each other.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

CAT-167 Handle Fetch error with large lineitems

- Apply error message when lineitem is unable to display due
to fetch error in edge cases where there is a lineitem with 1k+
entries occasionally stopping org information from being fetched
for other lineitems.
- Small rearrangement of code in UpdateCtrl to make things more
readable.
- Addition of Glyphicon warning sign when displaying error messages.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/templates/staff/acq/update_items/index.tt2
modified:   Open-ILS/src/templates/staff/acq/update_items/t_update_items.tt2
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

lp1744762 Lineitems by Bib filter multiple states

- Allow lineitem_state to take an array of strings, rather than
just a single string.

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/src/perlmods/lib/OpenILS/Application/Acq/Lineitem.pm

CAT-176 Refactor Update Items Fetch

- Utilize lineitem_state to properly fetch lineitems with the fixed code
from lp1744762

Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
 Changes to be committed:
modified:   Open-ILS/web/js/ui/default/staff/acq/update_items/app.js

KCLS Ansible-based brick manager + wizard

Brick stop/start/deploy/etc actions managed by ansible.
Includes a wizard script to walk the user through the steps for each
action.

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

JBAS-1832 Remove refs to legacy search language_filter

And remove a few other local unused bits.  File now matches master.

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

JBAS-2098 Dev DB builder schema-only option

Note the script must be manually modified for now, pending support for
getopt.

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

JBAS-1832 Apply COMMIT's to 3.2 SQL updates

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

JBAS-1832 Migrate 3.2 SQL to sqitch

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

JBAS-1832 KCLS 2.12 -> 3.2 SQL upgrade

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

JBAS-2098 Migrate browse data back to stock tables

Move data from the various
metabib.browse_[title|author|subject|series|call_number]_entry_* tables into
the stock metabib.browse_entry_* tables.

The data migration step handles de-duplication and creation of entry,
def_map, and simple_heading_map rows.

UI code is updated to refer to the stock tables as well.

Some local additions added to improve stock browse speed and resolve
index-size issues (combo_sort_value field, metabib_fields_cache field,
and substr indexes).

Includes updates to the new headings report to reference the new tables,
including a materialized view to speed up the initial report collection.

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

JBAS-2040 College cards use email; fixes

College cards now use email for student_id values.  Values are scrubbed
and made lower case.

Fix sftp agent to properly pass the --college flag to the generator
script.

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

JBAS-2018 eCard UMS print notice validator

Confirm patrons are un-purged and un-verified before sending to UMS for
ecard letter generation.

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

JBAS-1925 eCard print notice ID fix

Update print notice generator to use correct prod event def ID.

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

JBAS-1925 eCard code generator skips vowels

To avoid creating any words which could be offensive.

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

JBAS-1925 eCard address normalizer repair

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

JBAS-1925 Verify page close success msg <b> tag

Otherwise everything after the message (footers, etc.) are bolded.

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

JBAS-1925 Repair temp ecard patron activity non-extension

Update the patron activity extender to use the correct DB ID for the
pending ecard group (which changed recently).

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

JBAS-1925 Add Goog tag manager script to eCard form

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

JBAS-2045 Add self-reg ADA text

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

JBAS-2045 Remove gender field / stat cat data

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

JBAS-1925 Ecard (Quipu) data and web form

* Ecard user groups, policies, and barcode generator.
* TPAC-driven web form and submit API (/eg/opac/ecard/form)
* TPAC-driven card verification form (/eg/opac/ecard/verify)
* API / form Test script

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

JBAS-2049 Enable Fed. Way teacher accounts

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

Update dev data export w/ merge_date/to fields

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

Add SQL insert checks in search-index-keep-periods

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

JBAS-2015 UMS print notice summary email CRONTAB entry

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

EDI fetcher always uses passive FTP

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

JBAS-2036 Import pingest; add weekly batches

Import the pingest script for safe keeping.  Adds support for a new
--week-batch option for reingesting all bib records over a 7 day period.

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

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-2002 Self-reg googalyitcs on submit/cancel events

Send events to Goog indicating a submit or cancel button event.
Minor cleanup of old commented code.

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

JBAS-1050 Add strip-period title/author indexes

Now that we no longer strip periods universally for search indexes, add
title and author indexes that strip periods via normalizer to support
(e.g.) author = 'j.k. rowling' / 'j k rowling' / 'jk rowling'

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

JBAS-1634 Acq PO/Invoice search on identifiers

Replace the canned searches for "Purchase Orders" and "Open Invoices"
with searches for PO ID and invoice vendor invoice identifier.

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

JBAS-1967 Invoice close date search UI fix

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

JBAS-2024 Alt bib hold counts by rhrr

Recover stock hold counts code to reduce merge confusion and add a new
handler for calculating hold counts per bib record using the new
materialized reporter.hold_request_record table.  This gives us copy,
etc. -level hold counts back.

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

Backstage Qtrly export reports TCNs

Create a file listing the exported TCN's and put it in Backstage web
reports folder with each quarterly export.

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

JBAS-1967 Display ERP close date in invoice UI

Display the new ERP close date field for staff in the invoice UI when
either the invoice is closed or a value is present.

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

JBAS-1967 Invoice close fields cross-port

Including new erp_export_date field for exporting invoices to JDE.

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

JBAS-2018 A/T UUID template helper function

For generating email Message-ID: values

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

JBAS-1050 Avoid stripping periods from search indexes

Roll back an old customization that stripped periods from search index
values.  Removing the periods is unnecessary becuase the values are also
normalized by the search_normalize() function, which replaces periods
with spaces.

Adds an additional keyword index using the 'replace' normalizer to strip
periods from indexed values (without replacing them with a space) so
that we can additionaly index (for example) "g.i. joe" as "gi joe".

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

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>