YNU_JEUS/app_home/himed/xpapps/sts/stspamxp/xp/SPSTP02400_외국인예수금통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPSTP02400" position="absolute 0 0 1196 750" titletext="외국인예수금 조" onload="SPSTP02400_onload">
    <Layouts>
      <Layout>
        <Button position="absolute 1093 67 1143 89" id="btn_print1" class="btn6" taborder="26" visible="false" text="출력" onclick="btn_print1_onclick" anchor="top right"/>
        <Button position="absolute 1145 67 1195 89" id="btn_excel" class="btn7" taborder="30" text="엑셀" anchor="top right" onclick="btn_excel_onclick"/>
        <Static text="외국인예수금 조회" position="absolute 0 0 160 25" align="align:center middle;" id="caption60" class="tit_1"/>
        <Static text="수익 내역" position="absolute 0 73 90 89" id="caption1" class="tit_2"/>
        <Shape position="absolute 0 90 1195 94" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
        <Grid position="absolute 0 94 1195 749" id="grd_holdlist" binddataset="ds_main_holdlist" oncelldblclick="grd_ordearn_oncelldblclick" cellsizingtype="both" cellsizebandtype="allband" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="150"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="기관"/>
                <Cell col="2" text="수익일자"/>
                <Cell col="3" text="등록번호"/>
                <Cell col="4" text="성명"/>
                <Cell col="5"/>
                <Cell col="6" text="진료과"/>
                <Cell col="7" text="보조유형"/>
                <Cell col="8" text="입원/외래 구분"/>
                <Cell col="9" text="예수금"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" displaytype="combo" text="bind:instcd" combodataset="ds_cmb_instcd" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="2" displaytype="date" text="bind:earnenddd"/>
                <Cell col="3" text="bind:pid"/>
                <Cell col="4" displaytype="text" text="bind:hngnm" treestartlevel="1"/>
                <Cell col="5"/>
                <Cell col="6" displaytype="text" text="bind:deptname"/>
                <Cell col="7" displaytype="text" text="bind:suppkindnm"/>
                <Cell col="8" displaytype="combo" text="bind:brateflag" combodataset="ds_cmb_brateflag" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="9" displaytype="number" text="bind:payamt"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" style="font:Dotum,9,bold;" text="합계"/>
                <Cell col="2"/>
                <Cell col="3"/>
                <Cell col="4"/>
                <Cell col="5"/>
                <Cell col="6"/>
                <Cell col="7"/>
                <Cell col="8"/>
                <Cell col="9" displaytype="number" style="font:Dotum,9,bold;" text="expr:getSum('payamt')"/>
              </Band>
            </Format>
            <Format id="default2">
              <Columns>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="lvl"/>
                <Cell col="1" text="cdid"/>
                <Cell col="2" text="gubunnm"/>
                <Cell col="3" rowspan="2" text="계정명" taborder="undefined"/>
                <Cell col="4" text="deptcd"/>
                <Cell col="5" text="deptnm"/>
                <Cell col="6" colspan="3" text="본인부담금" taborder="undefined"/>
                <Cell col="9" colspan="3" text="공단부담금" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="계정합계" taborder="undefined"/>
                <Cell row="1" text="lvl"/>
                <Cell row="1" col="1" text="cdid"/>
                <Cell row="1" col="2" text="gubunnm"/>
                <Cell row="1" col="4" text="deptcd"/>
                <Cell row="1" col="5" text="deptnm"/>
                <Cell row="1" col="6" text="입원"/>
                <Cell row="1" col="7" text="외래"/>
                <Cell row="1" col="8" text="합계"/>
                <Cell row="1" col="9" text="입원"/>
                <Cell row="1" col="10" text="외래"/>
                <Cell row="1" col="11" text="합계"/>
              </Band>
              <Band id="body">
                <Cell text="bind:lvl"/>
                <Cell col="1" text="bind:cdid"/>
                <Cell col="2" text="bind:gubunnm"/>
                <Cell col="3" displaytype="tree" edittype="tree" style="align:left middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:cdnm" treestartlevel="1" treelevel="bind:lvl"/>
                <Cell col="4" style="background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:deptcd"/>
                <Cell col="5" style="background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:deptnm"/>
                <Cell col="6" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:own_inamt"/>
                <Cell col="7" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:own_outamt"/>
                <Cell col="8" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:own_totamt"/>
                <Cell col="9" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:insu_inamt"/>
                <Cell col="10" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:insu_outamt"/>
                <Cell col="11" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:insu_totamt"/>
                <Cell col="12" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:Dotum,9,bold;" text="bind:totamtall"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="grp_srch" taborder="31" position="absolute 0 25 1195 65" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout width="1195" height="41">
              <Shape id="line13" linetype="vertical" position="absolute 1108 7 1114 34" anchor="top right"/>
              <Static id="caption21" text="조회기간" class="search_name" position="absolute 15 12 85 29" anchor="default"/>
              <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1125 10 1181 32" anchor="top right" onclick="grp_srch_btn_search_onclick"/>
              <Static id="caption6" text="~" position="absolute 194 13 204 28" anchor="default"/>
              <Calendar id="ipt_fromdd" taborder="2" class="input_search" position="absolute 92 11 187 30" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null"/>
              <Calendar id="ipt_todd" taborder="3" class="input_search" position="absolute 211 11 306 30" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <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="srchflag" type="STRING" size="256"/>
          <Column id="deptyn" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="dayflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="srchflag"/>
            <Col id="deptyn"/>
            <Col id="gubun"/>
            <Col id="deptcd"/>
            <Col id="dayflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_holdlist" 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="earnenddd" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="deptname" type="STRING" size="256"/>
          <Column id="suppkindnm" type="STRING" size="256"/>
          <Column id="brateflag" type="STRING" size="256"/>
          <Column id="payamt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_instcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">031</Col>
            <Col id="cdnm">경북대학교병원</Col>
          </Row>
          <Row>
            <Col id="cdid">032</Col>
            <Col id="cdnm">칠곡 경북대학교병원</Col>
          </Row>
          <Row>
            <Col id="cdid">033</Col>
            <Col id="cdnm">경북대학교 치과병원</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_brateflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">I</Col>
            <Col id="cdnm">입원</Col>
          </Row>
          <Row>
            <Col id="cdid">O</Col>
            <Col id="cdnm">외래</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_srch.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_srch.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2018-10-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";

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

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 화면 로드시 초기화 함수
 ****************************************************************************************/

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SPSTP02400_onload(obj:Form, e:LoadEventInfo)
{
	// 폼 초기화
	frmf_initForm(obj);
	
	ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "todd", utlf_getCurrentDate());
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function grp_srch_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_diffMonth(ds_send.getColumn(0, "fromdd"), ds_send.getColumn(0, "todd")) > 2) {
		sysf_messageBox("최대 3개월까지만 조회가능합니다.","I");
		grp_srch.ipt_fromdd.setFocus();
		return;
	}
	
	ds_main_holdlist.clearData();
	var oParam = {};
		oParam.id          = "TRSTP02400";
		oParam.service     = "stspamapp.StsPam";
		oParam.method      = "reqGetForignHoldList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_holdlist=list";
		oParam.async       = false;
		//oParam.callback    = "cf_TRSTP02400";

	tranf_submit(oParam);
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_holdlist.rowcount > 0 ){
		grdf_exportExcel(grd_holdlist, "Excel", "Sheet1", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}
]]></Script>
  </Form>
</FDL>