| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327 |
- <?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="siskohatBulananSummary" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true">
- <property name="ireport.zoom" value="1.0"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <parameter name="headerDate" class="java.util.Date"/>
- <parameter name="totalSetoranAwal" class="java.math.BigDecimal"/>
- <parameter name="totalPelunasan" class="java.math.BigDecimal"/>
- <parameter name="totalBatalSetoranAwal" class="java.math.BigDecimal"/>
- <parameter name="totalBatalPelunasan" class="java.math.BigDecimal"/>
- <queryString>
- <![CDATA[]]>
- </queryString>
- <field name="TEMPTABLE_PK" class="java.lang.Integer"/>
- <field name="CHANNEL_FK" class="java.lang.String"/>
- <field name="A01" class="java.lang.String"/>
- <field name="A02" class="java.lang.String"/>
- <field name="A03" class="java.lang.String"/>
- <field name="A04" class="java.lang.String"/>
- <field name="A05" class="java.lang.String"/>
- <field name="A06" class="java.lang.String"/>
- <field name="A07" class="java.lang.String"/>
- <field name="A08" class="java.lang.String"/>
- <field name="A09" class="java.lang.String"/>
- <field name="A10" class="java.lang.String"/>
- <field name="A11" class="java.lang.String"/>
- <field name="A12" class="java.lang.String"/>
- <field name="A13" class="java.lang.String"/>
- <field name="A14" class="java.lang.String"/>
- <field name="A15" class="java.lang.String"/>
- <field name="A16" class="java.lang.String"/>
- <field name="A17" class="java.lang.String"/>
- <field name="A18" class="java.lang.String"/>
- <field name="A19" class="java.lang.String"/>
- <field name="A20" class="java.lang.String"/>
- <field name="A21" class="java.lang.String"/>
- <field name="A22" class="java.lang.String"/>
- <field name="A23" class="java.lang.String"/>
- <field name="A24" class="java.lang.String"/>
- <field name="A25" class="java.lang.String"/>
- <field name="A26" class="java.lang.String"/>
- <field name="A27" class="java.lang.String"/>
- <field name="A28" class="java.lang.String"/>
- <field name="A29" class="java.lang.String"/>
- <field name="A30" class="java.lang.String"/>
- <field name="A31" class="java.lang.String"/>
- <field name="A32" class="java.lang.String"/>
- <field name="A33" class="java.lang.String"/>
- <field name="A34" class="java.lang.String"/>
- <field name="A35" class="java.lang.String"/>
- <field name="A36" class="java.lang.String"/>
- <field name="A37" class="java.lang.String"/>
- <field name="A38" class="java.lang.String"/>
- <field name="A39" class="java.lang.String"/>
- <field name="A40" class="java.lang.String"/>
- <field name="INSERTDATE" class="java.sql.Timestamp"/>
- <field name="DELETION_DATE" class="java.sql.Timestamp"/>
- <field name="date" class="java.util.Date">
- <fieldDescription><![CDATA[date]]></fieldDescription>
- </field>
- <field name="totalBataPelunasanDay" class="java.math.BigDecimal">
- <fieldDescription><![CDATA[totalBataPelunasanDay]]></fieldDescription>
- </field>
- <field name="totalBatalSetoranAwalDay" class="java.math.BigDecimal">
- <fieldDescription><![CDATA[totalBatalSetoranAwalDay]]></fieldDescription>
- </field>
- <field name="totalPelunasanDay" class="java.math.BigDecimal">
- <fieldDescription><![CDATA[totalPelunasanDay]]></fieldDescription>
- </field>
- <field name="totalSetoranAwalDay" class="java.math.BigDecimal">
- <fieldDescription><![CDATA[totalSetoranAwalDay]]></fieldDescription>
- </field>
- <background>
- <band splitType="Stretch"/>
- </background>
- <pageHeader>
- <band height="123" splitType="Stretch">
- <staticText>
- <reportElement x="0" y="0" width="555" height="25"/>
- <textElement textAlignment="Center">
- <font fontName="SansSerif" size="14" isBold="true"/>
- </textElement>
- <text><![CDATA[Summary Hasil Rekonsiliasi Bulanan]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="25" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Tanggal Cetak]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="45" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[BPS]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="65" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Alamat]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="85" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Bulan]]></text>
- </staticText>
- <textField>
- <reportElement x="112" y="25" width="116" height="20"/>
- <box leftPadding="0"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("dd/MM/yy HH:mm:ss").format(new java.util.Date())]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="112" y="45" width="116" height="20"/>
- <textElement/>
- <text><![CDATA[200 - BTN KCS JAKARTA]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="25" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="45" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="65" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="85" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="112" y="65" width="116" height="20"/>
- <textElement/>
- <text><![CDATA[Jln. GajahMada No. 1]]></text>
- </staticText>
- <textField pattern="MMMMM yyyy">
- <reportElement x="112" y="85" width="116" height="20"/>
- <textElement/>
- <textFieldExpression class="java.util.Date"><![CDATA[$P{headerDate}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="24" splitType="Stretch">
- <staticText>
- <reportElement x="100" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Total Setoran Awal]]></text>
- </staticText>
- <staticText>
- <reportElement x="210" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Total Pelunasan]]></text>
- </staticText>
- <staticText>
- <reportElement x="320" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[ Batal Setoran Awal]]></text>
- </staticText>
- <staticText>
- <reportElement x="430" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Batal Pelunasan]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="0" width="100" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[Tanggal]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="25" splitType="Stretch">
- <textField isStretchWithOverflow="true" pattern="dd/MM/yy">
- <reportElement x="0" y="0" width="100" height="25"/>
- <textElement/>
- <textFieldExpression class="java.util.Date"><![CDATA[$F{date}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="120" y="0" width="90" height="25"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalSetoranAwalDay}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="230" y="0" width="90" height="25"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalPelunasanDay}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="450" y="0" width="90" height="25"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalBataPelunasanDay}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="340" y="0" width="90" height="25"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalBatalSetoranAwalDay}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="100" y="0" width="20" height="25"/>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="210" y="0" width="20" height="25"/>
- <box leftPadding="3"/>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="320" y="0" width="20" height="25"/>
- <box leftPadding="3"/>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="430" y="0" width="20" height="25"/>
- <box leftPadding="3"/>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- </band>
- </detail>
- <columnFooter>
- <band height="42">
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="120" y="20" width="90" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="3.0"/>
- </box>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalSetoranAwal}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="228" y="20" width="92" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="3.0"/>
- </box>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalPelunasan}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="340" y="20" width="90" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="3.0"/>
- </box>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalBatalSetoranAwal}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.#####">
- <reportElement x="450" y="20" width="90" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="3.0"/>
- </box>
- <textElement textAlignment="Right"/>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalBatalPelunasan}]]></textFieldExpression>
- </textField>
- <rectangle>
- <reportElement x="0" y="0" width="540" height="20"/>
- </rectangle>
- <staticText>
- <reportElement x="0" y="20" width="120" height="20"/>
- <box>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <bottomPen lineWidth="3.0" lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="210" y="20" width="18" height="20"/>
- <box>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <bottomPen lineWidth="3.0" lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="320" y="20" width="20" height="20"/>
- <box>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <bottomPen lineWidth="3.0" lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- <staticText>
- <reportElement x="430" y="20" width="20" height="20"/>
- <box>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <bottomPen lineWidth="3.0" lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right"/>
- <text><![CDATA[Rp.]]></text>
- </staticText>
- </band>
- </columnFooter>
- </jasperReport>
|