YNU_JEUS/app_home/himed/webapps/crc/stdycostweb/xrw/SMIRM00200_통장입금관리.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>통장입금관리</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<acctinfo>
							<acctinfolist>
								<acntdd/>
								<depor/>
								<depoamt/>
								<subjno/>
								<fstrgstrnm/>
								<fstrgstrid/>
								<fstrgstdt/>
								<lastupdtnm/>
								<lastupdtid/>
								<lastupdtdt/>
								<seqno/>
								<cmt/>
								<confamt/>
								<unconfamt/>
							</acctinfolist>
						</acctinfo>
						<bbookmngt>
							<item>
								<acntdd/>
								<depor/>
								<depoamt/>
								<cmt/>
								<confamt/>
								<depoconfdd/>
								<subjno/>
								<depobnbkconfdd/>
								<seqno/>
								<direcamtyn/>
								<crccamtyn/>
								<hospamtyn/>
								<judgamtyn/>
								<drugmngtamt/>
								<documngtamt/>
							</item>
						</bbookmngt>
					</main>
					<cond>
						<acctfromdd/>
						<accttodd/>
					</cond>
					<send>
						<reqdata/>
						<savadata/>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					model.setValue("/root/cond/acctfromdd",getCurrentDate());
					model.setValue("/root/cond/accttodd",getCurrentDate());
					model.removeNodeset("/root/main/acctinfo/acctinfolist");
					btn_cncrpatsrch.selected = true;
					model.toggle("case1");
					model.refresh();
				]]>
			</script>
			<submission id="TXIRM00201" mediatype="application/x-www-form-urlencoded" method="urlencoded-post" ref="/root/send/savadata" replace="instance" resultref="/root/main/acctinfo"/>
			<submission id="TRIRM00201" mediatype="application/x-www-form-urlencoded" method="urlencoded-post" ref="/root/cond" replace="instance" resultref="/root/main/acctinfo"/>
			<submission id="TRIRM00202" mediatype="application/x-www-form-urlencoded" method="urlencoded-post" ref="/root/cond" replace="instance" resultref="/root/main/bbookmngt"/>
			<submission id="TXIRM00202" mediatype="application/x-www-form-urlencoded" method="urlencoded-post" ref="/root/send/savadata" replace="instance" resultref="/root/main/acctinfo"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/userdeptinfoweb/js/ZSU001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/departmentcodeweb/js/ZSD001.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
	</xhtml:head>
	<xhtml:body guideline="1,1360;2,815;2,812;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1125px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:189px; height:14px; ">통장입금관리</caption>
		</group>
		<button id="btn_cncrpatsrch" class="btn_sw" group="tab" selected="true" style="left:0px; top:14px; width:100px; height:22px; ">
			<caption>통장정보입금</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					model.toggle("case1");
					btn_cncrpatsrch.selected =true;
				]]>
			</script>
		</button>
		<switch id="switch1" style="left:0px; top:35px; width:867px; height:745px; ">
			<case id="case1">
				<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:3px; width:865px; height:52px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button2" class="btn1_letter2" style="left:790px; top:20px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							if(submit("TRIRM00201")){
								grd_acctinfolist.rebuildStyle();
								setRowStyle("grd_acctinfolist","3","Y","depoconflag","equal"); // mis에 저장구분 RowStyle변경
								for(var i = grd_acctinfolist.fixedRows;i < grd_acctinfolist.rows;i++){
								var depoconfdd = model.getValue("/root/main/acctinfo/acctinfolist["+i+"]/depoconfdd");
									if(depoconfdd ==""){
										btn_save.disabled = false;
										btn_send.disabled = false;
									}								
								}
							}
							
						]]>
					</script>
				</button>
				<input id="ipt_acctfromdd" ref="/root/cond/acctfromdd" class="input_search" inputtype="date" style="left:114px; top:22px; width:100px; height:19px; "/>
				<input id="ipt_accttodd" ref="/root/cond/accttodd" class="input_search" inputtype="date" style="left:229px; top:22px; width:100px; height:19px; "/>
				<caption id="cap_orddd" class="search_name" style="left:24px; top:23px; width:86px; height:17px; ">입금일자 :</caption>
				<line id="line4" class="line_4" style="x1:769px; y1:13px; x2:769px; y2:50px; "/>
				<datagrid id="grd_acctinfolist" nodeset="/root/main/acctinfo/acctinfolist" class="datagrid2" caption="입금일자 ^입금자^입금액^적요^과제번호^최초입력자^최초입력자아이디^최초입력일시^최종수정자 ^최종수정자아이디^최종수정일시^seqno^depoconfdd^depoconflag^confamt^unconfamt^" colsep="^" colwidth="90, 131, 148, 302, 174, 90, 65, 100, 102, 77, 80, 100, 100, 100, 100, 100" dataheight="11" explorerbar="sort" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" selectionmode="byrow" style="left:0px; top:95px; width:865px; height:645px; ">
					<col ref="acntdd" type="inputdate"/>
					<col ref="depor" type="input" style="text-align:center; "/>
					<col ref="depoamt" type="input" format="(-)#,###" style="text-align:right; "/>
					<col ref="cmt" type="input"/>
					<col ref="subjno" type="input"/>
					<col ref="fstrgstrnm" visibility="hidden" style="text-align:center; "/>
					<col disabled="true" ref="fstrgstrid" visibility="hidden"/>
					<col disabled="true" ref="fstrgstdt" type="output" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
					<col disabled="true" ref="lastupdtrnm" type="output" visibility="hidden" style="text-align:center; "/>
					<col disabled="true" ref="lastupdtrid" visibility="hidden"/>
					<col disabled="true" ref="lastupdtdt" type="output" visibility="hidden" format="yyyy-mm-dd" style="text-align:center; "/>
					<col ref="acntseqno" visibility="hidden"/>
					<col ref="depoconfdd" visibility="hidden"/>
					<col ref="depoconflag" visibility="hidden"/>
					<col ref="confamt" visibility="hidden"/>
					<col ref="unconfamt" visibility="hidden"/>
					<script type="javascript" ev:event="onaftersort">
						<![CDATA[
						grd_acctinfolist.gridToInstance();
						]]>
					</script>
					<script type="javascript" ev:event="ondblclick">
						<![CDATA[
							var MdfyChk = model.getValue("/root/main/acctinfo/acctinfolist["+grd_acctinfolist.row+"]/depoconflag");
							var i = grd_acctinfolist.row;
							
							if (MdfyChk == "Y")
							{
								grd_acctinfolist.isReadOnly(i, grd_acctinfolist.colRef("acntdd"), i, grd_acctinfolist.colRef("depor"))=true; 
								grd_acctinfolist.isReadOnly(i, grd_acctinfolist.colRef("depoamt"), i, grd_acctinfolist.colRef("cmt"))=true; 
								grd_acctinfolist.isReadOnly(i, grd_acctinfolist.colRef("subjno"))=true; 
							}

							
						]]>
					</script>
					<!--2009.07.16 사업자등록번호에서 과제번호로 바뀜-->
					<!--script type="javascript" ev:event="onbuttonclick">
						<![CDATA[
						if(grd_acctinfolist.col == grd_acctinfolist.colRef("entrregno") ){
							window.load("../../stdycostweb/xrw/SPICU01900_사업자등록번호조회.xrw","modal","", "left:400px; top:400px; width:534px; height:343px;min:hidden;max:hidden;resize:true;");
							model.setValue("/root/main/acctinfo/acctinfolist["+grd_acctinfolist.row+"]/entrregno",getParameter("entrregno"));
							var acntseqno = model.getValue("/root/main/acctinfo/acctinfolist["+grd_acctinfolist.row+"]/acntseqno");
							if(acntseqno !=""){
								grd_acctinfolist.rowStatus(grd_acctinfolist.row) = 2;
							}else if(acntseqno ==""){
								grd_acctinfolist.rowStatus(grd_acctinfolist.row) = 1;
							}
							grd_acctinfolist.refresh();
						}
						]]>
					</script-->
				</datagrid>
				<caption id="caption60" class="search_no_b" style="left:215px; top:23px; width:12px; height:17px; ">~</caption>
				<button id="btn_save" class="btn4_letter2" style="left:694px; top:66px; width:56px; height:22px; ">
					<caption>저장</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						for(var i = grd_acctinfolist.fixedRows;i < grd_acctinfolist.rows;i++){
							var acntdd = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("acntdd"));
							var depoamt = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("depoamt"));
							var depor = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("depor"));							
							var cmt = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("cmt"));
							if(acntdd  ==""){
								messageBox("입금일자는","I003");
								return;
							}
							if(depor  ==""){
								messageBox("입금자는","I003");
								return;
							}
							if(depoamt  ==""){
								messageBox("입금액은","I003");
								return;
							}
							
							if(cmt  ==""){
								messageBox("적요는","I003");
								return;
							}
							
						}
						model.makeValue("/root/send/savadata/acctinfolist",grd_acctinfolist.getUpdateData());
						model.makeValue("/root/send/savadata/cond/acctfromdd",model.getValue("/root/cond/acctfromdd"));
						model.makeValue("/root/send/savadata/cond/accttodd",model.getValue("/root/cond/accttodd"));
						if(submit("TXIRM00201")){
							model.removeNodeset("/root/send/savadata");
						}
						]]>
					</script>
				</button>
				<button id="button1" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:625px; top:68px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
					<caption>엑셀입력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							grd_acctinfolist.rebuildStyle();							
						    var fileName	 = window.fileDialog("open", "|", true, "", "", "Excel Files(*.xls)|*.xls");
							grd_acctinfolist.loadExcel(fileName);
							for(var i = grd_acctinfolist.fixedRows;i < grd_acctinfolist.rows;i++){
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("fstrgstrnm")) =getUserName();
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("fstrgstrid")) =getUserId();
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("lastupdtrnm")) =getUserName();
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("lastupdtrid")) =getUserId();
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("fstrgstdt")) =getCurrentDate();
								grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("lastupdtdt")) =getCurrentDate();
								grd_acctinfolist.rowStatus(i) = 1;
								var acntdd = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("acntdd"));
								var depoamt = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("depoamt"));
								var depor = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("depor"));							
								var subjno = grd_acctinfolist.valueMatrix(i,grd_acctinfolist.colRef("subjno"));
								if(acntdd  ==""){
									 grd_acctinfolist.cellStyle("background-color", i, grd_acctinfolist.colRef("acntdd")) = "#FFFDBF";
								}
								if(depor  ==""){
									grd_acctinfolist.cellStyle("background-color", i, grd_acctinfolist.colRef("depor")) = "#FFFDBF";
								}
								if(depoamt  ==""){
									grd_acctinfolist.cellStyle("background-color", i, grd_acctinfolist.colRef("depoamt")) = "#FFFDBF";
								}
								
								if(subjno  ==""){
									grd_acctinfolist.cellStyle("background-color", i, grd_acctinfolist.colRef("subjno")) = "#FFFDBF";
								}
							}
							grd_acctinfolist.refresh();
						]]>
					</script>
				</button>
				<button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:556px; top:68px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
					<caption>엑셀저장</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
		
							if (fileName != "")
							{
								grd_acctinfolist.saveExcel(fileName);
							}
						]]>
					</script>
				</button>
				<caption id="caption17" class="hand" style="left:0px; top:60px; width:462px; height:28px; vertical-align:middle; ">
					<![CDATA[엑셀에 화면순서대로 데이터를 작성해 주세요!
입금일자,입금자,입금액은 필수로 작성해 주세요!]]>
				</caption>
				<button id="btn_addrow1" class="btn2_letter3" navindex="35" style="left:440px; top:68px; width:53px; height:19px; ">
					<caption>행추가</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						grd_acctinfolist.addRow();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("fstrgstrnm")) =getUserName();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("fstrgstrid")) =getUserId();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("lastupdtrnm")) =getUserName();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("lastupdtrid")) =getUserId();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("fstrgstdt")) =getCurrentDate();
						grd_acctinfolist.valueMatrix(grd_acctinfolist.row,grd_acctinfolist.colRef("lastupdtdt")) =getCurrentDate();
						grd_acctinfolist.refresh();
						]]>
					</script>
				</button>
				<button id="btn_delrow1" class="btn2_letter3" style="left:498px; top:68px; width:53px; height:19px; ">
					<caption>행삭제</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						if(grd_acctinfolist.row <= 0)
						{
							messageBox("삭제할 행이 ", "I004")
							btn_save.disabled = true;
							btn_send.disabled = true;
							return;
						}
						if (grd_acctinfolist.selectedRows > 0) {
							var selectedRows = Array(grd_acctinfolist.selectedRows);
							for(i=0;i<grd_acctinfolist.selectedRows;i++) {
								selectedRows[i] = grd_acctinfolist.selectedRow(i);
							}
						}
						var rowIdx;
						for ( var i= selectedRows.length ; i >= 0 ; i--)
						{   
							rowIdx = selectedRows[i];
							grd_acctinfolist.deleteRow( rowIdx , false);    
						}
						model.refresh();
					]]>
					</script>
				</button>
				<button id="btn_send" class="btn4_letter6" style="left:755px; top:66px; width:104px; height:22px; ">
					<caption>입금전표생성</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

						var msg = messageBox("입금전표생성 후에는 수정이 불가합니다\n"+ "\n"+ "그래도","Q004");
						if(msg == "6"){
								for(var i = grd_acctinfolist.fixedRows;i < grd_acctinfolist.rows;i++){
								var depoconfdd = model.getValue("/root/main/acctinfo/acctinfolist["+i+"]/depoconfdd");
									if(depoconfdd ==""){
										grd_acctinfolist.rowStatus(i) = 1;	
									}
								model.makeValue("/root/main/acctinfo/acctinfolist["+i+"]/depoconfdd",getCurrentDate());
								}
							model.makeValue("/root/send/savadata/acctinfolist",grd_acctinfolist.getUpdateData());
							model.makeValue("/root/send/savadata/cond/acctfromdd",model.getValue("/root/cond/acctfromdd"));
							model.makeValue("/root/send/savadata/cond/accttodd",model.getValue("/root/cond/accttodd"));
						
							if(submit("TXIRM00202")){
								model.removeNodeset("/root/send/savadata");
								grd_acctinfolist.rebuildStyle();
								setRowStyle("grd_acctinfolist","3","Y","depoconflag","equal"); // mis에 저장구분 RowStyle변경
							}
						}else if(msg == "7"){
							return;
							
						}
						]]>
					</script>
				</button>
				<line id="line3" class="line_1" style="x1:0px; y1:90px; x2:865px; y2:90px; "/>
			</case>
			<case id="case2" selected="true">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:3px; width:865px; height:52px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption1" class="search_no_b" style="left:215px; top:23px; width:12px; height:17px; ">~</caption>
				<button id="button7" class="btn1_letter2" style="left:790px; top:20px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							submit("TRIRM00202");
						]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:24px; top:23px; width:86px; height:17px; ">입금일자 :</caption>
				<input id="input1" ref="/root/cond/acctfromdd" class="input_search" inputtype="date" style="left:114px; top:22px; width:100px; height:19px; "/>
				<input id="input2" ref="/root/cond/accttodd" class="input_search" inputtype="date" style="left:229px; top:22px; width:100px; height:19px; "/>
				<line id="line1" class="line_4" style="x1:769px; y1:13px; x2:769px; y2:50px; "/>
				<caption id="caption3" class="tit_2" style="left:0px; top:70px; width:100px; height:13px; ">통장내역조회</caption>
				<line id="line2" class="line_1" style="x1:0px; y1:85px; x2:865px; y2:85px; "/>
				<button id="btn_excel" class="btn2_letter3" style="left:810px; top:65px; width:53px; height:19px; ">
					<caption>Excel</caption>
					<script type="javascript" ev:event="onclick">
						<![CDATA[					
						var fileName = window.fileDialog("save",",",false,"통장내역조회","xls","All Files(*.*)|*.*|Excel Files(*.xls)|*.xls");
						
						if(fileName !=""){								
							datagrid1.saveExcel(fileName);								
						} 
					]]>
					</script>
				</button>
				<datagrid id="datagrid1" nodeset="/root/main/bbookmngt/item" caption="입금일자^입금자^입금액^적요^확인금액^입금확인일^과제번호^차수^대체확인일^직접^병간^센간^심사^약제^문서" colsep="^" colwidth="70, 65, 75, 110, 63, 70, 100, 30, 70, 30, 30, 30, 30, 30, 30" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:90px; width:865px; height:650px; ">
					<col ref="acntdd" format="yyyy-mm-dd"/>
					<col ref="depor"/>
					<col ref="depoamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="cmt"/>
					<col ref="confamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="depoconfdd" format="yyyy-mm-dd"/>
					<col ref="subjno" style="text-align:center; "/>
					<col ref="seqno" style="text-align:center; "/>
					<col ref="depobnbkconfdd" format="yyyy-mm-dd"/>
					<col checkvalue="Y,N" ref="direcamtyn" type="checkbox"/>
					<col checkvalue="Y,N" ref="crccamtyn" type="checkbox"/>
					<col checkvalue="Y,N" ref="hospamtyn" type="checkbox"/>
					<col checkvalue="Y,N" ref="judgamtyn" type="checkbox"/>
					<col checkvalue="Y,N" ref="drugmngtamt" type="checkbox"/>
					<col checkvalue="Y,N" ref="documngtamt" type="checkbox"/>
				</datagrid>
			</case>
		</switch>
		<button id="btn_bbookmngt" class="btn_sw" group="tab" style="left:99px; top:14px; width:118px; height:22px; ">
			<caption>통장내역조회</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					model.toggle("case2");
					btn_bbookmngt.selected =true;
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>