Package org.openbravo.common.datasource

Class InOutLinePEHQLTransformer

java.lang.Object

org.openbravo.service.datasource.hql.HqlQueryPriorityHandler

org.openbravo.service.datasource.hql.HqlQueryTransformer

org.openbravo.common.datasource.InOutLinePEHQLTransformer

public class InOutLinePEHQLTransformer
extends HqlQueryTransformer

Field Summary

Fields

Modifier and Type	Field	Description
protected static String	CREATE_INVOICE_LINES_FORM_INOUT_WINDOW
protected static String	EMPTY_STRING
protected boolean	isSalesTransaction

Constructor Summary

Constructors

Constructor	Description
InOutLinePEHQLTransformer()

Method Summary

Modifier and Type	Method	Description
protected String	getFromClauseHQL()
protected String	getGroupByHQL()
protected String	getMovementQuantityHQL()
protected String	getOperativeQuantityHQL()
protected String	getOperativeUOM()
protected String	getOrderQuantityHQL()
protected String	getSelectClauseHQL()
protected String	getSinceHowManyDaysAgoInOutsShouldBeFiltered()	Return the value of FilterByDocumentsProcessedSinceNDaysAgo preference to be used to define a starting range date filter to limit the shipment/receipts records to be returned by the query
protected String	getWhereClauseHQL()
String	transformHqlQuery(String _hqlQuery, Map<String,String> requestParameters, Map<String,Object> queryNamedParameters)	Returns the transformed hql query

Methods inherited from class org.openbravo.service.datasource.hql.HqlQueryTransformer

transFormQuery

Methods inherited from class org.openbravo.service.datasource.hql.HqlQueryPriorityHandler

getPriority

Methods inherited from class java.lang.Object

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

Field Detail

EMPTY_STRING

protected static final String EMPTY_STRING

See Also:

Constant Field Values

CREATE_INVOICE_LINES_FORM_INOUT_WINDOW

protected static final String CREATE_INVOICE_LINES_FORM_INOUT_WINDOW

See Also:

Constant Field Values

isSalesTransaction

protected boolean isSalesTransaction

Constructor Detail

InOutLinePEHQLTransformer

public InOutLinePEHQLTransformer()

Method Detail

transformHqlQuery

public String transformHqlQuery(String _hqlQuery,
                                Map<String,String> requestParameters,
                                Map<String,Object> queryNamedParameters)

Description copied from class: HqlQueryTransformer

Returns the transformed hql query

Specified by:

transformHqlQuery in class HqlQueryTransformer

Parameters:

_hqlQuery - original hql query

requestParameters - the parameters of the request

queryNamedParameters - the named parameters of the hql query that will be used to fetch the table data. If the transformed hql query uses named parameters that did not exist in the original hql query, the named parameters must be added to this map

Returns:

the transformed hql query

getSelectClauseHQL

protected String getSelectClauseHQL()

getFromClauseHQL

protected String getFromClauseHQL()

getWhereClauseHQL

protected String getWhereClauseHQL()

getGroupByHQL

protected String getGroupByHQL()

getMovementQuantityHQL

protected String getMovementQuantityHQL()

getOperativeQuantityHQL

protected String getOperativeQuantityHQL()

getOrderQuantityHQL

protected String getOrderQuantityHQL()

getOperativeUOM

protected String getOperativeUOM()

getSinceHowManyDaysAgoInOutsShouldBeFiltered

protected String getSinceHowManyDaysAgoInOutsShouldBeFiltered()

Return the value of FilterByDocumentsProcessedSinceNDaysAgo preference to be used to define a starting range date filter to limit the shipment/receipts records to be returned by the query

Returns:

The value of the preference if exists for the Create Invoice Lines From Shipment/Receipt window, or since one year (365 days) if not or exists any conflict in the preference definition