YNU_JEUS/app_home/himed/xpapps/ast/dietxp/xp/SMANT00800_병동별상차림현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANT00800" position="absolute 0 0 1210 788" titletext="병동별상차림현황" oninit="SMANT00800_oninit" onload="SMANT00800_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1195 25" id="grp_tle">
          <Layouts>
            <Layout>
              <Static text="병동별상차림현황" position="absolute 0 0 149 25" id="caption6" class="tit_1"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 13 1195 757" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Static text="병동별상차림현황" position="absolute 0 56 140 72" id="caption1" class="tit_2"/>
              <Shape position="absolute 0 72 1194 78" linetype="horizontal" id="line1" class="line_10"/>
              <Grid position="absolute 0 76 1194 743" align="align:center middle;" id="grd_data" binddataset="ds_main_data" cellsizingtype="both" extendsizetype="row">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="0"/>
                      <Column size="100"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                      <Column size="70"/>
                    </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="보호자밥"/>
                      <Cell col="6" text="일반죽"/>
                      <Cell col="7" text="선택죽"/>
                      <Cell col="8" text="미음"/>
                      <Cell col="9" text="소아밥"/>
                      <Cell col="10" text="소아죽"/>
                      <Cell col="11" text="산모밥"/>
                      <Cell col="12" text="산모죽"/>
                      <Cell col="13" text="caption1"/>
                      <Cell col="14" text="caption2"/>
                      <Cell col="15" text="caption3"/>
                      <Cell col="16" text="caption4"/>
                      <Cell col="17" text="caption5"/>
                      <Cell col="18" text="caption6"/>
                      <Cell col="19" text="caption7"/>
                      <Cell col="20" text="caption8"/>
                      <Cell col="21" text="caption9"/>
                      <Cell col="22" text="caption10"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" text="expr:currow + 1"/>
                      <Cell col="1" text="bind:wardcd"/>
                      <Cell col="2" text="bind:wardnm"/>
                      <Cell col="3" text="bind:data1"/>
                      <Cell col="4" text="bind:data2"/>
                      <Cell col="5" text="bind:data3"/>
                      <Cell col="6" text="bind:data4"/>
                      <Cell col="7" text="bind:data5"/>
                      <Cell col="8" text="bind:data6"/>
                      <Cell col="9" text="bind:data7"/>
                      <Cell col="10" text="bind:data8"/>
                      <Cell col="11" text="bind:data9"/>
                      <Cell col="12" text="bind:data10"/>
                      <Cell col="13" text="bind:data11"/>
                      <Cell col="14" text="bind:data12"/>
                      <Cell col="15" text="bind:data13"/>
                      <Cell col="16" text="bind:data14"/>
                      <Cell col="17" text="bind:data15"/>
                      <Cell col="18" text="bind:data16"/>
                      <Cell col="19" text="bind:data17"/>
                      <Cell col="20" text="bind:data18"/>
                      <Cell col="21" text="bind:data19"/>
                      <Cell col="22" text="bind:data20"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button position="absolute 1120 50 1194 69" id="btn_excel" class="btn7" text="엑셀저장" onclick="grp_biz_btn_excel_onclick"/>
              <Div position="absolute 0 10 1194 47" align="align:center top;" id="grp_sea">
                <Layouts>
                  <Layout>
                    <Shape position="absolute 0 2 1194 37" id="roundrect1" type="roundrectangle" anchor="default"/>
                    <Static text="일자 :" position="absolute 41 12 105 29" id="caption2" class="search_name" anchor="default"/>
                    <Static text="끼니 :" position="absolute 316 12 378 29" id="caption3" class="search_name" anchor="default"/>
                    <Button position="absolute 950 8 1006 30" id="btn_search" class="btn1" visible="false" text="조회" anchor="default" onclick="grp_biz_grp_sea_btn_search_onclick"/>
                    <Shape position="absolute 1104 10 1110 32" linetype="vertical" id="line13" class="line_4" anchor="default"/>
                    <Calendar position="absolute 105 11 209 30" id="ipt_appdd" class="input_essential" anchor="default" autoselect="true"/>
                    <Button position="absolute 213 13 226 28" id="btn_beforedd" class="icon_pre" text="" anchor="default" onclick="grp_biz_grp_sea_btn_beforedd_onclick"/>
                    <Button position="absolute 226 13 239 28" id="btn_nextdd" class="icon_next" text="" anchor="default" onclick="grp_biz_grp_sea_btn_nextdd_onclick"/>
                    <Radio position="absolute 380 9 530 29" id="rdo_dietmeal" 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>
                    <Button position="absolute 1120 8 1176 30" id="button1" class="btn1" text="조회" anchor="default" onclick="grp_biz_grp_sea_button1_onclick"/>
                  </Layout>
                </Layouts>
              </Div>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 757 1195 784" id="grp_btn">
          <Layouts>
            <Layout>
              <Button position="absolute 0 5 80 27" id="button8" class="btn3" enable="false" text="식수통계"/>
              <Button position="absolute 285 5 341 27" id="btn_print" class="btn6" visible="false" text="출력" onclick="grp_btn_btn_print_onclick"/>
              <Button position="absolute 95 5 151 27" id="button2" class="btn6" text="출력" onclick="grp_btn_button2_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="wardcd" type="STRING" size="256"/>
          <Column id="wardnm" type="STRING" size="256"/>
          <Column id="data1" type="STRING" size="256"/>
          <Column id="data2" type="STRING" size="256"/>
          <Column id="data3" type="STRING" size="256"/>
          <Column id="data4" type="STRING" size="256"/>
          <Column id="data5" type="STRING" size="256"/>
          <Column id="data6" type="STRING" size="256"/>
          <Column id="data7" type="STRING" size="256"/>
          <Column id="data8" type="STRING" size="256"/>
          <Column id="data9" type="STRING" size="256"/>
          <Column id="data10" type="STRING" size="256"/>
          <Column id="data11" type="STRING" size="256"/>
          <Column id="data12" type="STRING" size="256"/>
          <Column id="data13" type="STRING" size="256"/>
          <Column id="data14" type="STRING" size="256"/>
          <Column id="data15" type="STRING" size="256"/>
          <Column id="data16" type="STRING" size="256"/>
          <Column id="data17" type="STRING" size="256"/>
          <Column id="data18" type="STRING" size="256"/>
          <Column id="data19" type="STRING" size="256"/>
          <Column id="data20" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="wardcd"/>
            <Col id="wardnm"/>
            <Col id="data1"/>
            <Col id="data2"/>
            <Col id="data3"/>
            <Col id="data4"/>
            <Col id="data5"/>
            <Col id="data6"/>
            <Col id="data7"/>
            <Col id="data8"/>
            <Col id="data9"/>
            <Col id="data10"/>
            <Col id="data11"/>
            <Col id="data12"/>
            <Col id="data13"/>
            <Col id="data14"/>
            <Col id="data15"/>
            <Col id="data16"/>
            <Col id="data17"/>
            <Col id="data18"/>
            <Col id="data19"/>
            <Col id="data20"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_printlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpdd" type="STRING" size="256"/>
          <Column id="dietmeal" type="STRING" size="256"/>
          <Column id="dietnm" type="STRING" size="256"/>
          <Column id="w4A" type="STRING" size="256"/>
          <Column id="w4B" type="STRING" size="256"/>
          <Column id="w5A" type="STRING" size="256"/>
          <Column id="w5B" type="STRING" size="256"/>
          <Column id="w6A" type="STRING" size="256"/>
          <Column id="w6B" type="STRING" size="256"/>
          <Column id="w7A" type="STRING" size="256"/>
          <Column id="w7B" type="STRING" size="256"/>
          <Column id="w7C" type="STRING" size="256"/>
          <Column id="w8A" type="STRING" size="256"/>
          <Column id="w8B" type="STRING" size="256"/>
          <Column id="w8C" type="STRING" size="256"/>
          <Column id="w9A" type="STRING" size="256"/>
          <Column id="w9B" type="STRING" size="256"/>
          <Column id="w9C" type="STRING" size="256"/>
          <Column id="we" type="STRING" size="256"/>
          <Column id="wh" type="STRING" size="256"/>
          <Column id="w3" type="STRING" size="256"/>
          <Column id="w10A" type="STRING" size="256"/>
          <Column id="w10B" type="STRING" size="256"/>
          <Column id="w10C" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="prcpdd"/>
            <Col id="dietmeal"/>
            <Col id="dietnm"/>
            <Col id="w4A"/>
            <Col id="w4B"/>
            <Col id="w5A"/>
            <Col id="w5B"/>
            <Col id="w6A"/>
            <Col id="w6B"/>
            <Col id="w7A"/>
            <Col id="w7B"/>
            <Col id="w7C"/>
            <Col id="w8A"/>
            <Col id="w8B"/>
            <Col id="w8C"/>
            <Col id="w9A"/>
            <Col id="w9B"/>
            <Col id="w9C"/>
            <Col id="we"/>
            <Col id="wh"/>
            <Col id="w3"/>
            <Col id="w10A"/>
            <Col id="w10B"/>
            <Col id="w10C"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main1_titleinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_searchitem" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="appdd" type="STRING" size="256"/>
          <Column id="dietmeal" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_basecode_dietmeal_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_rexprnt_title_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_rexprnt_ward_wardnm" 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_appdd" propid="value" datasetid="ds_send_searchitem" columnid="appdd"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.rdo_dietmeal" propid="value" datasetid="ds_send_searchitem" columnid="dietmeal"/>
    </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 SMANT00800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMANT00800_onload(obj:Form, e:LoadEventInfo)
{
	ds_main1_titleinfo.clearData();
	
	var oParam = {};
    oParam.id          = "TRANT00803";
    oParam.service     = "dietsumapp.DietSum";
    oParam.method      = "reqGetWardTitle";
    oParam.inds        = "req=ds_send_searchitem";
    oParam.outds       = "ds_main1_titleinfo=titleinfo";
    oParam.async       = false;

	tranf_submit(oParam);

	var icnt = parseInt(ds_main1_titleinfo.rowcount);
	var scaption = "병동코드^구분";
	var k = 0;
	for (var i = 0; i < icnt; i++){
		scaption = scaption + "^" +ds_main1_titleinfo.getColumn(i, "title1");
		k = parseInt(k) + 1;
	}
	if (k < 20){
		for (var i = parseInt(k + 1); i < 21; i++){
			scaption = scaption + "^" + "";
			grp_biz.grd_data.setRealColSize(i +2, 0, false);
		}
	}
	var scaptionsp = scaption.split("^");
	for(var i = 2; i < grp_biz.grd_data.getCellCount("Head"); i++){
		grp_biz.grd_data.setCellProperty("Head", i, "text", scaptionsp[i-1]);
		
	}
	finit();
	grp_biz.grp_sea.button1.enable = frmf_checkAuth("R");
}

function finit() {
	// 화면open시 공통코드 setting
	appf_getCodeList([{dsNm: "ds_init_basecode_dietmeal_A0055", cdGrpId: "A0055"}]);

	ds_main_data.clearData();
	ds_main_printlist.clearData();
	ds_send_searchitem.clearData();
	ds_send_searchitem.addRow();

	ds_send_searchitem.setColumn(0, "appdd", 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, "dietmeal", "1");
	} else if ( (tm.substr(0,4) > 0830) && (tm.substr(0,4) <= 1330) ) {     //중식 2차 마감시간은 11:30
		ds_send_searchitem.setColumn(0, "dietmeal", "2");
	} else {
		ds_send_searchitem.setColumn(0, "dietmeal", "3");
	}					
	frmf_inputEnterKey("grp_biz.grp_sea.button1", "onclick", new ClickEventInfo);
}

function grp_biz_btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_data, "", "sheetname1" , true, "" , "" , true);	
}

function grp_biz_grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
    oParam.id          = "TRANT00801";
    oParam.service     = "dietsumapp.DietSum";
    oParam.method      = "reqGetWardTableSet";
    oParam.inds        = "req=ds_send_searchitem";
    oParam.outds       = "ds_main_data=data ds_main_printlist=printlist";
    oParam.async       = false;
    
	tranf_submit(oParam);		
					
	ds_main_printlist.updateColID("w4a", "w4A");	
	ds_main_printlist.updateColID("w4b", "w4B");	
	ds_main_printlist.updateColID("w5a", "w5A");
	ds_main_printlist.updateColID("w5b", "w5B");
	ds_main_printlist.updateColID("w6a", "w6A");
	ds_main_printlist.updateColID("w6b", "w6B");
	ds_main_printlist.updateColID("w7a", "w7A");
	ds_main_printlist.updateColID("w7b", "w7B");
	ds_main_printlist.updateColID("w7c", "w7C");
	ds_main_printlist.updateColID("w8a", "w8A");
	ds_main_printlist.updateColID("w8b", "w8B");
	ds_main_printlist.updateColID("w8c", "w8C");
	ds_main_printlist.updateColID("w9a", "w9A");
	ds_main_printlist.updateColID("w9b", "w9B");
	ds_main_printlist.updateColID("w9c", "w9C");
	ds_main_printlist.updateColID("w10a", "w10A");
	ds_main_printlist.updateColID("w10b", "w10B");
	ds_main_printlist.updateColID("w10c", "w10C");
	                                       
				
	//그리드 하단에 합계 구하기
	ds_main_data.addRow();
	ds_main_data.setColumn(ds_main_data.rowposition, "wardnm", "계");

	var val = 0;
	for ( j = 3; j < grp_biz.grd_data.getCellCount("Head"); j++) {
		var sum = 0;
		for ( i=0; i<ds_main_data.rowcount-1; i++) {
			val = grp_biz.grd_data.getCellProperty("body", j, "text").replace("bind:" , "");
			val = ds_main_data.getColumn(i, val);
			sum = parseInt(sum) + parseInt(val);
		}
		
		ds_main_data.setColumn(ds_main_data.rowposition, grp_biz.grd_data.getCellProperty("body", j, "text").replace("bind:" , ""),  sum);
	}
}

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

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

function grp_biz_grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
    oParam.id          = "TRANT00802";
    oParam.service     = "dietsumapp.DietSum";
    oParam.method      = "reqGetWardTableSet2";
    oParam.inds        = "req=ds_send_searchitem";
    oParam.outds       = "ds_main_data=data ds_main_printlist=printlist";
    oParam.async       = false;

	tranf_submit(oParam);	
	
	ds_main_printlist.updateColID("w4a", "w4A");	
	
	//그리드 하단에 합계 구하기
	ds_main_data.addRow();
	ds_main_data.setColumn(ds_main_data.rowposition, "wardnm", "계");

	var val = 0;
	for ( j = 3; j < grp_biz.grd_data.getCellCount("Head"); j++) {
		var sum = 0;
		for ( i=0; i<ds_main_data.rowcount-1; i++) {
			val = grp_biz.grd_data.getCellProperty("body", j, "text").replace("bind:" , "");
			ds_main_data.addColumn(val, "string");
			val = ds_main_data.getColumn(i, val);
				sum = parseInt(sum) + parseInt(val);
		}
		
		ds_main_data.setColumn(ds_main_data.rowposition, grp_biz.grd_data.getCellProperty("body", j, "text").replace("bind:" , ""),  sum);
	}
}


function grp_btn_btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	//미리보기출력
	var objDOM = rptf_createDOM();			
	rptf_setNodeListToDOM(objDOM, "root/main/printlist", ds_main_printlist);	// 데이터셋 1	
	rptf_setNodeListToDOM(objDOM, "root/send/searchitem", ds_send_searchitem);	// 데이터셋 2

	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(["RPMNW00215"],[objParam], option);
			
	exeReportPreview("RPANT00801", "XMLSTR", "/root/main/printlist");
}

function grp_btn_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	//미리보기출력
	var objDOM = rptf_createDOM();			
	rptf_setNodeListToDOM(objDOM, "root/main/printlist", ds_main_printlist);	// 데이터셋 1	
	rptf_setNodeListToDOM(objDOM, "root/send/searchitem", ds_send_searchitem);	// 데이터셋 2

	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(["RPANT00803"],[objParam], option);
}
]]></Script>
  </Form>
</FDL>