Changeset 1494 for trunk/grails-app/domain

Timestamp:

Feb 4, 2011, 12:04:10 PM (13 years ago)

Author:

robert@…

Message:

Implemented pagination on study list pages

File:

• trunk/grails-app/domain/dbnp/studycapturing/Study.groovy (modified) (13 diffs)

trunk/grails-app/domain/dbnp/studycapturing/Study.groovy

@@ -14 +14 @@
 class Study extends TemplateEntity {
         static searchable = true
-        
+
         def moduleNotificationService
 
@@ -34 +34 @@
 
         /**
-        * UUID of this study
-        */
+         * UUID of this study
+         */
         String studyUUID
 
-        
+
         static hasMany = [
                 subjects: Subject,
@@ -85 +85 @@
         static final List<TemplateField> domainFields = [
                 new TemplateField(
-                        name: 'title',
-                        type: TemplateFieldType.STRING,
-                        required: true),
+                name: 'title',
+                type: TemplateFieldType.STRING,
+                required: true),
                 new TemplateField(
-                        name: 'description',
-                        type: TemplateFieldType.TEXT,
-                        comment:'Give a brief synopsis of what your study is about',
-                        required: true),
+                name: 'description',
+                type: TemplateFieldType.TEXT,
+                comment:'Give a brief synopsis of what your study is about',
+                required: true),
                 new TemplateField(
-                        name: 'code',
-                        type: TemplateFieldType.STRING,
-                        preferredIdentifier: true,
-                        comment: 'Fill out the code by which many people will recognize your study',
-                        required: true),
+                name: 'code',
+                type: TemplateFieldType.STRING,
+                preferredIdentifier: true,
+                comment: 'Fill out the code by which many people will recognize your study',
+                required: true),
                 new TemplateField(
-                        name: 'startDate',
-                        type: TemplateFieldType.DATE,
-                        comment: 'Fill out the official start date or date of first action',
-                        required: true),
+                name: 'startDate',
+                type: TemplateFieldType.DATE,
+                comment: 'Fill out the official start date or date of first action',
+                required: true),
                 new TemplateField(
-                        name: 'published',
-                        type: TemplateFieldType.BOOLEAN,
-                        comment: 'Determines whether this study is published (accessible for the study readers and, if the study is public, for anonymous users). A study can only be published if it meets certain quality criteria, which will be checked upon save.',
-                        required: false)
+                name: 'published',
+                type: TemplateFieldType.BOOLEAN,
+                comment: 'Determines whether this study is published (accessible for the study readers and, if the study is public, for anonymous users). A study can only be published if it meets certain quality criteria, which will be checked upon save.',
+                required: false)
         ]
 
@@ -123 +123 @@
         def List<Event> getOrphanEvents() {
                 def orphans = events.findAll { event -> !event.belongsToGroup(eventGroups) } +
-                        samplingEvents.findAll { event -> !event.belongsToGroup(eventGroups) }
+                samplingEvents.findAll { event -> !event.belongsToGroup(eventGroups) }
 
                 return orphans
@@ -349 +349 @@
                                 this.samples.findAll { sample ->
                                         (
-                                        (eventGroup.subjects.findAll {
-                                                it.equals(sample.parentSubject)
-                                        })
-                                                &&
-                                                (eventGroup.samplingEvents.findAll {
-                                                        (
-                                                        (it.id && sample.parentEvent.id && it.id == sample.parentEvent.id)
-                                                                ||
-                                                                (it.getIdentifier() == sample.parentEvent.getIdentifier())
-                                                                ||
-                                                                it.equals(sample.parentEvent)
+                                                        (eventGroup.subjects.findAll {
+                                                                it.equals(sample.parentSubject)
+                                                        })
+                                                        &&
+                                                        (eventGroup.samplingEvents.findAll {
+                                                                (
+                                                                                (it.id && sample.parentEvent.id && it.id == sample.parentEvent.id)
+                                                                                ||
+                                                                                (it.getIdentifier() == sample.parentEvent.getIdentifier())
+                                                                                ||
+                                                                                it.equals(sample.parentEvent)
+                                                                                )
+                                                        })
                                                         )
-                                                })
-                                        )
                                 }.each() { sample ->
                                         // remove sample from study
@@ -458 +458 @@
                         return c.list {
                                 maxResults(max)
+                                order("title", "asc")
+                                
                         }
                 }
@@ -463 +465 @@
                 return c.list {
                         maxResults(max)
+                        order("title", "asc")
                         or {
                                 eq("owner", user)
@@ -475 +478 @@
          * Returns a list of studies that are readable by the given user
          */
-        public static giveReadableStudies(SecUser user, int max) {
+        public static giveReadableStudies(SecUser user, int max, int offset = 0) {
                 def c = Study.createCriteria()
 
@@ -482 +485 @@
                         return c.list {
                                 maxResults(max)
+                                firstResult(offset)
+                                order("title", "asc")
                                 and {
                                         eq("published", true)
@@ -490 +495 @@
                         return c.list {
                                 maxResults(max)
+                                firstResult(offset)
+                                order("title", "asc")
                         }
                 } else {
                         return c.list {
                                 maxResults(max)
+                                firstResult(offset)
+                                order("title", "asc")
                                 or {
                                         eq("owner", user)
@@ -509 +518 @@
                 }
         }
-        
+
+        /**
+         * Returns the number of studies that are readable by the given user
+         */
+        public static countReadableStudies(SecUser user) {
+                def c = Study.createCriteria()
+
+                // Administrators are allowed to read everything
+                if (user == null) {
+                        return c.count {
+                                and {
+                                        eq("published", true)
+                                        eq("publicstudy", true)
+                                }
+                        }
+                } else if (user.hasAdminRights()) {
+                        return Study.count();
+                } else {
+                        return c.count {
+                                or {
+                                        eq("owner", user)
+                                        writers {
+                                                eq("id", user.id)
+                                        }
+                                        and {
+                                                readers {
+                                                        eq("id", user.id)
+                                                }
+                                                eq("published", true)
+                                        }
+                                }
+                        }
+                }
+        }
+
         /**
          * Returns the UUID of this study and generates one if needed
@@ -520 +563 @@
                         }
                 }
-                
+
                 return this.studyUUID;
         }
-        
+
         /**
          * Basic equals method to check whether objects are equals, by comparing the ids
@@ -532 +575 @@
                 if( o == null )
                         return false;
-                        
+
                 if( !( o instanceof Study ) )
                         return false
-                
+
                 Study s = (Study) o;
-                
+
                 return this.id == s.id
         }