YNU_JEUS/app_home/himed/webapps/crm/statisticsweb/xrw/SMCSN00500_기관별SMS전송통계.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>Untitle</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<statlist/>
						</list>
					</main>
					<send>
						<data>
							<fromdd/>
							<todd/>
							<srchvsinstcd/>
							<srchcond/>
							<year/>
							<month/>
							<srchbizflag/>
							<srchbizdetlcd/>
							<logo_pic/>
						</data>
					</send>
					<init>
						<A0607list>
							<A0607>
								<cdnm/>
								<cdid/>
							</A0607>
						</A0607list>
						<C0028list>
							<C0028>
								<cdnm/>
								<cdid/>
							</C0028>
						</C0028list>
					</init>
					<hidden>
						<itemset>
							<item>
								<lbl/>
								<val/>
							</item>
						</itemset>
					</hidden>
					<temp>
						<printlist>
						</printlist>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					// 공통코드 조회
					zbcfGetCodeList(new Array("A0607", "C0028"), new Array("/root/init/A0607list", "/root/init/C0028list"), false);
					fInsertInstance("C0028", "전체", "");
					
					
					var syscd = "CRM" + getUserInfo("dutplceinstcd");
					var piclogo = getLogoImageURL(syscd);
					model.setValue("/root/send/data/logo_pic", piclogo);
					
					
					fInitialize();
					
					
					
					model.refresh();
				]]>
			</script>
			<submission id="TRZBC00101" method="post" replace="instance"/>
			<bind id="bind1" ref="/root/main/list/msglist/isselected" readonly="../rsrvyn = '0' or (../rsrvyn = '1' and ../msgstate != 'ZM00')"/>
			<submission id="TRZBC00102" mediatype="application/x-www-form-urlencoded" method="post" replace="instance"/>
			<submission id="TRCSN00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" resultref="/root/main/list"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.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/shortmsgweb/js/ZMS00400.js"/>
		<script type="javascript" src="../../../com/shortmsgweb/js/ZMS001.js"/>
		<script type="javascript">
			<![CDATA[
				function fInitialize(){
					
					// 그리드 공라인 없애기
					model.removeNodeset("/root/main/list01/griduncoinfo");
					model.refresh();
				
					var curDate = getCurrentDate();
					var currentYear = getNewDate().getFullYear();
					var currentMonth= getNewDate().getMonth() + 1;
					var currentMonth   = (("" + currentMonth).length == 1) ? "0" + currentMonth : "" + currentMonth;
					var piclogo = getLogoImageURL();
					
					
					
					makeSrchYearItem();
					model.setValue("/root/send/data/fromdd",curDate);
					model.setValue("/root/send/data/todd",curDate);
					model.setValue("/root/send/data/year", currentYear);
					model.setValue("/root/send/data/month", currentMonth);
					model.setValue("/root/send/data/logo_pic", piclogo);

					
					
//					btn_save.disabled = !checkAuth("X");
//					makeReportPreview(0,112,1195,630);
//					submit("TRCSN00102");
					
				}
				function fInsertInstance(cdGroupID, codeName, codeID) {
					//model.refresh();
					
					model.copyNode("/root/hidden/comcd","/root/init/comcd");
				
					var nodelist = instance1.selectNodes("/root/hidden/comcd/"+cdGroupID);
				
					var newNode = instance1.createNode("element", cdGroupID, "");
				
					var childnode1 = instance1.createNode("element", "cdid", "");
					var childnode2 = instance1.createNode("element", "cdnm", "");
					newNode.appendChild(childnode1);
					newNode.appendChild(childnode2);
				
					if (nodelist.length > 0)
					{
						var currNode = root.hidden.comcd.insertBefore(newNode, nodelist.item(0)); 
				
						model.setValue("/root/hidden/comcd/"+cdGroupID+"[1]/cdnm", codeName);
						model.setValue("/root/hidden/comcd/"+cdGroupID+"[1]/cdid", codeID);
					}
				} 
			
				function makeSrchYearItem() {
						
					// item 초기화
					model.removeNodeset("/root/hidden/itemset/item");
					
					// Temp Item Node 생성
					var tmpItemNode = instance1.createNode("element", "item", "");
					var tmpLabelNode = instance1.createNode("element", "lbl", "");
					var tmpValueNode = instance1.createNode("element", "val", "");
					tmpItemNode.appendChild(tmpLabelNode);
					tmpItemNode.appendChild(tmpValueNode);
				
					// 현재 Year
					var curYear = getNewDate().getFullYear();
					// 초기 데이타가 2007년부터 있으므로
					var minYear = "2007"
					// Item Node
					var itemNode = null;
					
					for( var i = curYear; i >= minYear; i-- ) {
						
						tmpItemNode.lbl.text = i;
						tmpItemNode.val.text = i;
						
						// Temp Item Node 복사
						itemNode = tmpItemNode.cloneNode(true);					
						
						model.duplicate("/root/hidden/itemset", itemNode);
					}
					cmb_years.refresh();
					cmb_month.refresh();
				}
			
			// 시스템코드, 메시지종료, 메시지 번호가 입력되면 이들을 조합하여 메시지코드를 설정한다.
			function fSetMessageCode() {
				var syscd = model.getValue("/root/main/item/syscd");
				var msgkind = model.getValue("/root/main/item/msgkind");
				var msgno = model.getValue("/root/main/item/msgno");
				var msgcd = syscd + "." + msgkind + "." + msgno;
		    		model.setValue("/root/main/item/msgcd",msgcd);
		    		model.refresh();
			}
			
			
			function fGetStatList(){
				
				// 전송할 send 데이터 작성
				var year = model.getValue("/root/send/data/year");
				var month = model.getValue("/root/send/data/month");
				var srchcond = model.getValue("/root/send/data/srchcond");
				var fromdd = model.getValue("/root/send/data/fromdd");
				var todd = model.getValue("/root/send/data/todd");
			
			
				if (srchcond != "Y") // 전송일자일 경우
				{
					if (fromdd == "" && todd == "")
					{
						messageBox("전송일자를 ", "C001");
						return; // 리턴함
					}
					else if (fromdd  >  todd)
					{
						messageBox("시작일자가 종료일자보다 앞서있습니다. 수정해주십시오.", "E999");
						return;// 리턴함
					}
					else if (todd - fromdd > 10000)
					{
						messageBox("검색기간은 1년을 초과할 수 없습니다. 수정해주십시오.", "E999");
						return;// 리턴함
					}
			
				}
				else // 년/월일경우
				{
					// 해당월의 처음일자
					fromdd = year.toString() + month.toString() + "01";
			
					// 해당월의 마지막일자
					newDateObj = new Date(year, month, 0) ;
			
					todd = year.toString() + month.toString() + newDateObj.getDate();
				}
				
				//전송 할 값을 세팅
				model.setValue("/root/send/data/srchcond", fromdd);
				model.setValue("/root/send/data/todd", todd);
				
				if(submit("TRCSN00501")){
					
				}
			}
		
		
		]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1360;" 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:189px; height:14px; ">기관별 SMS 전송통계</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:750px; width:1195px; height:27px; ">
			<button id="btn_init" class="btn4_letter3" style="left:1126px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInitialize();
					]]>
				</script>
			</button>
			<line id="line32" class="line_6" style="x1:0px; y1:20px; x2:1194px; y2:20px; "/>
			<button id="btn_report13" class="btn4_letter3" visibility="hidden" style="left:1042px; top:3px; width:68px; height:22px; ">
				<caption>보고서</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					/*
						var sPrintYN     = "false"; // 출력 여부
						var sAutoCloseYN = "false"; // 미리보기 창닫기
						
						var iCount = getNodesetCount("/root/main/list/statlist");
						if (iCount > 0) {
							model.makeNode("/root/temp/printlist/fromdd");
							model.makeNode("/root/temp/printlist/todd");
							model.makeNode("/root/temp/printlist/year");
							model.makeNode("/root/temp/printlist/month");
							model.makeNode("/root/temp/printlist/logo_pic");
					
					
							model.makeValue("/root/temp/printlist/fromdd", model.getValue("/root/send/data/fromdd"));
							model.makeValue("/root/temp/printlist/todd", model.getValue("/root/send/data/todd"));
							model.makeValue("/root/temp/printlist/year", model.getValue("/root/send/data/year"));
							model.makeValue("/root/temp/printlist/month", model.getValue("/root/send/data/month"));
							model.makeValue("/root/temp/printlist/logo_pic", model.getValue("/root/send/data/logo_pic"));
							
							for (i = 1; i <= getNodesetCount("/root/main/list/statlist"); i++) {

								model.makeValue("/root/temp/printlist[" + i + "]/delivedd",grd_statlist.labelmatrix(i, 0));
								model.makeValue("/root/temp/printlist[" + i + "]/trsmcntcnt",grd_statlist.labelmatrix(i, 1));
								model.makeValue("/root/temp/printlist[" + i + "]/rsrtrsmcnt",grd_statlist.labelmatrix(i, 2));
								model.makeValue("/root/temp/printlist[" + i + "]/pssvtytrsmcnt",grd_statlist.labelmatrix(i, 3));
								model.makeValue("/root/temp/printlist[" + i + "]/succdcntcnt",grd_statlist.labelmatrix(i, 4));
								model.makeValue("/root/temp/printlist[" + i + "]/succdrate",grd_statlist.labelmatrix(i, 5));
								model.makeValue("/root/temp/printlist[" + i + "]/numbererrcnt",grd_statlist.labelmatrix(i, 6));
								model.makeValue("/root/temp/printlist[" + i + "]/timeoverlapexemptcnt",grd_statlist.labelmatrix(i, 7));
								model.makeValue("/root/temp/printlist[" + i + "]/overlapmsgcnt",grd_statlist.labelmatrix(i, 8));
								model.makeValue("/root/temp/printlist[" + i + "]/trsmingcnt",grd_statlist.labelmatrix(i, 9));
								model.makeValue("/root/temp/printlist[" + i + "]/errcnt",grd_statlist.labelmatrix(i, 10));
								model.makeValue("/root/temp/printlist[" + i + "]/wrongnumcnt",grd_statlist.labelmatrix(i, 11));
								model.makeValue("/root/temp/printlist[" + i + "]/termerrcnt",grd_statlist.labelmatrix(i, 12));
								model.makeValue("/root/temp/printlist[" + i + "]/norespcnt",grd_statlist.labelmatrix(i, 13));
								model.makeValue("/root/temp/printlist[" + i + "]/mrejectcnt",grd_statlist.labelmatrix(i, 14));
								model.makeValue("/root/temp/printlist[" + i + "]/retrsmcnt",grd_statlist.labelmatrix(i, 15));
								model.makeValue("/root/temp/printlist[" + i + "]/txqexpirecnt",grd_statlist.labelmatrix(i, 16));
								model.makeValue("/root/temp/printlist[" + i + "]/rrejectcnt",grd_statlist.labelmatrix(i, 17));
								model.makeValue("/root/temp/printlist[" + i + "]/etc",grd_statlist.labelmatrix(i, 18));
									
							}
							
							exeReportPreview("RPCSN00501_기관별SMS전송통계", "XMLSTR", "", "", sPrintYN , "", "", "", "", sAutoCloseYN, "", "", "", "", "", "", "", "", "", "", "");
							
							
						} else {
							messageBox("출력할 보고서 내용이 없습니다!!", "I");
						}
						*/
					]]>
				</script>
			</button>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:12px; width:1195px; height:740px; ">
			<caption id="caption26" class="tit_2" style="left:6px; top:102px; width:174px; height:13px; ">SMS 전송통계</caption>
			<line id="line9" class="line_1" style="x1:0px; y1:118px; x2:1194px; y2:118px; "/>
			<line id="line12" class="line_3" style="x1:0px; y1:735px; x2:1194px; y2:735px; "/>
			<datagrid id="grd_statlist" nodeset="/root/main/list/statlist" allowselection="true" caption="일자^발송전체건수^업무구분^업무구분^성공건수^성공율^기타^기타^기타^전송중^전송실패^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역^전송실패 세부내역|일자^발송전체건수^예약전송^수동전송^성공건수^성공율^번호오류^시간중복^중복메시지^전송중^전송실패^결번^단말기오류^무응답^메시지수신거부^재전송오류^TXQ Expire^거부됨^기타오류" colwidth="140, 91, 70, 70, 77, 55, 70, 70, 70, 61, 66, 72, 90, 100, 100, 100, 82, 82, 83" dataheight="25" defaultrows="0" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheight="25" style="left:0px; top:121px; width:1194px; height:614px; text-align:center; border-color:#808080; ">
				<col ref="delivedd" style="text-align:center; "/>
				<col ref="trsmcntcnt" style="text-align:center; "/>
				<col ref="rsrtrsmcnt" style="text-align:center; "/>
				<col ref="pssvtytrsmcnt" style="text-align:center; "/>
				<col ref="succdcntcnt" style="text-align:center; "/>
				<col ref="succdrate" style="text-align:center; "/>
				<col ref="numbererrcnt" style="text-align:center; "/>
				<col ref="timeoverlapexemptcnt" style="text-align:center; "/>
				<col ref="overlapmsgcnt" style="text-align:center; "/>
				<col ref="trsmingcnt" style="text-align:center; "/>
				<col ref="errcnt" style="text-align:center; "/>
				<col ref="wrongnumcnt" style="text-align:center; "/>
				<col ref="termerrcnt" style="text-align:center; "/>
				<col ref="norespcnt" style="text-align:center; "/>
				<col ref="mrejectcnt" style="text-align:center; "/>
				<col ref="retrsmcnt" style="text-align:center; "/>
				<col ref="txqexpirecnt" style="text-align:center; "/>
				<col ref="rrejectcnt" style="text-align:center; "/>
				<col ref="etc" style="text-align:center; "/>
				<script type="javascript" ev:event="oncopy">
					<![CDATA[
					grid_oncopy();
					]]>
				</script>
			</datagrid>
			<group id="group2" style="left:0px; top:14px; width:1194px; height:80px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:80px; "/>
				<button id="btn_search" class="btn1_letter2" style="left:1112px; top:28px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetStatList();
						
						]]>
					</script>
				</button>
				<line id="line1" class="line_4" style="x1:1096px; y1:11px; x2:1096px; y2:69px; "/>
				<input id="ipt_fromdd" ref="/root/send/data/fromdd" class="input_search" inputtype="date" format="yyyy-mm-dd" mask="exclude" style="left:92px; top:13px; width:85px; height:19px; ">
					<hint>
						<![CDATA[전송일자는 1년 미만의 기간을 입력하셔야 합니다.]]>
					</hint>
				</input>
				<caption id="cap_trsmdate" class="search_name" style="left:6px; top:13px; width:79px; height:17px; ">전송일자</caption>
				<input id="ipt_todd" ref="/root/send/data/todd" class="input_search" inputtype="date" format="yyyy-mm-dd" mask="exclude" style="left:202px; top:13px; width:85px; height:19px; ">
					<hint>
						<![CDATA[전송일자는 1년 미만의 기간을 입력하셔야 합니다.]]>
					</hint>
				</input>
				<caption id="caption1" style="left:182px; top:13px; width:20px; height:20px; ">~</caption>
				<select1 id="cmb_years" ref="/root/send/data/year" class="combo_s_essential" disabled="true" appearance="minimal" style="left:382px; top:13px; width:85px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/itemset/item">
							<label ref="lbl"/>
							<value ref="val"/>
						</itemset>
					</choices>
				</select1>
				<select id="chk_srchcond" ref="/root/send/data/srchcond" overflow="visible" appearance="full" style="left:301px; top:14px; width:76px; height:21px; font-weight:bolder; border-style:none; ">
					<choices>
						<item>
							<label>연도/월</label>
							<value>Y</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						// 값을 받아옴
						var srchcond = model.getValue("/root/send/data/srchcond");
						if(srchcond == "Y") // 선택된 상태이면
						{
							// 전송일자 비활성화
							ipt_fromdd.disabled =true;
							ipt_todd.disabled =true;
							
							// 연도/월 활성화
							cmb_years.disabled = false;
							cmb_month.disabled = false;
						}
						else
						{
							// 전송일자 비활성화
							ipt_fromdd.disabled =false;
							ipt_todd.disabled =false;
							
							// 연도/월 활성화
							cmb_years.disabled = true;
							cmb_month.disabled = true;
						}

						
						]]>
					</script>
				</select>
				<caption id="caption2" style="left:471px; top:11px; width:21px; height:25px; font-weight:bolder; ">년</caption>
				<select1 id="cmb_month" ref="/root/send/data/month" class="combo_s_essential" disabled="true" appearance="minimal" style="left:492px; top:13px; width:50px; height:19px; ">
					<choices>
						<item>
							<label>1</label>
							<value>01</value>
						</item>
						<item>
							<label>2</label>
							<value>02</value>
						</item>
						<item>
							<label>3</label>
							<value>03</value>
						</item>
						<item>
							<label>4</label>
							<value>04</value>
						</item>
						<item>
							<label>5</label>
							<value>05</value>
						</item>
						<item>
							<label>6</label>
							<value>06</value>
						</item>
						<item>
							<label>7</label>
							<value>07</value>
						</item>
						<item>
							<label>8</label>
							<value>08</value>
						</item>
						<item>
							<label>9</label>
							<value>09</value>
						</item>
						<item>
							<label>10</label>
							<value>10</value>
						</item>
						<item>
							<label>11</label>
							<value>11</value>
						</item>
						<item>
							<label>12</label>
							<value>12</value>
						</item>
					</choices>
				</select1>
				<caption id="caption3" style="left:547px; top:11px; width:21px; height:25px; font-weight:bolder; ">월</caption>
				<caption id="caption5" class="search_name" style="left:6px; top:50px; width:79px; height:17px; ">업무구분</caption>
				<select1 id="cmb_BizFlag" ref="/root/send/data/srchbizflag" class="combo_search" appearance="minimal" style="left:92px; top:47px; width:130px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/C0028list/C0028">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
						if ( model.getValue("/root/send/data/srchbizflag") == "3" ) {
							cmb_BizDetlCd.disabled = "false";
						} else {
							cmb_BizDetlCd.disabled = "true";
							model.setValue("/root/send/data/srchbizdetlcd", "");
							model.refresh();
						}
					]]>
					</script>
				</select1>
				<select1 id="cmb_BizDetlCd" ref="/root/send/data/srchbizdetlcd" class="combo_search" disabled="true" appearance="minimal" style="left:226px; top:47px; width:140px; height:19px; ">
					<choices>
						<item>
							<label>전체</label>
							<value/>
						</item>
						<item>
							<label>외래예약</label>
							<value>01</value>
						</item>
						<item>
							<label>검사예약</label>
							<value>03</value>
						</item>
						<item>
							<label>건진예약</label>
							<value>04</value>
						</item>
						<item>
							<label>가예약</label>
							<value>02</value>
						</item>
					</choices>
				</select1>
				<caption id="caption4" class="search_name" style="left:610px; top:13px; width:87px; height:17px; ">해당기관 :</caption>
				<select1 id="cmb_SrchVsInsrcd" ref="/root/send/data/srchvsinstcd" class="combo_search" appearance="minimal" style="left:700px; top:13px; width:130px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/A0607list/A0607">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
			</group>
			<button id="btn_save_excel" class="btn2_letter4" style="left:1129px; top:98px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var fromdd = model.getValue("/root/send/data/fromdd");
					var todd = model.getValue("/root/send/data/todd");
					var system = model.getValue("/root/send/data/srchvsinstcd");
					
					if(system == "") system = "전체"
					
					var excelFileName = "기관별SMS전송통계("+system+")_"+fromdd+"~"+ todd;
					var fileName = window.fileDialog("save", ",", false, excelFileName, "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");

					if (fileName != "")
					{
						//grd_ins_form_menuinfo.saveExcel(fileName,"exportfalserows:0;col_8:value;");
						grd_statlist.saveExcel(fileName);
					}
					]]>
				</script>
			</button>
			<button id="button1" class="btn2_letter3" style="left:1072px; top:98px; width:53px; height:19px; ">
				<caption>도움말</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					modal("SPZMS00200","","150","100","SPZMS00200", null, null);
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>