SMRAR00400_가수금대장.xfdl 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRAR00400" position="absolute 0 0 1201 805" titletext="가수금대장" oninit="SMRAR00400_oninit" onload="SMRAR00400_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="grp_biz" anchor="all" taborder="4" position="absolute 0 121 1195 779">
  8. <Layouts>
  9. <Layout width="1195" height="658"/>
  10. </Layouts>
  11. </Div>
  12. <Static id="caption6" text="가수금대장" class="tit_1" position="absolute 0 0 177 25"/>
  13. <Div id="grp_sea" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 41 1195 81">
  14. <Layouts>
  15. <Layout>
  16. <Static id="caption22" text="지출일자:" class="search_name" position="absolute 20 10 105 27"/>
  17. <Calendar id="ipt_fromdd" taborder="1" class="input_default" position="absolute 105 10 210 29" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
  18. <Static id="output1" text="~" position="absolute 219 13 244 28"/>
  19. <Calendar id="ipt_todd" taborder="2" class="input_default" position="absolute 240 10 345 29" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
  20. <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1117 2 1123 36" anchor="top right"/>
  21. <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 1130 9 1186 31" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
  22. </Layout>
  23. </Layouts>
  24. </Div>
  25. <Button id="ipt_excsave" taborder="2" text="엑셀저장" class="btn7" position="absolute 1115 95 1195 114" anchor="top right" onclick="ipt_excsave_onclick"/>
  26. <Grid id="grd_main" taborder="3" binddataset="ds_main_maindatalist" useinputpanel="false" position="absolute 0 119 1085 309">
  27. <Formats>
  28. <Format id="default">
  29. <Columns>
  30. <Column size="110"/>
  31. <Column size="110"/>
  32. <Column size="80"/>
  33. <Column size="100"/>
  34. <Column size="100"/>
  35. <Column size="100"/>
  36. <Column size="100"/>
  37. <Column size="100"/>
  38. </Columns>
  39. <Rows>
  40. <Row size="24" band="head"/>
  41. <Row size="24" band="head"/>
  42. <Row size="24"/>
  43. </Rows>
  44. <Band id="head">
  45. <Cell rowspan="2" text="전월이월" taborder="undefined"/>
  46. <Cell col="1" rowspan="2" text="당월입금액" taborder="undefined"/>
  47. <Cell col="2" rowspan="2" text="일자" taborder="undefined"/>
  48. <Cell col="3" rowspan="2" text="당월상계액" taborder="undefined"/>
  49. <Cell col="4" colspan="3" text="상계내역" taborder="undefined"/>
  50. <Cell col="7" rowspan="2" text="차월이월" taborder="undefined"/>
  51. <Cell row="1" col="4" text="계정"/>
  52. <Cell row="1" col="5" text="차변"/>
  53. <Cell row="1" col="6" text="대변"/>
  54. </Band>
  55. <Band id="body">
  56. <Cell text="bind:beforeamt"/>
  57. <Cell col="1" text="bind:currentmmamt"/>
  58. <Cell col="2" text="bind:sangmmdate"/>
  59. <Cell col="3" text="bind:sangmmamt"/>
  60. <Cell col="4" text="bind:sangacctid"/>
  61. <Cell col="5" text="bind:sangmmacctamt1"/>
  62. <Cell col="6" text="bind:sangmmacctamt"/>
  63. <Cell col="7" text="bind:afteramt"/>
  64. </Band>
  65. </Format>
  66. </Formats>
  67. </Grid>
  68. <Static id="caption28" text="가수금대장" class="tit_2" position="absolute 0 98 209 120"/>
  69. <Shape id="line193" linetype="horizontal" class="line_10" position="absolute 0 114 1195 120" radiusx="5" anchor="left top right"/>
  70. </Layout>
  71. </Layouts>
  72. <Objects>
  73. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  74. <ColumnInfo>
  75. <Column id="fromdd" type="STRING" size="256"/>
  76. <Column id="todd" type="STRING" size="256"/>
  77. <Column id="instcd" type="STRING" size="256"/>
  78. </ColumnInfo>
  79. <Rows>
  80. <Row>
  81. <Col id="fromdd"/>
  82. <Col id="todd"/>
  83. <Col id="instcd"/>
  84. </Row>
  85. </Rows>
  86. </Dataset>
  87. <Dataset id="ds_main_maindatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  88. </Objects>
  89. <Bind>
  90. <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
  91. <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
  92. </Bind>
  93. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  94. * System Name :
  95. * Job Name :
  96. * Creator :
  97. * Make Date : 2017-06-19
  98. * Description :
  99. *---------------------------------------------------------------------------------------
  100. * Modify Date Modifier Modify Description
  101. *---------------------------------------------------------------------------------------
  102. * 2017-06-19 Live Converter TF->XP
  103. *
  104. *---------------------------------------------------------------------------------------
  105. ****************************************************************************************/
  106. include "com_commonxp::comm_main.xjs";
  107. include "mis_miscommonxp::MIS.xjs";
  108. function SMRAR00400_oninit(obj:Form, e:InitEventInfo)
  109. {
  110. frmf_initForm(obj);
  111. }
  112. function SMRAR00400_onload(obj:Form, e:LoadEventInfo)
  113. {
  114. grdf_initGrid(grd_main);
  115. var objDOM = rptf_createDOM();
  116. var objParam = new Object();
  117. objParam.xml_data_XML1 = objDOM.documentElement.source;
  118. var option = null;
  119. rptf_exeReportPreview30(["SMRAR00601"],[objParam], option, "", "grp_biz")
  120. var today = utlf_getCurrentDate();
  121. var cur_yymmdd = parseInt(String(today).substring(0, 6))+"01";
  122. ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  123. ds_send.setColumn(0, "fromdd", cur_yymmdd);
  124. ds_send.setColumn(0, "todd", today);
  125. grp_sea.ipt_fromdd.setFocus();
  126. }
  127. function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  128. {
  129. var oParam = {};
  130. oParam.id = "TRRAR00401";
  131. oParam.service = "accountinginfoapp.AccountingInfo";
  132. oParam.method = "getGaamtDaejang";
  133. oParam.inds = "req=ds_send";
  134. oParam.outds = "ds_main_maindatalist=maindatalist";
  135. oParam.async = false;
  136. oParam.callback = "cf_TRRAR00401";
  137. tranf_submit(oParam);
  138. }
  139. function cf_TRRAR00401(sSvcId, nErrorCode, sErrorMsg)
  140. {
  141. if(nErrorCode < 0) return;
  142. else
  143. {
  144. var objDOM = rptf_createDOM();
  145. rptf_setNodeListToDOM(objDOM, "/root/send", ds_send);
  146. rptf_setNodeListToDOM(objDOM, "/root/main/maindatalist", ds_main_maindatalist);
  147. var objParam = new Object();
  148. objParam.xml_data_XML1 = objDOM.documentElement.source;
  149. var option = null;
  150. rptf_exeReportPreview30(["SMRAR00401"],[objParam], option, "", "grp_biz");
  151. }
  152. }
  153. function ipt_excsave_onclick(obj:Button, e:ClickEventInfo)
  154. {
  155. misfSaveExcel(grd_main);
  156. }
  157. ]]></Script>
  158. </Form>
  159. </FDL>