|
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/DHR/ |
| [ 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="test" language="groovy" pageWidth="992" pageHeight="842" columnWidth="952" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b85dc825-aea0-4fe3-b022-2c6c8cfeeae8">
<property name="ireport.zoom" value="0.8264462809917363"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="v_nop_awal2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="v_nop_akhir2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT A.KD_PROPINSI,A.KD_DATI2,A.KD_KECAMATAN,A.KD_KELURAHAN,
(A.KD_PROPINSI||' - '||C.NM_PROPINSI) AS NM_PROPINSI,
(A.KD_DATI2||' - '||D.NM_DATI2) AS NM_DATI2,
(A.KD_KECAMATAN||' - '||E.NM_KECAMATAN) AS NM_KECAMATAN,
(A.KD_KELURAHAN||' - '||F.NM_KELURAHAN) AS NM_KELURAHAN,
(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) AS THN_PAJAK,
TO_CHAR(A.TGL_TERBIT_SPPT,'DD/MM/YYYY') AS TGL_TERBIT_SPPT,
TO_CHAR(A.TGL_JATUH_TEMPO_SPPT,'DD/MM/YYYY') AS TGL_JATUH_TEMPO_SPPT,
(A.NM_WP_SPPT) AS NM_WP,
(A.KD_KLS_TANAH) AS KLS_TANAH,
(A.KD_KLS_BNG) AS KLS_BNG,
(A.LUAS_BUMI_SPPT) AS LUAS_TANAH,
(A.LUAS_BNG_SPPT) AS LUAS_BNG,
(A.NJOP_BUMI_SPPT) AS NJOP_TANAH,
(A.NJOP_BNG_SPPT) AS NJOP_BNG,
(A.PBB_YG_HARUS_DIBAYAR_SPPT) AS PBB,
G.NM_LOOKUP_ITEM AS STATUS_SPPT,
B.NM_PEGAWAI
FROM SPPT A,
PEGAWAI B,
REF_PROPINSI C,
REF_DATI2 D,
REF_KECAMATAN E,
REF_KELURAHAN F,
LOOKUP_ITEM G
WHERE A.NIP_PENCETAK_SPPT=B.NIP AND
A.KD_PROPINSI =C.KD_PROPINSI AND
A.KD_PROPINSI =D.KD_PROPINSI AND
A.KD_DATI2 =D.KD_DATI2 AND
A.KD_PROPINSI =E.KD_PROPINSI AND
A.KD_DATI2 =E.KD_DATI2 AND
A.KD_KECAMATAN =E.KD_KECAMATAN AND
A.KD_PROPINSI =F.KD_PROPINSI AND
A.KD_DATI2 =F.KD_DATI2 AND
A.KD_KECAMATAN =F.KD_KECAMATAN AND
A.KD_KELURAHAN =F.KD_KELURAHAN AND
--TO_CHAR(A.STATUS_PEMBAYARAN_SPPT)=G.KD_LOOKUP_ITEM AND
A.STATUS_PEMBAYARAN_SPPT = G.KD_LOOKUP_ITEM AND
G.KD_LOOKUP_GROUP ='02' AND
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||A.NO_URUT||A.KD_JNS_OP BETWEEN $P{v_nop_awal2} AND $P{v_nop_akhir2}]]>
</queryString>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="nm_propinsi" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="thn_pajak" class="java.lang.String"/>
<field name="tgl_terbit_sppt" class="java.lang.String"/>
<field name="tgl_jatuh_tempo_sppt" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="kls_tanah" class="java.lang.String"/>
<field name="kls_bng" class="java.lang.String"/>
<field name="luas_tanah" class="java.lang.Long"/>
<field name="luas_bng" class="java.lang.Long"/>
<field name="njop_tanah" class="java.lang.Long"/>
<field name="njop_bng" class="java.lang.Long"/>
<field name="pbb" class="java.lang.Long"/>
<field name="status_sppt" class="java.lang.String"/>
<field name="nm_pegawai" class="java.lang.String"/>
<title>
<band height="26" splitType="Stretch">
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="389" y="0" width="205" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[DAFTAR PERUBAHAN DATA OBJEK PAJAK]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="142" splitType="Stretch">
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="186" y="21" width="69" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[PROPINSI : :]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="186" y="35" width="69" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[KOTA/KAB :]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="609" y="21" width="84" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[KECAMATAN :]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="609" y="35" width="84" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[KELURAHAN :]]></text>
</staticText>
<textField>
<reportElement uuid="d3772f2c-940a-4cc3-ba75-48b9248d7be8" x="255" y="35" width="81" height="14"/>
<textElement>
<font fontName="Comic Sans MS"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d3772f2c-940a-4cc3-ba75-48b9248d7be8" x="693" y="21" width="91" height="14"/>
<textElement>
<font fontName="Comic Sans MS"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d3772f2c-940a-4cc3-ba75-48b9248d7be8" x="693" y="35" width="91" height="14"/>
<textElement>
<font fontName="Comic Sans MS"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="186" y="54" width="69" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS"/>
</textElement>
<text><![CDATA[NOP :]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="0" y="101" width="44" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[THN PJK]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="44" y="101" width="51" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[TGL SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="95" y="101" width="70" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[JTH TEMPO]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="165" y="101" width="119" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[NAMA WAJIB PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="284" y="101" width="105" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[KLS]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="284" y="115" width="52" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[TNH ]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="389" y="101" width="116" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[LUAS]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="389" y="115" width="54" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[TNH]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="505" y="101" width="135" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[NJOP]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="336" y="115" width="53" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="443" y="115" width="62" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="564" y="115" width="76" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="505" y="115" width="59" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[TNH]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="640" y="101" width="122" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[KETETAPAN ]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="640" y="115" width="122" height="14"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="762" y="101" width="121" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[STATUS BAYAR]]></text>
</staticText>
<staticText>
<reportElement uuid="d0c24b08-afa1-409f-8cad-9e01a8a4b79c" x="883" y="101" width="69" height="28"/>
<textElement textAlignment="Center">
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<text><![CDATA[PENCETAK]]></text>
</staticText>
<textField>
<reportElement uuid="d3772f2c-940a-4cc3-ba75-48b9248d7be8" x="255" y="54" width="65" height="14"/>
<textElement>
<font fontName="Comic Sans MS"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="9c09f63f-ad1f-4aaf-b1ce-8c473d5af0d9" x="-1" y="78" width="953" height="13"/>
<textElement/>
<text><![CDATA[=====================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="9c09f63f-ad1f-4aaf-b1ce-8c473d5af0d9" x="0" y="129" width="952" height="13"/>
<textElement/>
<text><![CDATA[=====================================================================================================================================================================]]></text>
</staticText>
<textField>
<reportElement uuid="d3772f2c-940a-4cc3-ba75-48b9248d7be8" x="255" y="21" width="81" height="14"/>
<textElement>
<font fontName="Comic Sans MS"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_propinsi}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="696d3f60-2b19-42ca-bd09-43e637266872" x="0" y="0" width="44" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="44" y="0" width="51" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_terbit_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="95" y="0" width="70" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_jatuh_tempo_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="165" y="0" width="119" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="284" y="0" width="52" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{kls_tanah}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="336" y="0" width="53" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{kls_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="389" y="0" width="54" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_tanah}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="443" y="0" width="62" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="505" y="0" width="59" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_tanah}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="564" y="0" width="76" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="640" y="0" width="122" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{pbb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="761" y="0" width="122" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{status_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="832eaad3-2c7c-4d81-8646-d890ce5e6e09" x="883" y="0" width="69" height="15"/>
<textElement>
<font fontName="Comic Sans MS" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="172"/>
</columnFooter>
</jasperReport>