<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="reportbb17_stock_awal" pageWidth="963" pageHeight="792" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="963" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="stock_type" class="java.lang.String"/>
	<parameter name="date_from" class="java.util.Date"/>
	<parameter name="date_end" class="java.util.Date"/>
	<parameter name="username" class="java.lang.String"/>
	<queryString>
		<![CDATA[call spireport00_stock_awal($P{stock_type}, $P{date_from}, $P{date_end})]]>
	</queryString>
	<field name="hdr_ftcompany_name" class="java.lang.String"/>
	<field name="hdr_ftstock_in_no" class="java.lang.String"/>
	<field name="hdr_ftcategory_code" class="java.lang.String"/>
	<field name="hdr_fdtrans_date" class="java.sql.Date"/>
	<field name="det_ftitem_code" class="java.lang.String"/>
	<field name="det_ftitem_name" class="java.lang.String"/>
	<field name="det_ftwarehouse_code" class="java.lang.String"/>
	<field name="det_ftwarehouse_name" class="java.lang.String"/>
	<field name="det_ftlocation_code" class="java.lang.String"/>
	<field name="det_ftlocation_name" class="java.lang.String"/>
	<field name="det_fnqty" class="java.lang.Double"/>
	<field name="det_ftuom_code" class="java.lang.String"/>
	<field name="det_fcprice" class="java.math.BigDecimal"/>
	<field name="det_fcprice_x" class="java.lang.String"/>
	<sortField name="det_ftitem_code"/>
	<variable name="urut" class="java.lang.Integer" calculation="Count">
		<variableExpression><![CDATA[new java.lang.Integer(0)]]></variableExpression>
		<initialValueExpression><![CDATA[new java.lang.Integer(1)]]></initialValueExpression>
	</variable>
	<variable name="qty_ttl" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{det_fnqty}]]></variableExpression>
	</variable>
	<variable name="price_ttl" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
		<variableExpression><![CDATA[$F{det_fcprice}]]></variableExpression>
	</variable>
	<background>
		<band/>
	</background>
	<title>
		<band height="1"/>
	</title>
	<pageHeader>
		<band height="95">
			<staticText>
				<reportElement key="staticText-1" x="341" y="4" width="280" height="24"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="18" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Laporan Stock Awal]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-2" x="689" y="38" width="75" height="17"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Periode]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-3" x="764" y="38" width="13" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[:]]></text>
			</staticText>
			<textField pattern="dd MMM yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="777" y="38" width="77" height="17"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_from}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-4" x="854" y="38" width="29" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[s/d]]></text>
			</staticText>
			<textField pattern="dd MMM yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-1" x="883" y="38" width="77" height="17"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_end}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-5" x="0" y="74" width="27" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-6" x="32" y="74" width="85" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Tgl.]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-7" x="122" y="74" width="335" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Nama Barang]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-8" x="463" y="74" width="137" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Gudang]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-9" x="605" y="74" width="137" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Lokasi]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-10" x="747" y="74" width="90" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Qty]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-11" x="842" y="74" width="118" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Harga]]></text>
			</staticText>
			<line>
				<reportElement key="line-1" x="0" y="71" width="963" height="1"/>
			</line>
			<line>
				<reportElement key="line-2" x="0" y="93" width="963" height="1"/>
			</line>
			<staticText>
				<reportElement key="staticText-12" x="1" y="38" width="85" height="17"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Type Stock]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-13" x="86" y="38" width="13" height="17"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-14" x="99" y="38" width="182" height="17"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Bahan Baku]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="18">
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="0" y="1" width="27" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{urut}]]></textFieldExpression>
			</textField>
			<textField pattern="dd MMM yyyy" isBlankWhenNull="true" hyperlinkType="None">
				<reportElement key="textField" x="32" y="1" width="85" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{hdr_fdtrans_date}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true" hyperlinkType="None">
				<reportElement key="textField" x="122" y="0" width="335" height="17"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{det_ftitem_name}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true" hyperlinkType="None">
				<reportElement key="textField" x="463" y="1" width="137" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{det_ftwarehouse_code}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true" hyperlinkType="None">
				<reportElement key="textField" x="605" y="1" width="137" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{det_ftlocation_code}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="747" y="1" width="46" height="16"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{det_fnqty}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="842" y="1" width="118" height="16"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{det_fcprice}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true" hyperlinkType="None">
				<reportElement key="textField" x="795" y="1" width="42" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{det_ftuom_code}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<lastPageFooter>
		<band height="50">
			<line>
				<reportElement key="line-3" x="0" y="2" width="963" height="1"/>
			</line>
			<textField evaluationTime="Report" pattern="EEE, d MMM yyyy HH:mm:ss" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-2" x="755" y="25" width="205" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isItalic="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true" hyperlinkType="None">
				<reportElement x="694" y="3" width="99" height="16"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{qty_ttl}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true" hyperlinkType="None">
				<reportElement x="842" y="3" width="118" height="16"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{price_ttl}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="605" y="3" width="84" height="16"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Total : ]]></text>
			</staticText>
		</band>
	</lastPageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
