Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017970
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 01. General setupminoralways2011-07-12 14:412011-08-23 13:32
ReporterdalsasuaView Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionfixedFixed in Version2.50MP33
StatusclosedFix in branchFixed in SCM revisionc1a592b54b9d
ProjectionnoneETAnoneTarget Version2.50MP31
OSLinux 32 bitDatabaseOracleJava version1.6.0_21
OS VersionUbuntu 10.10Database version11.2.0 SEAnt version1.8.0
Product Version2.50MP31SCM revision 
Review Assigned To
Web browserGoogle Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017970: Enterprise Module Management is not working fine with * organization.

Description- Enterprise Module Management provides modules that shouldn't, as are already applied in * organization.
- Furthermore: accounting module shouldn't appear to be applied.
Steps To Reproduce- As System Admin:
- go to Initial Client Setup
- choose as name 'Cliente'
- do NOT choose any reference data item (datasets). Specially, do NOT activate Initial Setup dataset from core module.
- change role to the new client
- run initial organization setup, and create a new legal entity withOUT acconting, with name Org
- set Org organization as ready
- go to enterprise module management
- apply core dataset to * organization
- go to Module window
- change version for module Core to a higher version number (activating in development flag)
- go to enterprise module management
- choose Org organization
- realize that the core module is provided to be applied
** This is wrong: core dataset has been already applied to * organization, so shouldn't be allowed to apply it to any other organization of the client, as all of them are bellow * organization in the organizational tree.
Proposed Solutionorg.openbravo.erpCommon.modules.ModuleReferenceDataOrgTree_data.selectOrg() shouldn't provide the organization, or org.openbravo.erpCommon.modules.ModuleReferenceDataOrgTree.filterAlreadyApplied() should remove it from the data.

diff --git a/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql b/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
--- a/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
+++ b/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
@@ -53,12 +53,12 @@
             WHERE M.TYPE = 'M'
             AND M.ISACTIVE = 'Y'
             AND 1=1
- AND ((EXISTS (SELECT 1 FROM ad_dataset
+ AND (EXISTS (SELECT 1 FROM ad_dataset
                             WHERE M.ad_module_id = AD_DATASET.ad_module_id
                             AND AD_DATASET.ACCESSLEVEL IN ('3','1')
                             AND AD_DATASET.EXPORTALLOWED = 'Y')
- AND M.HASREFERENCEDATA = 'Y')
- OR M.haschartofaccounts = 'Y')
+ AND M.HASREFERENCEDATA = 'Y'
+ AND M.HASCHARTOFACCOUNTS = 'N')
             AND NOT EXISTS (SELECT 1 FROM AD_CLIENTMODULE CM
                     WHERE CM.ad_module_id = M.ad_module_id
                     AND AD_CLIENT_ID = ?)
@@ -87,6 +87,7 @@
             AND 1=1
             AND M.HASREFERENCEDATA = 'Y'
             AND EXPORTALLOWED = 'Y'
+ AND M.HASCHARTOFACCOUNTS = 'N'
             AND NOT EXISTS (SELECT 1 FROM AD_CLIENTMODULE CM
                             WHERE CM.ad_module_id = M.ad_module_id
                             AND CM.AD_CLIENT_ID = ?
@@ -97,7 +98,7 @@
                             AND (AD_IsOrgIncluded(?, OM.AD_Org_ID, OM.AD_Client_ID)<>-1
                             OR AD_IsOrgIncluded(OM.AD_Org_ID, ?, OM.AD_Client_ID)<>-1)
                             AND OM.VERSION = M.VERSION)
- AND (((? <> '0') AND AD_DATASET.ACCESSLEVEL IN ('1', '3'))
+ AND (((? <> '0') AND AD_DATASET.ACCESSLEVEL IN ('1'))
                 OR ((? = '0') AND AD_DATASET.ACCESSLEVEL IN ('3', '6')))) A
           ORDER BY A.SeqNo
           ]]>
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00179693.0MP3 closedjecharri Enterprise Module Management is not working fine with * organization. 

-  Notes
(0039838)
hgbot (developer)
2011-08-03 17:39

 Repository: erp/stable/2.50
Changeset: 0e07b2b06b27f79346a2c8c5ba95940d652e528c
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Wed Aug 03 18:09:02 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/0e07b2b06b27f79346a2c8c5ba95940d652e528c [^]

Fixes issue 0017970: Enterprise Module Management is not working fine with *
organization.

---
M src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
---
(0040080)
hgbot (developer)
2011-08-10 16:45

 Repository: erp/stable/2.50
Changeset: e87eb616f545f7fddf1f8f3874525feef04d2d12
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Wed Aug 10 17:14:45 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/e87eb616f545f7fddf1f8f3874525feef04d2d12 [^]

Fixes issue 0017970: Enterprise Module Management is not working fine with *
organization.

---
M src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
---
(0040390)
hgbot (developer)
2011-08-22 15:12

 Repository: erp/stable/2.50
Changeset: c1a592b54b9d909ca70781e008c605fd12b09b61
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Aug 22 09:50:52 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/c1a592b54b9d909ca70781e008c605fd12b09b61 [^]

Fixes issue 17970: Ent.Mod.Management is not working ok

---
M src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
---

- Issue History
Date Modified Username Field Change
2011-07-12 14:48 dalsasua Type defect => backport
2011-07-12 14:48 dalsasua fix_in_branch => 2.50
2011-07-14 11:47 dalsasua Web browser Google Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-14 11:47 dalsasua Description Updated View Revisions
2011-07-14 11:47 dalsasua Proposed Solution updated
2011-07-14 12:15 dalsasua Issue Monitored: networkb
2011-07-20 18:08 dalsasua Assigned To dalsasua => jonalegriaesarte
2011-08-03 17:39 hgbot Checkin
2011-08-03 17:39 hgbot Note Added: 0039838
2011-08-03 17:39 hgbot Status scheduled => resolved
2011-08-03 17:39 hgbot Resolution open => fixed
2011-08-03 17:39 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/0e07b2b06b27f79346a2c8c5ba95940d652e528c [^]
2011-08-10 16:45 hgbot Checkin
2011-08-10 16:45 hgbot Note Added: 0040080
2011-08-10 16:45 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/0e07b2b06b27f79346a2c8c5ba95940d652e528c [^] => http://code.openbravo.com/erp/stable/2.50/rev/e87eb616f545f7fddf1f8f3874525feef04d2d12 [^]
2011-08-17 11:59 jonalegriaesarte Status resolved => new
2011-08-17 11:59 jonalegriaesarte Resolution fixed => open
2011-08-17 12:00 jonalegriaesarte Status new => scheduled
2011-08-17 12:00 jonalegriaesarte fix_in_branch 2.50 => pi
2011-08-17 12:08 jonalegriaesarte Web browser Google Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-08-17 12:08 jonalegriaesarte Severity major => minor
2011-08-17 12:08 jonalegriaesarte fix_in_branch pi =>
2011-08-22 15:12 hgbot Checkin
2011-08-22 15:12 hgbot Note Added: 0040390
2011-08-22 15:12 hgbot Status scheduled => resolved
2011-08-22 15:12 hgbot Resolution open => fixed
2011-08-22 15:12 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/e87eb616f545f7fddf1f8f3874525feef04d2d12 [^] => http://code.openbravo.com/erp/stable/2.50/rev/c1a592b54b9d909ca70781e008c605fd12b09b61 [^]
2011-08-23 13:32 jecharri Status resolved => closed
2011-08-23 13:32 jecharri Fixed in Version => 2.50MP33

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker