Class: I2CE CustomReport: Difference between revisions

From IHRIS Wiki
No edit summary
No edit summary
Line 47: Line 47:
The constructor
The constructor
*Signature: public function __construct($report)
*Signature: public function __construct($report)
Parameters:
*Parameters:
* [http://www.php.net/manual/en/language.types.string.php string ] $report<br/>The report name
** [http://www.php.net/manual/en/language.types.string.php string ] $report <br/>The report name
===_generateCache()===
===_generateCache()===
*Signature: protected function _generateCache()
*Signature: protected function _generateCache()
===generateCache()===
===generateCache()===
Below is the code to actually handle generation of reports
Below is the code to actually handle generation of reports Generate the cached report
Generate the cached report
*Signature: public function generateCache($force,$cache_forms)
*Signature: public function generateCache($force,$cache_forms)
Parameters:
*Parameters:
* [http://www.php.net/manual/en/language.types.boolean.php boolean ] $force<br/>Defaults to false.  If set to true, it will force the regeneration of the report if it is in_progress
** [http://www.php.net/manual/en/language.types.boolean.php boolean ] $force <br/>Defaults to false.  If set to true, it will force the regeneration of the report if it is in_progress
**Default Value: false
***Default Value: false
* [http://www.php.net/manual/en/language.types.boolean.php boolean ] $cache_forms<br/>Defaults to True.  If set to true, it will cache the forms required by this report
** [http://www.php.net/manual/en/language.types.boolean.php boolean ] $cache_forms <br/>Defaults to True.  If set to true, it will cache the forms required by this report
**Default Value: true
***Default Value: true
===getCachedTableName()===
===getCachedTableName()===
Below is the static code to actually handle checking/setting the status of a cached report
Below is the static code to actually handle checking/setting the status of a cached report
*Signature: static public function getCachedTableName($report,$withDB,$table_prefix)
*Signature: static public function getCachedTableName($report,$withDB,$table_prefix)
Parameters:
*Parameters:
*$report  
*$report  
*$withDB  
*$withDB  
**Default Value: true
***Default Value: true
*$table_prefix  
*$table_prefix  
**Default Value: ''
***Default Value: ''
===getColumnsInReportTable()===
===getColumnsInReportTable()===
Get the actual columns in the cached report table
Get the actual columns in the cached report table
*Signature: static public function getColumnsInReportTable($report)
*Signature: static public function getColumnsInReportTable($report)
Parameters:
*Parameters:
*$report  
*$report  
===getCreateField()===
===getCreateField()===
*Signature: protected function getCreateField($form,$field,$name)
*Signature: protected function getCreateField($form,$field,$name)
Parameters:
*Parameters:
*$form  
*$form  
*$field  
*$field  
Line 83: Line 82:
*Signature: public function getFormRelationship()
*Signature: public function getFormRelationship()
===getFormsRequiredByReport()===
===getFormsRequiredByReport()===
Gets the forms required by the report
Gets the forms required by the report @param string $report
@param string $report
*Signature: public function getFormsRequiredByReport()
*Signature: public function getFormsRequiredByReport()
*Returns: [http://www.php.net/manual/en/language.types.array.php array ] of string
*Returns: [http://www.php.net/manual/en/language.types.array.php array ]<br/>of string
===getLastGenerationTime()===
===getLastGenerationTime()===
*Signature: static public function getLastGenerationTime($report)
*Signature: static public function getLastGenerationTime($report)
*Returns: mixed.  False on failure, int the time the last report generation  on sucess
*Parameters:
Parameters:
** [http://www.php.net/manual/en/language.types.string.php string ] $report <br/>The shortname for the report
* [http://www.php.net/manual/en/language.types.string.php string ] $report<br/>The shortname for the report
*Returns: mixed.<br/>False on failure, int the time the last report generation  on sucess
===getReportedFunctions()===
===getReportedFunctions()===
*Signature: protected function getReportedFunctions()
*Signature: protected function getReportedFunctions()
===getStatus()===
===getStatus()===
Get the status of the requested report
Get the status of the requested report
@param boolean hooman_readable defaults to false.
*Signature: static public function getStatus($report,$hooman_readable)
*Signature: static public function getStatus($report,$hooman_readable)
*Returns: [http://www.php.net/manual/en/language.types.string.php string ] 'does_not_exist','not_generated','generated','failed','in_progress', 'stale' if it is not hooman readable
*Parameters:
*
** [http://www.php.net/manual/en/language.types.string.php string ] $report @param boolean hooman_readable defaults to false.
Parameters:
* [http://www.php.net/manual/en/language.types.string.php string ] $report
*$hooman_readable  
*$hooman_readable  
**Default Value: false
***Default Value: false
*Returns: [http://www.php.net/manual/en/language.types.string.php string ]<br/>'does_not_exist','not_generated','generated','failed','in_progress', 'stale' if it is not hooman readable *
===hasFailed()===
===hasFailed()===
Checks to see if a report has failed in its generation
Checks to see if a report has failed in its generation
*Signature: static public function hasFailed($report)
*Signature: static public function hasFailed($report)
*Returns: mixed.  True if it has failed, false if it has not failed, null if the report does not exist.
*Parameters:
Parameters:
** [http://www.php.net/manual/en/language.types.string.php string ] $report
* [http://www.php.net/manual/en/language.types.string.php string ] $report
*Returns: mixed.<br/>True if it has failed, false if it has not failed, null if the report does not exist.
===isStale()===
===isStale()===
Check to see if a report is stale.
Check to see if a report is stale.
*Signature: static public function isStale($report)
*Signature: static public function isStale($report)
*Returns: [http://www.php.net/manual/en/language.types.boolean.php boolean ] true/false
*Parameters:
Parameters:
** [http://www.php.net/manual/en/language.types.string.php string ] $report
* [http://www.php.net/manual/en/language.types.string.php string ] $report
*Returns: [http://www.php.net/manual/en/language.types.boolean.php boolean ]<br/>true/false
===processReportingFunctions()===
===processReportingFunctions()===
*Signature: protected function processReportingFunctions()
*Signature: protected function processReportingFunctions()
Line 121: Line 117:
Checks to see if a report exists
Checks to see if a report exists
*Signature: static public function reportExists($report)
*Signature: static public function reportExists($report)
*Parameters:
** [http://www.php.net/manual/en/language.types.string.php string ] $report
*Returns: [http://www.php.net/manual/en/language.types.boolean.php boolean ]
*Returns: [http://www.php.net/manual/en/language.types.boolean.php boolean ]
Parameters:
* [http://www.php.net/manual/en/language.types.string.php string ] $report
===setStatus()===
===setStatus()===
Set the status us a report.
Set the status us a report.
*Signature: static public function setStatus($report,$status)
*Signature: static public function setStatus($report,$status)
Parameters:
*Parameters:
* [http://www.php.net/manual/en/language.types.string.php string ] $report
** [http://www.php.net/manual/en/language.types.string.php string ] $report
* [http://www.php.net/manual/en/language.types.string.php string ] $status
** [http://www.php.net/manual/en/language.types.string.php string ] $status
===setupQueries()===
===setupQueries()===
*Signature: protected function setupQueries()
*Signature: protected function setupQueries()

Revision as of 23:40, 16 October 2009

This article desrcibes the class I2CE_CustomReport.

I2CE_CustomReport

Variables

$config

The magic data node holding the configuration information for this report $var protected I2CE_MagicDataNode $config

  • Type: protected $config

$table

$var protected string $table the name of the cached table of the report

  • Type: protected $table

$tmp_table

$var protected string $tmp_table the temporary name of the cached table of the report

  • Type: protected $tmp_table

$db

The instance of the database to perform queries on.

  • Type: protected MDB2 $db

$populate_queries

an array of queries used to populate the cached reports table(s)

  • Type: protected y $populate_queries

$init_queries

an array of queries used to inialize the cached reports table(s)

  • Type: protected y $init_queries

$get_field_def

  • Type: protected MDB2_PreparedStatement $get_field_def

$report_table_cols

  • Type: static protected $report_table_cols

$hooman

  • Type: static protected $hooman

$reportedFunctions

  • Type: protected $reportedFunctions

Methods

__construct()

The constructor

  • Signature: public function __construct($report)
  • Parameters:

_generateCache()

  • Signature: protected function _generateCache()

generateCache()

Below is the code to actually handle generation of reports Generate the cached report

  • Signature: public function generateCache($force,$cache_forms)
  • Parameters:
    • boolean $force
      Defaults to false. If set to true, it will force the regeneration of the report if it is in_progress
      • Default Value: false
    • boolean $cache_forms
      Defaults to True. If set to true, it will cache the forms required by this report
      • Default Value: true

getCachedTableName()

Below is the static code to actually handle checking/setting the status of a cached report

  • Signature: static public function getCachedTableName($report,$withDB,$table_prefix)
  • Parameters:
  • $report
  • $withDB
      • Default Value: true
  • $table_prefix
      • Default Value:

getColumnsInReportTable()

Get the actual columns in the cached report table

  • Signature: static public function getColumnsInReportTable($report)
  • Parameters:
  • $report

getCreateField()

  • Signature: protected function getCreateField($form,$field,$name)
  • Parameters:
  • $form
  • $field
  • $name

getFormRelationship()

  • Signature: public function getFormRelationship()

getFormsRequiredByReport()

Gets the forms required by the report @param string $report

  • Signature: public function getFormsRequiredByReport()
  • Returns: array
    of string

getLastGenerationTime()

  • Signature: static public function getLastGenerationTime($report)
  • Parameters:
    • string $report
      The shortname for the report
  • Returns: mixed.
    False on failure, int the time the last report generation on sucess

getReportedFunctions()

  • Signature: protected function getReportedFunctions()

getStatus()

Get the status of the requested report

  • Signature: static public function getStatus($report,$hooman_readable)
  • Parameters:
    • string $report @param boolean hooman_readable defaults to false.
  • $hooman_readable
      • Default Value: false
  • Returns: string
    'does_not_exist','not_generated','generated','failed','in_progress', 'stale' if it is not hooman readable *

hasFailed()

Checks to see if a report has failed in its generation

  • Signature: static public function hasFailed($report)
  • Parameters:
  • Returns: mixed.
    True if it has failed, false if it has not failed, null if the report does not exist.

isStale()

Check to see if a report is stale.

  • Signature: static public function isStale($report)
  • Parameters:
  • Returns: boolean
    true/false

processReportingFunctions()

  • Signature: protected function processReportingFunctions()

reportExists()

Checks to see if a report exists

  • Signature: static public function reportExists($report)
  • Parameters:
  • Returns: boolean

setStatus()

Set the status us a report.

  • Signature: static public function setStatus($report,$status)
  • Parameters:

setupQueries()

  • Signature: protected function setupQueries()

Inherited Fuzzy Methods

userMessage()

This method is inherited from I2CE_Fuzzy->userMessage()