public function getIterator($dbSelect = null)
{
if ($dbSelect === null) {
return $this->_getIteratorBy(1, 1);
}
return parent::getIterator($dbSelect);
}
public function getIterator($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from($this->_table)->where('handlerType = ?', $this->handlerType)->order('name');
}
return parent::getIterator($dbSelect);
}
public function getIterator($sqlSelect = null)
{
if ($sqlSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$sqlSelect = $db->select()->from($this->_table)->order('dateTime DESC');
}
return parent::getIterator($sqlSelect);
}
public function getIteratorByTeam($teamId = null)
{
if ($teamId === null) {
$teamId = $this->teamId;
}
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from($this->_table)->where("(status = 'new' AND (teamId = ? OR teamId = ''))", $teamId)->orWhere("status = 'new' AND userId = ?", (int) Zend_Auth::getInstance()->getIdentity()->personId)->order('dateTime DESC');
trigger_error($dbSelect->__toString(), E_USER_NOTICE);
return parent::getIterator($dbSelect);
}
public function getIteratorByPersonId($personId = null)
{
if ($personId === null) {
$personId = $this->personId;
}
$personId = (int) $personId;
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from($this->_table)->where('person_id = ' . $personId . ' OR patient_id = ' . $personId);
return parent::getIterator($dbSelect);
}
public function getIteratorByQueue()
{
$db = Zend_Registry::get('dbAdapter');
$sqlSelect = $db->select()->from($this->_table)->where('queue = 1')->order('dateTime DESC');
return parent::getIterator($sqlSelect);
}
public function getIteratorByParentId($id)
{
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from($this->_table)->where('`nsdrDefinitionUuid` = ?', $id);
return parent::getIterator($dbSelect);
}
