SELECT column1, column2 FROM table WHERE userid = {FRAMEWORK_USER}To pass the user into Reportico you edit your runner script or the page that embeds Reportico to set a user as follows :-
$q->external_user = "USERID";
You can user a similar mechanism to passs other external values through the user_parameters array and then use them in the SQL. For example setting
$q->user_parameters["my_parameter"] = "my parameter value";allows to use them in the SQL with the USER_PARAM command :-
SELECT column1, column2 FROM table WHERE value = {USER_PARAM,my_parameter}
The bootstrap_styles parameter controls whether Reportico should render its reports according to Bootstrap styling or not. By default, when runing in standalone mode, Reportico renders in bootstrap V3 and loads its own bootstrap. When embedding to fit in with your own application, you may want to override this default. You have the choice of turning off bootstrap completely for example:-
require_once('reportico.php'); $q->bootstrap_styles = false; $q->execute();or rendering for bootstrap 2 or 3 and using the bootstrap_preloaded get Reportico to use a preloaded bootstrap to avoid reloading it itself. To specify boot strap v2 or 3, set bootstrap_styles to "2" or "3". For example:-
require_once('reportico.php'); $q->bootstrap_styles = "3"; $q->bootstrap_preloaded = true; $q->execute();
Since these files are published to the Yii2 public assets folder you should clear out the public foler containing these files so they can be republished.
$q->charting_engine_html = "NVD3";to read
$q->charting_engine_html = "NVD3"; if(preg_match('/(?i)msie [1-8]/',$_SERVER['HTTP_USER_AGENT'])) { $q->charting_engine_html = "PCHART"; }
Since these files are published to the Yii2 public assets folder you should clear out the public foler containing these files so they can be republished.