source: trunk/jpdd/class.jpdd.organization.php @ 568

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

       */

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

if (!class_exists('JPDD_Organization')) {

  class JPDD_Organization extends DKG_Row {
    
    function getCreatePrivilege() {
          return array('Edit Organizations');
        }
        function getEditPrivilege() {
          return array('Edit Organizations');
        }

    # try to add a richtext editor for this form, since it has a description:
    function getFormInnards() {
      global $jpdd;
      $websiteerr = is_null($this->_website) ? NULL : $jpdd->isValid('URL', $this->_website);
      $jpdd->addTinyMCE();
      return '<div>
<label>Name:<br/><input type="text" name="title" value="'.$this->getTitle(true).'"/></label><br/>
<label>Description<br/><textarea name="description" rows="20" cols="70">'.$this->getDescription(true).'</textarea></label><br/>
<label>Web Site:<br/>'.(is_null($websiteerr)?'':'<span class="error">'.$websiteerr.'</span><br/>').'<input type="text" size="50" '.(is_null($websiteerr)?'':'class="error" ').'name="website" value="'.htmlentities($this->_website).'"/></label>
</div>';
    }

    function applyPostForm($prefix = '') {
      global $jpdd;
      $this->_title = $jpdd->nonEmptyString($_POST[$prefix.'title']);
      $this->_description = $jpdd->nonEmptyString($_POST[$prefix.'description']);
      $this->_website = $jpdd->nonEmptyString($_POST[$prefix.'website']);
    }

    function getWebsite() {
      global $jpdd;
      if (! is_null($this->_website) && (is_null($jpdd->isValid('URL', $this->_website))))
        return $this->_website;
      return NULL;
    }

    function handleCreation($prefix = '') {
      global $jpdd;
      $this->applyPostForm($prefix);
      $res = $jpdd->executeSQL('INSERT INTO '.$this->getSingletonTable().' (title, description, website) VALUES ('.
                                                           $jpdd->stringOrDefault($this->_title).', '.
                                                           $jpdd->stringOrDefault($this->_description).', '.
                                                           $jpdd->stringOrDefault($this->_website).
                               ')', false);
          if (false === $res) {
        $logid = $jpdd->log('creating organization db insert failed with pg error: '.pg_last_error($jpdd->_db));
                return 'database insertion of organization failed for some reason (error: '.(int)$logid.').';
          } else {
                $this->JPDD_Organization(array('data' => $jpdd->getSingletonFromSQL('SELECT * from '.$this->getSingletonTable().' WHERE id = currval(\''.$this->getSingletonTable().'_id_seq\')')));
                return NULL;
          }
    }

    function handleEdit() {
      global $jpdd;
      $this->applyPostForm();
      $ret = $jpdd->executeSQL('UPDATE '.$this->getSingletonTable().' SET '.
                               'title = '.$jpdd->stringOrDefault($this->getTitle()).', '.
                               'description = '.$jpdd->stringOrDefault($this->getDescription()).', '.
                               'website = '.$jpdd->stringOrDefault($this->_website).' '.
                               'WHERE id = '.$this->getID());
          if (false === $res) {
        $logid = $jpdd->log('database update of organization '.$this->getID().' insert failed with pg error: '.pg_last_error($jpdd->_db));
                return 'update of organization failed for some reason (error: '.(int)$logid.').';
          } else {
                $this->JPDD_Organization(array('id' => $this->getID()));
                return NULL;
          }
    }

    function getPDFLinks() {
      global $jpdd;
      if ($jpdd->isAuthenticated()) {
        if ($jpdd->_authenticated_user->hasAllOfThesePrivileges('Edit Organizations')) {
          $pdfs = array('Attendance List' => 'attendance');
          return '<div class="pdf-links">'."\n".join('', array_map(create_function('$t, $v', 'global $jpdd; return "<a href=\"".$jpdd->Path("printout", "organization", '.$this->getID().', $v.".pdf")."\">".$t."</a>\n";'), array_keys($pdfs), $pdfs))."</div>\n";
        }
      } else {
        return '';
      }
    }


        function getLinkedTitle($classnames = NULL) {
      global $jpdd;
      if ($jpdd->isAuthenticated() && $jpdd->_authenticated_user->canEdit($this)) {
        return parent::getLinkedTitle($classnames);
      } else {
        if (!is_null($this->_description)) {
          // if there's a description, treat as normal.
          return parent::getLinkedTitle($classnames);
        } elseif (!is_null($this->getWebsite())) {
          // instead, if there is a website, link to that.
          return '<a '.(is_null($classnames) ? '' : 'class="'.$classnames.'" ').'href="'.$this->getWebsite().'">'.$this->getTitle().'</a>';
        } else {
          // otherwise, there's not much here, so don't bother linking:
          return $this->getTitle();
        }
      }
        }

    function getPDF($pdfname) {
      require_once('class.jpdd.pdf.php');
      $ret = new JPDD_PDF();
      if ($pdfname == 'attendance.pdf') {
        $ret->addAttendanceLocationsPage($this);
      } else {
        return NULL;
      }
      return $ret;
    }
    
    function getDetailTopInnards() {
      return $this->getPDFLinks();
    }

    function getApplyingPeople() {
      global $jpdd;

      $sql = 'SELECT person.*, category_id FROM person JOIN affiliation ON (person_id = person.id) JOIN application ON (person.id = application.person_id) WHERE event_id = '.$jpdd->getActiveEventID().' ORDER BY category_id, first_name, middle_name, last_name';

      return $jpdd->getMultiSeriesFromSQLByValue($sql, 'category_id', 'JPDD_Person');
    }

    function getAffiliatedPersonIDs() {
      global $jpdd;
      return array_map('intval', $jpdd->getValuesFromSQL('SELECT person_id FROM affiliation WHERE organization_id = '.$this->getID(), 'person_id'));
    }

    function getLiaisonForm() {
      global $jpdd;
      
      // this is gonna require the interface js libraries:

      $jpdd->addSourcedScript('scripts/jquery.js');
      $jpdd->addSourcedScript('scripts/interface/interface.js');
      $jpdd->addSourcedScript('scripts/jpdd.liaison.js');
      $jpdd->addStyleSheet('styles/liaison.css');
      $script = '';

      // get the list of attendees for this event related to this
      // organization:
      $applied = $this->getApplyingPeople();

      $listed_ids = array();

      // get the remaining attendees affiliated with this
      // organization  
      // FIXME: this contains too many people at the moment, because it includes existing attendees.
      $otheraffiliates = $this->getM2MPeers('person', 'affiliation');

      // get the per-category requirements for this event:
      $jpdd->prepClass('category');
      $requirements = $jpdd->getSeriesFromSQL('SELECT category.*, minimum, maximum FROM attendance_requirements JOIN category ON (category.id = category_id) WHERE event_id = '.$jpdd->getActiveEventID().' ORDER BY minimum DESC', 'JPDD_Category'); 

      $ret = '<div class="instructions">Please sign up teachers from your school by dragging them to the appropriate subject area on the left.<strong>Remember to click <q>Save Changes</q> below!</div>';
      $script .= '$("li.affiliated_person").Draggable( {revert: true, ghosting: true} );
$("fieldset.category").each( JPDD.Liaison.testapply );';

      $ret .= '<table class="liaisonui"><tbody><tr><td>';

      $dropdown = '<select name="newassign">'."\n<option>choose a subject</option>\n";
      reset($requirements);
      while(list(,$req) = each($requirements)) {
        $ret .= '<fieldset id="category_'.$req->getID().'" catval="'.(int)$req->getID().'" class="category" min="'.(int)$req->_minimum.'" max="'.(int)$req->_maximum.'"><legend>'.$req->getTitle().'</legend><div class="notes"></div>
<ul>
';
        
        $dropdown .= '<option value="'.$req->getID().'">'.$req->getTitle().'</option>'."\n";
        if (array_key_exists($req->getID(), $applied)) {
          $ret .= join("\n", array_map(create_function('$x', 'return $x->getListItem("affiliated_person", '.$req->getID().');'), $applied[$req->getID()]));
          $ids = array_map(create_function('$x', 'return $x->getID();'), $applied[$req->getID()]);
          $listed_ids = array_merge($listed_ids, $ids);
        }
          
        /*
        $item = 0;
        while ($item < $req->_minimum) {
          $x = 'application_'.$req->getID().'_'.$item;
          $ret .= '<input type="hidden" name="application_'.$req->getID().'" value="" id="'.$x.'" />';
          $item++;
        }
        while ($item < $req->_maximum) {

          $item++;
        }
        */
        $ret .= '</ul></fieldset>';
      }
      
      $dropdown .= '</select>';
      
      $ret .= '</td><td>';

      // show all the affiliates in their own list:
      $ret .= '<fieldset class="category" catval=""><legend>Available teachers</legend><div class="notes"></div><ul>'.
        join("\n", array_map(create_function('$x', 'return $x->getListItem("affiliated_person", "");'), array_filter($otheraffiliates, create_function('$x', '$y = array('.join(',', $listed_ids).'); return !in_array($x->getID(), $y);')))).'
</ul>
</fieldset>
';

      // allow liaisons to create new people:
      $ret .= '<fieldset><legend>Add a new teacher</legend>
'.$dropdown.'<br/>
<label>First name:<br/><input type="text" name="first_name" value=""/></label><br/>
<label>Last name:<br/><input type="text" name="last_name" value=""/></label><br/>
<label>E-mail Address:<br/><input type="text" name="email" value=""/></label><br/>
</fieldset>';

      $ret .= '</tr></tbody></table>';
      $jpdd->addScriptChunk('$(document).ready(function() {'.$script.'});');
      return '<form action="'.$jpdd->Path('liaison/organization/'.$this->getID()).'" method="post">'.
        $ret.
        $jpdd->getFormTokenHiddenInput().
        '<input type="submit" value="Save Changes">'.
        '</form>';
    }
    
    function handleLiaisonForm() {
      global $jpdd;
      // walk through the people supplied: if they're affiliated with
      // the org in question, check their invitation status for the
      // current session, and make sure it matches the input.

      $affiliatedids = $this->getAffiliatedPersonIDs();
      $acceptedcategories = array_map('intval', $jpdd->getValuesFromSQL('SELECT category_id FROM attendance_requirements WHERE event_id = '.$jpdd->getActiveEventID(), 'category_id'));

      // we'll just ignore unaffiliated people:
      $people = array_intersect_key($jpdd->getPostedIDtoIDMap('person'), array_flip($affiliatedids));

      $unapplied = array();
      reset($people);
      while(list($person_id, $category) = each($people)) {
        if (is_null($category) || !in_array($category, $acceptedcategories))
          $unapplied[] = $person_id;
        else {
          $jpdd->executeSQL('DELETE FROM application WHERE event_id = '.$jpdd->getActiveEventID().' AND person_id = '.$person_id);
          $jpdd->executeSQL('INSERT INTO application (event_id, person_id, category_id) VALUES ('.(int)$jpdd->getActiveEventID().', '.
                            (int)$person_id.', '.$category.')');
        }
      }
      
      if (count($unapplied))
        $jpdd->executeSQL('DELETE FROM application WHERE event_id = '.$jpdd->getActiveEventID().' AND person_id IN ('.join(',', $unapplied).')');

      if ($jpdd->arrayKeyIsNotEmpty('first_name', $_POST) || 
          $jpdd->arrayKeyIsNotEmpty('last_name', $_POST) || 
          $jpdd->arrayKeyIsNotEmpty('email', $_POST)) {
        // FIXME: if the person fields are present, check if person
        // already exists, as affiliated with the school.


        // if not, create the person, 
        $newp = new JPDD_Person(array('data' => array('first_name' => $_POST['first_name'],
                                                      'last_name' => $_POST['last_name'],
                                                      'email' => $_POST['email'])));
        $res = $newp->storeNewInDatabase();
        if (false !== $res) {
          // affiliate the person with the org:
          $newp->addM2MPeers('organization', 'affiliation', array($this->getID()));
        
          if ($jpdd->arrayKeyIsNotEmpty('newassign', $_POST) && in_array((int)$_POST['newassign'], $acceptedcategories)) {
            // FIXME: if the org already has enough for this category, put this user into "alternate"?
            $jpdd->executeSQL('INSERT INTO application (event_id, person_id, category_id) VALUES ('.(int)$jpdd->getActiveEventID().', '.
                              $newp->getID().', '.(int)$_POST['newassign'].')');
          }
        }
      }
    }

        function getDetailInnards() {
      global $jpdd;
      $ret = '';
      
      if (!is_null($this->getWebsite())) 
        $ret .= '<a class="outlink" href="'.$this->getWebsite().'">Find out more about '.$this->getTitle().'</a>';

      // FIXME: maybe show all affiliated people?
      if ($jpdd->isAuthenticated() && $jpdd->_authenticated_user->hasAllOfThesePrivileges('List People')) {
        $peops = $this->getM2MPeers('person', 'affiliation');
        
        $ret .= '<h3>'.count($peops).(count($peops) == 1 ? ' Person' : ' People').'</h3><ul>'."\n".
          join('', array_map(create_function('$x', 'return "<li>".$x->getLinkedTitle()." ".$x->getWorkshopText(false)."\n";'), $peops)).
          "</ul>\n";
      }

          return $ret;
        }
  }

}