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	dpavlin	47
2			select
3	dpavlin	55	concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr') as dn,
4	dpavlin	47	'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	dpavlin	60	b.borrowernumber as objectGUID,
16	dpavlin	47	surname as displayName,
17	dpavlin	60	a.attribute as pager,
18	dpavlin	47	email as mail,
19	dpavlin	54	categorycode as memberOf,
20			categorycode as ou,
21	dpavlin	56	categorycode as department,
22	dpavlin	60	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	dpavlin	47
26	dpavlin	60
27