YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS02200_평생고객관리코드.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS02200" position="absolute 0 0 1211 750" titletext="기간별 평생건강관리 현황" oninit="SMAHS02200_oninit" onload="SMAHS02200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1211 23" id="group3">
          <Layouts>
            <Layout>
              <Static text="기간별 평생건강관리 현황" position="absolute 0 0 188 23" align="align:center middle;" id="caption60" class="tit_1" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 4 23 1207 58" id="group2" class="div_SA">
          <Layouts>
            <Layout>
              <Static text="기간                           ~" position="absolute 15 9 213 26" id="caption2" class="search_name"/>
              <Shape position="absolute 1129 7 1135 29" linetype="vertical" id="line2" class="line_4"/>
              <Button position="absolute 1139 7 1195 29" id="btn_search" class="btn1" text="조회" onclick="group2_btn_search_onclick"/>
              <Calendar position="absolute 60 8 180 27" id="ipt_fromdd" class="input_default" taborder="7"/>
              <Calendar position="absolute 200 8 320 27" id="ipt_todd" class="input_default" taborder="7"/>
              <Button position="absolute 1045 8 1125 30" id="btn_excelsave" class="btn7" text="액셀저장" onclick="group2_btn_excelsave_onclick"/>
              <Button position="absolute 975 8 1031 30" id="btn_prt" class="btn6" visible="true" text="출력" onclick="group2_btn_prt_onclick"/>
              <Shape position="absolute 1035 7 1041 29" linetype="vertical" id="line3" class="line_4" visible="false"/>
              <Static text="검사코드 :" position="absolute 360 10 446 27" id="caption3" class="search_name"/>
              <Combo position="absolute 438 8 548 27" id="cmb_srchhealexamflag" class="combo_search" innerdataset="@ds_init_baseinfo_healexamtestcdlist_S200" datacolumn="cdnm" codecolumn="cdid"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 5 90 395 405" id="grd_earnlst" binddataset="ds_main_item2">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </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:testcd"/>
                <Cell col="1" text="bind:cnt"/>
                <Cell col="2" displaytype="number" text="bind:amt" mask="#,###"/>
                <Cell col="3" displaytype="number" text="bind:sumamt" mask="#,###"/>
              </Band>
              <Band id="summary">
                <Cell style="align:left;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                <Cell col="1" displaytype="number" style="align:left;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" expr="expr:getSum('cnt')" mask="#,##9"/>
                <Cell col="2" displaytype="number" style="align:left;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" mask="#,##9"/>
                <Cell col="3" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" expr="expr:getSum('sumamt')" mask="#,##9"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid position="absolute 5 437 395 740" id="datagrid1" binddataset="ds_main_item3">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="59"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell text="금액"/>
                <Cell col="1" text="고객수"/>
                <Cell col="2" text="금액별단가"/>
                <Cell col="3" text="총비용"/>
                <Cell col="4" text="비적용고객수"/>
              </Band>
              <Band id="body">
                <Cell text="bind:testnm"/>
                <Cell col="1" text="bind:cnt"/>
                <Cell col="2" displaytype="number" text="bind:testamt" mask="#,###"/>
                <Cell col="3" displaytype="number" text="bind:sumamt" mask="#,###"/>
                <Cell col="4" displaytype="number" text="bind:nullcnt" mask="#,###"/>
              </Band>
              <Band id="summary">
                <Cell style="align:left;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                <Cell col="1" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" expr="expr:getSum('cnt')" mask="#,##9"/>
                <Cell col="2" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" mask="#,##9"/>
                <Cell col="3" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" expr="expr:getSum('sumamt')" mask="#,##9"/>
                <Cell col="4" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" expr="expr:getSum('nullcnt')" mask="#,##9"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid position="absolute 400 90 1206 740" id="datagrid2" binddataset="ds_main_item1">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
              </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="코드"/>
                <Cell col="4" text="패키지코드"/>
                <Cell col="5" text="패키지명"/>
                <Cell col="6" text="단체여부"/>
                <Cell col="7" text="단체명"/>
                <Cell col="8" text="본인부담금"/>
                <Cell col="9" text="단체부담금"/>
              </Band>
              <Band id="body">
                <Cell text="bind:pid"/>
                <Cell col="1" text="bind:hngnm"/>
                <Cell col="2" text="bind:hopedd"/>
                <Cell col="3" text="bind:testcd"/>
                <Cell col="4" text="bind:pkgcd"/>
                <Cell col="5" text="bind:pkgnm"/>
                <Cell col="6" text="bind:cmpyflag"/>
                <Cell col="7" text="bind:cmpynm"/>
                <Cell col="8" displaytype="number" text="bind:ownbamt" mask="#,###"/>
                <Cell col="9" displaytype="number" text="bind:cmpyamt" mask="#,###"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="코드별 통계" position="absolute 5 65 107 81" id="caption1" class="tit_2"/>
        <Shape position="absolute 5 82 395 88" linetype="horizontal" id="line1" class="line_10"/>
        <Static text="건진자 현황" position="absolute 400 65 502 81" id="caption4" class="tit_2"/>
        <Shape position="absolute 400 82 1206 88" linetype="horizontal" id="line4" class="line_10"/>
        <Static text="금액별 고객" position="absolute 5 415 107 431" id="caption5" class="tit_2"/>
        <Shape position="absolute 5 432 395 438" linetype="horizontal" id="line5" class="line_10"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_baseinfo_healexamtestcdlist_S200" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING"/>
          <Column id="cdid" type="STRING"/>
        </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="srchfromdd" type="STRING" size="256" sumtext="시작일자"/>
          <Column id="srchtodd" type="STRING" size="256" sumtext="종료일자"/>
          <Column id="srchtestcd" type="STRING" size="256" sumtext="검사코드"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_item1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="hngnm" type="STRING" size="256" sumtext="고객명"/>
          <Column id="hopedd" type="STRING" size="256" sumtext="건진일"/>
          <Column id="testcd" type="STRING" size="256" sumtext="검사코드"/>
          <Column id="pkgcd" type="STRING" size="256" sumtext="패키지코드"/>
          <Column id="pkgnm" type="STRING" size="256" sumtext="패키지명"/>
          <Column id="cmpyflag" type="STRING" size="256" sumtext="단체여부"/>
          <Column id="cmpynm" type="STRING" size="256" sumtext="단체명"/>
          <Column id="ownbamt" type="STRING" size="256" sumtext="본인부담금"/>
          <Column id="cmpyamt" type="STRING" size="256" sumtext="단체부담금"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_item2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="testcd" type="STRING" size="256" sumtext="평생고객코드"/>
          <Column id="codenm" type="STRING" size="256" sumtext="코드명"/>
          <Column id="cnt" type="STRING" size="256" sumtext="고객수"/>
          <Column id="amt" type="STRING" size="256" sumtext="관리단가"/>
          <Column id="sumamt" type="STRING" size="256" sumtext="총금액"/>
          <Column id="sortseq" type="STRING" size="256" sumtext="정렬"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_item3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="testnm" type="STRING" size="256" sumtext="테스트명"/>
          <Column id="cnt" type="STRING" size="256" sumtext="고객수"/>
          <Column id="nullcnt" type="STRING" size="256" sumtext="비적용고객수"/>
          <Column id="testamt" type="STRING" size="256" sumtext="관리단가"/>
          <Column id="sumamt" type="STRING" size="256" sumtext="총금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_export" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
      <BindItem id="item1" compid="group2.ipt_todd" propid="value" datasetid="ds_send" columnid="srchtodd"/>
      <BindItem id="item2" compid="group2.cmb_srchhealexamflag" propid="value" datasetid="ds_send" columnid="srchtestcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	ast_healexamstatxp -> SMAHS02200
 * Creator			:	yjh
 * Make Date 		:	2018-02-27
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2018-02-27		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/


//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "ast_healthexambasexp::healcombolist.xjs";


//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------



//=======================================================================================
// Function
//---------------------------------------------------------------------------------------



//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Components ID	: SMAHS02200
 * Event			: oninit
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 처음 초기화시
 ****************************************************************************************/
function SMAHS02200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

/****************************************************************************************
 * Components		: Form
 * Components ID	: SMAHS02200
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SMAHS02200_onload(obj:Form, e:LoadEventInfo)
{
	var cur_date = new Date();
	var from_date = (cur_date.getAddDate(-1, 'M')).getDateFormat();
	group2.ipt_fromdd.value = from_date;
	group2.ipt_todd.value = utlf_getCurrentDate();
	
	var arrParam = [{dsNm: "ds_init_baseinfo_healexamtestcdlist_S200", cdGrpId: "S200"}]
    healGetCodeList(arrParam);
    
    dsf_setDefaultVal(ds_init_baseinfo_healexamtestcdlist_S200, "all");
    group2.cmb_srchhealexamflag.index = 0;
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_search
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 조회버튼 클릭시
 ****************************************************************************************/
function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS00201";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetPyungSangStats";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_item1=item1 ds_main_item2=item2 ds_main_item3=item3";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS00201";

	tranf_submit(oParam);
	
// 	grd_earnlst.subtotalPosition = "below";						
// 	grd_earnlst.multiTotals = true;
// 	grd_earnlst.subtotal("clear", 0, 12);
// 	grd_earnlst.subtotal("sum", -1 , 1 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_earnlst.colRef("testcd") , "총계" );																
// 	grd_earnlst.subtotal("sum", -1 , 3 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_earnlst.colRef("testcd") , "총계" );																
// 
// 	datagrid1.subtotalPosition = "below";						
// 	datagrid1.multiTotals = true;
// 	datagrid1.subtotal("clear", 0, 12);
// 	datagrid1.subtotal("sum", -1 , 1 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", datagrid1.colRef("testnm") , "총계" );																
// 	datagrid1.subtotal("sum", -1 , 3 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", datagrid1.colRef("testnm") , "총계" );																
// 	datagrid1.subtotal("sum", -1 , 4 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", datagrid1.colRef("testnm") , "총계" );																
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_excelsave
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 엑셀저장버튼 클릭시
 ****************************************************************************************/
function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(datagrid2, "excel", "SheetName", false, "", "user", false);
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_prt
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 출력버튼 클릭시
 ****************************************************************************************/
function group2_btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_export.setColumn(0, "srchfromdd" , ds_send.getColumn(0, "srchfromdd").toDate().getDateFormat("YYYY/MM/DD"));
	ds_main_export.setColumn(0, "srchtodd" , ds_send.getColumn(0, "srchtodd").toDate().getDateFormat("YYYY/MM/DD"));
	
	var objDOM = rptf_createDOM();				                													// DOM 객체 설정	
	rptf_setNodeListToDOM(objDOM, "/root/main/item2", ds_main_item2);									// 데이터셋 1
	rptf_setNodeListToDOM(objDOM, "/root/main/item3", ds_main_item3);									// 데이터셋 1
	
	var objParam = new Object();
		objParam.srchfromdd = ds_main_export.getColumn(0, "srchfromdd");													// 최상의노드 XML 스트링 추출
		objParam.srchtodd = ds_main_export.getColumn(0, "srchtodd");													// 최상의노드 XML 스트링 추출
		objParam.xml_data_XML1 = objDOM.documentElement.source;													// 최상의노드 XML 스트링 추출
		
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
	
	rptf_exeReportPreview30(["RPAHS02201"],[objParam], option);
}
]]></Script>
  </Form>
</FDL>