SPICU02200_계약연구원급여현황.xrw 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297
  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. <grid>
  12. <emplno/>
  13. <workym/>
  14. <seqno/>
  15. <fromym/>
  16. <toym/>
  17. <stdemplno/>
  18. <appinstnm/>
  19. <stdsubjnm/>
  20. <payamt/>
  21. <paytotamt/>
  22. <payappyn/>
  23. <insurappyn/>
  24. <payappinst/>
  25. <rregno/>
  26. <stdrregno/>
  27. <hospnm/>
  28. <stdhospnm/>
  29. <deptnm/>
  30. <duthospnm/>
  31. <dutdeptnm/>
  32. <usernm/>
  33. </grid>
  34. <item>
  35. <notiyy/>
  36. </item>
  37. </list>
  38. <srch>
  39. <usernm/>
  40. <userid/>
  41. <stdusernm/>
  42. <stdemplno/>
  43. <startmonth/>
  44. <endmonth/>
  45. </srch>
  46. </main>
  47. <send>
  48. <data/>
  49. </send>
  50. <init>
  51. <grupjob>
  52. <item>
  53. <cdid/>
  54. <cdnm/>
  55. </item>
  56. </grupjob>
  57. </init>
  58. </root>
  59. </instance>
  60. <script type="javascript" ev:event="xforms-ready">
  61. <![CDATA[
  62. input_startdd.value = new Date().getDateFormat();
  63. input_enddd.value = new Date().getDateFormat().substring(0,6) + new Date().getMonthDay();
  64. fSearch();
  65. submit("TRICE00106");
  66. ]]>
  67. </script>
  68. <submission id="TRICU01605" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" replace="instance" resultref="/root/main/list"/>
  69. <submission id="TRICE00106" mediatype="application/x-www-form-urlencoded" method="post" replace="instance" resultref="/root/init/grupjob"/>
  70. </model>
  71. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  72. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  73. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  74. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  75. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  76. <script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
  77. <script type="javascript" src="../../../com/departmentcodeweb/js/ZSD001.js"/>
  78. <script type="javascript">
  79. <![CDATA[
  80. function fSearch() {
  81. model.copyNode("/root/send/data", "/root/main/srch");
  82. submit("TRICU01605", false);
  83. model.refresh();
  84. }
  85. function trim(data){
  86. return data.replace(/(^\s*)|(\s*$)/g, "");
  87. }
  88. ]]>
  89. </script>
  90. </xhtml:head>
  91. <xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  92. <datagrid id="totalgrid" nodeset="/root/main/list/grid" caption="작업월^사원번호^성명^주민번호^소속기관^부서명^근무기관명^근무부서명^직군^계약기간^계약기간^책임연구자^책임연구자^책임연구자^과제번호^연구과제명^총계약금액^월급여액^재정지원기관^입사일자^퇴직일자^휴대전화|작업월^사원번호^성명^주민번호^소속기관^부서명^근무기관명^근무부서명^직군^시작일^종료일^소속기관^사번^성명^과제번호^연구과제명^총계약금액^월급여액^재정지원기관^입사일자^퇴직일자^휴대전화" colsep="^" colwidth="53, 60, 56, 60, 102, 90, 102, 90, 67, 55, 55, 99, 60, 64, 100, 100, 70, 70, 100, 70, 70, 75, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:5px; top:90px; width:1175px; height:631px; ">
  93. <col ref="workym" format="9999-99" style="left:20px; top:63px; width:40px; height:23px; text-align:center; "/>
  94. <col ref="emplno" style="text-align:center; "/>
  95. <col ref="usernm" style="text-align:center; "/>
  96. <col ref="rregno" format="999999-9" style="text-align:center; "/>
  97. <col ref="hospnm"/>
  98. <col ref="deptnm"/>
  99. <col ref="duthospnm"/>
  100. <col ref="dutdeptnm"/>
  101. <col ref="grupjoblncd" type="combo" disabled="true" style="text-align:center; ">
  102. <choices>
  103. <itemset nodeset="/root/init/grupjob/item">
  104. <label ref="cdnm"/>
  105. <value ref="cdid"/>
  106. </itemset>
  107. </choices>
  108. </col>
  109. <col ref="fromym" format="9999-99" style="text-align:center; "/>
  110. <col ref="toym" format="9999-99" style="text-align:center; "/>
  111. <col ref="stdhospnm"/>
  112. <col ref="stdemplno" style="text-align:center; "/>
  113. <col ref="stdusernm" style="text-align:center; "/>
  114. <col/>
  115. <col ref="stdsubjnm"/>
  116. <col ref="paytotamt" format="(-)#,###" style="text-align:right; "/>
  117. <col ref="payamt" format="(-)#,###" style="text-align:right; "/>
  118. <col ref="payappinst"/>
  119. <col ref="entcodd" format="9999-99-99"/>
  120. <col ref="usertodd" format="9999-99-99"/>
  121. <col ref="mpphonno"/>
  122. <col ref="subjid" visibility="hidden"/>
  123. <col ref="instcd" visibility="hidden"/>
  124. <col ref="enddd" visibility="hidden"/>
  125. <col ref="userseqno" visibility="hidden"/>
  126. <col ref="subjid" visibility="hidden"/>
  127. <col ref="instcd" visibility="hidden"/>
  128. <script type="javascript" ev:event="onclick">
  129. <![CDATA[
  130. /*
  131. //스크롤 조작시 온클릭 이벤트 안타도록
  132. if( isDataCell() ){
  133. if ( datagrid3.col == datagrid3.colRef("usernm") ) {
  134. datagrid3.editCell();
  135. //return;
  136. }
  137. if ( datagrid3.col == datagrid3.colRef("rrgstno1") ) {
  138. datagrid3.editCell();
  139. //return;
  140. }
  141. if ( datagrid3.col == datagrid3.colRef("rrgstno2") ) {
  142. datagrid3.editCell();
  143. //return;
  144. }
  145. if ( datagrid3.col == datagrid3.colRef("sosok") ) {
  146. datagrid3.editCell();
  147. //return;
  148. }
  149. if ( datagrid3.col == datagrid3.colRef("workplceaddr") ) {
  150. datagrid3.editCell();
  151. //return;
  152. }
  153. if ( datagrid3.col == datagrid3.colRef("cmpytelno") ) {
  154. datagrid3.editCell();
  155. //return;
  156. }
  157. if ( datagrid3.col == datagrid3.colRef("email") ) {
  158. datagrid3.editCell();
  159. //return;
  160. }
  161. if ( datagrid3.col == datagrid3.colRef("depor") ) {
  162. datagrid3.editCell();
  163. //return;
  164. }
  165. if ( datagrid3.col == datagrid3.colRef("bankcd") ) {
  166. datagrid3.editCell();
  167. //return;
  168. }
  169. if ( datagrid3.col == datagrid3.colRef("acntno") ) {
  170. datagrid3.editCell();
  171. //return;
  172. }
  173. model.setValue("/root/send/data1/subjid", model.getValue("/root/main/list/grid1[" + datagrid3.row + "]/subjid"));
  174. model.setValue("/root/send/data1/instcd", model.getValue("/root/main/list/grid1[" + datagrid3.row + "]/instcd"));
  175. model.setValue("/root/send/data1/userid", model.getValue("/root/main/list/grid1[" + datagrid3.row + "]/userid"));
  176. model.setValue("/root/send/enddd", model.getValue("/root/main/list/grid1[" + datagrid3.row + "]/enddd"));
  177. readfunc();
  178. if (datagrid3.rows > 0){
  179. button1.disabled = false;
  180. button2.disabled = false;
  181. btn_save.disabled = false;
  182. }
  183. }
  184. for(var j=1; j<datagrid2.rows; j++){
  185. for(var i=1; i<datagrid1.rows; i++){
  186. if ( model.getValue("/root/main/list2/grid2["+ i +"]/userid")== model.getValue("/root/main/list3/grid3["+ j +"]/userid") &&
  187. model.getValue("/root/main/list2/grid2["+ i +"]/paydd") == model.getValue("/root/main/list3/grid3["+ j +"]/paydd")) {
  188. model.setValue("/root/main/list2/grid2["+ i +"]/chk","Y");
  189. }
  190. }
  191. }
  192. model.refresh();
  193. */
  194. ]]>
  195. </script>
  196. </datagrid>
  197. <line id="line1" class="line_3" style="x1:5px; y1:723px; x2:1180px; y2:723px; "/>
  198. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:4px; top:20px; width:1177px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
  199. <button id="button2" class="btn1_letter2" style="left:1105px; top:30px; width:56px; height:22px; ">
  200. <caption>조회</caption>
  201. <script type="javascript" ev:event="DOMActivate">
  202. <![CDATA[
  203. fSearch();
  204. ]]>
  205. </script>
  206. </button>
  207. <caption id="caption120" class="tit_1" style="left:0px; top:0px; width:173px; height:14px; background-image:../../../com/commonweb/images/tit_bullet1.gif; ">계약연구원 급여 현황 조회</caption>
  208. <caption id="caption74" class="search_name" style="left:20px; top:30px; width:90px; height:17px; background-image:../../../com/commonweb/images/search_bullet1.gif; ">작업월 :</caption>
  209. <caption id="caption1" class="search_name" style="left:340px; top:30px; width:90px; height:17px; background-image:../../../com/commonweb/images/search_bullet1.gif; ">사원번호 :</caption>
  210. <caption id="caption2" class="search_name" style="left:657px; top:30px; width:130px; height:17px; background-image:../../../com/commonweb/images/search_bullet1.gif; ">책임연구원 사번 :</caption>
  211. <input id="input_startdd" ref="/root/main/srch/startmonth" class="input_search" inputtype="date" format="yyyy-mm" style="left:95px; top:30px; width:100px; height:19px; "/>
  212. <input id="input_enddd" ref="/root/main/srch/endmonth" class="input_search" inputtype="date" format="yyyy-mm" style="left:215px; top:30px; width:100px; height:19px; "/>
  213. <button id="button1" class="icon_search" style="left:514px; top:33px; width:16px; height:16px; ">
  214. <caption/>
  215. <script type="javascript" ev:event="onclick">
  216. <![CDATA[
  217. window.load("../../../crc/comsubjweb/xrw/SPIMR00210_계약연구원관련조회.xrw","modal","code", "left:300px; top:300px; width:600px; height:540px;min:hidden;max:hidden;resize:false;");
  218. model.setValue("/root/main/srch/usernm", getParameter("usernm"));
  219. model.setValue("/root/main/srch/userid", getParameter("userid"));
  220. model.refresh();
  221. ]]>
  222. </script>
  223. </button>
  224. <input id="input20" ref="/root/main/srch/userid" class="input_search" style="left:430px; top:30px; width:80px; height:19px; ">
  225. <script type="javascript" ev:event="onkeyup">
  226. <![CDATA[
  227. if ( event.keyCode == 13 ) {
  228. setInputNodeCurText();
  229. fSearch();
  230. }
  231. ]]>
  232. </script>
  233. </input>
  234. <caption id="caption142" class="search_n_b" style="left:199px; top:34px; width:12px; height:13px; font-weight:bolder; ">~</caption>
  235. <input id="input1" ref="/root/main/srch/usernm" class="input_search" style="left:533px; top:30px; width:100px; height:19px; ">
  236. <script type="javascript" ev:event="onkeyup">
  237. <![CDATA[
  238. if ( event.keyCode == 13 ) {
  239. setInputNodeCurText();
  240. fSearch();
  241. }
  242. ]]>
  243. </script>
  244. </input>
  245. <button id="button3" class="icon_search" style="left:873px; top:33px; width:16px; height:16px; ">
  246. <caption/>
  247. <script type="javascript" ev:event="onclick">
  248. <![CDATA[
  249. window.load("../../../crc/comsubjweb/xrw/SPIMR00210_계약연구원관련조회.xrw","modal","code", "left:300px; top:300px; width:600px; height:540px;min:hidden;max:hidden;resize:false;");
  250. model.setValue("/root/main/srch/stdemplno", getParameter("userid"));
  251. model.setValue("/root/main/srch/stdusernm", getParameter("usernm"));
  252. model.refresh();
  253. ]]>
  254. </script>
  255. </button>
  256. <input id="input2" ref="/root/main/srch/stdemplno" class="input_search" style="left:789px; top:30px; width:80px; height:19px; ">
  257. <script type="javascript" ev:event="onkeyup">
  258. <![CDATA[
  259. if ( event.keyCode == 13 ) {
  260. setInputNodeCurText();
  261. fSearch();
  262. }
  263. ]]>
  264. </script>
  265. </input>
  266. <input id="input3" ref="/root/main/srch/stdusernm" class="input_search" style="left:892px; top:30px; width:100px; height:19px; ">
  267. <script type="javascript" ev:event="onkeyup">
  268. <![CDATA[
  269. if ( event.keyCode == 13 ) {
  270. setInputNodeCurText();
  271. fSearch();
  272. }
  273. ]]>
  274. </script>
  275. </input>
  276. <button id="btn_excel" class="btn2_letter3" style="left:1107px; top:69px; width:53px; height:19px; ">
  277. <caption>Excel</caption>
  278. <script type="javascript" ev:event="onclick">
  279. <![CDATA[
  280. var getDate = new Date().getDateFormat();
  281. var fileName = window.fileDialog("save",",",false,"계약연구원급여현황_" + getDate,"xls","All Files(*.*)|*.*|Excel Files(*.xls)|*.xls");
  282. if(fileName !=""){
  283. totalgrid.saveExcel(fileName);
  284. }
  285. ]]>
  286. </script>
  287. </button>
  288. </xhtml:body>
  289. </xhtml:html>