Subversion Repositories eFlore/Applications.cel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
419 aurelien 1
<style type="text/css">
2
	hr.pme-hr		     { border: 0px solid; padding: 0px; margin: 0px; border-top-width: 1px; height: 1px; }
3
	table.pme-main 	     { border: #004d9c 1px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
4
	table.pme-navigation { border: #004d9c 0px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
5
	th.pme-header	     { border: #004d9c 1px solid; padding: 4px; background: #add8e6; }
6
	td.pme-key-0, td.pme-value-0, td.pme-help-0, td.pme-navigation-0, td.pme-cell-0,
7
	td.pme-key-1, td.pme-value-1, td.pme-help-0, td.pme-navigation-1, td.pme-cell-1,
8
	td.pme-sortinfo, td.pme-filter { border: #004d9c 1px solid; padding: 3px; }
9
	td.pme-buttons { text-align: left;   }
10
	td.pme-message { text-align: center; }
11
	td.pme-stats   { text-align: right;  }
12
</style><?php
13
 
14
/*
15
 * IMPORTANT NOTE: This generated file contains only a subset of huge amount
16
 * of options that can be used with phpMyEdit. To get information about all
17
 * features offered by phpMyEdit, check official documentation. It is available
18
 * online and also for download on phpMyEdit project management page:
19
 *
20
 * http://platon.sk/projects/main_page.php?project_id=5
21
 *
22
 * This file was generated by:
23
 *
24
 *                    phpMyEdit version: 5.6
25
 *       phpMyEdit.class.php core class: 1.188
26
 *            phpMyEditSetup.php script: 1.48
27
 *              generating setup script: 1.48
28
 */
29
 
30
// MySQL host name, user name, password, database, and table
31
$opts['hn'] = 'localhost';
32
$opts['un'] = 'root';
33
$opts['pw'] = '';
34
$opts['db'] = 'cel';
35
$opts['tb'] = 'cel_inventory';
36
 
37
// Name of field which is the unique key
38
$opts['key'] = 'id';
39
 
40
// Type of key field (int/real/string/date etc.)
41
$opts['key_type'] = 'int';
42
 
43
// Sorting field(s)
44
$opts['sort_field'] = array('id');
45
 
46
// Number of records to display on the screen
47
// Value of -1 lists all records in a table
48
$opts['inc'] = 15;
49
 
50
// Options you wish to give the users
51
// A - add,  C - change, P - copy, V - view, D - delete,
52
// F - filter, I - initial sort suppressed
53
$opts['options'] = 'ACPVDF';
54
 
55
// Number of lines to display on multiple selection filters
56
$opts['multiple'] = '4';
57
 
58
// Navigation style: B - buttons (default), T - text links, G - graphic links
59
// Buttons position: U - up, D - down (default)
60
$opts['navigation'] = 'TB';
61
 
62
// Display special page elements
63
$opts['display'] = array(
64
	'form'  => true,
65
	'query' => true,
66
	'sort'  => true,
67
	'time'  => true,
68
	'tabs'  => true
69
);
70
 
71
// Set default prefixes for variables
72
$opts['js']['prefix']               = 'PME_js_';
73
$opts['dhtml']['prefix']            = 'PME_dhtml_';
74
$opts['cgi']['prefix']['operation'] = 'PME_op_';
75
$opts['cgi']['prefix']['sys']       = 'PME_sys_';
76
$opts['cgi']['prefix']['data']      = 'PME_data_';
77
 
78
/* Get the user's default language and use it if possible or you can
79
   specify particular one you want to use. Refer to official documentation
80
   for list of available languages. */
81
$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
82
 
83
/* Table-level filter capability. If set, it is included in the WHERE clause
84
   of any generated SELECT statement in SQL query. This gives you ability to
85
   work only with subset of data from table.
86
 
87
$opts['filters'] = "column1 like '%11%' AND column2<17";
88
$opts['filters'] = "section_id = 9";
89
$opts['filters'] = "PMEtable0.sessions_count > 200";
90
*/
91
 
92
/* Field definitions
93
 
94
Fields will be displayed left to right on the screen in the order in which they
95
appear in generated list. Here are some most used field options documented.
96
 
97
['name'] is the title used for column headings, etc.;
98
['maxlen'] maximum length to display add/edit/search input boxes
99
['trimlen'] maximum length of string content to display in row listing
100
['width'] is an optional display width specification for the column
101
          e.g.  ['width'] = '100px';
102
['mask'] a string that is used by sprintf() to format field output
103
['sort'] true or false; means the users may sort the display on this column
104
['strip_tags'] true or false; whether to strip tags from content
105
['nowrap'] true or false; whether this field should get a NOWRAP
106
['select'] T - text, N - numeric, D - drop-down, M - multiple selection
107
['options'] optional parameter to control whether a field is displayed
108
  L - list, F - filter, A - add, C - change, P - copy, D - delete, V - view
109
            Another flags are:
110
            R - indicates that a field is read only
111
            W - indicates that a field is a password field
112
            H - indicates that a field is to be hidden and marked as hidden
113
['URL'] is used to make a field 'clickable' in the display
114
        e.g.: 'mailto:$value', 'http://$value' or '$page?stuff';
115
['URLtarget']  HTML target link specification (for example: _blank)
116
['textarea']['rows'] and/or ['textarea']['cols']
117
  specifies a textarea is to be used to give multi-line input
118
  e.g. ['textarea']['rows'] = 5; ['textarea']['cols'] = 10
119
['values'] restricts user input to the specified constants,
120
           e.g. ['values'] = array('A','B','C') or ['values'] = range(1,99)
121
['values']['table'] and ['values']['column'] restricts user input
122
  to the values found in the specified column of another table
123
['values']['description'] = 'desc_column'
124
  The optional ['values']['description'] field allows the value(s) displayed
125
  to the user to be different to those in the ['values']['column'] field.
126
  This is useful for giving more meaning to column values. Multiple
127
  descriptions fields are also possible. Check documentation for this.
128
*/
129
 
130
$opts['fdd']['id'] = array(
131
  'name'     => 'ID',
132
  'select'   => 'T',
133
  'options'  => 'AVCPDR', // auto increment
134
  'maxlen'   => 20,
135
  'default'  => '0',
136
  'sort'     => true
137
);
138
$opts['fdd']['identifiant'] = array(
139
  'name'     => 'Identifiant',
140
  'select'   => 'T',
141
  'maxlen'   => 128,
142
  'sort'     => true
143
);
144
$opts['fdd']['ordre'] = array(
145
  'name'     => 'Ordre',
146
  'select'   => 'T',
147
  'maxlen'   => 20,
148
  'sort'     => true
149
);
150
$opts['fdd']['nom_sel'] = array(
151
  'name'     => 'Nom sel',
152
  'select'   => 'T',
153
  'maxlen'   => 255,
154
  'sort'     => true
155
);
156
$opts['fdd']['num_nom_sel'] = array(
157
  'name'     => 'Num nom sel',
158
  'select'   => 'T',
159
  'maxlen'   => 11,
160
  'sort'     => true
161
);
162
$opts['fdd']['nom_ret'] = array(
163
  'name'     => 'Nom ret',
164
  'select'   => 'T',
165
  'maxlen'   => 255,
166
  'sort'     => true
167
);
168
$opts['fdd']['num_nom_ret'] = array(
169
  'name'     => 'Num nom ret',
170
  'select'   => 'T',
171
  'maxlen'   => 11,
172
  'sort'     => true
173
);
174
$opts['fdd']['num_taxon'] = array(
175
  'name'     => 'Num taxon',
176
  'select'   => 'T',
177
  'maxlen'   => 11,
178
  'sort'     => true
179
);
180
$opts['fdd']['famille'] = array(
181
  'name'     => 'Famille',
182
  'select'   => 'T',
183
  'maxlen'   => 255,
184
  'sort'     => true
185
);
186
$opts['fdd']['location'] = array(
187
  'name'     => 'Location',
188
  'select'   => 'T',
189
  'maxlen'   => 50,
190
  'sort'     => true
191
);
192
$opts['fdd']['id_location'] = array(
193
  'name'     => 'ID location',
194
  'select'   => 'T',
195
  'maxlen'   => 10,
196
  'sort'     => true
197
);
198
$opts['fdd']['date_observation'] = array(
199
  'name'     => 'Date observation',
200
  'select'   => 'T',
201
  'maxlen'   => 19,
202
  'sort'     => true
203
);
204
$opts['fdd']['station'] = array(
205
  'name'     => 'Station',
206
  'select'   => 'T',
207
  'maxlen'   => 255,
208
  'sort'     => true
209
);
210
$opts['fdd']['milieu'] = array(
211
  'name'     => 'Milieu',
212
  'select'   => 'T',
213
  'maxlen'   => 255,
214
  'sort'     => true
215
);
216
$opts['fdd']['commentaire'] = array(
217
  'name'     => 'Commentaire',
218
  'select'   => 'T',
219
  'maxlen'   => 1024,
220
  'sort'     => true
221
);
222
$opts['fdd']['transmission'] = array(
223
  'name'     => 'Transmission',
224
  'select'   => 'T',
225
  'maxlen'   => 4,
226
  'sort'     => true
227
);
228
$opts['fdd']['date_creation'] = array(
229
  'name'     => 'Date creation',
230
  'select'   => 'T',
231
  'maxlen'   => 19,
232
  'sort'     => true
233
);
234
$opts['fdd']['date_modification'] = array(
235
  'name'     => 'Date modification',
236
  'select'   => 'T',
237
  'maxlen'   => 19,
238
  'sort'     => true
239
);
240
$opts['fdd']['date_transmission'] = array(
241
  'name'     => 'Date transmission',
242
  'select'   => 'T',
243
  'maxlen'   => 19,
244
  'sort'     => true
245
);
246
 
247
// Now important call to phpMyEdit
248
require_once 'phpMyEdit.class.php';
249
new phpMyEdit($opts);
250
 
251
?>
252