Package 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	Description
CustomerLinkDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
protected String	getColumnName()
protected EntityLogDAO	getEntityLogDAO()
List<Contract>	getLinkedContracts(int customerId)
List<Pair<Integer,Contract>>	getLinkedContracts(String contractTitle, boolean disableStrictMode)
List<Contract>	getLinkedContractsByCustomerIdAndContractTitle(int customerId, String contractTitle, boolean strictMode)
List<Contract>	getLinkedContractsByTitle(String contractTitle, boolean strictMode)	Метод получения списка связанных договоров по его заголовку
protected String	getObjectType()
protected 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, getLinkingObjectLinksWithType, getObjectLinksWithType, isLinkExists, prepareLink, updateLinkTitles

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

CustomerLinkDAO

public CustomerLinkDAO(Connection con)

Method Details

getTable

protected String getTable()

Specified by:

getTable in class CommonLinkDAO

getColumnName

protected String getColumnName()

Specified by:

getColumnName in class CommonLinkDAO

getObjectType

protected 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 List<Contract> getLinkedContractsByTitle(String contractTitle,
 boolean strictMode)
                                         throws BGException

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

Parameters:

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

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

Returns:

Throws:

BGException

getLinkedContractsByCustomerIdAndContractTitle

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

Throws:

BGException

getLinkedContracts

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

Throws:

BGException

getLinkedContracts

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

Overrides:

getLinkedContracts in class CommonLinkDAO

Throws:

BGException