| 468 |
mathias |
1 |
<?php
|
|
|
2 |
|
|
|
3 |
/*
|
|
|
4 |
* phpMyEdit - instant MySQL table editor and code generator
|
|
|
5 |
*
|
|
|
6 |
* phpMyEdit.class.php - main table editor class definition file
|
|
|
7 |
* ____________________________________________________________
|
|
|
8 |
*
|
|
|
9 |
* Copyright (c) 1999-2002 John McCreesh <jpmcc@users.sourceforge.net>
|
|
|
10 |
* Copyright (c) 2001-2002 Jim Kraai <jkraai@users.sourceforge.net>
|
|
|
11 |
* Versions 5.0 and higher developed by Ondrej Jombik <nepto@php.net>
|
|
|
12 |
* Copyright (c) 2002-2006 Platon Group, http://platon.sk/
|
|
|
13 |
* All rights reserved.
|
|
|
14 |
*
|
|
|
15 |
* See README file for more information about this software.
|
|
|
16 |
* See COPYING file for license information.
|
|
|
17 |
*
|
|
|
18 |
* Download the latest version from
|
|
|
19 |
* http://platon.sk/projects/phpMyEdit/
|
|
|
20 |
*/
|
|
|
21 |
|
|
|
22 |
/* $Platon: phpMyEdit/phpMyEdit.class.php,v 1.188 2006-09-08 16:30:31 michal Exp $ */
|
|
|
23 |
|
|
|
24 |
/* This is a generic table editing program. The table and fields to be
|
|
|
25 |
edited are defined in the calling program.
|
|
|
26 |
|
|
|
27 |
This program works in three passes.
|
|
|
28 |
* Pass 1 (the last part of the program) displays the selected MySQL
|
|
|
29 |
table in a scrolling table on the screen. Radio buttons are used to
|
|
|
30 |
select a record for editing or deletion. If the user chooses Add,
|
|
|
31 |
Change, Copy, View or Delete buttons.
|
|
|
32 |
* Pass 2 starts, displaying the selected record. If the user chooses
|
|
|
33 |
the Save button from this screen.
|
|
|
34 |
* Pass 3 processes the update and the display returns to the
|
|
|
35 |
original table view (Pass 1).
|
|
|
36 |
*/
|
|
|
37 |
|
|
|
38 |
class phpMyEdit_timer /* {{{ */
|
|
|
39 |
{
|
|
|
40 |
var $startTime;
|
|
|
41 |
var $started;
|
|
|
42 |
|
|
|
43 |
function phpMyEdit_timer($start = true)
|
|
|
44 |
{
|
|
|
45 |
$this->started = false;
|
|
|
46 |
if ($start) {
|
|
|
47 |
$this->start();
|
|
|
48 |
}
|
|
|
49 |
}
|
|
|
50 |
|
|
|
51 |
function start()
|
|
|
52 |
{
|
|
|
53 |
$startMtime = explode(' ', microtime());
|
|
|
54 |
$this->startTime = (double) $startMtime[0] + (double) $startMtime[1];
|
|
|
55 |
$this->started = true;
|
|
|
56 |
}
|
|
|
57 |
|
|
|
58 |
function end($iterations = 1)
|
|
|
59 |
{
|
|
|
60 |
// get the time, check whether the timer was started later
|
|
|
61 |
$endMtime = explode(' ', microtime());
|
|
|
62 |
if ($this->started) {
|
|
|
63 |
$endTime = (double)($endMtime[0])+(double)($endMtime[1]);
|
|
|
64 |
$dur = $endTime - $this->startTime;
|
|
|
65 |
$avg = 1000 * $dur / $iterations;
|
|
|
66 |
$avg = round(1000 * $avg) / 1000;
|
|
|
67 |
return $avg;
|
|
|
68 |
} else {
|
|
|
69 |
return 'phpMyEdit_timer ERROR: timer not started';
|
|
|
70 |
}
|
|
|
71 |
}
|
|
|
72 |
} /* }}} */
|
|
|
73 |
|
|
|
74 |
if (! function_exists('array_search')) { /* {{{ */
|
|
|
75 |
function array_search($needle, $haystack)
|
|
|
76 |
{
|
|
|
77 |
foreach ($haystack as $key => $value) {
|
|
|
78 |
if ($needle == $value)
|
|
|
79 |
return $key;
|
|
|
80 |
}
|
|
|
81 |
return false;
|
|
|
82 |
}
|
|
|
83 |
} /* }}} */
|
|
|
84 |
|
|
|
85 |
if (! function_exists('realpath')) { /* {{{ */
|
|
|
86 |
function realpath($path)
|
|
|
87 |
{
|
|
|
88 |
return $path;
|
|
|
89 |
}
|
|
|
90 |
} /* }}} */
|
|
|
91 |
|
|
|
92 |
class phpMyEdit
|
|
|
93 |
{
|
|
|
94 |
// Class variables {{{
|
|
|
95 |
|
|
|
96 |
// Database handling
|
|
|
97 |
var $hn; // hostname
|
|
|
98 |
var $un; // user name
|
|
|
99 |
var $pw; // password
|
|
|
100 |
var $tb; // table
|
|
|
101 |
var $db; // database
|
|
|
102 |
var $dbp; // database with point
|
|
|
103 |
var $dbh; // database handle
|
|
|
104 |
var $close_dbh; // if database handle should be closed
|
|
|
105 |
|
|
|
106 |
// Record manipulation
|
|
|
107 |
var $key; // name of field which is the unique key
|
|
|
108 |
var $key_num; // number of field which is the unique key
|
|
|
109 |
var $key_type; // type of key field (int/real/string/date etc.)
|
|
|
110 |
var $key_delim; // character used for key value quoting
|
|
|
111 |
var $rec; // number of record selected for editing
|
|
|
112 |
var $inc; // number of records to display
|
|
|
113 |
var $fm; // first record to display
|
|
|
114 |
var $fl; // is the filter row displayed (boolean)
|
|
|
115 |
var $fds; // sql field names
|
|
|
116 |
var $fdn; // sql field names => $k
|
|
|
117 |
var $num_fds; // number of fields
|
|
|
118 |
var $options; // options for users: ACDFVPI
|
|
|
119 |
var $fdd; // field definitions
|
|
|
120 |
var $qfn; // value of all filters used during the last pass
|
|
|
121 |
var $sfn; // sort field number (- = descending sort order)
|
|
|
122 |
var $cur_tab; // current selected tab
|
|
|
123 |
|
|
|
124 |
// Operation
|
|
|
125 |
var $navop; // navigation buttons/operations
|
|
|
126 |
var $sw; // filter display/hide/clear button
|
|
|
127 |
var $operation; // operation to do: Add, Change, Delete
|
|
|
128 |
var $saveadd;
|
|
|
129 |
var $moreadd;
|
|
|
130 |
var $canceladd;
|
|
|
131 |
var $savechange;
|
|
|
132 |
var $morechange;
|
|
|
133 |
var $cancelchange;
|
|
|
134 |
var $savecopy;
|
|
|
135 |
var $cancelcopy;
|
|
|
136 |
var $savedelete;
|
|
|
137 |
var $canceldelete;
|
|
|
138 |
var $cancelview;
|
|
|
139 |
|
|
|
140 |
// Additional features
|
|
|
141 |
var $labels; // multilingual labels
|
|
|
142 |
var $cgi; // CGI variable features array
|
|
|
143 |
var $js; // JS configuration array
|
|
|
144 |
var $dhtml; // DHTML configuration array
|
|
|
145 |
var $url; // URL array
|
|
|
146 |
var $message; // informational message to print
|
|
|
147 |
var $notify; // change notification e-mail adresses
|
|
|
148 |
var $logtable; // name of optional logtable
|
|
|
149 |
var $navigation; // navigation style
|
|
|
150 |
var $tabs; // TAB names
|
|
|
151 |
var $timer = null; // phpMyEdit_timer object
|
|
|
152 |
|
|
|
153 |
// Predefined variables
|
|
|
154 |
var $comp_ops = array('<'=>'<','<='=>'<=','='=>'=','>='=>'>=','>'=>'>');
|
|
|
155 |
var $sql_aggrs = array(
|
|
|
156 |
'sum' => 'Total',
|
|
|
157 |
'avg' => 'Average',
|
|
|
158 |
'min' => 'Minimum',
|
|
|
159 |
'max' => 'Maximum',
|
|
|
160 |
'count' => 'Count');
|
|
|
161 |
var $page_types = array(
|
|
|
162 |
'L' => 'list',
|
|
|
163 |
'F' => 'filter',
|
|
|
164 |
'A' => 'add',
|
|
|
165 |
'V' => 'view',
|
|
|
166 |
'C' => 'change',
|
|
|
167 |
'P' => 'copy',
|
|
|
168 |
'D' => 'delete'
|
|
|
169 |
);
|
|
|
170 |
var $default_buttons = array(
|
|
|
171 |
'L' => array('<<','<','add','view','change','copy','delete','>','>>','goto','goto_combo'),
|
|
|
172 |
'F' => array('<<','<','add','view','change','copy','delete','>','>>','goto','goto_combo'),
|
|
|
173 |
'A' => array('save','more','cancel'),
|
|
|
174 |
'C' => array('save','more','cancel'),
|
|
|
175 |
'P' => array('save', 'cancel'),
|
|
|
176 |
'D' => array('save','cancel'),
|
|
|
177 |
'V' => array('change','cancel')
|
|
|
178 |
);
|
|
|
179 |
// }}}
|
|
|
180 |
|
|
|
181 |
/*
|
|
|
182 |
* column specific functions
|
|
|
183 |
*/
|
|
|
184 |
|
|
|
185 |
function col_has_sql($k) { return isset($this->fdd[$k]['sql']); }
|
|
|
186 |
function col_has_sqlw($k) { return isset($this->fdd[$k]['sqlw']) && !$this->virtual($k); }
|
|
|
187 |
function col_has_values($k) { return isset($this->fdd[$k]['values']) || isset($this->fdd[$k]['values2']); }
|
|
|
188 |
function col_has_php($k) { return isset($this->fdd[$k]['php']); }
|
|
|
189 |
function col_has_URL($k) { return isset($this->fdd[$k]['URL'])
|
|
|
190 |
|| isset($this->fdd[$k]['URLprefix']) || isset($this->fdd[$k]['URLpostfix']); }
|
|
|
191 |
function col_has_multiple($k)
|
|
|
192 |
{ return $this->col_has_multiple_select($k) || $this->col_has_checkboxes($k); }
|
|
|
193 |
function col_has_multiple_select($k)
|
|
|
194 |
{ return $this->fdd[$k]['select'] == 'M' && ! $this->fdd[$k]['values']['table']; }
|
|
|
195 |
function col_has_checkboxes($k)
|
|
|
196 |
{ return $this->fdd[$k]['select'] == 'C' && ! $this->fdd[$k]['values']['table']; }
|
|
|
197 |
function col_has_radio_buttons($k)
|
|
|
198 |
{ return $this->fdd[$k]['select'] == 'O' && ! $this->fdd[$k]['values']['table']; }
|
|
|
199 |
function col_has_datemask($k)
|
|
|
200 |
{ return isset($this->fdd[$k]['datemask']) || isset($this->fdd[$k]['strftimemask']); }
|
|
|
201 |
|
|
|
202 |
/*
|
|
|
203 |
* functions for indicating whether navigation style is enabled
|
|
|
204 |
*/
|
|
|
205 |
|
|
|
206 |
function nav_buttons() { return stristr($this->navigation, 'B'); }
|
|
|
207 |
function nav_text_links() { return stristr($this->navigation, 'T'); }
|
|
|
208 |
function nav_graphic_links() { return stristr($this->navigation, 'G'); }
|
|
|
209 |
function nav_up() { return (stristr($this->navigation, 'U') && !($this->buttons[$this->page_type]['up'] === false)); }
|
|
|
210 |
function nav_down() { return (stristr($this->navigation, 'D') && !($this->buttons[$this->page_type]['down'] === false)); }
|
|
|
211 |
|
|
|
212 |
/*
|
|
|
213 |
* functions for indicating whether operations are enabled
|
|
|
214 |
*/
|
|
|
215 |
|
|
|
216 |
function add_enabled() { return stristr($this->options, 'A'); }
|
|
|
217 |
function change_enabled() { return stristr($this->options, 'C'); }
|
|
|
218 |
function delete_enabled() { return stristr($this->options, 'D'); }
|
|
|
219 |
function filter_enabled() { return stristr($this->options, 'F'); }
|
|
|
220 |
function view_enabled() { return stristr($this->options, 'V'); }
|
|
|
221 |
function copy_enabled() { return stristr($this->options, 'P') && $this->add_enabled(); }
|
|
|
222 |
function tabs_enabled() { return $this->display['tabs'] && count($this->tabs) > 0; }
|
|
|
223 |
function hidden($k) { return stristr($this->fdd[$k]['input'],'H'); }
|
|
|
224 |
function password($k) { return stristr($this->fdd[$k]['input'],'W'); }
|
|
|
225 |
function readonly($k) { return stristr($this->fdd[$k]['input'],'R') || $this->virtual($k); }
|
|
|
226 |
function virtual($k) { return stristr($this->fdd[$k]['input'],'V') && $this->col_has_sql($k); }
|
|
|
227 |
|
|
|
228 |
function add_operation() { return $this->operation == $this->labels['Add'] && $this->add_enabled(); }
|
|
|
229 |
function change_operation() { return $this->operation == $this->labels['Change'] && $this->change_enabled(); }
|
|
|
230 |
function copy_operation() { return $this->operation == $this->labels['Copy'] && $this->copy_enabled(); }
|
|
|
231 |
function delete_operation() { return $this->operation == $this->labels['Delete'] && $this->delete_enabled(); }
|
|
|
232 |
function view_operation() { return $this->operation == $this->labels['View'] && $this->view_enabled(); }
|
|
|
233 |
function filter_operation() { return $this->fl && $this->filter_enabled() && $this->list_operation(); }
|
|
|
234 |
function list_operation() { /* covers also filtering page */ return ! $this->change_operation()
|
|
|
235 |
&& ! $this->add_operation() && ! $this->copy_operation()
|
|
|
236 |
&& ! $this->delete_operation() && ! $this->view_operation(); }
|
|
|
237 |
function next_operation() { return ($this->navop == $this->labels['Next']) || ($this->navop == '>'); }
|
|
|
238 |
function prev_operation() { return ($this->navop == $this->labels['Prev']) || ($this->navop == '<'); }
|
|
|
239 |
function first_operation() { return ($this->navop == $this->labels['First']) || ($this->navop == '<<'); }
|
|
|
240 |
function last_operation() { return ($this->navop == $this->labels['Last']) || ($this->navop == '>>'); }
|
|
|
241 |
function clear_operation() { return $this->sw == $this->labels['Clear']; }
|
|
|
242 |
|
|
|
243 |
function add_canceled() { return $this->canceladd == $this->labels['Cancel']; }
|
|
|
244 |
function view_canceled() { return $this->cancelview == $this->labels['Cancel']; }
|
|
|
245 |
function change_canceled() { return $this->cancelchange == $this->labels['Cancel']; }
|
|
|
246 |
function copy_canceled() { return $this->cancelcopy == $this->labels['Cancel']; }
|
|
|
247 |
function delete_canceled() { return $this->canceldelete == $this->labels['Cancel']; }
|
|
|
248 |
|
|
|
249 |
function is_values2($k, $val = 'X') /* {{{ */
|
|
|
250 |
{
|
|
|
251 |
return $val === null ||
|
|
|
252 |
(isset($this->fdd[$k]['values2']) && !isset($this->fdd[$k]['values']['table']));
|
|
|
253 |
} /* }}} */
|
|
|
254 |
|
|
|
255 |
function processed($k) /* {{{ */
|
|
|
256 |
{
|
|
|
257 |
if ($this->virtual($k)) {
|
|
|
258 |
return false;
|
|
|
259 |
}
|
|
|
260 |
$options = @$this->fdd[$k]['options'];
|
|
|
261 |
if (! isset($options)) {
|
|
|
262 |
return true;
|
|
|
263 |
}
|
|
|
264 |
return
|
|
|
265 |
($this->saveadd == $this->labels['Save'] && stristr($options, 'A')) ||
|
|
|
266 |
($this->moreadd == $this->labels['More'] && stristr($options, 'A')) ||
|
|
|
267 |
($this->savechange == $this->labels['Save'] && stristr($options, 'C')) ||
|
|
|
268 |
($this->morechange == $this->labels['Apply'] && stristr($options, 'C')) ||
|
|
|
269 |
($this->savecopy == $this->labels['Save'] && stristr($options, 'P')) ||
|
|
|
270 |
($this->savedelete == $this->labels['Save'] && stristr($options, 'D'));
|
|
|
271 |
} /* }}} */
|
|
|
272 |
|
|
|
273 |
function displayed($k) /* {{{ */
|
|
|
274 |
{
|
|
|
275 |
if (is_numeric($k)) {
|
|
|
276 |
$k = $this->fds[$k];
|
|
|
277 |
}
|
|
|
278 |
$options = @$this->fdd[$k]['options'];
|
|
|
279 |
if (! isset($options)) {
|
|
|
280 |
return true;
|
|
|
281 |
}
|
|
|
282 |
return
|
|
|
283 |
($this->add_operation() && stristr($options, 'A')) ||
|
|
|
284 |
($this->view_operation() && stristr($options, 'V')) ||
|
|
|
285 |
($this->change_operation() && stristr($options, 'C')) ||
|
|
|
286 |
($this->copy_operation() && stristr($options, 'P')) ||
|
|
|
287 |
($this->delete_operation() && stristr($options, 'D')) ||
|
|
|
288 |
($this->filter_operation() && stristr($options, 'F')) ||
|
|
|
289 |
($this->list_operation() && stristr($options, 'L'));
|
|
|
290 |
} /* }}} */
|
|
|
291 |
|
|
|
292 |
function debug_var($name, $val) /* {{{ */
|
|
|
293 |
{
|
|
|
294 |
if (is_array($val) || is_object($val)) {
|
|
|
295 |
echo "<pre>$name\n";
|
|
|
296 |
ob_start();
|
|
|
297 |
//print_r($val);
|
|
|
298 |
var_dump($val);
|
|
|
299 |
$content = ob_get_contents();
|
|
|
300 |
ob_end_clean();
|
|
|
301 |
echo htmlspecialchars($content);
|
|
|
302 |
echo "</pre>\n";
|
|
|
303 |
} else {
|
|
|
304 |
echo 'debug_var()::<i>',htmlspecialchars($name),'</i>';
|
|
|
305 |
echo '::<b>',htmlspecialchars($val),'</b>::',"<br />\n";
|
|
|
306 |
}
|
|
|
307 |
} /* }}} */
|
|
|
308 |
|
|
|
309 |
function myquery($qry, $line = 0, $debug = 0) /* {{{ */
|
|
|
310 |
{
|
|
|
311 |
global $debug_query;
|
|
|
312 |
if ($debug_query || $debug) {
|
|
|
313 |
$line = intval($line);
|
|
|
314 |
echo '<h4>MySQL query at line ',$line,'</h4>',htmlspecialchars($qry),'<hr />',"\n";
|
|
|
315 |
}
|
|
|
316 |
if (isset($this->db)) {
|
|
|
317 |
$ret = @mysql_db_query($this->db, $qry, $this->dbh);
|
|
|
318 |
} else {
|
|
|
319 |
$ret = @mysql_query($qry, $this->dbh);
|
|
|
320 |
}
|
|
|
321 |
if (! $ret) {
|
|
|
322 |
echo '<h4>MySQL error ',mysql_errno($this->dbh),'</h4>';
|
|
|
323 |
echo htmlspecialchars(mysql_error($this->dbh)),'<hr />',"\n";
|
|
|
324 |
}
|
|
|
325 |
return $ret;
|
|
|
326 |
} /* }}} */
|
|
|
327 |
|
|
|
328 |
function make_language_labels($language) /* {{{ */
|
|
|
329 |
{
|
|
|
330 |
// just try the first language and variant
|
|
|
331 |
// this isn't content-negotiation rfc compliant
|
|
|
332 |
$language = strtoupper($language);
|
|
|
333 |
|
|
|
334 |
// try the full language w/ variant
|
|
|
335 |
$file = $this->dir['lang'].'PME.lang.'.$language.'.inc';
|
|
|
336 |
|
|
|
337 |
if (! file_exists($file)) {
|
|
|
338 |
// try the language w/o variant
|
|
|
339 |
$file = $this->dir['lang'].'PME.lang.'.substr($language,0,2).'.inc';
|
|
|
340 |
}
|
|
|
341 |
if (! file_exists($file)) {
|
|
|
342 |
// default to classical English
|
|
|
343 |
$file = $this->dir['lang'].'PME.lang.EN.inc';
|
|
|
344 |
}
|
|
|
345 |
$ret = @include($file);
|
|
|
346 |
if (! is_array($ret)) {
|
|
|
347 |
return $ret;
|
|
|
348 |
}
|
|
|
349 |
$small = array(
|
|
|
350 |
'Search' => 'v',
|
|
|
351 |
'Hide' => '^',
|
|
|
352 |
'Clear' => 'X',
|
|
|
353 |
'Query' => htmlspecialchars('>'));
|
|
|
354 |
if ((!$this->nav_text_links() && !$this->nav_graphic_links())
|
|
|
355 |
|| !isset($ret['Search']) || !isset($ret['Query'])
|
|
|
356 |
|| !isset($ret['Hide']) || !isset($ret['Clear'])) {
|
|
|
357 |
foreach ($small as $key => $val) {
|
|
|
358 |
$ret[$key] = $val;
|
|
|
359 |
}
|
|
|
360 |
}
|
|
|
361 |
return $ret;
|
|
|
362 |
} /* }}} */
|
|
|
363 |
|
|
|
364 |
function set_values($field_num, $prepend = null, $append = null, $strict = false) /* {{{ */
|
|
|
365 |
{
|
|
|
366 |
return (array) $prepend + (array) $this->fdd[$field_num]['values2']
|
|
|
367 |
+ (isset($this->fdd[$field_num]['values']['table']) || $strict
|
|
|
368 |
? $this->set_values_from_table($field_num, $strict)
|
|
|
369 |
: array())
|
|
|
370 |
+ (array) $append;
|
|
|
371 |
} /* }}} */
|
|
|
372 |
|
|
|
373 |
function set_values_from_table($field_num, $strict = false) /* {{{ */
|
|
|
374 |
{
|
|
|
375 |
$db = &$this->fdd[$field_num]['values']['db'];
|
|
|
376 |
$table = &$this->fdd[$field_num]['values']['table'];
|
|
|
377 |
$key = &$this->fdd[$field_num]['values']['column'];
|
|
|
378 |
$desc = &$this->fdd[$field_num]['values']['description'];
|
|
|
379 |
$dbp = isset($db) ? "$db." : $this->dbp;
|
|
|
380 |
$qparts['type'] = 'select';
|
|
|
381 |
if ($table) {
|
|
|
382 |
$qparts['select'] = 'DISTINCT '.$table.'.'.$key;
|
|
|
383 |
if ($desc && is_array($desc) && is_array($desc['columns'])) {
|
|
|
384 |
$qparts['select'] .= ',CONCAT('; // )
|
|
|
385 |
$num_cols = sizeof($desc['columns']);
|
|
|
386 |
if (isset($desc['divs'][-1])) {
|
|
|
387 |
$qparts['select'] .= '"'.addslashes($desc['divs'][-1]).'",';
|
|
|
388 |
}
|
|
|
389 |
foreach ($desc['columns'] as $key => $val) {
|
|
|
390 |
if ($val) {
|
|
|
391 |
$qparts['select'] .= 'IFNULL('.$val.',"")';
|
|
|
392 |
if ($desc['divs'][$key]) {
|
|
|
393 |
$qparts['select'] .= ',"'.addslashes($desc['divs'][$key]).'"';
|
|
|
394 |
}
|
|
|
395 |
$qparts['select'] .= ',';
|
|
|
396 |
}
|
|
|
397 |
}
|
|
|
398 |
$qparts['select']{strlen($qparts['select']) - 1} = ')';
|
|
|
399 |
$qparts['select'] .= ' AS PMEalias'.$field_num;
|
|
|
400 |
$qparts['orderby'] = 'PMEalias'.$field_num;
|
|
|
401 |
} else if ($desc && is_array($desc)) {
|
|
|
402 |
// TODO
|
|
|
403 |
} else if ($desc) {
|
|
|
404 |
$qparts['select'] .= ','.$table.'.'.$desc;
|
|
|
405 |
$qparts['orderby'] = $desc;
|
|
|
406 |
} else if ($key) {
|
|
|
407 |
$qparts['orderby'] = $key;
|
|
|
408 |
}
|
|
|
409 |
$qparts['from'] = "$dbp$table";
|
|
|
410 |
$ar = array(
|
|
|
411 |
'table' => $table,
|
|
|
412 |
'column' => $column,
|
|
|
413 |
'description' => $desc);
|
|
|
414 |
$qparts['where'] = $this->substituteVars($this->fdd[$field_num]['values']['filters'], $ar);
|
|
|
415 |
if ($this->fdd[$field_num]['values']['orderby']) {
|
|
|
416 |
$qparts['orderby'] = $this->substituteVars($this->fdd[$field_num]['values']['orderby'], $ar);
|
|
|
417 |
}
|
|
|
418 |
} else { /* simple value extraction */
|
|
|
419 |
$key = &$this->fds[$field_num];
|
|
|
420 |
$this->virtual($field_num) && $key = $this->fqn($field_num);
|
|
|
421 |
$qparts['select'] = 'DISTINCT '.$key.' AS PMEkey';
|
|
|
422 |
$qparts['orderby'] = 'PMEkey';
|
|
|
423 |
$qparts['from'] = $this->dbp.$this->tb;
|
|
|
424 |
}
|
|
|
425 |
$values = array();
|
|
|
426 |
$res = $this->myquery($this->get_SQL_query($qparts), __LINE__);
|
|
|
427 |
while ($row = @mysql_fetch_array($res, MYSQL_NUM)) {
|
|
|
428 |
$values[$row[0]] = $desc ? $row[1] : $row[0];
|
|
|
429 |
}
|
|
|
430 |
return $values;
|
|
|
431 |
} /* }}} */
|
|
|
432 |
|
|
|
433 |
function fqn($field, $dont_desc = false, $dont_cols = false) /* {{{ */
|
|
|
434 |
{
|
|
|
435 |
is_numeric($field) || $field = array_search($field, $this->fds);
|
|
|
436 |
// if read SQL expression exists use it
|
|
|
437 |
if ($this->col_has_sql($field))
|
|
|
438 |
return $this->fdd[$field]['sql'];
|
|
|
439 |
// on copy/change always use simple key retrieving
|
|
|
440 |
if ($this->add_operation()
|
|
|
441 |
|| $this->copy_operation()
|
|
|
442 |
|| $this->change_operation()) {
|
|
|
443 |
$ret = 'PMEtable0.'.$this->fds[$field];
|
|
|
444 |
} else {
|
|
|
445 |
if ($this->fdd[$this->fds[$field]]['values']['description'] && ! $dont_desc) {
|
|
|
446 |
$desc = &$this->fdd[$this->fds[$field]]['values']['description'];
|
|
|
447 |
if (is_array($desc) && is_array($desc['columns'])) {
|
|
|
448 |
$ret = 'CONCAT('; // )
|
|
|
449 |
$num_cols = sizeof($desc['columns']);
|
|
|
450 |
if (isset($desc['divs'][-1])) {
|
|
|
451 |
$ret .= '"'.addslashes($desc['divs'][-1]).'",';
|
|
|
452 |
}
|
|
|
453 |
foreach ($desc['columns'] as $key => $val) {
|
|
|
454 |
if ($val) {
|
|
|
455 |
$ret .= 'PMEjoin'.$field.'.'.$val;
|
|
|
456 |
if ($desc['divs'][$key]) {
|
|
|
457 |
$ret .= ',"'.addslashes($desc['divs'][$key]).'"';
|
|
|
458 |
}
|
|
|
459 |
$ret .= ',';
|
|
|
460 |
}
|
|
|
461 |
}
|
|
|
462 |
$ret{strlen($ret) - 1} = ')';
|
|
|
463 |
} else if (is_array($desc)) {
|
|
|
464 |
// TODO
|
|
|
465 |
} else {
|
|
|
466 |
$ret = 'PMEjoin'.$field.'.'.$this->fdd[$this->fds[$field]]['values']['description'];
|
|
|
467 |
}
|
|
|
468 |
// TODO: remove me
|
|
|
469 |
} elseif (0 && $this->fdd[$this->fds[$field]]['values']['column'] && ! $dont_cols) {
|
|
|
470 |
$ret = 'PMEjoin'.$field.'.'.$this->fdd[$this->fds[$field]]['values']['column'];
|
|
|
471 |
} else {
|
|
|
472 |
$ret = 'PMEtable0.'.$this->fds[$field];
|
|
|
473 |
}
|
|
|
474 |
// TODO: not neccessary, remove me!
|
|
|
475 |
if (is_array($this->fdd[$this->fds[$field]]['values2'])) {
|
|
|
476 |
}
|
|
|
477 |
}
|
|
|
478 |
return $ret;
|
|
|
479 |
} /* }}} */
|
|
|
480 |
|
|
|
481 |
function get_SQL_query($parts) /* {{{ */
|
|
|
482 |
{
|
|
|
483 |
foreach ($parts as $k => $v) {
|
|
|
484 |
$parts[$k] = trim($parts[$k]);
|
|
|
485 |
}
|
|
|
486 |
switch ($parts['type']) {
|
|
|
487 |
case 'select':
|
|
|
488 |
$ret = 'SELECT ';
|
|
|
489 |
if ($parts['DISTINCT'])
|
|
|
490 |
$ret .= 'DISTINCT ';
|
|
|
491 |
$ret .= $parts['select'];
|
|
|
492 |
$ret .= ' FROM '.$parts['from'];
|
|
|
493 |
if ($parts['where'] != '')
|
|
|
494 |
$ret .= ' WHERE '.$parts['where'];
|
|
|
495 |
if ($parts['groupby'] != '')
|
|
|
496 |
$ret .= ' GROUP BY '.$parts['groupby'];
|
|
|
497 |
if ($parts['having'] != '')
|
|
|
498 |
$ret .= ' HAVING '.$parts['having'];
|
|
|
499 |
if ($parts['orderby'] != '')
|
|
|
500 |
$ret .= ' ORDER BY '.$parts['orderby'];
|
|
|
501 |
if ($parts['limit'] != '')
|
|
|
502 |
$ret .= ' LIMIT '.$parts['limit'];
|
|
|
503 |
if ($parts['procedure'] != '')
|
|
|
504 |
$ret .= ' PROCEDURE '.$parts['procedure'];
|
|
|
505 |
break;
|
|
|
506 |
case 'update':
|
|
|
507 |
$ret = 'UPDATE '.$parts['table'];
|
|
|
508 |
$ret .= ' SET '.$parts['fields'];
|
|
|
509 |
if ($parts['where'] != '')
|
|
|
510 |
$ret .= ' WHERE '.$parts['where'];
|
|
|
511 |
break;
|
|
|
512 |
case 'insert':
|
|
|
513 |
$ret = 'INSERT INTO '.$parts['table'];
|
|
|
514 |
$ret .= ' VALUES '.$parts['values'];
|
|
|
515 |
break;
|
|
|
516 |
case 'delete':
|
|
|
517 |
$ret = 'DELETE FROM '.$parts['table'];
|
|
|
518 |
if ($parts['where'] != '')
|
|
|
519 |
$ret .= ' WHERE '.$parts['where'];
|
|
|
520 |
break;
|
|
|
521 |
default:
|
|
|
522 |
die('unknown query type');
|
|
|
523 |
break;
|
|
|
524 |
}
|
|
|
525 |
return $ret;
|
|
|
526 |
} /* }}} */
|
|
|
527 |
|
|
|
528 |
function get_SQL_column_list() /* {{{ */
|
|
|
529 |
{
|
|
|
530 |
$fields = array();
|
|
|
531 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
532 |
if (! $this->displayed[$k] && $k != $this->key_num) {
|
|
|
533 |
continue;
|
|
|
534 |
}
|
|
|
535 |
$fields[] = $this->fqn($k).' AS qf'.$k;
|
|
|
536 |
if ($this->col_has_values($k)) {
|
|
|
537 |
$fields[] = $this->fqn($k, true, true).' AS qf'.$k.'_idx';
|
|
|
538 |
}
|
|
|
539 |
if ($this->col_has_datemask($k)) {
|
|
|
540 |
$fields[] = 'UNIX_TIMESTAMP('.$this->fqn($k).') AS qf'.$k.'_timestamp';
|
|
|
541 |
}
|
|
|
542 |
}
|
|
|
543 |
return join(',', $fields);
|
|
|
544 |
} /* }}} */
|
|
|
545 |
|
|
|
546 |
function get_SQL_join_clause() /* {{{ */
|
|
|
547 |
{
|
|
|
548 |
$main_table = 'PMEtable0';
|
|
|
549 |
$join_clause = $this->tb." AS $main_table";
|
|
|
550 |
for ($k = 0, $numfds = sizeof($this->fds); $k < $numfds; $k++) {
|
|
|
551 |
$main_column = $this->fds[$k];
|
|
|
552 |
if($this->fdd[$main_column]['values']['db']) {
|
|
|
553 |
$dbp = $this->fdd[$main_column]['values']['db'].'.';
|
|
|
554 |
} else {
|
|
|
555 |
$dbp = $this->dbp;
|
|
|
556 |
}
|
|
|
557 |
$table = @$this->fdd[$main_column]['values']['table'];
|
|
|
558 |
$join_column = @$this->fdd[$main_column]['values']['column'];
|
|
|
559 |
$join_desc = @$this->fdd[$main_column]['values']['description'];
|
|
|
560 |
if ($join_desc != '' && $join_column != '') {
|
|
|
561 |
$join_table = 'PMEjoin'.$k;
|
|
|
562 |
$ar = array(
|
|
|
563 |
'main_table' => $main_table,
|
|
|
564 |
'main_column' => $main_column,
|
|
|
565 |
'join_table' => $join_table,
|
|
|
566 |
'join_column' => $join_column,
|
|
|
567 |
'join_description' => $join_desc);
|
|
|
568 |
$join_clause .= " LEFT OUTER JOIN $dbp$table AS $join_table ON (";
|
|
|
569 |
$join_clause .= isset($this->fdd[$main_column]['values']['join'])
|
|
|
570 |
? $this->substituteVars($this->fdd[$main_column]['values']['join'], $ar)
|
|
|
571 |
: "$join_table.$join_column = $main_table.$main_column";
|
|
|
572 |
if (isset($this->fdd[$main_column]['values']['filters'])) {
|
|
|
573 |
$join_clause .= ' AND ';
|
|
|
574 |
$join_clause .= $this->substituteVars($this->fdd[$main_column]['values']['filters'], $ar);
|
|
|
575 |
}
|
|
|
576 |
$join_clause .= ')';
|
|
|
577 |
}
|
|
|
578 |
}
|
|
|
579 |
return $join_clause;
|
|
|
580 |
} /* }}} */
|
|
|
581 |
|
|
|
582 |
function get_SQL_where_from_query_opts($qp = null, $text = 0) /* {{{ */
|
|
|
583 |
{
|
|
|
584 |
if ($qp == null) {
|
|
|
585 |
$qp = $this->query_opts;
|
|
|
586 |
}
|
|
|
587 |
$where = array();
|
|
|
588 |
foreach ($qp as $field => $ov) {
|
|
|
589 |
if (is_numeric($field)) {
|
|
|
590 |
$tmp_where = array();
|
|
|
591 |
foreach ($ov as $field2 => $ov2) {
|
|
|
592 |
$tmp_where[] = sprintf('%s %s %s', $field2, $ov2['oper'], $ov2['value']);
|
|
|
593 |
}
|
|
|
594 |
$where[] = '('.join(' OR ', $tmp_where).')';
|
|
|
595 |
} else {
|
|
|
596 |
if (is_array($ov['value'])) {
|
|
|
597 |
$tmp_ov_val = '';
|
|
|
598 |
foreach ($ov['value'] as $ov_val) {
|
|
|
599 |
strlen($tmp_ov_val) > 0 && $tmp_ov_val .= ' OR ';
|
|
|
600 |
$tmp_ov_val .= sprintf('FIND_IN_SET("%s",%s)', $ov_val, $field);
|
|
|
601 |
}
|
|
|
602 |
$where[] = "($tmp_ov_val)";
|
|
|
603 |
} else {
|
|
|
604 |
$where[] = sprintf('%s %s %s', $field, $ov['oper'], $ov['value']);
|
|
|
605 |
}
|
|
|
606 |
}
|
|
|
607 |
}
|
|
|
608 |
// Add any coder specified filters
|
|
|
609 |
if (! $text && $this->filters) {
|
|
|
610 |
$where[] = '('.$this->filters.')';
|
|
|
611 |
}
|
|
|
612 |
if (count($where) > 0) {
|
|
|
613 |
if ($text) {
|
|
|
614 |
return str_replace('%', '*', join(' AND ',$where));
|
|
|
615 |
} else {
|
|
|
616 |
return join(' AND ',$where);
|
|
|
617 |
}
|
|
|
618 |
}
|
|
|
619 |
return ''; /* empty string */
|
|
|
620 |
} /* }}} */
|
|
|
621 |
|
|
|
622 |
function gather_query_opts() /* {{{ */
|
|
|
623 |
{
|
|
|
624 |
$this->query_opts = array();
|
|
|
625 |
$this->prev_qfn = $this->qfn;
|
|
|
626 |
$this->qfn = '';
|
|
|
627 |
if ($this->clear_operation()) {
|
|
|
628 |
return;
|
|
|
629 |
}
|
|
|
630 |
// gathers query options into an array, $this->query_opts
|
|
|
631 |
$qo = array();
|
|
|
632 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
633 |
$l = 'qf'.$k;
|
|
|
634 |
$lc = 'qf'.$k.'_comp';
|
|
|
635 |
$li = 'qf'.$k.'_id';
|
|
|
636 |
$m = $this->get_sys_cgi_var($l);
|
|
|
637 |
$mc = $this->get_sys_cgi_var($lc);
|
|
|
638 |
$mi = $this->get_sys_cgi_var($li);
|
|
|
639 |
if (! isset($m) && ! isset($mi)) {
|
|
|
640 |
continue;
|
|
|
641 |
}
|
|
|
642 |
if (is_array($m) || is_array($mi)) {
|
|
|
643 |
if (is_array($mi)) {
|
|
|
644 |
$m = $mi;
|
|
|
645 |
$l = $li;
|
|
|
646 |
}
|
|
|
647 |
if (in_array('*', $m)) {
|
|
|
648 |
continue;
|
|
|
649 |
}
|
|
|
650 |
if ($this->col_has_values($k) && $this->col_has_multiple($k)) {
|
|
|
651 |
foreach (array_keys($m) as $key) {
|
|
|
652 |
$m[$key] = addslashes($m[$key]);
|
|
|
653 |
}
|
|
|
654 |
$qo[$this->fqn($k)] = array('value' => $m);
|
|
|
655 |
} else {
|
|
|
656 |
$qf_op = '';
|
|
|
657 |
foreach (array_keys($m) as $key) {
|
|
|
658 |
if ($qf_op == '') {
|
|
|
659 |
$qf_op = 'IN';
|
|
|
660 |
$qf_val = '"'.addslashes($m[$key]).'"';
|
|
|
661 |
$afilter = ' IN ("'.addslashes($m[$key]).'"'; // )
|
|
|
662 |
} else {
|
|
|
663 |
$afilter = $afilter.',"'.addslashes($m[$key]).'"';
|
|
|
664 |
$qf_val .= ',"'.addslashes($m[$key]).'"';
|
|
|
665 |
}
|
|
|
666 |
$this->qfn .= '&'.$this->cgi['prefix']['sys'].$l.'['.rawurlencode($key).']='.rawurlencode($m[$key]);
|
|
|
667 |
}
|
|
|
668 |
$afilter = $afilter.')';
|
|
|
669 |
// XXX: $dont_desc and $dont_cols hack
|
|
|
670 |
$dont_desc = isset($this->fdd[$k]['values']['description']);
|
|
|
671 |
$dont_cols = isset($this->fdd[$k]['values']['column']);
|
|
|
672 |
$qo[$this->fqn($k, $dont_desc, $dont_cols)] =
|
|
|
673 |
array('oper' => $qf_op, 'value' => "($qf_val)"); // )
|
|
|
674 |
}
|
|
|
675 |
} else if (isset($mi)) {
|
|
|
676 |
if ($mi == '*') {
|
|
|
677 |
continue;
|
|
|
678 |
}
|
|
|
679 |
if ($this->fdd[$k]['select'] != 'M' && $this->fdd[$k]['select'] != 'D' && $mi == '') {
|
|
|
680 |
continue;
|
|
|
681 |
}
|
|
|
682 |
$afilter = addslashes($mi);
|
|
|
683 |
$qo[$this->fqn($k, true, true)] = array('oper' => '=', 'value' => "'$afilter'");
|
|
|
684 |
$this->qfn .= '&'.$this->cgi['prefix']['sys'].$li.'='.rawurlencode($mi);
|
|
|
685 |
} else if (isset($m)) {
|
|
|
686 |
if ($m == '*') {
|
|
|
687 |
continue;
|
|
|
688 |
}
|
|
|
689 |
if ($this->fdd[$k]['select'] != 'M' && $this->fdd[$k]['select'] != 'D' && $m == '') {
|
|
|
690 |
continue;
|
|
|
691 |
}
|
|
|
692 |
$afilter = addslashes($m);
|
|
|
693 |
if ($this->fdd[$k]['select'] == 'N') {
|
|
|
694 |
$mc = in_array($mc, $this->comp_ops) ? $mc : '=';
|
|
|
695 |
$qo[$this->fqn($k)] = array('oper' => $mc, 'value' => "'$afilter'");
|
|
|
696 |
$this->qfn .= '&'.$this->cgi['prefix']['sys'].$l .'='.rawurlencode($m);
|
|
|
697 |
$this->qfn .= '&'.$this->cgi['prefix']['sys'].$lc.'='.rawurlencode($mc);
|
|
|
698 |
} else {
|
|
|
699 |
$afilter = '%'.str_replace('*', '%', $afilter).'%';
|
|
|
700 |
$ids = array();
|
|
|
701 |
$ar = array();
|
|
|
702 |
$ar[$this->fqn($k)] = array('oper' => 'LIKE', 'value' => "'$afilter'");
|
|
|
703 |
if (is_array($this->fdd[$k]['values2'])) {
|
|
|
704 |
foreach ($this->fdd[$k]['values2'] as $key => $val) {
|
|
|
705 |
if (strlen($m) > 0 && stristr($val, $m)) {
|
|
|
706 |
$ids[] = '"'.addslashes($key).'"';
|
|
|
707 |
}
|
|
|
708 |
}
|
|
|
709 |
if (count($ids) > 0) {
|
|
|
710 |
$ar[$this->fqn($k, true, true)]
|
|
|
711 |
= array('oper' => 'IN', 'value' => '('.join(',', $ids).')');
|
|
|
712 |
}
|
|
|
713 |
}
|
|
|
714 |
$qo[] = $ar;
|
|
|
715 |
$this->qfn .= '&'.$this->cgi['prefix']['sys'].$l.'='.rawurlencode($m);
|
|
|
716 |
}
|
|
|
717 |
}
|
|
|
718 |
}
|
|
|
719 |
$this->query_opts = $qo;
|
|
|
720 |
} /* }}} */
|
|
|
721 |
|
|
|
722 |
/*
|
|
|
723 |
* Create JavaScripts
|
|
|
724 |
*/
|
|
|
725 |
|
|
|
726 |
function form_begin() /* {{{ */
|
|
|
727 |
{
|
|
|
728 |
$page_name = htmlspecialchars($this->page_name);
|
|
|
729 |
if ($this->add_operation() || $this->change_operation() || $this->copy_operation()
|
|
|
730 |
|| $this->view_operation() || $this->delete_operation()) {
|
|
|
731 |
$field_to_tab = array();
|
|
|
732 |
for ($tab = $k = $this->cur_tab = 0; $k < $this->num_fds; $k++) {
|
|
|
733 |
if (isset($this->fdd[$k]['tab'])) {
|
|
|
734 |
if ($tab == 0 && $k > 0) {
|
|
|
735 |
$this->tabs[0] = 'PMEtab0';
|
|
|
736 |
$this->cur_tab = 1;
|
|
|
737 |
$tab++;
|
|
|
738 |
}
|
|
|
739 |
if (is_array($this->fdd[$k]['tab'])) {
|
|
|
740 |
$this->tabs[$tab] = @$this->fdd[$k]['tab']['name'];
|
|
|
741 |
$this->fdd[$k]['tab']['default'] && $this->cur_tab = $tab;
|
|
|
742 |
} else {
|
|
|
743 |
$this->tabs[$tab] = @$this->fdd[$k]['tab'];
|
|
|
744 |
}
|
|
|
745 |
$tab++;
|
|
|
746 |
}
|
|
|
747 |
$field_to_tab[$k] = max(0, $tab - 1);
|
|
|
748 |
}
|
|
|
749 |
if (preg_match('/^'.$this->dhtml['prefix'].'tab(\d+)$/', $this->get_sys_cgi_var('cur_tab'), $parts)) {
|
|
|
750 |
$this->cur_tab = $parts[1];
|
|
|
751 |
}
|
|
|
752 |
if ($this->tabs_enabled()) {
|
|
|
753 |
// initial TAB styles
|
|
|
754 |
echo '<style type="text/css" media="screen">',"\n";
|
|
|
755 |
for ($i = 0; $i < count($this->tabs); $i++) {
|
|
|
756 |
echo ' #'.$this->dhtml['prefix'].'tab',$i,' { display: ';
|
|
|
757 |
echo (($i == $this->cur_tab || $this->tabs[$i] == 'PMEtab0' ) ? 'block' : 'none') ,'; }',"\n";
|
|
|
758 |
}
|
|
|
759 |
echo '</style>',"\n";
|
|
|
760 |
// TAB javascripts
|
|
|
761 |
echo '<script type="text/javascript"><!--',"\n\n";
|
|
|
762 |
$css_class_name1 = $this->getCSSclass('tab', $position);
|
|
|
763 |
$css_class_name2 = $this->getCSSclass('tab-selected', $position);
|
|
|
764 |
echo 'var '.$this->js['prefix'].'cur_tab = "'.$this->dhtml['prefix'].'tab',$this->cur_tab,'";
|
|
|
765 |
|
|
|
766 |
function '.$this->js['prefix'].'show_tab(tab_name)
|
|
|
767 |
{';
|
|
|
768 |
if ($this->nav_up()) {
|
|
|
769 |
echo '
|
|
|
770 |
document.getElementById('.$this->js['prefix'].'cur_tab+"_up_label").className = "',$css_class_name1,'";
|
|
|
771 |
document.getElementById('.$this->js['prefix'].'cur_tab+"_up_link").className = "',$css_class_name1,'";
|
|
|
772 |
document.getElementById(tab_name+"_up_label").className = "',$css_class_name2,'";
|
|
|
773 |
document.getElementById(tab_name+"_up_link").className = "',$css_class_name2,'";';
|
|
|
774 |
}
|
|
|
775 |
if ($this->nav_down()) {
|
|
|
776 |
echo '
|
|
|
777 |
document.getElementById('.$this->js['prefix'].'cur_tab+"_down_label").className = "',$css_class_name1,'";
|
|
|
778 |
document.getElementById('.$this->js['prefix'].'cur_tab+"_down_link").className = "',$css_class_name1,'";
|
|
|
779 |
document.getElementById(tab_name+"_down_label").className = "',$css_class_name2,'";
|
|
|
780 |
document.getElementById(tab_name+"_down_link").className = "',$css_class_name2,'";';
|
|
|
781 |
}
|
|
|
782 |
echo '
|
|
|
783 |
document.getElementById('.$this->js['prefix'].'cur_tab).style.display = "none";
|
|
|
784 |
document.getElementById(tab_name).style.display = "block";
|
|
|
785 |
'.$this->js['prefix'].'cur_tab = tab_name;
|
|
|
786 |
document.'.$this->cgi['prefix']['sys'].'form.'.$this->cgi['prefix']['sys'].'cur_tab.value = tab_name;
|
|
|
787 |
}',"\n\n";
|
|
|
788 |
echo '// --></script>', "\n";
|
|
|
789 |
}
|
|
|
790 |
}
|
|
|
791 |
|
|
|
792 |
if ($this->add_operation() || $this->change_operation() || $this->copy_operation()) {
|
|
|
793 |
$first_required = true;
|
|
|
794 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
795 |
if ($this->displayed[$k] && ! $this->readonly($k) && ! $this->hidden($k)
|
|
|
796 |
&& ($this->fdd[$k]['js']['required'] || isset($this->fdd[$k]['js']['regexp']))) {
|
|
|
797 |
if ($first_required) {
|
|
|
798 |
$first_required = false;
|
|
|
799 |
echo '<script type="text/javascript"><!--',"\n";
|
|
|
800 |
echo '
|
|
|
801 |
function '.$this->js['prefix'].'trim(str)
|
|
|
802 |
{
|
|
|
803 |
while (str.substring(0, 1) == " "
|
|
|
804 |
|| str.substring(0, 1) == "\\n"
|
|
|
805 |
|| str.substring(0, 1) == "\\r")
|
|
|
806 |
{
|
|
|
807 |
str = str.substring(1, str.length);
|
|
|
808 |
}
|
|
|
809 |
while (str.substring(str.length - 1, str.length) == " "
|
|
|
810 |
|| str.substring(str.length - 1, str.length) == "\\n"
|
|
|
811 |
|| str.substring(str.length - 1, str.length) == "\\r")
|
|
|
812 |
{
|
|
|
813 |
str = str.substring(0, str.length - 1);
|
|
|
814 |
}
|
|
|
815 |
return str;
|
|
|
816 |
}
|
|
|
817 |
|
|
|
818 |
function '.$this->js['prefix'].'form_control(theForm)
|
|
|
819 |
{',"\n";
|
|
|
820 |
}
|
|
|
821 |
if ($this->col_has_values($k)) {
|
|
|
822 |
$condition = 'theForm.'.$this->cgi['prefix']['data'].$this->fds[$k].'.selectedIndex == -1';
|
|
|
823 |
$multiple = $this->col_has_multiple_select($k);
|
|
|
824 |
} else {
|
|
|
825 |
$condition = '';
|
|
|
826 |
$multiple = false;
|
|
|
827 |
if ($this->fdd[$k]['js']['required']) {
|
|
|
828 |
$condition = $this->js['prefix'].'trim(theForm.'.$this->cgi['prefix']['data'].$this->fds[$k].'.value) == ""';
|
|
|
829 |
}
|
|
|
830 |
if (isset($this->fdd[$k]['js']['regexp'])) {
|
|
|
831 |
$condition .= (strlen($condition) > 0 ? ' || ' : '');
|
|
|
832 |
$condition .= sprintf('!(%s.test('.$this->js['prefix'].'trim(theForm.%s.value)))',
|
|
|
833 |
$this->fdd[$k]['js']['regexp'], $this->cgi['prefix']['data'].$this->fds[$k]);
|
|
|
834 |
}
|
|
|
835 |
}
|
|
|
836 |
|
|
|
837 |
/* Multiple selects have their name like ``name[]''.
|
|
|
838 |
It is not possible to work with them directly, because
|
|
|
839 |
theForm.name[].something will result into JavaScript
|
|
|
840 |
syntax error. Following search algorithm is provided
|
|
|
841 |
as a workaround for this.
|
|
|
842 |
*/
|
|
|
843 |
if ($multiple) {
|
|
|
844 |
echo '
|
|
|
845 |
multiple_select = null;
|
|
|
846 |
for (i = 0; i < theForm.length; i++) {
|
|
|
847 |
if (theForm.elements[i].name == "',$this->cgi['prefix']['data'].$this->fds[$k],'[]") {
|
|
|
848 |
multiple_select = theForm.elements[i];
|
|
|
849 |
break;
|
|
|
850 |
}
|
|
|
851 |
}
|
|
|
852 |
if (multiple_select != null && multiple_select.selectedIndex == -1) {';
|
|
|
853 |
} else {
|
|
|
854 |
echo '
|
|
|
855 |
if (',$condition,') {';
|
|
|
856 |
}
|
|
|
857 |
echo '
|
|
|
858 |
alert("';
|
|
|
859 |
if (isset($this->fdd[$k]['js']['hint'])) {
|
|
|
860 |
echo htmlspecialchars($this->fdd[$k]['js']['hint']);
|
|
|
861 |
} else {
|
|
|
862 |
echo $this->labels['Please enter'],' ',$this->fdd[$k]['name'],'.';
|
|
|
863 |
}
|
|
|
864 |
echo '");';
|
|
|
865 |
if ($this->tabs_enabled() && $field_to_tab[$k] >= $this->cur_tab) {
|
|
|
866 |
echo '
|
|
|
867 |
'.$this->js['prefix'].'show_tab("'.$this->dhtml['prefix'].'tab',$field_to_tab[$k],'");';
|
|
|
868 |
}
|
|
|
869 |
echo '
|
|
|
870 |
theForm.',$this->cgi['prefix']['data'].$this->fds[$k],'.focus();
|
|
|
871 |
return false;
|
|
|
872 |
}',"\n";
|
|
|
873 |
}
|
|
|
874 |
}
|
|
|
875 |
if (! $first_required) {
|
|
|
876 |
echo '
|
|
|
877 |
return true;
|
|
|
878 |
}',"\n\n";
|
|
|
879 |
echo '// --></script>', "\n";
|
|
|
880 |
}
|
|
|
881 |
}
|
|
|
882 |
|
|
|
883 |
if ($this->filter_operation()) {
|
|
|
884 |
echo '<script type="text/javascript"><!--',"\n";
|
|
|
885 |
echo '
|
|
|
886 |
function '.$this->js['prefix'].'filter_handler(theForm, theEvent)
|
|
|
887 |
{
|
|
|
888 |
var pressed_key = null;
|
|
|
889 |
if (theEvent.which) {
|
|
|
890 |
pressed_key = theEvent.which;
|
|
|
891 |
} else {
|
|
|
892 |
pressed_key = theEvent.keyCode;
|
|
|
893 |
}
|
|
|
894 |
if (pressed_key == 13) { // enter pressed
|
|
|
895 |
theForm.submit();
|
|
|
896 |
return false;
|
|
|
897 |
}
|
|
|
898 |
return true;
|
|
|
899 |
}',"\n\n";
|
|
|
900 |
echo '// --></script>', "\n";
|
|
|
901 |
}
|
|
|
902 |
|
|
|
903 |
if ($this->display['form']) {
|
|
|
904 |
echo '<form class="',$this->getCSSclass('form'),'" method="post"';
|
|
|
905 |
echo ' action="',$page_name,'" name="'.$this->cgi['prefix']['sys'].'form">',"\n";
|
|
|
906 |
}
|
|
|
907 |
return true;
|
|
|
908 |
} /* }}} */
|
|
|
909 |
|
|
|
910 |
function form_end() /* {{{ */
|
|
|
911 |
{
|
|
|
912 |
if ($this->display['form']) {
|
|
|
913 |
echo '</form>',"\n";
|
|
|
914 |
}
|
|
|
915 |
} /* }}} */
|
|
|
916 |
|
|
|
917 |
function display_tab_labels($position) /* {{{ */
|
|
|
918 |
{
|
|
|
919 |
if (! is_array($this->tabs)) {
|
|
|
920 |
return false;
|
|
|
921 |
}
|
|
|
922 |
echo '<table summary="labels" class="',$this->getCSSclass('tab', $position),'">',"\n";
|
|
|
923 |
echo '<tr class="',$this->getCSSclass('tab', $position),'">',"\n";
|
|
|
924 |
for ($i = ($this->tabs[0] == 'PMEtab0' ? 1 : 0); $i < count($this->tabs); $i++) {
|
|
|
925 |
$css_class_name = $this->getCSSclass($i != $this->cur_tab ? 'tab' : 'tab-selected', $position);
|
|
|
926 |
echo '<td class="',$css_class_name,'" id="'.$this->dhtml['prefix'].'tab',$i,'_',$position,'_label">';
|
|
|
927 |
echo '<a class="',$css_class_name,'" id="'.$this->dhtml['prefix'].'tab',$i,'_',$position,'_link';
|
|
|
928 |
echo '" href="javascript:'.$this->js['prefix'].'show_tab(\''.$this->dhtml['prefix'].'tab',$i,'\')">';
|
|
|
929 |
echo $this->tabs[$i],'</a></td>',"\n";
|
|
|
930 |
}
|
|
|
931 |
echo '<td class="',$this->getCSSclass('tab-end', $position),'"> </td>',"\n";
|
|
|
932 |
echo '</tr>',"\n";
|
|
|
933 |
echo '</table>',"\n";
|
|
|
934 |
} /* }}} */
|
|
|
935 |
|
|
|
936 |
/*
|
|
|
937 |
* Display functions
|
|
|
938 |
*/
|
|
|
939 |
|
|
|
940 |
function display_add_record() /* {{{ */
|
|
|
941 |
{
|
|
|
942 |
for ($tab = 0, $k = 0; $k < $this->num_fds; $k++) {
|
|
|
943 |
if (isset($this->fdd[$k]['tab']) && $this->tabs_enabled() && $k > 0) {
|
|
|
944 |
$tab++;
|
|
|
945 |
echo '</table>',"\n";
|
|
|
946 |
echo '</div>',"\n";
|
|
|
947 |
echo '<div id="'.$this->dhtml['prefix'].'tab',$tab,'">',"\n";
|
|
|
948 |
echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n";
|
|
|
949 |
}
|
|
|
950 |
if (! $this->displayed[$k]) {
|
|
|
951 |
continue;
|
|
|
952 |
}
|
|
|
953 |
if ($this->hidden($k)) {
|
|
|
954 |
echo $this->htmlHiddenData($this->fds[$k], $this->fdd[$k]['default']);
|
|
|
955 |
continue;
|
|
|
956 |
}
|
|
|
957 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
958 |
$css_class_name = $this->getCSSclass('input', null, 'next', $css_postfix);
|
|
|
959 |
$escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true;
|
|
|
960 |
echo '<tr class="',$this->getCSSclass('row', null, true, $css_postfix),'">',"\n";
|
|
|
961 |
echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">';
|
|
|
962 |
echo $this->fdd[$k]['name'],'</td>',"\n";
|
|
|
963 |
echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"';
|
|
|
964 |
echo $this->getColAttributes($k),">\n";
|
|
|
965 |
if ($this->col_has_values($k)) {
|
|
|
966 |
$vals = $this->set_values($k);
|
|
|
967 |
$selected = @$this->fdd[$k]['default'];
|
|
|
968 |
$multiple = $this->col_has_multiple($k);
|
|
|
969 |
$readonly = $this->readonly($k);
|
|
|
970 |
$strip_tags = true;
|
|
|
971 |
//$escape = true;
|
|
|
972 |
if ($this->col_has_checkboxes($k) || $this->col_has_radio_buttons($k)) {
|
|
|
973 |
echo $this->htmlRadioCheck($this->cgi['prefix']['data'].$this->fds[$k],
|
|
|
974 |
$css_class_name, $vals, $selected, $multiple, $readonly,
|
|
|
975 |
$strip_tags, $escape);
|
|
|
976 |
} else {
|
|
|
977 |
echo $this->htmlSelect($this->cgi['prefix']['data'].$this->fds[$k],
|
|
|
978 |
$css_class_name, $vals, $selected, $multiple, $readonly,
|
|
|
979 |
$strip_tags, $escape);
|
|
|
980 |
}
|
|
|
981 |
} elseif (isset ($this->fdd[$k]['textarea'])) {
|
|
|
982 |
echo '<textarea class="',$css_class_name,'" name="',$this->cgi['prefix']['data'].$this->fds[$k],'"';
|
|
|
983 |
echo ($this->readonly($k) ? ' disabled="disabled"' : '');
|
|
|
984 |
if (intval($this->fdd[$k]['textarea']['rows']) > 0) {
|
|
|
985 |
echo ' rows="',$this->fdd[$k]['textarea']['rows'],'"';
|
|
|
986 |
}
|
|
|
987 |
if (intval($this->fdd[$k]['textarea']['cols']) > 0) {
|
|
|
988 |
echo ' cols="',$this->fdd[$k]['textarea']['cols'],'"';
|
|
|
989 |
}
|
|
|
990 |
if (isset($this->fdd[$k]['textarea']['wrap'])) {
|
|
|
991 |
echo ' wrap="',$this->fdd[$k]['textarea']['wrap'],'"';
|
|
|
992 |
} else {
|
|
|
993 |
echo ' wrap="virtual"';
|
|
|
994 |
}
|
|
|
995 |
echo '>';
|
|
|
996 |
if($escape) echo htmlspecialchars($this->fdd[$k]['default']);
|
|
|
997 |
else echo $this->fdd[$k]['default'];
|
|
|
998 |
echo '</textarea>',"\n";
|
|
|
999 |
} elseif ($this->col_has_php($k)) {
|
|
|
1000 |
echo include($this->fdd[$k]['php']);
|
|
|
1001 |
} else {
|
|
|
1002 |
// Simple edit box required
|
|
|
1003 |
$size_ml_props = '';
|
|
|
1004 |
$maxlen = intval($this->fdd[$k]['maxlen']);
|
|
|
1005 |
$size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60);
|
|
|
1006 |
$size && $size_ml_props .= ' size="'.$size.'"';
|
|
|
1007 |
$maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"';
|
|
|
1008 |
echo '<input class="',$css_class_name,'" ';
|
|
|
1009 |
echo ($this->password($k) ? 'type="password"' : 'type="text"');
|
|
|
1010 |
echo ($this->readonly($k) ? ' disabled="disabled"' : '');
|
|
|
1011 |
echo ' name="',$this->cgi['prefix']['data'].$this->fds[$k],'"';
|
|
|
1012 |
echo $size_ml_props,' value="';
|
|
|
1013 |
if($escape) echo htmlspecialchars($this->fdd[$k]['default']);
|
|
|
1014 |
else echo $this->fdd[$k]['default'];
|
|
|
1015 |
echo '" />';
|
|
|
1016 |
}
|
|
|
1017 |
echo '</td>',"\n";
|
|
|
1018 |
if ($this->guidance) {
|
|
|
1019 |
$css_class_name = $this->getCSSclass('help', null, true, $css_postfix);
|
|
|
1020 |
$cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' ';
|
|
|
1021 |
echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n";
|
|
|
1022 |
}
|
|
|
1023 |
echo '</tr>',"\n";
|
|
|
1024 |
}
|
|
|
1025 |
} /* }}} */
|
|
|
1026 |
|
|
|
1027 |
function display_copy_change_delete_record() /* {{{ */
|
|
|
1028 |
{
|
|
|
1029 |
/*
|
|
|
1030 |
* For delete or change: SQL SELECT to retrieve the selected record
|
|
|
1031 |
*/
|
|
|
1032 |
|
|
|
1033 |
$qparts['type'] = 'select';
|
|
|
1034 |
$qparts['select'] = $this->get_SQL_column_list();
|
|
|
1035 |
$qparts['from'] = $this->get_SQL_join_clause();
|
|
|
1036 |
$qparts['where'] = '('.$this->fqn($this->key).'='
|
|
|
1037 |
.$this->key_delim.$this->rec.$this->key_delim.')';
|
|
|
1038 |
|
|
|
1039 |
$res = $this->myquery($this->get_SQL_query($qparts),__LINE__);
|
|
|
1040 |
if (! ($row = @mysql_fetch_array($res, MYSQL_ASSOC))) {
|
|
|
1041 |
return false;
|
|
|
1042 |
}
|
|
|
1043 |
for ($tab = 0, $k = 0; $k < $this->num_fds; $k++) {
|
|
|
1044 |
if (isset($this->fdd[$k]['tab']) && $this->tabs_enabled() && $k > 0) {
|
|
|
1045 |
$tab++;
|
|
|
1046 |
echo '</table>',"\n";
|
|
|
1047 |
echo '</div>',"\n";
|
|
|
1048 |
echo '<div id="'.$this->dhtml['prefix'].'tab',$tab,'">',"\n";
|
|
|
1049 |
echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n";
|
|
|
1050 |
}
|
|
|
1051 |
if (! $this->displayed[$k]) {
|
|
|
1052 |
continue;
|
|
|
1053 |
}
|
|
|
1054 |
if ($this->copy_operation() || $this->change_operation()) {
|
|
|
1055 |
if ($this->hidden($k)) {
|
|
|
1056 |
if ($k != $this->key_num) {
|
|
|
1057 |
echo $this->htmlHiddenData($this->fds[$k], $row["qf$k"]);
|
|
|
1058 |
}
|
|
|
1059 |
continue;
|
|
|
1060 |
}
|
|
|
1061 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
1062 |
echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n";
|
|
|
1063 |
echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">';
|
|
|
1064 |
echo $this->fdd[$k]['name'],'</td>',"\n";
|
|
|
1065 |
/* There are two possibilities of readonly fields handling:
|
|
|
1066 |
1. Display plain text for readonly timestamps, dates and URLs.
|
|
|
1067 |
2. Display disabled input field
|
|
|
1068 |
In all cases particular readonly field will NOT be saved. */
|
|
|
1069 |
if ($this->readonly($k) && ($this->col_has_datemask($k) || $this->col_has_URL($k))) {
|
|
|
1070 |
echo $this->display_delete_field($row, $k);
|
|
|
1071 |
} elseif ($this->password($k)) {
|
|
|
1072 |
echo $this->display_password_field($row, $k);
|
|
|
1073 |
} else {
|
|
|
1074 |
echo $this->display_change_field($row, $k);
|
|
|
1075 |
}
|
|
|
1076 |
if ($this->guidance) {
|
|
|
1077 |
$css_class_name = $this->getCSSclass('help', null, true, $css_postfix);
|
|
|
1078 |
$cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' ';
|
|
|
1079 |
echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n";
|
|
|
1080 |
}
|
|
|
1081 |
echo '</tr>',"\n";
|
|
|
1082 |
} elseif ($this->delete_operation() || $this->view_operation()) {
|
|
|
1083 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
1084 |
echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n";
|
|
|
1085 |
echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">';
|
|
|
1086 |
echo $this->fdd[$k]['name'],'</td>',"\n";
|
|
|
1087 |
if ($this->password($k)) {
|
|
|
1088 |
echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"';
|
|
|
1089 |
echo $this->getColAttributes($k),'>',$this->labels['hidden'],'</td>',"\n";
|
|
|
1090 |
} else {
|
|
|
1091 |
$this->display_delete_field($row, $k);
|
|
|
1092 |
}
|
|
|
1093 |
if ($this->guidance) {
|
|
|
1094 |
$css_class_name = $this->getCSSclass('help', null, true, $css_postfix);
|
|
|
1095 |
$cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' ';
|
|
|
1096 |
echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n";
|
|
|
1097 |
}
|
|
|
1098 |
echo '</tr>',"\n";
|
|
|
1099 |
}
|
|
|
1100 |
}
|
|
|
1101 |
} /* }}} */
|
|
|
1102 |
|
|
|
1103 |
function display_change_field($row, $k) /* {{{ */
|
|
|
1104 |
{
|
|
|
1105 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
1106 |
$css_class_name = $this->getCSSclass('input', null, true, $css_postfix);
|
|
|
1107 |
$escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true;
|
|
|
1108 |
echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"';
|
|
|
1109 |
echo $this->getColAttributes($k),">\n";
|
|
|
1110 |
if ($this->col_has_values($k)) {
|
|
|
1111 |
$vals = $this->set_values($k);
|
|
|
1112 |
$multiple = $this->col_has_multiple($k);
|
|
|
1113 |
$readonly = $this->readonly($k);
|
|
|
1114 |
$strip_tags = true;
|
|
|
1115 |
//$escape = true;
|
|
|
1116 |
if ($this->col_has_checkboxes($k) || $this->col_has_radio_buttons($k)) {
|
|
|
1117 |
echo $this->htmlRadioCheck($this->cgi['prefix']['data'].$this->fds[$k],
|
|
|
1118 |
$css_class_name, $vals, $row["qf$k"], $multiple, $readonly,
|
|
|
1119 |
$strip_tags, $escape);
|
|
|
1120 |
} else {
|
|
|
1121 |
echo $this->htmlSelect($this->cgi['prefix']['data'].$this->fds[$k],
|
|
|
1122 |
$css_class_name, $vals, $row["qf$k"], $multiple, $readonly,
|
|
|
1123 |
$strip_tags, $escape);
|
|
|
1124 |
}
|
|
|
1125 |
} elseif (isset($this->fdd[$k]['textarea'])) {
|
|
|
1126 |
echo '<textarea class="',$css_class_name,'" name="',$this->cgi['prefix']['data'].$this->fds[$k],'"';
|
|
|
1127 |
echo ($this->readonly($k) ? ' disabled="disabled"' : '');
|
|
|
1128 |
if (intval($this->fdd[$k]['textarea']['rows']) > 0) {
|
|
|
1129 |
echo ' rows="',$this->fdd[$k]['textarea']['rows'],'"';
|
|
|
1130 |
}
|
|
|
1131 |
if (intval($this->fdd[$k]['textarea']['cols']) > 0) {
|
|
|
1132 |
echo ' cols="',$this->fdd[$k]['textarea']['cols'],'"';
|
|
|
1133 |
}
|
|
|
1134 |
if (isset($this->fdd[$k]['textarea']['wrap'])) {
|
|
|
1135 |
echo ' wrap="',$this->fdd[$k]['textarea']['wrap'],'"';
|
|
|
1136 |
} else {
|
|
|
1137 |
echo ' wrap="virtual"';
|
|
|
1138 |
}
|
|
|
1139 |
echo '>';
|
|
|
1140 |
if($escape) echo htmlspecialchars($row["qf$k"]);
|
|
|
1141 |
else echo $row["qf$k"];
|
|
|
1142 |
echo '</textarea>',"\n";
|
|
|
1143 |
} elseif ($this->col_has_php($k)) {
|
|
|
1144 |
echo include($this->fdd[$k]['php']);
|
|
|
1145 |
} else {
|
|
|
1146 |
$size_ml_props = '';
|
|
|
1147 |
$maxlen = intval($this->fdd[$k]['maxlen']);
|
|
|
1148 |
$size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60);
|
|
|
1149 |
$size && $size_ml_props .= ' size="'.$size.'"';
|
|
|
1150 |
$maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"';
|
|
|
1151 |
echo '<input class="',$css_class_name,'" type="text" ';
|
|
|
1152 |
echo ($this->readonly($k) ? 'disabled="disabled" ' : '');
|
|
|
1153 |
echo 'name="',$this->cgi['prefix']['data'].$this->fds[$k],'" value="';
|
|
|
1154 |
if($escape) echo htmlspecialchars($row["qf$k"]);
|
|
|
1155 |
else echo $row["qf$k"];
|
|
|
1156 |
echo '" />',"\n";
|
|
|
1157 |
}
|
|
|
1158 |
echo '</td>',"\n";
|
|
|
1159 |
} /* }}} */
|
|
|
1160 |
|
|
|
1161 |
function display_password_field($row, $k) /* {{{ */
|
|
|
1162 |
{
|
|
|
1163 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
1164 |
echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"';
|
|
|
1165 |
echo $this->getColAttributes($k),">\n";
|
|
|
1166 |
$size_ml_props = '';
|
|
|
1167 |
$maxlen = intval($this->fdd[$k]['maxlen']);
|
|
|
1168 |
$size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60);
|
|
|
1169 |
$size && $size_ml_props .= ' size="'.$size.'"';
|
|
|
1170 |
$maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"';
|
|
|
1171 |
echo '<input class="',$this->getCSSclass('value', null, true, $css_postfix),'" type="password" ';
|
|
|
1172 |
echo ($this->readonly($k) ? 'disabled="disabled" ' : '');
|
|
|
1173 |
echo 'name="',$this->cgi['prefix']['data'].$this->fds[$k],'" value="';
|
|
|
1174 |
echo htmlspecialchars($row["qf$k"]),'" ',$size_ml_props,' />',"\n";
|
|
|
1175 |
echo '</td>',"\n";
|
|
|
1176 |
} /* }}} */
|
|
|
1177 |
|
|
|
1178 |
function display_delete_field($row, $k) /* {{{ */
|
|
|
1179 |
{
|
|
|
1180 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
1181 |
$css_class_name = $this->getCSSclass('value', null, true, $css_postfix);
|
|
|
1182 |
echo '<td class="',$css_class_name,'"',$this->getColAttributes($k),">\n";
|
|
|
1183 |
echo $this->cellDisplay($k, $row, $css_class_name);
|
|
|
1184 |
echo '</td>',"\n";
|
|
|
1185 |
} /* }}} */
|
|
|
1186 |
|
|
|
1187 |
/**
|
|
|
1188 |
* Returns CSS class name
|
|
|
1189 |
*/
|
|
|
1190 |
function getCSSclass($name, $position = null, $divider = null, $postfix = null) /* {{{ */
|
|
|
1191 |
{
|
|
|
1192 |
static $div_idx = -1;
|
|
|
1193 |
$elements = array($this->css['prefix'], $name);
|
|
|
1194 |
if ($this->page_type && $this->css['page_type']) {
|
|
|
1195 |
if ($this->page_type != 'L' && $this->page_type != 'F') {
|
|
|
1196 |
$elements[] = $this->page_types[$this->page_type];
|
|
|
1197 |
}
|
|
|
1198 |
}
|
|
|
1199 |
if ($position && $this->css['position']) {
|
|
|
1200 |
$elements[] = $position;
|
|
|
1201 |
}
|
|
|
1202 |
if ($divider && $this->css['divider']) {
|
|
|
1203 |
if ($divider === 'next') {
|
|
|
1204 |
$div_idx++;
|
|
|
1205 |
if ($this->css['divider'] > 0 && $div_idx >= $this->css['divider']) {
|
|
|
1206 |
$div_idx = 0;
|
|
|
1207 |
}
|
|
|
1208 |
}
|
|
|
1209 |
$elements[] = $div_idx;
|
|
|
1210 |
}
|
|
|
1211 |
if ($postfix) {
|
|
|
1212 |
$elements[] = $postfix;
|
|
|
1213 |
}
|
|
|
1214 |
return join($this->css['separator'], $elements);
|
|
|
1215 |
} /* }}} */
|
|
|
1216 |
|
|
|
1217 |
/**
|
|
|
1218 |
* Returns field cell HTML attributes
|
|
|
1219 |
*/
|
|
|
1220 |
function getColAttributes($k) /* {{{ */
|
|
|
1221 |
{
|
|
|
1222 |
$colattrs = '';
|
|
|
1223 |
if (isset($this->fdd[$k]['colattrs'])) {
|
|
|
1224 |
$colattrs .= ' ';
|
|
|
1225 |
$colattrs .= trim($this->fdd[$k]['colattrs']);
|
|
|
1226 |
}
|
|
|
1227 |
if (isset($this->fdd[$k]['nowrap'])) {
|
|
|
1228 |
$colattrs .= ' nowrap';
|
|
|
1229 |
}
|
|
|
1230 |
return $colattrs;
|
|
|
1231 |
} /* }}} */
|
|
|
1232 |
|
|
|
1233 |
/**
|
|
|
1234 |
* Substitutes variables in string
|
|
|
1235 |
* (this is very simple but secure eval() replacement)
|
|
|
1236 |
*/
|
|
|
1237 |
function substituteVars($str, $subst_ar) /* {{{ */
|
|
|
1238 |
{
|
|
|
1239 |
$array = preg_split('/(\\$\w+)/', $str, -1, PREG_SPLIT_DELIM_CAPTURE);
|
|
|
1240 |
$count = count($array);
|
|
|
1241 |
for ($i = 1; $i < $count; $i += 2) {
|
|
|
1242 |
$key = substr($array[$i], 1);
|
|
|
1243 |
if (isset($subst_ar[$key])) {
|
|
|
1244 |
$array[$i] = $subst_ar[$key];
|
|
|
1245 |
}
|
|
|
1246 |
}
|
|
|
1247 |
return join('', $array);
|
|
|
1248 |
} /* }}} */
|
|
|
1249 |
|
|
|
1250 |
/**
|
|
|
1251 |
* Print URL
|
|
|
1252 |
*/
|
|
|
1253 |
function urlDisplay($k, $link_val, $disp_val, $css, $key) /* {{{ */
|
|
|
1254 |
{
|
|
|
1255 |
$escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true;
|
|
|
1256 |
$ret = '';
|
|
|
1257 |
$name = $this->fds[$k];
|
|
|
1258 |
$page = $this->page_name;
|
|
|
1259 |
$url = $this->cgi['prefix']['sys'].'rec'.'='.$key.'&'.$this->cgi['prefix']['sys'].'fm'
|
|
|
1260 |
.'='.$this->fm.'&'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl;
|
|
|
1261 |
$url .= '&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn).$this->qfn;
|
|
|
1262 |
$url .= '&'.$this->get_sfn_cgi_vars().$this->cgi['persist'];
|
|
|
1263 |
$ar = array(
|
|
|
1264 |
'key' => $key,
|
|
|
1265 |
'name' => $name,
|
|
|
1266 |
'link' => $link_val,
|
|
|
1267 |
'value' => $disp_val,
|
|
|
1268 |
'css' => $css,
|
|
|
1269 |
'page' => $page,
|
|
|
1270 |
'url' => $url
|
|
|
1271 |
);
|
|
|
1272 |
$urllink = isset($this->fdd[$k]['URL'])
|
|
|
1273 |
? $this->substituteVars($this->fdd[$k]['URL'], $ar)
|
|
|
1274 |
: $link_val;
|
|
|
1275 |
$urldisp = isset($this->fdd[$k]['URLdisp'])
|
|
|
1276 |
? $this->substituteVars($this->fdd[$k]['URLdisp'], $ar)
|
|
|
1277 |
: $disp_val;
|
|
|
1278 |
$target = isset($this->fdd[$k]['URLtarget'])
|
|
|
1279 |
? 'target="'.htmlspecialchars($this->fdd[$k]['URLtarget']).'" '
|
|
|
1280 |
: '';
|
|
|
1281 |
$prefix_found = false;
|
|
|
1282 |
$postfix_found = false;
|
|
|
1283 |
$prefix_ar = @$this->fdd[$k]['URLprefix'];
|
|
|
1284 |
$postfix_ar = @$this->fdd[$k]['URLpostfix'];
|
|
|
1285 |
is_array($prefix_ar) || $prefix_ar = array($prefix_ar);
|
|
|
1286 |
is_array($postfix_ar) || $postfix_ar = array($postfix_ar);
|
|
|
1287 |
foreach ($prefix_ar as $prefix) {
|
|
|
1288 |
if (! strncmp($prefix, $urllink, strlen($prefix))) {
|
|
|
1289 |
$prefix_found = true;
|
|
|
1290 |
break;
|
|
|
1291 |
}
|
|
|
1292 |
}
|
|
|
1293 |
foreach ($postfix_ar as $postfix) {
|
|
|
1294 |
if (! strncmp($postfix, $urllink, strlen($postfix))) {
|
|
|
1295 |
$postfix_found = true;
|
|
|
1296 |
break;
|
|
|
1297 |
}
|
|
|
1298 |
}
|
|
|
1299 |
$prefix_found || $urllink = array_shift($prefix_ar).$urllink;
|
|
|
1300 |
$postfix_found || $urllink = $urllink.array_shift($postfix_ar);
|
|
|
1301 |
if (strlen($urllink) <= 0 || strlen($urldisp) <= 0) {
|
|
|
1302 |
$ret = ' ';
|
|
|
1303 |
} else {
|
|
|
1304 |
if ($escape) {
|
|
|
1305 |
$urldisp = htmlspecialchars($urldisp);
|
|
|
1306 |
}
|
|
|
1307 |
$urllink = htmlspecialchars($urllink);
|
|
|
1308 |
$ret = '<a '.$target.'class="'.$css.'" href="'.$urllink.'">'.$urldisp.'</a>';
|
|
|
1309 |
}
|
|
|
1310 |
return $ret;
|
|
|
1311 |
} /* }}} */
|
|
|
1312 |
|
|
|
1313 |
function cellDisplay($k, $row, $css) /* {{{ */
|
|
|
1314 |
{
|
|
|
1315 |
$escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true;
|
|
|
1316 |
$key_rec = $row['qf'.$this->key_num];
|
|
|
1317 |
if (@$this->fdd[$k]['datemask']) {
|
|
|
1318 |
$value = intval($row["qf$k".'_timestamp']);
|
|
|
1319 |
$value = $value ? @date($this->fdd[$k]['datemask'], $value) : '';
|
|
|
1320 |
} else if (@$this->fdd[$k]['strftimemask']) {
|
|
|
1321 |
$value = intval($row["qf$k".'_timestamp']);
|
|
|
1322 |
$value = $value ? @strftime($this->fdd[$k]['strftimemask'], $value) : '';
|
|
|
1323 |
} else if ($this->is_values2($k, $row["qf$k"])) {
|
|
|
1324 |
$value = $row['qf'.$k.'_idx'];
|
|
|
1325 |
if ($this->fdd[$k]['select'] == 'M') {
|
|
|
1326 |
$value_ar = explode(',', $value);
|
|
|
1327 |
$value_ar2 = array();
|
|
|
1328 |
foreach ($value_ar as $value_key) {
|
|
|
1329 |
if (isset($this->fdd[$k]['values2'][$value_key])) {
|
|
|
1330 |
$value_ar2[$value_key] = $this->fdd[$k]['values2'][$value_key];
|
|
|
1331 |
$escape = false;
|
|
|
1332 |
}
|
|
|
1333 |
}
|
|
|
1334 |
$value = join(', ', $value_ar2);
|
|
|
1335 |
} else {
|
|
|
1336 |
if (isset($this->fdd[$k]['values2'][$value])) {
|
|
|
1337 |
$value = $this->fdd[$k]['values2'][$value];
|
|
|
1338 |
$escape = false;
|
|
|
1339 |
}
|
|
|
1340 |
}
|
|
|
1341 |
} elseif (isset($this->fdd[$k]['values2'][$row["qf$k"]])) {
|
|
|
1342 |
$value = $this->fdd[$k]['values2'][$row["qf$k"]];
|
|
|
1343 |
} else {
|
|
|
1344 |
$value = $row["qf$k"];
|
|
|
1345 |
}
|
|
|
1346 |
$original_value = $value;
|
|
|
1347 |
if (@$this->fdd[$k]['strip_tags']) {
|
|
|
1348 |
$value = strip_tags($value);
|
|
|
1349 |
}
|
|
|
1350 |
if ($num_ar = @$this->fdd[$k]['number_format']) {
|
|
|
1351 |
if (! is_array($num_ar)) {
|
|
|
1352 |
$num_ar = array($num_ar);
|
|
|
1353 |
}
|
|
|
1354 |
if (count($num_ar) == 1) {
|
|
|
1355 |
list($nbDec) = $num_ar;
|
|
|
1356 |
$value = number_format($value, $nbDec);
|
|
|
1357 |
} else if (count($num_ar) == 3) {
|
|
|
1358 |
list($nbDec, $decPoint, $thSep) = $num_ar;
|
|
|
1359 |
$value = number_format($value, $nbDec, $decPoint, $thSep);
|
|
|
1360 |
}
|
|
|
1361 |
}
|
|
|
1362 |
if (intval($this->fdd[$k]['trimlen']) > 0 && strlen($value) > $this->fdd[$k]['trimlen']) {
|
|
|
1363 |
$value = ereg_replace("[\r\n\t ]+",' ',$value);
|
|
|
1364 |
$value = substr($value, 0, $this->fdd[$k]['trimlen'] - 3).'...';
|
|
|
1365 |
}
|
|
|
1366 |
if (@$this->fdd[$k]['mask']) {
|
|
|
1367 |
$value = sprintf($this->fdd[$k]['mask'], $value);
|
|
|
1368 |
}
|
|
|
1369 |
if ($this->col_has_php($k)) {
|
|
|
1370 |
return include($this->fdd[$k]['php']);
|
|
|
1371 |
}
|
|
|
1372 |
if ($this->col_has_URL($k)) {
|
|
|
1373 |
return $this->urlDisplay($k, $original_value, $value, $css, $key_rec);
|
|
|
1374 |
}
|
|
|
1375 |
if (strlen($value) <= 0) {
|
|
|
1376 |
return ' ';
|
|
|
1377 |
}
|
|
|
1378 |
if ($escape) {
|
|
|
1379 |
$value = htmlspecialchars($value);
|
|
|
1380 |
}
|
|
|
1381 |
return nl2br($value);
|
|
|
1382 |
} /* }}} */
|
|
|
1383 |
|
|
|
1384 |
/**
|
|
|
1385 |
* Creates HTML submit input element
|
|
|
1386 |
*
|
|
|
1387 |
* @param name element name
|
|
|
1388 |
* @param label key in the language hash used as label
|
|
|
1389 |
* @param css_class_name CSS class name
|
|
|
1390 |
* @param js_validation if add JavaScript validation subroutine to button
|
|
|
1391 |
* @param disabled if mark the button as disabled
|
|
|
1392 |
* @param js any extra text in tags
|
|
|
1393 |
*/
|
|
|
1394 |
function htmlSubmit($name, $label, $css_class_name, $js_validation = true, $disabled = false, $js = NULL) /* {{{ */
|
|
|
1395 |
{
|
|
|
1396 |
// Note that <input disabled> isn't valid HTML, but most browsers support it
|
|
|
1397 |
if($disabled == -1) return;
|
|
|
1398 |
$markdisabled = $disabled ? ' disabled="disabled"' : '';
|
|
|
1399 |
$ret = '<input'.$markdisabled.' type="submit" class="'.$css_class_name
|
|
|
1400 |
.'" name="'.$this->cgi['prefix']['sys'].ltrim($markdisabled).$name
|
|
|
1401 |
.'" value="'.(isset($this->labels[$label]) ? $this->labels[$label] : $label);
|
|
|
1402 |
if ($js_validation) {
|
|
|
1403 |
$ret .= '" onclick="return '.$this->js['prefix'].'form_control(this.form);';
|
|
|
1404 |
}
|
|
|
1405 |
$ret .='"';
|
|
|
1406 |
if(isset($js)) $ret .= ' '.$js;
|
|
|
1407 |
$ret .= ' />';
|
|
|
1408 |
return $ret;
|
|
|
1409 |
} /* }}} */
|
|
|
1410 |
|
|
|
1411 |
/**
|
|
|
1412 |
* Creates HTML hidden input element
|
|
|
1413 |
*
|
|
|
1414 |
* @param name element name
|
|
|
1415 |
* @param value value
|
|
|
1416 |
*/
|
|
|
1417 |
|
|
|
1418 |
function htmlHiddenSys($name, $value) /* {{{ */
|
|
|
1419 |
{
|
|
|
1420 |
return $this->htmlHidden($this->cgi['prefix']['sys'].$name, $value);
|
|
|
1421 |
} /* }}} */
|
|
|
1422 |
|
|
|
1423 |
function htmlHiddenData($name, $value) /* {{{ */
|
|
|
1424 |
{
|
|
|
1425 |
return $this->htmlHidden($this->cgi['prefix']['data'].$name, $value);
|
|
|
1426 |
} /* }}} */
|
|
|
1427 |
|
|
|
1428 |
function htmlHidden($name, $value) /* {{{ */
|
|
|
1429 |
{
|
|
|
1430 |
return '<input type="hidden" name="'.htmlspecialchars($name)
|
|
|
1431 |
.'" value="'.htmlspecialchars($value).'" />'."\n";
|
|
|
1432 |
} /* }}} */
|
|
|
1433 |
|
|
|
1434 |
/**
|
|
|
1435 |
* Creates HTML select element (tag)
|
|
|
1436 |
*
|
|
|
1437 |
* @param name element name
|
|
|
1438 |
* @param css CSS class name
|
|
|
1439 |
* @param kv_array key => value array
|
|
|
1440 |
* @param selected selected key (it can be single string, array of
|
|
|
1441 |
* keys or multiple values separated by comma)
|
|
|
1442 |
* @param multiple bool for multiple selection
|
|
|
1443 |
* @param readonly bool for readonly/disabled selection
|
|
|
1444 |
* @param strip_tags bool for stripping tags from values
|
|
|
1445 |
* @param escape bool for HTML escaping values
|
|
|
1446 |
* @param js string to be in the <select >, ususally onchange='..';
|
|
|
1447 |
*/
|
|
|
1448 |
function htmlSelect($name, $css, $kv_array, $selected = null, /* ...) {{{ */
|
|
|
1449 |
/* booleans: */ $multiple = false, $readonly = false, $strip_tags = false, $escape = true, $js = NULL)
|
|
|
1450 |
{
|
|
|
1451 |
$ret = '<select class="'.htmlspecialchars($css).'" name="'.htmlspecialchars($name);
|
|
|
1452 |
if ($multiple) {
|
|
|
1453 |
$ret .= '[]" multiple size="'.$this->multiple;
|
|
|
1454 |
if (! is_array($selected) && $selected !== null) {
|
|
|
1455 |
$selected = explode(',', $selected);
|
|
|
1456 |
}
|
|
|
1457 |
}
|
|
|
1458 |
$ret .= '"'.($readonly ? ' disabled="disabled"' : '').$js.'>'."\n";
|
|
|
1459 |
if (! is_array($selected)) {
|
|
|
1460 |
$selected = $selected === null ? array() : array($selected);
|
|
|
1461 |
}
|
|
|
1462 |
$found = false;
|
|
|
1463 |
foreach ($kv_array as $key => $value) {
|
|
|
1464 |
$ret .= '<option value="'.htmlspecialchars($key).'"';
|
|
|
1465 |
if ((! $found || $multiple) && in_array((string) $key, $selected, 1)
|
|
|
1466 |
|| (count($selected) == 0 && ! $found && ! $multiple)) {
|
|
|
1467 |
$ret .= ' selected="selected"';
|
|
|
1468 |
$found = true;
|
|
|
1469 |
}
|
|
|
1470 |
$strip_tags && $value = strip_tags($value);
|
|
|
1471 |
$escape && $value = htmlspecialchars($value);
|
|
|
1472 |
$ret .= '>'.$value.'</option>'."\n";
|
|
|
1473 |
}
|
|
|
1474 |
$ret .= '</select>';
|
|
|
1475 |
return $ret;
|
|
|
1476 |
} /* }}} */
|
|
|
1477 |
|
|
|
1478 |
/**
|
|
|
1479 |
* Creates HTML checkboxes or radio buttons
|
|
|
1480 |
*
|
|
|
1481 |
* @param name element name
|
|
|
1482 |
* @param css CSS class name
|
|
|
1483 |
* @param kv_array key => value array
|
|
|
1484 |
* @param selected selected key (it can be single string, array of
|
|
|
1485 |
* keys or multiple values separated by comma)
|
|
|
1486 |
* @param multiple bool for multiple selection (checkboxes)
|
|
|
1487 |
* @param readonly bool for readonly/disabled selection
|
|
|
1488 |
* @param strip_tags bool for stripping tags from values
|
|
|
1489 |
* @param escape bool for HTML escaping values
|
|
|
1490 |
* @param js string to be in the <select >, ususally onchange='..';
|
|
|
1491 |
*/
|
|
|
1492 |
function htmlRadioCheck($name, $css, $kv_array, $selected = null, /* ...) {{{ */
|
|
|
1493 |
/* booleans: */ $multiple = false, $readonly = false, $strip_tags = false, $escape = true, $js = NULL)
|
|
|
1494 |
{
|
|
|
1495 |
$ret = '';
|
|
|
1496 |
if ($multiple) {
|
|
|
1497 |
if (! is_array($selected) && $selected !== null) {
|
|
|
1498 |
$selected = explode(',', $selected);
|
|
|
1499 |
}
|
|
|
1500 |
}
|
|
|
1501 |
if (! is_array($selected)) {
|
|
|
1502 |
$selected = $selected === null ? array() : array($selected);
|
|
|
1503 |
}
|
|
|
1504 |
$found = false;
|
|
|
1505 |
foreach ($kv_array as $key => $value) {
|
|
|
1506 |
$ret .= '<input type="'.($multiple ? 'checkbox' : 'radio').'" name="';
|
|
|
1507 |
$ret .= htmlspecialchars($name).'[]" value="'.htmlspecialchars($key).'"';
|
|
|
1508 |
if ((! $found || $multiple) && in_array((string) $key, $selected, 1)
|
|
|
1509 |
|| (count($selected) == 0 && ! $found && ! $multiple)) {
|
|
|
1510 |
$ret .= ' checked';
|
|
|
1511 |
$found = true;
|
|
|
1512 |
}
|
|
|
1513 |
if ($readonly) {
|
|
|
1514 |
$ret .= ' disabled="disabled"';
|
|
|
1515 |
}
|
|
|
1516 |
$strip_tags && $value = strip_tags($value);
|
|
|
1517 |
$escape && $value = htmlspecialchars($value);
|
|
|
1518 |
$ret .= '>'.$value.'<br>'."\n";
|
|
|
1519 |
}
|
|
|
1520 |
return $ret;
|
|
|
1521 |
} /* }}} */
|
|
|
1522 |
|
|
|
1523 |
/**
|
|
|
1524 |
* Returns original variables HTML code for use in forms or links.
|
|
|
1525 |
*
|
|
|
1526 |
* @param mixed $origvars string or array of original varaibles
|
|
|
1527 |
* @param string $method type of method ("POST" or "GET")
|
|
|
1528 |
* @param mixed $default_value default value of variables
|
|
|
1529 |
* if null, empty values will be skipped
|
|
|
1530 |
* @return get HTML code of original varaibles
|
|
|
1531 |
*/
|
|
|
1532 |
function get_origvars_html($origvars, $method = 'post', $default_value = '') /* {{{ */
|
|
|
1533 |
{
|
|
|
1534 |
$ret = '';
|
|
|
1535 |
$method = strtoupper($method);
|
|
|
1536 |
if ($method == 'POST') {
|
|
|
1537 |
if (! is_array($origvars)) {
|
|
|
1538 |
$new_origvars = array();
|
|
|
1539 |
foreach (explode('&', $origvars) as $param) {
|
|
|
1540 |
$parts = explode('=', $param, 2);
|
|
|
1541 |
if (! isset($parts[1])) {
|
|
|
1542 |
$parts[1] = $default_value;
|
|
|
1543 |
}
|
|
|
1544 |
if (strlen($parts[0]) <= 0) {
|
|
|
1545 |
continue;
|
|
|
1546 |
}
|
|
|
1547 |
$new_origvars[$parts[0]] = $parts[1];
|
|
|
1548 |
}
|
|
|
1549 |
$origvars =& $new_origvars;
|
|
|
1550 |
}
|
|
|
1551 |
foreach ($origvars as $key => $val) {
|
|
|
1552 |
if (strlen($val) <= 0 && $default_value === null) {
|
|
|
1553 |
continue;
|
|
|
1554 |
}
|
|
|
1555 |
$key = rawurldecode($key);
|
|
|
1556 |
$val = rawurldecode($val);
|
|
|
1557 |
$ret .= $this->htmlHidden($key, $val);
|
|
|
1558 |
}
|
|
|
1559 |
} else if (! strncmp('GET', $method, 3)) {
|
|
|
1560 |
if (! is_array($origvars)) {
|
|
|
1561 |
$ret .= $origvars;
|
|
|
1562 |
} else {
|
|
|
1563 |
foreach ($origvars as $key => $val) {
|
|
|
1564 |
if (strlen($val) <= 0 && $default_value === null) {
|
|
|
1565 |
continue;
|
|
|
1566 |
}
|
|
|
1567 |
$ret == '' || $ret .= '&';
|
|
|
1568 |
$ret .= htmlspecialchars(rawurlencode($key));
|
|
|
1569 |
$ret .= '=';
|
|
|
1570 |
$ret .= htmlspecialchars(rawurlencode($val));
|
|
|
1571 |
}
|
|
|
1572 |
}
|
|
|
1573 |
if ($method[strlen($method) - 1] == '+') {
|
|
|
1574 |
$ret = "?$ret";
|
|
|
1575 |
}
|
|
|
1576 |
} else {
|
|
|
1577 |
trigger_error('Unsupported Platon::get_origvars_html() method: '
|
|
|
1578 |
.$method, E_USER_ERROR);
|
|
|
1579 |
}
|
|
|
1580 |
return $ret;
|
|
|
1581 |
} /* }}} */
|
|
|
1582 |
|
|
|
1583 |
function get_sfn_cgi_vars($alternative_sfn = null) /* {{{ */
|
|
|
1584 |
{
|
|
|
1585 |
if ($alternative_sfn === null) { // FAST! (cached return value)
|
|
|
1586 |
static $ret = null;
|
|
|
1587 |
$ret == null && $ret = $this->get_sfn_cgi_vars($this->sfn);
|
|
|
1588 |
return $ret;
|
|
|
1589 |
}
|
|
|
1590 |
$ret = '';
|
|
|
1591 |
$i = 0;
|
|
|
1592 |
foreach ($alternative_sfn as $val) {
|
|
|
1593 |
$ret != '' && $ret .= '&';
|
|
|
1594 |
$ret .= rawurlencode($this->cgi['prefix']['sys'].'sfn')."[$i]=".rawurlencode($val);
|
|
|
1595 |
$i++;
|
|
|
1596 |
}
|
|
|
1597 |
return $ret;
|
|
|
1598 |
} /* }}} */
|
|
|
1599 |
|
|
|
1600 |
function get_default_cgi_prefix($type) /* {{{ */
|
|
|
1601 |
{
|
|
|
1602 |
switch ($type) {
|
|
|
1603 |
case 'operation': return 'PME_op_';
|
|
|
1604 |
case 'sys': return 'PME_sys_';
|
|
|
1605 |
case 'data': return 'PME_data_';
|
|
|
1606 |
}
|
|
|
1607 |
return '';
|
|
|
1608 |
} /* }}} */
|
|
|
1609 |
|
|
|
1610 |
function get_sys_cgi_var($name, $default_value = null) /* {{{ */
|
|
|
1611 |
{
|
|
|
1612 |
if (isset($this)) {
|
|
|
1613 |
return $this->get_cgi_var($this->cgi['prefix']['sys'].$name, $default_value);
|
|
|
1614 |
}
|
|
|
1615 |
return phpMyEdit::get_cgi_var(phpMyEdit::get_default_cgi_prefix('sys').$name, $default_value);
|
|
|
1616 |
} /* }}} */
|
|
|
1617 |
|
|
|
1618 |
function get_data_cgi_var($name, $default_value = null) /* {{{ */
|
|
|
1619 |
{
|
|
|
1620 |
if (isset($this)) {
|
|
|
1621 |
return $this->get_cgi_var($this->cgi['prefix']['data'].$name, $default_value);
|
|
|
1622 |
}
|
|
|
1623 |
return phpMyEdit::get_cgi_var(phpMyEdit::get_default_cgi_prefix('data').$name, $default_value);
|
|
|
1624 |
} /* }}} */
|
|
|
1625 |
|
|
|
1626 |
function get_cgi_var($name, $default_value = null) /* {{{ */
|
|
|
1627 |
{
|
|
|
1628 |
if (isset($this) && isset($this->cgi['overwrite'][$name])) {
|
|
|
1629 |
return $this->cgi['overwrite'][$name];
|
|
|
1630 |
}
|
|
|
1631 |
|
|
|
1632 |
static $magic_quotes_gpc = null;
|
|
|
1633 |
if ($magic_quotes_gpc === null) {
|
|
|
1634 |
$magic_quotes_gpc = get_magic_quotes_gpc();
|
|
|
1635 |
}
|
|
|
1636 |
$var = @$_GET[$name];
|
|
|
1637 |
if (! isset($var)) {
|
|
|
1638 |
$var = @$_POST[$name];
|
|
|
1639 |
}
|
|
|
1640 |
if (isset($var)) {
|
|
|
1641 |
if ($magic_quotes_gpc) {
|
|
|
1642 |
if (is_array($var)) {
|
|
|
1643 |
foreach (array_keys($var) as $key) {
|
|
|
1644 |
$var[$key] = stripslashes($var[$key]);
|
|
|
1645 |
}
|
|
|
1646 |
} else {
|
|
|
1647 |
$var = stripslashes($var);
|
|
|
1648 |
}
|
|
|
1649 |
}
|
|
|
1650 |
} else {
|
|
|
1651 |
$var = @$default_value;
|
|
|
1652 |
}
|
|
|
1653 |
if (isset($this) && $var === null && isset($this->cgi['append'][$name])) {
|
|
|
1654 |
return $this->cgi['append'][$name];
|
|
|
1655 |
}
|
|
|
1656 |
return $var;
|
|
|
1657 |
} /* }}} */
|
|
|
1658 |
|
|
|
1659 |
function get_server_var($name) /* {{{ */
|
|
|
1660 |
{
|
|
|
1661 |
if (isset($_SERVER[$name])) {
|
|
|
1662 |
return $_SERVER[$name];
|
|
|
1663 |
}
|
|
|
1664 |
global $HTTP_SERVER_VARS;
|
|
|
1665 |
if (isset($HTTP_SERVER_VARS[$name])) {
|
|
|
1666 |
return $HTTP_SERVER_VARS[$name];
|
|
|
1667 |
}
|
|
|
1668 |
global $$name;
|
|
|
1669 |
if (isset($$name)) {
|
|
|
1670 |
return $$name;
|
|
|
1671 |
}
|
|
|
1672 |
return null;
|
|
|
1673 |
} /* }}} */
|
|
|
1674 |
|
|
|
1675 |
/*
|
|
|
1676 |
* Debug functions
|
|
|
1677 |
*/
|
|
|
1678 |
|
|
|
1679 |
function print_get_vars ($miss = 'No GET variables found') // debug only /* {{{ */
|
|
|
1680 |
{
|
|
|
1681 |
// we parse form GET variables
|
|
|
1682 |
if (is_array($_GET)) {
|
|
|
1683 |
echo "<p> Variables per GET ";
|
|
|
1684 |
foreach ($_GET as $k => $v) {
|
|
|
1685 |
if (is_array($v)) {
|
|
|
1686 |
foreach ($v as $akey => $aval) {
|
|
|
1687 |
// $_GET[$k][$akey] = strip_tags($aval);
|
|
|
1688 |
// $$k[$akey] = strip_tags($aval);
|
|
|
1689 |
echo "$k\[$akey\]=$aval ";
|
|
|
1690 |
}
|
|
|
1691 |
} else {
|
|
|
1692 |
// $_GET[$k] = strip_tags($val);
|
|
|
1693 |
// $$k = strip_tags($val);
|
|
|
1694 |
echo "$k=$v ";
|
|
|
1695 |
}
|
|
|
1696 |
}
|
|
|
1697 |
echo '</p>';
|
|
|
1698 |
} else {
|
|
|
1699 |
echo '<p>';
|
|
|
1700 |
echo $miss;
|
|
|
1701 |
echo '</p>';
|
|
|
1702 |
}
|
|
|
1703 |
} /* }}} */
|
|
|
1704 |
|
|
|
1705 |
function print_post_vars($miss = 'No POST variables found') // debug only /* {{{ */
|
|
|
1706 |
{
|
|
|
1707 |
global $_POST;
|
|
|
1708 |
// we parse form POST variables
|
|
|
1709 |
if (is_array($_POST)) {
|
|
|
1710 |
echo "<p>Variables per POST ";
|
|
|
1711 |
foreach ($_POST as $k => $v) {
|
|
|
1712 |
if (is_array($v)) {
|
|
|
1713 |
foreach ($v as $akey => $aval) {
|
|
|
1714 |
// $_POST[$k][$akey] = strip_tags($aval);
|
|
|
1715 |
// $$k[$akey] = strip_tags($aval);
|
|
|
1716 |
echo "$k\[$akey\]=$aval ";
|
|
|
1717 |
}
|
|
|
1718 |
} else {
|
|
|
1719 |
// $_POST[$k] = strip_tags($val);
|
|
|
1720 |
// $$k = strip_tags($val);
|
|
|
1721 |
echo "$k=$v ";
|
|
|
1722 |
}
|
|
|
1723 |
}
|
|
|
1724 |
echo '</p>';
|
|
|
1725 |
} else {
|
|
|
1726 |
echo '<p>';
|
|
|
1727 |
echo $miss;
|
|
|
1728 |
echo '</p>';
|
|
|
1729 |
}
|
|
|
1730 |
} /* }}} */
|
|
|
1731 |
|
|
|
1732 |
function print_vars ($miss = 'Current instance variables') // debug only /* {{{ */
|
|
|
1733 |
{
|
|
|
1734 |
echo "$miss ";
|
|
|
1735 |
echo 'page_name=',$this->page_name,' ';
|
|
|
1736 |
echo 'hn=',$this->hn,' ';
|
|
|
1737 |
echo 'un=',$this->un,' ';
|
|
|
1738 |
echo 'pw=',$this->pw,' ';
|
|
|
1739 |
echo 'db=',$this->db,' ';
|
|
|
1740 |
echo 'dbp=',$this->dbp,' ';
|
|
|
1741 |
echo 'dbh=',$this->dbh,' ';
|
|
|
1742 |
echo 'tb=',$this->tb,' ';
|
|
|
1743 |
echo 'key=',$this->key,' ';
|
|
|
1744 |
echo 'key_type=',$this->key_type,' ';
|
|
|
1745 |
echo 'inc=',$this->inc,' ';
|
|
|
1746 |
echo 'options=',$this->options,' ';
|
|
|
1747 |
echo 'fdd=',$this->fdd,' ';
|
|
|
1748 |
echo 'fl=',$this->fl,' ';
|
|
|
1749 |
echo 'fm=',$this->fm,' ';
|
|
|
1750 |
echo 'sfn=',htmlspecialchars($this->get_sfn_cgi_vars()),' ';
|
|
|
1751 |
echo 'qfn=',$this->qfn,' ';
|
|
|
1752 |
echo 'sw=',$this->sw,' ';
|
|
|
1753 |
echo 'rec=',$this->rec,' ';
|
|
|
1754 |
echo 'navop=',$this->navop,' ';
|
|
|
1755 |
echo 'saveadd=',$this->saveadd,' ';
|
|
|
1756 |
echo 'moreadd=',$this->moreadd,' ';
|
|
|
1757 |
echo 'canceladd=',$this->canceladd,' ';
|
|
|
1758 |
echo 'savechange=',$this->savechange,' ';
|
|
|
1759 |
echo 'morechange=',$this->morechange,' ';
|
|
|
1760 |
echo 'cancelchange=',$this->cancelchange,' ';
|
|
|
1761 |
echo 'savecopy=',$this->savecopy,' ';
|
|
|
1762 |
echo 'cancelcopy=',$this->cancelcopy,' ';
|
|
|
1763 |
echo 'savedelete=',$this->savedelete,' ';
|
|
|
1764 |
echo 'canceldelete=',$this->canceldelete,' ';
|
|
|
1765 |
echo 'cancelview=',$this->cancelview,' ';
|
|
|
1766 |
echo 'operation=',$this->operation,' ';
|
|
|
1767 |
echo "\n";
|
|
|
1768 |
} /* }}} */
|
|
|
1769 |
|
|
|
1770 |
/*
|
|
|
1771 |
* Display buttons at top and bottom of page
|
|
|
1772 |
*/
|
|
|
1773 |
function display_list_table_buttons($position, $listall = false) /* {{{ */
|
|
|
1774 |
{
|
|
|
1775 |
if (($but_str = $this->display_buttons($position)) === null)
|
|
|
1776 |
return;
|
|
|
1777 |
if($position == 'down') echo '<hr class="'.$this->getCSSclass('hr', 'down').'" />'."\n";
|
|
|
1778 |
echo '<table summary="navigation" class="',$this->getCSSclass('navigation', $position),'">',"\n";
|
|
|
1779 |
echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n";
|
|
|
1780 |
echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n";
|
|
|
1781 |
echo $but_str,'</td>',"\n";
|
|
|
1782 |
// Message is now written here
|
|
|
1783 |
if (strlen(@$this->message) > 0) {
|
|
|
1784 |
echo '<td class="',$this->getCSSclass('message', $position),'">',$this->message,'</td>',"\n";
|
|
|
1785 |
}
|
|
|
1786 |
if($this->display['num_pages'] || $this->display['num_records'])
|
|
|
1787 |
echo '<td class="',$this->getCSSclass('stats', $position),'">',"\n";
|
|
|
1788 |
if($this->display['num_pages']) {
|
|
|
1789 |
if ($listall) {
|
|
|
1790 |
echo $this->labels['Page'],': 1 ',$this->labels['of'],' 1';
|
|
|
1791 |
} else {
|
|
|
1792 |
$current_page = intval($this->fm / $this->inc) + 1;
|
|
|
1793 |
$total_pages = max(1, ceil($this->total_recs / abs($this->inc)));
|
|
|
1794 |
echo $this->labels['Page'],': ',$current_page;
|
|
|
1795 |
echo ' ',$this->labels['of'],' ',$total_pages;
|
|
|
1796 |
}
|
|
|
1797 |
}
|
|
|
1798 |
if($this->display['num_records'])
|
|
|
1799 |
echo ' ',$this->labels['Records'],': ',$this->total_recs;
|
|
|
1800 |
if($this->display['num_pages'] || $this->display['num_records']) echo '</td>';
|
|
|
1801 |
echo '</tr></table>',"\n";
|
|
|
1802 |
if($position == 'up') echo '<hr class="'.$this->getCSSclass('hr', 'up').'" />'."\n";
|
|
|
1803 |
} /* }}} */
|
|
|
1804 |
|
|
|
1805 |
/*
|
|
|
1806 |
* Display buttons at top and bottom of page
|
|
|
1807 |
*/
|
|
|
1808 |
function display_record_buttons($position) /* {{{ */
|
|
|
1809 |
{
|
|
|
1810 |
if (($but_str = $this->display_buttons($position)) === null)
|
|
|
1811 |
return;
|
|
|
1812 |
if ($position == 'down') {
|
|
|
1813 |
if ($this->tabs_enabled()) $this->display_tab_labels('down');
|
|
|
1814 |
echo '<hr class="',$this->getCSSclass('hr', 'down'),'" />',"\n";
|
|
|
1815 |
}
|
|
|
1816 |
echo '<table summary="navigation" class="',$this->getCSSclass('navigation', $position),'">',"\n";
|
|
|
1817 |
echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n";
|
|
|
1818 |
echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n";
|
|
|
1819 |
echo $but_str,'</td>',"\n";
|
|
|
1820 |
// Message is now written here
|
|
|
1821 |
//echo '</td>',"\n";
|
|
|
1822 |
if (strlen(@$this->message) > 0) {
|
|
|
1823 |
echo '<td class="',$this->getCSSclass('message', $position),'">',$this->message,'</td>',"\n";
|
|
|
1824 |
}
|
|
|
1825 |
echo '</tr></table>',"\n";
|
|
|
1826 |
if ($position == 'up') {
|
|
|
1827 |
if ($this->tabs_enabled()) $this->display_tab_labels('up');
|
|
|
1828 |
echo '<hr class="',$this->getCSSclass('hr', 'up'),'" />',"\n";
|
|
|
1829 |
}
|
|
|
1830 |
} /* }}} */
|
|
|
1831 |
|
|
|
1832 |
function display_buttons($position) /* {{{ */
|
|
|
1833 |
{
|
|
|
1834 |
$nav_fnc = 'nav_'.$position;
|
|
|
1835 |
if(! $this->$nav_fnc())
|
|
|
1836 |
return;
|
|
|
1837 |
$buttons = (is_array($this->buttons[$this->page_type][$position]))
|
|
|
1838 |
? $this->buttons[$this->page_type][$position]
|
|
|
1839 |
: $this->default_buttons[$this->page_type];
|
|
|
1840 |
foreach ($buttons as $name) {
|
|
|
1841 |
$ret .= $this->display_button($name, $position)."\n";
|
|
|
1842 |
}
|
|
|
1843 |
return $ret;
|
|
|
1844 |
} /* }}} */
|
|
|
1845 |
|
|
|
1846 |
function display_button($name, $position = 'up') /* {{{ */
|
|
|
1847 |
{
|
|
|
1848 |
if (is_array($name)) {
|
|
|
1849 |
if (isset($name['code'])) return $name['code'];
|
|
|
1850 |
return $this->htmlSubmit($name['name'], $name['value'], $name['css'], $name['disabled'], $name['js']);
|
|
|
1851 |
}
|
|
|
1852 |
$disabled = 1; // show disabled by default
|
|
|
1853 |
if ($name[0] == '+') { $name = substr($name, 1); $disabled = 0; } // always show disabled as enabled
|
|
|
1854 |
if ($name[0] == '-') { $name = substr($name, 1); $disabled = -1; } // don't show disabled
|
|
|
1855 |
if ($name == 'cancel') {
|
|
|
1856 |
return $this->htmlSubmit('cancel'.$this->page_types[$this->page_type], 'Cancel',
|
|
|
1857 |
$this->getCSSclass('cancel', $position), false);
|
|
|
1858 |
}
|
|
|
1859 |
if (in_array($name, array('add','view','change','copy','delete'))) {
|
|
|
1860 |
$enabled_fnc = $name.'_enabled';
|
|
|
1861 |
$enabled = $this->$enabled_fnc();
|
|
|
1862 |
if ($name != 'add' && ! $this->total_recs && strstr('LF', $this->page_type))
|
|
|
1863 |
$enabled = false;
|
|
|
1864 |
return $this->htmlSubmit('operation', ucfirst($name),
|
|
|
1865 |
$this->getCSSclass($name, $position), false, $enabled ? 0 : $disabled);
|
|
|
1866 |
}
|
|
|
1867 |
if ($name == 'savedelete') {
|
|
|
1868 |
$enabled = $this->delete_enabled();
|
|
|
1869 |
$js = 'onclick="return confirm(\''.$this->labels['Delete'].' ?\');"';
|
|
|
1870 |
return $this->htmlSubmit('savedelete', 'Delete',
|
|
|
1871 |
$this->getCSSclass('save', $position), false, $enabled ? 0 : $disabled, $js);
|
|
|
1872 |
}
|
|
|
1873 |
if (in_array($name, array('save','more'))) {
|
|
|
1874 |
$validation = true; // if js validation
|
|
|
1875 |
if ($this->page_type == 'D' && $name == 'save' ) { $value = 'Delete'; $validation = false; }
|
|
|
1876 |
elseif ($this->page_type == 'C' && $name == 'more' ) { $value = 'Apply'; }
|
|
|
1877 |
else $value = ucfirst($name);
|
|
|
1878 |
return $this->htmlSubmit($name.$this->page_types[$this->page_type], $value,
|
|
|
1879 |
$this->getCSSclass($name, $position), $validation);
|
|
|
1880 |
}
|
|
|
1881 |
$listall = $this->inc <= 0;
|
|
|
1882 |
if ($listall) {
|
|
|
1883 |
$disabledprev = true;
|
|
|
1884 |
$disablednext = true;
|
|
|
1885 |
$total_pages = 1;
|
|
|
1886 |
$current_page = 1;
|
|
|
1887 |
} else {
|
|
|
1888 |
$disabledprev = $this->fm <= 0;
|
|
|
1889 |
$disablednext = $this->fm + $this->inc >= $this->total_recs;
|
|
|
1890 |
$total_pages = max(1, ceil($this->total_recs / abs($this->inc)));
|
|
|
1891 |
$current_page = ceil($this->fm / abs($this->inc)); // must + 1
|
|
|
1892 |
}
|
|
|
1893 |
$disabledfirst = $disabledprev;
|
|
|
1894 |
$disabledlast = $disablednext;
|
|
|
1895 |
// some statistics first
|
|
|
1896 |
if ($name == 'total_pages') return $total_pages;
|
|
|
1897 |
if ($name == 'current_page') return ($current_page+1);
|
|
|
1898 |
if ($name == 'total_recs') return ($this->total_recs);
|
|
|
1899 |
// now some goto buttons/dropdowns/inputs...
|
|
|
1900 |
if ($name == 'goto_text') {
|
|
|
1901 |
$ret = '<input type="text" class="'.$this->getCSSclass('gotopn', $position).'"';
|
|
|
1902 |
$ret .= ' name="'.$this->cgi['prefix']['sys'].'navpn'.$position.'" value="'.($current_page+1).'"';
|
|
|
1903 |
$ret .= ' size="'.(strlen($total_pages)+1).'" maxlength="'.(strlen($total_pages)+1).'"';
|
|
|
1904 |
// TODO some js here.... on enter submit, on click erase ?...
|
|
|
1905 |
$ret .=' oneypress="return PE_filter_handler(this.form, event);" />';
|
|
|
1906 |
return $ret;
|
|
|
1907 |
}
|
|
|
1908 |
if ($name == 'goto_combo') {
|
|
|
1909 |
$disabledgoto = !($listall || ($disablednext && $disabledprev)) ? '' : ' disabled';
|
|
|
1910 |
if ($disablegoto != '' && $disabled < 0) return;
|
|
|
1911 |
$kv_array = array();
|
|
|
1912 |
for ($i = 0; $i < $total_pages; $i++) {
|
|
|
1913 |
$kv_array[$this->inc * $i] = $i + 1;
|
|
|
1914 |
}
|
|
|
1915 |
// TODO: add onchange="return this.form.submit();" DONE ???
|
|
|
1916 |
return $this->htmlSelect($this->cgi['prefix']['sys'].ltrim($disabledgoto).'navfm'.$position,
|
|
|
1917 |
$this->getCSSclass('goto', $position), $kv_array, (string)$this->fm, false, $disabledgoto,
|
|
|
1918 |
false, true, 'onchange="return this.form.submit();"');
|
|
|
1919 |
}
|
|
|
1920 |
if ($name == 'goto') {
|
|
|
1921 |
return $this->htmlSubmit('navop', 'Go to', $this->getCSSclass('goto', $position),
|
|
|
1922 |
false, ($listall || ($disablednext && $disabledprev)) ? $disabled : 0);
|
|
|
1923 |
}
|
|
|
1924 |
if (in_array($name, array('first','prev','next','last','<<','<','>','>>'))) {
|
|
|
1925 |
$disabled_var = 'disabled'.$name;
|
|
|
1926 |
$name2 = $name;
|
|
|
1927 |
if (strlen($name) <= 2) {
|
|
|
1928 |
$nav_values = array('<<' => 'first', '<' => 'prev', '>' => 'next', '>>' => 'last');
|
|
|
1929 |
$disabled_var = 'disabled'.$nav_values[$name];
|
|
|
1930 |
$name2 = $nav_values[$name];
|
|
|
1931 |
}
|
|
|
1932 |
return $this->htmlSubmit('navop', ucfirst($name),
|
|
|
1933 |
$this->getCSSclass($name2, $position), false, $$disabled_var ? $disabled : 0);
|
|
|
1934 |
}
|
|
|
1935 |
if(isset($this->labels[$name])) return $this->labels[$name];
|
|
|
1936 |
return $name;
|
|
|
1937 |
} /* }}} */
|
|
|
1938 |
|
|
|
1939 |
function number_of_recs() /* {{{ */
|
|
|
1940 |
{
|
|
|
1941 |
$count_parts = array(
|
|
|
1942 |
'type' => 'select',
|
|
|
1943 |
'select' => 'count(*)',
|
|
|
1944 |
'from' => $this->get_SQL_join_clause(),
|
|
|
1945 |
'where' => $this->get_SQL_where_from_query_opts());
|
|
|
1946 |
$res = $this->myquery($this->get_SQL_query($count_parts), __LINE__);
|
|
|
1947 |
$row = @mysql_fetch_array($res, MYSQL_NUM);
|
|
|
1948 |
$this->total_recs = $row[0];
|
|
|
1949 |
} /* }}} */
|
|
|
1950 |
|
|
|
1951 |
/*
|
|
|
1952 |
* Table Page Listing
|
|
|
1953 |
*/
|
|
|
1954 |
function list_table() /* {{{ */
|
|
|
1955 |
{
|
|
|
1956 |
if ($this->fm == '') {
|
|
|
1957 |
$this->fm = 0;
|
|
|
1958 |
}
|
|
|
1959 |
$this->fm = $this->navfm;
|
|
|
1960 |
if ($this->prev_operation()) {
|
|
|
1961 |
$this->fm = $this->fm - $this->inc;
|
|
|
1962 |
if ($this->fm < 0) {
|
|
|
1963 |
$this->fm = 0;
|
|
|
1964 |
}
|
|
|
1965 |
}
|
|
|
1966 |
if ($this->first_operation()) {
|
|
|
1967 |
$this->fm = 0;
|
|
|
1968 |
} // last operation must be performed below, after retrieving total_recs
|
|
|
1969 |
if ($this->next_operation()) {
|
|
|
1970 |
$this->fm += $this->inc;
|
|
|
1971 |
}
|
|
|
1972 |
$this->number_of_recs();
|
|
|
1973 |
if ($this->last_operation() || $this->fm > $this->total_recs) { // if goto_text is badly set
|
|
|
1974 |
$this->fm = (int)(($this->total_recs - 1)/$this->inc)*$this->inc;
|
|
|
1975 |
}
|
|
|
1976 |
// If sort sequence has changed, restart listing
|
|
|
1977 |
$this->qfn != $this->prev_qfn && $this->fm = 0;
|
|
|
1978 |
if (0) { // DEBUG
|
|
|
1979 |
echo 'qfn vs. prev_qfn comparsion ';
|
|
|
1980 |
echo '[<b>',htmlspecialchars($this->qfn),'</b>]';
|
|
|
1981 |
echo '[<b>',htmlspecialchars($this->prev_qfn),'</b>]<br />';
|
|
|
1982 |
echo 'comparsion <u>',($this->qfn == $this->prev_qfn ? 'proved' : 'failed'),'</u>';
|
|
|
1983 |
echo '<hr />';
|
|
|
1984 |
}
|
|
|
1985 |
/*
|
|
|
1986 |
* If user is allowed to Change/Delete records, we need an extra column
|
|
|
1987 |
* to allow users to select a record
|
|
|
1988 |
*/
|
|
|
1989 |
$select_recs = $this->key != '' &&
|
|
|
1990 |
($this->change_enabled() || $this->delete_enabled() || $this->view_enabled());
|
|
|
1991 |
// Are we doing a listall?
|
|
|
1992 |
$listall = $this->inc <= 0;
|
|
|
1993 |
/*
|
|
|
1994 |
* Display the MySQL table in an HTML table
|
|
|
1995 |
*/
|
|
|
1996 |
$this->form_begin();
|
|
|
1997 |
echo $this->get_origvars_html($this->get_sfn_cgi_vars());
|
|
|
1998 |
echo $this->htmlHiddenSys('fl', $this->fl);
|
|
|
1999 |
// Display buttons at top and/or bottom of page.
|
|
|
2000 |
$this->display_list_table_buttons('up', $listall);
|
|
|
2001 |
if ($this->cgi['persist'] != '') {
|
|
|
2002 |
echo $this->get_origvars_html($this->cgi['persist']);
|
|
|
2003 |
}
|
|
|
2004 |
if (! $this->filter_operation()) {
|
|
|
2005 |
echo $this->get_origvars_html($this->qfn);
|
|
|
2006 |
}
|
|
|
2007 |
echo $this->htmlHiddenSys('qfn', $this->qfn);
|
|
|
2008 |
echo $this->htmlHiddenSys('fm', $this->fm);
|
|
|
2009 |
echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n";
|
|
|
2010 |
echo '<tr class="',$this->getCSSclass('header'),'">',"\n";
|
|
|
2011 |
/*
|
|
|
2012 |
* System (navigation, selection) columns counting
|
|
|
2013 |
*/
|
|
|
2014 |
$sys_cols = 0;
|
|
|
2015 |
$sys_cols += intval($this->filter_enabled() || $select_recs);
|
|
|
2016 |
if ($sys_cols > 0) {
|
|
|
2017 |
$sys_cols += intval($this->nav_buttons()
|
|
|
2018 |
&& ($this->nav_text_links() || $this->nav_graphic_links()));
|
|
|
2019 |
}
|
|
|
2020 |
/*
|
|
|
2021 |
* We need an initial column(s) (sys columns)
|
|
|
2022 |
* if we have filters, Changes or Deletes enabled
|
|
|
2023 |
*/
|
|
|
2024 |
if ($sys_cols) {
|
|
|
2025 |
echo '<th class="',$this->getCSSclass('header'),'" colspan="',$sys_cols,'">';
|
|
|
2026 |
if ($this->filter_enabled()) {
|
|
|
2027 |
if ($this->filter_operation()) {
|
|
|
2028 |
echo $this->htmlSubmit('sw', 'Hide', $this->getCSSclass('hide'), false);
|
|
|
2029 |
echo $this->htmlSubmit('sw', 'Clear', $this->getCSSclass('clear'), false);
|
|
|
2030 |
} else {
|
|
|
2031 |
echo $this->htmlSubmit('sw', 'Search', $this->getCSSclass('search'), false);
|
|
|
2032 |
}
|
|
|
2033 |
} else {
|
|
|
2034 |
echo ' ';
|
|
|
2035 |
}
|
|
|
2036 |
echo '</th>',"\n";
|
|
|
2037 |
}
|
|
|
2038 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
2039 |
$fd = $this->fds[$k];
|
|
|
2040 |
if (! $this->displayed[$k]) {
|
|
|
2041 |
continue;
|
|
|
2042 |
}
|
|
|
2043 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
2044 |
$css_class_name = $this->getCSSclass('header', null, null, $css_postfix);
|
|
|
2045 |
$fdn = $this->fdd[$fd]['name'];
|
|
|
2046 |
if (! $this->fdd[$fd]['sort'] || $this->password($fd)) {
|
|
|
2047 |
echo '<th class="',$css_class_name,'">',$fdn,'</th>',"\n";
|
|
|
2048 |
} else {
|
|
|
2049 |
// Clicking on the current sort field reverses the sort order
|
|
|
2050 |
$new_sfn = $this->sfn;
|
|
|
2051 |
array_unshift($new_sfn, in_array("$k", $new_sfn, 1) ? "-$k" : $k);
|
|
|
2052 |
echo '<th class="',$css_class_name,'">';
|
|
|
2053 |
echo '<a class="',$css_class_name,'" href="';
|
|
|
2054 |
echo htmlspecialchars($this->page_name.'?'.$this->cgi['prefix']['sys'].'fm'.'=0'
|
|
|
2055 |
.'&'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl
|
|
|
2056 |
.'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn).$this->qfn
|
|
|
2057 |
.'&'.$this->get_sfn_cgi_vars($new_sfn).$this->cgi['persist']);
|
|
|
2058 |
echo '">',$fdn,'</a></th>',"\n";
|
|
|
2059 |
}
|
|
|
2060 |
}
|
|
|
2061 |
echo '</tr>',"\n";
|
|
|
2062 |
|
|
|
2063 |
/*
|
|
|
2064 |
* Prepare the SQL Query from the data definition file
|
|
|
2065 |
*/
|
|
|
2066 |
$qparts['type'] = 'select';
|
|
|
2067 |
$qparts['select'] = $this->get_SQL_column_list();
|
|
|
2068 |
// Even if the key field isn't displayed, we still need its value
|
|
|
2069 |
if ($select_recs) {
|
|
|
2070 |
if (!in_array ($this->key, $this->fds)) {
|
|
|
2071 |
$qparts['select'] .= ','.$this->fqn($this->key);
|
|
|
2072 |
}
|
|
|
2073 |
}
|
|
|
2074 |
$qparts['from'] = $this->get_SQL_join_clause();
|
|
|
2075 |
$qparts['where'] = $this->get_SQL_where_from_query_opts();
|
|
|
2076 |
// build up the ORDER BY clause
|
|
|
2077 |
if (isset($this->sfn)) {
|
|
|
2078 |
$sort_fields = array();
|
|
|
2079 |
$sort_fields_w = array();
|
|
|
2080 |
foreach ($this->sfn as $field) {
|
|
|
2081 |
if ($field[0] == '-') {
|
|
|
2082 |
$field = substr($field, 1);
|
|
|
2083 |
$desc = true;
|
|
|
2084 |
} else {
|
|
|
2085 |
$field = $field;
|
|
|
2086 |
$desc = false;
|
|
|
2087 |
}
|
|
|
2088 |
$sort_field = $this->fqn($field);
|
|
|
2089 |
$sort_field_w = $this->fdd[$field]['name'];
|
|
|
2090 |
$this->col_has_sql($field) && $sort_field_w .= ' (sql)';
|
|
|
2091 |
if ($desc) {
|
|
|
2092 |
$sort_field .= ' DESC';
|
|
|
2093 |
$sort_field_w .= ' '.$this->labels['descending'];
|
|
|
2094 |
} else {
|
|
|
2095 |
$sort_field_w .= ' '.$this->labels['ascending'];
|
|
|
2096 |
}
|
|
|
2097 |
$sort_fields[] = $sort_field;
|
|
|
2098 |
$sort_fields_w[] = $sort_field_w;
|
|
|
2099 |
}
|
|
|
2100 |
if (count($sort_fields) > 0) {
|
|
|
2101 |
$qparts['orderby'] = join(',', $sort_fields);
|
|
|
2102 |
}
|
|
|
2103 |
}
|
|
|
2104 |
$qparts['limit'] = $listall ? '' : $this->fm.','.$this->inc;
|
|
|
2105 |
|
|
|
2106 |
/*
|
|
|
2107 |
* Main list_table() query
|
|
|
2108 |
*
|
|
|
2109 |
* Each row of the HTML table is one record from the SQL query. We must
|
|
|
2110 |
* perform this query before filter printing, because we want to use
|
|
|
2111 |
* mysql_field_len() function. We will also fetch the first row to get
|
|
|
2112 |
* the field names.
|
|
|
2113 |
*/
|
|
|
2114 |
$query = $this->get_SQL_query($qparts);
|
|
|
2115 |
$res = $this->myquery($query, __LINE__);
|
|
|
2116 |
if ($res == false) {
|
|
|
2117 |
$this->error('invalid SQL query', $query);
|
|
|
2118 |
return false;
|
|
|
2119 |
}
|
|
|
2120 |
$row = @mysql_fetch_array($res, MYSQL_ASSOC);
|
|
|
2121 |
|
|
|
2122 |
/* FILTER {{{
|
|
|
2123 |
*
|
|
|
2124 |
* Draw the filter and fill it with any data typed in last pass and stored
|
|
|
2125 |
* in the array parameter keyword 'filter'. Prepare the SQL WHERE clause.
|
|
|
2126 |
*/
|
|
|
2127 |
if ($this->filter_operation()) {
|
|
|
2128 |
// Filter row retrieval
|
|
|
2129 |
$fields = false;
|
|
|
2130 |
$filter_row = $row;
|
|
|
2131 |
if (! is_array($filter_row)) {
|
|
|
2132 |
unset($qparts['where']);
|
|
|
2133 |
$query = $this->get_SQL_query($qparts);
|
|
|
2134 |
$res = $this->myquery($query, __LINE__);
|
|
|
2135 |
if ($res == false) {
|
|
|
2136 |
$this->error('invalid SQL query', $query);
|
|
|
2137 |
return false;
|
|
|
2138 |
}
|
|
|
2139 |
$filter_row = @mysql_fetch_array($res, MYSQL_ASSOC);
|
|
|
2140 |
}
|
|
|
2141 |
/* Variable $fields is used to get index of particular field in
|
|
|
2142 |
result. That index can be passed in example to mysql_field_len()
|
|
|
2143 |
function. Use field names as indexes to $fields array. */
|
|
|
2144 |
if (is_array($filter_row)) {
|
|
|
2145 |
$fields = array_flip(array_keys($filter_row));
|
|
|
2146 |
}
|
|
|
2147 |
if ($fields != false) {
|
|
|
2148 |
$css_class_name = $this->getCSSclass('filter');
|
|
|
2149 |
echo '<tr class="',$css_class_name,'">',"\n";
|
|
|
2150 |
echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">';
|
|
|
2151 |
echo $this->htmlSubmit('filter', 'Query', $this->getCSSclass('query'), false);
|
|
|
2152 |
echo '</td>', "\n";
|
|
|
2153 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
2154 |
if (! $this->displayed[$k]) {
|
|
|
2155 |
continue;
|
|
|
2156 |
}
|
|
|
2157 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
2158 |
$css_class_name = $this->getCSSclass('filter', null, null, $css_postfix);
|
|
|
2159 |
$this->field_name = $this->fds[$k];
|
|
|
2160 |
$fd = $this->field_name;
|
|
|
2161 |
$this->field = $this->fdd[$fd];
|
|
|
2162 |
$l = 'qf'.$k;
|
|
|
2163 |
$lc = 'qf'.$k.'_comp';
|
|
|
2164 |
$li = 'qf'.$k.'_id';
|
|
|
2165 |
if ($this->clear_operation()) {
|
|
|
2166 |
$m = null;
|
|
|
2167 |
$mc = null;
|
|
|
2168 |
$mi = null;
|
|
|
2169 |
} else {
|
|
|
2170 |
$m = $this->get_sys_cgi_var($l);
|
|
|
2171 |
$mc = $this->get_sys_cgi_var($lc);
|
|
|
2172 |
$mi = $this->get_sys_cgi_var($li);
|
|
|
2173 |
}
|
|
|
2174 |
echo '<td class="',$css_class_name,'">';
|
|
|
2175 |
if ($this->password($k)) {
|
|
|
2176 |
echo ' ';
|
|
|
2177 |
} else if ($this->fdd[$fd]['select'] == 'D' || $this->fdd[$fd]['select'] == 'M') {
|
|
|
2178 |
// Multiple fields processing
|
|
|
2179 |
// Default size is 2 and array required for values.
|
|
|
2180 |
$from_table = ! $this->col_has_values($k) || isset($this->fdd[$k]['values']['table']);
|
|
|
2181 |
$vals = $this->set_values($k, array('*' => '*'), null, $from_table);
|
|
|
2182 |
$selected = $mi;
|
|
|
2183 |
$multiple = $this->col_has_multiple_select($k);
|
|
|
2184 |
$multiple |= $this->fdd[$fd]['select'] == 'M';
|
|
|
2185 |
$readonly = false;
|
|
|
2186 |
$strip_tags = true;
|
|
|
2187 |
$escape = true;
|
|
|
2188 |
echo $this->htmlSelect($this->cgi['prefix']['sys'].$l.'_id', $css_class_name,
|
|
|
2189 |
$vals, $selected, $multiple, $readonly, $strip_tags, $escape);
|
|
|
2190 |
} elseif ($this->fdd[$fd]['select'] == 'N' || $this->fdd[$fd]['select'] == 'T') {
|
|
|
2191 |
$size_ml_props = '';
|
|
|
2192 |
$maxlen = intval($this->fdd[$k]['maxlen']);
|
|
|
2193 |
$maxlen > 0 || $maxlen = intval(@mysql_field_len($res, $fields["qf$k"]));
|
|
|
2194 |
$size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size']
|
|
|
2195 |
: ($maxlen < 30 ? min($maxlen, 8) : 12);
|
|
|
2196 |
$size && $size_ml_props .= ' size="'.$size.'"';
|
|
|
2197 |
$maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"';
|
|
|
2198 |
if ($this->fdd[$fd]['select'] == 'N') {
|
|
|
2199 |
$mc = in_array($mc, $this->comp_ops) ? $mc : '=';
|
|
|
2200 |
echo $this->htmlSelect($this->cgi['prefix']['sys'].$l.'_comp',
|
|
|
2201 |
$css_class_name, $this->comp_ops, $mc);
|
|
|
2202 |
}
|
|
|
2203 |
echo '<input class="',$css_class_name,'" value="',htmlspecialchars(@$m);
|
|
|
2204 |
echo '" type="text" name="'.$this->cgi['prefix']['sys'].'qf'.$k.'"',$size_ml_props;
|
|
|
2205 |
echo ' onkeypress="return '.$this->js['prefix'].'filter_handler(this.form, event);" />';
|
|
|
2206 |
} else {
|
|
|
2207 |
echo ' ';
|
|
|
2208 |
}
|
|
|
2209 |
echo '</td>',"\n";
|
|
|
2210 |
}
|
|
|
2211 |
echo '</tr>',"\n";
|
|
|
2212 |
}
|
|
|
2213 |
} // }}}
|
|
|
2214 |
|
|
|
2215 |
/*
|
|
|
2216 |
* Display sorting sequence
|
|
|
2217 |
*/
|
|
|
2218 |
if ($qparts['orderby'] && $this->display['sort']) {
|
|
|
2219 |
$css_class_name = $this->getCSSclass('sortinfo');
|
|
|
2220 |
echo '<tr class="',$css_class_name,'">',"\n";
|
|
|
2221 |
echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">';
|
|
|
2222 |
echo '<a class="',$css_class_name,'" href="';
|
|
|
2223 |
echo htmlspecialchars($this->page_name
|
|
|
2224 |
.'?'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl
|
|
|
2225 |
.'&'.$this->cgi['prefix']['sys'].'fm'.'='.$this->fm
|
|
|
2226 |
.'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn)
|
|
|
2227 |
.$this->qfn.$this->cgi['persist']);
|
|
|
2228 |
echo '">',$this->labels['Clear'],'</a></td>',"\n";
|
|
|
2229 |
echo '<td class="',$css_class_name,'" colspan="',$this->num_fields_displayed,'">';
|
|
|
2230 |
echo $this->labels['Sorted By'],': ',join(', ', $sort_fields_w),'</td></tr>',"\n";
|
|
|
2231 |
}
|
|
|
2232 |
|
|
|
2233 |
/*
|
|
|
2234 |
* Display the current query
|
|
|
2235 |
*/
|
|
|
2236 |
$text_query = $this->get_SQL_where_from_query_opts(null, true);
|
|
|
2237 |
if ($text_query != '' && $this->display['query']) {
|
|
|
2238 |
$css_class_name = $this->getCSSclass('queryinfo');
|
|
|
2239 |
echo '<tr class="',$css_class_name,'">',"\n";
|
|
|
2240 |
echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">';
|
|
|
2241 |
echo '<a class="',$css_class_name,'" href="';
|
|
|
2242 |
echo htmlspecialchars($this->get_server_var('PHP_SELF')
|
|
|
2243 |
.'?'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl
|
|
|
2244 |
.'&'.$this->cgi['prefix']['sys'].'fm'.'='.$this->fm
|
|
|
2245 |
.'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn)
|
|
|
2246 |
.'&'.$this->get_sfn_cgi_vars().$this->cgi['persist']);
|
|
|
2247 |
echo '">',$this->labels['Clear'],'</a></td>',"\n";
|
|
|
2248 |
echo '<td class="',$css_class_name,'" colspan="',$this->num_fields_displayed,'">';
|
|
|
2249 |
echo $this->labels['Current Query'],': ',htmlspecialchars($text_query),'</td></tr>',"\n";
|
|
|
2250 |
}
|
|
|
2251 |
|
|
|
2252 |
if ($this->nav_text_links() || $this->nav_graphic_links()) {
|
|
|
2253 |
$qstrparts = array();
|
|
|
2254 |
strlen($this->fl) > 0 && $qstrparts[] = $this->cgi['prefix']['sys'].'fl'.'='.$this->fl;
|
|
|
2255 |
strlen($this->fm) > 0 && $qstrparts[] = $this->cgi['prefix']['sys'].'fm'.'='.$this->fm;
|
|
|
2256 |
count($this->sfn) > 0 && $qstrparts[] = $this->get_sfn_cgi_vars();
|
|
|
2257 |
strlen($this->cgi['persist']) > 0 && $qstrparts[] = $this->cgi['persist'];
|
|
|
2258 |
$qpview = $qstrparts;
|
|
|
2259 |
$qpcopy = $qstrparts;
|
|
|
2260 |
$qpchange = $qstrparts;
|
|
|
2261 |
$qpdelete = $qstrparts;
|
|
|
2262 |
$qp_prefix = $this->cgi['prefix']['sys'].'operation'.'='.$this->cgi['prefix']['operation'];
|
|
|
2263 |
$qpview[] = $qp_prefix.'View';
|
|
|
2264 |
$qpcopy[] = $qp_prefix.'Copy';
|
|
|
2265 |
$qpchange[] = $qp_prefix.'Change';
|
|
|
2266 |
$qpdelete[] = $qp_prefix.'Delete';
|
|
|
2267 |
$qpviewStr = htmlspecialchars($this->page_name.'?'.join('&',$qpview).$this->qfn);
|
|
|
2268 |
$qpcopyStr = htmlspecialchars($this->page_name.'?'.join('&',$qpcopy).$this->qfn);
|
|
|
2269 |
$qpchangeStr = htmlspecialchars($this->page_name.'?'.join('&',$qpchange).$this->qfn);
|
|
|
2270 |
$qpdeleteStr = htmlspecialchars($this->page_name.'?'.join('&',$qpdelete).$this->qfn);
|
|
|
2271 |
}
|
|
|
2272 |
|
|
|
2273 |
$fetched = true;
|
|
|
2274 |
$first = true;
|
|
|
2275 |
$rowCount = 0;
|
|
|
2276 |
while ((!$fetched && ($row = @mysql_fetch_array($res, MYSQL_ASSOC)) != false)
|
|
|
2277 |
|| ($fetched && $row != false)) {
|
|
|
2278 |
$fetched = false;
|
|
|
2279 |
echo '<tr class="',$this->getCSSclass('row', null, 'next'),'">',"\n";
|
|
|
2280 |
if ($sys_cols) { /* {{{ */
|
|
|
2281 |
$key_rec = $row['qf'.$this->key_num];
|
|
|
2282 |
$queryAppend = htmlspecialchars('&'.$this->cgi['prefix']['sys'].'rec'.'='.$key_rec);
|
|
|
2283 |
$viewQuery = $qpviewStr . $queryAppend;
|
|
|
2284 |
$copyQuery = $qpcopyStr . $queryAppend;
|
|
|
2285 |
$changeQuery = $qpchangeStr . $queryAppend;
|
|
|
2286 |
$deleteQuery = $qpdeleteStr . $queryAppend;
|
|
|
2287 |
$viewTitle = htmlspecialchars($this->labels['View']);
|
|
|
2288 |
$changeTitle = htmlspecialchars($this->labels['Change']);
|
|
|
2289 |
$copyTitle = htmlspecialchars($this->labels['Copy']);
|
|
|
2290 |
$deleteTitle = htmlspecialchars($this->labels['Delete']);
|
|
|
2291 |
$css_class_name = $this->getCSSclass('navigation', null, true);
|
|
|
2292 |
if ($select_recs) {
|
|
|
2293 |
if (! $this->nav_buttons() || $sys_cols > 1) {
|
|
|
2294 |
echo '<td class="',$css_class_name,'">';
|
|
|
2295 |
}
|
|
|
2296 |
if ($this->nav_graphic_links()) {
|
|
|
2297 |
$printed_out = false;
|
|
|
2298 |
if ($this->view_enabled()) {
|
|
|
2299 |
$printed_out = true;
|
|
|
2300 |
echo '<a class="',$css_class_name,'" href="',$viewQuery,'"><img class="';
|
|
|
2301 |
echo $css_class_name,'" src="',$this->url['images'];
|
|
|
2302 |
echo 'pme-view.png" height="15" width="16" border="0" ';
|
|
|
2303 |
echo 'alt="',$viewTitle,'" title="',$viewTitle,'" /></a>';
|
|
|
2304 |
}
|
|
|
2305 |
if ($this->change_enabled()) {
|
|
|
2306 |
$printed_out && print(' ');
|
|
|
2307 |
$printed_out = true;
|
|
|
2308 |
echo '<a class="',$css_class_name,'" href="',$changeQuery,'"><img class="';
|
|
|
2309 |
echo $css_class_name,'" src="',$this->url['images'];
|
|
|
2310 |
echo 'pme-change.png" height="15" width="16" border="0" ';
|
|
|
2311 |
echo 'alt="',$changeTitle,'" title="',$changeTitle,'" /></a>';
|
|
|
2312 |
}
|
|
|
2313 |
if ($this->copy_enabled()) {
|
|
|
2314 |
$printed_out && print(' ');
|
|
|
2315 |
$printed_out = true;
|
|
|
2316 |
echo '<a class="',$css_class_name,'" href="',$copyQuery,'"><img class="';
|
|
|
2317 |
echo $css_class_name,'" src="',$this->url['images'];
|
|
|
2318 |
echo 'pme-copy.png" height="15" width="16" border="0" ';
|
|
|
2319 |
echo 'alt="',$copyTitle,'" title="',$copyTitle,'" /></a>';
|
|
|
2320 |
}
|
|
|
2321 |
if ($this->delete_enabled()) {
|
|
|
2322 |
$printed_out && print(' ');
|
|
|
2323 |
$printed_out = true;
|
|
|
2324 |
echo '<a class="',$css_class_name,'" href="',$deleteQuery,'"><img class="';
|
|
|
2325 |
echo $css_class_name,'" src="',$this->url['images'];
|
|
|
2326 |
echo 'pme-delete.png" height="15" width="16" border="0" ';
|
|
|
2327 |
echo 'alt="',$deleteTitle,'" title="',$deleteTitle,'" /></a>';
|
|
|
2328 |
}
|
|
|
2329 |
}
|
|
|
2330 |
if ($this->nav_text_links()) {
|
|
|
2331 |
if ($this->nav_graphic_links()) {
|
|
|
2332 |
echo '<br class="',$css_class_name,'">';
|
|
|
2333 |
}
|
|
|
2334 |
$printed_out = false;
|
|
|
2335 |
if ($this->view_enabled()) {
|
|
|
2336 |
$printed_out = true;
|
|
|
2337 |
echo '<a href="',$viewQuery,'" title="',$viewTitle,'" class="',$css_class_name,'">V</a>';
|
|
|
2338 |
}
|
|
|
2339 |
if ($this->change_enabled()) {
|
|
|
2340 |
$printed_out && print(' ');
|
|
|
2341 |
$printed_out = true;
|
|
|
2342 |
echo '<a href="',$changeQuery,'" title="',$changeTitle,'" class="',$css_class_name,'">C</a>';
|
|
|
2343 |
}
|
|
|
2344 |
if ($this->copy_enabled()) {
|
|
|
2345 |
$printed_out && print(' ');
|
|
|
2346 |
$printed_out = true;
|
|
|
2347 |
echo '<a href="',$copyQuery,'" title="',$copyTitle,'" class="',$css_class_name,'">P</a>';
|
|
|
2348 |
}
|
|
|
2349 |
if ($this->delete_enabled()) {
|
|
|
2350 |
$printed_out && print(' ');
|
|
|
2351 |
$printed_out = true;
|
|
|
2352 |
echo '<a href="',$deleteQuery,'" title="',$deleteTitle,'" class="',$css_class_name,'">D</a>';
|
|
|
2353 |
}
|
|
|
2354 |
}
|
|
|
2355 |
if (! $this->nav_buttons() || $sys_cols > 1) {
|
|
|
2356 |
echo '</td>',"\n";
|
|
|
2357 |
}
|
|
|
2358 |
if ($this->nav_buttons()) {
|
|
|
2359 |
echo '<td class="',$css_class_name,'"><input class="',$css_class_name;
|
|
|
2360 |
echo '" type="radio" name="'.$this->cgi['prefix']['sys'].'rec';
|
|
|
2361 |
echo '" value="',htmlspecialchars($key_rec),'"';
|
|
|
2362 |
if (($this->rec == '' && $first) || ($this->rec == $key_rec)) {
|
|
|
2363 |
echo ' checked';
|
|
|
2364 |
$first = false;
|
|
|
2365 |
}
|
|
|
2366 |
echo ' /></td>',"\n";
|
|
|
2367 |
}
|
|
|
2368 |
} elseif ($this->filter_enabled()) {
|
|
|
2369 |
echo '<td class="',$css_class_name,'" colspan=',$sys_cols,'> </td>',"\n";
|
|
|
2370 |
}
|
|
|
2371 |
} /* }}} */
|
|
|
2372 |
for ($k = 0; $k < $this->num_fds; $k++) { /* {{{ */
|
|
|
2373 |
$fd = $this->fds[$k];
|
|
|
2374 |
if (! $this->displayed[$k]) {
|
|
|
2375 |
continue;
|
|
|
2376 |
}
|
|
|
2377 |
$css_postfix = @$this->fdd[$k]['css']['postfix'];
|
|
|
2378 |
$css_class_name = $this->getCSSclass('cell', null, true, $css_postfix);
|
|
|
2379 |
if ($this->password($k)) {
|
|
|
2380 |
echo '<td class="',$css_class_name,'">',$this->labels['hidden'],'</td>',"\n";
|
|
|
2381 |
continue;
|
|
|
2382 |
}
|
|
|
2383 |
echo '<td class="',$css_class_name,'"',$this->getColAttributes($fd),'>';
|
|
|
2384 |
echo $this->cellDisplay($k, $row, $css_class_name);
|
|
|
2385 |
echo '</td>',"\n";
|
|
|
2386 |
} /* }}} */
|
|
|
2387 |
echo '</tr>',"\n";
|
|
|
2388 |
}
|
|
|
2389 |
|
|
|
2390 |
/*
|
|
|
2391 |
* Display and accumulate column aggregation info, do totalling query
|
|
|
2392 |
* XXX this feature does not work yet!!!
|
|
|
2393 |
*/
|
|
|
2394 |
// aggregates listing (if any)
|
|
|
2395 |
if ($$var_to_total) {
|
|
|
2396 |
// do the aggregate query if necessary
|
|
|
2397 |
//if ($vars_to_total) {
|
|
|
2398 |
$qp = array();
|
|
|
2399 |
$qp['type'] = 'select';
|
|
|
2400 |
$qp['select'] = $aggr_from_clause;
|
|
|
2401 |
$qp['from'] = $this->get_SQL_join_clause();
|
|
|
2402 |
$qp['where'] = $this->get_SQL_where_from_query_opts();
|
|
|
2403 |
$tot_query = $this->get_SQL_query($qp);
|
|
|
2404 |
$totals_result = $this->myquery($tot_query,__LINE__);
|
|
|
2405 |
$tot_row = @mysql_fetch_array($totals_result, MYSQL_ASSOC);
|
|
|
2406 |
//}
|
|
|
2407 |
$qp_aggr = $qp;
|
|
|
2408 |
echo "\n",'<tr class="TODO-class">',"\n",'<td class="TODO-class"> </td>',"\n";
|
|
|
2409 |
/*
|
|
|
2410 |
echo '<td>';
|
|
|
2411 |
echo printarray($qp_aggr);
|
|
|
2412 |
echo printarray($vars_to_total);
|
|
|
2413 |
echo '</td>';
|
|
|
2414 |
echo '<td colspan="'.($this->num_fds-1).'">'.$var_to_total.' '.$$var_to_total.'</td>';
|
|
|
2415 |
*/
|
|
|
2416 |
// display the results
|
|
|
2417 |
for ($k=0;$k<$this->num_fds;$k++) {
|
|
|
2418 |
$fd = $this->fds[$k];
|
|
|
2419 |
if (stristr($this->fdd[$fd]['options'],'L') or !isset($this->fdd[$fd]['options'])) {
|
|
|
2420 |
echo '<td>';
|
|
|
2421 |
$aggr_var = 'qf'.$k.'_aggr';
|
|
|
2422 |
$$aggr_var = $this->get_sys_cgi_var($aggr_var);
|
|
|
2423 |
if ($$aggr_var) {
|
|
|
2424 |
echo $this->sql_aggrs[$$aggr_var],': ',$tot_row[$aggr_var];
|
|
|
2425 |
} else {
|
|
|
2426 |
echo ' ';
|
|
|
2427 |
}
|
|
|
2428 |
echo '</td>',"\n";
|
|
|
2429 |
}
|
|
|
2430 |
}
|
|
|
2431 |
echo '</tr>',"\n";
|
|
|
2432 |
}
|
|
|
2433 |
echo '</table>',"\n"; // end of table rows listing
|
|
|
2434 |
$this->display_list_table_buttons('down', $listall);
|
|
|
2435 |
$this->form_end();
|
|
|
2436 |
} /* }}} */
|
|
|
2437 |
|
|
|
2438 |
function display_record() /* {{{ */
|
|
|
2439 |
{
|
|
|
2440 |
// PRE Triggers
|
|
|
2441 |
$ret = true;
|
|
|
2442 |
if ($this->change_operation()) {
|
|
|
2443 |
$ret &= $this->exec_triggers_simple('update', 'pre');
|
|
|
2444 |
// if PRE update fails, then back to view operation
|
|
|
2445 |
if (! $ret) {
|
|
|
2446 |
$this->operation = $this->labels['View'];
|
|
|
2447 |
$ret = true;
|
|
|
2448 |
}
|
|
|
2449 |
}
|
|
|
2450 |
if ($this->add_operation() || $this->copy_operation()) {
|
|
|
2451 |
$ret &= $this->exec_triggers_simple('insert', 'pre');
|
|
|
2452 |
}
|
|
|
2453 |
if ($this->view_operation()) {
|
|
|
2454 |
$ret &= $this->exec_triggers_simple('select', 'pre');
|
|
|
2455 |
}
|
|
|
2456 |
if ($this->delete_operation()) {
|
|
|
2457 |
$ret &= $this->exec_triggers_simple('delete', 'pre');
|
|
|
2458 |
}
|
|
|
2459 |
// if PRE insert/view/delete fail, then back to the list
|
|
|
2460 |
if ($ret == false) {
|
|
|
2461 |
$this->operation = '';
|
|
|
2462 |
$this->list_table();
|
|
|
2463 |
return;
|
|
|
2464 |
}
|
|
|
2465 |
$this->form_begin();
|
|
|
2466 |
if ($this->cgi['persist'] != '') {
|
|
|
2467 |
echo $this->get_origvars_html($this->cgi['persist']);
|
|
|
2468 |
}
|
|
|
2469 |
echo $this->get_origvars_html($this->get_sfn_cgi_vars());
|
|
|
2470 |
echo $this->get_origvars_html($this->qfn);
|
|
|
2471 |
echo $this->htmlHiddenSys('cur_tab', $this->dhtml['prefix'].'tab'.$this->cur_tab);
|
|
|
2472 |
echo $this->htmlHiddenSys('qfn', $this->qfn);
|
|
|
2473 |
echo $this->htmlHiddenSys('rec', $this->copy_operation() ? '' : $this->rec);
|
|
|
2474 |
echo $this->htmlHiddenSys('fm', $this->fm);
|
|
|
2475 |
echo $this->htmlHiddenSys('fl', $this->fl);
|
|
|
2476 |
$this->display_record_buttons('up');
|
|
|
2477 |
if ($this->tabs_enabled()) {
|
|
|
2478 |
echo '<div id="'.$this->dhtml['prefix'].'tab0">',"\n";
|
|
|
2479 |
}
|
|
|
2480 |
echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n";
|
|
|
2481 |
if ($this->add_operation()) {
|
|
|
2482 |
$this->display_add_record();
|
|
|
2483 |
} else {
|
|
|
2484 |
$this->display_copy_change_delete_record();
|
|
|
2485 |
}
|
|
|
2486 |
echo '</table>',"\n";
|
|
|
2487 |
if ($this->tabs_enabled()) {
|
|
|
2488 |
echo '</div>',"\n";
|
|
|
2489 |
}
|
|
|
2490 |
$this->display_record_buttons('down');
|
|
|
2491 |
|
|
|
2492 |
$this->form_end();
|
|
|
2493 |
} /* }}} */
|
|
|
2494 |
|
|
|
2495 |
/*
|
|
|
2496 |
* Action functions
|
|
|
2497 |
*/
|
|
|
2498 |
|
|
|
2499 |
function do_add_record() /* {{{ */
|
|
|
2500 |
{
|
|
|
2501 |
// Preparing query
|
|
|
2502 |
$query = '';
|
|
|
2503 |
$key_col_val = '';
|
|
|
2504 |
$newvals = array();
|
|
|
2505 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
2506 |
if ($this->processed($k)) {
|
|
|
2507 |
$fd = $this->fds[$k];
|
|
|
2508 |
if ($this->readonly($k)) {
|
|
|
2509 |
$fn = (string) @$this->fdd[$k]['default'];
|
|
|
2510 |
} else {
|
|
|
2511 |
$fn = $this->get_data_cgi_var($fd);
|
|
|
2512 |
}
|
|
|
2513 |
if ($fd == $this->key) {
|
|
|
2514 |
$key_col_val = $fn;
|
|
|
2515 |
}
|
|
|
2516 |
$newvals[$fd] = is_array($fn) ? join(',',$fn) : $fn;
|
|
|
2517 |
}
|
|
|
2518 |
}
|
|
|
2519 |
// Creating array of changed keys ($changed)
|
|
|
2520 |
$changed = array_keys($newvals);
|
|
|
2521 |
// Before trigger, newvals can be efectively changed
|
|
|
2522 |
if ($this->exec_triggers('insert', 'before', $oldvals, $changed, $newvals) == false) {
|
|
|
2523 |
return false;
|
|
|
2524 |
}
|
|
|
2525 |
// Real query (no additional query in this method)
|
|
|
2526 |
foreach ($newvals as $fd => $val) {
|
|
|
2527 |
if ($fd == '') continue;
|
|
|
2528 |
if ($this->col_has_sqlw($this->fdn[$fd])) {
|
|
|
2529 |
$val_as = addslashes($val);
|
|
|
2530 |
$val_qas = '"'.addslashes($val).'"';
|
|
|
2531 |
$value = $this->substituteVars(
|
|
|
2532 |
$this->fdd[$this->fdn[$fd]]['sqlw'], array(
|
|
|
2533 |
'val_qas' => $val_qas,
|
|
|
2534 |
'val_as' => $val_as,
|
|
|
2535 |
'val' => $val
|
|
|
2536 |
));
|
|
|
2537 |
} else {
|
|
|
2538 |
$value = "'".addslashes($val)."'";
|
|
|
2539 |
}
|
|
|
2540 |
if ($query == '') {
|
|
|
2541 |
$query = 'INSERT INTO `'.$this->tb.'` (`'.$fd.'`'; // )
|
|
|
2542 |
$query2 = ') VALUES ('.$value.'';
|
|
|
2543 |
} else {
|
|
|
2544 |
$query .= ', `'.$fd.'`';
|
|
|
2545 |
$query2 .= ', '.$value.'';
|
|
|
2546 |
}
|
|
|
2547 |
}
|
|
|
2548 |
$query .= $query2.')';
|
|
|
2549 |
$res = $this->myquery($query, __LINE__);
|
|
|
2550 |
$this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record added'];
|
|
|
2551 |
if (! $res) {
|
|
|
2552 |
return false;
|
|
|
2553 |
}
|
|
|
2554 |
$this->rec = mysql_insert_id($this->dbh);
|
|
|
2555 |
// Notify list
|
|
|
2556 |
if (@$this->notify['insert'] || @$this->notify['all']) {
|
|
|
2557 |
$this->email_notify(false, $newvals);
|
|
|
2558 |
}
|
|
|
2559 |
// Note change in log table
|
|
|
2560 |
if ($this->logtable) {
|
|
|
2561 |
$query = sprintf('INSERT INTO %s'
|
|
|
2562 |
.' (updated, user, host, operation, tab, rowkey, col, oldval, newval)'
|
|
|
2563 |
.' VALUES (NOW(), "%s", "%s", "insert", "%s", "%s", "", "", "%s")',
|
|
|
2564 |
$this->logtable, addslashes($this->get_server_var('REMOTE_USER')),
|
|
|
2565 |
addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb),
|
|
|
2566 |
addslashes($key_col_val), addslashes(serialize($newvals)));
|
|
|
2567 |
$this->myquery($query, __LINE__);
|
|
|
2568 |
}
|
|
|
2569 |
// After trigger
|
|
|
2570 |
if ($this->exec_triggers('insert', 'after', $oldvals, $changed, $newvals) == false) {
|
|
|
2571 |
return false;
|
|
|
2572 |
}
|
|
|
2573 |
return true;
|
|
|
2574 |
} /* }}} */
|
|
|
2575 |
|
|
|
2576 |
function do_change_record() /* {{{ */
|
|
|
2577 |
{
|
|
|
2578 |
// Preparing queries
|
|
|
2579 |
$query_real = '';
|
|
|
2580 |
$query_oldrec = '';
|
|
|
2581 |
$newvals = array();
|
|
|
2582 |
$oldvals = array();
|
|
|
2583 |
$changed = array();
|
|
|
2584 |
// Prepare query to retrieve oldvals
|
|
|
2585 |
for ($k = 0; $k < $this->num_fds; $k++) {
|
|
|
2586 |
if ($this->processed($k) && !$this->readonly($k)) {
|
|
|
2587 |
$fd = $this->fds[$k];
|
|
|
2588 |
$fn = $this->get_data_cgi_var($fd);
|
|
|
2589 |
$newvals[$this->fds[$k]] = is_array($fn) ? join(',',$fn) : $fn;
|
|
|
2590 |
if ($query_oldrec == '') {
|
|
|
2591 |
$query_oldrec = 'SELECT '.$fd;
|
|
|
2592 |
} else {
|
|
|
2593 |
$query_oldrec .= ','.$fd;
|
|
|
2594 |
}
|
|
|
2595 |
}
|
|
|
2596 |
}
|
|
|
2597 |
$where_part = " WHERE (".$this->key.'='.$this->key_delim.$this->rec.$this->key_delim.')';
|
|
|
2598 |
$query_newrec = $query_oldrec.' FROM ' . $this->tb;
|
|
|
2599 |
$query_oldrec .= ' FROM ' . $this->tb . $where_part;
|
|
|
2600 |
// Additional query (must go before real query)
|
|
|
2601 |
$res = $this->myquery($query_oldrec, __LINE__);
|
|
|
2602 |
$oldvals = @mysql_fetch_array($res, MYSQL_ASSOC);
|
|
|
2603 |
@mysql_free_result($res);
|
|
|
2604 |
// Creating array of changed keys ($changed)
|
|
|
2605 |
foreach ($newvals as $fd => $value) {
|
|
|
2606 |
if ($value != $oldvals[$fd])
|
|
|
2607 |
$changed[] = $fd;
|
|
|
2608 |
}
|
|
|
2609 |
// Before trigger
|
|
|
2610 |
if ($this->exec_triggers('update', 'before', $oldvals, $changed, $newvals) == false) {
|
|
|
2611 |
return false;
|
|
|
2612 |
}
|
|
|
2613 |
// Build the real query respecting changes to the newvals array
|
|
|
2614 |
foreach ($newvals as $fd => $val) {
|
|
|
2615 |
if ($fd == '') continue;
|
|
|
2616 |
if ($this->col_has_sqlw($this->fdn[$fd])) {
|
|
|
2617 |
$val_as = addslashes($val);
|
|
|
2618 |
$val_qas = '"'.addslashes($val).'"';
|
|
|
2619 |
$value = $this->substituteVars(
|
|
|
2620 |
$this->fdd[$this->fdn[$fd]]['sqlw'], array(
|
|
|
2621 |
'val_qas' => $val_qas,
|
|
|
2622 |
'val_as' => $val_as,
|
|
|
2623 |
'val' => $val
|
|
|
2624 |
));
|
|
|
2625 |
} else {
|
|
|
2626 |
$value = "'".addslashes($val)."'";
|
|
|
2627 |
}
|
|
|
2628 |
if ($query_real == '') {
|
|
|
2629 |
$query_real = 'UPDATE '.$this->tb.' SET '.$fd.'='.$value;
|
|
|
2630 |
} else {
|
|
|
2631 |
$query_real .= ','.$fd.'='.$value;
|
|
|
2632 |
}
|
|
|
2633 |
}
|
|
|
2634 |
$query_real .= $where_part;
|
|
|
2635 |
// Real query
|
|
|
2636 |
$res = $this->myquery($query_real, __LINE__);
|
|
|
2637 |
$this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record changed'];
|
|
|
2638 |
if (! $res) {
|
|
|
2639 |
return false;
|
|
|
2640 |
}
|
|
|
2641 |
// Another additional query (must go after real query)
|
|
|
2642 |
if (in_array($this->key, $changed)) {
|
|
|
2643 |
$this->rec = $newvals[$this->key]; // key has changed
|
|
|
2644 |
}
|
|
|
2645 |
$query_newrec .= ' WHERE ('.$this->key.'='.$this->key_delim.$this->rec.$this->key_delim.')';
|
|
|
2646 |
$res = $this->myquery($query_newrec, __LINE__);
|
|
|
2647 |
$newvals = @mysql_fetch_array($res, MYSQL_ASSOC);
|
|
|
2648 |
@mysql_free_result($res);
|
|
|
2649 |
// Creating array of changed keys ($changed)
|
|
|
2650 |
$changed = array();
|
|
|
2651 |
foreach ($newvals as $fd => $value) {
|
|
|
2652 |
if ($value != $oldvals[$fd])
|
|
|
2653 |
$changed[] = $fd;
|
|
|
2654 |
}
|
|
|
2655 |
// Notify list
|
|
|
2656 |
if (@$this->notify['update'] || @$this->notify['all']) {
|
|
|
2657 |
if (count($changed) > 0) {
|
|
|
2658 |
$this->email_notify($oldvals, $newvals);
|
|
|
2659 |
}
|
|
|
2660 |
}
|
|
|
2661 |
// Note change in log table
|
|
|
2662 |
if ($this->logtable) {
|
|
|
2663 |
foreach ($changed as $key) {
|
|
|
2664 |
$qry = sprintf('INSERT INTO %s'
|
|
|
2665 |
.' (updated, user, host, operation, tab, rowkey, col, oldval, newval)'
|
|
|
2666 |
.' VALUES (NOW(), "%s", "%s", "update", "%s", "%s", "%s", "%s", "%s")',
|
|
|
2667 |
$this->logtable, addslashes($this->get_server_var('REMOTE_USER')),
|
|
|
2668 |
addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb),
|
|
|
2669 |
addslashes($this->rec), addslashes($key),
|
|
|
2670 |
addslashes($oldvals[$key]), addslashes($newvals[$key]));
|
|
|
2671 |
$this->myquery($qry, __LINE__);
|
|
|
2672 |
}
|
|
|
2673 |
}
|
|
|
2674 |
// After trigger
|
|
|
2675 |
if ($this->exec_triggers('update', 'after', $oldvals, $changed, $newvals) == false) {
|
|
|
2676 |
return false;
|
|
|
2677 |
}
|
|
|
2678 |
return true;
|
|
|
2679 |
} /* }}} */
|
|
|
2680 |
|
|
|
2681 |
function do_delete_record() /* {{{ */
|
|
|
2682 |
{
|
|
|
2683 |
// Additional query
|
|
|
2684 |
$query = 'SELECT * FROM '.$this->tb.' WHERE ('.$this->key.' = '
|
|
|
2685 |
.$this->key_delim.$this->rec.$this->key_delim.')'; // )
|
|
|
2686 |
$res = $this->myquery($query, __LINE__);
|
|
|
2687 |
$oldvals = @mysql_fetch_array($res, MYSQL_ASSOC);
|
|
|
2688 |
@mysql_free_result($res);
|
|
|
2689 |
// Creating array of changed keys ($changed)
|
|
|
2690 |
$changed = array_keys($oldvals);
|
|
|
2691 |
$newvals = array();
|
|
|
2692 |
// Before trigger
|
|
|
2693 |
if ($this->exec_triggers('delete', 'before', $oldvals, $changed, $newvals) == false) {
|
|
|
2694 |
return false;
|
|
|
2695 |
}
|
|
|
2696 |
// Real query
|
|
|
2697 |
$query = 'DELETE FROM '.$this->tb.' WHERE ('.$this->key.' = '
|
|
|
2698 |
.$this->key_delim.$this->rec.$this->key_delim.')'; // )
|
|
|
2699 |
$res = $this->myquery($query, __LINE__);
|
|
|
2700 |
$this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record deleted'];
|
|
|
2701 |
if (! $res) {
|
|
|
2702 |
return false;
|
|
|
2703 |
}
|
|
|
2704 |
// Notify list
|
|
|
2705 |
if (@$this->notify['delete'] || @$this->notify['all']) {
|
|
|
2706 |
$this->email_notify($oldvals, false);
|
|
|
2707 |
}
|
|
|
2708 |
// Note change in log table
|
|
|
2709 |
if ($this->logtable) {
|
|
|
2710 |
$query = sprintf('INSERT INTO %s'
|
|
|
2711 |
.' (updated, user, host, operation, tab, rowkey, col, oldval, newval)'
|
|
|
2712 |
.' VALUES (NOW(), "%s", "%s", "delete", "%s", "%s", "%s", "%s", "")',
|
|
|
2713 |
$this->logtable, addslashes($this->get_server_var('REMOTE_USER')),
|
|
|
2714 |
addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb),
|
|
|
2715 |
addslashes($this->rec), addslashes($key), addslashes(serialize($oldvals)));
|
|
|
2716 |
$this->myquery($query, __LINE__);
|
|
|
2717 |
}
|
|
|
2718 |
// After trigger
|
|
|
2719 |
if ($this->exec_triggers('delete', 'after', $oldvals, $changed, $newvals) == false) {
|
|
|
2720 |
return false;
|
|
|
2721 |
}
|
|
|
2722 |
return true;
|
|
|
2723 |
} /* }}} */
|
|
|
2724 |
|
|
|
2725 |
function email_notify($old_vals, $new_vals) /* {{{ */
|
|
|
2726 |
{
|
|
|
2727 |
if (! function_exists('mail')) {
|
|
|
2728 |
return false;
|
|
|
2729 |
}
|
|
|
2730 |
if ($old_vals != false && $new_vals != false) {
|
|
|
2731 |
$action = 'update';
|
|
|
2732 |
$subject = 'Record updated in';
|
|
|
2733 |
$body = 'An item with '.$this->fdd[$this->key]['name'].' = '
|
|
|
2734 |
.$this->key_delim.$this->rec.$this->key_delim .' was updated in';
|
|
|
2735 |
$vals = $new_vals;
|
|
|
2736 |
} elseif ($new_vals != false) {
|
|
|
2737 |
$action = 'insert';
|
|
|
2738 |
$subject = 'Record added to';
|
|
|
2739 |
$body = 'A new item was added into';
|
|
|
2740 |
$vals = $new_vals;
|
|
|
2741 |
} elseif ($old_vals != false) {
|
|
|
2742 |
$action = 'delete';
|
|
|
2743 |
$subject = 'Record deleted from';
|
|
|
2744 |
$body = 'An item was deleted from';
|
|
|
2745 |
$vals = $old_vals;
|
|
|
2746 |
} else {
|
|
|
2747 |
return false;
|
|
|
2748 |
}
|
|
|
2749 |
$addr = $this->get_server_var('REMOTE_ADDR');
|
|
|
2750 |
$user = $this->get_server_var('REMOTE_USER');
|
|
|
2751 |
$body = 'This notification e-mail was automatically generated by phpMyEdit.'."\n\n".$body;
|
|
|
2752 |
$body .= ' table '.$this->tb.' in MySQL database '.$this->db.' on '.$this->page_name;
|
|
|
2753 |
$body .= ' by '.($user == '' ? 'unknown user' : "user $user").' from '.$addr;
|
|
|
2754 |
$body .= ' at '.date('d/M/Y H:i').' with the following fields:'."\n\n";
|
|
|
2755 |
$i = 1;
|
|
|
2756 |
foreach ($vals as $k => $text) {
|
|
|
2757 |
$name = isset($this->fdd[$k]['name~'])
|
|
|
2758 |
? $this->fdd[$k]['name~'] : $this->fdd[$k]['name'];
|
|
|
2759 |
if ($action == 'update') {
|
|
|
2760 |
if ($old_vals[$k] == $new_vals[$k]) {
|
|
|
2761 |
continue;
|
|
|
2762 |
}
|
|
|
2763 |
$body .= sprintf("[%02s] %s (%s)\n WAS: %s\n IS: %s\n",
|
|
|
2764 |
$i, $name, $k, $old_vals[$k], $new_vals[$k]);
|
|
|
2765 |
} else {
|
|
|
2766 |
$body .= sprintf('[%02s] %s (%s): %s'."\n", $i, $name, $k, $text);
|
|
|
2767 |
}
|
|
|
2768 |
$i++;
|
|
|
2769 |
}
|
|
|
2770 |
$body .= "\n--\r\n"; // \r is needed for signature separating
|
|
|
2771 |
$body .= "phpMyEdit\ninstant MySQL table editor and code generator\n";
|
|
|
2772 |
$body .= "http://platon.sk/projects/phpMyEdit/\n\n";
|
|
|
2773 |
$subject = @$this->notify['prefix'].$subject.' '.$this->dbp.$this->tb;
|
|
|
2774 |
$subject = trim($subject); // just for sure
|
|
|
2775 |
$wrap_w = intval(@$this->notify['wrap']);
|
|
|
2776 |
$wrap_w > 0 || $wrap_w = 72;
|
|
|
2777 |
$from = (string) @$this->notify['from'];
|
|
|
2778 |
$from != '' || $from = 'webmaster@'.strtolower($this->get_server_var('SERVER_NAME'));
|
|
|
2779 |
$headers = 'From: '.$from."\n".'X-Mailer: PHP/'.phpversion().' (phpMyEdit)';
|
|
|
2780 |
$body = wordwrap($body, $wrap_w, "\n", 1);
|
|
|
2781 |
$emails = (array) $this->notify[$action] + (array) $this->notify['all'];
|
|
|
2782 |
foreach ($emails as $email) {
|
|
|
2783 |
if (! empty($email)) {
|
|
|
2784 |
mail(trim($email), $subject, $body, $headers);
|
|
|
2785 |
}
|
|
|
2786 |
}
|
|
|
2787 |
return true;
|
|
|
2788 |
} /* }}} */
|
|
|
2789 |
|
|
|
2790 |
/*
|
|
|
2791 |
* Apply triggers function
|
|
|
2792 |
* Run a (set of) trigger(s). $trigger can be an Array or a filename
|
|
|
2793 |
* Break and return false as soon as a trigger return false
|
|
|
2794 |
* we need a reference on $newvals to be able to change value before insert/update
|
|
|
2795 |
*/
|
|
|
2796 |
function exec_triggers($op, $step, $oldvals, &$changed, &$newvals) /* {{{ */
|
|
|
2797 |
{
|
|
|
2798 |
if (! isset($this->triggers[$op][$step])) {
|
|
|
2799 |
return true;
|
|
|
2800 |
}
|
|
|
2801 |
$ret = true;
|
|
|
2802 |
$trig = $this->triggers[$op][$step];
|
|
|
2803 |
if (is_array($trig)) {
|
|
|
2804 |
ksort($trig);
|
|
|
2805 |
for ($t = reset($trig); $t !== false && $ret != false; $t = next($trig)) {
|
|
|
2806 |
$ret = include($t);
|
|
|
2807 |
}
|
|
|
2808 |
} else {
|
|
|
2809 |
$ret = include($trig);
|
|
|
2810 |
}
|
|
|
2811 |
return $ret;
|
|
|
2812 |
} /* }}} */
|
|
|
2813 |
|
|
|
2814 |
function exec_triggers_simple($op, $step) /* {{{ */
|
|
|
2815 |
{
|
|
|
2816 |
$oldvals = $newvals = $changed = array();
|
|
|
2817 |
return $this->exec_triggers($op, $step, $oldvals, $changed, $newvals);
|
|
|
2818 |
} /* }}} */
|
|
|
2819 |
|
|
|
2820 |
/*
|
|
|
2821 |
* Recreate functions
|
|
|
2822 |
*/
|
|
|
2823 |
function recreate_fdd($default_page_type = 'L') /* {{{ */
|
|
|
2824 |
{
|
|
|
2825 |
// TODO: one level deeper browsing
|
|
|
2826 |
$this->page_type = $default_page_type;
|
|
|
2827 |
$this->filter_operation() && $this->page_type = 'F';
|
|
|
2828 |
$this->view_operation() && $this->page_type = 'V';
|
|
|
2829 |
if ($this->add_operation()
|
|
|
2830 |
|| $this->saveadd == $this->labels['Save']
|
|
|
2831 |
|| $this->moreadd == $this->labels['More']) {
|
|
|
2832 |
$this->page_type = 'A';
|
|
|
2833 |
}
|
|
|
2834 |
if ($this->change_operation()
|
|
|
2835 |
|| $this->savechange == $this->labels['Save']
|
|
|
2836 |
|| $this->morechange == $this->labels['Apply']) {
|
|
|
2837 |
$this->page_type = 'C';
|
|
|
2838 |
}
|
|
|
2839 |
if ($this->copy_operation() || $this->savecopy == $this->labels['Save']) {
|
|
|
2840 |
$this->page_type = 'P';
|
|
|
2841 |
}
|
|
|
2842 |
if ($this->delete_operation() || $this->savedelete == $this->labels['Delete']) {
|
|
|
2843 |
$this->page_type = 'D';
|
|
|
2844 |
}
|
|
|
2845 |
// Restore backups (if exists)
|
|
|
2846 |
foreach (array_keys($this->fdd) as $column) {
|
|
|
2847 |
foreach (array_keys($this->fdd[$column]) as $col_option) {
|
|
|
2848 |
if ($col_option[strlen($col_option) - 1] != '~')
|
|
|
2849 |
continue;
|
|
|
2850 |
|
|
|
2851 |
$this->fdd[$column][substr($col_option, 0, strlen($col_option) - 1)]
|
|
|
2852 |
= $this->fdd[$column][$col_option];
|
|
|
2853 |
unset($this->fdd[$column][$col_option]);
|
|
|
2854 |
}
|
|
|
2855 |
}
|
|
|
2856 |
foreach (array_keys($this->fdd) as $column) {
|
|
|
2857 |
foreach (array_keys($this->fdd[$column]) as $col_option) {
|
|
|
2858 |
if (! strchr($col_option, '|')) {
|
|
|
2859 |
continue;
|
|
|
2860 |
}
|
|
|
2861 |
$col_ar = explode('|', $col_option, 2);
|
|
|
2862 |
if (! stristr($col_ar[1], $this->page_type)) {
|
|
|
2863 |
continue;
|
|
|
2864 |
}
|
|
|
2865 |
// Make field backups
|
|
|
2866 |
$this->fdd[$column][$col_ar[0] .'~'] = $this->fdd[$column][$col_ar[0]];
|
|
|
2867 |
$this->fdd[$column][$col_option.'~'] = $this->fdd[$column][$col_option];
|
|
|
2868 |
// Set particular field
|
|
|
2869 |
$this->fdd[$column][$col_ar[0]] = $this->fdd[$column][$col_option];
|
|
|
2870 |
unset($this->fdd[$column][$col_option]);
|
|
|
2871 |
}
|
|
|
2872 |
}
|
|
|
2873 |
} /* }}} */
|
|
|
2874 |
|
|
|
2875 |
function recreate_displayed() /* {{{ */
|
|
|
2876 |
{
|
|
|
2877 |
$field_num = 0;
|
|
|
2878 |
$num_fields_displayed = 0;
|
|
|
2879 |
$this->fds = array();
|
|
|
2880 |
$this->fdn = array();
|
|
|
2881 |
$this->displayed = array();
|
|
|
2882 |
$this->guidance = false;
|
|
|
2883 |
foreach (array_keys($this->fdd) as $key) {
|
|
|
2884 |
if (preg_match('/^\d+$/', $key)) { // skipping numeric keys
|
|
|
2885 |
continue;
|
|
|
2886 |
}
|
|
|
2887 |
$this->fds[$field_num] = $key;
|
|
|
2888 |
$this->fdn[$key] = $field_num;
|
|
|
2889 |
/* We must use here displayed() function, because displayed[] array
|
|
|
2890 |
is not created yet. We will simultaneously create that array as well. */
|
|
|
2891 |
if ($this->displayed[$field_num] = $this->displayed($field_num)) {
|
|
|
2892 |
$num_fields_displayed++;
|
|
|
2893 |
}
|
|
|
2894 |
if (is_array(@$this->fdd[$key]['values']) && ! isset($this->fdd[$key]['values']['table'])) {
|
|
|
2895 |
foreach ($this->fdd[$key]['values'] as $val) {
|
|
|
2896 |
$this->fdd[$key]['values2'][$val] = $val;
|
|
|
2897 |
}
|
|
|
2898 |
unset($this->fdd[$key]['values']);
|
|
|
2899 |
}
|
|
|
2900 |
isset($this->fdd[$key]['help']) && $this->guidance = true;
|
|
|
2901 |
$this->fdd[$field_num] = $this->fdd[$key];
|
|
|
2902 |
$field_num++;
|
|
|
2903 |
}
|
|
|
2904 |
$this->num_fds = $field_num;
|
|
|
2905 |
$this->num_fields_displayed = $num_fields_displayed;
|
|
|
2906 |
$this->key_num = array_search($this->key, $this->fds);
|
|
|
2907 |
/* Adds first displayed column into sorting fields by replacing last
|
|
|
2908 |
array entry. Also remove duplicite values and change column names to
|
|
|
2909 |
their particular field numbers.
|
|
|
2910 |
|
|
|
2911 |
Note that entries like [0]=>'9' [1]=>'-9' are correct and they will
|
|
|
2912 |
have desirable sorting behaviour. So there is no need to remove them.
|
|
|
2913 |
*/
|
|
|
2914 |
$this->sfn = array_unique($this->sfn);
|
|
|
2915 |
$check_ar = array();
|
|
|
2916 |
foreach ($this->sfn as $key => $val) {
|
|
|
2917 |
if (preg_match('/^[-]?\d+$/', $val)) { // skipping numeric keys
|
|
|
2918 |
$val = abs($val);
|
|
|
2919 |
if (in_array($val, $check_ar) || $this->password($val)) {
|
|
|
2920 |
unset($this->sfn[$key]);
|
|
|
2921 |
} else {
|
|
|
2922 |
$check_ar[] = $val;
|
|
|
2923 |
}
|
|
|
2924 |
continue;
|
|
|
2925 |
}
|
|
|
2926 |
if ($val[0] == '-') {
|
|
|
2927 |
$val = substr($val, 1);
|
|
|
2928 |
$minus = '-';
|
|
|
2929 |
} else {
|
|
|
2930 |
$minus = '';
|
|
|
2931 |
}
|
|
|
2932 |
if (($val = array_search($val, $this->fds)) === false || $this->password($val)) {
|
|
|
2933 |
unset($this->sfn[$key]);
|
|
|
2934 |
} else {
|
|
|
2935 |
$val = intval($val);
|
|
|
2936 |
if (in_array($val, $check_ar)) {
|
|
|
2937 |
unset($this->sfn[$key]);
|
|
|
2938 |
} else {
|
|
|
2939 |
$this->sfn[$key] = $minus.$val;
|
|
|
2940 |
$check_ar[] = $val;
|
|
|
2941 |
}
|
|
|
2942 |
}
|
|
|
2943 |
}
|
|
|
2944 |
$this->sfn = array_unique($this->sfn);
|
|
|
2945 |
return true;
|
|
|
2946 |
} /* }}} */
|
|
|
2947 |
|
|
|
2948 |
function backward_compatibility() /* {{{ */
|
|
|
2949 |
{
|
|
|
2950 |
foreach (array_keys($this->fdd) as $column) {
|
|
|
2951 |
// move ['required'] to ['js']['required']
|
|
|
2952 |
if (! isset($this->fdd[$column]['js']['required']) && isset($this->fdd[$column]['required'])) {
|
|
|
2953 |
$this->fdd[$column]['js']['required'] = $this->fdd[$column]['required'];
|
|
|
2954 |
}
|
|
|
2955 |
// move 'HWR' flags from ['options'] into ['input']
|
|
|
2956 |
if (isset($this->fdd[$column]['options'])) {
|
|
|
2957 |
stristr($this->fdd[$column]['options'], 'H') && $this->fdd[$column]['input'] .= 'H';
|
|
|
2958 |
stristr($this->fdd[$column]['options'], 'W') && $this->fdd[$column]['input'] .= 'W';
|
|
|
2959 |
stristr($this->fdd[$column]['options'], 'R') && $this->fdd[$column]['input'] .= 'R';
|
|
|
2960 |
}
|
|
|
2961 |
}
|
|
|
2962 |
} /* }}} */
|
|
|
2963 |
|
|
|
2964 |
/*
|
|
|
2965 |
* Error handling function
|
|
|
2966 |
*/
|
|
|
2967 |
function error($message, $additional_info = '') /* {{{ */
|
|
|
2968 |
{
|
|
|
2969 |
echo '<h1>phpMyEdit error: ',htmlspecialchars($message),'</h1>',"\n";
|
|
|
2970 |
if ($additional_info != '') {
|
|
|
2971 |
echo '<hr />',htmlspecialchars($additional_info);
|
|
|
2972 |
}
|
|
|
2973 |
return false;
|
|
|
2974 |
} /* }}} */
|
|
|
2975 |
|
|
|
2976 |
/*
|
|
|
2977 |
* Database connection function
|
|
|
2978 |
*/
|
|
|
2979 |
function connect() /* {{{ */
|
|
|
2980 |
{
|
|
|
2981 |
if (isset($this->dbh)) {
|
|
|
2982 |
return true;
|
|
|
2983 |
}
|
|
|
2984 |
if (!isset($this->db)) {
|
|
|
2985 |
$this->error('no database defined');
|
|
|
2986 |
return false;
|
|
|
2987 |
}
|
|
|
2988 |
if (!isset ($this->tb)) {
|
|
|
2989 |
$this->error('no table defined');
|
|
|
2990 |
return false;
|
|
|
2991 |
}
|
|
|
2992 |
$this->dbh = @ini_get('allow_persistent')
|
|
|
2993 |
? @mysql_pconnect($this->hn, $this->un, $this->pw)
|
|
|
2994 |
: @mysql_connect($this->hn, $this->un, $this->pw);
|
|
|
2995 |
if (!$this->dbh) {
|
|
|
2996 |
$this->error('could not connect to MySQL');
|
|
|
2997 |
return false;
|
|
|
2998 |
}
|
|
|
2999 |
return true;
|
|
|
3000 |
} /* }}} */
|
|
|
3001 |
|
|
|
3002 |
/*
|
|
|
3003 |
* Database disconnection function
|
|
|
3004 |
*/
|
|
|
3005 |
function disconnect() /* {{{ */
|
|
|
3006 |
{
|
|
|
3007 |
if ($this->close_dbh) {
|
|
|
3008 |
@mysql_close($this->dbh);
|
|
|
3009 |
$this->dbh = null;
|
|
|
3010 |
}
|
|
|
3011 |
} /* }}} */
|
|
|
3012 |
|
|
|
3013 |
/*
|
|
|
3014 |
* The workhorse
|
|
|
3015 |
*/
|
|
|
3016 |
function execute() /* {{{ */
|
|
|
3017 |
{
|
|
|
3018 |
// DEBUG - uncomment to enable
|
|
|
3019 |
/*
|
|
|
3020 |
//phpinfo();
|
|
|
3021 |
$this->print_get_vars();
|
|
|
3022 |
$this->print_post_vars();
|
|
|
3023 |
$this->print_vars();
|
|
|
3024 |
echo "<pre>query opts:\n";
|
|
|
3025 |
echo print_r($this->query_opts);
|
|
|
3026 |
echo "</pre>\n";
|
|
|
3027 |
echo "<pre>get vars:\n";
|
|
|
3028 |
echo print_r($this->get_opts);
|
|
|
3029 |
echo "</pre>\n";
|
|
|
3030 |
*/
|
|
|
3031 |
|
|
|
3032 |
// Let's do explicit quoting - it's safer
|
|
|
3033 |
set_magic_quotes_runtime(0);
|
|
|
3034 |
// Checking if language file inclusion was successful
|
|
|
3035 |
if (! is_array($this->labels)) {
|
|
|
3036 |
$this->error('could not locate language files', 'searched path: '.$this->dir['lang']);
|
|
|
3037 |
return false;
|
|
|
3038 |
}
|
|
|
3039 |
// Database connection
|
|
|
3040 |
if ($this->connect() == false) {
|
|
|
3041 |
return false;
|
|
|
3042 |
}
|
|
|
3043 |
|
|
|
3044 |
/*
|
|
|
3045 |
* ======================================================================
|
|
|
3046 |
* Pass 3: process any updates generated if the user has selected
|
|
|
3047 |
* a save or cancel button during Pass 2
|
|
|
3048 |
* ======================================================================
|
|
|
3049 |
*/
|
|
|
3050 |
// Cancel button - Cancel Triggers
|
|
|
3051 |
if ($this->add_canceled() || $this->copy_canceled()) {
|
|
|
3052 |
$this->exec_triggers_simple('insert', 'cancel');
|
|
|
3053 |
}
|
|
|
3054 |
if ($this->view_canceled()) {
|
|
|
3055 |
$this->exec_triggers_simple('select', 'cancel');
|
|
|
3056 |
}
|
|
|
3057 |
if ($this->change_canceled()) {
|
|
|
3058 |
$this->exec_triggers_simple('update', 'cancel');
|
|
|
3059 |
}
|
|
|
3060 |
if ($this->delete_canceled()) {
|
|
|
3061 |
$this->exec_triggers_simple('delete', 'cancel');
|
|
|
3062 |
}
|
|
|
3063 |
// Save/More Button - database operations
|
|
|
3064 |
if ($this->saveadd == $this->labels['Save'] || $this->savecopy == $this->labels['Save']) {
|
|
|
3065 |
$this->add_enabled() && $this->do_add_record();
|
|
|
3066 |
unset($this->saveadd);
|
|
|
3067 |
unset($this->savecopy);
|
|
|
3068 |
$this->recreate_fdd();
|
|
|
3069 |
}
|
|
|
3070 |
elseif ($this->moreadd == $this->labels['More']) {
|
|
|
3071 |
$this->add_enabled() && $this->do_add_record();
|
|
|
3072 |
$this->operation = $this->labels['Add']; // to force add operation
|
|
|
3073 |
$this->recreate_fdd();
|
|
|
3074 |
$this->recreate_displayed();
|
|
|
3075 |
$this->backward_compatibility();
|
|
|
3076 |
}
|
|
|
3077 |
elseif ($this->savechange == $this->labels['Save']) {
|
|
|
3078 |
$this->change_enabled() && $this->do_change_record();
|
|
|
3079 |
unset($this->savechange);
|
|
|
3080 |
$this->recreate_fdd();
|
|
|
3081 |
}
|
|
|
3082 |
elseif ($this->morechange == $this->labels['Apply']) {
|
|
|
3083 |
$this->change_enabled() && $this->do_change_record();
|
|
|
3084 |
$this->operation = $this->labels['Change']; // to force change operation
|
|
|
3085 |
$this->recreate_fdd();
|
|
|
3086 |
$this->recreate_displayed();
|
|
|
3087 |
$this->backward_compatibility();
|
|
|
3088 |
}
|
|
|
3089 |
elseif ($this->savedelete == $this->labels['Delete']) {
|
|
|
3090 |
$this->delete_enabled() && $this->do_delete_record();
|
|
|
3091 |
unset($this->savedelete);
|
|
|
3092 |
$this->recreate_fdd();
|
|
|
3093 |
}
|
|
|
3094 |
|
|
|
3095 |
/*
|
|
|
3096 |
* ======================================================================
|
|
|
3097 |
* Pass 2: display an input/edit/confirmation screen if the user has
|
|
|
3098 |
* selected an editing button on Pass 1 through this page
|
|
|
3099 |
* ======================================================================
|
|
|
3100 |
*/
|
|
|
3101 |
if ($this->add_operation()
|
|
|
3102 |
|| $this->change_operation() || $this->delete_operation()
|
|
|
3103 |
|| $this->view_operation() || $this->copy_operation()) {
|
|
|
3104 |
$this->display_record();
|
|
|
3105 |
}
|
|
|
3106 |
|
|
|
3107 |
/*
|
|
|
3108 |
* ======================================================================
|
|
|
3109 |
* Pass 1 and Pass 3: display the MySQL table in a scrolling window on
|
|
|
3110 |
* the screen (skip this step in 'Add More' mode)
|
|
|
3111 |
* ======================================================================
|
|
|
3112 |
*/
|
|
|
3113 |
else {
|
|
|
3114 |
$this->list_table();
|
|
|
3115 |
}
|
|
|
3116 |
|
|
|
3117 |
$this->disconnect();
|
|
|
3118 |
if ($this->display['time'] && $this->timer != null) {
|
|
|
3119 |
echo $this->timer->end(),' miliseconds';
|
|
|
3120 |
}
|
|
|
3121 |
} /* }}} */
|
|
|
3122 |
|
|
|
3123 |
/*
|
|
|
3124 |
* Class constructor
|
|
|
3125 |
*/
|
|
|
3126 |
function phpMyEdit($opts) /* {{{ */
|
|
|
3127 |
{
|
|
|
3128 |
// Set desirable error reporting level
|
|
|
3129 |
$error_reporting = error_reporting(E_ALL & ~E_NOTICE);
|
|
|
3130 |
// Database handle variables
|
|
|
3131 |
if (isset($opts['dbh'])) {
|
|
|
3132 |
$this->close_dbh = false;
|
|
|
3133 |
$this->dbh = $opts['dbh'];
|
|
|
3134 |
$this->dbp = '';
|
|
|
3135 |
} else {
|
|
|
3136 |
$this->close_dbh = true;
|
|
|
3137 |
$this->dbh = null;
|
|
|
3138 |
$this->dbp = $opts['db'].'.';
|
|
|
3139 |
$this->hn = $opts['hn'];
|
|
|
3140 |
$this->un = $opts['un'];
|
|
|
3141 |
$this->pw = $opts['pw'];
|
|
|
3142 |
$this->db = $opts['db'];
|
|
|
3143 |
}
|
|
|
3144 |
$this->tb = $opts['tb'];
|
|
|
3145 |
// Other variables
|
|
|
3146 |
$this->key = $opts['key'];
|
|
|
3147 |
$this->key_type = $opts['key_type'];
|
|
|
3148 |
$this->inc = $opts['inc'];
|
|
|
3149 |
$this->options = $opts['options'];
|
|
|
3150 |
$this->fdd = $opts['fdd'];
|
|
|
3151 |
$this->multiple = intval($opts['multiple']);
|
|
|
3152 |
$this->multiple <= 0 && $this->multiple = 2;
|
|
|
3153 |
$this->filters = @$opts['filters'];
|
|
|
3154 |
$this->triggers = @$opts['triggers'];
|
|
|
3155 |
$this->notify = @$opts['notify'];
|
|
|
3156 |
$this->logtable = @$opts['logtable'];
|
|
|
3157 |
$this->page_name = @$opts['page_name'];
|
|
|
3158 |
if (! isset($this->page_name)) {
|
|
|
3159 |
$this->page_name = basename($this->get_server_var('PHP_SELF'));
|
|
|
3160 |
isset($this->page_name) || $this->page_name = $this->tb;
|
|
|
3161 |
}
|
|
|
3162 |
$this->display['query'] = @$opts['display']['query'];
|
|
|
3163 |
$this->display['sort'] = @$opts['display']['sort'];
|
|
|
3164 |
$this->display['time'] = @$opts['display']['time'];
|
|
|
3165 |
if ($this->display['time']) {
|
|
|
3166 |
$this->timer = new phpMyEdit_timer();
|
|
|
3167 |
}
|
|
|
3168 |
$this->display['tabs'] = isset($opts['display']['tabs'])
|
|
|
3169 |
? $opts['display']['tabs'] : true;
|
|
|
3170 |
$this->display['form'] = isset($opts['display']['form'])
|
|
|
3171 |
? $opts['display']['form'] : true;
|
|
|
3172 |
$this->display['num_records'] = isset($opts['display']['num_records'])
|
|
|
3173 |
? $opts['display']['num_records'] : true;
|
|
|
3174 |
$this->display['num_pages'] = isset($opts['display']['num_pages'])
|
|
|
3175 |
? $opts['display']['num_pages'] : true;
|
|
|
3176 |
// Creating directory variables
|
|
|
3177 |
$this->dir['root'] = dirname(realpath(__FILE__))
|
|
|
3178 |
. (strlen(dirname(realpath(__FILE__))) > 0 ? '/' : '');
|
|
|
3179 |
$this->dir['lang'] = $this->dir['root'].'lang/';
|
|
|
3180 |
// Creating URL variables
|
|
|
3181 |
$this->url['images'] = 'images/';
|
|
|
3182 |
isset($opts['url']['images']) && $this->url['images'] = $opts['url']['images'];
|
|
|
3183 |
// CSS classes policy
|
|
|
3184 |
$this->css = @$opts['css'];
|
|
|
3185 |
!isset($this->css['separator']) && $this->css['separator'] = '-';
|
|
|
3186 |
!isset($this->css['prefix']) && $this->css['prefix'] = 'pme';
|
|
|
3187 |
!isset($this->css['page_type']) && $this->css['page_type'] = false;
|
|
|
3188 |
!isset($this->css['position']) && $this->css['position'] = false;
|
|
|
3189 |
!isset($this->css['divider']) && $this->css['divider'] = 2;
|
|
|
3190 |
$this->css['divider'] = intval(@$this->css['divider']);
|
|
|
3191 |
// JS overall configuration
|
|
|
3192 |
$this->js = @$opts['js'];
|
|
|
3193 |
!isset($this->js['prefix']) && $this->js['prefix'] = 'PME_js_';
|
|
|
3194 |
// DHTML overall configuration
|
|
|
3195 |
$this->dhtml = @$opts['dhtml'];
|
|
|
3196 |
!isset($this->dhtml['prefix']) && $this->dhtml['prefix'] = 'PME_dhtml_';
|
|
|
3197 |
// Navigation
|
|
|
3198 |
$this->navigation = @$opts['navigation'];
|
|
|
3199 |
if (! $this->nav_buttons() && ! $this->nav_text_links() && ! $this->nav_graphic_links()) {
|
|
|
3200 |
$this->navigation .= 'B'; // buttons are default
|
|
|
3201 |
}
|
|
|
3202 |
if (! $this->nav_up() && ! $this->nav_down()) {
|
|
|
3203 |
$this->navigation .= 'D'; // down position is default
|
|
|
3204 |
}
|
|
|
3205 |
$this->buttons = $opts['buttons'];
|
|
|
3206 |
// Language labels (must go after navigation)
|
|
|
3207 |
$this->labels = $this->make_language_labels(isset($opts['language'])
|
|
|
3208 |
? $opts['language'] : $this->get_server_var('HTTP_ACCEPT_LANGUAGE'));
|
|
|
3209 |
// CGI variables
|
|
|
3210 |
$this->cgi = @$opts['cgi'];
|
|
|
3211 |
$this->cgi['persist'] = '';
|
|
|
3212 |
if (@is_array($opts['cgi']['persist'])) {
|
|
|
3213 |
foreach ($opts['cgi']['persist'] as $key => $val) {
|
|
|
3214 |
if (is_array($val)) {
|
|
|
3215 |
foreach($val as $key2 => $val2) {
|
|
|
3216 |
$this->cgi['persist'] .= '&'.rawurlencode($key)
|
|
|
3217 |
.'['.rawurlencode($key2).']='.rawurlencode($val2);
|
|
|
3218 |
}
|
|
|
3219 |
} else {
|
|
|
3220 |
$this->cgi['persist'] .= '&'.rawurlencode($key).'='.rawurlencode($val);
|
|
|
3221 |
}
|
|
|
3222 |
}
|
|
|
3223 |
}
|
|
|
3224 |
foreach (array('operation', 'sys', 'data') as $type) {
|
|
|
3225 |
if (! isset($this->cgi['prefix'][$type])) {
|
|
|
3226 |
$this->cgi['prefix'][$type] = $this->get_default_cgi_prefix($type);
|
|
|
3227 |
}
|
|
|
3228 |
}
|
|
|
3229 |
// Sorting variables
|
|
|
3230 |
$this->sfn = $this->get_sys_cgi_var('sfn');
|
|
|
3231 |
isset($this->sfn) || $this->sfn = array();
|
|
|
3232 |
is_array($this->sfn) || $this->sfn = array($this->sfn);
|
|
|
3233 |
isset($opts['sort_field']) || $opts['sort_field'] = array();
|
|
|
3234 |
is_array($opts['sort_field']) || $opts['sort_field'] = array($opts['sort_field']);
|
|
|
3235 |
$this->sfn = array_merge($this->sfn, $opts['sort_field']);
|
|
|
3236 |
// Form variables all around
|
|
|
3237 |
$this->fl = intval($this->get_sys_cgi_var('fl'));
|
|
|
3238 |
$this->fm = intval($this->get_sys_cgi_var('fm'));
|
|
|
3239 |
// $old_page = ceil($this->fm / abs($this->inc)) + 1;
|
|
|
3240 |
$this->qfn = $this->get_sys_cgi_var('qfn');
|
|
|
3241 |
$this->sw = $this->get_sys_cgi_var('sw');
|
|
|
3242 |
$this->rec = $this->get_sys_cgi_var('rec', '');
|
|
|
3243 |
$this->navop = $this->get_sys_cgi_var('navop');
|
|
|
3244 |
$navfmup = $this->get_sys_cgi_var('navfmup');
|
|
|
3245 |
$navfmdown = $this->get_sys_cgi_var('navfmdown');
|
|
|
3246 |
$navpnup = $this->get_sys_cgi_var('navpnup');
|
|
|
3247 |
$navpndown = $this->get_sys_cgi_var('navpndown');
|
|
|
3248 |
if($navfmdown!=NULL && $navfmdown != $this->fm) $this->navfm = $navfmdown;
|
|
|
3249 |
elseif($navfmup!=NULL && $navfmup != $this->fm) $this->navfm = $navfmup;
|
|
|
3250 |
elseif($navpndown!=NULL && ($navpndown-1)*$this->inc != $this->fm) $this->navfm = ($navpndown-1)*$this->inc;
|
|
|
3251 |
elseif($navpnup!=NULL && ($navpnup-1)*$this->inc != $this->fm) $this->navfm = ($navpnup-1)*$this->inc;
|
|
|
3252 |
else $this->navfm = $this->fm;
|
|
|
3253 |
$this->operation = $this->get_sys_cgi_var('operation');
|
|
|
3254 |
$oper_prefix_len = strlen($this->cgi['prefix']['operation']);
|
|
|
3255 |
if (! strncmp($this->cgi['prefix']['operation'], $this->operation, $oper_prefix_len)) {
|
|
|
3256 |
$this->operation = $this->labels[substr($this->operation, $oper_prefix_len)];
|
|
|
3257 |
}
|
|
|
3258 |
$this->saveadd = $this->get_sys_cgi_var('saveadd');
|
|
|
3259 |
$this->moreadd = $this->get_sys_cgi_var('moreadd');
|
|
|
3260 |
$this->canceladd = $this->get_sys_cgi_var('canceladd');
|
|
|
3261 |
$this->savechange = $this->get_sys_cgi_var('savechange');
|
|
|
3262 |
$this->morechange = $this->get_sys_cgi_var('morechange');
|
|
|
3263 |
$this->cancelchange = $this->get_sys_cgi_var('cancelchange');
|
|
|
3264 |
$this->savecopy = $this->get_sys_cgi_var('savecopy');
|
|
|
3265 |
$this->cancelcopy = $this->get_sys_cgi_var('cancelcopy');
|
|
|
3266 |
$this->savedelete = $this->get_sys_cgi_var('savedelete');
|
|
|
3267 |
$this->canceldelete = $this->get_sys_cgi_var('canceldelete');
|
|
|
3268 |
$this->cancelview = $this->get_sys_cgi_var('cancelview');
|
|
|
3269 |
// Filter setting
|
|
|
3270 |
if (isset($this->sw)) {
|
|
|
3271 |
$this->sw == $this->labels['Search'] && $this->fl = 1;
|
|
|
3272 |
$this->sw == $this->labels['Hide'] && $this->fl = 0;
|
|
|
3273 |
//$this->sw == $this->labels['Clear'] && $this->fl = 0;
|
|
|
3274 |
}
|
|
|
3275 |
// TAB names
|
|
|
3276 |
$this->tabs = array();
|
|
|
3277 |
// Setting key_delim according to key_type
|
|
|
3278 |
if ($this->key_type == 'real') {
|
|
|
3279 |
/* If 'real' key_type does not work,
|
|
|
3280 |
try change MySQL datatype from float to double */
|
|
|
3281 |
$this->rec = doubleval($this->rec);
|
|
|
3282 |
$this->key_delim = '';
|
|
|
3283 |
} elseif ($this->key_type == 'int') {
|
|
|
3284 |
$this->rec = intval($this->rec);
|
|
|
3285 |
$this->key_delim = '';
|
|
|
3286 |
} else {
|
|
|
3287 |
$this->key_delim = '"';
|
|
|
3288 |
// $this->rec remains unmodified
|
|
|
3289 |
}
|
|
|
3290 |
// Specific $fdd modifications depending on performed action
|
|
|
3291 |
$this->recreate_fdd();
|
|
|
3292 |
// Extract SQL Field Names and number of fields
|
|
|
3293 |
$this->recreate_displayed();
|
|
|
3294 |
// Issue backward compatibility
|
|
|
3295 |
$this->backward_compatibility();
|
|
|
3296 |
// Gathering query options
|
|
|
3297 |
$this->gather_query_opts();
|
|
|
3298 |
// Call to action
|
|
|
3299 |
!isset($opts['execute']) && $opts['execute'] = 1;
|
|
|
3300 |
$opts['execute'] && $this->execute();
|
|
|
3301 |
// Restore original error reporting level
|
|
|
3302 |
error_reporting($error_reporting);
|
|
|
3303 |
} /* }}} */
|
|
|
3304 |
|
|
|
3305 |
}
|
|
|
3306 |
|
|
|
3307 |
/* Modeline for ViM {{{
|
|
|
3308 |
* vim:set ts=4:
|
|
|
3309 |
* vim600:fdm=marker fdl=0 fdc=0:
|
|
|
3310 |
* }}} */
|
|
|
3311 |
|
|
|
3312 |
?>
|