YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SMPAS00550_계정별미수금현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPAS00550" position="absolute 0 0 1211 784" titletext="미수금현황장표" onload="SMPAS00550_onload">
    <Layouts>
      <Layout>
        <Div id="group2" position="absolute 0 25 1203 60" style="" class="div_SA">
          <Layouts>
            <Layout>
              <Static id="caption2" class="search_name" position="absolute 15 9 220 26" style="" text="기간 :                         ~" anchor="default"/>
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1132 7 1135 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Button id="btn_search" class="btn1" position="absolute 1139 7 1195 29" text="조회" onclick="group2_btn_search_onclick" anchor="default"/>
              <Calendar id="input7" class="input_default" taborder="7" position="absolute 75 8 195 27" style="" anchor="default" onkeydown="group2_input7_onkeydown" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null"/>
              <Calendar id="input1" class="input_default" taborder="7" position="absolute 215 8 335 27" style="" anchor="default" onkeydown="group2_input1_onkeydown" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd"/>
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo1" position="absolute 435 8 535 27" style="" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">ALL</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">I</Col>
                      <Col id="datacolumn">입원</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">O</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Button id="button95" class="btn7" visible="false" position="absolute 976 7 1056 29" style="" text="액셀저장" onclick="group2_button95_onclick" anchor="default"/>
              <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1063 7 1066 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Button id="btn_print" class="btn6" position="absolute 1070 7 1126 29" style="" text="출력" onclick="group2_btn_print_onclick" anchor="default"/>
              <Static id="caption1" class="search_name" position="absolute 350 9 455 26" style="" text="진료구분 :" anchor="default"/>
              <Static id="caption3" class="search_name" position="absolute 550 9 655 26" style="" text="금액구분 :" anchor="default"/>
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo2" position="absolute 635 8 735 27" style="" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">ALL</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">6</Col>
                      <Col id="datacolumn">미수만</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">E</Col>
                      <Col id="datacolumn">입금만</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption4" class="search_name" position="absolute 750 9 855 26" style="" text="일자구분 :" anchor="default"/>
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo3" position="absolute 835 8 935 27" style="" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">ALL</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">발생일자</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">5</Col>
                      <Col id="datacolumn">수납일자</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="datagrid2" binddataset="ds_main_receivamtlist_receivamtstats" position="absolute 0 70 1201 775" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="150"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <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="입금일자"/>
                <Cell col="9" text="미수잔액"/>
                <Cell col="10" text="담당자"/>
                <Cell col="11" text="계정"/>
                <Cell col="12" text="계정명"/>
                <Cell col="13"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow + 1"/>
                <Cell col="1" style="align:center middle;" text="bind:pid"/>
                <Cell col="2" style="align:left middle;" text="bind:hngnm"/>
                <Cell col="3" displaytype="combo" edittype="combo" text="bind:orddeptcd" combodataset="ds_init_orddeptcd_orddeptcdlist" combocodecol="cd" combodatacol="nm"/>
                <Cell col="4" displaytype="date" style="align:right middle;" text="bind:orddd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
                <Cell col="5" displaytype="number" style="align:right middle;" text="bind:totownbamt" mask="9,999"/>
                <Cell col="6" displaytype="number" style="align:right middle;" text="bind:uncoamt" mask="9,999"/>
                <Cell col="7" displaytype="number" style="align:right middle;" text="bind:rcptamt" mask="9,999"/>
                <Cell col="8" displaytype="date" style="align:right middle;" text="bind:rcptexecdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
                <Cell col="9" displaytype="number" style="align:right middle;" text="bind:restamt" mask="9,999"/>
                <Cell col="10" text="bind:usernm"/>
                <Cell col="11" style="align:center middle;" text="bind:uncocd"/>
                <Cell col="12" style="align:left middle;" text="bind:discunconm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption60" text="계정별_미수금현황" class="tit_1" position="absolute 0 0 180 25" style="align:left middle;font:Dotum,9,bold;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_tmpinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_tmpinfo_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="user" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="user"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="fromdata" type="STRING" size="256"/>
          <Column id="todata" type="STRING" size="256"/>
          <Column id="ordergubun" type="STRING" size="256"/>
          <Column id="amtgubun" type="STRING" size="256"/>
          <Column id="daygubun" type="STRING" size="256"/>
          <Column id="uncocdflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdata"/>
            <Col id="todata"/>
            <Col id="ordergubun">ALL</Col>
            <Col id="amtgubun">ALL</Col>
            <Col id="daygubun">ALL</Col>
            <Col id="uncocdflag">ALL</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_receivamtsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_receivamtlist_receivamtstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="uncocd" type="STRING" size="256"/>
          <Column id="discunconm" type="STRING" size="256"/>
          <Column id="uncnt" type="STRING" size="256"/>
          <Column id="uncoamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="uncocd"/>
            <Col id="discunconm"/>
            <Col id="uncnt"/>
            <Col id="uncoamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_receivamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_receivamtsumlist_receivamtsumstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="uncocd" type="STRING" size="256"/>
          <Column id="discunconm" type="STRING" size="256"/>
          <Column id="uncnt" type="STRING" size="256"/>
          <Column id="uncoamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="uncocd">총계</Col>
            <Col id="discunconm"/>
            <Col id="uncnt"/>
            <Col id="uncoamt"/>
          </Row>
        </Rows>
      </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_main_rcv" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="uncocd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="uncocd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_orddrid_orddridlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
          <Column id="dp" type="STRING" size="256"/>
          <Column id="sp" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cd"/>
            <Col id="nm"/>
            <Col id="dp"/>
            <Col id="sp"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_orddrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init_orddeptcd_orddeptcdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cd"/>
            <Col id="nm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <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="tmp" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_main_search" columnid="fromdata"/>
      <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_main_search" columnid="todata"/>
      <BindItem id="item2" compid="group2.combo1" propid="value" datasetid="ds_main_search" columnid="ordergubun"/>
      <BindItem id="item3" compid="group2.combo2" propid="value" datasetid="ds_main_search" columnid="amtgubun"/>
      <BindItem id="item4" compid="group2.combo3" propid="value" datasetid="ds_main_search" columnid="daygubun"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
include 'com_basiccodexp::ZBC001.xjs';
include 'com_zipcodexp::ZBP001.xjs';
include 'pam_pamcomnxp::PAM.xjs';

function SMPAS00550_onload(obj:Form, e:LoadEventInfo) {
    frmf_initForm(obj);
    
	//진료과코드 진료의사ID 조회
	pamGetDeptCDDrIDList();

	var vToday = new Date();
	var tmpYear = vToday.getYear();
	var tmpMonth = vToday.getMonth()+1;
	var tmpDate = vToday.getDate();

	if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
	if (tmpDate < 10) { tmpDate = "0"+tmpDate; }

	if(ds_main_search.getColumn(0, "fromdata") == ''){
		ds_main_search.setColumn( 0, "fromdata", tmpYear+""+tmpMonth+""+tmpDate-1);
		ds_main_search.setColumn( 0, "todata", tmpYear+""+tmpMonth+""+tmpDate);
	}

	//Rexport에 출력날자를 보여주기위한 데이터 저장
	dsf_makeValue( ds_main_tmp_print, "date", "string", "" );
	ds_main_tmp_print_date.copyData(ds_main_search_fromdata); 
	ds_main_tmp_print.setColumn( 0, "date", ds_main_search.getColumn(0, "fromdata"));
}

function rcvSearchCond()
{

} 

function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {
	var fromdata = utlf_transNullToEmpty(ds_main_search.getColumn(0, "fromdata"));
	var todata = utlf_transNullToEmpty(ds_main_search.getColumn(0, "todata"));
	
	if(fromdata == ""){
		sysf_messageBox("시작일을 입력","E007");
		group2.input7.setFocus();
		return false;
	}
	if(todata == ""){
		sysf_messageBox("끝일을 입력","E007");
		group2.input1.setFocus();
		return false;
	}
	
	if(parseInt(fromdata) > parseInt(todata)){
		sysf_messageBox("시작일이 끝일자보다 클수 ", "C001")
		return false;
	}
	else{
		ds_main_receivamtlist_receivamtstats.clearData();

		var day = parseInt(ds_main_search.getColumn(0, "daygubun"));
		
		var XXX_defSize = 100;

		if(day == 4){
			datagrid2.setFormatColProperty( 7, "size", 0);
			datagrid2.setFormatColProperty( 8, "size", 0);
			datagrid2.setFormatColProperty( 4, "size", XXX_defSize);
			datagrid2.setFormatColProperty( 6, "size", XXX_defSize);
		}
		else if (day == 5){
			datagrid2.setFormatColProperty( 4, "size", 0);
			datagrid2.setFormatColProperty( 6, "size", 0);
			datagrid2.setFormatColProperty( 7, "size", XXX_defSize);
			datagrid2.setFormatColProperty( 8, "size", XXX_defSize);
		}
		else{
			datagrid2.setFormatColProperty( 4, "size", XXX_defSize);
			datagrid2.setFormatColProperty( 6, "size", XXX_defSize);
			datagrid2.setFormatColProperty( 7, "size", XXX_defSize);
			datagrid2.setFormatColProperty( 8, "size", XXX_defSize);
		}

		var oParam = {};
		oParam.id          = "TRPAS00101";
		oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
		oParam.method      = "reqGetUncoAmtList";
		oParam.inds        = "req=ds_main_search";
		oParam.outds       = "ds_main_receivamtlist_receivamtstats=receivamtstats";
		oParam.async       = false;
		tranf_submit(oParam);

		//로드값이 있을때  엑셀저장여부 버튼 생성여부
		var rows = ds_main_receivamtlist_receivamtstats.rowcount;
		if(rows >0){
			group2.line1.visible  =true;
			group2.button95.visible = true;
		}
		else{
			group2.line1.visible  =false;
			group2.button95.visible = false;	
		}
		
		var sumtotal = rows;

		if(sumtotal == ""||sumtotal == null || sumtotal == 1){

		}
		else{
			datagrid2.mergeByFree(sumtotal,1,sumtotal,2);	
		}
	}
}

function group2_input7_onkeydown(obj:Calendar, e:KeyEventInfo) {
	if( e.keycode == 13 ) {
		obj.updateToDataset();
		group2.input1.setFocus();
	}
}

function group2_input1_onkeydown(obj:Calendar, e:KeyEventInfo) {
	if( event.keyCode == 13 ) {
		obj.updateToDataset();
		group2.btn_search.setFocus();
		group2.btn_search.click();
	}
}

function group2_button95_onclick(obj:Button, e:ClickEventInfo) {
	var vToday = new Date();
	var tmpYear = vToday.getYear();
	var tmpMonth = vToday.getMonth()+1;
	var tmpDate = vToday.getDate();

	grdf_exportExcel(grd_inuncolist, "미수금현황" + tmpYear + tmpMonth + tmpDate, "Sheet1", true, "" , 'user' , true);
}

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

// RPPAS000101은 없어서 주석처리함.
// 2017.03.08 kimdo3
//     var objDOM = rptf_createDOM();
//     var objParam = new Object();
//     rptf_setNodeListToDOM(objDOM, "/root/XXX" , ds_XXX);
//     objParam.xml_data_XML1 	= objDOM.documentElement.source;
//     var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
//     rptf_exeReportPreview30(["RPPAS00101"],[objParam], option);	


}

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