| Column | Datatype | | Remark |
| ADDRESS01 | STRING(60) | | Address Line #1 |
| ADDRESS02 | STRING(60) | | Address Line #2 |
| BELONGS_TO | {@link e4s.db.systabledef.CompanyId}
INTEGER | 3 | Company belongs to another company (can be null or empty) |
| CITY | STRING(60) | | City |
| null | null | null | null |
| COMPANY_ID | {@link e4s.db.systabledef.CompanyId}
INTEGER | 1 | Primary key, company - ID |
| COUNTRYCODE | CountryCode | | Countrycode |
| DATMOD | DATE | | Date modified |
| DATNEW | DATE | | Date created |
| EMAIL | STRING(60) | | Corporate E-Mail |
| GIS_LATITUDE | FLOAT | | GIS Latitude |
| GIS_LONGITUDE | FLOAT | | GIS Longitude |
| GROUP_ID | {@link e4s.db.systabledef.CompanyGroup}
STRING(16) | | Belongs to Group |
| LOGIN_NAME | STRING(16) | 2 | Name for login |
| NAME | STRING(60) | | Company Name |
| PHONE01 | STRING(60) | | Phone #1 |
| PHONE02 | STRING(60) | | Phone #2 |
| REM | STRING(255) | | Remark |
| UID | STRING(10) | | VAT Number |
| VALID_UNTIL | DATE | | Valid until |
| WWW | STRING(60) | | WWW Address |
| ZIPCODE | STRING(10) | | ZIP Code |
*
* Index 1: COMPANY_ID unique
* Index 2: LOGIN_NAME unique
* Index 3: BELONGS
*
* @see e4s.db.systabledef.T_D2S_COMPANY_Mod
* @see e4s.db.systabledef.T_D2S_COMPANY_Obj
* @see tabledef.V_D2S_USERS_Sel
*/
public class T_D2S_COMPANY_Sel extends dbSelectFreefields implements dbSelectFreefields_Intf
{
// ------------------------------------------------------------------
// -- this file was generated by e4s.db.dict.dbTable from the
// -- element4solution library. Do not place modifications here!
// -- http://www.element4solution.com
// -- (C)door2solution software gmbh
// ------------------------------------------------------------------
// ADDRESS01 STRING Address Line #1
// ADDRESS02 STRING Address Line #2
// BELONGS_TO CompanyId 3 Company belongs to another company (can be null or empty)
// CITY STRING City
//
// COMPANY_ID CompanyId 1 Primary key, company - ID
// COUNTRYCODE CountryCode Countrycode
// DATMOD DATE Date modified
// DATNEW DATE Date created
// EMAIL STRING Corporate E-Mail
// GIS_LATITUDE FLOAT GIS Latitude
// GIS_LONGITUDE FLOAT GIS Longitude
// GROUP_ID CompanyGroup Belongs to Group
// LOGIN_NAME STRING 2 Name for login
// NAME STRING Company Name
// PHONE01 STRING Phone #1
// PHONE02 STRING Phone #2
// REM STRING Remark
// UID STRING VAT Number
// VALID_UNTIL DATE Valid until
// WWW STRING WWW Address
// ZIPCODE STRING ZIP Code
/**
* Name of the database table.
*/
public final static dbTableName TABLENAME = new dbTableName("T_D2S_COMPANY");
/**
* This table enables client distinction.
*
* @see e4s.application.Client
* @see #hasClientDistinctive()
*/
public final static boolean IS_CLIENT_DISTINCTIVE = true;
/**
* This table enables freedefined database fields.
*
* @see e4s.db.freefield.FreefieldName
* @see #canHaveFreeDefinedFields()
*/
public final static boolean IS_FREEDEF_POSSIBLE = true;
/**
* Consistency check allready performed?
*/
private static boolean m_checked_conistency = false;
/**
* STRING(60)
* Address Line #1
*/
public final static dbColumnName COL_ADDRESS01 = new dbColumnName("ADDRESS01");
public final static dbColumnInfo CI_ADDRESS01 = new dbColumnInfo(COL_ADDRESS01,dbColumnType._DATATYPE_STRING,60,"Address Line #1");
/**
* STRING(60)
* Address Line #2
*/
public final static dbColumnName COL_ADDRESS02 = new dbColumnName("ADDRESS02");
public final static dbColumnInfo CI_ADDRESS02 = new dbColumnInfo(COL_ADDRESS02,dbColumnType._DATATYPE_STRING,60,"Address Line #2");
/**
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
* Member of index: BELONGS.
*
* @see e4s.db.systabledef.CompanyId
* @see #IDX_BELONGS
*/
public final static dbColumnName COL_BELONGS_TO = new dbColumnName("BELONGS_TO");
public final static dbColumnInfo CI_BELONGS_TO = new dbColumnInfo(COL_BELONGS_TO,CompanyId._DATATYPE,e4sLong.class,"Company belongs to another company (can be null or empty)");
/**
* STRING(60)
* City
*/
public final static dbColumnName COL_CITY = new dbColumnName("CITY");
public final static dbColumnInfo CI_CITY = new dbColumnInfo(COL_CITY,dbColumnType._DATATYPE_STRING,60,"City");
/**
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
* Member of index: COMPANY_ID.
*
* @see e4s.db.systabledef.CompanyId
* @see #IDX_COMPANY_ID
*/
public final static dbColumnName COL_COMPANY_ID = new dbColumnName("COMPANY_ID");
public final static dbColumnInfo CI_COMPANY_ID = new dbColumnInfo(COL_COMPANY_ID,CompanyId._DATATYPE,true,e4sLong.class,"Primary key, company - ID");
/**
* CountryCode
* Countrycode
*/
public final static dbColumnName COL_COUNTRYCODE = new dbColumnName("COUNTRYCODE");
public final static dbColumnInfo CI_COUNTRYCODE = new dbColumnInfo(COL_COUNTRYCODE,CountryCode._DATATYPE,CountryCode.LEN,"Countrycode");
/**
* DATE
* Date modified
*/
public final static dbColumnName COL_DATMOD = new dbColumnName("DATMOD");
public final static dbColumnInfo CI_DATMOD = new dbColumnInfo(COL_DATMOD,dbColumnType._DATATYPE_DATE,"Date modified");
/**
* DATE
* Date created
*/
public final static dbColumnName COL_DATNEW = new dbColumnName("DATNEW");
public final static dbColumnInfo CI_DATNEW = new dbColumnInfo(COL_DATNEW,dbColumnType._DATATYPE_DATE,"Date created");
/**
* STRING(60)
* Corporate E-Mail
*/
public final static dbColumnName COL_EMAIL = new dbColumnName("EMAIL");
public final static dbColumnInfo CI_EMAIL = new dbColumnInfo(COL_EMAIL,dbColumnType._DATATYPE_STRING,60,"Corporate E-Mail");
/**
* FLOAT
* GIS Latitude
*/
public final static dbColumnName COL_GIS_LATITUDE = new dbColumnName("GIS_LATITUDE");
public final static dbColumnInfo CI_GIS_LATITUDE = new dbColumnInfo(COL_GIS_LATITUDE,dbColumnType._DATATYPE_FLOAT,"GIS Latitude");
/**
* FLOAT
* GIS Longitude
*/
public final static dbColumnName COL_GIS_LONGITUDE = new dbColumnName("GIS_LONGITUDE");
public final static dbColumnInfo CI_GIS_LONGITUDE = new dbColumnInfo(COL_GIS_LONGITUDE,dbColumnType._DATATYPE_FLOAT,"GIS Longitude");
/**
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public final static dbColumnName COL_GROUP_ID = new dbColumnName("GROUP_ID");
public final static dbColumnInfo CI_GROUP_ID = new dbColumnInfo(COL_GROUP_ID,CompanyGroup._DATATYPE,e4sString.class,CompanyGroup.LEN,"Belongs to Group");
/**
* STRING(16)
* Name for login
* Member of index: LOGIN_NAME.
*
* @see #IDX_LOGIN_NAME
*/
public final static dbColumnName COL_LOGIN_NAME = new dbColumnName("LOGIN_NAME");
public final static dbColumnInfo CI_LOGIN_NAME = new dbColumnInfo(COL_LOGIN_NAME,dbColumnType._DATATYPE_STRING,16,"Name for login");
/**
* STRING(60)
* Company Name
*/
public final static dbColumnName COL_NAME = new dbColumnName("NAME");
public final static dbColumnInfo CI_NAME = new dbColumnInfo(COL_NAME,dbColumnType._DATATYPE_STRING,60,"Company Name");
/**
* STRING(60)
* Phone #1
*/
public final static dbColumnName COL_PHONE01 = new dbColumnName("PHONE01");
public final static dbColumnInfo CI_PHONE01 = new dbColumnInfo(COL_PHONE01,dbColumnType._DATATYPE_STRING,60,"Phone #1");
/**
* STRING(60)
* Phone #2
*/
public final static dbColumnName COL_PHONE02 = new dbColumnName("PHONE02");
public final static dbColumnInfo CI_PHONE02 = new dbColumnInfo(COL_PHONE02,dbColumnType._DATATYPE_STRING,60,"Phone #2");
/**
* STRING(255)
* Remark
*/
public final static dbColumnName COL_REM = new dbColumnName("REM");
public final static dbColumnInfo CI_REM = new dbColumnInfo(COL_REM,dbColumnType._DATATYPE_STRING,255,"Remark");
/**
* STRING(10)
* VAT Number
*/
public final static dbColumnName COL_UID = new dbColumnName("UID");
public final static dbColumnInfo CI_UID = new dbColumnInfo(COL_UID,dbColumnType._DATATYPE_STRING,10,"VAT Number");
/**
* DATE
* Valid until
*/
public final static dbColumnName COL_VALID_UNTIL = new dbColumnName("VALID_UNTIL");
public final static dbColumnInfo CI_VALID_UNTIL = new dbColumnInfo(COL_VALID_UNTIL,dbColumnType._DATATYPE_DATE,"Valid until");
/**
* STRING(60)
* WWW Address
*/
public final static dbColumnName COL_WWW = new dbColumnName("WWW");
public final static dbColumnInfo CI_WWW = new dbColumnInfo(COL_WWW,dbColumnType._DATATYPE_STRING,60,"WWW Address");
/**
* STRING(10)
* ZIP Code
*/
public final static dbColumnName COL_ZIPCODE = new dbColumnName("ZIPCODE");
public final static dbColumnInfo CI_ZIPCODE = new dbColumnInfo(COL_ZIPCODE,dbColumnType._DATATYPE_STRING,10,"ZIP Code");
/**
* Definition of database columns as array
* @see #INDEXES
*/
public final static dbColumnInfo[] COLUMNS =
{
CI_ADDRESS01,
CI_ADDRESS02,
CI_BELONGS_TO,
CI_CITY,
CI_COMPANY_ID,
CI_COUNTRYCODE,
CI_DATMOD,
CI_DATNEW,
CI_EMAIL,
CI_GIS_LATITUDE,
CI_GIS_LONGITUDE,
CI_GROUP_ID,
CI_LOGIN_NAME,
CI_NAME,
CI_PHONE01,
CI_PHONE02,
CI_REM,
CI_UID,
CI_VALID_UNTIL,
CI_WWW,
CI_ZIPCODE
};
/**
* Definition of index IDX_COMPANY_ID.
* @see #COL_COMPANY_ID
*/
public final static dbIndexInfo IDX_COMPANY_ID = new dbIndexInfo("IDX_COMPANY_ID",true,new dbColumnInfo[]{CI_COMPANY_ID,Client.CI_CLIENT});
/**
* Definition of index IDX_LOGIN_NAME.
* @see #COL_LOGIN_NAME
*/
public final static dbIndexInfo IDX_LOGIN_NAME = new dbIndexInfo("IDX_LOGIN_NAME",true,new dbColumnInfo[]{CI_LOGIN_NAME,Client.CI_CLIENT});
/**
* Definition of index IDX_BELONGS.
* @see #COL_BELONGS_TO
*/
public final static dbIndexInfo IDX_BELONGS = new dbIndexInfo("IDX_BELONGS",false,new dbColumnInfo[]{CI_BELONGS_TO,Client.CI_CLIENT});
/**
* Definition of table indexes.
* @see #COLUMNS
*/
public final static dbIndexInfo[] INDEXES = new dbIndexInfo[]{IDX_COMPANY_ID,IDX_LOGIN_NAME,IDX_BELONGS};
/**
* Construct an object for selecting data from T_D2S_COMPANY
* using a database connection, the table uses client distinction.
*
* @param dbcon a database connection
* @param applobj an application object, containing client and other information
*
* @see e4s.servlet.moduleImplementation#getApplicationObject()
* @see e4s.servlet.servletImplementation_Intf#getApplicationObject()
*/
public T_D2S_COMPANY_Sel(dbConnection_Intf dbcon, applObject_Intf applobj)
{
super(dbcon,TABLENAME,applobj);
}
/**
* Construct an object for selecting data from T_D2S_COMPANY
* using the default database connection, the table uses client distinction.
*
* @param applobj an application object, containing client and other information
*
* @see e4s.servlet.moduleImplementation#getApplicationObject()
* @see e4s.servlet.servletImplementation_Intf#getApplicationObject()
*/
public T_D2S_COMPANY_Sel(applObject_Intf applobj)
throws dbException
{
super(TABLENAME,applobj);
}
/**
* Construct an object for selecting data from T_D2S_COMPANY
* using an existing T_D2S_COMPANY_Sel instance.
*
* @param dbtable a previous created T_D2S_COMPANY_Sel
* @param copy_where if true, the WHERE statement from the table is also copied to the new created table.
*/
public T_D2S_COMPANY_Sel(T_D2S_COMPANY_Sel dbtable, boolean copy_where)
throws dbException
{
super((dbSelect_Intf)dbtable, copy_where);
}
/**
* Create a new instance for T_D2S_COMPANY_Sel
*
* @param copy_where if true, the WHERE statement from the table is also copied to the new created table.
*/
public dbSelect_Intf makeInstance( boolean copy_where )
throws dbException
{
T_D2S_COMPANY_Sel res = new T_D2S_COMPANY_Sel(this,copy_where);
return res;
}
public e4sID e4sID()
{
return new e4sID(TABLENAME);
}
/**
* Get the state if data of this table will be distincted by {@link e4s.application.Client}.
* This is the case, if the {@link e4s.application.applObject_Intf} object was involved during
* construction of the object.
*
* @return true (client distinction for this table is enabled)
*
* @see e4s.application.Client
* @see #IS_CLIENT_DISTINCTIVE
*/
public boolean hasClientDistinctive()
{
return IS_CLIENT_DISTINCTIVE;
}
/**
* Check, if this table might have freedefined fields.
*
* @return true (table enables freedefined database fields)
* @see #IS_FREEDEF_POSSIBLE
*/
public boolean canHaveFreeDefinedFields()
{
return (IS_FREEDEF_POSSIBLE && IS_CLIENT_DISTINCTIVE);
}
/**
* Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_D2S_COMPANY.
*
* @return class for the modifications
*
* @see e4s.db.dbModify_Intf
* @see e4s.db.freefield.dbModifyFreefields_Intf
* @see T_D2S_COMPANY_Mod
*/
public Class getModifyClass()
{
return T_D2S_COMPANY_Mod.class;
}
/**
* Make an instance of the associated class for modification of database table entries.
* If an application object is defined, it will also be handled to the new created instance,
* as well as the database connection.
*
* @param copy_where if true, the WHERE statement from the table is also copied to the new created table.
*
* @see #makeInstance(boolean)
*/
public dbModify_Intf makeInstance_Modify( boolean copy_where )
throws dbException
{
T_D2S_COMPANY_Mod res = new T_D2S_COMPANY_Mod(getConnection(),getApplicationObject());
if (copy_where)
res.setWhere(getWhere());
return res;
}
/**
* Get the defined and generated class for the data-object related to this table.
*
* @return the data object class
*
* @see T_D2S_COMPANY_Obj
*/
public Class getObjectClass()
{
return T_D2S_COMPANY_Obj.class;
}
/**
* Get information about the columns defined for this database table.
*
* @return null if no columns are defined, an array of {@link e4s.db.dbColumnInfo} objects
*
* @see COLUMNS
*/
public dbColumnInfo[] getColInfo()
{
return COLUMNS;
}
/**
* Get information about the indexes defined for this database table.
*
* @return null if no index is defined, an array of {@link e4s.db.dbIndexInfo} objects
*
* @see INDEXES
*/
public dbIndexInfo[] getIdxInfo()
{
return INDEXES;
}
/**
* Get value for client.
*
* @return the value for the client.
*/
public Client get_CLIENT()
throws dbException
{
Client res = new Client(getString(Client.COLUMN_NAME));
return res;
}
/**
* Get value for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @return the database column value retrieved for field ADDRESS01
*/
public String get_ADDRESS01()
throws dbException
{
String res = getString(COL_ADDRESS01);
return res;
}
/**
* Get value for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @return the database column value retrieved for field ADDRESS02
*/
public String get_ADDRESS02()
throws dbException
{
String res = getString(COL_ADDRESS02);
return res;
}
/**
* Get value for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @return the database column value retrieved for field BELONGS_TO
*
* @see e4s.db.systabledef.CompanyId
*/
public CompanyId get_BELONGS_TO()
throws dbException
{
e4sLong h = getD2sLong(COL_BELONGS_TO);
CompanyId res = (h == null) ? null : new CompanyId(h);
return res;
}
/**
* Get value for column CITY.
* STRING(60)
* City
*
* @return the database column value retrieved for field CITY
*/
public String get_CITY()
throws dbException
{
String res = getString(COL_CITY);
return res;
}
/**
* Get value for column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @return the database column value retrieved for field COMPANY_ID
*
* @see e4s.db.systabledef.CompanyId
*/
public CompanyId get_COMPANY_ID()
throws dbException
{
e4sLong h = getD2sLong(COL_COMPANY_ID);
CompanyId res = (h == null) ? null : new CompanyId(h);
return res;
}
/**
* Get value for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @return the database column value retrieved for field COUNTRYCODE
*/
public CountryCode get_COUNTRYCODE()
throws dbException
{
String h = getString(COL_COUNTRYCODE);
CountryCode res = (h == null) ? null : new CountryCode(h);
return res;
}
/**
* Get value for column DATMOD.
* DATE
* Date modified
*
* @return the database column value retrieved for field DATMOD
*/
public java.util.Date get_DATMOD()
throws dbException
{
java.util.Date res = getDate(COL_DATMOD);
return res;
}
/**
* Get value for column DATNEW.
* DATE
* Date created
*
* @return the database column value retrieved for field DATNEW
*/
public java.util.Date get_DATNEW()
throws dbException
{
java.util.Date res = getDate(COL_DATNEW);
return res;
}
/**
* Get value for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @return the database column value retrieved for field EMAIL
*/
public String get_EMAIL()
throws dbException
{
String res = getString(COL_EMAIL);
return res;
}
/**
* Get value for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @return the database column value retrieved for field GIS_LATITUDE
*/
public float get_GIS_LATITUDE()
throws dbException
{
float res = getFloat(COL_GIS_LATITUDE);
return res;
}
/**
* Get value for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @return the database column value retrieved for field GIS_LONGITUDE
*/
public float get_GIS_LONGITUDE()
throws dbException
{
float res = getFloat(COL_GIS_LONGITUDE);
return res;
}
/**
* Get value for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @return the database column value retrieved for field GROUP_ID
*
* @see e4s.db.systabledef.CompanyGroup
*/
public CompanyGroup get_GROUP_ID()
throws dbException
{
String h = getString(COL_GROUP_ID);
CompanyGroup res = (h == null) ? null : new CompanyGroup(h);
return res;
}
/**
* Get value for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @return the database column value retrieved for field LOGIN_NAME
*/
public String get_LOGIN_NAME()
throws dbException
{
String res = getString(COL_LOGIN_NAME);
return res;
}
/**
* Get value for column NAME.
* STRING(60)
* Company Name
*
* @return the database column value retrieved for field NAME
*/
public String get_NAME()
throws dbException
{
String res = getString(COL_NAME);
return res;
}
/**
* Get value for column PHONE01.
* STRING(60)
* Phone #1
*
* @return the database column value retrieved for field PHONE01
*/
public String get_PHONE01()
throws dbException
{
String res = getString(COL_PHONE01);
return res;
}
/**
* Get value for column PHONE02.
* STRING(60)
* Phone #2
*
* @return the database column value retrieved for field PHONE02
*/
public String get_PHONE02()
throws dbException
{
String res = getString(COL_PHONE02);
return res;
}
/**
* Get value for column REM.
* STRING(255)
* Remark
*
* @return the database column value retrieved for field REM
*/
public String get_REM()
throws dbException
{
String res = getString(COL_REM);
return res;
}
/**
* Get value for column UID.
* STRING(10)
* VAT Number
*
* @return the database column value retrieved for field UID
*/
public String get_UID()
throws dbException
{
String res = getString(COL_UID);
return res;
}
/**
* Get value for column VALID_UNTIL.
* DATE
* Valid until
*
* @return the database column value retrieved for field VALID_UNTIL
*/
public java.util.Date get_VALID_UNTIL()
throws dbException
{
java.util.Date res = getDate(COL_VALID_UNTIL);
return res;
}
/**
* Get value for column WWW.
* STRING(60)
* WWW Address
*
* @return the database column value retrieved for field WWW
*/
public String get_WWW()
throws dbException
{
String res = getString(COL_WWW);
return res;
}
/**
* Get value for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @return the database column value retrieved for field ZIPCODE
*/
public String get_ZIPCODE()
throws dbException
{
String res = getString(COL_ZIPCODE);
return res;
}
// generated using dbTable.generateClass_Function_GetObject:5234
/**
* Get the data object for T_D2S_COMPANY with optionally reading freedefined values.
*
* @param readfreefields also include the freefields.
*
* @return the data object.
*
* @see #get()
* @see e4s.db.systabledef.T_D2S_COMPANY_Obj#get(e4s.db.freefield.FreefieldName)
*/
public T_D2S_COMPANY_Obj get(boolean readfreefields)
throws dbException
{
T_D2S_COMPANY_Obj res = get();
if (readfreefields)
{
FreeValue fv[] = getFreeValues();
if ((fv != null) && (fv.length > 0))
{
for( int i = 0; i < fv.length; i++ )
res.set(fv[i]);
}
}
return res;
}
/**
* Get the data object for T_D2S_COMPANY without reading freedefined values.
*
* @param readfreefields also include the freefields.
*
* @return the data object.
*
* @see #get(boolean)
*/
public T_D2S_COMPANY_Obj get()
throws dbException
{
T_D2S_COMPANY_Obj res = new T_D2S_COMPANY_Obj();
// STRING ADDRESS01 Address Line #1
res.set_ADDRESS01(get_ADDRESS01());
// STRING ADDRESS02 Address Line #2
res.set_ADDRESS02(get_ADDRESS02());
// CompanyId BELONGS_TO Company belongs to another company (can be null or empty)
res.set_BELONGS_TO(get_BELONGS_TO());
// STRING CITY City
res.set_CITY(get_CITY());
// CompanyId COMPANY_ID Primary key, company - ID
res.set_COMPANY_ID(get_COMPANY_ID());
// CountryCode COUNTRYCODE Countrycode
res.set_COUNTRYCODE(get_COUNTRYCODE());
// DATE DATMOD Date modified
res.set_DATMOD(get_DATMOD());
// DATE DATNEW Date created
res.set_DATNEW(get_DATNEW());
// STRING EMAIL Corporate E-Mail
res.set_EMAIL(get_EMAIL());
// FLOAT GIS_LATITUDE GIS Latitude
res.set_GIS_LATITUDE(get_GIS_LATITUDE());
// FLOAT GIS_LONGITUDE GIS Longitude
res.set_GIS_LONGITUDE(get_GIS_LONGITUDE());
// CompanyGroup GROUP_ID Belongs to Group
res.set_GROUP_ID(get_GROUP_ID());
// STRING LOGIN_NAME Name for login
res.set_LOGIN_NAME(get_LOGIN_NAME());
// STRING NAME Company Name
res.set_NAME(get_NAME());
// STRING PHONE01 Phone #1
res.set_PHONE01(get_PHONE01());
// STRING PHONE02 Phone #2
res.set_PHONE02(get_PHONE02());
// STRING REM Remark
res.set_REM(get_REM());
// STRING UID VAT Number
res.set_UID(get_UID());
// DATE VALID_UNTIL Valid until
res.set_VALID_UNTIL(get_VALID_UNTIL());
// STRING WWW WWW Address
res.set_WWW(get_WWW());
// STRING ZIPCODE ZIP Code
res.set_ZIPCODE(get_ZIPCODE());
return res;
}
/**
* {@link #executeQuery()} and store elements of type T_D2S_COMPANY_Obj in a Vector.
* Perform a {@link #close()} afterwards.
*/
public e4sPersistantVector getQuery()
throws dbException
{
e4sPersistantVector res = new e4sPersistantVector();
executeQuery();
while( next() )
{
T_D2S_COMPANY_Obj data = get();
res.addElement(data);
}
close();
return res;
}
/*
* Add a query to a repository.
* First, a {@link e4s.persistant.e4sPersistantVector} object is created by using the {@link #getQuery()} function,
* and beeing added to the repository, which may not be null.
*
* @param repository the repository where the entries for {@link tabledef.T_D2S_COMPANY} are added.
*
* @see #getQuery()
*/
public void getQuery(e4sPersistantRepository repository)
throws dbException
{
if (repository != null)
{
e4sPersistantVector dataVec = getQuery();
repository.add(T_D2S_COMPANY_Obj.class,dataVec);
}
}
// generated using dbTable.generateClass_Function_Sort:4706
/**
* Sort ascending by column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void sort_ADDRESS01()
{
setOrderBy(COL_ADDRESS01,false);
}
/**
* Sort descending by column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void sort_ADDRESS01_descending()
{
setOrderBy(COL_ADDRESS01,true);
}
/**
* Sort ascending by column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void sort_ADDRESS02()
{
setOrderBy(COL_ADDRESS02,false);
}
/**
* Sort descending by column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void sort_ADDRESS02_descending()
{
setOrderBy(COL_ADDRESS02,true);
}
/**
* Sort ascending by column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @see e4s.db.systabledef.CompanyId
*/
public void sort_BELONGS_TO()
{
setOrderBy(COL_BELONGS_TO,false);
}
/**
* Sort descending by column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @see e4s.db.systabledef.CompanyId
*/
public void sort_BELONGS_TO_descending()
{
setOrderBy(COL_BELONGS_TO,true);
}
/**
* Sort ascending by column CITY.
* STRING(60)
* City
*/
public void sort_CITY()
{
setOrderBy(COL_CITY,false);
}
/**
* Sort descending by column CITY.
* STRING(60)
* City
*/
public void sort_CITY_descending()
{
setOrderBy(COL_CITY,true);
}
/**
* Sort ascending by column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @see e4s.db.systabledef.CompanyId
*/
public void sort_COMPANY_ID()
{
setOrderBy(COL_COMPANY_ID,false);
}
/**
* Sort descending by column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @see e4s.db.systabledef.CompanyId
*/
public void sort_COMPANY_ID_descending()
{
setOrderBy(COL_COMPANY_ID,true);
}
/**
* Sort ascending by column COUNTRYCODE.
* CountryCode
* Countrycode
*/
public void sort_COUNTRYCODE()
{
setOrderBy(COL_COUNTRYCODE,false);
}
/**
* Sort descending by column COUNTRYCODE.
* CountryCode
* Countrycode
*/
public void sort_COUNTRYCODE_descending()
{
setOrderBy(COL_COUNTRYCODE,true);
}
/**
* Sort ascending by column DATMOD.
* DATE
* Date modified
*/
public void sort_DATMOD()
{
setOrderBy(COL_DATMOD,false);
}
/**
* Sort descending by column DATMOD.
* DATE
* Date modified
*/
public void sort_DATMOD_descending()
{
setOrderBy(COL_DATMOD,true);
}
/**
* Sort ascending by column DATNEW.
* DATE
* Date created
*/
public void sort_DATNEW()
{
setOrderBy(COL_DATNEW,false);
}
/**
* Sort descending by column DATNEW.
* DATE
* Date created
*/
public void sort_DATNEW_descending()
{
setOrderBy(COL_DATNEW,true);
}
/**
* Sort ascending by column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void sort_EMAIL()
{
setOrderBy(COL_EMAIL,false);
}
/**
* Sort descending by column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void sort_EMAIL_descending()
{
setOrderBy(COL_EMAIL,true);
}
/**
* Sort ascending by column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*/
public void sort_GIS_LATITUDE()
{
setOrderBy(COL_GIS_LATITUDE,false);
}
/**
* Sort descending by column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*/
public void sort_GIS_LATITUDE_descending()
{
setOrderBy(COL_GIS_LATITUDE,true);
}
/**
* Sort ascending by column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*/
public void sort_GIS_LONGITUDE()
{
setOrderBy(COL_GIS_LONGITUDE,false);
}
/**
* Sort descending by column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*/
public void sort_GIS_LONGITUDE_descending()
{
setOrderBy(COL_GIS_LONGITUDE,true);
}
/**
* Sort ascending by column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void sort_GROUP_ID()
{
setOrderBy(COL_GROUP_ID,false);
}
/**
* Sort descending by column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void sort_GROUP_ID_descending()
{
setOrderBy(COL_GROUP_ID,true);
}
/**
* Sort ascending by column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void sort_LOGIN_NAME()
{
setOrderBy(COL_LOGIN_NAME,false);
}
/**
* Sort descending by column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void sort_LOGIN_NAME_descending()
{
setOrderBy(COL_LOGIN_NAME,true);
}
/**
* Sort ascending by column NAME.
* STRING(60)
* Company Name
*/
public void sort_NAME()
{
setOrderBy(COL_NAME,false);
}
/**
* Sort descending by column NAME.
* STRING(60)
* Company Name
*/
public void sort_NAME_descending()
{
setOrderBy(COL_NAME,true);
}
/**
* Sort ascending by column PHONE01.
* STRING(60)
* Phone #1
*/
public void sort_PHONE01()
{
setOrderBy(COL_PHONE01,false);
}
/**
* Sort descending by column PHONE01.
* STRING(60)
* Phone #1
*/
public void sort_PHONE01_descending()
{
setOrderBy(COL_PHONE01,true);
}
/**
* Sort ascending by column PHONE02.
* STRING(60)
* Phone #2
*/
public void sort_PHONE02()
{
setOrderBy(COL_PHONE02,false);
}
/**
* Sort descending by column PHONE02.
* STRING(60)
* Phone #2
*/
public void sort_PHONE02_descending()
{
setOrderBy(COL_PHONE02,true);
}
/**
* Sort ascending by column REM.
* STRING(255)
* Remark
*/
public void sort_REM()
{
setOrderBy(COL_REM,false);
}
/**
* Sort descending by column REM.
* STRING(255)
* Remark
*/
public void sort_REM_descending()
{
setOrderBy(COL_REM,true);
}
/**
* Sort ascending by column UID.
* STRING(10)
* VAT Number
*/
public void sort_UID()
{
setOrderBy(COL_UID,false);
}
/**
* Sort descending by column UID.
* STRING(10)
* VAT Number
*/
public void sort_UID_descending()
{
setOrderBy(COL_UID,true);
}
/**
* Sort ascending by column VALID_UNTIL.
* DATE
* Valid until
*/
public void sort_VALID_UNTIL()
{
setOrderBy(COL_VALID_UNTIL,false);
}
/**
* Sort descending by column VALID_UNTIL.
* DATE
* Valid until
*/
public void sort_VALID_UNTIL_descending()
{
setOrderBy(COL_VALID_UNTIL,true);
}
/**
* Sort ascending by column WWW.
* STRING(60)
* WWW Address
*/
public void sort_WWW()
{
setOrderBy(COL_WWW,false);
}
/**
* Sort descending by column WWW.
* STRING(60)
* WWW Address
*/
public void sort_WWW_descending()
{
setOrderBy(COL_WWW,true);
}
/**
* Sort ascending by column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void sort_ZIPCODE()
{
setOrderBy(COL_ZIPCODE,false);
}
/**
* Sort descending by column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void sort_ZIPCODE_descending()
{
setOrderBy(COL_ZIPCODE,true);
}
// generated using dbTable.generateClass_Function_Filter:4819
/**
* Define a filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01(final String filter)
throws dbException
{
setFilter(COL_ADDRESS01,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ADDRESS01(int operator, final String filter)
throws dbException
{
setFilter(COL_ADDRESS01,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_in(final String filter[])
throws dbException
{
setFilter(COL_ADDRESS01,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_ADDRESS01,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNull()
throws dbException
{
isNull(COL_ADDRESS01);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNotNull()
throws dbException
{
isNotNull(COL_ADDRESS01);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_ADDRESS01,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_ADDRESS01,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isEmpty()
throws dbException
{
isEmpty(COL_ADDRESS01);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNotEmpty()
throws dbException
{
isNotEmpty(COL_ADDRESS01);
}
/**
* Define a filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02(final String filter)
throws dbException
{
setFilter(COL_ADDRESS02,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ADDRESS02(int operator, final String filter)
throws dbException
{
setFilter(COL_ADDRESS02,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_in(final String filter[])
throws dbException
{
setFilter(COL_ADDRESS02,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_ADDRESS02,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNull()
throws dbException
{
isNull(COL_ADDRESS02);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNotNull()
throws dbException
{
isNotNull(COL_ADDRESS02);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_ADDRESS02,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_ADDRESS02,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isEmpty()
throws dbException
{
isEmpty(COL_ADDRESS02);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNotEmpty()
throws dbException
{
isNotEmpty(COL_ADDRESS02);
}
/**
* Define a filter (AND-ed WHERE) for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO(final CompanyId filter)
throws dbException
{
setFilter(COL_BELONGS_TO,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO(int operator, final CompanyId filter)
throws dbException
{
setFilter(COL_BELONGS_TO,operator,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_BELONGS_TO,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_BELONGS_TO,filter);
}
/**
* Define a filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY(final String filter)
throws dbException
{
setFilter(COL_CITY,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_CITY(int operator, final String filter)
throws dbException
{
setFilter(COL_CITY,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_in(final String filter[])
throws dbException
{
setFilter(COL_CITY,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_CITY,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNull()
throws dbException
{
isNull(COL_CITY);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNotNull()
throws dbException
{
isNotNull(COL_CITY);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_CITY,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_CITY,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isEmpty()
throws dbException
{
isEmpty(COL_CITY);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNotEmpty()
throws dbException
{
isNotEmpty(COL_CITY);
}
/**
* Define a filter (AND-ed WHERE) for column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID(final CompanyId filter)
throws dbException
{
setFilter(COL_COMPANY_ID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID(int operator, final CompanyId filter)
throws dbException
{
setFilter(COL_COMPANY_ID,operator,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_COMPANY_ID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_COMPANY_ID,filter);
}
/**
* Define a filter (AND-ed WHERE) for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @param filter the value to be compared within the SQL statement
*/
public void where_COUNTRYCODE(final CountryCode filter)
throws dbException
{
setFilter(COL_COUNTRYCODE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_COUNTRYCODE(int operator, final CountryCode filter)
throws dbException
{
setFilter(COL_COUNTRYCODE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD(final java.util.Date filter)
throws dbException
{
setFilter(COL_DATMOD,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_DATMOD(int operator, final java.util.Date filter)
throws dbException
{
setFilter(COL_DATMOD,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNull()
throws dbException
{
isNull(COL_DATMOD);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNotNull()
throws dbException
{
isNotNull(COL_DATMOD);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_DATMOD,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_DATMOD,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isEmpty()
throws dbException
{
isEmpty(COL_DATMOD);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNotEmpty()
throws dbException
{
isNotEmpty(COL_DATMOD);
}
/**
* Define a filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW(final java.util.Date filter)
throws dbException
{
setFilter(COL_DATNEW,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_DATNEW(int operator, final java.util.Date filter)
throws dbException
{
setFilter(COL_DATNEW,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNull()
throws dbException
{
isNull(COL_DATNEW);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNotNull()
throws dbException
{
isNotNull(COL_DATNEW);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_DATNEW,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_DATNEW,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isEmpty()
throws dbException
{
isEmpty(COL_DATNEW);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNotEmpty()
throws dbException
{
isNotEmpty(COL_DATNEW);
}
/**
* Define a filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL(final String filter)
throws dbException
{
setFilter(COL_EMAIL,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_EMAIL(int operator, final String filter)
throws dbException
{
setFilter(COL_EMAIL,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_in(final String filter[])
throws dbException
{
setFilter(COL_EMAIL,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_EMAIL,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNull()
throws dbException
{
isNull(COL_EMAIL);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNotNull()
throws dbException
{
isNotNull(COL_EMAIL);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_EMAIL,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_EMAIL,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isEmpty()
throws dbException
{
isEmpty(COL_EMAIL);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNotEmpty()
throws dbException
{
isNotEmpty(COL_EMAIL);
}
/**
* Define a filter (AND-ed WHERE) for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @param filter the value to be compared within the SQL statement
*/
public void where_GIS_LATITUDE(final float filter)
throws dbException
{
setFilter(COL_GIS_LATITUDE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_GIS_LATITUDE(int operator, final float filter)
throws dbException
{
setFilter(COL_GIS_LATITUDE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @param filter the value to be compared within the SQL statement
*/
public void where_GIS_LONGITUDE(final float filter)
throws dbException
{
setFilter(COL_GIS_LONGITUDE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_GIS_LONGITUDE(int operator, final float filter)
throws dbException
{
setFilter(COL_GIS_LONGITUDE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID(final CompanyGroup filter)
throws dbException
{
setFilter(COL_GROUP_ID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID(int operator, final CompanyGroup filter)
throws dbException
{
setFilter(COL_GROUP_ID,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_in(final CompanyGroup filter[])
throws dbException
{
setFilter(COL_GROUP_ID,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_not_in(final CompanyGroup filter[])
throws dbException
{
setFilter_NOT(COL_GROUP_ID,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNull()
throws dbException
{
isNull(COL_GROUP_ID);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNotNull()
throws dbException
{
isNotNull(COL_GROUP_ID);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_GROUP_ID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_GROUP_ID,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isEmpty()
throws dbException
{
isEmpty(COL_GROUP_ID);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNotEmpty()
throws dbException
{
isNotEmpty(COL_GROUP_ID);
}
/**
* Define a filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME(final String filter)
throws dbException
{
setFilter(COL_LOGIN_NAME,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_LOGIN_NAME(int operator, final String filter)
throws dbException
{
setFilter(COL_LOGIN_NAME,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_in(final String filter[])
throws dbException
{
setFilter(COL_LOGIN_NAME,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_LOGIN_NAME,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNull()
throws dbException
{
isNull(COL_LOGIN_NAME);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNotNull()
throws dbException
{
isNotNull(COL_LOGIN_NAME);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_LOGIN_NAME,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_LOGIN_NAME,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isEmpty()
throws dbException
{
isEmpty(COL_LOGIN_NAME);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNotEmpty()
throws dbException
{
isNotEmpty(COL_LOGIN_NAME);
}
/**
* Define a filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME(final String filter)
throws dbException
{
setFilter(COL_NAME,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_NAME(int operator, final String filter)
throws dbException
{
setFilter(COL_NAME,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_in(final String filter[])
throws dbException
{
setFilter(COL_NAME,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_NAME,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNull()
throws dbException
{
isNull(COL_NAME);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNotNull()
throws dbException
{
isNotNull(COL_NAME);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_NAME,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_NAME,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isEmpty()
throws dbException
{
isEmpty(COL_NAME);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNotEmpty()
throws dbException
{
isNotEmpty(COL_NAME);
}
/**
* Define a filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01(final String filter)
throws dbException
{
setFilter(COL_PHONE01,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_PHONE01(int operator, final String filter)
throws dbException
{
setFilter(COL_PHONE01,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_in(final String filter[])
throws dbException
{
setFilter(COL_PHONE01,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_PHONE01,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNull()
throws dbException
{
isNull(COL_PHONE01);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNotNull()
throws dbException
{
isNotNull(COL_PHONE01);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_PHONE01,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_PHONE01,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isEmpty()
throws dbException
{
isEmpty(COL_PHONE01);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNotEmpty()
throws dbException
{
isNotEmpty(COL_PHONE01);
}
/**
* Define a filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02(final String filter)
throws dbException
{
setFilter(COL_PHONE02,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_PHONE02(int operator, final String filter)
throws dbException
{
setFilter(COL_PHONE02,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_in(final String filter[])
throws dbException
{
setFilter(COL_PHONE02,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_PHONE02,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNull()
throws dbException
{
isNull(COL_PHONE02);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNotNull()
throws dbException
{
isNotNull(COL_PHONE02);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_PHONE02,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_PHONE02,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isEmpty()
throws dbException
{
isEmpty(COL_PHONE02);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNotEmpty()
throws dbException
{
isNotEmpty(COL_PHONE02);
}
/**
* Define a filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM(final String filter)
throws dbException
{
setFilter(COL_REM,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_REM(int operator, final String filter)
throws dbException
{
setFilter(COL_REM,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_in(final String filter[])
throws dbException
{
setFilter(COL_REM,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_REM,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNull()
throws dbException
{
isNull(COL_REM);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNotNull()
throws dbException
{
isNotNull(COL_REM);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_REM,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_REM,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isEmpty()
throws dbException
{
isEmpty(COL_REM);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNotEmpty()
throws dbException
{
isNotEmpty(COL_REM);
}
/**
* Define a filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID(final String filter)
throws dbException
{
setFilter(COL_UID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_UID(int operator, final String filter)
throws dbException
{
setFilter(COL_UID,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_in(final String filter[])
throws dbException
{
setFilter(COL_UID,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_UID,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNull()
throws dbException
{
isNull(COL_UID);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNotNull()
throws dbException
{
isNotNull(COL_UID);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_UID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_UID,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isEmpty()
throws dbException
{
isEmpty(COL_UID);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNotEmpty()
throws dbException
{
isNotEmpty(COL_UID);
}
/**
* Define a filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL(final java.util.Date filter)
throws dbException
{
setFilter(COL_VALID_UNTIL,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_VALID_UNTIL(int operator, final java.util.Date filter)
throws dbException
{
setFilter(COL_VALID_UNTIL,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNull()
throws dbException
{
isNull(COL_VALID_UNTIL);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNotNull()
throws dbException
{
isNotNull(COL_VALID_UNTIL);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_VALID_UNTIL,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_VALID_UNTIL,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isEmpty()
throws dbException
{
isEmpty(COL_VALID_UNTIL);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNotEmpty()
throws dbException
{
isNotEmpty(COL_VALID_UNTIL);
}
/**
* Define a filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW(final String filter)
throws dbException
{
setFilter(COL_WWW,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_WWW(int operator, final String filter)
throws dbException
{
setFilter(COL_WWW,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_in(final String filter[])
throws dbException
{
setFilter(COL_WWW,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_WWW,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNull()
throws dbException
{
isNull(COL_WWW);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNotNull()
throws dbException
{
isNotNull(COL_WWW);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_WWW,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_WWW,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isEmpty()
throws dbException
{
isEmpty(COL_WWW);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNotEmpty()
throws dbException
{
isNotEmpty(COL_WWW);
}
/**
* Define a filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE(final String filter)
throws dbException
{
setFilter(COL_ZIPCODE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ZIPCODE(int operator, final String filter)
throws dbException
{
setFilter(COL_ZIPCODE,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_in(final String filter[])
throws dbException
{
setFilter(COL_ZIPCODE,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_not_in(final String filter[])
throws dbException
{
setFilter_NOT(COL_ZIPCODE,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNull()
throws dbException
{
isNull(COL_ZIPCODE);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNotNull()
throws dbException
{
isNotNull(COL_ZIPCODE);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(COL_ZIPCODE,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(COL_ZIPCODE,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isEmpty()
throws dbException
{
isEmpty(COL_ZIPCODE);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNotEmpty()
throws dbException
{
isNotEmpty(COL_ZIPCODE);
}
// generated using dbTable.generateClass_Reference:2721
/*
* List of references for delete trigger.
*
* @return null if no delete references are set or an array of objects of
* class {@link e4s.db.e4s.db.dbReference} with associated tables.
*/
public dbReference[] getReferenceDelete(dbColumnName cName)
{
return null;
}
// generated using dbTable.generateClass_Reference:2721
/*
* List of references for lookup-reference trigger.
*
* @return null if no delete references are set or an array of objects of
* class {@link e4s.db.e4s.db.dbReference} with associated tables.
*/
public dbReference[] getReferenceLookup(dbColumnName cName)
{
return null;
}
// generated using dbTable.generateClass_Fieldset:2957
public FIELDSET createFIELDSET( FORM form )
{
FIELDSET res = createFIELDSET(getApplicationObject());
if (form != null)
form.addElement(res);
return res;
}
public static FIELDSET createFIELDSET()
{
return createFIELDSET((applObject_Intf)null);
}
//@SuppressWarnings("unused")
public static FIELDSET createFIELDSET(applObject_Intf applobj)
{
FIELDSET res = new FIELDSET(new e4sID(TABLENAME));
/*TEXTFIELD f_ADDRESS01 =*/ res.TEXTFIELD(COL_ADDRESS01,"ADDRESS01",CI_ADDRESS01.getLen());
/*TEXTFIELD f_ADDRESS02 =*/ res.TEXTFIELD(COL_ADDRESS02,"ADDRESS02",CI_ADDRESS02.getLen());
/*LONGFIELD f_BELONGS_TO =*/ res.LONGFIELD(COL_BELONGS_TO,"BELONGS_TO",5);
/*TEXTFIELD f_CITY =*/ res.TEXTFIELD(COL_CITY,"CITY",CI_CITY.getLen());
/*LONGFIELD f_COMPANY_ID =*/ res.LONGFIELD(COL_COMPANY_ID,"COMPANY_ID",5);
/*SELECT f_COUNTRYCODE =*/ res.SELECT(COL_COUNTRYCODE,"COUNTRYCODE",CountryCode.getCountrySelection());
DATEFIELD f_DATMOD =res.DATEFIELD(COL_DATMOD,"DATMOD");
f_DATMOD.noTimeFormat();
DATEFIELD f_DATNEW =res.DATEFIELD(COL_DATNEW,"DATNEW");
f_DATNEW.noTimeFormat();
/*TEXTFIELD f_EMAIL =*/ res.TEXTFIELD(COL_EMAIL,"EMAIL",CI_EMAIL.getLen());
/*FLOATFIELD f_GIS_LATITUDE =*/ res.FLOATFIELD(COL_GIS_LATITUDE,"GIS_LATITUDE");
/*FLOATFIELD f_GIS_LONGITUDE =*/ res.FLOATFIELD(COL_GIS_LONGITUDE,"GIS_LONGITUDE");
/*TEXTFIELD f_GROUP_ID =*/ res.TEXTFIELD(COL_GROUP_ID,"GROUP_ID",CompanyGroup.LEN);
/*TEXTFIELD f_LOGIN_NAME =*/ res.TEXTFIELD(COL_LOGIN_NAME,"LOGIN_NAME",CI_LOGIN_NAME.getLen());
/*TEXTFIELD f_NAME =*/ res.TEXTFIELD(COL_NAME,"NAME",CI_NAME.getLen());
/*TEXTFIELD f_PHONE01 =*/ res.TEXTFIELD(COL_PHONE01,"PHONE01",CI_PHONE01.getLen());
/*TEXTFIELD f_PHONE02 =*/ res.TEXTFIELD(COL_PHONE02,"PHONE02",CI_PHONE02.getLen());
/*TEXTAREA f_REM =*/ res.TEXTAREA(COL_REM,"REM",50,5);
/*TEXTFIELD f_UID =*/ res.TEXTFIELD(COL_UID,"UID",CI_UID.getLen());
DATEFIELD f_VALID_UNTIL =res.DATEFIELD(COL_VALID_UNTIL,"VALID_UNTIL");
f_VALID_UNTIL.noTimeFormat();
/*TEXTFIELD f_WWW =*/ res.TEXTFIELD(COL_WWW,"WWW",CI_WWW.getLen());
/*TEXTFIELD f_ZIPCODE =*/ res.TEXTFIELD(COL_ZIPCODE,"ZIPCODE",CI_ZIPCODE.getLen());
return res;
}
// generated using dbTable.generateClass_Fieldset_Get:3329
/*
* Create a {@link e4s.html.input.extended.FIELDSET} element.
*
* @return the new created fieldset element
*
* @see #get_FIELDSET(e4s.html.FORM)
* @see #get(e4s.html.input.extended.FIELDSET)
*/
public FIELDSET get_FIELDSET()
throws dbException
{
return get_FIELDSET(null);
}
/*
* Create a {@link e4s.html.input.extended.FIELDSET} element. The element
* will be assigned to the specified form- if available.
*
* @param form a valid form object where the FIELDSET element will be assigned, or null
*
* @return the new created fieldset element
*
* @see #get_FIELDSET()
* @see #get(e4s.html.input.extended.FIELDSET)
*/
public FIELDSET get_FIELDSET(FORM form)
throws dbException
{
FIELDSET res = null;
if (form != null)
res = createFIELDSET(form);
else
res = new FIELDSET(e4sID());
get(res);
return res;
}
/*
* Get the data into the {@link e4s.html.input.extended.FIELDSET} element.
*
* @param fieldset the element where the values will be stored.
*
* @see #get_FIELDSET()
* @see #get_FIELDSET(e4s.html.FORM)
*/
public void get(FIELDSET fieldset)
throws dbException
{
try
{
if (fieldset != null)
{
fieldset.setValue( COL_ADDRESS01,get_ADDRESS01() );
fieldset.setValue( COL_ADDRESS02,get_ADDRESS02() );
fieldset.setValue( COL_BELONGS_TO,get_BELONGS_TO() );
fieldset.setValue( COL_CITY,get_CITY() );
fieldset.setValue( COL_COMPANY_ID,get_COMPANY_ID() );
fieldset.setValue( COL_COUNTRYCODE,get_COUNTRYCODE() );
fieldset.setValue( COL_DATMOD,get_DATMOD() );
fieldset.setValue( COL_DATNEW,get_DATNEW() );
fieldset.setValue( COL_EMAIL,get_EMAIL() );
fieldset.setValue( COL_GIS_LATITUDE,get_GIS_LATITUDE() );
fieldset.setValue( COL_GIS_LONGITUDE,get_GIS_LONGITUDE() );
fieldset.setValue( COL_GROUP_ID,get_GROUP_ID() );
fieldset.setValue( COL_LOGIN_NAME,get_LOGIN_NAME() );
fieldset.setValue( COL_NAME,get_NAME() );
fieldset.setValue( COL_PHONE01,get_PHONE01() );
fieldset.setValue( COL_PHONE02,get_PHONE02() );
fieldset.setValue( COL_REM,get_REM() );
fieldset.setValue( COL_UID,get_UID() );
fieldset.setValue( COL_VALID_UNTIL,get_VALID_UNTIL() );
fieldset.setValue( COL_WWW,get_WWW() );
fieldset.setValue( COL_ZIPCODE,get_ZIPCODE() );
}
}
catch( Exception e )
{
throw new dbException(e);
}
}
// generated using dbTable.generateClass_Usage:4631
/**
* For the case, that the specified column is a e4s defined type (e.g. {@link e4s.util.e4sLong}, {@link e4s.util.e4sString})
* this function returns an array in which tables and columns this type is used, except the current table and the
* specified column.
*
* @param colname the column to be checked
*
* @see e4s.db.dbIntegrity
*/
public dbType_Usage[] getUsage(dbColumnName colname)
{
dbType_Usage res[] = null;
if ((colname != null) && colname.equals(COL_BELONGS_TO))
res = CompanyId.getUsage();
if ((colname != null) && colname.equals(COL_COMPANY_ID))
res = CompanyId.getUsage();
if ((colname != null) && colname.equals(COL_COUNTRYCODE))
res = CountryCode.getUsage();
if ((colname != null) && colname.equals(COL_GROUP_ID))
res = CompanyGroup.getUsage();
return removeOwnTableColumn(res,TABLENAME,colname);
}
// generated using dbTable.generateClass_Function_AnyData:4675
/**
* Check, if this table contains any data.
*
* @param con the connection
* @param applobj the application object containing the Client to be checked
*/
public static boolean isEmpty(dbConnection_Intf con,applObject_Intf applobj)
throws dbException
{
boolean res = true;
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(con,applobj);
T_D2S_COMPANY.executeQuery(1);
if (T_D2S_COMPANY.next())
res = false;
T_D2S_COMPANY.close();
return res;
}
// generated using dbTable.generateClass_Index:4164
/**
* Find a record associates with index 1.
*
* @param appobj the current application object containing client informations
* @param qCOMPANY_ID query Primary key, company - ID
*/
public static T_D2S_COMPANY_Obj find_COMPANY_ID(applObject_Intf appobj, CompanyId qCOMPANY_ID)
throws dbException
{
T_D2S_COMPANY_Obj res = null;
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.where_COMPANY_ID(qCOMPANY_ID);
T_D2S_COMPANY.executeQuery();
if (T_D2S_COMPANY.next())
res = T_D2S_COMPANY.get();
T_D2S_COMPANY.close();
return res;
}
/**
* Find a record associates with index 1 and read associated freefield values.
*
* @param appobj the current application object containing client informations
* @param qCOMPANY_ID query Primary key, company - ID
* @param readfreefields read freefield values.
*/
public static T_D2S_COMPANY_Obj find_COMPANY_ID(boolean readfreefields, applObject_Intf appobj, CompanyId qCOMPANY_ID)
throws dbException
{
T_D2S_COMPANY_Obj res = null;
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.where_COMPANY_ID(qCOMPANY_ID);
T_D2S_COMPANY.executeQuery();
if (T_D2S_COMPANY.next())
res = T_D2S_COMPANY.get(readfreefields);
T_D2S_COMPANY.close();
return res;
}
// generated using dbTable.generateClass_Index:4164
/**
* Find a record associates with index 2.
*
* @param appobj the current application object containing client informations
* @param qLOGIN_NAME query Name for login
*/
public static T_D2S_COMPANY_Obj find_LOGIN_NAME(applObject_Intf appobj, String qLOGIN_NAME)
throws dbException
{
T_D2S_COMPANY_Obj res = null;
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.where_LOGIN_NAME(qLOGIN_NAME);
T_D2S_COMPANY.executeQuery();
if (T_D2S_COMPANY.next())
res = T_D2S_COMPANY.get();
T_D2S_COMPANY.close();
return res;
}
/**
* Find a record associates with index 2 and read associated freefield values.
*
* @param appobj the current application object containing client informations
* @param qLOGIN_NAME query Name for login
* @param readfreefields read freefield values.
*/
public static T_D2S_COMPANY_Obj find_LOGIN_NAME(boolean readfreefields, applObject_Intf appobj, String qLOGIN_NAME)
throws dbException
{
T_D2S_COMPANY_Obj res = null;
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.where_LOGIN_NAME(qLOGIN_NAME);
T_D2S_COMPANY.executeQuery();
if (T_D2S_COMPANY.next())
res = T_D2S_COMPANY.get(readfreefields);
T_D2S_COMPANY.close();
return res;
}
/**
* Export data from database table to XML file
*
* @param out an opened output stream
*
* @return the number of records written
*
* @see toCsv(e4s.util.e4sPrintStream)
* @see toXml(String)
*/
public int toXml(e4sPrintStream out)
throws dbException
{
int res = 0;
out.TagStart(xmlImportHandler._XML_TAG_TABLE,xmlImportHandler._XML_ATTR_TABLE_NAME,TABLENAME.getName());
out.TagStart(xmlImportHandler._XML_TAG_INFO);
out.Tag("VERSION","1.01a");
out.Tag("EXPORTED",new java.util.Date());
out.TagEnd(xmlImportHandler._XML_TAG_INFO);
out.TagStart(xmlImportHandler._XML_TAG_DICT);
out.println(Client.COLUMN_INFO.makeXmlString_Export());
for( int i = 0; i < T_D2S_COMPANY_Sel.COLUMNS.length; i++ )
out.println( T_D2S_COMPANY_Sel.COLUMNS[i].makeXmlString_Export() );
out.TagEnd(xmlImportHandler._XML_TAG_DICT);
while(next())
{
out.TagStart(xmlImportHandler._XML_TAG_DATA);
out.Tag(Client.COLUMN_NAME,get_CLIENT());
out.Tag(COL_ADDRESS01,get_ADDRESS01());
out.Tag(COL_ADDRESS02,get_ADDRESS02());
out.Tag(COL_BELONGS_TO,get_BELONGS_TO());
out.Tag(COL_CITY,get_CITY());
out.Tag(COL_COMPANY_ID,get_COMPANY_ID());
out.Tag(COL_COUNTRYCODE,get_COUNTRYCODE());
out.Tag(COL_DATMOD,get_DATMOD());
out.Tag(COL_DATNEW,get_DATNEW());
out.Tag(COL_EMAIL,get_EMAIL());
out.Tag(COL_GIS_LATITUDE,get_GIS_LATITUDE());
out.Tag(COL_GIS_LONGITUDE,get_GIS_LONGITUDE());
out.Tag(COL_GROUP_ID,get_GROUP_ID());
out.Tag(COL_LOGIN_NAME,get_LOGIN_NAME());
out.Tag(COL_NAME,get_NAME());
out.Tag(COL_PHONE01,get_PHONE01());
out.Tag(COL_PHONE02,get_PHONE02());
out.Tag(COL_REM,get_REM());
out.Tag(COL_UID,get_UID());
out.Tag(COL_VALID_UNTIL,get_VALID_UNTIL());
out.Tag(COL_WWW,get_WWW());
out.Tag(COL_ZIPCODE,get_ZIPCODE());
out.TagEnd(xmlImportHandler._XML_TAG_DATA);
res++;
}
out.TagEnd(xmlImportHandler._XML_TAG_TABLE);
return res;
}
/**
* Export data from database table to XML file.
*
* @param appobj the current application object containing client informations
* @param path the path for file export
*
* @return the number of records written
*/
public static int toXml(applObject_Intf appobj, String path)
throws dbException, IOException
{
int res = 0;
String fPath = e4sUtil.concatenatePath(path,TABLENAME.getName() + ".xml");
e4sPrintStream out = new e4sPrintStream(fPath,e4sPrintStream.CHARSET_UTF8);
out.println(out.XmlHeader());
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.executeQuery();
res = T_D2S_COMPANY.toXml(out);
T_D2S_COMPANY.close();
return res;
}
// generated using dbTable.generateClass_Export_Csv:3978
/**
* Export data from database table to CSV file (MS-Excel compatible input format).
*
* @param out an opened output stream
* @param include_freefields true include freefield values in export.
*
* @return the number of records written
*/
public int toCsv(e4sPrintStream out, boolean include_freefields)
throws dbException
{
int res = 0;
data2csvHeader(out,Client.COLUMN_INFO);
data2csvHeader(out,COLUMNS);
FreefieldName freefields[] = include_freefields ? data2csvHeaderFreefields(out) : null;
out.println();
while(next())
{
data2csv(out,get_CLIENT());
data2csv(out,get_ADDRESS01());
data2csv(out,get_ADDRESS02());
data2csv(out,get_BELONGS_TO());
data2csv(out,get_CITY());
data2csv(out,get_COMPANY_ID());
data2csv(out,get_COUNTRYCODE());
data2csv(out,get_DATMOD());
data2csv(out,get_DATNEW());
data2csv(out,get_EMAIL());
data2csv(out,get_GIS_LATITUDE());
data2csv(out,get_GIS_LONGITUDE());
data2csv(out,get_GROUP_ID());
data2csv(out,get_LOGIN_NAME());
data2csv(out,get_NAME());
data2csv(out,get_PHONE01());
data2csv(out,get_PHONE02());
data2csv(out,get_REM());
data2csv(out,get_UID());
data2csv(out,get_VALID_UNTIL());
data2csv(out,get_WWW());
data2csv(out,get_ZIPCODE());
if ((freefields != null) && (freefields.length > 0))
{
for( int iF = 0; iF < freefields.length; iF++ )
{
String value = getFreeval(freefields[iF]);
data2csv(out,value);
}
}
out.println();
res++;
}
return res;
}
/**
* Export data from database table to CSV file (MS-Excel compatible input format).
*
* @param out an opened output stream
* @param freefields true include freefield values in export.
*
* @return the number of records written
*/
public int toCsv(e4sPrintStream out)
throws dbException
{
return toCsv(out,false);
}
/**
* Export data from database table to CSV file (MS-Excel input format).
*
* @param appobj the current application object containing client informations
* @param path the path for file export
* @param freefields true include freefield values in export.
*
* @return the number of records written
*/
public static int toCsv(applObject_Intf appobj, String path, boolean freefields)
throws dbException, IOException
{
int res = 0;
String fPath = e4sUtil.concatenatePath(path,TABLENAME.getName() + ".csv");
e4sPrintStream out = new e4sPrintStream(fPath,e4sPrintStream.CHARSET_UTF8);
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(appobj);
T_D2S_COMPANY.executeQuery();
res = T_D2S_COMPANY.toCsv(out,freefields);
T_D2S_COMPANY.close();
out.close();
return res;
}
/**
* Export data from database table to CSV file (MS-Excel input format).
*
* @param appobj the current application object containing client informations
* @param path the path for file export
*
* @return the number of records written
*/
public static int toCsv(applObject_Intf appobj, String path)
throws dbException, IOException
{
return toCsv(appobj, path, false);
}
/**
* Get the definitions of the free fields.
*
* @param applobj the application object
*
* @return the definitions for table T_D2S_COMPANY.
*
* @see e4s.db.freefield.dbSelectFreefields#getFreevalDefinitions(e4s.application.applObject_Intf,e4s.db.dbTableName)
* @see e4s.db.freefield.dbSelectFreefields#getFreevalDefinitions()
*/
public static T_D2S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(applObject_Intf applobj)
throws dbException
{
return dbSelectFreefields.getFreevalDefinitions(applobj,TABLENAME);
}
/**
* Get a value for the free-field specified.
* Based on unique index COMPANY_ID
*
* @param fieldname the name of the free field
*/
public String getFreeval( FreefieldName fieldname )
throws dbException
{
String res = null;
if (fieldname == null)
throw new dbException("Fieldname not specified");
T_D2S_FREEFIELD_VAL_Sel T_D2S_FREEFIELD_VAL = new T_D2S_FREEFIELD_VAL_Sel(getApplicationObject());
T_D2S_FREEFIELD_VAL.where_DB_TABLE(TABLENAME.getName());
T_D2S_FREEFIELD_VAL.where_FREEFIELD_NAME(fieldname.getName());
T_D2S_FREEFIELD_VAL.where_IDX1(getString(COL_COMPANY_ID));
T_D2S_FREEFIELD_VAL.executeQuery();
if (T_D2S_FREEFIELD_VAL.next())
res = T_D2S_FREEFIELD_VAL.get_VAL();
T_D2S_FREEFIELD_VAL.close();
return res;
}
/**
* Check table consistency against database.
*/
public static void checkConsistency()
throws dbException
{
if (! m_checked_conistency)
{
m_checked_conistency = true;
dbSelect.checkConsistencyTable(TABLENAME,IS_CLIENT_DISTINCTIVE,COLUMNS);
dbSelect.checkConsistencyIndex(TABLENAME,INDEXES);
}
}
}