AnonSec Team

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 ]
Current File : C:/xampp5/htdocs/bhumie/upload/../report/PemekaranWilayah/PindahNop.jrxml
<?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="PindahNop" 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="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<subDataset name="dataset1" uuid="eeeefde8-9d83-4ef9-b2a4-cde7b90c8209">
		<queryString>
			<![CDATA[select nm_kantor from ref_kantor
where kd_kanwil = '01'
and kd_kantor = '01']]>
		</queryString>
		<field name="nm_kantor" class="java.lang.String"/>
	</subDataset>
	<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_blok" class="java.lang.String"/>
	<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>
			<componentElement>
				<reportElement uuid="9d87e616-540c-4e2d-9382-1969d6b24850" x="0" y="31" width="572" height="14"/>
				<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
					<datasetRun subDataset="dataset1" uuid="61925311-3d81-460a-9540-05eb5ed09048">
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="14" width="572">
						<textField>
							<reportElement uuid="436e4ee2-5c28-4c15-8428-d682fea80630" x="0" y="2" width="572" height="12"/>
							<textElement textAlignment="Center">
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
		</band>
	</pageHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<textField>
				<reportElement uuid="0a72e0e6-8a06-41c0-ae26-37d3333c8fd1" x="7" y="2" width="75" height="13"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{rownum}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b76321eb-81d8-4605-b85a-eb75834f3a21" x="98" y="1" width="154" height="14"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nop_lama}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b76321eb-81d8-4605-b85a-eb75834f3a21" x="267" y="1" width="154" height="14"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nop_baru}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="3e4a1f9a-c7cd-409f-81d8-08e47679ae77" x="435" y="2" width="51" height="13"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_znt}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="7f3e72a7-af1c-4b22-9852-79f0d83a2f27" x="498" y="1" width="66" height="14"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nir}]]></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>
			<staticText>
				<reportElement uuid="3c2f97ba-762f-452b-9178-285404df7848" x="0" y="26" width="572" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[Hal.]]></text>
			</staticText>
			<textField>
				<reportElement uuid="417fae49-6b0f-4b12-88c6-88b55d90b94e" x="297" y="26" width="45" height="18"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
AnonSec - 2021