Index: lams_common/src/java/org/lamsfoundation/lams/notebook/dao/INotebookEntryDAO.java =================================================================== diff -u -r03abda6aa87eacaaab4f2ffa4fdd2daa98bebf87 -r665317d0c907b053cec7f56ac36305eb09dac446 --- lams_common/src/java/org/lamsfoundation/lams/notebook/dao/INotebookEntryDAO.java (.../INotebookEntryDAO.java) (revision 03abda6aa87eacaaab4f2ffa4fdd2daa98bebf87) +++ lams_common/src/java/org/lamsfoundation/lams/notebook/dao/INotebookEntryDAO.java (.../INotebookEntryDAO.java) (revision 665317d0c907b053cec7f56ac36305eb09dac446) @@ -33,8 +33,12 @@ void saveOrUpdate(NotebookEntry nb); - List get(String id, Long idType, Long userID); - NotebookEntry get(Long uid); + List get(Integer userID); + + List get(Integer userID, Long lessonID); + + List get(String id, Long idType, String signature, + Integer userID); } Index: lams_common/src/java/org/lamsfoundation/lams/notebook/dao/hibernate/NotebookEntryDAO.java =================================================================== diff -u -r6892d4ce77f9b47488a097d6b9985e9cff3b22cb -r665317d0c907b053cec7f56ac36305eb09dac446 --- lams_common/src/java/org/lamsfoundation/lams/notebook/dao/hibernate/NotebookEntryDAO.java (.../NotebookEntryDAO.java) (revision 6892d4ce77f9b47488a097d6b9985e9cff3b22cb) +++ lams_common/src/java/org/lamsfoundation/lams/notebook/dao/hibernate/NotebookEntryDAO.java (.../NotebookEntryDAO.java) (revision 665317d0c907b053cec7f56ac36305eb09dac446) @@ -36,13 +36,16 @@ public static final String SQL_QUERY_FIND_ENTRY_BY_EXTERNAL_ID = "from " + NotebookEntry.class.getName() + " where external_id=? and external_id_type=? and user_id=?"; + public static final String SQL_QUERY_FIND_ENTRY_BY_USER_ID = "from " + NotebookEntry.class.getName() + + " where user_id=?"; + public void saveOrUpdate(NotebookEntry notebookEntry) { this.getHibernateTemplate().saveOrUpdate(notebookEntry); this.getHibernateTemplate().flush(); } - public List get(String id, Long idType, Long userID) { - return getHibernateTemplate().find(SQL_QUERY_FIND_ENTRY_BY_EXTERNAL_ID, new Object[]{id, idType, userID}); + public List get(String id, Long idType, String signature, Integer userID) { + return (List)(getHibernateTemplate().find(SQL_QUERY_FIND_ENTRY_BY_EXTERNAL_ID, new Object[]{id, idType, signature, userID})); } public NotebookEntry get(Long uid) { @@ -53,4 +56,13 @@ return null; } } + + public List get(Integer userID) { + return (List)(getHibernateTemplate().find(SQL_QUERY_FIND_ENTRY_BY_USER_ID, userID)); + } + + public List get(Integer userID, Long lessonID) { + // TODO need to write hql query for lessionID and userID + return null; + } } Index: lams_common/src/java/org/lamsfoundation/lams/notebook/service/CoreNotebookService.java =================================================================== diff -u -r6de3862488bb70913c5ec5a8ff2aa43853295a13 -r665317d0c907b053cec7f56ac36305eb09dac446 --- lams_common/src/java/org/lamsfoundation/lams/notebook/service/CoreNotebookService.java (.../CoreNotebookService.java) (revision 6de3862488bb70913c5ec5a8ff2aa43853295a13) +++ lams_common/src/java/org/lamsfoundation/lams/notebook/service/CoreNotebookService.java (.../CoreNotebookService.java) (revision 665317d0c907b053cec7f56ac36305eb09dac446) @@ -36,7 +36,7 @@ import org.lamsfoundation.lams.util.MessageService; -public class CoreNotebookService implements ICoreNotebookService { +public class CoreNotebookService implements ICoreNotebookService, IExtendedCoreNotebookService{ private static Logger log = Logger.getLogger(CoreNotebookService.class); @@ -53,16 +53,18 @@ return notebookEntry.getUid(); } - public List getEntry(String id, Long idType, Long userID) { - List list = notebookEntryDAO.get(id, idType, userID); - List notebookEntries = new ArrayList(); - for (Iterator iter = list.iterator(); iter.hasNext();) { - NotebookEntry element = (NotebookEntry) iter.next(); - notebookEntries.add(element); - } - return notebookEntries; + public List getEntry(String id, Long idType, String signature, Integer userID) { + return notebookEntryDAO.get(id, idType, signature, userID); } + public List getEntry(Integer userID) { + return notebookEntryDAO.get(userID); + } + + public List getEntry(Integer userID, Long lessonID) { + return notebookEntryDAO.get(userID, lessonID); + } + public NotebookEntry getEntry(Long uid) { return notebookEntryDAO.get(uid); } Index: lams_common/src/java/org/lamsfoundation/lams/notebook/service/ICoreNotebookService.java =================================================================== diff -u -r28cb89c7a2c83239db0370b3911eee3195de4f23 -r665317d0c907b053cec7f56ac36305eb09dac446 --- lams_common/src/java/org/lamsfoundation/lams/notebook/service/ICoreNotebookService.java (.../ICoreNotebookService.java) (revision 28cb89c7a2c83239db0370b3911eee3195de4f23) +++ lams_common/src/java/org/lamsfoundation/lams/notebook/service/ICoreNotebookService.java (.../ICoreNotebookService.java) (revision 665317d0c907b053cec7f56ac36305eb09dac446) @@ -35,7 +35,7 @@ Long createNotebookEntry(Long id, Integer idType, String signature, Integer userID, String title, String entry); - List getEntry(String id, Long idType, Long userID); + List getEntry(String id, Long idType, String signature, Integer userID); NotebookEntry getEntry(Long uid);