source: cpc/trunk/project/apps/frontend/modules/section/actions/actions.class.php @ 1352

<?php

/**
 * section actions.
 *
 * @package    cpc
 * @subpackage section
 * @author     Your name here
 * @version    SVN: $Id: actions.class.php 12479 2008-10-31 10:54:40Z fabien $
 */
class sectionActions extends sfActions
{
 /**
  * Executes index action
  *
  * @param sfRequest $request A request object
  */
  public function executeParlementaire(sfWebRequest $request)
  {
    $this->parlementaire = Doctrine::getTable('Parlementaire')->findOneBySlug($request->getParameter('slug'));
    $this->forward404Unless($this->parlementaire);
    $this->titre = 'Dossiers parlementaires';
    $this->response->setTitle($this->titre.' de '.$this->parlementaire->nom);
  }

  public function executeParlementaireSection(sfWebRequest $request) 
  {
    $this->parlementaire = Doctrine::getTable('Parlementaire')->findOneBySlug($request->getParameter('slug'));
    $this->forward404Unless($this->parlementaire);

    $this->section = Doctrine::getTable('Section')->find($request->getParameter('id'));
    $this->forward404Unless($this->section);

    $this->qinterventions = Doctrine::getTable('Intervention')->createQuery('i')
      ->where('i.parlementaire_id = ?', $this->parlementaire->id)
      ->leftJoin('i.Section s')
      ->andWhere('(s.section_id = ? OR s.id = ?)', array($this->section->id, $this->section->id))
      ->andWhere('i.nb_mots > 20')
      ->orderBy('i.date DESC, i.timestamp ASC');
  }
  public function executeShow(sfWebRequest $request) 
  {
    $secid = $request->getParameter('id');
    $this->forward404Unless($secid);
    if ($option = Doctrine::getTable('VariableGlobale')->findOneByChamp('linkdossiers')) {
      $links = unserialize($option->getValue());
      if (isset($links[$secid]))
        $secid = $links[$secid];
    }
    $this->section = Doctrine::getTable('Section')->find($secid);
    $this->forward404Unless($this->section);

    $lois = $this->section->getTags(array('is_triple' => true,
                                          'namespace' => 'loi',
                                          'key' => 'numero',
                                          'return' => 'value'));
    $this->docs = array();
    if ($this->section->url_an || $lois) {
      $qtextes = Doctrine_Query::create()
        ->select('t.id, t.type, t.type_details, t.titre')
        ->from('Texteloi t')
        ->whereIn('t.numero', $lois);
      if ($this->section->url_an)
        $qtextes->orWhere('t.url_an = ?', $this->section->url_an);
      $qtextes->orderBy('t.numero, t.annexe');
      $textes = $qtextes->fetchArray();

      $textes_loi = Doctrine_Query::create()
        ->select('t.texteloi_id, t.titre')
        ->from('TitreLoi t')
        ->whereIn('t.texteloi_id', $lois)
        ->andWhere('t.chapitre IS NULL')
        ->andWhere('t.section is NULL')
        ->orderBy('t.texteloi_id')
        ->fetchArray();
    
      foreach ($textes_loi as $doc)
        $this->docs[$doc['texteloi_id']] = $doc;
      foreach ($textes as $texte)
        $this->docs[$texte['id']] = $texte;
      foreach ($lois as $loi) {
        $loi = sprintf("%04d", $loi);
        if (!isset($this->docs["$loi"]))
          $this->docs["$loi"] = null;
      }
    }
    
    $amdmts_lois = Doctrine_Query::create()->select('distinct(a.texteloi_id)')->from('Amendement a')->whereIn('a.texteloi_id', $lois)->fetchArray();
    $this->lois_amendees = array();
    foreach($amdmts_lois as $loi)
      array_push($this->lois_amendees, $loi['distinct']); 
    sort($this->lois_amendees);
   
    $inters = Doctrine_Query::create()
      ->select('i.id')
      ->from('Intervention i')
      ->leftJoin('i.Section s')
      ->where('(i.section_id = ? OR s.section_id = ?)', array($this->section->id, $this->section->id))
      ->andWhere('i.nb_mots > 20')
      ->fetchArray();
    
    $interventions = array();
    foreach($inters as $i) {
      $interventions[] = $i['id'];
    }

    //    $this->forward404Unless(count($interventions));
      
    $this->qtag = Doctrine_Query::create()
      ->from('Tagging tg, tg.Tag t');
    if (count($interventions))
      $this->qtag->whereIn('tg.taggable_id', $interventions);
    else
      $this->qtag->where('false');
    
    $this->ptag = Doctrine_Query::create()
      ->from('Intervention i')
      ->leftJoin('i.Parlementaire p')
      ->where('p.id IS NOT NULL')
      ->andWhere('((i.fonction != ? AND i.fonction != ? ) OR i.fonction IS NULL)', array('président', 'présidente'))
      ->groupBy('p.id')
      ->limit(30);
    if (count($interventions))
      $this->ptag->whereIn('i.id', $interventions);
    else
      $this->ptag->where('false');
    
    $request->setParameter('rss', array(array('link' => '@section_rss_commentaires?id='.$this->section->id, 'title'=>'Les commentaires sur '.$this->section->titre)));
  }

  public function executeList(sfWebRequest $request) 
  {
    if (!($this->order = $request->getParameter('order')))
      $this->order = 'plus';
    $query = Doctrine::getTable('Section')->createQuery('s')
      ->where('s.id = s.section_id')
      ->andWhere('s.nb_interventions > 5');
    if ($this->order == 'date') {
      $query->orderBy('s.max_date DESC');
      $this->titre = 'Les derniers dossiers à l\'Assemblée';
    } else if ($this->order == 'plus') {
      $query->orderBy('s.nb_interventions DESC');
      $this->titre = 'Les dossiers les plus discutés à l\'Assemblée';
    } else if ($this->order == 'coms') {
      $query->orderBy('s.nb_commentaires DESC');
      $this->titre = 'Les dossiers de l\'Assemblée les plus commentés par les citoyens';
    } else $this->forward404();
    $this->getResponse()->setTitle(str_replace('Assemblée', 'Assemblée nationale', $this->titre)." - NosDéputés.fr");
    $this->sections = $query->execute();

  }
}