Scope collectionHQ extract to org unit + children

Enable collectionHQ extract functions to scope to a specified org
unit ID and that org unit's children. Specify a default org unit of
1 to closely reproduce previous behavior.

NOTE: Even with an org unit of 1, this work-in-progress changes
previous behavior due to requiring an asset.call_number with
owning_lib in scope. Previously ALL bibs were included.

Signed-off-by: Jeff Godin <jgodin@tadl.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
make sure deleted bibs are excluded

Belt-and-suspenders

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
fix bib query so that each bib is extracted only once

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
adding db backup scripts, and an overview README of how to use them

git-svn-id: svn://svn.open-ils.org/ILS-Contrib@835 6d9bc8c9-1ec2-4278-b937-99fde70a366f
doubled shebang noticed by bshum and gmcharlt -- thanks!

git-svn-id: svn://svn.open-ils.org/ILS-Contrib@836 6d9bc8c9-1ec2-4278-b937-99fde70a366f
modernize the README for database backups

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
various speed improvements to the collectionHQ extract

This is the result of a first pass to remove inefficient
queries on metabib.real_full_rec and auditor.asset_copy_history.

Most of the changes don't affect the output, but there are a
couple exceptions:

- the new version is more likely to pick the first 082$a
  for the class number (which is also more correct)
- the script now bases the "current use count" on the date that
  the item was last transited to the current circ lib, rather than
  the date the circ lib simply changed.

The last change is the most uncertain.  One the one hand, it helps
proof the extract against pruning of the asset.copy auditor table.
On the other hand, if items change their circ library without getting
formally transited (which might be theoretically possible for
some workflows) the current use count *might* be calculated
differently than expected.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
add copyright and sponsorship statement

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
collectionHQ: fix query to retrieve price from bib record

Also includes a bit of whitespace cleanup.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Evergreen report templates

Two sets of report templates for Evergreen.  These can
be installed using psql, e.g.,

psql -U evergreen < EvergreenReportTemplates.sql
psql -U evergreen < EvergreenAdditionalReportsTemplates.sql

EvergreenReportTemplates.sql contains patron, circulation, and cataloging
and collection reports, while EvergreenAdditionalReportsTemplates.sql
contains additional patron, circulation, cataloging, and acquisitions reports.

The reports were written by Shae Tetterton and packaged by Steve
Callender.  Sponsorship and testing were provided by Bibliomation,
the King County Library System, Kirtland Community College, and the
Pioneer Library System.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Adding eg-stats files for monitoring Evergreen services
Moved eg-stats under monitoring, updated README and added nagios plugins.
Cleaning up, eg-stats has been moved under monitoring.
README updated, typos fixed and prettyfied by Michael Tate.