package br.com.centralit.citcorpore.ajaxForms;
import java.awt.Color;
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.Writer;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Date;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.axis.AxisLocation;
import org.jfree.chart.axis.NumberAxis;
import org.jfree.chart.labels.ItemLabelAnchor;
import org.jfree.chart.labels.ItemLabelPosition;
import org.jfree.chart.labels.StandardCategoryItemLabelGenerator;
import org.jfree.chart.labels.StandardPieSectionLabelGenerator;
import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.plot.PiePlot;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.chart.renderer.category.BarRenderer;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.data.general.DefaultPieDataset;
import org.jfree.ui.TextAnchor;
import org.w3c.dom.Document;
import org.w3c.dom.NamedNodeMap;
import org.w3c.dom.Node;
import br.com.centralit.citajax.html.AjaxFormAction;
import br.com.centralit.citajax.html.DocumentHTML;
import br.com.centralit.citajax.html.HTMLElement;
import br.com.centralit.citcorpore.bean.BIConsultaDTO;
import br.com.centralit.citcorpore.bean.UsuarioDTO;
import br.com.centralit.citcorpore.metainfo.bean.CamposObjetoNegocioDTO;
import br.com.centralit.citcorpore.metainfo.util.HashMapUtil;
import br.com.centralit.citcorpore.negocio.BIConsultaService;
import br.com.centralit.citcorpore.util.CITCorporeUtil;
import br.com.centralit.citcorpore.util.Enumerados.TipoDate;
import br.com.centralit.citcorpore.util.WebUtil;
import br.com.centralit.citgerencial.bean.GerencialOptionDTO;
import br.com.centralit.citgerencial.bean.GerencialOptionsDTO;
import br.com.centralit.citgerencial.bean.GerencialParameterDTO;
import br.com.centralit.citgerencial.negocio.GerencialGenerate;
import br.com.centralit.citgerencial.util.WebUtilGerencial;
import br.com.citframework.dto.Usuario;
import br.com.citframework.excecao.LogicException;
import br.com.citframework.excecao.ServiceException;
import br.com.citframework.integracao.JdbcEngine;
import br.com.citframework.service.ServiceLocator;
import br.com.citframework.util.Constantes;
import br.com.citframework.util.UtilDatas;
import br.com.citframework.util.UtilI18N;
import br.com.citframework.util.UtilStrings;
import br.com.citframework.util.UtilTratamentoArquivos;
import com.lowagie.text.Font;
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
public class GeraTemplateReport extends AjaxFormAction{
private static final Color COR_FUNDO = Color.WHITE;
private static final Color COR_TITULO = Color.BLACK;
@Override
public void load(DocumentHTML document, HttpServletRequest request,
HttpServletResponse response) throws Exception {
BIConsultaDTO biConsultaParm = (BIConsultaDTO)document.getBean();
BIConsultaService biConsultaService = (BIConsultaService) ServiceLocator.getInstance().getService(BIConsultaService.class, null);
UsuarioDTO user = WebUtil.getUsuario(request);
if (user == null) {
document.alert(UtilI18N.internacionaliza(request, "citcorpore.comum.sessaoExpirada"));
document.executeScript("window.location = '" + Constantes.getValue("SERVER_ADDRESS") + request.getContextPath() + "'");
return;
}
Usuario userGer = WebUtilGerencial.getUsuario(request);
BIConsultaDTO biConsultaDTO = new BIConsultaDTO();
biConsultaDTO.setIdConsulta(biConsultaParm.getIdConsulta());
request.setAttribute("idConsulta", "" + biConsultaParm.getIdConsulta());
try{
biConsultaDTO = (BIConsultaDTO) biConsultaService.restore(biConsultaDTO);
}catch(Exception e){
document.alert("Consulta inexistente!");
return;
}
if (biConsultaDTO == null){
document.alert("Consulta inexistente!");
return;
}
HashMap hashParametros = null;
if (biConsultaDTO.getParametros() != null && !biConsultaDTO.getParametros().trim().equalsIgnoreCase("")){
biConsultaDTO.setListParameters(getSubTreeParameters(biConsultaDTO.getParametros()));
hashParametros = getParametrosInformados(request);
}
if (!biConsultaParm.isParametersPreenchidos() && biConsultaDTO.getListParameters() != null && biConsultaDTO.getListParameters().size() > 0) {
HTMLElement divParametros = document.getElementById("divParametros");
request.setAttribute("htmlProcess", "");
divParametros.setInnerHTML(geraParametrosPainel(biConsultaDTO.getListParameters(), hashParametros, userGer, true, request));
document.executeScript("DEFINEALLPAGES_atribuiCaracteristicasCitAjax()");
// document.executeScript("$('#POPUP_PARAM').attr('title','" + gerencialPainelDto.getDescription() + "')");
document.executeScript("HTMLUtils.focusInFirstActivateField(document.formParametros)");
document.executeScript("pageLoad();");
document.executeScript("$('#POPUP_PARAM').dialog('open')");
return;
}
JdbcEngine jdbcEngine = null;
if (CITCorporeUtil.JDBC_ALIAS_REPORTS != null && !CITCorporeUtil.JDBC_ALIAS_REPORTS.trim().equalsIgnoreCase("")){
jdbcEngine = new JdbcEngine(CITCorporeUtil.JDBC_ALIAS_REPORTS, null);
}else{
jdbcEngine = new JdbcEngine(Constantes.getValue("DATABASE_ALIAS"), null);
}
Map<String, Object> data = new HashMap<String, Object>();
List result = new ArrayList();
List result1 = new ArrayList();
List result2 = new ArrayList();
List result3 = new ArrayList();
List result4 = new ArrayList();
List result5 = new ArrayList();
List result6 = new ArrayList();
List result7 = new ArrayList();
List result8 = new ArrayList();
List result9 = new ArrayList();
String strResult = new String("");
String strResult1 = new String("");
String strResult2 = new String("");
String strResult3 = new String("");
String strResult4 = new String("");
String strResult5 = new String("");
String strResult6 = new String("");
String strResult7 = new String("");
String strResult8 = new String("");
String strResult9 = new String("");
String formula = biConsultaDTO.getScriptExec();
if (formula != null && !formula.trim().equalsIgnoreCase("")){
org.mozilla.javascript.Context cx = org.mozilla.javascript.Context.enter();
org.mozilla.javascript.Scriptable scope = cx.initStandardObjects();
String sourceName = this.getClass().getName() + "_Script";
String retorno = "";
formula = formula.replaceAll("TEXTSEARCH", "utilStrings.generateNomeBusca");
formula = formula.replaceAll("GETFIELD", "hashMapUtil.getFieldInHash");
scope.put("user", scope, user);
scope.put("httpRequest", scope, request);
scope.put("hashParametros", scope, hashParametros);
scope.put("consultaDTO", scope, biConsultaDTO);
scope.put("objGeraTemplateReport", scope, this);
scope.put("retorno", scope, retorno);
scope.put("utilStrings", scope, new UtilStrings());
scope.put("hashMapUtil", scope, new HashMapUtil());
scope.put("jdbcEngine", scope, jdbcEngine);
scope.put("SGBD_PRINCIPAL", scope, CITCorporeUtil.SGBD_PRINCIPAL);
scope.put("result", scope, result);
scope.put("result1", scope, result1);
scope.put("result2", scope, result2);
scope.put("result3", scope, result3);
scope.put("result4", scope, result4);
scope.put("result5", scope, result5);
scope.put("result6", scope, result6);
scope.put("result7", scope, result7);
scope.put("result8", scope, result8);
scope.put("result9", scope, result9);
scope.put("strResult", scope, strResult);
scope.put("strResult1", scope, strResult1);
scope.put("strResult2", scope, strResult2);
scope.put("strResult3", scope, strResult3);
scope.put("strResult4", scope, strResult4);
scope.put("strResult5", scope, strResult5);
scope.put("strResult6", scope, strResult6);
scope.put("strResult7", scope, strResult7);
scope.put("strResult8", scope, strResult8);
scope.put("strResult9", scope, strResult9);
scope.put("dataToTemplate", scope, data);
Object resultEval = cx.evaluateString(scope, formula, sourceName, 1, null);
}
File f = new File(CITCorporeUtil.CAMINHO_REAL_APP + "/templateFreeMarker/" + user.getIdUsuario());
if (!f.exists()){
f.mkdirs();
}
String strPathTemplate = CITCorporeUtil.CAMINHO_REAL_APP + "/templateFreeMarker/" + user.getIdUsuario() + "/CONS_" + biConsultaDTO.getIdConsulta() + "_PROCESS.ftl";
UtilTratamentoArquivos.geraFileTxtFromString(strPathTemplate, biConsultaDTO.getTemplate());
String strPathTemplateCAB = strPathTemplate.replaceAll(".ftl", ".html");
geraTemplate("templateFreeMarker/" + user.getIdUsuario() + "/CONS_" + biConsultaDTO.getIdConsulta() + "_PROCESS.ftl", data, strPathTemplateCAB);
String strCabecalho = UtilTratamentoArquivos.getStringTextFromFileTxtTemplate(strPathTemplateCAB);
String strFinal = encode(strCabecalho);
request.setAttribute("htmlProcess", strFinal );
System.out.println(strFinal);
}
private void geraTemplate(String strPathTemplate, Map<String, Object> data, String strPathOutput) throws IOException, TemplateException{
Configuration cfg = new Configuration();
cfg.setDirectoryForTemplateLoading(new File(CITCorporeUtil.CAMINHO_REAL_APP));
Template template = cfg.getTemplate(strPathTemplate, "ISO-8859-1");
Writer file = new FileWriter(new File(strPathOutput));
template.process(data, file);
file.flush();
file.close();
}
public String generateGrafico_Pizza(boolean is3D, List listRetorno, UsuarioDTO usuario, String titulo, boolean percentagem, Integer tam, Integer alt, HttpServletRequest request) {
JFreeChart chart;
DefaultPieDataset dados = new DefaultPieDataset();
Double objDouble;
String objString1;
if (listRetorno == null) {
listRetorno = new ArrayList();
}
for (int i = 0; i < listRetorno.size(); i++) {
Object[] row = (Object[]) listRetorno.get(i);
objDouble = new Double(0);
objString1 = "";
for (int j = 0; j < row.length; j++) {
Object obj = row[j];
objDouble = null;
if (Integer.class.isInstance(obj)) {
objDouble = new Double(((Integer) obj).intValue());
} else if (Long.class.isInstance(obj)) {
objDouble = new Double(((Long) obj).intValue());
} else if (Double.class.isInstance(obj)) {
objDouble = new Double(((Double) obj).doubleValue());
} else {
if (BigDecimal.class.isInstance(obj)) {
objDouble = new Double(((BigDecimal) obj).doubleValue());
} else if (Long.class.isInstance(obj)) {
objDouble = new Double(((Long) obj).doubleValue());
} else if (Integer.class.isInstance(obj)) {
objDouble = new Double(((Integer) obj).doubleValue());
} else if (BigInteger.class.isInstance(obj)) {
objDouble = new Double(((BigInteger) obj).doubleValue());
//} else {
// objDouble = (Double) obj;
}
}
if (objDouble == null) {
objDouble = new Double(0);
}
if (String.class.isInstance(obj)) {
if (obj == null) {
obj = new String("");
}
objString1 = (String) obj;
}
}
dados.setValue(objString1, objDouble.doubleValue());
}
if (is3D) {
chart = ChartFactory.createPieChart3D(titulo, dados, true, true, false);
} else {
chart = ChartFactory.createPieChart(titulo, dados, true, true, false);
}
chart.setBackgroundPaint(COR_FUNDO);
chart.getTitle().setPaint(COR_TITULO);
chart.getTitle().setFont(new java.awt.Font("arial", Font.BOLD, 12));
chart.getPlot().setOutlinePaint(null);
chart.getPlot().setBackgroundPaint(new Color(221, 227, 213));
PiePlot piePlot = (PiePlot) chart.getPlot();
piePlot.setNoDataMessage(UtilI18N.internacionaliza(request, "citcorpore.comum.naoHaDadosParaApresentar"));
//piePlot.setNoDataMessage("N�o h� dados.");
if(percentagem)
piePlot.setLabelGenerator(new StandardPieSectionLabelGenerator("({0}) {1} - {2}"));
else
piePlot.setLabelGenerator(new StandardPieSectionLabelGenerator("{0} = {1}", new DecimalFormat("0"), new DecimalFormat("0")));
String caminhoRelativo = "";
String caminho = "";
try {
String strPath = CITCorporeUtil.CAMINHO_REAL_APP + "/tempFiles/" + usuario.getIdUsuario();
File arquivo = new File(CITCorporeUtil.CAMINHO_REAL_APP + "/tempFiles");
if (!arquivo.exists()) {
arquivo.mkdirs();
}
File arquivoVer = new File(strPath);
if (!arquivoVer.exists()) {
arquivoVer.mkdirs();
}
String fileName = "GRFTMPL_"
+ UtilDatas.convertDateToString(TipoDate.TIMESTAMP_WITH_SECONDS, UtilDatas.getDataHoraAtual(), WebUtil.getLanguage(request)).replaceAll("/", "_").replaceAll(":", "_").replaceAll(" ", "_") + ".png";
caminho = strPath + "/" + fileName;
String urlInicial = "";
try {
//urlInicial = ParametroUtil.getValorParametroCitSmartHashMap(Enumerados.ParametroSistema.URL_Sistema, "");
} catch (Exception e) {
e.printStackTrace();
}
if (urlInicial == null || urlInicial.trim().equalsIgnoreCase("")){
urlInicial = Constantes.getValue("CONTEXTO_APLICACAO");
}
caminhoRelativo = urlInicial + "/tempFiles" + "/" + usuario.getIdUsuario() + "/" + fileName;
arquivo = new File(caminho);
if (arquivo.exists()) {
arquivo.delete();
}
ChartUtilities.saveChartAsPNG(arquivo, chart, tam, alt);
} catch (IOException e) {
e.printStackTrace();
}
return "<img src=\"" + caminhoRelativo + "\"/>";
}
public Object generateRetornoGrafico_Barra(boolean is3D, List listRetorno, UsuarioDTO usuario, String titulo, boolean percentagem, Integer tam, Integer alt, HttpServletRequest request) throws Exception {
JFreeChart chart;
DefaultCategoryDataset dados = new DefaultCategoryDataset();
Double objDouble;
String objString1;
String objString2;
int qtdeColunas = 0;
int posString = 0;
int qtdeLinhas = 0;
for (int i = 0; i < listRetorno.size(); i++) {
Object[] row = (Object[]) listRetorno.get(i);
qtdeColunas = row.length - 1;
objDouble = new Double(0);
objString1 = "";
objString2 = "";
posString = 0;
qtdeLinhas++;
for (int j = 0; j < row.length; j++) {
Object obj = row[j];
objDouble = null;
if (Integer.class.isInstance(obj)) {
objDouble = new Double(((Integer) obj).intValue());
} else if (Long.class.isInstance(obj)) {
objDouble = new Double(((Long) obj).intValue());
} else if (Double.class.isInstance(obj)) {
objDouble = new Double(((Double) obj).doubleValue());
} else {
if (BigDecimal.class.isInstance(obj)) {
objDouble = new Double(((BigDecimal) obj).doubleValue());
} else if (Long.class.isInstance(obj)) {
objDouble = new Double(((Long) obj).doubleValue());
} else if (Integer.class.isInstance(obj)) {
objDouble = new Double(((Integer) obj).doubleValue());
} else if (BigInteger.class.isInstance(obj)) {
objDouble = new Double(((BigInteger) obj).doubleValue());
//} else {
// objDouble = (Double) obj;
}
}
if (objDouble == null) {
objDouble = new Double(0);
}
if (String.class.isInstance(obj)) {
if (obj == null) {
obj = new String("");
}
String str = "";
str = (String) obj;
if (posString == 0) {
objString1 = str;
} else {
objString2 = str;
}
posString++;
}
}
dados.addValue(objDouble.doubleValue(), objString1, objString2);
}
String t1 = null;
String t2 = null;
if (is3D) {
chart = ChartFactory.createBarChart3D(titulo, t1, t2, dados, PlotOrientation.VERTICAL, true, true, false);
} else {
chart = ChartFactory.createBarChart(titulo, t1, t2, dados, PlotOrientation.VERTICAL, true, true, false);
}
// Setando o valor maximo para nunca passar de 100, ja q se trata de
// porcentagem
CategoryPlot plot = chart.getCategoryPlot();
plot.setRangeAxisLocation(AxisLocation.BOTTOM_OR_LEFT);
plot.getRenderer().setBasePositiveItemLabelPosition(new ItemLabelPosition(ItemLabelAnchor.OUTSIDE1, TextAnchor.CENTER));
NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis();
rangeAxis.setUpperMargin(0.20);
rangeAxis.setAxisLineVisible(true);
rangeAxis.setTickLabelsVisible(true);
rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
// Formatando cores de fundo, fonte do titulo, etc...
chart.setBackgroundPaint(COR_FUNDO); // Cor do fundo do grafico
chart.getTitle().setPaint(COR_TITULO); // Cor do titulo
chart.getTitle().setFont(new java.awt.Font("arial", Font.BOLD, 12)); // Fonte do
chart.getPlot().setBackgroundPaint(new Color(221, 227, 213));// Cor de
chart.getLegend().setItemFont(new java.awt.Font("arial", Font.BOLD, 8));
chart.setBorderVisible(false); // Visibilidade da borda do grafico
BarRenderer rend = (BarRenderer) plot.getRenderer();
// CategoryItemRenderer rend = (CategoryItemRenderer) plot.getRenderer();
rend.setSeriesOutlinePaint(0, Color.BLACK); // Cor da borda das barras do
rend.setBaseItemLabelFont(new java.awt.Font("SansSerif", Font.BOLD, 10));
// rend.setSeriesPaint(0, new Color(70 ,130 ,180)); // Cor das barras do
// rend.setItemMargin(0.10); // Margem entre o eixo Y e a primeira barra do
rend.setBaseItemLabelsVisible(true);
// rend.setBaseItemLabelGenerator(new CustomLabelGenerator());
rend.setBaseItemLabelGenerator(new StandardCategoryItemLabelGenerator());
rend.setSeriesItemLabelsVisible(0, new Boolean(true));
rend.setSeriesItemLabelGenerator(0, new StandardCategoryItemLabelGenerator());
// rend.setSeriesPositiveItemLabelPosition(1, new ItemLabelPosition(ItemLabelAnchor.OUTSIDE11, TextAnchor.BASELINE_CENTER, TextAnchor.BASELINE_CENTER, 50.0));
rend.setPositiveItemLabelPositionFallback(new ItemLabelPosition(ItemLabelAnchor.CENTER, TextAnchor.BASELINE_CENTER, TextAnchor.CENTER, 0.0));
String caminhoRelativo = "";
String caminho = "";
try {
String strPath = CITCorporeUtil.CAMINHO_REAL_APP + "/tempFiles/" + usuario.getIdUsuario();
File arquivo = new File(CITCorporeUtil.CAMINHO_REAL_APP + "/tempFiles");
if (!arquivo.exists()) {
arquivo.mkdirs();
}
File arquivoVer = new File(strPath);
if (!arquivoVer.exists()) {
arquivoVer.mkdirs();
}
String fileName = "GRFTMPLBAR_"
+ UtilDatas.convertDateToString(TipoDate.TIMESTAMP_WITH_SECONDS, UtilDatas.getDataHoraAtual(), WebUtil.getLanguage(request)).replaceAll("/", "_").replaceAll(":", "_").replaceAll(" ", "_") + ".png";
caminho = strPath + "/" + fileName;
String urlInicial = "";
try {
//urlInicial = ParametroUtil.getValorParametroCitSmartHashMap(Enumerados.ParametroSistema.URL_Sistema, "");
} catch (Exception e) {
e.printStackTrace();
}
if (urlInicial == null || urlInicial.trim().equalsIgnoreCase("")){
urlInicial = Constantes.getValue("CONTEXTO_APLICACAO");
}
caminhoRelativo = urlInicial + "/tempFiles" + "/" + usuario.getIdUsuario() + "/" + fileName;
arquivo = new File(caminho);
if (arquivo.exists()) {
arquivo.delete();
}
ChartUtilities.saveChartAsPNG(arquivo, chart, tam, alt);
} catch (IOException e) {
e.printStackTrace();
}
return "<img src=\"" + caminhoRelativo + "\"/>";
}
public String executeScript(String formula, HashMap map, CamposObjetoNegocioDTO camposObjetoNegocioDTO){
if (formula == null){
return null;
}
org.mozilla.javascript.Context cx = org.mozilla.javascript.Context.enter();
org.mozilla.javascript.Scriptable scope = cx.initStandardObjects();
String sourceName = this.getClass().getName() + "_Script";
String retorno = "";
formula = formula.replaceAll("TEXTSEARCH", "utilStrings.generateNomeBusca");
formula = formula.replaceAll("GETFIELD", "hashMapUtil.getFieldInHash");
formula = "retorno = " + formula;
String compl = "var importNames = JavaImporter();\n";
compl += "importNames.importPackage(Packages.br.com.citframework.util);\n";
compl += "importNames.importPackage(Packages.br.com.centralit.citcorpore.metainfo.util);\n";
formula = compl + "\n" + formula;
List result = new ArrayList();
List result1 = new ArrayList();
List result2 = new ArrayList();
List result3 = new ArrayList();
List result4 = new ArrayList();
List result5 = new ArrayList();
List result6 = new ArrayList();
List result7 = new ArrayList();
List result8 = new ArrayList();
List result9 = new ArrayList();
scope.put("retorno", scope, retorno);
scope.put("utilStrings", scope, new UtilStrings());
scope.put("hashMapUtil", scope, new HashMapUtil());
scope.put("result", scope, result);
scope.put("result1", scope, result1);
scope.put("result2", scope, result2);
scope.put("result3", scope, result3);
scope.put("result4", scope, result4);
scope.put("result5", scope, result5);
scope.put("result6", scope, result6);
scope.put("result7", scope, result7);
scope.put("result8", scope, result8);
scope.put("result9", scope, result9);
Object resultEval = cx.evaluateString(scope, formula, sourceName, 1, null);
//System.out.println(cx.toString(result));
return org.mozilla.javascript.Context.toString(resultEval);
}
@Override
public Class<BIConsultaDTO> getBeanClass() {
return BIConsultaDTO.class;
}
public String generateSQL(String sql, UsuarioDTO usuario, Collection colParmsUtilizadosNoSQL) {
sql = sql.replaceAll("\\{IDEMPRESA\\}", "" + usuario.getIdEmpresa());
sql = sql.replaceAll("\\{DATAATUAL\\}", "'" + UtilDatas.dateToSTR(UtilDatas.getDataAtual()) + "'");
boolean b = true;
while (b) {
int beginIndex = sql.indexOf("{PARAM");
if (beginIndex >= 0) {
int endIndex = sql.indexOf("}");
String nameParm = sql.substring(beginIndex, endIndex);
nameParm = nameParm.replaceAll("\\{", "");
sql = sql.replaceFirst("\\{" + nameParm + "\\}", "?");
colParmsUtilizadosNoSQL.add(nameParm);
} else {
b = false;
}
}
return sql;
}
public List generateParameters(HashMap hsmParms, UsuarioDTO usuario, Collection colParmsUtilizadosNoSQL, Collection colDefinicaoParametros) {
if (colParmsUtilizadosNoSQL == null || colParmsUtilizadosNoSQL.size() == 0) {
return null;
}
List lstRetorno = new ArrayList();
for (Iterator it = colParmsUtilizadosNoSQL.iterator(); it.hasNext();) {
String nameParm = (String) it.next();
String type = getTypeParametro(colDefinicaoParametros, nameParm);
String valor = (String) hsmParms.get(nameParm);
if (type.equalsIgnoreCase("java.sql.Date")) {
Date data = null;
try {
data = UtilDatas.strToSQLDate(valor);
} catch (LogicException e) {
e.printStackTrace();
}
lstRetorno.add(data);
}
if (type.equalsIgnoreCase("java.lang.Integer")) {
Integer intAux = null;
if (valor == null) {
intAux = new Integer(0);
} else {
intAux = new Integer(valor);
}
lstRetorno.add(intAux);
}
if (type.equalsIgnoreCase("java.lang.Double")) {
Double duplo;
String aux = valor;
aux = aux.replaceAll("\\.", "");
aux = aux.replaceAll("\\,", "\\.");
duplo = new Double(Double.parseDouble(aux));
lstRetorno.add(duplo);
}
if (type.equalsIgnoreCase("java.lang.String")) {
lstRetorno.add(valor);
}
}
return lstRetorno;
}
private String getTypeParametro(Collection colDefinicaoParametros, String nameParm) {
if (colDefinicaoParametros == null) {
return "";
}
for (Iterator it = colDefinicaoParametros.iterator(); it.hasNext();) {
GerencialParameterDTO gerencialParameterDTO = (GerencialParameterDTO) it.next();
String nomeParmAux = "PARAM." + gerencialParameterDTO.getName().trim();
if (nomeParmAux.equalsIgnoreCase(nameParm)) {
return gerencialParameterDTO.getType();
}
}
return "";
}
private String geraParametrosPainel(List listParameters, HashMap hashParametros, Usuario user, boolean reload, HttpServletRequest request) throws ServiceException, Exception {
String strRetorno = "<table>";
for (Iterator it = listParameters.iterator(); it.hasNext();) {
GerencialParameterDTO gerencialParameterDto = (GerencialParameterDTO) it.next();
strRetorno += "<tr>";
strRetorno += "<td>";
strRetorno += UtilI18N.internacionaliza(request, gerencialParameterDto.getDescription());
if (gerencialParameterDto.isMandatory()) {
strRetorno += "*";
}
strRetorno += "</td>";
strRetorno += "<td>";
strRetorno += geraCampo(gerencialParameterDto, listParameters, hashParametros, user, reload, request);
strRetorno += "</td>";
strRetorno += "</tr>";
}
strRetorno += "</table>";
return strRetorno;
}
private String geraCampo(GerencialParameterDTO gerencialParameterDto, List listParameters, HashMap hashParametros, Usuario user, boolean reload, HttpServletRequest request)
throws ServiceException, Exception {
String strRetorno = "";
String strValid = "";
if (gerencialParameterDto.isMandatory()) {
strValid = "Required";
}
// Verifica se o campo tem o tipo HTML como select.
if (gerencialParameterDto.getTypeHTML() != null && gerencialParameterDto.getTypeHTML().equalsIgnoreCase("select")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
strRetorno += "<select size='" + gerencialParameterDto.getSize() + "' name='PARAM." + gerencialParameterDto.getName() + "' id='PARAM." + gerencialParameterDto.getName()
+ "' class='Description[" + gerencialParameterDto.getDescription() + "]" + strValidCompleta + "'";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onchange='recarrega(this)'";
}
String value = "#$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%"; // Valor absurdo!!!! So sera usado se nao foi informado o parametro.
if (reload) {
value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value == null) {
value = "#$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%";
}
}
strRetorno += ">";
if (gerencialParameterDto.getColOptions() != null) {
for (Iterator it = gerencialParameterDto.getColOptions().iterator(); it.hasNext();) {
Object obj = it.next();
if (GerencialOptionDTO.class.isInstance(obj)) {
GerencialOptionDTO option = (GerencialOptionDTO) obj;
strRetorno += "<option value='" + option.getValue() + "'";
if (reload) {
if (option.getValue().equalsIgnoreCase(value)) {
strRetorno += " selected ";
}
}
strRetorno += ">" + UtilI18N.internacionaliza(request, option.getText()) + "</option>";
}
if (GerencialOptionsDTO.class.isInstance(obj)) {
GerencialOptionsDTO options = (GerencialOptionsDTO) obj;
if (options.isOnload() || reload) {
GerencialGenerate gerencialGenerateService = (GerencialGenerate) ServiceLocator.getInstance().getService(GerencialGenerate.class, WebUtil.getUsuarioSistema(request));
Collection col = gerencialGenerateService.executaSQLOptions(options, listParameters, hashParametros, user);
for (Iterator itOptions = col.iterator(); itOptions.hasNext();) {
GerencialOptionDTO option = (GerencialOptionDTO) itOptions.next();
strRetorno += "<option value='" + option.getValue() + "'";
if (reload) {
if (option.getValue().equalsIgnoreCase(value)) {
strRetorno += " selected ";
}
}
strRetorno += ">" + option.getText() + "</option>";
}
}
}
}
}
strRetorno += "</select>";
}
// Verifica se o campo tem o tipo HTML como checkbox.
if (gerencialParameterDto.getTypeHTML() != null && gerencialParameterDto.getTypeHTML().equalsIgnoreCase("checkbox")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
String value = "#$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%"; // Valor absurdo!!!! So sera usado se nao foi informado o parametro.
if (reload) {
value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value == null) {
value = "#$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%$#%";
}
}
if (gerencialParameterDto.getColOptions() != null) {
String strRetornoAux = "";
int qtdeOpcoes = 0;
for (Iterator it = gerencialParameterDto.getColOptions().iterator(); it.hasNext();) {
Object obj = it.next();
if (GerencialOptionDTO.class.isInstance(obj)) {
qtdeOpcoes++;
GerencialOptionDTO option = (GerencialOptionDTO) obj;
strRetornoAux += "<input type='checkbox' name='PARAM." + gerencialParameterDto.getName() + "' id='PARAM." + gerencialParameterDto.getName() + "' class='Description["
+ gerencialParameterDto.getDescription() + "] " + strValidCompleta + "' value='" + option.getValue() + "'";
if (reload) {
if (option.getValue().equalsIgnoreCase(value)) {
strRetornoAux += " checked='checked' ";
}
}
if (gerencialParameterDto.isReload()) {
// strRetornoAux += " onclick='recarrega(this)'";
}
strRetornoAux += "/>" + option.getText() + "<br/>";
}
if (GerencialOptionsDTO.class.isInstance(obj)) {
GerencialOptionsDTO options = (GerencialOptionsDTO) obj;
if (options.isOnload() || reload) {
GerencialGenerate gerencialGenerateService = (GerencialGenerate) ServiceLocator.getInstance().getService(GerencialGenerate.class, WebUtil.getUsuarioSistema(request));
Collection col = gerencialGenerateService.executaSQLOptions(options, listParameters, hashParametros, user);
for (Iterator itOptions = col.iterator(); itOptions.hasNext();) {
qtdeOpcoes++;
GerencialOptionDTO option = (GerencialOptionDTO) itOptions.next();
strRetornoAux += "<input type='checkbox' name='PARAM." + gerencialParameterDto.getName() + "' id='PARAM." + gerencialParameterDto.getName() + "' class='Description["
+ gerencialParameterDto.getDescription() + "] " + strValidCompleta + "' value='" + option.getValue() + "'";
if (reload) {
if (option.getValue().equalsIgnoreCase(value)) {
strRetornoAux += " checked='checked' ";
}
}
if (gerencialParameterDto.isReload()) {
// strRetornoAux += " onclick='recarrega(this)'";
}
strRetornoAux += "/>" + option.getText() + "<br/>";
}
}
}
}
if (!strRetornoAux.equalsIgnoreCase("")) {
if (qtdeOpcoes > 5) {
strRetorno += "<div style='height:100px; overflow:auto; border: 1px solid black'>" + strRetornoAux + "</div>";
} else {
strRetorno += strRetornoAux;
}
}
}
}
// Campo Date
if (gerencialParameterDto.getType().equalsIgnoreCase("java.sql.Date")) {
strValid += ",Date";
strRetorno += "<input type='text' size='" + gerencialParameterDto.getSize() + "' maxlength='" + gerencialParameterDto.getSize() + "' name='PARAM." + gerencialParameterDto.getName()
+ "' id='PARAM." + gerencialParameterDto.getName() + "'";
if (!reload) {
strRetorno += " value='" + gerencialParameterDto.getDefaultValue() + "' ";
}
strRetorno += " class='Format[Date] Description[" + gerencialParameterDto.getDescription() + "] Valid[" + strValid + "] datepicker' ";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onblur='recarrega(this)'";
}
if (reload) {
String value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value != null) {
strRetorno += " value='" + value + "'";
}
}
strRetorno += "/>";
}
// Campo Inteiro - Nao ha casas decimais
if (gerencialParameterDto.getType().equalsIgnoreCase("java.lang.Integer")) {
if (gerencialParameterDto.getTypeHTML() == null || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("") || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("text")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
strRetorno += "<input type='text' size='" + gerencialParameterDto.getSize() + "' maxlength='" + gerencialParameterDto.getSize() + "' name='PARAM." + gerencialParameterDto.getName()
+ "' id='PARAM." + gerencialParameterDto.getName() + "'";
if (!reload) {
strRetorno += " value='" + gerencialParameterDto.getDefaultValue() + "' ";
}
strRetorno += " class='Format[Numero] Description[" + gerencialParameterDto.getDescription() + "]" + strValidCompleta + "'";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onblur='recarrega(this)'";
}
if (reload) {
String value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value != null) {
strRetorno += " value='" + value + "'";
}
}
strRetorno += "/>";
}
}
// Campo Duplo - Com casas decimais
if (gerencialParameterDto.getType().equalsIgnoreCase("java.lang.Double")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
strRetorno += "<input type='text' size='" + gerencialParameterDto.getSize() + "' maxlength='" + gerencialParameterDto.getSize() + "' name='PARAM." + gerencialParameterDto.getName()
+ "' id='PARAM." + gerencialParameterDto.getName() + "'";
if (!reload) {
strRetorno += " value='" + gerencialParameterDto.getDefaultValue() + "' ";
}
strRetorno += " class='Format[Money] Description[" + gerencialParameterDto.getDescription() + "]" + strValidCompleta + "'";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onblur='recarrega(this)'";
}
if (reload) {
String value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value != null) {
strRetorno += " value='" + value + "'";
}
}
strRetorno += "/>";
}
// Campo String
if (gerencialParameterDto.getType().equalsIgnoreCase("java.lang.String")) {
if (gerencialParameterDto.getTypeHTML() == null || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("") || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("text")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
strRetorno += "<input type='text' size='" + gerencialParameterDto.getSize() + "' maxlength='" + gerencialParameterDto.getSize() + "' name='PARAM." + gerencialParameterDto.getName()
+ "' id='PARAM." + gerencialParameterDto.getName() + "'";
if (!reload) {
strRetorno += " value='" + gerencialParameterDto.getDefaultValue() + "' ";
}
strRetorno += " class='Description[" + gerencialParameterDto.getDescription() + "]" + strValidCompleta + "'";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onblur='recarrega(this)'";
}
if (reload) {
String value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
if (value != null) {
strRetorno += " value='" + value + "'";
}
}
strRetorno += "/>";
}
}
// Campo StringBuilder
if (gerencialParameterDto.getType().equalsIgnoreCase("java.lang.StringBuilder")) {
if (gerencialParameterDto.getTypeHTML() == null || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("") || gerencialParameterDto.getTypeHTML().equalsIgnoreCase("text")
|| gerencialParameterDto.getTypeHTML().equalsIgnoreCase("textarea")) {
String strValidCompleta = "";
if (!strValid.trim().equalsIgnoreCase("")) {
strValidCompleta = " Valid[" + strValid + "]";
}
strRetorno += "<textarea rows='" + gerencialParameterDto.getSize() + "' cols='70' name='PARAM." + gerencialParameterDto.getName() + "' id='PARAM." + gerencialParameterDto.getName()
+ "'";
strRetorno += " class='Description[" + gerencialParameterDto.getDescription() + "]" + strValidCompleta + "'";
if (gerencialParameterDto.isReload()) {
// strRetorno += " onblur='recarrega(this)'";
}
String value = "";
if (reload) {
value = (String) hashParametros.get("PARAM." + gerencialParameterDto.getName());
} else {
value = gerencialParameterDto.getDefaultValue();
}
strRetorno += ">";
if (!reload) {
if (value == null) {
value = "";
}
strRetorno += value;
}
strRetorno += "</textarea>";
}
}
return strRetorno;
}
public List getSubTreeParameters(String parametros){
Document doc = null;
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
try {
DocumentBuilder builder = factory.newDocumentBuilder();
if (parametros == null){
return null;
}
InputStream is = new ByteArrayInputStream(parametros.getBytes());
doc = builder.parse(is);
} catch (Exception e) {
e.printStackTrace();
return null;
}
if (doc == null) return null;
Node noItem = doc.getChildNodes().item(0);
if (noItem == null){
return null;
}
List colParameters = new ArrayList();
GerencialParameterDTO gerencialParameter;
if (noItem.getChildNodes() != null){
for (int i = 0; i < noItem.getChildNodes().getLength(); i++){
Node noSubItem = noItem.getChildNodes().item(i);
if(noSubItem.getNodeName().equals("#text")) continue;
if(noSubItem.getNodeName().equals("#comment")) continue;
if (noSubItem.getNodeName().equalsIgnoreCase("PARAM")){
gerencialParameter = new GerencialParameterDTO();
NamedNodeMap map = noSubItem.getAttributes();
gerencialParameter.setType(map.getNamedItem("type").getNodeValue());
if (map.getNamedItem("typeHTML") != null){
gerencialParameter.setTypeHTML(map.getNamedItem("typeHTML").getNodeValue());
}
gerencialParameter.setValue(map.getNamedItem("value").getNodeValue());
gerencialParameter.setName(map.getNamedItem("name").getNodeValue());
gerencialParameter.setDescription(map.getNamedItem("description").getNodeValue());
String size = map.getNamedItem("size").getNodeValue();
if (size == null || size.trim().equalsIgnoreCase("")){
size = "0";
}
gerencialParameter.setSize(new Integer(Integer.parseInt(size)));
String defaultValue = null;
if (map.getNamedItem("default") != null){
defaultValue = map.getNamedItem("default").getNodeValue();
}
if (defaultValue == null){
defaultValue = "";
}
if (defaultValue.equalsIgnoreCase("{TODAY}") || defaultValue.equalsIgnoreCase("{DATAATUAL}")){
defaultValue = UtilDatas.dateToSTR(UtilDatas.getDataAtual());
}
if (defaultValue.equalsIgnoreCase("{MESATUAL}")){
defaultValue = "" + UtilDatas.getMonth(UtilDatas.getDataAtual());
}
if (defaultValue.equalsIgnoreCase("{ANOATUAL}")){
defaultValue = "" + UtilDatas.getYear(UtilDatas.getDataAtual());
}
gerencialParameter.setDefaultValue(defaultValue);
gerencialParameter.setFix(Boolean.valueOf(map.getNamedItem("fix").getNodeValue()).booleanValue());
gerencialParameter.setMandatory(Boolean.valueOf(map.getNamedItem("mandatory").getNodeValue()).booleanValue());
if (map.getNamedItem("reload") != null){
if (map.getNamedItem("reload").getNodeValue() != null && !map.getNamedItem("reload").getNodeValue().equalsIgnoreCase("")){
gerencialParameter.setReload(Boolean.valueOf(map.getNamedItem("reload").getNodeValue()).booleanValue());
}else{
gerencialParameter.setReload(false);
}
}else{
gerencialParameter.setReload(false);
}
if ("select".equalsIgnoreCase(gerencialParameter.getTypeHTML()) ||
"checkbox".equalsIgnoreCase(gerencialParameter.getTypeHTML()) ||
"radio".equalsIgnoreCase(gerencialParameter.getTypeHTML())){
gerencialParameter.setColOptions(getSubTreeOptions(noSubItem));
}
colParameters.add(gerencialParameter);
}
}
}
return colParameters;
}
public Collection getSubTreeOptions(Node noItem){
if (noItem == null) return null;
Collection colRetorno = new ArrayList();
if (noItem.getChildNodes() != null){
for (int i = 0; i < noItem.getChildNodes().getLength(); i++){
Node noSubItem = noItem.getChildNodes().item(i);
if(noSubItem.getNodeName().equals("#text")) continue;
if(noSubItem.getNodeName().equals("#comment")) continue;
if (noSubItem.getNodeName().equalsIgnoreCase("OPTION")){
NamedNodeMap map = noSubItem.getAttributes();
GerencialOptionDTO gerencialOptionDTO = new GerencialOptionDTO();
gerencialOptionDTO.setValue(map.getNamedItem("value").getNodeValue());
gerencialOptionDTO.setText(map.getNamedItem("text").getNodeValue());
colRetorno.add(gerencialOptionDTO);
}
if (noSubItem.getNodeName().equalsIgnoreCase("OPTIONS")){
NamedNodeMap map = noSubItem.getAttributes();
GerencialOptionsDTO gerencialOptionsDTO = new GerencialOptionsDTO();
String onLoad = UtilStrings.nullToVazio(map.getNamedItem("onload").getNodeValue());
if (onLoad.equalsIgnoreCase("true")){
gerencialOptionsDTO.setOnload(true);
}else{
gerencialOptionsDTO.setOnload(false);
}
gerencialOptionsDTO.setType(UtilStrings.nullToVazio(map.getNamedItem("type").getNodeValue()));
if (gerencialOptionsDTO.getType().equalsIgnoreCase("CLASS_GENERATE_SQL") ||
gerencialOptionsDTO.getType().equalsIgnoreCase("SERVICE")){
gerencialOptionsDTO.setClassExecute(UtilStrings.nullToVazio(noSubItem.getChildNodes().item(0).getNodeValue()).trim());
}else{
gerencialOptionsDTO.setType("SQL");
gerencialOptionsDTO.setSql(noSubItem.getChildNodes().item(0).getNodeValue());
}
colRetorno.add(gerencialOptionsDTO);
}
}
}
return colRetorno;
}
public HashMap getParametrosInformados(HttpServletRequest request) {
Enumeration x = request.getParameterNames();
HashMap hashRetorno = new HashMap();
String[] aux;
while (x.hasMoreElements()) {
String nameElement = (String) x.nextElement();
// System.out.println("Parametro vindo no request: " + nameElement + " ---> Valor: " + request.getParameter(nameElement));
if (nameElement.startsWith("PARAM.")) {
String[] strValores = request.getParameterValues(nameElement);
if (strValores.length == 0 || strValores.length == 1) {
String value = request.getParameter(nameElement);
hashRetorno.put(nameElement, value);
} else {
aux = new String[strValores.length];
for (int i = 0; i < strValores.length; i++) {
aux[i] = strValores[i];
}
hashRetorno.put(nameElement, aux);
}
}
}
Usuario user = WebUtilGerencial.getUsuario(request);
hashRetorno.put("USER", user);
return hashRetorno;
}
public static final String encode(String string) {
if (string == null) {
return "";
}
char c;
int length = string.length();
StringBuffer encoded = new StringBuffer(2 * length);
for (int i = 0; i < length; i++) {
c = string.charAt(i);
switch (c) {
case '�':
encoded.append("¹");
break;
case '�':
encoded.append("²");
break;
case '�':
encoded.append("³");
break;
case '�':
encoded.append("º");
break;
case '�':
encoded.append("°");
break;
case '�':
encoded.append("ç");
break;
case '�':
encoded.append("Ç");
break;
case '�':
encoded.append("<sup>a</sup>");
break;
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
encoded.append("&" + getLetraCorrespondente(c) + "acute;");
break;
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
encoded.append("&" + getLetraCorrespondente(c) + "circ;");
break;
case '�':
case '�':
case '�':
case '�':
encoded.append("&" + getLetraCorrespondente(c) + "tilde;");
break;
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
case '�':
encoded.append("&" + getLetraCorrespondente(c) + "grave;");
break;
default:
encoded.append(c);
break;
}
}
String strRet = encoded.toString();
return strRet;
}
public static String getLetraCorrespondente(char c) {
if (c == '�' || c == '�' || c == '�') {
return "a";
}
if (c == '�') {
return "a";
} else if (c == '�' || c == '�' || c == '�') {
return "A";
} else if (c == '�') {
return "A";
} else if (c == '�' || c == '�' || c == '�') {
return "e";
} else if (c == '�' || c == '�' || c == '�') {
return "E";
} else if (c == '�' || c == '�' || c == '�') {
return "i";
} else if (c == '�' || c == '�' || c == '�') {
return "I";
} else if (c == '�' || c == '�' || c == '�' || c == '�') {
return "o";
} else if (c == '�' || c == '�' || c == '�' || c == '�') {
return "O";
} else if (c == '�' || c == '�' || c == '�') {
return "u";
} else if (c == '�' || c == '�' || c == '�') {
return "U";
} else {
char auxChar[] = new char[1];
auxChar[0] = c;
String aux = new String(auxChar);
return aux;
}
}
}