package src;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.ejb.EJB;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import beans.AdministracionBeanRemote;

import model.Alumno;
import model.Asignatura;
import model.Concepto;
import model.Curso;
import model.Tema;

/**
 * Servlet implementation class CargarResultadosServlet
 */
@WebServlet("/CargarResultadosServlet")
public class CargarResultadosServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
	@PersistenceContext
    EntityManager em;
	
	@EJB
    AdministracionBeanRemote abr;
	
    /**
     * @see HttpServlet#HttpServlet()
     */
    public CargarResultadosServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
        int idTema = Integer.valueOf(request.getParameter("tema_id"));
        Tema tema = em.find(Tema.class, idTema);
        String idAsignatura = request.getParameter("asignatura");
        Asignatura asignatura = em.find(Asignatura.class, Integer.valueOf(idAsignatura));
        Curso curso = asignatura.getCurso();
        
        
        List<Alumno> alumnoList = em.createQuery("Select e from Alumno e where e.curso = :curso")
				.setParameter("curso", curso).getResultList();
        request.setAttribute("alumnoList", alumnoList);
		System.out.println(alumnoList.toString());

		

		
		try {
			
			out.printf("<table title=\"Resultados\"" +
					" class='table table-condensed table-bordered table-hover'" +
					"summary=\"Resultados por alumno por tema\"" +
					"data-attc-createChart=\"true\" " +
					"data-attc-colDescription=\"nombre\" " +
					"data-attc-colValues=\"tema\"" +
					"data-attc-location=\"grafico\" " +
					"data-attc-hideTable=\"false\" " +
					"data-attc-type=\"pie\" " +
					"data-attc-googleOptions='{\"is3D\":true}'" +
					"data-attc-controls='{\"showHide\":true,\"create\":true,\"chartType\":true}'>");
			out.printf("<thead>");
			out.printf("<tr>");
			
			out.printf("<th id=\"nombre\">");
			out.printf("Nombre");
			out.printf("</th>");
			
			out.printf("<th>");
			out.printf("Apellido");
			out.printf("</th>");
			
			out.printf("<th id=\"tema\">");
			out.printf("Tema");
			out.printf("</th>");
			
			
			
			List<Concepto> conceptoList = em.createQuery("Select e from Concepto e where e.tema = :tema")
					.setParameter("tema", tema).getResultList();
			
			for (Concepto concepto : conceptoList) {
		        	out.printf("<th >");
					out.printf(concepto.getNombre());
					out.printf("</th>");
		        }
		    out.printf("</tr>");
		    out.printf("</thead>");
		    out.printf("<tbody>");
			for (Alumno alumno : alumnoList){
				//System.out.println(tema.getConceptoList().toString());
				out.printf("<tr>");
				
				out.printf("<td class='lname'>");
				out.printf(alumno.getNombre());
				out.printf("</td>");
				
				out.printf("<td class='lname'>");
				out.printf(alumno.getApellido());
				out.printf("</td>");
				
				out.printf("<td class='lname'>");
				out.print(abr.aPorcentaje(abr.getValorNodoRed(tema.getNombre(), Integer.valueOf(idAsignatura), alumno.getIdAlumno())));
				out.print(" %");
				out.printf("</td>");
				
				conceptoList = em.createQuery("Select e from Concepto e where e.tema = :tema")
						.setParameter("tema", tema).getResultList();
		        for (Concepto concepto : conceptoList) {
		        	out.printf("<td class='motto'>");
					out.print(abr.aPorcentaje(abr.getValorNodoRed(concepto.getNombre(), Integer.valueOf(idAsignatura), alumno.getIdAlumno())));
					out.print(" %");
					out.printf("</td>");
		        }
		        out.printf("</tr>");
			}
			out.printf("</tbody>");
			out.printf("</table>");
		} finally {
            out.close();
        }
        
        //List<Concepto> conceptoList = abr.getConceptoList(idTema);
        System.out.println("prueba"); 
        //System.out.println(conceptoList.toString());
	}
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}