CentralogFamilleRepository.php

          WITH FAMILLE_SAUVE AS(
        SELECT cdfam, MAX(cdmaj) AS cdmaj, MAX(dtsave)
            FROM ever_famille_sauve
            WHERE dtsave >= :dateDernierTraitement
            GROUP BY cdfam
        )
        SELECT efs.cdfam as code_famille,
               f.libfam as libelle_famille,
               m.id_centre_profit AS centre_profit,
               efs.cdmaj = 'S' AS a_supprimer
        FROM FAMILLE_SAUVE efs
         INNER JOIN famille f
                    ON f.cdfam = efs.cdfam
                        AND f.dtann IS NULL
                        AND f.cdfam IS NOT NULL
         INNER JOIN mapping_centre_profit_famille m
                    ON m.cdcategfam = f.cdcategfam
                    AND m.id_centre_profit IS NOT NULL;