details: https://code.openbravo.com/erp/devel/pi/rev/9b82d811c2b2
changeset: 15487:9b82d811c2b2
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Tue Feb 14 13:44:39 2012 +0100
summary: Fixes issue 19737: Payment Report does not take into account the
role you are logged with.
diffstat:
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
| 18 ++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diffs (33 lines):
diff -r f2585e9deaf5 -r 9b82d811c2b2
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
a/modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
Wed Feb 15 16:58:28 2012 +0100
+++
b/modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
Tue Feb 14 13:44:39 2012 +0100
@@ -128,6 +128,11 @@
hsqlScript.append(" is not null or invps is not null ");
hsqlScript.append(") ");
+ hsqlScript.append(" and fpsd.");
+ hsqlScript.append(FIN_PaymentScheduleDetail.PROPERTY_ORGANIZATION);
+ hsqlScript.append(".id in ");
+
hsqlScript.append(concatOrganizations(OBContext.getOBContext().getReadableOrganizations()));
+
// organization + include sub-organization
if (!strOrg.isEmpty()) {
if (!strInclSubOrg.equalsIgnoreCase("include")) {
@@ -1160,4 +1165,17 @@
}
return bp;
}
+
+ private String concatOrganizations(String[] orgs) {
+ String concatOrgs = "";
+ for (int i = 0; i < orgs.length; i++) {
+ concatOrgs = concatOrgs.concat("', '" + orgs[i]);
+ }
+ if (!concatOrgs.equalsIgnoreCase("")) {
+ concatOrgs = concatOrgs.substring(3);
+ concatOrgs = "(" + concatOrgs + "')";
+ }
+
+ return concatOrgs;
+ }
}
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
