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
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
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.
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
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
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.
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
projects / working / Evergreen.git / log