\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
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
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.comunicacao.util.UtilitarioSql;\r
\r
/**\r
*\r
* @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
\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