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/SKKepalaDaerah/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : C:/xampp5/htdocs/bhumie/upload/../report/SKKepalaDaerah/SKOpIndividu_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="SKOpIndividu_1" language="groovy" pageWidth="7200" pageHeight="595" orientation="Landscape" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="3a811050-3f4a-48b1-9af7-33a60791eb5f">
	<property name="ireport.zoom" value="3.0"/>
	<property name="ireport.x" value="2687"/>
	<property name="ireport.y" value="0"/>
	<subDataset name="dataset1" uuid="414cbffa-da4b-4c8e-8e0e-4444524ed293">
		<parameter name="tahun_pajak" class="java.lang.String"/>
		<parameter name="njop_tnh_m2" class="java.math.BigDecimal">
			<defaultValueExpression><![CDATA[]]></defaultValueExpression>
		</parameter>
		<queryString>
			<![CDATA[select vlc_kd_kelas from penentuan_kelas(1, $P{tahun_pajak}, $P{njop_tnh_m2})]]>
		</queryString>
		<field name="vlc_kd_kelas" class="java.lang.String"/>
	</subDataset>
	<subDataset name="dataset2" uuid="aec28f4e-6e56-4158-a8b0-3e0ea78a75ca">
		<parameter name="tahun_pajak" class="java.lang.String"/>
		<parameter name="njop_bng_m2" class="java.math.BigDecimal">
			<defaultValueExpression><![CDATA[]]></defaultValueExpression>
		</parameter>
		<queryString>
			<![CDATA[select vlc_kd_kelas from penentuan_kelas(2, $P{tahun_pajak}, $P{njop_bng_m2})]]>
		</queryString>
		<field name="vlc_kd_kelas" class="java.lang.String"/>
	</subDataset>
	<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 row_number() over() as rownum,D.KD_KANWIL, D.KD_KANTOR, A.KD_PROPINSI,
A.KD_DATI2,
A.KD_KECAMATAN,
A.KD_KELURAHAN,
A.KD_BLOK,
A.NO_URUT,
A.KD_JNS_OP,
coalesce(A.JALAN_OP||' '||A.BLOK_KAV_NO_OP,'') ALAMAT,
coalesce(A.RT_OP ||'/'|| A.RW_OP,'') RTRW,
A.SUBJEK_PAJAK_ID,
A.TOTAL_LUAS_BUMI,
A.TOTAL_LUAS_BNG,
(A.NJOP_BUMI/1000) NJOP_BUMI,
(A.NJOP_BNG/1000) NJOP_BNG,
C.KD_ZNT,
case when (A.NJOP_BUMI/1000) is not null OR (A.NJOP_BUMI/1000) <> 0 then
 case when A.TOTAL_LUAS_BUMI = '0' then ROUND(((A.NJOP_BUMI/1000) *1000)/1, 0) else ROUND(((A.NJOP_BUMI/1000) *1000)/A.TOTAL_LUAS_BUMI , 0) end
else
 '0'
end
as NJOP_TNH_M2,
case when (A.NJOP_BNG/1000) is not null OR (A.NJOP_BNG/1000) <> 0 then
 case when A.TOTAL_LUAS_BNG = '0' then ROUND(((A.NJOP_BNG/1000) *1000)/1, 0) else ROUND(((A.NJOP_BNG/1000) *1000)/A.TOTAL_LUAS_BNG , 0) end
else
 '0'
end
as NJOP_BNG_M2
FROM pbb.DAT_OBJEK_PAJAK A, pbb.DAT_NILAI_INDIVIDU B,
pbb.DAT_OP_BUMI C, pbb.REF_ADM_KANTOR D
WHERE  ( A.KD_PROPINSI     =   $P{kd_propinsi}  AND
A.KD_DATI2    =   $P{kd_dati2}      AND
A.KD_KECAMATAN like $P{kd_kecamatan} AND
A.KD_KELURAHAN like  $P{kd_kelurahan}) AND
(D.KD_PROPINSI = $P{kd_propinsi} AND
D.KD_DATI2      = $P{kd_dati2} AND
D.KD_KECAMATAN      like $P{kd_kecamatan} ) AND
(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 AND
A.KD_JNS_OP != '8' AND
A.KD_JNS_OP != '9') 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 rownum asc]]>
	</queryString>
	<field name="rownum" class="java.lang.Long"/>
	<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_blok" class="java.lang.String"/>
	<field name="no_urut" class="java.lang.String"/>
	<field name="kd_jns_op" class="java.lang.String"/>
	<field name="alamat" class="java.lang.String"/>
	<field name="rtrw" class="java.lang.String"/>
	<field name="subjek_pajak_id" class="java.lang.String"/>
	<field name="total_luas_bumi" class="java.lang.Long"/>
	<field name="total_luas_bng" class="java.lang.Long"/>
	<field name="njop_bumi" class="java.lang.Long"/>
	<field name="njop_bng" class="java.lang.Long"/>
	<field name="kd_znt" class="java.lang.String"/>
	<field name="njop_tnh_m2" class="java.math.BigDecimal"/>
	<field name="njop_bng_m2" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="37" splitType="Stretch">
			<textField>
				<reportElement uuid="734cee3a-d4eb-4133-bc2e-7e9fe1c9316a" x="61" y="1" width="20" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_dati2}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b0b4104c-a721-4419-925a-ae0df059aa32" x="153" y="1" width="33" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{no_urut}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="3180fbf3-b210-4dbd-b7fe-e6bece4edec4" x="185" y="1" width="23" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_jns_op}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="32c43cfe-102a-4f1e-9688-1cffefccc28e" x="398" y="1" width="43" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{rtrw}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="1abd453f-62e8-4d54-9eff-4d50d55c96c6" x="427" y="1" width="66" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_luas_bumi}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="c057758f-0829-4cca-98b6-b2dc590283ab" x="501" y="1" width="66" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total_luas_bng}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="24d52e78-4891-478d-aada-971a0627b712" x="578" y="1" width="33" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_znt}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="4d50bc9d-49e7-41e4-95c9-ba2c9b3eee83" x="41" y="1" width="20" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_propinsi}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="5a740fb2-e8d1-4b5c-9db2-d1b76a8f1640" x="81" y="1" width="25" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_kecamatan}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="592fe84b-8d3c-47d3-aa7e-cd8673219d6e" x="105" y="1" width="25" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_kelurahan}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="1bb774ce-1a1f-4292-b150-062ad98199c8" x="129" y="1" width="25" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kd_blok}+"."]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement uuid="c365230c-cb8e-47b6-9009-e25742d082bb" x="221" y="1" width="133" height="16"/>
				<subreportParameter name="subjek_pajak_id">
					<subreportParameterExpression><![CDATA[$F{subjek_pajak_id}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKOpIndividu_2.jasper"]]></subreportExpression>
			</subreport>
			<textField>
				<reportElement uuid="bc4b2061-e699-44dd-8899-b2abf4e7c3ef" x="221" y="17" width="100" height="17"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{alamat}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="95eb73bf-5fce-4485-a762-bfe20c5291b1" x="885" y="1" width="76" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_bumi}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8c94ab32-8150-413f-99d9-3b6fa090bf54" x="973" y="1" width="70" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_bng}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement uuid="26df3bdc-3986-4435-9d80-5adf3eeb2ea2" x="426" y="17" width="729" height="17"/>
				<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="kd_blok">
					<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="no_urut">
					<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="kd_jenis_op">
					<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "SKOpIndividu_4.jasper"]]></subreportExpression>
			</subreport>
			<textField>
				<reportElement uuid="9b4b90a5-0bac-4eb2-95a6-ca8d22006745" x="5" y="1" width="19" height="16"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{rownum}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="95eb73bf-5fce-4485-a762-bfe20c5291b1" x="705" y="1" width="76" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_tnh_m2}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8c94ab32-8150-413f-99d9-3b6fa090bf54" x="806" y="1" width="70" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_bng_m2}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<componentElement>
				<reportElement uuid="94f2b8b4-a71f-4271-b8bd-e02d3f550266" x="628" y="0" width="31" height="17"/>
				<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="77357cad-4ed7-49a2-9cbb-1330815b40ed">
						<datasetParameter name="tahun_pajak">
							<datasetParameterExpression><![CDATA[$P{tahun_pajak}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="njop_tnh_m2">
							<datasetParameterExpression><![CDATA[$F{njop_tnh_m2}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="17" width="31">
						<textField>
							<reportElement uuid="18e0f177-a6bf-4621-8627-3bc0b001c5b9" x="0" y="1" width="31" height="16"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{vlc_kd_kelas}]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
			<componentElement>
				<reportElement uuid="78000927-42f5-4b84-b9c5-f9983371a4bb" x="671" y="0" width="32" height="17"/>
				<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="0233b800-55a2-4210-8301-c6c6cb6fa9b3">
						<datasetParameter name="tahun_pajak">
							<datasetParameterExpression><![CDATA[$P{tahun_pajak}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="njop_bng_m2">
							<datasetParameterExpression><![CDATA[$F{njop_bng_m2}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:listContents height="17" width="32">
						<textField>
							<reportElement uuid="4d549ba0-c8ba-409c-a836-9c210c740303" x="0" y="1" width="32" height="16"/>
							<textElement>
								<font fontName="Courier New"/>
							</textElement>
							<textFieldExpression><![CDATA[$F{vlc_kd_kelas}]]></textFieldExpression>
						</textField>
					</jr:listContents>
				</jr:list>
			</componentElement>
			<textField>
				<reportElement uuid="c9059111-a5f4-4bdc-8961-781008c7bbf9" x="1050" y="1" width="71" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_bumi} + $F{njop_bng}).replace(",", ".")]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
AnonSec - 2021