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