Merge pull request 'Gestion parcelle geom et changement https://gitea.com/actions/checkout@v4 #actions/checkout@v4' (#136 ) from features/crud_entites into develop

Reviewed-on: #136
Merge pull request 'Gestion parcelle geom' (#135 ) from features/crud_entites into develop
2026-03-01 17:33:59 +00:00 · 2026-03-01 17:29:34 +00:00 · 2026-03-01 01:40:41 +00:00 · 2026-02-22 23:17:33 +00:00 · 2026-02-22 13:53:35 +00:00 · 2026-02-21 12:42:08 +00:00
62 changed files with 375 additions and 2605 deletions
--- a/.gitea/workflows/cd-main.yml
+++ b/.gitea/workflows/cd-main.yml
@@ -52,10 +52,8 @@ jobs:
          echo "JAVA_HOME=$JAVA_HOME" >> "$GITHUB_ENV"

      # 4) Checkout du dépôt
-      #- name: Checkout repository
-      #  uses: https://gitea.com/actions/checkout@v4 #actions/checkout@v4
      - name: Checkout repository
-        run: git clone ${{ gitea.server_url }}/${{ gitea.repository }} .
+        uses: https://gitea.com/actions/checkout@v4 #actions/checkout@v4

      # 5) Informations de contexte (sans secrets)
      - name: Show context information
--- a/.gitea/workflows/ci-develop.yml
+++ b/.gitea/workflows/ci-develop.yml
@@ -52,10 +52,8 @@ jobs:
          echo "JAVA_HOME=$JAVA_HOME" >> "$GITHUB_ENV"

      # 4) Checkout du dépôt
-      #- name: Checkout repository
-      #  uses: https://gitea.com/actions/checkout@v4 #actions/checkout@v4
      - name: Checkout repository
-        run: git clone ${{ gitea.server_url }}/${{ gitea.repository }} .
+        uses: https://gitea.com/actions/checkout@v4 #actions/checkout@v4

      # 5) Création des secrets runtime (CI uniquement)
      - name: Create runtime secrets
--- a/src/main/java/io/gmss/fiscad/controllers/decoupage/SecteurController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/decoupage/SecteurController.java
@@ -315,31 +315,5 @@ public class SecteurController {
    }


-    @Operation(
-            summary = "recuperer tous les secteurs d'un departement",
-            description = "Permet de récuperer l'ensemble des secteurs du departement dont l'ID est fourni en path"
-    )
-    @GetMapping("/by-departement-id/{departementId}")
-    public ResponseEntity<?> getSecteurByDepartementId(@PathVariable Long departementId) {
-        try {
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, secteurService.getListSecteurByDepartementId(departementId), "Secteur trouvée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }

 }
--- a/src/main/java/io/gmss/fiscad/controllers/infocad/metier/EnqueteController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/infocad/metier/EnqueteController.java
@@ -2,7 +2,6 @@ package io.gmss.fiscad.controllers.infocad.metier;

 import io.gmss.fiscad.entities.infocad.metier.Enquete;
 import io.gmss.fiscad.entities.rfu.metier.EnqueteBatiment;
-import io.gmss.fiscad.entities.user.User;
 import io.gmss.fiscad.exceptions.*;
 import io.gmss.fiscad.interfaces.infocad.metier.EnqueteService;
 import io.gmss.fiscad.paylaods.ApiResponse;
@@ -11,8 +10,6 @@ import io.gmss.fiscad.paylaods.request.crudweb.EnquetePayLoadWeb;
 import io.gmss.fiscad.paylaods.request.synchronisation.EnquetePayLoad;
 import io.gmss.fiscad.paylaods.request.EnqueteTraitementPayLoad;
 import io.gmss.fiscad.paylaods.request.FiltreEnquetePayLoad;
-import io.gmss.fiscad.security.CurrentUser;
-import io.gmss.fiscad.security.UserPrincipal;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
 import io.swagger.v3.oas.annotations.tags.Tag;
@@ -483,8 +480,5 @@ public class EnqueteController {



-
-
-
 }

--- a/src/main/java/io/gmss/fiscad/controllers/infocad/metier/ParcelleController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/infocad/metier/ParcelleController.java
@@ -388,33 +388,6 @@ public class ParcelleController {



-    @PutMapping("/syncrhonise-etat-batie-parcelle")
-    public ResponseEntity<?> putSynchroniseEtatBatieParcelle() {
-        try {
-            Integer nombreParcelleSync= parcelleService.majParcelleBatieNonbatie();
-
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true,nombreParcelleSync , "Parcelle mise à jour avec succes."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-
-



--- a/src/main/java/io/gmss/fiscad/controllers/rfu/metier/DonneesImpositionTfuController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/rfu/metier/DonneesImpositionTfuController.java
@@ -7,10 +7,7 @@ import io.gmss.fiscad.enums.StatusAvis;
 import io.gmss.fiscad.exceptions.*;
 import io.gmss.fiscad.interfaces.rfu.metier.DonneesImpositionTfuService;
 import io.gmss.fiscad.paylaods.ApiResponse;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
 import io.gmss.fiscad.persistence.repositories.rfu.metier.ImpositionsTfuRepository;
-import io.gmss.fiscad.security.CurrentUser;
-import io.gmss.fiscad.security.UserPrincipal;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
 import io.swagger.v3.oas.annotations.tags.Tag;
@@ -163,104 +160,6 @@ public class DonneesImpositionTfuController {
        }
    }

-
-    @GetMapping("/all-page/by-imposition-id/{impositionId}")
-    public ResponseEntity<?> getAllDonneesImpositionTfuByImpositionIdPaged(@PathVariable Long impositionId, @RequestParam int pageNo, @RequestParam int pageSize) {
-        try {
-            Pageable pageable = PageRequest.of(pageNo, pageSize);
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, donneesImpositionTfuService.getDonneesFiscalesByImpositionTfuIdPageable(impositionId, pageable), "Liste des caractéristiques chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-    @GetMapping("/all-page/by-imposition-id/non-batie/{impositionId}")
-    public ResponseEntity<?> getAllDonneesImpositionTfuByImpositionIdNonBatiePaged(@PathVariable Long impositionId, @RequestParam int pageNo, @RequestParam int pageSize) {
-        try {
-            Pageable pageable = PageRequest.of(pageNo, pageSize);
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, donneesImpositionTfuService.getDonneesFiscalesByImpositionTfuIdNonBatiePageable(impositionId, pageable), "Liste des caractéristiques chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-
-    @GetMapping("/all-page/by-imposition-id/batie-batiment/{impositionId}")
-    public ResponseEntity<?> getAllDonneesImpositionTfuByImpositionIdBatieBatimentPaged(@PathVariable Long impositionId, @RequestParam int pageNo, @RequestParam int pageSize) {
-        try {
-            Pageable pageable = PageRequest.of(pageNo, pageSize);
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, donneesImpositionTfuService.getDonneesFiscalesByImpositionTfuIdBatieBatimentPageable(impositionId, pageable), "Liste des caractéristiques chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-    @GetMapping("/all-page/by-imposition-id/batie-unite-logement/{impositionId}")
-    public ResponseEntity<?> getAllDonneesImpositionTfuByImpositionIdBatieUniteLogPaged(@PathVariable Long impositionId, @RequestParam int pageNo, @RequestParam int pageSize) {
-        try {
-            Pageable pageable = PageRequest.of(pageNo, pageSize);
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, donneesImpositionTfuService.getDonneesFiscalesByImpositionTfuIdBatieUniteLogPageable(impositionId, pageable), "Liste des caractéristiques chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
    @GetMapping("/id/{id}")
    public ResponseEntity<?> getDonneesImpositionTfuById(@PathVariable Long id) {
        try {
@@ -283,91 +182,31 @@ public class DonneesImpositionTfuController {
            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
        }
    }
-    @Operation(summary = "Générer les données fiscales TFU des parcelle baties")
-    @PostMapping("/generer-batie")
-    public ResponseEntity<?> genererDonneesFiscaleBatie(@CurrentUser UserPrincipal userPrincipal, @RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
+    @Operation(summary = "Générer les données fiscales TFU")
+    @PostMapping("/generer")
+    public ResponseEntity<?> genererDonneesFiscale(@RequestBody ImpositionsTfu impositionsTfu) {
        try {
-            Optional<ImpositionsTfu> optionalImpositionsTfu =impositionsTfuRepository.findById(impositionsTfuPaylaodWeb.getId());
+            Optional<ImpositionsTfu> optionalImpositionsTfu =impositionsTfuRepository.findById(impositionsTfu.getId());

            if(optionalImpositionsTfu.isEmpty()){
                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "L'instance d'imposition n'est pas trouvée."),
+                        new ApiResponse<>(false, null, "L'imposition tfu n'est pas trouvée."),
                        HttpStatus.OK
                );
            }

-            if(!optionalImpositionsTfu.get().getStatusAvis().equals(StatusAvis.TFU_FNB_GENERE)){
+            if(!optionalImpositionsTfu.get().getStatusAvis().equals(StatusAvis.CREE)){
                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "l'état actuel : "+optionalImpositionsTfu.get().getStatusAvis()+" ne permet pas cette opération."),
+                        new ApiResponse<>(false, null, "le statut actuel ne permet pas cette opération."),
                        HttpStatus.OK
                );
            }

-           if(userPrincipal==null){
-               return new ResponseEntity<>(
-                       new ApiResponse<>(false, null, "Vous n'êtes pas autorisé à accéder à cette ressource"),
-                       HttpStatus.OK
-               );
-           }
-            impositionsTfuPaylaodWeb=donneesImpositionTfuService.genererDonneesFiscalesParcelleBatie(impositionsTfuPaylaodWeb,userPrincipal.getUser().getId());
-
+            optionalImpositionsTfu.get().setStatusAvis(StatusAvis.GENERE);
            return new ResponseEntity<>(
-                    new ApiResponse<>(true,impositionsTfuPaylaodWeb, "Données d'imposition des fonciers batis Générées avec succès."),
+                    new ApiResponse<>(true, donneesImpositionTfuService.genererDonneesFiscales(optionalImpositionsTfu.get()), "DonneesImpositionTfu trouvée avec succès."),
                    HttpStatus.OK
            );
-
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-
-
-
-    @Operation(summary = "Générer les données fiscales TFU des parcelle baties")
-    @PostMapping("/generer-non-batie")
-    public ResponseEntity<?> genererDonneesImpositionNonBaties(@CurrentUser UserPrincipal userPrincipal, @RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
-        try {
-            Optional<ImpositionsTfu> optionalImpositionsTfu =impositionsTfuRepository.findById(impositionsTfuPaylaodWeb.getId());
-
-            if(optionalImpositionsTfu.isEmpty()){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "L'instance d'imposition n'est pas trouvée."),
-                        HttpStatus.OK
-                );
-            }
-
-            if(!optionalImpositionsTfu.get().getStatusAvis().equals(StatusAvis.GENERATION_AUTORISE)){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "l'état actuel : "+optionalImpositionsTfu.get().getStatusAvis()+" ne permet pas cette opération."),
-                        HttpStatus.OK
-                );
-            }
-
-            if(userPrincipal==null){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "Vous n'êtes pas autorisé à accéder à cette ressource"),
-                        HttpStatus.OK
-                );
-            }
-            impositionsTfuPaylaodWeb=donneesImpositionTfuService.genererDonneesFiscalesParcelleNonBatie(impositionsTfuPaylaodWeb,userPrincipal.getUser().getId());
-
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true,impositionsTfuPaylaodWeb, "Données d'imposition pour les fonciers non batis Générées avec succès."),
-                    HttpStatus.OK
-            );
-
        } catch (HttpClientErrorException.MethodNotAllowed e) {
            logger.error(e.getLocalizedMessage());
            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
--- a/src/main/java/io/gmss/fiscad/controllers/rfu/metier/ImpositionsTfuController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/rfu/metier/ImpositionsTfuController.java
@@ -2,21 +2,12 @@ package io.gmss.fiscad.controllers.rfu.metier;


 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
-import io.gmss.fiscad.entities.user.User;
-import io.gmss.fiscad.enums.StatusAvis;
 import io.gmss.fiscad.exceptions.*;
-import io.gmss.fiscad.interfaces.infocad.metier.EnqueteService;
 import io.gmss.fiscad.interfaces.rfu.metier.ImpositionsTfuService;
 import io.gmss.fiscad.paylaods.ApiResponse;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
-import io.gmss.fiscad.security.CurrentUser;
-import io.gmss.fiscad.security.UserPrincipal;
-import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
 import io.swagger.v3.oas.annotations.tags.Tag;
 import jakarta.validation.Valid;
-import jakarta.ws.rs.NotAcceptableException;
-import lombok.AllArgsConstructor;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.data.domain.PageRequest;
@@ -30,7 +21,6 @@ import org.springframework.web.client.HttpClientErrorException;


@RestController
-@AllArgsConstructor
@RequestMapping(value = "api/impositions-tfu", produces = MediaType.APPLICATION_JSON_VALUE)
@SecurityRequirement(name = "bearer")
@Tag(name = "Impositions TFU")
@@ -38,32 +28,41 @@ import org.springframework.web.client.HttpClientErrorException;
 public class ImpositionsTfuController {

    private final ImpositionsTfuService impositionsTfuService;
-    private final EnqueteService enqueteService;
    private static final Logger logger = LoggerFactory.getLogger(ImpositionsTfuController.class);

-
+    public ImpositionsTfuController(ImpositionsTfuService impositionsTfuService) {
+        this.impositionsTfuService = impositionsTfuService;
+    }

    @PostMapping("/create")
-    public ResponseEntity<?> createImpositionsTfu(@CurrentUser UserPrincipal currentUser,@RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
+    public ResponseEntity<?> createImpositionsTfu(@RequestBody @Valid @Validated ImpositionsTfu impositionsTfu) {
        try {
-            if(currentUser==null){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "Vous n'etes pas autorisé à accéder à cette ressource."),
-                        HttpStatus.OK
-                );
-            }
-            User user=currentUser.getUser();
-
-            if(user.getStructure().getId()!=impositionsTfuPaylaodWeb.getStructureId()){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(false, null, "Vous n'etes pas autorisé à accéder à cette ressource."),
-                        HttpStatus.OK
-                );
-            }
-
-            impositionsTfuPaylaodWeb = impositionsTfuService.createImpositionsTfu(impositionsTfuPaylaodWeb);
+            impositionsTfu = impositionsTfuService.createImpositionsTfu(impositionsTfu);
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, impositionsTfuPaylaodWeb, "Unite de logement créé avec succès."),
+                    new ApiResponse<>(true, impositionsTfu, "Unite de logement créé avec succès."),
+                    HttpStatus.OK
+            );
+        } catch (HttpClientErrorException.MethodNotAllowed e) {
+            logger.error(e.getLocalizedMessage());
+            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
+        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
+                 FileStorageException e) {
+            logger.error(e.getLocalizedMessage());
+            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
+        } catch (NullPointerException e) {
+            logger.error(e.getLocalizedMessage());
+            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
+        } catch (Exception e) {
+            logger.error(e.getLocalizedMessage());
+            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
+        }
+    }
+
+    @PutMapping("/update/{id}")
+    public ResponseEntity<?> updateImpositionsTfu(@PathVariable Long id, @RequestBody ImpositionsTfu impositionsTfu) {
+        try {
+            return new ResponseEntity<>(
+                    new ApiResponse<>(true, impositionsTfuService.updateImpositionsTfu(id, impositionsTfu), "Unite de logement mise à jour avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -83,27 +82,11 @@ public class ImpositionsTfuController {
    }


-    @PutMapping("/cloturer-enquete")
-    public ResponseEntity<?> cloturer(@CurrentUser UserPrincipal userPrincipal, @RequestBody  ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb ) {
+    @PutMapping("/valider/{id}")
+    public ResponseEntity<?> validerImpositionsTfu(@RequestBody ImpositionsTfu impositionsTfu) {
        try {
-
-            if(userPrincipal==null){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(true, null, "Accès non autorisé"),
-                        HttpStatus.NOT_ACCEPTABLE
-                );
-            }
-
-
-            User user= userPrincipal.getUser();
-            if(user.getStructure().getId()!=impositionsTfuPaylaodWeb.getStructureId()){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(true,null, "Vous n'êtes pas autorisé à cloturer les enquetes du : "+user.getStructure().getNom()),
-                        HttpStatus.OK
-                );
-            }
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, impositionsTfuService.cloturerImpositionsTfu(impositionsTfuPaylaodWeb), "enquete cloturées avec succès."),
+                    new ApiResponse<>(true, impositionsTfuService.validerImpositionsTfu(impositionsTfu), "Unite de logement mise à jour avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -122,62 +105,11 @@ public class ImpositionsTfuController {
        }
    }

-//    @PutMapping("/update/{id}")
-//    public ResponseEntity<?> updateImpositionsTfu(@PathVariable Long id, @RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
-//        try {
-//            return new ResponseEntity<>(
-//                    new ApiResponse<>(true, impositionsTfuService.updateImpositionsTfu(id, impositionsTfuPaylaodWeb), "Unite de logement mise à jour avec succès."),
-//                    HttpStatus.OK
-//            );
-//        } catch (HttpClientErrorException.MethodNotAllowed e) {
-//            logger.error(e.getLocalizedMessage());
-//            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-//        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-//                 FileStorageException e) {
-//            logger.error(e.getLocalizedMessage());
-//            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-//        } catch (NullPointerException e) {
-//            logger.error(e.getLocalizedMessage());
-//            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-//        } catch (Exception e) {
-//            logger.error(e.getLocalizedMessage());
-//            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-//        }
-//    }
-
-    @Operation(
-            summary = "Autoriser la génération des avis d'un centre",
-            description = "Permet d'autoriser la génération des avis d'un centre pour un exervice données"
-    )
-
-    @PutMapping("/autoriser-generation-avis")
-    public ResponseEntity<?> autoriserImpositionsTfu(@RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
+    @PutMapping("/annuler/{id}")
+    public ResponseEntity<?> annulerImpositionsTfu(@PathVariable Long id, @RequestBody ImpositionsTfu impositionsTfu) {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, impositionsTfuService.autoriserGenerationImpositionsTfu(impositionsTfuPaylaodWeb), "Unite de logement mise à jour avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-    @PutMapping("/rejeter")
-    public ResponseEntity<?> annulerImpositionsTfu(@RequestBody ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) {
-        try {
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, impositionsTfuService.rejeterImpositionsTfu(impositionsTfuPaylaodWeb), "Unite de logement mise à jour avec succès."),
+                    new ApiResponse<>(true, impositionsTfuService.annulerImpositionsTfu(impositionsTfu), "Unite de logement mise à jour avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -220,19 +152,11 @@ public class ImpositionsTfuController {
        }
    }

-    @GetMapping("/all/by-user")
-    public ResponseEntity<?> getAllImpositionsTfuList(@CurrentUser UserPrincipal userPrincipal) {
+    @GetMapping("/all")
+    public ResponseEntity<?> getAllImpositionsTfuList() {
        try {
-
-            if(userPrincipal==null){
-                return new ResponseEntity<>(
-                        new ApiResponse<>(true, null, "Vous n'êtes pas autorisé à acceder à cette ressource"),
-                        HttpStatus.OK
-                );
-            }
-            User user= userPrincipal.getUser();
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, impositionsTfuService.getImpositionsTfuByUserIdIds(user.getId()), "Liste des Enquetes des unites Logements chargée avec succès."),
+                    new ApiResponse<>(true, impositionsTfuService.getImpositionsTfuList(), "Liste des Enquetes des unites Logements chargée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
--- a/src/main/java/io/gmss/fiscad/controllers/rfu/parametre/BaremRfuController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/rfu/parametre/BaremRfuController.java
@@ -2,9 +2,8 @@ package io.gmss.fiscad.controllers.rfu.parametre;

 import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
 import io.gmss.fiscad.exceptions.*;
-import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuBatiService;
+import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuService;
 import io.gmss.fiscad.paylaods.ApiResponse;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
 import io.swagger.v3.oas.annotations.tags.Tag;
 import jakarta.validation.Valid;
@@ -25,20 +24,20 @@ import org.springframework.web.client.HttpClientErrorException;
@SecurityRequirement(name = "bearer")
@Tag(name = "Barem Rfu")
 public class BaremRfuController {
-    private final BaremRfuBatiService baremRfuBatiService;
+    private final BaremRfuService baremRfuService;
    private static final Logger logger = LoggerFactory.getLogger(BaremRfuController.class);

-    public BaremRfuController(BaremRfuBatiService baremRfuBatiService) {
-        this.baremRfuBatiService = baremRfuBatiService;
+    public BaremRfuController(BaremRfuService baremRfuService) {
+        this.baremRfuService = baremRfuService;
    }


    @PostMapping("/create")
-    public ResponseEntity<?> createBaremRfu(@RequestBody @Valid @Validated BaremRfuBatiPayloadWeb baremRfuBatiPayloadWeb) {
+    public ResponseEntity<?> createBaremRfu(@RequestBody @Valid @Validated BaremRfuBati baremRfuBati) {
        try {
-            baremRfuBatiPayloadWeb = baremRfuBatiService.createBaremRfu(baremRfuBatiPayloadWeb);
+            baremRfuBati = baremRfuService.createBaremRfu(baremRfuBati);
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiPayloadWeb, "BaremRfuBati créé avec  succès."),
+                    new ApiResponse<>(true, baremRfuBati, "BaremRfuBati créé avec  succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -58,10 +57,10 @@ public class BaremRfuController {
    }

    @PutMapping("/update/{id}")
-    public ResponseEntity<?> updateBaremRfu(@PathVariable Long id, @RequestBody BaremRfuBatiPayloadWeb baremRfuBatiPayloadWeb) {
+    public ResponseEntity<?> updateBaremRfu(@PathVariable Long id, @RequestBody BaremRfuBati baremRfuBati) {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.updateBaremRfu(id, baremRfuBatiPayloadWeb), "BaremRfuBati mis à jour avec succès."),
+                    new ApiResponse<>(true, baremRfuService.updateBaremRfu(id, baremRfuBati), "BaremRfuBati mis à jour avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -83,7 +82,7 @@ public class BaremRfuController {
    @DeleteMapping("/delete/{id}")
    public ResponseEntity<?> deleteBaremRfur(@PathVariable Long id) {
        try {
-            baremRfuBatiService.deleteBaremRfu(id);
+            baremRfuService.deleteBaremRfu(id);
            return new ResponseEntity<>(
                    new ApiResponse<>(true, "BaremRfuBati supprimée avec succès."),
                    HttpStatus.OK
@@ -108,7 +107,7 @@ public class BaremRfuController {
    public ResponseEntity<?> getAllBaremRfuList() {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuList(), "Liste des baremRfus chargée avec succès."),
+                    new ApiResponse<>(true, baremRfuService.getBaremRfuList(), "Liste des baremRfus chargée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -133,7 +132,7 @@ public class BaremRfuController {
            Pageable pageable = PageRequest.of(pageNo, pageSize);

            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuList(pageable), "Liste des baremRfus chargée avec succès."),
+                    new ApiResponse<>(true, baremRfuService.getBaremRfuList(pageable), "Liste des baremRfus chargée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -156,7 +155,7 @@ public class BaremRfuController {
    public ResponseEntity<?> getBaremRfuById(@PathVariable Long id) {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuById(id), "BaremRfuBati trouvée avec succès."),
+                    new ApiResponse<>(true, baremRfuService.getBaremRfuById(id), "BaremRfuBati trouvée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -175,68 +174,13 @@ public class BaremRfuController {
        }
    }

-    @GetMapping("/by-categorie-batiment-id/{idCategorieBatiment}")
+    @GetMapping("/categorie-batiment/{idCategorieBatiment}")
    public ResponseEntity<?> getBaremRfuByType( //@Parameter(description = "ID de la catégorie de bâtiment", required = true)
                                                   @PathVariable Long idCategorieBatiment) {

        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuByCategorieBatiment(idCategorieBatiment), "Liste des baremRfu par categorie de batiments chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-
-    @GetMapping("/by-arrondissement-id/by-categorie-batiment-id/{idArrondissement}/{idCategorieBatiment}")
-    public ResponseEntity<?> getBaremRfuByArrondisementAndCategorie( //@Parameter(description = "ID de la catégorie de bâtiment", required = true)
-                                                @PathVariable Long idArrondissement,
-                                                @PathVariable Long idCategorieBatiment
-                                                ) {
-
-        try {
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuByArrondissementAndCategorieBatiment(idArrondissement,idCategorieBatiment), "Liste des baremRfu par categorie de batiments chargée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-    @GetMapping("/by-quartier-id/by-categorie-batiment-id/{idQuartier}/{idCategorieBatiment}")
-    public ResponseEntity<?> getBaremRfuByQuartierAndCategorie( //@Parameter(description = "ID de la catégorie de bâtiment", required = true)
-                                                                     @PathVariable Long idQuartier,
-                                                                     @PathVariable Long idCategorieBatiment
-    ) {
-
-        try {
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuBatiService.getBaremRfuByQuartierAndCategorieBatiment(idQuartier,idCategorieBatiment), "Liste des baremRfu par categorie de batiments chargée avec succès."),
+                    new ApiResponse<>(true, baremRfuService.getBaremRfuByType(idCategorieBatiment), "Liste des baremRfu par categorie de batiments chargée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
--- a/src/main/java/io/gmss/fiscad/controllers/rfu/parametre/BaremRfuNonBatiController.java
+++ b/src/main/java/io/gmss/fiscad/controllers/rfu/parametre/BaremRfuNonBatiController.java
@@ -4,7 +4,6 @@ import io.gmss.fiscad.entities.rfu.parametre.BaremRfuNonBati;
 import io.gmss.fiscad.exceptions.*;
 import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuNonBatiService;
 import io.gmss.fiscad.paylaods.ApiResponse;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
 import io.swagger.v3.oas.annotations.tags.Tag;
 import jakarta.validation.Valid;
@@ -35,11 +34,11 @@ public class BaremRfuNonBatiController {


    @PostMapping("/create")
-    public ResponseEntity<?> createBaremRfuNonBati(@RequestBody BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) {
+    public ResponseEntity<?> createBaremRfuNonBati(@RequestBody @Valid @Validated BaremRfuNonBati baremRfuNonBati) {
        try {
-            baremRfuNonBatiPayloadWeb = baremRfuNonBatiService.createBaremRfuNonBati(baremRfuNonBatiPayloadWeb);
+            baremRfuNonBati = baremRfuNonBatiService.createBaremRfuNonBati(baremRfuNonBati);
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuNonBatiPayloadWeb, "BaremRfuNonBati créé avec  succès."),
+                    new ApiResponse<>(true, baremRfuNonBati, "BaremRfuNonBati créé avec  succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -59,10 +58,10 @@ public class BaremRfuNonBatiController {
    }

    @PutMapping("/update/{id}")
-    public ResponseEntity<?> updateBaremRfuNonBati(@PathVariable Long id, @RequestBody BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) {
+    public ResponseEntity<?> updateBaremRfuNonBati(@PathVariable Long id, @RequestBody BaremRfuNonBati baremRfuNonBati) {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuNonBatiService.updateBaremRfuNonBati(id, baremRfuNonBatiPayloadWeb), "BaremRfuNonBati mis à jour avec succès."),
+                    new ApiResponse<>(true, baremRfuNonBatiService.updateBaremRfuNonBati(id, baremRfuNonBati), "BaremRfuNonBati mis à jour avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
@@ -157,31 +156,7 @@ public class BaremRfuNonBatiController {
    public ResponseEntity<?> getBaremRfuNonBatiById(@PathVariable Long id) {
        try {
            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuNonBatiService.getBaremRfuNonBatiById(id).orElse(null), "BaremRfuNonBati trouvée avec succès."),
-                    HttpStatus.OK
-            );
-        } catch (HttpClientErrorException.MethodNotAllowed e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Method POST/GET is required."), HttpStatus.OK);
-        } catch (NotFoundException | BadRequestException | MyFileNotFoundException | ResourceNotFoundException |
-                 FileStorageException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, e.getMessage()), HttpStatus.OK);
-        } catch (NullPointerException e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "Null value has been detected {" + e.getMessage() + "}."), HttpStatus.OK);
-        } catch (Exception e) {
-            logger.error(e.getLocalizedMessage());
-            return new ResponseEntity<>(new ApiResponse(false, null, "An error has been occur and the content is {" + e.getMessage() + "}."), HttpStatus.OK);
-        }
-    }
-
-
-    @GetMapping("/by-commune-id/by-zone-id/{communeId}/{zoneId}")
-    public ResponseEntity<?> getBaremRfuNonBatiByCommineAndZoneId(@PathVariable Long communeId, Long zoneId) {
-        try {
-            return new ResponseEntity<>(
-                    new ApiResponse<>(true, baremRfuNonBatiService.getBaremRfuNonBatiByCommuneAndZoneId(communeId,zoneId).orElse(null), "BaremRfuNonBati trouvée avec succès."),
+                    new ApiResponse<>(true, baremRfuNonBatiService.getBaremRfuNonBatiById(id), "BaremRfuNonBati trouvée avec succès."),
                    HttpStatus.OK
            );
        } catch (HttpClientErrorException.MethodNotAllowed e) {
--- a/src/main/java/io/gmss/fiscad/entities/decoupage/Quartier.java
+++ b/src/main/java/io/gmss/fiscad/entities/decoupage/Quartier.java
@@ -29,8 +29,6 @@ public class Quartier extends BaseEntity implements Serializable {
    @ManyToOne
    private Arrondissement arrondissement;

-    private String longitude;
-    private String latitude;
 //    @JsonIgnore
 //    @OneToOne(mappedBy = "quartier")
 //    private Bloc bloc;
--- a/src/main/java/io/gmss/fiscad/entities/infocad/metier/ParcelleGeom.java
+++ b/src/main/java/io/gmss/fiscad/entities/infocad/metier/ParcelleGeom.java
@@ -97,7 +97,6 @@ public class ParcelleGeom extends BaseEntity implements Serializable {
    @Enumerated(EnumType.STRING)
    private SourceDonnee sourceDonnees;
    private String observations;
-
    @Enumerated(EnumType.STRING)
    private StatutParcelle statutParcelle;
    private Long uploadId;
@@ -119,7 +118,7 @@ public class ParcelleGeom extends BaseEntity implements Serializable {
    private Quartier quartier ;

    @ColumnDefault("0")
-    private Integer  geomSrid;
+    private int  geomSrid;
    @JsonSerialize(using = GeometrySerializer.class)
    @JsonDeserialize(contentUsing = GeometryDeserializer.class)
    @Column(name = "geometry",columnDefinition = "geometry(Polygon,32631)")
--- a/src/main/java/io/gmss/fiscad/entities/rfu/metier/DonneesImpositionTfu.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/metier/DonneesImpositionTfu.java
@@ -8,9 +8,6 @@ import io.gmss.fiscad.entities.BaseEntity;
 import io.gmss.fiscad.entities.infocad.metier.Enquete;
 import io.gmss.fiscad.entities.infocad.metier.Parcelle;
 import io.gmss.fiscad.entities.infocad.metier.Tpe;
-import io.gmss.fiscad.entities.infocad.parametre.Structure;
-import io.gmss.fiscad.entities.rfu.parametre.ZoneRfu;
-import io.gmss.fiscad.enums.NatureImpot;
 import jakarta.persistence.*;
 import lombok.AllArgsConstructor;
 import lombok.Data;
@@ -74,17 +71,11 @@ public class DonneesImpositionTfu extends BaseEntity implements Serializable {
    private int superficieParc;
    private Long superficieAuSolBat;
    private Long superficieAuSolUlog;
-    //private String batieOuiNon;
-    //private String exhonereOuiNon;
-    //private String batimentExhonereOuiNon;
-    //private String uniteLogementExhonereOuiNon;
-    private Boolean batie;
-    private Boolean exonere;
-    private Boolean batimentExonere;
-    private Boolean uniteLogementExonere;
+    private String batieOuiNon;
+    private String exhonereOuiNon;
+    private String batimentExhonereOuiNon;
+    private String uniteLogementExhonereOuiNon;
    private Long valeurLocativeAdm;
-    private Long valeurLocativeAdm70Pour100;
-    private Long valeurLocativeAdmMetreCarre;
    private Long montantLoyerAnnuel;
    private Long tfuMetreCarre;
    private Long tfuMinimum;
@@ -97,30 +88,14 @@ public class DonneesImpositionTfu extends BaseEntity implements Serializable {
    @JsonDeserialize(using = LocalDateDeserializer.class)
    private LocalDate dateEnquete;
    private Long enqueteId;
-    //private Long structureId;
-    @JsonIgnore
-    @ManyToOne(fetch = FetchType.LAZY)
-    @JoinColumn(name = "structure_id")
-    private Structure structure ;
-
+    private Long structureId;
    private Long secteurId;
-
-    //private Long zoneRfuId;
-    @ManyToOne(fetch = FetchType.LAZY)
-    @JoinColumn(name = "zone_rfu_id")
-    private ZoneRfu zoneRfu ;
-
+    private Long zoneRfuId;
    @ColumnDefault("0")
-    private Long valeurAdminParcelleNb;
-    private Float tauxTfu;
-    private Float montantTaxe;
-    private Long valeurAdminParcelleNbMetreCarre;
+    private float tauxParcelleNonBati;
+    private Long valeurAdministrativeParcelleNonBati;
    @JsonIgnore
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "impositions_tfu_id", nullable = false)
-    private ImpositionsTfu impositionsTfu ;
-    @Enumerated(EnumType.STRING)
-    private NatureImpot natureImpot;
-    private Long valeurBatiment;
-    private Long valeurParcelle;
+    private ImpositionsTfu impositionsTfu;
 }
--- a/src/main/java/io/gmss/fiscad/entities/rfu/metier/ImpositionsTfu.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/metier/ImpositionsTfu.java
@@ -6,7 +6,6 @@ import com.fasterxml.jackson.databind.annotation.JsonDeserialize;
 import io.gmss.fiscad.deserializer.LocalDateDeserializer;
 import io.gmss.fiscad.entities.BaseEntity;
 import io.gmss.fiscad.entities.decoupage.Commune;
-import io.gmss.fiscad.entities.infocad.parametre.Structure;
 import io.gmss.fiscad.entities.rfu.parametre.Exercice;
 import io.gmss.fiscad.entities.rfu.parametre.Participer;
 import io.gmss.fiscad.enums.StatusAvis;
@@ -34,39 +33,24 @@ public class ImpositionsTfu extends BaseEntity implements Serializable {
    private Long id;
    @ManyToOne
    private Exercice exercice;
-
    @ManyToOne
    private Commune commune;
-
-    @ManyToOne
-    private Structure structure ;
-
    @JsonFormat(pattern = "yyyy-MM-dd")
    @JsonDeserialize(using = LocalDateDeserializer.class)
    private LocalDate dateGeneration;
-
-    @JsonFormat(pattern = "yyyy-MM-dd")
-    @JsonDeserialize(using = LocalDateDeserializer.class)
-    private LocalDate dateCloture;
-
-    private String referencePieceAdmin;
+    private String ReferencePieceAdmin;
    private String datePieceAdmin;
-
    @Enumerated(EnumType.STRING)
    private StatusAvis statusAvis;
-
-    private Integer nombreAvis;
-    private Integer nombreAvisFnb;
-    private Integer nombreAvisBatiment;
-    private Integer nombreAvisUniteLog;
-
+    private Long nombreAvis;
    @Column(columnDefinition = "TEXT")
    private String motif;
-
    @JsonIgnore
    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
    @JoinColumn(name = "impositions_tfu_id")
    private List<DonneesImpositionTfu> donneesImpositionTfus;

-
+    public  Long getNombreAvis(){
+        return donneesImpositionTfus==null?0l:donneesImpositionTfus.size();
+    }
 }
--- a/src/main/java/io/gmss/fiscad/entities/rfu/metier/SituationFiscaleParcelle.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/metier/SituationFiscaleParcelle.java
@@ -39,6 +39,7 @@ public class SituationFiscaleParcelle extends BaseEntity implements Serializable
    private Long montantDu ;
    private Long montantPaye ;
    private Long resteAPayer ;
+    private StatutParcelle etatFiscalParcelle ;
    @JsonFormat(pattern = "yyyy-MM-dd")
    @JsonDeserialize(using = LocalDateDeserializer.class)
    private LocalDate dateSync;
--- a/src/main/java/io/gmss/fiscad/entities/rfu/metier/UniteLogement.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/metier/UniteLogement.java
@@ -69,5 +69,4 @@ public class UniteLogement extends BaseEntity implements Serializable {
    @JsonDeserialize(using = LocalDateDeserializer.class)
    private LocalDate dateFinExemption;
    private Integer idToitRfu;
-    private Integer nombreEtage;
 }
--- a/src/main/java/io/gmss/fiscad/entities/rfu/parametre/BaremRfuBati.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/parametre/BaremRfuBati.java
@@ -2,7 +2,6 @@ package io.gmss.fiscad.entities.rfu.parametre;

 import io.gmss.fiscad.entities.BaseEntity;
 import io.gmss.fiscad.entities.decoupage.Arrondissement;
-import io.gmss.fiscad.entities.decoupage.Quartier;
 import jakarta.persistence.*;
 import lombok.AllArgsConstructor;
 import lombok.Data;
@@ -29,6 +28,4 @@ public class BaremRfuBati extends BaseEntity implements Serializable {
    private CategorieBatiment categorieBatiment;
    @ManyToOne
    private Arrondissement arrondissement;
-    @ManyToOne
-    private Quartier quartier ;
 }
--- a/src/main/java/io/gmss/fiscad/entities/rfu/parametre/BaremRfuNonBati.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/parametre/BaremRfuNonBati.java
@@ -23,9 +23,7 @@ public class BaremRfuNonBati extends BaseEntity implements Serializable {
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private Long valeurAdministrative;
-    private Long valeurAdministrativeMetreCarre;
-    private Boolean auMetreCarre;
-    private Float taux;
+    private float taux;
    @ManyToOne
    private Commune commune;
    @ManyToOne
--- a/src/main/java/io/gmss/fiscad/entities/rfu/parametre/Usage.java
+++ b/src/main/java/io/gmss/fiscad/entities/rfu/parametre/Usage.java
@@ -1,8 +1,10 @@
 package io.gmss.fiscad.entities.rfu.parametre;

 import io.gmss.fiscad.entities.BaseEntity;
-import io.gmss.fiscad.enums.CategorieUsage;
-import jakarta.persistence.*;
+import jakarta.persistence.Entity;
+import jakarta.persistence.GeneratedValue;
+import jakarta.persistence.GenerationType;
+import jakarta.persistence.Id;
 import lombok.AllArgsConstructor;
 import lombok.Data;
 import lombok.EqualsAndHashCode;
@@ -23,7 +25,5 @@ public class Usage extends BaseEntity implements Serializable {
    private Long id;
    private String code;
    private String nom;
-    @Enumerated(EnumType.STRING)
-    private CategorieUsage categorieUsage;
 }

--- a/src/main/java/io/gmss/fiscad/enums/CategorieUsage.java
+++ b/src/main/java/io/gmss/fiscad/enums/CategorieUsage.java
@@ -1,8 +0,0 @@
-package io.gmss.fiscad.enums;
-
-public enum CategorieUsage {
-
-    HABITATION,
-    PROFESSIONNELLE,
-    MIXTE
-}
--- a/src/main/java/io/gmss/fiscad/enums/NatureImpot.java
+++ b/src/main/java/io/gmss/fiscad/enums/NatureImpot.java
@@ -1,6 +0,0 @@
-package io.gmss.fiscad.enums;
-
-public enum NatureImpot {
-    TFU,
-    IRF
-}
--- a/src/main/java/io/gmss/fiscad/enums/ParametersType.java
+++ b/src/main/java/io/gmss/fiscad/enums/ParametersType.java
@@ -12,8 +12,5 @@ public enum ParametersType {
    CORPS_RESET_PASSWORD,
    OBJET_CREATE_ACCOUNT,
    CORPS_CREATE_ACCOUNT,
-    TOKEN_IFU_EN_LIGNE,
-    TAUX_TFU_HABITATION,
-    TAUX_TFU_PROFESSIONNELLE,
-    TAUX_DEFAUT_SUPERFICIE_AU_SOL;
+    TOKEN_IFU_EN_LIGNE ;
 }
--- a/src/main/java/io/gmss/fiscad/enums/StatusAvis.java
+++ b/src/main/java/io/gmss/fiscad/enums/StatusAvis.java
@@ -1,11 +1,8 @@
 package io.gmss.fiscad.enums;

 public enum StatusAvis {
-    EN_COURS,
-    CLOTURE,
-    GENERATION_AUTORISE,
-    REJETE,
-    TFU_FNB_GENERE,
-    GENERE
-
+    CREE,
+    GENERE,
+    ANNULE,
+    VALIDE,
 }
--- a/src/main/java/io/gmss/fiscad/enums/StatutEnquete.java
+++ b/src/main/java/io/gmss/fiscad/enums/StatutEnquete.java
@@ -2,7 +2,7 @@ package io.gmss.fiscad.enums;

 public enum StatutEnquete {
    EN_COURS,
-  //  DECLARATION,
+    DECLARATION,
    FINALISE,
    REJETE,
    VALIDE,
--- a/src/main/java/io/gmss/fiscad/enums/StatutParcelle.java
+++ b/src/main/java/io/gmss/fiscad/enums/StatutParcelle.java
@@ -2,6 +2,9 @@ package io.gmss.fiscad.enums;

 public enum StatutParcelle {
    NON_ENQUETER,
-    AJOUR,
-    NON_AJOUR;
+    ENQUETER_NON_BATIE_AJOUR,
+    ENQUETER_BATIE_AJOUR,
+    ENQUETER_NON_BATIE_NON_AJOUR,
+    ENQUETER_BATIE_NON_AJOUR
+
 }
--- a/src/main/java/io/gmss/fiscad/implementations/decoupage/SecteurServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/decoupage/SecteurServiceImpl.java
@@ -163,15 +163,8 @@ public class SecteurServiceImpl implements SecteurService {
                        secteurs.addAll(secteurRepository.findDistinctBySection_Id(avoirFonction.getFonction().getSection().getId()));
                    }else if(avoirFonction.getFonction().getStructure()!=null){
                        secteurs.addAll(secteurRepository.findDistinctBySection_Structure_Id(avoirFonction.getFonction().getStructure().getId()));
-                    }else if(avoirFonction.getFonction().getDepartement()!=null){
-                        secteurs.addAll(secteurRepository.findSectionsByDepartement(avoirFonction.getFonction().getDepartement().getId()));
                    }
                });
        return secteurs;
    }
-
-    @Override
-    public List<Secteur> getListSecteurByDepartementId(Long departementId) {
-        return secteurRepository.findSectionsByDepartement(departementId);
-    }
 }
--- a/src/main/java/io/gmss/fiscad/implementations/infocad/metier/EnqueteServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/infocad/metier/EnqueteServiceImpl.java
@@ -43,7 +43,6 @@ import io.gmss.fiscad.service.EntityFromPayLoadService;
 import jakarta.persistence.EntityManager;
 import jakarta.persistence.PersistenceContext;
 import jakarta.persistence.Query;
-import jakarta.transaction.Transactional;
 import lombok.RequiredArgsConstructor;
 import org.modelmapper.ModelMapper;
 import org.springframework.data.domain.Page;
@@ -349,7 +348,7 @@ public class EnqueteServiceImpl implements EnqueteService {
        Enquete enquete = optionalEnquete.get();
        enquete.setDateValidation(LocalDate.now());
        enquete.setStatutEnquete(StatutEnquete.VALIDE);
-        enquete.setSynchronise(true);
+        enquete.setSynchronise(false);
        return enqueteRepository.save(enquete);
    }

@@ -542,26 +541,4 @@ public class EnqueteServiceImpl implements EnqueteService {
    }


-    @Override
-    @Transactional
-    public int cloturerEnqueteParcelleBatimentUniteLogementByUserIdAndExerciceId(Long userId,Long exerciceId) {
-       Optional<User> optionalUser= userRepository.findById(userId);
-       int nbreEnquete=0;
-       if(optionalUser.isPresent() && optionalUser.get().getStructure()!=null){
-           Long structureId=optionalUser.get().getStructure().getId();
-           nbreEnquete=cloturerEnqueteParcelleBatimentUniteLogementByStructureIdAndExerciceId(structureId,exerciceId);
-       }
-        return nbreEnquete;
-    }
-
-    @Override
-    @Transactional
-    public int cloturerEnqueteParcelleBatimentUniteLogementByStructureIdAndExerciceId(Long structureId,Long exerciceId) {
-        Integer nombreParcelleImpacte=enqueteRepository.clotureEnqueteParcelle(structureId,exerciceId);
-        Integer nombreBatiment=enqueteBatimentRepository.clotureEnqueteBatiment(structureId,exerciceId);
-        Integer nombreUniteLogement=enqueteUniteLogementRepository.clotureEnqueteUniteLogement(structureId,exerciceId);
-        return nombreParcelleImpacte;
-    }
-
-
 }
--- a/src/main/java/io/gmss/fiscad/implementations/infocad/metier/ParcelleServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/infocad/metier/ParcelleServiceImpl.java
@@ -22,7 +22,6 @@ import io.gmss.fiscad.persistence.repositories.infocad.parametre.SituationGeogra
 import io.gmss.fiscad.persistence.specification.ParcelleSpecification;
 import io.gmss.fiscad.service.GeometryService;
 import jakarta.persistence.Query;
-import jakarta.transaction.Transactional;
 import lombok.AllArgsConstructor;
 import org.springframework.data.domain.*;
 import org.springframework.stereotype.Service;
@@ -194,13 +193,6 @@ public class ParcelleServiceImpl implements ParcelleService {

    }

-    @Override
-    @Transactional
-    public Integer majParcelleBatieNonbatie() {
-        return parcelleRepository.updateParcelleBatieTrue()+parcelleRepository.updateParcelleBatieFalse();
-    }
-
-
    private List<Long> getSecteurIdListForUser(Long userId) {
        List<Secteur> secteurs = secteurService.getListSecteurUserId(userId);
        List<Long> secteurIds = secteurs.stream()
--- a/src/main/java/io/gmss/fiscad/implementations/infocad/parametre/StructureServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/infocad/parametre/StructureServiceImpl.java
@@ -1,25 +1,20 @@
 package io.gmss.fiscad.implementations.infocad.parametre;

 import io.gmss.fiscad.entities.decoupage.Commune;
-import io.gmss.fiscad.entities.decoupage.Secteur;
 import io.gmss.fiscad.entities.decoupage.Section;
 import io.gmss.fiscad.entities.infocad.parametre.Structure;
-import io.gmss.fiscad.entities.user.AvoirFonction;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
 import io.gmss.fiscad.interfaces.infocad.parametre.StructureService;
 import io.gmss.fiscad.paylaods.request.crudweb.StructurePaylaodWeb;
 import io.gmss.fiscad.paylaods.response.StructureResponse;
 import io.gmss.fiscad.persistence.repositories.infocad.parametre.StructureRepository;
-import io.gmss.fiscad.persistence.repositories.user.AvoirFonctionRepository;
 import io.gmss.fiscad.service.EntityFromPayLoadService;
 import lombok.AllArgsConstructor;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.stereotype.Service;

-import java.time.LocalDate;
-import java.util.ArrayList;
 import java.util.List;
 import java.util.Optional;
@AllArgsConstructor
@@ -28,7 +23,6 @@ public class StructureServiceImpl implements StructureService {

    private final StructureRepository structureRepository;
    private final EntityFromPayLoadService entityFromPayLoadService;
-    private final AvoirFonctionRepository avoirFonctionRepository;

    @Override
    public StructurePaylaodWeb createStructure(StructurePaylaodWeb structurePaylaodWeb) throws BadRequestException {
@@ -95,29 +89,5 @@ public class StructureServiceImpl implements StructureService {
        return structureRepository.findStructureToDtoById(id);
    }

-    @Override
-    public List<Structure> getListStructureUserId(Long userId) {
-        List<AvoirFonction> avoirFonctions= avoirFonctionRepository.findAvoirFonctionByUser_Id(userId);
-        List<Structure> structures = new ArrayList<>();
-        avoirFonctions.stream()
-                .filter(af -> af.getDateFin() == null || af.getDateFin().isAfter(LocalDate.now()))
-                .forEach(avoirFonction -> {
-                    if(avoirFonction.getFonction().getStructure()!=null){
-                        structures.addAll(List.of(avoirFonction.getFonction().getStructure()));
-                    }else if (avoirFonction.getFonction().getDepartement()!=null){
-                        structures.addAll(structureRepository.findDistinctByCommune_Departement_Id(avoirFonction.getFonction().getDepartement().getId()));
-                    }
-                });
-        return structures;
-    }

-
-
-//    public List<Long> getStructureIdListForUser(Long userId) {
-//        List<Structure> structures = secteurService.getListSecteurUserId(userId);
-//        List<Long> secteurIds = secteurs.stream()
-//                .map(Secteur::getId)
-//                .toList();
-//        return  secteurIds;
-//    }
 }
--- a/src/main/java/io/gmss/fiscad/implementations/rfu/metier/CaracteristiqueBatimentServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/metier/CaracteristiqueBatimentServiceImpl.java
@@ -73,6 +73,7 @@ public class CaracteristiqueBatimentServiceImpl implements CaracteristiqueBatime
        return caracteristiqueBatimentRepository.findAllCaracteristiqueBatimentToDto();
    }

+
    @Override
    public Optional<CaracteristiqueBatimentPayloadWeb> getCaracteristiqueBatimentToDto(Long id) {
        if (caracteristiqueBatimentRepository.existsById(id)) {
--- a/src/main/java/io/gmss/fiscad/implementations/rfu/metier/DonneesImpositionTfuServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/metier/DonneesImpositionTfuServiceImpl.java
@@ -4,12 +4,9 @@ import io.gmss.fiscad.entities.decoupage.Arrondissement;
 import io.gmss.fiscad.entities.rfu.metier.DonneesImpositionTfu;
 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
 import io.gmss.fiscad.entities.rfu.parametre.BaremRfuNonBati;
-import io.gmss.fiscad.enums.StatusAvis;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
 import io.gmss.fiscad.interfaces.rfu.metier.DonneesImpositionTfuService;
-import io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
 import io.gmss.fiscad.paylaods.response.DonneesImpositionTfuResponse;
 import io.gmss.fiscad.persistence.repositories.decoupage.ArrondissementRepository;
 import io.gmss.fiscad.persistence.repositories.infocad.metier.EnqueteRepository;
@@ -18,7 +15,6 @@ import io.gmss.fiscad.persistence.repositories.rfu.metier.DonneesImpositionTfuRe
 import io.gmss.fiscad.persistence.repositories.rfu.metier.ImpositionsTfuRepository;
 import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuNonBatiRepository;
 import io.gmss.fiscad.persistence.repositories.rfu.parametre.ExerciceRepository;
-import io.gmss.fiscad.service.EntityFromPayLoadService;
 import jakarta.transaction.Transactional;
 import lombok.AllArgsConstructor;
 import org.springframework.dao.DataIntegrityViolationException;
@@ -40,7 +36,6 @@ public class DonneesImpositionTfuServiceImpl implements DonneesImpositionTfuServ
    private final BaremRfuNonBatiRepository baremRfuNonBatiRepository;
    private final ExerciceRepository exerciceRepository;
    private final ArrondissementRepository arrondissementRepository;
-    private final EntityFromPayLoadService entityFromPayLoadService;



@@ -96,43 +91,91 @@ public class DonneesImpositionTfuServiceImpl implements DonneesImpositionTfuServ

    @Override
    @Transactional
-    public ImpositionsTfuPaylaodWeb genererDonneesFiscalesParcelleNonBatie(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb, Long userId) {
-        Integer nb= donneesImpositionTfuRepository.genererDonneesTfuNonBatie(impositionsTfuPaylaodWeb.getId(),userId);
+    public Long genererDonneesFiscales(ImpositionsTfu impositionsTfu) {
+        List<DonneesImpositionTfuResponse> donneesImpositionTfuResponses= donneesImpositionTfuRepository.findAllDonneesImpositionTfu(impositionsTfu.getCommune().getId(),impositionsTfu.getExercice().getAnnee());
+        Long n=0l;
+        for (DonneesImpositionTfuResponse donneesImpositionTfuResponse: donneesImpositionTfuResponses){
+            DonneesImpositionTfu donneesImpositionTfu=new DonneesImpositionTfu();
+            donneesImpositionTfu.setImpositionsTfu(impositionsTfu);
+            donneesImpositionTfu.setZoneRfuId(donneesImpositionTfuResponse.getZoneRfuId());
+            donneesImpositionTfu.setCodeQuartierVillage(donneesImpositionTfuResponse.getCodeQuartierVillage());
+            donneesImpositionTfu.setNomQuartierVillage(donneesImpositionTfuResponse.getNomQuartierVillage());
+            donneesImpositionTfu.setCodeArrondissement(donneesImpositionTfuResponse.getCodeArrondissement());
+            donneesImpositionTfu.setNomArrondissement(donneesImpositionTfuResponse.getNomArrondissement());
+            donneesImpositionTfu.setCodeCommune(donneesImpositionTfuResponse.getCodeCommune());
+            donneesImpositionTfu.setNomCommune(donneesImpositionTfuResponse.getNomCommune());
+            donneesImpositionTfu.setCodeDepartement(donneesImpositionTfuResponse.getCodeDepartement());
+            donneesImpositionTfu.setNomDepartement(donneesImpositionTfuResponse.getNomDepartement());
+            donneesImpositionTfu.setQ(donneesImpositionTfuResponse.getQ());
+            donneesImpositionTfu.setIlot(donneesImpositionTfuResponse.getIlot());
+            donneesImpositionTfu.setParcelle(donneesImpositionTfuResponse.getParcelle());
+            donneesImpositionTfu.setLatitude(donneesImpositionTfuResponse.getLatitude());
+            donneesImpositionTfu.setLongitude(donneesImpositionTfuResponse.getLongitude());
+            donneesImpositionTfu.setNup(donneesImpositionTfuResponse.getNup());
+            donneesImpositionTfu.setNupProvisoire(donneesImpositionTfuResponse.getNupProvisoire());
+            donneesImpositionTfu.setSuperficieParc(donneesImpositionTfuResponse.getSuperficieParc());
+            donneesImpositionTfu.setAdresseProp(donneesImpositionTfuResponse.getAdresseProp());
+            donneesImpositionTfu.setAnnee(donneesImpositionTfuResponse.getAnnee());
+            donneesImpositionTfu.setAdresseSc(donneesImpositionTfuResponse.getAdresseSc());
+            donneesImpositionTfu.setBatieOuiNon(donneesImpositionTfuResponse.getBatieOuiNon());
+            donneesImpositionTfu.setTfuMinimum(donneesImpositionTfuResponse.getTfuMinimum());
+            donneesImpositionTfu.setCategorieBat(donneesImpositionTfuResponse.getCategorieBat());
+            donneesImpositionTfu.setDateEnquete(donneesImpositionTfuResponse.getDateEnquete());
+            donneesImpositionTfu.setEmailProp(donneesImpositionTfuResponse.getEmailProp());
+            donneesImpositionTfu.setEmailSc(donneesImpositionTfuResponse.getEmailSc());
+            donneesImpositionTfu.setMontantLoyerAnnuel(donneesImpositionTfuResponse.getMontantLoyerAnnuel());
+            donneesImpositionTfu.setEnqueteId(donneesImpositionTfuResponse.getEnqueteId());
+            donneesImpositionTfu.setExhonereOuiNon(donneesImpositionTfuResponse.getExhonereOuiNon());
+            donneesImpositionTfu.setIfu(donneesImpositionTfuResponse.getIfu());
+            donneesImpositionTfu.setNombreBat(donneesImpositionTfuResponse.getNombreBat());
+            donneesImpositionTfu.setNombrePiscine(donneesImpositionTfuResponse.getNombrePiscine());
+            donneesImpositionTfu.setNombreUlog(donneesImpositionTfuResponse.getNombreUlog());
+            donneesImpositionTfu.setNomProp(donneesImpositionTfuResponse.getNomProp());
+            donneesImpositionTfu.setNomSc(donneesImpositionTfuResponse.getNomSc());
+            donneesImpositionTfu.setNpi(donneesImpositionTfuResponse.getNpi());
+            donneesImpositionTfu.setNumBatiment(donneesImpositionTfuResponse.getNumBatiment()==null?"":donneesImpositionTfuResponse.getNumBatiment());
+            donneesImpositionTfu.setNumUniteLogement(donneesImpositionTfuResponse.getNumUniteLogement()==null?"":donneesImpositionTfuResponse.getNumUniteLogement());
+            donneesImpositionTfu.setPrenomProp(donneesImpositionTfuResponse.getPrenomProp());
+            donneesImpositionTfu.setPrenomSc(donneesImpositionTfuResponse.getPrenomSc());
+            donneesImpositionTfu.setRaisonSociale(donneesImpositionTfuResponse.getRaisonSociale());
+            donneesImpositionTfu.setSecteurId(donneesImpositionTfuResponse.getSecteurId());
+            donneesImpositionTfu.setStandingBat(donneesImpositionTfuResponse.getStandingBat());
+            donneesImpositionTfu.setStructureId(donneesImpositionTfuResponse.getStructureId());
+            donneesImpositionTfu.setSuperficieAuSolBat(donneesImpositionTfuResponse.getSuperficieAuSolBat());
+            donneesImpositionTfu.setSuperficieAuSolUlog(donneesImpositionTfuResponse.getSuperficieAuSolUlog());
+            donneesImpositionTfu.setTelProp(donneesImpositionTfuResponse.getTelProp());
+            donneesImpositionTfu.setTelSc(donneesImpositionTfuResponse.getTelSc());
+            donneesImpositionTfu.setTfuMetreCarre(donneesImpositionTfuResponse.getTfuMetreCarre());
+            donneesImpositionTfu.setTitreFoncier(donneesImpositionTfuResponse.getTitreFoncier());
+            donneesImpositionTfu.setValeurLocativeAdm(donneesImpositionTfuResponse.getValeurLocativeAdm());
+            donneesImpositionTfu.setBatimentExhonereOuiNon(donneesImpositionTfuResponse.getBatimentExhonereOuiNon());
+            donneesImpositionTfu.setUniteLogementExhonereOuiNon(donneesImpositionTfuResponse.getUniteLogementExhonereOuiNon());
+            try {
+                Optional<BaremRfuNonBati> baremRfuNonBatiOptional=baremRfuNonBatiRepository.findAllByCommune_IdAndZoneRfu_Id(impositionsTfu.getCommune().getId(),donneesImpositionTfu.getZoneRfuId());
+                 if(baremRfuNonBatiOptional.isPresent()){
+                     donneesImpositionTfu.setValeurAdministrativeParcelleNonBati(baremRfuNonBatiOptional.get().getValeurAdministrative());
+                     donneesImpositionTfu.setTauxParcelleNonBati(baremRfuNonBatiOptional.get().getTaux());
+                 }

-        ImpositionsTfu impositionsTfu = entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-        impositionsTfu.setStatusAvis(StatusAvis.TFU_FNB_GENERE);
-
-        impositionsTfu.setNombreAvisFnb(nb);

+                donneesImpositionTfuRepository.save(donneesImpositionTfu);
+                n++;
+            }catch (DataIntegrityViolationException e) {
+                if (e.getCause() instanceof org.hibernate.exception.ConstraintViolationException constraintEx &&
+                        constraintEx.getSQLException().getSQLState().equals("23505")) {
+                    System.out.println("Doublon détecté (clé unique) !");
+                } else {
+                    throw e;
+                }
+            }
+        }
        impositionsTfuRepository.save(impositionsTfu);
-
-        return impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
+        return n;
    }

    @Override
-    @Transactional
-    public ImpositionsTfuPaylaodWeb genererDonneesFiscalesParcelleBatie(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb, Long userId) {
-
-        Integer nbb= donneesImpositionTfuRepository.genererDonneesTfuBatie(impositionsTfuPaylaodWeb.getId(),userId);
-
-        Integer nbulo= donneesImpositionTfuRepository.genererDonneesTfuBatieUniteLogement(impositionsTfuPaylaodWeb.getId(),userId);
-
-
-        ImpositionsTfu impositionsTfu = entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-        impositionsTfu.setStatusAvis(StatusAvis.GENERE);
-
-        impositionsTfu.setNombreAvis(nbb+nbulo+ (impositionsTfu.getNombreAvisFnb()==null?0:impositionsTfu.getNombreAvisFnb()));
-        impositionsTfu.setNombreAvisBatiment(nbb);
-        impositionsTfu.setNombreAvisUniteLog(nbulo);
-
-        impositionsTfuRepository.save(impositionsTfu);
-
-        return impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
-    }
-
-    @Override
-    public List<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImposition(Long impositionsId) {
-        return donneesImpositionTfuRepository.findAllByImpositionTfuId(impositionsId);
+    public List<DonneesImpositionTfu> getDonneesFiscalesByImposition(Long impositionsId) {
+        return donneesImpositionTfuRepository.findAllByImpositionsTfu_Id(impositionsId);
    }

    @Override
@@ -144,24 +187,4 @@ public class DonneesImpositionTfuServiceImpl implements DonneesImpositionTfuServ
            return null;
        }
    }
-
-    @Override
-    public Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdPageable(Long impositionsTfuId, Pageable pageable) {
-        return donneesImpositionTfuRepository.findAllByImpositionTfuIdPageable(impositionsTfuId,pageable);
-    }
-
-    @Override
-    public Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdNonBatiePageable(Long impositionsTfuId, Pageable pageable) {
-        return donneesImpositionTfuRepository.findAllByImpositionTfuIdNonBatiePageable(impositionsTfuId,pageable);
-    }
-
-    @Override
-    public Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdBatieBatimentPageable(Long impositionsTfuId, Pageable pageable) {
-        return donneesImpositionTfuRepository.findAllByImpositionTfuIdBatieBatimentPageable(impositionsTfuId,pageable);
-    }
-
-    @Override
-    public Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdBatieUniteLogPageable(Long impositionsTfuId, Pageable pageable) {
-        return donneesImpositionTfuRepository.findAllByImpositionTfuIdBatieUniteLogPageable(impositionsTfuId,pageable);
-    }
 }
--- a/src/main/java/io/gmss/fiscad/implementations/rfu/metier/ImpositionsTfuServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/metier/ImpositionsTfuServiceImpl.java
@@ -1,154 +1,81 @@
 package io.gmss.fiscad.implementations.rfu.metier;

-import io.gmss.fiscad.entities.infocad.parametre.Structure;
 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
 import io.gmss.fiscad.enums.StatusAvis;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.interfaces.infocad.metier.EnqueteService;
-import io.gmss.fiscad.interfaces.infocad.parametre.StructureService;
 import io.gmss.fiscad.interfaces.rfu.metier.ImpositionsTfuService;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
 import io.gmss.fiscad.persistence.repositories.rfu.metier.ImpositionsTfuRepository;
-import io.gmss.fiscad.service.EntityFromPayLoadService;
-import jakarta.transaction.Transactional;
-import jakarta.ws.rs.NotAcceptableException;
-import lombok.AllArgsConstructor;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.stereotype.Service;

 import java.time.LocalDate;
-import java.util.ArrayList;
 import java.util.List;
 import java.util.Optional;
-@AllArgsConstructor
+
@Service
 public class ImpositionsTfuServiceImpl implements ImpositionsTfuService {

    private final ImpositionsTfuRepository impositionsTfuRepository;
-    private final StructureService structureService;
-    private final EntityFromPayLoadService entityFromPayLoadService;
-    private final EnqueteService enqueteService;

+    public ImpositionsTfuServiceImpl(ImpositionsTfuRepository impositionsTfuRepository) {
+        this.impositionsTfuRepository = impositionsTfuRepository;
+    }

-    /**
-     * Permet de créer pour un centre la synthèse de l'imposition de l'année en prélude de la
-     * génération des avis d'imposition
-     * @param impositionsTfuPaylaodWeb
-     * @return
-     * @throws BadRequestException
-     */
    @Override
-    @Transactional
-    public ImpositionsTfuPaylaodWeb createImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException {
-        if (impositionsTfuPaylaodWeb.getId() != null) {
+    public ImpositionsTfu createImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException {
+        if (impositionsTfu.getId() != null) {
            throw new BadRequestException("Impossible de créer une nouvelle unité de logement ayant un id non null.");
        }
-        List<ImpositionsTfu> impositionsTfus=impositionsTfuRepository.getImpositionsTfuByStructureAndExercice(impositionsTfuPaylaodWeb.getStructureId(), impositionsTfuPaylaodWeb.getExerciceId());
+         List<ImpositionsTfu> impositionsTfus=impositionsTfuRepository.getImpositionsTfuByCommuneAndExercice(impositionsTfu.getCommune().getCode(),impositionsTfu.getExercice().getAnnee());
        if (!impositionsTfus.isEmpty()) {
            throw new BadRequestException("Une Imposition non annulée existe déjà");
        }
-        List<StatusAvis> statusAvis= new ArrayList<>();
-        statusAvis.add(StatusAvis.EN_COURS);
-        statusAvis.add(StatusAvis.CLOTURE);
-        statusAvis.add(StatusAvis.GENERATION_AUTORISE);
-
-        Optional<ImpositionsTfu> optionalImpositionsTfu= impositionsTfuRepository.findDistinctByStructure_IdAndExercice_IdAndStatusAvisIn(impositionsTfuPaylaodWeb.getStructureId(),impositionsTfuPaylaodWeb.getExerciceId(),statusAvis);
-
-        if(optionalImpositionsTfu.isPresent()){
-            throw new BadRequestException("Une Imposition est déjà dans le workflow");
-        }
-
-        ImpositionsTfu impositionsTfu=entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-
-        impositionsTfu.setStatusAvis(StatusAvis.EN_COURS);
-
-        impositionsTfu =impositionsTfuRepository.save(impositionsTfu);
-
-        return  impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
+        impositionsTfu.setStatusAvis(StatusAvis.CREE);
+        impositionsTfu.setDateGeneration(LocalDate.now());
+        return impositionsTfuRepository.save(impositionsTfu);
    }

    @Override
-    public ImpositionsTfuPaylaodWeb rejeterImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException {
-        if (impositionsTfuPaylaodWeb.getId() == null) {
+    public ImpositionsTfu annulerImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException {
+        if (impositionsTfu.getId() == null) {
            throw new BadRequestException("Impossible d'annuler une imposition ayant un id null.");
        }
-        if (!impositionsTfuRepository.existsById(impositionsTfuPaylaodWeb.getId())) {
+        if (!impositionsTfuRepository.existsById(impositionsTfu.getId())) {
            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans notre base de données.");
        }
-        ImpositionsTfu impositionsTfu= entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-        if(!impositionsTfu.getStatusAvis().equals(StatusAvis.CLOTURE)){
-            throw new NotAcceptableException("L'état actuel :"+impositionsTfu.getStatusAvis()+"Ne permet pas de passer au l'état rejete");
-        }
-
-        impositionsTfu.setStatusAvis(StatusAvis.REJETE);
-        impositionsTfu =impositionsTfuRepository.save(impositionsTfu);
-        return  impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
-    }
-
-
-    @Override
-    @Transactional
-    public ImpositionsTfuPaylaodWeb cloturerImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException {
-        if (impositionsTfuPaylaodWeb.getId() == null) {
-            throw new BadRequestException("Impossible de cloturer une imposition ayant un id null.");
-        }
-        if (!impositionsTfuRepository.existsById(impositionsTfuPaylaodWeb.getId())) {
-            throw new NotFoundException("Impossible de trouver l'imposition spécifiée dans notre base de données.");
-        }
-
-        ImpositionsTfu impositionsTfu= entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-
-        if(!impositionsTfu.getStatusAvis().equals(StatusAvis.EN_COURS) && !impositionsTfu.getStatusAvis().equals(StatusAvis.REJETE)){
-            throw new NotAcceptableException("L'état actuel :"+impositionsTfu.getStatusAvis()+"Ne permet pas de passer au l'état rejete");
-        }
-
-        impositionsTfu.setDateCloture(LocalDate.now());
-        enqueteService.cloturerEnqueteParcelleBatimentUniteLogementByStructureIdAndExerciceId(impositionsTfu.getStructure().getId(),impositionsTfu.getExercice().getId());
-        impositionsTfu.setStatusAvis(StatusAvis.CLOTURE);
-        impositionsTfu =impositionsTfuRepository.save(impositionsTfu);
-        return  impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
+        impositionsTfu.setStatusAvis(StatusAvis.ANNULE);
+        return impositionsTfuRepository.save(impositionsTfu);
    }

    @Override
-    public ImpositionsTfuPaylaodWeb autoriserGenerationImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException {
-        if (impositionsTfuPaylaodWeb.getId() == null) {
+    public ImpositionsTfu validerImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException {
+        if (impositionsTfu.getId() == null) {
            throw new BadRequestException("Impossible de valider une imposition ayant un id null.");
        }
-        if (!impositionsTfuRepository.existsById(impositionsTfuPaylaodWeb.getId())) {
-            throw new NotFoundException("Impossible de trouver l'imposition spécifiée dans notre base de données.");
+        if (!impositionsTfuRepository.existsById(impositionsTfu.getId())) {
+            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans notre base de données.");
        }
-
-        ImpositionsTfu impositionsTfu= entityFromPayLoadService.getImpositionsTfuFromPayLoadWeb(impositionsTfuPaylaodWeb);
-
-        if(!impositionsTfu.getStatusAvis().equals(StatusAvis.CLOTURE)){
-            throw new NotFoundException("L'état actuel : "+impositionsTfu.getStatusAvis()+ " ne permet pas de passer à l'état Autorisé");
-        }
-        impositionsTfu.setDateGeneration(LocalDate.now());
-        impositionsTfu.setStatusAvis(StatusAvis.GENERATION_AUTORISE);
-        impositionsTfu =impositionsTfuRepository.save(impositionsTfu);
-        return  impositionsTfuRepository.findByIdToDto(impositionsTfu.getId()).orElse(null);
+        impositionsTfu.setStatusAvis(StatusAvis.VALIDE);
+        return impositionsTfuRepository.save(impositionsTfu);
    }

    @Override
-    public ImpositionsTfuPaylaodWeb updateImpositionsTfu(Long id, ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws NotFoundException {
-//        if (impositionsTfu.getId() == null) {
-//            throw new BadRequestException("Impossible de mettre à jour une nouvelle unité de logement ayant un id null.");
-//        }
-//        if (!impositionsTfuRepository.existsById(impositionsTfu.getId())) {
-//            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans notre base de données.");
-//        }
-        return null; // impositionsTfuRepository.save(impositionsTfu);
+    public ImpositionsTfu updateImpositionsTfu(Long id, ImpositionsTfu impositionsTfu) throws NotFoundException {
+        if (impositionsTfu.getId() == null) {
+            throw new BadRequestException("Impossible de mettre à jour une nouvelle unité de logement ayant un id null.");
+        }
+        if (!impositionsTfuRepository.existsById(impositionsTfu.getId())) {
+            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans notre base de données.");
+        }
+        return impositionsTfuRepository.save(impositionsTfu);
    }

    @Override
    public void deleteImpositionsTfu(Long id) throws NotFoundException {
        Optional<ImpositionsTfu> impositionsTfuOptional = impositionsTfuRepository.findById(id);
        if (impositionsTfuOptional.isPresent()) {
-            if(!impositionsTfuOptional.get().getStatusAvis().equals(StatusAvis.EN_COURS)){
-                throw new NotFoundException("L'état actuel : "+impositionsTfuOptional.get().getStatusAvis()+ " ne permet pas de supprimer");
-            }
            impositionsTfuRepository.deleteById(impositionsTfuOptional.get().getId());
        } else {
            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans notre base de données.");
@@ -167,22 +94,11 @@ public class ImpositionsTfuServiceImpl implements ImpositionsTfuService {


    @Override
-    public Optional<ImpositionsTfuPaylaodWeb> getImpositionsTfuById(Long id) {
+    public Optional<ImpositionsTfu> getImpositionsTfuById(Long id) {
        if (impositionsTfuRepository.existsById(id)) {
-            return impositionsTfuRepository.findByIdToDto(id);
+            return impositionsTfuRepository.findById(id);
        } else {
            throw new NotFoundException("Impossible de trouver la nouvelle unité de logement spécifiée dans la base de données.");
        }
    }
-
-    @Override
-    public List<ImpositionsTfuPaylaodWeb> getImpositionsTfuByUserIdIds(Long userId) {
-        System.out.println(userId);
-        List<Structure> structures = structureService.getListStructureUserId(userId);
-        List<Long> structureIds = structures.stream()
-                .map(Structure::getId)
-                .toList();
-        System.out.println(structureIds.get(0));
-        return impositionsTfuRepository.findByStructureIdsToDto(structureIds);
-    }
 }
--- a/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuBatiServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuBatiServiceImpl.java
@@ -1,92 +0,0 @@
-package io.gmss.fiscad.implementations.rfu.parametre;
-
-import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
-import io.gmss.fiscad.exceptions.BadRequestException;
-import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuBatiService;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb;
-import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuRepository;
-import io.gmss.fiscad.service.EntityFromPayLoadService;
-import lombok.AllArgsConstructor;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-import java.util.Optional;
-@AllArgsConstructor
-@Service
-public class BaremRfuBatiServiceImpl implements BaremRfuBatiService {
-    private final BaremRfuRepository baremRfuRepository;
-    private final EntityFromPayLoadService entityFromPayLoadService;
-
-
-
-    @Override
-    public BaremRfuBatiPayloadWeb createBaremRfu(BaremRfuBatiPayloadWeb baremRfuBatiPayloadWeb) throws BadRequestException {
-        if (baremRfuBatiPayloadWeb.getId() != null) {
-            throw new BadRequestException("Impossible de créer un nouvel bareme rfu ayant un id non null.");
-        }
-        BaremRfuBati baremRfuBati = entityFromPayLoadService.getBaremRfuBatiFromPayLoadWeb(baremRfuBatiPayloadWeb);
-        baremRfuBati = baremRfuRepository.save(baremRfuBati);
-        return baremRfuRepository.findByBaremRfuBatieId(baremRfuBati.getId()).orElse(null);
-    }
-
-    @Override
-    public BaremRfuBatiPayloadWeb updateBaremRfu(Long id, BaremRfuBatiPayloadWeb baremRfuBatiPayloadWeb) throws NotFoundException {
-        if (baremRfuBatiPayloadWeb.getId() == null) {
-            throw new BadRequestException("Impossible de mettre à jour une nouvel bareme rfu ayant un id null.");
-        }
-        if (!baremRfuRepository.existsById(baremRfuBatiPayloadWeb.getId())) {
-            throw new NotFoundException("Impossible de trouver le bareme spécifiée dans notre base de données.");
-        }
-        BaremRfuBati baremRfuBati = entityFromPayLoadService.getBaremRfuBatiFromPayLoadWeb(baremRfuBatiPayloadWeb);
-        baremRfuBati = baremRfuRepository.save(baremRfuBati);
-        return baremRfuRepository.findByBaremRfuBatieId(baremRfuBati.getId()).orElse(null);
-    }
-
-    @Override
-    public void deleteBaremRfu(Long id) throws NotFoundException {
-        Optional<BaremRfuBati> baremRfuOptional = baremRfuRepository.findById(id);
-        if (baremRfuOptional.isPresent()) {
-            baremRfuRepository.deleteById(baremRfuOptional.get().getId());
-        } else {
-            throw new NotFoundException("Impossible de trouver le Bareme spécifié dans notre base de données.");
-        }
-    }
-
-    @Override
-    public Page<BaremRfuBatiPayloadWeb> getBaremRfuList(Pageable pageable) {
-        return baremRfuRepository.findAllPayloadPaged(pageable);
-    }
-
-    @Override
-    public List<BaremRfuBatiPayloadWeb> getBaremRfuList() {
-        return baremRfuRepository.findAllPayload();
-    }
-
-    @Override
-    public List<BaremRfuBatiPayloadWeb> getBaremRfuByCategorieBatiment(Long idCategorieBatiment) {
-        return baremRfuRepository.findByCategorieBatiment(idCategorieBatiment);
-    }
-
-    @Override
-    public List<BaremRfuBatiPayloadWeb> getBaremRfuByArrondissement(Long idArrondissement) {
-        return baremRfuRepository.findByArrondissementId(idArrondissement);
-    }
-
-    @Override
-    public List<BaremRfuBatiPayloadWeb> getBaremRfuByArrondissementAndCategorieBatiment(Long IdArrondissement, Long IdCategorieBatiment) {
-        return baremRfuRepository.findByArrondissementAndCategorieBatiment(IdArrondissement,IdCategorieBatiment);
-    }
-
-    @Override
-    public List<BaremRfuBatiPayloadWeb> getBaremRfuByQuartierAndCategorieBatiment(Long idQuartier, Long IdCategorieBatiment) {
-        return baremRfuRepository.findByQuartierAndCategorieBatiment(idQuartier,IdCategorieBatiment);
-    }
-
-    @Override
-    public BaremRfuBatiPayloadWeb getBaremRfuById(Long id) {
-        return baremRfuRepository.findByBaremRfuBatieId(id).orElse(null);
-    }
-}
--- a/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuNonBatiServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuNonBatiServiceImpl.java
@@ -4,42 +4,38 @@ import io.gmss.fiscad.entities.rfu.parametre.BaremRfuNonBati;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
 import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuNonBatiService;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb;
 import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuNonBatiRepository;
-import io.gmss.fiscad.service.EntityFromPayLoadService;
-import lombok.AllArgsConstructor;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.stereotype.Service;

 import java.util.List;
 import java.util.Optional;
-@AllArgsConstructor
+
@Service
 public class BaremRfuNonBatiServiceImpl implements BaremRfuNonBatiService {
    private final BaremRfuNonBatiRepository baremRfuNonBatiRepository;
-    private final EntityFromPayLoadService entityFromPayLoadService;
+
+    public BaremRfuNonBatiServiceImpl(BaremRfuNonBatiRepository baremRfuNonBatiRepository) {
+        this.baremRfuNonBatiRepository = baremRfuNonBatiRepository;
+    }

    @Override
-    public BaremRfuNonBatiPayloadWeb createBaremRfuNonBati(BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) throws BadRequestException {
-        if (baremRfuNonBatiPayloadWeb.getId() != null) {
+    public BaremRfuNonBati createBaremRfuNonBati(BaremRfuNonBati baremRfuNonBati) throws BadRequestException {
+        if (baremRfuNonBati.getId() != null) {
            throw new BadRequestException("Impossible de créer une nouvelle campgne ayant un id non null.");
        }
-      BaremRfuNonBati baremRfuNonBati=  entityFromPayLoadService.getBaremRfuNonBatiFromPayLoadWeb(baremRfuNonBatiPayloadWeb);
-      baremRfuNonBati=baremRfuNonBatiRepository.save(baremRfuNonBati);
-      return baremRfuNonBatiRepository.findByIdToDto(baremRfuNonBati.getId()).orElse(null);
+        return baremRfuNonBatiRepository.save(baremRfuNonBati);
    }
    @Override
-    public BaremRfuNonBatiPayloadWeb updateBaremRfuNonBati(Long id, BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) throws NotFoundException {
-        if (baremRfuNonBatiPayloadWeb.getId() == null) {
+    public BaremRfuNonBati updateBaremRfuNonBati(Long id, BaremRfuNonBati baremRfuNonBati) throws NotFoundException {
+        if (baremRfuNonBati.getId() == null) {
            throw new BadRequestException("Impossible de mettre à jour une nouvelle baremRfuNonBati ayant un id null.");
        }
-        if (!baremRfuNonBatiRepository.existsById(baremRfuNonBatiPayloadWeb.getId())) {
+        if (!baremRfuNonBatiRepository.existsById(baremRfuNonBati.getId())) {
            throw new NotFoundException("Impossible de trouver la baremRfuNonBati spécifiée dans notre base de données.");
        }
-        BaremRfuNonBati baremRfuNonBati=  entityFromPayLoadService.getBaremRfuNonBatiFromPayLoadWeb(baremRfuNonBatiPayloadWeb);
-        baremRfuNonBati=baremRfuNonBatiRepository.save(baremRfuNonBati);
-        return baremRfuNonBatiRepository.findByIdToDto(baremRfuNonBati.getId()).orElse(null);
+        return baremRfuNonBatiRepository.save(baremRfuNonBati);
    }

    @Override
@@ -52,27 +48,20 @@ public class BaremRfuNonBatiServiceImpl implements BaremRfuNonBatiService {
        }
    }
    @Override
-    public Page<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiList(Pageable pageable) {
-        return baremRfuNonBatiRepository.findAllPayloadToDtoPaged(pageable);
+    public Page<BaremRfuNonBati> getBaremRfuNonBatiList(Pageable pageable) {
+        return baremRfuNonBatiRepository.findAll(pageable);
    }

    @Override
-    public List<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiList() {
-        return baremRfuNonBatiRepository.findAllPayloadToDto();
+    public List<BaremRfuNonBati> getBaremRfuNonBatiList() {
+        return baremRfuNonBatiRepository.findAll();
    }



    @Override
-    public Optional<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiById(Long id) {
-        return baremRfuNonBatiRepository.findByIdToDto(id);
+    public Optional<BaremRfuNonBati> getBaremRfuNonBatiById(Long id) {
+        return baremRfuNonBatiRepository.findById(id);
    }
-
-
-    @Override
-    public Optional<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiByCommuneAndZoneId(Long communeId,Long zoneId) {
-        return baremRfuNonBatiRepository.findByCommuneAndZoneToDto(communeId,zoneId);
-    }
-
 }

--- a/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuServiceImpl.java
+++ b/src/main/java/io/gmss/fiscad/implementations/rfu/parametre/BaremRfuServiceImpl.java
@@ -0,0 +1,70 @@
+package io.gmss.fiscad.implementations.rfu.parametre;
+
+import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
+import io.gmss.fiscad.exceptions.BadRequestException;
+import io.gmss.fiscad.exceptions.NotFoundException;
+import io.gmss.fiscad.interfaces.rfu.parametre.BaremRfuService;
+import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuRepository;
+import org.springframework.data.domain.Page;
+import org.springframework.data.domain.Pageable;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+import java.util.Optional;
+@Service
+public class BaremRfuServiceImpl implements BaremRfuService {
+    private final BaremRfuRepository baremRfuRepository;
+
+    public BaremRfuServiceImpl(BaremRfuRepository baremRfuRepository) {
+        this.baremRfuRepository = baremRfuRepository;
+    }
+
+    @Override
+    public BaremRfuBati createBaremRfu(BaremRfuBati baremRfuBati) throws BadRequestException {
+        if (baremRfuBati.getId() != null) {
+            throw new BadRequestException("Impossible de créer un nouvel bareme rfu ayant un id non null.");
+        }
+        return baremRfuRepository.save(baremRfuBati);
+    }
+
+    @Override
+    public BaremRfuBati updateBaremRfu(Long id, BaremRfuBati baremRfuBati) throws NotFoundException {
+        if (baremRfuBati.getId() == null) {
+            throw new BadRequestException("Impossible de mettre à jour une nouvel bareme rfu ayant un id null.");
+        }
+        if (!baremRfuRepository.existsById(baremRfuBati.getId())) {
+            throw new NotFoundException("Impossible de trouver le bareme spécifiée dans notre base de données.");
+        }
+        return baremRfuRepository.save(baremRfuBati);
+    }
+
+    @Override
+    public void deleteBaremRfu(Long id) throws NotFoundException {
+        Optional<BaremRfuBati> baremRfuOptional = baremRfuRepository.findById(id);
+        if (baremRfuOptional.isPresent()) {
+            baremRfuRepository.deleteById(baremRfuOptional.get().getId());
+        } else {
+            throw new NotFoundException("Impossible de trouver le Bareme spécifié dans notre base de données.");
+        }
+    }
+
+    @Override
+    public Page<BaremRfuBati> getBaremRfuList(Pageable pageable) {
+        return baremRfuRepository.findAll(pageable);
+    }
+
+    @Override
+    public List<BaremRfuBati> getBaremRfuList() {
+        return baremRfuRepository.findAll();
+    }
+
+    @Override
+    public List<BaremRfuBati> getBaremRfuByType(Long idCategorieBatiment) {
+        return baremRfuRepository.findAllByCategorieBatiment_Id(idCategorieBatiment);
+    }
+
+    @Override
+    public Optional<BaremRfuBati> getBaremRfuById(Long id) {
+        return baremRfuRepository.findById(id);
+    }
+}
--- a/src/main/java/io/gmss/fiscad/interfaces/decoupage/SecteurService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/decoupage/SecteurService.java
@@ -32,5 +32,4 @@ public interface SecteurService {
    Optional<SecteurPaylaodWeb> getSecteurById(Long id);

    List<Secteur> getListSecteurUserId(Long userId) ;
-    List<Secteur> getListSecteurByDepartementId(Long departementId) ;
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/infocad/metier/EnqueteService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/infocad/metier/EnqueteService.java
@@ -58,6 +58,5 @@ public interface EnqueteService {

    public List<EnqueteNonSyncResponse> getEnqueteValideNonSynch(Long terminalId);

-    int cloturerEnqueteParcelleBatimentUniteLogementByStructureIdAndExerciceId(Long strucutreId,Long exerciceId);
-    int cloturerEnqueteParcelleBatimentUniteLogementByUserIdAndExerciceId(Long userId,Long exerciceId);
+
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/infocad/metier/ParcelleService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/infocad/metier/ParcelleService.java
@@ -35,5 +35,4 @@ public interface ParcelleService {
    Page<ParcellePayLoadWeb> getParcelleListByRuePageableToDto(Long userId,Long rueId,Pageable pageable);

    Page<ParcellePayLoadWeb> getParcelleByMultiFiltre(Long userId, FiltreParcelle filtreParcelle, Pageable pageable);
-    Integer majParcelleBatieNonbatie();
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/infocad/parametre/StructureService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/infocad/parametre/StructureService.java
@@ -1,8 +1,6 @@
 package io.gmss.fiscad.interfaces.infocad.parametre;

-import io.gmss.fiscad.entities.decoupage.Secteur;
 import io.gmss.fiscad.entities.infocad.parametre.Structure;
-import io.gmss.fiscad.entities.user.AvoirFonction;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
 import io.gmss.fiscad.paylaods.request.crudweb.StructurePaylaodWeb;
@@ -10,8 +8,6 @@ import io.gmss.fiscad.paylaods.response.StructureResponse;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;

-import java.time.LocalDate;
-import java.util.ArrayList;
 import java.util.List;
 import java.util.Optional;

@@ -35,6 +31,4 @@ public interface StructureService {
    //List<StructureResponse> getStructuresByArrondissement(Long arrondissementID);


-    public List<Structure> getListStructureUserId(Long userId) ;
-
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/rfu/metier/DonneesImpositionTfuService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/rfu/metier/DonneesImpositionTfuService.java
@@ -4,8 +4,6 @@ import io.gmss.fiscad.entities.rfu.metier.DonneesImpositionTfu;
 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;

@@ -13,6 +11,8 @@ import java.util.List;
 import java.util.Optional;

 public interface DonneesImpositionTfuService {
+
+
    DonneesImpositionTfu createDonneesImpositionTfu(DonneesImpositionTfu donneesImpositionTfu) throws BadRequestException;

    DonneesImpositionTfu updateDonneesImpositionTfu(Long id, DonneesImpositionTfu donneesImpositionTfu) throws NotFoundException;
@@ -25,17 +25,7 @@ public interface DonneesImpositionTfuService {

    Optional<DonneesImpositionTfu> getDonneesImpositionTfuById(Long id);

-    ImpositionsTfuPaylaodWeb genererDonneesFiscalesParcelleBatie(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb,Long userId);
-    ImpositionsTfuPaylaodWeb genererDonneesFiscalesParcelleNonBatie(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb,Long userId);
-    List<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImposition(Long  impositionsId);
+    Long genererDonneesFiscales(ImpositionsTfu impositionsTfu);
+    List<DonneesImpositionTfu> getDonneesFiscalesByImposition(Long  impositionsId);
    List<DonneesImpositionTfu> getDonneesFiscalesByImpositionArrondissement(Long  impositionsId,Long arrondissementId);
-    Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdPageable(Long  impositionsTfuId, Pageable pageable);
-
-
-    Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdNonBatiePageable(Long  impositionsTfuId, Pageable pageable);
-    Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdBatieBatimentPageable(Long  impositionsTfuId, Pageable pageable);
-    Page<DonneesImpositionPaylaodWeb> getDonneesFiscalesByImpositionTfuIdBatieUniteLogPageable(Long  impositionsTfuId, Pageable pageable);
-
-
-
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/rfu/metier/ImpositionsTfuService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/rfu/metier/ImpositionsTfuService.java
@@ -3,7 +3,6 @@ package io.gmss.fiscad.interfaces.rfu.metier;
 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;

@@ -12,12 +11,11 @@ import java.util.Optional;

 public interface ImpositionsTfuService {

-    ImpositionsTfuPaylaodWeb createImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException;
-    ImpositionsTfuPaylaodWeb rejeterImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException;
-    ImpositionsTfuPaylaodWeb cloturerImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException;
-    ImpositionsTfuPaylaodWeb autoriserGenerationImpositionsTfu(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws BadRequestException;
+    ImpositionsTfu createImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException;
+    ImpositionsTfu annulerImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException;
+    ImpositionsTfu validerImpositionsTfu(ImpositionsTfu impositionsTfu) throws BadRequestException;

-    ImpositionsTfuPaylaodWeb updateImpositionsTfu(Long id, ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb) throws NotFoundException;
+    ImpositionsTfu updateImpositionsTfu(Long id, ImpositionsTfu impositionsTfu) throws NotFoundException;

    void deleteImpositionsTfu(Long id) throws NotFoundException;

@@ -25,6 +23,5 @@ public interface ImpositionsTfuService {

    List<ImpositionsTfu> getImpositionsTfuList();

-    Optional<ImpositionsTfuPaylaodWeb> getImpositionsTfuById(Long id);
-    List<ImpositionsTfuPaylaodWeb> getImpositionsTfuByUserIdIds(Long userId);
+    Optional<ImpositionsTfu> getImpositionsTfuById(Long id);
 }
--- a/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuBatiService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuBatiService.java
@@ -1,32 +0,0 @@
-package io.gmss.fiscad.interfaces.rfu.parametre;
-
-import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
-import io.gmss.fiscad.exceptions.BadRequestException;
-import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
-
-import java.util.List;
-import java.util.Optional;
-
-public interface BaremRfuBatiService {
-
-    BaremRfuBatiPayloadWeb createBaremRfu(BaremRfuBatiPayloadWeb baremRfuBati) throws BadRequestException;
-
-    BaremRfuBatiPayloadWeb updateBaremRfu(Long id, BaremRfuBatiPayloadWeb baremRfuBati) throws NotFoundException;
-
-    void deleteBaremRfu(Long id) throws NotFoundException;
-
-    Page<BaremRfuBatiPayloadWeb> getBaremRfuList(Pageable pageable);
-
-    List<BaremRfuBatiPayloadWeb> getBaremRfuList();
-
-    List<BaremRfuBatiPayloadWeb> getBaremRfuByCategorieBatiment(Long IdCategorieBatiment);
-    List<BaremRfuBatiPayloadWeb> getBaremRfuByArrondissement(Long IdArrondissement);
-    List<BaremRfuBatiPayloadWeb> getBaremRfuByArrondissementAndCategorieBatiment(Long IdArrondissement,Long IdCategorieBatiment);
-    List<BaremRfuBatiPayloadWeb> getBaremRfuByQuartierAndCategorieBatiment(Long idQuartier,Long IdCategorieBatiment);
-
-    BaremRfuBatiPayloadWeb getBaremRfuById(Long id);
-}
-
--- a/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuNonBatiService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuNonBatiService.java
@@ -3,7 +3,6 @@ package io.gmss.fiscad.interfaces.rfu.parametre;
 import io.gmss.fiscad.entities.rfu.parametre.BaremRfuNonBati;
 import io.gmss.fiscad.exceptions.BadRequestException;
 import io.gmss.fiscad.exceptions.NotFoundException;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;

@@ -12,18 +11,17 @@ import java.util.Optional;

 public interface BaremRfuNonBatiService {

-    BaremRfuNonBatiPayloadWeb createBaremRfuNonBati(BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) throws BadRequestException;
+    BaremRfuNonBati createBaremRfuNonBati(BaremRfuNonBati baremRfuNonBati) throws BadRequestException;

-    BaremRfuNonBatiPayloadWeb updateBaremRfuNonBati(Long id, BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb) throws NotFoundException;
+    BaremRfuNonBati updateBaremRfuNonBati(Long id, BaremRfuNonBati baremRfuNonBati) throws NotFoundException;

    void deleteBaremRfuNonBati(Long id) throws NotFoundException;

-    Page<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiList(Pageable pageable);
+    Page<BaremRfuNonBati> getBaremRfuNonBatiList(Pageable pageable);

-    List<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiList();
+    List<BaremRfuNonBati> getBaremRfuNonBatiList();


-    Optional<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiById(Long id);
-    Optional<BaremRfuNonBatiPayloadWeb> getBaremRfuNonBatiByCommuneAndZoneId(Long communeId,Long zoneId);
+    Optional<BaremRfuNonBati> getBaremRfuNonBatiById(Long id);
 }

--- a/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuService.java
+++ b/src/main/java/io/gmss/fiscad/interfaces/rfu/parametre/BaremRfuService.java
@@ -0,0 +1,28 @@
+package io.gmss.fiscad.interfaces.rfu.parametre;
+
+import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
+import io.gmss.fiscad.exceptions.BadRequestException;
+import io.gmss.fiscad.exceptions.NotFoundException;
+import org.springframework.data.domain.Page;
+import org.springframework.data.domain.Pageable;
+
+import java.util.List;
+import java.util.Optional;
+
+public interface BaremRfuService {
+
+    BaremRfuBati createBaremRfu(BaremRfuBati baremRfuBati) throws BadRequestException;
+
+    BaremRfuBati updateBaremRfu(Long id, BaremRfuBati baremRfuBati) throws NotFoundException;
+
+    void deleteBaremRfu(Long id) throws NotFoundException;
+
+    Page<BaremRfuBati> getBaremRfuList(Pageable pageable);
+
+    List<BaremRfuBati> getBaremRfuList();
+
+    List<BaremRfuBati> getBaremRfuByType(Long IdCategorieBatiment);
+
+    Optional<BaremRfuBati> getBaremRfuById(Long id);
+}
+
--- a/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/BaremRfuBatiPayloadWeb.java
+++ b/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/BaremRfuBatiPayloadWeb.java
@@ -1,56 +0,0 @@
-package io.gmss.fiscad.paylaods.request.crudweb;
-
-import io.gmss.fiscad.entities.decoupage.Arrondissement;
-import io.gmss.fiscad.entities.rfu.parametre.CategorieBatiment;
-import jakarta.persistence.ManyToOne;
-import lombok.Data;
-import lombok.NoArgsConstructor;
-
-@NoArgsConstructor
-@Data
-public class BaremRfuBatiPayloadWeb {
-    private Long id;
-    private Long valeurLocative;
-    private Double tfuMetreCarre;
-    private Long tfuMinimum;
-    private Long categorieBatimentId;
-    private String categorieBatimentNom;
-    private String categorieBatimentStanding;
-    private Long arrondissementId;
-    private String arrondissementCode;
-    private String arrondissementNom;
-
-    private Long quartierId;
-    private String quartierCode;
-    private String quartierNom;
-
-    private Long communeId;
-    private String communeCode;
-    private String communeNom;
-
-    public BaremRfuBatiPayloadWeb(Long id, Long valeurLocative, Double tfuMetreCarre, Long tfuMinimum, Long categorieBatimentId, String categorieBatimentNom, String categorieBatimentStanding, Long arrondissementId, String arrondissementCode, String arrondissementNom,
-                                  Long quartierId,
-                                  String quartierCode,
-                                  String quartierNom,
-                                   Long communeId,
-                                   String communeCode,
-                                   String communeNom
-                                  ) {
-        this.id = id;
-        this.valeurLocative = valeurLocative;
-        this.tfuMetreCarre = tfuMetreCarre;
-        this.tfuMinimum = tfuMinimum;
-        this.categorieBatimentId = categorieBatimentId;
-        this.categorieBatimentNom = categorieBatimentNom;
-        this.categorieBatimentStanding = categorieBatimentStanding;
-        this.arrondissementId = arrondissementId;
-        this.arrondissementCode = arrondissementCode;
-        this.arrondissementNom = arrondissementNom;
-        this.quartierId = quartierId;
-        this.quartierCode = quartierCode;
-        this.quartierNom = quartierNom;
-        this.communeId = communeId;
-        this.communeCode = communeCode;
-        this.communeNom = communeNom;
-    }
-}
--- a/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/BaremRfuNonBatiPayloadWeb.java
+++ b/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/BaremRfuNonBatiPayloadWeb.java
@@ -1,47 +0,0 @@
-package io.gmss.fiscad.paylaods.request.crudweb;
-
-import io.gmss.fiscad.entities.decoupage.Commune;
-import io.gmss.fiscad.entities.rfu.parametre.ZoneRfu;
-import jakarta.persistence.ManyToOne;
-import lombok.Data;
-import lombok.NoArgsConstructor;
-
-@NoArgsConstructor
-@Data
-public class BaremRfuNonBatiPayloadWeb {
-    private Long id;
-    private Long valeurAdministrative;
-    private float taux;
-    private Long communeId;
-    private String communeCode;
-    private String communeNom;
-    private Long zoneRfuId;
-    private String zoneRfuCode;
-    private String zoneRfuNom;
-    private Long valeurAdministrativeMetreCarre;
-    private Boolean auMetreCarre;
-
-    public BaremRfuNonBatiPayloadWeb(Long id,
-                                     Long valeurAdministrative,
-                                     Float taux,
-                                     Long communeId,
-                                     String communeCode,
-                                     String communeNom,
-                                     Long zoneRfuId,
-                                     String zoneRfuCode,
-                                     String zoneRfuNom,
-                                     Long valeurAdministrativeMetreCarre,
-                                     Boolean auMetreCarre) {
-        this.id = id;
-        this.valeurAdministrative = valeurAdministrative;
-        this.taux = taux;
-        this.communeId = communeId;
-        this.communeCode = communeCode;
-        this.communeNom = communeNom;
-        this.zoneRfuId = zoneRfuId;
-        this.zoneRfuCode = zoneRfuCode;
-        this.zoneRfuNom = zoneRfuNom;
-        this.valeurAdministrativeMetreCarre = valeurAdministrativeMetreCarre;
-        this.auMetreCarre = auMetreCarre;
-    }
-}
--- a/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/DonneesImpositionPaylaodWeb.java
+++ b/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/DonneesImpositionPaylaodWeb.java
@@ -1,201 +0,0 @@
-package io.gmss.fiscad.paylaods.request.crudweb;
-
-import com.fasterxml.jackson.annotation.JsonFormat;
-import io.gmss.fiscad.enums.NatureImpot;
-import jakarta.persistence.EnumType;
-import jakarta.persistence.Enumerated;
-import lombok.Data;
-import lombok.NoArgsConstructor;
-
-import java.time.LocalDate;
-import com.fasterxml.jackson.annotation.JsonFormat;
-import java.time.LocalDate;
-@NoArgsConstructor
-@Data
-public class DonneesImpositionPaylaodWeb {
-        private Long id;
-        private Long annee;
-        private String codeDepartement;
-        private String nomDepartement;
-        private String codeCommune;
-        private String nomCommune;
-        private String codeArrondissement;
-        private String nomArrondissement;
-        private String codeQuartierVillage;
-        private String nomQuartierVillage;
-        private String q;
-        private String ilot;
-        private String parcelle;
-        private String nup;
-        private String titreFoncier;
-        private String numBatiment;
-        private String numUniteLogement;
-        private String ifu;
-        private String npi;
-        private String telProp;
-        private String emailProp;
-        private String nomProp;
-        private String prenomProp;
-        private String raisonSociale;
-        private String adresseProp;
-        private String telRep;
-        private String emailRep;
-        private String nomRep;
-        private String prenomRep;
-        private String adresseRep;
-        private String longitude;
-        private String latitude;
-        private Integer superficieParc;
-        private Long superficieAuSolBat;
-        private Long superficieAuSolUlog;
-        private Boolean batie;
-        private Boolean exonere;
-        private Boolean batimentExonere;
-        private Boolean uniteLogementExonere;
-        private Long valeurLocativeAdm;
-        private Long valeurBatiment;
-        private Long valeurParcelle;
-        private Long montantLoyerAnnuel;
-        private Long tfuMetreCarre;
-        private Long tfuMinimum;
-        private String standingBat;
-        private String categorieBat;
-        private Long nombrePiscine;
-        private Long nombreUlog;
-        private Long nombreBat;
-        @JsonFormat(pattern = "yyyy-MM-dd")
-        private LocalDate dateEnquete;
-        private Long serviceId;
-        private String serviceCode;
-        private Long zoneRfuId;
-        private String zoneRfuNom;
-        private Float tauxTfu;
-        private Long valeurAdminParcelleNb;
-        @Enumerated(EnumType.STRING)
-        private NatureImpot natureImpot;
-        private Long valeurLocativeAdmMetreCarre;
-        private Long valeurAdminParcelleNbMetreCarre;
-        private Float montantTaxe;
-
-    public DonneesImpositionPaylaodWeb(Long id,
-                                       Long annee,
-                                       String codeDepartement,
-                                       String nomDepartement,
-                                       String codeCommune,
-                                       String nomCommune,
-                                       String codeArrondissement,
-                                       String nomArrondissement,
-                                       String codeQuartierVillage,
-                                       String nomQuartierVillage,
-                                       String q, String ilot,
-                                       String parcelle,
-                                       String nup,
-                                       String titreFoncier,
-                                       String numBatiment,
-                                       String numUniteLogement,
-                                       String ifu,
-                                       String npi,
-                                       String telProp,
-                                       String emailProp,
-                                       String nomProp,
-                                       String prenomProp,
-                                       String raisonSociale,
-                                       String adresseProp,
-                                       String telRep,
-                                       String emailRep,
-                                       String nomRep,
-                                       String prenomRep,
-                                       String adresseRep,
-                                       String longitude,
-                                       String latitude,
-                                       Integer superficieParc,
-                                       Long superficieAuSolBat,
-                                       Long superficieAuSolUlog,
-                                        Boolean batie,
-                                         Boolean exonere,
-                                         Boolean batimentExonere,
-                                         Boolean uniteLogementExonere,
-                                       Long valeurLocativeAdm,
-                                       Long montantLoyerAnnuel,
-                                       Long tfuMetreCarre,
-                                       Long tfuMinimum,
-                                       String standingBat,
-                                       String categorieBat,
-                                       Long nombrePiscine,
-                                       Long nombreUlog,
-                                       Long nombreBat,
-                                       LocalDate dateEnquete,
-                                       Long serviceId,
-                                       Long zoneRfuId,
-                                       Long valeurAdministrativeParcelleNonBati,
-                                       NatureImpot natureImpot,
-                                       String serviceCode,
-                                       String zoneRfuNom,
-                                        Long valeurBatiment,
-                                         Long valeurParcelle,
-                                        Long valeurLocativeAdmMetreCarre,
-                                        Long valeurAdministrativeParcelleNonBatiAuMetreCarre,
-                                        Float montantTaxe
-                                        ) {
-        this.id = id;
-        this.annee = annee;
-        this.codeDepartement = codeDepartement;
-        this.nomDepartement = nomDepartement;
-        this.codeCommune = codeCommune;
-        this.nomCommune = nomCommune;
-        this.codeArrondissement = codeArrondissement;
-        this.nomArrondissement = nomArrondissement;
-        this.codeQuartierVillage = codeQuartierVillage;
-        this.nomQuartierVillage = nomQuartierVillage;
-        this.q = q;
-        this.ilot = ilot;
-        this.parcelle = parcelle;
-        this.nup = nup;
-        this.titreFoncier = titreFoncier;
-        this.numBatiment = numBatiment;
-        this.numUniteLogement = numUniteLogement;
-        this.ifu = ifu;
-        this.npi = npi;
-        this.telProp = telProp;
-        this.emailProp = emailProp;
-        this.nomProp = nomProp;
-        this.prenomProp = prenomProp;
-        this.raisonSociale = raisonSociale;
-        this.adresseProp = adresseProp;
-        this.telRep = telRep;
-        this.emailRep = emailRep;
-        this.nomRep = nomRep;
-        this.prenomRep = prenomRep;
-        this.adresseRep = adresseRep;
-        this.longitude = longitude;
-        this.latitude = latitude;
-        this.superficieParc = superficieParc;
-        this.superficieAuSolBat = superficieAuSolBat;
-        this.superficieAuSolUlog = superficieAuSolUlog;
-        this.batie = batie;
-        this.exonere = exonere;
-        this.batimentExonere = batimentExonere;
-        this.uniteLogementExonere = uniteLogementExonere;
-        this.valeurLocativeAdm = valeurLocativeAdm;
-        this.montantLoyerAnnuel = montantLoyerAnnuel;
-        this.tfuMetreCarre = tfuMetreCarre;
-        this.tfuMinimum = tfuMinimum;
-        this.standingBat = standingBat;
-        this.categorieBat = categorieBat;
-        this.nombrePiscine = nombrePiscine;
-        this.nombreUlog = nombreUlog;
-        this.nombreBat = nombreBat;
-        this.dateEnquete = dateEnquete;
-        this.serviceId = serviceId;
-        this.zoneRfuId = zoneRfuId;
-        this.valeurAdminParcelleNb = valeurAdministrativeParcelleNonBati;
-        this.natureImpot = natureImpot;
-        this.serviceCode = serviceCode;
-        this.zoneRfuNom = zoneRfuNom;
-        this.valeurBatiment = valeurBatiment;
-        this.valeurParcelle = valeurParcelle;
-        this.valeurLocativeAdmMetreCarre = valeurLocativeAdmMetreCarre;
-        this.valeurAdminParcelleNbMetreCarre = valeurAdministrativeParcelleNonBatiAuMetreCarre;
-        this.montantTaxe = montantTaxe;
-    }
-}
--- a/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/ImpositionsTfuPaylaodWeb.java
+++ b/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/ImpositionsTfuPaylaodWeb.java
@@ -1,64 +0,0 @@
-package io.gmss.fiscad.paylaods.request.crudweb;
-
-import com.fasterxml.jackson.annotation.JsonFormat;
-import com.fasterxml.jackson.databind.annotation.JsonDeserialize;
-import io.gmss.fiscad.deserializer.LocalDateDeserializer;
-import io.gmss.fiscad.entities.decoupage.Commune;
-import io.gmss.fiscad.entities.infocad.parametre.Structure;
-import io.gmss.fiscad.entities.rfu.parametre.Exercice;
-import io.gmss.fiscad.enums.NatureImpot;
-import io.gmss.fiscad.enums.StatusAvis;
-import jakarta.persistence.*;
-import lombok.Data;
-import lombok.NoArgsConstructor;
-
-import java.time.LocalDate;
-
-@NoArgsConstructor
-@Data
-public class ImpositionsTfuPaylaodWeb {
-    private Long id;
-    private LocalDate dateGeneration;
-    private LocalDate dateCloture;
-    private String referencePieceAdmin;
-    private String datePieceAdmin;
-    @Enumerated(EnumType.STRING)
-    private StatusAvis statusAvis;
-    private Integer nombreAvis;
-    private Integer nombreAvisFnb;
-    private Integer nombreAvisBatiment;
-    private Integer nombreAvisUniteLog;
-    @Column(columnDefinition = "TEXT")
-    private String motif;
-    private Long exerciceId;
-    private Integer exerciceAnnee;
-    private Long communeId;
-    private String communeCode;
-    private String communeNom;
-    private Long structureId ;
-    private String structureNom ;
-    public ImpositionsTfuPaylaodWeb(Long id, LocalDate dateGeneration, LocalDate dateCloture, String referencePieceAdmin, String datePieceAdmin, StatusAvis statusAvis, Integer nombreAvis, String motif, Long exerciceId, Integer exerciceAnnee, Long communeId, String communeCode, String communeNom, Long structureId, String structureNom,
-                                    Integer nombreAvisFnb,
-                                    Integer nombreAvisBatiment,
-                                    Integer nombreAvisUniteLog
-                                    ) {
-        this.id = id;
-        this.dateGeneration = dateGeneration;
-        this.dateCloture = dateCloture;
-        this.referencePieceAdmin = referencePieceAdmin;
-        this.datePieceAdmin = datePieceAdmin;
-        this.statusAvis = statusAvis;
-        this.nombreAvis = nombreAvis;
-        this.motif = motif;
-        this.exerciceId = exerciceId;
-        this.exerciceAnnee = exerciceAnnee;
-        this.communeId = communeId;
-        this.communeCode = communeCode;
-        this.communeNom = communeNom;
-        this.structureId = structureId;
-        this.structureNom = structureNom;
-        this.nombreAvisFnb = nombreAvisFnb;
-        this.nombreAvisBatiment = nombreAvisBatiment;
-        this.nombreAvisUniteLog = nombreAvisUniteLog;
-    }
-}
--- a/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/ParcelleGeomPaylaodWeb.java
+++ b/src/main/java/io/gmss/fiscad/paylaods/request/crudweb/ParcelleGeomPaylaodWeb.java
@@ -90,7 +90,7 @@ public class ParcelleGeomPaylaodWeb {
    private String quartierCode ;
    private String quartierNom ;

-    private Integer  geomSrid;
+    private int  geomSrid;
    @JsonSerialize(using = GeometrySerializer.class)
    @JsonDeserialize(contentUsing = GeometryDeserializer.class)
    //@Column(name = "geometry",columnDefinition = "geometry(Polygon,32631)")
@@ -100,7 +100,7 @@ public class ParcelleGeomPaylaodWeb {

    private Long parcelleId;

-    public ParcelleGeomPaylaodWeb(Long id, String nup, String nupProvisoire, String longitude, String latitude, String numeroRue, String numeroEntreePorte, String codeInstad, String numeroEtatLieux, String numeroTitreFoncier, LocalDate dateTitreFoncier, Boolean batie, String npi, String ifu, String nom, String prenom, String raisonSociale, String nomEtPrenoms, String telephone, String adresse, String nomRepresentant, String prenomRepresentant, String raisonSocialeRepresentant, String nomEtPrenomsRepresentant, String telephoneRepresentant, String adresseRepresentant, String q, String zone, String ilot, String p, String qLotissement, String ilotLotissement, String pLotissement, String pointsPolygone, Integer superficie, String dateCollecte, SourceDonnee sourceDonnees, String observations, StatutParcelle statutParcelle, Long departementId, String departementCode, String departementNom, Long communeId, String communeCode, String communeNom, Long arrondissementId, String arrondissementCode, String arrondissementNom, Long quartierId, String quartierCode, String quartierNom, Integer geomSrid, Polygon geometry, String geometryString, Long parcelleId) {
+    public ParcelleGeomPaylaodWeb(Long id, String nup, String nupProvisoire, String longitude, String latitude, String numeroRue, String numeroEntreePorte, String codeInstad, String numeroEtatLieux, String numeroTitreFoncier, LocalDate dateTitreFoncier, Boolean batie, String npi, String ifu, String nom, String prenom, String raisonSociale, String nomEtPrenoms, String telephone, String adresse, String nomRepresentant, String prenomRepresentant, String raisonSocialeRepresentant, String nomEtPrenomsRepresentant, String telephoneRepresentant, String adresseRepresentant, String q, String zone, String ilot, String p, String qLotissement, String ilotLotissement, String pLotissement, String pointsPolygone, Integer superficie, String dateCollecte, SourceDonnee sourceDonnees, String observations, StatutParcelle statutParcelle, Long departementId, String departementCode, String departementNom, Long communeId, String communeCode, String communeNom, Long arrondissementId, String arrondissementCode, String arrondissementNom, Long quartierId, String quartierCode, String quartierNom, int geomSrid, Polygon geometry, String geometryString, Long parcelleId) {
        this.id = id;
        this.nup = nup;
        this.nupProvisoire = nupProvisoire;
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/decoupage/SecteurRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/decoupage/SecteurRepository.java
@@ -186,19 +186,5 @@ public interface SecteurRepository extends JpaRepository<Secteur, Long> {
    Optional<SecteurPaylaodWeb> findSecteurToDtoById(@Param("idSecteur") Long idSecteur);


-    @Query("""
-             SELECT new io.gmss.fiscad.entities.decoupage.Secteur(
-                  sec.id,
-                  sec.code,
-                  sec.nom,
-                  secti 
-            )
-            FROM Secteur sec
-            LEFT JOIN sec.section secti
-            LEFT JOIN secti.structure st
-            LEFT JOIN st.commune com
-            LEFT JOIN com.departement dep
-            WHERE dep.id = :idDepartement
-            """)
-     List<Secteur> findSectionsByDepartement(@Param("idDepartement") Long idDepartement);
+
 }
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/EnqueteRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/EnqueteRepository.java
@@ -13,7 +13,6 @@ import io.gmss.fiscad.paylaods.response.synchronisation.EnqueteNonSyncResponse;
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;

@@ -23,26 +22,6 @@ import java.util.Optional;
 public interface EnqueteRepository extends JpaRepository<Enquete, Long> {
     Optional<Enquete> findFirstByCodeParcelle(String codeParcelle);
    Optional<Enquete> findByMobileDataId(Long id);
-
-    @Modifying
-    @Query("""
-        UPDATE Enquete e
-        SET e.statutEnquete = 'CLOTURE'
-        WHERE EXISTS (
-            SELECT 1
-            FROM Parcelle p 
-            JOIN p.quartier q 
-            JOIN SecteurDecoupage cd on cd.quartier.id=q.id
-            JOIN cd.secteur s 
-            JOIN s.section sect 
-            JOIN sect.structure stru
-            WHERE e.parcelle.id=p.id
-            AND stru.id= :structureId
-        )
-        AND e.exercice.id = :exerciceId
-    """)
-    Integer clotureEnqueteParcelle(@Param("structureId") Long structureId,@Param("exerciceId") Long exerciceId);
-
    @Query(value = "select distinct " +
            " e.id," +
            " e.parcelle_id as parcelleId," +
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/ParcelleGeomRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/ParcelleGeomRepository.java
@@ -78,40 +78,6 @@ public interface ParcelleGeomRepository extends JpaRepository<ParcelleGeom, Long
            """,nativeQuery = true)
    void majCentroidParcelle();

-
-    @Modifying
-    @Transactional
-    @Query(value = """
-             update parcelle_geom pg
-              set parcelle_id = p.id,statut_parcelle='NON_AJOUR'
-              from parcelle p
-              where upper(p.q)=upper(pg.q)
-              and upper(p.i)=upper(pg.ilot)
-              and upper(p.p)=upper(pg.p)
-              and parcelle_is is null;
-            """,nativeQuery = true)
-    void majParcelleId();
-
-
-    @Modifying
-    @Transactional
-    @Query(value = """
-            UPDATE parcelle_geom p
-              SET batie = true
-              WHERE EXISTS (
-                      SELECT 1
-                      FROM Batiment b
-                      WHERE b.parcelle_id = p.parcelle_id
-              )
-              and p.parcelle_id is not null;
-            """,nativeQuery = true)
-    void majParcelleBatie();
-
-
-
-
-
-
    @Query("""
    SELECT new io.gmss.fiscad.paylaods.request.crudweb.ParcelleGeomPaylaodWeb(
        pg.id,
@@ -128,9 +94,9 @@ public interface ParcelleGeomRepository extends JpaRepository<ParcelleGeom, Long
        pg.batie,
        pg.npi,
        pg.ifu,
-        pers.nom,
-        pers.prenom,
-        pers.raisonSociale,
+        pg.nom,
+        pg.prenom,
+        pg.raisonSociale,
        pg.nomEtPrenoms,
        pg.telephone,
        pg.adresse,
@@ -168,18 +134,9 @@ public interface ParcelleGeomRepository extends JpaRepository<ParcelleGeom, Long
        pg.geomSrid,
        pg.geometry,
        pg.geometryString,
-        parc.id
+        pg.parcelle.id
    )
    FROM ParcelleGeom pg
-    LEFT JOIN pg.parcelle parc
-    LEFT JOIN Enquete e
-                ON e.parcelle = parc
-                AND e.dateEnquete = (
-                    SELECT MAX(e2.dateEnquete)
-                    FROM Enquete e2
-                    WHERE e2.parcelle = parc
-                )
-    LEFT JOIN e.personne pers
    LEFT JOIN pg.departement d
    LEFT JOIN pg.commune c
    LEFT JOIN pg.arrondissement a
@@ -205,9 +162,9 @@ public interface ParcelleGeomRepository extends JpaRepository<ParcelleGeom, Long
            pg.batie,
            pg.npi,
            pg.ifu,
-            pers.nom,
-            pers.prenom,
-            pers.raisonSociale,
+            pg.nom,
+            pg.prenom,
+            pg.raisonSociale,
            pg.nomEtPrenoms,
            pg.telephone,
            pg.adresse,
@@ -245,18 +202,9 @@ public interface ParcelleGeomRepository extends JpaRepository<ParcelleGeom, Long
            pg.geomSrid,
            pg.geometry,
            pg.geometryString,
-            parc.id
+            pg.parcelle.id
        )
        FROM ParcelleGeom pg
-        LEFT JOIN pg.parcelle parc
-        LEFT JOIN Enquete e
-                    ON e.parcelle = parc
-                    AND e.dateEnquete = (
-                        SELECT MAX(e2.dateEnquete)
-                        FROM Enquete e2
-                        WHERE e2.parcelle = parc
-                    )
-        LEFT JOIN e.personne pers
        LEFT JOIN pg.departement d
        LEFT JOIN pg.commune c
        LEFT JOIN pg.arrondissement a
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/ParcelleRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/metier/ParcelleRepository.java
@@ -11,7 +11,6 @@ import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
-import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;

@@ -21,32 +20,6 @@ import java.util.Optional;
 public interface ParcelleRepository extends JpaRepository<Parcelle, Long>, JpaSpecificationExecutor<Parcelle>, ParcelleRepositoryCustom {
    Optional<Parcelle> findFirstByExternalKeyAndTerminal_Id(Long externalKey, Long TerminalId);
    Optional<Parcelle> findByMobileDataId(Long id);
-
-
-    @Modifying
-    @Query("""
-        UPDATE Parcelle p
-        SET p.batie = TRUE
-        WHERE EXISTS (
-            SELECT 1
-            FROM Batiment b
-            WHERE b.parcelle.id = p.id
-        )
-    """)
-    Integer updateParcelleBatieTrue();
-
-    @Modifying
-    @Query("""
-        UPDATE Parcelle p
-        SET p.batie = FALSE
-        WHERE NOT EXISTS (
-            SELECT 1
-            FROM Batiment b
-            WHERE b.parcelle.id = p.id
-        )
-    """)
-    Integer updateParcelleBatieFalse();
-
    @Query(value = "Select  " +
            " p.id as idBackend, " +
            " p.external_key as externalKey, " +
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/parametre/StructureRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/infocad/parametre/StructureRepository.java
@@ -174,6 +174,4 @@ public interface StructureRepository extends JpaRepository<Structure, Long> {
            """)
    Page<StructurePaylaodWeb> findAllStructureByCommuneToDtoPageable(@Param("communeId") Long communeId, Pageable pageable);

-
-    List<Structure> findDistinctByCommune_Departement_Id(Long departementId);
 }
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/CaracteristiqueBatimentRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/CaracteristiqueBatimentRepository.java
@@ -60,9 +60,9 @@ public interface CaracteristiqueBatimentRepository extends JpaRepository<Caracte
                 ca.typeCaracteristique.libelle
            )
            FROM CaracteristiqueBatiment cb
-            LEFT JOIN cb.caracteristique ca
-            LEFT JOIN cb.enqueteBatiment eb
-            LEFT JOIN eb.exercice ex
+            JOIN cb.caracteristique ca
+            JOIN cb.enqueteBatiment eb
+            JOIN eb.exercice ex
            WHERE cb.id = :caracteristiqueBatimentId
            """)
    Optional<CaracteristiqueBatimentPayloadWeb> findCaracteristiqueBatimentToDto(@Param("caracteristiqueBatimentId") Long caracteristiqueBatimentId);
@@ -126,6 +126,7 @@ public interface CaracteristiqueBatimentRepository extends JpaRepository<Caracte
            JOIN cb.caracteristique ca
            JOIN cb.enqueteBatiment eb
            JOIN eb.exercice ex
+            WHERE eb.id = :enqueteBatimentId
            """,
            countQuery = """
             SELECT COUNT(distinct  cb)
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/DonneesImpositionTfuRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/DonneesImpositionTfuRepository.java
@@ -2,13 +2,9 @@ package io.gmss.fiscad.persistence.repositories.rfu.metier;

 import io.gmss.fiscad.entities.infocad.parametre.Personne;
 import io.gmss.fiscad.entities.rfu.metier.DonneesImpositionTfu;
-import io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb;
 import io.gmss.fiscad.paylaods.response.DonneesImpositionTfuResponse;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;

 import java.util.List;
 import java.util.Optional;
@@ -123,411 +119,9 @@ public interface DonneesImpositionTfuRepository extends JpaRepository<DonneesImp
        """, nativeQuery = true)
    List<DonneesImpositionTfuResponse> findAllDonneesImpositionTfu(Long communeId, int annee);

+    List<DonneesImpositionTfu> findAllByImpositionsTfu_Id(Long impositionId);
    List<DonneesImpositionTfu> findAllByImpositionsTfu_IdAndCodeArrondissement(Long impositionId,String arrondissementCode);


-    @Query("""
-SELECT new io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb(
-        d.id,
-        d.annee,
-        d.codeDepartement,
-        d.nomDepartement,
-        d.codeCommune,
-        d.nomCommune,
-        d.codeArrondissement,
-        d.nomArrondissement,
-        d.codeQuartierVillage,
-        d.nomQuartierVillage,
-        d.q,
-        d.ilot,
-        d.parcelle,
-        d.nup,
-        d.titreFoncier,
-        d.numBatiment,
-        d.numUniteLogement,
-        d.ifu,
-        d.npi,
-        d.telProp,
-        d.emailProp,
-        d.nomProp,
-        d.prenomProp,
-        d.raisonSociale,
-        d.adresseProp,
-        d.telSc,
-        d.emailSc,
-        d.nomSc,
-        d.prenomSc,
-        d.adresseSc,
-        d.longitude,
-        d.latitude,
-        d.superficieParc,
-        d.superficieAuSolBat,
-        d.superficieAuSolUlog,
-        d.batie,
-        d.exonere,
-        d.batimentExonere,
-        d.uniteLogementExonere,
-        d.valeurLocativeAdm,
-        d.montantLoyerAnnuel,
-        d.tfuMetreCarre,
-        d.tfuMinimum,
-        d.standingBat,
-        d.categorieBat,
-        d.nombrePiscine,
-        d.nombreUlog,
-        d.nombreBat,
-        d.dateEnquete,
-        s.id,
-        z.id,
-        d.valeurAdminParcelleNb,
-        d.natureImpot,
-        s.code,
-        z.nom,
-        d.valeurBatiment,
-        d.valeurParcelle,
-        d.valeurLocativeAdmMetreCarre,
-        d.valeurAdminParcelleNbMetreCarre,
-        d.montantTaxe
-        )
-        FROM DonneesImpositionTfu d
-        JOIN d.impositionsTfu itfu
-        LEFT join d.structure s 
-        LEFT join d.zoneRfu z
-        WHERE itfu.id = :impositionTfuId
-        order by d.nomProp,d.nomProp asc
-        """)
-    List<DonneesImpositionPaylaodWeb> findAllByImpositionTfuId(
-            Long impositionTfuId
-    );
-
-
-    @Query("""
-SELECT new io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb(
-        d.id,
-        d.annee,
-        d.codeDepartement,
-        d.nomDepartement,
-        d.codeCommune,
-        d.nomCommune,
-        d.codeArrondissement,
-        d.nomArrondissement,
-        d.codeQuartierVillage,
-        d.nomQuartierVillage,
-        d.q,
-        d.ilot,
-        d.parcelle,
-        d.nup,
-        d.titreFoncier,
-        d.numBatiment,
-        d.numUniteLogement,
-        d.ifu,
-        d.npi,
-        d.telProp,
-        d.emailProp,
-        d.nomProp,
-        d.prenomProp,
-        d.raisonSociale,
-        d.adresseProp,
-        d.telSc,
-        d.emailSc,
-        d.nomSc,
-        d.prenomSc,
-        d.adresseSc,
-        d.longitude,
-        d.latitude,
-        d.superficieParc,
-        d.superficieAuSolBat,
-        d.superficieAuSolUlog,
-        d.batie,
-        d.exonere,
-        d.batimentExonere,
-        d.uniteLogementExonere,
-        d.valeurLocativeAdm,
-        d.montantLoyerAnnuel,
-        d.tfuMetreCarre,
-        d.tfuMinimum,
-        d.standingBat,
-        d.categorieBat,
-        d.nombrePiscine,
-        d.nombreUlog,
-        d.nombreBat,
-        d.dateEnquete,
-        s.id,
-        z.id,
-        d.valeurAdminParcelleNb,
-        d.natureImpot,
-        s.code,
-        z.nom,
-        d.valeurBatiment,
-        d.valeurParcelle,
-        d.valeurLocativeAdmMetreCarre,
-        d.valeurAdminParcelleNbMetreCarre,
-        d.montantTaxe
-        )
-        FROM DonneesImpositionTfu d
-        JOIN d.impositionsTfu itfu
-        LEFT join d.structure s 
-        LEFT join d.zoneRfu z
-        WHERE itfu.id = :impositionTfuId
-        order by d.nomProp,d.nomProp asc
-        """)
-    Page<DonneesImpositionPaylaodWeb> findAllByImpositionTfuIdPageable(
-            Long impositionTfuId,
-            Pageable pageable
-    );
-
-
-    @Query("""
-SELECT new io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb(
-        d.id,
-        d.annee,
-        d.codeDepartement,
-        d.nomDepartement,
-        d.codeCommune,
-        d.nomCommune,
-        d.codeArrondissement,
-        d.nomArrondissement,
-        d.codeQuartierVillage,
-        d.nomQuartierVillage,
-        d.q,
-        d.ilot,
-        d.parcelle,
-        d.nup,
-        d.titreFoncier,
-        d.numBatiment,
-        d.numUniteLogement,
-        d.ifu,
-        d.npi,
-        d.telProp,
-        d.emailProp,
-        d.nomProp,
-        d.prenomProp,
-        d.raisonSociale,
-        d.adresseProp,
-        d.telSc,
-        d.emailSc,
-        d.nomSc,
-        d.prenomSc,
-        d.adresseSc,
-        d.longitude,
-        d.latitude,
-        d.superficieParc,
-        d.superficieAuSolBat,
-        d.superficieAuSolUlog,
-        d.batie,
-        d.exonere,
-        d.batimentExonere,
-        d.uniteLogementExonere,
-        d.valeurLocativeAdm,
-        d.montantLoyerAnnuel,
-        d.tfuMetreCarre,
-        d.tfuMinimum,
-        d.standingBat,
-        d.categorieBat,
-        d.nombrePiscine,
-        d.nombreUlog,
-        d.nombreBat,
-        d.dateEnquete,
-        s.id,
-        z.id,
-        d.valeurAdminParcelleNb,
-        d.natureImpot,
-        s.code,
-        z.nom,
-        d.valeurBatiment,
-        d.valeurParcelle,
-        d.valeurLocativeAdmMetreCarre,
-        d.valeurAdminParcelleNbMetreCarre,
-        d.montantTaxe
-        )
-        FROM DonneesImpositionTfu d
-        JOIN d.impositionsTfu itfu
-        LEFT join d.structure s 
-        LEFT join d.zoneRfu z
-        WHERE itfu.id = :impositionTfuId
-        and d.batie is true
-        and d.numUniteLogement is null
-        order by d.nomProp,d.nomProp asc
-        """)
-    Page<DonneesImpositionPaylaodWeb> findAllByImpositionTfuIdBatieBatimentPageable(
-            Long impositionTfuId,
-            Pageable pageable
-    );
-
-    @Query("""
-SELECT new io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb(
-        d.id,
-        d.annee,
-        d.codeDepartement,
-        d.nomDepartement,
-        d.codeCommune,
-        d.nomCommune,
-        d.codeArrondissement,
-        d.nomArrondissement,
-        d.codeQuartierVillage,
-        d.nomQuartierVillage,
-        d.q,
-        d.ilot,
-        d.parcelle,
-        d.nup,
-        d.titreFoncier,
-        d.numBatiment,
-        d.numUniteLogement,
-        d.ifu,
-        d.npi,
-        d.telProp,
-        d.emailProp,
-        d.nomProp,
-        d.prenomProp,
-        d.raisonSociale,
-        d.adresseProp,
-        d.telSc,
-        d.emailSc,
-        d.nomSc,
-        d.prenomSc,
-        d.adresseSc,
-        d.longitude,
-        d.latitude,
-        d.superficieParc,
-        d.superficieAuSolBat,
-        d.superficieAuSolUlog,
-        d.batie,
-        d.exonere,
-        d.batimentExonere,
-        d.uniteLogementExonere,
-        d.valeurLocativeAdm,
-        d.montantLoyerAnnuel,
-        d.tfuMetreCarre,
-        d.tfuMinimum,
-        d.standingBat,
-        d.categorieBat,
-        d.nombrePiscine,
-        d.nombreUlog,
-        d.nombreBat,
-        d.dateEnquete,
-        s.id,
-        z.id,
-        d.valeurAdminParcelleNb,
-        d.natureImpot,
-        s.code,
-        z.nom,
-        d.valeurBatiment,
-        d.valeurParcelle,
-        d.valeurLocativeAdmMetreCarre,
-        d.valeurAdminParcelleNbMetreCarre,
-        d.montantTaxe
-        )
-        FROM DonneesImpositionTfu d
-        JOIN d.impositionsTfu itfu
-        LEFT join d.structure s 
-        LEFT join d.zoneRfu z
-        WHERE itfu.id = :impositionTfuId
-        and d.batie is true
-        and d.numUniteLogement is not null
-        order by d.nomProp,d.nomProp asc
-        """)
-    Page<DonneesImpositionPaylaodWeb> findAllByImpositionTfuIdBatieUniteLogPageable(
-            Long impositionTfuId,
-            Pageable pageable
-    );
-
-
-    @Query("""
-SELECT new io.gmss.fiscad.paylaods.request.crudweb.DonneesImpositionPaylaodWeb(
-        d.id,
-        d.annee,
-        d.codeDepartement,
-        d.nomDepartement,
-        d.codeCommune,
-        d.nomCommune,
-        d.codeArrondissement,
-        d.nomArrondissement,
-        d.codeQuartierVillage,
-        d.nomQuartierVillage,
-        d.q,
-        d.ilot,
-        d.parcelle,
-        d.nup,
-        d.titreFoncier,
-        d.numBatiment,
-        d.numUniteLogement,
-        d.ifu,
-        d.npi,
-        d.telProp,
-        d.emailProp,
-        d.nomProp,
-        d.prenomProp,
-        d.raisonSociale,
-        d.adresseProp,
-        d.telSc,
-        d.emailSc,
-        d.nomSc,
-        d.prenomSc,
-        d.adresseSc,
-        d.longitude,
-        d.latitude,
-        d.superficieParc,
-        d.superficieAuSolBat,
-        d.superficieAuSolUlog,
-        d.batie,
-        d.exonere,
-        d.batimentExonere,
-        d.uniteLogementExonere,
-        d.valeurLocativeAdm,
-        d.montantLoyerAnnuel,
-        d.tfuMetreCarre,
-        d.tfuMinimum,
-        d.standingBat,
-        d.categorieBat,
-        d.nombrePiscine,
-        d.nombreUlog,
-        d.nombreBat,
-        d.dateEnquete,
-        s.id,
-        z.id,
-        d.valeurAdminParcelleNb,
-        d.natureImpot,
-        s.code,
-        z.nom,
-        d.valeurBatiment,
-        d.valeurParcelle,
-        d.valeurLocativeAdmMetreCarre,
-        d.valeurAdminParcelleNbMetreCarre,
-        d.montantTaxe
-        )
-        FROM DonneesImpositionTfu d
-        JOIN d.impositionsTfu itfu
-        LEFT join d.structure s 
-        LEFT join d.zoneRfu z
-        WHERE itfu.id = :impositionTfuId
-        and d.batie is false
-        order by d.nomProp,d.nomProp asc
-        """)
-    Page<DonneesImpositionPaylaodWeb> findAllByImpositionTfuIdNonBatiePageable(
-            Long impositionTfuId,
-            Pageable pageable
-    );
-
-    @Query(value = "SELECT generer_donnees_imposition_tfu_batie(:structureId, :impositionId)", nativeQuery = true)
-    Integer genererDonneesTfuBatie(
-            @Param("structureId") Long structureId,
-            @Param("impositionId") Long impositionId
-    );
-
-
-    @Query(value = "SELECT generer_donnees_imposition_tfu_batie_unite_logement(:structureId, :impositionId)", nativeQuery = true)
-    Integer genererDonneesTfuBatieUniteLogement(
-            @Param("structureId") Long structureId,
-            @Param("impositionId") Long impositionId
-    );
-
-
-    @Query(value = "SELECT generer_donnees_imposition_tfu_non_batie(:structureId, :impositionId)", nativeQuery = true)
-    Integer genererDonneesTfuNonBatie(
-            @Param("structureId") Long structureId,
-            @Param("impositionId") Long impositionId
-    );
-
-

 }
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/EnqueteBatimentRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/EnqueteBatimentRepository.java
@@ -6,7 +6,6 @@ import io.gmss.fiscad.paylaods.response.restoration.EnqueteBatimentPayLoadRestor
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;

@@ -20,26 +19,6 @@ public interface EnqueteBatimentRepository extends JpaRepository<EnqueteBatiment

    //List<EnqueteBatiment> findAllByEnquete_Id(Long enqueteId);

-    @Modifying
-    @Query("""
-        UPDATE EnqueteBatiment eb
-        SET eb.statutEnquete = 'CLOTURE'
-        WHERE EXISTS (
-            SELECT 1
-            FROM Parcelle p 
-            JOIN p.quartier q 
-            JOIN SecteurDecoupage cd on cd.quartier.id=q.id
-            JOIN cd.secteur s 
-            JOIN s.section sect 
-            JOIN sect.structure stru
-            WHERE eb.batiment.parcelle.id=p.id
-            AND stru.id= :structureId
-        )
-        AND eb.exercice.id = :exerciceId
-    """)
-    Integer clotureEnqueteBatiment(@Param("structureId") Long structureId,@Param("exerciceId") Long exerciceId);
-
-
    @Query(
            nativeQuery = true,
            value = "select eb.id as idBackend, " +
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/EnqueteUniteLogementRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/EnqueteUniteLogementRepository.java
@@ -6,7 +6,6 @@ import io.gmss.fiscad.paylaods.response.restoration.EnqueteUniteLogementPayLoadR
 import org.springframework.data.domain.Page;
 import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;

@@ -19,24 +18,7 @@ public interface EnqueteUniteLogementRepository extends JpaRepository<EnqueteUni
    Optional<EnqueteUniteLogement> findByMobileDataId(Long id);

    //List<EnqueteUniteLogement> findAllByEnquete_Id(Long id);
-    @Modifying
-    @Query("""
-        UPDATE EnqueteUniteLogement eul
-        SET eul.statutEnquete = 'CLOTURE'
-        WHERE EXISTS (
-            SELECT 1
-            FROM Parcelle p 
-            JOIN p.quartier q 
-            JOIN SecteurDecoupage cd on cd.quartier.id=q.id
-            JOIN cd.secteur s 
-            JOIN s.section sect 
-            JOIN sect.structure stru
-            WHERE eul.uniteLogement.batiment.parcelle.id=p.id
-            AND stru.id= :structureId
-        )
-        AND eul.exercice.id = :exerciceId
-    """)
-    Integer clotureEnqueteUniteLogement(@Param("structureId") Long structureId,@Param("exerciceId") Long exerciceId);
+
    @Query(nativeQuery = true,
            value = "select eul.id as idBackend, " +
                    "eul.terminal_id as terminalId, " +
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/ImpositionsTfuRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/metier/ImpositionsTfuRepository.java
@@ -1,13 +1,8 @@
 package io.gmss.fiscad.persistence.repositories.rfu.metier;

 import io.gmss.fiscad.entities.rfu.metier.ImpositionsTfu;
-import io.gmss.fiscad.enums.StatusAvis;
-import io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;

 import java.util.List;
 import java.util.Optional;
@@ -16,9 +11,6 @@ import java.util.Optional;
 public interface ImpositionsTfuRepository extends JpaRepository<ImpositionsTfu, Long> {

    Optional<ImpositionsTfu> findAllByCommune_IdAndExercice_Id(Long communeId,Long ExerciceId);
-
-    Optional<ImpositionsTfu> findDistinctByStructure_IdAndExercice_IdAndStatusAvisIn(Long structureId, Long exerciceId, List<StatusAvis> statusAvis);
-
    @Query(value = "select i.* " +
            " from impositions_tfu i " +
            " inner join commune c on c.id=i.commune_id" +
@@ -27,171 +19,4 @@ public interface ImpositionsTfuRepository extends JpaRepository<ImpositionsTfu,
            " and c.code= ?1 and e.annee = ?2 " +
            " and i.deleted is false ", nativeQuery = true)
    List<ImpositionsTfu> getImpositionsTfuByCommuneAndExercice(String codeCommnune,int annee);
-
-    @Query(value = "select i.* " +
-            " from impositions_tfu i " +
-            " inner join commune c on c.id=i.commune_id" +
-            " inner join exercice e on e.id=i.exercice_id" +
-            " inner join structure s on s.id=i.structure_id" +
-            " where status_avis in ('VALIDE','CREE','GENERE') " +
-            " and s.id= ?1 and e.id = ?2 " +
-            " and i.deleted is false ", nativeQuery = true)
-    List<ImpositionsTfu> getImpositionsTfuByStructureAndExercice(Long structureId,Long exerciceId);
-
-
-    @Query("""
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb(
-                i.id,
-                i.dateGeneration,
-                i.dateCloture,
-                i.referencePieceAdmin,
-                i.datePieceAdmin,
-                i.statusAvis,
-                i.nombreAvis,
-                i.motif,
-                e.id,
-                e.annee,
-                c.id,
-                c.code,
-                c.nom,
-                s.id,
-                s.nom,
-                i.nombreAvisFnb,
-                i.nombreAvisBatiment,
-                i.nombreAvisUniteLog
-            )
-            FROM ImpositionsTfu i
-            LEFT JOIN i.exercice e
-            LEFT JOIN i.commune c
-            LEFT JOIN i.structure s
-            WHERE i.id= :impositionId
-            """)
-    Optional<ImpositionsTfuPaylaodWeb> findByIdToDto(@Param("impositionId") Long impositionId);
-    @Query("""
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb(
-                i.id,
-                i.dateGeneration,
-                i.dateCloture,
-                i.referencePieceAdmin,
-                i.datePieceAdmin,
-                i.statusAvis,
-                i.nombreAvis,
-                i.motif,
-                e.id,
-                e.annee,
-                c.id,
-                c.code,
-                c.nom,
-                s.id,
-                s.nom,
-                i.nombreAvisFnb,
-                i.nombreAvisBatiment,
-                i.nombreAvisUniteLog
-            )
-            FROM ImpositionsTfu i
-            LEFT JOIN i.exercice e
-            LEFT JOIN i.commune c
-            LEFT JOIN i.structure s
-            """)
-    List<ImpositionsTfuPaylaodWeb> findAllPayloadToDto();
-
-
-    @Query(
-            value = """
-                SELECT new io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb(
-                    i.id,
-                    i.dateGeneration,
-                    i.dateCloture,
-                    i.referencePieceAdmin,
-                    i.datePieceAdmin,
-                    i.statusAvis,
-                    i.nombreAvis,
-                    i.motif,
-                    e.id,
-                    e.annee,
-                    c.id,
-                    c.code,
-                    c.nom,
-                    s.id,
-                    s.nom,
-                i.nombreAvisFnb,
-                i.nombreAvisBatiment,
-                i.nombreAvisUniteLog
-                )
-                FROM ImpositionsTfu i
-                LEFT JOIN i.exercice e
-                LEFT JOIN i.commune c
-                LEFT JOIN i.structure s
-                """,
-                            countQuery = """
-                SELECT COUNT(i)
-                FROM ImpositionsTfu i
-                LEFT JOIN i.exercice e
-                LEFT JOIN i.commune c
-                LEFT JOIN i.structure s
-                """
-                    )
-    Page<ImpositionsTfuPaylaodWeb> findAllPayloadToDto(Pageable pageable);
-
-
-    @Query("""
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb(
-                i.id,
-                i.dateGeneration,
-                i.dateCloture,
-                i.referencePieceAdmin,
-                i.datePieceAdmin,
-                i.statusAvis,
-                i.nombreAvis,
-                i.motif,
-                e.id,
-                e.annee,
-                c.id,
-                c.code,
-                c.nom,
-                s.id,
-                s.nom,
-                i.nombreAvisFnb,
-                i.nombreAvisBatiment,
-                i.nombreAvisUniteLog
-            )
-            FROM ImpositionsTfu i
-            LEFT JOIN i.exercice e
-            LEFT JOIN i.commune c
-            LEFT JOIN i.structure s
-            WHERE s.id in (:structureIds)
-            """)
-    List<ImpositionsTfuPaylaodWeb> findByStructureIdsToDto(@Param("structureIds") List<Long> structureIds);
-
-
-
-    @Query("""
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.ImpositionsTfuPaylaodWeb(
-                i.id,
-                i.dateGeneration,
-                i.dateCloture,
-                i.referencePieceAdmin,
-                i.datePieceAdmin,
-                i.statusAvis,
-                i.nombreAvis,
-                i.motif,
-                e.id,
-                e.annee,
-                c.id,
-                c.code,
-                c.nom,
-                s.id,
-                s.nom,
-                i.nombreAvisFnb,
-                i.nombreAvisBatiment,
-                i.nombreAvisUniteLog
-            )
-            FROM ImpositionsTfu i
-            LEFT JOIN i.exercice e
-            LEFT JOIN i.commune c
-            LEFT JOIN i.structure s
-            LEFT JOIN c.departement d
-            WHERE d.id= :departementId
-            """)
-    List<ImpositionsTfuPaylaodWeb> findByDepartementIdToDto(@Param("departementId") Long departementId);
 }
--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/parametre/BaremRfuNonBatiRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/parametre/BaremRfuNonBatiRepository.java
@@ -2,146 +2,11 @@ package io.gmss.fiscad.persistence.repositories.rfu.parametre;

 import io.gmss.fiscad.entities.rfu.parametre.BaremRfuNonBati;
 import io.gmss.fiscad.entities.rfu.parametre.ZoneRfu;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;

-import java.util.List;
 import java.util.Optional;

 public interface BaremRfuNonBatiRepository extends JpaRepository<BaremRfuNonBati, Long> {
 Optional<BaremRfuNonBati> findAllByCommune_IdAndZoneRfu_Id(Long communeId,Long zoneRfuId);
-
-    @Query(
-            value = """
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb(
-                b.id,
-                b.valeurAdministrative,
-                b.taux,
-                c.id,
-                c.code,
-                c.nom,
-                z.id,
-                z.code,
-                z.nom,
-                b.valeurAdministrativeMetreCarre,
-                b.auMetreCarre
-            )
-            FROM BaremRfuNonBati b
-            LEFT JOIN b.commune c
-            LEFT JOIN b.zoneRfu z
-            """,
-                        countQuery = """
-            SELECT COUNT(b)
-            FROM BaremRfuNonBati b
-            """
-                )
-    Page<BaremRfuNonBatiPayloadWeb> findAllPayloadToDtoPaged(Pageable pageable);
-
-    @Query(
-            """
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb(
-                b.id,
-                b.valeurAdministrative,
-                b.taux,
-                c.id,
-                c.code,
-                c.nom,
-                z.id,
-                z.code,
-                z.nom,
-                b.valeurAdministrativeMetreCarre,
-                b.auMetreCarre
-            )
-            FROM BaremRfuNonBati b
-            LEFT JOIN b.commune c
-            LEFT JOIN b.zoneRfu z
-            """
-    )
-    List<BaremRfuNonBatiPayloadWeb> findAllPayloadToDto();
-
-
-    @Query(
-                    """
-                    SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb(
-                        b.id,
-                        b.valeurAdministrative,
-                        b.taux,
-                        c.id,
-                        c.code,
-                        c.nom,
-                        z.id,
-                        z.code,
-                        z.nom,
-                b.valeurAdministrativeMetreCarre,
-                b.auMetreCarre
-                    )
-                    FROM BaremRfuNonBati b
-                    LEFT JOIN b.commune c
-                    LEFT JOIN b.zoneRfu z
-                    WHERE c.id = :communeId
-                    """
-                )
-    List<BaremRfuNonBatiPayloadWeb> findByCommuneToDto(
-            @Param("communeId") Long communeId
-    );
-
-
-    @Query(
-            """
-            SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb(
-                b.id,
-                b.valeurAdministrative,
-                b.taux,
-                c.id,
-                c.code,
-                c.nom,
-                z.id,
-                z.code,
-                z.nom,
-                b.valeurAdministrativeMetreCarre,
-                b.auMetreCarre
-            )
-            FROM BaremRfuNonBati b
-            LEFT JOIN b.commune c
-            LEFT JOIN b.zoneRfu z
-            WHERE b.id = :BaremNonBatiId
-            """
-    )
-    Optional<BaremRfuNonBatiPayloadWeb> findByIdToDto(
-            @Param("BaremNonBatiId") Long BaremNonBatiId
-    );
-
-
-
-    @Query(
-            value = """
-                SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuNonBatiPayloadWeb(
-                    b.id,
-                    b.valeurAdministrative,
-                    b.taux,
-                    c.id,
-                    c.code,
-                    c.nom,
-                    z.id,
-                    z.code,
-                    z.nom,
-                b.valeurAdministrativeMetreCarre,
-                b.auMetreCarre
-                )
-                FROM BaremRfuNonBati b
-                LEFT JOIN b.commune c
-                LEFT JOIN b.zoneRfu z
-                WHERE (:communeId IS NULL OR c.id = :communeId)
-                AND (:zoneId IS NULL OR z.id = :zoneId)
-                """
-                    )
-    Optional<BaremRfuNonBatiPayloadWeb> findByCommuneAndZoneToDto(
-            @Param("communeId") Long communeId,
-            @Param("zoneId") Long zoneId
-    );
 }

--- a/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/parametre/BaremRfuRepository.java
+++ b/src/main/java/io/gmss/fiscad/persistence/repositories/rfu/parametre/BaremRfuRepository.java
@@ -1,256 +1,11 @@
 package io.gmss.fiscad.persistence.repositories.rfu.parametre;

 import io.gmss.fiscad.entities.rfu.parametre.BaremRfuBati;
-import io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb;
-import org.springframework.data.domain.Page;
-import org.springframework.data.domain.Pageable;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;

 import java.util.List;
-import java.util.Optional;

 public interface BaremRfuRepository extends JpaRepository<BaremRfuBati, Long> {
-   /// List<BaremRfuBati> findAllByCategorieBatiment_Id(Long idCategorieBat);
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-    """)
-    Page<BaremRfuBatiPayloadWeb> findAllPayloadPaged(Pageable pageable);
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-    """)
-    List<BaremRfuBatiPayloadWeb> findAllPayload();
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE a.id = :arrondissementId
-    """)
-    List<BaremRfuBatiPayloadWeb> findByArrondissementId(
-            @Param("arrondissementId") Long arrondissementId
-    );
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE b.id = :baremRfuBatiId
-    """)
-    Optional<BaremRfuBatiPayloadWeb> findByBaremRfuBatieId(
-            @Param("baremRfuBatiId") Long id
-    );
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE a.id = :arrondissementId
-    """)
-    Page<BaremRfuBatiPayloadWeb> findByArrondissementIdPaged(
-            @Param("arrondissementId") Long arrondissementId,
-            Pageable pageable
-    );
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE a.id = :arrondissementId
-        and cb.id = :categorieBatimentId
-    """)
-    List<BaremRfuBatiPayloadWeb> findByArrondissementAndCategorieBatiment(
-            @Param("arrondissementId") Long arrondissementId,
-            @Param("categorieBatimentId") Long categorieBatimentId
-    );
-
-    @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE cb.id = :categorieBatimentId
-    """)
-    List<BaremRfuBatiPayloadWeb> findByCategorieBatiment(
-            @Param("categorieBatimentId") Long categorieBatimentId
-    );
-
-
- @Query("""
-        SELECT new io.gmss.fiscad.paylaods.request.crudweb.BaremRfuBatiPayloadWeb(
-            b.id,
-            b.valeurLocative,
-            b.tfuMetreCarre,
-            b.tfuMinimum,
-            cb.id,
-            cb.nom,
-            cb.standing,
-            a.id,
-            a.code,
-            a.nom,
-            q.id,
-            q.code,
-            q.nom,
-            c.id,
-            c.code,
-            c.nom
-        )
-        FROM BaremRfuBati b
-        LEFT JOIN b.categorieBatiment cb
-        LEFT JOIN b.arrondissement a
-        LEFT JOIN b.quartier q
-        LEFT JOIN a.commune c
-        WHERE cb.id = :categorieBatimentId
-        and q.id = :quartierId
-    """)
- List<BaremRfuBatiPayloadWeb> findByQuartierAndCategorieBatiment(
-         @Param("quartierId") Long quartierId,
-         @Param("categorieBatimentId") Long categorieBatimentId
- );
+    List<BaremRfuBati> findAllByCategorieBatiment_Id(Long idCategorieBat);
 }

--- a/src/main/java/io/gmss/fiscad/service/EntityFromPayLoadService.java
+++ b/src/main/java/io/gmss/fiscad/service/EntityFromPayLoadService.java
@@ -1,6 +1,5 @@
 package io.gmss.fiscad.service;

-import io.gmss.fiscad.controllers.rfu.metier.ImpositionsTfuController;
 import io.gmss.fiscad.entities.decoupage.*;
 import io.gmss.fiscad.entities.infocad.metier.Enquete;
 import io.gmss.fiscad.entities.infocad.metier.Parcelle;
@@ -24,8 +23,6 @@ import io.gmss.fiscad.persistence.repositories.infocad.metier.PieceRepository;
 import io.gmss.fiscad.persistence.repositories.infocad.metier.UploadRepository;
 import io.gmss.fiscad.persistence.repositories.infocad.parametre.*;
 import io.gmss.fiscad.persistence.repositories.rfu.metier.*;
-import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuNonBatiRepository;
-import io.gmss.fiscad.persistence.repositories.rfu.parametre.BaremRfuRepository;
 import io.gmss.fiscad.persistence.repositories.rfu.parametre.CaracteristiqueRepository;
 import io.gmss.fiscad.persistence.repositories.rfu.parametre.ExerciceRepository;
 import io.gmss.fiscad.persistence.repositories.user.AvoirFonctionRepository;
@@ -74,9 +71,6 @@ public class EntityFromPayLoadService {
    private final AvoirFonctionRepository avoirFonctionRepository;
    private final EnqueteActiviteRepository enqueteActiviteRepository;
    private final ExerciceRepository exerciceRepository ;
-    private final BaremRfuRepository baremRfuRepository ;
-    private final BaremRfuNonBatiRepository baremRfuNonBatiRepository ;
-    private final ImpositionsTfuRepository impositionsTfuRepository ;


    public CaracteristiqueParcelle getCaracteristiqueParcelleFromPayLoadWeb(CaracteristiqueParcellePayloadWeb caracteristiqueParcellePayloadWeb){
@@ -668,11 +662,11 @@ public class EntityFromPayLoadService {
        eul.setRepresentantNpi(enqueteUniteLogementPayloadWeb.getRepresentantNpi());
        eul.setNombrePiscine(enqueteUniteLogementPayloadWeb.getNombrePiscine());
       // eul.setStatutEnquete(StatutEnquete.EN_COURS);
-        //if(!enqueteUniteLogementPayloadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
+        if(!enqueteUniteLogementPayloadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
            eul.setStatutEnquete(StatutEnquete.EN_COURS);
-//        }else{
-//            eul.setStatutEnquete(enqueteUniteLogementPayloadWeb.getStatutEnquete());
-//        }
+        }else{
+            eul.setStatutEnquete(enqueteUniteLogementPayloadWeb.getStatutEnquete());
+        }

        return eul;
    }
@@ -762,11 +756,11 @@ public class EntityFromPayLoadService {
        enqueteBatiment.setRepresentantNpi(enqueteBatimentPayloadWeb.getRepresentantNpi());
        enqueteBatiment.setNombrePiscine(enqueteBatimentPayloadWeb.getNombrePiscine());
        //enqueteBatiment.setStatutEnquete(StatutEnquete.EN_COURS);
-        //if(!enqueteBatimentPayloadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
+        if(!enqueteBatimentPayloadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
            enqueteBatiment.setStatutEnquete(StatutEnquete.EN_COURS);
-//        }else{
-//            enqueteBatiment.setStatutEnquete(enqueteBatimentPayloadWeb.getStatutEnquete());
-//        }
+        }else{
+            enqueteBatiment.setStatutEnquete(enqueteBatimentPayloadWeb.getStatutEnquete());
+        }
        return enqueteBatiment;
    }

@@ -825,11 +819,11 @@ public class EntityFromPayLoadService {
        enquete.setDateEnquete(LocalDate.now());
        enquete.setLitige(enquetePayLoadWeb.getLitige());

-       // if(!enquetePayLoadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
+        if(!enquetePayLoadWeb.getStatutEnquete().equals(StatutEnquete.DECLARATION)){
            enquete.setStatutEnquete(StatutEnquete.EN_COURS);
-//        }else{
-//            enquete.setStatutEnquete(enquetePayLoadWeb.getStatutEnquete());
-//        }
+        }else{
+            enquete.setStatutEnquete(enquetePayLoadWeb.getStatutEnquete());
+        }
        enquete.setObservationParticuliere(enquetePayLoadWeb.getObservation());
        enquete.setAutreAdresse(enquetePayLoadWeb.getAutreAdresse());
        enquete.setAutreNumeroTitreFoncier(enquetePayLoadWeb.getAutreNumeroTitreFoncier());
@@ -856,108 +850,4 @@ public class EntityFromPayLoadService {

        return enquete;
    }
-
-
-
-
-    public BaremRfuBati getBaremRfuBatiFromPayLoadWeb(BaremRfuBatiPayloadWeb baremRfuBatiPayloadWeb){
-        BaremRfuBati baremRfuBati = new BaremRfuBati();
-        if (baremRfuBatiPayloadWeb.getId()!=null)
-            baremRfuBati=baremRfuRepository.findById(baremRfuBatiPayloadWeb.getId()).orElse(new BaremRfuBati());
-
-        // ======================
-        // Relations (sans hit DB)
-        // ======================
-
-        if (baremRfuBatiPayloadWeb.getArrondissementId() != null) {
-            Arrondissement arrondissement = new Arrondissement();
-            arrondissement.setId(baremRfuBatiPayloadWeb.getArrondissementId());
-            baremRfuBati.setArrondissement(arrondissement);
-        }
-
-        if (baremRfuBatiPayloadWeb.getQuartierId() != null) {
-            Quartier quartier = new Quartier();
-            quartier.setId(baremRfuBatiPayloadWeb.getQuartierId());
-            baremRfuBati.setQuartier(quartier);
-        }
-
-        if (baremRfuBatiPayloadWeb.getCategorieBatimentId() != null) {
-            CategorieBatiment categorieBatiment = new CategorieBatiment();
-            categorieBatiment.setId(baremRfuBatiPayloadWeb.getCategorieBatimentId());
-            baremRfuBati.setCategorieBatiment(categorieBatiment);
-        }
-
-        baremRfuBati.setTfuMinimum(baremRfuBatiPayloadWeb.getTfuMinimum());
-        baremRfuBati.setValeurLocative(baremRfuBatiPayloadWeb.getValeurLocative());
-        baremRfuBati.setTfuMetreCarre(baremRfuBatiPayloadWeb.getTfuMetreCarre());
-
-
-
-        return baremRfuBati;
-    }
-
-
-    public ImpositionsTfu getImpositionsTfuFromPayLoadWeb(ImpositionsTfuPaylaodWeb impositionsTfuPaylaodWeb){
-        ImpositionsTfu impositionsTfu = new ImpositionsTfu();
-        if (impositionsTfuPaylaodWeb.getId()!=null)
-            impositionsTfu=impositionsTfuRepository.findById(impositionsTfuPaylaodWeb.getId()).orElse(new ImpositionsTfu());
-
-        // ======================
-        // Relations (sans hit DB)
-        // ======================
-
-        if (impositionsTfuPaylaodWeb.getExerciceId() != null) {
-            Exercice exercice = new Exercice();
-            exercice.setId(impositionsTfuPaylaodWeb.getExerciceId());
-            impositionsTfu.setExercice(exercice);
-        }
-
-        if (impositionsTfuPaylaodWeb.getCommuneId() != null) {
-            Commune commune = new Commune();
-            commune.setId(impositionsTfuPaylaodWeb.getCommuneId());
-            impositionsTfu.setCommune(commune);
-        }
-
-        if (impositionsTfuPaylaodWeb.getStructureId() != null) {
-            Structure structure = new Structure();
-            structure.setId(impositionsTfuPaylaodWeb.getStructureId());
-            impositionsTfu.setStructure(structure);
-        }
-        impositionsTfu.setMotif(impositionsTfuPaylaodWeb.getMotif());
-        impositionsTfu.setDatePieceAdmin(impositionsTfuPaylaodWeb.getDatePieceAdmin());
-        impositionsTfu.setReferencePieceAdmin(impositionsTfuPaylaodWeb.getReferencePieceAdmin());
-
-        return impositionsTfu;
-    }
-
-
-
-    public BaremRfuNonBati getBaremRfuNonBatiFromPayLoadWeb(BaremRfuNonBatiPayloadWeb baremRfuNonBatiPayloadWeb){
-        BaremRfuNonBati baremRfuNonBati = new BaremRfuNonBati();
-        if (baremRfuNonBatiPayloadWeb.getId()!=null)
-            baremRfuNonBati=baremRfuNonBatiRepository.findById(baremRfuNonBatiPayloadWeb.getId()).orElse(new BaremRfuNonBati());
-
-        // ======================
-        // Relations (sans hit DB)
-        // ======================
-
-        if (baremRfuNonBatiPayloadWeb.getZoneRfuId() != null) {
-            ZoneRfu zoneRfu = new ZoneRfu();
-            zoneRfu.setId(baremRfuNonBatiPayloadWeb.getZoneRfuId());
-            baremRfuNonBati.setZoneRfu(zoneRfu);
-        }
-
-        if (baremRfuNonBatiPayloadWeb.getCommuneId() != null) {
-            Commune commune = new Commune();
-            commune.setId(baremRfuNonBatiPayloadWeb.getCommuneId());
-            baremRfuNonBati.setCommune(commune);
-        }
-
-        baremRfuNonBati.setTaux(baremRfuNonBatiPayloadWeb.getTaux());
-        baremRfuNonBati.setAuMetreCarre(baremRfuNonBatiPayloadWeb.getAuMetreCarre());
-        baremRfuNonBati.setValeurAdministrative(baremRfuNonBatiPayloadWeb.getValeurAdministrative());
-        baremRfuNonBati.setValeurAdministrativeMetreCarre(baremRfuNonBatiPayloadWeb.getValeurAdministrativeMetreCarre());
-
-        return baremRfuNonBati;
-    }
 }
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -1,7 +1,6 @@
 spring.profiles.active=${SPRING_PROFILES_ACTIVE}
 #spring.profiles.active=abomey
 #spring.profiles.active=test
-#test
 spring.jpa.properties.hibernate.id.new_generator_mappings=false
 spring.jpa.properties.hibernate.enable_lazy_load_no_trans=true
 spring.jpa.open-in-view=false
Author	SHA1	Message	Date
AKAKPO Aurince	d46a14626e	Merge pull request 'Gestion parcelle geom et changement https://gitea.com/actions/checkout@v4 #actions/checkout@v4' (#136 ) from features/crud_entites into develop Reviewed-on: #136	2026-03-01 17:33:59 +00:00
AKAKPO Aurince	920c70c877	Merge pull request 'Gestion parcelle geom' (#135 ) from features/crud_entites into develop Reviewed-on: #135	2026-03-01 17:29:34 +00:00
AKAKPO Aurince	2ab5b9299c	Merge pull request 'Gestion parcelle geom' (#133 ) from features/crud_entites into develop Reviewed-on: #133	2026-03-01 01:40:41 +00:00
AKAKPO Aurince	bf19ab6e6a	Merge pull request 'features/crud_entites' (#131 ) from features/crud_entites into develop Reviewed-on: #131	2026-02-22 23:17:33 +00:00
AKAKPO Aurince	84451d5a15	Merge pull request 'features/crud_entites' (#129 ) from features/crud_entites into develop Reviewed-on: #129	2026-02-22 13:53:35 +00:00
AKAKPO Aurince	e687a9a904	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#127 ) from features/crud_entites into develop Reviewed-on: #127	2026-02-21 12:42:08 +00:00
AKAKPO Aurince	9685c73513	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#125 ) from features/crud_entites into develop Reviewed-on: #125	2026-02-20 19:33:57 +00:00
AKAKPO Aurince	650470efff	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#123 ) from features/crud_entites into develop Reviewed-on: #123	2026-02-20 18:54:07 +00:00
AKAKPO Aurince	9f5cc61726	Merge pull request 'features/crud_entites' (#121 ) from features/crud_entites into develop Reviewed-on: #121	2026-02-19 20:37:58 +00:00
AKAKPO Aurince	41175d93f0	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#119 ) from features/crud_entites into develop Reviewed-on: #119	2026-02-19 19:07:35 +00:00
AKAKPO Aurince	1ecaecdee3	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#117 ) from features/crud_entites into develop Reviewed-on: #117	2026-02-19 18:33:11 +00:00
AKAKPO Aurince	122dfcbead	Merge pull request 'features/crud_entites' (#115 ) from features/crud_entites into develop Reviewed-on: #115	2026-02-19 12:00:31 +00:00
AKAKPO Aurince	d168b68d4b	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#113 ) from features/crud_entites into develop Reviewed-on: #113	2026-02-18 23:05:41 +00:00
AKAKPO Aurince	2af14dd4cd	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#111 ) from features/crud_entites into develop Reviewed-on: #111	2026-02-18 20:42:05 +00:00
AKAKPO Aurince	76f0d34e79	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#109 ) from features/crud_entites into develop Reviewed-on: #109	2026-02-18 14:01:25 +00:00
AKAKPO Aurince	666779ecce	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#107 ) from features/crud_entites into develop Reviewed-on: #107	2026-02-16 22:04:26 +00:00
AKAKPO Aurince	7fcd676fc0	Merge pull request 'features/crud_entites' (#105 ) from features/crud_entites into develop Reviewed-on: #105	2026-02-16 20:55:25 +00:00
AKAKPO Aurince	fffdef7103	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#103 ) from features/crud_entites into develop Reviewed-on: #103	2026-02-16 00:15:01 +00:00
AKAKPO Aurince	95c0dacd1e	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#101 ) from features/crud_entites into develop Reviewed-on: #101	2026-02-14 14:08:19 +00:00
AKAKPO Aurince	7ac6b953d3	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#99 ) from features/crud_entites into develop Reviewed-on: #99	2026-02-13 17:54:51 +00:00
AKAKPO Aurince	e010100472	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#97 ) from features/crud_entites into develop Reviewed-on: #97	2026-02-12 21:31:24 +00:00
AKAKPO Aurince	177a9c7b56	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#95 ) from features/crud_entites into develop Reviewed-on: #95	2026-02-12 02:15:05 +00:00
AKAKPO Aurince	3054930a86	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#93 ) from features/crud_entites into develop Reviewed-on: #93	2026-02-11 21:14:57 +00:00
AKAKPO Aurince	4397abd041	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#91 ) from features/crud_entites into develop Reviewed-on: #91	2026-02-11 21:10:08 +00:00
AKAKPO Aurince	a4b403ca20	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#89 ) from features/crud_entites into develop Reviewed-on: #89	2026-02-10 00:10:39 +00:00
AKAKPO Aurince	ff7b88f9f8	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#87 ) from features/crud_entites into develop Reviewed-on: #87	2026-02-09 23:26:42 +00:00
AKAKPO Aurince	37fdba1d85	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#85 ) from features/crud_entites into develop Reviewed-on: #85	2026-02-08 22:23:08 +00:00
AKAKPO Aurince	f50ed9aa5f	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#83 ) from features/crud_entites into develop Reviewed-on: #83	2026-02-04 01:33:32 +00:00
AKAKPO Aurince	966fd2ca7a	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#81 ) from features/crud_entites into develop Reviewed-on: #81	2026-02-03 19:32:06 +00:00
AKAKPO Aurince	a10253b2e8	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#79 ) from features/crud_entites into develop Reviewed-on: #79	2026-02-03 15:08:48 +00:00
AKAKPO Aurince	08b68f9e08	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#77 ) from features/crud_entites into develop Reviewed-on: #77	2026-02-02 23:03:26 +00:00
AKAKPO Aurince	be487d6a03	Merge pull request 'gestion revu de code en utilisant uniquement les DTO' (#75 ) from features/crud_entites into develop Reviewed-on: #75	2026-02-01 22:49:00 +00:00
AKAKPO Aurince	3be64e7f44	Merge pull request 'gestion de profil, secteur, section et arbre decoupage' (#73 ) from features/crud_entites into develop Reviewed-on: #73	2026-01-27 08:58:32 +00:00
AKAKPO Aurince	03a661cdc0	Merge pull request 'gestion de profil, secteur, section et arbre decoupage' (#72 ) from features/crud_entites into develop Reviewed-on: #72	2026-01-27 08:37:52 +00:00
AKAKPO Aurince	a68ec444cc	Merge pull request 'features/crud_entites' (#70 ) from features/crud_entites into develop Reviewed-on: #70	2026-01-13 20:33:17 +00:00
AKAKPO Aurince	58f517bf31	Merge pull request 'correction creation user par defaut' (#68 ) from features/crud_entites into develop Reviewed-on: #68	2025-12-20 19:03:51 +00:00
AKAKPO Aurince	7f18f22efb	Merge pull request 'correction creation user par defaut' (#66 ) from features/crud_entites into develop Reviewed-on: #66	2025-12-20 18:55:42 +00:00
AKAKPO Aurince	af3218412f	Merge pull request 'correction creation user par defaut' (#64 ) from features/crud_entites into develop Reviewed-on: #64	2025-12-20 17:06:19 +00:00
AKAKPO Aurince	f35670c72e	Merge pull request 'correction creation user par defaut' (#62 ) from features/crud_entites into develop Reviewed-on: #62	2025-12-20 15:03:45 +00:00
AKAKPO Aurince	a77c0e854d	Merge pull request 'correction creation user par defaut' (#60 ) from features/crud_entites into develop Reviewed-on: #60	2025-12-20 14:48:47 +00:00
AKAKPO Aurince	e75eff4e20	Merge pull request 'correction lecture de secret chargement' (#58 ) from features/crud_entites into develop Reviewed-on: #58	2025-12-20 14:33:59 +00:00
AKAKPO Aurince	40d078c653	Merge pull request 'correction lecture de secret chargement' (#56 ) from features/crud_entites into develop Reviewed-on: #56	2025-12-20 14:14:02 +00:00
AKAKPO Aurince	31dd11d017	Merge pull request 'correction lecture de secret chargement' (#54 ) from features/crud_entites into develop Reviewed-on: #54	2025-12-20 13:10:40 +00:00
AKAKPO Aurince	6dfd12fae8	Merge pull request 'correction lecture de secret chargement' (#52 ) from features/crud_entites into develop Reviewed-on: #52	2025-12-20 12:57:46 +00:00
AKAKPO Aurince	a4ad0a4556	Merge pull request 'correction lecture de secret chargement' (#50 ) from features/crud_entites into develop Reviewed-on: #50	2025-12-20 12:41:09 +00:00
AKAKPO Aurince	411a6c0c2d	Merge pull request 'correction lecture de secret' (#48 ) from features/crud_entites into develop Reviewed-on: #48	2025-12-20 12:21:25 +00:00
AKAKPO Aurince	bed73b2b16	Merge pull request 'correction lecture de secret' (#46 ) from features/crud_entites into develop Reviewed-on: #46	2025-12-20 12:10:00 +00:00
AKAKPO Aurince	5a0814a0ba	Merge pull request 'correction lecture de secret' (#44 ) from features/crud_entites into develop Reviewed-on: #44	2025-12-20 12:00:12 +00:00
AKAKPO Aurince	126254ea94	Merge pull request 'correction lecture de secret' (#42 ) from features/crud_entites into develop Reviewed-on: #42	2025-12-20 11:43:55 +00:00
AKAKPO Aurince	f9e4681af4	Merge pull request 'correction lecture de secret' (#40 ) from features/crud_entites into develop Reviewed-on: #40	2025-12-20 11:39:40 +00:00
AKAKPO Aurince	84089d3639	Merge pull request 'correction profil actif' (#38 ) from features/crud_entites into develop Reviewed-on: #38	2025-12-20 10:48:01 +00:00
AKAKPO Aurince	02b0a937b4	Merge pull request 'correction profil actif' (#36 ) from features/crud_entites into develop Reviewed-on: #36	2025-12-20 10:02:19 +00:00
AKAKPO Aurince	c0096457fb	Merge pull request 'nouvelle verson ci-cd avec gitea runner natif intallé sur hote' (#34 ) from features/crud_entites into develop Reviewed-on: #34	2025-12-19 19:14:24 +00:00
AKAKPO Aurince	b6062ba4d1	Merge pull request 'nouvelle verson ci-cd avec gitea runner natif intallé sur hote' (#33 ) from features/crud_entites into develop Reviewed-on: #33	2025-12-19 10:50:02 +00:00
AKAKPO Aurince	8dc8c974d3	Merge pull request 'correction docker composer avec les secrets' (#32 ) from features/crud_entites into develop Reviewed-on: #32	2025-12-19 10:39:57 +00:00
AKAKPO Aurince	957416df9e	Merge pull request 'correction docker composer avec les secrets' (#30 ) from features/crud_entites into develop Reviewed-on: #30	2025-12-18 15:47:21 +00:00
AKAKPO Aurince	8d8af75108	Merge pull request 'correction docker composer avec les secrets' (#28 ) from features/crud_entites into develop Reviewed-on: #28	2025-12-18 15:46:02 +00:00
AKAKPO Aurince	555f13508e	Merge pull request 'correction docker composer avec les secrets' (#26 ) from features/crud_entites into develop Reviewed-on: #26	2025-12-18 10:36:10 +00:00
AKAKPO Aurince	d92a2b2503	Merge pull request 'correction docker composer avec les secrets' (#24 ) from features/crud_entites into develop Reviewed-on: #24	2025-12-17 17:13:46 +00:00
AKAKPO Aurince	5ccfdb6a3f	Merge pull request 'correction docker composer avec les secrets' (#22 ) from features/crud_entites into develop Reviewed-on: #22	2025-12-17 16:58:50 +00:00
AKAKPO Aurince	87b3bfbe83	Merge pull request 'correction docker composer avec les secrets' (#20 ) from features/crud_entites into develop Reviewed-on: #20	2025-12-17 16:49:15 +00:00
AKAKPO Aurince	62f25ea726	Merge pull request 'correction docker composer avec les secrets' (#18 ) from features/crud_entites into develop Reviewed-on: #18	2025-12-17 16:41:46 +00:00
AKAKPO Aurince	6125fcbd0b	Merge pull request 'correction docker composer' (#16 ) from features/crud_entites into develop Reviewed-on: #16	2025-12-17 16:26:17 +00:00
AKAKPO Aurince	211af6103a	Merge pull request 'features/crud_entites' (#14 ) from features/crud_entites into develop Reviewed-on: #14	2025-12-17 14:12:53 +00:00
AKAKPO Aurince	d27b622db8	Merge pull request 'Changement en DB du nom de la colonne personne_id en proprietaire_id dans la table enquete' (#12 ) from features/crud_entites into develop All checks were successful CD - Deploy on main / deploy (pull_request) Successful in 35s Details Reviewed-on: #12	2025-12-16 18:22:48 +00:00
AKAKPO Aurince	c80b40082c	Merge pull request 'Changement en DB du nom de la colonne personne_id en proprietaire_id dans la table enquete' (#10 ) from features/crud_entites into develop All checks were successful CD - Deploy on main / deploy (pull_request) Successful in 44s Details Reviewed-on: #10	2025-12-16 18:06:52 +00:00
AKAKPO Aurince	4a88af6487	Merge pull request 'Changement en DB du nom de la colonne personne_id en proprietaire_id dans la table enquete' (#8 ) from features/crud_entites into develop All checks were successful CD - Deploy on main / deploy (pull_request) Successful in 34s Details Reviewed-on: #8	2025-12-05 19:24:00 +00:00
AKAKPO Aurince	966b0af1c2	Merge pull request 'Changement en DB du nom de la colonne personne_id en proprietaire_id dans la table enquete' (#6 ) from features/crud_entites into develop All checks were successful CD - Deploy on main / deploy (pull_request) Successful in 36s Details Reviewed-on: #6	2025-12-05 19:20:57 +00:00
AKAKPO Aurince	58aa088ac3	Merge pull request 'ajout de ci-cd' (#4 ) from features/crud_entites into develop All checks were successful CD - Deploy on main / deploy (pull_request) Successful in 39s Details Reviewed-on: #4	2025-12-05 19:10:37 +00:00
AKAKPO Aurince	033b430051	Merge pull request 'ajout de ci-cd' (#2 ) from features/crud_entites into develop Some checks failed CD - Deploy on main / deploy (pull_request) Failing after 39s Details Reviewed-on: #2	2025-12-05 19:06:43 +00:00
AKAKPO Aurince	b8dbc7f625	Merge pull request 'ajout de ci-cd' (#1 ) from features/crud_entites into develop Reviewed-on: #1	2025-12-05 17:53:30 +00:00