WebSVN - bacoAlunos - Diff - Rev 1844 and 1848 - /branches/v3/impl/src/java/pt/estgp/estgweb/services/courses/CourseReportServices.java

 package pt.estgp.estgweb.services.courses;
+import jomm.dao.impl.AbstractDao;
 import jomm.utils.StreamsUtils;
 import org.apache.log4j.Logger;
 import org.json.JSONArray;
 import org.json.JSONException;
 import org.json.JSONObject;
 import pt.utl.ist.berserk.logic.serviceManager.IService;
 import java.io.IOException;
 import java.io.InputStream;
 import java.net.URL;
+import java.net.URLConnection;
 import java.util.*;
 /**
  * Created by jorgemachado on 14/10/17.
  */
     /****************************************************************************/
     /* SERVICOS CORE DOS REPORTS
     /****************************************************************************/
-    /**
-     * Gera uma tabela de estatisticas dos DTP recorrendo ao servico WS de
-     * load de tabelas DTP, caso o serviço nao devolva unidades são criadas novas
-     * com os valores a falso.
-     *
-     * @param courseCode
-     * @param year
-     * @return UnitsDtpTable
-     * @throws IOException
-     * @throws JSONException
-     */
-    public UnitsDtpTable updateDtpStatsTable4Course(ReportCourseDocument reportCourseDocument, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException
-    {
-        ReportsUcSummarySection reportsUcSummarySection = (ReportsUcSummarySection) reportCourseDocument.findDocumentSection(ReportsUcSummarySection.class);
-        UnitsDtpTable unitsDtpTable = (UnitsDtpTable) reportsUcSummarySection.findDocComponent(UnitsDtpTable.class);
-        UnitDtpSemester semester1 = new UnitDtpSemester();
-        UnitDtpSemester semester2 = new UnitDtpSemester();
-        unitsDtpTable.setSemester1(semester1);
-        unitsDtpTable.setSemester2(semester2);
-        List<CourseUnit> units = DaoFactory.getCourseUnitDaoImpl().loadByCourseSiges(courseCode, year);
-.5.0/docs/api/java/lang/String.html">String json = loadCourseUnitDtpStats(courseCode,year);
-        JSONObject response = new JSONObject(json);
-        JSONArray stats = (JSONArray) response.get("dtpstats");
-        CourseUnitDtpStat[] statsLoaded = CourseUnitDtpStat.fromJson(stats);
-        for(CourseUnit cu :units)
-        {
-            CourseUnitDtpStat statFound = CourseReportUtils.findCourseUnitDtpStat(statsLoaded, (CourseUnitImpl) cu);
-            if(statFound == null)
-            {
-                statFound = CourseReportUtils.createCourseUnitDtpStat(cu);
-            }
-            if(((CourseUnitImpl) cu).getSemestreAbsolutoS1S2().equals("S1"))
-                semester1.getCourseUnitDtpStats().add(statFound);
-            else
-                semester2.getCourseUnitDtpStats().add(statFound);
-        }
-        return unitsDtpTable;
-    }
     /**
+     *
      * @param courseCode
      * @param year
      * @return
      * @throws IOException
      * @throws JSONException
      */
-    public ReportCourseDocument createNewCourseReportDocument(1.5.0/docs/api/java/lang/String.html">String courseCode,1.5.0/docs/api/java/lang/String.html">String year) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException
+    public CourseReportDocument createNewCourseReportDocument(1.5.0/docs/api/java/lang/String.html">String courseCode,1.5.0/docs/api/java/lang/String.html">String year) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException
+    {
-        ReportCourseDocument reportCourseDocument = new ReportCourseDocument();
+        CourseReportDocument reportCourseDocument = new CourseReportDocument();
         reportCourseDocument.init();
         //FIRST SERVICE TO CALL TO OBTAIN UNITS AND EVALUATIONS
         //THIS IS THE BASE FOR THE REMAIN SERVICE CALLS
         return reportCourseDocument;
+    }
-    public SurveysResultsSection updateSurveysDataTables(1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year, ReportCourseDocument reportCourseDocument) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException {
+    public SurveysResultsSection updateSurveysDataTables(1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year, CourseReportDocument reportCourseDocument) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException {
         SurveysSection surveysSection = (SurveysSection) reportCourseDocument.findDocumentSection(SurveysSection.class);
-        SurveysResultsSection surveysResultsSection = (SurveysResultsSection) surveysSection.findSubSection(SurveysResultsSection.class);
+        SurveysResultsSection surveysResultsSection = (SurveysResultsSection) surveysSection.findSection(SurveysResultsSection.class);
         QuestionariosDataTableComponent dataTableComponentS1 = (QuestionariosDataTableComponent) surveysResultsSection.getComponents().get(0);
         QuestionariosDataTableComponent dataTableComponentS2 = (QuestionariosDataTableComponent) surveysResultsSection.getComponents().get(1);
         QuestionariosReportsService questionariosReportsService = new QuestionariosReportsService();
 .5.0/docs/api/java/lang/String.html">String jsonDataTableS1 = questionariosReportsService.loadReportUnidadesSalasJson(courseCode,year,"S1");
     /**
      * Este serviço atualiza a tabela de resultados de aprendizagem com base nas courseunitssections
      * @param reportCourseDocument
      * @return UnitsLearningResultsTable
      */
-    public UnitsLearningResultsTable updateCleanLearningResultsFromCourseUnitsSections(ReportCourseDocument reportCourseDocument)
+    public UnitsLearningResultsTable updateCleanLearningResultsFromCourseUnitsSections(CourseReportDocument reportCourseDocument)
+    {
         CourseUnitsReportsSection unitReportsSection = (CourseUnitsReportsSection) reportCourseDocument.findDocumentSection(CourseUnitsReportsSection.class);
         LearningResultsSection learningResultsSection = (LearningResultsSection) reportCourseDocument.findDocumentSection(LearningResultsSection.class);
         UnitsLearningResultsTable learningResultsTable = (UnitsLearningResultsTable) learningResultsSection.findDocComponent(UnitsLearningResultsTable.class);
         Map<Integer,UnitsLearningResultYear> anosPlano = new HashMap<Integer, UnitsLearningResultYear>();
         Map<String,UnitsLearningResultSemester> anoSemestre = new HashMap<String, UnitsLearningResultSemester>();
-        for(DocumentSection subSection : unitReportsSection.getSubSections())
+        for(DocumentSection subSection : unitReportsSection.getSections())
+        {
             CourseUnitSection unitSection = (CourseUnitSection) subSection;
             int anoPlano = unitSection.getAnoPlano();
             UnitsLearningResultYear anoFound = anosPlano.get(anoPlano);
             if(anoFound == null)
         }*/
+    }
     /**
+     * Gera uma tabela de estatisticas dos DTP recorrendo ao servico WS de
+     * load de tabelas DTP, caso o serviço nao devolva unidades são criadas novas
+     * com os valores a falso.
+     *
+     * @param courseCode
+     * @param year
+     * @return UnitsDtpTable
+     * @throws IOException
+     * @throws JSONException
+     */
+    public UnitsDtpTable updateDtpStatsTable4Course(CourseReportDocument reportCourseDocument, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException
+    {
+        ReportsUcSummarySection reportsUcSummarySection = (ReportsUcSummarySection) reportCourseDocument.findDocumentSection(ReportsUcSummarySection.class);
+        UnitsDtpTable unitsDtpTable = (UnitsDtpTable) reportsUcSummarySection.findDocComponent(UnitsDtpTable.class);
+        UnitDtpSemester semester1 = new UnitDtpSemester();
+        UnitDtpSemester semester2 = new UnitDtpSemester();
+        unitsDtpTable.setSemester1(semester1);
+        unitsDtpTable.setSemester2(semester2);
+        List<CourseUnit> units = DaoFactory.getCourseUnitDaoImpl().loadByCourseSiges(courseCode, year);
+        CourseUnitDtpStat[] statsLoaded;
+        try
+        {
+.5.0/docs/api/java/lang/String.html">String json = loadCourseUnitDtpStats(courseCode,year);
+            JSONObject response = new JSONObject(json);
+            JSONArray stats = (JSONArray) response.get("dtpstats");
+            statsLoaded = CourseUnitDtpStat.fromJson(stats);
+        }
+        catch(1.5.0/docs/api/java/lang/Exception.html">Exception e)
+        {
+            logger.error(e,e);
+            statsLoaded = new CourseUnitDtpStat[0];
+        }
+        for(CourseUnit cu :units)
+        {
+            CourseUnitDtpStat statFound = CourseReportUtils.findCourseUnitDtpStat(statsLoaded, (CourseUnitImpl) cu);
+            if(statFound == null)
+            {
+                statFound = CourseReportUtils.createCourseUnitDtpStat(cu);
+            }
+            if(((CourseUnitImpl) cu).getSemestreAbsolutoS1S2().equals("S1"))
+                semester1.getCourseUnitDtpStats().add(statFound);
+            else
+                semester2.getCourseUnitDtpStats().add(statFound);
+        }
+        return unitsDtpTable;
+    }
+    /**
      * Update course unit sections with reports, this method dows not change learning results table
      * values from learning results stays in unit but does not change learning results Table
      * @param courseCode
      * @param year
      * @param reportCourseDocument
      * @throws JSONException
      * @throws IOException
      * @return a list of CourseUnitSection
      */
-    public List<DocumentSection> updateCleanCourseUnitSections(1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year, ReportCourseDocument reportCourseDocument) throws JSONException, 1.5.0/docs/api/java/io/IOException.html">IOException {
+    public List<DocumentSection> updateCleanCourseUnitSections(1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year, CourseReportDocument reportCourseDocument) throws JSONException, 1.5.0/docs/api/java/io/IOException.html">IOException {
         List<CourseUnit> units = DaoFactory.getCourseUnitDaoImpl().loadByCourseSiges(courseCode, year);
-.5.0/docs/api/java/lang/String.html">String courseUnitSectionsJson = loadCourseEvaluationSections(courseCode,year);
-        JSONObject object = new JSONObject(courseUnitSectionsJson);
-        JSONArray evaluations = object.getJSONArray("evaluations");
-        CourseUnitSection[] courseUnitSections = CourseUnitSection.fromJsonArray(evaluations.toString());
         CourseUnitsReportsSection unitReportsSection = (CourseUnitsReportsSection) reportCourseDocument.findDocumentSection(CourseUnitsReportsSection.class);
+        CourseUnitSection[] courseUnitSections = null;
+        try{
+.5.0/docs/api/java/lang/String.html">String courseUnitSectionsJson = loadCourseEvaluationSections(courseCode,year);
+            JSONObject object = new JSONObject(courseUnitSectionsJson);
+            JSONArray evaluations = object.getJSONArray("evaluations");
+            courseUnitSections = CourseUnitSection.fromJsonArray(evaluations.toString());
+        }
+        catch(1.5.0/docs/api/java/lang/Exception.html">Exception e)
+        {
+            logger.error(e,e);
+            courseUnitSections = new CourseUnitSection[0];
+        }
         List<DocumentSection> subSections = new ArrayList<DocumentSection>();
-        unitReportsSection.setSubSections(subSections);
+        unitReportsSection.setSections(subSections);
         for(CourseUnit cu :units)
+        {
             CourseUnitSection sectionFound = CourseReportUtils.findCourseUnitSection(courseUnitSections, (CourseUnitImpl) cu);
             if(sectionFound == null)
+            {
                 courseUnitEvaluation.setAutoGeneratedCourseReport(true);
                 DaoFactory.getCourseUnitEvaluationDaoImpl().save(courseUnitEvaluation);
                 cu.setCourseUnitEvaluation(courseUnitEvaluation);
                 sectionFound.setCourseUnitEvaluation(courseUnitEvaluation);
+            }
-            unitReportsSection.getSubSections().add(sectionFound);
+            unitReportsSection.getSections().add(sectionFound);
+        }
         return subSections;
+    }
     public static void main(1.5.0/docs/api/java/lang/String.html">String[] args) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException {
-        /*AbstractDao.getCurrentSession().beginTransaction();
+        AbstractDao.getCurrentSession().beginTransaction();
-        ReportCourseDocument reportCourseDocument = new CourseReportServices().createNewCourseReportDocument("44","201617");
+        CourseReportDocument reportCourseDocument = new CourseReportServices().createNewCourseReportDocument("44","201617");
-        System.out.println(reportCourseDocument.toJson());
+.5.0/docs/api/java/lang/System.html">System.out.println(reportCourseDocument.toJson());
-        AbstractDao.getCurrentSession().getTransaction().commit();*/
+        AbstractDao.getCurrentSession().getTransaction().commit();
         //System.setProperty("javax.net.ssl.trustStore", "/JORGE/COPIAS/.keystore");
         //System.setProperty("javax.net.ssl.trustStorePassword", "changeit");
-.5.0/docs/api/java/net/URL.html">URL url = new 1.5.0/docs/api/java/net/URL.html">URL("http://pae.ipportalegre.pt/wsjson/api/app/ws-course-pedagogic-results-list?code=44&year=201617&period=S1");
+        /*URL url = new URL("http://pae.ipportalegre.pt/wsjson/api/app/ws-course-pedagogic-results-list?code=44&year=201617&period=S1");
-.5.0/docs/api/java/lang/System.html">System.out.println(StreamsUtils.readString(url.openStream()));
+        System.out.println(StreamsUtils.readString(url.openStream()));*/
+    }
     /*
     public String loadUnitsAndCreateLearningResultsTables4Course(String courseCode, String year) throws IOException, JSONException
             return obj.toString();
+        }
         else
+        {
-.5.0/docs/api/java/net/URL.html">URL url = new 1.5.0/docs/api/java/net/URL.html">URL(Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_DTP_STATS + "?code=" + courseCode  + "&year=" + year);
+.5.0/docs/api/java/lang/String.html">String serviceUrl = Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_DTP_STATS + "?code=" + courseCode  + "&year=" + year;
+.5.0/docs/api/java/lang/String.html">String json = "{ dtpstats : [] }";
+            try{
+.5.0/docs/api/java/net/URL.html">URL url = new 1.5.0/docs/api/java/net/URL.html">URL(serviceUrl);
+.5.0/docs/api/java/net/URLConnection.html">URLConnection conn = url.openConnection();
-+0%2Fdocs%2Fapi+InputStream">InputStream is = url.openStream();
++0%2Fdocs%2Fapi+InputStream">InputStream is = conn.getInputStream();
-.5.0/docs/api/java/lang/String.html">String json = StreamsUtils.readString(is);
+                json = StreamsUtils.readString(is);
-            is.close();
+                is.close();
+            }catch(1.5.0/docs/api/java/lang/Throwable.html">Throwable e)
+            {
-            //TODO temos de extrair o resultado do RESPONSE
+                logger.error("Connecting " + serviceUrl,e);
+                return json;
+            }
             JSONObject jsonObject = new JSONObject(json);
             return jsonObject.get("response").toString();
+        }
+    }
      * @return String JSONObject with a JSON ARRAY of List<CourseUnitSection>
      */
     public 1.5.0/docs/api/java/lang/String.html">String loadCourseEvaluationSections(1.5.0/docs/api/java/lang/String.html">String courseCode,1.5.0/docs/api/java/lang/String.html">String year) throws JSONException, 1.5.0/docs/api/java/io/IOException.html">IOException {
-        if(Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_EVALUATION.indexOf("localhost")>=0)
+        if(Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_EVALUATION_REPORT.indexOf("localhost")>=0)
+        {
             JSONArray array = new JSONArray();
             List<CourseUnit> units = DaoFactory.getCourseUnitDaoImpl().loadByCourseSiges(courseCode, year);
             for(CourseUnit cu: units)
+            {
             return obj.toString();
+        }
         else
+        {
+.5.0/docs/api/java/lang/String.html">String json = "{ evaluations : [] }";
-.5.0/docs/api/java/net/URL.html">URL url = new 1.5.0/docs/api/java/net/URL.html">URL(Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_EVALUATION + "?code=" + courseCode  + "&year=" + year);
+.5.0/docs/api/java/lang/String.html">String serviceUrl = Globals.SYSTEM_WSJSON_SERVICE_COURSE_UNITS_EVALUATION_REPORT + "?code=" + courseCode  + "&year=" + year;
+            try{
+.5.0/docs/api/java/net/URL.html">URL url = new 1.5.0/docs/api/java/net/URL.html">URL(serviceUrl);
+.5.0/docs/api/java/net/URLConnection.html">URLConnection conn = url.openConnection();
-+0%2Fdocs%2Fapi+InputStream">InputStream is = url.openStream();
++0%2Fdocs%2Fapi+InputStream">InputStream is = conn.getInputStream();
+                json = StreamsUtils.readString(is);
+                is.close();
+            }catch(1.5.0/docs/api/java/lang/Throwable.html">Throwable e)
+            {
+                logger.error("Connecting " + serviceUrl,e);
+                return json;
+            }
-.5.0/docs/api/java/lang/String.html">String json = StreamsUtils.readString(is);
-            is.close();
             JSONObject jsonObject = new JSONObject(json);
             return jsonObject.get("response").toString();
+        }
+    }

Subversion Repositories bacoAlunos

(root)/branches/v3/impl/src/java/pt/estgp/estgweb/services/courses/CourseReportServices.java @ 1848 - Rev 1844 → 1848