Package org.bgerp.plugin.bgb.getolt.dao
Class OltDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.plugin.bgb.getolt.dao.OltDAO
-
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, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoiddelete(int id) getAll()getByBillings(Set<String> billings) getById(int id) Filtered query by billing, status, vendor, and optional OLT IDs.getStale(int staleMinutes, int limit) intvoidinsertOrUpdate(Olt olt) intResets OLTs stuck in UPDATING status back to NEW (e.g.voidvoidupdatePortCount(int oltId, int portCount) voidupdateStatus(int oltId, OltStatus status) Methods inherited from class ru.bgcrm.dao.CommonDAO
deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert
-
Constructor Details
-
OltDAO
-
-
Method Details
-
getAll
- Throws:
SQLException
-
getByIp
- Throws:
SQLException
-
getById
- Throws:
SQLException
-
getStale
- Throws:
SQLException
-
update
- Throws:
SQLException
-
insert
- Throws:
SQLException
-
insertOrUpdate
- Throws:
SQLException
-
updateStatus
- Throws:
SQLException
-
resetStuckUpdating
Resets OLTs stuck in UPDATING status back to NEW (e.g. after server restart).- Returns:
- number of reset OLTs
- Throws:
SQLException
-
delete
- Throws:
SQLException
-
updatePortCount
- Throws:
SQLException
-
getDistinctBillings
- Throws:
SQLException
-
getDistinctVendors
- Throws:
SQLException
-
getDistinctStatuses
- Throws:
SQLException
-
getByBillings
- Throws:
SQLException
-
getFiltered
public List<Olt> getFiltered(Set<String> billings, Set<String> statuses, Set<String> vendors, Set<Integer> oltIds) throws SQLException Filtered query by billing, status, vendor, and optional OLT IDs. Empty sets mean "no filter".- Throws:
SQLException
-