Properties

$sip

$sip : \qfq\SIP

Type

\qfq\SIP

$dbAlias

$dbAlias : string

Type

string

$frArray

$frArray : 

Type

$indexArray

$indexArray : 

Type

$levelCount

$levelCount : 

Type

$page_control

$page_control : 

Type

$fr_error

$fr_error : 

Type

$t3data

$t3data : 

Type

$phpUnit

$phpUnit : 

Type

$showDebugInfo

$showDebugInfo : 

Type

Methods

__construct()

__construct(array  $t3data,   $sessionName,   $phpUnit = false) 

Report constructor.

Parameters

array $t3data
$sessionName
$phpUnit

process()

process() : string

Main function. Parses bodytext and iterates over all queries.

Returns

string

parseFRLine()

parseFRLine(string  $ttLine) : void

Split line in level, command, content and fill 'frArray', 'levelCount', 'indexArray' Example: 10.50.5.sql = select * from person

Parameters

string $ttLine

: line to split in level, command, content

setLine()

setLine(  $level,   $frCmd,   $value) 

Parameters

$level
$frCmd
$value

sortIndexArray()

sortIndexArray(array  $ary, string  $clause,   $ascending = true) : \qfq\The

Sorts the associative array.

Parameters

array $ary

: The unsorted Level Array

string $clause

: the sort argument 0 ASC, 1 ASC... according to the number of columns

$ascending

Returns

\qfq\The —

content that is displayed on the website

generateSortArg()

generateSortArg() : string

generateSortArg

Returns

string

triggerReport()

triggerReport(integer  $cur_level = 1, string  $super_level_array = array(), integer  $counter) : string

Executes the queries recursive. This Method is called for each Sublevel.

ROOTLEVEL This method is called once from the main method. For the first call the method executes the rootlevels

SUBLEVEL For each rootlevel the method calls it self whith the levelmode 0 If the next Level is a Sublevel it will be executed and $this->counter will be added by 1 The sublevel calls the method again for a following sublevel

Parameters

integer $cur_level

Which level it will call [10] = level 1, [10.10] = level 2 ...

string $super_level_array

The Value-Array of the indexarray [0=>10, 1=>50]

integer $counter

The outer numeric Arraykey of indexarray

Throws

\qfq\codeException
\qfq\SqlReportException
\qfq\SyntaxReportException
\qfq\UserReportException

Returns

string —

The content that is displayed on the website

getValueParentDefault()

getValueParentDefault(string  $level_key, string  $full_super_level, string  $full_level, string  $cur_level, string  $default) : string

Determine value: 1) if one specified in line: take it 2) if one specified in upper level: take it 3) if none above take default Set value on $full_level

Parameters

string $level_key
  • 'db' or 'debug'
string $full_super_level
  • f.e.: 10.10.
string $full_level
  • f.e.: 10.10.10.
string $cur_level
  • f.e.: 2
string $default
  • f.e.: 0

Returns

string —

The calculated value.

collectRow()

collectRow(array  $row, array  $keys, string  $full_level, string  $rowIndex) : string

Steps through 'row' and collects all columns

Parameters

array $row

Recent row fetch from sql resultset.

array $keys

List of all columnnames

string $full_level

Recent position to work on.

string $rowIndex

Index of recent row in resultset.

Throws

\qfq\SyntaxReportException

Returns

string —

Collected content of all printable columns

renderColumn()

renderColumn(string  $columnIndex, string  $columnName, string  $columnValue, string  $full_level, string  $rowIndex, boolean  $show) : string

Renders column depending of column name (if name is a reserved column name)

Parameters

string $columnIndex
string $columnName
string $columnValue
string $full_level
string $rowIndex
boolean $show

Throws

\qfq\SyntaxReportException

Returns

string —

rendered column

myExec()

myExec(string  $cmd) : string

Executes the Command in $cmd RC: if RC==0 Returns Output, else 'RC - Output'

Parameters

string $cmd

: contains the Comand

Returns

string —

The content that is displayed on the website

doFixColPosPage()

doFixColPosPage(string  $columnName, string  $columnValue) : string

Renders PageX: convert position content to token content. Respect default values depending on PageX

Parameters

string $columnName
string $columnValue

Throws

\qfq\SyntaxReportException

Returns

string —

rendered link

$columnValue:

[<page id|alias>[&param=value&...]] | [record id] | [text] | [tooltip] | [msgbox] | [class] | [target] | [render mode] | [create hash]

param[0]: <page id|alias>[&param=value&...] param[1]: record id param[2]: text param[3]: tooltip param[4]: msgbox param[5]: class param[6]: target param[7]: render mode param[8]: create hash

composeLinkPart()

composeLinkPart(string  $qualifier, string  $value, string  $defaultValue = "") : string

If there is a value (or a defaultValue): compose it together with qualifier and delimiter.

Parameters

string $qualifier
string $value
string $defaultValue

Returns

string —

rendered link

doPage()

doPage(string  $columnName, string  $columnValue) : string

Renders pageX: extract token and determine if any default value has be applied

Parameters

string $columnName
string $columnValue

Returns

string —

rendered link

form2hash()

form2hash(  $formName,   $formRecordId) : string

Prepare Session Array with Hash Entry: Only for form

Parameters

$formName
$formRecordId

Returns

string

getResultArrayIndex()

getResultArrayIndex(  $variable) : string

Generate SortArgument

Parameters

$variable

Returns

string

compareArraystart()

compareArraystart(  $arr1,   $arr2) : boolean

Parameters

$arr1
$arr2

Returns

boolean

compareArraylength()

compareArraylength(  $arr1,   $arr2) : boolean

Parameters

$arr1
$arr2

Returns

boolean