btnmw-was-app/Apps/REKON/WEB-INF/jrxml/MemoReport.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="MemoReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="START_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[new java.util.Date()]]></defaultValueExpression>
	</parameter>
	<parameter name="END_DATE" class="java.util.Date">
		<defaultValueExpression><![CDATA[new java.util.Date()]]></defaultValueExpression>
	</parameter>
	<parameter name="REKENING_NO" class="java.lang.String"/>
	<parameter name="REKENING_OWNER" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT SUM(A08) + SUM(COALESCE(A23, NULL, 0)) GRANDTOTAL, COUNT(A10)  TOTAL_BILL
FROM MWTEMP.TEMPTABLE
WHERE   A13 IN ('0', '3') AND A15 <> '' AND date(a02) >= $P{START_DATE} AND date(a02) <= $P{END_DATE}]]>
	</queryString>
	<field name="GRANDTOTAL" class="java.math.BigDecimal"/>
	<field name="TOTAL_BILL" class="java.lang.Integer"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="58" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="93" y="19" width="368" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["No : /M/DOPS/MPD-PDO/".concat(new java.text.SimpleDateFormat("MM/yyyy").format($P{END_DATE}))]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="180" y="1" width="195" height="20"/>
				<textElement textAlignment="Center">
					<font size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[MEMO]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="140" splitType="Stretch">
			<staticText>
				<reportElement x="180" y="0" width="257" height="20"/>
				<textElement/>
				<text><![CDATA[Kepada                : Finance and Accounting Division]]></text>
			</staticText>
			<staticText>
				<reportElement x="180" y="20" width="257" height="20"/>
				<textElement/>
				<text><![CDATA[Dari                      : Operation and Business Support Division]]></text>
			</staticText>
			<staticText>
				<reportElement x="180" y="40" width="257" height="20"/>
				<textElement/>
				<text><![CDATA[Perihal                 : Transaksi Pembayaran PLN Prepaid]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="70" width="555" height="13"/>
				<box rightPadding="3"/>
				<textElement/>
				<text><![CDATA[              Sebagaimana kesepakatan bersama antara PT. Bank Tabungan Negara (Persero) dengan]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="73" width="555" height="58"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["PT. Perusahaan Listrik Negara (Persero) mengenai penerimaan pembayaran jasa listrik melalui system Host to Host," +
"dengan ini disampaikan penerimaan yang harus dipindahbukukan ke rekening PLN untuk transaksi " +
"tanggal: " + (new java.text.SimpleDateFormat("dd MMMM yyyy").format($P{START_DATE})) + " s/d " + (new java.text.SimpleDateFormat("dd MMMM yyyy").format($P{END_DATE})) + ", data dengan rincian sebagai berikut :"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="20">
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="97" y="0" width="106" height="20"/>
				<box topPadding="2" leftPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Rekening]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="266" y="0" width="101" height="20"/>
				<box topPadding="2" leftPadding="0" rightPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="4" y="0" width="93" height="20"/>
				<box topPadding="2" leftPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Tujuan]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="203" y="0" width="63" height="20"/>
				<box topPadding="2" leftPadding="0" rightPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Total BILL]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="4" y="0" width="93" height="20" isPrintWhenDetailOverflows="true"/>
				<box leftPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<leftPen lineWidth="0.75" lineStyle="Solid"/>
					<bottomPen lineWidth="0.75" lineStyle="Solid"/>
					<rightPen lineWidth="0.75" lineStyle="Solid"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="97" y="0" width="106" height="20" isPrintWhenDetailOverflows="true"/>
				<box leftPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<leftPen lineWidth="0.75" lineStyle="Solid"/>
					<bottomPen lineWidth="0.75" lineStyle="Solid"/>
					<rightPen lineWidth="0.75" lineStyle="Solid"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="203" y="0" width="63" height="20" isPrintWhenDetailOverflows="true"/>
				<box leftPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<leftPen lineWidth="0.75" lineStyle="Solid"/>
					<bottomPen lineWidth="0.75" lineStyle="Solid"/>
					<rightPen lineWidth="0.75" lineStyle="Solid"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
			</textField>
			<textField>
				<reportElement x="97" y="0" width="106" height="20"/>
				<box leftPadding="3" rightPadding="3"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{REKENING_NO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="4" y="0" width="93" height="20"/>
				<box leftPadding="3" rightPadding="3"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{REKENING_OWNER}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="203" y="0" width="63" height="20"/>
				<box leftPadding="3" rightPadding="3"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTAL_BILL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="266" y="0" width="101" height="20"/>
				<box leftPadding="3" rightPadding="3">
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{GRANDTOTAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="131" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="351" y="83" width="176" height="20"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Jakarta," + (new java.text.SimpleDateFormat("dd MMMM yyyy").format(new java.util.Date()))]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="12" width="555" height="13"/>
				<box rightPadding="3"/>
				<textElement/>
				<text><![CDATA[Demikian kami sampaikan, atas perhatian dan kerjasamanya diucpakan terimakasih.]]></text>
			</staticText>
			<staticText>
				<reportElement x="-16" y="103" width="543" height="27"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[PT BANK TABUNGAN NEGARA (PERSERO) Tbk
OPERATION AND BUSINESS SUPPORT DIVISION]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>