<?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="HargaResource" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="cec79a55-a31e-4af1-9563-d49c6e889da6">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="kd_propinsi" class="java.lang.String"/>
	<parameter name="kd_dati2" class="java.lang.String"/>
	<parameter name="thn_resource" class="java.lang.String"/>
	<queryString>
		<![CDATA[select 	HRG_RESOURCE,
        a.kd_group_resource group_res,
	a.kd_group_resource||a.kd_resource kode,
	b.nm_resource,
	b.satuan_resource,
	c.nm_group_resource,
	d.nm_dati2,
'DAFTAR HARGA BAHAN DAN UPAH TENAGA KERJA'  judul_res,
'DAFTAR BIAYA KOMPONEN BANGUNAN NON STANDAR' judul_ns,
'DAFTAR HARGA FASILITAS BANGUNAN' judul_fas
FROM 	pbb.hrg_resource a,
	pbb.item_resource b,
	pbb.group_resource c,
	pbb.ref_dati2 d,
	pbb.ref_propinsi e
WHERE	a.kd_propinsi = d.kd_propinsi AND
	a.kd_dati2 = d.kd_dati2 AND
	a.kd_propinsi = e.kd_propinsi AND
	d.kd_propinsi = e.kd_propinsi AND
	a.kd_group_resource = b.kd_group_resource AND
	a.kd_group_resource = c.kd_group_resource AND
	a.kd_resource = b.kd_resource AND
	b.kd_group_resource = c.kd_group_resource AND
	a.kd_propinsi = $P{kd_propinsi} AND
	a.kd_dati2 = $P{kd_dati2} AND
	a.thn_hrg_resource = $P{thn_resource} AND
                a.kd_group_resource < '12'

ORDER BY a.kd_group_resource,a.kd_resource]]>
	</queryString>
	<field name="hrg_resource" class="java.lang.Double"/>
	<field name="group_res" class="java.lang.String"/>
	<field name="kode" class="java.lang.String"/>
	<field name="nm_resource" class="java.lang.String"/>
	<field name="satuan_resource" class="java.lang.String"/>
	<field name="nm_group_resource" class="java.lang.String"/>
	<field name="nm_dati2" class="java.lang.String"/>
	<field name="judul_res" class="java.lang.String"/>
	<field name="judul_ns" class="java.lang.String"/>
	<field name="judul_fas" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="81" splitType="Stretch">
			<textField>
				<reportElement uuid="ff031766-efdd-484b-a297-582eeaeecac7" x="22" y="14" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{kd_propinsi}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="fe624bd4-b605-4e1a-abcc-8154867774c0" x="142" y="14" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{kd_dati2}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="61" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="126" splitType="Stretch">
			<textField>
				<reportElement uuid="5157a574-759a-4c2b-9026-c28ea5e95d95" x="128" y="14" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="93467511-8ec9-4927-bf1c-15bbc03e5709" x="13" y="14" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[kode]]></text>
			</staticText>
			<textField>
				<reportElement uuid="4b44beb6-b028-4d24-9e3e-9df172ccacaf" x="128" y="50" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_resource}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="dbdb95ac-2bcc-4cee-b8f6-3c0fb3bd136e" x="13" y="50" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[nm_resource]]></text>
			</staticText>
			<textField>
				<reportElement uuid="f0b63854-49bf-41be-bd05-1ffc06fe16a3" x="128" y="81" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{satuan_resource}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="91e15d6d-0a03-4fcc-916f-df05598c87b3" x="13" y="81" width="100" height="20"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<text><![CDATA[satuan_resource]]></text>
			</staticText>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>