|
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/CetakTunggal/ |
| [ 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="CetakTunggal" language="groovy" pageWidth="595" pageHeight="842" columnWidth="573" leftMargin="11" rightMargin="11" topMargin="56" bottomMargin="11" uuid="cdb3fb24-f103-4043-8047-fcaf73d843e1">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="d6c14566-7f4f-4e40-a0de-6d3cf35d20c9"/>
<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"/>
<parameter name="no_surat" class="java.lang.String"/>
<parameter name="thn_pajak" class="java.lang.String"/>
<parameter name="tglBlnThn" 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 NOP,
a.THN_PAJAK_SPPT, a.KD_KANWIL,a.KD_KANTOR,
a.TGL_PEMBAYARAN_SPPT, a.JML_SPPT_YG_DIBAYAR,
b.NM_WP_SPPT,
coalesce(c.JALAN_OP,'')||' '||coalesce(c.BLOK_KAV_NO_OP,'') AL_OP, c.RW_OP, RT_OP,
d.NM_TP,f.nm_kanwil,e.nm_kantor,e.AL_KANTOR,e.no_telpon,e.no_faksimili,
(select no_srt_seksi from pbb.ref_seksi where kd_seksi = '50') no_srt_seksi,
g.nip_pegawai,h.nama_pegawai,
date_part('year', NOW())::text tahun
from pbb.pembayaran_sppt a, pbb.sppt b, pbb.dat_objek_pajak c, pbb.tempat_pembayaran d,
(select kd_kantor,upper(nm_KANTOR) nm_kantor,AL_KANTOR,no_telpon,no_faksimili from pbb.ref_kantor) e,
(select kd_kanwil, nm_kanwil from pbb.ref_kanwil) f,
(select nip nip_pegawai, kd_kantor, kd_kanwil
from pbb.posisi_pegawai
where
kd_jabatan = '10') g,
(select nip nip_pegawai,nm_pegawai nama_pegawai from pbb.pegawai) h
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.THN_PAJAK_SPPT = $P{thn_pajak}
and 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
and b.KD_PROPINSI = c.KD_PROPINSI
and b.KD_DATI2 = c.KD_DATI2
and b.KD_KECAMATAN = c.KD_KECAMATAN
and b.KD_KELURAHAN = c.KD_KELURAHAN
and b.KD_BLOK = c.KD_BLOK
and b.NO_URUT = c.NO_URUT
and b.KD_JNS_OP = c.KD_JNS_OP
and a.KD_KANWIL = d.KD_KANWIL
and a.KD_KANTOR = d.KD_KANTOR
and a.KD_TP = d.KD_TP
and e.kd_kantor = a.kd_kantor
and f.kd_kanwil = a.kd_kanwil
and g.kd_kantor = a.kd_kantor
and g.kd_kanwil = a.kd_kanwil
and h.nip_pegawai = g.nip_pegawai]]>
</queryString>
<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="tgl_pembayaran_sppt" class="java.sql.Timestamp"/>
<field name="jml_sppt_yg_dibayar" class="java.lang.Long"/>
<field name="nm_wp_sppt" class="java.lang.String"/>
<field name="al_op" class="java.lang.String"/>
<field name="rw_op" class="java.lang.String"/>
<field name="rt_op" class="java.lang.String"/>
<field name="nm_tp" class="java.lang.String"/>
<field name="nm_kanwil" class="java.lang.String"/>
<field name="nm_kantor" class="java.lang.String"/>
<field name="al_kantor" class="java.lang.String"/>
<field name="no_telpon" class="java.lang.String"/>
<field name="no_faksimili" class="java.lang.String"/>
<field name="no_srt_seksi" class="java.lang.String"/>
<field name="nip_pegawai" class="java.lang.String"/>
<field name="nama_pegawai" class="java.lang.String"/>
<field name="tahun" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="755" splitType="Stretch">
<staticText>
<reportElement uuid="c9309534-621f-43dc-9f3b-80375920592d" x="20" y="80" width="52" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nomor :]]></text>
</staticText>
<line>
<reportElement uuid="87671746-23d8-4fb0-b859-aaea2c82d77b" x="20" y="70" width="551" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="87671746-23d8-4fb0-b859-aaea2c82d77b" x="20" y="67" width="551" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="8a9ea8aa-04d2-478c-a56b-65e2f8a582bb" x="226" y="39" width="55" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[, TELP]]></text>
</staticText>
<textField>
<reportElement uuid="05667a70-dcdf-40d1-8a05-50be9fc73a1f" x="89" y="39" width="138" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{al_kantor}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ad209224-8523-4920-aa92-52c489a93fa8" x="388" y="39" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_faksimili}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="eac10a96-5620-49c4-966b-2844f31aa5e6" x="270" y="39" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_telpon}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="e7ee4656-8a60-480d-a271-4444db4283e5" x="358" y="39" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[FAX]]></text>
</staticText>
<textField>
<reportElement uuid="dc9cc2b3-c138-427e-b7f0-6827bf38b7ee" x="0" y="25" width="571" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9f1802f4-f4af-4229-bdeb-fdb717e1e0de" x="0" y="8" width="571" height="17"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kanwil}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="3053eeb4-7b3e-45a7-ad35-db26cdfac6e2" x="20" y="131" width="150" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Yth. Bpk/ibu/saudara/i ]]></text>
</staticText>
<textField>
<reportElement uuid="8edf2aac-139e-41cd-b9cd-15a90c32fcbb" x="166" y="131" width="100" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="841fc85d-a5d4-4d17-ac4a-73b0d07fb01c" x="56" y="146" width="38" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Di]]></text>
</staticText>
<staticText>
<reportElement uuid="95e10bf8-e6d9-40e1-a8b6-ac9f29885583" x="72" y="161" width="41" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tempat]]></text>
</staticText>
<staticText>
<reportElement uuid="ef6d7d5e-bba8-436e-816d-88ca57e47a37" x="40" y="203" width="531" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Berdasarkan hasil pemeriksaan basisdata PBB, wajib pajak dengan data sebagai berikut :]]></text>
</staticText>
<staticText>
<reportElement uuid="e030532f-36f7-48b3-ac90-42a8fa55fdd4" x="40" y="236" width="152" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Wajib Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="e030532f-36f7-48b3-ac90-42a8fa55fdd4" x="40" y="255" width="152" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nomor Objek Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="e030532f-36f7-48b3-ac90-42a8fa55fdd4" x="40" y="274" width="152" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Letak Objek Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="e030532f-36f7-48b3-ac90-42a8fa55fdd4" x="40" y="293" width="152" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tanggal Dibayar :]]></text>
</staticText>
<staticText>
<reportElement uuid="e030532f-36f7-48b3-ac90-42a8fa55fdd4" x="40" y="312" width="152" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[PBB Dibayar :]]></text>
</staticText>
<textField>
<reportElement uuid="c7c098ba-ff74-4d2b-978c-1ab5d69b67d1" x="193" y="236" width="100" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="682edd69-d501-4df7-893c-9a85b652a36c" x="193" y="255" width="378" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="312449ec-6c78-4d7b-a865-22355d5f4464" x="192" y="274" width="100" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{al_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="da4cd745-e661-4080-8b95-d8ccb7b6f93b" x="193" y="293" width="24" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd").format(new Integer($F{tgl_pembayaran_sppt}.getDate()))]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0afcf049-bed0-43b4-aba0-db75ce062c9e" x="212" y="293" width="51" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_pembayaran_sppt}.getMonth() == 0 ?
"Januari" : $F{tgl_pembayaran_sppt}.getMonth() == 1 ?
"Februari" : $F{tgl_pembayaran_sppt}.getMonth() == 2 ?
"Maret" : $F{tgl_pembayaran_sppt}.getMonth() == 3 ?
"April" : $F{tgl_pembayaran_sppt}.getMonth() == 4 ?
"Mei" : $F{tgl_pembayaran_sppt}.getMonth() == 5 ?
"Juni" : $F{tgl_pembayaran_sppt}.getMonth() == 6 ?
"Juli" : $F{tgl_pembayaran_sppt}.getMonth() == 7 ?
"Agustus" : $F{tgl_pembayaran_sppt}.getMonth() == 8 ?
"September" : $F{tgl_pembayaran_sppt}.getMonth() == 9 ?
"Oktober" : $F{tgl_pembayaran_sppt}.getMonth() == 10 ?
"November" : $F{tgl_pembayaran_sppt}.getMonth() == 11 ?
"Desember" : "Unknown"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="da4cd745-e661-4080-8b95-d8ccb7b6f93b" x="264" y="293" width="29" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("yyyy").format($F{tgl_pembayaran_sppt})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a2bb9984-9169-460f-88ab-5062039e2c85" x="435" y="79" width="136" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{tglBlnThn}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3834110f-5a19-47cc-9117-fda0d5afddfd" x="215" y="312" width="100" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt_yg_dibayar})+' ,-']]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="15de5301-0a02-4aae-9b5c-a59a8abdae48" x="20" y="387" width="551" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[dinyatakan TELAH MEMBAYAR PBB TERUTANG tahun melalui]]></text>
</staticText>
<textField>
<reportElement uuid="3f2bfb93-7b35-4e30-be9e-3f67da76224d" x="287" y="387" width="39" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3ab4db00-ee06-41c0-93e2-7ad6c20b19f4" x="364" y="387" width="207" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_tp}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="652202d1-a096-424e-a178-c9dd8b28c1b9" x="20" y="412" width="551" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Demikian atas partisipasi Saudara dalam melunasi PBB diucapkan terima kasih]]></text>
</staticText>
<staticText>
<reportElement uuid="3fb87e52-6895-4e8e-b682-b30aa37cc06f" x="410" y="545" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kepala Kantor]]></text>
</staticText>
<staticText>
<reportElement uuid="bf0cdfbe-ab3d-48c2-9ef4-c6c5a19f651c" x="193" y="312" width="23" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Rp.]]></text>
</staticText>
<textField>
<reportElement uuid="5ae2eb3f-c3b4-467c-a0e3-910c8110150a" x="389" y="618" width="153" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_pegawai}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cf7b2aa7-c508-477c-a6bb-3f365336be2e" x="389" y="638" width="153" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip_pegawai}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="9fb314c9-1b61-4a9a-b6a5-11f7d6f25a0e" x="20" y="92" width="281" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Hal : Surat Keterangan Pembayaran PBB]]></text>
</staticText>
<textField>
<reportElement uuid="656336f7-c6ac-44d1-9c81-14686c246dc5" x="69" y="80" width="292" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{no_surat}.replace("^", "/")]]></textFieldExpression>
</textField>
</band>
</pageHeader>
</jasperReport>