YNU_JEUS/app_home/himed/xpapps/pam/patinfomngtxp/xp/SMPMC02301_감면내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPMC02301" position="absolute 0 0 1256 805" titletext="감면 내역 조회" onload="SMPMC02301_onload">
    <Layouts>
      <Layout>
        <Div id="Div00" taborder="7" position="absolute -1 23 1199 61" class="div_SA">
          <Layouts>
            <Layout width="1200" height="38"/>
          </Layouts>
        </Div>
        <Static text="감면 내역 조회" position="absolute 0 0 123 23" align="align:center middle;" id="cap_title" class="tit_1"/>
        <Static text="조회 결과" position="absolute 0 69 79 85" id="caption7" class="tit_2"/>
        <Shape position="absolute 0 86 1195 92" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;"/>
        <Static text="할인 적용 기간 :" position="absolute 5 33 127 50" id="caption35" class="search_name"/>
        <Button position="absolute 1128 31 1184 53" id="btn_search" class="btn1" taborder="6" text="조회" onclick="btn_search_onclick"/>
        <Shape position="absolute 1112 29 1118 54" linetype="vertical" id="line13"/>
        <Button position="absolute 1131 65 1195 84" id="btn_excel" class="btn2" text="엑셀저장" onclick="btn_excel_onclick"/>
        <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" band="left"/>
                <Column size="120"/>
                <Column size="70"/>
                <Column size="85"/>
                <Column size="80"/>
                <Column size="80"/>
                <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="최종수정일시"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow + 1"/>
                <Cell col="1" text="bind:emplno"/>
                <Cell col="2" text="bind:emplnm"/>
                <Cell col="3" text="bind:empkindnm"/>
                <Cell col="4" displaytype="date" text="bind:entcodd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="5" displaytype="date" text="bind:entcodd_mis" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="6" displaytype="date" text="bind:retiredd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="7" displaytype="date" text="bind:retiredd_mis" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="8" text="bind:disccd"/>
                <Cell col="9" style="align:center middle;" text="bind:discnm"/>
                <Cell col="10" text="bind:pid"/>
                <Cell col="11" text="bind:name"/>
                <Cell col="12" text="bind:famyrelnm"/>
                <Cell col="13" displaytype="date" text="bind:fromdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="14" displaytype="date" text="bind:todd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
                <Cell col="15" text="bind:fstrgstrnm"/>
                <Cell col="16" displaytype="date" text="bind:fstrgstdt" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
                <Cell col="17" text="bind:lastupdtrnm"/>
                <Cell col="18" displaytype="date" text="bind:lastupdtdt" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Calendar position="absolute 124 32 214 51" id="ipt_fromdd" class="input_search" dateformat="yyyy-MM-dd" value="null"/>
        <Calendar position="absolute 234 32 324 51" id="ipt_todd" class="input_search" dateformat="yyyy-MM-dd" value="null"/>
        <Static text="~" position="absolute 219 32 229 51" align="align:center middle;" id="caption1"/>
        <Static text="검증항목 :" position="absolute 360 33 450 50" id="caption2" class="search_name"/>
        <Combo position="absolute 455 32 635 51" id="cmb_errflag" class="combo_search" innerdataset="@ds_init_errlist_errinfo" datacolumn="nm" codecolumn="cd"/>
      </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="emplno" type="STRING"/>
          <Column id="emplnm" type="STRING"/>
          <Column id="empkindnm" type="STRING"/>
          <Column id="entcodd" type="STRING"/>
          <Column id="entcodd_mis" type="STRING"/>
          <Column id="retiredd" type="STRING"/>
          <Column id="retiredd_mis" 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_init_cmb_errflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_errlist_errinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cd">N</Col>
            <Col id="nm">인사 정보 없음</Col>
          </Row>
          <Row>
            <Col id="cd">R</Col>
            <Col id="nm">재직 기간 이외 감면</Col>
          </Row>
          <Row>
            <Col id="cd">A100</Col>
            <Col id="nm">A100 - 기타</Col>
          </Row>
          <Row>
            <Col id="cd">A200</Col>
            <Col id="nm">A200 - 본인, 배우자, 기타</Col>
          </Row>
          <Row>
            <Col id="cd">D</Col>
            <Col id="nm">가족 관계 중복</Col>
          </Row>
          <Row>
            <Col id="cd">B</Col>
            <Col id="nm">A200 - 아기, 애기</Col>
          </Row>
          <Row>
            <Col id="cd">E</Col>
            <Col id="nm">관계 항목 누락</Col>
          </Row>
        </Rows>
      </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="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="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="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="errflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="errflag"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="cmb_errflag" propid="value" datasetid="ds_send" columnid="errflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name      :   
 * Job Name         :   
 * Creator      :   
 * Make Date        :   2016-05-24
 * Description      :                                                                      
 *--------------------------------------------------------------------------------------- 
 * Modify Date      Modifier      Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";

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

    grd_fmly.setFormatColProperty("body", grd_fmly.getBindCellIndex("body", "entcodd_mis"), "size", "0");
    grd_fmly.setFormatColProperty("body", grd_fmly.getBindCellIndex("body", "retiredd_mis"), "size", "0");

    ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
    ds_send.setColumn(0, "todd", utlf_getCurrentDate());
}

function btn_search_onclick(obj: Button, e: ClickEventInfo) {
    if (utlf_transNullToEmpty(ds_send.getColumn(0, "errflag")) == "") {
        sysf_messageBox("검증항목이 선택되지 않았습니다.", "E999");
        return;
    }

    var oParam = {};
    oParam.id = "TRPMC02308";
    oParam.service = "patinfomngtapp.PatDiscInfo";
    oParam.method = "reqGetFmlyErrList";
    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");
}]]></Script>
  </Form>
</FDL>