<?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="vw_advance_statement" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="BlankPage" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2a40f9da-50ae-477c-88ab-f61cfadef782">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<style name="Row" mode="Transparent">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#E6DAC3"/>
		</conditionalStyle>
	</style>
	<parameter name="filterid" class="java.lang.String">
		<defaultValueExpression><![CDATA["1"]]></defaultValueExpression>
	</parameter>
	<parameter name="orgwhere" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="organd" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT vw_advance_statement.pay_date, vw_advance_statement.employee_id,
	vw_advance_statement.entity_name,  vw_advance_statement.in_payroll,
	vw_advance_statement.amount, vw_advance_statement.recovery,
	(vw_advance_statement.amount - vw_advance_statement.recovery) as balance

FROM vw_advance_statement

WHERE (vw_advance_statement.entity_id = '$P!{filterid}')

$P!{organd}

ORDER BY vw_advance_statement.pay_date]]>
	</queryString>
	<field name="pay_date" class="java.sql.Date"/>
	<field name="employee_id" class="java.lang.String"/>
	<field name="entity_name" class="java.lang.String"/>
	<field name="in_payroll" class="java.lang.Boolean"/>
	<field name="amount" class="java.lang.Double"/>
	<field name="recovery" class="java.lang.Double"/>
	<field name="balance" class="java.lang.Double"/>
	<variable name="amount_1" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{amount}]]></variableExpression>
	</variable>
	<variable name="recovery_1" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{recovery}]]></variableExpression>
	</variable>
	<variable name="balance_1" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{balance}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="71" splitType="Stretch">
			<staticText>
				<reportElement style="Title" x="66" y="0" width="226" height="62" uuid="50d03d44-5b53-49e5-93d5-c905c7208ad1"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Times New Roman" size="24" pdfFontName="Times-Roman"/>
				</textElement>
				<text><![CDATA[Advance Statement]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement style="Detail" x="292" y="32" width="63" height="15" uuid="591b1971-efb4-4cec-9002-828b21c9342e"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{employee_id}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement style="Detail" x="292" y="47" width="201" height="15" uuid="6d1c8b47-e976-408d-9fd9-dfe56f5d61d8"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{entity_name}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="16" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="15" width="555" height="1" uuid="fefdaf3e-be06-4dd1-bde2-43d6134d0074"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement style="Column header" x="1" y="0" width="87" height="15" forecolor="#000000" uuid="82658298-a217-4115-aa7e-529d0fc6ed3f"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<text><![CDATA[Pay Date]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="88" y="0" width="59" height="15" forecolor="#000000" uuid="cacf6c85-c0e8-4ac8-b970-fdc07c069073"/>
				<textElement>
					<font fontName="Times New Roman"/>
				</textElement>
				<text><![CDATA[In Payroll]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="147" y="0" width="72" height="15" forecolor="#000000" uuid="4e872778-e391-4410-8e36-e6c24d596436"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<text><![CDATA[Advance]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="219" y="0" width="72" height="15" forecolor="#000000" uuid="ff6a9170-c2e5-431a-b35f-90250d19a393"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<text><![CDATA[Deduction]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="292" y="1" width="72" height="15" forecolor="#000000" uuid="a2eefd51-dbfd-41fd-aaf7-8c74340ef5ad"/>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman"/>
				</textElement>
				<text><![CDATA[Balance]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="15" uuid="1aa8d3ef-f175-4514-a20f-15fa81346c8c"/>
				<textField isStretchWithOverflow="true" pattern="yyyy MMMMM" isBlankWhenNull="true">
					<reportElement style="Detail" x="1" y="0" width="87" height="15" uuid="bd3797be-b686-4ed4-9cb8-b8befd54e547"/>
					<textElement>
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{pay_date}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="88" y="0" width="59" height="15" uuid="6c08a57d-ca93-42ce-9d4d-8d0ca1bf2a96"/>
					<textElement>
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{in_payroll}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
					<reportElement style="Detail" x="147" y="0" width="72" height="15" uuid="2012b121-5f64-4bf9-b97d-033ae1fb9e2e">
						<printWhenExpression><![CDATA[$F{amount} != 0]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{amount}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
					<reportElement style="Detail" x="292" y="0" width="72" height="15" uuid="6a298bfa-b7c5-4c82-a543-3f1b7a844927"/>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{balance_1}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
					<reportElement style="Detail" x="219" y="0" width="72" height="15" uuid="b3224d42-c5f2-4584-8330-0b64de63acea">
						<printWhenExpression><![CDATA[$F{recovery} != 0]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{recovery}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="15" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1" uuid="df5ad23f-6e99-4b9d-9b11-8287262dbde4"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="eb274927-8d1c-4070-bd32-68c34fc170e7"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="533" y="0" width="40" height="20" forecolor="#736343" uuid="8c2716ea-d0c0-44ee-8dd0-7fee32bb89aa"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement style="Column header" x="453" y="0" width="80" height="20" forecolor="#736343" uuid="06d7b90e-afdb-42f4-9562-dc609cefd46b"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
				</textField>
				<textField pattern="EEEEE, d MMMMM yyyy HH:mm:ss Z">
					<reportElement style="Column header" x="22" y="1" width="197" height="20" forecolor="#736343" uuid="06f97c39-28d2-42ca-a5bf-3a097bfc3f3c"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</pageFooter>
	<summary>
		<band height="32" splitType="Stretch">
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="147" y="5" width="72" height="20" uuid="7621eff5-58b9-4f44-b411-d2ce96012aba"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{amount_1}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="219" y="5" width="72" height="20" uuid="43ad5724-22ba-4ec2-8f0f-30b0a20e3523"/>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Right">
					<font fontName="Times New Roman" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{recovery_1}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
