SMRIM00100_과제종류별 세목.xrw 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
  4. <xhtml:head>
  5. <xhtml:title>과제종류별 세목</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <cond>
  11. <bizflag>O</bizflag>
  12. <acntinfo>
  13. <acntlist>
  14. <acntnm/>
  15. <acntcd/>
  16. </acntlist>
  17. </acntinfo>
  18. <acntdetinfo>
  19. <acntdetlist>
  20. <supacnt2nm/>
  21. <supacnt3nm/>
  22. <supacnt4nm/>
  23. <supacnt5nm/>
  24. <acntnm/>
  25. <lrgnm/>
  26. <mdlnm/>
  27. <supacntcd2/>
  28. <supacntcd3/>
  29. <supacntcd4/>
  30. <supacntcd5/>
  31. <acntcd/>
  32. <lrgcd/>
  33. <mdlcd/>
  34. <bizflag/>
  35. <amtcd/>
  36. </acntdetlist>
  37. </acntdetinfo>
  38. </cond>
  39. </main>
  40. <resrchdept>
  41. </resrchdept>
  42. <hidden>
  43. </hidden>
  44. <send>
  45. </send>
  46. <init>
  47. </init>
  48. </root>
  49. </instance>
  50. <script type="javascript" ev:event="xforms-ready">
  51. <![CDATA[
  52. model.removenode("root/send");
  53. model.makeValue("root/send/cdgrupid", "I0011");
  54. submit("TRRIM00110");
  55. grd_acntlist.refresh();
  56. ]]>
  57. </script>
  58. <submission id="TRRIM00110" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/cdgrupid" resultref="/root/main/cond/acntinfo"/>
  59. <submission id="TRRIM00120" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/cond/acntdetinfo"/>
  60. </model>
  61. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  62. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  63. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  64. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  65. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  66. </xhtml:head>
  67. <xhtml:body>
  68. <caption id="caption10" class="tit_1" style="left:0px; top:0px; width:160px; height:14px; ">과제종류별 세목</caption>
  69. <caption id="caption_cdgrup_list" class="tit_2" style="left:0px; top:35px; width:118px; height:14px; ">과제종류</caption>
  70. <caption id="caption1" class="tit_2" style="left:270px; top:35px; width:118px; height:13px; ">분류</caption>
  71. <datagrid id="grd_acntlist" nodeset="/root/main/cond/acntinfo/acntlist" visibility="visible" caption="과제종류^acntcd" colsep="^" colwidth="220, 0" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:55px; width:245px; height:645px; ">
  72. <col ref="acntnm"/>
  73. <col ref="acntcd" visibility="hidden"/>
  74. <script type="javascript" ev:event="ondblclick">
  75. <![CDATA[
  76. var cRow = grd_acntlist.row;
  77. model.removenode("root/send");
  78. model.makeValue("root/send/acntcd", model.getValue("/root/main/cond/acntinfo/acntlist["+ cRow +"]/acntcd") );
  79. model.makeValue("root/send/bizflag",model.getValue("/root/main/cond/bizflag") );
  80. submit("TRRIM00120");
  81. grd_detl.refresh();
  82. ]]>
  83. </script>
  84. </datagrid>
  85. <datagrid id="grd_detl" nodeset="/root/main/cond/acntdetinfo/acntdetlist" caption="중분류^소분류(계정명)^계정코드^supacntcd2^supacntcd3^supacntcd4^supacntcd5^계정과목코드^목 코드^세목 코드^입출금 구분^금액코드" colsep="^" colwidth="191, 231, 114, 0, 0, 0, 0, 0, 0, 0, 0, 0" mergecells="bycol" mergecellsfixedrows="bycolrec" rowsep="|" style="left:270px; top:55px; width:905px; height:645px; text-align:center; ">
  86. <col ref="lrgnm" style="text-align:center; "/>
  87. <col ref="mdlnm" style="text-align:left; "/>
  88. <col ref="mdlcd"/>
  89. <col ref="supacntcd2"/>
  90. <col ref="supacntcd3"/>
  91. <col ref="supacntcd4"/>
  92. <col ref="supacntcd5"/>
  93. <col ref="acntcd"/>
  94. <col ref="lrgcd"/>
  95. <col ref="mdlcd"/>
  96. <col ref="bizflag"/>
  97. <col ref="amtcd"/>
  98. </datagrid>
  99. <line id="line4" class="line_1" style="x1:0px; y1:50px; x2:246px; y2:50px; "/>
  100. <line id="line1" class="line_1" style="x1:270px; y1:50px; x2:1174px; y2:50px; "/>
  101. <select1 id="radio1" ref="/root/main/cond/bizflag" appearance="full" cellspacing="10" cols="2" overflow="visible" style="left:330px; top:32px; width:110px; height:20px; border-style:none; ">
  102. <choices>
  103. <item>
  104. <label>비용</label>
  105. <value>O</value>
  106. </item>
  107. <item>
  108. <label>수익</label>
  109. <value>I</value>
  110. </item>
  111. </choices>
  112. <script type="javascript" ev:event="xforms-value-changed">
  113. <![CDATA[
  114. grd_acntlist.dispatch("ondblclick");
  115. ]]>
  116. </script>
  117. </select1>
  118. <button id="button1" class="btn2_letter3" style="left:1120px; top:30px; width:53px; height:19px; ">
  119. <caption>Excel</caption>
  120. <script type="javascript" ev:event="DOMActivate">
  121. <![CDATA[
  122. var sAcntnm = model.getValue("/root/main/cond/acntdetinfo/acntdetlist[1]/acntnm");
  123. if (sAcntnm == ""){
  124. messageBox("조회가 되지", "E007");
  125. return;
  126. }
  127. var sPrntDD = getCurrentDate();
  128. var file = window.fileDialog("save","","true","과제종류별 세목_("+sPrntDD+")","xls","All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  129. if(file != "") {
  130. grd_detl.saveExcel(file);
  131. }
  132. ]]>
  133. </script>
  134. </button>
  135. </xhtml:body>
  136. </xhtml:html>