YNU_JEUS/app_home/himed/webapps/mis/purcbaseweb/xrw/SMRFC00407_재물조사대상자업로드.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>재물조사 대상자 업로드</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<grid>
							<degolist/>
						</grid>
					</main>
					<send>
						<instcd/>
						<yyyymm/>
						<yyyy/>
						<mngtdeptcd/>
						<mngtdeptnm/>
						<acntcd/>
						<acntnm/>
						<installplcecd/>
						<installplcenm/>
						<totcnt/>
						<userid/>
						<save>
							<degolist/>
						</save>
					</send>
					<init>
					</init>
					<hidden/>
					<temp>
						<fixainfo/>
					</temp>
					<popacnt>
						<instcd/>
						<yyyy/>
						<selectyn/>
					</popacnt>
					<popacntlist>
						<acntlist/>
					</popacntlist>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<submission id="TRRFC00412" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/grid/degolist"/>
			<submission id="TRRFC00413" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp/fixainfo"/>
			<submission id="TXRFC00409" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					misfGridInit(grd_degolist);
					
					misfComboComCdList("C0048",cmb_instcd,"Y"); //기관코드
					
					model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
					model.setValue(ipt_yyyymm.attribute("ref"),getCurrentDate().substring(0, 6));
					var tyyyy = model.getValue("/root/send/yyyymm");
					model.setValue("/root/send/yyyy",tyyyy.substring(0, 4));		
					
					model.setValue(ipt_acntcd_search.attribute("ref"),'');
					model.setValue(ipt_acntnm_search.attribute("ref"),'');
					model.setValue(ipt_installplcecd.attribute("ref"),'');
					model.setValue(ipt_installplcenm.attribute("ref"),'');					


					var dutplcecd = getUserInfo("dutplcecd");	
					if(dutplcecd == "4020334000" || getUserInfo("userid") == "MIS"  || getUserInfo("userid") == "99207"   ){
					//	btn_search.dispatch("DOMActivate");	
				 	    submit("TRRFC00413");   // 저장된 데이터 건수 조회
						model.setValue("/root/send/totcnt",model.getValue("/root/temp/fixainfo/cnt"));
			     	}else{
                    	messageBox("물류팀외 조회할 수","I004");
						btn_search.disabled = true;
						btn_save.disabled = true;
						btn_proc.disabled = true;
						ipt_yyyymm.disabled = true;
						btn_mngtdeptcd.disabled = true;
						ipt_mngtdeptcd.disabled = true;
						btn_list.disabled = true;
                    }		
 
                  	model.refresh();		
				}

 			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="1200" pageheight="800" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:186px; height:15px; ">재물조사  대상자 업로드</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1185px; height:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line13" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
			</group>
		</group>
		<group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line16" class="line_2" style="x1:0px; y1:25px; x2:1185px; y2:25px; "/>
			<button id="btn_clear" class="btn4_letter3" navindex="13" style="left:1115px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInitialize();		
					]]>
				</script>
			</button>
			<button id="btn_list" class="btn3_letter6" navindex="12" style="left:1010px; top:3px; width:104px; height:22px; ">
				<caption>대상자산집계</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					   model.setValue("/root/send/userid",getUserInfo("userid"));
					
					   var cnt = model.getValue("/root/send/totcnt");
							if(cnt != "0"){  // 저장 건수가 있으면
								var ret = messageBox("기존에 저장된 데이터가 "+ cnt +"건  존재합니다.\n","Q003");
								if (ret == 6) {	  // OK
								    submit("TXRFC00409");
								    btn_search.dispatch("DOMActivate");
									messageBox("저장", "I002");
								}else{
								return;
								}
							}else{
								    submit("TXRFC00409");
								    btn_search.dispatch("DOMActivate");
									messageBox("저장", "I002");
							}			
				 	    submit("TRRFC00413");   // 저장된 데이터 건수 조회
					   model.refresh();
					]]>
				</script>
			</button>
		</group>
		<group id="group1" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
			<group id="group3" style="left:0px; top:10px; width:1185px; height:70px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:70px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
				<line id="line1" class="line_4" style="x1:1034px; y1:11px; x2:1034px; y2:61px; border-color:#ffe4bb; border-left-style:solid; "/>
				<button id="btn_search" class="btn1_letter2" navindex="6" style="left:1085px; top:21px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
			            submit("TRRFC00412");
						model.refresh();
						]]>
					</script>
				</button>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:108px; top:8px; width:147px; height:19px; text-align:center; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							btn_search.dispatch("DOMActivate");
						]]>
					</script>
				</select1>
				<input id="ipt_mngtdeptcd" ref="/root/send/mngtdeptcd" class="input_search" disabled="false" navindex="4" style="left:115px; top:40px; width:95px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfSearchDept(ipt_mngtdeptnm);
					]]>
					</script>
				</input>
				<button id="btn_mngtdeptcd" class="icon_search" disabled="false" navindex="-1" style="left:213px; top:40px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						misfOpenPopUpList("02", ipt_mngtdeptcd,"","mngtdeptcd,mngtdeptnm");
						ipt_mngtdeptcd.refresh();
						ipt_mngtdeptnm.refresh();
					]]>
					</script>
				</button>
				<caption id="caption9" class="search_name" style="left:15px; top:40px; width:92px; height:17px; ">사용부서 :</caption>
				<input id="ipt_mngtdeptnm" ref="/root/send/mngtdeptnm" class="output_fix" navindex="-1" editable="false" appearance="input" style="left:232px; top:40px; width:150px; height:19px; "/>
				<input id="ipt_acntcd_search" ref="/root/send/acntcd" class="input_search" navindex="5" visibility="visible" style="left:640px; top:8px; width:85px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_acntcd_search.value != "")
							{
								rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt", 
										      ",Y,2," + ipt_acntcd_search.value, "", "acntcd,acntnm",
											ipt_acntcd_search, "PPRAC00100_계정코드HELP", "useyn,acntcd","Y,ipt_acntcd_search");
							}else{
								ipt_acntnm_search.value = '';
							}
							ipt_acntcd_search.refresh();
							ipt_acntnm_search.refresh();
						]]>
					</script>
				</input>
				<input id="ipt_acntnm_search" ref="/root/send/acntnm" class="output_fix" navindex="-1" editable="false" style="left:748px; top:8px; width:197px; height:19px; "/>
				<button id="btn_acntcd_search" class="icon_search" navindex="-1" style="left:729px; top:11px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							rszfOpenPopUpListByWndName(ipt_acntcd_search, "", "acntcd,acntnm","PPRAC00100_계정코드HELP","","");
							  
							ipt_acntcd_search.refresh();
							ipt_acntnm_search.refresh();
						]]>
					</script>
				</button>
				<caption id="caption5" class="search_name" style="left:575px; top:10px; width:65px; height:17px; ">계정:</caption>
				<caption id="caption1" class="search_name" style="left:330px; top:10px; width:86px; height:17px; ">기준년월 :</caption>
				<input id="ipt_installplcecd" ref="/root/send/installplcecd" class="input_search" disabled="false" navindex="4" style="left:515px; top:40px; width:95px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfSearchDept(ipt_installplcenm);
					]]>
					</script>
				</input>
				<button id="btn_installplcecd" class="icon_search" disabled="false" navindex="-1" style="left:613px; top:40px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						misfOpenPopUpList("02", ipt_installplcecd,"","installplcecd,installplcenm");
						ipt_installplcecd.refresh();
						ipt_installplcenm.refresh();
					]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:415px; top:40px; width:92px; height:17px; ">설치장소 :</caption>
				<input id="ipt_installplcenm" ref="/root/send/installplcenm" class="output_fix" navindex="-1" editable="false" appearance="input" style="left:632px; top:40px; width:150px; height:19px; "/>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:104px; x2:1195px; y2:104px; "/>
			<caption id="caption10" class="tit_2" style="left:5px; top:89px; width:205px; height:15px; ">재물조사 대상자 리스트</caption>
			<datagrid id="grd_degolist" nodeset="/root/main/grid/degolist" caption="자산코드^자산명^계정과목^계정과목^수량^취득금액^취득일^잔존가^사용부서^설치부서" colsep="^" colwidth="120, 316, 55,100, 35, 95, 70, 95,120,120" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="7" style="left:0px; top:109px; width:1185px; height:596px; ">
				<col ref="fixasetcd" style="text-align:center; "/>
				<col ref="goodflaghngnm" style="padding-left:5; "/>
				<col ref="acntcd" style="text-align:center; "/>
				<col ref="acntnm" style="padding-left:5; "/>
				<col ref="goodqty" style="text-align:center; "/>
				<col ref="possnamt" format="#,##0" style="text-align:right; "/>
				<col ref="possndd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="janjonsak" format="#,##0" style="text-align:right; "/>
				<col ref="mngtdeptnm" style="text-align:center; "/>
				<col ref="installplcenm" style="text-align:center; "/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						     	grd_degolist.gridToInstance();
							]]>
				</script>
			</datagrid>
			<button id="button4" class="btn2_letter4" navindex="8" style="left:1122px; top:84px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
                        if( grd_degolist.rows - grd_degolist.fixedRows > 0 ) {
							var fileName ="재물조사대상자산조회_" + getCurrentDate();
							var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							grd_degolist.saveExcel(fileName, "Sheet");
						} else {
							messageBox("저장 데이터가","I004");
						}						
					]]>
				</script>
			</button>
			<input id="ipt_yyyymm" ref="/root/send/yyyymm" class="input_search" navindex="2" format="yyyy-mm" style="left:425px; top:20px; width:55px; height:19px; text-align:center; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var tyyyy = model.getValue("/root/send/yyyymm");
					          model.setValue("/root/send/yyyy",tyyyy.substring(0, 4));	
					]]>
				</script>
			</input>
			<caption id="caption4" style="left:916px; top:82px; width:201px; height:20px; background-color:#ffffcc; ">* 잔존가 기준 : 기준년도의 6월달</caption>
			<input id="ipt_cnt" ref="/root/send/totcnt" disabled="true" navindex="2" format="#,###" style="left:288px; top:84px; width:92px; height:19px; font-weight:bold; text-align:right; "/>
			<caption id="caption13" style="left:190px; top:85px; width:95px; height:18px; text-align:center; vertical-align:middle; background-color:#C4E693; ">저장된 건수 :</caption>
		</group>
	</xhtml:body>
</xhtml:html>