public class JurisdictionAccessBean extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean implements JurisdictionAccessBeanData
Constructor and Description |
---|
JurisdictionAccessBean()
Zero argument constructor used to initialize the access bean.
|
JurisdictionAccessBean(javax.ejb.EJBObject o) |
JurisdictionAccessBean(java.lang.String aCode, java.lang.Integer aStoreEntityId, java.lang.Integer aSubclass) |
Modifier and Type | Method and Description |
---|---|
void | commitCopyHelper() |
protected java.lang.String | defaultJNDIName() |
java.util.Enumeration | findByStoreentId(java.lang.Integer storeentId)
Retrieves the JurisdictionAccessBeans of the specified StoreEntity.
|
java.util.Enumeration | findByStoreEntitySubclassZipCodeCityStateAndCountry(java.lang.Integer storeEntityId, java.lang.Integer subclass, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country)
Retrieves the JurisdictionAccessBeans of a StoreEntity and a subclass that match the specified zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.STOREENT_ID = ?) AND (T1.SUBCLASS = ?) AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL) |
java.util.Enumeration | findByStorePath(java.lang.Integer aStoreEntityId, java.lang.String aStRelTypName)
Retrieves the JurisdictionAccessBeans that belong to stores in the storepath for the specific store.
If there are some stores related to the specified store id by the given store relationship type, it uses these related stores. |
java.util.Enumeration | findByStorePathGroupSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer aStoreId, java.lang.Integer aSubclass, java.lang.String aStRelTypName, java.lang.String aGeoCode, java.lang.String aZipCode, java.lang.String aCity, java.lang.String aState, java.lang.String aCountry)
Retrieves the JurisdictionAccessBeans that match the specified zipcode, city, state, country for the specific subclass.
|
java.util.Enumeration | findByStorePathSubclassZipCodeCityStateAndCountry(java.lang.Integer aStoreId, java.lang.Integer aSubclass, java.lang.String aStRelTypName, java.lang.String aZipCode, java.lang.String aCity, java.lang.String aState, java.lang.String aCountry)
Retrieves the JurisdictionAccessBeans that match the specified zipcode, city, state, country for the specific subclass.
|
java.util.Enumeration | findByStoreSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer storeId, java.lang.Integer subclass, java.lang.String geoCode, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country)
Retrieves the JurisdictionAccessBeans of a Store and a subclass that match the specified GEO code, zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.STOREENT_ID = ? OR T1.STOREENT_ID = (SELECT STORE.STOREGRP_ID FROM STORE WHERE STORE.STORE_ID = ?)) AND (T1.SUBCLASS = ?) AND (T1.GEOCODE = ? or T1.GEOCODE IS NULL) AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATEABBR = ? OR (T1.STATE is null AND T1.STATEABBR is null)) AND (T1.COUNTRY = ? OR T1.COUNTRYABBR = ? OR (T1.COUNTRY is null AND T1.COUNTRYABBR is null)). |
java.util.Enumeration | findByZipCodeCityStateAndCountry(java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country)
Retrieves the JurisdictionAccessBeans that match the specified zip code, city, state, and country.
The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.ZIPCODESTART <= ? OR T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL) |
java.lang.String | getCity() |
java.lang.String | getCode() |
java.lang.String | getCountry() |
java.lang.String | getCountryAbbreviation() |
java.lang.String | getCounty() |
java.lang.String | getDescription() |
java.lang.String | getDistrict() |
java.lang.String | getGeoCode() |
java.lang.String | getJurisdictionId() |
java.lang.Integer | getJurisdictionIdInEJBType() |
java.lang.String | getMarkForDelete() |
java.lang.Integer | getMarkForDeleteInEJBType() |
java.lang.String | getState() |
java.lang.String | getStateAbbreviation() |
java.lang.String | getStoreEntityId() |
java.lang.Integer | getStoreEntityIdInEJBType() |
java.lang.String | getSubclass() |
java.lang.Integer | getSubclassInEJBType() |
java.lang.String | getZipcodeEnd() |
java.lang.String | getZipcodeStart() |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() |
void | setCity(java.lang.String newValue) |
void | setCode(java.lang.String newValue) |
void | setCountry(java.lang.String newValue) |
void | setCountryAbbreviation(java.lang.String newValue) |
void | setCounty(java.lang.String newValue) |
void | setDescription(java.lang.String newValue) |
void | setDistrict(java.lang.String newValue) |
void | setGeoCode(java.lang.String newValue) |
void | setInitKey_jurisdictionId(java.lang.String newValue) |
void | setMarkForDelete(java.lang.Integer newValue) |
void | setMarkForDelete(java.lang.String newValue) |
void | setState(java.lang.String newValue) |
void | setStateAbbreviation(java.lang.String newValue) |
void | setStoreEntityId(java.lang.Integer newValue) |
void | setStoreEntityId(java.lang.String newValue) |
void | setSubclass(java.lang.Integer newValue) |
void | setSubclass(java.lang.String newValue) |
void | setZipcodeEnd(java.lang.String newValue) |
void | setZipcodeStart(java.lang.String newValue) |
public JurisdictionAccessBean()
public JurisdictionAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public JurisdictionAccessBean(java.lang.String aCode, java.lang.Integer aStoreEntityId, java.lang.Integer aSubclass) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
public java.util.Enumeration findByStoreEntitySubclassZipCodeCityStateAndCountry(java.lang.Integer storeEntityId, java.lang.Integer subclass, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of a StoreEntity and a subclass that match the specified zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.STOREENT_ID = ?) AND (T1.SUBCLASS = ?)
AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL)
public java.util.Enumeration findByStoreSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer storeId, java.lang.Integer subclass, java.lang.String geoCode, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of a Store and a subclass that match the specified GEO code, zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.STOREENT_ID = ? OR T1.STOREENT_ID = (SELECT STORE.STOREGRP_ID FROM STORE WHERE STORE.STORE_ID = ?)) AND (T1.SUBCLASS = ?)
AND (T1.GEOCODE = ? or T1.GEOCODE IS NULL)
AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATEABBR = ? OR (T1.STATE is null AND T1.STATEABBR is null)) AND (T1.COUNTRY = ? OR T1.COUNTRYABBR = ? OR (T1.COUNTRY is null AND T1.COUNTRYABBR is null)).
public java.util.Enumeration findByStoreentId(java.lang.Integer storeentId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of the specified StoreEntity.
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
T1.STOREENT_ID = ?
public java.util.Enumeration findByZipCodeCityStateAndCountry(java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans that match the specified zip code, city, state, and country.
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.ZIPCODESTART <= ? OR T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL)
public void setInitKey_jurisdictionId(java.lang.String newValue)
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getDescription() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setDescription(java.lang.String newValue)
public java.lang.String getCity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCity(java.lang.String newValue)
public java.lang.String getStateAbbreviation() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setStateAbbreviation(java.lang.String newValue)
public java.lang.String getCode() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCode(java.lang.String newValue)
public java.lang.String getJurisdictionId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getJurisdictionIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getCountry() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCountry(java.lang.String newValue)
public java.lang.String getState() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setState(java.lang.String newValue)
public java.lang.String getGeoCode() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setGeoCode(java.lang.String newValue)
public java.lang.String getCountryAbbreviation() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCountryAbbreviation(java.lang.String newValue)
public java.lang.String getMarkForDelete() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getMarkForDeleteInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setMarkForDelete(java.lang.String newValue)
public void setMarkForDelete(java.lang.Integer newValue)
public java.lang.String getZipcodeStart() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setZipcodeStart(java.lang.String newValue)
public java.lang.String getZipcodeEnd() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setZipcodeEnd(java.lang.String newValue)
public java.lang.String getSubclass() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getSubclassInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setSubclass(java.lang.String newValue)
public void setSubclass(java.lang.Integer newValue)
public java.lang.String getCounty() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCounty(java.lang.String newValue)
public java.lang.String getStoreEntityId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getStoreEntityIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setStoreEntityId(java.lang.String newValue)
public void setStoreEntityId(java.lang.Integer newValue)
public java.lang.String getDistrict() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setDistrict(java.lang.String newValue)
public java.util.Enumeration findByStorePathSubclassZipCodeCityStateAndCountry(java.lang.Integer aStoreId, java.lang.Integer aSubclass, java.lang.String aStRelTypName, java.lang.String aZipCode, java.lang.String aCity, java.lang.String aState, java.lang.String aCountry) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
Retrieves the JurisdictionAccessBeans that match the specified zipcode, city, state, country for the specific subclass. They belong to stores in the storepath for the specific store.
If there are some stores related to the specified store id by the given store relationship type, it uses these related stores. Otherwise, it uses the specified store id. To get the related stores, it uses the following SQL:
SELECT STOREREL.RELATEDSTORE_ID FROM STOREREL, STRELTYP WHERE STOREREL.STORE_ID=? AND STOREREL.STATE=1 AND
STRELTYP.NAME=? AND STRELTYP.STRELTYP_ID = STOREREL.STRELTYP_ID ORDER BY STOREREL.SEQUENCE
Assumes the above SQL as storeRelationclause, and the result where clause as storePathClause.
If storeRelationclause is null, the storePathClause is set as "T1.STOREENT_ID IN (aStoreEntityId)". Otherwise, the storePathClause is set as "T1.STOREENT_ID IN (storeRelationclause)".
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.SUBCLASS = ?) and
(T1.ZIPCODESTART <= ? or T1.ZIPCODESTART is null) and (T1.ZIPCODEEND >= ? or T1.ZIPCODEEND is null)
and (T1.CITY = ? or T1.CITY is null) and (T1.STATE = ? or T1.STATE is null) and (T1.country = ? or T1.country is null) and storePathClause
public java.util.Enumeration findByStorePath(java.lang.Integer aStoreEntityId, java.lang.String aStRelTypName) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
Retrieves the JurisdictionAccessBeans that belong to stores in the storepath for the specific store.
If there are some stores related to the specified store id by the given store relationship type, it uses these related stores. Otherwise, it uses the specified store id. To get the related stores, it uses the following SQL:
SELECT STOREREL.RELATEDSTORE_ID FROM STOREREL, STRELTYP WHERE STOREREL.STORE_ID=? AND STOREREL.STATE=1 AND
STRELTYP.NAME=? AND STRELTYP.STRELTYP_ID = STOREREL.STRELTYP_ID ORDER BY STOREREL.SEQUENCE
Assumes the above SQL as storeRelationclause, and the result where clause as storePathClause.
If storeRelationclause is null, the storePathClause is set as "T1.STOREENT_ID IN (aStoreEntityId)". Otherwise, the storePathClause is set as "T1.STOREENT_ID IN (storeRelationclause)".
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE storePathClause
public java.util.Enumeration findByStorePathGroupSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer aStoreId, java.lang.Integer aSubclass, java.lang.String aStRelTypName, java.lang.String aGeoCode, java.lang.String aZipCode, java.lang.String aCity, java.lang.String aState, java.lang.String aCountry) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
Retrieves the JurisdictionAccessBeans that match the specified zipcode, city, state, country for the specific subclass. They belong to stores in the storepath for the specific store and the storegroup.
If there are some stores related to the specified store id by the given store relationship type, it uses these related stores. Otherwise, it uses the specified store id. To get the related stores, it uses the following SQL:
SELECT STOREREL.RELATEDSTORE_ID FROM STOREREL, STRELTYP WHERE STOREREL.STORE_ID=? AND STOREREL.STATE=1 AND
STRELTYP.NAME=? AND STRELTYP.STRELTYP_ID = STOREREL.STRELTYP_ID ORDER BY STOREREL.SEQUENCE
Assumes the above SQL as storeRelationclause, and the result where clause as storePathClause.
If storeRelationclause is null, the storePathClause is set as "T1.STOREENT_ID IN (aStoreEntityId)". Otherwise, the storePathClause is set as "T1.STOREENT_ID IN (storeRelationclause)".
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.SUBCLASS = ?) and
(T1.GEOCODE = ? or T1.GEOCODE is null) and
(T1.ZIPCODESTART <= ? or T1.ZIPCODESTART is null) and (T1.ZIPCODEEND >= ? or T1.ZIPCODEEND is null)
and (T1.CITY = ? or T1.CITY is null) and (T1.STATE = ? or T1.STATEABBR = ? or (T1.STATE is null and T1.STATEABBR is null)) and (T1.COUNTRY = ? or T1.COUNTRYABBR = ? or (T1.COUNTRY is null and T1.COUNTRYABBR is null))
and (T1.STOREENT_ID = (select STORE.STOREGRP_ID from STORE where STORE.STORE_ID = ?) or storePathClause)