SF.net SVN: ledger-smb:[3970] branches/1.3

[..hidden..]

Revision: 3970
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3970&view=rev
Author:   einhverfr
Date:     2011-11-10 05:52:12 +0000 (Thu, 10 Nov 2011)
Log Message:
-----------
Correcting menu and permissions issues, bugs  3433644 and 3430820

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/Pg-database.sql
    branches/1.3/sql/modules/Fixes.sql
    branches/1.3/sql/modules/Roles.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2011-11-09 08:26:24 UTC (rev 3969)
+++ branches/1.3/Changelog	2011-11-10 05:52:12 UTC (rev 3970)
@@ -2,6 +2,10 @@
 Initial Release:  Monday, Oct 12 2011
 Supported Presently
 
+Changelog for LedgerSMB 1.3.5
+* Fixing Menu and Permissions bug 3430820 (Chris T)
+* Fixing permissions bug 3433644 (Chris T)
+
 Changelog for LedgerSMB 1.3.4
 * Corrected case matching error in upgrade script (Chris T)
 * Corrected version number on new databases (Chris T)

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2011-11-09 08:26:24 UTC (rev 3969)
+++ branches/1.3/sql/Pg-database.sql	2011-11-10 05:52:12 UTC (rev 3970)
@@ -2792,8 +2792,8 @@
 82	module	pe.pl	196
 83	action	add	198
 83	module	pe.pl	199
-83	type	partsgroup	200
-82	type	pricegroup	197
+83	type	pricegroup	200
+82	type	partsgroup	197
 84	module	ic.pl	202
 84	action	stock_assembly	203
 85	menu	1	204
@@ -2812,10 +2812,10 @@
 90	module	ic.pl	217
 90	searchitems	labor	218
 91	module	pe.pl	221
-91	type	pricegroup	222
+91	type	partsgroup	222
 91	action	search	220
 92	module	pe.pl	224
-92	type	partsgroup	225
+92	type	pricegroup	225
 92	action	search	223
 93	action	search	226
 93	module	ic.pl	227

Modified: branches/1.3/sql/modules/Fixes.sql
===================================================================
--- branches/1.3/sql/modules/Fixes.sql	2011-11-09 08:26:24 UTC (rev 3969)
+++ branches/1.3/sql/modules/Fixes.sql	2011-11-10 05:52:12 UTC (rev 3970)
@@ -17,4 +17,11 @@
 update menu_attribute set id = '152' where value  =
 'consolidate_sales_order' and node_id = '64';
 
+-- fix for bug 3430820
+update menu_attribute set value = 'pricegroup' where node_id = '83' and attribute = 'type';
+update menu_attribute set value = 'partsgroup' where node_id = '82' and attribute = 'type';
+
+UPDATE menu_attribute SET value = 'partsgroup' WHERE node_id = 91 and attribute = 'type';
+UPDATE menu_attribute SET value = 'pricegroup' WHERE node_id = 92 and attribute = 'type';
+
 COMMIT;

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2011-11-09 08:26:24 UTC (rev 3969)
+++ branches/1.3/sql/modules/Roles.sql	2011-11-10 05:52:12 UTC (rev 3970)
@@ -749,7 +749,7 @@
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
 GRANT ALL ON partsvendor, partscustomer TO "lsmb_<?lsmb dbname ?>__part_create";
-GRANT INSERT ON parts, makemodel TO "lsmb_<?lsmb dbname ?>__part_create";
+GRANT INSERT ON parts, makemodel, partsgroup, assembly TO "lsmb_<?lsmb dbname ?>__part_create";
 GRANT ALL ON parts_id_seq TO "lsmb_<?lsmb dbname ?>__part_create";
 GRANT INSERT ON partstax TO "lsmb_<?lsmb dbname ?>__part_create";
 
@@ -770,7 +770,7 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__part_edit"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON parts TO "lsmb_<?lsmb dbname ?>__part_edit";
+GRANT UPDATE ON parts, partsgroup, assembly TO "lsmb_<?lsmb dbname ?>__part_edit";
 GRANT ALL ON makemodel TO "lsmb_<?lsmb dbname ?>__part_edit";
 --###oldcode: Should have been UPDATE
 GRANT ALL ON partstax TO "lsmb_<?lsmb dbname ?>__part_edit";

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.