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/DataReferensi-old/

[ Home ]	[ C0mmand ]	[ Upload File ]

Current File : C:/xampp5/htdocs/bhumie/upload/../report/DataReferensi-old/SKZntSismiop_1.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="SKZntSismiop_1" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="92071305-8540-444c-9514-ecfd74b12d69">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="kd_propinsi" class="java.lang.String"/>
	<parameter name="kd_dati2" class="java.lang.String"/>
	<parameter name="kd_kecamatan" class="java.lang.String"/>
	<parameter name="kd_kelurahan" class="java.lang.String"/>
	<parameter name="tahun_pajak" class="java.lang.String"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT DISTINCT B.KD_PROPINSI, B.KD_DATI2, B.KD_KECAMATAN, B.KD_KELURAHAN, B.KD_BLOK, B.JALAN_OP, C.KD_ZNT
FROM pbb.DAT_OBJEK_PAJAK B, pbb.DAT_OP_BUMI C
WHERE ((B.KD_PROPINSI     = $P{kd_propinsi}
  AND B.KD_DATI2                  LIKE $P{kd_dati2}
  AND B.KD_KECAMATAN      LIKE $P{kd_kecamatan}
  AND B.KD_KELURAHAN      LIKE $P{kd_kelurahan}
  AND B.KD_JNS_OP              NOT IN ('7','8'))
  AND (C.KD_PROPINSI          = B.KD_PROPINSI
  AND C.KD_DATI2                  = B.KD_DATI2
  AND C.KD_KECAMATAN      = B.KD_KECAMATAN
  AND C.KD_KELURAHAN      = B.KD_KELURAHAN
  AND C.KD_BLOK                   = B.KD_BLOK
  AND C.NO_URUT                  = B.NO_URUT
  AND C.KD_JNS_OP               = B.KD_JNS_OP))
ORDER BY B.KD_PROPINSI, B.KD_DATI2, B.KD_KECAMATAN, B.KD_KELURAHAN, B.KD_BLOK, B.JALAN_OP, C.KD_ZNT]]>
	</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="kd_blok" class="java.lang.String"/>
	<field name="jalan_op" class="java.lang.String"/>
	<field name="kd_znt" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="17" splitType="Stretch">
			<textField>
				<reportElement uuid="05e52afc-193e-48f2-a3bf-72820b15d379" x="6" y="1" width="29" height="15"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_blok}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="43a70200-42e9-4b54-ad86-1007313a5a23" x="56" y="1" width="117" height="15"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{jalan_op}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="cdeaa5e8-9f56-4e9f-bfa4-df3c119bb5c6" x="194" y="1" width="21" height="15"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_znt}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement uuid="21648ce5-d496-4028-9213-bde61243cc03" x="234" y="1" width="285" height="15"/>
				<subreportParameter name="kd_propinsi">
					<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_dati2">
					<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_kecamatan">
					<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_kelurahan">
					<subreportParameterExpression><![CDATA[$P{kd_kelurahan}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="tahun_pajak">
					<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_znt">
					<subreportParameterExpression><![CDATA[$F{kd_znt}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR"/>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA["SKZntSismiop_2.jasper"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
</jasperReport>

AnonSec - 2021