Changeset 142

Timestamp:

Jan 26, 2007 3:48:17 PM (6 years ago)

Author:

dkg

Message:

JPDD: added attendance overview table for Phyllis.

Location:

trunk/jpdd

Files:

• class.jpdd.php (modified) (3 diffs)
• class.jpdd.workshop.php (modified) (1 diff)
• web/jpdd.css (modified) (1 diff)

trunk/jpdd/class.jpdd.php

@@ -55 +55 @@
 
       if ($this->isAuthenticated()) {
-        if ($this->_authenticated_user->hasAnyOfThesePrivileges('Update Workshops'))
+        if ($this->_authenticated_user->hasAnyOfThesePrivileges('Update Workshops')) {
           $links['Workshops'] = 'workshop';
+          $links['Review Signups'] = 'attendance';
+        }
         if ($this->_authenticated_user->hasAnyOfThesePrivileges('List People'))
           $links['People'] = 'person';
@@ -109 +111 @@
 
     function getAllowedActions() {
-      return array_merge(parent::getAllowedActions(), array('signup', 'printout'));
-    }
-
+      return array_merge(parent::getAllowedActions(), array('signup', 'printout', 'attendance'));
+    }
+
+
+    function getWorkshopOverviewWithAttendence() {
+      return '<table><tr><th>workshop</th><th>max</th><th>min</th><th>total</th><th>by school</th></tr>'."\n<tbody>\n".
+        join('', array_map(create_function('$w', 'return $w->getOverviewRowWithAttendence();'), $this->getAll('workshop'))).
+        '</tbody></table>'."\n";
+    }
 
     function handleSignup() {
@@ -184 +192 @@
           $pdf->Output($pdfname, 'I');
         }
-      } 
+      } elseif ($this->_action = 'attendance') {
+        if ($this->isAuthenticated() && $this->_authenticated_user->hasAnyOfThesePrivileges('Update Workshops'))
+          return $this->getWorkshopOverviewWithAttendence();
+        else
+          $this->permissionDenied('You are not authorized to view this overview.');
+      }
       return parent::getMainContentExtended();
     }

trunk/jpdd/class.jpdd.workshop.php

@@ -138 +138 @@
     }
 
+    function getAudienceListBySchoolCount() {
+      global $jpdd;
+      $sql = 'SELECT organization.id, MAX(organization.title) AS title, COUNT(*) AS count  FROM audience LEFT JOIN affiliation ON (audience.person_id = affiliation.person_id) LEFT JOIN organization ON (affiliation.organization_id = organization.id)  WHERE workshop_id = '.$this->getID().' GROUP BY organization.id ORDER BY MAX(organization.title)';
+      $x = $jpdd->getSeriesFromSQL($sql);
+      // FIXME: link these schools!
+      return "<ul>\n".join('', array_map(create_function('$x', 'return "<li>".(int)$x["count"]." ".(is_null($x["title"]) ? "unaffiliated" : " from ".htmlentities($x["title"]));'), $x))."</ul>\n";
+    }
+
+    function getOverviewRowWithAttendence() {
+      return '<tr><td>'.$this->getLinkedTitle().$this->getPresentersWithOrgs().'</td>'.
+        '<td class="attendance">'.(int)$this->_max_attendees.'</td>'.
+        '<td class="attendance">'.(int)$this->_min_attendees.'</td>'.
+        '<td class="attendance">'.$this->getAudienceCount().'</td>'.
+        '<td>'.$this->getAudienceListBySchoolCount().'</td></tr>'."\n";
+    }
+
         function getDetailTopInnards() {
       return $this->getPresentersWithOrgs();

trunk/jpdd/web/jpdd.css

@@ -150 +150 @@
 }
 
+
+table { 
+ border: thin solid black;
+}
+
+td { 
+ border: thin solid black;
+}
+
+td.attendance {
+ text-align: center;
+}
+
 @media print {