/*\r
- * Copyright (C) 2001, 2002 The Mir-coders group\r
+ * Copyright (C) 2001, 2002 The Mir-coders group\r
*\r
* This file is part of Mir.\r
*\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 the com.oreilly.servlet library, any library\r
- * licensed under the Apache Software License, The Sun (tm) Java Advanced\r
- * Imaging library (JAI), The Sun JIMI library (or with modified versions of\r
- * the above that use the same license as the above), and distribute linked\r
- * combinations including the two. You must obey the GNU General Public\r
- * License in all respects for all of the code used other than the above\r
- * mentioned libraries. If you modify this file, you may extend this exception\r
- * to your version of the file, but you are not obligated to do so. If you do\r
- * not wish to do so, delete this exception statement from your version.\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
-\r
package mircoders.localizer.basic;\r
\r
import java.util.HashMap;\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.MediaHelper;\r
-import mir.media.MirMedia;\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.DatabaseMedia;\r
import mircoders.storage.DatabaseMediaType;\r
import mircoders.storage.DatabaseMediafolder;\r
import mircoders.storage.DatabaseMessages;\r
import mircoders.storage.DatabaseVideo;\r
\r
public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {\r
- private EntityAdapterModel model;\r
protected LoggerWrapper logger;\r
+ protected MirPropertiesConfiguration configuration;\r
\r
- public MirBasicDataModelLocalizer() {\r
- model=null;\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
- public EntityAdapterModel adapterModel() throws MirLocalizerFailure {\r
- if (model==null)\r
- model = buildModel();\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
- return model;\r
- };\r
+ anEntityAdapterDefinition.addCalculatedField("lockinguser", new ContentToUserField("to_locking_user"));\r
+ anEntityAdapterDefinition.addCalculatedField("is_locked", new ContentToIsLockedField());\r
\r
- protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
- try {\r
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\r
- anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");\r
- anEntityAdapterDefinition.addMirDateField("date", "date");\r
anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());\r
anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());\r
anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());\r
anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));\r
anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));\r
\r
- anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));\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
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
\r
protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
try {\r
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\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
}\r
\r
- protected EntityAdapterModel buildModel() throws MirLocalizerFailure {\r
+ public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc {\r
EntityAdapterModel result = new EntityAdapterModel();\r
\r
try {\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
- result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
+\r
+ result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
+\r
\r
definition = new EntityAdapterDefinition();\r
- definition.addDBDateField("creationdate", "webdb_create");\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( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());\r
result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());\r
result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "video", DatabaseVideo.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
protected class FilteredField implements EntityAdapterDefinition.CalculatedField {\r
- String fieldName;\r
+ private String fieldName;\r
\r
public FilteredField(String aFieldName) {\r
fieldName = aFieldName;\r
public Object getValue(EntityAdapter anEntityAdapter) {\r
try {\r
if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {\r
- return anEntityAdapter.get(fieldName);\r
+ return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName));\r
}\r
else {\r
- return MirGlobal.localizer().producerAssistant().filterText((String) anEntityAdapter.get(fieldName));\r
+ return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName));\r
}\r
}\r
catch (Throwable t) {\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.getValue");\r
+ logger.debug("ContentToParentField.getFieldValue");\r
return anEntityAdapter.getToOneRelation(\r
"id="+anEntityAdapter.get("to_content"),\r
"id",\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")+" and is_published='1'",\r
- "webdb_create",\r
+ "to_media="+anEntityAdapter.get("id")+" " + extracondition,\r
+ order,\r
"comment" );\r
}\r
catch (Throwable t) {\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
- return anEntityAdapter.getRelation(\r
- "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)",\r
- "title",\r
- "topic" );\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
protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {\r
- String definition;\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
- return anEntityAdapter.getRelation(\r
- "is_published='t' and exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)",\r
- "id",\r
- definition);\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
Entity mediaType;\r
RewindableIterator iterator;\r
Map result;\r
- MirMedia mediaHandler;\r
+ MediaHandler mediaHandler;\r
String tinyIcon;\r
String iconAlt;\r
\r
iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));\r
iterator.rewind();\r
\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyText");\r
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText");\r
iconAlt = "Text";\r
\r
if (iterator.hasNext()) {\r
mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();\r
mediaHandler = MediaHelper.getHandler( mediaType );\r
\r
- if (mediaHandler.isVideo()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyVideo");\r
- iconAlt = "Video";\r
- }\r
- else if (mediaHandler.isAudio()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyAudio");\r
- iconAlt = "Audio";\r
- }\r
- else if (mediaHandler.isImage()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyImage");\r
- iconAlt = "Image";\r
- }\r
- else {\r
- tinyIcon = mediaHandler.getTinyIconName();\r
- iconAlt = mediaHandler.getIconAltName();\r
- }\r
-\r
+ tinyIcon = mediaHandler.getTinyIconName();\r
+ iconAlt = mediaHandler.getIconAltName();\r
}\r
}\r
catch (Throwable t) {\r
}\r
\r
result = new HashMap();\r
- result.put("tiny_icon", MirGlobal.getConfigProperty("Producer.ImageRoot") + "/" + tinyIcon);\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
+\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