function __construct()
{
$this->id = $_POST['id'];
$this->cnx = parent::getCnx();
$this->mesQuestions = Sondage::getQuestions($this->cnx, $this->id);
$this->nomFichier = "statistiques_sondage_" . $this->id . ".csv";
}
public function verificationInscription()
{
//NOUVEL UTILISATEUR AVEC IP
$cnx = parent::getCnx();
$user = new User($cnx, true, $_SERVER["REMOTE_ADDR"]);
//INSCRIPTION DANS LA TABLE USER
$user->ajouterUser();
//INSCRIPTION DANS LA TABLE MEMBRE
$mail = $_POST['mail'];
$mdp = $_POST['mdp1'];
$id = $user->getId();
$ip = $user->getIp();
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$adresse = $_POST['adresse'];
$cp = $_POST['cp'];
$ville = $_POST['ville'];
$qualite = "FO";
//NOUVEAU MEMBRE
$membre = new Membres($mail, $mdp, $id, $ip, $nom, $prenom, $adresse, $cp, $ville, $qualite);
if ($membre->authentification($cnx) == FALSE) {
if ($membre->ajouterMembre($cnx)) {
return 1;
} else {
return -1;
}
} else {
return 0;
}
}
function __construct()
{
$this->mesQuestions = Sondage::getQuestions(parent::getCnx(), $_SESSION['id']);
if (isset($_REQUEST['action'])) {
if ($_REQUEST['action'] == 'suppr') {
$this->mesQuestions[$_REQUEST['id']]->supprimerQuestion(parent::getCnx());
}
}
}
public function verificationLogin()
{
$membres = new Membres($_POST['mail'], $_POST['mdp']);
$resultat = $membres->authentification(parent::getCnx());
if ($resultat != false) {
//SI LE MEMBRE AUTHENTIFIE EST UN ADMIN
if ($resultat['QUALITE'] == 'BO') {
//INSTANCIATION D'UN ADMINN UNIQUE
$object_membre = new Admin($resultat['MAIL_USER'], $resultat['MDP_USER'], $resultat['ID_USER'], $resultat['IP'], $resultat['NOM_USER'], $resultat['PRENOM_USER'], $resultat['ADRESSE_USER'], $resultat['CP_USER'], $resultat['VILLE_USER'], $resultat['QUALITE']);
} else {
//INSTANCIATION D'UN MEMBRE
$object_membre = new Membres($resultat['MAIL_USER'], $resultat['MDP_USER'], $resultat['ID_USER'], $resultat['IP'], $resultat['NOM_USER'], $resultat['PRENOM_USER'], $resultat['ADRESSE_USER'], $resultat['CP_USER'], $resultat['VILLE_USER'], $resultat['QUALITE']);
}
//SERIALISATION DE L'ADMIN OU DU MEMBRE
$obj_serialise = serialize($object_membre);
//ON STOCKE L'OBJET SERIALISE EN SESSION
$_SESSION['membre'] = $obj_serialise;
$_SESSION['idMembre'] = $resultat['ID_USER'];
//Redirection vers la page Index
header('Location: index.php?page=Default');
}
}
public function getSujet()
{
$sujet = new Sujet();
return $sujet->getSujet(parent::getCnx());
}
public function getMesSondages()
{
$membre = unserialize($_SESSION['membre']);
$tab = $membre->recupererMesSondages(parent::getCnx());
$str = "";
$str .= "<center>";
$str .= "<table border = '1' id = 'hor-minimalist-b'><thead><tr><th scope='col'>Libelle</th><th scope='col' width ='150'>Type</th><th scope='col' width ='150'>Date cloture</th><th scope='col' width ='150'>Publication</th><th scope='col' width ='150'>URL</th><th scope='col' width ='150'>Etat</th><th scope='col' width ='150'>Actions</th></tr></thead>";
for ($i = 0; $i < COUNT($tab); $i++) {
$str .= "<tr>";
$str .= "<td>" . $tab[$i]->getNom() . "</td>";
if ($tab[$i]->getType() == 0) {
$str .= "<td>PUBLIC</td>";
} else {
$str .= "<td>PRIVE</td>";
}
if ($tab[$i]->getDateCloture() != "") {
$str .= "<td>" . $this->formaterDate($tab[$i]->getDateCloture()) . "</td>";
} else {
$str .= "<td></td>";
}
if ($tab[$i]->getEtat() == 0) {
$str .= "<td>PAS PUBLIE</td>";
} else {
$str .= "<td>PUBLIE</td>";
}
$str .= "<td><a href = " . $tab[$i]->getUrl() . ">" . $tab[$i]->getUrl() . "</a></td>";
switch ($tab[$i]->getStatut()) {
case 0:
$disabled = "";
$str .= "<td></td>";
break;
case 1:
$disabled = "disabled";
$str .= "<td>Demande de modification envoyee a l'administrateur</td>";
break;
case 2:
$disabled = "";
$str .= "<td>Modification autorisee par l'administrateur</td>";
break;
case 3:
$disabled = "disabled";
$str .= "<td>Modification refusee par l'administrateur</td>";
break;
case 4:
$disabled = "disabled";
$str .= "<td>Cloturee</td>";
break;
}
if ($tab[$i]->getDateCloture() != "") {
$str .= "<td><form method='POST' action = 'index.php?page=Statistiques'><input type = 'hidden' name = 'id' value = '" . $tab[$i]->getId() . "'><input type='submit' value='STATISTIQUES' name='stats' class ='rounded gkbutton'/></td></form>";
} else {
if ($tab[$i]->getEtat() == 0) {
$str .= "<td><form method='POST'><input type = 'hidden' name = 'id' value = '" . $i . "'><input type='submit' value='SUPPRIMER' name='supprimer' class ='rounded gkbutton'/><input type='submit' value='PUBLIER' name='publier' class ='rounded gkbutton'/><input type='submit' value='MODIFIER' name='modifier' class ='rounded gkbutton'/></td></form>";
} else {
$str .= "<td><form method='POST'><input type = 'hidden' name = 'id' value = '" . $i . "'><input type='submit' value='SUPPRIMER' name='supprimer' class ='rounded gkbutton'/><input type='submit' value='MODIFIER' name='modifier' class ='rounded gkbutton' " . $disabled . "></td></form>";
}
}
$str .= "</tr>";
}
$str .= "</center>";
$str .= "</table>";
if (isset($_POST['supprimer'])) {
if ($tab[$_POST['id']]->getNombreQuestions(parent::getCnx()) == 0) {
if ($tab[$_POST['id']]->supprimerSondage(parent::getCnx())) {
header('Location: index.php?page=MesSondages');
}
} else {
$str .= "Ce sondage ne peut pas etre supprime";
}
}
//ACTION DE L'UTILISATEUR SUR LE SONDAGE
if (isset($_POST['publier'])) {
if ($tab[$_POST['id']]->getNombreQuestions(parent::getCnx()) <= 4) {
$str .= "Vous devez ajouter au moins 5 questions";
} else {
if ($tab[$_POST['id']]->publierSondage(parent::getCnx())) {
header('Location: index.php?page=MesSondages');
}
}
}
if (isset($_POST['modifier'])) {
switch ($tab[$_POST['id']]->getStatut()) {
case 0:
if ($tab[$_POST['id']]->getEtat() == 0) {
$_SESSION['id'] = $tab[$_POST['id']]->getId();
header('Location: index.php?page=Questions');
} else {
$tab[$_POST['id']]->demanderModification(parent::getCnx());
header('Location: index.php?page=MesSondages');
}
break;
case 1:
break;
case 2:
$_SESSION['id'] = $tab[$_POST['id']]->getId();
$tab[$_POST['id']]->modifierSondage(parent::getCnx());
header('Location: index.php?page=Questions');
break;
case 3:
break;
}
}
return $str;
}
public function getSondages()
{
$membre = unserialize($_SESSION['membre']);
$tab = $membre->administrationSondages(parent::getCnx());
$str = "";
$str .= "<center>";
$str .= "<table border = '1' id = 'hor-minimalist-b'><thead><tr><th scope='col'>Libelle</th><th scope='col' width ='150'>Type</th><th scope='col'>Date cloture</th><th scope='col' width ='150'>Publication</th><th scope='col' width ='150'>URL</th><th scope='col' width ='150'>Actions</th>";
for ($i = 0; $i < COUNT($tab); $i++) {
$bgcolor = "";
//SI MEMBRE DEMANDE UNE MODIFICATION
if ($tab[$i]->getStatut() == 1) {
$bgcolor = "bgcolor = 'red'";
} else {
if ($tab[$i]->getStatut() == 2) {
$bgcolor = "bgcolor = 'green'";
}
}
$str .= "<tr " . $bgcolor . ">";
$str .= "<td>" . $tab[$i]->getNom() . "</td>";
if ($tab[$i]->getType() == 0) {
$str .= "<td>PUBLIC</td>";
} else {
$str .= "<td>PRIVE</td>";
}
if ($tab[$i]->getDateCloture()) {
$str .= "<td>" . $this->formaterDate($tab[$i]->getDateCloture()) . "</td>";
} else {
$str .= "<td></td>";
}
if ($tab[$i]->getEtat() == 0) {
$str .= "<td>PAS PUBLIE</td>";
} else {
$str .= "<td>PUBLIE</td>";
}
$str .= "<td><a href = " . $tab[$i]->getUrl() . ">" . $tab[$i]->getUrl() . "</a></td>";
if ($tab[$i]->getStatut() == 1) {
$str .= "<td><form method='POST'><input type = 'hidden' name = 'id' value = '" . $i . "'><input type='submit' value='SUPPRIMER' name='supprimer' class = 'rounded gkbutton'/><input type='submit' value='ACCEPTER' name='accepter' class = 'rounded gkbutton'/><input type='submit' value='REFUSER' name='refuser' class = 'rounded gkbutton'/></td></form>";
} else {
if ($tab[$i]->getDateCloture() != "" || $tab[$i]->getEtat() == 0) {
$str .= "<td><form method='POST'><input type = 'hidden' name = 'id' value = '" . $i . "'><input type='submit' value='SUPPRIMER' name='supprimer' class = 'rounded gkbutton'/></td></form>";
} else {
$str .= "<td><form method='POST'><input type = 'hidden' name = 'id' value = '" . $i . "'><input type='submit' value='SUPPRIMER' name='supprimer' class = 'rounded gkbutton'/><input type='submit' value='CLOTURER' name='cloturer' class = 'rounded gkbutton'/></td></form>";
}
}
$str .= "</tr>";
}
$str .= "</center>";
$str .= "</table>";
//SELON L'ACTION EXECUTEE PAR L'ADMINISTRATEUR
if (isset($_POST['cloturer'])) {
$membre->cloturerSondage(parent::getCnx(), $tab[$_POST['id']]->getId());
header('Location: index.php?page=Administration');
}
if (isset($_POST['supprimer'])) {
$membre->supprimerSondage(parent::getCnx(), $tab[$_POST['id']]->getId());
header('Location: index.php?page=Administration');
}
if (isset($_POST['accepter'])) {
$membre->autoriserModificationSondage(parent::getCnx(), $tab[$_POST['id']]->getId());
header('Location: index.php?page=Administration');
}
if (isset($_POST['refuser'])) {
$membre->refuserModificationSondage(parent::getCnx(), $tab[$_POST['id']]->getId());
header('Location: index.php?page=Administration');
}
return $str;
}
