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
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
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
particular).
This doesn't have paging yet, and will also need tweaked to enable
searching by more than one attribute at a time.
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
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
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
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
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
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).
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
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)
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
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
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
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
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
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
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.
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:
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
projects / working / Evergreen.git / log