Package com.openindex.openestate.tool.crm.db.hsql

Class HSqlDbCrmActivityHandler

java.lang.Object

com.openindex.openestate.tool.crm.db.DbCrmActivityHandlerImpl

com.openindex.openestate.tool.crm.db.hsql.HSqlDbCrmActivityHandler

All Implemented Interfaces:

DbCrmActivityHandler

public class HSqlDbCrmActivityHandler
extends DbCrmActivityHandlerImpl

HSqlDbCrmActivityHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	PROC_REMOVE_ACTIVITIES
static String	PROC_REMOVE_ACTIVITIES_CONTACTS_ENTRIES
static String	PROC_SAVE_ACTIVITIES
static String	PROC_SAVE_ACTIVITIES_CONTACTS_ENTRIES
static String	TABLE_ACTIVITIES
static String	TABLE_ACTIVITIES_CONTACTS_ENTRIES
static String	VIEW_ACTIVITIES
static String	VIEW_ACTIVITIES_CONTACTS_ENTRIES

Constructor Summary

Constructors

Constructor	Description
HSqlDbCrmActivityHandler()

Method Summary

Modifier and Type	Method	Description
DbCrmActivity[]	getActivities(Connection c, long[] ids)
DbCrmActivity[]	getActivities(Connection c, DbCrmActivity.Type type)
DbCrmActivity[]	getActivities(Connection c, Date begin, Date end)
DbCrmActivity[]	getActivitiesByKeyword(Connection c, String keyword, DbCrmActivity.Type[] types, int limit)
DbCrmActivity[]	getActivitiesForContact(Connection c, long[] contactEntryIds, DbCrmActivity.Type type)
long[]	getActivityIds(Connection c, long[] contactEntryIds, DbCrmActivity.Type type)
void	loadContactEntries(Connection c, DbCrmActivity[] activities)
void	removeActivities(Connection c, long[] ids)
void	removeActivityContactEntries(Connection c, long activityId, long[] contactEntryIds)
void	saveActivity(Connection c, DbCrmActivity activity)
void	saveActivityContactEntries(Connection c, long activityId, long[] contactEntryIds)

Methods inherited from class com.openindex.openestate.tool.crm.db.DbCrmActivityHandlerImpl

buildActivity, getActivities, getActivitiesByKeyword, getActivitiesByKeyword, getActivitiesByKeyword, getActivitiesForContact, getActivitiesForContact, getActivitiesForContact, getActivity, getActivityIds, getActivityIds, getActivityIds, getActivityIds, getActivityIds, loadContactEntries, removeActivity, removeActivityContactEntry, saveActivityContactEntry

Methods inherited from class java.lang.Object

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

Field Detail

PROC_REMOVE_ACTIVITIES

public static final String PROC_REMOVE_ACTIVITIES

See Also:

Constant Field Values

PROC_REMOVE_ACTIVITIES_CONTACTS_ENTRIES

public static final String PROC_REMOVE_ACTIVITIES_CONTACTS_ENTRIES

See Also:

Constant Field Values

PROC_SAVE_ACTIVITIES

public static final String PROC_SAVE_ACTIVITIES

See Also:

Constant Field Values

PROC_SAVE_ACTIVITIES_CONTACTS_ENTRIES

public static final String PROC_SAVE_ACTIVITIES_CONTACTS_ENTRIES

See Also:

Constant Field Values

VIEW_ACTIVITIES

public static final String VIEW_ACTIVITIES

See Also:

Constant Field Values

VIEW_ACTIVITIES_CONTACTS_ENTRIES

public static final String VIEW_ACTIVITIES_CONTACTS_ENTRIES

See Also:

Constant Field Values

TABLE_ACTIVITIES

public static final String TABLE_ACTIVITIES

See Also:

Constant Field Values

TABLE_ACTIVITIES_CONTACTS_ENTRIES

public static final String TABLE_ACTIVITIES_CONTACTS_ENTRIES

See Also:

Constant Field Values

Constructor Detail

HSqlDbCrmActivityHandler

public HSqlDbCrmActivityHandler()

Method Detail

getActivities

public DbCrmActivity[] getActivities(Connection c,
                                     DbCrmActivity.Type type)
                              throws SQLException

Specified by:

getActivities in interface DbCrmActivityHandler

Specified by:

getActivities in class DbCrmActivityHandlerImpl

Throws:

SQLException

getActivities

public DbCrmActivity[] getActivities(Connection c,
                                     long[] ids)
                              throws SQLException

Specified by:

getActivities in interface DbCrmActivityHandler

Specified by:

getActivities in class DbCrmActivityHandlerImpl

Throws:

SQLException

getActivities

public DbCrmActivity[] getActivities(Connection c,
                                     Date begin,
                                     Date end)
                              throws SQLException

Specified by:

getActivities in interface DbCrmActivityHandler

Specified by:

getActivities in class DbCrmActivityHandlerImpl

Throws:

SQLException

getActivitiesByKeyword

public DbCrmActivity[] getActivitiesByKeyword(Connection c,
                                              String keyword,
                                              DbCrmActivity.Type[] types,
                                              int limit)
                                       throws SQLException

Specified by:

getActivitiesByKeyword in interface DbCrmActivityHandler

Specified by:

getActivitiesByKeyword in class DbCrmActivityHandlerImpl

Throws:

SQLException

getActivitiesForContact

public DbCrmActivity[] getActivitiesForContact(Connection c,
                                               long[] contactEntryIds,
                                               DbCrmActivity.Type type)
                                        throws SQLException

Specified by:

getActivitiesForContact in interface DbCrmActivityHandler

Specified by:

getActivitiesForContact in class DbCrmActivityHandlerImpl

Throws:

SQLException

getActivityIds

public long[] getActivityIds(Connection c,
                             long[] contactEntryIds,
                             DbCrmActivity.Type type)
                      throws SQLException

Specified by:

getActivityIds in interface DbCrmActivityHandler

Specified by:

getActivityIds in class DbCrmActivityHandlerImpl

Throws:

SQLException

loadContactEntries

public void loadContactEntries(Connection c,
                               DbCrmActivity[] activities)
                        throws SQLException

Specified by:

loadContactEntries in interface DbCrmActivityHandler

Specified by:

loadContactEntries in class DbCrmActivityHandlerImpl

Throws:

SQLException

removeActivities

public void removeActivities(Connection c,
                             long[] ids)
                      throws SQLException

Specified by:

removeActivities in interface DbCrmActivityHandler

Specified by:

removeActivities in class DbCrmActivityHandlerImpl

Throws:

SQLException

removeActivityContactEntries

public void removeActivityContactEntries(Connection c,
                                         long activityId,
                                         long[] contactEntryIds)
                                  throws SQLException

Specified by:

removeActivityContactEntries in interface DbCrmActivityHandler

Specified by:

removeActivityContactEntries in class DbCrmActivityHandlerImpl

Throws:

SQLException

saveActivity

public void saveActivity(Connection c,
                         DbCrmActivity activity)
                  throws SQLException

Specified by:

saveActivity in interface DbCrmActivityHandler

Specified by:

saveActivity in class DbCrmActivityHandlerImpl

Throws:

SQLException

saveActivityContactEntries

public void saveActivityContactEntries(Connection c,
                                       long activityId,
                                       long[] contactEntryIds)
                                throws SQLException

Specified by:

saveActivityContactEntries in interface DbCrmActivityHandler

Specified by:

saveActivityContactEntries in class DbCrmActivityHandlerImpl

Throws:

SQLException