projects
/
virtual-ldap
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
remove clever e-mail selection and use primary one
[virtual-ldap]
/
sql
/
hreduperson.sql
diff --git
a/sql/hreduperson.sql
b/sql/hreduperson.sql
index
d0eb058
..
b3cb5b3
100644
(file)
--- a/
sql/hreduperson.sql
+++ b/
sql/hreduperson.sql
@@
-1,6
+1,6
@@
select
select
- concat('uid=',trim(userid)
)
as dn,
+ concat('uid=',trim(userid)
,',ou=',categorycode,',dc=ffzg,dc=hr')
as dn,
'person
organizationalPerson
inetOrgPerson
'person
organizationalPerson
inetOrgPerson
@@
-12,12
+12,16
@@
select
concat(firstname,' ',surname) as cn,
-- SAFEQ specific mappings from UMgr-LDAP.conf
concat(firstname,' ',surname) as cn,
-- SAFEQ specific mappings from UMgr-LDAP.conf
- b
orrowernumber
as objectGUID,
+ b
.borrowernumber
as objectGUID,
surname as displayName,
surname as displayName,
-
rfid_sid
as pager,
+
a.attribute
as pager,
email as mail,
email as mail,
--- categorycode as memberOf,
+ categorycode as memberOf,
+ categorycode as ou,
categorycode as department,
categorycode as department,
- concat('/home/',borrowernumber) as homeDirectory
-from borrowers
+ concat('/home/',b.borrowernumber) as homeDirectory
+from borrowers b
+left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
+
+