YNU_JEUS/app_home/himed/xpapps/pam/patinfomngtxp/xp/SMPMC02302_감면이력조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPMC02302" position="absolute 0 0 1256 805" titletext="감면 이력 조회" onload="SMPMC02302_onload">
    <Layouts>
      <Layout>
        <Div id="Div00" taborder="7" position="absolute 0 22 1199 60" class="div_SA"/>
        <Static text="감면 이력 조회" position="absolute 0 0 125 23" align="align:center middle;" id="cap_title" class="tit_1"/>
        <Static text="등록번호 :" position="absolute 10 33 101 50" id="caption1" class="search_name"/>
        <Edit position="absolute 102 32 172 51" id="ipt_pid" class="input_search" onkeyup="ipt_pid_onkeyup"/>
        <Static text="사번 :" position="absolute 205 33 267 50" id="caption35" class="search_name"/>
        <Edit position="absolute 272 32 332 51" id="ipt_emplno" class="input_search" onkeyup="ipt_emplno_onkeyup"/>
        <Static text="이력발생일 :" position="absolute 370 33 469 50" id="caption2" class="search_name"/>
        <Calendar position="absolute 475 32 565 51" id="ipt_logdd" class="input_search" dateformat="yyyy-MM-dd" value="null" style="background:URL('theme://images/bg_edit_R.png') stretch 5,5;" enable="false"/>
        <CheckBox position="absolute 570 34 620 49" id="chk_logddflag" onchanged="chk_logddflag_onchanged" text="적용" falsevalue="N" truevalue="Y"/>
        <Shape position="absolute 1112 30 1118 55" linetype="vertical" id="line13"/>
        <Button position="absolute 1128 30 1184 52" id="btn_search" class="btn1" taborder="6" text="조회" onclick="btn_search_onclick"/>
        <Static text="조회 결과" position="absolute 0 68 79 84" id="caption7" class="tit_2"/>
        <Shape position="absolute 0 86 1195 92" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;"/>
        <Grid position="absolute 0 90 1195 760" align="align:center middle;" id="grd_fmly" binddataset="ds_main_fmlylist_fmlyinfo">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="40"/>
                <Column size="120"/>
                <Column size="60"/>
                <Column size="70"/>
                <Column size="120"/>
                <Column size="70"/>
                <Column size="85"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="60"/>
                <Column size="200"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="120"/>
                <Column size="70"/>
                <Column size="120"/>
              </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="할인종료일"/>
                <Cell col="17" text="최초등록자"/>
                <Cell col="18" text="최초등록일시"/>
                <Cell col="19" text="최종수정자"/>
                <Cell col="20" text="최종수정일시"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow + 1"/>
                <Cell col="1" text="bind:instnm"/>
                <Cell col="2" displaytype="date" text="bind:logdt" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
                <Cell col="3" text="bind:logact"/>
                <Cell col="4" text="bind:logusernm"/>
                <Cell col="5" text="bind:emplno"/>
                <Cell col="6" text="bind:emplnm"/>
                <Cell col="7" text="bind:empkindnm"/>
                <Cell col="8" displaytype="date" text="bind:entcodd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="9" displaytype="date" text="bind:retiredd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="10" text="bind:disccd"/>
                <Cell col="11" style="align:center middle;" text="bind:discnm"/>
                <Cell col="12" text="bind:pid"/>
                <Cell col="13" text="bind:name"/>
                <Cell col="14" text="bind:famyrelnm"/>
                <Cell col="15" displaytype="date" text="bind:fromdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="16" displaytype="date" text="bind:todd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="17" text="bind:fstrgstrnm"/>
                <Cell col="18" displaytype="date" text="bind:fstrgstdt" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
                <Cell col="19" text="bind:lastupdtrnm"/>
                <Cell col="20" displaytype="date" text="bind:lastupdtdt" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button position="absolute 1131 65 1195 84" id="btn_excel" class="btn2" text="엑셀저장" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_fmly" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instnm" type="STRING"/>
          <Column id="logdt" type="STRING"/>
          <Column id="logact" type="STRING"/>
          <Column id="logusernm" type="STRING"/>
          <Column id="emplno" type="STRING"/>
          <Column id="emplnm" type="STRING"/>
          <Column id="empkindnm" type="STRING"/>
          <Column id="entcodd" type="STRING"/>
          <Column id="retiredd" type="STRING"/>
          <Column id="disccd" type="STRING"/>
          <Column id="discnm" type="STRING"/>
          <Column id="pid" type="STRING"/>
          <Column id="name" type="STRING"/>
          <Column id="famyrelnm" type="STRING"/>
          <Column id="fromdd" type="STRING"/>
          <Column id="todd" type="STRING"/>
          <Column id="fstrgstrnm" type="STRING"/>
          <Column id="fstrgstdt" type="STRING"/>
          <Column id="lastupdtrnm" type="STRING"/>
          <Column id="lastupdtdt" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_fmlylist_fmlyinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="logdt" type="STRING" size="256"/>
          <Column id="logact" type="STRING" size="256"/>
          <Column id="loguserid" type="STRING" size="256"/>
          <Column id="logusernm" type="STRING" size="256"/>
          <Column id="logip" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="empkindcd" type="STRING" size="256"/>
          <Column id="empkindnm" type="STRING" size="256"/>
          <Column id="entcodd" type="STRING" size="256"/>
          <Column id="entcodd_mis" type="STRING" size="256"/>
          <Column id="retiredd" type="STRING" size="256"/>
          <Column id="retiredd_mis" type="STRING" size="256"/>
          <Column id="disccd" type="STRING" size="256"/>
          <Column id="discnm" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="famyrelcd" type="STRING" size="256"/>
          <Column id="famyrelnm" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="fstrgstrnm" type="STRING" size="256"/>
          <Column id="fstrgstdt" type="STRING" size="256"/>
          <Column id="lastupdtrnm" type="STRING" size="256"/>
          <Column id="lastupdtdt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instnm"/>
            <Col id="logdt"/>
            <Col id="logact"/>
            <Col id="loguserid"/>
            <Col id="logusernm"/>
            <Col id="logip"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="empkindcd"/>
            <Col id="empkindnm"/>
            <Col id="entcodd"/>
            <Col id="entcodd_mis"/>
            <Col id="retiredd"/>
            <Col id="retiredd_mis"/>
            <Col id="disccd"/>
            <Col id="discnm"/>
            <Col id="pid"/>
            <Col id="name"/>
            <Col id="famyrelcd"/>
            <Col id="famyrelnm"/>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="fstrgstrnm"/>
            <Col id="fstrgstdt"/>
            <Col id="lastupdtrnm"/>
            <Col id="lastupdtdt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="userid" type="STRING" size="256"/>
          <Column id="logdd" type="STRING" size="256"/>
          <Column id="logddflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="pid"/>
            <Col id="userid"/>
            <Col id="logdd"/>
            <Col id="logddflag"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_pid" propid="value" datasetid="ds_send" columnid="pid"/>
      <BindItem id="item1" compid="ipt_emplno" propid="value" datasetid="ds_send" columnid="userid"/>
      <BindItem id="item2" compid="ipt_logdd" propid="value" datasetid="ds_send" columnid="logdd"/>
      <BindItem id="item3" compid="chk_logddflag" propid="value" datasetid="ds_send" columnid="logddflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name      :   
 * Job Name         :   
 * Creator      :   
 * Make Date        :   2016-10-07
 * Description      :                                                                      
 *--------------------------------------------------------------------------------------- 
 * Modify Date      Modifier      Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-10-07      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";

function SMPMC02302_onload(obj: Form, e: LoadEventInfo) {
    frmf_initForm(obj); // 폼 초기화 

    ds_send.setColumn(0, "logdd", utlf_getCurrentDate());

    ipt_logdd.enable = false;
}

function btn_search_onclick(obj: Button, e: ClickEventInfo) {
    if (utlf_transNullToEmpty(ds_send.getColumn(0, "pid")) == "" &&
        utlf_transNullToEmpty(ds_send.getColumn(0, "emplno")) == "" &&
        ds_send.getColumn(0, "logddflag") != "Y") {
        sysf_messageBox("적어도 1개 이상의 조건을 입력해야 합니다.", "E999");
        return;
    }

    var oParam = {};
    oParam.id = "TRPMC02309";
    oParam.service = "patinfomngtapp.PatDiscInfo";
    oParam.method = "reqGetFmlyLog";
    oParam.inds = "req=ds_send";
    oParam.outds = "ds_main_fmlylist_fmlyinfo=fmly";
    oParam.async = false;

    tranf_submit(oParam);
}

function btn_excel_onclick(obj: Button, e: ClickEventInfo) {
    grdf_exportExcel(grd_fmly, "감면이력조회", "Sheet1", true, "", 'user', true);

    sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
}

function ipt_pid_onkeyup(obj: Edit, e: KeyEventInfo) {
    if (e.keycode == 13) {
        obj.updateToDataset();
        btn_search.click();
    }
}

function ipt_emplno_onkeyup(obj: Edit, e: KeyEventInfo) {
    if (e.keycode == 13) {
        obj.updateToDataset();
        btn_search.click();
    }
}

function chk_logddflag_onchanged(obj: CheckBox, e: CheckBoxChangeEventInfo) {
    ipt_logdd.disabled = !(ds_send.getColumn(0, "logddflag") == "Y");
}]]></Script>
  </Form>
</FDL>