working/Evergreen.git
10 years agoAdd column avg_wait_time to config.circ_modifier.
scottmk [Fri, 21 May 2010 16:32:00 +0000 (16:32 +0000)]
Add column avg_wait_time to config.circ_modifier.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0273.schema.config-circ-mod-avg-wait.sql
M    Open-ILS/src/sql/Pg/100.circ_matrix.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoremove errant tsearch joiners if the normalizers are messy and leave leading/trailing...
miker [Fri, 21 May 2010 15:52:42 +0000 (15:52 +0000)]
remove errant tsearch joiners if the normalizers are messy and leave leading/trailing spaces

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

10 years agoadd identifier FTS config (assumed to exist in some places)
miker [Fri, 21 May 2010 15:46:30 +0000 (15:46 +0000)]
add identifier FTS config (assumed to exist in some places)

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

10 years agouse proper JSON, re ' vs "
miker [Fri, 21 May 2010 15:24:39 +0000 (15:24 +0000)]
use proper JSON, re ' vs "

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

10 years agohide the out-of-sync, non-xul dojo menu in the html pages. we don't want it showing...
erickson [Fri, 21 May 2010 15:09:13 +0000 (15:09 +0000)]
hide the out-of-sync, non-xul dojo menu in the html pages.  we don't want it showing up in the self-check UI or any oter public UIs built from templates

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

10 years agoSupport IS NULL and IS NOT NULL expressions.
scottmk [Fri, 21 May 2010 14:00:03 +0000 (14:00 +0000)]
Support IS NULL and IS NOT NULL expressions.

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@16470 dcc99617-32d9-48b4-a31d-7c20da2025e4

10 years agoFixing a typo in the previous changeset (a missing comma that led to
scottmk [Fri, 21 May 2010 13:04:16 +0000 (13:04 +0000)]
Fixing a typo in the previous changeset (a missing comma that led to
nonsense instead of an obvious error).

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/0270.schema.query-xisnull-correction.sql

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

10 years agoallow caller to define the sort field/direction in PL retrieval call. by default...
erickson [Fri, 21 May 2010 13:02:19 +0000 (13:02 +0000)]
allow caller to define the sort field/direction in PL retrieval call.  by default, sort most recently edited PLs to the front

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

10 years agoPO virtual lineitem_count field is an int, not a link
erickson [Fri, 21 May 2010 13:02:18 +0000 (13:02 +0000)]
PO virtual lineitem_count field is an int, not a link

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

10 years agoCreate database support for IS [NOT] NULL expressions
scottmk [Thu, 20 May 2010 20:35:12 +0000 (20:35 +0000)]
Create database support for IS [NOT] NULL expressions
in stored queries.

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/0269.schema.query-xisnull.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoAcq: correct a mistake in r16464
senator [Thu, 20 May 2010 16:01:51 +0000 (16:01 +0000)]
Acq: correct a mistake in r16464

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

10 years agoAcq: fix unified search for not-null boolean fields
senator [Thu, 20 May 2010 15:47:55 +0000 (15:47 +0000)]
Acq: fix unified search for not-null boolean fields

The unified search UI produces a checkbox for these fields, but it did not
build a search query from checkboxes correctly.

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

10 years agoloosen the restrictions on exporting holdings / price data from uploaded records...
erickson [Thu, 20 May 2010 14:10:47 +0000 (14:10 +0000)]
loosen the restrictions on exporting holdings / price data from uploaded records.  It's no longer necessary to set every field in the holdings data just to import.  if no quantity is defined, go ahead and pull the estimed price data (when present) to link it with the lineitem

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

10 years agoDon't assume an explicit print strategy has been set here
phasefx [Thu, 20 May 2010 05:21:39 +0000 (05:21 +0000)]
Don't assume an explicit print strategy has been set here

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

10 years ago* I18N for print admin interface
phasefx [Thu, 20 May 2010 04:55:40 +0000 (04:55 +0000)]
* I18N for print admin interface
* custom/external print strategy (where you dictate an external command and feed it %receipt.txt% and/or %receipt.html%)
* DOS LPT1 Print strategy preserved as a legacy option, but without serving double-duty with the external linux commands
* label printing now honors plain text print strategies, but we're still stuck with system defaults for print dialogs
* @hex attribute for generating control characters when using HTML in templates being rendered with plain text print strategies

  For example, <p hex="0C">Hello World</p> will transform into form feed + Hello World if used with DOS LPT1 Print or with the
  %receipt.txt% macro for the Custom/External Print strategy.  <p>Hello World</p hex="0C"> will yield Hello World + form feed.

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

10 years agoset persisted settings before generating labels on page load
phasefx [Thu, 20 May 2010 04:54:15 +0000 (04:54 +0000)]
set persisted settings before generating labels on page load

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

10 years agorework these column definitions for pre-cats, since all rows in the list are getting...
phasefx [Thu, 20 May 2010 04:54:11 +0000 (04:54 +0000)]
rework these column definitions for pre-cats, since all rows in the list are getting mvr objects now

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

10 years agochange this id to avoid a collision when patron and circ columns are combined in...
phasefx [Thu, 20 May 2010 04:54:03 +0000 (04:54 +0000)]
change this id to avoid a collision when patron and circ columns are combined in one list (such as with the Check-In interface)

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

10 years agologic error, ensure that the "first_pre" print CSS class only occurs once per batch
phasefx [Thu, 20 May 2010 04:53:56 +0000 (04:53 +0000)]
logic error, ensure that the "first_pre" print CSS class only occurs once per batch

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

10 years agoadd magic debug controls to chrome interfaces
phasefx [Thu, 20 May 2010 04:53:50 +0000 (04:53 +0000)]
add magic debug controls to chrome interfaces

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

10 years agoImplement new param_list method, which returns a list of
scottmk [Thu, 20 May 2010 01:25:15 +0000 (01:25 +0000)]
Implement new param_list method, which returns a list of
bind variables so that the client can populate them.

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

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

10 years agoImplement open-ils.qstore.bind_param method, which applies actual
scottmk [Wed, 19 May 2010 19:37:05 +0000 (19:37 +0000)]
Implement open-ils.qstore.bind_param method, which applies actual
values to bind variables (overriding default values, if any).

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

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

10 years agomake the first_word index normalizer return a not-null value when given an empty...
miker [Wed, 19 May 2010 19:24:48 +0000 (19:24 +0000)]
make the first_word index normalizer return a not-null value when given an empty string; remove naco and date normalizers from all identifier fields

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

10 years agoadd ISBN 10/13 index normalizer (requires ISN postgres contrib module); adjust index...
miker [Wed, 19 May 2010 18:54:25 +0000 (18:54 +0000)]
add ISBN 10/13 index normalizer (requires ISN postgres contrib module); adjust index definition xpath so it actually works; generalize indexing trigger function so it does not have to know about search classes before hand

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

10 years agoMake sure that all bind variables have been assigned values
scottmk [Wed, 19 May 2010 14:11:29 +0000 (14:11 +0000)]
Make sure that all bind variables have been assigned values
before trying to execute a query.

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

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

10 years agoAdd partial support for bind variables: load them from the
scottmk [Wed, 19 May 2010 12:46:18 +0000 (12:46 +0000)]
Add partial support for bind variables: load them from the
database, and use default values if available.  There is no
mechanism yet to override the defaults.

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

10 years agoFix a typo in a previous commit to the acq schema. The upgrade script was
scottmk [Tue, 18 May 2010 20:12:38 +0000 (20:12 +0000)]
Fix a typo in a previous commit to the acq schema.  The upgrade script was
correct, but this upgrade script will fix a database table that was built
from the installation script, which was wrong.

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/0266.schema.acq-fix-edi-message-check.sql

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

10 years agoidentifier search class, including some (I believe) sane default index defs
miker [Tue, 18 May 2010 19:10:07 +0000 (19:10 +0000)]
identifier search class, including some (I believe) sane default index defs

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

10 years agoAcq: don't check claim eligibility on pseudo-LIs generated in title search
senator [Tue, 18 May 2010 16:53:33 +0000 (16:53 +0000)]
Acq: don't check claim eligibility on pseudo-LIs generated in title search

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

10 years agoAcq: back/next result paging through unified search interfaces
senator [Mon, 17 May 2010 21:33:46 +0000 (21:33 +0000)]
Acq: back/next result paging through unified search interfaces

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

10 years agoadded selector column for edi_account; added edi messages page for POs; allow editpan...
erickson [Mon, 17 May 2010 20:50:52 +0000 (20:50 +0000)]
added selector column for edi_account; added edi messages page for POs; allow editpane cancel button to show when in readOnly mode

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

10 years agodon't assume an autofieldwidget cached linked object list contains the linked object...
erickson [Mon, 17 May 2010 19:57:04 +0000 (19:57 +0000)]
don't assume an autofieldwidget cached linked object list contains the linked object in question.  it may have been filtered out of the original list

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

10 years agobetter handling of mingling readOnly and non-readOnly widgets during copy update...
erickson [Mon, 17 May 2010 19:57:03 +0000 (19:57 +0000)]
better handling of mingling readOnly and non-readOnly widgets during copy update in lineitem table

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

10 years agoadded support for redelivery of 'retry' edi_messages. added support for filting...
erickson [Mon, 17 May 2010 17:08:26 +0000 (17:08 +0000)]
added support for redelivery of 'retry' edi_messages.   added support for filting on ORDERS message types

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

10 years agoTwo changes to acq.edi_message:
scottmk [Mon, 17 May 2010 16:47:32 +0000 (16:47 +0000)]
Two changes to acq.edi_message:

1. New "message_type" column.

2. New valid value for status column: 'retry'.

-- WARNING: because the new column is NOT NULL, this upgrade script must
-- initialize it with something if the table is not empty.  The initial
-- value, 'ORDERS', may not always be appropriate.  Massage as needed.

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/0264.schema.acq-edi-message-type.sql
M    Open-ILS/examples/fm_IDL.xml

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

10 years agoSpotted minor typos while reading up on the new addition.
dbs [Sun, 16 May 2010 21:01:28 +0000 (21:01 +0000)]
Spotted minor typos while reading up on the new addition.

miker++ # looks like a promising direction!

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

10 years agoOptional pgmemcache-based caching of permission checks. Significantly speeds permiss...
miker [Sun, 16 May 2010 20:19:09 +0000 (20:19 +0000)]
Optional pgmemcache-based caching of permission checks.  Significantly speeds permission testing for common checks against heavy-use users, such as circulation-related permissions.

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

10 years agoallow multiple 260 tags in summary view
miker [Sun, 16 May 2010 19:16:42 +0000 (19:16 +0000)]
allow multiple 260 tags in summary view

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

10 years agoshow progress indicator in autogrid with next/prev in piclist list page
erickson [Fri, 14 May 2010 16:10:26 +0000 (16:10 +0000)]
show progress indicator in autogrid with next/prev in piclist list page

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

10 years agonodeValue not working to find source def sql in the IDL. at least, not with xulrunne...
erickson [Thu, 13 May 2010 21:31:57 +0000 (21:31 +0000)]
nodeValue not working to find source def sql in the IDL.  at least, not with xulrunner-1.9.  textContent works

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

10 years agorepaired some IDL typos w/ hold/copy ration view
erickson [Thu, 13 May 2010 21:31:56 +0000 (21:31 +0000)]
repaired some IDL typos w/ hold/copy ration view

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

10 years agoAcq: the XULTermLoader dijit now returns the first columns of CSV rows
senator [Thu, 13 May 2010 21:07:16 +0000 (21:07 +0000)]
Acq: the XULTermLoader dijit now returns the first columns of CSV rows

Could be improved later to allow more control over what data you get back,
but it works fine for the current uses (reading a file of one-term-per-line
for unified search and reading a CSV file where the first column is of
interest in the Bib record->lineitem interface).

Also added a little support to the LI table/pager for remember what lineitems
are selected even after you move on to the next page.  Nothing really takes
full advantage of this yet, though.

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

10 years agofix column name
phasefx [Thu, 13 May 2010 20:19:02 +0000 (20:19 +0000)]
fix column name

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

10 years agofix syntax
phasefx [Thu, 13 May 2010 20:13:08 +0000 (20:13 +0000)]
fix syntax

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

10 years agouse estimed_unit_price directly on the lineitem in JEDI creation. strip protocol...
erickson [Thu, 13 May 2010 19:05:09 +0000 (19:05 +0000)]
use estimed_unit_price directly on the lineitem in JEDI creation.  strip protocol/port info from the edi account host before attempting remote delivery.  more strict check of successfull login for RemoteAccount

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

10 years agoteach the overlay functions about data matching REs; add a template-based merge inste...
miker [Thu, 13 May 2010 16:44:14 +0000 (16:44 +0000)]
teach the overlay functions about data matching REs; add a template-based merge instead of requiring a vandelay record, and use that for bib merging; minor logic collapsing

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

10 years agofixed some typos, thinkos in EDI cross-walk
erickson [Thu, 13 May 2010 15:20:36 +0000 (15:20 +0000)]
fixed some typos, thinkos in EDI cross-walk

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

10 years agoAcq: two bug fixes
senator [Thu, 13 May 2010 15:02:58 +0000 (15:02 +0000)]
Acq: two bug fixes

1) a bug recently introduced in unified search would try to build the catalog
search query more often than needed (and fail at it)
2) there was a colliding accesskey in staff client acquisitions menu

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

10 years agomoved to generic acqpo.activate hook instead of the format.po.jedi hook
erickson [Thu, 13 May 2010 14:23:14 +0000 (14:23 +0000)]
moved to generic acqpo.activate hook instead of the format.po.jedi hook
added validator to determine of a PO should create JEDI
added JEDI creation reactor.  it behaves like ProcessTemplate, but gives
us something more specific to filter acqpo.activate events on
update PO JEDI reactor to use new hook and reactor
update the edi_pusher to filter out events for PO's that have already
been processed

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

10 years agoAcq: import file of bib IDs, get paginated LI table from which make new orders
senator [Wed, 12 May 2010 22:14:49 +0000 (22:14 +0000)]
Acq: import file of bib IDs, get paginated LI table from which make new orders

This is most of the way to being usable, but isn't all there,
as it probably still needs:
1) trivial parsing of the input file so that we can look for a
specific column in a CSV file to treat as a bib ID instead of a whole line,
2) a way to select and act on lineitems not currently displayed on the page

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

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