[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4249 - in phpcompta/branches/rel600-dynamic-menu: inclu
|
From: |
phpcompta-dev |
|
Subject: |
[Phpcompta-dev] r4249 - in phpcompta/branches/rel600-dynamic-menu: include sql |
|
Date: |
Fri, 28 Oct 2011 22:16:46 +0200 (CEST) |
Author: danydb
Date: 2011-10-28 22:16:44 +0200 (Fri, 28 Oct 2011)
New Revision: 4249
Added:
phpcompta/branches/rel600-dynamic-menu/include/company.inc.php
Modified:
phpcompta/branches/rel600-dynamic-menu/include/ac_common.php
phpcompta/branches/rel600-dynamic-menu/sql/
phpcompta/branches/rel600-dynamic-menu/sql/object-6.0.sql
Log:
last fix
Modified: phpcompta/branches/rel600-dynamic-menu/include/ac_common.php
===================================================================
--- phpcompta/branches/rel600-dynamic-menu/include/ac_common.php
2011-10-28 20:00:42 UTC (rev 4248)
+++ phpcompta/branches/rel600-dynamic-menu/include/ac_common.php
2011-10-28 20:16:44 UTC (rev 4249)
@@ -695,10 +695,12 @@
{
global $g_user;
$cn=Dossier::connect();
- $amodule=$cn->get_array("select me_code,me_menu,me_url from v_all_menu
+ $amodule=$cn->get_array("select
+ me_code,me_menu,me_url
+ from v_all_menu
where
user_name=$1
- and me_module='Y'
+ and p_type_display='M'
order by p_order",array($g_user->login));
require_once('template/module.php');
if ( $selected != -1 )
Added: phpcompta/branches/rel600-dynamic-menu/include/company.inc.php
===================================================================
--- phpcompta/branches/rel600-dynamic-menu/include/company.inc.php
(rev 0)
+++ phpcompta/branches/rel600-dynamic-menu/include/company.inc.php
2011-10-28 20:16:44 UTC (rev 4249)
@@ -0,0 +1,102 @@
+<?php
+global $g_user;
+ $g_user->can_request(PARCOORD,1);
+ echo '<div class="content">';
+ require_once("class_own.php");
+ if ( isset ($_POST['record_company'] ))
+ {
+ $m=new Own($cn);
+ extract($_POST);
+ $m->MY_NAME=$p_name;
+ $m->MY_TVA=$p_tva;
+ $m->MY_STREET=$p_street;
+ $m->MY_NUMBER=$p_no;
+ $m->MY_CP=$p_cp;
+ $m->MY_COMMUNE=$p_Commune;
+ $m->MY_TEL=$p_tel;
+ $m->MY_FAX=$p_fax;
+ $m->MY_PAYS=$p_pays;
+ $m->MY_CHECK_PERIODE=$p_check_periode;
+ $m->MY_DATE_SUGGEST=$p_date_suggest;
+ if ( $g_user->check_action(PARCA)!=0)$m->MY_ANALYTIC=$p_compta;
+ if ( $g_user->check_action(PARSTR)!=0) $m->MY_STRICT=$p_strict;
+ if ( $g_user->check_action(PARTVA)!=0)$m->MY_TVA_USE=$p_tva_use;
+ $m->MY_PJ_SUGGEST=$p_pj;
+ $m->Update();
+ }
+
+ $my=new Own($cn);
+ ///// Compta analytic
+ $array=array (
+ array("value"=>"ob",'label'=>_("obligatoire")),
+ array("value"=>"op",'label'=>_("optionnel")),
+ array("value"=>"nu",'label'=>_("non utilisé"))
+ );
+ $strict_array=array(
+ array('value'=>'N','label'=>_('Non')),
+ array('value'=>'Y','label'=>_('Oui'))
+ );
+
+ $compta=new ISelect();
+ $compta->table=1;
+ $compta->selected=$my->MY_ANALYTIC;
+
+ $strict=new ISelect();
+ $strict->table=1;
+ $strict->selected=$my->MY_STRICT;
+
+ $tva_use=new ISelect();
+ $tva_use->table=1;
+ $tva_use->selected=$my->MY_TVA_USE;
+
+ $pj_suggest=new ISelect();
+ $pj_suggest->table=1;
+ $pj_suggest->selected=$my->MY_PJ_SUGGEST;
+
+ $date_suggest=new ISelect();
+ $date_suggest->table=1;
+ $date_suggest->selected=$my->MY_DATE_SUGGEST;
+
+ $check_periode=new ISelect();
+ $check_periode->table=1;
+ $check_periode->selected=$my->MY_CHECK_PERIODE;
+
+ // other parameters
+ $all=new IText();
+ $all->table=1;
+ echo '<form method="post" >';
+ echo dossier::hidden();
+ echo "<table class=\"result\" style=\"width:auto\">";
+ echo "<tr>".td(_('Nom
société'),'style="text-align:right"').$all->input("p_name",$my->MY_NAME)."</tr>";
+ $all->value='';
+ echo
"<tr>".td(_("Téléphone"),'style="text-align:right"').$all->input("p_tel",$my->MY_TEL)."</tr>";
+ $all->value='';
+ echo
"<tr>".td(_("Fax"),'style="text-align:right"').$all->input("p_fax",$my->MY_FAX)."</tr>";
+ $all->value='';
+ echo "<tr>".td(_("Rue
"),'style="text-align:right"').$all->input("p_street",$my->MY_STREET)."</tr>";
+ $all->value='';
+ echo
"<tr>".td(_("Numéro"),'style="text-align:right"').$all->input("p_no",$my->MY_NUMBER)."</tr>";
+ $all->value='';
+ echo "<tr>".td(_("Code
Postal"),'style="text-align:right"').$all->input("p_cp",$my->MY_CP)."</tr>";
+ $all->value='';
+ echo
"<tr>".td(_("Commune"),'style="text-align:right"').$all->input("p_Commune",$my->MY_COMMUNE)."</tr>";
+ $all->value='';
+ echo
"<tr>".td(_("Pays"),'style="text-align:right"').$all->input("p_pays",$my->MY_PAYS)."</tr>";
+ $all->value='';
+ echo "<tr>".td(_("Numéro de
Tva"),'style="text-align:right"').$all->input("p_tva",$my->MY_TVA)."</tr>";
+ if ( $g_user->check_action(PARCA)==0) $compta->setReadonly(true);
+ echo "<tr>".td(_("Utilisation de la compta.
analytique"),'style="text-align:right"').$compta->input("p_compta",$array)."</tr>";
+ if ( $g_user->check_action(PARSTR)==0) $strict->setReadonly(true);
+ echo "<tr>".td(_("Utilisation du mode strict
"),'style="text-align:right"').$strict->input("p_strict",$strict_array)."</tr>";
+ if ( $g_user->check_action(PARTVA)==0) $tva_use->setReadonly(true);
+ echo "<tr>".td(_("Assujetti à la
tva"),'style="text-align:right"').$tva_use->input("p_tva_use",$strict_array)."</tr>";
+ echo "<tr>".td(_("Suggérer le numéro de pièce
justificative"),'style="text-align:right"').$pj_suggest->input("p_pj",$strict_array)."</tr>";
+ echo "<tr>".td(_("Suggérer la
date"),'style="text-align:right"').$date_suggest->input("p_date_suggest",$strict_array)."</tr>";
+ echo '<tr>'.td(_('Afficher la période comptable pour éviter les erreurs de
date'),'style="text-align:right"').$check_periode->input('p_check_periode',$strict_array).'</tr>';
+ echo "</table>";
+ echo HtmlInput::submit("record_company",_("Sauve"));
+ echo "</form>";
+ echo '</div>';
+ exit();
+
+?>
Property changes on: phpcompta/branches/rel600-dynamic-menu/sql
___________________________________________________________________
Name: svn:ignore
+ .upgrade.sql.swp
Modified: phpcompta/branches/rel600-dynamic-menu/sql/object-6.0.sql
===================================================================
--- phpcompta/branches/rel600-dynamic-menu/sql/object-6.0.sql 2011-10-28
20:00:42 UTC (rev 4248)
+++ phpcompta/branches/rel600-dynamic-menu/sql/object-6.0.sql 2011-10-28
20:16:44 UTC (rev 4249)
@@ -23,7 +23,6 @@
me_code text NOT NULL,
me_menu text,
me_file text,
- me_module character(1),
me_url text,
me_description text
);
@@ -80,6 +79,13 @@
--
+-- Name: COLUMN profile.p_name; Type: COMMENT; Schema: public; Owner: dany
+--
+
+COMMENT ON COLUMN profile.p_name IS 'Name of the profile';
+
+
+--
-- Name: COLUMN profile.p_desc; Type: COMMENT; Schema: public; Owner: dany
--
@@ -96,7 +102,7 @@
me_code_dep text,
p_id integer,
p_order integer,
- p_type_display character(1)
+ p_type_display text NOT NULL
);
@@ -163,7 +169,7 @@
-- Name: profile_menu_pm_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
dany
--
-SELECT pg_catalog.setval('profile_menu_pm_id_seq', 69, true);
+SELECT pg_catalog.setval('profile_menu_pm_id_seq', 79, true);
--
@@ -261,7 +267,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_module, mr.me_url 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 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;
@@ -291,60 +297,69 @@
-- Data for Name: menu_ref; Type: TABLE DATA; Schema: public; Owner: dany
--
-INSERT INTO menu_ref VALUES ('COMPANY', 'Sociétés', 'company.inc.php', 'N',
NULL, 'Parametre societe');
-INSERT INTO menu_ref VALUES ('PERIODE', 'Période', 'periode.inc.php', 'N',
NULL, 'Gestion des périodes');
-INSERT INTO menu_ref VALUES ('DIVPARM', 'Divers', NULL, 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGPAYMENT', 'Moyen de paiement',
'payment_middle.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGTVA', 'TVA', 'tva.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGACCOUNT', 'Poste', 'poste.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('CARD', 'Fiche', 'fiche.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('STOCK', 'Stock', 'stock.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('MISC', 'Opérations Diverses',
'compta_ods.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('HIST', 'Historique', 'user_action_gl.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('VEN', 'Vente', 'compta_ven.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('ACH', 'Achat', 'compta_ach.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('FIN', 'Financier', 'compta_fin.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('LET', 'Lettrage', 'letter.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('PREOD', 'Opérations prédéfinies',
'preod.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('VERIFBIL', 'Vérification ',
'verif_bilan.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('REPORT', 'Création de rapport',
'report.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('OPEN', 'Ecriture Ouverture', 'opening.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('ADM', 'Administration', 'adm.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('FOLLOW', 'Courrier', 'action.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('FORECAST', 'Prévision', 'forecast.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPJRN', 'Historique', 'impress_jrn.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPREC', 'Rapprochement', 'impress_rec.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPPOSTE', 'Poste', 'impress_poste.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPREPORT', 'Rapport',
'impress_rapport.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPBILAN', 'Bilan', 'impress_bilan.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPGL', 'Grand Livre',
'impress_gl_comptes.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPBAL', 'Balance', 'balance.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMPCARD', 'Catégorie de Fiches',
'impress_fiche.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTDET', 'Fiche', 'detail_client.inc.php', 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTFOLLOW', 'Suivi', 'suivi_client.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTOP', 'Opération',
'operation_client.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGCARDCAT', 'Catégorie de fiche',
'fiche_def.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUST', 'Client', 'client.inc.php', 'N', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('CFGCATDOC', 'Catégorie de documents',
'cat_document.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGATTRIBCARD', 'Attribut de fiche',
'card_attr.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CFGPCMN', 'Plan Comptable',
'param_pcmn.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('PARAM', 'Paramètre', NULL, 'Y', NULL, NULL);
-INSERT INTO menu_ref VALUES ('GESTION', 'Gestion', NULL, 'Y', NULL, NULL);
-INSERT INTO menu_ref VALUES ('CUSTCONTACT', 'Contact (à faire)', NULL, 'N',
NULL, NULL);
-INSERT INTO menu_ref VALUES ('COMPTA', 'Comptabilité', NULL, 'Y', NULL, NULL);
-INSERT INTO menu_ref VALUES ('LOGOUT', 'Sortie', NULL, 'Y', 'logout.php',
NULL);
-INSERT INTO menu_ref VALUES ('DASHBOARD', 'Tableau de bord',
'dashboard.inc.php', 'Y', NULL, NULL);
-INSERT INTO menu_ref VALUES ('IMP', 'Impression', NULL, 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTER', 'Lettrage', NULL, 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTERCARD', 'Let. Fiche',
'lettering.card.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('LETTERACC', 'Let. Poste',
'lettering.account.inc.php', 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php',
'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('ADV', 'Avancé', NULL, 'N', NULL, NULL);
-INSERT INTO menu_ref VALUES ('ANC', 'Compta Analytique', NULL, 'Y', NULL,
NULL);
-INSERT INTO menu_ref VALUES ('ACCESS', 'Dossier', NULL, 'Y', 'user_login.php',
NULL);
-INSERT INTO menu_ref VALUES ('DOCUMENT', 'Document',
'document_modele.inc.php', 'N', NULL, NULL);
+INSERT INTO menu_ref VALUES ('COMPANY', 'Sociétés', 'company.inc.php', NULL,
'Parametre societe');
+INSERT INTO menu_ref VALUES ('PERIODE', 'Période', 'periode.inc.php', NULL,
'Gestion des périodes');
+INSERT INTO menu_ref VALUES ('DIVPARM', 'Divers', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGPAYMENT', 'Moyen de paiement',
'payment_middle.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGTVA', 'TVA', 'tva.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGACCOUNT', 'Poste', 'poste.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('CARD', 'Fiche', 'fiche.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('STOCK', 'Stock', 'stock.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('MISC', 'Opérations Diverses',
'compta_ods.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('HIST', 'Historique', 'user_action_gl.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('VEN', 'Vente', 'compta_ven.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('ACH', 'Achat', 'compta_ach.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('FIN', 'Financier', 'compta_fin.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('LET', 'Lettrage', 'letter.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('PREOD', 'Opérations prédéfinies',
'preod.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('VERIFBIL', 'Vérification ',
'verif_bilan.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('REPORT', 'Création de rapport',
'report.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('OPEN', 'Ecriture Ouverture', 'opening.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('ADM', 'Administration', 'adm.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('FOLLOW', 'Courrier', 'action.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('FORECAST', 'Prévision', 'forecast.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPJRN', 'Historique', 'impress_jrn.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPREC', 'Rapprochement', 'impress_rec.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPPOSTE', 'Poste', 'impress_poste.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPREPORT', 'Rapport',
'impress_rapport.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPBILAN', 'Bilan', 'impress_bilan.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPGL', 'Grand Livre',
'impress_gl_comptes.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMPBAL', 'Balance', 'balance.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('IMPCARD', 'Catégorie de Fiches',
'impress_fiche.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTDET', 'Fiche', 'detail_client.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTFOLLOW', 'Suivi', 'suivi_client.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTOP', 'Opération',
'operation_client.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGCARDCAT', 'Catégorie de fiche',
'fiche_def.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUST', 'Client', 'client.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGCATDOC', 'Catégorie de documents',
'cat_document.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGATTRIBCARD', 'Attribut de fiche',
'card_attr.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGPCMN', 'Plan Comptable',
'param_pcmn.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('PARAM', 'Paramètre', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('GESTION', 'Gestion', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CUSTCONTACT', 'Contact (à faire)', NULL, NULL,
NULL);
+INSERT INTO menu_ref VALUES ('CFGEXTENSION', 'Extension', 'extension.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('COMPTA', 'Comptabilité', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('LOGOUT', 'Sortie', NULL, 'logout.php', NULL);
+INSERT INTO menu_ref VALUES ('DASHBOARD', 'Tableau de bord',
'dashboard.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('IMP', 'Impression', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('LETTER', 'Lettrage', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGSECURITY', 'Sécurité', 'param_sec.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('LETTERCARD', 'Let. Fiche',
'lettering.card.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('LETTERACC', 'Let. Poste',
'lettering.account.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php',
NULL, NULL);
+INSERT INTO menu_ref VALUES ('ADV', 'Avancé', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANC', 'Compta Analytique', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGDOCUMENT', 'Document',
'document_modele.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('ACCESS', 'Dossier', NULL, 'user_login.php',
NULL);
+INSERT INTO menu_ref VALUES ('DOCUMENT', 'Document',
'document_modele.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('CFGLEDGER', 'journaux', NULL, NULL, NULL);
+INSERT INTO menu_ref VALUES ('PLANANC', 'Plan Compt. analytique',
'anc_pa.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANCODS', 'Opérations diverses',
'anc_od.inc.php', NULL, NULL);
+INSERT INTO menu_ref VALUES ('ANCGROUP', 'Groupe', 'anc_group.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('ANCIMP', 'Impression', 'anc_imp.inc.php', NULL,
NULL);
+INSERT INTO menu_ref VALUES ('PREFERENCE', 'Préférence', 'pref.inc.php', NULL,
NULL);
--
@@ -361,7 +376,6 @@
--
INSERT INTO profile_menu VALUES (1, 'COMPTA', NULL, 1, 5, 'M');
-INSERT INTO profile_menu VALUES (34, 'GESTION', NULL, 1, 6, 'M');
INSERT INTO profile_menu VALUES (2, 'ANC', NULL, 1, 7, 'M');
INSERT INTO profile_menu VALUES (45, 'PARAM', NULL, 1, 2, 'M');
INSERT INTO profile_menu VALUES (44, 'DASHBOARD', NULL, 1, 1, 'M');
@@ -375,7 +389,6 @@
INSERT INTO profile_menu VALUES (59, 'CFGPAYMENT', 'DIVPARM', 1, 4, 'E');
INSERT INTO profile_menu VALUES (60, 'CFGTVA', 'DIVPARM', 1, 5, 'E');
INSERT INTO profile_menu VALUES (61, 'CFGACCOUNT', 'DIVPARM', 1, 6, 'E');
-INSERT INTO profile_menu VALUES (65, 'CFGCARDCAT', 'DIVPARM', 1, 7, 'e');
INSERT INTO profile_menu VALUES (67, 'CFGCATDOC', 'DIVPARM', 1, 8, 'E');
INSERT INTO profile_menu VALUES (13, 'IMPBILAN', 'IMP', 1, 11, 'E');
INSERT INTO profile_menu VALUES (14, 'IMPCARD', 'IMP', 1, 12, 'E');
@@ -384,18 +397,24 @@
INSERT INTO profile_menu VALUES (17, 'IMPBAL', 'IMP', 1, 15, 'E');
INSERT INTO profile_menu VALUES (68, 'CFGATTRIBCARD', 'DIVPARM', 1, 9, 'E');
INSERT INTO profile_menu VALUES (69, 'CFGPCMN', 'PARAM', 1, 4, 'E');
+INSERT INTO profile_menu VALUES (70, 'CFGEXTENSION', 'PARAM', 1, 5, 'E');
INSERT INTO profile_menu VALUES (20, 'LOGOUT', NULL, 1, 19, 'M');
+INSERT INTO profile_menu VALUES (71, 'CFGSECURITY', 'PARAM', 1, 6, 'E');
+INSERT INTO profile_menu VALUES (72, 'PREDOP', 'PARAM', 1, 7, 'E');
+INSERT INTO profile_menu VALUES (73, 'CFGDOCUMENT', 'PARAM', 1, 8, 'E');
+INSERT INTO profile_menu VALUES (74, 'CFGLEDGER', 'PARAM', 1, 9, 'E');
+INSERT INTO profile_menu VALUES (75, 'PLANANC', 'ANC', 1, 1, 'E');
+INSERT INTO profile_menu VALUES (65, 'CFGCARDCAT', 'DIVPARM', 1, 7, 'E');
INSERT INTO profile_menu VALUES (9, 'IMPPOSTE', 'IMP', 1, 8, 'E');
INSERT INTO profile_menu VALUES (10, 'IMPREC', 'IMP', 1, 9, 'E');
INSERT INTO profile_menu VALUES (11, 'IMPREPORT', 'IMP', 1, 10, 'E');
-INSERT INTO profile_menu VALUES (24, 'LETTERCARD', 'LETTER', 1, 1, 'M');
-INSERT INTO profile_menu VALUES (27, 'LETTERACC', 'LETTER', 1, 2, 'M');
-INSERT INTO profile_menu VALUES (28, 'ADV', 'COMPTA', 1, 20, 'M');
-INSERT INTO profile_menu VALUES (29, 'VERIFBIL', 'ADV', 1, 21, 'M');
-INSERT INTO profile_menu VALUES (30, 'STOCK', 'ADV', 1, 22, 'M');
-INSERT INTO profile_menu VALUES (31, 'PREDOP', 'ADV', 1, 23, 'M');
-INSERT INTO profile_menu VALUES (32, 'OPEN', 'ADV', 1, 24, 'M');
-INSERT INTO profile_menu VALUES (33, 'REPORT', 'ADV', 1, 25, 'M');
+INSERT INTO profile_menu VALUES (76, 'ANCODS', 'ANC', 1, 2, 'E');
+INSERT INTO profile_menu VALUES (77, 'ANCGROUP', 'ANC', 1, 3, 'E');
+INSERT INTO profile_menu VALUES (78, 'ANCIMP', 'ANC', 1, 4, 'E');
+INSERT INTO profile_menu VALUES (79, 'PREFERENCE', NULL, 1, 2, 'M');
+INSERT INTO profile_menu VALUES (23, 'LETTER', 'COMPTA', 1, 8, 'E');
+INSERT INTO profile_menu VALUES (24, 'LETTERCARD', 'LETTER', 1, 1, 'E');
+INSERT INTO profile_menu VALUES (27, 'LETTERACC', 'LETTER', 1, 2, 'E');
INSERT INTO profile_menu VALUES (37, 'CUST', 'GESTION', 1, 1, 'E');
INSERT INTO profile_menu VALUES (38, 'SUPPL', 'GESTION', 1, 2, 'E');
INSERT INTO profile_menu VALUES (39, 'ADM', 'GESTION', 1, 3, 'E');
@@ -404,14 +423,20 @@
INSERT INTO profile_menu VALUES (40, 'STOCK', 'GESTION', 1, 5, 'E');
INSERT INTO profile_menu VALUES (41, 'FORECAST', 'GESTION', 1, 7, 'E');
INSERT INTO profile_menu VALUES (42, 'FOLLOW', 'GESTION', 1, 8, 'E');
-INSERT INTO profile_menu VALUES (43, 'HIST', 'COMPTA', 1, 1, 'M');
+INSERT INTO profile_menu VALUES (29, 'VERIFBIL', 'ADV', 1, 21, 'E');
+INSERT INTO profile_menu VALUES (30, 'STOCK', 'ADV', 1, 22, 'E');
+INSERT INTO profile_menu VALUES (31, 'PREDOP', 'ADV', 1, 23, 'E');
+INSERT INTO profile_menu VALUES (32, 'OPEN', 'ADV', 1, 24, 'E');
+INSERT INTO profile_menu VALUES (33, 'REPORT', 'ADV', 1, 25, 'E');
INSERT INTO profile_menu VALUES (5, 'CARD', 'COMPTA', 1, 7, 'E');
+INSERT INTO profile_menu VALUES (43, 'HIST', 'COMPTA', 1, 1, 'E');
+INSERT INTO profile_menu VALUES (34, 'GESTION', NULL, 1, 6, 'M');
INSERT INTO profile_menu VALUES (4, 'VEN', 'COMPTA', 1, 2, 'E');
INSERT INTO profile_menu VALUES (3, 'ACH', 'COMPTA', 1, 3, 'E');
INSERT INTO profile_menu VALUES (19, 'FIN', 'COMPTA', 1, 4, 'E');
INSERT INTO profile_menu VALUES (18, 'MISC', 'COMPTA', 1, 5, 'E');
INSERT INTO profile_menu VALUES (6, 'IMP', 'COMPTA', 1, 6, 'E');
-INSERT INTO profile_menu VALUES (23, 'LETTER', 'COMPTA', 1, 8, 'M');
+INSERT INTO profile_menu VALUES (28, 'ADV', 'COMPTA', 1, 20, 'E');
--
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4249 - in phpcompta/branches/rel600-dynamic-menu: include sql,
phpcompta-dev <=