PHP Class Operator_Driver_asterisksql, horde

The table structure can be created by the scripts/sql/operator_foo.sql script. Copyright 2008-2016 Horde LLC (http://www.horde.org/) See the enclosed file COPYING for license information (GPL). If you did not receive this file, see http://www.horde.org/licenses/gpl.

Author: Your Name ([email protected])

Inheritance: extends Operator_Driver

Show file Open project: horde/horde

Protected Properties

Property	Type	Description
$_connected	boolean	Boolean indicating whether or not we're connected to the SQL server.
$_db	DB	Handle for the current database connection.
$_params	array	Hash containing connection parameters.
$_write_db	DB	Handle for the current database connection, used for writing. Defaults to the same handle as $_db if a separate write database is not required.

Public Methods

Method	Description
__construct ( array $params = [] )	Constructs a new SQL storage object.
getAccountCodes ( )

Protected Methods

Method	Description
_connect ( ) : boolean	Attempts to open a connection to the SQL server.
_disconnect ( ) : boolean	Disconnects from the SQL server and cleans up the connection.
_getMonthlyCallStats ( $start, $end, $accountcode = null, $dcontext = null ) : array	Get summary call statistics per-month for a given time range, account and destination.
_getRecords ( $start, $end, $accountcode = null, $dcontext = null, $rowstart, $rowlimit = null ) : array	Get call detail records from the database

Method Details

__construct() public method

Constructs a new SQL storage object.

public __construct ( array $params = [] )
$params	array	A hash containing connection parameters.

_connect() protected method

Attempts to open a connection to the SQL server.

protected _connect ( ) : boolean
return	boolean	True on success.

_disconnect() protected method

Disconnects from the SQL server and cleans up the connection.

protected _disconnect ( ) : boolean
return	boolean	True on success, false on failure.

_getMonthlyCallStats() protected method

Get summary call statistics per-month for a given time range, account and destination.

protected _getMonthlyCallStats ( $start, $end, $accountcode = null, $dcontext = null ) : array
return	array	Array of call statistics. The key of each element is the month name in date('Y-m') format and the value being an array of statistics for calls placed that month.

_getRecords() protected method

Get call detail records from the database

protected _getRecords ( $start, $end, $accountcode = null, $dcontext = null, $rowstart, $rowlimit = null ) : array
return	array	[0] contains summary statistics; [1] is an array of the actual call records.

getAccountCodes() public method

public getAccountCodes ( )

Property Details

$_connected protected property

Boolean indicating whether or not we're connected to the SQL server.

protected bool $_connected
return	boolean

$_db protected property

Handle for the current database connection.

protected DB $_db
return	DB

$_params protected property

Hash containing connection parameters.

protected array $_params
return	array

$_write_db protected property

Handle for the current database connection, used for writing. Defaults to the same handle as $_db if a separate write database is not required.

protected DB $_write_db
return	DB