YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD03350_근태집계합산조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD03350" position="absolute 0 0 1200 794" titletext="근태 집계 합산 조회" oninit="SMRPD03350_oninit" onload="SMRPD03350_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="근태집계합산조회" class="tit_1" position="absolute 0 0 264 25"/>
        <Shape id="line4" class="line_6" position="absolute 0 40 1195 46" anchor="left top right"/>
        <Div id="group4" taborder="1" position="absolute 0 45 1195 85" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption5" text="소속기관 :" class="search_name" position="absolute 10 11 96 28"/>
              <Combo id="cmb_instcd" taborder="1" class="combo_search" position="absolute 100 10 235 29" onitemchanged="group4_cmb_instcd_onitemchanged"/>
              <Static id="caption1" text="근무년월 :" class="search_name" position="absolute 245 11 331 28"/>
              <Calendar id="ipt_frdutym" taborder="2" class="input_search" position="absolute 330 10 400 29" mask="yyyy-mm" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group4_ipt_frdutym_onchanged"/>
              <Static id="caption4" text="~" position="absolute 402 11 417 31"/>
              <Calendar id="ipt_todutym" taborder="3" class="input_search" position="absolute 415 10 485 29" mask="yyyy-mm" autoselect="true" autoskip="true" dateformat="yyyy-MM" editformat="yyyy-MM" onchanged="group4_ipt_todutym_onchanged"/>
              <Static id="caption2" text="근무부서 :" class="search_name" position="absolute 494 11 582 28"/>
              <Combo id="combo1" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 579 10 659 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="5" class="input_search" position="absolute 660 10 730 29" autoselect="true" autoskip="true" onkeyup="group4_ipt_dutdeptcd_onkeyup"/>
              <Button id="btn_dutdept" taborder="6" class="icon_search" position="absolute 733 12 749 28" onclick="group4_btn_dutdept_onclick"/>
              <Edit id="ipt_dutdeptnm" taborder="7" class="input_search" position="absolute 751 10 865 29" autoselect="true" autoskip="true" onkeyup="group4_ipt_dutdeptnm_onkeyup"/>
              <Static id="caption3" text="사번 :" class="search_name" position="absolute 870 11 933 28"/>
              <Edit id="ipt_emplnos" taborder="8" class="input_default" position="absolute 931 10 990 29" autoselect="true" autoskip="true" onkeyup="group4_ipt_emplnos_onkeyup"/>
              <Button id="btn_emplno" taborder="9" class="icon_search" position="absolute 993 11 1009 27" onclick="group4_btn_emplno_onclick"/>
              <Edit id="ipt_emplnms" taborder="10" class="input_default" position="absolute 1012 10 1090 29" autoselect="true" autoskip="true" onkeyup="group4_ipt_emplnms_onkeyup"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1107 8 1113 30" anchor="top right"/>
              <Button id="btn_search" taborder="11" text="조회" class="btn1" position="absolute 1125 9 1181 31" anchor="top right" onclick="group4_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption7" text="근태미대상 제외" position="absolute 997 96 1103 116" anchor="top right"/>
        <CheckBox id="bool1" taborder="2" position="absolute 972 95 997 115" anchor="top right" truevalue="Y" falsevalue="N"/>
        <Static id="caption278" text="근태집계목록" class="tit_2" position="absolute 0 98 154 120"/>
        <Shape id="line207" class="line_10" position="absolute 0 114 1195 120" anchor="left top right"/>
        <Grid id="grd_dutsumlist" taborder="3" binddataset="ds_main_list_dutsumlist" useinputpanel="false" position="absolute 0 119 1195 789" autoenter="select" cellsizingtype="col" autofittype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="180"/>
                <Column size="86"/>
                <Column size="101"/>
                <Column size="73"/>
                <Column size="108"/>
                <Column size="71"/>
                <Column size="65"/>
                <Column size="68"/>
                <Column size="66"/>
                <Column size="77"/>
                <Column size="67"/>
                <Column size="65"/>
                <Column size="65"/>
                <Column size="59"/>
                <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="응급소급"/>
                <Cell col="12" text="야간소급"/>
                <Cell col="13" text="휴일소급"/>
                <Cell col="14" text="생휴"/>
                <Cell col="15" text="caption3"/>
                <Cell col="16" text="caption1"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" style="align:left middle;padding:2 2 2 5;" text="bind:dutplcedeptnm" enable="false"/>
                <Cell col="2" style="align:left middle;padding:2 2 2 5;" text="bind:jobposnm" enable="false"/>
                <Cell col="3" edittype="none" text="bind:emplno" enable="false"/>
                <Cell col="4" style="align:left middle;padding:0 0 0 5;" text="bind:emplnm" enable="false"/>
                <Cell col="5" text="bind:rregno" mask="######-#######" maskchar=" " enable="false"/>
                <Cell col="6" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:ovtmworkextnbiztm150" mask="9.0" maskchar=" " enable="false"/>
                <Cell col="7" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:tranalwntm" mask="###.0" maskchar=" " enable="false"/>
                <Cell col="8" displaytype="text" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:nigtlabrtm" enable="false"/>
                <Cell col="9" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:holiduttm" mask="9.0" maskchar=" " enable="false"/>
                <Cell col="10" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:extnnigtbfmmstktm150" mask="9.0" maskchar=" " enable="false"/>
                <Cell col="11" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:tranalwnmnt" mask="9,999.0" maskchar=" " suppress="0" enable="false"/>
                <Cell col="12" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:nigtlabrmnt" mask="9.0" maskchar=" " suppress="0" enable="false"/>
                <Cell col="13" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:holidutmnt" mask="9.0" maskchar=" " enable="false"/>
                <Cell col="14" edittype="none" style="align:right middle;padding:0 5 0 0;" text="bind:earlyattdnctm150" maskchar=" " enable="false"/>
                <Cell col="15" text="bind:dutym"/>
                <Cell col="16" text="bind:appscheexecflag"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excsave" taborder="4" text="엑셀저장" class="btn7" position="absolute 1101 95 1181 114" anchor="top right" onclick="btn_excsave_onclick"/>
      </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="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="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"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
      <BindItem id="item1" compid="group4.ipt_frdutym" propid="value" datasetid="ds_send_retrparams" columnid="frdutym"/>
      <BindItem id="item2" compid="group4.ipt_todutym" propid="value" datasetid="ds_send_retrparams" columnid="todutym"/>
      <BindItem id="item3" compid="group4.combo1" propid="value" datasetid="ds_send_retrparams" columnid="deptgb"/>
      <BindItem id="item4" compid="group4.ipt_dutdeptcd" propid="value" datasetid="ds_send_retrparams" columnid="dutunitcd"/>
      <BindItem id="item5" compid="group4.ipt_dutdeptnm" propid="value" datasetid="ds_send_retrparams" columnid="dutunitnm"/>
      <BindItem id="item6" compid="group4.ipt_emplnos" propid="value" datasetid="ds_send_retrparams" columnid="emplno"/>
      <BindItem id="item7" compid="group4.ipt_emplnms" propid="value" datasetid="ds_send_retrparams" columnid="emplnm"/>
      <BindItem id="item8" compid="bool1" propid="value" datasetid="ds_send_retrparams" columnid="gb"/>
    </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 SMRPD03350_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

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

function fInitialize()
{
	misfGridInit(grd_dutsumlist);
	
	misfGetAndSetUserInfo();
	misfComboInstCdListMulti("group4.cmb_instcd", utlf_getCurrentDate(),"","N");
	
	ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparams.setColumn(0, "frdutym", String(utlf_getCurrentDate()).substr(0,6));
	ds_send_retrparams.setColumn(0, "todutym", String(utlf_getCurrentDate()).substr(0,6));
	ds_send_retrparams.setColumn(0, "deptgb", "1");
	ds_send_retrparams.setColumn(0, "gb", "N");
	
	group4.btn_search.click();
}

function group4_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	group4.btn_search.click();
}

function group4_ipt_frdutym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_retrparams.setColumn(0, "frdutym", String(obj.value).substr(0,6));
	group4.btn_search.click();
}

function group4_ipt_todutym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_retrparams.setColumn(0, "todutym", String(obj.value).substr(0,6));
	group4.btn_search.click();
}

function group4_ipt_dutdeptcd_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", group4.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", group4.cmb_instcd.value, "instcd" );
	}
	if(e.columnid == "dutunitnm")
	{
		group4.ipt_dutdeptnm.value = e.newvalue;
		group4.ipt_dutdeptnm.setFocus();
		misfValidationCheck("02", "", "dutunitcd,dutunitnm", group4.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", group4.cmb_instcd.value, "instcd");
}

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

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_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

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

	tranf_submit(oParam);
}

function ds_main_list_dutsumlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if (e.columnid == "tranalwnmnt" ) 
	{
		var cnt = ds_main_list_dutsumlist.getColumn(ds_main_list_dutsumlist.rowposition, "tranalwnmnt");
		var hcnt = parseFloat(cnt) * 1;
		
		ds_main_list_dutsumlist.setColumn(ds_main_list_dutsumlist.rowposition, "tranalwnmnt", hcnt);
	}
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_dutsumlist);
}
]]></Script>
  </Form>
</FDL>