YNU_JEUS/app_home/himed/xpapps/ast/examcurestatsxp/xp/SMAES00300_기능검사실통계(월별).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES00300" position="absolute 0 0 1256 805" titletext="기능검사실 통계(월별)" oninit="model1_oninit" onload="SMAES00300_onload">
    <Layouts>
      <Layout>
        <Static id="caption1" text="기능검사실 통계(월별)" class="tit_2" position="absolute 0 77 200 97" positiontype="position"/>
        <Shape id="line1" class="line_1" position="absolute 0 65 1195 65" linetype="horizontal" positiontype="position"/>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" onlbuttonup="btn_excsave_onlbuttonup" class="btn2" position="absolute 1188 74 1256 94" anchor="top right" positiontype="position" onclick="btn_excsave_onclick"/>
        <Grid id="grd_list" taborder="3" useinputpanel="false" position="absolute 0 97 1256 805" anchor="all" autofittype="col" binddataset="ds_grid_grd_list" positiontype="position" cellsizingtype="col" oncolresized="grd_list_oncolresized">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="270"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="44"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="60"/>
                <Column size="60"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="검사코드"/>
                <Cell col="2" text="검사명"/>
                <Cell col="3" text="1월"/>
                <Cell col="4" text="2월"/>
                <Cell col="5" text="3월"/>
                <Cell col="6" text="4월"/>
                <Cell col="7" text="5월"/>
                <Cell col="8" text="6월"/>
                <Cell col="9" text="7월"/>
                <Cell col="10" text="8월"/>
                <Cell col="11" text="9월"/>
                <Cell col="12" text="10월"/>
                <Cell col="13" text="11월"/>
                <Cell col="14" text="12월"/>
                <Cell col="15" text="합계"/>
                <Cell col="16" text="비교기간"/>
                <Cell col="17" text="증감"/>
                <Cell col="18" text="증감율"/>
              </Band>
              <Band id="body">
                <Cell expr="expr:currow + 1"/>
                <Cell col="1" style="align:left;" text="bind:prcpcd"/>
                <Cell col="2" style="align:left;" text="bind:prcpnm" wordwrap="char"/>
                <Cell col="3" displaytype="number" text="bind:month01" mask="#,##0"/>
                <Cell col="4" displaytype="number" text="bind:month02" mask="#,##0"/>
                <Cell col="5" displaytype="number" text="bind:month03" mask="#,##0"/>
                <Cell col="6" displaytype="number" text="bind:month04" mask="#,##0"/>
                <Cell col="7" displaytype="number" text="bind:month05" mask="#,##0"/>
                <Cell col="8" displaytype="number" text="bind:month06" mask="#,##0"/>
                <Cell col="9" displaytype="number" text="bind:month07" mask="#,##0"/>
                <Cell col="10" displaytype="number" text="bind:month08" mask="#,##0"/>
                <Cell col="11" displaytype="number" text="bind:month09" mask="#,##0"/>
                <Cell col="12" displaytype="number" text="bind:month10" mask="#,##0"/>
                <Cell col="13" displaytype="number" text="bind:month11" mask="#,##0"/>
                <Cell col="14" displaytype="number" text="bind:month12" mask="#,##0"/>
                <Cell col="15" displaytype="number" text="bind:monthsum" mask="#,##0"/>
                <Cell col="16" displaytype="number" text="bind:compare" mask="#,##0"/>
                <Cell col="17" displaytype="number" text="bind:variation" mask="#,##0"/>
                <Cell col="18" displaytype="text" style="align:right middle;" text="bind:comparerate"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" colspan="2" text="합계"/>
                <Cell col="3" text="expr:getSum(&quot;month01&quot;)"/>
                <Cell col="4" text="expr:getSum(&quot;month02&quot;)"/>
                <Cell col="5" text="expr:getSum(&quot;month03&quot;)"/>
                <Cell col="6" text="expr:getSum(&quot;month04&quot;)"/>
                <Cell col="7" text="expr:getSum(&quot;month05&quot;)"/>
                <Cell col="8" text="expr:getSum(&quot;month06&quot;)"/>
                <Cell col="9" text="expr:getSum(&quot;month07&quot;)"/>
                <Cell col="10" text="expr:getSum(&quot;month08&quot;)"/>
                <Cell col="11" text="expr:getSum(&quot;month09&quot;)"/>
                <Cell col="12" text="expr:getSum(&quot;month10&quot;)"/>
                <Cell col="13" text="expr:getSum(&quot;month11&quot;)"/>
                <Cell col="14" text="expr:getSum(&quot;month12&quot;)"/>
                <Cell col="15" text="expr:getSum(&quot;monthsum&quot;)"/>
                <Cell col="16" displaytype="number" text="expr:getSum(&quot;compare&quot;)" mask="9,999"/>
                <Cell col="17" displaytype="number" text="expr:getSum(&quot;variation&quot;)" mask="9,999"/>
                <Cell col="18" displaytype="number" text="expr:getSum(&quot;compare&quot;) == 0?0:(getSum(&quot;monthsum&quot;) - getSum(&quot;compare&quot;)) / getSum(&quot;compare&quot;) *100" mask="999,9%"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="기능검사실 통계(월별)" class="tit_1" position="absolute 0 3 200 28" positiontype="position"/>
        <Div id="grp_sea" taborder="4" style="align:center top;" class="div_SA" position="absolute 0 28 1256 70" anchor="left top right" positiontype="position">
          <Layouts>
            <Layout>
              <Static id="caption2" text="조회기간" class="search_name" position="absolute 8 10 82 30" anchor="default" positiontype="position"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1110 4 1110 26" anchor="default" positiontype="position"/>
              <Button id="btn_sea" taborder="14" text="조회" onlbuttonup="btn_sea_onlbuttonup" class="btn1" position="absolute 1188 10 1244 30" anchor="top right" onclick="btn_sea_onclick" positiontype="position"/>
              <Calendar id="ipt_todd" taborder="15" class="input_essential" position="absolute 198 10 298 30" anchor="default" dateformat="yyyy-MM-dd" value="null" positiontype="position"/>
              <Static id="caption5" text="~" position="absolute 182 10 198 30" anchor="default" style="align:center;" class="search_no_b" positiontype="position"/>
              <Calendar id="ipt_fromdd" taborder="16" class="input_essential" position="absolute 82 10 182 30" anchor="default" dateformat="yyyy-MM-dd" value="null" positiontype="position"/>
              <Static id="caption3" text="비교기간" class="search_name" position="absolute 322 10 396 30" anchor="default" positiontype="position"/>
              <Calendar id="ipt_compto" taborder="17" class="input_essential" position="absolute 512 10 612 30" anchor="default" dateformat="yyyy-MM-dd" value="null" positiontype="position"/>
              <Static id="caption4" text="~" position="absolute 496 10 512 30" anchor="default" style="align:center;" class="search_no_b" positiontype="position"/>
              <Calendar id="ipt_compfrom" taborder="18" class="input_essential" position="absolute 396 10 496 30" anchor="default" dateformat="yyyy-MM-dd" value="null" positiontype="position"/>
              <Static id="caption7" text="검사실" class="search_name" position="absolute 636 10 697 30" anchor="default"/>
              <Combo id="cmb_excuroom" taborder="19" class="input_essential" position="absolute 697 10 812 30" anchor="default" innerdataset="@ds_init_cmb_initexcuroom" codecolumn="basecd" datacolumn="basecdflagdesc" positiontype="position"/>
              <Static id="caption00" text="구분" class="search_name" position="absolute 836 10 884 30" anchor="default"/>
              <Radio id="ioflag" taborder="20" columncount="3" rowcount="0" codecolumn="value" datacolumn="label" position="absolute 884 10 1029 30" anchor="default" index="0" value="A" innerdataset="@ds_ioflag" onitemclick="grp_sea_ioflag_onitemclick" positiontype="position">
                <Radio id="ioflag" taborder="20" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 884 10 1029 30" anchor="default" index="0" value="A" positiontype="position">
                  <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">I</Col>
                        <Col id="datacolumn">입원</Col>
                      </Row>
                      <Row>
                        <Col id="codecolumn">O</Col>
                        <Col id="datacolumn">외래</Col>
                      </Row>
                    </Rows>
                  </Dataset>
                </Radio>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grid_grd_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpcd" type="STRING"/>
          <Column id="prcpnm" type="STRING"/>
          <Column id="month01" type="STRING"/>
          <Column id="month02" type="STRING"/>
          <Column id="month03" type="STRING"/>
          <Column id="month04" type="STRING"/>
          <Column id="month05" type="STRING"/>
          <Column id="month06" type="STRING"/>
          <Column id="month07" type="STRING"/>
          <Column id="month08" type="STRING"/>
          <Column id="month09" type="STRING"/>
          <Column id="month10" type="STRING"/>
          <Column id="month11" type="STRING"/>
          <Column id="month12" type="STRING"/>
          <Column id="monthsum" type="STRING"/>
          <Column id="compare" type="STRING"/>
          <Column id="variation" type="STRING"/>
          <Column id="comparerate" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_reqparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basesuppdeptcd" type="STRING" size="256"/>
          <Column id="rbasecdflag" type="STRING" size="256"/>
          <Column id="ebasecdflag" type="STRING" size="256"/>
          <Column id="largeclass" type="STRING" size="256"/>
          <Column id="cdgrupid" type="STRING" size="256"/>
          <Column id="centflag" type="STRING" size="256"/>
          <Column id="basecdcnts" type="STRING" size="256"/>
          <Column id="suppflag" type="STRING" size="256"/>
          <Column id="baseroomopenyn" type="STRING" size="256"/>
          <Column id="screenflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_cmb_initexcuroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basecd" type="STRING" size="256"/>
          <Column id="basecdflagdesc" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_cmb_initexecrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basecd" type="STRING" size="256"/>
          <Column id="basecdflagdesc" type="STRING" size="256"/>
          <Column id="equaluserid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_ioflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">전체</Col>
            <Col id="value">A</Col>
          </Row>
          <Row>
            <Col id="label">입원</Col>
            <Col id="value">I</Col>
          </Row>
          <Row>
            <Col id="label">외래</Col>
            <Col id="value">O</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	KU2.0
 * Job Name 		:	
 * File Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-03-25
 *                                                                                        
 * Description  	:	                                                                   

 ****************************************************************************************/


//=======================================================================================
// xjs Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "com_basiccodexp::ZBC001.xjs";
include "ast_examcurexp::AEZ0001.xjs";

function f_TRAEA01115(){//검사실combo
			
			ds_cmb_reqparam.setColumn(0, "basesuppdeptcd", suppdeptcd);
			ds_cmb_reqparam.setColumn(0, "rbasecdflag", "R");
			ds_cmb_reqparam.setColumn(0, "ebasecdflag", "E");
			ds_cmb_reqparam.setColumn(0, "largeclass", "M4");
			ds_cmb_reqparam.setColumn(0, "cdgrupid", "A0486");
			ds_cmb_reqparam.setColumn(0, "centflag", "");
			ds_cmb_reqparam.setColumn(0, "baseroomopenyn", "N");
									
			var oParam = new Object();
			oParam.id = "TRAEA01115";
			oParam.service = "examcureacptexecapp.ExamCureAcpt";
			oParam.method = "reqGetInitFuncExamCureRoomList";
			oParam.inds = "reqparam=ds_cmb_reqparam";
			oParam.outds ="ds_init_cmb_initexcuroom=initexcuroom";
			oParam.callback = "cbf_TRAEA01115";

			tranf_submit(oParam);
}
function cbf_TRAEA01115(sSvcId, objErrorCode, objErrorMsg){
	frmf_addComboItem("grp_sea.cmb_excuroom", "--전체--", "", ""); //검사실
	grp_sea.cmb_excuroom.index = 0;
}
function f_TRAES00301(){//조회
			
			dsf_createDsRow("ds_req",
			[{col:"execfromdd", val:grp_sea.ipt_fromdd.value}
			,{col:"exectodd", val:grp_sea.ipt_todd.value}
			,{col:"comparefromdd", val:grp_sea.ipt_compfrom.value}
			,{col:"comparetodd", val:grp_sea.ipt_compto.value}
			,{col:"excuroomcd", val:grp_sea.cmb_excuroom.value}
			,{col:"suppdeptcd", val:suppdeptcd}
			,{col:"ioflag", val:grp_sea.ioflag.value}
			,{col:"screenflag", val:ds_cmb_reqparam.getColumn(0, "screenflag")}
			]);
									
			var oParam = new Object();
			oParam.id = "TRAES00301";
			oParam.service = "examcurestatsapp.FuntExam";
			oParam.method = "reqGetFuntExamStatsMMList";
			oParam.inds = "req=ds_req";
			oParam.outds ="ds_grid_grd_list=item";
			oParam.callback = "cbf_TRAES00301";
			
			tranf_submit(oParam);
}
function cbf_TRAES00301(sSvcId, objErrorCode, objErrorMsg){
	for(var i=0; i<ds_grid_grd_list.rowcount; i++){
		var temp = ds_grid_grd_list.getColumn(i,"comparerate");
		if(utlf_isNull(temp)){
			ds_grid_grd_list.setColumn(i,"comparerate", "%");
		}else{
			ds_grid_grd_list.setColumn(i,"comparerate",temp+"%");
		}
	}
	grd_list.updateToDataset();
}
/****************************************************************************************
 * Components	    : 
 * Components ID  : SMAES00300
 * Event 		    : onload
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function SMAES00300_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  // 화면공통
	
	lf_aezfSetSuppDeptcd();
	
	// 검사실/실시자 조회
	f_TRAEA01115();			
	
	var fromdd = utlf_getCurrentDate().substr(0,4) + "0101"
	var todd = utlf_getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
	var comparefromdd = utlf_getCurrentDate().substr(0,6).toDate().getAddDate(-1,"Y").getDateFormat("YYYY") +  "0101";
	var comparetodd = comparefromdd.substr(0,4) + todd.substr(4,4);
	
	
	
	grp_sea.ipt_fromdd.value = fromdd;
	
	grp_sea.ipt_todd.value = todd;
	
	grp_sea.ipt_compfrom.value = comparefromdd;
	
	grp_sea.ipt_compto.value = comparetodd;
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : btn_sea
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function btn_sea_onclick(obj:Button, e:ClickEventInfo)
{
							
	f_TRAES00301();
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : btn_excsave
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 엑셀저장
 ****************************************************************************************/
function btn_excsave_onclick(obj:Button, e:ClickEventInfo)
{
	if(ds_grid_grd_list.rowcount <= 0){
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}else{	
		grdf_exportExcel(grd_list, "기능검사실통계(월별)", "sheet1");
	}
					
}


function grd_list_oncolresized(obj:Grid, e:GridSizeChangedEventInfo)
{
	if(e.newvalue == 0){
		obj.setRealColSize(e.subindex, 1);
	}

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