Ява класс
Код:
public class ManagerJob
{
private static final Logger log = Logger.getLogger( ManagerJob.class );
public List<String[]> getData()
{
Connection con = Setup.getSetup().getDBConnectionFromPool();
List<String> manager = new ArrayList<String>();
manager.add("Test");
return manager;
}
}
Это отчет, он с sql эм, и рабочий, много конечно ненужного, но не стоит обращать внимание, толькоо на нужное
Код:
# cat custom_report_executers.jsp
<%@ page import="java.util.Enumeration"%>
<%@ page import = "java.util.*" %>
<%@ page import = "java.net.*" %>
<%@ page import = "ru.bitel.common.sql.ConnectionSet.*" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.util.*" %>
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ include file="/WEB-INF/jspf/taglibs.jsp"%>
<div class="center1020">
<h2>Отчёт по исполнителям</h2>
<html:form action="/user/empty">
<input type="hidden" name="forwardFile" value="/WEB-INF/jspf/user/plugin/report/report/custom_report_executers.jsp"/>
Дата начала:
<ui:date-time paramName="date1" value="0"/>
Дата окончания:
<ui:date-time paramName="date2" value="0"/>
<br/>
<button type="button" class="btn-grey ml1 mt05" onclick="openUrlToParent( formUrl( this.form ), $(this.form) )">Сформировать</button>
</html:form>
<c:set var="date1" value="${u:parseDate( form.param.date1, 'ymd' ) }"/>
<c:set var="date2" value="${u:parseDate( form.param.date2, 'ymd' ) }"/>
<c:if test="${not empty date1}">
<%-- в случае, если Slave база не настроена - будет использована обычная --%>
<sql:query var="result" dataSource="${ctxSlaveDataSource}">
SELECT p.id, u.title, pt.title,
(SELECT count(p.id) FROM process AS p
LEFT JOIN process_type AS pt ON pt.id = p.type_id
LEFT JOIN process_executor AS pe ON pe.process_id = p.id
LEFT JOIN user AS u ON pe.user_id = u.id
LEFT JOIN param_list AS pl ON pl.id = p.id AND pl.param_id IN (26,42)
LEFT JOIN param_date AS pd ON pd.id = p.id
LEFT JOIN user_group AS ug ON ug.user_id = u.id
WHERE pd.param_id = 10 AND pd.value BETWEEN ? AND ? AND ug.group_id = 1),
nplv.title FROM process AS p
LEFT JOIN process_type AS pt ON pt.id = p.type_id
LEFT JOIN process_executor AS pe ON pe.process_id = p.id
LEFT JOIN param_list AS pl ON pl.id = p.id AND pl.param_id IN (26,42)
LEFT JOIN n_param_list_value AS nplv ON nplv.id = pl.value AND nplv.param_id = pl.param_id
LEFT JOIN user AS u ON pe.user_id = u.id
LEFT JOIN param_date AS pd ON pd.id = p.id
LEFT JOIN user_group AS ug ON ug.user_id = u.id
WHERE pd.param_id = 10 AND pd.value BETWEEN ? AND ? AND ug.group_id = 1
ORDER BY pt.title
<sql:param value="${date1}"/>
<sql:param value="${date2}"/>
<sql:param value="${date1}"/>
<sql:param value="${date2}"/>
</sql:query>
<u:newInstance var="test" clazz="ru.bgcrm.dyn.bghelp.ManagerJob"/>
<c:forEach var="row" items="${test.getData()}">
<c:set var="id" value="${row[0]}"/>
System.out.println("IP of my system " + ${id});
<%
String query = "SELECT id FROM process LIMIT 5";
System.out.println("IP of my system " + query);
%>
<table style="width: 100%;" class="data mt1">
<tr>
<td>ID</td>
<td>Исполнитель</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="executers" value="${row[1]}"/>
<c:set var="type" value="${row[2]}"/>
<c:set var="colT" value="${row[3]}"/>
<c:set var="vid" value="${row[4]}"/>
<c:set var="colV" value="${row[5]}"/>
<tr>
<td><a href="UNDEF" onclick="openProcess( ${id} ); return false;">${id}</a></td>
<td>${executers}</td>
<td>${type}</td>
<td>${colT}</td>
<td>${vid}</td>
<td>${colV}</td>
</tr>
</c:forEach>
</table>
</c:if>
</div>
Принт даже не вызвался, хелп ми
_________________
Код:
Клиент: вер. 6.2.714 / 25.05.2015 17:27:15
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
Сервер: вер. 6.2.881 / 22.05.2015 17:56:55
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
Помощь по администрированию bgbilling в jabber конференции или Группа в telegramСтиль программирования - пьяный мастерстер
Разработка мобильных приложений