[server] Send mails when lecture gets deactivated

1 files changed, 20 insertions, 13 deletions

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
index 147b6b8a..ff160917 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
@@ -574,20 +574,25 @@ public class DbLecture {
 			throw e;
 		}
 	}
+	
+	public static List<LectureSummary> getLecturesUsingImageVersion(MysqlConnection connection, String imageVersionId)
+	throws SQLException {
+		MysqlStatement stmt = connection.prepareStatement(summaryBaseSql
+				+ " WHERE l.imageversionid = :imageversionid");
+		stmt.setString("userid", "-");
+		stmt.setString("imageversionid", imageVersionId);
+		ResultSet rs = stmt.executeQuery();
+		List<LectureSummary> list = new ArrayList<>();
+		while (rs.next()) {
+			list.add(fillSummary(null, rs));
+		}
+		return list;
+	}
 
 	public static List<LectureSummary> getLecturesUsingImageVersion(String imageVersionId)
 			throws SQLException {
 		try (MysqlConnection connection = Database.getConnection()) {
-			MysqlStatement stmt = connection.prepareStatement(summaryBaseSql
-					+ " WHERE l.imageversionid = :imageversionid");
-			stmt.setString("userid", "-");
-			stmt.setString("imageversionid", imageVersionId);
-			ResultSet rs = stmt.executeQuery();
-			List<LectureSummary> list = new ArrayList<>();
-			while (rs.next()) {
-				list.add(fillSummary(null, rs));
-			}
-			return list;
+			return getLecturesUsingImageVersion(connection, imageVersionId);
 		} catch (SQLException e) {
 			LOGGER.error("Query failed in DbLecture.getExpiringLectures()", e);
 			throw e;
@@ -606,10 +611,12 @@ public class DbLecture {
 
 	protected static void unlinkFromImageVersion(MysqlConnection connection, String imageVersionId)
 			throws SQLException {
-		MysqlStatement stmt = connection.prepareStatement("UPDATE lecture SET imageversionid = NULL"
+		List<LectureSummary> lectures = getLecturesUsingImageVersion(connection, imageVersionId);
+		MysqlStatement uStmt = connection.prepareStatement("UPDATE lecture SET imageversionid = NULL"
 				+ " WHERE imageversionid = :imageversionid");
-		stmt.setString("imageversionid", imageVersionId);
-		stmt.executeUpdate();
+		uStmt.setString("imageversionid", imageVersionId);
+		uStmt.executeUpdate();
+		MailGenerator.lectureDeactivated(lectures);
 	}
 
 }