Changeset 73

Timestamp:

Jan 7, 2007 4:13:31 AM (6 years ago)

Author:

dkg

Message:

JPDD: made it so an admin can add/remove presenters from a workshop.

Location:

trunk/jpdd

Files:

• class.jpdd.workshop.php (modified) (6 diffs)
• sql/db.sql (modified) (1 diff)

trunk/jpdd/class.jpdd.workshop.php

@@ -14 +14 @@
           return array('Update Workshops');
         }
-        
         function getEditPrivilege() {
           return array('Update Workshops');
+        }
+
+        function getNonAttendees($flavor) {
+          global $jpdd;
+          $jpdd->prepClass('person');
+          return $jpdd->getSeriesFromSQL('SELECT person.* FROM person LEFT JOIN (SELECT * FROM attendance WHERE workshop_id = '.$this->getID().' AND flavor = '.$jpdd->escStr($flavor).') AS attendance ON (person.id = attendance.person_id) WHERE workshop_id IS NULL', 'JPDD_Person');
         }
 
@@ -25 +30 @@
         }
 
+        function addAttendees($ids, $flavor) {
+          global $jpdd;
+          if (!is_array($ids)) {
+                if ($jpdd->isEmpty($ids))
+                  return;
+                $ids = array($ids);
+          }
+          reset($ids);
+          while(list(,$id) = each($ids)) {
+                if (!$jpdd->isEmpty($id)) {
+                  $jpdd->executeSQL('INSERT INTO attendance (person_id, workshop_id, flavor) VALUES ('.(int)$id.', '.$this->getID().', '.$jpdd->escStr($flavor).')');
+                }
+          }
+        }
+        function dropAttendees($ids, $flavor) {
+          global $jpdd;
+          if (!is_array($ids)) {
+                if ($jpdd->isEmpty($ids))
+                  return;
+                $ids = array($ids);
+          }
+          $jpdd->executeSQL('DELETE FROM attendance WHERE workshop_id = '.$this->getID().' AND flavor = '.$jpdd->escStr($flavor).' AND person_id IN ('.join(',', array_map('intval', $ids)).')');
+        }
+
+
         function getFormInnards() {
           global $jpdd;
+          $nonpresenters = $this->getNonAttendees('presenter');
+          $presenters = $this->getAttendees('presenter');
+
           return '<div>
 <label>Title<br/><input type="text" size="72" name="title" value="'.$this->getTitle(true).'"/></label><br/>
@@ -34 +67 @@
 <label>Min. Attendees: <input type="text" size="2" maxlength="2" name="min_attendees" value="'.($jpdd->isEmpty($this->_min_attendees) ? '' : (int)$this->_min_attendees).'"/></label><br/>
 <label>Max. Attendees: <input type="text" size="2" maxlength="2" name="max_attendees" value="'.($jpdd->isEmpty($this->_max_attendees) ? '' : (int)$this->_max_attendees).'"/></label>
+</div>
+<div>
+'.(0 == count($presenters)?'':'Presented by:<br/><ul>'.
+   join("\n", array_map(create_function('$h', 'return "<li>".$h->getLinkedTitle()." <label>[<input type=\"checkbox\" name=\"remove_presenters[]\" value=\"".$h->getID()."\"/>remove]</label>";'), $presenters)).'</ul>').'
+<label>Add Presenter:<br/><select name="new_presenters[]">
+<option value=""></option>
+'.join("\n", array_map(create_function('$h', "return '<option value=\"'.\$h->getID().'\">'.\$h->getTitle().'</option>';"), $nonpresenters)).'
+</select></label>
 </div>
 </div>';
@@ -60 +101 @@
           } else {
                 $this->JPDD_Workshop(array('id' => $this->getID()));
+                $this->addAttendees($_POST['new_presenters'], 'presenter');
+                $this->dropAttendees($_POST['remove_presenters'], 'presenter');
                 return true;
           }
@@ -79 +122 @@
           } else {
                 $this->JPDD_Workshop(array('data' => $jpdd->getSingletonFromSQL('SELECT * from workshop WHERE id = currval(\'workshop_id_seq\')')));
+                $this->addAttendees($_POST['new_presenters'], 'presenter');
                 return true;
           }
@@ -91 +135 @@
           }
 
-          $ret .= '<div class="workshop-blurb">'.$this->getDescription().'</div>';
+          // silly debugging:
+          //      $nonpresenters = $this->getNonAttendees('presenter');
+          //      $ret .= 'Non-presenters: <ul>'.join("\n", array_map(create_function('$xx', 'return "<li>".$xx->getLinkedTitle();'), $nonpresenters)).'</ul>';
 
           $ret .= '<div class="attendance">Min. Attendees: '.(int)($this->_min_attendees).'<br/>'.

trunk/jpdd/sql/db.sql

@@ -302 +302 @@
 REVOKE ALL ON TABLE attendance FROM dkg;
 GRANT ALL ON TABLE attendance TO dkg;
-GRANT SELECT ON TABLE attendance TO "www-data";
+GRANT INSERT,SELECT,DELETE ON TABLE attendance TO "www-data";
+
+
+--
+-- Name: attendance_id_seq; Type: ACL; Schema: public; Owner: dkg
+--
+
+REVOKE ALL ON TABLE attendance_id_seq FROM PUBLIC;
+REVOKE ALL ON TABLE attendance_id_seq FROM dkg;
+GRANT ALL ON TABLE attendance_id_seq TO dkg;
+GRANT SELECT,UPDATE ON TABLE attendance_id_seq TO "www-data";