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/LaporanPembayaran/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : C:/xampp5/htdocs/bhumie/upload/../report/LaporanPembayaran/LaporanPembayaran.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="LaporanPembayaran" language="groovy" pageWidth="595" pageHeight="842" columnWidth="519" leftMargin="56" rightMargin="20" topMargin="56" bottomMargin="20" uuid="d4306d5a-1d7c-42cd-9f40-1437b5e5ed01">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="19"/>
	<style name="table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="Table Dataset 1" uuid="90efbf88-2efa-4113-b691-0eda9b20dc1f"/>
	<subDataset name="dataset2" uuid="21d1f71b-fa9b-4563-a235-ebe591b7c0da">
		<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_pajak" class="java.lang.String"/>
		<queryString>
			<![CDATA[select coalesce(sum(jml_sppt_yg_dibayar),0) as jumlah from pembayaran_sppt where kd_propinsi = $P{kd_propinsi} and kd_dati2 = $P{kd_dati2} and kd_kecamatan = $P{kd_kecamatan} and to_char(tgl_pembayaran_sppt, 'YYYY') = $P{thn_pajak}]]>
		</queryString>
		<field name="jumlah" class="java.math.BigDecimal"/>
	</subDataset>
	<subDataset name="dataset1" uuid="cf5f155d-f33d-4905-b822-433d3a6d0515">
		<parameter name="kd_propinsi" class="java.lang.String"/>
		<parameter name="kd_dati2" class="java.lang.String"/>
		<parameter name="thn_pajak" class="java.lang.String"/>
		<queryString>
			<![CDATA[select coalesce(sum(jml_sppt_yg_dibayar),0) as jumlah from pembayaran_sppt where kd_propinsi = $P{kd_propinsi} and kd_dati2 = $P{kd_dati2} and to_char(tgl_pembayaran_sppt, 'YYYY') = $P{thn_pajak}]]>
		</queryString>
		<field name="jumlah" class="java.math.BigDecimal"/>
	</subDataset>
	<parameter name="thn_pajak" class="java.lang.String"/>
	<parameter name="nm_dati2" class="java.lang.String"/>
	<parameter name="DEFA_VALUE" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
i.KD_PROPINSI||'.'||i.KD_DATI2||'.'||i.KD_KECAMATAN||'-'||i.NM_KECAMATAN KODE,
i.KD_PROPINSI, i.KD_DATI2, i.KD_KECAMATAN, i.NM_KECAMATAN
from
pbb.REF_KECAMATAN i]]>
	</queryString>
	<field name="kode" 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="nm_kecamatan" class="java.lang.String"/>
	<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
		<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="123" splitType="Stretch">
			<textField>
				<reportElement uuid="1e49ff0d-d431-4508-a1b4-03dfdc981ca8" x="0" y="0" width="519" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="14" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["LAPORAN PENERIMAAN PBB"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="1e49ff0d-d431-4508-a1b4-03dfdc981ca8" x="0" y="16" width="519" height="14"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["KABUPATEN "+$P{nm_dati2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="1e49ff0d-d431-4508-a1b4-03dfdc981ca8" x="0" y="30" width="519" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["TAHUN "+$P{thn_pajak}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement uuid="85bb9673-21d6-48d9-ace8-30b3ba7cdccd" x="19" y="100" width="440" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="19" y="101" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="63" y="101" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="256" y="101" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement uuid="963c53fa-66d2-452a-b69a-a8f4018a4f86" x="31" y="105" width="15" height="14"/>
				<textElement>
					<font fontName="Courier New" isBold="true"/>
				</textElement>
				<text><![CDATA[No]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="963c53fa-66d2-452a-b69a-a8f4018a4f86" x="76" y="105" width="148" height="14"/>
				<textElement>
					<font fontName="Courier New" isBold="true"/>
				</textElement>
				<text><![CDATA[Nama Kecamatan]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="963c53fa-66d2-452a-b69a-a8f4018a4f86" x="272" y="105" width="148" height="14"/>
				<textElement>
					<font fontName="Courier New" isBold="true"/>
				</textElement>
				<text><![CDATA[Penerimaan PBB]]></text>
			</staticText>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="458" y="101" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="85bb9673-21d6-48d9-ace8-30b3ba7cdccd" x="19" y="122" width="440" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement uuid="5742ee1e-ac97-4dda-a014-4d6826f8664d" x="19" y="81" width="419" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA["Berikut laporan penerimaan PBB tahun "+$P{thn_pajak}+" : "]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="22" splitType="Stretch">
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="19" y="-1" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="63" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="256" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="458" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="85bb9673-21d6-48d9-ace8-30b3ba7cdccd" x="19" y="21" width="440" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement uuid="78efa7d1-1de9-453b-9bcd-6eac237aef23" x="69" y="4" width="169" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
			</textField>
			<componentElement>
				<reportElement uuid="41b6d099-f358-4363-9b19-26e2aeb81b86" x="257" y="2" width="202" height="20"/>
				<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="dataset2" uuid="213dae8b-62c8-49e2-8144-5fc8d7080e33">
						<datasetParameter name="thn_pajak">
							<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_propinsi">
							<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_dati2">
							<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_kecamatan">
							<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="20" width="202">
						<textField>
							<reportElement uuid="3f314d4b-e2f3-452f-a331-7dc7d7c015c8" x="9" y="2" width="186" height="14"/>
							<textElement textAlignment="Right">
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah}).replace(",",".")]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
			<textField>
				<reportElement uuid="5047888e-f760-4391-8844-b80e481d7ec0" x="31" y="4" width="15" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="275" splitType="Stretch">
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="256" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="63" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement uuid="963c53fa-66d2-452a-b69a-a8f4018a4f86" x="76" y="4" width="148" height="14"/>
				<textElement>
					<font fontName="Courier New" isBold="true"/>
				</textElement>
				<text><![CDATA[Total Penerimaan]]></text>
			</staticText>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="19" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="85bb9673-21d6-48d9-ace8-30b3ba7cdccd" x="19" y="21" width="440" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="5d7baa8c-9fa3-4e7d-9a32-2db461b0ea75" x="458" y="0" width="1" height="21"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<componentElement>
				<reportElement uuid="6ae0b04a-de47-4d1d-a62c-1f65c231f366" x="257" y="0" width="201" height="21"/>
				<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="0954ef2e-870d-45e1-979c-6d026bdcc074">
						<datasetParameter name="kd_propinsi">
							<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="kd_dati2">
							<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="thn_pajak">
							<datasetParameterExpression><![CDATA[$P{thn_pajak}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="21" width="201">
						<textField>
							<reportElement uuid="25d34f84-e9b0-4cbc-8df7-c42b3ce8fa49" x="9" y="4" width="186" height="14"/>
							<textElement textAlignment="Right">
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah}).replace(",",".")]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
			<textField>
				<reportElement uuid="40569c86-40ad-4a68-b16d-bce7237e8fb3" x="309" y="73" width="150" height="12"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{nm_dati2}+", "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="40569c86-40ad-4a68-b16d-bce7237e8fb3" x="309" y="139" width="150" height="12"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA["........................"]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
AnonSec - 2021