senator [Thu, 18 Feb 2010 17:05:11 +0000 (17:05 +0000)]
Acq: Minor bugfixes to PO search interface
1) Avoid a problem with floating point math when summing
amount_{encumbered,spent} in the combined PO view.
2) When redirected to the combined PO view after using the "split PO" function,
check the "show results as a virtual combined PO" checkbox for
interface consistency's sake.
miker [Thu, 18 Feb 2010 15:56:51 +0000 (15:56 +0000)]
forward-porting r15578: Patch from Warren Layton to escape "s in hand-built JSON ... should probably build an object and call js2json against it, but this gets the job done for now
miker [Thu, 18 Feb 2010 02:43:08 +0000 (02:43 +0000)]
Patch from Galen Charlton which:
Fixes bad call to array_upper() that causes ingest to fail if the record
contains one or more 856 fields. Credit to Lee Dickens for discovering the
bug and subsequently testing the fix.
erickson [Wed, 17 Feb 2010 20:51:19 +0000 (20:51 +0000)]
added initial lineitem cancellation api call. added support for creating a/t events for user requests, including item ordered, cancelled, and received. added support for post response hooks to the batch manager for doing work after the caller has been issued a respond_complete
erickson [Wed, 17 Feb 2010 20:35:27 +0000 (20:35 +0000)]
added support for stopping/starting single (Perl) services in lieu of stop/start all via brick control. Also added support for a -l localhost option, which i realize makes no sense in a brick environment, but if you are bouncing between single and multi server systems, it's nice to have the ability to control either with this script
scottmk [Wed, 17 Feb 2010 14:22:56 +0000 (14:22 +0000)]
Add a boolean column prepayment_required to acq.provider.
See KCLS ticket 2249.
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/0163.schema.acq.provider-prepayment-required.sql
M Open-ILS/examples/fm_IDL.xml
senator [Tue, 16 Feb 2010 15:11:37 +0000 (15:11 +0000)]
Acq: POs can only be created with active providers (vendors)
Added a new feature to AutoFieldWidget to make this as simple: there's now
a searchFilter option that you can give to the constructor, enabling you
to constrain the set of objects that you'll get back for, say, a
FilteringSelect widget.
senator [Tue, 16 Feb 2010 15:00:34 +0000 (15:00 +0000)]
Acq: Several improvements to the LI search interface
- You can export a file of ISBN numbers from any interface using an
LI table.
- You can use multiple search terms in the LI search interface.
- The LI search interface no longer returns too many results in tested cases.
- You can make a brief bib record out of your LI search terms.
- Little bit of misc cleanup.
phasefx [Mon, 15 Feb 2010 19:19:21 +0000 (19:19 +0000)]
re-order the local admin menu based on en-US alphabetical order. If we start generating these menus dynamically (which would help reduce the need for staff client upgrades), we could alphabetize long menus regardless of locale
scottmk [Mon, 15 Feb 2010 15:12:14 +0000 (15:12 +0000)]
In acq.lineitem_alert_text: add owning_lib column. Also make the
UNIQUE constraint apply to code + owning_lib, not just code.
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/0161.schema.acq.alert-text-org.sql
M Open-ILS/examples/fm_IDL.xml
dbs [Fri, 12 Feb 2010 20:43:13 +0000 (20:43 +0000)]
Make autoconf 2.6.1 an explicit requirement due to AC_PROG_MKDIR_P macro usage
RHEL 5.4 still ships with autoconf 2.59 (released in 2003, folks) and fails
because MKDIR_P isn't defined. For now, let's kill it right at the ./configure
step until we decide whether to use the marked-as-obsolete AM_PROG_MKDIR_P
macro instead.
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