diff options
| author | Michael Wilson | 2014-10-14 18:53:57 +0200 |
|---|---|---|
| committer | Michael Wilson | 2014-10-14 18:53:57 +0200 |
| commit | cdc14633ee8bbcfb9a847f0dd109708d8b088fd4 (patch) | |
| tree | 94ad4fb1b951a971b48f61cac553290f8a858bfd /dozentenmodulserver/src/main/java/sql | |
| parent | Text angepasst (diff) | |
| download | tutor-module-cdc14633ee8bbcfb9a847f0dd109708d8b088fd4.tar.gz tutor-module-cdc14633ee8bbcfb9a847f0dd109708d8b088fd4.tar.xz tutor-module-cdc14633ee8bbcfb9a847f0dd109708d8b088fd4.zip | |
-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... :(
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 59 |
1 files changed, 48 insertions, 11 deletions
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;
|