YNU_JEUS/app_home/himed/xpapps/mis/paybnusmngtxp/xp/SMRWP22100_가족수당신청내역확인.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRWP22100" position="absolute 0 0 1197 793" titletext="가족수당 지급 대상 현황 확인" onload="SMRWP22100_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" align="align:center top;" id="btn_madd" class="div_SA" anchor="left top right" taborder="2">
          <Layouts>
            <Layout/>
          </Layouts>
        </Div>
        <Static id="caption6" text="가족수당 지급 대상자 현황" class="tit_1" position="absolute 0 0 243 25"/>
        <Shape id="line12" linetype="vertical" class="line_4" position="absolute 967 35 973 57" anchor="top right"/>
        <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 979 35 1035 57" onclick="btn_search_onclick" anchor="top right"/>
        <Static id="caption1" text="사원번호 :" class="search_name" position="absolute 15 38 101 55"/>
        <Edit id="ipt_emplnm" taborder="1" class="input_search" enable="false" position="absolute 200 36 350 55"/>
        <Button id="btn_emplno" taborder="4" class="icon_search" enable="false" position="absolute 180 38 196 54" onclick="btn_emplno_onclick"/>
        <Edit id="ipt_emplno" taborder="0" class="input_search" enable="false" position="absolute 106 36 176 55" onkeydown="ipt_emplno_onkeydown"/>
        <Button id="button1" taborder="5" text="저장" class="btn4" position="absolute 1037 35 1093 57" onclick="button1_onclick" anchor="top right"/>
        <Button id="button2" taborder="6" text="확인 HELP" class="btn4" position="absolute 1095 35 1187 57" onclick="button2_onclick" anchor="top right"/>
        <Static id="caption21" text="가족수당 신청 리스트" class="tit_2" position="absolute 0 76 174 97"/>
        <Shape id="line16" class="line_10" position="absolute 0 92 1195 98" anchor="left top right"/>
        <Grid id="grd_famylist" taborder="7" binddataset="ds_main_famyinfo_famylist" useinputpanel="false" position="absolute 0 97 1195 562" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="63"/>
                <Column size="110"/>
                <Column size="60"/>
                <Column size="70"/>
                <Column size="90"/>
                <Column size="80"/>
                <Column size="0"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="60"/>
                <Column size="120"/>
                <Column size="95"/>
                <Column size="120"/>
                <Column size="60"/>
              </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="비고"/>
                <Cell col="16" text="확인여부"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:instcd"/>
                <Cell col="2" text="bind:deptnm"/>
                <Cell col="3" text="bind:emplno"/>
                <Cell col="4" text="bind:name"/>
                <Cell col="5" text="bind:jobkindnm"/>
                <Cell col="6" text="bind:jobgradnm"/>
                <Cell col="7" text="bind:relation"/>
                <Cell col="8" text="bind:relationnm"/>
                <Cell col="9" text="bind:relname"/>
                <Cell col="10" text="bind:rregno"/>
                <Cell col="11" text="bind:rregnoall"/>
                <Cell col="12" displaytype="checkbox" edittype="checkbox" text="bind:nopayflag" expr="expr:(nopayflag==&quot;Y&quot;||nopayflag==1)?1:0"/>
                <Cell col="13" displaytype="combo" edittype="combo" text="bind:nopayresn" combodataset="ds_cmb_nopayresn" combocodecol="value" combodatacol="label"/>
                <Cell col="14" displaytype="date" edittype="date" style="padding:0 0 0 0;" text="bind:nopaydate" calendardisplay="display"/>
                <Cell col="15" displaytype="text" edittype="text" text="bind:cmt"/>
                <Cell col="16" displaytype="checkbox" edittype="checkbox" text="bind:magamflag" expr="expr:(magamflag==&quot;Y&quot;||magamflag==1)?1:0"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excsave" taborder="8" text="엑셀저장" class="btn7" position="absolute 1115 70 1195 92" onclick="btn_excsave_onclick" anchor="top right"/>
        <ImageViewer id="img1" taborder="9" image="URL('IMG::mis/famycheck1.png')" position="absolute 0 564 726 789" anchor="left bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_cmbauth" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cmbauth" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep" oncolumnchanged="ds_send_search_oncolumnchanged">
        <ColumnInfo>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="emplno"/>
            <Col id="emplnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="saveinfo" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_famyinfo_famylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep" oncolumnchanged="ds_main_famyinfo_famylist_oncolumnchanged">
        
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="temp" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="temp"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="init"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_nopayresn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">세대분가</Col>
            <Col id="value">01</Col>
          </Row>
          <Row>
            <Col id="label">연령도달</Col>
            <Col id="value">02</Col>
          </Row>
          <Row>
            <Col id="label">이혼</Col>
            <Col id="value">03</Col>
          </Row>
          <Row>
            <Col id="label">사망</Col>
            <Col id="value">04</Col>
          </Row>
          <Row>
            <Col id="label">기타</Col>
            <Col id="value">99</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_emplnm" propid="value" datasetid="ds_send_search" columnid="emplnm"/>
      <BindItem id="item1" compid="ipt_emplno" propid="value" datasetid="ds_send_search" columnid="emplno"/>
    </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                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RSZ001.xjs";
include "mis_humtrafactmngtxp::RPB001.xjs";
//include "mis_purcbasexp::SMRFE00200.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: N/A
 * Description		: 초기화
 ****************************************************************************************/
 
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMRWP22100_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  		// 폼 초기화 
	
	grdf_setRowTypeIcon(grd_famylist, 0); // 그리드 상태 표시

	sysf_messageBox("★ [확인여부] 체크 후 저장 필수 ★", "I999");

	misfGetUserAuth();

	if(DUTY_WELF_YN == "Y"){
		ipt_emplno.enable = true;
		ipt_emplnm.enable = true;
		btn_emplno.enable = true;
	} else {
		ipt_emplno.enable = false;
		ipt_emplnm.enable = false;
		btn_emplno.enable = false;
	}

	ds_send_search.setColumn( 0, "emplno", sysf_getUserInfo("userid"));
	ds_send_search.setColumn( 0, "emplnm", sysf_getUserInfo("usernm"));
}

/****************************************************************************************
 * Components		: Edit
 * Description		: 사원번호 입력 검색
 ****************************************************************************************/
function ipt_emplno_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		if(ds_send_search.getColumn(0,"emplno") == obj.text) return;		
		obj.updateToDataset();
	}
}

/****************************************************************************************
 * Components		: Dataset
 * Description		: 사원번호 입력 검색
 ****************************************************************************************/
function ds_send_search_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "emplno") {
		ipt_emplno.value = e.newvalue;
		ipt_emplno.enable = true;
		ipt_emplno.setFocus();
		rpbfValidationCheck("EMPLNO", "emplno,emplnm");
		ipt_emplno.enable = false;
		if(!utlf_isNull(ds_send_search.getColumn(0,"emplnm"))) btn_search.click();
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 사원번호 검색 팝업
 ****************************************************************************************/
function btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	rpbfOpenPopUpList("SPRPB00101", ipt_emplno, "emplno,emplnm", "", "N");

	if(!utlf_isNull(ds_send.getColumn(0,"emplnm"))) btn_search.click();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRWP22101";
		oParam.service     = "paybnusmngtapp.PayCalcMngt";
		oParam.method      = "reqGetFamyInfoList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_famyinfo_famylist=famylist";
		oParam.async       = true;
		//oParam.callback    = "cf_TRRWP22101";

	tranf_submit(oParam);
}

/****************************************************************************************
 * Components		: Button
 * Description		: 저장
 ****************************************************************************************/
function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	for (var i = 0 ; i < ds_main_famyinfo_famylist.rowcount ; i++) {
		if (ds_main_famyinfo_famylist.getColumn(i, "nopayflag") == "Y" && dsf_getColumnNullToEmpty(ds_main_famyinfo_famylist, i, "nopayresn") == "") {
			sysf_messageBox(i + "번째 행의 지급제외 사유가 입력되지 않았습니다", "E999");
			return;
		}
	}
	
	dsf_createDs("ds_send_saveinfo");
	var dsUpdate = grdf_getGridUpdateData(grd_famylist, "all");
	grdf_setStatusColumn(dsUpdate, "status");
	ds_send_saveinfo.copyData(dsUpdate, true);
	var oParam = {};
		oParam.id          = "TXRWP22101";
		oParam.service     = "paybnusmngtapp.PayCalcMngt";
		oParam.method      = "reqSetFamyInfoList";
		oParam.inds        = "saveinfo=ds_send_saveinfo";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRWP22101";

	tranf_submit(oParam);

	btn_search.click();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 사원번호 검색 팝업
 ****************************************************************************************/
function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var filepath = "mis/rpv/req//20160212/20160212162154785000_99207";
	
	dsf_createDsRow("ds_req", 	[
                                {col:"filepath", type:"STRING", size:256, val:filepath}
                                ]);
	var oParam = {};
		oParam.id          = "TRRWC03003";
		oParam.service     = "paybaseinfomngtapp.PayBaseInfoMngt";
		oParam.method      = "reqGetManualAtt";
		oParam.inds        = "req=ds_req";
		oParam.outds       = "ds_file_attachfile=attachfile";
		oParam.async       = false;
		oParam.callback    = "cf_TRRWC03003";

	tranf_submit(oParam);
}

function cf_TRRWC03003(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
	
	var filenm 	 = "★가족수당 개별 지급현황 확인 및 정정방법.ppt";
	var fd  	 = new FileDialog;
	var objVFile = fd.open("FileSave", FileDialog.SAVE, "%MYDOCUMENT%", filenm);  // 단일 파일 선택
	if (objVFile != null)
	{
		var temp = dsf_readFileFromDs(objVFile.fullpath, ds_file_attachfile, 0, "filedata"); // 파일저장
		sleep(1000);
		if( !utlf_isNull(temp) )
		{
			var rtn = sysf_messageBox("파일을", "Q004");
			if( rtn == 6  )
			{
				var text = new String(objVFile.fullpath);
				var replaceText = text.replace(" ", "");
				if( text.length != replaceText.length )
				{
					sysf_messageBox("공백이 포함된 [파일명/폴더]는 자동열기가 실행되지 않습니다.", "E999", "");
					return;
				}
				else
				{
//					system.execShell(objVFile.fullpath);
					var path = objVFile.fullpath;
					var sArg = "";
					var objExtCommon = new ExtCommon();
					objExtCommon.executeProcess(path, sArg);
				}
			}
		}
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_famylist);
}

/****************************************************************************************
 * Components		: Dataset
 * Description		: 체크박스 설정
 ****************************************************************************************/
function ds_main_famyinfo_famylist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid=="nopayflag" || e.columnid=="magamflag") {
		obj.setColumn(e.row,e.columnid,(e.newvalue=="Y"||e.newvalue==1)?"Y":"N");
	}
}
]]></Script>
  </Form>
</FDL>