SPPAS00710_미수금입금내역.xfdl 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPPAS00710" position="absolute 0 0 803 784" titletext="미수금 입금현황" onload="SPPAS00710_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 25 800 62" id="grp" class="div_SA">
  8. <Layouts>
  9. <Layout width="800" height="37">
  10. <Button position="absolute 730 7 786 29" id="btn_search" class="btn1" text="조회" onclick="grp_btn_search_onclick"/>
  11. <Shape position="absolute 717 7 723 29" linetype="vertical" id="line1" class="line_4" visible="true"/>
  12. <Static text="입금기간 :" position="absolute 10 10 101 27" id="caption4" class="search_name"/>
  13. <Calendar position="absolute 102 9 207 28" id="input1" dateformat="yyyy-MM-dd" autoselect="true" autoskip="true"/>
  14. <Static text="~" position="absolute 212 11 224 26" align="align:center middle;" id="caption1"/>
  15. <Calendar position="absolute 229 9 334 28" id="input2" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
  16. </Layout>
  17. </Layouts>
  18. </Div>
  19. <Static text="입금현황" position="absolute 0 67 111 83" id="caption2" class="tit_2"/>
  20. <Grid position="absolute 0 86 800 782" align="align:center middle;" id="datagrid1" binddataset="ds_uncorcptamt" autofittype="col" cellsizingtype="both" cellsizebandtype="allband">
  21. <Formats>
  22. <Format id="default">
  23. <Columns>
  24. <Column size="25"/>
  25. <Column size="100"/>
  26. <Column size="100"/>
  27. <Column size="100"/>
  28. <Column size="80"/>
  29. <Column size="100"/>
  30. <Column size="100"/>
  31. <Column size="100"/>
  32. </Columns>
  33. <Rows>
  34. <Row size="24" band="head"/>
  35. <Row size="24"/>
  36. </Rows>
  37. <Band id="head">
  38. <Cell/>
  39. <Cell col="1" colspan="2" text="미수번호" taborder="undefined"/>
  40. <Cell col="3" text="등록번호"/>
  41. <Cell col="4" text="성명"/>
  42. <Cell col="5" text="수납일자"/>
  43. <Cell col="6" text="입금액"/>
  44. <Cell col="7" text="비고"/>
  45. </Band>
  46. <Band id="body">
  47. <Cell celltype="head" text="expr:currow + 1"/>
  48. <Cell col="1" style="align:center middle;" text="bind:uncocd"/>
  49. <Cell col="2" style="align:center middle;" text="bind:unconm"/>
  50. <Cell col="3" style="align:center middle;" text="bind:pid"/>
  51. <Cell col="4" style="align:center middle;" text="bind:hngnm"/>
  52. <Cell col="5" displaytype="date" style="align:center middle;" text="bind:rcptexecdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
  53. <Cell col="6" displaytype="number" style="align:right middle;padding:0 4 0 0;" text="bind:rcptamt"/>
  54. <Cell col="7" text="bind:rem"/>
  55. </Band>
  56. </Format>
  57. </Formats>
  58. </Grid>
  59. <Button position="absolute 720 65 800 84" id="button1" class="btn7" text="엑셀저장" onclick="button1_onclick"/>
  60. <Static id="caption60" text="미수금 입금내역" class="tit_1" position="absolute 0 0 160 25"/>
  61. </Layout>
  62. </Layouts>
  63. <Objects>
  64. <Dataset id="ds_uncorcptamt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  65. <ColumnInfo>
  66. <Column id="uncocd" type="STRING"/>
  67. <Column id="unconm" type="STRING"/>
  68. <Column id="pid" type="STRING"/>
  69. <Column id="hngnm" type="STRING"/>
  70. <Column id="rcptexecdd" type="STRING"/>
  71. <Column id="rcptamt" type="STRING"/>
  72. <Column id="rem" type="STRING"/>
  73. </ColumnInfo>
  74. </Dataset>
  75. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  76. <ColumnInfo>
  77. <Column id="fromdd" type="STRING" size="256"/>
  78. <Column id="todd" type="STRING" size="256"/>
  79. </ColumnInfo>
  80. <Rows>
  81. <Row/>
  82. </Rows>
  83. </Dataset>
  84. </Objects>
  85. <Bind>
  86. <BindItem id="item0" compid="grp.input1" propid="value" datasetid="ds_send" columnid="fromdd"/>
  87. <BindItem id="item1" compid="grp.input2" propid="value" datasetid="ds_send" columnid="todd"/>
  88. </Bind>
  89. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  90. * System Name :
  91. * Job Name :
  92. * Creator :
  93. * Make Date : 2016-05-24
  94. * Description :
  95. *---------------------------------------------------------------------------------------
  96. * Modify Date Modifier Modify Description
  97. *---------------------------------------------------------------------------------------
  98. * 2016-05-24 Live Converter TF->XP
  99. *
  100. *---------------------------------------------------------------------------------------
  101. ****************************************************************************************/
  102. //=======================================================================================
  103. // Lib Include
  104. //---------------------------------------------------------------------------------------
  105. include 'com_commonxp::comm_main.xjs';
  106. var arErrorCode = new HashArray();
  107. //=======================================================================================
  108. // Local methods
  109. //---------------------------------------------------------------------------------------
  110. /****************************************************************************************
  111. * Argument :
  112. * Description :
  113. ****************************************************************************************/
  114. //=======================================================================================
  115. // callback
  116. //---------------------------------------------------------------------------------------
  117. function callback(sSvcId, nErrorCode, sErrorMsg){
  118. arErrorCode.push(sSvcId, nErrorCode);
  119. }
  120. //=======================================================================================
  121. // Events
  122. //---------------------------------------------------------------------------------------
  123. /****************************************************************************************
  124. * Argument :
  125. * Description : onload
  126. ****************************************************************************************/
  127. function SPPAS00710_onload(obj:Form, e:LoadEventInfo){
  128. // 폼 초기회
  129. frmf_initForm(obj);
  130. ds_send.setColumn(0, 'fromdd', utlf_getCurrentDate());
  131. ds_send.setColumn(0, 'todd', utlf_getCurrentDate());
  132. }
  133. /****************************************************************************************
  134. * Argument :
  135. * Description : 조회 버튼 클릭 이벤트
  136. ****************************************************************************************/
  137. function grp_btn_search_onclick(obj:Button, e:ClickEventInfo){
  138. var oParam = {};
  139. oParam.id = "TRPAS00800";
  140. oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
  141. oParam.method = "reqGetRcptList";
  142. oParam.inds = "req=ds_send";
  143. oParam.outds = "ds_uncorcptamt=uncorcptamt";
  144. oParam.async = false;
  145. oParam.callback = "callback";
  146. tranf_submit(oParam);
  147. }
  148. /****************************************************************************************
  149. * Argument :
  150. * Description : 엑셀저장 버튼 클릭 이벤트
  151. ****************************************************************************************/
  152. function button1_onclick(obj:Button, e:ClickEventInfo){
  153. grdf_exportExcel(datagrid1, 'excel', 'SheetName', true, '', 'user', true);
  154. }
  155. ]]></Script>
  156. </Form>
  157. </FDL>