YNU_JEUS/app_home/himed/xpapps/sts/stscmcnwxp/xp/SMSDT06300_사회사업자선회수입금지출금현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSDT06300" position="absolute 0 0 1201 808" titletext="사회사업자선회수입금지출금현황" oninit="SMSDT06300_oninit" onload="SMSDT06300_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="사회사업 자선회수입금지출금 현황" class="tit_1" position="absolute 0 0 270 25"/>
        <Static id="caption21" text="사회사업 자선회수입금지출금 현황" class="tit_2" position="absolute 0 92 240 114"/>
        <Shape id="line1" class="line_10" position="absolute 0 107 1195 116" anchor="left top right"/>
        <Div id="group4" anchor="left top right" taborder="2" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Calendar id="ipt_toentryy" taborder="7" class="input_search" position="absolute 404 10 462 29" mask="yyyy" onchanged="group4_ipt_toentryy_onchanged" autoselect="true" dateformat="yyyy" value="null" editformat="yyyy"/>
              <Calendar id="ipt_fromdd" taborder="4" class="input_search" position="absolute 300 11 366 30" mask="yyyy" onchanged="group4_ipt_fromdd_onchanged" dateformat="yyyy" value="null" editformat="yyyy" autoselect="true"/>
              <Calendar id="ipt_fromentryy" taborder="6" class="input_search" position="absolute 299 11 365 30" mask="yyyy" dateformat="yyyy" value="null" editformat="yyyy" autoselect="true" onchanged="group4_ipt_fromentryy_onchanged"/>
              <Combo id="cmb_reqincm" taborder="9" innerdataset="@ds_init_incm_A0639" codecolumn="cdid" datacolumn="cdnm" position="absolute 809 11 894 30"/>
              <Combo id="cmb_reqexps" taborder="10" innerdataset="@ds_init_exps_A0640" codecolumn="cdid" datacolumn="cdnm" position="absolute 809 11 894 30"/>
              <Static id="caption4" text="입금구분 :" class="search_name" position="absolute 719 12 810 29"/>
              <Static id="caption5" text="출금구분 :" class="search_name" position="absolute 719 12 810 29"/>
              <Static id="caption2" text="조회기간:" class="search_name" position="absolute 209 12 285 29"/>
              <Button id="button2" taborder="3" text="조회" class="btn1" position="absolute 1123 10 1179 32" anchor="top right" onclick="group4_button2_onclick"/>
              <Static id="caption23" text="조회구분 :" class="search_name" position="absolute 15 12 101 29"/>
              <Shape id="line2" linetype="vertical" position="absolute 1110 10 1116 32" anchor="top right"/>
              <Static id="cap1" text="~" position="absolute 374 10 399 30"/>
              <Static id="caption1" text="조회년도 :" class="search_name" position="absolute 210 12 286 29"/>
              <Combo id="cmb_reqflag" taborder="5" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 105 10 190 29" onitemchanged="group4_cmb_reqflag_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 499 12 595 29"/>
              <Combo id="cmb_reqflag2" taborder="8" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 599 11 684 30" onitemchanged="group4_cmb_reqflag2_onitemchanged">
                <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 89 1195 108" anchor="top right" onclick="btn_excel_onclick"/>
        <Grid id="grd_brgstincmexpsprescond" class="datagrid2" taborder="4" binddataset="ds_main_brgstincmexpspres_brgstincmexpsprescond" useinputpanel="false" position="absolute 0 113 1195 777" anchor="all" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="40"/>
                <Column size="0"/>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="구분"/>
                <Cell col="1" text="구분코드"/>
                <Cell col="2" text="구분"/>
                <Cell col="3" text="1월"/>
                <Cell col="4" text="2월"/>
                <Cell col="5" text="3월"/>
                <Cell col="6" text="4월"/>
                <Cell col="7" text="5월"/>
                <Cell col="8" text="6월"/>
                <Cell col="9" text="7월"/>
                <Cell col="10" text="8월"/>
                <Cell col="11" text="9월"/>
                <Cell col="12" text="10월"/>
                <Cell col="13" text="11월"/>
                <Cell col="14" text="12월"/>
                <Cell col="15" text="합계"/>
                <Cell col="16" text="구분그룹코드"/>
              </Band>
              <Band id="body">
                <Cell text="bind:inextype" suppress="1" suppressalign="middle,over"/>
                <Cell col="1" text="bind:cdid"/>
                <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:cdnm"/>
                <Cell col="3" displaytype="number" text="bind:amt01"/>
                <Cell col="4" displaytype="number" text="bind:amt02"/>
                <Cell col="5" displaytype="number" text="bind:amt03"/>
                <Cell col="6" displaytype="number" text="bind:amt04"/>
                <Cell col="7" displaytype="number" text="bind:amt05"/>
                <Cell col="8" displaytype="number" text="bind:amt06"/>
                <Cell col="9" displaytype="number" text="bind:amt07"/>
                <Cell col="10" displaytype="number" text="bind:amt08"/>
                <Cell col="11" displaytype="number" text="bind:amt09"/>
                <Cell col="12" displaytype="number" text="bind:amt10"/>
                <Cell col="13" displaytype="number" text="bind:amt11"/>
                <Cell col="14" displaytype="number" text="bind:amt12"/>
                <Cell col="15" displaytype="number" text="bind:amt13"/>
                <Cell col="16" text="bind:cdgrupid" mask="(-)#,###"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line37" class="line_6" position="absolute 0 777 1195 783" anchor="left right bottom"/>
        <Button id="btn_search0" taborder="5" text="초기화" class="btn4" position="absolute 1127 782 1195 804" anchor="right bottom" onclick="btn_search0_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_brgstincmexpspres_brgstincmexpsprescond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="inextype" type="STRING" size="256" sumtext="수입지출구분"/>
          <Column id="cdid" type="STRING" size="256" sumtext="구분코드"/>
          <Column id="cdnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="amt01" type="STRING" size="256" sumtext="01월금액"/>
          <Column id="amt02" type="STRING" size="256" sumtext="02월금액"/>
          <Column id="amt03" type="STRING" size="256" sumtext="03월금액"/>
          <Column id="amt04" type="STRING" size="256" sumtext="04월금액"/>
          <Column id="amt05" type="STRING" size="256" sumtext="05월금액"/>
          <Column id="amt06" type="STRING" size="256" sumtext="06월금액"/>
          <Column id="amt07" type="STRING" size="256" sumtext="07월금액"/>
          <Column id="amt08" type="STRING" size="256" sumtext="08월금액"/>
          <Column id="amt09" type="STRING" size="256" sumtext="09월금액"/>
          <Column id="amt10" type="STRING" size="256" sumtext="10월금액"/>
          <Column id="amt11" type="STRING" size="256" sumtext="11월금액"/>
          <Column id="amt12" type="STRING" size="256" sumtext="12월금액"/>
          <Column id="amt13" type="STRING" size="256" sumtext="합계"/>
          <Column id="cdgrupid" type="STRING" size="256" sumtext="구분그룹코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_exps_A0640" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_incm_A0639" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reqflag" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="reqflag2" type="STRING" size="256"/>
          <Column id="reqincm" type="STRING" size="256"/>
          <Column id="reqexps" type="STRING" size="256"/>
          <Column id="fromentryy" type="STRING" size="256"/>
          <Column id="toentryy" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="reqflag">1</Col>
            <Col id="fromdd"/>
            <Col id="reqflag2"/>
            <Col id="reqincm"/>
            <Col id="reqexps"/>
            <Col id="fromentryy"/>
            <Col id="toentryy"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.cmb_reqflag" propid="value" datasetid="ds_main_search" columnid="reqflag"/>
      <BindItem id="item1" compid="group4.ipt_fromentryy" propid="value" datasetid="ds_main_search" columnid="fromentryy"/>
      <BindItem id="item2" compid="group4.ipt_fromdd" propid="value" datasetid="ds_main_search" columnid="fromdd"/>
      <BindItem id="item3" compid="group4.ipt_toentryy" propid="value" datasetid="ds_main_search" columnid="toentryy"/>
      <BindItem id="item4" compid="group4.cmb_reqflag2" propid="value" datasetid="ds_main_search" columnid="reqflag2"/>
      <BindItem id="item5" compid="group4.cmb_reqincm" propid="value" datasetid="ds_main_search" columnid="reqincm"/>
      <BindItem id="item6" compid="group4.cmb_reqexps" propid="value" datasetid="ds_main_search" columnid="reqexps"/>
    </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 SMSDT06300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMSDT06300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_brgstincmexpsprescond);
	
	fInit();
}

function fInit()
{
	group4.ipt_fromentryy.visible=false;
	group4.ipt_toentryy.visible=false;
	group4.cap1.visible=false;
	group4.caption1.visible=true;
	group4.caption2.visible=false;

	group4.cmb_reqincm.visible=false;
	group4.cmb_reqexps.visible=false;
	group4.caption4.visible=false;
	group4.caption5.visible=false;
	
	var arrParam = [{dsNm: "ds_init_incm_A0639", cdGrpId: "A0639"}
				   ,{dsNm: "ds_init_exps_A0640", cdGrpId: "A0640"}]
	appf_getCodeList(arrParam); 
	
	ds_main_brgstincmexpspres_brgstincmexpsprescond.clearData();
	
	var CurrentDate = utlf_getCurrentDate();
	var CurrentDateYM = String(CurrentDate).substr(0,6);
	var LastDate = CurrentDate.toDate().getAddDate(-1,"M").getDateFormat();
	var LastDateYM = String(LastDate).substr(0,6);
	
	dsf_makeValue(ds_main_search, "fromdd", "string", LastDateYM);
	
	var CurrentDateYY = String(CurrentDate).substring(0,4);
	dsf_makeValue(ds_main_search, "fromentryy", "string", CurrentDateYY);
	dsf_makeValue(ds_main_search, "toentryy", "string", CurrentDateYY);
	
	frmf_addComboItem("group4.cmb_reqincm", "전체", "", "above");
	frmf_addComboItem("group4.cmb_reqexps", "전체", "", "above");
}			

function group4_ipt_fromentryy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_search.setColumn(0, "fromentryy", 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,4));
}

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

function group4_cmb_reqflag2_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if(obj.value == 'I')
	{
		group4.cmb_reqincm.visible = true;
		group4.cmb_reqexps.visible = false;
		group4.caption4.visible = true;
		group4.caption5.visible = false;
		group4.cmb_reqincm.index = 0;
	}
	else if(obj.value=='O')
	{
		group4.cmb_reqincm.visible = false;
		group4.cmb_reqexps.visible = true;
		group4.caption4.visible = false;
		group4.caption5.visible = true;
		group4.cmb_reqexps.index = 0;
	}
	else
	{
		group4.cmb_reqincm.visible = false;
		group4.cmb_reqexps.visible = false;
		group4.caption4.visible = false;
		group4.caption5.visible = false;
	}
}

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

function fReqBrgstIncmExpsCond()
{
	ds_send_reqdata.clearData();
	
	var fdate = ds_main_search.getColumn(0, "fromdd");
	var reqflag = ds_main_search.getColumn(0, "reqflag");
	var fromentryy = ds_main_search.getColumn(0, "fromentryy");
	var toentryy = ds_main_search.getColumn(0, "toentryy");
	
	var fromdd = String(fdate).substr(0,4);
	
	dsf_makeValue(ds_send_reqdata, "fromdd", "string", fromdd);
	dsf_makeValue(ds_send_reqdata, "reqflag", "string", reqflag);
	dsf_makeValue(ds_send_reqdata, "fromentryy", "string", fromentryy);
	dsf_makeValue(ds_send_reqdata, "toentryy", "string", toentryy);

	dsf_makeValue(ds_send_reqdata, "reqflag2", "string", ds_main_search.getColumn(0, "reqflag2"));
	dsf_makeValue(ds_send_reqdata, "reqincm", "string", ds_main_search.getColumn(0, "reqincm"));
	dsf_makeValue(ds_send_reqdata, "reqexps", "string", ds_main_search.getColumn(0, "reqexps"));
	
	if(reqflag=='1')
	{
		if(utlf_isNull(fromdd))
		{
			sysf_messageBox("조회시작일자는","I003");
			model.setFocus("ipt_fromdd");
			return;
		}
	}
	else
	{
		if(utlf_isNull(fromentryy))
		{
			sysf_messageBox("조회시작연도는","I003");
			group4.ipt_fromentryy.setFocus();
			return;
		}
		if(utlf_isNull(toentryy))
		{
			sysf_messageBox("조회종료연도는","I003");
			group4.ipt_toentryy.setFocus();
			return;
		}
		if(fromentryy > toentryy)
		{
			sysf_messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
			group4.ipt_fromentryy.setFocus();
			return;
		}
		var dateintval = utlf_getDateInterval(fromentryy+"0101",toentryy+"1231");
		if(dateintval>"1980")
		{
			sysf_messageBox("조회기간은 최대 5년까지 할 수 있습니다","I");
			group4.ipt_fromdd.setFocus();
			return;
		}
	}
	
	var oParam = {};
		oParam.id          = "TRSDT06301";
		oParam.service     = "stscmcnwapp.SoclEndStats";
		oParam.method      = "reqGetCharityIncmExps";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_brgstincmexpspres_brgstincmexpsprescond=brgstincmexpsprescond";
		oParam.async       = false;
		//oParam.callback    = "cf_TRSDT06301";

	tranf_submit(oParam);

	var arrCol = ["inextype", "cdid", "cdnm", "amt01", "amt02", "amt03", "amt04", "amt05", "amt06", "amt07", "amt08"
				, "amt09", "amt10", "amt11", "amt12", "amt13", "cdgrupid"];

	var str =  "";
	
	for ( var nCnt = arrCol.length-1; nCnt > -1; nCnt-- ) 
	{
		if(utlf_isNull(ds_main_brgstincmexpspres_brgstincmexpsprescond.getColumn(0, arrCol[nCnt])) || nCnt == 1 || nCnt == 16)
		{
			grd_brgstincmexpsprescond.setFormatColProperty(nCnt, "size", 0);
		}
		else
		{
			grd_brgstincmexpsprescond.setFormatColProperty(nCnt, "size", 100);
			grd_brgstincmexpsprescond.setFormatColProperty(0, "size", 40);
			grd_brgstincmexpsprescond.setFormatColProperty(2, "size", 150);
		}
	}
	
	if ( group4.cmb_reqflag.value == "2" ) 
	{
		str = "구분^구분코드^구분";
		for ( var nCnt = 3; nCnt < arrCol.length - 2; nCnt++ ) 
		{
			str += "^"+ (parseInt(ds_main_search.getColumn(0, "fromentryy").substring(0,4)) + nCnt - 3) + "년";
		}
	}
	else
	{
		str = "구분^구분코드^구분^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^구분그룹코드";
	}
	
	var caption = str.split("^");
	for(var i = 0; i < caption.length; i++)
	{
		grd_brgstincmexpsprescond.setCellProperty("Head", i, "text", caption[i]);
	}
}

function group4_cmb_reqflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if(obj.value=='1')
	{
		group4.ipt_fromdd.visible=true;
		group4.ipt_fromentryy.visible=false;
		group4.ipt_toentryy.visible=false;
		group4.cap1.visible=false;
		group4.caption1.visible=true;
		group4.caption2.visible=false;
	}
	else
	{
		group4.ipt_fromdd.visible=false;
		group4.ipt_fromentryy.visible=true;
		group4.ipt_toentryy.visible=true;
		group4.cap1.visible=true;
		group4.caption1.visible=false;
		group4.caption2.visible=true;
	}
	fReqBrgstIncmExpsCond(); //조회 
}

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

function fExcel() 
{
	if (ds_main_brgstincmexpspres_brgstincmexpsprescond.rowcount == 0)
	{
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}
	
	grdf_exportExcel(grd_brgstincmexpsprescond, "자선회수입금지출금현황", "SheetName", "true", "", "");
}

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