X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Flocalizer%2Fbasic%2FMirBasicDataModelLocalizer.java;h=e3d2d17231e522e656f527088b2c1ad19b636336;hb=6874c3a58e85fdb9ebf216d4c09eb466bda6f4f7;hp=d65cd234fd8d761725e0f32d69e2b1b55eceeb6c;hpb=62f2f914058c39865ff038e6281b045b05f598cb;p=mir.git diff --git a/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java b/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java index d65cd234..e3d2d172 100755 --- a/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java +++ b/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java @@ -1,5 +1,5 @@ /* - * Copyright (C) 2001, 2002 The Mir-coders group + * Copyright (C) 2001, 2002 The Mir-coders group * * This file is part of Mir. * @@ -18,63 +18,121 @@ * 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. + * 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.*; -import mir.entity.*; -import mir.entity.adapter.*; -import mir.media.*; -import mir.misc.*; -import mir.util.*; -import mircoders.storage.*; -import mircoders.global.*; -import mircoders.entity.*; -import mircoders.localizer.*; +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.MediaHandler; +import mir.misc.NumberUtils; +import mir.util.ParameterExpander; +import mir.util.RewindableIterator; +import mir.util.StructuredContentParser; +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.media.MediaHelper; +import mircoders.module.ModuleContent; +import mircoders.storage.DatabaseArticleType; +import mircoders.storage.DatabaseAudio; +import mircoders.storage.DatabaseBreaking; +import mircoders.storage.DatabaseComment; +import mircoders.storage.DatabaseCommentStatus; +import mircoders.storage.DatabaseContent; +import mircoders.storage.DatabaseContentToMedia; +import mircoders.storage.DatabaseContentToTopics; +import mircoders.storage.DatabaseImageType; +import mircoders.storage.DatabaseImages; +import mircoders.storage.DatabaseLanguage; +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 { - private EntityAdapterModel model; + protected LoggerWrapper logger; + protected MirPropertiesConfiguration configuration; + + public MirBasicDataModelLocalizer() throws MirLocalizerFailure, MirLocalizerExc { + logger = new LoggerWrapper("Localizer.DataModel"); - public MirBasicDataModelLocalizer() { + try { + configuration = MirPropertiesConfiguration.instance(); + } + catch (Throwable e) { + throw new MirLocalizerFailure("Can't get configuration: " + e.getMessage(), e); + } } - public EntityAdapterModel adapterModel() throws MirLocalizerFailure { - if (model==null) - model = buildModel(); + protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure, MirLocalizerExc { + try { + anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange", configuration.getString("Mir.DefaultTimezone")); + anEntityAdapterDefinition.addMirDateField("date", "date", configuration.getString("Mir.DefaultTimezone")); - return model; - }; + anEntityAdapterDefinition.addCalculatedField("lockinguser", new ContentToUserField("to_locking_user")); + anEntityAdapterDefinition.addCalculatedField("is_locked", new ContentToIsLockedField()); - protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure { - 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("mediacount", new ContentMediaCountField("uploaded_media", true)); + anEntityAdapterDefinition.addCalculatedField("fullmediacount", new ContentMediaCountField("uploaded_media", false)); - anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" )); 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); @@ -83,18 +141,33 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure { try { - anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create"); + anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); 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 CommentToOperationsField()); + anEntityAdapterDefinition.addCalculatedField("operations", + new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations())); } catch (Throwable t) { throw new MirLocalizerFailure(t.getMessage(), t); } } - protected EntityAdapterModel buildModel() throws MirLocalizerFailure { + public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc { EntityAdapterModel result = new EntityAdapterModel(); try { @@ -107,27 +180,73 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { definition = new EntityAdapterDefinition(); constructCommentAdapterDefinition( definition ); result.addMapping( "comment", DatabaseComment.getInstance(), definition); + result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition()); result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition()); + result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition()); + + definition = new EntityAdapterDefinition(); - definition.addDBDateField("creationdate", "webdb_create"); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition); - result.addMapping( "feature", DatabaseFeature.getInstance(), new EntityAdapterDefinition()); + definition = new EntityAdapterDefinition(); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + result.addMapping( "internalMessage", DatabaseMessages.getInstance(), definition); + + definition = new EntityAdapterDefinition(); + definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), definition); + definition = new EntityAdapterDefinition(); + definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); + result.addMapping( "image", DatabaseImages.getInstance(), definition); + definition = new EntityAdapterDefinition(); + definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); + result.addMapping( "audio", DatabaseAudio.getInstance(), definition); + definition = new EntityAdapterDefinition(); + definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); + result.addMapping( "video", DatabaseVideo.getInstance(), definition); + definition = new EntityAdapterDefinition(); + definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); + result.addMapping( "otherMedia", DatabaseOther.getInstance(), definition); + + + result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition()); 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()); + + definition = new EntityAdapterDefinition(); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addDBDateField("lastlogindate", "lastlogin", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("structuredProfile", new StructuredContentField("profile")); + result.addMapping( "user", DatabaseUsers.getInstance(), definition); + 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); @@ -150,21 +269,38 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } - protected class CommentToOperationsField implements EntityAdapterDefinition.CalculatedField { + 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 { - Map operations = MirGlobal.localizer().adminInterface().simpleCommentOperations(); - Iterator i = operations.entrySet().iterator(); + Iterator i = operations.iterator(); List availableOperations = new Vector(); while (i.hasNext()) { - Map.Entry entry = (Map.Entry) i.next(); - MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation = - (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) entry.getValue(); + (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next(); if (operation.isAvailable(anEntityAdapter)) { - availableOperations.add(entry.getKey()); + availableOperations.add(operation.getName()); } }; @@ -177,7 +313,7 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } protected class FilteredField implements EntityAdapterDefinition.CalculatedField { - String fieldName; + private String fieldName; public FilteredField(String aFieldName) { fieldName = aFieldName; @@ -186,10 +322,10 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { public Object getValue(EntityAdapter anEntityAdapter) { try { if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) { - return anEntityAdapter.get(fieldName); + return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName)); } else { - return MirGlobal.localizer().producerAssistant().filterText((String) anEntityAdapter.get(fieldName)); + return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName)); } } catch (Throwable t) { @@ -198,6 +334,86 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } + 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.getFieldValue"); + 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 { @@ -212,12 +428,101 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } + 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 MediaToMediaFolderField implements EntityAdapterDefinition.CalculatedField { + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return anEntityAdapter.getToOneRelation( + "id="+anEntityAdapter.get("to_media_folder"), + "id", + "mediaFolder" ); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + public static class MediaInfo { + private MediaHandler mediaHandler; + + public MediaInfo(MediaHandler aHandler) { + mediaHandler = aHandler; + } + public String getBigIcon() { + if (mediaHandler == null) + return "bla"; + else + return mediaHandler.getBigIconName(); + } + + public String getSmallIcon() { + if (mediaHandler == null) + return "bla"; + else + return mediaHandler.getTinyIconName(); + } + + public String getMediaType() { + return ""; + } + } + + protected class MediaToMediaInfoField implements EntityAdapterDefinition.CalculatedField { + public Object getValue(EntityAdapter anEntityAdapter) { + try { + MediaHandler mediaHandler = MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()); + + return new MediaInfo(mediaHandler); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class MediaToBigIconField implements EntityAdapterDefinition.CalculatedField { + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()).getBigIconName(); + } + 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")+" and is_published='1'", - "webdb_create", + "to_media="+anEntityAdapter.get("id")+" " + extracondition, + order, "comment" ); } catch (Throwable t) { @@ -227,12 +532,35 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField { + private String topicCondition; + private String topicOrder; + + public ContentToTopicsField() { + this(null); + } + + public ContentToTopicsField(String aTopicCondition) { + this(aTopicCondition, "title"); + } + + public ContentToTopicsField(String aTopicCondition, String aTopicOrder) { + topicCondition = aTopicCondition; + topicOrder = aTopicOrder; + } + public Object getValue(EntityAdapter anEntityAdapter) { try { - return anEntityAdapter.getRelation( - "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)", - "title", - "topic" ); + + Vector extraTable = new Vector(); + extraTable.add("content_x_topic cxt"); + String condition = "cxt.content_id="+anEntityAdapter.get("id")+ + " and cxt.topic_id=t.id"; + + if (topicCondition!=null && topicCondition.length()>0) + condition = "(" + topicCondition + ") and " + condition; + + return anEntityAdapter.getComplexRelation("t", extraTable, + condition, topicOrder, "topic" ); } catch (Throwable t) { throw new RuntimeException(t.getMessage()); @@ -241,18 +569,61 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField { - String definition; + 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 = "cxm.content_id="+ anEntityAdapter.get("id") + + " and cxm.media_id = m.id"; + if (published) + condition = "is_published='t' and " + condition; + + List extraTables = new Vector(); + extraTables.add("content_x_media cxm"); + + return anEntityAdapter.getComplexRelation("m", extraTables, 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 { - return anEntityAdapter.getRelation( - "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)", - "title", - definition); + + String condition = "cxm.comment_id="+ anEntityAdapter.get("id") + + " and cxm.media_id = m.id"; + if (published) + condition = "is_published='t' and " + condition; + + List extraTables = new Vector(); + extraTables.add("comment_x_media cxm"); + return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition); + } catch (Throwable t) { throw new RuntimeException(t.getMessage()); @@ -266,7 +637,7 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { Entity mediaType; RewindableIterator iterator; Map result; - MirMedia mediaHandler; + MediaHandler mediaHandler; String tinyIcon; String iconAlt; @@ -274,7 +645,7 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media")); iterator.rewind(); - tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyText"); + tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText"); iconAlt = "Text"; if (iterator.hasNext()) { @@ -283,38 +654,23 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType(); mediaHandler = MediaHelper.getHandler( mediaType ); - if (mediaHandler.isVideo()) { - tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyVideo"); - iconAlt = "Video"; - } - else if (mediaHandler.isAudio()) { - tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyAudio"); - iconAlt = "Audio"; - } - else if (mediaHandler.isImage()) { - tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyImage"); - iconAlt = "Image"; - } - else { - tinyIcon = mediaHandler.getTinyIconName(); - iconAlt = mediaHandler.getIconAltName(); - } - + tinyIcon = mediaHandler.getTinyIconName(); + iconAlt = mediaHandler.getIconAltName(); } } catch (Throwable t) { - System.out.println("ContentToIconField: exception: " +t.getMessage()); - t.printStackTrace(System.out); + logger.error("ContentToIconField: " +t.getMessage()); throw new RuntimeException(t.getMessage()); } result = new HashMap(); - result.put("tiny_icon", MirGlobal.getConfigProperty("Producer.ImageRoot") + "/" + tinyIcon); + 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; @@ -335,4 +691,95 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } } + + protected class HumanReadableSizeField implements EntityAdapterDefinition.CalculatedField { + private String fieldName; + + public HumanReadableSizeField(String aFieldName) { + fieldName= aFieldName; + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + String size = (String) anEntityAdapter.get(fieldName); + if (size!=null) + return NumberUtils.humanReadableSize(Double.parseDouble(size)); + else + return ""; + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + + protected class ContentMediaCountField implements EntityAdapterDefinition.CalculatedField { + private String table; + private boolean published; + + public ContentMediaCountField(String aTable, boolean anOnlyPublished) { + table = aTable; + published = anOnlyPublished; + } + + public ContentMediaCountField(String aTable) { + this(aTable, true); + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + Vector extraTable = new Vector(); + extraTable.add(table+" m"); + String selectSql = "cxm.media_id=m.id and cxm.content_id="+ + anEntityAdapter.get("id"); + if (published) + selectSql+= " and m.is_published='t'"; + + return Integer.toString( + DatabaseContentToMedia.getInstance().getSize( + "cxm", extraTable, selectSql)); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class ContentToUserField implements EntityAdapterDefinition.CalculatedField { + private String fieldName; + + public ContentToUserField(String aFieldName) { + fieldName = aFieldName; + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return anEntityAdapter.getToOneRelation( + "id=" + anEntityAdapter.get(fieldName), + "id", + "user"); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class ContentToIsLockedField implements EntityAdapterDefinition.CalculatedField { + private ModuleContent contentModule; + + public ContentToIsLockedField() { + contentModule = new ModuleContent(DatabaseContent.getInstance()); + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return new Boolean(contentModule.queryArticleLock(anEntityAdapter.getEntity().getId())!=null); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } }