123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613 |
- <?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>
- <yyeducprcslist/>
- <emplist/>
- <yyeducprcslist1/>
- </main>
- <send>
- <req>
- <appyy/>
- <mainbdunit/>
- <instcd/>
- <educflag/>
- <educfromdd/>
- <eductodd/>
- <instnm/>
- </req>
- <save>
- <instcd/>
- <appyy/>
- <educcd/>
- <cmpltcursstdyyn/>
- <educdg/>
- </save>
- <emplist/>
- </send>
- <init>
- <itemset>
- <set1>
- <value/>
- <label/>
- </set1>
- </itemset>
- </init>
- <temp/>
- <hidden>
- <item>
- <value>M</value>
- <label>남</label>
- </item>
- <item>
- <value>F</value>
- <label>여</label>
- </item>
- <item1>
- <value>Y</value>
- <label>이수</label>
- </item1>
- <item1>
- <value>N</value>
- <label>미이수</label>
- </item1>
- </hidden>
- </root>
- </instance>
- <submission id="TRRPS01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/req" resultref="/root/main/yyeducprcslist"/>
- <submission id="TRRPS01002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/main/emplist"/>
- <submission id="TXRPS01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
- </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/stringHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../mis/educationmngtweb/js/RPS001.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //사용자 권한
- fCheckAuth();
-
- fInit();
- ]]>
- </script>
- <script type="javascript">
- <![CDATA[
- function fInit() {
-
- // 그리드 초기화
- misfGridInit(grd_yyeducprcslist);
- misfGridInit(grd_yyeducprcslist1);
- misfGridInit(grd_emplist);
-
- misfMsterDetailSet(grd_yyeducprcslist, null, "TRRPS01001", "Y");
- misfMsterDetailSet(grd_emplist, grd_yyeducprcslist, "TRRPS01002", "Y");
-
- var curDate = getCurrentDate().substr(0,4);
- model.setValue("/root/send/req/appyy", getCurrentDate().substr(0,4));
-
- rpsEducSetComboList("M01-002", "cmb_educflag","Y");
- grd_emplist.fixedcellcheckbox(0,1) = true;
-
- model.setValue("/root/send/req/instcd", getUserInfo("dutplceinstcd"));
- model.setValue("/root/send/req/instnm", getUserInfo("dutplceinstnm"));
-
- model.refresh();
- }
-
-
- //========================================================================================
- //버튼에 대한 화면 권한 체크(R : 읽기, X : 입력/수정/삭제, P : 출력)
- //========================================================================================
- function fCheckAuth() {
- btn_search.disabled = !checkAuth("R") ;
- btn_save.disabled = !checkAuth("X") ;
-
- var userinstcd = getUserInfo("dutplceinstcd");
- var userdeptcd = getUserInfo("dutplcecd");
-
- misfGetUserAuth();
- if( DUTY_EDU_YN == 'Y' || getUserInfo("dutplcecd") == "4020503000" ) {
- ipt_instnm.disabled = false;
- ipt_instcd.disabled = false;
- btn_instcd.disabled = false;
- }
- else {
- ipt_instnm.disabled = true;
- ipt_instcd.disabled = true;
- btn_instcd.disabled = true;
- }
- }
-
- // 미이수자가 있는 교육에 색깔 넣기
- function fSetEducColor() {
- for(i=grd_yyeducprcslist.fixedRows; i < grd_yyeducprcslist.rows;i++) {
- var cmpltyncnt = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("cmpltyncnt"));
-
- if(cmpltyncnt == 0){
- grd_yyeducprcslist.rowStyle(i, "all", "background-color") ="white";
- }else{
- grd_yyeducprcslist.rowStyle(i, "all", "background-color") ="#99ccff";
- }
- }
- model.refresh();
- }
-
- // 미이수자 색깔 넣기
- function fSetColor() {
- for(i=grd_emplist.fixedRows; i < grd_emplist.rows;i++)
- {
- var cmpltcursstdyyn = grd_emplist.valueMatrix(i,grd_emplist.colRef("cmpltcursstdyyn"));
- if(cmpltcursstdyyn =='Y'){
- grd_emplist.rowStyle(i, "all", "background-color") ="white";
- }else{
- grd_emplist.rowStyle(i, "all", "background-color") ="#ffff99";
- }
- grd_emplist.valueMatrix(i,grd_emplist.colRef("chk")) = 'N';
- }
- model.refresh();
- }
-
- function fEducListRetrieve()
- {
- var iRowIdx = grd_yyeducprcslist1.row;
- model.removeNodeset("/root/main/yyeducprcslist");
- model.removeNodeset("/root/main/yyeducprcslist1");
- model.refresh();
- submit("TRRPS01001");
-
- fListAddCombo() ;
-
- if(grd_yyeducprcslist1.rows > 1) {
- if(iRowIdx == -1) iRowIdx = 1;
- else
- if(iRowIdx > grd_yyeducprcslist1.rows) iRowIdx = grd_yyeducprcslist1.rows - 1;
-
- grd_yyeducprcslist1.row = iRowIdx;
- grd_yyeducprcslist1.select(iRowIdx, 1, iRowIdx, 10) = true;
-
- grd_yyeducprcslist1.dispatch("ondblclick");
- }
- else {
- model.removeNodeset("/root/main/yyeducprcslist1");
- model.refresh();
- }
- }
-
- function fListAddCombo() {
- // 교육명 세팅
- for(var i = grd_yyeducprcslist.fixedRows, j = grd_yyeducprcslist1.rows; i < grd_yyeducprcslist.rows; i++ ) {
- if( j == "1" ) { // grd_yyeducprcslist1에 아무내용도 없을때는 무조건 addrow
- grd_yyeducprcslist1.addRow(false);
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("appyy")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("appyy"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("instcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("instcd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcdnm")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcdnm"));
- /*
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educfromdd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("eductodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductodd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educappfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educappfromdd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educapptodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educapptodd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educplce")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educplce"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcnts")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcnts"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("eductm")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductm"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("apppsnno")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("apppsnno"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcapa")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcapa"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("cmpltyncnt")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("cmpltyncnt"));
- */
- j++;
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) == grd_yyeducprcslist1.valueMatrix(1,grd_yyeducprcslist1.colRef("educcd")) ) {
- continue;
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) == grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("educcd")) ) {
- continue;
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) != grd_yyeducprcslist1.valueMatrix(j-1,grd_yyeducprcslist1.colRef("educcd")) ) {
- // educcd가 다른경우
- grd_yyeducprcslist1.addRow(false);
- grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("appyy")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("appyy"));
- grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("instcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("instcd"));
- grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("educcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd"));
- grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("educcdnm")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcdnm"));
- /*
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educfromdd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("eductodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductodd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educappfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educappfromdd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educapptodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educapptodd"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educplce")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educplce"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcnts")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcnts"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("eductm")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductm"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("apppsnno")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("apppsnno"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("educcapa")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcapa"));
- grd_yyeducprcslist1.valueMatrix(i,grd_yyeducprcslist1.colRef("cmpltyncnt")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("cmpltyncnt"));
- */
- j++;
- }
- }
-
- // 차수 콤보 세팅
- var dg = 1;
- for(var i = grd_yyeducprcslist.fixedRows, j = grd_yyeducprcslist1.fixedRows; i < grd_yyeducprcslist.rows; i++ ) {
- if( i == grd_yyeducprcslist.fixedRows && j == grd_yyeducprcslist1.fixedRows) { // 맨첫번째 row일때
- model.makeNode("/root/init/itemset/set"+i+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+i+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+i+"["+dg+"]/value","");
- model.setValue("/root/init/itemset/set"+i+"["+dg+"]/label","전체");
-
- dg++;
- model.makeNode("/root/init/itemset/set"+i+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+i+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+i+"["+dg+"]/value",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- model.setValue("/root/init/itemset/set"+i+"["+dg+"]/label",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) == grd_yyeducprcslist1.valueMatrix(1,grd_yyeducprcslist1.colRef("educcd")) ) {
- // 첫번째 row의 educcd와 현재진행중인row의 educcd가 같으면 차수만 추가
- dg++;
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/value",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/label",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) == grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("educcd")) ) {
- dg++;
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/value",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/label",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) != grd_yyeducprcslist1.valueMatrix(j,grd_yyeducprcslist1.colRef("educcd")) ) {
- // educcd가 다른경우
- dg = 1;
- j++
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/value","");
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/label","전체");
- dg++;
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/value");
- model.makeNode("/root/init/itemset/set"+j+"["+dg+"]/label");
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/value",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- model.setValue("/root/init/itemset/set"+j+"["+dg+"]/label",grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")));
- }
- }
-
- // itemset을 row별로 설정..
- for(var i = grd_yyeducprcslist1.fixedRows; i < grd_yyeducprcslist1.rows; i++ ) {
- grd_yyeducprcslist1.cellComboNodeset(i, 2) = "/root/init/itemset/set"+i;
- }
-
- grd_yyeducprcslist1.row = 1; // grd_yyeducprcslist1그리드의 1번 row를 선택한것과 같음.
- model.refresh();
- }
-
- function fEducDtListRetrieve() {
- model.setValue("/root/send/save/instcd", grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row, grd_yyeducprcslist1.colRef("instcd")));
- model.setValue("/root/send/save/educdg", grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row, grd_yyeducprcslist1.colRef("educdg")));
- model.setValue("/root/send/save/appyy", grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row, grd_yyeducprcslist1.colRef("appyy")));
- model.setValue("/root/send/save/educcd", grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row, grd_yyeducprcslist1.colRef("educcd")));
-
- submit("TRRPS01002");
- }
- ]]>
- </script>
- </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:38px; width:1195px; height:744px; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:5px; width:1195px; height:63px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="btn_search" class="btn1_letter2" style="left:1125px; top:27px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if(!isRequiredControls("cmb_appyy")) return;
-
- fEducListRetrieve();
- ]]>
- </script>
- </button>
- <line id="line13" class="line_4" style="x1:1110px; y1:9px; x2:1110px; y2:64px; "/>
- <line id="line8" class="line_1" style="x1:0px; y1:90px; x2:1194px; y2:89px; "/>
- <caption id="caption20" class="tit_2" style="left:5px; top:74px; width:175px; height:13px; ">연간 교육과정 차수별 내역</caption>
- <select1 id="cmb_educflag" ref="/root/send/req/educflag" class="combo_search" appearance="minimal" style="left:150px; top:40px; width:95px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="cap_appyy" class="search_name" style="left:64px; top:15px; width:90px; height:17px; ">년 도 :</caption>
- <input id="ipt_appyy" ref="/root/send/req/appyy" class="input_s_essential" inputtype="date" format="yyyy" style="left:150px; top:15px; width:95px; height:19px; "/>
- <caption id="cap_educflag" class="search_name" style="left:64px; top:40px; width:86px; height:17px; ">교육구분 :</caption>
- <caption id="cap_educmdlcd" class="search_name" style="left:406px; top:40px; width:91px; height:17px; ">이수구분 :</caption>
- <caption id="cap_instcd" class="search_name" style="left:406px; top:15px; width:90px; height:17px; ">기 관 :</caption>
- <line id="line1" class="line_1" style="x1:0px; y1:350px; x2:1194px; y2:350px; "/>
- <caption id="caption7" class="tit_2" style="left:0px; top:314px; width:162px; height:13px; ">교육대상자 및 이수 내역</caption>
- <input id="input1" ref="/root/send/save/instcd" visibility="hidden" style="left:430px; top:65px; width:45px; height:19px; "/>
- <input id="input2" ref="/root/send/save/appyy" visibility="hidden" style="left:480px; top:65px; width:35px; height:19px; "/>
- <input id="input3" ref="/root/send/save/educcd" visibility="hidden" style="left:520px; top:65px; width:30px; height:19px; "/>
- <input id="input4" ref="/root/send/save/educdg" visibility="hidden" style="left:555px; top:65px; width:35px; height:19px; "/>
- <button id="button1" class="btn2_letter4" style="left:64px; top:330px; width:64px; height:19px; ">
- <caption>전체선택</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var rownum = grd_emplist.rows - grd_emplist.fixedRows;
-
- for(var i= grd_emplist.fixedRows ; i < grd_emplist.rows ; i++) {
- if(grd_emplist.valueMatrix(i, grd_emplist.colRef("cmpltcursstdyyn")) == "N"){
- grd_emplist.valueMatrix(i, grd_emplist.colRef("chk")) = "Y";
- grd_emplist.rowStatus(i) = 2;
- }
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="btn_excel" class="btn5_letter4" style="left:1130px; top:330px; 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_emplist.saveExcel(fileName);
- }
- ]]>
- </script>
- </button>
- <caption id="cap_educfromdd" class="search_name" style="left:785px; top:40px; width:87px; height:17px; ">교육년월 :</caption>
- <input id="ipt_educfromdd" ref="/root/send/req/educfromdd" class="input_search" inputtype="date" format="yyyy-mm" style="left:874px; top:40px; width:80px; height:19px; text-align:center; "/>
- <caption id="caption3" style="left:958px; top:40px; width:15px; height:20px; text-align:center; ">~</caption>
- <input id="ipt_eductodd" ref="/root/send/req/eductodd" class="input_search" inputtype="date" format="yyyy-mm" style="left:976px; top:40px; width:80px; height:19px; text-align:center; "/>
- <select1 id="radio2" ref="/root/send/save/cmpltcursstdyyn" appearance="full" cols="3" overflow="visible" style="left:495px; top:40px; width:171px; height:20px; border-style:none; ">
- <choices>
- <item>
- <label>전체</label>
- <value/>
- </item>
- <item>
- <label>이수자</label>
- <value>Y</value>
- </item>
- <item>
- <label>미이수자</label>
- <value>N</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- submit("TRRPS01002");
-
- fSetColor() ;
- model.refresh();
- ]]>
- </script>
- </select1>
- <datagrid id="grd_emplist" nodeset="/root/main/emplist" autoresize="true" caption="^차수^사원번호^성명^이수구분^시험점수^비고^교육일자^교육일자^교육시간일정^교육총시간^교직구분코드^교직구분^근무기관코드^소속기관^근무부서코드^소속부서^성직구분코드^성직구분^직군코드^직군^신직급코드^신직급^년차^직종코드^직종^직책코드^직책^성별^입사일자^기관^적용년도^교육코드" colsep="^" colwidth="25, 39, 70, 70, 70, 60, 90, 80, 80, 90, 75, 35, 60, 33, 106, 31, 117, 28, 70, 22, 92, 25, 66, 43, 39, 80, 34, 94, 53, 89, 78, 57, 68" dataheight="25" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:355px; width:1195px; height:387px; text-align:center; ">
- <col checkvalue="Y,N" ref="chk" type="checkbox"/>
- <col ref="educdg" style="text-align:center; "/>
- <col ref="emplno" style="text-align:center; "/>
- <col ref="emplnm" style="text-align:center; "/>
- <col ref="cmpltcursstdyyn" type="combo">
- <choices>
- <itemset nodeset="/root/hidden/item1">
- <label ref="label"/>
- <value ref="value"/>
- </itemset>
- </choices>
- </col>
- <col ref="testscor" type="input" maxlength="5"/>
- <col ref="cmt" type="input" maxlength="100"/>
- <col ref="educfromdd" format="yyyy-mm-dd"/>
- <col ref="eductodd" format="yyyy-mm-dd"/>
- <col ref="eductmplan" format="99:99-99:99"/>
- <col ref="eductm" maxbyte="3"/>
- <col ref="prfshipflag" visibility="hidden"/>
- <col ref="prfshipnm"/>
- <col ref="dutinstcd" visibility="hidden"/>
- <col ref="dutinstnm"/>
- <col ref="dutdeptcd" visibility="hidden"/>
- <col ref="dutdeptnm"/>
- <col ref="holyordflag" visibility="hidden"/>
- <col ref="holyordnm"/>
- <col ref="grupjoblncd" visibility="hidden"/>
- <col ref="grupjoblnnm"/>
- <col ref="njobgradcd" visibility="hidden"/>
- <col ref="njobgradnm"/>
- <col ref="anual" style="text-align:center; "/>
- <col ref="jobkindcd" visibility="hidden"/>
- <col ref="jobkindnm"/>
- <col ref="jobrespcd" visibility="hidden"/>
- <col ref="jobrespnm"/>
- <col disabled="true" ref="gender" type="combo">
- <choices>
- <itemset nodeset="/root/hidden/item">
- <label ref="label"/>
- <value ref="value"/>
- </itemset>
- </choices>
- </col>
- <col ref="entcodd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="appyy" visibility="hidden"/>
- <col ref="educcd" visibility="hidden"/>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var col = grd_emplist.col;
- ]]>
- </script>
- </datagrid>
- <button id="button2" class="btn2_letter2" style="left:132px; top:330px; width:42px; height:19px; ">
- <caption>이수</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var rownum = grd_emplist.rows - grd_emplist.fixedRows;
-
- for(var i= grd_emplist.fixedRows ; i < grd_emplist.rows ; i++) {
- if( grd_emplist.valueMatrix(i, grd_emplist.colRef("chk")) == "Y" ) {
- grd_emplist.valueMatrix(i, grd_emplist.colRef("cmpltcursstdyyn")) = "Y";
- grd_emplist.addStatus(i,"update");
- }
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="button3" class="btn2_letter3" style="left:175px; top:330px; width:53px; height:19px; ">
- <caption>미이수</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var rownum = grd_emplist.rows - grd_emplist.fixedRows;
-
- for(var i= grd_emplist.fixedRows ; i < grd_emplist.rows ; i++) {
- if( grd_emplist.valueMatrix(i,grd_emplist.colRef("chk")) == "Y" ){
- grd_emplist.valueMatrix(i, grd_emplist.colRef("cmpltcursstdyyn")) ="N";
- grd_emplist.addStatus(i,"update");
- }
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <datagrid id="grd_yyeducprcslist1" nodeset="/root/main/yyeducprcslist1" caption="교육명^차수^교육일자^교육일자^교육신청일^교육신청일^교육 장소^교육 내용^교육
시간^신청인원/ 정원^신청인원/ 정원^미이수인원^기관^적용년도^교육코드^비고|교육명^차수^From^To^From^To^교육 장소^교육 내용^교육
시간^신청인원/ 정원^신청인원/ 정원^미이수인원^기관^적용년도^교육코드^비고" colsep="^" colwidth="337, 52, 75, 90, 75, 75, 197, 130, 42, 32, 32, 49, 54, 58, 55, 236" dataheight="25" explorerbar="sortshow" extendlastcol="scroll" frozencols="6" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:93px; width:1195px; height:217px; ">
- <col ref="educcdnm"/>
- <col ref="educdg" type="combo" style="text-align:center; ">
- <choices>
- <itemset nodeset="/root/init/itemset/set1">
- <label ref="label"/>
- <value ref="value"/>
- </itemset>
- </choices>
- </col>
- <col ref="educfromdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="eductodd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educappfromdd" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educapptodd" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educplce" style="text-align:left; "/>
- <col ref="educcnts" style="text-align:left; "/>
- <col ref="eductm" style="text-align:center; "/>
- <col ref="apppsnno" style="text-align:center; "/>
- <col ref="educcapa" style="text-align:center; "/>
- <col ref="cmpltyncnt" visibility="hidden" style="text-align:right; "/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="appyy" visibility="hidden" style="text-align:right; "/>
- <col ref="educcd" visibility="hidden"/>
- <col ref="cmt"/>
- <script type="javascript" ev:event="ondblclick">
- <![CDATA[
- grd_yyeducprcslist1.dispatch("xforms-value-changed");
- ]]>
- </script>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- // 콤보박스의 내용이 변경되었을때...
- for(var i = grd_yyeducprcslist.fixedRows; i < grd_yyeducprcslist.rows; i++ ) {
- if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) == grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcd")) ) {
- if(grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educdg")) == grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educdg")) ) {
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educfromdd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("eductodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductodd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educappfromdd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educappfromdd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educapptodd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educapptodd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educplce")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educplce"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcnts")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcnts"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("eductm")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("eductm"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("apppsnno")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("apppsnno"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcapa")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcapa"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("cmpltyncnt")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("cmpltyncnt"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("instcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("instcd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("appyy")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("appyy"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("cmt")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("cmt"));
- }
- else if( grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educdg")) == "" ) {
- // 전체를 선택하면 신청인원/정원을 공백으로 설정한다.
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educfromdd")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("eductodd")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educappfromdd"))= "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educapptodd")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educplce")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcnts")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("eductm")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("apppsnno")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcapa")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("cmpltyncnt")) = "";
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("instcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("instcd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("appyy")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("appyy"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcd")) = grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd"));
- grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("cmt")) = "";
- }
- }
- else if( grd_yyeducprcslist.valueMatrix(i,grd_yyeducprcslist.colRef("educcd")) != grd_yyeducprcslist1.valueMatrix(grd_yyeducprcslist1.row,grd_yyeducprcslist1.colRef("educcd")) ) {
- // educcd가 다른경우
- continue;
- }
- }
- fEducDtListRetrieve() ;
- fSetColor() ;
- ]]>
- </script>
- </datagrid>
- <datagrid id="grd_yyeducprcslist" nodeset="/root/main/yyeducprcslist" visibility="hidden" autoresize="true" caption="교육명^차수^교육일자^교육일자^교육신청일^교육신청일^교육 장소^교육 내용^교육
시간^신청인원/ 정원^신청인원/ 정원^미이수인원^기관^적용년도^교육코드^비고|교육명^차수^From^To^From^To^교육 장소^교육 내용^교육
시간^신청인원/ 정원^신청인원/ 정원^미이수인원^기관^적용년도^교육코드^비고" colsep="^" colwidth="313, 52, 75, 90, 75, 75, 197, 30, 42, 32, 32, 49, 54, 58, 55, 236" dataheight="25" explorerbar="sortshow" extendlastcol="scroll" frozencols="6" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:385px; top:210px; width:790px; height:112px; ">
- <col ref="educcdnm"/>
- <col ref="educdg" style="text-align:right; "/>
- <col ref="educfromdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="eductodd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educappfromdd" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educapptodd" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="educplce" style="text-align:left; "/>
- <col ref="educcnts" visibility="hidden" style="text-align:left; "/>
- <col ref="eductm" style="text-align:right; "/>
- <col ref="apppsnno" style="text-align:center; "/>
- <col ref="educcapa" style="text-align:center; "/>
- <col ref="cmpltyncnt" visibility="hidden" style="text-align:right; "/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="appyy" visibility="hidden" style="text-align:right; "/>
- <col ref="educcd" visibility="hidden"/>
- <col ref="cmt"/>
- </datagrid>
- <button id="btn_instcd" class="icon_search" style="left:655px; top:15px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "instcd,instnm";
- misfOpenPopUpList("03", ipt_instnm,"Z0007", recv_list, "", "") ;
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_instnm" ref="/root/send/req/instnm" class="input_search" appearance="input" style="left:495px; top:15px; width:158px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if( ipt_instnm.value.getByteLength() == '0' ) {
- ipt_instcd.value = "" ;
- }
- model.refresh();
- ]]>
- </script>
- </input>
- <input id="ipt_instcd" ref="/root/send/req/instcd" disabled="true" visibility="hidden" style="left:676px; top:15px; width:50px; height:19px; "/>
- <button id="btn_save" class="btn4_letter2" style="left:0px; top:328px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if( misfSave("TXRPS01001") ) {
- messageBox("","I001");
- grd_emplist.fixedcellischeck(0,1) = false;
- }
- submit("TRRPS01002");
- fSetColor();
- ]]>
- </script>
- </button>
- </group>
- <group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; "/>
- </xhtml:body>
- </xhtml:html>
|