svnno****@sourc*****
svnno****@sourc*****
2007年 8月 24日 (金) 22:09:40 JST
Revision: 483
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=483
Author: shinsuke
Date: 2007-08-24 22:09:39 +0900 (Fri, 24 Aug 2007)
Log Message:
-----------
added portal id.
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomersBhv.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersProductsBhv.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomersDao.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersProductsDao.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomers.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrdersProducts.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersDbm.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersProductsDbm.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsAttributesCB.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsAttributesCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsAttributesCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersCIQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsAttributesCIQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsAttributesNss.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java
-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomersBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomersBhv.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomersBhv.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -28,7 +28,7 @@
* CUSTOMERS_ID
*
* [column-property]
- * CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
+ * CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
*
* [foreign-property]
* addressBook
@@ -761,6 +761,7 @@
final java.util.Set<String> names = sourceMyEntity.getModifiedPropertyNames();
if (names.contains("customersId")) { destinationMyEntity.setCustomersId(sourceMyEntity.getCustomersId()); }
+ if (names.contains("customersPortalId")) { destinationMyEntity.setCustomersPortalId(sourceMyEntity.getCustomersPortalId()); }
if (names.contains("customersGender")) { destinationMyEntity.setCustomersGender(sourceMyEntity.getCustomersGender()); }
if (names.contains("customersFirstname")) { destinationMyEntity.setCustomersFirstname(sourceMyEntity.getCustomersFirstname()); }
if (names.contains("customersLastname")) { destinationMyEntity.setCustomersLastname(sourceMyEntity.getCustomersLastname()); }
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersProductsBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersProductsBhv.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersProductsBhv.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -38,7 +38,7 @@
*
*
* [identity]
- *
+ * ordersProductsId
*
* [update-date]
*
@@ -723,6 +723,30 @@
// ===================================================================================
// Various Insert
// ==============
+
+ /* (non-javadoc)
+ * Copy-insert.
+ *
+ * @param primaryKey Primary-keys. (NotNull)
+ * @return Inserted count.
+ * @exception jp.sf.pal.pompei.allcommon.exception.RecordHasAlreadyBeenDeletedException
+ */
+ public int copyInsertByPKValueAfterSelect(java.math.BigDecimal ordersProductsId) {
+ OrdersProducts entity = new OrdersProducts();
+ entity.setOrdersProductsId(ordersProductsId);
+ final OrdersProductsCB cb = newMyConditionBean();
+ cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString(entity));
+ final OrdersProducts currentEntity = selectEntityWithDeletedCheck(cb);
+ return delegateInsert(currentEntity);
+ }
+
+ /**
+ * Filter 'copy-insert' entity.
+ *
+ * @param ordersProducts Entity. (NotNull)
+ */
+ protected void filterCopyInsertEntity(OrdersProducts ordersProducts) {
+ }
// ===================================================================================
// CBSetupper
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -29,7 +29,7 @@
* PRODUCTS_ATTRIBUTES_ID, PRODUCTS_ID, OPTIONS_ID, OPTIONS_VALUES_ID, OPTIONS_VALUES_PRICE, PRICE_PREFIX
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -460,6 +460,26 @@
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Products'.
+ *
+ * @param productsAttributesList The list of productsAttributes. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Products> pulloutProducts(java.util.List<ProductsAttributes> productsAttributesList) {
+ assertObjectNotNull("productsAttributesList", productsAttributesList);
+ final java.util.Set<Products> foreignSet = new java.util.LinkedHashSet<Products>();
+ for (java.util.Iterator ite = productsAttributesList.iterator(); ite.hasNext(); ) {
+ final ProductsAttributes productsAttributes = (ProductsAttributes)ite.next();
+ final Products foreignEntity = productsAttributes.getProducts();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Products>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -34,7 +34,7 @@
* manufacturers
*
* [refferer-property]
- * ordersProductsList, productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsAttributesList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -605,6 +605,152 @@
}
// /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [PRODUCTS_ATTRIBUTES]
+ // RefererProperty = [productsAttributesList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of productsAttributesList.
+ * <pre>
+ * You can load referer.
+ *
+ * ex) {Client Example}
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * productsBhv.loadProductsAttributesList(productsList);
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ */
+ public void loadProductsAttributesList(java.util.List<Products> productsList) {
+ final ConditionBeanSetupper<ProductsAttributesCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsAttributesCB>() {
+ public void setup(ProductsAttributesCB cb) {
+ }
+ };
+ loadProductsAttributesList(productsList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of productsAttributesList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsAttributesCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsAttributesCB>() {
+ * public void setup(ProductsAttributesCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsAttributesList(productsList, conditionBeanSetupper);
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param conditionBeanSetupper Referer condition setupper instance for registering referer condition. (NotNull)
+ */
+ public void loadProductsAttributesList(java.util.List<Products> productsList, ConditionBeanSetupper<ProductsAttributesCB> conditionBeanSetupper) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("conditionBeanSetupper<ProductsAttributesCB>", conditionBeanSetupper);
+ if (productsList.isEmpty()) {
+ return;
+ }
+ loadProductsAttributesList(productsList, new LoadRefererOption<ProductsAttributesCB, ProductsAttributes>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of productsAttributesList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsAttributesCB> cbSetupper = new ConditionBeanSetupper<ProductsAttributesCB>() {
+ * public void setup(ProductsAttributesCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsAttributesList(productsList, new LoadRefererOption<ProductsAttributesCB, ProductsAttributes>(cbSetupper));
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param loadRefererOption Load-referer option. (NotNull)
+ */
+ public void loadProductsAttributesList(java.util.List<Products> productsList, LoadRefererOption<ProductsAttributesCB, ProductsAttributes> loadRefererOption) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("loadRefererOption<ProductsAttributes, ProductsAttributesCB>", loadRefererOption);
+ if (productsList.isEmpty()) {
+ return;
+ }
+
+ final java.util.Map<java.math.BigDecimal, Products> pkMyEntityMap = new java.util.LinkedHashMap<java.math.BigDecimal, Products>();
+ final java.util.List<java.math.BigDecimal> pkList = new java.util.ArrayList<java.math.BigDecimal>();
+ for (Products products : productsList) {
+ pkList.add(products.getProductsId());
+ pkMyEntityMap.put((java.math.BigDecimal)toLowerCaseIfString(products.getProductsId()), products);
+ }
+ final ProductsAttributesBhv refererBhv = getDaoSelector().getBehavior(ProductsAttributesBhv.class);
+ final ProductsAttributesCB cb = loadRefererOption.getReffererConditionBean() != null ? loadRefererOption.getReffererConditionBean() : refererBhv.newMyConditionBean();
+ cb.query().setProductsId_InScope(pkList);
+ loadRefererOption.delegateKeyConditionExchangingFirstWhereClauseForLastOne(cb);
+ if (!loadRefererOption.isStopOrderByKey()) {
+ cb.query().addOrderBy_ProductsId_Asc();
+ cb.getSqlComponentOfOrderByClause().exchangeFirstOrderByElementForLastOne();
+ }
+ loadRefererOption.delegateConditionBeanSettingUp(cb);
+ final java.util.List<ProductsAttributes> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<ProductsAttributes>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<ProductsAttributes>>();
+ for (ProductsAttributes reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getProductsId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getProductsId()), new java.util.ArrayList<ProductsAttributes>());
+ }
+ (pkReffererListMap.get(toLowerCaseIfString(reffererEntity.getProductsId()))).add(reffererEntity);
+
+ // for Reverse Reference.
+ final Products myEntity = pkMyEntityMap.get(toLowerCaseIfString(reffererEntity.getProductsId()));
+ reffererEntity.setProducts(myEntity);
+ }
+
+ for (Products products : productsList) {
+ if (pkReffererListMap.containsKey(toLowerCaseIfString(products.getProductsId()))) {
+ products.setProductsAttributesList((java.util.List<ProductsAttributes>)pkReffererListMap.get(toLowerCaseIfString(products.getProductsId())));
+ } else {
+ products.setProductsAttributesList(new java.util.ArrayList<ProductsAttributes>());
+ }
+ }
+ }
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
// RefererTable = [PRODUCTS_DESCRIPTION]
// RefererProperty = [productsDescriptionList]
// * * * * * * * * */
@@ -919,7 +1065,7 @@
}
return new java.util.ArrayList<Manufacturers>(foreignSet);
}
-
+
// ===================================================================================
// Basic Entity Update
// ===================
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomersDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomersDao.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomersDao.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -11,7 +11,7 @@
* CUSTOMERS_ID
*
* [column-property]
- * CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
+ * CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
*
* [foreign-property]
* addressBook
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersProductsDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersProductsDao.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersProductsDao.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -23,7 +23,7 @@
*
*
* [identity]
- *
+ * ordersProductsId
*
* [update-date]
*
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -14,7 +14,7 @@
* PRODUCTS_ATTRIBUTES_ID, PRODUCTS_ID, OPTIONS_ID, OPTIONS_VALUES_ID, OPTIONS_VALUES_PRICE, PRICE_PREFIX
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -17,7 +17,7 @@
* manufacturers
*
* [refferer-property]
- * ordersProductsList, productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsAttributesList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomers.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomers.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomers.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -13,7 +13,7 @@
* CUSTOMERS_ID
*
* [column-property]
- * CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
+ * CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
*
* [foreign-property]
* addressBook
@@ -59,6 +59,9 @@
/** The value of customersId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _customersId;
+ /** The value of customersPortalId. ColumnDefinition -- VARCHAR(255) : NotNull*/
+ protected String _customersPortalId;
+
/** The value of customersGender. ColumnDefinition -- CHAR(1) : NotNull*/
protected String _customersGender;
@@ -169,6 +172,30 @@
_customersId = customersId;
}
+ /** Column-Annotation for S2Dao. ColumnDefinition -- VARCHAR(255) : NotNull*/
+ public static final String customersPortalId_COLUMN = "CUSTOMERS_PORTAL_ID";
+
+ /**
+ * Get the value of customersPortalId. <br />
+ * {VARCHAR(255) : NotNull}
+ *
+ * @return The value of customersPortalId. (Nullable)
+ */
+ public String getCustomersPortalId() {
+ return _customersPortalId;
+ }
+
+ /**
+ * Set the value of customersPortalId. <br />
+ * {VARCHAR(255) : NotNull}
+ *
+ * @param customersPortalId The value of customersPortalId. (Nullable)
+ */
+ public void setCustomersPortalId(String customersPortalId) {
+ _modifiedProperties.addPropertyName("customersPortalId");
+ _customersPortalId = customersPortalId;
+ }
+
/** Column-Annotation for S2Dao. ColumnDefinition -- CHAR(1) : NotNull*/
public static final String customersGender_COLUMN = "CUSTOMERS_GENDER";
@@ -413,16 +440,16 @@
// ===================================================================================
// Classify Method
// ===============
-
+
// ===================================================================================
// Classification Determination
// ============================
-
+
// ===================================================================================
// Classification Getter
// =====================
-
+
// ===================================================================================
// Foreign Table
@@ -695,6 +722,7 @@
final StringBuffer sb = new StringBuffer();
sb.append(delimiter).append(getCustomersId());
+ sb.append(delimiter).append(getCustomersPortalId());
sb.append(delimiter).append(getCustomersGender());
sb.append(delimiter).append(getCustomersFirstname());
sb.append(delimiter).append(getCustomersLastname());
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrdersProducts.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrdersProducts.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrdersProducts.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -25,7 +25,7 @@
*
*
* [identity]
- *
+ * ordersProductsId
*
* [update-date]
*
@@ -45,6 +45,9 @@
/** TABLE-Annotation for S2Dao */
public static final String TABLE = "ORDERS_PRODUCTS";
+
+ /** ID-Annotation */
+ public static final String ordersProductsId_ID = "identity";
// ===================================================================================
// Attribute
@@ -53,7 +56,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of ordersProductsId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of ordersProductsId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _ordersProductsId;
/** The value of ordersId. ColumnDefinition -- INTEGER : NotNull : FK to ORDERS*/
@@ -136,12 +139,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
public static final String ordersProductsId_COLUMN = "ORDERS_PRODUCTS_ID";
/**
* Get the value of ordersProductsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @return The value of ordersProductsId. (Nullable)
*/
@@ -151,7 +154,7 @@
/**
* Set the value of ordersProductsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @param ordersProductsId The value of ordersProductsId. (Nullable)
*/
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -19,7 +19,7 @@
* manufacturers
*
* [refferer-property]
- * ordersProductsList, productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsAttributesList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -558,6 +558,34 @@
// /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [PRODUCTS_ATTRIBUTES]
+ // ReffererProperty = [productsAttributesList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.ProductsAttributes> _childrenProductsAttributesList;
+
+ /**
+ * Get the list of refferer table without lazyload.
+ * If it's not loaded yet, returns null.
+ *
+ * @return The list of refferer table. (Nullable)
+ */
+ public java.util.List<jp.sf.pal.pompei.exentity.ProductsAttributes> getProductsAttributesList() {
+ return _childrenProductsAttributesList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setProductsAttributesList(java.util.List<jp.sf.pal.pompei.exentity.ProductsAttributes> entity) {
+ this._childrenProductsAttributesList = entity;
+ }
+
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
// ReffererTable = [PRODUCTS_DESCRIPTION]
// ReffererProperty = [productsDescriptionList]
// * * * * * * * * */
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -16,7 +16,7 @@
* PRODUCTS_ATTRIBUTES_ID, PRODUCTS_ID, OPTIONS_ID, OPTIONS_VALUES_ID, OPTIONS_VALUES_PRICE, PRICE_PREFIX
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -59,7 +59,7 @@
/** The value of productsAttributesId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _productsAttributesId;
- /** The value of productsId. ColumnDefinition -- INTEGER : NotNull*/
+ /** The value of productsId. ColumnDefinition -- INTEGER : NotNull : FK to PRODUCTS*/
protected java.math.BigDecimal _productsId;
/** The value of optionsId. ColumnDefinition -- INTEGER : NotNull*/
@@ -154,12 +154,12 @@
_productsAttributesId = productsAttributesId;
}
- /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull : FK to PRODUCTS*/
public static final String productsId_COLUMN = "PRODUCTS_ID";
/**
* Get the value of productsId. <br />
- * {INTEGER : NotNull}
+ * {INTEGER : NotNull : FK to PRODUCTS}
*
* @return The value of productsId. (Nullable)
*/
@@ -169,7 +169,7 @@
/**
* Set the value of productsId. <br />
- * {INTEGER : NotNull}
+ * {INTEGER : NotNull : FK to PRODUCTS}
*
* @param productsId The value of productsId. (Nullable)
*/
@@ -293,6 +293,48 @@
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int products_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String products_RELKEYS = "PRODUCTS_ID:PRODUCTS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.Products _parentProducts;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.Products getProducts() {
+ return _parentProducts;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setProducts(jp.sf.pal.pompei.exentity.Products entity) {
+ this._parentProducts = entity;
+ }
+
+ /**
+ * Has relation object of products.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationProducts() {
+ return _parentProducts != null && _parentProducts.hasPrimaryKeyValue();
+ }
+
+
// ===================================================================================
// Refferer Table
// ==============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersDbm.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersDbm.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -14,7 +14,7 @@
* CUSTOMERS_ID
*
* [column-property]
- * CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
+ * CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER
*
* [foreign-property]
* addressBook
@@ -84,6 +84,8 @@
/** Db-name of CustomersId. */
public static final String COLUMN_DB_NAME_OF_CustomersId = "CUSTOMERS_ID";
+ /** Db-name of CustomersPortalId. */
+ public static final String COLUMN_DB_NAME_OF_CustomersPortalId = "CUSTOMERS_PORTAL_ID";
/** Db-name of CustomersGender. */
public static final String COLUMN_DB_NAME_OF_CustomersGender = "CUSTOMERS_GENDER";
/** Db-name of CustomersFirstname. */
@@ -107,6 +109,8 @@
/** Cap-prop-name of CustomersId. */
public static final String COLUMN_CAP_PROP_NAME_OF_CustomersId = "CustomersId";
+ /** Cap-prop-name of CustomersPortalId. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_CustomersPortalId = "CustomersPortalId";
/** Cap-prop-name of CustomersGender. */
public static final String COLUMN_CAP_PROP_NAME_OF_CustomersGender = "CustomersGender";
/** Cap-prop-name of CustomersFirstname. */
@@ -136,6 +140,8 @@
/** Uncap-prop-name of CustomersId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_CustomersId = "customersId";
+ /** Uncap-prop-name of CustomersPortalId. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_CustomersPortalId = "customersPortalId";
/** Uncap-prop-name of CustomersGender. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_CustomersGender = "customersGender";
/** Uncap-prop-name of CustomersFirstname. */
@@ -173,6 +179,7 @@
map.put(TABLE_DB_NAME, TABLE_CAP_PROP_NAME);
map.put(COLUMN_DB_NAME_OF_CustomersId, COLUMN_CAP_PROP_NAME_OF_CustomersId);
+ map.put(COLUMN_DB_NAME_OF_CustomersPortalId, COLUMN_CAP_PROP_NAME_OF_CustomersPortalId);
map.put(COLUMN_DB_NAME_OF_CustomersGender, COLUMN_CAP_PROP_NAME_OF_CustomersGender);
map.put(COLUMN_DB_NAME_OF_CustomersFirstname, COLUMN_CAP_PROP_NAME_OF_CustomersFirstname);
map.put(COLUMN_DB_NAME_OF_CustomersLastname, COLUMN_CAP_PROP_NAME_OF_CustomersLastname);
@@ -198,6 +205,7 @@
map.put(TABLE_DB_NAME, TABLE_UNCAP_PROP_NAME);
map.put(COLUMN_DB_NAME_OF_CustomersId, COLUMN_UNCAP_PROP_NAME_OF_CustomersId);
+ map.put(COLUMN_DB_NAME_OF_CustomersPortalId, COLUMN_UNCAP_PROP_NAME_OF_CustomersPortalId);
map.put(COLUMN_DB_NAME_OF_CustomersGender, COLUMN_UNCAP_PROP_NAME_OF_CustomersGender);
map.put(COLUMN_DB_NAME_OF_CustomersFirstname, COLUMN_UNCAP_PROP_NAME_OF_CustomersFirstname);
map.put(COLUMN_DB_NAME_OF_CustomersLastname, COLUMN_UNCAP_PROP_NAME_OF_CustomersLastname);
@@ -223,6 +231,7 @@
map.put(TABLE_CAP_PROP_NAME, TABLE_DB_NAME);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersId, COLUMN_DB_NAME_OF_CustomersId);
+ map.put(COLUMN_CAP_PROP_NAME_OF_CustomersPortalId, COLUMN_DB_NAME_OF_CustomersPortalId);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersGender, COLUMN_DB_NAME_OF_CustomersGender);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersFirstname, COLUMN_DB_NAME_OF_CustomersFirstname);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersLastname, COLUMN_DB_NAME_OF_CustomersLastname);
@@ -248,6 +257,7 @@
map.put(TABLE_CAP_PROP_NAME, TABLE_UNCAP_PROP_NAME);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersId, COLUMN_UNCAP_PROP_NAME_OF_CustomersId);
+ map.put(COLUMN_CAP_PROP_NAME_OF_CustomersPortalId, COLUMN_UNCAP_PROP_NAME_OF_CustomersPortalId);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersGender, COLUMN_UNCAP_PROP_NAME_OF_CustomersGender);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersFirstname, COLUMN_UNCAP_PROP_NAME_OF_CustomersFirstname);
map.put(COLUMN_CAP_PROP_NAME_OF_CustomersLastname, COLUMN_UNCAP_PROP_NAME_OF_CustomersLastname);
@@ -273,6 +283,7 @@
map.put(TABLE_UNCAP_PROP_NAME, TABLE_DB_NAME);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersId, COLUMN_DB_NAME_OF_CustomersId);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersPortalId, COLUMN_DB_NAME_OF_CustomersPortalId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersGender, COLUMN_DB_NAME_OF_CustomersGender);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersFirstname, COLUMN_DB_NAME_OF_CustomersFirstname);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersLastname, COLUMN_DB_NAME_OF_CustomersLastname);
@@ -298,6 +309,7 @@
map.put(TABLE_UNCAP_PROP_NAME, TABLE_CAP_PROP_NAME);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersId, COLUMN_CAP_PROP_NAME_OF_CustomersId);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersPortalId, COLUMN_CAP_PROP_NAME_OF_CustomersPortalId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersGender, COLUMN_CAP_PROP_NAME_OF_CustomersGender);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersFirstname, COLUMN_CAP_PROP_NAME_OF_CustomersFirstname);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CustomersLastname, COLUMN_CAP_PROP_NAME_OF_CustomersLastname);
@@ -436,7 +448,7 @@
* @return Column-db-name comma-string. (NotNull)
*/
public String getColumnDbNameCommaString() {
- return "CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER";
+ return "CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER";
}
// ===================================================================================
@@ -616,6 +628,7 @@
final MapStringValueAnalyzer analyzer = new MapStringValueAnalyzer(columnValueMap, entity.getModifiedPropertyNames());
if (analyzer.init("CUSTOMERS_ID", "customersId", "customersId")) { myEntity.setCustomersId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
+ if (analyzer.init("CUSTOMERS_PORTAL_ID", "customersPortalId", "customersPortalId")) { myEntity.setCustomersPortalId(analyzer.analyzeString(String.class)); };
if (analyzer.init("CUSTOMERS_GENDER", "customersGender", "customersGender")) { myEntity.setCustomersGender(analyzer.analyzeString(String.class)); };
if (analyzer.init("CUSTOMERS_FIRSTNAME", "customersFirstname", "customersFirstname")) { myEntity.setCustomersFirstname(analyzer.analyzeString(String.class)); };
if (analyzer.init("CUSTOMERS_LASTNAME", "customersLastname", "customersLastname")) { myEntity.setCustomersLastname(analyzer.analyzeString(String.class)); };
@@ -700,6 +713,7 @@
final String mapMarkAndStartBrace = MAP_STRING_MAP_MARK + startBrace;
final StringBuffer sb = new StringBuffer();
helpAppendingColumnValueString(sb, delimiter, equal, "CUSTOMERS_ID", myEntity.getCustomersId());
+ helpAppendingColumnValueString(sb, delimiter, equal, "CUSTOMERS_PORTAL_ID", myEntity.getCustomersPortalId());
helpAppendingColumnValueString(sb, delimiter, equal, "CUSTOMERS_GENDER", myEntity.getCustomersGender());
helpAppendingColumnValueString(sb, delimiter, equal, "CUSTOMERS_FIRSTNAME", myEntity.getCustomersFirstname());
helpAppendingColumnValueString(sb, delimiter, equal, "CUSTOMERS_LASTNAME", myEntity.getCustomersLastname());
@@ -753,6 +767,7 @@
final Customers myEntity = downcast(entity);
final java.util.Map<String, Object> valueMap = new java.util.LinkedHashMap<String, Object>();
valueMap.put("CUSTOMERS_ID", myEntity.getCustomersId());
+ valueMap.put("CUSTOMERS_PORTAL_ID", myEntity.getCustomersPortalId());
valueMap.put("CUSTOMERS_GENDER", myEntity.getCustomersGender());
valueMap.put("CUSTOMERS_FIRSTNAME", myEntity.getCustomersFirstname());
valueMap.put("CUSTOMERS_LASTNAME", myEntity.getCustomersLastname());
@@ -774,6 +789,7 @@
final Customers myEntity = downcast(entity);
final java.util.Map<String, String> valueMap = new java.util.LinkedHashMap<String, String>();
valueMap.put("CUSTOMERS_ID", helpGettingColumnStringValue(myEntity.getCustomersId()));
+ valueMap.put("CUSTOMERS_PORTAL_ID", helpGettingColumnStringValue(myEntity.getCustomersPortalId()));
valueMap.put("CUSTOMERS_GENDER", helpGettingColumnStringValue(myEntity.getCustomersGender()));
valueMap.put("CUSTOMERS_FIRSTNAME", helpGettingColumnStringValue(myEntity.getCustomersFirstname()));
valueMap.put("CUSTOMERS_LASTNAME", helpGettingColumnStringValue(myEntity.getCustomersLastname()));
@@ -791,11 +807,11 @@
// JDBC Support
// ============
public String getPreparedInsertClause() {
- return "insert into CUSTOMERS(CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
+ return "insert into CUSTOMERS(CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
}
public String getPreparedInsertClause(String tablePrefix) {
- return "insert into " + tablePrefix + "CUSTOMERS(CUSTOMERS_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
+ return "insert into " + tablePrefix + "CUSTOMERS(CUSTOMERS_ID, CUSTOMERS_PORTAL_ID, CUSTOMERS_GENDER, CUSTOMERS_FIRSTNAME, CUSTOMERS_LASTNAME, CUSTOMERS_DOB, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_DEFAULT_ADDRESS_ID, CUSTOMERS_TELEPHONE, CUSTOMERS_FAX, CUSTOMERS_PASSWORD, CUSTOMERS_NEWSLETTER) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
}
// ===================================================================================
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersProductsDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersProductsDbm.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersProductsDbm.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -26,7 +26,7 @@
*
*
* [identity]
- *
+ * ordersProductsId
*
* [update-date]
*
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -17,7 +17,7 @@
* PRODUCTS_ATTRIBUTES_ID, PRODUCTS_ID, OPTIONS_ID, OPTIONS_VALUES_ID, OPTIONS_VALUES_PRICE, PRICE_PREFIX
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -108,6 +108,8 @@
/** Cap-prop-name of PricePrefix. */
public static final String COLUMN_CAP_PROP_NAME_OF_PricePrefix = "PricePrefix";
+ /** Cap-prop-name of products. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Products = "Products";
/** Uncap-prop-name of ProductsAttributesId. */
@@ -123,6 +125,8 @@
/** Uncap-prop-name of PricePrefix. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_PricePrefix = "pricePrefix";
+ /** Uncap-prop-name of products. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Products = "products";
/** {db-name : cap-prop-name} map. */
@@ -473,6 +477,15 @@
}
}
+ /**
+ * Get foreign dbmeta of Products.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public ProductsDbm getForeignDBMeta_Products() {
+ return ProductsDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -20,7 +20,7 @@
* manufacturers
*
* [refferer-property]
- * ordersProductsList, productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsAttributesList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -141,6 +141,8 @@
/** Cap-prop-name of OrdersProductsList. */
public static final String COLUMN_CAP_PROP_NAME_OF_OrdersProductsList = "OrdersProductsList";
+ /** Cap-prop-name of ProductsAttributesList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ProductsAttributesList = "ProductsAttributesList";
/** Cap-prop-name of ProductsDescriptionList. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsDescriptionList = "ProductsDescriptionList";
/** Cap-prop-name of ProductsToCategoriesList. */
@@ -178,6 +180,8 @@
/** Uncap-prop-name of ordersProductsList. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersProductsList = "ordersProductsList";
+ /** Uncap-prop-name of productsAttributesList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsAttributesList = "productsAttributesList";
/** Uncap-prop-name of productsDescriptionList. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsDescriptionList = "productsDescriptionList";
/** Uncap-prop-name of productsToCategoriesList. */
@@ -581,7 +585,7 @@
public ManufacturersDbm getForeignDBMeta_Manufacturers() {
return ManufacturersDbm.getInstance();
}
-
+
// ===================================================================================
// Determination
// =============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsAttributesCB.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsAttributesCB.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsAttributesCB.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -189,6 +189,50 @@
// ===================================================================================
// Setup-Select
// ============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** Is select for products? */
+ protected boolean _isSelectProducts;
+ /** Nest select setupper for products. */
+ protected ProductsNss _nssProducts;
+ /**
+ * Is select for products? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+ /**
+ * Get nest select setupper for products. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public ProductsNss getNssProducts() {
+ if (_nssProducts == null) {
+ _nssProducts = new ProductsNss(null);// for Dummy
+ }
+ return _nssProducts;
+ }
+ /**
+ * Set up select for products.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for products. (NotNull)
+ */
+ public ProductsNss setupSelect_Products() {
+ query().queryProducts();// For setting outer join.
+ if (_nssProducts == null || !_nssProducts.hasConditionQuery()) {
+ _nssProducts = new ProductsNss(query().queryProducts());
+ }
+ _isSelectProducts = true;
+ limitSelect_Off();
+ return _nssProducts;
+ }
// ===================================================================================
// Basic Override
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -233,7 +233,7 @@
limitSelect_Off();
return _nssManufacturers;
}
-
+
// ===================================================================================
// Basic Override
// ==============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -191,6 +191,149 @@
abstract protected ConditionValue getCValueCustomersId();
+ /** Column db name of customersPortalId. */
+ protected static final String COL_CUSTOMERS_PORTAL_ID = "CUSTOMERS_PORTAL_ID";
+
+ /** Column java name of customersPortalId. */
+ protected static final String J_CustomersPortalId = "CustomersPortalId";
+
+ /** Column uncapitalised java name of customersPortalId. */
+ protected static final String UJ_customersPortalId = "customersPortalId";
+
+ /**
+ * Set the value of customersPortalId using equal. { = }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as equal.
+ */
+ public void setCustomersPortalId_Equal(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_EQUAL, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using notEqual. { != }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as notEqual.
+ */
+ public void setCustomersPortalId_NotEqual(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_NOT_EQUAL, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using greaterThan. { > }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as greaterThan.
+ */
+ public void setCustomersPortalId_GreaterThan(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_GREATER_THAN, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using lessThan. { < }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as lessThan.
+ */
+ public void setCustomersPortalId_LessThan(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_LESS_THAN, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using greaterEqual. { >= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as greaterEqual.
+ */
+ public void setCustomersPortalId_GreaterEqual(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_GREATER_EQUAL, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using lessEqual. { <= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as lessEqual.
+ */
+ public void setCustomersPortalId_LessEqual(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_LESS_EQUAL, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using prefixSearch. { like 'xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as prefixSearch.
+ */
+ public void setCustomersPortalId_PrefixSearch(String customersPortalId) {
+ registerCustomersPortalId(ConditionKey.CK_PREFIX_SEARCH, filterRemoveEmptyString(customersPortalId));
+ }
+
+ /**
+ * Set the value of customersPortalId using likeSearch. { like '%xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ * You can invoke this method several times and the conditions are set up.
+ *
+ * @param customersPortalId The value of customersPortalId as likeSearch.
+ * @param likeSearchOption Like search option. (NotNull)
+ */
+ public void setCustomersPortalId_LikeSearch(String customersPortalId, jp.sf.pal.pompei.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
+ registerLikeSearchQuery(ConditionKey.CK_LIKE_SEARCH, filterRemoveEmptyString(customersPortalId), getCValueCustomersPortalId(), COL_CUSTOMERS_PORTAL_ID, J_CustomersPortalId, UJ_customersPortalId, likeSearchOption);
+ }
+
+ /**
+ * Set the value of customersPortalId using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param customersPortalIdList The value of customersPortalId as inScope.
+ */
+ public void setCustomersPortalId_InScope(java.util.List<String> customersPortalIdList) {
+ registerCustomersPortalId(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyStringFromList(customersPortalIdList));
+ }
+
+ /**
+ * Set the value of customersPortalId using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param customersPortalId The value of customersPortalId as inScope.
+ */
+ public void setCustomersPortalId_InScope(String customersPortalId, jp.sf.pal.pompei.allcommon.cbean.coption.InScopeOption option) {
+ registerInScopeQuery(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyString(customersPortalId), getCValueCustomersPortalId(), COL_CUSTOMERS_PORTAL_ID, J_CustomersPortalId, UJ_customersPortalId, option);
+ }
+
+ /**
+ * Set the value of customersPortalId using notInScope. { not in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param customersPortalIdList The value of customersPortalId as notInScope.
+ */
+ public void setCustomersPortalId_NotInScope(java.util.List<String> customersPortalIdList) {
+ registerCustomersPortalId(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(customersPortalIdList));
+ }
+
+ /**
+ * Register condition of customersPortalId.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of customersPortalId. (Nullable)
+ */
+ protected void registerCustomersPortalId(ConditionKey key, Object value) {
+ registerQuery(key, value, getCValueCustomersPortalId(), COL_CUSTOMERS_PORTAL_ID, J_CustomersPortalId, UJ_customersPortalId);
+ }
+
+ /**
+ * Register inline condition of customersPortalId.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of customersPortalId. (Nullable)
+ */
+ protected void registerInlineCustomersPortalId(ConditionKey key, Object value) {
+ registerInlineQuery(key, value, getCValueCustomersPortalId(), COL_CUSTOMERS_PORTAL_ID, J_CustomersPortalId, UJ_customersPortalId);
+ }
+
+ abstract protected ConditionValue getCValueCustomersPortalId();
+
/** Column db name of customersGender. */
protected static final String COL_CUSTOMERS_GENDER = "CUSTOMERS_GENDER";
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsAttributesCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsAttributesCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsAttributesCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -239,8 +239,25 @@
public void setProductsId_NotInScope(java.util.List<java.math.BigDecimal> productsIdList) {
registerProductsId(ConditionKey.CK_NOT_IN_SCOPE, productsIdList);
}
-
+
/**
+ * Set the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_Products(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_Products");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery);
+
+ /**
* Register condition of productsId.
*
* @param key Condition key. (NotNull)
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -153,6 +153,23 @@
abstract public void keepProductsId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery);
/**
+ * Set the sub-query of ProductsId_InScopeSubQuery_ProductsAttributesList using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS_ATTRIBUTES where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_ProductsAttributesList using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_ProductsAttributesList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_ProductsAttributesList");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery);
+
+ /**
* Set the sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery.
* { in (select xxx.PRODUCTS_ID from PRODUCTS_DESCRIPTION where ...) }
* This method use from clause and where clause of the sub-query instance.
@@ -204,6 +221,23 @@
abstract public void keepProductsId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery);
/**
+ * Set the sub-query of ProductsId_ExistsSubQuery_ProductsAttributesList using existsSubQuery.
+ * { exists (select xxx.PRODUCTS_ID from PRODUCTS_ATTRIBUTES where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_ExistsSubQuery_ProductsAttributesList using existsSubQuery. (NotNull)
+ */
+ public void setProductsId_ExistsSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_ExistsSubQuery_ProductsAttributesList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_ExistsSubQuery_ProductsAttributesList");
+ }
+
+ abstract public void keepProductsId_ExistsSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery);
+
+ /**
* Set the sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery.
* { exists (select xxx.PRODUCTS_ID from PRODUCTS_DESCRIPTION where ...) }
* This method use from clause and where clause of the sub-query instance.
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -75,6 +75,24 @@
}
/**
+ * Include select-column of customersPortalId as mine.
+ * Alias name is java-name of this column.
+ * Be careful to whether your table have the same column.
+ */
+ public void includeAsMine_CustomersPortalId() {
+ registerIncludedSelectColumn("CustomersPortalId", getRealColumnName("CUSTOMERS_PORTAL_ID"));
+ }
+
+ /**
+ * Include select-column of customersPortalId as mine.
+ *
+ * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+ */
+ public void includeAsMine_CustomersPortalId(String aliasName) {
+ registerIncludedSelectColumn(aliasName, getRealColumnName("CUSTOMERS_PORTAL_ID"));
+ }
+
+ /**
* Include select-column of customersGender as mine.
* Alias name is java-name of this column.
* Be careful to whether your table have the same column.
@@ -336,6 +354,48 @@
}
// /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [CUSTOMERS_PORTAL_ID]
+ // - - - - - - - - -/
+
+ /** The attribute of customersPortalId. */
+ protected ConditionValue _customersPortalId;
+
+ /**
+ * Get the value of customersPortalId.
+ *
+ * @return The value of customersPortalId.
+ */
+ public ConditionValue getCustomersPortalId() {
+ if (_customersPortalId == null) {
+ _customersPortalId = new ConditionValue();
+ }
+ return _customersPortalId;
+ }
+
+ protected ConditionValue getCValueCustomersPortalId() {
+ return getCustomersPortalId();
+ }
+
+
+ /**
+ * Add order-by of customersPortalId as ASC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsCustomersCQ addOrderBy_CustomersPortalId_Asc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_CUSTOMERS_PORTAL_ID), null, true);return this;
+ }
+
+ /**
+ * Add order-by of customersPortalId as DESC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsCustomersCQ addOrderBy_CustomersPortalId_Desc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_CUSTOMERS_PORTAL_ID), null, false);return this;
+ }
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [CUSTOMERS_GENDER]
// - - - - - - - - -/
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsAttributesCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsAttributesCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsAttributesCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -236,8 +236,24 @@
return getProductsId();
}
-
+
+ /** The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. */
+ protected ProductsCQ _productsId_InScopeSubQuery_Products;
+
/**
+ * Get the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (Nullable)
+ */
+ public ProductsCQ getProductsId_InScopeSubQuery_Products() {
+ return _productsId_InScopeSubQuery_Products;
+ }
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _productsId_InScopeSubQuery_Products = subQuery;
+ }
+
+ /**
* Add order-by of productsId as ASC.
*
* @return this. (NotNull)
@@ -429,12 +445,81 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ProductsAttributesCQ baseQuery = (ProductsAttributesCQ)baseQueryAsSuper;
final ProductsAttributesCQ unionQuery = (ProductsAttributesCQ)unionQueryAsSuper;
+
+ if (baseQuery.hasConditionQueryProducts()) {
+ unionQuery.queryProducts().reflectRelationOnUnionQuery(baseQuery.queryProducts(), unionQuery.queryProducts());
+ }
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /**
+ * Query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ queryProducts() {
+ return getConditionQueryProducts();
+ }
+
+ /** Condition-query for products. */
+ protected ProductsCQ _conditionQueryProducts;
+
+ /**
+ * Get condition-query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ getConditionQueryProducts() {
+ if (_conditionQueryProducts == null) {
+ _conditionQueryProducts = newQueryProducts();
+ setupOuterJoin_Products();
+ }
+ return _conditionQueryProducts;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_Products() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("PRODUCTS_ID");
+ value = getConditionQueryProducts().getRealColumnName("PRODUCTS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "PRODUCTS";
+ final String aliasName = getConditionQueryProducts().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for products.
+ *
+ * @return Query for products. (NotNull)
+ */
+ protected ProductsCQ newQueryProducts() {
+ return new ProductsCQ(this, getSqlClause(), "Products", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryProducts() {
+ return _conditionQueryProducts != null;
+ }
}
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -337,6 +337,22 @@
_productsId_InScopeSubQuery_OrdersProductsList = subQuery;
}
+ /** The sub-query of ProductsId_InScopeSubQuery_ProductsAttributesList using inScopeSubQuery. */
+ protected ProductsAttributesCQ _productsId_InScopeSubQuery_ProductsAttributesList;
+
+ /**
+ * Get the sub-query of ProductsId_InScopeSubQuery_ProductsAttributesList using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_ProductsAttributesList using inScopeSubQuery. (Nullable)
+ */
+ public ProductsAttributesCQ getProductsId_InScopeSubQuery_ProductsAttributesList() {
+ return _productsId_InScopeSubQuery_ProductsAttributesList;
+ }
+
+ public void keepProductsId_InScopeSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ _productsId_InScopeSubQuery_ProductsAttributesList = subQuery;
+ }
+
/** The sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery. */
protected ProductsDescriptionCQ _productsId_InScopeSubQuery_ProductsDescriptionList;
@@ -385,6 +401,22 @@
_productsId_ExistsSubQuery_OrdersProductsList = subQuery;
}
+ /** The sub-query of ProductsId_ExistsSubQuery_ProductsAttributesList using existsSubQuery. */
+ protected ProductsAttributesCQ _productsId_ExistsSubQuery_ProductsAttributesList;
+
+ /**
+ * Get the sub-query of ProductsId_ExistsSubQuery_ProductsAttributesList using existsSubQuery.
+ *
+ * @return The sub-query of ProductsId_ExistsSubQuery_ProductsAttributesList using existsSubQuery. (Nullable)
+ */
+ public ProductsAttributesCQ getProductsId_ExistsSubQuery_ProductsAttributesList() {
+ return _productsId_ExistsSubQuery_ProductsAttributesList;
+ }
+
+ public void keepProductsId_ExistsSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ _productsId_ExistsSubQuery_ProductsAttributesList = subQuery;
+ }
+
/** The sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery. */
protected ProductsDescriptionCQ _productsId_ExistsSubQuery_ProductsDescriptionList;
@@ -965,7 +997,7 @@
if (baseQuery.hasConditionQueryManufacturers()) {
unionQuery.queryManufacturers().reflectRelationOnUnionQuery(baseQuery.queryManufacturers(), unionQuery.queryManufacturers());
}
-
+
}
// ===================================================================================
@@ -1037,5 +1069,5 @@
return _conditionQueryManufacturers != null;
}
-
+
}
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersCIQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersCIQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -85,6 +85,14 @@
}
// /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [CUSTOMERS_PORTAL_ID]
+ // - - - - - - - - -/
+ protected ConditionValue getCValueCustomersPortalId() {
+ return _myCQ.getCustomersPortalId();
+ }
+
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [CUSTOMERS_GENDER]
// - - - - - - - - -/
protected ConditionValue getCValueCustomersGender() {
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsAttributesCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsAttributesCIQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsAttributesCIQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -82,7 +82,11 @@
return _myCQ.getProductsId();
}
-
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_Products(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [OPTIONS_ID]
// - - - - - - - - -/
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -79,6 +79,10 @@
_myCQ.keepProductsId_InScopeSubQuery_OrdersProductsList(subQuery);
}
+ public void keepProductsId_InScopeSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_ProductsAttributesList(subQuery);
+ }
+
public void keepProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
_myCQ.keepProductsId_InScopeSubQuery_ProductsDescriptionList(subQuery);
}
@@ -92,6 +96,11 @@
// _myCQ.keepProductsId_ExistsSubQuery_OrdersProductsList(subQuery);
}
+ public void keepProductsId_ExistsSubQuery_ProductsAttributesList(ProductsAttributesCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepProductsId_ExistsSubQuery_ProductsAttributesList(subQuery);
+ }
+
public void keepProductsId_ExistsSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
// _myCQ.keepProductsId_ExistsSubQuery_ProductsDescriptionList(subQuery);
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsAttributesNss.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsAttributesNss.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsAttributesNss.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -52,6 +52,27 @@
// With...
// =======
+ /** Is select products? */
+ protected boolean _isSelectProducts;
+
+ /**
+ * Is select products?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+
+ /**
+ * Set up select with products.
+ */
+ public void withProducts() {
+ assertConditionQuery();
+ _query.queryProducts();
+ _isSelectProducts = true;
+ }
+
// ===================================================================================
// Helper
// ======
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java 2007-08-24 13:07:31 UTC (rev 482)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java 2007-08-24 13:09:39 UTC (rev 483)
@@ -72,7 +72,7 @@
_query.queryManufacturers();
_isSelectManufacturers = true;
}
-
+
// ===================================================================================
// Helper
// ======