YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD12600_월별휴일일수조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD12600" position="absolute 0 0 1200 785" titletext="월별휴일일수관리" oninit="SMRPD12600_oninit" onload="SMRPD12600_onload">
    <Layouts>
      <Layout>
        <Div id="group4" anchor="left top right" taborder="6" class="div_SA2" position="absolute 0 47 1190 87">
          <Layouts>
            <Layout>
              <Static id="cap_instcd" text="기관:" class="search_name" position="absolute 13 12 74 29" anchor="default"/>
              <Combo id="cmb_instcd" taborder="12" class="combo_s_essential" enable="false" position="absolute 72 10 197 29" anchor="default"/>
              <Static id="caption2" text="근무년월 :" class="search_name" position="absolute 226 12 309 29" anchor="default"/>
              <Calendar id="ipt_dutym" taborder="13" autoselect="true" autoskip="true" class="input_search" position="absolute 308 10 383 29" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group4_ipt_dutym_onchanged"/>
              <Calendar id="input1" taborder="14" autoselect="true" autoskip="true" class="input_search" position="absolute 398 10 473 29" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" editformat="yyyy-MM" onchanged="group4_input1_onchanged"/>
              <Static id="caption1" text="~" position="absolute 387 14 394 26" anchor="default"/>
              <Combo id="cmb_dutplce" taborder="15" class="combo_search" position="absolute 575 10 805 29" anchor="default" visible="false" onitemchanged="group4_cmb_dutplce_onitemchanged"/>
              <Static id="caption5" text="근무부서 :" class="search_name" position="absolute 494 12 573 29" anchor="default"/>
              <Static id="caption7" text="사번 :" class="search_name" position="absolute 827 11 882 28" anchor="default"/>
              <Edit id="ipt_emplnos" taborder="16" autoselect="true" autoskip="true" class="input_essential" enable="false" position="absolute 884 10 943 29" anchor="default" onkeydown="group4_ipt_emplnos_onkeydown"/>
              <Button id="btn_emplno" taborder="17" class="icon_search" enable="false" position="absolute 945 11 961 27" anchor="default" onclick="group4_btn_emplno_onclick"/>
              <Edit id="ipt_emplnms" taborder="18" autoselect="true" autoskip="true" class="input_default" enable="false" position="absolute 968 10 1048 29" anchor="default" onkeydown="group4_ipt_emplnms_onkeydown"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1095 9 1101 31" anchor="top right"/>
              <Button id="btn_search" taborder="19" text="조회" class="btn1" position="absolute 1118 9 1174 31" anchor="top right" onclick="group4_btn_search_onclick"/>
              <Edit id="ipt_dutdeptcd" taborder="20" autoselect="true" autoskip="true" class="input_search" enable="false" position="absolute 575 10 655 29" anchor="default" onkeydown="group4_ipt_dutdeptcd_onkeydown" visible="false"/>
              <Button id="btn_dutdept" taborder="21" class="icon_search" enable="false" position="absolute 656 11 672 27" anchor="default" onclick="group4_btn_dutdept_onclick" visible="false"/>
              <Edit id="ipt_dutdeptnm" taborder="22" autoselect="true" autoskip="true" class="input_search" enable="false" position="absolute 678 10 805 29" anchor="default" onkeydown="group4_ipt_dutdeptnm_onkeydown" visible="false"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="월별휴일일수조회(기간)" class="tit_1" position="absolute 0 0 280 25"/>
        <Static id="caption278" text="사원목록" class="tit_2" position="absolute 0 97 157 119"/>
        <Shape id="line207" class="line_10" position="absolute 0 113 1192 119" anchor="left top right"/>
        <Grid id="grd_deduitemlist" taborder="1" binddataset="ds_main_deduitem_deduitemlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 118 1192 778" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="85"/>
                <Column size="90"/>
                <Column size="100"/>
                <Column size="85"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="330"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="90"/>
                <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="퇴사일"/>
                <Cell col="10" text="확정여부"/>
                <Cell col="11" text="caption1"/>
                <Cell col="12" text="caption2"/>
                <Cell col="13" text="caption3"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="date" text="bind:dutym" mask="yyyy-MM" calendardisplaynulltype="nulltext"/>
                <Cell col="2" text="bind:emplno" enable="false"/>
                <Cell col="3" style="align:left middle;" text="bind:emplnm"/>
                <Cell col="4" style="align:center middle;" text="bind:jobkindnm"/>
                <Cell col="5" displaytype="normal" edittype="expr:deprtmangrdutcnfmyn == 'Y' ? 'none' : 'normal'" style="align:center middle;background:EXPR(holicnt == '0' || utlf_isNull(holicnt) ? '#ff99cc' : '');background2:EXPR(holicnt == '0' || utlf_isNull(holicnt) ? '#ff99cc' : '');" text="bind:holicnt"/>
                <Cell col="6" displaytype="normal" edittype="expr:deprtmangrdutcnfmyn == 'Y' ? 'none' : 'normal'" style="align:center middle;background:EXPR(jancnt == '0' || utlf_isNull(jancnt) ? '#ff99cc' : '');background2:EXPR(jancnt == '0' || utlf_isNull(jancnt) ? '#ff99cc' : '');" text="bind:jancnt"/>
                <Cell col="7" text="bind:dutplcedeptnm"/>
                <Cell col="8" displaytype="date" style="align:center middle;" text="bind:entcodd" calendardisplaynulltype="nulltext"/>
                <Cell col="9" displaytype="date" style="align:center middle;" text="bind:retiredd" calendardisplaynulltype="nulltext"/>
                <Cell col="10" displaytype="checkbox" text="bind:deprtmangrdutcnfmyn" expr="expr:deprtmangrdutcnfmyn == 'Y' ? 1 : 0" enable="false"/>
                <Cell col="11" text="bind:dutym"/>
                <Cell col="12" text="bind:instcd"/>
                <Cell col="13" text="bind:oldholicnt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_deduitemamtlist" taborder="2" binddataset="ds_main_deduitemamt_deduitemamtlist" useinputpanel="false" visible="false" position="absolute 1150 150 1165 565">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="129"/>
                <Column size="62"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="OFF일"/>
                <Cell col="1" text="요일"/>
                <Cell col="2" text="caption1"/>
                <Cell col="3" text="caption3"/>
                <Cell col="4" text="caption2"/>
              </Band>
              <Band id="body">
                <Cell enable="false" text="bind:dutdd" mask="yyyy-mm-dd"/>
                <Cell col="1" text="bind:yoil" mask="(-)#,###"/>
                <Cell col="2" text="bind:emplno"/>
                <Cell col="3" text="bind:dutym"/>
                <Cell col="4" text="bind:instcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_saveexcel" taborder="3" text="엑셀저장" class="btn7" position="absolute 1111 94 1191 113" anchor="top right" onclick="btn_saveexcel_onclick"/>
        <CheckBox id="chk_tempyn" taborder="4" text="마지막 근무지 기준으로 전체기간 조회" truevalue="Y" position="absolute 872 93 1102 113" anchor="top right" visible="true" onclick="chk_tempyn_onclick"/>
        <Button id="btn_save" taborder="5" text="저장" class="btn4" enable="false" position="absolute 1135 22 1191 44" anchor="top right" onclick="btn_save_onclick"/>
        <Shape id="line9" class="line_6" position="absolute 0 43 1192 49" anchor="left 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">
        <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="duttoym" type="STRING" size="256"/>
          <Column id="dutunitcd" type="STRING" size="256"/>
          <Column id="dutunitnm" type="STRING" size="256"/>
          <Column id="lastyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="dutym"/>
            <Col id="duttoym"/>
            <Col id="dutunitcd"/>
            <Col id="dutunitnm"/>
            <Col id="lastyn"/>
          </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="dutdd" type="STRING" size="256" sumtext="휴일일자"/>
          <Column id="yoil" type="STRING" size="256" sumtext="요일"/>
          <Column id="dutym" type="STRING" size="256" sumtext="근무년월"/>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_deduitemamt_deduitemamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_combocd_combocdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_cmb_dutplce_combocodelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_userinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.cmb_instcd" propid="value" datasetid="ds_send_deduitem" columnid="instcd"/>
      <BindItem id="item1" compid="group4.ipt_dutym" propid="value" datasetid="ds_send_deduitem" columnid="dutym"/>
      <BindItem id="item2" compid="group4.input1" propid="value" datasetid="ds_send_deduitem" columnid="duttoym"/>
      <BindItem id="item3" compid="group4.ipt_dutdeptcd" propid="value" datasetid="ds_send_deduitem" columnid="dutunitcd"/>
      <BindItem id="item4" compid="group4.cmb_dutplce" propid="value" datasetid="ds_send_deduitem" columnid="dutunitcd"/>
      <BindItem id="item5" compid="group4.ipt_dutdeptnm" propid="value" datasetid="ds_send_deduitem" columnid="dutunitnm"/>
      <BindItem id="item6" compid="group4.ipt_emplnos" propid="value" datasetid="ds_send_deduitem" columnid="emplno"/>
      <BindItem id="item7" compid="group4.ipt_emplnms" propid="value" datasetid="ds_send_deduitem" columnid="emplnm"/>
      <BindItem id="item8" compid="chk_tempyn" propid="value" datasetid="ds_send_deduitem" columnid="lastyn"/>
    </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";
include "mis_dligclaznsmngtxp::RPD001.xjs";
function SMRPD12600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD12600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_deduitemlist);
	grdf_setRowTypeIcon(grd_deduitemlist, 0);
	
	var curdate = String(utlf_getCurrentDate());
	
	ds_send_deduitem.setColumn(0, "dutym", curdate.substr(0,6));
	ds_send_deduitem.setColumn(0, "duttoym", curdate.substr(0,6));
	ds_send_deduitem.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	misfGetUserAuth();
	misfGetAndSetUserInfo();
	
	if(DUTY_CERT_YN == "Y" || !utlf_isNull(JOB_POS_CD))
	{
		group4.ipt_emplnos.enable = true;
		group4.btn_emplno.enable = true;
		group4.ipt_emplnms.enable = true;
		btn_save.enable = true;
		
		if(DUTY_DILI_YN == "Y")
		{
			group4.ipt_dutdeptcd.enable = true;
			group4.btn_dutdept.enable = true;
			group4.ipt_dutdeptnm.enable = true;
		}
	}
	
	if (DUTY_PART_YN == "Y" && DUTY_MOVE_YN == "Y") 
	{
		group4.cmb_dutplce.visible = false;
	} 
	else 
	{
		group4.cmb_dutplce.visible = true;
	}
	
	rpdfComboCdList(group4.cmb_dutplce);
	rpdfSetDutUnitCombo();
	
	ds_send_deduitem.setColumn(0, "emplno", sysf_getUserId());
	ds_send_deduitem.setColumn(0, "emplnm", sysf_getUserName());
	
	ds_send_deduitem.setColumn(0, "dutunitcd", DUT_PLCEDEPT_CD);
	ds_send_deduitem.setColumn(0, "dutunitnm", DUT_PLCEDEPT_NM);
	
	misfComboInstCdListMulti("group4.cmb_instcd",utlf_getCurrentDate(),"","N");
}

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

function group4_input1_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = String(obj.value).substr(0,6);
	
	ds_send_deduitem.setColumn(0, "duttoym", date);
}

function group4_ipt_dutdeptcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", group4.cmb_instcd.value, "instcd" );
	}
}

function group4_btn_dutdept_onclick(obj:Button,  e:ClickEventInfo)
{
	 misfOpenPopUpList("02", ds_send_deduitem,"","dutunitcd,dutunitnm", group4.cmb_instcd.value + "," + group4.ipt_dutym.value+"01", "instcd,basedd");
}

function group4_ipt_dutdeptnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", group4.cmb_instcd.value, "instcd" );
	}
}

function group4_cmb_dutplce_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	group4_btn_search_onclick();
}

function group4_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridInit(grd_deduitemlist);
	
	var oParam = {};
		oParam.id          = "TRRPD12602";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetHoliCountDtlInfoList";
		oParam.inds        = "req=ds_send_deduitem";
		oParam.outds       = "ds_main_deduitem_deduitemlist=deduitemamtlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD12602";

	tranf_submit(oParam);
}

function group4_ipt_emplnos_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(utlf_isNull(obj.value))
	{
		var recv_list = "emplno,emplnm" ;
		rpbfValidationCheck("EMPLNO", recv_list);
		
		if (String(obj.value).length > 0) 
		{
			group4_btn_search_onclick();
		}
	}
}

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

function group4_ipt_emplnms_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(utlf_isNull(obj.value))
	{
		var recv_list = "emplno,emplnm" ;
		rpbfValidationCheck("EMPLNM", recv_list);
		
		if (String(group4.ipt_emplnos.value).length > 0) 
		{
			group4_btn_search_onclick();
		}
	}
}

function chk_tempyn_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if(obj.value == "Y")
	{
	}
	else
	{
		ds_send_deduitem.setColumn(0, "lastyn", "");
	}
}

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

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TXRPD12401";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqExeHoliCountList";
		oParam.inds        = "deduitemlist=ds_main_deduitem_deduitemlist:u deduitemamtlist=ds_main_deduitemamt_deduitemamtlist:u";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXRPD12401";

	tranf_submit(oParam);
}

function cf_TXRPD12401(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
    else
    {
		group4_btn_search_onclick();
    }
}

function ds_main_deduitem_deduitemlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if (e.columnid == "emplno" ) 
	{
		var recv_list = "emplno,emplnm";
		misfValidationCheck("01-1", "", recv_list);
		
		if(!utlf_isNull(obj.getColumn(e.row, "emplno")))
		{
			misfGridInit(grd_deduitemamtlist);
			//btn_grdadddeduitemamtlist.dispatch("DOMActivate");
		}
	}
	
	if(e.columnid == "holicnt")
	{
		if(obj.getColumn(e.row, "deprtmangrdutcnfmyn") == "Y")
		{
			sysf_messageBox("확정된 자료는 수정할 수 없습니다.", "E999", "");
			obj.setColumn(e.row, "holicnt", obj.getColumn(e.row, "oldholicnt"));
			
			obj.updatecontrol = false;
			obj.setRowType(e.row, "");
			obj.updatecontrol = true;
			return;
		}
	}
}
]]></Script>
  </Form>
</FDL>