X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=sql%2Fhreduperson.sql;h=b3cb5b3e1db1ce7a600d0da8fb02ce1f27defef3;hb=ba90bc97b89ded491f5e44bd4a4b571ce36ba2fe;hp=b068bd78593d935471f0ee30e421c0c2de7db6a9;hpb=81326d819a2f6c6fdd076087f54fb82c3a44739e;p=virtual-ldap

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index b068bd7..b3cb5b3 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -1,6 +1,6 @@
 
 select
-	concat('uid=',trim(userid))			as dn,
+	concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')	as dn,
 	'person
 	organizationalPerson
 	inetOrgPerson
@@ -12,12 +12,16 @@ select
 	concat(firstname,' ',surname)			as cn,
 
 	-- SAFEQ specific mappings from UMgr-LDAP.conf
-	borrowernumber					as objectGUID,
+	b.borrowernumber					as objectGUID,
 	surname						as displayName,
-	rfid_sid					as pager,
+	a.attribute					as pager,
 	email						as mail,
 	categorycode					as memberOf,
 	categorycode					as ou,
-	concat('/home/',borrowernumber)			as homeDirectory
-from borrowers
+	categorycode					as department,
+	concat('/home/',b.borrowernumber)			as homeDirectory
+from borrowers b
+left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
+
+