public function execute($request)
 {
     $this->resource = $request->getAttribute('sf_route')->resource;
     $criteria = new Criteria();
     $criteria->add(QubitEvent::ACTOR_ID, $this->resource->id);
     $criteria->addJoin(QubitEvent::INFORMATION_OBJECT_ID, QubitInformationObject::ID);
     $criteria->addAscendingOrderByColumn(QubitEvent::TYPE_ID);
     // Sort info objects alphabetically (w/ fallback)
     $criteria->addAscendingOrderByColumn('title');
     $criteria = QubitCultureFallback::addFallbackCriteria($criteria, 'QubitInformationObject');
     // Filter draft descriptions
     $criteria = QubitAcl::addFilterDraftsCriteria($criteria);
     $this->relatedInfoObjects = array();
     foreach (QubitEvent::get($criteria) as $item) {
         $this->relatedInfoObjects[$item->type->getRole()][] = $item->informationObject;
     }
     // Get "subject of" information objects (name access point)
     $criteria = new Criteria();
     $criteria->add(QubitRelation::OBJECT_ID, $this->resource->id);
     $criteria->add(QubitRelation::TYPE_ID, QubitTerm::NAME_ACCESS_POINT_ID);
     $this->subjectInfoObjects = array();
     foreach (QubitRelation::get($criteria) as $item) {
         $this->subjectInfoObjects[] = $item->subject;
     }
 }
 protected function addField($name)
 {
     switch ($name) {
         case 'creators':
             $criteria = new Criteria();
             $this->resource->addEventsCriteria($criteria);
             $criteria->add(QubitEvent::ACTOR_ID, null, Criteria::ISNOTNULL);
             $criteria->add(QubitEvent::TYPE_ID, QubitTerm::CREATION_ID);
             $value = $choices = array();
             foreach ($this->events = QubitEvent::get($criteria) as $item) {
                 $choices[$value[] = $this->context->routing->generate(null, array($item->actor, 'module' => 'actor'))] = $item->actor;
             }
             $this->form->setDefault('creators', $value);
             $this->form->setValidator('creators', new sfValidatorPass());
             $this->form->setWidget('creators', new sfWidgetFormSelect(array('choices' => $choices, 'multiple' => true)));
             break;
         case 'appraisal':
             $this->form->setDefault('appraisal', $this->resource['appraisal']);
             $this->form->setValidator('appraisal', new sfValidatorString());
             $this->form->setWidget('appraisal', new sfWidgetFormTextarea());
             break;
         default:
             return parent::addField($name);
     }
 }
    public function __get($name)
    {
        switch ($name) {
            case 'biogHist':
                return self::toDiscursiveSet($this->resource->history);
            case 'entityType':
                switch ($this->resource->entityTypeId) {
                    case QubitTerm::CORPORATE_BODY_ID:
                        return 'corporateBody';
                    case QubitTerm::FAMILY_ID:
                        return 'family';
                    case QubitTerm::PERSON_ID:
                        return 'person';
                }
                return;
            case 'existDates':
                // TODO <date/>, <dateRange/>, <dateSet/>, <descriptiveNote/>, simple
                // natural language parsing?
                return '<date>' . esc_specialchars($this->resource->datesOfExistence) . '</date>';
            case 'generalContext':
                return self::toDiscursiveSet($this->resource->generalContext);
            case 'maintenanceHistory':
                ProjectConfiguration::getActive()->loadHelpers('Date');
                $createdAt = format_date($this->resource->createdAt, 's');
                $updatedAt = format_date($this->resource->updatedAt, 's');
                $createdDisplay = format_date($this->resource->createdAt, 'F');
                $updatedDisplay = format_date($this->resource->updatedAt, 'F');
                return <<<return
<maintenanceEvent>
  <eventType>created</eventType>
  <eventDateTime standardDateTime="{$createdAt}">{$createdDisplay}</eventDateTime>
  <agentType>human</agentType>
  <agent/>
</maintenanceEvent>

<maintenanceEvent>
  <eventType>revised</eventType>
  <eventDateTime standardDateTime="{$updatedAt}">{$updatedDisplay}</eventDateTime>
  <agentType>human</agentType>
  <agent/>
</maintenanceEvent>

return;
            case 'maintenanceStatus':
                switch (strtolower($this->resource->descriptionStatus)) {
                    case 'revised':
                        return 'revised';
                    default:
                        return 'new';
                }
            case 'publicationStatus':
                return 'approved';
            case 'resourceRelation':
                $criteria = new Criteria();
                $criteria->add(QubitEvent::ACTOR_ID, $this->resource->id);
                $criteria->addJoin(QubitEvent::INFORMATION_OBJECT_ID, QubitInformationObject::ID);
                return QubitEvent::get($criteria);
            case 'functionRelation':
                $criteria = new Criteria();
                $criteria->addAlias('subj', QubitObject::TABLE_NAME);
                $criteria->addJoin(QubitRelation::SUBJECT_ID, 'subj.id');
                $criteria->add(QubitRelation::OBJECT_ID, $this->resource->id);
                $criteria->add('subj.class_name', 'QubitFunction');
                return QubitRelation::get($criteria);
            case 'structureOrGenealogy':
                return self::toDiscursiveSet($this->resource->internalStructures);
        }
    }
 public static function geteventsById($id, array $options = array())
 {
     $criteria = new Criteria();
     self::addeventsCriteriaById($criteria, $id);
     return QubitEvent::get($criteria, $options);
 }
 /**
  * Related events which have a date
  */
 public function getDates(array $options = array())
 {
     $criteria = new Criteria();
     $criteria->add(QubitEvent::INFORMATION_OBJECT_ID, $this->id);
     $criteria->addMultipleJoin(array(array(QubitEvent::ID, QubitEventI18n::ID), array(QubitEvent::SOURCE_CULTURE, QubitEventI18n::CULTURE)), Criteria::LEFT_JOIN);
     $criteria->add($criteria->getNewCriterion(QubitEvent::END_DATE, null, Criteria::ISNOTNULL)->addOr($criteria->getNewCriterion(QubitEvent::START_DATE, null, Criteria::ISNOTNULL))->addOr($criteria->getNewCriterion(QubitEventI18n::DATE, null, Criteria::ISNOTNULL)));
     if (isset($options['type_id'])) {
         $criteria->add(QubitEvent::TYPE_ID, $options['type_id']);
     }
     $criteria->addDescendingOrderByColumn(QubitEvent::START_DATE);
     return QubitEvent::get($criteria);
 }