svnno****@sourc*****
svnno****@sourc*****
2007年 7月 28日 (土) 03:46:36 JST
Revision: 397
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=397
Author: takeharu
Date: 2007-07-28 03:46:33 +0900 (Sat, 28 Jul 2007)
Log Message:
-----------
changed db schema
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersBhv.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/BsProductsBhv.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersDao.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/BsProductsDao.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrders.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/dbmeta/OrdersDbm.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/ProductsDbm.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersCB.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersProductsCB.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/AbstractBsOrdersCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersProductsCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersStatusCQ.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/BsOrdersCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersProductsCQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersStatusCQ.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/OrdersCIQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersProductsCIQ.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersStatusCIQ.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/OrdersNss.java
pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersProductsNss.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/BsOrdersBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersBhv.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersBhv.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -11,6 +11,8 @@
import jp.sf.pal.pompei.allcommon.cbean.PagingResultBean;
import jp.sf.pal.pompei.allcommon.dbmeta.DBMeta;
+import jp.sf.pal.pompei.exbhv.*;
+
import jp.sf.pal.pompei.exdao.*;
import jp.sf.pal.pompei.exentity.*;
import jp.sf.pal.pompei.bsentity.dbmeta.*;
@@ -26,19 +28,19 @@
* ORDERS_ID
*
* [column-property]
- * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
+ * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
*
* [foreign-property]
- *
+ * ordersStatus
*
* [refferer-property]
- *
+ * ordersProductsList
*
* [sequence]
*
*
* [identity]
- *
+ * ordersId
*
* [update-date]
*
@@ -456,10 +458,176 @@
// Load Referer
// ============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [ORDERS_PRODUCTS]
+ // RefererProperty = [ordersProductsList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of ordersProductsList.
+ * <pre>
+ * You can load referer.
+ *
+ * ex) {Client Example}
+ * final OrdersCB cb = new OrdersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Orders> ordersList = ordersBhv.selectList(cb);
+ * ordersBhv.loadOrdersProductsList(ordersList);
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param ordersList Entity list of orders. (NotNull)
+ */
+ public void loadOrdersProductsList(java.util.List<Orders> ordersList) {
+ final ConditionBeanSetupper<OrdersProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ public void setup(OrdersProductsCB cb) {
+ }
+ };
+ loadOrdersProductsList(ordersList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of ordersProductsList.
+ * <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 OrdersCB cb = new OrdersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Orders> ordersList = ordersBhv.selectList(cb);
+ * final ConditionBeanSetupper<OrdersProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ * public void setup(OrdersProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * ordersBhv.loadOrdersProductsList(ordersList, conditionBeanSetupper);
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setOrdersId_InScope(pkList);
+ * cb.query().addOrderBy_OrdersId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param ordersList Entity list of orders. (NotNull)
+ * @param conditionBeanSetupper Referer condition setupper instance for registering referer condition. (NotNull)
+ */
+ public void loadOrdersProductsList(java.util.List<Orders> ordersList, ConditionBeanSetupper<OrdersProductsCB> conditionBeanSetupper) {
+ assertObjectNotNull("ordersList<Orders>", ordersList);
+ assertObjectNotNull("conditionBeanSetupper<OrdersProductsCB>", conditionBeanSetupper);
+ if (ordersList.isEmpty()) {
+ return;
+ }
+ loadOrdersProductsList(ordersList, new LoadRefererOption<OrdersProductsCB, OrdersProducts>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of ordersProductsList.
+ * <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 OrdersCB cb = new OrdersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Orders> ordersList = ordersBhv.selectList(cb);
+ * final ConditionBeanSetupper<OrdersProductsCB> cbSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ * public void setup(OrdersProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * ordersBhv.loadOrdersProductsList(ordersList, new LoadRefererOption<OrdersProductsCB, OrdersProducts>(cbSetupper));
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setOrdersId_InScope(pkList);
+ * cb.query().addOrderBy_OrdersId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param ordersList Entity list of orders. (NotNull)
+ * @param loadRefererOption Load-referer option. (NotNull)
+ */
+ public void loadOrdersProductsList(java.util.List<Orders> ordersList, LoadRefererOption<OrdersProductsCB, OrdersProducts> loadRefererOption) {
+ assertObjectNotNull("ordersList<Orders>", ordersList);
+ assertObjectNotNull("loadRefererOption<OrdersProducts, OrdersProductsCB>", loadRefererOption);
+ if (ordersList.isEmpty()) {
+ return;
+ }
+
+ final java.util.Map<java.math.BigDecimal, Orders> pkMyEntityMap = new java.util.LinkedHashMap<java.math.BigDecimal, Orders>();
+ final java.util.List<java.math.BigDecimal> pkList = new java.util.ArrayList<java.math.BigDecimal>();
+ for (Orders orders : ordersList) {
+ pkList.add(orders.getOrdersId());
+ pkMyEntityMap.put((java.math.BigDecimal)toLowerCaseIfString(orders.getOrdersId()), orders);
+ }
+ final OrdersProductsBhv refererBhv = getDaoSelector().getBehavior(OrdersProductsBhv.class);
+ final OrdersProductsCB cb = loadRefererOption.getReffererConditionBean() != null ? loadRefererOption.getReffererConditionBean() : refererBhv.newMyConditionBean();
+ cb.query().setOrdersId_InScope(pkList);
+ loadRefererOption.delegateKeyConditionExchangingFirstWhereClauseForLastOne(cb);
+ if (!loadRefererOption.isStopOrderByKey()) {
+ cb.query().addOrderBy_OrdersId_Asc();
+ cb.getSqlComponentOfOrderByClause().exchangeFirstOrderByElementForLastOne();
+ }
+ loadRefererOption.delegateConditionBeanSettingUp(cb);
+ final java.util.List<OrdersProducts> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<OrdersProducts>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<OrdersProducts>>();
+ for (OrdersProducts reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getOrdersId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getOrdersId()), new java.util.ArrayList<OrdersProducts>());
+ }
+ (pkReffererListMap.get(toLowerCaseIfString(reffererEntity.getOrdersId()))).add(reffererEntity);
+
+ // for Reverse Reference.
+ final Orders myEntity = pkMyEntityMap.get(toLowerCaseIfString(reffererEntity.getOrdersId()));
+ reffererEntity.setOrders(myEntity);
+ }
+
+ for (Orders orders : ordersList) {
+ if (pkReffererListMap.containsKey(toLowerCaseIfString(orders.getOrdersId()))) {
+ orders.setOrdersProductsList((java.util.List<OrdersProducts>)pkReffererListMap.get(toLowerCaseIfString(orders.getOrdersId())));
+ } else {
+ orders.setOrdersProductsList(new java.util.ArrayList<OrdersProducts>());
+ }
+ }
+ }
+
// ===================================================================================
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'OrdersStatus'.
+ *
+ * @param ordersList The list of orders. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<OrdersStatus> pulloutOrdersStatus(java.util.List<Orders> ordersList) {
+ assertObjectNotNull("ordersList", ordersList);
+ final java.util.Set<OrdersStatus> foreignSet = new java.util.LinkedHashSet<OrdersStatus>();
+ for (java.util.Iterator ite = ordersList.iterator(); ite.hasNext(); ) {
+ final Orders orders = (Orders)ite.next();
+ final OrdersStatus foreignEntity = orders.getOrdersStatus();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<OrdersStatus>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
@@ -630,7 +798,7 @@
if (names.contains("ccExpires")) { destinationMyEntity.setCcExpires(sourceMyEntity.getCcExpires()); }
if (names.contains("lastModified")) { destinationMyEntity.setLastModified(sourceMyEntity.getLastModified()); }
if (names.contains("datePurchased")) { destinationMyEntity.setDatePurchased(sourceMyEntity.getDatePurchased()); }
- if (names.contains("ordersStatus")) { destinationMyEntity.setOrdersStatus(sourceMyEntity.getOrdersStatus()); }
+ if (names.contains("ordersStatusId")) { destinationMyEntity.setOrdersStatusId(sourceMyEntity.getOrdersStatusId()); }
if (names.contains("ordersDateFinished")) { destinationMyEntity.setOrdersDateFinished(sourceMyEntity.getOrdersDateFinished()); }
if (names.contains("currency")) { destinationMyEntity.setCurrency(sourceMyEntity.getCurrency()); }
if (names.contains("currencyValue")) { destinationMyEntity.setCurrencyValue(sourceMyEntity.getCurrencyValue()); }
@@ -716,6 +884,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 ordersId) {
+ Orders entity = new Orders();
+ entity.setOrdersId(ordersId);
+ final OrdersCB cb = newMyConditionBean();
+ cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString(entity));
+ final Orders currentEntity = selectEntityWithDeletedCheck(cb);
+ return delegateInsert(currentEntity);
+ }
+
+ /**
+ * Filter 'copy-insert' entity.
+ *
+ * @param orders Entity. (NotNull)
+ */
+ protected void filterCopyInsertEntity(Orders orders) {
+ }
// ===================================================================================
// CBSetupper
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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsOrdersProductsBhv.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -29,7 +29,7 @@
* ORDERS_PRODUCTS_ID, ORDERS_ID, PRODUCTS_ID, PRODUCTS_MODEL, PRODUCTS_NAME, PRODUCTS_PRICE, FINAL_PRICE, PRODUCTS_TAX, PRODUCTS_QUANTITY
*
* [foreign-property]
- *
+ * orders, products
*
* [refferer-property]
*
@@ -460,6 +460,46 @@
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Orders'.
+ *
+ * @param ordersProductsList The list of ordersProducts. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Orders> pulloutOrders(java.util.List<OrdersProducts> ordersProductsList) {
+ assertObjectNotNull("ordersProductsList", ordersProductsList);
+ final java.util.Set<Orders> foreignSet = new java.util.LinkedHashSet<Orders>();
+ for (java.util.Iterator ite = ordersProductsList.iterator(); ite.hasNext(); ) {
+ final OrdersProducts ordersProducts = (OrdersProducts)ite.next();
+ final Orders foreignEntity = ordersProducts.getOrders();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Orders>(foreignSet);
+ }
+
+ /**
+ * Pull out the list of foreign table 'Products'.
+ *
+ * @param ordersProductsList The list of ordersProducts. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Products> pulloutProducts(java.util.List<OrdersProducts> ordersProductsList) {
+ assertObjectNotNull("ordersProductsList", ordersProductsList);
+ final java.util.Set<Products> foreignSet = new java.util.LinkedHashSet<Products>();
+ for (java.util.Iterator ite = ordersProductsList.iterator(); ite.hasNext(); ) {
+ final OrdersProducts ordersProducts = (OrdersProducts)ite.next();
+ final Products foreignEntity = ordersProducts.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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -34,7 +34,7 @@
* manufacturers
*
* [refferer-property]
- * productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -459,6 +459,152 @@
// ============
// /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [ORDERS_PRODUCTS]
+ // RefererProperty = [ordersProductsList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of ordersProductsList.
+ * <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.loadOrdersProductsList(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 loadOrdersProductsList(java.util.List<Products> productsList) {
+ final ConditionBeanSetupper<OrdersProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ public void setup(OrdersProductsCB cb) {
+ }
+ };
+ loadOrdersProductsList(productsList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of ordersProductsList.
+ * <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<OrdersProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ * public void setup(OrdersProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadOrdersProductsList(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 loadOrdersProductsList(java.util.List<Products> productsList, ConditionBeanSetupper<OrdersProductsCB> conditionBeanSetupper) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("conditionBeanSetupper<OrdersProductsCB>", conditionBeanSetupper);
+ if (productsList.isEmpty()) {
+ return;
+ }
+ loadOrdersProductsList(productsList, new LoadRefererOption<OrdersProductsCB, OrdersProducts>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of ordersProductsList.
+ * <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<OrdersProductsCB> cbSetupper = new ConditionBeanSetupper<OrdersProductsCB>() {
+ * public void setup(OrdersProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadOrdersProductsList(productsList, new LoadRefererOption<OrdersProductsCB, OrdersProducts>(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 loadOrdersProductsList(java.util.List<Products> productsList, LoadRefererOption<OrdersProductsCB, OrdersProducts> loadRefererOption) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("loadRefererOption<OrdersProducts, OrdersProductsCB>", 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 OrdersProductsBhv refererBhv = getDaoSelector().getBehavior(OrdersProductsBhv.class);
+ final OrdersProductsCB 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<OrdersProducts> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<OrdersProducts>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<OrdersProducts>>();
+ for (OrdersProducts reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getProductsId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getProductsId()), new java.util.ArrayList<OrdersProducts>());
+ }
+ (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.setOrdersProductsList((java.util.List<OrdersProducts>)pkReffererListMap.get(toLowerCaseIfString(products.getProductsId())));
+ } else {
+ products.setOrdersProductsList(new java.util.ArrayList<OrdersProducts>());
+ }
+ }
+ }
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
// RefererTable = [PRODUCTS_DESCRIPTION]
// RefererProperty = [productsDescriptionList]
// * * * * * * * * */
@@ -773,7 +919,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/BsOrdersDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersDao.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersDao.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -11,19 +11,19 @@
* ORDERS_ID
*
* [column-property]
- * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
+ * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
*
* [foreign-property]
- *
+ * ordersStatus
*
* [refferer-property]
- *
+ * ordersProductsList
*
* [sequence]
*
*
* [identity]
- *
+ * ordersId
*
* [update-date]
*
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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsOrdersProductsDao.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -14,7 +14,7 @@
* ORDERS_PRODUCTS_ID, ORDERS_ID, PRODUCTS_ID, PRODUCTS_MODEL, PRODUCTS_NAME, PRODUCTS_PRICE, FINAL_PRICE, PRODUCTS_TAX, PRODUCTS_QUANTITY
*
* [foreign-property]
- *
+ * orders, 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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -17,7 +17,7 @@
* manufacturers
*
* [refferer-property]
- * productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrders.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrders.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrders.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -13,19 +13,19 @@
* ORDERS_ID
*
* [column-property]
- * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
+ * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
*
* [foreign-property]
- *
+ * ordersStatus
*
* [refferer-property]
- *
+ * ordersProductsList
*
* [sequence]
*
*
* [identity]
- *
+ * ordersId
*
* [update-date]
*
@@ -45,6 +45,9 @@
/** TABLE-Annotation for S2Dao */
public static final String TABLE = "ORDERS";
+
+ /** ID-Annotation */
+ public static final String ordersId_ID = "identity";
// ===================================================================================
// Attribute
@@ -53,7 +56,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of ordersId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of ordersId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _ordersId;
/** The value of customersId. ColumnDefinition -- INTEGER : NotNull*/
@@ -167,8 +170,8 @@
/** The value of datePurchased. ColumnDefinition -- TIMESTAMP*/
protected java.sql.Timestamp _datePurchased;
- /** The value of ordersStatus. ColumnDefinition -- INTEGER : NotNull*/
- protected java.math.BigDecimal _ordersStatus;
+ /** The value of ordersStatusId. ColumnDefinition -- INTEGER : NotNull : FK to ORDERS_STATUS*/
+ protected java.math.BigDecimal _ordersStatusId;
/** The value of ordersDateFinished. ColumnDefinition -- TIMESTAMP*/
protected java.sql.Timestamp _ordersDateFinished;
@@ -235,12 +238,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 ordersId_COLUMN = "ORDERS_ID";
/**
* Get the value of ordersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @return The value of ordersId. (Nullable)
*/
@@ -250,7 +253,7 @@
/**
* Set the value of ordersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @param ordersId The value of ordersId. (Nullable)
*/
@@ -1147,28 +1150,28 @@
_datePurchased = datePurchased;
}
- /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull*/
- public static final String ordersStatus_COLUMN = "ORDERS_STATUS";
+ /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull : FK to ORDERS_STATUS*/
+ public static final String ordersStatusId_COLUMN = "ORDERS_STATUS_ID";
/**
- * Get the value of ordersStatus. <br />
- * {INTEGER : NotNull}
+ * Get the value of ordersStatusId. <br />
+ * {INTEGER : NotNull : FK to ORDERS_STATUS}
*
- * @return The value of ordersStatus. (Nullable)
+ * @return The value of ordersStatusId. (Nullable)
*/
- public java.math.BigDecimal getOrdersStatus() {
- return _ordersStatus;
+ public java.math.BigDecimal getOrdersStatusId() {
+ return _ordersStatusId;
}
/**
- * Set the value of ordersStatus. <br />
- * {INTEGER : NotNull}
+ * Set the value of ordersStatusId. <br />
+ * {INTEGER : NotNull : FK to ORDERS_STATUS}
*
- * @param ordersStatus The value of ordersStatus. (Nullable)
+ * @param ordersStatusId The value of ordersStatusId. (Nullable)
*/
- public void setOrdersStatus(java.math.BigDecimal ordersStatus) {
- _modifiedProperties.addPropertyName("ordersStatus");
- _ordersStatus = ordersStatus;
+ public void setOrdersStatusId(java.math.BigDecimal ordersStatusId) {
+ _modifiedProperties.addPropertyName("ordersStatusId");
+ _ordersStatusId = ordersStatusId;
}
/** Column-Annotation for S2Dao. ColumnDefinition -- TIMESTAMP*/
@@ -1262,10 +1265,80 @@
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS_STATUS]
+ // ForeignProperty = [ordersStatus]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int ordersStatus_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String ordersStatus_RELKEYS = "ORDERS_STATUS_ID:ORDERS_STATUS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.OrdersStatus _parentOrdersStatus;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.OrdersStatus getOrdersStatus() {
+ return _parentOrdersStatus;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setOrdersStatus(jp.sf.pal.pompei.exentity.OrdersStatus entity) {
+ this._parentOrdersStatus = entity;
+ }
+
+ /**
+ * Has relation object of ordersStatus.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationOrdersStatus() {
+ return _parentOrdersStatus != null && _parentOrdersStatus.hasPrimaryKeyValue();
+ }
+
+
// ===================================================================================
// Refferer Table
// ==============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [ORDERS_PRODUCTS]
+ // ReffererProperty = [ordersProductsList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.OrdersProducts> _childrenOrdersProductsList;
+
+ /**
+ * 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.OrdersProducts> getOrdersProductsList() {
+ return _childrenOrdersProductsList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setOrdersProductsList(java.util.List<jp.sf.pal.pompei.exentity.OrdersProducts> entity) {
+ this._childrenOrdersProductsList = entity;
+ }
+
// ===================================================================================
// Accept
// ======
@@ -1496,7 +1569,7 @@
sb.append(delimiter).append(getCcExpires());
sb.append(delimiter).append(getLastModified());
sb.append(delimiter).append(getDatePurchased());
- sb.append(delimiter).append(getOrdersStatus());
+ sb.append(delimiter).append(getOrdersStatusId());
sb.append(delimiter).append(getOrdersDateFinished());
sb.append(delimiter).append(getCurrency());
sb.append(delimiter).append(getCurrencyValue());
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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrdersProducts.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -16,7 +16,7 @@
* ORDERS_PRODUCTS_ID, ORDERS_ID, PRODUCTS_ID, PRODUCTS_MODEL, PRODUCTS_NAME, PRODUCTS_PRICE, FINAL_PRICE, PRODUCTS_TAX, PRODUCTS_QUANTITY
*
* [foreign-property]
- *
+ * orders, products
*
* [refferer-property]
*
@@ -56,10 +56,10 @@
/** The value of ordersProductsId. ColumnDefinition -- PK : INTEGER : NotNull*/
protected java.math.BigDecimal _ordersProductsId;
- /** The value of ordersId. ColumnDefinition -- INTEGER : NotNull*/
+ /** The value of ordersId. ColumnDefinition -- INTEGER : NotNull : FK to ORDERS*/
protected java.math.BigDecimal _ordersId;
- /** 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 productsModel. ColumnDefinition -- VARCHAR(12)*/
@@ -160,12 +160,12 @@
_ordersProductsId = ordersProductsId;
}
- /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull : FK to ORDERS*/
public static final String ordersId_COLUMN = "ORDERS_ID";
/**
* Get the value of ordersId. <br />
- * {INTEGER : NotNull}
+ * {INTEGER : NotNull : FK to ORDERS}
*
* @return The value of ordersId. (Nullable)
*/
@@ -175,7 +175,7 @@
/**
* Set the value of ordersId. <br />
- * {INTEGER : NotNull}
+ * {INTEGER : NotNull : FK to ORDERS}
*
* @param ordersId The value of ordersId. (Nullable)
*/
@@ -184,12 +184,12 @@
_ordersId = ordersId;
}
- /** 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)
*/
@@ -199,7 +199,7 @@
/**
* Set the value of productsId. <br />
- * {INTEGER : NotNull}
+ * {INTEGER : NotNull : FK to PRODUCTS}
*
* @param productsId The value of productsId. (Nullable)
*/
@@ -371,6 +371,90 @@
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS]
+ // ForeignProperty = [orders]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int orders_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String orders_RELKEYS = "ORDERS_ID:ORDERS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.Orders _parentOrders;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.Orders getOrders() {
+ return _parentOrders;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setOrders(jp.sf.pal.pompei.exentity.Orders entity) {
+ this._parentOrders = entity;
+ }
+
+ /**
+ * Has relation object of orders.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationOrders() {
+ return _parentOrders != null && _parentOrders.hasPrimaryKeyValue();
+ }
+
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int products_RELNO = 1;
+
+ /** 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/BsProducts.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -19,7 +19,7 @@
* manufacturers
*
* [refferer-property]
- * productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -530,6 +530,34 @@
// /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [ORDERS_PRODUCTS]
+ // ReffererProperty = [ordersProductsList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.OrdersProducts> _childrenOrdersProductsList;
+
+ /**
+ * 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.OrdersProducts> getOrdersProductsList() {
+ return _childrenOrdersProductsList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setOrdersProductsList(java.util.List<jp.sf.pal.pompei.exentity.OrdersProducts> entity) {
+ this._childrenOrdersProductsList = entity;
+ }
+
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
// ReffererTable = [PRODUCTS_DESCRIPTION]
// ReffererProperty = [productsDescriptionList]
// * * * * * * * * */
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersDbm.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersDbm.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -14,19 +14,19 @@
* ORDERS_ID
*
* [column-property]
- * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
+ * ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE
*
* [foreign-property]
- *
+ * ordersStatus
*
* [refferer-property]
- *
+ * ordersProductsList
*
* [sequence]
*
*
* [identity]
- *
+ * ordersId
*
* [update-date]
*
@@ -158,8 +158,8 @@
public static final String COLUMN_DB_NAME_OF_LastModified = "LAST_MODIFIED";
/** Db-name of DatePurchased. */
public static final String COLUMN_DB_NAME_OF_DatePurchased = "DATE_PURCHASED";
- /** Db-name of OrdersStatus. */
- public static final String COLUMN_DB_NAME_OF_OrdersStatus = "ORDERS_STATUS";
+ /** Db-name of OrdersStatusId. */
+ public static final String COLUMN_DB_NAME_OF_OrdersStatusId = "ORDERS_STATUS_ID";
/** Db-name of OrdersDateFinished. */
public static final String COLUMN_DB_NAME_OF_OrdersDateFinished = "ORDERS_DATE_FINISHED";
/** Db-name of Currency. */
@@ -243,8 +243,8 @@
public static final String COLUMN_CAP_PROP_NAME_OF_LastModified = "LastModified";
/** Cap-prop-name of DatePurchased. */
public static final String COLUMN_CAP_PROP_NAME_OF_DatePurchased = "DatePurchased";
- /** Cap-prop-name of OrdersStatus. */
- public static final String COLUMN_CAP_PROP_NAME_OF_OrdersStatus = "OrdersStatus";
+ /** Cap-prop-name of OrdersStatusId. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_OrdersStatusId = "OrdersStatusId";
/** Cap-prop-name of OrdersDateFinished. */
public static final String COLUMN_CAP_PROP_NAME_OF_OrdersDateFinished = "OrdersDateFinished";
/** Cap-prop-name of Currency. */
@@ -252,7 +252,11 @@
/** Cap-prop-name of CurrencyValue. */
public static final String COLUMN_CAP_PROP_NAME_OF_CurrencyValue = "CurrencyValue";
+ /** Cap-prop-name of ordersStatus. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_OrdersStatus = "OrdersStatus";
+ /** Cap-prop-name of OrdersProductsList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_OrdersProductsList = "OrdersProductsList";
/** Uncap-prop-name of OrdersId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersId = "ordersId";
@@ -330,8 +334,8 @@
public static final String COLUMN_UNCAP_PROP_NAME_OF_LastModified = "lastModified";
/** Uncap-prop-name of DatePurchased. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_DatePurchased = "datePurchased";
- /** Uncap-prop-name of OrdersStatus. */
- public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus = "ordersStatus";
+ /** Uncap-prop-name of OrdersStatusId. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersStatusId = "ordersStatusId";
/** Uncap-prop-name of OrdersDateFinished. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersDateFinished = "ordersDateFinished";
/** Uncap-prop-name of Currency. */
@@ -339,7 +343,11 @@
/** Uncap-prop-name of CurrencyValue. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_CurrencyValue = "currencyValue";
+ /** Uncap-prop-name of ordersStatus. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus = "ordersStatus";
+ /** Uncap-prop-name of ordersProductsList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersProductsList = "ordersProductsList";
/** {db-name : cap-prop-name} map. */
private static java.util.Map<String, String> _dbNameCapPropNameMap;
@@ -388,7 +396,7 @@
map.put(COLUMN_DB_NAME_OF_CcExpires, COLUMN_CAP_PROP_NAME_OF_CcExpires);
map.put(COLUMN_DB_NAME_OF_LastModified, COLUMN_CAP_PROP_NAME_OF_LastModified);
map.put(COLUMN_DB_NAME_OF_DatePurchased, COLUMN_CAP_PROP_NAME_OF_DatePurchased);
- map.put(COLUMN_DB_NAME_OF_OrdersStatus, COLUMN_CAP_PROP_NAME_OF_OrdersStatus);
+ map.put(COLUMN_DB_NAME_OF_OrdersStatusId, COLUMN_CAP_PROP_NAME_OF_OrdersStatusId);
map.put(COLUMN_DB_NAME_OF_OrdersDateFinished, COLUMN_CAP_PROP_NAME_OF_OrdersDateFinished);
map.put(COLUMN_DB_NAME_OF_Currency, COLUMN_CAP_PROP_NAME_OF_Currency);
map.put(COLUMN_DB_NAME_OF_CurrencyValue, COLUMN_CAP_PROP_NAME_OF_CurrencyValue);
@@ -444,7 +452,7 @@
map.put(COLUMN_DB_NAME_OF_CcExpires, COLUMN_UNCAP_PROP_NAME_OF_CcExpires);
map.put(COLUMN_DB_NAME_OF_LastModified, COLUMN_UNCAP_PROP_NAME_OF_LastModified);
map.put(COLUMN_DB_NAME_OF_DatePurchased, COLUMN_UNCAP_PROP_NAME_OF_DatePurchased);
- map.put(COLUMN_DB_NAME_OF_OrdersStatus, COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus);
+ map.put(COLUMN_DB_NAME_OF_OrdersStatusId, COLUMN_UNCAP_PROP_NAME_OF_OrdersStatusId);
map.put(COLUMN_DB_NAME_OF_OrdersDateFinished, COLUMN_UNCAP_PROP_NAME_OF_OrdersDateFinished);
map.put(COLUMN_DB_NAME_OF_Currency, COLUMN_UNCAP_PROP_NAME_OF_Currency);
map.put(COLUMN_DB_NAME_OF_CurrencyValue, COLUMN_UNCAP_PROP_NAME_OF_CurrencyValue);
@@ -500,7 +508,7 @@
map.put(COLUMN_CAP_PROP_NAME_OF_CcExpires, COLUMN_DB_NAME_OF_CcExpires);
map.put(COLUMN_CAP_PROP_NAME_OF_LastModified, COLUMN_DB_NAME_OF_LastModified);
map.put(COLUMN_CAP_PROP_NAME_OF_DatePurchased, COLUMN_DB_NAME_OF_DatePurchased);
- map.put(COLUMN_CAP_PROP_NAME_OF_OrdersStatus, COLUMN_DB_NAME_OF_OrdersStatus);
+ map.put(COLUMN_CAP_PROP_NAME_OF_OrdersStatusId, COLUMN_DB_NAME_OF_OrdersStatusId);
map.put(COLUMN_CAP_PROP_NAME_OF_OrdersDateFinished, COLUMN_DB_NAME_OF_OrdersDateFinished);
map.put(COLUMN_CAP_PROP_NAME_OF_Currency, COLUMN_DB_NAME_OF_Currency);
map.put(COLUMN_CAP_PROP_NAME_OF_CurrencyValue, COLUMN_DB_NAME_OF_CurrencyValue);
@@ -556,7 +564,7 @@
map.put(COLUMN_CAP_PROP_NAME_OF_CcExpires, COLUMN_UNCAP_PROP_NAME_OF_CcExpires);
map.put(COLUMN_CAP_PROP_NAME_OF_LastModified, COLUMN_UNCAP_PROP_NAME_OF_LastModified);
map.put(COLUMN_CAP_PROP_NAME_OF_DatePurchased, COLUMN_UNCAP_PROP_NAME_OF_DatePurchased);
- map.put(COLUMN_CAP_PROP_NAME_OF_OrdersStatus, COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus);
+ map.put(COLUMN_CAP_PROP_NAME_OF_OrdersStatusId, COLUMN_UNCAP_PROP_NAME_OF_OrdersStatusId);
map.put(COLUMN_CAP_PROP_NAME_OF_OrdersDateFinished, COLUMN_UNCAP_PROP_NAME_OF_OrdersDateFinished);
map.put(COLUMN_CAP_PROP_NAME_OF_Currency, COLUMN_UNCAP_PROP_NAME_OF_Currency);
map.put(COLUMN_CAP_PROP_NAME_OF_CurrencyValue, COLUMN_UNCAP_PROP_NAME_OF_CurrencyValue);
@@ -612,7 +620,7 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_CcExpires, COLUMN_DB_NAME_OF_CcExpires);
map.put(COLUMN_UNCAP_PROP_NAME_OF_LastModified, COLUMN_DB_NAME_OF_LastModified);
map.put(COLUMN_UNCAP_PROP_NAME_OF_DatePurchased, COLUMN_DB_NAME_OF_DatePurchased);
- map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus, COLUMN_DB_NAME_OF_OrdersStatus);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersStatusId, COLUMN_DB_NAME_OF_OrdersStatusId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersDateFinished, COLUMN_DB_NAME_OF_OrdersDateFinished);
map.put(COLUMN_UNCAP_PROP_NAME_OF_Currency, COLUMN_DB_NAME_OF_Currency);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CurrencyValue, COLUMN_DB_NAME_OF_CurrencyValue);
@@ -668,7 +676,7 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_CcExpires, COLUMN_CAP_PROP_NAME_OF_CcExpires);
map.put(COLUMN_UNCAP_PROP_NAME_OF_LastModified, COLUMN_CAP_PROP_NAME_OF_LastModified);
map.put(COLUMN_UNCAP_PROP_NAME_OF_DatePurchased, COLUMN_CAP_PROP_NAME_OF_DatePurchased);
- map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersStatus, COLUMN_CAP_PROP_NAME_OF_OrdersStatus);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersStatusId, COLUMN_CAP_PROP_NAME_OF_OrdersStatusId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_OrdersDateFinished, COLUMN_CAP_PROP_NAME_OF_OrdersDateFinished);
map.put(COLUMN_UNCAP_PROP_NAME_OF_Currency, COLUMN_CAP_PROP_NAME_OF_Currency);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CurrencyValue, COLUMN_CAP_PROP_NAME_OF_CurrencyValue);
@@ -800,7 +808,7 @@
* @return Column-db-name comma-string. (NotNull)
*/
public String getColumnDbNameCommaString() {
- return "ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE";
+ return "ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE";
}
// ===================================================================================
@@ -905,6 +913,15 @@
}
}
+ /**
+ * Get foreign dbmeta of OrdersStatus.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public OrdersStatusDbm getForeignDBMeta_OrdersStatus() {
+ return OrdersStatusDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
@@ -1008,7 +1025,7 @@
if (analyzer.init("CC_EXPIRES", "ccExpires", "ccExpires")) { myEntity.setCcExpires(analyzer.analyzeString(String.class)); };
if (analyzer.init("LAST_MODIFIED", "lastModified", "lastModified")) { myEntity.setLastModified(analyzer.analyzeDate(java.sql.Timestamp.class)); };
if (analyzer.init("DATE_PURCHASED", "datePurchased", "datePurchased")) { myEntity.setDatePurchased(analyzer.analyzeDate(java.sql.Timestamp.class)); };
- if (analyzer.init("ORDERS_STATUS", "ordersStatus", "ordersStatus")) { myEntity.setOrdersStatus(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
+ if (analyzer.init("ORDERS_STATUS_ID", "ordersStatusId", "ordersStatusId")) { myEntity.setOrdersStatusId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
if (analyzer.init("ORDERS_DATE_FINISHED", "ordersDateFinished", "ordersDateFinished")) { myEntity.setOrdersDateFinished(analyzer.analyzeDate(java.sql.Timestamp.class)); };
if (analyzer.init("CURRENCY", "currency", "currency")) { myEntity.setCurrency(analyzer.analyzeString(String.class)); };
if (analyzer.init("CURRENCY_VALUE", "currencyValue", "currencyValue")) { myEntity.setCurrencyValue(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
@@ -1123,7 +1140,7 @@
helpAppendingColumnValueString(sb, delimiter, equal, "CC_EXPIRES", myEntity.getCcExpires());
helpAppendingColumnValueString(sb, delimiter, equal, "LAST_MODIFIED", myEntity.getLastModified());
helpAppendingColumnValueString(sb, delimiter, equal, "DATE_PURCHASED", myEntity.getDatePurchased());
- helpAppendingColumnValueString(sb, delimiter, equal, "ORDERS_STATUS", myEntity.getOrdersStatus());
+ helpAppendingColumnValueString(sb, delimiter, equal, "ORDERS_STATUS_ID", myEntity.getOrdersStatusId());
helpAppendingColumnValueString(sb, delimiter, equal, "ORDERS_DATE_FINISHED", myEntity.getOrdersDateFinished());
helpAppendingColumnValueString(sb, delimiter, equal, "CURRENCY", myEntity.getCurrency());
helpAppendingColumnValueString(sb, delimiter, equal, "CURRENCY_VALUE", myEntity.getCurrencyValue());
@@ -1207,7 +1224,7 @@
valueMap.put("CC_EXPIRES", myEntity.getCcExpires());
valueMap.put("LAST_MODIFIED", myEntity.getLastModified());
valueMap.put("DATE_PURCHASED", myEntity.getDatePurchased());
- valueMap.put("ORDERS_STATUS", myEntity.getOrdersStatus());
+ valueMap.put("ORDERS_STATUS_ID", myEntity.getOrdersStatusId());
valueMap.put("ORDERS_DATE_FINISHED", myEntity.getOrdersDateFinished());
valueMap.put("CURRENCY", myEntity.getCurrency());
valueMap.put("CURRENCY_VALUE", myEntity.getCurrencyValue());
@@ -1259,7 +1276,7 @@
valueMap.put("CC_EXPIRES", helpGettingColumnStringValue(myEntity.getCcExpires()));
valueMap.put("LAST_MODIFIED", helpGettingColumnStringValue(myEntity.getLastModified()));
valueMap.put("DATE_PURCHASED", helpGettingColumnStringValue(myEntity.getDatePurchased()));
- valueMap.put("ORDERS_STATUS", helpGettingColumnStringValue(myEntity.getOrdersStatus()));
+ valueMap.put("ORDERS_STATUS_ID", helpGettingColumnStringValue(myEntity.getOrdersStatusId()));
valueMap.put("ORDERS_DATE_FINISHED", helpGettingColumnStringValue(myEntity.getOrdersDateFinished()));
valueMap.put("CURRENCY", helpGettingColumnStringValue(myEntity.getCurrency()));
valueMap.put("CURRENCY_VALUE", helpGettingColumnStringValue(myEntity.getCurrencyValue()));
@@ -1270,11 +1287,11 @@
// JDBC Support
// ============
public String getPreparedInsertClause() {
- return "insert into ORDERS(ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
+ return "insert into ORDERS(ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
}
public String getPreparedInsertClause(String tablePrefix) {
- return "insert into " + tablePrefix + "ORDERS(ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
+ return "insert into " + tablePrefix + "ORDERS(ORDERS_ID, CUSTOMERS_ID, CUSTOMERS_NAME, CUSTOMERS_COMPANY, CUSTOMERS_STREET_ADDRESS, CUSTOMERS_SUBURB, CUSTOMERS_CITY, CUSTOMERS_POSTCODE, CUSTOMERS_STATE, CUSTOMERS_COUNTRY, CUSTOMERS_TELEPHONE, CUSTOMERS_EMAIL_ADDRESS, CUSTOMERS_ADDRESS_FORMAT_ID, DELIVERY_NAME, DELIVERY_COMPANY, DELIVERY_STREET_ADDRESS, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_ADDRESS_FORMAT_ID, BILLING_NAME, BILLING_COMPANY, BILLING_STREET_ADDRESS, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_STATE, BILLING_COUNTRY, BILLING_ADDRESS_FORMAT_ID, PAYMENT_METHOD, CC_TYPE, CC_OWNER, CC_NUMBER, CC_EXPIRES, LAST_MODIFIED, DATE_PURCHASED, ORDERS_STATUS_ID, ORDERS_DATE_FINISHED, CURRENCY, CURRENCY_VALUE) 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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrdersProductsDbm.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -17,7 +17,7 @@
* ORDERS_PRODUCTS_ID, ORDERS_ID, PRODUCTS_ID, PRODUCTS_MODEL, PRODUCTS_NAME, PRODUCTS_PRICE, FINAL_PRICE, PRODUCTS_TAX, PRODUCTS_QUANTITY
*
* [foreign-property]
- *
+ * orders, products
*
* [refferer-property]
*
@@ -120,6 +120,10 @@
/** Cap-prop-name of ProductsQuantity. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsQuantity = "ProductsQuantity";
+ /** Cap-prop-name of orders. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Orders = "Orders";
+ /** Cap-prop-name of products. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Products = "Products";
/** Uncap-prop-name of OrdersProductsId. */
@@ -141,6 +145,10 @@
/** Uncap-prop-name of ProductsQuantity. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsQuantity = "productsQuantity";
+ /** Uncap-prop-name of orders. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Orders = "orders";
+ /** Uncap-prop-name of products. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Products = "products";
/** {db-name : cap-prop-name} map. */
@@ -509,6 +517,24 @@
}
}
+ /**
+ * Get foreign dbmeta of Orders.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public OrdersDbm getForeignDBMeta_Orders() {
+ return OrdersDbm.getInstance();
+ }
+
+ /**
+ * 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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -20,7 +20,7 @@
* manufacturers
*
* [refferer-property]
- * productsDescriptionList, productsToCategoriesList
+ * ordersProductsList, productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
@@ -139,6 +139,8 @@
/** Cap-prop-name of manufacturers. */
public static final String COLUMN_CAP_PROP_NAME_OF_Manufacturers = "Manufacturers";
+ /** Cap-prop-name of OrdersProductsList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_OrdersProductsList = "OrdersProductsList";
/** Cap-prop-name of ProductsDescriptionList. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsDescriptionList = "ProductsDescriptionList";
/** Cap-prop-name of ProductsToCategoriesList. */
@@ -174,6 +176,8 @@
/** Uncap-prop-name of manufacturers. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_Manufacturers = "manufacturers";
+ /** Uncap-prop-name of ordersProductsList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_OrdersProductsList = "ordersProductsList";
/** Uncap-prop-name of productsDescriptionList. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsDescriptionList = "productsDescriptionList";
/** Uncap-prop-name of productsToCategoriesList. */
@@ -577,7 +581,7 @@
public ManufacturersDbm getForeignDBMeta_Manufacturers() {
return ManufacturersDbm.getInstance();
}
-
+
// ===================================================================================
// Determination
// =============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersCB.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersCB.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersCB.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -189,7 +189,51 @@
// ===================================================================================
// Setup-Select
// ============
-
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS_STATUS]
+ // ForeignProperty = [ordersStatus]
+ // * * * * * * * * */
+
+ /** Is select for ordersStatus? */
+ protected boolean _isSelectOrdersStatus;
+ /** Nest select setupper for ordersStatus. */
+ protected OrdersStatusNss _nssOrdersStatus;
+ /**
+ * Is select for ordersStatus? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectOrdersStatus() {
+ return _isSelectOrdersStatus;
+ }
+ /**
+ * Get nest select setupper for ordersStatus. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public OrdersStatusNss getNssOrdersStatus() {
+ if (_nssOrdersStatus == null) {
+ _nssOrdersStatus = new OrdersStatusNss(null);// for Dummy
+ }
+ return _nssOrdersStatus;
+ }
+ /**
+ * Set up select for ordersStatus.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for ordersStatus. (NotNull)
+ */
+ public OrdersStatusNss setupSelect_OrdersStatus() {
+ query().queryOrdersStatus();// For setting outer join.
+ if (_nssOrdersStatus == null || !_nssOrdersStatus.hasConditionQuery()) {
+ _nssOrdersStatus = new OrdersStatusNss(query().queryOrdersStatus());
+ }
+ _isSelectOrdersStatus = true;
+ limitSelect_Off();
+ return _nssOrdersStatus;
+ }
+
// ===================================================================================
// Basic Override
// ==============
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersProductsCB.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersProductsCB.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsOrdersProductsCB.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -189,6 +189,94 @@
// ===================================================================================
// Setup-Select
// ============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS]
+ // ForeignProperty = [orders]
+ // * * * * * * * * */
+
+ /** Is select for orders? */
+ protected boolean _isSelectOrders;
+ /** Nest select setupper for orders. */
+ protected OrdersNss _nssOrders;
+ /**
+ * Is select for orders? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectOrders() {
+ return _isSelectOrders;
+ }
+ /**
+ * Get nest select setupper for orders. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public OrdersNss getNssOrders() {
+ if (_nssOrders == null) {
+ _nssOrders = new OrdersNss(null);// for Dummy
+ }
+ return _nssOrders;
+ }
+ /**
+ * Set up select for orders.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for orders. (NotNull)
+ */
+ public OrdersNss setupSelect_Orders() {
+ query().queryOrders();// For setting outer join.
+ if (_nssOrders == null || !_nssOrders.hasConditionQuery()) {
+ _nssOrders = new OrdersNss(query().queryOrders());
+ }
+ _isSelectOrders = true;
+ limitSelect_Off();
+ return _nssOrders;
+ }
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // 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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -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/AbstractBsOrdersCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -134,6 +134,40 @@
public void setOrdersId_NotInScope(java.util.List<java.math.BigDecimal> ordersIdList) {
registerOrdersId(ConditionKey.CK_NOT_IN_SCOPE, ordersIdList);
}
+
+ /**
+ * Set the sub-query of OrdersId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery.
+ * { in (select xxx.ORDERS_ID from ORDERS_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 OrdersId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery. (NotNull)
+ */
+ public void setOrdersId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersId_InScopeSubQuery_OrdersProductsList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_ORDERS_ID, "ORDERS_ID", "ordersId_InScopeSubQuery_OrdersProductsList");
+ }
+
+ abstract public void keepOrdersId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery);
+
+ /**
+ * Set the sub-query of OrdersId_ExistsSubQuery_OrdersProductsList using existsSubQuery.
+ * { exists (select xxx.ORDERS_ID from ORDERS_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 OrdersId_ExistsSubQuery_OrdersProductsList using existsSubQuery. (NotNull)
+ */
+ public void setOrdersId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersId_ExistsSubQuery_OrdersProductsList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_ORDERS_ID, "ORDERS_ID", "ordersId_ExistsSubQuery_OrdersProductsList");
+ }
+
+ abstract public void keepOrdersId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery);
/**
* Register condition of ordersId.
@@ -5410,110 +5444,127 @@
abstract protected ConditionValue getCValueDatePurchased();
- /** Column db name of ordersStatus. */
- protected static final String COL_ORDERS_STATUS = "ORDERS_STATUS";
+ /** Column db name of ordersStatusId. */
+ protected static final String COL_ORDERS_STATUS_ID = "ORDERS_STATUS_ID";
- /** Column java name of ordersStatus. */
- protected static final String J_OrdersStatus = "OrdersStatus";
+ /** Column java name of ordersStatusId. */
+ protected static final String J_OrdersStatusId = "OrdersStatusId";
- /** Column uncapitalised java name of ordersStatus. */
- protected static final String UJ_ordersStatus = "ordersStatus";
+ /** Column uncapitalised java name of ordersStatusId. */
+ protected static final String UJ_ordersStatusId = "ordersStatusId";
/**
- * Set the value of ordersStatus using equal. { = }
+ * Set the value of ordersStatusId using equal. { = }
*
- * @param ordersStatus The value of ordersStatus as equal.
+ * @param ordersStatusId The value of ordersStatusId as equal.
*/
- public void setOrdersStatus_Equal(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_EQUAL, ordersStatus);
+ public void setOrdersStatusId_Equal(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_EQUAL, ordersStatusId);
}
/**
- * Set the value of ordersStatus using notEqual. { != }
+ * Set the value of ordersStatusId using notEqual. { != }
*
- * @param ordersStatus The value of ordersStatus as notEqual.
+ * @param ordersStatusId The value of ordersStatusId as notEqual.
*/
- public void setOrdersStatus_NotEqual(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_NOT_EQUAL, ordersStatus);
+ public void setOrdersStatusId_NotEqual(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_NOT_EQUAL, ordersStatusId);
}
/**
- * Set the value of ordersStatus using greaterThan. { > }
+ * Set the value of ordersStatusId using greaterThan. { > }
*
- * @param ordersStatus The value of ordersStatus as greaterThan.
+ * @param ordersStatusId The value of ordersStatusId as greaterThan.
*/
- public void setOrdersStatus_GreaterThan(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_GREATER_THAN, ordersStatus);
+ public void setOrdersStatusId_GreaterThan(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_GREATER_THAN, ordersStatusId);
}
/**
- * Set the value of ordersStatus using lessThan. { < }
+ * Set the value of ordersStatusId using lessThan. { < }
*
- * @param ordersStatus The value of ordersStatus as lessThan.
+ * @param ordersStatusId The value of ordersStatusId as lessThan.
*/
- public void setOrdersStatus_LessThan(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_LESS_THAN, ordersStatus);
+ public void setOrdersStatusId_LessThan(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_LESS_THAN, ordersStatusId);
}
/**
- * Set the value of ordersStatus using greaterEqual. { >= }
+ * Set the value of ordersStatusId using greaterEqual. { >= }
*
- * @param ordersStatus The value of ordersStatus as greaterEqual.
+ * @param ordersStatusId The value of ordersStatusId as greaterEqual.
*/
- public void setOrdersStatus_GreaterEqual(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_GREATER_EQUAL, ordersStatus);
+ public void setOrdersStatusId_GreaterEqual(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_GREATER_EQUAL, ordersStatusId);
}
/**
- * Set the value of ordersStatus using lessEqual. { <= }
+ * Set the value of ordersStatusId using lessEqual. { <= }
*
- * @param ordersStatus The value of ordersStatus as lessEqual.
+ * @param ordersStatusId The value of ordersStatusId as lessEqual.
*/
- public void setOrdersStatus_LessEqual(java.math.BigDecimal ordersStatus) {
- registerOrdersStatus(ConditionKey.CK_LESS_EQUAL, ordersStatus);
+ public void setOrdersStatusId_LessEqual(java.math.BigDecimal ordersStatusId) {
+ registerOrdersStatusId(ConditionKey.CK_LESS_EQUAL, ordersStatusId);
}
/**
- * Set the value of ordersStatus using inScope. { in (a, b) }
+ * Set the value of ordersStatusId using inScope. { in (a, b) }
* If the element in the list is null or empty-string, the condition-element is ignored.
*
- * @param ordersStatusList The value of ordersStatus as inScope.
+ * @param ordersStatusIdList The value of ordersStatusId as inScope.
*/
- public void setOrdersStatus_InScope(java.util.List<java.math.BigDecimal> ordersStatusList) {
- registerOrdersStatus(ConditionKey.CK_IN_SCOPE, ordersStatusList);
+ public void setOrdersStatusId_InScope(java.util.List<java.math.BigDecimal> ordersStatusIdList) {
+ registerOrdersStatusId(ConditionKey.CK_IN_SCOPE, ordersStatusIdList);
}
/**
- * Set the value of ordersStatus using notInScope. { not in (a, b) }
+ * Set the value of ordersStatusId using notInScope. { not in (a, b) }
* If the element in the list is null or empty-string, the condition-element is ignored.
*
- * @param ordersStatusList The value of ordersStatus as notInScope.
+ * @param ordersStatusIdList The value of ordersStatusId as notInScope.
*/
- public void setOrdersStatus_NotInScope(java.util.List<java.math.BigDecimal> ordersStatusList) {
- registerOrdersStatus(ConditionKey.CK_NOT_IN_SCOPE, ordersStatusList);
+ public void setOrdersStatusId_NotInScope(java.util.List<java.math.BigDecimal> ordersStatusIdList) {
+ registerOrdersStatusId(ConditionKey.CK_NOT_IN_SCOPE, ordersStatusIdList);
}
-
+
/**
- * Register condition of ordersStatus.
+ * Set the sub-query of OrdersStatusId_InScopeSubQuery_OrdersStatus using inScopeSubQuery.
+ * { in (select xxx.ORDERS_STATUS_ID from ORDERS_STATUS 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 OrdersStatusId_InScopeSubQuery_OrdersStatus using inScopeSubQuery. (NotNull)
+ */
+ public void setOrdersStatusId_InScopeSubQuery_OrdersStatus(OrdersStatusCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersStatusId_InScopeSubQuery_OrdersStatus(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_ORDERS_STATUS_ID, "ORDERS_STATUS_ID", "ordersStatusId_InScopeSubQuery_OrdersStatus");
+ }
+
+ abstract public void keepOrdersStatusId_InScopeSubQuery_OrdersStatus(OrdersStatusCQ subQuery);
+
+ /**
+ * Register condition of ordersStatusId.
+ *
* @param key Condition key. (NotNull)
- * @param value The value of ordersStatus. (Nullable)
+ * @param value The value of ordersStatusId. (Nullable)
*/
- protected void registerOrdersStatus(ConditionKey key, Object value) {
- registerQuery(key, value, getCValueOrdersStatus(), COL_ORDERS_STATUS, J_OrdersStatus, UJ_ordersStatus);
+ protected void registerOrdersStatusId(ConditionKey key, Object value) {
+ registerQuery(key, value, getCValueOrdersStatusId(), COL_ORDERS_STATUS_ID, J_OrdersStatusId, UJ_ordersStatusId);
}
/**
- * Register inline condition of ordersStatus.
+ * Register inline condition of ordersStatusId.
*
* @param key Condition key. (NotNull)
- * @param value The value of ordersStatus. (Nullable)
+ * @param value The value of ordersStatusId. (Nullable)
*/
- protected void registerInlineOrdersStatus(ConditionKey key, Object value) {
- registerInlineQuery(key, value, getCValueOrdersStatus(), COL_ORDERS_STATUS, J_OrdersStatus, UJ_ordersStatus);
+ protected void registerInlineOrdersStatusId(ConditionKey key, Object value) {
+ registerInlineQuery(key, value, getCValueOrdersStatusId(), COL_ORDERS_STATUS_ID, J_OrdersStatusId, UJ_ordersStatusId);
}
- abstract protected ConditionValue getCValueOrdersStatus();
+ abstract protected ConditionValue getCValueOrdersStatusId();
/** Column db name of ordersDateFinished. */
protected static final String COL_ORDERS_DATE_FINISHED = "ORDERS_DATE_FINISHED";
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersProductsCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersProductsCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersProductsCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -239,8 +239,25 @@
public void setOrdersId_NotInScope(java.util.List<java.math.BigDecimal> ordersIdList) {
registerOrdersId(ConditionKey.CK_NOT_IN_SCOPE, ordersIdList);
}
-
+
/**
+ * Set the sub-query of OrdersId_InScopeSubQuery_Orders using inScopeSubQuery.
+ * { in (select xxx.ORDERS_ID from ORDERS 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 OrdersId_InScopeSubQuery_Orders using inScopeSubQuery. (NotNull)
+ */
+ public void setOrdersId_InScopeSubQuery_Orders(OrdersCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersId_InScopeSubQuery_Orders(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_ORDERS_ID, "ORDERS_ID", "ordersId_InScopeSubQuery_Orders");
+ }
+
+ abstract public void keepOrdersId_InScopeSubQuery_Orders(OrdersCQ subQuery);
+
+ /**
* Register condition of ordersId.
*
* @param key Condition key. (NotNull)
@@ -344,8 +361,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/AbstractBsOrdersStatusCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersStatusCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrdersStatusCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -134,6 +134,40 @@
public void setOrdersStatusId_NotInScope(java.util.List<java.math.BigDecimal> ordersStatusIdList) {
registerOrdersStatusId(ConditionKey.CK_NOT_IN_SCOPE, ordersStatusIdList);
}
+
+ /**
+ * Set the sub-query of OrdersStatusId_InScopeSubQuery_OrdersList using inScopeSubQuery.
+ * { in (select xxx.ORDERS_STATUS_ID from ORDERS 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 OrdersStatusId_InScopeSubQuery_OrdersList using inScopeSubQuery. (NotNull)
+ */
+ public void setOrdersStatusId_InScopeSubQuery_OrdersList(OrdersCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersStatusId_InScopeSubQuery_OrdersList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_ORDERS_STATUS_ID, "ORDERS_STATUS_ID", "ordersStatusId_InScopeSubQuery_OrdersList");
+ }
+
+ abstract public void keepOrdersStatusId_InScopeSubQuery_OrdersList(OrdersCQ subQuery);
+
+ /**
+ * Set the sub-query of OrdersStatusId_ExistsSubQuery_OrdersList using existsSubQuery.
+ * { exists (select xxx.ORDERS_STATUS_ID from ORDERS 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 OrdersStatusId_ExistsSubQuery_OrdersList using existsSubQuery. (NotNull)
+ */
+ public void setOrdersStatusId_ExistsSubQuery_OrdersList(OrdersCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepOrdersStatusId_ExistsSubQuery_OrdersList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_ORDERS_STATUS_ID, "ORDERS_STATUS_ID", "ordersStatusId_ExistsSubQuery_OrdersList");
+ }
+
+ abstract public void keepOrdersStatusId_ExistsSubQuery_OrdersList(OrdersCQ subQuery);
/**
* Register condition of ordersStatusId.
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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -136,6 +136,23 @@
}
/**
+ * Set the sub-query of ProductsId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from ORDERS_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_OrdersProductsList using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_OrdersProductsList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_OrdersProductsList");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ 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.
@@ -170,6 +187,23 @@
abstract public void keepProductsId_InScopeSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery);
/**
+ * Set the sub-query of ProductsId_ExistsSubQuery_OrdersProductsList using existsSubQuery.
+ * { exists (select xxx.PRODUCTS_ID from ORDERS_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_ExistsSubQuery_OrdersProductsList using existsSubQuery. (NotNull)
+ */
+ public void setProductsId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_ExistsSubQuery_OrdersProductsList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_ExistsSubQuery_OrdersProductsList");
+ }
+
+ abstract public void keepProductsId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ 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/BsOrdersCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -741,21 +741,21 @@
}
/**
- * Include select-column of ordersStatus as mine.
+ * Include select-column of ordersStatusId as mine.
* Alias name is java-name of this column.
* Be careful to whether your table have the same column.
*/
- public void includeAsMine_OrdersStatus() {
- registerIncludedSelectColumn("OrdersStatus", getRealColumnName("ORDERS_STATUS"));
+ public void includeAsMine_OrdersStatusId() {
+ registerIncludedSelectColumn("OrdersStatusId", getRealColumnName("ORDERS_STATUS_ID"));
}
/**
- * Include select-column of ordersStatus as mine.
+ * Include select-column of ordersStatusId as mine.
*
* @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
*/
- public void includeAsMine_OrdersStatus(String aliasName) {
- registerIncludedSelectColumn(aliasName, getRealColumnName("ORDERS_STATUS"));
+ public void includeAsMine_OrdersStatusId(String aliasName) {
+ registerIncludedSelectColumn(aliasName, getRealColumnName("ORDERS_STATUS_ID"));
}
/**
@@ -842,8 +842,40 @@
return getOrdersId();
}
-
+
+ /** The sub-query of OrdersId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery. */
+ protected OrdersProductsCQ _ordersId_InScopeSubQuery_OrdersProductsList;
+
/**
+ * Get the sub-query of OrdersId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery.
+ *
+ * @return The sub-query of OrdersId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery. (Nullable)
+ */
+ public OrdersProductsCQ getOrdersId_InScopeSubQuery_OrdersProductsList() {
+ return _ordersId_InScopeSubQuery_OrdersProductsList;
+ }
+
+ public void keepOrdersId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _ordersId_InScopeSubQuery_OrdersProductsList = subQuery;
+ }
+
+ /** The sub-query of OrdersId_ExistsSubQuery_OrdersProductsList using existsSubQuery. */
+ protected OrdersProductsCQ _ordersId_ExistsSubQuery_OrdersProductsList;
+
+ /**
+ * Get the sub-query of OrdersId_ExistsSubQuery_OrdersProductsList using existsSubQuery.
+ *
+ * @return The sub-query of OrdersId_ExistsSubQuery_OrdersProductsList using existsSubQuery. (Nullable)
+ */
+ public OrdersProductsCQ getOrdersId_ExistsSubQuery_OrdersProductsList() {
+ return _ordersId_ExistsSubQuery_OrdersProductsList;
+ }
+
+ public void keepOrdersId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _ordersId_ExistsSubQuery_OrdersProductsList = subQuery;
+ }
+
+ /**
* Add order-by of ordersId as ASC.
*
* @return this. (NotNull)
@@ -2416,45 +2448,61 @@
}
// /- - - - - - - - - - - - - - - - - - - - - - -
- // Column = [ORDERS_STATUS]
+ // Column = [ORDERS_STATUS_ID]
// - - - - - - - - -/
- /** The attribute of ordersStatus. */
- protected ConditionValue _ordersStatus;
+ /** The attribute of ordersStatusId. */
+ protected ConditionValue _ordersStatusId;
/**
- * Get the value of ordersStatus.
+ * Get the value of ordersStatusId.
*
- * @return The value of ordersStatus.
+ * @return The value of ordersStatusId.
*/
- public ConditionValue getOrdersStatus() {
- if (_ordersStatus == null) {
- _ordersStatus = new ConditionValue();
+ public ConditionValue getOrdersStatusId() {
+ if (_ordersStatusId == null) {
+ _ordersStatusId = new ConditionValue();
}
- return _ordersStatus;
+ return _ordersStatusId;
}
- protected ConditionValue getCValueOrdersStatus() {
- return getOrdersStatus();
+ protected ConditionValue getCValueOrdersStatusId() {
+ return getOrdersStatusId();
}
-
+
+ /** The sub-query of OrdersStatusId_InScopeSubQuery_OrdersStatus using inScopeSubQuery. */
+ protected OrdersStatusCQ _ordersStatusId_InScopeSubQuery_OrdersStatus;
+
/**
- * Add order-by of ordersStatus as ASC.
+ * Get the sub-query of OrdersStatusId_InScopeSubQuery_OrdersStatus using inScopeSubQuery.
*
+ * @return The sub-query of OrdersStatusId_InScopeSubQuery_OrdersStatus using inScopeSubQuery. (Nullable)
+ */
+ public OrdersStatusCQ getOrdersStatusId_InScopeSubQuery_OrdersStatus() {
+ return _ordersStatusId_InScopeSubQuery_OrdersStatus;
+ }
+
+ public void keepOrdersStatusId_InScopeSubQuery_OrdersStatus(OrdersStatusCQ subQuery) {
+ _ordersStatusId_InScopeSubQuery_OrdersStatus = subQuery;
+ }
+
+ /**
+ * Add order-by of ordersStatusId as ASC.
+ *
* @return this. (NotNull)
*/
- public BsOrdersCQ addOrderBy_OrdersStatus_Asc() {
- getSqlClause().registerOrderBy(getRealColumnName(COL_ORDERS_STATUS), null, true);return this;
+ public BsOrdersCQ addOrderBy_OrdersStatusId_Asc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_ORDERS_STATUS_ID), null, true);return this;
}
/**
- * Add order-by of ordersStatus as DESC.
+ * Add order-by of ordersStatusId as DESC.
*
* @return this. (NotNull)
*/
- public BsOrdersCQ addOrderBy_OrdersStatus_Desc() {
- getSqlClause().registerOrderBy(getRealColumnName(COL_ORDERS_STATUS), null, false);return this;
+ public BsOrdersCQ addOrderBy_OrdersStatusId_Desc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_ORDERS_STATUS_ID), null, false);return this;
}
// /- - - - - - - - - - - - - - - - - - - - - - -
@@ -2589,12 +2637,81 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final OrdersCQ baseQuery = (OrdersCQ)baseQueryAsSuper;
final OrdersCQ unionQuery = (OrdersCQ)unionQueryAsSuper;
-
+
+ if (baseQuery.hasConditionQueryOrdersStatus()) {
+ unionQuery.queryOrdersStatus().reflectRelationOnUnionQuery(baseQuery.queryOrdersStatus(), unionQuery.queryOrdersStatus());
+ }
+
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS_STATUS]
+ // ForeignProperty = [ordersStatus]
+ // * * * * * * * * */
+
+ /**
+ * Query for ordersStatus.
+ *
+ * @return Instance of OrdersStatusCQ as ordersStatus. (NotNull)
+ */
+ public OrdersStatusCQ queryOrdersStatus() {
+ return getConditionQueryOrdersStatus();
+ }
+
+ /** Condition-query for ordersStatus. */
+ protected OrdersStatusCQ _conditionQueryOrdersStatus;
+
+ /**
+ * Get condition-query for ordersStatus.
+ *
+ * @return Instance of OrdersStatusCQ as ordersStatus. (NotNull)
+ */
+ public OrdersStatusCQ getConditionQueryOrdersStatus() {
+ if (_conditionQueryOrdersStatus == null) {
+ _conditionQueryOrdersStatus = newQueryOrdersStatus();
+ setupOuterJoin_OrdersStatus();
+ }
+ return _conditionQueryOrdersStatus;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_OrdersStatus() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("ORDERS_STATUS_ID");
+ value = getConditionQueryOrdersStatus().getRealColumnName("ORDERS_STATUS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "ORDERS_STATUS";
+ final String aliasName = getConditionQueryOrdersStatus().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for ordersStatus.
+ *
+ * @return Query for ordersStatus. (NotNull)
+ */
+ protected OrdersStatusCQ newQueryOrdersStatus() {
+ return new OrdersStatusCQ(this, getSqlClause(), "OrdersStatus", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryOrdersStatus() {
+ return _conditionQueryOrdersStatus != null;
+ }
-
+
}
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersProductsCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersProductsCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersProductsCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -290,8 +290,24 @@
return getOrdersId();
}
-
+
+ /** The sub-query of OrdersId_InScopeSubQuery_Orders using inScopeSubQuery. */
+ protected OrdersCQ _ordersId_InScopeSubQuery_Orders;
+
/**
+ * Get the sub-query of OrdersId_InScopeSubQuery_Orders using inScopeSubQuery.
+ *
+ * @return The sub-query of OrdersId_InScopeSubQuery_Orders using inScopeSubQuery. (Nullable)
+ */
+ public OrdersCQ getOrdersId_InScopeSubQuery_Orders() {
+ return _ordersId_InScopeSubQuery_Orders;
+ }
+
+ public void keepOrdersId_InScopeSubQuery_Orders(OrdersCQ subQuery) {
+ _ordersId_InScopeSubQuery_Orders = subQuery;
+ }
+
+ /**
* Add order-by of ordersId as ASC.
*
* @return this. (NotNull)
@@ -332,8 +348,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)
@@ -609,12 +641,150 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final OrdersProductsCQ baseQuery = (OrdersProductsCQ)baseQueryAsSuper;
final OrdersProductsCQ unionQuery = (OrdersProductsCQ)unionQueryAsSuper;
+
+ if (baseQuery.hasConditionQueryOrders()) {
+ unionQuery.queryOrders().reflectRelationOnUnionQuery(baseQuery.queryOrders(), unionQuery.queryOrders());
+ }
+
+ if (baseQuery.hasConditionQueryProducts()) {
+ unionQuery.queryProducts().reflectRelationOnUnionQuery(baseQuery.queryProducts(), unionQuery.queryProducts());
+ }
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [ORDERS]
+ // ForeignProperty = [orders]
+ // * * * * * * * * */
+
+ /**
+ * Query for orders.
+ *
+ * @return Instance of OrdersCQ as orders. (NotNull)
+ */
+ public OrdersCQ queryOrders() {
+ return getConditionQueryOrders();
+ }
+
+ /** Condition-query for orders. */
+ protected OrdersCQ _conditionQueryOrders;
+
+ /**
+ * Get condition-query for orders.
+ *
+ * @return Instance of OrdersCQ as orders. (NotNull)
+ */
+ public OrdersCQ getConditionQueryOrders() {
+ if (_conditionQueryOrders == null) {
+ _conditionQueryOrders = newQueryOrders();
+ setupOuterJoin_Orders();
+ }
+ return _conditionQueryOrders;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_Orders() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("ORDERS_ID");
+ value = getConditionQueryOrders().getRealColumnName("ORDERS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "ORDERS";
+ final String aliasName = getConditionQueryOrders().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for orders.
+ *
+ * @return Query for orders. (NotNull)
+ */
+ protected OrdersCQ newQueryOrders() {
+ return new OrdersCQ(this, getSqlClause(), "Orders", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryOrders() {
+ return _conditionQueryOrders != null;
+ }
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // 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/BsOrdersStatusCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersStatusCQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrdersStatusCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -140,8 +140,40 @@
return getOrdersStatusId();
}
-
+
+ /** The sub-query of OrdersStatusId_InScopeSubQuery_OrdersList using inScopeSubQuery. */
+ protected OrdersCQ _ordersStatusId_InScopeSubQuery_OrdersList;
+
/**
+ * Get the sub-query of OrdersStatusId_InScopeSubQuery_OrdersList using inScopeSubQuery.
+ *
+ * @return The sub-query of OrdersStatusId_InScopeSubQuery_OrdersList using inScopeSubQuery. (Nullable)
+ */
+ public OrdersCQ getOrdersStatusId_InScopeSubQuery_OrdersList() {
+ return _ordersStatusId_InScopeSubQuery_OrdersList;
+ }
+
+ public void keepOrdersStatusId_InScopeSubQuery_OrdersList(OrdersCQ subQuery) {
+ _ordersStatusId_InScopeSubQuery_OrdersList = subQuery;
+ }
+
+ /** The sub-query of OrdersStatusId_ExistsSubQuery_OrdersList using existsSubQuery. */
+ protected OrdersCQ _ordersStatusId_ExistsSubQuery_OrdersList;
+
+ /**
+ * Get the sub-query of OrdersStatusId_ExistsSubQuery_OrdersList using existsSubQuery.
+ *
+ * @return The sub-query of OrdersStatusId_ExistsSubQuery_OrdersList using existsSubQuery. (Nullable)
+ */
+ public OrdersCQ getOrdersStatusId_ExistsSubQuery_OrdersList() {
+ return _ordersStatusId_ExistsSubQuery_OrdersList;
+ }
+
+ public void keepOrdersStatusId_ExistsSubQuery_OrdersList(OrdersCQ subQuery) {
+ _ordersStatusId_ExistsSubQuery_OrdersList = subQuery;
+ }
+
+ /**
* Add order-by of ordersStatusId as ASC.
*
* @return this. (NotNull)
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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -321,6 +321,22 @@
}
+ /** The sub-query of ProductsId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery. */
+ protected OrdersProductsCQ _productsId_InScopeSubQuery_OrdersProductsList;
+
+ /**
+ * Get the sub-query of ProductsId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_OrdersProductsList using inScopeSubQuery. (Nullable)
+ */
+ public OrdersProductsCQ getProductsId_InScopeSubQuery_OrdersProductsList() {
+ return _productsId_InScopeSubQuery_OrdersProductsList;
+ }
+
+ public void keepProductsId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _productsId_InScopeSubQuery_OrdersProductsList = subQuery;
+ }
+
/** The sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery. */
protected ProductsDescriptionCQ _productsId_InScopeSubQuery_ProductsDescriptionList;
@@ -353,6 +369,22 @@
_productsId_InScopeSubQuery_ProductsToCategoriesList = subQuery;
}
+ /** The sub-query of ProductsId_ExistsSubQuery_OrdersProductsList using existsSubQuery. */
+ protected OrdersProductsCQ _productsId_ExistsSubQuery_OrdersProductsList;
+
+ /**
+ * Get the sub-query of ProductsId_ExistsSubQuery_OrdersProductsList using existsSubQuery.
+ *
+ * @return The sub-query of ProductsId_ExistsSubQuery_OrdersProductsList using existsSubQuery. (Nullable)
+ */
+ public OrdersProductsCQ getProductsId_ExistsSubQuery_OrdersProductsList() {
+ return _productsId_ExistsSubQuery_OrdersProductsList;
+ }
+
+ public void keepProductsId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _productsId_ExistsSubQuery_OrdersProductsList = subQuery;
+ }
+
/** The sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery. */
protected ProductsDescriptionCQ _productsId_ExistsSubQuery_ProductsDescriptionList;
@@ -933,7 +965,7 @@
if (baseQuery.hasConditionQueryManufacturers()) {
unionQuery.queryManufacturers().reflectRelationOnUnionQuery(baseQuery.queryManufacturers(), unionQuery.queryManufacturers());
}
-
+
}
// ===================================================================================
@@ -1005,5 +1037,5 @@
return _conditionQueryManufacturers != null;
}
-
+
}
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersCIQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersCIQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -74,7 +74,16 @@
return _myCQ.getOrdersId();
}
-
+
+ public void keepOrdersId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _myCQ.keepOrdersId_InScopeSubQuery_OrdersProductsList(subQuery);
+ }
+
+ public void keepOrdersId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepOrdersId_ExistsSubQuery_OrdersProductsList(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [CUSTOMERS_ID]
// - - - - - - - - -/
@@ -372,13 +381,17 @@
// /- - - - - - - - - - - - - - - - - - - - - - -
- // Column = [ORDERS_STATUS]
+ // Column = [ORDERS_STATUS_ID]
// - - - - - - - - -/
- protected ConditionValue getCValueOrdersStatus() {
- return _myCQ.getOrdersStatus();
+ protected ConditionValue getCValueOrdersStatusId() {
+ return _myCQ.getOrdersStatusId();
}
-
+
+ public void keepOrdersStatusId_InScopeSubQuery_OrdersStatus(OrdersStatusCQ subQuery) {
+ _myCQ.keepOrdersStatusId_InScopeSubQuery_OrdersStatus(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [ORDERS_DATE_FINISHED]
// - - - - - - - - -/
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersProductsCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersProductsCIQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersProductsCIQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -82,7 +82,11 @@
return _myCQ.getOrdersId();
}
-
+
+ public void keepOrdersId_InScopeSubQuery_Orders(OrdersCQ subQuery) {
+ _myCQ.keepOrdersId_InScopeSubQuery_Orders(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [PRODUCTS_ID]
// - - - - - - - - -/
@@ -90,7 +94,11 @@
return _myCQ.getProductsId();
}
-
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_Products(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [PRODUCTS_MODEL]
// - - - - - - - - -/
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersStatusCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersStatusCIQ.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrdersStatusCIQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -74,7 +74,16 @@
return _myCQ.getOrdersStatusId();
}
-
+
+ public void keepOrdersStatusId_InScopeSubQuery_OrdersList(OrdersCQ subQuery) {
+ _myCQ.keepOrdersStatusId_InScopeSubQuery_OrdersList(subQuery);
+ }
+
+ public void keepOrdersStatusId_ExistsSubQuery_OrdersList(OrdersCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepOrdersStatusId_ExistsSubQuery_OrdersList(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [LANGUAGE_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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -75,6 +75,10 @@
}
+ public void keepProductsId_InScopeSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_OrdersProductsList(subQuery);
+ }
+
public void keepProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
_myCQ.keepProductsId_InScopeSubQuery_ProductsDescriptionList(subQuery);
}
@@ -83,6 +87,11 @@
_myCQ.keepProductsId_InScopeSubQuery_ProductsToCategoriesList(subQuery);
}
+ public void keepProductsId_ExistsSubQuery_OrdersProductsList(OrdersProductsCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepProductsId_ExistsSubQuery_OrdersProductsList(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/OrdersNss.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersNss.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersNss.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -52,6 +52,27 @@
// With...
// =======
+ /** Is select ordersStatus? */
+ protected boolean _isSelectOrdersStatus;
+
+ /**
+ * Is select ordersStatus?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectOrdersStatus() {
+ return _isSelectOrdersStatus;
+ }
+
+ /**
+ * Set up select with ordersStatus.
+ */
+ public void withOrdersStatus() {
+ assertConditionQuery();
+ _query.queryOrdersStatus();
+ _isSelectOrdersStatus = true;
+ }
+
// ===================================================================================
// Helper
// ======
Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersProductsNss.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersProductsNss.java 2007-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/OrdersProductsNss.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -52,6 +52,48 @@
// With...
// =======
+ /** Is select orders? */
+ protected boolean _isSelectOrders;
+
+ /**
+ * Is select orders?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectOrders() {
+ return _isSelectOrders;
+ }
+
+ /**
+ * Set up select with orders.
+ */
+ public void withOrders() {
+ assertConditionQuery();
+ _query.queryOrders();
+ _isSelectOrders = true;
+ }
+
+ /** 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-07-27 18:43:53 UTC (rev 396)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java 2007-07-27 18:46:33 UTC (rev 397)
@@ -72,7 +72,7 @@
_query.queryManufacturers();
_isSelectManufacturers = true;
}
-
+
// ===================================================================================
// Helper
// ======