siskohatBulananHibernateSummary.jrxml 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327
  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" isFloatColumnFooter="true">
  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="headerDate" class="java.util.Date"/>
  7. <parameter name="totalSetoranAwal" class="java.math.BigDecimal"/>
  8. <parameter name="totalPelunasan" class="java.math.BigDecimal"/>
  9. <parameter name="totalBatalSetoranAwal" class="java.math.BigDecimal"/>
  10. <parameter name="totalBatalPelunasan" class="java.math.BigDecimal"/>
  11. <queryString>
  12. <![CDATA[]]>
  13. </queryString>
  14. <field name="TEMPTABLE_PK" class="java.lang.Integer"/>
  15. <field name="CHANNEL_FK" class="java.lang.String"/>
  16. <field name="A01" class="java.lang.String"/>
  17. <field name="A02" class="java.lang.String"/>
  18. <field name="A03" class="java.lang.String"/>
  19. <field name="A04" class="java.lang.String"/>
  20. <field name="A05" class="java.lang.String"/>
  21. <field name="A06" class="java.lang.String"/>
  22. <field name="A07" class="java.lang.String"/>
  23. <field name="A08" class="java.lang.String"/>
  24. <field name="A09" class="java.lang.String"/>
  25. <field name="A10" class="java.lang.String"/>
  26. <field name="A11" class="java.lang.String"/>
  27. <field name="A12" class="java.lang.String"/>
  28. <field name="A13" class="java.lang.String"/>
  29. <field name="A14" class="java.lang.String"/>
  30. <field name="A15" class="java.lang.String"/>
  31. <field name="A16" class="java.lang.String"/>
  32. <field name="A17" class="java.lang.String"/>
  33. <field name="A18" class="java.lang.String"/>
  34. <field name="A19" class="java.lang.String"/>
  35. <field name="A20" class="java.lang.String"/>
  36. <field name="A21" class="java.lang.String"/>
  37. <field name="A22" class="java.lang.String"/>
  38. <field name="A23" class="java.lang.String"/>
  39. <field name="A24" class="java.lang.String"/>
  40. <field name="A25" class="java.lang.String"/>
  41. <field name="A26" class="java.lang.String"/>
  42. <field name="A27" class="java.lang.String"/>
  43. <field name="A28" class="java.lang.String"/>
  44. <field name="A29" class="java.lang.String"/>
  45. <field name="A30" class="java.lang.String"/>
  46. <field name="A31" class="java.lang.String"/>
  47. <field name="A32" class="java.lang.String"/>
  48. <field name="A33" class="java.lang.String"/>
  49. <field name="A34" class="java.lang.String"/>
  50. <field name="A35" class="java.lang.String"/>
  51. <field name="A36" class="java.lang.String"/>
  52. <field name="A37" class="java.lang.String"/>
  53. <field name="A38" class="java.lang.String"/>
  54. <field name="A39" class="java.lang.String"/>
  55. <field name="A40" class="java.lang.String"/>
  56. <field name="INSERTDATE" class="java.sql.Timestamp"/>
  57. <field name="DELETION_DATE" class="java.sql.Timestamp"/>
  58. <field name="date" class="java.util.Date">
  59. <fieldDescription><![CDATA[date]]></fieldDescription>
  60. </field>
  61. <field name="totalBataPelunasanDay" class="java.math.BigDecimal">
  62. <fieldDescription><![CDATA[totalBataPelunasanDay]]></fieldDescription>
  63. </field>
  64. <field name="totalBatalSetoranAwalDay" class="java.math.BigDecimal">
  65. <fieldDescription><![CDATA[totalBatalSetoranAwalDay]]></fieldDescription>
  66. </field>
  67. <field name="totalPelunasanDay" class="java.math.BigDecimal">
  68. <fieldDescription><![CDATA[totalPelunasanDay]]></fieldDescription>
  69. </field>
  70. <field name="totalSetoranAwalDay" class="java.math.BigDecimal">
  71. <fieldDescription><![CDATA[totalSetoranAwalDay]]></fieldDescription>
  72. </field>
  73. <background>
  74. <band splitType="Stretch"/>
  75. </background>
  76. <pageHeader>
  77. <band height="123" splitType="Stretch">
  78. <staticText>
  79. <reportElement x="0" y="0" width="555" height="25"/>
  80. <textElement textAlignment="Center">
  81. <font fontName="SansSerif" size="14" isBold="true"/>
  82. </textElement>
  83. <text><![CDATA[Summary Hasil Rekonsiliasi Bulanan]]></text>
  84. </staticText>
  85. <staticText>
  86. <reportElement x="0" y="25" width="100" height="20"/>
  87. <box leftPadding="5"/>
  88. <textElement/>
  89. <text><![CDATA[Tanggal Cetak]]></text>
  90. </staticText>
  91. <staticText>
  92. <reportElement x="0" y="45" width="100" height="20"/>
  93. <box leftPadding="5"/>
  94. <textElement/>
  95. <text><![CDATA[BPS]]></text>
  96. </staticText>
  97. <staticText>
  98. <reportElement x="0" y="65" width="100" height="20"/>
  99. <box leftPadding="5"/>
  100. <textElement/>
  101. <text><![CDATA[Alamat]]></text>
  102. </staticText>
  103. <staticText>
  104. <reportElement x="0" y="85" width="100" height="20"/>
  105. <box leftPadding="5"/>
  106. <textElement/>
  107. <text><![CDATA[Bulan]]></text>
  108. </staticText>
  109. <textField>
  110. <reportElement x="112" y="25" width="116" height="20"/>
  111. <box leftPadding="0"/>
  112. <textElement/>
  113. <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("dd/MM/yy HH:mm:ss").format(new java.util.Date())]]></textFieldExpression>
  114. </textField>
  115. <staticText>
  116. <reportElement x="112" y="45" width="116" height="20"/>
  117. <textElement/>
  118. <text><![CDATA[200 - BTN KCS JAKARTA]]></text>
  119. </staticText>
  120. <staticText>
  121. <reportElement x="100" y="25" width="12" height="20"/>
  122. <textElement/>
  123. <text><![CDATA[:]]></text>
  124. </staticText>
  125. <staticText>
  126. <reportElement x="100" y="45" width="12" height="20"/>
  127. <textElement/>
  128. <text><![CDATA[:]]></text>
  129. </staticText>
  130. <staticText>
  131. <reportElement x="100" y="65" width="12" height="20"/>
  132. <textElement/>
  133. <text><![CDATA[:]]></text>
  134. </staticText>
  135. <staticText>
  136. <reportElement x="100" y="85" width="12" height="20"/>
  137. <textElement/>
  138. <text><![CDATA[:]]></text>
  139. </staticText>
  140. <staticText>
  141. <reportElement x="112" y="65" width="116" height="20"/>
  142. <textElement/>
  143. <text><![CDATA[Jln. GajahMada No. 1]]></text>
  144. </staticText>
  145. <textField pattern="MMMMM yyyy">
  146. <reportElement x="112" y="85" width="116" height="20"/>
  147. <textElement/>
  148. <textFieldExpression class="java.util.Date"><![CDATA[$P{headerDate}]]></textFieldExpression>
  149. </textField>
  150. </band>
  151. </pageHeader>
  152. <columnHeader>
  153. <band height="24" splitType="Stretch">
  154. <staticText>
  155. <reportElement x="100" y="0" width="110" height="24"/>
  156. <box>
  157. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  158. </box>
  159. <textElement textAlignment="Right"/>
  160. <text><![CDATA[Total Setoran Awal]]></text>
  161. </staticText>
  162. <staticText>
  163. <reportElement x="210" y="0" width="110" height="24"/>
  164. <box>
  165. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  166. </box>
  167. <textElement textAlignment="Right"/>
  168. <text><![CDATA[Total Pelunasan]]></text>
  169. </staticText>
  170. <staticText>
  171. <reportElement x="320" y="0" width="110" height="24"/>
  172. <box>
  173. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  174. </box>
  175. <textElement textAlignment="Right"/>
  176. <text><![CDATA[ Batal Setoran Awal]]></text>
  177. </staticText>
  178. <staticText>
  179. <reportElement x="430" y="0" width="110" height="24"/>
  180. <box>
  181. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  182. </box>
  183. <textElement textAlignment="Right"/>
  184. <text><![CDATA[Batal Pelunasan]]></text>
  185. </staticText>
  186. <staticText>
  187. <reportElement x="0" y="0" width="100" height="24"/>
  188. <box>
  189. <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
  190. </box>
  191. <textElement/>
  192. <text><![CDATA[Tanggal]]></text>
  193. </staticText>
  194. </band>
  195. </columnHeader>
  196. <detail>
  197. <band height="25" splitType="Stretch">
  198. <textField isStretchWithOverflow="true" pattern="dd/MM/yy">
  199. <reportElement x="0" y="0" width="100" height="25"/>
  200. <textElement/>
  201. <textFieldExpression class="java.util.Date"><![CDATA[$F{date}]]></textFieldExpression>
  202. </textField>
  203. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  204. <reportElement x="120" y="0" width="90" height="25"/>
  205. <textElement textAlignment="Right"/>
  206. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalSetoranAwalDay}]]></textFieldExpression>
  207. </textField>
  208. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  209. <reportElement x="230" y="0" width="90" height="25"/>
  210. <textElement textAlignment="Right"/>
  211. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalPelunasanDay}]]></textFieldExpression>
  212. </textField>
  213. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  214. <reportElement x="450" y="0" width="90" height="25"/>
  215. <textElement textAlignment="Right"/>
  216. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalBataPelunasanDay}]]></textFieldExpression>
  217. </textField>
  218. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  219. <reportElement x="340" y="0" width="90" height="25"/>
  220. <textElement textAlignment="Right"/>
  221. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalBatalSetoranAwalDay}]]></textFieldExpression>
  222. </textField>
  223. <staticText>
  224. <reportElement x="100" y="0" width="20" height="25"/>
  225. <textElement textAlignment="Right"/>
  226. <text><![CDATA[Rp.]]></text>
  227. </staticText>
  228. <staticText>
  229. <reportElement x="210" y="0" width="20" height="25"/>
  230. <box leftPadding="3"/>
  231. <textElement textAlignment="Right"/>
  232. <text><![CDATA[Rp.]]></text>
  233. </staticText>
  234. <staticText>
  235. <reportElement x="320" y="0" width="20" height="25"/>
  236. <box leftPadding="3"/>
  237. <textElement textAlignment="Right"/>
  238. <text><![CDATA[Rp.]]></text>
  239. </staticText>
  240. <staticText>
  241. <reportElement x="430" y="0" width="20" height="25"/>
  242. <box leftPadding="3"/>
  243. <textElement textAlignment="Right"/>
  244. <text><![CDATA[Rp.]]></text>
  245. </staticText>
  246. </band>
  247. </detail>
  248. <columnFooter>
  249. <band height="42">
  250. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  251. <reportElement x="120" y="20" width="90" height="20"/>
  252. <box>
  253. <topPen lineWidth="1.0"/>
  254. <bottomPen lineWidth="3.0"/>
  255. </box>
  256. <textElement textAlignment="Right"/>
  257. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalSetoranAwal}]]></textFieldExpression>
  258. </textField>
  259. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  260. <reportElement x="228" y="20" width="92" height="20"/>
  261. <box>
  262. <topPen lineWidth="1.0"/>
  263. <bottomPen lineWidth="3.0"/>
  264. </box>
  265. <textElement textAlignment="Right"/>
  266. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalPelunasan}]]></textFieldExpression>
  267. </textField>
  268. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  269. <reportElement x="340" y="20" width="90" height="20"/>
  270. <box>
  271. <topPen lineWidth="1.0"/>
  272. <bottomPen lineWidth="3.0"/>
  273. </box>
  274. <textElement textAlignment="Right"/>
  275. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalBatalSetoranAwal}]]></textFieldExpression>
  276. </textField>
  277. <textField isStretchWithOverflow="true" pattern="#,##0.#####">
  278. <reportElement x="450" y="20" width="90" height="20"/>
  279. <box>
  280. <topPen lineWidth="1.0"/>
  281. <bottomPen lineWidth="3.0"/>
  282. </box>
  283. <textElement textAlignment="Right"/>
  284. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$P{totalBatalPelunasan}]]></textFieldExpression>
  285. </textField>
  286. <rectangle>
  287. <reportElement x="0" y="0" width="540" height="20"/>
  288. </rectangle>
  289. <staticText>
  290. <reportElement x="0" y="20" width="120" height="20"/>
  291. <box>
  292. <topPen lineWidth="1.0" lineStyle="Solid"/>
  293. <bottomPen lineWidth="3.0" lineStyle="Solid"/>
  294. </box>
  295. <textElement textAlignment="Right"/>
  296. <text><![CDATA[Rp.]]></text>
  297. </staticText>
  298. <staticText>
  299. <reportElement x="210" y="20" width="18" height="20"/>
  300. <box>
  301. <topPen lineWidth="1.0" lineStyle="Solid"/>
  302. <bottomPen lineWidth="3.0" lineStyle="Solid"/>
  303. </box>
  304. <textElement textAlignment="Right"/>
  305. <text><![CDATA[Rp.]]></text>
  306. </staticText>
  307. <staticText>
  308. <reportElement x="320" y="20" width="20" height="20"/>
  309. <box>
  310. <topPen lineWidth="1.0" lineStyle="Solid"/>
  311. <bottomPen lineWidth="3.0" lineStyle="Solid"/>
  312. </box>
  313. <textElement textAlignment="Right"/>
  314. <text><![CDATA[Rp.]]></text>
  315. </staticText>
  316. <staticText>
  317. <reportElement x="430" y="20" width="20" height="20"/>
  318. <box>
  319. <topPen lineWidth="1.0" lineStyle="Solid"/>
  320. <bottomPen lineWidth="3.0" lineStyle="Solid"/>
  321. </box>
  322. <textElement textAlignment="Right"/>
  323. <text><![CDATA[Rp.]]></text>
  324. </staticText>
  325. </band>
  326. </columnFooter>
  327. </jasperReport>