|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectit.eng.spagobi.commons.dao.AbstractHibernateDAO
it.eng.spagobi.kpi.config.dao.KpiDAOImpl
public class KpiDAOImpl
Field Summary |
---|
Fields inherited from class it.eng.spagobi.commons.dao.AbstractHibernateDAO |
---|
TENANT_FILTER_NAME |
Constructor Summary | |
---|---|
KpiDAOImpl()
|
Method Summary | |
---|---|
java.lang.Integer |
countKpis()
|
boolean |
deleteKpi(java.lang.Integer kpiId)
|
boolean |
deleteKpiRel(java.lang.Integer kpiRelId)
|
void |
deleteKpiValueFromInterval(java.lang.Integer kpiInstanceId,
java.util.Date from,
java.util.Date to,
Resource r,
OrganizationalUnitGrantNode grantNode)
KpiValue valid for the the KpiInstance selected, ou selected for the resource selected, in the date selected |
KpiValue |
getDisplayKpiValue(java.lang.Integer kpiInstanceId,
java.util.Date d,
Resource r,
OrganizationalUnitGrantNode grantNode)
The last KpiValue for the the KpiInstance selected, for the resource selected, ou and hiererchy selected in the date selected or before |
it.eng.spagobi.tools.dataset.bo.IDataSet |
getDsFromKpiId(java.lang.Integer kpiId)
|
java.lang.Integer |
getKpiTrend(java.lang.Integer resId,
java.lang.Integer kpiInstId,
java.util.Date endDate)
|
org.json.JSONObject |
getKpiTrendJSONResult(java.lang.Integer kpiInstId,
java.util.Date beginDate,
java.util.Date endDate)
Returns a JSONOBject with all the the trend values of the KpiInstance |
java.lang.String |
getKpiTrendXmlResult(java.lang.Integer resId,
java.lang.Integer kpiInstId,
java.util.Date endDate)
Returns a List of all the the Threshols of the KpiInstance |
java.lang.String |
getKpiTrendXmlResult(java.lang.Integer resId,
java.lang.Integer kpiInstId,
java.util.Date beginDate,
java.util.Date endDate)
Returns a List of all the the Threshols of the KpiInstance |
KpiValue |
getKpiValue(java.lang.Integer kpiInstanceId,
java.util.Date d,
Resource r,
OrganizationalUnitGrantNode grantNode)
KpiValue valid for the the KpiInstance selected, for the resource selected, ant the selected grant node associated |
java.util.List |
getKpiValue(SbiKpiInstance kpi,
java.util.Date d)
|
KpiValue |
getKpiValueFromInterval(java.lang.Integer kpiInstanceId,
java.util.Date from,
java.util.Date to,
Resource r,
OrganizationalUnitGrantNode grantNode)
KpiValue valid for the the KpiInstance selected, for the resource selected,ou selected in the date selected |
java.lang.Integer |
insertKpi(Kpi kpi)
|
java.lang.Integer |
insertKpiValue(KpiValue value)
Inserts a new KPI Value with its date, value period and thresholds |
Kpi |
loadKpiById(java.lang.Integer id)
Returns the Kpi of the referred id |
Kpi |
loadKpiDefinitionById(java.lang.Integer id)
Returns the Kpi Definition of the referred id |
KpiDocuments |
loadKpiDocByKpiIdAndDocId(java.lang.Integer kpiId,
java.lang.Integer docId)
|
java.util.List |
loadKpiList()
Returns the list of Kpi. |
java.util.List |
loadKpiList(java.lang.String fieldOrder,
java.lang.String typeOrder)
|
java.util.List |
loadKpiListFiltered(java.lang.String hsql,
java.lang.Integer offset,
java.lang.Integer fetchSize)
Returns the list of Kpi filtered by hsql query string. |
java.util.List |
loadKpiRelListByParentId(java.lang.Integer kpiParentId)
|
java.lang.String |
loadKPIValueXml(java.lang.Integer kpiValueId)
|
java.util.List |
loadPagedKpiList(java.lang.Integer offset,
java.lang.Integer fetchSize)
|
void |
modifyKpi(Kpi kpi)
|
java.lang.Integer |
setKpiRel(java.lang.Integer kpiParentId,
java.lang.Integer kpiChildId,
java.lang.String parameter)
|
Kpi |
toKpi(SbiKpi kpi)
|
KpiRel |
toKpiRel(SbiKpiRel sbiKpiRel)
|
Methods inherited from class it.eng.spagobi.commons.dao.AbstractHibernateDAO |
---|
commitIfActiveAndClose, disableTenantFilter, enableTenantFilter, getSession, getTenant, getUserProfile, logException, rollbackIfActiveAndClose, setTenant, setUserID, setUserProfile, updateSbiCommonInfo4Insert, updateSbiCommonInfo4Update |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface it.eng.spagobi.commons.dao.ISpagoBIDao |
---|
getUserProfile, setTenant, setUserID, setUserProfile |
Constructor Detail |
---|
public KpiDAOImpl()
Method Detail |
---|
public java.lang.String loadKPIValueXml(java.lang.Integer kpiValueId) throws it.eng.spago.error.EMFUserError
loadKPIValueXml
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public KpiDocuments loadKpiDocByKpiIdAndDocId(java.lang.Integer kpiId, java.lang.Integer docId) throws it.eng.spago.error.EMFUserError
loadKpiDocByKpiIdAndDocId
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public Kpi loadKpiDefinitionById(java.lang.Integer id) throws it.eng.spago.error.EMFUserError
IKpiDAO
loadKpiDefinitionById
in interface IKpiDAO
id
- of the Kpi
it.eng.spago.error.EMFUserError
- If an Exception occurredpublic Kpi loadKpiById(java.lang.Integer id) throws it.eng.spago.error.EMFUserError
IKpiDAO
loadKpiById
in interface IKpiDAO
id
- of the Kpi
it.eng.spago.error.EMFUserError
- If an Exception occurredpublic java.lang.String getKpiTrendXmlResult(java.lang.Integer resId, java.lang.Integer kpiInstId, java.util.Date endDate) throws it.eng.spago.base.SourceBeanException
IKpiDAO
getKpiTrendXmlResult
in interface IKpiDAO
it.eng.spago.base.SourceBeanException
public java.lang.String getKpiTrendXmlResult(java.lang.Integer resId, java.lang.Integer kpiInstId, java.util.Date beginDate, java.util.Date endDate) throws it.eng.spago.base.SourceBeanException
IKpiDAO
getKpiTrendXmlResult
in interface IKpiDAO
it.eng.spago.base.SourceBeanException
public org.json.JSONObject getKpiTrendJSONResult(java.lang.Integer kpiInstId, java.util.Date beginDate, java.util.Date endDate) throws it.eng.spago.base.SourceBeanException
IKpiDAO
getKpiTrendJSONResult
in interface IKpiDAO
it.eng.spago.base.SourceBeanException
public java.lang.Integer getKpiTrend(java.lang.Integer resId, java.lang.Integer kpiInstId, java.util.Date endDate) throws java.lang.Exception
getKpiTrend
in interface IKpiDAO
java.lang.Exception
public java.util.List getKpiValue(SbiKpiInstance kpi, java.util.Date d) throws it.eng.spago.error.EMFUserError
it.eng.spago.error.EMFUserError
public java.lang.Integer insertKpiValue(KpiValue value) throws it.eng.spago.error.EMFUserError
IKpiDAO
insertKpiValue
in interface IKpiDAO
it.eng.spago.error.EMFUserError
- If an Exception occurredpublic KpiValue getKpiValue(java.lang.Integer kpiInstanceId, java.util.Date d, Resource r, OrganizationalUnitGrantNode grantNode) throws it.eng.spago.error.EMFUserError
IKpiDAO
getKpiValue
in interface IKpiDAO
it.eng.spago.error.EMFUserError
- if an Exception occurspublic Kpi toKpi(SbiKpi kpi) throws it.eng.spago.error.EMFUserError
it.eng.spago.error.EMFUserError
public java.util.List loadKpiList(java.lang.String fieldOrder, java.lang.String typeOrder) throws it.eng.spago.error.EMFUserError
loadKpiList
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.util.List loadKpiList() throws it.eng.spago.error.EMFUserError
IKpiDAO
loadKpiList
in interface IKpiDAO
it.eng.spago.error.EMFUserError
- if an Exception occurspublic void modifyKpi(Kpi kpi) throws it.eng.spago.error.EMFUserError
modifyKpi
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.lang.Integer insertKpi(Kpi kpi) throws it.eng.spago.error.EMFUserError
insertKpi
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public boolean deleteKpi(java.lang.Integer kpiId) throws it.eng.spago.error.EMFUserError
deleteKpi
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public it.eng.spagobi.tools.dataset.bo.IDataSet getDsFromKpiId(java.lang.Integer kpiId) throws it.eng.spago.error.EMFUserError
getDsFromKpiId
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.lang.Integer countKpis() throws it.eng.spago.error.EMFUserError
countKpis
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.util.List loadPagedKpiList(java.lang.Integer offset, java.lang.Integer fetchSize) throws it.eng.spago.error.EMFUserError
loadPagedKpiList
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.lang.Integer setKpiRel(java.lang.Integer kpiParentId, java.lang.Integer kpiChildId, java.lang.String parameter) throws it.eng.spago.error.EMFUserError
setKpiRel
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public java.util.List loadKpiRelListByParentId(java.lang.Integer kpiParentId) throws it.eng.spago.error.EMFUserError
loadKpiRelListByParentId
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public KpiRel toKpiRel(SbiKpiRel sbiKpiRel) throws it.eng.spago.error.EMFUserError
it.eng.spago.error.EMFUserError
public boolean deleteKpiRel(java.lang.Integer kpiRelId) throws it.eng.spago.error.EMFUserError
deleteKpiRel
in interface IKpiDAO
it.eng.spago.error.EMFUserError
public KpiValue getKpiValueFromInterval(java.lang.Integer kpiInstanceId, java.util.Date from, java.util.Date to, Resource r, OrganizationalUnitGrantNode grantNode) throws it.eng.spago.error.EMFUserError
IKpiDAO
getKpiValueFromInterval
in interface IKpiDAO
it.eng.spago.error.EMFUserError
- if an Exception occurspublic void deleteKpiValueFromInterval(java.lang.Integer kpiInstanceId, java.util.Date from, java.util.Date to, Resource r, OrganizationalUnitGrantNode grantNode) throws it.eng.spago.error.EMFUserError
IKpiDAO
deleteKpiValueFromInterval
in interface IKpiDAO
it.eng.spago.error.EMFUserError
- if an Exception occurspublic java.util.List loadKpiListFiltered(java.lang.String hsql, java.lang.Integer offset, java.lang.Integer fetchSize) throws it.eng.spago.error.EMFUserError
IKpiDAO
loadKpiListFiltered
in interface IKpiDAO
hsql
- query string
it.eng.spago.error.EMFUserError
- if an Exception occurspublic KpiValue getDisplayKpiValue(java.lang.Integer kpiInstanceId, java.util.Date d, Resource r, OrganizationalUnitGrantNode grantNode) throws it.eng.spago.error.EMFUserError
IKpiDAO
getDisplayKpiValue
in interface IKpiDAO
it.eng.spago.error.EMFUserError
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |