YNU_JEUS/app_home/himed/webapps/mis/bugtexecweb/xrw/SMRBP00400_예산실적대비표.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>
						<list>
							<bugtexeclist/>
						</list>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<acntyy/>
							<retrkind>dept</retrkind>
							<acntcd/>
							<acntnm/>
						</retrparams>
						<date/>
						<retrprarms2>
							<instcd/>
							<mngtcd>%</mngtcd>
						</retrprarms2>
					</send>
					<hidden>
					</hidden>
					<init>
						<code>
							<codelist/>
						</code>
					</init>
					<temp/>
				</root>
			</instance>
			<submission id="TRRBP00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
			<submission id="TRRAZ00001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrprarms2" resultref="/root/init/code/codelist"/>
		</model>
		<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/acntcommonweb/js/RAD001.js"/>
		<script type="javascript" ev:event="xforms-ready">
			<![CDATA[

				fCheckAuth();
			     fInitialize();				

			]]>
		</script>
		<script type="javascript">
			<![CDATA[
			
				var acntdept = "";      		//재무팀 부서코드 default 값   "4030100000"
				var bugtdept = "";             	//기획팀 부서코드 default 값   "4060100000"
				
				
				//========================================================================================
				//화면 권한 체크
				//========================================================================================
				function fCheckAuth()
				{
					btn_search.disabled = !checkAuth("R") ;					
				}
				
				//========================================================================================
				//초기화
				//========================================================================================
				function fInitialize()
				{
					model.removenode("/root/main/list/bugtexeclist");
					
					misfComboComCdListMulti("Z0007","cmb_instcd");

					model.setValue("/root/send/retrparams/instcd", getUserInfo("dutplceinstcd"));
					model.setValue("/root/send/date", getCurrentDate());
					racfGetCadlYmd("/root/send/date", "/root/temp");

					ipt_acntyy.value = model.getValue("/root/temp/acntyy");

					if(getUserInfo("dutplceinstcd") != "001")
					{
						cmb_instcd.disabled = true;
					}
					
					model.setValue("/root/send/retrprarms2/instcd",  getUserInfo("dutplceinstcd"));
					submit("TRRAZ00001");
					
					
					
					for (i=1; i<=instance1.selectNodes("root/init/code/code/codelist").length; i++)
					{
						cdgbn = model.getValue("/root/init/code/code/codelist[" + i + "]/cdgbn");

						if (cdgbn == "acntdept")
						{
							acntdept = model.getValue("/root/init/code/code/codelist[" + i + "]/cdid");
						}
						else if (cdgbn == "bugtdept")
						{
							bugtdept = model.getValue("/root/init/code/code/codelist[" + i + "]/cdid");
						}
						
					}					
							
					rdo_retrkind.dispatch("xforms-value-changed");
					
					model.setFocus("ipt_acntnm");

					model.refresh();    
				}
								
				//========================================================================================
				//각종 코드 Help Open
				//========================================================================================
				function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
				{
					misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
					model.refresh();
				}
				
				//========================================================================================
				//코드 Validation Check
				//========================================================================================
				function fValidationCheck(vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName)
				{
					if(event.keyCode == 13 || event.name == "xforms-value-changed")
					{
						document.controls(event.currentTarget).value = document.controls(event.currentTarget).currentText;
						misfValidationCheck(vgbn, pcdgrupid, recvlist, pValueControl, pNodeName);
						model.refresh();
						
						model.setFocus(pNextIndex);
					}
				}
				
				function fPrint()
				{
					exeReportPreview("RPRBP00401", "XMLSTR");

					model.refresh();
				}
				
                ]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" 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:230px; 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:40; width:1195px; height:744px; ">
			<line id="line1" class="line_1" style="x1:0px; y1:80px; x2:1195px; y2:80px; "/>
			<group id="group2" style="left:0px; top:10px; width:1194px; height:40px; vertical-align:top; ">
				<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption9" class="search_name" style="left:270px; top:11px; width:86px; height:17px; ">예산년도 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="8" style="left:1123px; top:9px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
												
							if(rdo_retrkind.value == "dept" && !(getUserInfo("dutplcecd") == model.getValue(ipt_acntcd.attribute("ref")) 
							                                            	|| radfCheckBugtAuth(getUserInfo("dutplceinstcd"), getUserInfo("userid"), model.getValue(ipt_acntcd.attribute("ref")), 'BUGTSEARCHYN') == "Y"
							                                            	|| getUserInfo("dutplcecd") == bugtdept)	)
							{
								messageBox("조회권한이 없습니다.", "I000");
							}
							else
							{
								model.removeNodeset(grd_bugtexecist.nodeset);
								model.refresh();
								submit("TRRBP00401");
								grd_bugtexecist.rebuildStyle();
								grd_bugtexecist.rowStyle(grd_bugtexecist.rows - 1, "data", "background-color") = "#ffff99";
							}

							for(var i = grd_bugtexecist.fixedRows ; i < grd_bugtexecist.rows ; i++)
							{
								if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("acntcd")) == "99999999")
								{
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ccffcc";
								}		
								if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("deptcd")) == "9999999999")
								{
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffff99";
								}							
							}

						]]>
					</script>
				</button>
				<line id="line2" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:31px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_acntcd" ref="/root/send/retrparams/acntcd" class="input_s_essential" navindex="5" maxlength="10" style="left:707px; top:11px; width:85px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							if(rdo_retrkind.value == "dept")
							{
								racfDeptValidCheck("acntcd,acntnm");
							}
							else if(rdo_retrkind.value == "acnt")
							{
								racfAcntValidCheck("acntcd,acntnm");
							}
							else if(rdo_retrkind.value == "projectid")
							{
							}

						]]>
					</script>
				</input>
				<button id="btn_acntcd" class="icon_search" style="left:796px; top:13px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							if(rdo_retrkind.value == "dept")
							{
								fOpenPopupHelp("11", ipt_acntcd, "acntcd,acntnm", "", cmb_instcd.value, "instcd");
							}
							else if(rdo_retrkind.value == "acnt")
							{
								fOpenPopupHelp("05", ipt_acntcd, "acntcd,acntnm", "", cmb_instcd.value, "instcd");
							}
							else if(rdo_retrkind.value == "projectid")
							{
//								fOpenPopupHelp("02", ipt_acntcd, "acntcd,acntnm", "", cmb_instcd.value, "instcd");
							}

						]]>
					</script>
				</button>
				<input id="ipt_acntnm" ref="/root/send/retrparams/acntnm" class="input_s_essential" navindex="4" imemode="hangul" style="left:815px; top:11px; width:185px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
							if (event.keyCode == "13")
							{
								if(rdo_retrkind.value == "dept")
								{
									racfDeptValidCheck("acntcd,acntnm");
								}
								else if(rdo_retrkind.value == "acnt")
								{
									racfAcntValidCheck("acntcd,acntnm");
								}
								else if(rdo_retrkind.value == "projectid")
								{
								}
								
								btn_search.dispatch("DOMActivate");
							}	
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							if(rdo_retrkind.value == "dept")
							{
								racfDeptValidCheck("acntcd,acntnm");
							}
							else if(rdo_retrkind.value == "acnt")
							{
								racfAcntValidCheck("acntcd,acntnm");
							}
							else if(rdo_retrkind.value == "projectid")
							{
							}

						]]>
					</script>
				</input>
				<input id="ipt_acntyy" ref="/root/send/retrparams/acntyy" class="input_s_essential" navindex="2" style="left:360px; top:11px; width:100px; height:19px; text-align:center; "/>
				<select1 id="rdo_retrkind" ref="/root/send/retrparams/retrkind" navindex="3" overflow="visible" appearance="full" cellspacing="10" cols="3" style="left:498px; top:12px; width:209px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>부서별</label>
							<value>dept</value>
						</item>
						<item>
							<label>계정별</label>
							<value>acnt</value>
						</item>
						<item>
							<label>Project 별</label>
							<value>project</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							if(rdo_retrkind.value == "dept")
							{
								ipt_acntcd.attribute("maxlength") = 10;
								model.setValue(ipt_acntcd.attribute("ref"), getUserInfo("dutplcecd"));
								model.setValue(ipt_acntnm.attribute("ref"), getUserInfo("dutplcenm"));
							}
							else if(rdo_retrkind.value == "acnt")
							{
								ipt_acntcd.attribute("maxlength") = 8;
							}
							else if(rdo_retrkind.value == "project")
							{
								ipt_acntcd.attribute("maxlength") = 20;
							}
						
						]]>
					</script>
				</select1>
				<caption id="caption1" class="search_name" style="left:475px; top:11px; width:15px; height:17px; "/>
				<select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_search" navindex="1" appearance="minimal" style="left:102px; top:11px; width:153px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption8" class="search_name" style="left:14px; top:12px; width:86px; height:17px; ">소속기관 :</caption>
			</group>
			<caption id="caption2" class="tit_2" style="left:5px; top:65px; width:159px; height:14px; ">예산집행실적총괄(월별)</caption>
			<datagrid id="grd_bugtexecist" nodeset="/root/main/list/bugtexeclist" caption="기관코드^기관명^예산년도^부서코드^부   서^계정코드^계정과목^예산금액^조정금액^추경금액^예산합계^실적합계^잔액^3월 실적^4월 실적^5월 실적^6월 실적^7월 실적^8월 실적^9월 실적^10월 실적^11월 실적^12월 실적^1월 실적^2월 실적" colsep="^" colwidth="0, 0, 0, 0, 120, 0, 140, 90, 90, 90, 80, 90, 90, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80" dataheight="25" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:85px; width:1195px; height:651px; ">
				<col ref="instcd" visibility="hidden"/>
				<col ref="instnm" visibility="hidden"/>
				<col ref="acntyy" visibility="hidden"/>
				<col ref="deptcd" visibility="hidden"/>
				<col ref="deptnm"/>
				<col ref="acntcd" visibility="hidden"/>
				<col ref="acntnm"/>
				<col ref="orgbugtamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="updtamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="revsupmbugtamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="bugtsumamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="execsum" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="balamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="mar" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="apr" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="may" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="jun" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="jul" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="aug" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="sep" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="oct" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="nov" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="dec" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="jan" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="feb" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			</datagrid>
			<button id="btn_excel" class="btn2_letter4" style="left:1125px; top:55px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							
						var sInstnm	= "[" + cmb_instcd.label + "]";
						var sAcntyy	= model.getValue(ipt_acntyy.attribute("ref")) + "회계년도";
						
						var sTitle = "예산실적 대비표 " + sInstnm + sAcntyy;
						grd_bugtexecist.rebuild();
						misfSaveExcel(grd_bugtexecist, sTitle);
					]]>
				</script>
			</button>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line5" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
			<button id="btn_print" class="btn4_letter2" style="left:1136px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						fPrint();

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