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