YNU_JEUS/app_home/himed/xpapps/ast/dietstatsxp/xp/SMANS00700_처방코드중분류별통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANS00700" position="absolute 0 0 1211 735" titletext="영양팀 중분류별 통계" oninit="SMANS00700_oninit" onload="SMANS00700_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1195 25" id="grp_tle">
          <Layouts>
            <Layout>
              <Static text="영양팀 중분류별 통계" position="absolute 0 0 171 25" id="caption6" class="tit_1"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 13 1203 719" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Static text="중분류별 통계" position="absolute 0 50 200 66" id="caption1" class="tit_2" anchor="default"/>
              <Shape position="absolute 0 67 1183 73" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
              <Div position="absolute 0 10 1195 42" align="align:center top;" id="grp_sea" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape position="absolute 0 2 1185 32" id="roundrect1" type="roundrectangle" anchor="default"/>
                    <Static text="조회기간 :" position="absolute 247 9 318 26" id="caption2" class="search_name" anchor="default"/>
                    <Shape position="absolute 1107 6 1113 28" linetype="vertical" id="line13" class="line_4" anchor="default"/>
                    <Button position="absolute 1120 6 1176 28" id="btn_sea" class="btn1" taborder="4" text="조회" anchor="default" onclick="grp_biz_grp_sea_btn_sea_onclick"/>
                    <Calendar position="absolute 425 8 510 27" id="ipt_todd" class="input_default" taborder="2" anchor="default" autoselect="true"/>
                    <Static text="~" position="absolute 410 9 422 26" id="caption5" class="search_no_b" anchor="default"/>
                    <Calendar position="absolute 324 8 409 27" id="ipt_fromdd" class="input_default" taborder="1" anchor="default" autoselect="true" autoskip="true"/>
                    <Static text="중분류 :" position="absolute 557 9 615 26" id="caption3" class="search_name" visible="true" anchor="default"/>
                    <Combo position="absolute 621 8 721 27" id="combo1" visible="true" innerdataset="@ds_init_code_dietcls" datacolumn="mdlnm" codecolumn="mdlcd" anchor="default"/>
                    <Radio id="rdo_srchgubun" taborder="5" tabstop="false" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="swt_nutrsrchrslt_case1_grp_rdo_patflag1_onitemchanged" position="absolute 98 8 209 28" style="textpadding:0 3 0 3;" columncount="2">
                      <Dataset id="innerdataset">
                        <ColumnInfo>
                          <Column id="codecolumn" size="256"/>
                          <Column id="datacolumn" size="256"/>
                        </ColumnInfo>
                        <Rows>
                          <Row>
                            <Col id="codecolumn">A</Col>
                            <Col id="datacolumn">집계</Col>
                          </Row>
                          <Row>
                            <Col id="codecolumn">P</Col>
                            <Col id="datacolumn">처방</Col>
                          </Row>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Static id="caption00" text="조회구분 :" class="search_name" position="absolute 15 9 86 26"/>
                  </Layout>
                </Layouts>
              </Div>
              <Button position="absolute 1110 45 1184 64" id="btn_excsave" class="btn7" text="엑셀저장" onclick="grp_biz_btn_excsave_onclick" anchor="default"/>
              <Grid position="absolute 0 71 1183 695" id="grd_mealprcpcd" class="datagrid2" binddataset="ds_main_list_item" selecttype="multiarea" cellsizingtype="both" extendsizetype="row" cellsizebandtype="allband" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="30" band="left"/>
                      <Column size="0" band="left"/>
                      <Column size="100" band="left"/>
                      <Column size="70" band="left"/>
                      <Column size="100" band="left"/>
                      <Column size="200" band="left"/>
                      <Column size="100" band="left"/>
                      <Column size="100" band="left"/>
                      <Column size="100"/>
                      <Column size="100"/>
                    </Columns>
                    <Rows>
                      <Row size="33" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="대분류"/>
                      <Cell col="2" text="중분류"/>
                      <Cell col="3" text="소분류"/>
                      <Cell col="4" text="식사코드"/>
                      <Cell col="5" text="식사명"/>
                      <Cell col="6" text="조식"/>
                      <Cell col="7" text="중식"/>
                      <Cell col="8" text="석식"/>
                      <Cell col="9" text="합계"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" text="expr:currow + 1"/>
                      <Cell col="1" displaytype="combo" edittype="none" style="align:center middle;" text="bind:dietlrgcd" combodataset="ds_init_basecode_dietlrg_A0046" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                      <Cell col="2" displaytype="combo" edittype="none" style="align:center middle;" text="bind:dietmdlcd" combodataset="ds_init_code_dietcls" combocodecol="mdlcd" combodatacol="mdlnm" enable="false"/>
                      <Cell col="3" displaytype="combo" edittype="none" style="align:center middle;" text="bind:dietsmlcd" combodataset="ds_init_basecode_dietsml_A0048" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                      <Cell col="4" style="align:center middle;" text="bind:dietcd" enable="false"/>
                      <Cell col="5" style="align:center middle;" text="bind:dietnm" enable="false"/>
                      <Cell col="6" displaytype="text" style="align:center middle;" text="bind:breakmeal" enable="false"/>
                      <Cell col="7" displaytype="text" style="align:center middle;" text="bind:lunchmeal" enable="false"/>
                      <Cell col="8" displaytype="text" style="align:center middle;" text="bind:dinnermeal" enable="false"/>
                      <Cell col="9" displaytype="text" style="align:center middle;" text="bind:dietsum" enable="false"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dietlrgcd" type="STRING" size="256"/>
          <Column id="dietmdlcd" type="STRING" size="256"/>
          <Column id="dietsmlcd" type="STRING" size="256"/>
          <Column id="dietcd" type="STRING" size="256"/>
          <Column id="dietnm" 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="dietsum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dietlrgcd"/>
            <Col id="dietmdlcd"/>
            <Col id="dietsmlcd"/>
            <Col id="dietcd"/>
            <Col id="dietnm"/>
            <Col id="breakmeal"/>
            <Col id="lunchmeal"/>
            <Col id="dinnermeal"/>
            <Col id="dietsum"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchgubun" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="dietmdlcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_globalinstance_instance1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_basecode_dietlrg_A0046" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_basecode_dietsml_A0048" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_basecode_inputcond_A0053" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_basecode_endflag_A0054" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_basecode_mealflag_A0055" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_code_dietcls" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="lrgcd" type="STRING" size="256"/>
          <Column id="lrgnm" type="STRING" size="256"/>
          <Column id="mdlcd" type="STRING" size="256"/>
          <Column id="mdlnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="lrgcd"/>
            <Col id="lrgnm"/>
            <Col id="mdlcd"/>
            <Col id="mdlnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_code_etcdietcls" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_ward_dept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="depthngnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="grp_biz.grp_sea.combo1" propid="value" datasetid="ds_send" columnid="dietmdlcd"/>
      <BindItem id="item12" compid="grp_biz.grp_sea.rdo_srchgubun" propid="value" datasetid="ds_send" columnid="srchgubun"/>
    </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";
include "ast_examcurexp::AEZ0001.xjs";

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

function SMANS00700_onload(obj:Form, e:LoadEventInfo)
{
	lf_aezfSetSuppDeptcd();	// globalinstance 셋팅하기

	var arrParam 	= [{dsNm: "ds_init_basecode_dietlrg_A0046"	, cdGrpId: "A0046"}
					  ,{dsNm: "ds_init_basecode_dietsml_A0048"	, cdGrpId: "A0048"}
					  ,{dsNm: "ds_init_basecode_inputcond_A0053", cdGrpId: "A0053"}
					  ,{dsNm: "ds_init_basecode_endflag_A0054"	, cdGrpId: "A0054"}
					  ,{dsNm: "ds_init_basecode_mealflag_A0055"	, cdGrpId: "A0055"}
					  ]
	appf_getCodeList(arrParam);
	
	// 식사/기타 분류코드 조회
	var oParam = {};
    oParam.id          = "TRANB00203";
    oParam.service     = "dietbaseapp.Dietbase";
    oParam.method      = "reqGetDietClsCd";
    oParam.inds        = "req=ds_send_req";
    oParam.outds       = "ds_init_code_dietcls=dietcls ds_init_code_etcdietcls=etcdietcls";
    oParam.async       = false;

	tranf_submit(oParam);
	
	frmf_addComboItem( "grp_biz.grp_sea.combo1", " ", "", "above" );

	//var fromdd = getCurrentDate().toDate().getAddDate(-1, "D").getDateFormat("YYYYMMDD");
	//var todd = getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
	var fromdd 	= utlf_getCurrentDate();		// 적용일자 현재일자 셋팅
	var todd 	= utlf_getCurrentDate();		// 적용일자 현재일자 셋팅
	
	ds_main_list_item.clearData();
	ds_send.setColumn(0, "srchgubun" , "A");
	ds_send.setColumn(0, "fromdd"	 , fromdd);
	ds_send.setColumn(0, "todd"		 , todd);
}

function grp_biz_grp_sea_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	if ( utlf_isNull(ds_send.getColumn(0, "fromdd"))){
		sysf_messageBox("조회시작일자는", "I003");
		grp_biz.grp_sea.ipt_fromdd.setFocus();
		return;
	}
	if ( utlf_isNull(ds_send.getColumn(0, "todd"))){
		sysf_messageBox("조회종료일자는", "I003");
		grp_biz.grp_sea.ipt_todd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send.getColumn(0, "fromdd"), "YYYYMMDD") == false){
		sysf_messageBox("조회 시작일자의 형식이", "E016");
		grp_biz.grp_sea.ipt_fromdd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send.getColumn(0, "todd"), "YYYYMMDD") == false){
		sysf_messageBox("조회 종료일자의 형식이", "E016");
		grp_biz.grp_sea.ipt_todd.setFocus();
		return;
	}
	if (ds_send.getColumn(0, "fromdd") > ds_send.getColumn(0, "todd")){
		sysf_messageBox("조회 시작일자는 종료일자 보다 클 수", "I004");
		grp_biz.grp_sea.ipt_fromdd.setFocus();
		return;
	}
	
	var oParam = {};
    oParam.id          = "TRANS00701";
    oParam.service     = "dietstatsapp.DietStats";
    oParam.method      = "reqGetDietCodeStats";
    oParam.inds        = "req=ds_send";
    oParam.outds       = "ds_main_list_item=ret";
    oParam.async       = false;

	tranf_submit(oParam);

}

function grp_biz_btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_mealprcpcd, "", "sheetname1" , true, "" , "" , true);	
}
]]></Script>
  </Form>
</FDL>