YNU_JEUS/app_home/himed/xpapps/emr/agonalcarexp/xp/SPMNH03800_후원금 멀티 입금.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPMNH03800" position="absolute 0 0 610 438" titletext="기부금 멀티 입금" oninit="SPMNH03800_oninit" onload="SPMNH03800_onload">
    <Layouts>
      <Layout>
        <Button position="absolute 550 7 606 29" id="btn_cancel" class="btn4" taborder="9" text="닫기" onclick="btn_cancel_onclick" anchor="top right"/>
        <Grid position="absolute 0 35 605 83" id="grd_aidmtlist" taborder="7" binddataset="ds_main_aidmtlist" autofittype="col" oncellclick="grd_aidmtlist_oncellclick" anchor="left top right" autoenter="select" onkeydown="grd_aidmtlist_onkeydown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="79"/>
                <Column size="70"/>
                <Column size="84"/>
                <Column size="89"/>
                <Column size="120"/>
                <Column size="90"/>
                <Column size="70"/>
              </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="입금액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:memno"/>
                <Cell col="1" text="bind:membnm"/>
                <Cell col="2" displaytype="combo" edittype="combo" style="padding:0 2 0 2;" text="bind:paymthdflag" combodataset="ds_init_A00002" combocodecol="cdid" combodatacol="cdnm" combodisplayrowcount="20"/>
                <Cell col="3" displaytype="combo" edittype="combo" style="padding:0 2 0 2;" text="bind:paybankflag" combodataset="ds_init_A00001" combocodecol="cdid" combodatacol="cdnm" combodisplayrowcount="20"/>
                <Cell col="4" text="bind:acntno"/>
                <Cell col="5" displaytype="date" edittype="date" text="bind:payindd" calendardisplaynulltype="none"/>
                <Cell col="6" displaytype="number" edittype="normal" style="align:center middle;" text="bind:aidamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="기부금 멀티 입금" position="absolute 1 14 132 37" id="caption1" class="tit_2"/>
        <Shape position="absolute 0 30 605 36" linetype="horizontal" id="line1" class="line_1" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
        <Button position="absolute 492 7 548 29" id="button1" class="btn4" taborder="9" text="저장" onclick="button1_onclick" anchor="top right"/>
        <Grid position="absolute 0 123 605 426" id="grd_aidmtmultilist" taborder="7" binddataset="ds_main_aidmtmultilist" autofittype="col" anchor="all" autoenter="key">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="40"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="120"/>
                <Column size="122"/>
                <Column size="120"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell displaytype="checkbox" edittype="checkbox"/>
                <Cell col="1" text="납부 년월"/>
                <Cell col="2" text="납부 여부"/>
                <Cell col="3" text="회원번호"/>
                <Cell col="4" text="회원명"/>
                <Cell col="5" text="입금액"/>
              </Band>
              <Band id="body">
                <Cell displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:chk == 'true' || chk == '1' ? 1 : 0"/>
                <Cell col="1" displaytype="date" text="bind:payym" mask="yyyy-MM" calendardisplaynulltype="none"/>
                <Cell col="2" text="bind:payyn"/>
                <Cell col="3" text="bind:memno"/>
                <Cell col="4" text="bind:membnm"/>
                <Cell col="5" displaytype="number" edittype="normal" style="align:center middle;" text="bind:aidamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="납부년월 체크" position="absolute 1 102 132 124" id="caption2" class="tit_2"/>
        <Shape position="absolute 0 118 605 124" linetype="horizontal" id="line2" class="line_1" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
        <Button position="absolute 508 99 605 118" id="button6" class="btn2" text="약정금액 계산" onclick="button6_onclick" anchor="top right"/>
        <Div position="absolute 240 72 400 242" id="group2" visible="false" style="background:#87cefaff;">
          <Layouts>
            <Layout>
              <Static text="계좌(지로)번호" position="absolute 2 4 118 25" id="caption5" class="tit_2" anchor="default"/>
              <Radio position="absolute 10 25 150 155" id="rdo_acntno" class="radio_search" taborder="31" columncount="1" innerdataset="@ds_init_acntno" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="group2_rdo_acntno_onitemchanged" onkeydown="group2_rdo_acntno_onkeydown"/>
              <Button position="absolute 113 3 155 22" id="button8" class="btn5" taborder="22" text="닫기" anchor="default" onclick="group2_button8_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Button position="absolute 427 99 507 118" id="button2" class="btn7" text="엑셀저장" onclick="button2_onclick" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_A00001" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_A00002" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_aidmtlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_aidmtlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="memno" type="STRING" size="256"/>
          <Column id="membnm" type="STRING" size="256"/>
          <Column id="paymthdflag" type="STRING" size="256"/>
          <Column id="paybankflag" type="STRING" size="256"/>
          <Column id="acntno" type="STRING" size="256"/>
          <Column id="payindd" type="STRING" size="256"/>
          <Column id="aidamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_aidmtmultilist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_aidmtmultilist_oncolumnchanged">
        <ColumnInfo>
          <Column id="chk" type="STRING" size="256" sumtext="chk"/>
          <Column id="payym" type="STRING" size="256" sumtext="납부 년월"/>
          <Column id="payyn" type="STRING" size="256" sumtext="납부 여부"/>
          <Column id="memno" type="STRING" size="256" sumtext="회원번호"/>
          <Column id="membnm" type="STRING" size="256" sumtext="회원명"/>
          <Column id="aidamt" type="STRING" size="256" sumtext="입금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_acntno" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="acntno"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_mondetl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="monamt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_sAmtData" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.rdo_acntno" propid="value" datasetid="ds_temp" columnid="acntno"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-10-31
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-10-31      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "emr_agonalcarexp::SMMNH00001.xjs"

var payyy;
function SPMNH03800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPMNH03800_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_aidmtmultilist);

	dsf_createDsRow("ds_send", [{col:"bankflagcd", type:"STRING", size:256 , val :"" }]);
                              
	var oParam = {};
		oParam.id          = "TRMNH02401";
		oParam.service     = "hospiceapp.HospiceAidAssocnMngt";
		oParam.method      = "reqGetAcntList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_acntno=acntno";
		oParam.async       = false;
		//oParam.callback    = "cf_TRMNH02401";

	tranf_submit(oParam);
	
	var arrParam = new Array();
	arrParam = [{dsNm: "ds_init_A00001", cdGrpId: "A00001", showValue: false},
				{dsNm: "ds_init_A00002", cdGrpId: "A00002", showValue: false}];
	fGetCodeList(arrParam, true);
 
 	//grd_aidmtmultilist.fixedcellcheckbox(0,0) = true;

	var memno = opener.frmf_getParameter("memno");
	var membnm = opener.frmf_getParameter("membnm");
	var paymthdflag = opener.frmf_getParameter("paymthdflag");
	var paybankflag = opener.frmf_getParameter("paybankflag");
	var acntno = opener.frmf_getParameter("acntno");
	payyy = opener.frmf_getParameter("payyy");
	var payindd = utlf_getCurrentDate();

	ds_main_aidmtlist.setColumn(0, "memno", memno);
	ds_main_aidmtlist.setColumn(0, "membnm", membnm);
	ds_main_aidmtlist.setColumn(0, "paymthdflag", paymthdflag);
	ds_main_aidmtlist.setColumn(0, "paybankflag", paybankflag);
	ds_main_aidmtlist.setColumn(0, "acntno", acntno);
	ds_main_aidmtlist.setColumn(0, "payindd", payindd);

	dsf_createDsRow("ds_send", [{col:"membno", type:"STRING", size:256 , val : memno}
							 ,	{col:"membnm", type:"STRING", size:256 , val : membnm}
							 ,	{col:"payyy", type:"STRING", size:256 , val : payyy}]);
	
	var oParam = {};
		oParam.id          = "TRMNH03801";
		oParam.service     = "hospiceapp.HospiceAidAssocnMngt";
		oParam.method      = "reqGetAidmtMultiList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_aidmtmultilist=aidmtmultilist";
		oParam.async       = false;
		oParam.callback    = "cf_TRMNH03801";

	tranf_submit(oParam);
}

function cf_TRMNH03801(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
	{
		return;
	}
	else
	{
		for(var i = 0; i < ds_main_aidmtmultilist.rowcount; i++)
		{
			if(ds_main_aidmtmultilist.getColumn(i, "chk") == "true")
			{
// 				grd_aidmtmultilist.setCellProperty("Body", 0, "edittype", "none");
// 				grd_aidmtmultilist.setCellProperty("Body", 5, "edittype", "none");
			}
			else
			{
// 				grd_aidmtmultilist.setCellProperty("Body", 0, "edittype", "checkbox");
// 				grd_aidmtmultilist.setCellProperty("Body", 5, "edittype", "nomal");
			}
		}
	}
}

function ds_main_aidmtmultilist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "chk")
	{
		obj.setColumn(e.row, "chk", (e.newvalue == "true" || e.newvalue == 1) ? "true" : "false");
	}
	
// 	if(grd_aidmtlist.col == 2)
// 	{
// 		if(grd_aidmtlist.valueMatrix(1,2)=="01"){
// 			grd_aidmtlist.isReadOnly(1, 7)  = false;
// 		}else{
// 			grd_aidmtlist.isReadOnly(1, 7)  = true;
// 		}
// 	}else if(grd_aidmtlist.col == 5){
// 		if(grd_aidmtlist.valueMatrix(1,5)==getCurrentDate()){
// 			messageBox("후원금 입금일이 같으면 추가 입금을", "E001");
// 			grd_aidmtlist.valueMatrix(1,5) = "";
// 			return;
// 		}
// 	}
}

function ds_main_aidmtlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "paybankflag")
	{
		obj.setColumn(e.row, "acntno", "");
		
		ds_send.clearData();
				
		dsf_createDsRow("ds_send", [{col:"bankflagcd", type:"STRING", size:256 , val : obj.getColumn(e.row, "paybankflag")}]);
                              
		var oParam = {};
			oParam.id          = "TRMNH02401";
			oParam.service     = "hospiceapp.HospiceAidAssocnMngt";
			oParam.method      = "reqGetAcntList";
			oParam.inds        = "req=ds_send";
			oParam.outds       = "ds_init_acntno=acntno";
			oParam.async       = false;
			//oParam.callback    = "cf_TRMNH02401";

		tranf_submit(oParam);		
	}
	
	if(e.columnid == "paymthdflag")
	{
		if(obj.getColumn(0, "paymthdflag") == "01")
		{
			sysf_messageBox("지로 납부는 멀티 후원금 입금을", "E001");
			obj.setColumn(0, "paymthdflag", "");
			return;
		}
	}
	else if(e.columnid == "paybankflag")
	{
		if(obj.setColumn(0, "paybankflag") == "99")
		{
			sysf_messageBox("지로 납부는 멀티 후원금 입금을", "E001");
			obj.setColumn(0, "paybankflag", "");
			return;
		}
	}
	else if(e.columnid == "payindd")
	{
// 		if(e.newvalue(0, "payindd") == utlf_getCurrentDate())
// 		{
// 			sysf_messageBox("기부금 입금일이 같으면 추가 입금을", "E001");
// 			obj.setColumn(0, "payindd", "");
// 			return;
// 		}
	}
}

function grd_aidmtlist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if(e.col == 4)
	{
		ds_temp.setColumn(0, "acntno", ds_main_aidmtlist.getColumn(e.row, "acntno"));
		group2.visible = true;	
	}
}

function group2_button8_onclick(obj:Button,  e:ClickEventInfo)
{
	group2.visible = false;
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var acntno = ds_main_aidmtlist.getColumn(0, "acntno");
					
	if(utlf_isNull(acntno))
	{
		sysf_messageBox("계좌(지로)번호를 입력하십시오.", "E");
		return;
	}
	
	if(sysf_messageBox("","Q002") != 6) 
	{
		return;
	}
	
	if(utlf_isNull(ds_main_aidmtlist.getColumn(i, "payindd")))
	{
		sysf_messageBox("입금일은", "I003");
		return;
	}
	if(utlf_isNull(ds_main_aidmtlist.getColumn(0, "aidamt")))
	{
		sysf_messageBox("입금액은", "I003");
		return;
	}
	
	//var xAmtPath = "/root/main/aidmtmultilist";
	
	var sAmtData =
					"membno"            
				+ "▦payym"        
				+ "▦payindd"        
				+ "▦paymthdflag"   
				+ "▦paybankflag"         
				+ "▦acntno"        
				+ "▦aidamt"    
				+ "▦orgaidamt"   
				+ "▩"   ;
	
	for(var i = 0; i < ds_main_aidmtmultilist.rowcount; i++ )
	{
		if((ds_main_aidmtmultilist.getColumn(i, "chk")=="true") && (ds_main_aidmtmultilist.getColumn(i, "payyn")=="N")) 
		{
			sAmtData +=
						ds_main_aidmtmultilist.getColumn(i, "memno")
				+ "▦" + ds_main_aidmtmultilist.getColumn(i, "payym")
				+ "▦" + ds_main_aidmtlist.getColumn(0, "payindd")
				+ "▦" + ds_main_aidmtlist.getColumn(0, "paymthdflag")
				+ "▦" + ds_main_aidmtlist.getColumn(0, "paybankflag")
				+ "▦" + ds_main_aidmtlist.getColumn(0, "acntno")
				+ "▦" + ds_main_aidmtmultilist.getColumn(i, "aidamt")
				+ "▦" + ds_main_aidmtmultilist.getColumn(i, "aidamt")
				+ "▩"   ;
		}
	}
	
	dsf_setCSVToDs("ds_send_sAmtData", sAmtData);
	
	var oParam = {};
		oParam.id          = "TXMNH03801";
		oParam.service     = "hospiceapp.HospiceAidAssocnMngt";
		oParam.method      = "reqSetAidmtMulti";
		oParam.inds        = "req=ds_send_sAmtData";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXMNH03801";

	tranf_submit(oParam);			
	this.close();
}

function btn_cancel_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_aidmtmultilist.rowcount == 0)
	{
		sysf_messageBox("엑셀저장할 내역이", "I004");
	}
	else
	{
		grdf_exportExcel(grd_aidmtmultilist, "", "see");
	}
}

function group2_rdo_acntno_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	ds_main_aidmtlist.setColumn(ds_main_aidmtlist.rowposition, "acntno", ds_temp.getColumn(0, "acntno"));
	group2.visible = false;		
}

function group2_rdo_acntno_onkeydown(obj:Radio, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		group2.visible = false;
	}
}

function button6_onclick(obj:Button,  e:ClickEventInfo)
{
	var cnt = 0;
	var tempamt = 0;

	amt = Number(ds_main_aidmtlist.getColumn(0, "aidamt"));
	tempamt = amt;
	
	if(utlf_isNull(amt))
	{
		sysf_messageBox("입금액을", "C001");
		return;
	}
	
	ds_send.clearData();
		
	dsf_createDsRow("ds_send", [{col:"membno", type:"STRING", size:256 , val : ds_main_aidmtlist.getColumn(0, "memno")}
							 ,	{col:"amtyy", type:"STRING", size:256 , val : payyy}]);
	
	
	var oParam = {};
		oParam.id          = "TRMNH04001";
		oParam.service     = "hospiceapp.HospiceAidAssocnMngt";
		oParam.method      = "reqGetMonmtList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_mondetl=mondetl";
		oParam.async       = false;
		//oParam.callback    = "cf_TRMNH04001";
	
	tranf_submit(oParam);
	
	monamt = Number(ds_init_mondetl.getColumn(0, "monamt"));
	
	if(utlf_isNull(monamt))
	{
		lastCnt = 0;
		for(var i = 0 ; i < ds_main_aidmtmultilist.rowcount; i++)
		{
			if((ds_main_aidmtmultilist.getColumn(i, "chk") == "true") && (ds_main_aidmtmultilist.getColumn(i, "payyn") == "N")) 
			{
				lastCnt++;
			}
		}
		
		if(lastCnt == 0)
		{
			sysf_messageBox("납부년월을", "C002");
			return;
		}

		for(var i = 0 ; i < ds_main_aidmtmultilist.rowcount; i++ )
		{
			if((ds_main_aidmtmultilist.getColumn(i, "chk") == "true") && (ds_main_aidmtmultilist.getColumn(i, "payyn")))
			{
				tempamt = tempamt - parseInt(amt/lastCnt);
				cnt++;
				if( cnt == lastCnt ) 
				{
					ds_main_aidmtmultilist.setColumn(i, "aidamt", (amt/lastCnt)+tempamt);
				}
				else 
				{
					ds_main_aidmtmultilist.setColumn(i, "aidamt", (amt/lastCnt));
				}

			}
		}
	}
	else 
	{
		lastCnt = 0;
		for(var i = 0 ; i < ds_main_aidmtmultilist.rowcount; i++ )
		{
			if((ds_main_aidmtmultilist.getColumn(i, "chk")=="true") && (ds_main_aidmtmultilist.getColumn(i, "payym")=="N")) 
			{
				lastCnt = i;
			}
		}
		
		if(lastCnt == 0)
		{
			sysf_messageBox("납부년월을", "C002");
			return;
		}
		
		for(var i = 0; i < ds_main_aidmtmultilist.rowcount; i++ )
		{
			if((ds_main_aidmtmultilist.getColumn(i, "chk")=="true")&&(ds_main_aidmtmultilist.getColumn(i, "payym")=="N")) 
			{
				if(amt >= monamt)
				{
					if(i == lastCnt)
					{
						ds_main_aidmtmultilist.setColumn(i, "aidamt", aidamt);
					}
					else
					{
						ds_main_aidmtmultilist.setColumn(i, "aidamt", monamt);
					}
					amt = amt - monamt;
				}
				else
				{
					ds_main_aidmtmultilist.setColumn(i, "aidamt", amt);
					amt = amt - amt;
				}
			}
		}
	}
}

function grd_aidmtlist_onkeydown(obj:Grid, e:KeyEventInfo)
{
	if(e.keycode == 13){
		obj.showEditor(false);
	}
}
]]></Script>
  </Form>
</FDL>