Package ch.pschatzmann.edgar.reporting.marketshare

Class ValuesByCompanyAndYear

java.lang.Object

ch.pschatzmann.edgar.reporting.marketshare.ValuesByCompanyAndYear

All Implemented Interfaces:

ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>, ch.pschatzmann.common.table.ITableEx<ch.pschatzmann.common.table.Value>, java.io.Serializable

public class ValuesByCompanyAndYear
extends java.lang.Object
implements ch.pschatzmann.common.table.ITableEx<ch.pschatzmann.common.table.Value>

Calculates the total sales per company and year

Author:

pschatzmann

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor	Description
ValuesByCompanyAndYear()
ValuesByCompanyAndYear(java.util.List<java.lang.String> parameters)

Method Summary

Modifier and Type	Method	Description
ch.pschatzmann.common.table.ITableEx<ch.pschatzmann.common.table.Value>	addColumnKey(java.lang.String parameterName)
Table	getBaseTable()
int	getColumnCount()
java.lang.String	getColumnTitle(int col)
int	getRowCount()
java.util.List	getRowFieldNames()
java.util.List	getRowValue(int row)
java.lang.Double	getTotalSales(java.lang.String year, java.lang.String companyName)	We return the sales for the requested SIC code and year.
ch.pschatzmann.common.table.Value	getValue(int col, int row)

Methods inherited from interface ch.pschatzmann.common.table.ITable

getBaseTableOfClass, getBaseTables, getBaseTableWithFields, getColumnKeyIndex, getColumnKeyValues, getColumnTitleIndex, getColumnValues, isEmpty, toList

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ValuesByCompanyAndYear

public ValuesByCompanyAndYear(java.util.List<java.lang.String> parameters)
                       throws DataException,
                              java.lang.ClassNotFoundException,
                              java.sql.SQLException

Throws:

DataException

java.lang.ClassNotFoundException

java.sql.SQLException

ValuesByCompanyAndYear

public ValuesByCompanyAndYear()
                       throws DataException,
                              java.lang.ClassNotFoundException,
                              java.sql.SQLException

Throws:

DataException

java.lang.ClassNotFoundException

java.sql.SQLException

Method Detail

getRowFieldNames

public java.util.List getRowFieldNames()

Specified by:

getRowFieldNames in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getColumnCount

public int getColumnCount()

Specified by:

getColumnCount in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getColumnTitle

public java.lang.String getColumnTitle(int col)

Specified by:

getColumnTitle in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getRowCount

public int getRowCount()

Specified by:

getRowCount in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getRowValue

public java.util.List getRowValue(int row)

Specified by:

getRowValue in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getValue

public ch.pschatzmann.common.table.Value getValue(int col,
                                                  int row)

Specified by:

getValue in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getBaseTable

public Table getBaseTable()

Specified by:

getBaseTable in interface ch.pschatzmann.common.table.ITable<ch.pschatzmann.common.table.Value>

getTotalSales

public java.lang.Double getTotalSales(java.lang.String year,
                                      java.lang.String companyName)
                               throws java.text.ParseException

We return the sales for the requested SIC code and year. Please note that if we do not have the data for the full year available we report the last full year instead

Parameters:

year -

companyName -

Returns:

Throws:

java.text.ParseException

addColumnKey

public ch.pschatzmann.common.table.ITableEx<ch.pschatzmann.common.table.Value> addColumnKey(java.lang.String parameterName)

Specified by:

addColumnKey in interface ch.pschatzmann.common.table.ITableEx<ch.pschatzmann.common.table.Value>