|
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="R232_SEJARAHOP" language="groovy" pageWidth="850" pageHeight="612" orientation="Landscape" columnWidth="800" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d8c78c1a-3b90-4e88-a6a2-adb0f3e62e03">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="33"/>
<style name="table">
<box>
<topPen lineWidth="1.0" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<topPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<parameter name="propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kota" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok_to" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok_from" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT (A.THN_PAJAK_SPPT) AS TAHUN_PAJAK,(A.KD_PROPINSI||'.'||A.KD_DATI2||'.'||A.KD_KECAMATAN||'.'||A.KD_KELURAHAN||'.'||
A.KD_BLOK||'.'||A.NO_URUT||'.'||A.KD_JNS_OP) AS NOP,
(B.JALAN_OP||' '||'KAV.'||B.BLOK_KAV_NO_OP) AS ALM_OP,
(C.NM_KELURAHAN) AS NM_KELURAHAN,
('RT.'||B.RT_OP||'/'||' RW.'||B.RW_OP) AS RT_RW,
(A.LUAS_BUMI_SPPT||' M2') AS LUAS_TNH,
(A.LUAS_BNG_SPPT||' M2') AS LUAS_BNG,
TO_CHAR(A.TGL_CETAK_SPPT,'DD/MM/YYYY') AS TGL_CETAK,
TO_CHAR(A.TGL_TERBIT_SPPT,'DD/MM/YYYY') AS TGL_TERBIT,
TO_CHAR(A.TGL_JATUH_TEMPO_SPPT,'DD/MM/YYYY') AS TGL_JTH_TEMPO,
(A.NM_WP_SPPT) AS NM_WP,
(A.JLN_WP_SPPT||' '||'KAV. '||A.BLOK_KAV_NO_WP_SPPT||' '||'RT.'||
A.RT_WP_SPPT||'/'||'RW. '||A.RW_WP_SPPT||' '||A.KOTA_WP_SPPT) AS ALM_WP
FROM SPPT A,
DAT_OBJEK_PAJAK B,
REF_KELURAHAN C
WHERE 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.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.KD_PROPINSI = $P{propinsi} and
a.KD_DATI2 = $P{kota} and
a.KD_KECAMATAN = $P{kecamatan} and
a.KD_KELURAHAN = $P{kelurahan} and
a.KD_BLOK||a.NO_URUT||a.KD_JNS_OP BETWEEN $P{kd_blok_from} AND $P{kd_blok_to}]]>
</queryString>
<field name="tahun_pajak" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="alm_op" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="rt_rw" class="java.lang.String"/>
<field name="luas_tnh" class="java.lang.String"/>
<field name="luas_bng" class="java.lang.String"/>
<field name="tgl_cetak" class="java.lang.String"/>
<field name="tgl_terbit" class="java.lang.String"/>
<field name="tgl_jth_tempo" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="alm_wp" class="java.lang.String"/>
<variable name="tgl_cetak_1" class="java.lang.Integer" resetType="Page" calculation="Count">
<variableExpression><![CDATA[$F{tgl_cetak}]]></variableExpression>
</variable>
<variable name="nop_1" class="java.lang.Integer" resetType="Page" calculation="Count">
<variableExpression><![CDATA[$F{nop}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="79" splitType="Stretch">
<staticText>
<reportElement uuid="8ab39822-617b-4d18-b174-f3efd445bfba" positionType="Float" x="279" y="19" width="316" height="46"/>
<textElement>
<font size="16"/>
</textElement>
<text><![CDATA[CATATAN SEJARAH OBJEK PAJAK]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="66" splitType="Stretch">
<frame>
<reportElement uuid="8998455a-9f73-4fac-a830-9ebb43c37825" style="table 1" x="0" y="0" width="138" height="20"/>
<staticText>
<reportElement uuid="12b07153-1080-4e0b-b576-b20e60fc6b4d" style="table" x="5" y="0" width="118" height="20"/>
<textElement/>
<text><![CDATA[NOMOR OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="491bb162-88b3-492e-969d-70adbfe9eae6" x="128" y="0" width="10" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<frame>
<reportElement uuid="0bb6e9a8-f8b6-4158-92b2-059736a9448e" style="table 1" x="0" y="20" width="138" height="20"/>
<staticText>
<reportElement uuid="c8d1f51c-d45c-4857-8135-111d4a51e125" x="5" y="0" width="118" height="20"/>
<textElement/>
<text><![CDATA[ALAMAT OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="81791c59-7ac1-4e1d-b569-4ec33e0cd19a" x="128" y="0" width="10" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<frame>
<reportElement uuid="11a55561-2c3a-4caf-9b65-d90cdcdbc08f" style="table 1" x="0" y="40" width="138" height="20"/>
<staticText>
<reportElement uuid="638bd65b-69a4-4e16-bca5-87522f8b1e7f" x="5" y="0" width="118" height="20"/>
<textElement/>
<text><![CDATA[KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="d3ac2c02-4192-4f3c-85f1-1a7674b26d04" x="128" y="0" width="10" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<frame>
<reportElement uuid="6eb8b7d4-957a-49b7-b505-998618501e8f" x="138" y="0" width="200" height="20"/>
<textField>
<reportElement uuid="3586ee44-63f9-4258-8799-8117ce453642" x="10" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
</frame>
<frame>
<reportElement uuid="71a4c0c9-f9b0-4f49-805e-e65d7f6917ed" x="138" y="20" width="200" height="20"/>
<textField>
<reportElement uuid="719c21c3-32ed-4df9-9ac3-a95a1b2824dc" x="10" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{alm_op}]]></textFieldExpression>
</textField>
</frame>
<frame>
<reportElement uuid="e9ce8eb2-52d8-423b-8ddd-e0cc5d4f5368" x="138" y="40" width="200" height="20"/>
<textField>
<reportElement uuid="a7c77711-5a4d-4ae9-885c-ab826f3da725" x="10" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
</frame>
<frame>
<reportElement uuid="f6a616ba-f296-4f45-a50e-f414729c3f43" x="710" y="0" width="100" height="20"/>
<textField>
<reportElement uuid="cb5a4519-4619-4082-a8af-29e9c050f562" x="13" y="0" width="81" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{rt_rw}]]></textFieldExpression>
</textField>
</frame>
<frame>
<reportElement uuid="574cedf2-e633-4c7d-a641-c03cc6ff9596" style="table 1" x="630" y="0" width="80" height="20"/>
<staticText>
<reportElement uuid="58e26856-5ab6-4daf-b84c-354565e39d0b" style="table" x="5" y="0" width="65" height="20"/>
<textElement/>
<text><![CDATA[RT / RW]]></text>
</staticText>
<staticText>
<reportElement uuid="9aa2cd33-cf0a-431a-9699-2671d225fdef" x="75" y="0" width="5" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<frame>
<reportElement uuid="adab763c-e27a-4280-8829-d1bdb209ead4" x="710" y="20" width="100" height="20"/>
</frame>
<frame>
<reportElement uuid="250f02e4-8093-4622-b4c2-6ef14790f2b2" style="table 1" x="630" y="20" width="80" height="20"/>
<staticText>
<reportElement uuid="3519e85c-5cc7-4861-b195-ee98ebd56674" style="table" x="5" y="0" width="65" height="20"/>
<textElement/>
<text><![CDATA[LUAS TANAH]]></text>
</staticText>
<staticText>
<reportElement uuid="42604aff-dd8f-4c84-ac93-73c7c5724f92" x="75" y="0" width="5" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<frame>
<reportElement uuid="73a8d252-d8c8-4b27-8b83-97e52d8790aa" x="710" y="40" width="100" height="20"/>
</frame>
<frame>
<reportElement uuid="d86fcba1-96a2-443c-81cf-5819fa7121b9" style="table 1" x="630" y="40" width="80" height="20"/>
<staticText>
<reportElement uuid="7d33431c-2670-4aa5-9ff4-a7f877916032" style="table" x="5" y="0" width="65" height="20"/>
<textElement/>
<text><![CDATA[LUAS BNG]]></text>
</staticText>
<staticText>
<reportElement uuid="b619b02a-6f58-4137-8259-36677f8edff4" x="75" y="0" width="5" height="20"/>
<textElement/>
<text><![CDATA[:]]></text>
</staticText>
</frame>
<textField>
<reportElement uuid="4560265a-60b9-41b4-b598-47d1355ec00b" x="723" y="20" width="81" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{luas_tnh}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7eb18277-c1fa-4805-9b30-7772b6d187b9" x="723" y="40" width="81" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{luas_bng}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="31" splitType="Stretch">
<staticText>
<reportElement uuid="d14d4bfa-fc74-4d99-b662-ecec597f6c42" x="10" y="9" width="19" height="20"/>
<textElement/>
<text><![CDATA[NO]]></text>
</staticText>
<frame>
<reportElement uuid="05dde52e-1c70-4967-8375-aaa9f0bb95c6" x="29" y="9" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="75704cf6-da4e-4820-81c5-b25c4aa506b5" x="49" y="9" width="40" height="20"/>
<textElement/>
<text><![CDATA[TAHUN]]></text>
</staticText>
<frame>
<reportElement uuid="9bf4fc5d-2f92-4589-a6d8-0c5e35fe6ca2" x="89" y="9" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="55b88519-ed1d-40de-b213-28fbd6c35e2c" x="109" y="10" width="75" height="20"/>
<textElement/>
<text><![CDATA[TGL CETAK]]></text>
</staticText>
<frame>
<reportElement uuid="96dd9814-c6e9-4d4f-9be8-ca386a54612d" x="184" y="10" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="716c0519-c5df-447b-b922-c00a1c600f39" x="204" y="10" width="75" height="20"/>
<textElement/>
<text><![CDATA[TGL TERBIT]]></text>
</staticText>
<staticText>
<reportElement uuid="8921b50b-df1a-4ba9-b80e-a703c39dd7ca" x="299" y="10" width="100" height="20"/>
<textElement/>
<text><![CDATA[TGL JATUH TEMPO]]></text>
</staticText>
<frame>
<reportElement uuid="6a78bb85-5be3-4eee-840d-c505328b4a7d" x="279" y="10" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="85050c22-b718-4526-bd54-d11608d5d78a" x="419" y="10" width="115" height="20"/>
<textElement/>
<text><![CDATA[NOMOR OBJEK PAJAK]]></text>
</staticText>
<frame>
<reportElement uuid="563dfe8a-4af7-4108-93d8-917af7d2bd60" x="399" y="10" width="20" height="20"/>
</frame>
<frame>
<reportElement uuid="1dff0f12-188d-4405-9c81-adbc746e19e2" x="534" y="9" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="03b693bd-a658-4484-b7d4-86cfcb7872c0" x="554" y="10" width="115" height="20"/>
<textElement/>
<text><![CDATA[NAMA WAJIB PAJAK]]></text>
</staticText>
<frame>
<reportElement uuid="71335618-4ba9-40e2-ab75-41af1627e642" x="669" y="10" width="20" height="20"/>
</frame>
<staticText>
<reportElement uuid="74849d73-0f7c-40a0-b8d4-dcd1d1843db4" x="689" y="10" width="115" height="20"/>
<textElement/>
<text><![CDATA[ALAMAT WAJIB PAJAK]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="7dd28009-bce4-43ad-b349-00e65b6646de" x="10" y="0" width="24" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$V{nop_1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="20e68a8f-82af-4f9e-8a91-6b45fe31f2ba" x="419" y="0" width="100" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f0c21d41-af3a-4777-93ea-3f2d2a82a906" x="689" y="0" width="100" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{alm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f38ad6f7-a9cd-415b-a229-70c4a55c2501" x="49" y="0" width="40" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{tahun_pajak}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="73cc0ff3-7fe8-44fb-9b64-7fda526002c9" x="109" y="0" width="80" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_cetak}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="75f679fd-8634-4a88-9874-4d7bc81a19c3" x="204" y="0" width="75" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_terbit}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3fe95fd9-c604-47ce-ac7b-0c8f1238bee2" x="554" y="0" width="100" height="20"/>
<textElement textAlignment="Left">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bb25b123-7d60-4439-8d1d-0ef5ff93c00d" x="299" y="0" width="100" height="20"/>
<textElement textAlignment="Center">
<paragraph lineSpacing="Single" leftIndent="5"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl_jth_tempo}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>