Class ChangeLogDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.dao.ChangeLogDAO

public class ChangeLogDAO
extends CommonDAO

DAO for inventory_change_log — append-only pre/post JSON snapshot audit trail, shared across tracked object types (device, store, item, ...) via the object_type column.

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
ChangeLogDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
List<ChangeLogEntry>	getHistory(String objectType, int objectId)
void	log(String objectType, int objectId, String action, String preChange, String postChange, int userId)

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

ChangeLogDAO

public ChangeLogDAO(Connection con)

Method Details

log

public void log(String objectType,
 int objectId,
 String action,
 String preChange,
 String postChange,
 int userId)
         throws SQLException

Parameters:

preChange - JSON snapshot before the change, null for action="create"

postChange - JSON snapshot after the change

Throws:

SQLException

getHistory

public List<ChangeLogEntry> getHistory(String objectType,
 int objectId)
                                throws SQLException

Throws:

SQLException