/** * 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; }