ru.bgcrm.dao

Class CustomerLinkDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.CommonLinkDAO

ru.bgcrm.dao.CustomerLinkDAO

public class CustomerLinkDAO
extends CommonLinkDAO

В перспективе нужно все линки свести в одну таблицу, пока сделано так для совместимости со старыми БД.

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
CustomerLinkDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	getColumnName()
protected EntityLogDAO	getEntityLogDAO()
java.util.List<Contract>	getLinkedContracts(int customerId)
java.util.List<Pair<java.lang.Integer,Contract>>	getLinkedContracts(java.lang.String contractTitle, boolean disableStrictMode)
java.util.List<Contract>	getLinkedContractsByCustomerIdAndContractTitle(int customerId, java.lang.String contractTitle, boolean strictMode)
java.util.List<Contract>	getLinkedContractsByTitle(java.lang.String contractTitle, boolean strictMode) Метод получения списка связанных договоров по его заголовку
protected java.lang.String	getObjectType()
protected java.lang.String	getTable()
void	searchCustomerByLink(SearchResult<Customer> searchResult, CommonObjectLink link)

Methods inherited from class ru.bgcrm.dao.CommonLinkDAO

addLink, addLinkAndLog, addLinkIfNotExist, copyLinks, copyLinks, deleteLink, deleteLinkAndLog, deleteLinksTo, deleteLinksWithType, deleteObjectLinks, getLinkDAO, getLinkedCustomer, getLinkedCustomers, getObjectLinksWithType, isLinkExists, prepareLink, updateLinkTitles

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Detail

CustomerLinkDAO

public CustomerLinkDAO(java.sql.Connection con)

Method Detail

getTable

protected java.lang.String getTable()

Specified by:

getTable in class CommonLinkDAO

getColumnName

protected java.lang.String getColumnName()

Specified by:

getColumnName in class CommonLinkDAO

getObjectType

protected java.lang.String getObjectType()

Specified by:

getObjectType in class CommonLinkDAO

getEntityLogDAO

protected EntityLogDAO getEntityLogDAO()

Specified by:

getEntityLogDAO in class CommonLinkDAO

searchCustomerByLink

public void searchCustomerByLink(SearchResult<Customer> searchResult,
                                 CommonObjectLink link)
                          throws BGException

Throws:

BGException

getLinkedContractsByTitle

public java.util.List<Contract> getLinkedContractsByTitle(java.lang.String contractTitle,
                                                          boolean strictMode)
                                                   throws BGException

Метод получения списка связанных договоров по его заголовку

Parameters:

contractTitle - заголовок запроса

strictMode - режим поиска, по аналогии с java - strict это equals, а !strict это contains

Returns:

Throws:

BGException

getLinkedContractsByCustomerIdAndContractTitle

public java.util.List<Contract> getLinkedContractsByCustomerIdAndContractTitle(int customerId,
                                                                               java.lang.String contractTitle,
                                                                               boolean strictMode)
                                                                        throws BGException

Throws:

BGException

getLinkedContracts

public java.util.List<Pair<java.lang.Integer,Contract>> getLinkedContracts(java.lang.String contractTitle,
                                                                           boolean disableStrictMode)
                                                                    throws BGException

Throws:

BGException

getLinkedContracts

public java.util.List<Contract> getLinkedContracts(int customerId)
                                            throws BGException

Overrides:

getLinkedContracts in class CommonLinkDAO

Throws:

BGException