Catch up to trunk phase 2 (the rest) -- Merged revisions 17889,17891-17892,17894...

Catch up to trunk phase 2 (the rest) -- Merged revisions 17889,17891-17892,17894,17896-17897,17899,17901,17903,17905-17906,17908,17910,17912-17915,17917-17918,17922,17927,17929,17931,17933,17935,17937-17939,17941,17944-17946,17948,17950,17952,17954,17956-17958,17963,17965,17972,17974,17976,17978,17980,17982,17984-17985,17987,17989,17991-17992,17994-17995,17997,17999,18001-18007,18009,18011,18013,18015-18017,18021,18023,18025,18027,18029,18034,18037,18039,18041,18043,18045,18047,18049,18051,18054-18058,18062,18068,18072-18073,18075-18077,18079,18081,18083-18085,18089,18091,18093,18095,18097,18099,18101,18103,18105-18106,18109,18111-18113,18116,18121,18123-18124,18126,18128,18130,18132-18133,18136,18138,18140-18141,18146,18148,18150-18151,18153,18158-18159,18163,18165,18167,18169,18171-18172,18175,18177,18179-18180,18182-18185,18187-18188,18191-18193,18195-18196,18198-18199,18202-18203,18205,18207,18210-18211,18213,18215,18217,18219-18220,18222,18224,18226,18228,18230-18231,18233,18239-18240,18244-18245,18247,18249,18251,18253,18255-18256,18258-18262,18264,18269,18271-18272,18274,18277-18282,18285-18291,18293-18294,18298-18300,18303,18310-18313,18321-18323,18326,18329,18331,18333,18336,18342-18343,18349,18351,18353,18364-18366 via svnmerge from
svn://svn.open-ils.org/ILS/trunk

........
  r17889 | scottmk | 2010-09-22 11:59:06 -0400 (Wed, 22 Sep 2010) | 8 lines

  For action.circulation and action.aged_circulation: add indexes
  on the target_copy column.

  This change was made in upgrade script # 0017, but was apparently
  never applied to the base install script.

  M    Open-ILS/src/sql/Pg/090.schema.action.sql
........
  r17891 | scottmk | 2010-09-22 15:16:26 -0400 (Wed, 22 Sep 2010) | 7 lines

  Adding a trigger.  Upgrade # 0364 created the trigger function but not
  the trigger itself.  However the base install script 040.schema.asset.sql
  creates both the function and the trigger.

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0414.schema.call-number-upd-ins-trigger.sql
........
  r17892 | phasefx | 2010-09-22 15:31:07 -0400 (Wed, 22 Sep 2010) | 1 line

  Holdings Maintenance used to make too many assumptions about what a decent org hierarchy looked like, and had these rules to suppress some of the fetch-render-happy behavior that existed when clicking on org units.  We can remove them now, and this allows volumes to render when owned by the top of the org tree
........
  r17894 | phasefx | 2010-09-22 15:37:43 -0400 (Wed, 22 Sep 2010) | 2 lines

  fixes a bug in Item Status -> Alternate View when the item being viewed has no circ modifier
........
  r17896 | phasefx | 2010-09-22 16:01:55 -0400 (Wed, 22 Sep 2010) | 1 line

  fix from tsbere to handle case where the print strategy is set to custom/external but the actual command is missing (perhaps due to xulrunner upgrades?)
........
  r17897 | phasefx | 2010-09-22 16:01:59 -0400 (Wed, 22 Sep 2010) | 1 line

  set label printer context for label printing
........
  r17899 | senator | 2010-09-22 20:14:03 -0400 (Wed, 22 Sep 2010) | 3 lines

  Hopefully fix a holds list sorting issue that only manifested when printing.
........
  r17901 | senator | 2010-09-22 20:34:22 -0400 (Wed, 22 Sep 2010) | 2 lines

  Another IDL chunking fix for web/templates-based interfaces
........
  r17903 | miker | 2010-09-22 22:12:02 -0400 (Wed, 22 Sep 2010) | 1 line

  only flesh up to, but not including, the leaf for the group_field
........
  r17905 | miker | 2010-09-22 22:49:36 -0400 (Wed, 22 Sep 2010) | 1 line

  Use a transaction to avoid talking to a replicated db when building A/T data structures
........
  r17906 | dbs | 2010-09-22 23:09:19 -0400 (Wed, 22 Sep 2010) | 7 lines

  Remove most UI annoyances from authority management interface

    * term input field now gets the focus automatically
    * pressing enter in most places submits a new search
    * removed the onBlur event as that required users to click a second
      time to open the action menu
........
  r17908 | dbs | 2010-09-22 23:18:14 -0400 (Wed, 22 Sep 2010) | 6 lines

  Browse through 20 authority records at a time in management interface

  The default browse list is set to 9 elements, but we have enough vertical
  space to make use of more. Perhaps we should check the font size and
  viewport height and then adjust accordingly, but that would be Hard.
........
  r17910 | dbs | 2010-09-22 23:45:16 -0400 (Wed, 22 Sep 2010) | 10 lines

  Remove most annoying UI "feature" of the new authority browse list interface

  When I added the new authority browse list interface, I used dojo.xhrGet()
  to retrieve records from the authority browse backend - but because I didn't
  specify sync:true, when you first right-clicked on a subfield, the function
  would return immediately and default to showing the context menu. You would
  then need to click two more times to show the authority list.

  Now you get it on your first right-click, as it should be.
........
  r17912 | miker | 2010-09-23 00:33:39 -0400 (Thu, 23 Sep 2010) | 1 line

  Have the CStoreEditor grow a DESTROY
........
  r17913 | erickson | 2010-09-23 01:31:03 -0400 (Thu, 23 Sep 2010) | 1 line

  event firing util code needs to run in a xact
........
  r17914 | erickson | 2010-09-23 03:17:00 -0400 (Thu, 23 Sep 2010) | 1 line

  fetch last updated event before comitting to stay in the xact
........
  r17915 | scottmk | 2010-09-23 09:45:06 -0400 (Thu, 23 Sep 2010) | 8 lines

  Dropping and recreating a foreign key constraint for config.metabib_field,
  in order to change its name.  WHen this foreign key was first introduced,
  the upgrade script gave it one name and the base install script gave it
  a different name.  Here we bring the names into sync.

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0415.schema.rename-field-class-fkey.sql
........
  r17917 | scottmk | 2010-09-23 10:31:32 -0400 (Thu, 23 Sep 2010) | 5 lines

  Rename a couple of indexes (recuring -> recurring)

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0416.schema.rename-recuring-idx.sql
........
  r17918 | scottmk | 2010-09-23 11:22:29 -0400 (Thu, 23 Sep 2010) | 12 lines

  Drop the never-used column item_count from acq.lineitem.
  Drop it also from the associated history table, and rebuild
  the function that maintains it.  Finally, rebuild the
  associated lifecycle view.

  Apply to trunk only; this column never existed in 2.0.
  The column has already been removed from the base installation
  script.

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0417.schema.acq.drop-lineitem-item-count.sql
........
  r17922 | miker | 2010-09-23 11:38:46 -0400 (Thu, 23 Sep 2010) | 11 lines

  Forward-port of a patch from Steve Callendar, via James Fournie, via launchpad:

  When the patron.password.use_phone is set, new patrons are created with their password set to the last 4 digits of their phone number, HOWEVER, when a patron's password is reset, it does not work properly. Although the little underlined summary shows the proper 4 digits, the password box displays 9-ish digits, and is not the last 4 digits of the password.

  The attached patch was created by Steve Callender and is confirmed working on 1.6.0

  ORIGINAL CAVEAT: This patch will not work on 2.0 as that has a new user editor, but it would presumably be worthwhile to verify this functionality works in that editor as well.

  ED NOTE: Because it is possible to use the old editor -- it still exists -- this patch should be applied.  It does what it advertises to do, which is fix the old editor to follow the "use phone number" OU setting.
........
  r17927 | phasefx | 2010-09-23 12:35:20 -0400 (Thu, 23 Sep 2010) | 2 lines

  disable holds Detail View button until the asynchronously loading details UI is ready
........
  r17929 | scottmk | 2010-09-23 14:58:36 -0400 (Thu, 23 Sep 2010) | 5 lines

  esolving various discrepancies between a freshly built 2.0
  database and an upgraded one.

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r17931 | erickson | 2010-09-23 16:47:47 -0400 (Thu, 23 Sep 2010) | 1 line

  repaired search call for user_setting. cstoreeditor uses the fieldmapper name, sos/usr/user/
........
  r17933 | senator | 2010-09-23 16:59:13 -0400 (Thu, 23 Sep 2010) | 2 lines

  IE hates the dangling comma (sometimes).
........
  r17935 | erickson | 2010-09-23 19:01:06 -0400 (Thu, 23 Sep 2010) | 1 line

  I can has authoritative for selfcheck receipts
........
  r17937 | miker | 2010-09-23 19:38:10 -0400 (Thu, 23 Sep 2010) | 1 line

  Stopping the leak
........
  r17938 | miker | 2010-09-23 19:47:49 -0400 (Thu, 23 Sep 2010) | 1 line

  reverting previous. sorry, folks
........
  r17939 | miker | 2010-09-23 19:49:26 -0400 (Thu, 23 Sep 2010) | 1 line

  Stopping the leak (let us try this again)
........
  r17941 | senator | 2010-09-23 20:15:31 -0400 (Thu, 23 Sep 2010) | 2 lines

  Re-commit miker's PermaCrud changes, just a tad more nicer ;-)
........
  r17944 | scottmk | 2010-09-23 20:56:21 -0400 (Thu, 23 Sep 2010) | 10 lines

  Apply some fixes that were earlier applied to the base installation script
  090.schema.action.sql, but not in an upgrade script.

  Also: correct a typo (INTEVAL -> INTERVAL).  Hence this upgrade needs to go
  to v2.0 as well as to trunk.

  M    Open-ILS/src/sql/Pg/090.schema.action.sql
  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0418.function.action.fix-purge-circ.sql
........
  r17945 | miker | 2010-09-23 21:46:41 -0400 (Thu, 23 Sep 2010) | 1 line

  correct the comment
........
  r17946 | miker | 2010-09-23 21:47:06 -0400 (Thu, 23 Sep 2010) | 1 line

  use _session_request in RO calls
........
  r17948 | phasefx | 2010-09-23 22:36:55 -0400 (Thu, 23 Sep 2010) | 2 lines

  We're starting to get events where ilsevent == empty string now, not just null or a number.
........
  r17950 | senator | 2010-09-24 00:45:42 -0400 (Fri, 24 Sep 2010) | 3 lines

  Be more tolerant of long-running A/T event handling for holds pull list printing
........
  r17952 | phasefx | 2010-09-24 01:48:39 -0400 (Fri, 24 Sep 2010) | 2 lines

  this call returns an array; fixes surprise stat cats in patron display
........
  r17954 | gmc | 2010-09-24 12:37:23 -0400 (Fri, 24 Sep 2010) | 9 lines

  improve hold targetting

  * all potential capturable copies are now checked (up to the first
    one that is permitted for the request), instead of a small random
    subset of them
  * don't do redundant permission checks

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r17956 | miker | 2010-09-24 13:45:49 -0400 (Fri, 24 Sep 2010) | 1 line

  excise the no-potentials check, should only effect frozen holds
........
  r17957 | miker | 2010-09-24 13:56:31 -0400 (Fri, 24 Sep 2010) | 1 line

  put the frozen (and also empty issuance or last-copy-removed) check back in as a conditional select if we found nothing mapped
........
  r17958 | phasefx | 2010-09-24 14:04:59 -0400 (Fri, 24 Sep 2010) | 2 lines

  don't styled the juvenile indicator in the patron display based on age calculations by default, just go by the juvenile flag on the user.  local CSS can restore the behavior if desired
........
  r17963 | miker | 2010-09-24 14:08:05 -0400 (Fri, 24 Sep 2010) | 1 line

  cut-n-paste-o ... removing bad "my"
........
  r17965 | phasefx | 2010-09-24 14:23:10 -0400 (Fri, 24 Sep 2010) | 2 lines

  spawn item attribute editor instead of item notes UI during process missing pieces workflow
........
  r17972 | erickson | 2010-09-24 15:30:10 -0400 (Fri, 24 Sep 2010) | 1 line

  removed extra {}'s from where clause
........
  r17974 | senator | 2010-09-24 16:11:12 -0400 (Fri, 24 Sep 2010) | 2 lines

  Fix an autogrid create dialog of the kind that gets big, unusable and jumpy
........
  r17976 | miker | 2010-09-24 16:29:43 -0400 (Fri, 24 Sep 2010) | 1 line

  Remove confusing older targeter version; move status trimming to earlier in the process
........
  r17978 | erickson | 2010-09-24 18:23:58 -0400 (Fri, 24 Sep 2010) | 1 line

  clean up the fire_object_events cstore xact
........
  r17980 | erickson | 2010-09-24 19:04:45 -0400 (Fri, 24 Sep 2010) | 1 line

  more transaction cleanups
........
  r17982 | senator | 2010-09-24 20:56:24 -0400 (Fri, 24 Sep 2010) | 2 lines

  Maybe not abandon poor little cstore so much.
........
  r17984 | miker | 2010-09-24 20:58:35 -0400 (Fri, 24 Sep 2010) | 1 line

  pedantic protection of cstore backends -- always use die_event when in xact mode, and rollback otherwise
........
  r17985 | senator | 2010-09-24 21:13:31 -0400 (Fri, 24 Sep 2010) | 2 lines

  paranoia
........
  r17987 | erickson | 2010-09-24 23:27:20 -0400 (Fri, 24 Sep 2010) | 1 line

  events don't have granularity's.  removing
........
  r17989 | senator | 2010-09-24 23:45:21 -0400 (Fri, 24 Sep 2010) | 2 lines

  How did this get lost? PermaCrud authoritative might work now?
........
  r17991 | erickson | 2010-09-24 23:46:03 -0400 (Fri, 24 Sep 2010) | 1 line

  no need to start a xact in the holds pull list.  really long lists can results in sending a rollback on a timed-out cstore handle, resulting in errors
........
  r17992 | senator | 2010-09-24 23:54:09 -0400 (Fri, 24 Sep 2010) | 2 lines

  fix misplaced paranoia
........
  r17994 | erickson | 2010-09-25 00:09:57 -0400 (Sat, 25 Sep 2010) | 1 line

  only need to wrap event retrieve in xact for latest copy.  otherwise, run the risk of xact-ed cstore timing out
........
  r17995 | gmc | 2010-09-25 22:42:50 -0400 (Sat, 25 Sep 2010) | 6 lines

  don't leak cstores if CStoreEditor rollback fails

  Patch by Mike Rylander.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r17997 | gmc | 2010-09-25 22:49:39 -0400 (Sat, 25 Sep 2010) | 10 lines

  more selfcheck receipt transaction hackery

  Instead of having authoritative versions of
  open-ils.circ.fire_*_trigger_events, wrap just the
  target retrieval itself in a transaction.  Avoids as
  yet unexplained rollback failure that occurs if
  processing a selfcheck receipt with more than a few items on it.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r17999 | phasefx | 2010-09-25 23:17:05 -0400 (Sat, 25 Sep 2010) | 2 lines

  make address_type required in the patron editor, otherwise a blank value sends a null to the db where it silently fails
........
  r18001 | phasefx | 2010-09-26 02:34:22 -0400 (Sun, 26 Sep 2010) | 2 lines

  Show cover art in Z39.50 client.  I'm slow, so it only hit me this year that we can show added content for material not actually in the catalog yet
........
  r18002 | phasefx | 2010-09-26 03:05:58 -0400 (Sun, 26 Sep 2010) | 2 lines

  make the splitters in the z39.50 interface sticky
........
  r18003 | phasefx | 2010-09-26 04:06:33 -0400 (Sun, 26 Sep 2010) | 2 lines

  make all the splitters sticky with oils_persist
........
  r18004 | phasefx | 2010-09-26 05:23:43 -0400 (Sun, 26 Sep 2010) | 2 lines

  Call persist_helper() in most interfaces.  Give it the ability to handle resizing windows and set some windows up so that their height, width, and maximized state persist
........
  r18005 | phasefx | 2010-09-26 06:02:38 -0400 (Sun, 26 Sep 2010) | 2 lines

  make the MARC editor optional with Z39.50
........
  r18006 | phasefx | 2010-09-26 06:29:36 -0400 (Sun, 26 Sep 2010) | 2 lines

  unmark record for overlay after it is overlaid
........
  r18007 | miker | 2010-09-26 11:31:41 -0400 (Sun, 26 Sep 2010) | 1 line

  allow more complex facet ordering
........
  r18009 | miker | 2010-09-26 11:53:21 -0400 (Sun, 26 Sep 2010) | 1 line

  Only show facetOrder limited facets that have values
........
  r18011 | gmc | 2010-09-26 12:26:21 -0400 (Sun, 26 Sep 2010) | 4 lines

  added missing columns to CDBI table definitions

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18013 | dbs | 2010-09-26 14:34:47 -0400 (Sun, 26 Sep 2010) | 2 lines

  Remove a debugging statement that slipped in
........
  r18015 | erickson | 2010-09-26 19:20:10 -0400 (Sun, 26 Sep 2010) | 1 line

  push copy location order update into ML method.  return updated orders from method to prevent replication issues.  update UI JS to match
........
  r18016 | erickson | 2010-09-26 19:20:11 -0400 (Sun, 26 Sep 2010) | 1 line

  no need to warn when emails may just be disabled
........
  r18017 | erickson | 2010-09-26 19:20:12 -0400 (Sun, 26 Sep 2010) | 1 line

  honor SIP return date as the circ backdate
........
  r18021 | gmc | 2010-09-26 21:43:12 -0400 (Sun, 26 Sep 2010) | 4 lines

  avoid multiple clicks of selfcheck logout link

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18023 | scottmk | 2010-09-27 08:45:57 -0400 (Mon, 27 Sep 2010) | 5 lines

  Resolve differences between stored procedures in a freshly installed
  2.0 database and those in an upgraded one.

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r18025 | miker | 2010-09-27 11:23:10 -0400 (Mon, 27 Sep 2010) | 1 line

  Provide for limiting the number of classOrder elements to a specific number. Skips those without facet values.
........
  r18027 | miker | 2010-09-27 12:15:14 -0400 (Mon, 27 Sep 2010) | 1 line

  Adjust hold-to-record view to cover I, F and R hold types
........
  r18029 | phasefx | 2010-09-27 12:29:19 -0400 (Mon, 27 Sep 2010) | 2 lines

  since we're enforcing the requiredness of address type, let's give it a default value (since empty strings don't work with these widgets)
........
  r18034 | miker | 2010-09-27 14:26:29 -0400 (Mon, 27 Sep 2010) | 1 line

  use transaction when gathering records from a newly created queue; adjust rollback usage in import loop
........
  r18037 | gmc | 2010-09-27 14:50:56 -0400 (Mon, 27 Sep 2010) | 4 lines

  fix default path to selfcheck sounds

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18039 | miker | 2010-09-27 15:11:21 -0400 (Mon, 27 Sep 2010) | 1 line

  make pubdate sorting on search faster by pre-munging date1 and date2 into an acceptable sortkey
........
  r18041 | miker | 2010-09-27 15:16:57 -0400 (Mon, 27 Sep 2010) | 1 line

  Correct the subquery for A/T opt_in_setting
........
  r18043 | miker | 2010-09-27 15:24:13 -0400 (Mon, 27 Sep 2010) | 1 line

  missed in the previous commit, sorry folks
........
  r18045 | gmc | 2010-09-27 15:27:04 -0400 (Mon, 27 Sep 2010) | 7 lines

  fix glitch in hold target OU weighting

  We want to weight by the copy's circulation library, not the
  pickup library.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18047 | gmc | 2010-09-27 15:48:33 -0400 (Mon, 27 Sep 2010) | 4 lines

  fix another hold targeting glitch

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18049 | gmc | 2010-09-27 16:14:49 -0400 (Mon, 27 Sep 2010) | 7 lines

  adjustments to pubdate sorting patch

  * handle upgrade for date1/date2 containing the empty string
  * syntax error fix

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18051 | senator | 2010-09-27 16:54:56 -0400 (Mon, 27 Sep 2010) | 2 lines

  Special overriden widgets need forcible population when used in edit dialogs
........
  r18054 | scottmk | 2010-09-27 17:31:17 -0400 (Mon, 27 Sep 2010) | 12 lines

  1. Turn some ints into bigints.

  2. Rename the uniqueness constraint for booking.resource_type.

  M    Open-ILS/src/sql/Pg/090.schema.action.sql
  M    Open-ILS/src/sql/Pg/200.schema.acq.sql
  M    Open-ILS/src/sql/Pg/012.schema.vandelay.sql
  M    Open-ILS/src/sql/Pg/095.schema.booking.sql
  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  M    Open-ILS/src/sql/Pg/070.schema.container.sql
  A    Open-ILS/src/sql/Pg/upgrade/0421.schema.embiggen-ints.sql
........
  r18055 | atz | 2010-09-27 21:22:40 -0400 (Mon, 27 Sep 2010) | 3 lines

  For edi_translator on RHEL

  Note: RubyGems 1.3.4 is not available anymore
........
  r18056 | atz | 2010-09-27 21:22:41 -0400 (Mon, 27 Sep 2010) | 1 line

  Fix POD for RemoteAccount
........
  r18057 | atz | 2010-09-27 21:24:20 -0400 (Mon, 27 Sep 2010) | 1 line

  Minor cleanup
........
  r18058 | atz | 2010-09-27 21:26:07 -0400 (Mon, 27 Sep 2010) | 1 line

  typo in POD
........
  r18062 | dbs | 2010-09-27 23:08:48 -0400 (Mon, 27 Sep 2010) | 5 lines

  Use quoted attribute values to make Firefox / XULRunner happier about dojo queries

  The unquoted values in BibTemplate and the OPAC detail template were generating
  mucho noise in the JavaScript console; this hushes it up nicely.
........
  r18068 | dbs | 2010-09-27 23:32:28 -0400 (Mon, 27 Sep 2010) | 11 lines

  Add a placeholder server/skin/custom.js to prevent one error in JS console

  custom.js enables you to override the settings in the stock constants.js
  to skin the behaviour of your staff client at your installation, without
  being subject to grief at upgrade time.

  Not having a custom.js file at all was, however, causing errors to be generated
  in the JS console as XULRunner tried hard to parse the 404 message as
  JavaScript. I suppose one could have changed the 404 message to valid
  JavaScript... naw, that would be evil.
........
  r18072 | scottmk | 2010-09-28 01:13:32 -0400 (Tue, 28 Sep 2010) | 6 lines

  Turn an int into a bigint in acq.acq_lineitem_history, following up on
  a similar change to acq.lineitem.

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0422.schema.acq.lineitem-history-bigint.sql
........
  r18073 | scottmk | 2010-09-28 01:17:03 -0400 (Tue, 28 Sep 2010) | 4 lines

  Incorporate several recent upgrade scripts, through # 0422.

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r18075 | dbs | 2010-09-28 02:18:07 -0400 (Tue, 28 Sep 2010) | 6 lines

  Silence SQL warnings from O:A:Storage:Publisher:metabib

  PostgreSQL wants strings containing regular expressions to be prefixed
  with E; this patch considerably reduces the noise in open-ils.storage_unix.log
  by complying with PostgreSQL's wishes.
........
  r18076 | dbs | 2010-09-28 02:43:41 -0400 (Tue, 28 Sep 2010) | 13 lines

  Make authority validation rules match authority ingest rules for better matches

  This resolves a problem in O:A:Storage:Publisher:authority:validate_tag() where
  the full NACO normalization rules that are applied to the subfields of the
  authority records when they are ingested into authority.full_rec are not similarly
  applied to the incoming subfields of the bib field that is being validated;
  only diacritic characters in the bib field subfields were being normalized.

  Now we apply naco_normalize() to the search terms so that they will match
  the ingested form of the authority record.

  Addresses https://bugs.launchpad.net/evergreen/+bug/649556
........
  r18077 | miker | 2010-09-28 12:35:24 -0400 (Tue, 28 Sep 2010) | 1 line

  add support for the null() xpath function, which works in pgxml (AKA xml2) but not in the builtin XPATH function for 8.3+
........
  r18079 | dbs | 2010-09-28 12:40:02 -0400 (Tue, 28 Sep 2010) | 7 lines

  Change memcached default location to 127.0.0.1 from localhost

  Debian Squeeze currently doesn't fare well with memcached servers pointing to
  localhost and needs an explicit 127.0.0.1, whereas Ubuntu Lucid is happy with
  either. Changing the default here means one less possible gotcha in the out
  of the box install & configure experience for Debian Squeeze folk.
........
  r18081 | phasefx | 2010-09-28 12:46:34 -0400 (Tue, 28 Sep 2010) | 1 line

  this breaks (hides) the buttonbar in windows.  Sorry James, miker
........
  r18083 | erickson | 2010-09-28 14:12:12 -0400 (Tue, 28 Sep 2010) | 1 line

  repaired logic bug in lineitem worksheet template
........
  r18084 | erickson | 2010-09-28 14:12:13 -0400 (Tue, 28 Sep 2010) | 5 lines

  ability to override checkin events. minor fixes.

  repaired bug that caused checkin to sometimes fail when a hold
  was captured for a user that had at least 1 inactive card;
  made checkin override events configurable; minor cleanup
........
  r18085 | erickson | 2010-09-28 14:12:14 -0400 (Tue, 28 Sep 2010) | 1 line

  for troubleshooting, log the size of the template output to be stored
........
  r18089 | senator | 2010-09-28 16:26:09 -0400 (Tue, 28 Sep 2010) | 5 lines

  A/T: Send an early response back to the client when running all pending events
  The client may wish to know when the relativelty fast process of creating the
  events is over, and the relatively slow process of validating them and running
  their reactors/cleanup/etc is about to begin.
........
  r18091 | miker | 2010-09-28 16:45:17 -0400 (Tue, 28 Sep 2010) | 1 line

  move the early-out response so we avoid breaking the caller
........
  r18093 | phasefx | 2010-09-28 17:12:11 -0400 (Tue, 28 Sep 2010) | 2 lines

  Delete all cookies on logoff.  There's dojo code that looks for stale session cookies and has the xul client prompt for a new session.  When you logoff, the session is destroyed, but the stale cookies were being left behind (and not overwritten on login? I don't understand that part).  But this fixes it
........
  r18095 | miker | 2010-09-28 19:12:58 -0400 (Tue, 28 Sep 2010) | 1 line

  Use transactions everywhere in Vandelay
........
  r18097 | miker | 2010-09-29 10:45:50 -0400 (Wed, 29 Sep 2010) | 1 line

  Process item imports during record import, not as a secondary call (never should have worked, but for transaction timing)
........
  r18099 | miker | 2010-09-29 11:05:53 -0400 (Wed, 29 Sep 2010) | 1 line

  support per-grunlarity parallelizing via flag and lock file
........
  r18101 | gmc | 2010-09-29 13:48:52 -0400 (Wed, 29 Sep 2010) | 10 lines

  reporter: don't try to write Excel formulas

  Any cell value that starts with = is now always written
  as a text cell in spreadsheet output.  Avoids a possible
  exploit as well as errors like this:

  Couldn't parse formula: = at /openils/bin/clark-kent.pl line 429

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18103 | gmc | 2010-09-29 14:07:43 -0400 (Wed, 29 Sep 2010) | 4 lines

  fix FM type of reporter.report.data

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18105 | miker | 2010-09-29 16:16:41 -0400 (Wed, 29 Sep 2010) | 1 line

  Give BibTemplate the ability to inspect and optionally parse XML, instead of requiring a DOM node
........
  r18106 | phasefx | 2010-09-29 16:49:05 -0400 (Wed, 29 Sep 2010) | 2 lines

  Fix overzealous prompting for auth credentials, and some debug lines
........
  r18109 | erickson | 2010-09-30 16:49:14 -0400 (Thu, 30 Sep 2010) | 1 line

  fire the hold_request.cancel.staff when hold is cancelled by staff
........
  r18111 | atz | 2010-09-30 19:06:39 -0400 (Thu, 30 Sep 2010) | 6 lines

  Silence warning

  Warnings was:
  Use of uninitialized value in subroutine entry at /openils/lib/perl5/OpenILS/SIP/Patron.pm line 230.

  Signed-off-by: Joe Atzberger <atz@esilibrary.com>
........
  r18112 | dbs | 2010-10-01 01:16:41 -0400 (Fri, 01 Oct 2010) | 6 lines

  Add serial.record_entry to CDBI definitions

  Better late than never; never added the serial.record_entry
  CDBI definitions in the 1.6 series, but as that table can
  still be active in 2.0 we might as well get it in place.
........
  r18113 | dbs | 2010-10-01 01:24:38 -0400 (Fri, 01 Oct 2010) | 14 lines

  Teach marc_export script how to export MFHD serial records

  Passing the --mfhd flag will export any non-deleted MFHD records in
  serial.record_entry associated with each bib ID. So, for a hypothetical set of
  bib IDs 1, 2, 3, where 2 has no associated MFHD records and 3 has 2 MFHD records
  associated with it, the output will be structured as follows:

  Bib MARC for bib ID 1
  MFHD MARC for bib ID 1
  Bib MARC for bib ID 2
  Bib MARC for bib ID 3
  MFHD MARC for bib ID 3
  MFHD MARC for bib ID 2
........
  r18116 | phasefx | 2010-10-01 08:19:11 -0400 (Fri, 01 Oct 2010) | 2 lines

  tweak remoteauth.cgi to offer usrname and barcode params in addition to user.  user param now looks for the opac.barcode_regex org unit setting to determine whether the value is a usrname or barcode.  change double-quotes to single-quotes if we're not doing string interpolation.  change apache instructions for configuration
........
  r18121 | phasefx | 2010-10-01 14:07:00 -0400 (Fri, 01 Oct 2010) | 2 lines

  use an opac login here, which doesn't require the STAFF_LOGIN permission by default
........
  r18123 | miker | 2010-10-01 15:39:51 -0400 (Fri, 01 Oct 2010) | 1 line

  Implement a process-local cache for event target fleshing -- particularly helpful with large event groups
........
  r18124 | senator | 2010-10-01 15:45:27 -0400 (Fri, 01 Oct 2010) | 5 lines

  Offer yet another pull list printing pathway

  If you have pull lists long enough to make A/T groan, perhaps this will work
  better for you.
........
  r18126 | dbs | 2010-10-01 16:07:59 -0400 (Fri, 01 Oct 2010) | 11 lines

  Set due times for durations measured in days to 23:59:59 after inserts OR updates

  The existing trigger acted only on the initial insert of a circulation
  transaction for duration intervals perfectly divisible by 24 hours.
  If updates to those due dates were subsequently issued, then the due
  time would revert to 00:00:00 - which could cause surprising overdue
  fines to be generated on the due date, rather than after the due date.

  This commit makes the trigger take effect on both INSERT and UPDATE
  to the action.circulation table.
........
  r18128 | dbs | 2010-10-01 16:13:10 -0400 (Fri, 01 Oct 2010) | 2 lines

  Bring the 1.6.1-2.0 upgrade script up to date for the push_due_date_tgr
........
  r18130 | senator | 2010-10-01 17:48:41 -0400 (Fri, 01 Oct 2010) | 4 lines

  Fix an apparent bug in a case where OpenILS::WWW::Proxy means to send a
  redirect, and also avoid the issue altogether in the new holds pull list
  printing interface just added earlier today.
........
  r18132 | miker | 2010-10-02 01:47:02 -0400 (Sat, 02 Oct 2010) | 7 lines

  Massive search core-query speed improvement.

   * Only compile the tsquery once
   * Use direct ids instead of going back to the db udring a queyr
   * Change a remaining CASE to COALESCE/NULLIF
........
  r18133 | miker | 2010-10-02 02:04:05 -0400 (Sat, 02 Oct 2010) | 1 line

  putting back the NUMERIC cast, it is needed
........
  r18136 | miker | 2010-10-02 11:47:28 -0400 (Sat, 02 Oct 2010) | 1 line

  configurable chunking of the holds stream to avoid the xulrunner "I forgot the chunked stream" problem
........
  r18138 | scottmk | 2010-10-03 10:17:37 -0400 (Sun, 03 Oct 2010) | 4 lines

  Incorporate upgrade scripts 0423 and 0424

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r18140 | erickson | 2010-10-03 11:06:45 -0400 (Sun, 03 Oct 2010) | 1 line

  moved the cache clear to later in the firing to pick up data; fixed some typos/thinkos
........
  r18141 | miker | 2010-10-03 20:40:44 -0400 (Sun, 03 Oct 2010) | 1 line

  Allow caller to ignore selected facet classes; ignore identifier class by default
........
  r18146 | scottmk | 2010-10-04 09:43:13 -0400 (Mon, 04 Oct 2010) | 8 lines

  Add hold_priority column to permission.grp_tree table.

  M    Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/permission.pm
  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0425.schema.perm-grp-tree-hold-priority.sql
  M    Open-ILS/src/sql/Pg/006.schema.permissions.sql
  M    Open-ILS/examples/fm_IDL.xml
........
  r18148 | senator | 2010-10-04 10:01:28 -0400 (Mon, 04 Oct 2010) | 2 lines

  Fix a slight bug in 18136, and the alt pull list printing interface works again.
........
  r18150 | senator | 2010-10-04 11:40:21 -0400 (Mon, 04 Oct 2010) | 2 lines

  Add a control for the hold_priority field in the permission group UI
........
  r18151 | miker | 2010-10-04 12:15:41 -0400 (Mon, 04 Oct 2010) | 1 line

  add support for hold_priority sorting in open-ils.storage.action.hold_request.nearest_hold
........
  r18153 | erickson | 2010-10-04 12:48:01 -0400 (Mon, 04 Oct 2010) | 1 line

  fixed typo in vandelay merge profile permission check
........
  r18158 | senator | 2010-10-04 14:57:20 -0400 (Mon, 04 Oct 2010) | 2 lines

  Add "Patron Alias" as an available column in pull list, holds shelf interfaces
........
  r18159 | dbs | 2010-10-04 15:05:59 -0400 (Mon, 04 Oct 2010) | 2 lines

  French translation of password reset form and prompts at /opac/password/fr-CA/
........
  r18163 | senator | 2010-10-04 17:28:17 -0400 (Mon, 04 Oct 2010) | 3 lines

  Add some missing ACQ perms. Other perms may be missing, but I /know/ these
  are needed.
........
  r18165 | erickson | 2010-10-05 10:15:40 -0400 (Tue, 05 Oct 2010) | 1 line

  avoid running activated hook when in dry run mode
........
  r18167 | gmc | 2010-10-05 10:44:21 -0400 (Tue, 05 Oct 2010) | 4 lines

  make it easier to grep for bib search durations from the Pg log

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18169 | phasefx | 2010-10-05 11:16:42 -0400 (Tue, 05 Oct 2010) | 8 lines

  more classname hooks for local CSS to latch on to if needed

  For example, you may have a server/skin/global_custom.css containing:

      .hide_patron_credit { display: none }
      .hide_patron_work{ display: none }
      .hide_patron_goods { display: none }
........
  r18171 | atz | 2010-10-05 12:14:46 -0400 (Tue, 05 Oct 2010) | 1 line

  Add title to PO view page.
........
  r18172 | atz | 2010-10-05 12:16:59 -0400 (Tue, 05 Oct 2010) | 1 line

  EDI job POD
........
  r18175 | senator | 2010-10-05 12:37:57 -0400 (Tue, 05 Oct 2010) | 3 lines

  This is a silly commit, as this template should be made configurable down the
  road, maybe by OU setting or something. Anyway, make the list more legible.
........
  r18177 | atz | 2010-10-05 13:08:56 -0400 (Tue, 05 Oct 2010) | 1 line

  The whole point of test mode, NOT actually committing actions.
........
  r18179 | gmc | 2010-10-05 14:54:05 -0400 (Tue, 05 Oct 2010) | 8 lines

  hold matrix selection: treat root OU as just another OU

  Treat the root OU as just another OU for the purpose of
  calculating OU proximity adjustments when selecting a
  matchpoint.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18180 | phasefx | 2010-10-05 15:33:08 -0400 (Tue, 05 Oct 2010) | 2 lines

  be quiet with errors retrieving remote column settings
........
  r18182 | phasefx | 2010-10-05 16:12:58 -0400 (Tue, 05 Oct 2010) | 1 line

  patch from tsbere to use _blank for new windows instead of generated identifiers
........
  r18183 | phasefx | 2010-10-05 16:13:01 -0400 (Tue, 05 Oct 2010) | 2 lines

  patch from tsbere to improve tab behavior and to give command-line options for controlling tabs
  See https://bugs.launchpad.net/evergreen/+bug/625056
........
  r18184 | phasefx | 2010-10-05 16:13:03 -0400 (Tue, 05 Oct 2010) | 1 line

  bug fix for close tab regression
........
  r18185 | phasefx | 2010-10-05 16:13:06 -0400 (Tue, 05 Oct 2010) | 1 line

  some I18N and tweak call to getIntPref.  Is the 2nd parameter version an undocumented way of providing a default if the pref isn't found?
........
  r18187 | miker | 2010-10-05 22:31:55 -0400 (Tue, 05 Oct 2010) | 1 line

  Add a retargetting specific version of the hold-permit function which skips user tests
........
  r18188 | miker | 2010-10-05 22:35:17 -0400 (Tue, 05 Oct 2010) | 1 line

  usr_grp is entirely unused currently; hide it
........
  r18191 | miker | 2010-10-05 23:07:30 -0400 (Tue, 05 Oct 2010) | 1 line

  Add a switch to turn on strict OU matching for all OUs required by a hold matchpoint
........
  r18192 | scottmk | 2010-10-06 09:27:26 -0400 (Wed, 06 Oct 2010) | 5 lines

  Fixed the second and third function definitions, which wouldn't compile.
  An SQL function cannot reference its parameters by name, but only by number.

  M    Open-ILS/src/sql/Pg/upgrade/0428.schema.hold_retarget.sql
........
  r18193 | erickson | 2010-10-06 09:28:09 -0400 (Wed, 06 Oct 2010) | 1 line

  first level of groups hash can be array or hash, leading to breakage;  for now, keep it simple and return continue-status to keep the caller alive
........
  r18195 | miker | 2010-10-06 09:43:52 -0400 (Wed, 06 Oct 2010) | 1 line

  Make retargetting check less lax by including appropriate patron-side test
........
  r18196 | miker | 2010-10-06 09:45:00 -0400 (Wed, 06 Oct 2010) | 1 line

  Start out exact-ou-match rules with an "always win" weight
........
  r18198 | miker | 2010-10-06 09:53:18 -0400 (Wed, 06 Oct 2010) | 1 line

  Thinko fix for field name. The script would not commit, so please simply reapply 0430.
........
  r18199 | erickson | 2010-10-06 09:54:26 -0400 (Wed, 06 Oct 2010) | 1 line

  suppress usr_grp field in hold matrix matchpoint;  see also 18188
........
  r18202 | scottmk | 2010-10-06 10:32:01 -0400 (Wed, 06 Oct 2010) | 5 lines

  Further propagating a syntax correction; SQL functions cannot reference
  their parameters by name.

  M    Open-ILS/src/sql/Pg/110.hold_matrix.sql
........
  r18203 | phasefx | 2010-10-06 10:59:43 -0400 (Wed, 06 Oct 2010) | 2 lines

  hold/transit slips may want to use stat cats as well
........
  r18205 | erickson | 2010-10-06 11:01:38 -0400 (Wed, 06 Oct 2010) | 1 line

  avoid retreiving/searching a linked object, when there is no object to retrieve (i.e. ident value is null) and silence various warnings by skipping this scenario.  mild variable refactor for easy reading for feeble eyes.
........
  r18207 | scottmk | 2010-10-06 11:55:14 -0400 (Wed, 06 Oct 2010) | 14 lines

  Two changes to config schema:

  1. Add new column date_ceiling to rule_circ_duration table.

  2. New table hard_due_date.

  For trunk, v1.6, v1.6.2 (eventually), and v2.1 (eventually).

  NOT for v1.6.1 or v2.0.

  M    Open-ILS/src/sql/Pg/002.schema.config.sql
  A    Open-ILS/src/sql/Pg/upgrade/0432.schema.config_hard_due_date.sql
  M    Open-ILS/examples/fm_IDL.xml
........
  r18210 | scottmk | 2010-10-06 14:19:43 -0400 (Wed, 06 Oct 2010) | 4 lines

  Incorporate upgrades 0427 and 0428 into the consolidated upgrade script.

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r18211 | miker | 2010-10-06 16:07:39 -0400 (Wed, 06 Oct 2010) | 1 line

  db upgrade script dislikes holes -- spackle this one
........
  r18213 | erickson | 2010-10-06 16:44:46 -0400 (Wed, 06 Oct 2010) | 1 line

  added support for honoring the due date ceiling from the duration rule.  AKA, end-of-semester due dates
........
  r18215 | senator | 2010-10-06 17:01:42 -0400 (Wed, 06 Oct 2010) | 14 lines

  New way to printing shelf-expired holds

  This just takes the newest template for printing hold pull lists and
  grafts this new functionality onto it.  It should perhaps be adjusted to also
  be able to print things on the holds shelf that /aren't/ shelf-expired.

  For now you get to this under Admin -> For Developers -> Local Administration

  This also corrects a bug because of which a "print pull list (alternate
  strategy)" button appeared where it shouldn't.

  This also removes the booking links from Admin -> For Developers -> Local
  Administration, as there are regular staff client menu entries for those now.
........
  r18217 | atz | 2010-10-06 18:12:36 -0400 (Wed, 06 Oct 2010) | 1 line

  Warn but continue on skipped upgrade revs.
........
  r18219 | erickson | 2010-10-07 10:56:43 -0400 (Thu, 07 Oct 2010) | 6 lines

  Parallel action/trigger collection and reaction

  QA'ed patch from miker to support parallel a/t event collection and
  reaction.  Max parallel procs is controlled by two new opensrf.xml
  trigger app_settings.  Sample config included, settings disabled by
  default.
........
  r18220 | phasefx | 2010-10-07 11:14:50 -0400 (Thu, 07 Oct 2010) | 2 lines

  destination_shelf macro for hold and hold/transit slips.  Will contain either HOLD SHELF, PUBLIC HOLD SHELF, or PRIVATE HOLD SHELF (these are localizable).  The latter two depend on the org unit setting 'circ.holds.behind_desk_pickup_supported' being in effect, and also considers a user setting for the holds user at the time of printing.
........
  r18222 | senator | 2010-10-07 13:18:58 -0400 (Thu, 07 Oct 2010) | 2 lines

  Add some reasonable default sorting to this expired holds list
........
  r18224 | atz | 2010-10-07 14:48:45 -0400 (Thu, 07 Oct 2010) | 6 lines

  EDI template update for ORDERS

  This template produces JSON for the edi translator to convert into
  actual EDI lines.  It now handles vendor-specific requirements for
  account and sub-account identification, and also transmits notes
  of the vendor-public variety as FTX segments in the lineitem.
........
  r18226 | senator | 2010-10-07 15:10:58 -0400 (Thu, 07 Oct 2010) | 3 lines

  Just a minor thing on this shelf expired print interface,
  probably more changes coming.
........
  r18228 | gmc | 2010-10-07 17:39:05 -0400 (Thu, 07 Oct 2010) | 4 lines

  choose the hold permit test variant correctly

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18230 | senator | 2010-10-07 18:37:45 -0400 (Thu, 07 Oct 2010) | 8 lines

  Expired holds shelf printer needs to be a holds shelf *clearer* and printer

  This needs cleaned up and stuff, and made into something cooler.
  Basically just does what XUL interfaces under the Circ menu can already do,
  but streamlined to tolerate really big datasets.

  Much of this code originates from berick and miker.
........
  r18231 | senator | 2010-10-07 18:46:24 -0400 (Thu, 07 Oct 2010) | 2 lines

  progress to ProgressDialog means total, not incremental
........
  r18233 | gmc | 2010-10-07 21:34:08 -0400 (Thu, 07 Oct 2010) | 8 lines

  do not apply superpage limit inside bib search joins

  Oddly, empirical evidence suggests that this might actually
  be faster, and if this pans out, search results will definitely
  be more complete.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18239 | dbs | 2010-10-07 23:30:00 -0400 (Thu, 07 Oct 2010) | 7 lines

  Avoid scary SSL / HTTPS errors in Apache configuration

  When port 443 is the last listener port, Apache generates lots
  of "unknown protocol speaking not SSL to HTTPS port!?" errors in
  the logs - which are scary, but harmless. Putting port 80 last
  avoids those errors entirely, per http://wiki.apache.org/httpd/InternalDummyConnection
........
  r18240 | scottmk | 2010-10-08 10:16:19 -0400 (Fri, 08 Oct 2010) | 19 lines

  Tidied up buildSELECT() a bit:

  1. Sprinkled the const qualifier here and there.

  2. Moved some variable declarations to get them closer to the point of
  first use, and to limit their scope.

  3. Renamed some variables to better reflect their meaning.

  4. Split a couple of variables into multiple variables, instead of using
  them for multiple unrelated purposes.

  5. Plugged a memory leak in the case of an error return.

  6. Added comments, including a Doxygen-style comment at the top of the
  function.

  M    Open-ILS/src/c-apps/oils_sql.c
........
  r18244 | miker | 2010-10-08 13:06:52 -0400 (Fri, 08 Oct 2010) | 1 line

  add a method to overlay a special bib container full of records (or bucket + template)
........
  r18245 | phasefx | 2010-10-08 13:29:20 -0400 (Fri, 08 Oct 2010) | 2 lines

  moving users in and out of groups produced dialogs that expected vertical patron summaries.  this fixes that
........
  r18247 | phasefx | 2010-10-08 13:38:24 -0400 (Fri, 08 Oct 2010) | 2 lines

  fix logic error where we were just testing for the presence of a user setting instead of its value
........
  r18249 | senator | 2010-10-08 14:02:08 -0400 (Fri, 08 Oct 2010) | 2 lines

  Be a little more tolerant of aberrant data when clearing the holds shelf
........
  r18251 | phasefx | 2010-10-08 16:58:37 -0400 (Fri, 08 Oct 2010) | 1 line

  typo
........
  r18253 | erickson | 2010-10-08 17:10:43 -0400 (Fri, 08 Oct 2010) | 1 line

  mild fixes for a/t interface admin interface.  sort by def name instead of hook, which probably makes more sense to a human.  hide the opt-in and max-delay columns to free up some badly needed horizontal space.  use percentage width for name column, which acts a lot like 'auto', but allows the user to manually resize
........
  r18255 | miker | 2010-10-08 22:32:49 -0400 (Fri, 08 Oct 2010) | 1 line

  mod_perl handler to allow batch update bib records from an ephemeral template
........
  r18256 | erickson | 2010-10-11 10:01:45 -0400 (Mon, 11 Oct 2010) | 1 line

  wait to run-pending if a specific granularity used
........
  r18258 | scottmk | 2010-10-11 10:25:05 -0400 (Mon, 11 Oct 2010) | 12 lines

  Pull out into a separate function: the code in SELECT() that builds a
  comma-separated list of ORDER BY expressions from a JSON_ARRAY.

  Invoke that function, not only from SELECT(), but also from the
  buildSELECT() function.

  As a result, the select methods will be able to use the same array
  syntax as json_query for ORDER BY clauses, as an alternative to the
  existing hash syntax.

  M    Open-ILS/src/c-apps/oils_sql.c
........
  r18259 | atz | 2010-10-11 11:21:12 -0400 (Mon, 11 Oct 2010) | 1 line

  Clean up method registration sigs/descs
........
  r18260 | atz | 2010-10-11 12:06:23 -0400 (Mon, 11 Oct 2010) | 1 line

  Method registration cleanup
........
  r18261 | miker | 2010-10-11 12:06:52 -0400 (Mon, 11 Oct 2010) | 1 line

  supply a dummy leader, as required by the Perl MARC modules
........
  r18262 | atz | 2010-10-11 12:07:09 -0400 (Mon, 11 Oct 2010) | 1 line

  Tighter verbose format for skipped POs
........
  r18264 | miker | 2010-10-11 12:07:47 -0400 (Mon, 11 Oct 2010) | 1 line

  Working template-based batch bib updater!
........
  r18269 | phasefx | 2010-10-11 16:39:31 -0400 (Mon, 11 Oct 2010) | 2 lines

  initialize these lists just once to prevent display glitch
........
  r18271 | miker | 2010-10-11 16:41:37 -0400 (Mon, 11 Oct 2010) | 1 line

  dogfooding cleanup
........
  r18272 | miker | 2010-10-11 16:42:46 -0400 (Mon, 11 Oct 2010) | 1 line

  make the source selection less confusing, and improve some wording in the template section (more to come)
........
  r18274 | phasefx | 2010-10-11 17:42:48 -0400 (Mon, 11 Oct 2010) | 2 lines

  avoid race condition with post-save patron editor refresh and replicated databases
........
  r18277 | scottmk | 2010-10-12 09:40:14 -0400 (Tue, 12 Oct 2010) | 4 lines

  Incorporate upgrade # 0433 into the consolidated upgrade script.

  M    Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
........
  r18278 | miker | 2010-10-12 11:19:54 -0400 (Tue, 12 Oct 2010) | 1 line

  skip unknown order_by entries instead of erroring
........
  r18279 | miker | 2010-10-12 11:39:47 -0400 (Tue, 12 Oct 2010) | 1 line

  rearrangement for variable existance
........
  r18280 | miker | 2010-10-12 11:40:45 -0400 (Tue, 12 Oct 2010) | 1 line

  and ... use a function name that exists
........
  r18281 | miker | 2010-10-12 12:02:31 -0400 (Tue, 12 Oct 2010) | 1 line

  now that we are working again, hush the warnings (osrfLogInternal to the rescue)
........
  r18282 | atz | 2010-10-12 13:01:52 -0400 (Tue, 12 Oct 2010) | 1 line

  Be sure to copy new JS files from OpenSRF on a FULL update/install
........
  r18285 | miker | 2010-10-12 15:23:22 -0400 (Tue, 12 Oct 2010) | 1 line

  improve labeling and documentation
........
  r18286 | phasefx | 2010-10-12 15:34:35 -0400 (Tue, 12 Oct 2010) | 1 line

  add option for hiding entire embedded browser toolbar
........
  r18287 | phasefx | 2010-10-12 15:34:39 -0400 (Tue, 12 Oct 2010) | 1 line

  allow util.deck to be instantiated with either a xul deck object or a xul deck id
........
  r18288 | phasefx | 2010-10-12 15:34:50 -0400 (Tue, 12 Oct 2010) | 1 line

  vertical bib summary (mainly for use in the Merge Record interface).  I tried using just bib_brief.xul with document.loadOverlay to choose between bib_brief_overlay_vertical.xul and bib_brief_overlay.xul based on a param, but was running into too much pain going that route.
........
  r18289 | phasefx | 2010-10-12 15:35:42 -0400 (Tue, 12 Oct 2010) | 2 lines

  new record merge UI.  needs r18287, r18288.  I'll backport them all together
........
  r18290 | miker | 2010-10-12 15:55:58 -0400 (Tue, 12 Oct 2010) | 1 line

  more terminology cleanup and inline documentation
........
  r18291 | miker | 2010-10-12 16:31:31 -0400 (Tue, 12 Oct 2010) | 1 line

  Get rid of commas, apparently confusing; make action button label more generic / less "developery"
........
  r18293 | miker | 2010-10-12 17:31:33 -0400 (Tue, 12 Oct 2010) | 1 line

  when we have no target field, add the entire source field, even when we have a subfield designation
........
  r18294 | phasefx | 2010-10-12 17:32:21 -0400 (Tue, 12 Oct 2010) | 1 line

  entry points for miker_'s batch marc editor
........
  r18298 | miker | 2010-10-12 20:27:46 -0400 (Tue, 12 Oct 2010) | 1 line

  deduplicate bibs going into the merge queue
........
  r18299 | miker | 2010-10-12 20:28:43 -0400 (Tue, 12 Oct 2010) | 1 line

  arg, missing semicolon
........
  r18300 | miker | 2010-10-12 20:29:38 -0400 (Tue, 12 Oct 2010) | 1 line

  double-arg, backwards logic
........
  r18303 | miker | 2010-10-12 22:33:59 -0400 (Tue, 12 Oct 2010) | 1 line

  thinko supporting multiple rules of the same type in in-line merge rulesets
........
  r18310 | phasefx | 2010-10-13 12:03:25 -0400 (Wed, 13 Oct 2010) | 2 lines

  missing semicolon
........
  r18311 | erickson | 2010-10-13 12:13:23 -0400 (Wed, 13 Oct 2010) | 1 line

  when the target for an event is no longer around, immediately invalidate the event and prevent the event from bubbling up for further processing
........
  r18312 | miker | 2010-10-13 12:17:14 -0400 (Wed, 13 Oct 2010) | 1 line

  Use just one transaction, and inside an rstore editor no less, for fleshing env paths
........
  r18313 | phasefx | 2010-10-13 12:30:38 -0400 (Wed, 13 Oct 2010) | 1 line

  overzealous trimming of cat.properties
........
  r18321 | scottmk | 2010-10-13 14:53:56 -0400 (Wed, 13 Oct 2010) | 22 lines

  Changes to the treatment of ORDER BY:

  1. For json_query: when ORDER BY is expressed as an object keyed on class
  (instead of an array of field specifications), and the class is not in
  scope, error out instead of silently ignoring the class.

  The other changes affect only methods other than json_query:

  2. When the ORDER BY list is provided as a raw text string: block any
  string containing a semicolon, in order to block simple SQL injections.
  For now we make no exceptions for quoted semicolons, which are not
  likely ever to appear an an ORDER BY clause.

  3. Keep virtual fields out of the ORDER BY clause.  For now we silently
  ignore them, as we ignore non-existent fields.  In both cases we should
  perhaps error out.

  4. Don't require that a class referenced in the ORDER BY clause also be
  referenced in the SELECT clause.  Just make sure it's in scope.

  M    Open-ILS/src/c-apps/oils_sql.c
........
  r18322 | erickson | 2010-10-13 16:16:57 -0400 (Wed, 13 Oct 2010) | 1 line

  clean up duplicate system-controlled penalties during penalty calculation; perform penalty trigger event creation after the standalone commit occurs.  todo, handle non-standalone post-commit penalty trigger event creation
........
  r18323 | erickson | 2010-10-13 16:16:58 -0400 (Wed, 13 Oct 2010) | 1 line

  default to standard cstore instead of rstore for env building editor
........
  r18326 | phasefx | 2010-10-14 11:29:29 -0400 (Thu, 14 Oct 2010) | 2 lines

  change the Swap Editor button to a persisted checkbox
........
  r18329 | miker | 2010-10-14 14:13:20 -0400 (Thu, 14 Oct 2010) | 1 line

  correct top-half ordering by label_sortkey
........
  r18331 | miker | 2010-10-14 14:35:27 -0400 (Thu, 14 Oct 2010) | 1 line

  patch from Steve Callendar to avoid resetting the passwd every time a phone number changes
........
  r18333 | miker | 2010-10-14 15:18:11 -0400 (Thu, 14 Oct 2010) | 1 line

  cast label_sortkey to bytea in order to get ascii-betical sorting in any locale, even C. stupid glibc ...
........
  r18336 | miker | 2010-10-14 15:33:41 -0400 (Thu, 14 Oct 2010) | 1 line

  backward compat indexing for label instead of label_sortkey
........
  r18342 | erickson | 2010-10-14 15:57:42 -0400 (Thu, 14 Oct 2010) | 1 line

  repaired upgrade version
........
  r18343 | miker | 2010-10-14 16:04:05 -0400 (Thu, 14 Oct 2010) | 1 line

  "as" not "to" ... you pointed that out the first time, miker, what is your deal?
........
  r18349 | miker | 2010-10-14 16:17:00 -0400 (Thu, 14 Oct 2010) | 1 line

  force granularity-only when any granularity is specified
........
  r18351 | erickson | 2010-10-14 18:17:21 -0400 (Thu, 14 Oct 2010) | 1 line

  If an item is captured for a hold, but not in transit (i.e. on holds shelf), set the destination_location equal to the pickup library (i.e where it's supposedly on the shelf).  This is useful for autmated sorting so that the item will return to the branch whose shelf where it belongs.
........
  r18353 | gmc | 2010-10-15 09:08:52 -0400 (Fri, 15 Oct 2010) | 7 lines

  tweak expanding search field aliases

  Avoids a glitch that can occur if a search field alias
  exists that happens to have the same name as a search field.

  Signed-off-by: Galen Charlton <gmc@esilibrary.com>
........
  r18364 | miker | 2010-10-16 11:32:32 -0400 (Sat, 16 Oct 2010) | 1 line

  use a function to wrap up escaping of solidus and casting to bytea, propogate to indexing and where/order_by
........
  r18365 | miker | 2010-10-16 11:35:39 -0400 (Sat, 16 Oct 2010) | 1 line

  need to update this index as well
........
  r18366 | miker | 2010-10-16 11:38:21 -0400 (Sat, 16 Oct 2010) | 1 line

  go ahead and use the new index if we need to
........

git-svn-id: svn://svn.open-ils.org/ILS/branches/serials-integration@18372 dcc99617-32d9-48b4-a31d-7c20da2025e4