[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4318 - in phpcompta/trunk: html include include/templat
|
From: |
phpcompta-dev |
|
Subject: |
[Phpcompta-dev] r4318 - in phpcompta/trunk: html include include/template sql |
|
Date: |
Mon, 7 Nov 2011 22:16:48 +0100 (CET) |
Author: danydb
Date: 2011-11-07 22:16:45 +0100 (Mon, 07 Nov 2011)
New Revision: 4318
Modified:
phpcompta/trunk/html/export.php
phpcompta/trunk/html/popup.php
phpcompta/trunk/html/recherche.php
phpcompta/trunk/include/ac_common.php
phpcompta/trunk/include/balance.inc.php
phpcompta/trunk/include/class_acc_account_ledger.php
phpcompta/trunk/include/class_anc_acc_list.php
phpcompta/trunk/include/class_anc_balance_double.php
phpcompta/trunk/include/class_anc_balance_simple.php
phpcompta/trunk/include/class_anc_group.php
phpcompta/trunk/include/class_anc_listing.php
phpcompta/trunk/include/class_anc_table.php
phpcompta/trunk/include/class_fiche.php
phpcompta/trunk/include/class_user.php
phpcompta/trunk/include/compta_ven.inc.php
phpcompta/trunk/include/history_operation.inc.php
phpcompta/trunk/include/impress_bilan.inc.php
phpcompta/trunk/include/impress_fiche.inc.php
phpcompta/trunk/include/impress_jrn.inc.php
phpcompta/trunk/include/impress_rapport.inc.php
phpcompta/trunk/include/param_sec.inc.php
phpcompta/trunk/include/template/menu.php
phpcompta/trunk/include/template/module.php
phpcompta/trunk/sql/object-6.0.sql
phpcompta/trunk/sql/upgrade.sql
Log:
432: Modularit?\195?\169: impact sur la s?\195?\169curit?\195?\169 des
impressions et export CSV
Add new_line for menu & module
Improve javascript support (module + menu)
Modified: phpcompta/trunk/html/export.php
===================================================================
--- phpcompta/trunk/html/export.php 2011-11-05 23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/html/export.php 2011-11-07 21:16:45 UTC (rev 4318)
@@ -32,144 +32,127 @@
$gDossier=dossier::id();
$cn=new Database($gDossier);
-/**
- address@hidden check the security here
- */
-
$user=new User($cn);
$user->Check();
$act=$user->check_dossier($gDossier);
-if ( $act=='X' || ! isset($_GET['act']) )
+if ( $act=='X' || ! isset($_GET['act']) || $user->check_print($_GET['act'])==0
)
{
echo alert('Accès interdit');
+ redirect("do.php?".dossier::get());
exit();
}
-switch( $_GET['act'])
+
+ switch( $_GET['act'])
{
- case 'CSV/histo':
- $user->can_request(IMPJRN,0);
+ case 'CSV:histo':
require_once('export_histo_csv.php');
exit();
break;
- case 'CSV/ledger':
- $user->can_request(IMPJRN,0);
+ case 'CSV:ledger':
require_once('export_ledger_csv.php');
exit();
break;
- case 'PDF/ledger':
- $user->can_request(IMPJRN,0);
+ case 'PDF:ledger':
require_once('export_ledger_pdf.php');
exit();
break;
- case 'CSV/postedetail':
- $user->can_request(IMPPOSTE,0);
+ case 'CSV:postedetail':
require_once('export_poste_detail_csv.php');
exit();
break;
- case 'PDF/postedetail':
- $user->can_request(IMPPOSTE,0);
+ case 'PDF:postedetail':
require_once('export_poste_detail_pdf.php');
exit();
break;
- case 'CSV/fichedetail':
- $user->can_request(IMPPOSTE,0);
+ case 'CSV:fichedetail':
require_once('export_fiche_detail_csv.php');
exit();
break;
- case 'PDF/fichedetail':
- $user->can_request(IMPPOSTE,0);
+ case 'PDF:fichedetail':
require_once('export_fiche_detail_pdf.php');
exit();
break;
- case 'CSV/fiche_balance':
- $user->can_request(IMPFIC,0);
+ case 'CSV:fiche_balance':
require_once('export_fiche_balance_csv.php');
exit();
break;
- case 'PDF/fiche_balance':
- $user->can_request(IMPFIC,0);
+ case 'PDF:fiche_balance':
require_once('export_fiche_balance_pdf.php');
exit();
break;
- case 'CSV/report':
+ case 'CSV:report':
require_once('export_form_csv.php');
exit();
break;
- case 'PDF/report':
+ case 'PDF:report':
require_once('export_form_pdf.php');
exit();
break;
- case 'CSV/fiche':
- $user->can_request(IMPFIC,0);
+ case 'CSV:fiche':
require_once('export_fiche_csv.php');
exit();
break;
- case 'PDF/fiche':
- $user->can_request(IMPFIC,0);
+ case 'PDF:fiche':
require_once('export_fiche_pdf.php');
exit();
break;
- case 'CSV/glcompte':
- $user->can_request(IMPBIL,0);
+ case 'CSV:glcompte':
require_once('export_gl_csv.php');
exit();
break;
- case 'PDF/glcompte':
- $user->can_request(IMPBIL,0);
+ case 'PDF:glcompte':
require_once('export_gl_pdf.php');
exit();
break;
- case 'PDF/sec':
- $user->can_request(PARSEC,1);
+ case 'PDF:sec':
require_once('export_security_pdf.php');
exit();
break;
- case 'CSV/AncList':
+ case 'CSV:AncList':
require_once('export_anc_list_csv.php');
exit();
break;
- case 'CSV/AncBalSimple':
+ case 'CSV:AncBalSimple':
require_once('export_anc_balance_simple_csv.php');
exit();
break;
- case 'PDF/AncBalSimple':
+ case 'PDF:AncBalSimple':
require_once('export_anc_balance_simple_pdf.php');
exit();
break;
- case 'CSV/AncBalDouble':
+ case 'CSV:AncBalDouble':
require_once('export_anc_balance_double_csv.php');
exit();
break;
- case 'PDF/AncBalDouble':
+ case 'PDF:AncBalDouble':
require_once('export_anc_balance_double_pdf.php');
exit();
break;
- case 'CSV/balance':
+ case 'CSV:balance':
require_once('export_balance_csv.php');
exit();
break;
- case 'PDF/balance':
+ case 'PDF:balance':
require_once('export_balance_pdf.php');
exit();
break;
- case 'CSV/AncTable':
+ case 'CSV:AncTable':
require_once('export_anc_table_csv.php');
exit();
break;
- case 'CSV/AncAccList':
+ case 'CSV:AncAccList':
require_once('export_anc_acc_list_csv.php');
exit();
break;
- case 'CSV/AncBalGroup':
+ case 'CSV:AncBalGroup':
require_once('export_anc_balance_group_csv.php');
exit();
break;
- case 'OTH/Bilan':
- $user->can_request(IMPBIL);
+ case 'OTH:Bilan':
require_once 'export_bilan_oth.php';
exit();
break;
Modified: phpcompta/trunk/html/popup.php
===================================================================
--- phpcompta/trunk/html/popup.php 2011-11-05 23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/html/popup.php 2011-11-07 21:16:45 UTC (rev 4318)
@@ -42,13 +42,13 @@
if (isset($_GET['pcm_val']) )
{
-
$href_csv="export.php?".$href.'&poste_id='.$_GET['pcm_val'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=CSV/postedetail";
-
$href_pdf="export.php?".$href.'&poste_id='.$_GET['pcm_val'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=PDF/postedetail";;
+
$href_csv="export.php?".$href.'&poste_id='.$_GET['pcm_val'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=CSV:postedetail";
+
$href_pdf="export.php?".$href.'&poste_id='.$_GET['pcm_val'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=PDF:postedetail";;
}
else
{
-
$href_csv="export.php?".$href.'&f_id='.$_GET['f_id'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=CSV/fichedetail";
-
$href_pdf="export.php?".$href.'&f_id='.$_GET['f_id'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=PDF/fichedetail";
+
$href_csv="export.php?".$href.'&f_id='.$_GET['f_id'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=CSV:fichedetail";
+
$href_pdf="export.php?".$href.'&f_id='.$_GET['f_id'].'&ople=0&type=poste&'.$from_periode.'&'.$to_periode."&act=PDF:fichedetail";
}
echo '<a class="button" href="'.$href_csv.'">Export CSV</a>';
Modified: phpcompta/trunk/html/recherche.php
===================================================================
--- phpcompta/trunk/html/recherche.php 2011-11-05 23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/html/recherche.php 2011-11-07 21:16:45 UTC (rev 4318)
@@ -99,7 +99,7 @@
}
echo '<form action="export.php" method="get">';
echo $r;
- echo HtmlInput::hidden('act','CSV/histo');
+ echo HtmlInput::hidden('act','CSV:histo');
echo HtmlInput::submit('viewsearch','Export vers CSV');
echo HtmlInput::hidden('p_action','ALL');
echo '</form>';
Modified: phpcompta/trunk/include/ac_common.php
===================================================================
--- phpcompta/trunk/include/ac_common.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/ac_common.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -737,7 +737,7 @@
global $g_user;
$cn = Dossier::connect();
$amodule = $cn->get_array("select
- me_code,me_menu,me_url
+ me_code,me_menu,me_url,me_javascript,p_order
from v_all_menu
where
user_name=$1
@@ -826,7 +826,7 @@
global $g_user;
$cn = Dossier::connect();
$amenu = $cn->get_array("select
- me_menu,me_code
+ me_menu,me_code,me_url,me_javascript
from v_all_menu
where
me_code_dep=$1 and user_name=$2 order by p_order", array($module[$idx],
$g_user->login));
@@ -852,7 +852,7 @@
$file = $cn->get_array("select
me_file,me_parameter,me_javascript
from menu_ref
where
- me_code=$1 and
+ me_code=$1 and
(me_file is not null or trim(me_file) <>'' or
me_javascript is not null or trim (me_javascript) <> '')",
array($module[$idx]));
Modified: phpcompta/trunk/include/balance.inc.php
===================================================================
--- phpcompta/trunk/include/balance.inc.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/balance.inc.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -179,7 +179,7 @@
dossier::hidden().
HtmlInput::submit('bt_pdf',"Export PDF").
HtmlInput::hidden("ac",$_REQUEST['ac']).
- HtmlInput::hidden("act","PDF/balance").
+ HtmlInput::hidden("act","PDF:balance").
HtmlInput::hidden("from_periode",$_GET['from_periode']).
HtmlInput::hidden("to_periode",$_GET['to_periode']);
@@ -200,7 +200,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.
HtmlInput::submit('bt_csv',"Export CSV").
dossier::hidden().
- HtmlInput::hidden("act","CSV/balance").
+ HtmlInput::hidden("act","CSV:balance").
HtmlInput::hidden("from_periode",$_GET['from_periode']).
HtmlInput::hidden("to_periode",$_GET['to_periode']);
echo HtmlInput::get_to_hidden(array('ac'));
Modified: phpcompta/trunk/include/class_acc_account_ledger.php
===================================================================
--- phpcompta/trunk/include/class_acc_account_ledger.php 2011-11-05
23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/include/class_acc_account_ledger.php 2011-11-07
21:16:45 UTC (rev 4318)
@@ -429,12 +429,12 @@
switch($actiontarget)
{
case 'poste':
- $action_csv='CSV/postedetail';
- $action_pdf='PDF/postedetail';
+ $action_csv='CSV:postedetail';
+ $action_pdf='PDF:postedetail';
break;
case 'gl_comptes':
- $action_csv='CSV/glcompte';
- $action_pdf='PDF/glcompte';
+ $action_csv='CSV:glcompte';
+ $action_pdf='PDF:glcompte';
break;
default:
throw new Exception(" Fonction HtmlTableHeader argument actiontarget
invalid");
Modified: phpcompta/trunk/include/class_anc_acc_list.php
===================================================================
--- phpcompta/trunk/include/class_anc_acc_list.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/class_anc_acc_list.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -189,7 +189,7 @@
{
$r="";
$r.= '<form method="GET" action="export.php" style="display:inline">';
- $r.= HtmlInput::hidden("act","CSV/AncAccList");
+ $r.= HtmlInput::hidden("act","CSV:AncAccList");
$r.= HtmlInput::hidden("to",$this->to);
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
Modified: phpcompta/trunk/include/class_anc_balance_double.php
===================================================================
--- phpcompta/trunk/include/class_anc_balance_double.php 2011-11-05
23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/include/class_anc_balance_double.php 2011-11-07
21:16:45 UTC (rev 4318)
@@ -354,7 +354,7 @@
$r.= '<form method="GET" action="export.php" style="display:inline">';
$r.= $p_string;
$r.= HtmlInput::hidden("to",$this->to);
- $r.= HtmlInput::hidden("act","PDF/AncBalDouble");
+ $r.= HtmlInput::hidden("act","PDF:AncBalDouble");
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
$r.= HtmlInput::hidden("from_poste",$this->from_poste);
@@ -368,7 +368,7 @@
$r.= '<form method="GET" action="export.php" style="display:inline">';
$r.= HtmlInput::hidden("to",$this->to);
- $r.= HtmlInput::hidden("act","CSV/AncBalDouble");
+ $r.= HtmlInput::hidden("act","CSV:AncBalDouble");
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
$r.= HtmlInput::hidden("from_poste",$this->from_poste);
Modified: phpcompta/trunk/include/class_anc_balance_simple.php
===================================================================
--- phpcompta/trunk/include/class_anc_balance_simple.php 2011-11-05
23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/include/class_anc_balance_simple.php 2011-11-07
21:16:45 UTC (rev 4318)
@@ -246,7 +246,7 @@
$r.= $p_string;
$r.= dossier::hidden();
$r.= HtmlInput::hidden("to",$this->to);
- $r.= HtmlInput::hidden("act","PDF/AncBalSimple");
+ $r.= HtmlInput::hidden("act","PDF:AncBalSimple");
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
@@ -256,7 +256,7 @@
$r.= '</form>';
$r.= '<form method="GET" action="export.php" style="display:inline">';
- $r.= HtmlInput::hidden("act","CSV/AncBalSimple");
+ $r.= HtmlInput::hidden("act","CSV:AncBalSimple");
$r.= HtmlInput::hidden("to",$this->to);
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
Modified: phpcompta/trunk/include/class_anc_group.php
===================================================================
--- phpcompta/trunk/include/class_anc_group.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/class_anc_group.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -205,7 +205,7 @@
{
$r="";
$r.= '<form method="GET" action="export.php" style="display:inline">';
- $r.= HtmlInput::hidden("act","CSV/AncBalGroup");
+ $r.= HtmlInput::hidden("act","CSV:AncBalGroup");
$r.= HtmlInput::hidden("to",$this->to);
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
Modified: phpcompta/trunk/include/class_anc_listing.php
===================================================================
--- phpcompta/trunk/include/class_anc_listing.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/class_anc_listing.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -189,7 +189,7 @@
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
$r.= HtmlInput::hidden("from_poste",$this->from_poste);
$r.= HtmlInput::hidden("to_poste",$this->to_poste);
- $r.=HtmlInput::hidden('act','CSV/AncList');
+ $r.=HtmlInput::hidden('act','CSV:AncList');
$r.= $p_string;
$r.= dossier::hidden();
$r.=HtmlInput::submit('bt_csv',"Export en CSV");
Modified: phpcompta/trunk/include/class_anc_table.php
===================================================================
--- phpcompta/trunk/include/class_anc_table.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/class_anc_table.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -103,7 +103,7 @@
{
$r="";
$r.= '<form method="GET" action="export.php" style="display:inline">';
- $r.= HtmlInput::hidden("act","CSV/AncTable");
+ $r.= HtmlInput::hidden("act","CSV:AncTable");
$r.= HtmlInput::hidden("to",$this->to);
$r.= HtmlInput::hidden("from",$this->from);
$r.= HtmlInput::hidden("pa_id",$this->pa_id);
Modified: phpcompta/trunk/include/class_fiche.php
===================================================================
--- phpcompta/trunk/include/class_fiche.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/class_fiche.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -1386,7 +1386,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.
HtmlInput::submit('bt_pdf',"Export PDF").
dossier::hidden().$str_ople.
- HtmlInput::hidden('act','PDF/fichedetail').
+ HtmlInput::hidden('act','PDF:fichedetail').
$hid->input("type","poste").
$hid->input('p_action','impress').
$hid->input("f_id",$this->id).
@@ -1400,7 +1400,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.
HtmlInput::submit('bt_csv',"Export CSV").
- HtmlInput::hidden('act','PDF/fichedetail').
+ HtmlInput::hidden('act','PDF:fichedetail').
dossier::hidden().$str_ople.
$hid->input("type","poste").
$hid->input('p_action','impress').
Modified: phpcompta/trunk/include/class_user.php
===================================================================
--- phpcompta/trunk/include/class_user.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/class_user.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -688,6 +688,51 @@
}
}
+ /**
+ * !\brief Check if the user can print (in menu_ref p_type_display=p)
+ * otherwise warn and exit
+ * \param $p_action requested action
+ * \return nothing the program exits automatically
+ */
+ function check_print($p_action)
+ {
+ global $audit,$cn;
+ if ($this->Admin() == 1)
+ return 1;
+ if ($this->is_local_admin(dossier::id()) == 1)
+ return 1;
+ $res=$cn->get_value("select count(*) from profile_menu
+ join profile_user using (p_id)
+ where user_name=$1 and me_code=$2 ",
+ array($this->login,$p_action));
+ return $res;
+
+ }
+ /* !\brief Check if the user can print (in menu_ref p_type_display=p)
+ * otherwise warn and exit
+ * \param $p_action requested action
+ * \return nothing the program exits automatically
+ */
+
+ function can_print($p_action, $p_js=0)
+ {
+ if ($this->check_print($p_action) == 0)
+ {
+ if ($p_js == 1)
+ {
+ echo "<script>";
+ echo "alert ('Cette action ne vous est pas
autorisée. Contactez votre responsable');";
+ echo "</script>";
+ }
+ else
+ {
+ echo '<div class="u_redcontent">';
+ echo '<h2 class="error"> Cette action ne vous
est pas autorisée Contactez votre responsable</h2>';
+ echo '</div>';
+ }
+ exit(-1);
+ }
+ }
/* !
* \brief Check if an user is an local administrator
*
Modified: phpcompta/trunk/include/compta_ven.inc.php
===================================================================
--- phpcompta/trunk/include/compta_ven.inc.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/compta_ven.inc.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -332,7 +332,7 @@
}
echo '<form action="export.php" method="get">';
echo $r;
- echo HtmlInput::hidden('act','CSV/histo');
+ echo HtmlInput::hidden('act','CSV:histo');
echo HtmlInput::submit('viewsearch','Export vers CSV');
echo '</form>';
Modified: phpcompta/trunk/include/history_operation.inc.php
===================================================================
--- phpcompta/trunk/include/history_operation.inc.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/history_operation.inc.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -137,7 +137,7 @@
}
echo '<form action="export.php" method="get">';
echo $r;
-echo HtmlInput::hidden('act', 'CSV/histo');
+echo HtmlInput::hidden('act', 'CSV:histo');
echo HtmlInput::submit('viewsearch', 'Export vers CSV');
echo '</form>';
Modified: phpcompta/trunk/include/impress_bilan.inc.php
===================================================================
--- phpcompta/trunk/include/impress_bilan.inc.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/impress_bilan.inc.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -78,7 +78,7 @@
echo dossier::hidden();
echo HtmlInput::get_to_hidden(array('exercice'));
echo HtmlInput::hidden('b_id',$_GET['b_id']);
- echo HtmlInput::hidden('act','OTH/Bilan');
+ echo HtmlInput::hidden('act','OTH:Bilan');
echo HtmlInput::hidden('from_periode',$bilan->from);
echo HtmlInput::hidden('to_periode',$bilan->to);
Modified: phpcompta/trunk/include/impress_fiche.inc.php
===================================================================
--- phpcompta/trunk/include/impress_fiche.inc.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/impress_fiche.inc.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -105,7 +105,7 @@
$hid=new IHidden();
echo '<form method="GET" ACTION="export.php">'.dossier::hidden().
HtmlInput::submit('bt_csv',"Export CSV").
- HtmlInput::hidden('act',"CSV/fiche").
+ HtmlInput::hidden('act',"CSV:fiche").
$hid->input("type","fiche").
$hid->input("ac",$_REQUEST['ac']).
$hid->input("fd_id",$_REQUEST['cat']);
@@ -115,7 +115,7 @@
}
$export_pdf='<FORM METHOD="get" ACTION="export.php" style="display:inline">';
$export_pdf.=HtmlInput::hidden('cat',$_GET['cat']);
-$export_pdf.=HtmlInput::hidden('act',"PDF/fiche_balance").
+$export_pdf.=HtmlInput::hidden('act',"PDF:fiche_balance").
$export_pdf.=HtmlInput::hidden('start',$_GET['start']);
$export_pdf.=HtmlInput::hidden('end',$_GET['end']);
$export_pdf.=HtmlInput::hidden('histo',$_GET['histo']);
@@ -125,7 +125,7 @@
$export_csv='<FORM METHOD="get" ACTION="export.php" style="display:inline">';
$export_csv.=HtmlInput::hidden('cat',$_GET['cat']);
-$export_csv.=HtmlInput::hidden('act','CSV/fiche_balance');
+$export_csv.=HtmlInput::hidden('act','CSV:fiche_balance');
$export_csv.=HtmlInput::hidden('start',$_GET['start']);
$export_csv.=HtmlInput::hidden('end',$_GET['end']);
$export_csv.=HtmlInput::hidden('histo',$_GET['histo']);
Modified: phpcompta/trunk/include/impress_jrn.inc.php
===================================================================
--- phpcompta/trunk/include/impress_jrn.inc.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/impress_jrn.inc.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -170,7 +170,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.dossier::hidden().
HtmlInput::submit('bt_pdf',"Export PDF").
- HtmlInput::hidden('act','PDF/ledger').
+ HtmlInput::hidden('act','PDF:ledger').
$hid->input("type","jrn").
$hid->input("jrn_id",$Jrn->id).
$hid->input("from_periode",$_GET['from_periode']).
@@ -181,7 +181,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.dossier::hidden().
HtmlInput::submit('bt_csv',"Export CSV").
- HtmlInput::hidden('act','CSV/ledger').
+ HtmlInput::hidden('act','CSV:ledger').
$hid->input("type","jrn").
$hid->input("jrn_id",$Jrn->id).
$hid->input("from_periode",$_GET['from_periode']).
Modified: phpcompta/trunk/include/impress_rapport.inc.php
===================================================================
--- phpcompta/trunk/include/impress_rapport.inc.php 2011-11-05 23:39:54 UTC
(rev 4317)
+++ phpcompta/trunk/include/impress_rapport.inc.php 2011-11-07 21:16:45 UTC
(rev 4318)
@@ -94,7 +94,7 @@
echo '<TD><form method="GET" ACTION="export.php">'.
HtmlInput::submit('bt_pdf',"Export PDF").
- HtmlInput::hidden('act','PDF/report').
+ HtmlInput::hidden('act','PDF:report').
dossier::hidden().
$hid->input("type","rapport").
$hid->input("ac",$_GET['ac']).
@@ -111,7 +111,7 @@
echo "</form></TD>";
echo '<TD><form method="GET" ACTION="export.php">'.
- HtmlInput::hidden('act','CSV/report').
+ HtmlInput::hidden('act','CSV:report').
HtmlInput::submit('bt_csv',"Export CSV").
dossier::hidden().
$hid->input("type","form").
Modified: phpcompta/trunk/include/param_sec.inc.php
===================================================================
--- phpcompta/trunk/include/param_sec.inc.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/param_sec.inc.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -208,7 +208,7 @@
$sec_User=new User($cn_dossier,$_GET['user_id']);
echo '<form method="post">';
- $sHref=sprintf
('export.php?p_action=sec&act=PDF/sec&user_id=%s&'.$str_dossier ,
+ $sHref=sprintf
('export.php?p_action=sec&act=PDF:sec&user_id=%s&'.$str_dossier ,
$_GET ['user_id']
);
Modified: phpcompta/trunk/include/template/menu.php
===================================================================
--- phpcompta/trunk/include/template/menu.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/template/menu.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -26,14 +26,27 @@
else:
$class="mtitle";
$url="";$pt="";
-
+ $js="";
for ($e=0;$e <= $idx;$e++):
- $url.=$pt.$module[$e];
- $pt="/";
+ $url.=$pt.$module[$e];
+ $pt="/";
endfor;
- $url.=$pt.$amenu[$i]['me_code'];
+ if ( $amenu[$i]['me_url']!='')
+ {
+ $url=$row['me_url'];
+ }
+ elseif ($amenu[$i]['me_javascript'] != '')
+ {
+ $url="javascript:void(0)";
+ $js=sprintf('
onclick="%s"',$amenu[$i]['me_javascript']);
+ }
+ else
+ {
+ $url.=$pt.$amenu[$i]['me_code'];
+ }
+
?> <td class="<?=$class?>">
- <a class="mtitle"
href="do.php?gDossier=<?=Dossier::id()?>&ac=<?=$url?>">
+ <a class="mtitle"
href="do.php?gDossier=<?=Dossier::id()?>&ac=<?=$url?>" <?=$js?> >
<?=$amenu[$i]['me_menu']?>
</a>
</td>
Modified: phpcompta/trunk/include/template/module.php
===================================================================
--- phpcompta/trunk/include/template/module.php 2011-11-05 23:39:54 UTC (rev
4317)
+++ phpcompta/trunk/include/template/module.php 2011-11-07 21:16:45 UTC (rev
4318)
@@ -22,9 +22,9 @@
<tr>
<?php
foreach ($amodule as $row):
-
+ $js="";
$style="background:white";
- if ( $row['me_menu']=='new_line')
+ if ( $row['me_code']=='new_line')
{
echo "</tr><tr>";
continue;
@@ -37,12 +37,17 @@
{
$url=$row['me_url'];
}
- else
+ elseif ($row['me_javascript'] != '')
+ {
+ $url="javascript:void(0)";
+ $js=sprintf('
onclick="%s"',$row['me_javascript']);
+ }
+ else
{
-
$url="do.php?gDossier=".Dossier::id()."&ac=".$row['me_code'];
+
$url="do.php?gDossier=".Dossier::id()."&ac=".$row['me_code'];
}
?>
- <td class="tool" style="<?=$style?>"><a class="mtitle"
href="<?=$url?>"><?=$row['me_menu']?></td>
+ <td class="tool" style="<?=$style?>"><a class="mtitle"
href="<?=$url?>" <?=$js?> ><?=$row['me_menu']?></td>
<?
endforeach;
?>
Modified: phpcompta/trunk/sql/object-6.0.sql
===================================================================
--- phpcompta/trunk/sql/object-6.0.sql 2011-11-05 23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/sql/object-6.0.sql 2011-11-07 21:16:45 UTC (rev 4318)
@@ -26,7 +26,8 @@
me_url text,
me_description text,
me_parameter text,
- me_javascript text
+ me_javascript text,
+ me_type character varying(2)
);
@@ -61,6 +62,16 @@
--
+-- Name: COLUMN menu_ref.me_type; Type: COMMENT; Schema: public; Owner: dany
+--
+
+COMMENT ON COLUMN menu_ref.me_type IS 'ME for menu
+PR for Printing
+SP for special meaning (ex: return to line)
+PL for plugin';
+
+
+--
-- Name: profile; Type: TABLE; Schema: public; Owner: dany; Tablespace:
--
@@ -172,7 +183,7 @@
-- Name: profile_menu_pm_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
dany
--
-SELECT pg_catalog.setval('profile_menu_pm_id_seq', 153, true);
+SELECT pg_catalog.setval('profile_menu_pm_id_seq', 156, true);
--
@@ -300,110 +311,111 @@
-- Data for Name: menu_ref; Type: TABLE DATA; Schema: public; Owner: dany
--
-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);
+INSERT INTO menu_ref VALUES ('ACH', 'Achat', 'compta_ach.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CSV:AncBalGroup', 'Export Balance groupe
analytique', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('OTH:Bilan', 'Export Bilan', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:ledger', 'Export Journaux', NULL, NULL,
NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:postedetail', 'Export Poste détail', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:postedetail', 'Export Poste détail', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:fichedetail', 'Export Fiche détail', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('SEARCH', 'Recherche', NULL, NULL, NULL, NULL,
'popup_recherche()', 'ME');
+INSERT INTO menu_ref VALUES ('COMPANY', 'Sociétés', 'company.inc.php', NULL,
'Parametre societe', NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PERIODE', 'Période', 'periode.inc.php', NULL,
'Gestion des périodes', NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('DIVPARM', 'Divers', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGPAYMENT', 'Moyen de paiement',
'payment_middle.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGTVA', 'TVA', 'tva.inc.php', NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGACCOUNT', 'Poste', 'poste.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CARD', 'Fiche', 'fiche.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('STOCK', 'Stock', 'stock.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('VEN', 'Vente', 'compta_ven.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PDF:fichedetail', 'Export Fiche détail', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:fiche_balance', 'Export Fiche balance',
NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('ODSIMP', 'Historique opérations diverses',
'history_operation.inc.php', NULL, NULL, 'ledger_type=ODS', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('LET', 'Lettrage', 'letter.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PREOD', 'Opérations prédéfinies',
'preod.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('VERIFBIL', 'Vérification ',
'verif_bilan.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('REPORT', 'Création de rapport',
'report.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('OPEN', 'Ecriture Ouverture', 'opening.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ACHIMP', 'Historique achat',
'history_operation.inc.php', NULL, NULL, 'ledger_type=ACH', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FOLLOW', 'Courrier', 'action.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FORECAST', 'Prévision', 'forecast.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPJRN', 'Historique', 'impress_jrn.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('LETTER', 'Lettrage', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGSECURITY', 'Sécurité', 'param_sec.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('LETTERCARD', 'Let. Fiche',
'lettering.card.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('LETTERACC', 'Let. Poste',
'lettering.account.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ADV', 'Avancé', NULL, NULL, NULL, NULL, NULL,
'ME');
+INSERT INTO menu_ref VALUES ('ANC', 'Compta Analytique', NULL, NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGDOCUMENT', 'Document',
'document_modele.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('DOCUMENT', 'Document',
'document_modele.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PLANANC', 'Plan Compt. analytique',
'anc_pa.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ANCODS', 'Opérations diverses',
'anc_od.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ANCGROUP', 'Groupe', 'anc_group.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ANCIMP', 'Impression', 'anc_imp.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('VENMENU', 'Vente / Recette', NULL, NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PREFERENCE', 'Préférence', 'pref.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('HIST', 'Historique',
'history_operation.inc.php', NULL, NULL, 'ledger_type=ALL', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('MENUFIN', 'Financier', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('TVA', 'Tva', 'extension_get.inc.php', NULL,
NULL, 'plugin_code=AMORTIS', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('EXTENSION', 'Extension',
'extension_choice.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('MENUACH', 'Achat', NULL, NULL, NULL, NULL, NULL,
'ME');
+INSERT INTO menu_ref VALUES ('MENUODS', 'Opérations diverses', NULL, NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ODS', 'Opérations Diverses',
'compta_ods.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FINIMP', 'Historique financier',
'history_operation.inc.php', NULL, NULL, 'ledger_type=FIN', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ADM', 'Administration', 'adm.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FIN', 'Nouvel extrait', 'compta_fin.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FINSALDO', 'Soldes', 'compta_fin_saldo.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('FINREC', 'Rapprochement',
'compta_fin_rec.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('ACCESS', 'Dossier', NULL, 'user_login.php',
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('JSSEARCH', 'Recherche', NULL, NULL, NULL, NULL,
'search_reconcile()', 'ME');
+INSERT INTO menu_ref VALUES ('CFGLEDGER', 'journaux', 'cfgledger.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPREC', 'Rapprochement', 'impress_rec.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPPOSTE', 'Poste', 'impress_poste.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPREPORT', 'Rapport',
'impress_rapport.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPBILAN', 'Bilan', 'impress_bilan.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPGL', 'Grand Livre',
'impress_gl_comptes.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPBAL', 'Balance', 'balance.inc.php', NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMPCARD', 'Catégorie de Fiches',
'impress_fiche.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CUSTDET', 'Fiche', 'detail_client.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CUSTFOLLOW', 'Suivi', 'suivi_client.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CUSTOP', 'Opération',
'operation_client.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGCARDCAT', 'Catégorie de fiche',
'fiche_def.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CUST', 'Client', 'client.inc.php', NULL, NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGCATDOC', 'Catégorie de documents',
'cat_document.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('VENIMP', 'Historique vente',
'history_operation.inc.php', NULL, NULL, 'ledger_type=VEN', NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGATTRIBCARD', 'Attribut de fiche',
'card_attr.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGPCMN', 'Plan Comptable',
'param_pcmn.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PARAM', 'Paramètre', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('GESTION', 'Gestion', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CUSTCONTACT', 'Contact (à faire)', NULL, NULL,
NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('CFGEXTENSION', 'Extension', 'extension.inc.php',
NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('COMPTA', 'Comptabilité', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('LOGOUT', 'Sortie', NULL, 'logout.php', NULL,
NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('DASHBOARD', 'Tableau de bord',
'dashboard.inc.php', NULL, NULL, NULL, NULL, 'ME');
+INSERT INTO menu_ref VALUES ('IMP', 'Impression', NULL, NULL, NULL, NULL,
NULL, 'ME');
+INSERT INTO menu_ref VALUES ('PDF:fiche_balance', 'Export Fiche balance',
NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:report', 'Export report', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:report', 'Export report', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:fiche', 'Export Fiche', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:fiche', 'Export Fiche', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:glcompte', 'Export Grand Livre', NULL, NULL,
NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:glcompte', 'Export Grand Livre', NULL, NULL,
NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:sec', 'Export Sécurité', NULL, NULL, NULL,
NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:AncList', 'Export Comptabilité analytique',
NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:AncBalSimple', 'Export Comptabilité
analytique balance simple', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:AncBalSimple', 'Export Comptabilité
analytique', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:AncBalDouble', 'Export Comptabilité
analytique balance double', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:AncBalDouble', 'Export Comptabilité
analytique balance double', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:balance', 'Export Balance comptable', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('PDF:balance', 'Export Balance comptable', NULL,
NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:histo', 'Export Historique', NULL, NULL,
NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:ledger', 'Export Journaux', NULL, NULL,
NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:AncTable', 'Export Tableau Analytique',
NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('CSV:AncAccList', 'Export Historique Compt.
Analytique', NULL, NULL, NULL, NULL, NULL, 'PR');
+INSERT INTO menu_ref VALUES ('new_line', NULL, NULL, NULL, 'Saut de ligne',
NULL, NULL, 'SP');
--
@@ -419,10 +431,8 @@
-- Data for Name: profile_menu; Type: TABLE DATA; Schema: public; Owner: dany
--
-INSERT INTO profile_menu VALUES (45, 'PARAM', NULL, 1, 2, 'M', NULL);
INSERT INTO profile_menu VALUES (51, 'COMPTA', NULL, 3, 1, 'M', NULL);
INSERT INTO profile_menu VALUES (52, 'VEN', 'COMPTA', 3, 1, 'E', NULL);
-INSERT INTO profile_menu VALUES (53, 'ACCESS', NULL, 1, 18, 'M', NULL);
INSERT INTO profile_menu VALUES (54, 'COMPANY', 'PARAM', 1, 1, 'E', NULL);
INSERT INTO profile_menu VALUES (55, 'PERIODE', 'PARAM', 1, 2, 'E', NULL);
INSERT INTO profile_menu VALUES (56, 'DIVPARM', 'PARAM', 1, 3, 'E', NULL);
@@ -438,7 +448,6 @@
INSERT INTO profile_menu VALUES (68, 'CFGATTRIBCARD', 'DIVPARM', 1, 9, 'E',
NULL);
INSERT INTO profile_menu VALUES (69, 'CFGPCMN', 'PARAM', 1, 4, 'E', NULL);
INSERT INTO profile_menu VALUES (70, 'CFGEXTENSION', 'PARAM', 1, 5, 'E', NULL);
-INSERT INTO profile_menu VALUES (20, 'LOGOUT', NULL, 1, 19, 'M', NULL);
INSERT INTO profile_menu VALUES (71, 'CFGSECURITY', 'PARAM', 1, 6, 'E', NULL);
INSERT INTO profile_menu VALUES (72, 'PREDOP', 'PARAM', 1, 7, 'E', NULL);
INSERT INTO profile_menu VALUES (73, 'CFGDOCUMENT', 'PARAM', 1, 8, 'E', NULL);
@@ -469,61 +478,63 @@
INSERT INTO profile_menu VALUES (33, 'REPORT', 'ADV', 1, 25, 'E', NULL);
INSERT INTO profile_menu VALUES (5, 'CARD', 'COMPTA', 1, 7, 'E', NULL);
INSERT INTO profile_menu VALUES (43, 'HIST', 'COMPTA', 1, 1, 'E', NULL);
-INSERT INTO profile_menu VALUES (34, 'GESTION', NULL, 1, 6, 'M', NULL);
INSERT INTO profile_menu VALUES (94, 'FINSALDO', 'MENUFIN', 1, 3, 'E', NULL);
INSERT INTO profile_menu VALUES (95, 'FINREC', 'MENUFIN', 1, 4, 'E', NULL);
+INSERT INTO profile_menu VALUES (79, 'PREFERENCE', NULL, 1, 15, 'M', NULL);
INSERT INTO profile_menu VALUES (6, 'IMP', 'COMPTA', 1, 6, 'E', NULL);
INSERT INTO profile_menu VALUES (28, 'ADV', 'COMPTA', 1, 20, 'E', NULL);
-INSERT INTO profile_menu VALUES (79, 'PREFERENCE', 'ANC', 1, 2, 'M', NULL);
-INSERT INTO profile_menu VALUES (44, 'DASHBOARD', NULL, 1, 1, 'M', 0);
-INSERT INTO profile_menu VALUES (1, 'COMPTA', NULL, 1, 5, 'M', 0);
-INSERT INTO profile_menu VALUES (2, 'ANC', NULL, 1, 7, 'M', 1);
+INSERT INTO profile_menu VALUES (45, 'PARAM', NULL, 1, 20, 'M', NULL);
+INSERT INTO profile_menu VALUES (53, 'ACCESS', NULL, 1, 25, 'M', NULL);
+INSERT INTO profile_menu VALUES (123, 'CSV:histo', NULL, 1, NULL, 'P', NULL);
+INSERT INTO profile_menu VALUES (20, 'LOGOUT', NULL, 1, 30, 'M', NULL);
+INSERT INTO profile_menu VALUES (44, 'DASHBOARD', NULL, 1, 10, 'M', 1);
+INSERT INTO profile_menu VALUES (156, 'new_line', NULL, 1, 35, 'M', NULL);
+INSERT INTO profile_menu VALUES (124, 'CSV:ledger', NULL, 1, NULL, 'P', NULL);
INSERT INTO profile_menu VALUES (80, 'PLANANC', 'ANC', 2, 1, 'E', NULL);
-INSERT INTO profile_menu VALUES (50, 'ANC', NULL, 2, 1, 'M', 1);
-INSERT INTO profile_menu VALUES (82, 'EXTENSION', NULL, 1, 100, 'M', NULL);
-INSERT INTO profile_menu VALUES (83, 'TVA', NULL, 1, 101, 'M', 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 (84, 'TVA', 'PARAM', 1, 102, 'E', NULL);
+INSERT INTO profile_menu VALUES (1, 'COMPTA', NULL, 1, 40, 'M', 0);
INSERT INTO profile_menu VALUES (3, 'MENUACH', 'COMPTA', 1, 3, 'E', NULL);
-INSERT INTO profile_menu VALUES (85, 'ACH', 'MENUACH', 1, 1, 'E', NULL);
INSERT INTO profile_menu VALUES (86, 'ACHIMP', 'MENUACH', 1, 2, 'E', NULL);
+INSERT INTO profile_menu VALUES (34, 'GESTION', NULL, 1, 45, 'M', NULL);
INSERT INTO profile_menu VALUES (18, 'MENUODS', 'COMPTA', 1, 5, 'E', NULL);
INSERT INTO profile_menu VALUES (88, 'ODS', 'MENUODS', 1, 1, 'E', NULL);
INSERT INTO profile_menu VALUES (89, 'ODSIMP', 'MENUODS', 1, 2, 'E', NULL);
+INSERT INTO profile_menu VALUES (2, 'ANC', NULL, 1, 50, 'M', 0);
INSERT INTO profile_menu VALUES (4, 'VENMENU', 'COMPTA', 1, 2, 'E', NULL);
INSERT INTO profile_menu VALUES (90, 'VEN', 'VENMENU', 1, 1, 'E', NULL);
INSERT INTO profile_menu VALUES (91, 'VENIMP', 'VENMENU', 1, 2, 'E', NULL);
+INSERT INTO profile_menu VALUES (82, 'EXTENSION', NULL, 1, 55, 'M', NULL);
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);
+INSERT INTO profile_menu VALUES (151, 'SEARCH', NULL, 1, 60, 'M', NULL);
+INSERT INTO profile_menu VALUES (85, 'ACH', 'MENUACH', 1, 1, 'E', NULL);
+INSERT INTO profile_menu VALUES (127, 'PDF:postedetail', NULL, 1, NULL, 'P',
NULL);
+INSERT INTO profile_menu VALUES (50, 'ANC', NULL, 2, 1, 'M', 0);
+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);
--
@@ -574,10 +585,10 @@
--
--- Name: fki_profile_menu_menu_ref; Type: INDEX; Schema: public; Owner: dany;
Tablespace:
+-- Name: fki_profile_menu_me_code; Type: INDEX; Schema: public; Owner: dany;
Tablespace:
--
-CREATE INDEX fki_profile_menu_menu_ref ON profile_menu USING btree (me_code);
+CREATE INDEX fki_profile_menu_me_code ON profile_menu USING btree (me_code);
--
@@ -592,7 +603,7 @@
--
ALTER TABLE ONLY profile_menu
- ADD CONSTRAINT profile_menu_me_code_fkey FOREIGN KEY (me_code) REFERENCES
menu_ref(me_code);
+ ADD CONSTRAINT profile_menu_me_code_fkey FOREIGN KEY (me_code) REFERENCES
menu_ref(me_code) ON UPDATE CASCADE ON DELETE CASCADE;
--
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2011-11-05 23:39:54 UTC (rev 4317)
+++ phpcompta/trunk/sql/upgrade.sql 2011-11-07 21:16:45 UTC (rev 4318)
@@ -15,5 +15,6 @@
trigger.tmp_pcmn.sql
account_add.sql
object-6.0.sql
+epad-style.css
*/
create unique index qcode_idx on fiche_detail (ad_value) where ad_id=23;
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4318 - in phpcompta/trunk: html include include/template sql,
phpcompta-dev <=