source: trunk/jpdd/class.jpdd.workshop.php @ 72

<?php  /* -*- indent-tabs-mode: nil; tab-width: 4; c-basic-offset: 2; -*-

       */

require_once('class.dkg.row.php');

if (!class_exists('JPDD_Workshop')) {

  class JPDD_Workshop extends DKG_Row {

        var $_short_title_length = 35;

        function getCreatePrivilege() {
          return array('Update Workshops');
        }
        
        function getEditPrivilege() {
          return array('Update Workshops');
        }

        function getAttendees($flavor) {
          global $jpdd;
          $jpdd->prepClass('person');
          return $jpdd->getSeriesFromSQL('SELECT person.* FROM person JOIN attendance ON (person.id = attendance.person_id) WHERE workshop_id = '.$this->getID().' AND flavor = '.$jpdd->escStr($flavor), 'JPDD_Person');
        }

        function getFormInnards() {
          global $jpdd;
          return '<div>
<label>Title<br/><input type="text" size="72" name="title" value="'.$this->getTitle(true).'"/></label><br/>
<label>Short Title<br/><input type="text" maxlength="'.(int)$this->_short_title_length.'" name="short_title" value="'.htmlentities($this->_short_title).'"/></label><br/>
<label>Description<br/><textarea name="description" rows="20" cols="80">'.$this->getDescription(true).'</textarea></label>
<div class="attendance" style="text-align: right;">
<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>';
        }

        function applyPostForm() {
          $this->_title = $_POST['title'];
          $this->_short_title = $_POST['short_title'];
          $this->_description = $_POST['description'];
          $this->_min_attendees = $_POST['min_attendees'];
          $this->_max_attendees = $_POST['max_attendees'];
        }

        function handleEdit() {
          global $jpdd;
          $this->applyPostForm();
          $res = $jpdd->executeSQL('UPDATE '.$this->getSingletonTable().' SET '.
                                                           'title = '.$jpdd->escStr($this->_title).', '.
                                                           'short_title = '.$jpdd->stringOrDefault($this->_short_title).', '.
                                                           'description = '.$jpdd->escStr($this->_description).', '.
                                                           'min_attendees = '.$jpdd->intOrDefault($this->_min_attendees).', '.
                                                           'max_attendees = '.$jpdd->intOrDefault($this->_max_attendees).' WHERE '.
                                                           'id = '.$this->getID(), false);
          if (false === $res) {
                return false;
          } else {
                $this->JPDD_Workshop(array('id' => $this->getID()));
                return true;
          }
        }

        function handleCreation() {
          // just insert a new row, grab the created ID, and re-initialize
          // ourselves, returning true if successful.
          global $jpdd;
          $this->applyPostForm();
          $res = $jpdd->executeSQL('INSERT INTO '.$this->getSingletonTable().' (title, short_title, description, min_attendees, max_attendees) VALUES ('.
                                                           $jpdd->escStr($this->_title).', '.
                                                           $jpdd->stringOrDefault($this->_short_title).', '.
                                                           $jpdd->escStr($this->_description).', '.
                                                           $jpdd->intOrDefault($this->_min_attendees).', '.
                                                           $jpdd->intOrDefault($this->_max_attendees).')', false);
          if (false === $res) {
                return false;
          } else {
                $this->JPDD_Workshop(array('data' => $jpdd->getSingletonFromSQL('SELECT * from workshop WHERE id = currval(\'workshop_id_seq\')')));
                return true;
          }
        }

        function getDetailInnards() {
          global $jpdd;

          $presenters = $this->getAttendees('presenter');
          if (count($presenters)) {
                $ret .= '<div>Presented by: '.join(', ', array_map(create_function('$xx', 'return $xx->getLinkedTitle();'), $presenters)).'</div>';
          }

          $ret .= '<div class="workshop-blurb">'.$this->getDescription().'</div>';

          $ret .= '<div class="attendance">Min. Attendees: '.(int)($this->_min_attendees).'<br/>'.
                'Max. Attendees: '.(int)($this->_max_attendees).'<br/>'.
                'Current Attendees: '.count($this->getAttendees('attendee')).
                '</div>';
          return $ret;
        }
  }
}