working/Evergreen.git
6 years agoJBAS-2101 Improve refundable xact summary view speed
Bill Erickson [Wed, 14 Nov 2018 16:51:43 +0000 (11:51 -0500)]
JBAS-2101 Improve refundable xact summary view speed

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Lost/paid show dialog on re-prints
Bill Erickson [Thu, 8 Nov 2018 19:43:54 +0000 (14:43 -0500)]
JBAS-2101 Lost/paid show dialog on re-prints

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Lost/paid uses default context (again)
Bill Erickson [Thu, 8 Nov 2018 18:17:36 +0000 (13:17 -0500)]
JBAS-2101 Lost/paid uses default context (again)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1925 eCard form FAQ link
Bill Erickson [Thu, 8 Nov 2018 18:09:39 +0000 (13:09 -0500)]
JBAS-1925 eCard form FAQ link

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Print lost/paid from bill history uses default context
Bill Erickson [Thu, 8 Nov 2018 17:28:51 +0000 (12:28 -0500)]
JBAS-2101 Print lost/paid from bill history uses default context

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Lost payment forces print dialog, uses default context
Bill Erickson [Thu, 8 Nov 2018 17:22:02 +0000 (12:22 -0500)]
JBAS-2101 Lost payment forces print dialog, uses default context

Temporarily clear the silent print option when printing a lost/paid
reciept.  Send lost/paid receipts to the 'default' printer.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2118 Lost payments auth for webstaff WIP
Bill Erickson [Thu, 8 Nov 2018 16:37:30 +0000 (11:37 -0500)]
JBAS-2118 Lost payments auth for webstaff WIP

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Refundable xact address handling improvements
Bill Erickson [Fri, 2 Nov 2018 14:44:49 +0000 (10:44 -0400)]
JBAS-2101 Refundable xact address handling improvements

If no mailing/billing address is linked to the account, use the first
address found for the user.

If no addresses exist, use "NONE" for required refundable xact fields.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Payment grid shows A/D login
Bill Erickson [Thu, 1 Nov 2018 20:53:21 +0000 (16:53 -0400)]
JBAS-2101 Payment grid shows A/D login

In the XUL client transaction details payment grid:

1. Rename the existing "Staff" column to "Login" (i.e. shared ILS login)
2. Add a new column labeled "Staff" which shows the KCLS login (first
   part of email) of the staff that accepted a lost payment.  Column
   will be empty for non-lost payments.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1925 eCard form Seattle residents warning
Bill Erickson [Thu, 1 Nov 2018 20:04:47 +0000 (13:04 -0700)]
JBAS-1925 eCard form Seattle residents warning

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Stock browse migration create_date repair
Bill Erickson [Tue, 30 Oct 2018 19:04:56 +0000 (12:04 -0700)]
JBAS-1839 Stock browse migration create_date repair

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Ansible logs history
Bill Erickson [Tue, 30 Oct 2018 18:45:04 +0000 (14:45 -0400)]
JBAS-1839 Ansible logs history

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 More 3.2 browse SQL syncing
Bill Erickson [Tue, 30 Oct 2018 18:15:44 +0000 (14:15 -0400)]
JBAS-1839 More 3.2 browse SQL syncing

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-188 catalog fixes search templates
Katlyn Beck [Wed, 24 Oct 2018 21:23:17 +0000 (21:23 +0000)]
CAT-188 catalog fixes search templates

- Added template name input, save button, and delete button
- Adjusted getSearchStash() to parse JSON
- Added templateActionSave function to call create_template using browser specific variables
- Added templateActionDelete function to mirror desktop functionality
- Added functions to save to localStorage in place of file storage

Signed-off-by: Katlyn Beck <kbeck@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/opac/parts/advanced/search.tt2
modified:   Open-ILS/web/js/ui/kcls/conify/global/config/search_templates.js

6 years agoCAT-188 3.2 catalog fixes search templates WIP
Katlyn Beck [Tue, 23 Oct 2018 16:19:01 +0000 (16:19 +0000)]
CAT-188 3.2 catalog fixes search templates WIP

Signed-off-by: Katlyn Beck <kbeck@catalyte.io>
 Changes to be committed:
modified:   KCLS/openils/var/templates_kcls/opac/parts/advanced/search.tt2
modified:   Open-ILS/web/js/ui/kcls/conify/global/config/search_templates.js

6 years agoLP#1800481 Vandelay import form templates
Bill Erickson [Mon, 29 Oct 2018 16:31:26 +0000 (12:31 -0400)]
LP#1800481 Vandelay import form templates

Support saving MARC Import form values as named templates.  Values are
stored as (by defualt) workstation settings.  A template may be selected
as the default and templates may be deleted.

Includes release notes update angular vandelay.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1779158 Ang6 Vandelay Release Notes
Bill Erickson [Thu, 11 Oct 2018 19:47:58 +0000 (15:47 -0400)]
LP#1779158 Ang6 Vandelay Release Notes

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1779158 Ang6 Vandelay UI Port
Bill Erickson [Thu, 28 Jun 2018 22:23:39 +0000 (18:23 -0400)]
LP#1779158 Ang6 Vandelay UI Port

Port of the MARC Import/Export UI from a Dojo-driven interface to a
Angular(6) interface.

Includes an additional UI called "Recent Imports" which displays
Vandelay session tracker information for both active sessions and those
within the selected time frame.  Active sessions are updated regularly
to display progress to the user.

Includes grid persist key workstation settings.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Browse entries index md5 vals; other SQL
Bill Erickson [Tue, 30 Oct 2018 16:12:19 +0000 (09:12 -0700)]
JBAS-1839 Browse entries index md5 vals; other SQL

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2117 Aged payments first in circ aging
Bill Erickson [Thu, 25 Oct 2018 16:44:06 +0000 (12:44 -0400)]
JBAS-2117 Aged payments first in circ aging

Delete payments from active table first to clear any
account_adjustment's that might link to billings that will also be
deleted.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 Reprint lost/paid from payment history
Bill Erickson [Thu, 18 Oct 2018 19:21:10 +0000 (15:21 -0400)]
JBAS-1306 Reprint lost/paid from payment history

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Ansible root plays get names
Bill Erickson [Wed, 17 Oct 2018 16:22:38 +0000 (12:22 -0400)]
JBAS-1839 Ansible root plays get names

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Ansible separate localhost ('single') target
Bill Erickson [Wed, 17 Oct 2018 16:18:50 +0000 (12:18 -0400)]
JBAS-1839 Ansible separate localhost ('single') target

Create a separate ansible build target for single-server hosts, e.g.
'localhost'.  This simplifies the plays by not requiring special
handling for single-server instances.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1839 Ansible skip angular on sips/utils
Bill Erickson [Wed, 17 Oct 2018 15:30:33 +0000 (11:30 -0400)]
JBAS-1839 Ansible skip angular on sips/utils

Avoid building AngJS and Ang targets on sips / utils

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2129 Delay 3.2 copy alert migration
Bill Erickson [Tue, 16 Oct 2018 21:39:27 +0000 (17:39 -0400)]
JBAS-2129 Delay 3.2 copy alert migration

They are not compliant with XUL.  Research pending.

They can be migrated later.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 Integrate browse SQL diffs to 3.2 SQL
Bill Erickson [Wed, 10 Oct 2018 17:57:06 +0000 (13:57 -0400)]
JBAS-1832 Integrate browse SQL diffs to 3.2 SQL

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2090 Green River College cards
Bill Erickson [Wed, 26 Sep 2018 15:16:26 +0000 (11:16 -0400)]
JBAS-2090 Green River College cards

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAnsible uses XUL series ID for server ID
Bill Erickson [Mon, 1 Oct 2018 15:37:49 +0000 (11:37 -0400)]
Ansible uses XUL series ID for server ID

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAnsible publishes XUL build files
Bill Erickson [Mon, 1 Oct 2018 15:24:27 +0000 (11:24 -0400)]
Ansible publishes XUL build files

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAnsible stop-util ignore reporter kill errors
Bill Erickson [Mon, 1 Oct 2018 14:01:32 +0000 (10:01 -0400)]
Ansible stop-util ignore reporter kill errors

Keep going when a reporter pid file is found but no such process is
running.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoPort KCLS changes to pingest.pl
Bill Erickson [Fri, 28 Sep 2018 19:26:31 +0000 (15:26 -0400)]
Port KCLS changes to pingest.pl

Now we can benefit from up-stream additions.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAnsible Angular(JS) build steps
Bill Erickson [Thu, 27 Sep 2018 15:44:00 +0000 (11:44 -0400)]
Ansible Angular(JS) build steps

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-188 Copy table view/edit links browser support
Bill Erickson [Mon, 24 Sep 2018 15:52:04 +0000 (11:52 -0400)]
CAT-188 Copy table view/edit links browser support

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-188 Search result table link repairs
Bill Erickson [Mon, 24 Sep 2018 15:38:07 +0000 (11:38 -0400)]
CAT-188 Search result table link repairs

Use the "href" on the source <a> element for the search resutls
new_tab() call.

In the browser client, no special handling is required.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-188 Catalog Browser compatability WIP SQUASH
Kyle Huckins [Wed, 11 Jul 2018 20:19:37 +0000 (20:19 +0000)]
CAT-188 Catalog Browser compatability WIP SQUASH

6 years agoJBAS-1832 3.2 upgrade SQL reorder; more logging
Bill Erickson [Thu, 27 Sep 2018 14:37:24 +0000 (10:37 -0400)]
JBAS-1832 3.2 upgrade SQL reorder; more logging

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoeg-brick-wizard non-graceful detach 1 second
Bill Erickson [Wed, 26 Sep 2018 21:31:37 +0000 (17:31 -0400)]
eg-brick-wizard non-graceful detach 1 second

Sleep of 0 means forever in ansible, not "no sleep"

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCollege flag may apply to students and teachers
Bill Erickson [Tue, 18 Sep 2018 17:27:58 +0000 (10:27 -0700)]
College flag may apply to students and teachers

Ensure the --college flag is set for both students and teachers when
importing college student/teacher accounts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2088 Add online payments help email to pay form
Bill Erickson [Tue, 14 Aug 2018 18:50:58 +0000 (14:50 -0400)]
JBAS-2088 Add online payments help email to pay form

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2035 TPAC Syndetics support
Bill Erickson [Thu, 2 Aug 2018 15:54:44 +0000 (11:54 -0400)]
JBAS-2035 TPAC Syndetics support

* 'Reviews and More' opens the Syndetics index page for the record.
* 'Summaries and More' also opens the Syndetics index page for the
  record.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2103 Rainbow combo card; label updates
Bill Erickson [Fri, 14 Sep 2018 19:00:59 +0000 (15:00 -0400)]
JBAS-2103 Rainbow combo card; label updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoStudent imports sftp client force-new option
Bill Erickson [Mon, 17 Sep 2018 19:59:57 +0000 (12:59 -0700)]
Student imports sftp client force-new option

Adds a new -n flag to sftp-client-agent.sh so the agent can be used to
process files with >500 new accounts instead of having to process
manually with generate-patrons-from-csv.pl

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2096 implement hiding for stat cat ""Hidden in BiblioCommons"
Bradley Bonner [Wed, 29 Aug 2018 20:39:23 +0000 (13:39 -0700)]
JBAS-2096 implement hiding for stat cat ""Hidden in BiblioCommons"

As discussed in JBAS-2096, this change adds item opac_visible logic changes to support the newly added "Hidden in BiblioCommons" stat cat.

Bradley Bonner
bbonner@kcls.org

6 years agoper WHD 6134532, removing the patron first name macro from the receipt.
Bradley Bonner [Thu, 23 Aug 2018 17:35:02 +0000 (10:35 -0700)]
per WHD 6134532, removing the patron first name macro from the receipt.

6 years agoJBAS-2089 Remove keychain and pride cards
Bill Erickson [Tue, 14 Aug 2018 18:45:09 +0000 (14:45 -0400)]
JBAS-2089 Remove keychain and pride cards

Additionally, since there are no longer any keychain cards, hide the
card type selector and display the wallet cards by default

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 3.2 data updates extracted for parallelizing
Bill Erickson [Wed, 26 Sep 2018 20:38:44 +0000 (16:38 -0400)]
JBAS-1832 3.2 data updates extracted for parallelizing

Move name keywords, billing updates, and browse data migration to
dedicated scripts so they can be manually run in parallel.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 3.2 billing columns for aged_billing
Bill Erickson [Mon, 24 Sep 2018 19:03:18 +0000 (15:03 -0400)]
JBAS-1832 3.2 billing columns for aged_billing

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2117 Aged money split purge to separate script
Bill Erickson [Tue, 16 Oct 2018 19:42:31 +0000 (15:42 -0400)]
JBAS-2117 Aged money split purge to separate script

Move the purging steps, where we delete rows from money.payment /
money.billing, to a separate DB update so it can be run separately if
necessary.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 Lost/paid summary view SQL repair
Bill Erickson [Tue, 16 Oct 2018 15:21:35 +0000 (11:21 -0400)]
JBAS-1306 Lost/paid summary view SQL repair

Avoid use of all_ciculation_slim and all_payments view for active
lookups.  These slow the queries down considerably for the normal use
case of staff accepting payments and printing recteipts.

If the B.O. needs access to payments for anon circs / money down the
road we may can create a separate query.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 Lost pay dialog login failure fixes
Bill Erickson [Tue, 16 Oct 2018 14:46:20 +0000 (10:46 -0400)]
JBAS-1306 Lost pay dialog login failure fixes

Avoid ressetting the password after a login failure in the lost/paid
dialog, because at the point the login fails, the dialog no longer
exists.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 Lost pay dialog verbiage updates
Bill Erickson [Mon, 15 Oct 2018 19:52:33 +0000 (15:52 -0400)]
JBAS-1306 Lost pay dialog verbiage updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 Reprint lost payment receipt option
Bill Erickson [Thu, 11 Oct 2018 18:47:25 +0000 (14:47 -0400)]
JBAS-1306 Reprint lost payment receipt option

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2101 Use all_payments; receipt updates
Bill Erickson [Thu, 11 Oct 2018 15:02:58 +0000 (11:02 -0400)]
JBAS-2101 Use all_payments; receipt updates

Reference money.all_payments view to pick up aged payments.

Remove staff initials from receipts.

Add Final vs. Partial payment info to receipts.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1306 SQL backport for all circs slim DB view
Bill Erickson [Thu, 8 Feb 2018 15:13:39 +0000 (10:13 -0500)]
JBAS-1306 SQL backport for all circs slim DB view

Use the slim view in the refundable xact summary view.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#1695007 All-circulations slim DB VIEW
Bill Erickson [Thu, 1 Jun 2017 14:56:11 +0000 (10:56 -0400)]
LP#1695007 All-circulations slim DB VIEW

Adds a new view action.all_circulation_slim which collects all
action.circulation and action.aged_circulation rows into a single set,
without the added joins for copy and patron data imposed by the existing
action.aged_circulation view.

The new leaner view is now used by various other views and APIs in place
of the all_circulation view:

DB:  action.all_circ_chain()
DB:  action.summarize_all_circ_chain()
DB:  rating.percent_time_circulating()
API: open-ils.circ.retrieve
API: open-ils.circ.copy_checkout_history.retrieve
API: open-ils.circ.copy_details.retrieve
API: open-ils.circ.renewal_chain.retrieve_by_circ[.summary]
API: open-ils.circ.prev_renewal_chain.retrieve_by_circ[.summary]

To Test (webstaff style):

[1] Open a copy in the web staff Item Status / Detail View interface
    that has live and aged circulations.
[2] Open the Recent Circ History tab
[3] Confirm relevent fields for both types of circs display as expected
    and that the Patron field for the aged circulation shows a value of
    <Aged Circulation>

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
6 years agoJBAS-1306 Lost/paid Payment Reciepts & Tracking
Bill Erickson [Mon, 3 Jul 2017 21:16:42 +0000 (17:16 -0400)]
JBAS-1306 Lost/paid Payment Reciepts & Tracking

* refundable payment tracking
* rf payment print / email receipts (re-printable)
* rf payment staff 2ndry authorization via ldap
* rf payment staff view (for B.O.)

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2094 Transit update occurs in main transaction
Bill Erickson [Mon, 27 Aug 2018 19:17:30 +0000 (15:17 -0400)]
JBAS-2094 Transit update occurs in main transaction

Avoid creating a secondary transaction when updating transits to use a
new source lib/time.  Update should occur in the in-progress transaction
instead.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2117 Aged billing/payment tables local SQL
Bill Erickson [Mon, 24 Sep 2018 18:34:07 +0000 (14:34 -0400)]
JBAS-2117 Aged billing/payment tables local SQL

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#793802 Add money.all_[payments|billings] views
Bill Erickson [Mon, 24 Sep 2018 14:33:13 +0000 (10:33 -0400)]
LP#793802 Add money.all_[payments|billings] views

Similar to money.all_circulation_slim, add views to collect data from
both active and aged versions of the payment and billing tables.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoLP#793802 Aged billings and payments
Bill Erickson [Fri, 21 Sep 2018 18:53:33 +0000 (14:53 -0400)]
LP#793802 Aged billings and payments

Creates tables money.aged_billing and money.aged_payment.  When a
circulation is aged, billings/payments linked to the circ are migrated
to the aged_* table.

Upgrade script includes a migration script for migrating existing
billings and payments.

Includes IDL entries for reporting and pcrud access just in case it's
needed.  Note the 'xact' column on these new tables links directly to
the aged circulation instead of the non-existent money.billable_xact.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2127 Resync DB sample data pre-lost paid
Bill Erickson [Thu, 11 Oct 2018 15:45:45 +0000 (08:45 -0700)]
JBAS-2127 Resync DB sample data pre-lost paid

Remove some errant lost-paid entries in the sample data before applying
the lost-paid commits.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 3.2 SQL rearrangements
Bill Erickson [Thu, 20 Sep 2018 15:43:38 +0000 (11:43 -0400)]
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>
6 years agoCAT-172 Additional AngJS patron edit fixes
Bill Erickson [Wed, 19 Sep 2018 15:55:38 +0000 (11:55 -0400)]
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>
6 years agoCAT-172 patron edit reordered
Katlyn Beck [Thu, 7 Jun 2018 18:34:47 +0000 (18:34 +0000)]
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

6 years agoJBAS-1832 Merge latest 3.2 SQL into upgrade
Bill Erickson [Wed, 19 Sep 2018 14:48:40 +0000 (10:48 -0400)]
JBAS-1832 Merge latest 3.2 SQL into upgrade

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoCAT-152 Update Items Interface
Kyle Huckins [Wed, 25 Oct 2017 23:43:08 +0000 (23:43 +0000)]
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

6 years agoKCLS Ansible-based brick manager + wizard
Bill Erickson [Tue, 27 Feb 2018 16:13:06 +0000 (11:13 -0500)]
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>
6 years agoJBAS-1832 Remove refs to legacy search language_filter
Bill Erickson [Wed, 12 Sep 2018 14:43:28 +0000 (10:43 -0400)]
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>
6 years agoJBAS-2098 Dev DB builder schema-only option
Bill Erickson [Fri, 31 Aug 2018 15:21:23 +0000 (11:21 -0400)]
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>
6 years agoJBAS-1832 Apply COMMIT's to 3.2 SQL updates
Bill Erickson [Wed, 12 Sep 2018 20:11:45 +0000 (16:11 -0400)]
JBAS-1832 Apply COMMIT's to 3.2 SQL updates

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 Migrate 3.2 SQL to sqitch
Bill Erickson [Wed, 12 Sep 2018 14:50:35 +0000 (10:50 -0400)]
JBAS-1832 Migrate 3.2 SQL to sqitch

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1832 KCLS 2.12 -> 3.2 SQL upgrade
Bill Erickson [Tue, 28 Aug 2018 19:57:37 +0000 (15:57 -0400)]
JBAS-1832 KCLS 2.12 -> 3.2 SQL upgrade

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2098 Migrate browse data back to stock tables
Bill Erickson [Thu, 30 Aug 2018 21:34:45 +0000 (17:34 -0400)]
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>
6 years agoJBAS-2040 College cards use email; fixes
Bill Erickson [Wed, 11 Jul 2018 15:37:24 +0000 (11:37 -0400)]
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>
6 years agoJBAS-2018 eCard UMS print notice validator
Bill Erickson [Thu, 26 Jul 2018 14:56:40 +0000 (10:56 -0400)]
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>
6 years agoJBAS-1925 eCard print notice ID fix
Bill Erickson [Wed, 25 Jul 2018 14:16:38 +0000 (10:16 -0400)]
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>
6 years agoJBAS-1925 eCard code generator skips vowels
Bill Erickson [Tue, 24 Jul 2018 21:26:08 +0000 (17:26 -0400)]
JBAS-1925 eCard code generator skips vowels

To avoid creating any words which could be offensive.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1925 eCard address normalizer repair
Bill Erickson [Tue, 24 Jul 2018 21:05:48 +0000 (17:05 -0400)]
JBAS-1925 eCard address normalizer repair

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1925 Verify page close success msg <b> tag
Bill Erickson [Tue, 24 Jul 2018 18:38:54 +0000 (14:38 -0400)]
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>
6 years agoJBAS-1925 Repair temp ecard patron activity non-extension
Bill Erickson [Tue, 24 Jul 2018 13:24:42 +0000 (09:24 -0400)]
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>
6 years agoJBAS-1925 Add Goog tag manager script to eCard form
Bill Erickson [Mon, 23 Jul 2018 15:02:32 +0000 (11:02 -0400)]
JBAS-1925 Add Goog tag manager script to eCard form

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2045 Add self-reg ADA text
Bill Erickson [Thu, 21 Jun 2018 14:34:13 +0000 (10:34 -0400)]
JBAS-2045 Add self-reg ADA text

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2045 Remove gender field / stat cat data
Bill Erickson [Wed, 6 Jun 2018 14:50:34 +0000 (10:50 -0400)]
JBAS-2045 Remove gender field / stat cat data

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-1925 Ecard (Quipu) data and web form
Bill Erickson [Wed, 3 Jan 2018 22:29:48 +0000 (17:29 -0500)]
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>
6 years agoJBAS-2049 Enable Fed. Way teacher accounts
Bill Erickson [Thu, 14 Jun 2018 14:09:53 +0000 (10:09 -0400)]
JBAS-2049 Enable Fed. Way teacher accounts

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoUpdate dev data export w/ merge_date/to fields
Bill Erickson [Fri, 6 Jul 2018 17:14:15 +0000 (10:14 -0700)]
Update dev data export w/ merge_date/to fields

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoAdd SQL insert checks in search-index-keep-periods
Bill Erickson [Fri, 6 Jul 2018 17:04:59 +0000 (13:04 -0400)]
Add SQL insert checks in search-index-keep-periods

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2015 UMS print notice summary email CRONTAB entry
Bill Erickson [Wed, 27 Jun 2018 18:25:12 +0000 (14:25 -0400)]
JBAS-2015 UMS print notice summary email CRONTAB entry

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoEDI fetcher always uses passive FTP
Bill Erickson [Mon, 11 Jun 2018 19:32:53 +0000 (15:32 -0400)]
EDI fetcher always uses passive FTP

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2036 Import pingest; add weekly batches
Bill Erickson [Tue, 29 May 2018 21:39:20 +0000 (17:39 -0400)]
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>
6 years agoJBAS-2012 Hide acq cost value in item summaries
Bill Erickson [Mon, 2 Apr 2018 20:49:08 +0000 (16:49 -0400)]
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>
6 years agoJBAS-2002 Self-reg googalyitcs on submit/cancel events
Bill Erickson [Mon, 2 Apr 2018 20:18:31 +0000 (16:18 -0400)]
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>
6 years agoJBAS-1050 Add strip-period title/author indexes
Bill Erickson [Thu, 17 May 2018 14:34:13 +0000 (10:34 -0400)]
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>
6 years agoJBAS-1634 Acq PO/Invoice search on identifiers
Bill Erickson [Fri, 20 Apr 2018 17:21:03 +0000 (13:21 -0400)]
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>
6 years agoJBAS-1967 Invoice close date search UI fix
Bill Erickson [Thu, 19 Apr 2018 20:15:51 +0000 (16:15 -0400)]
JBAS-1967 Invoice close date search UI fix

Signed-off-by: Bill Erickson <berickxx@gmail.com>
6 years agoJBAS-2024 Alt bib hold counts by rhrr
Bill Erickson [Mon, 16 Apr 2018 21:47:32 +0000 (17:47 -0400)]
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>
6 years agoBackstage Qtrly export reports TCNs
Bill Erickson [Mon, 16 Apr 2018 19:45:32 +0000 (15:45 -0400)]
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>
6 years agoJBAS-1967 Display ERP close date in invoice UI
Bill Erickson [Thu, 12 Apr 2018 20:03:54 +0000 (16:03 -0400)]
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>
6 years agoJBAS-1967 Invoice close fields cross-port
Bill Erickson [Thu, 12 Apr 2018 19:20:03 +0000 (15:20 -0400)]
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>
6 years agoJBAS-2018 A/T UUID template helper function
Bill Erickson [Mon, 9 Apr 2018 14:27:20 +0000 (10:27 -0400)]
JBAS-2018 A/T UUID template helper function

For generating email Message-ID: values

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