public void imprimiTexto(ResultSet rs, TYPE_PRINT bVisualizar, String sCab) {
BigDecimal bTotal = new BigDecimal("0");
BigDecimal bSaldo = new BigDecimal("0");
BigDecimal bSaldoLinha = new BigDecimal("0");
BigDecimal bVlrDeb = new BigDecimal("0");
BigDecimal bVlrCred = new BigDecimal("0");
BigDecimal bVlrTotDeb = new BigDecimal("0");
BigDecimal bVlrTotCred = new BigDecimal("0");
BigDecimal bAnt = buscaSaldoAnt();
ImprimeOS imp = new ImprimeOS("", con);
String linhafina = StringFunctions.replicate("-", 133);
String sDataLanca = "";
String sConta = "";
String sCodConta = txtCodConta.getVlrString();
boolean bPrim = true;
int linPag = imp.verifLinPag() - 1;
try {
imp.limpaPags();
imp.setTitulo("Extrato Bancário");
imp.addSubTitulo("EXTRATO BANCÁRIO");
sConta = "CONTA: " + sCodConta + " - " + txtDescConta.getVlrString();
imp.addSubTitulo(sConta);
while (rs.next()) {
if (!bPrim) {
if (!(sDataLanca.equals(rs.getString("DataSL")))) {
bTotal = new BigDecimal(rs.getString("SaldoSL"));
}
} else {
bTotal = new BigDecimal(rs.getString("SaldoSL"));
}
if (imp.pRow() == linPag) {
imp.eject();
imp.incPags();
}
if (imp.pRow() == 0) {
imp.montaCab();
imp.impCab(136, true);
imp.say(0, imp.comprimido());
imp.say(0, "|" + linhafina + "|");
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "| Data");
imp.say(14, "| Historico");
imp.say(69, "| Doc");
imp.say(82, "| Débito");
imp.say(100, "| Crédito");
imp.say(118, "| Saldo");
imp.say(135, "|");
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "|" + linhafina + "|");
if (bPrim) {
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "|");
imp.say(
103,
"Saldo Anterior: "
+ Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bAnt.toString()));
imp.say(135, "|");
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "|" + linhafina + "|");
bSaldoLinha = new BigDecimal(bAnt.toString());
}
}
bPrim = false;
bSaldo = new BigDecimal(rs.getBigDecimal("SaldoSL").toString());
bAnt = bSaldo;
sDataLanca = rs.getString("DataSL");
bSaldoLinha = bSaldoLinha.add(rs.getBigDecimal("VlrSubLanca"));
if (rs.getFloat("VlrSubLanca") < 0) {
bVlrDeb = new BigDecimal(rs.getBigDecimal("VlrSubLanca").toString()).abs();
bVlrCred = new BigDecimal("0.00");
bVlrTotDeb = bVlrTotDeb.add(new BigDecimal(bVlrDeb.toString()));
} else {
bVlrCred = new BigDecimal(rs.getBigDecimal("VlrSubLanca").toString());
bVlrDeb = new BigDecimal("0.00");
bVlrTotCred = bVlrTotCred.add(new BigDecimal(bVlrCred.toString()));
}
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "| " + StringFunctions.sqlDateToStrDate(rs.getDate("DataSL")));
imp.say(14, "| " + Funcoes.copy(rs.getString("HistBLanca"), 0, 50));
imp.say(69, "| " + Funcoes.alinhaDir(rs.getString("DocLanca"), 10));
imp.say(82, "|");
if (bVlrDeb.floatValue() != 0) {
imp.say(
imp.pRow() + 0,
84,
Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrDeb.toString()));
}
imp.say(100, "|");
if (bVlrCred.floatValue() != 0) {
imp.say(
0,
102,
Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrCred.toString()));
}
imp.say(
118,
"|"
+ Funcoes.strDecimalToStrCurrency(
15, Aplicativo.casasDecFin, bSaldoLinha.toString()));
imp.say(135, "|");
}
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "|" + linhafina + "|");
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "|");
imp.say(82, "|");
imp.say(
84, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrTotDeb.toString()));
imp.say(100, "|");
imp.say(
102, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrTotCred.toString()));
imp.say(118, "|");
imp.say(119, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bTotal.toString()));
imp.say(135, "|");
imp.pulaLinha(1, imp.comprimido());
imp.say(0, "+" + linhafina + "+");
imp.eject();
imp.fechaGravacao();
rs.close();
con.commit();
} catch (Exception e) {
e.printStackTrace();
}
if (bVisualizar == TYPE_PRINT.VIEW) {
imp.preview(this);
} else {
imp.print();
}
}
public void imprimir(TYPE_PRINT bVisualizar) {
if (txtDatafim.getVlrDate().before(txtDataini.getVlrDate())) {
Funcoes.mensagemInforma(this, "Data final maior que a data inicial!");
return;
}
ImprimeOS imp = new ImprimeOS("", con);
int linPag = imp.verifLinPag() - 1;
int numcheque = 0;
boolean pass = false;
String sPag = "";
String sDataini = "";
String sDatafim = "";
sDataini = txtDataini.getVlrString();
sDatafim = txtDatafim.getVlrString();
ResultSet rs = getResultSet();
try {
imp.limpaPags();
while (rs.next()) {
if (numcheque != rs.getInt("NCHEQUE")) {
pass = true;
numcheque = rs.getInt("NCHEQUE");
} else pass = false;
if (imp.pRow() >= (linPag - 1)) {
imp.say(imp.pRow() + 1, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 0, "|" + StringFunctions.replicate("-", 89) + "|");
imp.incPags();
imp.eject();
}
if (imp.pRow() == 0) {
imp.montaCab();
imp.setTitulo("Relatório de saida x retorno" + sPag);
imp.addSubTitulo(
"RELATÓRIO DE SAIDA X RETORNO "
+ sPag
+ " - PERIODO DE :"
+ sDataini
+ " ATE: "
+ sDatafim);
imp.impCab(91, true);
imp.say(imp.pRow() + 0, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 0, "|" + StringFunctions.replicate("-", 88) + "|");
}
if (pass == true) {
imp.say(imp.pRow() + 1, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 0, StringFunctions.replicate("=", 90));
imp.say(imp.pRow() + 1, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 0, " Cliente:");
imp.say(imp.pRow() + 0, 2, rs.getString("NOMECLI"));
imp.say(imp.pRow() + 1, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 2, "Num.Cheque:");
imp.say(imp.pRow() + 0, 2, rs.getString("NCHEQUE"));
imp.say(imp.pRow() + 0, 3, "Valor:");
imp.say(imp.pRow() + 0, 2, rs.getString("VALOR"));
imp.say(imp.pRow() + 0, 3, "Banco:");
imp.say(imp.pRow() + 0, 2, rs.getString("banco"));
imp.say(imp.pRow() + 2, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 2, "Data/Saída");
imp.say(imp.pRow() + 0, 3, "Descrição");
imp.say(imp.pRow() + 0, 42, "Data/Retorno");
imp.say(imp.pRow() + 0, 5, "Cód.Retorno");
imp.say(imp.pRow() + 1, 0, "" + imp.comprimido());
imp.say(imp.pRow() + 0, 0, StringFunctions.replicate("-", 90));
}
imp.say(imp.pRow() + 1, 0, "" + imp.normal());
imp.say(imp.pRow() + 0, 2, Funcoes.dateToStrDate(rs.getDate("Dates")));
imp.say(imp.pRow() + 0, 3, rs.getString("DESCRICAO"));
imp.say(imp.pRow() + 0, 5, Funcoes.dateToStrDate(rs.getDate("Dater")));
imp.say(imp.pRow() + 0, 11, rs.getString("Codigor"));
if (imp.pRow() >= linPag) {
imp.incPags();
imp.eject();
}
}
imp.say(imp.pRow() + 1, 0, "" + imp.normal());
imp.say(imp.pRow() + 0, 0, StringFunctions.replicate("=", 90));
imp.eject();
imp.fechaGravacao();
con.commit();
} catch (SQLException err) {
Funcoes.mensagemErro(this, "Erro consulta tabela de Cheques!" + err.getMessage());
}
if (bVisualizar == TYPE_PRINT.VIEW) {
imp.preview(this);
} else {
imp.print();
}
}