코드 관리

코드 관리 코드군 ID : 코드군 ID 코드 ID 코드이름 코드영문약어명 출력순서 코드값 최소값 최대값 최소 연산자 0 1 최대 연산자 0 1 유효시작일시 유효종료일시 코드 상세설명

</group>
			<caption id="caption_cdgrup_list" class="tit_2" style="left:29px; top:66px; width:118px; height:13px; ">코드군 목록</caption>
			<line id="line8" class="line_1" style="x1:0px; y1:82px; x2:1194px; y2:82px; "/>
			<line id="line10" class="line_3" style="x1:0px; y1:735px; x2:1194px; y2:735px; "/>
			<line id="line7" class="line_3" style="x1:0px; y1:741px; x2:1194px; y2:741px; "/>
			<datagrid id="grd_cdgruplist" nodeset="/root/main/cdgrup/list/cdgrup" caption="코드군ID^코드군명^코드길이^코드군설명^출력순서^유효시작일자^유효종료일자^권한기관코드^권한기관명^권한부서코드^권한부서명^최초등록자ID^최초등록자이름^최초등록일시^최종수정자ID^최종수정자이름^최종수정일시^레 벨" colwidth="150, 200, 60, 200, 60, 100, 100, 100, 100, 100, 100, 100, 100, 150, 100, 100, 150, 100" dataheight="25" defaultrows="0" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="23" tooltip="true" style="left:0px; top:85px; width:340px; height:455px; border-color:#808080; ">
				<col ref="cdgrupid"/>
				<col ref="cdgrupnm"/>
				<col ref="cdlgth"/>
				<col ref="detldesc" visibility="hidden"/>
				<col ref="dispseq" visibility="hidden"/>
				<col ref="valifromdd" format="yyyy-mm-dd"/>
				<col ref="valitodd" format="yyyy-mm-dd"/>
				<col ref="authinstcd"/>
				<col ref="authinstnm"/>
				<col ref="authdeptcd"/>
				<col ref="authdeptnm"/>
				<col ref="fstrgstrid" visibility="hidden"/>
				<col ref="fstrgstrnm" visibility="hidden"/>
				<col ref="fstrgstdt" visibility="hidden" format="yyyy-mm-dd hh:nn:ss"/>
				<col ref="lastupdtrid" visibility="hidden"/>
				<col ref="lastupdtrnm" visibility="hidden"/>
				<col ref="lastupdtdt" visibility="hidden" format="yyyy-mm-dd hh:nn:ss"/>
				<col ref="level" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						fInitMainData(true);
						var row = 	grd_cdgruplist.row;
						var cdgrupid = grd_cdgruplist.valueMatrix(row, grd_cdgruplist.colRef("cdgrupid"));
						model.makeValue("/root/send/data/cdgrupid", cdgrupid);
						model.makeValue("/root/send/data/sortfield", "dispseq");
						model.makeValue("/root/send/data/cdid", "");
						model.makeValue("/root/send/data/cdengabbrnm", "");
						model.makeValue("/root/send/data/cdnm", "");
						model.makeValue("/root/send/data/detldesc", "");
						model.makeValue("/root/send/data/cdval", "");
						model.makeValue("/root/send/data/minval", "");
						model.makeValue("/root/send/data/maxval", "");
						model.makeValue("/root/send/data/minopercd", "");
						model.makeValue("/root/send/data/maxopercd", "");
							
						submit("TRZBC00124");
						model.refresh();
					]]>
				</script>
			</datagrid>
			<datagrid id="grd_cdlist" nodeset="/root/main/code/list/code" caption="신청구분^대분류구분코드^코드SID^코드군ID^코드군명^코드ID^코드길이^코드이름^상세설명^출력순서^코드값^최소값^최대값^최소연산자^최대연산자^코드영문약어^유효시작일자^유효종료일자^최초등록자ID^최초등록자명^최초등록일시^최종수정자ID^최종수정자명^최종수정일시" colwidth="100, 100, 200, 100, 100, 100, 100, 100, 150, 68, 100, 100, 100, 68, 68, 100, 100, 100, 100, 100, 150, 100, 100, 150" dataheight="25" defaultrows="0" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" tooltip="true" style="left:375px; top:85px; width:820px; height:455px; border-color:#808080; ">
				<col ref="process"/>
				<col ref="class"/>
				<col ref="cdsid"/>
				<col ref="cdgrupid"/>
				<col ref="cdgrupnm"/>
				<col ref="cdid"/>
				<col ref="cdlgth"/>
				<col ref="cdnm"/>
				<col ref="detldesc"/>
				<col ref="dispseq"/>
				<col ref="cdval"/>
				<col ref="minval"/>
				<col ref="maxval"/>
				<col ref="minopercd"/>
				<col ref="maxopercd"/>
				<col ref="cdengabbrnm"/>
				<col ref="valifromdd" format="yyyy-mm-dd"/>
				<col ref="valitodd" format="yyyy-mm-dd"/>
				<col ref="fstrgstrid"/>
				<col ref="fstrgstrnm"/>
				<col ref="fstrgstdt" format="yyyy-mm-dd hh:nn:ss"/>
				<col ref="lastupdtrid"/>
				<col ref="lastupdtrnm"/>
				<col ref="lastupdtdt" format="yyyy-mm-dd hh:nn:ss"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
					var modestatus = model.getValue("/root/main/mode/modestatus");
					if(modestatus!="importexcel"){
						fInitMainDataControls(false);
						var row = grd_cdlist.row;
						model.copyNode("/root/main/data", "/root/main/code/list/code["+row+"]");
						model.setValue("/root/main/mode/modelabel", "코드관리>코드상세보기");
						model.setValue("/root/main/mode/modestatus", "view");
						model.refresh();
						fInitMainDataControls(true);
					}
				]]>
				</script>
			</datagrid>
			<caption id="caption_cd_list" class="tit_2" style="left:405px; top:65px; width:118px; height:13px; ">코드 목록</caption>
			<group id="grp_excel_process" style="left:999px; top:56px; width:188px; height:25px; ">
				<button id="button1" class="btn2_letter4" style="left:1px; top:3px; width:64px; height:19px; ">
					<caption>엑셀입력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var fileName = window.fileDialog("open", "", false);
							if(fileName==""){
								return;
							}
							grd_cdlist.loadExcel(fileName);
							fRearrangeExcelData();
							grd_cdlist.refresh();

]]>
					</script>
				</button>
				<button id="button2" class="btn2_letter4" style="left:66px; top:3px; width:64px; height:19px; ">
					<caption>엑셀출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						]]>
					</script>
				</button>
				<button id="button3" class="btn2_letter3" style="left:131px; top:3px; width:64px; height:19px; ">
					<caption>행삭제</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						]]>
					</script>
				</button>
			</group>
			<img id="img_convert_import_excel" class="icon_left" style="left:375px; top:61px; width:26px; height:19px; background-stretch:stretch; ">
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						fShiftCdListGridColumn("excel");
						grd_cdgruplist.visible = false;
						ipt_search.disabled = true;
						img_cdgrup_search_popup.disabled = true;
						btn_search.disabled= true;
						img_convert_import_excel.visible = false;
						grp_excel_process.visible = true;
						grp_excel_save.visible = false;
						caption_cd_list.visible = false;
						grp_excel_process.visible = true;
						grd_cdlist.attribute("left") = "0"+"px";
						grd_cdlist.attribute("width") = "1194" + "px";
						grd_cdlist.attribute("height") = "647" + "px";
						grd_reorg_sequence.visible = false;
						grd_general_bottom.visible = false;
						img_convert_general_process.visible= true;
						caption_cdgrup_list.visible = true;
						caption_cdgrup_list.attribute("left") = "29px";
						model.removenode("/root/main/code/list");
						model.makeNode("/root/main/code/list");
						model.setValue("/root/main/mode/modestatus", "importexcel");
						model.refresh();
						
					]]>
				</script>
			</img>
			<img id="img_convert_general_process" class="icon_right" style="left:0px; top:61px; width:26px; height:19px; background-stretch:stretch; ">
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						model.removenode("/root/main/code/list");
						model.makeNode("/root/main/code/list");
						img_convert_general_process.visible = false;
						caption_cdgrup_list.attribute("left")  = "0";
						grd_cdgruplist.visible = true;
						grd_cdlist.attribute("left") = "375px";
						grd_cdlist.attribute("width") = "820px";
						grd_cdlist.attribute("height") = "455px";
						img_convert_import_excel.visible = true;
						caption_cd_list.visible = true;
						grd_general_bottom.visible= true;
						ipt_search.disabled = false;
						img_cdgrup_search_popup.disabled = false;
						btn_search.disabled = false;
						grp_excel_process.visible = false;
						grp_excel_save.visible = true;
						grd_reorg_sequence.visible = true;
						model.setValue("/root/main/mode/modestatus", "");
						fShiftCdListGridColumn();
						model.refresh();
					]]>
				</script>
			</img>
			<group id="grp_excel_save" style="left:1119px; top:56px; width:66px; height:25px; ">
				<button id="button4" class="btn2_letter4" style="left:1px; top:3px; width:64px; height:19px; ">
					<caption>엑셀출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var row = 	grd_cdgruplist.row;
						var cdgrupid = grd_cdgruplist.valueMatrix(row, grd_cdgruplist.colRef("cdgrupid"));
						var cdgrupnm = grd_cdgruplist.valueMatrix(row, grd_cdgruplist.colRef("cdgrupnm"));
						
						var fileName = window.fileDialog("save", ",", false, cdgrupnm+"코드_"+cdgrupid, "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
	
						if (fileName != "")
						{
							grd_cdlist.saveExcel(fileName);
						}
						]]>
					</script>
				</button>
			</group>
		</group>
		<group id="grp_btn" style="left:0px; top:13px; width:1195px; height:27px; ">
			<button id="btn_init" class="btn4_letter3" style="left:1126px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.removenode("/root/main/cdgrup/list");
						model.makeNode("/root/main/cdgrup/list");
						model.removenode("/root/main/code/list");
						model.makeNode("/root/main/code/list");
						model.refresh();
					]]>
				</script>
			</button>
			<button id="btn_save" class="btn4_letter2" style="left:1067px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var result;
						var modestatus = model.getValue("/root/main/mode/modestatus");
						var cdsid;
						if(modestatus=="view"){
							messageBox("조회중인 정보를 저장", 'E001') ;
							return;
						}else if(modestatus=="insert"){
							if(!fValidateMainData()) return false;
							var cdgrupid = model.getValue("/root/main/data/cdgrupid");
							var cdid   = model.getValue("/root/main/data/cdid");
							var cdnm = model.getValue("/root/main/data/cdnm");
							var cdsid = cdgrupid+cdid;
							if(cdnm==""){
								model.setValue("/root/main/data/detldesc", cdnm);
							}
							result = messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름: "+cdnm+"]을 추가", "S001");
							model.makeValue("/root/main/data/cdsid", cdgrupid+cdid);
							if( result==7 || result == 2 ) return;
							model.copyNode("/root/send/data", "/root/main/data");
							
							// 코드이름 중복체크 
							model.removenode("/root/hidden/temp/count");
							model.refresh();
							
							result = submit("TRZBC00126");
							var count = model.getValue("/root/hidden/temp/count/count");
							if (count > 0) {
								result = messageBox( "[코드군 ID : "+cdgrupid+"]에 동일한  코드 이름이 존재합니다. ["+cdnm+"]을 추가", "S001");
								if( result==7 || result == 2 ) return;
							}
							
							result = submit("TXZBC00109");
						}else if(modestatus=="update"){
							var cdgrupid = model.getValue("/root/main/data/cdgrupid");
							var cdid = model.getValue("/root/main/data/cdid");
							cdsid = cdgrupid+cdid;
							var cdnm	     =  model.getValue("/root/main/data/cdnm");
							result = messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름 : "+cdnm+"]을 수정", "S001");
							if( result==7 || result == 2 ) return;
							model.copyNode("/root/send/data", "/root/main/data");
							result = submit("TXZBC00110");
						}else if(modestatus=="delete"){
							var cdgrupid = model.getValue("/root/main/data/cdgrupid");
							var cdid = model.getValue("/root/main/data/cdid");
							cdsid = cdgrupid+cdid;
							var cdnm = model.getValue("/root/main/data/cdnm");
							result = messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름 : "+cdnm+"]을 삭제", "S001");
							if( result==7 || result == 2 ) return;						
							model.copyNode("/root/send/data", "/root/main/data");
							model.makeValue("/root/send/data/cdsid", cdsid);
							result = submit("TXZBC00111");
						}else if(modestatus=="importexcel"){
							var update_data = grd_cdlist.getUpdateData();
							model.removenode("/root/send/data");
							model.makeNode("/root/send/data");
							model.setValue("/root/send/data", update_data);
							//alert(update_data);
							success = submit("TXZBC00119");
							if(success){
								alert("["+(grd_cdlist.rows-1)+"]개의 코드군을 엑셀로 부터 추출하여 성공적으로 서버에 적용하였습니다.");
								for(var i=grd_cdlist.fixedRows; i<grd_cdlist.rows; i++){
									grd_cdlist.rowStatus(i) = 0;
								}
							}
						}else if(modestatus=="swapsequence"){
							var update_data = grd_cdlist.getUpdateData();
							//alert("update_data : "+update_data);
							model.removenode("/root/send/data");
							model.makeNode("/root/send/data");
							model.setValue("/root/send/data", update_data);
							submit("TXZBC00120");
						}else{
							messageBox('처리 모드를', 'C002');
							return;
						}

if(modestatus!="importexcel"){
							
							fInitMainData(true);
							var row = 	grd_cdgruplist.row;
							var cdgrupid = grd_cdgruplist.valueMatrix(row, grd_cdgruplist.colRef("cdgrupid"));
							model.makeValue("root/send/data/sortfield", "dispseq");
							model.makeValue("/root/send/data/cdgrupid", cdgrupid);
							model.makeValue("/root/send/data/cdid", "");
							model.makeValue("/root/send/data/cdengabbrnm", "");
							model.makeValue("/root/send/data/cdnm", "");
							model.makeValue("/root/send/data/detldesc", "");
							model.makeValue("/root/send/data/cdval", "");
							model.makeValue("/root/send/data/minval", "");
							model.makeValue("/root/send/data/maxval", "");
							model.makeValue("/root/send/data/minopercd", "");
							model.makeValue("/root/send/data/maxopercd", "");
							submit("TRZBC00124");
							fInitMainDataControls(false);
							
							if(modestatus!="delete"&&modestatus!="swapsequence"){
								row = fFindGridItem(grd_cdlist, grd_cdlist.colRef("cdsid"), cdsid);
								model.copyNode("/root/main/data", "/root/main/code/list/code["+row+"]");
								model.setValue("/root/main/mode/modelabel", "코드관리>코드상세보기");
								model.setValue("/root/main/mode/modestatus", "view");
								model.refresh();
							}
							
							fInitMainDataControls(true);							
						}

]]>
				</script>
			</button>
		</group>
		<group id="grd_reorg_sequence" style="left:343px; top:330px; width:28px; height:45px; ">
			<img id="img6" class="icon_top" style="left:1px; top:1px; width:26px; height:19px; background-stretch:stretch; ">
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						var selected_row = grd_cdlist.row;
						var up_row = selected_row-1;
						//alert("selected_row : "+selected_row);
						//alert("up_row : "+up_row);
						if(selected_row>0){
							if(up_row>0){
								fSwapCodeSequence(selected_row, up_row);
								model.setValue("/root/main/mode/modestatus", "swapsequence");
								model.refresh();
								grd_cdlist.row = up_row;
							}else{
								messageBox("더이상 위로 이동할수 없습니다.", "C");
							}
						}else{
							messageBox("선택된 행이 없습니다.", "C");
						}
					]]>
				</script>
			</img>
			<img id="img3" class="icon_bottom" style="left:1px; top:24px; width:26px; height:19px; background-stretch:stretch; ">
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						var selected_row = grd_cdlist.row;
						var dn_row = selected_row +1;
						//alert("selected_row : "+selected_row+", dn_row : "+dn_row+", grd_cdlist.rows : "+grd_cdlist.rows);
						if(selected_row>0){
							if(dn_row<grd_cdlist.rows){
								fSwapCodeSequence(selected_row, dn_row);
								model.setValue("/root/main/mode/modestatus", "swapsequence");
								model.refresh();
								grd_cdlist.row = dn_row;
							}else{
								messageBox("더이상 아래로 이동할수 없습니다.", "C");
							}
						}else{
							messageBox("선택된 행이 없습니다.", "C");
						}		
					]]>
				</script>
			</img>
		</group>
	</xhtml:body>
</xhtml:html>