siskohatBulananSummary.jrxml 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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">
  3. <property name="ireport.zoom" value="1.0"/>
  4. <property name="ireport.x" value="0"/>
  5. <property name="ireport.y" value="0"/>
  6. <parameter name="startDate" class="java.util.Date">
  7. <defaultValueExpression><![CDATA[]]></defaultValueExpression>
  8. </parameter>
  9. <parameter name="endDate" class="java.util.Date">
  10. <defaultValueExpression><![CDATA[]]></defaultValueExpression>
  11. </parameter>
  12. <queryString>
  13. <![CDATA[SELECT * FROM MWTEMP.TEMPTABLE ORDER BY A03]]>
  14. </queryString>
  15. <field name="TEMPTABLE_PK" class="java.lang.Integer"/>
  16. <field name="CHANNEL_FK" class="java.lang.String"/>
  17. <field name="A01" class="java.lang.String"/>
  18. <field name="A02" class="java.lang.String"/>
  19. <field name="A03" class="java.lang.String"/>
  20. <field name="A04" class="java.lang.String"/>
  21. <field name="A05" class="java.lang.String"/>
  22. <field name="A06" class="java.lang.String"/>
  23. <field name="A07" class="java.lang.String"/>
  24. <field name="A08" class="java.lang.String"/>
  25. <field name="A09" class="java.lang.String"/>
  26. <field name="A10" class="java.lang.String"/>
  27. <field name="A11" class="java.lang.String"/>
  28. <field name="A12" class="java.lang.String"/>
  29. <field name="A13" class="java.lang.String"/>
  30. <field name="A14" class="java.lang.String"/>
  31. <field name="A15" class="java.lang.String"/>
  32. <field name="A16" class="java.lang.String"/>
  33. <field name="A17" class="java.lang.String"/>
  34. <field name="A18" class="java.lang.String"/>
  35. <field name="A19" class="java.lang.String"/>
  36. <field name="A20" class="java.lang.String"/>
  37. <field name="A21" class="java.lang.String"/>
  38. <field name="A22" class="java.lang.String"/>
  39. <field name="A23" class="java.lang.String"/>
  40. <field name="A24" class="java.lang.String"/>
  41. <field name="A25" class="java.lang.String"/>
  42. <field name="A26" class="java.lang.String"/>
  43. <field name="A27" class="java.lang.String"/>
  44. <field name="A28" class="java.lang.String"/>
  45. <field name="A29" class="java.lang.String"/>
  46. <field name="A30" class="java.lang.String"/>
  47. <field name="A31" class="java.lang.String"/>
  48. <field name="A32" class="java.lang.String"/>
  49. <field name="A33" class="java.lang.String"/>
  50. <field name="A34" class="java.lang.String"/>
  51. <field name="A35" class="java.lang.String"/>
  52. <field name="A36" class="java.lang.String"/>
  53. <field name="A37" class="java.lang.String"/>
  54. <field name="A38" class="java.lang.String"/>
  55. <field name="A39" class="java.lang.String"/>
  56. <field name="A40" class="java.lang.String"/>
  57. <field name="INSERTDATE" class="java.sql.Timestamp"/>
  58. <field name="DELETION_DATE" class="java.sql.Timestamp"/>
  59. <background>
  60. <band splitType="Stretch"/>
  61. </background>
  62. <pageHeader>
  63. <band height="123" splitType="Stretch">
  64. <staticText>
  65. <reportElement x="0" y="0" width="555" height="25"/>
  66. <textElement textAlignment="Center">
  67. <font fontName="SansSerif" size="14" isBold="true"/>
  68. </textElement>
  69. <text><![CDATA[Summary Hasil Rekonsiliasi Bulanan]]></text>
  70. </staticText>
  71. <staticText>
  72. <reportElement x="0" y="25" width="100" height="20"/>
  73. <box leftPadding="5"/>
  74. <textElement/>
  75. <text><![CDATA[Tanggal Cetak]]></text>
  76. </staticText>
  77. <staticText>
  78. <reportElement x="0" y="45" width="100" height="20"/>
  79. <box leftPadding="5"/>
  80. <textElement/>
  81. <text><![CDATA[BPS]]></text>
  82. </staticText>
  83. <staticText>
  84. <reportElement x="0" y="65" width="100" height="20"/>
  85. <box leftPadding="5"/>
  86. <textElement/>
  87. <text><![CDATA[Alamat]]></text>
  88. </staticText>
  89. <staticText>
  90. <reportElement x="0" y="85" width="100" height="20"/>
  91. <box leftPadding="5"/>
  92. <textElement/>
  93. <text><![CDATA[Bulan]]></text>
  94. </staticText>
  95. <textField>
  96. <reportElement x="112" y="25" width="116" height="20"/>
  97. <box leftPadding="0"/>
  98. <textElement/>
  99. <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("dd/MM/yy HH:mm:ss").format(new java.util.Date())]]></textFieldExpression>
  100. </textField>
  101. <staticText>
  102. <reportElement x="112" y="45" width="116" height="20"/>
  103. <textElement/>
  104. <text><![CDATA[200 - BTN KCS JAKARTA]]></text>
  105. </staticText>
  106. <staticText>
  107. <reportElement x="100" y="25" width="12" height="20"/>
  108. <textElement/>
  109. <text><![CDATA[:]]></text>
  110. </staticText>
  111. <staticText>
  112. <reportElement x="100" y="45" width="12" height="20"/>
  113. <textElement/>
  114. <text><![CDATA[:]]></text>
  115. </staticText>
  116. <staticText>
  117. <reportElement x="100" y="65" width="12" height="20"/>
  118. <textElement/>
  119. <text><![CDATA[:]]></text>
  120. </staticText>
  121. <staticText>
  122. <reportElement x="100" y="85" width="12" height="20"/>
  123. <textElement/>
  124. <text><![CDATA[:]]></text>
  125. </staticText>
  126. <staticText>
  127. <reportElement x="112" y="65" width="116" height="20"/>
  128. <textElement/>
  129. <text><![CDATA[Jln. GajahMada No. 1]]></text>
  130. </staticText>
  131. <textField pattern="MMMMM yyyy" isBlankWhenNull="true">
  132. <reportElement x="112" y="85" width="100" height="20"/>
  133. <textElement/>
  134. <textFieldExpression class="java.util.Date"><![CDATA[$P{startDate}]]></textFieldExpression>
  135. </textField>
  136. </band>
  137. </pageHeader>
  138. <columnHeader>
  139. <band height="24" splitType="Stretch">
  140. <staticText>
  141. <reportElement x="100" y="0" width="110" height="24"/>
  142. <box>
  143. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  144. </box>
  145. <textElement/>
  146. <text><![CDATA[Total Setoran Awal]]></text>
  147. </staticText>
  148. <staticText>
  149. <reportElement x="210" y="0" width="110" height="24"/>
  150. <box>
  151. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  152. </box>
  153. <textElement/>
  154. <text><![CDATA[Total Pelunasan]]></text>
  155. </staticText>
  156. <staticText>
  157. <reportElement x="320" y="0" width="110" height="24"/>
  158. <box>
  159. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  160. </box>
  161. <textElement/>
  162. <text><![CDATA[ Batal Setoran Awal]]></text>
  163. </staticText>
  164. <staticText>
  165. <reportElement x="430" y="0" width="110" height="24"/>
  166. <box>
  167. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  168. </box>
  169. <textElement/>
  170. <text><![CDATA[Batal Pelunasan]]></text>
  171. </staticText>
  172. <staticText>
  173. <reportElement x="0" y="0" width="100" height="24"/>
  174. <box>
  175. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  176. </box>
  177. <textElement/>
  178. <text><![CDATA[Tanggal]]></text>
  179. </staticText>
  180. </band>
  181. </columnHeader>
  182. <detail>
  183. <band height="25" splitType="Stretch">
  184. <textField pattern="dd/MM/yy">
  185. <reportElement x="0" y="0" width="100" height="25"/>
  186. <box topPadding="5" bottomPadding="0"/>
  187. <textElement/>
  188. <textFieldExpression class="java.lang.String"><![CDATA[$F{A03}]]></textFieldExpression>
  189. </textField>
  190. </band>
  191. </detail>
  192. <lastPageFooter>
  193. <band height="50"/>
  194. </lastPageFooter>
  195. </jasperReport>