YNU_JEUS/app_home/himed/webapps/mis/slipweb/xrw/SMRAD00710_계정별잔액조회.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>
						<acntbalancesheet/>
					</main>
					<send>
						<params>
							<instcd/>
							<frdate/>
							<todate/>
							<acntcd/>
							<acntnm/>
							<acntclsflag>1</acntclsflag>
						</params>
					</send>
					<init/>
					<temp/>
					<hidden/>
				</root>
			</instance>
			<submission id="TRRAD00711" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/params" resultref="/root/main/acntbalancesheet"/>
		</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[
				model.removeNodeset("/root/main/acntbalancesheet");				
				fSetDayMonthDate();							
				model.setValue("/root/send/params/instcd", getUserInfo("dutplceinstcd"));
				model.setFocus("ipt_acntcd");
				model.refresh();
			]]>
		</script>
		<script type="javascript">
			<![CDATA[

				function fSetDayMonthDate()
				{
					
					
					var dt = new Date();
					var lastdt = new Date(dt.getYear(), dt.getMonth()+1, 0);
					
					ipt_todate.value = getCurrentDate().substr(0, 6) + lastdt.getDate();			
					
					fSetFromDD();		
				}
				
				function fSetFromDD()
				{
					var vAcntYY = radfgetAcntYY(getUserInfo("dutplceinstcd"), ipt_todate.value);
					if(vAcntYY == "")
					{
						messageBox("기수관리에 회계년도가 등록되어 있지 않습니다." ,"I000");
						ipt_todate.value = "";
					}
					else
					{
						ipt_frdate.value = vAcntYY + "0301";	
						
					}
					
				}
				
				
				function fRetrieve()
				{
					if(!fCheckAcntCdNull())	return;
					submit("TRRAD00711");
					fSetRowColor(grd_acntbalancesheet);
				}

				function fCheckAcntCdNull()
				{
					var bRet = true;
					
					if(model.getValue("/root/send/params/acntcd") == "")
					{
						messageBox("선택된 계정과목이 ", "I004");
						return false;
					}
										
					return bRet;
				}
				
				function fSetRowColor(pGrid)
				{
					var iCnt = 0;
					
					for(var i=0; i<pGrid.rows;i++)
					{
						if(pGrid.valueMatrix(i, pGrid.colRef("dflag")) == "1")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ccffff";
						}
						else if(pGrid.valueMatrix(i, pGrid.colRef("dflag")) == "3")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ffccff";
						}						
					}
				}
				
				//========================================================================================
				//코드 Validation Check
				//========================================================================================
				function fValidationCheck(vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName, pRetrKind)
				{
					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, pRetrKind);
						model.refresh();
						
						if (pNextIndex != "")
						{
							model.setFocus(pNextIndex);
						}
					}
				}				
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1193;" 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; ">
			<group id="group4" style="left:0px; top:5px; width:1195px; height:35px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line30" class="line_4" style="x1:1109px; y1:5px; x2:1109px; y2:30px; background-color:transparent; border-color:transparent; "/>
				<button id="btn_search" class="btn1_letter2" navindex="5" style="left:1125px; top:6px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fRetrieve();
						]]>
					</script>
				</button>
				<select1 id="cmb_acntclsflag" ref="/root/send/params/acntclsflag" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:405px; top:9px; width:63px; height:19px; ">
					<choices>
						<item>
							<label>대분류</label>
							<value>4</value>
						</item>
						<item>
							<label>관</label>
							<value>3</value>
						</item>
						<item>
							<label>항</label>
							<value>2</value>
						</item>
						<item>
							<label>목</label>
							<value>1</value>
						</item>
						<item>
							<label>세목</label>
							<value>0</value>
						</item>
					</choices>
				</select1>
				<button id="btn_fracnthelp2" class="icon_search" style="left:201px; top:9px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[								
									misfOpenPopUpList("05", ipt_acntcd, "", "acntcd,acntnm", "cmb_acntclsflag", "acntclsflag");	
									model.refresh();
						]]>
					</script>
				</button>
				<input id="ipt_acntcd" ref="/root/send/params/acntcd" class="input_s_essential" navindex="4" style="left:122px; top:9px; width:75px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
									if(event.keyCode == 13)
									{
										model.setFocus("btn_search");
									}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									fValidationCheck("05", "acntcd,acntnm", "", "", "cmb_acntclsflag", "acntclsflag");

						]]>
					</script>
				</input>
				<caption id="caption28" class="search_name" style="left:30px; top:9px; width:90px; height:17px; ">계정과목 :</caption>
				<input id="ipt_acntnm" ref="/root/send/params/acntnm" class="input_s_essential" navindex="5" style="left:219px; top:9px; width:176px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
									if(event.keyCode == 13)
									{
										model.setFocus("btn_search");
									}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									fValidationCheck("05", "acntcd,acntnm", "", "", "cmb_acntclsflag", "acntclsflag");

						]]>
					</script>
				</input>
				<input id="ipt_todate" ref="/root/send/params/todate" class="input_s_essential" navindex="3" inputtype="date" format="yyyy-mm-dd" style="left:747px; top:9px; width:101px; height:19px; "/>
				<caption id="caption2" class="search_name" style="left:530px; top:9px; width:86px; height:17px; ">기     간 :</caption>
				<input id="ipt_frdate" ref="/root/send/params/frdate" class="input_s_essential" disabled="false" navindex="2" inputtype="date" format="yyyy-mm-dd" style="left:620px; top:9px; width:100px; height:19px; "/>
				<caption id="cpt_slip" visibility="visible" style="left:726px; top:10px; width:15px; height:20px; ">~</caption>
			</group>
			<datagrid id="grd_acntbalancesheet" nodeset="/root/main/acntbalancesheet" backcoloralternate="#ffffff" caption="구분^기관코드^계정코드^계정과목^전일누계^차변^대변^당기잔액^잔액" colsep="^" colwidth="0, 0, 120, 330, 150, 150, 150, 0, 150" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:65px; width:1193px; height:677px; ">
				<col ref="dflag" visibility="hidden"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="acntcd"/>
				<col ref="acntnm" style="padding-left:10; "/>
				<col class="text_right" ref="transamt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
				<col class="text_right" ref="dramt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
				<col class="text_right" ref="cramt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
				<col class="text_right" ref="balamt" visibility="hidden" format="(-)#,###" savetype="digit" style="text-align:right; "/>
				<col class="text_right" ref="sumbalamt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
			</datagrid>
			<button id="button6" class="btn2_letter4" style="left:1126px; top:43px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

								//radfSaveExcel(grd_acntbalancesheet);
								var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
								grd_acntbalancesheet.saveExcel(fileName,"SheetName:sheet1");

							]]>
				</script>
			</button>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:13px; width:1195px; height:27px; ">
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
			<button id="button8" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>