YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT07300_사회사업연구및교육실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT07300.사회사업연구및교육실적.xrw
	* 설    명   : 사회사업연구및교육실적
	* 작 성 자  : 임여원
	* 작 성 일  : 2008.11.17
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<brgstincmexpspres>
							<brgstincmexpsprescond>
								<cond/>
								<b02cnt/>
								<b02/>
								<b06cnt/>
								<b06/>
								<a05cnt/>
								<a05/>
								<a06cnt/>
								<a06/>
								<a04cnt/>
								<a04/>
								<a02cnt/>
								<a02/>
								<a03cnt/>
								<a03/>
								<cnttotal/>
								<amttotal/>
								<lstachivcnt/>
								<lstachivamt/>
								<lstachivcntcomp/>
								<lstachivamtcomp/>
							</brgstincmexpsprescond>
						</brgstincmexpspres>
						<search>
							<reqflag>1</reqflag>
							<fromdd/>
							<todd/>
						</search>
					</main>
					<send>
						<reqdata/>
					</send>
					<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"/>
			<submission id="TRSDT07301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/brgstincmexpspres"/>
			<bind id="lstachivcntcomp" ref="/root/main/brgstincmexpspres/brgstincmexpsprescond/lstachivcntcomp" calculate="../cnttotal  - ../lstachivcnt"/>
			<bind id="lstachivamtcomp" ref="/root/main/brgstincmexpspres/brgstincmexpsprescond/lstachivamtcomp" calculate="../amttotal  - ../lstachivamt"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit()
				{
					//cmb_reqflag.select(0);
					caption1.visible=true;
					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);
					model.makeValue("/root/main/search/todd",LastDateYM);
					
					grd_brgstincmexpsprescond.colHidden(17)=true;
					grd_brgstincmexpsprescond.colHidden(18)=true;
					grd_brgstincmexpsprescond.colHidden(19)=true;
					grd_brgstincmexpsprescond.colHidden(20)=true;
					//grd_brgstincmexpsprescond.colWidth(15)=150;
					//grd_brgstincmexpsprescond.colHidden(21)=true;
					//grd_brgstincmexpsprescond.colHidden(22)=true;
										
					//grd_brgstincmexpsprescond.visible=true;
					//grd_brgstincmexpsprescond2.visible=false;
					
					
					model.refresh();
					
					
					
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fReqBrgstIncmExpsCond()
				{
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					
					var fromdd=model.getValue("/root/main/search/fromdd");
					var todd=model.getValue("/root/main/search/todd");
					var reqflag=model.getValue("/root/main/search/reqflag");
					
					//var fromdd=fdate.substr(4,2);
					//var todd=todate.substr(4,2);
					//var fromendyy=fdate.substr(0,4);
					//var toendyy=todate.substr(0,4);
					
					//alert(todd.substring(6,2));
					model.makeValue("/root/send/reqdata/fromdd",fromdd);
					model.makeValue("/root/send/reqdata/todd",todd);
					model.makeValue("/root/send/reqdata/reqflag",reqflag);
					
						if(isNull(fromdd))
						{
							messageBox("조회시작일자는","I003");
							model.setFocus("ipt_fromdd");
							return;
						}
						if(isNull(todd))
						{
							messageBox("조회종료일자는","I003");
							model.setFocus("ipt_todd");
							return;
						}
						var dateintval=getDateInterval(fromdd+"01",todd+"31");
						
						if(fromdd>todd)
						{
							messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
							model.setFocus("ipt_todd");
							return;
						}
						
						if(dateintval>"370")
						{
							messageBox("조회기간은 최대 1년까지 할 수 있습니다","I");
							model.setFocus("ipt_fromdd");
							return;
						}
						
					submit("TRSDT07301");
					
					var idxRow=grd_brgstincmexpsprescond.rows;
					var fixRow=grd_brgstincmexpsprescond.fixedRows;
					var reqflag=model.getValue("/root/main/search/reqflag");
					
					for(i=1;i<=idxRow-fixRow;i++)
					{
						var cond=model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond"+"["+i+"]/cond");
						

							if(cond=='전기간실적'&&i=='1')
							{
									//grd_brgstincmexpsprescond.removeRow(false);
									model.removeNodeset("/root/main/brgstincmexpspres/brgstincmexpsprescond");
								
							}
							else
							{
								if(reqflag=='2')
								{
									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("b02cnt"); i<= grd_brgstincmexpsprescond.colRef("amttotal"); 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);								      
							//alert("sSum "+ sSum +"bfResult " + bfResult + "sStat " + sStat);					
						}	                                                                                  
															                                                  
						grd_brgstincmexpsprescond.valueMatrix(insRow-1, grd_brgstincmexpsprescond.colRef("lstachivcnt")) = "";                        
						grd_brgstincmexpsprescond.valueMatrix(insRow-1, grd_brgstincmexpsprescond.colRef("lstachivcntcomp")) = "";	                  
						grd_brgstincmexpsprescond.valueMatrix(insRow, grd_brgstincmexpsprescond.colRef("lstachivcntcomp")) = "";	
						
						grd_brgstincmexpsprescond.valueMatrix(insRow-1, grd_brgstincmexpsprescond.colRef("lstachivamt")) = "";                        
						grd_brgstincmexpsprescond.valueMatrix(insRow-1, grd_brgstincmexpsprescond.colRef("lstachivamtcomp")) = "";	                  
						grd_brgstincmexpsprescond.valueMatrix(insRow, grd_brgstincmexpsprescond.colRef("lstachivamtcomp")) = "";                  
																                                              
					}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:409px; 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-mm" style="left:332px; top:8px; width:73px; height:19px; "/>
				<input id="ipt_todd" ref="/root/main/search/todd" class="input_search" navindex="3" inputtype="date" format="yyyy-mm" style="left:445px; top:8px; width:73px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:240px; top:10px; width:100px; height:17px; ">조회기간 :</caption>
				<select1 id="cmb_reqflag" ref="/root/main/search/reqflag" navindex="1" appearance="minimal" style="left:110px; 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[
									model.removeNodeset("/root/send/reqdata");
									model.makeNode("/root/send/reqdata");
									
									if(cmb_reqflag.value=='1')
									{
										//grd_brgstincmexpsprescond.colWidth(1)=150;
										grd_brgstincmexpsprescond.colHidden(17)=true;
										grd_brgstincmexpsprescond.colHidden(18)=true;
										grd_brgstincmexpsprescond.colHidden(19)=true;
										grd_brgstincmexpsprescond.colHidden(20)=true;
										
										
										//grd_brgstincmexpsprescond.colWidth(15)=100;
										
										
									}
									else
									{
										//grd_brgstincmexpsprescond.colWidth(15)=46;
										grd_brgstincmexpsprescond.colHidden(17)=false;
										grd_brgstincmexpsprescond.colHidden(18)=false;
										grd_brgstincmexpsprescond.colHidden(19)=false;
										grd_brgstincmexpsprescond.colHidden(20)=false;
									}
									
									model.refresh();
									fReqBrgstIncmExpsCond(); //조회함수 
						
						]]>
					</script>
				</select1>
			</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" bind="bind_grd_brgstincmexpsprescond" nodeset="/root/main/brgstincmexpspres/brgstincmexpsprescond" class="datagrid2" caption="구분^사회사업사례집담회^사회사업사례집담회^사회사업연구조사활동^사회사업연구조사활동^사회사업실습교육^사회사업실습교육^사회사업수련교육^사회사업수련교육^사회사업자체교육^사회사업자체교육^사회사업원내교육^사회사업원내교육^사회사업원외교육^사회사업원외교육^연구및교육합계^연구및교육합계^전월실적^전월실적^전월대비실적비교^전월대비실적비교^장소^장소명^장소^담당자|구분^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^횟수^인원^장소^장소명^장소^담당자" colsep="^" colwidth="132, 58, 58, 63, 63, 52, 53, 52, 52, 52, 52, 52, 52, 52, 52, 46, 46, 47, 47, 53, 53" dataheight="25" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:0px; top:76px; width:1190px; height:664px; ">
				<col ref="cond" style="text-align:center; "/>
				<col ref="b02cnt" style="text-align:center; "/>
				<col ref="b02" style="text-align:center; "/>
				<col ref="b06cnt" style="text-align:center; "/>
				<col ref="b06" style="text-align:center; "/>
				<col ref="a05cnt" style="text-align:center; "/>
				<col ref="a05" style="text-align:center; "/>
				<col ref="a06cnt" style="text-align:center; "/>
				<col ref="a06" style="text-align:center; "/>
				<col ref="a04cnt" style="text-align:center; "/>
				<col ref="a04" style="text-align:center; "/>
				<col ref="a02cnt" style="text-align:center; "/>
				<col ref="a02" style="text-align:center; "/>
				<col ref="a03cnt" style="text-align:center; "/>
				<col ref="a03" style="text-align:center; "/>
				<col ref="cnttotal" style="text-align:center; "/>
				<col ref="amttotal" style="text-align:center; "/>
				<col ref="lstachivcnt" style="text-align:center; "/>
				<col ref="lstachivamt" style="text-align:center; "/>
				<col ref="lstachivcntcomp" style="text-align:center; "/>
				<col ref="lstachivamtcomp" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>