-package mircoders.module;
-
-import java.io.*;
-import java.util.*;
-import java.sql.*;
-import javax.servlet.*;
-import javax.servlet.http.*;
+/*
+ * 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.
+ */
-import mir.servlet.*;
-import mir.module.*;
-import mir.entity.*;
-import mir.misc.*;
-import mir.storage.*;
+package mircoders.module;
-import mircoders.entity.*;
+import mir.log.LoggerWrapper;
+import mir.module.AbstractModule;
+import mir.storage.StorageObject;
+import mir.util.JDBCStringRoutines;
+import mircoders.global.*;
-/*
- * ContentObjekt -
+/**
*
- *
- * @author RK
+ * <p>Title: ModuleContent</p>
+ * <p>Description: helper routines to manage articles</p>
+ * <p>Copyright: Copyright (c) 2003</p>
+ * <p>Company: </p>
+ * @author not attributable
+ * @version 1.0
*/
public class ModuleContent extends AbstractModule
{
- static Logfile theLog;
-
- public ModuleContent() {
- super();
- if (theLog == null) theLog = Logfile.getInstance(Configuration.getProperty("Home") + Configuration.getProperty("Module.Content.Logfile"));
- }
-
- public ModuleContent(StorageObject theStorage) {
- this.theStorage = theStorage;
- if (theLog == null) theLog = Logfile.getInstance(Configuration.getProperty("Home") + Configuration.getProperty("Module.Content.Logfile"));
- }
-
- //
- // methoden, um an ContentEntities zu kommen
-
-
- public EntityList getContent(HashMap searchValues, boolean concat, int offset, EntityUsers user)
- throws ModuleException {
-
- try {
-
- String whereClause ="", aField, aValue;
- boolean first = true;
-
- Set set = searchValues.keySet();
- Iterator it = set.iterator();
- for (int i=0;i<set.size();i++) {
- aField = (String)it.next();
- aValue = (String)searchValues.get(aField);
-
- if (first == false)
- whereClause += (concat) ? " and " : " or ";
- else
- first = false;
-
- whereClause += "(";
-
- // default: hier splitten der eintraege und verknupfung mit AND OR NOT
- StringTokenizer st = new StringTokenizer(aValue);
- boolean firstToken = true;
- while(st.hasMoreTokens()) {
- String notString = "";
- String tokenConcat = " OR ";
- String nextToken = st.nextToken();
-
- if (nextToken.startsWith("+")) {
- nextToken = nextToken.substring(1);
- tokenConcat = " AND ";
- }
- if (nextToken.startsWith("-")) {
- nextToken = nextToken.substring(1);
- tokenConcat = " AND ";
- notString = " NOT ";
- }
- if (firstToken == true) {
- tokenConcat = "";
- firstToken = false;
- }
-
-
- whereClause += tokenConcat + aField + notString + " like '";
- whereClause += nextToken + "%'";
- }
- whereClause += ") ";
- }
- return theStorage.selectByWhereClause(whereClause, offset);
- }
- catch (StorageObjectException e){
- throw new ModuleException(e.toString());
- }
-
- }
-
- public EntityList getContentByField(String aField, String aValue, String orderBy, int offset,
- EntityUsers user) throws ModuleException
- {
- String whereClause = "lower("+aField + ") like lower('%" + StringUtil.quote(aValue) + "%')";
- return getContent(whereClause, orderBy, offset, user);
- }
-
- public EntityList getContent(String whereClause, String orderBy, int offset, int limit, EntityGruppen user)
- throws ModuleException {
-
- try {
- if (user!=null){
- //theLog.printInfo("user!=null admin: "+ user.getValue("admin"));
- if (user.getValue("is_admin").equals("0"))
- whereClause += " and to_publisher='" + user.getId()+"'";
- }
- return theStorage.selectByWhereClause(whereClause, orderBy, offset, limit);
- }
- catch (StorageObjectException e){ throw new ModuleException(e.toString()); }
- }
-
- public EntityList getContent(String whereClause, String orderBy,int offset, int limit)
- throws ModuleException {
- try {
- return theStorage.selectByWhereClause(whereClause, orderBy, offset, limit);
- } catch (StorageObjectException e){
- throw new ModuleException(e.toString());
- }
- }
-
- public EntityList getContent(String whereClause, String orderBy, int offset, EntityUsers user)
- throws ModuleException
- {
- try {
- if (whereClause !=null) {
-
- // for the different article_types
- if(whereClause.equals("newswire")) {
- whereClause="is_published='1' and to_article_type='1'";
- orderBy = "webdb_create desc";
- }
- if(whereClause.equals("feature")) {
- whereClause="is_published='1' and to_article_type='2'";
- orderBy = "webdb_create desc";
- }
- if(whereClause.equals("themenspecial")) {
- whereClause="is_published='1' and to_article_type='3'";
- orderBy = "webdb_create desc";
- }
- if(whereClause.equals("special")) {
- whereClause="is_published='1' and to_article_type='4'";
- orderBy = "webdb_create desc";
- }
-
- if(whereClause.equals("comments")) {
- whereClause="not (comment is null or comment like '')";
- orderBy = "webdb_lastchange desc";
- }
-
- if(whereClause.equals("nfrei")) {
- whereClause="is_published='0'"; orderBy="date desc";
- }
-
- if(whereClause.equals("lastchange")) {
- whereClause=""; orderBy="webdb_lastchange desc";
- }
-
- if(whereClause.equals("media")) {
- whereClause="to_media > 0"; orderBy="webdb_lastchange desc";
- }
- }
- return theStorage.selectByWhereClause(whereClause, orderBy, offset);
- }
- catch (StorageObjectException e){ throw new ModuleException(e.toString()); }
- }
-
-
+ static LoggerWrapper logger = new LoggerWrapper("Module.Content");
+
+ public ModuleContent() {
+ super();
+ }
+
+ public ModuleContent(StorageObject aStorage) {
+ storage = aStorage;
+ }
+
+ public void expireArticleLock(String anId, String aUserId) {
+ if (!MirGlobal.isUserLoggedIn(anId)) {
+ unlockArticle(anId, aUserId, false);
+ }
+ }
+
+ /**
+ * Locks an article. Forced (that is, without checking wether it's already locked)
+ * if necessary.
+ *
+ * @param anId The article number
+ * @param aUserId The locking user
+ * @param aForce Should it e forced?
+ * @return
+ */
+ public boolean lockArticle(String anId, String aUserId, boolean aForce) {
+ try {
+ String query =
+ "update content set to_locking_user=" + JDBCStringRoutines.escapeStringLiteral(aUserId) +
+ " where id = " + JDBCStringRoutines.escapeStringLiteral(anId);
+
+ if (!aForce)
+ query = query + " and to_locking_user is null";
+
+ return storage.executeUpdate(query) > 0;
+ }
+ catch (Throwable t) {
+ return false;
+ }
+ }
+
+ /**
+ * Unlocks an article. Forced (that is, without checking wether it's locked by
+ * the person that unlocks it) if necessary.
+ *
+ * @param anId The article number
+ * @param aUserId The user that unlocks
+ * @param aForce Should it e forced?
+ * @return <code>true</code> if successfull, <code>false</code> if not
+ */
+ public boolean unlockArticle(String anId, String aUserId, boolean aForce) {
+ try {
+ String query =
+ "update content set to_locking_user=null" +
+ " where id = " + JDBCStringRoutines.escapeStringLiteral(anId);
+
+ if (!aForce)
+ query = query + " and to_locking_user = "+JDBCStringRoutines.escapeStringLiteral(aUserId);
+
+ return storage.executeUpdate(query) > 0;
+ }
+ catch (Throwable t) {
+ return false;
+ }
+ }
+
+ /**
+ * Returns the id of the locking user of an article. <code>null</code> otherwise.
+ *
+ * @param anId
+ * @return
+ */
+ public String queryArticleLock(String anId) {
+ try {
+ String result = storage.executeFreeSingleValueSql("select to_locking_user from content where id = " + JDBCStringRoutines.escapeStringLiteral(anId));
+
+ if (result!=null && !MirGlobal.isUserLoggedIn(result)) {
+ expireArticleLock(anId, result);
+ result = null;
+ }
+
+ return result;
+ }
+ catch (Throwable t) {
+ return null;
+ }
+ }
}