SMRWS00400_급여연봉및평균임금조회.xrw 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674
  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. <payspecdata>
  11. <payamtlist/>
  12. <paytitlelist/>
  13. </payspecdata>
  14. <yypayavg>
  15. <yypayavglist/>
  16. <paytitlelist/>
  17. </yypayavg>
  18. <avgpayamtyy>
  19. <avgpayamtyylist/>
  20. </avgpayamtyy>
  21. </main>
  22. <init>
  23. <temp/>
  24. </init>
  25. <send>
  26. <payspec>
  27. <workflag>X</workflag>
  28. <workym/>
  29. <saldfrayflag/>
  30. <instcd/>
  31. <jobgradcd/>
  32. <payclscd/>
  33. <payclsprfshipflag/>
  34. <holyordflag/>
  35. <prfshipflag/>
  36. <deptcd/>
  37. <deptnm/>
  38. <jobposcd/>
  39. <jobposnm/>
  40. <jobkindcd/>
  41. <jobkindnm/>
  42. <jobrespcd/>
  43. <jobrespnm/>
  44. <senirtyyn/>
  45. <licnalwnflag/>
  46. <hdfamyyn/>
  47. <maryyn/>
  48. <dutyy/>
  49. </payspec>
  50. <prtdata>
  51. <instnm/>
  52. <prtuser/>
  53. <payym/>
  54. </prtdata>
  55. <save>
  56. <paybugtincrlist/>
  57. </save>
  58. <yypayavg>
  59. <instcd/>
  60. <fromym/>
  61. <toym/>
  62. <prfshipflag/>
  63. <grupjoblncd/>
  64. <jobgradcd/>
  65. <payclscd/>
  66. </yypayavg>
  67. <avgpayamtyy>
  68. <instcd/>
  69. <workflag/>
  70. <workym/>
  71. <emplno/>
  72. </avgpayamtyy>
  73. </send>
  74. <hidden/>
  75. </root>
  76. </instance>
  77. <script type="javascript" ev:event="xforms-ready">
  78. <![CDATA[
  79. model.removeNodeset(grd_avgpayamtyylist.nodeset);
  80. model.refresh();
  81. var curdate = getCurrentDate();
  82. model.setValue(ipt_workym.attribute("ref") , curdate.substr(0,6));
  83. model.setValue(ipt_fromym.attribute("ref") , curdate.substr(0,6));
  84. model.setValue(ipt_toym.attribute("ref") , curdate.substr(0,6));
  85. model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
  86. model.setValue(cmb_instcd2.attribute("ref") , getUserInfo("dutplceinstcd"));
  87. model.setValue(cmb_holyordflag.attribute("ref") , "1");
  88. model.setValue(ipt_dutyy.attribute("ref") , "1");
  89. model.setValue(cmb_senirtyyn.attribute("ref") , "N");
  90. model.setValue(cmb_licnalwnflag.attribute("ref") , "Z");
  91. model.setValue(cmb_hdfamyyn.attribute("ref") , "N");
  92. model.setValue(cmb_maryyn.attribute("ref") , "N");
  93. model.setValue(cmb_SalDfrayFlag.attribute("ref"), "1");
  94. misfComboInstCdListMulti("cmb_instcd,cmb_instcd2",getCurrentDate(),"","N");
  95. misfComboComCdListMulti("R0112,R0064,R0098,R0058,R0066,R0097,R0233,R0126,R0121,R0120,R0058,R0059,R0064,R0098",
  96. "cmb_SalDfrayFlag,cmb_jobgradcd,cmb_payclscd,cmb_prfshipflag,cmb_holyordflag,cmb_payclsprfshipflag,cmb_senirtyyn,cmb_licnalwnflag,cmb_hdfamyyn,cmb_maryyn,cmb_prfshipflag2,cmb_grupjoblncd2,cmb_jobgradcd2,cmb_payclscd2");
  97. addComboItem( "cmb_SalDfrayFlag", "[-- 전체 --]", "%", "above");
  98. model.setValue(cmb_SalDfrayFlag.attribute("ref"), "%");
  99. addComboItem( "cmb_prfshipflag2", "[-- 전체 --]", "%", "above");
  100. model.setValue(cmb_prfshipflag2.attribute("ref"), "%");
  101. addComboItem( "cmb_grupjoblncd2", "[-- 전체 --]", "%", "above");
  102. model.setValue(cmb_grupjoblncd2.attribute("ref"), "%");
  103. addComboItem( "cmb_jobgradcd2", "[-- 전체 --]", "%", "above");
  104. model.setValue(cmb_jobgradcd2.attribute("ref"), "%");
  105. addComboItem( "cmb_payclscd2", "[-- 전체 --]", "%", "above");
  106. model.setValue(cmb_payclscd2.attribute("ref"), "%");
  107. // misfGetUserAuth();
  108. //
  109. // if (DUTY_PAY_YN == "Y" ) {
  110. // cmb_instcd.disabled = false;
  111. // }
  112. // else {
  113. // cmb_instcd.disabled = true;
  114. // }
  115. model.refresh();
  116. model.setFocus("ipt_workym");
  117. ]]>
  118. </script>
  119. <submission id="TRRWP02103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecexcel"/>
  120. <submission id="TRRWS00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
  121. <submission id="TXRWS00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/hidden/temp"/>
  122. <submission id="TXRWS00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
  123. <submission id="TRRWS00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/yypayavg" resultref="/root/main/yypayavg"/>
  124. <submission id="TRRWS00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/avgpayamtyy" resultref="/root/main/avgpayamtyy"/>
  125. </model>
  126. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  127. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  128. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  129. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  130. <script type="javascript" src="../../../com/batchinfoweb/js/ZSB001.js"/>
  131. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  132. <script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
  133. </xhtml:head>
  134. <xhtml:body style="margin-left:8; margin-right:8; ">
  135. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  136. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">급여 연봉 및 평균 임금 조회</caption>
  137. </group>
  138. <group id="group2" scroll="auto" style="left:0px; top:40px; width:1195px; height:740px; ">
  139. <switch id="switch1" style="left:0px; top:30px; width:1190px; height:705px; ">
  140. <case id="case2">
  141. <shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:5px; top:5px; width:1180px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
  142. <select1 id="cmb_jobgradcd2" ref="/root/send/yypayavg/jobgradcd" class="combo_s_essential" navindex="40" appearance="minimal" style="left:870px; top:15px; width:90px; height:19px; ">
  143. <choices>
  144. <itemset>
  145. <label/>
  146. <value/>
  147. </itemset>
  148. </choices>
  149. </select1>
  150. <select1 id="cmb_prfshipflag2" ref="/root/send/yypayavg/prfshipflag" class="combo_s_essential" navindex="80" appearance="minimal" style="left:535px; top:15px; width:95px; height:19px; ">
  151. <choices>
  152. <itemset>
  153. <label/>
  154. <value/>
  155. </itemset>
  156. </choices>
  157. </select1>
  158. <select1 id="cmb_payclscd2" ref="/root/send/yypayavg/payclscd" class="combo_s_essential" navindex="50" appearance="minimal" style="left:1020px; top:15px; width:93px; height:19px; ">
  159. <choices>
  160. <itemset>
  161. <label/>
  162. <value/>
  163. </itemset>
  164. </choices>
  165. </select1>
  166. <select1 id="cmb_instcd2" ref="/root/send/yypayavg/instcd" class="combo_s_essential" navindex="30" appearance="minimal" style="left:294px; top:15px; width:141px; height:19px; ">
  167. <choices>
  168. <itemset>
  169. <label/>
  170. <value/>
  171. </itemset>
  172. </choices>
  173. </select1>
  174. <caption id="caption17" class="search_name" style="left:815px; top:15px; width:55px; height:17px; ">직급:</caption>
  175. <caption id="caption18" class="search_name" style="left:965px; top:15px; width:58px; height:17px; ">호봉:</caption>
  176. <caption id="caption19" class="search_name" style="left:455px; top:15px; width:83px; height:17px; ">교직구분:</caption>
  177. <caption id="caption20" class="search_name" style="left:640px; top:15px; width:59px; height:17px; ">직군:</caption>
  178. <caption id="caption21" class="search_name" style="left:240px; top:15px; width:55px; height:17px; ">기관:</caption>
  179. <caption id="caption22" class="search_name" style="left:10px; top:15px; width:70px; height:17px; ">기간:</caption>
  180. <input id="ipt_fromym" ref="/root/send/yypayavg/fromym" class="input_default" navindex="10" inputtype="date" format="yyyy-mm" style="left:64px; top:15px; width:74px; height:19px; text-align:center; vertical-align:middle; "/>
  181. <select1 id="cmb_grupjoblncd2" ref="/root/send/yypayavg/grupjoblncd" class="combo_s_essential" navindex="20" appearance="minimal" style="left:696px; top:15px; width:109px; height:19px; ">
  182. <choices>
  183. <itemset>
  184. <label/>
  185. <value/>
  186. </itemset>
  187. </choices>
  188. </select1>
  189. <button id="btn_search2" class="btn1_letter2" style="left:1125px; top:13px; width:56px; height:22px; ">
  190. <caption>조회</caption>
  191. <script type="javascript" ev:event="DOMActivate">
  192. <![CDATA[
  193. if (grd_yypayavglist.nodeset.length> 0) {
  194. model.removeNodeset("/root/main/yypayavg/yypayavglist");
  195. grd_yypayavglist.nodeset = "/root/init/temp";
  196. for (var i = grd_yypayavglist.cols - 1; i >= 1 ; i--) {
  197. grd_yypayavglist.removeColumn(false);
  198. }
  199. grd_yypayavglist.caption = "";
  200. model.refresh();
  201. grd_yypayavglist.rebuild();
  202. }
  203. submit("TRRWS00401");
  204. var node = instance1.selectNodes("/root/main/yypayavg/yypayavglist[1]/*");
  205. var payitemcnt = model.getValue("/root/main/yypayavg/paytitlelist/payitemcnt") ;
  206. var payitemcnt2 = model.getValue("/root/main/yypayavg/paytitlelist/payitemcnt2") ;
  207. if (node.length > 0 ) {
  208. grd_yypayavglist.frozenCols = 4;
  209. for(i=0;i<payitemcnt;i++) {
  210. if (i < 4 ) {
  211. grd_yypayavglist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
  212. }
  213. else {
  214. grd_yypayavglist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
  215. }
  216. }
  217. //grd_payamtlist.frozenCols = 4;
  218. }
  219. grd_yypayavglist.caption = model.getValue("/root/main/yypayavg/paytitlelist/paytitle") + "|" + model.getValue("/root/main/yypayavg/paytitlelist/paytitle");
  220. grd_yypayavglist.nodeset = "/root/main/yypayavg/yypayavglist";
  221. grd_yypayavglist.rebuild();
  222. grd_yypayavglist.subtotalposition = "below";
  223. if (node.length > 0 ) {
  224. for(i=0;i<payitemcnt;i++) {
  225. if (i == 4 ) {
  226. grd_yypayavglist.subtotal("sum",-1 , grd_yypayavglist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");
  227. }
  228. else if (i > 4 ) {
  229. grd_yypayavglist.subtotal("average",-1 , grd_yypayavglist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");
  230. }
  231. }
  232. }
  233. // if (grd_paybugtincrlist.visible == true) {
  234. // submit("TRRWS00303");
  235. // }
  236. ]]>
  237. </script>
  238. </button>
  239. <line id="line13" class="line_4" style="x1:1120px; y1:5px; x2:1120px; y2:45px; "/>
  240. <input id="ipt_toym" ref="/root/send/yypayavg/toym" class="input_default" navindex="10" inputtype="date" format="yyyy-mm" style="left:147px; top:15px; width:74px; height:19px; text-align:center; vertical-align:middle; "/>
  241. <caption id="caption23" style="left:137px; top:15px; width:10px; height:19px; ">-</caption>
  242. <line id="line2" class="line_1" style="x1:0px; y1:70px; x2:1185px; y2:70px; "/>
  243. <button id="button3" class="btn2_letter4" style="left:1121px; top:48px; width:64px; height:19px; ">
  244. <caption>엑셀저장</caption>
  245. <script type="javascript" ev:event="DOMActivate">
  246. <![CDATA[
  247. var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  248. if (fileName != "")
  249. {
  250. grd_yypayavglist.saveExcel(fileName);
  251. window.exec(fileName);
  252. }
  253. ]]>
  254. </script>
  255. </button>
  256. <caption id="caption24" class="tit_2" style="left:7px; top:53px; width:144px; height:14px; ">평균 임금 List</caption>
  257. <datagrid id="grd_yypayavglist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:75px; width:1185px; height:620px; "/>
  258. </case>
  259. <case id="case1" selected="true">
  260. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:5px; top:5px; width:270px; height:695px; background-color:#fffbf2; border-color:#ffd799; "/>
  261. <select1 id="cmb_jobgradcd" ref="/root/send/payspec/jobgradcd" class="combo_s_essential" navindex="50" appearance="minimal" style="left:97px; top:148px; width:163px; height:19px; ">
  262. <choices>
  263. <itemset>
  264. <label/>
  265. <value/>
  266. </itemset>
  267. </choices>
  268. </select1>
  269. <button id="btn_saveexcel" class="btn2_letter4" style="left:1118px; top:6px; width:64px; height:19px; ">
  270. <caption>엑셀저장</caption>
  271. <script type="javascript" ev:event="DOMActivate">
  272. <![CDATA[
  273. var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  274. if (fileName != "")
  275. {
  276. grd_payamtlist.saveExcel(fileName);
  277. window.exec(fileName);
  278. }
  279. ]]>
  280. </script>
  281. </button>
  282. <line id="line9" class="line_1" style="x1:278px; y1:28px; x2:1186px; y2:28px; "/>
  283. <select1 id="cmb_prfshipflag" ref="/root/send/payspec/prfshipflag" class="combo_s_essential" navindex="40" appearance="minimal" style="left:97px; top:115px; width:163px; height:19px; ">
  284. <choices>
  285. <itemset>
  286. <label/>
  287. <value/>
  288. </itemset>
  289. </choices>
  290. </select1>
  291. <select1 id="cmb_payclscd" ref="/root/send/payspec/payclscd" class="combo_s_essential" navindex="60" appearance="minimal" style="left:97px; top:181px; width:163px; height:19px; ">
  292. <choices>
  293. <itemset>
  294. <label/>
  295. <value/>
  296. </itemset>
  297. </choices>
  298. </select1>
  299. <select1 id="cmb_instcd" ref="/root/send/payspec/instcd" class="combo_s_essential" navindex="30" appearance="minimal" style="left:97px; top:83px; width:163px; height:19px; ">
  300. <choices>
  301. <itemset>
  302. <label/>
  303. <value/>
  304. </itemset>
  305. </choices>
  306. </select1>
  307. <caption id="caption2" class="search_name" style="left:10px; top:148px; width:85px; height:17px; ">직 급:</caption>
  308. <caption id="caption3" class="search_name" style="left:10px; top:181px; width:85px; height:17px; ">호 봉:</caption>
  309. <caption id="caption34" class="tit_2" style="left:280px; top:11px; width:144px; height:14px; ">월 급여List</caption>
  310. <caption id="cap_SalDfrayFlag" class="search_name" style="left:10px; top:50px; width:91px; height:17px; ">급여 종류:</caption>
  311. <caption id="caption4" class="search_name" style="left:10px; top:115px; width:91px; height:17px; ">교직 구분:</caption>
  312. <caption id="cap_workym" class="search_name" style="left:10px; top:15px; width:88px; height:17px; ">기 준 월:</caption>
  313. <caption id="cap_instcd" class="search_name" style="left:10px; top:83px; width:85px; height:17px; ">기 관:</caption>
  314. <input id="ipt_workym" ref="/root/send/payspec/workym" class="input_default" navindex="10" inputtype="date" format="yyyy-mm" style="left:97px; top:15px; width:101px; height:19px; text-align:center; vertical-align:middle; "/>
  315. <button id="btn_search" class="btn1_letter2" style="left:204px; top:15px; width:56px; height:22px; ">
  316. <caption>조회</caption>
  317. <script type="javascript" ev:event="DOMActivate">
  318. <![CDATA[
  319. model.removeNodeset(grd_avgpayamtyylist.nodeset);
  320. if (grd_payamtlist.nodeset.length> 0) {
  321. model.removeNodeset("/root/main/payspecdata/payamtlist");
  322. grd_payamtlist.nodeset = "/root/init/temp";
  323. for (var i = grd_payamtlist.cols - 1; i >= 1 ; i--) {
  324. grd_payamtlist.removeColumn(false);
  325. }
  326. grd_payamtlist.caption = "";
  327. model.refresh();
  328. grd_payamtlist.rebuild();
  329. }
  330. submit("TXRWS00401");
  331. var node = instance1.selectNodes("/root/main/payspecdata/payamtlist[1]/*");
  332. var payitemcnt = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt") ;
  333. var payitemcnt2 = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt2") ;
  334. if (node.length > 0 ) {
  335. grd_payamtlist.frozenCols = 4;
  336. for(i=0;i<payitemcnt;i++) {
  337. if (i < 4 ) {
  338. grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
  339. }
  340. else if (i == payitemcnt - 1) {
  341. grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + "visibility:hidden;", false);
  342. }
  343. else {
  344. grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
  345. }
  346. }
  347. //grd_payamtlist.frozenCols = 4;
  348. }
  349. grd_payamtlist.caption = model.getValue("/root/main/payspecdata/paytitlelist/paytitle") + "|" + model.getValue("/root/main/payspecdata/paytitlelist/paytitle");
  350. grd_payamtlist.nodeset = "/root/main/payspecdata/payamtlist";
  351. grd_payamtlist.rebuild();
  352. // grd_payamtlist.subtotalposition = "below";
  353. // if (node.length > 0 ) {
  354. // for(i=0;i<payitemcnt;i++) {
  355. // if (i >= 4 ) {
  356. // grd_payamtlist.subtotal("sum",-1 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  357. // grd_payamtlist.subTotal("sum", 2 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#f99999; font-weight:bold; ", 1, "소계");
  358. //
  359. // }
  360. // }
  361. // }
  362. // if (grd_paybugtincrlist.visible == true) {
  363. // submit("TRRWS00303");
  364. // }
  365. ]]>
  366. </script>
  367. </button>
  368. <select1 id="cmb_SalDfrayFlag" ref="/root/send/payspec/saldfrayflag" class="combo_s_essential" navindex="20" appearance="minimal" style="left:97px; top:50px; width:163px; height:19px; ">
  369. <choices>
  370. <itemset>
  371. <label/>
  372. <value/>
  373. </itemset>
  374. </choices>
  375. </select1>
  376. <datagrid id="grd_payamtlist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:278px; top:33px; width:908px; height:272px; ">
  377. <script type="javascript" ev:event="onrowchanged">
  378. <![CDATA[
  379. model.setValue("/root/send/avgpayamtyy/instcd", cmb_instcd.value);
  380. model.setValue("/root/send/avgpayamtyy/workflag", "X");
  381. model.setValue("/root/send/avgpayamtyy/workym", ipt_workym.value);
  382. var emplno = "";
  383. emplno = grd_payamtlist.valueMatrix(grd_payamtlist.row, grd_payamtlist.colRef(grd_payamtlist.colAttribute(grd_payamtlist.cols-1, "ref")));
  384. model.setValue("/root/send/avgpayamtyy/emplno", emplno);
  385. submit("TRRWS00402");
  386. grd_payamtlist.dispatch("onmouseup");
  387. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("payavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  388. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("bnusavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  389. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("dutavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  390. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("festavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  391. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("stdyavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  392. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("mediavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  393. grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("totamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
  394. ]]>
  395. </script>
  396. </datagrid>
  397. <select1 id="cmb_holyordflag" ref="/root/send/payspec/holyordflag" class="combo_s_essential" navindex="120" appearance="minimal" style="left:97px; top:380px; width:163px; height:19px; ">
  398. <choices>
  399. <itemset>
  400. <label/>
  401. <value/>
  402. </itemset>
  403. </choices>
  404. </select1>
  405. <caption id="caption1" class="search_name" style="left:10px; top:380px; width:91px; height:17px; ">성직 구분:</caption>
  406. <input id="ipt_deptnm" ref="/root/send/payspec/deptnm" class="input_default" navindex="70" style="left:97px; top:214px; width:143px; height:19px; ">
  407. <script type="javascript" ev:event="xforms-value-changed">
  408. <![CDATA[
  409. misfValidationCheck("02", "", "deptcd,deptnm" );
  410. model.refresh();
  411. ]]>
  412. </script>
  413. </input>
  414. <button id="btn_deptcd" class="icon_search" style="left:244px; top:215px; width:16px; height:16px; ">
  415. <caption/>
  416. <script type="javascript" ev:event="DOMActivate">
  417. <![CDATA[
  418. var recv_list = "deptcd,deptnm";
  419. var instcd = cmb_instcd.value;
  420. rpbfOpenDeptCdHelp(ipt_deptcd,recv_list, instcd, "instcd");
  421. model.refresh();
  422. ]]>
  423. </script>
  424. </button>
  425. <input id="ipt_deptcd" ref="/root/send/payspec/deptcd" class="input_default" visibility="hidden" style="left:97px; top:214px; width:40px; height:19px; ">
  426. <script type="javascript" ev:event="xforms-value-changed">
  427. <![CDATA[
  428. var recv_list = "emplno,emplnm" ;
  429. rpbfValidationCheck("EMPLNO", recv_list);
  430. model.refresh();
  431. ]]>
  432. </script>
  433. </input>
  434. <caption id="caption5" class="search_name" style="left:10px; top:214px; width:91px; height:17px; ">근무 부서:</caption>
  435. <input id="ipt_jobposnm" ref="/root/send/payspec/jobposnm" class="input_default" navindex="80" style="left:97px; top:247px; width:143px; height:19px; ">
  436. <script type="javascript" ev:event="xforms-value-changed">
  437. <![CDATA[
  438. misfValidationCheck("03", "R0062", "jobposcd,jobposnm" );
  439. model.refresh();
  440. ]]>
  441. </script>
  442. </input>
  443. <button id="btn_jobposcd" class="icon_search" style="left:244px; top:249px; width:16px; height:16px; ">
  444. <caption/>
  445. <script type="javascript" ev:event="DOMActivate">
  446. <![CDATA[
  447. var recv_list = "jobposcd,jobposnm";
  448. rpbfOpenComCdHelp(ipt_jobposcd,"R0062", recv_list);
  449. model.refresh();
  450. ]]>
  451. </script>
  452. </button>
  453. <caption id="caption7" class="search_name" style="left:10px; top:247px; width:92px; height:17px; ">직 위:</caption>
  454. <input id="ipt_jobposcd" ref="/root/send/payspec/jobposcd" class="input_default" visibility="hidden" style="left:97px; top:247px; width:40px; height:19px; ">
  455. <script type="javascript" ev:event="xforms-value-changed">
  456. <![CDATA[
  457. var recv_list = "emplno,emplnm" ;
  458. rpbfValidationCheck("EMPLNO", recv_list);
  459. model.refresh();
  460. ]]>
  461. </script>
  462. </input>
  463. <button id="btn_jobkindcd" class="icon_search" style="left:244px; top:281px; width:16px; height:16px; ">
  464. <caption/>
  465. <script type="javascript" ev:event="DOMActivate">
  466. <![CDATA[
  467. var recv_list = "jobkindcd,jobkindnm";
  468. rpbfOpenComCdHelp(ipt_jobkindcd,"R0061", recv_list);
  469. model.refresh();
  470. ]]>
  471. </script>
  472. </button>
  473. <input id="ipt_jobkindnm" ref="/root/send/payspec/jobkindnm" class="input_default" navindex="90" style="left:97px; top:280px; width:143px; height:19px; ">
  474. <script type="javascript" ev:event="xforms-value-changed">
  475. <![CDATA[
  476. misfValidationCheck("03", "R0061", "jobkindcd,jobkindnm" );
  477. model.refresh();
  478. ]]>
  479. </script>
  480. </input>
  481. <input id="ipt_jobkindcd" ref="/root/send/payspec/jobkindcd" class="input_default" visibility="hidden" style="left:97px; top:280px; width:40px; height:19px; ">
  482. <script type="javascript" ev:event="xforms-value-changed">
  483. <![CDATA[
  484. var recv_list = "emplno,emplnm" ;
  485. rpbfValidationCheck("EMPLNO", recv_list);
  486. model.refresh();
  487. ]]>
  488. </script>
  489. </input>
  490. <caption id="caption8" class="search_name" style="left:10px; top:280px; width:92px; height:17px; ">직 종:</caption>
  491. <select1 id="cmb_payclsprfshipflag" ref="/root/send/payspec/payclsprfshipflag" class="combo_s_essential" navindex="110" appearance="minimal" style="left:97px; top:346px; width:163px; height:19px; ">
  492. <choices>
  493. <itemset>
  494. <label/>
  495. <value/>
  496. </itemset>
  497. </choices>
  498. </select1>
  499. <caption id="caption9" class="search_name" style="left:10px; top:346px; width:86px; height:17px; ">호봉 교직:</caption>
  500. <button id="btn_jobrespcd" class="icon_search" style="left:244px; top:314px; width:16px; height:16px; ">
  501. <caption/>
  502. <script type="javascript" ev:event="DOMActivate">
  503. <![CDATA[
  504. var recv_list = "jobrespcd,jobrespnm";
  505. rpbfOpenComCdHelp(ipt_jobrespcd,"R0063", recv_list);
  506. model.refresh();
  507. ]]>
  508. </script>
  509. </button>
  510. <caption id="caption10" class="search_name" style="left:10px; top:313px; width:92px; height:17px; ">직 책:</caption>
  511. <input id="ipt_jobrespnm" ref="/root/send/payspec/jobrespnm" class="input_default" navindex="100" style="left:97px; top:313px; width:143px; height:19px; ">
  512. <script type="javascript" ev:event="xforms-value-changed">
  513. <![CDATA[
  514. misfValidationCheck("03", "R0063", "jobrespcd,jobrespnm" );
  515. model.refresh();
  516. ]]>
  517. </script>
  518. </input>
  519. <input id="ipt_jobrespcd" ref="/root/send/payspec/jobrespcd" class="input_default" visibility="hidden" style="left:97px; top:313px; width:40px; height:19px; ">
  520. <script type="javascript" ev:event="xforms-value-changed">
  521. <![CDATA[
  522. var recv_list = "emplno,emplnm" ;
  523. rpbfValidationCheck("EMPLNO", recv_list);
  524. model.refresh();
  525. ]]>
  526. </script>
  527. </input>
  528. <select1 id="cmb_senirtyyn" ref="/root/send/payspec/senirtyyn" class="combo_s_essential" navindex="130" appearance="minimal" style="left:97px; top:412px; width:163px; height:19px; ">
  529. <choices>
  530. <itemset>
  531. <label/>
  532. <value/>
  533. </itemset>
  534. </choices>
  535. </select1>
  536. <caption id="caption11" class="search_name" style="left:10px; top:412px; width:91px; height:17px; ">선임 여부:</caption>
  537. <caption id="caption12" class="search_name" style="left:10px; top:445px; width:91px; height:17px; ">면허 구분:</caption>
  538. <select1 id="cmb_licnalwnflag" ref="/root/send/payspec/licnalwnflag" class="combo_s_essential" navindex="140" appearance="minimal" style="left:97px; top:445px; width:163px; height:19px; ">
  539. <choices>
  540. <itemset>
  541. <label/>
  542. <value/>
  543. </itemset>
  544. </choices>
  545. </select1>
  546. <caption id="caption13" class="search_name" style="left:10px; top:478px; width:91px; height:17px; ">가장 여부:</caption>
  547. <select1 id="cmb_hdfamyyn" ref="/root/send/payspec/hdfamyyn" class="combo_s_essential" navindex="150" appearance="minimal" style="left:97px; top:478px; width:163px; height:19px; ">
  548. <choices>
  549. <itemset>
  550. <label/>
  551. <value/>
  552. </itemset>
  553. </choices>
  554. </select1>
  555. <caption id="caption14" class="search_name" style="left:10px; top:511px; width:101px; height:17px; ">결혼 여부:</caption>
  556. <select1 id="cmb_maryyn" ref="/root/send/payspec/maryyn" class="combo_s_essential" navindex="160" appearance="minimal" style="left:97px; top:511px; width:163px; height:19px; ">
  557. <choices>
  558. <itemset>
  559. <label/>
  560. <value/>
  561. </itemset>
  562. </choices>
  563. </select1>
  564. <caption id="caption15" class="search_name" style="left:10px; top:545px; width:88px; height:17px; ">근속 년수:</caption>
  565. <input id="ipt_dutyy" ref="/root/send/payspec/dutyy" class="input_default" navindex="170" style="left:97px; top:545px; width:163px; height:19px; text-align:center; vertical-align:middle; "/>
  566. <line id="line1" class="line_1" style="x1:278px; y1:330px; x2:1186px; y2:330px; "/>
  567. <button id="btn_yyavgexcel" class="btn2_letter4" style="left:1120px; top:308px; width:64px; height:19px; ">
  568. <caption>엑셀저장</caption>
  569. <script type="javascript" ev:event="DOMActivate">
  570. <![CDATA[
  571. var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  572. if (fileName != "")
  573. {
  574. grd_avgpayamtyylist.saveExcel(fileName);
  575. window.exec(fileName);
  576. }
  577. ]]>
  578. </script>
  579. </button>
  580. <caption id="caption16" class="tit_2" style="left:280px; top:313px; width:144px; height:13px; ">년 급여List</caption>
  581. <datagrid id="grd_avgpayamtyylist" nodeset="/root/main/avgpayamtyy/avgpayamtyylist" caption="교직구분^직급^호봉^지급월^급여^상여^정근수당^명절수당^연구보조비^진료수당^합계|교직구분^직급^호봉^지급월^급여^상여^정근수당^명절수당^연구보조비^진료수당^합계" colsep="^" colwidth="80, 73, 51, 76, 87, 85, 78, 76, 80, 79, 107" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:278px; top:335px; width:908px; height:365px; ">
  582. <col ref="prfshipflagnm"/>
  583. <col ref="jobgradnm"/>
  584. <col ref="payclsnm"/>
  585. <col ref="payym" format="yyyy-mm" style="text-align:center; vertical-align:middle; "/>
  586. <col ref="payavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  587. <col ref="bnusavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  588. <col ref="dutavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  589. <col ref="festavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  590. <col ref="stdyavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  591. <col ref="mediavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
  592. <col ref="totamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
  593. </datagrid>
  594. </case>
  595. </switch>
  596. <button id="button1" class="btn_sw" group="tab" selected="true" style="left:5px; top:5px; width:80px; height:22px; ">
  597. <caption>연봉계산</caption>
  598. <script type="javascript" ev:event="DOMActivate">
  599. <![CDATA[
  600. model.toggle("case1");
  601. ]]>
  602. </script>
  603. </button>
  604. <button id="button2" class="btn_sw" group="tab" selected="false" style="left:88px; top:5px; width:80px; height:22px; ">
  605. <caption>평균임금</caption>
  606. <script type="javascript" ev:event="DOMActivate">
  607. <![CDATA[
  608. model.toggle("case2");
  609. ]]>
  610. </script>
  611. </button>
  612. </group>
  613. <group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
  614. </xhtml:body>
  615. </xhtml:html>