- theLog = Logfile.getInstance(this.getClass().getName());
- templateListString = MirConfig.getProp("ServletModule.Bilder.ListTemplate");
- templateObjektString = MirConfig.getProp("ServletModule.Bilder.ObjektTemplate");
- templateConfirmString = MirConfig.getProp("ServletModule.Bilder.ConfirmTemplate");
- try {
- mainModule = new ModuleImages(DatabaseImages.getInstance());
- mediafolderModule = new ModuleMediafolder(DatabaseMediafolder.getInstance());
- dbRights = DatabaseRights.getInstance();
- dbImageFormat = DatabaseImageFormat.getInstance();
- dbImageColor = DatabaseImageColor.getInstance();
- dbImageType = DatabaseImageType.getInstance();
- dbImageLayout = DatabaseImageLayout.getInstance();
- }
- catch (StorageObjectException e) {
- theLog.printDebugInfo("servletmodulebilder konnte nicht initialisiert werden");
- }
- }
-
-
- public void insert(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- try {
- WebdbMultipartRequest mp = new WebdbMultipartRequest(req);
- HashMap parameters = mp.getParameters();
- String mediaId=null;
- MpRequest mpReq = (MpRequest)mp.requestList.get(0);
- byte[] imageData=mpReq.getMedia();
- String fileName=mpReq.getFilename();
- String contentType= mpReq.getContentType();
-
- EntityUsers user = _getUser(req);
- parameters.put("date", StringUtil.date2webdbDate(new GregorianCalendar()));
- parameters.put("to_publisher", user.getId());
- parameters.put("is_produced", "0");
- if (!parameters.containsKey("is_published"))
- parameters.put("is_published","0");
-
- String id = mainModule.add(parameters);
- EntityImages entImage = (EntityImages)mainModule.getById(id);
-
- if (imageData!=null && fileName!=null) {
- String fileType = "-1";
-
- //the where clause to find the media_type entry
- //from the content-type.
- //we use the media type entry to lookup the
- //media Handler/Storage classes
- String wc = " mime_type='"+contentType+"'";
-
- EntityList mediaTypesList = DatabaseMediaType.getInstance().selectByWhereClause(wc);
- String mediaTypeId = null;
- String mediaStorageName = null;
- String mediaHandlerName = null;
-
- //if we found an entry matching the
- //content-type int the table.
- if (mediaTypesList.size() > 0) {
- //get the class names from the media_type table.
- mediaTypeId = mediaTypesList.elementAt(0).getId();
- mediaStorageName = mediaTypesList.elementAt(0).getValue("tablename");
- mediaHandlerName = mediaTypesList.elementAt(0).getValue("classname");
- parameters.put("to_media_type",mediaTypeId);
-
- //load the classes via reflection
- String MediaId;
- try {
- Class mediaStorageClass = Class.forName("mircoders.storage.Database"+mediaStorageName);
- Method m = mediaStorageClass.getMethod("getInstance", null);
- Database mediaStorage = (Database)m.invoke(null, null);
- Entity mediaEnt = (Entity)mediaStorage.getEntityClass().newInstance();
- mediaEnt.setStorage(mediaStorage);
- mediaEnt.setValues(parameters);
- mediaId = mediaEnt.insert();
-
- Class mediaHandlerClass = Class.forName("mir.media.MediaHandler"+mediaHandlerName);
- MirMedia mediaHandler = (MirMedia)mediaHandlerClass.newInstance();
- //save and store the media data/metadata
- mediaHandler.set(mpReq.getMedia(), mediaEnt,mediaTypesList.elementAt(0));
-
- //were done with mpReq at this point, dereference it. as it contains
- //mucho mem. -mh 01.10.2001
- mpReq=null;
-
- if(mediaId!=null){
- new ProducerMedia().handle(null, null, false, false, mediaId);
- }
- } catch (Exception e) {
- theLog.printError("setting uploaded_media failed: "+e.toString());
- } //end try-catch
-
-
- if (fileType != "-1")
- entImage.setImage(imageData, fileType);
- else
- theLog.printError("Wrong file uploaded!");
- }
- _edit(id, req, res);
- }
- }
- catch (IOException e) { throw new ServletModuleException("upload -- ioexception " + e.toString());}
- catch (ModuleException e) { throw new ServletModuleException("upload -- moduleexception " + e.toString());}
- catch (StorageObjectException e) { throw new ServletModuleException("StorageObjectException" + e.toString());}
-
- }
-
- public void update(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
-
- try {
- WebdbMultipartRequest mp = new WebdbMultipartRequest(req);
- HashMap parameters = mp.getParameters();
- MpRequest mpReq = (MpRequest)mp.requestList.get(0);
- byte[] imageData=mpReq.getMedia();
- String fileName=mpReq.getFilename();
- String contentType=mpReq.getContentType();
-
- EntityUsers user = _getUser(req);
- parameters.put("to_publisher", user.getId());
- parameters.put("is_produced", "0");
- if (!parameters.containsKey("is_published"))
- parameters.put("is_published","0");
-
- String id = mainModule.set(parameters);
- EntityImages entImage = (EntityImages)mainModule.getById(id);
-
- if (imageData!=null && fileName!=null) {
- String fileType = "-1";
- if (contentType.equals("image/jpeg")) fileType="0";
- if (contentType.equals("image/gif")) fileType="1";
- if (fileType != "-1")
- entImage.setImage(imageData, fileType);
- else
- theLog.printError("Wrong file uploaded!");
- }
- _edit(id, req, res);
- }
- catch (IOException e) { throw new ServletModuleException("upload -- ioexception " + e.toString());}
- catch (ModuleException e) { throw new ServletModuleException("upload -- moduleexception " + e.toString());}
-
- }
-
-
- public void showimg(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException
- {
- String idParam = req.getParameter("id");
- if (idParam!=null && !idParam.equals("")) {
- try {
- EntityImages entImage =(EntityImages)mainModule.getById(idParam);
- res.setContentType("image/jpeg"); // testweise
- ServletOutputStream out = res.getOutputStream(); // wichtig, dass vorher kein res.getwriter() gelaufen ist
-
- byte[] outbytes = entImage.getImage();
- out.write(outbytes);
- out.close();
- }
-
- catch (IOException e) {throw new ServletModuleException(e.toString());}
- catch (ModuleException e) {throw new ServletModuleException(e.toString());}
- catch (Exception e) {throw new ServletModuleException(e.toString());}
- }
- else theLog.printDebugInfo("id nicht angeben.");
- // darf keine exception werfen
- }
-
- public void showicon(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException
- {
- String idParam = req.getParameter("id");
- if (idParam!=null && !idParam.equals("")) {
- try {
- EntityImages entImage =(EntityImages)mainModule.getById(idParam);
- res.setContentType("image/jpeg"); // testweise
- ServletOutputStream out = res.getOutputStream(); // wichtig, dass vorher kein res.getwriter() gelaufen ist
-
- byte[] outbytes = entImage.getIcon();
- out.write(outbytes);
- out.close();
- }
-
- catch (IOException e) {throw new ServletModuleException(e.toString());}
- catch (ModuleException e) {throw new ServletModuleException(e.toString());}
- catch (Exception e) {throw new ServletModuleException(e.toString());}
- }
- else throw new ServletModuleException("id nicht angeben.");
- }
-
- public void list(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException
- {
- // Parameter auswerten
- SimpleHash mergeData = new SimpleHash();
- String query_text = req.getParameter("query_text");
- mergeData.put("query_text",query_text);
- if (query_text!=null) mergeData.put("query_text_encoded",URLEncoder.encode(query_text));
- String query_field = req.getParameter("query_field");
- mergeData.put("query_field",query_field);
- String query_is_published = req.getParameter("query_is_published");
- mergeData.put("query_is_published",query_is_published);
- String query_media_folder = req.getParameter("query_media_folder");
- mergeData.put("query_media_folder",query_media_folder);
- String offset = req.getParameter("offset");
- if (offset==null || offset.equals("")) offset="0";
- mergeData.put("offset",offset);
-
- String order = req.getParameter("order");
- if (order==null) order="webdb_lastchange desc";
-
- // if in connection mode to content
- String cid = req.getParameter("cid");
- mergeData.put("cid",cid);
-
-
- // sql basteln
- String whereClause=""; boolean isFirst=true;
- if (query_text!=null && !query_text.equalsIgnoreCase("")) {
- whereClause += "lower("+query_field+") like lower('%"+query_text+"%')"; isFirst=false;}
- if (query_is_published != null && !query_is_published.equals("")) {
- if (isFirst==false) whereClause+=" and ";
- whereClause += "is_published='"+query_is_published+"'";
- isFirst=false;
- }
- if (query_media_folder != null && !query_media_folder.equals("")) {
- if (isFirst==false) whereClause+=" and ";
- whereClause += "to_media_folder='"+query_media_folder+"'";
- }
- //theLog.printDebugInfo("sql-whereclause: " + whereClause + " order: " + order + " offset: " + offset);