[OFBiz] SVN: r6952 - trunk/applications/accounting/entitydef

[sichen@svn.ofbiz.org]

Author: sichen
Date: 2006-03-08 17:35:19 -0600 (Wed, 08 Mar 2006)
New Revision: 6952

Modified:
   trunk/applications/accounting/entitydef/entitymodel.xml
Log:
Changed the view we use to sum up accounting transaction amounts grouped by product so it allows selecting by transactionDate, grouping by account type (instead of accountId), and group by isPosted.

Modified: trunk/applications/accounting/entitydef/entitymodel.xml
===================================================================
--- trunk/applications/accounting/entitydef/entitymodel.xml	2006-03-08 22:37:16 UTC (rev 6951)
+++ trunk/applications/accounting/entitydef/entitymodel.xml	2006-03-08 23:35:19 UTC (rev 6952)
@@ -1087,11 +1087,21 @@
             package-name="org.ofbiz.accounting.ledger"
             title="Sum of AcctgTransEntry entity amounts, grouped by glAccountId, productId, debitCreditFlag">
       <member-entity entity-alias="ATE" entity-name="AcctgTransEntry"/>
+      <member-entity entity-alias="ACT" entity-name="AcctgTrans"/>
+      <member-entity entity-alias="GLA" entity-name="GlAccount"/>
       <alias entity-alias="ATE" name="organizationPartyId" group-by="true"/>
-      <alias entity-alias="ATE" name="glAccountId" group-by="true"/>
       <alias entity-alias="ATE" name="productId" group-by="true"/>
       <alias entity-alias="ATE" name="debitCreditFlag" group-by="true"/>
       <alias entity-alias="ATE" name="amount" function="sum"/>
+      <alias entity-alias="GLA" name="glAccountTypeId" group-by="true"/> <!-- so we can select by type of account -->
+      <alias entity-alias="ACT" name="isPosted" group-by="true"/>
+      <alias entity-alias="ACT" name="transactionDate" group-by="false"/> <!-- so we can select the sum by date -->
+      <view-link entity-alias="ATE" rel-entity-alias="GLA">
+        <key-map field-name="glAccountId"/>
+      </view-link>
+      <view-link entity-alias="ATE" rel-entity-alias="ACT">
+        <key-map field-name="acctgTransId"/>
+      </view-link>
     </view-entity>
     <entity entity-name="AcctgTransEntryType"
             package-name="org.ofbiz.accounting.ledger"