$frqParticipante = new ForumQuestaoParticipanteController();
date_default_timezone_set("America/Sao_Paulo");
switch ($_REQUEST["acao"]) {
case "listaQuestoesRecentes":
if ($_POST['texto'] != '') {
$questoes = $questaoController->selectComleta($_POST['texto']);
} else {
$questoes = $questaoController->selectUltimas(5);
}
$html = '';
if (count($questoes) > 0) {
$viewController = new ForumViewController();
$dataFuncao = new DatasFuncao();
foreach ($questoes as $q) {
$totalViews = $viewController->totalByQuestao($q->getFrq_id());
$totalRespostas = $respostasController->totalByQuestao($q->getFrq_id());
if ($totalViews == 1) {
$msgView = '<span id="totalVisTexto' . $q->getFrq_id() . '"><span id="totalVis' . $q->getFrq_id() . '">1</span> visualização</span>';
} else {
$msgView = '<span id="totalVisTexto' . $q->getFrq_id() . '"><span id="totalVis' . $q->getFrq_id() . '">' . $totalViews . '</span> visualizaçôes</span>';
}
if ($totalRespostas == 1) {
$totalRespostas = '<span id="totalRespTexto' . $q->getFrq_id() . '"><span id="totalResp' . $q->getFrq_id() . '">1</span> resposta</span>';
} else {
$totalRespostas = '<span id="totalRespTexto' . $q->getFrq_id() . '"><span id="totalResp' . $q->getFrq_id() . '">' . $totalRespostas . '</span> respostas</span>';
}
//$data = substr(str_replace(' ',' às ',$q->getFrq_data()),0,-3);
$data = $dataFuncao->dataBR($q->getFrq_data());
$html .= '<div class="ln_box ln_box caixaQuestao" style="cursor: pointer" onClick="listaRespostas(' . $q->getFrq_id() . ')" id="' . $q->getFrq_id() . '">
<p class="ln_pergunta">' . utf8_encode($q->getFrq_questao()) . '</p>
<div class="ln_info row">
public function getQuestao($idQuestao)
{
$userController = new UsuarioController();
$forumController = new ForumQuestaoController();
$frqController = new ForumQuestaoParticipanteController();
$viewController = new ForumViewController();
$respostasController = new ForumRespostaController();
$logado = unserialize($_SESSION['USR']);
$id = $logado['id'];
$resp = $forumController->select($idQuestao);
$usuario = $userController->select($resp->getFrq_usuario());
$respostas = $respostasController->totalByQuestao($resp->getFrq_id());
$frqId = $resp->getFrq_id();
$frqQuestao = utf8_encode($resp->getFrq_questao());
$frqUsuario = utf8_encode($usuario->getUsr_nome());
$frqData = DatasFuncao::dataTimeBRExibicao($resp->getFrq_data());
$usrNome = utf8_encode($logado["nome"]);
$marginRight = "";
if ($viewController->verificaUsuarioByQuestao($id, $idQuestao) == 0) {
$view = new ForumView();
$view->setFrv_questao($idQuestao);
$view->setFrv_usuario($id);
$view->setFrv_data(date('Y-m-d h:i:s'));
$viewController->insert($view);
}
if (file_exists("imgp/" . $userController->buscaFotoByIdUsuario($id))) {
$usrFoto = $userController->buscaFotoByIdUsuario($id);
} else {
$usrFoto = "default.png";
}
if (file_exists("imgp/" . $usuario->getUsr_imagem())) {
$foto = $usuario->getUsr_imagem();
} else {
$foto = 'default.png';
}
if (count($respostas) > 4) {
$marginRight = "margin_right";
}
$html = "<div id=\"box_topico\" class=\"row\">";
$html .= "<p class=\"foto_aluno col-xs-1 col-md-1 col-lg-1\">";
$html .= "<img src=\"imgp/{$foto}\">";
$html .= "</p>";
$html .= "<div class=\"col-xs-11 col-md-11 col-lg-11\">";
$html .= "<p class=\"dados_aluno\">";
$html .= "<span class=\"aluno_nome\">{$frqUsuario}</span>";
$html .= "<span class=\"aluno_data\">Postado dia {$frqData}</span>";
$html .= "</p>";
$html .= "<p>";
$html .= "<span class=\"resp_aluno\">{$frqQuestao}</span>";
$html .= "</p>";
$html .= "</div>";
$html .= "</div>";
$html .= "<div id=\"box_Respostas_container\">";
$html .= "<div id=\"box_Respostas\">";
$html .= "<div id=\"fbCarregandoFrr\" class=\"alert alert-warning\">Carregando respostas...</div>";
$html .= "</div>";
$html .= "<div id=\"containerCarregarRespostas\" style=\"display:none;\">";
$html .= "<button id=\"btnCarregarFrr\" data-min=\"5\" type=\"button\" class=\"btn\">Carregar mais</button>";
$html .= "</div>";
$html .= "</div>";
$html .= "<div id=\"box_nova_resposta\">";
$html .= "<div id=\"campo_resp\">";
$html .= "<p class=\"foto_aluno col-xs-1 col-md-1 col-lg-1\">";
$html .= "<img src=\"imgp/{$usrFoto}\">";
$html .= "</p>";
$html .= "<div class=\"col-xs-11 col-md-11 col-lg-11\">";
$html .= "<div class=\"dados_aluno\">";
$html .= "<form id=\"formNovaResposta\" class=\"form\">";
$html .= "<input type=\"hidden\" name=\"acao\" value=\"NovaRespostaQuestao\" />";
$html .= "<input type=\"hidden\" name=\"usuario\" value=\"{$id}\" />";
$html .= "<input type=\"hidden\" name=\"questao\" value=\"{$frqId}\" />";
$html .= "<textarea id=\"resp_forum\" name=\"resposta\" placeholder=\"Digite aqui sua resposta!\"></textarea>";
$html .= "</form>";
$html .= "<button class=\"btn btn-primary\" id=\"btn_pronto\" idAluno=\"{$id}\">Responder</button>";
$html .= "<div style=\"clear:both;\"></div>";
$html .= "</div>";
$html .= "</div>";
$html .= "</div>";
$html .= "</div>";
echo $html;
}
<![endif]-->
<script src="//use.typekit.net/rtp0aku.js"></script>
<script>try {
Typekit.load();
} catch (e) {
}</script>
</head>
<body>
<input type="hidden" id="idfrq" value="<?php
echo $_GET["resp"];
?>
"/>
<input type="hidden" id="frrQtde" value ="<?php
echo $respostasController->totalByQuestao($_GET["resp"]);
?>
"/>
<!--Conteudo Geral-->
<div id="container">
<!--Topo-->
<div class="row">
<?php
$templateGeral->topoSite();
?>
</div>
<!--Conteudo Central-->
<div id="Conteudo_Area">
<div class="row">
<div class="row">
public function listaAlunos()
{
$forumController = new ForumQuestaoController();
$viewController = new ForumViewController();
$respController = new ForumRespostaController();
$frqParticipante = new ForumQuestaoParticipanteController();
$dataFuncao = new DatasFuncao();
$idusr = unserialize($_SESSION["USR"])["id"];
$idesc = unserialize($_SESSION["USR"])["escola"];
$questoes = [];
if ($idesc) {
$questoes = $forumController->selectAprovadasByEscola($idesc);
} else {
$questoes = $forumController->selectAllAprovadas($idesc);
}
$cont = 0;
function verificarAlteracaoQuestao($fqp, $frr)
{
$fqp_d = strtotime($fqp->getFqp_ultima_visualizacao());
$frr_d = strtotime($frr->getFrr_data());
if ($fqp_d - $frr_d < 0) {
return true;
} else {
return false;
}
}
foreach ($questoes as $key => $value) {
$resp = $respController->totalByQuestao($value->getFrq_id());
$labelNovo = "";
if ($frqParticipante->verificarParticipante($value->getFrq_id(), $idusr)) {
$fqp = $frqParticipante->getUltimaVisualizacao($value->getFrq_id(), $idusr);
$frr = $respController->getMaisRecenteByQuestao($value->getFrq_id());
if ($frr && verificarAlteracaoQuestao($fqp, $frr)) {
$labelNovo = "<span class=\"badge\">Novo</span>";
}
}
if ($cont % 2 == 0) {
$caixaGrande = "cx_rosa";
$caixaPequena = "cx_brancaP";
} else {
$caixaGrande = "cx_branca";
$caixaPequena = "cx_rosaP";
}
if (file_exists("imgp/" . $value->getFrq_usuario()->getUsr_imagem())) {
$foto = $value->getFrq_usuario()->getUsr_imagem();
} else {
$foto = 'default.png';
}
$idfrq = $value->getFrq_id();
$frq = utf8_encode($value->getFrq_questao());
$usr = utf8_encode($value->getFrq_usuario()->getUsr_nome());
$frt = utf8_encode($value->getFrq_topico()->getFrt_topico());
$data = $dataFuncao->dataTimeBRExibicao($value->getFrq_data());
$views = $value->getFrq_visualizacoes();
echo '<a href="forumResposta.php?resp=' . $idfrq . '" id="caixaQuestao' . $idfrq . '">';
echo '<div id="perg_box' . $idfrq . '" class="perg_box ' . $caixaGrande . ' row">';
echo '<div class="perg_box_1 col-xs-12 col-md-7 col-lg-7">';
echo '<p class="foto_aluno"><img src="imgp/' . $foto . '"></p>';
echo '<p class="perg_aluno questaoTexto" id="' . $idfrq . '">' . $frq . ' ' . $labelNovo . '</p>';
echo '<p class="nome_aluno">' . $usr . '</p>';
echo '<p class="post_data">Tópico: ' . $frt . ' | Postado dia ' . $data . '</p>';
echo '</div>';
echo '<div class="perg_box_2 col-xs-12 col-md-5 col-lg-5">';
echo '<p id="qtd_visu' . $idfrq . '" class="qtd_visu ' . $caixaPequena . '"><span>' . $views . '</span> visualizações</p>';
echo '<p id="qtd_resp' . $idfrq . '" class="qtd_resp ' . $caixaPequena . '"><span>' . $resp . '</span> respostas</p>';
echo '</div>';
echo '</div>';
echo '</a>';
$cont++;
}
}
