[Phpcompta-dev] r4316 - in phpcompta/trunk: html sql

[phpcompta-dev]

Author: danydb
Date: 2011-11-05 00:45:50 +0100 (Sat, 05 Nov 2011)
New Revision: 4316

Modified:
   phpcompta/trunk/html/
   phpcompta/trunk/sql/object-6.0.sql
Log:
ajout impression dans menu_ref et profile_menu


Property changes on: phpcompta/trunk/html
___________________________________________________________________
Name: svn:ignore
   - *.log
ajax
.user_login.php.swp

   + *.log
ajax
.user_login.php.swp
.~lock.a.csv#
.~lock.a.ods#
.a.csv.swp


Modified: phpcompta/trunk/sql/object-6.0.sql
===================================================================
--- phpcompta/trunk/sql/object-6.0.sql  2011-11-04 23:42:31 UTC (rev 4315)
+++ phpcompta/trunk/sql/object-6.0.sql  2011-11-04 23:45:50 UTC (rev 4316)
@@ -25,7 +25,8 @@
     me_file text,
     me_url text,
     me_description text,
-    me_parameter text
+    me_parameter text,
+    me_javascript text
 );
 
 
@@ -171,7 +172,7 @@
 -- Name: profile_menu_pm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: 
dany
 --
 
-SELECT pg_catalog.setval('profile_menu_pm_id_seq', 95, true);
+SELECT pg_catalog.setval('profile_menu_pm_id_seq', 153, true);
 
 
 --
@@ -269,7 +270,7 @@
 --
 
 CREATE VIEW v_all_menu AS
-    SELECT pm.me_code, pm.pm_id, pm.me_code_dep, pm.p_order, 
pm.p_type_display, pu.user_name, pu.pu_id, p.p_name, p.p_desc, mr.me_menu, 
mr.me_file, mr.me_url, mr.me_parameter FROM (((profile_menu pm JOIN 
profile_user pu ON ((pu.p_id = pm.p_id))) JOIN profile p ON ((p.p_id = 
pm.p_id))) JOIN menu_ref mr USING (me_code)) ORDER BY pm.p_order;
+    SELECT pm.me_code, pm.pm_id, pm.me_code_dep, pm.p_order, 
pm.p_type_display, pu.user_name, pu.pu_id, p.p_name, p.p_desc, mr.me_menu, 
mr.me_file, mr.me_url, mr.me_parameter, mr.me_javascript FROM (((profile_menu 
pm JOIN profile_user pu ON ((pu.p_id = pm.p_id))) JOIN profile p ON ((p.p_id = 
pm.p_id))) JOIN menu_ref mr USING (me_code)) ORDER BY pm.p_order;
 
 
 ALTER TABLE public.v_all_menu OWNER TO dany;
@@ -299,81 +300,110 @@
 -- Data for Name: menu_ref; Type: TABLE DATA; Schema: public; Owner: dany
 --
 
-INSERT INTO menu_ref VALUES ('COMPANY', 'Sociétés', 'company.inc.php', NULL, 
'Parametre societe', NULL);
-INSERT INTO menu_ref VALUES ('PERIODE', 'Période', 'periode.inc.php', NULL, 
'Gestion des périodes', NULL);
-INSERT INTO menu_ref VALUES ('DIVPARM', 'Divers', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGPAYMENT', 'Moyen de paiement', 
'payment_middle.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGTVA', 'TVA', 'tva.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGACCOUNT', 'Poste', 'poste.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('CARD', 'Fiche', 'fiche.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('STOCK', 'Stock', 'stock.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('ODSIMP', 'Historique opérations diverses', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ODS');
-INSERT INTO menu_ref VALUES ('VEN', 'Vente', 'compta_ven.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('ACH', 'Achat', 'compta_ach.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('LET', 'Lettrage', 'letter.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('PREOD', 'Opérations prédéfinies', 
'preod.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('VERIFBIL', 'Vérification ', 
'verif_bilan.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('REPORT', 'Création de rapport', 
'report.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('OPEN', 'Ecriture Ouverture', 'opening.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ACHIMP', 'Historique achat', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ACH');
-INSERT INTO menu_ref VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('FOLLOW', 'Courrier', 'action.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('FORECAST', 'Prévision', 'forecast.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPJRN', 'Historique', 'impress_jrn.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPREC', 'Rapprochement', 'impress_rec.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPPOSTE', 'Poste', 'impress_poste.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPREPORT', 'Rapport', 
'impress_rapport.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPBILAN', 'Bilan', 'impress_bilan.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPGL', 'Grand Livre', 
'impress_gl_comptes.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPBAL', 'Balance', 'balance.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPCARD', 'Catégorie de Fiches', 
'impress_fiche.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTDET', 'Fiche', 'detail_client.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTFOLLOW', 'Suivi', 'suivi_client.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTOP', 'Opération', 
'operation_client.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGCARDCAT', 'Catégorie de fiche', 
'fiche_def.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUST', 'Client', 'client.inc.php', NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('CFGCATDOC', 'Catégorie de documents', 
'cat_document.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('VENIMP', 'Historique vente', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=VEN');
-INSERT INTO menu_ref VALUES ('CFGATTRIBCARD', 'Attribut de fiche', 
'card_attr.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGPCMN', 'Plan Comptable', 
'param_pcmn.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('PARAM', 'Paramètre', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('GESTION', 'Gestion', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTCONTACT', 'Contact (à faire)', NULL, NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGEXTENSION', 'Extension', 'extension.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('COMPTA', 'Comptabilité', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('LOGOUT', 'Sortie', NULL, 'logout.php', NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('DASHBOARD', 'Tableau de bord', 
'dashboard.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMP', 'Impression', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTER', 'Lettrage', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGSECURITY', 'Sécurité', 'param_sec.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTERCARD', 'Let. Fiche', 
'lettering.card.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTERACC', 'Let. Poste', 
'lettering.account.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ADV', 'Avancé', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ANC', 'Compta Analytique', NULL, NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('CFGDOCUMENT', 'Document', 
'document_modele.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ACCESS', 'Dossier', NULL, 'user_login.php', 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('DOCUMENT', 'Document', 
'document_modele.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGLEDGER', 'journaux', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('PLANANC', 'Plan Compt. analytique', 
'anc_pa.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ANCODS', 'Opérations diverses', 
'anc_od.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('ANCGROUP', 'Groupe', 'anc_group.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('ANCIMP', 'Impression', 'anc_imp.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('VENMENU', 'Vente / Recette', NULL, NULL, NULL, 
NULL);
-INSERT INTO menu_ref VALUES ('PREFERENCE', 'Préférence', 'pref.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('HIST', 'Historique', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ALL');
-INSERT INTO menu_ref VALUES ('MENUFIN', 'Financier', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('TVA', 'Tva', 'extension_get.inc.php', NULL, 
NULL, 'plugin_code=AMORTIS');
-INSERT INTO menu_ref VALUES ('EXTENSION', 'Extension', 
'extension_choice.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('MENUACH', 'Achat', NULL, NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('MENUODS', 'Opérations diverses', NULL, NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('ODS', 'Opérations Diverses', 
'compta_ods.inc.php', NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('FINIMP', 'Historique financier', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=FIN');
-INSERT INTO menu_ref VALUES ('ADM', 'Administration', 'adm.inc.php', NULL, 
NULL, NULL);
-INSERT INTO menu_ref VALUES ('FIN', 'Nouvel extrait', 'compta_fin.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('FINSALDO', 'Soldes', 'compta_fin_saldo.inc.php', 
NULL, NULL, NULL);
-INSERT INTO menu_ref VALUES ('FINREC', 'Rapprochement', 
'compta_fin_rec.inc.php', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('SEARCH', 'Recherche', NULL, NULL, NULL, NULL, 
'popup_recherche()');
+INSERT INTO menu_ref VALUES ('COMPANY', 'Sociétés', 'company.inc.php', NULL, 
'Parametre societe', NULL, NULL);
+INSERT INTO menu_ref VALUES ('PERIODE', 'Période', 'periode.inc.php', NULL, 
'Gestion des périodes', NULL, NULL);
+INSERT INTO menu_ref VALUES ('DIVPARM', 'Divers', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('CFGPAYMENT', 'Moyen de paiement', 
'payment_middle.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGTVA', 'TVA', 'tva.inc.php', NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('CFGACCOUNT', 'Poste', 'poste.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CARD', 'Fiche', 'fiche.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('STOCK', 'Stock', 'stock.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('ODSIMP', 'Historique opérations diverses', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ODS', NULL);
+INSERT INTO menu_ref VALUES ('VEN', 'Vente', 'compta_ven.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('ACH', 'Achat', 'compta_ach.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('LET', 'Lettrage', 'letter.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('PREOD', 'Opérations prédéfinies', 
'preod.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('VERIFBIL', 'Vérification ', 
'verif_bilan.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('REPORT', 'Création de rapport', 
'report.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('OPEN', 'Ecriture Ouverture', 'opening.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ACHIMP', 'Historique achat', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ACH', NULL);
+INSERT INTO menu_ref VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FOLLOW', 'Courrier', 'action.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FORECAST', 'Prévision', 'forecast.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPJRN', 'Historique', 'impress_jrn.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('JSSEARCH', 'Recherche', NULL, NULL, NULL, NULL, 
'search_reconcile()');
+INSERT INTO menu_ref VALUES ('IMPREC', 'Rapprochement', 'impress_rec.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPPOSTE', 'Poste', 'impress_poste.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPREPORT', 'Rapport', 
'impress_rapport.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPBILAN', 'Bilan', 'impress_bilan.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPGL', 'Grand Livre', 
'impress_gl_comptes.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPBAL', 'Balance', 'balance.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPCARD', 'Catégorie de Fiches', 
'impress_fiche.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTDET', 'Fiche', 'detail_client.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTFOLLOW', 'Suivi', 'suivi_client.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTOP', 'Opération', 
'operation_client.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGCARDCAT', 'Catégorie de fiche', 
'fiche_def.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUST', 'Client', 'client.inc.php', NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGCATDOC', 'Catégorie de documents', 
'cat_document.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('VENIMP', 'Historique vente', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=VEN', NULL);
+INSERT INTO menu_ref VALUES ('CFGATTRIBCARD', 'Attribut de fiche', 
'card_attr.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGPCMN', 'Plan Comptable', 
'param_pcmn.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PARAM', 'Paramètre', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('GESTION', 'Gestion', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('CUSTCONTACT', 'Contact (à faire)', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGEXTENSION', 'Extension', 'extension.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('COMPTA', 'Comptabilité', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('LOGOUT', 'Sortie', NULL, 'logout.php', NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('DASHBOARD', 'Tableau de bord', 
'dashboard.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMP', 'Impression', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('LETTER', 'Lettrage', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('CFGSECURITY', 'Sécurité', 'param_sec.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('LETTERCARD', 'Let. Fiche', 
'lettering.card.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('LETTERACC', 'Let. Poste', 
'lettering.account.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ADV', 'Avancé', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANC', 'Compta Analytique', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGDOCUMENT', 'Document', 
'document_modele.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ACCESS', 'Dossier', NULL, 'user_login.php', 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('DOCUMENT', 'Document', 
'document_modele.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGLEDGER', 'journaux', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('PLANANC', 'Plan Compt. analytique', 
'anc_pa.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANCODS', 'Opérations diverses', 
'anc_od.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANCGROUP', 'Groupe', 'anc_group.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANCIMP', 'Impression', 'anc_imp.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('VENMENU', 'Vente / Recette', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('PREFERENCE', 'Préférence', 'pref.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('HIST', 'Historique', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=ALL', NULL);
+INSERT INTO menu_ref VALUES ('MENUFIN', 'Financier', NULL, NULL, NULL, NULL, 
NULL);
+INSERT INTO menu_ref VALUES ('TVA', 'Tva', 'extension_get.inc.php', NULL, 
NULL, 'plugin_code=AMORTIS', NULL);
+INSERT INTO menu_ref VALUES ('EXTENSION', 'Extension', 
'extension_choice.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('MENUACH', 'Achat', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('MENUODS', 'Opérations diverses', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ODS', 'Opérations Diverses', 
'compta_ods.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FINIMP', 'Historique financier', 
'history_operation.inc.php', NULL, NULL, 'ledger_type=FIN', NULL);
+INSERT INTO menu_ref VALUES ('ADM', 'Administration', 'adm.inc.php', NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FIN', 'Nouvel extrait', 'compta_fin.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FINSALDO', 'Soldes', 'compta_fin_saldo.inc.php', 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('FINREC', 'Rapprochement', 
'compta_fin_rec.inc.php', NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/histo', 'Export Historique', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/ledger', 'Export Journaux', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/ledger', 'Export Journaux', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/postedetail', 'Export Poste détail', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/postedetail', 'Export Poste détail', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/fichedetail', 'Export Fiche détail', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/fichedetail', 'Export Fiche détail', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/fiche_balance', 'Export Fiche balance', 
NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/fiche_balance', 'Export Fiche balance', 
NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/report', 'Export report', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/report', 'Export report', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/fiche', 'Export Fiche', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/fiche', 'Export Fiche', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/glcompte', 'Export Grand Livre', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/glcompte', 'Export Grand Livre', NULL, NULL, 
NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/sec', 'Export Sécurité', NULL, NULL, NULL, 
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncList', 'Export Comptabilité analytique', 
NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncBalSimple', 'Export Comptabilité 
analytique balance simple', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/AncBalSimple', 'Export Comptabilité 
analytique', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncBalDouble', 'Export Comptabilité 
analytique balance double', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/AncBalDouble', 'Export Comptabilité 
analytique balance double', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/balance', 'Export Balance comptable', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PDF/balance', 'Export Balance comptable', NULL, 
NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncTable', 'Export Tableau Analytique', 
NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncAccList', 'Export Historique Compt. 
Analytique', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CSV/AncBalGroup', 'Export Balance groupe 
analytique', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('OTH/Bilan', 'Export Bilan', NULL, NULL, NULL, 
NULL, NULL);
 
 
 --
@@ -465,6 +495,35 @@
 INSERT INTO profile_menu VALUES (19, 'FIN', 'MENUFIN', 1, 1, 'E', NULL);
 INSERT INTO profile_menu VALUES (92, 'MENUFIN', 'COMPTA', 1, 4, 'E', NULL);
 INSERT INTO profile_menu VALUES (93, 'FINIMP', 'MENUFIN', 1, 2, 'E', NULL);
+INSERT INTO profile_menu VALUES (123, 'CSV/histo', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (124, 'CSV/ledger', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (125, 'PDF/ledger', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (126, 'CSV/postedetail', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (127, 'PDF/postedetail', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (128, 'CSV/fichedetail', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (129, 'PDF/fichedetail', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (130, 'CSV/fiche_balance', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (131, 'PDF/fiche_balance', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (132, 'CSV/report', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (133, 'PDF/report', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (134, 'CSV/fiche', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (135, 'PDF/fiche', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (136, 'CSV/glcompte', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (137, 'PDF/glcompte', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (138, 'PDF/sec', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (139, 'CSV/AncList', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (140, 'CSV/AncBalSimple', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (141, 'PDF/AncBalSimple', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (142, 'CSV/AncBalDouble', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (143, 'PDF/AncBalDouble', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (144, 'CSV/balance', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (145, 'PDF/balance', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (146, 'CSV/AncTable', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (147, 'CSV/AncAccList', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (148, 'CSV/AncBalGroup', NULL, 1, NULL, 'P', 
NULL);
+INSERT INTO profile_menu VALUES (149, 'OTH/Bilan', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (151, 'SEARCH', NULL, 1, NULL, 'M', NULL);
+INSERT INTO profile_menu VALUES (153, 'JSSEARCH', NULL, 1, NULL, 'M', NULL);
 
 
 --