import org.lilie.services.eliot.scolarite.Etablissement
import org.lilie.services.eliot.utils.ListeUtilsService
import org.lilie.services.eliot.constantes.ConstFonct
+import org.lilie.services.eliot.applications.notes.resultat.DirtyMoyenneService
/**
* Service pour marquer que les données source d'une moyenne ont changé.
List<Periode> periodes) {
if (!modaliteMatieres) {
- log.warn("marqueChangementsSousServices: ModaliteMatieres vide. Service: $service Periodes: $periodes")
+ log.warn("marqueChangementsSousServices: ModaliteMatieres vide. Service: ${service.id} Periodes: ${periodes*.id}")
return
}
}
else {
if (log.debugEnabled) {
- log.debug("SousService n'existe pas pour service: $service modaliteMatiere: $modaliteMatiere typePeriode: ${periode.typePeriode}")
+ log.debug("SousService n'existe pas pour serviceId: ${service.id} modaliteMatiere: ${modaliteMatiere.id} typePeriode: ${periode.typePeriodeId}")
}
}
}
),
dm_updated AS (
UPDATE entnotes.dirty_moyenne AS dm_to_update
- SET date_changement = now()
+ SET date_changement = clock_timestamp()
FROM dm
WHERE dm_to_update.type_moyenne = dm.type_moyenne
AND dm_to_update.eleve_id = dm.eleve_id
dm.sous_service_id,
dm.periode_id,
dm.type_moyenne,
- now()
+ clock_timestamp()
FROM dm
WHERE NOT EXISTS (
SELECT * FROM dm_updated
),
dm_updated AS (
UPDATE entnotes.dirty_moyenne AS dm_to_update
- SET date_changement = now()
+ SET date_changement = clock_timestamp()
FROM dm
WHERE dm_to_update.type_moyenne = dm.type_moyenne
AND dm_to_update.eleve_id = dm.eleve_id
dm.eleve_id,
dm.periode_id,
dm.type_moyenne,
- now()
+ clock_timestamp()
FROM dm
WHERE NOT EXISTS (
SELECT * FROM dm_updated
),
dm_updated AS (
UPDATE entnotes.dirty_moyenne AS dm_to_update
- SET date_changement = now()
+ SET date_changement = clock_timestamp()
FROM dm
WHERE dm_to_update.type_moyenne = dm.type_moyenne
AND dm_to_update.eleve_id = dm.eleve_id
dm.service_id,
dm.periode_id,
dm.type_moyenne,
- now()
+ clock_timestamp()
FROM dm
WHERE NOT EXISTS (
SELECT * FROM dm_updated
where eleve in (:eleves) \
and typeMoyenne = :typeMoyenne"
)
- .setParameter('date', GregorianCalendar.getInstance(Locale.FRANCE).getTime())
+ .setParameter('date', postgreSqlDateService.clockTimestamp())
.setParameterList('eleves', eleves)
.setParameter('typeMoyenne', TypeMoyenneEnum.ELEVE_PERIODE)
.executeUpdate()
return
}
- Date now = GregorianCalendar.getInstance(Locale.FRANCE).getTime()
-
// On avait des problemes quand on faisait des suppressions de plus que
// 4000 items dans un coup. Donc la on split la liste aux lots plus petits.
listeUtilsService.splitParLot(dirtyMoyenneIds, 3000).
set dateChangement = :date \
where d.id in (:dirtyMoyenneIds)"
)
- .setParameter('date', now)
+ .setParameter('date', postgreSqlDateService.clockTimestamp())
.setParameterList('dirtyMoyenneIds', lotDirtyMoyenneIds)
.executeUpdate()
}