skip expired users

[virtual-ldap] / sql / group.sql

diff --git a/sql/group.sql b/sql/group.sql
index b34ebf2..b862457 100644 (file)
--- a/sql/group.sql
+++ b/sql/group.sql
@@ -1,11 +1,11 @@
 select
-       concat('cn=',c.categorycode,',ou=groups')       as dn,
+       concat('cn=',c.categorycode,',ou=',c.categorycode,',dc=ffzg,dc=hr')     as dn,
        'group'                         as objectClass,
-       'groups'                        as ou,
+       c.categorycode                  as ou,
        c.categorycode                  as cn,
        description                     as description,
 
        concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
 from categories c
 join borrowers b on b.categorycode = c.categorycode
-where length(userid) > 0
+where length(userid) > 0 and userid not like '%@expired'