<%--
Copyright (C) 2000 - 2013 Silverpeas
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
As a special exception to the terms and conditions of version 3.0 of
the GPL, you may redistribute this Program in connection with Free/Libre
Open Source Software ("FLOSS") applications as described in Silverpeas's
FLOSS exception. You should have received a copy of the text describing
the FLOSS exception, and it is also available here:
"http://www.silverpeas.org/docs/core/legal/floss_exception.html"
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU Affero General Public License for more details.
You should have received a copy of the GNU Affero General Public License
along with this program. If not, see .
--%>
<%@page import="com.silverpeas.util.StringUtil"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://www.silverpeas.com/tld/viewGenerator" prefix="view"%>
<%@ include file="imports.jsp" %>
<%@ include file="init.jsp.inc" %>
<%
String column = "";
String compare = "";
int cpp = 0;
String[] allColumns_rs = new String[1];
allColumns_rs[0] = connecteurJDBC.getString("comboTous");
String[] allCompares = {connecteurJDBC.getString("contient"), "=", "<=", ">=", "!=", ">", "<"};
String col = request.getParameter("colNumber");
String columnValueS = request.getParameter("columnValue");
String action = request.getParameter("Action");
String sort = request.getParameter("Sort");
String[] columns = (String[]) request.getParameterValues("columns");
String[] compares = (String[]) request.getParameterValues("compares");
String value = "";
String label = "";
String selected = "";
if (sort == null || sort.equals("")) {
sort = "desc";
} else {
connecteurJDBC.setSortType(sort);
}
if (columns != null) {
column = columns[0];
connecteurJDBC.setColumnReq(column);
} else {
column = connecteurJDBC.getColumnReq();
}
if (compares != null) {
compare = compares[0];
connecteurJDBC.setCompare(compare);
} else {
compare = connecteurJDBC.getCompare();
}
if ((columnValueS != null) && (!columnValueS.equals(connecteurJDBC.getColumnValue()))) {
connecteurJDBC.setColumnValue(columnValueS);
} else {
columnValueS = connecteurJDBC.getColumnValue();
}
if (col != null && !col.equals("")) {
cpp = Integer.parseInt(col);
}
String lastValidSqlReq = connecteurJDBC.getFullRequest();
if (action != null) {
if (action.equals("newSQLReq")) {
// do nothing ?
} else if (action.equals("sortColumn")) {
int index = lastValidSqlReq.toLowerCase().indexOf("order by");
if (index != -1) //** SCO ** d�j� une close order by
{
lastValidSqlReq = lastValidSqlReq.substring(0, index - 1);
}
lastValidSqlReq = lastValidSqlReq + " ORDER BY " + connecteurJDBC.getColumnName(cpp) + " "
+ connecteurJDBC.getSortType();
connecteurJDBC.setFullRequest(lastValidSqlReq);
}
}
%>
<%=connecteurJDBC.getString("windowTitleMain")%>
<%
browseBar.setExtraInformation(connecteurJDBC.getString("titreExecution"));
if (flag.equals("publisher") || flag.equals("admin")) {
tabbedPane = gef.getTabbedPane();
tabbedPane.addTab(connecteurJDBC.getString("tabbedPaneConsultation"), "DoRequest", true);
tabbedPane.addTab(connecteurJDBC.getString("tabbedPaneRequete"), "ParameterRequest", false);
}
if (flag.equals("admin")) {
tabbedPane.addTab(connecteurJDBC.getString("tabbedPaneParametresJDBC"), "ParameterConnection",
false);
}
Frame frame = gef.getFrame();
out.println(window.printBefore());
if (flag.equals("publisher") || flag.equals("admin")) {
out.println(tabbedPane.print());
}
out.println(frame.printBefore());
//Tableau
ArrayPane arrayPane = gef.getArrayPane("ResultSet", "Main", request, session);
arrayPane.setSortable(true);
arrayPane.setExportData(true);
arrayPane.setVisibleLineNumber(15);
if (lastValidSqlReq != null) {
connecteurJDBC.startConnection(lastValidSqlReq);
// Add the columns titles
allColumns_rs = new String[connecteurJDBC.getColumnCount()];
for (int i = 1; i <= connecteurJDBC.getColumnCount(); i++) {
arrayPane.addArrayColumn(connecteurJDBC.getColumnName(i));
allColumns_rs[i - 1] = connecteurJDBC.getColumnName(i);
}
arrayPane.setSortable(true);
while (connecteurJDBC.getNext()) {
// apply filter if needed
boolean rowIsOK = false;
if (column != null && compare != null && columnValueS != null
&& !"*".equals(column) && !"*".equals(compare) && !"".equals(columnValueS)) {
String theValue = connecteurJDBC.getString(Integer.parseInt(column));
if (theValue == null) {
rowIsOK = false;
} else if (connecteurJDBC.getString("contient").equals(compare)) {
if (theValue != null) {
rowIsOK = theValue.toLowerCase().indexOf(columnValueS.toLowerCase()) != -1;
}
} else {
int compareResult = theValue.compareToIgnoreCase(columnValueS);
if ("!=".equals(compare)) {
rowIsOK = (compareResult != 0);
}
if ("=".equals(compare)) {
rowIsOK = (compareResult == 0);
}
if (">=".equals(compare)) {
rowIsOK = (compareResult >= 0);
}
if ("<=".equals(compare)) {
rowIsOK = (compareResult <= 0);
}
if (">".equals(compare)) {
rowIsOK = (compareResult > 0);
}
if ("<".equals(compare)) {
rowIsOK = (compareResult < 0);
}
}
} else {
rowIsOK = true;
}
if (rowIsOK) {
ArrayLine arrayLine = arrayPane.addArrayLine();
for (int i = 1; i <= connecteurJDBC.getColumnCount(); i++) {
String val = connecteurJDBC.getString(i);
ArrayCellText champ = arrayLine.addArrayCellText(val);
if (val != null) {
if (StringUtil.isInteger(val)) {
champ.setCompareOn(Integer.parseInt(val));
} else {
champ.setCompareOn(val.toLowerCase());
}
} else {
champ.setCompareOn(null);
}
}
}
}
connecteurJDBC.closeConnection();
}
%>