Statistiques
| Branche: | Révision :

root / src / pip_stock.php @ master

Historique | Voir | Annoter | Télécharger (5,37 ko)

1 1a2be799 Florent Chuffart
<?php
2 1a2be799 Florent Chuffart
session_start ();
3 d072e29c Florent Chuffart
require("headers.php");
4 1a2be799 Florent Chuffart
5 1a2be799 Florent Chuffart
/*
6 1a2be799 Florent Chuffart
 * IMPORTANT NOTE: This generated file contains only a subset of huge amount
7 1a2be799 Florent Chuffart
 * of options that can be used with phpMyEdit. To get information about all
8 1a2be799 Florent Chuffart
 * features offered by phpMyEdit, check official documentation. It is available
9 1a2be799 Florent Chuffart
 * online and also for download on phpMyEdit project management page:
10 1a2be799 Florent Chuffart
 *
11 1a2be799 Florent Chuffart
 * http://platon.sk/projects/main_page.php?project_id=5
12 1a2be799 Florent Chuffart
 *
13 1a2be799 Florent Chuffart
 * This file was generated by:
14 1a2be799 Florent Chuffart
 *
15 1a2be799 Florent Chuffart
 *                    phpMyEdit version: unknown
16 1a2be799 Florent Chuffart
 *       phpMyEdit.class.php core class: 1.204
17 1a2be799 Florent Chuffart
 *            phpMyEditSetup.php script: 1.50
18 1a2be799 Florent Chuffart
 *              generating setup script: 1.50
19 1a2be799 Florent Chuffart
 */
20 1a2be799 Florent Chuffart
21 1a2be799 Florent Chuffart
/*************************/
22 1a2be799 Florent Chuffart
//
23 1a2be799 Florent Chuffart
// Pass phpMyEdit options
24 1a2be799 Florent Chuffart
//
25 1a2be799 Florent Chuffart
/*************************/
26 1a2be799 Florent Chuffart
27 1a2be799 Florent Chuffart
28 1a2be799 Florent Chuffart
$opts['dbh'] = $connexion;
29 1a2be799 Florent Chuffart
$opts['tb'] = $tb;
30 1a2be799 Florent Chuffart
31 1a2be799 Florent Chuffart
// Name of field which is the unique key
32 1a2be799 Florent Chuffart
$opts['key'] = 'ID';
33 1a2be799 Florent Chuffart
34 1a2be799 Florent Chuffart
// Type of key field (int/real/string/date etc.)
35 1a2be799 Florent Chuffart
$opts['key_type'] = 'int';
36 1a2be799 Florent Chuffart
37 1a2be799 Florent Chuffart
// Sorting field(s)
38 1a2be799 Florent Chuffart
$opts['sort_field'] = array('ID');
39 1a2be799 Florent Chuffart
40 1a2be799 Florent Chuffart
// Number of records to display on the screen
41 1a2be799 Florent Chuffart
// Value of -1 lists all records in a table
42 1a2be799 Florent Chuffart
$opts['inc'] = 15;
43 1a2be799 Florent Chuffart
44 1a2be799 Florent Chuffart
// Options you wish to give the users
45 1a2be799 Florent Chuffart
// A - add,  C - change, P - copy, V - view, D - delete,
46 1a2be799 Florent Chuffart
// F - filter, I - initial sort suppressed
47 1a2be799 Florent Chuffart
$opts['options'] = $privopt;
48 1a2be799 Florent Chuffart
49 1a2be799 Florent Chuffart
// Number of lines to display on multiple selection filters
50 1a2be799 Florent Chuffart
$opts['multiple'] = '4';
51 1a2be799 Florent Chuffart
52 1a2be799 Florent Chuffart
// Navigation style: B - buttons (default), T - text links, G - graphic links
53 1a2be799 Florent Chuffart
// Buttons position: U - up, D - down (default)
54 1a2be799 Florent Chuffart
$opts['navigation'] = 'UDBG';
55 1a2be799 Florent Chuffart
56 1a2be799 Florent Chuffart
// Display special page elements
57 1a2be799 Florent Chuffart
$opts['display'] = array(
58 1a2be799 Florent Chuffart
        'form'  => true,
59 1a2be799 Florent Chuffart
        'query' => true,
60 1a2be799 Florent Chuffart
        'sort'  => true,
61 1a2be799 Florent Chuffart
        'time'  => true,
62 1a2be799 Florent Chuffart
        'tabs'  => true
63 1a2be799 Florent Chuffart
);
64 1a2be799 Florent Chuffart
65 1a2be799 Florent Chuffart
// Set default prefixes for variables
66 1a2be799 Florent Chuffart
$opts['js']['prefix']               = 'PME_js_';
67 1a2be799 Florent Chuffart
$opts['dhtml']['prefix']            = 'PME_dhtml_';
68 1a2be799 Florent Chuffart
$opts['cgi']['prefix']['operation'] = 'PME_op_';
69 1a2be799 Florent Chuffart
$opts['cgi']['prefix']['sys']       = 'PME_sys_';
70 1a2be799 Florent Chuffart
$opts['cgi']['prefix']['data']      = 'PME_data_';
71 1a2be799 Florent Chuffart
72 1a2be799 Florent Chuffart
/* Get the user's default language and use it if possible or you can
73 1a2be799 Florent Chuffart
   specify particular one you want to use. Refer to official documentation
74 1a2be799 Florent Chuffart
   for list of available languages. */
75 1a2be799 Florent Chuffart
$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'] . '-UTF8';
76 1a2be799 Florent Chuffart
77 1a2be799 Florent Chuffart
/* Table-level filter capability. If set, it is included in the WHERE clause
78 1a2be799 Florent Chuffart
   of any generated SELECT statement in SQL query. This gives you ability to
79 1a2be799 Florent Chuffart
   work only with subset of data from table.
80 1a2be799 Florent Chuffart

81 1a2be799 Florent Chuffart
$opts['filters'] = "column1 like '%11%' AND column2<17";
82 1a2be799 Florent Chuffart
$opts['filters'] = "section_id = 9";
83 1a2be799 Florent Chuffart
$opts['filters'] = "PMEtable0.sessions_count > 200";
84 1a2be799 Florent Chuffart
*/
85 1a2be799 Florent Chuffart
86 1a2be799 Florent Chuffart
/* Field definitions
87 1a2be799 Florent Chuffart
   
88 1a2be799 Florent Chuffart
Fields will be displayed left to right on the screen in the order in which they
89 1a2be799 Florent Chuffart
appear in generated list. Here are some most used field options documented.
90 1a2be799 Florent Chuffart

91 1a2be799 Florent Chuffart
['name'] is the title used for column headings, etc.;
92 1a2be799 Florent Chuffart
['maxlen'] maximum length to display add/edit/search input boxes
93 1a2be799 Florent Chuffart
['trimlen'] maximum length of string content to display in row listing
94 1a2be799 Florent Chuffart
['width'] is an optional display width specification for the column
95 1a2be799 Florent Chuffart
          e.g.  ['width'] = '100px';
96 1a2be799 Florent Chuffart
['mask'] a string that is used by sprintf() to format field output
97 1a2be799 Florent Chuffart
['sort'] true or false; means the users may sort the display on this column
98 1a2be799 Florent Chuffart
['strip_tags'] true or false; whether to strip tags from content
99 1a2be799 Florent Chuffart
['nowrap'] true or false; whether this field should get a NOWRAP
100 1a2be799 Florent Chuffart
['select'] T - text, N - numeric, D - drop-down, M - multiple selection
101 1a2be799 Florent Chuffart
['options'] optional parameter to control whether a field is displayed
102 1a2be799 Florent Chuffart
  L - list, F - filter, A - add, C - change, P - copy, D - delete, V - view
103 1a2be799 Florent Chuffart
            Another flags are:
104 1a2be799 Florent Chuffart
            R - indicates that a field is read only
105 1a2be799 Florent Chuffart
            W - indicates that a field is a password field
106 1a2be799 Florent Chuffart
            H - indicates that a field is to be hidden and marked as hidden
107 1a2be799 Florent Chuffart
['URL'] is used to make a field 'clickable' in the display
108 1a2be799 Florent Chuffart
        e.g.: 'mailto:$value', 'http://$value' or '$page?stuff';
109 1a2be799 Florent Chuffart
['URLtarget']  HTML target link specification (for example: _blank)
110 1a2be799 Florent Chuffart
['textarea']['rows'] and/or ['textarea']['cols']
111 1a2be799 Florent Chuffart
  specifies a textarea is to be used to give multi-line input
112 1a2be799 Florent Chuffart
  e.g. ['textarea']['rows'] = 5; ['textarea']['cols'] = 10
113 1a2be799 Florent Chuffart
['values'] restricts user input to the specified constants,
114 1a2be799 Florent Chuffart
           e.g. ['values'] = array('A','B','C') or ['values'] = range(1,99)
115 1a2be799 Florent Chuffart
['values']['table'] and ['values']['column'] restricts user input
116 1a2be799 Florent Chuffart
  to the values found in the specified column of another table
117 1a2be799 Florent Chuffart
['values']['description'] = 'desc_column'
118 1a2be799 Florent Chuffart
  The optional ['values']['description'] field allows the value(s) displayed
119 1a2be799 Florent Chuffart
  to the user to be different to those in the ['values']['column'] field.
120 1a2be799 Florent Chuffart
  This is useful for giving more meaning to column values. Multiple
121 1a2be799 Florent Chuffart
  descriptions fields are also possible. Check documentation for this.
122 1a2be799 Florent Chuffart
*/
123 1a2be799 Florent Chuffart
124 1a2be799 Florent Chuffart
$opts['fdd']['ID'] = array(
125 1a2be799 Florent Chuffart
  'name'     => 'ID',
126 1a2be799 Florent Chuffart
  'select'   => 'N',
127 1a2be799 Florent Chuffart
  //'options'  => 'LAVCPDR', // auto increment
128 1a2be799 Florent Chuffart
  'maxlen'   => 10,
129 1a2be799 Florent Chuffart
  'default'  => '0',
130 1a2be799 Florent Chuffart
  'sort'     => true
131 1a2be799 Florent Chuffart
);
132 1a2be799 Florent Chuffart
$opts['fdd']['Serial_Number'] = array(
133 1a2be799 Florent Chuffart
  'name'     => 'Serial Number',
134 1a2be799 Florent Chuffart
  'select'   => 'T',
135 1a2be799 Florent Chuffart
  'maxlen'   => 30,
136 1a2be799 Florent Chuffart
  //'default'  => '0',
137 1a2be799 Florent Chuffart
  'sort'     => true
138 1a2be799 Florent Chuffart
);
139 1a2be799 Florent Chuffart
$opts['fdd']['Marque'] = array(
140 1a2be799 Florent Chuffart
  'name'     => 'Marque',
141 1a2be799 Florent Chuffart
  'select'   => 'D',
142 1a2be799 Florent Chuffart
  'maxlen'   => 25,
143 1a2be799 Florent Chuffart
  'sort'     => true,
144 1a2be799 Florent Chuffart
  'values'   => array(
145 1a2be799 Florent Chuffart
          'table'  => 'pip_marque',
146 1a2be799 Florent Chuffart
        'column' => 'Marque')
147 1a2be799 Florent Chuffart
);
148 1a2be799 Florent Chuffart
$opts['fdd']['Type'] = array(
149 1a2be799 Florent Chuffart
  'name'     => 'Type',
150 1a2be799 Florent Chuffart
  'select'   => 'D',
151 1a2be799 Florent Chuffart
  'maxlen'   => 25,
152 1a2be799 Florent Chuffart
  'sort'     => true,
153 1a2be799 Florent Chuffart
  'values'   => array(
154 1a2be799 Florent Chuffart
          'table'  => 'pip_type',
155 1a2be799 Florent Chuffart
        'column' => 'Type')
156 1a2be799 Florent Chuffart
);
157 1a2be799 Florent Chuffart
158 1a2be799 Florent Chuffart
// TRIGGER
159 1a2be799 Florent Chuffart
// Before displaying the view page
160 1a2be799 Florent Chuffart
161 d072e29c Florent Chuffart
require("footers.php");
162 d072e29c Florent Chuffart
?>