10 years ago1. New table, acq.lineitem_alert_text.
scottmk [Fri, 12 Feb 2010 20:37:18 +0000 (20:37 +0000)]
1. New table, acq.lineitem_alert_text.

2. New foreign key in acq.lineitem_note, pointing to the new table.

3. Fixed evident typo in IDL for acq.lineitem_note (changed
"Vote Value" to "Note Value").

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0160.schema.acq.line-item-alert-text.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoadded optional user data pass-thru. this will give the UI the ability to pass in...
erickson [Fri, 12 Feb 2010 20:20:21 +0000 (20:20 +0000)]
added optional user data pass-thru.  this will give the UI the ability to pass in per-printout comments, etc.  go ahead and use the print-on-demand granulariy for consistency

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

10 years agomethod for creating/running format related lineitem events, modeled off the one for...
phasefx [Fri, 12 Feb 2010 18:33:22 +0000 (18:33 +0000)]
method for creating/running format related lineitem events, modeled off the one for purchase orders

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632
miker [Fri, 12 Feb 2010 17:21:43 +0000 (17:21 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632
miker [Fri, 12 Feb 2010 17:13:27 +0000 (17:13 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632

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

10 years agoRemove unneeded debugging cruft.
senator [Fri, 12 Feb 2010 17:03:38 +0000 (17:03 +0000)]
Remove unneeded debugging cruft.

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632
miker [Fri, 12 Feb 2010 16:40:37 +0000 (16:40 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:24:21 +0000 (16:24 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:23:07 +0000 (16:23 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoAcq: Added a working LI search interface.
senator [Fri, 12 Feb 2010 16:22:47 +0000 (16:22 +0000)]
Acq: Added a working LI search interface.

There's more to come on this, but for now you can search LIs by state,
by related PO ordering agency, by any one attached attribute value, and even
by providing a file of search terms to match some attributes (ISBN in

This doesn't have paging yet, and will also need tweaked to enable
searching by more than one attribute at a time.

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:17:31 +0000 (16:17 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:11:46 +0000 (16:11 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:10:57 +0000 (16:10 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 16:06:19 +0000 (16:06 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoreverting one of the for..in to for(;;) changes for "arguments" -- that is special
miker [Fri, 12 Feb 2010 16:04:33 +0000 (16:04 +0000)]
reverting one of the for..in to for(;;) changes for "arguments" -- that is special

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

10 years agoAddressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required...
miker [Fri, 12 Feb 2010 15:49:32 +0000 (15:49 +0000)]
Addressing https://bugs.launchpad.net/evergreen/+bug/520632 -- not strictly required here, but for(;;) is better form for array access

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

10 years agoPatch from Joe Atzberger to add getop support for defininging the call style, hostnam...
erickson [Fri, 12 Feb 2010 13:29:27 +0000 (13:29 +0000)]
Patch from Joe Atzberger to add getop support for defininging the call style, hostname, etc. and a fix to bypass some extraneous oils_requestor output that was dying during json parsing

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

10 years agoUse the home library of the bucket owner as the context org for the VIEW_CONTAINER...
phasefx [Thu, 11 Feb 2010 20:19:18 +0000 (20:19 +0000)]
Use the home library of the bucket owner as the context org for the VIEW_CONTAINER permission

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

10 years agoIn renaming the config.recuring_fine table, the associated sequence was not automatic...
dbs [Thu, 11 Feb 2010 20:09:17 +0000 (20:09 +0000)]
In renaming the config.recuring_fine table, the associated sequence was not automatically renamed; fix that.

This manifested in errors thrown while manipulating recurring fines due to the
expectation that the sequence would be named differently than it was.

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

10 years agoforward-porting r15501: Normalization for ratio-like strings -- specifically for...
miker [Thu, 11 Feb 2010 18:22:32 +0000 (18:22 +0000)]
forward-porting r15501: Normalization for ratio-like strings -- specifically for map scale ratios; allow the default search class (as specified in the basic search dropdown) to target a specific index

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

10 years agomoved user request hold promotion to its own sub. exit early on error. promote...
erickson [Thu, 11 Feb 2010 15:44:50 +0000 (15:44 +0000)]
moved user request hold promotion to its own sub.  exit early on error.  promote holds when the lineitem is 'imported' instead of with each lineitem update

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

10 years agoupdated the reporting output. limited returned funds to funds that are propagable...
erickson [Wed, 10 Feb 2010 22:10:13 +0000 (22:10 +0000)]
updated the reporting output. limited returned funds to funds that are propagable and returning the rollover amount for funds whose balances rolled to the following year's funds

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

10 years agobackend to support collection of patron purchase request data; create holds, when...
miker [Wed, 10 Feb 2010 21:45:59 +0000 (21:45 +0000)]
backend to support collection of patron purchase request data; create holds, when requested, from purchase requests at acqli->bre vivication time

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

10 years agoMethod for transfering money between funds
phasefx [Wed, 10 Feb 2010 21:38:43 +0000 (21:38 +0000)]
Method for transfering money between funds

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

10 years agoprovide wrapper methods for the 2 fiscall rollover processes: creating next year...
erickson [Wed, 10 Feb 2010 20:47:44 +0000 (20:47 +0000)]
provide wrapper methods for the 2 fiscall rollover processes: creating next year's funds and moving encumbrances to next years funds / de-activating last year's fund.  For both, a dry run version exists that reports on all fund data (for the related org units) for the following year, including fund summary.  I'd be surprised if we didn't have to tweak this some, but it should be mostly there

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

10 years agoadded sub to find the most relevant event def by hook for a given context org unit
erickson [Wed, 10 Feb 2010 18:15:01 +0000 (18:15 +0000)]
added sub to find the most relevant event def by hook for a given context org unit

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

10 years agoPatch from Joe Atzberger to add a line item 'worksheet' print template and a helper...
erickson [Wed, 10 Feb 2010 17:49:46 +0000 (17:49 +0000)]
Patch from Joe Atzberger to add a line item 'worksheet' print template and a helper routine for extracting lineitem attributes

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

10 years agooops, meant to delete this file when changing it's name. see 15484
erickson [Wed, 10 Feb 2010 17:48:17 +0000 (17:48 +0000)]
oops, meant to delete this file when changing it's name.  see 15484

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

10 years agopercent field was removed from acq::fund_allocation
phasefx [Wed, 10 Feb 2010 15:20:57 +0000 (15:20 +0000)]
percent field was removed from acq::fund_allocation

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

10 years agoML stub for fiscal rollover processing.
erickson [Wed, 10 Feb 2010 02:41:09 +0000 (02:41 +0000)]
ML stub for fiscal rollover processing.

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

10 years agoTry to ensure that the PostgreSQL cluster gets initialized with a C locale
dbs [Wed, 10 Feb 2010 01:42:03 +0000 (01:42 +0000)]
Try to ensure that the PostgreSQL cluster gets initialized with a C locale

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

10 years agoentry points for Transfer Title Holds functionality
phasefx [Tue, 9 Feb 2010 22:11:51 +0000 (22:11 +0000)]
entry points for Transfer Title Holds functionality

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

10 years agoSeveral bug fixes and improvements to LI table and DF application.
senator [Tue, 9 Feb 2010 21:55:26 +0000 (21:55 +0000)]
Several bug fixes and improvements to LI table and DF application.

- The "release" button was removed from the DF application controls.
- The "save changes" button was moved in from the right edge of the screen.
- "Save changes" behaves better (doesn't reveal a dead progress bar) when
    there are no changes to save.
- Distribution formula application controls and labels disappear properly
    from the LI table's copy editor if there are none in the system.
- There is no more error about "li.id is not a function."
- There is a "reset formulas" button in the DF application controls now that
    reverts all copy values to whatever they were before any DF were
    applied (within a single editing session).
- When multiple DF are applied, they are applied "serially" with regards to
    copies, not "in parallel" (i.e., from the end of the last application,
    not from position zero).

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

10 years agolineitem item_count was changed to a virtual field in the IDL some time ago. the...
erickson [Tue, 9 Feb 2010 20:38:27 +0000 (20:38 +0000)]
lineitem item_count was changed to a virtual field in the IDL some time ago.  the column was never used.  removing from the schema for future installs

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

10 years agoinsert 'schema' into upgrade script name
erickson [Tue, 9 Feb 2010 18:00:11 +0000 (18:00 +0000)]
insert 'schema' into upgrade script name

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

10 years agoAdding org unit settings for fund spending limits.
scottmk [Tue, 9 Feb 2010 17:35:29 +0000 (17:35 +0000)]
Adding org unit settings for fund spending limits.

See ticket 4201.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0157.data.fund-spending-limits.sql
M    Open-ILS/src/sql/Pg/950.data.seed-values.sql

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

10 years agoconsolidate inactive provider test in the po create code. added support for preventi...
erickson [Tue, 9 Feb 2010 17:21:06 +0000 (17:21 +0000)]
consolidate inactive provider test in the po create code.  added support for preventing fund debit creation when a fund has or is about to exceed the balance stop percent (if defined)

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

10 years agoWhoops: forgot this sql upgrade script that belonged with the previous commit.
senator [Tue, 9 Feb 2010 14:50:23 +0000 (14:50 +0000)]
Whoops: forgot this sql upgrade script that belonged with the previous commit.

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

10 years agoRecord applications of distribution formulas to lineitems in a new DB table.
senator [Tue, 9 Feb 2010 14:49:16 +0000 (14:49 +0000)]
Record applications of distribution formulas to lineitems in a new DB table.

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

10 years agologic thinko in last-copy-deleted IDL view
miker [Tue, 9 Feb 2010 14:25:22 +0000 (14:25 +0000)]
logic thinko in last-copy-deleted IDL view

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

10 years agodon't allow creation of PO's against inactive providers
erickson [Tue, 9 Feb 2010 03:22:26 +0000 (03:22 +0000)]
don't allow creation of PO's against inactive providers

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

10 years agoadding more ingest normalizers
miker [Mon, 8 Feb 2010 20:52:07 +0000 (20:52 +0000)]
adding more ingest normalizers

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

10 years agosome cleanup of the change_hold_title method
phasefx [Mon, 8 Feb 2010 20:18:12 +0000 (20:18 +0000)]
some cleanup of the change_hold_title method

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

10 years agoAdd "active" column to acq.provider; bool not null default true.
scottmk [Mon, 8 Feb 2010 19:49:10 +0000 (19:49 +0000)]
Add "active" column to acq.provider; bool not null default true.

Related to ticket #2248.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0154.schema.provider-active.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoMethod for moving title holds from their current bibs to a new bib.
phasefx [Mon, 8 Feb 2010 18:32:15 +0000 (18:32 +0000)]
Method for moving title holds from their current bibs to a new bib.

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

10 years agoadding IDL view to calculate the date of removal for the last copy on a bib record
miker [Mon, 8 Feb 2010 17:40:51 +0000 (17:40 +0000)]
adding IDL view to calculate the date of removal for the last copy on a bib record

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

10 years agothese batch calls require a wide timeout window to complete, especially for things...
erickson [Fri, 5 Feb 2010 22:28:10 +0000 (22:28 +0000)]
these batch calls require a wide timeout window to complete, especially for things like pre-due notices with large sets of circs.  Up the request timeout

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

10 years agoAcq: Give users a way to split one PO into many (one PO per lineitem).
senator [Fri, 5 Feb 2010 21:55:23 +0000 (21:55 +0000)]
Acq: Give users a way to split one PO into many (one PO per lineitem).

After splitting, the staff client user is directed to the PO search
interface and is shown a combined view of all the newly separated POs.

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

10 years agoNew columns to acq.fund: balance_wqarning_percent and balance_stop_percent.
scottmk [Fri, 5 Feb 2010 21:23:56 +0000 (21:23 +0000)]
New columns to acq.fund: balance_wqarning_percent and balance_stop_percent.
When the balance of a fund falls below these percentages, the system should
issue a warning or stop further charges.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0153.schema.acq.fund-spending-limits.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoFor now, limit the purchase order targeting event retrieval methods to those with...
phasefx [Fri, 5 Feb 2010 20:11:33 +0000 (20:11 +0000)]
For now, limit the purchase order targeting event retrieval methods to those with EDI related event hooks in their definitions.

Cancel/reset methods for events targeting purchase orders.

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

10 years agoAnd get DojoSRF into the right place
dbs [Fri, 5 Feb 2010 19:29:59 +0000 (19:29 +0000)]
And get DojoSRF into the right place

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

10 years agoCorrect JSDOJOOSRF vs. JSDOJOSRF typo
dbs [Fri, 5 Feb 2010 19:20:30 +0000 (19:20 +0000)]

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

10 years agoEnsure target directory exists before creating links therein
dbs [Fri, 5 Feb 2010 18:54:03 +0000 (18:54 +0000)]
Ensure target directory exists before creating links therein

Thanks to Warren Layton for spotting this in a fresh install

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

10 years agoretain timezone information when building a DateTime object from an epoch timestamp
miker [Fri, 5 Feb 2010 16:33:26 +0000 (16:33 +0000)]
retain timezone information when building a DateTime object from an epoch timestamp

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

10 years agoUndoing most of the previous commit, having been shown
scottmk [Fri, 5 Feb 2010 16:10:25 +0000 (16:10 +0000)]
Undoing most of the previous commit, having been shown
a Better Way...

M    Open-ILS/src/sql/Pg/005.schema.actors.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/0152.schema.acq.undo-spending-limits.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years ago1. Add two new columns to actor.org_unit: spend_warning_percent and
scottmk [Fri, 5 Feb 2010 04:25:05 +0000 (04:25 +0000)]
1. Add two new columns to actor.org_unit: spend_warning_percent and
spend_limit_percent.  These define, by org unit, spending levels
that should trigger either a warning or a firm limit for a fund.

2. Added corresponding columns to the auditor.actor_org_unit_history table.

3. In order to make the above work: raarranged way we create the
actor.org_unit table so that we define it with the fiscal_calendar
column and add the associated foreign key constraint later.

4. Add a fiscal_calendar column to the auditor.actor_org_unit_history
table (correcting an oversight on a previous commit).

5. Created two new functions to look up the default spending levels
for a given org unit.  Where the spending level is undefined, the
functions look for a spending level defined for a parent org unit,
ultimately defaulting if necessary to a hard-coded value.

M    Open-ILS/src/sql/Pg/005.schema.actors.sql
M    Open-ILS/src/sql/Pg/999.functions.global.sql
M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0151.schema.acq.spending-limits.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoMethods for retrieving action_trigger events related to Purchase Orders
phasefx [Thu, 4 Feb 2010 21:13:30 +0000 (21:13 +0000)]
Methods for retrieving action_trigger events related to Purchase Orders

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

10 years agoGive the correct i18n ID to MERGE_USERS (thanks to Benjamin Shum for catching this)
dbs [Thu, 4 Feb 2010 18:09:07 +0000 (18:09 +0000)]
Give the correct i18n ID to MERGE_USERS (thanks to Benjamin Shum for catching this)

Also add MERGE_USERS to the schema upgrade

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

10 years agoAdd an "virtual PO" view of PO search results in the Acquisitions module.
senator [Thu, 4 Feb 2010 17:21:37 +0000 (17:21 +0000)]
Add an "virtual PO" view of PO search results in the Acquisitions module.

This extends the li_table primitive and uses it to display lineitems belonging
to many POs as if they were part of one large PO.

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

10 years agoAdd a function acq.attribute_debits() to attribute debits to funding
scottmk [Thu, 4 Feb 2010 14:23:54 +0000 (14:23 +0000)]
Add a function acq.attribute_debits() to attribute debits to funding
source credits, and thereby to funding sources.

This version is a rewrite.  The original version didn't work in
PostgreSQL 8.2 because it used arrays of composite types.  This
new version uses temporary tables instead.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0149.schema.acq.attribute-debits.sql

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

10 years agoMake Evergreen link to the OpenSRF JavaScript files, rather than copy them.
dbs [Thu, 4 Feb 2010 05:00:54 +0000 (05:00 +0000)]
Make Evergreen link to the OpenSRF JavaScript files, rather than copy them.

This means that if you upgrade OpenSRF, you will automatically get the
upgraded OpenSRF JavaScript in your Evergreen instance without having to
manually copy the files into the multiple places they live. Your Dojo
layer will still need to be recreated, however.

Also, use the autoconf AC_PROG_LN_S and AC_PROG_MKDIR_P macros to provide
better cross-platform support for these commands.

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

10 years agoenabled pagination for circ mod list
erickson [Wed, 3 Feb 2010 23:11:09 +0000 (23:11 +0000)]
enabled pagination for circ mod list

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

10 years ago1. Back off the function acq.attribute_debits, along with three
scottmk [Wed, 3 Feb 2010 18:34:31 +0000 (18:34 +0000)]
1. Back off the function acq.attribute_debits, along with three
associated type definitions, for attributing debits to funding
source credits.  This function used some features not supported
by PostgreSQL 8.2.

2. Add some functions for rolling over funds at the end of the year:


Note that the diffs are misleadingly confusing because of a
bunch of spurious matches.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0148.schema.acq.rollover-fund.sql

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

10 years agoPatch from Bill Ott (after problem identification by Dan Wells) to address styling...
miker [Wed, 3 Feb 2010 15:26:10 +0000 (15:26 +0000)]
Patch from Bill Ott (after problem identification by Dan Wells) to address styling of shadowed records in the staff client

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

10 years agofix survey JS for the new PermaCrud CUD semantics in the oncomplete handler
miker [Tue, 2 Feb 2010 21:56:21 +0000 (21:56 +0000)]
fix survey JS for the new PermaCrud CUD semantics in the oncomplete handler

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

10 years agoupdated oncomplete handlers for new PermaCrud CUD response style
erickson [Tue, 2 Feb 2010 21:38:19 +0000 (21:38 +0000)]
updated oncomplete handlers for new PermaCrud CUD response style

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

10 years agopermacrud CUD actions support an oncomplete handler, but the request object passed...
erickson [Tue, 2 Feb 2010 21:25:44 +0000 (21:25 +0000)]
permacrud CUD actions support an oncomplete handler, but the request object passed as the argument already had it's responses pulled from the wire.  pass the return_list as a second param to CUD onhandler functions.  updated auto widgets to match

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

10 years agoAdd a function acq.transfer_fund to transfer money from one fund
scottmk [Tue, 2 Feb 2010 18:44:24 +0000 (18:44 +0000)]
Add a function acq.transfer_fund to transfer money from one fund
to another (or to none).  The result is entries in acq.fund_allocation
and acq.fund_transfer.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0147.schema.acq.transfer-fund.sql

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

10 years agoAdd the acq.fund_allocation_percent table.
scottmk [Tue, 2 Feb 2010 15:59:11 +0000 (15:59 +0000)]
Add the acq.fund_allocation_percent table.

I had installed this table and the associated triggers via an
upgrade script, but neglected to add them to the baseline
schema script.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql

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

10 years agoretrieve_purchase_order now handles multiple PO requests
sboyette [Tue, 2 Feb 2010 15:08:04 +0000 (15:08 +0000)]
retrieve_purchase_order now handles multiple PO requests

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

10 years agoAdd active flag to acq.fund table. If a fund is not active,
scottmk [Tue, 2 Feb 2010 14:56:16 +0000 (14:56 +0000)]
Add active flag to acq.fund table.  If a fund is not active,
then you shouldn't be able to spend money from it.

See KCLS ticket 4201.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0146.schema.acq.fund-active.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoTypo spotted by Bill Ott: infomation -> information
miker [Tue, 2 Feb 2010 01:31:17 +0000 (01:31 +0000)]
Typo spotted by Bill Ott: infomation -> information

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

10 years agoadding a note for future (Jason?) work -- use the time from the original due date...
miker [Tue, 2 Feb 2010 01:22:49 +0000 (01:22 +0000)]
adding a note for future (Jason?) work -- use the time from the original due date if the circ interval is day-granular

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

10 years agoInclude support for public notes in the formatted display
djfiander [Tue, 2 Feb 2010 00:49:09 +0000 (00:49 +0000)]
Include support for public notes in the formatted display

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

10 years agoFix the leader to ensure that holdings can be compressed.
djfiander [Tue, 2 Feb 2010 00:35:05 +0000 (00:35 +0000)]
Fix the leader to ensure that holdings can be compressed.

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

10 years agoforward porting r15420: add overlooked MERGE_USERS permission
miker [Mon, 1 Feb 2010 21:25:33 +0000 (21:25 +0000)]
forward porting r15420: add overlooked MERGE_USERS permission

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

10 years agofixing namespace array handling in PG 8.3 transitional XML wrapper functions
miker [Mon, 1 Feb 2010 20:59:14 +0000 (20:59 +0000)]
fixing namespace array handling in PG 8.3 transitional XML wrapper functions

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

10 years agoPatch from Doug Kyle to address transit-related deficiency in the reshelving-complete...
miker [Mon, 1 Feb 2010 17:24:21 +0000 (17:24 +0000)]
Patch from Doug Kyle to address transit-related deficiency in the reshelving-complete query.

Previously, items that transited for reshelving at their circulating library would be flipped from Reshelving to Available almost immediately in most cases.  Doug taught the "find copies to flip to Available" query about transit receive times, allowing them to stay in Reshelving status for as long as copies returned directly to the circulating library.

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

10 years agoForward porting r15413: Patch from Ben Ostrowsky updating the list of supported linux...
miker [Mon, 1 Feb 2010 15:29:50 +0000 (15:29 +0000)]
Forward porting r15413: Patch from Ben Ostrowsky updating the list of supported linux distributions in the README

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

10 years agorepaired hold queue position logic to account for holds that have no potential copies...
erickson [Mon, 1 Feb 2010 15:10:57 +0000 (15:10 +0000)]
repaired hold queue position logic to account for holds that have no potential copies assigned

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

10 years agoAvoid i18n breakage due to trailing ampersand in translation
dbs [Mon, 1 Feb 2010 06:22:19 +0000 (06:22 +0000)]
Avoid i18n breakage due to trailing ampersand in translation

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

10 years agoForward-port r15406 from rel_1_6: Fix occurrences parsing in i18n build
dbs [Mon, 1 Feb 2010 06:00:06 +0000 (06:00 +0000)]
Forward-port r15406 from rel_1_6: Fix occurrences parsing in i18n build

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

10 years agoCommit updates to translations from Launchpad
dbs [Mon, 1 Feb 2010 04:37:11 +0000 (04:37 +0000)]
Commit updates to translations from Launchpad

Welcome to Brazilian Portugese, British English, and Spanish!

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

10 years agoAlso remove fm_IDL from the Makefile; fm_IDL.dtd is what we want
dbs [Mon, 1 Feb 2010 04:32:18 +0000 (04:32 +0000)]
Also remove fm_IDL from the Makefile; fm_IDL.dtd is what we want

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

10 years agoDelete this vestigial directory left from the file reorganization
dbs [Mon, 1 Feb 2010 04:29:45 +0000 (04:29 +0000)]
Delete this vestigial directory left from the file reorganization

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

10 years agoC-style comment was terminated prematurely by XPath expression in old biblio.flatten_...
dbs [Mon, 1 Feb 2010 01:49:51 +0000 (01:49 +0000)]
C-style comment was terminated prematurely by XPath expression in old biblio.flatten_marc()

SQL-style comments will avoid that problem and let us keep the old function around
for awhile for easy comparison with the new version.

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

10 years agothis papers over the transitional differences in XML and XSLT support in postgres...
miker [Fri, 29 Jan 2010 20:36:26 +0000 (20:36 +0000)]
this papers over the transitional differences in XML and XSLT support in postgres from version 8.2 through 8.4.  For 8.2, we depend completely on contrib/xml2; for 8.3, we only use contrib/xml2 for the xslt_process function; and finally, for 8.4 we remove contrib/xml2 as a requirement altogether, as it is mostly broken in 8.4

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

10 years agoAdd machinery for attributing debits to funding source credits,
scottmk [Fri, 29 Jan 2010 19:46:40 +0000 (19:46 +0000)]
Add machinery for attributing debits to funding source credits,
and thereby to funding sources.

1. New table, acq.debit_attribution.

2. Create three new types, to be used internally by:

3. New function acq.attribute_debits().

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0143.schema.debit_attribution.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agodon't assume a null org unit value should default to the users workstation org unit...
erickson [Thu, 28 Jan 2010 15:43:31 +0000 (15:43 +0000)]
don't assume a null org unit value should default to the users workstation org unit.  that's misleading.  created a new flag to force this assumption.  when not set, the value remains null

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

10 years agowhen getDisplayString() is called without ever having built a true widget, the code...
erickson [Thu, 28 Jan 2010 15:22:13 +0000 (15:22 +0000)]
when getDisplayString() is called without ever having built a true widget, the code needs to be prepared to deal with raw values.  in this case, 't' and 'f' are valid values for bool fields

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

10 years agodo not promote a number widget's value to '0' when the value is null/isNaN. that...
erickson [Thu, 28 Jan 2010 15:13:28 +0000 (15:13 +0000)]
do not promote a number widget's value to '0' when the value is null/isNaN.  that's equivalent to assuming the value is 37.  if the value needs to be zero, make it so, otherwise assume non-numeric values should translate to null.  will backport after checking for code that functions based on this assumption

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

10 years agoOops: need to coalesce before summing, not after.
scottmk [Thu, 28 Jan 2010 14:06:23 +0000 (14:06 +0000)]
Oops: need to coalesce before summing, not after.

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0142.schema.acq.fund_debit_total_view.sql

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

10 years agoRedefine the view acq.fund_debit_total:
scottmk [Wed, 27 Jan 2010 21:31:12 +0000 (21:31 +0000)]
Redefine the view acq.fund_debit_total:

1. Correct the mistaken use of acq.fund_debit.id for fund,
instead of acq.fund_debit.fund.

2. Join to acq.fund so that we get a zero total for a fund
with no debits in acq.fund_debit.

Four other views are affected indirectly because they are defined
in terms of acq.fund_debit_total:


M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0141.schema.acq.fund_debit_total_view.sql

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

10 years agoAdd history tables, in the acq schema, for acq.purchase_order
scottmk [Tue, 26 Jan 2010 21:40:32 +0000 (21:40 +0000)]
Add history tables, in the acq schema, for acq.purchase_order
and acq.lineitem.

See KCLS tickets 4304 and 2172.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0140.schema.acq-audit-funcs.sql
A    Open-ILS/src/sql/Pg/201.acq.audit-functions.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoDedup recs from open-ils.search.biblio.isbn_list. Consistent whitespace with the...
phasefx [Tue, 26 Jan 2010 16:35:37 +0000 (16:35 +0000)]
Dedup recs from open-ils.search.biblio.isbn_list.  Consistent whitespace with the rest of Biblio.pm

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

10 years agoopen-ils.search.biblio.isbn_list [ isbn1, isbn2, ... ]. This is making multiple...
phasefx [Mon, 25 Jan 2010 21:08:05 +0000 (21:08 +0000)]
open-ils.search.biblio.isbn_list [ isbn1, isbn2, ... ].  This is making multiple calls to storage; we may want to implement it with one SQL query.  May also want to rename the method from .isbn_list to .isbn.batch

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

10 years agofix regression killing transit list interface
phasefx [Mon, 25 Jan 2010 19:31:26 +0000 (19:31 +0000)]
fix regression killing transit list interface

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

10 years agoPatch from Joe Atzberger to address a number of small issues, including better repo...
erickson [Mon, 25 Jan 2010 18:00:02 +0000 (18:00 +0000)]
Patch from Joe Atzberger to address a number of small issues, including better repo update handling and flexibility enhancements for better staff client bundles

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

10 years agoPatch from Joe Atzberger to allow db update script to run from the ILS base directory
erickson [Mon, 25 Jan 2010 17:48:40 +0000 (17:48 +0000)]
Patch from Joe Atzberger to allow db update script to run from the ILS base directory

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

10 years agoprovide a --max-sleep=<seconds> option for use in --process-hooks mode to wait on...
miker [Mon, 25 Jan 2010 17:38:38 +0000 (17:38 +0000)]
provide a --max-sleep=<seconds> option for use in --process-hooks mode to wait on the lock file to go away, and default to 1 hour (3600)

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