dolibarr  9.0.0
dbtable.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3  * Copyright (C) 2004-2005 Laurent Destailleur <eldy@users.sourceforge.net>
4  * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
5  * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
6  * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
7  *
8  * This program is free software; you can redistribute it and/or modify
9  * it under the terms of the GNU General Public License as published by
10  * the Free Software Foundation; either version 3 of the License, or
11  * (at your option) any later version.
12  *
13  * This program is distributed in the hope that it will be useful,
14  * but WITHOUT ANY WARRANTY; without even the implied warranty of
15  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16  * GNU General Public License for more details.
17  *
18  * You should have received a copy of the GNU General Public License
19  * along with this program. If not, see <http://www.gnu.org/licenses/>.
20  */
21 
27 require '../../main.inc.php';
28 
29 $langs->load("admin");
30 
31 if (! $user->admin)
33 
34 $table=GETPOST('table','alpha');
35 
36 
37 /*
38  * View
39  */
40 
41 llxHeader();
42 
43 
44 print load_fiche_titre($langs->trans("Table") . " ".$table,'','title_setup');
45 
46 // Define request to get table description
47 $base=0;
48 if (preg_match('/mysql/i',$conf->db->type))
49 {
50  $sql = "SHOW TABLE STATUS LIKE '".$db->escape($table)."'";
51  $base=1;
52 }
53 else if ($conf->db->type == 'pgsql')
54 {
55  $sql = "SELECT conname,contype FROM pg_constraint";
56  $base=2;
57 }
58 
59 if (! $base)
60 {
61  print $langs->trans("FeatureNotAvailableWithThisDatabaseDriver");
62 }
63 else
64 {
65  $resql = $db->query($sql);
66  if ($resql)
67  {
68  $num = $db->num_rows($resql);
69  $i=0;
70  while ($i < $num)
71  {
72  $row = $db->fetch_row($resql);
73  $i++;
74  }
75  }
76 
77  if ($base == 1) // mysql
78  {
79  $link=array();
80  $cons = explode(";", $row[14]);
81  if (! empty($cons))
82  {
83  foreach($cons as $cc)
84  {
85  $cx = preg_replace("/\)\sREFER/", "", $cc);
86  $cx = preg_replace("/\(`/", "", $cx);
87  $cx = preg_replace("/`\)/", "", $cx);
88  $cx = preg_replace("/`\s/", "", $cx);
89 
90  $val = explode("`",$cx);
91 
92  $link[trim($val[0])][0] = (isset($val[1])?$val[1]:'');
93  $link[trim($val[0])][1] = (isset($val[2])?$val[2]:'');
94  }
95  }
96 
97  // var_dump($link);
98 
99  print '<table class="noborder">';
100  print '<tr class="liste_titre">';
101  print '<td>'.$langs->trans("Fields").'</td><td>'.$langs->trans("Type").'</td><td>'.$langs->trans("Index").'</td>';
102  print '<td></td>';
103  print '<td></td>';
104  print '<td></td>';
105  print '<td></td>';
106  print '<td>'.$langs->trans("FieldsLinked").'</td>';
107  print '</tr>';
108 
109  //$sql = "DESCRIBE ".$table;
110  $sql = "SHOW FULL COLUMNS IN ".$db->escape($table);
111 
112  $resql = $db->query($sql);
113  if ($resql)
114  {
115  $num = $db->num_rows($resql);
116  $i=0;
117  while ($i < $num)
118  {
119  $row = $db->fetch_row($resql);
120  print '<tr class="oddeven">';
121  print "<td>".$row[0]."</td>";
122  print "<td>".$row[1]."</td>";
123  print "<td>".$row[3]."</td>";
124  print "<td>".(empty($row[4])?'':$row[4])."</td>";
125  print "<td>".(empty($row[5])?'':$row[5])."</td>";
126  print "<td>".(empty($row[6])?'':$row[6])."</td>";
127  print "<td>".(empty($row[7])?'':$row[7])."</td>";
128 
129  print "<td>".(isset($link[$row[0]][0])?$link[$row[0]][0]:'').".";
130  print (isset($link[$row[0]][1])?$link[$row[0]][1]:'')."</td>";
131 
132  print '<!-- ALTER ALTER TABLE '.$table.' MODIFY '.$row[0].' '.$row[1].' COLLATE utf8_unicode_ci; -->';
133  print '</tr>';
134  $i++;
135  }
136  }
137  print '</table>';
138  }
139 }
140 
141 // End of page
142 llxFooter();
143 $db->close();
llxFooter()
Empty footer.
Definition: wrapper.php:56
load_fiche_titre($titre, $morehtmlright='', $picto='title_generic.png', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
GETPOST($paramname, $check='none', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
print
Draft customers invoices.
Definition: index.php:91
if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) if(! empty($conf->don->enabled) && $user->rights->societe->lire) if(! empty($conf->tax->enabled) && $user->rights->tax->charges->lire) if(! empty($conf->facture->enabled) &&! empty($conf->commande->enabled) && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) $resql
Social contributions to pay.
Definition: index.php:1053
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0)
Show a message to say access is forbidden and stop program Calling this function terminate execution ...
llxHeader()
Empty header.
Definition: wrapper.php:44