ImageComment
.
*
@@ -31,5 +36,13 @@
*/
public interface ImageCommentDAO extends DAO {
+ /**
+ * Return imageComment by the given commentUid.
+ *
+ * @param commentUid
+ * @param userId
+ * @return
+ */
+ public ImageComment getCommentByUid(Long commentUid);
+
}
-
\ No newline at end of file
Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/ImageGalleryUserDAO.java
===================================================================
diff -u -r8a7c47632a6a93892f015f068d12adb376c0ae2d -ree0608cfdaec0a5cc246ac316091712268491fc6
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/ImageGalleryUserDAO.java (.../ImageGalleryUserDAO.java) (revision 8a7c47632a6a93892f015f068d12adb376c0ae2d)
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/ImageGalleryUserDAO.java (.../ImageGalleryUserDAO.java) (revision ee0608cfdaec0a5cc246ac316091712268491fc6)
@@ -34,4 +34,6 @@
ImageGalleryUser getUserByUserIDAndContentID(Long userId, Long contentId);
ListImageCommentDAO
.
*
* @author Andrey Balan
* @see org.lamsfoundation.lams.tool.imageGallery.dao.ImageCommentDAO
*/
-public class ImageCommentDAOHibernate extends BaseDAOHibernate implements ImageCommentDAO{
+public class ImageCommentDAOHibernate extends BaseDAOHibernate implements ImageCommentDAO {
+ private static final String FIND_BY_UID = "from " + ImageComment.class.getName()
+ + " as r where r.uid = ?";
+ public ImageComment getCommentByUid(Long commentUid) {
+ List list = getHibernateTemplate().find(FIND_BY_UID, commentUid);
+ if (list == null || list.size() == 0)
+ return null;
+ return (ImageComment) list.get(0);
+ }
+
}
-
\ No newline at end of file
Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryItemVisitDAOHibernate.java
===================================================================
diff -u -r5d9ada1b3b139591dc6f1fffec04990beb727522 -ree0608cfdaec0a5cc246ac316091712268491fc6
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryItemVisitDAOHibernate.java (.../ImageGalleryItemVisitDAOHibernate.java) (revision 5d9ada1b3b139591dc6f1fffec04990beb727522)
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryItemVisitDAOHibernate.java (.../ImageGalleryItemVisitDAOHibernate.java) (revision ee0608cfdaec0a5cc246ac316091712268491fc6)
@@ -48,7 +48,7 @@
+ ImageGallery.class.getName() + " as r " + " where v.sessionId = s.sessionId "
+ " and s.imageGallery.uid = r.uid " + " and r.contentId =? "
+ " group by v.sessionId, v.imageGalleryItem.uid ";
-
+
public ImageGalleryItemVisitLog getImageGalleryItemLog(Long itemUid, Long userId) {
List list = getHibernateTemplate().find(FIND_BY_ITEM_AND_USER, new Object[] { userId, itemUid });
if (list == null || list.size() == 0)
Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryUserDAOHibernate.java
===================================================================
diff -u -r8a7c47632a6a93892f015f068d12adb376c0ae2d -ree0608cfdaec0a5cc246ac316091712268491fc6
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryUserDAOHibernate.java (.../ImageGalleryUserDAOHibernate.java) (revision 8a7c47632a6a93892f015f068d12adb376c0ae2d)
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dao/hibernate/ImageGalleryUserDAOHibernate.java (.../ImageGalleryUserDAOHibernate.java) (revision ee0608cfdaec0a5cc246ac316091712268491fc6)
@@ -28,30 +28,40 @@
import org.lamsfoundation.lams.tool.imageGallery.dao.ImageGalleryUserDAO;
import org.lamsfoundation.lams.tool.imageGallery.model.ImageGalleryUser;
+public class ImageGalleryUserDAOHibernate extends BaseDAOHibernate implements ImageGalleryUserDAO {
-public class ImageGalleryUserDAOHibernate extends BaseDAOHibernate implements ImageGalleryUserDAO{
-
- private static final String FIND_BY_USER_ID_CONTENT_ID = "from " + ImageGalleryUser.class.getName() + " as u where u.userId =? and u.imageGallery.contentId=?";
- private static final String FIND_BY_USER_ID_SESSION_ID = "from " + ImageGalleryUser.class.getName() + " as u where u.userId =? and u.session.sessionId=?";
- private static final String FIND_BY_SESSION_ID = "from " + ImageGalleryUser.class.getName() + " as u where u.session.sessionId=?";
+ private static final String FIND_BY_USER_ID_CONTENT_ID = "from " + ImageGalleryUser.class.getName()
+ + " as u where u.userId =? and u.imageGallery.contentId=?";
+ private static final String FIND_BY_USER_ID_SESSION_ID = "from " + ImageGalleryUser.class.getName()
+ + " as u where u.userId =? and u.session.sessionId=?";
+ private static final String FIND_BY_SESSION_ID = "from " + ImageGalleryUser.class.getName()
+ + " as u where u.session.sessionId=?";
+ private static final String FIND_COUNT_OF_VOTES = "select count(*) from "
+ + ImageGalleryUser.class.getName() + " as u where u.votedImageUid =? and u.session.sessionId=?";
- public ImageGalleryUser getUserByUserIDAndSessionID(Long userID, Long sessionId) {
- List list = this.getHibernateTemplate().find(FIND_BY_USER_ID_SESSION_ID,new Object[]{userID,sessionId});
- if(list == null || list.size() == 0)
- return null;
- return (ImageGalleryUser) list.get(0);
- }
+ public ImageGalleryUser getUserByUserIDAndSessionID(Long userID, Long sessionId) {
+ List list = this.getHibernateTemplate().find(FIND_BY_USER_ID_SESSION_ID, new Object[] { userID, sessionId });
+ if (list == null || list.size() == 0)
+ return null;
+ return (ImageGalleryUser) list.get(0);
+ }
- public ImageGalleryUser getUserByUserIDAndContentID(Long userId, Long contentId) {
- List list = this.getHibernateTemplate().find(FIND_BY_USER_ID_CONTENT_ID,new Object[]{userId,contentId});
- if(list == null || list.size() == 0)
- return null;
- return (ImageGalleryUser) list.get(0);
- }
+ public ImageGalleryUser getUserByUserIDAndContentID(Long userId, Long contentId) {
+ List list = this.getHibernateTemplate().find(FIND_BY_USER_ID_CONTENT_ID, new Object[] { userId, contentId });
+ if (list == null || list.size() == 0)
+ return null;
+ return (ImageGalleryUser) list.get(0);
+ }
- public List