YNU_JEUS/app_home/himed/xpapps/ast/dietstatsxp/xp/SMANS00100_환자식통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANS01200" position="absolute 0 0 1256 840" titletext="환자식통계" oninit="SMANS01200_oninit" onload="SMANS01200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1195 25" id="grp_tle">
          <Layouts>
            <Layout>
              <Static text="환자식통계" position="absolute 5 0 112 25" id="caption6" class="tit_1"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 13 1195 783" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Div position="absolute 5 10 1185 48" align="align:center top;" id="group1" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape position="absolute 0 1 1178 38" id="roundrect2" type="roundrectangle" anchor="default"/>
                    <Static text="기간 :" position="absolute 25 12 90 29" id="caption3" class="search_name" anchor="default"/>
                    <Shape position="absolute 1092 9 1098 31" linetype="vertical" id="line14" class="line_4" anchor="default"/>
                    <Calendar position="absolute 90 11 190 30" align="align:center middle;" id="ipt_fromdd" class="input_default" taborder="2" style="align:center middle;" anchor="default" autoselect="true"/>
                    <Calendar position="absolute 210 11 310 30" align="align:center middle;" id="ipt_todd" class="input_default" taborder="2" style="align:center middle;" anchor="default" autoselect="true"/>
                    <Static text="~" position="absolute 195 11 207 28" id="caption11" class="search_n_b" style="font:Dotum,9,bold;" anchor="default"/>
                    <Button position="absolute 1110 9 1166 31" id="btn_search" class="btn1" taborder="4" text="조회" onclick="grp_biz_group1_btn_search_onclick" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Shape position="absolute 5 51 1185 57" linetype="horizontal" id="line2" class="line_10" anchor="default"/>
              <Grid position="absolute 5 55 405 730" id="grd_mealstats" visible="false" binddataset="ds_main_patmealstats2_item" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="90"/>
                      <Column size="100"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                    </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="점심"/>
                      <Cell col="4" text="저녁"/>
                      <Cell col="5" text="계"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:left middle;" text="bind:dietlrgcls"/>
                      <Cell col="1" style="align:left middle;" text="bind:dietmdlcls"/>
                      <Cell col="2" style="align:center middle;" text="bind:breakmeal"/>
                      <Cell col="3" style="align:center middle;" text="bind:lunchmeal"/>
                      <Cell col="4" style="align:center middle;" text="bind:dinnermeal"/>
                      <Cell col="5" style="align:center middle;" text="bind:mdlsum"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Grid position="absolute 5 730 405 750" id="grd_insustats" visible="false" binddataset="ds_main_patmealstats2_item2" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="구분"/>
                      <Cell col="1" text="1"/>
                      <Cell col="2" text="2"/>
                      <Cell col="3" text="3"/>
                      <Cell col="4" text="4"/>
                      <Cell col="5" text="5"/>
                      <Cell col="6" text="6"/>
                      <Cell col="7" text="7"/>
                      <Cell col="8" text="8"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:center middle;" text="bind:dietmdlcls"/>
                      <Cell col="1" text="bind:insu1"/>
                      <Cell col="2" text="bind:insu2"/>
                      <Cell col="3" text="bind:insu3"/>
                      <Cell col="4" text="bind:insu4"/>
                      <Cell col="5" text="bind:insu5"/>
                      <Cell col="6" text="bind:insu6"/>
                      <Cell col="7" text="bind:insu7"/>
                      <Cell col="8" text="bind:insu8"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Grid position="absolute 5 750 405 770" id="grd_aebmsyst" visible="false" binddataset="ds_main_patmealstats2_item3" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="1"/>
                      <Cell col="1" text="2"/>
                      <Cell col="2" text="3"/>
                      <Cell col="3" text="4"/>
                      <Cell col="4" text="5"/>
                    </Band>
                    <Band id="body">
                      <Cell text="bind:prcpcd"/>
                      <Cell col="1" text="bind:excucdnm"/>
                      <Cell col="2" text="bind:incnt"/>
                      <Cell col="3" text="bind:outcnt"/>
                      <Cell col="4" text="bind:total"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Grid position="absolute 5 750 405 770" id="grd_aebmsyst2" visible="false" binddataset="ds_main_patmealstats2_item4" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="1"/>
                      <Cell col="1" text="2"/>
                      <Cell col="2" text="3"/>
                      <Cell col="3" text="4"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:center middle;" text="bind:prcpcd1"/>
                      <Cell col="1" text="bind:excucdnm1"/>
                      <Cell col="2" text="bind:incnt1"/>
                      <Cell col="3" text="bind:total1"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Grid id="grd_appro" taborder="1" binddataset="ds_main_patmealstats2_item5" useinputpanel="false" visible="false" position="absolute 5 710 405 730">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="10"/>
                      <Column size="10"/>
                      <Column size="10"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="1"/>
                      <Cell col="1" text="2"/>
                      <Cell col="2" text="3"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:center middle;" text="bind:a1"/>
                      <Cell col="1" text="bind:a2"/>
                      <Cell col="2" text="bind:a3"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
        <Div id="grp_biz2" taborder="1" position="absolute 2 68 1004 839"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_patmealstats_item" 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="dietlrgcls" type="STRING" size="256"/>
          <Column id="dietmdlcls" type="STRING" size="256"/>
          <Column id="breakmeal" type="STRING" size="256"/>
          <Column id="lunchmeal" type="STRING" size="256"/>
          <Column id="dinnermeal" type="STRING" size="256"/>
          <Column id="mdlsum" type="STRING" size="256"/>
          <Column id="lrgclsnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="dietlrgcls"/>
            <Col id="dietmdlcls"/>
            <Col id="breakmeal"/>
            <Col id="lunchmeal"/>
            <Col id="dinnermeal"/>
            <Col id="mdlsum"/>
            <Col id="lrgclsnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats_item2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dietmdlcls" type="STRING" size="256"/>
          <Column id="insu1" type="STRING" size="256"/>
          <Column id="insu2" type="STRING" size="256"/>
          <Column id="insu3" type="STRING" size="256"/>
          <Column id="insu4" type="STRING" size="256"/>
          <Column id="insu5" type="STRING" size="256"/>
          <Column id="insu6" type="STRING" size="256"/>
          <Column id="insu7" type="STRING" size="256"/>
          <Column id="insu8" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dietmdlcls"/>
            <Col id="insu1"/>
            <Col id="insu2"/>
            <Col id="insu3"/>
            <Col id="insu4"/>
            <Col id="insu5"/>
            <Col id="insu6"/>
            <Col id="insu7"/>
            <Col id="insu8"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats_item3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpcd" type="STRING" size="256"/>
          <Column id="excucdnm" type="STRING" size="256"/>
          <Column id="incnt" type="STRING" size="256"/>
          <Column id="outcnt" type="STRING" size="256"/>
          <Column id="total" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="prcpcd"/>
            <Col id="excucdnm"/>
            <Col id="incnt"/>
            <Col id="outcnt"/>
            <Col id="total"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats_item4" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpcd1" type="STRING" size="256"/>
          <Column id="excucdnm1" type="STRING" size="256"/>
          <Column id="incnt1" type="STRING" size="256"/>
          <Column id="total1" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="prcpcd1"/>
            <Col id="excucdnm1"/>
            <Col id="incnt1"/>
            <Col id="total1"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2_item" 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="dietlrgcls" type="STRING" size="256"/>
          <Column id="dietmdlcls" type="STRING" size="256"/>
          <Column id="breakmeal" type="STRING" size="256"/>
          <Column id="lunchmeal" type="STRING" size="256"/>
          <Column id="dinnermeal" type="STRING" size="256"/>
          <Column id="mdlsum" type="STRING" size="256"/>
          <Column id="lrgclsnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="dietlrgcls"/>
            <Col id="dietmdlcls"/>
            <Col id="breakmeal"/>
            <Col id="lunchmeal"/>
            <Col id="dinnermeal"/>
            <Col id="mdlsum"/>
            <Col id="lrgclsnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2_item2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dietmdlcls" type="STRING" size="256"/>
          <Column id="insu1" type="STRING" size="256"/>
          <Column id="insu2" type="STRING" size="256"/>
          <Column id="insu3" type="STRING" size="256"/>
          <Column id="insu4" type="STRING" size="256"/>
          <Column id="insu5" type="STRING" size="256"/>
          <Column id="insu6" type="STRING" size="256"/>
          <Column id="insu7" type="STRING" size="256"/>
          <Column id="insu8" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dietmdlcls"/>
            <Col id="insu1"/>
            <Col id="insu2"/>
            <Col id="insu3"/>
            <Col id="insu4"/>
            <Col id="insu5"/>
            <Col id="insu6"/>
            <Col id="insu7"/>
            <Col id="insu8"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2_item3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpcd" type="STRING" size="256"/>
          <Column id="excucdnm" type="STRING" size="256"/>
          <Column id="incnt" type="STRING" size="256"/>
          <Column id="outcnt" type="STRING" size="256"/>
          <Column id="total" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="prcpcd"/>
            <Col id="excucdnm"/>
            <Col id="incnt"/>
            <Col id="outcnt"/>
            <Col id="total"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2_item4" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpcd1" type="STRING" size="256"/>
          <Column id="excucdnm1" type="STRING" size="256"/>
          <Column id="incnt1" type="STRING" size="256"/>
          <Column id="total1" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="prcpcd1"/>
            <Col id="excucdnm1"/>
            <Col id="incnt1"/>
            <Col id="total1"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_data" 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"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_patmealstats_item5" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="a1" type="STRING" size="256"/>
          <Column id="a2" type="STRING" size="256"/>
          <Column id="a3" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_patmealstats2_item5" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="a1" type="STRING" size="256"/>
          <Column id="a2" type="STRING" size="256"/>
          <Column id="a3" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.group1.ipt_fromdd" propid="value" datasetid="ds_send_data" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_biz.group1.ipt_todd" propid="value" datasetid="ds_send_data" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

function SMANS01200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMANS01200_onload(obj:Form, e:LoadEventInfo)
{
	grp_biz.group1.ipt_fromdd.value = utlf_getCurrentDate();
	grp_biz.group1.ipt_todd.value 	= utlf_getCurrentDate();
	ds_main_patmealstats.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_main_patmealstats2.setColumn(0,"instcd", sysf_getUserInfo("dutplceinstcd"));
}

function grp_biz_group1_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if ( utlf_isNull(ds_send_data.getColumn(0, "fromdd")) ){
		sysf_messageBox("조회시작일자는", "I003");
		grp_biz.group1.ipt_fromdd.setFocus();
		return;
	}
	if ( utlf_isNull(ds_send_data.getColumn(0, "todd")) ){
		sysf_messageBox("조회종료일자는", "I003");
		grp_biz.group1.ipt_todd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send_data.getColumn(0, "fromdd"), "YYYYMMDD") == false){
		sysf_messageBox("조회 시작일자의 형식이", "E016");
		grp_biz.group1.ipt_fromdd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send_data.getColumn(0, "todd"), "YYYYMMDD") == false){
		sysf_messageBox("조회 종료일자의 형식이", "E016");
		grp_biz.group1.ipt_todd.setFocus();
		return;
	}
	if (ds_send_data.getColumn(0, "fromdd") > ds_send_data.getColumn(0, "todd")){
		sysf_messageBox("조회 시작일자는 종료일자 보다 클 수", "I004");
		grp_biz.group1.ipt_fromdd.setFocus();
		return;
	}
	ds_main_patmealstats2.clearData();
	ds_main_patmealstats2.addRow();
	ds_main_patmealstats.clearData();
	ds_main_patmealstats.addRow();

	var oParam = {};
    oParam.id          = "TRANS00101";
    oParam.service     = "dietstatsapp.DietStats";
    oParam.method      = "reqGetPatDietStats";
    oParam.inds        = "req=ds_send_data";
    oParam.outds       = "ds_main_patmealstats2_item=ret ds_main_patmealstats2_item2=item2 ds_main_patmealstats2_item3=item3 ds_main_patmealstats2_item4=item4 ds_main_patmealstats2_item5=item5";
    oParam.async       = false;

	tranf_submit(oParam);


	fCalculation();     //소계 및 총계 구하기
	ds_main_patmealstats_item.addColumn("fromdd", "string");
	ds_main_patmealstats_item.addColumn("todd"	, "string");
	ds_main_patmealstats_item.addColumn("instcd", "string");
	
	ds_main_patmealstats_item.setColumn(0, "fromdd"	, grp_biz.group1.ipt_fromdd.value);
	ds_main_patmealstats_item.setColumn(0, "todd"	, grp_biz.group1.ipt_todd.value);
	ds_main_patmealstats_item.setColumn(0, "instcd"	, sysf_getUserInfo("dutplceinstcd"));
	
	//미리보기출력
	var objDOM = rptf_createDOM();			
	rptf_setNodeListToDOM(objDOM, "root/main/patmealstats/item", ds_main_patmealstats_item);	// 데이터셋 1	
	rptf_setNodeListToDOM(objDOM, "root/main/patmealstats/item4", ds_main_patmealstats_item4);	// 데이터셋 2	
	rptf_setNodeListToDOM(objDOM, "root/main/patmealstats/item3", ds_main_patmealstats_item3);	// 데이터셋 3	
	rptf_setNodeListToDOM(objDOM, "root/main/patmealstats/item2", ds_main_patmealstats_item2);	// 데이터셋 4	
	rptf_setNodeListToDOM(objDOM, "root/main/patmealstats/item5", ds_main_patmealstats_item5);	// 데이터셋 5	
	
	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;														// 최상의노드 XML 스트링 추출
	
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
	rptf_exeReportPreview30(["RPANS00101"],[objParam], option, "", "grp_biz2");
}

//소계 및 총계 구하기
function fCalculation() {
	//일반식 소계 구하기
	var val1 = 0;
	var val2 = 0;
	var val3 = 0;
	var val4 = 0;
	var sum1 = 0;
	var sum2 = 0;
	var sum3 = 0;
	var sum4 = 0;
	var totsum1 = 0;
	var totsum2 = 0;
	var totsum3 = 0;
	var totsum4 = 0;
	var tsum1 = 0;
	var tsum2 = 0;
	var tsum3 = 0;
	var tsum4 = 0;
	var k = 0;
	var sdietlrgcls = "";
	var slrgclsnm = "";
	var i = 0;
	var k1 = 0;
	var k3 = 0;

	for (i = 0; i < ds_main_patmealstats2_item.rowcount; i++){
		if (i == 0){
			sdietlrgcls = ds_main_patmealstats2_item.getColumn(i, "dietlrgcls");
			slrgclsnm 	= ds_main_patmealstats2_item.getColumn(i, "lrgclsnm");
		}
		if (sdietlrgcls == ds_main_patmealstats2_item.getColumn(i, "dietlrgcls")){
			val1  = ds_main_patmealstats2_item.getColumn(i, "breakmeal");
			sum1  = parseInt(val1) + parseInt(sum1);
			val2  = ds_main_patmealstats2_item.getColumn(i, "lunchmeal");
			sum2  = parseInt(val2) + parseInt(sum2);
			val3  = ds_main_patmealstats2_item.getColumn(i, "dinnermeal");
			sum3  = parseInt(val3) + parseInt(sum3);
			val4  = ds_main_patmealstats2_item.getColumn(i, "mdlsum");
			val4  = ds_main_patmealstats2_item.getColumn(i, "mdlsum");	
			sum4  = parseInt(val4) + parseInt(sum4);
			tsum1 = parseInt(val1) + parseInt(tsum1);
			tsum2 = parseInt(val2) + parseInt(tsum2);
			tsum3 = parseInt(val3) + parseInt(tsum3);
			tsum4 = parseInt(val4) + parseInt(tsum4);
			k1 = parseInt(k1) + 1;
			
			k3 = parseInt(k3) + 1;
			if (k3 == 1){
				ds_main_patmealstats_item.clearData();
				var cnt = ds_main_patmealstats_item.rowcount;
				if(cnt==0){ 
					dsf_copyColInfo(ds_main_patmealstats_item, ds_main_patmealstats2_item);
				}
				ds_main_patmealstats_item.addRow();
				ds_main_patmealstats_item.copyRow(cnt,ds_main_patmealstats2_item,i);
			}else{
				ds_main_patmealstats_item.addRow();
				ds_main_patmealstats_item.copyRow(ds_main_patmealstats_item.rowcount-1,ds_main_patmealstats2_item,i);
			}
		}else{
			if (k1 > 1){
				//grd_mealstats.insertRow(0);
				k3 = parseInt(k3) + 1;
				dsf_makeValue(ds_main_patmealstats_item, "dietlrgcls"	, "string", sdietlrgcls	, k3-1);
				dsf_makeValue(ds_main_patmealstats_item, "dietmdlcls"	, "string", "소계"		, k3-1);
				dsf_makeValue(ds_main_patmealstats_item, "breakmeal"	, "string", sum1		, k3-1);
				dsf_makeValue(ds_main_patmealstats_item, "lunchmeal"	, "string", sum2		, k3-1);
				dsf_makeValue(ds_main_patmealstats_item, "dinnermeal"	, "string", sum3		, k3-1);
				dsf_makeValue(ds_main_patmealstats_item, "mdlsum"		, "string", sum4		, k3-1);
			}
			if (slrgclsnm != ds_main_patmealstats2_item.getColumn(i, "lrgclsnm")){
				if ( !utlf_isNull(slrgclsnm) ){
					k3 = parseInt(k3) + 1;
					dsf_makeValue(ds_main_patmealstats_item, "dietlrgcls"	, "string", slrgclsnm	, k3-1);
					dsf_makeValue(ds_main_patmealstats_item, "dietmdlcls"	, "string", ""			, k3-1);
					dsf_makeValue(ds_main_patmealstats_item, "breakmeal"	, "string", tsum1		, k3-1);
					dsf_makeValue(ds_main_patmealstats_item, "lunchmeal"	, "string", tsum2		, k3-1);
					dsf_makeValue(ds_main_patmealstats_item, "dinnermeal"	, "string", tsum3		, k3-1);
					dsf_makeValue(ds_main_patmealstats_item, "mdlsum"		, "string", tsum4		, k3-1);
					
					val1 	= ds_main_patmealstats2_item.getColumn(i, "breakmeal");
					tsum1 	= parseInt(val1);
					val2 	= ds_main_patmealstats2_item.getColumn(i, "lunchmeal");
					tsum2 	= parseInt(val2);
					val3 	= ds_main_patmealstats2_item.getColumn(i, "dinnermeal");
					tsum3 	= parseInt(val3);
					val4 	= ds_main_patmealstats2_item.getColumn(i, "mdlsum");
					tsum4 	= parseInt(val4);
				}
				slrgclsnm = ds_main_patmealstats2_item.getColumn(i, "lrgclsnm");
			}
			sum1 = 0;	sum2 = 0; sum3 = 0; sum4 = 0;
			sdietlrgcls = ds_main_patmealstats2_item.getColumn(i, "dietlrgcls");
			val1 = ds_main_patmealstats2_item.getColumn(i, "breakmeal");
			sum1 = parseInt(val1);
			val2 = ds_main_patmealstats2_item.getColumn(i, "lunchmeal");
			sum2 = parseInt(val2);
			val3 = ds_main_patmealstats2_item.getColumn(i, "dinnermeal");
			sum3 = parseInt(val3);
			val4 = ds_main_patmealstats2_item.getColumn(i, "mdlsum");
			sum4 = parseInt(val4);
			tsum1 = parseInt(val1) + parseInt(tsum1);
			tsum2 = parseInt(val2) + parseInt(tsum2);
			tsum3 = parseInt(val3) + parseInt(tsum3);
			tsum4 = parseInt(val4) + parseInt(tsum4);
			k1 = 1;
			
			k3 = parseInt(k3) + 1;
			ds_main_patmealstats_item.addRow();
			ds_main_patmealstats_item.copyRow(ds_main_patmealstats_item.rowcount-1,ds_main_patmealstats2_item,i);
		}
		totsum1 = parseInt(val1) + parseInt(totsum1);
		totsum2 = parseInt(val2) + parseInt(totsum2);
		totsum3 = parseInt(val3) + parseInt(totsum3);
		totsum4 = parseInt(val4) + parseInt(totsum4);
		
		trace("i : " + i + "   val1    : " + val1);
		trace("i : " + i + "   totsum1 : " + totsum1);
	}
	trace("totsum1 : " + totsum1);
	trace("totsum2 : " + totsum2);
	trace("totsum3 : " + totsum3);
	trace("totsum4 : " + totsum4);
	if (k1 > 1){
		k3 = parseInt(k3) + 1;
		dsf_makeValue(ds_main_patmealstats_item, "dietlrgcls"	, "string", sdietlrgcls	, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "dietmdlcls"	, "string", "소계"		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "breakmeal"	, "string", sum1		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "lunchmeal"	, "string", sum2		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "dinnermeal"	, "string", sum3		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "mdlsum"		, "string", sum4		, k3-1);

	}
	if ( !utlf_isNull(slrgclsnm) ){
		k3 = parseInt(k3) + 1;
		
		dsf_makeValue(ds_main_patmealstats_item, "dietlrgcls"	, "string", slrgclsnm	, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "dietmdlcls"	, "string", ""			, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "breakmeal"	, "string", tsum1		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "lunchmeal"	, "string", tsum2		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "dinnermeal"	, "string", tsum3		, k3-1);
		dsf_makeValue(ds_main_patmealstats_item, "mdlsum"		, "string", tsum4		, k3-1);
					
		val1 	= ds_main_patmealstats2_item.getColumn(i, "breakmeal");
		tsum1 	= parseInt(val1);
		val2 	= ds_main_patmealstats2_item.getColumn(i, "lunchmeal");
		tsum2 	= parseInt(val2);
		val3 	= ds_main_patmealstats2_item.getColumn(i, "dinnermeal");
		tsum3 	= parseInt(val3);
		val4	= ds_main_patmealstats2_item.getColumn(i, "mdlsum");
		tsum4 	= parseInt(val4);
	}
	//총계 구하기
	//grd_mealstats.insertRow(0);
	k3 = parseInt(k3) + 1;
	
	dsf_makeValue(ds_main_patmealstats_item, "dietlrgcls"	, "string", "총계"	, k3-1);
	dsf_makeValue(ds_main_patmealstats_item, "breakmeal"	, "string", totsum1	, k3-1);
	dsf_makeValue(ds_main_patmealstats_item, "lunchmeal"	, "string", totsum2	, k3-1);
	dsf_makeValue(ds_main_patmealstats_item, "dinnermeal"	, "string", totsum3	, k3-1);
	dsf_makeValue(ds_main_patmealstats_item, "mdlsum"		, "string", totsum4	, k3-1);

	//보험종류별 계 구하기
	var val51 = 0;
	var val52 = 0;
	var val53 = 0;
	var val54 = 0;
	var val55 = 0;
	var val56 = 0;
	var val57 = 0;
	var val58 = 0;
	var sum51 = 0;
	var sum52 = 0;
	var sum53 = 0;
	var sum54 = 0;
	var sum55 = 0;
	var sum56 = 0;
	var sum57 = 0;
	var sum58 = 0;

	var kk = parseInt(ds_main_patmealstats2_item2.rowcount);
	var k5 = 0;
	for (var i = 0; i < kk;  i++) {
		k5 = parseInt(k5) + 1;
		
		if (k5 == 1){
			ds_main_patmealstats_item2.clearData();
			var cnt = ds_main_patmealstats_item2.rowcount;
			if(cnt==0){ 
				dsf_copyColInfo(ds_main_patmealstats_item2, ds_main_patmealstats2_item2);
			}
			ds_main_patmealstats_item2.addRow();
			ds_main_patmealstats_item2.copyRow(cnt,ds_main_patmealstats2_item2,i);

		}else{
			ds_main_patmealstats_item2.addRow();
			ds_main_patmealstats_item2.copyRow(ds_main_patmealstats_item2.rowcount-1,ds_main_patmealstats2_item2,i);
		}
		val51 = ds_main_patmealstats2_item2.getColumn(i, "insu1");
		sum51 = parseInt(val51) + parseInt(sum51);
		val52 = ds_main_patmealstats2_item2.getColumn(i, "insu2");
		sum52 = parseInt(val52) + parseInt(sum52);
		val53 = ds_main_patmealstats2_item2.getColumn(i, "insu3");
		sum53 = parseInt(val53) + parseInt(sum53);
		val54 = ds_main_patmealstats2_item2.getColumn(i, "insu4");
		sum54 = parseInt(val54) + parseInt(sum54);
		val55 = ds_main_patmealstats2_item2.getColumn(i, "insu5");
		sum55 = parseInt(val55) + parseInt(sum55);
		val56 = ds_main_patmealstats2_item2.getColumn(i, "insu6");
		sum56 = parseInt(val56) + parseInt(sum56);
		val57 = ds_main_patmealstats2_item2.getColumn(i, "insu7");
		sum57 = parseInt(val57) + parseInt(sum57);
		val58 = ds_main_patmealstats2_item2.getColumn(i, "insu8");
		sum58 = parseInt(val58) + parseInt(sum58);
	}
	k5 = parseInt(k5) + 1;
	
	dsf_makeValue(ds_main_patmealstats_item2,"dietmdlcls"	,"string", "총계", k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu1"		,"string",  sum51 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu2"		,"string",  sum52 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu3"		,"string",  sum53 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu4"		,"string",  sum54 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu5"		,"string",  sum55 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu6"		,"string",  sum56 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu7"		,"string",  sum57 , k5-1);
	dsf_makeValue(ds_main_patmealstats_item2,"insu8"		,"string",  sum58 , k5-1);
	
	//과내검사 통계 구하기
	var val21 = 0;
	var val22 = 0;
	var val23 = 0;
	var sum21 = 0;
	var sum22 = 0;
	var sum23 = 0;

	var rr = parseInt(ds_main_patmealstats2_item3.rowcount);
	var k2 = 0;
	for (var i = 0; i <  rr;  i++) {
		k2 = parseInt(k2) + 1;
		
		if (k2 == 1){//
			ds_main_patmealstats_item3.clearData();
			var cnt = ds_main_patmealstats_item3.rowcount;
			if(cnt==0){ 
				dsf_copyColInfo(ds_main_patmealstats_item3, ds_main_patmealstats2_item3);
			}
			ds_main_patmealstats_item3.addRow();
			ds_main_patmealstats_item3.copyRow(cnt,ds_main_patmealstats2_item3,i);
						
		}else{
			ds_main_patmealstats_item3.addRow();
			ds_main_patmealstats_item3.copyRow(ds_main_patmealstats_item3.rowcount-1,ds_main_patmealstats2_item3,i);
				
		}
		 val21 = ds_main_patmealstats2_item3.getColumn(i, "incnt") ;
		 sum21 = parseInt(val21) + parseInt(sum21);
		 val22 = ds_main_patmealstats2_item3.getColumn(i, "outcnt") ;
		 sum22 = parseInt(val22) + parseInt(sum22);
		 val23 = ds_main_patmealstats2_item3.getColumn(i, "total");
		 sum23 = parseInt(val23) + parseInt(sum23);
	}
	k2 = parseInt(k2) + 1;
	dsf_makeValue(ds_main_patmealstats_item3,"prcpcd"		,"string",  "총계" , k2-1);
	dsf_makeValue(ds_main_patmealstats_item3,"incnt"		,"string",  sum21 	, k2-1);
	dsf_makeValue(ds_main_patmealstats_item3,"outcnt"		,"string",  sum22 	, k2-1);
	dsf_makeValue(ds_main_patmealstats_item3,"total"		,"string",  sum23 	, k2-1);

	//산모야식 통계 구하기
	var val31 = 0;
	var val32 = 0;
	var val33 = 0;
	var sum31 = 0;
	var sum32 = 0;
	var sum33 = 0;

	var jj = parseInt(ds_main_patmealstats2_item4.rowcount);
	var j2 = 0;
	for (var i = 0; i <  jj;  i++) {
		j2 = parseInt(j2) + 1;

		if (j2 == 1){
			ds_main_patmealstats_item4.clearData();
			var cnt = ds_main_patmealstats_item4.rowcount;
			if(cnt==0){ 
				dsf_copyColInfo(ds_main_patmealstats_item4, ds_main_patmealstats2_item4);
			}
			ds_main_patmealstats_item4.addRow();
			ds_main_patmealstats_item4.copyRow(cnt,ds_main_patmealstats2_item4,i);			
		}else{
			ds_main_patmealstats_item4.addRow();
			ds_main_patmealstats_item4.copyRow(ds_main_patmealstats_item4.rowcount-1,ds_main_patmealstats2_item4,i);			
		}
		 val31 = ds_main_patmealstats2_item4.getColumn(i, "incnt1");
		 sum31 = parseInt(val31) + parseInt(sum31);
		 val33 = ds_main_patmealstats2_item4.getColumn(i, "total1");
		 sum33 = parseInt(val33) + parseInt(sum33);
	}
	j2 = parseInt(j2) + 1;
	dsf_makeValue(ds_main_patmealstats_item4,"prcpcd1"		,"string",  "총계" , j2-1);
	dsf_makeValue(ds_main_patmealstats_item4,"incnt1"		,"string",  sum31 	, j2-1);
	dsf_makeValue(ds_main_patmealstats_item4,"total1"		,"string",  sum33 	, j2-1);
	
	ds_main_patmealstats_item5.addColumn("a1", "string");
	ds_main_patmealstats_item5.addColumn("a2", "string");
	ds_main_patmealstats_item5.addColumn("a3", "string");
	
	ds_main_patmealstats_item5.setColumn(0, "a1", ds_main_patmealstats2_item5.getColumn(0, "a1"));
	ds_main_patmealstats_item5.setColumn(0, "a2", ds_main_patmealstats2_item5.getColumn(0, "a2"));
	ds_main_patmealstats_item5.setColumn(0, "a3", ds_main_patmealstats2_item5.getColumn(0, "a3"));	
}	]]></Script>
  </Form>
</FDL>