YNU_JEUS/app_home/himed/webapps/mis/bugtappweb/xrw/SMRBQ00500_예산EXCEL입력.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>본/추경예산EXCEL입력</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<bugtexcel>
							<bugtexcellist/>
						</bugtexcel>
						<bugtexcelupload>
							<bugtexceluploadlist/>
						</bugtexcelupload>
						<bugtcheck>
							<bugtchecklist/>
						</bugtcheck>
					</main>
					<send>
						<condition>
							<instcd/>
							<acntyy/>
							<deptcd/>
							<depthngnm/>
							<workflag>1</workflag>
						</condition>
						<bugtexceluploadlist/>
					</send>
					<hidden>
						<list>
							<taxbillchecklist/>
						</list>
						<condition>
							<instcd/>
						</condition>
					</hidden>
					<init>
					</init>
					<temp>
					</temp>
					<target/>
					<contextmenu>
						<assgym>
							<item>
								<label>연간</label>
								<value>-</value>
							</item>
							<item>
								<label>3월</label>
								<value>03</value>
							</item>
							<item>
								<label>4월</label>
								<value>04</value>
							</item>
							<item>
								<label>5월</label>
								<value>05</value>
							</item>
							<item>
								<label>6월</label>
								<value>06</value>
							</item>
							<item>
								<label>7월</label>
								<value>07</value>
							</item>
							<item>
								<label>8월</label>
								<value>08</value>
							</item>
							<item>
								<label>9월</label>
								<value>09</value>
							</item>
							<item>
								<label>10월</label>
								<value>10</value>
							</item>
							<item>
								<label>11월</label>
								<value>11</value>
							</item>
							<item>
								<label>12월</label>
								<value>12</value>
							</item>
							<item>
								<label>1월</label>
								<value>01</value>
							</item>
							<item>
								<label>2월</label>
								<value>02</value>
							</item>
						</assgym>
					</contextmenu>
				</root>
			</instance>
			<submission id="TRZBC00101" method="urlencoded-post" replace="instance"/>
			<bind id="bind_totamt" ref="/root/hidden/totamt" calculate="(/root/main/orch_one/paytotamt) - (/root/main/orch_one/incmtax) -(/root/main/orch_one/resdntax)"/>
			<bind id="bind_amt" ref="/root/hidden/orchreturn/amt" calculate="sum(/root/main/list/orchlist/paytotamt)"/>
			<bind id="bind_incmtax" ref="/root/hidden/orchreturn/incmtax" calculate="sum(/root/main/list/orchlist/incmtax)"/>
			<bind id="bind_resdntax" ref="/root/hidden/orchreturn/resdntax" calculate="sum(/root/main/list/orchlist/resdntax)"/>
			<submission id="TRRBQ00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/bugtexcel"/>
			<submission id="TRRBQ00502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/bugtcheck"/>
			<submission id="TXRBQ00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
			<submission id="TXRBQ00502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/temp"/>
			<submission id="TXRBQ00503" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/temp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.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[

				fInitialize();

			]]>
		</script>
		<script type="javascript">
			<![CDATA[

				var vWorkFlag = "";

				function fInitialize()
				{
					vWorkFlag = model.getValue("/root/target/slipinfo/workflag");

					if(vWorkFlag == "1")
					{
						cap_title.value = "본예산 Excel 입력";
						cap_title.refresh();
					}
					else if(vWorkFlag == "2")
					{
						cap_title.value = "추경예산 Excel 입력";
						cap_title.refresh();
					}

					misfComboComCdList("Z0007", cmb_instcd,   "N");
					model.setValue(cmb_instcd.attribute("ref"),   getUserInfo("dutplceinstcd"));

					model.setValue(ipt_acntyy.attribute("ref"), 			model.getValue("/root/target/slipinfo/acntyy"));
					model.setValue(ipt_deptcd.attribute("ref"), 			model.getValue("/root/target/slipinfo/deptcd"));
					model.setValue(ipt_depthngnm.attribute("ref"), 		model.getValue("/root/target/slipinfo/depthngnm"));
					model.setValue("/root/send/condition/workflag", 	vWorkFlag);

					fSearch();
				}

				function fSearch()
				{
					model.removenode(grd_bugtexcellist.nodeset);
					model.removenode(grd_bugtchecklist.nodeset);
					submit("TRRBQ00501");
					submit("TRRBQ00502");
					
					if(grd_bugtchecklist.fixedRows == grd_bugtchecklist.rows)
					{
						btn_inputexcel.disabled = false;
					}
					else
					{
						btn_inputexcel.disabled = true;
					}
						

					model.refresh();
				}

				//엑셀 입력
				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();
						return true;
					}
					return false;
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:8; margin-right:8; margin-bottom:8; ">
		<group id="group1" style="left:0px; top:0px; width:1042px; height:13px; ">
			<caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:190px; height:14px; ">예산 Excel 입력</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:12px; width:1195px; height:753px; ">
			<line id="line2" class="line_1" style="x1:0px; y1:9px; x2:1195px; y2:9px; "/>
			<datagrid id="grd_bugtexcellist" nodeset="/root/main/bugtexcel/bugtexcellist" caption="예산구분^관^항^목^계정명^계정코드^배정월^적요^근거^본예산액^추경예산액^데이터여부" colwidth="80, 130, 130, 130, 150, 90, 60, 200, 200, 100, 100, 80, 80, 80, 80" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:35px; width:1195px; height:240px; ">
				<col disabled="true" ref="bugtflag" type="combo">
					<choices>
						<item>
							<label>수익</label>
							<value>1</value>
						</item>
						<item>
							<label>비용</label>
							<value>2</value>
						</item>
					</choices>
				</col>
				<col ref="supacntnm2"/>
				<col ref="supacntnm3"/>
				<col ref="supacntnm4"/>
				<col ref="acntnm"/>
				<col ref="acntcd"/>
				<col disabled="true" ref="assgym" type="combo">
					<choices>
						<itemset nodeset="/root/contextmenu/assgym/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col ref="bugtappresn"/>
				<col ref="bugtappbase"/>
				<col ref="orgbugtappamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="revbugtappamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="data_exist"/>
			</datagrid>
			<button id="btn_exceldel" class="btn4_letter2" navindex="-1" style="left:1075px; top:14px; width:56px; height:22px; ">
				<caption>삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						submit("TXRBQ00502");
						fSearch();
					]]>
				</script>
			</button>
			<button id="btn_inputexcel" class="btn4_letter5" navindex="-1" style="left:980px; top:14px; width:92px; height:22px; ">
				<caption>Excel 저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						model.removeNodeset(grd_bugtexcellist.nodeset);
					      	model.removeNodeset(grd_bugtexceluploadlist.nodeset);
					      	model.removeNodeset(grd_bugtchecklist.nodeset);
					      	grd_bugtexcellist.refresh();
					      	grd_bugtexceluploadlist.refresh();
					      	grd_bugtchecklist.refresh();
						
						if(!fInputExcel(grd_bugtexcellist))
						{
							return false;
						}
						
						for(var i = grd_bugtexcellist.fixedRows ; i < grd_bugtexcellist.rows ; i++)
						{
							vBugtflag = grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("bugtflag"));
							if (vBugtflag == "수익") 
							{
								grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("bugtflag")) = "1";
							}
							else if (vBugtflag == "비용") 
							{
								grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("bugtflag")) = "2";
							}
							else
							{
								messageBox("잘못된 예산구분입니다.", "I000");
								return false;
							}			
							
							var vAssgym = "";
							var vBugtflag = "";
							if(grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) != '연간')
							{					
								
								vAssgym = grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym"));
								vAssgym = vAssgym.replace("월","").getLeftPad(2,"0");			
								if(grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) > 12 || grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) < 1)
								{
									messageBox("잘못된 배정월입니다.", "I000");
									return false;
								}
								grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) = vAssgym;
							}
							else if(grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) == '연간')
							{
								grd_bugtexcellist.valueMatrix(i, grd_bugtexcellist.colRef("assgym")) = '-';								
							}
						}
						
						
						var Instcd 		= cmb_instcd.value;
						var Acntyy 	= ipt_acntyy.value;
						var Deptcd 	= ipt_deptcd.value;
						
						for(var i=1 ; i < grd_bugtexcellist.rows;  i++)
						{
							misfGridIUD(grd_bugtexceluploadlist, "A", "N")														
							
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/instcd",		Instcd);
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/workflag",		vWorkFlag);
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/acntyy",		Acntyy);
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/deptcd",		Deptcd);
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/bugtflag",		model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/bugtflag"));
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/acntcd",		model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/acntcd"));
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/assgym",		model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/assgym"));
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/bugtappresn",	model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/bugtappresn"));
							model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/bugtappbase",	model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/bugtappbase"));
							
							if(vWorkFlag == "1")
							{
								model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/bugtappamt",	model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/orgbugtappamt"));
							}
							else if(vWorkFlag == "2")
							{
								model.setValue(grd_bugtexceluploadlist.nodeset + "[" + i + "]/bugtappamt",	model.getValue(grd_bugtexcellist.nodeset + "[" + i + "]/revbugtappamt"));
							}							
						}
												
						model.setValue("/root/send/bugtexceluploadlist", grd_bugtexceluploadlist.getUpdateData());
						
						submit("TXRBQ00501");
																		
						fSearch();
						
					]]>
				</script>
			</button>
			<button id="btn_excelapp" class="btn4_letter2" disabled="false" navindex="-1" style="left:1135px; top:14px; width:56px; height:22px; ">
				<caption>적용</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						var DeptAcnt = "N";
						
						if(radfCheckInstMngt(getUserInfo("dutplceinstcd"), 'condition4') == "Y")
						{
							DeptAcnt = "Y";							
						}
						
						for(var i = grd_bugtchecklist.fixedRows ; i < grd_bugtchecklist.rows ; i++)
						{
							if(DeptAcnt == "Y")
							{
								if(grd_bugtchecklist.valueMatrix(i, grd_bugtchecklist.colRef("deptuseacntyn")) == "N")
								{
									messageBox("사용계정이 아닙니다.", "I000");
									return false;
								}
							}
							
							if(grd_bugtchecklist.valueMatrix(i, grd_bugtchecklist.colRef("bugtuseyn")) == "N")
							{
								messageBox("예산계정이 아닙니다.", "I000");
								return false;
							}
							
							if(grd_bugtchecklist.valueMatrix(i, grd_bugtchecklist.colRef("mngtdeptyn")) == "N")
							{
								messageBox("예산관리부서가 아닙니다.", "I000");
								return false;
							}
						}
						
						submit("TXRBQ00503");
											
					]]>
				</script>
			</button>
			<datagrid id="grd_bugtchecklist" nodeset="/root/main/bugtcheck/bugtchecklist" caption="기관코드^회계년도^부서코드^부서^작업구분^예산구분^대분류코드^대분류^관코드^관^항코드^항^목코드^목^계정코드^계정명^배정월^적요^산출근거^신청액^부서사용계정여부^예산계정여부^예산부서여부^배정년월중복여부" colwidth="0, 0, 0, 0, 0, 80, 0, 0, 0, 100, 0, 100, 0, 100, 80, 150, 60, 150, 150, 90, 20, 20, 20, 20" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:281px; width:1195px; height:469px; ">
				<col ref="instcd"/>
				<col ref="acntyy"/>
				<col ref="deptcd"/>
				<col ref="deptengnm"/>
				<col ref="workflag"/>
				<col ref="bugtflag" type="combo">
					<choices>
						<item>
							<label>수익</label>
							<value>1</value>
						</item>
						<item>
							<label>비용</label>
							<value>2</value>
						</item>
					</choices>
				</col>
				<col ref="supacntcd1"/>
				<col ref="supacntmn1"/>
				<col ref="supacntcd2"/>
				<col ref="supacntmn2"/>
				<col ref="supacntcd3"/>
				<col ref="supacntmn3"/>
				<col ref="supacntcd4"/>
				<col ref="supacntmn4"/>
				<col ref="acntcd"/>
				<col ref="acntnm"/>
				<col ref="assgym" type="combo">
					<choices>
						<itemset nodeset="/root/contextmenu/assgym/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col ref="bugtappresn"/>
				<col ref="bugtappbase"/>
				<col ref="bugtappamt"/>
				<col ref="deptuseacntyn"/>
				<col ref="bugtuseyn"/>
				<col ref="mngtdeptyn"/>
				<col ref="duplication"/>
			</datagrid>
			<line id="line1" class="line_1" style="x1:0px; y1:276px; x2:1195px; y2:276px; "/>
			<button id="button2" class="btn2_letter4" navindex="-1" style="left:5px; top:15px; width:97px; height:19px; ">
				<caption>입력샘플</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSaveExcel(grd_bugtexcellist);
					]]>
				</script>
			</button>
			<button id="button3" class="btn2_letter6" navindex="-1" style="left:72px; top:15px; width:86px; height:19px; ">
				<caption>Excel(적용)</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSaveExcel(grd_bugtchecklist);
					]]>
				</script>
			</button>
			<select1 id="cmb_instcd" ref="/root/send/condition/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:274px; top:15px; width:175px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption7" class="search_name" style="left:185px; top:15px; width:86px; height:17px; ">기     관 :</caption>
			<input id="ipt_depthngnm" ref="/root/send/condition/depthngnm" class="input_s_essential" disabled="true" navindex="3" imemode="hangul" style="left:815px; top:15px; 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");
							}
							
							fRetrieve();
							
							fAppCheck();

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

							fOpenPopupDeptHelp(ipt_deptcd, "deptcd,depthngnm");
							fRetrieve();
							
							fAppCheck();

						]]>
				</script>
			</button>
			<caption id="caption3" class="search_name" style="left:636px; top:15px; width:107px; height:17px; ">부  서 :</caption>
			<input id="ipt_deptcd" ref="/root/send/condition/deptcd" class="input_s_essential" disabled="true" navindex="2" maxlength="10" style="left:710px; top:15px; 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");
							}
							
							fRetrieve();
							
							fAppCheck();

						]]>
				</script>
			</input>
			<caption id="caption2" class="search_name" style="left:465px; top:15px; width:86px; height:17px; ">예산년도 :</caption>
			<input id="ipt_acntyy" ref="/root/send/condition/acntyy" class="input_s_essential" disabled="true" navindex="1" maxlength="4" style="left:554px; top:15px; width:68px; height:19px; text-align:center; "/>
			<datagrid id="grd_bugtexceluploadlist" nodeset="/root/main/bugtexcelupload/bugtexceluploadlist" visibility="hidden" caption="기관코드^회계년도^작업구분^부서코드^예산구분^계정코드^배정월^적요^산출근거^예산액" colwidth="75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75, 75" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:415px; top:160px; width:770px; height:105px; ">
				<col ref="instcd"/>
				<col ref="acntyy"/>
				<col ref="workflag"/>
				<col ref="deptcd"/>
				<col disabled="true" ref="bugtflag"/>
				<col ref="acntcd"/>
				<col disabled="true" ref="assgym"/>
				<col ref="bugtappresn"/>
				<col ref="bugtappbase"/>
				<col ref="bugtappamt" format="(-)#,###" style="text-align:right; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>