|
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="Laporan daftar formulir transaksi" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="af22cec9-7839-46aa-931e-9d8b2591486d">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="96"/>
<parameter name="v_PROPINSI" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="v_DATI2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="v_KECAMATAN" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="v_KELURAHAN" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="V_NOP1" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="V_NOP2" 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_BLOK||'.'||A.NO_URUT
||'.'||A.KD_JNS_OP) AS NOP,
(A.JALAN_OP||' '||'KAV.'||A.BLOK_KAV_NO_OP) AS ALAMAT_OP,
B.NM_WP AS NM_WP,
('RT.'||A.RT_OP||'/'||'RW.'||A.RW_OP) AS RT_RW_OP,
C.NM_KELURAHAN AS KELURAHAN,
(A.NO_FORMULIR_SPOP) AS DOKUMEN_OP,
(E.NO_FORMULIR_LSPOP) AS DOKUMEN_BNG,
E.NO_BNG AS NO_BNG,
TO_CHAR(A.TGL_PEREKAMAN_OP,'DD/MM/YYYY') AS TGL_REKAM_OP,
TO_CHAR(E.TGL_PEREKAMAN_BNG,'DD/MM/YYYY') AS TGL_REKAM_BNG,
D.NM_LOOKUP_ITEM AS JNS_TRANSAKSI_OP,
D.NM_LOOKUP_ITEM AS JNS_TRANSAKSI_BNG,
A.NIP_PENDATA AS NIP_PENDATA_OP,
E.NIP_PENDATA_BNG AS NIP_PENDATA_BNG,
A.NIP_PEREKAM_OP AS NIP_PEREKAM_OP,
E.NIP_PEREKAM_BNG AS NIP_PEREKAM_BNG,
COALESCE((A.JALAN_OP||' '||'KAV.'||A.BLOK_KAV_NO_OP||' '||B.NM_WP), B.NM_WP)
AS namaAlamat
FROM DAT_OBJEK_PAJAK A,
DAT_SUBJEK_PAJAK B,
REF_KELURAHAN C,
LOOKUP_ITEM D,
DAT_OP_BANGUNAN E
WHERE A.SUBJEK_PAJAK_ID =B.SUBJEK_PAJAK_ID AND
A.KD_PROPINSI =C.KD_PROPINSI AND
A.KD_DATI2 =C.KD_DATI2 AND
A.KD_KECAMATAN =C.KD_KECAMATAN AND
A.KD_KELURAHAN =C.KD_KELURAHAN AND
A.JNS_TRANSAKSI_OP =D.KD_LOOKUP_ITEM AND
--A.JNS_TRANSAKSI_BNG =D.KD_LOOKUP_ITEM AND
D.KD_LOOKUP_GROUP ='33' AND
A.KD_PROPINSI =E.KD_PROPINSI AND
A.KD_DATI2 =E.KD_DATI2 AND
A.KD_KECAMATAN =E.KD_KECAMATAN AND
A.KD_KELURAHAN =E.KD_KELURAHAN AND
A.KD_BLOK =E.KD_BLOK AND
A.NO_URUT =E.NO_URUT AND
A.KD_JNS_OP =E.KD_JNS_OP AND
a.KD_PROPINSI = $P{v_PROPINSI} and
a.KD_DATI2 = $P{v_DATI2} and
a.KD_KECAMATAN = $P{v_KECAMATAN} and
a.KD_KELURAHAN = $P{v_KELURAHAN} and
a.KD_BLOK||a.NO_URUT||a.KD_JNS_OP BETWEEN $P{V_NOP1} AND $P{V_NOP2}
order by namaAlamat]]>
</queryString>
<field name="nop" class="java.lang.String"/>
<field name="alamat_op" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="rt_rw_op" class="java.lang.String"/>
<field name="kelurahan" class="java.lang.String"/>
<field name="dokumen_op" class="java.lang.String"/>
<field name="dokumen_bng" class="java.lang.String"/>
<field name="no_bng" class="java.lang.Integer"/>
<field name="tgl_rekam_op" class="java.lang.String"/>
<field name="tgl_rekam_bng" class="java.lang.String"/>
<field name="jns_transaksi_op" class="java.lang.String"/>
<field name="jns_transaksi_bng" class="java.lang.String"/>
<field name="nip_pendata_op" class="java.lang.String"/>
<field name="nip_pendata_bng" class="java.lang.String"/>
<field name="nip_perekam_op" class="java.lang.String"/>
<field name="nip_perekam_bng" class="java.lang.String"/>
<field name="namaalamat" class="java.lang.String"/>
<variable name="recordCount" class="java.lang.Long" resetType="Group" resetGroup="namaalamat" calculation="Count">
<variableExpression><![CDATA[$F{dokumen_op}]]></variableExpression>
</variable>
<group name="namaalamat">
<groupExpression><![CDATA[$F{namaalamat}]]></groupExpression>
<groupHeader>
<band height="101">
<textField>
<reportElement uuid="d772b4fe-9bc1-4371-ad64-6d1e27d88910" x="121" y="0" width="199" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="e3422b68-0f0f-47ef-bd29-f43ac75a8d52" x="1" y="0" width="120" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMER OBJEK PAJAK :]]></text>
</staticText>
<textField>
<reportElement uuid="4def62bb-af5c-47e1-b7a1-5f2adb9d148c" x="121" y="20" width="199" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_op} != null ? $F{alamat_op} : ""]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="ad8df794-056d-4225-8bf6-76e48fe76114" x="1" y="20" width="120" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ALAMAT OBJEK PAJAK:]]></text>
</staticText>
<textField>
<reportElement uuid="69d7fc45-6f0f-47a1-875f-fbf043834abc" x="121" y="39" width="199" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="224b325b-8c1f-4f60-bd78-9cec5f0b748a" x="1" y="39" width="120" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA WAJIB PAJAK :]]></text>
</staticText>
<textField>
<reportElement uuid="c88fd757-5ba3-4be3-b0c3-caf5fc6570d3" x="456" y="19" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{rt_rw_op} != null ? $F{rt_rw_op} : "" ]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d74f4a41-aa6b-4bca-a339-6b921e6224bb" x="376" y="20" width="80" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[RT / RW :]]></text>
</staticText>
<textField>
<reportElement uuid="d944b589-56f6-4e51-8f4e-3c864d1ff447" x="456" y="39" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kelurahan} != null ? $F{kelurahan} : ""]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="636b11c0-05fe-4872-97aa-94a544e54675" x="376" y="39" width="80" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KELURAHAN :]]></text>
</staticText>
<line>
<reportElement uuid="d94abfdd-383a-4f80-8d1b-a1eb2e1a938d" x="0" y="65" width="555" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="bce7028b-aa43-41a4-96dd-e9762879e97f" x="0" y="67" width="555" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="9afcb449-426a-4179-a636-4df7a2d2a693" x="1" y="68" width="14" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[NO]]></text>
</staticText>
<line>
<reportElement uuid="0e2897cc-aae8-4b9c-836b-7cb34f9b847b" x="0" y="88" width="555" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="bbbe75fd-28d4-4274-80de-79259aeb0679" x="0" y="90" width="555" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="316fe510-95a7-4c00-8cde-02ca67981891" x="15" y="71" width="55" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[NO DOKUMEN OP]]></text>
</staticText>
<staticText>
<reportElement uuid="ca39d59f-52e0-45f9-b8f9-0c836a9eb308" x="70" y="71" width="64" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[TGL REKAM OP]]></text>
</staticText>
<staticText>
<reportElement uuid="04b61f3f-c8b4-45aa-a97b-3f83c0854071" x="134" y="70" width="74" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[JNS TRANSAKSI OP]]></text>
</staticText>
<staticText>
<reportElement uuid="8ff61545-7e55-46f2-98e4-df28199bf310" x="208" y="70" width="25" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[NO BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="fc87c1d1-543f-4abb-a319-e4582bd924b0" x="233" y="70" width="58" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[NO DOKUMEN BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="93a688dd-9df3-45f3-8e89-0e88ca73ee31" x="291" y="70" width="57" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[TGL REKAM BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="a61ad0d0-3cc6-4ce8-af04-9163153f7581" x="348" y="69" width="70" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[JNS TRANSAKSI BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="858ba476-7178-4a0a-a242-d4832c76b58e" x="418" y="69" width="67" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[PEREKAM]]></text>
</staticText>
<staticText>
<reportElement uuid="967d5a07-7220-42fb-91e8-93b699bd8b1d" x="485" y="70" width="71" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<text><![CDATA[OPERATOR / PENDATA]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band height="31"/>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="80" splitType="Stretch">
<staticText>
<reportElement uuid="2f55a766-85b8-4808-8aa3-8703c7a520fa" x="178" y="31" width="207" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN TRANSAKSI OBJEK PAJAK]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="17" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="61" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="25" splitType="Stretch">
<textField>
<reportElement uuid="4cd8f98a-3452-403d-ab53-3dbeab2adb5f" x="0" y="4" width="15" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{recordCount}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c2f93936-6ab1-457a-9e3a-608050c73e6c" x="15" y="4" width="55" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{dokumen_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6c00369b-8f74-4f58-9cc7-7f87e2e79896" x="70" y="4" width="64" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_rekam_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="15925b25-bf1b-4c49-bb3b-25033f32db4c" x="134" y="4" width="74" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jns_transaksi_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a2cc9751-e61b-4225-b3ff-cf9bfc1eba54" x="208" y="4" width="25" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a97c27d6-0efa-49fa-aec8-d987ae17f352" x="233" y="4" width="58" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{dokumen_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="771a53da-e08e-4661-bd52-ce505fb92a4f" x="291" y="4" width="57" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_rekam_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="aa1b6058-5063-4f31-940a-2baa713ecab2" x="418" y="4" width="67" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip_perekam_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="924ea289-30c0-4cbe-9590-d4ebc7f51de0" x="511" y="4" width="70" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip_pendata_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="49c520e4-6b8e-4ece-8c08-734fc01cc25f" x="511" y="-6" width="70" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip_perekam_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7a146ef5-1552-41b4-af35-a4b1c3eebdda" x="348" y="4" width="70" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jns_transaksi_op}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="21" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="25" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>