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