From 61e8e600dd1c9d6066711dfb9874e0117b87baf6 Mon Sep 17 00:00:00 2001 From: Jonathan Bauer Date: Wed, 10 Sep 2014 14:54:40 +0200 Subject: mavenization v2 --- .../src/main/java/server/ServerHandler.java | 190 ++++++++++++++++++--- 1 file changed, 165 insertions(+), 25 deletions(-) (limited to 'Dozentenmodulserver/src/main/java/server/ServerHandler.java') diff --git a/Dozentenmodulserver/src/main/java/server/ServerHandler.java b/Dozentenmodulserver/src/main/java/server/ServerHandler.java index 6534ca3d..35b9579a 100644 --- a/Dozentenmodulserver/src/main/java/server/ServerHandler.java +++ b/Dozentenmodulserver/src/main/java/server/ServerHandler.java @@ -20,6 +20,9 @@ import models.Configuration; import org.apache.commons.io.FileUtils; import org.apache.log4j.Logger; import org.apache.thrift.TException; + +import com.mysql.jdbc.StringUtils; + import sql.SQL; import util.XMLCreator; @@ -156,11 +159,11 @@ public class ServerHandler implements Server.Iface { } @Override - public boolean writeVLdata(String imagename, String login, + public boolean writeVLdata(String imagename, String desc ,String login, String firstname, String lastname, String university, String Mail, String Tel, String Fak, boolean license, boolean internet, long ram, long cpu, String imagePath, boolean isTemplate, - long filesize, long shareMode) throws TException { + long filesize, long shareMode, String os) throws TException { String mode=null; @@ -177,8 +180,12 @@ public class ServerHandler implements Server.Iface { String pk_person = sql.setPerson(login, lastname, firstname, Mail, new Date(), pk_institution); - sql.setImageData(pk_person, license, internet, cpu, ram, imagename, - imagePath, isTemplate, filesize,mode); + //OS impl Select and write + //ACHTUNG: Anzahl der Leerzeichen muss eingehalten werden: 'Windows 7 32 bit" + String pk_os=sql.getOSpk(os.substring(0, nthIndexOf(os, " ", 2)),os.substring(nthIndexOf(os," ", 2), os.lastIndexOf(" ")).replace(" ", "")); + + sql.setImageData(pk_person, license, internet, cpu, ram, imagename,desc, + imagePath, isTemplate, filesize,mode,pk_os); log.info(new Date() + " - written VLdata"); // TODO Auto-generated method stub @@ -276,10 +283,10 @@ public class ServerHandler implements Server.Iface { } @Override - public boolean updateImageData(String name, String newName, + public boolean updateImageData(String name, String newName,String desc, String image_path, boolean license, boolean internet, long ram, long cpu, String id, String version, boolean isTemplate, - long filesize, long shareMode) throws TException { + long filesize, long shareMode, String os) throws TException { String mode=null; if(shareMode==0) @@ -289,17 +296,14 @@ public class ServerHandler implements Server.Iface { else{ mode="to_be_published"; } - sql.UpdateImageData(name, newName, image_path, license, internet, cpu, - ram, id, version, isTemplate, filesize,mode); + String pk_os=sql.getOSpk(os.substring(0, nthIndexOf(os, " ", 2)),os.substring(nthIndexOf(os," ", 2), os.lastIndexOf(" ")).replace(" ", "")); + sql.UpdateImageData(name, newName,desc ,image_path, license, internet, cpu, + ram, id, version, isTemplate, filesize,mode,pk_os); return false; } - @Override - public Map getLectureData(String lecturename) - throws TException { - // TODO Auto-generated method stub - return null; - } + + @Override public List getLectureList() throws TException { @@ -315,18 +319,26 @@ public class ServerHandler implements Server.Iface { @Override public boolean updateLecturedata(String name, String newName, String shortdesc, String desc, String startDate, String endDate, - boolean isActive, String imagename, String firstname, + boolean isActive, String imageid,String imageversion,String user ,String firstname, String lastname, String university, String Mail, String Tel, String Fak, String id) throws TException { - String pk_image = ""; - int imageversion = 0; - Map image = sql.getImageIDandVersion(imagename); - - pk_image = image.get("GUID"); - imageversion = Integer.parseInt(image.get("version")); - sql.updateLectureData(pk_image, imageversion, lastname, newName, desc, + Map map = new HashMap(); + map = sql.getDeleteXMLData(id); + sql.updateLectureData(imageid, imageversion, lastname, newName, desc, shortdesc, startDate, endDate, isActive, id); + String path = Configuration.config.getAbsolute_path() + + "prod/" + + map.get("date") + .substring(0, map.get("date").length() - 2) + "_" + + university + "_" + user + "_" + map.get("name") + ".xml"; + File tmpFile=new File(path); + try { + FileUtils.forceDelete(tmpFile); + } catch (IOException e1) { + // TODO Auto-generated catch block + e1.printStackTrace(); + } XMLCreator xml = new XMLCreator(sql.getConnection(), newName); try { xml.create(newName); @@ -336,8 +348,6 @@ public class ServerHandler implements Server.Iface { e.printStackTrace(); } - // sql.updateLectureData(con, pk_image, imageversion, lastname, newName, - // desc, shortdesc, startDate, endDate, isActive, id); return false; } @@ -384,7 +394,7 @@ public class ServerHandler implements Server.Iface { try { String path = Configuration.config.getAbsolute_path() - + "temp/" + + "prod/" + map.get("date") .substring(0, map.get("date").length() - 2) + "_" + hs + "_" + user + "_" + map.get("name") + ".xml"; @@ -403,5 +413,135 @@ public class ServerHandler implements Server.Iface { return sql.getAllUniversities(); } + + @Override + public Map getLectureData(String lectureid) + throws TException { + log.info(new Date() + " - returning LectureData: " + + sql.getLectureData(lectureid).size() + "items."); + return sql.getLectureData(lectureid); + } + + + + + public static int nthIndexOf(final String string, final String token, + final int index) + { + int j = 0; + + for (int i = 0; i < index; i++) + { + j = string.indexOf(token, j + 1); + if (j == -1) break; + } + + return j; + } + + @Override + public boolean checkUser(String username) throws TException { + return sql.checkUser(username); + + } + + @Override + public boolean createUser(String loginName, String lastName, + String firstName, String mail, String university) throws TException { + String pk_institution = sql.setInstitution(university); + String pk_person = sql.setPerson(loginName, lastName, firstName, mail, + new Date(), pk_institution); + return true; + } + + @Override + public boolean writeImageRights(String imagename, String username, String lastName, String firstName, String mail, String university, String role) + throws TException { + String pk_image = null; + Map map = new HashMap(); + int imageversion = 0; + String pk_institution = sql.setInstitution(university); + String pk_person = sql.setPerson(username, lastName, firstName, mail, + new Date(), pk_institution); + map = sql.getImageIDandVersion(imagename); + pk_image = map.get("GUID"); + imageversion = Integer.parseInt(map.get("version")); + + if(role.equals("Dozent")) { + int read=1; + int write=1; + int changePermission=0; + int admin=0; + int linkallowed=1; + int roleID=sql.getRoleID(role); + + sql.setImageRights(pk_person, pk_image, roleID, read, write, changePermission, admin, linkallowed); + + }else if(role.equals("Admin")){ + int read=1; + int write=1; + int changePermission=1; + int admin=1; + int linkallowed=1; + int roleID=sql.getRoleID(role); + + sql.setImageRights(pk_person, pk_image, roleID, read, write, changePermission, admin, linkallowed); + } + else{ + int read=1; + int write=0; + int changePermission=0; + int admin=0; + int linkallowed=0; + int roleID=sql.getRoleID(role); + + sql.setImageRights(pk_person, pk_image, roleID, read, write, changePermission, admin, linkallowed); + } + + return true; + } + + @Override + public boolean writeLectureRights(String lecturename, String username, + String lastName, String firstName, String mail, String university, + String role) throws TException { + String pk_lecture = null; + + String pk_institution = sql.setInstitution(university); + String pk_person = sql.setPerson(username, lastName, firstName, mail, + new Date(), pk_institution); + pk_lecture=sql.getLectureID(lecturename); + + if(role.equals("Dozent")) { + int read=1; + int write=1; + int changePermission=0; + int admin=0; + int roleID=sql.getRoleID(role); + + sql.setLectureRights(pk_person, pk_lecture, roleID, read, write, changePermission, admin); + + }else if(role.equals("Admin")){ + int read=1; + int write=1; + int changePermission=1; + int admin=1; + int roleID=sql.getRoleID(role); + + sql.setLectureRights(pk_person, pk_lecture, roleID, read, write, changePermission, admin); + } + else{ + int read=0; + int write=0; + int changePermission=0; + int admin=0; + int roleID=sql.getRoleID(role); + + sql.setLectureRights(pk_person, pk_lecture, roleID, read, write, changePermission, admin); + } + + return true; + } + } -- cgit v1.2.3-55-g7522