YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT06300_사회사업자선회수입금지출금현황.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT06300.사회사업자선회수입금지출금현황.xrw
	* 설    명   : 사회사업자선회수입금지출금현황
	* 작 성 자  : 임여원
	* 작 성 일  : 2008.11.17
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<brgstincmexpspres>
							<brgstincmexpsprescond>
								<inextype/>
								<cdid/>
								<cdnm/>
								<amt01/>
								<amt02/>
								<amt03/>
								<amt04/>
								<amt05/>
								<amt06/>
								<amt07/>
								<amt08/>
								<amt09/>
								<amt10/>
								<amt11/>
								<amt12/>
								<amt13/>
								<cdgrupid/>
							</brgstincmexpsprescond>
						</brgstincmexpspres>
						<search>
							<reqflag>1</reqflag>
							<fromdd/>
							<reqflag2/>
							<reqincm/>
							<reqexps/>
							<fromentryy/>
							<toentryy/>
						</search>
					</main>
					<send>
						<reqdata/>
					</send>
					<init>
						<incm>
						</incm>
						<exps>
						</exps>
					</init>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../ast/commonweb/js/AST.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[					
						fInit();		
						
						
									
				]]>
			</script>
			<submission id="TRSDT04002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
			<bind id="bfreqcntconsult" ref="/root/main/cnstinfo/cnstlist/bfreqcntconsult" calculate="../reqtot -    ../bfreqcnt"/>
			<bind id="bfreplcntreply" ref="/root/main/cnstinfo/cnstlist/bfreplcntreply" calculate="../repltot -    ../bfreplcnt"/>
			<submission id="TRSDT06301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/brgstincmexpspres"/>
			<submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit()
				{
					//cmb_reqflag.select(0);
					ipt_fromentryy.visible=false;
					ipt_toentryy.visible=false;
					cap1.visible=false;
					caption1.visible=true;
					caption2.visible=false;

					cmb_reqincm.visible=false;
					cmb_reqexps.visible=false;
					caption4.visible=false;
					caption5.visible=false;
					zbcfGetCodeList(new Array("A0639", "A0640"), new Array("/root/init/incm", "/root/init/exps"));

					model.removeNodeset("/root/main/brgstincmexpspres");
					
					var CurrentDate=getCurrentDate();
					var CurrentDateYM=CurrentDate.substr(0,6);
					var LastDate=CurrentDate.toDate().getAddDate(-1,"M").getDateFormat();
					var LastDateYM=LastDate.substr(0,6);
					model.makeValue("/root/main/search/fromdd",LastDateYM);
					var CurrentDateYY=CurrentDate.substring(0,4);
					model.makeValue("/root/main/search/fromentryy",CurrentDateYY);
					model.makeValue("/root/main/search/toentryy",CurrentDateYY);
					
					model.refresh();
					addComboItem("cmb_reqincm", "전체", "", "above");
					addComboItem("cmb_reqexps", "전체", "", "above");
//					cmb_reqincm.select(0);
					
					
					
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fReqBrgstIncmExpsCond()
				{
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					
					var fdate=model.getValue("/root/main/search/fromdd");
					var reqflag=model.getValue("/root/main/search/reqflag");
					var fromentryy=model.getValue("/root/main/search/fromentryy");
					var toentryy=model.getValue("/root/main/search/toentryy");
	
					var fromdd=fdate.substr(0,4);
					
					//alert(todd.substring(6,2));
					model.makeValue("/root/send/reqdata/fromdd",fromdd);
					model.makeValue("/root/send/reqdata/reqflag",reqflag);
					model.makeValue("/root/send/reqdata/fromentryy",fromentryy);
					model.makeValue("/root/send/reqdata/toentryy",toentryy);

					model.makeValue("/root/send/reqdata/reqflag2",model.getValue("/root/main/search/reqflag2"));
					model.makeValue("/root/send/reqdata/reqincm",model.getValue("/root/main/search/reqincm"));
					model.makeValue("/root/send/reqdata/reqexps",model.getValue("/root/main/search/reqexps"));
					
					//alert(reqflag);
				
					if(reqflag=='1')
					{
						if(isNull(fromdd))
						{
							messageBox("조회시작일자는","I003");
							model.setFocus("ipt_fromdd");
							return;
						}
					}
					else
					{
						if(isNull(fromentryy))
						{
							messageBox("조회시작연도는","I003");
							model.setFocus("ipt_fromentryy");
							return;
						}
						if(isNull(toentryy))
						{
							messageBox("조회종료연도는","I003");
							model.setFocus("ipt_toentryy");
							return;
						}
						if(fromentryy>toentryy)
						{
							messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
							model.setFocus("ipt_fromentryy");
							return;
						}
						var dateintval=getDateInterval(fromentryy+"0101",toentryy+"1231");
						if(dateintval>"1980")
						{
							messageBox("조회기간은 최대 5년까지 할 수 있습니다","I");
							model.setFocus("ipt_fromdd");
							return;
						}
					}
					
					
				
					// 조회종료일자와 조회시작일자사이의 길이, 월별일 때는 1년, 년도별 5년으로 제약 
					//model.makeValue("");
					//model.makeValue("");
					//model.makeValue("");
					
					//model.copyNode("/root/send/reqdata","/root/main/search");
					submit("TRSDT06301");

					var arrCol = ["inextype", "cdid", "cdnm", "amt01", "amt02", "amt03", "amt04", "amt05", "amt06", "amt07", "amt08"
										, "amt09", "amt10", "amt11", "amt12", "amt13", "cdgrupid"];

					for ( var nCnt = arrCol.length - 1; nCnt > -1; nCnt-- ) {
						if ( model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond/" + arrCol[nCnt]) == "" ||
								nCnt == 1 || nCnt == 16)
							grd_brgstincmexpsprescond.colHidden(nCnt) = true;
						else
							grd_brgstincmexpsprescond.colHidden(nCnt) = false;
					}

					if ( cmb_reqflag.value == "2" ) {
						var str = "구분^구분코드^구분";
						for ( var nCnt = 3; nCnt < arrCol.length - 2; nCnt++ ) 
							str += "^"+ (parseInt(ipt_fromentryy.value.substring(0,4)) + nCnt - 3) + "년";
						grd_brgstincmexpsprescond.caption = str + "^합계^구분그룹코드";
					} else
						grd_brgstincmexpsprescond.caption = 
								"구분^구분코드^구분^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^구분그룹코드";

					for ( var nCnt = 0; nCnt < arrCol.length; nCnt++ ) {
						grd_brgstincmexpsprescond.mergeCol(nCnt) = (nCnt == 0 ? true : false);
					}
					grd_brgstincmexpsprescond.mergeCells = "bycol";
					
					var idxRow=grd_brgstincmexpsprescond.rows;
					var fixRow=grd_brgstincmexpsprescond.fixedRows;
					
//					for(i=1;i<=idxRow-fixRow;i++)
//					{
//						var cond=model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond"+"["+i+"]/cond");
//
//						if(cond=='전기간실적'&&i=='1')
//						{
//							model.removeNodeset("/root/main/brgstincmexpspres/brgstincmexpsprescond");
//							//grd_brgstincmexpsprescond.removeRow(false);
//						}
//						else
//						{
//							if(reqflag=='1')
//							{
//								fGetBfResult();
//								return;
//							}	
//						}		
//					}
					model.refresh();
				}
				
/**========================================================================================================================================                 
  * 전년실적                                                                                                                                                  
  =========================================================================================================================================*/					
                                                                                                                                                              
  				                                                                                                                                             
  					function fGetBfResult(){	                                                                                                             
  					if(grd_brgstincmexpsprescond.rows - grd_brgstincmexpsprescond.fixedRows >1){                                                             
  						var sStat = 0;                                                                                                                       
  						var insRow = grd_brgstincmexpsprescond.rows;                                                                                         
  						grd_brgstincmexpsprescond.addRow(insRow, false);                                                                                     
  						grd_brgstincmexpsprescond.valueMatrix(insRow, grd_brgstincmexpsprescond.colRef("cond") ) = "전기간대비실적비교";                    
  							                                                                                                                                 
  						for(var i= grd_brgstincmexpsprescond.colRef("incmcnt"); i<= grd_brgstincmexpsprescond.colRef("expsamtcomp"); i++)                               
  						{                                                                                                                                    
  							var bfResult = eval(grd_brgstincmexpsprescond.valueMatrix(insRow -1 , i));							                             
  							var sSum = eval(grd_brgstincmexpsprescond.valueMatrix(insRow-2, i));		                                                     
  																											                                                 
  							sStat = eval(sSum)- eval(bfResult) ;							                                                                 
  							grd_brgstincmexpsprescond.valueMatrix(insRow, i ) = eval(sStat);								                                 				                                             
  						}	                                                                                                                                 
  															                                                                                                                       
  																                                                                                             
  					}else{						                                                                                                             
  						model.removeNodeset("/root/main/brgstincmexpspres/brgstincmexpsprescond");						                                     
  					}                                                                                                                                        
  					model.refresh();                                                                                                                         
  				}                                                                                                                                            
                   

/**========================================================================================================================================
* 초기화 
=========================================================================================================================================*/					
				function fResetBrgstIncmExps()
				{
					model.removeNodeset("/root/main/brgstincmexpspres");
					model.refresh();
				}

/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/					
				function fExcel() {
					if (grd_brgstincmexpsprescond.rows <= 2) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "자선회수입금지출금현황", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_brgstincmexpsprescond.saveExcel(fileName, "SheetName", false, false, "", "", false);
					}
				}
				
					
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;1,1191;" 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>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:757px; width:1195px; height:27px; ">
			<line id="line37" class="line_6" style="x1:0px; y1:0px; x2:1194px; y2:0px; "/>
			<button id="btn_search0" class="btn4_letter3" style="left:1126px; top:5px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							fResetBrgstIncmExps();
					]]>
				</script>
			</button>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<caption id="caption21" class="tit_2" style="left:0px; top:55px; width:232px; height:14px; ">사회사업 자선회수입금지출금 현황</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:73px; x2:1190px; y2:72px; "/>
			<group id="group4" style="left:0px; top:5px; width:1194px; height:35px; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<button id="button2" class="btn1_letter2" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
								fReqBrgstIncmExpsCond();					
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:15px; top:10px; width:86px; height:17px; ">조회구분 :</caption>
				<line id="line2" style="x1:1113px; y1:7px; x2:1113px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="cap1" style="left:374px; top:8px; width:25px; height:20px; text-align:center; ">~</caption>
				<input id="ipt_fromdd" ref="/root/main/search/fromdd" class="input_search" navindex="2" inputtype="date" format="yyyy" style="left:297px; top:8px; width:58px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:210px; top:10px; width:100px; height:17px; ">조회년도 :</caption>
				<select1 id="cmb_reqflag" ref="/root/main/search/reqflag" navindex="1" appearance="minimal" style="left:105px; top:10px; width:85px; height:19px; ">
					<choices>
						<item>
							<label>월별</label>
							<value>1</value>
						</item>
						<item>
							<label>년도별</label>
							<value>2</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									var CurrentDate=getCurrentDate();
									if(cmb_reqflag.value=='1')
									{
										ipt_fromdd.visible=true;
										ipt_fromentryy.visible=false;
										ipt_toentryy.visible=false;
										cap1.visible=false;
										caption1.visible=true;
										caption2.visible=false;
										
										model.removeNodeset("/root/send/reqdata/entryy");

									}
									else
									{
										ipt_fromdd.visible=false;
										ipt_fromentryy.visible=true;
										ipt_toentryy.visible=true;
										cap1.visible=true;
										caption1.visible=false;
										caption2.visible=true;
										
										
										model.removeNodeset("/root/send/reqdata/fromdd");
										//model.removeNodeset("");
									}
									model.removeNodeset("/root/send/reqdata");
									model.makeNode("/root/send/reqdata");
									model.refresh();
									fReqBrgstIncmExpsCond(); //조회 
						
						]]>
					</script>
				</select1>
				<input id="ipt_fromentryy" ref="/root/main/search/fromentryy" class="input_search" navindex="2" inputtype="date" format="yyyy" style="left:312px; top:8px; width:58px; height:19px; "/>
				<caption id="caption2" class="search_name" style="left:209px; top:10px; width:100px; height:17px; ">조회기간:</caption>
				<input id="ipt_toentryy" ref="/root/main/search/toentryy" class="input_search" navindex="2" inputtype="date" format="yyyy" style="left:404px; top:8px; width:58px; height:19px; "/>
				<caption id="caption3" class="search_name" style="left:510px; top:10px; width:96px; height:17px; ">수입/지출 :</caption>
				<select1 id="cmb_reqflag2" ref="/root/main/search/reqflag2" navindex="1" appearance="minimal" style="left:610px; top:10px; width:85px; height:19px; ">
					<choices>
						<item>
							<label>전체</label>
							<value/>
						</item>
						<item>
							<label>수입</label>
							<value>I</value>
						</item>
						<item>
							<label>지출</label>
							<value>O</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									if(cmb_reqflag2.value=='I')
									{
										cmb_reqincm.visible=true;
										cmb_reqexps.visible=false;
										caption4.visible=true;
										caption5.visible=false;
										cmb_reqincm.select(0);
									}
									else if (cmb_reqflag2.value=='O')
									{
										cmb_reqincm.visible=false;
										cmb_reqexps.visible=true;
										caption4.visible=false;
										caption5.visible=true;
										cmb_reqexps.select(0);
									}
									else
									{
										cmb_reqincm.visible=false;
										cmb_reqexps.visible=false;
										caption4.visible=false;
										caption5.visible=false;
									}
						]]>
					</script>
				</select1>
				<select1 id="cmb_reqincm" ref="/root/main/search/reqincm" navindex="1" appearance="minimal" style="left:800px; top:10px; width:85px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/incm/A0639">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption4" class="search_name" style="left:710px; top:10px; width:91px; height:17px; ">입금구분 :</caption>
				<select1 id="cmb_reqexps" ref="/root/main/search/reqexps" navindex="1" appearance="minimal" style="left:800px; top:10px; width:85px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/exps/A0640">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption5" class="search_name" style="left:710px; top:10px; width:91px; height:17px; ">출금구분 :</caption>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:1126px; top:50px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExcel();
					]]>
				</script>
			</button>
			<datagrid id="grd_brgstincmexpsprescond" nodeset="/root/main/brgstincmexpspres/brgstincmexpsprescond" class="datagrid2" caption="구분^구분코드^구분^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^구분그룹코드" colsep="^" colwidth="40, 100, 150, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" dataheight="25" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; ">
				<col ref="inextype" style="text-align:center; "/>
				<col ref="cdid" visibility="hidden" style="text-align:center; "/>
				<col ref="cdnm" style="text-align:left; "/>
				<col ref="amt01" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt02" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt03" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt04" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt05" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt06" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt07" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt08" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt09" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt10" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt11" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt12" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt13" format="(-)#,###" style="text-align:right; "/>
				<col ref="cdgrupid" visibility="hidden" format="(-)#,###" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>