YNU_JEUS/app_home/himed/xpapps/pam/clamuncoxp/xp/SMPIF31100_통보월별정산지급내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPIF31100" position="absolute 0 0 1204 758" titletext="Untitle" oninit="SMPIF31100_oninit" onload="SMPIF31100_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 13 1195 757" id="group3" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout>
              <Static text="정산지급내역" position="absolute 1 55 112 77" id="caption3" class="tit_2"/>
              <Shape position="absolute 1 71 1195 77" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
              <Button position="absolute 1115 51 1195 70" id="button12" class="btn7" text="엑셀저장" anchor="top right" onclick="group3_button12_onclick"/>
              <Div position="absolute 1 11 1195 46" align="align:center top;" id="grp_sea" class="div_SA" anchor="left top right">
                <Layouts>
                  <Layout>
                    <Button position="absolute 1123 7 1179 29" id="button2" class="btn1" text="조회" anchor="top right" onclick="group3_grp_sea_button2_onclick"/>
                    <Shape position="absolute 1104 7 1110 29" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
                    <CheckBox position="absolute 610 7 735 27" id="checkbox2" class="checkbox_search" anchor="default" text="원외처방정산포함" truevalue="Y" falsevalue="N"/>
                    <Static text="보험유형 :" position="absolute 285 9 371 26" id="caption4" class="search_name" anchor="default"/>
                    <Static text="통보월 :" position="absolute 15 9 90 26" id="caption5" class="search_name" anchor="default"/>
                    <Radio position="absolute 371 4 506 29" id="rdo_insukind" class="radio_search" columncount="3" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_rdo_insukind"/>
                    <Calendar position="absolute 91 8 166 27" align="align:center middle;" id="ipt_fromdd" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" ontextchanged="group3_grp_sea_ipt_fromdd_ontextchanged" onchanged="group3_grp_sea_ipt_fromdd_onchanged"/>
                    <Static text="~" position="absolute 168 11 183 26" id="caption1" anchor="default"/>
                    <Calendar position="absolute 181 8 260 27" align="align:center middle;" id="ipt_todd" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
                  </Layout>
                </Layouts>
              </Div>
              <Grid position="absolute 1 76 1195 736" id="grd_calcpayspec" class="datagrid2" binddataset="ds_main_calcpayspec" autofittype="col" anchor="all" onkeydown="group3_grd_calcpayspec_onkeydown" onselectchanged="group3_grd_calcpayspec_onselectchanged" onmouseup="group3_grd_calcpayspec_onmouseup" oncellclick="group3_grd_calcpayspec_oncellclick" cellsizingtype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="23"/>
                      <Column size="60"/>
                      <Column size="45"/>
                      <Column size="60"/>
                      <Column size="70"/>
                      <Column size="60"/>
                      <Column size="60"/>
                      <Column size="40"/>
                      <Column size="65"/>
                      <Column size="75"/>
                      <Column size="50"/>
                      <Column size="80"/>
                      <Column size="50"/>
                      <Column size="80"/>
                      <Column size="50"/>
                      <Column size="80"/>
                      <Column size="60"/>
                      <Column size="80"/>
                      <Column size="80"/>
                    </Columns>
                    <Rows>
                      <Row size="36" 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="내원&#10;유형"/>
                      <Cell col="8" text="접수번호"/>
                      <Cell col="9" text="심사차수"/>
                      <Cell col="10" text="진료과"/>
                      <Cell col="11" text="입금일자"/>
                      <Cell col="12" text="입금&#10;건수"/>
                      <Cell col="13" text="입금액"/>
                      <Cell col="14" text="삭감&#10;건수"/>
                      <Cell col="15" text="삭감액"/>
                      <Cell col="16" text="이의신청&#10;건수"/>
                      <Cell col="17" text="이의신청액"/>
                      <Cell col="18" text="이의신청&#10;결정액"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" expr="currow+1"/>
                      <Cell col="1" text="bind:calcflag"/>
                      <Cell col="2" text="bind:verflag"/>
                      <Cell col="3" displaytype="date" text="bind:notimm" mask="yyyy-MM"/>
                      <Cell col="4" text="bind:calcdg"/>
                      <Cell col="5" displaytype="date" text="bind:uncoym" mask="yyyy-MM"/>
                      <Cell col="6" displaytype="date" text="bind:clamym" mask="yyyy-MM"/>
                      <Cell col="7" text="bind:ioflag"/>
                      <Cell col="8" text="bind:acptno"/>
                      <Cell col="9" text="bind:judgdg"/>
                      <Cell col="10" text="bind:ordfildcd"/>
                      <Cell col="11" displaytype="date" text="bind:depodd" mask="yyyy-MM-dd"/>
                      <Cell col="12" displaytype="number" text="bind:depocnt"/>
                      <Cell col="13" displaytype="number" text="bind:depoamt"/>
                      <Cell col="14" displaytype="number" text="bind:cutcnt"/>
                      <Cell col="15" displaytype="number" text="bind:cutamt"/>
                      <Cell col="16" displaytype="number" text="bind:obtappcnt"/>
                      <Cell col="17" displaytype="number" text="bind:obtappamt"/>
                      <Cell col="18" displaytype="number" text="bind:obtappdeciamt"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button position="absolute 1019 51 1113 70" id="button7" class="btn7" text="Open Excel" anchor="top right" onclick="group3_button7_onclick"/>
              <Button position="absolute 911 51 964 70" id="button10" class="btn2" text="열카피" anchor="top right" onclick="group3_button10_onclick"/>
              <Button position="absolute 965 51 1018 70" id="button11" class="btn2" text="행카피" anchor="top right" onclick="group3_button11_onclick"/>
              <Button position="absolute 857 51 910 70" id="button13" class="btn2" text="셀카피" anchor="top right" onclick="group3_button13_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="통보월별 정산지급내역 조회" class="tit_1" position="absolute 1 0 225 23"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_calcpayspec" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="calcflag" type="STRING" size="256" sumtext="정산구분"/>
          <Column id="verflag" type="STRING" size="256" sumtext="버전구분"/>
          <Column id="notimm" type="STRING" size="256" sumtext="통보월"/>
          <Column id="calcdg" type="STRING" size="256" sumtext="정산차수"/>
          <Column id="uncoym" type="STRING" size="256" sumtext="미수월"/>
          <Column id="clamym" type="STRING" size="256" sumtext="청구월"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="내원유형"/>
          <Column id="acptno" type="STRING" size="256" sumtext="접수번호"/>
          <Column id="judgdg" type="STRING" size="256" sumtext="심사차수"/>
          <Column id="ordfildcd" type="STRING" size="256" sumtext="진료과"/>
          <Column id="depodd" type="STRING" size="256" sumtext="입금일자"/>
          <Column id="depocnt" type="STRING" size="256" sumtext="입금건수"/>
          <Column id="depoamt" type="STRING" size="256" sumtext="입금액"/>
          <Column id="cutcnt" type="STRING" size="256" sumtext="삭감건수"/>
          <Column id="cutamt" type="STRING" size="256" sumtext="삭감액"/>
          <Column id="obtappcnt" type="STRING" size="256" sumtext="이신건수"/>
          <Column id="obtappamt" type="STRING" size="256" sumtext="이신액"/>
          <Column id="obtappdeciamt" 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="6"/>
          <Column id="todd" type="STRING" size="6"/>
          <Column id="insukind" type="STRING" size="256"/>
          <Column id="oprcpcalcyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_rdo_insukind" 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">11</Col>
          </Row>
          <Row>
            <Col id="label">보호</Col>
            <Col id="value">21</Col>
          </Row>
          <Row>
            <Col id="label">산재</Col>
            <Col id="value">41</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group3.grp_sea.checkbox2" propid="value" datasetid="ds_send" columnid="oprcpcalcyn"/>
      <BindItem id="item1" compid="group3.grp_sea.rdo_insukind" propid="value" datasetid="ds_send" columnid="insukind"/>
      <BindItem id="item2" compid="group3.grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item3" compid="group3.grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
    </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";

var col = "N";

function SMPIF31100_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMPIF31100_onload(obj:Form, e:LoadEventInfo)
{
	ds_send.setColumn(0, "fromdd", "");
	ds_send.setColumn(0, "todd", "");
		
	group3.grp_sea.ipt_fromdd.setFocus();
	
	group3.grp_sea.rdo_insukind.index = 0;
}

function group3_grp_sea_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(group3.grp_sea.ipt_fromdd.value))
	{
		sysf_messageBox("통보월 시작일을","C001");
	} 
	else 
	{
		var oParam = {};
			oParam.id          = "TRPIF31101";
			oParam.service     = "clamuncoapp.ClamUnco";
			oParam.method      = "reqGetCalcPaySpec";
			oParam.inds        = "req=ds_send";
			oParam.outds       = "ds_main_calcpayspec=gridcalcpayspec";
			oParam.async       = false;
			//oParam.callback    = "cf_TRPIF31101";

		tranf_submit(oParam);
	}
}

function group3_grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var value = obj.value;

	ds_send.setColumn(0, "fromdd", String(value).substr(0, 6));
	ds_send.setColumn(0, "todd", String(value).substr(0, 6));
}

function group3_button13_onclick(obj:Button,  e:ClickEventInfo)
{
	col = "N";
	group3.grd_calcpayspec.selecttype = "multiarea";
}

function group3_button10_onclick(obj:Button,  e:ClickEventInfo)
{
	col = "Y";
	group3.grd_calcpayspec.selecttype = "multiarea";
}

function group3_button11_onclick(obj:Button,  e:ClickEventInfo)
{
	col = "N";
	group3.grd_calcpayspec.setCellPos = "multirow";
}

function group3_button7_onclick(obj:Button,  e:ClickEventInfo)
{
	system.execShell("excel");
}

function group3_button12_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_main_calcpayspec.rowcount > 0) 
	{
		var today = new Date();
								
		var yy = today.getYear()+"";
		var mm = today.getMonth()+1;
		var dd = today.getDate();
		
		if(mm < 10) 
		{ 
			mm = "0" + mm; 
		}
		else 
		{ 
			mm = mm + ""; 
		}
		
		if(dd < 10) 
		{ 
			dd = "0" + dd; 
		}  
		else 
		{ 
			dd = dd + ""; 
		}
		
		var tmp = yy+mm+dd;
		var titlename = "";
				
		if(ds_send.getColumn(0, "insukind") == "11") 
		{
			titlename = "통보월별정산지급내역조회(보험)_"+tmp;
		} 
		else if(ds_send.getColumn(0, "insukind") == "21") 
		{
			titlename = "통보월별정산지급내역조회(보호)_"+tmp;
		}
								
		grdf_exportExcel(group3.grd_calcpayspec, titlename, "see");
	}
	else
	{
		sysf_messageBox("엑셀저장할 내역이", "I004");	
	}	
}

function group3_grd_calcpayspec_onkeydown(obj:Grid, e:KeyEventInfo)
{	
	if(col == "Y")
	{
		var CONST_SEPARATOR = "	";	//컬럼별 구분자
		var lv_oBindDs = eval(obj.binddataset);
		var lv_sColID;
		var lv_sVal;
		var lv_sClipboard = "";
		var lv_nAreaStartRow;
		var lv_nAreaEndRow;
		var lv_nAreaStartCol;
		var lv_nAreaEndCol;
	   
		if(obj.selecttype == "multiarea") 
		{
			lv_nAreaStartRow = 0;
			lv_nAreaEndRow   = parseInt(obj.rowcount-1);
			lv_nAreaStartCol = parseInt(obj.currentcol);
			lv_nAreaEndCol   = parseInt(obj.currentcol);
		} 
		
		for(var nRow = lv_nAreaStartRow; nRow <= lv_nAreaEndRow; nRow++) 
		{
			for(var nCell = lv_nAreaStartCol; nCell <= lv_nAreaEndCol; nCell++) 
			{
				lv_sColID = obj.getCellProperty("body",nCell,"text");
				lv_sVal = obj.getCellValue(nRow,nCell);
				lv_sClipboard = lv_sClipboard + lv_sVal + CONST_SEPARATOR;
			}

			lv_sClipboard = lv_sClipboard.substr(0,lv_sClipboard.length-1);
			lv_sClipboard = lv_sClipboard +String.fromCharCode(10);
		}

		lv_sClipboard = lv_sClipboard.substr(0,lv_sClipboard.length-1);
		
		iv_sClipboard = lv_sClipboard;	
		
		system.setClipboard("CF_TEXT",lv_sClipboard);
	}
	else
	{
		if (e.ctrlKey == true && e.keycode == 67 )
		{
			grdf_clipboardCopy(obj, "PAM");
		}
	}
}

function group3_grd_calcpayspec_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	var lv_nAreaStartRow;
	var lv_nAreaEndRow;
	var lv_nAreaStartCol;
	var lv_nAreaEndCol;

	if(col == "Y")
	{
		lv_nAreaStartRow = 0;
		lv_nAreaEndRow   = parseInt(obj.rowcount-1);
		lv_nAreaStartCol = parseInt(obj.currentcol);
		lv_nAreaEndCol   = parseInt(obj.currentcol);
		
		grdf_initGridStyle(obj);
		
		for(var nRow = lv_nAreaStartRow; nRow <= lv_nAreaEndRow; nRow++) 
		{
			for(var nCell = lv_nAreaStartCol; nCell <= lv_nAreaEndCol; nCell++) 
			{
				obj.setCellProperty("body",nCell,"background","#FFE7E5");
				obj.setCellProperty("body",nCell,"background2","#FFE7E5");
			}
		}
	}
	else
	{
		grdf_initGridStyle(obj);
	}
}
]]></Script>
  </Form>
</FDL>