|
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/DaftarTunggakan/ |
| [ 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="DaftarTunggakan" language="groovy" pageWidth="970" pageHeight="791" columnWidth="934" leftMargin="18" rightMargin="18" topMargin="34" bottomMargin="19" uuid="d2e99efb-6b14-4358-a197-7bb2f906910e">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="letakObjekPajak" uuid="d22b6d09-4203-49aa-af98-de8c070bad0b">
<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"/>
<queryString>
<![CDATA[select (coalesce(ltrim(rtrim(jalan_op)),'') || ' ' ||coalesce(ltrim(rtrim(blok_kav_no_op)),'')) as letak_object_pajak
from dat_objek_pajak
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan}
and kd_kelurahan = $P{kd_kelurahan}
and kd_blok = $P{kd_blok}
and no_urut = $P{no_urut}
and kd_jns_op = $P{kd_jns_op}]]>
</queryString>
<field name="letak_object_pajak" class="java.lang.String"/>
</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="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="pmin" class="java.lang.String"/>
<parameter name="pmax" class="java.lang.String"/>
<parameter name="pawal" class="java.lang.String"/>
<parameter name="DEFA_VALUE" class="java.lang.Integer" isForPrompting="false">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<parameter name="buku" class="java.lang.String"/>
<parameter name="tglBlnThn" class="java.lang.String"/>
<parameter name="pTahun" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT /*+ parallel(sppt,8) */
kd_propinsi,
kd_dati2,
kd_kecamatan,
kd_kelurahan,
kd_blok,
no_urut,
kd_jns_op,
thn_pajak_sppt,
nm_wp_sppt,
coalesce(ltrim(rtrim(jln_wp_sppt)) || ' ' || coalesce(ltrim(rtrim(blok_kav_no_wp_sppt)),''), '-') alm_wp,
(coalesce(rt_wp_sppt,'')||'-'||coalesce(rw_wp_sppt,'')) rt_rw,
to_char(tgl_jatuh_tempo_sppt,'DD/MM/YYYY') as tgl_jatuh_tempo_sppt,
CASE
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) > 24::double precision THEN round(24::numeric * 0.02 * pbb_yg_harus_dibayar_sppt::numeric)::double precision
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) >= 12::double precision THEN round((date_part('month'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1 + 12::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) < 12::double precision THEN round((date_part('month'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
ELSE NULL::double precision
END AS dip,
(pbb_yg_harus_dibayar_sppt+(
CASE
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) > 24::double precision THEN round(24::numeric * 0.02 * pbb_yg_harus_dibayar_sppt::numeric)::double precision
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) >= 12::double precision THEN round((date_part('month'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1 + 12::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
WHEN (date_part('year'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt)) * 12::double precision) < 12::double precision THEN round((date_part('month'::text, age(to_date($P{pawal}, 'DD-MM-YYYY')::timestamp without time zone, tgl_jatuh_tempo_sppt))+ 1::double precision) * 0.02::double precision * pbb_yg_harus_dibayar_sppt::double precision)
ELSE NULL::double precision
END
)
) as bayar,
pbb_yg_harus_dibayar_sppt
FROM pbb.SPPT
WHERE kd_propinsi = $P{kd_propinsi}
AND kd_dati2 = $P{kd_dati2}
AND kd_kecamatan = $P{kd_kecamatan}
AND kd_kelurahan = $P{kd_kelurahan}
AND status_pembayaran_sppt = '0'
AND cast(thn_pajak_sppt as numeric) = cast($P{pTahun} as numeric)
AND cast(pbb_yg_harus_dibayar_sppt as numeric) between cast($P{pmin} as numeric) and cast($P{pmax} as numeric)
ORDER BY kd_blok, no_urut, kd_jns_op, 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="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="thn_pajak_sppt" class="java.lang.String"/>
<field name="nm_wp_sppt" class="java.lang.String"/>
<field name="alm_wp" class="java.lang.String"/>
<field name="rt_rw" class="java.lang.String"/>
<field name="tgl_jatuh_tempo_sppt" class="java.lang.String"/>
<field name="dip" class="java.lang.Double"/>
<field name="bayar" class="java.lang.Double"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.lang.Long"/>
<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
</variable>
<variable name="pbb_yg_harus_dibayar_sppt_1" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></variableExpression>
</variable>
<variable name="pbb_yg_harus_dibayar_sppt_2" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></variableExpression>
</variable>
<variable name="pbb_yg_harus_dibayar_sppt_3" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></variableExpression>
</variable>
<variable name="dip_1" class="java.lang.Double" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{dip}]]></variableExpression>
</variable>
<variable name="dip_2" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{dip}]]></variableExpression>
</variable>
<variable name="bayar_1" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{bayar}]]></variableExpression>
</variable>
<variable name="total1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></variableExpression>
</variable>
<variable name="total2" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{dip}]]></variableExpression>
</variable>
<variable name="total3" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{bayar}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="149"/>
</title>
<pageHeader>
<band height="83" splitType="Stretch">
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="1" y="-87" width="77" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Propinsi :]]></text>
</staticText>
<subreport>
<reportElement uuid="3dc26a6b-7ac2-4f92-a37e-7c531316ddd1" x="78" y="-86" width="200" height="15"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "DaftarTunggakan2.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="e5c2254d-6aeb-4662-b6cc-59d9319e8e5e" x="1" y="33" width="921" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[===============================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="0de84360-884d-4495-9fc6-959f4fe1b1e0" x="382" y="-173" width="206" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN TUNGGAKAN PEMBAYARAN PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="e6e0eb6e-450d-486e-896e-f5e1aeedc23c" x="436" y="-159" width="36" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun]]></text>
</staticText>
<subreport>
<reportElement uuid="8a40e6f1-a097-4c8e-b741-d52332790c5a" x="78" y="-60" width="200" height="14"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "dati2.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="1" y="-61" width="77" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kab / Kota :]]></text>
</staticText>
<subreport>
<reportElement uuid="8521df20-4868-4bf9-9caf-19dfe4ad1482" x="723" y="-85" width="175" height="14"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "kecamatan.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="649" y="-85" width="74" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kecamatan :]]></text>
</staticText>
<subreport>
<reportElement uuid="4a70f0e5-fc60-4a87-b02c-7c2aae586956" x="723" y="-60" width="175" height="14"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$P{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "kelurahan.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="649" y="-61" width="74" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kelurahan :]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="42" y="45" width="56" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[N O P]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="141" y="45" width="173" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA WAJIB PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="328" y="45" width="139" height="26"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ALAMAT WAJIB PAJAK
LETAK OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="477" y="45" width="37" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[RT/RW]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="524" y="45" width="47" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TAHUN]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="578" y="45" width="68" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JATUH TEMPO]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="651" y="45" width="80" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KETETAPAN PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="740" y="45" width="67" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="815" y="45" width="101" height="26"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[KETETAPAN PBB + DENDA]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="1" y="45" width="35" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMOR]]></text>
</staticText>
<textField>
<reportElement uuid="791a0833-c7a8-4893-9d16-4df8963e7284" x="476" y="-144" width="67" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{buku}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="6348f09a-4b9e-40e3-8427-705bf2d4e2b8" x="437" y="-144" width="40" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku :]]></text>
</staticText>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="39" y="41" width="1" height="42"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="0" y="41" width="1" height="32"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="138" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="324" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="474" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="522" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="576" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="649" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="738" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="814" y="41" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="921" y="39" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="497b2293-8da4-43a9-a3e1-c77a66067da9" x="0" y="71" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="0" y="79" width="919" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="0" y="81" width="922" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="d86f8998-b669-463c-ae70-8be6193916a0" x="472" y="-159" width="73" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{pawal}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="678421c0-d3c3-4c4f-a2ea-4eac294a0840" x="814" y="11" width="34" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement uuid="df69814d-9487-472f-b806-9760e722c2b3" x="855" y="11" width="36" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="102cac89-1e01-4398-8c32-02c60f65fd38" x="753" y="11" width="61" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Halaman : ]]></text>
</staticText>
<staticText>
<reportElement uuid="78c9cccc-9e4c-4f91-b113-74d0405fd325" x="838" y="11" width="19" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[/]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="42" splitType="Stretch">
<textField>
<reportElement uuid="6983e8ab-9a71-49f0-b643-d092ef87d306" x="1" y="0" width="38" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6e32a6c9-0a5e-4bcd-8a9c-f0e1a78c164d" x="42" y="0" width="88" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_blok} + "-" + $F{no_urut} + "." + $F{kd_jns_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="92e04359-995c-4658-859a-cb65074789a3" x="141" y="0" width="173" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="8b7d5d30-93f8-4bbd-b92d-5b2ddc440ce4" x="328" y="2" width="139" height="18"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alm_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="12d1338a-9031-448d-ba61-99a990bd3518" x="477" y="0" width="39" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{rt_rw}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="710ddc2e-1668-40aa-b726-e1db3b110687" x="524" y="0" width="47" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="89e41c3f-161c-45a5-ab75-6a9a531d7109" x="578" y="0" width="68" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_jatuh_tempo_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0f7c6799-83f3-4568-bebd-e031e1e0acbf" x="651" y="0" width="80" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c98f2d56-7491-4206-90af-02a348ca2d07" x="740" y="0" width="67" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{dip}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="0" y="-3" width="1" height="45"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="ed55df41-a4d2-4a0f-be2a-88e56b7c5067" x="816" y="0" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="138" y="-3" width="1" height="43"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="324" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="474" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="522" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="576" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="649" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="738" y="-12" width="1" height="52"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="814" y="-3" width="1" height="43"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="bbb12c60-750a-4495-b9b8-a2868c4dfe6f" x="328" y="20" width="145" 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="letakObjekPajak" uuid="145946ed-fe47-447c-9bcf-5961963bc249">
<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>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="19" width="145">
<textField>
<reportElement uuid="29fc45a1-8154-4a0b-ab0e-7136ae9efc7e" x="0" y="0" width="139" height="19"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{letak_object_pajak}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="44c4949c-67d2-47c9-9c89-4b74c9c1fa86" x="40" y="0" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="324" y="0" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="474" y="0" width="1" height="42"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="522" y="0" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="576" y="0" width="1" height="40"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="649" y="0" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="738" y="0" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="920" y="2" width="1" height="39"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</detail>
<columnFooter>
<band height="103" splitType="Stretch">
<textField>
<reportElement uuid="a2f9cb63-304a-4405-9cca-c70d1de3cfb1" x="651" y="14" width="80" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{pbb_yg_harus_dibayar_sppt_3}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f906eac5-e50d-4e19-bf56-7e5a08290c21" x="740" y="14" width="67" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{dip_2}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="842abd13-ea5a-410c-bbd8-25bfce258e7b" stretchType="RelativeToBandHeight" x="816" y="14" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{bayar_1}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="15" y="19" width="134" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TOTAL HALAMAN INI]]></text>
</staticText>
<staticText>
<reportElement uuid="2717eea4-d7e6-4e37-8efd-9191ef406d72" x="12" y="79" width="167" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DI TERBITKAN PADA TANGGAL :]]></text>
</staticText>
<staticText>
<reportElement uuid="202ab33b-d064-4d59-b31d-e1097d86e703" x="15" y="39" width="212" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TOTAL SAMPAI DENGAN HALAMAN INI]]></text>
</staticText>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="0" y="0" width="919" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="0" y="2" width="922" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="7644cacb-e9df-4c47-8669-7410ee91b8f0" x="740" y="41" width="67" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{total2}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7f67e097-fb83-460e-b0b8-4d94b6102c5a" x="651" y="41" width="80" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{total1}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3bca7670-ed67-4055-b849-caaa52daecad" stretchType="RelativeToBandHeight" x="815" y="41" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{total3}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f4f6d785-b631-4354-ad91-f851aae732ad" x="179" y="79" width="190" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{tglBlnThn}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="1" y="66" width="921" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ddf4f0fb-752f-4040-a14e-5ab34b6dfd8b" x="1" y="64" width="907" height="2"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line direction="BottomUp">
<reportElement uuid="27ca0da9-4eb0-4480-b009-2c123def4b0b" x="0" y="2" width="1" height="65"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9fbc8bb5-cc88-426b-971a-605acbafee1c" x="921" y="9" width="1" height="55"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnFooter>
</jasperReport>