Subversion Repositories bacoAlunos

Compare Revisions

Ignore whitespace Rev 1475 → Rev 1476

/branches/v3/impl/src/doc/BacoV32016/processos/QueriesQuestionarios.txt
New file
0,0 → 1,0
select tr.nomeDocente,avg((r6+r7+r8+r9+r10+r11+r12)/7.0) as media,avg((timeTakenR6+timeTakenR7+timeTakenR8+timeTakenR9+timeTakenR10+timeTakenR11+timeTakenR12)/7.0) as tempo from questionario_resposta q join questionario_resposta_requisitada qr on qr.resposta = q.id join questionario_peda_aluno_requisitado ar on ar.respostaRequisitada = qr.id join questionario_peda_tipologia_requisitada tr on tr.id = ar.tipologia_requisitada group by tr.cdDocente order by media;
/branches/v3/impl/src/web/user/home/teacherPae.jsp
39,7 → 39,7
 
</div>
<div class="col-md-4 col-sm-12 col-xs-12">
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president">
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<jsp:include page="panels/questionarios.jsp"/>
</baco:hasRole>
<jsp:include page="panels/emailSet.jsp"/>
/branches/v3/impl/src/web/user/questionarios/questionariosSee.jsp
29,9 → 29,11
 
%>
 
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<html:link styleClass="btn btn-default pull-right" action="/user/startQuestionariosPaeMessagePedagogico.do?&formDescription=${desc}&targetDispatch=sendEmailQuestionariosProcessing">
<span class="glyphicon glyphicon-envelope"> </span> Enviar Mensagem A Todos Os Inquiridos
</html:link>
</baco:hasRole>
<a class="btn btn-default" href="#" data-toggle="modal" data-target="#modalHelpQuestionario">
<span class="glyphicon glyphicon-question-sign"></span> Ajuda sobre Processo dos Questionários
</a>
/branches/v3/impl/src/web/user/questionarios/pedagogicoEstudante/questionarioDashBoard.jsp
70,12 → 70,14
String descEncoded = URLEncoder.encode(questionario.getDescription(),"ISO-8859-1");
request.setAttribute("descEncoded",descEncoded);
%>
<html:link styleClass="btn btn-default" action="/user/startQuestionariosPaeMessagePedagogico.do?questionarioId=${Questionario.id}&formDescription=Mensagem para os alunos: ${descEncoded}&targetDispatch=sendEmailQuestionario&cursoAfetoOrUnidadeAfetaOrQuestionarioAfetoId=${Questionario.id}">
<span class="glyphicon glyphicon-envelope"> </span> Enviar para todos os Cursos
</html:link>
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<html:link styleClass="btn btn-default" action="/user/startQuestionariosPaeMessagePedagogico.do?questionarioId=${Questionario.id}&formDescription=Mensagem para os alunos: ${descEncoded}&targetDispatch=sendEmailQuestionario&cursoAfetoOrUnidadeAfetaOrQuestionarioAfetoId=${Questionario.id}">
<span class="glyphicon glyphicon-envelope"> </span> Enviar para todos os Cursos
</html:link>
</baco:hasRole>
</td>
 
<a href="<%=request.getContextPath()%>/user/questionariosPaeMessagePedagogico.do"/>
 
</div>
<div class="col-sm-12">
<table class="tablesorter-blue">
119,11 → 121,12
<div class="progress-bar progress-bar-<%=percentageColor%>" role="progressbar" aria-valuenow="<%=percentage%>"
aria-valuemin="0" aria-valuemax="100" style="width:<%=percentage%>%">
<%=percentage%>%
<span class="icon icon-users"> </span>
</div>
</div>
</td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=questionarioStatsVars.alunosQueResponderam%></label></td>
<td><%=questionarioStatsVars.alunosDeUsadas%></td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=questionarioStatsVars.alunosQueResponderam%></label> <span class="icon icon-user"> </span></td>
<td><label class="label label-primary"><%=questionarioStatsVars.alunosDeUsadas%></label> <span class="icon icon-users"> </span></td>
<td><%=questionarioStatsVars.profsDeUsadas%></td>
<td><%=questionarioStatsVars.tipologiasUsadas%></td>
<td>
146,8 → 149,8
</div>
</div>
</td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=questionarioStatsVars.respostasObtidas%></label></td>
<td><label class="label label-info" style="font-size: 1em"><%=questionarioStatsVars.respostasRequisitadas%></label></td>
<td class="text-nowrap"><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=questionarioStatsVars.respostasObtidas%></label> <span class="icon icon icon-file-text2"> </span></td>
<td class="text-nowrap"><label class="label label-primary" style="font-size: 1em"><%=questionarioStatsVars.respostasRequisitadas%></label> <span class="icon icon icon-files-empty"> </span> </td>
 
</tbody>
</table>
165,7 → 168,10
<th>% Respostas</th>
<th>Respostas</th>
<th>Total</th>
<th></th>
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<th></th>
</baco:hasRole>
 
</thead>
<tbody>
<%
190,8 → 196,8
<td><%=cursoAfeto.getCodigoCurso()%></td>
<td><%=cursoAfeto.getNome()%></td>
<td>
<a href="#" data-href="<%=request.getContextPath()%>/user/questionarios/pedagogicoEstudante/questionarioCourseDashBoard.jsp?cursoAfetoId=${cursoAfeto.id}" data-title="Acompanhamento de questionários do curso (${cursoAfeto.codigoCurso}) ${cursoAfeto.nome} da ${cursoAfeto.nomeInstituicao})" data-toggle="modal" data-target="#modalAjaxRequest">
<%=cursoAfeto.getUnidadesAfetas().size()%>
<a class="btn btn-default" href="#" data-href="<%=request.getContextPath()%>/user/questionarios/pedagogicoEstudante/questionarioCourseDashBoard.jsp?cursoAfetoId=${cursoAfeto.id}" data-title="Acompanhamento de questionários do curso (${cursoAfeto.codigoCurso}) ${cursoAfeto.nome} da ${cursoAfeto.nomeInstituicao})" data-toggle="modal" data-target="#modalAjaxRequest">
<%=cursoAfeto.getUnidadesAfetas().size()%> UC's
</a>
 
</td>
212,12 → 218,13
<div class="progress-bar progress-bar-<%=percentageColor%>" role="progressbar" aria-valuenow="<%=percentage%>"
aria-valuemin="0" aria-valuemax="100" style="width:<%=percentage%>%">
<%=percentage%>%
<span class="icon icon-users"> </span>
</div>
</div>
 
</td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=alunosComRespostasCurso%></label></td>
<td><label class="label label-info" style="font-size: 1em"><%=alunosTotalCurso%></label></td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=alunosComRespostasCurso%> </label> <span class="icon icon-user"> </span> </td>
<td><label class="label label-primary" style="font-size: 1em"><%=alunosTotalCurso%></label> <span class="icon icon-users"> </span></td>
<td>
<%
percentage = (int) (100.0 * ( ((float)respostasCurso/((float)cursoAfeto.getStatRespostasRequisitadas()))));
235,11 → 242,14
<div class="progress-bar progress-bar-<%=percentageColor%>" role="progressbar" aria-valuenow="<%=percentage%>"
aria-valuemin="0" aria-valuemax="100" style="width:<%=percentage%>%">
<%=percentage%>%
 
<span class="icon icon-stack"> </span>
</div>
</div>
</td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=respostasCurso%></label></td>
<td><label class="label label-info" style="font-size: 1em"><%=cursoAfeto.getStatRespostasRequisitadas()%></label></td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=respostasCurso%></label> <span class="icon icon-file-text2"> </span></td>
<td><label class="label label-primary" style="font-size: 1em"><%=cursoAfeto.getStatRespostasRequisitadas()%></label> <span class="icon icon icon-files-empty"> </span></td>
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<td>
<%
String nomeCursoEncoded = URLEncoder.encode(cursoAfeto.getNome(),"ISO-8859-1");
249,6 → 259,7
<span class="glyphicon glyphicon-envelope"> </span>
</html:link>
</td>
</baco:hasRole>
</tr>
<%
}
/branches/v3/impl/src/web/user/questionarios/pedagogicoEstudante/results/fusionCharts.jsp
New file
0,0 → 1,182
<%@ page import="jomm.dao.impl.AbstractDao" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="/WEB-INF/tlds/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/tlds/struts-nested.tld" prefix="nested" %>
<%@ taglib uri="/WEB-INF/tlds/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/tlds/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/tlds/struts-tiles.tld" prefix="tiles" %>
<%@ taglib uri="/WEB-INF/tlds/baco.tld" prefix="baco" %>
<%@ taglib uri="/WEB-INF/tlds/jomm.tld" prefix="jomm" %>
<jsp:useBean id="UserSession" type="pt.estgp.estgweb.domain.UserSessionImpl" scope="request"/>
<html>
<head>
<title></title>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.charts.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.powercharts.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.gantt.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.maps.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/fusioncharts.widgets.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/charts/fusioncharts-suite-xt/js/themes/fusioncharts.theme.fint.js"></script>
<script>
<%
AbstractDao.getCurrentSession().beginTransaction();
 
 
List<Object[]> results = AbstractDao.getCurrentSession().createSQLQuery("select tr.nomeDocente,avg((r6+r7+r8+r9+r10+r11+r12)/7.0) as media,avg((timeTakenR6+timeTakenR7+timeTakenR8+timeTakenR9+timeTakenR10+timeTakenR11+timeTakenR12)/7.0) as tempo from questionario_resposta q join questionario_resposta_requisitada qr on qr.resposta = q.id join questionario_peda_aluno_requisitado ar on ar.respostaRequisitada = qr.id join questionario_peda_tipologia_requisitada tr on tr.id = ar.tipologia_requisitada " +
 
" group by tr.cdDocente order by media desc;").list();
float maxMedia = 1;
float maxTempo = 0;
for(Object[] result: results)
{
float tempo = Float.parseFloat(""+result[2]);
if(tempo > maxTempo)
maxTempo = tempo;
}
maxTempo = 1000;
 
 
%>
FusionCharts.ready(function(){
var revenueChart = new FusionCharts(
{
 
"type": "msbar2d",
"renderAt": "chartContainer",
"width": "600",
"height": "4000",
"dataFormat": "json",
"dataSource": {
 
"chart": {
"caption": "Split of Sales by Product Category",
"subCaption": "In top 5 stores last month",
"yAxisName": "Médias (Tempo Maximo = <%=maxTempo%>, Média Maxima: 5)",
"numberPrefix": "Pontos",
"paletteColors": "#0075c2,#1aaf5d",
"bgColor": "#ffffff",
"showBorder": "0",
"showHoverEffect": "1",
"showCanvasBorder": "0",
"usePlotGradientColor": "0",
"plotBorderAlpha": "10",
"yAxisMaxValue": "5",
"legendBorderAlpha": "0",
"legendShadow": "0",
"placevaluesInside": "1",
"valueFontColor": "#ffffff",
"showXAxisLine": "1",
"xAxisLineColor": "#999999",
"divlineColor": "#999999",
"divLineDashed": "1",
"showAlternateVGridColor": "0",
"subcaptionFontBold": "0",
"subcaptionFontSize": "14"
 
},
"categories": [
{
"category": [
<%
String sep = "";
int i = 1;
for(Object[] result: results)
{
%>
<%=sep%>
{
"label": "<%=i + "º -" + result[0]%>"
}
<%
sep = ",";
i++;
}
%>
]
}
],
"dataset": [
{
"seriesname": "Classificação",
"data": [
 
<%
sep = "";
for(Object[] result: results)
{
float media = Float.parseFloat(""+result[1]);
 
%>
<%=sep%>
{
"value": "<%=media / maxMedia%>"
}
<%
sep = ",";
}
%>
]
} /*,
 
{
"seriesname": "Current Year",
"data": [
<%
sep = "";
for(Object[] result: results)
{
float tempo = Float.parseFloat(""+result[2]);
%>
<%=sep%>
{
"value": "<%=tempo/maxTempo%>"
}
<%
sep = ",";
}
%>
]
}*/
],
"trendlines": [
{
"line": [
{
"startvalue": "12250",
"color": "#0075c2",
"displayvalue": "Previous{br}Average",
"valueOnRight": "1",
"thickness": "1",
"showBelow": "1",
"tooltext": "Previous year quarterly target : $13.5K"
},
{
"startvalue": "25950",
"color": "#1aaf5d",
"displayvalue": "Current{br}Average",
"valueOnRight": "1",
"thickness": "1",
"showBelow": "1",
"tooltext": "Current year quarterly target : $23K"
}
]
}
]
}
}
);
revenueChart.render();
})
<%
AbstractDao.getCurrentSession().getTransaction().commit();
%>
</script>
</head>
<body>
<h1>Posição dos Docentes Atual</h1>
<div id="chartContainer">FusionCharts XT will load here!</div>
 
</body>
</html>
/branches/v3/impl/src/web/user/questionarios/pedagogicoEstudante/questionarioCourseDashBoard.jsp
73,7 → 73,9
<th>Alunos com Respos. %</th>
<th>Alunos com Respos.</th>
<th>Alunos</th>
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<th></th>
</baco:hasRole>
</thead>
<tbody>
<%
107,12 → 109,14
<div class="progress-bar progress-bar-<%=percentageColor%>" role="progressbar" aria-valuenow="<%=percentage%>"
aria-valuemin="0" aria-valuemax="100" style="width:<%=percentage%>%">
<%=percentage%>%
<span class="icon icon-users"> </span>
</div>
</div>
 
</td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=tipologia[7]%></label></td>
<td><label class="label label-info" style="font-size: 1em"><%=tipologia[8]%></label></td>
<td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=tipologia[7]%></label> <span class="icon icon-user"> </span></td>
<td><label class="label label-primary" style="font-size: 1em"><%=tipologia[8]%></label> <span class="icon icon-users"> </span></td>
<baco:hasRole role="admin,all,questionarios.gerais,questionarios.admin,pedagogicCouncil.president,administrativeCouncil.director">
<td>
<%
Long unidadeId = (Long) tipologia[9];
126,6 → 130,7
<span class="glyphicon glyphicon-envelope"> </span>
</html:link>
</td>
</baco:hasRole>
</tr>
<%
}