Class ContractStockItemDao
java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.common.dao.AbstractDao<ContractStockItem>
ru.bitel.bgbilling.common.dao.AbstractIdDao<ContractStockItem>
ru.bitel.bgbilling.plugins.shop.server.dao.ContractStockItemDao
public class ContractStockItemDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<ContractStockItem>
-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
ru.bitel.bgbilling.common.dao.AbstractDao.ListParams -
Field Summary
Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
orderByPatternFields inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant
con, ERROR, fields, moduleId, SQL_ALL, SQL_AND, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_JOIN, SQL_LEFT_JOIN, SQL_LIMIT, SQL_NOT_IN, SQL_ON, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE, tableName -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptiongetByStockItemId(int stockItemId) intgetContractIdByStockItem(int stockItemId, Date dateFilter) protected ContractStockItemgetListByContractId(int contractId, boolean onlyActive) voidlist(SearchResult<ContractStockItem> searchResult, int contractId) protected voidupdateImpl(ContractStockItem contractStockItem) Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractIdDao
delete, executeUpdate, get, getAndDelete, getAndUpdate, loadData, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlInsertValues, sqlQuery, sqlUpdateSet, sqlWhereIdMethods inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
deleteImpl, dropTemporaryTable, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getQueryWithFilter, getSQLOrder, list, list, list, listCountImplPS, listImpl, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, queryPeriod, setPageRecordCount, updateMethods inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant
getPlaceholders, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam, sqlDelete, sqlDeleteBatch, sqlInsert, sqlInsertBatch, sqlInsertGetId, sqlInsertGetLongId, sqlInsertOnDuplicateKeyUpdate, sqlInsertSelect, sqlInsertUpdateById, sqlSelectCountAsInt, sqlUpdate, sqlUpdateBatchMethods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
error, error, error, getLogger, logError, logError, warn
-
Constructor Details
-
ContractStockItemDao
-
-
Method Details
-
getFromRS
- Specified by:
getFromRSin classru.bitel.bgbilling.common.dao.AbstractDao<ContractStockItem>- Throws:
SQLException
-
updateImpl
- Specified by:
updateImplin classru.bitel.bgbilling.common.dao.AbstractDao<ContractStockItem>- Throws:
SQLException
-
getListByContractId
public List<ContractStockItem> getListByContractId(int contractId, boolean onlyActive) throws SQLException - Throws:
SQLException
-
getContractIdByStockItem
- Parameters:
stockItemId- ID товара со складаdateFilter- фильтр по дате, вернёт date_from invalid input: '<' dateFilter и date_to > dateFilter- Returns:
- вернёт ID договора за которым данный товар закреплён или -1, если не закреплён
- Throws:
SQLException
-
getByStockItemId
- Throws:
SQLException
-
list
- Throws:
SQLException
-