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

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES04600" position="absolute 0 0 1256 805" titletext="기능검사실 통계(분기별)" oninit="model1_oninit" onload="SMAES04600_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"/>
        <Div id="grp_sea" taborder="1" style="align:center top;" position="absolute 0 25 1256 67" class="div_SA" anchor="left top right" positiontype="position">
          <Layouts>
            <Layout>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1110 4 1110 26" anchor="default" positiontype="position"/>
              <Button id="btn_sea" taborder="1" text="조회" onlbuttonup="btn_sea_onlbuttonup" class="btn1" position="absolute 1188 10 1244 30" anchor="top right" positiontype="position" onclick="btn_sea_onclick"/>
              <Static id="caption9" text="검사실" class="search_name" position="absolute 354 10 415 30" anchor="default" visible="true" positiontype="position"/>
              <Combo id="cmb_excuroom" taborder="2" position="absolute 415 10 571 30" anchor="default" class="input_essential" visible="true" positiontype="position" innerdataset="@ds_init_cmb_initexcuroom" codecolumn="basecd" datacolumn="basecdflagdesc"/>
              <Static id="caption8" text="구분" class="search_name" visible="false" position="absolute 579 10 627 30" anchor="default" positiontype="position"/>
              <Radio id="ioflag" taborder="3" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" visible="false" position="absolute 627 10 772 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>
              <Static id="caption2" text="조회년도" class="search_name" position="absolute 8 10 82 30" anchor="default" positiontype="position"/>
              <Combo id="cmb_qurt" taborder="6" position="absolute 245 10 346 30" anchor="default" class="input_essential" positiontype="position" codecolumn="value" datacolumn="label" innerdataset="@ds_cmb_qurt" onitemchanged="grp_sea_cmb_qurt_onitemchanged"/>
              <Static id="caption3" text="조회분기" class="search_name" position="absolute 171 10 245 30" anchor="default" positiontype="position"/>
              <Spin id="ipt_toyear" taborder="7" class="input_essential" position="absolute 82 10 163 30" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <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" style="align:center middle;" autofittype="col" anchor="all" binddataset="ds_grid_grd_list" positiontype="position" onheadclick="grd_list_onheadclick" cellsizingtype="col" oncolresized="grd_list_oncolresized">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="87"/>
                <Column size="314"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="42"/>
                <Column size="54"/>
                <Column size="54"/>
                <Column size="54"/>
                <Column size="54"/>
                <Column size="54"/>
                <Column size="54"/>
                <Column size="54"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2"/>
                <Cell col="1" rowspan="2" text="검사코드"/>
                <Cell col="2" rowspan="2" text="검사명"/>
                <Cell col="3" colspan="3" text="3월"/>
                <Cell col="6" colspan="3" text="4월"/>
                <Cell col="9" colspan="3" text="5월"/>
                <Cell col="12" colspan="3" text="1/4분기"/>
                <Cell col="15" colspan="2" text="전분기대비"/>
                <Cell col="17" colspan="2" text="전년동분기대비"/>
                <Cell row="1" col="3" text="입원"/>
                <Cell row="1" col="4" text="외래"/>
                <Cell row="1" col="5" text="계"/>
                <Cell row="1" col="6" text="입원"/>
                <Cell row="1" col="7" text="외래"/>
                <Cell row="1" col="8" text="계"/>
                <Cell row="1" col="9" text="입원"/>
                <Cell row="1" col="10" text="외래"/>
                <Cell row="1" col="11" text="계"/>
                <Cell row="1" col="12" text="입원"/>
                <Cell row="1" col="13" text="외래"/>
                <Cell row="1" col="14" text="계"/>
                <Cell row="1" col="15" text="합계"/>
                <Cell row="1" col="16" text="증감"/>
                <Cell row="1" col="17" text="합계"/>
                <Cell row="1" 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:imonth01" mask="#,##0"/>
                <Cell col="4" displaytype="number" text="bind:omonth01" mask="#,##0"/>
                <Cell col="5" displaytype="number" text="bind:smonth01" mask="#,##0"/>
                <Cell col="6" displaytype="number" text="bind:imonth02" mask="#,##0"/>
                <Cell col="7" displaytype="number" text="bind:omonth02" mask="#,##0"/>
                <Cell col="8" displaytype="number" text="bind:smonth02" mask="#,##0"/>
                <Cell col="9" displaytype="number" text="bind:imonth03" mask="#,##0"/>
                <Cell col="10" displaytype="number" text="bind:omonth03" mask="#,##0"/>
                <Cell col="11" displaytype="number" text="bind:smonth03" mask="#,##0"/>
                <Cell col="12" displaytype="number" text="bind:iqurt01" mask="#,##0"/>
                <Cell col="13" displaytype="number" text="bind:oqurt01" mask="#,##0"/>
                <Cell col="14" displaytype="number" text="bind:squrt01" mask="#,##0"/>
                <Cell col="15" displaytype="number" text="bind:prequrtsum" mask="#,##0"/>
                <Cell col="16" displaytype="number" text="bind:prequrtrate" mask="###.0%"/>
                <Cell col="17" displaytype="number" text="bind:preyearqurtsum" mask="#,##0"/>
                <Cell col="18" displaytype="number" text="bind:preyearqurtrate" mask="###.0%"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" colspan="2" text="총계"/>
                <Cell col="3" text="expr:getSum(&quot;imonth01&quot;)"/>
                <Cell col="4" text="expr:getSum(&quot;omonth01&quot;)"/>
                <Cell col="5" text="expr:getSum(&quot;smonth01&quot;)"/>
                <Cell col="6" text="expr:getSum(&quot;imonth02&quot;)"/>
                <Cell col="7" text="expr:getSum(&quot;omonth02&quot;)"/>
                <Cell col="8" text="expr:getSum(&quot;smonth02&quot;)"/>
                <Cell col="9" text="expr:getSum(&quot;imonth03&quot;)"/>
                <Cell col="10" text="expr:getSum(&quot;omonth03&quot;)"/>
                <Cell col="11" text="expr:getSum(&quot;smonth03&quot;)"/>
                <Cell col="12" text="expr:getSum(&quot;iqurt01&quot;)"/>
                <Cell col="13" text="expr:getSum(&quot;oqurt01&quot;)"/>
                <Cell col="14" text="expr:getSum(&quot;squrt01&quot;)"/>
                <Cell col="15" text="expr:getSum(&quot;prequrtsum&quot;)"/>
                <Cell col="16" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;prequrtsum&quot;)==0?0:(getSum(&quot;squrt01&quot;) - getSum(&quot;prequrtsum&quot;)) / (getSum(&quot;prequrtsum&quot;)) * 100" mask="#,##0%"/>
                <Cell col="17" text="expr:getSum(&quot;preyearqurtsum&quot;)"/>
                <Cell col="18" displaytype="number" text="expr:getSum(&quot;preyearqurtsum&quot;)==0?0:(getSum(&quot;squrt01&quot;) - getSum(&quot;preyearqurtsum&quot;)) / getSum(&quot;preyearqurtsum&quot;) * 100" mask="#,##0%"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="기능검사실 통계(분기별)" class="tit_1" position="absolute 0 3 200 28" positiontype="position"/>
      </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="imonth01" type="STRING"/>
          <Column id="omonth01" type="STRING"/>
          <Column id="smonth01" type="STRING"/>
          <Column id="imonth02" type="STRING"/>
          <Column id="omonth02" type="STRING"/>
          <Column id="smonth02" type="STRING"/>
          <Column id="imonth03" type="STRING"/>
          <Column id="omonth03" type="STRING"/>
          <Column id="smonth03" type="STRING"/>
          <Column id="iqurt01" type="STRING"/>
          <Column id="oqurt01" type="STRING"/>
          <Column id="squrt01" type="STRING"/>
          <Column id="prequrtsum" type="STRING"/>
          <Column id="prequrtrate" type="STRING"/>
          <Column id="preyearqurtsum" type="STRING"/>
          <Column id="preyearqurtrate" 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_cmb_qurt" 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">1분기</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">2분기</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">3분기</Col>
            <Col id="value">3</Col>
          </Row>
          <Row>
            <Col id="label">4분기</Col>
            <Col id="value">4</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	KU2.0
 * Job Name 		:	
 * File Name 		:	SMAES04600_기능검사실통계(분기별).xfdl
 * 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.async       = false;
			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_TRAES04601(){//조회
			
			dsf_createDsRow("ds_req",
			[{col:"srchyyyy", val:grp_sea.ipt_toyear.value}
			,{col:"srchqurt", val:grp_sea.cmb_qurt.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 = "TRAES04601";
			oParam.service = "examcurestatsapp.FuntExam";
			oParam.method = "reqGetFuntExamStatsQurtList";
			oParam.inds = "req=ds_req";
			oParam.outds ="ds_grid_grd_list=item";
			oParam.async       = false;
			oParam.callback = "cbf_TRAES04601";
			
			tranf_submit(oParam);
}
function cbf_TRAES04601(sSvcId, objErrorCode, objErrorMsg){

}				
//---------------------------------------------------------------------------------------				
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------

/****************************************************************************************
 * Components	    : 
 * Components ID  : SMAES04600
 * Event 		    : onload
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function SMAES04600_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  // 화면공통
	lf_aezfSetSuppDeptcd();
			
		// 검사실
	f_TRAEA01115();					
	var tempto1 = utlf_getCurrentDate().substr(0,4);
	grp_sea.ipt_toyear.value = tempto1;		
	grp_sea.cmb_qurt.index = 0;
}

/****************************************************************************************
 * 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_TRAES04601();						
}

/****************************************************************************************
 * 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");
	}
}
/****************************************************************************************
 * Components	    : 
 * Components ID  : cmb_qurt
 * Event 		    : onitemchanged
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 조회분기에 따른 그리드 헤더 정보 변경
 ****************************************************************************************/
function grp_sea_cmb_qurt_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if(grp_sea.cmb_qurt.index == 0){
		grd_list.setCellProperty("head",3,"text","3월");
		grd_list.setCellProperty("head",4,"text","4월");
		grd_list.setCellProperty("head",5,"text","5월");
		grd_list.setCellProperty("head",6,"text","1/4분기");
	}else if(grp_sea.cmb_qurt.index == 1){
		grd_list.setCellProperty("head",3,"text","6월");
		grd_list.setCellProperty("head",4,"text","7월");
		grd_list.setCellProperty("head",5,"text","8월");
		grd_list.setCellProperty("head",6,"text","2/4분기");
	}else if(grp_sea.cmb_qurt.index == 2){
		grd_list.setCellProperty("head",3,"text","9월");
		grd_list.setCellProperty("head",4,"text","10월");
		grd_list.setCellProperty("head",5,"text","11월");
		grd_list.setCellProperty("head",6,"text","3/4분기");
	}else if(grp_sea.cmb_qurt.index == 3){
		grd_list.setCellProperty("head",3,"text","12월");
		grd_list.setCellProperty("head",4,"text","1월");
		grd_list.setCellProperty("head",5,"text","2월");
		grd_list.setCellProperty("head",6,"text","4/4분기");
	}
}
function grd_list_oncolresized(obj:Grid, e:GridSizeChangedEventInfo)
{
	if(e.newvalue == 0){
		obj.setRealColSize(e.subindex, 1);
	}


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