YNU_JEUS/app_home/himed/webapps/ast/voluntractweb/xrw/SMAAA03600_자원봉사자소속팀별통계.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>
						<search>
							<fromdd/>
							<todd/>
							<actdeptcd/>
						</search>
						<voluntractteam>
							<voluntractteaminfo>
								<actdeptcd/>
								<voluntractdwcd/>
								<voluntractteamcd/>
								<cnt/>
								<attdabsnflag/>
								<servtm/>
								<total/>
							</voluntractteaminfo>
						</voluntractteam>
					</main>
					<init>
						<vacatflagcd>
						</vacatflagcd>
						<actdeptcd/>
						<voluntractteamcd/>
					</init>
					<send>
						<reqdata/>
					</send>
					<hidden>
						<init>
							<comcd/>
						</init>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//grd_studvoluntrlist.fixedcellcheckbox(0,1) = "true";
					fInit();
				]]>
			</script>
			<submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRZBC00102" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRZBP00102" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRAAA03601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/voluntractteam"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
	</xhtml:head>
	<script type="javascript">
		<![CDATA[
		//초기화
		function fInit() {
			
			zbcfGetCodeList(new Array("A0503","A0359","A0360"),new Array("/root/hidden/init/comcd","/root/hidden/init/comcd","/root/hidden/init/comcd"));
			
			var CurrentDate=getCurrentDate();
			var currentYM=CurrentDate.substr(0,6);
			
			model.makeValue("/root/main/search/fromdd","200801");
			model.makeValue("/root/main/search/todd",currentYM);
			addComboItem("cmb_actdeptcd","","","above");
			
			model.removeNodeset("/root/main/voluntractteam");
			model.refresh();
			
	
		}
		//통계조회 
		function fVoluntrStatReq()
		{
			var fromdd=model.getValue("/root/main/search/fromdd");
			var todd=model.getValue("/root/main/search/todd");
			var actdeptcd=model.getValue("/root/main/search/actdeptcd");
			
			model.removeNodeset("/root/send/reqdata");
			model.makeNode("/root/send/reqdata");
			
			if(isNull(fromdd))
			{
				messageBox("조회시작일은","I003");
				model.setFocus("ipt_fromdd");
				return;
			}
			else
			{
				model.makeValue("/root/send/reqdata/fromdd",fromdd);
			}
			if(isNull(todd))
			{
				messageBox("조회종료일은","I003");
				model.setFocus("ipt_todd");
				return;
			}
			else
			{
				model.makeValue("/root/send/reqdata/todd",todd);
			}
			if(isNull(actdeptcd))
			{
				model.makeValue("/root/send/reqdata/actdeptcd","%");
			}
			else
			{
				model.makeValue("/root/send/reqdata/actdeptcd",actdeptcd);
			}
			
			//model.copyNode("/root/send/reqdata","/root/main/search");
			
			submit("TRAAA03601");
		
			var idxRows=grd_voluntractteaminfo.rows;
			
			if(idxRows!='0')
			{
				for(i=1;i<idxRows;i++)
				{
					
						//grd_voluntractteaminfo.cellStyle("background-color",3,2, 3, 5) = "#ccffcc";   
					var actdeptcd=model.getValue("/root/main/voluntractteam/voluntractteaminfo"+"["+i+"]/actdeptcd");
					var voluntractdwcd=model.getValue("/root/main/voluntractteam/voluntractteaminfo"+"["+i+"]/voluntractdwcd");
					if(voluntractdwcd=="소계")
					{
						//alert(i);
						grd_voluntractteaminfo.cellStyle("background-color",i+1,2, i+1, 5) = "#ccffcc";    

					}
					else if(actdeptcd=="합계")
					{
						//alert("합계"+i);
						grd_voluntractteaminfo.cellStyle("background-color",i+1,1, i+1, 5) = "#ccffff";     
					}
					else
					{
						grd_voluntractteaminfo.cellStyle("background-color",i+1,0, i+1, 5) = "#ffffff";   
					}
				}
			}
			
			model.refresh();
			
			
		}
		// 초기화 함수 
		function fResetVoluntrActTeam()
		{
			var btn=messageBox("초기화를","Q004");
			if(btn=="6")
			{
				model.removeNodeset("/root/main/voluntractteam");
				
			}
			else
			{
				return;
			}
			model.refresh();
		}
		// 엑셀 저장 함수 
		function fExcelVoluntrTeamStat()
		{
			var fileName=window.fileDialog("save",",",false,"excel","xls","Excel Files(*.xls)|*.xls|All Files(*.*)|*.*");
			
			if(fileName!="")
			{
				grd_voluntractteaminfo.saveExcel(fileName,"SheetName",false,false,"","",false);
				
			}
		}
		
		
		]]>
	</script>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:815px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:207px; height:14px; ">자원봉사자통계</caption>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:825px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:820px; height:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:820px; height:35px; "/>
				<button id="button1" class="btn1_letter2" style="left:753px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[						
							fVoluntrStatReq();										
						]]>
					</script>
				</button>
				<line id="line13" class="line_4" style="x1:742px; y1:7px; x2:742px; y2:29px; "/>
				<caption id="caption3" class="search_name" style="left:20px; top:10px; width:94px; height:17px; ">조회기간 :</caption>
				<input id="ipt_fromdd" ref="/root/main/search/fromdd" class="input_default" inputtype="date" format="yyyy-mm" appearance="minimal" style="left:114px; top:9px; width:71px; height:19px; "/>
				<input id="ipt_todd" ref="/root/main/search/todd" class="input_default" inputtype="date" format="yyyy-mm" appearance="minimal" style="left:202px; top:9px; width:71px; height:19px; "/>
				<caption id="caption4" style="left:188px; top:10px; width:20px; height:20px; ">~</caption>
				<caption id="caption2" class="search_name" style="left:325px; top:10px; width:94px; height:17px; ">활동그룹 :</caption>
				<select1 id="cmb_actdeptcd" ref="/root/main/search/actdeptcd" appearance="minimal" style="left:420px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0503">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									fVoluntrStatReq();				
						]]>
					</script>
				</select1>
			</group>
			<button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:748px; top:51px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[																
						fExcelVoluntrTeamStat();						
					]]>
				</script>
			</button>
			<datagrid id="grd_voluntractteaminfo" nodeset="/root/main/voluntractteam/voluntractteaminfo" caption="활동그룹^활동요일/시간대^참여인원(실인원)^총결인원(횟수)^봉사시간(분단위)^합계|활동그룹^활동요일/시간대^참여인원(실인원)^총결인원(횟수)^봉사시간(분단위)^합계" colsep="^" colwidth="162, 135, 160, 160, 160" dataheight="25" extendlastcol="scroll" frozencols="7" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:77px; width:820px; height:663px; ">
				<col ref="actdeptcd" style="text-align:center; "/>
				<col ref="voluntractdwcd" style="text-align:center; "/>
				<col ref="cnt" format="#,###" style="text-align:center; "/>
				<col ref="attdabsnflag" format="#,###" style="text-align:center; "/>
				<col ref="servtm" format="#,###.9" style="text-align:center; "/>
			</datagrid>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:757px; width:820px; height:27px; ">
			<line id="line37" class="line_6" style="x1:0px; y1:0px; x2:820px; y2:0px; "/>
		</group>
		<caption id="caption1" class="tit_2" style="left:5px; top:71px; width:309px; height:14px; ">자원봉사자 소속팀별 통계</caption>
		<line id="line1" class="line_1" style="x1:0px; y1:86px; x2:820px; y2:86px; "/>
		<button id="button10" class="btn4_letter3" disable.background-image="../../../com/commonweb/images/dis_btn4_letter3.gif" style="left:743px; top:760px; width:68px; height:22px; background-image:../../../com/commonweb/images/btn4_letter3.gif; ">
			<caption>초기화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						fResetVoluntrActTeam();	
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>