YNU_JEUS/app_home/himed/webapps/emr/homecareweb/xrw/SMMNF05200_가정간호물품사용내역.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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>
						<cond>
							<sumfromdd/>
							<sumtodd/>
							<prcpattrflag/>
						</cond>
						<goodinfo>
							<goodlist>
								<prcpcd/>
								<prcpnm/>
								<drugpackunit/>
								<totprcpcnt/>
								<hospprcpcnt/>
							</goodlist>
						</goodinfo>
					</main>
					<send>
						<reqdata/>
					</send>
					<init>
						<churchlist>
							<churchcd/>
							<churchnm/>
						</churchlist>
					</init>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../emr/commonweb/js/EMRCommon.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				//초기화
				          fInit();
				]]>
			</script>
			<submission id="TRMNF05201" mediatype="application/x-www-form-urlencoded" method="post" resultref="/root/init/churchlist"/>
			<submission id="TRMNF05202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/goodinfo"/>
		</model>
		<script type="javascript">
			<![CDATA[
				//화면 초기 설정
				          function fInit(){
						     model.setValue("/root/main/cond/sumfromdd"   , getCurrentDate()            ); // 시작일자 (현재일자)
						     model.setValue("/root/main/cond/sumtodd"     , getCurrentDate()            ); // 종료일자 (현재일자)
						     model.setValue("/root/main/cond/prcpattrflag", "3"                         ); // 처방속성구분 ("3": 전체)
					       
						     //* 그리드 초기화 *//
						     model.removeNodeset("/root/main/goodinfo"); // 물품사용내역 초기화
						     model.removeNodeset("/root/init/churchlist"); // 부서명 초기화
						     
						     submit("TRMNF05201");

						     var dataCnt = getNodesetCnt(model, "/root/init/churchlist") ;
						     grd_goodlist.caption = "처방코드^처방명^단위^계^병원";
						     var Cnt = 0;

						     for(var i=0 ; i < dataCnt; i++){
						     		Cnt = i+1 ;
						     		 grd_goodlist.addColumn("ref:col"+ i + "; type:output;");
						     		 grd_goodlist.colwidth(i+5) = 70;	
							     	 //grd_goodlist.valuematrix(0, i) = model.getValue("/root/init/churchlist[" + i +"]/churchnm");	
							     	 grd_goodlist.caption = grd_goodlist.caption + "^" + model.getValue("/root/init/churchlist[" + Cnt +"]/churchnm");						     	 						     	 
							     	 						     	 
						     }
						     grd_goodlist.rebuild();
						     model.refresh();
					}
				
				//물품 사용 내역 조회
					function fSrchgoodInfo(){
						
						model.copyNode("/root/send/reqdata","/root/main/cond");
					 	   submit("TRMNF05202");	 
					}
					
			//환자별 집계현황조회		
					function fSrchSumPatInfo(){
					 	   iRow = grd_sumprcpinfo.row;
					 	   iCol = grd_sumprcpinfo.col;
					
					     model.removeNodeset("/root/main/sumpatlist");
					
					 	   model.makeValue("/root/main/sumpatlist/prcpnm", model.getValue("/root/main/sumprcplist/sumprcpinfo["+ iRow +"]/prcpnm")); // 처방명
					 	   model.makeValue("/root/main/sumpatlist/prcpcd", model.getValue("/root/main/sumprcplist/sumprcpinfo["+ iRow +"]/prcpcd")); // 처방코드
					
					     model.removenode("/root/send");
							 model.makeNode("/root/send/reqdata");
							 model.makeValue("/root/send/reqdata/sumfromdd"    , model.getValue("/root/main/cond/sumfromdd")   ); // 집계시작일자
							 model.makeValue("/root/send/reqdata/sumtodt"      , model.getValue("/root/main/cond/sumtodd")         ); // 집계종료일자
							 model.makeValue("/root/send/reqdata/prcpattrflag" , model.getValue("/root/main/cond/prcpattrflag")); // 처방속성구분
							 model.makeValue("/root/send/reqdata/deliveflag"   , model.getValue("/root/main/cond/deliveflag")  ); // 불출구분
							 model.makeValue("/root/send/reqdata/prcpcd"       , model.getValue("/root/main/sumprcplist/sumprcpinfo["+ iRow +"]/prcpcd")); // 처방코드
							 model.makeValue("/root/send/reqdata/drugmthdspccd", model.getValue("/root/main/sumprcplist/sumprcpinfo["+ iRow +"]/drugmthdspccd")); // 재료규격ID
							 
					 	   submit("TRMNF05002");	    
					 	 
					 	   grd_prcppotlist.colstyle(7, "data", "color") = "black"; // 입력자 글자색상 초기화(검정)
					
					 	   for(var i=1; i<grd_prcppotlist.rows; i++){
					 	   	   if(model.getValue("/root/main/sumpatlist/sumpatinfo["+i+"]/prcpauthflag") == "0"){  // 입력자가 의사일 경우 글자색상 지정(보라색)
					 	   	      	grd_prcppotlist.cellStyle("color", i, 7, i, 7) =  "#cc0099";  
					 	   	   }
					 	   }
					}
					
			
			//출력기능	
					function fExecPrint(){
					     model.removenode("/root/send");
					     model.makeNode("/root/send/cond");
					     model.makeNode("/root/send/goodinfo");
					     model.makeNode("/root/send/init");
					     model.copyNode("/root/send/cond"       , "/root/main/cond");
					     model.copyNode("/root/send/goodinfo", "/root/main/goodinfo");
					     model.copyNode("/root/send/init"       , "/root/init");

					     
 							exeReportPreview("RPMNF05200", "XMLSTR");
					}
							
			/************************************************************************************************************************/
			/**
			 * @group  :
			 * @ver    :
			 * @by     : 김기용
			 * @---------------------------------------------------
			 * @type   : function
			 * @access : public
			 * @desc   : 그리드 별 엑셀저장
			 * @param  :
			 * @return :
			 * @---------------------------------------------------
			 */
				function saveExcelAll() {
					
					var paramLen = saveExcelAll.arguments.length;
					
					// 마지막 인자가 Boolean일 경우 처리
					var extendsCaptionBool;
					if( typeof(saveExcelAll.arguments[paramLen - 1]) == "boolean" ) {
						extendsCaptionBool =  saveExcelAll.arguments[paramLen - 1];		
						paramLen = paramLen - 1;
					}
					else{
						extendsCaptionBool =  false;
					}
						
					var tmpParamArray = new Array();
					if( extendsCaptionBool ) {
						for( var i = 0; i < paramLen; i++ ) {
							tmpParamArray[i] =  saveExcelAll.arguments[i];	
						}
						saveExcelAllWithCaption(tmpParamArray);
					}	
					else{
						for( var i = 0; i < paramLen; i++ ) {
							tmpParamArray[i] =  saveExcelAll.arguments[i];	
						}
						saveExcelAllWithNotCaption(tmpParamArray);
					}
				}
				
				function saveExcelAllWithCaption( sheetArray ) {
					
					// alert(gridCaptionArray);	
					
					var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						  
					if( fileName == "" )
						return;
						
					// var sheetArray = new Array("grd_bizprescondstats|업무현황",  "grd_patprescondstats|환자현황", "grd_hdstatsinfo|혈액투석현황", "grd_pdstatsinfo|복막투석현황", "grd_pdbizstatsinfo|복막투석업무현황");

	                              var sheetArrayLen = sheetArray.length;
					
					var gridId;
					var gridObj;
					for( var i = 0; i < sheetArray.length; i++ ) {
						
						gridId = sheetArray[i].split("|")[0]; 
						gridObj = document.all.item(gridId);
						// saveText() 함수는 Caption저장이 불가능 하여 SaveExcel()을 이용한다.
						gridObj.saveExcel("C:\\Temp\\tmp_TFExcel_" + i +".xls");
					}							    
					
					// excel application 실행함
		                      tfexcel.launchnewinstance(0);
								
		                       //실행된 excel application에서 새로운 workbook을 생성
					tfexcel.createworkbook();
		                      
					tfexcel.activatesheet(1);
		                      
					var sheetName;
					var nResult;
					for( var i = 0; i  < sheetArrayLen; i++ ) 
		                      {
		                      		sheetName = sheetArray[i].split("|")[1];
		                      		
		                      		if( i > 1 ) {
							nResult = tfexcel.activatesheet(i+1);
							tfexcel.sheetname(i+1) = sheetName;
						}
						else {
							nResult = tfexcel.addsheet(i+1, sheetName);	
						}
						if( nResult < 0 ) {
								messageBox(sheetName + " 저장을", "E009");
								// alert(sheetName + " 오류발생");
								return;
						}
						 tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
		                      }
		                      
		                      tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel.xls");	
				 
				 	//workbook을 저장.
					tfexcel.save(fileName);
										
					//excel application을 종료. excel application 생성 후 반드시 close해야함.
					tfexcel.close();
				 
				 	var fso = new ActiveXObject("Scripting.FileSystemObject");
					for( var i = 0; i  < sheetArrayLen; i++ ) {
						 fso.DeleteFile("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
					}	
					
					var rmsg = messageBox("저장된 Excel을", "Q004");
					// var rmsg = window.alert("저장된 Excel을 실행하시겠습니까?", "알림", 36);
					if( rmsg == 6 )
						window.exec("excel.exe", '\"' + fileName + '\"');	
				}
				
				function saveExcelAllWithNotCaption( sheetArray ) {
					
					// alert(gridCaptionArray);
					
					var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						  
					if( fileName == "" )
			  			return;

					 // excel application 실행함
					tfexcel.launchnewinstance(0);
							
		                       // 실행된 excel application에서 새로운 workbook을 생성
					tfexcel.createworkbook();
		                      
		                      // var sheetArray = new Array("grd_bizprescondstats|업무현황",  "grd_patprescondstats|환자현황", "grd_hdstatsinfo|혈액투석현황", "grd_pdstatsinfo|복막투석현황", "grd_pdbizstatsinfo|복막투석업무현황"); 
					var sheetArrayLen = sheetArray.length;
					var gridId;
					var gridObj;
					var sheetName;
					var nResult;
		                    
					for( var i = 0; i  < sheetArrayLen; i++ ) {
			
						gridId = sheetArray[i].split("|")[0]; 
						gridObj = document.all.item(gridId);

						sheetName = sheetArray[i].split("|")[1];
						
						if( i > 1 ) {
							nResult = tfexcel.activatesheet(i+1);
							tfexcel.sheetname(i+1) = sheetName;
						}
						else {
							nResult = tfexcel.addsheet(i+1, sheetName);	
						}
						if( nResult < 0 ) {
								messageBox(sheetName + " 저장을", "E009");
								// alert(sheetName + " 오류발생");
								return;
						}
						gridObj.saveText("C:\\Temp\\tmp_TFExcel.csv",  "\n", ",", '\:', true);
					        tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel.csv");		
					}
					
					//workbook을 저장.
					tfexcel.save(fileName);
										
					//excel application을 종료. excel application 생성 후 반드시 close해야함.
					tfexcel.close();
					
					// CSV File 삭제
  					var fso = new ActiveXObject("Scripting.FileSystemObject");
					fso.DeleteFile("C:\\Temp\\tmp_TFExcel.csv");		
					
					var rmsg = messageBox("저장된 Excel을", "Q004");
					// var rmsg = window.alert("저장된 Excel을 실행하시겠습니까?", "알림", 36);
					if( rmsg == 6 )
						window.exec("excel.exe", '\"' + fileName + '\"');		
				}

				function createTFExcel(tfExcelID, parentObj) {
					if( parentObj == null )
						parentObj = body;
					var tfExcelObj = parentObj.createChild("xforms:object", "id:" + tfExcelID + "; clsid:{fe8d1001-6a9d-424d-ae2a-301493bb12da}; left:100px; top:100px; width:100px; height:100px; ");
					return tfExcelObj;
				}
				/************************************************************************************************************************/	
				]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1168;" 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:220px; height:13px; ">가정간호 물품사용 내역</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:757px; width:1195px; height:27px; "/>
		<group id="group5" scroll="auto" style="left:0px; top:13px; width:1195px; height:742px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1195px; height:50px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button1" class="btn1_letter2" style="left:1014px; top:10px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						      fSrchgoodInfo(); // 물품사용 내역 조회
						]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:12px; top:15px; width:86px; height:17px; ">집계일시 :</caption>
				<caption id="caption3" style="left:194px; top:15px; width:20px; height:20px; font-weight:bold; ">~</caption>
				<input id="ipt_sumfromdd" ref="/root/main/cond/sumfromdd" class="input_search" inputtype="date" style="left:106px; top:14px; width:85px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
//		                      if(model.getValue("/root/main/cond/sumtodd") == getCurrentDate()) {
//                                        model.setValue("/root/main/cond/sumtotm"     , getCurrentTime().substr(0,4)); // 집계종료시간 (현재시간)
//                                    } else {
//                                        model.setValue("/root/main/cond/sumtotm"     , "2359"); // 집계종료시간 
//                                    }  
//                                    model.setValue("/root/main/cond/sumfromtm"  , "0000"); // 집계시작시간
//                                    ipt_sumfromtm.refresh();
//                                    ipt_sumtotm.refresh();				
						]]>
					</script>
				</input>
				<input id="ipt_sumtodd" ref="/root/main/cond/sumtodd" class="input_search" inputtype="date" style="left:209px; top:14px; width:85px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
//                                   if(model.getValue("/root/main/cond/sumtodd") == getCurrentDate()) {
//                                        model.setValue("/root/main/cond/sumtotm"     , getCurrentTime().substr(0,4)); // 집계종료시간 (현재시간)
//                                    } else {
//                                        model.setValue("/root/main/cond/sumtotm"     , "2359"); // 집계종료시간 
//                                    }  
//                                    model.setValue("/root/main/cond/sumfromtm"  , "0000"); // 집계시작시간
//                                    ipt_sumfromtm.refresh();
//                                    ipt_sumtotm.refresh();				
						]]>
					</script>
				</input>
				<select1 id="radio4" ref="/root/main/cond/prcpattrflag" class="radio_search" appearance="full" cellspacing="4" cols="3" vcellspacing="5" overflow="visible" style="left:405px; top:12px; width:145px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>재료</label>
							<value>1</value>
						</item>
						<item>
							<label>처치</label>
							<value>2</value>
						</item>
						<item>
							<label>전체</label>
							<value>3</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
				//		       fSrchSumPrcpInfo(); // 처방별 집계현황조회
						]]>
					</script>
				</select1>
				<button id="button3" class="btn1_letter2" style="left:1132px; top:10px; width:56px; height:22px; ">
					<caption>출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						     fExecPrint();
						]]>
					</script>
				</button>
				<button id="button9" class="btn1_letter2" style="left:1073px; top:10px; width:56px; height:22px; ">
					<caption>엑셀</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						       saveExcelAll( "grd_goodlist|물품사용내역", true);
						]]>
					</script>
				</button>
				<caption id="caption4" class="search_name" style="left:313px; top:15px; width:91px; height:17px; ">처방속성 :</caption>
				<line id="line13" class="line_4" style="x1:1002px; y1:5px; x2:1002px; y2:42px; "/>
			</group>
			<datagrid id="grd_goodlist" nodeset="/root/main/goodinfo/goodlist" class="datagrid2" caption="처방코드^처방명^단위^계^병원" colsep="^" colwidth="100, 300, 70, 50, 70" ellipsis="true" explorerbar="sort" mergecellsfixedrows="bycolrec" rowsep="|" tooltip="true" style="left:0px; top:102px; width:1195px; height:615px; ">
				<col ref="prcpcd" style="text-align:left; "/>
				<col ref="prcpnm" style="text-align:left; "/>
				<col ref="drugpackunit" style="text-align:center; "/>
				<col ref="totprcpcnt" style="text-align:right; "/>
				<col ref="hospprcpcnt" style="text-align:right; "/>
			</datagrid>
			<line id="line1" class="line_1" style="x1:0px; y1:97px; x2:1195px; y2:97px; "/>
			<line id="line6" class="line_3" style="x1:1194px; y1:97px; x2:1194px; y2:115px; border-color:#ffe4bb; border-left-style:solid; "/>
			<caption id="caption42" class="tit_2" style="left:5px; top:80px; width:131px; height:14px; ">물품사용 내역</caption>
			<object id="tfexcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" visibility="hidden" style="left:590px; top:20px; width:175px; height:30px; "/>
		</group>
	</xhtml:body>
</xhtml:html>