
sql.auth.secUser.read.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of butor-auth-dao Show documentation
Show all versions of butor-auth-dao Show documentation
This project is an authentication module (DAO).
SELECT
u.*,
f.firmName,
f.theme
FROM secUser u
left join (__authDataSql__) dfu on
dfu.dataType = 'firm' and
(dfu.d1 = '*' or (dfu.d1 = u.firmId))
left join (__authDataSql__) du on
du.dataType = 'user' and
(du.d1 = '*' or (du.d1 = u.id))
LEFT JOIN secFirm f ON
f.firmId = u.firmId
WHERE
(dfu.d1 is not null or du.d1 is not null) and
u.id = :id
© 2015 - 2025 Weber Informatics LLC | Privacy Policy