|
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/PemekaranWilayah/ |
| [ 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="GabungBLok" language="groovy" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="104b5021-8449-47c5-b59e-03df67670108">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="558"/>
<property name="ireport.y" value="82"/>
<parameter name="queryParam" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT
row_number() OVER () AS rownum,
(A.KD_PROPINSI||'.'|| A.KD_DATI2||'.'|| A.KD_KECAMATAN||'.'|| A.KD_KELURAHAN||'.'|| A.KD_BLOK||'-'|| A.NO_URUT||'.'|| A.KD_JNS_OP) AS NOP_BARU,
TO_CHAR(A.TGL_PERUBAHAN_NOP, 'DD/MM/YYYY') AS TGL_PERUBAHAN,
(A.KD_PROPINSI_ASAL||'.'|| A.KD_DATI2_ASAL||'.'||A.KD_KECAMATAN_ASAL||'.'|| A.KD_KELURAHAN_ASAL||'.'||A.KD_BLOK_ASAL||'-'|| A.NO_URUT_ASAL||'.'|| A.KD_JNS_OP_ASAL) AS NOP_LAMA ,
A.NIP_PERUBAH_NOP,
A.STATUS_PERUBAHAN_NOP,
C.KD_ZNT,
D.NIR
FROM PERUBAHAN_NOP A
INNER JOIN DAT_OP_BUMI B ON
(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)
INNER JOIN DAT_PETA_ZNT C ON
(B.KD_ZNT = C.KD_ZNT
AND B.KD_BLOK = C.KD_BLOK
AND B.KD_KELURAHAN = C.KD_KELURAHAN
AND B.KD_KECAMATAN = C.KD_KECAMATAN
AND B.KD_DATI2 = C.KD_DATI2
AND B.KD_PROPINSI = C.KD_PROPINSI)
INNER JOIN DAT_NIR D ON
(C.KD_PROPINSI = D.KD_PROPINSI
AND C.KD_DATI2 = D.KD_DATI2
AND C.KD_KECAMATAN = D.KD_KECAMATAN
AND C.KD_KELURAHAN = D.KD_KELURAHAN
AND C.KD_ZNT = D.KD_ZNT
AND D.THN_NIR_ZNT = date_part('year', NOW())::text) WHERE 1=1 AND $P!{queryParam}]]>
</queryString>
<field name="rownum" class="java.lang.Long"/>
<field name="nop_baru" class="java.lang.String"/>
<field name="tgl_perubahan" class="java.lang.String"/>
<field name="nop_lama" class="java.lang.String"/>
<field name="nip_perubah_nop" class="java.lang.String"/>
<field name="status_perubahan_nop" class="java.lang.Integer"/>
<field name="kd_znt" class="java.lang.String"/>
<field name="nir" class="java.lang.Double"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="108" splitType="Stretch">
<staticText>
<reportElement uuid="4fc7549b-570a-4c19-9e2c-8ed1881778f9" x="0" y="6" width="572" height="25"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DAFTAR PERUBAHAN NOP
HASIL PEMEKARAN WILAYAH]]></text>
</staticText>
<line>
<reportElement uuid="7d190457-7e5b-4da8-bd90-8d3ddb362b33" x="0" y="65" width="572" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="7d190457-7e5b-4da8-bd90-8d3ddb362b33" x="0" y="68" width="572" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="e37901e0-b5d9-474b-9c0b-648eade1dab6" x="7" y="71" width="75" height="24"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMOR]]></text>
</staticText>
<staticText>
<reportElement uuid="e37901e0-b5d9-474b-9c0b-648eade1dab6" x="98" y="71" width="154" height="24"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP LAMA]]></text>
</staticText>
<staticText>
<reportElement uuid="e37901e0-b5d9-474b-9c0b-648eade1dab6" x="267" y="72" width="154" height="24"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP BARU]]></text>
</staticText>
<staticText>
<reportElement uuid="e37901e0-b5d9-474b-9c0b-648eade1dab6" x="498" y="71" width="66" height="24"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NIR BARU]]></text>
</staticText>
<staticText>
<reportElement uuid="362d97b2-58c1-4669-b928-09320056ad67" x="435" y="71" width="51" height="24"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ZNT
BARU]]></text>
</staticText>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="0" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="89" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="259" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="428" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="492" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d6515a87-f486-4463-8448-1d1188df68b2" x="571" y="71" width="1" height="26"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="7d190457-7e5b-4da8-bd90-8d3ddb362b33" x="0" y="100" width="572" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</pageHeader>
<detail>
<band height="16" splitType="Stretch">
<textField>
<reportElement uuid="80a1b211-7460-4954-af2b-469429130ee6" x="7" y="0" width="74" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{rownum}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="856949fa-55c0-42bc-8e8a-4e36c6c1b126" x="98" y="0" width="154" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop_lama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9a6ea6b9-6f74-4538-a580-b60ea6453bd2" x="267" y="0" width="154" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop_baru}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="57d3fcc5-b55e-4025-955a-eb004a0ff9db" x="499" y="1" width="66" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nir}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="957af8c0-f457-4bb5-a1b1-b7b488c4f838" x="435" y="1" width="51" height="14"/>
<textElement>
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_znt}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="50">
<line>
<reportElement uuid="a57ca1d3-c6d2-4a36-b13e-beca9e8bc334" x="0" y="11" width="572" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="a57ca1d3-c6d2-4a36-b13e-beca9e8bc334" x="0" y="13" width="572" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</pageFooter>
</jasperReport>