function ResultEnquete($numero)
{
require_once $_SESSION['DOCROOT'] . "/classes/class.enquete.php";
$Enq = new Enquete($numero);
$tv = $Enq->getVotos("TOTAL");
$perc = 0.0;
$vt = 0;
$wd = "";
$aux = "";
for ($x = 1; $x < 11; $x++) {
if ($Enq->getOpcao($x) != NULL) {
$vt = $Enq->getVotos($x);
if ($vt == 0) {
$perc = 0;
} else {
$perc = $vt / $tv * 100;
}
$wd = sprintf("%02.1d", 120 * $perc / 100);
echo '<tr>' . "\n";
echo '<td width=10%> </td>' . "\n";
echo '<td width=40%>' . "\n";
echo $Enq->getOpcao($x) . "\n";
echo '</td>' . "\n";
echo '<td width=50%>' . "\n";
echo "<IMG SRC='imagens/bluebar.gif' WIDTH='" . $wd . "' HEIGHT='9' ALT='" . sprintf("%2.1f", $perc) . "%'>" . "\n";
$aux = sprintf("%d (%2.1f%s)", $vt, $perc, '%');
echo $aux . "\n";
echo '</td>' . "\n";
echo '</tr>' . "\n";
}
}
echo "<tr><td colspan=3 align=center><br><br><b>Total de votos: " . $tv . "</td></tr>" . "\n";
}
/**
* edits enquete
*/
public function edit()
{
$json = $_POST['json'];
$json = stripslashes($json);
$enquete = json_decode($json, true);
$name = $enquete['name'];
$introduction = $enquete['introduction'];
$start_date = $enquete['start_date'];
$end_date = $enquete['end_date'];
$questions = $enquete['questions'];
$deleted_questions = $enquete['deleted_question'];
$deleted_attributes = $enquete['deleted_attributes'];
$enquete_id = $enquete['id'];
$user_id = $_SESSION['user_id'];
Enquete::edit($name, $introduction, $start_date, $end_date, $questions, $deleted_questions, $deleted_attributes, $enquete_id, $user_id);
}
include "head.php"; ?> <span class="titusr">Resultado Parcial da Enquete</span> <?php include "traco.php"; ?> <?php include "tophome.php"; ?> <table id="menuadm" border="0" cellspacing="0"> <?php require_once $_SESSION['DOCROOT'] . "/classes/class.enquete.php"; $numero = $_GET['enq']; $Enq = new Enquete($numero); include 'lst_enqresult.php'; echo '<tr><td colspan=3><b>' . $Enq->getPergunta() . '<br><br></td></tr>' . "\n"; ResultEnquete($numero); ?> </table> <?php include "bothome.php"; ?> <?php include "rodape.php";
<?php
include "sessao.php";
require_once $_SESSION['DOCROOT'] . "/classes/class.enquete.php";
$numero = $_POST['enquete'];
$Enq = new Enquete($numero);
$temerro = 0;
$javotou = FALSE;
if ($Enq->getTipoResposta() == 'U') {
if ($_POST['opcoes'] == NULL) {
$temerro = 1;
}
} else {
$temerro = 1;
for ($x = 1; $x < 11; $x++) {
$op = sprintf("op%02d", $x);
if ($_POST[$op] == 'S') {
$temerro = 0;
}
}
}
if ($Enq->getRestrita() == 'S' && $_SESSION['logado'] != 'SIM') {
$temerro = 2;
}
if ($temerro == 0) {
if ($Enq->ValidaVoto() == TRUE) {
$javotou = FALSE;
if ($Enq->getTipoResposta() == 'U') {
$Enq->RegistraVoto($_POST['opcoes']);
} else {
for ($x = 1; $x < 11; $x++) {
<?php
include "traco.php";
?>
<?php
include "tophome.php";
?>
<form method="post" action="prc_cadenquetes.php" name="CadEnquete" onload="loadfoco();">
<table id="tabform" border="0" cellspacing="0" width="440px">
<?php
require_once $_SESSION['DOCROOT'] . "/classes/class.enquete.php";
$numero = $_GET['enq'];
$enq = new Enquete($numero);
?>
<tr> <td><input type="hidden" name="codigo" value=" <?php
echo $enq->getCodigo();
?>
"> </td> </tr>
<tr> <td>
<fieldset width="430px" style="width:430px;" align="center">
<legend><span style="color:green;"><b>Pergunta</b></legend>
<input size="65" maxlength="50" tabindex="1" name="pergunta" value="<?php
echo $enq->getPergunta();
?>
">
</fieldset>
/**
* Gets enqeute by id
* @return array All Equetes
*/
public function get_all_enquetes()
{
return Enquete::get_all();
}
<a href="frm_cadenquetes.php?enq=0">Inclur Nova Enquete</a>
</td>
<td>
<a href="menu_admin.php">Menu Principal</a>
</td>
</tr>
<tr>
<td>
<br>
</td>
</tr>
<?php
require_once $_SESSION['DOCROOT'] . "/classes/class.enquete.php";
$enqs = Enquete::getEnquetes("T");
echo ' <tr class="cabec" align=left> <td>Pergunta</td> <td>Inicio</td><td>Fim</td></tr>' . "\n";
if (count($enqs) == 0) {
echo "<tr ><td colspan=7>Nenhuma enquete cadastrada.</td></tr>";
}
foreach ($enqs as $e) {
if ($fllin == 0) {
$fllin = 1;
echo ' <tr class="rel1"' . '>';
} else {
$fllin = 0;
echo ' <tr class="rel2"' . '>';
}
$dtini = sprintf('<a href="frm_cadenquetes.php?enq=%s">%s</a>', $e['numero'], date("d/m/Y", strtotime($e['datainicio'])));
$dtfim = sprintf('<a href="frm_cadenquetes.php?enq=%s">%s</a>', $e['numero'], date("d/m/Y", strtotime($e['datafim'])));
$per = sprintf('<a href="frm_cadenquetes.php?enq=%s">%s</a>', $e['numero'], $e['pergunta']);
public function Paginacao($order, $inicio, $fim)
{
$sql = "SELECT * FROM perguntas {$order} LIMIT {$inicio},{$fim}";
$stmt = $this->conexao->prepare($sql);
$stmt->execute();
$searchResults = array();
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
$temp = new Enquete();
$temp->setIdpergunta($rs->idpergunta);
$temp->setPergunta($rs->pergunta);
$temp->setStatus($rs->status);
array_push($searchResults, $temp);
}
return $searchResults;
}
<?php
Auth::verificaAcesso();
function __autoload($classe)
{
require_once "../../class/" . $classe . ".class.php";
}
ob_start();
$enquete = new Enquete();
$enqueteDAO = new EnqueteDAO();
$menuDAO = new MenuAdminDAO();
$menu = $menuDAO->getMenuPorTitulo("enquetes");
$idmenu = $menu->getIdmenu();
$acao = $_GET["acao"];
//$acao = "add";
switch ($acao) {
//cria uma enquete
case "add":
$act = "addresp";
$setPergunta = $_POST["pergunta"];
$setStatus = 0;
$enquete->setPergunta($setPergunta);
$enquete->setStatus($setStatus);
$enqueteDAO->InserePergunta($enquete);
$id = $enqueteDAO->getUltimoID();
header("location: ../principal.php?menu={$idmenu}&act={$act}&idpergunta={$id->idpergunta}");
break;
//adiciona uma resposta
//adiciona uma resposta
case "addresp":
$act = "addresp";
$lst = Enquete::getEnquetes("A");
if (count($lst) == 0) {
return;
}
?>
<div class="painel">
<div class="LeftCorner"> </div>
<div class="TitPainel">.:: Enquetes ::.</div>
<div class="RightCorner"> </div>
<div class="corpo">
<table cellpadding="0" cellspacing="0" frame="box" rules="none">
<?php
$vez = 0;
foreach ($lst as $e) {
$enq = new Enquete($e['numero']);
if ($vez != 0) {
echo '<tr> <td colspan=2>' . "\n";
echo '<hr style="height: 1px; width: 100%;" align="left">' . "\n";
echo '</td></tr>' . "\n";
}
$nomeform = sprintf("enq%04d", $enq->getCodigo());
echo ' <form method="post" action="prc_votaenq.php" name="' . $nomeform . '">' . "\n";
echo '<input type=hidden name="enquete" value="' . $enq->getCodigo() . '">' . "\n";
echo "<tr><td colspan=2>" . $enq->getPergunta() . "</td></tr>\n";
for ($x = 1; $x < 11; $x++) {
if ($enq->getOpcao($x) != NULL) {
if ($enq->getTipoResposta() == "U") {
echo '<tr><td colspan=2> <input type="radio" tabindex="' . $x . '" name="opcoes" value="' . $x . '">' . $enq->getOpcao($x) . '</td></tr>';
} else {
echo '<tr><td colspan=2> <input type="checkbox" tabindex="' . $x . '" name="' . sprintf("op%02d", $x) . '" value="S">' . $enq->getOpcao($x) . '</td></tr>';
function grava($codigo, $pergunta, $opcoes, $dia, $mes, $ano, $resposta, $restrita)
{
$temerro = 0;
$x = 0;
if (empty($pergunta)) {
echo "<tr><td>Informe a pergunta da enquete </td></tr>" . "\n";
$temerro = 1;
}
if (count($opcoes) < 2) {
echo "<tr><td>Informe pelo menos 2 opções para a enquete </td></tr>" . "\n";
$temerro = 1;
}
if (!checkdate($mes, $dia, $ano)) {
echo "<tr><td>Data de encerramento da enquete inválida !</td></tr>" . "\n";
$temerro = 1;
}
if (empty($resposta)) {
echo "<tr><td>Informe o tipo de resposta da enquete (Unica ou Multipla).</td></tr>" . "\n";
$temerro = 1;
}
if ($temerro == 1) {
include "volta.php";
} else {
$enq = new Enquete($codigo);
$enq->setPergunta($pergunta);
foreach ($opcoes as $op) {
$x++;
$enq->setOpcao($x, $op);
}
$enq->setDataFim($ano . "/" . $mes . "/" . $dia);
$enq->setTipoResposta($resposta);
$enq->setRestrita($restrita);
$enq->Grava();
echo "<tr><td><b>" . $enq->getPergunta() . "</td></tr>\n";
echo '<tr><td><br></td></tr>' . "\n";
echo "<tr><td>Enquete gravada com sucesso !</td></tr>\n";
echo '<tr><td><br></td></tr>' . "\n";
echo '<tr><td><br></td></tr>' . "\n";
echo '<tr><td><a href="lst_cadenquetes.php">OK</a></td></tr>' . "\n";
}
}