YNU_JEUS/app_home/himed/webapps/mis/accountinginfoweb/xrw/SMRAR00200_가수금상계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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/>
							<line/>
							<seqline/>
							<aactno/>
							<aactcd/>
							<gadate/>
							<gubun/>
							<rmrk/>
							<gaamt/>
							<janamt/>
							<sangflag/>
							<ymdwrite/>
							<seqwrite/>
							<sangflag_text/>
							<hiscnt/>
							<hissumjanamt/>
							<statementdate/>
							<realjanamt/>
						</maindatalist>
					</main>
					<send>
						<instcd/>
						<statementdate/>
						<gadate_fr/>
						<gadate_to/>
					</send>
					<hidden>
						<apsl>
							<sumgaamt/>
							<sumjanamt/>
						</apsl>
						<save/>
					</hidden>
					<init>
					</init>
					<temp>
						<unsllist>
							<instcd/>
							<statementdate/>
							<unslno/>
						</unsllist>
					</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/statementdate", fdate); 
					var vyear = fdate.substr(0,4) + "0101"
					model.setValue("/root/send/gadate_fr", vyear); 
					model.setValue("/root/send/gadate_to", fdate); 

					submit("TRRAR00201");
					
					model.refresh();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
				
					var chkflag = 0;
					
					//조회
					function fGetMainDataList()	{
						setAlertOn();
						submit("TRRAR00201");
						model.setValue("/root/hidden/apsl/sumjanamt", 0);
						model.refresh();
					}	
					
					//정렬 순서로 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();
						}
					}
					
					//저장시 입력data checking logic..
					function fSetChackValue() 
					{
						var updtdata = getGridUpdateData(grd_main);
						if (updtdata == ""){
							messageBox("변경된 데이터가","I004");
							return false;
						}
						var row = grd_main.row;
						for ( var i = grd_main.fixedRows; i <= grd_main.rows; i++ ) {							
							if ( grd_main.rowStatus(i)=='2' ) {	//update..
								if ( grd_main.valueMatrix(i, grd_main.colRef("sangflag"))=="Y" ){
									//전표번호적용..
									grd_main.valueMatrix(i, grd_main.colRef("statementdate")) = ipt_statementdate.value;									
									
									if ( grd_main.valueMatrix(i, grd_main.colRef("janamt")).length==0 || grd_main.valueMatrix(i, grd_main.colRef("janamt"))==0 ){
										messageBox("상계금액을" ,"C001");
										grd_main.row = i;
										grd_main.col  = grd_main.colRef("janamt");
										grd_main.editCell();
										return false;
									}
								       if ( ( parseInt(grd_main.valueMatrix(i, grd_main.colRef("gaamt"))) - parseInt(grd_main.valueMatrix(i, grd_main.colRef("hissumjanamt")) ) < grd_main.valueMatrix(i, grd_main.colRef("janamt"))) ) {
										messageBox("상계금액이 "+ (grd_main.valueMatrix(i, grd_main.colRef("gaamt")) - grd_main.valueMatrix(i, grd_main.colRef("hissumjanamt")))+" 보다 클 수 없습니다. 다시 " ,"C001");
										grd_main.row = i;
										grd_main.col  = grd_main.colRef("janamt");
										grd_main.editCell();
										return false;
									}
								}
							}
						}
						//rtn = messageBox("", "Q002");
						//if(rtn != "6" ) return false;
						return true;
					}					
					
	       	      ]]>
			</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"/>
			<bind id="bind_cpt_gaamtsum" ref="/root/hidden/apsl/sumgaamt" calculate="sum(/root/main/maindatalist/gaamt)-sum(/root/main/maindatalist/janamt)"/>
			<submission id="TRRAR00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/maindatalist"/>
			<submission id="TXRAR00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/save" resultref="/root/temp"/>
		</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[
						
						      fGetMainDataList();
						
						]]>
					</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_statementdate" ref="/root/send/statementdate" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:978px; top:9px; width:110px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var row = grd_main.row;
						for ( var i = grd_main.fixedRows; i <= grd_main.rows; i++ ) {							
							grd_main.valueMatrix(i, grd_main.colRef("statementdate")) = ipt_statementdate.value;
						}
						//model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption3" class="search_name" style="left:886px; top:9px; width:104px; height:17px; ">전표일자 :</caption>
				<input id="ipt_gadate_fr" ref="/root/send/gadate_fr" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:118px; top:9px; width:110px; height:19px; "/>
				<input id="ipt_gadate_to" ref="/root/send/gadate_to" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:251px; top:9px; width:110px; height:19px; "/>
				<caption id="caption2" style="left:234px; top:9px; width:15px; height:17px; ">~</caption>
				<caption id="caption5" class="search_name" style="left:16px; top:9px; width:104px; height:17px; ">가수금일자 :</caption>
			</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="true" caption="예금계좌^보조과목^가수금일자^구분^적  요^가수금액^상계금액^전표^전표^이미상계된금액^instcd^line^seqline^적용할전표일^상계후실잔액" colsep="^" colwidth="120, 70, 90, 90, 190, 110, 110, 28, 70, 90, 0, 0, 0, 90, 90" 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="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="gaamt" format="#,###" style="text-align:right; "/>
				<col class="input_s_essential" ref="janamt" type="input" format="#,###" style="text-align:right; "/>
				<col checkvalue="Y,N" ref="sangflag" type="checkbox"/>
				<col ref="sangflag_text"/>
				<col ref="hissumjanamt" format="#,###" style="text-align:right; "/>
				<col ref="instcd"/>
				<col ref="line"/>
				<col ref="seqline"/>
				<col ref="statementdate" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="realjanamt" format="#,###" style="text-align:right; "/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_main.gridToInstance();
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[

				      	if (grd_main.col == grd_main.colRef("sangflag") ) {
						if (grd_main.valueMatrix(grd_main.row, grd_main.colRef("sangflag")) == 'Y') {		//가수금 - 이전상계금액합계            						
							grd_main.valueMatrix(grd_main.row, grd_main.colRef("janamt")) = grd_main.valueMatrix(grd_main.row, grd_main.colRef("gaamt")) - grd_main.valueMatrix(grd_main.row, grd_main.colRef("hissumjanamt"));
							grd_main.valueMatrix(grd_main.row, grd_main.colRef("statementdate")) = ipt_statementdate.value;
						} else {
							grd_main.valueMatrix(grd_main.row, grd_main.colRef("janamt")) = 0;
						}
				      	}
				      	if ( grd_main.col==grd_main.colRef("sangflag")||grd_main.col==grd_main.colRef("janamt") ) {
				      		grd_main.valueMatrix(grd_main.row, grd_main.colRef("realjanamt")) = parseInt(grd_main.valueMatrix(grd_main.row, grd_main.colRef("gaamt"))) - (parseInt(grd_main.valueMatrix(grd_main.row, grd_main.colRef("janamt"))) + parseInt(grd_main.valueMatrix(grd_main.row, grd_main.colRef("hissumjanamt")))) ;
				      		var sumjanamt = 0;
				      		for ( var i = grd_main.fixedRows; i <= grd_main.rows; i++ ) {							
							if ( grd_main.valueMatrix(i, grd_main.colRef("sangflag"))=="Y" ){
								sumjanamt = sumjanamt + parseInt(grd_main.valueMatrix(i, grd_main.colRef("janamt")));
							}else{
								grd_main.removeStatus( i , "update");
							}
						}
				      		model.setValue("/root/hidden/apsl/sumjanamt", sumjanamt);
				      	}	
				      				      				      	
					]]>
				</script>
				<script type="javascript" ev:event="onmouseup">
					<![CDATA[
					
						// 2011.07.25 cyw Sangflag 컬럼에서 드레그시, 드레그 영역 자동체크&계산
						if( grd_main.col == grd_main.colRef("sangflag") ){
							if( grd_main.selectedRows > 1){
								for( var i = 0 ; i < grd_main.selectedRows ; i++ ){
									if(model.getValue("/root/main/maindatalist[" + grd_main.selectedRow(i) + "]/sangflag") == "N"){
										model.setValue("/root/main/maindatalist[" + grd_main.selectedRow(i) + "]/sangflag" , "Y");
	
								      		grd_main.rowStatus( grd_main.selectedRow(i) ) = 2;
									}else{
	
										model.setValue("/root/main/maindatalist[" + grd_main.selectedRow(i) + "]/sangflag" , "N");
								      		grd_main.removeStatus(  grd_main.selectedRow(i) , "update");
									}
									
		
									if (grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("sangflag")) == 'Y') {		//가수금 - 이전상계금액합계            						
										grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("janamt")) = grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("gaamt")) - grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("hissumjanamt"));
										grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("statementdate")) = ipt_statementdate.value;
									} else {
										grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("janamt")) = 0;
									}
		
							      		grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("realjanamt")) = parseInt(grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("gaamt"))) - (parseInt(grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("janamt"))) + parseInt(grd_main.valueMatrix( grd_main.selectedRow(i), grd_main.colRef("hissumjanamt")))) ;
							      		var sumjanamt = 0;
							      		for ( var a = grd_main.fixedRows; a <= grd_main.rows; a++ ) {							
										if ( grd_main.valueMatrix(a, grd_main.colRef("sangflag"))=="Y" ){
											sumjanamt = sumjanamt + parseInt(grd_main.valueMatrix(a, grd_main.colRef("janamt")));
										}
									}
							      		model.setValue("/root/hidden/apsl/sumjanamt", sumjanamt);		
								}
							}
						}
						model.recalculate();
						model.refresh();	
					]]>
				</script>
			</datagrid>
			<button id="ipt_excsave" class="btn2_letter4" style="left:1127px; top:52px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						misfSaveExcel(grd_main);
						
					]]>
				</script>
			</button>
			<caption id="caption21" class="tit_2" style="left:5px; top:57px; width:131px; height:13px; ">출력 목록</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<button id="button39" class="btn4_letter2" style="left:1137px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					if( fSetChackValue()  ) {		//저장시 입력data checking logic..
						rtn = messageBox("저장하시면 체크하신 DATA를 상계하면서 전표처리 합니다.","Q002");
						if ( rtn == "6" ) {						
							//입력,수정,삭제된 data save node 에 담기..
							model.setValue("/root/hidden/save",grd_main.getUpdateData());
							if(submit("TXRAR00201"))	{
								//전표입력창 띄우기						
								model.makeValue("/root/source/slipinfo/instcd", model.getValue("/root/temp/unsllist/instcd"));
								model.makeValue("/root/source/slipinfo/slipdt", model.getValue("/root/temp/unsllist/statementdate"));	//미결전표일자
								model.makeValue("/root/source/slipinfo/slipno", model.getValue("/root/temp/unsllist/unslno"));//미결전표번호
								model.refresh();
								modal("SMRAD08100","","","","","/root/source", "/root/target" );	
								//opener.javascript.grd_unsl.rowStatus(1) = "2";								
								button2.dispatch("DOMActivate");
							}							
						}
					}
					]]>
				</script>
			</button>
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
		</group>
		<caption id="caption1" class="cell_1" style="left:534px; top:757px; width:120px; height:23px; text-align:center; vertical-align:middle; ">합  계</caption>
		<caption id="cpt_gaamtsum" ref="/root/hidden/apsl/sumgaamt" format="(-)#,###" style="left:655px; top:757px; width:110px; height:23px; text-align:right; vertical-align:middle; background-color:#ffcccc; "/>
		<caption id="cpt_janamtsum" ref="/root/hidden/apsl/sumjanamt" format="(-)#,###" style="left:766px; top:757px; width:120px; height:23px; text-align:right; vertical-align:middle; padding-right:2; background-color:#ffe79d; "/>
		<button id="btn_print" class="btn4_letter2" visibility="visible" style="left:1080px; top:16px; width:56px; height:22px; ">
			<caption>출력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[

					exeReportPreview("SMRAR00201", "XMLSTR");

					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>