YNU_JEUS/app_home/himed/webapps/mis/accountinginfoweb/xrw/SMRAR00800_구매건전자결제파일생성.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/>
							<entrregno/>
							<rrgstno/>
							<custnm/>
							<ibgoymd/>
							<yejungymd/>
							<keumak/>
							<rmrk/>
							<transymd/>
							<signflag/>
							<kydate/>
							<kyseq/>
							<ymdaction/>
							<seq/>
							<line/>
						</maindatalist>
						<mainexcellist>
							<instcd/>
							<seq/>
							<entrregno/>
							<rrgstno/>
							<custnm/>
							<ibgoymd/>
							<yejungymd/>
							<keumak/>
							<rmrk/>
						</mainexcellist>
					</main>
					<send>
						<instcd/>
						<senddate/>
						<signflag/>
						<senddatetmp/>
					</send>
					<hidden>
						<apsl>
							<sumkeumak/>
							<rowcount/>
						</apsl>
						<save/>
					</hidden>
					<init>
						<senddaylist>
							<label/>
							<value/>
						</senddaylist>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				        var fdate = getCurrentDate();    
					model.removenode( "/root/main/maindatalist");
					model.removenode( "/root/main/mainexcellist");
					model.setValue("/root/send/instcd",   getUserInfo("dutplceinstcd"));
					model.setValue("/root/send/senddate", fdate); 

					fGetSendDayList();
					
					button1.dispatch("DOMActivate"); //전송자료생성버튼 click
				]]>
			</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();
						}
					}
					
					function fGetSendDayList(){
						if( submit("TRRAR00802") ){	//조회가능한 전송일자 리스트
							cmb_sendday.refresh();
						}
					}
					
					//data checking logic..
					function fSetChackValue() 
					{
						/*var row = grd_main.row;
						var signflagN = 0;
						for ( var i = grd_main.fixedRows; i <= grd_main.rows; i++ ) {							
							if ( grd_main.valueMatrix(i, grd_main.colRef("signflag"))=="N" ){
								signflagN = signflagN + 1;
							}
						}
						if ( signflagN == 0 ) {
							alert("전송자료생성을 클릭하셔서 조회 후 생성해 주세요.");
							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"/>
			<submission id="TRRAR00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main"/>
			<submission id="TRRAR00802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/senddaylist"/>
			<submission id="TXRAR00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/save" resultref="/root/temp"/>
			<bind id="bind_cpt_sumkeumak" ref="/root/hidden/apsl/sumkeumak" calculate="sum(/root/main/mainexcellist/keumak)"/>
		</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_letter7" navindex="4" style="left:1073px; top:9px; width:80px; height:22px; text-align:left; ">
					<caption>전송내역조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							setAlertOn();
							model.setValue("/root/send/signflag", "Y");							
							if (submit("TRRAR00801") ){
								//var k=0;
								//model.setValue("/root/hidden/apsl/sumkeumak", 0);
								
								//2011.06.20 박준범 -  " i <= grd_main.rows" 이 부분의 부등호를 "<" 로 변경함
								for ( var i = grd_main.fixedRows; i < grd_main.rows; i++ ) {							
									grd_main.valueMatrix(i, grd_main.colRef("line")) = i;
								}
								grd_main.refresh();							
							}
						]]>
					</script>
				</button>
				<line id="line5" class="line_4" style="x1:1057px; y1:8px; x2:1057px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_senddate" ref="/root/send/senddate" class="input_s_essential" inputtype="date" style="left:213px; top:9px; width:110px; height:19px; "/>
				<caption id="caption3" class="search_name" style="left:11px; top:9px; width:104px; height:17px; ">전송일자 :</caption>
				<select1 id="cmb_sendday" ref="/root/send/senddatetmp" class="combo_s_essential" navindex="1" appearance="minimal" style="left:100px; top:9px; width:110px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/senddaylist">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var sendday = cmb_sendday.value;
							model.setValue("/root/send/senddate", sendday );
       							model.refresh();
       							button2.dispatch("DOMActivate");
						]]>
					</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" caption="순번^사업자번호^업체명^검수일자^결제일자^구입금액^매입채무액^계약건명^전송^instcd^seq^transymd^kydate^kyseq^ymdaction" colsep="^" colwidth="50, 110, 170, 100, 100, 100, 100, 300, 50, 0, 0, 0, 0, 0, 0" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" tooltip="true" style="left:0px; top:80px; width:1194px; height:635px; ">
				<col ref="line" style="left:20px; top:23px; width:50px; height:23px; text-align:center; "/>
				<col ref="entrregno" format="999-99-99999" style="text-align:center; "/>
				<col ref="custnm" style="text-align:left; "/>
				<col ref="ibgoymd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="yejungymd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="keumak" format="#,###" style="text-align:right; "/>
				<col ref="keumak" format="#,###" style="text-align:right; "/>
				<col ref="rmrk" style="text-align:left; "/>
				<col ref="signflag" style="text-align:center; "/>
				<col ref="instcd" style="text-align:center; "/>
				<col ref="seq" style="text-align:center; "/>
				<col ref="transymd" style="text-align:center; "/>
				<col ref="kydate"/>
				<col ref="kyseq"/>
				<col ref="ymdaction"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_main.gridToInstance();
					]]>
				</script>
			</datagrid>
			<button id="ipt_excsave" class="btn2_letter3" style="left:1133px; top:52px; width:53px; height:19px; ">
				<caption>생 성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					if( fSetChackValue() ) {		//저장시 입력data checking logic..
						rtn = messageBox("아래의 DATA 생성을","Q003");
						if ( rtn == "6" ) {
							
							var signflagY = 0;
							
							//2011.06.20 박준범 -  " i <= grd_main.rows" 이 부분의 부등호를 "<" 로 변경함
							for ( var i = grd_main.fixedRows; i < grd_main.rows; i++ ) {							
								if ( grd_main.valueMatrix(i, grd_main.colRef("signflag"))=="Y" ){
									signflagY = signflagY + 1;
								}
							}
							//alert( "signflag Y 생성건: " + signflagY);
							if ( signflagY > 0 ) {
								misfSaveExcel(grd_excel);
							}else{
								//N 인경우 DATA를 UPDATE 하고 아닌경우는 엑셀만 받는다.
								
								//2011.06.20 박준범 -  " i <= grd_main.rows" 이 부분의 부등호를 "<" 로 변경함
								for ( var i = grd_main.fixedRows; i < grd_main.rows; i++ ) {
									grd_main.rowStatus(i) = 2;
									grd_main.valueMatrix(i, grd_main.colRef("transymd")) = ipt_senddate.value;
									grd_main.valueMatrix(i, grd_main.colRef("signflag")) = "Y";
									grd_main.valueMatrix(i, grd_main.colRef("seq")) = grd_main.valueMatrix(i, grd_main.colRef("line"));
								}
								
								//입력,수정,삭제된 data save node 에 담기..
								model.setValue("/root/hidden/save", grd_main.getUpdateData());
								
								if(submit("TXRAR00801"))	{
									//2011.06.22 박준범 - Excel 자료 생성시점을 다시 조회하기 전으로 옮겼음 
									misfSaveExcel(grd_excel);

									fGetSendDayList();
									
									//2011.06.22 박준범 - 하단의 구현된 것이 button2 클릭 이벤트의 구현부와 동일하여 event 호출로 대체함
									button2.dispatch("DOMActivate"); //전송내역조회버튼 click
									
									/* 2011.06.22 박준범 - 위의 코드로 대체 후 comment 처리함											
									model.setValue("/root/send/signflag", "Y");
									
									if (submit("TRRAR00801") ){

										//2011.06.20 박준범 -  " i <= grd_main.rows" 이 부분의 부등호를 "<" 로 변경함
										for ( var i = grd_main.fixedRows; i < grd_main.rows; i++ ) {							
											grd_main.valueMatrix(i, grd_main.colRef("line")) = i;
										}
										grd_main.refresh();							
										
										//2011.06.22 박준범 - Excel 자료 생성시점을 다시 조회하기 전으로 옮기기 위해 comment 처리
										//misfSaveExcel(grd_excel);
									}
									*/									
								}
							}
						}
					}
					]]>
				</script>
			</button>
			<caption id="caption21" class="tit_2" style="left:5px; top:57px; width:200px; height:13px; ">전자결제 전송파일 생성</caption>
			<button id="button1" class="btn2_letter6" style="left:1042px; top:52px; width:86px; height:19px; ">
				<caption>전송자료생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[					
						setAlertOn();
						model.setValue("/root/send/signflag", "N");
						if (submit("TRRAR00801") ){
							
							//2011.06.20 박준범 -  " i <= grd_main.rows" 이 부분의 부등호를 "<" 로 변경함
							for ( var i = grd_main.fixedRows; i < grd_main.rows; i++ ) {							
								grd_main.valueMatrix(i, grd_main.colRef("line")) = i;
							}
							grd_main.refresh();
						}				
					]]>
				</script>
			</button>
			<datagrid id="grd_excel" nodeset="/root/main/mainexcellist" visibility="hidden" colsep="^" colwidth="70, 100, 103, 170, 100, 100, 100, 100, 170" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" tooltip="true" style="left:20px; top:430px; width:1155px; height:280px; ">
				<col ref="seq"/>
				<col ref="entrregno" style="text-align:left; "/>
				<col ref="rrgstno" format="999999-9999999" style="left:20px; top:23px; width:50px; height:23px; text-align:left; "/>
				<col ref="custnm" style="text-align:left; "/>
				<col ref="ibgoymd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="yejungymd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="keumak" style="left:593px; top:23px; width:100px; height:23px; text-align:right; "/>
				<col ref="keumak" style="text-align:right; "/>
				<col ref="rmrk" maxlength="10" style="text-align:left; "/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_main.gridToInstance();
					]]>
				</script>
			</datagrid>
		</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:534px; top:757px; width:120px; height:23px; text-align:center; vertical-align:middle; ">합  계</caption>
		<caption id="cpt_sumkeumak" ref="/root/hidden/apsl/sumkeumak" format="(-)#,###" style="left:655px; top:757px; width:110px; height:23px; text-align:right; vertical-align:middle; background-color:#ffcccc; "/>
	</xhtml:body>
</xhtml:html>