SMRAA00600_매각자산명세서.xrw 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>매각자산현황</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <list>
  11. <detailist/>
  12. </list>
  13. </main>
  14. <send>
  15. <condition>
  16. <instcd/>
  17. <frdt/>
  18. <todt/>
  19. <repayflag/>
  20. </condition>
  21. </send>
  22. <init/>
  23. <temp/>
  24. </root>
  25. </instance>
  26. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  27. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  28. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  29. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  30. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  31. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  32. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  33. <script type="javascript" ev:event="xforms-ready">
  34. <![CDATA[
  35. fOpenForm();
  36. //sCdGrupid = model.getValue("/root/init/comcode/cdgrupid");
  37. ]]>
  38. </script>
  39. <script type="javascript">
  40. <![CDATA[
  41. //========================================================================================
  42. //화면 로드시 초기화 함수
  43. //========================================================================================
  44. function fOpenForm() {
  45. //model.removenode("/root/main/notelist");
  46. var sToday = getCurrentDate().toString();
  47. var sFrday = sToday.substring(0,4) + "0301";
  48. model.setValue("/root/send/condition/todt",sToday);
  49. model.setValue("/root/send/condition/frdt",sFrday);
  50. var instcd = getUserInfo("dutplceinstcd");
  51. model.setValue("/root/send/condition/instcd",instcd);
  52. //misfComboComCdListMulti("R0025", "cmb_goodflag_search");
  53. // misfComboComCdListMulti("R0044", "cmb_goodflag_search");
  54. model.refresh();
  55. }
  56. //========================================================================================
  57. //관리대장 조회
  58. //========================================================================================
  59. function fRetrieve()
  60. {
  61. model.reset("/root/main/list/detailist");
  62. model.resetInstanceNode("/root/main/list/detailist");
  63. model.removenode("/root/main/list/detailist");
  64. model.refresh();
  65. submit("TRRAA00701");
  66. datagrid11.subtotalposition="below";
  67. datagrid11.multitotals=true;
  68. datagrid11.subtotal("sum", 1, 10, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
  69. datagrid11.subtotal("sum", 1, 11, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
  70. datagrid11.subtotal("sum", 1, 12, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
  71. datagrid11.subtotal("sum", 1, 13, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
  72. datagrid11.subtotal("sum", 1, 14, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
  73. model.refresh();
  74. }
  75. //========================================================================================
  76. //엑셀입력(excel file을 그리드에 입력)
  77. //========================================================================================
  78. function fInputExcel(pGrid) {
  79. var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  80. if(fileName != "") {
  81. pGrid.loadExcel(fileName, 1, true);
  82. pGrid.deleteRow(1);
  83. for(i = 1; i < pGrid.rows; i++) {
  84. pGrid.rowStatus(i) = 1;
  85. }
  86. pGrid.refresh();
  87. }
  88. }
  89. ]]>
  90. </script>
  91. <submission id="TRRAA00701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/detailist"/>
  92. </model>
  93. </xhtml:head>
  94. <xhtml:body guideline="1,1195;1,23;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  95. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  96. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">매각자산 현황</caption>
  97. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  98. </group>
  99. <group id="group3" scroll="auto" style="left:0px; top:20px; width:1195px; height:730px; ">
  100. <line id="line3" class="line_1" style="x1:0px; y1:100px; x2:1195px; y2:100px; "/>
  101. <caption id="caption21" class="tit_2" style="left:5px; top:80px; width:134px; height:14px; ">매각자산현황</caption>
  102. <button id="btn_excadd" class="btn2_letter4" style="left:1115px; top:50px; width:64px; height:19px; text-align:left; ">
  103. <caption>엑셀입력</caption>
  104. <script type="javascript" ev:event="onclick">
  105. <![CDATA[
  106. fInputExcel(grd_notelist);
  107. ]]>
  108. </script>
  109. </button>
  110. <upload id="upload1" style="left:735px; top:415px; width:100px; height:20px; "/>
  111. <group id="group4" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
  112. <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:55px; background-color:#fffbf2; border-color:#ffd799; "/>
  113. <button id="btn_search" class="btn1_letter2" navindex="16" style="left:1124; top:19px; width:56px; height:22px; ">
  114. <caption>조회</caption>
  115. <script type="javascript" ev:event="DOMActivate">
  116. <![CDATA[
  117. fRetrieve();
  118. ]]>
  119. </script>
  120. </button>
  121. <line id="line30" class="line_4" style="x1:1109; y1:8px; x2:1109; y2:51px; "/>
  122. <caption id="cap_goodflag_search" class="search_name" visibility="hidden" style="left:365px; top:20px; width:112px; height:17px; ">상태구분 :</caption>
  123. <caption id="caption2" class="search_name" style="left:15px; top:20px; width:91px; height:17px; ">매각 기간 :</caption>
  124. <select1 id="cmb_goodflag_search" ref="/root/send/condition/repayflag" class="combo_default" navindex="1" visibility="hidden" appearance="minimal" style="left:485px; top:20px; width:210px; height:19px; ">
  125. <choices>
  126. <itemset nodeset="/root/init/goodflag">
  127. <label ref="label"/>
  128. <value ref="value"/>
  129. </itemset>
  130. </choices>
  131. </select1>
  132. <caption id="caption7" style="left:213px; top:20px; width:15px; height:20px; ">~</caption>
  133. <input id="input2" ref="/root/send/condition/frdt" class="input_s_essential" inputtype="date" style="left:109px; top:20px; width:100px; height:19px; "/>
  134. <input id="input3" ref="/root/send/condition/todt" class="input_s_essential" inputtype="date" style="left:226px; top:20px; width:100px; height:19px; "/>
  135. </group>
  136. <datagrid id="datagrid11" nodeset="/root/main/list/detailist" caption="기관코드^자산분류^코드^자산명^수량^내용년수^취득일^처분일^처분구분^취득금액^감가상각충당금^미상각잔액^매각금액^차액" colsep="^" colwidth="0, 75, 0, 243, 39, 63, 77, 80, 64, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:2px; top:110px; width:1183px; height:580px; ">
  137. <col ref="instcd" style="text-align:left; "/>
  138. <col ref="acntnm" style="text-align:left; "/>
  139. <col ref="fixasetcd" style="text-align:left; "/>
  140. <col ref="goodflaghngnm" style="text-align:left; "/>
  141. <col ref="goodqty" style="text-align:left; "/>
  142. <col ref="cntsyearno" style="text-align:left; "/>
  143. <col ref="possndd" format="yyyy-mm-dd" style="text-align:left; "/>
  144. <col ref="saledd" format="yyyy-mm-dd" style="text-align:left; "/>
  145. <col ref="saleflag" style="text-align:left; "/>
  146. <col ref="possnamt" format="#,###" style="text-align:right; "/>
  147. <col ref="redurepayamt" format="#,###" style="text-align:right; "/>
  148. <col ref="notdpramt" format="#,###" style="text-align:right; "/>
  149. <col ref="saleamt" format="#,###" style="text-align:right; "/>
  150. <col ref="diffamt" format="(-)#,###" style="text-align:right; "/>
  151. </datagrid>
  152. <button id="btn_excel" class="btn2_letter4" navindex="10" style="left:1115px; top:75px; width:64px; height:19px; text-align:left; ">
  153. <caption>엑셀출력</caption>
  154. <script type="javascript" ev:event="DOMActivate">
  155. <![CDATA[
  156. misfSaveExcel(datagrid11);
  157. ]]>
  158. </script>
  159. </button>
  160. </group>
  161. </xhtml:body>
  162. </xhtml:html>