YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD12500_월별휴일확정관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD12500" position="absolute 0 0 1197 792" titletext="월별휴일확정관리" oninit="SMRPD12500_oninit" onload="SMRPD12500_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="월별휴일확정관리" class="tit_1" position="absolute 0 0 248 25"/>
        <Shape id="line9" class="line_6" position="absolute 0 44 1195 50" anchor="left top right"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1134 23 1190 45" anchor="top right" onclick="btn_save_onclick"/>
        <Div id="grp_sea" taborder="2" position="absolute 0 48 1195 88" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="cap_instcd" text="기관:" class="search_name" position="absolute 13 10 74 27"/>
              <Combo id="cmb_instcd" taborder="1" class="combo_s_essential" enable="false" position="absolute 72 9 197 28"/>
              <Static id="caption2" text="근무년월 :" class="search_name" position="absolute 221 10 312 27"/>
              <Calendar id="ipt_dutym" taborder="2" class="input_search" position="absolute 308 9 418 28" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" style="align:center middle;" autoselect="true" autoskip="true" onchanged="grp_sea_ipt_dutym_onchanged"/>
              <Static id="caption5" text="관리부서 :" class="search_name" position="absolute 443 10 529 27"/>
              <Edit id="ipt_dutdeptcd" taborder="3" class="input_s_essential" position="absolute 530 9 615 28" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_dutdeptcd_onkeyup"/>
              <Button id="btn_dutdept" taborder="4" class="icon_search" position="absolute 621 11 637 27" onclick="grp_sea_btn_dutdept_onclick"/>
              <Edit id="ipt_dutdeptnm" taborder="5" class="input_search" position="absolute 639 9 773 28" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_dutdeptnm_onkeyup"/>
              <Static id="caption7" text="사번 :" class="search_name" position="absolute 793 9 856 26"/>
              <Edit id="ipt_emplnos" taborder="6" class="input_essential" position="absolute 854 9 916 28" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_emplnos_onkeyup"/>
              <Button id="btn_emplno" taborder="7" class="icon_search" position="absolute 918 9 934 25" onclick="grp_sea_btn_emplno_onclick"/>
              <Edit id="ipt_emplnms" taborder="8" class="input_default" position="absolute 935 9 1041 28" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_emplnms_onkeyup"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1085 8 1091 30" anchor="top right"/>
              <Button id="btn_search" taborder="9" text="조회" class="btn1" position="absolute 1108 8 1164 30" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption278" text="사원목록" class="tit_2" position="absolute 0 102 157 124"/>
        <Shape id="line207" class="line_10" position="absolute 0 118 1195 124" anchor="left top right"/>
        <Grid id="grd_deduitemlist" taborder="3" binddataset="ds_main_deduitem_deduitemlist" useinputpanel="false" position="absolute 0 123 1195 788" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="22"/>
                <Column size="96"/>
                <Column size="93"/>
                <Column size="83"/>
                <Column size="91"/>
                <Column size="494"/>
                <Column size="95"/>
                <Column size="89"/>
                <Column size="112"/>
                <Column size="0"/>
                <Column size="0"/>
                <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="휴일갯수"/>
                <Cell col="4" text="잔여휴일수"/>
                <Cell col="5" text="부서"/>
                <Cell col="6" text="입사일"/>
                <Cell col="7" text="퇴사일"/>
                <Cell col="8" text="확정여부"/>
                <Cell col="9" text="caption1"/>
                <Cell col="10" text="caption2"/>
                <Cell col="11" text="caption3"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:emplno" enable="false"/>
                <Cell col="2" style="align:left middle;" text="bind:emplnm"/>
                <Cell col="3" displaytype="text" edittype="text" style="align:center middle;" text="bind:holicnt"/>
                <Cell col="4" displaytype="text" edittype="text" style="align:center middle;" text="bind:jancnt"/>
                <Cell col="5" text="bind:dutplcedeptnm"/>
                <Cell col="6" text="bind:entcodd" mask="####-##-##" maskchar=" " calendardisplaynulltype="nulltext"/>
                <Cell col="7" text="bind:retiredd" mask="####-##-##" maskchar=" " calendardisplaynulltype="nulltext"/>
                <Cell col="8" displaytype="checkbox" edittype="checkbox" text="bind:deprtmangrdutcnfmyn" expr="expr:deprtmangrdutcnfmyn == 'Y' ? 1 : 0"/>
                <Cell col="9" text="bind:dutym"/>
                <Cell col="10" text="bind:instcd"/>
                <Cell col="11" text="bind:oldholicnt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Combo id="cmb_dutplce" taborder="4" class="combo_search" visible="false" position="absolute 345 98 588 117" onitemchanged="cmb_dutplce_onitemchanged"/>
        <Radio id="radio1" taborder="5" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 675 99 835 119" onitemchanged="radio1_onitemchanged">
          <Dataset id="innerdataset">
            <ColumnInfo>
              <Column id="codecolumn"/>
              <Column id="datacolumn"/>
            </ColumnInfo>
            <Rows>
              <Row>
                <Col id="codecolumn"/>
                <Col id="datacolumn">전체</Col>
              </Row>
              <Row>
                <Col id="codecolumn">Y</Col>
                <Col id="datacolumn">확정</Col>
              </Row>
              <Row>
                <Col id="codecolumn">N</Col>
                <Col id="datacolumn">미확정</Col>
              </Row>
            </Rows>
          </Dataset>
        </Radio>
        <CheckBox id="bool1" taborder="6" position="absolute 946 98 968 118" truevalue="Y" falsevalue="N"/>
        <Button id="button1" taborder="7" text="전체적용" class="btn4" position="absolute 968 96 1048 118" onclick="button1_onclick"/>
        <Button id="btn_saveexcel" taborder="8" text="엑셀저장" onclick="btn_saveexcel_onclick" class="btn7" position="absolute 1114 99 1194 118" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_deduitem" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_deduitem_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="dutym" type="STRING" size="256"/>
          <Column id="dutunitcd" type="STRING" size="256"/>
          <Column id="dutunitnm" type="STRING" size="256"/>
          <Column id="conformyn" type="STRING" size="256"/>
          <Column id="chkyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="dutym"/>
            <Col id="dutunitcd"/>
            <Col id="dutunitnm"/>
            <Col id="conformyn"/>
            <Col id="chkyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_deduitem_deduitemlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_deduitem_deduitemlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="emplno" type="STRING" size="256" sumtext="사원번호"/>
          <Column id="emplnm" type="STRING" size="256" sumtext="사원명"/>
          <Column id="holicnt" type="STRING" size="256" sumtext="휴일갯수"/>
          <Column id="jancnt" type="STRING" size="256" sumtext="잔여갯수"/>
          <Column id="entcodd" type="STRING" size="256" sumtext="입사일자"/>
          <Column id="retiredd" type="STRING" size="256" sumtext="퇴사일자"/>
          <Column id="dutym" type="STRING" size="256" sumtext="근무년월"/>
          <Column id="dutplcedeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="oldholicnt" type="STRING" size="256" sumtext="휴일갯수"/>
          <Column id="deprtmangrdutcnfmyn" type="STRING" size="256" sumtext="승인여부"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send_deduitem" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_dutym" propid="value" datasetid="ds_send_deduitem" columnid="dutym"/>
      <BindItem id="item2" compid="grp_sea.ipt_dutdeptcd" propid="value" datasetid="ds_send_deduitem" columnid="dutunitcd"/>
      <BindItem id="item3" compid="grp_sea.ipt_dutdeptnm" propid="value" datasetid="ds_send_deduitem" columnid="dutunitnm"/>
      <BindItem id="item4" compid="grp_sea.ipt_emplnos" propid="value" datasetid="ds_send_deduitem" columnid="emplno"/>
      <BindItem id="item5" compid="grp_sea.ipt_emplnms" propid="value" datasetid="ds_send_deduitem" columnid="emplnm"/>
      <BindItem id="item6" compid="bool1" propid="value" datasetid="ds_send_deduitem" columnid=""/>
      <BindItem id="item7" compid="radio1" propid="value" datasetid="ds_send_deduitem" columnid="conformyn"/>
      <BindItem id="item8" compid="cmb_dutplce" propid="value" datasetid="ds_send_deduitem" columnid="dutunitcd"/>
    </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_dligclaznsmngtxp::RPD001.xjs";
include "mis_humtrafactmngtxp::RPB001.xjs";
function SMRPD12500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD12500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_deduitemlist);
	grdf_setRowTypeIcon(grd_deduitemlist, 0);
	
	misfGridInit(grd_deduitemlist);
	
	//misfMsterDetailSet(grd_deduitemlist,null, "TRRPD12501" ,"Y"); 
	
	var curdate = utlf_getCurrentDate();
	
	ds_send_deduitem.setColumn(0, "dutym", String(curdate).substr(0,6));
	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	misfGetUserAuth();
	
	rpdfSetControlAuth();
	rpdfComboCdList(cmb_dutplce);
	rpdfSetDutUnitCombo();
	
	ds_send_deduitem.enableevent = false;
	ds_send_deduitem.setColumn(0, "dutunitcd", DUT_UNIT_CD);
	ds_send_deduitem.setColumn(0, "dutunitnm", DUT_UNIT_NM);
	ds_send_deduitem.enableevent = true;
	ds_send_deduitem.setColumn(0, "chkyn", "N");
	
	misfComboInstCdListMulti("grp_sea.cmb_instcd",utlf_getCurrentDate(),"","N");
	cmb_dutplce.visible = false;
}

function grp_sea_ipt_dutym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_deduitem.setColumn(0, "dutym", String(obj.value).substr(0,6));
}

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

function grp_sea_btn_dutdept_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", grp_sea.ipt_dutdeptcd,"","dutunitcd,dutunitnm", grp_sea.cmb_instcd.value + "," + String(ds_send_deduitem.getColumn(0, "dutym")).substr(0,6)+"31", "instcd,basedd");
	grp_sea.btn_search.click();
}

function grp_sea_ipt_dutdeptcd_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", grp_sea.cmb_instcd.value, "instcd" );
		ds_send_deduitem.setColumn(0, "dutunitcd", cmb_dutplce.value);
	}
}

function grp_sea_ipt_dutdeptnm_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", grp_sea.cmb_instcd.value, "instcd" );
		ds_send_deduitem.setColumn(0, "dutunitcd", cmb_dutplce.value);
	}
}

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

function grp_sea_btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "emplno,emplnm" ;
	rpbfOpenPopUpList("SPRPB00101", grp_sea.ipt_emplnos, recv_list,"1","N");	
	
	if (String(grp_sea.ipt_emplnos.value).length > 0) 
	{
		grp_sea.btn_search.click();
	}
}

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

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRPD12501";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetHoliCount2List";
		oParam.inds        = "req=ds_send_deduitem";
		oParam.outds       = "ds_main_deduitem_deduitemlist=deduitemlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD12501";

	tranf_submit(oParam);
}

function radio1_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
}

function cmb_dutplce_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var chkyn = ds_send_deduitem.getColumn(0, "chkyn");
	
	for (var i = 0; i < ds_main_deduitem_deduitemlist.rowcount; i++)
	{
		ds_main_deduitem_deduitemlist.setColumn(i, "deprtmangrdutcnfmyn", chkyn);
		ds_main_deduitem_deduitemlist.updatecontrol = false;
		ds_main_deduitem_deduitemlist.setRowType(i, "u");
		ds_main_deduitem_deduitemlist.updatecontrol = true;
	}
}

function btn_saveexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_deduitemlist, "excel", "see", "true", "", "");
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TXRPD12501";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqExeHoliConformList";
		oParam.inds        = "deduitemlist=ds_main_deduitem_deduitemlist:u";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXRPD12501";

	tranf_submit(oParam);
}

function cf_TXRPD12501(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		grp_sea.btn_search.click();
	}
}

function ds_main_deduitem_deduitemlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "deprtmangrdutcnfmyn")
	{
		obj.setColumn(e.row, "deprtmangrdutcnfmyn", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
	}
}
]]></Script>
  </Form>
</FDL>