source: cpc/trunk/project/lib/model/doctrine/Intervention.class.php @ 1355

<?php

/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class Intervention extends BaseIntervention
{
  public function getLink() {
    sfProjectConfiguration::getActive()->loadHelpers(array('Url'));
    return url_for('@interventions_seance?seance='.$this->getSeance()->id).'#inter_'.$this->getMd5();
  }

  public function getPersonne() {
    sfProjectConfiguration::getActive()->loadHelpers(array('Url'));
    return $this->getIntervenant()->getNom();
  }

  public function __toString() {
    if (strlen($this->intervention) > 1024)
      return substr($this->intervention, 0, 512).'...';
    return $this->intervention;
  }

  public function getTitre() {
    $titre = 'Intervention du '.$this->date.' ';
    if ($this->type == 'commission') {
      $titre .= 'en commission';
    }else{
      $titre .= 'en hémicycle';
    }
    return $titre;
  }

  public function setSeance($type, $date, $heure, $session, $commission = null) {
    $this->setType($type);
    if ($type == 'commission') {
      $commission = Doctrine::getTable('Organisme')->findOneByNomOrCreateIt($commission, 'parlementaire');
      $seance = $commission->getSeanceByDateAndMomentOrCreateIt($date, $heure, $session);
      $commission->free();
    } else{
      $seance = Doctrine::getTable('Seance')->findOneOrCreateIt('hemicycle', $date, $heure, $session);
    }
    $id = $this->_set('seance_id', $seance->id);
    $seance->free();
    return $id;
  }
  public function setPersonnaliteByNom($nom, $fonction = null) 
  {
    $this->setFonction($fonction);
    if (!preg_match('/ministre|secr[^t]+taire [^t]+tat|commissaire|garde des sceaux/i', $fonction)) { 
      $personne = Doctrine::getTable('Parlementaire')->findOneByNom($nom);
      if (!$personne) {
        $personne = Doctrine::getTable('Parlementaire')->similarTo($nom);
      }
      if ($personne) {
        return $this->setParlementaire($personne);
      }
    }
    $personne = Doctrine::getTable('Personnalite')->findOneByNom($nom);
    if (!$personne) {
      $personne = Doctrine::getTable('Personnalite')->similarTo($nom);
    }
    if (!$personne) {
      $personne = new Personnalite();
      $personne->setNom($nom);
      $personne->save();
    }
    if ($personne) {
      return $this->setPersonnalite($personne,$fonction);
    }
  }
  public function setParlementaire($parlementaire, $from_db = null) {
    if (isset($parlementaire->id)) {
      $this->_set('parlementaire_id', $parlementaire->id);
      if (!$from_db)
        $this->getSeance()->addPresence($parlementaire, 'intervention', $this->source);
      $parlementaire->free();
    }
  }

  public function hasIntervenant() {
    if ($this->parlementaire_id) {
      return true;
    }
    if ($this->personnalite_id) {
      return true;
    }
    return false;
  }

  public function getIntervenant() {
    $perso = $this->Parlementaire;
    if (!$perso->id)
      $perso = $this->Personnalite;
    return $perso;
  }

  public function getNomAndFonction() {
    $res = null;
    if ($this->hasIntervenant()) {
      $res = $this->getIntervenant()->getNom();
      if ($this->getFonction())
        $res .= ', '.$this->getFonction();
    }
    return $res;
  }

  public function setContexte($contexte, $date = null, $timestamp = null, $tlois = null, $debug = 0) {
    $tlois = preg_replace('/[^,\d]+/', '', $tlois);
    $tlois = preg_replace('/\s+,/', ',', $tlois);
    $tlois = preg_replace('/,\s+/', ',', $tlois);
    $lois = explode(',', $tlois);
    $loisstring = "";
    foreach($lois as $loi) if ($loi) {
      $tag = 'loi:numero='.$loi;
      $this->addTag($tag);
      if ($loisstring == "") $loisstring = "t.numero = $loi";
      else $loisstring .= " OR t.numero = $loi";
    }
    if ($lois[0]) {
      $urls = Doctrine_Query::create()
        ->select('distinct(t.url_an)')
        ->from('Texteloi t')
        ->where('t.type = ? OR t.type = ? OR t.type = ? OR t.type = ?', array("Proposition de loi", "Proposition de résolution", "Projet de loi", "Texte de la commission"))
        ->andWhere($loisstring)
        ->fetchArray();
      $ct = count($urls);
      if ($ct == 0) $urls = Doctrine_Query::create()
        ->select('distinct(t.url_an)')
        ->from('Texteloi t')
        ->where($loisstring)
        ->fetchArray();
      $ct = count($urls);
      if ($ct > 1) {
        $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt($contexte, $date, $timestamp));
        if ($debug) {
          print "WARNING : Intervention $this->id has tags lois corresponding to multiple url_ans : ";
          foreach ($urls as $url)
            print $url['distinct']." ; ";
          print " => Saving to section $this->Section->id\n";
          $debug = 0;
        }
        return $debug;
      }
      if ($ct == 0) $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt($contexte, $date, $timestamp));
      else if ($ct == 1) {
        $section1 = Doctrine::getTable('Section')->findOneByContexte($contexte);
        $section2 = Doctrine::getTable('Section')->findOneByUrlAn($urls[0]['distinct']);
        if ($section2) {
          if (!$section1)
            $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt(str_replace(trim(preg_replace('/^([^>])(>.*)?$/', '\\1', $contexte)), $section2->titre, $contexte), $date, $timestamp));
          else if ($section1->section_id == $section2->id)
            $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt($section1->titre_complet, $date, $timestamp));
          else {
            $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt($contexte, $date, $timestamp));
            if ($debug) {
              print "WARNING : Intervention $this->id has tags lois corresponding to another section $section2->id";
              print " => Saving to section $this->Section->id\n";
              $debug = 0;
            }
            return $debug;
          }
        }
        else {
          $section1 = Doctrine::getTable('Section')->findOneByContexteOrCreateIt($contexte, $date, $timestamp);
          $this->setSection($section1);
          $section1->setUrlAn($urls[0]['distinct']);
          $section1->save();
        }
      }
      if ($this->section_id != 1) {
        $titre = $this->Section->Section->getTitre();
        if (!(preg_match('/(cloture|ouverture|question|ordre du jour|calendrier|élection.*nouveau|démission|reprise|examen simplifié|cessation.*mandat|proclamation|souhaits)/i', $titre))) {
          foreach($lois as $loi) {
            $tag = 'loi:numero='.$loi;
            $this->Section->addTag($tag);
            if ($this->Section->section_id && $this->Section->Section->id && $this->Section->section_id != $this->section_id)
              $this->Section->Section->addTag($tag);
          }
        }
      }
      return $debug;
    } else {
      $this->setSection(Doctrine::getTable('Section')->findOneByContexteOrCreateIt($contexte, $date, $timestamp));
      return $debug;
    }
  }

  public function setAmendements($tamendements) {
    $tamendements = preg_replace('/[^,\d]+/', '', $tamendements);
    $amends = preg_split('/\s*,\s*/', $tamendements);
    foreach($amends as $amend) {
      $tag = 'loi:amendement='.$amend;
      $this->addTag($tag);
    }
  }
  
  public function setIntervention($s) {
    $this->_set('nb_mots', str_word_count($s));
    return $this->_set('intervention', $s);
  }

  public function getIntervention($args = array()) {
    $inter = $this->_get('intervention');
    if ($this->type == 'loi' && isset($args['linkify_amendements']) && $linko = $args['linkify_amendements']) {
      $inter = preg_replace('/\(([^\)]+)\)/', '(<i>\\1</i>)', $inter);
      if (preg_match_all('/(amendements?[,\s]+(identiques?)?[,\s]*)((n[°os\s]*|\d+\s*|,\s*|à\s*|et\s*|rectifié\s*)+)/', $inter, $match)) {
        $lois = implode(',', $this->getTags(array('is_triple' => true,
                                                  'namespace' => 'loi',
                                                  'key' => 'numero',
                                                  'return' => 'value')));
        for ($i = 0 ; $i < count($match[0]) ; $i++) {
          $match_protected = preg_replace('/(\s*)(\d[\d\s\à]*rectifiés?|\d[\d\s\à]*)(,\s*|\s*et\s*)*/', '\1%\2%\3', $match[3][$i]);
          if (preg_match_all('/\s*%([^%]+)%(,\s*|\s*et\s*)*/', $match_protected, $amends)) {
            $replace = $match_protected;
            foreach($amends[1] as $amend) {
              $am = preg_replace('/à+/', '-', $amend);
              $am = preg_replace('/[^\d\-]+/', '',$am);
              $link = str_replace('LLL', urlencode($lois), $linko);
              $link = str_replace('AAA', urlencode($am), $link);
              $replace = preg_replace('/%'.$amend.'%/', '<a name="amend_'.$am.'" href="'.$link.'">'.$amend.'</a> ', $replace);
            }
            $inter = preg_replace('/'.$match[1][$i].$match[3][$i].'/', $match[1][$i].$replace, $inter);
          }
        }
      }
    }
    return $inter;
  }
}