SMRPD00700_부서별휴가사용현황.xrw 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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. <deptprvaliuselist/>
  12. </list>
  13. </main>
  14. <send>
  15. <retrparams>
  16. <instcd/>
  17. <dutyy/>
  18. <dutunitcd/>
  19. <dutunitnm/>
  20. <emplno/>
  21. <emplnm/>
  22. <prfshipflag/>
  23. <preststatcd/>
  24. <deptgb/>
  25. </retrparams>
  26. </send>
  27. <init/>
  28. <temp/>
  29. </root>
  30. </instance>
  31. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  32. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  33. <submission id="TRRPD00701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
  34. </model>
  35. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  36. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  37. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  38. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  39. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  40. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  41. <script type="javascript" src="../../../mis/dligclaznsmngtweb/js/RPD001.js"/>
  42. <script type="javascript" ev:event="xforms-ready">
  43. <![CDATA[
  44. fInitialize();
  45. ]]>
  46. </script>
  47. <script type="javascript">
  48. <![CDATA[
  49. function fInitialize() {
  50. model.removenode("/root/main/list/deptprvaliuselist");
  51. misfMsterDetailSet(grd_dutsumlist, null, "TRRPD00201", "Y");
  52. misfComboComCdListMulti("R0058,R0146","cmb_prfshipflag,cmb_preststatcd");
  53. model.setValue("/root/send/retrparams/dutyy", getCurrentDate().substr(0, 4));
  54. misfComboInstCdListMulti("cmb_instcd",getCurrentDate().substr(0, 8),"","Y");
  55. misfGetAndSetUserInfo();
  56. misfGetUserAuth();
  57. rpdfSetControlAuth();
  58. rpdfComboCdList(cmb_dutplce); // 권한별 근무부서 세팅
  59. rpdfSetDutUnitCombo();
  60. model.setValue("/root/send/retrparams/instcd", getUserInfo("dutplceinstcd"));
  61. model.setValue("/root/send/retrparams/dutunitcd", DUT_UNIT_CD);
  62. model.setValue("/root/send/retrparams/dutunitnm", DUT_UNIT_NM);
  63. addGridComboItem("cmb_prfshipflag", "전체", "","above");
  64. addGridComboItem("cmb_preststatcd", "전체", "","above");
  65. model.setValue("/root/send/retrparams/deptgb", "1");
  66. model.refresh();
  67. if (cmb_dutplce.value == "") {
  68. cmb_dutplce.select(0);
  69. }
  70. grd_dutsumlist.rowHeight(0) = 35;
  71. if(getUserInfo("dutplceinstcd") == "001" && DUTY_PART_YN == "Y") {
  72. cmb_instcd.disabled = false;
  73. }
  74. if(DUTY_PART_YN != "Y") {
  75. ipt_dutdeptcd.disabled = true;
  76. ipt_dutdeptnm.disabled = true;
  77. btn_dutdept.disabled = true;
  78. }
  79. }
  80. function fRetrieve() {
  81. if(model.getValue("/root/send/retrparams/dutunitcd") == "" && DUTY_PART_YN != "Y") {
  82. messageBox("근무부서를", "C001");
  83. return "dutunitval";
  84. }
  85. submit("TRRPD00701");
  86. var fNum = 0;
  87. for(var i=1; i<grd_dutsumlist.rows; i++) {
  88. for(var j=grd_dutsumlist.colRef("jan") - 1; j<=grd_dutsumlist.colRef("userate"); j++) {
  89. fNum = 0;
  90. fNum = parseFloat(grd_dutsumlist.valueMatrix(i, j));
  91. if(fNum == 0) {
  92. grd_dutsumlist.valueMatrix(i, j) = "0";
  93. }
  94. else {
  95. if( (fNum % parseInt(fNum)) == 0) {
  96. grd_dutsumlist.valueMatrix(i, j) = parseInt(fNum);
  97. }
  98. }
  99. }
  100. if(grd_dutsumlist.valueMatrix(i, grd_dutsumlist.colRef("deptnm")) == " 계") {
  101. grd_dutsumlist.rowStyle(i, "all", "background-color") = "#ffff99";
  102. }
  103. else {
  104. grd_dutsumlist.rowStyle(i, "all", "background-color") = "transparent";
  105. }
  106. }
  107. }
  108. function fPrint() {
  109. exeReportPreview("RPRPD00701", "XMLSTR");
  110. model.refresh();
  111. }
  112. function fSet1YearNurse() {
  113. var sEntcoDD = "";
  114. var iEnterDayCnt = 0;
  115. var iCurntDayCnt = 0;
  116. for(var i=2; i<grd_dutsumlist.rows-1; i++) {
  117. sEntcoDD = grd_dutsumlist.valueMatrix(i, grd_dutsumlist.colRef("entcodd"));
  118. iEnterDayCnt = parseInt( Math.floor( Date.parse( misfConvertChar2Date(sEntcoDD, "/")) / 8.64e7));
  119. iCurntDayCnt = parseInt( Math.floor( Date.parse( misfConvertChar2Date(getCurrentDate(), "/")) / 8.64e7));
  120. if(iCurntDayCnt - iEnterDayCnt <= 365) {
  121. grd_dutsumlist.cellStyle("background-image", i, grd_dutsumlist.colRef("emplnm")) = "../../../com/commonweb/images/input_s_essential.gif";
  122. grd_dutsumlist.cellStyle("background-position", i, grd_dutsumlist.colRef("emplnm")) = "center left";
  123. }
  124. else {
  125. grd_dutsumlist.rebuildStyle(i,grd_dutsumlist.colRef("emplnm"));
  126. }
  127. }
  128. }
  129. ]]>
  130. </script>
  131. </xhtml:head>
  132. <xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-right:8; ">
  133. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  134. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">부서별휴가사용현황</caption>
  135. </group>
  136. <group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  137. <select1 id="cmb_preststatcd" ref="/root/send/retrparams/preststatcd" class="combo_search" navindex="7" visibility="hidden" appearance="minimal" style="left:1000px; top:18px; width:90px; height:19px; ">
  138. <choices>
  139. <itemset>
  140. <label/>
  141. <value/>
  142. </itemset>
  143. </choices>
  144. </select1>
  145. <caption id="caption4" class="search_name" visibility="hidden" style="left:940px; top:19px; width:58px; height:17px; ">상태 :</caption>
  146. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  147. <line id="line13" class="line_4" style="x1:1110px; y1:17px; x2:1110px; y2:39px; "/>
  148. <caption id="caption278" class="tit_2" style="left:5px; top:54px; width:162px; height:14px; ">부서별휴가사용</caption>
  149. <line id="line207" class="line_1" style="x1:0px; y1:69px; x2:1195px; y2:69px; "/>
  150. <datagrid id="grd_dutsumlist" nodeset="/root/main/list/deptprvaliuselist" backcoloralternate="transparent" caption="기관코드^기관명^부서코드^부 서^직위^사원번호^성명^연차^보휴^발생계^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^년차&#xA;사용계^보휴&#xA;사용계^잔여일수^사용율^입사일자^퇴사일자" colsep="^" colwidth="0, 0, 0, 134, 76, 70, 58, 43, 43, 43, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 45, 45, 55, 50, 74, 76" dataheight="25" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:74px; width:1195px; height:661px; ">
  151. <col ref="instcd" visibility="visible"/>
  152. <col ref="instnm" visibility="visible"/>
  153. <col ref="dutplcedeptcd" visibility="visible"/>
  154. <col ref="deptnm" style="text-align:left; "/>
  155. <col ref="jobposnm" style="text-align:left; "/>
  156. <col ref="emplno" style="text-align:center; "/>
  157. <col ref="emplnm" style="text-align:center; "/>
  158. <col ref="yearno" savetype="digit" style="text-align:right; padding-right:1; "/>
  159. <col ref="healholi" visibility="hidden" savetype="digit" style="text-align:right; padding-right:1; "/>
  160. <col ref="genrsum" visibility="hidden" savetype="digit" style="text-align:right; padding-right:1; "/>
  161. <col ref="jan" savetype="digit" style="text-align:right; padding-right:1; "/>
  162. <col ref="feb" savetype="digit" style="text-align:right; padding-right:1; "/>
  163. <col ref="mar" savetype="digit" style="text-align:right; padding-right:1; "/>
  164. <col ref="apr" savetype="digit" style="text-align:right; padding-right:1; "/>
  165. <col ref="may" savetype="digit" style="text-align:right; padding-right:1; "/>
  166. <col ref="jun" savetype="digit" style="text-align:right; padding-right:1; "/>
  167. <col ref="jul" savetype="digit" style="text-align:right; padding-right:1; "/>
  168. <col ref="aug" savetype="digit" style="text-align:right; padding-right:1; "/>
  169. <col ref="sep" savetype="digit" style="text-align:right; padding-right:1; "/>
  170. <col ref="oct" savetype="digit" style="text-align:right; padding-right:1; "/>
  171. <col ref="nov" savetype="digit" style="text-align:right; padding-right:1; "/>
  172. <col ref="dec" savetype="digit" style="text-align:right; padding-right:1; "/>
  173. <col ref="usesum" savetype="digit" style="text-align:right; padding-right:1; "/>
  174. <col ref="usecaresum" visibility="hidden" savetype="digit" style="text-align:right; padding-right:1; "/>
  175. <col ref="spresum" savetype="digit" style="text-align:right; padding-right:1; "/>
  176. <col ref="userate" format="###.0 %" savetype="digit" style="text-align:right; padding-right:1; "/>
  177. <col ref="entcodd" format="yyyy-mm-dd" style="text-align:center; "/>
  178. <col ref="retiredd" format="yyyy-mm-dd" style="text-align:center; "/>
  179. <script type="javascript" ev:event="onaftersort">
  180. <![CDATA[
  181. grd_dutsumlist.gridToInstance();
  182. ]]>
  183. </script>
  184. </datagrid>
  185. <caption id="caption5" class="search_name" style="left:10px; top:19px; width:86px; height:17px; ">소속기관 :</caption>
  186. <caption id="caption1" class="search_name" style="left:260px; top:19px; width:112px; height:17px; ">기준년도 :</caption>
  187. <select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_search" disabled="true" navindex="1" appearance="minimal" style="left:98px; top:18px; width:145px; height:19px; ">
  188. <choices>
  189. <itemset>
  190. <label/>
  191. <value/>
  192. </itemset>
  193. </choices>
  194. </select1>
  195. <button id="btn_dutdept" class="icon_search" style="left:601px; top:20px; width:16px; height:16px; ">
  196. <caption/>
  197. <script type="javascript" ev:event="DOMActivate">
  198. <![CDATA[
  199. // misfOpenPopUpList("02", ipt_dutdeptcd, "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd");
  200. misfOpenPopUpList("02", ipt_dutdeptcd,"","dutunitcd,dutunitnm", cmb_instcd.value + "," + ipt_dutym.value+"31", "instcd,basedd");
  201. model.refresh();
  202. ]]>
  203. </script>
  204. </button>
  205. <caption id="caption2" class="search_name" style="left:437px; top:19px; width:88px; height:17px; ">소속부서 :</caption>
  206. <input id="ipt_dutdeptnm" ref="/root/send/retrparams/dutunitnm" class="input_search" navindex="4" style="left:619px; top:18px; width:99px; height:19px; ">
  207. <script type="javascript" ev:event="onkeypress">
  208. <![CDATA[
  209. if(event.keyCode == 13) {
  210. if(ipt_dutdeptnm.value == ipt_dutdeptnm.currentText) return;
  211. ipt_dutdeptnm.value = ipt_dutdeptnm.currentText;
  212. misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
  213. model.refresh();
  214. }
  215. ]]>
  216. </script>
  217. <script type="javascript" ev:event="xforms-value-changed">
  218. <![CDATA[
  219. misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
  220. model.refresh();
  221. ]]>
  222. </script>
  223. </input>
  224. <input id="ipt_dutdeptcd" ref="/root/send/retrparams/dutunitcd" class="input_search" navindex="3" maxlength="10" style="left:523px; top:18px; width:75px; height:19px; text-align:center; ">
  225. <script type="javascript" ev:event="onkeypress">
  226. <![CDATA[
  227. if(event.keyCode == 13) {
  228. if(ipt_dutdeptcd.value == ipt_dutdeptcd.currentText) return;
  229. ipt_dutdeptcd.value = ipt_dutdeptcd.currentText;
  230. misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
  231. model.refresh();
  232. }
  233. ]]>
  234. </script>
  235. <script type="javascript" ev:event="xforms-value-changed">
  236. <![CDATA[
  237. misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
  238. model.refresh();
  239. ]]>
  240. </script>
  241. </input>
  242. <button id="btn_search" class="btn1_letter2" style="left:1125px; top:17px; width:56px; height:22px; ">
  243. <caption>조회</caption>
  244. <script type="javascript" ev:event="DOMActivate">
  245. <![CDATA[
  246. fRetrieve();
  247. fSet1YearNurse() ;
  248. ]]>
  249. </script>
  250. </button>
  251. <button id="button1" class="btn2_letter4" style="left:1128px; top:49px; width:64px; height:19px; ">
  252. <caption>엑셀저장</caption>
  253. <script type="javascript" ev:event="DOMActivate">
  254. <![CDATA[
  255. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  256. if (fileName != ""){
  257. grd_dutsumlist.saveExcel(fileName, "sheetname:savetype", true, true, "", "");
  258. }
  259. ]]>
  260. </script>
  261. </button>
  262. <select1 id="cmb_prfshipflag" ref="/root/send/retrparams/prfshipflag" class="combo_search" navindex="7" appearance="minimal" style="left:942px; top:18px; width:98px; height:19px; ">
  263. <choices>
  264. <itemset>
  265. <label/>
  266. <value/>
  267. </itemset>
  268. </choices>
  269. </select1>
  270. <caption id="caption3" class="search_name" style="left:855px; top:19px; width:88px; height:17px; ">급여분류 :</caption>
  271. <input id="ipt_dutym" ref="/root/send/retrparams/dutyy" maxlength="4" style="left:350px; top:18px; width:60px; height:19px; text-align:center; "/>
  272. <select1 id="combo1" ref="/root/send/retrparams/deptgb" appearance="minimal" style="left:725px; top:18px; width:100px; height:19px; ">
  273. <choices>
  274. <item>
  275. <label>근무지</label>
  276. <value>1</value>
  277. </item>
  278. <item>
  279. <label>소속부서</label>
  280. <value>2</value>
  281. </item>
  282. <item>
  283. <label>소속과(팀)</label>
  284. <value>3</value>
  285. </item>
  286. <item>
  287. <label>소속부(실)</label>
  288. <value>4</value>
  289. </item>
  290. </choices>
  291. </select1>
  292. <select1 id="cmb_dutplce" ref="/root/send/retrparams/dutunitcd" class="combo_search" visibility="visible" appearance="minimal" style="left:523px; top:18px; width:195px; height:19px; ">
  293. <choices>
  294. <itemset>
  295. <label/>
  296. <value/>
  297. </itemset>
  298. </choices>
  299. <script type="javascript" ev:event="xforms-value-changed">
  300. <![CDATA[
  301. btn_search.dispatch("DOMActivate");
  302. ]]>
  303. </script>
  304. </select1>
  305. </group>
  306. <group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
  307. <line id="line4" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25; "/>
  308. <button id="btn_print" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
  309. <caption>출력</caption>
  310. <script type="javascript" ev:event="DOMActivate">
  311. <![CDATA[
  312. fPrint();
  313. ]]>
  314. </script>
  315. </button>
  316. </group>
  317. </xhtml:body>
  318. </xhtml:html>