--- /dev/null
+/*
+ * Copyright © FYLAB and the Conseil Régional d'Île-de-France, 2009
+ * This file is part of L'Interface Libre et Interactive de l'Enseignement
+ * (Lilie).
+ *
+ * Lilie is free software. You can redistribute it and/or modify since
+ * you respect the terms of either (at least one of the both license) :
+ * - under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ * - the CeCILL-C as published by CeCILL-C; either version 1 of the
+ * License, or any later version
+ *
+ * There are special exceptions to the terms and conditions of the
+ * licenses as they are applied to this software. View the full text of
+ * the exception in file LICENSE.txt in the directory of this software
+ * distribution.
+ *
+ * Lilie is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * Licenses for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * and the CeCILL-C along with Lilie. If not, see :
+ * <http://www.gnu.org/licenses/> and
+ * <http://www.cecill.info/licences.fr.html>.
+ */
+
+package org.lilie.services.eliot.scolarite.suppressionutilisateurs
+
+import groovy.sql.Sql
+import java.sql.Timestamp
+import org.lilie.services.eliot.securite.impl.Autorite
+
+class SuppressionPhysiqueUtilisateursService {
+
+ static transactional = true
+
+ def dataSource
+
+ public Timestamp getDateDebutDerniereBascule(){
+ Sql sql = new Sql(dataSource)
+
+ String str = "SELECT min(date_debut) FROM bascule_annee.etape"
+
+ return (Timestamp)sql.firstRow(str).get("min")
+
+ }
+
+ public def supprimerPhysiquementUtilisateurs(Timestamp dateMaximale,
+ Integer autoritesIdASupprimer){
+
+ Sql sql = new Sql(dataSource)
+
+ String str = """SELECT * FROM suppression_utilisateurs('$dateMaximale', $autoritesIdASupprimer)"""
+
+ def result = sql.rows(str)
+
+ return result
+ }
+
+}