Class DeviceDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.dao.DeviceDAO

public class DeviceDAO
extends CommonDAO

DAO for Device. Soft delete via deleted_at / deleted_by.

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

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

Field Summary

Fields inherited from class 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

Constructor	Description
DeviceDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	delete(int id, int userId)	Soft-delete.
static Device	fromRs(ResultSet rs)
Device	get(int id)
List<Device>	getList(boolean includeDeleted)
List<Device>	getList(boolean includeDeleted, int equipTypeId)
List<Device>	getListByParent(int parentDeviceId)
List<Device>	getListByStatus(String status)
void	restore(int id)	Restore soft-deleted device.
void	update(Device d, int userId)	Inserts or updates a device.

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

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

Constructor Details

DeviceDAO

public DeviceDAO(Connection con)

Method Details

getList

public List<Device> getList(boolean includeDeleted)
                     throws SQLException

Throws:

SQLException

getList

public List<Device> getList(boolean includeDeleted,
 int equipTypeId)
                     throws SQLException

Parameters:

equipTypeId - filters by exact equipment type id; 0 = no filter (all types)

Throws:

SQLException

getListByStatus

public List<Device> getListByStatus(String status)
                             throws SQLException

Throws:

SQLException

getListByParent

public List<Device> getListByParent(int parentDeviceId)
                             throws SQLException

Throws:

SQLException

get

public Device get(int id)
           throws SQLException

Throws:

SQLException

update

public void update(Device d,
 int userId)
            throws SQLException

Inserts or updates a device. Sets id on the object when inserting.

Throws:

SQLException

delete

public void delete(int id,
 int userId)
            throws SQLException

Soft-delete.

Throws:

SQLException

restore

public void restore(int id)
             throws SQLException

Restore soft-deleted device.

Throws:

SQLException

fromRs

public static Device fromRs(ResultSet rs)
                     throws SQLException

Throws:

SQLException