YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS02500_패키지별건진현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS02500" position="absolute 0 0 1211 784" titletext="패키지별검진현황" oninit="SMAHS02500_oninit" onload="SMAHS02500_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 26 1209 61" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="건진일자 :" position="absolute 5 9 82 26" id="caption2" class="search_name" anchor="left top"/>
              <Shape position="absolute 1129 7 1135 29" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1139 7 1195 29" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Combo position="absolute 435 8 585 27" id="cmb_healexamdetlflag" class="combo_search" innerdataset="@ds_init_base_healexamdetlflag_item" datacolumn="cdnm" codecolumn="cdid" anchor="left top" index="-1" autoselect="true" autoskip="true"/>
              <Static text="건진구분 :" position="absolute 354 9 427 26" id="caption3" class="search_name" anchor="left top"/>
              <Calendar position="absolute 219 8 340 27" id="ipt_todd" class="input_search" taborder="7" anchor="left top" autoselect="true" autoskip="true"/>
              <Calendar position="absolute 81 8 202 27" id="ipt_fromdd" class="input_search" taborder="7" anchor="left top" autoselect="true" autoskip="true"/>
              <Static id="caption1" position="absolute 207 11 220 28" text="~" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 1 88 527 779" id="grd_pkgspeclst" binddataset="ds_main_pkgspeclst_item" anchor="left top bottom" autofittype="col" cellsizingtype="col" oncelldblclick="grd_pkgspeclst_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="100"/>
                <Column size="260"/>
                <Column size="50"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </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="pkgcd"/>
                <Cell col="5" text="healexamflag"/>
                <Cell col="6" text="healexamdetlflag"/>
                <Cell col="7" text="fromdd"/>
                <Cell col="8" text="todd"/>
              </Band>
              <Band id="body">
                <Cell style="align:left middle;" text="bind:healexamflagnm"/>
                <Cell col="1" style="align:left middle;" text="bind:pkgnm"/>
                <Cell col="2" style="align:left middle;" text="bind:pkgcnt"/>
                <Cell col="3" style="align:left middle;" text="bind:pkgamt"/>
                <Cell col="4" text="bind:pkgcd"/>
                <Cell col="5" text="bind:healexamflag"/>
                <Cell col="6" text="bind:healexamdetlflag"/>
                <Cell col="7" text="bind:fromdd"/>
                <Cell col="8" text="bind:todd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid position="absolute 534 88 1207 779" id="grd_pkgdetllst" binddataset="ds_main_pkgdetllst_item" anchor="all" autofittype="col" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="60"/>
                <Column size="270"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="등록번호"/>
                <Cell col="2" text="성명"/>
                <Cell col="3" text="성별"/>
                <Cell col="4" text="거래처명"/>
                <Cell col="5" text="건진일"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow + 1"/>
                <Cell col="1" style="align:left middle;" text="bind:pid"/>
                <Cell col="2" style="align:left middle;" text="bind:hngnm"/>
                <Cell col="3" text="bind:sex"/>
                <Cell col="4" style="align:left middle;" text="bind:pkgnm"/>
                <Cell col="5" displaytype="date" edittype="date" text="bind:hopedd" mask="yyyy-MM-dd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button position="absolute 450 63 527 82" id="btn_excsave" class="btn7" text="엑셀저장" anchor="left top" onclick="btn_excsave_onclick"/>
        <Shape position="absolute 0 83 527 89" linetype="horizontal" id="line1" class="line_10" anchor="left top"/>
        <Button position="absolute 1130 63 1207 82" id="button1" class="btn7" text="엑셀저장" anchor="top right" onclick="button1_onclick"/>
        <Shape position="absolute 534 83 1207 89" linetype="horizontal" id="line3" class="line_10" anchor="left top right"/>
        <Static id="caption60" text="패키지별검진현황" class="tit_1" position="absolute 0 0 151 25" anchor="left top"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_base_healexamdetlflag_item" 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_main_pkgspeclst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="healexamflagnm" type="STRING"/>
          <Column id="pkgnm" type="STRING"/>
          <Column id="pkgcnt" type="STRING"/>
          <Column id="pkgamt" type="STRING"/>
          <Column id="pkgcd" type="STRING"/>
          <Column id="healexamflag" type="STRING"/>
          <Column id="healexamdetlflag" type="STRING"/>
          <Column id="fromdd" type="STRING"/>
          <Column id="todd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_pkgdetllst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="pid" type="STRING"/>
          <Column id="hngnm" type="STRING"/>
          <Column id="sex" type="STRING"/>
          <Column id="pkgnm" type="STRING"/>
          <Column id="hopedd" 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"/>
          <Column id="srchtodd" type="STRING" size="256"/>
          <Column id="srchhealexamdetlflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_codeinfo_A0068" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_codeinfo_A0069" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_codeinfo_A0070" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_detl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="healexamflag" type="STRING" size="256" sumtext="건진구분"/>
          <Column id="healexamdetlflag" type="STRING" size="256" sumtext="건진상세구분"/>
          <Column id="pkgcd" type="STRING" size="256" sumtext="패키지코드"/>
          <Column id="fromdd" type="STRING" size="256" sumtext="조회시작일자"/>
          <Column id="todd" type="STRING" size="256" sumtext="조회종료일자"/>
        </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_healexamdetlflag" propid="value" datasetid="ds_send" columnid="srchhealexamdetlflag"/>
    </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 SMAHS02500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS02500_onload(obj:Form, e:LoadEventInfo)
{
	ds_send.setColumn(0, "srchfromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "srchtodd", utlf_getCurrentDate());
	
	// 공통코드 조회
	
	var arrParam = [ {dsNm: "ds_init_codeinfo_A0068", cdGrpId: "A0068"}
	                ,{dsNm: "ds_init_codeinfo_A0069", cdGrpId: "A0069"}
	                ,{dsNm: "ds_init_codeinfo_A0070", cdGrpId: "A0070"}];
	zbcfGetCodeList(arrParam);
	
	ds_init_base_healexamdetlflag_item.copyData(ds_init_codeinfo_A0070);
	
	ds_init_base_healexamdetlflag_item.insertRow(0);
	ds_init_base_healexamdetlflag_item.setColumn(0, "cdid", "");
	ds_init_base_healexamdetlflag_item.setColumn(0, "cdnm", "-전 체-");
	ds_send.setColumn(0, "srchhealexamdetlflag", "");
}

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

}

function grd_pkgspeclst_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	if(ds_main_pkgspeclst_item.rowposition > 0)
	{
		ds_send_detl.setColumn(0, "healexamflag",		ds_main_pkgspeclst_item.getColumn(ds_main_pkgspeclst_item.rowposition, "healexamflag"));
		ds_send_detl.setColumn(0, "healexamdetlflag",	ds_main_pkgspeclst_item.getColumn(ds_main_pkgspeclst_item.rowposition, "healexamdetlflag"));
		ds_send_detl.setColumn(0, "pkgcd",				ds_main_pkgspeclst_item.getColumn(ds_main_pkgspeclst_item.rowposition, "pkgcd"));
		ds_send_detl.setColumn(0, "fromdd",				ds_main_pkgspeclst_item.getColumn(ds_main_pkgspeclst_item.rowposition, "fromdd"));
		ds_send_detl.setColumn(0, "todd",				ds_main_pkgspeclst_item.getColumn(ds_main_pkgspeclst_item.rowposition, "todd"));

		
		var oParam = {};
			oParam.id          = "TRAHS02502";
			oParam.service     = "healexamstatapp.StatRef";
			oParam.method      = "reqGetPkgSpecDetlList";
			oParam.inds        = "req=ds_send_detl";
			oParam.outds       = "ds_main_pkgdetllst_item=item";
			oParam.async       = false;
			//oParam.callback    = "cf_TRAHS02502";
		tranf_submit(oParam);
	}
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_pkgspeclst, "Excel", "sheet1", false);
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_pkgdetllst, "Excel", "sheet1", false);
}
]]></Script>
  </Form>
</FDL>