Package com.openindex.openestate.tool.contacts

Class ContactsEntryExportXlsTask

java.lang.Object

javax.swing.SwingWorker<T,V>

com.openindex.openestate.tool.ImmoToolTask<Long,Void>

com.openindex.openestate.tool.utils.XlsExportTask<DbContactsEntry>

com.openindex.openestate.tool.contacts.ContactsEntryExportXlsTask

All Implemented Interfaces:

ContactsEntryExportFields, PropertyChangeListener, Runnable, Future<Long>, RunnableFuture<Long>, EventListener

public class ContactsEntryExportXlsTask
extends XlsExportTask<DbContactsEntry>
implements ContactsEntryExportFields

ImmoToolTask zum Tabellenexport von Adressen im Excel-Format.

Author:

Andreas Rudolph

Nested Class Summary

Nested classes/interfaces inherited from class com.openindex.openestate.tool.ImmoToolTask

ImmoToolTask.Adapter, ImmoToolTask.Callback, ImmoToolTask.Listener

Nested classes/interfaces inherited from class javax.swing.SwingWorker

SwingWorker.StateValue

Field Summary

Fields inherited from interface com.openindex.openestate.tool.contacts.ContactsEntryExportFields

ACTIVE, ADDRESS_CITY, ADDRESS_COUNTRY, ADDRESS_DISTRICT, ADDRESS_LATITUDE, ADDRESS_LONGITUDE, ADDRESS_POSTALCODE, ADDRESS_REGION, ADDRESS_STREET, ADDRESS_STREETNR, COMPANY_BUSINESS, COMPANY_DEPARTMENT, COMPANY_FAX, COMPANY_LEGAL_FORM, COMPANY_MAIL, COMPANY_MOBILEPHONE, COMPANY_NAME, COMPANY_NAME_ADDITION, COMPANY_PHONE, COMPANY_POSITION, COMPANY_WEBSITE, CONTACT_ALLOWED, DETAILS_AUSWEIS_ART, DETAILS_AUSWEIS_BEHOERDE, DETAILS_AUSWEIS_NR, DETAILS_CITIZENSHIP, DETAILS_DAY_OF_BIRTH, DETAILS_KONTO_BIC, DETAILS_KONTO_BLZ, DETAILS_KONTO_IBAN, DETAILS_KONTO_INHABER, DETAILS_KONTO_INSTITUT, DETAILS_KONTO_NR, DETAILS_PLACE_OF_BIRTH, DETAILS_SPRACHEN, DETAILS_STEUER_IDNR, DETAILS_STEUER_NR, DETAILS_STEUER_UMSATZ_IDNR, DETAILS_WIRTSCHAFT_IDNR, FIELDCOUNT, GROUP, ID, NOTES, NR, PERSON_FAX, PERSON_FIRSTNAME, PERSON_GENDER, PERSON_LASTNAME, PERSON_LETTER_ADDRESS, PERSON_MAIL, PERSON_MIDDLENAME, PERSON_MOBILEPHONE, PERSON_PHONE, PERSON_TITLE

Constructor Summary

Constructors

Constructor	Description
ContactsEntryExportXlsTask(AbstractDbDriver dbDriver, DbContactsHandler contactsHandler, File exportFile, Charset charset)
ContactsEntryExportXlsTask(AbstractDbDriver dbDriver, DbContactsHandler contactsHandler, File exportFile, Charset charset, Long groupId)

Method Summary

Modifier and Type	Method	Description
protected Long	doInBackground()
protected DbContactsHandler	getContactsHandler()
protected String	getFieldTitle(int index)
protected int	getHeadlineRowspan()
protected String[]	getHeadlineValues(int index)
protected String[]	loadEmptyContainer()
protected DbContactsEntry[]	loadXlsObjects()
protected DbContactsEntry[]	loadXlsObjects(Connection c, DbContactsHandler contactsHandler)
protected void	writeValues(DbContactsEntry src, String[] dest)

Methods inherited from class com.openindex.openestate.tool.utils.XlsExportTask

createWorkbook, executeExport, getDbDriver, getFootlineFormat, getHeadlineFormat, getRow1Format, getRow2Format, getXlsFile, writeValue

Methods inherited from class com.openindex.openestate.tool.ImmoToolTask

addListener, cancelled, checkCancelled, createCallback, done, executeAndWait, executeAndWait, failed, finished, getDescription, getId, getMessage, getParentWindow, getTaskDialog, getTitle, isCancelException, isPending, isStarted, process, propertyChange, removeListener, setDescription, setMessage, setParentWindow, setProgress, setProgress, setProgress, setProgress, setTaskDialog, setTitle, succeeded

Methods inherited from class javax.swing.SwingWorker

addPropertyChangeListener, cancel, execute, firePropertyChange, get, get, getProgress, getPropertyChangeSupport, getState, isCancelled, isDone, publish, removePropertyChangeListener, run, setProgress

Methods inherited from class java.lang.Object

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

Constructor Detail

ContactsEntryExportXlsTask

public ContactsEntryExportXlsTask(AbstractDbDriver dbDriver,
                                  DbContactsHandler contactsHandler,
                                  File exportFile,
                                  Charset charset)

ContactsEntryExportXlsTask

public ContactsEntryExportXlsTask(AbstractDbDriver dbDriver,
                                  DbContactsHandler contactsHandler,
                                  File exportFile,
                                  Charset charset,
                                  Long groupId)

Method Detail

doInBackground

protected Long doInBackground()
                       throws Exception

Overrides:

doInBackground in class XlsExportTask<DbContactsEntry>

Throws:

Exception

getContactsHandler

protected DbContactsHandler getContactsHandler()

getFieldTitle

protected String getFieldTitle(int index)

Specified by:

getFieldTitle in class XlsExportTask<DbContactsEntry>

getHeadlineRowspan

protected int getHeadlineRowspan()

Overrides:

getHeadlineRowspan in class XlsExportTask<DbContactsEntry>

getHeadlineValues

protected String[] getHeadlineValues(int index)

Overrides:

getHeadlineValues in class XlsExportTask<DbContactsEntry>

loadEmptyContainer

protected String[] loadEmptyContainer()

Specified by:

loadEmptyContainer in class XlsExportTask<DbContactsEntry>

loadXlsObjects

protected DbContactsEntry[] loadXlsObjects()
                                    throws SQLException

Specified by:

loadXlsObjects in class XlsExportTask<DbContactsEntry>

Throws:

SQLException

loadXlsObjects

protected DbContactsEntry[] loadXlsObjects(Connection c,
                                           DbContactsHandler contactsHandler)
                                    throws SQLException

Throws:

SQLException

writeValues

protected void writeValues(DbContactsEntry src,
                           String[] dest)

Specified by:

writeValues in class XlsExportTask<DbContactsEntry>