/apps/backend/modules/catalogue/actions/actions.class.php

<?php

/**
 * catalogue actions.
 *
 * @package    darwin
 * @subpackage catalogue
 * @author     DB team <collections@naturalsciences.be>
 * @version    SVN: $Id: actions.class.php 12479 2008-10-31 10:54:40Z fabien $
 */
class catalogueActions extends DarwinActions
{
  protected $catalogue = array(
   'catalogue_relationships','catalogue_people','class_vernacular_names','catalogue_properties','comments',
   'specimens','specimen_individuals','specimen_parts','ext_links','collection_maintenance', 'insurances',
   'people_addresses', 'people_comm','people_languages', 'people_relationships', 'classification_keywords');

  protected $ref_id = array('specimens' => 'spec_ref','specimen_individuals' => 'individual_ref','specimen_parts' => 'part_ref') ;
  public function executeRelation(sfWebRequest $request)
  {
    if(! $this->getUser()->isAtLeast(Users::ENCODER)) $this->forwardToSecureAction();  
    $this->relation = null;
    if($request->hasParameter('id'))
    {
      $this->relation = Doctrine::getTable('CatalogueRelationships')->find($request->getParameter('id'));
    }
    if(! $this->relation)
    {
     $this->relation = new CatalogueRelationships();
     $this->relation->setRecordId_1($request->getParameter('rid'));
     $this->relation->setReferencedRelation($request->getParameter('table'));
     $this->relation->setRelationshipType($request->getParameter('type') == 'rename' ? 'current_name' : 'recombined from');
    }

    $this->form = new CatalogueRelationshipsForm($this->relation);
    
    if($request->isMethod('post'))
    {
      $this->form->bind($request->getParameter('catalogue_relationships'));
      if($this->form->isValid())
      {
        try{
          $this->form->save();
          $this->form->getObject()->refreshRelated();
          $this->form = new CatalogueRelationshipsForm($this->form->getObject()); //Ugly refresh
          return $this->renderText('ok');
        }
        catch(Doctrine_Exception $ne)
        {
          $e = new DarwinPgErrorParser($ne);
          $error = new sfValidatorError(new savedValidator(),$e->getMessage());
          $this->form->getErrorSchema()->addError($error);
        }
      }
    }
    $filterFormName = DarwinTable::getFilterForTable($request->getParameter('table'));
    $this->searchForm = new $filterFormName(array('table'=>$request->getParameter('table')));
  }
  
  public function executeTree(sfWebRequest $request)
  {
    $this->items = Doctrine::getTable( DarwinTable::getModelForTable($request->getParameter('table')) )
      ->findWithParents($request->getParameter('id'));
  }

  public function executeSearch(sfWebRequest $request)
  {
    $this->setCommonValues('catalogue', 'name_order_by', $request);
    $this->forward404Unless($request->hasParameter('searchCatalogue'));
    $item = $request->getParameter('searchCatalogue',array('') );
    $formFilterName = DarwinTable::getFilterForTable($item['table']);
    $this->searchForm = new $formFilterName(array('table' => $item['table'], 'level' => $item['level'], 'caller_id' => $item['caller_id']));
    $this->searchResults($this->searchForm,$request);
    $this->setLayout(false);
  }

  public function executeDeleteRelated(sfWebRequest $request)
  {
    if(in_array($request->getParameter('table'), array('users_languages','users_comm','users_addresses')))
    {
      $r = Doctrine::getTable( DarwinTable::getModelForTable($request->getParameter('table')) )->find($request->getParameter('id'));
      $this->forward404Unless($r,'No such item');

      if((in_array($request->getParameter('table'), array('users_comm','users_addresses'))
          && ($r->getPersonUserRef() == $this->getUser()->getId() || $this->getUser()->isAtLeast(Users::MANAGER)))
        || (in_array($request->getParameter('table'), array('users_languages'))
          && ($r->getUsersRef() == $this->getUser()->getId() || $this->getUser()->isAtLeast(Users::MANAGER)) ))
      {
        try
        {
          $r->delete();
        }
        catch(Doctrine_Exception $ne)
        {
          $e = new DarwinPgErrorParser($ne);
          return $this->renderText($e->getMessage());
        }
        return $this->renderText('ok');
      }
    }

    if(! $this->getUser()->isAtLeast(Users::ENCODER))
      $this->forwardToSecureAction();
    if(! in_array($request->getParameter('table'),$this->catalogue))
      $this->forwardToSecureAction();   
    $r = Doctrine::getTable( DarwinTable::getModelForTable($request->getParameter('table')) )->find($request->getParameter('id'));
    $this->forward404Unless($r,'No such item');

    if(!$this->getUser()->isA(Users::ADMIN))
    {
      if(in_array($request->getParameter('table'),array('comments','catalogue_properties','ext_links')) && in_array($r->getReferencedRelation(),$this->ref_id))
      {
        $spec = Doctrine::getTable('specimenSearch')->getRecordByRef($this->ref_id[$r->getReferencedRelation()],$r->getRecordId());
        if(in_array($spec->getCollectionRef(),Doctrine::getTable('Specimens')->testNoRightsCollections($this->ref_id[$r->getReferencedRelation()],
                                                                                                        $r->getRecordId(), 
                                                                                                        $this->getUser()->getId())))    
          $this->forwardToSecureAction();    
      } 
    }

    try{
      $r->delete();
    }
    catch(Doctrine_Exception $ne)
    {
      $e = new DarwinPgErrorParser($ne);
      return $this->renderText($e->getMessage());
    }
    return $this->renderText('ok');
  }

  protected function searchResults($form, $request)
  {
    if($request->getParameter('searchCatalogue','') !== '')
    {
      $form->bind($request->getParameter('searchCatalogue'));
      if ($form->isValid())
      {
        $query = $form
                 ->getQuery()
                 ->orderBy($this->orderBy .' '.$this->orderDir .', id' );
        if($this->is_choose == 0)
          $query->andWhere('id > 0');

        $pager = new DarwinPager($query,
          $this->currentPage,
          $form->getValue('rec_per_page')
        );

        // Replace the count query triggered by the Pager to get the number of records retrieved
        $count_q = clone $query;
        // Remove from query the group by and order by clauses
        $count_q = $count_q->select('count(id)')->removeDqlQueryPart('groupby')->removeDqlQueryPart('orderby')->removeDqlQueryPart('join');

        // Initialize an empty count query
        $counted = new DoctrineCounted();
        // Define the correct select count() of the count query
        $counted->count_query = $count_q;
        // And replace the one of the pager with this new one
        $pager->setCountQuery($counted);
        $this->pagerLayout = new PagerLayoutWithArrows(
          $pager,
          new Doctrine_Pager_Range_Sliding(array('chunk' => $this->pagerSlidingSize)),
          $this->getController()->genUrl($this->s_url.$this->o_url).'/page/{%page_number}'
          );

        // Sets the Pager Layout templates
        $this->setDefaultPaggingLayout($this->pagerLayout);
        // If pager not yet executed, this means the query has to be executed for data loading
        if (! $this->pagerLayout->getPager()->getExecuted())
           $this->items = $this->pagerLayout->execute();
      }
    }
  }

  public function executeSearchPUL(sfWebRequest $request)
  {
    $response = 'ok';
    if($request->hasParameter('level_id') && $request->hasParameter('parent_id') && $request->hasParameter('table'))
    {
      $parent_level = Doctrine::getTable($request->getParameter('table'))->find($request->getParameter('parent_id'))->getLevelRef();
      $possible_upper_levels = Doctrine::getTable('PossibleUpperLevels')->findByLevelRef($request->getParameter('level_id'));
      if($possible_upper_levels)
      {
        $response = 'not ok';
        foreach($possible_upper_levels as $val)
        {
          if($val->getLevelUpperRef() == 0)
          {
            $response = 'top';
            break;
          }
          elseif ($val->getLevelUpperRef() == $parent_level)
          {
            $response = 'ok';
            break;
          }
        }
      }
    }
    return $this->renderText($response);
  }

  public function executeKeyword(sfWebRequest $request)
  {
    if(!$this->getUser()->isAtLeast(Users::ENCODER)) $this->forwardToSecureAction();

    $this->forward404Unless( $request->hasParameter('id') && $request->hasParameter('table'));
    $this->ref_object = Doctrine::getTable(DarwinTable::getModelForTable($request->getParameter('table')))->find($request->getParameter('id'));
    $this->forward404Unless($this->ref_object);
    $this->form = new  KeywordsForm(null,array('table' => $request->getParameter('table'), 'id' => $request->getParameter('id')));

    if($request->isMethod('post'))
    {
      $this->form->bind($request->getParameter('keywords'));
      if($this->form->isValid())
      {
        try{
          $this->form->save();
          return $this->renderText('ok');

        }
        catch(Doctrine_Exception $ne)
        {
          $e = new DarwinPgErrorParser($ne);
          $error = new sfValidatorError(new savedValidator(),$e->getMessage());
          $this->form->getErrorSchema()->addError($error);
        }
      }
    }

  }

  public function executeAddKeyword(sfWebRequest $request)
  {
    if($this->getUser()->getDbUserType() < Users::ENCODER) $this->forwardToSecureAction();  
    $number = intval($request->getParameter('num'));

    $form = new  KeywordsForm(null,array('no_load'=>true));

    $form->addKeyword($number, $request->getParameter('key'));

    return $this->renderPartial('nameValue',array('form' => $form['newKeywords'][$number]));
  }

  public function executeGetCurrent(sfWebRequest $request)
  {
    $this->forward404Unless( $request->hasParameter('id') && $request->hasParameter('table'));

    $relation  = Doctrine::getTable('ClassificationSynonymies')->findGroupIdFor(
      $request->getParameter('table'),
      $request->getParameter('id'),
      'rename'
    );
    if($relation == 0)
      return $this->renderText('{}'); // The record has no current name

    $current  = Doctrine::getTable('ClassificationSynonymies')->findBasionymIdForGroupId($relation);
    if($current == $request->getParameter('id') || $current == 0)
      return $this->renderText('{}'); // The record is a current name
    $item = Doctrine::getTable(DarwinTable::getModelForTable($request->getParameter('table')))->find($current);
    return $this->renderText(json_encode(array('name'=>$item->getName(), 'id'=>$item->getId() )));
  }
}