scottmk [Fri, 4 Dec 2009 16:02:03 +0000 (16:02 +0000)]
Add a bunch of updatable view to the query schema, for
representing various subsets of expressions.
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/0107.schema.query-updatable_views.sql
M Open-ILS/examples/fm_IDL.xml
miker [Fri, 4 Dec 2009 15:37:19 +0000 (15:37 +0000)]
Patch from Lebbeous Fogle-Weekley which implements the configuration interfaces required
to support bookable resources, including the addition of cataloged materials as bookable
items. Thus spake Lebbeous:
Here it is at last. The only entry point (for now) to these interfaces
besides the "admin" menu is in the holdings maintenance / copy browser
context menu. There you can select items and create bookable resources
out of them (basically), and upon that creation you get a new tab open
in the staff client where you could further edit (in a basic, conify
way) that resource.
dbs [Fri, 4 Dec 2009 03:09:24 +0000 (03:09 +0000)]
Hack: create symbolic links with names demanded by Translate Toolkit
GNU gettext recommended layout is foo.dtd/ll.po, where "ll" represents
the locale of the translated resource.
But Translate Toolkit doesn't offer any command line flags to tell it
what kind of file it's supposed to generate; it relies on the filename:
The file extension of the original Mozilla file is required to tell the
Toolkit how to do the conversion. Therefore, a file like foo.dtd must be
named foo.dtd.po in order to po2moz to recognise it as a DTD file.
miker [Thu, 3 Dec 2009 21:29:05 +0000 (21:29 +0000)]
integrate the new booking.reservation billable transaction table with all the parts that use grocery transactions, including in the materialized summary view
scottmk [Thu, 3 Dec 2009 16:23:34 +0000 (16:23 +0000)]
Add updatable view query.expr_string.
Change a datatype in query.record_column.
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/0104.schema.query-expr-string.sql
M Open-ILS/examples/fm_IDL.xml
erickson [Thu, 3 Dec 2009 15:40:16 +0000 (15:40 +0000)]
add some default event def granularities. when an override widget is defined, still try to set the value of the widget based on the object being edited
phasefx [Wed, 2 Dec 2009 23:39:35 +0000 (23:39 +0000)]
merge from my offline repo. Toward a billing interface replacement. Other things including a hopeful fix for a dojo.require race condition in util/date.js
erickson [Wed, 2 Dec 2009 18:31:01 +0000 (18:31 +0000)]
implemented items out page. made printing of top-level receipt optional. trimmed nav links to only include links that are not already available elsewhere.
erickson [Wed, 2 Dec 2009 14:35:05 +0000 (14:35 +0000)]
added stored proc to take a circ and determine the full chain of associated circs and companion proc to summarize the chain. added fm class accs for action::circ_chain_summary. add ML method to turn the stored proc output into FM objects. added unrecoverd field to action.circulation since it was missing
scottmk [Mon, 30 Nov 2009 20:35:11 +0000 (20:35 +0000)]
Create a schema named "query" instead of "sql" (which is a
reserved word).
Note that two previous upgrade scripts are being changed. If you have
already run them, you can run them again after manually deleting two
entries from config.upgrade.log:
DELETE FROM config.upgrade.log
WHERE version in ( '0097', '0098' );
The 0097.schema.sql-datatype.sql will drop the misbegotten sql
schema if it exists.
A Pg/008.schema.query.sql
M Pg/upgrade/0098.schema.sql-stored-query.sql
M Pg/upgrade/0097.schema.sql-datatype.sql
D Pg/008.schema.sql.sql
scottmk [Mon, 30 Nov 2009 17:51:05 +0000 (17:51 +0000)]
Create a new schema "sql" to represent stored queries.
Note: the 008.schema.sql.sql file defines the entire schema,
except for updatable views (which will be defined later).
However the upgrade file 0097.schema.sql-datatype.sql
only adds four tables; likewise for the update to fm_IDL.xml.
The other tables will be added in due course, but in the
meanwhile there will be some tables defined in the schema
file that haven't been added yet by the upgrades.
M Open-ILS/src/sql/Pg/002.schema.config.sql
A Open-ILS/src/sql/Pg/upgrade/0097.schema.sql-datatype.sql
A Open-ILS/src/sql/Pg/008.schema.sql.sql
M Open-ILS/examples/fm_IDL.xml
miker [Thu, 26 Nov 2009 02:09:09 +0000 (02:09 +0000)]
DB and middle layer implementation of floating items -- no UI yet.
asset.copy gets a new BOOL column, floating, that when set to true causes
the circ_lib for that copy to be set to the check-in location if it would
otherwise be transited elsewhere simply to be reshelved.
djfiander [Wed, 25 Nov 2009 22:44:34 +0000 (22:44 +0000)]
CHANGES
. Added more comments
. Removed OpenSRF dependency entirely
. Added compressed_to_last() method
. Added setter functionality to is_compressed() method (needed for compressed_to_last())
. Replaced hardcoded 'Note:' with double-dash (should we consider some basic template support?)
. Fixed a few small bugs and typos
================================================
Developer's Certificate of Origin 1.1
By making a contribution to this project, I certify that:
(a) The contribution was created in whole or in part by me and I
have the right to submit it under the open source license
indicated in the file; or
(b) The contribution is based upon previous work that, to the best
of my knowledge, is covered under an appropriate open source
license and I have the right under that license to submit that
work with modifications, whether created in whole or in part
by me, under the same open source license (unless I am
permitted to submit under a different license), as indicated
in the file; or
(c) The contribution was provided directly to me by some other
person who certified (a), (b) or (c) and I have not modified
it.
(d) I understand and agree that this project and the contribution
are public and that a record of the contribution (including all
personal information I submit with it, including my sign-off) is
maintained indefinitely and may be redistributed consistent with
this project or the open source license(s) involved.
Signed-off-by: Dan Wells <dbw2@calvin.edu>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@15033 dcc99617-32d9-48b4-a31d-7c20da2025e4
erickson [Wed, 25 Nov 2009 21:38:37 +0000 (21:38 +0000)]
Added sample self-checkout checkout receipt
added generic (public/perm-checkin) circ event runner
Added 'g' qualifier to event path-fleshing method name munging
Added explicit exception when environment path is not valid
Added virtual hours_of_operation field for org units
miker [Wed, 25 Nov 2009 18:07:13 +0000 (18:07 +0000)]
Adding support for an opaque user_data field on Action/Trigger events:
* New column on action_trigger.event and fieldmapper field (user_data) to hold json-encoded data blob
* New optional param to event creation calls to pass said data blob
(related, added a granularity param to targeted event creator -- pass undef in that position to ignore def granularity, as before)
* New grouped event environment array, called user_data, carrying the peer user_data fields to target and event
* New grouped event method, environment.EventProcessor.findEvent(), for grabbing a specific Event instance (fully fleshed)
scottmk [Wed, 25 Nov 2009 16:49:13 +0000 (16:49 +0000)]
Replace all calls to the old JSON parser with calls
to the new one.
M Open-ILS/src/c-apps/oils_cstore.c
M Open-ILS/src/c-apps/oils_dataloader.c
M Open-ILS/src/c-apps/oils_utils.c
M Open-ILS/src/c-apps/oils_auth.c
M Open-ILS/src/extras/oils_requestor.c
erickson [Tue, 24 Nov 2009 22:45:22 +0000 (22:45 +0000)]
plugged in audio alerts for selfcheck. local config is managed by TT path overriding. at least until there's a need to make it fancier. TODO: add the org setting that turns on audio alerts for selfcheck
erickson [Mon, 23 Nov 2009 20:50:40 +0000 (20:50 +0000)]
DB update patch/script from Joe Atzberger.
===
Attachment one is a database update script based on work Bill sent to the list. The previous mechanism was to call psql -f once per file, but that also required the psql password to be entered once per file and didn't check to see if the call failed to try again or at least bail out on subsequent files (that might require the earlier ones to succeed. Given that typing (or even pasting) 20+ consecutive blind password entires is error-prone, I replaced that with a pipe to single psql call.
Pending acceptance, the foreseeable goal will be to integrate this script with the update.sh script and have a single call to apply both code and data changes from an updated repo.
===
erickson [Mon, 23 Nov 2009 20:38:40 +0000 (20:38 +0000)]
Update script patch from Joe Atzberger.
===
The purpose of this script is to consolidate a lot of the annoying and error-prone tasks associated with an upgrade for a developer, including make, make install, the xulrunner client built and autogen.
Considerations:
* Run as user "opensrf"
* opensrf needs sudo (again, targeting developers, not production) for apache stop/start, chown and make install
* Assumes opensrf has two SVN (or git-svn) repos: OpenILS and OpenSRF
* Both repos should be already configured (as in ./configure)
Detailed usage notes available via -h option. Both repo directories and the install directory can be specified on the command line. Try it with -t (test mode) to see feedback without making any changes.
===
TODO. Add option to use brick_ctl.sh instead of osrf_ctl.sh for service start/stop
scottmk [Mon, 23 Nov 2009 20:37:08 +0000 (20:37 +0000)]
Changing some datatypes to link, to reflect the presence
of corresponding linkages in the <links> aggregate, for
classes "rud", "rcirct", "rhrr", "rxbt", "rxpt", and "ergbhu".
erickson [Mon, 23 Nov 2009 17:13:14 +0000 (17:13 +0000)]
now updating circ and hold summary numbers. during checkout, update the total and session checkout number. if a hold is captured during checkout, update the hold numbers to reflect the change
erickson [Mon, 23 Nov 2009 16:41:27 +0000 (16:41 +0000)]
plugged in support for auto-renew-age checking. more event handling. self-check should now be functionally equivalent to the old self-check as far as checkout/renewal goes. still needs receipts, etc.
erickson [Sun, 22 Nov 2009 19:49:18 +0000 (19:49 +0000)]
added a util function to play an audio file via url using the HTML5 <audio> element. no attempt was made to support browsers that don't yet support <audio>
djfiander [Sun, 22 Nov 2009 00:37:42 +0000 (00:37 +0000)]
CHANGES
. Added support for compressed 863 holdings, including both structure and function
. Added function to turn 863 chronologies into ISO datestrings (YYYY-MM-DD)
. Employed the existing prediction logic to generate full prediction lists by way of an 863 increment method
. Added necessary accessor and setter methods to reduce direct object attribute access
. Renamed a few methods to better fit the expanded object interfaces
. Cleaned up a few commented-out print-type debug statements
. Other minor changes
TODO
. Switch to full POD-style inline documentation
. Address various XXX and TODO comments here and there as needed
. Further flesh out object interfaces as needed
Developer's Certificate of Origin 1.1
By making a contribution to this project, I certify that:
(a) The contribution was created in whole or in part by me and I
have the right to submit it under the open source license
indicated in the file; or
(b) The contribution is based upon previous work that, to the best
of my knowledge, is covered under an appropriate open source
license and I have the right under that license to submit that
work with modifications, whether created in whole or in part
by me, under the same open source license (unless I am
permitted to submit under a different license), as indicated
in the file; or
(c) The contribution was provided directly to me by some other
person who certified (a), (b) or (c) and I have not modified
it.
(d) I understand and agree that this project and the contribution
are public and that a record of the contribution (including all
personal information I submit with it, including my sign-off) is
maintained indefinitely and may be redistributed consistent with
this project or the open source license(s) involved.
Signed-off-by: Dan Wells <dbw2@calvin.edu>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@14997 dcc99617-32d9-48b4-a31d-7c20da2025e4
miker [Fri, 20 Nov 2009 19:15:10 +0000 (19:15 +0000)]
Patch from Joe Atzberger to break up the auditor table creation function into multiple bits.
This is the start of a process that will make the auditor functionality more stable and predictable across upgrades, where columns are dropped and created on audited tables.
phasefx [Thu, 19 Nov 2009 18:44:14 +0000 (18:44 +0000)]
This gives the offline interfaces the ability to use font_helper (which honors the global font settings), but it also pulls in a lot of functions that won't work in offline mode is called, which why it wasn't there originally. Font helper had slipped into the offline interfaces causing non-fatal errors
phasefx [Thu, 19 Nov 2009 18:33:40 +0000 (18:33 +0000)]
Fix util.date regression in offline mode. We don't have dojo in that environment, and likely won't bundle it. So back to original parsing for db_date2Date if no dojo, and don't offer the %{localized} and %{iso8601} format options if no dojo. At least for now.
erickson [Thu, 19 Nov 2009 16:25:20 +0000 (16:25 +0000)]
created general purpose 'a copy for a theoretical hold is available at shelving location X for org Y'. can be used by the OPAC to nudge (or force) users toward just grabbing the copy instead of placing a hold
dbs [Thu, 19 Nov 2009 16:14:42 +0000 (16:14 +0000)]
Apply patch from Galen Charlton to escape email addresses in overdue notices:
"Trivial patch to turn on XML-escaping of e-mail addresses. '&' is a
rarely used but valid character in email addresses, and failing to
escape makes the overdue notice data file non-well-formed."
phasefx [Thu, 19 Nov 2009 07:14:01 +0000 (07:14 +0000)]
localize dates in various list columns using dojo (hey, no more .substring(0,10)!) and remove newly redundant columns (so for example, instead of having both a
'Checkout Date' and a 'Checkout Timestamp', we just have 'Checkout Date', using a dojo localized time). list.fm_columns does this automatically, but we're not
ready to replace all lists with that yet. Also tweaked some ambiguous labels.
phasefx [Thu, 19 Nov 2009 05:43:47 +0000 (05:43 +0000)]
Use Dojo for parsing date strings from the database into javascript date objects, and for turning dates into ISO8601 date strings. Stop using DP_DateExtensions.js. Add a {localized} format for util.date.formatted_date, using Dojo.
phasefx [Wed, 18 Nov 2009 16:35:49 +0000 (16:35 +0000)]
With fm_columns, hide by default any virtual field and any field with a datatype of link. For rendering values for link fields, if the data encountered is an object, flatten it by using the field's .key value as a method against the object.
projects / working / Evergreen.git / log