|
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/HargaResource/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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="1ce5502f-7ae1-449f-a332-974890b77b54">
<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"/>
<group name="DetailGroup">
<groupExpression><![CDATA[$F{group_res}]]></groupExpression>
<groupHeader>
<band height="1"/>
</groupHeader>
<groupFooter>
<band height="9">
<break>
<reportElement uuid="3866d920-beab-44bb-b10a-ec1a4f3778dd" isPrintRepeatedValues="false" x="0" y="4" width="100" height="1"/>
</break>
</band>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="131">
<textField evaluationTime="Page" isBlankWhenNull="true">
<reportElement uuid="8c2392a2-259c-4523-94a7-cbe58bed8034" isPrintRepeatedValues="false" x="123" y="68" width="156" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_group_resource}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e30319a7-ec54-4d1a-9c96-67f176116714" x="142" y="56" width="112" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_dati2}]]></textFieldExpression>
</textField>
<textField evaluationTime="Page">
<reportElement uuid="08b60d60-cb1a-4135-8ffc-317b02c50374" x="94" y="68" width="18" height="13" printWhenGroupChanges="DetailGroup"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{group_res}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="efbe35d6-6e6b-4a1e-b014-d5b44abeed5b" x="94" y="56" width="18" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_propinsi}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="e250805c-4269-4578-9aa0-54e35c9f7314" x="423" y="3" width="120" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NO DOKUMEN :]]></text>
</staticText>
<staticText>
<reportElement uuid="781817e4-38ac-4e13-bf99-99dcc2823cb9" x="9" y="68" width="85" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JENIS BAHAN :]]></text>
</staticText>
<staticText>
<reportElement uuid="67901c35-a338-49f3-91a4-65410ec216f6" x="3" y="31" width="552" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DAFTAR HARGA BAHAN DAN UPAH TENAGA KERJA]]></text>
</staticText>
<staticText>
<reportElement uuid="fb9e0345-e57d-4409-896d-4123590a00cd" x="129" y="56" width="10" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField>
<reportElement uuid="f6aea201-aa69-43cb-a2a9-b478264f890c" x="112" y="56" width="18" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{kd_dati2}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="6644ec75-cc86-4b2a-870d-81ab6693ccde" x="9" y="56" width="85" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KOTA / KAB :]]></text>
</staticText>
<staticText>
<reportElement uuid="fb9e0345-e57d-4409-896d-4123590a00cd" x="111" y="68" width="10" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<staticText>
<reportElement uuid="6644ec75-cc86-4b2a-870d-81ab6693ccde" x="394" y="56" width="79" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[HAL :]]></text>
</staticText>
<staticText>
<reportElement uuid="6644ec75-cc86-4b2a-870d-81ab6693ccde" x="394" y="68" width="79" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TAHUN PAJAK :]]></text>
</staticText>
<textField>
<reportElement uuid="5b52e70b-1a18-41f1-b2e0-ad3863dd5cbe" x="473" y="56" width="27" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="322ca132-ef0d-48af-bf4b-0b8547f5c8e4" x="473" y="68" width="39" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{thn_resource}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="4ee594b9-f37c-48ef-899a-5d9af0a71cb6" x="9" y="89" width="534" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[========================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="9" y="98" width="42" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kode]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="91" y="98" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Bahan /]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="91" y="109" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tenaga Kerja]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="350" y="98" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Satuan]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="447" y="98" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Harga]]></text>
</staticText>
<staticText>
<reportElement uuid="1bcb38ea-d70e-4332-9f6e-be7780720ffa" x="447" y="109" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[(Rp.1000)]]></text>
</staticText>
<staticText>
<reportElement uuid="4ee594b9-f37c-48ef-899a-5d9af0a71cb6" x="9" y="119" width="534" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[========================================================================================]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="15" splitType="Stretch">
<textField>
<reportElement uuid="04a3b90c-1bff-4b4b-bd93-9d3ee89b762f" x="9" y="3" width="60" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="16cfb295-1a89-4107-97c6-e3718b5b6e5d" x="91" y="3" width="237" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_resource}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="047b9d72-f9c8-4dec-bc03-01c16311b766" x="350" y="3" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{satuan_resource}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7f808733-78e3-460b-9e93-71b33784d9fb" x="447" y="3" width="65" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{hrg_resource}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>