YNU_JEUS/app_home/himed/webapps/mis/fundsweb/xrw/SMRAF00300_자금일보월보.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>Untitle</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list1>
							<acntpr/>
						</list1>
						<list2>
							<fundscdpr/>
						</list2>
						<list3>
							<planexeclist/>
						</list3>
						<daylist/>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<instnm/>
							<frdate/>
							<todate/>
							<kind/>
						</retrparams>
						<retrparams2>
							<instcd/>
							<frdate/>
							<kind/>
						</retrparams2>
						<retrparams3>
							<instcd/>
							<frdate/>
							<kind/>
						</retrparams3>
						<retrparams4>
							<instcd/>
							<dutym/>
						</retrparams4>
					</send>
					<init/>
					<temp/>
				</root>
			</instance>
			<submission id="TRRAF00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list1"/>
			<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/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[

					fInit();

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

					var arrBaseDD   = new Array();
					var arrHoliFlag = new Array();
					var arrDayNm    = new Array();

					function fInit()
					{
						misfComboComCdListMulti("Z0007,Z0007,Z0007", "cmb_instcd,cmb_instcd2,cmb_instcd3");
						
						model.removenode("/root/main/list1/acntpr");
						model.removenode("/root/main/list2/fundscdpr");
						model.removenode("/root/main/list3/planexeclist");

						model.setValue("/root/send/retrparams/instcd", getUserInfo("dutplceinstcd"));
						model.setValue("/root/send/retrparams/frdate", getCurrentDate());
						model.setValue("/root/send/retrparams/todate", getCurrentDate());

						model.setValue("/root/send/retrparams2/instcd", getUserInfo("dutplceinstcd"));
						model.setValue("/root/send/retrparams2/frdate", getCurrentDate().substr(0, 6));

						model.setValue("/root/send/retrparams3/instcd", getUserInfo("dutplceinstcd"));
						model.setValue("/root/send/retrparams3/frdate", getCurrentDate().substr(0, 6));

						fSetGridMonth("C");
						
						if(getUserInfo("dutplceinstcd") == '001')
						{
							cmb_instcd.visible = true;
						}

						model.refresh();
					}
					
					function fRetrieveAcntPr()
					{
						model.setValue("/root/send/retrparams/kind", "acntpr");
						submit("TRRAF00301");

						for(var i=2; i<grd_acntpr.rows; i++)
						{
							var sOrderFlag = model.getValue(grd_acntpr.nodeset + "[" + (i - 1) + "]/orderflag");
							
							if(sOrderFlag == "1")	  grd_acntpr.rowStyle(i, "all", "background-color") = "#ffffff";
							else if(sOrderFlag == "2") grd_acntpr.rowStyle(i, "all", "background-color") = "#ffffcc";
							else if(sOrderFlag == "3") grd_acntpr.rowStyle(i, "all", "background-color") = "#ccffcc";
						}

						model.refresh();
					}
					
					function fRetrieveFundsCdPr()
					{
						model.setValue("/root/send/retrparams2/kind", "fundscdpr");
						submit("TRRAF00302");
						model.refresh();
						
						for(var i=2; i<grd_fundscdpr.rows; i++)
						{
							var sOrderFlag = model.getValue(grd_fundscdpr.nodeset + "[" + (i - 1) + "]/orderflag");
							var sFundsCd   = model.getValue(grd_fundscdpr.nodeset + "[" + (i - 1) + "]/setfundscd");

							if(sOrderFlag == "1")
							{
								if(sFundsCd == "0000" || sFundsCd == "9700")	grd_fundscdpr.rowStyle(i, "all", "background-color") = "#eaeaea";
								else if(sFundsCd == "9800")                  grd_fundscdpr.rowStyle(i, "all", "background-color") = "#dddddd";
								else if(sFundsCd == "9900")                  grd_fundscdpr.rowStyle(i, "all", "background-color") = "#c0c0c0";
								else									grd_fundscdpr.rowStyle(i, "all", "background-color") = "#ffffff";
								
							}
							else if(sOrderFlag == "2") grd_fundscdpr.rowStyle(i, "all", "background-color") = "#ffffcc";
							else if(sOrderFlag == "3") grd_fundscdpr.rowStyle(i, "all", "background-color") = "#ccffcc";
						}
						
						fSetGridMonth("R");

						fSetSumAmt(grd_fundscdpr);
					}
					
					function fRetrievePlanExecList()
					{
						model.setValue("/root/send/retrparams3/kind", "planexeclist");
						submit("TRRAF00303");
						model.refresh();
						
						for(var i=2; i<grd_planexeclist.rows; i++)
						{
							var sOrderFlag = model.getValue(grd_planexeclist.nodeset + "[" + (i - 1) + "]/orderflag");
							var sFundsCd   = model.getValue(grd_planexeclist.nodeset + "[" + (i - 1) + "]/setfundscd");

							if(sOrderFlag == "1")
							{
								if(sFundsCd == "0000" || sFundsCd == "9700")	grd_planexeclist.rowStyle(i, "all", "background-color") = "#eaeaea";
								else if(sFundsCd == "9800")                  grd_planexeclist.rowStyle(i, "all", "background-color") = "#dddddd";
								else if(sFundsCd == "9900")                  grd_planexeclist.rowStyle(i, "all", "background-color") = "#c0c0c0";
								else									grd_planexeclist.rowStyle(i, "all", "background-color") = "#ffffff";
								
							}
							else if(sOrderFlag == "2") grd_planexeclist.rowStyle(i, "all", "background-color") = "#ffffcc";
							else if(sOrderFlag == "3") grd_planexeclist.rowStyle(i, "all", "background-color") = "#ccffcc";
						}
						
						fSetSumAmt(grd_planexeclist);
					}
					
					function fSetSumAmt(pGrid)
					{
						var iFundsGb1Sum    = 0;
						var iFundsGb1DrAmt  = 0;
						var iFundsGb1CrAmt  = 0;
						var iFundsGb1RowIdx = -1;

						var iFundsGB2Sum    = 0;
						var iFundsGb2DrAmt  = 0;
						var iFundsGb2CrAmt  = 0;
						var iFundsGb2RowIdx = -1;

						var iFundsGB3Sum    = 0;
						var iFundsGb3DrAmt  = 0;
						var iFundsGb3CrAmt  = 0;
						var iFundsGb3RowIdx = -1;

						var iFundsGB4Sum    = 0;
						var iFundsGb4DrAmt  = 0;
						var iFundsGb4CrAmt  = 0;
						var iFundsGb4RowIdx = -1;

						var iFundsGB5Sum    = 0;
						var iFundsGb5DrAmt  = 0;
						var iFundsGb5CrAmt  = 0;
						var iFundsGb5RowIdx = -1;

						var iPreMonthAmt    = 0;	// 전기이월금액
						var iNextACntAmt    = 0;	// 차기이월금액
						var iAcntAmt        = 0; // 제예금잔액 = 차입실행액 - 예금인출액
						var iSendAmt        = 0; // 차입금잔액 = 차입실행액 - 차입상환액
	
						var i7100Amt        = 0;	// 예금인출액
						var i8100Amt        = 0;	// 예금불입액
						var i7300Amt        = 0;	// 차입실행액
						var i8300Amt        = 0;	// 차입상환액
						
						var iPreMonthRowIdx = pGrid.findRow("0000", 2, pGrid.colRef("setfundscd"));	// 전기이월     Row Index
						var iNextAcntRowIdx = pGrid.findRow("9700", 2, pGrid.colRef("setfundscd"));	// 차기이월금액 Row Index
						var iAcntRowIdx     = pGrid.findRow("9800", 2, pGrid.colRef("setfundscd"));	// 제예금잔액   Row Index
						var iSendRowIdx     = pGrid.findRow("9900", 2, pGrid.colRef("setfundscd"));	// 차입금잔액   Row Index
						
						var i7100RowIdx     = pGrid.findRow("7100", 2, pGrid.colRef("setfundscd"));	// 예금인출 Row Index
						var i8100RowIdx     = pGrid.findRow("8100", 2, pGrid.colRef("setfundscd"));	// 예금불입 Row Index
						var i7300RowIdx     = pGrid.findRow("7300", 2, pGrid.colRef("setfundscd"));	// 차입실행 Row Index
						var i8300RowIdx     = pGrid.findRow("8300", 2, pGrid.colRef("setfundscd"));	// 차입상환 Row Index

						for(var i=2; i<pGrid.rows; i++)
						{
							if(pGrid.valueMatrix(i, pGrid.colRef("fundssumgb")) == "02" && pGrid.valueMatrix(i, pGrid.colRef("orderflag")) == "3")
							{
								iFundsGb1RowIdx = i;
							}
							else if(pGrid.valueMatrix(i, pGrid.colRef("fundssumgb")) == "04" && pGrid.valueMatrix(i, pGrid.colRef("orderflag")) == "3")
							{
								iFundsGb2RowIdx = i;
							}
							else if(pGrid.valueMatrix(i, pGrid.colRef("fundssumgb")) == "06" && pGrid.valueMatrix(i, pGrid.colRef("orderflag")) == "3")
							{
								iFundsGb3RowIdx = i;
							}
							else if(pGrid.valueMatrix(i, pGrid.colRef("fundssumgb")) == "08" && pGrid.valueMatrix(i, pGrid.colRef("orderflag")) == "3")
							{
								iFundsGb4RowIdx = i;
							}
							else if(pGrid.valueMatrix(i, pGrid.colRef("fundssumgb")) == "10" && pGrid.valueMatrix(i, pGrid.colRef("orderflag")) == "3")
							{
								iFundsGb5RowIdx = i;
							}
						}
						
						var iLastCol = 1;
						if(pGrid.attribute("id") == "grd_planexeclist") iLastCol = 2;

						for(var i=pGrid.frozenCols; i<pGrid.cols - iLastCol; i++)
						{
							for(var j=2; j<pGrid.rows; j++)
							{
								if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "01" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "2")
								{
									iFundsGb1DrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "02" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "2")
								{
									iFundsGb1CrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "03" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb2DrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "04" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb2CrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "05" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb3DrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "06" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb3CrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "07" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "2")
								{
									iFundsGb4DrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "08" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "2")
								{
									iFundsGb4CrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "09" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb5DrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
								else if(pGrid.valueMatrix(j, pGrid.colRef("fundssumgb")) == "10" && pGrid.valueMatrix(j, pGrid.colRef("orderflag")) == "1")
								{
									iFundsGb5CrAmt = parseInt(pGrid.valueMatrix(j, i), 10);
								}
							}

							i7100Amt = parseInt(pGrid.valueMatrix(i7100RowIdx, i), 10);
							i8100Amt = parseInt(pGrid.valueMatrix(i8100RowIdx, i), 10);
							i7300Amt = parseInt(pGrid.valueMatrix(i7300RowIdx, i), 10);
							i8300Amt = parseInt(pGrid.valueMatrix(i8300RowIdx, i), 10);

							if(i == pGrid.frozenCols || pGrid.attribute("id") == "grd_planexeclist")
							{
								iPreMonthAmt = parseInt(pGrid.valueMatrix(iPreMonthRowIdx, i) == "" ? 0 : pGrid.valueMatrix(iPreMonthRowIdx, i), 10);
								iAcntAmt     = parseInt(pGrid.valueMatrix(iAcntRowIdx,     i) == "" ? 0 : pGrid.valueMatrix(iAcntRowIdx,     i), 10);
								iSendAmt     = parseInt(pGrid.valueMatrix(iSendRowIdx,     i) == "" ? 0 : pGrid.valueMatrix(iSendRowIdx,     i), 10);
							}
							else
							{
								iPreMonthAmt = 0;
								iAcntAmt     = 0;
								iSendAmt     = 0;
							}

							iFundsGb1Sum = iFundsGb1DrAmt - iFundsGb1CrAmt;
							iFundsGB2Sum = iFundsGb2DrAmt - iFundsGb2CrAmt;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
							iFundsGB3Sum = iFundsGb3DrAmt - iFundsGb3CrAmt;
							iFundsGB4Sum = iFundsGb4DrAmt - iFundsGb4CrAmt;
							iFundsGB5Sum = iFundsGb5DrAmt - iFundsGb5CrAmt;
							
							iNextACntAmt = iPreMonthAmt + (iFundsGb1Sum + iFundsGB2Sum + iFundsGB3Sum + iFundsGB4Sum + iFundsGB5Sum);
							iAcntAmt     = iAcntAmt + (i8100Amt - i7100Amt);
							iSendAmt     = iSendAmt + (i7300Amt - i8300Amt);

							model.setValue(pGrid.nodeset + "[" + (iFundsGb1RowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iFundsGb1Sum);
							model.setValue(pGrid.nodeset + "[" + (iFundsGb2RowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iFundsGB2Sum);
							model.setValue(pGrid.nodeset + "[" + (iFundsGb3RowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iFundsGB3Sum);
							model.setValue(pGrid.nodeset + "[" + (iFundsGb4RowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iFundsGB4Sum);
							model.setValue(pGrid.nodeset + "[" + (iFundsGb5RowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iFundsGB5Sum);

							model.setValue(pGrid.nodeset + "[" + (iNextAcntRowIdx - 1) + "]/" + pGrid.colAttribute(i, "ref"), iNextACntAmt);

							if((pGrid.attribute("id") != "grd_planexeclist" && i == pGrid.frozenCols) || (i != pGrid.frozenCols))
							{
								model.setValue(pGrid.nodeset + "[" + (iAcntRowIdx - 1)     + "]/" + pGrid.colAttribute(i, "ref"), iAcntAmt);
								model.setValue(pGrid.nodeset + "[" + (iSendRowIdx - 1)     + "]/" + pGrid.colAttribute(i, "ref"), iSendAmt);
							}

						}
					}

					function fSetGridMonth(sType)
					{
						arrBaseDD   = new Array();
						arrHoliFlag = new Array();
						arrDayNm    = new Array();

						if(sType == "C")
						{
							model.setValue("/root/send/retrparams4/instcd", model.getValue("/root/send/retrparams/instcd"));
							model.setValue("/root/send/retrparams4/dutym",  model.getValue("/root/send/retrparams/frdate").substr(0, 6));
							submit("TRRPD02206");
						}
						else
						{
							for(var i=1; i<=31; i++)
							{
								arrBaseDD[i - 1]   = model.getValue("/root/main/daylist[" + i + "]/basedd");
								arrHoliFlag[i - 1] = model.getValue("/root/main/daylist[" + i + "]/holiflag");
								arrDayNm[i - 1]    = model.getValue("/root/main/daylist[" + i + "]/daynm");

								if(arrBaseDD[i - 1] == "")
								{
									grd_fundscdpr.colHidden(i + 6) = true;
								}
								else
								{
									grd_fundscdpr.colHidden(i + 6) = false;
								}
		
								if(arrHoliFlag[i - 1] == '4')
								{
									grd_fundscdpr.colStyle((i + 6), "all", "color") = "#0000FF";
								}
								else if(arrHoliFlag[i - 1] == '0')
								{
									grd_fundscdpr.colStyle((i + 6), "all", "color") = "#FF0000";
								}
								else
								{
									grd_fundscdpr.colStyle((i + 6), "all", "color") = "#000000";
								}
							}
						}
					}

				]]>
			</script>
			<submission id="TRRAF00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams2" resultref="/root/main/list2"/>
			<submission id="TRRPD02206" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams4" resultref="/root/main/daylist"/>
			<submission id="TRRAF00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams3" resultref="/root/main/list3"/>
		</model>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1195;2,777;" 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:65px; width:1195px; height:715px; ">
			<switch id="switch1" style="left:0px; top:0px; width:1195px; height:715px; ">
				<case id="case1" selected="true">
					<group id="grp_sea" style="left:0px; top:10px; width:1193px; height:35px; vertical-align:top; ">
						<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
						<line id="line5" class="line_4" style="x1:1107px; y1:7px; x2:1107px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
						<caption id="caption1" class="search_name" style="left:305px; top:9px; width:86px; height:17px; ">조회일자 :</caption>
						<select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_search" disabled="true" navindex="1" appearance="minimal" style="left:105px; top:8px; width:145px; height:19px; ">
							<choices>
								<itemset>
									<label/>
									<value/>
								</itemset>
							</choices>
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[

								]]>
							</script>
						</select1>
						<caption id="caption7" class="search_name" style="left:16px; top:9px; width:86px; height:17px; ">기관구분 :</caption>
						<input id="ipt_frdate" ref="/root/send/retrparams/frdate" class="input_s_essential" inputtype="date" style="left:395px; top:8px; width:100px; height:19px; text-align:center; "/>
						<button id="btn_searchacntpr" class="btn1_letter2" navindex="4" style="left:1124px; top:7px; width:56px; height:22px; text-align:left; ">
							<caption>조회</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[

									fRetrieveAcntPr();

								]]>
							</script>
						</button>
						<input id="input1" ref="/root/send/retrparams/todate" class="input_s_essential" inputtype="date" style="left:513px; top:8px; width:100px; height:19px; text-align:center; "/>
						<caption id="caption3" style="left:498px; top:11px; width:14px; height:15px; ">~</caption>
					</group>
					<button id="btn_excelforacntpr" class="btn2_letter2" style="left:1148px; top:50px; width:42px; height:19px; text-align:left; ">
						<caption>엑셀</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

								misfSaveExcel(grd_acntpr);

							]]>
						</script>
					</button>
					<line id="line3" class="line_1" style="x1:0px; y1:70px; x2:1193px; y2:70px; "/>
					<caption id="caption21" class="tit_2" style="left:5px; top:55px; width:131px; height:14px; ">계좌별현황</caption>
					<datagrid id="grd_acntpr" nodeset="/root/main/list1/acntpr" allowuserresize="false" backcoloralternate="transparent" caption="구분^구분^구분^전일잔액^입금^출금^잔액|자금구분^은행명^계좌명^전일잔액^입금^출금^잔액" colsep="^" colwidth="114, 200, 140, 160, 160, 160, 160" frozencols="3" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:75px; width:1193px; height:638px; ">
						<col ref="fundskind"/>
						<col ref="custnm"/>
						<col ref="fncmnm"/>
						<col ref="balamt" format="(-)#,###" style="text-align:right; "/>
						<col ref="dramt" format="(-)#,###" style="text-align:right; "/>
						<col ref="cramt" format="(-)#,###" style="text-align:right; "/>
						<col ref="curbalamt" format="(-)#,###" style="text-align:right; "/>
					</datagrid>
				</case>
				<case id="case2" style="left:0px; top:0px; width:1192px; height:713px; ">
					<group id="group2" style="left:0px; top:10px; width:1192px; height:35px; vertical-align:top; ">
						<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1192px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
						<button id="btn_search2" class="btn1_letter2" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; text-align:left; ">
							<caption>조회</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[

									fRetrieveFundsCdPr();

								]]>
							</script>
						</button>
						<line id="line1" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
						<caption id="caption2" class="search_name" style="left:305px; top:9px; width:86px; height:17px; ">조회년월 :</caption>
						<caption id="caption8" class="search_name" style="left:16px; top:9px; width:86px; height:17px; ">기관구분 :</caption>
						<select1 id="cmb_instcd2" ref="/root/send/retrparams2/instcd" class="combo_search" disabled="false" navindex="1" appearance="minimal" style="left:105px; top:8px; width:145px; height:19px; ">
							<choices>
								<itemset>
									<label/>
									<value/>
								</itemset>
							</choices>
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[

									fSetGridMonth("C");

									fRetrieveFundsCdPr();

								]]>
							</script>
						</select1>
						<input id="ipt_frdate2" ref="/root/send/retrparams2/frdate" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:395px; top:8px; width:100px; height:19px; text-align:center; ">
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[

									fSetGridMonth("C");

									fRetrieveFundsCdPr();

								]]>
							</script>
						</input>
					</group>
					<caption id="caption9" class="tit_2" style="left:5px; top:55px; width:131px; height:14px; ">자금과목별현황</caption>
					<datagrid id="grd_fundscdpr" nodeset="/root/main/list2/fundscdpr" autoresize="false" backcoloralternate="#ffffff" caption="구분^합계구분^구분^구분^정렬Flag^합계^1^2^3^4^5^6^7^8^9^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^Set자금코드|자금구분^합계구분^자금과목^자금과목^정렬Flag^합계^1^2^3^4^5^6^7^8^9^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^Set자금코드" colsep="^" colwidth="114, 0, 157, 80, 0, 100, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 0" frozencols="6" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:75px; width:1192px; height:638px; ">
						<col ref="fundsgb" style="text-align:center; "/>
						<col ref="fundssumgb"/>
						<col ref="fundsnm" style="text-align:center; "/>
						<col ref="fundscd" style="text-align:center; "/>
						<col ref="orderflag" visibility="hidden"/>
						<col ref="sumamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day01" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day02" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day03" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day04" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day05" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day06" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day07" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day08" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day09" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day10" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day11" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day12" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day13" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day14" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day15" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day16" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day17" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day18" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day19" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day20" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day21" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day22" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day23" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day24" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day25" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day26" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day27" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day28" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day29" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day30" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="day31" format="(-)#,###" style="text-align:right; padding-right:2; "/>
						<col ref="setfundscd" visibility="hidden"/>
					</datagrid>
					<button id="btn_excelfundscdpr" class="btn2_letter2" style="left:1148px; top:50px; width:42px; height:19px; text-align:left; ">
						<caption>엑셀</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

								misfSaveExcel(grd_fundscdpr);

							]]>
						</script>
					</button>
					<line id="line4" class="line_1" style="x1:0px; y1:70px; x2:1192px; y2:70px; "/>
				</case>
				<case id="case3">
					<button id="btn_excelplanexeclist" class="btn2_letter2" style="left:1148px; top:50px; width:42px; height:19px; text-align:left; ">
						<caption>엑셀</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

								misfSaveExcel(grd_planexeclist);

							]]>
						</script>
					</button>
					<caption id="caption12" class="tit_2" style="left:5px; top:55px; width:131px; height:14px; ">계획대비실적</caption>
					<group id="group6" style="left:0px; top:10px; width:1192px; height:35px; vertical-align:top; ">
						<shape id="roundrect4" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1192px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
						<line id="line8" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
						<caption id="caption13" class="search_name" style="left:305px; top:9px; width:86px; height:17px; ">조회년월 :</caption>
						<caption id="caption14" class="search_name" style="left:16px; top:9px; width:86px; height:17px; ">기관구분 :</caption>
						<select1 id="cmb_instcd3" ref="/root/send/retrparams3/instcd" class="combo_search" disabled="false" navindex="1" appearance="minimal" style="left:105px; top:8px; width:145px; height:19px; ">
							<choices>
								<itemset>
									<label/>
									<value/>
								</itemset>
							</choices>
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[

									fRetrievePlanExecList();

								]]>
							</script>
						</select1>
						<input id="ipt_frdate3" ref="/root/send/retrparams3/frdate" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:395px; top:8px; width:100px; height:19px; text-align:center; ">
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[

									fRetrievePlanExecList();

								]]>
							</script>
						</input>
						<button id="btn_search3" class="btn1_letter2" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; text-align:left; ">
							<caption>조회</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[

									fRetrievePlanExecList();

								]]>
							</script>
						</button>
					</group>
					<line id="line9" class="line_1" style="x1:0px; y1:70px; x2:1192px; y2:70px; "/>
					<datagrid id="grd_planexeclist" nodeset="/root/main/list3/planexeclist" autoresize="false" backcoloralternate="#ffffff" caption="구분^합계구분^구분^구분^정렬Flag^계획^실적^실적율^Set자금코드|자금구분^합계구분^자금과목^자금과목^정렬Flag^계획^실적^실적율^Set자금코드" colsep="^" colwidth="114, 0, 157, 80, 0, 220, 220, 70, 0" frozencols="6" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:75px; width:1192px; height:638px; ">
						<col ref="fundsgb" style="text-align:center; "/>
						<col ref="fundssumgb"/>
						<col ref="fundsnm" style="text-align:center; "/>
						<col ref="fundscd" style="text-align:center; "/>
						<col ref="orderflag" visibility="hidden"/>
						<col ref="plansumamt" format="(-)#,###" style="text-align:right; padding-right:3; "/>
						<col ref="execsumamt" format="(-)#,###" style="text-align:right; padding-right:3; "/>
						<col ref="execrate" style="text-align:right; padding-right:3; "/>
						<col ref="setfundscd" visibility="hidden"/>
					</datagrid>
				</case>
			</switch>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
		</group>
		<button id="button65" class="btn_sw" group="tab" selected="true" style="left:0px; top:45px; width:80px; height:22px; ">
			<caption>계좌별</caption>
			<toggle case="case1" ev:event="onclick"/>
		</button>
		<button id="button64" class="btn_sw" group="tab" style="left:80px; top:45px; width:100px; height:22px; ">
			<caption>자금과목별</caption>
			<toggle case="case2" ev:event="onclick"/>
		</button>
		<button id="button1" class="btn_sw" group="tab" style="left:180px; top:45px; width:105px; height:22px; ">
			<caption>계획대비실적</caption>
			<toggle case="case3" ev:event="onclick"/>
		</button>
	</xhtml:body>
</xhtml:html>