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

<jasperReport name="reportbb18_rekapitulasi_barang" pageWidth="1023" pageHeight="2500" columnWidth="1023" 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="ftwarehouse_code" 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 `spireportbb18_rekapitulasi_barang`($P{ftwarehouse_code},$P{date_from},$P{date_end})]]>
	</queryString>
	<field name="ftitem_code" class="java.lang.String"/>
	<field name="ftitem_name" class="java.lang.String"/>
	<field name="ftstock_group_code" class="java.lang.String"/>
	<field name="fnsaldo_awal" class="java.lang.Double"/>
	<field name="fnmasuk" class="java.lang.Double"/>
	<field name="fnkeluar" class="java.lang.Double"/>
	<field name="fnsaldo_akhir" class="java.lang.Double"/>
	<field name="fcnet_price" class="java.lang.Double"/>
	<field name="ftwarehouse_code" class="java.lang.String"/>
	<field name="ftlocation_code" class="java.lang.String"/>
	<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="total" class="java.math.BigDecimal" calculation="Sum"/>
	<variable name="ttl_masuk" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{fnmasuk}]]></variableExpression>
	</variable>
	<variable name="ttl_saldo_awal" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{fnsaldo_awal}]]></variableExpression>
	</variable>
	<variable name="ttl_keluar" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{fnkeluar}]]></variableExpression>
	</variable>
	<variable name="ttl_saldo_akhir" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{fnsaldo_akhir}]]></variableExpression>
	</variable>
	<background>
		<band/>
	</background>
	<title>
		<band/>
	</title>
	<pageHeader>
		<band height="72">
			<staticText>
				<reportElement key="staticText-1" x="0" y="0" width="783" height="18"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[LAPORAN REKAPITULASI BARANG]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-2" x="0" y="18" width="172" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12"/>
				</textElement>
				<text><![CDATA[Periode :]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-1" x="172" y="18" width="100" height="18"/>
				<textElement>
					<font fontName="Arial" size="12" isBold="false" isStrikeThrough="false" pdfFontName="Helvetica"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_from}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" x="272" y="18" width="25" height="18"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="12"/>
				</textElement>
				<text><![CDATA[s/d]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-2" x="297" y="18" width="301" height="18"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_end}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-4" x="0" y="54" width="32" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="32" y="54" width="140" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Kode Barang]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="783" y="54" width="60" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Masuk]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="723" y="54" width="60" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Awal]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="843" y="54" width="60" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Keluar]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="598" y="54" width="125" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Nama Group]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="172" y="54" width="426" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Nama Barang]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="903" y="54" width="60" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Akhir]]></text>
			</staticText>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-5" x="783" y="0" width="120" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-6" x="903" y="0" width="60" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-2" x="0" y="36" width="172" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12"/>
				</textElement>
				<text><![CDATA[Gudang :]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="172" y="36" width="426" height="18"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{ftwarehouse_code}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-4" x="963" y="54" width="60" height="18"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Harga]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="20">
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="32" y="0" width="140" height="20"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftitem_code}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="0" y="0" width="32" height="20"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{urut}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="598" y="0" width="125" height="20"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftstock_group_code}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="172" y="0" width="426" height="20"/>
				<textElement>
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftitem_name}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="783" y="0" width="60" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{fnmasuk}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="903" y="0" width="60" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{fnsaldo_akhir}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="843" y="0" width="60" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{fnkeluar}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="723" y="0" width="60" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{fnsaldo_awal}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="963" y="0" width="60" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{fcnet_price}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="36">
			<staticText>
				<reportElement key="staticText-16" x="0" y="0" width="963" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<textField evaluationTime="Report" pattern="EEE, d MMM yyyy HH:mm:ss" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-4" x="783" y="18" width="180" 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 isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="457" y="18" width="326" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isItalic="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{username}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<lastPageFooter>
		<band height="36">
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-7" x="457" y="18" width="326" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isItalic="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{username}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="EEE, d MMM yyyy HH:mm:ss" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-8" x="783" y="18" width="180" 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>
			<staticText>
				<reportElement key="staticText-17" x="0" y="0" width="723" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[ GRAND TOTAL : ]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-9" x="723" y="0" width="60" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{ttl_saldo_awal}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-10" x="783" y="0" width="60" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{ttl_masuk}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-11" x="843" y="0" width="60" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{ttl_keluar}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-12" x="903" y="0" width="60" height="18"/>
				<box>
					<topPen lineWidth="0.5" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="Arial" size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{ttl_saldo_akhir}]]></textFieldExpression>
			</textField>
		</band>
	</lastPageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
