create organizationlUnit for each categorycode from Koha

diff --git a/sql/group.sql b/sql/group.sql
index b34ebf2..e98e8f4 100644 (file)
--- a/sql/group.sql
+++ b/sql/group.sql
@@ -1,5 +1,5 @@
 select
 select

-       concat('cn=',c.categorycode,',ou=groups')       as dn,
+       concat('cn=',c.categorycode,',ou=',c.categorycode)      as dn,

        'group'                         as objectClass,
        'groups'                        as ou,
        c.categorycode                  as cn,
        'group'                         as objectClass,
        'groups'                        as ou,
        c.categorycode                  as cn,

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index d0eb058..b068bd7 100644 (file)
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -16,8 +16,8 @@ select
        surname                                         as displayName,
        rfid_sid                                        as pager,
        email                                           as mail,
        surname                                         as displayName,
        rfid_sid                                        as pager,
        email                                           as mail,

---     categorycode                                    as memberOf,
-       categorycode                                    as department,
+       categorycode                                    as memberOf,
+       categorycode                                    as ou,

        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers
 
        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers
 

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 7f010fc..21d4912 100644 (file)
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,7 +1,8 @@
 
 select
 
 select

-       'ou=groups'                     as dn,
+       concat('ou=',c.categorycode,'dc=ffzg,dc=hr')    as dn,

        'organizationalunit'            as objectClass,
        'organizationalunit'            as objectClass,

-       'groups'                        as ou,
-       'Groups from Koha'              as description
+       c.categorycode                  as ou,
+       c.description                   as description
+from categories c