ambit2.db.reporters.xlsx

Class SubstanceRecordXLSXReporter<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.SubstanceRecordXLSXReporter<Q>

All Implemented Interfaces:

IStudyPrinter, 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 SubstanceRecordXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>
extends AbstractXLSXReporter<Q>
implements IStudyPrinter

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected org.apache.poi.ss.usermodel.Font	blackFont
protected org.apache.poi.ss.usermodel.Font	blueFont
protected StudyFormatter	formatter
protected org.apache.poi.ss.usermodel.CellStyle	hstyle
protected org.apache.poi.ss.usermodel.Font	redFont
protected int	rowIndex
protected org.apache.poi.ss.usermodel.CellStyle	sectionStyle
protected int	substanceIndex
protected org.apache.poi.ss.usermodel.CellStyle	tableStyle

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

dataformat, fileExtension, out, sheet, style, 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
SubstanceRecordXLSXReporter(String baseRef, boolean hssf, SubstanceEndpointsBundle[] bundles, String configResource)
SubstanceRecordXLSXReporter(String baseRef, boolean hssf, Template template, Profile groupedProperties, SubstanceEndpointsBundle[] bundles, String urlPrefix)

Method Summary

Modifier and Type	Method and Description
void	footer(OutputStream output, Q query)
void	header(OutputStream output, Q query)
void	print(int record, int column, int order, String value, boolean isResult, ReliabilityParams._r_flags studyResultType)
void	printHeader(int record, int column, int order, String value)
Object	processItem(IStructureRecord item)

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

createRichTextString, getFileExtension

Methods inherited from class ambit2.db.reporters.QueryHeaderReporter

configureProcessors, 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

close, getConnection, isCloseConnection, isEnabled, setConnection

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.reporter.Reporter

close

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

getID, isEnabled, open, setEnabled

Field Detail

rowIndex

protected int rowIndex

substanceIndex

protected int substanceIndex

formatter

protected StudyFormatter formatter

sectionStyle

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

hstyle

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

tableStyle

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

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

Constructor Detail

SubstanceRecordXLSXReporter

public SubstanceRecordXLSXReporter(String baseRef,
                                   boolean hssf,
                                   SubstanceEndpointsBundle[] bundles,
                                   String configResource)

SubstanceRecordXLSXReporter

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

Method Detail

printHeader

public void printHeader(int record,
                        int column,
                        int order,
                        String value)

Specified by:

printHeader in interface IStudyPrinter

print

public void print(int record,
                  int column,
                  int order,
                  String value,
                  boolean isResult,
                  ReliabilityParams._r_flags studyResultType)

Specified by:

print in interface IStudyPrinter

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>

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

footer

public void footer(OutputStream output,
                   Q query)

Overrides:

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