dbs [Tue, 28 Jul 2009 06:26:25 +0000 (06:26 +0000)]
Make i18n scripts stricter about UTF-8 input/output handling.
Also, be strict about the JSON format of strings in Dojo resource bundles.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13751
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 28 Jul 2009 05:17:59 +0000 (05:17 +0000)]
Avoid a mixed-content (HTTP vs. HTTPS) warning
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13750
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 28 Jul 2009 05:05:37 +0000 (05:05 +0000)]
Attempt to avoid clashes with browsers that treat 'delete' as a reserved keyword
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13749
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Mon, 27 Jul 2009 19:38:52 +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/trunk@13744
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Mon, 27 Jul 2009 19:15:49 +0000 (19:15 +0000)]
minor bug fix; we're testing the value here for whether it's suitable for display or not, not the existence of the field itself
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13743
dcc99617-32d9-48b4-a31d-
7c20da2025e4
lmcfarland [Mon, 27 Jul 2009 18:57:46 +0000 (18:57 +0000)]
added open-ils.pcrud controller to ahrn class
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13742
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 27 Jul 2009 18:28:38 +0000 (18:28 +0000)]
added pcrud perms for hold notes
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13741
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 24 Jul 2009 21:00:01 +0000 (21:00 +0000)]
reset the alarm with each socket read so that we only time out after a period of inactivity
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13740
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Fri, 24 Jul 2009 19:27:59 +0000 (19:27 +0000)]
faster method for bill retrieval. This was used in the past and for some unknown reason we moved away from it, so testers be wary
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13735
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 24 Jul 2009 19:25:30 +0000 (19:25 +0000)]
added authoritative option so some billing methods
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13734
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Fri, 24 Jul 2009 19:20:06 +0000 (19:20 +0000)]
check for errors on the bills request
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13729
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Fri, 24 Jul 2009 17:14:19 +0000 (17:14 +0000)]
Reworking of the "Messages" interface in the patron display for manipulating standing penalties. Not yet complete, but functional.
TODO:
Need to add a field for staff initials if a specific OU setting is present, and need to add a section and some methods for "archived" messages. Also need to change how penalties are expressed in the summary sidebar. Also need thought on
how/whether/when this will replace the existing Notes infrastructure, since it can do the same thing but better.
NOTES:
Experimenting with xul toolbar/toolbox; there's a beep when you use the hot key for the Actions menu that this might be the cause of. Also, we're actually using the Dojo openils.PermaCrud code for
modifying existing penalties. Exciting :)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13728
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 24 Jul 2009 16:32:49 +0000 (16:32 +0000)]
small net::server process to read MARC data from a raw socket and import the data into Evergreen. It was originally designed for OCLC Connexion imports, but could be used to import MARC from any source
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13727
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 21:36:00 +0000 (21:36 +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/trunk@13724
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 19:19:51 +0000 (19:19 +0000)]
open-ils.cat.biblio.records.merge uses in_db merge now to take advantage of URI handling (and speed, etc.). added a perm test to in_db_merge. removed old bib merge code
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13715
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Thu, 23 Jul 2009 17:52:58 +0000 (17:52 +0000)]
Pull dojo in for all xul interfaces and use its AutoIDL fieldmapper stuff instead of fmall.js/fmgen.js
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13714
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Thu, 23 Jul 2009 16:32:27 +0000 (16:32 +0000)]
Thanks to miker_ and dojo 1.3.2, the <script> tag for loading dojo works now (if you configure djConfig in inline javascript rather than as an attribute on the script tag itself, and dojo.require() works if djConfig is given the baseUrl for dojo.js
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13713
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 14:59:28 +0000 (14:59 +0000)]
patch from Ben Ostrowsky to fix log entry typos: ciculator -> circulator
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13710
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 14:57:02 +0000 (14:57 +0000)]
updated perm description to match expectations
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13709
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 14:51:57 +0000 (14:51 +0000)]
added api call for calling the new actor.usr_delete stored procedure, which purges user data/xacts, anonymizes top-level user data, and transfers data to another user where necessary
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13708
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 23 Jul 2009 13:41:47 +0000 (13:41 +0000)]
Patch from Bill Ott to clear the advanced search form prior to populating with cached search data to prevent doubling of search rows
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13705
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Thu, 23 Jul 2009 01:43:43 +0000 (01:43 +0000)]
Fix typo in typo fix - thanks to Warren Layton for finding & reporting
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13702
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 18:08:59 +0000 (18:08 +0000)]
Patch from Warren Layton for support of RIS format in SuperCat - thanks Warren!
===
I've put together another SuperCat feed, this type for the RIS format.
This can be used with most bibliographic citation software, such as
Reference Manager and Endnote. Combined with the previous "MARC text"
feed for RefWorks, most software should be covered.
I have only included the changes to add the feed and the XSLT file.
The patch (against trunk) doesn't include any changes to the OPAC, but
I'm willing to put something together if needed.
The MARC21slim2RIS.xsl transform makes a few assumptions:
* Any authors listed in 100, 110, or 111 fields are considered
"primary authors" (A1)
* Any individuals listed in 700 fields are considered primary authors
(A1) if their last name is found in the statement of responsibility
(245c). Otherwise, they are considered secondary authors (A2). It's
not 100% accurate, but it's certainly a step up from just turning all
700-level authors into A2s.
* Corporate authors listed in 710 fields are always considered
secondary authors (A2).
* Meetings in 711 fields are always converted into "Title Series" (T3)
(i.e., a talk at a conference would have the conference name listed as
the "Title Series", with the title of the talk listed as "T1", primary
title).
* Apart from field 520 (used for Abstracts, "N2"), no 5xx fields are used
* Subfields in the 650 and 651 fields are used as keywords ("KW")
Developer's Certificate of Origin 1.1
By making a contribution to this project, I certify that:
(a) The contribution was created in whole or in part by me and I
have the right to submit it under the open source license
indicated in the file; or
(b) The contribution is based upon previous work that, to the best
of my knowledge, is covered under an appropriate open source
license and I have the right under that license to submit that
work with modifications, whether created in whole or in part
by me, under the same open source license (unless I am
permitted to submit under a different license), as indicated
in the file; or
(c) The contribution was provided directly to me by some other
person who certified (a), (b) or (c) and I have not modified
it.
(d) I understand and agree that this project and the contribution
are public and that a record of the contribution (including all
personal information I submit with it, including my sign-off) is
maintained indefinitely and may be redistributed consistent with
this project or the open source license(s) involved.
Signed-off-by: Warren Layton
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13700
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 17:59:42 +0000 (17:59 +0000)]
Update the README for the 1.6 release
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13697
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 17:12:23 +0000 (17:12 +0000)]
Populate Acquisitions and Acquisitions Administrators group with basic permissions
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13692
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 16:59:30 +0000 (16:59 +0000)]
Populate Acquisitions and Acquisitions Administrators group with basic permissions
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13691
dcc99617-32d9-48b4-a31d-
7c20da2025e4
miker [Wed, 22 Jul 2009 16:48:33 +0000 (16:48 +0000)]
Temporary script to deal with ingest trigger issues
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13690
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 16:18:48 +0000 (16:18 +0000)]
Add permissions to enable staff to login and catalogers to touch serial records
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13687
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 16:00:12 +0000 (16:00 +0000)]
IDL changes; throw out the cached mods records
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13686
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 13:31:07 +0000 (13:31 +0000)]
Following r13680, don't create the tables that we have now dropped from the schema
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13685
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Wed, 22 Jul 2009 13:21:06 +0000 (13:21 +0000)]
FTS on serials records is unnecessary bloat
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13680
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Wed, 22 Jul 2009 03:55:35 +0000 (03:55 +0000)]
example of getting dojo and PermaCrud to work with xul
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13679
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 21 Jul 2009 21:06:50 +0000 (21:06 +0000)]
setting circ.workstation when appropriate. some minor tab leveling
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13678
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 21 Jul 2009 20:56:53 +0000 (20:56 +0000)]
Oops -- correcting carelessness of previous change
to definition of action.circulation. workstation
references actor,workstation, not actor.org_unit.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13677
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 21 Jul 2009 20:47:45 +0000 (20:47 +0000)]
removed old, unnecessary comment
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13676
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 21 Jul 2009 20:34:05 +0000 (20:34 +0000)]
Adding a column "workstation" to action.circulation
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13675
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 21 Jul 2009 17:20:46 +0000 (17:20 +0000)]
This update to oils_cstore.c moves in the direction of supporting
table aliases in JSON queries (but we're not there yet).
We now maintain a stack to represent the top level query and any
subqueries nested within it. In each stack frame we store information
about the core class and any joined classes, including whatever aliases
are used for them. This stack enables us to look up the table
corresponding to a given alias.
Such searches now replace the old is_joined function for determining
whether a given class is in scope for a column in the SELECT or
ORDER BY clause.
In passing:
1. Rewrote the first few lines of searchJOIN() so that it wouldn't
be so convoluted.
2. We now detect attempts to do autojoins, or to join to the same
table multiple ways. These are the sorts of queries that need
table aliases to disambiguate the table references, The old code
would create invalid SQL and then let PostgreSQL complain about it,
Now we complain about it up front.
3. Corrected spelling errors in a couple of messages.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13674
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 21 Jul 2009 16:13:30 +0000 (16:13 +0000)]
added hold notification trigger event def
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13671
dcc99617-32d9-48b4-a31d-
7c20da2025e4
miker [Tue, 21 Jul 2009 16:00:46 +0000 (16:00 +0000)]
add 1.6 upgrade sql (and remove 2.0 stub)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13670
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 21 Jul 2009 15:04:38 +0000 (15:04 +0000)]
IE does not support Array.map(), use dojo.map(). dojox.data.dom.textContent() returns nothing in IE -- use innerHTML instead when using IE.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13665
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 21 Jul 2009 13:58:11 +0000 (13:58 +0000)]
Hrm; expose dojo.require() calls
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13662
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 21 Jul 2009 13:53:28 +0000 (13:53 +0000)]
Use pcrud to delete MFHD records, per berick's suggestion. One less Perl mess :)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13661
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 21 Jul 2009 13:03:56 +0000 (13:03 +0000)]
use the editor's allowed() method for checking perms. added context org to perm check. removed info/activity logs since editor logs queries at info and updates at activity already. changed 'record' param to 'record_id' for clarity. returning the new id on create instead of the editor object.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13658
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 21 Jul 2009 05:31:25 +0000 (05:31 +0000)]
Add a basic UI for creating and deleting MFHD records to the record display in the staff client
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13649
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 21 Jul 2009 05:29:29 +0000 (05:29 +0000)]
Add some crude methods for creating and deleting MFHD records
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13648
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 21 Jul 2009 05:28:59 +0000 (05:28 +0000)]
Do not display holdings for serial records that have been deleted
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13647
dcc99617-32d9-48b4-a31d-
7c20da2025e4
djfiander [Tue, 21 Jul 2009 01:15:56 +0000 (01:15 +0000)]
Merge processing for $yp and $yc into single loop, since combined
dates can appear in both types of patterns.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13646
dcc99617-32d9-48b4-a31d-
7c20da2025e4
djfiander [Tue, 21 Jul 2009 01:14:50 +0000 (01:14 +0000)]
Add a bit more debugging code
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13645
dcc99617-32d9-48b4-a31d-
7c20da2025e4
djfiander [Tue, 21 Jul 2009 01:11:22 +0000 (01:11 +0000)]
Add a few more tests, including one of a combined publication
date in the $yp pattern rather than in the $yc pattern (example
taken from LoC documentation).
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13644
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Mon, 20 Jul 2009 22:52:21 +0000 (22:52 +0000)]
Avoid one useless call to the goog
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13643
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 20 Jul 2009 20:42:02 +0000 (20:42 +0000)]
localeStrings variable getting clobbered by some other global var. give it a namespace to protect it
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13640
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 20 Jul 2009 19:56:23 +0000 (19:56 +0000)]
in general, you want the router to operate at loglevel 2 (warn) unless you are debugging something
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13637
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 20 Jul 2009 19:39:45 +0000 (19:39 +0000)]
specific cookie path not playing nicely when communicating with staff client cookies, in particular, change operator functionality. go back to global cookies
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13634
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 20 Jul 2009 15:33:54 +0000 (15:33 +0000)]
fixed reltype for hold notes. might_have -> has_many
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13633
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Mon, 20 Jul 2009 05:14:34 +0000 (05:14 +0000)]
no need to destroy and recreate this interface if staff bounce around the patron sub-interfaces
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13632
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Mon, 20 Jul 2009 04:30:08 +0000 (04:30 +0000)]
removed unused variable
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13631
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 20 Jul 2009 03:20:48 +0000 (03:20 +0000)]
display label strings for linked objects instead of bare pkeys. still need to look at resizing the cell
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13628
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Mon, 20 Jul 2009 02:47:04 +0000 (02:47 +0000)]
This interface needs to change a bit, but I wanted to refactor the existing code first to make it more readable (did I succeed?)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13627
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Sun, 19 Jul 2009 15:35:54 +0000 (15:35 +0000)]
added seed data for hold-available notifications. update holdisavail validator to use same basic logic as hold status method
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13624
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Sat, 18 Jul 2009 12:07:49 +0000 (12:07 +0000)]
In oils_auth.c: changed the treatment of inactive accounts.
Previously, if someone tried to log on to an inactive account,
the error message reported to the client would identify the
account as inactive, without regard to the password.
Now the message identifies the account as inactive only if the
password matches. Otherwise it reports it simply as a failure.
Also: changed the barcode to a pointer to const, pointing to
an existing string, rather than allocating a separate copy
that we have to free later.
Also: tinkered with a couple of info messages to avoid
invoking undefined behavior when barcode is NULL.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13623
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Fri, 17 Jul 2009 20:54:17 +0000 (20:54 +0000)]
In oils_auth.c: Fixed a bug.
If you try to log in with a non-existent username, the old
code would report that the username was inactive. Now it
reports a login failure. Inactive usernames are still
reported as inactive.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13622
dcc99617-32d9-48b4-a31d-
7c20da2025e4
miker [Fri, 17 Jul 2009 16:36:15 +0000 (16:36 +0000)]
autodetect marcxml (or, rather, "not binary marc") at vandelay staging import
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13620
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 17 Jul 2009 16:04:45 +0000 (16:04 +0000)]
added option to import holdings from main record import screen. Give the user the option to choose which item import profile, when bibs are done importing, attempt to import holdings for successfully imported records. Still needs a UI for configuring new import profiles and ways to import holdings from the queue interface
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13617
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 16 Jul 2009 20:22:17 +0000 (20:22 +0000)]
1. OK to have duplicate usr_standing_penalty's. 2. find the best context org using the configured penalty org depth. 3. set the staff field.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13616
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Thu, 16 Jul 2009 20:07:02 +0000 (20:07 +0000)]
Create a bunch of new indexes so that the new actor.usr_delete
and actor.usr_purge_data procedures won't have to do full
table scans.
The CREATE INDEX statements are sprinkled across seven different
installation scripts. Here there are all in one place, for
updating an existing database:
-- 200.schema.acq.sql
CREATE INDEX fund_alloc_allocator_idx ON acq.fund_allocation ( allocator );
CREATE INDEX li_creator_idx ON acq.lineitem ( creator );
CREATE INDEX li_editor_idx ON acq.lineitem ( editor );
CREATE INDEX li_selector_idx ON acq.lineitem ( selector );
CREATE INDEX li_note_creator_idx ON acq.lineitem_note ( creator );
CREATE INDEX li_note_editor_idx ON acq.lineitem_note ( editor );
CREATE INDEX li_usr_attr_def_usr_idx ON acq.lineitem_usr_attr_definition ( usr );
CREATE INDEX acq_picklist_owner_idx ON acq.picklist ( owner );
CREATE INDEX acq_picklist_creator_idx ON acq.picklist ( creator );
CREATE INDEX acq_picklist_editor_idx ON acq.picklist ( editor );
CREATE INDEX acq_po_note_creator_idx ON acq.po_note ( creator );
CREATE INDEX acq_po_note_editor_idx ON acq.po_note ( editor );
CREATE INDEX po_creator_idx ON acq.purchase_order ( creator );
CREATE INDEX po_editor_idx ON acq.purchase_order ( editor );
-- 090.schema.action.sql
CREATE INDEX circ_all_usr_idx ON action.circulation ( usr );
CREATE INDEX circ_circ_staff_idx ON action.circulation ( circ_staff );
CREATE INDEX circ_checkin_staff_idx ON action.circulation ( checkin_staff );
CREATE INDEX ahn_notify_staff_idx ON action.hold_notification ( notify_staff );
CREATE INDEX hold_request_fulfillment_staff_idx ON action.hold_request ( fulfillment_staff );
CREATE INDEX hold_request_requestor_idx ON action.hold_request ( requestor );
CREATE INDEX action_in_house_use_staff_idx ON action.in_house_use ( staff );
CREATE INDEX non_cat_in_house_use_staff_idx ON action.non_cat_in_house_use ( staff );
CREATE INDEX action_non_cat_circ_patron_idx ON action.non_cataloged_circulation ( patron );
CREATE INDEX action_non_cat_circ_staff_idx ON action.non_cataloged_circulation ( staff );
CREATE INDEX action_survey_response_usr_idx ON action.survey_response ( usr );
-- 005.schema.actors.sql
CREATE INDEX actor_usr_note_creator_idx ON actor.usr_note ( creator );
CREATE INDEX usr_org_unit_opt_in_staff_idx ON actor.usr_org_unit_opt_in ( staff );
CREATE INDEX actor_usr_standing_penalty_staff_idx ON actor.usr_standing_penalty ( staff );
-- 040.schema.asset.sql
CREATE INDEX asset_call_number_note_creator_idx ON asset.call_number_note ( creator );
CREATE INDEX cp_creator_idx ON asset.copy ( creator );
CREATE INDEX cp_editor_idx ON asset.copy ( editor );
CREATE INDEX asset_copy_note_creator_idx ON asset.copy_note ( creator );
-- 901.audit-tables.sql
CREATE INDEX aud_actor_usr_address_hist_id_idx ON auditor.actor_usr_address_history ( id );
CREATE INDEX aud_actor_usr_hist_id_idx ON auditor.actor_usr_history ( id );
CREATE INDEX aud_asset_cn_hist_creator_idx ON auditor.asset_call_number_history ( creator );
CREATE INDEX aud_asset_cn_hist_editor_idx ON auditor.asset_call_number_history ( editor );
CREATE INDEX aud_asset_cp_hist_creator_idx ON auditor.asset_copy_history ( creator );
CREATE INDEX aud_asset_cp_hist_editor_idx ON auditor.asset_copy_history ( editor );
CREATE INDEX aud_bib_rec_entry_hist_creator_idx ON auditor.biblio_record_entry_history ( creator );
CREATE INDEX aud_bib_rec_entry_hist_editor_idx ON auditor.biblio_record_entry_history ( editor );
-- 070.schema.container.sql
CREATE INDEX user_bucket_item_target_user_idx ON container.user_bucket_item ( target_user );
-- 080.schema.money.sql
CREATE INDEX m_c_t_collector_idx ON money.collections_tracker ( collector );
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13615
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Thu, 16 Jul 2009 16:25:04 +0000 (16:25 +0000)]
flesh hold notes on retrieve by id
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13614
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Thu, 16 Jul 2009 05:53:11 +0000 (05:53 +0000)]
Give cataloguers a chance to recover from errors, or add holdings to an empty MFHD record
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13611
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Wed, 15 Jul 2009 20:15:00 +0000 (20:15 +0000)]
in duplicate patron search, sort patrons with penalties to the top, followed by last/first name sorting
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13610
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Wed, 15 Jul 2009 19:20:42 +0000 (19:20 +0000)]
eh, still didn't think it through. so much for one changeset :)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13609
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Wed, 15 Jul 2009 19:19:21 +0000 (19:19 +0000)]
didn't mean to leave param2 and param3 in there
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13608
dcc99617-32d9-48b4-a31d-
7c20da2025e4
phasefx [Wed, 15 Jul 2009 19:17:50 +0000 (19:17 +0000)]
Not tested, but let the keys 'search_limit' and 'search_sort' be useable in the JSON-encoded 'query' object that pre-populates the search fields in search_form.xul when spawned by say, the patron editor
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13607
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Wed, 15 Jul 2009 17:05:18 +0000 (17:05 +0000)]
patch from Mike R. to provide an option to sort user search results on the number of outstanding penalties a user has
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13606
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Wed, 15 Jul 2009 17:04:42 +0000 (17:04 +0000)]
In actor.usr_delete(): correct the mistreatment of the profile column.
It points to permission.grp_tree, not to actor.org_unit.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13605
dcc99617-32d9-48b4-a31d-
7c20da2025e4
miker [Wed, 15 Jul 2009 16:48:39 +0000 (16:48 +0000)]
check for a null circ mod on an item when doing a non-null circ_mod test
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13602
dcc99617-32d9-48b4-a31d-
7c20da2025e4
miker [Wed, 15 Jul 2009 16:12:55 +0000 (16:12 +0000)]
Protect against duplicate Located URIs at ingest time
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13599
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Wed, 15 Jul 2009 15:01:59 +0000 (15:01 +0000)]
repaired missing ; after COMMENT
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13597
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Wed, 15 Jul 2009 14:06:37 +0000 (14:06 +0000)]
patched up some logic bugs, fixed some typos
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13596
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Wed, 15 Jul 2009 12:22:34 +0000 (12:22 +0000)]
In verifyObjectPCRUD: pull the lookup of the root org_unit id into
a separate function. Cache the results for up to an hour, in order
to reduce the repetition of identical queries getting identical results.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13595
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Wed, 15 Jul 2009 01:11:44 +0000 (01:11 +0000)]
Undoing previous misguided commit
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13594
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 14 Jul 2009 23:27:48 +0000 (23:27 +0000)]
Correct a syntax error where '$func$' appeared in the place of '$$'
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13593
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 14 Jul 2009 20:08:41 +0000 (20:08 +0000)]
added seed data for org-unit setting
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13592
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 14 Jul 2009 19:57:29 +0000 (19:57 +0000)]
when patron checks out an item and they have no holds that directly target the item,
allow for a setting that tells the system to look for an alternate hold to fulfil the item.
also cleaned up some unnecessarily complicated checkout hold fulfil code
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13591
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 14 Jul 2009 18:42:30 +0000 (18:42 +0000)]
Correcting some careless typos...
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13590
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 14 Jul 2009 18:22:34 +0000 (18:22 +0000)]
Add tables from the auditor schema to actor.usr_purge_data().
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13589
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 14 Jul 2009 17:12:01 +0000 (17:12 +0000)]
For the id_list methods: build the SELECT clause directly
instead of incurring the overhead of jsonParseStringFmt().
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13588
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Tue, 14 Jul 2009 16:36:52 +0000 (16:36 +0000)]
Patch from James Fournie -- fixing org tree fleshing depth.
====
I was having a horrible time getting the hasCommonAncestor() function
to work in the circ Javascripts. I eventually discovered that
ScriptBuilder.pm was making a cstore actor.org_unit search with flesh
= 2, which limited the search to org units above depth 2. My org
units were depth 3. I changed the cstore flesh to -1 and this seems
to retreive all org units. I also found an similar problem in
AppUtils.pm
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13584
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Tue, 14 Jul 2009 13:30:41 +0000 (13:30 +0000)]
Tweaks to oils_cstore.c:
1. Added a couple of const qualifiers.
2. In verifyObjectPCRUD: renamed meta to method_metadata, for clarity.
In many places we use "meta" for class metadata.
3. In verifyObjectPCRUD: when looking for the root of the org tree,
build the where clause object directly instead of incurring the overhead
of jsonParseString().
4. A few lines further down: free the where clause object in only
a single place.
5. In single_hash(): represent a NULL value as a JSON_NULL.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13583
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Tue, 14 Jul 2009 02:24:21 +0000 (02:24 +0000)]
Enhance RefWorks support on a per-skin basis:
* Add the ability to disable it entirely (rdetailEnableRefWorks variable)
* Add the ability to specify a different host for the RefWorks application (rdetailRefWorksHost)
Also, collect the growing list of configuration variables in rdetail.js at the head of the file.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13580
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 13 Jul 2009 19:12:33 +0000 (19:12 +0000)]
added duplicate phone / address searching. added and started using locale strings bundle
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13579
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Mon, 13 Jul 2009 18:03:45 +0000 (18:03 +0000)]
Add two functions to the actor schema:
usr_purge_data: purges rows associated with a given user, by either
deleting them or reassigning them to another user.
usr_delete: logically deletes a user; removes personally identifiable
information, and purges associated rows in other tables.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13578
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 13 Jul 2009 17:29:37 +0000 (17:29 +0000)]
use new dojo-ified patron edit interface by default
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13577
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Mon, 13 Jul 2009 16:23:59 +0000 (16:23 +0000)]
Basic fix for reporter as of rel_1_6 and the super-smart cstore
As virtual fields are no longer defined in fm_IDL.xml, the old code that returned
a list of fields filtering on the virtual attribute started returning an empty list.
As a quick fix, we'll just return an array of all field elements.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13574
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 13 Jul 2009 16:22:10 +0000 (16:22 +0000)]
force the staff flag to true for staff-created notes
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13573
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 13 Jul 2009 15:17:51 +0000 (15:17 +0000)]
added 'staff' column to indicate a staff-created hold note
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13572
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Mon, 13 Jul 2009 13:31:48 +0000 (13:31 +0000)]
capture the timeout argument to json_query
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13567
dcc99617-32d9-48b4-a31d-
7c20da2025e4
scottmk [Sat, 11 Jul 2009 22:22:47 +0000 (22:22 +0000)]
Plug a couple of memory leaks.
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13566
dcc99617-32d9-48b4-a31d-
7c20da2025e4
dbs [Sat, 11 Jul 2009 04:41:36 +0000 (04:41 +0000)]
Update to latest libyaz; install z39.50 server library out of the box
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13563
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 10 Jul 2009 14:47:23 +0000 (14:47 +0000)]
dtd entity for new usr_summary column in stat cat editor
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13562
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 10 Jul 2009 14:46:30 +0000 (14:46 +0000)]
using new penalty org depth when setting invalid addr penalty. created const for penalty name
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13561
dcc99617-32d9-48b4-a31d-
7c20da2025e4
erickson [Fri, 10 Jul 2009 14:45:50 +0000 (14:45 +0000)]
added ancestor at depth util function
git-svn-id: svn://svn.open-ils.org/ILS/trunk@13560
dcc99617-32d9-48b4-a31d-
7c20da2025e4