From cdc14633ee8bbcfb9a847f0dd109708d8b088fd4 Mon Sep 17 00:00:00 2001
From: Michael Wilson
Date: Tue, 14 Oct 2014 18:53:57 +0200
Subject: -Wechsel ins Hauptmenü löscht nun gespeichrte Berechtigungen, die
 sich noch im Zwischenspeicher befinden -Beim Bearbeiten vom Image werden nun
 Berechtigte Benutzer angezeigt -Aktuell funktioniert bei den Veranstaltungen
 nichts... :(

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 59 +++++++++++++++++++++-----
 1 file changed, 48 insertions(+), 11 deletions(-)

(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 3c82b182..80e19ea4 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -1112,16 +1112,15 @@ public List<Image> getImageListPermissionLink(String userID) {
 		return id;
 	}
 	
-	//get all users from HS OG -- temp, tb replaced by allUsers bwLehrpool
+	//get all users from satellite -- temp, tb replaced by allUsers bwLehrpool
 	//does -NOT- return the user himself
 	public List<Person> getAllOtherSatelliteUsers(String userID){
 		Connection con=getConnection();
 		Statement stm=null;
 		ResultSet res = null;
-		//Map<String, String> map = new HashMap<String, String>();
+
 		List<Person> list = new ArrayList<Person>();
 		
-		
 		try {
 			stm = con.createStatement();
 		} catch (SQLException e) {
@@ -1134,26 +1133,64 @@ public List<Image> getImageListPermissionLink(String userID) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		}
-		
 		try {
 			while (res.next()) {
-				
-				
+				//fill the list with users - permissions are all false because the image is new
 				list.add(new Person(res.getString("userID"), 
 						res.getString("Nachname"),
-						res.getString("Vorname")));
-
+						res.getString("Vorname"), false, false, false, false, false, false, false));
 			}
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		}
-		
 		return list;
-		
-	}
+	}//end getAllOtherSatelliteUsers()
+	
 	
+	// get the permissions of an image or a lecture for all other registered users -EXCEPT- the logged on user
+	public List<Person> getPermissionForUserAndImage(String userID, String imageID){
+		Connection con=getConnection();
+		Statement stm=null;
+		ResultSet res = null;
 
+		List<Person> list = new ArrayList<Person>();
+		
+		try {
+			stm = con.createStatement();
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		try {
+			res = stm.executeQuery("SELECT DISTINCT pmi.GUID_imageID, pmi.userID, u.userID,	u.Nachname,	u.Vorname, pmi.image_read, pmi.image_write,	pmi.image_admin, pmi.link_allowed FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_user u WHERE pmi.userID!='"+userID+"' AND pmi.GUID_imageID='"+imageID+"' AND pmi.userID=u.userID AND pmi.image_write=1 ORDER BY u.Nachname ASC;");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		try {
+			while (res.next()) {
+				//fill the list with users - permissions are all false because the image is new
+				list.add(new Person(res.getString("userID"), 
+						res.getString("Nachname"),
+						res.getString("Vorname"),
+						Boolean.parseBoolean(res.getString("image_read")),
+						Boolean.parseBoolean(res.getString("image_write")),
+						Boolean.parseBoolean(res.getString("image_admin")),
+						Boolean.parseBoolean(res.getString("link_allowed")),
+						false, //lecture_read
+						false, //lecture_write
+						false) //lecture_admin
+				);
+			}
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return list;
+	}//end getAllOtherSatelliteUsers()
+	
+	
 	
 	public boolean updateImagePermissions(){
 		boolean success=true;
-- 
cgit v1.2.3-55-g7522