strip cr/lf from attribue

[virtual-ldap] / sql / hreduperson.sql

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index b068bd7..b3cb5b3 100644 (file)
--- 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'
+
+