From 9187afc018092bf036bfb5a63cc12acbe2f7422e Mon Sep 17 00:00:00 2001
From: Michael Wilson
Date: Wed, 8 Oct 2014 16:28:11 +0200
Subject: -Rechteveraltung funktioniert endlich beim anlegen eines neuen Image
 -> muss entsprechend für alle anderen Seiten sinnvoll übernommen werden

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 107 +++++++++++++++++++++++--
 1 file changed, 100 insertions(+), 7 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 0b5765fa..cb9464eb 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -942,7 +942,7 @@ public class SQL {
 		return ret;
 	}
 	
-	public int setImageRights(String pk_person, String pk_image,int role ,int read, int write, int changePermission, int admin,int linkallowed) {
+	public int setImageRights(String pk_person, String pk_image,int role ,int read, int write, int admin,int linkallowed) {
 
 	
 
@@ -951,7 +951,7 @@ public class SQL {
 			Statement stm = con.createStatement();
 			
 			String uid = UUID.randomUUID().toString();
-			stm.executeUpdate("INSERT INTO `bwLehrpool`.`pm_VLData_image`(`GUID`,`GUID_imageID`,`roleID`,`userID`,`image_read`,`image_write`,`image_admin`,`image_changePermission`,`link_allowed`)VALUES('"
+			stm.executeUpdate("INSERT INTO `bwLehrpool`.`pm_VLData_image`(`GUID`,`GUID_imageID`,`roleID`,`userID`,`image_read`,`image_write`,`image_admin`,`link_allowed`)VALUES('"
 					+ uid
 					+ "','"
 					+ pk_image
@@ -966,8 +966,6 @@ public class SQL {
 					+ "','"
 					+ admin
 					+ "','"
-					+ changePermission
-					+ "','"
 					+ linkallowed+ "');");
 			con.commit();
 			con.close();
@@ -1057,7 +1055,8 @@ public class SQL {
 	}
 	
 	//get all users from HS OG -- temp, tb replaced by allUsers bwLehrpool
-	public List<Person> getAllOGUsers(){
+	//does -NOT- return the user himself
+	public List<Person> getAllOtherSatelliteUsers(String userID){
 		Connection con=getConnection();
 		Statement stm=null;
 		ResultSet res = null;
@@ -1072,7 +1071,7 @@ public class SQL {
 			e.printStackTrace();
 		}
 		try {
-			res = stm.executeQuery("SELECT userID, Nachname, Vorname FROM m_user ORDER BY Nachname ASC;");
+			res = stm.executeQuery("SELECT userID, Nachname, Vorname FROM m_user WHERE userID !='"+userID+"' ORDER BY Nachname ASC;");
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
@@ -1096,7 +1095,101 @@ public class SQL {
 		
 	}
 	
+
 	
+	public boolean updateImagePermissions(){
+		boolean success=true;
+		
+		Connection con=getConnection();
+		Statement stm=null;
+		try {
+			stm = con.createStatement();
+			stm.executeQuery("");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return success;
+	}// end setImagePermissions()
 	
+	public boolean deleteImagePermissions(){
+		boolean success=true;
+		
+		Connection con=getConnection();
+		Statement stm=null;
+		try {
+			stm = con.createStatement();
+			stm.executeQuery("");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return success;
+	}// end setImagePermissions()
+	
+	public boolean writeAdditionalImageRights(String imageID, String userID, boolean isRead, boolean isWrite, boolean isLinkAllowed, boolean isAdmin){
+		boolean success= true;
+		
+		String uid = UUID.randomUUID().toString();
+		Connection con=getConnection();
+		Statement stm=null;
+		
+		try {
+			stm=con.createStatement();
+	
+			log.info(new Date() + " - INSERT INTO pm_VLData_image (" +
+						"GUID, " +
+						"GUID_imageID, " +
+						"roleID, " +
+						"userID, " +
+						"image_read, " +
+						"image_write, " +
+						"Image_admin, " +
+						"link_allowed)" +
+					"VALUES(" +
+						"'"+uid+"'," +
+						"'"+imageID+"'," +
+						"1," +
+						"'"+userID+"'," +
+						isRead+"," +
+						isWrite+"," +
+						isLinkAllowed+"," +
+						isAdmin+"" +
+					")");
+			
+			stm.executeUpdate("INSERT INTO pm_VLData_image (" +
+						"GUID, " +
+						"GUID_imageID, " +
+						"roleID, " +
+						"userID, " +
+						"image_read, " +
+						"image_write, " +
+						"Image_admin, " +
+						"link_allowed)" +
+					"VALUES(" +
+						"'"+uid+"'," +
+						"'"+imageID+"'," +
+						"1," +
+						"'"+userID+"'," +
+						isRead+"," +
+						isWrite+"," +
+						isLinkAllowed+"," +
+						isAdmin+"" +
+					");");
+			con.commit();
+			con.close();
+			log.info(new Date() + " - Written additional image rights.");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+			log.info(new Date() + " - Failed to write additional image rights.");
+		}
+		
+		
+		return success;
+		
+	}// end 
 	
-}
+}//end class
-- 
cgit v1.2.3-55-g7522