YNU_JEUS/app_home/himed/xpapps/ast/hsctstemcellxp/xp/SMABS10900_조혈모세포출고현황통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMABS10900" position="absolute 0 0 1196 763" titletext="조혈모세포 출고 현황" onload="SMABS10900_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 51 1194 762" id="grp_biz" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout>
              <Static text="조혈모세포 출고 현황" position="absolute 0 73 210 90" id="caption1" class="tit_2" anchor="default"/>
              <Shape position="absolute 0 89 1194 95" id="line1" class="line_10" anchor="left top right"/>
              <Button position="absolute 1114 67 1194 89" id="button2" class="btn7" text="엑셀저장" anchor="top right" onclick="grp_biz_button2_onclick"/>
              <Div position="absolute 0 0 1194 60" align="align:center top;" id="grp_sea" class="div_SA2" anchor="left top right">
                <Layouts>
                  <Layout>
                    <Static text="기간(출고일) :" position="absolute 15 9 127 26" id="caption4" class="search_name" anchor="default"/>
                    <Static text="~" position="absolute 241 10 253 27" id="caption7" class="search_no_b" anchor="default"/>
                    <Button position="absolute 1123 20 1179 42" id="button3" class="btn1" text="조회" anchor="top right" onclick="grp_biz_grp_sea_button3_onclick"/>
                    <Shape position="absolute 1104 12 1110 50" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
                    <Calendar position="absolute 130 8 238 27" id="input2" class="input_essential" anchor="default"/>
                    <Calendar position="absolute 256 8 364 27" id="input3" class="input_essential" anchor="default"/>
                    <Static text="출고장소 :" position="absolute 468 9 554 26" id="caption8" class="search_name" anchor="default"/>
                    <Combo position="absolute 557 8 687 27" id="combo2" class="combo_search" innerdataset="@ds_init_cmbinfo_deliveflag_A0157" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
                    <Static text="비교(츨고일) :" position="absolute 15 35 127 52" id="caption9" class="search_name" anchor="default"/>
                    <Calendar position="absolute 130 34 238 53" id="input1" class="input_essential" anchor="default"/>
                    <Static text="~" position="absolute 241 36 253 53" id="caption2" class="search_no_b" anchor="default"/>
                    <Calendar position="absolute 256 34 364 53" id="input4" class="input_essential" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Grid position="absolute 0 94 1194 710" align="align:center middle;" id="grd_cellinoutlist" binddataset="ds_main_cellinout_cellinoutlist" anchor="all" cellsizingtype="col" selecttype="multirow">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="88"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="63"/>
                      <Column size="100"/>
                      <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="1월"/>
                      <Cell col="3" text="2월"/>
                      <Cell col="4" text="3월"/>
                      <Cell col="5" text="4월"/>
                      <Cell col="6" text="5월"/>
                      <Cell col="7" text="6월"/>
                      <Cell col="8" text="7월"/>
                      <Cell col="9" text="8월"/>
                      <Cell col="10" text="9월"/>
                      <Cell col="11" text="10월"/>
                      <Cell col="12" text="11월"/>
                      <Cell col="13" text="12월"/>
                      <Cell col="14" text="Total"/>
                      <Cell col="15" text="전년도"/>
                      <Cell col="16" text="증감율"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" text="expr:currow+1"/>
                      <Cell col="1" displaytype="text" edittype="none" text="bind:codenm"/>
                      <Cell col="2" edittype="none" text="bind:monthcnt01"/>
                      <Cell col="3" text="bind:monthcnt02"/>
                      <Cell col="4" text="bind:monthcnt03"/>
                      <Cell col="5" text="bind:monthcnt04"/>
                      <Cell col="6" text="bind:monthcnt05"/>
                      <Cell col="7" text="bind:monthcnt06"/>
                      <Cell col="8" text="bind:monthcnt07"/>
                      <Cell col="9" text="bind:monthcnt08"/>
                      <Cell col="10" text="bind:monthcnt09"/>
                      <Cell col="11" text="bind:monthcnt10"/>
                      <Cell col="12" text="bind:monthcnt11"/>
                      <Cell col="13" text="bind:monthcnt12"/>
                      <Cell col="14" text="bind:monthcnttotal"/>
                      <Cell col="15" text="bind:beforeyearcnt"/>
                      <Cell col="16" text="bind:cntaddper"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 25 1195 53" id="grp_btn" anchor="left top right">
          <Layouts>
            <Layout>
              <Button position="absolute 0 1 56 23" id="btn_prt" class="btn6" text="출력" anchor="default" visible="false"/>
              <Shape id="line9" class="line_6" position="absolute 0 22 1195 28" anchor="left top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="조혈모세포 출고 현황" class="tit_1" position="absolute 0 0 210 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_cmbinfo_deliveflag_A0157" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid"/>
            <Col id="cdnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="hidden" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="delivefromdd" type="STRING" size="256"/>
          <Column id="delivetodd" type="STRING" size="256"/>
          <Column id="delivefromdd2" type="STRING" size="256"/>
          <Column id="delivetodd2" type="STRING" size="256"/>
          <Column id="deliveflag" type="STRING" size="256"/>
          <Column id="searchflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="delivefromdd"/>
            <Col id="delivetodd"/>
            <Col id="delivefromdd2"/>
            <Col id="delivetodd2"/>
            <Col id="deliveflag"/>
            <Col id="searchflag">O</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_cellinout_cellinoutlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="codenm" type="STRING" size="256"/>
          <Column id="monthcnt01" type="STRING" size="256"/>
          <Column id="monthcnt02" type="STRING" size="256"/>
          <Column id="monthcnt03" type="STRING" size="256"/>
          <Column id="monthcnt04" type="STRING" size="256"/>
          <Column id="monthcnt05" type="STRING" size="256"/>
          <Column id="monthcnt06" type="STRING" size="256"/>
          <Column id="monthcnt07" type="STRING" size="256"/>
          <Column id="monthcnt08" type="STRING" size="256"/>
          <Column id="monthcnt09" type="STRING" size="256"/>
          <Column id="monthcnt10" type="STRING" size="256"/>
          <Column id="monthcnt11" type="STRING" size="256"/>
          <Column id="monthcnt12" type="STRING" size="256"/>
          <Column id="monthcnttotal" type="STRING" size="256"/>
          <Column id="beforeyearcnt" type="STRING" size="256"/>
          <Column id="cntaddper" type="STRING" size="256"/>
          <Column id="bonebank" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="codenm"/>
            <Col id="monthcnt01"/>
            <Col id="monthcnt02"/>
            <Col id="monthcnt03"/>
            <Col id="monthcnt04"/>
            <Col id="monthcnt05"/>
            <Col id="monthcnt06"/>
            <Col id="monthcnt07"/>
            <Col id="monthcnt08"/>
            <Col id="monthcnt09"/>
            <Col id="monthcnt10"/>
            <Col id="monthcnt11"/>
            <Col id="monthcnt12"/>
            <Col id="monthcnttotal"/>
            <Col id="beforeyearcnt"/>
            <Col id="cntaddper"/>
            <Col id="bonebank"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.grp_sea.input2" propid="value" datasetid="ds_send_req" columnid="delivefromdd"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.input3" propid="value" datasetid="ds_send_req" columnid="delivetodd"/>
      <BindItem id="item2" compid="grp_biz.grp_sea.combo2" propid="value" datasetid="ds_send_req" columnid="deliveflag"/>
      <BindItem id="item3" compid="grp_biz.grp_sea.input1" propid="value" datasetid="ds_send_req" columnid="delivefromdd2"/>
      <BindItem id="item4" compid="grp_biz.grp_sea.input4" propid="value" datasetid="ds_send_req" columnid="delivetodd2"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: N/A
 * Description		: 조회
 ****************************************************************************************/
function fGetCellInOutInfo() {
	dsf_setFixVal(ds_send_req, "searchflag:O");
	var oParam = {};
		oParam.id          = "TRABS10901";
		oParam.service     = "hsctstemcellapp.StemCellDelive";
		oParam.method      = "reqGetCellInOutStats";
		oParam.inds        = "req=ds_send_req";
		oParam.outds       = "ds_main_cellinout_cellinoutlist=cellinoutlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRABS10901";

	tranf_submit(oParam);

	// 전년도 대비 증감율을 구한다.
	for (var i = 0; i < ds_main_cellinout_cellinoutlist.rowcount; i++) {
		var iMonthCntTotal = ds_main_cellinout_cellinoutlist.getColumn(i, "monthcnttotal");
		var iBeforeYearCnt = ds_main_cellinout_cellinoutlist.getColumn(i, "beforeyearcnt");

		if ( utlf_isNull(iMonthCntTotal) || utlf_isNull(iBeforeYearCnt) || iBeforeYearCnt == 0 ) {
			ds_main_cellinout_cellinoutlist.setColumn( i , "cntaddper", "");
		} else {
			var dCntAddPer = ((parseFloat(iMonthCntTotal) - parseFloat(iBeforeYearCnt)) / parseFloat(iBeforeYearCnt)) * 100;
			ds_main_cellinout_cellinoutlist.setColumn( i , "cntaddper", (Math.round(dCntAddPer * 100) / 100));
		}
	}
}

function cf_TRABS10901(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    dsf_setTypeFormat(ds_main_cellinout_cellinoutlist, "monthcnt01:INT^monthcnt02:INT^monthcnt03:INT^monthcnt04:INT^monthcnt05:INT^monthcnt06:INT^monthcnt07:INT^monthcnt08:INT^monthcnt09:INT^monthcnt10:INT^monthcnt11:INT^monthcnt12:INT^monthcnttotal:INT^beforeyearcnt:INT^cntaddper:FLOAT");
}

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMABS10900_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	var arrParam = 	[{dsNm: "ds_init_cmbinfo_deliveflag_A0157", cdGrpId: "A0157"}
					];
	appf_getCodeList(arrParam);

	var scurrentdd   = utlf_getCurrentDate();

	ds_send_req.setColumn( 0, "delivefromdd", scurrentdd.toDate().getAddDate(-30,"D").getDateFormat("YYYYMMDD"));
	ds_send_req.setColumn( 0, "delivetodd", scurrentdd.toDate().getAddDate(30,"D").getDateFormat("YYYYMMDD"));
	ds_send_req.setColumn( 0, "delivefromdd2", scurrentdd.toDate().getAddDate(-30,"D").getDateFormat("YYYYMMDD"));
	ds_send_req.setColumn( 0, "delivetodd2", scurrentdd.toDate().getAddDate(30,"D").getDateFormat("YYYYMMDD"));
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function grp_biz_button2_onclick(obj:Button, e:ClickEventInfo) {
	if( ds_main_cellinout_cellinoutlist.rowcount > 0 ){
		grdf_exportExcel(grp_biz.grd_cellinoutlist, "조혈모세포츨고현황", "조혈모세포츨고현황", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function grp_biz_grp_sea_button3_onclick(obj:Button, e:ClickEventInfo) {
	fGetCellInOutInfo()
}

]]></Script>
  </Form>
</FDL>