YNU_JEUS/app_home/himed/xpapps/emr/wardcarexp/xp/SMMNW18100_입퇴원라운지통계.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMNW18100" position="absolute 0 0 630 700" titletext="입퇴원라운지통계" onload="SMMNW18100_onload">
    <Layouts>
      <Layout>
        <Div id="group1" position="absolute 0 0 610 21" style="" scrollbars="none">
          <Layouts>
            <Layout>
              <Static id="caption6" class="tit_1" position="absolute 0 0 157 23" style="" text="입퇴원라운지통계" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group3" position="absolute 0 13 610 690" style="">
          <Layouts>
            <Layout>
              <Div id="group2" position="absolute 0 10 610 45" style="" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 610 35" style="border:1 solid #ffd799 #ffd799;background:#fffbf2  ;"/>
                    <Shape id="line2" class="line_4" linetype="vertical" position="absolute 478 7 481 29" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
                    <Static id="caption17" class="search_name" position="absolute 14 8 109 25" style="" text="업무일자 :" anchor="default"/>
                    <Calendar id="ipt_fromdd" class="input_search" mask="yyyy-mm-dd" position="absolute 107 8 205 27" style="" anchor="default" autoselect="true"/>
                    <Calendar id="ipt_todd" class="input_search" position="absolute 227 8 325 27" style="" anchor="default" autoselect="true"/>
                    <Static id="cpt_line" class="search_no_b" position="absolute 210 8 222 25" style="" text="~" anchor="default"/>
                    <Button id="btn_search" class="btn1" position="absolute 488 7 544 29" style="" text="조회" onclick="group3_group2_btn_search_onclick" anchor="default"/>
                    <Radio datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="rdo_srchflag" position="absolute 340 8 450 28" style="" onitemchanged="group3_group2_rdo_srchflag_onitemchanged" 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>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Button id="button1" class="btn1" position="absolute 545 7 601 29" style="" text="엑셀" onclick="group3_group2_button1_onclick" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Static id="caption2" class="tit_2" position="absolute 5 50 305 72" style="align:left middle;font:Dotum,9,bold;" text="입퇴원라운지현황" anchor="default"/>
              <Shape id="line1" class="line_1" linetype="horizontal" position="absolute 0 70 610 73" style="strokepen:5 solid #33bbbbff;" anchor="default"/>
              <Grid id="grd_inlvstatlist" binddataset="ds_main_inlvstatinfo_inlvstatlist" class="datagrid2" position="absolute 0 75 610 675" style="" onaftersort="group3_grd_inlvstatlist_onaftersort" cellsizingtype="col" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="105"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="50"/>
                      <Column size="20"/>
                      <Column size="55"/>
                      <Column size="55"/>
                    </Columns>
                    <Rows>
                      <Row size="30" band="head"/>
                      <Row size="24"/>
                      <Row size="24" band="summ"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="부서"/>
                      <Cell col="1" text="평균&#10;병상수"/>
                      <Cell col="2" text="입원"/>
                      <Cell col="3" text="입원&#10;방문"/>
                      <Cell col="4" text="입실&#10;저장"/>
                      <Cell col="5" text="퇴원"/>
                      <Cell col="6" text="퇴원&#10;방문"/>
                      <Cell col="7" colspan="2" text="전일&#10;퇴원예고율" taborder="undefined"/>
                      <Cell col="9" text="검사대기&#10;방문"/>
                      <Cell col="10" text="진료대기&#10;방문"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:left middle;" text="bind:orddeptnm" wordwrap="char"/>
                      <Cell col="1" displaytype="number" text="bind:roomcnt"/>
                      <Cell col="2" displaytype="number" text="bind:inptcnt"/>
                      <Cell col="3" displaytype="number" text="bind:idlvcnt"/>
                      <Cell col="4" displaytype="number" text="bind:careinrmcnt"/>
                      <Cell col="5" displaytype="number" text="bind:dschcnt"/>
                      <Cell col="6" displaytype="number" text="bind:dhlvcnt"/>
                      <Cell col="7" displaytype="number" text="bind:dschrate"/>
                      <Cell col="8" displaytype="normal" text="%"/>
                      <Cell col="9" displaytype="number" text="bind:telvcnt"/>
                      <Cell col="10" displaytype="number" text="bind:mdlvcnt"/>
                    </Band>
                    <Band id="summary">
                      <Cell style="background:#99ff99ff;background2:#99ff99ff;"/>
                      <Cell col="1" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;roomcnt&quot;)"/>
                      <Cell col="2" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;inptcnt&quot;)"/>
                      <Cell col="3" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;idlvcnt&quot;)"/>
                      <Cell col="4" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;careinrmcnt&quot;)"/>
                      <Cell col="5" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;dschcnt&quot;)"/>
                      <Cell col="6" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;dhlvcnt&quot;)"/>
                      <Cell col="7" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;dschrate&quot;) / rowcount" mask="##0"/>
                      <Cell col="8" displaytype="normal" style="background:#99ff99ff;background2:#99ff99ff;" text="%"/>
                      <Cell col="9" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;telvcnt&quot;)"/>
                      <Cell col="10" displaytype="number" style="background:#99ff99ff;background2:#99ff99ff;" expr="getSum(&quot;mdlvcnt&quot;)"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="send" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="inlvstatinfo" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="srchflag" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchflag">1</Col>
            <Col id="fromdd"/>
            <Col id="todd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_inlvstatinfo_inlvstatlist" 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_fromdd" propid="value" datasetid="ds_main_cond" columnid="fromdd"/>
      <BindItem id="item1" compid="group3.group2.ipt_todd" propid="value" datasetid="ds_main_cond" columnid="todd"/>
      <BindItem id="item2" compid="group3.group2.rdo_srchflag" propid="value" datasetid="ds_main_cond" columnid="srchflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	emr_wardcarexp -> SMMNW17300
 * Creator			:	yjh
 * Make Date 		:	2017-01-09
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2017-01-09		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";


function SMMNW18100_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	fInitialize();

}


function fInitialize()
{
	ds_main_inlvstatinfo_inlvstatlist.clearData();
	ds_send.clearData(); 
	ds_send.addRow();
	ds_main_cond.setColumn( 0, "fromdd",utlf_getCurrentDate());
	ds_main_cond.setColumn( 0, "todd",utlf_getCurrentDate());


}	

function fSearch()
{
	var fromdd = ds_main_cond.getColumn(0, "fromdd");
	var todd    = ds_main_cond.getColumn(0, "todd");

	if(utlf_getDateInterval(fromdd, todd) > 31){    
		sysf_messageBox("조회기간은 한달이상을 넘을 수", "I004");
		group3.group2.ipt_todd.setFocus();
		return;
	}			

	ds_main_inlvstatinfo_inlvstatlist.clearData();
	ds_send.copyData(ds_main_cond);       

	var oParam = {};
	oParam.id          = "TRMNW18100";
	oParam.service     = "wardcareapp.WardCareMngt";
	oParam.method      = "reqGetInlvStatList";
	oParam.inds        = "req=ds_send";
	oParam.outds       = "ds_main_inlvstatinfo_inlvstatlist=inlvstatlist";
	oParam.async       = false;
	//oParam.callback    = "cf_TRMNW18100";

	tranf_submit(oParam);
	
	//ds_main_inlvstatinfo_inlvstatlist.keystring = "G:orddeptnm";  부분 sum 


	if(ds_main_cond.getColumn(0, "srchflag") == "1"){
	    group3.grd_inlvstatlist.setFormatColProperty(group3.grd_inlvstatlist.getBindCellIndex("Body","telvcnt"),"size",0); 
	    group3.grd_inlvstatlist.setFormatColProperty(group3.grd_inlvstatlist.getBindCellIndex("Body","mdlvcnt"),"size",0); 
	}else{
		group3.grd_inlvstatlist.setFormatColProperty(group3.grd_inlvstatlist.getBindCellIndex("Body","telvcnt"),"size",55); 
	    group3.grd_inlvstatlist.setFormatColProperty(group3.grd_inlvstatlist.getBindCellIndex("Body","mdlvcnt"),"size",55); 
	}

}



function group3_group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {

	fSearch();

}

function group3_group2_rdo_srchflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo) {

	fSearch();

}

function group3_group2_button1_onclick(obj:Button, e:ClickEventInfo) {

	var fName = "";

	if(ds_main_cond.getColumn(0, "srchflag") == "1"){
		fName = "입퇴원라운지통계(병동)_";
	}else if(ds_main_cond.getColumn(0, "srchflag") == "2"){
		fName = "입퇴원라운지통계(진료과)_";
	}

	var fileName = fName+utlf_getCurrentDate();

	grdf_exportExcel(group3.grd_inlvstatlist, fileName, "Sheet1",  true, "" , 'user' , true);


}
]]></Script>
  </Form>
</FDL>