|
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/PengeluaranHimbauan/ |
| [ 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="HimbauanBiasa" language="groovy" pageWidth="595" pageHeight="936" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="45f02657-6e5b-4358-9a0c-00223c23b3d0">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="402"/>
<style name="table">
<box>
<topPen lineWidth="1.0" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="dataset1" uuid="1a22edbb-2b8b-4768-9d6b-28bfe5bb05ea">
<parameter name="kd_kanwil" class="java.lang.String"/>
<queryString>
<![CDATA[Select nm_kanwil from ref_kanwil where kd_kanwil = $P{kd_kanwil};]]>
</queryString>
<field name="nm_kanwil" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset3" uuid="22c46df8-fcd2-4bfc-8515-d98be55e4410">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[select al_kantor||' '||kota_terbit||' TELP.'||NO_TELPON||' FAX.'||NO_FAKSIMILI as alamat
from ref_kantor
where kd_kanwil = $P{kd_kanwil} and
kd_kantor = $P{kd_kantor};]]>
</queryString>
<field name="alamat" class="java.lang.String"/>
</subDataset>
<subDataset name="Table Dataset 1" uuid="4e062056-5c0b-45a3-9ee2-7071e807fe74"/>
<subDataset name="Table Dataset 2" uuid="2407f18c-f358-4511-8ec6-f07c879ca54b">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[Select nm_kantor from ref_kantor
where kd_kanwil = $P{kd_kanwil} and
kd_kantor = $P{kd_kantor};]]>
</queryString>
<field name="nm_kantor" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset2" uuid="966d4e9d-1e3a-43cd-ba73-3ecfa6ce9cb9">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[Select nm_kantor from ref_kantor
where kd_kanwil = $P{kd_kanwil} and
kd_kantor = $P{kd_kantor};]]>
</queryString>
<field name="nm_kantor" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset4" uuid="aabc241a-8ecd-4fe2-b20e-18bf3190e2ea"/>
<subDataset name="dataset5" uuid="1f078a98-6712-401c-8c24-89fca7f36b94">
<queryString>
<![CDATA[Select a.nm_pegawai,a.nip
from pegawai a,
posisi_pegawai b
where a.nip = b.nip and
b.kd_jabatan = '10' and
b.kd_wewenang = '10' and
to_date(to_char(b.tgl_akhir_berlaku,'dd/mm/yyyy'),'dd/mm/yyyy') > (select to_date(to_char(now(),'dd/mm/yyyy'),'dd/mm/yyyy'));]]>
</queryString>
<field name="nm_pegawai" class="java.lang.String"/>
<field name="nip" class="java.lang.String"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_kota" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="thn_awal" class="java.lang.String"/>
<parameter name="thn_akhir" class="java.lang.String"/>
<parameter name="ketetapan_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="ketetapan_akhir" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_surat" class="java.lang.String"/>
<parameter name="tgl_terbit" class="java.lang.String">
<parameterDescription><![CDATA[]]></parameterDescription>
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_denda" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl" class="java.lang.String"/>
<parameter name="hari" class="java.lang.String"/>
<parameter name="waktu" class="java.lang.String"/>
<parameter name="tempat" class="java.lang.String"/>
<queryString>
<![CDATA[Select CONCAT(coalesce(c.kd_propinsi,' ')||'.'||coalesce(c.kd_dati2,'')||'.'||coalesce(c.kd_kecamatan,' ')
||'.'||coalesce(c.kd_kelurahan,' ')||'.'||coalesce(c.kd_blok,'')||'.'||coalesce(c.no_urut,' ')
||'.'||coalesce(c.kd_jns_op,' ')) as nop,
c.kd_blok,
c.no_urut,
c.kd_jns_op,
c.kd_kanwil,
c.kd_kantor,
concat(coalesce(a.jalan_op,'')||' '||coalesce(a.blok_kav_no_op,'')) as jalanop,
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,
g.JALAN_WP,
g.BLOK_KAV_NO_WP,
now() as tgl_surat,
g.RW_WP,
g.RT_WP,
d.jml_sppt_yg_dibayar,
d.denda_sppt,
sum(d.jml_sppt_yg_dibayar - d.denda_sppt) as spptdibayar,
to_date($P{tgl_terbit},'dd mm yyyy') as tgl,
to_date($P{tgl},'dd mm yyyy') as tglbayar
from dat_objek_pajak a,
sppt c left join 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),
ref_dati2 f,
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.TGL_JATUH_TEMPO_SPPT < now() and
c.pbb_terhutang_sppt <> 0 and
c.pbb_terhutang_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_kota} and
a.kd_kecamatan = $P{kd_kecamatan} and
a.kd_kelurahan = $P{kd_kelurahan} and
to_number(c.thn_pajak_sppt, '9999') >= to_number($P{thn_awal},'9999') and
to_number(c.thn_pajak_sppt, '9999') <= to_number($P{thn_akhir},'9999') and
c.pbb_terhutang_sppt >= to_number($P{ketetapan_awal},'9999') AND
c.pbb_terhutang_sppt < to_number($P{ketetapan_akhir},'9999')
group by CONCAT(coalesce(c.kd_propinsi,' ')||'.'||coalesce(c.kd_dati2,'')||'.'||coalesce(c.kd_kecamatan,' ')
||'.'||coalesce(c.kd_kelurahan,' ')||'.'||coalesce(c.kd_blok,'')||'.'||coalesce(c.no_urut,' ')
||'.'||coalesce(c.kd_jns_op,' ')),
jalanop,
c.kd_blok,
c.no_urut,
c.kd_jns_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,
g.JALAN_WP,
g.BLOK_KAV_NO_WP,
g.RW_WP,
g.RT_WP,
c.kd_kanwil,
c.kd_kantor,
d.jml_sppt_yg_dibayar,
d.denda_sppt
order by nop]]>
</queryString>
<field name="nop" 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_kanwil" class="java.lang.String"/>
<field name="kd_kantor" class="java.lang.String"/>
<field name="jalanop" 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="jalan_wp" class="java.lang.String"/>
<field name="blok_kav_no_wp" class="java.lang.String"/>
<field name="tgl_surat" class="java.sql.Timestamp"/>
<field name="rw_wp" class="java.lang.String"/>
<field name="rt_wp" class="java.lang.String"/>
<field name="jml_sppt_yg_dibayar" class="java.lang.Long"/>
<field name="denda_sppt" class="java.lang.Long"/>
<field name="spptdibayar" class="java.math.BigDecimal"/>
<field name="tgl" class="java.sql.Date"/>
<field name="tglbayar" class="java.sql.Date"/>
<detail>
<band height="896" splitType="Stretch">
<staticText>
<reportElement uuid="2beba3fb-1f3f-4dd9-b2d9-e1a1fb7b9be4" x="0" y="329" width="555" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[====================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="3913d894-3516-44d4-a248-65c612d15365" x="1" y="561" width="555" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[==================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="213aa087-3cec-4f4a-ae0e-54b209a809b7" x="0" y="305" width="555" height="20"/>
<textElement/>
<text><![CDATA[dengan rincian sebagai berikut :]]></text>
</staticText>
<staticText>
<reportElement uuid="d4e89e89-14eb-467a-a55e-096a56b1ee07" x="0" y="232" width="555" height="27"/>
<textElement verticalAlignment="Top"/>
<text><![CDATA[Menurut tata usaha kami, Saudara belum melunasi PBB sebagai berikut:]]></text>
</staticText>
<staticText>
<reportElement uuid="ddb0704a-96d0-489c-aae9-bc511b5e3a64" x="0" y="88" width="44" height="20"/>
<textElement/>
<text><![CDATA[Nomor :]]></text>
</staticText>
<staticText>
<reportElement uuid="1214a607-8d2f-4046-92a7-333c6fd118be" x="0" y="108" width="555" height="20"/>
<textElement/>
<text><![CDATA[Sifat : Amat segera]]></text>
</staticText>
<staticText>
<reportElement uuid="c158bf8a-e8a0-43aa-beed-ee434947368a" x="0" y="128" width="555" height="32"/>
<textElement/>
<text><![CDATA[Hal : Himbauan Pelunasan PBB
Pada tanggal ]]></text>
</staticText>
<textField>
<reportElement uuid="81b66f11-a149-4c40-a823-59bbc14b25e1" x="44" y="88" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA["S-" + $P{no_surat}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="be32bede-240e-41fc-a6a8-656b6135368f" x="0" y="0" width="555" height="20"/>
<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="a5119c99-f589-4b18-9016-c2ad086e8102">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="20" width="555">
<textField>
<reportElement uuid="4ceed32b-2662-42b5-8797-bdbbf9945e0e" x="0" y="0" width="555" height="16"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nm_kanwil}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="44cb16e9-fff0-449b-bd9a-01a8f497645e" x="0" y="41" width="555" height="23"/>
<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="dataset3" uuid="b28ba255-1b5b-47f6-be4f-e27de8d1446f">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="23" width="555">
<textField>
<reportElement uuid="aad817bc-a719-4e62-83d3-04fa68ad6c1c" x="0" y="0" width="555" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{alamat}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="2232dadf-d363-4f19-82d1-cc1beee2610b" x="0" y="59" width="555" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[=======================================================================================================]]></text>
</staticText>
<componentElement>
<reportElement uuid="8745f9d9-2918-434e-8b0f-b7b07a357573" x="0" y="20" width="555" height="21"/>
<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="9f8cfa69-d90d-4cc3-aa3f-c353d9fa5dbd">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="21" width="555">
<textField>
<reportElement uuid="a778296e-559b-4a4f-b3f7-be753d876e04" x="0" y="1" width="555" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="db1bf87f-9629-41d2-8226-2600b4fb21fa" x="0" y="160" width="22" height="20"/>
<textElement/>
<text><![CDATA[Yth.]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement uuid="743888c4-c394-4266-afe1-fd8cfeec8c04" x="22" y="160" width="533" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nm_wp} == null ? "" : $F{nm_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="f35f1bd6-fba8-4747-bbfd-8d58530ebac8" x="22" y="180" width="533" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[($F{jalan_wp} == null ? "" : $F{jalan_wp})
+" "+
($F{blok_kav_no_wp} == null ? "" : $F{blok_kav_no_wp})
+" RT."+
($F{rt_wp} == null ? "" : $F{rt_wp})
+" RW."+
($F{rw_wp} == null ? "" : $F{rw_wp})]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="2d1d775f-e009-42bc-8ee5-1705c2750a5e" x="22" y="200" width="533" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[($F{kelurahan_wp_sppt} == null ? "" : $F{kelurahan_wp_sppt})
+ " " +
($F{kota_wp_sppt} == null ? "" : $F{kota_wp_sppt})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="49ca804a-edae-48e0-9743-975e52dbb47d" x="193" y="350" width="114" height="40"/>
<textElement textAlignment="Center"/>
<text><![CDATA[Tanggal
Jatuh Tempo]]></text>
</staticText>
<rectangle>
<reportElement uuid="feefc48b-12fa-4652-94d2-f6bb84d90868" x="57" y="258" width="439" height="20"/>
</rectangle>
<staticText>
<reportElement uuid="22fcfbc1-f772-48db-8201-0c09822d9f81" x="60" y="260" width="126" height="20"/>
<textElement/>
<text><![CDATA[Nomor SPPT :]]></text>
</staticText>
<rectangle>
<reportElement uuid="1bae3a6f-fd9e-46fc-96e5-acf56e05819c" x="57" y="278" width="439" height="20"/>
</rectangle>
<staticText>
<reportElement uuid="2ff81cb7-bc4d-4872-af80-32be0df8ac6d" x="60" y="281" width="126" height="20"/>
<textElement/>
<text><![CDATA[Alamat Objek Pajak :]]></text>
</staticText>
<textField>
<reportElement uuid="37a9e801-dad3-4222-ae3e-9357a535fa8c" x="196" y="261" width="300" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="85170a69-e75f-4f15-989f-b561620854ff" x="196" y="281" width="300" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{jalanop}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="7323b50a-1825-4a5c-b8e9-f8323750d68f" x="93" y="349" width="100" height="40"/>
<textElement textAlignment="Center"/>
<text><![CDATA[Ketetapan PBB
(Rp.)]]></text>
</staticText>
<staticText>
<reportElement uuid="e533fd8d-1eac-4431-b6dd-b6fe96e4aab7" x="22" y="349" width="71" height="20"/>
<textElement/>
<text><![CDATA[Tahun ]]></text>
</staticText>
<staticText>
<reportElement uuid="b82e9bda-d8df-4cdd-bc37-b46540dd0141" x="22" y="786" width="519" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[Kepala Kantor]]></text>
</staticText>
<componentElement>
<reportElement uuid="6cee723c-2360-41aa-8191-1b3cd953335d" x="335" y="852" width="206" height="39"/>
<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="dataset5" uuid="237abf94-6d3a-4a5c-8113-253896d5648c">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="39" width="206">
<textField isBlankWhenNull="true">
<reportElement uuid="9ea5fb59-7772-44f3-b593-fa6568b9a04e" x="0" y="1" width="205" height="20"/>
<textElement textAlignment="Right"/>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="c423205c-2ac7-4370-bd2a-fb9140ac1525" x="7" y="19" width="198" height="20"/>
<textElement textAlignment="Right"/>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="fdc02f44-1407-4f94-9af4-a319e035c8d7" x="0" y="349" width="13" height="20"/>
<textElement/>
<text><![CDATA[No]]></text>
</staticText>
<staticText>
<reportElement uuid="932de6e4-531e-421f-b6d1-879091997146" x="307" y="349" width="114" height="40"/>
<textElement textAlignment="Center"/>
<text><![CDATA[Denda Administrasi 2%
sebulan (Rp.)]]></text>
</staticText>
<staticText>
<reportElement uuid="7546f19e-847c-420c-909b-4c03183fdba2" x="421" y="349" width="114" height="40"/>
<textElement textAlignment="Center"/>
<text><![CDATA[PBB terutang s/d
vltglbunga (Rp.)]]></text>
</staticText>
<staticText>
<reportElement uuid="99dcdfb3-4cd5-4a6e-9848-f63e17260830" x="1" y="530" width="555" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[====================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="d92f671b-3c91-49d3-a557-488fcc4e7ded" x="13" y="545" width="54" height="20"/>
<textElement/>
<text><![CDATA[Total]]></text>
</staticText>
<subreport>
<reportElement uuid="f7807ae0-f444-4308-be70-c5e23209d2d2" x="1" y="389" width="534" height="141"/>
<subreportParameter name="kd_kota">
<subreportParameterExpression><![CDATA[$P{kd_kota}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="ketetapan_akhir">
<subreportParameterExpression><![CDATA[$P{ketetapan_akhir}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$P{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_akhir">
<subreportParameterExpression><![CDATA[$P{thn_akhir}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_awal">
<subreportParameterExpression><![CDATA[$P{thn_awal}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tgl_terbit">
<subreportParameterExpression><![CDATA[$P{tgl_denda}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="ketetapan_awal">
<subreportParameterExpression><![CDATA[$P{ketetapan_awal}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["himbauan_sub_data.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="9c8c3c89-085c-4f14-8974-b3ec7568b5e5" x="64" y="542" width="456" height="23"/>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kota">
<subreportParameterExpression><![CDATA[$P{kd_kota}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_akhir">
<subreportParameterExpression><![CDATA[$P{thn_akhir}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$P{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_awal">
<subreportParameterExpression><![CDATA[$P{thn_awal}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tgl_terbit">
<subreportParameterExpression><![CDATA[$P{tgl_denda}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["himbauan_sub_data_sum.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="3915da96-c9a6-4998-9489-6c33a2291e2e" x="22" y="581" width="532" height="196"/>
<textElement/>
<text><![CDATA[ Sehubungan dengan hal tersebut disampaikan:
Dalam rangka kegiatan Jemput Bola-Pembayaran PBB, kami akan membuka loket pembayaran PBB pada:
Hari :
Tanggal :
Waktu :
Tempat :
Sangat diharapkan pada kesempatan tersebut Saudara dapat melakukan pembayaran/melunasi PBB sesuai jumlah tersebut di atas.
Apabila sebelum menerima Surat Himbauan ini jumlah PBB di atas telah Saudara lunasi, kami mohon maaf dan mengucapkan terima kasih, serta dimohon fotokopi bukti pelunasannya (STTS) dapat disampaikan kepada kami.
Dalam hal Saudara belum menerima SPPT-PBB, surat pemberitahuan ini dapat digunakan sebagai alat untuk melaksanakan pembayaran.
Demikian disampaikan atas perhatiannya diucapkan terima kasih.]]></text>
</staticText>
<textField>
<reportElement uuid="9eabf803-00c5-44ac-9b39-5513f01161ca" x="111" y="619" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{hari}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ed2e2402-a7d7-4c37-9804-8b3b5c6d8457" x="111" y="645" width="195" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{waktu}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2031deb5-f9a0-4826-8d5c-6cfc7706bd23" x="111" y="658" width="196" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{tempat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8df8d80f-2414-4e21-8de9-4501a842e2ac" x="421" y="88" width="128" height="14"/>
<textElement>
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd").format($F{tgl_surat})
+" "+
($F{tgl_surat}.getMonth() == 0 ?
"Januari" : $F{tgl_surat}.getMonth() == 1 ?
"Februari" : $F{tgl_surat}.getMonth() == 2 ?
"Maret" : $F{tgl_surat}.getMonth() == 3 ?
"April" : $F{tgl_surat}.getMonth() == 4 ?
"Mei" : $F{tgl_surat}.getMonth() == 5 ?
"Juni" : $F{tgl_surat}.getMonth() == 6 ?
"Juli" : $F{tgl_surat}.getMonth() == 7 ?
"Agustus" : $F{tgl_surat}.getMonth() == 8 ?
"September" : $F{tgl_surat}.getMonth() == 9 ?
"Oktober" : $F{tgl_surat}.getMonth() == 10 ?
"November" : $F{tgl_surat}.getMonth() == 11 ?
"Desember" : "Unknown")
+" "+
new SimpleDateFormat("yyyy").format($F{tgl_surat})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8e47a0be-83aa-4b03-9d02-6c06ecd4177f" x="111" y="632" width="110" height="14"/>
<textElement>
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd").format($F{tglbayar})
+" "+
($F{tglbayar}.getMonth() == 0 ?
"Januari" : $F{tglbayar}.getMonth() == 1 ?
"Februari" : $F{tglbayar}.getMonth() == 2 ?
"Maret" : $F{tglbayar}.getMonth() == 3 ?
"April" : $F{tglbayar}.getMonth() == 4 ?
"Mei" : $F{tglbayar}.getMonth() == 5 ?
"Juni" : $F{tglbayar}.getMonth() == 6 ?
"Juli" : $F{tglbayar}.getMonth() == 7 ?
"Agustus" : $F{tglbayar}.getMonth() == 8 ?
"September" : $F{tglbayar}.getMonth() == 9 ?
"Oktober" : $F{tglbayar}.getMonth() == 10 ?
"November" : $F{tglbayar}.getMonth() == 11 ?
"Desember" : "Unknown")
+" "+
new SimpleDateFormat("yyyy").format($F{tglbayar})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="fcf0aa12-226c-499f-9892-29d57943d936" x="1" y="593" width="21" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[1.]]></text>
</staticText>
<staticText>
<reportElement uuid="fcf0aa12-226c-499f-9892-29d57943d936" x="1" y="707" width="21" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[2.]]></text>
</staticText>
<staticText>
<reportElement uuid="fcf0aa12-226c-499f-9892-29d57943d936" x="2" y="744" width="21" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[3.]]></text>
</staticText>
</band>
</detail>
</jasperReport>