|
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/CatatanPembayaran/ |
| [ 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="CetakKurangBayar" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="36" bottomMargin="20" uuid="b03919fb-5d1f-4721-a842-110298acbb5a">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="f0c71562-3fc7-40a3-9302-8bea4b6e2027">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pajak_sppt" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="pbb_harus_bayar" class="java.math.BigDecimal">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT coalesce(jml_sppt_yg_dibayar,0) as jml_sppt_yg_dibayar,
0 AS denda
FROM (
SELECT A.KD_PROPINSI , A.KD_DATI2,
A.KD_KECAMATAN ,
A.KD_KELURAHAN ,
A.KD_BLOK ,
A.NO_URUT ,
A.KD_JNS_OP,
A.THN_PAJAK_SPPT ,A.STATUS_PEMBAYARAN_SPPT,A.TGL_JATUH_TEMPO_SPPT,A.pbb_yg_harus_dibayar_sppt,
(SELECT sum(jml_sppt_yg_dibayar) FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS jml_sppt_yg_dibayar,
(SELECT DENDA_SPPT FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS DENDA_SPPT,
(SELECT POKOK_DENDA_ADM FROM DENDA_ADMINISTRASI B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_DENDA) AS POKOK_DENDA_ADM
FROM SPPT A
WHERE A.KD_PROPINSI = $P{kd_propinsi}
AND A.KD_DATI2 = $P{kd_dati2}
AND A.KD_KECAMATAN = $P{kd_kecamatan}
AND A.KD_KELURAHAN = $P{kd_kelurahan}
AND A.KD_BLOK = $P{kd_blok}
AND A.NO_URUT = $P{no_urut}
AND A.KD_JNS_OP = $P{kd_jns_op}
AND A.THN_PAJAK_SPPT = $P{thn_pajak_sppt}
and status_pembayaran_sppt = '0'
)AS A]]>
</queryString>
<field name="jml_sppt_yg_dibayar" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Integer"/>
<variable name="denda" class="java.lang.Double">
<variableExpression><![CDATA[$F{denda}]]></variableExpression>
</variable>
<variable name="totalDenda" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{denda}]]></variableExpression>
</variable>
<variable name="totalJumlah" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[($P{pbb_harus_bayar}.doubleValue() + $V{denda}.doubleValue()) - $F{jml_sppt_yg_dibayar}.doubleValue()]]></variableExpression>
</variable>
</subDataset>
<subDataset name="dataset2" uuid="ac061234-28ea-41c3-8100-472abb38fb4e">
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="total_terhutang" class="java.lang.Double">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT sum(coalesce(jml_sppt_yg_dibayar,0)) as total_yg_dibayar,
0 AS ttotal_denda
FROM (
SELECT A.KD_PROPINSI , A.KD_DATI2,
A.KD_KECAMATAN ,
A.KD_KELURAHAN ,
A.KD_BLOK ,
A.NO_URUT ,
A.KD_JNS_OP,
A.THN_PAJAK_SPPT ,A.STATUS_PEMBAYARAN_SPPT,A.TGL_JATUH_TEMPO_SPPT,A.pbb_yg_harus_dibayar_sppt,
(SELECT sum(jml_sppt_yg_dibayar) FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS jml_sppt_yg_dibayar,
(SELECT DENDA_SPPT FROM PEMBAYARAN_SPPT B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_PAJAK_SPPT ) AS DENDA_SPPT,
(SELECT POKOK_DENDA_ADM FROM DENDA_ADMINISTRASI B
WHERE A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK = B.KD_BLOK
AND A.NO_URUT = B.NO_URUT
AND A.KD_JNS_OP = B.KD_JNS_OP
AND A.THN_PAJAK_SPPT = B.THN_DENDA) AS POKOK_DENDA_ADM
FROM SPPT A
WHERE A.KD_PROPINSI = $P{kd_propinsi}
AND A.KD_DATI2 = $P{kd_dati2}
AND A.KD_KECAMATAN = $P{kd_kecamatan}
AND A.KD_KELURAHAN = $P{kd_kelurahan}
AND A.KD_BLOK = $P{kd_blok}
AND A.NO_URUT = $P{no_urut}
AND A.KD_JNS_OP = $P{kd_jns_op}
AND status_pembayaran_sppt = '0'
)AS A]]>
</queryString>
<field name="total_yg_dibayar" class="java.math.BigDecimal"/>
<field name="ttotal_denda" class="java.lang.Integer"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<parameter name="DEFA_VALUE" class="java.lang.Integer" isForPrompting="false">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA["C:\\xampp\\htdocs\\bhumie\\report\\CatatanPembayaran\\"]]></defaultValueExpression>
</parameter>
<parameter name="date" class="java.lang.String"/>
<queryString>
<![CDATA[Select c.kd_propinsi,c.kd_dati2,c.kd_kecamatan,c.kd_kelurahan,k.nm_kelurahan,c.kd_blok,c.no_urut,c.kd_jns_op, c.kd_propinsi||'.'||c.kd_dati2||'.'||c.kd_kecamatan||'.'||
c.kd_kelurahan||'.'||c.kd_blok||'.'||c.no_urut||'.'||c.kd_jns_op NOP,
coalesce(a.jalan_op,'')||' '||coalesce(a.blok_kav_no_op,'')||' RW.'||coalesce(a.rw_op,'')||' /RT.'||coalesce(a.rt_op,'') alamat_op, a.subjek_pajak_id,
c.pbb_yg_harus_dibayar_sppt pbbterhutangsppt,
c.tgl_jatuh_tempo_sppt jatuhtempo,
c.thn_pajak_sppt tahunsppt,c.kelurahan_wp_sppt, c.kota_wp_sppt, f.nm_dati2, g.NM_WP, coalesce(g.JALAN_WP,'')||' '||coalesce(g.BLOK_KAV_NO_WP,'')||' RW.'||coalesce(g.RW_WP,'')||'/RT.'||coalesce(g.RT_WP,'') as alamat_wp,
sum(coalesce(d.jml_sppt_yg_dibayar,0) - coalesce(d.denda_sppt,0)) spptdibayar
from pbb.dat_objek_pajak a,
pbb.sppt c left join pbb.pembayaran_sppt d on
c.kd_propinsi = d.kd_propinsi and
c.kd_dati2 = d.kd_dati2 and
c.kd_kecamatan = d.kd_kecamatan and
c.kd_kelurahan = d.kd_kelurahan and
c.kd_blok = d.kd_blok and
c.no_urut = d.no_urut and
c.kd_jns_op = d.kd_jns_op and
c.thn_pajak_sppt = d.thn_pajak_sppt left join pbb.ref_kelurahan k on
c.kd_propinsi = k.kd_propinsi and
c.kd_dati2 = k.kd_dati2 and
c.kd_kecamatan = k.kd_kecamatan and
c.kd_kelurahan = k.kd_kelurahan,
pbb.ref_dati2 f,
pbb.dat_subjek_pajak g
Where a.kd_propinsi = c.kd_propinsi and
a.kd_dati2 = c.kd_dati2 and
a.kd_kecamatan = c.kd_kecamatan and
a.kd_kelurahan = c.kd_kelurahan and
a.kd_blok = c.kd_blok and
a.no_urut = c.no_urut and
a.kd_jns_op = c.kd_jns_op and
a.kd_Propinsi = f.kd_propinsi and
a.kd_dati2 = f.kd_dati2 and
c.status_pembayaran_sppt = '0' and
a.subjek_pajak_id = g.subjek_pajak_id and
c.pbb_yg_harus_dibayar_sppt <> 0 and
c.pbb_yg_harus_dibayar_sppt - (coalesce(d.jml_sppt_yg_dibayar,0) - coalesce(d.denda_sppt,0)) > 0 and
a.kd_propinsi = $P{kd_propinsi} and
a.kd_dati2 = $P{kd_dati2} and
a.kd_kecamatan = $P{kd_kecamatan} and
a.kd_kelurahan = $P{kd_kelurahan} and
a.kd_blok = $P{kd_blok} and
a.no_urut = $P{no_urut} and
a.kd_jns_op = $P{kd_jns_op}
group by c.kd_propinsi,c.kd_dati2,c.kd_kecamatan,c.kd_kelurahan,k.nm_kelurahan,c.kd_blok,c.no_urut,c.kd_jns_op, c.kd_propinsi||'.'||c.kd_dati2||'.'||c.kd_kecamatan||'.'||
c.kd_kelurahan||'.'||c.kd_blok||'.'||c.no_urut||'.'||c.kd_jns_op,
coalesce(a.jalan_op,'')||' '||coalesce(a.blok_kav_no_op,'')||' RW.'||coalesce(a.rw_op,'')||' /RT.'||coalesce(a.rt_op,''),
a.subjek_pajak_id,
c.pbb_yg_harus_dibayar_sppt,
c.tgl_jatuh_tempo_sppt,
c.thn_pajak_sppt, c.kelurahan_wp_sppt, c.kota_wp_sppt, f.nm_dati2,g.NM_WP,
coalesce(g.JALAN_WP,'')||' '||coalesce(g.BLOK_KAV_NO_WP,'')||' RW.'||coalesce(g.RW_WP,'')||'/RT.'||coalesce(g.RT_WP,'')
order by nop,c.thn_pajak_sppt]]>
</queryString>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="kd_blok" class="java.lang.String"/>
<field name="no_urut" class="java.lang.String"/>
<field name="kd_jns_op" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="alamat_op" class="java.lang.String"/>
<field name="subjek_pajak_id" class="java.lang.String"/>
<field name="pbbterhutangsppt" class="java.lang.Long"/>
<field name="jatuhtempo" class="java.sql.Timestamp"/>
<field name="tahunsppt" class="java.lang.String"/>
<field name="kelurahan_wp_sppt" class="java.lang.String"/>
<field name="kota_wp_sppt" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="alamat_wp" class="java.lang.String"/>
<field name="spptdibayar" class="java.math.BigDecimal"/>
<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
</variable>
<variable name="trbt" class="java.util.Date" resetType="None">
<variableExpression><![CDATA[new Date()]]></variableExpression>
<initialValueExpression><![CDATA[]]></initialValueExpression>
</variable>
<variable name="d1" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format(new Date()))]]></variableExpression>
</variable>
<variable name="m1" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format(new Date()))]]></variableExpression>
</variable>
<variable name="y1" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format(new Date()))]]></variableExpression>
</variable>
<variable name="d2" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format($F{jatuhtempo}))]]></variableExpression>
</variable>
<variable name="m2" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format($F{jatuhtempo}))]]></variableExpression>
</variable>
<variable name="y2" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format($F{jatuhtempo}))]]></variableExpression>
</variable>
<variable name="d3" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{d1}-$V{d2}]]></variableExpression>
</variable>
<variable name="m3" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{m1}+($V{y1}*12)]]></variableExpression>
</variable>
<variable name="y3" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{m2}+($V{y2}*12)]]></variableExpression>
</variable>
<variable name="d4" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{d3}<1?
0
:1]]></variableExpression>
</variable>
<variable name="m4" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{m3}-$V{y3}]]></variableExpression>
</variable>
<variable name="y4" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[$V{m4}+$V{d4}]]></variableExpression>
</variable>
<variable name="v_terhutang" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{pbbterhutangsppt}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="170" splitType="Stretch">
<staticText>
<reportElement uuid="3b2fa4d8-f2df-482d-ab58-c9fb993b158c" x="4" y="2" width="141" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[RINCIAN KEKURANGAN PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="d2b8c624-f51f-4b71-85b7-18f2d1060579" x="4" y="14" width="549" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[==========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="6101403b-6230-4e69-b42a-1c57f3ec3984" x="4" y="36" width="57" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tanggal]]></text>
</staticText>
<staticText>
<reportElement uuid="6101403b-6230-4e69-b42a-1c57f3ec3984" x="4" y="47" width="57" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama WP]]></text>
</staticText>
<textField>
<reportElement uuid="0f03d243-2db1-46a2-9ff4-4cb0535e4862" x="64" y="47" width="176" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[": " +$F{nm_wp}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="6101403b-6230-4e69-b42a-1c57f3ec3984" x="4" y="58" width="57" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat WP]]></text>
</staticText>
<textField>
<reportElement uuid="ee35e0c1-493c-45b0-9b59-894e0e62a106" x="71" y="69" width="281" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kelurahan_wp_sppt}+" "+$F{kota_wp_sppt}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="6101403b-6230-4e69-b42a-1c57f3ec3984" x="4" y="83" width="57" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<textField>
<reportElement uuid="87f21b44-0ed2-43ee-ab80-14bd6345e79b" x="64" y="82" width="281" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[": " +$F{nop}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="6101403b-6230-4e69-b42a-1c57f3ec3984" x="4" y="94" width="57" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat OP]]></text>
</staticText>
<staticText>
<reportElement uuid="d2b8c624-f51f-4b71-85b7-18f2d1060579" x="4" y="130" width="549" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[==========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="d2b8c624-f51f-4b71-85b7-18f2d1060579" x="4" y="158" width="549" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[==========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="101" y="138" width="88" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB Terhutang]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="4" y="138" width="25" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[No]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="33" y="138" width="51" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="122" y="149" width="33" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[(RP.)]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="212" y="138" width="46" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tanggal]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="201" y="149" width="97" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jatuh Tempo]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="304" y="138" width="113" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Denda Administrasi]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="310" y="149" width="113" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[1 % Sebulan (RP.)]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="442" y="138" width="68" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah s.d.]]></text>
</staticText>
<staticText>
<reportElement uuid="42ccca5d-93bd-420c-8df0-3a883f410146" x="436" y="149" width="113" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Hari Ini (Rp.)]]></text>
</staticText>
<textField>
<reportElement uuid="12611839-9dd0-4ea7-a84c-994a8cee556a" x="64" y="58" width="281" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[": " +$F{alamat_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="087db8b6-a694-470b-9c13-71ab33bc0eab" x="64" y="94" width="281" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[": " +$F{alamat_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e4961d9f-3b53-4544-937c-b2a7ccebded2" x="71" y="105" width="281" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}+" "+$F{kota_wp_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0f03d243-2db1-46a2-9ff4-4cb0535e4862" x="64" y="35" width="176" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[": " +$P{date}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<detail>
<band height="25" splitType="Stretch">
<textField isBlankWhenNull="true">
<reportElement uuid="ef6eff36-556f-4ea9-ab36-82d16af80527" x="33" y="0" width="51" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tahunsppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0731f44c-0cf5-46a8-96bb-f884de118f12" x="95" y="0" width="86" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{pbbterhutangsppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="d3577595-dd05-443b-b815-cc5031ab99fa" x="201" y="0" width="97" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new BigDecimal(new SimpleDateFormat("dd").format($F{jatuhtempo}))+"/"+new BigDecimal(new SimpleDateFormat("MM").format($F{jatuhtempo}))+"/"+new BigDecimal(new SimpleDateFormat("yyyy").format($F{jatuhtempo}))]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="27118f89-ff08-449f-a256-878e5152ec30" x="4" y="0" width="25" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="7b1081fc-ed38-4f7e-95e1-56c37269e83b" x="304" y="0" width="245" height="25"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset1" uuid="105a4625-83ea-435c-97f0-369d78ed3a27">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pajak_sppt">
<datasetParameterExpression><![CDATA[$F{tahunsppt}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="pbb_harus_bayar">
<datasetParameterExpression><![CDATA[$F{pbbterhutangsppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="25" width="245">
<textField>
<reportElement uuid="d92c9cee-696f-40ed-a17d-f449bf3854b5" x="0" y="0" width="113" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{denda}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6b693adb-a641-4e28-94cc-3fc56d3070d7" x="132" y="0" width="103" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format(($P{pbb_harus_bayar}.doubleValue() + $V{denda}.doubleValue()) - $F{jml_sppt_yg_dibayar}.doubleValue())]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</detail>
<summary>
<band height="33">
<staticText>
<reportElement uuid="c57ed1e9-5115-49df-8586-9cb1db7b8d04" x="4" y="11" width="91" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TOTAL]]></text>
</staticText>
<textField>
<reportElement uuid="9405079c-2c8d-417f-a100-f3616fd45596" x="95" y="11" width="106" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{v_terhutang}.doubleValue())]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="3f0c6186-19eb-4417-ad0c-544ffba5937d" x="2" y="0" width="547" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[===========================================================================================]]></text>
</staticText>
<componentElement>
<reportElement uuid="0f82d1b3-6c15-424c-a958-da90d3fae6d2" x="298" y="12" width="251" height="19"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset2" uuid="d3187b7c-0909-4c4f-9a2d-4cd8bd441587">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$P{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$P{kd_blok}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$P{no_urut}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$P{kd_jns_op}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="total_terhutang">
<datasetParameterExpression><![CDATA[$V{v_terhutang}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="19" width="251">
<textField>
<reportElement uuid="6b693adb-a641-4e28-94cc-3fc56d3070d7" x="6" y="0" width="113" height="19"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{ttotal_denda}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6b693adb-a641-4e28-94cc-3fc56d3070d7" x="138" y="0" width="103" height="19"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($P{total_terhutang}.doubleValue() + $F{ttotal_denda}.doubleValue())]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</summary>
</jasperReport>