결과관리서식팝업

<button id="button9" class="btn2_letter5" style="left:885px; top:760px; width:75px; height:19px; ">
			<caption>줄 바꾸기</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					tar_Sentence1.value = tar_Sentence1.value + "\n";
				]]>
			</script>
		</button>
		<button id="button12" class="btn2_letter4" style="left:1050px; top:760px; width:64px; height:19px; ">
			<caption>취     소</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						if ( checkOpener() ) {							
							opener.javascript.setParameter("mmt203_str1", "");
							opener.javascript.setParameter("mmt203_str2", "");
							window.close();
						} else {
							var rtn = messageBox("상위화면을 찾을 수", "E001");
						}
				]]>
			</script>
		</button>
		<button id="button13" class="btn2_letter4" style="left:1125px; top:760px; width:64px; height:19px; ">
			<caption>초 기 화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						tar_Sentence1.value = ""
						tar_Sentence2.value = ""
		
				]]>
			</script>
		</button>
		<output id="output2" ref="/root/main/display/pos" class="output_search" style="left:245px; top:0px; width:84px; height:19px; text-align:center; "/>
		<output id="output3" ref="/root/main/display/label" class="output_fix" style="left:330px; top:0px; width:565px; height:19px; "/>
		<datagrid id="grd_sheet" nodeset="/root/main/sheetlist/sheet" backcoloralternate="#ffffff" caption="Sheet List^seq^defltvw^grupcd" colsep="^" colwidth="198, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:5px; top:25px; width:235px; height:615px; ">
			<col ref="sheetnm" type="input"/>
			<col ref="seq" type="input" visibility="hidden"/>
			<col ref="defltvw" type="input" visibility="hidden"/>
			<col ref="grupcd" type="input" visibility="hidden"/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[

var selRow = grd_sheet.row;
				var seq = model.getValue("/root/main/sheetlist/sheet[" +  selRow + "]/seq");

//ss.ReDraw = false;

if (seq == "") {
					//ss.maxrows = 0;
					return;
				}
				
    			fSetClearSpread(true);
				
				fGetSheetInfo(seq);
				
				fGetSheetData(seq);
				//ss.ReDraw = true; 
				
				]]>
			</script>
		</datagrid>
		<button id="btn_rowadd" class="btn2_letter3" style="left:5px; top:0px; width:53px; height:19px; ">
			<caption>행추가</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						var gridCnt = model.getXPathValue("count(/root/main/sheetlist/sheet)");
						if (gridCnt > 0) {
						  //1:insert, 3:insert,new
						  if (grd_sheet.rowStatus(gridCnt) == 1 || grd_sheet.rowStatus(gridCnt) == 3 ) {
						   return; 
						  }
						}
						grd_sheet.addRow(false);
						var sgrupcd = model.getValue("/root/main/grupcd");
						model.setValue("/root/main/sheetlist/sheet[" + (Number(gridCnt) + 1) + "]/grupcd", sgrupcd);
						
						grd_sheet.refresh();
				]]>
			</script>
		</button>
		<button id="btn_rowdel" class="btn2_letter3" style="left:60px; top:0px; width:53px; height:19px; ">
			<caption>행삭제</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						var gridCnt = model.getXPathValue("count(/root/main/sheetlist/sheet)");
						if (gridCnt > 0) {
							var selRow = grd_sheet.row;
						  //1:insert, 3:insert,new
							if (grd_sheet.rowStatus(selRow) == 1 || grd_sheet.rowStatus(gridCnt) == 3 ) {
								grd_sheet.deleteRow(selRow, false);
							} else {
								grd_sheet.addStatus(selRow,"delete")
							}
							grd_sheet.refresh();
						}
				]]>
			</script>
		</button>
		<button id="btn_sheetsave" class="btn5_letter2" style="left:198px; top:0px; width:42px; height:19px; ">
			<caption>저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[

var sgrupcd  = model.getValue("/root/main/grupcd");

var confirm = messageBox("", "Q002", "");

if (confirm == "6") {
							fSaveData();

//ss.ReDraw = false; 
							fSetClearSpread(true);							
							fGetSheetList(sgrupcd);
							//ss.ReDraw = true; 
							model.refresh();  
						}
				]]>
			</script>
		</button>
		<button id="btn_default" class="btn2_letter4" style="left:115px; top:0px; width:55px; height:19px; ">
			<caption>Default</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						var sRow = grd_sheet.row;
						if (sRow > 0) {
							fClearSheetGridStyle();
							grd_sheet.rowstyle(sRow, "data", "font-weight") = "bold";
							model.setValue("/root/main/sheetlist/sheet[" +  sRow + "]/defltvw","Y");
						} else {	
							alert("선택된 Sheet가 없습니다.");
						}
				]]>
			</script>
		</button>
		<button id="btn_datasave" class="btn5_letter6" style="left:5px; top:760px; width:86px; height:19px; ">
			<caption>편집내용저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					var ls_seq = model.getValue("/root/main/display/seq");
					var li_line1 = 0;
					var li_line2 = 0;
					
					if (ls_seq=="") {
						messageBox("Sheet가 선택되지","E007");
						//model.setFocus("cmb_input_cls");
						return;	
					}
					
					model.makeNode("/root/send/sheetinfo/sheet");
					model.copyNode("/root/send/info","/root/main/sheetinfo/sheet");
					model.resetInstanceNode("/root/send/sheetinfo/sheet");
					model.resetInstanceNode("/root/send/info");
					model.resetInstanceNode("/root/send/data");

for(var i = 1;i<=grd_sheetdata.cols; i++) {

//Cell Size, 간격초기화시 정보를 저장하기위해 첫 Cell을 저장한다.
						if (grd_sheetdata.colwidth(i) != 72 || i == 1) {
							li_line1 ++;
							model.makeValue("/root/send/info[" + li_line1+ "]/seq", ls_seq);
							model.makeValue("/root/send/info[" + li_line1+ "]/flag", "C");
							model.makeValue("/root/send/info[" + li_line1+ "]/pos", i);
							model.makeValue("/root/send/info[" + li_line1+ "]/val", grd_sheetdata.colwidth(i));
						}

for(var j = 1;j<=grd_sheetdata.rows; j++) {

//ss.row = j;
							//ss.col = i;
							
							
							//Data, Data가 전혀없을 경우를 위해 첫 Cell을 저장한다.
							if (model.getValue(grd_sheetdata.nodeset+"["+j+"]/col"+i) != "" || (i == 1 && j == 1)) {
								li_line2 ++;
								model.makeValue("/root/send/data[" + li_line2 + "]/seq", ls_seq);
								model.makeValue("/root/send/data[" + li_line2 + "]/rowno", j);
								model.makeValue("/root/send/data[" + li_line2 + "]/colno", i);
								if (grd_sheetdata.cellstyle("font-weight", j, i, j, i) == "bold") {
									model.makeValue("/root/send/data[" + li_line2 + "]/bold", "Y");
								} else {
									model.makeValue("/root/send/data[" + li_line2 + "]/bold", "N");
								}
								model.makeValue("/root/send/data[" + li_line2 + "]/content", model.getValue(grd_sheetdata.nodeset+"["+j+"]/col"+i));
							}

}
					}
					
					if (submit( "TXAMT00304", false )) {
						alert("저장했습니다.");

//get sheet data, info
						//ss.ReDraw = false; 
						fSetClearSpread(true);
						fGetSheetData(ls_seq);
						fGetSheetInfo(ls_seq);
						//ss.ReDraw = true;

}
					
				
				]]>
			</script>
		</button>
		<bool id="bool1" checkvalue="Y,N" ref="/root/main/superuser/yn" style="left:105px; top:760px; width:25px; height:20px; ">
			<script type="javascript" ev:event="xforms-select">
				<![CDATA[
					model.makeValue("/root/main/superuser/yn", "Y");
					fApplyPermission();
				]]>
			</script>
			<script type="javascript" ev:event="xforms-deselect">
				<![CDATA[
					model.makeValue("/root/main/superuser/yn", "N");
					fApplyPermission();
				]]>
			</script>
		</bool>
		<caption id="cap_superuser" style="left:129px; top:762px; width:71px; height:15px; ">관리자모드</caption>
		<button id="btn_fontbold" class="btn2_letter2" style="left:1148px; top:0px; width:42px; height:19px; ">
			<caption>굵게</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				var srow = 0;
				var scol = 0;
				for (var i=0; i<grd_sheetdata.selectedCells.length; i++)
				{
					srow = grd_sheetdata.selectedCells.item(i).row
					scol = grd_sheetdata.selectedCells.item(i).col
					
					if (grd_sheetdata.cellstyle("font-weight", srow, scol) == "bold") {
						grd_sheetdata.rebuildStyle( srow, scol, srow, scol);
					}else {
						grd_sheetdata.cellstyle("font-weight", srow, scol) = "bold";
					}
				}
				
//				var ls_Row1 = ss.SelBlockRow;
//				var ls_Row2 = ss.SelBlockRow2;
//				var ls_Col1 = ss.SelBlockCol;
//				var ls_Col2 = ss.SelBlockCol2;
//
//				ss.BlockMode = true;
//				ss.row = ls_Row1;
//				ss.row2 = ls_Row2;
//				ss.col = ls_Col1;
//				ss.col2 = ls_Col2;
//				
//				//block의 첫Cell기준
//				if (ss.FontBold) {
//					ss.FontBold = false;	
//				}else {
//					ss.FontBold = true;	
//				}
//
//				ss.BlockMode = false;
/*				
				var Row = ss.ActiveRow; 
				var Col = ss.ActiveCol;
				ss.row = Row;
				ss.col = Col;
				if (ss.FontBold) {
					ss.FontBold = false;	
				}else {
					ss.FontBold = true;	
				}
*/
				]]>
			</script>
		</button>
		<button id="btn_excel" class="btn2_letter5" style="left:990px; top:0px; width:75px; height:19px; ">
			<caption>엑셀업로드</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						
						//엑셀용 변수 선언
						var Excel,oRange;
						var fileName = window.fileDialog("open", ",", false, " ", "xls", "All Files (*.*) |*.*| Excel FIles(*.xls)|*.xls");

if (fileName == "") return;

// 엑셀 객체생성
						Excel = new ActiveXObject("Excel.Application");
						Excel.Application.Workbooks.Open(fileName);

//엑셀표시
						Excel.Application.Visible = false;
						//sheet1 선택
						Excel.Application.Worksheets(1).Activate;

// sheet1내 작업영역을 객체에 저장
						oRange = Excel.Application.ActiveSheet.UsedRange;
						 
						//oRange에는 현재 내용이 있는 부분만 선택됨.
						//oRange부분을 선택표시
						oRange.Select();

//ss.ReDraw = false; 
						fSetClearSpread(true);

//oRange부분을 브라우저에 출력

for ( var i= 1; i <= oRange.Rows.count ; i ++ )   //Rows
						{
						   for ( var j = 1 ; j <= oRange.Columns.count ; j ++ ) //Columns
						   {
								if (((oRange.Cells( 1, j ).width) / 72) * 96 != 72) {
									grd_sheetdata.colWidth(j) = ((oRange.Cells( 1, j ).width) / 72) * 96  ;
								}   
						//		ss.row = i;
						//		ss.col = j;
						//		ss.text = oRange.Cells( i, j );
						//		ss.FontBold = oRange.Cells( i, j ).font.bold;
								if (oRange.Cells( i, j ).Value != null ) {
									model.makeValue(grd_sheetdata.nodeset+"["+i+"]/col"+j, oRange.Cells( i, j ));
								}
								if (oRange.Cells( i, j ).font.bold) {
									grd_sheetdata.cellstyle("font-weight", i, j) = "bold";
								}
								
							}
						}

//	ss.ReDraw = true;

Excel.Quit();
						
						grd_sheetdata.resizeCells();
						grd_sheetdata.rebuild();

]]>
			</script>
		</button>
		<button id="btn_initcell" class="btn2_letter5" style="left:1069px; top:0px; width:75px; height:19px; ">
			<caption>간격초기화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					//ss.ReDraw = false; 
					fSetClearSpread(false);
					//ss.ReDraw = true; 
				]]>
			</script>
		</button>
		<button id="button1" class="btn2_letter5" style="left:885px; top:760px; width:75px; height:19px; ">
			<caption>줄 바꾸기</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					tar_Sentence1.value = tar_Sentence1.value + "\n";
				]]>
			</script>
		</button>
		<datagrid id="grd_sheetdata" nodeset="/root/main/grdsheetdata" allowbigselection="false" allowselection="true" allowuserresize="true" autoresize="false" autosizemouse="true" caption="A^B^C^D^E^F^G^H^I^J^K^L^M^N^O^P^Q^R^S^T" colsep="^" colwidth="72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" selectionmode="free" tooltip="true" style="left:245px; top:25px; width:940px; height:613px; ">
			<col ref="col1" type="input"/>
			<col ref="col2" type="input"/>
			<col ref="col3" type="input"/>
			<col ref="col4" type="input"/>
			<col ref="col5" type="input"/>
			<col ref="col6" type="input"/>
			<col ref="col7" type="input"/>
			<col ref="col8" type="input"/>
			<col ref="col9" type="input"/>
			<col ref="col10" type="input"/>
			<col ref="col11" type="input"/>
			<col ref="col12" type="input"/>
			<col ref="col13" type="input"/>
			<col ref="col14" type="input"/>
			<col ref="col15" type="input"/>
			<col ref="col16" type="input"/>
			<col ref="col17" type="input"/>
			<col ref="col18" type="input"/>
			<col ref="col19" type="input"/>
			<col ref="col20" type="input"/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				var ls_pos = "";
				var ls_value = "";
				var ls_row = grd_sheetdata.row;
				var ls_col = grd_sheetdata.col;
				var ls_sentence = "";
				var ls_searhstr = "";

//ss object외에 입력되는것을 방지하기위해 추가
				//model.setFocus("ss");
				
				//좌표 찍어줌
				//ASCII코드를 문자로 변환
				ls_pos = String.fromCharCode(65 + (ls_col - 1));
				ls_pos = ls_pos + ls_row;
				model.setValue("/root/main/display/pos", ls_pos);
				
				grd_sheetdata.row = ls_row;
				grd_sheetdata.col = ls_col;
				ls_value = grd_sheetdata.valueMatrix(ls_row,ls_col);
				model.setValue("/root/main/display/label"," " + ls_value);

//model.refresh();
				
				if (ls_value == "") return;

if (grd_sheetdata.cellstyle("font-weight", ls_row, ls_col) == "bold") return;

if (ls_row==0 ) return;
				
				if (ls_col == 0) return;
				
				if (ls_value.indexOf("[[") != -1 && ls_value.indexOf("]]") != -1) {
					ls_sentence = ls_value.substring(0,ls_value.indexOf("[["));
					ls_searhstr = ls_value.substring(ls_value.indexOf("[["), ls_value.indexOf("]]")+2);
				} else {
					ls_sentence = ls_value;
					ls_searhstr = "";
				}

if (tar_Sentence1.value == "") tar_Sentence1.value = " ";
				
				if (tar_Sentence1.value == " " || tar_Sentence1.value.substr(tar_Sentence1.value.length-1,1).charCodeAt(0) == 10) {
					if (tar_Sentence1.value == " ") tar_Sentence1.value = "";
					tar_Sentence1.value = tar_Sentence1.value + ls_sentence;				
				} else {
					tar_Sentence1.value = tar_Sentence1.value + " " + ls_sentence;				
				}
    
				if (ls_searhstr != "") {
					if(tar_Sentence2.value == "") {
						tar_Sentence2.value = ls_searhstr.replace("[[","<").replace("]]",">");
					} else {
						tar_Sentence2.value = tar_Sentence2.value + " " + ls_searhstr.replace("[[","<").replace("]]",">");
					}
				}

//문장중 마지막 두글자가 AT인 경우 마지막 Sheet로 이동해서 보여준다.
				if (tar_Sentence1.value.substr(tar_Sentence1.value.length-2,2).toUpperCase()== "AT") {

var ls_lastrow = model.getXPathValue("count(/root/main/sheetlist/sheet)");
					var seq = model.getValue("/root/main/sheetlist/sheet[" +  ls_lastrow + "]/seq");
					grd_sheet.row = ls_lastrow;

if (seq == "") {
						//ss.maxrows = 0;
					} else {
						//ss.ReDraw = false; 
						fSetClearSpread(true);
						fGetSheetData(seq);
						fGetSheetInfo(seq);
						//ss.ReDraw = true; 
					}

}
				
				]]>
			</script>
			<script type="javascript" ev:event="KeyPress(KeyAscii)">
				<![CDATA[
				if(KeyAscii==9) model.setFocus("cmd_input");
				]]>
			</script>
		</datagrid>
		<bool id="bool2" checkvalue="Y,N" ref="/root/init/autoresizeyn" style="left:200px; top:760px; width:20px; height:20px; "/>
		<caption id="caption1" style="left:221px; top:761px; width:86px; height:15px; ">자동줄바꿈적용</caption>
		<button id="btn_xlssave" class="btn2_letter5" style="left:910px; top:0px; width:75px; height:19px; ">
			<caption>엑셀저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						var file = window.fileDialog("save","","true","","xls","Excel Files(*.xls)|*.xls");
						if(file == "") return;
						grd_sheetdata.saveExcel(file, "sheet1;exportfalserows:0");

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