Exemplo n.º 1
0
 /**
  * Return a collection of teams
  *
  */
 public function findAll()
 {
     $orderBy = array('name' => 'ASC');
     $queryBuilder = $this->db->createQueryBuilder();
     $queryBuilder->select('t.*')->from('team', 't')->orderBy('t.' . key($orderBy), current($orderBy));
     $statement = $queryBuilder->execute();
     $teamsData = $statement->fetchAll();
     $teams = array();
     foreach ($teamsData as $teamData) {
         $teamId = $teamData['id'];
         $team = $this->hydrateTeam($teamData);
         $teammates = $this->db->fetchAll('SELECT * FROM team_has_teammate INNER JOIN teammate ON team_has_teammate.teammate_id = teammate.id WHERE team_id = ?', array($teamId));
         $arrayTeammate = array();
         foreach ($teammates as $teammateData) {
             $teammate = new Teammate();
             $teammate->hydrate($teammateData);
             $arrayTeammate[] = $teammate;
         }
         $team->setTeammates($arrayTeammate);
         $teams[$teamId] = $team;
     }
     return $teams;
 }
Exemplo n.º 2
0
 /**
  * @param $teamData
  * @return Teammate
  */
 public function hydrateTeammate($teamData)
 {
     $teammate = new Teammate();
     $teammate->setId($teamData['id']);
     $teammate->setFirstname($teamData['firstname']);
     $teammate->setLastname($teamData['lastname']);
     $teammate->setEmail($teamData['email']);
     $teammate->setPhone($teamData['phone']);
     $teammate->setImage($teamData['image']);
     return $teammate;
 }