working/Evergreen.git
10 years agoAdd purchase_order column to acq.edi_message.
scottmk [Wed, 12 May 2010 20:44:40 +0000 (20:44 +0000)]
Add purchase_order column to acq.edi_message.

Also: add the CREATE TABLE command for acq.edi_message (including
the new column) to 200.schema.acq.sql, where it was omitted due
to an oversight.

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/0259.schema.acq-edi-msg-po.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoPatch from Galen Charlton: This resolves a performance issue found by EG Indiana...
erickson [Wed, 12 May 2010 19:20:05 +0000 (19:20 +0000)]
Patch from Galen Charlton: This resolves a performance issue found by EG Indiana on large ascecm tables.

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

10 years agoput spine label preview into a tab instead of a window. fixes it for xulrunner 1.9.2
phasefx [Wed, 12 May 2010 17:48:35 +0000 (17:48 +0000)]
put spine label preview into a tab instead of a window.  fixes it for xulrunner 1.9.2

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

10 years agohoping to get around new chrome versus remote xul restrictions
phasefx [Wed, 12 May 2010 17:48:34 +0000 (17:48 +0000)]
hoping to get around new chrome versus remote xul restrictions

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

10 years agogo back to using cmd_print code; we'll fix it in browser.js if at all
phasefx [Wed, 12 May 2010 17:48:33 +0000 (17:48 +0000)]
go back to using cmd_print code; we'll fix it in browser.js if at all

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

10 years agodefine obj for this method
phasefx [Wed, 12 May 2010 17:48:32 +0000 (17:48 +0000)]
define obj for this method

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

10 years agocall recv to pull responses off the wire
erickson [Wed, 12 May 2010 02:55:24 +0000 (02:55 +0000)]
call recv to pull responses off the wire

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

10 years agoAdd "label" column to query.bind_variable
scottmk [Tue, 11 May 2010 19:53:25 +0000 (19:53 +0000)]
Add "label" column to query.bind_variable

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0257.schema.query-bind-var-label.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agopcrud requires transaction begin/commit for writes...
erickson [Mon, 10 May 2010 22:26:20 +0000 (22:26 +0000)]
pcrud requires transaction begin/commit for writes...

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

10 years agoDefine an updatable view query.expr_xbind as those rows in
scottmk [Mon, 10 May 2010 19:48:15 +0000 (19:48 +0000)]
Define an updatable view query.expr_xbind as those rows in
query.expression where type = 'xbind'.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0256.schema.query-bind-expr-view.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoAdd to query.expression: foreign key bind_variable pointing
scottmk [Mon, 10 May 2010 18:42:52 +0000 (18:42 +0000)]
Add to query.expression: foreign key bind_variable pointing
to query.bind_variable.  Also: allow the expression type 'xbind'.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0255.query-expr-bind.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoAdd table query.bind_variable.
scottmk [Mon, 10 May 2010 14:52:05 +0000 (14:52 +0000)]
Add table query.bind_variable.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0254.schema.query-bind-variable.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoRevise the updatable views for the various types of query.expression:
scottmk [Sat, 8 May 2010 20:17:42 +0000 (20:17 +0000)]
Revise the updatable views for the various types of query.expression:

1. Rename query.expr_string to query.expr_xstr, for consistency.

2. Add a "negate" column to each view, except for query.expr_xnum
and query.expr_xstr.

3. Add a "left_operand" column to query.expr_xin, correcting an
earlier oversignt.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0253.schema.query_expr_view.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoremoved unused utility function that was calling a (likely) deprecated view
erickson [Fri, 7 May 2010 19:31:08 +0000 (19:31 +0000)]
removed unused utility function that was calling a (likely) deprecated view

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

10 years agouse direct circ search instead of what-may-be-one-day-deprecated open-ils.cstore...
erickson [Fri, 7 May 2010 19:04:56 +0000 (19:04 +0000)]
use direct circ search instead of what-may-be-one-day-deprecated open-ils.cstore.direct.action.open_circulation.search view API call in circ fetching utility function

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

10 years agopatch from James Fournie to repair some faulty assumptions in the previous legacy...
erickson [Fri, 7 May 2010 18:53:45 +0000 (18:53 +0000)]
patch from James Fournie to repair some faulty assumptions in the previous legacy script SIP fix;  additionally, I added legacy_script_support override option to oils_sip.xml.exmple to allow use of in-db circ-mod configs even if the circ code is still using circ scritps

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

10 years agoAcq: bugfixes, improvements to lineitem + bib search
senator [Fri, 7 May 2010 15:27:22 +0000 (15:27 +0000)]
Acq: bugfixes, improvements to lineitem + bib search

identify bib-results with a book icon to distinguish them from li
results; git rid of an alert() when canceling from a file upload dialog;
fix a sneaky bug that removed other match-type options once the user selecte
the "term from a file" option

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

10 years agorough cut at reporting extension for a purchase alert list (based on holds to copy...
phasefx [Thu, 6 May 2010 22:14:06 +0000 (22:14 +0000)]
rough cut at reporting extension for a purchase alert list (based on holds to copy ratio).  mulling over the notion of using action.hold_copy_map for counting copies...  exceptions abound however we do it as far as accuracy goes

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

10 years agoWrap interface results from "find originating purchase order" in browser
senator [Thu, 6 May 2010 19:52:20 +0000 (19:52 +0000)]
Wrap interface results from "find originating purchase order" in browser

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

10 years agoadd explicit nesting parens in SQL; protect against empty class specifiers (throw...
miker [Thu, 6 May 2010 19:49:25 +0000 (19:49 +0000)]
add explicit nesting parens in SQL; protect against empty class specifiers (throw them away)

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

10 years ago1. Support negation of an expression (except in a few cases where it
scottmk [Thu, 6 May 2010 18:56:46 +0000 (18:56 +0000)]
1. Support negation of an expression (except in a few cases where it
doesn't make sense, such as negation of a number or string).

2. Support HAVING clauses.  This isn't useful yet because we don't
support GROUP BY yet.

M    Open-ILS/include/openils/oils_buildq.h
M    Open-ILS/src/c-apps/oils_storedq.c
M    Open-ILS/src/c-apps/buildSQL.c

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

10 years agoAcq: lineitem + bib searches: form a metaclass query that works better
senator [Thu, 6 May 2010 18:42:43 +0000 (18:42 +0000)]
Acq: lineitem + bib searches: form a metaclass query that works better

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

10 years agoAcq: improvements to lineitem + bib search in unified search UI
senator [Thu, 6 May 2010 16:44:21 +0000 (16:44 +0000)]
Acq: improvements to lineitem + bib search in unified search UI

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

10 years agoadded batch lineitem fund updater from lineitem table ui
erickson [Thu, 6 May 2010 16:04:38 +0000 (16:04 +0000)]
added batch lineitem fund updater from lineitem table ui

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

10 years ago1. Add a boolean "negate" column to query.expression.
scottmk [Thu, 6 May 2010 16:00:37 +0000 (16:00 +0000)]
1. Add a boolean "negate" column to query.expression.

2. Remove the valid values 'xnbet' (for NOT BETWEEN), 'xnex' (for
NOT EXIST) and 'xnin' (for NOT IN) for the column query.expression.type.
We will represent those types with 'xbet', 'xnex', and 'xin',
respectively, combined with negate = TRUE.

3. Eliminate the updatable views defined for the valid values
removed above.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0252.schema.query-negation.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoadded links to LI and PO history pages
erickson [Thu, 6 May 2010 14:55:11 +0000 (14:55 +0000)]
added links to LI and PO history pages

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

10 years agosupport 905u (editor by barcode or usrname) in vandelay overlay/merge rules
miker [Wed, 5 May 2010 19:02:07 +0000 (19:02 +0000)]
support 905u (editor by barcode or usrname) in vandelay overlay/merge rules

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

10 years agodon't assume order date is set in invoice po_item rendering
erickson [Wed, 5 May 2010 17:45:07 +0000 (17:45 +0000)]
don't assume order date is set in invoice po_item rendering

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

10 years agoprevent trailing funk in po retrieve api call response by returning explicit undef
erickson [Wed, 5 May 2010 17:45:06 +0000 (17:45 +0000)]
prevent trailing funk in po retrieve api call response by returning explicit undef

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

10 years agoAcq: PO items i'face (acq.po_item is a peer of acq.lineitem for non-bib stuff)
senator [Tue, 4 May 2010 21:24:30 +0000 (21:24 +0000)]
Acq: PO items i'face (acq.po_item is a peer of acq.lineitem for non-bib stuff)

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

10 years agoarg ... even with topic branches, I still do stuff like this
miker [Tue, 4 May 2010 18:20:41 +0000 (18:20 +0000)]
arg ... even with topic branches, I still do stuff like this

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

10 years agocustom "splice" method, spelled subsetNL -- supplied dojo version is not happy; debug...
miker [Tue, 4 May 2010 18:06:47 +0000 (18:06 +0000)]
custom "splice" method, spelled subsetNL -- supplied dojo version is not happy; debugging aids; js error protection

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

10 years agouser_transaction_history methods
erickson [Tue, 4 May 2010 15:13:42 +0000 (15:13 +0000)]
user_transaction_history methods

Overhauled method registration for efficiency, extensibility and completeness.
There are two types of user_transaction_history SRF methods being declared:
authoritative and non-authoritative.  Each method also has an "ids" variant,
but the args are the same for all 12.

Signed-off-by: Joe Atzberger <atz@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16385 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agorepair SQL generation for ORed queries
miker [Tue, 4 May 2010 15:06:26 +0000 (15:06 +0000)]
repair SQL generation for ORed queries

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

10 years agoAcq: view vouchers from previously issued claims in LI/LID claim interface
senator [Mon, 3 May 2010 21:23:38 +0000 (21:23 +0000)]
Acq: view vouchers from previously issued claims in LI/LID claim interface

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

10 years agoupdated SIP server to pull item config info from the new circ_modifier table when...
erickson [Mon, 3 May 2010 19:00:31 +0000 (19:00 +0000)]
updated SIP server to pull item config info from the new circ_modifier table when legacy script support is disabled

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

10 years agoAcq: users can now claim individual copies from the LI copy table
senator [Mon, 3 May 2010 18:05:27 +0000 (18:05 +0000)]
Acq: users can now claim individual copies from the LI copy table

Also included, small bugfix to unified search (bug had caused atomic version
of the API call to include an extra, undesired result), and an improvement
to the decision to show or not show the "mark received" link on the LI copy
table.

Also made using the claiming dialog update the LI table to reflect the new
claims / changes in eligibility.

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

10 years agoPatron update docs
erickson [Mon, 3 May 2010 17:15:04 +0000 (17:15 +0000)]
Patron update docs

and a light dusting of perltidy.

Signed-off-by: Joe Atzberger <atz@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16379 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agofixed bug where updating the email address resulted in updating the username instead...
erickson [Mon, 3 May 2010 15:34:49 +0000 (15:34 +0000)]
fixed bug where updating the email address resulted in updating the username instead of the email address on the local copy of the user object in the opac.  this bug likely affected nothing.

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

10 years agoPaging options for user_transactions and user_transactions_history, plus refactored...
phasefx [Mon, 3 May 2010 14:39:28 +0000 (14:39 +0000)]
Paging options for user_transactions and user_transactions_history, plus refactored post-query grep filters into the query itself

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

10 years agoflesh hold notes in the holds retrieve call, being mindful of who is requesting the...
erickson [Mon, 3 May 2010 14:02:50 +0000 (14:02 +0000)]
flesh hold notes in the holds retrieve call, being mindful of who is requesting the hold and who can see staff/private notes

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

10 years agoadd the ability to run in sync mode; prevent use of cached unapi data; add the slot...
miker [Mon, 3 May 2010 01:03:25 +0000 (01:03 +0000)]
add the ability to run in sync mode; prevent use of cached unapi data; add the slot as a well-known param to format and value handlers

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

10 years agosub-object limiting (think: holdings); query limit/offset; new "templated" mode using...
miker [Mon, 3 May 2010 01:01:29 +0000 (01:01 +0000)]
sub-object limiting (think: holdings); query limit/offset; new "templated" mode using opac/template-value elements and dojo.string.substitute; org depth support in constructed tag URIs

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

10 years agoMoved the datatype lookups from the drones to the listener process.
scottmk [Sat, 1 May 2010 18:11:47 +0000 (18:11 +0000)]
Moved the datatype lookups from the drones to the listener process.

The cstore, rstore, and pcrud servers do dummy SELECT queries of all
the non-virtual classes in the IDL, in order to get datatypes for all
the non-virtual fields.

These lookups are time-consuming.  On my laptop they may take several
seconds.  On a system with various components running on separate
boxes, they may take longer due to the additional network latency.

Formerly these lookups were done by each drone process when it
initialized itself, resulting in an occasional hiccup of additional
response latency whenever the listener spawned another drone.

Now the parent process does the lookup once, before it spawns any
drones.  The drones inherit the resulting datatypes via the normal
fork operation, and never have to look up the datatypes themselves.

In order for this new arrangement to work, the oilsExtendIDL function
(which does the lookups) needs to receive a database connection as a
parameter, since the parent's connection is different from those of
the drones.

M    Open-ILS/include/openils/oils_sql.h
M    Open-ILS/src/c-apps/oils_pcrud.c
M    Open-ILS/src/c-apps/oils_rstore.c
M    Open-ILS/src/c-apps/oils_sql.c
M    Open-ILS/src/c-apps/oils_cstore.c

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

10 years agoOrg unit settings gui.disable_local_save_columns and url.remote_column_settings....
phasefx [Sat, 1 May 2010 09:57:46 +0000 (09:57 +0000)]
Org unit settings gui.disable_local_save_columns and url.remote_column_settings.  Respectively, these allow us to prevent the local saving and use of column settings, and allows us to specify column settings remotely.  If local settings are allowed and remote settings are also configured, then local settings will trump remote settings.  Currently these only work with xul lists, not dojo.  There is no UI for saving settings remotely; for now the notion is that an admin sets columns up locally, and then transfers the setting files to the remote server.

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

10 years agoDedicated interface for circ.staff_client.do_not_auto_attempt_print org unit setting...
phasefx [Sat, 1 May 2010 08:33:51 +0000 (08:33 +0000)]
Dedicated interface for circ.staff_client.do_not_auto_attempt_print org unit setting (given that the generic one does not handle settings of type array very well--particularly enumeration of allowed array values)

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

10 years agomake the Javascript Shell environment more closely resemble that of the xul interface...
phasefx [Sat, 1 May 2010 08:33:50 +0000 (08:33 +0000)]
make the Javascript Shell environment more closely resemble that of the xul interfaces (JSAN loaded, utility functions and constants loaded, and network and error objects pre-configured)

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

10 years agoreplace direct use of dojo.date in these xul interfaces with util.date wrapper
phasefx [Sat, 1 May 2010 05:42:41 +0000 (05:42 +0000)]
replace direct use of dojo.date in these xul interfaces with util.date wrapper

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

10 years agoAcq: Towards a working lineitems + bibs search, but still not really there
senator [Fri, 30 Apr 2010 21:17:57 +0000 (21:17 +0000)]
Acq: Towards a working lineitems + bibs search, but still not really there

At least these things still need done:
    1) Need to find out how to combine search terms correctly for the
        open-ils.search multiclass method.
    2) Need either to find out how to negate multiclass search terms or
        to disable not- based searching for lineitem+bib
    3) Need to make uploaded file-of-terms work.

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

10 years agoadded support for update the fund on an LID after the debits have been created. ...
erickson [Fri, 30 Apr 2010 20:49:28 +0000 (20:49 +0000)]
added support for update the fund on an LID after the debits have been created.  added a .dry_run version of open-ils.acq.lineitem_detail.cud.batch[.dry_run] to allow the caller to check the fund warning percents

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

10 years agoUse the oilsConnectDB function to connect to the database, instead
scottmk [Fri, 30 Apr 2010 20:39:29 +0000 (20:39 +0000)]
Use the oilsConnectDB function to connect to the database, instead
of using replicated code.

M    Open-ILS/src/c-apps/oils_pcrud.c
M    Open-ILS/src/c-apps/oils_rstore.c
M    Open-ILS/src/c-apps/oils_cstore.c

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

10 years agoGive event definition a proper id (23)
erickson [Fri, 30 Apr 2010 16:34:33 +0000 (16:34 +0000)]
Give event definition a proper id (23)

Signed-off-by: Joe Atzberger <atz@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@16362 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoAdded global_flag and support for using the internal record
erickson [Fri, 30 Apr 2010 15:43:10 +0000 (15:43 +0000)]
Added global_flag and support for using the internal record
identifier as the tcn_value for newly imported records
TODO: add support to vandelay stored import procedures

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

10 years agorepaired syntax error in db schema / upgrade script
erickson [Fri, 30 Apr 2010 14:52:04 +0000 (14:52 +0000)]
repaired syntax error in db schema / upgrade script

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

10 years agoadd table and IDL class for global flags/settings. the value column is text, may...
miker [Fri, 30 Apr 2010 14:43:40 +0000 (14:43 +0000)]
add table and IDL class for global flags/settings.  the value column is text, may be semantically upgraded to JSON in the future

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

10 years agobreak the main registration table out to a separate template to ease the process...
erickson [Fri, 30 Apr 2010 14:40:33 +0000 (14:40 +0000)]
break the main registration table out to a separate template to ease the process of locally overriding the field order

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

10 years ago1. When a class name is available instead of a table/view name,
scottmk [Fri, 30 Apr 2010 01:52:37 +0000 (01:52 +0000)]
1. When a class name is available instead of a table/view name,
look up the class in the IDL to get a table name, view name, or
(in parentheses) a source definition in the form of a subquery.

2. Rename buildQuery() to build_Query() in order to avoid a
name collision.

M    Open-ILS/src/c-apps/buildSQL.c

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

10 years agoThe associated behavior for the cat.bib.delete_on_no_copy_via_acq_lineitem_cancel...
phasefx [Thu, 29 Apr 2010 22:07:17 +0000 (22:07 +0000)]
The associated behavior for the cat.bib.delete_on_no_copy_via_acq_lineitem_cancel org unit setting.

I notice the "alert on empty" setting does not seem to work with bib deletion via lineitem cancel

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

10 years agoAcq: unified search UI changes for lineitems + bibs search. No ML support yet.
senator [Thu, 29 Apr 2010 21:20:39 +0000 (21:20 +0000)]
Acq: unified search UI changes for lineitems + bibs search. No ML support yet.

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

10 years agoorg unit setting for "Delete bib if all copies are deleted via Acquisitions lineitem...
phasefx [Thu, 29 Apr 2010 20:34:02 +0000 (20:34 +0000)]
org unit setting for "Delete bib if all copies are deleted via Acquisitions lineitem cancellation."

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

10 years agoSubsequent EDI patch from Joe Atzberger. In this installmanent, EDI really does...
erickson [Thu, 29 Apr 2010 20:28:36 +0000 (20:28 +0000)]
Subsequent EDI patch from Joe Atzberger.  In this installmanent, EDI really does some stuff.  Also included are a number of test scripts and some mild code cleanup

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

10 years agoforward-ported the functionality for use-last-4-of-phone-as-default-password based...
erickson [Thu, 29 Apr 2010 19:59:45 +0000 (19:59 +0000)]
forward-ported the functionality for use-last-4-of-phone-as-default-password based on org setting

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

10 years ago1. Renamed function getRelation to oilsGetRelation.
scottmk [Thu, 29 Apr 2010 19:02:50 +0000 (19:02 +0000)]
1. Renamed function getRelation to oilsGetRelation.

2. Made oilsGetRelation() globally scoped so that qstore
can call it.

3. Renamed its formal parameter from "class" to "classdef",
since "class" is a reserved word in C++.  That can create
problems if the header file is #included in a C++ program.

4. Added a doxygen-style comment along the way.

M    Open-ILS/include/openils/oils_sql.h
M    Open-ILS/src/c-apps/oils_sql.c

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

10 years agoReturn of the top-level Help menu, with a context sensitive For Active Tab menu entry.
phasefx [Thu, 29 Apr 2010 18:45:39 +0000 (18:45 +0000)]
Return of the top-level Help menu, with a context sensitive For Active Tab menu entry.

So now every interface has a help option, though more work can still be done for interfaces containing sub-interfaces (I've reworked the OPAC wrapper here, but Patron Display / Patron Search could still use some love).

We'll also want to give thought to adding Help widgets to any popup dialogs.

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

10 years agoutility methods for deck class
phasefx [Thu, 29 Apr 2010 18:45:38 +0000 (18:45 +0000)]
utility methods for deck class

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

10 years agodebugging aid
phasefx [Thu, 29 Apr 2010 18:45:37 +0000 (18:45 +0000)]
debugging aid

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

10 years agoload menu.js before JSAN gets a chance too, so we can have better error reporting...
phasefx [Thu, 29 Apr 2010 18:45:37 +0000 (18:45 +0000)]
load menu.js before JSAN gets a chance too, so we can have better error reporting (with correct line numbers)

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

10 years agoImplement .columns method of qstore server, to return a list
scottmk [Thu, 29 Apr 2010 16:55:04 +0000 (16:55 +0000)]
Implement .columns method of qstore server, to return a list
of column names.

Also: add several doxygen-style comments to oils_storedq.c.

M    Open-ILS/include/openils/oils_buildq.h
M    Open-ILS/src/c-apps/oils_qstore.c
M    Open-ILS/src/c-apps/oils_storedq.c

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

10 years agoadded support for selecting merge/overlay options during import of already queued...
erickson [Thu, 29 Apr 2010 15:53:35 +0000 (15:53 +0000)]
added support for selecting merge/overlay options during import of already queued records, same as main upload page

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

10 years agoadded paging to user picklist retrieval/display
erickson [Thu, 29 Apr 2010 15:14:20 +0000 (15:14 +0000)]
added paging to user picklist retrieval/display

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

10 years agoafter a record has been successfully imported via vandelay in the stream importer...
erickson [Thu, 29 Apr 2010 14:17:20 +0000 (14:17 +0000)]
after a record has been successfully imported via vandelay in the stream importer, remove the record from the bib queue to prevent bloat

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

10 years agoGive the stream_results versions of vandelay item spooling the ability to, like,...
erickson [Thu, 29 Apr 2010 14:17:19 +0000 (14:17 +0000)]
Give the stream_results versions of vandelay item spooling the ability to, like, you know, stream

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

10 years agoadded pcrud entries for po_items, repaired pcrud entries for po notes
erickson [Wed, 28 Apr 2010 21:48:21 +0000 (21:48 +0000)]
added pcrud entries for po_items, repaired pcrud entries for po notes
added logic to create invoice_item's from po_item's.
added po_item fund debit creation on po activation
added po_items to po money summary
added support for handling po_item debits during invoiceing.
showing po_item estimated cost summary data in invoice table

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

10 years agoAdd po_item column to auditor.acq_invoice_item_history.
scottmk [Wed, 28 Apr 2010 21:28:45 +0000 (21:28 +0000)]
Add po_item column to auditor.acq_invoice_item_history.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0244.schema.acq-inv-item-hist-po-item.sql

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

10 years agoCreate a reusable function for connecting to the database.
scottmk [Wed, 28 Apr 2010 21:11:54 +0000 (21:11 +0000)]
Create a reusable function for connecting to the database.
Use it in qstore (others to follow).

M    Open-ILS/include/openils/oils_sql.h
M    Open-ILS/src/c-apps/oils_qstore.c
M    Open-ILS/src/c-apps/oils_sql.c

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

10 years agoAdd a po_item column, pointing to acq.po_item, to acq.invoice_item.
scottmk [Wed, 28 Apr 2010 19:28:45 +0000 (19:28 +0000)]
Add a po_item column, pointing to acq.po_item, to acq.invoice_item.

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/0243.schema.acq-inv-item-po-item.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years ago1. Implement a messages method to return a list of previously
scottmk [Wed, 28 Apr 2010 18:34:23 +0000 (18:34 +0000)]
1. Implement a messages method to return a list of previously
generated error messages.

2. Comment out some code that looked up datatype for all the
non-virtual fields in the IDL.  This time-consuming step serves
no purpose in qstore, and likely never will.

3. Added some more qstore-style comments.

M    Open-ILS/src/c-apps/oils_qstore.c

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

10 years agowhen a LI points to a PO, show the LI as a link in the lineitem summary blob
erickson [Wed, 28 Apr 2010 15:39:50 +0000 (15:39 +0000)]
when a LI points to a PO, show the LI as a link in the lineitem summary blob

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

10 years agoEliminated the oilsExecSql function as a relic of an earlier design.
scottmk [Wed, 28 Apr 2010 15:31:46 +0000 (15:31 +0000)]
Eliminated the oilsExecSql function as a relic of an earlier design.

Also: added some doxygen-style comments.

M    Open-ILS/include/openils/oils_buildq.h
M    Open-ILS/src/c-apps/oils_execsql.c

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

10 years agoLoosened some restrictions on invoicing. It is now possible to invoice
erickson [Wed, 28 Apr 2010 15:24:31 +0000 (15:24 +0000)]
Loosened some restrictions on invoicing.  It is now possible to invoice
items that have not yet been received.  It is also possible to invoice
for cancelled items, assuming the debit for the cancelled item remains.

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

10 years agoAdd keep_debits column to acq.cancel_reason.
scottmk [Wed, 28 Apr 2010 14:41:03 +0000 (14:41 +0000)]
Add keep_debits column to acq.cancel_reason.

Add a row for delivered_but_lost, with keep_debits = TRUE.

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/0242.schema.acq-cancel-reason-keep-debits.sql
M    Open-ILS/src/sql/Pg/950.data.seed-values.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoinit the printer in the new selfcheck UI
erickson [Wed, 28 Apr 2010 13:02:28 +0000 (13:02 +0000)]
init the printer in the new selfcheck UI

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

10 years agoImplement .execute method of qstore server.
scottmk [Wed, 28 Apr 2010 03:41:56 +0000 (03:41 +0000)]
Implement .execute method of qstore server.

M    Open-ILS/include/openils/oils_buildq.h
M    Open-ILS/src/c-apps/oils_qstore.c
M    Open-ILS/src/c-apps/Makefile.am
A    Open-ILS/src/c-apps/oils_execsql.c

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

10 years agoBring the password reset interface to the Craftsman skin
dbs [Tue, 27 Apr 2010 22:00:28 +0000 (22:00 +0000)]
Bring the password reset interface to the Craftsman skin

Along the way, we make the placement slightly less hard-coded so that we
can better support custom skins that might not match default - although
we're still assuming that the login box will be a table with a tbody, you
can use the config.ids.login.tbody variable to point at the ID you care
about for your skin.

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

10 years agoImprove password reset form usability
dbs [Tue, 27 Apr 2010 20:31:05 +0000 (20:31 +0000)]
Improve password reset form usability

Clean up after ourselves by clearing the values of the barcode / username
text fields if the user hits Cancel or submits a request that was handled
by the backend service.

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

10 years agoAcq: Find PO from which copy originated
senator [Tue, 27 Apr 2010 16:57:39 +0000 (16:57 +0000)]
Acq: Find PO from which copy originated

In the Item Status staff client interface there is now a new menu option that
will look for a PO from which a given item originated.

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

10 years agoAdded support to invoice page for adding extra copies to an invoice than
erickson [Tue, 27 Apr 2010 16:53:33 +0000 (16:53 +0000)]
Added support to invoice page for adding extra copies to an invoice than
were ordered.  The process creates new lineitem details and fund debits
to accommodate the new copies.
Fixed some typos
TODO: update the li summary blob to treat the li title/author as a link
to the details page for the lineitem

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

10 years agoAdd acq.po_item table.
scottmk [Tue, 27 Apr 2010 16:23:19 +0000 (16:23 +0000)]
Add acq.po_item table.

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/0241.schema.acq-po-item.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoensure order date is non-null before formatting
erickson [Tue, 27 Apr 2010 12:46:51 +0000 (12:46 +0000)]
ensure order date is non-null before formatting

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

10 years agoreplace lingering date substring kludges with util.date/dojo.locale. In some places...
phasefx [Mon, 26 Apr 2010 21:42:45 +0000 (21:42 +0000)]
replace lingering date substring kludges with util.date/dojo.locale.  In some places (like due dates) I'm letting the whole timestamp show where before we were showing just the date

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

10 years agoIDL:
erickson [Mon, 26 Apr 2010 20:51:39 +0000 (20:51 +0000)]
IDL:
added pcrud <retrieve> entry for acq selection list.
added selector columns to PL and PO.
removed now-virtual item_count column from acq.acq_lineitem_history
repaired faulty pcrud actions stanza for acq po

AutoGrid
added a readOnly edit mode to AutoGrid.  this will allow users to pop up the edit dialog for copy/paste, since it is not (currently) possible to copy values directly from a dojo grid

new UIs
added a lineitem history ui which shows the audit values from a given lineitem
added a po history ui which shows the audit values from a given po

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

10 years agowire org unit settings for date/time formatting into util.date library
phasefx [Mon, 26 Apr 2010 20:36:57 +0000 (20:36 +0000)]
wire org unit settings for date/time formatting into util.date library

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

10 years agoAcq: invoices are now printable from search results
senator [Mon, 26 Apr 2010 19:58:03 +0000 (19:58 +0000)]
Acq: invoices are now printable from search results

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

10 years agothinko on using cleared fund debit id
erickson [Mon, 26 Apr 2010 19:47:47 +0000 (19:47 +0000)]
thinko on using cleared fund debit id

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

10 years agoin acq, when an LID is canceled, make sure the encumbrance is removed as well
erickson [Mon, 26 Apr 2010 19:18:17 +0000 (19:18 +0000)]
in acq, when an LID is canceled, make sure the encumbrance is removed as well

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

10 years agobulked up docs for the record copy-count calls. removed unused format specifier
erickson [Mon, 26 Apr 2010 18:31:06 +0000 (18:31 +0000)]
bulked up docs for the record copy-count calls.  removed unused format specifier

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

10 years agoorg unit settings for formatting displayed date and time values
phasefx [Mon, 26 Apr 2010 18:17:17 +0000 (18:17 +0000)]
org unit settings for formatting displayed date and time values

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

10 years agoAdded API call to return the total hold count for titles and metarecords
erickson [Mon, 26 Apr 2010 18:14:31 +0000 (18:14 +0000)]
Added API call to return the total hold count for titles and metarecords

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

10 years agoThere is no template for printing patron lists. Quick fix until we replace those...
phasefx [Mon, 26 Apr 2010 17:14:44 +0000 (17:14 +0000)]
There is no template for printing patron lists.  Quick fix until we replace those actions with standard List actions

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

10 years agoDon't rely on the sequence like this, using xact_start to find preceding circ renewal...
phasefx [Mon, 26 Apr 2010 16:21:45 +0000 (16:21 +0000)]
Don't rely on the sequence like this, using xact_start to find preceding circ renewal chain

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