Skip to content

Instantly share code, notes, and snippets.

@ffdesousa
Last active June 5, 2020 03:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ffdesousa/e450beba6887381d1f81d7a0b4932e81 to your computer and use it in GitHub Desktop.
Save ffdesousa/e450beba6887381d1f81d7a0b4932e81 to your computer and use it in GitHub Desktop.
function createDataset(fields, constraints, sortFields) {
var NOME_SERVICO = "wsFormulaVisual";
var CAMINHO_SERVICO = "com.totvs.WsFormulaVisual";
try {
var servico = ServiceManager.getServiceInstance(NOME_SERVICO);
var serviceHelper = servico.getBean();
var instancia = servico.instantiate(CAMINHO_SERVICO);
var ws = instancia.getRMIwsFormulaVisual();
var authService = serviceHelper.getBasicAuthenticatedClient(ws, "com.totvs.IwsFormulaVisual", 'Usuario', 'Senha');
var contexto = 'CODCOILIGADA=1;CODFILIAL=1;CODUSUARIO=Usuario;CODSISTEMA=F';
var xml = '<Parameters><Parametros><CodColigada>1</CodColigada><DataVencimento>2020-06-03</DataVencimento><Lancamentos>484779</Lancamentos><IsentaJurosMulta>false</IsentaJurosMulta></Parametros></Parameters>';
var result = authService.execute(0, 300, contexto, '', xml, '');
var dataset = DatasetBuilder.newDataset();
var xmlResultados = new XML(result);
dataset.addColumn('XML');
var registro = new Array();
registro.push(xmlResultados);
dataset.addRow( registro );
log.info(dataset);
return dataset;
} catch (e) {
if (e == null) e = "Erro desconhecido; verifique o log do AppServer";
var mensagemErro = "Erro na comunicacao com o Progress OpenEdge: " + e;
log.error(mensagemErro);
dataset.addColumn("ERROR");
dataset.addRow(new Array(mensagemErro));
return dataset;
}
}
function parseContext(constraints) {
var context = "";
if ((constraints != null) && (constraints.length > 0) && (constraints[0].getFieldName() == "RMSContext")) {
context = constraints[0].getInitialValue();
}
r
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment