org.compiere.model
Class MLookupFactory

java.lang.Object
  org.compiere.model.MLookupFactory

public class MLookupFactory
extends Object

Create MLookups

Version:

$Id: MLookupFactory.java,v 1.3 2006/07/30 00:58:04 jjanke Exp $

Author:

Jorg Janke

Constructor Summary

MLookupFactory()

Method Summary

static MLookup	get(Ctx ctx, int WindowNo, int Column_ID, int AD_Reference_ID) Create MLookup
static MLookup	get(Ctx ctx, int WindowNo, int Column_ID, int AD_Reference_ID, Language language, String ColumnName, int AD_Reference_Value_ID, boolean IsParent, String ValidationCode) Create MLookup
static StringBuffer	getLookup_DisplayColumn(Language language, String TableName) Get Display Columns SQL for Table/Table Direct Lookup
static MLookupInfo	getLookup_List(Language language, int AD_Reference_Value_ID) Get Lookup SQL for Lists
static String	getLookup_ListEmbed(Language language, int AD_Reference_Value_ID, String linkColumnName) Get Lookup SQL for List
static String	getLookup_TableDirEmbed(Language language, String ColumnName, String BaseTable) Get embedded SQL for TableDir Lookup (no translation)
static String	getLookup_TableDirEmbed(Language language, String ColumnName, String BaseTable, String BaseColumn) Get embedded SQL for TableDir Lookup (no translation)
static String	getLookup_TableEmbed(Language language, String BaseColumn, String BaseTable, int AD_Reference_Value_ID) Get Embedded Lookup SQL for Table Lookup
static MLookupInfo	getLookupInfo(Ctx ctx, int WindowNo, int AD_Reference_ID, int Column_ID, Language language, String ColumnName, int AD_Reference_Value_ID, boolean IsParent, String ValidationCode) Get Information for Lookups based on Column_ID for Table Columns or Process Parameters.
static MLookupInfo	getLookupInfo(Lookup lookup, int Column_ID, Language language, String ColumnName, int AD_Reference_Value_ID, boolean IsParent, String ValidationCode) Get Information for Lookups based on Column_ID for Table Columns or Process Parameters.

Methods inherited from class java.lang.Object

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

Constructor Detail

MLookupFactory

public MLookupFactory()

Method Detail

get

public static MLookup get(Ctx ctx,
                          int WindowNo,
                          int Column_ID,
                          int AD_Reference_ID,
                          Language language,
                          String ColumnName,
                          int AD_Reference_Value_ID,
                          boolean IsParent,
                          String ValidationCode)

Create MLookup

Parameters:

ctx - context for access

WindowNo - window no

AD_Reference_ID - display type

Column_ID - AD_Column_ID or AD_Process_Para_ID

language - report language

ColumnName - key column name

AD_Reference_Value_ID - AD_Reference (List, Table)

IsParent - parent (prevents query to directly access value)

ValidationCode - optional SQL validation

Returns:

MLookup

Throws:

Exception - if Lookup could not be created

get

public static MLookup get(Ctx ctx,
                          int WindowNo,
                          int Column_ID,
                          int AD_Reference_ID)

Create MLookup

Parameters:

ctx - context for access

WindowNo - window no

Column_ID - AD_Column_ID or AD_Process_Para_ID

AD_Reference_ID - display type

Returns:

MLookup

getLookupInfo

public static MLookupInfo getLookupInfo(Lookup lookup,
                                        int Column_ID,
                                        Language language,
                                        String ColumnName,
                                        int AD_Reference_Value_ID,
                                        boolean IsParent,
                                        String ValidationCode)

Get Information for Lookups based on Column_ID for Table Columns or Process Parameters. The SQL returns three columns:

                Key, Value, Name, IsActive      (where either key or value is null)
  

Parameters:

ctx - context for access

WindowNo - window no

AD_Reference_ID - display type

Column_ID - AD_Column_ID or AD_Process_Para_ID

language - report language

ColumnName - key column name

AD_Reference_Value_ID - AD_Reference (List, Table)

IsParent - parent (prevents query to directly access value)

ValidationCode - optional SQL validation

Returns:

lookup info structure

getLookupInfo

public static MLookupInfo getLookupInfo(Ctx ctx,
                                        int WindowNo,
                                        int AD_Reference_ID,
                                        int Column_ID,
                                        Language language,
                                        String ColumnName,
                                        int AD_Reference_Value_ID,
                                        boolean IsParent,
                                        String ValidationCode)

Get Information for Lookups based on Column_ID for Table Columns or Process Parameters. The SQL returns three columns:

                Key, Value, Name, IsActive      (where either key or value is null)
  

Parameters:

ctx - context for access

WindowNo - window no

AD_Reference_ID - display type

Column_ID - AD_Column_ID or AD_Process_Para_ID

language - report language

ColumnName - key column name

AD_Reference_Value_ID - AD_Reference (List, Table)

IsParent - parent (prevents query to directly access value)

ValidationCode - optional SQL validation

Returns:

lookup info structure

getLookup_List

public static MLookupInfo getLookup_List(Language language,
                                         int AD_Reference_Value_ID)

Get Lookup SQL for Lists

Parameters:

language - report language

AD_Reference_Value_ID - reference value

Returns:

SELECT NULL, Value, Name, IsActive FROM AD_Ref_List

getLookup_ListEmbed

public static String getLookup_ListEmbed(Language language,
                                         int AD_Reference_Value_ID,
                                         String linkColumnName)

Get Lookup SQL for List

Parameters:

language - report Language

AD_Reference_Value_ID - reference value

linkColumnName - link column name

Returns:

SELECT Name FROM AD_Ref_List WHERE AD_Reference_ID=x AND Value=linkColumn

getLookup_TableEmbed

public static String getLookup_TableEmbed(Language language,
                                          String BaseColumn,
                                          String BaseTable,
                                          int AD_Reference_Value_ID)

Get Embedded Lookup SQL for Table Lookup

Parameters:

language - report language

BaseColumn - base column name

BaseTable - base table name

AD_Reference_Value_ID - reference value

Returns:

SELECT Name FROM Table

getLookup_DisplayColumn

public static StringBuffer getLookup_DisplayColumn(Language language,
                                                   String TableName)

Get Display Columns SQL for Table/Table Direct Lookup

Parameters:

language - report language

TableName - table name

Returns:

SELECT DisplayColumns

getLookup_TableDirEmbed

public static String getLookup_TableDirEmbed(Language language,
                                             String ColumnName,
                                             String BaseTable)

Get embedded SQL for TableDir Lookup (no translation)

Parameters:

language - report language

ColumnName - column name

BaseTable - base table

Returns:

SELECT Column FROM TableName WHERE BaseTable.ColumnName=TableName.ColumnName

getLookup_TableDirEmbed

public static String getLookup_TableDirEmbed(Language language,
                                             String ColumnName,
                                             String BaseTable,
                                             String BaseColumn)

Get embedded SQL for TableDir Lookup (no translation)

Parameters:

language - report language

ColumnName - column name

BaseTable - base table

BaseColumn - base column

Returns:

SELECT Column FROM TableName WHERE BaseTable.BaseColumn=TableName.ColumnName