public static function getTypes()
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select * from type');
$req->execute();
$res = $req->fetchAll();
return $res;
}
public static function getInfosClasses()
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select classe.idClasse, nomClasse, etablissement.idEtablissement, nomEtablissement from classe, exister, etablissement where classe.idClasse = exister.idClasse and exister.idEtablissement = etablissement.idEtablissement;');
$req->execute();
$res = $req->fetchAll();
return $res;
}
public static function getInfosEnfant($idEnf)
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select nomEnf, prenomEnf, nomClasse, nomEtablissement from enfant, classe, etablissement where idEnf = :idEnf and enfant.idClasse = classe.idClasse and enfant.idEtablissement = etablissement.idEtablissement;');
$req->execute(array("idEnf" => $idEnf));
$res = $req->fetchAll();
return $res;
}
public static function getEtablissements()
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select * from etablissement');
$req->execute();
$res = $req->fetchAll();
return $res;
}
public static function login($login, $mdp)
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select mdpBene from benevole where loginBene = :login');
$req->execute(array('login' => $login));
$res = $req->fetch();
if ($res[0] == $mdp) {
return true;
} else {
return false;
}
}
public static function getAdherents()
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('select * from adherent');
$req->execute();
$adhs = $req->fetchAll(PDO::FETCH_CLASS, "DAOAdherent");
foreach ($adhs as $res) {
array_push(DAOAdherent::$adherents, $res);
}
foreach (DAOAdherent::$adherents as $adh) {
$adh->enfant = array();
$req = $bdd->prepare('select * from enfant where idAd = :idAd');
$req->execute(array('idAd' => $adh->idAd));
$enfs = $req->fetchAll(PDO::FETCH_CLASS, "DAOEnfant");
foreach ($enfs as $res) {
array_push($adh->enfant, $res);
}
}
return DAOAdherent::$adherents;
}
public static function updateEtatBenevole($idBene, $etat)
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('update benevole set estAdmin = :etat where idBene = :idBene;');
$req->execute(array("etat" => $etat, "idBene" => $idBene));
}
public static function creerLivre($codeISBN, $titre, $editeur, $auteur, $anneeEdition, $formatEdition, $idCategorie, $idType, $idDiscipline)
{
$bdd = DAOConnectBDD::connect();
$req = $bdd->prepare('insert into manuel values (:codeISBN,:titre,:editeur,:auteur,:anneeEdition,:formatEdition,:idCategorie,:idType,:idDiscipline);');
$req->execute(array("codeISBN" => $codeISBN, "titre" => $titre, "editeur" => $editeur, "auteur" => $auteur, "anneeEdition" => $anneeEdition, "formatEdition" => $formatEdition, "idCategorie" => $idCategorie, "idType" => $idType, "idDiscipline" => $idDiscipline));
}
