Answer

Extends \LSActiveRecord

Class Answer

package

Default

Methods

Lists the behaviors of this model

behaviors() : array
inherited

Below is a list of all behaviors we register:

see \CTimestampBehavior \PluginEventBehavior

Response

array

deleteAllByAttributes

deleteAllByAttributes(array $attributes, string $condition = '', array $params = array()) : integer
inherited
todo

This should also be moved to the behavior at some point. This method overrides the parent in order to raise PluginEvents for Bulk delete operations.

Filter Criteria are wrapped into a CDBCriteria instance so we have a single instance responsible for holding the filter criteria to be passed to the PluginEvent, this also enables us to pass the fully configured CDBCriteria instead of the original Parameters.

See {@link find()} for detailed explanation about $condition and $params.

Arguments

$attributes

array

list of attribute values (indexed by attribute names) that the active records should match. An attribute value can be an array which will be used to generate an IN condition.

$condition

string

query condition or criteria.

$params

array

parameters to be bound to an SQL statement.

Response

integer

number of rows affected by the execution.

Finds all active records satisfying the specified condition but returns them as array

findAllAsArray(\CDbCriteria $condition = '', array $params = array()) : array
inherited

See \find() for detailed explanation about $condition and $params.

Arguments

$condition

\CDbCriteria

query condition or criteria.

$params

array

parameters to be bound to an SQL statement.

Response

array

list of active records satisfying the specified condition. An empty array is returned if none is found.

getAllRecords

getAllRecords( $condition,  $order = false) 

Arguments

$condition

$order

Return the key=>value answer for a given $qid

getAnswerFromCode(integer $qid, string $code, string $sLanguage, integer $iScaleID) : array
staticvar

array $answerCache

Arguments

$qid

integer

$code

string

$sLanguage

string

$iScaleID

integer

Response

array

getAnswerQuery

getAnswerQuery(integer $surveyid, string $lang, boolean $return_query = true) : array|\CDbCommand

Arguments

$surveyid

integer

$lang

string

$return_query

boolean

Response

array|\CDbCommand

getAnswers

getAnswers(integer $qid) : \CDbDataReader

Arguments

$qid

integer

Response

\CDbDataReader

Return the max value for a field

getMaxId(string $field = null, boolean $forceRefresh = false) : false|integer
inherited

This is a convenience method, that uses the primary key of the model to retrieve the highest value.

Throws
\Exception

Arguments

$field

string

The field that contains the Id, when null primary key is used if it is a single field

$forceRefresh

boolean

Don't use value from static cache but always requery the database

Response

false|integer

Return the min value for a field

getMinId(string $field = null, boolean $forceRefresh = false) : false|integer
inherited

This is a convenience method, that uses the primary key of the model to retrieve the highest value.

Throws
\Exception

Arguments

$field

string

The field that contains the Id, when null primary key is used if it is a single field

$forceRefresh

boolean

Don't use value from static cache but always requery the database

Response

false|integer

getQuestionsForStatistics

getQuestionsForStatistics(string $fields, mixed $condition, string $orderby) : array

Arguments

$fields

string

$condition

mixed

$orderby

string

Response

array

insertRecords

insertRecords(array $data) : boolean|null

Arguments

$data

array

Response

boolean|null

model

model( $class = __CLASS__) : \Answer
static
inheritdoc

Arguments

$class

Response

\Answer

oldNewInsertansTags

oldNewInsertansTags(integer $newsid, integer $oldsid) : array<mixed,static>

Arguments

$newsid

integer

$oldsid

integer

Response

array<mixed,static>

primaryKey

primaryKey() 
inheritdoc

Modified version that default to do the same as the original, but allows via a third parameter to retrieve the result as array instead of active records. This solves a joining problem. Usage via findAllAsArray method

query(\CDbCriteria $criteria, boolean $all = false, boolean $asAR = true) : mixed
inherited

Performs the actual DB query and populates the AR objects with the query result. This method is mainly internally used by other AR query methods.

since 1.1.7

Arguments

$criteria

\CDbCriteria

the query criteria

$all

boolean

whether to return all data

$asAR

boolean

Response

mixed

the AR objects populated with the query result

relations

relations() 
inheritdoc

rules

rules() 
inheritdoc

tableName

tableName() 
inheritdoc

updateRecord

updateRecord(array $data, boolean|mixed $condition = false) : integer

Arguments

$data

array

$condition

boolean|mixed

Response

integer

Updates sort order of answers inside a question

updateSortOrder(integer $qid, string $lang) : void
static
static
access

public

Arguments

$qid

integer

$lang

string

Properties

qid

qid : integer

Question id

Type(s)

integer

code

code : string

Answer code

Type(s)

string

answer

answer : string

Answer text

Type(s)

string

sortorder

sortorder : integer

Answer sort order

Type(s)

integer

assessment_value

assessment_value : integer

Type(s)

integer

language

language : string

Language code

Type(s)

string

scale_id

scale_id : integer

Type(s)

integer

questions

questions : \Question

Type(s)

\Question

groups

groups : \Question

Type(s)

\Question