[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 4484
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4484&view=rev
Author:   einhverfr
Date:     2012-03-16 07:16:58 +0000 (Fri, 16 Mar 2012)
Log Message:
-----------
Merging menu for transaction import

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-03-16 05:40:28 UTC (rev 4483)
+++ trunk/sql/Pg-database.sql	2012-03-16 07:16:58 UTC (rev 4484)
@@ -2440,9 +2440,8 @@
 -- Name: menu_node_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ledgersmb
 --
 
-SELECT pg_catalog.setval('menu_node_id_seq', 242, true);
+SELECT pg_catalog.setval('menu_node_id_seq', 248, true);
 
-
 --
 -- Data for Name: menu_node; Type: TABLE DATA; Schema: public; Owner: ledgersmb
 --
@@ -2513,8 +2512,6 @@
 71	Quotations	70	1
 72	RFQs	70	2
 74	Journal Entry	73	1
-75	Adjust Till	73	2
-76	Reports	73	3
 78	Add Part	77	1
 79	Add Service	77	2
 80	Add Assembly	77	3
@@ -2567,8 +2564,6 @@
 132	Yearend	128	4
 137	Add Accounts	136	1
 138	List Accounts	136	2
-139	Add GIFI	136	3
-140	List GIFI	136	4
 142	Add Warehouse	141	1
 143	List Warehouse	141	2
 148	Add Business	147	1
@@ -2611,17 +2606,7 @@
 242	Letterhead	172	16
 189	POS Invoice	188	1
 198	AR Voucher	1	2
-3	Sales Invoice	1	3
-11	Customers	1	7
-4	Reports	1	6
-194	Credit Note	1	4
-195	Credit Invoice	1	5
 199	AP Voucher	21	2
-23	Vendor Invoice	21	3
-24	Reports	21	6
-30	Vendors	21	7
-196	Debit Note	21	4
-197	Debit Invoice	21	5
 200	Vouchers	35	5
 40	Transfer	35	6
 41	Reports	35	8
@@ -2672,6 +2657,26 @@
 236	Reports	229	11
 239	Depreciation	236	2
 240	Disposal	236	3
+243	Import Batch	21	3
+23	Vendor Invoice	21	4
+24	Reports	21	7
+30	Vendors	21	8
+196	Debit Note	21	5
+197	Debit Invoice	21	6
+244	Import Batch	1	3
+3	Sales Invoice	1	4
+11	Customers	1	8
+4	Reports	1	7
+194	Credit Note	1	5
+195	Credit Invoice	1	6
+245	Import	73	2
+75	Adjust Till	73	3
+76	Reports	73	4
+246	Import Chart	136	3
+139	Add GIFI	136	4
+140	List GIFI	136	5
+247	Import GIFI	136	6
+248	Import	153	3
 \.
 
 --
@@ -2724,7 +2729,7 @@
 -- Name: menu_attribute_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ledgersmb
 --
 
-SELECT pg_catalog.setval('menu_attribute_id_seq', 649, true);
+SELECT pg_catalog.setval('menu_attribute_id_seq', 667, true);
 
 
 --
@@ -2869,10 +2874,8 @@
 63	menu	1	146
 64	module	oe.pl	147
 64	action	search	148
-64	type	ship_order	149
 65	module	oe.pl	150
 65	action	search	151
-65	type	receive_order	152
 66	module	oe.pl	153
 66	action	search_transfer	154
 67	menu	1	155
@@ -2888,6 +2891,7 @@
 71	type	sales_quotation	165
 71	action	search	164
 72	module	oe.pl	166
+64	type	ship_order	149
 72	action	search	168
 72	type	request_quotation	167
 73	menu	1	169
@@ -2918,8 +2922,6 @@
 82	module	pe.pl	196
 83	action	add	198
 83	module	pe.pl	199
-83	type	pricegroup	200
-82	type	partsgroup	197
 84	module	ic.pl	202
 84	action	stock_assembly	203
 85	menu	1	204
@@ -2938,10 +2940,8 @@
 90	module	ic.pl	217
 90	searchitems	labor	218
 91	module	pe.pl	221
-91	type	partsgroup	222
 91	action	search	220
 92	module	pe.pl	224
-92	type	pricegroup	225
 92	action	search	223
 93	action	search	226
 93	module	ic.pl	227
@@ -3008,11 +3008,9 @@
 117	module	bp.pl	294
 117	action	search	295
 117	vc	customer	297
-117	type	invoice	296
 118	module	bp.pl	298
 118	action	search	299
 118	vc	customer	300
-118	type	sales_order	301
 120	module	bp.pl	302
 120	action	search	303
 120	vc	customer	304
@@ -3043,6 +3041,8 @@
 127	action	search	331
 127	type	timecard	332
 125	type	bin_list	324
+117	type	invoice	296
+118	type	sales_order	301
 126	type	request_quotation	328
 127	vc	employee	333
 128	menu	1	334
@@ -3248,7 +3248,6 @@
 201	action	create_batch	563
 203	module	vouchers.pl	565
 203	action	create_batch	566
-203	batch_type	receipts	567
 202	module	vouchers.pl	568
 202	action	create_batch	569
 204	module	vouchers.pl	571
@@ -3301,7 +3300,6 @@
 234	module	asset.pl	627
 234	action	new_report	628
 235	module	asset.pl	630
-235	action	import	631
 236	menu	1	632
 237	module	asset.pl	633
 237	action	display_nbv	634
@@ -3317,15 +3315,35 @@
 239	depreciation	1	639
 240	module	asset.pl	640
 240	action	search_reports	641
+65	type	receive_order	149
+83	type	pricegroup	200
+82	type	partsgroup	197
+91	type	partsgroup	222
+92	type	pricegroup	225
+235	action	begin_import	631
+203	batch_type	receipt	567
+243	module	import_csv.pl	650
+243	action	begin_import	651
+243	type	ap_multi	652
+244	module	import_csv.pl	653
+244	action	begin_import	654
+244	type	ar_multi	655
+245	module	import_csv.pl	656
+245	action	begin_import	657
+245	type	gl	658
+246	module	import_csv.pl	659
+246	action	begin_import	660
+246	type	chart	661
+247	module	import_csv.pl	662
+247	action	begin_import	663
+247	type	gifi	664
+248	module	import_csv.pl	665
+248	action	begin_import	666
+248	type	sic	667
 \.
 
-
 --
--- PostgreSQL database dump complete
---
 
---
-
 CREATE TABLE menu_acl (
     id serial NOT NULL,
     role_name character varying,

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2012-03-16 05:40:28 UTC (rev 4483)
+++ trunk/sql/modules/Roles.sql	2012-03-16 07:16:58 UTC (rev 4484)
@@ -278,7 +278,11 @@
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
 values (198, 'allow', 'lsmb_<?lsmb dbname ?>__ar_transaction_create_voucher');
 
+-- Activate when AR batch import is working
+--INSERT INTO menu_acl (node_id, acl_type, role_name) 
+--values (244, 'allow', 'lsmb_<?lsmb dbname ?>__ar_transaction_create_voucher');
 
+
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ar_invoice_create"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__ar_transaction_create";
@@ -483,6 +487,8 @@
 
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
 values (199, 'allow', 'lsmb_<?lsmb dbname ?>__ap_transaction_create_voucher');
+INSERT INTO menu_acl (node_id, acl_type, role_name) 
+values (243, 'allow', 'lsmb_<?lsmb dbname ?>__ap_transaction_create_voucher');
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ap_invoice_create"
 WITH INHERIT NOLOGIN
@@ -1032,6 +1038,8 @@
 values (35, 'allow', 'lsmb_<?lsmb dbname ?>__gl_transaction_create');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (40, 'allow', 'lsmb_<?lsmb dbname ?>__gl_transaction_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (245, 'allow', 'lsmb_<?lsmb dbname ?>__gl_transaction_create');
 
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__gl_voucher_create"
@@ -1317,6 +1325,8 @@
 values (136, 'allow', 'lsmb_<?lsmb dbname ?>__account_create');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (137, 'allow', 'lsmb_<?lsmb dbname ?>__account_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (246, 'allow', 'lsmb_<?lsmb dbname ?>__account_create');
 
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__account_edit"
@@ -1353,6 +1363,8 @@
 values (136, 'allow', 'lsmb_<?lsmb dbname ?>__gifi_create');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (139, 'allow', 'lsmb_<?lsmb dbname ?>__gifi_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (247, 'allow', 'lsmb_<?lsmb dbname ?>__gifi_create');
 
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__gifi_edit"
@@ -1419,6 +1431,8 @@
 values (153, 'allow', 'lsmb_<?lsmb dbname ?>__sic_create');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (154, 'allow', 'lsmb_<?lsmb dbname ?>__sic_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (248, 'allow', 'lsmb_<?lsmb dbname ?>__sic_create');
 
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__sic_edit"

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