working/Evergreen.git
10 years agoSimple 1-line feature for EDI translator
atz [Wed, 4 Aug 2010 03:56:35 +0000 (03:56 +0000)]
Simple 1-line feature for EDI translator

Allows us to know what the effective version of openils-mapper is.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17070 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoNew org unit setting type: serial.prev_issuance_copy_location
scottmk [Tue, 3 Aug 2010 20:45:45 +0000 (20:45 +0000)]
New org unit setting type: serial.prev_issuance_copy_location

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0359.data.setting-prev-iss-copy-loc.sql
M    Open-ILS/src/sql/Pg/950.data.seed-values.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17069 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years ago0358 more values for acq.cancel_reason
atz [Tue, 3 Aug 2010 20:21:56 +0000 (20:21 +0000)]
0358 more values for acq.cancel_reason

Note: we won't be using all of them, the set is just there for completeness.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17068 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadded open-ils.circ.copy.due_date.retrieve API call to return the due date for a...
erickson [Tue, 3 Aug 2010 20:11:22 +0000 (20:11 +0000)]
added open-ils.circ.copy.due_date.retrieve API call to return the due date for a given copy if it's circulating.  method does not require auth, so only the due date is exposed, not the circ or user, etc.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17067 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoSlight overhaul of ISBN indexing focused on the translate_isbn1013 function
dbs [Tue, 3 Aug 2010 03:14:49 +0000 (03:14 +0000)]
Slight overhaul of ISBN indexing focused on the translate_isbn1013 function

  * Switch to a PLPERLU function built on Business::ISBN for more robust
    indexing of records with problematic ISBNs; thanks to Jason Stephenson
    <jstephenson@mvlc.org> for the initial implementation

  * Remove the first_word, naco_normalize, and split_date_range normalizers
    from the indexing chain for ISBNs, as these unnecessarily munge the
    ISBNs. We can trust Business::ISBN to determine what is a real ISBN,
    hyphens and all.

  * Index all ISBNs in a given record and generate the corresponding
    ISBN10/ISBN13 variations. Also, fix the checksum if given an ISBN with
    a bad checksum, but be sure to index the original bad-checksum ISBN as
    well.

  * Add a set of 10 MARC records with bad ISBNs (thanks to Jason Stephenson
    again for these) for testing purposes to Open-ILS/tests/datasets

  * Add the Business::ISBN Perl module as a prerequisite to the installer

  * Remove contrib/isn from the PostgreSQL install instructions

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17066 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoCorrect DDL for creating a fresh schema - match upgrade 0356
dbs [Tue, 3 Aug 2010 02:24:24 +0000 (02:24 +0000)]
Correct DDL for creating a fresh schema - match upgrade 0356

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17065 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoescape more in the cn label for browse xml
miker [Mon, 2 Aug 2010 20:01:04 +0000 (20:01 +0000)]
escape more in the cn label for browse xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17064 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years ago0356 fixup - the updates otherwise failed for syntax or dependent constraints
atz [Mon, 2 Aug 2010 19:16:02 +0000 (19:16 +0000)]
0356 fixup - the updates otherwise failed for syntax or dependent constraints

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17063 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agocreate correct primary key constraints for some view-based / inheritted tables
miker [Mon, 2 Aug 2010 17:17:55 +0000 (17:17 +0000)]
create correct primary key constraints for some view-based / inheritted tables

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17062 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoupdate schema list for Slony replication
miker [Mon, 2 Aug 2010 15:00:51 +0000 (15:00 +0000)]
update schema list for Slony replication

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17061 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agotoward printing slip and letter for missing pieces
phasefx [Mon, 2 Aug 2010 14:17:02 +0000 (14:17 +0000)]
toward printing slip and letter for missing pieces

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17060 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdmin Menu link for viewing EDI Messages
atz [Fri, 30 Jul 2010 20:27:14 +0000 (20:27 +0000)]
Admin Menu link for viewing EDI Messages

Modifies and uses the existing page for viewing one PO's messages.

TODO: Other kinds of filtering/searching.
TODO: Display PO number where name unavailable.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17059 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agorepaired copy/paste thinko in the vandelay auto-overlay-with-merge-profile logic
erickson [Thu, 29 Jul 2010 23:12:34 +0000 (23:12 +0000)]
repaired copy/paste thinko in the vandelay auto-overlay-with-merge-profile logic

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17058 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoThis patch replaces the result page sidebar new-search trees
miker [Thu, 29 Jul 2010 21:08:36 +0000 (21:08 +0000)]
This patch replaces the result page sidebar new-search trees
(implemented before "faceting" became a thing, and designed for
new-search, not drill-down) with and implementation of what has become
the generally accepted "way to do faceting".  This is implemented as a
Dojo Dijit, and the markup and code footprints within the OPAC proper
are small, just  a couple <div>s and a little bit of glue code to help
the facet rendering engine find the data it needs.  The set and order
of facet classes to display in a given facet bar (title, author,
subject, etc) is configurable in the markup, as are the number of
values displayed for each facet when collapsed (before the [More...]
button is pushed).

Also included is a Searcher Dijit which implements an embeddable
advanced search interface.  This is mainly useful for constructing
boolean-chained searches (we support AND and OR now, though they're
spelled && and || in the query string), and has the beginnings of
support for filters and modifiers.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17057 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAcq: better labels for adding catalog record based item to PL or PO
senator [Thu, 29 Jul 2010 18:54:07 +0000 (18:54 +0000)]
Acq: better labels for adding catalog record based item to PL or PO

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17055 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoNeed to die if we fail to find a picklist, symmetric to the top of the conditional.
atz [Thu, 29 Jul 2010 17:08:37 +0000 (17:08 +0000)]
Need to die if we fail to find a picklist, symmetric to the top of the conditional.

Otherwise, we crash out on $conn->respond($picklist->id);

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17054 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdd Developer Instructions section, like the OpenSRF README, per tsbere's suggestion
dbs [Thu, 29 Jul 2010 16:23:21 +0000 (16:23 +0000)]
Add Developer Instructions section, like the OpenSRF README, per tsbere's suggestion

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17053 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoBuild a threadsafe libjs so that JavaScript::SpiderMonkey can be threadsafe
dbs [Thu, 29 Jul 2010 02:56:48 +0000 (02:56 +0000)]
Build a threadsafe libjs so that JavaScript::SpiderMonkey can be threadsafe

Thomas Berezansky <tsbere@mvlc.org> reported problems building
JavaScript::SpiderMonkey on 64-bit Ubuntu and offered some
patches to build it without -JS_THREADSAFE. The real problem, however,
was that libjs was not itself being built with the JS_THREADSAFE
option.

Enabling the JS_THREADSAFE option pulls in the requirement of
the nspr4-dev package on Ubuntu and Debian.

Tested on 64-bit Ubuntu Lucid and 64-bit Debian Lenny. 64-bit Fedora 13
worked previously because it uses the packaged version of libjs - which
was already built with the JS_THREADSAFE option.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17052 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoPatch from Jason Stephenson:
miker [Thu, 29 Jul 2010 00:55:52 +0000 (00:55 +0000)]
Patch from Jason Stephenson:

The patch adds (BinaryEncoding => 'UTF-8') wherever MARC::File::XML is used in the database
PgPerl functions where it is not already being done. This stops the functions like
maintain_control_number() from trying to convert records from MARC8 to UTF-8 and blowing up,
when the records are already UTF-8.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17051 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoSyntax error in serials schema file.
senator [Wed, 28 Jul 2010 15:51:35 +0000 (15:51 +0000)]
Syntax error in serials schema file.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17049 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agodocumentation for facet value retrieve method
miker [Wed, 28 Jul 2010 14:37:00 +0000 (14:37 +0000)]
documentation for facet value retrieve method

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17048 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agomiddle layer support and client-side utility function. missing messagecat for missin...
phasefx [Tue, 27 Jul 2010 22:33:34 +0000 (22:33 +0000)]
middle layer support and client-side utility function.  missing messagecat for missing pieces dialog

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17047 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agosince we're re-circulating to previous patrons sometimes as a poor man's check-in...
phasefx [Tue, 27 Jul 2010 22:33:10 +0000 (22:33 +0000)]
since we're re-circulating to previous patrons sometimes as a poor man's check-in undo, give us the power to turn off these fee-generating features.  berick++

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17046 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoflesh out scan item as missing pieces dialog
phasefx [Tue, 27 Jul 2010 22:33:01 +0000 (22:33 +0000)]
flesh out scan item as missing pieces dialog

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17045 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoentry point and function stub for Mark Item as Missing Pieces
phasefx [Tue, 27 Jul 2010 22:32:56 +0000 (22:32 +0000)]
entry point and function stub for Mark Item as Missing Pieces
entry point for scanning item as missing pieces and stub dialog

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17044 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoput these command elements into the overlay, closer to where they're being used
phasefx [Tue, 27 Jul 2010 22:32:53 +0000 (22:32 +0000)]
put these command elements into the overlay, closer to where they're being used

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17043 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoPrevent years in "New Fund" dialog from being displayed with a comma separator
dbs [Tue, 27 Jul 2010 21:34:43 +0000 (21:34 +0000)]
Prevent years in "New Fund" dialog from being displayed with a comma separator

Also limit to a seemingly reasonable range of 2000 - 2200 for the year

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17042 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoReverse dojo.mixin() order in AutoFieldWidget to favour passed-in constraints; otherw...
dbs [Tue, 27 Jul 2010 21:27:24 +0000 (21:27 +0000)]
Reverse dojo.mixin() order in AutoFieldWidget to favour passed-in constraints; otherwise we stomp them

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17041 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoMerge Dan Wells' changes to the serial schema from the
scottmk [Tue, 27 Jul 2010 17:27:01 +0000 (17:27 +0000)]
Merge Dan Wells' changes to the serial schema from the
seials-integration branch.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0352.schema.serials-integration.sql
M    Open-ILS/src/sql/Pg/210.schema.serials.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17039 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoWe require Buttons on this form. Continuing the good work senator started.
dbs [Tue, 27 Jul 2010 03:29:19 +0000 (03:29 +0000)]
We require Buttons on this form. Continuing the good work senator started.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17038 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agotweak hold "status" for canceled holds. And one whitespace fix
phasefx [Mon, 26 Jul 2010 18:09:10 +0000 (18:09 +0000)]
tweak hold "status" for canceled holds.  And one whitespace fix

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17035 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoNew table: actor.usr_saved_search
scottmk [Mon, 26 Jul 2010 16:18:09 +0000 (16:18 +0000)]
New table: actor.usr_saved_search

M    Open-ILS/src/sql/Pg/005.schema.actors.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17034 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoimprove description of VIEW_PERMIT_CHECKOUT and VIEW_HOLD_PERMIT permissions
gmc [Mon, 26 Jul 2010 14:09:07 +0000 (14:09 +0000)]
improve description of VIEW_PERMIT_CHECKOUT and VIEW_HOLD_PERMIT permissions

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@17033 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoMention oils_web.xml in the README
dbs [Mon, 26 Jul 2010 13:15:11 +0000 (13:15 +0000)]
Mention oils_web.xml in the README

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17032 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoUpdate README and prereq installer for Evergreen trunk:
dbs [Mon, 26 Jul 2010 12:50:22 +0000 (12:50 +0000)]
Update README and prereq installer for Evergreen trunk:

  * Favour PostgreSQL 8.4
  * Add ISN contrib
  * Update Dojo to 1.3.3
  * Add Ubuntu Lucid as a target
  * Remove Gentoo support (until we have a volunteer)
  * Remove Ubuntu Karmic support (can add back in at release time if warranted)

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17031 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdd procedure action.apply_fieldset.
scottmk [Fri, 23 Jul 2010 17:38:40 +0000 (17:38 +0000)]
Add procedure action.apply_fieldset.

M    Open-ILS/src/sql/Pg/090.schema.action.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0350.schema.action-apply-fieldset.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17030 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoForward-port r17024: include null fields, via .toStoreItem(), when creating a permiss...
miker [Fri, 23 Jul 2010 17:21:24 +0000 (17:21 +0000)]
Forward-port r17024: include null fields, via .toStoreItem(), when creating a permission map store item

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17027 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agologic error preventing deletion of addresses in patron editor
phasefx [Fri, 23 Jul 2010 16:18:58 +0000 (16:18 +0000)]
logic error preventing deletion of addresses in patron editor

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17023 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agosupport printing of stat cats and surveys from patron editor
phasefx [Fri, 23 Jul 2010 15:57:51 +0000 (15:57 +0000)]
support printing of stat cats and surveys from patron editor

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17022 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agolog the IP address of the connecting client
erickson [Fri, 23 Jul 2010 14:36:34 +0000 (14:36 +0000)]
log the IP address of the connecting client

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17021 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAcq: revert something I didn't mean in r17013
senator [Thu, 22 Jul 2010 21:43:27 +0000 (21:43 +0000)]
Acq: revert something I didn't mean in r17013

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17017 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdded option to link a (freerange) lineitem to a catalog
erickson [Thu, 22 Jul 2010 21:39:33 +0000 (21:39 +0000)]
Added option to link a (freerange) lineitem to a catalog
record via simple pop-up search page.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17016 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agofixed bug in related lineitems page where it was attempting to fetch the bib record...
erickson [Thu, 22 Jul 2010 21:39:32 +0000 (21:39 +0000)]
fixed bug in related lineitems page where it was attempting to fetch the bib record based on the lineitem id

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17015 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agobug #608937: make barcode search from main patron search form case-insensitive
gmc [Thu, 22 Jul 2010 21:37:59 +0000 (21:37 +0000)]
bug #608937: make barcode search from main patron search form case-insensitive

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@17014 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAcq: attempt to fix issue where adding copies in an LI table's copies
senator [Thu, 22 Jul 2010 21:33:32 +0000 (21:33 +0000)]
Acq: attempt to fix issue where adding copies in an LI table's copies
interface, then returning to the table view, then going back to copies
doesn't show the most recent saved changes.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17013 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAcq: always show "add to new selection list" / "create new PO" buttons in
senator [Thu, 22 Jul 2010 20:59:52 +0000 (20:59 +0000)]
Acq: always show "add to new selection list" / "create new PO" buttons in
related lineitems interface

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17012 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoupgrade script and version bump for r17007
miker [Thu, 22 Jul 2010 01:03:33 +0000 (01:03 +0000)]
upgrade script and version bump for r17007

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17008 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoretain the indicators on located uri 856 merge during asset merge; update script...
miker [Thu, 22 Jul 2010 00:58:49 +0000 (00:58 +0000)]
retain the indicators on located uri 856 merge during asset merge; update script and backporting to come

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17007 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadded an 'Add Brief Record' button to the PO interface, which is visible when there...
erickson [Wed, 21 Jul 2010 21:35:50 +0000 (21:35 +0000)]
added an 'Add Brief Record' button to the PO interface, which is visible when there are no lineitems on an existing PO.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17006 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd collection code as non-i18n version of shelving location
erickson [Wed, 21 Jul 2010 21:17:00 +0000 (21:17 +0000)]
add collection code as non-i18n version of shelving location

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17005 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agopushed view-in-catalog link up to the main lineitem display.
erickson [Wed, 21 Jul 2010 21:16:59 +0000 (21:16 +0000)]
pushed view-in-catalog link up to the main lineitem display.
moved pl/po/worksheet/catalog links to a row of their own for a more consistent location (visually).
replaced 'PO:' 'PL:' with small icons to easier catch the eye;
added 'worksheet' tag to the worksheet icon for clarity
TODO: plug in bib discovery and linking mechanism for freerange lineitems

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17004 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoprotect acn, acp and auri from our $lib faking
miker [Wed, 21 Jul 2010 20:06:56 +0000 (20:06 +0000)]
protect acn, acp and auri from our $lib faking

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17002 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd parameter support to acn, acp and auri unapi axes
miker [Wed, 21 Jul 2010 19:58:44 +0000 (19:58 +0000)]
add parameter support to acn, acp and auri unapi axes

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17001 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd copy_circ_lib and copy_owning_lib to circ matrix matchpoints, closer one (if...
miker [Wed, 21 Jul 2010 18:17:23 +0000 (18:17 +0000)]
add copy_circ_lib and copy_owning_lib to circ matrix matchpoints, closer one (if both are set) is more important to the ordering

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17000 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoimprove documentation of macros available to receipt templates
gmc [Wed, 21 Jul 2010 16:00:53 +0000 (16:00 +0000)]
improve documentation of macros available to receipt templates

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16999 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoindex which /greatly/ speeds collection of pending active events
miker [Wed, 21 Jul 2010 15:36:52 +0000 (15:36 +0000)]
index which /greatly/ speeds collection of pending active events

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16995 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoTwo new tables in action schema: fieldset and fieldset_col_val.
scottmk [Wed, 21 Jul 2010 15:07:04 +0000 (15:07 +0000)]
Two new tables in action schema: fieldset and fieldset_col_val.

M    Open-ILS/src/sql/Pg/090.schema.action.sql
M    Open-ILS/src/sql/Pg/999.functions.global.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0346.schema.action-fieldset.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16994 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoset truncation to 1 for all biblios.net Z39.50 attributes
gmc [Tue, 20 Jul 2010 22:36:06 +0000 (22:36 +0000)]
set truncation to 1 for all biblios.net Z39.50 attributes

Thanks to Anoop Atre for spotting the problem.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16993 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agologin just before starting work and log out after each request is handled. this...
erickson [Tue, 20 Jul 2010 21:16:00 +0000 (21:16 +0000)]
login just before starting work and log out after each request is handled.  this is removes the need to check for bad authtokens and re-login mid-process

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16992 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoflush the xmpp socket before attempting to process new marc stream requests
erickson [Tue, 20 Jul 2010 21:16:00 +0000 (21:16 +0000)]
flush the xmpp socket before attempting to process new marc stream requests

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16991 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadded support for selecting individual copy statuses that will prevent checkout at...
erickson [Tue, 20 Jul 2010 21:15:59 +0000 (21:15 +0000)]
added support for selecting individual copy statuses that will prevent checkout at self-check even when the generic copy_not_available event has been overridden to allow for non-standard copy circs from selfcheck.  TODO: ui for managing the list

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16990 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoPatch from John Craig providing a saner timestamp cleansing setup for backdated circs
miker [Tue, 20 Jul 2010 19:54:38 +0000 (19:54 +0000)]
Patch from John Craig providing a saner timestamp cleansing setup for backdated circs

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16986 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agobackporting r16982: use the correct table and field, caught by Doug Kyle and reported...
miker [Tue, 20 Jul 2010 15:58:48 +0000 (15:58 +0000)]
backporting r16982: use the correct table and field, caught by Doug Kyle and reported via IRC

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16985 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agomd5 module is deprecated; move to hashlib
erickson [Tue, 20 Jul 2010 12:58:13 +0000 (12:58 +0000)]
md5 module is deprecated;  move to hashlib

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16981 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agouse abs() to get page number in either direction
miker [Mon, 19 Jul 2010 19:03:20 +0000 (19:03 +0000)]
use abs() to get page number in either direction

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16980 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agouse LEFT JOIN to allow a single query to count copies per circ mod
miker [Mon, 19 Jul 2010 15:06:59 +0000 (15:06 +0000)]
use LEFT JOIN to allow a single query to count copies per circ mod

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16979 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoupdated default estimated hold wait display to handle seconds instead of days returne...
erickson [Mon, 19 Jul 2010 14:06:35 +0000 (14:06 +0000)]
updated default estimated hold wait display to handle seconds instead of days returned by the ML API call.  TODO, consider if/how to handle sub-day intervals

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16978 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agowhen calculating estimed hold wait time, don't ignore copies that have no circ modifier
erickson [Mon, 19 Jul 2010 14:06:34 +0000 (14:06 +0000)]
when calculating estimed hold wait time, don't ignore copies that have no circ modifier

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16977 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agorepaired sql syntax for upgrade log commit
erickson [Mon, 19 Jul 2010 12:47:02 +0000 (12:47 +0000)]
repaired sql syntax for upgrade log commit

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16975 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoput the null return back, in case that is important on the client side
miker [Sun, 18 Jul 2010 14:44:18 +0000 (14:44 +0000)]
put the null return back, in case that is important on the client side

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16973 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoremove ingest service call from authority import thanks to in-db ingest of auth by...
miker [Sun, 18 Jul 2010 00:21:09 +0000 (00:21 +0000)]
remove ingest service call from authority import thanks to in-db ingest of auth by dbs; send final message with total and count processed; send record counts at most every 3%; rearrange queue cleanup code to aviod needless rollback and cover all queues, not just the first one we test

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16972 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoTeach marc2sre.pl MFHD record ingest script to read a mapping of library names to...
dbs [Sat, 17 Jul 2010 20:53:55 +0000 (20:53 +0000)]
Teach marc2sre.pl MFHD record ingest script to read a mapping of library names to OU IDs

The past approach required workarounds that weren't fun for a library
without in-house scripting expertise; this provides a straightforward
mapping approach with docs and a working sample. Which should be helpful
for all of the libraries that will go with the MFHD serials approach in
the future. Heh.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16971 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoSwitch to ingesting authority records automatically via database triggers
dbs [Sat, 17 Jul 2010 20:51:15 +0000 (20:51 +0000)]
Switch to ingesting authority records automatically via database triggers

Taken largely from the existing approach for ingesting biblio records,
there is some duplication here that we could genericize. But for now,
we'll go with the working-but-separate approach to avoid introducing
badness into the relatively stable biblio ingest pipeline.

Also, move some of the existing authority-related functions out of
the metabib schema file and into 999.functions.global.sql.

Finally, the direct_ingest.pl script is no longer necessary for
ingest of authority records, either, so die in that case as well.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16970 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoFix schema creation breakage. Damn you dangling commas.
dbs [Sat, 17 Jul 2010 20:45:08 +0000 (20:45 +0000)]
Fix schema creation breakage. Damn you dangling commas.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16969 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd seed for COPY_NEEDED_FOR_HOLD.override permission
gmc [Fri, 16 Jul 2010 20:38:38 +0000 (20:38 +0000)]
add seed for COPY_NEEDED_FOR_HOLD.override permission

Being careful during the upgrade since a fair number of
EG database in the wild had this one added manually.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16968 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoIt is important to update the upgrade_log to prevent collisions and such.
dbs [Fri, 16 Jul 2010 19:55:37 +0000 (19:55 +0000)]
It is important to update the upgrade_log to prevent collisions and such.

Updating config.upgrade_log to 0340.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16967 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoreturn NULL terminator to indicate successful read; fixed typo
erickson [Fri, 16 Jul 2010 19:02:37 +0000 (19:02 +0000)]
return NULL terminator to indicate successful read; fixed typo

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16966 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoget rid of the chrome instantiated sound object so it's every interface for itself...
phasefx [Fri, 16 Jul 2010 18:28:27 +0000 (18:28 +0000)]
get rid of the chrome instantiated sound object so it's every interface for itself, and have remote xul load server/skin/custom.js instead of chrome

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16965 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agomake --timeout actually work if setting a timeout > 60 seconds
gmc [Fri, 16 Jul 2010 15:53:14 +0000 (15:53 +0000)]
make --timeout actually work if setting a timeout > 60 seconds

Also remove ersatz XML declarations so that XML output
is well-formed.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16964 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoserial.record_entry already had an owner column spelled "owning_lib"
dbs [Fri, 16 Jul 2010 15:23:15 +0000 (15:23 +0000)]
serial.record_entry already had an owner column spelled "owning_lib"

Adjust the table and affected function accordingly

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16963 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdd the new owner column to the are object in the IDL
dbs [Fri, 16 Jul 2010 14:56:46 +0000 (14:56 +0000)]
Add the new owner column to the are object in the IDL

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16962 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agorearrange while loop to prevent error: Can't 'last' outside a loop block
erickson [Fri, 16 Jul 2010 13:57:15 +0000 (13:57 +0000)]
rearrange while loop to prevent error: Can't 'last' outside a loop block

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16956 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd --timeout switch to marc_export
gmc [Fri, 16 Jul 2010 13:41:53 +0000 (13:41 +0000)]
add --timeout switch to marc_export

Provides way to export bibs with holdings
that have a large number of copies attached.  Default
timeout remains 1 second when exporting bibs; increased
to 300 seconds when exporting holdings based on
empirical tests on a big database.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16955 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agowhitespace consistency improvements
gmc [Fri, 16 Jul 2010 13:25:06 +0000 (13:25 +0000)]
whitespace consistency improvements

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16954 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agouse a left join instead of -not-exists for anti-join -- much faster for large nullabl...
miker [Fri, 16 Jul 2010 02:37:24 +0000 (02:37 +0000)]
use a left join instead of -not-exists for anti-join -- much faster for large nullable-side sets in this case

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16953 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoThis should have been part of r16946. Now the TranslatorPopup works in the
senator [Thu, 15 Jul 2010 22:01:29 +0000 (22:01 +0000)]
This should have been part of r16946.  Now the TranslatorPopup works in the
Copy Location Editor

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16952 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoHave open-ils.circ.circulation.due_date.update return the circ instead of the circ...
phasefx [Thu, 15 Jul 2010 21:34:21 +0000 (21:34 +0000)]
Have open-ils.circ.circulation.due_date.update return the circ instead of the circ id so that modified rows in Items Out refresh correctly, and have Items Out -> Edit Due Date, -> Renew with Specific Date, and -> Mark Claimed Returned use the date/timepicker dialog

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16951 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agomore configuration options for date/timepicker dialog, and use that dialog with staff...
phasefx [Thu, 15 Jul 2010 21:34:16 +0000 (21:34 +0000)]
more configuration options for date/timepicker dialog, and use that dialog with staff editing of hold thaw date and expire time

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16950 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agowrong variable; could refresh the wrong rows
phasefx [Thu, 15 Jul 2010 21:34:09 +0000 (21:34 +0000)]
wrong variable; could refresh the wrong rows

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16949 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoallow open-ils.circ.hold.update.batch to apply nulls to fields
phasefx [Thu, 15 Jul 2010 21:34:06 +0000 (21:34 +0000)]
allow open-ils.circ.hold.update.batch to apply nulls to fields

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16948 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoadd copy circ lib to alternative item details view
phasefx [Thu, 15 Jul 2010 21:34:02 +0000 (21:34 +0000)]
add copy circ lib to alternative item details view

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16947 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agomake openils.widget.TranslatorPopup a little more environment-agnostic
senator [Thu, 15 Jul 2010 21:19:24 +0000 (21:19 +0000)]
make openils.widget.TranslatorPopup a little more environment-agnostic

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16946 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoARG! Missed a semicolon. Perl, be like JS and make them optional. On second thought...
miker [Thu, 15 Jul 2010 20:27:18 +0000 (20:27 +0000)]
ARG! Missed a semicolon. Perl, be like JS and make them optional.  On second thought do not be like JS in any way.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16945 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoreturn # of imported and failed records to the caller
erickson [Thu, 15 Jul 2010 20:10:10 +0000 (20:10 +0000)]
return # of imported and failed records to the caller

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16943 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoProtect authority records from real deletion and add a "merge authorities" function
dbs [Thu, 15 Jul 2010 19:22:19 +0000 (19:22 +0000)]
Protect authority records from real deletion and add a "merge authorities" function

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16942 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agocompanion to "browse", which drops you into the middle of a list centered on your...
miker [Thu, 15 Jul 2010 17:17:53 +0000 (17:17 +0000)]
companion to "browse", which drops you into the middle of a list centered on your input, "startwith" browses only from your input on

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16941 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoDelete links to deleted bib records as part of biblio.indexing_ingest_or_delete()
dbs [Thu, 15 Jul 2010 15:50:58 +0000 (15:50 +0000)]
Delete links to deleted bib records as part of biblio.indexing_ingest_or_delete()

Moves authority.bib_linking cleanup from the special case
of merging bib record assets to the general case of deleting bib records

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16940 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agobug 605921: fix bib search hang on queries like "title ; subtitle"
gmc [Thu, 15 Jul 2010 15:15:43 +0000 (15:15 +0000)]
bug 605921: fix bib search hang on queries like "title ; subtitle"

More generally, the fix avoids a to_tsquery exception in cases
where a search term is normalized away to the empty string.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16939 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agobug 605884: make MARC expert search of control fields work
gmc [Thu, 15 Jul 2010 13:52:06 +0000 (13:52 +0000)]
bug 605884: make MARC expert search of control fields work

Allows users to search on the 001 and 003 fields, for example.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16938 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoasset.merge_record_assets() needs auth_link declaration (was in upgrade script)
dbs [Thu, 15 Jul 2010 10:24:44 +0000 (10:24 +0000)]
asset.merge_record_assets() needs auth_link declaration (was in upgrade script)

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16937 dcc99617-32d9-48b4-a31d-7c20da2025e4