Author: jleroux
Date: Tue Sep 10 19:08:29 2013
New Revision: 1521589

URL: http://svn.apache.org/r1521589
Log:
For "Order Report Issue" https://issues.apache.org/jira/browse/OFBIZ-5297

The quickInitDataWarehouse BI button used these dates (set in BI main screen)

<set field="fromDate" value="2008-01-01 00:00:00.0" type="Timestamp"/>
<set field="thruDate" value="2010-01-01 00:00:00.0" type="Timestamp"/>

This generated 1000+ records. I set 10 years ahead (from sept. 2013) in a new 
bi.properties file used by the BI main screen. So it generates only 3000+ 
records (and others related in BI DB) which is still reasonable. A message, 
placed at the top of the Order Reports page, informs users that for 4 Birt 
reports s/he needs 1st to run the data warehouse init using the BI button. Also 
this message clarifies the range, to be certain that in 10 years people will 
still easily know what to change...

I have also replaced a lot of labels and added English and French translations 
(by-product: some labels cleaning in CommonUiLabels.xml)

I did not do the same for the accounting paymentReport and 
ViewFacilityInventoryHistoryReport facility Birt reports which only need 
translation. 
I noticed that there are no ways to get to ViewFacilityInventoryHistoryReport 
from UI though!

Added:
    ofbiz/trunk/framework/bi/config/bi.properties   (with props)
Modified:
    ofbiz/trunk/applications/order/widget/ordermgr/ReportScreens.xml
    ofbiz/trunk/framework/bi/widget/BiScreens.xml
    ofbiz/trunk/framework/common/config/CommonUiLabels.xml
    ofbiz/trunk/specialpurpose/birt/config/BirtUiLabels.xml
    
ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/OrdersByChannel.rptdesign
    ofbiz/trunk/specialpurpose/birt/widget/order/OrderForms.xml
    ofbiz/trunk/specialpurpose/birt/widget/order/OrderScreens.xml

Modified: ofbiz/trunk/applications/order/widget/ordermgr/ReportScreens.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/widget/ordermgr/ReportScreens.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/applications/order/widget/ordermgr/ReportScreens.xml (original)
+++ ofbiz/trunk/applications/order/widget/ordermgr/ReportScreens.xml Tue Sep 10 
19:08:29 2013
@@ -26,10 +26,12 @@ under the License.
             <actions>
                 <set field="titleProperty" value="OrderReports"/>
                 <set field="headerItem" value="reports"/>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>
             </actions>
             <widgets>
                 <decorator-screen name="main-decorator" 
location="${parameters.mainDecoratorLocation}">
                     <decorator-section name="body">
+                        <label 
style="h3">${uiLabelMap.BirtOrderReportsWarning}</label>
                         <include-portal-page id="OrderReportPage"/>
                     </decorator-section>
                 </decorator-screen>

Added: ofbiz/trunk/framework/bi/config/bi.properties
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/framework/bi/config/bi.properties?rev=1521589&view=auto
==============================================================================
--- ofbiz/trunk/framework/bi/config/bi.properties (added)
+++ ofbiz/trunk/framework/bi/config/bi.properties Tue Sep 10 19:08:29 2013
@@ -0,0 +1,2 @@
+fromDate=2013-09-01
+thruDate=2023-09-01
\ No newline at end of file

Propchange: ofbiz/trunk/framework/bi/config/bi.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: ofbiz/trunk/framework/bi/config/bi.properties
------------------------------------------------------------------------------
    svn:keywords = Date Rev Author URL Id

Propchange: ofbiz/trunk/framework/bi/config/bi.properties
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Modified: ofbiz/trunk/framework/bi/widget/BiScreens.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/framework/bi/widget/BiScreens.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/framework/bi/widget/BiScreens.xml (original)
+++ ofbiz/trunk/framework/bi/widget/BiScreens.xml Tue Sep 10 19:08:29 2013
@@ -102,12 +102,15 @@ under the License.
             <actions>
                 <set field="titleProperty" 
value="BusinessIntelligenceMainPage"/>
                 <set field="headerItem" value="main"/>
-                <set field="fromDate" value="2008-01-01 00:00:00.0" 
type="Timestamp"/>
-                <set field="thruDate" value="2010-01-01 00:00:00.0" 
type="Timestamp"/>
+                <property-to-field resource="bi" property="fromDate" 
field="fromDateProp" no-locale="true"/>
+                <property-to-field resource="bi" property="thruDate" 
field="thruDateProp" no-locale="true"/>
+                <set field="fromDate" from-field="fromDateProp" 
type="Timestamp"/>
+                <set field="thruDate" from-field="thruDateProp" 
type="Timestamp"/>
             </actions>
             <widgets>
                 <decorator-screen name="main-decorator" 
location="${parameters.mainDecoratorLocation}">
                     <decorator-section name="body">
+                <label>fromDateProp = ${fromDateProp}</label>
                         <screenlet>
                             <container>
                                 <platform-specific>

Modified: ofbiz/trunk/framework/common/config/CommonUiLabels.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/config/CommonUiLabels.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/framework/common/config/CommonUiLabels.xml (original)
+++ ofbiz/trunk/framework/common/config/CommonUiLabels.xml Tue Sep 10 19:08:29 
2013
@@ -7100,7 +7100,7 @@
         <value xml:lang="zh">没有省: _NA_</value>
     </property>
     <property key="CommonNoStatesProvincesExists">
-       <value xml:lang="cs">Žádný Kraj/Samosprávný celek 
neexistuje</value>
+        <value xml:lang="cs">Žádný Kraj/Samosprávný celek 
neexistuje</value>
         <value xml:lang="de">Es existiert kein Bundesland</value>
         <value xml:lang="en">No States/Provinces exist</value>
         <value xml:lang="es">No existen provincias</value>
@@ -12251,6 +12251,10 @@
         <value xml:lang="zh-CN">星期</value>
         <value xml:lang="zh-TW">星期</value>
     </property>
+    <property key="CommonWeeks">
+        <value xml:lang="en">Weeks</value>
+        <value xml:lang="fr">Semaines</value>
+    </property>
     <property key="CommonWeekly">
         <value xml:lang="ar">أسبوعيا</value>
         <value xml:lang="cs">Týdně</value>
@@ -13772,7 +13776,7 @@
         <value xml:lang="zh">币值</value>
         <value xml:lang="zh-TW">幣別</value>
     </property>
-    <property key="FormFieldTitle_updateButton">               
+    <property key="FormFieldTitle_updateButton">
         <value xml:lang="ar">تحديث</value>
         <value xml:lang="cs">Obnovit</value>
         <value xml:lang="de">Aktualisieren</value>

Modified: ofbiz/trunk/specialpurpose/birt/config/BirtUiLabels.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/birt/config/BirtUiLabels.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/specialpurpose/birt/config/BirtUiLabels.xml (original)
+++ ofbiz/trunk/specialpurpose/birt/config/BirtUiLabels.xml Tue Sep 10 19:08:29 
2013
@@ -37,14 +37,59 @@
         <value xml:lang="ja">Eclipse BIRT 業務</value>
         <value xml:lang="th">Eclipse BIRT Application</value>
         <value xml:lang="zh">Eclipse BIRT应用程序</value>
-    </property>
-    <property key="FrameworkBirt">
-        <value xml:lang="en">Framework Eclipse BIRT</value>
-        <value xml:lang="ja">Eclipse BIRT フレームワーク</value>
-        <value xml:lang="th">Framework Eclipse BIRT</value>
-        <value xml:lang="zh">Eclipse BIRT框架</value>
-    </property>
-
+    </property>    
+    <property key="BirtOrderReportAllReferrer">
+        <value xml:lang="en">All Referrer</value>
+        <value xml:lang="fr">Tous apporteurs d'affaires</value>
+    </property>    
+    <property key="BirtOrderReportAllOrderItemsWithDiscountCode">
+        <value xml:lang="en">All order items with discount code</value>
+        <value xml:lang="fr">Tous les lignes de commandes ayant des codes 
promotionels</value>
+    </property>        
+    <property key="BirtOrderReportCouponSalesReport">
+        <value xml:lang="en">Coupon Sales Report</value>
+        <value xml:lang="fr">Ventes promotionelles</value>
+    </property>    
+    <property key="BirtOrderReportFormatType">
+        <value xml:lang="en">Format Type</value>
+        <value xml:lang="fr">Format : </value>
+    </property>        
+    <property key="BirtOrderReportLast3MonthsSalesReport">
+        <value xml:lang="en">Last 3 Months Sales Report</value>
+        <value xml:lang="fr">Ventes des 3 derniers mois</value>
+    </property>
+    <property key="BirtOrderReportNetBeforeOverheadReport">
+        <value xml:lang="en">Net Before Overhead Report</value>
+        <value xml:lang="fr">Net avant frais généraux</value>
+    </property>
+    <property key="BirtOrderReportOrderByReferrer">
+        <value xml:lang="en">Order By Referrer</value>
+        <value xml:lang="fr">Commandes par apporteurs d'affaires</value>
+    </property>
+    <property key="BirtOrderReportProductDemandReport">
+        <value xml:lang="en">Product Demand Report</value>
+        <value xml:lang="fr">Demandes par produit</value>
+    </property>
+    <property key="BirtOrderReportReportBy">
+        <value xml:lang="en">Report By</value>
+        <value xml:lang="fr">Par : </value>
+    </property>
+    <property key="BirtOrderReportSalesReport">
+        <value xml:lang="en">Sales Report</value>
+        <value xml:lang="fr">Ventes depuis :</value>
+    </property>
+    <property key="BirtOrderReportSaleOrderDiscountCode">
+        <value xml:lang="en">Sales Order Discount Code</value>
+        <value xml:lang="fr">Ventes par codes promotionels</value>
+    </property>
+    <property key="BirtOrderReportSaleOrdersByChannel">
+        <value xml:lang="en">Sale Orders By Channel</value>
+        <value xml:lang="fr">Ventes par canaux</value>
+    </property>
+    <property key="BirtOrderReportsWarning">
+        <value xml:lang="en">Four Birt reports (Last 3 Months Sales, Sales, 
Sales Order Discount Code, Product Demand) require to feed the BI data base 
(note that the bi.properties file will need to be updated after September 
2023). Then only new approved orders will be taken into account</value>
+        <value xml:lang="fr">Quatre tableau créés par Birt (Ventes des 3 
derniers mois, Ventes, Ventes par codes promotionels, Demandes par produit) 
nécessitent d'alimenter la base de données d'Inform. décis. (notez aussi la 
màj du fichier bi.properties nécessaire après septembre 2023). Seulemnt 
ensuite les commandes approuvées seront prises en compte.</value>
+    </property>    
     <property key="ExampleBirtExamples">
         <value xml:lang="en">BIRT Examples</value>
         <value xml:lang="ja">BIRT サンプル</value>

Modified: 
ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/OrdersByChannel.rptdesign
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/OrdersByChannel.rptdesign?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- 
ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/OrdersByChannel.rptdesign
 (original)
+++ 
ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/OrdersByChannel.rptdesign
 Tue Sep 10 19:08:29 2013
@@ -464,7 +464,7 @@ return true;]]></method>
             <property name="fontWeight">bolder</property>
             <property name="textAlign">center</property>
             <property name="contentType">auto</property>
-            <text-property name="content"><![CDATA[Orders By Sale 
Channel]]></text-property>
+            <text-property name="content"><![CDATA[Orders By Sales 
Channel]]></text-property>
         </text>
         <text id="577"/>
         <extended-item extensionName="Crosstab" extensionVersion="2.5.0" 
id="634">

Modified: ofbiz/trunk/specialpurpose/birt/widget/order/OrderForms.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/birt/widget/order/OrderForms.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/specialpurpose/birt/widget/order/OrderForms.xml (original)
+++ ofbiz/trunk/specialpurpose/birt/widget/order/OrderForms.xml Tue Sep 10 
19:08:29 2013
@@ -26,14 +26,14 @@ under the License.
     <form name="SalesReport" type="single" target="checkReportBy" title=""
           header-row-style="header-row" default-table-style="basic-table" 
target-window="_BLANK">
         <field name="fromDate" title="${uiLabelMap.CommonFromDate}"><date-time 
type="date"/></field>
-        <field name="reportBy" title="Report By">
+        <field name="reportBy" title="${uiLabelMap.BirtOrderReportReportBy}">
             <drop-down>
-                <option key="day" description="Days"></option>
-                <option key="week" description="Weeks"></option>
-                <option key="month" description="Months"></option>
+                <option key="day" 
description="${uiLabelMap.CommonDays}"></option>
+                <option key="week" 
description="${uiLabelMap.CommonWeeks}"></option>
+                <option key="month" 
description="${uiLabelMap.CommonMonths}"></option>
             </drop-down>
         </field>
-        <field name="exportType" title="Format Type">
+        <field name="exportType" 
title="${uiLabelMap.BirtOrderReportFormatType}">
             <drop-down>
                 <option key="pdf" description="PDF"></option>
                 <option key="excel" description="Excel"></option>
@@ -71,11 +71,11 @@ under the License.
 
     <form name="OrderByReferrer" type="single" target="OrderByReferrer.pdf" 
target-window="_BLANK">
         <!--field name="referrerUrl"><text-find 
default-option="contains"/></field-->
-        <field name="referrerUrl" title=" "><display description="All 
Referrer"></display></field>
+        <field name="referrerUrl" title=" "><display 
description="${uiLabelMap.BirtOrderReportAllReferrer}"></display></field>
         <field name="submit" title="${uiLabelMap.CommonRun}"><submit 
button-type="button"/></field>
     </form>
     <form name="SaleOrdersByChannel" type="single" 
target="OrdersByChannel.pdf" target-window="_BLANK">
-        <field name="saleChannel">
+        <field name="SalesChannel" title="${uiLabelMap.OrderSalesChannel}">
             <drop-down allow-empty="false">
                 <option key="" description="- ${uiLabelMap.CommonSelectAny} 
-"/>
                 <entity-options description="${description}" 
entity-name="Enumeration" key-field-name="description">
@@ -86,7 +86,7 @@ under the License.
         <field name="submit" title="${uiLabelMap.CommonRun}"><submit 
button-type="button"/></field>
     </form>
     <form name="SaleOrderDiscountCode" type="single" 
target="OrderDiscountCode.pdf" target-window="_BLANK">
-        <field name="discountCodeUrl" title=" "><display description="All 
order items with discount code"></display></field>
+        <field name="discountCodeUrl" title=" "><display 
description="${uiLabelMap.BirtOrderReportAllOrderItemsWithDiscountCode}"></display></field>
         <field name="submit" title="${uiLabelMap.CommonRun}"><submit 
button-type="button"/></field>
     </form>
     <form name="Last3MonthsSalesReport" type="single" 
target="Last3MonthsSalesReport.pdf" target-window="_BLANK">

Modified: ofbiz/trunk/specialpurpose/birt/widget/order/OrderScreens.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/birt/widget/order/OrderScreens.xml?rev=1521589&r1=1521588&r2=1521589&view=diff
==============================================================================
--- ofbiz/trunk/specialpurpose/birt/widget/order/OrderScreens.xml (original)
+++ ofbiz/trunk/specialpurpose/birt/widget/order/OrderScreens.xml Tue Sep 10 
19:08:29 2013
@@ -27,9 +27,10 @@ under the License.
         <section>
             <actions>
                 <property-map resource="OrderUiLabels" map-name="uiLabelMap" 
global="true"/>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
             </actions>
             <widgets>
-                <screenlet title="Sales Report">
+                <screenlet title="${uiLabelMap.BirtOrderReportSalesReport}">
                     <include-form name="SalesReport" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -40,9 +41,10 @@ under the License.
         <section>
             <actions>
                 <property-map resource="ProductUiLabels" map-name="uiLabelMap" 
global="true"/>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
             </actions>
             <widgets>
-                <screenlet title="Net Before Overhead Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportNetBeforeOverheadReport}">
                     <include-form name="NetBeforeOverheadReport" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -53,19 +55,23 @@ under the License.
         <section>
             <actions>
                 <property-map resource="ProductUiLabels" map-name="uiLabelMap" 
global="true"/>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
             </actions>
             <widgets>
-                <screenlet title="Product Demand Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportProductDemandReport}">
                     <include-form name="ProductDemandReport" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
         </section>
     </screen>
     <!-- Sale Order By Referrer -->
-    <screen name="SaleOrdersByReferrerReport">
+    <screen name="SaleOrdersByReferrerReport">        
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <screenlet title="Sale Orders by Referrer Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportOrderByReferrer}">
                     <include-form name="OrderByReferrer" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -74,8 +80,12 @@ under the License.
     <!-- Sale Order By Channel -->
     <screen name="SaleOrdersByChannelReport">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>
+                <property-map resource="OrderUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <screenlet title="Sale Orders By Channel Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportSaleOrdersByChannel}">
                     <include-form name="SaleOrdersByChannel" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -84,8 +94,11 @@ under the License.
     <!-- Sale Order with Discount Code -->
     <screen name="SaleOrderDiscountCodeReport">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <screenlet title="Sale Orders Discount Code Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportSaleOrderDiscountCode}">
                     <include-form name="SaleOrderDiscountCode" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -94,8 +107,11 @@ under the License.
     <!-- Last Three Months Sales Report -->
     <screen name="Last3MonthsSalesReport">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <screenlet title="Last Three Months Sales Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportLast3MonthsSalesReport}">
                     <include-form name="Last3MonthsSalesReport" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
@@ -104,20 +120,21 @@ under the License.
     <!-- Coupon Sales Report -->
     <screen name="CouponSalesReport">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <screenlet title="Coupon Sales Report">
+                <screenlet 
title="${uiLabelMap.BirtOrderReportCouponSalesReport}">
                     <include-form name="CouponSalesReport" 
location="component://birt/widget/order/OrderForms.xml"/>
                 </screenlet>
             </widgets>
         </section>
     </screen>
 
-
-
-
     <screen name="SalesOrderReport">
         <section>
             <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
                 <entity-condition entity-name="SalesOrderItemStarSchema" 
list="SalesReportList">
                     <condition-list combine="and">
                         <condition-expr field-name="orderDate" 
operator="greater-equals" from-field="parameters.fromOrderDate" 
ignore-if-empty="true"/>
@@ -126,29 +143,41 @@ under the License.
                 </entity-condition>
             </actions>
             <widgets>
-                <platform-specific>
-                    <xml><html-template 
location="component://order/webapp/ordermgr/reports/SalesReport.rptdesign"/></xml>
-                </platform-specific>
+                <screenlet title="${uiLabelMap.BirtOrderReportSalesReport}">   
             
+                    <platform-specific>
+                        <xml><html-template 
location="component://order/webapp/ordermgr/reports/SalesReport.rptdesign"/></xml>
+                    </platform-specific>
+                </screenlet>
             </widgets>
         </section>
     </screen>
 
     <screen name="NetBeforeOverheadOrderReport">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <platform-specific>
-                    <xml><html-template 
location="component://order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign"/></xml>
-                </platform-specific>
+                <screenlet 
title="${uiLabelMap.BirtOrderReportNetBeforeOverheadReport}">
+                    <platform-specific>
+                        <xml><html-template 
location="component://order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign"/></xml>
+                    </platform-specific>
+                </screenlet>
             </widgets>
         </section>
     </screen>
 
     <screen name="ProductDemandOrderReport ">
         <section>
+            <actions>
+                <property-map resource="BirtUiLabels" map-name="uiLabelMap" 
global="true"/>                
+            </actions>
             <widgets>
-                <platform-specific>
-                    <xml><html-template 
location="component://order/webapp/ordermgr/reports/ProductDemandReport.rptdesign"/></xml>
-                </platform-specific>
+                <screenlet 
title="${uiLabelMap.BirtOrderReportProductDemandReport}">
+                    <platform-specific>
+                        <xml><html-template 
location="component://order/webapp/ordermgr/reports/ProductDemandReport.rptdesign"/></xml>
+                    </platform-specific>
+                </screenlet>
             </widgets>
         </section>
     </screen>


Reply via email to