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"; } }