custom_detailed_process_report.jsp

gistfile1.txt

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

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

<div class="center1020">
	<h2>Детальный отчёт по процессам (за выбранный период)</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://127.0.0.1:3306/bgerp?characterEncoding=UTF8" user="user" password="password"/>
			<sql:query dataSource="${data}" var="result">
			SELECT IFNULL(param_list_value.title, "нет данных") AS title, COUNT(IFNULL(param_list_value.title, "Нет данных")) AS quantity FROM process LEFT JOIN param_list ON param_list.id=process.id LEFT JOIN param_list_value ON param_list_value.id=param_list.value AND param_list_value.param_id=9 WHERE 1=1 AND status_dt >=? AND status_dt <=? GROUP BY param_list_value.title ORDER BY param_list_value.title LIMIT 100;

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

		<table style="width: 100%;" class="data mt1">
			<tr>
				<td>Название задачи</td>
				<td>Количество задач</td>
			</tr>	

			<c:forEach var="row" items="${result.rowsByIndex}">
			<%--<c:forEach var="row" items="${result.rows}">--%>
				<tr>
					<%--<td> <c:out value="${row.TimeToCall}"/></td>
					<td> <c:out value="${row.CallDuration}"/></td>
					<td> <c:out value="${row.Number}"/></td>--%>
					<td>${row[0]}</td>
					<td>${row[1]}</td>
				</tr>			
			</c:forEach>
		</table>

		<sql:setDataSource var="data" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/bgerp?characterEncoding=UTF8" user="user" password="password"/>
			<sql:query dataSource="${data}" var="result">
			SELECT COUNT(id) AS ALL_quantity 
			FROM process 
			WHERE 1=1 
			AND status_dt >=? 
			AND status_dt <=? 
			LIMIT 100;

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

		<table style="width: 100%;" class="data mt1">
			<tr>
				<td>Всего процессов (за выбранный период)</td>
			</tr>	

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

	</c:if>
</div>