SF.net SVN: ledger-smb:[6781] trunk/sql

[..hidden..]

Revision: 6781
          http://sourceforge.net/p/ledger-smb/code/6781
Author:   einhverfr
Date:     2014-02-06 07:59:46 +0000 (Thu, 06 Feb 2014)
Log Message:
-----------
Closing 982, inventory adjustment approval now works

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Roles.sql
    trunk/sql/modules/menu_rebuild.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2014-02-06 07:35:00 UTC (rev 6780)
+++ trunk/sql/Pg-database.sql	2014-02-06 07:59:46 UTC (rev 6781)
@@ -2900,6 +2900,7 @@
 204	Reverse Receipts	200	5
 18	Reverse Overpay	200	3
 26	Reverse AR Overpay	200	6
+59	Inventory	205	4
 \.
 
 
@@ -3551,6 +3552,9 @@
 26	module	vouchers.pl	213
 26	action	create_batch	214
 26	overpayment	1	215
+59	module	reports.pl	216
+59	action	start_report	217
+59	report_name	inventory_adj	218
 \.
 
 

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2014-02-06 07:35:00 UTC (rev 6780)
+++ trunk/sql/modules/Roles.sql	2014-02-06 07:59:46 UTC (rev 6781)
@@ -691,6 +691,14 @@
 SELECT lsmb__grant_menu('inventory_adjust', node_id, 'allow')
   FROM unnest(array[6,16]) node_id;
 
+SELECT lsmb__create_role('inventory_approve');
+SELECT lsmb__grant_menu('inventory_approve', 59, 'allow');
+SELECT lsmb__grant_role('inventory_approve', 'ar_invoice_create');
+SELECT lsmb__grant_role('inventory_approve', 'ap_invoice_create');
+SELECT lsmb__grant_perms('inventory_adjust', obj, 'SELECT')
+  FROM unnest(array['inventory_report'::text, 'inventory_report_line']) obj;
+SELECT lsmb__grant_perms('inventory_adjust', 'inventory_report', 'UPDATE');
+
 SELECT lsmb__create_role('pricegroup_create');
 SELECT lsmb__grant_role('pricegroup_create', 'contact_read');
 SELECT lsmb__grant_menu('pricegroup_create', 83, 'allow');

Modified: trunk/sql/modules/menu_rebuild.sql
===================================================================
--- trunk/sql/modules/menu_rebuild.sql	2014-02-06 07:35:00 UTC (rev 6780)
+++ trunk/sql/modules/menu_rebuild.sql	2014-02-06 07:59:46 UTC (rev 6781)
@@ -807,6 +807,9 @@
 26	module	vouchers.pl	213
 26	action	create_batch	214
 26	overpayment	1	215
+59	module	reports.pl	216
+59	action	start_report	217
+59	report_name	inventory_adj	218
 \.
 
 
@@ -1036,6 +1039,7 @@
 204	Reverse Receipts	200	5
 18	Reverse Overpay	200	3
 26	Reverse AR Overpay	200	6
+59	Inventory	205	4
 \.
 
 

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits