<%@ 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="groups" value="${form.getSelectedValues( 'group' )}"/>
<c:set var="executors" value="${form.getSelectedValues( 'executor' )}"/>
<html:form action="/user/empty">
<input type="hidden" name="forwardFile" value="/WEB-INF/jspf/user/plugin/report/report/example_test.jsp"/>
<u:sc>
Дата закрытия:
<c:set var="uiid" value="${u:uiid()}"/>
<html:text property="date" styleId="${uiid}"/>
<c:set var="selector" value="#${uiid}"/>
<%@ include file="/WEB-INF/jspf/datetimepicker.jsp"%>
</u:sc>
<u:sc>
Дата закрытия:
<c:set var="uiid" value="${u:uiid()}"/>
<html:text property="date1" styleId="${uiid}"/>
<c:set var="selector" value="#${uiid}"/>
<%@ include file="/WEB-INF/jspf/datetimepicker.jsp"%>
</u:sc>
<div class="ml05" style="display: inline-block;">
<u:sc>
<c:set var="list" value="${ctxUserGroupList}"/>
<c:set var="prefixText" value="Группы:"/>
<c:set var="paramName" value="group"/>
<c:set var="values" value="${groups}"/>
<c:set var="widthTextValue" value="150px"/>
<c:set var="showFilter" value="1"/>
<%@ include file="/WEB-INF/jspf/combo_check.jsp"%>
</u:sc>
</div>
<div class="ml05" style="display: inline-block;">
<u:sc>
<c:set var="list" value="${ctxUserList}"/>
<c:set var="prefixText" value="Исполнители:"/>
<c:set var="paramName" value="executor"/>
<c:set var="values" value="${executors}"/>
<c:set var="widthTextValue" value="150px"/>
<c:set var="showFilter" value="1"/>
<%@ include file="/WEB-INF/jspf/combo_check.jsp"%>
</u:sc>
</div>
<button type="button" class="btn-grey ml1" onclick="openUrlToParent( formUrl( this.form ), $(this.form) )">Сформировать</button>
</html:form>
<c:set var="date" value="${u:parseDate( form.param.date, 'ymd' ) }"/>
<c:set var="date1" value="${u:parseDate( form.param.date, 'ymd' ) }"/>
<c:if test="${not empty date}">
<%-- в случае, если Slave база не настроена - будет использована обычная --%>
<sql:query var="result" dataSource="${ctxSlaveDataSource}">
SELECT process.id, process.description, status.title, DATE_FORMAT(process.create_dt, '%Y-%m-%d %H.%i.%s'), DATE_FORMAT(process.close_dt, '%Y-%m-%d %H.%i.%s')
FROM process
LEFT JOIN process_status_title AS status ON process.status_id=status.id
<c:if test="${not empty groups}">
INNER JOIN process_group AS pg ON process.id=pg.process_id AND pg.group_id IN(${u:toString( groups )})
</c:if>
<c:if test="${not empty executors}">
INNER JOIN process_executor AS pe ON process.id=pe.process_id AND pe.user_id IN(${u:toString( executors )})
</c:if>
WHERE close_dt>=? AND close_dt<DATE_ADD(?, INTERVAL 1 DAY)
ORDER BY process.id
<sql:param value="${date}"/>
<sql:param value="${date}"/>
</sql:query>
<table style="width: 100%;" class="data mt1">
<tr>
<td>ID</td>
<td>Описание</td>
<td>Статус</td>
<td>Создан</td>
<td>Закрыт</td>
</tr>
<c:forEach var="row" items="${result.rowsByIndex}">
<c:set var="id" value="${row[0]}"/>
<c:set var="description" value="${row[1]}"/>
<c:set var="status" value="${row[2]}"/>
<c:set var="createTime" value="${row[3]}"/>
<c:set var="closeTime" value="${row[4]}"/>
<tr>
<td><a href="UNDEF" onclick="openProcess( ${id} ); return false;">${id}</a></td>
<td>${description}</td>
<td>${status}</td>
<td>${createTime}</td>
<td>${closeTime}</td>
</tr>
</c:forEach>
</table>
</c:if>
</div>
Вход
Регистрация
FAQ
Поиск
