0022762: Balance Sheet and P/L Structure Report does not filter by readable organizations

diff -r 26a81bd13b91 src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
--- a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java	Mon Dec 24 14:06:41 2012 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java	Thu Jan 10 10:45:46 2013 +0100
@@ -29,6 +29,8 @@
 
 import org.openbravo.base.secureApp.HttpSecureAppServlet;
 import org.openbravo.base.secureApp.VariablesSecureApp;
+import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBDal;
 import org.openbravo.erpCommon.businessUtility.AccountTree;
 import org.openbravo.erpCommon.businessUtility.AccountTreeData;
 import org.openbravo.erpCommon.businessUtility.AccountingSchemaMiscData;
@@ -42,6 +44,7 @@
 import org.openbravo.erpCommon.utility.ToolBar;
 import org.openbravo.erpCommon.utility.Utility;
 import org.openbravo.erpCommon.utility.WindowTreeData;
+import org.openbravo.model.ad.access.Role;
 import org.openbravo.xmlEngine.XmlDocument;
 
 public class GeneralAccountingReports extends HttpSecureAppServlet {
@@ -450,10 +453,24 @@
     } catch (Exception ex) {
       throw new ServletException(ex);
     }
+    
+    String strOrgList = "";
+    String[] orgList = OBContext.getOBContext().getReadableOrganizations();
+    int i = 0;
+    for (String org : orgList ){
+    	if(i==0){
+        	strOrgList += "'"+org+"'";
+    	}
+    	else{
+    		strOrgList += ",'"+org+"'";
+    	}
+    	i++;
+    }
+    
     xmlDocument.setParameter(
         "orgs",
         Utility.arrayDobleEntrada("arrOrgs",
-            GeneralAccountingReportsData.selectOrgsDouble(this, vars.getClient())));
+            GeneralAccountingReportsData.selectOrgsDouble(this, vars.getClient(), strOrgList)));
     xmlDocument.setParameter(
         "accountingReports",
         Utility.arrayDobleEntrada("arrAccountingReports",
diff -r 26a81bd13b91 src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql	Mon Dec 24 14:06:41 2012 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql	Thu Jan 10 10:45:46 2013 +0100
@@ -278,6 +278,7 @@
         AND O.BALANCED = 'Y' 
         AND AD_ISORGINCLUDED(O.AD_ORG_ID, ORG.AD_ORG_ID, S.AD_CLIENT_ID) <> -1
         AND ORG.AD_ORG_ID <> '0'
+        AND ORG.AD_ORG_ID IN ('1')
       UNION
       SELECT S.C_ACCTSCHEMA_ID||R.C_ACCT_RPT_ID AS PADRE, O.AD_ORG_ID AS ID, O.NAME AS NAME
       FROM C_ACCT_RPT R, AD_ORG_ACCTSCHEMA S, (
@@ -295,10 +296,13 @@
         AND S.AD_CLIENT_ID = ?
         AND R.ISORGBALANCED = 'N' 
         AND COALESCE(R.REPORTTYPE,'N') = 'N'
+        AND O.AD_ORG_ID IN ('1')
       ORDER BY NAME,PADRE
         ]]></Sql>
         <Parameter name="adClient"/>
+        <Parameter name="adOrg" optional="false" type="replace" after="AND ORG.AD_ORG_ID IN (" text="'1'"/>
         <Parameter name="adClient"/>
+        <Parameter name="adOrg" optional="false" type="replace" after="AND O.AD_ORG_ID IN (" text="'1'"/>
    </SqlMethod>
    <SqlMethod name="selectYearsDouble" type="preparedStatement" return="multiple">
       <SqlMethodComment></SqlMethodComment>