SMRPB01703_인사조건검색결과.xrw 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  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>SMRPB01703_인사조건검색결과</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <itemqry>
  11. <itemqrylist/>
  12. </itemqry>
  13. </main>
  14. <init>
  15. <orderby>
  16. <code>1</code>
  17. <cdnm>오름차순</cdnm>
  18. <code>2</code>
  19. <cdnm>내림차순</cdnm>
  20. </orderby>
  21. <titleinfo>
  22. <titlevo/>
  23. <titlecnt/>
  24. <titlenm/>
  25. <coltype/>
  26. </titleinfo>
  27. </init>
  28. <send>
  29. <itemqry>
  30. <strqry>select emplno , JOBPOSCD from mis.RPBMEMPL where emplno = '10404053 '</strqry>
  31. <titlecnt>2</titlecnt>
  32. <titlenm>emplno,JOBPOSCD</titlenm>
  33. </itemqry>
  34. <orderby/>
  35. </send>
  36. <hidden/>
  37. <target/>
  38. </root>
  39. </instance>
  40. <script type="javascript" ev:event="xforms-ready">
  41. <![CDATA[
  42. var strqry = model.getValue("/root/target/defaultvalue/strqry");
  43. var title = model.getValue("/root/target/defaultvalue/title");
  44. var titlecnt = model.getValue("/root/target/defaultvalue/titlecnt");
  45. var titlenm = model.getValue("/root/target/defaultvalue/titlenm");
  46. var coltype = model.getValue("/root/target/defaultvalue/coltype");
  47. model.setValue("/root/send/itemqry/strqry",strqry);
  48. model.setValue("/root/send/itemqry/titlecnt",titlecnt);
  49. model.setValue("/root/send/itemqry/titlenm",titlenm);
  50. model.setValue("/root/init/titleinfo/titlevo",title);
  51. model.setValue("/root/init/titleinfo/titlenm",titlenm);
  52. model.setValue("/root/init/titleinfo/coltype",coltype);
  53. model.setValue(rbo_orderby.attribute("ref"),"1");
  54. btn_search.dispatch("DOMActivate");
  55. model.setFocus("grd_result");
  56. ]]>
  57. </script>
  58. <submission id="TRRPB01703" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/itemqry"/>
  59. </model>
  60. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  61. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  62. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  63. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  64. <script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
  65. </xhtml:head>
  66. <xhtml:body style="margin-left:8; margin-right:8; ">
  67. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  68. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">인사조건검색결과</caption>
  69. </group>
  70. <group id="group2" scroll="auto" style="left:0px; top:40px; width:1195px; height:740px; ">
  71. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:3px; width:1193px; height:27px; background-color:#fffbf2; border-color:#ffd799; "/>
  72. <button id="btn_search" class="btn1_letter2" style="left:1134px; top:6px; width:56px; height:22px; ">
  73. <caption>조회</caption>
  74. <script type="javascript" ev:event="DOMActivate">
  75. <![CDATA[
  76. for (var i = grd_result.cols; i >= grd_result.fixedCols ; i--) {
  77. grd_result.removeColumn(false);
  78. }
  79. if (grd_result.nodeset.length> 0) {
  80. grd_result.nodeset = "/root/init/temp";
  81. model.removeNodeset(grd_result.nodeset);
  82. model.refresh();
  83. }
  84. submit("TRRPB01703");
  85. try{
  86. var node = instance1.selectNodes("/root/main/itemqry/itemqrylist[1]/*");
  87. var titlecnt = model.getValue("/root/target/defaultvalue/titlecnt");
  88. var coltype = model.getValue("/root/target/defaultvalue/coltype").split(",");
  89. for(i=0;i<titlecnt;i++) {
  90. if(coltype[i] == "INT" ||coltype[i] == "FLOAT" || coltype[i] == "MONEY" ){
  91. grd_result.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "#,###;"+ " style:" + "text-align:right; ", false);
  92. }
  93. else if(coltype[i] == "YYMMDD"){
  94. grd_result.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "yyyy-mm-dd;" + " style:" + "text-align:left; ", false);
  95. }
  96. else if(coltype[i] == "YYMM"){
  97. grd_result.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + " format:" + "yyyy-mm;" + "text-align:left; ", false);
  98. }
  99. else{
  100. grd_result.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + "text-align:left; ", false);
  101. }
  102. }
  103. }
  104. catch (ex) {
  105. }
  106. grd_result.caption = model.getValue("/root/target/defaultvalue/title");
  107. grd_result.nodeset = "/root/main/itemqry/itemqrylist";
  108. grd_result.rebuild();
  109. ]]>
  110. </script>
  111. </button>
  112. <line id="line13" class="line_4" style="x1:1130px; y1:8px; x2:1130px; y2:23px; "/>
  113. <button id="btn_saveexcel" class="btn2_letter4" style="left:1129px; top:32px; width:64px; height:19px; ">
  114. <caption>엑셀저장</caption>
  115. <script type="javascript" ev:event="DOMActivate">
  116. <![CDATA[
  117. var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  118. if (fileName != "")
  119. {
  120. grd_result.saveExcel(fileName);
  121. }
  122. ]]>
  123. </script>
  124. </button>
  125. <caption id="caption1" class="search_name" visibility="hidden" style="left:1px; top:7px; width:100px; height:17px; vertical-align:middle; ">항목구분</caption>
  126. <select1 id="rbo_orderby" ref="/root/send/orderby" visibility="hidden" overflow="visible" appearance="full" cols="2" style="left:79px; top:7px; width:311px; height:20px; border-style:none; ">
  127. <choices>
  128. <itemset nodeset="/root/init/orderby">
  129. <label ref="cdnm"/>
  130. <value ref="code"/>
  131. </itemset>
  132. </choices>
  133. </select1>
  134. <datagrid id="grd_result" colsep="^" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:2px; top:54px; width:1190px; height:684px; "/>
  135. </group>
  136. <group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
  137. </xhtml:body>
  138. </xhtml:html>