YNU_JEUS/app_home/himed/webapps/mis/accountinginfoweb/xrw/SMRAR00300_가수금상계조회.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>
						<maindatalist>
							<instcd/>
							<aactcd/>
							<gadate/>
							<gubun/>
							<rmrk/>
							<gaamt/>
							<janamt/>
							<sangflag/>
							<line/>
							<seqline/>
							<ymdwrite/>
							<unslno/>
							<sanctslipno/>
							<aactno/>
							<seqwrite/>
							<rowcnt/>
						</maindatalist>
					</main>
					<send>
						<instcd/>
						<gadate_fr/>
						<gadate_to/>
						<aactno/>
						<aactcd/>
					</send>
					<hidden>
						<apsl>
							<sumjanamt/>
						</apsl>
						<save/>
					</hidden>
					<init>
						<bankinfo>
							<aactno/>
							<aactcd/>
						</bankinfo>
					</init>
					<temp>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				        var fdate = getCurrentDate();    
					model.removenode( "/root/main/maindatalist");
					model.setValue("/root/send/instcd",   getUserInfo("dutplceinstcd"));					
					model.setValue("/root/send/gadate_fr", fdate.substr(0,4)+"0101" ); 
					model.setValue("/root/send/gadate_to", fdate); 

					submit("TRRAR00101");	//기관코드 send. / 예금계좌번호,코드 return.

					addComboItem("cmb_aactno","--전체--","","above");
					model.refresh();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					//정렬 순서로 sort함.
					function fGetSortSeq(){
						var num = grd_main.rows- 1;
						if(rdo_seq.value == 1){
							grd_main.sort(1, 2, num, 2) = "asc";
						}else{
							grd_main.sort(1, 3, num, 3) = "asc";
						}
						model.refresh(); 	  
					}
					
					//출력물순서 저장
					
					//엑셀 입력
					function fInputExcel(pGrid) {
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						if(fileName != "") {
							pGrid.loadExcel(fileName, 1, true);
							pGrid.deleteRow(1);
							
							for(i = 1; i < pGrid.rows; i++) {
								pGrid.rowStatus(i) = 1;
							}
							pGrid.refresh();
						}
					}
					
	       	      ]]>
			</script>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<submission id="TRRAR00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/bankinfo"/>
			<submission id="TRRAR00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/maindatalist"/>
			<submission id="TXRAR00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/save" resultref="/root/temp"/>
			<bind id="bind_cpt_sumjanamt" ref="/root/hidden/apsl/sumjanamt" calculate="sum(/root/main/maindatalist/janamt)"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">가수금 상계 조회</caption>
			<caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:38px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:38; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button2" class="btn1_letter2" navindex="4" style="left:1123px; top:9px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[						      
							//setAlertOn();
							submit("TRRAR00301");
							//model.setValue("/root/hidden/apsl/sumjanamt", 0);
							model.refresh();
						]]>
					</script>
				</button>
				<line id="line5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_gadate_fr" ref="/root/send/gadate_fr" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:423px; top:9px; width:110px; height:19px; "/>
				<caption id="caption2" style="left:539px; top:9px; width:15px; height:17px; ">~</caption>
				<input id="ipt_gadate_to" ref="/root/send/gadate_to" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:556px; top:9px; width:110px; height:19px; "/>
				<caption id="caption3" class="search_name" style="left:321px; top:9px; width:104px; height:17px; ">가수금일자 :</caption>
				<output id="opt_aactcd" ref="/root/send/aactcd" class="output_fix" appearance="output" style="left:252px; top:9px; width:55px; height:19px; "/>
				<caption id="caption5" class="search_name" style="left:11px; top:9px; width:104px; height:17px; ">예금계좌 :</caption>
				<select1 id="cmb_aactno" ref="/root/send/aactno" class="combo_s_essential" navindex="1" appearance="minimal" style="left:100px; top:9px; width:150px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/bankinfo">
							<label ref="aactno"/>
							<value ref="aactcd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[						
						model.setValue("/root/send/aactcd", cmb_aactno.value);
						model.refresh();
						]]>
					</script>
				</select1>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:75px; x2:1194px; y2:75px; "/>
			<datagrid id="grd_main" nodeset="/root/main/maindatalist" dragmode="false" caption="기관코드^예금계좌^보조과목^가수금일자^구분^적  요^전표작성일자^승인전표번호^asis전표번호^상계금액^Row No.^미결전표번호" colsep="^" colwidth="0, 130, 84, 100, 90, 238, 100, 100, 100, 120, 82, 0" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" selectionmode="byrow" tooltip="true" style="left:0px; top:80px; width:1194px; height:635px; ">
				<col ref="instcd" style="text-align:center; "/>
				<col ref="aactno" style="text-align:center; "/>
				<col ref="aactcd" style="text-align:center; "/>
				<col ref="gadate" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="gubun" style="text-align:center; "/>
				<col ref="rmrk"/>
				<col ref="ymdwrite" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="sanctslipno" style="text-align:center; "/>
				<col ref="seqwrite" style="text-align:center; "/>
				<col ref="janamt" format="#,###" style="text-align:right; "/>
				<col ref="rowcnt" style="text-align:right; "/>
				<col ref="unslno"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_main.gridToInstance();
					]]>
				</script>
			</datagrid>
			<button id="ipt_excsave" class="btn2_letter4" style="left:1055px; top:52px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[					
						misfSaveExcel(grd_main);						
					]]>
				</script>
			</button>
			<button id="button18" class="btn2_letter4" style="left:1122px; top:52px; width:64px; height:19px; ">
				<caption>전표취소</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
						misfGridIUD(grd_main, "D");	
						model.refresh();

						var cnt = 0;
						for ( var i = grd_main.fixedRows; i <= grd_main.rows; i++ ) {
							if ( grd_main.rowStatus(i)=='4' ) {	//delete
								cnt = cnt + 1;
							}
						}
						if ( cnt > 1){
							alert("동시에 여러건을 선택해서 취소 처리 할 수 없습니다.\n\n한 건만 선택해 주세요.");
							button2.dispatch("DOMActivate");
							return false;
						}
					
						if ( grd_main.valueMatrix(grd_main.row, grd_main.colRef("ymdwrite")).length == 0 || 
						     grd_main.valueMatrix(grd_main.row, grd_main.colRef("sanctslipno")).length== 0 ){
							alert("전표작성일자 또는 승인전표번호가 없는 상계건은 이 화면에서 취소 처리 할 수 없습니다.");
							button2.dispatch("DOMActivate");
							return false;
						}
					
						rtn = messageBox("전표작성일자: "+grd_main.valueMatrix(grd_main.row, grd_main.colRef("ymdwrite"))+",  승인전표번호: "+grd_main.valueMatrix(grd_main.row, grd_main.colRef("sanctslipno"))+" 의 \n\n전표 및 가수금상계를 취소 하며","Q002");
						if ( rtn == "6" ) {
							//입력,수정,삭제된 data save node 에 담기..
							model.setValue("/root/hidden/save",grd_main.getUpdateData());							
							if(submit("TXRAR00301"))	{
								button2.dispatch("DOMActivate");
							}
						}else{
							button2.dispatch("DOMActivate");
						}
						]]>
				</script>
			</button>
			<caption id="caption21" class="tit_2" style="left:5px; top:57px; width:131px; height:13px; ">출력 목록</caption>
			<caption id="caption7" style="left:85px; top:57px; width:500px; height:13px; ">(* 100,000건 이상 조회가 안됩니다. 계좌와 가수금일자를 선택하신 후 조회 해 주세요.)</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
		</group>
		<caption id="caption1" class="cell_1" style="left:877px; top:757px; width:100px; height:23px; text-align:center; vertical-align:middle; ">합  계</caption>
		<caption id="cpt_gaamtsum" ref="/root/hidden/apsl/sumjanamt" format="(-)#,###" style="left:978px; top:757px; width:120px; height:23px; text-align:right; vertical-align:middle; background-color:#ffcccc; "/>
		<button id="btn_print" class="btn4_letter2" visibility="visible" style="left:1135px; top:16px; width:56px; height:22px; ">
			<caption>출력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[

					exeReportPreview("SMRAR00301", "XMLSTR");
					
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>