-/*
- * 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.localizer.basic;
-
-import java.util.HashMap;
-import java.util.Iterator;
-import java.util.List;
-import java.util.Map;
-import java.util.Vector;
-
-import mir.config.MirPropertiesConfiguration;
-import mir.entity.Entity;
-import mir.entity.adapter.EntityAdapter;
-import mir.entity.adapter.EntityAdapterDefinition;
-import mir.entity.adapter.EntityAdapterModel;
-import mir.log.LoggerWrapper;
-import mir.media.MediaHelper;
-import mir.media.MirMedia;
-import mir.util.ParameterExpander;
-import mir.util.*;
-import mircoders.entity.EntityUploadedMedia;
-import mircoders.global.MirGlobal;
-import mircoders.localizer.MirAdminInterfaceLocalizer;
-import mircoders.localizer.MirDataModelLocalizer;
-import mircoders.localizer.MirLocalizerExc;
-import mircoders.localizer.MirLocalizerFailure;
-import mircoders.storage.DatabaseArticleType;
-import mircoders.storage.DatabaseAudio;
-import mircoders.storage.DatabaseBreaking;
-import mircoders.storage.*;
-import mircoders.storage.DatabaseCommentStatus;
-import mircoders.storage.DatabaseContent;
-import mircoders.storage.DatabaseImageType;
-import mircoders.storage.DatabaseImages;
-import mircoders.storage.DatabaseLanguage;
-import mircoders.storage.DatabaseMedia;
-import mircoders.storage.DatabaseMediaType;
-import mircoders.storage.DatabaseMediafolder;
-import mircoders.storage.DatabaseMessages;
-import mircoders.storage.DatabaseOther;
-import mircoders.storage.DatabaseTopics;
-import mircoders.storage.DatabaseUploadedMedia;
-import mircoders.storage.DatabaseUsers;
-import mircoders.storage.DatabaseVideo;
-
-public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {
- protected LoggerWrapper logger;
- protected MirPropertiesConfiguration configuration;
-
- public MirBasicDataModelLocalizer() throws MirLocalizerFailure, MirLocalizerExc {
- logger = new LoggerWrapper("Localizer.DataModel");
-
- try {
- configuration = MirPropertiesConfiguration.instance();
- }
- catch (Throwable e) {
- throw new MirLocalizerFailure("Can't get configuration: " + e.getMessage(), e);
- }
- }
-
- protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure, MirLocalizerExc {
- try {
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
- anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");
- anEntityAdapterDefinition.addMirDateField("date", "date");
- anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());
- anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());
- anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());
-
- anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));
- anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));
-
- anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));
- anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new ContentToMediaField( "uploadedMedia", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new ContentToMediaField( "image", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new ContentToMediaField( "audio", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new ContentToMediaField( "video", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new ContentToMediaField( "otherMedia", false));
- anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());
-
- anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());
-
- anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
- anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));
-
- anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());
- anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());
-
- anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Article.PublicUrl")));
-
- anEntityAdapterDefinition.addCalculatedField("operations",
- new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));
- }
- catch (Throwable t) {
- throw new MirLocalizerFailure(t.getMessage(), t);
- }
- }
-
- protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {
- try {
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
- anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());
- anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());
-
- anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new CommentToMediaField( "uploadedMedia" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_images", new CommentToMediaField( "image" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_audio", new CommentToMediaField( "audio" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_video", new CommentToMediaField( "video" ));
- anEntityAdapterDefinition.addCalculatedField("to_media_other", new CommentToMediaField( "otherMedia" ));
- anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new CommentToMediaField( "uploadedMedia", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new CommentToMediaField( "image", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new CommentToMediaField( "audio", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new CommentToMediaField( "video", false));
- anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new CommentToMediaField( "otherMedia", false));
-
- anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Comment.PublicUrl")));
-
- anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
- anEntityAdapterDefinition.addCalculatedField("operations",
- new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));
- }
- catch (Throwable t) {
- throw new MirLocalizerFailure(t.getMessage(), t);
- }
- }
-
- public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc {
- EntityAdapterModel result = new EntityAdapterModel();
-
- try {
- EntityAdapterDefinition definition;
-
- definition = new EntityAdapterDefinition();
- constructContentAdapterDefinition( definition );
- result.addMapping( "content", DatabaseContent.getInstance(), definition);
-
- definition = new EntityAdapterDefinition();
- constructCommentAdapterDefinition( definition );
- result.addMapping( "comment", DatabaseComment.getInstance(), definition);
-
- result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());
-
- definition = new EntityAdapterDefinition();
- definition.addDBDateField("creationdate", "webdb_create");
- result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);
-
- result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "video", DatabaseVideo.getInstance(), new EntityAdapterDefinition());
- result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());
-
- result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition());
-
- }
- catch (Throwable t) {
- throw new MirLocalizerFailure(t.getMessage(), t);
- }
-
- return result;
- }
-
- protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getToOneRelation(
- "id="+anEntityAdapter.get("to_media"),
- "id",
- "content" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getToOneRelation(
- "id="+anEntityAdapter.get("to_comment_status"),
- "id",
- "commentStatus" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {
- private List operations;
-
- public EntityToSimpleOperationsField(List anOperations) {
- operations = anOperations;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- Iterator i = operations.iterator();
- List availableOperations = new Vector();
-
- while (i.hasNext()) {
- MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =
- (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();
-
- if (operation.isAvailable(anEntityAdapter)) {
- availableOperations.add(operation.getName());
- }
- };
-
- return availableOperations;
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class FilteredField implements EntityAdapterDefinition.CalculatedField {
- private String fieldName;
-
- public FilteredField(String aFieldName) {
- fieldName = aFieldName;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {
- return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName));
- }
- else {
- return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName));
- }
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class StructuredContentField implements EntityAdapterDefinition.CalculatedField {
- private String expression;
-
- public StructuredContentField(String anExpression) {
- expression = anExpression;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return StructuredContentParser.parse(ParameterExpander.evaluateStringExpression(anEntityAdapter, expression));
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ExpandedField implements EntityAdapterDefinition.CalculatedField {
- private String expression;
-
- public ExpandedField(String anExpression) {
- expression = anExpression;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return ParameterExpander.expandExpression(anEntityAdapter, expression);
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class EvaluatedField implements EntityAdapterDefinition.CalculatedField {
- private String expression;
-
- public EvaluatedField(String anExpression) {
- expression = anExpression;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return ParameterExpander.evaluateExpression(anEntityAdapter, expression);
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- logger.debug("ContentToParentField.getValue");
- return anEntityAdapter.getToOneRelation(
- "id="+anEntityAdapter.get("to_content"),
- "id",
- "content" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getRelation(
- "to_content="+anEntityAdapter.get("id"),
- "id",
- "content" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getToOneRelation(
- "id="+anEntityAdapter.get("to_language"),
- "id",
- "language" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getToOneRelation(
- "id="+anEntityAdapter.get("to_article_type"),
- "id",
- "articleType" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {
- private String extracondition;
- private String order;
-
- public ContentToCommentsField() {
- this ( " and is_published='1'", "webdb_create");
- }
-
- public ContentToCommentsField(String anExtraCondition, String anOrder) {
- order = anOrder;
- extracondition = anExtraCondition;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return anEntityAdapter.getRelation(
- "to_media="+anEntityAdapter.get("id")+" " + extracondition,
- order,
- "comment" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {
- private String topicCondition;
-
- public ContentToTopicsField() {
- this(null);
- }
-
- public ContentToTopicsField(String aTopicCondition) {
- topicCondition = aTopicCondition;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- String condition = "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)";
- if (topicCondition!=null && topicCondition.length()>0)
- condition = "(" + topicCondition + ") and " + condition;
-
- return anEntityAdapter.getRelation(
- condition,
- "title",
- "topic" );
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {
- private String definition;
- private boolean published;
-
- public ContentToMediaField(String aDefinition, boolean anOnlyPublished) {
- definition = aDefinition;
- published = anOnlyPublished;
- }
-
- public ContentToMediaField(String aDefinition) {
- this(aDefinition, true);
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- String condition = "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)";
- if (published)
- condition = "is_published='t' and " + condition;
- return anEntityAdapter.getRelation(
- condition,
- "id",
- definition);
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class CommentToMediaField implements EntityAdapterDefinition.CalculatedField {
- private String definition;
- private boolean published;
-
- public CommentToMediaField(String aDefinition, boolean anOnlyPublished) {
- definition = aDefinition;
- published = anOnlyPublished;
- }
-
- public CommentToMediaField(String aDefinition) {
- this(aDefinition, true);
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- String condition = "exists (select * from comment_x_media where comment_id="+anEntityAdapter.get("id")+" and media_id=id)";
- if (published)
- condition = "is_published='t' and " + condition;
- return anEntityAdapter.getRelation(
- condition,
- "id",
- definition);
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-
- protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {
- public Object getValue(EntityAdapter anEntityAdapter) {
- EntityAdapter media;
- Entity mediaType;
- RewindableIterator iterator;
- Map result;
- MirMedia mediaHandler;
- String tinyIcon;
- String iconAlt;
-
- try {
- iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));
- iterator.rewind();
-
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText");
- iconAlt = "Text";
-
- if (iterator.hasNext()) {
- media = (EntityAdapter) iterator.next();
-
- mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();
- mediaHandler = MediaHelper.getHandler( mediaType );
-
- if (mediaHandler.isVideo()) {
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyVideo");
- iconAlt = "Video";
- }
- else if (mediaHandler.isAudio()) {
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyAudio");
- iconAlt = "Audio";
- }
- else if (mediaHandler.isImage()) {
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyImage");
- iconAlt = "Image";
- }
- else {
- tinyIcon = mediaHandler.getTinyIconName();
- iconAlt = mediaHandler.getIconAltName();
- }
-
- }
- }
- catch (Throwable t) {
- logger.error("ContentToIconField: " +t.getMessage());
- throw new RuntimeException(t.getMessage());
- }
-
- result = new HashMap();
- result.put("tiny_icon", MirGlobal.config().getString("Producer.ImageRoot") + "/" + tinyIcon);
- result.put("icon_alt", iconAlt);
-
- return result;
- }
- }
-
- protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {
- private String extraCondition;
-
- public ContentCommentCountField(String anExtraCondition) {
- super();
-
- extraCondition = anExtraCondition;
- }
-
- public Object getValue(EntityAdapter anEntityAdapter) {
- try {
- return Integer.toString(
- DatabaseComment.getInstance().getSize(
- "to_media="+anEntityAdapter.get("id")+" " + extraCondition));
- }
- catch (Throwable t) {
- throw new RuntimeException(t.getMessage());
- }
- }
- }
-}
+/*\r
+ * Copyright (C) 2001, 2002 The Mir-coders group\r
+ *\r
+ * This file is part of Mir.\r
+ *\r
+ * Mir is free software; you can redistribute it and/or modify\r
+ * it under the terms of the GNU General Public License as published by\r
+ * the Free Software Foundation; either version 2 of the License, or\r
+ * (at your option) any later version.\r
+ *\r
+ * Mir is distributed in the hope that it will be useful,\r
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of\r
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\r
+ * GNU General Public License for more details.\r
+ *\r
+ * You should have received a copy of the GNU General Public License\r
+ * along with Mir; if not, write to the Free Software\r
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA\r
+ *\r
+ * In addition, as a special exception, The Mir-coders gives permission to link\r
+ * the code of this program with any library licensed under the Apache Software License,\r
+ * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library\r
+ * (or with modified versions of the above that use the same license as the above),\r
+ * and distribute linked combinations including the two. You must obey the\r
+ * GNU General Public License in all respects for all of the code used other than\r
+ * the above mentioned libraries. If you modify this file, you may extend this\r
+ * exception to your version of the file, but you are not obligated to do so.\r
+ * If you do not wish to do so, delete this exception statement from your version.\r
+ */\r
+package mircoders.localizer.basic;\r
+\r
+import java.util.HashMap;\r
+import java.util.Iterator;\r
+import java.util.List;\r
+import java.util.Map;\r
+import java.util.Vector;\r
+\r
+import mir.config.MirPropertiesConfiguration;\r
+import mir.entity.Entity;\r
+import mir.entity.adapter.EntityAdapter;\r
+import mir.entity.adapter.EntityAdapterDefinition;\r
+import mir.entity.adapter.EntityAdapterModel;\r
+import mir.log.LoggerWrapper;\r
+import mir.media.MediaHandler;\r
+import mir.misc.NumberUtils;\r
+import mir.util.ParameterExpander;\r
+import mir.util.RewindableIterator;\r
+import mir.util.StructuredContentParser;\r
+import mircoders.entity.EntityUploadedMedia;\r
+import mircoders.global.MirGlobal;\r
+import mircoders.localizer.MirAdminInterfaceLocalizer;\r
+import mircoders.localizer.MirDataModelLocalizer;\r
+import mircoders.localizer.MirLocalizerExc;\r
+import mircoders.localizer.MirLocalizerFailure;\r
+import mircoders.media.MediaHelper;\r
+import mircoders.module.ModuleContent;\r
+import mircoders.storage.DatabaseArticleType;\r
+import mircoders.storage.DatabaseAudio;\r
+import mircoders.storage.DatabaseBreaking;\r
+import mircoders.storage.DatabaseComment;\r
+import mircoders.storage.DatabaseCommentStatus;\r
+import mircoders.storage.DatabaseContent;\r
+import mircoders.storage.DatabaseContentToMedia;\r
+import mircoders.storage.DatabaseContentToTopics;\r
+import mircoders.storage.DatabaseImageType;\r
+import mircoders.storage.DatabaseImages;\r
+import mircoders.storage.DatabaseLanguage;\r
+import mircoders.storage.DatabaseMediaType;\r
+import mircoders.storage.DatabaseMediafolder;\r
+import mircoders.storage.DatabaseMessages;\r
+import mircoders.storage.DatabaseOther;\r
+import mircoders.storage.DatabaseTopics;\r
+import mircoders.storage.DatabaseUploadedMedia;\r
+import mircoders.storage.DatabaseUsers;\r
+import mircoders.storage.DatabaseVideo;\r
+\r
+public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {\r
+ protected LoggerWrapper logger;\r
+ protected MirPropertiesConfiguration configuration;\r
+\r
+ public MirBasicDataModelLocalizer() throws MirLocalizerFailure, MirLocalizerExc {\r
+ logger = new LoggerWrapper("Localizer.DataModel");\r
+\r
+ try {\r
+ configuration = MirPropertiesConfiguration.instance();\r
+ }\r
+ catch (Throwable e) {\r
+ throw new MirLocalizerFailure("Can't get configuration: " + e.getMessage(), e);\r
+ }\r
+ }\r
+\r
+ protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure, MirLocalizerExc {\r
+ try {\r
+ anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange", configuration.getString("Mir.DefaultTimezone"));\r
+ anEntityAdapterDefinition.addMirDateField("date", "date", configuration.getString("Mir.DefaultTimezone"));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("lockinguser", new ContentToUserField("to_locking_user"));\r
+ anEntityAdapterDefinition.addCalculatedField("is_locked", new ContentToIsLockedField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());\r
+ anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());\r
+ anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));\r
+ anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));\r
+\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("mediacount", new ContentMediaCountField("uploaded_media", true));\r
+ anEntityAdapterDefinition.addCalculatedField("fullmediacount", new ContentMediaCountField("uploaded_media", false));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new ContentToMediaField( "uploadedMedia", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new ContentToMediaField( "image", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new ContentToMediaField( "audio", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new ContentToMediaField( "video", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new ContentToMediaField( "otherMedia", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
+ anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());\r
+ anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Article.PublicUrl")));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("operations",\r
+ new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new MirLocalizerFailure(t.getMessage(), t);\r
+ }\r
+ }\r
+\r
+ protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
+ try {\r
+ anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());\r
+ anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new CommentToMediaField( "uploadedMedia" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_images", new CommentToMediaField( "image" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_audio", new CommentToMediaField( "audio" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_video", new CommentToMediaField( "video" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_media_other", new CommentToMediaField( "otherMedia" ));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new CommentToMediaField( "uploadedMedia", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new CommentToMediaField( "image", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new CommentToMediaField( "audio", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new CommentToMediaField( "video", false));\r
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new CommentToMediaField( "otherMedia", false));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Comment.PublicUrl")));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
+ anEntityAdapterDefinition.addCalculatedField("operations",\r
+ new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new MirLocalizerFailure(t.getMessage(), t);\r
+ }\r
+ }\r
+\r
+ public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc {\r
+ EntityAdapterModel result = new EntityAdapterModel();\r
+\r
+ try {\r
+ EntityAdapterDefinition definition;\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ constructContentAdapterDefinition( definition );\r
+ result.addMapping( "content", DatabaseContent.getInstance(), definition);\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ constructCommentAdapterDefinition( definition );\r
+ result.addMapping( "comment", DatabaseComment.getInstance(), definition);\r
+ result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
+\r
+ result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());\r
+\r
+ result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
+\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ result.addMapping( "internalMessage", DatabaseMessages.getInstance(), definition);\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), definition);\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
+ result.addMapping( "image", DatabaseImages.getInstance(), definition);\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
+ result.addMapping( "audio", DatabaseAudio.getInstance(), definition);\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
+ result.addMapping( "video", DatabaseVideo.getInstance(), definition);\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
+ result.addMapping( "otherMedia", DatabaseOther.getInstance(), definition);\r
+\r
+\r
+ result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());\r
+ result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());\r
+ result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());\r
+ result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
+ result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addDBDateField("lastlogindate", "lastlogin", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("structuredProfile", new StructuredContentField("profile"));\r
+ result.addMapping( "user", DatabaseUsers.getInstance(), definition);\r
+\r
+ result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());\r
+\r
+ result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition());\r
+\r
+ }\r
+ catch (Throwable t) {\r
+ throw new MirLocalizerFailure(t.getMessage(), t);\r
+ }\r
+\r
+ return result;\r
+ }\r
+\r
+ protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_media"),\r
+ "id",\r
+ "content" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_comment_status"),\r
+ "id",\r
+ "commentStatus" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {\r
+ private List operations;\r
+\r
+ public EntityToSimpleOperationsField(List anOperations) {\r
+ operations = anOperations;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ Iterator i = operations.iterator();\r
+ List availableOperations = new Vector();\r
+\r
+ while (i.hasNext()) {\r
+ MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =\r
+ (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();\r
+\r
+ if (operation.isAvailable(anEntityAdapter)) {\r
+ availableOperations.add(operation.getName());\r
+ }\r
+ };\r
+\r
+ return availableOperations;\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class FilteredField implements EntityAdapterDefinition.CalculatedField {\r
+ private String fieldName;\r
+\r
+ public FilteredField(String aFieldName) {\r
+ fieldName = aFieldName;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {\r
+ return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName));\r
+ }\r
+ else {\r
+ return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName));\r
+ }\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class StructuredContentField implements EntityAdapterDefinition.CalculatedField {\r
+ private String expression;\r
+\r
+ public StructuredContentField(String anExpression) {\r
+ expression = anExpression;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return StructuredContentParser.parse(ParameterExpander.evaluateStringExpression(anEntityAdapter, expression));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ExpandedField implements EntityAdapterDefinition.CalculatedField {\r
+ private String expression;\r
+\r
+ public ExpandedField(String anExpression) {\r
+ expression = anExpression;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return ParameterExpander.expandExpression(anEntityAdapter, expression);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class EvaluatedField implements EntityAdapterDefinition.CalculatedField {\r
+ private String expression;\r
+\r
+ public EvaluatedField(String anExpression) {\r
+ expression = anExpression;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return ParameterExpander.evaluateExpression(anEntityAdapter, expression);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ logger.debug("ContentToParentField.getFieldValue");\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_content"),\r
+ "id",\r
+ "content" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getRelation(\r
+ "to_content="+anEntityAdapter.get("id"),\r
+ "id",\r
+ "content" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_language"),\r
+ "id",\r
+ "language" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_article_type"),\r
+ "id",\r
+ "articleType" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class MediaToMediaFolderField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id="+anEntityAdapter.get("to_media_folder"),\r
+ "id",\r
+ "mediaFolder" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ public static class MediaInfo {\r
+ private MediaHandler mediaHandler;\r
+\r
+ public MediaInfo(MediaHandler aHandler) {\r
+ mediaHandler = aHandler;\r
+ }\r
+ public String getBigIcon() {\r
+ if (mediaHandler == null)\r
+ return "bla";\r
+ else\r
+ return mediaHandler.getBigIconName();\r
+ }\r
+\r
+ public String getSmallIcon() {\r
+ if (mediaHandler == null)\r
+ return "bla";\r
+ else\r
+ return mediaHandler.getTinyIconName();\r
+ }\r
+\r
+ public String getMediaType() {\r
+ return "";\r
+ }\r
+ }\r
+\r
+ protected class MediaToMediaInfoField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ MediaHandler mediaHandler = MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType());\r
+\r
+ return new MediaInfo(mediaHandler);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class MediaToBigIconField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()).getBigIconName();\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {\r
+ private String extracondition;\r
+ private String order;\r
+\r
+ public ContentToCommentsField() {\r
+ this ( " and is_published='1'", "webdb_create");\r
+ }\r
+\r
+ public ContentToCommentsField(String anExtraCondition, String anOrder) {\r
+ order = anOrder;\r
+ extracondition = anExtraCondition;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getRelation(\r
+ "to_media="+anEntityAdapter.get("id")+" " + extracondition,\r
+ order,\r
+ "comment" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {\r
+ private String topicCondition;\r
+ private String topicOrder;\r
+\r
+ public ContentToTopicsField() {\r
+ this(null);\r
+ }\r
+\r
+ public ContentToTopicsField(String aTopicCondition) {\r
+ this(aTopicCondition, "title");\r
+ }\r
+\r
+ public ContentToTopicsField(String aTopicCondition, String aTopicOrder) {\r
+ topicCondition = aTopicCondition;\r
+ topicOrder = aTopicOrder;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+\r
+ Vector extraTable = new Vector();\r
+ extraTable.add("content_x_topic cxt");\r
+ String condition = "cxt.content_id="+anEntityAdapter.get("id")+\r
+ " and cxt.topic_id=t.id";\r
+\r
+ if (topicCondition!=null && topicCondition.length()>0)\r
+ condition = "(" + topicCondition + ") and " + condition;\r
+\r
+ return anEntityAdapter.getComplexRelation("t", extraTable,\r
+ condition, topicOrder, "topic" );\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {\r
+ private String definition;\r
+ private boolean published;\r
+\r
+ public ContentToMediaField(String aDefinition, boolean anOnlyPublished) {\r
+ definition = aDefinition;\r
+ published = anOnlyPublished;\r
+ }\r
+\r
+ public ContentToMediaField(String aDefinition) {\r
+ this(aDefinition, true);\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ String condition = "cxm.content_id="+ anEntityAdapter.get("id") +\r
+ " and cxm.media_id = m.id";\r
+ if (published)\r
+ condition = "is_published='t' and " + condition;\r
+\r
+ List extraTables = new Vector();\r
+ extraTables.add("content_x_media cxm");\r
+\r
+ return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class CommentToMediaField implements EntityAdapterDefinition.CalculatedField {\r
+ private String definition;\r
+ private boolean published;\r
+\r
+ public CommentToMediaField(String aDefinition, boolean anOnlyPublished) {\r
+ definition = aDefinition;\r
+ published = anOnlyPublished;\r
+ }\r
+\r
+ public CommentToMediaField(String aDefinition) {\r
+ this(aDefinition, true);\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+\r
+ String condition = "cxm.comment_id="+ anEntityAdapter.get("id") +\r
+ " and cxm.media_id = m.id";\r
+ if (published)\r
+ condition = "is_published='t' and " + condition;\r
+\r
+ List extraTables = new Vector();\r
+ extraTables.add("comment_x_media cxm");\r
+ return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition);\r
+\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ EntityAdapter media;\r
+ Entity mediaType;\r
+ RewindableIterator iterator;\r
+ Map result;\r
+ MediaHandler mediaHandler;\r
+ String tinyIcon;\r
+ String iconAlt;\r
+\r
+ try {\r
+ iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));\r
+ iterator.rewind();\r
+\r
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText");\r
+ iconAlt = "Text";\r
+\r
+ if (iterator.hasNext()) {\r
+ media = (EntityAdapter) iterator.next();\r
+\r
+ mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();\r
+ mediaHandler = MediaHelper.getHandler( mediaType );\r
+\r
+ tinyIcon = mediaHandler.getTinyIconName();\r
+ iconAlt = mediaHandler.getIconAltName();\r
+ }\r
+ }\r
+ catch (Throwable t) {\r
+ logger.error("ContentToIconField: " +t.getMessage());\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+\r
+ result = new HashMap();\r
+ result.put("tiny_icon", MirGlobal.config().getString("Producer.ImageRoot") + "/" + tinyIcon);\r
+ result.put("icon_alt", iconAlt);\r
+\r
+ return result;\r
+ }\r
+ }\r
+\r
+ protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {\r
+ private String extraCondition;\r
+\r
+ public ContentCommentCountField(String anExtraCondition) {\r
+ super();\r
+\r
+ extraCondition = anExtraCondition;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return Integer.toString(\r
+ DatabaseComment.getInstance().getSize(\r
+ "to_media="+anEntityAdapter.get("id")+" " + extraCondition));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class HumanReadableSizeField implements EntityAdapterDefinition.CalculatedField {\r
+ private String fieldName;\r
+\r
+ public HumanReadableSizeField(String aFieldName) {\r
+ fieldName= aFieldName;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ String size = (String) anEntityAdapter.get(fieldName);\r
+ if (size!=null)\r
+ return NumberUtils.humanReadableSize(Double.parseDouble(size));\r
+ else\r
+ return "";\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+\r
+ protected class ContentMediaCountField implements EntityAdapterDefinition.CalculatedField {\r
+ private String table;\r
+ private boolean published;\r
+\r
+ public ContentMediaCountField(String aTable, boolean anOnlyPublished) {\r
+ table = aTable;\r
+ published = anOnlyPublished;\r
+ }\r
+\r
+ public ContentMediaCountField(String aTable) {\r
+ this(aTable, true);\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ Vector extraTable = new Vector();\r
+ extraTable.add(table+" m");\r
+ String selectSql = "cxm.media_id=m.id and cxm.content_id="+\r
+ anEntityAdapter.get("id");\r
+ if (published)\r
+ selectSql+= " and m.is_published='t'";\r
+\r
+ return Integer.toString(\r
+ DatabaseContentToMedia.getInstance().getSize(\r
+ "cxm", extraTable, selectSql));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToUserField implements EntityAdapterDefinition.CalculatedField {\r
+ private String fieldName;\r
+\r
+ public ContentToUserField(String aFieldName) {\r
+ fieldName = aFieldName;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id=" + anEntityAdapter.get(fieldName),\r
+ "id",\r
+ "user");\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToIsLockedField implements EntityAdapterDefinition.CalculatedField {\r
+ private ModuleContent contentModule;\r
+\r
+ public ContentToIsLockedField() {\r
+ contentModule = new ModuleContent(DatabaseContent.getInstance());\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return new Boolean(contentModule.queryArticleLock(anEntityAdapter.getEntity().getId())!=null);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+}\r