|
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/SKKeberatan/ |
| [ 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="SKKeberatan_1" language="groovy" pageWidth="595" pageHeight="1704" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="70" bottomMargin="20" uuid="0f783632-f067-4239-9b17-91f1debbc854">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="186"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA["C:\\xampp\\htdocs\\bhumie\\report\\SKKeberatan\\"]]></defaultValueExpression>
</parameter>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT ALL SK_SK.KD_KANWIL, SK_SK.KD_KANTOR, SK_SK.NO_SK, SK_SK.TGL_SK, SK_SK.NO_BA_KANTOR,
SK_SK.TGL_BA_KANTOR,
SK_SK.NO_BA_LAPANGAN, SK_SK.TGL_BA_LAPANGAN, KEPUTUSAN_KEBERATAN_PBB.THN_PELAYANAN,
KEPUTUSAN_KEBERATAN_PBB.BUNDEL_PELAYANAN, KEPUTUSAN_KEBERATAN_PBB.NO_URUT_PELAYANAN,
KEPUTUSAN_KEBERATAN_PBB.KD_PROPINSI_PEMOHON, KEPUTUSAN_KEBERATAN_PBB.KD_DATI2_PEMOHON,
KEPUTUSAN_KEBERATAN_PBB.KD_KECAMATAN_PEMOHON, KEPUTUSAN_KEBERATAN_PBB.KD_KELURAHAN_PEMOHON,
KEPUTUSAN_KEBERATAN_PBB.KD_BLOK_PEMOHON, KEPUTUSAN_KEBERATAN_PBB.NO_URUT_PEMOHON,
KEPUTUSAN_KEBERATAN_PBB.KD_JNS_OP_PEMOHON,
KEPUTUSAN_KEBERATAN_PBB.JNS_KEPUTUSAN, KEPUTUSAN_KEBERATAN_PBB.LUAS_BUMI_SK_KEBERATAN,
KEPUTUSAN_KEBERATAN_PBB.LUAS_BNG_SK_KEBERATAN, KEPUTUSAN_KEBERATAN_PBB.NJOP_BUMI_SK_KEBERATAN,
KEPUTUSAN_KEBERATAN_PBB.NJOP_BNG_SK_KEBERATAN,
KEPUTUSAN_KEBERATAN_PBB.PBB_SK_KEBERATAN, PST_DETAIL.THN_PAJAK_PERMOHONAN,
SPPT.LUAS_BUMI_SPPT, SPPT.LUAS_BNG_SPPT, SPPT.NJOP_BUMI_SPPT, SPPT.NJOP_BNG_SPPT,
SPPT.PBB_TERHUTANG_SPPT, SPPT.PBB_YG_HARUS_DIBAYAR_SPPT
FROM pbb.SK_SK, pbb.KEPUTUSAN_KEBERATAN_PBB, pbb.PST_DETAIL, pbb.SPPT
WHERE ((KEPUTUSAN_KEBERATAN_PBB.NO_SK = SK_SK.NO_SK
AND KEPUTUSAN_KEBERATAN_PBB.JNS_SK = SK_SK.JNS_SK
AND KEPUTUSAN_KEBERATAN_PBB.KD_KANTOR = SK_SK.KD_KANTOR
AND KEPUTUSAN_KEBERATAN_PBB.KD_KANWIL = SK_SK.KD_KANWIL)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_JNS_OP_PEMOHON = PST_DETAIL.KD_JNS_OP_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.NO_URUT_PEMOHON = PST_DETAIL.NO_URUT_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.KD_BLOK_PEMOHON = PST_DETAIL.KD_BLOK_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.KD_KELURAHAN_PEMOHON = PST_DETAIL.KD_KELURAHAN_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.KD_KECAMATAN_PEMOHON = PST_DETAIL.KD_KECAMATAN_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.KD_DATI2_PEMOHON = PST_DETAIL.KD_DATI2_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.KD_PROPINSI_PEMOHON = PST_DETAIL.KD_PROPINSI_PEMOHON
AND KEPUTUSAN_KEBERATAN_PBB.NO_URUT_PELAYANAN = PST_DETAIL.NO_URUT_PELAYANAN
AND KEPUTUSAN_KEBERATAN_PBB.BUNDEL_PELAYANAN = PST_DETAIL.BUNDEL_PELAYANAN
AND KEPUTUSAN_KEBERATAN_PBB.THN_PELAYANAN = PST_DETAIL.THN_PELAYANAN
AND KEPUTUSAN_KEBERATAN_PBB.KD_KANTOR = PST_DETAIL.KD_KANTOR
AND KEPUTUSAN_KEBERATAN_PBB.KD_KANWIL = PST_DETAIL.KD_KANWIL)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_PROPINSI_PEMOHON = SPPT.KD_PROPINSI)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_DATI2_PEMOHON = SPPT.KD_DATI2)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_KECAMATAN_PEMOHON = SPPT.KD_KECAMATAN)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_KELURAHAN_PEMOHON = SPPT.KD_KELURAHAN)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_BLOK_PEMOHON = SPPT.KD_BLOK)
AND (KEPUTUSAN_KEBERATAN_PBB.NO_URUT_PEMOHON = SPPT.NO_URUT)
AND (KEPUTUSAN_KEBERATAN_PBB.KD_JNS_OP_PEMOHON = SPPT.KD_JNS_OP)
AND (PST_DETAIL.THN_PAJAK_PERMOHONAN = SPPT.THN_PAJAK_SPPT))]]>
</queryString>
<field name="kd_kanwil" class="java.lang.String"/>
<field name="kd_kantor" class="java.lang.String"/>
<field name="no_sk" class="java.lang.String"/>
<field name="tgl_sk" class="java.sql.Timestamp"/>
<field name="no_ba_kantor" class="java.lang.String"/>
<field name="tgl_ba_kantor" class="java.sql.Timestamp"/>
<field name="no_ba_lapangan" class="java.lang.String"/>
<field name="tgl_ba_lapangan" class="java.sql.Timestamp"/>
<field name="thn_pelayanan" class="java.lang.String"/>
<field name="bundel_pelayanan" class="java.lang.String"/>
<field name="no_urut_pelayanan" class="java.lang.String"/>
<field name="kd_propinsi_pemohon" class="java.lang.String"/>
<field name="kd_dati2_pemohon" class="java.lang.String"/>
<field name="kd_kecamatan_pemohon" class="java.lang.String"/>
<field name="kd_kelurahan_pemohon" class="java.lang.String"/>
<field name="kd_blok_pemohon" class="java.lang.String"/>
<field name="no_urut_pemohon" class="java.lang.String"/>
<field name="kd_jns_op_pemohon" class="java.lang.String"/>
<field name="jns_keputusan" class="java.lang.String"/>
<field name="luas_bumi_sk_keberatan" class="java.lang.Long"/>
<field name="luas_bng_sk_keberatan" class="java.lang.Long"/>
<field name="njop_bumi_sk_keberatan" class="java.lang.Long"/>
<field name="njop_bng_sk_keberatan" class="java.lang.Long"/>
<field name="pbb_sk_keberatan" class="java.lang.Long"/>
<field name="thn_pajak_permohonan" class="java.lang.String"/>
<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="pbb_terhutang_sppt" class="java.lang.Long"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.lang.Long"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="1319" splitType="Stretch">
<line>
<reportElement uuid="22f3693f-a461-4739-a14b-bbe9dafa8c77" x="11" y="66" width="531" height="1"/>
</line>
<subreport>
<reportElement uuid="2600d91c-1ff6-4744-b83b-e12163f90e1a" x="31" y="4" width="493" height="19"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_Kop1.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="69e79064-65d9-4a92-9168-da002dde6004" x="31" y="22" width="493" height="20"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_Kop2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="d3d60989-df59-45d7-b1a4-8c05857f20d7" x="31" y="41" width="493" height="18"/>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_cpkantor.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="a28b58e1-1959-43ad-97f6-af9c87e9079c" x="31" y="81" width="493" height="16"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_cpkop2.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="d366e0ef-9c8f-410b-b7b8-4148250c62c3" x="31" y="96" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["NOMOR : KEP "+$F{no_sk}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="357e9d02-823b-41f9-8cc0-6dc2fb7a0280" x="31" y="122" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[TENTANG]]></text>
</staticText>
<staticText>
<reportElement uuid="357e9d02-823b-41f9-8cc0-6dc2fb7a0280" x="31" y="135" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[PENYELESAIAN KEBERATAN]]></text>
</staticText>
<staticText>
<reportElement uuid="357e9d02-823b-41f9-8cc0-6dc2fb7a0280" x="31" y="148" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[ATAS SPPT/SKP PAJAK BUMI DAN BANGUNAN]]></text>
</staticText>
<subreport>
<reportElement uuid="b8e89ae5-6696-474e-a587-a7a2fa2ab549" x="0" y="179" width="555" height="441"/>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pelayanan">
<subreportParameterExpression><![CDATA[$F{thn_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="bundel_pelayanan">
<subreportParameterExpression><![CDATA[$F{bundel_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut_pelayanan">
<subreportParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="propinsi_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="dati2_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kecamatan_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kelurahan_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut_pemohon">
<subreportParameterExpression><![CDATA[$F{no_urut_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jenis_op_pemohon">
<subreportParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="SUBREPORT_DIR"/>
<subreportParameter name="no_ba">
<subreportParameterExpression><![CDATA[$F{no_ba_lapangan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tgl_ba">
<subreportParameterExpression><![CDATA[$F{tgl_ba_lapangan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="jns_keputusan">
<subreportParameterExpression><![CDATA[$F{jns_keputusan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_permohonan">
<subreportParameterExpression><![CDATA[$F{thn_pajak_permohonan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_memperhatikan.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="357e9d02-823b-41f9-8cc0-6dc2fb7a0280" x="31" y="706" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="false"/>
</textElement>
<text><![CDATA[Pasal 2]]></text>
</staticText>
<textField>
<reportElement uuid="0d5c333f-51ee-42aa-8f1d-60adf5c36be4" x="95" y="729" width="427" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Jumlah pajak terutang yang harus dibayar Rp. "+new java.text.DecimalFormat("#,##0").format($F{pbb_terhutang_sppt}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="efd47c8a-12c3-4090-b1b4-8987830a17f1" x="95" y="782" width="429" height="26"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Apabila dikemudian hari ternyata terdapat kekeliruan dalam Keputusan ini maka akan dibetulkan sebagaimana mestinya."]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="357e9d02-823b-41f9-8cc0-6dc2fb7a0280" x="31" y="760" width="493" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="false"/>
</textElement>
<text><![CDATA[Pasal 2]]></text>
</staticText>
<textField>
<reportElement uuid="e69ff294-cfc1-4451-bac0-2abe507f1822" x="257" y="844" width="98" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Ditetapkan di :"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="072a8518-b702-4e81-b109-ce9e01e8431a" x="257" y="857" width="98" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Pada tanggal :"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6980b20d-e6bd-48fa-88fa-2828b066c062" x="355" y="858" width="163" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_sk}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="29fe66d0-fbea-48ee-b842-e71d1e54324e" x="355" y="845" width="205" height="13"/>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_kota.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="e69ff294-cfc1-4451-bac0-2abe507f1822" x="257" y="889" width="98" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Kepala Dinas"]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="36052cae-d5bd-4f2d-8a81-b7d47bcf108d" x="257" y="960" width="261" height="29"/>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_kadis.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="cdf9e3c9-47bf-4406-a346-e6cadaacb91e" x="5" y="1228" width="420" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tembusan Surat Keputusan ini disampaikan kepada Yth.]]></text>
</staticText>
<subreport>
<reportElement uuid="c19ad257-e1dd-48cf-9ff9-d181f8bf876a" x="5" y="1243" width="550" height="71"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKKeberatan_Tembusan.jasper"]]></subreportExpression>
</subreport>
</band>
</pageHeader>
</jasperReport>