TurkShell v1.0

Owner : www-data

PHP Version

5.6.40-0+deb8u12

Disk Space

40.84 GB

Server Addr

19-www4

Your IP

10.10.10.40

Edit File

File:

<%-- 
    Document   : listaturma
    Created on : 15/02/2016, 15:10:38
    Author     : Rafael
--%>

<%@page import="br.ler.map.Turma"%>
<%@page import="br.ler.control.Hash"%>
<%@page import="java.util.List"%>
<%@page import="br.ler.map.ObjetoSub"%>
<%@page import="br.ler.jdbc.UsuarioDAO"%>
<%@page import="br.ler.map.Usuario"%>

<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
    <head>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link href="css/bootstrap.min.css" rel="stylesheet">
        <link href="css/mystyle.css" rel="stylesheet">
        <link href="css/style.css" rel="stylesheet">
        <link href="css/my_page.css" rel="stylesheet">
        <meta charset="UTF-8">
        <link rel="shortcut icon" href="img/icon.ico"/>
        <%
            //Usuario user = (Usuario) request.getAttribute("criptUser");
            List<Usuario> membros = (List<Usuario>) request.getAttribute("listMembro");
            String turma = (String) request.getAttribute("turma");
            Usuario us = (Usuario) request.getAttribute("criptUserObject");
            UsuarioDAO d = new UsuarioDAO();
        %>
        <script src="js/jquery-latest.js"></script>
        <script>
            $(document).ready(function () {
                $('#SearchMem').keyup(function (event) {
                    var username = $('#SearchMem').val();
                    $.get('action', {userMem: username, codTurm: <%=turma%>, codUsMain: <%=us.getCod()%>}, function (responseText) {
                        var json = JSON.parse(responseText);
                        var out = "";
                        document.getElementById("showMem").style.display = "block";
                        if (responseText.valueOf() !== "{}") {
                            for (i = 0; i < json.length; i++) {
                                out += "<button value='" + json[i].cod + "' style='font - size: 90px;' id='codnewMem' name='codnewMem' class='btn-link pull-right'>";
                                out += "<h1><span style='font - size: 90px;' class='pull-right glyphicon-plus text-primary'></span></h1>";
                                out += "</button>";
                                out += "<img id='showImgMem' style='margin: 0 auto; ' class='img-responsive img-full img-circle ' src='img/" + json[i].codMD + "' alt='' height='65' width='65'>";
                                out += "<p id='showNameMem' class='text-center' style='margin-left: -30px;'>" + json[i].nome + "</p>";
                                out += "<p id='showSchoolMem' style=' font-size: 12px; margin-left: -35px;' class='text-center'>" + json[i].inst + "</p>";
                            }
                            out += "";
                        }
                        document.getElementById("showMembros").innerHTML = out;
                        if (username.length < 1) {
                            document.getElementById("showMem").style.display = "none";
                        }
                    });
                });
            });
        </script>
        
        <script>
            $(document).ready(function () {
                $('#SearchMat').keyup(function (event) {
                    var username = $('#SearchMat').val();
                    $.get('action', {userMat: username, codTurm: <%=turma%>, codUsMain: <%=us.getCod()%>}, function (responseText) {
                        var json = JSON.parse(responseText);
                        var out = "";
                        if (responseText.valueOf() !== "{}") {
                            document.getElementById("showMat").style.display = "block";
                            for (i = 0; i < json.length; i++) {
                                out += "<button value='" + json[i].cod + "' id='codnewMat' name='codnewMat' class='btn-link pull-right'>";
                                out += "<span style='font-size: 30px;' class='pull-right glyphicon-plus text-primary'></span>";
                                out += "</button>";
                                out += "<p id='MatTitle' style='font-size: 18px;'>" + json[i].title + "</p>";
                                out += "<br>";
                            }
                            document.getElementById("showMat").innerHTML = out;
                        }
                        if (username.length < 1) {
                            document.getElementById("showMat").style.display = "none";
                        }
                    });
                });
            });
        </script>
        <title><%=d.upperCaseFirst(us.getNome())%></title>
        <style>
            /* Tooltip */
            .test + .tooltip > .tooltip-inner {
                background-color: whitesmoke;
                opacity:0.80;
                -moz-opacity: 0.60;
                filter: alpha(opacity=45);
                color: #000000; 
                border: 0.5px solid brown; 
                padding: 14px;
                font-size: 14px;
                font-weight: bold;
            }
            /* Tooltip on top */
            .test + .tooltip.top > .tooltip-arrow {
                border-top: 5px solid brown;
            }
            /* Tooltip on bottom */
            .test + .tooltip.bottom > .tooltip-arrow {
                border-bottom: 5px solid brown;
            }
            /* Tooltip on left */
            .test + .tooltip.left > .tooltip-arrow {
                border-left: 5px solid brown;
            }
            /* Tooltip on right */
            .test + .tooltip.right > .tooltip-arrow {
                border-right: 5px solid brown;
            }
        </style>
        <script>
            $(document).ready(function () {
                $('[data-toggle="tooltip"]').tooltip();
            });
        </script>
    </head>
    <script>
        function getValueObject()
        {
            var x = document.getElementById("objectOk");
            alert(x.innerHTML);
        }
    </script>
    <body>
        <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
                           url="jdbc:mysql://localhost/ler"
                           user="ler"  password="f36bgh81a"/>
        <div class="navbar navbar-default navbar-fixed-top">
            <div class="container">
                <div class="navbar-right pull-right">
                    <ul class="nav navbar-nav navbar-left pull-right">
                        <li class="dropdown">
                            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                                <strong>
                                    <%=d.upperCaseAllFirst(d.firstName(us.getNome()))%>&nbsp;
                                    <%if (us.getImg().equals("yes")) {%>
                                    <img style="margin-top: -11px; margin-right: 10px;" class=" img-full img-circle pull-right" src="img/<%=session.getAttribute("encryptUserObject")%>/<%=session.getAttribute("encryptUserObject")%>.jpg" alt="Smiley face" height="42" width="42">
                                    <%} else {%>
                                    <button height="42" width="42" class="btn btn-warning btn-circle-sm navbar-btn pull-right" style="margin-top: -11px; margin-right: 10px;"><strong style="font-size: 20px;" id="namefacelocale" class="text-uppercase"><%=us.getNome().substring(0, 1)%></strong></button>
                                    <%}%>
                                </strong>
                            </a>
                            <ul class="dropdown-menu">
                                <li>
                                    <form class="form-horizontal" action="action?pag=materiaisManuseados" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-repeat" style="margin-left: 0px;"><font size="3"> 
                                            Utlimos Lidos
                                            </font>
                                        </button>
                                    </form>
                                </li>
                                <li>
                                    <form class="form-horizontal" action="action?pag=userFavorito" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-heart" style="margin-left: 0px;">
                                            <font size="3"> Favoritos</font>
                                        </button>
                                    </form>
                                </li>
                                <li>
                                    <form class="form-horizontal" action="action?pag=userMaterial" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-book" style="margin-left: 0px;"><font size="3"> 
                                            Meus Materiais
                                            </font>
                                        </button>
                                    </form>
                                </li>
                                <hr>
                                <li>
                                    <form class="form-horizontal" action="action?pag=userTurma" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-blackboard" style="margin-left: 0px;"><font size="3"> Turmas</font></button>
                                    </form>
                                </li>
                                <li>
                                    <form class="form-horizontal" action="action?pag=userRelatorio" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-stats" style="margin-left: 0px;"><font size="3"> Relatórios</font></font></button>
                                    </form>
                                </li>
                                <li>
                                    <form class="form-horizontal" action="action?pag=userPerfil" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-user" style="margin-left: 0px;"><font size="3"> Perfil</font></button>
                                    </form>
                                </li>
                                <hr>
                                <li>
                                    <form class="form-horizontal" action="action?pag=about" method="POST">
                                        <button class="btn btn-link glyphicon glyphicon-info-sign" style="margin-left: 0px;"><font size="3"> Informações</font></button>
                                    </form>
                                </li>
                                <li>
                                    <form class="form-horizontal" action="action?pag=Logout" method="POST">
                                        <button value="Logout" class=" btn btn-link glyphicon glyphicon-off" style="margin-left: 0px;"><font size="3"> Sair</font></button>
                                    </form>
                                </li>
                            </ul>
                        </li>
                    </ul>
                </div>
                <form class="form-horizontal" action="action?pag=home" method="POST">
                    <button class="btn btn-default navbar-btn pull-left " style="margin-left: -4px; margin-top: 8px;"><font size="3"> Inicio</font></button>
                </form>
<button class="navbar-toggle pull-right" data-toggle ="collapse" data-target ="#buscarMaterial">
                    <span class="glyphicon glyphicon-search"></span>
                </button>
                <div class="pull-right collapse navbar-collapse" id="buscarMaterial">
                    <ul class="nav navbar-nav">
                        <form class="navbar-form" action="action?pag=searchObject" method="POST" enctype="multipart/form-data">
                            <div class="input-group">
                                <input type="text" class="form-control" placeholder="Buscar material" name="typeTextSearch">
                                <div class="input-group-btn">
                                    <button href="#" class="dropdown-toggle btn btn-default" type="submit" data-toggle="dropdown"><i class="glyphicon glyphicon-search"></i> <b class="caret"></b></button>
                                    <ul class="pull-right dropdown-menu">
                                        <li>
                                            <button name="typeSearch" value="book" class="btn btn-link glyphicon glyphicon-book" style="margin-left: 8px;"> Livros</button>
                                        </li>
                                        <li>
                                            <button name="typeSearch" value="file" class="btn btn-link glyphicon glyphicon-file" style="margin-left: 8px;"> Apostilas</button>
                                        </li>
                                        <li>
                                            <button name="typeSearch" value="bookmark" class="btn btn-link glyphicon glyphicon-bookmark" style="margin-left: 8px;"> Artigos</button>
                                        </li>
                                        <li>
                                            <button name="typeSearch" value="flag" class="btn btn-link glyphicon glyphicon-flag" style="margin-left: 8px;"> Monografias</button>
                                        </li>
                                    </ul>
                                </div>
                            </div>
                        </form>
                    </ul>
                </div>
            </div>
        </div>
        <br>
        <hr>
        <div class="container" style="margin-top: 30px;">
            <div class="col-md-9">
                <fieldset>
                    <div class="panel panel-default">
                        <sql:query dataSource="${snapshot}" var="tur">
                            SELECT * FROM turma  WHERE cod = <%=Integer.valueOf(turma)%>;
                        </sql:query>
                        <div class="panel-heading">
                            <c:forEach var="row" items="${tur.rows}">
                                <div class="text-center" style="font-size: 28px; color: #6f6f6f;">
                                    <p><a href="#configClass" data-toggle="modal"><strong><c:out value="${row.nome}"/></strong></a></p>
                                </div>
                            </c:forEach>
                            <sql:query dataSource="${snapshot}" var="passTurma">
                                SELECT * FROM turma  WHERE cod_user = <%=us.getCod()%> AND cod = <%=turma%>;
                            </sql:query>
                            <div id="participante" class="text-center">
                                <p>
                                    <c:forEach var="row" items="${passTurma.rows}">
                                        <button href="#SelectUser" data-toggle="modal"  class="btn-link">
                                            <span class="list-group-item-heading glyphicon glyphicon-plus-sign" style="font-size: 16px;"> Novo membro</span>
                                        </button>
                                    </c:forEach>
                                </p>
                            </div>
                            <div id="materiais" style="display: none" class="text-center">
                                <p>
                                    <c:forEach var="row" items="${passTurma.rows}">
                                        <button href="#insertMaterial" data-toggle="modal"  class="btn-link">
                                            <span class="list-group-item-heading glyphicon glyphicon-plus-sign" style="font-size: 16px;"> Novo material</span>
                                        </button>
                                    </c:forEach>
                                </p>
                            </div>
                            <div id="dados" style="display: none" class="text-center">
                            </div>
                            <div class="text-center">
                                <sql:query dataSource="${snapshot}" var="contMember">
                                    SELECT count(cod_turma) AS countMembro FROM listturma  WHERE cod_turma = <%=Integer.valueOf(turma)%> AND excluir = 0;
                                </sql:query>
                                <c:forEach var="row" items="${contMember.rows}">
                                    <h5 class="list-group-item-heading glyphicon glyphicon-user test" style="font-size: 16px;" data-toggle="tooltip" data-placement="left"  title="Total de membros nesta turma"> <c:out value="${row.countMembro}"/>-Membros</h5>
                                </c:forEach>
                                <sql:query dataSource="${snapshot}" var="materialturma">
                                    SELECT count(cod_turma) AS countMembro FROM materialturma  WHERE cod_turma = <%=Integer.valueOf(turma)%>;
                                </sql:query>
                                &nbsp;&nbsp;&nbsp;
                                <c:forEach var="row" items="${materialturma.rows}">
                                    <span class="list-group-item-heading glyphicon glyphicon-book test" style="font-size: 16px;" data-toggle="tooltip" data-placement="right" title="Total de materiais nesta turma">  <c:out value="${row.countMembro}"/>-Materiais</span>
                                </c:forEach>
                            </div>
                        </div>
                        <div class="panel-body">
                            <div class="col-lg-12">
                                <div class="panel panel-danger">
                                    <div class="list-group">
                                        <div id="membroList">
                                            <%for (Usuario ob : membros) {
                                                    if (ob.getCod() != us.getCod()) {
                                            %>
                                            <%}%>
                                            <div class="form-group list-group-item">
                                                <c:forEach var="row" items="${passTurma.rows}">
                                                    <form class="form-horizontal" action="action?pag=TurmaTrashMembro" method="POST">
                                                        <button name="codtrashMem" value="<%=ob.getCod()%>" class="btn btn-link pull-right test" data-toggle="tooltip" data-placement="top"  title="deseja remover  <%=ob.getNome()%> ?"><span class="glyphicon glyphicon-minus" style="font-size: 20px; color: red; margin-top: -16px;"></span></button>
                                                        <input name="cod_turma" value="<%=turma%>" style="display: none;">
                                                        <input name="cod_excluir" value="1" style="display: none;">
                                                    </form>
                                                </c:forEach>
                                                <div class="text-center">
                                                    <%if (ob.getImg().equals("yes")) {%>
                                                    <img style="margin: 0 auto; margin-top: -8px;" class="img-responsive img-full img-circle " src="img/<%=Hash.criptografar(String.valueOf(ob.getCod()))%>/<%=Hash.criptografar(String.valueOf(ob.getCod()))%>.jpg" alt="" height="45" width="45">
                                                    <%} else {%>

<%}%>
                                                    <button class="btn btn-link test" name="ObjetoSelect" value="<%=Hash.criptografar(String.valueOf(ob.getCod()))%> test" style="font-size: 20px; margin-top: -8px;" data-toggle="tooltip" data-placement="right"  title="<%=ob.getTipo() + " \n"%><%=ob.getInstituicao() + "\n"%><%=ob.getEmail() + "\n"%>">
                                                        &nbsp;<strong><%=ob.getNome()%></strong>
                                                    </button>
                                                </div>
                                            </div>
                                            <%}%>
                                        </div>
                                        <div id="membroMaterial" style="display: none;">
                                            <sql:query dataSource="${snapshot}" var="listMat">
                                                SELECT MD5(cod) AS codMD, cod,titulo,categoria,qtdpag,palavra_chave,inscricao, excluir FROM materialturma INNER JOIN objeto ON materialturma.cod_material = objeto.cod  WHERE cod_turma = <%=Integer.valueOf(turma)%>;
                                            </sql:query>
                                            <c:forEach var="row2" items="${listMat.rows}">
                                                <div class="form-group list-group-item">
                                                    <c:forEach var="row" items="${passTurma.rows}">
                                                        <form class="form-horizontal" action="action?pag=TurmaTrashMat" method="POST">
                                                            <button name="codTrashMat" value="<c:out value="${row2.cod}"/>" class="btn btn-link pull-right test" data-toggle="tooltip" data-placement="top"  title="deseja remover este material ?"><span class="glyphicon glyphicon-minus" style="font-size: 20px; color: red; margin-top: -16px;"></span></button>
                                                            <input name="cod_turma" value="<%=turma%>" style="display: none;">
                                                        </form>
                                                    </c:forEach>
                                                    <div class="text-center">
                                                        <button href="#<c:out value="${row2.cod}"/>" data-toggle="modal" class="btn btn-link" value="" style="font-size: 20px; margin-top: -8px;">
                                                            &nbsp;<strong><c:out value="${row2.titulo}"/></strong>
                                                        </button>
                                                    </div>
                                                </div>
                                            </c:forEach>
                                        </div>
                                        <div id="membroDados" style="display: none;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </fieldset>
            </div>
            <script>
                function actionMenu() {
                    var teste = $("input[name='objectOk']:checked").val();
                    document.getElementById("menuEdit").innerHTML =
                            "<form class='form-horizontal' action='action?pag=userEditObject' method='POST' enctype='multipart/form-data'>" +
                            "<li><p><button name='selectcodObjeto' value='" + teste + "' class='glyphicon glyphicon-edit btn btn-warning'> Editar</button></p></li>" +
                            "</form>";
                    document.getElementById("menuTrash").innerHTML =
                            "<form class='form-horizontal' action='action?pag=trashObjeto&trashConfirm=no' method='POST' enctype='multipart/form-data'>" +
                            "<li><p><button name='selectcodObjeto' value='" + teste + "' class='glyphicon glyphicon-remove-sign btn btn-warning'> Excluir</button></p></li>" +
                            "</form>";
                }
                function participante() {
                    document.getElementById("participante").style.display = "block";
                    document.getElementById("materiais").style.display = "none";
                    document.getElementById("dados").style.display = "none";
                    $("#btnPart").attr("class", "list-group-item active");
                    $("#btnMat").attr("class", "list-group-item");
                    $("#btnDad").attr("class", "list-group-item");
                    document.getElementById("membroList").style.display = "block";
                    document.getElementById("membroMaterial").style.display = "none";
                    document.getElementById("membroDados").style.display = "none";
                }
                function materiais() {
                    document.getElementById("materiais").style.display = "block";
                    document.getElementById("participante").style.display = "none";
                    document.getElementById("dados").style.display = "none";
                    $("#btnPart").attr("class", "list-group-item");
                    $("#btnMat").attr("class", "list-group-item active");
                    $("#btnDad").attr("class", "list-group-item");
                    document.getElementById("membroList").style.display = "none";
                    document.getElementById("membroMaterial").style.display = "block";
                    document.getElementById("membroDados").style.display = "none";
                }
            </script>
            <div class="col-md-3" style="display: block">
                <div class="list-group">
                    <button id="btnPart" class="list-group-item active" onclick="participante();">
                        <h4 class="list-group-item-heading glyphicon glyphicon-user"> Participantes</h4>
                        <p class="list-group-item-text">Lista de Participantes</p>
                    </button>
                </div>
                <div class="list-group">
                    <button id="btnMat" class="list-group-item" onclick="materiais();">
                        <h4 class="list-group-item-heading glyphicon glyphicon-list glyphicon-book"> Materiais</h4>
                        <p class="list-group-item-text">Materiais proposto para está turma</p>
                    </button>
                </div>
                <div class="list-group">
                    <a id="SearchInfo" href="#dadosSta" data-toggle="modal" class="list-group-item">
                        <h4 class="list-group-item-heading glyphicon glyphicon-stats"> Dados</h4>
                        <p class="list-group-item-text">Relatórios sobre leitura da turma</p>
                    </a>
                </div>
                <br><br>
                <c:forEach var="row" items="${passTurma.rows}">
                    <div class="list-group text-center">
                        <div class="list-group-item">
                            <h4 class="list-group-item-heading">Solicitação de saída</h4>
                            <br>
                            <sql:query dataSource="${snapshot}" var="listTurma">
                                SELECT MD5(cod), cod, nome,instituicao FROM usuario WHERE cod IN (SELECT listturma.cod_user FROM listturma WHERE excluir = 2 AND cod_turma = <%=Integer.valueOf(turma)%>);
                            </sql:query>
                            <c:forEach var="row" items="${listTurma.rows}">
                                <p><c:out value="${row.nome}"/></p>
                                <div style="margin-top: -14px;">
                                    <div class="col-md-6">
                                        <form class="form-horizontal" action="action?pag=TurmaTrashMembro" method="POST">
                                            <button name="codtrashMem" value="<c:out value="${row.cod}"/>" class="btn-link" style="color:red;">Remover</button>
                                            <input name="cod_turma" value="<%=turma%>" style="display: none;">
                                            <input name="cod_excluir" value="1" style="display: none;">
                                        </form>
                                    </div>
                                    <div class="col-md-6">
                                        <form class="form-horizontal" action="action?pag=TurmaNewMem" method="POST">
                                            <button name="codnewMem" value="<c:out value="${row.cod}"/>" class="btn-link">Adicionar</button>
                                            <input name="cod_turma" value="<%=turma%>" style="display: none;">
                                        </form>
                                    </div>
                                </div>
                                <hr>
                                <br>
                            </c:forEach>
                        </div>
                    </div>
                </div>
            </c:forEach>
        </div>
        <hr>
        <br><br><br>        
        <div class="navbar navbar-default navbar-fixed-bottom">
            <div class="container navbar-toggle" data-toggle="collapse" data-target="#">
                <a class="navbar-button btn btn-link pull-left test" data-toggle="tooltip" data-placement="top" title="GEPET - Grupo de Estudo e Pesquisa em Educação Tecnológica 2016"><img style="border-width:0; height: 31px; width:31px;" class="img-responsive img-full" src="img/Copyright.png"/></a>
                <a rel="license" class="navbar-button btn btn-link pull-left test" data-toggle="tooltip" data-placement="top" title="Este trabalho está licenciado com uma Licença Creative Commons - Atribuição-NãoComercial 4.0 Internacional."><img alt="Licença Creative Commons" style="border-width:0" class="img-responsive img-full" src="https://i.creativecommons.org/l/by-nc/4.0/88x31.png" /></a>
                <a href="http://www.unemat.br/" class="navbar-button btn btn-link pull-right test" data-toggle="tooltip" data-placement="top" target="_blank" title="Visite o site da Universidade do Estado de Mato Grosso"><img src="img/unemat.jpg" class="img-responsive img-full "></a>
            </div>
            <div class="container collapse navbar-collapse" id="myNavbar">
                <a rel="license" href="http://creativecommons.org/licenses/by-nc/4.0/" class=" navbar-button btn btn-link pull-left test" data-toggle="tooltip" data-placement="top" title="Este trabalho está licenciado com uma Licença Creative Commons - Atribuição-NãoComercial 4.0 Internacional."><img alt="Licença Creative Commons" style="border-width:0" class="img-responsive img-full" src="https://i.creativecommons.org/l/by-nc/4.0/88x31.png" /></a>
                <p class="navbar-text">GEPET - Grupo de Estudo e Pesquisa em Educação Tecnológica &COPY; 2016</p>
                <a href="http://www.unemat.br/" class="navbar-button btn btn-link pull-right test" data-toggle="tooltip" data-placement="top" target="_blank" title="Visite o site da Universidade do Estado de Mato Grosso"><img src="img/unemat.jpg" class="img-responsive img-full "></a>
            </div>
        </div>
        <div class="modal fade" id ="manutencao" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <form class="form-horizontal">
                        <div class="modal-header">
                            <p>SUPORTE</p>
                        </div>
                        <div class="modal-body ">
                            ESTE MODULO DO SITE SE ENCONTRA EM MANUTENÇÃO - CONSTRUÇÃO!
                        </div>
                        <div class="modal-footer">
                            <a class="btn btn-warning" data-dismiss="modal">Retorna</a>
                        </div>
                    </form>
                </div>
            </div>
        </div>

<sql:query dataSource="${snapshot}" var="listMaterial">
            SELECT MD5(cod) as codMD, titulo, excluir FROM objeto INNER JOIN materialturma ON objeto.cod = materialturma.cod_material WHERE objeto.cod_user = <%=us.getCod()%> AND materialturma.cod_turma = <%=Integer.valueOf(turma)%>;
        </sql:query>
        <div class="modal fade" id ="dadosSta" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <a class="btn btn-link pull-right glyphicon glyphicon-remove-circle" data-dismiss="modal"style="font-size: 28px;"></a>
                    <div class="modal-header">
                        <h3 class="text-center"><p>Escolha um material</p></h3>
                    </div>
                    <div class="modal-body">
                        <form class="form-horizontal" action="action?pag=userRelatorioMaterial" method="POST">
                            <input name="ObjetoTurma" value="<%=turma%>" style="display: none">
                            <c:forEach var="row" items="${listMaterial.rows}">
                                <div class="text-center">
                                    <p><button id="InfoMat" name="ObjetoSelect" value="<c:out value="${row.codMD}"/>" class="btn btn-success"><c:out value="${row.titulo}"/></button></p>
                                </div>
                            </c:forEach>
                        </form>
                    </div>
                    <div class="modal-footer">
                    </div>
                </div>
            </div>
        </div>

<div class="modal fade" id ="noSelect" name="noLog" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <form class="form-horizontal">
                        <div class="modal-header">
                            <h3><p>Informativo</p></h3>
                        </div>
                        <div class="modal-body ">
                            <h4 class="text-center text-warning">
                                <p>Nada selecionado!<br>Por favor selecione um material para prosseguir!</p>
                            </h4>
                        </div>
                        <div class="modal-footer">
                            <a class="btn btn-warning" data-dismiss="modal">Retorna</a>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <div class="modal fade" id ="SelectUser" name="noLog" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <a class="btn btn-link pull-right glyphicon glyphicon-remove-circle" data-dismiss="modal"style="font-size: 28px;"></a>
                    <form class="form-horizontal" action="action?pag=TurmaNewMem" method="POST">
                        <input name="cod_turma" value="<%=turma%>" style="display: none;">
                        <div class="modal-header">
                            <h3><p>Cadastrar participante nesta turma</p></h3>
                        </div>
                        <div class="modal-body ">
                            <input class="form-control" type="text" id="SearchMem" placeholder="Digite nome de quem deseja encontrar" autocomplete="off" style="font-size: 18px;">
                            <br>
                            <div id="showMem" style="display: none;">
                                <div id="showMembros">

</div>
                                
                                <hr style="border-color: #BBB;">
                                <br>
                            </div>
                        </div>
                        <div class="modal-footer">
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <div class="modal fade" id ="configClass" name="noLog" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <a class="btn btn-link pull-right glyphicon glyphicon-remove-circle" data-dismiss="modal"style="font-size: 28px;"></a>
                    <div class="modal-header">
                        <h3 class="text-center"><p>Painel de configuração</p></h3>
                    </div>
                    <form class="form-horizontal" action="action?pag=turmaAlterName" method="POST" >
                        <div class="modal-body ">
                            <div class="panel-success text-center">
                                <c:forEach var="row" items="${tur.rows}">
                                    <p><input class="form-control text-center" name="newName" placeholder="<c:out value="${row.nome}"/>"></p>            
                                        <c:forEach var="row" items="${passTurma.rows}">
                                        <p><button name="cod_turmaAlterName" value="<c:out value="${row.cod}"/>" class="btn btn-success">Alterar nome da turma</button></p>
                                    </c:forEach>
                                </c:forEach>
                            </div>
                        </div>
                    </form>
                    <div class="modal-footer">
                        <c:forEach var="row" items="${passTurma.rows}">
                            <button data-dismiss="modal" href="#trashTurmConf" data-toggle="modal" class="btn btn-danger" style="font-size: 14px;"><span class="glyphicon glyphicon-remove-sign"></span> Encerrar turma</button>
                        </c:forEach>
                        <%for (Usuario ob : membros) {
                                if (ob.getCod() == us.getCod()) {
                        %>
                        <form class="form-horizontal" action="action?pag=TurmaTrashMembro" method="POST">
                            &nbsp;<button id="codtrashMem" name="codtrashMem" value="<%=us.getCod()%>" id="btnExitClass" class="btn btn-warning" style="font-size: 14px;"><span class="glyphicon glyphicon-remove-sign"></span> Sair da turma</button>
                            <input name="cod_turma" value="<%=turma%>" style="display: none;">
                            <input name="cod_excluir" value="2" style="display: none;">
                        </form>
                        <%break;
                            }%>
                        <%}%>

</div>
                </div>
            </div>
        </div>
        <div class="modal fade" id ="trashTurmConf" name="noLog" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <div class="modal-header">
                        <h3><p>Encerramento de turma</p></h3>
                    </div>
                    <div class="modal-body ">
                        <h4 class="text-center text-warning">
                            <form class="form-horizontal" action="action?pag=trashTurma" method="POST">
                                <p><button name="codTrashTruma" value="<%=turma%>" class="btn btn-danger" style="font-size: 14px;">Deseja encerrar está turma?</button></p>
                                <p><a class="btn btn-primary" data-dismiss="modal" style="font-size: 14px;">Cancelar</a></p>
                            </form>
                        </h4>
                    </div>
                    <div class="modal-footer">
                    </div>
                </div>
            </div>
        </div>
        <div class="modal fade" id ="insertMaterial" name="noLog" role="dialog">
            <div class="modal-dialog">
                <div class="modal-content  alert alert-warning">
                    <a class="btn btn-link pull-right glyphicon glyphicon-remove-circle" data-dismiss="modal"style="font-size: 28px;"></a>
                    <div class="modal-header">
                        <h3 class="text-center"><p>Inserir Material</p></h3>
                    </div>
                    <form class="form-horizontal" action="action?pag=TurmaNewMat" method="POST" >
                        <input name="cod_turma" value="<%=turma%>" style="display: none;">
                        <div class="modal-body ">
                            <input class="form-control" type="text" id="SearchMat" placeholder="Digite nome do material deseja encontrar" style="font-size: 18px;" autocomplete="off">
                            <br>
                            <div id="showMat" style="display: none;">

</div>
                        </div>
                    </form>
                    <div class="modal-footer">
                    </div>
                </div>
            </div>
        </div>
        <c:forEach var="row2" items="${listMat.rows}">
            <div class="modal fade" id ="<c:out value="${row2.cod}"/>" role="dialog">
                <div class="modal-dialog">
                    <div class="modal-content  alert alert-warning text-center">
                        <a class="pull-right btn btn-default" data-dismiss="modal"><span class="pull-right glyphicon glyphicon-remove-sign"></span></a><br>
                        <hr>
                        <c:choose>
                            <c:when test="${row2.excluir == 0}">
                                <%if (session.getAttribute("encryptUserObject") == null) {
                                %>
                                <button href="#noLog" data-toggle="modal" class="btn-link test" style="color: #cd2a19;" data-toggle="tooltip" data-placement="right"  title="Começar a ler?">
                                    <strong><h3><p><c:out value="${row2.titulo}"/></p></h3></strong>
                                </button>
                                <%} else if (session.getAttribute("encryptUserObject") != null) {%>
                                <form action="action?pag=readObject" method="POST">
                                    <button name="txtcodObjeto" value="<c:out value="${row2.cod}"/>" class="btn-link" style="color: #cd2a19;">
                                        <strong><h3><p><c:out value="${row2.titulo}"/></p></h3></strong>
                                    </button>
                                </form>
                                <%}%>
                                <p>Categoria: <c:out value="${row2.categoria}"/>.</p>
                                <p>Nº Pagina: <c:out value="${row2.qtdpag}"/>. </p>
                                <p>Palavra Chave: <c:out value="${row2.palavra_chave}"/>.</p>
                                <p>Sobre: <c:out value="${row2.sobre}"/>.</p><hr><br>
                                <div class="form-group-lg" id="fieldinsert">
                                    <form action="action?pag=readObject" method="POST">
                                        <button name="txtcodObjeto" value="<c:out value="${row2.codMD}"/>" class="btn btn-block form-control" aria-expanded="false" aria-haspopup="true" style="border-color: gray;"><strong>Começar a ler</strong></button>
                                    </form>
                                </div>
                                <hr>
                                <p>Submetido em: <c:out value="${row2.inscricao}"/>.</p>
                            </c:when>
                            <c:otherwise>
                                <p class="text-danger text-center" style="font-size: 24px; margin-top: -12px;">Esse material foi excluido.</p>
                            </c:otherwise>    
                        </c:choose>
                    </div>
                </div>
            </div>
        </c:forEach>
        <script src="js/jquery.min.js"></script>
        <script src="js/bootstrap.js"></script>
    </body>
</html>