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
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
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
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
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.
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
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.
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
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
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.
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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.
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)
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)
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.
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