X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fservlet%2FServletModuleContent.java;h=04d04fd7f9b8d5dfb68fd04a5bef1b458edfd6e1;hb=626a903ec07e58e845d9bf5c6467adc7a95db1c9;hp=cc317f84ab35f1de6d501ffb548aefb860b29039;hpb=c1442585c17418ee8c6d96635a180c0a3c55ef07;p=mir.git diff --git a/source/mircoders/servlet/ServletModuleContent.java b/source/mircoders/servlet/ServletModuleContent.java index cc317f84..04d04fd7 100755 --- a/source/mircoders/servlet/ServletModuleContent.java +++ b/source/mircoders/servlet/ServletModuleContent.java @@ -1,562 +1,605 @@ -/* - * Copyright (C) 2001, 2002 The Mir-coders group - * - * This file is part of Mir. - * - * Mir is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * Mir is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with Mir; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - * - * In addition, as a special exception, The Mir-coders gives permission to link - * the code of this program with the com.oreilly.servlet library, any library - * licensed under the Apache Software License, The Sun (tm) Java Advanced - * Imaging library (JAI), The Sun JIMI library (or with modified versions of - * the above that use the same license as the above), and distribute linked - * combinations including the two. You must obey the GNU General Public - * License in all respects for all of the code used other than the above - * mentioned libraries. If you modify this file, you may extend this exception - * to your version of the file, but you are not obligated to do so. If you do - * not wish to do so, delete this exception statement from your version. - */ - -package mircoders.servlet; - -import java.io.IOException; -import java.util.GregorianCalendar; -import java.util.HashMap; -import java.util.Iterator; -import java.util.List; -import java.util.Map; - -import javax.servlet.http.HttpServletRequest; -import javax.servlet.http.HttpServletResponse; -import javax.servlet.http.HttpSession; - -import mir.entity.adapter.EntityAdapterModel; -import mir.entity.adapter.EntityIteratorAdapter; -import mir.log.LoggerWrapper; -import mir.misc.StringUtil; -import mir.module.ModuleException; -import mir.servlet.ServletModule; -import mir.servlet.ServletModuleException; -import mir.storage.StorageObjectFailure; -import mir.util.CachingRewindableIterator; -import mir.util.HTTPRequestParser; -import mir.util.JDBCStringRoutines; -import mir.util.SQLQueryBuilder; -import mir.util.URLBuilder; -import mircoders.entity.EntityContent; -import mircoders.entity.EntityUsers; -import mircoders.global.MirGlobal; -import mircoders.module.ModuleContent; -import mircoders.search.IndexUtil; -import mircoders.storage.DatabaseComment; -import mircoders.storage.DatabaseContent; -import mircoders.storage.DatabaseContentToTopics; - -import org.apache.lucene.index.IndexReader; - -import freemarker.template.SimpleHash; - -/* - * ServletModuleContent - - * deliver html for the article admin form. - * - * @version $Id: ServletModuleContent.java,v 1.35 2003/02/28 18:27:08 idfx Exp $ - * @author rk, mir-coders - * - */ - -public class ServletModuleContent extends ServletModule -{ - private String editTemplate = configuration.getString("ServletModule.Content.ObjektTemplate");; - private String listTemplate = configuration.getString("ServletModule.Content.ListTemplate"); - - private static ServletModuleContent instance = new ServletModuleContent(); - public static ServletModule getInstance() { return instance; } - - private ServletModuleContent() { - super(); - logger = new LoggerWrapper("ServletModule.Content"); - try { - - templateListString = configuration.getString("ServletModule.Content.ListTemplate"); - templateObjektString = configuration.getString("ServletModule.Content.ObjektTemplate"); - templateConfirmString = configuration.getString("ServletModule.Content.ConfirmTemplate"); - - mainModule = new ModuleContent(DatabaseContent.getInstance()); - } - catch (StorageObjectFailure e) { - logger.error("servletmodulecontent konnte nicht initialisiert werden"); - } - } - - public void list(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException - { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - - String where = requestParser.getParameter("where"); - String order = requestParser.getParameterWithDefault("order", "webdb_create desc"); - int offset = requestParser.getIntegerWithDefault("offset", 0); - String selectArticleUrl = requestParser.getParameter("selectarticleurl"); - - returnArticleList(aRequest, aResponse, where, order, offset, selectArticleUrl); - } - - public void search(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException { - try { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - SQLQueryBuilder queryBuilder = new SQLQueryBuilder(); - String searchField = requestParser.getParameterWithDefault("searchfield", ""); - String searchValue = requestParser.getParameterWithDefault("searchvalue", "").trim(); - String searchOrder = requestParser.getParameterWithDefault("searchorder", ""); - String searchispublished = requestParser.getParameterWithDefault("searchispublished", ""); - String searchArticleType = requestParser.getParameterWithDefault("searcharticletype", ""); - String selectArticleUrl = requestParser.getParameter("selectarticleurl"); - - if (searchValue.length()>0) { - if (searchField.equals("contents")) - queryBuilder.appendAndCondition( - "(lower(content_data) like " + "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%')"+ - " or (lower(description) like " + "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%')"); - else - queryBuilder.appendAndCondition( - "lower("+ searchField + ") like " + - "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%'"); - } - - if (searchispublished.length()>0) { - if (searchispublished.equals("0")) - queryBuilder.appendAndCondition("is_published='f'"); - else - queryBuilder.appendAndCondition("is_published='t'"); - } - - if (searchArticleType.length()>0) { - queryBuilder.appendAndCondition("to_article_type="+Integer.parseInt(searchArticleType)); - } - - if (searchOrder.length()>0) { - if (searchOrder.equals("datedesc")) - queryBuilder.appendAscendingOrder("webdb_create"); - else if (searchOrder.equals("dateasc")) - queryBuilder.appendDescendingOrder("webdb_create"); - else if (searchOrder.equals("title")) - queryBuilder.appendDescendingOrder("title"); - else if (searchOrder.equals("creator")) - queryBuilder.appendDescendingOrder("creator"); - } - - returnArticleList(aRequest, aResponse, queryBuilder.getWhereClause(), queryBuilder.getOrderByClause(), 0, selectArticleUrl); - } - catch (Throwable 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 (StorageObjectFailure 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); - //delete from lucene index, if any - String index = configuration.getString("IndexPath"); - if (IndexReader.indexExists(index)){ - IndexUtil.unindexID(idParam,index); - } - - } - catch (ModuleException e) { - throw new ServletModuleException(e.toString()); - } - catch (StorageObjectFailure e) { - throw new ServletModuleException(e.toString()); - } - catch (IOException 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("Invalid call: id not supplied "); - _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) { - logger.error("smod content :: attach :: could not get entityContent"); - } - catch(StorageObjectFailure e) { - logger.error("smod content :: attach :: could not get entityContent"); - } - - _showObject(idParam, req, res); - } - - public void dettach(HttpServletRequest req, HttpServletResponse res) throws ServletModuleException - { - String cidParam = req.getParameter("cid"); - String midParam = req.getParameter("mid"); - if (cidParam == null) throw new ServletModuleException("smod content :: dettach :: cid missing"); - if (midParam == null) throw new ServletModuleException("smod content :: dettach :: mid missing"); - - try { - EntityContent entContent = (EntityContent)mainModule.getById(cidParam); - entContent.dettach(cidParam,midParam); - } - catch(ModuleException e) { - logger.error("smod content :: dettach :: could not get entityContent"); - } - catch(StorageObjectFailure e) { - logger.error("smod content :: dettach :: could not get entityContent"); - } - - _showObject(cidParam, req, res); - } - - public void update(HttpServletRequest aRequest, HttpServletResponse aResponse) - throws ServletModuleException - { - try { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - - String returnUrl = requestParser.getParameter("returnurl"); - - String idParam = aRequest.getParameter("id"); - if (idParam == null) throw new ServletModuleException("Wrong call: (id) is missing"); - - HashMap withValues = getIntersectingValues(aRequest, DatabaseContent.getInstance()); - String[] topic_id = aRequest.getParameterValues("to_topic"); - String content_id = aRequest.getParameter("id"); - - 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.set(withValues); - DatabaseContentToTopics.getInstance().setTopics(aRequest.getParameter("id"),topic_id); - - String whereParam = aRequest.getParameter("where"); - String orderParam = aRequest.getParameter("order"); - - if (returnUrl!=null){ - redirect(aResponse, returnUrl); - } - else - _showObject(idParam, aRequest, aResponse); - } - catch (Throwable e) { - throw new ServletModuleException(e.toString()); - } - } - -/* - * HelperMethod shows the basic article editing form. - * - * if the "id" parameter is null, it means show an empty form to add a new - * article. -*/ - private void _showObject(String id, HttpServletRequest aRequest, HttpServletResponse aResponse) - throws ServletModuleException { - - try { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - Map responseData = ServletHelper.makeGenerationData(getLocale(aRequest)); - EntityAdapterModel model = MirGlobal.localizer().dataModel().adapterModel(); - Map article; - URLBuilder urlBuilder = new URLBuilder(); - - urlBuilder.setValue("module", "Content"); - urlBuilder.setValue("do", "edit"); - urlBuilder.setValue("id", id); - urlBuilder.setValue("returnurl", requestParser.getParameter("returnurl")); - - if (id!=null) { - responseData.put("new", Boolean.FALSE); - article = model.makeEntityAdapter("content", mainModule.getById(id)); - } - else { - List fields = DatabaseContent.getInstance().getFields(); - responseData.put("new", Boolean.TRUE); - article = new HashMap(); - Iterator i = fields.iterator(); - while (i.hasNext()) { - article.put(i.next(), null); - } - - article.put("to_topics", null); - - MirGlobal.localizer().adminInterface().initializeArticle(article); - } - responseData.put("article", article); - - responseData.put("returnurl", requestParser.getParameter("returnurl")); - responseData.put("thisurl", urlBuilder.getQuery()); - - ServletHelper.generateResponse(aResponse.getWriter(), responseData, editTemplate); - } - catch (Exception e) { - throw new ServletModuleException(e.toString()); - } - } - - public void returnArticleList( - HttpServletRequest aRequest, - HttpServletResponse aResponse, - String aWhereClause, - String anOrderByClause, - int anOffset, - String aSelectArticleUrl) throws ServletModuleException { - - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - URLBuilder urlBuilder = new URLBuilder(); - EntityAdapterModel model; - int nrArticlesPerPage = 20; - int count; - - try { - Map responseData = ServletHelper.makeGenerationData(getLocale(aRequest)); - model = MirGlobal.localizer().dataModel().adapterModel(); - - Object articleList = - new CachingRewindableIterator( - new EntityIteratorAdapter( aWhereClause, anOrderByClause, nrArticlesPerPage, - MirGlobal.localizer().dataModel().adapterModel(), "content", nrArticlesPerPage, anOffset) - ); - - responseData.put("nexturl", null); - responseData.put("prevurl", null); - - count=mainModule.getSize(aWhereClause); - - urlBuilder.setValue("module", "Content"); - urlBuilder.setValue("do", "list"); - urlBuilder.setValue("where", aWhereClause); - urlBuilder.setValue("order", anOrderByClause); - - - urlBuilder.setValue("searchfield", requestParser.getParameter("searchfield")); - urlBuilder.setValue("searchvalue", requestParser.getParameter("searchvalue")); - urlBuilder.setValue("searchispublished", requestParser.getParameter("searchispublished")); - urlBuilder.setValue("searchorder", requestParser.getParameter("searchorder")); - urlBuilder.setValue("searcharticletype", requestParser.getParameter("searcharticletype")); - urlBuilder.setValue("selectarticleurl", aSelectArticleUrl); - - responseData.put("searchfield", requestParser.getParameter("searchfield")); - responseData.put("searchvalue", requestParser.getParameter("searchvalue")); - responseData.put("searchispublished", requestParser.getParameter("searchispublished")); - responseData.put("searchorder", requestParser.getParameter("searchorder")); - responseData.put("searcharticletype", requestParser.getParameter("searcharticletype")); - responseData.put("selectarticleurl", aSelectArticleUrl); - - urlBuilder.setValue("offset", anOffset); - responseData.put("offset" , new Integer(anOffset).toString()); - responseData.put("thisurl" , urlBuilder.getQuery()); - - if (count>=anOffset+nrArticlesPerPage) { - urlBuilder.setValue("offset", anOffset + nrArticlesPerPage); - responseData.put("nexturl" , urlBuilder.getQuery()); - } - - if (anOffset>0) { - urlBuilder.setValue("offset", Math.max(anOffset - nrArticlesPerPage, 0)); - responseData.put("prevurl" , urlBuilder.getQuery()); - } - - responseData.put("articles", articleList); - - responseData.put("from" , Integer.toString(anOffset+1)); - responseData.put("count", Integer.toString(count)); - responseData.put("to", Integer.toString(Math.min(anOffset+nrArticlesPerPage, count))); - responseData.put("offset" , Integer.toString(anOffset)); - responseData.put("order", anOrderByClause); - responseData.put("where" , aWhereClause); - - ServletHelper.generateResponse(aResponse.getWriter(), responseData, listTemplate); - } - catch (Throwable e) { - throw new ServletModuleException(e.toString()); - } - } - - public void selectparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException - { - try { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - URLBuilder urlBuilder = new URLBuilder(); - - urlBuilder.setValue("module", "Content"); - urlBuilder.setValue("do", "setparent"); - urlBuilder.setValue("childid", requestParser.getParameter("id")); - urlBuilder.setValue("returnurl", requestParser.getParameter("returnurl")); - - returnArticleList(aRequest, aResponse, "", "", 0, urlBuilder.getQuery()); - } - catch (Throwable e) { - throw new ServletModuleException(e.getMessage()); - } - } - - public void listchildren(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException - { - try { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - String articleId = requestParser.getParameter("article_id"); - - if (articleId == null) - throw new ServletModuleException("ServletModuleContent.listchildren: article_id not set!"); - - returnArticleList(aRequest, aResponse, "to_content = " + articleId, "", 0, null); - } - catch (Throwable e) { - throw new ServletModuleException(e.getMessage()); - } - } - - public void setparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException - { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - String articleId = aRequest.getParameter("childid"); - String parentId = aRequest.getParameter("id"); - String returnUrl = aRequest.getParameter("returnurl"); - - try { - EntityContent article = (EntityContent) mainModule.getById(articleId); - article.setValueForProperty("to_content", parentId); - article.setProduced(false); - article.update(); - } - catch(Throwable e) { - logger.error("ServletModuleContent.setparent: " + e.getMessage()); - throw new ServletModuleException("ServletModuleContent.setparent: " + e.getMessage()); - } - - redirect(aResponse, returnUrl); - } - - public void clearparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleException - { - HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); - String articleId = requestParser.getParameter("id"); - String returnUrl = requestParser.getParameter("returnurl"); - - try { - EntityContent article = (EntityContent) mainModule.getById(articleId); - article.setValueForProperty("to_content", ""); - article.setProduced(false); - article.update(); - } - catch(Throwable e) { - e.printStackTrace(logger.asPrintWriter(LoggerWrapper.DEBUG_MESSAGE)); - logger.error("ServletModuleContent.clearparent: " + e.getMessage()); - - throw new ServletModuleException("ServletModuleContent.clearparent: " + e.getMessage()); - } - - redirect(aResponse, returnUrl); - } - - private EntityUsers _getUser(HttpServletRequest req) - { - HttpSession session=req.getSession(false); - - return (EntityUsers)session.getAttribute("login.uid"); - } -} +/* + * Copyright (C) 2001, 2002 The Mir-coders group + * + * This file is part of Mir. + * + * Mir is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * Mir is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with Mir; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + * + * In addition, as a special exception, The Mir-coders gives permission to link + * the code of this program with any library licensed under the Apache Software License, + * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library + * (or with modified versions of the above that use the same license as the above), + * and distribute linked combinations including the two. You must obey the + * GNU General Public License in all respects for all of the code used other than + * the above mentioned libraries. If you modify this file, you may extend this + * exception to your version of the file, but you are not obligated to do so. + * If you do not wish to do so, delete this exception statement from your version. + */ + +package mircoders.servlet; + +import mir.entity.adapter.EntityAdapter; +import mir.entity.adapter.EntityAdapterEngine; +import mir.entity.adapter.EntityAdapterModel; +import mir.generator.Generator; +import mir.misc.StringUtil; +import mir.servlet.AdminServletModule; +import mir.servlet.ServletModuleExc; +import mir.servlet.ServletModuleFailure; +import mir.util.HTTPRequestParser; +import mir.util.JDBCStringRoutines; +import mir.util.SQLQueryBuilder; +import mir.util.StringRoutines; +import mir.util.URLBuilder; +import mircoders.entity.EntityContent; +import mircoders.entity.EntityUsers; +import mircoders.global.MirGlobal; +import mircoders.module.ModuleContent; +import mircoders.storage.DatabaseContent; +import mircoders.storage.DatabaseContentToTopics; + +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; +import java.util.ArrayList; +import java.util.Collections; +import java.util.GregorianCalendar; +import java.util.HashMap; +import java.util.Iterator; +import java.util.List; +import java.util.Locale; +import java.util.Map; + +/** + * Article admin interface code + */ + +public class ServletModuleContent extends AdminServletModule { + private ModuleContent contentModule = new ModuleContent(); + + public ServletModuleContent() { + addPropagatedParameter("selectarticleurl"); + addPropagatedParameter("searchtopic"); + addPropagatedParameter("searchvalue"); + addPropagatedParameter("searcharticletype"); + + definition = "content"; + mainModule = contentModule; + } + + public void search(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc, ServletModuleFailure { + try { + String extraTables = ""; + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + SQLQueryBuilder queryBuilder = new SQLQueryBuilder(); + String searchField = requestParser.getParameterWithDefault("searchfield", ""); + String searchValue = requestParser.getParameterWithDefault("searchvalue", "").trim(); + String searchOrder = requestParser.getParameterWithDefault("searchorder", ""); + String searchispublished = requestParser.getParameterWithDefault("searchispublished", ""); + String searchArticleType = requestParser.getParameterWithDefault("searcharticletype", ""); + String searchTopic = requestParser.getParameterWithDefault("searchtopic", ""); + + if (searchValue.length()>0) { + if ("id".equals(searchField)) { + queryBuilder.appendAndCondition( + "id='"+JDBCStringRoutines.escapeStringLiteral(searchValue)+"'"); + } + else if ("contents".equals(searchField)) { + queryBuilder.appendAndCondition( + "(lower(content_data) like " + "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%')"+ + " or (lower(description) like " + "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%')"); + } + else { + queryBuilder.appendAndCondition( + "lower("+ searchField + ") like " + + "'%" + JDBCStringRoutines.escapeStringLiteral(searchValue.toLowerCase()) + "%'"); + } + } + + if (searchispublished.length()>0) { + if ("0".equals(searchispublished)) { + queryBuilder.appendAndCondition("is_published='f'"); + } + else { + queryBuilder.appendAndCondition("is_published='t'"); + } + } + + if (searchArticleType.length()>0) { + queryBuilder.appendAndCondition("to_article_type="+Integer.parseInt(searchArticleType)); + } + + if (searchOrder.length()>0) { + if ("datedesc".equals(searchOrder)) { + queryBuilder.appendDescendingOrder("webdb_create"); + } + else if ("dateasc".equals(searchOrder)) { + queryBuilder.appendAscendingOrder("webdb_create"); + } + else if ("title".equals(searchOrder)) { + queryBuilder.appendAscendingOrder("title"); + } + else if ("creator".equals(searchOrder)) { + queryBuilder.appendAscendingOrder("creator"); + } + } + + if (searchTopic.length() > 0) { + queryBuilder.appendAndCondition("cxt.content_id = id"); + queryBuilder.appendAndCondition("cxt.topic_id = " + JDBCStringRoutines.escapeStringLiteral(searchTopic)); + + extraTables = "content_x_topic cxt"; + } + + returnList(aRequest, aResponse, queryBuilder.getWhereClause(), queryBuilder.getOrderByClause(), 0, + Collections.EMPTY_MAP, null, extraTables); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + public void add(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + editObject(aRequest, aResponse, null, aRequest.getParameter("template")); + } + + public void insert(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + try { + Map withValues = getIntersectingValues(aRequest, DatabaseContent.getInstance()); + + String now = StringUtil.date2webdbDate(new GregorianCalendar()); + withValues.put("date", now); + withValues.put("publish_path", StringUtil.webdbDate2path(now)); + withValues.put("to_publisher", ServletHelper.getUser(aRequest).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 webdbCreate = (String) withValues.get("webdb_create"); + if (webdbCreate==null || webdbCreate.trim().length()==0) { + withValues.remove("webdb_create"); + } + + String id = mainModule.add(withValues); + logAdminUsage(aRequest, id, "object added"); + + DatabaseContentToTopics.getInstance().setTopics(id, aRequest.getParameterValues("to_topic")); + + editObject(aRequest, aResponse, id, aRequest.getParameter("template")); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + public void edit(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + String idParam = aRequest.getParameter("id"); + if (idParam == null) { + throw new ServletModuleExc("Invalid call: id not supplied "); + } + + editObject(aRequest, aResponse, idParam, aRequest.getParameter("template")); + } + + /** + * Attaches media to an article + * @param aRequest + * @param aResponse + * @throws mir.servlet.ServletModuleExc + */ + public void attach(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + String mediaIdParam = aRequest.getParameter("mid"); + String articleId = aRequest.getParameter("articleid"); + if (articleId == null || mediaIdParam==null) { + throw new ServletModuleExc("smod content :: attach :: articleid/mid missing"); + } + + // check if mediaIdParam and articleid are correct integers + try { + Integer.parseInt(mediaIdParam); + Integer.parseInt(articleId); + } + catch (NumberFormatException e) { + throw new ServletModuleExc("smod content :: attach :: invalid articleid/mid", e); + } + + if (!MirGlobal.accessControl().article().mayEditArticle(ServletHelper.getUser(aRequest), articleId)) { + throw new ServletModuleExc("Article has been locked"); + } + + try { + EntityContent entContent = (EntityContent) mainModule.getById(articleId); + entContent.attach(mediaIdParam); + } + catch(Throwable e) { + throw new ServletModuleFailure(e); + } + + logAdminUsage(aRequest, articleId, "media " + mediaIdParam + " attached"); + + editObject(aRequest, aResponse, articleId, aRequest.getParameter("template")); + } + + /** + * Deattaches media from an article + */ + public void dettach(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + String articleId = aRequest.getParameter("articleid"); + String midParam = aRequest.getParameter("mid"); + if (articleId == null) + throw new ServletModuleExc("smod content :: dettach :: articleid missing"); + if (midParam == null) + throw new ServletModuleExc("smod content :: dettach :: mid missing"); + + if (!MirGlobal.accessControl().article().mayEditArticle(ServletHelper.getUser(aRequest), articleId)) + throw new ServletModuleExc("Article has been locked"); + + try { + EntityContent entContent = (EntityContent)mainModule.getById(articleId); + entContent.dettach(articleId, midParam); + } + catch(Throwable e) { + throw new ServletModuleFailure(e); + } + + logAdminUsage(aRequest, articleId, "media " + midParam + " deattached"); + + editObject(aRequest, aResponse, articleId, aRequest.getParameter("request")); + } + + /** + * Locks an article + */ + public void lock(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc + { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + + String idParam = requestParser.getParameter("id"); + if (idParam == null) { + throw new ServletModuleExc("Wrong call: (id) is missing"); + } + + EntityUsers user = ServletHelper.getUser(aRequest); + + if (!MirGlobal.accessControl().article().mayLockArticle(user, idParam)) { + throw new ServletModuleExc("Unable to lock"); + } + + contentModule.lockArticle(idParam, user.getId(), false); + + editObject(aRequest, aResponse, idParam, aRequest.getParameter("template")); + } + + /** + * Unlocks an article + */ + public void unlock(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc + { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + + String idParam = requestParser.getParameter("id"); + if (idParam == null) { + throw new ServletModuleExc("Wrong call: (id) is missing"); + } + + EntityUsers user = ServletHelper.getUser(aRequest); + + if (!MirGlobal.accessControl().article().mayUnlockArticle(user, idParam)) { + throw new ServletModuleExc("Unable to unlock"); + } + + contentModule.unlockArticle(idParam, user.getId(), false); + + editObject(aRequest, aResponse, idParam, aRequest.getParameter("template")); + } + + /** + * Forcelocks an article + */ + public void forcelock(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + + String idParam = requestParser.getParameter("id"); + if (idParam == null) { + throw new ServletModuleExc("Wrong call: (id) is missing"); + } + + EntityUsers user = ServletHelper.getUser(aRequest); + + if (!MirGlobal.accessControl().article().mayForceLockArticle(user, idParam)) { + throw new ServletModuleExc("Unable to force lock"); + } + + contentModule.lockArticle(idParam, user.getId(), true); + + editObject(aRequest, aResponse, idParam, aRequest.getParameter("template")); + } + + /** + * Stores an article + */ + public void update(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + try { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + + String idParam = requestParser.getParameter("id"); + if (idParam == null) { + throw new ServletModuleExc("Wrong call: (id) is missing"); + } + + if (!MirGlobal.accessControl().article().mayEditArticle(ServletHelper.getUser(aRequest), idParam)) { + throw new ServletModuleExc("Article has been locked"); + } + + Map withValues = getIntersectingValues(aRequest, DatabaseContent.getInstance()); + + 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 webdbCreate = (String) withValues.get("webdb_create"); + if (webdbCreate==null || webdbCreate.trim().length()==0) { + withValues.remove("webdb_create"); + } + + String id = mainModule.set(withValues); + + logAdminUsage(aRequest, id, "object modified"); + + DatabaseContentToTopics.getInstance().setTopics(aRequest.getParameter("id"), aRequest.getParameterValues("to_topic")); + + if (MirGlobal.accessControl().article().mayUnlockArticle(ServletHelper.getUser(aRequest), idParam) && + requestParser.getParameterWithDefault("unlock", "0").equals("1")) { + contentModule.unlockArticle(id, ServletHelper.getUser(aRequest).getId(), false); + } + + editObject(aRequest, aResponse, idParam, aRequest.getParameter("template")); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + + /** + * Returns the basic article editing form. + * + * @param anId identifier of the article. null, means show an + * @param aTemplate + */ + public void editObject(HttpServletRequest aRequest, HttpServletResponse aResponse, + String anId, String aTemplate) throws ServletModuleExc { + try { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + Map responseData = ServletHelper.makeGenerationData(aRequest, aResponse, new Locale[] { getLocale(aRequest), getFallbackLocale(aRequest)}); + EntityAdapterModel model = MirGlobal.localizer().dataModel().adapterModel(); + Object article; + URLBuilder urlBuilder = new URLBuilder(); + + urlBuilder.setValue("module", "Content"); + urlBuilder.setValue("do", "edit"); + urlBuilder.setValue("id", anId); + urlBuilder.setValue("template", aTemplate); + urlBuilder.setValue("returnurl", requestParser.getParameter("returnurl")); + + if (anId !=null) { + responseData.put("new", Boolean.FALSE); + article = model.makeEntityAdapter("content", mainModule.getById(anId)); + + EntityUsers user = ServletHelper.getUser(aRequest); + + responseData.put("mayEdit", + Boolean.valueOf(MirGlobal.accessControl().article().mayEditArticle(user, anId))); + responseData.put("mayLock", + Boolean.valueOf(MirGlobal.accessControl().article().mayLockArticle(user, anId))); + responseData.put("mayForceLock", + Boolean.valueOf(MirGlobal.accessControl().article().mayForceLockArticle(user, anId))); + responseData.put("mayUnlock", + Boolean.valueOf(MirGlobal.accessControl().article().mayUnlockArticle(user, anId))); + } + else { + List fields = DatabaseContent.getInstance().getFieldNames(); + responseData.put("new", Boolean.TRUE); + + Map emptyArticle = new HashMap(); + + Iterator i = fields.iterator(); + while (i.hasNext()) { + emptyArticle.put(i.next(), null); + } + + emptyArticle.put("to_topics", null); + + MirGlobal.localizer().adminInterface().initializeArticle(emptyArticle); + article = emptyArticle; + + responseData.put("mayEdit", Boolean.TRUE); + responseData.put("mayLock", Boolean.FALSE); + responseData.put("mayForceLock", Boolean.FALSE); + responseData.put("mayUnlock", Boolean.FALSE); + + } + responseData.put("article", article); + + List topicsList = new ArrayList(); + + String[] topicCategories = getConfiguration().getStringArray("Mir.Localizer.Admin.TopicLists"); + + if (topicCategories.length==0 ) { + Map categoryMap = new HashMap(); + categoryMap.put("key", "topic"); + categoryMap.put("listtype", "0"); + categoryMap.put("listparameter", "3"); + categoryMap.put("items", EntityAdapterEngine.retrieveAdapterList(model, "topic", "", "title", -1, 0)); + topicsList.add(categoryMap); + } + else { + for (int i = 0; i < topicCategories.length; i++) { + Map categoryMap = new HashMap(); + List parts = StringRoutines.splitString(topicCategories[i], ":"); + + String key = null; + + if (parts.size() > 0) { + key = (String) parts.get(0); + } + String listtype = "0"; + if (parts.size() > 1) { + listtype = (String) parts.get(1); + } + String listparameter = "5"; + if (parts.size() > 2) { + listparameter = (String) parts.get(2); + } + String where = ""; + if (parts.size() > 3) { + where = (String) parts.get(3); + } + String order = ""; + if (parts.size() > 4) { + order = (String) parts.get(4); + } + + if (key != null) { + categoryMap.put("key", key); + categoryMap.put("listtype", listtype); + categoryMap.put("listparameter", listparameter); + categoryMap.put("items", EntityAdapterEngine.retrieveAdapterList(model, "topic", where, order, -1, 0)); + topicsList.add(categoryMap); + } + } + } + + responseData.put("topics", topicsList); + + responseData.put("returnurl", requestParser.getParameter("returnurl")); + responseData.put("thisurl", urlBuilder.getQuery()); + + if (aTemplate == null) { + aTemplate = editGenerator; + } + + ServletHelper.generateResponse(aResponse.getWriter(), responseData, aTemplate); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + public void selectparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + try { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + URLBuilder urlBuilder = new URLBuilder(); + + urlBuilder.setValue("module", "Content"); + urlBuilder.setValue("do", "setparent"); + urlBuilder.setValue("childid", requestParser.getParameter("id")); + urlBuilder.setValue("returnurl", requestParser.getParameter("returnurl")); + + returnList(aRequest, aResponse, "", "", 0, + Collections.singletonMap("selectarticleurl", urlBuilder.getQuery())); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + public void listchildren(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + String articleId = requestParser.getParameter("article_id"); + + if (articleId == null) { + throw new ServletModuleExc("ServletModuleContent.listchildren: article_id not set!"); + } + + try { + returnList(aRequest, aResponse, "to_content = " + articleId, "webdb_create desc", 0); + } + catch (Throwable e) { + throw new ServletModuleFailure(e); + } + } + + public void setparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + String articleId = requestParser.getParameter("childid"); + String parentId = requestParser.getParameter("id"); + String returnUrl = requestParser.getParameter("returnurl"); + + if (!MirGlobal.accessControl().article().mayEditArticle(ServletHelper.getUser(aRequest), articleId)) + throw new ServletModuleExc("Article has been locked"); + + try { + EntityContent article = (EntityContent) mainModule.getById(articleId); + article.setFieldValue("to_content", parentId); + article.setProduced(false); + article.update(); + logAdminUsage(aRequest, articleId, "parent set to " + parentId); + } + catch(Throwable e) { + getLogger().error("ServletModuleContent.setparent: " + e.getMessage()); + + throw new ServletModuleFailure(e); + } + + ServletHelper.redirect(aResponse, returnUrl); + } + + public void clearparent(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + String articleId = requestParser.getParameter("id"); + String returnUrl = requestParser.getParameter("returnurl"); + + try { + EntityContent article = (EntityContent) mainModule.getById(articleId); + article.setFieldValue("to_content", null); + article.setProduced(false); + article.update(); + logAdminUsage(aRequest, articleId, "parent cleared"); + } + catch(Throwable e) { + getLogger().error("ServletModuleContent.clearparent: " + e.getMessage(), e); + + throw new ServletModuleFailure("ServletModuleContent.clearparent: " + e.getMessage(), e); + } + + ServletHelper.redirect(aResponse, returnUrl); + } + + public void showPreview(HttpServletRequest aRequest, HttpServletResponse aResponse) throws ServletModuleExc { + try { + HTTPRequestParser requestParser = new HTTPRequestParser(aRequest); + String articleId = requestParser.getParameter("id"); + EntityAdapter article = getModel().makeEntityAdapter("content", mainModule.getById(articleId)); + String preview = requestParser.getParameterWithDefault("preview", "default"); + + Map generationValues = new HashMap(); + Generator generator = + MirGlobal.localizer().adminInterface().prepareArticlePreview(preview, article, generationValues); + + generator.generate(aResponse.getWriter(), generationValues, getLogger()); + } + catch (Exception e) { + throw new ServletModuleFailure(e); + } + } +}