YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD12720_기간별사유조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD12720" position="absolute 0 0 1206 781" titletext="휴일일수 및 미사용 휴일일수" oninit="SMRPD12720_oninit" onload="SMRPD12720_onload">
    <Layouts>
      <Layout>
        <Combo position="absolute 280 66 405 85" id="cmb_instcd" class="combo_s_essential" enable="false" visible="false"/>
        <Static id="caption6" text="휴일일수 사용 조회" class="tit_1" position="absolute 0 0 270 25"/>
        <Div id="grp_sea" taborder="1" position="absolute 0 25 1200 65" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption2" text="기간:" class="search_name" position="absolute 10 12 101 29"/>
              <Calendar id="ipt_dutym" taborder="1" class="input_search" position="absolute 77 11 157 30" mask="" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_sea_ipt_dutym_onchanged"/>
              <Static id="caption1" text="~" position="absolute 159 11 174 31"/>
              <Calendar id="ipt_edutym" taborder="2" class="input_search" position="absolute 177 11 257 30" mask="" autoselect="true" autoskip="true" dateformat="yyyy-MM" editformat="yyyy-MM" onchanged="grp_sea_ipt_edutym_onchanged"/>
              <Static id="caption3" text="부서 :" class="search_name" position="absolute 322 12 425 29"/>
              <Combo id="cmb_unitcd" taborder="3" innerdataset="@ds_temp_nrunit" codecolumn="deptcd" datacolumn="deptnm" class="combo_search" position="absolute 392 11 612 30" onitemchanged="grp_sea_cmb_unitcd_onitemchanged"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1093 11 1099 33" anchor="top right"/>
              <Button id="btn_search" taborder="4" text="조회" class="btn1" position="absolute 1111 11 1167 33" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_saveexcel" taborder="2" text="엑셀저장" class="btn7" position="absolute 1120 86 1200 105" anchor="top right" onclick="btn_saveexcel_onclick"/>
        <Shape id="line207" class="line_10" position="absolute 0 105 1200 111" anchor="left top right"/>
        <Grid id="grd_nrlist" class="datagrid2" taborder="3" binddataset="ds_main_nrlist" useinputpanel="false" position="absolute 0 110 1200 775" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="22"/>
                <Column size="100"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="68"/>
                <Column size="68"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="68"/>
                <Column size="43"/>
                <Column size="60"/>
                <Column size="43"/>
                <Column size="43"/>
                <Column size="73"/>
              </Columns>
              <Rows>
                <Row size="34" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="부서명" taborder="undefined"/>
                <Cell col="2" colspan="15" text="ⓐ 사유별 미사용 휴일수" taborder="undefined"/>
                <Cell col="17" colspan="5" text="ⓑ 사유별 초과사용 휴일수" taborder="undefined"/>
                <Cell col="22" text="최종 미사용&#10;휴일수"/>
                <Cell row="1" col="2" text="분만"/>
                <Cell row="1" col="3" text="휴직"/>
                <Cell row="1" col="4" text="교육(병원)"/>
                <Cell row="1" col="5" text="교육(노조)"/>
                <Cell row="1" col="6" text="병가"/>
                <Cell row="1" col="7" text="청원"/>
                <Cell row="1" col="8" text="사직"/>
                <Cell row="1" col="9" text="부서변경"/>
                <Cell row="1" col="10" text="신규임용"/>
                <Cell row="1" col="11" text="출장"/>
                <Cell row="1" col="12" text="하계"/>
                <Cell row="1" col="13" text="산재"/>
                <Cell row="1" col="14" text="파업"/>
                <Cell row="1" col="15" text="기타"/>
                <Cell row="1" col="16" text="합계"/>
                <Cell row="1" col="17" text="가동율저하"/>
                <Cell row="1" col="18" text="공사"/>
                <Cell row="1" col="19" text="병상축소"/>
                <Cell row="1" col="20" text="기타"/>
                <Cell row="1" col="21" text="합계"/>
                <Cell row="1" col="22" text="ⓐ - ⓑ"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" style="align:left middle;padding:2 2 2 2;background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:dutplcedeptnm"/>
                <Cell col="2" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt01"/>
                <Cell col="3" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt02"/>
                <Cell col="4" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt03"/>
                <Cell col="5" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt04"/>
                <Cell col="6" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt05"/>
                <Cell col="7" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt06"/>
                <Cell col="8" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt07"/>
                <Cell col="9" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt08"/>
                <Cell col="10" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt09"/>
                <Cell col="11" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt10"/>
                <Cell col="12" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt11"/>
                <Cell col="13" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt12"/>
                <Cell col="14" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt13"/>
                <Cell col="15" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt14"/>
                <Cell col="16" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cntgbn1"/>
                <Cell col="17" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt91"/>
                <Cell col="18" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt92"/>
                <Cell col="19" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt93"/>
                <Cell col="20" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cnt94"/>
                <Cell col="21" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:cntgbn2"/>
                <Cell col="22" style="background:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');background2:EXPR(currow== ds_main_nrlist.rowcount-1  ? '#E5EFFC' : '');font:EXPR(currow== ds_main_nrlist.rowcount-1  ? 'arial,9,bold' : '');" text="bind:lastsum"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption278" text="내역" class="tit_2" position="absolute 0 89 240 112"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" 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="sdutym" type="STRING" size="256"/>
          <Column id="edutym" type="STRING" size="256"/>
          <Column id="dutplcedeptcd" type="STRING" size="256"/>
          <Column id="dutplcedeptnm" type="STRING" size="256"/>
          <Column id="unitcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="sdutym"/>
            <Col id="edutym"/>
            <Col id="dutplcedeptcd"/>
            <Col id="dutplcedeptnm"/>
            <Col id="unitcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_nrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="gbn" type="STRING" size="256" sumtext="부서코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_nrunit" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_dutym" propid="value" datasetid="ds_send" columnid="sdutym"/>
      <BindItem id="item1" compid="grp_sea.ipt_edutym" propid="value" datasetid="ds_send" columnid="edutym"/>
      <BindItem id="item2" compid="grp_sea.cmb_unitcd" propid="value" datasetid="ds_init" columnid="unitcd"/>
      <BindItem id="item3" compid="cmb_instcd" propid="value" datasetid="ds_send" 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";
include "mis_dligclaznsmngtxp::RPD001.xjs";
function SMRPD12720_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD12720_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_nrlist);
	grdf_setRowTypeIcon(grd_nrlist, 0);
	
	var curdate = String(utlf_getCurrentDate());
	
	ds_send.setColumn(0, "sdutym", curdate.substr(0, 6));
	ds_send.setColumn(0, "edutym", curdate.substr(0, 6));
	ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	misfGetAndSetUserInfo();
	misfGetUserAuth();
	rpdfSetDutUnitCombo();
	
	var oParam = {};
		oParam.id          = "TRRPD12720";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetNrUnitcd";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_temp_nrunit=nrunit";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD12720";

	tranf_submit(oParam);

	if(grp_sea.cmb_unitcd.visible == true)
	{
		frmf_addComboItem("grp_sea.cmb_unitcd","전체","","above");
	}
	
	ds_init.setColumn(0, "unitcd", "2"+DUT_UNIT_CD);
	
	var vJobposcd = sysf_getUserInfo("jobposcd");
	
	if (vJobposcd == "62" || vJobposcd == "41" || vJobposcd == "41-1" || DUTY_PART_YN == "Y") 
	{
		grp_sea.cmb_unitcd.enable = true;
	} 
	else 
	{
		grp_sea.cmb_unitcd.enable = false;
	}
}

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

function grp_sea_ipt_edutym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "edutym", String(obj.value).substr(0,6));
}

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

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var vUnitcd = String(utlf_transNullToEmpty(ds_init.getColumn(0, "unitcd"))).substr(0,1);
	var vDeptcd = String(utlf_transNullToEmpty(ds_init.getColumn(0, "unitcd"))).substr(1,10);
	
	if (vUnitcd == "1") 
	{
		dsf_makeValue(ds_send, "unitcd", "string", vDeptcd, 0);
		dsf_makeValue(ds_send, "dutplcedeptcd", "string", "", 0);
	}
	else 
	{
		dsf_makeValue(ds_send, "unitcd", "string", "", 0);
		dsf_makeValue(ds_send, "dutplcedeptcd", "string", vDeptcd, 0);
	}
	
	var oParam = {};
		oParam.id          = "TRRPD12721";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetRornByDept";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_nrlist=nrlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD12721";

	tranf_submit(oParam);
}

function btn_saveexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_nrlist, "excel", "see", "true");
}
]]></Script>
  </Form>
</FDL>