custom_asterisk_missed_calls.jsp

<%@ page import="java.util.Enumeration"%>

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ include file="/WEB-INF/jspf/taglibs.jsp"%>

<div class="center1020">
	<h2>Пропущенные звонки Asterisk (выводится максимум 1000 значений)</h2>

	<c:set var="datestart" value="${u:parseDate( form.param.datestart, 'ymdhms' ) }"/>
	<c:set var="dateend" value="${u:parseDate( form.param.dateend, 'ymdhms' ) }"/>

	<html:form action="/user/empty">
		<input type="hidden" name="forwardFile" value="${form.forwardFile}"/>

		<div>
			<b>Выбор даты и времени с: </b>
			<ui:date-time type="ymdhms" paramName="datestart" editable="1"/>
			<b> по: </b>
			<ui:date-time type="ymdhms" paramName="dateend" editable="1"/>
			</br>
			<button type="button" class="btn-grey ml1 mt05" onclick="openUrlToParent( formUrl( this.form ), $(this.form) )">Сформировать</button>
		</div>
	</html:form>

	<%--
	Генерация отчёта, если в запросе пришёл параметр date.	
	--%>		
	<c:if test="${not empty datestart and not empty dateend}">

		<sql:setDataSource var="data" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://ip:3306/qstats" user="user" password="password"/>
			<sql:query dataSource="${data}" var="result">
			SELECT DATE_FORMAT(datetime,'%Y-%m-%d %H:%i:%s') AS TimeToCall, TIME_FORMAT(TIMEDIFF(datetimeend, datetimeconnect),'%i:%s') AS CallDuration, clid AS Number FROM queue_stats_mv WHERE event = 'ABANDON' AND queue = 'support' AND datetime >=? AND datetime <=? LIMIT 1000;

			<sql:param value="${datestart}"/>
			<sql:param value="${dateend}"/>
		</sql:query>

		<table style="width: 100%;" class="data mt1">
			<tr>
				<td>Время звонка</td>
				<td>Продолжительность звонка</td>
				<td>Номер телефона</td>
			</tr>	

			<c:forEach var="row" items="${result.rowsByIndex}">
				<tr>
					<td>${row[0]}</td>
					<td>${row[1]}</td>
					<td>${row[2]}</td>
				</tr>			
			</c:forEach>
		</table>
	</c:if>
</div>