123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
- <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">
- <xhtml:head>
- <xhtml:title>급여 연봉 및 평균 임금 조회</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <payspecdata>
- <payamtlist/>
- <paytitlelist/>
- </payspecdata>
- <yypayavg>
- <yypayavglist/>
- <paytitlelist/>
- </yypayavg>
- <avgpayamtyy>
- <avgpayamtyylist/>
- </avgpayamtyy>
- </main>
- <init>
- <temp/>
- </init>
- <send>
- <payspec>
- <workflag>X</workflag>
- <workym/>
- <saldfrayflag/>
- <instcd/>
- <jobgradcd/>
- <payclscd/>
- <payclsprfshipflag/>
- <holyordflag/>
- <prfshipflag/>
- <deptcd/>
- <deptnm/>
- <jobposcd/>
- <jobposnm/>
- <jobkindcd/>
- <jobkindnm/>
- <jobrespcd/>
- <jobrespnm/>
- <senirtyyn/>
- <licnalwnflag/>
- <hdfamyyn/>
- <maryyn/>
- <dutyy/>
- </payspec>
- <prtdata>
- <instnm/>
- <prtuser/>
- <payym/>
- </prtdata>
- <save>
- <paybugtincrlist/>
- </save>
- <yypayavg>
- <instcd/>
- <fromym/>
- <toym/>
- <prfshipflag/>
- <grupjoblncd/>
- <jobgradcd/>
- <payclscd/>
- </yypayavg>
- <avgpayamtyy>
- <instcd/>
- <workflag/>
- <workym/>
- <emplno/>
- </avgpayamtyy>
- </send>
- <hidden/>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- model.removeNodeset(grd_avgpayamtyylist.nodeset);
- model.refresh();
-
- var curdate = getCurrentDate();
-
- model.setValue(ipt_workym.attribute("ref") , curdate.substr(0,6));
- model.setValue(ipt_fromym.attribute("ref") , curdate.substr(0,6));
- model.setValue(ipt_toym.attribute("ref") , curdate.substr(0,6));
-
- model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
- model.setValue(cmb_instcd2.attribute("ref") , getUserInfo("dutplceinstcd"));
- model.setValue(cmb_holyordflag.attribute("ref") , "1");
- model.setValue(ipt_dutyy.attribute("ref") , "1");
- model.setValue(cmb_senirtyyn.attribute("ref") , "N");
- model.setValue(cmb_licnalwnflag.attribute("ref") , "Z");
- model.setValue(cmb_hdfamyyn.attribute("ref") , "N");
- model.setValue(cmb_maryyn.attribute("ref") , "N");
-
- model.setValue(cmb_SalDfrayFlag.attribute("ref"), "1");
-
- misfComboInstCdListMulti("cmb_instcd,cmb_instcd2",getCurrentDate(),"","N");
-
- misfComboComCdListMulti("R0112,R0064,R0098,R0058,R0066,R0097,R0233,R0126,R0121,R0120,R0058,R0059,R0064,R0098",
- "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");
-
- addComboItem( "cmb_SalDfrayFlag", "[-- 전체 --]", "%", "above");
- model.setValue(cmb_SalDfrayFlag.attribute("ref"), "%");
-
- addComboItem( "cmb_prfshipflag2", "[-- 전체 --]", "%", "above");
- model.setValue(cmb_prfshipflag2.attribute("ref"), "%");
-
- addComboItem( "cmb_grupjoblncd2", "[-- 전체 --]", "%", "above");
- model.setValue(cmb_grupjoblncd2.attribute("ref"), "%");
-
- addComboItem( "cmb_jobgradcd2", "[-- 전체 --]", "%", "above");
- model.setValue(cmb_jobgradcd2.attribute("ref"), "%");
-
- addComboItem( "cmb_payclscd2", "[-- 전체 --]", "%", "above");
- model.setValue(cmb_payclscd2.attribute("ref"), "%");
-
-
- // misfGetUserAuth();
- //
- // if (DUTY_PAY_YN == "Y" ) {
- // cmb_instcd.disabled = false;
- // }
- // else {
- // cmb_instcd.disabled = true;
- // }
-
- model.refresh();
-
-
- model.setFocus("ipt_workym");
- ]]>
- </script>
- <submission id="TRRWP02103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecexcel"/>
- <submission id="TRRWS00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
- <submission id="TXRWS00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/hidden/temp"/>
- <submission id="TXRWS00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
- <submission id="TRRWS00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/yypayavg" resultref="/root/main/yypayavg"/>
- <submission id="TRRWS00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/avgpayamtyy" resultref="/root/main/avgpayamtyy"/>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../com/batchinfoweb/js/ZSB001.js"/>
- <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
- <script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
- </xhtml:head>
- <xhtml:body style="margin-left:8; margin-right:8; ">
- <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
- <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">급여 연봉 및 평균 임금 조회</caption>
- </group>
- <group id="group2" scroll="auto" style="left:0px; top:40px; width:1195px; height:740px; ">
- <switch id="switch1" style="left:0px; top:30px; width:1190px; height:705px; ">
- <case id="case2">
- <shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:5px; top:5px; width:1180px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption17" class="search_name" style="left:815px; top:15px; width:55px; height:17px; ">직급:</caption>
- <caption id="caption18" class="search_name" style="left:965px; top:15px; width:58px; height:17px; ">호봉:</caption>
- <caption id="caption19" class="search_name" style="left:455px; top:15px; width:83px; height:17px; ">교직구분:</caption>
- <caption id="caption20" class="search_name" style="left:640px; top:15px; width:59px; height:17px; ">직군:</caption>
- <caption id="caption21" class="search_name" style="left:240px; top:15px; width:55px; height:17px; ">기관:</caption>
- <caption id="caption22" class="search_name" style="left:10px; top:15px; width:70px; height:17px; ">기간:</caption>
- <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; "/>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <button id="btn_search2" class="btn1_letter2" style="left:1125px; top:13px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- if (grd_yypayavglist.nodeset.length> 0) {
-
- model.removeNodeset("/root/main/yypayavg/yypayavglist");
- grd_yypayavglist.nodeset = "/root/init/temp";
-
- for (var i = grd_yypayavglist.cols - 1; i >= 1 ; i--) {
- grd_yypayavglist.removeColumn(false);
-
- }
- grd_yypayavglist.caption = "";
-
- model.refresh();
- grd_yypayavglist.rebuild();
-
- }
-
-
- submit("TRRWS00401");
-
-
- var node = instance1.selectNodes("/root/main/yypayavg/yypayavglist[1]/*");
-
- var payitemcnt = model.getValue("/root/main/yypayavg/paytitlelist/payitemcnt") ;
- var payitemcnt2 = model.getValue("/root/main/yypayavg/paytitlelist/payitemcnt2") ;
-
- if (node.length > 0 ) {
- grd_yypayavglist.frozenCols = 4;
-
- for(i=0;i<payitemcnt;i++) {
- if (i < 4 ) {
- grd_yypayavglist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
- }
- else {
- grd_yypayavglist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
- }
- }
- //grd_payamtlist.frozenCols = 4;
- }
- grd_yypayavglist.caption = model.getValue("/root/main/yypayavg/paytitlelist/paytitle") + "|" + model.getValue("/root/main/yypayavg/paytitlelist/paytitle");
- grd_yypayavglist.nodeset = "/root/main/yypayavg/yypayavglist";
- grd_yypayavglist.rebuild();
-
- grd_yypayavglist.subtotalposition = "below";
- if (node.length > 0 ) {
- for(i=0;i<payitemcnt;i++) {
- if (i == 4 ) {
- grd_yypayavglist.subtotal("sum",-1 , grd_yypayavglist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");
- }
- else if (i > 4 ) {
- grd_yypayavglist.subtotal("average",-1 , grd_yypayavglist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");
-
- }
- }
- }
-
- // if (grd_paybugtincrlist.visible == true) {
- // submit("TRRWS00303");
- // }
- ]]>
- </script>
- </button>
- <line id="line13" class="line_4" style="x1:1120px; y1:5px; x2:1120px; y2:45px; "/>
- <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; "/>
- <caption id="caption23" style="left:137px; top:15px; width:10px; height:19px; ">-</caption>
- <line id="line2" class="line_1" style="x1:0px; y1:70px; x2:1185px; y2:70px; "/>
- <button id="button3" class="btn2_letter4" style="left:1121px; top:48px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if (fileName != "")
- {
- grd_yypayavglist.saveExcel(fileName);
- window.exec(fileName);
- }
- ]]>
- </script>
- </button>
- <caption id="caption24" class="tit_2" style="left:7px; top:53px; width:144px; height:14px; ">평균 임금 List</caption>
- <datagrid id="grd_yypayavglist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:75px; width:1185px; height:620px; "/>
- </case>
- <case id="case1" selected="true">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:5px; top:5px; width:270px; height:695px; background-color:#fffbf2; border-color:#ffd799; "/>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <button id="btn_saveexcel" class="btn2_letter4" style="left:1118px; top:6px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if (fileName != "")
- {
- grd_payamtlist.saveExcel(fileName);
- window.exec(fileName);
- }
- ]]>
- </script>
- </button>
- <line id="line9" class="line_1" style="x1:278px; y1:28px; x2:1186px; y2:28px; "/>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption2" class="search_name" style="left:10px; top:148px; width:85px; height:17px; ">직 급:</caption>
- <caption id="caption3" class="search_name" style="left:10px; top:181px; width:85px; height:17px; ">호 봉:</caption>
- <caption id="caption34" class="tit_2" style="left:280px; top:11px; width:144px; height:14px; ">월 급여List</caption>
- <caption id="cap_SalDfrayFlag" class="search_name" style="left:10px; top:50px; width:91px; height:17px; ">급여 종류:</caption>
- <caption id="caption4" class="search_name" style="left:10px; top:115px; width:91px; height:17px; ">교직 구분:</caption>
- <caption id="cap_workym" class="search_name" style="left:10px; top:15px; width:88px; height:17px; ">기 준 월:</caption>
- <caption id="cap_instcd" class="search_name" style="left:10px; top:83px; width:85px; height:17px; ">기 관:</caption>
- <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; "/>
- <button id="btn_search" class="btn1_letter2" style="left:204px; top:15px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.removeNodeset(grd_avgpayamtyylist.nodeset);
-
- if (grd_payamtlist.nodeset.length> 0) {
-
- model.removeNodeset("/root/main/payspecdata/payamtlist");
- grd_payamtlist.nodeset = "/root/init/temp";
-
- for (var i = grd_payamtlist.cols - 1; i >= 1 ; i--) {
- grd_payamtlist.removeColumn(false);
-
- }
- grd_payamtlist.caption = "";
-
- model.refresh();
- grd_payamtlist.rebuild();
-
- }
-
-
- submit("TXRWS00401");
-
-
- var node = instance1.selectNodes("/root/main/payspecdata/payamtlist[1]/*");
-
- var payitemcnt = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt") ;
- var payitemcnt2 = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt2") ;
-
- if (node.length > 0 ) {
- grd_payamtlist.frozenCols = 4;
-
- for(i=0;i<payitemcnt;i++) {
- if (i < 4 ) {
- grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
- }
- else if (i == payitemcnt - 1) {
- grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + "visibility:hidden;", false);
- }
- else {
- grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
- }
- }
- //grd_payamtlist.frozenCols = 4;
- }
- grd_payamtlist.caption = model.getValue("/root/main/payspecdata/paytitlelist/paytitle") + "|" + model.getValue("/root/main/payspecdata/paytitlelist/paytitle");
- grd_payamtlist.nodeset = "/root/main/payspecdata/payamtlist";
- grd_payamtlist.rebuild();
-
- // grd_payamtlist.subtotalposition = "below";
- // if (node.length > 0 ) {
- // for(i=0;i<payitemcnt;i++) {
- // if (i >= 4 ) {
- // grd_payamtlist.subtotal("sum",-1 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- // grd_payamtlist.subTotal("sum", 2 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#f99999; font-weight:bold; ", 1, "소계");
- //
- // }
- // }
- // }
-
- // if (grd_paybugtincrlist.visible == true) {
- // submit("TRRWS00303");
- // }
- ]]>
- </script>
- </button>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <datagrid id="grd_payamtlist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:278px; top:33px; width:908px; height:272px; ">
- <script type="javascript" ev:event="onrowchanged">
- <![CDATA[
- model.setValue("/root/send/avgpayamtyy/instcd", cmb_instcd.value);
- model.setValue("/root/send/avgpayamtyy/workflag", "X");
- model.setValue("/root/send/avgpayamtyy/workym", ipt_workym.value);
-
- var emplno = "";
- emplno = grd_payamtlist.valueMatrix(grd_payamtlist.row, grd_payamtlist.colRef(grd_payamtlist.colAttribute(grd_payamtlist.cols-1, "ref")));
- model.setValue("/root/send/avgpayamtyy/emplno", emplno);
-
- submit("TRRWS00402");
-
- grd_payamtlist.dispatch("onmouseup");
-
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("payavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("bnusavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("dutavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("festavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("stdyavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("mediavg"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- grd_avgpayamtyylist.subtotal("sum",-1 , grd_avgpayamtyylist.colRef("totamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");
- ]]>
- </script>
- </datagrid>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption1" class="search_name" style="left:10px; top:380px; width:91px; height:17px; ">성직 구분:</caption>
- <input id="ipt_deptnm" ref="/root/send/payspec/deptnm" class="input_default" navindex="70" style="left:97px; top:214px; width:143px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfValidationCheck("02", "", "deptcd,deptnm" );
- model.refresh();
- ]]>
- </script>
- </input>
- <button id="btn_deptcd" class="icon_search" style="left:244px; top:215px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "deptcd,deptnm";
- var instcd = cmb_instcd.value;
- rpbfOpenDeptCdHelp(ipt_deptcd,recv_list, instcd, "instcd");
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_deptcd" ref="/root/send/payspec/deptcd" class="input_default" visibility="hidden" style="left:97px; top:214px; width:40px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var recv_list = "emplno,emplnm" ;
- rpbfValidationCheck("EMPLNO", recv_list);
- model.refresh();
- ]]>
- </script>
- </input>
- <caption id="caption5" class="search_name" style="left:10px; top:214px; width:91px; height:17px; ">근무 부서:</caption>
- <input id="ipt_jobposnm" ref="/root/send/payspec/jobposnm" class="input_default" navindex="80" style="left:97px; top:247px; width:143px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfValidationCheck("03", "R0062", "jobposcd,jobposnm" );
- model.refresh();
- ]]>
- </script>
- </input>
- <button id="btn_jobposcd" class="icon_search" style="left:244px; top:249px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "jobposcd,jobposnm";
- rpbfOpenComCdHelp(ipt_jobposcd,"R0062", recv_list);
- model.refresh();
- ]]>
- </script>
- </button>
- <caption id="caption7" class="search_name" style="left:10px; top:247px; width:92px; height:17px; ">직 위:</caption>
- <input id="ipt_jobposcd" ref="/root/send/payspec/jobposcd" class="input_default" visibility="hidden" style="left:97px; top:247px; width:40px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var recv_list = "emplno,emplnm" ;
- rpbfValidationCheck("EMPLNO", recv_list);
- model.refresh();
- ]]>
- </script>
- </input>
- <button id="btn_jobkindcd" class="icon_search" style="left:244px; top:281px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "jobkindcd,jobkindnm";
- rpbfOpenComCdHelp(ipt_jobkindcd,"R0061", recv_list);
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_jobkindnm" ref="/root/send/payspec/jobkindnm" class="input_default" navindex="90" style="left:97px; top:280px; width:143px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfValidationCheck("03", "R0061", "jobkindcd,jobkindnm" );
- model.refresh();
- ]]>
- </script>
- </input>
- <input id="ipt_jobkindcd" ref="/root/send/payspec/jobkindcd" class="input_default" visibility="hidden" style="left:97px; top:280px; width:40px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var recv_list = "emplno,emplnm" ;
- rpbfValidationCheck("EMPLNO", recv_list);
- model.refresh();
- ]]>
- </script>
- </input>
- <caption id="caption8" class="search_name" style="left:10px; top:280px; width:92px; height:17px; ">직 종:</caption>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption9" class="search_name" style="left:10px; top:346px; width:86px; height:17px; ">호봉 교직:</caption>
- <button id="btn_jobrespcd" class="icon_search" style="left:244px; top:314px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "jobrespcd,jobrespnm";
- rpbfOpenComCdHelp(ipt_jobrespcd,"R0063", recv_list);
- model.refresh();
- ]]>
- </script>
- </button>
- <caption id="caption10" class="search_name" style="left:10px; top:313px; width:92px; height:17px; ">직 책:</caption>
- <input id="ipt_jobrespnm" ref="/root/send/payspec/jobrespnm" class="input_default" navindex="100" style="left:97px; top:313px; width:143px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfValidationCheck("03", "R0063", "jobrespcd,jobrespnm" );
- model.refresh();
- ]]>
- </script>
- </input>
- <input id="ipt_jobrespcd" ref="/root/send/payspec/jobrespcd" class="input_default" visibility="hidden" style="left:97px; top:313px; width:40px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var recv_list = "emplno,emplnm" ;
- rpbfValidationCheck("EMPLNO", recv_list);
- model.refresh();
- ]]>
- </script>
- </input>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption11" class="search_name" style="left:10px; top:412px; width:91px; height:17px; ">선임 여부:</caption>
- <caption id="caption12" class="search_name" style="left:10px; top:445px; width:91px; height:17px; ">면허 구분:</caption>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption13" class="search_name" style="left:10px; top:478px; width:91px; height:17px; ">가장 여부:</caption>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption14" class="search_name" style="left:10px; top:511px; width:101px; height:17px; ">결혼 여부:</caption>
- <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; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption15" class="search_name" style="left:10px; top:545px; width:88px; height:17px; ">근속 년수:</caption>
- <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; "/>
- <line id="line1" class="line_1" style="x1:278px; y1:330px; x2:1186px; y2:330px; "/>
- <button id="btn_yyavgexcel" class="btn2_letter4" style="left:1120px; top:308px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if (fileName != "")
- {
- grd_avgpayamtyylist.saveExcel(fileName);
- window.exec(fileName);
- }
- ]]>
- </script>
- </button>
- <caption id="caption16" class="tit_2" style="left:280px; top:313px; width:144px; height:13px; ">년 급여List</caption>
- <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; ">
- <col ref="prfshipflagnm"/>
- <col ref="jobgradnm"/>
- <col ref="payclsnm"/>
- <col ref="payym" format="yyyy-mm" style="text-align:center; vertical-align:middle; "/>
- <col ref="payavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="bnusavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="dutavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="festavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="stdyavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="mediavg" format="#,###" style="text-align:right; vertical-align:middle; "/>
- <col ref="totamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
- </datagrid>
- </case>
- </switch>
- <button id="button1" class="btn_sw" group="tab" selected="true" style="left:5px; top:5px; width:80px; height:22px; ">
- <caption>연봉계산</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.toggle("case1");
- ]]>
- </script>
- </button>
- <button id="button2" class="btn_sw" group="tab" selected="false" style="left:88px; top:5px; width:80px; height:22px; ">
- <caption>평균임금</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.toggle("case2");
- ]]>
- </script>
- </button>
- </group>
- <group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
- </xhtml:body>
- </xhtml:html>
|