package Gems
subpackage Agenda
copyright Copyright (c) 2014 Erasmus MC
license New BSD License
since Class available since version 1.6.5 5-mrt-2015 11:29:20

 Methods

__construct()

__construct(string|array $fields = null

Parameters

$fields

stringarray

Optional select fieldlist

Called after the check that all required registry values have been set correctly has run.

afterRegistry() : void

fetchAll()

fetchAll() : array

Returns

array

fetchOne()

fetchOne() : mixed

Returns

mixed

fetchRow()

fetchRow() : array

Returns

array

For a certain appointment filter

forFilter(\Gems\Agenda\AppointmentFilterInterface $filter) : \Gems\Agenda\AppointmentSelect

Add's the filter sql where and remembers the filter

Parameters

$filter

\Gems\Agenda\AppointmentFilterInterface

Returns

\Gems\Agenda\AppointmentSelect

For a certain appointment filter

forFilterId(integer $filterId) : \Gems\Agenda\AppointmentSelect

Parameters

$filterId

integer

Returns

\Gems\Agenda\AppointmentSelect

forPeriod()

forPeriod(\MUtil_Date $from = null, \MUtil_Date $until = null, boolean $sortAsc = true) : \Gems\Agenda\AppointmentSelect

Parameters

$from

\MUtil_Date

Optional date after which the appointment must occur

$until

\MUtil_Date

Optional date before which the appointment must occur

$sortAsc

boolean

Retrieve first or last appointment first

Returns

\Gems\Agenda\AppointmentSelect

For a certain respondent / organization

forRespondent(integer $respondentId, integer $organizationId) : \Gems\Agenda\AppointmentSelect

Parameters

$respondentId

integer

$organizationId

integer

Returns

\Gems\Agenda\AppointmentSelect

fromDate()

fromDate(mixed $from = null, string $oper = '>=') : \Gems\Agenda\AppointmentSelect
deprecated since 1.7.1 replace by forPeriod()

Parameters

$from

mixed

Optional date or appointment after which the appointment must occur

$oper

string

Comparison operator for the from date: <= < = > >=

Returns

\Gems\Agenda\AppointmentSelect

Get the constructed select statement

getSelect() : \Zend_Db_Select

Returns

\Zend_Db_Select

Select only active agenda items

onlyActive() : \Gems\Agenda\AppointmentSelect

Returns

\Gems\Agenda\AppointmentSelect

order()

order(mixed $spec) : \Gems\Agenda\AppointmentSelect

Parameters

$spec

mixed

The column(s) and direction to order by.

Returns

\Gems\Agenda\AppointmentSelect

Add a filter for the appointment id's currently used in tracks with this track id

uniqueForTrackId(integer $trackId, integer $respTrackId, array $previousAppIds) 

Parameters

$trackId

integer

The current trrack id

$respTrackId

integer

The current respondent track id or null for new tracks

$previousAppIds

array

array of gap_id_appointment

Add a filter for the appointment id's currently used in this track

uniqueInTrackInstance(array $previousAppIds) 

Parameters

$previousAppIds

array

array of gap_id_appointment

 Properties

 

$_select

$_select : \Zend_Db_Select

Default

 

$agenda

$agenda : \Gems_Agenda

Default

 

$db

$db : \Zend_Db_Adapter_Abstract

Default

 

The fields returned by the query

$fields : string | array

Default

"*"