YNU_JEUS/app_home/himed/xpapps/pam/clamuncoxp/xp/SMPIF73401_미수금검증조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPIF73201" position="absolute 0 0 1053 781" titletext="미수금 검증조회" oninit="SMPIF73201_oninit" onload="SMPIF73201_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 13 1047 775" id="grp_biz" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout width="1047" height="762">
              <Grid position="absolute 1 130 1045 758" id="grd_clbsmast" class="datagrid2" binddataset="ds_main_datagrid" anchor="all" cellsizingtype="col" selecttype="multiarea" onkeyup="grp_biz_grd_clbsmast_onkeyup" onkeydown="grp_biz_grd_clbsmast_onkeydown">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="23" band="left"/>
                      <Column size="85" band="left"/>
                      <Column size="88" band="left"/>
                      <Column size="88" band="left"/>
                      <Column size="88" band="left"/>
                      <Column size="0"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                      <Column size="88"/>
                    </Columns>
                    <Rows>
                      <Row size="30" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell taborder="undefined"/>
                      <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" text="지원금입금"/>
                      <Cell col="14" text="상한금"/>
                      <Cell col="15" text="상한입금"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" displaytype="date" text="bind:clamym" mask="yyyy-MM"/>
                      <Cell col="2" text="bind:acptno"/>
                      <Cell col="3" text="bind:clamno"/>
                      <Cell col="4" text="bind:judgdg"/>
                      <Cell col="5" style="align:right middle;" text="bind:clclamamtsum"/>
                      <Cell col="6" style="align:right middle;" text="bind:jrjudgdeciamt"/>
                      <Cell col="7" style="align:right middle;" text="bind:depoamt"/>
                      <Cell col="8" style="align:right middle;" text="bind:totouncoamt"/>
                      <Cell col="9" style="align:right middle;" text="bind:uncoamt"/>
                      <Cell col="10" style="align:right middle;" text="bind:jrhandicaprfund"/>
                      <Cell col="11" style="align:right middle;" text="bind:jrhandicaprfund_amt"/>
                      <Cell col="12" style="align:right middle;" text="bind:jrsuppamt"/>
                      <Cell col="13" style="align:right middle;" text="bind:jrsupp_amt"/>
                      <Cell col="14" style="align:right middle;" text="bind:jrownbmaxexamt"/>
                      <Cell col="15" style="align:right middle;" text="bind:jrownbmaxex_amt"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Static text="미수금 검증내역" position="absolute 1 107 238 130" id="cap_judgtrgtman" class="tit_2" anchor="default"/>
              <Shape position="absolute 1 128 1045 129" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
              <Div position="absolute 1 11 1047 99" align="align:center top;" id="group1" class="div_SA" anchor="left top right">
                <Layouts>
                  <Layout>
                    <Static text="청구년월" position="absolute 10 8 95 25" id="caption30" class="search_name" anchor="default"/>
                    <Button position="absolute 984 30 1040 52" id="btn_select" class="btn1" taborder="32" text="조회" anchor="top right" onclick="grp_biz_group1_btn_select_onclick"/>
                    <Shape position="absolute 973 30 979 52" linetype="vertical" id="line3" class="line_4" anchor="top right"/>
                    <Static text="~" position="absolute 171 6 191 26" id="caption1" anchor="default"/>
                    <cp_monthCal id="ipt_clamym" taborder="35" scrollbars="none" position="absolute 85 7 160 27" anchor="default"/>
                    <cp_monthCal id="ipt_clamtoym" taborder="36" scrollbars="none" position="absolute 192 7 267 27" anchor="default"/>
                    <Radio id="rdo_srchgbn" taborder="37" columncount="0" rowcount="3" position="absolute 83 31 967 82" innerdataset="@ds_PK234list" codecolumn="cdid" datacolumn="cdnm" anchor="default" onitemclick="grp_biz_group1_rdo_srchgbn_onitemclick"/>
                    <Static id="caption00" text="조회구분" class="search_name" position="absolute 10 33 75 50" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Button id="btn_excelsave" taborder="1" text="엑셀저장" onclick="btn_excelsave_onclick" class="btn7" position="absolute 969 106 1045 126" anchor="top right"/>
              <Button id="button2" taborder="2" text="출력" onclick="grp_biz_button2_onclick" class="btn6" position="absolute 919 106 968 126" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="cap_title" text="미수금 검증조회" class="tit_1" position="absolute 1 0 225 23"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_datagrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ioflag" type="STRING" size="256" sumtext="구분" prop="KEY"/>
          <Column id="insuflag" type="STRING" size="256" sumtext="보험구분" prop="KEY"/>
          <Column id="ordfildcd" type="STRING" size="256" sumtext="합계" prop="TEXT"/>
          <Column id="bfcnt" type="BIGDECIMAL" size="256" sumtext="전월미수금"/>
          <Column id="afcnt" type="BIGDECIMAL" size="256" sumtext="원무청구액"/>
          <Column id="bfeditotordamt" type="BIGDECIMAL" size="256" sumtext="심사전청구액"/>
          <Column id="afeditotordamt" type="BIGDECIMAL" size="256" sumtext="인수차액"/>
          <Column id="bfinsuclamamt" type="BIGDECIMAL" size="256" sumtext="청구불능자체조정"/>
          <Column id="afinsuclamamt" type="BIGDECIMAL" size="256" sumtext="심사후청구액"/>
          <Column id="bfownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="장기이식미수금"/>
          <Column id="afownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="장기이식미수입금"/>
          <Column id="bfhedisuppamt" type="BIGDECIMAL" size="256" sumtext="삭감액"/>
          <Column id="afhedisuppamt" type="BIGDECIMAL" size="256" sumtext="미수이관"/>
          <Column id="bfledisuppamt" type="BIGDECIMAL" size="256" sumtext="금월미수금"/>
          <Column id="afledisuppamt" type="BIGDECIMAL" size="256" sumtext="존재구분"/>
          <Column id="bfedihandcaprfundamt" type="BIGDECIMAL" size="256" sumtext="추가당초보완청구"/>
          <Column id="afedihandcaprfundamt" type="BIGDECIMAL" size="256" sumtext="기타금액"/>
          <Column id="bfallinsuclamamt" type="BIGDECIMAL" size="256" sumtext="청구년월"/>
          <Column id="afallinsuclamamt" type="BIGDECIMAL" size="256" sumtext="청구년월"/>
          <Column id="afdiffamt" type="BIGDECIMAL" size="256" sumtext="청구미수입금"/>
          <Column id="afalldiffamt" type="BIGDECIMAL" size="256" sumtext="청구미수입금"/>
          <Column id="avrgeditotordamt" type="BIGDECIMAL" size="256" sumtext="청구년월"/>
          <Column id="isexist" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="uncaym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="insert" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_PK234list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="clamym" type="STRING" size="256"/>
          <Column id="clamtoym" type="STRING" size="256"/>
          <Column id="srchgbn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="isexist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_ioflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">입원</Col>
            <Col id="value">I</Col>
          </Row>
          <Row>
            <Col id="label">외래</Col>
            <Col id="value">O</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_insuflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">건강보험</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">DRG</Col>
            <Col id="value">D</Col>
          </Row>
          <Row>
            <Col id="label">의료급여</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">자보</Col>
            <Col id="value">3</Col>
          </Row>
          <Row>
            <Col id="label">산재</Col>
            <Col id="value">4</Col>
          </Row>
          <Row>
            <Col id="label">기타</Col>
            <Col id="value">5</Col>
          </Row>
          <Row>
            <Col id="label">장기이식</Col>
            <Col id="value">9</Col>
          </Row>
          <Row>
            <Col id="label">완화</Col>
            <Col id="value">B</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_ordfildcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">의과</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">치과</Col>
            <Col id="value">6</Col>
          </Row>
          <Row>
            <Col id="label">정신과</Col>
            <Col id="value">7</Col>
          </Row>
          <Row>
            <Col id="label">DRG</Col>
            <Col id="value">D</Col>
          </Row>
          <Row>
            <Col id="label">완화</Col>
            <Col id="value">B</Col>
          </Row>
          <Row>
            <Col id="label">소계</Col>
          </Row>
          <Row>
            <Col id="label">피스</Col>
            <Col id="value">C</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_rdo_srchgbn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">1</Col>
            <Col id="cdnm">[건보]심결있고 입금액 없는 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">2</Col>
            <Col id="cdnm">[건보]토탈미수금, 미수금 있는 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">3</Col>
            <Col id="cdnm">[건보]토탈미수금, 미수금 다른것 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">4</Col>
            <Col id="cdnm">[보호]심결있고 입금액 없는 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">5</Col>
            <Col id="cdnm">[보호]토탈미수금, 미수금 있는 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">6</Col>
            <Col id="cdnm">[보호]토탈미수금, 미수금 다른것 자료</Col>
          </Row>
          <Row>
            <Col id="cdid">7</Col>
            <Col id="cdnm">접수 3개월 경과 후 심결내역 없는 자료</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.group1.rdo_srchgbn" propid="value" datasetid="ds_send" columnid="srchgbn"/>
    </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                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "pam_pamcomnxp::PAM001.xjs";
include "pam_pamcomnxp::PAM.xjs";
function SMPIF73201_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMPIF73201_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grp_biz.grd_clbsmast);
	grdf_setRowTypeIcon(grp_biz.grd_clbsmast, 0);
	
	fInitialize();
}

function fInitialize()
{
	var objParam = [{dsNm: "ds_PK234list", cdGrpId: "PK234", showValue: true}];
	pamfGetCodeList(objParam, true, ""); //비동기

	//appf_getCodeList(arrParam);	
	//pamGetDeptCDDrIDList();
	
	var d_year = utlf_addMonth(utlf_getCurrentDate(), -12);
	grp_biz.group1.ipt_clamym.setData(d_year.substr(0,4)+"01");
	grp_biz.group1.ipt_clamtoym.setData(d_year.substr(0,4)+"12");
	
	grp_biz_group1_ipt_clamym_onchanged();
	
	grp_biz.group1.ipt_clamym.setCallEvent("grp_biz_group1_ipt_clamym_onchanged");
	
	grp_biz.group1.rdo_srchgbn.index = 0;
}

function grp_biz_group1_ipt_clamym_onchanged(){

	ds_send.setColumn(0, "clamym", grp_biz.group1.ipt_clamym.getData());
	ds_send.setColumn(0, "clamtoym", grp_biz.group1.ipt_clamtoym.getData());
	
}

function grp_biz_group1_ipt_clamym_onkeydown(obj:Calendar, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		grp_biz_group1_ipt_clamym_onchanged
	}
}

function grp_biz_group1_ipt_clamtoym_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = obj.value;
	
	ds_send.setColumn(0, "clamtoym", String(date).substr(0, 6));
}

function grp_biz_group1_ipt_clamtoym_onkeydown(obj:Calendar, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		grp_biz_group1_ipt_clamtoym_onchanged();
		
		grp_biz_group1_btn_select_onclick();
	}
}

function grp_biz_group1_btn_select_onclick(obj:Button,  e:ClickEventInfo)
{
	grp_biz_group1_ipt_clamym_onchanged();
	fGetDocuList();
}

function fGetDocuList()
{
	var oParam = {};
		oParam.id          = "TRPIF74100";
		oParam.service     = "clamuncoapp.ClamUnco";
		oParam.method      = "reqGetUncoDiffList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_datagrid=datagrid";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIF73200";

	tranf_submit(oParam);

}

function grp_biz_grd_clbsmast_onkeyup(obj:Grid, e:KeyEventInfo)
{

}

function grp_biz_grd_clbsmast_onkeydown(obj:Grid, e:KeyEventInfo)
{
	if (e.ctrlKey == true && e.keycode == 67 ){
		grdf_clipboardCopy(grp_biz.grd_clbsmast, "PAM");
	}
}

function btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_clbsmast, "exportExcel", "see", false, "" ,"user");	
	
}

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

	var objDOM = rptf_createDOM();	// DOM 객체 설정
		if (ds_main_datagrid.rowcount == 0) {
			ds_main_datagrid.addRow();
		}
		rptf_setNodeListToDOM(objDOM, "/root/main/datagrid", ds_main_datagrid);
		rptf_setNodeListToDOM(objDOM, "/root/send", ds_send);
		rptf_setNodeListToDOM(objDOM, "/root/init/srchgbnlist", ds_rdo_srchgbn);
		
	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;

	var option = //"open=1;save=1;directprint=0;printdialog=0;print=1;zoom=0;";	
	rptf_exeReportPreview30(["RPPIF80800"],[objParam], option);
}
]]></Script>
  </Form>
</FDL>