<?php
include "_debut.inc.php";
use modele\dao\EtablissementDao;
require_once __DIR__ . "/../../includes/fonctions.inc.php";
use modele\Connexion;
// OBTENIR LE DÉTAIL DE L'ÉTABLISSEMENT SÉLECTIONNÉ
Connexion::connecter();
$lgEtab = EtablissementDao::getOneById($id);
//$nom = $lgEtab['nom'];
//$adresseRue = $lgEtab['adresseRue'];
//$codePostal = $lgEtab['codePostal'];
//$ville = $lgEtab['ville'];
//$tel = $lgEtab['tel'];
//$adresseElectronique = $lgEtab['adresseElectronique'];
//$type = $lgEtab['type'];
//$civiliteResponsable = $lgEtab['civiliteResponsable'];
//$nomResponsable = $lgEtab['nomResponsable'];
//$prenomResponsable = $lgEtab['prenomResponsable'];
echo "\r\n<br>\r\n<table width='60%' cellspacing='0' cellpadding='0' class='tabNonQuadrille'>\r\n \r\n <tr class='enTeteTabNonQuad'>\r\n <td colspan='3'><strong>" . $lgEtab->getNom() . "</strong></td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td width='20%'> Id: </td>\r\n <td>" . $lgEtab->getId() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Adresse: </td>\r\n <td>" . $lgEtab->getAdresseRue() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Code postal: </td>\r\n <td>" . $lgEtab->getCodePostal() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Ville: </td>\r\n <td>" . $lgEtab->getVille() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Téléphone: </td>\r\n <td>" . $lgEtab->getTel() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> E-mail: </td>\r\n <td>" . $lgEtab->getAdressseElectronique() . "</td>\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Type: </td>";
if ($lgEtab->getTypeEtab() == 1) {
echo "<td> Etablissement scolaire </td>";
} else {
echo "<td> Autre établissement </td>";
}
echo "\r\n </tr>\r\n <tr class='ligneTabNonQuad'>\r\n <td> Responsable: </td>\r\n <td>" . $lgEtab->getCiviliteResponsable() . " " . $lgEtab->getNomResponsable() . " " . $lgEtab->getPrenomResponsable() . "\r\n </td>\r\n </tr> \r\n</table>\r\n<br>\r\n<a href='cGestionEtablissements.php'>Retour</a>";
include "_fin.inc.php";
<?php
include "_debut.inc.php";
use modele\dao\EtablissementDao;
require_once __DIR__ . "/../../includes/fonctions.inc.php";
use modele\Connexion;
use modele\dao\UserDAO;
// AFFICHER L'ENSEMBLE DES ÉTABLISSEMENTS
// CETTE PAGE CONTIENT UN TABLEAU CONSTITUÉ D'1 LIGNE D'EN-TÊTE ET D'1 LIGNE PAR
// ÉTABLISSEMENT
echo "\r\n<br>\r\n<table width='55%' cellspacing='0' cellpadding='0' class='tabNonQuadrille'>\r\n\r\n <tr class='enTeteTabNonQuad'>\r\n <td colspan='4'><strong>Etablissements</strong></td>\r\n </tr>";
Connexion::connecter();
$arrayEtab = EtablissementDao::getAll();
//$rsEtab = mysql_query($req, $connexion);
if (isset($_SESSION['pseudo'])) {
$privil = UserDAO::getPrivilegeByPseudo($_SESSION['pseudo']);
}
// BOUCLE SUR LES ÉTABLISSEMENTS
for ($i = 0; $i < count($arrayEtab); $i++) {
$unEtab = $arrayEtab[$i];
echo "\r\n\t\t<tr class='ligneTabNonQuad'>\r\n <td width='52%'>" . $unEtab->getNom() . "</td>\r\n \r\n <td width='16%' align='center'> \r\n <a href='cGestionEtablissements.php?action=detailEtab&id=" . $unEtab->getId() . "'>\r\n Voir détail</a></td>";
if (isset($_SESSION['pseudo']) && $privil == '1') {
echo "<td width='16%' align='center'> \r\n <a href='cGestionEtablissements.php?action=demanderModifierEtab&id=" . $unEtab->getId() . "'>\r\n Modifier</a></td>";
}
// S'il existe déjà des attributions pour l'établissement, il faudra
// d'abord les supprimer avant de pouvoir supprimer l'établissement
if (!existeAttributionsEtab($connexion, $unEtab->getId()) && isset($_SESSION['pseudo']) && $privil == '1') {
echo "\r\n <td width='16%' align='center'> \r\n <a href='cGestionEtablissements.php?action=demanderSupprimerEtab&id=" . $unEtab->getId() . "'>\r\n Supprimer</a></td>";
} else {
echo "\r\n <td width='16%'> </td>";
}
$type = $_REQUEST['type'];
$civiliteResponsable = $_REQUEST['civiliteResponsable'];
$nomResponsable = $_REQUEST['nomResponsable'];
$prenomResponsable = $_REQUEST['prenomResponsable'];
if ($action == 'validerCreerEtab') {
verifierDonneesEtabC($connexion, $id, $nom, $adresseRue, $codePostal, $ville, $tel, $nomResponsable);
if (nbErreurs() == 0) {
EtablissementDao::creerModifierEtablissement($connexion, 'C', $id, $nom, $adresseRue, $codePostal, $ville, $tel, $adresseElectronique, $type, $civiliteResponsable, $nomResponsable, $prenomResponsable);
include "vues/GestionEtablissements/vObtenirEtablissements.php";
} else {
include "vues/GestionEtablissements/vCreerModifierEtablissement.php";
}
} else {
verifierDonneesEtabM($connexion, $id, $nom, $adresseRue, $codePostal, $ville, $tel, $nomResponsable);
if (nbErreurs() == 0) {
EtablissementDao::creerModifierEtablissement($connexion, 'M', $id, $nom, $adresseRue, $codePostal, $ville, $tel, $adresseElectronique, $type, $civiliteResponsable, $nomResponsable, $prenomResponsable);
include "vues/GestionEtablissements/vObtenirEtablissements.php";
} else {
include "vues/GestionEtablissements/vCreerModifierEtablissement.php";
}
}
break;
}
// Fermeture de la connexion au serveur MySql
$connexion = null;
function verifierDonneesEtabC($connexion, $id, $nom, $adresseRue, $codePostal, $ville, $tel, $nomResponsable)
{
if ($id == "" || $nom == "" || $adresseRue == "" || $codePostal == "" || $ville == "" || $tel == "" || $nomResponsable == "") {
ajouterErreur('Chaque champ suivi du caractère * est obligatoire');
}
if ($id != "") {
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>test DAO</title>
</head>
<body>
<?php
use modele\Connexion;
use modele\dao\EtablissementDao;
use modele\metier\Etablissement;
require "../includes/fonctions.inc.php";
//require_once("../modele/Connexion.class.php");
//require_once("../modele/dao/AttributionDao.class.php");
//require_once("../modele/dao/EtablissementDao.class.php");
//require_once("../modele/dao/GroupeDao.class.php");
//require_once("../modele/dao/OffreDao.class.php");
//require_once("../modele/dao/TypeChambreDao.class.php");
$pdo = Connexion::connecter();
$unEtab = new Etablissement("TEST", "etab test", "adresse test", "44444", "ville test", "0242042099", "", "", "monsieur", "duPON", "boul");
EtablissementDao::insert($unEtab);
var_dump($unEtab);
$unEtab2 = new Etablissement("TEST", "etab test modifié", "adresse test", "44444", "ville test", "0242042099", "", "", "monsieur", "duPON", "boul");
EtablissementDao::update("TEST", $unEtab2);
$pdo = Connexion::deconnecter();
?>
</body>
</html>
