<?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_4" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="14a10f28-c731-47ae-8df3-4944629a3e95">
	<property name="ireport.zoom" value="3.0"/>
	<property name="ireport.x" value="1526"/>
	<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="kd_blok" class="java.lang.String"/>
	<parameter name="no_urut" class="java.lang.String"/>
	<parameter name="kd_jenis_op" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
A.LUAS_BUMI_BEBAN as luas_tanah_bersama,
A.LUAS_BNG_BEBAN as luas_bng_bersama,
(A.NJOP_BUMI_BEBAN/1000) as njop_tanah_bersama,
(A.NJOP_BNG_BEBAN/1000) as njop_bng_bersama,
case when A.LUAS_BUMI_BEBAN is not null OR A.LUAS_BUMI_BEBAN <> 0 then
 case when A.LUAS_BUMI_BEBAN = '0' then ROUND(((A.NJOP_BUMI_BEBAN/1000) *1000)/1, 0) else ROUND(((A.NJOP_BUMI_BEBAN/1000) *1000)/A.LUAS_BUMI_BEBAN , 0) end
else
 '0'
end
as NJOP_TNH_BERS_M2,
case when A.LUAS_BNG_BEBAN is not null OR A.LUAS_BNG_BEBAN <> 0 then
 case when A.LUAS_BNG_BEBAN = '0' then ROUND(((A.NJOP_BNG_BEBAN/1000) *1000)/1, 0) else ROUND(((A.NJOP_BNG_BEBAN/1000) *1000)/A.LUAS_BNG_BEBAN , 0) end
else
 '0'
end
as NJOP_BNG_BERS_M2

  FROM pbb.DAT_OP_ANGGOTA A
  WHERE A.KD_PROPINSI = $P{kd_propinsi} AND
				A.KD_DATI2 = $P{kd_dati2} AND
				A.KD_KECAMATAN = $P{kd_kecamatan} AND
				A.KD_KELURAHAN = $P{kd_kelurahan} AND
				A.KD_BLOK = $P{kd_blok} AND
				A.NO_URUT = $P{no_urut} AND
				A.KD_JNS_OP = $P{kd_jenis_op};]]>
	</queryString>
	<field name="luas_tanah_bersama" class="java.lang.Long"/>
	<field name="luas_bng_bersama" class="java.lang.Long"/>
	<field name="njop_tanah_bersama" class="java.lang.Long"/>
	<field name="njop_bng_bersama" class="java.lang.Long"/>
	<field name="njop_tnh_bers_m2" class="java.math.BigDecimal"/>
	<field name="njop_bng_bers_m2" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement uuid="36c14cf0-530f-4045-bc84-5f174b3b7777" x="71" y="8" width="2" height="12"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[|]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="36c14cf0-530f-4045-bc84-5f174b3b7777" x="71" y="0" width="2" height="12"/>
				<textElement textAlignment="Center">
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[|]]></text>
			</staticText>
			<textField>
				<reportElement uuid="adc9f79a-0663-46e2-bfde-fd799e780493" x="3" y="5" width="66" height="11"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{luas_tanah_bersama}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8686c11a-59a2-45d7-9d64-97d7331886f3" x="76" y="5" width="66" height="11"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{luas_bng_bersama}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6fa9c915-8d0d-45d5-8e1b-65ff4e651be6" x="445" y="13" width="76" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{njop_tanah_bersama}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b3235c0f-ba82-44e2-a749-3722bf8b43b1" x="546" y="13" width="70" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{njop_bng_bersama}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement uuid="0e882075-0603-4ab4-aaad-26437e6a0ba5" x="279" y="11" width="82" height="14"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{njop_tnh_bers_m2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="c5a9b3eb-893c-437e-aaa2-d5d35bfa42dc" x="366" y="10" width="83" height="15"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{njop_bng_bers_m2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="1469430b-9905-413d-96d8-b49cfb5514e8" x="621" y="13" width="71" height="12"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{njop_tanah_bersama} + $F{njop_bng_bersama}).replace(",", ".")]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>