YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT00200_월별원목업무총집계표.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT00200.월별원목업무총집계표.xrw
	* 설    명   : 월별 원목업무 총 집계표
	* 작 성 자  : 김다영
	* 작 성 일  : 2008.07.31
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<fthinfo>
							<fthinfolist>
								<lrgnm/>
								<mdlnm/>
								<smlnm/>
								<col1/>
								<col2/>
								<col3/>
								<col4/>
								<col5/>
								<col6/>
								<col7/>
								<col8/>
								<col9/>
								<col10/>
								<col11/>
								<col12/>
								<sum/>
								<presum/>
								<increase/>
								<lrgcd/>
								<mdlcd/>
								<smlcd/>
							</fthinfolist>
						</fthinfo>
						<cond>
							<yearflag>2</yearflag>
							<endyy/>
							<conslrid/>
							<viewflag>1</viewflag>
							<qurtyy/>
							<entryy/>
						</cond>
					</main>
					<send>
						<reqdata/>
					</send>
					<init>
						<comcodelist>
							<conslrlist>
								<conslrlistinfo>
									<conslrid/>
									<conslrnm>전체</conslrnm>
								</conslrlistinfo>
							</conslrlist>
						</comcodelist>
						<jobrespcd/>
					</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/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[
					
					fGetComCdList();
					fGetJobrespcd();
					
				]]>
			</script>
			<submission id="TRSDT00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/fthinfo"/>
			<submission id="TRAYA00101" ref="/root/send/reqdata" resultref="/root/init/comcodelist/conslrlist"/>
			<bind id="sum" ref="/root/main/fthinfo/fthinfolist/sum" calculate="../col1  +../col2  +../col3  +../col4  +../col5  +../col6  + ../col7  + ../col8 + ../col9 + ../col10 +  ../col11  + ../col12"/>
			<bind id="increase" ref="/root/main/fthinfo/fthinfolist/increase" calculate="( ../sum  - ../presum )  div   ../presum  *  100"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 원목자조회, 그리드초기화
=========================================================================================================================================*/	
				function fGetComCdList(){
					
					var currentDate = getCurrentDate();
	                var currentYear = currentDate.substring(0, 4); 
	
					// 그리드초기화
					model.removeNodeset("/root/main/ftninfo/fthinfolist");
					model.setValue("/root/main/cond/endyy",currentYear);
					model.setValue("/root/main/cond/entryy",currentYear);
					
					model.removeNodeset(grd_fthendstatsmonthlist.nodeset);
					
					cmb_qurtyy.select(0);
					cmb_qurtyy.disabled =  true;
						
					//  원목자 조회
					model.makeValue("/root/send/reqdata/joblncd", "B");
					submit("TRAYA00101", false);
					addComboItem("cmb_conslrid", "전체", "", "above");
									
					var code = getUserInfo('jobrespcd');
					
					model.refresh();
				}
				
/**========================================================================================================================================
* 월별원목업무총집계표 조회
=========================================================================================================================================*/			
				function fGetFthInfoList(){
					
					var endyy = model.getValue("/root/main/cond/endyy");
					if( endyy == ""){
						messageBox("조회년도를","C001" );
						model.refresh();
						return;
								
					}
					
					
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
															
					//grid merge
					grd_fthendstatsmonthlist.mergeCells = "bycolrec";
					grd_fthendstatsmonthlist.mergeCol(0) = true;
					grd_fthendstatsmonthlist.mergeCol(1) = true;
					grd_fthendstatsmonthlist.mergeCol(2) = true;
					grd_fthendstatsmonthlist.mergeCol(3) = false;
					grd_fthendstatsmonthlist.mergeCol(4) = false;
					grd_fthendstatsmonthlist.mergeCol(5) = false;
					grd_fthendstatsmonthlist.mergeCol(6) = false;
					grd_fthendstatsmonthlist.mergeCol(7) = false;
					grd_fthendstatsmonthlist.mergeCol(8) = false;
					grd_fthendstatsmonthlist.mergeCol(9) = false;
					grd_fthendstatsmonthlist.mergeCol(10) = false;
					grd_fthendstatsmonthlist.mergeCol(11) = false;
					grd_fthendstatsmonthlist.mergeCol(12) = false;
					grd_fthendstatsmonthlist.mergeCol(13) = false;
					grd_fthendstatsmonthlist.mergeCol(14) = false;
					grd_fthendstatsmonthlist.mergeCol(15) = false;
					grd_fthendstatsmonthlist.mergeCol(16) = false;
					grd_fthendstatsmonthlist.mergeCol(17) = false;
					grd_fthendstatsmonthlist.mergeCol(18) = false;
					grd_fthendstatsmonthlist.mergeCol(19) = false;
					grd_fthendstatsmonthlist.mergeCol(20) = false;
					grd_fthendstatsmonthlist.mergeCol(21) = false;
					
					submit("TRSDT00201");
					
				}
/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/						
				
				function fExcel() {
					if (grd_fthendstatsmonthlist.rows <= 1) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "월별 원목업무 총집계표", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_fthendstatsmonthlist.saveExcel(fileName, "SheetName", false, false, "", "", false);
					}
				}

/**========================================================================================================================================
* 월별원목업무총집계표 초기화
=========================================================================================================================================*/										
				function fInitialize()
				{
					// 그리드초기화
					model.removeNodeset("/root/main/ftninfo/fthinfolist");
					model.removeNodeset("/root/main/cond/fthendyy");
					
					
					model.removeNodeset(grd_fthendstatsmonthlist.nodeset);
					
					cmb_conslrid.select(0);
											
					model.refresh();

					
				}
/**========================================================================================================================================
* 원목자 권한
=========================================================================================================================================*/					
				function fGetJobrespcd(){
				
				//사용자ID (입력자 또는 로그인한 사용자ID)
				
				var userid =  getUserInfo("userid"); 
				model.setValue(cmb_conslrid.attribute("ref"), userid);
				
				model.refresh();	
				
				var code = getUserInfo('jobrespcd');
				if(code == '1070' || 	code == '1020' || code =='1030' || code =='01'){
					cmb_conslrid.disabled = false;
				}else{
					cmb_conslrid.disabled = true;
					}
				}
/**========================================================================================================================================
* 년도 구분
=========================================================================================================================================*/					
				function fYearflaginfo(){
					var yearflag = model.getValue("/root/main/cond/yearflag");
					if(yearflag == '2'){
						cmb_qurtyy.disabled =  true;
						cmb_qurtyy.select (0);
					}else if(yearflag == '1'){
						cmb_qurtyy.disabled =  false;
					}
				}
					
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;" 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:160px; 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[
						fInitialize();
					]]>
				</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:50px; width:190px; height:14px; ">월별 원목업무 총 집계표</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:74px; x2:1194px; y2:73px; "/>
			<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" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetFthInfoList();				
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:370px; top:8px; width:80px; height:17px; ">원목자 :</caption>
				<select1 id="cmb_conslrid" ref="/root/main/cond/conslrid" class="combo_default" appearance="minimal" style="left:455px; top:8px; width:130px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/comcodelist/conslrlist/conslrlistinfo">
							<label ref="conslrnm"/>
							<value ref="conslrid"/>
						</itemset>
					</choices>
				</select1>
				<line id="line2" style="x1:1113px; y1:7px; x2:1113px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_year" ref="/root/main/cond/endyy" style="left:170px; top:8px; width:55px; height:19px; "/>
				<select1 id="rdo_yearflag" ref="/root/main/cond/yearflag" overflow="visible" appearance="full" cols="2" rows="1" style="left:25px; top:8px; width:140px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>달력년도</label>
							<value>2</value>
						</item>
						<item>
							<label>사업년도</label>
							<value>1</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
								fYearflaginfo();
						]]>
					</script>
				</select1>
				<select1 id="cmb_qurtyy" ref="/root/main/cond/qurtyy" appearance="minimal" style="left:230px; top:8px; width:70px; height:19px; ">
					<choices>
						<item>
							<label>전체</label>
							<value/>
						</item>
						<item>
							<label>1분기</label>
							<value>1</value>
						</item>
						<item>
							<label>2분기</label>
							<value>2</value>
						</item>
						<item>
							<label>3분기</label>
							<value>3</value>
						</item>
						<item>
							<label>4분기</label>
							<value>4</value>
						</item>
					</choices>
				</select1>
				<input id="ipt_entryy" ref="/root/main/cond/entryy" visibility="hidden" style="left:305px; top:8px; width:55px; height:19px; "/>
			</group>
			<datagrid id="grd_fthendstatsmonthlist" nodeset="/root/main/fthinfo/fthinfolist" autoresize="true" caption="항목^세부단위 업무^세부단위 업무^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^lrgcd^mdlcd^smlcd^  전년도       (분기) 합계^증감율(%)|항목^세부단위 업무^세부단위 업무^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^lrgcd^mdlcd^smlcd^  전년도       (분기) 합계^증감율(%)" colsep="^" colwidth="85, 150, 137, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 65, 7, 6, 6, 75, 65" mergecellsfixedrows="byrowrec" rowsep="|" style="left:0px; top:77px; width:1195px; height:662px; ">
				<col ref="lrgnm" style="text-align:center; "/>
				<col ref="mdlnm" style="text-align:center; "/>
				<col ref="smlnm" style="text-align:center; "/>
				<col ref="col1" format="#,###" style="text-align:center; "/>
				<col ref="col2" format="#,###" style="text-align:center; "/>
				<col ref="col3" format="#,###" style="text-align:center; "/>
				<col ref="col4" format="#,###" style="text-align:center; "/>
				<col ref="col5" format="#,###" style="text-align:center; "/>
				<col ref="col6" format="#,###" style="text-align:center; "/>
				<col ref="col7" format="#,###" style="text-align:center; "/>
				<col ref="col8" format="#,###" style="text-align:center; "/>
				<col ref="col9" format="#,###" style="text-align:center; "/>
				<col ref="col10" format="#,###" style="text-align:center; "/>
				<col ref="col11" format="#,###" style="text-align:center; "/>
				<col ref="col12" format="#,###" style="text-align:center; "/>
				<col ref="sum" format="#,###" style="text-align:center; "/>
				<col ref="lrgcd" visibility="hidden" style="text-align:right; "/>
				<col ref="mdlcd" visibility="hidden" style="text-align:right; "/>
				<col ref="smlcd" visibility="hidden" style="text-align:right; "/>
				<col ref="presum" format="#,###" style="text-align:center; "/>
				<col ref="increase" format="(-)#,###.99" style="text-align:center; "/>
			</datagrid>
			<select1 id="rdo_viewflag" ref="/root/main/cond/viewflag" overflow="visible" appearance="full" cols="2" rows="1" style="left:1027px; top:48px; width:93px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>전체</label>
						<value>1</value>
					</item>
					<item>
						<label>기본</label>
						<value>2</value>
					</item>
				</choices>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
					       if(rdo_viewflag.value =='1'){
							grd_fthendstatsmonthlist.rowHidden(35) = false;   
							grd_fthendstatsmonthlist.rowHidden(36) = false;
							grd_fthendstatsmonthlist.rowHidden(37) = false;
							grd_fthendstatsmonthlist.rowHidden(38) = false;
							grd_fthendstatsmonthlist.rowHidden(39) = false;
							grd_fthendstatsmonthlist.rowHidden(40) = false;
							grd_fthendstatsmonthlist.rowHidden(41) = false;
							grd_fthendstatsmonthlist.rowHidden(42) = false;
							grd_fthendstatsmonthlist.rowHidden(43) = false;
							grd_fthendstatsmonthlist.rowHidden(44) = false;
							grd_fthendstatsmonthlist.rowHidden(45) = false;
							grd_fthendstatsmonthlist.rowHidden(46) = false;
							grd_fthendstatsmonthlist.rowHidden(47) = false;
							grd_fthendstatsmonthlist.rowHidden(48) = false;
							grd_fthendstatsmonthlist.rowHidden(49) = false;
							grd_fthendstatsmonthlist.rowHidden(50) = false;
							grd_fthendstatsmonthlist.rowHidden(51) = false;
							grd_fthendstatsmonthlist.rowHidden(52) = false;
							grd_fthendstatsmonthlist.rowHidden(53) = false;
							grd_fthendstatsmonthlist.rowHidden(54) = false;
							grd_fthendstatsmonthlist.rowHidden(55) = false;
							grd_fthendstatsmonthlist.rowHidden(56) = false;
							grd_fthendstatsmonthlist.rowHidden(57) = false;
							grd_fthendstatsmonthlist.rowHidden(58) = false;
							model.refresh();
						}
						else if(rdo_viewflag.value == '2'){
							grd_fthendstatsmonthlist.rowHidden(35) = true;  
							grd_fthendstatsmonthlist.rowHidden(36) = true;
							grd_fthendstatsmonthlist.rowHidden(37) = true;
							grd_fthendstatsmonthlist.rowHidden(38) = true;
							grd_fthendstatsmonthlist.rowHidden(39) = true;
							grd_fthendstatsmonthlist.rowHidden(40) = true;
							grd_fthendstatsmonthlist.rowHidden(41) = true;
							grd_fthendstatsmonthlist.rowHidden(42) = true;
							grd_fthendstatsmonthlist.rowHidden(43) = true;
							grd_fthendstatsmonthlist.rowHidden(44) = true;
							grd_fthendstatsmonthlist.rowHidden(45) = true;
							grd_fthendstatsmonthlist.rowHidden(46) = true;
							grd_fthendstatsmonthlist.rowHidden(47) = true;
							grd_fthendstatsmonthlist.rowHidden(48) = true;
							grd_fthendstatsmonthlist.rowHidden(49) = true;
							grd_fthendstatsmonthlist.rowHidden(50) = true;
							grd_fthendstatsmonthlist.rowHidden(51) = true;
							grd_fthendstatsmonthlist.rowHidden(52) = true;
							grd_fthendstatsmonthlist.rowHidden(53) = true;
							grd_fthendstatsmonthlist.rowHidden(54) = true;
							grd_fthendstatsmonthlist.rowHidden(55) = true;
							grd_fthendstatsmonthlist.rowHidden(56) = true;
							grd_fthendstatsmonthlist.rowHidden(57) = true;
							grd_fthendstatsmonthlist.rowHidden(58) = true;
							model.refresh();
						}		  
					]]>
				</script>
			</select1>
			<caption id="caption29" class="cell_1" style="left:944px; top:46px; width:79px; height:21px; text-align:center; vertical-align:middle; ">표시구분</caption>
			<button id="btn_excel" class="btn2_letter4" style="left:1130px; top:46px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExcel();
					]]>
				</script>
			</button>
			<shape id="roundrect2" class="roundrect_example" appearance="roundrect" style="left:940px; top:43px; width:185px; height:27px; "/>
		</group>
	</xhtml:body>
</xhtml:html>