YNU_JEUS/app_home/himed/xpapps/sts/stscmcnwxp/xp/SMSDT06500_사회사업자선진료실적.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSDT06500" position="absolute 0 0 1198 796" titletext="사회사업 자선진료실적" oninit="SMSDT06500_oninit" onload="SMSDT06500_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="사회사업 자선진료실적" class="tit_1" position="absolute 0 0 224 25"/>
        <Static id="caption21" text="사회사업 자선진료실적" class="tit_2" position="absolute 0 80 195 102"/>
        <Shape id="line1" linetype="horizontal" class="line_10" position="absolute 0 94 1195 105" anchor="left top right"/>
        <Div id="group4" taborder="2" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Static id="caption1" text="조회기간 :" class="search_name" position="absolute 465 12 565 29"/>
              <Calendar id="ipt_todd" taborder="6" class="input_search" position="absolute 670 10 743 29" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" editformat="yyyy-MM" onchanged="group4_ipt_todd_onchanged"/>
              <Calendar id="ipt_fromdd" taborder="7" class="input_search" position="absolute 557 10 630 29" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group4_ipt_fromdd_onchanged"/>
              <Static id="caption2" text="조회년도:" class="search_name" position="absolute 464 12 564 29" visible="false"/>
              <Calendar id="ipt_toentryy" taborder="8" class="input_search" visible="false" position="absolute 670 10 728 29" mask="yyyy" autoselect="true" dateformat="yyyy" value="null" editformat="yyyy" onchanged="group4_ipt_toentryy_onchanged"/>
              <Calendar id="ipt_fromentryy" taborder="9" class="input_search" visible="false" position="absolute 557 10 615 29" mask="yyyy" autoselect="true" dateformat="yyyy" editformat="yyyy" onchanged="group4_ipt_fromentryy_onchanged"/>
              <Button id="button2" taborder="5" text="조회" class="btn1" position="absolute 1123 10 1179 32" anchor="top right" onclick="group4_button2_onclick"/>
              <Shape id="line2" linetype="vertical" position="absolute 1110 10 1116 32" anchor="top right"/>
              <Static id="cap1" text="~" position="absolute 640 10 665 30"/>
              <Static id="caption23" text="조회구분 :" class="search_name" position="absolute 240 13 326 30"/>
              <Combo id="cmb_sumflag" taborder="10" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 335 11 420 30" onitemchanged="group4_cmb_sumflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">월별</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">년도별</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption3" text="입원/외래 :" class="search_name" position="absolute 15 12 108 29"/>
              <Combo id="cmd_ioflag" taborder="11" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 115 10 200 29">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">- 전 체 -</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">I</Col>
                      <Col id="datacolumn">입원</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">O</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excel" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 77 1195 96" anchor="top right" onclick="btn_excel_onclick"/>
        <Grid id="grd_list" class="datagrid1" taborder="4" binddataset="ds_main_chacinfo_chaclist" useinputpanel="false" position="absolute 0 101 1195 765" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="197"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="59"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="3" text="구분" taborder="undefined"/>
                <Cell col="1" colspan="2" text="사회사업 자선환자" taborder="undefined"/>
                <Cell col="3" colspan="7" text="사회사업 자선진료비" taborder="undefined"/>
                <Cell row="1" col="1" rowspan="2" text="실인원" taborder="undefined"/>
                <Cell row="1" col="2" rowspan="2" text="연인원" taborder="undefined"/>
                <Cell row="1" col="3" rowspan="2" text="총액" taborder="undefined"/>
                <Cell row="1" col="4" colspan="4" text="납부액" taborder="undefined"/>
                <Cell row="1" col="8" rowspan="2" text="보조액" taborder="undefined"/>
                <Cell row="1" col="9" rowspan="2" text="감면액" taborder="undefined"/>
                <Cell row="2" col="4" text="공단청구액"/>
                <Cell row="2" col="5" text="외부후원액"/>
                <Cell row="2" col="6" text="본인납부액"/>
                <Cell row="2" col="7" text="총납부액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:discunconm"/>
                <Cell col="1" displaytype="number" style="align:center middle;" text="bind:orgpatcnt"/>
                <Cell col="2" displaytype="number" style="align:center middle;" text="bind:yearpatcnt"/>
                <Cell col="3" displaytype="number" style="align:center middle;" text="bind:totamt"/>
                <Cell col="4" displaytype="number" style="align:center middle;" text="bind:totinsubamt"/>
                <Cell col="5" displaytype="number" style="align:center middle;" text="bind:outeraidamt"/>
                <Cell col="6" displaytype="number" style="align:center middle;" text="bind:rcptamt"/>
                <Cell col="7" displaytype="number" style="align:center middle;" text="bind:totownbamt"/>
                <Cell col="8" displaytype="number" style="align:center middle;" text="bind:suppamt"/>
                <Cell col="9" displaytype="number" style="align:center middle;" text="bind:aidsuppamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line37" class="line_6" position="absolute 0 765 1195 771" anchor="left right bottom"/>
        <Button id="btn_search0" taborder="5" text="초기화" class="btn4" position="absolute 1127 770 1195 792" anchor="right bottom" onclick="btn_search0_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_search" 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="fromentryy" type="STRING" size="256"/>
          <Column id="fromendyy" type="STRING" size="256"/>
          <Column id="toendyy" type="STRING" size="256"/>
          <Column id="toentryy" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="fromentryy"/>
            <Col id="fromendyy"/>
            <Col id="toendyy"/>
            <Col id="toentryy"/>
            <Col id="flag"/>
            <Col id="ioflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_chacinfo_chaclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ordflagnm" type="STRING" size="256" sumtext="입원외래"/>
          <Column id="discunconm" type="STRING" size="256" sumtext="자선진료코드명"/>
          <Column id="orgpatcnt" type="INT" size="256" sumtext="실인원수"/>
          <Column id="yearpatcnt" type="INT" size="256" sumtext="연인원수"/>
          <Column id="totamt" type="LOGN" size="256" sumtext="총액"/>
          <Column id="totinsubamt" type="LOGN" size="256" sumtext="공단청구액"/>
          <Column id="outeraidamt" type="LOGN" size="256" sumtext="외부후원액"/>
          <Column id="rcptamt" type="LOGN" size="256" sumtext="본인납부액"/>
          <Column id="totownbamt" type="LOGN" size="256" sumtext="총납부액"/>
          <Column id="suppamt" type="LOGN" size="256" sumtext="보조액"/>
          <Column id="aidsuppamt" type="LOGN" size="256" sumtext="후원보조액"/>
          <Column id="supprate" type="BIGDECIMAL" size="256" sumtext="총액대비보조율"/>
          <Column id="ownsupprate" type="BIGDECIMAL" size="256" sumtext="환자부담액대비보조율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.cmd_ioflag" propid="value" datasetid="ds_main_search" columnid="ioflag"/>
      <BindItem id="item1" compid="group4.cmb_sumflag" propid="value" datasetid="ds_main_search" columnid="flag"/>
      <BindItem id="item2" compid="group4.ipt_fromentryy" propid="value" datasetid="ds_main_search" columnid="fromentryy"/>
      <BindItem id="item3" compid="group4.ipt_fromdd" propid="value" datasetid="ds_main_search" columnid="fromdd"/>
      <BindItem id="item4" compid="group4.ipt_toentryy" propid="value" datasetid="ds_main_search" columnid="toentryy"/>
      <BindItem id="item5" compid="group4.ipt_todd" propid="value" datasetid="ds_main_search" columnid="todd"/>
    </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 SMSDT06500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMSDT06500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_list);
	
	fInit();	
}

function fInit()
{
	ds_main_chacinfo_chaclist.clearData();
	
	group4.cmb_sumflag.index = 0;
	
	var currentDate = utlf_getCurrentDate();
	var LastDate = currentDate.toDate().getAddDate(-1,"M").getDateFormat();
	var LastDateYM = String(LastDate).substr(0,6);
	
	ds_main_search.setColumn(0, "fromdd"	,LastDateYM);
	ds_main_search.setColumn(0, "todd"	,LastDateYM);
	
	var CurrentDateYY = String(currentDate).substring(0,4);
	dsf_makeValue(ds_main_search, "fromentryy", "string",CurrentDateYY);
	dsf_makeValue(ds_main_search, "toentryy", "string",CurrentDateYY);
}			

function group4_cmb_sumflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fComSelect();
}

function fComSelect()
{
	if(group4.cmb_sumflag.value=='1')
	{
		group4.ipt_fromdd.visible = true;
		group4.ipt_todd.visible = true;
		group4.ipt_fromentryy.visible = false;
		group4.ipt_toentryy.visible = false;
		group4.cap1.visible = true;
		group4.caption1.visible = true;
		group4.caption2.visible = false;
	}
	else
	{
		group4.ipt_fromdd.visible = false;
		group4.ipt_todd.visible = false;
		group4.ipt_fromentryy.visible = true;
		group4.ipt_toentryy.visible = true;
		group4.cap1.visible = true;
		group4.caption1.visible = false;
		group4.caption2.visible = true;
	}		
}

function group4_ipt_fromentryy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_search.setColumn(0, "fromentryy", String(obj.value).substr(0,4));
}

function group4_ipt_toentryy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_search.setColumn(0, "toentryy", String(obj.value).substr(0,4));
}

function group4_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_search.setColumn(0, "fromdd", String(obj.value).substr(0,6));
}

function group4_ipt_todd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_search.setColumn(0, "todd", String(obj.value).substr(0,6));
}

function group4_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
}

function fSearch()
{	
	var fromdd = ds_main_search.getColumn(0, "fromdd");
	var todd = ds_main_search.getColumn(0, "todd");
	var fromentryy = ds_main_search.getColumn(0, "fromentryy");
	var toentryy = ds_main_search.getColumn(0, "toentryy");
	
	if (group4.cmb_sumflag.value == "1")
	{
		var fromdd = ds_main_search.getColumn(0, "fromdd");
		var todd = ds_main_search.getColumn(0, "todd");
		
		var fdate = ds_main_search.getColumn(0, "fromdd") +"01";
		var tdate = ds_main_search.getColumn(0, "todd")+ "31";	
		
		var dateintval = utlf_getDateInterval(fdate,tdate);
		
		if(utlf_isNull(fromdd))
		{
			sysf_messageBox("조회시작일자는","I003");
			group4.ipt_fromdd.setFocus();
			return;
		}
		if(utlf_isNull(todd))
		{
			sysf_messageBox("조회종료일자는","I003");
			group4.ipt_todd.setFocus();
			return;
		}
		if(fromdd > todd)
		{
			sysf_messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
			group4.ipt_todd.setFocus();
			return;
		}
		if(dateintval > 370)
		{
			sysf_messageBox("조회기간은 최대1년까지 할 수 있습니다.","I");
			group4.ipt_fromdd.setFocus();
			return;
		}
	}
	else
	{
		var fromdd = ds_main_search.getColumn(0, "fromentryy");
		var todd = ds_main_search.getColumn(0, "toentryy");
		
		var dateintval = utlf_getDateInterval(fromdd+"0101",todd+"1231");
		
		if(utlf_isNull(fromdd))
		{
			sysf_messageBox("조회시작연도는","I003");
			group4.ipt_fromentryy.setFocus();
			return;
		}
		if(utlf_isNull(todd))
		{
			sysf_messageBox("조회종료연도는","I003");
			group4.ipt_toentryy.setFocus();
			return;
		}
		if(fromdd > todd)
		{
			sysf_messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
			group4.ipt_toentryy.setFocus();
			return;
		}
		
		if(dateintval > "1980")
		{
			sysf_messageBox("조회기간은 최대 5년까지 할 수 있습니다","I");
			group4.ipt_fromentryy.setFocus();
			return;
		} 
	}
	
	var ioflag = ds_main_search.getColumn(0, "ioflag");
	var flag = ds_main_search.getColumn(0, "flag");
	
	ds_send_search.clearData();
	
	dsf_makeValue(ds_send_search, "flag", "string", flag);
	dsf_makeValue(ds_send_search, "ioflag", "string", ioflag);
	dsf_makeValue(ds_send_search, "fromdd", "string", fromdd);
	dsf_makeValue(ds_send_search, "todd", "string", todd);
	dsf_makeValue(ds_send_search, "fromentryy", "string", fromentryy);
	dsf_makeValue(ds_send_search, "toentryy", "string", toentryy);
	
	var oParam = {};
		oParam.id          = "TRSDT06501";
		oParam.service     = "stscmcnwapp.SoclEndStats";
		oParam.method      = "reqGetCharityOrdStat";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_chacinfo_chaclist=chaclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRSDT06501";

	tranf_submit(oParam);
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	fExcel();
}

function fExcel()
{
	if (ds_main_chacinfo_chaclist.rowcount == 0)
	{
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}
	
	grdf_exportExcel(grd_list, "사회사업 자선진료대장", "SheetName", "true", "", "");
}

function btn_search0_onclick(obj:Button,  e:ClickEventInfo)
{
	fInit();
}
]]></Script>
  </Form>
</FDL>