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/report/test/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : C:/xampp5/htdocs/bhumie/report/test/report2.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="report2" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="dccdb401-4d4c-4842-bf4a-7e4cd7c95bf6">
	<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>
	<pageHeader>
		<band height="35" splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="125" splitType="Stretch">
			<textField>
				<reportElement uuid="06e85813-3089-4952-8643-474579347630" x="124" y="15" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="379c227f-6c26-4c7e-8cba-017ef7ba8df1" x="19" y="15" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<text><![CDATA[kode]]></text>
			</staticText>
			<textField>
				<reportElement uuid="41eebc71-6317-4656-b81a-213f344ae6f5" x="124" y="43" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_resource}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="df707047-5fa1-429d-9d27-98a57fc42dd6" x="19" y="43" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<text><![CDATA[nm_resource]]></text>
			</staticText>
			<textField>
				<reportElement uuid="137bfd5d-a846-42b7-914f-61eef449a1a1" x="124" y="74" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{satuan_resource}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="60066f6c-4f1b-4c97-b6e4-e8e8940a277a" x="19" y="74" width="100" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<text><![CDATA[satuan_resource]]></text>
			</staticText>
		</band>
	</detail>
</jasperReport>

AnonSec - 2021