YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD00700_부서별휴가사용현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD00700" position="absolute 0 0 1199 789" titletext="부서별휴가사용현황" oninit="SMRPD00700_oninit" onload="SMRPD00700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="부서별휴가사용현황" class="tit_1" position="absolute 0 0 150 25"/>
        <Shape id="line4" class="line_6" position="absolute 0 47 1195 53" anchor="left top right"/>
        <Button id="btn_print" taborder="1" text="출력" class="btn6" visible="false" position="absolute 0 26 56 48" onclick="btn_print_onclick"/>
        <Div id="grp_sea" taborder="2" position="absolute 0 51 1194 91" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Edit id="ipt_dutdeptcd" taborder="8" class="input_search" position="absolute 512 11 587 30" autoskip="true" autoselect="true" onkeyup="grp_sea_ipt_dutdeptcd_onkeyup"/>
              <Button id="btn_dutdept" taborder="9" class="icon_search" position="absolute 590 12 606 28" onclick="grp_sea_btn_dutdept_onclick"/>
              <Edit id="ipt_dutdeptnm" taborder="10" class="input_search" position="absolute 608 11 707 30" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_dutdeptnm_onkeyup"/>
              <Static id="caption5" text="소속기관 :" class="search_name" position="absolute 9 12 95 29"/>
              <Combo id="cmb_instcd" taborder="1" class="combo_search" enable="false" position="absolute 87 11 232 30"/>
              <Static id="caption1" text="기준년도 :" class="search_name" position="absolute 259 12 371 29"/>
              <Edit id="ipt_dutym" taborder="2" position="absolute 339 11 399 30" autoselect="true" autoskip="true" maxlength="4" style="align:center middle;"/>
              <Static id="caption2" text="소속부서 :" class="search_name" position="absolute 436 12 524 29"/>
              <Combo id="cmb_dutplce" taborder="3" class="combo_search" position="absolute 512 11 707 30" onitemchanged="grp_sea_cmb_dutplce_onitemchanged"/>
              <Combo id="combo1" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 714 11 814 30">
                <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>
              <Static id="caption3" text="급여분류 :" class="search_name" position="absolute 854 12 942 29"/>
              <Combo id="cmb_preststatcd" taborder="5" class="combo_search" visible="false" position="absolute 989 11 1079 30"/>
              <Combo id="cmb_prfshipflag" taborder="6" class="combo_search" position="absolute 931 11 1029 30"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1106 10 1112 32" anchor="top right"/>
              <Button id="btn_search" taborder="7" text="조회" class="btn1" position="absolute 1124 10 1180 32" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption4" text="상태 :" class="search_name" visible="false" position="absolute 854 12 912 29"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="button1" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 100 1195 119" anchor="top right" onclick="button1_onclick"/>
        <Static id="caption278" text="부서별휴가사용" class="tit_2" position="absolute 0 103 162 125"/>
        <Shape id="line207" class="line_10" position="absolute 0 119 1195 125" anchor="left top right"/>
        <Grid id="grd_dutsumlist" taborder="4" binddataset="ds_main_list_deptprvaliuselist" useinputpanel="false" position="absolute 0 124 1195 785" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="22" band="left"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="134"/>
                <Column size="76"/>
                <Column size="70"/>
                <Column size="58"/>
                <Column size="43"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="45"/>
                <Column size="0"/>
                <Column size="55"/>
                <Column size="50"/>
                <Column size="74"/>
                <Column size="76"/>
              </Columns>
              <Rows>
                <Row size="35" 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="1월"/>
                <Cell col="12" text="2월"/>
                <Cell col="13" text="3월"/>
                <Cell col="14" text="4월"/>
                <Cell col="15" text="5월"/>
                <Cell col="16" text="6월"/>
                <Cell col="17" text="7월"/>
                <Cell col="18" text="8월"/>
                <Cell col="19" text="9월"/>
                <Cell col="20" text="10월"/>
                <Cell col="21" text="11월"/>
                <Cell col="22" text="12월"/>
                <Cell col="23" text="년차&#10;사용계"/>
                <Cell col="24" text="보휴&#10;사용계"/>
                <Cell col="25" text="잔여일수"/>
                <Cell col="26" text="사용율"/>
                <Cell col="27" text="입사일자"/>
                <Cell col="28" text="퇴사일자"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:instcd"/>
                <Cell col="2" text="bind:instnm"/>
                <Cell col="3" text="bind:dutplcedeptcd"/>
                <Cell col="4" style="align:left;" text="bind:deptnm"/>
                <Cell col="5" text="bind:jobposnm"/>
                <Cell col="6" text="bind:emplno"/>
                <Cell col="7" text="bind:emplnm"/>
                <Cell col="8" style="align:right;" text="bind:yearno"/>
                <Cell col="9" text="bind:healholi"/>
                <Cell col="10" text="bind:genrsum"/>
                <Cell col="11" displaytype="number" text="bind:jan"/>
                <Cell col="12" displaytype="number" text="bind:feb"/>
                <Cell col="13" displaytype="number" text="bind:mar"/>
                <Cell col="14" displaytype="number" text="bind:apr"/>
                <Cell col="15" displaytype="number" text="bind:may"/>
                <Cell col="16" displaytype="number" text="bind:jun"/>
                <Cell col="17" displaytype="number" text="bind:jul"/>
                <Cell col="18" displaytype="number" text="bind:aug"/>
                <Cell col="19" displaytype="number" text="bind:sep"/>
                <Cell col="20" displaytype="number" text="bind:oct"/>
                <Cell col="21" displaytype="number" text="bind:nov"/>
                <Cell col="22" displaytype="number" text="bind:dec"/>
                <Cell col="23" displaytype="number" text="bind:usesum"/>
                <Cell col="24" displaytype="number" text="bind:usecaresum"/>
                <Cell col="25" displaytype="number" text="bind:spresum"/>
                <Cell col="26" displaytype="number" text="bind:userate" mask="###.#%"/>
                <Cell col="27" displaytype="date" text="bind:entcodd" maskchar=" " calendardisplaynulltype="none"/>
                <Cell col="28" displaytype="date" text="bind:retiredd" maskchar=" " calendardisplaynulltype="none"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparams" 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="dutyy" 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="prfshipflag" type="STRING" size="256"/>
          <Column id="preststatcd" type="STRING" size="256"/>
          <Column id="deptgb" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="dutyy"/>
            <Col id="dutunitcd"/>
            <Col id="dutunitnm"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="prfshipflag"/>
            <Col id="preststatcd"/>
            <Col id="deptgb"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_deptprvaliuselist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="instnm" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="dutplcedeptcd" type="STRING" size="256" sumtext="근무부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="jobposnm" type="STRING" size="256" sumtext="직위"/>
          <Column id="emplno" type="STRING" size="256" sumtext="사원번호"/>
          <Column id="emplnm" type="STRING" size="256" sumtext="성명"/>
          <Column id="yearno" type="DECIMAL" size="256" sumtext="년차"/>
          <Column id="healholi" type="DECIMAL" size="256" sumtext="보휴"/>
          <Column id="genrsum" type="DECIMAL" size="256" sumtext="발생계"/>
          <Column id="jan" type="DECIMAL" size="256" sumtext=" 1월"/>
          <Column id="feb" type="DECIMAL" size="256" sumtext=" 2월"/>
          <Column id="mar" type="DECIMAL" size="256" sumtext=" 3월"/>
          <Column id="apr" type="DECIMAL" size="256" sumtext=" 4월"/>
          <Column id="may" type="DECIMAL" size="256" sumtext=" 5월"/>
          <Column id="jun" type="DECIMAL" size="256" sumtext=" 6월"/>
          <Column id="jul" type="DECIMAL" size="256" sumtext=" 7월"/>
          <Column id="aug" type="DECIMAL" size="256" sumtext=" 8월"/>
          <Column id="sep" type="DECIMAL" size="256" sumtext=" 9월"/>
          <Column id="oct" type="DECIMAL" size="256" sumtext="10월"/>
          <Column id="nov" type="DECIMAL" size="256" sumtext="11월"/>
          <Column id="dec" type="DECIMAL" size="256" sumtext="12월"/>
          <Column id="usesum" type="STRING" size="256" sumtext="년차사용계"/>
          <Column id="usecaresum" type="STRING" size="256" sumtext="보휴사용계"/>
          <Column id="spresum" type="STRING" size="256" sumtext="잔여일수"/>
          <Column id="userate" type="DECIMAL" size="256" sumtext="사용율"/>
          <Column id="curdate" type="STRING" size="256" sumtext="사용율"/>
          <Column id="curtime" type="STRING" size="256" sumtext="사용율"/>
          <Column id="prntname" type="STRING" size="256" sumtext="사용율"/>
          <Column id="retiredd" type="STRING" size="256" sumtext="퇴직일자"/>
          <Column id="entcodd" type="STRING" size="256" sumtext="입사일자"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_dutym" propid="value" datasetid="ds_send_retrparams" columnid="dutyy"/>
      <BindItem id="item2" compid="grp_sea.ipt_dutdeptcd" propid="value" datasetid="ds_send_retrparams" columnid="dutunitcd"/>
      <BindItem id="item3" compid="grp_sea.ipt_dutdeptnm" propid="value" datasetid="ds_send_retrparams" columnid="dutunitnm"/>
      <BindItem id="item4" compid="grp_sea.cmb_dutplce" propid="value" datasetid="ds_send_retrparams" columnid="dutunitcd"/>
      <BindItem id="item5" compid="grp_sea.combo1" propid="value" datasetid="ds_send_retrparams" columnid="deptgb"/>
      <BindItem id="item6" compid="grp_sea.cmb_prfshipflag" propid="value" datasetid="ds_send_retrparams" columnid="prfshipflag"/>
      <BindItem id="item7" compid="grp_sea.cmb_preststatcd" propid="value" datasetid="ds_send_retrparams" columnid="preststatcd"/>
    </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";
function SMRPD00700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD00700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dutsumlist);
	fInitialize();
}

function fInitialize() 
{
	ds_main_list_deptprvaliuselist.clearData();
	//misfMsterDetailSet(grd_dutsumlist, null, "TRRPD00201", "Y");

	misfComboComCdListMulti("R0058,R0146","grp_sea.cmb_prfshipflag,grp_sea.cmb_preststatcd");
	
	ds_send_retrparams.setColumn(0, "dutyy", String(utlf_getCurrentDate()).substr(0, 4));
	misfComboInstCdListMulti("grp_sea.cmb_instcd",String(utlf_getCurrentDate()).substr(0, 8),"","Y");
	misfGetAndSetUserInfo();
	misfGetUserAuth();

	rpdfSetControlAuth();
	rpdfComboCdList(grp_sea.cmb_dutplce); 
	rpdfSetDutUnitCombo();

	ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparams.setColumn(0, "dutunitcd", DUT_UNIT_CD);
	ds_send_retrparams.setColumn(0, "dutunitnm", DUT_UNIT_NM);
	
	frmf_addComboItem("grp_sea.cmb_prfshipflag","전체","","above");
	frmf_addComboItem("grp_sea.cmb_preststatcd","전체","","above");
	
	ds_send_retrparams.setColumn(0, "deptgb", "1");
	
	if (utlf_isNull(grp_sea.cmb_dutplce.value))
	{
		grp_sea.cmb_dutplce.index = 0;
	}
	
	if(sysf_getUserInfo("dutplceinstcd") == "001" && DUTY_PART_YN == "Y") 
	{
		grp_sea.cmb_instcd.enable = true;
	}

	if(DUTY_PART_YN != "Y")
	{
		grp_sea.ipt_dutdeptcd.enable = false;
		grp_sea.ipt_dutdeptnm.enable = false;
		grp_sea.btn_dutdept.enable = false;
	}
}

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

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fRetrieve();
	fSet1YearNurse() ;
}

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" );
	}
}

function grp_sea_btn_dutdept_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", grp_sea.ipt_dutdeptcd,"","dutunitcd,dutunitnm", grp_sea.cmb_instcd.value + "," + grp_sea.ipt_dutym.value+"31", "instcd,basedd");
}

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" );
	}
}

function fRetrieve()
{
	if(utlf_isNull(ds_send_retrparams.getColumn(0, "dutunitcd")) && DUTY_PART_YN != "Y")
	{
		sysf_messageBox("근무부서를", "C001");
		return "dutunitval";
	}					
	
	var oParam = {};
		oParam.id          = "TRRPD00701";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetDeptPrValiUseList";
		oParam.inds        = "req=ds_send_retrparams";
		oParam.outds       = "ds_main_list_deptprvaliuselist=deptprvaliuselist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD00701";

	tranf_submit(oParam);
	
	if( utlf_isNull(ds_main_list_deptprvaliuselist.getColumnInfo("usecaresum")) ){
		ds_main_list_deptprvaliuselist.addColumn("usecaresum", "string");
	}
	
	var fNum = 0;
	
	for(var i = 0; i < ds_main_list_deptprvaliuselist.rowcount; i++) 
	{
		for(var j = grd_dutsumlist.getBindCellIndex("Body", "jan"); j < grd_dutsumlist.getBindCellIndex("Body", "userate"); j++)
		{
			var sColNm = utlf_transNullToEmpty(grd_dutsumlist.getCellProperty("body", j, "text")+"").replace("bind:", "");
			fNum = 0;
			fNum = parseFloat(ds_main_list_deptprvaliuselist.getColumn(i, sColNm));
			
			if(fNum == 0) 
			{
				ds_main_list_deptprvaliuselist.setColumn(i, sColNm, "0");
			}
			else 
			{
				if( (fNum % parseFloat(fNum)) == 0) 
				{
					ds_main_list_deptprvaliuselist.setColumn(i, sColNm, parseFloat(fNum));
				}
			}
		}
		
		if(ds_main_list_deptprvaliuselist.getColumn(i, "deptnm") == "     계") 
		{
			misfSetGridColor(grd_dutsumlist, "all", "#ffff99", "B" ,i);
		}
		else
		{
			misfSetGridColor(grd_dutsumlist, "all", "", "B" ,i);
		}
	}
}

function fSet1YearNurse()
{
	var sEntcoDD = "";
	var iEnterDayCnt = 0;
	var iCurntDayCnt = 0;
	
	for(var i = 0; i < ds_main_list_deptprvaliuselist.rowcount; i++) 
	{
		sEntcoDD     = ds_main_list_deptprvaliuselist.getColumn(i, "entcodd");
		iEnterDayCnt = parseFloat( Math.floor( Date.parse( misfConvertChar2Date(sEntcoDD, "/")) / 8.64e7));
		iCurntDayCnt = parseFloat( Math.floor( Date.parse( misfConvertChar2Date(utlf_getCurrentDate(), "/")) / 8.64e7));
		
		if(iCurntDayCnt - iEnterDayCnt <= 365) 
		{
// 			grd_dutsumlist.cellStyle("background-image",    i, grd_dutsumlist.colRef("emplnm")) = "../../../com/commonweb/images/input_s_essential.gif";
// 			grd_dutsumlist.cellStyle("background-position", i, grd_dutsumlist.colRef("emplnm")) = "center left";
		}
		else 
		{
//			grd_dutsumlist.rebuildStyle(i,grd_dutsumlist.colRef("emplnm"));
		}
	}
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_dutsumlist, "excel", "savetype", "true");
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	fPrint();
}

function fPrint() 
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/list/deptprvaliuselist", ds_main_list_deptprvaliuselist);
		
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;
				
	var option = "";	
	rptf_exeReportPreview30(["RPRPD00701"],[objParam], option, "");
}]]></Script>
  </Form>
</FDL>