YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT07500_사회사업자선회부서별가입실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT07500.사회사업자선회부서별가입실적.xrw
	* 설    명   : 사회사업자선회부서별가입실적 
	* 작 성 자  : 임여원
	* 작 성 일  : 2008.12.05
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
								<cls/>
								<dutplcedeptcd/>
								<instnm/>
								<deptnm/>
								<emplno/>
								<entcnt/>
								<entrate/>
								<deduamt/>
								<deduavg/>
							</brgstincmexpsprescond>
						</brgstincmexpspres>
						<search>
							<instcd>%</instcd>
							<fromdd/>
							<fromentryy/>
							<fromendyy/>
							<toendyy/>
							<toentryy/>
						</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"/>
			<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="TRSDT07501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/brgstincmexpspres"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit()
				{
					//cmb_reqflag.select(0);
					//ipt_fromdd.visible=true;
					//ipt_todd.visible=true;
					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);
										
					var dutplceinstcd=getUserInfo("dutplceinstcd"); 
					//기관코드 받아서 중앙의료원 , 강남성모일 때만 전체로, 나머지는 로그인한 병원의 것만 조회하도록 함 
					
					if(dutplceinstcd=='103')
					{
						cmb_instcd.select(2);
						cmb_instcd.disabled=true;
					}
					else if(dutplceinstcd=='011')
					{
						cmb_instcd.select(3);
						cmb_instcd.disabled=true;
						
					}
					else if(dutplceinstcd=='013')
					{
						cmb_instcd.select(5);
						cmb_instcd.disabled=true;
						
					}
					else if(dutplceinstcd=='001')
					{
						cmb_instcd.select(1);
						cmb_instcd.disabled=false;
						
					}
					else
					{
						cmb_instcd.select(4);
						cmb_instcd.disabled=false;
					}
					model.refresh();
					
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fReqBrgstIncmExpsCond()
				{
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					model.refresh();
					
					var fromdd=model.getValue("/root/main/search/fromdd");
					var instcd=model.getValue("/root/main/search/instcd");
					
					model.makeValue("/root/send/reqdata/fromdd",fromdd);
					model.makeValue("/root/send/reqdata/instcd",instcd);
					
					if(isNull(fromdd))
					{
						messageBox("조회시작일자는","I003");
						model.setFocus("ipt_fromdd");
						return;
					}
					
					
					submit("TRSDT07501");
					
					/*
					var idxRows=grd_brgstincmexpsprescond.rows;
			
			
					//alert(idxRows);
					if(idxRows!='0')
					{
						for(i=1;i<idxRows;i++)
						{
							var instnm=model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond"+"["+i+"]/instnm");
							var deptnm=model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond"+"["+i+"]/deptnm");
							
							if(deptnm=="소계")
							{
								//alert(i);
								grd_brgstincmexpsprescond.cellStyle("background-color",i+1,2, i+1, 7) = "#ccffcc";    
		
							}
							else if(instnm=="합계")
							{
								//alert("합계"+i);
								grd_brgstincmexpsprescond.cellStyle("background-color",i+1,1, i+1, 7) = "#ccffff";     
							}
							else
							{
								grd_brgstincmexpsprescond.cellStyle("background-color",i+1,1, i+1, 7) = "#ffffff";   
							}
						}
					}
					
				*/	
					
					
				}
				
   /**========================================================================================================================================                                 
   * 전년실적                                                                                                                                                                  
   =========================================================================================================================================*/					                                                                                                                                                                 
   					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("nurspatcnt"); i<= grd_brgstincmexpsprescond.colRef("nursexchamt"); 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="3" 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:280px; 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; "/>
				<input id="ipt_fromdd" ref="/root/main/search/fromdd" class="input_search" navindex="1" inputtype="date" format="yyyy-mm" style="left:102px; top:8px; width:73px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:10px; top:10px; width:100px; height:17px; ">조회일자:</caption>
				<select1 id="cmb_instcd" ref="/root/main/search/instcd" navindex="2" appearance="minimal" style="left:375px; top:8px; width:125px; height:19px; ">
					<choices>
						<item>
							<label>전체</label>
							<value>%</value>
						</item>
						<item>
							<label>중앙의료원</label>
							<value>001</value>
						</item>
						<item>
							<label>성의교정</label>
							<value>103</value>
						</item>
						<item>
							<label>성모병원</label>
							<value>011</value>
						</item>
						<item>
							<label>강남성모병원</label>
							<value>012</value>
						</item>
						<item>
							<label>의정부성모병원</label>
							<value>013</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
								/*
									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);
									
									var fromdd=model.getValue("/root/main/search/fromdd");
									var todd=model.getValue("/root/main/search/todd");
									
									*/
									model.removeNodeset("/root/send/reqdata");
									model.makeNode("/root/send/reqdata");
									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" nodeset="/root/main/brgstincmexpspres/brgstincmexpsprescond" class="datagrid2" backcoloralternate="transparent" caption="기관명^부서명^교직원수^자선회가입교직원수^자선회교직원가입률^자선회교직원기부액^부서1인당기부액^reply^장소^장소^장소^장소명^장소^담당자|기관명^부서명^교직원수^자선회가입교직원수^자선회교직원가입률^자선회교직원기부액^부서1인당기부액^reply^장소^장소^장소^장소명^장소^담당자" colsep="^" colwidth="178, 269, 132, 141, 141, 152, 152" dataheight="25" extendlastcol="scroll" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; ">
				<col ref="instnm" style="text-align:center; "/>
				<col ref="deptnm"/>
				<col ref="emplno" format="#,###" style="text-align:center; "/>
				<col ref="entcnt" format="#,###" style="text-align:center; "/>
				<col ref="entrate" style="text-align:center; "/>
				<col ref="deduamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="deduavg" format="(-)#,###" style="text-align:right; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>