Author: arunpatidar
Date: Tue Jun 21 15:04:49 2016
New Revision: 1749552
URL:
http://svn.apache.org/viewvc?rev=1749552&view=revLog:
Applied patch from ticket OFBIZ-7314:'Last 3 Months Sales Report is not working'. Thanks Rohit Koushal for your contribution.
Modified:
ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/Last3MonthsSalesReport.rptdesign
Modified: ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/Last3MonthsSalesReport.rptdesign
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/Last3MonthsSalesReport.rptdesign?rev=1749552&r1=1749551&r2=1749552&view=diff==============================================================================
--- ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/Last3MonthsSalesReport.rptdesign (original)
+++ ofbiz/trunk/specialpurpose/birt/webapp/ordermgr/reports/Last3MonthsSalesReport.rptdesign Tue Jun 21 15:04:49 2016
@@ -215,7 +215,7 @@ module = "Last3MonthsSalesReport.rptdesi
<method name="open"><![CDATA[salesOrderItemStarSchemas = null;
userLogin = null;
try {
- userLogin = delegator.findByPrimaryKey("UserLogin",UtilMisc.toMap("userLoginId","admin"));
+ userLogin = delegator.findOne("UserLogin",UtilMisc.toMap("userLoginId","admin"), false);
months = new LinkedList();
thisMonth = 0;
thisMonth = UtilDateTime.getMonth(UtilDateTime.nowTimestamp(), TimeZone.getDefault(), Locale.getDefault())+1;
@@ -278,7 +278,7 @@ if (salesOrderItemStarSchemas) {
totalRow = salesOrderItemStarSchemas.size();
}
]]></method>
- <method name="fetch"><![CDATA[if (countOfRow == totalRow - 1) return false;
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
salesOrderItemStarSchema = salesOrderItemStarSchemas.get(countOfRow);
input = new HashMap();
input.put("productId", salesOrderItemStarSchema.getString("productProductId"));
@@ -297,7 +297,7 @@ price = 0;
internalName = "None";
input = new HashMap();
try {
- product = delegator.findByPrimaryKey("Product",UtilMisc.toMap("productId", salesOrderItemStarSchema.getString("productProductId")));
+ product = delegator.findOne("Product",UtilMisc.toMap("productId", salesOrderItemStarSchema.getString("productProductId")), false);
if(product!=null){
input.put("product", product);
input.put("userLogin", userLogin);