YNU_JEUS/app_home/himed/xpapps/sts/stscmcnwxp/xp/SMSDT06700_사회사업기부금실적.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSDT06700" position="absolute 0 0 1201 782" titletext="사회사업 기부금실적" oninit="SMSDT06700_oninit" onload="SMSDT06700_onload">
    <Layouts>
      <Layout>
        <Tab id="switch1" anchor="all" taborder="4" tabindex="0" class="tab_Normal" position="absolute 0 83 1195 748">
          <Tabpages>
            <Tabpage id="case1">
              <Layouts>
                <Layout>
                  <Grid id="grd_list" class="datagrid1" taborder="0" binddataset="ds_main_deciinfo_decilist" useinputpanel="false" position="absolute 0 5 1195 652" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="200"/>
                          <Column size="150"/>
                          <Column size="150"/>
                          <Column size="150"/>
                          <Column size="150"/>
                          <Column size="150"/>
                          <Column size="150"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell rowspan="2" text="구분" taborder="undefined"/>
                          <Cell col="1" rowspan="2" text="기부자수" taborder="undefined"/>
                          <Cell col="2" rowspan="2" text="기부금액" taborder="undefined"/>
                          <Cell col="3" rowspan="2" text="기부자1인당&#10;평균금액" taborder="undefined"/>
                          <Cell col="4" rowspan="2" text="사회사업&#10;기부금 지원결정환자수" taborder="undefined"/>
                          <Cell col="5" rowspan="2" text="사회사업&#10;기부금 결정액" taborder="undefined"/>
                          <Cell col="6" rowspan="2" text="환자1인당&#10;기부금 결정액" taborder="undefined"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:flagnm"/>
                          <Cell col="1" displaytype="number" text="bind:contribpatcnt"/>
                          <Cell col="2" displaytype="number" text="bind:contribamt"/>
                          <Cell col="3" displaytype="number" text="bind:contribpatamt"/>
                          <Cell col="4" displaytype="number" text="bind:decipatcnt"/>
                          <Cell col="5" displaytype="number" text="bind:deciamt"/>
                          <Cell col="6" displaytype="number" text="bind:patamt"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case2">
              <Layouts>
                <Layout>
                  <Grid id="grd_exps" class="datagrid1" taborder="0" binddataset="ds_main_expsinfo_expslist" useinputpanel="false" position="absolute 0 5 1195 652" autoenter="select" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="230"/>
                          <Column size="230"/>
                          <Column size="230"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell rowspan="2" text="구분" taborder="undefined"/>
                          <Cell col="1" rowspan="2" text="사회사업&#10;기부금 지원환자수" taborder="undefined"/>
                          <Cell col="2" rowspan="2" text="사회사업&#10;기부금 지출액" taborder="undefined"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:flagnm"/>
                          <Cell col="1" displaytype="number" text="bind:supppatcnt"/>
                          <Cell col="2" displaytype="number" text="bind:suppamt"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="caption6" text="사회사업 기부금실적" class="tit_1" position="absolute 0 0 224 25"/>
        <Shape id="line1" class="line_10" position="absolute 0 95 1195 104" anchor="left top right"/>
        <Div id="group4" anchor="left top right" taborder="2" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Static id="caption2" text="조회년도:" class="search_name" position="absolute 741 12 841 29" visible="false"/>
              <Shape id="line2" linetype="vertical" position="absolute 1110 9 1116 31" anchor="top right"/>
              <Static id="cap1" text="~" position="absolute 905 14 914 26"/>
              <Static id="caption1" text="조회기간 :" class="search_name" position="absolute 740 12 840 29"/>
              <Static id="caption23" text="조회구분 :" class="search_name" position="absolute 506 12 592 29"/>
              <Combo id="cmb_ioflag" taborder="2" innerdataset="@ds_init_ioflag1_C0029" codecolumn="cdid" datacolumn="cdnm" position="absolute 385 11 470 30"/>
              <Combo id="cmb_sumflag" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 601 10 701 29" 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>
              <Calendar id="ipt_fromdd" taborder="4" class="input_search" position="absolute 819 11 892 30" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group4_ipt_fromdd_onchanged"/>
              <Calendar id="ipt_todd" taborder="5" class="input_search" position="absolute 928 11 1001 30" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group4_ipt_todd_onchanged"/>
              <Calendar id="ipt_fromentryy" taborder="6" class="input_search" position="absolute 819 11 877 30" mask="yyyy" autoselect="true" dateformat="yyyy" value="null" editformat="yyyy" onchanged="group4_ipt_fromentryy_onchanged" visible="false"/>
              <Calendar id="ipt_toentryy" taborder="7" class="input_search" position="absolute 928 11 986 30" mask="yyyy" autoselect="true" dateformat="yyyy" value="null" editformat="yyyy" onchanged="group4_ipt_toentryy_onchanged" visible="false"/>
              <Static id="caption3" text="입원/외래 :" class="search_name" position="absolute 285 13 378 30"/>
              <Button id="btn_search" taborder="8" text="조회" class="btn1" position="absolute 1123 9 1179 31" anchor="top right" onclick="group4_btn_search_onclick"/>
              <Radio id="rdo_achivflag" taborder="9" columncount="4" rowcount="1" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 23 10 268 30" onitemchanged="group4_rdo_achivflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">C1</Col>
                      <Col id="datacolumn">기부금 결정실적</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C2</Col>
                      <Col id="datacolumn">기부금 지출실적</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </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"/>
        <Static id="cap_list" text="사회사업 기부금실적" class="tit_2" position="absolute 0 80 217 102"/>
        <Shape id="line37" class="line_6" position="absolute 0 748 1195 754" anchor="left right bottom"/>
        <Button id="btn_search0" taborder="5" text="초기화" class="btn4" position="absolute 1127 752 1195 774" 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"/>
          <Column id="achivflag" 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"/>
            <Col id="achivflag">C1</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_ioflag1_C0029" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_deciinfo_decilist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flagnm" type="STRING" size="256" sumtext="구분"/>
          <Column id="contribpatcnt" type="INT" size="256" sumtext="기부자수"/>
          <Column id="contribamt" type="BIGDECIMAL" size="256" sumtext="기부금액"/>
          <Column id="contribpatamt" type="BIGDECIMAL" size="256" sumtext="1인당평균금액"/>
          <Column id="decipatcnt" type="INT" size="256" sumtext="기부금결정환자수"/>
          <Column id="deciamt" type="LOGN" size="256" sumtext="기부금결정금액"/>
          <Column id="patamt" type="BIGDECIMAL" size="256" sumtext="1인당결정금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_expsinfo_expslist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flagnm" type="STRING" size="256" sumtext="구분"/>
          <Column id="supppatcnt" type="INT" size="256" sumtext="기부금지원환자수"/>
          <Column id="suppamt" type="INT" 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.rdo_achivflag" propid="value" datasetid="ds_main_search" columnid="achivflag"/>
      <BindItem id="item1" compid="group4.cmb_ioflag" propid="value" datasetid="ds_main_search" columnid="ioflag"/>
      <BindItem id="item2" compid="group4.cmb_sumflag" propid="value" datasetid="ds_main_search" columnid="flag"/>
      <BindItem id="item3" compid="group4.ipt_fromentryy" propid="value" datasetid="ds_main_search" columnid="fromentryy"/>
      <BindItem id="item4" compid="group4.ipt_fromdd" propid="value" datasetid="ds_main_search" columnid="todd"/>
      <BindItem id="item5" compid="group4.ipt_toentryy" propid="value" datasetid="ds_main_search" columnid="toentryy"/>
      <BindItem id="item6" 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";
var arErrorCode = new HashArray();
function SMSDT06700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMSDT06700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case1.grd_list);
	grdf_initGrid(switch1.case2.grd_exps);
	
	fInit();
}

function fInit()
{
	ds_main_deciinfo_decilist.clearData();
	group4.cmb_sumflag.index = 0;
	
	var arrParam = [{dsNm: "ds_init_ioflag_A0563", cdGrpId: "A0563"}
				   ,{dsNm: "ds_init_ioflag1_C0029", cdGrpId: "C0029"}]
	appf_getCodeList(arrParam); 
	
	frmf_addComboItem("group4.cmb_ioflag", "", "", "above");

	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);
	
	group4.cmb_ioflag.index = 0;
}		

function group4_rdo_achivflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	fAchivflagChagne();		
}

function fAchivflagChagne()
{
	if(group4.rdo_achivflag.value == 'C1')
	{
		ds_main_deciinfo_decilist.clearData();
		switch1.tabindex = 0;
		
		cap_list.text = "사회사업 기부금결정실적";
		group4.cmb_ioflag.index = 0;
	}
	else
	{
		ds_main_expsinfo_expslist.clearData();
		switch1.tabindex = 1;
		group4.cmb_ioflag.index = 0;
		
		cap_list.text = "사회사업 기부금지출실적";
	}
}

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

function fComSelect()
{
	var CurrentDate = utlf_getCurrentDate();
	
	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_btn_search_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");
	
	var frommonth = ds_main_search.getColumn(0, "fromdd") + "01";
	var tomonth = ds_main_search.getColumn(0, "todd") + "01";

	var fromyear = ds_main_search.getColumn(0, "fromentryy")+ "0101";
	var toyear = ds_main_search.getColumn(0, "toentryy")+ "0101";
	
	var ioflag = ds_main_search.getColumn(0, "ioflag");
	var flag = ds_main_search.getColumn(0, "flag");
	
	if (flag == "2")
	{
		if( ! utlf_isValidDateTime( fromyear, 'YYYYMMDD') || ! utlf_isValidDateTime( toyear, 'YYYYMMDD') )
		{
			sysf_messageBox("입력하신 일자구분이 정확한 날짜타입이 아닙니다.", "I999", "");
			group4.ipt_fromentryy.setFocus();
			return;
		}
		
		if( utlf_getDateInterval(fromyear, toyear) > 1825 )
		{
			sysf_messageBox("조회기간은 최대5년까지 할 수 있습니다.", "I999", "");
			group4.ipt_toentryy.setFocus();
			return;	
		}

		if( utlf_getDateInterval(fromyear, toyear) < 0 )
		{
			sysf_messageBox("일자구분에서 시작일자가 종료일자보다 미래일자 입니다. 확인하세요!", "I999", "");
			group4.ipt_fromentryy.setFocus();
			return;
		}
	}
	else
	{
		if( !utlf_isValidDateTime( fromdd, 'YYYYMM') || !utlf_isValidDateTime(todd, 'YYYYMM') )
		{
			sysf_messageBox("입력하신 일자구분이 정확한 날짜타입이 아닙니다.", "I999", "");
			group4.ipt_fromdd.setFocus();
			return;
		}
		
		if( utlf_getDateInterval(frommonth, tomonth) > 365 )
		{
			sysf_messageBox("조회기간은 최대1년까지 할 수 있습니다..", "I999", "");
			group4.ipt_todd.setFocus();
			return;	
		}

		if( utlf_getDateInterval(frommonth, tomonth) < 0 )
		{
			sysf_messageBox("일자구분에서 시작일자가 종료일자보다 미래일자 입니다. 확인하세요!", "I999", "");
			group4.ipt_fromdd.setFocus();
			return;
		}
		
	}
	
	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 achivflag = ds_main_search.getColumn(0, "achivflag");
	dsf_makeValue(ds_send_search, "achivflag", "string", achivflag);
	
	if (achivflag == "C1")
	{
		var oParam = {};
			oParam.id          = "TRSDT06701";
			oParam.service     = "stscmcnwapp.SoclEndStats";
			oParam.method      = "reqGetContribDeciStat";
			oParam.inds        = "req=ds_send_search";
			oParam.outds       = "ds_main_deciinfo_decilist=decilist";
			oParam.async       = false;
			oParam.callback    = "cf_submit";

		tranf_submit(oParam);
		
		if(arErrorCode.pop("TRSDT06701") > -1)
		{
			var sumflag = ds_main_search.getColumn(0, "flag");
			
			if (sumflag == "1")
			{
				fGetDeciResult();
			}
			
		}
		else
		{
			sysf_messageBox("조회를", "E009");
		}
	}
	else
	{
		var oParam = {};
			oParam.id          = "TRSDT06702";
			oParam.service     = "stscmcnwapp.SoclEndStats";
			oParam.method      = "reqGetContribSuppStat";
			oParam.inds        = "req=ds_send_search";
			oParam.outds       = "ds_main_expsinfo_expslist=expslist";
			oParam.async       = false;
			oParam.callback    = "cf_submit";

		tranf_submit(oParam);

		if(arErrorCode.pop("TRSDT06702") > -1)
		{
			var sumflag = ds_main_search.getColumn(0, "flag");
			if (sumflag == "1")
			{
				fGetExpsResult();
			}
		}
		else
		{
			sysf_messageBox("조회를", "E009");
		}
	}
}

function cf_submit(sSvcId, nErrorCode, sErrorMsg) 
{
	arErrorCode.push(sSvcId, nErrorCode);
    if(nErrorCode < 0) return;
}

function fGetDeciResult()
{
	if(ds_main_deciinfo_decilist.rowcount > 1)
	{
		var sStat = 0;
		var insRow = ds_main_deciinfo_decilist.addRow();
		
		ds_main_deciinfo_decilist.setColumn(insRow, "flagnm", "전기간대비실적비교");
			
		for(var i = 1; i < 7; i++)
		{
			var bfResult = eval(ds_main_deciinfo_decilist.getColumn(insRow-1 , i));
			var sSum = eval(ds_main_deciinfo_decilist.getColumn(insRow-2 , i));			
			sStat = eval(sSum)- eval(bfResult) ;			
			ds_main_deciinfo_decilist.setColumn(insRow, i ,eval(sStat));
		}	
	}
	else
	{
		ds_main_deciinfo_decilist.clearData();
	}
}

function fGetExpsResult()
{	
	if(ds_main_expsinfo_expslist.rowcount > 1)
	{
		var sStat = 0;
		var insRow = ds_main_expsinfo_expslist.addRow();
		ds_main_expsinfo_expslist.setColumn(insRow, "flagnm", "전기간대비실적비교");
			
		for(var i = 1; i < 3; i++)
		{
			var bfResult = eval(ds_main_expsinfo_expslist.getColumn(insRow-1 , i));												
			var sSum = eval(ds_main_expsinfo_expslist.getColumn(insRow-2, i));
			
			sStat = eval(sSum)- eval(bfResult) ;							
			ds_main_expsinfo_expslist.setColumn(insRow, i, eval(sStat));
		}	
	}
	else
	{
		ds_main_expsinfo_expslist.clearData();
	}
}

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

function fExcel() 
{	
	var achivflag = ds_main_search.getColumn(0, "achivflag");
	
	if (achivflag == "C1")
	{
		if (ds_main_deciinfo_decilist.rowcount == 0)
		{
			sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
			return;
		}
		
		grdf_exportExcel(switch1.case1.grd_list, "사회사업 기부금결정실적", "SheetName", "true", "", "");	
	}
	else
	{
		if (ds_main_expsinfo_expslist.rowcount == 0)
		{
			sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
			return;
		}
		
		grdf_exportExcel(switch1.case2.grd_exps, "사회사업 기부금지출실적", "SheetName", "true", "", "");	
	}
}

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