YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT02000_사회사업상담관리실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT02000.사회사업 상담 관리 실적.xrw
	* 설    명   : 사회사업 상담 관리 실적
	* 작 성 자  : 황혜민
	* 작 성 일  : 2008.09.02
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<cnstinfo>
							<cnstlist>
								<cond/>
								<soclpsy/>
								<socleco/>
								<soclio/>
								<soclloc/>
								<soclret/>
								<socletc/>
								<soclssum/>
								<soclper/>
								<soclfam/>
								<soclgcon/>
								<soclgedu/>
								<socltel/>
								<soclvst/>
								<soclcur/>
								<soclhom/>
								<soclclin/>
								<soclesum/>
								<soclsum/>
								<bfcnt/>
								<bfcompare/>
							</cnstlist>
						</cnstinfo>
					</main>
					<send>
						<reqdata>
							<fromdd/>
							<todd/>
							<sumflag>1</sumflag>
						</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="TRSDT06001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
			<bind id="bfcompare" ref="/root/main/cnstinfo/cnstlist/bfcompare" calculate="../soclsum  - ../bfcnt"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit(){
					
					var currentDate = getCurrentDate();
					var LastDate=currentDate.toDate().getAddDate(-1,"M").getDateFormat();
					var LastDateYM=LastDate.substr(0,6);
					
					model.setValue("/root/send/reqdata/fromdd", LastDateYM );					
	               	model.setValue("/root/send/reqdata/todd"    , LastDateYM );	               		
						               			               		
					// 그리드초기화
					model.removeNodeset("/root/main/cnstinfo/cnstlist");				
					
					model.refresh();
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fDefaultCheck(){
					var fromdd = model.getValue("/root/send/reqdata/fromdd") +"01";
					var todd     = model.getValue("/root/send/reqdata/todd")+ "01";		
					
					if( isNull(fromdd) == true || isNull(todd) == true){
						model.removeNodeset("/root/main/cnstinfo/cnstlist");
						model.refresh();
						messageBox("조회기간을", "C001");
						model.setFocus("ipt_fromdd");
						return false;
					}					
						// dataHelper 함수 isValidDateTime
					if( !isValidDateTime(fromdd, 'YYYYMMDD') || !isValidDateTime(todd, 'YYYYMMDD')){
						model.removeNodeset("/root/main/cnstinfo/cnstlist");
						model.refresh();
						messageBox("입력하신 일이 정확한 날짜타입이 아닙니다.", "E999", "");
						model.setFocus("ipt_fromdd");
						return false;	
					}
					if(fromdd>todd)
					{
						model.removeNodeset("/root/main/cnstinfo/cnstlist");
						model.refresh();
						messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
						model.setFocus("ipt_todd");
						return;
					}
							
					var dateintval=getDateInterval(fromdd,todd);
					//alert(dateintval);
					if(dateintval>=365)
					{
						model.removeNodeset("/root/main/cnstinfo/cnstlist");
						model.refresh();
						messageBox("조회기간은 최대1년까지 할 수 있습니다.","I");
						model.setFocus("ipt_fromdd");
						
						return false;
					}	
					else
					{
						return true;	
					}	
					
				}
/**========================================================================================================================================
*-- 조회 (STS.SDTSCNST)
=========================================================================================================================================*/	
				function fAllSearch(){
					//model.resetInstanceNode("/root/main/cnstinfo/cnstlist");			
					model.removeNodeset("/root/main/cnstinfo/cnstlist");
					
					var val = model.getValue("/root/send/reqdata/sumflag");
						
					switch(val){
					// 월별
					case("1"):  
						fDisableGrd(false);	
						fSearch();				
						//fGetBfResult();
						break;
					// 임상과
					case("3"):
						fDisableGrd(true);
						fSearch();
						break;								
					// 업무분야별
					case("2"):
						fDisableGrd(true);							
						fSearch();
						break;
					}		
				}
				
				function fSearch(){
					//alert(fDefaultCheck());
					if(!fDefaultCheck()) return;				
					
					if(submit("TRSDT06001") ==  true){
						
					}else{
						messageBox("조회를", "E009");
					}	
					var val = model.getValue("/root/send/reqdata/sumflag");
					
					if(val=='1')
					{
						fGetBfResult();		//월별로 조회했을 때 전년도 합계 구하는 함수 
					}
								
				}

/**========================================================================================================================================
*  조회구분 변경했을때
=========================================================================================================================================*/	
			
				function fDisableGrd(flag){					
					grd_cnst.colHidden(19)  =  flag;
					grd_cnst.colHidden(20)  =  flag;
				}
				

				function fCmbChange(){
					//model.resetInstanceNode("/root/main/cnstinfo/cnstlist");
//					model.removeNodeset("/root/main/cnstinfo/cnstlist");
//					model.refresh();
					
					fAllSearch();
//						var val = model.getValue("/root/send/reqdata/sumflag");
//						
//						switch(val){
//						// 월별
//						case("1"):  
//							fDisableGrd(false);	
//							fSearch();				
//							fGetBfResult();
//							break;
//						// 임상과
//						case("3"):
//							fDisableGrd(true);
//							fSearch();
//							break;								
//						// 업무분야별
//						case("2"):
//							fDisableGrd(true);							
//							fSearch();
//							break;
//						}					
				}
				
/*
* 전월대비 실적비교    합계-전월실적 
===========================================*/
					
				function fGetBfResult(){	
					//if(!fDefaultCheck()) return;	     // 조건에 만족하지 않을 때는 함수 타지 않게 수정 
								
					if(grd_cnst.rows - grd_cnst.fixedRows >1){
						var sStat = 0;
						var insRow = grd_cnst.rows;
						grd_cnst.addRow(insRow, false);
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("cond") ) = "전기간대비실적비교";
							
						for(var i= grd_cnst.colRef("soclpsy"); i<= grd_cnst.colRef("soclsum"); i++){
							var bfResult = eval(grd_cnst.valueMatrix(insRow -1 , i));												
							var sSum = eval(grd_cnst.valueMatrix(insRow-2, i));		
																											
							sStat = eval(sSum)- eval(bfResult) ;							
							grd_cnst.valueMatrix(insRow, i ) = eval(sStat);								
							//alert("sSum "+ sSum +"bfResult " + bfResult + "sStat " + sStat);														
						}	
															
						grd_cnst.valueMatrix(insRow-1, grd_cnst.colRef("bfcnt")) = "";
						grd_cnst.valueMatrix(insRow-1, grd_cnst.colRef("bfcompare")) = "";	
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("bfcompare")) = "";	
																
					}else{						
						model.removeNodeset("/root/main/cnstinfo/cnstlist");						
					}
					model.refresh();
				}

/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/					
				function fExcel() {
					if (grd_cnst.rows <= 1) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "사회사업상담관리실적", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_cnst.saveExcel(fileName, "SheetName", false, false, "", "", 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:224px; 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[
						fInit();
					]]>
				</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:195px; height:13px; ">사회사업상담관리실적</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:74px; x2:1190px; 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[
						//fCmbChange();												
						fAllSearch();
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:25px; 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; "/>
				<select1 id="cmb_sumflaga2" ref="/root/send/reqdata/sumflag" appearance="minimal" style="left:125px; top:10px; width:100px; height:19px; ">
					<choices>
						<item>
							<label>월별</label>
							<value>1</value>
						</item>
						<item>
							<label>임상과별</label>
							<value>3</value>
						</item>
						<item>
							<label>업무분야별</label>
							<value>2</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
							fCmbChange();				
						]]>
					</script>
				</select1>
				<caption id="cap1" style="left:455px; top:8px; width:25px; height:20px; text-align:center; ">~</caption>
				<input id="ipt_fromdd" ref="/root/send/reqdata/fromdd" class="input_search" inputtype="date" format="yyyy-mm" style="left:357px; top:8px; width:100px; height:19px; "/>
				<input id="ipt_todd" ref="/root/send/reqdata/todd" class="input_search" inputtype="date" format="yyyy-mm" style="left:480px; top:8px; width:100px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:265px; top:10px; width:100px; height:17px; ">조회기간 :</caption>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:1130px; top:51px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExcel();
					]]>
				</script>
			</button>
			<datagrid id="grd_cnst" nodeset="/root/main/cnstinfo/cnstlist" class="datagrid2" caption="구분^사회사업&#xA;심리사회적&#xA;문제^사회사업&#xA;경제적&#xA;문제^사회사업&#xA;입퇴원계획&#xA;문제^사회사업&#xA;지역사회자원&#xA;연결문제^사회사업&#xA;사회복귀및&#xA;재활문제^사회사업&#xA;기타문제^소계^사회사업&#xA;개별상담^사회사업&#xA;가족상담^사회사업&#xA;집단상담^사회사업&#xA;집단교육^전화&#xA;상담^사회사업&#xA;병실방문^사회사업&#xA;치료적&#xA;협의^가정&#xA;방문^사회사업&#xA;임상기록^소계^합계^전월실적^전월대비&#xA;실적비교^caption3^caption4^caption5^caption6^caption7^caption8^사회사업&#xA;가족상담^사회사업&#xA;집단상담^사회사업&#xA;집단상담^사회사업&#xA;집단교육^전화상담^사회사업&#xA;병실방문^사회사업&#xA;치료적&#xA;협의^사회사업&#xA;임상기록^소계^합계|구분^사회사업&#xA;심리사회적&#xA;문제^사회사업&#xA;경제적&#xA;문제^사회사업&#xA;입퇴원계획&#xA;문제^사회사업&#xA;지역사회자원&#xA;연결문제^사회사업&#xA;사회복귀및&#xA;재활문제^사회사업&#xA;기타문제^소계^사회사업&#xA;개별상담^사회사업&#xA;가족상담^사회사업&#xA;집단상담^사회사업&#xA;집단교육^전화&#xA;상담^사회사업&#xA;병실방문^사회사업&#xA;치료적&#xA;협의^가정&#xA;방문^사회사업&#xA;임상기록^소계^합계^전월실적^전월대비&#xA;실적비교^caption2^caption3^caption4^caption5^caption6^caption7^caption8^사회사업&#xA;집단상담^사회사업&#xA;집단교육^전화상담^사회사업&#xA;병실방문^사회사업&#xA;치료적&#xA;협의^사회사업&#xA;임상기록^소계^합계" colsep="^" colwidth="120, 68, 58, 69, 80, 69, 58, 52, 56, 55, 57, 55, 45, 55, 54, 41, 56, 50, 50, 55, 55" dataheight="25" frozencols="8" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; ">
				<col ref="cond" format="yyyy-mm" style="text-align:center; "/>
				<col ref="soclpsy" style="text-align:center; "/>
				<col ref="socleco" style="text-align:center; "/>
				<col ref="soclio" format="yyyy-mm-dd hh:nn:ss" style="text-align:center; "/>
				<col ref="soclloc" style="text-align:center; "/>
				<col ref="soclret" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="socletc" style="text-align:center; "/>
				<col ref="soclssum" style="text-align:center; "/>
				<col ref="soclper" style="text-align:center; "/>
				<col ref="soclfam" style="text-align:center; "/>
				<col ref="soclgcon" style="text-align:center; "/>
				<col ref="soclgedu" style="text-align:center; "/>
				<col ref="socltel" style="text-align:center; "/>
				<col ref="soclvst" style="text-align:center; "/>
				<col ref="soclcur" style="text-align:center; "/>
				<col ref="soclhom" style="text-align:center; "/>
				<col ref="soclclin" style="text-align:center; "/>
				<col ref="soclesum" style="text-align:center; "/>
				<col ref="soclsum" style="text-align:center; "/>
				<col ref="bfcnt" style="text-align:center; "/>
				<col ref="bfcompare" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>