|
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/CatatanPembayaran/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="CetakPembayaran" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="babf18ad-ee31-43f9-b4c4-e681217d5733">
<property name="ireport.zoom" value="3.8906136901500026"/>
<property name="ireport.x" value="1226"/>
<property name="ireport.y" value="232"/>
<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 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.njop_sppt, a.njoptkp_sppt,
a.pbb_yg_harus_dibayar_sppt, a.tgl_jatuh_tempo_sppt,
coalesce(b.pembayaran_sppt_ke,0) as pembayaran_sppt_ke, coalesce(b.JML_SPPT_YG_DIBAYAR,0) as jml_sppt_yg_dibayar, b.tgl_pembayaran_sppt,
c.NM_WP, coalesce(c.JALAN_WP,'')||' '||coalesce(c.BLOK_KAV_NO_WP,'') as alamat_wp, coalesce(d.JALAN_OP,'')||' '||coalesce(d.BLOK_KAV_NO_OP,'') as alamat_op
from pbb.sppt a left join pbb.pembayaran_sppt b on
a.kd_propinsi = b.kd_propinsi
and a.kd_dati2 = b.kd_dati2
and a.kd_kecamatan = b.kd_kecamatan
and a.kd_kelurahan = b.kd_kelurahan
and a.kd_blok = b.kd_blok
and a.no_urut = b.no_urut
and a.kd_jns_op = b.kd_jns_op
and a.thn_pajak_sppt = b.thn_pajak_sppt,
pbb.dat_subjek_pajak c, pbb.dat_objek_pajak d
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan = $P{kd_kecamatan}
and a.kd_kelurahan = $P{kd_kelurahan}
and a.kd_blok = $P{kd_blok}
and a.no_urut = $P{no_urut}
and a.kd_jns_op = $P{kd_jns_op}
and a.status_pembayaran_sppt <> '2'
and d.kd_propinsi = a.kd_propinsi
and d.kd_dati2 = a.kd_dati2
and d.kd_kecamatan = a.kd_kecamatan
and d.kd_kelurahan = a.kd_kelurahan
and d.kd_blok = a.kd_blok
and d.no_urut = a.no_urut
and d.kd_jns_op = a.kd_jns_op
and c.subjek_pajak_id = d.subjek_pajak_id
order by a.thn_pajak_sppt]]>
</queryString>
<field name="nop" class="java.lang.String"/>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="njop_sppt" class="java.lang.Long"/>
<field name="njoptkp_sppt" class="java.lang.Integer"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.lang.Long"/>
<field name="tgl_jatuh_tempo_sppt" class="java.sql.Timestamp"/>
<field name="pembayaran_sppt_ke" class="java.lang.Integer"/>
<field name="jml_sppt_yg_dibayar" class="java.lang.Long"/>
<field name="tgl_pembayaran_sppt" class="java.sql.Timestamp"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="alamat_wp" class="java.lang.String"/>
<field name="alamat_op" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="105" splitType="Stretch">
<staticText>
<reportElement uuid="93ecd97f-5f76-4ac2-b9c0-23853341d67f" x="0" y="39" width="126" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat Objek Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="93ecd97f-5f76-4ac2-b9c0-23853341d67f" x="0" y="13" width="126" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Wajib Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="93ecd97f-5f76-4ac2-b9c0-23853341d67f" x="0" y="26" width="126" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat Wajib Pajak :]]></text>
</staticText>
<textField>
<reportElement uuid="d129455f-7236-4c76-a3a4-28c43bbdf16d" x="126" y="0" width="236" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="93ecd97f-5f76-4ac2-b9c0-23853341d67f" x="0" y="0" width="126" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nomor Objek Pajak :]]></text>
</staticText>
<textField>
<reportElement uuid="5ada57c2-7924-4e9f-8e86-5d392792df2b" x="126" y="13" width="236" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7d536dd8-c5ac-4b62-a061-502323bd56a2" x="126" y="26" width="236" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2a8723cd-3e3a-4342-8fd8-0ca3679ca30f" x="126" y="39" width="236" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_op}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="be6a0fa9-154d-421f-a3fd-cac6db19d678" x="5" y="68" width="548" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="10" y="77" width="36" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="6" y="76" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="6" y="85" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="53" y="85" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="53" y="76" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="228" y="85" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="228" y="76" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="70" y="76" width="45" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[N J O P]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="70" y="85" width="85" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[N J O P T K P]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="404" y="76" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="404" y="85" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="241" y="76" width="115" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB Harus Bayar]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="241" y="85" width="115" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tgl Jatuh Tempo]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="529" y="76" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="529" y="85" width="2" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="413" y="76" width="115" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah Pembayaran]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="413" y="85" width="115" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tgl Pembayaran]]></text>
</staticText>
<staticText>
<reportElement uuid="be6a0fa9-154d-421f-a3fd-cac6db19d678" x="4" y="93" width="548" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=========================================================================================]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="25" splitType="Stretch">
<textField isBlankWhenNull="true">
<reportElement uuid="a7a3b1a2-5f41-44df-a62c-a1467aa7fc45" x="411" y="11" width="115" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new BigDecimal(new SimpleDateFormat("dd").format($F{tgl_pembayaran_sppt}))+"/"+new BigDecimal(new SimpleDateFormat("MM").format($F{tgl_pembayaran_sppt}))+"/"+new BigDecimal(new SimpleDateFormat("yyyy").format($F{tgl_pembayaran_sppt}))]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="53" y="0" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="6" y="10" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="5304ef07-1f33-47a5-9c95-e268df55d55e" x="12" y="1" width="38" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="529" y="0" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement uuid="95905ec7-bd72-412f-8809-daa1d96e0ed4" x="264" y="11" width="129" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new BigDecimal(new SimpleDateFormat("dd").format($F{tgl_jatuh_tempo_sppt}))+"/"+new BigDecimal(new SimpleDateFormat("MM").format($F{tgl_jatuh_tempo_sppt}))+"/"+new BigDecimal(new SimpleDateFormat("yyyy").format($F{tgl_jatuh_tempo_sppt}))]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="405" y="0" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="6" y="0" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="53" y="10" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="55fcdb77-b3eb-4e9d-8101-88bba009667a" x="70" y="11" width="150" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{njoptkp_sppt})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2961fe38-51d3-4896-9f6a-1af004d9d787" x="263" y="1" width="130" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt})]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement uuid="79ea8090-9e9c-40e6-8ef7-b2f129836651" x="411" y="1" width="115" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{jml_sppt_yg_dibayar})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="529" y="10" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="228" y="10" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="405" y="10" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="49eea4ef-26c5-4d90-ab56-b1656a3c36ad" x="70" y="1" width="150" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{njop_sppt})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d9f835a5-b41d-43e5-886b-5d42b53e48ce" x="228" y="0" width="1" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="11"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
</band>
</detail>
<summary>
<band height="12" splitType="Stretch">
<staticText>
<reportElement uuid="be6a0fa9-154d-421f-a3fd-cac6db19d678" x="6" y="0" width="548" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[=========================================================================================]]></text>
</staticText>
</band>
</summary>
</jasperReport>