|
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/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="himbauan_sub_data" language="groovy" pageWidth="595" pageHeight="425" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="aaca4da0-c49a-4a88-bc15-5514632c645c">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="8d44566c-9777-41e2-9b5c-1835d5ca0131">
<queryString>
<![CDATA[SELECT NM_KANTOR FROM REF_KANTOR]]>
</queryString>
<field name="nm_kantor" class="java.lang.String"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_akhir" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kota" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_terbit" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select c.thn_pajak_sppt, c.pbb_yg_harus_dibayar_sppt, c.tgl_jatuh_tempo_sppt, c.pbb_terhutang_sppt, e.denda_adm_stlh_pengurangan,
case
when e.denda_adm_stlh_pengurangan != null then e.denda_adm_stlh_pengurangan
when e.denda_adm_stlh_pengurangan is null then (
(0.02 *
(
case when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) > 48 then 48
when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) < 0 then 0
else
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
end
)
) * c.pbb_terhutang_sppt
)
end as denda,
case
when e.denda_adm_stlh_pengurangan != null then e.denda_adm_stlh_pengurangan
when e.denda_adm_stlh_pengurangan is null then (
(0.02 *
(
case when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) > 48 then 48
when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) < 0 then 0
else
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
end
)
) * c.pbb_terhutang_sppt
)
end + c.pbb_yg_harus_dibayar_sppt as jumlah_pbb_terhutang
from
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)
left join denda_administrasi e on (
c.kd_propinsi = e.kd_propinsi
and c.kd_dati2 = e.kd_dati2
and c.kd_kecamatan = e.kd_kecamatan
and c.kd_kelurahan = e.kd_kelurahan
and c.kd_blok = e.kd_blok
and c.no_urut = e.no_urut
and c.kd_jns_op = e.kd_jns_op
and c.thn_pajak_sppt = e.thn_denda
)
where
c.kd_propinsi = $P{kd_propinsi} and
c.kd_dati2 = $P{kd_kota} and
c.kd_kecamatan = $P{kd_kecamatan} and
c.kd_kelurahan = $P{kd_kelurahan} and
c.kd_blok = $P{kd_blok} and
c.no_urut = $P{no_urut} and
c.kd_jns_op = $P{kd_jns_op} 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')]]>
</queryString>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.lang.Long"/>
<field name="tgl_jatuh_tempo_sppt" class="java.sql.Timestamp"/>
<field name="pbb_terhutang_sppt" class="java.lang.Long"/>
<field name="denda_adm_stlh_pengurangan" class="java.lang.Long"/>
<field name="denda" class="java.lang.Double"/>
<field name="jumlah_pbb_terhutang" class="java.lang.Double"/>
<detail>
<band height="21">
<textField>
<reportElement uuid="f10e4d3d-2c43-46e5-aa0b-e71b96342d9e" positionType="Float" x="21" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7e3c6248-76f9-44da-b1c2-d1077110aa1e" positionType="Float" x="121" y="0" width="138" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c1bd549b-ce66-445b-8197-ac3490ef1d01" positionType="Float" x="200" y="0" width="129" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd MMMM yyyy").format($F{tgl_jatuh_tempo_sppt})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7d29c311-ca32-4457-ae4c-c2fce7d8e9d5" positionType="Float" x="0" y="0" width="31" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{COLUMN_COUNT}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="35f70dc3-ea8f-4c27-9b5b-d9356567072e" positionType="Float" x="336" y="0" width="45" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe01b3af-a4e1-42c3-951c-c2acffe0e106" positionType="Float" x="458" y="0" width="67" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_pbb_terhutang}).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="131">
<staticText>
<reportElement uuid="fc14abb6-4588-48f7-b17a-1ad97a64d6b6" x="0" y="20" width="539" height="52"/>
<textElement textAlignment="Justified">
<paragraph lineSpacing="Single"/>
</textElement>
<text><![CDATA[ Sehubungan dengan itu, dalam rangka penertiban administrasi kami, apabila ternyata Saudara telah melunasi PBB terhutang sebagaimana tersebut di atas kami ucapkan terima kasih dan mohon kesediaan Saudara untuk dapat menyampaikan foto copy Surat Tanda Terima Setoran (STTS) kepada kami, sedangkan jika sebaliknya mohon kiranya dapat segera melakukan pembayaran pada Bank Tempat Pembayaran yang terdekat. ]]></text>
</staticText>
<staticText>
<reportElement uuid="3913d894-3516-44d4-a248-65c612d15365" x="0" y="2" width="539" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[==================================================================================================]]></text>
</staticText>
<componentElement>
<reportElement uuid="8a31f129-b142-4a86-b548-b2adc4891315" x="0" y="72" width="539" height="59"/>
<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="c35e02ed-a532-4a1d-8d69-1d76c196ae35">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="59" width="539">
<textField>
<reportElement uuid="646ad1ca-9403-4f00-88cf-3375a205b866" x="0" y="1" width="539" height="50"/>
<textElement textAlignment="Justified" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[" Dalam hal Saudara belum menerima Surat Pemberitahuan Pajak Terhutang (SPPT) PBB, untuk mendapatkan salinannya dapat menghubungi loket Pelayanan "+$F{nm_kantor}+".\n"+
" Atas perhatian dan kerjasamanya kami sampaikan terima kasih."]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</columnFooter>
</jasperReport>