net.sf.jasperreports.engine.query.AbstractXlsQueryExecuter Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jasperreports Show documentation
Show all versions of jasperreports Show documentation
Free Java Reporting Library
/*
* JasperReports - Free Java Reporting Library.
* Copyright (C) 2001 - 2019 TIBCO Software Inc. All rights reserved.
* http://www.jaspersoft.com
*
* Unless you have purchased a commercial license agreement from Jaspersoft,
* the following license terms apply:
*
* This program is part of JasperReports.
*
* JasperReports is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* JasperReports 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 Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with JasperReports. If not, see .
*/
package net.sf.jasperreports.engine.query;
import java.text.DateFormat;
import java.text.NumberFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.TimeZone;
import net.sf.jasperreports.engine.DefaultJasperReportsContext;
import net.sf.jasperreports.engine.JRDataset;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRField;
import net.sf.jasperreports.engine.JRParameter;
import net.sf.jasperreports.engine.JRPropertiesUtil.PropertySuffix;
import net.sf.jasperreports.engine.JRValueParameter;
import net.sf.jasperreports.engine.JasperReportsContext;
import net.sf.jasperreports.engine.data.AbstractXlsDataSource;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
/**
* Excel query executer implementation.
*
* @author Sanda Zaharia ([email protected])
*/
public abstract class AbstractXlsQueryExecuter extends JRAbstractQueryExecuter {
private static final Log log = LogFactory.getLog(AbstractXlsQueryExecuter.class);
private AbstractXlsDataSource datasource;
/**
*
*/
protected AbstractXlsQueryExecuter(
JasperReportsContext jasperReportsContext,
JRDataset dataset,
Map parametersMap
)
{
this(SimpleQueryExecutionContext.of(jasperReportsContext),
dataset, parametersMap);
}
protected AbstractXlsQueryExecuter(
QueryExecutionContext context,
JRDataset dataset,
Map parametersMap
)
{
super(context, dataset, parametersMap);
}
protected AbstractXlsQueryExecuter(JRDataset dataset, Map parametersMap)
{
this(DefaultJasperReportsContext.getInstance(), dataset, parametersMap);
}
protected void initDatasource(AbstractXlsDataSource datasource) throws JRException
{
this.datasource = datasource;
if (datasource != null) {
// build column names list
List columnNamesList = null;
@SuppressWarnings("deprecation")
String columnNames = getStringParameterOrProperty(JRXlsxQueryExecuterFactory.XLSX_COLUMN_NAMES);
if (columnNames == null)
{
columnNames = getStringParameterOrProperty(AbstractXlsQueryExecuterFactory.XLS_COLUMN_NAMES);
}
if(columnNames != null) {
columnNamesList = new ArrayList();
columnNamesList.add(columnNames);
} else {
@SuppressWarnings("deprecation")
String[] columnNamesArray = (String[]) getParameterValue(JRXlsxQueryExecuterFactory.XLSX_COLUMN_NAMES_ARRAY, true);
if (columnNamesArray == null)
{
columnNamesArray = (String[]) getParameterValue(AbstractXlsQueryExecuterFactory.XLS_COLUMN_NAMES_ARRAY, true);
}
if(columnNamesArray != null) {
columnNamesList = Arrays.asList(columnNamesArray);
} else {
@SuppressWarnings("deprecation")
String propertiesPrefix = JRXlsxQueryExecuterFactory.XLSX_COLUMN_NAMES;
List properties = getPropertiesUtil().getAllProperties(dataset, propertiesPrefix);
if (properties != null && !properties.isEmpty())
{
columnNamesList = new ArrayList();
for(int i = 0; i < properties.size(); i++) {
PropertySuffix property = properties.get(i);
columnNamesList.add(property.getValue());
}
}
else
{
propertiesPrefix = AbstractXlsQueryExecuterFactory.XLS_COLUMN_NAMES;
properties = getPropertiesUtil().getAllProperties(dataset, propertiesPrefix);
if (properties != null && !properties.isEmpty())
{
columnNamesList = new ArrayList();
for(int i = 0; i < properties.size(); i++) {
PropertySuffix property = properties.get(i);
columnNamesList.add(property.getValue());
}
}
else
{
JRField[] fields = dataset.getFields();
if (fields != null && fields.length > 0)
{
columnNamesList = new ArrayList();
for (int i = 0; i < fields.length; i++)
{
columnNamesList.add(fields[i].getName());
}
}
}
}
}
}
List splitColumnNamesList = null;
if (columnNamesList != null && columnNamesList.size() > 0) {
splitColumnNamesList = new ArrayList();
for(int i = 0; i < columnNamesList.size(); i++) {
String names = columnNamesList.get(i);
for(String token: names.split(",")){
splitColumnNamesList.add(token.trim());
}
}
}
// build column indexes list
List columnIndexesList = null;
@SuppressWarnings("deprecation")
String columnIndexes = getStringParameterOrProperty(JRXlsxQueryExecuterFactory.XLSX_COLUMN_INDEXES);
if (columnIndexes == null)
{
columnIndexes = getStringParameterOrProperty(AbstractXlsQueryExecuterFactory.XLS_COLUMN_INDEXES);
}
if (columnIndexes != null) {
columnIndexesList = new ArrayList();
for (String colIndex: columnIndexes.split(",")){
columnIndexesList.add(Integer.valueOf(colIndex.trim()));
}
} else {
@SuppressWarnings("deprecation")
Integer[] columnIndexesArray = (Integer[]) getParameterValue(JRXlsxQueryExecuterFactory.XLSX_COLUMN_INDEXES_ARRAY, true);
if (columnIndexesArray == null)
{
columnIndexesArray = (Integer[]) getParameterValue(AbstractXlsQueryExecuterFactory.XLS_COLUMN_INDEXES_ARRAY, true);
}
if (columnIndexesArray != null) {
columnIndexesList = Arrays.asList(columnIndexesArray);
} else {
@SuppressWarnings("deprecation")
String propertiesPrefix = JRXlsxQueryExecuterFactory.XLSX_COLUMN_INDEXES;
List properties = getPropertiesUtil().getAllProperties(dataset, propertiesPrefix);
if (properties != null && !properties.isEmpty())
{
columnIndexesList = new ArrayList();
for(int i = 0; i < properties.size(); i++) {
String propertyValue = properties.get(i).getValue();
for (String colIndex: propertyValue.split(",")){
columnIndexesList.add(Integer.valueOf(colIndex.trim()));
}
}
}
else
{
propertiesPrefix = AbstractXlsQueryExecuterFactory.XLS_COLUMN_INDEXES;
properties = getPropertiesUtil().getAllProperties(dataset, propertiesPrefix);
if (properties != null && !properties.isEmpty())
{
columnIndexesList = new ArrayList();
for(int i = 0; i < properties.size(); i++) {
String propertyValue = properties.get(i).getValue();
for (String colIndex: propertyValue.split(",")){
columnIndexesList.add(Integer.valueOf(colIndex.trim()));
}
}
}
}
}
}
// set column names or column indexes or both
if (splitColumnNamesList != null) {
if (columnIndexesList != null) {
int[] indexesArray = new int[columnIndexesList.size()];
for (int i=0; i 0)
{
datasource.setSheetSelection(sheetSelection);
}
}
}
@Override
public void close() {
if(datasource != null){
datasource.close();
}
}
@Override
public boolean cancelQuery() throws JRException {
return false;
}
@Override
protected String getParameterReplacement(String parameterName) {
return String.valueOf(getParameterValue(parameterName));
}
}