git.rot13.org Git - virtual-ldap/blob - sql/hreduperson.sql

   1
   2 select
   3         concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
   4         'person
   5         organizationalPerson
   6         inetOrgPerson
   7         hrEduPerson'                                    as objectClass,
   8
   9         trim(userid)                                    as uid,
  10         firstname                                       as givenName,
  11         surname                                         as sn,
  12         concat(firstname,' ',surname)                   as cn,
  13
  14         -- SAFEQ specific mappings from UMgr-LDAP.conf
  15         b.borrowernumber                                        as objectGUID,
  16         surname                                         as displayName,
  17         a.attribute                                     as pager,
  18         case
  19                 when email    regexp '@ffzg.hr' then email
  20                 when emailpro regexp '@ffzg.hr' then emailpro
  21         else
  22                 trim(userid)
  23         end as mail,
  24         categorycode                                    as memberOf,
  25         categorycode                                    as ou,
  26         categorycode                                    as department,
  27         concat('/home/',b.borrowernumber)                       as homeDirectory
  28 from borrowers b
  29 left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
  30
  31
  32