Metodo grava LOG, atualizado com resposta do mediador

A data da resposta deve ser nula no armazenamento e atualizada com data atual apos após uso do metodo grava log

diff --git a/src/java/org/ufcspa/simdecs/comunicacao/MetodoParaGravarLog.java b/src/java/org/ufcspa/simdecs/comunicacao/MetodoParaGravarLog.java
index dfe2200..0101ca6 100644 (file)
--- a/src/java/org/ufcspa/simdecs/comunicacao/MetodoParaGravarLog.java
+++ b/src/java/org/ufcspa/simdecs/comunicacao/MetodoParaGravarLog.java
@@ -6,6 +6,7 @@ package org.ufcspa.simdecs.comunicacao;
 \r
 \r
 import java.io.IOException;\r
+import java.io.PrintWriter;\r
 import java.text.ParseException;\r
 import java.text.SimpleDateFormat;\r
 import java.util.Date;\r
@@ -13,6 +14,7 @@ import java.util.logging.Level;
 import java.util.logging.Logger;\r
 import javax.persistence.EntityManager;\r
 import javax.persistence.EntityManagerFactory;\r
+import javax.persistence.NoResultException;\r
 import javax.persistence.Persistence;\r
 import javax.servlet.ServletException;\r
 import javax.servlet.http.HttpServlet;\r
@@ -20,6 +22,9 @@ import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;\r
 import javax.servlet.http.HttpSession;\r
 import org.ufcspa.simdecs.entidade.Log;\r
+import org.ufcspa.simdecs.entidade.RespostaMediador;\r
+import org.ufcspa.simdecs.entidade.Usuario;\r
+import org.ufcspa.simdecs.util.UtilitarioSql;\r
 \r
 /**\r
  *\r
@@ -37,24 +42,7 @@ public class MetodoParaGravarLog extends HttpServlet {
      * @throws ServletException if a servlet-specific error occurs\r
      * @throws IOException if an I/O error occurs\r
      */\r
-    public java.sql.Date converteDataUtilToSql(Date data) {  \r
   \r
-       SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy");  \r
-  \r
-       Date dataUtil = data;  \r
-       java.sql.Date dataSql = null;  \r
-  \r
-       try {  \r
-           dataUtil = new java.sql.Date(dataUtil.getTime());  \r
-           dataSql = (java.sql.Date) dataUtil;  \r
-  \r
-       } catch (Exception e) {  \r
-           //JOptionPane.showMessageDialog(null, "Erro ao converte data para sql: " + e.getMessage());  \r
-       }  \r
-  \r
-  \r
-       return dataSql;  \r
-   }  \r
     protected void processRequest(HttpServletRequest request, HttpServletResponse response)\r
             throws ServletException, IOException, ParseException {\r
        HttpSession session = request.getSession(true);\r
@@ -62,19 +50,64 @@ public class MetodoParaGravarLog extends HttpServlet {
 \r
         Date dt = new Date();\r
         Long idLong = new Long(request.getParameter("id"));\r
-\r
+        UtilitarioSql util = new UtilitarioSql();\r
+        PrintWriter out = response.getWriter();\r
+        // alteracao solicitado mosmmann \r
+        //response.setContentType("text/html;charset=UTF-8");\r
+        \r
+        response.setContentType( "text/xml" );\r
+        response.setHeader( "Cache-Control", "no-cache" );\r
+        out.println( "<xml>" );\r
         \r
         \r
         EntityManagerFactory emf = Persistence.createEntityManagerFactory("simdecsPU");\r
         EntityManager em = emf.createEntityManager();\r
         em.getTransaction().begin();\r
         Log lg =new Log();\r
-        lg.setDatalog(converteDataUtilToSql(dt));        \r
+        lg.setDatalog(util.converteDataUtilToSql(dt));        \r
         lg.setDescricaolog(request.getParameter("log"));\r
         lg.setHoralog(dt);\r
         lg.setUsuid(idLong);\r
         em.persist(lg);\r
         em.getTransaction().commit();\r
+        \r
+        RespostaMediador resp;\r
+\r
+        try {\r
+                em.getTransaction().begin();\r
+               resp = (RespostaMediador) em.createQuery("select resposta from RespostaMediador as resposta where resposta.idUsuario=:id and resposta.dataResposta is null" )\r
+                                                                               .setParameter("id", idLong)\r
+                                                                               //.setParameter("data",dtNull )\r
+                                                                               .getSingleResult();\r
+                if(resp.getId()>0)\r
+                {\r
+                    out.println( "<id>" + String.valueOf(resp.getId()) + "</id>" );\r
+                    out.println("<resposta>" + resp.getNome() + "</resposta>");\r
+                    out.println("<arquivo>" + resp.getEndArquivo() + "</arquivo>");\r
+                    resp.setDataResposta(util.converteDataUtilToSql(dt));\r
+                }\r
+                else \r
+                {\r
+                    out.println( "<id>0</id>" );\r
+                    out.println("<resposta></resposta>");\r
+                    out.println("<arquivo></arquivo>");\r
+                }\r
+                \r
+//                out.println("OK "+ user.getId());\r
+//                out.close();\r
+       } catch (NoResultException ne) {\r
+            \r
+//             request.setAttribute("id","0");         \r
+//             out.println("Usuario ou senha Inválido ");\r
+                out.println( "<id>" + "0" + "</id>" );\r
+                \r
+       } finally {         \r
+            em.persist(lg);\r
+            em.getTransaction().commit();\r
+            out.println( "</xml>" );\r
+            out.close();\r
+        }\r
+        \r
 \r
     }\r
 \r