');
$query='SELECT * FROM liste_votes WHERE idVotation="' .$this->protect( $idVotation) .'"';
$result = $this->query($query);
$votes = $this->result->fetch_all(MYSQLI_ASSOC);
foreach ($votes as $vote)
{
switch ($vote["methode"])
{
case 1:
$total = 0;
echo "
" . $vote["libelle"] . "
";
$query='SELECT * FROM liste_candidats WHERE idVotation=' . $idVotation . ' AND idVote=' . $vote["id"];
$result = $this->query($query);
$candidats = $this->result->fetch_all(MYSQLI_ASSOC);
echo "
";
//$resultatCandidats = '';
$query='SELECT COUNT(*) as n FROM votes WHERE idVotation=' . $this->protect($idVotation) . ' AND idVote=' . $vote["id"] .' AND idCandidat=0';
$result = $this->query($query);
$resultat = $this->result->fetch_array(MYSQLI_ASSOC);
$blanc = $resultat["n"];
echo 'Votes blancs : ' . $blanc . '
';
foreach($candidats as $candidat)
{
$query='SELECT COUNT(*) as n FROM votes WHERE idVotation=' . $this->protect($idVotation) . ' AND idVote=' . $vote["id"] .' AND idCandidat=' . $candidat["id"];
$result = $this->query($query);
$resultat = $this->result->fetch_array(MYSQLI_ASSOC);
echo $candidat["candidat"] . ' :' . $resultat["n"] . '
';
$resultatCandidats[$candidat['candidat']] = $resultat["n"];
$total += $resultat["n"];
}
array_multisort($resultatCandidats, SORT_DESC, SORT_NUMERIC);
reset($resultatCandidats);
if ($total != 0)
{
if ($total >= $blanc)
{
print("Remporte le vote : " . key($resultatCandidats));
unset($resultatCandidats);
print("
");
}else
{
print("Aucun candidat n'emporte le vote, car il y a plus de 50% de votes blancs.
");
}
listeVotants($idVotation, $vote["id"], $listeAdherents);
}else
{
print("Aucun votant, le vote est annulé.
");
}
print("
" . EOLH);
break;
default:
break;
}
}
}else
{
print "Bonjour, vous pourrez consulter les résultats à partir du " . formattedate('fr', $votation['tf'] , "Europe/Paris") . "";
}
}
}
function liste_votants($idVotation)
{
$query = 'SELECT DISTINCT idVotant FROM liste_votes WHERE idVotation=' . $idVotation;
$this->query($query);
$votants = $this->result->fetch_all(MYSQLI_ASSOC);
$doliDB = new dbDolibarr();
foreach($votants as $votant)
{
$query ="SELECT login, firstname, lastname FROM llx_adherent WHERE login='" . $votant . "'";
$dolibarr->query($query);
$r = mysqli_fetch_array();
$listeVotants[$votant]["nom"] = $r["lastname"];
$listeVotants[$votant]["prenom"] = $r["firstname"];
}
return $listeVotants;
}
function queryVotationList()
{
$query = "SELECT * FROM liste_votations";
$this->query($query);
$votationLine = $this->result->fetch_all(MYSQLI_ASSOC);
foreach ($votationLine as $line)
{
$votationList[$line["id"]] = $line;
}
return $votationList;
}
function queryVotationName($idVotation) :string
{
$query = "SELECT libelle FROM liste_votations WHERE id='" . $idVotation . "'";
$this->query($query);
$votationLine = $this->result->fetch_assoc();
return $votationLine["libelle"];
}
function queryVoteList($idVotation)
{
$query = "SELECT * FROM liste_votes WHERE idVotation = " . idVotation;
$this->query($query);
$votes = $this->result->fetch_all(MYSQLI_ASSOC);
foreach ($votes as $line)
{
$votesList[$line["id"]] = $line;
}
return $votesList;
}
function queryVoteName($idVote)
{
$query = "SELECT libelle FROM liste_votes WHERE id='" . $idVote . "'";
$this->query($query);
$voteLine = $this->result->fetch_assoc();
return $voteLine["libelle"];
}
function queryVotes($idVotation)
{
$query = "SELECT lv.id, lv.libelle, ms.libelle as methode FROM liste_votes as lv LEFT JOIN methods as ms ON lv.methode=ms.id WHERE idVotation='" . $idVotation . "'";
$this->query($query);
$votes = $this->result->fetch_all(MYSQLI_ASSOC);
return $votes;
}
function queryCandidatsList($idVotation, $idVote)
{
$query = "SELECT * FROM liste_candidats WHERE idVotation='" . $idVotation . "' AND idVote='" . $idVote . "'";
$this->query($query);
$candidats = $this->result->fetch_all(MYSQLI_ASSOC);
foreach ($candidats as $line)
{
$candidatsList[$line["id"]] = $line;
}
return $candidatsList;
}
}
function queryCandidatName($idCandidat)
{
$query = "SELECT libelle FROM liste_candidats where id='" . $idCandidat . "'";
$this->query($query);
$line = $this->result->fetch_assoc();
return $line["candidat"];
}
?>