コード例 #1
0
 @Override
 public List<StockUpdate> executeQueryStockUpdate() throws Exception {
   java.util.List<com.app.shared.healthcontext.StockUpdate> listDtoInterface =
       new java.util.ArrayList<com.app.shared.healthcontext.StockUpdate>();
   try {
     atg.taglib.json.util.JSONObject queryParams = new atg.taglib.json.util.JSONObject();
     queryParams.put("queryId", "3BCC374A-1D8F-4747-9C8D-564B177DCB6B");
     atg.taglib.json.util.JSONArray jsonArray = new atg.taglib.json.util.JSONArray();
     queryParams.put("queryCriteria", jsonArray);
     listDtoInterface =
         queryExecuterService.getAllQueryData(
             "com.app.shared.healthcontext.StockUpdate", queryParams);
   } catch (Exception e) {
     e.printStackTrace();
   }
   return listDtoInterface;
 }
コード例 #2
0
  @SuppressWarnings("unused")
  @RequestMapping(method = RequestMethod.GET, value = "/resultado.html")
  public void resultadoJSON(
      @RequestParam("total") int total,
      HttpServletRequest request,
      HttpServletResponse response,
      ModelMap model)
      throws UnsupportedEncodingException, JSONException {

    PesquisaForm form = new PesquisaForm();
    Usuario obj = super.getUsuarioLogado();

    Carteira carteira = carteiraService.selectById(obj.getIdCarteira());

    form.setCarteira(carteira);
    form.setPapel(obj.getUsuPapel());
    form.setTotal(total);

    PrintWriter writer = null;

    try {
      writer = response.getWriter();
    } catch (IOException ex) {
      System.err.println(
          PesquisaController.class.getName() + "ocorreu uma exceção: " + ex.getMessage());
    }

    String[] cols = {
      "details.idDocumentoDetalhes",
      "details.tipoDocumento.tipoDocumentoNome",
      "details.nrProtocolo",
      "details.nrDocumento",
      "details.assunto",
      "details.dataEntSistema"
    };

    JSONObject result = new JSONObject();
    JSONArray array = new JSONArray();
    int amount = 5;
    int start = 0;
    int echo = 0;
    int col = 0;

    String id = "";
    String tipo = "";
    String protocolo = "";
    String nrDoc = "";
    String assunto = "";
    String data = "";

    String dir = "asc";
    String sStart = request.getParameter("iDisplayStart");
    String sAmount = request.getParameter("iDisplayLength");
    String sEcho = request.getParameter("sEcho");
    String sCol = request.getParameter("iSortCol_0");
    String sdir = request.getParameter("sSortDir_0");
    boolean bServerSide =
        (((String) request.getParameter("bServerSide")).equals("true") ? true : false);
    form.setServerSide(bServerSide);

    // id = request.getParameter("sSearch_0");

    tipo = request.getParameter("sSearch_0");
    if (tipo != null) form.setTipoDocumento(tipo);

    protocolo = request.getParameter("sSearch_1");
    if (protocolo != null) form.setNrProtocol(protocolo);

    nrDoc = request.getParameter("sSearch_2");
    if (nrDoc != null) form.setNrDocumento(nrDoc);

    assunto = request.getParameter("sSearch_3");
    if (assunto != null) form.setAssunto(assunto);

    data = request.getParameter("sSearch_4");
    if (data != null) form.setDataEntSistema(DataTimeUtil.convertKeyUpFormatBrazilToUS(data));

    if (sStart != null) {
      start = Integer.parseInt(sStart);
      if (start < 0) start = 0;
    }
    form.setStart(start);

    if (sAmount != null) {
      amount = Integer.parseInt(sAmount);
      if (amount < 5 || amount > 100) amount = 10;
    }
    form.setAmount(amount);

    if (sEcho != null) {
      echo = Integer.parseInt(sEcho);
    }
    form.setEcho(echo);

    if (sCol != null) {
      col = Integer.parseInt(sCol);
      if (col < 0 || col > 6) col = 0;
    }
    form.setCol(col);

    if (sdir != null) {
      if (!sdir.equals("asc")) dir = "desc";
    }
    form.setDir(dir);

    String colName = cols[col];
    form.setColName(colName);

    String searchTerm = request.getParameter("sSearch");
    if (searchTerm != null)
      form.setSearchTerm(DataTimeUtil.convertKeyUpFormatBrazilToUS(searchTerm));

    int totalAfterFilter = total;

    List<DocumentoCompleto> docs = (List<DocumentoCompleto>) documentoService.returnSearch(form);

    if (searchTerm != "" || form.getIndividualSearch() != "")
      totalAfterFilter = docs.size() > 0 ? docs.get(0).getTotal() : 0;

    /*for( int i=0; i<docs.size(); i++ ){
    	DocumentoCompleto dc = docs.remove(i);

    	JSONArray ja = new JSONArray();
    	ja.put(String.valueOf(dc.getDocumentoDetalhes().getIdDocumentoDetalhes()));
    	ja.put(dc.getDocumentoDetalhes().getTipoDocumento().getTipoDocumentoNome());
    	ja.put(dc.getDocumentoDetalhes().getNrProtocolo());
    	ja.put(dc.getDocumentoDetalhes().getNrDocumento());
    	ja.put(dc.getDocumentoDetalhes().getAssunto());
    	ja.put(DataTimeUtil.getBrazilFormatDataHora(dc.getDocumentoDetalhes().getDataEntSistema()));
    	array.put(ja);
    }*/

    Iterator<DocumentoCompleto> ite = docs.iterator();

    while (ite.hasNext()) {
      DocumentoCompleto dc = ite.next();

      JSONArray ja = new JSONArray();
      ja.put(String.valueOf(dc.getDocumentoDetalhes().getIdDocumentoDetalhes()));
      ja.put(dc.getDocumentoDetalhes().getTipoDocumento().getTipoDocumentoNome());
      ja.put(dc.getDocumentoDetalhes().getNrProtocolo());
      ja.put(dc.getDocumentoDetalhes().getNrDocumento());
      ja.put(dc.getDocumentoDetalhes().getAssunto());
      ja.put(DataTimeUtil.getBrazilFormatDataHora(dc.getDocumentoDetalhes().getDataEntSistema()));
      array.put(ja);
    }

    docs = null;

    response.setHeader("Content-Type", "application/json; charset=ISO-8859-1");

    result.put("iTotalRecords", total);
    result.put("iTotalDisplayRecords", totalAfterFilter);
    result.put("aaData", array);

    writer.print(result);

    writer.flush();
    writer.close();
  }