You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jo...@apache.org on 2007/02/06 23:21:03 UTC

svn commit: r504333 - in /ofbiz/trunk/applications/product: data/ProductTypeData.xml entitydef/entitygroup.xml entitydef/entitymodel.xml

Author: jonesde
Date: Tue Feb  6 14:21:02 2007
New Revision: 504333

URL: http://svn.apache.org/viewvc?view=rev&rev=504333
Log:
Added ProductCategoryLink entity and supporting seed data

Modified:
    ofbiz/trunk/applications/product/data/ProductTypeData.xml
    ofbiz/trunk/applications/product/entitydef/entitygroup.xml
    ofbiz/trunk/applications/product/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/product/data/ProductTypeData.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/data/ProductTypeData.xml?view=diff&rev=504333&r1=504332&r2=504333
==============================================================================
--- ofbiz/trunk/applications/product/data/ProductTypeData.xml (original)
+++ ofbiz/trunk/applications/product/data/ProductTypeData.xml Tue Feb  6 14:21:02 2007
@@ -34,8 +34,6 @@
 
     <EnumerationType description="Product Price Parent Enum Type" enumTypeId="PROD_PRICE" hasTable="N" parentTypeId=""/>
     <EnumerationType description="Product Price Input Parameter" enumTypeId="PROD_PRICE_IN_PARAM" hasTable="N" parentTypeId="PROD_PRICE"/>
-    <EnumerationType description="Product Price Condition" enumTypeId="PROD_PRICE_COND" hasTable="N" parentTypeId="PROD_PRICE"/>
-
     <Enumeration description="Product" enumCode="PRODUCT_ID" enumId="PRIP_PRODUCT_ID" sequenceId="01" enumTypeId="PROD_PRICE_IN_PARAM"/>
     <Enumeration description="Product Category" enumCode="PRODUCT_CATEGORY_ID" enumId="PRIP_PROD_CAT_ID" sequenceId="02" enumTypeId="PROD_PRICE_IN_PARAM"/>
     <Enumeration description="Product Catalog" enumCode="PROD_CATALOG_ID" enumId="PRIP_PROD_CLG_ID" sequenceId="03" enumTypeId="PROD_PRICE_IN_PARAM"/>
@@ -59,6 +57,7 @@
     <Enumeration description="&gt;=" enumCode="GTE" enumId="PRC_GTE" sequenceId="06" enumTypeId="PROD_PRICE_COND"/>
     ... new style below less technical -->
 
+    <EnumerationType description="Product Price Condition" enumTypeId="PROD_PRICE_COND" hasTable="N" parentTypeId="PROD_PRICE"/>
     <Enumeration description="Is" enumCode="EQ" enumId="PRC_EQ" sequenceId="01" enumTypeId="PROD_PRICE_COND"/>
     <Enumeration description="Is Not" enumCode="NEQ" enumId="PRC_NEQ" sequenceId="02" enumTypeId="PROD_PRICE_COND"/>
     <Enumeration description="Is Less Than" enumCode="LT" enumId="PRC_LT" sequenceId="03" enumTypeId="PROD_PRICE_COND"/>
@@ -110,6 +109,10 @@
     <Enumeration description="OFBiz URL" enumCode="OFBURL" enumId="KOTT_OFBURL" enumTypeId="KWOVRD_TRGT_TYPE" sequenceId="03"/>
     <Enumeration description="Absolute URL" enumCode="AURL" enumId="KOTT_AURL" enumTypeId="KWOVRD_TRGT_TYPE" sequenceId="04"/>
 
+    <EnumerationType description="Product Category Link Type" enumTypeId="PCAT_LINK_TYPE" hasTable="N" parentTypeId=""/>
+    <Enumeration description="Search Parameters" enumCode="SEARCH_PARAM" enumId="PCLT_SEARCH_PARAM" sequenceId="01" enumTypeId="PCAT_LINK_TYPE"/>
+    <Enumeration description="Absolute URL" enumCode="ABS_URL" enumId="PCLT_ABS_URL" sequenceId="02" enumTypeId="PCAT_LINK_TYPE"/>
+    
     <FacilityType description="Building" facilityTypeId="BUILDING" hasTable="N" parentTypeId=""/>
     <FacilityType description="Floor" facilityTypeId="FLOOR" hasTable="N" parentTypeId=""/>
     <FacilityType description="Office" facilityTypeId="OFFICE" hasTable="N" parentTypeId=""/>

Modified: ofbiz/trunk/applications/product/entitydef/entitygroup.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitygroup.xml?view=diff&rev=504333&r1=504332&r2=504333
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitygroup.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitygroup.xml Tue Feb  6 14:21:02 2007
@@ -42,6 +42,7 @@
     <entity-group group="org.ofbiz" entity="ProductCategoryContent" />
     <entity-group group="org.ofbiz" entity="ProductCategoryContentAndInfo" />
     <entity-group group="org.ofbiz" entity="ProductCategoryContentType" />
+    <entity-group group="org.ofbiz" entity="ProductCategoryLink" />
     <entity-group group="org.ofbiz" entity="ProductCategoryMember" />
     <entity-group group="org.ofbiz" entity="ProductCategoryMemberAndRole" />
     <entity-group group="org.ofbiz" entity="ProductCategoryRole" />

Modified: ofbiz/trunk/applications/product/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitymodel.xml?view=diff&rev=504333&r1=504332&r2=504333
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitymodel.xml Tue Feb  6 14:21:02 2007
@@ -309,25 +309,50 @@
         <key-map field-name="parentTypeId" rel-field-name="prodCatContentTypeId"/>
       </relation>
     </entity>
+    <entity entity-name="ProductCategoryLink"
+        package-name="org.ofbiz.product.category"
+        title="Product Category Link Entity">
+        <field name="productCategoryId" type="id-ne"></field>
+        <field name="linkSeqId" type="id-ne"></field>
+        <field name="fromDate" type="date-time"></field>
+        <field name="thruDate" type="date-time"></field>
+        <field name="comments" type="comment"><description>Internal comments, not for public display.</description></field>
+        <field name="sequenceNum" type="numeric"><description>This field is used to sort the links. The linkSeqId field is not used because it is part of the primary key and cannot be changed.</description></field>
+        <field name="titleText" type="description"></field>
+        <field name="detailText" type="very-long"></field>
+        <field name="imageUrl" type="description"></field>
+        <field name="linkTypeEnumId" type="id"></field>
+        <field name="linkInfo" type="long-varchar"></field>
+        <field name="detailSubScreen" type="long-varchar"><description>This is optional. If not specified a default should be used by the category detail template.</description></field>
+        <prim-key field="productCategoryId"/>
+        <prim-key field="linkSeqId"/>
+        <prim-key field="fromDate"/>
+        <relation type="one" fk-name="PROD_CLNK_CATEGORY" rel-entity-name="ProductCategory">
+            <key-map field-name="productCategoryId"/>
+        </relation>
+        <relation type="one" fk-name="PROD_CLNK_LKTPENM" title="LinkType" rel-entity-name="Enumeration">
+            <key-map field-name="linkTypeEnumId" rel-field-name="enumId"/>
+        </relation>
+    </entity>
     <entity entity-name="ProductCategoryMember"
-            package-name="org.ofbiz.product.category"
-            title="Product Category Member Entity">
-      <field name="productCategoryId" type="id-ne"></field>
-      <field name="productId" type="id-ne"></field>
-      <field name="fromDate" type="date-time"></field>
-      <field name="thruDate" type="date-time"></field>
-      <field name="comments" type="comment"></field>
-      <field name="sequenceNum" type="numeric"></field>
-      <field name="quantity" type="floating-point"></field>
-      <prim-key field="productCategoryId"/>
-      <prim-key field="productId"/>
-      <prim-key field="fromDate"/>
-      <relation type="one" fk-name="PROD_CMBR_PRODUCT" rel-entity-name="Product">
-        <key-map field-name="productId"/>
-      </relation>
-      <relation type="one" fk-name="PROD_CMBR_CATEGORY" rel-entity-name="ProductCategory">
-        <key-map field-name="productCategoryId"/>
-      </relation>
+        package-name="org.ofbiz.product.category"
+        title="Product Category Member Entity">
+        <field name="productCategoryId" type="id-ne"></field>
+        <field name="productId" type="id-ne"></field>
+        <field name="fromDate" type="date-time"></field>
+        <field name="thruDate" type="date-time"></field>
+        <field name="comments" type="comment"></field>
+        <field name="sequenceNum" type="numeric"></field>
+        <field name="quantity" type="floating-point"></field>
+        <prim-key field="productCategoryId"/>
+        <prim-key field="productId"/>
+        <prim-key field="fromDate"/>
+        <relation type="one" fk-name="PROD_CMBR_PRODUCT" rel-entity-name="Product">
+            <key-map field-name="productId"/>
+        </relation>
+        <relation type="one" fk-name="PROD_CMBR_CATEGORY" rel-entity-name="ProductCategory">
+            <key-map field-name="productCategoryId"/>
+        </relation>
     </entity>
     <view-entity entity-name="ProductCategoryMemberAndRole"
             package-name="org.ofbiz.product.category"