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/KelurahanReport.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" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f8152524-c9a1-44a8-9958-3e825ad75350">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<subDataset name="dataset1" uuid="2d9c1733-0536-48c7-8bfe-ca58b44a6a03">
		<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="thn_spt_masal" class="java.lang.String"/>
		<queryString>
			<![CDATA[select
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_KELURAHAN B, pbb.tempat_pembayaran_sppt_masal c, pbb.tempat_pembayaran d
WHERE
C.KD_TP = D.KD_TP AND
B.KD_KECAMATAN = C.KD_KECAMATAN AND
B.KD_KELURAHAN = C.KD_KELURAHAN AND
B.KD_PROPINSI = $P{kd_propinsi} AND
B.KD_DATI2 = $P{kd_dati2} AND
B.KD_KECAMATAN = $P{kd_kecamatan} AND
c.THN_TP_SPPT_MASAL = $P{thn_spt_masal}
order by KD_KELURAHAN]]>
		</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_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"/>
	</subDataset>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["C:\\xampp\\htdocs\\sip-pbb\\report\\DataReferensi\\"]]></defaultValueExpression>
	</parameter>
	<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="thn_spt_masal" class="java.lang.String"/>
	<queryString>
		<![CDATA[select b.kd_kantor, b.nm_kantor, c.kd_kanwil, c.nm_kanwil,d.nm_kecamatan from pbb.ref_adm_kantor a, pbb.ref_kantor b, pbb.ref_kanwil c, pbb.ref_kecamatan d
where
a.kd_kanwil = c.kd_kanwil AND
a.kd_kantor = b.kd_kantor AND
(a.kd_propinsi=d.kd_propinsi and
a.kd_dati2=d.kd_dati2
) AND
a.kd_propinsi = $P{kd_propinsi} AND
a.kd_dati2 = $P{kd_dati2} AND
d.kd_kecamatan=$P{kd_kecamatan}]]>
	</queryString>
	<field name="kd_kantor" class="java.lang.String"/>
	<field name="nm_kantor" class="java.lang.String"/>
	<field name="kd_kanwil" class="java.lang.String"/>
	<field name="nm_kanwil" class="java.lang.String"/>
	<field name="nm_kecamatan" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="63" splitType="Stretch">
			<staticText>
				<reportElement uuid="59aa8b8f-06bc-4889-a5a2-cd96bc2305d7" x="192" y="29" width="156" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<text><![CDATA[TABEL KELURAHAN]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="144">
			<staticText>
				<reportElement uuid="ca5d3340-7892-4e23-af30-622b429513fe" x="34" y="3" width="13" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<text><![CDATA[-]]></text>
			</staticText>
			<textField>
				<reportElement uuid="c79e4e75-8f4e-4fe2-89ef-90c8d1523f47" x="47" y="3" width="407" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_kanwil}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="ca5d3340-7892-4e23-af30-622b429513fe" x="34" y="19" width="13" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="10"/>
				</textElement>
				<text><![CDATA[-]]></text>
			</staticText>
			<textField>
				<reportElement uuid="98048d2a-7f1b-4a08-b9c2-d22fea329005" x="47" y="19" width="407" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_kantor}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="21" y="97" width="507" height="12"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[-------------------------------------------------------------------------------------]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="51cc836f-0a6e-4c65-853e-cb26466488c7" x="20" y="129" width="507" height="12"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[-------------------------------------------------------------------------------------]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="72" y="107" width="69" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KD SISTEP/]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="23" y="107" width="46" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KD KEL]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="150" y="106" width="69" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KD SEKTOR]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="72" y="117" width="69" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KD TP]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="226" y="105" width="133" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[NAMA KELURAHAN]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="226" y="119" width="159" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[NAMA TEMPAT PEMBAYARAN]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="90b91897-e049-4040-a999-9bbc7e058722" x="463" y="106" width="62" height="13"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KODE POS]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="770b1a79-5146-44b6-a4bb-284ad26cbcf4" x="21" y="35" width="65" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[PROPINSI ]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="3e04a991-7864-498b-aa99-4230ddc56cb3" x="21" y="51" width="65" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KAB/KODYA]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="c2ebd0b4-b79a-4329-8a6a-db54060e34ef" x="21" y="67" width="65" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[KECAMATAN]]></text>
			</staticText>
			<textField>
				<reportElement uuid="52135d16-9d9d-42c7-a76a-94589ad0abf6" x="21" y="4" width="13" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_kanwil}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="f414a650-5a0a-4418-8868-2c8c2672aa7f" x="21" y="19" width="13" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_kantor}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement uuid="bba46946-6f73-4c35-836e-1b089c4f04b8" x="86" y="35" width="200" height="16"/>
				<subreportParameter name="kd_propinsi">
					<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_1.jasper"]]></subreportExpression>
			</subreport>
			<subreport>
				<reportElement uuid="209ba300-76d8-4e12-8bfe-8380b7dbafca" x="86" y="67" width="200" height="16"/>
				<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>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_3.jasper"]]></subreportExpression>
			</subreport>
			<subreport>
				<reportElement uuid="0180f96a-024b-465f-bbd5-e51e2e9b7ac3" x="86" y="51" width="200" height="16"/>
				<subreportParameter name="kd_propinsi">
					<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_dati2">
					<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "KelurahanReport_2.jasper"]]></subreportExpression>
			</subreport>
		</band>
	</pageHeader>
	<detail>
		<band height="38">
			<componentElement>
				<reportElement uuid="84914eaf-a741-43e5-9f1a-7746a9b3d99f" x="18" y="1" width="508" height="36"/>
				<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="6e13c14b-1794-475d-a602-718ffd637d94">
						<datasetParameter name="kd_propinsi">
							<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_dati2">
							<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_kecamatan">
							<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="thn_spt_masal">
							<datasetParameterExpression><![CDATA[$P{thn_spt_masal}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="36" width="508">
						<textField isBlankWhenNull="true">
							<reportElement uuid="c1af1ff9-d5f9-4032-b8b9-55dcbe8a3fe9" x="445" y="3" width="60" height="20"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{kd_pos}]]></textFieldExpression>
						</textField>
						<textField>
							<reportElement uuid="3a19d3a3-1603-43c8-8b8d-e30377d4fdae" x="132" y="3" 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="52" y="3" 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="210" y="3" width="208" height="14"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
						</textField>
						<textField>
							<reportElement uuid="669c11c8-5df2-4c19-ae28-039ae2507dae" x="5" y="3" width="22" height="14"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{kd_kelurahan}]]></textFieldExpression>
						</textField>
						<textField>
							<reportElement uuid="30a151e7-b221-4fa5-b110-fd62ca55691c" x="211" y="17" width="207" height="17"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{nm_tp}]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
		</band>
	</detail>
</jasperReport>
AnonSec - 2021