YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SPPAS00750_일일미수현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPPAS00750" position="absolute 0 0 600 200" titletext="일일 미수현황" onload="SPPAS00750_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 24 590 64" id="grp" class="div_SA">
          <Layouts>
            <Layout width="590" height="35">
              <Button position="absolute 520 10 576 32" id="btn_search" class="btn1" text="조회" anchor="default" onclick="grp_btn_search_onclick"/>
              <Shape position="absolute 507 10 513 32" linetype="vertical" id="line1" class="line_4" visible="true" anchor="default"/>
              <Static text="미수기간 :" position="absolute 10 12 101 29" id="caption4" class="search_name" anchor="default"/>
              <Calendar position="absolute 102 11 207 30" id="input1" anchor="default" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
            </Layout>
          </Layouts>
        </Div>
        <Static text="미수 현황" position="absolute 0 76 140 92" id="caption2" class="tit_2"/>
        <Grid position="absolute 0 93 590 193" align="align:center middle;" id="grd_totuncolist" visible="true" binddataset="ds_uncolist">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="139"/>
                <Column size="140"/>
                <Column size="140"/>
                <Column size="140"/>
              </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="미수총누계"/>
              </Band>
              <Band id="body">
                <Cell style="align:right middle;padding:0 4 0 0;" text="bind:beftotuncoamt" mask="#,###"/>
                <Cell col="1" style="align:right middle;padding:0 4 0 0;" text="bind:dayunco" mask="#,###"/>
                <Cell col="2" style="align:right middle;padding:0 4 0 0;" text="bind:rcptamt" mask="#,###"/>
                <Cell col="3" style="align:right middle;padding:0 4 0 0;" text="bind:totuncoamt" mask="#,###"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button position="absolute 510 73 590 92" id="button1" class="btn7" text="엑셀저장" onclick="button1_onclick"/>
        <Static id="caption60" text="일일 미수 현황" class="tit_1" position="absolute 0 0 140 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_uncolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="outuncoamt" type="STRING" size="256" sumtext="외래미수"/>
          <Column id="inuncoamt" type="STRING" size="256" sumtext="입원미수"/>
          <Column id="etcuncoamt" type="STRING" size="256" sumtext="기타미수"/>
          <Column id="beftotuncoamt" type="STRING" size="256" sumtext="전일미수총누계"/>
          <Column id="uncoamt" type="STRING" size="256" sumtext="미수발생액"/>
          <Column id="dayunco" type="STRING" size="256" sumtext="당일미수금액"/>
          <Column id="rcptamt" type="STRING" size="256" sumtext="미수입금액"/>
          <Column id="totuncoamt" type="STRING" size="256" sumtext="미수총누계"/>
        </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="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="sendflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="sendflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_befounco" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="beftotuncoamt" type="STRING" size="256" sumtext="전일미수총누계"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_totuncoamt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="totuncoamt" type="STRING" size="256" sumtext="미수총누계"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_uncorcpt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rcptamt" type="STRING" size="256" sumtext="미수입금액"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp.input1" propid="value" datasetid="ds_send" columnid="fromdd"/>
    </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
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: 
 * Description		: 
 ****************************************************************************************/
 
 
//=======================================================================================
// callback
//---------------------------------------------------------------------------------------
function callback(sSvcId, nErrorCode, sErrorMsg){
	arErrorCode.push(sSvcId, nErrorCode);
}

//=======================================================================================
// Events
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: 
 * Description		: onload
 ****************************************************************************************/
function SPPAS00750_onload(obj:Form, e:LoadEventInfo){
	// 폼 초기화
	frmf_initForm(obj);
	
	ds_send.setColumn(0, 'sendflag', 'yyyy');
	ds_send.setColumn(0, 'fromdd', utlf_getCurrentDate());
}

/****************************************************************************************
 * Argument			: 
 * Description		: 조회 버튼 클릭 이벤트
 ****************************************************************************************/
function grp_btn_search_onclick(obj:Button,  e:ClickEventInfo){
	ds_uncolist.clearData();
	ds_uncolist.addRow();
	
	ds_befounco.clearData();
	ds_befounco.addRow();
	
	ds_totuncoamt.clearData();
	ds_totuncoamt.addRow();
	
	var oParam = {};
		oParam.id          = "TRPAS00810";
		oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
		oParam.method      = "reqGetTotUncoamt";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_uncolist=uncolist ds_befounco=befounco ds_totuncoamt=totuncoamt ds_uncorcpt=uncorcpt";
		//oParam.outds       = "ds_uncolist=uncolist ds_=befounco ds_=totuncoamt ds_=uncorcpt ds_=inddunco ds_=outddunco";
		oParam.async       = false;
		oParam.callback    = "callback";

	tranf_submit(oParam);
	
	if(arErrorCode.pop("TRPAS00810") > -1){
		// 전일미수총누계
		var beftotamt = parseInt(ds_befounco.getColumn(0, 'beftotuncoamt'));
		ds_uncolist.setColumn(0, 'beftotuncoamt', beftotamt);
		
		// 당일미수발생액
		var outuncoamt = parseInt(ds_uncolist.getColumn(0, 'outuncoamt'));
		ds_uncolist.setColumn(0, 'dayunco', outuncoamt);
		
		// 당일미수입금액
		var rcptamt = parseInt(ds_uncorcpt.getColumn(0, 'rcptamt'));
		ds_uncolist.setColumn(0, 'rcptamt', rcptamt);
		
		// 미수 총 누계 = 전일미수총계 + (당일 미수금액 + 당일 미수금액)
		ds_uncolist.setColumn(0, 'totuncoamt', beftotamt + (outuncoamt - rcptamt));
	}
}

/****************************************************************************************
 * Argument			: 
 * Description		: 엑셀저장 버튼 클릭 이벤트
 ****************************************************************************************/
function button1_onclick(obj:Button,  e:ClickEventInfo){
	grdf_exportExcel(grd_totuncolist, 'save', 'SheetName', true, '', 'user', false);
}
]]></Script>
  </Form>
</FDL>