Blame | Last modification | View Log | RSS feed
<%@ 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>