|
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/report/SalinanMasal_old/SPPT/ |
| [ 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="CetakMasalSppt" language="groovy" pageWidth="493" pageHeight="541" columnWidth="479" leftMargin="5" rightMargin="9" topMargin="11" bottomMargin="11" whenResourceMissingType="Empty" uuid="f8e7e214-379e-44b9-a6a2-677ab75690c0">
<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_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="p_awal" class="java.lang.String"/>
<parameter name="p_akhir" class="java.lang.String"/>
<parameter name="buku" class="java.lang.String"/>
<parameter name="p_awal2" class="java.lang.Double" isForPrompting="false">
<defaultValueExpression><![CDATA[Double.parseDouble($P{p_awal})]]></defaultValueExpression>
</parameter>
<parameter name="p_akhir2" class="java.lang.Double" isForPrompting="false">
<parameterDescription><![CDATA[]]></parameterDescription>
<defaultValueExpression><![CDATA[Double.parseDouble($P{p_akhir})]]></defaultValueExpression>
</parameter>
<parameter name="tgl_terbit" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT A.NM_WP_SPPT, A.JLN_WP_SPPT, A.BLOK_KAV_NO_WP_SPPT, A.KELURAHAN_WP_SPPT, A.KOTA_WP_SPPT, coalesce(A.NPWP_SPPT,SUBSTR(A.NPWP_SPPT,1,2)||'.'||SUBSTR(A.NPWP_SPPT,3,3)||'.'||SUBSTR(A.NPWP_SPPT,6,3)||'.'||SUBSTR(A.NPWP_SPPT,9,1)||'-'||SUBSTR(A.NPWP_SPPT,10,3)||'.'||'000','BELUM ADA') AS NPWP_SPPT,
'RT:'||coalesce(A.RT_WP_SPPT,'--')||' RW:'||coalesce(A.RW_WP_SPPT,'--') AS RTRW_WP, A.NO_PERSIL_SPPT, A.SIKLUS_SPPT,
A.KD_KLS_TANAH, A.THN_AWAL_KLS_TANAH, A.KD_PROPINSI, A.KD_DATI2, A.KD_KECAMATAN, A.KD_KELURAHAN,
A.KD_BLOK, A.NO_URUT, A.KD_JNS_OP, A.KD_KLS_BNG, A.THN_AWAL_KLS_BNG, A.TGL_JATUH_TEMPO_SPPT,
A.LUAS_BUMI_SPPT, A.LUAS_BNG_SPPT, A.NJOP_BUMI_SPPT,
A.NJOP_BNG_SPPT, A.NJOP_SPPT, A.NJOPTKP_SPPT, A.PBB_TERHUTANG_SPPT, A.FAKTOR_PENGURANG_SPPT, A.PBB_YG_HARUS_DIBAYAR_SPPT,
A.TGL_TERBIT_SPPT, A.KD_PROPINSI||'.'||A.KD_DATI2||'.'|| A.KD_KECAMATAN||'.'||A.KD_KELURAHAN||'.'||
A.KD_BLOK||'-'||A.NO_URUT||'.'||A.KD_JNS_OP AS NOP, A.THN_PAJAK_SPPT, A.KD_KANWIL, A.KD_KANTOR, A.KD_TP,
B.NM_DATI2, C.NM_KECAMATAN, D.NM_KELURAHAN, D.KD_SEKTOR, E.JALAN_OP, E.BLOK_KAV_NO_OP,
'RT:'||coalesce(E.RT_OP,'--')||' RW:'||coalesce(E.RW_OP,'--') AS RTRW_OP,E.NO_PERSIL, H.NM_TP,
H.ALAMAT_TP, I.NM_KANWIL, J.NM_KANTOR, J.KOTA_TERBIT, K.NM_SEKTOR,
L.KD_KLS_TANAH AS KD_KLS_TANAH_BER, L.THN_AWAL_KLS_TANAH AS THN_AWAL_KLS_TANAH_BER,
L.KD_KLS_BNG AS KD_KLS_BNG_BER, L.THN_AWAL_KLS_BNG AS THN_AWAL_KLS_BNG_BER,
L.LUAS_BUMI_BEBAN_SPPT, L.LUAS_BNG_BEBAN_SPPT, L.NJOP_BUMI_BEBAN_SPPT,
L.NJOP_BNG_BEBAN_SPPT
FROM pbb.SPPT A LEFT JOIN pbb.SPPT_OP_BERSAMA L on
A.KD_PROPINSI = L.KD_PROPINSI AND
A.KD_DATI2 = L.KD_DATI2 AND
A.KD_KECAMATAN = L.KD_KECAMATAN AND
A.KD_KELURAHAN = L.KD_KELURAHAN AND
A.KD_BLOK = L.KD_BLOK AND
A.NO_URUT = L.NO_URUT AND
A.KD_JNS_OP = L.KD_JNS_OP AND
A.THN_PAJAK_SPPT = L.THN_PAJAK_SPPT,
pbb.REF_DATI2 B, pbb.REF_KECAMATAN C, pbb.REF_KELURAHAN D,
pbb.DAT_OBJEK_PAJAK E, pbb.TEMPAT_PEMBAYARAN H, pbb.REF_KANWIL I, pbb.REF_KANTOR J,
pbb.REF_JNS_SEKTOR K, pbb.TEMP_SPPT M
WHERE
M.STATUS_SPPT = '1' 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.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal2} AND $P{p_akhir2} AND
M.KD_PROPINSI = A.KD_PROPINSI AND M.KD_DATI2 = A.KD_DATI2 AND
M.KD_KECAMATAN = A.KD_KECAMATAN AND M.KD_KELURAHAN = A.KD_KELURAHAN AND
M.KD_BLOK = A.KD_BLOK AND M.NO_URUT = A.NO_URUT AND
M.KD_JNS_OP = A.KD_JNS_OP AND M.THN_TEMP_SPPT = A.THN_PAJAK_SPPT AND
A.KD_PROPINSI = E.KD_PROPINSI AND
A.KD_DATI2 = E.KD_DATI2 AND
A.KD_KECAMATAN = E.KD_KECAMATAN AND
A.KD_KELURAHAN = E.KD_KELURAHAN AND
A.KD_BLOK = E.KD_BLOK AND
A.NO_URUT = E.NO_URUT AND
A.KD_JNS_OP = E.KD_JNS_OP AND
A.KD_PROPINSI = B.KD_PROPINSI AND
A.KD_DATI2 = B.KD_DATI2 AND
A.KD_PROPINSI = C.KD_PROPINSI AND
A.KD_DATI2 = C.KD_DATI2 AND
A.KD_KECAMATAN = C.KD_KECAMATAN AND
A.KD_PROPINSI = D.KD_PROPINSI AND
A.KD_DATI2 = D.KD_DATI2 AND
A.KD_KECAMATAN = D.KD_KECAMATAN AND
A.KD_KELURAHAN = D.KD_KELURAHAN AND
A.KD_KANWIL = H.KD_KANWIL AND
A.KD_KANTOR = H.KD_KANTOR AND
A.KD_TP = H.KD_TP AND
A.KD_KANWIL = I.KD_KANWIL AND
A.KD_KANWIL = J.KD_KANWIL AND
A.KD_KANTOR = J.KD_KANTOR AND
D.KD_SEKTOR = K.KD_SEKTOR
ORDER BY A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,
A.KD_KELURAHAN,A.KD_BLOK,A.NO_URUT,A.KD_JNS_OP;]]>
</queryString>
<field name="nm_wp_sppt" class="java.lang.String"/>
<field name="jln_wp_sppt" class="java.lang.String"/>
<field name="blok_kav_no_wp_sppt" class="java.lang.String"/>
<field name="kelurahan_wp_sppt" class="java.lang.String"/>
<field name="kota_wp_sppt" class="java.lang.String"/>
<field name="npwp_sppt" class="java.lang.String"/>
<field name="rtrw_wp" class="java.lang.String"/>
<field name="no_persil_sppt" class="java.lang.String"/>
<field name="siklus_sppt" class="java.lang.Integer"/>
<field name="kd_kls_tanah" class="java.lang.String"/>
<field name="thn_awal_kls_tanah" class="java.lang.String"/>
<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="kd_kls_bng" class="java.lang.String"/>
<field name="thn_awal_kls_bng" class="java.lang.String"/>
<field name="tgl_jatuh_tempo_sppt" class="java.sql.Timestamp"/>
<field name="luas_bumi_sppt" class="java.lang.Long"/>
<field name="luas_bng_sppt" class="java.lang.Long"/>
<field name="njop_bumi_sppt" class="java.lang.Long"/>
<field name="njop_bng_sppt" class="java.lang.Long"/>
<field name="njop_sppt" class="java.lang.Long"/>
<field name="njoptkp_sppt" class="java.lang.Integer"/>
<field name="pbb_terhutang_sppt" class="java.lang.Long"/>
<field name="faktor_pengurang_sppt" class="java.lang.Long"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.lang.Long"/>
<field name="tgl_terbit_sppt" class="java.sql.Timestamp"/>
<field name="nop" class="java.lang.String"/>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="kd_kanwil" class="java.lang.String"/>
<field name="kd_kantor" class="java.lang.String"/>
<field name="kd_tp" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="kd_sektor" class="java.lang.String"/>
<field name="jalan_op" class="java.lang.String"/>
<field name="blok_kav_no_op" class="java.lang.String"/>
<field name="rtrw_op" class="java.lang.String"/>
<field name="no_persil" class="java.lang.String"/>
<field name="nm_tp" class="java.lang.String"/>
<field name="alamat_tp" class="java.lang.String"/>
<field name="nm_kanwil" class="java.lang.String"/>
<field name="nm_kantor" class="java.lang.String"/>
<field name="kota_terbit" class="java.lang.String"/>
<field name="nm_sektor" class="java.lang.String"/>
<field name="kd_kls_tanah_ber" class="java.lang.String"/>
<field name="thn_awal_kls_tanah_ber" class="java.lang.String"/>
<field name="kd_kls_bng_ber" class="java.lang.String"/>
<field name="thn_awal_kls_bng_ber" class="java.lang.String"/>
<field name="luas_bumi_beban_sppt" class="java.lang.Long"/>
<field name="luas_bng_beban_sppt" class="java.lang.Long"/>
<field name="njop_bumi_beban_sppt" class="java.lang.Long"/>
<field name="njop_bng_beban_sppt" class="java.lang.Long"/>
<variable name="variabela" class="java.lang.String">
<variableExpression><![CDATA[$F{jalan_op}+' '+$F{blok_kav_no_op}]]></variableExpression>
</variable>
<variable name="vlc_persil" class="java.lang.String">
<variableExpression><![CDATA[$F{no_persil}==null ? ' ' : 'PRSL:'+$F{no_persil}]]></variableExpression>
</variable>
<variable name="jalan_op" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? $F{jalan_op} : $F{jalan_op}]]></variableExpression>
</variable>
<variable name="rtrwop" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? $F{rtrw_op}+' '+$V{vlc_persil} : $F{blok_kav_no_op}]]></variableExpression>
</variable>
<variable name="kelurahan_op" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? $F{nm_kelurahan} : $F{rtrw_op}+' '+$V{vlc_persil}]]></variableExpression>
</variable>
<variable name="kecamatan_op" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? $F{nm_kecamatan} : $F{nm_kelurahan}]]></variableExpression>
</variable>
<variable name="dati2_op" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? $F{nm_dati2} : $F{nm_kecamatan}]]></variableExpression>
</variable>
<variable name="propinsi_op" class="java.lang.String">
<variableExpression><![CDATA[$V{variabela}.length()<31 ? ' ' : $F{nm_dati2}]]></variableExpression>
</variable>
<variable name="variabelb" class="java.lang.String">
<variableExpression><![CDATA[$F{jln_wp_sppt}+' '+$F{blok_kav_no_wp_sppt}]]></variableExpression>
</variable>
<variable name="jalan_wp" class="java.lang.String">
<variableExpression><![CDATA[$V{variabelb}.length()<31 ? $F{jln_wp_sppt} : $F{jln_wp_sppt}]]></variableExpression>
</variable>
<variable name="rtrw_wp" class="java.lang.String">
<variableExpression><![CDATA[$V{variabelb}.length()<31 ? $F{rtrw_wp} : $F{blok_kav_no_wp_sppt}]]></variableExpression>
</variable>
<variable name="kelurahan_wp" class="java.lang.String">
<variableExpression><![CDATA[$V{variabelb}.length()<31 ? $F{kelurahan_wp_sppt} : $F{rtrw_wp}]]></variableExpression>
</variable>
<variable name="kota_wp" class="java.lang.String">
<variableExpression><![CDATA[$V{variabelb}.length()<31 ? $F{kota_wp_sppt} : $F{kelurahan_wp_sppt}]]></variableExpression>
</variable>
<variable name="kosong_wp" class="java.lang.String">
<variableExpression><![CDATA[$V{variabelb}.length()<31 ? '' : $F{kota_wp_sppt}]]></variableExpression>
</variable>
<variable name="cf_kd_kelas_tanah" class="java.lang.String">
<variableExpression><![CDATA[$F{kd_kls_tanah}.toUpperCase()=='XXX' ? 0 : $F{kd_kls_tanah}]]></variableExpression>
</variable>
<variable name="cf_kd_kls_bng" class="java.lang.String">
<variableExpression><![CDATA[$F{kd_kls_bng}.toUpperCase()=='XXX' ? 0 : $F{kd_kls_bng}]]></variableExpression>
</variable>
<variable name="cf_kd_kls_tanah_ber" class="java.lang.String">
<variableExpression><![CDATA[$F{kd_kls_tanah_ber}.toUpperCase()=="XXX" ? "XXX" : $F{kd_kls_tanah_ber}]]></variableExpression>
</variable>
<variable name="cf_kd_kls_bng_ber" class="java.lang.String">
<variableExpression><![CDATA[$F{kd_kls_bng_ber}.toUpperCase()=="XXX" ? "XXX" : $F{kd_kls_bng_ber}]]></variableExpression>
</variable>
<variable name="dtjt" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format($F{tgl_jatuh_tempo_sppt}))]]></variableExpression>
</variable>
<variable name="mtjt" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format($F{tgl_jatuh_tempo_sppt}))]]></variableExpression>
</variable>
<variable name="ytjt" class="java.lang.Integer" resetType="None">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format($F{tgl_jatuh_tempo_sppt}))]]></variableExpression>
</variable>
<variable name="mtjt2" class="java.lang.String" resetType="None">
<variableExpression><![CDATA[($V{mtjt} == 1) ? "JAN" : (
($V{mtjt} == 2) ? "FEB" : (
($V{mtjt} == 3) ? "MAR" : (
($V{mtjt} == 4) ? "APR" : (
($V{mtjt} == 5) ? "MEI" : (
($V{mtjt} == 6) ? "JUNI" : (
($V{mtjt} == 7) ? "JULI" : (
($V{mtjt} == 8) ? "AGT" : (
($V{mtjt} == 9) ? "SEPT" : (
($V{mtjt} == 10) ? "OKT" : (
($V{mtjt} == 11) ? "NOV" : "DES"
)
)
)
)
)
)
)
)
)
)]]></variableExpression>
</variable>
<variable name="dtt" class="java.lang.String" resetType="None">
<variableExpression><![CDATA[$P{tgl_terbit}.substring(0,2)]]></variableExpression>
</variable>
<variable name="mtt" class="java.lang.String" resetType="None">
<variableExpression><![CDATA[$P{tgl_terbit}.substring(3,5)]]></variableExpression>
</variable>
<variable name="ytt" class="java.lang.String" resetType="None">
<variableExpression><![CDATA[$P{tgl_terbit}.substring(6,10)]]></variableExpression>
</variable>
<variable name="mtt2" class="java.lang.String" resetType="None">
<variableExpression><![CDATA[($V{mtt} == "01") ? "JAN" : (
($V{mtt} == "02") ? "FEB" : (
($V{mtt} == "03") ? "MAR" : (
($V{mtt} == "04") ? "APR" : (
($V{mtt} == "05") ? "MEI" : (
($V{mtt} == "06") ? "JUNI" : (
($V{mtt} == "07") ? "JULI" : (
($V{mtt} == "08") ? "AGT" : (
($V{mtt} == "09") ? "SEPT" : (
($V{mtt} == "10") ? "OKT" : (
($V{mtt} == "11") ? "NOV" : "DES"
)
)
)
)
)
)
)
)
)
)]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="503" splitType="Stretch">
<textField>
<reportElement uuid="a32463b2-2bb3-4673-9de0-689d153a6259" x="310" y="45" width="52" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d867878d-9771-4ad4-82ba-2210cf42e81f" x="361" y="45" width="60" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_sektor}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="ae73a0ad-e883-40e6-838e-c36ed0201fff" x="8" y="81" width="195" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{jalan_op}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="5c714038-a20f-4066-8972-ec265f445327" x="8" y="93" width="195" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{rtrwop}.trim()=="null")?"":$V{rtrwop}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="3d2ea77f-cc87-42dc-bc29-c4d03a1f0ad0" x="8" y="105" width="195" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{kelurahan_op}.trim()=="null")?"":$V{kelurahan_op}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="33075627-e7ca-4ce9-b0f8-8aab2c37be33" x="8" y="117" width="193" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{kecamatan_op}.trim()=="null")?"":$V{kecamatan_op}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="1baf7d52-3999-414d-aaeb-7936fceee803" x="8" y="129" width="193" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{dati2_op}.trim()=="null")?"":$V{dati2_op}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="98878046-a519-43b5-bd7b-f48485e9250c" x="8" y="141" width="193" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{propinsi_op}.trim()=="null")?"":$V{propinsi_op}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="8c24113e-6052-4416-abda-ef9c0d4a72d3" x="257" y="81" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="27466c46-4cda-49f3-bd38-1f8e753d96ed" x="257" y="93" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{jalan_wp}.trim()=="null")?"":$V{jalan_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="b59fb14d-9bcf-4199-be45-6c3be76e1597" x="257" y="105" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{rtrw_wp}.trim()=="null")?"":$V{rtrw_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="db3eac81-ec0e-4ba9-9594-faadd4d3655c" x="257" y="117" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{kelurahan_wp}.trim()=="null")?"":$V{kelurahan_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="214ee11e-cec3-4114-807b-6c8e833ec648" x="257" y="129" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($V{kota_wp}.trim()=="null")?"":$V{kota_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cdbd9be3-896d-4229-8add-f97a96aad83b" x="257" y="141" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{kosong_wp} ?
$V{kosong_wp} : ""]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="359ecf50-25ed-4f48-a432-f89241c1a931" x="1" y="167" width="59" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[BUMI]]></text>
</staticText>
<staticText>
<reportElement uuid="14ea96ed-2d75-42a3-acc3-5ccbab85c4c8" x="1" y="178" width="59" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[BANGUNAN]]></text>
</staticText>
<textField>
<reportElement uuid="bc36c614-13a1-48e9-a246-581710391451" x="74" y="167" width="61" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bumi_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4f44176a-21d3-47e7-9086-42cdf3f5a15e" x="74" y="178" width="61" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bng_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="da8229c9-e231-4081-ac4c-357ecd028f88" x="149" y="167" width="39" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{cf_kd_kelas_tanah}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0eb51e4a-5111-49b7-9c4c-79bce5fd456d" x="149" y="178" width="39" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{cf_kd_kls_bng}]]></textFieldExpression>
</textField>
<textField pattern="">
<reportElement uuid="059004cb-1ea3-4666-ada9-9b0484acb645" x="200" y="167" width="100" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njop_bumi_sppt}.doubleValue()/$F{luas_bumi_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0cd37899-b79b-4ec8-be38-487bb9337f8a" x="200" y="178" width="100" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njop_bng_sppt}.doubleValue()/$F{luas_bng_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="532cce4a-b1ed-46cb-812f-5df23a89ddc6" x="74" y="189" width="61" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bumi_beban_sppt}==null ? "" : $F{luas_bumi_beban_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cb4d0817-78fe-4213-830b-aa28257d2156" x="74" y="200" width="61" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bng_beban_sppt}==null ? "" : $F{luas_bng_beban_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6c932736-427c-4c02-b288-13ef78d6f395" x="149" y="189" width="39" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{cf_kd_kls_tanah_ber}==null ? "" : $V{cf_kd_kls_tanah_ber}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="36387506-aafc-4ffb-a314-3c7de3308eab" x="149" y="200" width="39" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{cf_kd_kls_bng_ber}==null ? "" : $V{cf_kd_kls_bng_ber}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7f063b6d-833b-4e2d-b8d6-8f6a40b1b79a" x="200" y="189" width="100" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi_beban_sppt}==null ?
"" :
new java.text.DecimalFormat("#,##0").format($F{njop_bumi_beban_sppt}.doubleValue()/$F{luas_bumi_beban_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="44926e8a-6a45-4478-8522-5aee6f492fcd" x="200" y="200" width="100" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng_beban_sppt}==null ?
"" :
new java.text.DecimalFormat("#,##0").format($F{njop_bng_beban_sppt}.doubleValue()/$F{luas_bng_beban_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e5c92cdc-236d-4c99-aa40-38cb40c85f30" x="312" y="167" width="103" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njop_bumi_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="eb3d9926-82e0-454f-9d1a-ddfa92bc4739" x="312" y="178" width="103" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njop_bng_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="309b6881-6b8d-4cc1-be73-6f712e590ceb" x="312" y="189" width="103" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi_beban_sppt}==null ?
"" : new java.text.DecimalFormat("#,##0").format($F{njop_bumi_beban_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e640eb89-9b7f-4d7d-bfd5-84528d810b6f" x="312" y="200" width="103" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng_beban_sppt}==null ?
"" : new java.text.DecimalFormat("#,##0").format($F{njop_bng_beban_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="06f7c22a-d043-4124-968a-436688a98794" x="1" y="189" width="59" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi_beban_sppt}==null ?
"" : "BUMI BERSAMA"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4953cc05-ed0b-42c8-b2a9-8e3f2f084f1d" x="1" y="200" width="59" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng_beban_sppt}==null ?
"" : "BANG BERSAMA"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bf8d06b9-4031-45c4-ae4e-8144afebab15" x="302" y="223" width="113" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njop_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="17982505-aafa-43d4-ac19-97a996a04f37" x="302" y="235" width="113" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njoptkp_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{njoptkp_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f45a07a9-8f09-4a31-bac0-a9bccf72cc9f" x="302" y="247" width="113" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($F{njop_sppt}-$F{njoptkp_sppt})==0 ?
0 :
new java.text.DecimalFormat("#,##0").format(($F{njop_sppt}-$F{njoptkp_sppt}).doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="af0f1ed8-6753-4979-a59b-bca387a00419" x="319" y="259" width="96" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_terhutang_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{pbb_terhutang_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f45a07a9-8f09-4a31-bac0-a9bccf72cc9f" x="221" y="259" width="84" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[($F{njop_sppt}-$F{njoptkp_sppt})==0 ?
0 :
new java.text.DecimalFormat("#,##0").format(($F{njop_sppt}-$F{njoptkp_sppt}).doubleValue())]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="df98e22d-7b9c-46fe-bee9-e2aaa5c5e6f1" x="139" y="259" width="91" height="18"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak_sppt">
<subreportParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="njop_sppt">
<subreportParameterExpression><![CDATA[$F{njop_sppt}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "CetakMasalSppt_1.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="ec340041-4b6e-4f46-bcff-8c2f76b87974" x="315" y="277" width="100" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{faktor_pengurang_sppt}==0 ?
"" : $F{faktor_pengurang_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f7c184e9-75bd-4d24-9f24-a1a5b0cbcc3d" x="27" y="277" width="278" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{faktor_pengurang_sppt}==0 ?
"" : "Faktor Pengurang/Pengaturan Pengenaan"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e6f708b4-f82c-49e5-9d9a-c910af6cdbb8" x="316" y="298" width="100" height="15"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3857c410-ed6c-4bdc-bc3a-4a74443db942" x="260" y="337" width="66" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kota_terbit}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="17e525c9-db06-448d-89e7-6b3e1176be6f" stretchType="RelativeToBandHeight" x="8" y="362" width="292" height="13"/>
<textElement textAlignment="Left">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_tp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="511e8b8a-238d-4c59-a9b4-5c91b21c8694" stretchType="RelativeToBandHeight" x="8" y="375" width="222" height="24"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_tp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bd9d1cad-c2ab-408b-8e1e-dbac020340ca" x="79" y="438" width="277" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="678a68ec-63b7-4ce8-b6c0-d50cc036d671" x="146" y="449" width="172" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7db8477d-11e9-4992-a2b9-3e38a4386dfa" x="146" y="462" width="172" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e85bd74-c682-426e-b1f4-2af4240d604b" x="78" y="473" width="253" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="448add0d-bd8b-42e1-82c3-1b77cefa3b46" x="78" y="485" width="41" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}+" - "]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8b87375b-46ac-49d4-ba1c-fd3f650997df" x="159" y="485" width="78" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}==0 ?
0 :
new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7492fc79-9461-4622-9ff1-1a53ea42be4a" x="20" y="57" width="169" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="47b74c6a-10e5-48cd-8775-a91e06ddcb20" x="143" y="57" width="133" height="13"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_sppt">
<subreportParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="siklus_sppt">
<subreportParameterExpression><![CDATA[$F{siklus_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="nm_wp_sppt">
<subreportParameterExpression><![CDATA[$F{nm_wp_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="pbb_yg_harus_dibayar_sppt">
<subreportParameterExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="SUBREPORT_DIR">
<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "CetakMasalSppt_3.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="a5d1f640-4838-4bba-95bc-7f4d2db78204" x="5" y="310" width="424" height="27"/>
<subreportParameter name="pbb_yg_harus_dibayar">
<subreportParameterExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "CetakMasalSppt_Terbilang.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="9ae684d4-7585-4fdf-af5b-ec6a52695579" x="249" y="389" width="113" height="30"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "CetakMasalSppt_2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="6a451725-ff8c-4dbf-aa3c-8144128cd22d" x="119" y="485" width="37" height="12"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jenis_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="siklus_sppt">
<subreportParameterExpression><![CDATA[$F{siklus_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_sppt">
<subreportParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="vnop"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "CetakMasalSppt_Terbilang2.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="251d4e5c-2442-4c0e-80b2-8030fee212ad" x="88" y="332" width="115" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{dtjt}.toString()+" "+$V{mtjt2}.toString()+" "+$V{ytjt}.toString()]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="251d4e5c-2442-4c0e-80b2-8030fee212ad" x="329" y="337" width="86" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[" "+$V{dtt}+" "+$V{mtt2}+" "+$V{ytt}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>