YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS01900_통합건진미수현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS01900" position="absolute 0 0 1211 784" titletext="건진일평균인원현황" onload="SMAHS01900_onload">
    <Layouts>
      <Layout>
        <Div id="group3" position="absolute 0 0 1211 21" style="" scrollbars="none">
          <Layouts>
            <Layout>
              <Static id="caption60" class="tit_1" position="absolute 0 0 183 22" style="align:left middle;font:dotum,9,bold;" text="통합건진미수현황" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group2" position="absolute 0 21 1203 61" style="" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1133 10 1136 32" anchor="top right"/>
              <Button id="btn_search" class="btn1" position="absolute 1140 10 1196 32" style="" text="조회" onclick="group2_btn_search_onclick" anchor="top right"/>
              <Button id="btn_excelsave" class="btn7" visible="true" position="absolute 977 10 1057 32" style="" text="엑셀저장" onclick="group2_btn_excelsave_onclick" anchor="top right"/>
              <Button id="btn_prt" class="btn6" position="absolute 1071 10 1127 32" style="" text="출력" onclick="group2_btn_prt_onclick" anchor="top right"/>
              <Shape id="line3" class="line_4" linetype="vertical" position="absolute 1064 10 1067 32" anchor="top right"/>
              <Static id="caption2" class="search_name" position="absolute 15 12 88 29" style="" text="연도 :" anchor="default"/>
              <Static id="caption1" class="search_name" position="absolute 205 12 278 29" style="" text="월 :" anchor="default"/>
              <Combo innerdataset="ds_init_baseinfo_yearlst_P0167" datacolumn="cdnm" codecolumn="cdid" columncount="-1" rowcount="-1" id="cmb_year" position="absolute 80 11 180 30" style="" onitemclick="group2_cmb_year_onitemclick" anchor="default"/>
              <Combo innerdataset="ds_init_baseinfo_monthlst_R0009" datacolumn="cdnm" codecolumn="cdid" columncount="-1" rowcount="-1" id="cmb_month" position="absolute 255 11 355 30" style="" onitemclick="group2_cmb_month_onitemclick" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_uncolst" binddataset="ds_main_uncolst_item" position="absolute 0 69 1203 776" style="align:center ;" onaftersort="grd_uncolst_onaftersort" onbeforesort="grd_uncolst_onbeforesort" ontextchanged="grd_uncolst_ontextchanged" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="200"/>
                <Column size="130"/>
                <Column size="130"/>
                <Column size="100"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="182"/>
                <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="총미수금"/>
                <Cell col="5" text="삭감액"/>
                <Cell col="6" text="최종입금일"/>
                <Cell col="7" text="최종청구일"/>
                <Cell col="8" text="비고"/>
              </Band>
              <Band id="body">
                <Cell style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:dotum,9,bold;" text="bind:cmpynm"/>
                <Cell col="1" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:exclamamt"/>
                <Cell col="2" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:nowclamamt"/>
                <Cell col="3" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:incmamt"/>
                <Cell col="4" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:uncoamt"/>
                <Cell col="5" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:discamt"/>
                <Cell col="6" displaytype="date" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:lastincmdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
                <Cell col="7" displaytype="date" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:lastclamdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
                <Cell col="8" style="background:EXPR(cmpynm == '총계' ? '#808080' : '');background2:EXPR(cmpynm == '총계' ? '#808080' : '');color:EXPR(cmpynm == '총계' ? '#ffffff' : '');color2:EXPR(cmpynm == '총계' ? '#ffffff' : '');font:EXPR(cmpynm == '총계' ? 'Dotum,9,bold' : '');" text="bind:remfact"/>
                <Cell col="9" text="bind:clamtrgtcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_uncolst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cmpynm" type="STRING" size="256"/>
          <Column id="exclamamt" type="STRING" size="256"/>
          <Column id="nowclamamt" type="STRING" size="256"/>
          <Column id="incmamt" type="STRING" size="256"/>
          <Column id="uncoamt" type="STRING" size="256"/>
          <Column id="discamt" type="STRING" size="256"/>
          <Column id="lastincmdd" type="STRING" size="256"/>
          <Column id="lastclamdd" type="STRING" size="256"/>
          <Column id="clamtrgtcd" type="STRING" size="256"/>
          <Column id="remfact" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cmpynm"/>
            <Col id="exclamamt"/>
            <Col id="nowclamamt"/>
            <Col id="incmamt"/>
            <Col id="uncoamt"/>
            <Col id="discamt"/>
            <Col id="lastincmdd"/>
            <Col id="lastclamdd"/>
            <Col id="clamtrgtcd"/>
            <Col id="remfact"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_uncolst" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
          <Column id="srchinstcd" type="STRING" size="256"/>
          <Column id="srchyear" type="STRING" size="256"/>
          <Column id="srchmonth" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchfromdd"/>
            <Col id="srchtodd"/>
            <Col id="srchinstcd"/>
            <Col id="srchyear"/>
            <Col id="srchmonth"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_baseinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="yearlst" type="STRING" size="256"/>
          <Column id="monthlst" type="STRING" size="256"/>
        </ColumnInfo>
      </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>
        <Rows>
          <Row>
            <Col id="hidden"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="export" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init_baseinfo_monthlst_R0009" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_yearlst_P0167" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_export" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_uncolst_item_report" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_year" propid="value" datasetid="ds_send" columnid="srchyear"/>
      <BindItem id="item1" compid="group2.cmb_month" propid="value" datasetid="ds_send" columnid="srchmonth"/>
    </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 SMAHS01900_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
 //grdf_initGrid(grd_XXX); 
 //grdf_setGridSort(grd_XXX); 
 //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	// 기관코드 초기화
	ds_send.setColumn( 0, "srchinstcd" , sysf_getUserInfo("dutplceinstcd"));

	//공통코드 조회
  	var arrParam = [{dsNm: "ds_init_baseinfo_yearlst_P0167", cdGrpId: "P0167"}
				   ,{dsNm: "ds_init_baseinfo_monthlst_R0009", cdGrpId: "R0009"}
				   ];
	appf_getCodeList(arrParam);
	   									    		 				

	// 일자초기화
	ds_send.setColumn( 0, "srchyear" , utlf_getCurrentDate().substr(0,4));
	ds_send.setColumn( 0, "srchmonth" , utlf_getCurrentDate().substr(4,2));

	//group2.cmb_year.dispatch("xforms-select");

//model.refresh();

}



//전체에서 event와 src를 제외한  script 를 모두포함.

/*
* 건진종류 소계 및 총계를 생성한다.
*/
function fSetRcptSum() {
	// 그리드 merge 및 합계 초기화

	var tExclamamt = 0;
	var tNwclamamt = 0;
	var tIncmamt = 0;
	var tUncoamt = 0;
	var tDiscamt = 0;
	
	
	for(var i =0; i < ds_main_uncolst_item.rowcount ; i++) {
// 
// 		// 소계 및 합계
// 		if((i >= grd_uncolst.colRef("bfmuncoamt") && i <= grd_uncolst.colRef("discamt")) ) {																		
// 			grd_uncolst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_uncolst.colRef("cmpynm") , "총계" );																
// 		}		
       	tExclamamt  = tExclamamt  + parseFloat(utlf_transNull(ds_main_uncolst_item.getColumn(i, "exclamamt"),0));
	    tNwclamamt  = tNwclamamt  + parseFloat(utlf_transNull(ds_main_uncolst_item.getColumn(i, "nowclamamt"),0));
	    tIncmamt    = tIncmamt    + parseFloat(utlf_transNull(ds_main_uncolst_item.getColumn(i, "incmamt"),0));
	    tUncoamt    = tUncoamt    + parseFloat(utlf_transNull(ds_main_uncolst_item.getColumn(i, "uncoamt"),0));
	    tDiscamt    = tDiscamt    + parseFloat(utlf_transNull(ds_main_uncolst_item.getColumn(i, "discamt"),0));
	    
	}
	
	nRow = ds_main_uncolst_item.addRow();
	ds_main_uncolst_item.setColumn(nRow,"cmpynm",	    "총계");
    ds_main_uncolst_item.setColumn(nRow,"exclamamt",	tExclamamt);
    ds_main_uncolst_item.setColumn(nRow,"nowclamamt",	tNwclamamt);
    ds_main_uncolst_item.setColumn(nRow,"incmamt",	    tIncmamt);
    ds_main_uncolst_item.setColumn(nRow,"uncoamt",	    tUncoamt);
    ds_main_uncolst_item.setColumn(nRow,"discamt",	    tDiscamt);
    ds_main_uncolst_item.rowposition = -1;
}

/*
* 일자 초기화 (srchfromdd , srchtodd)
*/
function fDate(vYear , vMon) {

	var dd = new Date(vYear, vMon  ,0);						
	ds_send.setColumn( 0, "srchfromdd" , vYear + vMon + "01");
	ds_send.setColumn( 0, "srchtodd" , vYear + vMon + dd.getDate());

}



function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {


	var oParam = {};
    oParam.id          = "TRAHS01901";
    oParam.service     = "healexamstatapp.StatRef";
    oParam.method      = "reqGetTuncoCondList";
    oParam.inds        = "req=ds_send";
    oParam.outds       = "ds_main_uncolst_item=item";
    oParam.async       = false;
    oParam.callback    = "cf_TRAHS01901";

	tranf_submit(oParam);
	

	
}

function cf_TRAHS01901(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    ds_main_uncolst_item.updateColID("oldmisuamt","exclamamt");
	ds_main_uncolst_item.updateColID("clamamt","nowclamamt");
	ds_main_uncolst_item.updateColID("incomeamt","incmamt");
	ds_main_uncolst_item.updateColID("discamt","uncoamt");
	ds_main_uncolst_item.updateColID("misuamt","discamt");
	ds_main_uncolst_item.updateColID("clamdd","lastclamdd");
	ds_main_uncolst_item.updateColID("incomedd","lastincmdd");
	ds_main_uncolst_item_report.copyData(ds_main_uncolst_item);
	
    fSetRcptSum();
}

function group2_btn_excelsave_onclick(obj:Button, e:ClickEventInfo) {

	grdf_exportExcel(grd_uncolst, "excel","Sheet1",  true, "" , "" , true);

}

function group2_btn_prt_onclick(obj:Button, e:ClickEventInfo) {

	dsf_makeValue( ds_main_export, "srchfromdd", "string",  ds_send.getColumn(0, "srchfromdd").toDate().getDateFormat("YYYY_MM_DD"));
	dsf_makeValue( ds_main_export, "srchtodd", "string",  ds_send.getColumn(0, "srchtodd").toDate().getDateFormat("YYYY_MM_DD"));						
	dsf_makeValue( ds_main_export, "srchmonth", "string",  ds_send.getColumn(0, "srchmonth"));						
    var objDOM = rptf_createDOM();
    var objParam = new Object();
    rptf_setNodeListToDOM(objDOM, "/root/main/uncolst/item" , ds_main_uncolst_item_report);
    objParam.xml_data_XML1 	= objDOM.documentElement.source;
    objParam.srchfromdd = ds_main_export.getColumn(0,"srchfromdd");
	objParam.srchtodd = ds_main_export.getColumn(0,"srchtodd");
	objParam.srchmonth = ds_main_export.getColumn(0,"srchmonth");
    var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
    rptf_exeReportPreview30(["RPAHS01201"],[objParam], option);	

}

function group2_cmb_year_onitemclick(obj:Combo, e:ListBoxClickEventInfo) {

	fDate(group2.cmb_year.value , group2.cmb_month.value);

}

function group2_cmb_month_onitemclick(obj:Combo, e:ListBoxClickEventInfo) {

	fDate(group2.cmb_year.value , group2.cmb_month.value);

}

function grd_uncolst_onaftersort() {

	fSetRcptSum();	
	grd_uncolst.gridToInstance();

}

function grd_uncolst_onbeforesort() {

	grd_uncolst.subtotal("clear", 0, 5)

}

function grd_uncolst_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo) {  /// ????? 1.0에서 기능사용여부 확인 필요 

	var iRow = grd_uncolst.row;
	var iCol = grd_uncolst.col;
	if(iCol ==8){
		var iRemfact =grd_uncolst.valueMatrix(iRow,iCol);
		model.removenode("ds_main_uncolst_item["+iRow+"]_remfact");
		ds_main_uncolst_item.setColumn( iRow, "remfact", iRemfact);
	}

}

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