-
- static ModuleTopics themenModule;
- static ModuleSchwerpunkt schwerpunktModule;
- static ModuleGruppen gruppenModule;
- static ModuleImages imageModule;
-
- static String templateOpString;
-
- // Singelton / Kontruktor
-
- private static ServletModuleContent instance = new ServletModuleContent();
- public static ServletModule getInstance() { return instance; }
-
- private ServletModuleContent() {
- try {
- theLog = Logfile.getInstance(Configuration.getProperty("Home") + Configuration.getProperty("ServletModule.Content.Logfile"));
- templateListString = Configuration.getProperty("ServletModule.Content.ListTemplate");
- templateOpString = Configuration.getProperty("ServletModule.Content.OpTemplate");
- templateObjektString = Configuration.getProperty("ServletModule.Content.ObjektTemplate");
- templateConfirmString = Configuration.getProperty("ServletModule.Content.ConfirmTemplate");
- mainModule = new ModuleContent(DatabaseContent.getInstance());
- themenModule = new ModuleTopics(DatabaseTopics.getInstance());
- schwerpunktModule = new ModuleSchwerpunkt(DatabaseFeature.getInstance());
- gruppenModule = new ModuleGruppen(DatabaseGroups.getInstance());
- imageModule = new ModuleImages(DatabaseImages.getInstance());
- }
- catch (StorageObjectException e) {
- theLog.printDebugInfo("servletmodulecontent konnte nicht initialisiert werden");
- }
- }
-
- // Methoden
-
- public void list(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- try {
- EntityUsers user = _getUser(req);
- EntityList theList;
- String offsetParam = req.getParameter("offset");
- int offset =0;
-
- // hier offsetcode bearbeiteb
- if (offsetParam != null && !offsetParam.equals(""))
- offset = Integer.parseInt(offsetParam);
-
- if (req.getParameter("next") != null)
- offset=Integer.parseInt(req.getParameter("nextoffset"));
- else
- if (req.getParameter("prev") != null)
- offset = Integer.parseInt(req.getParameter("prevoffset"));
-
- String whereParam = req.getParameter("where");
- String orderParam = req.getParameter("order");
-
- theList = ((ModuleContent)mainModule).getContent(whereParam, orderParam, offset, user);
- _list(theList, req, res);
- } catch (ModuleException e) {
- throw new ServletModuleException(e.toString());
- }
- }
-
- public void listop(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- try {
- EntityUsers user = _getUser(req);
- EntityList theList;
- String offsetParam = req.getParameter("offset");
- int offset =0;
-
- String whereParam = req.getParameter("where");
-
- if (whereParam==null) whereParam = "to_article_type='0'";
-
- // hier offsetcode bearbeiteb
- if (offsetParam != null && !offsetParam.equals(""))
- offset = Integer.parseInt(offsetParam);
-
- if (req.getParameter("next") != null)
- offset=Integer.parseInt(req.getParameter("nextoffset"));
- else
- if (req.getParameter("prev") != null)
- offset = Integer.parseInt(req.getParameter("prevoffset"));
-
- String orderParam = req.getParameter("order");
-
- theList = ((ModuleContent)mainModule).getContent(whereParam, orderParam, offset, user);
- _list(theList, req, res);
- } catch (ModuleException e) {
- throw new ServletModuleException(e.toString());
- }
- }
-
-
- public void search(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException {
- try {
- EntityUsers user = _getUser(req);
- EntityList theList;
- String fieldParam = req.getParameter("field");
- String fieldValueParam = req.getParameter("fieldvalue");
- String orderParam = req.getParameter("order");
-
- theList = ((ModuleContent)mainModule).getContentByField(fieldParam, fieldValueParam, orderParam, 0, user);
- _list(theList, req, res);
- } catch (ModuleException e) {
- throw new ServletModuleException(e.toString());
- }
- }
-
- public void add(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException {
-
- EntityUsers user = _getUser(req);
- SimpleHash mergeData = new SimpleHash();
- mergeData.put("new", "1");
- mergeData.put("is_published", "1");
- String now = StringUtil.date2webdbDate(new GregorianCalendar());
- mergeData.put("date", new SimpleScalar(now));
- mergeData.put("themenPopupData", themenModule.getTopicsAsSimpleList());
- mergeData.put("gruppenPopupData", gruppenModule.getGruppenAsSimpleList());
- try {
- mergeData.put("articletypePopupData", DatabaseArticleType.getInstance().getPopupData());
- } catch (Exception e) {theLog.printError("articletype could not be fetched.");}
- //mergeData.put("gruppenHashData", gruppenModule.getHashData());
- mergeData.put("schwerpunktPopupData", schwerpunktModule.getSchwerpunktAsSimpleList());
- mergeData.put("login_user", HTMLTemplateProcessor.makeSimpleHash(user));
- deliver(req, res, mergeData, templateObjektString);
- }
-
-
- public void insert(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- //theLog.printDebugInfo(":: content :: trying to insert");
- try {
- EntityUsers user = _getUser(req);
- HashMap withValues = getIntersectingValues(req, DatabaseContent.getInstance());
- //theLog.printDebugInfo(":: content :: got intersecting values");
- String now = StringUtil.date2webdbDate(new GregorianCalendar());
- withValues.put("date", now);
- withValues.put("publish_path", StringUtil.webdbDate2path(now));
- withValues.put("to_publisher", user.getId());
- withValues.put("is_produced", "0");
- if (!withValues.containsKey("is_published"))
- withValues.put("is_published","0");
- if (!withValues.containsKey("is_html"))
- withValues.put("is_html","0");
- if (withValues.get("creator").toString().equals(""))
- withValues.put("creator","Anonym");
- String id = mainModule.add(withValues);
- DatabaseContentToTopics.getInstance().setTopics(id,req.getParameterValues("to_topic"));
- //theLog.printDebugInfo(":: content :: inserted");
- _showObject(id, req, res);
- }
- catch (StorageObjectException e) { throw new ServletModuleException(e.toString());}
- catch (ModuleException e) { throw new ServletModuleException(e.toString());}
- }
-
- public void delete(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
-
- EntityUsers user = _getUser(req);
- // hier pruefen ob dem akt. user loeschen erlaubt ist...
- String idParam = req.getParameter("id");
- if (idParam == null) throw new ServletModuleException("Falscher Aufruf: (id) nicht angegeben");
-
- String confirmParam = req.getParameter("confirm");
- String cancelParam = req.getParameter("cancel");
-
- if (confirmParam == null && cancelParam == null) {
- // HTML Ausgabe zum Confirmen!
- SimpleHash mergeData = new SimpleHash();
- mergeData.put("module", "Content");
- mergeData.put("infoString", "Content: " + idParam);
- mergeData.put("id", idParam);
- mergeData.put("where", req.getParameter("where"));
- mergeData.put("order", req.getParameter("order"));
- mergeData.put("offset", req.getParameter("offset"));
- deliver(req, res, mergeData, templateConfirmString);
- }
- else {
- if (confirmParam!= null && !confirmParam.equals("")) {
- try {
- mainModule.deleteById(idParam);
- //delete rows in the content_x_topic-table
- DatabaseContentToTopics.getInstance().deleteByContentId(idParam);
- //delete rows in the comment-table
- DatabaseComment.getInstance().deleteByContentId(idParam);
- } catch (ModuleException e) {
- throw new ServletModuleException(e.toString());
- } catch (StorageObjectException e) {
- throw new ServletModuleException(e.toString());
- }
- list(req,res);
- }
- else {
- // Datensatz anzeigen
- _showObject(idParam, req, res);
- }
- }
- }
-
- public void edit(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- String idParam = req.getParameter("id");
- if (idParam == null) throw new ServletModuleException("Falscher Aufruf: (id) nicht angegeben");
- _showObject(idParam, req, res);
- }
-
- // methods for attaching media file
- public void attach(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- String mediaIdParam = req.getParameter("mid");
- String idParam = req.getParameter("cid");
- if (idParam == null||mediaIdParam==null) throw new ServletModuleException("smod content :: attach :: cid/mid missing");
- try {
- EntityContent entContent = (EntityContent)mainModule.getById(idParam);
- entContent.attach(mediaIdParam);
- }
- catch(ModuleException e) {
- theLog.printError("smod content :: attach :: could not get entityContent");
- }
- _showObject(idParam, req, res);
- }
-
- public void dettach(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- String idParam = req.getParameter("cid");
- if (idParam == null) throw new ServletModuleException("smod content :: dettach :: cid missing");
- try {
- EntityContent entContent = (EntityContent)mainModule.getById(idParam);
- entContent.dettach();
- }
- catch(ModuleException e) {
- theLog.printError("smod content :: dettach :: could not get entityContent");
- }
- _showObject(idParam, req, res);
- }
-
- public void newswire(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
- {
- String idParam = req.getParameter("id");
- if (idParam == null) throw new ServletModuleException("smod content :: newswire :: id missing");
- try {
- EntityContent entContent = (EntityContent)mainModule.getById(idParam);
- entContent.newswire();
- }
- catch(ModuleException e) {
- theLog.printError("smod content :: newswire :: could not get entityContent");
- }
- list(req, res);
- }
-
-
- public void update(HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException
- {
- try {
-
- EntityUsers user = _getUser(req);
- if (user==null) theLog.printDebugInfo("user null!");
- String idParam = req.getParameter("id");
- if (idParam == null) throw new ServletModuleException("Falscher Aufruf: (id) nicht angegeben");
-
- HashMap withValues = getIntersectingValues(req, DatabaseContent.getInstance());
- //String topic_id = req.getParameter("to_topic");
- String[] topic_id = req.getParameterValues("to_topic");
- String content_id = req.getParameter("id");
- // withValues.put("publish_path", StringUtil.webdbDate2path((String)withValues.get("date")));
- if(user != null) withValues.put("user_id", user.getId());
- withValues.put("is_produced", "0");
- if (!withValues.containsKey("is_published"))
- withValues.put("is_published","0");
- if (!withValues.containsKey("is_html"))
- withValues.put("is_html","0");
- if (withValues.get("creator").toString().equals(""))
- withValues.put("creator","Anonym");
- //theLog.printDebugInfo("updating. ");
- String id = mainModule.set(withValues);
- DatabaseContentToTopics.getInstance().setTopics(req.getParameter("id"),topic_id);
- //theLog.printDebugInfo("update done. ");
- String whereParam = req.getParameter("where");
- String orderParam = req.getParameter("order");
- if ((whereParam!=null && !whereParam.equals("")) || (orderParam!=null && !orderParam.equals(""))){
- //theLog.printDebugInfo("update to list");
- list(req,res);
- }
- else
- _showObject(idParam, req, res);
- }
- catch (StorageObjectException e) { throw new ServletModuleException(e.toString());}
- catch (ModuleException e) { throw new ServletModuleException(e.toString());}
- }
-
- //
- // Hilfsmethoden
-
- private void _showObject(String id, HttpServletRequest req, HttpServletResponse res)
- throws ServletModuleException {
-
- try {
- EntityContent entContent=(EntityContent)mainModule.getById(id);
- SimpleHash mergeData = HTMLTemplateProcessor.makeSimpleHash(entContent);
- EntityList topicToContent = DatabaseContentToTopics.getInstance().getTopics(entContent);
- if (topicToContent!=null && topicToContent.size()>0){
- theLog.printDebugInfo("topicanzahl: "+topicToContent.size());
- Entity topics = null;
- SimpleList topicList = new SimpleList();
- for(int i=0;i<topicToContent.size();i++){
- topics = (EntityTopics)topicToContent.elementAt(i);
- topicList.add(topics.getId());
+ static ModuleTopics themenModule;
+ static ModuleSchwerpunkt schwerpunktModule;
+ static ModuleImages imageModule;
+
+ static String templateOpString;
+
+// Singelton / Kontruktor
+
+ private static ServletModuleContent instance = new ServletModuleContent();
+ public static ServletModule getInstance() { return instance; }
+
+ private ServletModuleContent() {
+ logger = new LoggerWrapper("ServletModule.Content");
+ try {
+ templateListString = MirConfig.getProp("ServletModule.Content.ListTemplate");
+ templateObjektString = MirConfig.getProp("ServletModule.Content.ObjektTemplate");
+ templateConfirmString = MirConfig.getProp("ServletModule.Content.ConfirmTemplate");
+
+ mainModule = new ModuleContent(DatabaseContent.getInstance());
+ themenModule = new ModuleTopics(DatabaseTopics.getInstance());
+ schwerpunktModule = new ModuleSchwerpunkt(DatabaseFeature.getInstance());
+ imageModule = new ModuleImages(DatabaseImages.getInstance());
+ }
+ catch (StorageObjectException e) {
+ logger.error("servletmodulecontent konnte nicht initialisiert werden");
+ }
+ }
+
+// Methoden
+
+ public void list(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
+ {
+ EntityUsers user = _getUser(req);
+ String offsetParam = req.getParameter("offset");
+ String whereParam = req.getParameter("where");
+ String orderParam = req.getParameter("order");
+
+ int offset =0;
+
+ if (offsetParam != null && !offsetParam.equals(""))
+ offset = Integer.parseInt(offsetParam);
+
+ if (req.getParameter("next") != null)
+ offset=Integer.parseInt(req.getParameter("nextoffset"));
+ else
+ if (req.getParameter("prev") != null)
+ offset = Integer.parseInt(req.getParameter("prevoffset"));
+
+ returnArticleList(req, res, whereParam, orderParam, offset);
+ }
+
+ public void listop(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
+ {
+ EntityUsers user = _getUser(req);
+ String offsetParam = req.getParameter("offset");
+ int offset =0;
+
+ String whereParam = req.getParameter("where");
+
+ if (whereParam==null) whereParam = "to_article_type='0'";
+
+// hier offsetcode bearbeiteb
+ if (offsetParam != null && !offsetParam.equals(""))
+ offset = Integer.parseInt(offsetParam);
+
+ if (req.getParameter("next") != null)
+ offset=Integer.parseInt(req.getParameter("nextoffset"));
+ else
+ if (req.getParameter("prev") != null)
+ offset = Integer.parseInt(req.getParameter("prevoffset"));
+
+ String orderParam = req.getParameter("order");
+
+ returnArticleList(req, res, whereParam, orderParam, offset);
+ }
+
+
+ public void search(HttpServletRequest req, HttpServletResponse res)
+ throws ServletModuleException {
+ try {
+ EntityUsers user = _getUser(req);
+ EntityList theList;
+ String fieldParam = req.getParameter("field");
+ String fieldValueParam = req.getParameter("fieldvalue");
+ String orderParam = req.getParameter("order");
+
+ theList = ((ModuleContent)mainModule).getContentByField(fieldParam, fieldValueParam, orderParam, 0, user);
+ returnArticleList(req, res, "lower("+ fieldParam + ") like lower('%" + JDBCStringRoutines.escapeStringLiteral(fieldValueParam) + "%')", orderParam, 0);
+ } catch (ModuleException e) {
+ throw new ServletModuleException(e.toString());
+ }
+ }
+
+ public void add(HttpServletRequest req, HttpServletResponse res)
+ throws ServletModuleException {
+ _showObject(null, req, res);
+ }
+
+
+ public void insert(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
+ {
+//theLog.printDebugInfo(":: content :: trying to insert");
+ try {
+ EntityUsers user = _getUser(req);
+ HashMap withValues = getIntersectingValues(req, DatabaseContent.getInstance());
+
+ String now = StringUtil.date2webdbDate(new GregorianCalendar());
+ withValues.put("date", now);
+ withValues.put("publish_path", StringUtil.webdbDate2path(now));
+ withValues.put("to_publisher", user.getId());
+ withValues.put("is_produced", "0");
+ if (!withValues.containsKey("is_published"))
+ withValues.put("is_published","0");
+ if (!withValues.containsKey("is_html"))
+ withValues.put("is_html","0");
+
+ String id = mainModule.add(withValues);
+ DatabaseContentToTopics.getInstance().setTopics(id,req.getParameterValues("to_topic"));
+
+ _showObject(id, req, res);
+ }
+ catch (StorageObjectException e) {
+ throw new ServletModuleException(e.toString());
+ }
+ catch (ModuleException e) {
+ throw new ServletModuleException(e.toString());
+ }
+ }
+
+ public void delete(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException
+ {
+ EntityUsers user = _getUser(req);
+
+ String idParam = req.getParameter("id");
+ if (idParam == null) throw new ServletModuleException("Invalid call: id missing");
+
+ String confirmParam = req.getParameter("confirm");
+ String cancelParam = req.getParameter("cancel");
+
+ logger.info("where = " + req.getParameter("where"));
+
+ if (confirmParam == null && cancelParam == null) {
+
+ SimpleHash mergeData = new SimpleHash();
+ mergeData.put("module", "Content");
+ mergeData.put("infoString", "Content: " + idParam);
+ mergeData.put("id", idParam);
+ mergeData.put("where", req.getParameter("where"));
+ mergeData.put("order", req.getParameter("order"));
+ mergeData.put("offset", req.getParameter("offset"));
+ deliver(req, res, mergeData, templateConfirmString);
+ }
+ else {
+ if (confirmParam!= null && !confirmParam.equals("")) {
+ try {
+ mainModule.deleteById(idParam);
+
+ /** @todo the following two should be implied in
+ * DatabaseContent */
+
+ //delete rows in the content_x_topic-table
+ DatabaseContentToTopics.getInstance().deleteByContentId(idParam);
+ //delete rows in the comment-table
+ DatabaseComment.getInstance().deleteByContentId(idParam);
+ } catch (ModuleException e) {
+ throw new ServletModuleException(e.toString());
+ } catch (StorageObjectException e) {
+ throw new ServletModuleException(e.toString());