forked from reportico-web/reportico
-
Notifications
You must be signed in to change notification settings - Fork 1
/
run.php
executable file
·301 lines (242 loc) · 14.3 KB
/
run.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
<?php
/*
Reportico - PHP Reporting Tool
Copyright (C) 2010-2014 Peter Deed
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* File: run.php
*
* Reportico runner script
*
* @link http://www.reportico.org/
* @copyright 2010-2014 Peter Deed
* @author Peter Deed <[email protected]>
* @package Reportico
* @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
* @version $Id: run.php,v 1.25 2014/05/17 15:12:31 peter Exp $
*/
// set error reporting level
error_reporting(E_ALL);
// Set the timezone according to system defaults
date_default_timezone_set(@date_default_timezone_get());
// Reserver 100Mb for running
ini_set("memory_limit","100M");
// Allow a good time for long reports to run. Set to 0 to allow unlimited time
ini_set("max_execution_time","90");
// Include Reportico - for embedding reportico in a script running from outside the Reportico directory,
// just include the full path to the file reportico.php
//require_once('<FULL_PATH_TO_REPORTICO>/reportico.php');
require_once('reportico.php');
// Only turn on output buffering if necessary, normally leave this uncommented
//ob_start();
$q = new reportico();
// In design mode, allow sql debugging
//$q->allow_debug = true;
// Specify any URL parameters that should be added into any links generated in Reportico.
// Useful when embedding in another application or frameworks where requests need to be channelled
// back though themselves
//$q->forward_url_get_parameters = "";
// Reportico Ajax mode. If set to true will run all reportico requests from buttons and links
// through AJAX, meaning reportico will refresh in its own window and not refresh the whole page
//$q->reportico_ajax_mode = true;
/*
** Initial execution states .. allows you to start user and limit user to specfic
** report menus, reports or report output
** The default behaviour is to show the Administration page on initial startup
*/
// Start user in specific project
//$q->initial_project = "<project>";
// If starting user in specific project then project passweord is required if one exists
// and you dont want user to have to type it in
//$q->initial_project_password = "<project password>";
// Specify a report to start user in specify the xml report file in the specified project folder
//$q->initial_report = "reportfile.xml";
// Specify whether user is started in administration page, project menu, report criteria entry,
// report output or report design mode, use respectively ( "ADMIN", "MENU", "PREPARE", "EXECUTE", "MAINTAIN")
// default is "ADMIN"
//$q->initial_execute_mode = "<MODE>";
// When only executing a report, indicates what format it should be showed in .. HTML(the default), PDF or CSV
//$q->initial_output_format = "HTML";
// When initial mode is report criteria entry or execution, these set the flags for whether report detail, group hears, columns headers
// etc are to be show. For example you might only want to run a report and show the graphs, by default all show except criteria
//$q->initial_show_detail = "show";
//$q->initial_show_graph = "show";
//$q->initial_show_group_headers = "show";
//$q->initial_show_group_trailers = "show";
//$q->initial_show_column_headers = "show";
//$q->initial_show_criteria = "show";
// Set default output style - TABLE = one row per record, FORM = one page per record
//$q->initial_output_style = "TABLE";
// Set source SQL to generate report from, without requirement for report , requires an initial_project to be defined for connection details
//$q->initial_sql = "SELECT column1 AS columntitle1, column2 AS columntitle2 FROM table";
// Set Report Title when running reort from an SQL statement above
// $q->set_attribute("ReportTitle", "Report Title");
// Specify access mode to limit what user can do, one of :-
// FULL - the default, allows user to log in under admin/design mode and design reports
// ALLPROJECTS - allows entry to admin page to select project but no ability to logon in admin/designer mode
// ONEPROJECT - allows entry to a single project and no access to the admin page
// ONEREPORT - limits user to single report, crtieria entry and report execution ( requires initial project/report )
// REPORTOUTPUT - executes a report and allows to "Return" button to crtieria entry ( requires initial project/report )
//$q->access_mode = "<MODE>";
// Generate report definition from SQL and set some column / report attributes
// Also the full report definition can be built up programmatically
// which requires further doicumentation
//$q->importSQL("SELECT column1 AS columntitle1, column2 AS columntitle2 FROM table");
//$q->get_column("column1")->set_attribute("column_display","hide");
//$q->get_column("column1")->set_attribute("column_title","Custom Title");
//$q->set_attribute("ReportTitle","New Report Title");
// Default initial execute mode to single report output if REPORTOUTPUT mode specified
if ( $q->access_mode == "REPORTOUTPUT" )
$q->initial_execute_mode = "EXECUTE";
// Provide an existing connection to Reportico, at the moment to use this there still needs to be project
// in existence, but the connection specified here will override the
// this allows you build create temporary tables and perform other actions prior to reporting
// $q->external_connection = false;
// try
// {
// $q->external_connection = new PDO("mysql:host=localhost; dbname=dbname", "username", "password" );
// }
// catch ( PDOException $ex )
// {
// $q->external_connection = false;
// // Handle Error
// }
// Specify alternate path to projects folder, templates_c folder
//$q->projects_folder = "projects";
//$q->admin_projects_folder = "projects";
//$q->compiled_templates_folder = "templates_c";
// For setting report criteria parameters.. use the criteria name as the key and the criteria value
// $q->initial_execution_parameters = array();
// $q->initial_execution_parameters["lookupcriteria"] = "value1,value2";
// $q->initial_execution_parameters["datecriteria"] = "2014-07-01";
// $q->initial_execution_parameters["datecriteria2"] = "TODAY";
// $q->initial_execution_parameters["daterangecriteria1"] = "2014-01-01-2014-02-01";
// $q->initial_execution_parameters["daterangecriteria2"] = "FIRSTOFMONTH-LASTOFMONTH";
// The session namespace to use. Only relevant when showing more than one report in a single page. Specify a name
// to store all session variables for this instance and then when running another report instance later in the script
// use another name
//$q->session_namespace = "namespace";
// Current user - when embedding reportico, you may wish to run queries by user. In this case
// set the current user here. Then you can use the construct {FRAMEWORK_USER} within your queries
//$q->external_user = "<CURRENT USER>";
// Indicates whether report output should include a refresh button
//$q->show_refresh_button = false;
// Set to true if you are embedding in another report
//$q->embedded_report = false;
// Set to true if you want to clear the report session whenever you call this script
// $q->clear_reportico_session = true;
// Specify an alternative AJAX runner from the stanfdard run.php
//$q->reportico_ajax_script_url = $_SERVER["SCRIPT_NAME"];
// If you want to connect to a reporting database whose connection information is available in the calling
// script, then you should configure your project connection type to "framework" using the configure project link
//and then you can pass your connection info here
//define('SW_FRAMEWORK_DB_DRIVER','pdo_mysql');
//define('SW_FRAMEWORK_DB_USER', '<USER>');
//define('SW_FRAMEWORK_DB_PASSWORD','PASSWORD');
//define('SW_FRAMEWORK_DB_HOST', '127.0.0.1'); // Use ip:port to specifiy a non standard port
//define('SW_FRAMEWORK_DB_DATABASE', '<DATABASENAME>');
// For passing external user parameters, can be referenced in SQL with {USER_PARAM,parameter_name}
// and can be referenced in custom SQL with $this->user_parameters
//$q->user_parameters["your_parameter_name"] = "your parameter value";
// Jquery already included?
//$q->jquery_preloaded = false;
// Bootstrap Features
// Set bootstrap_styles to false for reportico classic styles, or "3" for bootstrap 3 look and feel and 2 for bootstrap 2
// If you are embedding reportico and you have already loaded bootstrap then set bootstrap_preloaded equals true so reportico
// doestnt load it again.
//$q->bootstrap_styles = "3";
//$q->bootstrap_preloaded = false;
// In bootstrap enable pages, the bootstrap modal is by default used for the quick edit buttons
// but they can be ignored and reportico's own modal invoked by setting this to true
//$q->force_reportico_mini_maintains = false;
// Engine to use for charts ..
// HTML reports can use javascript charting, PDF reports must use PCHART
//$q->charting_engine = "PCHART";
//$q->charting_engine_html = "NVD3";
// Whether to turn on dynamic grids to provide searchable/sortable reports
// $q->dynamic_grids = true;
// $q->dynamic_grids_sortable = true;
// $q->dynamic_grids_searchable = true;
// $q->dynamic_grids_paging = false;
// $q->dynamic_grids_page_size = 10;
// Show or hide various report elements
//$q->output_template_parameters["show_hide_navigation_menu"] = "show";
//$q->output_template_parameters["show_hide_dropdown_menu"] = "show";
//$q->output_template_parameters["show_hide_report_output_title"] = "show";
//$q->output_template_parameters["show_hide_prepare_section_boxes"] = "hide";
//$q->output_template_parameters["show_hide_prepare_pdf_button"] = "show";
//$q->output_template_parameters["show_hide_prepare_html_button"] = "show";
//$q->output_template_parameters["show_hide_prepare_print_html_button"] = "show";
//$q->output_template_parameters["show_hide_prepare_csv_button"] = "show";
//$q->output_template_parameters["show_hide_prepare_page_style"] = "show";
//$q->output_template_parameters["show_hide_prepare_go_buttons"] = "hide";
//$q->output_template_parameters["show_hide_prepare_reset_buttons"] = "hide";
// Label for criteria section if required
// $q->criteria_block_label = "Report Criteria:";
// Static Menu definition
// ======================
// identifies the items that will show in the middle of the project menu page.
// If not set will use the project level menu definitions in project/projectname/menu.php
// To have no static menu ( for example if you just want to use a drop down then set to empty array )
// To define a static menu, follow the example here.
// report can be a valid report file ( without the xml suffix ).
// If title is left as AUTO then the title will be taken form the report definition
// Use title of BLANKLINE to separate items and LINE to draw a horizontal line separator
//$q->static_menu = array (
//array ( "report" => "an_xml_reportfile1", "title" => "<AUTO>" ),
//array ( "report" => "another_reportfile", "title" => "<AUTO>" ),
//array ( "report" => "", "title" => "BLANKLINE" ),
//array ( "report" => "anotherfreportfile", "title" => "Custom Title" ),
//array ( "report" => "", "title" => "BLANKLINE" ),
//array ( "report" => "andanother", "title" => "Another Custom Title" ),
//);
// To auto generate a static menu from all the xml report files in the project use
//$q->static_menu = array ( array ( "report" => ".*\.xml", "title" => "<AUTO>" ) );
// To hide the static report menu
//$q->static_menu = array ();
// Required PDF Engine set -- to tcpdf ( default ) or fpdf
//$q->pdf_engine = "fpdf";
// How CSV, PDF out is delivered to the browser ( TCPDF output only )
// either as
// "DOWNLOAD_SAME_WINDOW" - downloaded as attachment from within the current browser window ( default )
// "INLINE" - shown inside a new browser window making use of any existing browser PDF plugin (if not will download)
// "DOWNLOAD_NEW_WINDOW" - downloaded as attachment from winthin the current browser window
//$q->pdf_delivery_mode = "DOWNLOAD_SAME_WINDOW";
// Dropdown Menu definition
// ========================
// Menu items for the drop down menu
// Enter definition for the the dropdown menu options across the top of the page
// Each array element represents a dropdown menu across the page and sub array items for each drop down
// You must specifiy a project folder for each project entry and the reportfile definitions must point to a valid xml report file
// within the specified project
//$q->dropdown_menu = array(
// array (
// "project" => "projectname",
// "title" => "dropdown menu 1 title",
// "items" => array (
// array ( "reportfile" => "report" ),
// array ( "reportfile" => "anotherreport" ),
// )
// ),
// array (
// "project" => "projectname",
// "title" => "dropdown menu 2 title",
// "items" => array (
// array ( "reportfile" => "report" ),
// array ( "reportfile" => "anotherreport" ),
// )
// ),
// );
// Run the report
$q->execute();
//ob_end_flush();
?>