YNU_JEUS/app_home/himed/webapps/mis/redurepayamtweb/xrw/SMRAA00700_(X)계정별감가상각명세서.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>
						<list>
							<detailist/>
						</list>
					</main>
					<send>
						<condition>
							<instcd/>
							<wkdt/>
							<goodflag/>
							<lrgcd/>
						</condition>
					</send>
					<init/>
					<temp/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fOpenForm();
					//sCdGrupid = model.getValue("/root/init/comcode/cdgrupid");
				]]>
			</script>
			<script type="javascript">
				<![CDATA[				
					
					//========================================================================================
					//화면 로드시 초기화 함수
					//========================================================================================
					function fOpenForm() {
						
						//model.removenode("/root/main/notelist");	
						
						var sToday   = getCurrentDate().toString();
						var sFrday  =  sToday.substring(0,4) + "0301";
						
					
						model.setValue("/root/send/condition/wkdt",sToday);


						var instcd = getUserInfo("dutplceinstcd");
						model.setValue("/root/send/condition/instcd",instcd);

			 	     //misfComboComCdListMulti("R0025", "cmb_goodflag_search"); 	
//					     misfComboComCdListMulti("R0044", "cmb_goodflag_search"); 	
					     					
						model.refresh();
						
					}
					
					//========================================================================================
					//관리대장 조회
					//========================================================================================
					function fRetrieve()
					{
						
						model.removeNodeset("/root/main/list/detailist");
					     model.reset("/root/main/list/detailist");
					     model.resetInstanceNode("/root/main/list/detailist");
                              submit("TRRAA00601");
                              
					     datagrid11.subtotalposition="below"; 
                              datagrid11.multitotals=true; 
					     datagrid11.subtotal("sum", 1, 4, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 5, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 6, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 7, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 8, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 9, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 10, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 11, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 12, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
					     datagrid11.subtotal("sum", 1, 13, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 3, "합계", false); 
                              
                              
						model.refresh();
						
					}
	
					
					//========================================================================================
					//엑셀입력(excel file을 그리드에 입력)
					//========================================================================================
					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();
						}
					}
				]]>
			</script>
			<submission id="TRRAA00601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/detailist"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="1,1195;1,23;" 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:20px; width:1195px; height:730px; ">
			<line id="line3" class="line_1" style="x1:0px; y1:100px; x2:1195px; y2:100px; "/>
			<caption id="caption21" class="tit_2" style="left:5px; top:80px; width:134px; height:14px; ">유형자산명세서</caption>
			<button id="btn_excadd" class="btn2_letter4" style="left:1115px; top:50px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[

						fInputExcel(grd_notelist);

					]]>
				</script>
			</button>
			<upload id="upload1" style="left:735px; top:415px; width:100px; height:20px; "/>
			<group id="group4" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:55px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="16" style="left:1124; top:19px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fRetrieve();
						]]>
					</script>
				</button>
				<line id="line30" class="line_4" style="x1:1109; y1:8px; x2:1109; y2:51px; "/>
				<input id="input1" ref="/root/send/condition/wkdt" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:103px; top:20px; width:100px; height:19px; "/>
				<caption id="caption8" class="search_name" style="left:23px; top:20px; width:86px; height:17px; ">상각 월 :</caption>
			</group>
			<datagrid id="datagrid11" nodeset="/root/main/list/detailist" caption="기관코드^계정코드^계정명^기초가액^당기증가^당기감소^기말잔액^감가충당금^상각전잔액^당기상각액^충당금누계^미상각잔액^차액" colsep="^" colwidth="0,0, 100, 120, 95, 95, 110, 110, 110, 110, 110, 110, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:2px; top:110px; width:1193px; height:610px; ">
				<col ref="instcd"/>
				<col ref="acntcd"/>
				<col ref="acntnm" style="left:100px; top:23px; width:200px; height:23px; text-align:left; "/>
				<col ref="basamt" format="#,###" style="text-align:right; "/>
				<col ref="thisup" format="#,###" style="text-align:right; "/>
				<col ref="thisdw" format="#,###" style="text-align:right; "/>
				<col ref="lstsum" format="#,###" style="text-align:right; "/>
				<col ref="bfdprsum" format="#,###" style="text-align:right; "/>
				<col ref="rmnamt" format="#,###" style="text-align:right; "/>
				<col ref="thdpramt" format="#,###" style="text-align:right; "/>
				<col ref="dprsum" format="#,###" style="text-align:right; "/>
				<col ref="nodpramt" format="#,###" style="text-align:right; "/>
				<col ref="dfamt" format="#,###" style="left:660px; top:23px; width:120px; height:23px; text-align:right; "/>
			</datagrid>
			<button id="btn_excel" class="btn2_letter4" navindex="10" style="left:1115px; top:75px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						misfSaveExcel(datagrid11);		

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