YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD04600_외국시찰및연수등록.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD04600" position="absolute 0 0 1202 807" titletext="외국시찰및연수등록" oninit="SMRPD04600_oninit" onload="SMRPD04600_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="외국시찰및연수등록" class="tit_1" position="absolute 0 0 280 25"/>
        <Shape id="line4" class="line_6" position="absolute 0 44 1195 50" anchor="left top right"/>
        <Button id="button36" taborder="1" text="저장" class="btn4" position="absolute 1139 23 1195 45" onclick="button36_onclick" anchor="top right"/>
        <Div id="group4" anchor="left top right" taborder="2" class="div_SA2" position="absolute 0 48 1195 88">
          <Layouts>
            <Layout>
              <Static id="caption2" text="근무부서 :" class="search_name" position="absolute 17 11 105 28"/>
              <Combo id="combo1" taborder="1" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 105 10 195 29">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">근무지</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">근무부서</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">근무과(팀)</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">근무부(실)</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Edit id="ipt_dutdeptcd" taborder="2" class="input_search" position="absolute 200 10 270 29" autoskip="true" autoselect="true" onkeydown="group4_ipt_dutdeptcd_onkeydown"/>
              <Edit id="ipt_dutdeptnm" taborder="3" class="input_search" position="absolute 291 10 405 29" autoskip="true" autoselect="true" onkeydown="group4_ipt_dutdeptnm_onkeydown"/>
              <Button id="btn_dutdept" taborder="4" class="icon_search" position="absolute 273 12 289 28" onclick="group4_btn_dutdept_onclick"/>
              <Static id="caption1" text="기간 :" class="search_name" position="absolute 440 11 506 28"/>
              <Calendar id="ipt_dutym" taborder="5" class="input_search" position="absolute 505 10 610 29" mask="yyyy-mm-dd" autoskip="true" autoselect="true" onchanged="group4_ipt_dutym_onchanged"/>
              <Static id="caption4" text="~" position="absolute 617 10 632 30"/>
              <Calendar id="input1" taborder="6" class="input_search" position="absolute 635 10 740 29" mask="yyyy-mm-dd" autoskip="true" autoselect="true" onchanged="group4_input1_onchanged"/>
              <Static id="caption3" text="사번 :" class="search_name" position="absolute 775 11 838 28"/>
              <Edit id="ipt_emplnos" taborder="7" class="input_default" position="absolute 836 10 903 29" autoskip="true" autoselect="true" onkeyup="group4_ipt_emplnos_onkeyup"/>
              <Button id="btn_emplno" taborder="8" class="icon_search" position="absolute 908 10 924 26" onclick="group4_btn_emplno_onclick"/>
              <Edit id="ipt_emplnms" taborder="9" class="input_default" position="absolute 927 10 1023 29" autoskip="true" autoselect="true" onkeydown="group4_ipt_emplnms_onkeydown"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1107 8 1113 30" anchor="top right"/>
              <Button id="btn_search" taborder="10" text="조회" class="btn1" position="absolute 1125 9 1181 31" onclick="group4_btn_search_onclick" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excsave" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 107 1195 126" onclick="btn_excsave_onclick" anchor="top right"/>
        <Button id="btn_grddelpaydedulist" taborder="4" text="행삭제" class="btn2" position="absolute 1059 107 1112 126" onclick="btn_grddelpaydedulist_onclick" anchor="top right"/>
        <Button id="btn_grdaddpaydedulist" taborder="5" text="행추가" class="btn2" position="absolute 1003 107 1056 126" onclick="btn_grdaddpaydedulist_onclick" anchor="top right"/>
        <Shape id="line207" class="line_10" position="absolute 0 126 1195 132" anchor="left top right"/>
        <Grid id="grd_dutsumlist" taborder="6" binddataset="ds_main_list_dutsumlist" useinputpanel="false" position="absolute 0 131 1195 801" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all" onexpanddown="grd_dutsumlist_onexpanddown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23"/>
                <Column size="101"/>
                <Column size="73"/>
                <Column size="107"/>
                <Column size="112"/>
                <Column size="114"/>
                <Column size="202"/>
                <Column size="169"/>
                <Column size="165"/>
                <Column size="113"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="사원번호"/>
                <Cell col="2" text="성명"/>
                <Cell col="3" text="기간(FROM)"/>
                <Cell col="4" text="기간(TO)"/>
                <Cell col="5" text="국가"/>
                <Cell col="6" text="교육목적"/>
                <Cell col="7" text="교육종류"/>
                <Cell col="8" text="교육기관"/>
                <Cell col="9" text="지급액"/>
                <Cell col="10" text="caption7"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="text" edittype="expr:getRowType(currow) == 2 ? 'text' : 'none'" style="align:center middle;" text="bind:emplno" expandshow="show" enable="false"/>
                <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:emplnm"/>
                <Cell col="3" displaytype="date" edittype="date" text="bind:giganfrom" calendardisplaynulltype="nulltext"/>
                <Cell col="4" displaytype="date" edittype="date" text="bind:giganto" calendardisplaynulltype="nulltext"/>
                <Cell col="5" displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 3;" text="bind:nationcd" combodisplayrowcount="40" id="nationcd"/>
                <Cell col="6" displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 3;" text="bind:stdobject" combodisplayrowcount="40" id="stdobject"/>
                <Cell col="7" displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 3;" text="bind:stdkind" combodisplayrowcount="40" id="stdkind"/>
                <Cell col="8" displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 3;" text="bind:gigwancd" combodisplayrowcount="40" id="gigwancd"/>
                <Cell col="9" displaytype="number" edittype="normal" text="bind:jigeubamt"/>
                <Cell col="10" text="bind:oldgiganfrom"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Combo id="cmb_instcd" taborder="7" class="combo_search" visible="false" position="absolute 510 91 650 110"/>
        <Static id="caption5" text="소속기관 :" class="search_name" visible="false" position="absolute 420 92 506 109"/>
        <Static id="caption278" text="내역" class="tit_2" position="absolute 0 110 162 132"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparams_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="frdutym" type="STRING" size="256"/>
          <Column id="todutym" type="STRING" size="256"/>
          <Column id="dutunitcd" type="STRING" size="256"/>
          <Column id="dutunitnm" type="STRING" size="256"/>
          <Column id="retrflag" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="deptgb" type="STRING" size="256"/>
          <Column id="gb" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="frdutym"/>
            <Col id="todutym"/>
            <Col id="dutunitcd"/>
            <Col id="dutunitnm"/>
            <Col id="retrflag">0510</Col>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="deptgb"/>
            <Col id="gb"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_dutsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_list_dutsumlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="dutplcedeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="emplno" type="STRING" size="256" sumtext="사원번호"/>
          <Column id="emplnm" type="STRING" size="256" sumtext="성명"/>
          <Column id="rregno" type="STRING" size="256" sumtext="주민번호"/>
          <Column id="giganfrom" type="STRING" size="256" sumtext="기간from"/>
          <Column id="giganto" type="STRING" size="256" sumtext="기간to"/>
          <Column id="nationcd" type="STRING" size="256" sumtext="국가코드"/>
          <Column id="stdobject" type="STRING" size="256" sumtext="교육목적"/>
          <Column id="stdkind" type="STRING" size="256" sumtext="교육종류"/>
          <Column id="gigwancd" type="STRING" size="256" sumtext="교육기관"/>
          <Column id="jigeubamt" type="STRING" size="256" sumtext="교육기관"/>
          <Column id="oldgiganfrom" type="STRING" size="256" sumtext="기간from"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.combo1" propid="value" datasetid="ds_send_retrparams" columnid="deptgb"/>
      <BindItem id="item1" compid="group4.ipt_dutdeptcd" propid="value" datasetid="ds_send_retrparams" columnid="dutunitcd"/>
      <BindItem id="item2" compid="group4.ipt_dutdeptnm" propid="value" datasetid="ds_send_retrparams" columnid="dutunitnm"/>
      <BindItem id="item3" compid="group4.ipt_dutym" propid="value" datasetid="ds_send_retrparams" columnid="frdutym"/>
      <BindItem id="item4" compid="group4.input1" propid="value" datasetid="ds_send_retrparams" columnid="todutym"/>
      <BindItem id="item5" compid="group4.ipt_emplnos" propid="value" datasetid="ds_send_retrparams" columnid="emplno"/>
      <BindItem id="item6" compid="group4.ipt_emplnms" propid="value" datasetid="ds_send_retrparams" columnid="emplnm"/>
      <BindItem id="item7" compid="cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_humtrafactmngtxp::RPB001.xjs";
function SMRPD04600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD04600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dutsumlist);
	grdf_setRowTypeIcon(grd_dutsumlist, 0);
	
	fInitialize();
}

function fInitialize()
{
	ds_main_list_dutsumlist.clearData();
	
	misfComboComCdListMulti("R0416,R0400,R0417,R0393,R0416","grd_dutsumlist.nationcd,grd_dutsumlist.stdobject,grd_dutsumlist.stdkind,grd_dutsumlist.gigwancd,grd_dutsumlist.nationcd");
	
	ds_send_retrparams.setColumn(0, "frdutym", String(utlf_getCurrentDate()).substr(0, 6) + "01");
	ds_send_retrparams.setColumn(0, "todutym", utlf_getCurrentDate());
	
	misfComboInstCdListMulti("cmb_instcd", group4.ipt_dutym.value+String(utlf_getCurrentDate()).substr(6, 2),"","N");
	
	misfGetAndSetUserInfo();
	
	ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	cmb_instcd.enable = false;
	
	ds_send_retrparams.setColumn(0, "deptgb", "1");
	
	group4.btn_search.click();
}

function group4_ipt_dutdeptcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();

		misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
	}
}

function ds_send_retrparams_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "dutunitcd")
	{
		group4.ipt_dutdeptcd.value = e.newvalue;
		group4.ipt_dutdeptcd.setFocus();
		
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );		
	}
	if(e.columnid == "dutunitnm")
	{
		group4.ipt_dutdeptnm.value = e.newvalue;
		group4.ipt_dutdeptnm.setFocus();
		
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
	}
	if(e.columnid == "emplno")
	{
		group4.ipt_emplnos.value = e.newvalue;
		group4.ipt_emplnos.setFocus();
		
		var recv_list = "emplno,emplnm" ;
		rpbfValidationCheck("EMPLNO", recv_list);
		
		if (String(e.newvalue).length > 0) 
		{
			group4.btn_search.click();
		}
	}
	
	if(e.columnid == "emplnm")
	{
		group4.ipt_emplnms.value = e.newvalue;
		group4.ipt_emplnms.setFocus();
		
		var recv_list = "emplno,emplnm" ;
		rpbfValidationCheck("EMPLNM", recv_list);
		
		if (String(group4.ipt_emplnos.value).length > 0) 
		{
			group4.btn_search.click();
		}
	}
}

function group4_btn_dutdept_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", group4.ipt_dutdeptcd, "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd");
}

function group4_ipt_dutdeptnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();

		misfValidationCheck("02", "", "dutunitcd,dutunitnm", cmb_instcd.value, "instcd" );
	}
}

function group4_ipt_dutym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	group4.btn_search.click();
}

function group4_input1_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	group4.btn_search.click();
}

function group4_ipt_emplnos_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

function group4_btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "emplno,emplnm" ;
	rpbfOpenPopUpList("SPRPB00101", group4.ipt_emplnos, recv_list,"","N");	
}

function group4_ipt_emplnms_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

function group4_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRPD04601";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetForeignerList";
		oParam.inds        = "req=ds_send_retrparams";
		oParam.outds       = "ds_main_list_dutsumlist=dutsumlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD04601";

	tranf_submit(oParam);
}

function btn_grdaddpaydedulist_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_list_dutsumlist.addRow();
}

function btn_grddelpaydedulist_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_dutsumlist, "D");
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_dutsumlist);
}

function button36_onclick(obj:Button,  e:ClickEventInfo)
{
	for (var i = 0; i < ds_main_list_dutsumlist.rowcount; i ++)
	{
		var emplno1 = ds_main_list_dutsumlist.getColumn(i, "emplno");
		var ymd1 = ds_main_list_dutsumlist.getColumn(i, "giganfrom");
		
		if(utlf_isNull(ds_main_list_dutsumlist.getColumn(i, "emplno")))
		{
			sysf_messageBox(parseInt(i+1) + "번째의 사원번호는 필수 입력항목입니다.", "E999", "");
			return;
		}
		
		if(utlf_isNull(ds_main_list_dutsumlist.getColumn(i, "giganfrom")))
		{
			sysf_messageBox(parseInt(i+1) + "번째의 기간(FROM)은 필수 입력항목입니다.", "E999", "");
			return;
		}
		
		for (var j = 0; j < ds_main_list_dutsumlist.rowcount; j ++)
		{
			var emplno2 = ds_main_list_dutsumlist.getColumn(j, "emplno");
			var ymd2 = ds_main_list_dutsumlist.getColumn(j, "giganfrom");
			
			if (i != j)
			{
				if (emplno1 == emplno2 && ymd1 == ymd2)
				{
					sysf_messageBox(parseInt(j+1) + "번째에서 중복된 자료가 존재합니다", "E999", "");
					return;
				}
			}
		}
	}
	var update = grdf_getGridUpdateData(grd_dutsumlist).rowcount;
	if(update == 0)
	{
		sysf_messageBox("업데이트 정보가 없습니다.", "E999", "");
		return 0;
	} 
	else 
	{
		var oParam = {};
			oParam.id          = "TXRPD04601";
			oParam.service     = "dligclaznsmngtapp.DutScheMngt";
			oParam.method      = "reqExeForeignerList";
			oParam.inds        = "req=ds_main_list_dutsumlist:u";
			oParam.outds       = "ds_=item";
			oParam.typeStr     = "m";
			oParam.async       = false;
			oParam.callback    = "cf_TXRPD04601";

		tranf_submit(oParam);
	}
}

function cf_TXRPD04601(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		sysf_messageBox("정상적으로 처리되었습니다.", "E999", "");
		group4.btn_search.click();
	}
}

function grd_dutsumlist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	var recv_list = "emplno,emplnm";		
	rpbfOpenPopUpList("SPRPB00101", grd_dutsumlist, recv_list,"","N");
}

function ds_main_list_dutsumlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if (e.columnid == "giganfrom" ) 
	{
		var ymd = obj.getColumn(e.row, "giganfrom");
		
		if (utlf_isValidDateTime(ymd) == false)
		{
			sysf_messageBox("일자가 잘못 입력되었습니다.", "E999", "");
			return;
		}
	}
	if (e.columnid == "giganto" ) 
	{
		var ymd = obj.getColumn(e.row, "giganto");
		
		if (utlf_isValidDateTime(ymd) == false)
		{
			sysf_messageBox("일자가 잘못 입력되었습니다.", "E999", "");
			return;
		}
	}
}
]]></Script>
  </Form>
</FDL>