updateUserProfiles.clean=DELETE FROM AUTH_UTI_PRF WHERE UTI_ID = ?
updateUserProfiles.insertProfiles=INSERT INTO AUTH_UTI_PRF(UTI_ID, PRF_CODE) VALUES (?, ?)
-buildUserScopes.clean=DELETE FROM AUTH_HAB_COL
-buildUserScopes.insertScopes=\
- INSERT INTO AUTH_HAB_COL (UTI_ID, TID_CODE, COL_CLEF) \
- SELECT DISTINCT UTI.UTI_ID, 'SIRET', REF_COLL.IDCOLL \
+buildUserScopes.clean=TRUNCATE TABLE AUTH_HAB_COL
+buildUserScopes.getUsers=\
+ SELECT UTI.UTI_ID, REF_CRC_DEPT.RFC_DEP_CODE \
FROM AUTH_UTILISATEUR UTI \
- JOIN REF_CRC_DEPT ON REF_CRC_DEPT.RFC_CRC_NOM = UTI.UTI_CRC \
- JOIN REF_COLL_SPL_IX REF_COLL ON SUBSTR(REF_COLL.CODIC, 0, 3) = LPAD(REF_CRC_DEPT.RFC_DEP_CODE, 3, '0')
+ JOIN REF_CRC_DEPT ON REF_CRC_DEPT.RFC_CRC_NOM = UTI.UTI_CRC
+
+buildUserScopes.insertUserScope=\
+ INSERT INTO AUTH_HAB_COL (UTI_ID, TID_CODE, COL_CLEF) \
+ SELECT DISTINCT ?, 'SIRET', REF_COLL.IDCOLL \
+ FROM REF_COLL_SPL_IX REF_COLL \
+ WHERE SUBSTR(REF_COLL.CODIC, 0, 3) = LPAD(?, 3, '0')
unsynchronizeUser.cleanProfiles=DELETE FROM AUTH_UTI_PRF WHERE UTI_ID = ?