YNU_JEUS/app_home/himed/xpapps/sts/stscmcnwxp/xp/SMSDT06800_사회사업수가실적.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSDT06800" position="absolute 0 0 1201 790" titletext="사회사업 수가실적" oninit="SMSDT06800_oninit" onload="SMSDT06800_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="사회사업 수가실적" class="tit_1" position="absolute 0 0 221 25"/>
        <Static id="caption21" text="사회사업 수가실적" class="tit_2" position="absolute 0 78 266 100"/>
        <Shape id="line1" class="line_10" position="absolute 0 93 1195 102" anchor="left top right"/>
        <Div id="group4" anchor="left top right" taborder="2" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Button id="button2" taborder="1" text="조회" class="btn1" position="absolute 1123 9 1179 31" anchor="top right" onclick="group4_button2_onclick"/>
              <Shape id="line2" linetype="vertical" position="absolute 1110 9 1116 31" anchor="top right"/>
              <Static id="caption1" text="사업년도 :" class="search_name" position="absolute 20 11 104 28"/>
              <Calendar id="ipt_entryy" taborder="2" autoselect="true" dateformat="yyyy" editformat="yyyy" class="input_search" position="absolute 120 10 218 29" mask="yyyy" onchanged="group4_ipt_entryy_onchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excel" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 75 1195 94" anchor="top right" onclick="btn_excel_onclick"/>
        <Grid id="grd_calclist" class="datagrid2" taborder="4" binddataset="ds_main_calcinfo_calclist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 99 1195 758" anchor="all" oncellclick="grd_calclist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="190" band="left"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="47" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="구분" taborder="undefined"/>
                <Cell col="1" colspan="2" text="1월" taborder="undefined"/>
                <Cell col="3" colspan="2" text="2월" taborder="undefined"/>
                <Cell col="5" colspan="2" text="3월" taborder="undefined"/>
                <Cell col="7" colspan="2" text="4월" taborder="undefined"/>
                <Cell col="9" colspan="2" text="5월" taborder="undefined"/>
                <Cell col="11" colspan="2" text="6월" taborder="undefined"/>
                <Cell col="13" colspan="2" text="7월" taborder="undefined"/>
                <Cell col="15" colspan="2" text="8월" taborder="undefined"/>
                <Cell col="17" colspan="2" text="9월" taborder="undefined"/>
                <Cell col="19" colspan="2" text="10월" taborder="undefined"/>
                <Cell col="21" colspan="2" text="11월" taborder="undefined"/>
                <Cell col="23" colspan="2" text="12월" taborder="undefined"/>
                <Cell col="25" colspan="2" text="합계" taborder="undefined"/>
                <Cell col="27" colspan="2" text="   전기간실적" taborder="undefined"/>
                <Cell col="29" colspan="2" text="전기간대비실적비교" taborder="undefined"/>
                <Cell row="1" col="1" text="건수" taborder="undefined"/>
                <Cell row="1" col="2" text="금액" taborder="undefined"/>
                <Cell row="1" col="3" text="건수"/>
                <Cell row="1" col="4" text="금액"/>
                <Cell row="1" col="5" text="건수"/>
                <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="건수"/>
                <Cell row="1" col="12" text="금액"/>
                <Cell row="1" col="13" text="건수"/>
                <Cell row="1" col="14" text="금액"/>
                <Cell row="1" col="15" text="건수"/>
                <Cell row="1" col="16" text="금액"/>
                <Cell row="1" col="17" text="건수"/>
                <Cell row="1" col="18" text="금액"/>
                <Cell row="1" col="19" text="건수"/>
                <Cell row="1" col="20" text="금액"/>
                <Cell row="1" col="21" text="건수"/>
                <Cell row="1" col="22" text="금액"/>
                <Cell row="1" col="23" text="건수"/>
                <Cell row="1" col="24" text="금액"/>
                <Cell row="1" col="25" text="건수"/>
                <Cell row="1" col="26" text="금액"/>
                <Cell row="1" col="27" text="건수"/>
                <Cell row="1" col="28" text="금액"/>
                <Cell row="1" col="29" text="건수"/>
                <Cell row="1" col="30" text="금액"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="bind:cdnm"/>
                <Cell col="1" text="bind:cnt1"/>
                <Cell col="2" displaytype="number" style="align:center middle;" text="bind:psnno1"/>
                <Cell col="3" text="bind:cnt2"/>
                <Cell col="4" displaytype="number" style="align:center middle;" text="bind:psnno2"/>
                <Cell col="5" text="bind:cnt3"/>
                <Cell col="6" displaytype="number" style="align:center middle;" text="bind:psnno3"/>
                <Cell col="7" text="bind:cnt4"/>
                <Cell col="8" displaytype="number" style="align:center middle;" text="bind:psnno4"/>
                <Cell col="9" text="bind:cnt5"/>
                <Cell col="10" displaytype="number" style="align:center middle;" text="bind:psnno5"/>
                <Cell col="11" text="bind:cnt6"/>
                <Cell col="12" displaytype="number" style="align:center middle;" text="bind:psnno6"/>
                <Cell col="13" text="bind:cnt7"/>
                <Cell col="14" displaytype="number" style="align:center middle;" text="bind:psnno7"/>
                <Cell col="15" text="bind:cnt8"/>
                <Cell col="16" displaytype="number" style="align:center middle;" text="bind:psnno8"/>
                <Cell col="17" text="bind:cnt9"/>
                <Cell col="18" displaytype="number" style="align:center middle;" text="bind:psnno9"/>
                <Cell col="19" text="bind:cnt10"/>
                <Cell col="20" displaytype="number" style="align:center middle;" text="bind:psnno10"/>
                <Cell col="21" text="bind:cnt11"/>
                <Cell col="22" displaytype="number" style="align:center middle;" text="bind:psnno11"/>
                <Cell col="23" text="bind:cnt12"/>
                <Cell col="24" displaytype="number" style="align:center middle;" text="bind:psnno12"/>
                <Cell col="25" text="bind:totcnt"/>
                <Cell col="26" displaytype="number" style="align:center middle;" text="bind:totpsnno"/>
                <Cell col="27" text="bind:bfcnt"/>
                <Cell col="28" displaytype="number" style="align:center middle;" text="bind:bfpsnno"/>
                <Cell col="29" text="bind:cntrate" expr="expr:parseInt(totcnt)-parseInt(bfcnt)"/>
                <Cell col="30" displaytype="number" style="align:center middle;" text="bind:psnnorate" expr="expr:parseInt(totpsnno)-parseInt(bfpsnno)"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_search0" taborder="5" text="초기화" class="btn4" position="absolute 1127 764 1195 786" onclick="btn_search0_onclick" anchor="right bottom"/>
        <Shape id="line37" class="line_6" position="absolute -1 760 1194 766" anchor="left right bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="entryy" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_calcinfo_calclist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dispseq" type="STRING" size="256" sumtext="dispseq"/>
          <Column id="cdnm" type="STRING" size="256" sumtext="cdnm"/>
          <Column id="cnt3" type="STRING" size="256" sumtext="3월금액"/>
          <Column id="psnno3" type="STRING" size="256" sumtext="3월인원수"/>
          <Column id="cnt4" type="STRING" size="256" sumtext="4월금액"/>
          <Column id="psnno4" type="STRING" size="256" sumtext="4월인원수"/>
          <Column id="cnt5" type="STRING" size="256" sumtext="5월금액"/>
          <Column id="psnno5" type="STRING" size="256" sumtext="5월인원수"/>
          <Column id="cnt6" type="STRING" size="256" sumtext="6월금액"/>
          <Column id="psnno6" type="STRING" size="256" sumtext="6월인원수"/>
          <Column id="cnt7" type="STRING" size="256" sumtext="7월금액"/>
          <Column id="psnno7" type="STRING" size="256" sumtext="7월인원수"/>
          <Column id="cnt8" type="STRING" size="256" sumtext="8월금액"/>
          <Column id="psnno8" type="STRING" size="256" sumtext="8월인원수"/>
          <Column id="cnt9" type="STRING" size="256" sumtext="9월금액"/>
          <Column id="psnno9" type="STRING" size="256" sumtext="9월인원수"/>
          <Column id="cnt10" type="STRING" size="256" sumtext="10월금액"/>
          <Column id="psnno10" type="STRING" size="256" sumtext="10월인원수"/>
          <Column id="cnt11" type="STRING" size="256" sumtext="11월금액"/>
          <Column id="psnno11" type="STRING" size="256" sumtext="11월인원수"/>
          <Column id="cnt12" type="STRING" size="256" sumtext="12월금액"/>
          <Column id="psnno12" type="STRING" size="256" sumtext="12월인원수"/>
          <Column id="cnt1" type="STRING" size="256" sumtext="1월금액"/>
          <Column id="psnno1" type="STRING" size="256" sumtext="1월인원수"/>
          <Column id="cnt2" type="STRING" size="256" sumtext="2월금액"/>
          <Column id="psnno2" type="STRING" size="256" sumtext="2월인원수"/>
          <Column id="totcnt" type="STRING" size="256" sumtext="합계금액"/>
          <Column id="totpsnno" type="STRING" size="256" sumtext="합계인원수"/>
          <Column id="bfcnt" type="STRING" size="256" sumtext="전월실적금액"/>
          <Column id="bfpsnno" type="STRING" size="256" sumtext="전월실적인원수"/>
          <Column id="cntrate" type="STRING" size="256" sumtext="전월대비실적비교금액"/>
          <Column id="psnnorate" type="STRING" size="256" sumtext="전월대비실적비교인원수"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.ipt_entryy" propid="value" datasetid="ds_main_cond" columnid="entryy"/>
    </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 SMSDT06800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMSDT06800_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_calclist);
	fInit();
}

function fInit()
{
	ds_main_calcinfo_calclist.clearData();
	
	var currentDate = utlf_getCurrentDate();
	var currentYear = String(currentDate).substring(0, 4); 
	
	ds_main_cond.setColumn(0, "entryy"		,currentYear);
	group4.ipt_entryy.visible    = true;
}		

function group4_ipt_entryy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_cond.setColumn(0, "entryy"		,String(obj.value).substr(0,4));
}

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

function fExcel()
{
	if (ds_main_calcinfo_calclist.rowcount == 0)
	{
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}
	
	grdf_exportExcel(grd_calclist, "사회사업 수가실적실적", "SheetName", "true", "", "");
}

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

function fGetCalcInfo()
{
	var entryy   = ds_main_cond.getColumn(0, "entryy");
	if(utlf_isNull(entryy))
	{
		sysf_messageBox("조회년도를","C001" );
		ds_main_calcinfo_calclist.clearData();
		return;
	}
		
	group4.ipt_entryy.visible 	= true;
	
	var oParam = {};
		oParam.id          = "TRSDT06801";
		oParam.service     = "stscmcnwapp.SoclEndStats";
		oParam.method      = "reqGetCalcStat";
		oParam.inds        = "req=ds_main_cond";
		oParam.outds       = "ds_main_calcinfo_calclist=calclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRSDT06801";

	tranf_submit(oParam);
	
	fStat();
}

function fStat()
{
	if(ds_main_calcinfo_calclist.rowcount == 0)
	{
		return;
	}
	
	if(ds_main_calcinfo_calclist.rowcount > 0)
	{
		var sStat = 0;
		var insRow = ds_main_calcinfo_calclist.addRow();
		
		ds_main_calcinfo_calclist.setColumn(insRow, "cdnm", "전년대비실적비교");
		
		for(var i = 2; i <= grd_calclist.getBindCellIndex("Body", "totpsnno"); i++)
		{
			var bfResult = eval(ds_main_calcinfo_calclist.getColumn(insRow-1 , i));
			var sSum = eval(ds_main_calcinfo_calclist.getColumn(insRow-2, i));		
																							
			sStat = eval(sSum)- eval(bfResult);
			ds_main_calcinfo_calclist.setColumn(insRow, i , eval(sStat));					
		}
		
		ds_main_calcinfo_calclist.setColumn(insRow-1, "cntrate", "");
		ds_main_calcinfo_calclist.setColumn(insRow, "cntrate", "");
		ds_main_calcinfo_calclist.setColumn(insRow-1, "psnnorate", "");
		ds_main_calcinfo_calclist.setColumn(insRow, "psnnorate", "");
	}
}


function grd_calclist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	trace(e.cell)
}

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