YNU_JEUS/app_home/himed/webapps/mis/educationmngtweb/xrw/SMRPS03300_교육예산종합조회.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
						<rpsdbugtotaltlist/>
					</main>
					<send>
						<appyy/>
						<instcd/>
						<educflag/>
						<instnm/>
					</send>
					<init/>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				      finit();
				]]>
			</script>
			<submission id="TRRPS03301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rpsdbugtotaltlist"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/educationmngtweb/js/RPS001.js"/>
		<script type="javascript">
			<![CDATA[
				function finit() {
					/* Grid 초기화 */
					misfGridInit(grd_rpsdbugtlist);
					
					rpsfMsterDetailSet(grd_rpsdbugtlist,null, "TRRPS03301" ,"N"); 
					
					var curdate = getCurrentDate();
					
					model.setValue(ipt_appyy.attribute("ref") , curdate.substr(0, 4));
					
//					rpsEducSetComboList(ipt_appyy.value, "M01-001,M01-002", "cmb_educlrgcd,cmb_educmdlcd", "Y", "1,2");
					
					rpsEducSetComboList("M01-002", "cmb_educflag", "Y");
					
					model.refresh();
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-right:8; ">
		<group id="group1" style="left:0px; top:0px; width:1195; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:160px; height:14px; ">교육 예산/결산</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:43px; width:1195px; height:739px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:5px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1130px; top:12px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(!isRequiredControls("ipt_appyy")) return;
						
						misfGridInit(grd_rpsdbugtlist);
						
						submit("TRRPS03301");
						
						grd_rpsdbugtlist.mergeCells = "bycol";
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("educcdnm")) 	= true;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("bugtflagnm"))= true;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("bugtflag"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item1")) 	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item2"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item3"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item4"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item5"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item6"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item7")) 	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item8"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item9"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item10")) 	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item11"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("item12"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("itemtotal")) = false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("choipsncnt"))= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("appyy"))		= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("instcd"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("educcd")) 	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("unslno"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("unsldd"))	= false;
						grd_rpsdbugtlist.mergeCol(grd_rpsdbugtlist.colRef("psnbugt"))	= false;
						grd_rpsdbugtlist.merge();
						
						grd_rpsdbugtlist.rowstyle((grd_rpsdbugtlist.rows-2), "data", "background-color") = "#ffff99";
						grd_rpsdbugtlist.rowstyle((grd_rpsdbugtlist.rows-1), "data", "background-color") = "#ffff99";
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" visibility="hidden" style="x1:1110px; y1:12px; x2:1110px; y2:34px; "/>
			<line id="line8" class="line_1" style="x1:0px; y1:70px; x2:1194px; y2:69px; "/>
			<caption id="caption20" class="tit_2" style="left:5px; top:54px; width:169px; height:14px; ">교육 예산/결산(단위:원)</caption>
			<caption id="cap_appyy" class="search_name" style="left:32px; top:14px; width:90px; height:17px; ">교육년도 :</caption>
			<input id="ipt_appyy" ref="/root/send/appyy" class="input_s_essential" inputtype="date" format="yyyy" style="left:119px; top:13px; width:95px; height:19px; text-align:center; "/>
			<caption id="cap_mainbdunit" class="search_name" style="left:291px; top:14px; width:91px; height:17px; ">주체기관 :</caption>
			<select1 id="cmb_educflag" ref="/root/send/educflag" class="combo_search" appearance="minimal" style="left:740px; top:13px; width:130px; height:19px; text-align:left; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="cap_educlrgcd" class="search_name" style="left:652px; top:14px; width:91px; height:17px; ">교육구분 :</caption>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1129px; top:48px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							grd_rpsdbugtlist.saveExcel(fileName, "sheet1");
						}
					]]>
				</script>
			</button>
			<button id="button8" class="icon_search" style="left:538px; top:13px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "instcd,instnm";
						misfOpenPopUpList("03", ipt_instnm,"Z0007", recv_list, "", "") ;
					    model.refresh();
					]]>
				</script>
			</button>
			<input id="ipt_instnm" ref="/root/send/instnm" class="input_search" appearance="input" style="left:378px; top:13px; width:158px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if( ipt_instnm.value.getByteLength() == '0' ) {
							ipt_instcd.value = "" ;
						}
						model.refresh();
					]]>
				</script>
			</input>
			<input id="ipt_instcd" ref="/root/send/instcd" disabled="true" visibility="hidden" style="left:559px; top:13px; width:50px; height:19px; "/>
			<datagrid id="grd_rpsdbugtlist" nodeset="/root/main/rpsdbugtotaltlist" caption="교육명^^구분^숙박비^식비^내부강사비^외부강사비^교통비^대관료^교재비^자료비^간식비^진행비^의복비^예비비^총계^이수인원^인당교육비^년도^기관^교육코드^전표번호^전표일자" colsep="^" colwidth="183, 40, 44, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 80, 60, 80, 80, 80, 80, 80, 80" rowheader="update" rowsep="|" style="left:0px; top:73px; width:1195px; height:652px; ">
				<col ref="educcdnm"/>
				<col ref="bugtflagnm" style="text-align:center; "/>
				<col ref="bugtflag" visibility="hidden"/>
				<col ref="item1" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item2" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item3" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item4" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item5" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item6" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item7" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item8" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item9" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item10" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item11" type="output" format="#,###" style="text-align:right; "/>
				<col ref="item12" type="output" format="#,###" style="text-align:right; "/>
				<col ref="itemtotal" format="#,###" style="text-align:right; "/>
				<col ref="choipsncnt" style="text-align:right; "/>
				<col ref="psnbugt" format="#,###" style="text-align:right; "/>
				<col ref="appyy" rowspan="2" visibility="hidden"/>
				<col ref="instcd" rowspan="2" visibility="hidden"/>
				<col ref="educcd" rowspan="2" visibility="hidden"/>
				<col ref="unslno" visibility="hidden"/>
				<col ref="unsldd" visibility="hidden" format="yyyy-mm-dd"/>
			</datagrid>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:17px; width:1195px; height:27px; ">
			<button id="btn_init" class="btn4_letter3" style="left:1125px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						finit();
					]]>
				</script>
			</button>
			<button id="btn_print" class="btn6_letter2" style="left:1px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						exeReportPreview("RPRPS03301", "XMLSTR");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>