YNU_JEUS/app_home/himed/xpapps/ast/examcurestatsxp/xp/SMAES07000_기능검사실실시자검사건수.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES06600" position="absolute 0 0 1198 768" titletext="재활근전도 기능검사실 통계(월별)" oninit="SMAES06600_oninit" onload="SMAES06600_onload">
    <Layouts>
      <Layout>
        <Div id="grp_sea" taborder="1" class="div_SA" position="absolute 0 25 1195 61" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption2" text="조회기간 :" class="search_name" position="absolute 15 11 87 28" anchor="default"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1107 7 1113 29" anchor="top right"/>
              <Button id="btn_sea" taborder="3" text="조회" class="btn1" position="absolute 1125 8 1181 30" anchor="top right" onclick="grp_sea_btn_sea_onclick"/>
              <Calendar id="ipt_todd" taborder="4" class="input_default" position="absolute 199 8 284 29" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Static id="caption5" text="~" class="search_no_b" position="absolute 182 11 194 28" anchor="default"/>
              <Calendar id="ipt_fromdd" taborder="5" class="input_default" position="absolute 90 8 175 29" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Static id="caption9" text="검사실 :" class="search_name" position="absolute 620 11 678 28" anchor="default"/>
              <Combo id="cmb_excuroomcd" taborder="6" innerdataset="@ds_init_cmb_initexcuroom" codecolumn="basecd" datacolumn="basecdflagdesc" position="absolute 684 8 799 29" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" class="btn7" position="absolute 1027 32 1104 54" anchor="top right" onclick="btn_excsave_onclick"/>
        <Static id="caption6" text="기능검사실 실시자별 통계(월별)" class="tit_1" position="absolute 0 0 230 25"/>
        <Tab id="switch1" taborder="4" tabindex="0" scrollbars="autoboth" position="absolute 2 64 1192 749">
          <Tabpages>
            <Tabpage id="case1" text="검사실별">
              <Layouts>
                <Layout>
                  <Grid id="grd_list" taborder="0" binddataset="ds_main_list" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute -3 0 1188 645" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="270"/>
                          <Column size="62"/>
                          <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"/>
                        </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="합계"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" text="expr:currow+1"/>
                          <Cell col="1" celltype="none" style="align:left middle;" text="bind:prcpnm" wordwrap="word" suppress="1" suppressalign="middle,over"/>
                          <Cell col="2" text="bind:trnm"/>
                          <Cell col="3" displaytype="number" text="bind:month01"/>
                          <Cell col="4" displaytype="number" text="bind:month02"/>
                          <Cell col="5" displaytype="number" text="bind:month03"/>
                          <Cell col="6" displaytype="number" text="bind:month04"/>
                          <Cell col="7" displaytype="number" text="bind:month05"/>
                          <Cell col="8" displaytype="number" text="bind:month06"/>
                          <Cell col="9" displaytype="number" text="bind:month07"/>
                          <Cell col="10" displaytype="number" text="bind:month08"/>
                          <Cell col="11" displaytype="number" text="bind:month09"/>
                          <Cell col="12" displaytype="number" text="bind:month10"/>
                          <Cell col="13" displaytype="number" text="bind:month11"/>
                          <Cell col="14" displaytype="number" text="bind:month12"/>
                          <Cell col="15" displaytype="number" text="bind:monthsum"/>
                        </Band>
                        <Band id="summary">
                          <Cell colspan="2" style="align:center middle;background:#99ff99ff;" text="합          계" taborder="undefined"/>
                          <Cell col="2"/>
                          <Cell col="3" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month01&quot;)"/>
                          <Cell col="4" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month02&quot;)"/>
                          <Cell col="5" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month03&quot;)"/>
                          <Cell col="6" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month04&quot;)"/>
                          <Cell col="7" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month05&quot;)"/>
                          <Cell col="8" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month06&quot;)"/>
                          <Cell col="9" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month07&quot;)"/>
                          <Cell col="10" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month08&quot;)"/>
                          <Cell col="11" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month09&quot;)"/>
                          <Cell col="12" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month10&quot;)"/>
                          <Cell col="13" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month11&quot;)"/>
                          <Cell col="14" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month12&quot;)"/>
                          <Cell col="15" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;monthsum&quot;)"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case2" text="검사별">
              <Layouts>
                <Layout>
                  <Grid id="grd_list" taborder="0" binddataset="ds_mainexcucd_list" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute -3 0 1189 645" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="270"/>
                          <Column size="62"/>
                          <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"/>
                        </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="합계"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" text="expr:currow+1"/>
                          <Cell col="1" celltype="none" style="align:left middle;" text="bind:prcpnm" wordwrap="word" suppress="1" suppressalign="middle,over"/>
                          <Cell col="2" text="bind:trnm"/>
                          <Cell col="3" displaytype="number" text="bind:month01"/>
                          <Cell col="4" displaytype="number" text="bind:month02"/>
                          <Cell col="5" displaytype="number" text="bind:month03"/>
                          <Cell col="6" displaytype="number" text="bind:month04"/>
                          <Cell col="7" displaytype="number" text="bind:month05"/>
                          <Cell col="8" displaytype="number" text="bind:month06"/>
                          <Cell col="9" displaytype="number" text="bind:month07"/>
                          <Cell col="10" displaytype="number" text="bind:month08"/>
                          <Cell col="11" displaytype="number" text="bind:month09"/>
                          <Cell col="12" displaytype="number" text="bind:month10"/>
                          <Cell col="13" displaytype="number" text="bind:month11"/>
                          <Cell col="14" displaytype="number" text="bind:month12"/>
                          <Cell col="15" displaytype="number" text="bind:monthsum"/>
                        </Band>
                        <Band id="summary">
                          <Cell colspan="2" style="align:center middle;background:#99ff99ff;" text="합          계" taborder="undefined"/>
                          <Cell col="2"/>
                          <Cell col="3" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month01&quot;)"/>
                          <Cell col="4" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month02&quot;)"/>
                          <Cell col="5" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month03&quot;)"/>
                          <Cell col="6" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month04&quot;)"/>
                          <Cell col="7" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month05&quot;)"/>
                          <Cell col="8" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month06&quot;)"/>
                          <Cell col="9" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month07&quot;)"/>
                          <Cell col="10" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month08&quot;)"/>
                          <Cell col="11" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month09&quot;)"/>
                          <Cell col="12" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month10&quot;)"/>
                          <Cell col="13" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month11&quot;)"/>
                          <Cell col="14" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;month12&quot;)"/>
                          <Cell col="15" displaytype="number" style="background:#99ff99ff;" text="expr:getSum(&quot;monthsum&quot;)"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <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="trnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="execfromdd" type="STRING" size="256"/>
          <Column id="exectodd" type="STRING" size="256"/>
          <Column id="comparefromdd" type="STRING" size="256"/>
          <Column id="comparetodd" type="STRING" size="256"/>
          <Column id="excuroomcd" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="execfromdd"/>
            <Col id="exectodd"/>
            <Col id="comparefromdd"/>
            <Col id="comparetodd"/>
            <Col id="excuroomcd"/>
            <Col id="suppdeptcd"/>
            <Col id="ioflag">A</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instance1" 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"/>
      <Dataset id="ds_init_cmb_initexcuroomcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="excuroomnm" type="STRING"/>
          <Column id="excuroomcd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_mainexcucd_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <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="trnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="execfromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="exectodd"/>
      <BindItem id="item2" compid="grp_sea.cmb_excuroomcd" propid="value" datasetid="ds_send" columnid="excuroomcd"/>
    </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";
include "com_basiccodexp::ZBC001.xjs";
include "ast_examcurexp::AEZ0001.xjs";

/******************************************************************
 * Argument          : 
 * Description       : 초기화
 ******************************************************************/
function SMAES06600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAES06600_onload(obj:Form, e:LoadEventInfo)
{
	//기능검사실 실시자별 통계(월별)
	ds_send_globalinstance.setColumn(0, "instance1",     '2220000000');
	
	dsf_createDsRow("ds_temp_globalinstance",
					[{col:"basesuppdeptcd", type:"string", size:256, val:ds_send_globalinstance.getColumn(0, "instance1")}
					, {col:"rbasecdflag", type:"string", size:256, val:"R"}
					, {col:"ebasecdflag", type:"string", size:256, val:"E"}
					, {col:"largeclass", type:"string", size:256, val:"M4"}
					, {col:"cdgrupid", type:"string", size:256, val:"A0486"}
					, {col:"centflag", type:"string", size:256, val:""}], true);
	var oParam = {};
		oParam.id          = "TRAEA01115";
		oParam.service     = "examcureacptexecapp.ExamCureAcpt";
		oParam.method      = "reqGetInitFuncExamCureRoomList";
		oParam.inds        = "reqparam=ds_temp_globalinstance";
		oParam.outds       = "ds_init_cmb_initexcuroom=initexcuroom ds_init_cmb_initexcuroomcd=initexcuroomcd";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAEA01115";

	tranf_submit(oParam);
	
	var fromdd = utlf_getCurrentDate().substr(0,4) + "0101"
	var todd = utlf_getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
	
	dsf_addDsItem(ds_init_cmb_initexcuroomcd, "excuroomcd", "excuroomnm", "--전체--", "", "above");
	dsf_addDsItem(ds_init_cmb_initexcuroom, "basecd", "basecdflagdesc", "--전체--", "", "above");
	
	ds_main_list.clearData();
	ds_send.setColumn(0, "execfromdd", fromdd);
	ds_send.setColumn(0, "exectodd", todd);
}

/******************************************************************
 * Argument          : 
 * Description       : 조회 button event
 ******************************************************************/
function grp_sea_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
    //검사실별치료사
	ds_send.setColumn(0, "suppdeptcd", ds_send_globalinstance.getColumn(0, "instance1"));
	var oParam = {};
		oParam.id          = "TRAES07001";
		oParam.service     = "examcurestatsapp.FuntExam";
		oParam.method      = "reqGetFuntExamStatsTRList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAES06601";

	tranf_submit(oParam);
	
	
	//20181121 검사별치료사 통계	
	var oParam = {};
		oParam.id          = "TRAES07002";
		oParam.service     = "examcurestatsapp.FuntExam";
		oParam.method      = "reqGetFuntExamExcucdTRList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_mainexcucd_list=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAES06601";

	tranf_submit(oParam);
	
	
}

/******************************************************************
 * Argument          : 
 * Description       : Excel button event
 ******************************************************************/
function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	if(switch1.tabindex == 0){
		if( ds_main_list.rowcount > 0 ){
			grdf_exportExcel(switch1.case1.grd_list, "기능검사실별 실시자별 통계(월별)", "기능검사실 실시자별 통계(월별)", false, "", "user", false);
		} else {
			sysf_messageBox("조회된 데이터가 ", "I004");
		}
	}
	
	if(switch1.tabindex == 1){
		if( ds_mainexcucd_list.rowcount > 0 ){
			grdf_exportExcel(switch1.case2.grd_list, "기능검사별 실시자별 통계(월별)", "기능검사별 실시자별 통계(월별)", false, "", "user", false);
		} else {
			sysf_messageBox("조회된 데이터가 ", "I004");
		}
	}
		
		
}
]]></Script>
  </Form>
</FDL>