YNU_JEUS/app_home/himed/webapps/mis/slipweb/xrw/SMRAD00600_총계정원장.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>
						<tacnt>
							<day>
								<totalacntlist/>
							</day>
							<month>
								<totalacntlist/>
							</month>
						</tacnt>
						<date>
							<day>
								<frdate/>
								<todate/>
								<tempdate/>
							</day>
							<month>
								<frdate/>
								<todate/>
								<tempdate/>
							</month>
						</date>
					</main>
					<send>
						<params>
							<instcd/>
							<frdate/>
							<todate/>
							<fracntcd/>
							<fracntnm/>
							<toacntcd/>
							<toacntnm/>
							<retrflag/>
							<acntclsflag>1</acntclsflag>
						</params>
						<retrparams>
							<instnm/>
							<retrflag/>
							<frdate/>
							<todate/>
							<fracntcd/>
							<fracntnm/>
							<toacntcd/>
							<toacntnm/>
						</retrparams>
						<prntlist>
							<gridlist/>
						</prntlist>
					</send>
					<init/>
					<temp/>
				</root>
			</instance>
			<submission id="TRRAD00601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/params" resultref="/root/main/tacnt/day"/>
			<submission id="TRRAD00602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/params" resultref="/root/main/tacnt/month"/>
		</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/tacnt/day/totalacntlist");
				model.removeNodeset("/root/main/tacnt/month/totalacntlist");
				
				fSetDayMonthDate();
				
				btn_daypr.dispatch("DOMActivate");
				
				misfMsterDetailSet(grd_daypr,   null,"TRRAD00601", "N");
				misfMsterDetailSet(grd_monthpr, null,"TRRAD00602", "N");
				
				misfComboComCdList("Z0007", cmb_instcd, "N");
				
				radfCheckInstSearchAuth(getUserInfo("dutplceinstcd"), cmb_instcd);
				
				model.setValue("/root/send/params/instcd", getUserInfo("dutplceinstcd"));
				model.setValue("/root/send/params/retrflag", "day");

				model.setFocus("ipt_fracntcd");

				model.refresh();

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

				function fSetDayMonthDate()
				{
					var dt = new Date();
					var lastdt = new Date(dt.getYear(), dt.getMonth()+1, 0);

					ipt_frdate1.value = getCurrentDate().substr(0, 6) + "01";
					ipt_todate1.value = getCurrentDate().substr(0, 6) + lastdt.getDate();
					ipt_frdate2.value = getCurrentDate().substr(0, 6);
					ipt_todate2.value = getCurrentDate().substr(0, 6);
					
				}

				function fRetrieve()
				{
					model.setValue("/root/send/params/frdate", model.getValue("/root/main/date/" + model.getValue("/root/send/params/retrflag") + "/frdate"));
					model.setValue("/root/send/params/todate", model.getValue("/root/main/date/" + model.getValue("/root/send/params/retrflag") + "/todate"));

					if(!fCheckAcntCdNull())
					{
						return;
					}

					model.refresh();

					if(model.getValue("/root/send/params/retrflag") == "day")
					{
						submit("TRRAD00601");
						fSetRowColor(grd_daypr);
					}
					else
					{
						
						submit("TRRAD00602");
						fSetRowColor(grd_monthpr);
					}
				}

				function fCheckAcntCdNull()
				{
					var bRet = true;
					
					if(model.getValue("/root/send/params/fracntcd") == "" && model.getValue("/root/send/params/toacntcd") == "")
					{
						messageBox("선택된 계정과목이 ", "I004");
						return false;
					}
					
					if(model.getValue("/root/send/params/fracntcd") != "" && model.getValue("/root/send/params/toacntcd") == "")
					{
						model.setValue("/root/send/params/toacntcd", model.getValue("/root/send/params/fracntcd"));
						model.setValue("/root/send/params/toacntnm", model.getValue("/root/send/params/fracntnm"));
					}
					else if(model.getValue("/root/send/params/fracntcd") == "" && model.getValue("/root/send/params/toacntcd") != "")
					{
						model.setValue("/root/send/params/fracntcd", model.getValue("/root/send/params/toacntcd"));
						model.setValue("/root/send/params/fracntnm", model.getValue("/root/send/params/toacntnm"));
					}
					
					return bRet;
				}
				
				function fSetRowColor(pGrid)
				{
					var iCnt = 0;
					
					for(var i=0; i<pGrid.rows;i++)
					{
						if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "1")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ccffff";
						}
						else if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "2")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ffffff";
						}
						else if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "3")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ffccff";
						}
						else if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "4")
						{
							pGrid.rowStyle(i, "all", "background-color") = "#ffffcc";
						}
					}
					
					//pGrid.frozenRows = 1;
//					pGrid.frozenBottomRows = 1;
//					pGrid.backColorFrozen = "#dddddd";
				}
				
				//========================================================================================
				//코드 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:60px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption24" class="search_name" visibility="hidden" style="left:425px; top:35px; width:86px; height:17px; ">(class)</caption>
				<caption id="caption5" class="search_name" style="left:19px; top:10px; width:90px; height:17px; ">기관코드 :</caption>
				<select1 id="cmb_instcd" ref="/root/send/params/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:108px; top:9px; width:237px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<line id="line30" class="line_4" style="x1:1109px; y1:3px; x2:1109px; y2:58px; background-color:transparent; border-color:transparent; "/>
				<switch id="sw_date" style="left:6px; top:30px; width:320px; height:25px; ">
					<case id="case_dayparams" selected="true" style="left:0px; top:0px; width:338px; height:23px; ">
						<caption id="caption2" class="search_name" style="left:12px; top:3px; width:86px; height:17px; ">기     간 :</caption>
						<caption id="caption1" style="left:203px; top:4px; width:15px; height:15px; ">~</caption>
						<input id="ipt_frdate1" ref="/root/main/date/day/frdate" class="input_s_essential" navindex="2" inputtype="date" format="yyyy-mm-dd" style="left:102px; top:2px; width:100px; height:19px; "/>
						<input id="ipt_todate1" ref="/root/main/date/day/todate" class="input_s_essential" navindex="3" inputtype="date" format="yyyy-mm-dd" style="left:214px; top:2px; width:101px; height:19px; "/>
					</case>
					<case id="case_monthparams">
						<caption id="caption3" class="search_name" style="left:12px; top:3px; width:86px; height:17px; ">기     간 :</caption>
						<caption id="caption8" style="left:203px; top:4px; width:15px; height:15px; ">~</caption>
						<input id="ipt_frdate2" ref="/root/main/date/month/frdate" class="input_s_essential" navindex="2" inputtype="date" format="yyyy-mm" style="left:102px; top:2px; width:100px; height:19px; "/>
						<input id="ipt_todate2" ref="/root/main/date/month/todate" class="input_s_essential" navindex="3" inputtype="date" format="yyyy-mm" style="left:214px; top:2px; width:101px; height:19px; "/>
					</case>
				</switch>
				<button id="btn_search" class="btn1_letter2" navindex="5" style="left:1125px; top:17px; 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" appearance="minimal" style="left:445px; top:34px; 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>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									model.setValue("/root/send/params/fracntcd", "");								
									model.setValue("/root/send/params/fracntnm", "");
									model.setValue("/root/send/params/toacntcd", "");
									model.setValue("/root/send/params/toacntnm", "");
									model.refresh();								
								]]>
					</script>
				</select1>
				<button id="btn_toacnthelp2" class="icon_search" style="left:596px; top:34px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
					
									misfOpenPopUpList("05", ipt_fracntcd, "", "toacntcd,toacntnm", "cmb_acntclsflag", "acntclsflag");	
									model.refresh();

								]]>
					</script>
				</button>
				<button id="btn_fracnthelp2" class="icon_search" style="left:596px; top:10px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
								
									misfOpenPopUpList("05", ipt_fracntcd, "", "fracntcd,fracntnm", "cmb_acntclsflag", "acntclsflag");	
									model.refresh();

								]]>
					</script>
				</button>
				<input id="ipt_fracntcd" ref="/root/send/params/fracntcd" class="input_s_essential" navindex="4" style="left:517px; top:10px; 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", "fracntcd,fracntnm", "", "", "cmb_acntclsflag", "acntclsflag");

								]]>
					</script>
				</input>
				<caption id="caption28" class="search_name" style="left:425px; top:10px; width:90px; height:17px; ">계정과목 :</caption>
				<input id="ipt_toacntcd" ref="/root/send/params/toacntcd" class="input_s_essential" navindex="6" style="left:517px; top:34px; 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", "toacntcd,toacntnm", "", "", "cmb_acntclsflag", "acntclsflag");

								]]>
					</script>
				</input>
				<input id="ipt_fracntnm" ref="/root/send/params/fracntnm" class="input_s_essential" navindex="5" style="left:614px; top:10px; 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", "fracntcd,fracntnm", "", "", "cmb_acntclsflag", "acntclsflag");

								]]>
					</script>
				</input>
				<input id="ipt_toacntnm" ref="/root/send/params/toacntnm" class="input_s_essential" navindex="7" style="left:614px; top:34px; 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", "toacntcd,toacntnm", "", "", "cmb_acntclsflag", "acntclsflag");

								]]>
					</script>
				</input>
			</group>
			<switch id="sw_grid" class="sw_box" style="left:0px; top:95px; width:1195px; height:644px; border-style:solid; ">
				<case id="case_grddaypr" selected="true">
					<caption id="caption21" class="tit_2" style="left:5px; top:10px; width:131px; height:14px; ">일별</caption>
					<line id="line3" class="line_1" style="x1:0px; y1:25px; x2:1193px; y2:25px; "/>
					<button id="btn_excel" class="btn2_letter4" style="left:1123px; top:4px; width:64px; height:19px; text-align:left; ">
						<caption>엑셀출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

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

							]]>
						</script>
					</button>
					<datagrid id="grd_daypr" nodeset="/root/main/tacnt/day/totalacntlist" backcoloralternate="#ffffff" caption="계정코드^계정과목^순번^날짜^날짜^날짜^차변^대변^잔액^잔액^구분" colsep="^" colwidth="110, 210, 0, 160, 0, 160, 215, 215, 0, 215, 0" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:30px; width:1193px; height:610px; ">
						<col class="text_center" ref="supacntcd4"/>
						<col class="text_center" ref="supacntnm4"/>
						<col ref="supseq" visibility="hidden"/>
						<col class="text_center" ref="ymdd"/>
						<col ref="yyyymm" visibility="hidden"/>
						<col ref="apsldt" visibility="hidden"/>
						<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="balsum" format="(-)#,###" savetype="digit" style="text-align:right; "/>
						<col ref="gubn" visibility="hidden"/>
					</datagrid>
					<datagrid id="grd_excel1" nodeset="/root/main/tacnt/day/totalacntlist" visibility="hidden" backcoloralternate="#ffffff" caption="계정코드^계정과목^날짜^차변^대변^잔액" colsep="^" colwidth="110, 210, 160, 215, 215, 215" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:350px; top:425px; width:703px; height:152px; ">
						<col class="text_center" ref="supacntcd4"/>
						<col class="text_center" ref="supacntnm4"/>
						<col class="text_center" ref="ymdd"/>
						<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="balsum" format="(-)#,###" savetype="digit" style="text-align:right; "/>
					</datagrid>
				</case>
				<case id="case_grdmonthpr">
					<caption id="caption9" class="tit_2" style="left:5px; top:10px; width:131px; height:14px; ">월별</caption>
					<line id="line1" class="line_1" style="x1:0px; y1:25px; x2:1193px; y2:25px; "/>
					<button id="button6" class="btn2_letter4" style="left:1124px; top:4px; width:64px; height:19px; text-align:left; ">
						<caption>엑셀출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

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

							]]>
						</script>
					</button>
					<datagrid id="grd_monthpr" nodeset="/root/main/tacnt/month/totalacntlist" caption="계정코드^계정과목^순번^회계년도^날짜^차변^대변^잔액^잔액^구분" colsep="^" colwidth="110, 210, 0, 0, 160, 215, 215, 0, 215, 0" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:30px; width:1193px; height:612px; ">
						<col class="text_center" ref="supacntcd4"/>
						<col class="text_center" ref="supacntnm4"/>
						<col ref="supseq" visibility="hidden"/>
						<col ref="acntyy" visibility="hidden"/>
						<col class="text_center" ref="ymdd"/>
						<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="balsum" format="(-)#,###" savetype="digit" style="text-align:right; "/>
						<col ref="gubn" visibility="hidden"/>
					</datagrid>
					<datagrid id="grd_excel2" nodeset="/root/main/tacnt/month/totalacntlist" visibility="hidden" caption="계정코드^계정과목^날짜^차변^대변^잔액" colsep="^" colwidth="100, 200, 160, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:210px; top:175px; width:800px; height:90px; ">
						<col class="text_center" ref="supacntcd4"/>
						<col class="text_center" ref="supacntnm4"/>
						<col class="text_center" ref="ymdd"/>
						<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="balsum" format="(-)#,###" savetype="digit" style="text-align:right; "/>
					</datagrid>
				</case>
			</switch>
			<button id="btn_daypr" class="btn_sw" group="tab" selected="true" style="left:0px; top:74px; width:36; height:22px; ">
				<caption>일별</caption>
				<toggle case="case_grddaypr" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						sw_date.selectedIndex = 0;

						model.setValue("/root/send/params/retrflag", "day");
						model.setFocus("ipt_fracntcd");

					]]>
				</script>
			</button>
			<button id="btn_monthpr" class="btn_sw" group="tab" style="left:36px; top:74px; width:36px; height:22px; ">
				<caption>월별</caption>
				<toggle case="case_grdmonthpr" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						sw_date.selectedIndex = 1;
						model.setValue("/root/send/params/retrflag", "month");
						model.setFocus("ipt_fracntcd");

					]]>
				</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" style="left:0px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						var vRetrflag = model.getValue("/root/send/params/retrflag");
					
						model.setValue("/root/send/retrparams/instnm", 	cmb_instcd.label);
						model.setValue("/root/send/retrparams/retrflag", 	vRetrflag);	
						model.setValue("/root/send/retrparams/fracntcd", 	ipt_fracntcd.value);
						model.setValue("/root/send/retrparams/fracntnm", 	ipt_fracntnm.value);	
						model.setValue("/root/send/retrparams/toacntcd", 	ipt_toacntcd.value);
						model.setValue("/root/send/retrparams/toacntnm", 	ipt_toacntnm.value);						
					
						if(vRetrflag == "day")
						{
							grd_daypr.gridToInstance();
						
							if(grd_daypr.rows == grd_daypr.fixedRows)
							{
								messageBox("출력할 내용이" ,"I004");
								return;
							}				
						
							model.setValue("/root/send/retrparams/frdate", 	ipt_frdate1.value);
							model.setValue("/root/send/retrparams/todate", 	ipt_todate1.value);
							
							model.removeNodeset("/root/send/prntlist/gridlist");						
							model.copyNode("/root/send/prntlist", "/root/main/tacnt/day");
						}
						else
						{
							grd_monthpr.gridToInstance();
						
							if(grd_monthpr.rows == grd_monthpr.fixedRows)
							{
								messageBox("출력할 내용이" ,"I004");
								return;
							}				
						
							model.setValue("/root/send/retrparams/frdate", 	ipt_frdate2.value);
							model.setValue("/root/send/retrparams/todate", 	ipt_todate2.value);	
						
							model.removeNodeset("/root/send/prntlist/gridlist");						
							model.copyNode("/root/send/prntlist", "/root/main/tacnt/month");
						}
						
						exeReportPreview("RPRAD00601", "XMLSTR", "/root/send/retrparams");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>