public class CampaignTarget extends DBPersist
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
CampaignTarget() |
Modifier and Type | Method and Description |
---|---|
static int |
increaseTargetAchievement(JDCConnection oConn,
java.lang.String sGuWorkArea,
java.lang.String sGuZone,
java.lang.String sGuProduct,
float fQuantity)
Increase achieved sales of a given product for all active campaigns
|
float |
refreshTargetAchievement(JDCConnection oConn)
Lookup non cancelled orders at k_orders table and refresh achieved sales for this campaign target
|
boolean |
store(JDCConnection oConn)
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages
register insertions and updates.
|
allcaps, allcaps, clear, clone, columns, containsKey, containsValue, delete, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getIntArray, getInteger, getIntegerArray, getIntervalPart, getItemMap, getItems, getMoney, getPrimaryKey, getShort, getSQLDate, getSQLTime, getString, getStringHtml, getStringNull, getTable, getTable, getTime, getTimeOfDay, getTimestamp, isEmpty, isNull, iterator, keySet, load, load, parseXML, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, putAll, putAll, remove, remove, replace, replace, replace, replace, replace, replace, replace, replace, setAuditTransact, setAuditUser, setCreationDate, setPrimaryKey, size, toLowerCase, toUpperCase, toXML, toXML, toXML, values
public static final short ClassId
public boolean store(JDCConnection oConn) throws java.sql.SQLException
DBPersist
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages register insertions and updates. If the stored object already exists at database then it is updated, if it does not exists then it is inserted. A primary key violation error is never thrown so ther is no need to call delete() method before re-writing an existing object.
NULL fields : All values not set calling put() methods for DBPersist
will be assumed to be NULL. If a not nullable field is not set then an
SQLException will be raised.
On storing an already existing object all values will we overwrited,
so is a DBPersist is not fully loaded before storing it, values not set
by calling put() methods that already were present at database will be lost.
public float refreshTargetAchievement(JDCConnection oConn) throws java.sql.SQLException
oConn
- JDCConnectionjava.sql.SQLException
public static int increaseTargetAchievement(JDCConnection oConn, java.lang.String sGuWorkArea, java.lang.String sGuZone, java.lang.String sGuProduct, float fQuantity) throws java.sql.SQLException
oConn
- JDCConnectionsGuWorkArea
- String WorkArea GUIDsGuZone
- String GUID of thesauri Term representing the Geographic ZonesGuProduct
- String product GUIDfQuantity
- float Count of new products sold (if negative sales are decreased)java.sql.SQLException