Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040040.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040040.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040040.sql 24 Jan 2015 18:10:55 -0000 1.1 @@ -0,0 +1,12 @@ +-- Turn off autocommit, so nothing is committed if there is an error + +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; + +-- LDEV-3420 Add date column to Gradebook marks +ALTER TABLE lams_gradebook_user_activity ADD COLUMN update_date DATETIME DEFAULT NULL; + +-- If there were no errors, commit and restore autocommit to on +SET FOREIGN_KEY_CHECKS=0; +COMMIT; +SET AUTOCOMMIT = 1; Index: lams_common/src/java/org/lamsfoundation/lams/gradebook/GradebookUserActivity.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/gradebook/GradebookUserActivity.java,v diff -u -r1.2 -r1.3 --- lams_common/src/java/org/lamsfoundation/lams/gradebook/GradebookUserActivity.java 2 Jul 2009 09:55:59 -0000 1.2 +++ lams_common/src/java/org/lamsfoundation/lams/gradebook/GradebookUserActivity.java 24 Jan 2015 18:10:56 -0000 1.3 @@ -23,6 +23,8 @@ /* $Id$ */ package org.lamsfoundation.lams.gradebook; +import java.util.Date; + import org.lamsfoundation.lams.learningdesign.ToolActivity; import org.lamsfoundation.lams.usermanagement.User; @@ -41,15 +43,18 @@ private Double mark; private String feedback; private Boolean markedInGradebook; + private Date updateDate; public GradebookUserActivity() { markedInGradebook = false; + updateDate = new Date(); } public GradebookUserActivity(ToolActivity activity, User learner){ this.activity = activity; this.learner = learner; markedInGradebook = false; + updateDate = new Date(); } /** @@ -120,5 +125,15 @@ this.markedInGradebook = markedInGradebook; } - + /** + * @hibernate.property column="update_date" + * @return + */ + public Date getUpdateDate() { + return updateDate; + } + + public void setUpdateDate(Date updateDate) { + this.updateDate = updateDate; + } } Index: lams_common/src/java/org/lamsfoundation/lams/learningdesign/ToolActivity.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/learningdesign/ToolActivity.java,v diff -u -r1.44 -r1.45 --- lams_common/src/java/org/lamsfoundation/lams/learningdesign/ToolActivity.java 22 Apr 2014 19:44:46 -0000 1.44 +++ lams_common/src/java/org/lamsfoundation/lams/learningdesign/ToolActivity.java 24 Jan 2015 18:10:56 -0000 1.45 @@ -152,6 +152,7 @@ newGradebookAct.setActivity(newToolActivity); newGradebookAct.setLearner(gradebookAct.getLearner()); newGradebookAct.setMark(gradebookAct.getMark()); + newGradebookAct.setUpdateDate(gradebookAct.getUpdateDate()); } } newToolActivity.setGradebookUserActivities(newGradebookUserActivities); Index: lams_gradebook/src/java/org/lamsfoundation/lams/gradebook/service/GradebookService.java =================================================================== RCS file: /usr/local/cvsroot/lams_gradebook/src/java/org/lamsfoundation/lams/gradebook/service/GradebookService.java,v diff -u -r1.39 -r1.40 --- lams_gradebook/src/java/org/lamsfoundation/lams/gradebook/service/GradebookService.java 5 Sep 2014 21:30:13 -0000 1.39 +++ lams_gradebook/src/java/org/lamsfoundation/lams/gradebook/service/GradebookService.java 24 Jan 2015 18:11:00 -0000 1.40 @@ -401,6 +401,7 @@ .toString(); gradebookUserActivity.setMark(mark); + gradebookUserActivity.setUpdateDate(new Date()); gradebookUserActivity.setMarkedInGradebook(markedInGradebook); gradebookDAO.insertOrUpdate(gradebookUserActivity); @@ -451,6 +452,7 @@ } gradebookUserActivity.setFeedback(feedback); + gradebookUserActivity.setUpdateDate(new Date()); gradebookDAO.insertOrUpdate(gradebookUserActivity); }