YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS00100_패키지별실적현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS00100" position="absolute 0 0 1199 783" titletext="패키지별실적현황" oninit="SMAHS00100_oninit" onload="SMAHS00100_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="기간                           ~" position="absolute 15 12 229 29" id="caption2" class="search_name" anchor="default"/>
              <Shape position="absolute 1115 10 1121 32" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1125 10 1181 32" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Calendar position="absolute 58 11 178 30" id="ipt_fromdd" class="input_default" taborder="1" anchor="default" autoselect="true" autoskip="true"/>
              <Calendar position="absolute 209 11 329 30" id="input1" class="input_default" taborder="2" anchor="default" autoselect="true" autoskip="true"/>
              <Combo position="absolute 560 11 660 30" id="cmb_srchhealexamdetlflag" class="combo_search" innerdataset="@ds_init_baseinfo_healexamdetlflaglist_A0070" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
              <Combo position="absolute 440 11 550 30" id="cmb_srchhealexamflag" class="combo_search" innerdataset="@ds_init_baseinfo_healexamflaglist_A0068" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="group2_cmb_srchhealexamflag_onitemchanged"/>
              <Static text="상태 :" position="absolute 678 12 732 29" id="caption3" class="search_name" anchor="default"/>
              <cp_checkboxList id="ckb_statflag" titletext="CheckBox List" taborder="3" scrollbars="none" position="absolute 730 0 1090 32" style="background:transparent; " col="1" row="1" cellspacing="2" vcellspacing="0" itemWidth="100" itemHeight="20" overflow="visible"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 0 96 1195 773" align="align:center middle;" id="grd_pkglist" binddataset="ds_main_pkglist" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="40"/>
                <Column size="110"/>
                <Column size="200"/>
                <Column size="100"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="40"/>
                <Column size="87"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" colspan="2" text="패키지코드" taborder="undefined"/>
                <Cell col="3" text="패키지명"/>
                <Cell col="4" text="금액"/>
                <Cell col="5" text="1월"/>
                <Cell col="6" text="2월"/>
                <Cell col="7" text="3월"/>
                <Cell col="8" text="4월"/>
                <Cell col="9" text="5월"/>
                <Cell col="10" text="6월"/>
                <Cell col="11" text="7월"/>
                <Cell col="12" text="8월"/>
                <Cell col="13" text="9월"/>
                <Cell col="14" text="10월"/>
                <Cell col="15" text="11월"/>
                <Cell col="16" text="12월"/>
                <Cell col="17" text="패키지별건수"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" displaytype="combo" style="align:center middle;" text="bind:cmpyflag" combodataset="ds_cmb_cmpyflag" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:pkgcd"/>
                <Cell col="3" style="align:left middle;padding:0 0 0 3;" text="bind:pkgnm"/>
                <Cell col="4" displaytype="number" text="bind:pkgamt"/>
                <Cell col="5" text="bind:jan"/>
                <Cell col="6" text="bind:feb"/>
                <Cell col="7" text="bind:scnd"/>
                <Cell col="8" text="bind:apr"/>
                <Cell col="9" text="bind:may"/>
                <Cell col="10" text="bind:jun"/>
                <Cell col="11" text="bind:jul"/>
                <Cell col="12" text="bind:aug"/>
                <Cell col="13" text="bind:sep"/>
                <Cell col="14" text="bind:oct"/>
                <Cell col="15" text="bind:nov"/>
                <Cell col="16" text="bind:dec"/>
                <Cell col="17" text="bind:pkgcnt"/>
              </Band>
              <Band id="summary">
                <Cell style="background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                <Cell col="1" style="background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                <Cell col="2" style="background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                <Cell col="3" style="background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                <Cell col="4" style="background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                <Cell col="5" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('jan')"/>
                <Cell col="6" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('feb')"/>
                <Cell col="7" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('scnd')"/>
                <Cell col="8" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('apr')"/>
                <Cell col="9" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('may')"/>
                <Cell col="10" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('jun')"/>
                <Cell col="11" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('jul')"/>
                <Cell col="12" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('aug')"/>
                <Cell col="13" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('sep')"/>
                <Cell col="14" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('oct')"/>
                <Cell col="15" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('nov')"/>
                <Cell col="16" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('dec')"/>
                <Cell col="17" displaytype="text" style="align:center middle;background:#7cbbddff;background2:#7cbbddff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('pkgcnt')"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="건진구분 :" position="absolute 350 38 436 55" id="caption1" class="search_name"/>
        <Button position="absolute 1114 75 1194 94" id="button1" class="btn7" text="엑셀저장" anchor="top right" onclick="button1_onclick"/>
        <Button position="absolute 1055 75 1113 94" id="button2" class="btn6" visible="true" text="출력" anchor="top right" onclick="button2_onclick"/>
        <Static id="caption60" text="패키지별실적현황" class="tit_1" position="absolute 0 0 183 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <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="srchhealexamflag" type="STRING" size="256"/>
          <Column id="srchhealexamdetlflag" type="STRING" size="256"/>
          <Column id="srchstatflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchfromdd"/>
            <Col id="srchtodd"/>
            <Col id="srchhealexamflag"/>
            <Col id="srchhealexamdetlflag"/>
            <Col id="srchstatflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_pkglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmpyflag" type="STRING" size="256" sumtext="단체구분"/>
          <Column id="pkgcd" type="STRING" size="256" sumtext="pkg코드"/>
          <Column id="pkgnm" type="STRING" size="256" sumtext="pkg명"/>
          <Column id="pkgamt" type="STRING" size="256" sumtext="pkg금액"/>
          <Column id="jan" type="STRING" size="256" sumtext="1월"/>
          <Column id="feb" type="STRING" size="256" sumtext="2월"/>
          <Column id="scnd" type="STRING" size="256" sumtext="3월"/>
          <Column id="apr" type="STRING" size="256" sumtext="4월"/>
          <Column id="may" type="STRING" size="256" sumtext="5월"/>
          <Column id="jun" type="STRING" size="256" sumtext="6월"/>
          <Column id="jul" type="STRING" size="256" sumtext="7월"/>
          <Column id="aug" type="STRING" size="256" sumtext="8월"/>
          <Column id="sep" type="STRING" size="256" sumtext="9월"/>
          <Column id="oct" type="STRING" size="256" sumtext="10월"/>
          <Column id="nov" type="STRING" size="256" sumtext="11월"/>
          <Column id="dec" type="STRING" size="256" sumtext="12월"/>
          <Column id="pkgcnt" type="STRING" size="256" sumtext="pkg별건수"/>
          <Column id="pkgavgamt" type="STRING" size="256" sumtext="pkg평균금액"/>
          <Column id="pkgtotamt" type="STRING" size="256" sumtext="pkg총금액"/>
          <Column id="pkgdiscamt" type="STRING" size="256" sumtext="pkg할인금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_cmpyflag" 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">개인</Col>
            <Col id="value">N</Col>
          </Row>
          <Row>
            <Col id="label">단체</Col>
            <Col id="value">Y</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_baseinfo_healexamflaglist_A0068" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_healexamdetlflaglist_A0070" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_statflaglist_A0107" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_healexamdetlflaglist1_A0069" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
      <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_send" columnid="srchtodd"/>
      <BindItem id="item2" compid="group2.cmb_srchhealexamflag" propid="value" datasetid="ds_send" columnid="srchhealexamflag"/>
      <BindItem id="item3" compid="group2.cmb_srchhealexamdetlflag" 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";

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

function SMAHS00100_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_pkglist);
	
	var arrParam = [{dsNm: "ds_init_baseinfo_healexamflaglist_A0068", cdGrpId: "A0068"}
				   ,{dsNm: "ds_init_baseinfo_healexamdetlflaglist_A0070", cdGrpId: "A0070"}
				   ,{dsNm: "ds_init_baseinfo_statflaglist_A0107", cdGrpId: "A0107"}
				   ,{dsNm: "ds_init_baseinfo_healexamdetlflaglist1_A0069", cdGrpId: "A0069"}]
	appf_getCodeList(arrParam); 
	
	ds_send.setColumn(0, "srchfromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "srchtodd", utlf_getCurrentDate());
	
	var sProp="col=5,row=2,cellspacing=4,vcellspacing=0,itemWidth=-1,itemHeight=20,overflow='visible'";
	group2.ckb_statflag.setInitComp(sProp, ds_init_baseinfo_statflaglist_A0107,"cdid","cdnm","fn_cmpEvent");
	
	frmf_addComboItem("group2.cmb_srchhealexamflag","전체","","above");
	frmf_addComboItem("group2.cmb_srchhealexamdetlflag","전체","","above");
	
	group2.ipt_fromdd.setFocus();
}

function fn_cmpEvent()
{
	var rtn = group2.ckb_statflag.getData();trace(rtn)
	rtn = String(rtn).replace(",", " ");
	ds_send.setColumn(0, "srchstatflag", rtn);
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var stat = ds_send.getColumn(0, "srchstatflag");
	
	var j = 1;

	if(!utlf_isNull(stat) || stat != "" || stat != " ")
	{
		stat = stat.split(" ");
		
		for(var i = 0; i < stat.length; i++)
		{
			dsf_makeValue(ds_send,"srchstatflag"+ j, "string" , stat[i]);
			j = j+1;
		}
	}

	var oParam = {};
		oParam.id          = "TRA20HS00101";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetPkgStats";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_pkglist=pkglist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS00101";

	tranf_submit(oParam);
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_pkglist, "excel", "SheetName", "true", "", "");
}

function group2_cmb_srchhealexamflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if(obj.value == "C")
	{
		group2.cmb_srchhealexamdetlflag.innerdataset = "ds_init_baseinfo_healexamdetlflaglist1_A0069";
		group2.cmb_srchhealexamdetlflag.datacolumn = "cdnm";
		group2.cmb_srchhealexamdetlflag.codecolumn = "cdid";
	}
	else if(obj.value == "G")
	{
		group2.cmb_srchhealexamdetlflag.innerdataset = "ds_init_baseinfo_healexamdetlflaglist_A0070";
		group2.cmb_srchhealexamdetlflag.datacolumn = "cdnm";
		group2.cmb_srchhealexamdetlflag.codecolumn = "cdid";
	}
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/pkglist", ds_main_pkglist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
		objParam.srchfromdd = String(ds_send.getColumn(0, "srchfromdd")).toDate().getDateFormat("YYYY/MM/DD");
		objParam.srchtodd = String(ds_send.getColumn(0, "srchtodd")).toDate().getDateFormat("YYYY/MM/DD");
	
	var option = ""; 
	rptf_exeReportPreview30(["RPAHS00101"],[objParam], option);
}
]]></Script>
  </Form>
</FDL>