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