WebSVN - bacoAlunos - Diff - Rev 1629 and 1830 - /branches/v3/impl/src/java/pt/estgp/estgweb/services/questionarios/QuestionariosReportsService.java

 package pt.estgp.estgweb.services.questionarios;
+import jomm.dao.impl.AbstractDao;
+import jomm.utils.StreamsUtils;
 import org.apache.log4j.Logger;
+import org.hibernate.Criteria;
+import org.json.JSONException;
+import org.json.JSONObject;
 import pt.estgp.estgweb.domain.*;
 import pt.estgp.estgweb.domain.dao.DaoFactory;
 import pt.estgp.estgweb.services.jobs.JobDeamon;
 import pt.estgp.estgweb.services.jobs.ServiceJob;
+import pt.estgp.estgweb.services.questionarios.pedagogico.reportprocessors.utils.DataTable;
 import pt.estgp.estgweb.utils.ConfigProperties;
+import pt.estgp.estgweb.utils.Globals;
 import pt.estgp.estgweb.web.exceptions.NotAuthorizedException;
 import pt.estgp.estgweb.web.form.questionarios.widgets.ReportAdminAlunosWidgetForm;
 import pt.utl.ist.berserk.logic.serviceManager.IService;
+import java.io.IOException;
+import java.io.InputStream;
+import java.net.URL;
 import java.util.ArrayList;
 import java.util.HashSet;
 import java.util.List;
 import java.util.Set;
+import static org.hibernate.criterion.Restrictions.eq;
+import static org.hibernate.criterion.Restrictions.like;
 /**
  * Created by jorgemachado on 21/03/16.
  */
 public class QuestionariosReportsService implements IService
+{
     private static final 1.5.0/docs/api/java/util/logging/Logger.html">Logger logger = 1.5.0/docs/api/java/util/logging/Logger.html">Logger.getLogger(QuestionariosReportsService.class);
     public void saveReportGroup(1.5.0/docs/api/java/lang/String.html">String title,1.5.0/docs/api/java/lang/String.html">String classType, UserSession userSession) throws 1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException, 1.5.0/docs/api/java/lang/IllegalAccessException.html">IllegalAccessException, 1.5.0/docs/api/java/lang/InstantiationException.html">InstantiationException
+    {
         QuestionarioReportFileGroup reportFileGroup = (QuestionarioReportFileGroup) 1.5.0/docs/api/java/lang/Class.html">Class.forName(classType).newInstance();
         reportFileGroup.setTitle(title);
 .5.0/docs/api/java/lang/String.html">String processorClassForGroup = ConfigProperties.getProperty("questionarios.processor." + classType);
         QuestionarioReportFile reportFile = DaoFactory.getQuestionarioReportFileDaoImpl()
                 .load(reportFileId);
         reportFile.setActive(active);
+    }
-    public QuestionarioReportFileGroupImpl runJobGenerate(long reportGroupId,1.5.0/docs/api/java/lang/String.html">String title,boolean active, UserSession session) throws NotAuthorizedException, 1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException {
+    public QuestionarioReportFileGroupImpl runJobGenerate(long reportGroupId,1.5.0/docs/api/java/lang/String.html">String title,boolean active, 1.5.0/docs/api/java/lang/String.html">String generateSigesCode, UserSession session) throws NotAuthorizedException, 1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException {
         QuestionarioReportFileGroupImpl reportGroup = (QuestionarioReportFileGroupImpl) DaoFactory.getQuestionarioReportFileGroupDaoImpl().load(reportGroupId);
         reportGroup.setTitle(title);
         reportGroup.setActive(active);
         paramJob.setName(ServiceJob.JOB_questionario_report_id_KEY);
         paramJob.setDescription("ID do Report Group");
         paramJob.setObject("" + reportGroupId);
         paramsJob.add(paramJob);
+        if(generateSigesCode != null && generateSigesCode.trim().length()>0)
+        {
+            JobServiceTaskParameterImpl paramJobSigesCode = DomainObjectFactory.createJobServiceTaskParameterImpl();
+            paramJobSigesCode.setName(ServiceJob.JOB_questionario_sigesCode_KEY);
+            paramJobSigesCode.setDescription("Gerar apenas este SigesCode");
+            paramJobSigesCode.setObject(generateSigesCode);
+            paramsJob.add(paramJobSigesCode);
+        }
 .5.0/docs/api/java/lang/Class.html">Class reportGeneratorServiceClass = 1.5.0/docs/api/java/lang/Class.html">Class.forName(reportGroup.getReportProcessorClass());
         JobServiceTask job = JobDeamon.createServiceJob(reportGeneratorServiceClass, session.getUser(), paramsJob,
                 "Service: Geração de Reports para o group " + reportGroupId + " - " + reportGroup.getTitle());
         reportGroup.setReportGenerationTaskId(job.getId());
+    }
+    /****************************************************************************/
+    /* SERVICOS WS-API
+    /****************************************************************************/
+    /**
+     *
+     * @param sigesCode
+     * @param year
+     * @param periodIncluded
+     * @return an encoded DataTable in JSON (pt.estgp.estgweb.services.questionarios.pedagogico.reportprocessors.utils.DataTable)
+     * @throws IOException
+     */
+    public 1.5.0/docs/api/java/lang/String.html">String loadReportUnidadesSalasJson(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String year, 1.5.0/docs/api/java/lang/String.html">String periodIncluded) throws 1.5.0/docs/api/java/io/IOException.html">IOException, JSONException {
+        if(Globals.SYSTEM_WSJSON_SERVICE_COURSE_REPORT_RESULTS.indexOf("localhost")>=0)
+        {
+            Criteria c = DaoFactory.getQuestionarioReportCursoFileDaoImpl().createCriteria();
+            c.createAlias("reportGroup","rg");
+            c.add(like("rg.periodos","%" + periodIncluded + "%"));
+            c.add(eq("rg.importYear",year));
+            c.add(eq("entityCode",sigesCode));
+            List<QuestionarioReportCursoFile> files = c.list();
+            if(files.size() == 0)
+            {
+                return "{}";
+            }
+            return files.get(0).getCourseReportQuestionsJson();
+        }
+        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_REPORT_RESULTS + "?code=" + sigesCode + "&year=" + year);
++0%2Fdocs%2Fapi+InputStream">InputStream is = url.openStream();
+.5.0/docs/api/java/lang/String.html">String json = StreamsUtils.readString(is);
+            is.close();
+            JSONObject jsonObject = new JSONObject(json);
+            return jsonObject.getString("response").toString();
+        }
+    }
+    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();
+.5.0/docs/api/java/lang/String.html">String json = new QuestionariosReportsService().loadReportUnidadesSalasJson("9119", "201516", "S2");
+        DataTable d = DataTable.fromJson(json);
+.5.0/docs/api/java/lang/System.html">System.out.println(d.toJson());
+.5.0/docs/api/java/lang/System.html">System.out.println(d.toJson().equals(json));
+        AbstractDao.getCurrentSession().getTransaction().commit();
+    }
+}

Subversion Repositories bacoAlunos

(root)/branches/v3/impl/src/java/pt/estgp/estgweb/services/questionarios/QuestionariosReportsService.java @ 1830 - Rev 1629 → 1830