@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;
}
@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();
}