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