Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- log.debug("ANALIZZO F.FPPRA E F.ANT2004");
- if (isLinea012(macpra)) {
- query = "select anno, sum(impant) as impant, sum(ritenuta_imposta) as ritenutaImposta "+
- "from ( "+
- "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 "+
- "from f.fppra f, f.tesas t, f.mapra m "+
- "where t.TESAS_CODFIS=? "+
- "and f.FPPRA_ASSIC=t.TESAS_ASSIC "+
- "and m.MAPRA_MACPRA=f.FPPRA_MACPRA "+
- "and m.MAPRA_STATUS not in ('SS') "+
- "and m.MAPRA_MACPRA < ? "+
- "union "+
- "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 "+
- "from f.ant2004 a, f.tesas b "+
- "where a.CODANA=b.TESAS_CODANA "+
- "and b.TESAS_CODFIS=? "+
- ") tab " +
- "group by anno";
- }
- else {
- query = "select anno, sum(impant) as impant, sum(ritenuta_imposta) as ritenutaImposta "+
- "from ( "+
- "select 'fppra' as tab, 2007 AS ANNO, FPPRA_MACPRA as MACPRA, 0 as impant, FPPRA_TASSEP as tassazioneSeparata,FPPRA_IMP_RITIMP as ritenuta_imposta "+
- "from f.fppra f, f.tesas t, f.mapra m "+
- "where t.TESAS_CODFIS=? "+
- "and f.FPPRA_ASSIC=t.TESAS_ASSIC "+
- "and m.MAPRA_MACPRA=f.FPPRA_MACPRA "+
- "and m.MAPRA_STATUS not in ('SS') "+
- "and m.MAPRA_MACPRA < ? "+
- "union "+
- "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 "+
- "from f.ant2004 a, f.tesas b "+
- "where a.CODANA=b.TESAS_CODANA "+
- "and b.TESAS_CODFIS=? "+
- ") tab " +
- "group by anno";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement