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/report/SKKepalaDaerah/../

[ Home ]	[ C0mmand ]	[ Upload File ]

Current File : C:/xampp5/htdocs/bhumie/report/SKKepalaDaerah/../KelurahanReport_4.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="KelurahanReport_4" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="124e6aef-6863-4c2b-8bc3-4cbc841afed7">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="KD_KANWIL" class="java.lang.String"/>
	<parameter name="KD_KANTOR" class="java.lang.String"/>
	<parameter name="thn_spt_masal" class="java.lang.String"/>
	<parameter name="kd_propinsi" class="java.lang.String"/>
	<parameter name="kd_dati2" class="java.lang.String"/>
	<parameter name="kd_kecamatan" class="java.lang.String"/>
	<queryString>
		<![CDATA[select
A.KD_KANWIL, A.KD_KANTOR, B.KD_PROPINSI, B.KD_DATI2, B.KD_KECAMATAN, B.KD_KELURAHAN,
B.KD_SEKTOR, B.NM_KELURAHAN, B.KD_POS_KELURAHAN AS KD_POS, c.kd_tp, c.thn_tp_sppt_masal, d.nm_tp
FROM pbb.REF_ADM_KANTOR A, pbb.REF_KELURAHAN B, pbb.tempat_pembayaran_sppt_masal c, pbb.tempat_pembayaran d
WHERE
A.KD_PROPINSI = B.KD_PROPINSI AND
A.KD_DATI2 = B.KD_DATI2 AND
A.KD_KECAMATAN = B.KD_KECAMATAN AND
A.KD_PROPINSI = C.KD_PROPINSI AND
A.KD_DATI2 = C.KD_DATI2 AND
A.KD_KECAMATAN = C.KD_KECAMATAN AND
A.KD_KANWIL = C.KD_KANWIL AND
A.KD_KANTOR = C.KD_KANTOR AND
C.KD_KANWIL = D.KD_KANWIL AND
C.KD_KANTOR = D.KD_KANTOR AND
C.KD_TP = D.KD_TP AND
B.KD_KELURAHAN = C.KD_KELURAHAN AND
A.KD_KANWIL LIKE $P{KD_KANWIL}  AND
A.KD_KANTOR LIKE $P{KD_KANTOR} AND
A.KD_PROPINSI LIKE $P{kd_propinsi}  AND
A.KD_KECAMATAN = $P{kd_kecamatan} AND
A.KD_DATI2 LIKE $P{kd_dati2}
AND c.thn_tp_sppt_masal = $P{thn_spt_masal}
order by KD_KELURAHAN]]>
	</queryString>
	<field name="kd_kanwil" class="java.lang.String"/>
	<field name="kd_kantor" class="java.lang.String"/>
	<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_sektor" class="java.lang.String"/>
	<field name="nm_kelurahan" class="java.lang.String"/>
	<field name="kd_pos" class="java.lang.String"/>
	<field name="kd_tp" class="java.lang.String"/>
	<field name="thn_tp_sppt_masal" class="java.lang.String"/>
	<field name="nm_tp" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="34" splitType="Stretch">
			<textField>
				<reportElement uuid="669c11c8-5df2-4c19-ae28-039ae2507dae" x="2" y="0" width="22" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_kelurahan}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="3a19d3a3-1603-43c8-8b8d-e30377d4fdae" x="129" y="0" width="34" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_sektor}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="eb6b7ea2-2e96-4b2b-9bac-d9c1973b7d06" x="49" y="0" width="32" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_tp}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8876011b-6b83-4fe2-9c33-e1724f7748a3" x="207" y="0" width="208" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="30a151e7-b221-4fa5-b110-fd62ca55691c" x="208" y="14" width="207" height="17"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_tp}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="c1af1ff9-d5f9-4032-b8b9-55dcbe8a3fe9" x="580" y="0" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_pos}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>

AnonSec - 2021