ambit2.db.reporters.xlsx

Class StructureRecordXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>

java.lang.Object

net.idea.modbcum.p.DefaultAmbitProcessor<Target,Result>

net.idea.modbcum.p.AbstractDBProcessor<Q,Output>

net.idea.modbcum.r.QueryAbstractReporter<T,Q,Output>

net.idea.modbcum.r.QueryReporter<IStructureRecord,Q,Output>

ambit2.db.reporters.QueryStructureReporter<Q,Output>

ambit2.db.reporters.QueryHeaderReporter<Q,OutputStream>

ambit2.db.reporters.xlsx.AbstractXLSXReporter<Q>

ambit2.db.reporters.xlsx.StructureRecordXLSXReporter<Q>

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IDBProcessor<Q,OutputStream>, net.idea.modbcum.i.processors.IProcessor<Q,OutputStream>, net.idea.modbcum.i.reporter.Reporter<Q,OutputStream>

public class StructureRecordXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>
extends AbstractXLSXReporter<Q>

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	autosizecolumn
protected org.apache.poi.ss.usermodel.Font	blackFont
protected org.apache.poi.ss.usermodel.Font	blueFont
protected org.apache.poi.ss.usermodel.CellStyle	blueStyle
protected ProcessorStructureRetrieval	component
protected Dimension	d
protected StudyFormatter	formatter
protected org.apache.poi.ss.usermodel.CellStyle	hstyle
protected ImageReporter<Q>	imageReporter
protected AddDimensionedImage	imgHelper
protected Map<String,Integer>	mergedProperties
protected int	offset
protected org.apache.poi.ss.usermodel.Font	redFont
protected int	rowIndex
protected org.apache.poi.ss.usermodel.CellStyle	style

Fields inherited from class ambit2.db.reporters.xlsx.AbstractXLSXReporter

dataformat, fileExtension, out, sheet, workbook, writingStarted

Fields inherited from class ambit2.db.reporters.QueryHeaderReporter

groupProperties, header, includeMol, template

Fields inherited from class net.idea.modbcum.r.QueryAbstractReporter

autoCommit, batch, licenseURI, maxRecords, output, processors, showFooter, showHeader, startTime, timeout

Fields inherited from class net.idea.modbcum.p.AbstractDBProcessor

closeConnection, connection

Fields inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

enabled, logger, propertyChangeSupport

Constructor Summary

Constructors

Constructor and Description
StructureRecordXLSXReporter(String baseRef, boolean hssf, Template template, Profile groupedProperties, SubstanceEndpointsBundle[] bundles, String urlPrefix, boolean includeMol, String configResource)

Method Summary

Modifier and Type	Method and Description
protected void	addPicture(byte[] bytes, int row, int column)
protected void	addPicture(IStructureRecord record, int row, int column)
void	close()
protected void	configureProcessors(String baseRef, boolean includeMol)
void	footer(OutputStream output, Q query)
void	header(OutputStream output, Q query)
protected void	initColumns(int afterCol)
boolean	isAutosizeColumns()
Object	processItem(IStructureRecord item)
void	setAutosizeColumns(boolean autosizecolumn)
void	setConnection(Connection connection)

Methods inherited from class ambit2.db.reporters.xlsx.AbstractXLSXReporter

createRichTextString, getFileExtension

Methods inherited from class ambit2.db.reporters.QueryHeaderReporter

configurePropertyProcessors, getGroupProperties, getHeader, getTemplate, isIncludeMol, setGroupProperties, setTemplate, template2Header

Methods inherited from class ambit2.db.reporters.QueryStructureReporter

createBatch, isIncludeLicenseInTextFiles

Methods inherited from class net.idea.modbcum.r.QueryAbstractReporter

getLicenseURI, getMaxRecords, getOutput, getProcessors, getStartTime, getTimeout, isAutoCommit, isShowFooter, isShowHeader, process, setAutoCommit, setCloseConnection, setLicenseURI, setMaxRecords, setOutput, setProcessors, setShowFooter, setShowHeader, setStartTime, setTimeout, wrapup

Methods inherited from class net.idea.modbcum.p.AbstractDBProcessor

getConnection, isCloseConnection, isEnabled

Methods inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

addPropertyChangeListener, addPropertyChangeListener, getID, open, removePropertyChangeListener, removePropertyChangeListener, setEnabled, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface net.idea.modbcum.i.processors.IProcessor

getID, isEnabled, open, setEnabled

Field Detail

imageReporter

protected ImageReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>> imageReporter

component

protected ProcessorStructureRetrieval component

d

protected Dimension d

offset

protected int offset

rowIndex

protected int rowIndex

formatter

protected StudyFormatter formatter

mergedProperties

protected Map<String,Integer> mergedProperties

style

protected org.apache.poi.ss.usermodel.CellStyle style

hstyle

protected org.apache.poi.ss.usermodel.CellStyle hstyle

blueStyle

protected org.apache.poi.ss.usermodel.CellStyle blueStyle

blackFont

protected org.apache.poi.ss.usermodel.Font blackFont

blueFont

protected org.apache.poi.ss.usermodel.Font blueFont

redFont

protected org.apache.poi.ss.usermodel.Font redFont

autosizecolumn

protected boolean autosizecolumn

imgHelper

protected AddDimensionedImage imgHelper

Constructor Detail

StructureRecordXLSXReporter

public StructureRecordXLSXReporter(String baseRef,
                                   boolean hssf,
                                   Template template,
                                   Profile groupedProperties,
                                   SubstanceEndpointsBundle[] bundles,
                                   String urlPrefix,
                                   boolean includeMol,
                                   String configResource)

Method Detail

isAutosizeColumns

public boolean isAutosizeColumns()

setAutosizeColumns

public void setAutosizeColumns(boolean autosizecolumn)

setConnection

public void setConnection(Connection connection)
                   throws net.idea.modbcum.i.exceptions.DbAmbitException

Specified by:

setConnection in interface net.idea.modbcum.i.IDBProcessor<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Overrides:

setConnection in class net.idea.modbcum.p.AbstractDBProcessor<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Throws:

net.idea.modbcum.i.exceptions.DbAmbitException

close

public void close()
           throws Exception

Specified by:

close in interface net.idea.modbcum.i.processors.IProcessor<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Specified by:

close in interface net.idea.modbcum.i.reporter.Reporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Overrides:

close in class net.idea.modbcum.p.AbstractDBProcessor<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Throws:

Exception

header

public void header(OutputStream output,
                   Q query)

Specified by:

header in class net.idea.modbcum.r.QueryAbstractReporter<IStructureRecord,Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

footer

public void footer(OutputStream output,
                   Q query)

Overrides:

footer in class AbstractXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>

initColumns

protected void initColumns(int afterCol)

processItem

public Object processItem(IStructureRecord item)
                   throws Exception

Specified by:

processItem in class net.idea.modbcum.r.QueryAbstractReporter<IStructureRecord,Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Throws:

Exception

configureProcessors

protected void configureProcessors(String baseRef,
                                   boolean includeMol)

Overrides:

configureProcessors in class QueryHeaderReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

addPicture

protected void addPicture(IStructureRecord record,
                          int row,
                          int column)
                   throws net.idea.modbcum.i.exceptions.AmbitException

Throws:

net.idea.modbcum.i.exceptions.AmbitException

addPicture

protected void addPicture(byte[] bytes,
                          int row,
                          int column)
                   throws IOException

Throws:

IOException