protected function _authenticateCreateSelect() { $dbSelect = parent::_authenticateCreateSelect(); $dbSelect->where('ghost = false and is_locked = false and valid_until > \'' . date('c') . '\' and ( case when timelock_start is not null then case when timelock_end is not null then current_date not between timelock_start and timelock_end else current_date < timelock_start end else true end ) ')->where('"user".id in (select p.id_user from profile p inner join profile_group pg on pg.id_profile = p.id right join "group" g on g.id = pg.id_group where p.id_branch = ? and g.group_name = \'logowanie\' and p.ghost = false)', ODDZIAL_ID); return $dbSelect; }
protected function _authenticateCreateSelect() { $dbSelect = parent::_authenticateCreateSelect(); $dbSelect->orWhere('email = ?', $this->_identity); return $dbSelect; }
/** * _authenticateCreateSelect() - This method creates a Zend_Db_Select object that * is completely configured to be queried against the database. * * @return Zend_Db_Select */ protected function _authenticateCreateSelect() { $select = parent::_authenticateCreateSelect()->where($this->_zendDb->quoteIdentifier($this->_tenantColumn, true) . ' = ?', $this->_tenant); return $select; }