InquiryStatement.jrxml 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574
  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="InquiryStatement" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
  3. <property name="ireport.zoom" value="1.771561000000022"/>
  4. <property name="ireport.x" value="0"/>
  5. <property name="ireport.y" value="126"/>
  6. <parameter name="reportFilter" class="java.lang.String">
  7. <defaultValueExpression><![CDATA["1=1"]]></defaultValueExpression>
  8. </parameter>
  9. <parameter name="periodeStart" class="java.sql.Timestamp"/>
  10. <parameter name="periodeEnd" class="java.sql.Timestamp"/>
  11. <parameter name="rekening" class="java.lang.String"/>
  12. <parameter name="billerName" class="java.lang.String" isForPrompting="false"/>
  13. <parameter name="pathImage" class="java.lang.String"/>
  14. <parameter name="printdate" class="java.sql.Timestamp" isForPrompting="false"/>
  15. <parameter name="schema" class="java.lang.String">
  16. <defaultValueExpression><![CDATA["P"]]></defaultValueExpression>
  17. </parameter>
  18. <parameter name="description" class="java.lang.String"/>
  19. <parameter name="saldoDate" class="java.util.Date"/>
  20. <parameter name="branchName" class="java.lang.String"/>
  21. <parameter name="printBy" class="java.lang.String" isForPrompting="false"/>
  22. <queryString>
  23. <![CDATA[SELECT uncode, branch, treff6, trdat6, cfna2, cfna3, trremk, trtktn, trtime, trdorc, amt, auxtrc, serial, trancd, stdbal, sname,
  24. CASE WHEN TRUSER != '' THEN 0 ELSE 1 END AS TRUSER
  25. FROM bw$P!{schema}dat.DDBHIS
  26. WHERE $P!{reportFilter}
  27. ORDER BY TRDATE, TRUSER, TRTIME ASC]]>
  28. </queryString>
  29. <field name="UNCODE" class="java.math.BigDecimal"/>
  30. <field name="BRANCH" class="java.math.BigDecimal"/>
  31. <field name="TREFF6" class="java.math.BigDecimal"/>
  32. <field name="TRDAT6" class="java.math.BigDecimal"/>
  33. <field name="CFNA2" class="java.lang.String"/>
  34. <field name="CFNA3" class="java.lang.String"/>
  35. <field name="TRREMK" class="java.lang.String"/>
  36. <field name="TRTKTN" class="java.lang.String"/>
  37. <field name="TRTIME" class="java.lang.String"/>
  38. <field name="TRDORC" class="java.lang.String"/>
  39. <field name="AMT" class="java.math.BigDecimal"/>
  40. <field name="AUXTRC" class="java.lang.String"/>
  41. <field name="SERIAL" class="java.math.BigDecimal"/>
  42. <field name="TRANCD" class="java.math.BigDecimal"/>
  43. <field name="STDBAL" class="java.math.BigDecimal"/>
  44. <field name="SNAME" class="java.lang.String"/>
  45. <field name="TRUSER" class="java.lang.Integer"/>
  46. <variable name="initialBalance" class="java.math.BigDecimal">
  47. <variableExpression><![CDATA[$V{initialBalance} == null ? $F{STDBAL} : $V{initialBalance}]]></variableExpression>
  48. <initialValueExpression><![CDATA[$F{STDBAL}]]></initialValueExpression>
  49. </variable>
  50. <variable name="totalDebitKredit" class="java.math.BigDecimal">
  51. <variableExpression><![CDATA[$F{TRDORC} == 'D' ? $V{totalDebitKredit}.subtract($F{AMT}) : ($F{TRDORC} == 'C' ? $V{totalDebitKredit}.add($F{AMT}) : $V{totalDebitKredit})]]></variableExpression>
  52. <initialValueExpression><![CDATA[BigDecimal.ZERO]]></initialValueExpression>
  53. </variable>
  54. <variable name="currentBalance" class="java.math.BigDecimal">
  55. <variableExpression><![CDATA[$V{initialBalance}.add($V{totalDebitKredit})]]></variableExpression>
  56. <initialValueExpression><![CDATA[$F{STDBAL}]]></initialValueExpression>
  57. </variable>
  58. <variable name="totalDebit" class="java.math.BigDecimal" calculation="Sum">
  59. <variableExpression><![CDATA[$F{TRDORC} == "D" ? $F{AMT} : 0]]></variableExpression>
  60. </variable>
  61. <variable name="totalCredit" class="java.math.BigDecimal" calculation="Sum">
  62. <variableExpression><![CDATA[$F{TRDORC} == "C" ? $F{AMT} : 0]]></variableExpression>
  63. </variable>
  64. <variable name="countDebit" class="java.lang.Integer" calculation="Sum">
  65. <variableExpression><![CDATA[$F{TRDORC} == "D" ? 1 : 0]]></variableExpression>
  66. <initialValueExpression><![CDATA[0]]></initialValueExpression>
  67. </variable>
  68. <variable name="countCredit" class="java.lang.Integer" calculation="Sum">
  69. <variableExpression><![CDATA[$F{TRDORC} == "C" ? 1 : 0]]></variableExpression>
  70. <initialValueExpression><![CDATA[0]]></initialValueExpression>
  71. </variable>
  72. <background>
  73. <band splitType="Stretch"/>
  74. </background>
  75. <title>
  76. <band height="32" splitType="Stretch">
  77. <staticText>
  78. <reportElement x="0" y="0" width="802" height="32"/>
  79. <textElement>
  80. <font fontName="Arial Narrow" size="22" isBold="true"/>
  81. </textElement>
  82. <text><![CDATA[Report Rekening Koran]]></text>
  83. </staticText>
  84. </band>
  85. </title>
  86. <pageHeader>
  87. <band height="120" splitType="Stretch">
  88. <staticText>
  89. <reportElement x="344" y="0" width="35" height="20"/>
  90. <textElement textAlignment="Right">
  91. <font fontName="Arial Narrow"/>
  92. </textElement>
  93. <text><![CDATA[Branch]]></text>
  94. </staticText>
  95. <staticText>
  96. <reportElement x="379" y="0" width="14" height="20"/>
  97. <textElement textAlignment="Center">
  98. <font fontName="Arial Narrow"/>
  99. </textElement>
  100. <text><![CDATA[:]]></text>
  101. </staticText>
  102. <staticText>
  103. <reportElement x="344" y="20" width="35" height="20"/>
  104. <textElement textAlignment="Right">
  105. <font fontName="Arial Narrow"/>
  106. </textElement>
  107. <text><![CDATA[Periode]]></text>
  108. </staticText>
  109. <staticText>
  110. <reportElement x="379" y="20" width="14" height="20"/>
  111. <textElement textAlignment="Center">
  112. <font fontName="Arial Narrow"/>
  113. </textElement>
  114. <text><![CDATA[:]]></text>
  115. </staticText>
  116. <textField isStretchWithOverflow="true" pattern="dd-MMM-yyyy" isBlankWhenNull="true">
  117. <reportElement x="393" y="20" width="105" height="20"/>
  118. <textElement>
  119. <font fontName="Arial Narrow"/>
  120. </textElement>
  121. <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{periodeStart}]]></textFieldExpression>
  122. </textField>
  123. <textField isStretchWithOverflow="true" pattern="dd-MMM-yyyy" isBlankWhenNull="true">
  124. <reportElement x="515" y="20" width="113" height="20"/>
  125. <textElement textAlignment="Center">
  126. <font fontName="Arial Narrow"/>
  127. </textElement>
  128. <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{periodeEnd}]]></textFieldExpression>
  129. </textField>
  130. <staticText>
  131. <reportElement x="498" y="20" width="17" height="20"/>
  132. <textElement>
  133. <font fontName="Arial Narrow"/>
  134. </textElement>
  135. <text><![CDATA[-]]></text>
  136. </staticText>
  137. <staticText>
  138. <reportElement x="321" y="40" width="58" height="20"/>
  139. <textElement textAlignment="Right">
  140. <font fontName="Arial Narrow"/>
  141. </textElement>
  142. <text><![CDATA[No Rekening]]></text>
  143. </staticText>
  144. <staticText>
  145. <reportElement x="379" y="40" width="14" height="20"/>
  146. <textElement textAlignment="Center">
  147. <font fontName="Arial Narrow"/>
  148. </textElement>
  149. <text><![CDATA[:]]></text>
  150. </staticText>
  151. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  152. <reportElement x="393" y="40" width="235" height="20"/>
  153. <textElement>
  154. <font fontName="Arial Narrow"/>
  155. </textElement>
  156. <textFieldExpression class="java.lang.String"><![CDATA[$P{rekening}]]></textFieldExpression>
  157. </textField>
  158. <staticText>
  159. <reportElement x="344" y="60" width="35" height="20"/>
  160. <textElement textAlignment="Right">
  161. <font fontName="Arial Narrow"/>
  162. </textElement>
  163. <text><![CDATA[Name]]></text>
  164. </staticText>
  165. <staticText>
  166. <reportElement x="379" y="60" width="14" height="20"/>
  167. <textElement textAlignment="Center">
  168. <font fontName="Arial Narrow"/>
  169. </textElement>
  170. <text><![CDATA[:]]></text>
  171. </staticText>
  172. <staticText>
  173. <reportElement x="333" y="80" width="46" height="20"/>
  174. <textElement textAlignment="Right">
  175. <font fontName="Arial Narrow"/>
  176. </textElement>
  177. <text><![CDATA[Address]]></text>
  178. </staticText>
  179. <staticText>
  180. <reportElement x="379" y="80" width="14" height="20"/>
  181. <textElement textAlignment="Center">
  182. <font fontName="Arial Narrow"/>
  183. </textElement>
  184. <text><![CDATA[:]]></text>
  185. </staticText>
  186. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  187. <reportElement x="393" y="80" width="235" height="20"/>
  188. <textElement>
  189. <font fontName="Arial Narrow"/>
  190. </textElement>
  191. <textFieldExpression class="java.lang.String"><![CDATA[$F{CFNA2}]]></textFieldExpression>
  192. </textField>
  193. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  194. <reportElement x="393" y="100" width="235" height="20"/>
  195. <textElement>
  196. <font fontName="Arial Narrow"/>
  197. </textElement>
  198. <textFieldExpression class="java.lang.String"><![CDATA[$F{CFNA3}]]></textFieldExpression>
  199. </textField>
  200. <staticText>
  201. <reportElement x="0" y="0" width="239" height="20"/>
  202. <textElement>
  203. <font fontName="Arial Narrow" isBold="true"/>
  204. </textElement>
  205. <text><![CDATA[PT. Bank Tabungan Negara(Persero), Tbk]]></text>
  206. </staticText>
  207. <staticText>
  208. <reportElement x="0" y="58" width="69" height="20"/>
  209. <textElement verticalAlignment="Middle">
  210. <font fontName="Arial Narrow" isBold="true"/>
  211. </textElement>
  212. <text><![CDATA[Date Printed]]></text>
  213. </staticText>
  214. <image>
  215. <reportElement x="0" y="20" width="189" height="38"/>
  216. <imageExpression class="java.lang.String"><![CDATA[$P{pathImage}]]></imageExpression>
  217. </image>
  218. <staticText>
  219. <reportElement x="69" y="58" width="14" height="20"/>
  220. <textElement textAlignment="Center">
  221. <font fontName="Arial Narrow"/>
  222. </textElement>
  223. <text><![CDATA[:]]></text>
  224. </staticText>
  225. <textField isStretchWithOverflow="true" pattern="dd-MMM-yy HH:mm:ss" isBlankWhenNull="true">
  226. <reportElement x="83" y="58" width="126" height="20"/>
  227. <textElement verticalAlignment="Middle">
  228. <font fontName="Arial Narrow"/>
  229. </textElement>
  230. <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{printdate}]]></textFieldExpression>
  231. </textField>
  232. <textField>
  233. <reportElement x="393" y="0" width="235" height="20"/>
  234. <textElement/>
  235. <textFieldExpression class="java.lang.String"><![CDATA[$P{branchName}]]></textFieldExpression>
  236. </textField>
  237. <textField>
  238. <reportElement x="393" y="60" width="235" height="20"/>
  239. <textElement>
  240. <font fontName="Arial Narrow"/>
  241. </textElement>
  242. <textFieldExpression class="java.lang.String"><![CDATA[$F{SNAME}]]></textFieldExpression>
  243. </textField>
  244. <staticText>
  245. <reportElement x="0" y="78" width="69" height="20"/>
  246. <textElement verticalAlignment="Middle">
  247. <font fontName="Arial Narrow" isBold="true"/>
  248. </textElement>
  249. <text><![CDATA[Printed By]]></text>
  250. </staticText>
  251. <staticText>
  252. <reportElement x="69" y="78" width="14" height="20"/>
  253. <textElement textAlignment="Center">
  254. <font fontName="Arial Narrow"/>
  255. </textElement>
  256. <text><![CDATA[:]]></text>
  257. </staticText>
  258. <textField>
  259. <reportElement x="83" y="78" width="126" height="20"/>
  260. <textElement verticalAlignment="Middle">
  261. <font fontName="Arial Narrow"/>
  262. </textElement>
  263. <textFieldExpression class="java.lang.String"><![CDATA[$P{printBy}]]></textFieldExpression>
  264. </textField>
  265. </band>
  266. </pageHeader>
  267. <columnHeader>
  268. <band height="66" splitType="Stretch">
  269. <staticText>
  270. <reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="69" height="35"/>
  271. <box leftPadding="2">
  272. <pen lineStyle="Solid"/>
  273. <topPen lineWidth="1.0" lineStyle="Solid"/>
  274. <leftPen lineStyle="Solid"/>
  275. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  276. <rightPen lineStyle="Solid"/>
  277. </box>
  278. <textElement verticalAlignment="Middle">
  279. <font fontName="Arial Narrow" size="9" isBold="true"/>
  280. </textElement>
  281. <text><![CDATA[TRANS DATE]]></text>
  282. </staticText>
  283. <staticText>
  284. <reportElement stretchType="RelativeToBandHeight" x="69" y="0" width="64" height="35"/>
  285. <box leftPadding="2">
  286. <pen lineStyle="Solid"/>
  287. <topPen lineWidth="1.0" lineStyle="Solid"/>
  288. <leftPen lineStyle="Solid"/>
  289. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  290. <rightPen lineStyle="Solid"/>
  291. </box>
  292. <textElement verticalAlignment="Middle">
  293. <font fontName="Arial Narrow" size="9" isBold="true"/>
  294. </textElement>
  295. <text><![CDATA[EFF DATE]]></text>
  296. </staticText>
  297. <staticText>
  298. <reportElement stretchType="RelativeToBandHeight" x="134" y="0" width="244" height="35"/>
  299. <box leftPadding="2">
  300. <pen lineStyle="Solid"/>
  301. <topPen lineWidth="1.0" lineStyle="Solid"/>
  302. <leftPen lineStyle="Solid"/>
  303. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  304. <rightPen lineStyle="Solid"/>
  305. </box>
  306. <textElement verticalAlignment="Middle">
  307. <font fontName="Arial Narrow" size="9" isBold="true"/>
  308. </textElement>
  309. <text><![CDATA[TRANS DESCRIPTION]]></text>
  310. </staticText>
  311. <staticText>
  312. <reportElement stretchType="RelativeToBandHeight" x="442" y="0" width="101" height="35"/>
  313. <box leftPadding="0" rightPadding="2">
  314. <pen lineStyle="Solid"/>
  315. <topPen lineWidth="1.0" lineStyle="Solid"/>
  316. <leftPen lineStyle="Solid"/>
  317. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  318. <rightPen lineStyle="Solid"/>
  319. </box>
  320. <textElement textAlignment="Right" verticalAlignment="Middle">
  321. <font fontName="Arial Narrow" size="9" isBold="true"/>
  322. </textElement>
  323. <text><![CDATA[DEBIT]]></text>
  324. </staticText>
  325. <staticText>
  326. <reportElement stretchType="RelativeToBandHeight" x="543" y="0" width="102" height="35"/>
  327. <box leftPadding="0" rightPadding="2">
  328. <pen lineStyle="Solid"/>
  329. <topPen lineWidth="1.0" lineStyle="Solid"/>
  330. <leftPen lineStyle="Solid"/>
  331. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  332. <rightPen lineStyle="Solid"/>
  333. </box>
  334. <textElement textAlignment="Right" verticalAlignment="Middle">
  335. <font fontName="Arial Narrow" size="9" isBold="true"/>
  336. </textElement>
  337. <text><![CDATA[KREDIT]]></text>
  338. </staticText>
  339. <staticText>
  340. <reportElement stretchType="RelativeToBandHeight" x="645" y="0" width="157" height="35"/>
  341. <box leftPadding="0" rightPadding="2">
  342. <pen lineStyle="Solid"/>
  343. <topPen lineWidth="1.0" lineStyle="Solid"/>
  344. <leftPen lineStyle="Solid"/>
  345. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  346. <rightPen lineStyle="Solid"/>
  347. </box>
  348. <textElement textAlignment="Right" verticalAlignment="Middle">
  349. <font fontName="Arial Narrow" size="9" isBold="true"/>
  350. </textElement>
  351. <text><![CDATA[LEDGER BALANCE]]></text>
  352. </staticText>
  353. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  354. <reportElement x="134" y="35" width="245" height="31"/>
  355. <box topPadding="5" leftPadding="3"/>
  356. <textElement verticalAlignment="Top">
  357. <font fontName="Arial Narrow"/>
  358. </textElement>
  359. <textFieldExpression class="java.lang.String"><![CDATA[$F{TRREMK} == null ? $F{TRREMK} : $P{description}]]></textFieldExpression>
  360. </textField>
  361. <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
  362. <reportElement x="0" y="35" width="69" height="31">
  363. <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
  364. </reportElement>
  365. <box topPadding="5" leftPadding="3"/>
  366. <textElement>
  367. <font fontName="Arial Narrow"/>
  368. </textElement>
  369. <textFieldExpression class="java.util.Date"><![CDATA[$P{saldoDate}]]></textFieldExpression>
  370. </textField>
  371. <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
  372. <reportElement x="69" y="35" width="64" height="31">
  373. <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
  374. </reportElement>
  375. <box topPadding="5" leftPadding="3"/>
  376. <textElement>
  377. <font fontName="Arial Narrow"/>
  378. </textElement>
  379. <textFieldExpression class="java.util.Date"><![CDATA[$P{saldoDate}]]></textFieldExpression>
  380. </textField>
  381. <staticText>
  382. <reportElement stretchType="RelativeToBandHeight" x="378" y="0" width="64" height="35"/>
  383. <box leftPadding="2">
  384. <pen lineStyle="Solid"/>
  385. <topPen lineWidth="1.0" lineStyle="Solid"/>
  386. <leftPen lineStyle="Solid"/>
  387. <bottomPen lineWidth="1.0" lineStyle="Solid"/>
  388. <rightPen lineStyle="Solid"/>
  389. </box>
  390. <textElement verticalAlignment="Middle">
  391. <font fontName="Arial Narrow" size="9" isBold="true"/>
  392. </textElement>
  393. <text><![CDATA[POSTING TIME]]></text>
  394. </staticText>
  395. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  396. <reportElement x="645" y="35" width="157" height="31" isPrintWhenDetailOverflows="true"/>
  397. <box topPadding="5" rightPadding="5"/>
  398. <textElement textAlignment="Right">
  399. <font fontName="Arial Narrow" size="10"/>
  400. </textElement>
  401. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{currentBalance}]]></textFieldExpression>
  402. </textField>
  403. </band>
  404. </columnHeader>
  405. <detail>
  406. <band height="31" splitType="Stretch">
  407. <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
  408. <reportElement x="0" y="0" width="69" height="31" isPrintWhenDetailOverflows="true"/>
  409. <box topPadding="5" leftPadding="3"/>
  410. <textElement>
  411. <font fontName="Arial Narrow"/>
  412. </textElement>
  413. <textFieldExpression class="java.util.Date"><![CDATA[new SimpleDateFormat("ddMMyy").parse($F{TRDAT6}.toString().length() == 5 ? "0"+$F{TRDAT6}.toString() : $F{TRDAT6}.toString())]]></textFieldExpression>
  414. </textField>
  415. <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
  416. <reportElement x="69" y="0" width="64" height="31" isPrintWhenDetailOverflows="true"/>
  417. <box topPadding="5" leftPadding="3"/>
  418. <textElement>
  419. <font fontName="Arial Narrow"/>
  420. </textElement>
  421. <textFieldExpression class="java.util.Date"><![CDATA[new SimpleDateFormat("ddMMyy").parse($F{TREFF6}.toString().length() == 5 ? "0"+$F{TREFF6}.toString() : $F{TREFF6}.toString())]]></textFieldExpression>
  422. </textField>
  423. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  424. <reportElement x="133" y="0" width="246" height="31" isPrintWhenDetailOverflows="true"/>
  425. <box topPadding="5" leftPadding="3"/>
  426. <textElement verticalAlignment="Top">
  427. <font fontName="Arial Narrow"/>
  428. </textElement>
  429. <textFieldExpression class="java.lang.String"><![CDATA[$F{TRREMK}]]></textFieldExpression>
  430. </textField>
  431. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  432. <reportElement x="442" y="0" width="101" height="31" isPrintWhenDetailOverflows="true">
  433. <printWhenExpression><![CDATA[$F{TRDORC} == "D"]]></printWhenExpression>
  434. </reportElement>
  435. <box topPadding="5" rightPadding="2"/>
  436. <textElement textAlignment="Right">
  437. <font fontName="Arial Narrow"/>
  438. </textElement>
  439. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMT}]]></textFieldExpression>
  440. </textField>
  441. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  442. <reportElement x="543" y="0" width="102" height="31" isPrintWhenDetailOverflows="true">
  443. <printWhenExpression><![CDATA[$F{TRDORC} == "C"]]></printWhenExpression>
  444. </reportElement>
  445. <box topPadding="5" rightPadding="2"/>
  446. <textElement textAlignment="Right">
  447. <font fontName="Arial Narrow"/>
  448. </textElement>
  449. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMT}]]></textFieldExpression>
  450. </textField>
  451. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  452. <reportElement x="645" y="0" width="157" height="31" isPrintWhenDetailOverflows="true"/>
  453. <box topPadding="5" rightPadding="5"/>
  454. <textElement textAlignment="Right">
  455. <font fontName="Arial Narrow" size="10"/>
  456. </textElement>
  457. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{currentBalance}]]></textFieldExpression>
  458. </textField>
  459. <textField isStretchWithOverflow="true" pattern="HH:mm:ss" isBlankWhenNull="true">
  460. <reportElement x="379" y="0" width="63" height="31"/>
  461. <box topPadding="5" leftPadding="3"/>
  462. <textElement verticalAlignment="Top">
  463. <font fontName="Arial Narrow"/>
  464. </textElement>
  465. <textFieldExpression class="java.lang.String"><![CDATA[$F{TRTIME}.length() == 5 ? new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse("0"+$F{TRTIME})) : $F{TRTIME}.length() < 6 ? new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse("00000"+$F{TRTIME})) : new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse($F{TRTIME}))]]></textFieldExpression>
  466. </textField>
  467. </band>
  468. </detail>
  469. <pageFooter>
  470. <band height="54" splitType="Stretch">
  471. <textField>
  472. <reportElement x="344" y="34" width="80" height="20"/>
  473. <textElement textAlignment="Right">
  474. <font fontName="Arial Narrow"/>
  475. </textElement>
  476. <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
  477. </textField>
  478. <textField evaluationTime="Report">
  479. <reportElement x="424" y="34" width="40" height="20"/>
  480. <textElement>
  481. <font fontName="Arial Narrow"/>
  482. </textElement>
  483. <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
  484. </textField>
  485. </band>
  486. </pageFooter>
  487. <summary>
  488. <band height="60" splitType="Stretch">
  489. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  490. <reportElement x="442" y="0" width="101" height="20"/>
  491. <box topPadding="5" rightPadding="2">
  492. <topPen lineWidth="1.0"/>
  493. <leftPen lineWidth="0.0"/>
  494. <bottomPen lineWidth="1.0"/>
  495. <rightPen lineWidth="0.0"/>
  496. </box>
  497. <textElement textAlignment="Right">
  498. <font fontName="Arial Narrow"/>
  499. </textElement>
  500. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{totalDebit}]]></textFieldExpression>
  501. </textField>
  502. <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
  503. <reportElement x="543" y="0" width="102" height="20"/>
  504. <box topPadding="5" rightPadding="2">
  505. <topPen lineWidth="1.0"/>
  506. <bottomPen lineWidth="1.0"/>
  507. <rightPen lineWidth="0.0"/>
  508. </box>
  509. <textElement textAlignment="Right">
  510. <font fontName="Arial Narrow"/>
  511. </textElement>
  512. <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{totalCredit}]]></textFieldExpression>
  513. </textField>
  514. <staticText>
  515. <reportElement x="0" y="0" width="442" height="20"/>
  516. <box rightPadding="2">
  517. <topPen lineWidth="1.0"/>
  518. <bottomPen lineWidth="1.0"/>
  519. </box>
  520. <textElement textAlignment="Right" verticalAlignment="Middle">
  521. <font fontName="Arial Narrow" size="10" isBold="true"/>
  522. </textElement>
  523. <text><![CDATA[TOTAL DEBIT CREDIT]]></text>
  524. </staticText>
  525. <staticText>
  526. <reportElement x="645" y="0" width="157" height="20"/>
  527. <box>
  528. <topPen lineWidth="1.0"/>
  529. <bottomPen lineWidth="1.0"/>
  530. </box>
  531. <textElement/>
  532. <text><![CDATA[]]></text>
  533. </staticText>
  534. <staticText>
  535. <reportElement x="0" y="20" width="134" height="20"/>
  536. <box topPadding="0" leftPadding="2"/>
  537. <textElement verticalAlignment="Middle"/>
  538. <text><![CDATA[Jumlah Transaksi Debit]]></text>
  539. </staticText>
  540. <staticText>
  541. <reportElement x="0" y="40" width="134" height="20"/>
  542. <box topPadding="0" leftPadding="2"/>
  543. <textElement verticalAlignment="Middle"/>
  544. <text><![CDATA[Jumlah Transaksi Kredit]]></text>
  545. </staticText>
  546. <staticText>
  547. <reportElement x="134" y="20" width="14" height="20"/>
  548. <textElement textAlignment="Center" verticalAlignment="Middle">
  549. <font fontName="Arial Narrow"/>
  550. </textElement>
  551. <text><![CDATA[:]]></text>
  552. </staticText>
  553. <staticText>
  554. <reportElement x="134" y="40" width="14" height="20"/>
  555. <textElement textAlignment="Center" verticalAlignment="Middle">
  556. <font fontName="Arial Narrow"/>
  557. </textElement>
  558. <text><![CDATA[:]]></text>
  559. </staticText>
  560. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  561. <reportElement x="148" y="20" width="100" height="20"/>
  562. <box leftPadding="2"/>
  563. <textElement verticalAlignment="Middle"/>
  564. <textFieldExpression class="java.lang.Integer"><![CDATA[$V{countDebit}]]></textFieldExpression>
  565. </textField>
  566. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  567. <reportElement x="148" y="40" width="100" height="20"/>
  568. <box leftPadding="2"/>
  569. <textElement verticalAlignment="Middle"/>
  570. <textFieldExpression class="java.lang.Integer"><![CDATA[$V{countCredit}]]></textFieldExpression>
  571. </textField>
  572. </band>
  573. </summary>
  574. </jasperReport>