/**
* Chargement de a liste des phases pour une activite
*
* @param string $code Code CCAM
* @param string $activite Activité CCAM
*
* @return self[] Liste des phases
*/
static function loadListFromCodeActivite($code, $activite)
{
$ds = self::$spec->ds;
$query = "SELECT p_phase.*\n FROM p_phase\n WHERE p_phase.CODEACTE = %1\n AND p_phase.ACTIVITE = %2\n ORDER BY p_phase.PHASE ASC";
$query = $ds->prepare($query, $code, $activite);
$result = $ds->exec($query);
$list_phases = array();
while ($row = $ds->fetchArray($result)) {
$phase = new CPhaseCCAM();
$phase->_code = $code;
$phase->_activite = $activite;
$phase->map($row);
$list_phases[$row["PHASE"]] = $phase;
}
return $list_phases;
}
/**
* Chargement des phases disponibles
* Table p_phase
*
* @return array La liste des phases
*/
function loadRefPhases()
{
return $this->_ref_phases = CPhaseCCAM::loadListFromCodeActivite($this->_code, $this->code_activite);
}
