YNU_JEUS/app_home/himed/xpapps/sts/stspamxp/xp/SPSTP00900_수익예산조회.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPSTP00900" position="absolute 0 0 1203 782" titletext="Untitle" onload="SPSTP00900_onload">
    <Layouts>
      <Layout>
        <Div id="grp" taborder="6" position="absolute 0 24 1200 62" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1005 4 1008 34" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
              <Static id="caption21" text="조회년월 :" class="search_name" position="absolute 21 11 95 28" anchor="left top"/>
              <Button id="btn_search" taborder="2" text="조회" onclick="btn_search_onclick" class="btn1" position="absolute 1015 8 1071 30" anchor="top right"/>
              <Button id="button1" taborder="3" text="엑셀" onclick="button1_onclick" class="btn7" position="absolute 1074 8 1130 30" anchor="top right"/>
              <Button id="button2" taborder="4" text="출력" onclick="button2_onclick" class="btn6" position="absolute 1133 8 1189 30" anchor="top right"/>
              <Button id="button3" taborder="5" text="수익데이터 생성" onclick="button3_onclick" class="btn4" position="absolute 870 8 997 30" anchor="top right"/>
              <Calendar id="ipt_srchdd" taborder="6" position="absolute 105 9 195 29" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true" onkeydown="grp_ipt_srchdd_onkeydown" style="align:center middle;" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" linetype="horizontal" position="absolute 0 85 1200 89" style="" anchor="left top right"/>
        <Grid id="grd_earnbugt" binddataset="ds_grddata_earnbugtList" position="absolute 0 89 1200 779" style="" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="140"/>
                <Column size="130"/>
                <Column size="130"/>
                <Column size="120"/>
                <Column size="130"/>
                <Column size="130"/>
                <Column size="120"/>
              </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="외래달성율(%)"/>
              </Band>
              <Band id="body">
                <Cell style="align:center middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:grupgbnm"/>
                <Cell col="1" style="align:center middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:centhngnm"/>
                <Cell col="2" style="align:center middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:depthngnm"/>
                <Cell col="3" displaytype="number" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:inpgoalamt" mask="#,##0"/>
                <Cell col="4" displaytype="number" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:inptotamt" mask="#,##0"/>
                <Cell col="5" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:inpgoalp"/>
                <Cell col="6" displaytype="number" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:outgoalamt" mask="#,##0"/>
                <Cell col="7" displaytype="number" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:outtotamt" mask="#,##0"/>
                <Cell col="8" style="align:right middle;background:BIND(bgColor);background2:BIND(bgColor);font:BIND(font);" text="bind:outgoalp"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption60" class="tit_1" position="absolute 0 0 183 24" style="align:left middle;font:Dotum,9, bold;" text="수익예산조회" anchor="left top"/>
        <Static id="caption46" class="tit_2" position="absolute 1 68 105 84" style="" text="수익예산조회" anchor="left top"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bugtym" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_grddata_earnbugtList" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="grupgbnm" type="STRING" size="256" sumtext=""/>
          <Column id="grupgb" type="STRING" size="256" sumtext=""/>
          <Column id="centhngnm" type="STRING" size="256" sumtext=""/>
          <Column id="orddeptcd" type="STRING" size="256" sumtext=""/>
          <Column id="depthngnm" type="STRING" size="256" sumtext=""/>
          <Column id="inpgoalamt" type="STRING" size="256" sumtext=""/>
          <Column id="outgoalamt" type="STRING" size="256" sumtext=""/>
          <Column id="inptotamt" type="STRING" size="256" sumtext=""/>
          <Column id="outtotamt" type="STRING" size="256" sumtext=""/>
          <Column id="inpgoalp" type="STRING" size="256" sumtext=""/>
          <Column id="outgoalp" type="STRING" size="256" sumtext=""/>
          <Column id="dispseq" type="STRING" size="256" sumtext=""/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_reqExeEarnBugtList" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="message" type="STRING" size="256" sumtext=""/>
          <Column id="result" type="STRING" size="256" sumtext=""/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp.ipt_srchdd" propid="value" datasetid="ds_cond" columnid="bugtym"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
 //=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include 'com_commonxp::comm_main.xjs';

var arErrorCode = new HashArray();
//=======================================================================================
// Local methods
//---------------------------------------------------------------------------------------
/**
 * [fInit description]
 * @return {[type]} [description]
 */
function fInit() {
    ds_cond.setColumn(0, "bugtym", utlf_getCurrentDate().substr(0, 6));
}

/**
 * [fDispAprvCnclChng description]
 * @param  {[type]} grdObj [description]
 * @return {[type]}        [description]
 */
function fDispAprvCnclChng(grdObj: Grid) {
    var chagValue = "";
    for (var i = 1; i < grdObj.rowcount; i++) {
        chagValue = utlf_transNullToEmpty(ds_grddata_earnbugtList.getColumn(i, "orddeptcd"));
        if (chagValue == "") {
            ds_grddata_earnbugtList.setColumn(i, 'bgColor', '#ffff99');
            ds_grddata_earnbugtList.setColumn(i, 'font', 'Dotum,9,bold');
        }
    }
}

/**
 * submit 후 호출 될 공통 콜백
 * @param  {[type]}   sSvcId     [description]
 * @param  {[type]}   nErrorCode [description]
 * @param  {[type]}   sErrorMsg  [description]
 * @return {Function}            [description]
 */
function callback(sSvcId, nErrorCode, sErrorMsg){
    arErrorCode.push(sSvcId, nErrorCode);
}

//=======================================================================================
// Events
//---------------------------------------------------------------------------------------
/**
 * onload 이벤트 발생 시 호출
 * @param {[type]} obj:Form        [description]
 * @param {[type]} e:LoadEventInfo [description]
 */
function SPSTP00900_onload(obj: Form, e: LoadEventInfo) {
    frmf_initForm(obj);

    fInit();
}

/**
 * ipt_srchdd 키보드 입력 이벤트
 * @param  {[type]} obj: Calendar      [description]
 * @param  {[type]} e:   KeyEventInfo  [description]
 * @return {[type]}      [description]
 */
function grp_ipt_srchdd_onkeydown(obj: Calendar, e: KeyEventInfo) {
    if (e.keycode == 13) {
		grp.btn_search.setFocus();
        grp.btn_search.click();
    }
}

/**
 * 수익데이터 생성 버튼 클릭 이벤트
 * @param  {[type]} obj: Button         [description]
 * @param  {[type]} e:   ClickEventInfo [description]
 * @return {[type]}      [description]
 */
function button3_onclick(obj: Button, e: ClickEventInfo) {
    if (utlf_transNullToEmpty(ds_cond.getColumn(0, "bugtym")) == "") {
        return;
    }

    var date = ds_cond.getColumn(0, 'bugtym');

    if (sysf_messageBox(date + " 수익자료 생성을", "Q004") == "6") {
        ds_reqExeEarnBugtList.clearData();

        var oParam = {};
        oParam.id          = "TXSTP00902";
        oParam.service     = "stspamapp.StsPam";
        oParam.method      = "reqExeEarnBugtList";
        oParam.inds        = "req=ds_cond";
        oParam.outds       = "ds_reqExeEarnBugtList=reqExeEarnBugtList";
        oParam.async       = false;
        oParam.callback    = "callback";

        tranf_submit(oParam);

        if (arErrorCode.pop("TXSTP00902") > -1) {
			ds_reqExeEarnBugtList.updateColID('msg', 'message');
            if (ds_reqExeEarnBugtList.rowcount > 0) {
                sysf_messageBox(ds_reqExeEarnBugtList.getColumn(0, "message"), "I002");
                grp.btn_search.click();

            }
            else {
                sysf_messageBox(ds_reqExeEarnBugtList.getColumn(0, "message"), "C001");
            }
        }
    }
}

/**
 * 조회 버튼 클릭 이벤트
 * @param  {[type]} obj: Button         [description]
 * @param  {[type]} e:   ClickEventInfo [description]
 * @return {[type]}      [description]
 */
function btn_search_onclick(obj: Button, e: ClickEventInfo) {
    if (utlf_transNullToEmpty(ds_cond.getColumn(0, "bugtym")) == "") {
        return;
    }
    
    var value = String(ds_cond.getColumn(0, 'bugtym'));
    if(value.length > 6){
		trace('1');
		value = value.substr(0, 6);
		ds_cond.setColumn(0, 'bugtym', value);
    }

    ds_grddata_earnbugtList.clearData();
    
    //trace(ds_cond.saveXML());
    
    var oParam = {};
    oParam.id          = "TRSTP01705";
    oParam.service     = "stspamapp.StsPam";
    oParam.method      = "reqGetEarnBugtList";
    oParam.inds        = "req=ds_cond";
    oParam.outds       = "ds_grddata_earnbugtList=earnbugtList";
    oParam.async       = false;
    oParam.callback    = "callback";

    tranf_submit(oParam);

	ds_grddata_earnbugtList.addColumn('bgColor', 'string');
	ds_grddata_earnbugtList.addColumn('font', 'string');
    
    if (arErrorCode.pop("TRSTP01705") > -1) {
        fDispAprvCnclChng(grd_earnbugt);
    }
}

/**
 * 엑셀 버튼 클릭 이벤트
 * @param  {[type]} obj: Button         [description]
 * @param  {[type]} e:   ClickEventInfo [description]
 * @return {[type]}      [description]
 */
function button1_onclick(obj: Button, e: ClickEventInfo) {
    var today = ds_cond.getColumn(0, "bugtym");
    grdf_exportExcel(grd_earnbugt, "수익예산_" + today, "Sheet1", true, "", "user", false);
}

/**
 * 출력 버튼 클릭 이벤트
 * @param  {[type]} obj: Button         [description]
 * @param  {[type]} e:   ClickEventInfo [description]
 * @return {[type]}      [description]
 */
function button2_onclick(obj: Button, e: ClickEventInfo) {
    // DOM 객체 설정
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/cond", ds_cond);
		rptf_setNodeListToDOM(objDOM, "/root/grddata/earnbugtList", ds_grddata_earnbugtList);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;
	var option = null;
	rptf_exeReportPreview30(["RPSTP00904"],[objParam], option)
}


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