working/Evergreen.git
16 years agobackporting trunk fix for pathological historical circ report query plan
miker [Thu, 15 Oct 2009 16:43:07 +0000 (16:43 +0000)]
backporting trunk fix for pathological historical circ report query plan

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

16 years agobackporting r14443 and r14444 from trunk: xul + dojo can not use dojo.addOnLoad or...
miker [Thu, 15 Oct 2009 16:20:52 +0000 (16:20 +0000)]
backporting r14443 and r14444 from trunk: xul + dojo can not use dojo.addOnLoad or djConfig.parseOnLoad

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

16 years agouse inline penalty processing during fine generation to prevent duplicate penalties
erickson [Thu, 15 Oct 2009 13:55:20 +0000 (13:55 +0000)]
use inline penalty processing during fine generation to prevent duplicate penalties

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

16 years agoAdd UPDATE_RECORD permission to enable cataloguers to undelete records.
dbs [Thu, 15 Oct 2009 02:49:58 +0000 (02:49 +0000)]
Add UPDATE_RECORD permission to enable cataloguers to undelete records.

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

16 years agoBackport r14431 - add missing error message
dbs [Thu, 15 Oct 2009 01:48:51 +0000 (01:48 +0000)]
Backport r14431 - add missing error message

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

16 years agothinko on rollback vs. commit when creating a local cstoreEditor object for user...
erickson [Wed, 14 Oct 2009 21:02:41 +0000 (21:02 +0000)]
thinko on rollback vs. commit when creating a local cstoreEditor object for user penalty calculation/creation

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

16 years agobackport changeset 14111: fixes doubled holds display glitch from oils_persist
phasefx [Wed, 14 Oct 2009 19:45:57 +0000 (19:45 +0000)]
backport changeset 14111: fixes doubled holds display glitch from oils_persist

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

16 years agolike dob, trim the expire_date to accomodate jscalendar
erickson [Wed, 14 Oct 2009 19:32:05 +0000 (19:32 +0000)]
like dob, trim the expire_date to accomodate jscalendar

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

16 years agoMerge r14405 from trunk: support state_store updates
dbs [Wed, 14 Oct 2009 01:30:01 +0000 (01:30 +0000)]
Merge r14405 from trunk: support state_store updates

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

16 years agoPatch from Laura Cassell to make the email regexp a bit more forgiving.
miker [Mon, 12 Oct 2009 20:25:16 +0000 (20:25 +0000)]
Patch from Laura Cassell to make the email regexp a bit more forgiving.
Specifically, this allows the name portion of the address to contain
period separated chunks.

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

16 years agoonly need to send address search params once now
miker [Mon, 12 Oct 2009 18:00:00 +0000 (18:00 +0000)]
only need to send address search params once now

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

16 years agoforward-porting part of r14372: set trucation to 1 for LoC z39.50 source
miker [Mon, 12 Oct 2009 16:54:39 +0000 (16:54 +0000)]
forward-porting part of r14372: set trucation to 1 for LoC z39.50 source

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

16 years agosort checked out items by due date, oldest first. this brings the items that need...
erickson [Mon, 12 Oct 2009 16:37:12 +0000 (16:37 +0000)]
sort checked out items by due date, oldest first.  this brings the items that need the most attention to the top of the list.  previously, there was no sorting

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

16 years agoforward porting 14363 and 14364: do not use NEW in an ON DELETE trigger, use OLD
miker [Mon, 12 Oct 2009 16:20:56 +0000 (16:20 +0000)]
forward porting 14363 and 14364: do not use NEW in an ON DELETE trigger, use OLD

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

16 years agojscalendar doesn't like the DoB date format. trim the DoB to just the date part
erickson [Mon, 12 Oct 2009 15:04:50 +0000 (15:04 +0000)]
jscalendar doesn't like the DoB date format.  trim the DoB to just the date part

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

16 years agobackport changesets 13953, 14017: persist mechanism replacement for 1.9 xulrunners
phasefx [Mon, 12 Oct 2009 14:50:03 +0000 (14:50 +0000)]
backport changesets 13953, 14017: persist mechanism replacement for 1.9 xulrunners

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

16 years agoforward-porting r14346: pass the patron id (instead of the object) and the appropriat...
miker [Mon, 12 Oct 2009 05:09:26 +0000 (05:09 +0000)]
forward-porting r14346: pass the patron id (instead of the object) and the appropriate context org to the penalty calculator

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

16 years agocapture the context org parameter for penalty generation.
erickson [Mon, 12 Oct 2009 05:08:10 +0000 (05:08 +0000)]
capture the context org parameter for penalty generation.

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

16 years agofoward-porting 1.2 changeset r9281 for cloned patron address searching
miker [Fri, 9 Oct 2009 18:21:40 +0000 (18:21 +0000)]
foward-porting 1.2 changeset r9281 for cloned patron address searching

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

16 years agowhen adding copies to a lineitem, you can now choose the total count instead of havin...
erickson [Fri, 9 Oct 2009 15:29:18 +0000 (15:29 +0000)]
when adding copies to a lineitem, you can now choose the total count instead of having to X copies

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

16 years agountil a more flexible solution exists, make the default zip regex in the old-school...
erickson [Fri, 9 Oct 2009 12:49:38 +0000 (12:49 +0000)]
until a more flexible solution exists, make the default zip regex in the old-school patron editor Canada-friendly by default

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

16 years agoBackporting r14305 to fix <controlfield> creation and use (when missing) bug:
miker [Thu, 8 Oct 2009 17:47:11 +0000 (17:47 +0000)]
Backporting r14305 to fix <controlfield> creation and use (when missing) bug:

When we add a <controlfield> element we need to set it to be 40 characters
long, and full of spaces, otherwise the Fixed Field editor cannot properly
set the positions.

Additionally, when a Fixed Field is edited but there is no backing
<controlfield> element (say, trying to set the Audn when there is no 008)
then we will add the needed <controlfield>.

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

16 years agoBackporting r14032, a confirmed fix for ticket #64: use Safe to protect against EVIL...
miker [Thu, 8 Oct 2009 15:51:09 +0000 (15:51 +0000)]
Backporting r14032, a confirmed fix for ticket #64: use Safe to protect against EVIL evals coming in from the outside world -- we share the environment into the Safe compartment using the name $current_environment

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

16 years agoBackport the good part of r14283 for escaping call number labels and org_unit shortna...
dbs [Wed, 7 Oct 2009 20:38:01 +0000 (20:38 +0000)]
Backport the good part of r14283 for escaping call number labels and org_unit shortnames in -full unAPI output

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

16 years agocreated workaround for confusing IE bug caused by titles with @'s, which resulted...
erickson [Wed, 7 Oct 2009 20:24:08 +0000 (20:24 +0000)]
created workaround for confusing IE bug caused by titles with @'s, which resulted in URLs where the title should be

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

16 years agobackporting -r14276:14278. added support for setting billing/mailing address on...
erickson [Tue, 6 Oct 2009 14:57:26 +0000 (14:57 +0000)]
backporting -r14276:14278.  added support for setting billing/mailing address on the user account.  make new addresses valid by default. make the 1st address on a new patron the billing/mailing address

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

16 years agoRemove the source of many annoying 404 errors - a CSS file that doesn't exist
dbs [Tue, 6 Oct 2009 04:34:24 +0000 (04:34 +0000)]
Remove the source of many annoying 404 errors - a CSS file that doesn't exist

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

16 years agoRemove duplicate entity definition
dbs [Tue, 6 Oct 2009 03:53:51 +0000 (03:53 +0000)]
Remove duplicate entity definition

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

16 years agoif a timestamp is null, don't attempt to turn it into an iso string
erickson [Mon, 5 Oct 2009 17:48:55 +0000 (17:48 +0000)]
if a timestamp is null, don't attempt to turn it into an iso string

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

16 years agomake ndoe depth calculation more efficient and run at startup time to speed up displa...
erickson [Mon, 5 Oct 2009 16:12:14 +0000 (16:12 +0000)]
make ndoe depth calculation more efficient and run at startup time to speed up display for large trees (e.g. org trees).  throw exception when an org unit is retrieved that does not exist, since this cryptic error pops up from time to time during development

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

16 years agoRemove one hard-coded string (Subjects) from default skin
dbs [Fri, 2 Oct 2009 20:14:42 +0000 (20:14 +0000)]
Remove one hard-coded string (Subjects) from default skin

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

16 years agobackporting changeset 14244: Make the old survey wizard use work locations instead...
phasefx [Fri, 2 Oct 2009 04:42:01 +0000 (04:42 +0000)]
backporting changeset 14244: Make the old survey wizard use work locations instead of home lib

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

16 years agoMake MODS v3 variants inherit from mods3 rather than mods (version 2).
dbs [Mon, 28 Sep 2009 18:41:15 +0000 (18:41 +0000)]
Make MODS v3 variants inherit from mods3 rather than mods (version 2).

Results in the correct namespace being applied to MODS v3[123] and makes Zotero happy.

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

16 years agobackporting r14173: Fix targetting trac ticket #70 -- populate the xact_type column...
miker [Sat, 26 Sep 2009 16:39:14 +0000 (16:39 +0000)]
backporting r14173: Fix targetting trac ticket #70 -- populate the xact_type column in transaction summary materialization trigger

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

16 years agoBackporting r14165:
miker [Fri, 25 Sep 2009 01:18:41 +0000 (01:18 +0000)]
Backporting r14165:

Patch from Warren Layton at Laurentian university which addresses some issues
saving org unit data via the conify interfaces.

Thanks, Warren, and sorry for the delay.

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

16 years agobackporting r14159: Correcting reporting view definition with regard to ISBN and...
miker [Thu, 24 Sep 2009 19:26:24 +0000 (19:26 +0000)]
backporting r14159: Correcting reporting view definition with regard to ISBN and ISSN extraction

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

16 years agobackporting r14155: correcting thinko that caused calling a cstore method before...
miker [Thu, 24 Sep 2009 19:17:59 +0000 (19:17 +0000)]
backporting r14155: correcting thinko that caused calling a cstore method before cstore is started

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

16 years agobackporting r13983: turn off array expansion in DBD::Pg (new feature that is on by...
miker [Thu, 24 Sep 2009 17:05:22 +0000 (17:05 +0000)]
backporting r13983: turn off array expansion in DBD::Pg (new feature that is on by default, and we do not want it)

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

16 years agoSQL thinko causing over-zealous reshelving of copies not yet out of their delay time...
miker [Wed, 23 Sep 2009 16:47:16 +0000 (16:47 +0000)]
SQL thinko causing over-zealous reshelving of copies not yet out of their delay time.  Problem spotted and fix suggested by Bill Ott of GRPL.

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

16 years agobiblios Z39 search requires truncation on title attr. call child_init on Z39 module...
erickson [Wed, 23 Sep 2009 16:25:26 +0000 (16:25 +0000)]
biblios Z39 search requires truncation on title attr.  call child_init on Z39 module from top-level search service child init

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

16 years agorepresent due date in local time zone (eventually org unit time zone). cleaned up...
erickson [Wed, 23 Sep 2009 16:23:11 +0000 (16:23 +0000)]
represent due date in local time zone (eventually org unit time zone).  cleaned up the due-date calculation code

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

16 years agoBackport r14098 from trunk: fix typo in CDBI/config.pm (courtesy Jason Stephenson)
dbs [Tue, 22 Sep 2009 20:35:29 +0000 (20:35 +0000)]
Backport r14098 from trunk: fix typo in CDBI/config.pm (courtesy Jason Stephenson)

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

16 years agobackporting r14089 and r14091: IE does not appreciate direct parent/child CSS selecto...
miker [Tue, 22 Sep 2009 17:57:06 +0000 (17:57 +0000)]
backporting r14089 and r14091: IE does not appreciate direct parent/child CSS selectors, so we will use the more generic descendant selector; improve the display of title data by providing a space between subfields (XML processors, particularly those rendering HTML, normalizes whitespace by default)

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

16 years agoproperly populate %services hash of configured Z servers
miker [Mon, 21 Sep 2009 15:12:01 +0000 (15:12 +0000)]
properly populate %services hash of configured Z servers

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

16 years agoif no legacy map for in-db checkout/renew is defined, default to the fail message...
erickson [Fri, 18 Sep 2009 21:34:39 +0000 (21:34 +0000)]
if no legacy map for in-db checkout/renew is defined, default to the fail message from the in-db process

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

16 years agoBug reported by Wiktor Rzeczkowski from McMaster University: [parallel_]pg_loader...
miker [Fri, 18 Sep 2009 17:25:16 +0000 (17:25 +0000)]
Bug reported by Wiktor Rzeczkowski from McMaster University: [parallel_]pg_loader.pl was not taught about the changes to the materialized_simple_record trigger

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

16 years agoduring inspect, return policy data even if the patron is not allowed to checkout...
erickson [Tue, 15 Sep 2009 16:26:19 +0000 (16:26 +0000)]
during inspect, return policy data even if the patron is not allowed to checkout without override

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

16 years agofor now, don't allow inspect calls on copies that have not been created in the db...
erickson [Tue, 15 Sep 2009 16:13:00 +0000 (16:13 +0000)]
for now, don't allow inspect calls on copies that have not been created in the db, IOW pre-cat copies that have never circulated

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

16 years agoPatch from Warren Layton for asciibetical ordering of services in z39.50 client....
phasefx [Sun, 13 Sep 2009 15:11:11 +0000 (15:11 +0000)]
Patch from Warren Layton for asciibetical ordering of services in z39.50 client. Native Catalog always goes to the top. Thanks!

---

The attached patch presents the Z39.50 targets in the Staff Client in
alphabetical order - a problem for us because we're starting to have
quite a few configured.

I'm not sure if this is the most elegant solution so feedback is
definitely welcome.

Cheers,

    Warren

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

16 years agoPatch from Ben Ostrowsky to add some comments to the z39 config table
erickson [Fri, 11 Sep 2009 13:27:44 +0000 (13:27 +0000)]
Patch from Ben Ostrowsky to add some comments to the z39 config table

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

16 years agoPatch from Joe Atzberger to repair fund delete param description
erickson [Thu, 10 Sep 2009 18:21:31 +0000 (18:21 +0000)]
Patch from Joe Atzberger to repair fund delete param description

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

16 years agoprevent negative paging display offset. added paginator to event def grids
erickson [Wed, 9 Sep 2009 13:17:11 +0000 (13:17 +0000)]
prevent negative paging display offset.  added paginator to event def grids

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

16 years agothere's no valid reason to call ingest from within the bib create/overlay code before...
erickson [Fri, 4 Sep 2009 20:50:35 +0000 (20:50 +0000)]
there's no valid reason to call ingest from within the bib create/overlay code before the changes have been committed.  removed embedded ingest logic and the no-ingest flags passed by everyone that uses them

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

16 years agocapture override as a var because using =~ in an arg list is non-good
erickson [Fri, 4 Sep 2009 20:42:32 +0000 (20:42 +0000)]
capture override as a var because using =~ in an arg list is non-good

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

16 years agoon marc record import, call ingest after the create xact has been committed
erickson [Fri, 4 Sep 2009 20:17:29 +0000 (20:17 +0000)]
on marc record import, call ingest after the create xact has been committed

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

16 years agoplug baseWidgetValue setting for readOnly widgets back in with try/catch and comment...
erickson [Fri, 4 Sep 2009 19:58:38 +0000 (19:58 +0000)]
plug baseWidgetValue setting for readOnly widgets back in with try/catch and comment.  typo: state -> state()

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

16 years agotighter control over displaying mark-recived and update-barcodes links in lineitem...
erickson [Fri, 4 Sep 2009 19:26:23 +0000 (19:26 +0000)]
tighter control over displaying mark-recived and update-barcodes links in lineitem table.  showing lineitem and PO state in the UI.  Added PO activate routine which effectively marks a PO as 'ready to send to vendor'

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

16 years agoLoosened constraint on group penalty thresholds. You can now define threholds for...
erickson [Fri, 4 Sep 2009 17:26:02 +0000 (17:26 +0000)]
Loosened constraint on group penalty thresholds.  You can now define threholds for the same group as long as they have a different context org unit

To Update:

ALTER TABLE permission.grp_penalty_threshold DROP CONSTRAINT penalty_grp_once;
ALTER TABLE permission.grp_penalty_threshold ADD CONSTRAINT penalty_grp_once UNIQUE (grp,penalty,org_unit);

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

16 years agoexpose PO ID and PO name. plugged in option to change the PO name
erickson [Fri, 4 Sep 2009 15:24:09 +0000 (15:24 +0000)]
expose PO ID and PO name.  plugged in option to change the PO name

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

16 years agouse a separate pcrud instance for each object deletion so that a single instances...
erickson [Tue, 1 Sep 2009 20:55:54 +0000 (20:55 +0000)]
use a separate pcrud instance for each object deletion so that a single instances isn't trying to create transactions while it's already in the middle of transactions, pending async responses.  added some docs

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

16 years agoadded ability to clone event_def environment when an event_def is cloned
erickson [Tue, 1 Sep 2009 18:41:21 +0000 (18:41 +0000)]
added ability to clone event_def environment when an event_def is cloned

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

16 years agopass the clone object to the postsubmit handler. allow caller to specificy post...
erickson [Tue, 1 Sep 2009 18:41:07 +0000 (18:41 +0000)]
pass the clone object to the postsubmit handler.  allow caller to specificy post-clone handler. added some docs

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

16 years agocalling widget.attr on readonly objects occaisonally results in errors from (as yet...
erickson [Tue, 1 Sep 2009 14:19:21 +0000 (14:19 +0000)]
calling widget.attr on readonly objects occaisonally results in errors from (as yet unexplained) dojo race condition.  however, basewidgetvalue is not needed for readOnly widgets, since displaystring is used, so bypasss for now;  use dojo.create

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

16 years agopass the ID not the bib object to the reporter.simple_rec_update stored proc
erickson [Fri, 28 Aug 2009 22:02:04 +0000 (22:02 +0000)]
pass the ID not the bib object to the reporter.simple_rec_update stored proc

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

16 years agoCreate tables acq.fiscal_calendar and acq.fiscal_year.
scottmk [Thu, 27 Aug 2009 13:05:10 +0000 (13:05 +0000)]
Create tables acq.fiscal_calendar and acq.fiscal_year.

Create function acq.find_bad_fy to do sanity checks on
acq.fiscal_year.

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

16 years agomisnamed dojo tab
erickson [Mon, 24 Aug 2009 21:52:24 +0000 (21:52 +0000)]
misnamed dojo tab

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

16 years agoChange constraint on acq.provider. Instead of making
scottmk [Mon, 24 Aug 2009 17:53:14 +0000 (17:53 +0000)]
Change constraint on acq.provider.  Instead of making
code unique by itself, make code + owner unique.

For changing an existing table:

ALTER TABLE acq.provider
DROP CONSTRAINT provider_code_key;

ALTER TABLE acq.provider
ALTER COLUMN code SET NOT NULL;

ALTER TABLE acq.provider
ADD CONSTRAINT code_once_per_owner
UNIQUE (code, owner);

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

16 years agoAdd columns to acq.purchase_order: order_date and name, along
scottmk [Mon, 24 Aug 2009 16:24:02 +0000 (16:24 +0000)]
Add columns to acq.purchase_order: order_date and name, along
with some triggers for the name.

To apply to an existing table:

-- Add new columns; populate name

ALTER TABLE acq.purchase_order
ADD COLUMN order_date TIMESTAMP WITH TIME ZONE;

ALTER TABLE acq.purchase_order
ADD COLUMN name TEXT;

UPDATE acq.purchase_order
SET name = id::TEXT;

ALTER TABLE acq.purchase_order
ALTER COLUMN name SET NOT NULL;

-- Name should default to the id.  We can't do that with a DEFAULT
-- clause but we can do it with a trigger.

CREATE OR REPLACE FUNCTION acq.purchase_order_name_default () RETURNS TRIGGER
AS $$
BEGIN
IF NEW.name IS NULL THEN
NEW.name := NEW.id::TEXT;
END IF;

RETURN NEW;
END;
$$ LANGUAGE PLPGSQL;

CREATE TRIGGER po_name_default_trg
  BEFORE INSERT OR UPDATE ON acq.purchase_order
  FOR EACH ROW EXECUTE PROCEDURE acq.purchase_order_name_default ();

-- Name should be unique for a given ordering_agency and day, where
-- order_date is not null.  We can't do that with a check constraint
-- because it would require a subquery, so we use a trigger.

CREATE INDEX acq_po_org_name_order_date_idx
ON acq.purchase_order( ordering_agency, name, order_date );

CREATE OR REPLACE FUNCTION acq.po_org_name_date_unique () RETURNS TRIGGER
AS $$
DECLARE
collision INT;
BEGIN
--
-- If order_date is not null, then make sure we don't have a collision
-- on order_date (truncated to day), org, and name
--
IF NEW.order_date IS NULL THEN
RETURN NEW;
END IF;
--
-- In the WHERE clause, we compare the order_dates without regard to time of day.
-- We use a pair of inequalities instead of comparing truncated dates so that the
-- query can do an indexed range scan.
--
SELECT 1 INTO collision
FROM acq.purchase_order
WHERE
ordering_agency = NEW.ordering_agency
AND name = NEW.name
AND order_date >= date_trunc( 'day', NEW.order_date )
AND order_date <  date_trunc( 'day', NEW.order_date ) + '1 day'::INTERVAL
AND id <> NEW.id;
--
IF collision IS NULL THEN
-- okay, no collision
RETURN NEW;
ELSE
-- collision; nip it in the bud
RAISE EXCEPTION 'Colliding purchase orders: ordering_agency %, date %, name ''%''',
NEW.ordering_agency, NEW.order_date, NEW.name;
END IF;
END;
$$ LANGUAGE PLPGSQL;

CREATE TRIGGER po_org_name_date_unique_trg
  BEFORE INSERT OR UPDATE ON acq.purchase_order
  FOR EACH ROW EXECUTE PROCEDURE acq.po_org_name_date_unique ();

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

16 years agoChange uniqueness constraint on acq.fund.code so as to
scottmk [Mon, 24 Aug 2009 15:07:46 +0000 (15:07 +0000)]
Change uniqueness constraint on acq.fund.code so as to
include org and year

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

16 years agotypo, reporter.reporter.
erickson [Fri, 21 Aug 2009 18:33:52 +0000 (18:33 +0000)]
typo,  reporter.reporter.

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

16 years agomore work on pcrud filter dialog. added filter option to autogrid. repaired faulty...
erickson [Fri, 21 Aug 2009 15:33:58 +0000 (15:33 +0000)]
more work on pcrud filter dialog.  added filter option to autogrid.  repaired faulty linked object caching in autogrid.  with caching repaired, made linked grid cell data fetching synchronous to prevent excessive network requests (1st instance of an object is cached)

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

16 years agoNew field: action.hold_request.shelf_time
scottmk [Thu, 20 Aug 2009 21:17:35 +0000 (21:17 +0000)]
New field: action.hold_request.shelf_time

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

16 years agoset hold.shelf_time when item hits the shelf. updated hold notify event def to use...
erickson [Thu, 20 Aug 2009 21:13:08 +0000 (21:13 +0000)]
set hold.shelf_time when item hits the shelf.  updated hold notify event def to use shelf_time as the delay field

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

16 years agoNew column: acq.hold_request.shelf_time
scottmk [Thu, 20 Aug 2009 20:56:39 +0000 (20:56 +0000)]
New column: acq.hold_request.shelf_time

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

16 years agobackport of r13897: thinko in recent ingest fix
miker [Thu, 20 Aug 2009 15:35:29 +0000 (15:35 +0000)]
backport of r13897: thinko in recent ingest fix

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

16 years agobackporting r13894: moving the simple-rec synchronization out of the DB for insert...
miker [Thu, 20 Aug 2009 15:12:35 +0000 (15:12 +0000)]
backporting r13894: moving the simple-rec synchronization out of the DB for insert/update, and as a new trigger for "delete".  This should finally address the ingest issues seen at some sites through the 1.4 series

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

16 years agobackport changeset 13889 for fixing regression with renewing multiple items at once...
phasefx [Thu, 20 Aug 2009 08:07:51 +0000 (08:07 +0000)]
backport changeset 13889 for fixing regression with renewing multiple items at once in staff client

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

16 years agoif the requested hook does not exist, gracefully back out
erickson [Wed, 19 Aug 2009 15:59:16 +0000 (15:59 +0000)]
if the requested hook does not exist, gracefully back out

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

16 years agoadd lib shortname to overdue script xml output
erickson [Wed, 19 Aug 2009 14:11:09 +0000 (14:11 +0000)]
add lib shortname to overdue script xml output

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

16 years agodon't call ->content if there is no response
erickson [Tue, 18 Aug 2009 17:44:41 +0000 (17:44 +0000)]
don't call ->content if there is no response

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

16 years agobackport changesets 13842 and 13862 for working copy/paste context menus in marc...
phasefx [Tue, 18 Aug 2009 06:46:07 +0000 (06:46 +0000)]
backport changesets 13842 and 13862 for working copy/paste context menus in marc editor

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

16 years agobackport changeset 13857: fixed regression with default search field not being refocu...
phasefx [Tue, 18 Aug 2009 05:34:26 +0000 (05:34 +0000)]
backport changeset 13857: fixed regression with default search field not being refocused after using the Clear Form button.  Also have the default field come into focus when the whole tab leaves focus and is later revisited.

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

16 years agoturned on paging for po list. set up the state filter differently so that the browse...
erickson [Mon, 17 Aug 2009 20:10:33 +0000 (20:10 +0000)]
turned on paging for po list.  set up the state filter differently so that the browser won't choose a default value.  no longer showing and fleshing the owner column since it was causing the render flickering... will reassess later.

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

16 years agoset page title
erickson [Mon, 17 Aug 2009 20:10:25 +0000 (20:10 +0000)]
set page title

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

16 years agobackporting -r13845:13848. fund year list api call, suppresse linked fields, fund...
erickson [Mon, 17 Aug 2009 16:16:22 +0000 (16:16 +0000)]
backporting -r13845:13848.  fund year list api call, suppresse linked fields, fund year selector in fund list page using new call

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

16 years agoadded support to autogrid for loading paged data via callback for UIs that load their...
erickson [Sun, 16 Aug 2009 15:49:33 +0000 (15:49 +0000)]
added support to autogrid for loading paged data via callback for UIs that load their own data.  added paging to fund list page.  added paging options to fund by org fetcher

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

16 years agobackporting 13830:13834. initial pagination support. when enabled, back/prev links...
erickson [Thu, 13 Aug 2009 21:11:53 +0000 (21:11 +0000)]
backporting 13830:13834.  initial pagination support.  when enabled, back/prev links appear in a small nav pane just above the grid, added support for limit/offset to pcrud search and retrieveall calls, turn on pagination in the provider list page, fixed some bugs in creating new picklists by name

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

16 years agoadded ability to auto-override configured checkout/renewal events at selfcheck. ...
erickson [Wed, 12 Aug 2009 17:19:29 +0000 (17:19 +0000)]
added ability to auto-override configured checkout/renewal events at selfcheck.  also, pull in JS files directly so we're not unnecessarily running opac-only code

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

16 years agoselected columns in a json_query need to be in an array
erickson [Tue, 11 Aug 2009 16:38:40 +0000 (16:38 +0000)]
selected columns in a json_query need to be in an array

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

16 years agoBackport changeset 13791 from trunk: restore raw z39.50 PQN search feature
phasefx [Mon, 3 Aug 2009 20:55:14 +0000 (20:55 +0000)]
Backport changeset 13791 from trunk: restore raw z39.50 PQN search feature

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

16 years agobackport 13764: added example translator memcache server config
erickson [Wed, 29 Jul 2009 03:23:09 +0000 (03:23 +0000)]
backport 13764: added example translator memcache server config

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

16 years agoset the grp_perm_map sequence before inserting grp_perm_map rows. Thanks Dan!
phasefx [Tue, 28 Jul 2009 18:20:30 +0000 (18:20 +0000)]
set the grp_perm_map sequence before inserting grp_perm_map rows.  Thanks Dan!

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

16 years agoBackport r13751 from trunk: Make i18n scripts stricter about UTF-8 input/output handling.
dbs [Tue, 28 Jul 2009 13:42:29 +0000 (13:42 +0000)]
Backport r13751 from trunk: Make i18n scripts stricter about UTF-8 input/output handling.

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

16 years agoBackport r13750 from trunk: Avoid a mixed-content (HTTP vs. HTTPS) warning
dbs [Tue, 28 Jul 2009 13:41:21 +0000 (13:41 +0000)]
Backport r13750 from trunk: Avoid a mixed-content (HTTP vs. HTTPS) warning

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

16 years agoBackport r13749 from trunk: Attempt to avoid clashes with browsers that treat 'delete...
dbs [Tue, 28 Jul 2009 13:40:16 +0000 (13:40 +0000)]
Backport r13749 from trunk: Attempt to avoid clashes with browsers that treat 'delete' as a reserved JavaScript keyword

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

16 years agobug fix: Item Status, once spawned from the Copy Buckets interface, would keep spawni...
phasefx [Mon, 27 Jul 2009 19:38:58 +0000 (19:38 +0000)]
bug fix: Item Status, once spawned from the Copy Buckets interface, would keep spawning on every bucket change

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

16 years agobackporting changeset 13735: faster method for bill retrieval
phasefx [Fri, 24 Jul 2009 19:42:08 +0000 (19:42 +0000)]
backporting changeset 13735: faster method for bill retrieval

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

16 years agoadded authoritative option so some billing methods
erickson [Fri, 24 Jul 2009 19:25:23 +0000 (19:25 +0000)]
added authoritative option so some billing methods

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

16 years agochanged ACQ label in staff client to Acquisitions (Preview) to prevent confusion
erickson [Fri, 24 Jul 2009 14:24:50 +0000 (14:24 +0000)]
changed ACQ label in staff client to Acquisitions (Preview) to prevent confusion

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

16 years agofixed what appears to be a typo in the oils_i18n_gettext pkey param for 'author of...
erickson [Thu, 23 Jul 2009 21:35:52 +0000 (21:35 +0000)]
fixed what appears to be a typo in the oils_i18n_gettext pkey param for 'author of work' entry

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