public function showAll()
{
session_start();
$login = new Login();
$id = $login->isLogged();
if ($id) {
$user = new User($id);
$regNumber = $user->regNumber;
$data["user"] = $user;
//echo $regNumber;
} else {
header('Location: http://localhost/WEB_Projeto_Final/public_html/home');
}
$show_questions = new Questao();
$results = $show_questions->getAll();
$getSubjects = $show_questions->getSubjects($regNumber);
//var_dump($getSubjects);
$data["subjects"] = array_unique($getSubjects);
$data['questions'] = $results;
$data['images'] = $show_questions->getImages($results);
$data['answers'] = $show_questions->getAnswer($results);
$this->view('questoes/listar', $data);
// echo $result[0]->value;
// var_dump($results);
}
public function selectFull()
{
$sql = "select * from questao";
$result = $this->retrieve($sql);
$lista = array();
while ($qr = mysqli_fetch_array($result)) {
$ques = new Questao();
$ques->setQst_id($qr["qst_id"]);
$ques->setQst_numero($qr["qst_numero"]);
$ques->setQst_questao($qr["qst_questao"]);
$ques->setQst_exercicio($qr["qst_exercicio"]);
array_push($lista, $ques);
}
return $lista;
}
<?php include_once '../config.php'; include_once ROOT . "model/mysql.php"; include ROOT . "model/admin/questao.php"; $questao = new Questao(); echo $questao->anteriorid(11);
<?php
require '../../../config.php';
require ROOT . 'model/admin/questao.php';
$questao_cdg = $_POST['questao_cdg'];
$questao = new Questao($questao_cdg);
// $questao->gravar('', '', '0', '', '', '', '', '', '', '1', '1', '1', NULL, NULL, NULL);
$questao_inserida = $questao->gravar($_POST['pergunta'], $_POST['imagem'], $_POST['imagem_pos'], $_POST['texto'], $_POST['opcao1'], $_POST['opcao2'], $_POST['opcao3'], $_POST['opcao4'], $_POST['opcao5'], $_SESSION['USUARIO_CDG'], $_POST['revisor_cdg'], $_POST['materia'], isset($_POST['assunto']) ? $_POST['assunto'] : null, isset($_POST['tipo']) ? $_POST['tipo'] : null, isset($_POST['descritor']) ? $_POST['descritor'] : null);
if ($questao_inserida != -1) {
$questao_cdg = $questao_inserida;
}
header("Location: " . ROOT_URL . "control/cadastros/questoes/edit_questao.php?q=" . $questao_cdg . "&s=s");
<?php
include_once '../../config.php';
include ROOT . "model/admin/questao.php";
$questao_cdg = isset($_GET['q']) ? $_GET['q'] : -1;
$questao = new Questao();
if ($questao_cdg != -1) {
if ($questao->duplicar_questao($questao_cdg)) {
header('Location: ' . ROOT_URL . 'view/admin/edit_questao.php?q=' . $questao->ultima_questao_inserida() . '&s=c');
}
}
<?php
/** seta o fuso horario padrão com o de fortaleza */
date_default_timezone_set("America/Fortaleza");
/** @var Questao */
$questoesBusiness = Questao::getInstance();
/** @var array dados das questoes selecionadas */
$questoes = $questoesBusiness->buscarPorCapitulo((int) $url->getURL(1), $idUsuario);
/** @var Exercicio */
$exerciciosBusiness = Exercicio::getInstance();
/** Recebe o formulario */
$form = filter_input_array(INPUT_POST, FILTER_DEFAULT);
if (isset($form['salvar'])) {
/** @var int pontuação total do aluno */
$sum = 0;
/** */
$qtdQuestoes = 0;
/** */
unset($form['salvar']);
/** */
foreach ($form as $questao => $resposta) {
$res = $questoesBusiness->buscarItem($resposta);
$sum += $res[0]['valor'];
$qtdQuestoes++;
}
/** */
$nota = $sum * 10 / $qtdQuestoes;
/** */
$dados = array("idCapitulo" => $url->getURL(1), "idUsuario" => $idUsuario, "nota" => $nota, "data" => date("Y-m-d H:i:s"));
/** */
$exerciciosBusiness->cadastrar($dados);
public function delete($params = null)
{
session_start();
if (!empty($params)) {
$question = $params[0];
$delete_question = new Questao();
$delete_question->deletar($question);
}
}
<?php include '../../../config.php'; include ROOT . "view/vhead.php"; require ROOT . 'view/admin/vheader_admin.php'; include_once ROOT . 'model/admin/questao.php'; $pesquisa = isset($_POST['pesquisa']) ? $_POST['pesquisa'] : -1; $descritor = isset($_GET['d']) ? $_GET['d'] : -1; $questao = new Questao(); $questoes = $questao->lista_questoes($pesquisa, $descritor); $action_pesquisa = ROOT_URL . 'control/cadastros/questoes/index.php'; include ROOT . 'view/cadastros/questoes/vquestoes.php';
