Class: I2CE CustomReport (4.1.4)

For other versions, see Class: I2CE_CustomReport (versions) .

This article describes the class I2CE_CustomReport .

• Extends the class: I2CE_Fuzzy.
• Location: Part of the module CustomReports in the package I2CE 4.1.4-release
• Source: Defined in the file modules/CustomReports/lib/I2CE_CustomReport.php on line 29
• Author: Carl Leitner <litlfred@ibiblio.org>

I2CE_CustomReport

Variables

$config

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 35
• Type: protected $config

$table

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 42
• Type: protected $table

$tmp_table

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 47
• Type: protected $tmp_table

$db

The instance of the database to perform queries on.

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 52
• Type: protected MDB2 $db

$populate_queries

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 58
• Type: protected array $populate_queries

$id_length

The length for the id and parent columns in cached report tables.

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 63
• Type: protected integer $id_length

$get_field_def

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 109
• Type: protected MDB2_PreparedStatement $get_field_def

$report_table_cols

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 112
• Type: static protected $report_table_cols

$hooman

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 244
• Type: static protected $hooman

$reportedFunctions

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 558
• Type: protected $reportedFunctions

Methods

__construct()

The constructor

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 70
• Signature: public function __construct($report)
• Parameters:
  • string $report
    The report name

_generateCache()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 470
• Signature: protected function _generateCache()

dropTable()

Drop the zebra_XXX table

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 459
• Signature: public function dropTable($update_status)
• Parameters:
  • $update_status
    • Default Value: true

generateCache()

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 397
• 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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 159
• Signature: static public function getCachedTableName($report,$withDB,$table_prefix,$counter)
• Parameters:
  • $report
  • $withDB
    • Default Value: true
  • $table_prefix
    • Default Value:
  • $counter
    • Default Value: false

getColumnsInReportTable()

Get the actual columns in the cached report table

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 117
• Signature: static public function getColumnsInReportTable($report)
• Parameters:
  • $report

getCreateField()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 1114
• Signature: protected function getCreateField($form,$field,$name)
• Parameters:
  • $form
  • $field
  • $name

getFormRelationship()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 102
• Signature: public function getFormRelationship()

getFormsRequiredByReport()

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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 146
• Signature: public function getFormsRequiredByReport()
• Returns: array
  of string

getLastGenerationTime()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 370
• 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

getQueryAsName()

Return the array or string with the portion before the ' AS ' removed.

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 607
• Signature: static public function getQueryAsName($selects)
• Parameters:
  • mixed $selects
• Returns: mixed

getReportedFunctions()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 560
• Signature: protected function getReportedFunctions()

getReports()

Get all available report

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 194
• Signature: static public function getReports()

getSingleQueryAsName()

Return the named as value for a select query. e.g. `demographic`.`id` AS `demographic+id` would return `demographic+id`

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 592
• Signature: static public function getSingleQueryAsName($select)
• Parameters:
  • string $select
• Returns: string

getStatus()

Get the status of the requested report

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 274
• 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

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 216
• Signature: static public function hasFailed($report)
• Parameters:
  • string $report
• Returns: mixed.
  True if it has failed, false if it has not failed, null if the report does not exist.

hooman()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 245
• Signature: static protected function hooman($key)
• Parameters:
  • $key

isStale()

Check to see if a report is stale.

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 318
• Signature: static public function isStale($report)
• Parameters:
  • string $report
• Returns: boolean
  true/false

reportExists()

Checks to see if a report exists

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 203
• Signature: static public function reportExists($report)
• Parameters:
  • string $report
• Returns: boolean

setStatus()

Set the status us a report.

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 306
• Signature: static public function setStatus($report,$status)
• Parameters:
  • string $report
  • string $status

setupQueries()

• Defined in i2ce/modules/CustomReports/lib/I2CE_CustomReport.php on line 617
• Signature: protected function setupQueries()

Inherited Methods

_hasMethod()

This public method is inherited from I2CE_Fuzzy->_hasMethod()

Inherited Fuzzy Methods

userMessage()

This method is inherited from I2CE_Fuzzy->userMessage()