public function findAllWithCount() { $stmt = "SELECT g.*, count(DISTINCT gu.id_user) AS countUser\n FROM groupe g\n JOIN groupe_user gu ON g.id_groupe = gu.id_groupe\n GROUP BY gu.id_groupe\n ORDER BY gu.id_groupe DESC"; $raw = $this->db->SqlArray($stmt); $hydrated = array(); foreach ($raw as $groupe) { $hydrated[] = new Groupe($groupe['id_groupe'], $groupe['libelle'], $groupe['countUser']); } return $hydrated; }
public function findAll() { $stmt = "SELECT m.* FROM mail m"; $raw = $this->db->SqlArray($stmt); $hydrated = array(); foreach ($raw as $mail) { $hydrated[] = new Mail($mail['id_mail'], $mail['libelle'], $mail['objet'], $mail['body']); } return $hydrated; }
public function findAll() { $stmt = "SELECT n.* FROM newsletter n"; $raw = $this->db->SqlArray($stmt); $hydrated = array(); foreach ($raw as $news) { $hydrated[] = new Newsletter($news['id_newsletter'], $news['nom'], $news['contenu'], $news['lien']); } return $hydrated; }
public function findUsersInGroupeUser() { $stmt = "SELECT g.id_groupe, g.libelle AS groupe_libelle, u.*\n FROM users u\n JOIN groupe_user gu ON u.id_user = gu.id_user\n JOIN groupe g ON g.id_groupe = gu.id_groupe\n GROUP BY gu.id_user\n ORDER BY gu.id_user"; $raw = $this->db->SqlArray($stmt); $hydrated = array(); foreach ($raw as $user) { $hydrated[] = new User($user['id_user'], $user['nom'], $user['prenom'], $user['mail'], $user['telephone'], $user['id_groupe'], $user['groupe_libelle']); } return $hydrated; }
public function findAll() { $stmt = "SELECT ug.* FROM groupe_user ug"; $raw = $this->db->SqlArray($stmt); $hydrated = array(); foreach ($raw as $usergroupe) { $hydrated[] = new GroupeUser($usergroupe['id_user'], $usergroupe['id_groupe']); } return $hydrated; }