contrib/pines/report-creator.git
2 years agodo not print PHP errors on screen master
Chris Sharp [Mon, 21 Mar 2022 20:50:39 +0000 (16:50 -0400)]
do not print PHP errors on screen

3 years agoexplicitly name current dir for Perl 5.26+, part II
Chris Sharp [Thu, 1 Jul 2021 14:25:18 +0000 (10:25 -0400)]
explicitly name current dir for Perl 5.26+, part II

3 years agoexplicitly name current dir for Perl 5.26+
Chris Sharp [Thu, 1 Jul 2021 14:17:31 +0000 (10:17 -0400)]
explicitly name current dir for Perl 5.26+

3 years agorestore file modes
Chris Sharp [Mon, 22 Mar 2021 14:21:36 +0000 (10:21 -0400)]
restore file modes

3 years agoVersion 5 template additions
Adam Bowling [Wed, 26 Aug 2020 19:58:14 +0000 (15:58 -0400)]
Version 5 template additions

4 years agoadd another 18.04 prereq
Chris Sharp [Thu, 23 Apr 2020 15:17:14 +0000 (11:17 -0400)]
add another 18.04 prereq

4 years agoupdate to latest PHP 7
Chris Sharp [Thu, 23 Apr 2020 15:15:01 +0000 (11:15 -0400)]
update to latest PHP 7

4 years agoremove 14.04 support and add 18.04 support
Chris Sharp [Thu, 23 Apr 2020 14:47:45 +0000 (10:47 -0400)]
remove 14.04 support and add 18.04 support

5 years agoAdds category for "Acquisitions" to Quick Reports categories.
Adam Bowling [Tue, 1 Oct 2019 18:51:55 +0000 (14:51 -0400)]
Adds category for "Acquisitions" to Quick Reports categories.

Signed-off-by: Adam Bowling <abowling@emeralddata.net>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
5 years agomore de-PINES-fication
Chris Sharp [Fri, 22 Mar 2019 16:59:02 +0000 (12:59 -0400)]
more de-PINES-fication

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
5 years agoDe-PINES-ify master and fix a spacing issue in the footer.
Chris Sharp [Fri, 22 Mar 2019 16:46:10 +0000 (12:46 -0400)]
De-PINES-ify master and fix a spacing issue in the footer.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
5 years agoExclude all items that are attached to systems in all queries.
Chris Sharp [Wed, 6 Feb 2019 22:29:03 +0000 (17:29 -0500)]
Exclude all items that are attached to systems in all queries.

6 years agoFix Circulation by MARC item type query.
Chris Sharp [Fri, 14 Sep 2018 18:57:57 +0000 (14:57 -0400)]
Fix Circulation by MARC item type query.

Previously, this query was making use of the "circ_as_type" item
attribute, which is not the same thing as the MARC type of the item,
which is defined in the fixed field of the MARC record.

6 years agoPoint to the master database rather than the read-only database.
Chris Sharp [Sun, 14 Jan 2018 19:35:06 +0000 (14:35 -0500)]
Point to the master database rather than the read-only database.

Because of a misconfiguration in GenaSYS (since fixed), the QR
configuration file pulled the reports *database* connection info
rather than the *state_store* (e.g. master) database.  Fixed with
this change.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
6 years agotypo fix
Chris Sharp [Wed, 3 Jan 2018 14:13:47 +0000 (09:13 -0500)]
typo fix

6 years agoadding php7.0 apache module to dependencies for 16.04
Chris Sharp [Wed, 3 Jan 2018 14:09:44 +0000 (09:09 -0500)]
adding php7.0 apache module to dependencies for 16.04

6 years agoadd php 7.0 support
Chris Sharp [Wed, 3 Jan 2018 00:40:39 +0000 (19:40 -0500)]
add php 7.0 support

6 years agoAdds memcached session setting for >=PHP7.0
Adam Bowling [Tue, 2 Jan 2018 18:32:21 +0000 (13:32 -0500)]
Adds memcached session setting for >=PHP7.0

Signed-off-by: Adam Bowling <abowling@emeralddata.net>
6 years agoExtends MemcachedSession class for >= PHP7.0 support.
Adam Bowling [Tue, 2 Jan 2018 18:24:34 +0000 (13:24 -0500)]
Extends MemcachedSession class for >= PHP7.0 support.

Signed-off-by: Adam Bowling <abowling@emeralddata.net>
6 years agoExclude transits for items miscataloged at the system level.
Chris Sharp [Fri, 1 Dec 2017 19:35:50 +0000 (14:35 -0500)]
Exclude transits for items miscataloged at the system level.

While not a common issue, if any items that are miscataloged
with an owning library of a PINES system rather than branch,
the consolidation step fails because there's more than one
row returned from a subquery expecting a single value.  Explicitly
exclude any items owned by units with a parent_ou of 1 (PINES).

7 years agoFix variable assignments.
Chris Sharp [Wed, 12 Jul 2017 23:04:39 +0000 (19:04 -0400)]
Fix variable assignments.

7 years agoAdding 16.04 support to install script.
Chris Sharp [Wed, 12 Jul 2017 22:46:10 +0000 (18:46 -0400)]
Adding 16.04 support to install script.

7 years agoAdding Chris DeBellis's feature additions:
Chris Sharp [Mon, 8 May 2017 16:15:49 +0000 (12:15 -0400)]
Adding Chris DeBellis's feature additions:

- the user can now import report templates that use Year and Year-Month
  dates instead of actual dates
- The user can import report templates with 'contains matching substring'.

7 years agoexclude git files from rsync
Chris Sharp [Sun, 2 Apr 2017 13:13:30 +0000 (09:13 -0400)]
exclude git files from rsync

7 years agoadding check for root running the install script
Chris Sharp [Sun, 2 Apr 2017 13:10:42 +0000 (09:10 -0400)]
adding check for root running the install script

7 years agoLP#1586108 - Fix incorrectly formatted date.
Chris Sharp [Fri, 3 Mar 2017 13:05:49 +0000 (08:05 -0500)]
LP#1586108 - Fix incorrectly formatted date.

Fix authored by Chris DeBellis.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoadding perl query processes
Chris Sharp [Mon, 30 Jan 2017 19:48:17 +0000 (14:48 -0500)]
adding perl query processes

7 years agoAdding MS Word documentation for Executive Reports Admin
Chris Sharp [Sun, 15 Jan 2017 19:02:15 +0000 (14:02 -0500)]
Adding MS Word documentation for Executive Reports Admin

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoAdding Chris DeBellis's Executive Reports work
Chris Sharp [Sun, 15 Jan 2017 18:30:39 +0000 (13:30 -0500)]
Adding Chris DeBellis's Executive Reports work

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoFixing query up to make it work.
Chris Sharp [Wed, 30 Nov 2016 12:27:35 +0000 (07:27 -0500)]
Fixing query up to make it work.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoModify auth query to accommodate new-style EG auth.
Chris Sharp [Tue, 29 Nov 2016 20:01:05 +0000 (15:01 -0500)]
Modify auth query to accommodate new-style EG auth.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoFixing typo in SQL file.
Chris Sharp [Tue, 22 Nov 2016 15:41:16 +0000 (10:41 -0500)]
Fixing typo in SQL file.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoChange directory ownership after rsync.
Chris Sharp [Tue, 22 Nov 2016 14:49:24 +0000 (09:49 -0500)]
Change directory ownership after rsync.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoAdding installation script for Ubuntu 14.04
Chris Sharp [Tue, 22 Nov 2016 02:00:49 +0000 (21:00 -0500)]
Adding installation script for Ubuntu 14.04

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoPerform the DB table creation within a transaction, for safety.
Chris Sharp [Tue, 22 Nov 2016 01:49:13 +0000 (20:49 -0500)]
Perform the DB table creation within a transaction, for safety.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
7 years agoCreate ASCIIDoc versions of the documentation.
Chris Sharp [Tue, 22 Nov 2016 01:27:02 +0000 (20:27 -0500)]
Create ASCIIDoc versions of the documentation.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
8 years agoAdd custom permission to permission.permission_list in Evergreen db
Michael Peters [Thu, 28 Apr 2016 13:58:10 +0000 (09:58 -0400)]
Add custom permission to permission.permission_list in Evergreen db

The quick_reports_setup.sql was missing a crucial permission required
in the permission.permission_list in the Evergreen database.

This commit adds an insert of that permission.

Thank you to Brent Mills from Hood River Library for the discovery!

Signed-off-by: Michael Peters <mpeters@emeralddata.net>
8 years agoInitial public release of report-creator AKA Quick Reports
Chris DeBellis [Fri, 15 Apr 2016 18:08:15 +0000 (14:08 -0400)]
Initial public release of report-creator AKA Quick Reports

The initial public release of the report-creator tool (also known as
Quick Reports) commisioned by PINES and coded by Emerald Data Networks.

Additional credits for testing and documentation include the following:

Andrew Witter <awitter@emeralddata.net>
Darrell Rodgers <drodgers@emeralddata.net>
Joshua Lamos <jlamos@emeralddata.net>
Michael Peters <mpeters@emeralddata.net>
Terran McCanna <tmccanna@georgialibraries.org>
Chris Sharp <csharp@georgialibraries.org>

Signed-off-by: Michael Peters <mpeters@emeralddata.net>
8 years agoInitialize Git repository
Michael Peters [Thu, 14 Apr 2016 18:57:07 +0000 (14:57 -0400)]
Initialize Git repository

Signed-off-by: Michael Peters <mpeters@emeralddata.net>