Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2019
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. log.debug("ANALIZZO F.FPPRA E F.ANT2004");
  2. if (isLinea012(macpra)) {
  3. query = "select anno, sum(impant) as impant, sum(ritenuta_imposta) as ritenutaImposta "+
  4. "from ( "+
  5. "select 'fppra' as tab, 2007 AS ANNO, FPPRA_MACPRA as MACPRA, 0 as impant, FPPRA_TASSEP as tassazioneSeparata,FPPRA_IMP_RI_ALL as ritenuta_imposta "+
  6. "from f.fppra f, f.tesas t, f.mapra m "+
  7. "where t.TESAS_CODFIS=? "+
  8. "and f.FPPRA_ASSIC=t.TESAS_ASSIC "+
  9. "and m.MAPRA_MACPRA=f.FPPRA_MACPRA "+
  10. "and m.MAPRA_STATUS not in ('SS') "+
  11. "and m.MAPRA_MACPRA < ? "+
  12. "union "+
  13. "select 'ant2004' as tab, YEAR(dtuscr) AS ANNO, 0 as MACPRA, a.IMPANT, a.TAS_SEP as tassazioneSeparata, a.IMPON_RIT_IMPOSTA as ritenuta_imposta "+
  14. "from f.ant2004 a, f.tesas b "+
  15. "where a.CODANA=b.TESAS_CODANA "+
  16. "and b.TESAS_CODFIS=? "+
  17. ") tab " +
  18. "group by anno";
  19. }
  20. else {
  21. query = "select anno, sum(impant) as impant, sum(ritenuta_imposta) as ritenutaImposta "+
  22. "from ( "+
  23. "select 'fppra' as tab, 2007 AS ANNO, FPPRA_MACPRA as MACPRA, 0 as impant, FPPRA_TASSEP as tassazioneSeparata,FPPRA_IMP_RITIMP as ritenuta_imposta "+
  24. "from f.fppra f, f.tesas t, f.mapra m "+
  25. "where t.TESAS_CODFIS=? "+
  26. "and f.FPPRA_ASSIC=t.TESAS_ASSIC "+
  27. "and m.MAPRA_MACPRA=f.FPPRA_MACPRA "+
  28. "and m.MAPRA_STATUS not in ('SS') "+
  29. "and m.MAPRA_MACPRA < ? "+
  30. "union "+
  31. "select 'ant2004' as tab, YEAR(dtuscr) AS ANNO, 0 as MACPRA, a.IMPANT, a.TAS_SEP as tassazioneSeparata, a.IMPON_RIT_IMPOSTA as ritenuta_imposta "+
  32. "from f.ant2004 a, f.tesas b "+
  33. "where a.CODANA=b.TESAS_CODANA "+
  34. "and b.TESAS_CODFIS=? "+
  35. ") tab " +
  36. "group by anno";
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement