|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bhumie/upload/../report/LaporanPembayaran/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="detil_perBankS" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="58de4f1d-3a73-476c-a22a-42e0a73c6604">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Pkd_kantor" class="java.lang.String"/>
<parameter name="Pkd_tp" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[select
a.jml_sppt1
,a.jml_pbb1
,b.jml_sppt2
,b.jml_pbb2
,c.jml_sppt3
,c.jml_pbb3
,d.jml_sppt4
,d.jml_pbb4
,e.jml_sppt5
,e.jml_pbb5
,f.jml_sppt6
,f.jml_pbb6
,g.jml_sppt7
,g.jml_pbb7
,b.jml_sppt2 + c.jml_sppt3 + d.jml_sppt4 + e.jml_sppt5 + f.jml_sppt6 as jml_sppt
,b.jml_pbb2 + c.jml_pbb3 + d.jml_pbb4 + e.jml_pbb5 + f.jml_pbb6 as jml_pbb
,a.jml_sppt1 + g.jml_sppt7 as jml_tunggakan_sppt
,a.jml_pbb1 + g.jml_pbb7 as jml_tunggakan_pbb
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb1,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now())
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
) a inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb2,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_propinsi}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 1
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)b on a.id = b.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb3,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_propinsi}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 2
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)c on a.id = c.id inner join (
Select coalesce(COUNT(*),0) jml_sppt4, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb4,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_propinsi}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 3
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)d on a.id = d.id inner join (
Select coalesce(COUNT(*),0) jml_sppt5, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb5,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_propinsi}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 4
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)e on a.id = e.id inner join (
Select coalesce(COUNT(*),0) jml_sppt6, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb6,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_propinsi}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') = date_part('year',now()) - 5
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)f on a.id = f.id inner join (
Select coalesce(COUNT(*),0) jml_sppt7, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) jml_pbb7,1 id from pbb.pembayaran_sppt
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and to_number(thn_pajak_sppt,'9999') <= date_part('year',now()) - 6
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
and tgl_pembayaran_sppt between date ($P{Ptgl_awal}) and date ($P{Ptgl_akhir})
)g on a.id = g.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<field name="jml_sppt4" class="java.lang.Long"/>
<field name="jml_pbb4" class="java.math.BigDecimal"/>
<field name="jml_sppt5" class="java.lang.Long"/>
<field name="jml_pbb5" class="java.math.BigDecimal"/>
<field name="jml_sppt6" class="java.lang.Long"/>
<field name="jml_pbb6" class="java.math.BigDecimal"/>
<field name="jml_sppt7" class="java.lang.Long"/>
<field name="jml_pbb7" class="java.math.BigDecimal"/>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
<field name="jml_tunggakan_sppt" class="java.lang.Long"/>
<field name="jml_tunggakan_pbb" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="048bc2b5-1092-49dd-8fd1-d74c59f77dd3" x="6" y="0" width="34" height="19"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="93d688d1-c457-478d-b914-ed1059512bf7" x="48" y="-1" width="33" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fd5f2a87-c3d9-455f-b24c-3ab5ff0f7ace" x="89" y="0" width="32" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8edf4c88-18a1-4b86-885a-4e0d9f636278" x="129" y="0" width="29" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="dd0a55c8-5f23-42e3-8e47-0fab102dd498" x="166" y="0" width="27" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt3}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f0d0ccfe-2924-485f-ba2c-c9cab9d55fae" x="201" y="-1" width="32" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb3}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9f9cbc74-b181-47ed-9655-de9a292ebd03" x="245" y="0" width="32" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt4}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="714b3d3f-532c-47de-9fcf-13a6adfa3346" x="285" y="0" width="32" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb4}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="24fe24ab-ea1e-4081-a045-a914d9f8a85f" x="324" y="0" width="34" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt5}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a83142cf-0c7a-4ef8-952d-3f576c83e422" x="368" y="0" width="36" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb5}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1a27ec43-cccc-44f8-a8f9-579a5d8149b3" x="412" y="0" width="31" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt6}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="570d1ce7-fd68-409c-aaf2-6d1fb8354dc2" x="451" y="0" width="31" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb6}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5659ac46-5d0f-4d1e-972b-0741412d212b" x="490" y="0" width="41" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt7}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="658b2bae-9d72-4492-9505-990fe333223c" x="593" y="0" width="41" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9bd1b9e9-34fb-4142-8758-94a6ab4cdf57" x="642" y="-1" width="40" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1b0fe04b-ee37-4899-a138-548de33dc245" x="690" y="0" width="32" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_tunggakan_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f0c729bf-6a88-435e-8036-d24ca87923a6" x="730" y="0" width="34" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_tunggakan_pbb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4a788d89-4343-41ac-b5d3-d91dde132890" x="539" y="0" width="46" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jml_pbb7}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="125" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="85" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="43" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="161" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="196" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="281" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="238" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="320" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="362" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="408" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="447" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="485" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="535" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="589" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="637" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="685" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="725" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="5a7b7edc-8125-45d8-83fe-426e8751d621" x="767" y="1" width="1" height="15"/>
</line>
</band>
</detail>
</jasperReport>