Add columns to the database for storing URIs of SKOS
vocabularies and concepts. In particular:
- add a vocabulary column to config.record_attr_definition
to store the URI of the published vocabulary associated
with the record attribute
- add a concept_uri column to config.coded_value_map
Signed-off-by: Galen Charlton <gmc@esilibrary.com> Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
This was converted from marcedit-tooltips.xml
using the marc_tooltips_to_sql script introduced in the
previous commit. As a consequence, the tag table
data is somewhat out of date; this will be addressed
later.
Signed-off-by: Galen Charlton <gmc@esilibrary.com> Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Galen Charlton [Mon, 2 Mar 2015 19:10:13 +0000 (19:10 +0000)]
LP#1427287: script to migrate MARC tooltips data file
marc_tooltips_to_sql is a script that converts an
Evergreen MARC tooltips file to a set of SQL statements
for seeding config.marc_field, config.marc_subfield,
config.record_attr_definition, and config.coded_value_map
with tag table data.
This patch teaches the Evergreen database how to store
information about MARC fields, subfields, and values that
can be associated with subfields. The initial application
of the tag-table service is supplying the webstaff MARC editor
with data for context menus for selecting valid tag, indicator
value, subfield code, and subfield values.
A record attribute's coded value map can be associated with a
MARC subfield and returned by the tag-table service. This is for
supporting the use of controlled vocabularies for subfield values in
the MARC editor.
Database schema
---------------
Tables:
* config.marc_format: list of MARC formats; at present, however,
only MARC21 is supported
* config.marc_field: list of fields recognized by the Evergreen
database.
* config.marc_subfield: list of subfields recognized by Evergreen
These two views assist in the process of determining the set of
MARC fields and subfields are meant to be in force at a particular
OU. These are generally not meant to be queried directly, in
favor of the config.ou_marc_{sub}fields() functions.
These functions return the authoritative set of fields or
subfields in force at a given OU.
OpenSRF methods
---------------
This patch adds methods to open-ils.cat for
retrieving either the entire tag table or just the list
of MARC fields, either from the stock MARC format
seed definition or as potentially customized for the user's
workstation OU:
Ben Shum [Tue, 18 Aug 2015 15:26:09 +0000 (11:26 -0400)]
LP#1312309: Initial changes to web Makefile to avoid copying JSPAC files
In Open-ILS/web/Makefile.am, we were copying in some files for JSPAC.
Because we're in the process of removing these files, this broke the
installation process for make install step of the README.
Remove the loop for now, probably more cleanup required here.
Jeff Godin [Fri, 15 May 2015 23:16:50 +0000 (16:16 -0700)]
LP#1312309: Remove old bbags.xml interface, apache config
Remove the XML and Javascript for the old JSPAC book bags / bbags / list
display.
Also, remove <Location> block in Apache example configs for /opac/extras, as
the only things requiring it were the (now removed) legacy self checkout
interface, and this bbags interface.
Signed-off-by: Jeff Godin <jgodin@tadl.org> Signed-off-by: Ben Shum <bshum@biblio.org>
Bill Erickson [Tue, 18 Aug 2015 16:42:14 +0000 (12:42 -0400)]
LP#1440114 invoice item type prorate/blanket warning
Warn the user that only one of 'prorate' or 'blanket' may be selected
when creating/editing an invoice item type. When this happens, the save
operation is aborted and the user is returned to the edit dialog.
Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Adds new "Finalize Blanket Order" button to purchase page for PO's that
are activated and have at least on blanket charge. Finalizing the PO
disencumbers all blanket charges and marks the PO as complete.
Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Kathy Lussier <klussier@masslnc.org>
When invoicing a PO that has at least one blanket charge, a new option is
present which allows staff to indicate that an invoice is the final invoice
for the PO. Finalizing a PO results in the following:
1. Encumbrances for all blanket charges on the PO are dropped to $0.
This is done by setting the amount paid in the original fund_debit
(linked the blanket po_item) to $0.
2. If no pending lineitems exist on the PO, the PO is marked as received.
If there are pending lineitems, the state is left untouched.
Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Support "blanket" (long-lived, multi-invoice) orders via a new "blanket"
boolean on invoice item types. Blanket charges can be invoiced multiple
times by creating a new fund_debit for each invoice item linked to a
blanket po_item.
This change also adds the amounts paid over time for blanket charges to
the Amount Paid summary information for purchase orders containing the
charges.
Adds a new Invoice Item Type of "Blanket Order".
Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Bill Erickson [Wed, 8 Apr 2015 19:17:01 +0000 (15:17 -0400)]
LP#1440114 Remove inv_item via po_item from invoice
Allow invoice_items which were descended from po_item's (direct charges)
to be removed from invoices. Prior to this, a JS exception prevented
removal of these items.
Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Kathy Lussier <klussier@masslnc.org>
This commit adds a pgTAP test which ensures that imported items are
being successfully added to the 'import_item' table. The test confirms
that the correct number of items have stat cat data in the table. The
test also ensures that the new xpath function works properly, simply by
using it.
Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Ben Shum <bshum@biblio.org>
LP#1379815 Add code to assign stat cats on Vandelay imported items
This commit adds columns to the Holdings Import Profile table
(vandelay.import_item_attr_definition) and to vandelay.import_item, adds
the corresponding fields to the IDL, modifies the database functions
which import the data (ingest_bib_items() and ingest_items()) and adds
code that parses the imported stat cat data (of the form
CAT 1|VALUE 1||CAT 2|VALUE 2) and applies it to the appropriate
overlayed copy.
Signed-off-by: Remington Steed <rjs7@calvin.edu> Signed-off-by: Dan Wells <dbw2@calvin.edu> Signed-off-by: Ben Shum <bshum@biblio.org>
Dan Wells [Wed, 8 Oct 2014 17:35:43 +0000 (13:35 -0400)]
LP#1379815 Add missing behavior to update_copy_stat_entries
The current function doesn't provide the level of control we need, even
with the 'delete_stats' flag set to zero. This commit adds a new
'add_or_update_only' option which preserves existing stat cat entry maps
for any stat cat not represented on the incoming copy object, and
updates values when appropriate.
This commit also updates the function comment for better clarity.
Signed-off-by: Dan Wells <dbw2@calvin.edu> Signed-off-by: Ben Shum <bshum@biblio.org>
Dan Wells [Mon, 6 Oct 2014 15:52:27 +0000 (11:52 -0400)]
LP#1379815 Fetch tag data as a table using tag/xpath combo
New function: oils_xpath_tag_to_table()
This function is adapted from oils_xpath_table() with the goal of being
more targeted and simpler to use.
The main issue with oils_xpath_table() is that it relies on peer
UNNEST() functions, and that leads to unexpected behavior whenever the
xpath arguments result in uneven or "gapped" selections. In the first
type of case, the resulting table includes rows representing the least
common multiple of the underlying xpath selections. In the second
type, though the xpaths may sometimes return the same number of values,
those values are not correlated except by order in the marc, which does
not account for the real possibility of null values in the set.
This example illustrates both negative behaviors (non-correlated fields
and least-common-multiple row multiplication).
The new method, while internally quite similar, has a different
signature, with the most significant change being a 'tag' argument
which serves as a common base element for the xpaths (now an array
rather than a pipe-delimited string).
Signed-off-by: Dan Wells <dbw2@calvin.edu> Signed-off-by: Ben Shum <bshum@biblio.org>
Set search preferences is currently ordered by shortname in
Admin > Workstation Administration > Set Search Preferences.
This patch adds functionality that orders each org unit and
its children in alphabetical order by name, rather than by
shortname.
Signed-off-by: Adam Bowling <abowling@emeralddata.net> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>