Custom Reporting Plugin for CakePHP 2.x

The report manager plugin can help users to create reports based on the application's models.

Installation

Option 1: Manual

1. Download this: http://github.com/TribeHR/ad_hoc_reporting/zipball/master
2. Unzip that download.
3. Copy the resulting folder to app/Plugin
4. Rename the folder you just copied to AdHocReporting

Option 2: GIT Submodule

In your app directory type:

git submodule add git://github.com/TribeHR/ad_hoc_reporting.git Plugin/AdHocReporting
git submodule init
git submodule update

Option 3: GIT Clone

In your plugin directory type

git clone git://github.com/TribeHR/ad_hoc_reporting.git AdHocReporting

Setup

In app/Config/bootstrap.php add:

CakePlugin::load('AdHocReporting', array('bootstrap' => true, 'routes' => true));

Setup the AdHocReport table by running the SQL found in Config/Schema/ad_hoc_reports.sql

If you are using an ACL, add ACO entries for

• AdHocReporting/AdHocReports/index
• AdHocReporting/AdHocReports/add
• AdHocReporting/AdHocReports/delete
• AdHocReporting/AdHocReports/edit
• AdHocReporting/AdHocReports/wizard
• AdHocReporting/AdHocReports/view
• AdHocReporting/AdHocReports/duplicate

External dependencies

If http://opensource.box.com/spout/ library is available it is used for Excel creation.

Credits

This plugin is a fork of the plugin written by Luis Dias from March 11, 2013 http://github.com/luisdias/CakePHP-Report-Manager-Plugin

It was originally inspired by the Report Creator Component by Gene Kelly from Nov 9th 2006.
http://bakery.cakephp.org/articles/Gkelly/2006/11/09/report-creator-component

It also uses a Jquery plugin called SmartWizard by Tech Laboratory.
http://techlaboratory.net/products.php?product=smartwizard