virtual-ldap/sql/hreduperson.sql


select
        concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
        'person
        organizationalPerson
        inetOrgPerson
        hrEduPerson'                                    as objectClass,

        trim(userid)                                    as uid,
        firstname                                       as givenName,
        surname                                         as sn,
        concat(firstname,' ',surname)                   as cn,

        -- SAFEQ specific mappings from UMgr-LDAP.conf
        b.borrowernumber                                        as objectGUID,
        surname                                         as displayName,
        a.attribute                                     as pager,
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,
        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'


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	email as mail,
19	categorycode as memberOf,
20	categorycode as ou,
21	categorycode as department,
22	concat('/home/',b.borrowernumber) as homeDirectory
23	from borrowers b
24	left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
25
26
27