Ejemplo n.º 1
0
 /**
  * Chargement de a liste des informations historisées pour une phase
  *
  * @param string $code     Code CCAM
  * @param string $activite Activité CCAM
  * @param string $phase    Phase CCAM
  *
  * @return self[] Liste des informations historisées
  */
 static function loadListFromCodeActivitePhase($code, $activite, $phase)
 {
     $ds = self::$spec->ds;
     $query = "SELECT p_phase_acte.*\n      FROM p_phase_acte\n      WHERE p_phase_acte.CODEACTE = %1\n      AND p_phase_acte.ACTIVITE = %2\n      AND p_phase_acte.PHASE = %3\n      ORDER BY p_phase_acte.DATEEFFET DESC";
     $query = $ds->prepare($query, $code, $activite, $phase);
     $result = $ds->exec($query);
     $list_infos = array();
     while ($row = $ds->fetchArray($result)) {
         $info = new CPhaseInfoCCAM();
         $info->map($row);
         $list_infos[$row["DATEEFFET"]] = $info;
     }
     return $list_infos;
 }
Ejemplo n.º 2
0
 /**
  * Chargement des informations historisées de la phase
  * Table p_phase_acte
  *
  * @return array La liste des informations historisées
  */
 function loadRefInfo()
 {
     return $this->_ref_classif = CPhaseInfoCCAM::loadListFromCodeActivitePhase($this->_code, $this->_activite, $this->code_phase);
 }