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;
}
