YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS03800_건진금액별건진건수현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS03800" classname="SMAHS03800" inheritanceid="" position="absolute 0 0 923 784" titletext="건진금액별건진건수현황" oninit="SMAHS03800_oninit" onload="SMAHS03800_onload">
    <Layouts>
      <Layout>
        <Div id="group2" anchor="left top right" taborder="0" class="div_SA" position="absolute 0 26 912 61">
          <Layouts>
            <Layout>
              <Shape id="line2" linetype="vertical" class="line_4" position="absolute 833 7 839 29" anchor="top right"/>
              <Button id="btn_search" taborder="8" text="조회" onclick="group2_btn_search_onclick" class="btn1" position="absolute 843 7 899 29" anchor="top right"/>
              <Combo id="cmb_healexamflag" taborder="9" autoselect="true" autoskip="true" innerdataset="@ds_init_codeinfo_A0068" codecolumn="cdid" datacolumn="cdnm" class="combo_search" position="absolute 233 9 313 28" anchor="left top" onitemchanged="group2_cmb_healexamflag_onitemchanged"/>
              <Static id="caption3" text="건진구분 :" class="search_name" position="absolute 152 10 225 27" anchor="left top"/>
              <Combo id="cmb_year" taborder="12" innerdataset="@ds_init_year" codecolumn="cdid" datacolumn="cdnm" onitemchanged="group2_cmb_year_onitemchanged" visible="true" position="absolute 68 8 136 27" enable="true" anchor="default"/>
              <Static id="caption00" text="연도 :" class="search_name" visible="true" position="absolute 11 10 84 27" anchor="default"/>
              <Button id="btn_excelsave" taborder="13" text="엑셀저장" onclick="group2_btn_excelsave_onclick" class="btn7" position="absolute 745 8 825 30" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption60" text="건진금액별 건진건수" class="tit_1" position="absolute 0 0 151 25" anchor="left top"/>
        <Grid id="grd_item" taborder="6" binddataset="ds_item" scrollbars="autoboth" useinputpanel="false" position="absolute 0 72 478 754">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="200"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="연도"/>
                <Cell col="1" text="월"/>
                <Cell col="2" text="금액대"/>
                <Cell col="3" text="인원수"/>
              </Band>
              <Band id="body">
                <Cell text="bind:year"/>
                <Cell col="1" text="bind:month"/>
                <Cell col="2" text="bind:totamt"/>
                <Cell col="3" text="bind:cnts"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_codeinfo_A0068" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="healexamflag" type="STRING" size="256"/>
          <Column id="year" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_codeinfo_P0167" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_grd_2016" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="month" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_2017" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_2018" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_2019" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_excel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="cnts" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_year" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_healexamflag" propid="value" datasetid="ds_send" columnid="healexamflag"/>
      <BindItem id="item3" compid="group2.cmb_year" propid="value" datasetid="ds_send" columnid="year"/>
    </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 "com_zipcodexp::ZBP001.xjs";

function SMAHS03800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS03800_onload(obj:Form, e:LoadEventInfo)
{	
	// 공통코드 조회
	var arrParam = [ {dsNm: "ds_init_codeinfo_A0068", cdGrpId: "A0068"}
					,{dsNm: "ds_init_codeinfo_P0167", cdGrpId: "P0167"}];
	zbcfGetCodeList(arrParam);
	
	ds_init_codeinfo_P0167.filter("cdid >= 2016");
	ds_init_year.copyData(ds_init_codeinfo_P0167, true);
	
	ds_send.setColumn(0, "healexamflag", "C");
	ds_send.setColumn(0, "year", "2019");
	
	//조회
	group2.btn_search.onclick.fireEvent(group2.btn_search, new ClickEventInfo);
}

//조회
function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS03801";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetStatAmtCnts";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_item=item";
		oParam.async       = false;
		oParam.callback    = "cf_TRAHS02501";
	tranf_submit(oParam);
}

function cf_TRAHS02501(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
	
	ds_grd_excel.copyData(ds_item, true);
}

function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_item, "건진금액별 건진건수 현황", "Sheet1", "true", "", "");
}

function group2_cmb_year_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	//조회
	group2.btn_search.onclick.fireEvent(group2.btn_search, new ClickEventInfo);
}

function group2_cmb_healexamflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	//조회
	group2.btn_search.onclick.fireEvent(group2.btn_search, new ClickEventInfo);
}
]]></Script>
  </Form>
</FDL>