YNU_JEUS/app_home/himed/webapps/mis/bugtexecweb/xrw/SMRBP00800_분기별예산배정내역서.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>
							<datalist>
								<instcd/>
								<gubn/>
								<acntyy/>
								<deptcd/>
								<supacntnm2/>
								<supacntnm3/>
								<supacntnm4/>
								<acntnm/>
								<totalorgbugtamt/>
								<orgbugtamt1/>
								<orgbugtamt2/>
								<orgbugtamt3/>
								<orgbugtamt4/>
								<balance/>
								<revsupmbugtamt1/>
								<revsupmbugtamt2/>
								<revsupmbugtamt3/>
								<revsupmbugtamt4/>
								<aggregate/>
							</datalist>
						</list>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<acntyy/>
							<deptcd/>
							<depthngnm/>
							<bugtflag/>
							<quarter/>
						</retrparams>
						<date/>
						<search>
							<nm/>
						</search>
					</send>
					<hidden>
					</hidden>
					<init>
						<baseinfo>
							<quarter>
								<cd>1</cd>
								<nm>1분기</nm>
							</quarter>
							<quarter>
								<cd>2</cd>
								<nm>2분기</nm>
							</quarter>
							<quarter>
								<cd>3</cd>
								<nm>3분기</nm>
							</quarter>
							<quarter>
								<cd>4</cd>
								<nm>4분기</nm>
							</quarter>
						</baseinfo>
					</init>
					<temp/>
				</root>
			</instance>
			<submission id="TRRBP00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
		</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/bugtcommonweb/js/RBC001.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"
				var Deptcd 	= getUserInfo("dutplcecd");
				var Deptnm 	= getUserInfo("dutplcenm");
				
				
				//========================================================================================
				//화면 권한 체크
				//========================================================================================
				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");

					/*if (getCurrentDate().substr(4,4) >='0101' && getCurrentDate().substr(4,4) <='0331'){
						model.setValue("/root/send/retrparams/quarter", "1");
					}else if (getCurrentDate().substr(4,4) >='0401' && getCurrentDate().substr(4,4) <='0630'){
						model.setValue("/root/send/retrparams/quarter", "2");
					}else if (getCurrentDate().substr(4,4) >='0701' && getCurrentDate().substr(4,4) <='0930'){
						model.setValue("/root/send/retrparams/quarter", "3");
					}else if (getCurrentDate().substr(4,4) >='1001' && getCurrentDate().substr(4,4) <='1231'){
						model.setValue("/root/send/retrparams/quarter", "4");
					}			*/		

					ipt_acntyy.value = model.getValue("/root/temp/acntyy");
					model.setValue("/root/send/retrparams/deptcd", 	Deptcd);	
					model.setValue("/root/send/retrparams/depthngnm", 	Deptnm);				
					rdo_bugtflag.value = "2"

					if(getUserInfo("dutplceinstcd") != "001")
					{
						cmb_instcd.disabled = true;
					}
					
					model.setFocus("ipt_deptcd");

					model.refresh();    
				}
				
				//========================================================================================
				//부서코드 Help Open
				//========================================================================================
				function fOpenPopupDeptHelp(pControl, pInstance)
				{				
					misfOpenPopUpList("11", pControl, "", pInstance);
					model.refresh();
				}
								
				//========================================================================================
				//각종 코드 Help Open
				//========================================================================================
				function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
				{
					misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
					model.refresh();
				}

				//========================================================================================
				//출력
				//========================================================================================
				function fPrint()
				{
					exeReportPreview("RPRBP00801", "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:250px; 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:110px; x2:1195px; y2:110px; "/>
			<group id="group2" style="left:0px; top:10px; width:1194px; height:70px; vertical-align:top; ">
				<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:70px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption9" class="search_name" style="left:365px; top:10px; width:86px; height:17px; ">예산년도 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="8" style="left:1123px; top:24px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							model.removeNodeset(grd_bugtexecist.nodeset);
							model.refresh();
							submit("TRRBP00801");
							
							for(var i = 0 ; i < grd_bugtexecist.rows ; i++)
							{
								if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "0"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ff99cc";
								}else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "1"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffcc99";
								}else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "2"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffff99";
								}else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "3"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ccffcc";
								}else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "4"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#cc99ff";
								}else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "5"){
									grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffffff";
								}				
							}

						]]>
					</script>
				</button>
				<line id="line2" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:61px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_acntyy" ref="/root/send/retrparams/acntyy" class="input_s_essential" navindex="2" style="left:455px; top:9px; width:100px; height:19px; text-align:center; "/>
				<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>
				<select1 id="rdo_bugtflag" ref="/root/send/retrparams/bugtflag" navindex="27" overflow="visible" appearance="full" cellspacing="10" cols="4" style="left:454px; top:39px; width:206px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>수입</label>
							<value>1</value>
						</item>
						<item>
							<label>비용</label>
							<value>2</value>
						</item>
						<item>
							<label>구매</label>
							<value>3</value>
						</item>
						<item>
							<label>자본</label>
							<value>4</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							btn_search.dispatch("DOMActivate");

						]]>
					</script>
				</select1>
				<caption id="caption5" class="search_name" style="left:365px; top:40px; width:87px; height:17px; ">예산구분 :</caption>
				<input id="ipt_depthngnm" ref="/root/send/retrparams/depthngnm" class="input_s_essential" disabled="false" navindex="3" imemode="hangul" style="left:183px; top:39px; width:150px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
						
							racfBugtDeptValidCheck("deptcd,depthngnm", "name");
						
							if(event.keyCode == 13)
							{
								btn_search.dispatch("DOMActivate");
							}
							
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							racfBugtDeptValidCheck("deptcd,depthngnm", "name");

							if(ipt_deptcd.value != "" && ipt_depthngnm.value != "")
							{
								btn_search.dispatch("DOMActivate");
							}
							
							

						]]>
					</script>
				</input>
				<button id="btn_depthelp" class="icon_search" disabled="false" style="left:162px; top:39px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							fOpenPopupDeptHelp(ipt_deptcd, "deptcd,depthngnm");
							if(ipt_deptcd.value != "" &&ipt_depthngnm.value != "")
							{
								btn_search.dispatch("DOMActivate");
							}

						]]>
					</script>
				</button>
				<caption id="caption3" class="search_name" style="left:14px; top:40px; width:107px; height:17px; ">부서 :</caption>
				<input id="ipt_deptcd" ref="/root/send/retrparams/deptcd" class="input_s_essential" disabled="false" navindex="2" maxlength="10" style="left:78px; top:39px; width:80px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

							if(event.keyCode == 13)
							{								
								model.setFocus("ipt_depthngnm");
							}

						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							racfBugtDeptValidCheck("deptcd,depthngnm", "code");

							if(ipt_deptcd.value != "" &&ipt_depthngnm.value != "")
							{
								btn_search.dispatch("DOMActivate");
							}
							
							


						]]>
					</script>
				</input>
				<caption id="caption1" class="search_name" visibility="hidden" style="left:665px; top:11px; width:86px; height:17px; ">예산분기 :</caption>
				<select1 id="cmb_quarter" ref="/root/send/retrparams/quarter" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:755px; top:10px; width:74px; height:19px; text-align:center; vertical-align:middle; ">
					<choices>
						<itemset nodeset="/root/init/baseinfo/quarter">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
/*							if (cmb_quarter.value == '1'){
								ipt_fromym.value = ipt_acntyy.value + '01';
								ipt_toym.value = ipt_acntyy.value + '03';
							}else if (cmb_quarter.value == '2'){
								ipt_fromym.value = ipt_acntyy.value + '04';
								ipt_toym.value = ipt_acntyy.value + '06';
							}
							else if (cmb_quarter.value == '3'){
								ipt_fromym.value = ipt_acntyy.value + '07';
								ipt_toym.value = ipt_acntyy.value + '09';
							}
							else if (cmb_quarter.value == '4'){
								ipt_fromym.value = ipt_acntyy.value + '10';
								ipt_toym.value = ipt_acntyy.value + '12';
							}*/
							btn_search.dispatch("DOMActivate");				
						]]>
					</script>
				</select1>
				<button id="button4" class="btn2_letter2" style="left:915px; top:39px; width:42px; height:19px; ">
					<caption>찾기</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var vPrntnmCol = grd_bugtexecist.colRef("acntnm");
							var searchnm = model.getValue("/root/send/search/nm");
							
							var findRow = grd_bugtexecist.findRow(searchnm, 1, vPrntnmCol, false, false);
							grd_bugtexecist.row = findRow;	
						]]>
					</script>
				</button>
				<caption id="caption7" class="search_name" style="left:690px; top:40px; width:111px; height:17px; ">조     회 :</caption>
				<input id="input1" ref="/root/send/search/nm" class="input_s_essential" navindex="2" maxlength="10" style="left:780px; top:39px; width:130px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

							if(event.keyCode == 13)
							{
								inputEnterKey("button4", "DOMActivate");
							}

						]]>
					</script>
				</input>
			</group>
			<caption id="caption2" class="tit_2" style="left:5px; top:95px; width:159px; height:14px; ">분기별예산배정내역서</caption>
			<datagrid id="grd_bugtexecist" nodeset="/root/main/list/datalist" caption="기관코드^구분^예산연도^부서코드^계정과목^계정과목^계정과목^계정과목^예산액^분기별 배정^분기별 배정^분기별 배정^분기별 배정^배정잔액^예산조정(추가,감액,전용)^예산조정(추가,감액,전용)^예산조정(추가,감액,전용)^예산조정(추가,감액,전용)^배정누계|기관코드^구분^예산연도^부서코드^관^항^목^세목^예산액^1/4 분기^2/4 분기^3/4 분기^4/4 분기^배정잔액^1/4 분기^2/4 분기^3/4 분기^4/4 분기^배정누계" colsep="^" colwidth="100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:115px; width:1190px; height:585px; ">
				<col ref="instcd" visibility="hidden"/>
				<col ref="gubn" visibility="hidden"/>
				<col ref="acntyy" visibility="hidden"/>
				<col ref="deptcd" visibility="hidden"/>
				<col ref="supacntnm2"/>
				<col ref="supacntnm3"/>
				<col ref="supacntnm4"/>
				<col ref="acntnm"/>
				<col ref="totalorgbugtamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="orgbugtamt1" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="orgbugtamt2" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="orgbugtamt3" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="orgbugtamt4" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="balance" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="revsupmbugtamt1" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="revsupmbugtamt2" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="revsupmbugtamt3" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="revsupmbugtamt4" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="aggregate" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
			</datagrid>
			<button id="btn_5" class="btn2_letter4" style="left:1125px; top:90px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
								
								var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
								grd_bugtexecist.saveExcel(fileName,"SheetName:sheet1");
								//radfSaveExcel(grd_exceloutput1);
							]]>
				</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>