inquiry_statement.jsp 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. <%@ include file="../common/header.jsp"%>
  2. <script type="text/javascript" language="javascript">
  3. <!--
  4. function doGenerateReport() {
  5. var message = "";
  6. var focus = false;
  7. var form = document.forms.inquiry;
  8. if (trim(form.rekening.value).length == 0) {
  9. message = message + ("<bean:message key="error.inquiry.rekening"/>\n");
  10. if (!focus) form.rekening.focus(); focus = true;
  11. }
  12. if (trim(form.startDate.value).length == 0) {
  13. message = message + ("<bean:message key="error.inquiry.startDate"/>\n");
  14. if (!focus) form.startDate.focus(); focus = true;
  15. }
  16. if (trim(form.endDate.value).length == 0) {
  17. message = message + ("<bean:message key="error.inquiry.endDate"/>\n");
  18. if (!focus) form.endDate.focus(); focus = true;
  19. }
  20. if(message == "") {
  21. var l = form.type.length;
  22. var val = "";
  23. for (var i=0; i<l; i++) {
  24. if (form.type[i].checked) {
  25. val = form.type[i].value;
  26. break;
  27. }
  28. }
  29. form.reportType.value = val;
  30. form.action.value = "generate_report";
  31. form.submit();
  32. // doDisable(form, "button");
  33. // doDisableImage(form);
  34. }else{
  35. alert(message);
  36. }
  37. }
  38. function doView(){
  39. var message = "";
  40. var focus = false;
  41. var form = document.forms.inquiry;
  42. if (trim(form.rekening.value).length == 0) {
  43. message = message + ("<bean:message key="error.inquiry.rekening"/>\n");
  44. if (!focus) form.rekening.focus(); focus = true;
  45. }
  46. if (trim(form.startDate.value).length == 0) {
  47. message = message + ("<bean:message key="error.inquiry.startDate"/>\n");
  48. if (!focus) form.startDate.focus(); focus = true;
  49. }
  50. if (trim(form.endDate.value).length == 0) {
  51. message = message + ("<bean:message key="error.inquiry.endDate"/>\n");
  52. if (!focus) form.endDate.focus(); focus = true;
  53. }
  54. if(message == "") {
  55. document.forms.inquiry.action.value="view_statement_search";
  56. document.forms.inquiry.submit();
  57. doDisable(document.forms.inquiry, "button");
  58. } else {
  59. alert(message);
  60. }
  61. }
  62. function doDownloadFile(folder, name){
  63. var form = document.forms.inquiry;
  64. form.tempStorageFolder.value=folder;
  65. form.tempStorageName.value=name;
  66. form.action.value="download_file";
  67. form.submit();
  68. }
  69. -->
  70. </script>
  71. <form name="inquiry" action="inquiry.do" method="POST" >
  72. <input type="hidden" name="action"/>
  73. <input type="hidden" name="sequence"/>
  74. <input type="hidden" name="redirect" value="create"/>
  75. <input type="hidden" name="reportType" value="report">
  76. <input type="hidden" name="tempStorageFolder">
  77. <input type="hidden" name="tempStorageName">
  78. <logic:notEmpty name="sname"><input type="hidden" name="sname" value="<bean:write name="sname"/>"></logic:notEmpty>
  79. <logic:notEmpty name="branch"><input type="hidden" name="branch" value="<bean:write name="branch"/>"></logic:notEmpty>
  80. <input type="hidden" name="notes" value="<bean:write name="notes"/>">
  81. <input type="hidden" name="deletionNote" value="<bean:write name="deletionNote"/>">
  82. <table width="100%" border="0" align="center" cellpadding="2" cellspacing="4">
  83. <td class="titleHeader" align="left"><bean:message key="project.inquiryStatement.key"/></td>
  84. </table>
  85. <table border="0" width="98%" align="center" cellpadding="2" cellspacing="1">
  86. <tr><td><html:errors/></td></tr>
  87. </table>
  88. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  89. <tr>
  90. <td width="15%" valign="top"><b><bean:message key="inquiryStatement.noRek.key" /><font color="#FF0000">*</font></b></td>
  91. <td width="1%" valign="top">:</td>
  92. <td width="84%" valign="top">
  93. <select name="rekening" style="width:300">
  94. <option value="">-- Select No Rekening --</option>
  95. <logic:notEmpty name="balanceList">
  96. <logic:iterate id="element_rekening" name="balanceList" >
  97. <option value="<bean:write name="element_rekening" property="acctno"/>"
  98. <logic:equal name="rekeningStr" value="${element_rekening.acctno}">
  99. selected
  100. </logic:equal>
  101. ><bean:write name="element_rekening" property="acctno" /></option>
  102. </logic:iterate>
  103. </logic:notEmpty>
  104. </select>
  105. </td>
  106. </tr>
  107. <tr>
  108. <td width="15%"><b><bean:message key="inquiryStatement.startDate.key"/><font color="#FF0000">*</font></b></td>
  109. <td width="1%">:</td>
  110. <td width="84%">
  111. <input type="text" name="startDate" value="<logic:notEmpty name="startDate"><bean:write name="startDate" format="dd/MM/yyyy" /></logic:notEmpty>" size="15" maxlength="10">
  112. <a href="javascript:cal_startDate.popup();"><img src="./images/cal.gif" width="16" height="16" border="0" alt=""></a>
  113. <script type="text/javascript" language="javascript">
  114. var cal_startDate = new calendar1(document.forms['inquiry'].elements['startDate']);
  115. </script>
  116. </td>
  117. </tr>
  118. <tr>
  119. <td width="15%"><b><bean:message key="inquiryStatement.endDate.key"/><font color="#FF0000">*</font></b></td>
  120. <td width="1%">:</td>
  121. <td width="84%">
  122. <input type="text" name="endDate" value="<logic:notEmpty name="endDate"><bean:write name="endDate" format="dd/MM/yyyy" /></logic:notEmpty>" size="15" maxlength="10">
  123. <a href="javascript:cal_endDate.popup();"><img src="./images/cal.gif" width="16" height="16" border="0" alt=""></a>
  124. <script type="text/javascript" language="javascript">
  125. var cal_endDate = new calendar1(document.forms['inquiry'].elements['endDate']);
  126. </script>
  127. </td>
  128. </tr>
  129. <tr>
  130. <td width="15%" valign="top">&nbsp</td>
  131. <td width="1%" valign="top">&nbsp</td>
  132. <td width="84%" valign="top">
  133. <input type="radio" name="type" value="PDF"> PDF </input>
  134. <input type="radio" name="type" value="XLS"> Excel </input>
  135. </td>
  136. </tr>
  137. <tr>
  138. <td width="15%"></td>
  139. <td width="1%"></td>
  140. <td><input type="button" value=<bean:message key="button.view"/> onclick="doView();" >
  141. <input type="button" value=<bean:message key="button.print"/> onclick="doGenerateReport();" >
  142. </td>
  143. <td colspan="4">&nbsp;</td>
  144. </tr>
  145. </table>
  146. <table>
  147. <tr>
  148. <td>
  149. <font color="#FF0000">*</font><b><logic:notEmpty name="notes"><bean:write name="notes" /></logic:notEmpty></b>
  150. </td>
  151. </tr>
  152. </table>
  153. <br/>
  154. <logic:notEmpty name="statementList">
  155. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  156. <tr align = "left">
  157. <td width="15%"><b><bean:message key="inquiryStatement.biller.key" /></b></td>
  158. <td width="1%">:</td>
  159. <td width="84%">
  160. <bean:write name="billerName"/>
  161. </td>
  162. </tr>
  163. <tr align = "left">
  164. <td width="15%"><b><bean:message key="inquiryStatement.branch.key" /></b></td>
  165. <td width="1%">:</td>
  166. <td width="84%">
  167. <bean:write name="branchName"/>
  168. </td>
  169. </tr>
  170. <tr align = "left">
  171. <td width="15%"><b><bean:message key="inquiryStatement.rekening.key" /></b></td>
  172. <td width="1%">:</td>
  173. <td width="84%">
  174. <bean:write name="rekening"/>
  175. </td>
  176. </tr>
  177. <tr align = "left">
  178. <td width="15%"><b><bean:message key="inquiryStatement.sname.key" /></b></td>
  179. <td width="1%">:</td>
  180. <td width="84%">
  181. <logic:notEmpty name="sname">
  182. <bean:write name="sname"/>
  183. </logic:notEmpty>
  184. </td>
  185. </tr>
  186. </table>
  187. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  188. <tr>
  189. <td class="titleField"><bean:message key="inquiryStatement.transDate.key"/></td>
  190. <td class="titleField"><bean:message key="inquiryStatement.transEffDate.key"/></td>
  191. <td class="titleField"><bean:message key="inquiryStatement.description.key"/></td>
  192. <td class="titleField"><bean:message key="inquiryStatement.time.key"/></td>
  193. <!--td class="titleField"><bean:message key="inquiryStatement.transCode.key"/></td>
  194. <td class="titleField"><bean:message key="inquiryStatement.chequeNo.key"/></td-->
  195. <td class="titleField"><bean:message key="inquiryStatement.debit.key"/></td>
  196. <td class="titleField"><bean:message key="inquiryStatement.kredit.key"/></td>
  197. <td class="titleField"><bean:message key="inquiryStatement.balance.key"/></td>
  198. </tr>
  199. <tr>
  200. <td width="5%" align="left">
  201. <bean:write name="date" format="dd/MM/yy"/>
  202. </td>
  203. <td width="5%" align="left">
  204. <bean:write name="date" format="dd/MM/yy"/>
  205. </td>
  206. <td width="35%" align="left">
  207. <bean:write name="description"/>
  208. </td>
  209. <td width="5%"></td>
  210. <td width="15%"></td>
  211. <td width="15%"></td>
  212. <td width="20%" align="right">
  213. <bean:write name="curBalance" format="#,##0.00"/>
  214. </td>
  215. </tr>
  216. <logic:iterate id="element_inquiry" name="statementList">
  217. <tr>
  218. <td width="5%" align="left">
  219. <bean:write name="element_inquiry" property="trdat6" format="dd/MM/yy"/>
  220. </td>
  221. <td width="5%" align="left">
  222. <bean:write name="element_inquiry" property="treff6" format="dd/MM/yy"/>
  223. </td>
  224. <td width="35%" align="left">
  225. <bean:write name="element_inquiry" property="trremk"/>
  226. </td>
  227. <td width="5%" align="left">
  228. <bean:write name="element_inquiry" property="time"/>
  229. </td>
  230. <!--td width="10%" align="right">
  231. <bean:write name="element_inquiry" property="trancd"/>
  232. </td>
  233. <td width="5%" align="right">
  234. <bean:write name="element_inquiry" property="serial"/>
  235. </td-->
  236. <td width="15%" align="right">
  237. <logic:notEmpty name= "element_inquiry" property="amt">
  238. <logic:equal name="element_inquiry" property="trdorc" value="D">
  239. <bean:write name="element_inquiry" property="amt" format="#,##0.00"/>
  240. </logic:equal>
  241. </logic:notEmpty>
  242. </td>
  243. <td width="15%" align="right">
  244. <logic:notEmpty name= "element_inquiry" property="amt">
  245. <logic:equal name="element_inquiry" property="trdorc" value="C">
  246. <bean:write name="element_inquiry" property="amt" format="#,##0.00"/>
  247. </logic:equal>
  248. </logic:notEmpty>
  249. </td>
  250. <td width="20%" align="right">
  251. <bean:write name="element_inquiry" property="stdbal" format="#,##0.00"/>
  252. </td>
  253. </tr>
  254. </logic:iterate>
  255. </table>
  256. <br/>
  257. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  258. <tr>
  259. <td width="50%" align="left">
  260. <b><bean:message key="inquiryStatement.total.key"/></b>
  261. </td>
  262. <td width="15%" align="right"><b><bean:write name="totalDebit" format="#,##0.00"/></b></td>
  263. <td width="15%" align="right"><b><bean:write name="totalKredit" format="#,##0.00"/></b></td>
  264. <td width="20%" align="right"></td>
  265. </tr>
  266. </table>
  267. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  268. <tr align = "left">
  269. <td width="15%"><b><bean:message key="inquiryStatement.countDebit.key" /></b></td>
  270. <td width="1%">:</td>
  271. <td width="84%">
  272. <bean:write name="countDebit"/>
  273. </td>
  274. </tr>
  275. <tr align = "left">
  276. <td width="15%"><b><bean:message key="inquiryStatement.countCredit.key" /></b></td>
  277. <td width="1%">:</td>
  278. <td width="84%">
  279. <bean:write name="countCredit"/>
  280. </td>
  281. </tr>
  282. </table>
  283. </logic:notEmpty>
  284. <br/><br/>
  285. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  286. <tr>
  287. <td align="left" class="titleField"><bean:message key="download.filename.key"/></td>
  288. <td align="left" class="titleField"><bean:message key="download.filesize.key"/></td>
  289. <td align="left" class="titleField"><bean:message key="download.date.key"/></td>
  290. </tr>
  291. <tr>
  292. <logic:notEmpty name="fileList">
  293. <logic:iterate id="element" name="fileList">
  294. <tr>
  295. <logic:equal name="element" property="status" value="1">
  296. <td align="left" class="celBorder"><a href="#" onclick="doDownloadFile('<bean:write name="element" property="folder"/>', '<bean:write name="element" property="name"/>');"><bean:write name="element" property="name" /></a></td>
  297. </logic:equal>
  298. <logic:equal name="element" property="status" value="0">
  299. <td align="left" class="celBorder"><logic:notEmpty name="element"><bean:write name="element" property="name" /></logic:notEmpty>&nbsp;</td>
  300. </logic:equal>
  301. <td align="right" class="celBorder"><logic:notEmpty name="element"><bean:write name="element" property="datafileLength"/></logic:notEmpty>&nbsp;</td>
  302. <logic:equal name="element" property="status" value="1">
  303. <td align="right" class="celBorder"><logic:notEmpty name="element"><bean:write name="element" property="timestamp" format="dd/MM/yyyy HH:mm:ss SSS"/></logic:notEmpty>&nbsp;</td>
  304. </logic:equal>
  305. <logic:equal name="element" property="status" value="0">
  306. <td align="right" class="celBorder">In Progress</td>
  307. </logic:equal>
  308. </tr>
  309. </logic:iterate>
  310. </logic:notEmpty>
  311. </tr>
  312. </table>
  313. <table border="0" width="100%" align="center" class="td" cellpadding="2" cellspacing="1">
  314. <tr>
  315. <td align="left" class="celBorder">
  316. <b><logic:notEmpty name="deletionNote"><bean:write name="deletionNote" /></logic:notEmpty></b>
  317. </td>
  318. </tr>
  319. </table>
  320. </FORM>
  321. <%@ include file="../common/footer.jsp" %>