{

var $debug = false;

var $formats = array();

var $attributes = array();

var $default_attr = array();

function __construct()

{

$this->default_attr = $this->attributes;

}

function debug($val)

{

if ( $this->debug )

printf("<br>(X".get_class($this)."): $val\n");

}

function error($in_text)

{

trigger_error($in_text, E_USER_ERROR);

}

function & get_attribute ( $attrib_name )

{

$val = false;

if ( isset ( $this->attributes[$attrib_name] ) )

if ( $this->attributes[$attrib_name] )

{

$val = check_for_default($attrib_name, $this->attributes[$attrib_name]);

return $val;

}

else

{

$val = check_for_default($attrib_name, $this->attributes[$attrib_name]);

return $val;

}

else

return $val;

}

// Parses a Reportico value ( e.g. criteria default, criteria value )

// and if it indicates some kind of metavalue surrounded by {} then

// convert it

// Current syntax :-

// {constant,<VALUE>} - returns defined PHP constants

function & derive_meta_value ( $to_parse )

{

global $g_project;

$parsed = $to_parse;

if ( preg_match ( "/{constant,SW_PROJECT}/", $parsed ) )

{

$parsed = $g_project;

return $parsed;

}

else

if ( preg_match ( "/{constant,SW_DB_DRIVER}/", $parsed ) )

{

if ( defined("SW_DB_TYPE") && SW_DB_TYPE == "framework" )

$parsed = "framework";

else

{

$parsed = preg_replace('/{constant,([^}]*)}/',

'\1',

$parsed);

if ( defined ( $parsed ) )

$parsed = constant($parsed);

else

$parsed = "";

}

return $parsed;

}

else

if (

preg_match ( "/{constant,SW_DB_PASSWORD}/", $parsed ) ||

preg_match ( "/{constant,SW_DB_USER}/", $parsed ) ||

preg_match ( "/{constant,SW_DB_DATABASE}/", $parsed )

)

{

if ( defined("SW_DB_TYPE") && SW_DB_TYPE == "framework" )

$parsed = "";

else

{

$parsed = preg_replace('/{constant,([^}]*)}/',

'\1',

$parsed);

if ( defined ( $parsed ) )

$parsed = constant($parsed);

else

$parsed = "";

}

return $parsed;

}

else

if ( preg_match ( "/{constant,.*}/", $parsed ) )

{

$parsed = preg_replace('/{constant,([^}]*)}/',

'\1',

$parsed);

if ( defined ( $parsed ) )

$parsed = constant($parsed);

else

$parsed = "";

return $parsed;

}

else

return $parsed;

}

function & derive_attribute ( $attrib_name, $default )

{

if ( $this->attributes[$attrib_name] )

{

return $this->attributes[$attrib_name];

}

else

{

return $default;

}

}

function set_format ( $format_type, $format_value )

{

if ( !array_key_exists($format_type, $this->formats) )

handle_error("Format Type ".$format_type." Unknown.");

$this->formats[$format_type] = $format_value;

}

function get_format ( $format_type )

{

if ( !array_key_exists($format_type, $this->formats) )

return;

return $this->formats[$format_type];

}

function set_attribute ( $attrib_name, $attrib_value )

{

if ( !array_key_exists($attrib_name, $this->attributes ) )

return;

if ( $attrib_value )

$this->attributes[$attrib_name] = $attrib_value;

else

$this->attributes[$attrib_name] = $this->default_attr[$attrib_name];

}

function & get_value ( $value_name )

{

return $this->values[$value_name];

}

function set_value ( $value_name, $value_value )

{

$this->values[$value_name] = $value_value;

}

function submitted ( $value_name )

{

if ( array_key_exists($value_name, $_REQUEST) )

return true;

else

return false;

}

{

var $class = "reportico";

var $prepare_url;

var $menu_url;

var $admin_menu_url;

var $configure_project_url;

var $delete_project_url;

var $create_report_url;

var $version = "4.3";

var $name;

var $rowselection="all";

var $parent_query=false;

var $allow_maintain = "FULL";

var $embedded_report = false;

var $allow_debug = true;

var $user_template=false;

var $xmlin=false;

var $xmlout=false;

var $xmloutfile=false;

var $xmlintext=false;

var $xmlinput=false;

var $sqlinput=false;

var $datasource;

var $progress_text = "Ready";

var $progress_status = "Ready"; // One of READY, WORKING, FINISHED, ERROR

var $query_statement;

var $maintain_sql = false;

var $columns = array();

var $tables = array();

var $where_text;

var $group_text;

var $table_text;

var $sql_raw = false;

var $sql_limit_first = false;

var $sql_skip_offset = false;

var $display_order_set = array();

var $order_set = array();

var $group_set = array();

var $groups = array();

var $page_headers = array();

var $page_footers = array();

var $query_count = 0;

var $expand_col = false;

var $execute_mode;

var $match_column = "";

var $lookup_return_col = false;

var $lookup_queries = array();

var $source_type = "database";

var $source_datasource = false;

var $source_xml = false;

var $top_level_query = true;

var $clone_columns = array();

var $pre_sql = array();

var $graphs = array();

var $clearform = false;

var $first_criteria_selection = true;

var $menuitems = array();

var $dropdown_menu = false;

var $static_menu = false;

var $projectitems = array();

var $target_style = false;

var $target_format = false;

var $lineno = 0;

var $groupvals = array();

var $email_recipients = false;

var $drilldown_report = false;

var $forward_url_get_parameters="";

var $forward_url_get_parameters_graph="";

var $forward_url_get_parameters_dbimage="";

var $reportico_ajax_script_url=false;

var $reportico_ajax_called=false;

var $reportico_ajax_mode=true;

var $reportico_ajax_preloaded=false;

var $clear_reportico_session=false;

var $target_show_graph = false;

var $target_show_detail = false;

var $target_show_group_headers = false;

var $target_show_group_trailers = false;

var $target_show_column_headers = false;

var $target_show_criteria = false;

var $show_form_panel = false;

var $status_message = "";

var $framework_parent = false;

var $framework_type = false;

var $charting_engine = "PCHART";

var $charting_engine_html = "NVD3";

var $pdf_engine = "tcpdf";

var $pdf_engine_file = "reportico_report_fpdf";

var $projects_folder = "projects";

var $admin_projects_folder = "projects";

var $compiled_templates_folder = "templates_c";

var $attributes = array (

"ReportTitle" => "Set Report Title",

"ReportDescription" => false,

"PageSize" => ".DEFAULT",

"PageOrientation" => ".DEFAULT",

"TopMargin" => "",

"BottomMargin" => "",

"RightMargin" => "",

"LeftMargin" => "",

"pdfFont" => "",

"pdfFontSize" => "",

"PreExecuteCode" => "NONE",

"formBetweenRows" => "solidline",

//"bodyDisplay" => "show",

//"graphDisplay" => "show",

"gridDisplay" => ".DEFAULT",

"gridSortable" => ".DEFAULT",

"gridSearchable" => ".DEFAULT",

"gridPageable" => ".DEFAULT",

"gridPageSize" => ".DEFAULT"

);

var $panels = array();

var $targets = array();

var $assignment = array();

var $criteria_links = array();

// Admin or normal login

var $login_type = "NORMAL";

// Output control

var $output_skipline = false;

var $output_allcell_styles = false;

var $output_header_styles = false;

var $output_hyperlinks = false;

var $output_images = false;

var $output_row_styles = false;

var $output_page_styles = false;

var $output_before_form_row_styles = false;

var $output_after_form_row_styles = false;

var $output_group_header_styles = false;

var $output_group_header_label_styles = false;

var $output_group_header_value_styles = false;

var $output_group_trailer_styles = false;

var $output_reportbody_styles = false;

var $admin_accessible = true;

// Template Parameters

var $output_template_parameters = array(

"show_hide_navigation_menu" => "show",

"show_hide_dropdown_menu" => "show",

"show_hide_report_output_title" => "show",

"show_hide_prepare_section_boxes" => "show",

"show_hide_prepare_pdf_button" => "show",

"show_hide_prepare_html_button" => "show",

"show_hide_prepare_print_html_button" => "show",

"show_hide_prepare_csv_button" => "show",

"show_hide_prepare_page_style" => "show",

);

// Template Parameters

// Charsets for in and output

var $db_charset = false;

var $output_charset = false;

// Currently edited links to other reports

var $reportlink_report = false;

var $reportlink_report_item = false;

var $reportlink_or_import = false;

// Three parameters which can be set from a calling script

// which can be incorporated into reportic queries

// For example a calling framework username can

// be passed so that data can be returned for that

// user

var $external_user = false;

var $external_param1 = false;

var $external_param2 = false;

var $external_param3 = false;

// Initial settings to set default project, report, execute mode. Set by

// application frameworks embedding reportico

var $initial_project = false;

var $initial_execute_mode = false;

var $initial_report = false;

var $initial_project_password = false;

var $initial_output_format = false;

var $initial_output_style = false;

var $initial_show_detail = false;

var $initial_show_graph = false;

var $initial_show_group_headers = false;

var $initial_show_group_trailers = false;

var $initial_show_column_headers = false;

var $initial_show_criteria = false;

var $initial_execution_parameters = false;

var $initial_sql = false;

// Access mode - one of FULL, ALLPROJECTS, ONEPROJECT, REPORTOUTPUT

var $access_mode = "FULL";

// Whether to show refresh button on report output

var $show_refresh_button = false;

// Whether to show print button on report output

var $show_print_button = true;

// Session namespace to use

var $session_namespace = false;

// Whether to perform drill downs in their own namespace (normally from embedding in frameworks

// where reportico namespaces are used within the framework session

var $drilldown_namespace = false;

// URL Path to Reportico folder

var $reportico_url_path = false;

// Path to Reportico runner for AJAX use or standalone mode

var $url_path_to_reportico_runner = false;

// Path to frameworks assets folder

var $url_path_to_assets = false;

// Path to public reportico site for help

var $url_doc_site = "http://www.reportico.org/documentation/";

// Path to public reportico site

var $url_site = "http://www.reportico.org/";

// Path to calling script for form actions

// In standalone mode will be the reportico runner, otherwise the

// script in which reportico is embedded

var $url_path_to_calling_script = false;

// external user parameters as specified in sql as {USER_PARAM,your_parameter_name}

// set with $q->user_parameters["your_parameter_name"] = "value";

var $user_parameters = array();

// Specify a pdo connection fexternally

var $external_connection = false;

var $bootstrap_styles = "3";

var $jquery_preloaded = false;

var $bootstrap_preloaded = false;

var $bootstrap_styling_page = "table table-striped table-condensed";

var $bootstrap_styling_button_go = "btn btn-success";

var $bootstrap_styling_button_reset = "btn btn-default";

var $bootstrap_styling_button_admin = "btn";

var $bootstrap_styling_button_delete = "btn btn-danger";

var $bootstrap_styling_dropdown = "form-control";

//var $bootstrap_styling_checkbox_button = "btn btn-default btn-xs";

var $bootstrap_styling_checkbox_button = "checkbox-inline";

var $bootstrap_styling_checkbox = "checkbox";

var $bootstrap_styling_toolbar_button = "btn";

var $bootstrap_styling_htabs = "nav nav-justified nav-tabs nav-tabs-justified ";

var $bootstrap_styling_vtabs = "nav nav-tabs nav-stacked";

var $bootstrap_styling_design_dropdown = "form-control";

var $bootstrap_styling_textfield = "form-control";

var $bootstrap_styling_design_ok = "btn btn-success";

var $bootstrap_styling_menu_table = "table";

var $bootstrap_styling_small_button = "btn btn-sm btn-default";

// Dynamic grids

var $dynamic_grids = false;

var $dynamic_grids_sortable = true;

var $dynamic_grids_searchable = true;

var $dynamic_grids_paging = false;

var $dynamic_grids_page_size = 10;

// Dynamic grids

var $parent_reportico = false;

// For laravel ( and other frameworks supporting multiple connections ) specifies

// an array of available databases to connect ot

var $available_connections=array();

// In bootstrap enabled 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

var $force_reportico_mini_maintains = false;

// Array to hold plugins

var $plugins = array();

function __construct()

{

reportico_object::__construct();

$this->parent_query =& $this;

}

// Dummy functions for yii to work with Reportico

function init()

{

}

function getIsInitialized()

{

return true;

}

// End Yii functions

function &create_graph()

{

$engine = $this->charting_engine;

if ( $this->target_format == "HTML" )

$engine = $this->charting_engine_html;

if ( get_request_item("target_format", "HTML") == "PDF" )

$engine = $this->charting_engine;

// Cannot use two forms of charting in the same

if ( !class_exists("reportico_graph", false) )

switch ( $engine )

{

case "NVD3":

require_once('swgraph_nvd3.php');

break;

case "FLOT":

require_once('swgraph_flot.php');

break;

case "JPGRAPH":

require_once('swgraph.php');

break;

case "PCHART":

default:

require_once('swgraph_pchart.php');

break;

}

$graph = new reportico_graph($this, "internal");

$this->graphs[] =& $graph;

return $graph;

}

/*

** In AJAX mode, all links, buttons etc will be served by ajax call to

** to runner script or specified ajax script, otherwise they will

** call the initial calling script

*/

function get_action_url()

{

$calling_script = $this->url_path_to_calling_script;

if ( $this->reportico_ajax_mode )

$calling_script = $this->reportico_ajax_script_url;

return $calling_script;

}

function &get_graph_by_name($in_query)

{

$graphs = array();

foreach ( $this->graphs as $k => $v )

{

if ( $v->graph_column == $in_query )

{

$graphs[] =& $this->graphs[$k];

}

}

return $graphs;

}

function query_display()

{

foreach ( $this->columns as $col )

{

echo $col->query_name;

echo " ".$col->table_name.".".$col->column_name;

echo " ".$col->column_type;

echo " ".$col->column_length;

echo " ".$col->in_select;

echo "<br>\n";

}

}

function request_display()

{

while ( list($id, $val) = each($_REQUEST) )

{

echo "<b>$id</b><br>";

var_dump($val);

echo "<br>";

}

}

function set_datasource(&$datasource)

{

$this->datasource =& $datasource;

foreach ( $this->columns as $k => $col )

{

$this->columns[$k]->set_datasource($this->datasource);

}

}

function display_columns()

{

foreach ( $this->columns as $k => $col )

{

echo "$k Data: $col->datasource Name: $col->query_name<br>";

}

}

// -----------------------------------------------------------------------------

// Function : set_lookup_return

// -----------------------------------------------------------------------------

function set_lookup_return($query_name)

{

foreach($this->columns as $k => $v )

{

$this->columns[$k]->lookup_return_flag = false;

}

if ( $cl = get_query_column($query_name, $this->columns ) )

{

$col =& $cl ;

$col->lookup_return_flag = true;

$this->lookup_return_col =& $col;

}

}

// -----------------------------------------------------------------------------

// Function : set_column_format

// -----------------------------------------------------------------------------

function set_column_format($query_name, $format_type, $format_value )

{

$this->check_column_name("set_column_format", $query_name);

if ( $cl =&get_query_column($query_name, $this->columns ) )

{

$col =& $cl ;

$col->set_format($format_type, $format_value);

}

}

// -----------------------------------------------------------------------------

// Function : set_group_format

// -----------------------------------------------------------------------------

function set_group_format($query_name, $format_type, $format_value )

{

$this->check_group_name("set_group_format", $query_name);

if ( array_key_exists($query_name, $this->group) )

{

$col =& $this->group[$query_name] ;

$col->set_format($format_type, $format_value);

}

}

// -----------------------------------------------------------------------------

// Function : add_pre_sql

// -----------------------------------------------------------------------------

function add_pre_sql($in_sql)

{

$this->pre_sql[] = $in_sql;

}

// -----------------------------------------------------------------------------

// Function : set_lookup_display

// -----------------------------------------------------------------------------

function set_lookup_display($query_name, $abbrev_name = false)

{

if ( !$query_name )

return;

if ( !$this->check_column_name_r("set_lookup_display", $query_name) )

{

handle_error( "Failure in Lookup Display: Unknown Column Name $query_name");

return;

}

if ( $cl = get_query_column($query_name, $this->columns ) )

{

foreach ( $this->columns as $k => $v )

{

$this->columns[$k]->lookup_display_flag = false;

$this->columns[$k]->lookup_abbrev_flag = false;

}

$cl->lookup_display_flag = true;

if ( $abbrev_name )

{

$col2 = get_query_column($abbrev_name, $this->columns ) ;

$col2->lookup_abbrev_flag = true;

}

else

$cl->lookup_abbrev_flag = true;

}

}

// -----------------------------------------------------------------------------

// Function : set_lookup_expand_match

// -----------------------------------------------------------------------------

function set_lookup_expand_match($match_column)

{

$this->match_column = $match_column;

}

// -----------------------------------------------------------------------------

// Function : check_page_header_name

// -----------------------------------------------------------------------------

function check_page_header_name($in_scope, $in_name)

{

if ( !array_key_exists($in_name, $this->page_headers) )

{

handle_error("$in_scope: Group $in_name unknown");

}

}

// -----------------------------------------------------------------------------

// Function : check_page_footer_name

// -----------------------------------------------------------------------------

function check_page_footer_name($in_scope, $in_name)

{

if ( !array_key_exists($in_name, $this->page_footers) )

{

handle_error("$in_scope: Group $in_name unknown");

}

}

// -----------------------------------------------------------------------------

// Function : check_group_name_r

// -----------------------------------------------------------------------------

function check_group_name_r($in_scope, $in_column_name)

{

if ( !($qc = get_group_column($in_column_name, $this->groups ) ) )

{

handle_error( "$in_scope: Group $in_column_name unknown");

return(false);

}

else

return true;

}

// -----------------------------------------------------------------------------

// Function : check_group_name

// -----------------------------------------------------------------------------

function check_group_name($in_scope, $in_column_name)

{

if ( !($qc = get_group_column($in_column_name, $this->groups ) ) )

{

handle_error("$in_scope: Group $in_column_name unknown");

}

}

// -----------------------------------------------------------------------------

// Function : check_column_name_r

// -----------------------------------------------------------------------------

function check_column_name_r($in_scope, $in_column_name)

{

if ( ! ($cl = get_query_column($in_column_name, $this->columns )) )

{

handle_error( "$in_scope: Column $in_column_name unknown");

return false;

}

else

return true;

}

// -----------------------------------------------------------------------------

// Function : check_column_name

// -----------------------------------------------------------------------------

function check_column_name($in_scope, $in_column_name)

{

if ( ! ($cl = get_query_column($in_column_name, $this->columns )) )

{

handle_error("$in_scope: Column $in_column_name unknown");

}

}

// -----------------------------------------------------------------------------

// Function : check_criteria_name

// -----------------------------------------------------------------------------

function check_criteria_name($in_scope, $in_column_name)

{

if ( !array_key_exists($in_column_name, $this->lookup_queries) )

{

handle_error("$in_scope: Column $in_column_name unknown");

}

}

// -----------------------------------------------------------------------------

// Function : check_criteria_name_r

// -----------------------------------------------------------------------------

function check_criteria_name_r($in_scope, $in_column_name)

{

if ( !array_key_exists($in_column_name, $this->lookup_queries) )

{

//handle_error("$in_scope: Column $in_column_name unknown");

return false;

}

return true;

}

// -----------------------------------------------------------------------------

// Function : set_criteria_link

// -----------------------------------------------------------------------------

function set_criteria_link($link_from, $link_to, $clause, $link_number=-1)

{

if ( !$this->check_criteria_name_r("set_criteria_link", $link_from))

{

handle_error( "Failure in Criteria Link: Unknown Lookup Name $link_from");

return;

}

if ( !$this->check_criteria_name_r("set_criteria_link", $link_to))

{

handle_error( "Failure in Criteria Link: Unknown Lookup Name $link_to");

return;

}

//$lf =& $this->columns[$link_from];

//$lt =& $this->columns[$link_to];

//$lfq =& $lf->lookup_query;

//$ltq =& $lt->lookup_query;

$lfq =& $this->lookup_queries[$link_from]->lookup_query;

$ltq =& $this->lookup_queries[$link_to]->lookup_query;

if ( !$lfq )

handle_error("set_criteria_link: No Lookup For $link_from");

$this->lookup_queries[$link_from]->lookup_query->add_criteria_link($clause, $link_from, $link_to, $ltq, $link_number);

}

// -----------------------------------------------------------------------------

// Function : add_criteria_link

// -----------------------------------------------------------------------------

function add_criteria_link($clause, $link_from, $link_to, &$query, $link_number = -1)

{

if ( $link_number != -1 )

$this->criteria_links[$link_number] =

array(

"clause" => $clause,

"link_from" => $link_from,

"tag" => $link_to,

"query" => &$query

);

else

$this->criteria_links[] =

array(

"clause" => $clause,

"link_from" => $link_from,

"tag" => $link_to,

"query" => &$query

);

}

// -----------------------------------------------------------------------------

// Function : set_criteria_type

// -----------------------------------------------------------------------------

function set_criteria_type($query_name, $criteria_type)

{

$this->check_column_name("set_criteria_ltype", $query_name);

if ( ($cl =&get_query_column($query_name, $this->columns )) )

{

$cl->set_criteria_type($criteria_type);

}

}

// -----------------------------------------------------------------------------

// Function : set_criteria_help

// -----------------------------------------------------------------------------

function set_criteria_help($query_name, $criteria_help)

{

$this->check_criteria_name("set_criteria_defaults", $query_name);

if ( array_key_exists($query_name, $this->lookup_queries) )

{

$col =& $this->lookup_queries[$query_name] ;

$col->set_criteria_help($criteria_help);

}

}

// -----------------------------------------------------------------------------

// Function : set_criteria_link_report

// -----------------------------------------------------------------------------

function set_criteria_link_report($in_query, $in_report, $in_report_item)

{

if ( array_key_exists($in_query, $this->lookup_queries) )

{

$col =& $this->lookup_queries[$in_query] ;

$col->set_criteria_link_report($in_report, $in_report_item);

$col->set_datasource($this->datasource);

}

}

// -----------------------------------------------------------------------------

// Function : set_criteria_input

// -----------------------------------------------------------------------------

function set_criteria_input($in_query, $in_source, $in_display, $in_expand_display = false, $_use = "")

{

if ( array_key_exists($in_query, $this->lookup_queries) )

{

$col =& $this->lookup_queries[$in_query] ;

$col->set_criteria_input($in_source, $in_display, $in_expand_display, $_use);

$col->set_datasource($this->datasource);

}

}

// -----------------------------------------------------------------------------

// Function : set_criteria_lookup

// -----------------------------------------------------------------------------

function set_criteria_lookup($query_name, &$lookup_query, $in_table, $in_column)

{

if ( array_key_exists ( $query_name, $this->lookup_queries ) )

{

}

else

{

$this->lookup_queries[$query_name] = new reportico_criteria_column(

$this,

$query_name,

$in_table,

$in_column,

"CHAR",

0,

"###.##",

0

);

$this->set_criteria_attribute($query_name, "column_title", $query_name);

$lookup_query->set_datasource($this->datasource);

}

$this->parent_query =& $this;

$this->lookup_queries[$query_name]->set_criteria_lookup($lookup_query);

$this->lookup_queries[$query_name]->first_criteria_selection = $this->first_criteria_selection;

$this->lookup_queries[$query_name]->lookup_query->parent_query =& $this;

}

// -----------------------------------------------------------------------------

// Function : set_criteria_list

// -----------------------------------------------------------------------------

function set_criteria_list($query_name, $in_list)

{

$this->check_criteria_name("set_criteria_list", $query_name);