YNU_JEUS/app_home/himed/xpapps/ast/dietxp/xp/SMANT00250_멸균식간식및음료수통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANT00250" position="absolute 0 0 1215 731" titletext="멸균식 간식 및 음료수 통계" oninit="SMANT00250_oninit" onload="SMANT00250_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1195 25" id="group1">
          <Layouts>
            <Layout>
              <Static text="멸균식 간식 및 음료수 통계" position="absolute 0 0 204 25" id="caption6" class="tit_1"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 15 1195 719" id="group3" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Div position="absolute 0 10 1195 65" align="align:center top;" id="group2" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape position="absolute 0 10 1194 42" id="roundrect1" type="roundrectangle" anchor="default"/>
                    <Static text="일자 :" position="absolute 15 17 101 34" id="caption1" class="search_name" anchor="default"/>
                    <Calendar position="absolute 79 16 184 35" id="ipt_dietdd" class="input_essential" anchor="default" autoselect="true" autoskip="true"/>
                    <Button position="absolute 1118 15 1174 37" id="btn_search" class="btn1" text="조회" onclick="group3_group2_btn_search_onclick" anchor="default"/>
                    <Shape position="absolute 1096 15 1102 37" linetype="vertical" id="line1" anchor="default"/>
                    <Radio position="absolute 355 16 505 36" id="rdo_meal" class="radio_search" columncount="3" rowcount="1" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
                      <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>
                          <Row>
                            <Col id="codecolumn">3</Col>
                            <Col id="datacolumn">석식</Col>
                          </Row>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Static text="끼니구분 :" position="absolute 265 17 356 34" id="caption5" class="search_name" anchor="default"/>
                    <Button position="absolute 188 18 201 33" id="btn_before" class="icon_pre" text="" onclick="group3_group2_btn_before_onclick" anchor="default"/>
                    <Button position="absolute 201 18 214 33" id="button1" class="icon_next" text="" onclick="group3_group2_button1_onclick" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Button position="absolute 1143 67 1195 86" id="btn_excel" class="btn7" text="엑셀" onclick="group3_btn_excel_onclick" anchor="default"/>
              <Grid position="absolute 0 93 1195 694" align="align:center middle;" id="grd_data" binddataset="ds_main_bmealstatslist" anchor="default" cellsizingtype="both" extendsizetype="row">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="0"/>
                      <Column size="100"/>
                      <Column size="210"/>
                      <Column size="220"/>
                      <Column size="100"/>
                    </Columns>
                    <Rows>
                      <Row size="24" 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="건수"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" text="expr:currow + 1"/>
                      <Cell col="1" text="bind:iptdt" mask="####-##-## ##:##"/>
                      <Cell col="2" text="bind:dietcd"/>
                      <Cell col="3" style="align:left middle;" text="bind:dietnm"/>
                      <Cell col="4" style="align:left middle;" text="bind:bmealdrnknm"/>
                      <Cell col="5" style="align:center middle;" text="bind:bmealdrnkcnt"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Shape position="absolute 0 89 1195 95" linetype="horizontal" id="line5" class="line_10" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_bmealstatslist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dietnm2" type="STRING" size="256"/>
          <Column id="clinccmtcnts" type="STRING" size="256"/>
          <Column id="prcpdelivefact" type="STRING" size="256"/>
          <Column id="tfdtlcd" type="STRING" size="256"/>
          <Column id="remark" type="STRING" size="256"/>
          <Column id="room1" type="STRING" size="256"/>
          <Column id="dietnm1" type="STRING" size="256"/>
          <Column id="bfremfactcd" type="STRING" size="256"/>
          <Column id="bfremfactnm" type="STRING" size="256"/>
          <Column id="room2" type="STRING" size="256"/>
          <Column id="choidietyn" type="STRING" size="256"/>
          <Column id="iptpsn" type="STRING" size="256"/>
          <Column id="iptdt" type="STRING" size="256"/>
          <Column id="prcpdd" type="STRING" size="256"/>
          <Column id="dietmeal" type="STRING" size="256"/>
          <Column id="calr" type="STRING" size="256"/>
          <Column id="mealcnt" type="STRING" size="256"/>
          <Column id="procermealyn" type="STRING" size="256"/>
          <Column id="dietcd" type="STRING" size="256"/>
          <Column id="dietmdlnm" type="STRING" size="256"/>
          <Column id="dietsmlnm" type="STRING" size="256"/>
          <Column id="calrunit" type="STRING" size="256"/>
          <Column id="remark1" type="STRING" size="256"/>
          <Column id="remark2" type="STRING" size="256"/>
          <Column id="remark3" type="STRING" size="256"/>
          <Column id="dietnm" type="STRING" size="256"/>
          <Column id="bmealdrnknm" type="STRING" size="256"/>
          <Column id="prntprcpdelivefact" type="STRING" size="256"/>
          <Column id="dietcd" type="STRING" size="256"/>
          <Column id="bmealdrnknm" type="STRING" size="256"/>
          <Column id="bmealdrnkcnt" type="STRING" size="256"/>
          <Column id="dietnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dietnm2"/>
            <Col id="clinccmtcnts"/>
            <Col id="prcpdelivefact"/>
            <Col id="tfdtlcd"/>
            <Col id="remark"/>
            <Col id="room1"/>
            <Col id="dietnm1"/>
            <Col id="bfremfactcd"/>
            <Col id="bfremfactnm"/>
            <Col id="room2"/>
            <Col id="choidietyn"/>
            <Col id="iptpsn"/>
            <Col id="iptdt"/>
            <Col id="prcpdd"/>
            <Col id="dietmeal"/>
            <Col id="calr"/>
            <Col id="mealcnt"/>
            <Col id="procermealyn"/>
            <Col id="dietcd"/>
            <Col id="dietmdlnm"/>
            <Col id="dietsmlnm"/>
            <Col id="calrunit"/>
            <Col id="remark1"/>
            <Col id="remark2"/>
            <Col id="remark3"/>
            <Col id="dietnm"/>
            <Col id="bmealdrnknm"/>
            <Col id="prntprcpdelivefact"/>
            <Col id="dietcd"/>
            <Col id="bmealdrnknm"/>
            <Col id="bmealdrnkcnt"/>
            <Col id="dietnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main2_magamlist_magaminfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="magamyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_searchitem" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dietdd" type="STRING" size="256"/>
          <Column id="mealflag" type="STRING" size="256"/>
          <Column id="endflag" type="STRING" size="256"/>
          <Column id="nmcardflag" type="STRING" size="256"/>
          <Column id="ward" type="STRING" size="256"/>
          <Column id="nutrward" type="STRING" size="256"/>
          <Column id="updtyn" type="STRING" size="256"/>
          <Column id="updtflag" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="userid" type="STRING" size="256"/>
          <Column id="endyn" type="STRING" size="256"/>
          <Column id="endmsg" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dietdd"/>
            <Col id="mealflag"/>
            <Col id="endflag"/>
            <Col id="nmcardflag"/>
            <Col id="ward"/>
            <Col id="nutrward"/>
            <Col id="updtyn"/>
            <Col id="updtflag"/>
            <Col id="instcd"/>
            <Col id="userid"/>
            <Col id="endyn"/>
            <Col id="endmsg"/>
            <Col id="pid"/>
            <Col id="hngnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_ret" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="retmsg" 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"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group3.group2.ipt_dietdd" propid="value" datasetid="ds_send_searchitem" columnid="dietdd"/>
      <BindItem id="item1" compid="group3.group2.rdo_meal" propid="value" datasetid="ds_send_searchitem" columnid="mealflag"/>
    </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 SMANT00250_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMANT00250_onload(obj:Form, e:LoadEventInfo)
{
	finit();
	group3.group2.btn_search.enable= frmf_checkAuth("R");
	ds_send_searchitem.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_searchitem.setColumn(0, "userid", sysf_getUserInfo("userid"));
}

//초기화
function finit() {
	//화면open시 공통코드 setting
	//model.removeNodeset("/root/main/data");
	ds_send_searchitem.setColumn(0, "dietdd", utlf_getCurrentDate());
	
	//화면open시 현재시간을 계산하여 끼니와 마감구분 자동setting
	//각 끼니별 2차 마감시간으로부터 2시간후까지는 이전끼니로 setting
	var tm = utlf_getCurrentTime();
	if ( tm.substr(0,4) <= 0830 ) {     													//조식 2차 마감시간은 06:30
		ds_send_searchitem.setColumn(0, "mealflag", "1");
		if ( tm.substr(0,4) <= 0530 ) {
			ds_send_searchitem.setColumn(0, "endflag", "1");
		} else {
			ds_send_searchitem.setColumn(0, "endflag", "2");
		}
	} else if ( (tm.substr(0,4) > 0830) && (tm.substr(0,4) <= 1330) ) {     //중식 2차 마감시간은 11:30
		ds_send_searchitem.setColumn(0, "mealflag", "2");
		if ( tm.substr(0,4) <= 1030 ) {
			ds_send_searchitem.setColumn(0, "endflag", "1");
		} else {
			ds_send_searchitem.setColumn(0, "endflag", "2");
		}
	} else if ( (tm.substr(0,4) > 1330) ) {
		ds_send_searchitem.setColumn(0, "mealflag", "3");
		if ( tm.substr(0,4) <= 1600 ) {
			ds_send_searchitem.setColumn(0, "endflag", "1");
		} else {
			ds_send_searchitem.setColumn(0, "endflag", "2");
		}
	}
}
function group3_group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	//조회시점이 마감시간 전인지 마감시간 후인지 체크
	ds_send_searchitem.addColumn("prcpdd", "string");
	ds_send_searchitem.addColumn("meal", "string");
	
	ds_send_searchitem.setColumn(0, "prcpdd", ds_send_searchitem.getColumn(0, "dietdd"));
	ds_send_searchitem.setColumn(0, "meal", ds_send_searchitem.getColumn(0, "mealflag"));
	
	var oParam = {};
    oParam.id          = "TRANT00103";
    oParam.service     = "dietsumapp.DietSum";
    oParam.method      = "reqGetMagamYn";
    oParam.inds        = "req=ds_send_searchitem";
    oParam.outds       = "ds_main2_magamlist_magaminfo=magaminfo";
    oParam.async       = false;

	tranf_submit(oParam);

	var tm 		= utlf_getCurrentTime();
	var dd 		= ds_send_searchitem.getColumn(0, "dietdd");
	var mealflag= ds_send_searchitem.getColumn(0, "mealflag");   //끼니
	var endflag = ds_send_searchitem.getColumn(0, "endflag");      //마감구분	

	if (ds_main2_magamlist_magaminfo.getColumn(0, "magamyn") == "N"){
		//마감전 데이터임.
		ds_send_searchitem.setColumn(0, "endyn", "N");
		ds_send_searchitem.setColumn(0, "endmsg", "식사마감이 완료되지 않았습니다.");
	} else {
		//마감후 데이터임.
		ds_send_searchitem.setColumn(0, "endyn", "Y");
		ds_send_searchitem.setColumn(0, "endmsg", "마감완료된 식사입니다.");
	}
	
	if ( utlf_isNull(ds_send_searchitem.getColumn(0, "ward")) ) {
		ds_send_searchitem.setColumn(0, "ward", "-");
	}
	
	ds_send_searchitem.addColumn("prcpdd","string");
	ds_send_searchitem.addColumn("meal","string");
	
	ds_send_searchitem.setColumn(0, "prcpdd", ds_send_searchitem.getColumn(0, "dietdd"));
	ds_send_searchitem.setColumn(0, "meal", ds_send_searchitem.getColumn(0, "mealflag"));
	
	var oParam = {};
    oParam.id          = "TRANT00251";
    oParam.service     = "dietsumapp.DietSum";
    oParam.method      = "reqGetBMealStats";
    oParam.inds        = "req=ds_send_searchitem";
    oParam.outds       = "ds_main_bmealstatslist=bmealstatslist";
    oParam.async       = false;

	tranf_submit(oParam);

}

function group3_group2_btn_before_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_searchitem.getColumn(0, "dietdd");
	dd = dd.toDate().getAddDate(-1, "D");
	dd = dd.getDateFormat();
	ds_send_searchitem.setColumn(0, "dietdd", dd);
}

function group3_group2_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_searchitem.getColumn(0, "dietdd");
	dd = dd.toDate().getAddDate(1, "D");
	dd = dd.getDateFormat();
	ds_send_searchitem.setColumn(0, "dietdd", dd);
}

function group3_btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if ( ds_main_bmealstatslist.rowcount > 0 ) {
		grdf_exportExcel(group3.grd_data, "멸균식간식음료수통계", "sheetname1" , true, "" , "" , true);
	} else {
		sysf_messageBox("엑셀로 저장할 데이터가", "I004")
		return;
	}
}
]]></Script>
  </Form>
</FDL>