Class InvoiceNumberDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.bil.invoice.dao.InvoiceNumberDAO

public class InvoiceNumberDAO
extends CommonDAO

Builder DAO for retrieving next invoice counter number. At the end of uniqueness selection functions must be called next(), performing the SQL query and returning required value. Used from scripts.

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
InvoiceNumberDAO(Connection con, Invoice invoice)

Method Summary

Modifier and Type	Method	Description
InvoiceNumberDAO	month()	Selects for the current month.
int	next()	Selects the next counter value.
InvoiceNumberDAO	process()	Selects for the current process.

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

InvoiceNumberDAO

public InvoiceNumberDAO(Connection con,
 Invoice invoice)

Method Details

process

public InvoiceNumberDAO process()

Selects for the current process.

Returns:

month

public InvoiceNumberDAO month()

Selects for the current month.

Returns:

next

public int next()
         throws SQLException

Selects the next counter value. Terminating function.

Returns:

Throws:

SQLException