source: trunk/jpdd/class.jpdd.php @ 151

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

           */

require_once 'class.dkg.site.php';

if (!class_exists('JPDD_JPDD')) {

  class JPDD_JPDD extends DKG_Site {

    function JPDD_JPDD() {
      $this->DKG_Site();
      $this->addClassMapEntry('workshop', array('classname' => 'JPDD_Workshop', 
                                                'filename' => 'class.jpdd.workshop.php',
                                                'table' => 'workshop',
                                                'sort' => 'title'));
      // overrides the default DKG_Person map, which is fine because
      // it's a subclass:
      $this->addClassMapEntry('person', array('classname' => 'JPDD_Person', 
                                              'filename' => 'class.jpdd.person.php',
                                              'table' => 'person',
                                              'sort' => 'first_name,last_name'));
      $this->addClassMapEntry('category', array('classname' => 'JPDD_Category', 
                                                'filename' => 'class.jpdd.category.php',
                                                'table' => 'category',
                                                'sort' => 'title'));
      $this->addClassMapEntry('room', array('classname' => 'JPDD_Room', 
                                                'filename' => 'class.jpdd.room.php',
                                                'table' => 'room',
                                                'sort' => 'title'));
      $this->addClassMapEntry('organization', array('classname' => 'JPDD_Organization', 
                                                    'filename' => 'class.jpdd.organization.php',
                                                    'table' => 'organization',
                                                    'sort' => 'title'));
    }


    function getDefaultPage() {
      return $this->getSnippet('home');
    }

    function initialize() {
      parent::initialize();
      $this->_stylesheets[] = 'jpdd.css';
    }

    function getNavLink($title,$targ) {
      return '<a '.(($this->_action == $targ || (in_array($this->_action, array('view', 'edit')) && $this->_type == $targ)) ? 'class="current" ' : '').'href='.$this->Path($targ).'>'.$title.'</a>';
    }

    function getNavLinks() {
      // FIXME: this is way way way too static.
      $links = array('Categories' => 'category',
                     'Participating Schools' => 'organization');

      if ($this->isAuthenticated()) {
        if ($this->_authenticated_user->hasAnyOfThesePrivileges('Update Workshops'))
          $links['Workshops'] = 'workshop';
        if ($this->_authenticated_user->hasAnyOfThesePrivileges('List People'))
          $links['People'] = 'person';
        if ($this->_authenticated_user->hasAnyOfThesePrivileges('List Rooms'))
          $links['Rooms'] = 'room';
        if ($this->_authenticated_user->hasAllOfThesePrivileges('Update Workshops', 'Edit People', 'Edit Categories'))
          $links['Review Signups'] = 'overview';
      } else {
        if ($this->_action != 'newacct')
          $links['Create New Account'] = 'newacct';
      }
      return '<div class="navlinks">'."\n".
        join(' ', array_map(create_function('$t,$v', 'global $jpdd; return $jpdd->getNavLink($t,$v);'), array_keys($links), $links)).
        "\n".'</div>';
    }

    function getTopofPage() {
      return '<a href="'.$this->Path().'"><div class="header"><h1>'.$this->getPageTitle().'</h1>'.
        '<div class="subtitle"><q>'.$this->_site_subtitle.'</q></div>'.
        '<div class="date">'.$this->_site_date.'</div>'.
        '</div></a>'."\n";
    } 
    function getSidebar() {
      return '<div class="sidebar">
'.(in_array($this->_action, array('login', 'logout', 'resetpass', 'newacct')) ? '' : $this->getLoginForm()).'
'.$this->getNavLinks().'
</div>';
    }

    function getPageBody() {
      return $this->getTopofPage().'<div class="maincontent">'.$this->getMainContent().$this->getSnippet('directions').'</div>'.$this->getSidebar().$this->getSnippet('footer');
    }


    function getWorkshops() {
      $workshops = $this->getAll('workshop');
      
      $ret = '<dl>';
      reset($workshops);
      while (list(,$workshop) = each($workshops)) {
        $ret .= '<dt><a href="'.$this->Path('workshop', (int)($workshop->_id)).'">'.htmlentities($workshop->_title).'</a></dt>'.
          '<dd>'.htmlentities($workshop->_description).'</dd>';
      }
      return $ret.'</ul>';
    }


    function getAdditionalSalutation() {
      $x = $this->_authenticated_user->getSalutation();
      if ('' != $x)
        return '<div>'.$x.'</div>';
      return $x;
    }

    function getAllowedActions() {
      return array_merge(parent::getAllowedActions(), array('signup', 'printout', 'overview'));
    }

    function getGenericOverview() {
      return '<ul>'."\n".
        '<li>Workshops available: '.$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM workshop', 'foo')."\n".
        '<li>Workshop presenters: '.(int)$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM presenter', 'foo')."\n".
        '<li>Workshop attendees: '.(int)$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM audience', 'foo')."\n".
        '<li>Complete on-line accounts: '.$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM person WHERE pass IS NOT NULL', 'foo')."\n".
        '<ul><li>who aren\'t presenters or attendees yet: '.(int)$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM (SELECT id FROM person WHERE pass IS NOT NULL) AS p LEFT JOIN attendance ON (p.id = attendance.person_id) WHERE workshop_id IS NULL', 'foo')."\n".
        '<li>who are <a href="'.$this->Path('overview', 'unaffiliated').'">unaffiliated with any school</a>: '.(int)$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM (SELECT id FROM person WHERE pass IS NOT NULL) AS p LEFT JOIN affiliation ON (p.id = affiliation.person_id) WHERE organization_id IS NULL', 'foo')."</ul>\n".
        '<li>People without e-mail addresses: '.(int)$this->getValueFromSQL('SELECT COUNT(*) AS foo FROM person WHERE email IS NULL', 'foo')."\n".
        '</ul>';
    }

    function getUnaffiliatedAccounts() {
      $sql = 'SELECT person.* FROM person LEFT JOIN affiliation ON (person.id = affiliation.person_id) WHERE affiliation.id IS NULL AND person.pass IS NOT NULL';
      $us = $this->getSeriesFromSQL($sql, 'JPDD_Person');
      return "<h3>Unaffiliated accounts<ul>\n".join('', array_map(create_function('$x', 'return "<li>".$x->getLinkedTitle().(is_null($x->_email) ? "" : " - <a class=\"email\" href=\"mailto:".$x->_email."\">&lt;".$x->_email."&gt;</a>")."\n";'), $us))."</ul>";
    }

    function getSchoolOverview() {
      $sql = 'SELECT MAX(organization.title) AS title, organization.id, COUNT(*) AS registrations FROM audience LEFT JOIN affiliation ON (audience.person_id = affiliation.person_id) LEFT JOIN organization ON (affiliation.organization_id = organization.id) GROUP BY organization.id ORDER BY MAX(organization.title)';
      $os = $this->getSeriesFromSQL($sql);
      return '<table><tr><th>school</th><th>signups</th></tr>'."\n<tbody>\n".
        join('', array_map(create_function('$o', 'global $jpdd; return "<tr><td>".($jpdd->isEmpty($o["title"]) ? "unaffiliated" : "<a href=\"".$jpdd->Path("organization", $o["id"])."\">".htmlentities($o["title"])."</a>")."</td><td class=\"attendance\">".(int)$o["registrations"]."</td></tr>\n";'), $os)).
        '</tbody></table>'."\n";
    }

    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() {
      if (($this->_type) != 'workshop') {
        $this->addWarning('You can only sign up for a workshop.');
        return '';
      }
      $workshop = $this->getItem('workshop', $this->_identifier);
      
      // must POST
      if ($_SERVER['REQUEST_METHOD'] != 'POST') {
        $x = $this->Path('workshop', (int)$workshop->getID());
        $this->redirectLocal($x);
        exit;
      }
      if (!$this->isAuthenticated()) {
        // FIXME: should this be $this->permissionDenied() instead?  if not, document why not.
        $this->addWarning('You must be logged in to sign up for a workshop.');
        return $workshop->getDetailView();
      }
      // must match form token
      if (!$this->verifyFormToken()) {
        $this->addWarning('Form token did not match.');
        return $workshop->getDetailView();
      }

      if ($_POST['cancel'] == 'cancel') {
        // this is to cancel a signup.
        if (!$this->_authenticated_user->isAttendingWorkshop($workshop->getID(), 'audience')) {
          $this->addWarning('You are not signed up for this workshop at the moment.');
          return $workshop->getDetailView();
        }
        $sql = 'DELETE FROM attendance WHERE workshop_id = '.(int)$workshop->getID().' AND person_id = '.(int)$this->_authenticated_user->getID().' AND flavor = '.$this->escStr('audience');
        $this->executeSQL($sql);
      } else {
        // this is to actually sign up for this course.
        // authenticated user must not be attending any workshop currently.
        if ($this->_authenticated_user->getAttendanceCount() > 0) {
          $this->addWarning('You are already signed up for a workshop.');
          return $workshop->getDetailView();
        }
        // must be room in the workshop.
        if ($workshop->isFull()) {
          $this->addWarning('Sorry, '.$workshop->getLinkedTitle().' is already full.  Please choose <a href="'.$this->Path('category').'">another workshop</a>.');
          return $workshop->getDetailView();
        }
        $sql = 'INSERT INTO attendance (workshop_id, person_id, flavor) VALUES ('.(int)$workshop->getID().', '.(int)$this->_authenticated_user->getID().', '.$this->escStr('audience').')';
        $this->executeSQL($sql);
      }
      return $workshop->getDetailView();
    }

    function getMainContentExtended() {
      if ($this->_action == 'signup') {
        return $this->handleSignup();
      } elseif ($this->_action == 'printout') {
        $pdf = NULL;
        $pdfname = array_shift($this->_extra_URI_args);
        if ($this->_type == 'person') {
          if ($this->isAuthenticated()) {
            $subj = $this->getItem('person', (int)$this->_identifier);
            if ($this->_authenticated_user->canEdit($subj) || ($this->_authenticated_user->getID() == $subj->getID())) {
              // those who can edit the person are allowed to view their pdfs also.
              $pdf = $subj->getPDF($pdfname);
            }
          } else {
            $this->permissionDenied('You must be logged in to view an individual printout.');
          }
        }
        if (!is_null($pdf)) {
          // we've got a $pdf, we should emit it properly.
          $pdf->Output($pdfname, 'I');
        }
      } elseif ($this->_action = 'overview') {
        // we're using the presence of all three privileges as a proxy for sysadmin status:
        if ($this->isAuthenticated() && $this->_authenticated_user->hasAllOfThesePrivileges('Update Workshops', 'Edit Categories', 'Edit People')) {
          return $this->getOverview($this->_type);
        } else {
          $this->permissionDenied('You are not authorized to view this overview.');
        }
      }
      return parent::getMainContentExtended();
    }

    function getOverview($which) {
      global $jpdd;
      if (is_null($which))
        $which = '';

      $ret = '<div class="overviewnav">';

      // choice of administrator overviews:
      $overviews = array('Overview' => '',
                         'By Workshop' => 'workshop',
                         'By School' => 'organization');
      
      reset($overviews);
      while (list($t,$v) = each($overviews)) {
        $ret .= '<a '.($which == $v ? 'class="current" ' : '').'href="'.$this->Path('overview', $v).'">'.$t.'</a> ';
      }
      $ret .= '</div>';

      if ($which == 'workshop') {
        $ret .= $this->getWorkshopOverviewWithAttendence();
      } elseif ($which == 'organization') {
        $ret .= $this->getSchoolOverview();
      } elseif ($which == 'unaffiliated') {
        $ret .= $this->getUnaffiliatedAccounts();
      } else {
        $ret .= $this->getGenericOverview();
      }
      return $ret;
    }
    

    // new account requirements:
    // FIXME: these should somehow call on JPDD_Person directly, instead of being here...
    
    function getNewAccountFormExtraFields() {
      $lasterr = (($_SERVER['REQUEST_METHOD'] == 'POST') && $this->isEmpty($_POST['last_name']));
      $orgs = $this->getAll('organization');
      //      $this->addSourcedScript('scripts/dkg.base.js');
      //      $this->addScriptChunk('DKG.onLoadScripts.push(\'DKG.ShowOnValue("", "other", "org_title");\');');
      $acct = $this->getItem('person', (int)$this->_identifier);
      
      return '<label>First name:<br/><input type="text" name="first_name" value="'.htmlentities($this->defaultOnEmpty($_POST['first_name'], $acct->_first_name)).'"/></label><br/>
'.//<label>Middle name:<br/><input type="text" name="middle_name" value="'.htmlentities($_POST['middle_name']).'"/></label><br/>
'<label>'.$this->getRequiredFieldLabel().'Last name:<br/>'.
        ($lasterr ? '<span class="error">Must include a last name</span><br/>' : '').
'<input type="text" '.($lasterr ? 'class="error" ' : '').'name="last_name" value="'.htmlentities($this->defaultOnEmpty($_POST['last_name'], $acct->_last_name)).'"/></label><br/>

'.$acct->getM2MEditView('organization', 'affiliation', 'Affiliated With', 'Add Affiliation')

        /* 
.'<fieldset><legend>Affiliated With</legend>
<label><select onchange="DKG.ShowOnValue(this.value, \'other\', \'org_title\');" " name="affiliate_id">
<option value=""></option>
'.join("\n",array_map(create_function('$n', 'return "<option value=\"".$n->getID()."\">".htmlentities($n->getTitle())."</option>";'),$orgs)).'
<option value="other">Other...</option>
</select></label><br/>
<label id="org_title">School Name:<br/><input name="org_title" type="text" value="'.htmlentities($_POST['org_title']).'"/></label>
</fieldset>
'
        */
;
    }
    // return an array of update statements:
    function handleNewAccountFormExtraFields() {
      return array('first_name = '.$this->stringOrDefault($_POST['first_name']),
                   'middle_name = '.$this->stringOrDefault($_POST['middle_name']),
                   'last_name = '.$this->stringOrDefault($_POST['last_name']));
    }
    // return true if extra fields are all properly validated and can
    // continue:
    function validateNewAccountFormExtraFields() {
      return (!$this->isEmpty($_POST['last_name']));
    }

    function handleAdditionalNewAccountUpdates($id) {
      $affiliate = $_POST['affiliate_id'];
      if ('other' == $affiliate) {
        if ($this->isEmpty($_POST['org_title'])) {
          $affiliate = 0;
        } else {
          // try to make a new org:
          require_once('class.jpdd.organization.php');
          $org = new JPDD_Organization(array());
          $org->handleCreation('org_');
          $affiliate = $org->getID();
        }
      } else {
        $rem = array_key_exists('remove_affiliation', $_POST) ? $_POST['remove_affiliation'] : array();
        if (!is_array($rem)) $rem = array($rem);
        $add = array_key_exists('add_affiliation', $_POST) ? $_POST['add_affiliation'] : array();
        if (!is_array($add)) $add = array($add);
        array_map(create_function('$x', 'global $jpdd; $jpdd->executeSQL("INSERT INTO affiliation (person_id, organization_id) VALUES ('.(int)$id.', ".(int)$x.")");'), array_filter($add, create_function('$x', 'global $jpdd; return !$jpdd->isEmpty($x);')));
        array_map(create_function('$x', 'global $jpdd; $jpdd->executeSQL("DELETE FROM affiliation WHERE person_id = '.(int)$id.' AND organization_id = ".(int)$x);'), array_filter($rem, create_function('$x', 'global $jpdd; return !$jpdd->isEmpty($x);')));
      }
    }
  }
}

global $jpdd;

?>