details: https://code.openbravo.com/erp/devel/pi/rev/936644ddfc46
changeset: 30304:936644ddfc46
user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date: Tue Sep 20 11:26:27 2016 +0200
summary: Related to 34018: AdminMode in
AcctSchemaStructureProvider.getAcctSchemasFromDB
diffstat:
src/org/openbravo/dal/security/AcctSchemaStructureProvider.java | 25
++++++----
1 files changed, 15 insertions(+), 10 deletions(-)
diffs (35 lines):
diff -r 1c1111f45555 -r 936644ddfc46
src/org/openbravo/dal/security/AcctSchemaStructureProvider.java
--- a/src/org/openbravo/dal/security/AcctSchemaStructureProvider.java Tue Sep
20 09:37:30 2016 +0200
+++ b/src/org/openbravo/dal/security/AcctSchemaStructureProvider.java Tue Sep
20 11:26:27 2016 +0200
@@ -60,16 +60,21 @@
@SuppressWarnings("unchecked")
private ArrayList<String> getAcctSchemasFromDB(String orgId, String
clientID) {
- String where = " select a.id"
- + " from OrganizationAcctSchema as oas"
- + " join oas.accountingSchema as a"
- + " where oas.client.id = :clientId"
- + " and (ad_isorgincluded(:orgId, oas.organization.id, oas.client.id)
<> -1 or :orgId = '0')"
- + " and a.active = true" + " and oas.active = true" + " group by a.id";
+ try {
+ OBContext.setAdminMode(true);
+ String where = " select a.id"
+ + " from OrganizationAcctSchema as oas"
+ + " join oas.accountingSchema as a"
+ + " where oas.client.id = :clientId"
+ + " and (ad_isorgincluded(:orgId, oas.organization.id,
oas.client.id) <> -1 or :orgId = '0')"
+ + " and a.active = true" + " and oas.active = true" + " group by
a.id";
- final Query qry = OBDal.getInstance().getSession().createQuery(where);
- qry.setParameter("clientId", clientID);
- qry.setParameter("orgId", orgId);
- return (ArrayList<String>) qry.list();
+ final Query qry = OBDal.getInstance().getSession().createQuery(where);
+ qry.setParameter("clientId", clientID);
+ qry.setParameter("orgId", orgId);
+ return (ArrayList<String>) qry.list();
+ } finally {
+ OBContext.restorePreviousMode();
+ }
}
}
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
