YNU_JEUS/app_home/himed/xpapps/mis/yyendtaxadstxp/xp/SMRWY03600_연말정산의료비적용(개인조회).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRWY03600" position="absolute 0 0 1201 774" titletext="연말정산 의료비 적용" oninit="SMRWY03600_oninit" onload="SMRWY03600_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="연말정산 감면 내역 조회" class="tit_1" position="absolute 0 0 243 25"/>
        <Static id="cap_2014_2" text="12월 27일까지의 감면 내용입니다. 자료는 계속 업데이트 예정입니다." visible="false" position="absolute 601 98 1016 118" style="color:#ff00ffff;font:Dotum,9,bold;"/>
        <Static id="caption21" text="감면자 리스트" class="tit_2" position="absolute 0 101 174 124"/>
        <Shape id="line16" class="line_10" position="absolute 0 116 1194 125" anchor="left top right"/>
        <Grid id="grd_yyendtaxadsthealcare" taborder="1" binddataset="ds_main_yyendtaxadsthealcarelist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 122 1194 765" anchor="all" oncellclick="grd_yyendtaxadsthealcare_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="0"/>
                <Column size="120"/>
                <Column size="70"/>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="69"/>
                <Column size="80"/>
                <Column size="55"/>
                <Column size="110"/>
                <Column size="120"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="121"/>
                <Column size="60"/>
                <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"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:seqno" enable="false"/>
                <Cell col="2" displaytype="combo" edittype="combo" text="bind:instcd" enable="false"/>
                <Cell col="3" displaytype="combo" edittype="combo" text="bind:gubun" enable="false"/>
                <Cell col="4" displaytype="text" edittype="text" text="bind:deduyy" mask="####" maskchar=" " enable="false"/>
                <Cell col="5" displaytype="text" edittype="text" text="bind:emplno" enable="false"/>
                <Cell col="6" text="bind:emplnm" enable="false"/>
                <Cell col="7" displaytype="text" edittype="text" text="bind:fname" enable="false"/>
                <Cell col="8" displaytype="combo" edittype="combo" text="bind:relation" combodataset="ds_cmb_relation" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="9" displaytype="text" edittype="mask" style="align:center middle;" text="bind:famyrregno" mask="######-#######" maskchar=" " enable="false"/>
                <Cell col="10" text="bind:orddeptnm"/>
                <Cell col="11" displaytype="date" text="bind:orddd" calendardisplaynulltype="nulltext"/>
                <Cell col="12" displaytype="number" edittype="normal" text="bind:dcamt" enable="false"/>
                <Cell col="13" text="bind:cmt"/>
                <Cell col="14" displaytype="none" edittype="none" text="bind:magamyn" enable="false"/>
                <Cell col="15" displaytype="none" edittype="none" text="bind:guest" enable="false"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" class="btn7" position="absolute 1115 98 1195 117" anchor="top right" onclick="btn_excsave_onclick"/>
        <Button id="btn_excins" taborder="3" text="엑셀입력" class="btn7" visible="false" position="absolute 1034 98 1114 117" anchor="top right" onclick="btn_excins_onclick"/>
        <Button id="btn_delrow" taborder="4" text="행삭제" class="btn2" visible="false" position="absolute 900 97 953 116" onclick="btn_delrow_onclick"/>
        <Button id="btn_dutcdflag" taborder="5" text="행추가" class="btn2" visible="false" position="absolute 846 97 899 116" onclick="btn_dutcdflag_onclick"/>
        <Static id="caption3" text="총 감면금액 :" position="absolute 358 99 448 118" style="color:#ff0000ff;font:Dotum,9,bold;"/>
        <Static id="caption4" position="absolute 443 96 633 116" mask="#,###"/>
        <Static id="caption7" text="감면금액 확인후 꼭 확인 버튼을 눌러주세요." position="absolute 715 29 1050 49" style="color:#ff00ffff;font:Dotum,9,bold;"/>
        <Static id="cap_2014_1" text="2015년 1월 4일 15시부터 확인버튼이 활성화됩니다." visible="false" position="absolute 372 29 707 49" style="color:#ff00ffff;font:Dotum,9,bold;"/>
        <Shape id="line11" class="line_6" position="absolute 0 48 1194 54" anchor="left top right"/>
        <Button id="btn_save" taborder="6" text="저장" class="btn4" visible="false" position="absolute 715 29 771 51" onclick="btn_save_onclick"/>
        <Button id="btn_apply" taborder="7" text="적용" class="btn4" visible="false" position="absolute 659 29 715 51" onclick="btn_apply_onclick"/>
        <Button id="btn_admin" taborder="8" text="관리자" class="btn4" visible="false" position="absolute 1056 27 1124 49" anchor="top right" onclick="btn_admin_onclick"/>
        <Combo id="cmb_auth" taborder="9" visible="false" position="absolute 555 29 655 48"/>
        <Button id="btn_ok" taborder="10" text="확인" class="btn4" position="absolute 1125 27 1181 49" anchor="top right" onclick="btn_ok_onclick"/>
        <Div id="btn_madd" taborder="11" class="div_SA2" position="absolute 0 53 1195 93" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line12" linetype="vertical" class="line_4" position="absolute 1107 10 1113 32" anchor="top right"/>
              <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 1125 10 1181 32" anchor="top right" onclick="btn_madd_btn_search_onclick"/>
              <Static id="caption2" text="년도 :" class="search_name" position="absolute 18 11 79 28" anchor="default"/>
              <Calendar id="ipt_fromyyyy" taborder="6" position="absolute 80 10 145 29" mask="yyyy" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy" value="null" editformat="yyyy" onchanged="btn_madd_ipt_fromyyyy_onchanged"/>
              <Static id="caption1" text="사원번호 :" class="search_name" position="absolute 295 12 381 29" anchor="default"/>
              <Edit id="ipt_emplnm" taborder="7" class="input_search" enable="false" position="absolute 480 11 630 30" anchor="default"/>
              <Button id="btn_emplno" taborder="8" class="icon_search" enable="false" position="absolute 460 13 476 29" anchor="default" onclick="btn_madd_btn_emplno_onclick"/>
              <Edit id="ipt_emplno" taborder="9" class="input_search" enable="false" position="absolute 386 11 456 30" anchor="default" onkeydown="btn_madd_ipt_emplno_onkeydown"/>
              <Calendar id="ipt_toyyyy" taborder="10" visible="false" position="absolute 160 10 225 29" mask="yyyy" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy" editformat="yyyy" onchanged="btn_madd_ipt_toyyyy_onchanged"/>
              <Static id="caption5" text="~" visible="false" position="absolute 147 11 162 31" anchor="default"/>
              <CheckBox id="chk_tempyn" taborder="11" position="absolute 936 9 1106 29" anchor="default" text="감면자별 합산금액 보기" truevalue="Y" onclick="btn_madd_chk_tempyn_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_yyendtaxadsthealcarelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="toyyyy" type="STRING" size="256"/>
          <Column id="sumyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="yyyy"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="toyyyy"/>
            <Col id="sumyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_relation" 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">1</Col>
          </Row>
          <Row>
            <Col id="label">가족</Col>
            <Col id="value">2</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="btn_madd.ipt_fromyyyy" propid="value" datasetid="ds_send_search" columnid="yyyy"/>
      <BindItem id="item1" compid="btn_madd.ipt_toyyyy" propid="value" datasetid="ds_send_search" columnid="toyyyy"/>
      <BindItem id="item2" compid="btn_madd.ipt_emplno" propid="value" datasetid="ds_send_search" columnid="emplno"/>
      <BindItem id="item3" compid="btn_madd.ipt_emplnm" propid="value" datasetid="ds_send_search" columnid="emplnm"/>
      <BindItem id="item4" compid="btn_madd.chk_tempyn" propid="value" datasetid="ds_send_search" columnid="sumyn"/>
    </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";
function SMRWY03600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRWY03600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_yyendtaxadsthealcare);
	grdf_setRowTypeIcon(grd_yyendtaxadsthealcare, 0);
	
	misfGridInit(grd_yyendtaxadsthealcare);
	
	//misfMsterDetailSet(grd_yyendtaxadsthealcare,null, "TRRWY03301" ,"Y","free");
	misfComboComCdListMulti("Z0007,R1550,R9991","grd_yyendtaxadsthealcare.instcd,grd_yyendtaxadsthealcare.gubun,cmb_auth");
	
	var yyyy = utlf_getCurrentDate().toString().substr(0,4) - 1;
	
	if (utlf_getCurrentDate().toString().substr(4, 2) == "12") 
	{
		yyyy = utlf_getCurrentDate().toString().substr(0,4);	
	}
	
	ds_send_search.setColumn(0, "yyyy", yyyy);
	ds_send_search.setColumn(0, "toyyyy", yyyy);
	
	cmb_auth.value = sysf_getUserInfo("userid");
	
	ds_send_search.setColumn(0, "emplno", sysf_getUserInfo("userid"));
	ds_send_search.setColumn(0, "emplnm", sysf_getUserInfo("usernm"));
	
	misfGetUserAuth();
	
	if(cmb_auth.text == "1")
	{
		btn_admin.visible = true;
		btn_madd.ipt_emplno.enable = true;
		btn_madd.ipt_emplnm.enable = true;
		btn_madd.btn_emplno.enable = true;
	}
	else
	{
		btn_madd.ipt_emplno.enable = false;
		btn_madd.ipt_emplnm.enable = false;
		btn_madd.btn_emplno.enable = false;
	}
	
	btn_madd.btn_search.click();
	
	var curdate = utlf_getCurrentDate();
	var curtime = utlf_getCurrentTime().toString().substr(0, 2);
	var curdatetime = curdate + curtime;
	
	if (curdatetime >= "2016010416")
	{
		cap_2014_1.visible = false;
		cap_2014_2.visible = false;
	} 
	else 
	{
		cap_2014_1.visible = true;
		cap_2014_2.visible = true;
	}
	
	var instcd = sysf_getUserInfo("dutplceinstcd");
	
	if (instcd == "033") 
	{
		if (curdatetime >= "2017010215" && curdatetime <= "2017010700")
		{
			btn_ok.enable = true;
		} 
		else 
		{
			btn_ok.enable = false;
		}
	}
	else 
	{
		if (curdatetime >= "2017010215" && curdatetime <= "2017010500")
		{
			btn_ok.enable = true;
		} 
		else 
		{
			btn_ok.enable = false;
		}
	}
}

function btn_madd_ipt_fromyyyy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = String(obj.value).substr(0,4);
	ds_send_search.setColumn(0, "yyyy", date);
	ds_send_search.setColumn(0, "toyyyy", date);
	
	btn_madd.btn_search.click();
}

function btn_madd_ipt_toyyyy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = String(obj.value).substr(0,4);
	ds_send_search.setColumn(0, "toyyyy", date);
	btn_madd.btn_search.click();
}

function btn_madd_ipt_emplno_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		rpbfValidationCheck("EMPLNO", "emplno,emplnm");
		
		if(!utlf_isNull(btn_madd.ipt_emplnm.value))
		{
			btn_madd.btn_search.click();
		}
	}
}

function btn_madd_btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	rpbfOpenPopUpList("SPRPB00101", ds_send_search, "emplno,emplnm", "", "N");									
	
	if(!utlf_isNull(btn_madd.ipt_emplnm.value))
	{
		btn_madd.btn_search.click();
	}
}

function btn_madd_chk_tempyn_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if(obj.value == "Y")
	{}
	else
	{
		ds_send_search.setColumn(0, "sumyn", "");
	}
}

function btn_madd_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(btn_madd.ipt_fromyyyy.value))
	{
		sysf_messageBox("년도가 없습니다. 확인해 주세요", "E999", "");
		btn_madd.ipt_fromyyyy.setFocus();
		return;
	}
	misfGridInit(grd_yyendtaxadsthealcare);
	
	var oParam = {};
		oParam.id          = "TRRWY03301";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstBaseDataRgst";
		oParam.method      = "reqGetYYEndTaxAdstHealCareList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_yyendtaxadsthealcarelist=yyendtaxadsthealcarelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRWY03301";

	tranf_submit(oParam);
	
	var fsum = 0 ;
	
	for(var i = 0; i < ds_main_yyendtaxadsthealcarelist.rowcount; i++)
	{
		var dcamt = ds_main_yyendtaxadsthealcarelist.getColumn(i, "dcamt");
		fsum += parseInt(dcamt)
	}
	caption4.text = fsum;
}

function btn_apply_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(btn_madd.ipt_fromyyyy.value))
	{
		sysf_messageBox("년도가 없습니다. 확인해 주세요", "E999", "");
		btn_madd.ipt_fromyyyy.setFocus();
		return;
	}
	var oParam = {};
		oParam.id          = "TRRWY03302";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstBaseDataRgst";
		oParam.method      = "reqGetYYEndTaxAdstHealCareApply";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRWY03302";

	tranf_submit(oParam);
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var chk = 0;
	if(ds_main_yyendtaxadsthealcarelist.rowcount == 0)
	{
		return;
	}
	
	for(var i = 0; i < ds_main_yyendtaxadsthealcarelist.rowcount; i++)
	{
		if(ds_main_yyendtaxadsthealcarelist.getRowType(i) != 1)
		{
			chk++;
		}
		
		var magamyn = ds_main_yyendtaxadsthealcarelist.getColumn(i, "magamyn");
		
		if(magamyn == "Y")
		{
			sysf_messageBox("마감된 자료는 저장이 불가능합니다.", "E999", "");
			return;
		}
	}
	
	if(chk == "0")
	{
		sysf_messageBox("변경된 자료가 없습니다.", "E999", "");
		return;
	}
	
	var oParam = {};
		oParam.id          = "TXRWY03301";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstBaseDataRgst";
		oParam.method      = "reqExeYYEndTaxAdstHealCareList";
		oParam.inds        = "yyendtaxadsthealcarelist=ds_main_yyendtaxadsthealcarelist:u";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRWY03301";

	tranf_submit(oParam);

	btn_madd.btn_search.click();
}

function btn_admin_onclick(obj:Button,  e:ClickEventInfo)
{
	frmf_modal("SMRWY03700", "SMRWY03700", "", "", "", "", "", "", "", "", "", "", "M");	
}

function btn_ok_onclick(obj:Button,  e:ClickEventInfo)
{
	for(var i = 0 ; i < ds_main_yyendtaxadsthealcarelist.rowcount; i++)
	{
		ds_main_yyendtaxadsthealcarelist.setColumn(i, "magamyn", "Y");
		ds_main_yyendtaxadsthealcarelist.setColumn(i, "guest", "Y");
	}
	
	var oParam = {};
		oParam.id          = "TXRWY03301";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstBaseDataRgst";
		oParam.method      = "reqExeYYEndTaxAdstHealCareList";
		oParam.inds        = "yyendtaxadsthealcarelist=ds_main_yyendtaxadsthealcarelist:u";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRWY03301";

	tranf_submit(oParam);

	btn_madd.btn_search.click();
}

function btn_dutcdflag_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_yyendtaxadsthealcare,"A");
}

function btn_delrow_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_yyendtaxadsthealcare, "D");
}

function btn_excins_onclick(obj:Button,  e:ClickEventInfo)
{
	var req = sysf_messageBox("자료를 다 비우고 입력하시겠습니까?.", "Q003");
	if( req == 6 )
	{
		misfGridInit(grd_yyendtaxadsthealcare);
	}
	
	grdf_ImportExcel("ds_main_yyendtaxadsthealcarelist", 2, grd_yyendtaxadsthealcare);
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_yyendtaxadsthealcare);
}

function grd_yyendtaxadsthealcare_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRWY03301";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstBaseDataRgst";
		oParam.method      = "reqGetYYEndTaxAdstHealCareList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_yyendtaxadsthealcarelist=yyendtaxadsthealcarelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRWY03301";

	tranf_submit(oParam);
}
]]></Script>
  </Form>
</FDL>