From 76375531e24e40a553531f80d438ef9288b60079 Mon Sep 17 00:00:00 2001
From: Nino Breuer
Date: Mon, 3 Nov 2014 11:38:03 +0100
Subject: fixed bug: all images now show ALL images

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 37 ++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)

(limited to 'dozentenmodulserver/src/main/java/sql')

diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index 235874c2..c9615d41 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -417,6 +417,43 @@ public class SQL {
 		}
 		return list;
 	}
+	
+	public List<Image> getImageList(String userID) {
+
+		Connection con = getConnection();
+		Statement stm;
+
+		List<Image> list = new ArrayList<Image>();
+		try {
+
+			stm = con.createStatement();
+
+			// ResultSet
+			ResultSet res = stm
+					.executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name, vl.cond_hasLicenseRestriction, os.name, os.architecture,  '' as lecture, vl.image_update_time,  Concat(u.Nachname,' ',u.Vorname) as user,  vl.image_isTemplate, vl.image_description FROM  bwLehrpool.pm_VLData_image pmi,  bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os,  bwLehrpool.m_user u WHERE u.userID = vl.image_owner AND vl.content_operatingSystem = os.operatingSystemID");
+					
+
+			while (res.next()) {
+				list.add(new Image(res.getString("GUID_imageID"), res
+						.getString("imageVersion"),
+						res.getString("image_name"), res
+								.getString("cond_hasLicenseRestriction"), res
+								.getString("name")
+								+ " "
+								+ res.getString("architecture") + " bit", res
+								.getString("lecture"), res
+								.getString("image_update_time"), res
+								.getString("user"), res
+								.getString("image_isTemplate"),
+								res.getString("image_description")));
+			}
+			con.close();
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return list;
+	}
 
 	public List<Image> getImageListPermissionLink(String userID) {
 
-- 
cgit v1.2.3-55-g7522