| New file |
|---|
| 0,0 → 1,3312 |
|---|
| <?php |
| |
| /* |
| * phpMyEdit - instant MySQL table editor and code generator |
| * |
| * phpMyEdit.class.php - main table editor class definition file |
| * ____________________________________________________________ |
| * |
| * Copyright (c) 1999-2002 John McCreesh <jpmcc@users.sourceforge.net> |
| * Copyright (c) 2001-2002 Jim Kraai <jkraai@users.sourceforge.net> |
| * Versions 5.0 and higher developed by Ondrej Jombik <nepto@php.net> |
| * Copyright (c) 2002-2006 Platon Group, http://platon.sk/ |
| * All rights reserved. |
| * |
| * See README file for more information about this software. |
| * See COPYING file for license information. |
| * |
| * Download the latest version from |
| * http://platon.sk/projects/phpMyEdit/ |
| */ |
| |
| /* $Platon: phpMyEdit/phpMyEdit.class.php,v 1.188 2006-09-08 16:30:31 michal Exp $ */ |
| |
| /* This is a generic table editing program. The table and fields to be |
| edited are defined in the calling program. |
| |
| This program works in three passes. |
| * Pass 1 (the last part of the program) displays the selected MySQL |
| table in a scrolling table on the screen. Radio buttons are used to |
| select a record for editing or deletion. If the user chooses Add, |
| Change, Copy, View or Delete buttons. |
| * Pass 2 starts, displaying the selected record. If the user chooses |
| the Save button from this screen. |
| * Pass 3 processes the update and the display returns to the |
| original table view (Pass 1). |
| */ |
| |
| class phpMyEdit_timer /* {{{ */ |
| { |
| var $startTime; |
| var $started; |
| |
| function phpMyEdit_timer($start = true) |
| { |
| $this->started = false; |
| if ($start) { |
| $this->start(); |
| } |
| } |
| |
| function start() |
| { |
| $startMtime = explode(' ', microtime()); |
| $this->startTime = (double) $startMtime[0] + (double) $startMtime[1]; |
| $this->started = true; |
| } |
| |
| function end($iterations = 1) |
| { |
| // get the time, check whether the timer was started later |
| $endMtime = explode(' ', microtime()); |
| if ($this->started) { |
| $endTime = (double)($endMtime[0])+(double)($endMtime[1]); |
| $dur = $endTime - $this->startTime; |
| $avg = 1000 * $dur / $iterations; |
| $avg = round(1000 * $avg) / 1000; |
| return $avg; |
| } else { |
| return 'phpMyEdit_timer ERROR: timer not started'; |
| } |
| } |
| } /* }}} */ |
| |
| if (! function_exists('array_search')) { /* {{{ */ |
| function array_search($needle, $haystack) |
| { |
| foreach ($haystack as $key => $value) { |
| if ($needle == $value) |
| return $key; |
| } |
| return false; |
| } |
| } /* }}} */ |
| |
| if (! function_exists('realpath')) { /* {{{ */ |
| function realpath($path) |
| { |
| return $path; |
| } |
| } /* }}} */ |
| |
| class phpMyEdit |
| { |
| // Class variables {{{ |
| |
| // Database handling |
| var $hn; // hostname |
| var $un; // user name |
| var $pw; // password |
| var $tb; // table |
| var $db; // database |
| var $dbp; // database with point |
| var $dbh; // database handle |
| var $close_dbh; // if database handle should be closed |
| |
| // Record manipulation |
| var $key; // name of field which is the unique key |
| var $key_num; // number of field which is the unique key |
| var $key_type; // type of key field (int/real/string/date etc.) |
| var $key_delim; // character used for key value quoting |
| var $rec; // number of record selected for editing |
| var $inc; // number of records to display |
| var $fm; // first record to display |
| var $fl; // is the filter row displayed (boolean) |
| var $fds; // sql field names |
| var $fdn; // sql field names => $k |
| var $num_fds; // number of fields |
| var $options; // options for users: ACDFVPI |
| var $fdd; // field definitions |
| var $qfn; // value of all filters used during the last pass |
| var $sfn; // sort field number (- = descending sort order) |
| var $cur_tab; // current selected tab |
| |
| // Operation |
| var $navop; // navigation buttons/operations |
| var $sw; // filter display/hide/clear button |
| var $operation; // operation to do: Add, Change, Delete |
| var $saveadd; |
| var $moreadd; |
| var $canceladd; |
| var $savechange; |
| var $morechange; |
| var $cancelchange; |
| var $savecopy; |
| var $cancelcopy; |
| var $savedelete; |
| var $canceldelete; |
| var $cancelview; |
| |
| // Additional features |
| var $labels; // multilingual labels |
| var $cgi; // CGI variable features array |
| var $js; // JS configuration array |
| var $dhtml; // DHTML configuration array |
| var $url; // URL array |
| var $message; // informational message to print |
| var $notify; // change notification e-mail adresses |
| var $logtable; // name of optional logtable |
| var $navigation; // navigation style |
| var $tabs; // TAB names |
| var $timer = null; // phpMyEdit_timer object |
| |
| // Predefined variables |
| var $comp_ops = array('<'=>'<','<='=>'<=','='=>'=','>='=>'>=','>'=>'>'); |
| var $sql_aggrs = array( |
| 'sum' => 'Total', |
| 'avg' => 'Average', |
| 'min' => 'Minimum', |
| 'max' => 'Maximum', |
| 'count' => 'Count'); |
| var $page_types = array( |
| 'L' => 'list', |
| 'F' => 'filter', |
| 'A' => 'add', |
| 'V' => 'view', |
| 'C' => 'change', |
| 'P' => 'copy', |
| 'D' => 'delete' |
| ); |
| var $default_buttons = array( |
| 'L' => array('<<','<','add','view','change','copy','delete','>','>>','goto','goto_combo'), |
| 'F' => array('<<','<','add','view','change','copy','delete','>','>>','goto','goto_combo'), |
| 'A' => array('save','more','cancel'), |
| 'C' => array('save','more','cancel'), |
| 'P' => array('save', 'cancel'), |
| 'D' => array('save','cancel'), |
| 'V' => array('change','cancel') |
| ); |
| // }}} |
| |
| /* |
| * column specific functions |
| */ |
| |
| function col_has_sql($k) { return isset($this->fdd[$k]['sql']); } |
| function col_has_sqlw($k) { return isset($this->fdd[$k]['sqlw']) && !$this->virtual($k); } |
| function col_has_values($k) { return isset($this->fdd[$k]['values']) || isset($this->fdd[$k]['values2']); } |
| function col_has_php($k) { return isset($this->fdd[$k]['php']); } |
| function col_has_URL($k) { return isset($this->fdd[$k]['URL']) |
| || isset($this->fdd[$k]['URLprefix']) || isset($this->fdd[$k]['URLpostfix']); } |
| function col_has_multiple($k) |
| { return $this->col_has_multiple_select($k) || $this->col_has_checkboxes($k); } |
| function col_has_multiple_select($k) |
| { return $this->fdd[$k]['select'] == 'M' && ! $this->fdd[$k]['values']['table']; } |
| function col_has_checkboxes($k) |
| { return $this->fdd[$k]['select'] == 'C' && ! $this->fdd[$k]['values']['table']; } |
| function col_has_radio_buttons($k) |
| { return $this->fdd[$k]['select'] == 'O' && ! $this->fdd[$k]['values']['table']; } |
| function col_has_datemask($k) |
| { return isset($this->fdd[$k]['datemask']) || isset($this->fdd[$k]['strftimemask']); } |
| |
| /* |
| * functions for indicating whether navigation style is enabled |
| */ |
| |
| function nav_buttons() { return stristr($this->navigation, 'B'); } |
| function nav_text_links() { return stristr($this->navigation, 'T'); } |
| function nav_graphic_links() { return stristr($this->navigation, 'G'); } |
| function nav_up() { return (stristr($this->navigation, 'U') && !($this->buttons[$this->page_type]['up'] === false)); } |
| function nav_down() { return (stristr($this->navigation, 'D') && !($this->buttons[$this->page_type]['down'] === false)); } |
| |
| /* |
| * functions for indicating whether operations are enabled |
| */ |
| |
| function add_enabled() { return stristr($this->options, 'A'); } |
| function change_enabled() { return stristr($this->options, 'C'); } |
| function delete_enabled() { return stristr($this->options, 'D'); } |
| function filter_enabled() { return stristr($this->options, 'F'); } |
| function view_enabled() { return stristr($this->options, 'V'); } |
| function copy_enabled() { return stristr($this->options, 'P') && $this->add_enabled(); } |
| function tabs_enabled() { return $this->display['tabs'] && count($this->tabs) > 0; } |
| function hidden($k) { return stristr($this->fdd[$k]['input'],'H'); } |
| function password($k) { return stristr($this->fdd[$k]['input'],'W'); } |
| function readonly($k) { return stristr($this->fdd[$k]['input'],'R') || $this->virtual($k); } |
| function virtual($k) { return stristr($this->fdd[$k]['input'],'V') && $this->col_has_sql($k); } |
| |
| function add_operation() { return $this->operation == $this->labels['Add'] && $this->add_enabled(); } |
| function change_operation() { return $this->operation == $this->labels['Change'] && $this->change_enabled(); } |
| function copy_operation() { return $this->operation == $this->labels['Copy'] && $this->copy_enabled(); } |
| function delete_operation() { return $this->operation == $this->labels['Delete'] && $this->delete_enabled(); } |
| function view_operation() { return $this->operation == $this->labels['View'] && $this->view_enabled(); } |
| function filter_operation() { return $this->fl && $this->filter_enabled() && $this->list_operation(); } |
| function list_operation() { /* covers also filtering page */ return ! $this->change_operation() |
| && ! $this->add_operation() && ! $this->copy_operation() |
| && ! $this->delete_operation() && ! $this->view_operation(); } |
| function next_operation() { return ($this->navop == $this->labels['Next']) || ($this->navop == '>'); } |
| function prev_operation() { return ($this->navop == $this->labels['Prev']) || ($this->navop == '<'); } |
| function first_operation() { return ($this->navop == $this->labels['First']) || ($this->navop == '<<'); } |
| function last_operation() { return ($this->navop == $this->labels['Last']) || ($this->navop == '>>'); } |
| function clear_operation() { return $this->sw == $this->labels['Clear']; } |
| |
| function add_canceled() { return $this->canceladd == $this->labels['Cancel']; } |
| function view_canceled() { return $this->cancelview == $this->labels['Cancel']; } |
| function change_canceled() { return $this->cancelchange == $this->labels['Cancel']; } |
| function copy_canceled() { return $this->cancelcopy == $this->labels['Cancel']; } |
| function delete_canceled() { return $this->canceldelete == $this->labels['Cancel']; } |
| |
| function is_values2($k, $val = 'X') /* {{{ */ |
| { |
| return $val === null || |
| (isset($this->fdd[$k]['values2']) && !isset($this->fdd[$k]['values']['table'])); |
| } /* }}} */ |
| |
| function processed($k) /* {{{ */ |
| { |
| if ($this->virtual($k)) { |
| return false; |
| } |
| $options = @$this->fdd[$k]['options']; |
| if (! isset($options)) { |
| return true; |
| } |
| return |
| ($this->saveadd == $this->labels['Save'] && stristr($options, 'A')) || |
| ($this->moreadd == $this->labels['More'] && stristr($options, 'A')) || |
| ($this->savechange == $this->labels['Save'] && stristr($options, 'C')) || |
| ($this->morechange == $this->labels['Apply'] && stristr($options, 'C')) || |
| ($this->savecopy == $this->labels['Save'] && stristr($options, 'P')) || |
| ($this->savedelete == $this->labels['Save'] && stristr($options, 'D')); |
| } /* }}} */ |
| |
| function displayed($k) /* {{{ */ |
| { |
| if (is_numeric($k)) { |
| $k = $this->fds[$k]; |
| } |
| $options = @$this->fdd[$k]['options']; |
| if (! isset($options)) { |
| return true; |
| } |
| return |
| ($this->add_operation() && stristr($options, 'A')) || |
| ($this->view_operation() && stristr($options, 'V')) || |
| ($this->change_operation() && stristr($options, 'C')) || |
| ($this->copy_operation() && stristr($options, 'P')) || |
| ($this->delete_operation() && stristr($options, 'D')) || |
| ($this->filter_operation() && stristr($options, 'F')) || |
| ($this->list_operation() && stristr($options, 'L')); |
| } /* }}} */ |
| |
| function debug_var($name, $val) /* {{{ */ |
| { |
| if (is_array($val) || is_object($val)) { |
| echo "<pre>$name\n"; |
| ob_start(); |
| //print_r($val); |
| var_dump($val); |
| $content = ob_get_contents(); |
| ob_end_clean(); |
| echo htmlspecialchars($content); |
| echo "</pre>\n"; |
| } else { |
| echo 'debug_var()::<i>',htmlspecialchars($name),'</i>'; |
| echo '::<b>',htmlspecialchars($val),'</b>::',"<br />\n"; |
| } |
| } /* }}} */ |
| |
| function myquery($qry, $line = 0, $debug = 0) /* {{{ */ |
| { |
| global $debug_query; |
| if ($debug_query || $debug) { |
| $line = intval($line); |
| echo '<h4>MySQL query at line ',$line,'</h4>',htmlspecialchars($qry),'<hr />',"\n"; |
| } |
| if (isset($this->db)) { |
| $ret = @mysql_db_query($this->db, $qry, $this->dbh); |
| } else { |
| $ret = @mysql_query($qry, $this->dbh); |
| } |
| if (! $ret) { |
| echo '<h4>MySQL error ',mysql_errno($this->dbh),'</h4>'; |
| echo htmlspecialchars(mysql_error($this->dbh)),'<hr />',"\n"; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function make_language_labels($language) /* {{{ */ |
| { |
| // just try the first language and variant |
| // this isn't content-negotiation rfc compliant |
| $language = strtoupper($language); |
| |
| // try the full language w/ variant |
| $file = $this->dir['lang'].'PME.lang.'.$language.'.inc'; |
| |
| if (! file_exists($file)) { |
| // try the language w/o variant |
| $file = $this->dir['lang'].'PME.lang.'.substr($language,0,2).'.inc'; |
| } |
| if (! file_exists($file)) { |
| // default to classical English |
| $file = $this->dir['lang'].'PME.lang.EN.inc'; |
| } |
| $ret = @include($file); |
| if (! is_array($ret)) { |
| return $ret; |
| } |
| $small = array( |
| 'Search' => 'v', |
| 'Hide' => '^', |
| 'Clear' => 'X', |
| 'Query' => htmlspecialchars('>')); |
| if ((!$this->nav_text_links() && !$this->nav_graphic_links()) |
| || !isset($ret['Search']) || !isset($ret['Query']) |
| || !isset($ret['Hide']) || !isset($ret['Clear'])) { |
| foreach ($small as $key => $val) { |
| $ret[$key] = $val; |
| } |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function set_values($field_num, $prepend = null, $append = null, $strict = false) /* {{{ */ |
| { |
| return (array) $prepend + (array) $this->fdd[$field_num]['values2'] |
| + (isset($this->fdd[$field_num]['values']['table']) || $strict |
| ? $this->set_values_from_table($field_num, $strict) |
| : array()) |
| + (array) $append; |
| } /* }}} */ |
| |
| function set_values_from_table($field_num, $strict = false) /* {{{ */ |
| { |
| $db = &$this->fdd[$field_num]['values']['db']; |
| $table = &$this->fdd[$field_num]['values']['table']; |
| $key = &$this->fdd[$field_num]['values']['column']; |
| $desc = &$this->fdd[$field_num]['values']['description']; |
| $dbp = isset($db) ? "$db." : $this->dbp; |
| $qparts['type'] = 'select'; |
| if ($table) { |
| $qparts['select'] = 'DISTINCT '.$table.'.'.$key; |
| if ($desc && is_array($desc) && is_array($desc['columns'])) { |
| $qparts['select'] .= ',CONCAT('; // ) |
| $num_cols = sizeof($desc['columns']); |
| if (isset($desc['divs'][-1])) { |
| $qparts['select'] .= '"'.addslashes($desc['divs'][-1]).'",'; |
| } |
| foreach ($desc['columns'] as $key => $val) { |
| if ($val) { |
| $qparts['select'] .= 'IFNULL('.$val.',"")'; |
| if ($desc['divs'][$key]) { |
| $qparts['select'] .= ',"'.addslashes($desc['divs'][$key]).'"'; |
| } |
| $qparts['select'] .= ','; |
| } |
| } |
| $qparts['select']{strlen($qparts['select']) - 1} = ')'; |
| $qparts['select'] .= ' AS PMEalias'.$field_num; |
| $qparts['orderby'] = 'PMEalias'.$field_num; |
| } else if ($desc && is_array($desc)) { |
| // TODO |
| } else if ($desc) { |
| $qparts['select'] .= ','.$table.'.'.$desc; |
| $qparts['orderby'] = $desc; |
| } else if ($key) { |
| $qparts['orderby'] = $key; |
| } |
| $qparts['from'] = "$dbp$table"; |
| $ar = array( |
| 'table' => $table, |
| 'column' => $column, |
| 'description' => $desc); |
| $qparts['where'] = $this->substituteVars($this->fdd[$field_num]['values']['filters'], $ar); |
| if ($this->fdd[$field_num]['values']['orderby']) { |
| $qparts['orderby'] = $this->substituteVars($this->fdd[$field_num]['values']['orderby'], $ar); |
| } |
| } else { /* simple value extraction */ |
| $key = &$this->fds[$field_num]; |
| $this->virtual($field_num) && $key = $this->fqn($field_num); |
| $qparts['select'] = 'DISTINCT '.$key.' AS PMEkey'; |
| $qparts['orderby'] = 'PMEkey'; |
| $qparts['from'] = $this->dbp.$this->tb; |
| } |
| $values = array(); |
| $res = $this->myquery($this->get_SQL_query($qparts), __LINE__); |
| while ($row = @mysql_fetch_array($res, MYSQL_NUM)) { |
| $values[$row[0]] = $desc ? $row[1] : $row[0]; |
| } |
| return $values; |
| } /* }}} */ |
| |
| function fqn($field, $dont_desc = false, $dont_cols = false) /* {{{ */ |
| { |
| is_numeric($field) || $field = array_search($field, $this->fds); |
| // if read SQL expression exists use it |
| if ($this->col_has_sql($field)) |
| return $this->fdd[$field]['sql']; |
| // on copy/change always use simple key retrieving |
| if ($this->add_operation() |
| || $this->copy_operation() |
| || $this->change_operation()) { |
| $ret = 'PMEtable0.'.$this->fds[$field]; |
| } else { |
| if ($this->fdd[$this->fds[$field]]['values']['description'] && ! $dont_desc) { |
| $desc = &$this->fdd[$this->fds[$field]]['values']['description']; |
| if (is_array($desc) && is_array($desc['columns'])) { |
| $ret = 'CONCAT('; // ) |
| $num_cols = sizeof($desc['columns']); |
| if (isset($desc['divs'][-1])) { |
| $ret .= '"'.addslashes($desc['divs'][-1]).'",'; |
| } |
| foreach ($desc['columns'] as $key => $val) { |
| if ($val) { |
| $ret .= 'PMEjoin'.$field.'.'.$val; |
| if ($desc['divs'][$key]) { |
| $ret .= ',"'.addslashes($desc['divs'][$key]).'"'; |
| } |
| $ret .= ','; |
| } |
| } |
| $ret{strlen($ret) - 1} = ')'; |
| } else if (is_array($desc)) { |
| // TODO |
| } else { |
| $ret = 'PMEjoin'.$field.'.'.$this->fdd[$this->fds[$field]]['values']['description']; |
| } |
| // TODO: remove me |
| } elseif (0 && $this->fdd[$this->fds[$field]]['values']['column'] && ! $dont_cols) { |
| $ret = 'PMEjoin'.$field.'.'.$this->fdd[$this->fds[$field]]['values']['column']; |
| } else { |
| $ret = 'PMEtable0.'.$this->fds[$field]; |
| } |
| // TODO: not neccessary, remove me! |
| if (is_array($this->fdd[$this->fds[$field]]['values2'])) { |
| } |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function get_SQL_query($parts) /* {{{ */ |
| { |
| foreach ($parts as $k => $v) { |
| $parts[$k] = trim($parts[$k]); |
| } |
| switch ($parts['type']) { |
| case 'select': |
| $ret = 'SELECT '; |
| if ($parts['DISTINCT']) |
| $ret .= 'DISTINCT '; |
| $ret .= $parts['select']; |
| $ret .= ' FROM '.$parts['from']; |
| if ($parts['where'] != '') |
| $ret .= ' WHERE '.$parts['where']; |
| if ($parts['groupby'] != '') |
| $ret .= ' GROUP BY '.$parts['groupby']; |
| if ($parts['having'] != '') |
| $ret .= ' HAVING '.$parts['having']; |
| if ($parts['orderby'] != '') |
| $ret .= ' ORDER BY '.$parts['orderby']; |
| if ($parts['limit'] != '') |
| $ret .= ' LIMIT '.$parts['limit']; |
| if ($parts['procedure'] != '') |
| $ret .= ' PROCEDURE '.$parts['procedure']; |
| break; |
| case 'update': |
| $ret = 'UPDATE '.$parts['table']; |
| $ret .= ' SET '.$parts['fields']; |
| if ($parts['where'] != '') |
| $ret .= ' WHERE '.$parts['where']; |
| break; |
| case 'insert': |
| $ret = 'INSERT INTO '.$parts['table']; |
| $ret .= ' VALUES '.$parts['values']; |
| break; |
| case 'delete': |
| $ret = 'DELETE FROM '.$parts['table']; |
| if ($parts['where'] != '') |
| $ret .= ' WHERE '.$parts['where']; |
| break; |
| default: |
| die('unknown query type'); |
| break; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function get_SQL_column_list() /* {{{ */ |
| { |
| $fields = array(); |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| if (! $this->displayed[$k] && $k != $this->key_num) { |
| continue; |
| } |
| $fields[] = $this->fqn($k).' AS qf'.$k; |
| if ($this->col_has_values($k)) { |
| $fields[] = $this->fqn($k, true, true).' AS qf'.$k.'_idx'; |
| } |
| if ($this->col_has_datemask($k)) { |
| $fields[] = 'UNIX_TIMESTAMP('.$this->fqn($k).') AS qf'.$k.'_timestamp'; |
| } |
| } |
| return join(',', $fields); |
| } /* }}} */ |
| |
| function get_SQL_join_clause() /* {{{ */ |
| { |
| $main_table = 'PMEtable0'; |
| $join_clause = $this->tb." AS $main_table"; |
| for ($k = 0, $numfds = sizeof($this->fds); $k < $numfds; $k++) { |
| $main_column = $this->fds[$k]; |
| if($this->fdd[$main_column]['values']['db']) { |
| $dbp = $this->fdd[$main_column]['values']['db'].'.'; |
| } else { |
| $dbp = $this->dbp; |
| } |
| $table = @$this->fdd[$main_column]['values']['table']; |
| $join_column = @$this->fdd[$main_column]['values']['column']; |
| $join_desc = @$this->fdd[$main_column]['values']['description']; |
| if ($join_desc != '' && $join_column != '') { |
| $join_table = 'PMEjoin'.$k; |
| $ar = array( |
| 'main_table' => $main_table, |
| 'main_column' => $main_column, |
| 'join_table' => $join_table, |
| 'join_column' => $join_column, |
| 'join_description' => $join_desc); |
| $join_clause .= " LEFT OUTER JOIN $dbp$table AS $join_table ON ("; |
| $join_clause .= isset($this->fdd[$main_column]['values']['join']) |
| ? $this->substituteVars($this->fdd[$main_column]['values']['join'], $ar) |
| : "$join_table.$join_column = $main_table.$main_column"; |
| if (isset($this->fdd[$main_column]['values']['filters'])) { |
| $join_clause .= ' AND '; |
| $join_clause .= $this->substituteVars($this->fdd[$main_column]['values']['filters'], $ar); |
| } |
| $join_clause .= ')'; |
| } |
| } |
| return $join_clause; |
| } /* }}} */ |
| |
| function get_SQL_where_from_query_opts($qp = null, $text = 0) /* {{{ */ |
| { |
| if ($qp == null) { |
| $qp = $this->query_opts; |
| } |
| $where = array(); |
| foreach ($qp as $field => $ov) { |
| if (is_numeric($field)) { |
| $tmp_where = array(); |
| foreach ($ov as $field2 => $ov2) { |
| $tmp_where[] = sprintf('%s %s %s', $field2, $ov2['oper'], $ov2['value']); |
| } |
| $where[] = '('.join(' OR ', $tmp_where).')'; |
| } else { |
| if (is_array($ov['value'])) { |
| $tmp_ov_val = ''; |
| foreach ($ov['value'] as $ov_val) { |
| strlen($tmp_ov_val) > 0 && $tmp_ov_val .= ' OR '; |
| $tmp_ov_val .= sprintf('FIND_IN_SET("%s",%s)', $ov_val, $field); |
| } |
| $where[] = "($tmp_ov_val)"; |
| } else { |
| $where[] = sprintf('%s %s %s', $field, $ov['oper'], $ov['value']); |
| } |
| } |
| } |
| // Add any coder specified filters |
| if (! $text && $this->filters) { |
| $where[] = '('.$this->filters.')'; |
| } |
| if (count($where) > 0) { |
| if ($text) { |
| return str_replace('%', '*', join(' AND ',$where)); |
| } else { |
| return join(' AND ',$where); |
| } |
| } |
| return ''; /* empty string */ |
| } /* }}} */ |
| |
| function gather_query_opts() /* {{{ */ |
| { |
| $this->query_opts = array(); |
| $this->prev_qfn = $this->qfn; |
| $this->qfn = ''; |
| if ($this->clear_operation()) { |
| return; |
| } |
| // gathers query options into an array, $this->query_opts |
| $qo = array(); |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| $l = 'qf'.$k; |
| $lc = 'qf'.$k.'_comp'; |
| $li = 'qf'.$k.'_id'; |
| $m = $this->get_sys_cgi_var($l); |
| $mc = $this->get_sys_cgi_var($lc); |
| $mi = $this->get_sys_cgi_var($li); |
| if (! isset($m) && ! isset($mi)) { |
| continue; |
| } |
| if (is_array($m) || is_array($mi)) { |
| if (is_array($mi)) { |
| $m = $mi; |
| $l = $li; |
| } |
| if (in_array('*', $m)) { |
| continue; |
| } |
| if ($this->col_has_values($k) && $this->col_has_multiple($k)) { |
| foreach (array_keys($m) as $key) { |
| $m[$key] = addslashes($m[$key]); |
| } |
| $qo[$this->fqn($k)] = array('value' => $m); |
| } else { |
| $qf_op = ''; |
| foreach (array_keys($m) as $key) { |
| if ($qf_op == '') { |
| $qf_op = 'IN'; |
| $qf_val = '"'.addslashes($m[$key]).'"'; |
| $afilter = ' IN ("'.addslashes($m[$key]).'"'; // ) |
| } else { |
| $afilter = $afilter.',"'.addslashes($m[$key]).'"'; |
| $qf_val .= ',"'.addslashes($m[$key]).'"'; |
| } |
| $this->qfn .= '&'.$this->cgi['prefix']['sys'].$l.'['.rawurlencode($key).']='.rawurlencode($m[$key]); |
| } |
| $afilter = $afilter.')'; |
| // XXX: $dont_desc and $dont_cols hack |
| $dont_desc = isset($this->fdd[$k]['values']['description']); |
| $dont_cols = isset($this->fdd[$k]['values']['column']); |
| $qo[$this->fqn($k, $dont_desc, $dont_cols)] = |
| array('oper' => $qf_op, 'value' => "($qf_val)"); // ) |
| } |
| } else if (isset($mi)) { |
| if ($mi == '*') { |
| continue; |
| } |
| if ($this->fdd[$k]['select'] != 'M' && $this->fdd[$k]['select'] != 'D' && $mi == '') { |
| continue; |
| } |
| $afilter = addslashes($mi); |
| $qo[$this->fqn($k, true, true)] = array('oper' => '=', 'value' => "'$afilter'"); |
| $this->qfn .= '&'.$this->cgi['prefix']['sys'].$li.'='.rawurlencode($mi); |
| } else if (isset($m)) { |
| if ($m == '*') { |
| continue; |
| } |
| if ($this->fdd[$k]['select'] != 'M' && $this->fdd[$k]['select'] != 'D' && $m == '') { |
| continue; |
| } |
| $afilter = addslashes($m); |
| if ($this->fdd[$k]['select'] == 'N') { |
| $mc = in_array($mc, $this->comp_ops) ? $mc : '='; |
| $qo[$this->fqn($k)] = array('oper' => $mc, 'value' => "'$afilter'"); |
| $this->qfn .= '&'.$this->cgi['prefix']['sys'].$l .'='.rawurlencode($m); |
| $this->qfn .= '&'.$this->cgi['prefix']['sys'].$lc.'='.rawurlencode($mc); |
| } else { |
| $afilter = '%'.str_replace('*', '%', $afilter).'%'; |
| $ids = array(); |
| $ar = array(); |
| $ar[$this->fqn($k)] = array('oper' => 'LIKE', 'value' => "'$afilter'"); |
| if (is_array($this->fdd[$k]['values2'])) { |
| foreach ($this->fdd[$k]['values2'] as $key => $val) { |
| if (strlen($m) > 0 && stristr($val, $m)) { |
| $ids[] = '"'.addslashes($key).'"'; |
| } |
| } |
| if (count($ids) > 0) { |
| $ar[$this->fqn($k, true, true)] |
| = array('oper' => 'IN', 'value' => '('.join(',', $ids).')'); |
| } |
| } |
| $qo[] = $ar; |
| $this->qfn .= '&'.$this->cgi['prefix']['sys'].$l.'='.rawurlencode($m); |
| } |
| } |
| } |
| $this->query_opts = $qo; |
| } /* }}} */ |
| |
| /* |
| * Create JavaScripts |
| */ |
| |
| function form_begin() /* {{{ */ |
| { |
| $page_name = htmlspecialchars($this->page_name); |
| if ($this->add_operation() || $this->change_operation() || $this->copy_operation() |
| || $this->view_operation() || $this->delete_operation()) { |
| $field_to_tab = array(); |
| for ($tab = $k = $this->cur_tab = 0; $k < $this->num_fds; $k++) { |
| if (isset($this->fdd[$k]['tab'])) { |
| if ($tab == 0 && $k > 0) { |
| $this->tabs[0] = 'PMEtab0'; |
| $this->cur_tab = 1; |
| $tab++; |
| } |
| if (is_array($this->fdd[$k]['tab'])) { |
| $this->tabs[$tab] = @$this->fdd[$k]['tab']['name']; |
| $this->fdd[$k]['tab']['default'] && $this->cur_tab = $tab; |
| } else { |
| $this->tabs[$tab] = @$this->fdd[$k]['tab']; |
| } |
| $tab++; |
| } |
| $field_to_tab[$k] = max(0, $tab - 1); |
| } |
| if (preg_match('/^'.$this->dhtml['prefix'].'tab(\d+)$/', $this->get_sys_cgi_var('cur_tab'), $parts)) { |
| $this->cur_tab = $parts[1]; |
| } |
| if ($this->tabs_enabled()) { |
| // initial TAB styles |
| echo '<style type="text/css" media="screen">',"\n"; |
| for ($i = 0; $i < count($this->tabs); $i++) { |
| echo ' #'.$this->dhtml['prefix'].'tab',$i,' { display: '; |
| echo (($i == $this->cur_tab || $this->tabs[$i] == 'PMEtab0' ) ? 'block' : 'none') ,'; }',"\n"; |
| } |
| echo '</style>',"\n"; |
| // TAB javascripts |
| echo '<script type="text/javascript"><!--',"\n\n"; |
| $css_class_name1 = $this->getCSSclass('tab', $position); |
| $css_class_name2 = $this->getCSSclass('tab-selected', $position); |
| echo 'var '.$this->js['prefix'].'cur_tab = "'.$this->dhtml['prefix'].'tab',$this->cur_tab,'"; |
| |
| function '.$this->js['prefix'].'show_tab(tab_name) |
| {'; |
| if ($this->nav_up()) { |
| echo ' |
| document.getElementById('.$this->js['prefix'].'cur_tab+"_up_label").className = "',$css_class_name1,'"; |
| document.getElementById('.$this->js['prefix'].'cur_tab+"_up_link").className = "',$css_class_name1,'"; |
| document.getElementById(tab_name+"_up_label").className = "',$css_class_name2,'"; |
| document.getElementById(tab_name+"_up_link").className = "',$css_class_name2,'";'; |
| } |
| if ($this->nav_down()) { |
| echo ' |
| document.getElementById('.$this->js['prefix'].'cur_tab+"_down_label").className = "',$css_class_name1,'"; |
| document.getElementById('.$this->js['prefix'].'cur_tab+"_down_link").className = "',$css_class_name1,'"; |
| document.getElementById(tab_name+"_down_label").className = "',$css_class_name2,'"; |
| document.getElementById(tab_name+"_down_link").className = "',$css_class_name2,'";'; |
| } |
| echo ' |
| document.getElementById('.$this->js['prefix'].'cur_tab).style.display = "none"; |
| document.getElementById(tab_name).style.display = "block"; |
| '.$this->js['prefix'].'cur_tab = tab_name; |
| document.'.$this->cgi['prefix']['sys'].'form.'.$this->cgi['prefix']['sys'].'cur_tab.value = tab_name; |
| }',"\n\n"; |
| echo '// --></script>', "\n"; |
| } |
| } |
| |
| if ($this->add_operation() || $this->change_operation() || $this->copy_operation()) { |
| $first_required = true; |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| if ($this->displayed[$k] && ! $this->readonly($k) && ! $this->hidden($k) |
| && ($this->fdd[$k]['js']['required'] || isset($this->fdd[$k]['js']['regexp']))) { |
| if ($first_required) { |
| $first_required = false; |
| echo '<script type="text/javascript"><!--',"\n"; |
| echo ' |
| function '.$this->js['prefix'].'trim(str) |
| { |
| while (str.substring(0, 1) == " " |
| || str.substring(0, 1) == "\\n" |
| || str.substring(0, 1) == "\\r") |
| { |
| str = str.substring(1, str.length); |
| } |
| while (str.substring(str.length - 1, str.length) == " " |
| || str.substring(str.length - 1, str.length) == "\\n" |
| || str.substring(str.length - 1, str.length) == "\\r") |
| { |
| str = str.substring(0, str.length - 1); |
| } |
| return str; |
| } |
| |
| function '.$this->js['prefix'].'form_control(theForm) |
| {',"\n"; |
| } |
| if ($this->col_has_values($k)) { |
| $condition = 'theForm.'.$this->cgi['prefix']['data'].$this->fds[$k].'.selectedIndex == -1'; |
| $multiple = $this->col_has_multiple_select($k); |
| } else { |
| $condition = ''; |
| $multiple = false; |
| if ($this->fdd[$k]['js']['required']) { |
| $condition = $this->js['prefix'].'trim(theForm.'.$this->cgi['prefix']['data'].$this->fds[$k].'.value) == ""'; |
| } |
| if (isset($this->fdd[$k]['js']['regexp'])) { |
| $condition .= (strlen($condition) > 0 ? ' || ' : ''); |
| $condition .= sprintf('!(%s.test('.$this->js['prefix'].'trim(theForm.%s.value)))', |
| $this->fdd[$k]['js']['regexp'], $this->cgi['prefix']['data'].$this->fds[$k]); |
| } |
| } |
| |
| /* Multiple selects have their name like ``name[]''. |
| It is not possible to work with them directly, because |
| theForm.name[].something will result into JavaScript |
| syntax error. Following search algorithm is provided |
| as a workaround for this. |
| */ |
| if ($multiple) { |
| echo ' |
| multiple_select = null; |
| for (i = 0; i < theForm.length; i++) { |
| if (theForm.elements[i].name == "',$this->cgi['prefix']['data'].$this->fds[$k],'[]") { |
| multiple_select = theForm.elements[i]; |
| break; |
| } |
| } |
| if (multiple_select != null && multiple_select.selectedIndex == -1) {'; |
| } else { |
| echo ' |
| if (',$condition,') {'; |
| } |
| echo ' |
| alert("'; |
| if (isset($this->fdd[$k]['js']['hint'])) { |
| echo htmlspecialchars($this->fdd[$k]['js']['hint']); |
| } else { |
| echo $this->labels['Please enter'],' ',$this->fdd[$k]['name'],'.'; |
| } |
| echo '");'; |
| if ($this->tabs_enabled() && $field_to_tab[$k] >= $this->cur_tab) { |
| echo ' |
| '.$this->js['prefix'].'show_tab("'.$this->dhtml['prefix'].'tab',$field_to_tab[$k],'");'; |
| } |
| echo ' |
| theForm.',$this->cgi['prefix']['data'].$this->fds[$k],'.focus(); |
| return false; |
| }',"\n"; |
| } |
| } |
| if (! $first_required) { |
| echo ' |
| return true; |
| }',"\n\n"; |
| echo '// --></script>', "\n"; |
| } |
| } |
| |
| if ($this->filter_operation()) { |
| echo '<script type="text/javascript"><!--',"\n"; |
| echo ' |
| function '.$this->js['prefix'].'filter_handler(theForm, theEvent) |
| { |
| var pressed_key = null; |
| if (theEvent.which) { |
| pressed_key = theEvent.which; |
| } else { |
| pressed_key = theEvent.keyCode; |
| } |
| if (pressed_key == 13) { // enter pressed |
| theForm.submit(); |
| return false; |
| } |
| return true; |
| }',"\n\n"; |
| echo '// --></script>', "\n"; |
| } |
| |
| if ($this->display['form']) { |
| echo '<form class="',$this->getCSSclass('form'),'" method="post"'; |
| echo ' action="',$page_name,'" name="'.$this->cgi['prefix']['sys'].'form">',"\n"; |
| } |
| return true; |
| } /* }}} */ |
| |
| function form_end() /* {{{ */ |
| { |
| if ($this->display['form']) { |
| echo '</form>',"\n"; |
| } |
| } /* }}} */ |
| |
| function display_tab_labels($position) /* {{{ */ |
| { |
| if (! is_array($this->tabs)) { |
| return false; |
| } |
| echo '<table summary="labels" class="',$this->getCSSclass('tab', $position),'">',"\n"; |
| echo '<tr class="',$this->getCSSclass('tab', $position),'">',"\n"; |
| for ($i = ($this->tabs[0] == 'PMEtab0' ? 1 : 0); $i < count($this->tabs); $i++) { |
| $css_class_name = $this->getCSSclass($i != $this->cur_tab ? 'tab' : 'tab-selected', $position); |
| echo '<td class="',$css_class_name,'" id="'.$this->dhtml['prefix'].'tab',$i,'_',$position,'_label">'; |
| echo '<a class="',$css_class_name,'" id="'.$this->dhtml['prefix'].'tab',$i,'_',$position,'_link'; |
| echo '" href="javascript:'.$this->js['prefix'].'show_tab(\''.$this->dhtml['prefix'].'tab',$i,'\')">'; |
| echo $this->tabs[$i],'</a></td>',"\n"; |
| } |
| echo '<td class="',$this->getCSSclass('tab-end', $position),'"> </td>',"\n"; |
| echo '</tr>',"\n"; |
| echo '</table>',"\n"; |
| } /* }}} */ |
| |
| /* |
| * Display functions |
| */ |
| |
| function display_add_record() /* {{{ */ |
| { |
| for ($tab = 0, $k = 0; $k < $this->num_fds; $k++) { |
| if (isset($this->fdd[$k]['tab']) && $this->tabs_enabled() && $k > 0) { |
| $tab++; |
| echo '</table>',"\n"; |
| echo '</div>',"\n"; |
| echo '<div id="'.$this->dhtml['prefix'].'tab',$tab,'">',"\n"; |
| echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n"; |
| } |
| if (! $this->displayed[$k]) { |
| continue; |
| } |
| if ($this->hidden($k)) { |
| echo $this->htmlHiddenData($this->fds[$k], $this->fdd[$k]['default']); |
| continue; |
| } |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('input', null, 'next', $css_postfix); |
| $escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true; |
| echo '<tr class="',$this->getCSSclass('row', null, true, $css_postfix),'">',"\n"; |
| echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">'; |
| echo $this->fdd[$k]['name'],'</td>',"\n"; |
| echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"'; |
| echo $this->getColAttributes($k),">\n"; |
| if ($this->col_has_values($k)) { |
| $vals = $this->set_values($k); |
| $selected = @$this->fdd[$k]['default']; |
| $multiple = $this->col_has_multiple($k); |
| $readonly = $this->readonly($k); |
| $strip_tags = true; |
| //$escape = true; |
| if ($this->col_has_checkboxes($k) || $this->col_has_radio_buttons($k)) { |
| echo $this->htmlRadioCheck($this->cgi['prefix']['data'].$this->fds[$k], |
| $css_class_name, $vals, $selected, $multiple, $readonly, |
| $strip_tags, $escape); |
| } else { |
| echo $this->htmlSelect($this->cgi['prefix']['data'].$this->fds[$k], |
| $css_class_name, $vals, $selected, $multiple, $readonly, |
| $strip_tags, $escape); |
| } |
| } elseif (isset ($this->fdd[$k]['textarea'])) { |
| echo '<textarea class="',$css_class_name,'" name="',$this->cgi['prefix']['data'].$this->fds[$k],'"'; |
| echo ($this->readonly($k) ? ' disabled="disabled"' : ''); |
| if (intval($this->fdd[$k]['textarea']['rows']) > 0) { |
| echo ' rows="',$this->fdd[$k]['textarea']['rows'],'"'; |
| } |
| if (intval($this->fdd[$k]['textarea']['cols']) > 0) { |
| echo ' cols="',$this->fdd[$k]['textarea']['cols'],'"'; |
| } |
| if (isset($this->fdd[$k]['textarea']['wrap'])) { |
| echo ' wrap="',$this->fdd[$k]['textarea']['wrap'],'"'; |
| } else { |
| echo ' wrap="virtual"'; |
| } |
| echo '>'; |
| if($escape) echo htmlspecialchars($this->fdd[$k]['default']); |
| else echo $this->fdd[$k]['default']; |
| echo '</textarea>',"\n"; |
| } elseif ($this->col_has_php($k)) { |
| echo include($this->fdd[$k]['php']); |
| } else { |
| // Simple edit box required |
| $size_ml_props = ''; |
| $maxlen = intval($this->fdd[$k]['maxlen']); |
| $size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60); |
| $size && $size_ml_props .= ' size="'.$size.'"'; |
| $maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"'; |
| echo '<input class="',$css_class_name,'" '; |
| echo ($this->password($k) ? 'type="password"' : 'type="text"'); |
| echo ($this->readonly($k) ? ' disabled="disabled"' : ''); |
| echo ' name="',$this->cgi['prefix']['data'].$this->fds[$k],'"'; |
| echo $size_ml_props,' value="'; |
| if($escape) echo htmlspecialchars($this->fdd[$k]['default']); |
| else echo $this->fdd[$k]['default']; |
| echo '" />'; |
| } |
| echo '</td>',"\n"; |
| if ($this->guidance) { |
| $css_class_name = $this->getCSSclass('help', null, true, $css_postfix); |
| $cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' '; |
| echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n"; |
| } |
| echo '</tr>',"\n"; |
| } |
| } /* }}} */ |
| |
| function display_copy_change_delete_record() /* {{{ */ |
| { |
| /* |
| * For delete or change: SQL SELECT to retrieve the selected record |
| */ |
| |
| $qparts['type'] = 'select'; |
| $qparts['select'] = $this->get_SQL_column_list(); |
| $qparts['from'] = $this->get_SQL_join_clause(); |
| $qparts['where'] = '('.$this->fqn($this->key).'=' |
| .$this->key_delim.$this->rec.$this->key_delim.')'; |
| |
| $res = $this->myquery($this->get_SQL_query($qparts),__LINE__); |
| if (! ($row = @mysql_fetch_array($res, MYSQL_ASSOC))) { |
| return false; |
| } |
| for ($tab = 0, $k = 0; $k < $this->num_fds; $k++) { |
| if (isset($this->fdd[$k]['tab']) && $this->tabs_enabled() && $k > 0) { |
| $tab++; |
| echo '</table>',"\n"; |
| echo '</div>',"\n"; |
| echo '<div id="'.$this->dhtml['prefix'].'tab',$tab,'">',"\n"; |
| echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n"; |
| } |
| if (! $this->displayed[$k]) { |
| continue; |
| } |
| if ($this->copy_operation() || $this->change_operation()) { |
| if ($this->hidden($k)) { |
| if ($k != $this->key_num) { |
| echo $this->htmlHiddenData($this->fds[$k], $row["qf$k"]); |
| } |
| continue; |
| } |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n"; |
| echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">'; |
| echo $this->fdd[$k]['name'],'</td>',"\n"; |
| /* There are two possibilities of readonly fields handling: |
| 1. Display plain text for readonly timestamps, dates and URLs. |
| 2. Display disabled input field |
| In all cases particular readonly field will NOT be saved. */ |
| if ($this->readonly($k) && ($this->col_has_datemask($k) || $this->col_has_URL($k))) { |
| echo $this->display_delete_field($row, $k); |
| } elseif ($this->password($k)) { |
| echo $this->display_password_field($row, $k); |
| } else { |
| echo $this->display_change_field($row, $k); |
| } |
| if ($this->guidance) { |
| $css_class_name = $this->getCSSclass('help', null, true, $css_postfix); |
| $cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' '; |
| echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n"; |
| } |
| echo '</tr>',"\n"; |
| } elseif ($this->delete_operation() || $this->view_operation()) { |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n"; |
| echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">'; |
| echo $this->fdd[$k]['name'],'</td>',"\n"; |
| if ($this->password($k)) { |
| echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"'; |
| echo $this->getColAttributes($k),'>',$this->labels['hidden'],'</td>',"\n"; |
| } else { |
| $this->display_delete_field($row, $k); |
| } |
| if ($this->guidance) { |
| $css_class_name = $this->getCSSclass('help', null, true, $css_postfix); |
| $cell_value = $this->fdd[$k]['help'] ? $this->fdd[$k]['help'] : ' '; |
| echo '<td class="',$css_class_name,'">',$cell_value,'</td>',"\n"; |
| } |
| echo '</tr>',"\n"; |
| } |
| } |
| } /* }}} */ |
| |
| function display_change_field($row, $k) /* {{{ */ |
| { |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('input', null, true, $css_postfix); |
| $escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true; |
| echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"'; |
| echo $this->getColAttributes($k),">\n"; |
| if ($this->col_has_values($k)) { |
| $vals = $this->set_values($k); |
| $multiple = $this->col_has_multiple($k); |
| $readonly = $this->readonly($k); |
| $strip_tags = true; |
| //$escape = true; |
| if ($this->col_has_checkboxes($k) || $this->col_has_radio_buttons($k)) { |
| echo $this->htmlRadioCheck($this->cgi['prefix']['data'].$this->fds[$k], |
| $css_class_name, $vals, $row["qf$k"], $multiple, $readonly, |
| $strip_tags, $escape); |
| } else { |
| echo $this->htmlSelect($this->cgi['prefix']['data'].$this->fds[$k], |
| $css_class_name, $vals, $row["qf$k"], $multiple, $readonly, |
| $strip_tags, $escape); |
| } |
| } elseif (isset($this->fdd[$k]['textarea'])) { |
| echo '<textarea class="',$css_class_name,'" name="',$this->cgi['prefix']['data'].$this->fds[$k],'"'; |
| echo ($this->readonly($k) ? ' disabled="disabled"' : ''); |
| if (intval($this->fdd[$k]['textarea']['rows']) > 0) { |
| echo ' rows="',$this->fdd[$k]['textarea']['rows'],'"'; |
| } |
| if (intval($this->fdd[$k]['textarea']['cols']) > 0) { |
| echo ' cols="',$this->fdd[$k]['textarea']['cols'],'"'; |
| } |
| if (isset($this->fdd[$k]['textarea']['wrap'])) { |
| echo ' wrap="',$this->fdd[$k]['textarea']['wrap'],'"'; |
| } else { |
| echo ' wrap="virtual"'; |
| } |
| echo '>'; |
| if($escape) echo htmlspecialchars($row["qf$k"]); |
| else echo $row["qf$k"]; |
| echo '</textarea>',"\n"; |
| } elseif ($this->col_has_php($k)) { |
| echo include($this->fdd[$k]['php']); |
| } else { |
| $size_ml_props = ''; |
| $maxlen = intval($this->fdd[$k]['maxlen']); |
| $size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60); |
| $size && $size_ml_props .= ' size="'.$size.'"'; |
| $maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"'; |
| echo '<input class="',$css_class_name,'" type="text" '; |
| echo ($this->readonly($k) ? 'disabled="disabled" ' : ''); |
| echo 'name="',$this->cgi['prefix']['data'].$this->fds[$k],'" value="'; |
| if($escape) echo htmlspecialchars($row["qf$k"]); |
| else echo $row["qf$k"]; |
| echo '" />',"\n"; |
| } |
| echo '</td>',"\n"; |
| } /* }}} */ |
| |
| function display_password_field($row, $k) /* {{{ */ |
| { |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"'; |
| echo $this->getColAttributes($k),">\n"; |
| $size_ml_props = ''; |
| $maxlen = intval($this->fdd[$k]['maxlen']); |
| $size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] : min($maxlen, 60); |
| $size && $size_ml_props .= ' size="'.$size.'"'; |
| $maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"'; |
| echo '<input class="',$this->getCSSclass('value', null, true, $css_postfix),'" type="password" '; |
| echo ($this->readonly($k) ? 'disabled="disabled" ' : ''); |
| echo 'name="',$this->cgi['prefix']['data'].$this->fds[$k],'" value="'; |
| echo htmlspecialchars($row["qf$k"]),'" ',$size_ml_props,' />',"\n"; |
| echo '</td>',"\n"; |
| } /* }}} */ |
| |
| function display_delete_field($row, $k) /* {{{ */ |
| { |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('value', null, true, $css_postfix); |
| echo '<td class="',$css_class_name,'"',$this->getColAttributes($k),">\n"; |
| echo $this->cellDisplay($k, $row, $css_class_name); |
| echo '</td>',"\n"; |
| } /* }}} */ |
| |
| /** |
| * Returns CSS class name |
| */ |
| function getCSSclass($name, $position = null, $divider = null, $postfix = null) /* {{{ */ |
| { |
| static $div_idx = -1; |
| $elements = array($this->css['prefix'], $name); |
| if ($this->page_type && $this->css['page_type']) { |
| if ($this->page_type != 'L' && $this->page_type != 'F') { |
| $elements[] = $this->page_types[$this->page_type]; |
| } |
| } |
| if ($position && $this->css['position']) { |
| $elements[] = $position; |
| } |
| if ($divider && $this->css['divider']) { |
| if ($divider === 'next') { |
| $div_idx++; |
| if ($this->css['divider'] > 0 && $div_idx >= $this->css['divider']) { |
| $div_idx = 0; |
| } |
| } |
| $elements[] = $div_idx; |
| } |
| if ($postfix) { |
| $elements[] = $postfix; |
| } |
| return join($this->css['separator'], $elements); |
| } /* }}} */ |
| |
| /** |
| * Returns field cell HTML attributes |
| */ |
| function getColAttributes($k) /* {{{ */ |
| { |
| $colattrs = ''; |
| if (isset($this->fdd[$k]['colattrs'])) { |
| $colattrs .= ' '; |
| $colattrs .= trim($this->fdd[$k]['colattrs']); |
| } |
| if (isset($this->fdd[$k]['nowrap'])) { |
| $colattrs .= ' nowrap'; |
| } |
| return $colattrs; |
| } /* }}} */ |
| |
| /** |
| * Substitutes variables in string |
| * (this is very simple but secure eval() replacement) |
| */ |
| function substituteVars($str, $subst_ar) /* {{{ */ |
| { |
| $array = preg_split('/(\\$\w+)/', $str, -1, PREG_SPLIT_DELIM_CAPTURE); |
| $count = count($array); |
| for ($i = 1; $i < $count; $i += 2) { |
| $key = substr($array[$i], 1); |
| if (isset($subst_ar[$key])) { |
| $array[$i] = $subst_ar[$key]; |
| } |
| } |
| return join('', $array); |
| } /* }}} */ |
| |
| /** |
| * Print URL |
| */ |
| function urlDisplay($k, $link_val, $disp_val, $css, $key) /* {{{ */ |
| { |
| $escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true; |
| $ret = ''; |
| $name = $this->fds[$k]; |
| $page = $this->page_name; |
| $url = $this->cgi['prefix']['sys'].'rec'.'='.$key.'&'.$this->cgi['prefix']['sys'].'fm' |
| .'='.$this->fm.'&'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl; |
| $url .= '&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn).$this->qfn; |
| $url .= '&'.$this->get_sfn_cgi_vars().$this->cgi['persist']; |
| $ar = array( |
| 'key' => $key, |
| 'name' => $name, |
| 'link' => $link_val, |
| 'value' => $disp_val, |
| 'css' => $css, |
| 'page' => $page, |
| 'url' => $url |
| ); |
| $urllink = isset($this->fdd[$k]['URL']) |
| ? $this->substituteVars($this->fdd[$k]['URL'], $ar) |
| : $link_val; |
| $urldisp = isset($this->fdd[$k]['URLdisp']) |
| ? $this->substituteVars($this->fdd[$k]['URLdisp'], $ar) |
| : $disp_val; |
| $target = isset($this->fdd[$k]['URLtarget']) |
| ? 'target="'.htmlspecialchars($this->fdd[$k]['URLtarget']).'" ' |
| : ''; |
| $prefix_found = false; |
| $postfix_found = false; |
| $prefix_ar = @$this->fdd[$k]['URLprefix']; |
| $postfix_ar = @$this->fdd[$k]['URLpostfix']; |
| is_array($prefix_ar) || $prefix_ar = array($prefix_ar); |
| is_array($postfix_ar) || $postfix_ar = array($postfix_ar); |
| foreach ($prefix_ar as $prefix) { |
| if (! strncmp($prefix, $urllink, strlen($prefix))) { |
| $prefix_found = true; |
| break; |
| } |
| } |
| foreach ($postfix_ar as $postfix) { |
| if (! strncmp($postfix, $urllink, strlen($postfix))) { |
| $postfix_found = true; |
| break; |
| } |
| } |
| $prefix_found || $urllink = array_shift($prefix_ar).$urllink; |
| $postfix_found || $urllink = $urllink.array_shift($postfix_ar); |
| if (strlen($urllink) <= 0 || strlen($urldisp) <= 0) { |
| $ret = ' '; |
| } else { |
| if ($escape) { |
| $urldisp = htmlspecialchars($urldisp); |
| } |
| $urllink = htmlspecialchars($urllink); |
| $ret = '<a '.$target.'class="'.$css.'" href="'.$urllink.'">'.$urldisp.'</a>'; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function cellDisplay($k, $row, $css) /* {{{ */ |
| { |
| $escape = isset($this->fdd[$k]['escape']) ? $this->fdd[$k]['escape'] : true; |
| $key_rec = $row['qf'.$this->key_num]; |
| if (@$this->fdd[$k]['datemask']) { |
| $value = intval($row["qf$k".'_timestamp']); |
| $value = $value ? @date($this->fdd[$k]['datemask'], $value) : ''; |
| } else if (@$this->fdd[$k]['strftimemask']) { |
| $value = intval($row["qf$k".'_timestamp']); |
| $value = $value ? @strftime($this->fdd[$k]['strftimemask'], $value) : ''; |
| } else if ($this->is_values2($k, $row["qf$k"])) { |
| $value = $row['qf'.$k.'_idx']; |
| if ($this->fdd[$k]['select'] == 'M') { |
| $value_ar = explode(',', $value); |
| $value_ar2 = array(); |
| foreach ($value_ar as $value_key) { |
| if (isset($this->fdd[$k]['values2'][$value_key])) { |
| $value_ar2[$value_key] = $this->fdd[$k]['values2'][$value_key]; |
| $escape = false; |
| } |
| } |
| $value = join(', ', $value_ar2); |
| } else { |
| if (isset($this->fdd[$k]['values2'][$value])) { |
| $value = $this->fdd[$k]['values2'][$value]; |
| $escape = false; |
| } |
| } |
| } elseif (isset($this->fdd[$k]['values2'][$row["qf$k"]])) { |
| $value = $this->fdd[$k]['values2'][$row["qf$k"]]; |
| } else { |
| $value = $row["qf$k"]; |
| } |
| $original_value = $value; |
| if (@$this->fdd[$k]['strip_tags']) { |
| $value = strip_tags($value); |
| } |
| if ($num_ar = @$this->fdd[$k]['number_format']) { |
| if (! is_array($num_ar)) { |
| $num_ar = array($num_ar); |
| } |
| if (count($num_ar) == 1) { |
| list($nbDec) = $num_ar; |
| $value = number_format($value, $nbDec); |
| } else if (count($num_ar) == 3) { |
| list($nbDec, $decPoint, $thSep) = $num_ar; |
| $value = number_format($value, $nbDec, $decPoint, $thSep); |
| } |
| } |
| if (intval($this->fdd[$k]['trimlen']) > 0 && strlen($value) > $this->fdd[$k]['trimlen']) { |
| $value = ereg_replace("[\r\n\t ]+",' ',$value); |
| $value = substr($value, 0, $this->fdd[$k]['trimlen'] - 3).'...'; |
| } |
| if (@$this->fdd[$k]['mask']) { |
| $value = sprintf($this->fdd[$k]['mask'], $value); |
| } |
| if ($this->col_has_php($k)) { |
| return include($this->fdd[$k]['php']); |
| } |
| if ($this->col_has_URL($k)) { |
| return $this->urlDisplay($k, $original_value, $value, $css, $key_rec); |
| } |
| if (strlen($value) <= 0) { |
| return ' '; |
| } |
| if ($escape) { |
| $value = htmlspecialchars($value); |
| } |
| return nl2br($value); |
| } /* }}} */ |
| |
| /** |
| * Creates HTML submit input element |
| * |
| * @param name element name |
| * @param label key in the language hash used as label |
| * @param css_class_name CSS class name |
| * @param js_validation if add JavaScript validation subroutine to button |
| * @param disabled if mark the button as disabled |
| * @param js any extra text in tags |
| */ |
| function htmlSubmit($name, $label, $css_class_name, $js_validation = true, $disabled = false, $js = NULL) /* {{{ */ |
| { |
| // Note that <input disabled> isn't valid HTML, but most browsers support it |
| if($disabled == -1) return; |
| $markdisabled = $disabled ? ' disabled="disabled"' : ''; |
| $ret = '<input'.$markdisabled.' type="submit" class="'.$css_class_name |
| .'" name="'.$this->cgi['prefix']['sys'].ltrim($markdisabled).$name |
| .'" value="'.(isset($this->labels[$label]) ? $this->labels[$label] : $label); |
| if ($js_validation) { |
| $ret .= '" onclick="return '.$this->js['prefix'].'form_control(this.form);'; |
| } |
| $ret .='"'; |
| if(isset($js)) $ret .= ' '.$js; |
| $ret .= ' />'; |
| return $ret; |
| } /* }}} */ |
| |
| /** |
| * Creates HTML hidden input element |
| * |
| * @param name element name |
| * @param value value |
| */ |
| |
| function htmlHiddenSys($name, $value) /* {{{ */ |
| { |
| return $this->htmlHidden($this->cgi['prefix']['sys'].$name, $value); |
| } /* }}} */ |
| |
| function htmlHiddenData($name, $value) /* {{{ */ |
| { |
| return $this->htmlHidden($this->cgi['prefix']['data'].$name, $value); |
| } /* }}} */ |
| |
| function htmlHidden($name, $value) /* {{{ */ |
| { |
| return '<input type="hidden" name="'.htmlspecialchars($name) |
| .'" value="'.htmlspecialchars($value).'" />'."\n"; |
| } /* }}} */ |
| |
| /** |
| * Creates HTML select element (tag) |
| * |
| * @param name element name |
| * @param css CSS class name |
| * @param kv_array key => value array |
| * @param selected selected key (it can be single string, array of |
| * keys or multiple values separated by comma) |
| * @param multiple bool for multiple selection |
| * @param readonly bool for readonly/disabled selection |
| * @param strip_tags bool for stripping tags from values |
| * @param escape bool for HTML escaping values |
| * @param js string to be in the <select >, ususally onchange='..'; |
| */ |
| function htmlSelect($name, $css, $kv_array, $selected = null, /* ...) {{{ */ |
| /* booleans: */ $multiple = false, $readonly = false, $strip_tags = false, $escape = true, $js = NULL) |
| { |
| $ret = '<select class="'.htmlspecialchars($css).'" name="'.htmlspecialchars($name); |
| if ($multiple) { |
| $ret .= '[]" multiple size="'.$this->multiple; |
| if (! is_array($selected) && $selected !== null) { |
| $selected = explode(',', $selected); |
| } |
| } |
| $ret .= '"'.($readonly ? ' disabled="disabled"' : '').$js.'>'."\n"; |
| if (! is_array($selected)) { |
| $selected = $selected === null ? array() : array($selected); |
| } |
| $found = false; |
| foreach ($kv_array as $key => $value) { |
| $ret .= '<option value="'.htmlspecialchars($key).'"'; |
| if ((! $found || $multiple) && in_array((string) $key, $selected, 1) |
| || (count($selected) == 0 && ! $found && ! $multiple)) { |
| $ret .= ' selected="selected"'; |
| $found = true; |
| } |
| $strip_tags && $value = strip_tags($value); |
| $escape && $value = htmlspecialchars($value); |
| $ret .= '>'.$value.'</option>'."\n"; |
| } |
| $ret .= '</select>'; |
| return $ret; |
| } /* }}} */ |
| |
| /** |
| * Creates HTML checkboxes or radio buttons |
| * |
| * @param name element name |
| * @param css CSS class name |
| * @param kv_array key => value array |
| * @param selected selected key (it can be single string, array of |
| * keys or multiple values separated by comma) |
| * @param multiple bool for multiple selection (checkboxes) |
| * @param readonly bool for readonly/disabled selection |
| * @param strip_tags bool for stripping tags from values |
| * @param escape bool for HTML escaping values |
| * @param js string to be in the <select >, ususally onchange='..'; |
| */ |
| function htmlRadioCheck($name, $css, $kv_array, $selected = null, /* ...) {{{ */ |
| /* booleans: */ $multiple = false, $readonly = false, $strip_tags = false, $escape = true, $js = NULL) |
| { |
| $ret = ''; |
| if ($multiple) { |
| if (! is_array($selected) && $selected !== null) { |
| $selected = explode(',', $selected); |
| } |
| } |
| if (! is_array($selected)) { |
| $selected = $selected === null ? array() : array($selected); |
| } |
| $found = false; |
| foreach ($kv_array as $key => $value) { |
| $ret .= '<input type="'.($multiple ? 'checkbox' : 'radio').'" name="'; |
| $ret .= htmlspecialchars($name).'[]" value="'.htmlspecialchars($key).'"'; |
| if ((! $found || $multiple) && in_array((string) $key, $selected, 1) |
| || (count($selected) == 0 && ! $found && ! $multiple)) { |
| $ret .= ' checked'; |
| $found = true; |
| } |
| if ($readonly) { |
| $ret .= ' disabled="disabled"'; |
| } |
| $strip_tags && $value = strip_tags($value); |
| $escape && $value = htmlspecialchars($value); |
| $ret .= '>'.$value.'<br>'."\n"; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| /** |
| * Returns original variables HTML code for use in forms or links. |
| * |
| * @param mixed $origvars string or array of original varaibles |
| * @param string $method type of method ("POST" or "GET") |
| * @param mixed $default_value default value of variables |
| * if null, empty values will be skipped |
| * @return get HTML code of original varaibles |
| */ |
| function get_origvars_html($origvars, $method = 'post', $default_value = '') /* {{{ */ |
| { |
| $ret = ''; |
| $method = strtoupper($method); |
| if ($method == 'POST') { |
| if (! is_array($origvars)) { |
| $new_origvars = array(); |
| foreach (explode('&', $origvars) as $param) { |
| $parts = explode('=', $param, 2); |
| if (! isset($parts[1])) { |
| $parts[1] = $default_value; |
| } |
| if (strlen($parts[0]) <= 0) { |
| continue; |
| } |
| $new_origvars[$parts[0]] = $parts[1]; |
| } |
| $origvars =& $new_origvars; |
| } |
| foreach ($origvars as $key => $val) { |
| if (strlen($val) <= 0 && $default_value === null) { |
| continue; |
| } |
| $key = rawurldecode($key); |
| $val = rawurldecode($val); |
| $ret .= $this->htmlHidden($key, $val); |
| } |
| } else if (! strncmp('GET', $method, 3)) { |
| if (! is_array($origvars)) { |
| $ret .= $origvars; |
| } else { |
| foreach ($origvars as $key => $val) { |
| if (strlen($val) <= 0 && $default_value === null) { |
| continue; |
| } |
| $ret == '' || $ret .= '&'; |
| $ret .= htmlspecialchars(rawurlencode($key)); |
| $ret .= '='; |
| $ret .= htmlspecialchars(rawurlencode($val)); |
| } |
| } |
| if ($method[strlen($method) - 1] == '+') { |
| $ret = "?$ret"; |
| } |
| } else { |
| trigger_error('Unsupported Platon::get_origvars_html() method: ' |
| .$method, E_USER_ERROR); |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function get_sfn_cgi_vars($alternative_sfn = null) /* {{{ */ |
| { |
| if ($alternative_sfn === null) { // FAST! (cached return value) |
| static $ret = null; |
| $ret == null && $ret = $this->get_sfn_cgi_vars($this->sfn); |
| return $ret; |
| } |
| $ret = ''; |
| $i = 0; |
| foreach ($alternative_sfn as $val) { |
| $ret != '' && $ret .= '&'; |
| $ret .= rawurlencode($this->cgi['prefix']['sys'].'sfn')."[$i]=".rawurlencode($val); |
| $i++; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function get_default_cgi_prefix($type) /* {{{ */ |
| { |
| switch ($type) { |
| case 'operation': return 'PME_op_'; |
| case 'sys': return 'PME_sys_'; |
| case 'data': return 'PME_data_'; |
| } |
| return ''; |
| } /* }}} */ |
| |
| function get_sys_cgi_var($name, $default_value = null) /* {{{ */ |
| { |
| if (isset($this)) { |
| return $this->get_cgi_var($this->cgi['prefix']['sys'].$name, $default_value); |
| } |
| return phpMyEdit::get_cgi_var(phpMyEdit::get_default_cgi_prefix('sys').$name, $default_value); |
| } /* }}} */ |
| |
| function get_data_cgi_var($name, $default_value = null) /* {{{ */ |
| { |
| if (isset($this)) { |
| return $this->get_cgi_var($this->cgi['prefix']['data'].$name, $default_value); |
| } |
| return phpMyEdit::get_cgi_var(phpMyEdit::get_default_cgi_prefix('data').$name, $default_value); |
| } /* }}} */ |
| |
| function get_cgi_var($name, $default_value = null) /* {{{ */ |
| { |
| if (isset($this) && isset($this->cgi['overwrite'][$name])) { |
| return $this->cgi['overwrite'][$name]; |
| } |
| |
| static $magic_quotes_gpc = null; |
| if ($magic_quotes_gpc === null) { |
| $magic_quotes_gpc = get_magic_quotes_gpc(); |
| } |
| $var = @$_GET[$name]; |
| if (! isset($var)) { |
| $var = @$_POST[$name]; |
| } |
| if (isset($var)) { |
| if ($magic_quotes_gpc) { |
| if (is_array($var)) { |
| foreach (array_keys($var) as $key) { |
| $var[$key] = stripslashes($var[$key]); |
| } |
| } else { |
| $var = stripslashes($var); |
| } |
| } |
| } else { |
| $var = @$default_value; |
| } |
| if (isset($this) && $var === null && isset($this->cgi['append'][$name])) { |
| return $this->cgi['append'][$name]; |
| } |
| return $var; |
| } /* }}} */ |
| |
| function get_server_var($name) /* {{{ */ |
| { |
| if (isset($_SERVER[$name])) { |
| return $_SERVER[$name]; |
| } |
| global $HTTP_SERVER_VARS; |
| if (isset($HTTP_SERVER_VARS[$name])) { |
| return $HTTP_SERVER_VARS[$name]; |
| } |
| global $$name; |
| if (isset($$name)) { |
| return $$name; |
| } |
| return null; |
| } /* }}} */ |
| |
| /* |
| * Debug functions |
| */ |
| |
| function print_get_vars ($miss = 'No GET variables found') // debug only /* {{{ */ |
| { |
| // we parse form GET variables |
| if (is_array($_GET)) { |
| echo "<p> Variables per GET "; |
| foreach ($_GET as $k => $v) { |
| if (is_array($v)) { |
| foreach ($v as $akey => $aval) { |
| // $_GET[$k][$akey] = strip_tags($aval); |
| // $$k[$akey] = strip_tags($aval); |
| echo "$k\[$akey\]=$aval "; |
| } |
| } else { |
| // $_GET[$k] = strip_tags($val); |
| // $$k = strip_tags($val); |
| echo "$k=$v "; |
| } |
| } |
| echo '</p>'; |
| } else { |
| echo '<p>'; |
| echo $miss; |
| echo '</p>'; |
| } |
| } /* }}} */ |
| |
| function print_post_vars($miss = 'No POST variables found') // debug only /* {{{ */ |
| { |
| global $_POST; |
| // we parse form POST variables |
| if (is_array($_POST)) { |
| echo "<p>Variables per POST "; |
| foreach ($_POST as $k => $v) { |
| if (is_array($v)) { |
| foreach ($v as $akey => $aval) { |
| // $_POST[$k][$akey] = strip_tags($aval); |
| // $$k[$akey] = strip_tags($aval); |
| echo "$k\[$akey\]=$aval "; |
| } |
| } else { |
| // $_POST[$k] = strip_tags($val); |
| // $$k = strip_tags($val); |
| echo "$k=$v "; |
| } |
| } |
| echo '</p>'; |
| } else { |
| echo '<p>'; |
| echo $miss; |
| echo '</p>'; |
| } |
| } /* }}} */ |
| |
| function print_vars ($miss = 'Current instance variables') // debug only /* {{{ */ |
| { |
| echo "$miss "; |
| echo 'page_name=',$this->page_name,' '; |
| echo 'hn=',$this->hn,' '; |
| echo 'un=',$this->un,' '; |
| echo 'pw=',$this->pw,' '; |
| echo 'db=',$this->db,' '; |
| echo 'dbp=',$this->dbp,' '; |
| echo 'dbh=',$this->dbh,' '; |
| echo 'tb=',$this->tb,' '; |
| echo 'key=',$this->key,' '; |
| echo 'key_type=',$this->key_type,' '; |
| echo 'inc=',$this->inc,' '; |
| echo 'options=',$this->options,' '; |
| echo 'fdd=',$this->fdd,' '; |
| echo 'fl=',$this->fl,' '; |
| echo 'fm=',$this->fm,' '; |
| echo 'sfn=',htmlspecialchars($this->get_sfn_cgi_vars()),' '; |
| echo 'qfn=',$this->qfn,' '; |
| echo 'sw=',$this->sw,' '; |
| echo 'rec=',$this->rec,' '; |
| echo 'navop=',$this->navop,' '; |
| echo 'saveadd=',$this->saveadd,' '; |
| echo 'moreadd=',$this->moreadd,' '; |
| echo 'canceladd=',$this->canceladd,' '; |
| echo 'savechange=',$this->savechange,' '; |
| echo 'morechange=',$this->morechange,' '; |
| echo 'cancelchange=',$this->cancelchange,' '; |
| echo 'savecopy=',$this->savecopy,' '; |
| echo 'cancelcopy=',$this->cancelcopy,' '; |
| echo 'savedelete=',$this->savedelete,' '; |
| echo 'canceldelete=',$this->canceldelete,' '; |
| echo 'cancelview=',$this->cancelview,' '; |
| echo 'operation=',$this->operation,' '; |
| echo "\n"; |
| } /* }}} */ |
| |
| /* |
| * Display buttons at top and bottom of page |
| */ |
| function display_list_table_buttons($position, $listall = false) /* {{{ */ |
| { |
| if (($but_str = $this->display_buttons($position)) === null) |
| return; |
| if($position == 'down') echo '<hr class="'.$this->getCSSclass('hr', 'down').'" />'."\n"; |
| echo '<table summary="navigation" class="',$this->getCSSclass('navigation', $position),'">',"\n"; |
| echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n"; |
| echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n"; |
| echo $but_str,'</td>',"\n"; |
| // Message is now written here |
| if (strlen(@$this->message) > 0) { |
| echo '<td class="',$this->getCSSclass('message', $position),'">',$this->message,'</td>',"\n"; |
| } |
| if($this->display['num_pages'] || $this->display['num_records']) |
| echo '<td class="',$this->getCSSclass('stats', $position),'">',"\n"; |
| if($this->display['num_pages']) { |
| if ($listall) { |
| echo $this->labels['Page'],': 1 ',$this->labels['of'],' 1'; |
| } else { |
| $current_page = intval($this->fm / $this->inc) + 1; |
| $total_pages = max(1, ceil($this->total_recs / abs($this->inc))); |
| echo $this->labels['Page'],': ',$current_page; |
| echo ' ',$this->labels['of'],' ',$total_pages; |
| } |
| } |
| if($this->display['num_records']) |
| echo ' ',$this->labels['Records'],': ',$this->total_recs; |
| if($this->display['num_pages'] || $this->display['num_records']) echo '</td>'; |
| echo '</tr></table>',"\n"; |
| if($position == 'up') echo '<hr class="'.$this->getCSSclass('hr', 'up').'" />'."\n"; |
| } /* }}} */ |
| |
| /* |
| * Display buttons at top and bottom of page |
| */ |
| function display_record_buttons($position) /* {{{ */ |
| { |
| if (($but_str = $this->display_buttons($position)) === null) |
| return; |
| if ($position == 'down') { |
| if ($this->tabs_enabled()) $this->display_tab_labels('down'); |
| echo '<hr class="',$this->getCSSclass('hr', 'down'),'" />',"\n"; |
| } |
| echo '<table summary="navigation" class="',$this->getCSSclass('navigation', $position),'">',"\n"; |
| echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n"; |
| echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n"; |
| echo $but_str,'</td>',"\n"; |
| // Message is now written here |
| //echo '</td>',"\n"; |
| if (strlen(@$this->message) > 0) { |
| echo '<td class="',$this->getCSSclass('message', $position),'">',$this->message,'</td>',"\n"; |
| } |
| echo '</tr></table>',"\n"; |
| if ($position == 'up') { |
| if ($this->tabs_enabled()) $this->display_tab_labels('up'); |
| echo '<hr class="',$this->getCSSclass('hr', 'up'),'" />',"\n"; |
| } |
| } /* }}} */ |
| |
| function display_buttons($position) /* {{{ */ |
| { |
| $nav_fnc = 'nav_'.$position; |
| if(! $this->$nav_fnc()) |
| return; |
| $buttons = (is_array($this->buttons[$this->page_type][$position])) |
| ? $this->buttons[$this->page_type][$position] |
| : $this->default_buttons[$this->page_type]; |
| foreach ($buttons as $name) { |
| $ret .= $this->display_button($name, $position)."\n"; |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function display_button($name, $position = 'up') /* {{{ */ |
| { |
| if (is_array($name)) { |
| if (isset($name['code'])) return $name['code']; |
| return $this->htmlSubmit($name['name'], $name['value'], $name['css'], $name['disabled'], $name['js']); |
| } |
| $disabled = 1; // show disabled by default |
| if ($name[0] == '+') { $name = substr($name, 1); $disabled = 0; } // always show disabled as enabled |
| if ($name[0] == '-') { $name = substr($name, 1); $disabled = -1; } // don't show disabled |
| if ($name == 'cancel') { |
| return $this->htmlSubmit('cancel'.$this->page_types[$this->page_type], 'Cancel', |
| $this->getCSSclass('cancel', $position), false); |
| } |
| if (in_array($name, array('add','view','change','copy','delete'))) { |
| $enabled_fnc = $name.'_enabled'; |
| $enabled = $this->$enabled_fnc(); |
| if ($name != 'add' && ! $this->total_recs && strstr('LF', $this->page_type)) |
| $enabled = false; |
| return $this->htmlSubmit('operation', ucfirst($name), |
| $this->getCSSclass($name, $position), false, $enabled ? 0 : $disabled); |
| } |
| if ($name == 'savedelete') { |
| $enabled = $this->delete_enabled(); |
| $js = 'onclick="return confirm(\''.$this->labels['Delete'].' ?\');"'; |
| return $this->htmlSubmit('savedelete', 'Delete', |
| $this->getCSSclass('save', $position), false, $enabled ? 0 : $disabled, $js); |
| } |
| if (in_array($name, array('save','more'))) { |
| $validation = true; // if js validation |
| if ($this->page_type == 'D' && $name == 'save' ) { $value = 'Delete'; $validation = false; } |
| elseif ($this->page_type == 'C' && $name == 'more' ) { $value = 'Apply'; } |
| else $value = ucfirst($name); |
| return $this->htmlSubmit($name.$this->page_types[$this->page_type], $value, |
| $this->getCSSclass($name, $position), $validation); |
| } |
| $listall = $this->inc <= 0; |
| if ($listall) { |
| $disabledprev = true; |
| $disablednext = true; |
| $total_pages = 1; |
| $current_page = 1; |
| } else { |
| $disabledprev = $this->fm <= 0; |
| $disablednext = $this->fm + $this->inc >= $this->total_recs; |
| $total_pages = max(1, ceil($this->total_recs / abs($this->inc))); |
| $current_page = ceil($this->fm / abs($this->inc)); // must + 1 |
| } |
| $disabledfirst = $disabledprev; |
| $disabledlast = $disablednext; |
| // some statistics first |
| if ($name == 'total_pages') return $total_pages; |
| if ($name == 'current_page') return ($current_page+1); |
| if ($name == 'total_recs') return ($this->total_recs); |
| // now some goto buttons/dropdowns/inputs... |
| if ($name == 'goto_text') { |
| $ret = '<input type="text" class="'.$this->getCSSclass('gotopn', $position).'"'; |
| $ret .= ' name="'.$this->cgi['prefix']['sys'].'navpn'.$position.'" value="'.($current_page+1).'"'; |
| $ret .= ' size="'.(strlen($total_pages)+1).'" maxlength="'.(strlen($total_pages)+1).'"'; |
| // TODO some js here.... on enter submit, on click erase ?... |
| $ret .=' oneypress="return PE_filter_handler(this.form, event);" />'; |
| return $ret; |
| } |
| if ($name == 'goto_combo') { |
| $disabledgoto = !($listall || ($disablednext && $disabledprev)) ? '' : ' disabled'; |
| if ($disablegoto != '' && $disabled < 0) return; |
| $kv_array = array(); |
| for ($i = 0; $i < $total_pages; $i++) { |
| $kv_array[$this->inc * $i] = $i + 1; |
| } |
| // TODO: add onchange="return this.form.submit();" DONE ??? |
| return $this->htmlSelect($this->cgi['prefix']['sys'].ltrim($disabledgoto).'navfm'.$position, |
| $this->getCSSclass('goto', $position), $kv_array, (string)$this->fm, false, $disabledgoto, |
| false, true, 'onchange="return this.form.submit();"'); |
| } |
| if ($name == 'goto') { |
| return $this->htmlSubmit('navop', 'Go to', $this->getCSSclass('goto', $position), |
| false, ($listall || ($disablednext && $disabledprev)) ? $disabled : 0); |
| } |
| if (in_array($name, array('first','prev','next','last','<<','<','>','>>'))) { |
| $disabled_var = 'disabled'.$name; |
| $name2 = $name; |
| if (strlen($name) <= 2) { |
| $nav_values = array('<<' => 'first', '<' => 'prev', '>' => 'next', '>>' => 'last'); |
| $disabled_var = 'disabled'.$nav_values[$name]; |
| $name2 = $nav_values[$name]; |
| } |
| return $this->htmlSubmit('navop', ucfirst($name), |
| $this->getCSSclass($name2, $position), false, $$disabled_var ? $disabled : 0); |
| } |
| if(isset($this->labels[$name])) return $this->labels[$name]; |
| return $name; |
| } /* }}} */ |
| |
| function number_of_recs() /* {{{ */ |
| { |
| $count_parts = array( |
| 'type' => 'select', |
| 'select' => 'count(*)', |
| 'from' => $this->get_SQL_join_clause(), |
| 'where' => $this->get_SQL_where_from_query_opts()); |
| $res = $this->myquery($this->get_SQL_query($count_parts), __LINE__); |
| $row = @mysql_fetch_array($res, MYSQL_NUM); |
| $this->total_recs = $row[0]; |
| } /* }}} */ |
| |
| /* |
| * Table Page Listing |
| */ |
| function list_table() /* {{{ */ |
| { |
| if ($this->fm == '') { |
| $this->fm = 0; |
| } |
| $this->fm = $this->navfm; |
| if ($this->prev_operation()) { |
| $this->fm = $this->fm - $this->inc; |
| if ($this->fm < 0) { |
| $this->fm = 0; |
| } |
| } |
| if ($this->first_operation()) { |
| $this->fm = 0; |
| } // last operation must be performed below, after retrieving total_recs |
| if ($this->next_operation()) { |
| $this->fm += $this->inc; |
| } |
| $this->number_of_recs(); |
| if ($this->last_operation() || $this->fm > $this->total_recs) { // if goto_text is badly set |
| $this->fm = (int)(($this->total_recs - 1)/$this->inc)*$this->inc; |
| } |
| // If sort sequence has changed, restart listing |
| $this->qfn != $this->prev_qfn && $this->fm = 0; |
| if (0) { // DEBUG |
| echo 'qfn vs. prev_qfn comparsion '; |
| echo '[<b>',htmlspecialchars($this->qfn),'</b>]'; |
| echo '[<b>',htmlspecialchars($this->prev_qfn),'</b>]<br />'; |
| echo 'comparsion <u>',($this->qfn == $this->prev_qfn ? 'proved' : 'failed'),'</u>'; |
| echo '<hr />'; |
| } |
| /* |
| * If user is allowed to Change/Delete records, we need an extra column |
| * to allow users to select a record |
| */ |
| $select_recs = $this->key != '' && |
| ($this->change_enabled() || $this->delete_enabled() || $this->view_enabled()); |
| // Are we doing a listall? |
| $listall = $this->inc <= 0; |
| /* |
| * Display the MySQL table in an HTML table |
| */ |
| $this->form_begin(); |
| echo $this->get_origvars_html($this->get_sfn_cgi_vars()); |
| echo $this->htmlHiddenSys('fl', $this->fl); |
| // Display buttons at top and/or bottom of page. |
| $this->display_list_table_buttons('up', $listall); |
| if ($this->cgi['persist'] != '') { |
| echo $this->get_origvars_html($this->cgi['persist']); |
| } |
| if (! $this->filter_operation()) { |
| echo $this->get_origvars_html($this->qfn); |
| } |
| echo $this->htmlHiddenSys('qfn', $this->qfn); |
| echo $this->htmlHiddenSys('fm', $this->fm); |
| echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n"; |
| echo '<tr class="',$this->getCSSclass('header'),'">',"\n"; |
| /* |
| * System (navigation, selection) columns counting |
| */ |
| $sys_cols = 0; |
| $sys_cols += intval($this->filter_enabled() || $select_recs); |
| if ($sys_cols > 0) { |
| $sys_cols += intval($this->nav_buttons() |
| && ($this->nav_text_links() || $this->nav_graphic_links())); |
| } |
| /* |
| * We need an initial column(s) (sys columns) |
| * if we have filters, Changes or Deletes enabled |
| */ |
| if ($sys_cols) { |
| echo '<th class="',$this->getCSSclass('header'),'" colspan="',$sys_cols,'">'; |
| if ($this->filter_enabled()) { |
| if ($this->filter_operation()) { |
| echo $this->htmlSubmit('sw', 'Hide', $this->getCSSclass('hide'), false); |
| echo $this->htmlSubmit('sw', 'Clear', $this->getCSSclass('clear'), false); |
| } else { |
| echo $this->htmlSubmit('sw', 'Search', $this->getCSSclass('search'), false); |
| } |
| } else { |
| echo ' '; |
| } |
| echo '</th>',"\n"; |
| } |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| $fd = $this->fds[$k]; |
| if (! $this->displayed[$k]) { |
| continue; |
| } |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('header', null, null, $css_postfix); |
| $fdn = $this->fdd[$fd]['name']; |
| if (! $this->fdd[$fd]['sort'] || $this->password($fd)) { |
| echo '<th class="',$css_class_name,'">',$fdn,'</th>',"\n"; |
| } else { |
| // Clicking on the current sort field reverses the sort order |
| $new_sfn = $this->sfn; |
| array_unshift($new_sfn, in_array("$k", $new_sfn, 1) ? "-$k" : $k); |
| echo '<th class="',$css_class_name,'">'; |
| echo '<a class="',$css_class_name,'" href="'; |
| echo htmlspecialchars($this->page_name.'?'.$this->cgi['prefix']['sys'].'fm'.'=0' |
| .'&'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl |
| .'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn).$this->qfn |
| .'&'.$this->get_sfn_cgi_vars($new_sfn).$this->cgi['persist']); |
| echo '">',$fdn,'</a></th>',"\n"; |
| } |
| } |
| echo '</tr>',"\n"; |
| |
| /* |
| * Prepare the SQL Query from the data definition file |
| */ |
| $qparts['type'] = 'select'; |
| $qparts['select'] = $this->get_SQL_column_list(); |
| // Even if the key field isn't displayed, we still need its value |
| if ($select_recs) { |
| if (!in_array ($this->key, $this->fds)) { |
| $qparts['select'] .= ','.$this->fqn($this->key); |
| } |
| } |
| $qparts['from'] = $this->get_SQL_join_clause(); |
| $qparts['where'] = $this->get_SQL_where_from_query_opts(); |
| // build up the ORDER BY clause |
| if (isset($this->sfn)) { |
| $sort_fields = array(); |
| $sort_fields_w = array(); |
| foreach ($this->sfn as $field) { |
| if ($field[0] == '-') { |
| $field = substr($field, 1); |
| $desc = true; |
| } else { |
| $field = $field; |
| $desc = false; |
| } |
| $sort_field = $this->fqn($field); |
| $sort_field_w = $this->fdd[$field]['name']; |
| $this->col_has_sql($field) && $sort_field_w .= ' (sql)'; |
| if ($desc) { |
| $sort_field .= ' DESC'; |
| $sort_field_w .= ' '.$this->labels['descending']; |
| } else { |
| $sort_field_w .= ' '.$this->labels['ascending']; |
| } |
| $sort_fields[] = $sort_field; |
| $sort_fields_w[] = $sort_field_w; |
| } |
| if (count($sort_fields) > 0) { |
| $qparts['orderby'] = join(',', $sort_fields); |
| } |
| } |
| $qparts['limit'] = $listall ? '' : $this->fm.','.$this->inc; |
| |
| /* |
| * Main list_table() query |
| * |
| * Each row of the HTML table is one record from the SQL query. We must |
| * perform this query before filter printing, because we want to use |
| * mysql_field_len() function. We will also fetch the first row to get |
| * the field names. |
| */ |
| $query = $this->get_SQL_query($qparts); |
| $res = $this->myquery($query, __LINE__); |
| if ($res == false) { |
| $this->error('invalid SQL query', $query); |
| return false; |
| } |
| $row = @mysql_fetch_array($res, MYSQL_ASSOC); |
| |
| /* FILTER {{{ |
| * |
| * Draw the filter and fill it with any data typed in last pass and stored |
| * in the array parameter keyword 'filter'. Prepare the SQL WHERE clause. |
| */ |
| if ($this->filter_operation()) { |
| // Filter row retrieval |
| $fields = false; |
| $filter_row = $row; |
| if (! is_array($filter_row)) { |
| unset($qparts['where']); |
| $query = $this->get_SQL_query($qparts); |
| $res = $this->myquery($query, __LINE__); |
| if ($res == false) { |
| $this->error('invalid SQL query', $query); |
| return false; |
| } |
| $filter_row = @mysql_fetch_array($res, MYSQL_ASSOC); |
| } |
| /* Variable $fields is used to get index of particular field in |
| result. That index can be passed in example to mysql_field_len() |
| function. Use field names as indexes to $fields array. */ |
| if (is_array($filter_row)) { |
| $fields = array_flip(array_keys($filter_row)); |
| } |
| if ($fields != false) { |
| $css_class_name = $this->getCSSclass('filter'); |
| echo '<tr class="',$css_class_name,'">',"\n"; |
| echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">'; |
| echo $this->htmlSubmit('filter', 'Query', $this->getCSSclass('query'), false); |
| echo '</td>', "\n"; |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| if (! $this->displayed[$k]) { |
| continue; |
| } |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('filter', null, null, $css_postfix); |
| $this->field_name = $this->fds[$k]; |
| $fd = $this->field_name; |
| $this->field = $this->fdd[$fd]; |
| $l = 'qf'.$k; |
| $lc = 'qf'.$k.'_comp'; |
| $li = 'qf'.$k.'_id'; |
| if ($this->clear_operation()) { |
| $m = null; |
| $mc = null; |
| $mi = null; |
| } else { |
| $m = $this->get_sys_cgi_var($l); |
| $mc = $this->get_sys_cgi_var($lc); |
| $mi = $this->get_sys_cgi_var($li); |
| } |
| echo '<td class="',$css_class_name,'">'; |
| if ($this->password($k)) { |
| echo ' '; |
| } else if ($this->fdd[$fd]['select'] == 'D' || $this->fdd[$fd]['select'] == 'M') { |
| // Multiple fields processing |
| // Default size is 2 and array required for values. |
| $from_table = ! $this->col_has_values($k) || isset($this->fdd[$k]['values']['table']); |
| $vals = $this->set_values($k, array('*' => '*'), null, $from_table); |
| $selected = $mi; |
| $multiple = $this->col_has_multiple_select($k); |
| $multiple |= $this->fdd[$fd]['select'] == 'M'; |
| $readonly = false; |
| $strip_tags = true; |
| $escape = true; |
| echo $this->htmlSelect($this->cgi['prefix']['sys'].$l.'_id', $css_class_name, |
| $vals, $selected, $multiple, $readonly, $strip_tags, $escape); |
| } elseif ($this->fdd[$fd]['select'] == 'N' || $this->fdd[$fd]['select'] == 'T') { |
| $size_ml_props = ''; |
| $maxlen = intval($this->fdd[$k]['maxlen']); |
| $maxlen > 0 || $maxlen = intval(@mysql_field_len($res, $fields["qf$k"])); |
| $size = isset($this->fdd[$k]['size']) ? $this->fdd[$k]['size'] |
| : ($maxlen < 30 ? min($maxlen, 8) : 12); |
| $size && $size_ml_props .= ' size="'.$size.'"'; |
| $maxlen && $size_ml_props .= ' maxlength="'.$maxlen.'"'; |
| if ($this->fdd[$fd]['select'] == 'N') { |
| $mc = in_array($mc, $this->comp_ops) ? $mc : '='; |
| echo $this->htmlSelect($this->cgi['prefix']['sys'].$l.'_comp', |
| $css_class_name, $this->comp_ops, $mc); |
| } |
| echo '<input class="',$css_class_name,'" value="',htmlspecialchars(@$m); |
| echo '" type="text" name="'.$this->cgi['prefix']['sys'].'qf'.$k.'"',$size_ml_props; |
| echo ' onkeypress="return '.$this->js['prefix'].'filter_handler(this.form, event);" />'; |
| } else { |
| echo ' '; |
| } |
| echo '</td>',"\n"; |
| } |
| echo '</tr>',"\n"; |
| } |
| } // }}} |
| |
| /* |
| * Display sorting sequence |
| */ |
| if ($qparts['orderby'] && $this->display['sort']) { |
| $css_class_name = $this->getCSSclass('sortinfo'); |
| echo '<tr class="',$css_class_name,'">',"\n"; |
| echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">'; |
| echo '<a class="',$css_class_name,'" href="'; |
| echo htmlspecialchars($this->page_name |
| .'?'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl |
| .'&'.$this->cgi['prefix']['sys'].'fm'.'='.$this->fm |
| .'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn) |
| .$this->qfn.$this->cgi['persist']); |
| echo '">',$this->labels['Clear'],'</a></td>',"\n"; |
| echo '<td class="',$css_class_name,'" colspan="',$this->num_fields_displayed,'">'; |
| echo $this->labels['Sorted By'],': ',join(', ', $sort_fields_w),'</td></tr>',"\n"; |
| } |
| |
| /* |
| * Display the current query |
| */ |
| $text_query = $this->get_SQL_where_from_query_opts(null, true); |
| if ($text_query != '' && $this->display['query']) { |
| $css_class_name = $this->getCSSclass('queryinfo'); |
| echo '<tr class="',$css_class_name,'">',"\n"; |
| echo '<td class="',$css_class_name,'" colspan="',$sys_cols,'">'; |
| echo '<a class="',$css_class_name,'" href="'; |
| echo htmlspecialchars($this->get_server_var('PHP_SELF') |
| .'?'.$this->cgi['prefix']['sys'].'fl'.'='.$this->fl |
| .'&'.$this->cgi['prefix']['sys'].'fm'.'='.$this->fm |
| .'&'.$this->cgi['prefix']['sys'].'qfn'.'='.rawurlencode($this->qfn) |
| .'&'.$this->get_sfn_cgi_vars().$this->cgi['persist']); |
| echo '">',$this->labels['Clear'],'</a></td>',"\n"; |
| echo '<td class="',$css_class_name,'" colspan="',$this->num_fields_displayed,'">'; |
| echo $this->labels['Current Query'],': ',htmlspecialchars($text_query),'</td></tr>',"\n"; |
| } |
| |
| if ($this->nav_text_links() || $this->nav_graphic_links()) { |
| $qstrparts = array(); |
| strlen($this->fl) > 0 && $qstrparts[] = $this->cgi['prefix']['sys'].'fl'.'='.$this->fl; |
| strlen($this->fm) > 0 && $qstrparts[] = $this->cgi['prefix']['sys'].'fm'.'='.$this->fm; |
| count($this->sfn) > 0 && $qstrparts[] = $this->get_sfn_cgi_vars(); |
| strlen($this->cgi['persist']) > 0 && $qstrparts[] = $this->cgi['persist']; |
| $qpview = $qstrparts; |
| $qpcopy = $qstrparts; |
| $qpchange = $qstrparts; |
| $qpdelete = $qstrparts; |
| $qp_prefix = $this->cgi['prefix']['sys'].'operation'.'='.$this->cgi['prefix']['operation']; |
| $qpview[] = $qp_prefix.'View'; |
| $qpcopy[] = $qp_prefix.'Copy'; |
| $qpchange[] = $qp_prefix.'Change'; |
| $qpdelete[] = $qp_prefix.'Delete'; |
| $qpviewStr = htmlspecialchars($this->page_name.'?'.join('&',$qpview).$this->qfn); |
| $qpcopyStr = htmlspecialchars($this->page_name.'?'.join('&',$qpcopy).$this->qfn); |
| $qpchangeStr = htmlspecialchars($this->page_name.'?'.join('&',$qpchange).$this->qfn); |
| $qpdeleteStr = htmlspecialchars($this->page_name.'?'.join('&',$qpdelete).$this->qfn); |
| } |
| |
| $fetched = true; |
| $first = true; |
| $rowCount = 0; |
| while ((!$fetched && ($row = @mysql_fetch_array($res, MYSQL_ASSOC)) != false) |
| || ($fetched && $row != false)) { |
| $fetched = false; |
| echo '<tr class="',$this->getCSSclass('row', null, 'next'),'">',"\n"; |
| if ($sys_cols) { /* {{{ */ |
| $key_rec = $row['qf'.$this->key_num]; |
| $queryAppend = htmlspecialchars('&'.$this->cgi['prefix']['sys'].'rec'.'='.$key_rec); |
| $viewQuery = $qpviewStr . $queryAppend; |
| $copyQuery = $qpcopyStr . $queryAppend; |
| $changeQuery = $qpchangeStr . $queryAppend; |
| $deleteQuery = $qpdeleteStr . $queryAppend; |
| $viewTitle = htmlspecialchars($this->labels['View']); |
| $changeTitle = htmlspecialchars($this->labels['Change']); |
| $copyTitle = htmlspecialchars($this->labels['Copy']); |
| $deleteTitle = htmlspecialchars($this->labels['Delete']); |
| $css_class_name = $this->getCSSclass('navigation', null, true); |
| if ($select_recs) { |
| if (! $this->nav_buttons() || $sys_cols > 1) { |
| echo '<td class="',$css_class_name,'">'; |
| } |
| if ($this->nav_graphic_links()) { |
| $printed_out = false; |
| if ($this->view_enabled()) { |
| $printed_out = true; |
| echo '<a class="',$css_class_name,'" href="',$viewQuery,'"><img class="'; |
| echo $css_class_name,'" src="',$this->url['images']; |
| echo 'pme-view.png" height="15" width="16" border="0" '; |
| echo 'alt="',$viewTitle,'" title="',$viewTitle,'" /></a>'; |
| } |
| if ($this->change_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a class="',$css_class_name,'" href="',$changeQuery,'"><img class="'; |
| echo $css_class_name,'" src="',$this->url['images']; |
| echo 'pme-change.png" height="15" width="16" border="0" '; |
| echo 'alt="',$changeTitle,'" title="',$changeTitle,'" /></a>'; |
| } |
| if ($this->copy_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a class="',$css_class_name,'" href="',$copyQuery,'"><img class="'; |
| echo $css_class_name,'" src="',$this->url['images']; |
| echo 'pme-copy.png" height="15" width="16" border="0" '; |
| echo 'alt="',$copyTitle,'" title="',$copyTitle,'" /></a>'; |
| } |
| if ($this->delete_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a class="',$css_class_name,'" href="',$deleteQuery,'"><img class="'; |
| echo $css_class_name,'" src="',$this->url['images']; |
| echo 'pme-delete.png" height="15" width="16" border="0" '; |
| echo 'alt="',$deleteTitle,'" title="',$deleteTitle,'" /></a>'; |
| } |
| } |
| if ($this->nav_text_links()) { |
| if ($this->nav_graphic_links()) { |
| echo '<br class="',$css_class_name,'">'; |
| } |
| $printed_out = false; |
| if ($this->view_enabled()) { |
| $printed_out = true; |
| echo '<a href="',$viewQuery,'" title="',$viewTitle,'" class="',$css_class_name,'">V</a>'; |
| } |
| if ($this->change_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a href="',$changeQuery,'" title="',$changeTitle,'" class="',$css_class_name,'">C</a>'; |
| } |
| if ($this->copy_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a href="',$copyQuery,'" title="',$copyTitle,'" class="',$css_class_name,'">P</a>'; |
| } |
| if ($this->delete_enabled()) { |
| $printed_out && print(' '); |
| $printed_out = true; |
| echo '<a href="',$deleteQuery,'" title="',$deleteTitle,'" class="',$css_class_name,'">D</a>'; |
| } |
| } |
| if (! $this->nav_buttons() || $sys_cols > 1) { |
| echo '</td>',"\n"; |
| } |
| if ($this->nav_buttons()) { |
| echo '<td class="',$css_class_name,'"><input class="',$css_class_name; |
| echo '" type="radio" name="'.$this->cgi['prefix']['sys'].'rec'; |
| echo '" value="',htmlspecialchars($key_rec),'"'; |
| if (($this->rec == '' && $first) || ($this->rec == $key_rec)) { |
| echo ' checked'; |
| $first = false; |
| } |
| echo ' /></td>',"\n"; |
| } |
| } elseif ($this->filter_enabled()) { |
| echo '<td class="',$css_class_name,'" colspan=',$sys_cols,'> </td>',"\n"; |
| } |
| } /* }}} */ |
| for ($k = 0; $k < $this->num_fds; $k++) { /* {{{ */ |
| $fd = $this->fds[$k]; |
| if (! $this->displayed[$k]) { |
| continue; |
| } |
| $css_postfix = @$this->fdd[$k]['css']['postfix']; |
| $css_class_name = $this->getCSSclass('cell', null, true, $css_postfix); |
| if ($this->password($k)) { |
| echo '<td class="',$css_class_name,'">',$this->labels['hidden'],'</td>',"\n"; |
| continue; |
| } |
| echo '<td class="',$css_class_name,'"',$this->getColAttributes($fd),'>'; |
| echo $this->cellDisplay($k, $row, $css_class_name); |
| echo '</td>',"\n"; |
| } /* }}} */ |
| echo '</tr>',"\n"; |
| } |
| |
| /* |
| * Display and accumulate column aggregation info, do totalling query |
| * XXX this feature does not work yet!!! |
| */ |
| // aggregates listing (if any) |
| if ($$var_to_total) { |
| // do the aggregate query if necessary |
| //if ($vars_to_total) { |
| $qp = array(); |
| $qp['type'] = 'select'; |
| $qp['select'] = $aggr_from_clause; |
| $qp['from'] = $this->get_SQL_join_clause(); |
| $qp['where'] = $this->get_SQL_where_from_query_opts(); |
| $tot_query = $this->get_SQL_query($qp); |
| $totals_result = $this->myquery($tot_query,__LINE__); |
| $tot_row = @mysql_fetch_array($totals_result, MYSQL_ASSOC); |
| //} |
| $qp_aggr = $qp; |
| echo "\n",'<tr class="TODO-class">',"\n",'<td class="TODO-class"> </td>',"\n"; |
| /* |
| echo '<td>'; |
| echo printarray($qp_aggr); |
| echo printarray($vars_to_total); |
| echo '</td>'; |
| echo '<td colspan="'.($this->num_fds-1).'">'.$var_to_total.' '.$$var_to_total.'</td>'; |
| */ |
| // display the results |
| for ($k=0;$k<$this->num_fds;$k++) { |
| $fd = $this->fds[$k]; |
| if (stristr($this->fdd[$fd]['options'],'L') or !isset($this->fdd[$fd]['options'])) { |
| echo '<td>'; |
| $aggr_var = 'qf'.$k.'_aggr'; |
| $$aggr_var = $this->get_sys_cgi_var($aggr_var); |
| if ($$aggr_var) { |
| echo $this->sql_aggrs[$$aggr_var],': ',$tot_row[$aggr_var]; |
| } else { |
| echo ' '; |
| } |
| echo '</td>',"\n"; |
| } |
| } |
| echo '</tr>',"\n"; |
| } |
| echo '</table>',"\n"; // end of table rows listing |
| $this->display_list_table_buttons('down', $listall); |
| $this->form_end(); |
| } /* }}} */ |
| |
| function display_record() /* {{{ */ |
| { |
| // PRE Triggers |
| $ret = true; |
| if ($this->change_operation()) { |
| $ret &= $this->exec_triggers_simple('update', 'pre'); |
| // if PRE update fails, then back to view operation |
| if (! $ret) { |
| $this->operation = $this->labels['View']; |
| $ret = true; |
| } |
| } |
| if ($this->add_operation() || $this->copy_operation()) { |
| $ret &= $this->exec_triggers_simple('insert', 'pre'); |
| } |
| if ($this->view_operation()) { |
| $ret &= $this->exec_triggers_simple('select', 'pre'); |
| } |
| if ($this->delete_operation()) { |
| $ret &= $this->exec_triggers_simple('delete', 'pre'); |
| } |
| // if PRE insert/view/delete fail, then back to the list |
| if ($ret == false) { |
| $this->operation = ''; |
| $this->list_table(); |
| return; |
| } |
| $this->form_begin(); |
| if ($this->cgi['persist'] != '') { |
| echo $this->get_origvars_html($this->cgi['persist']); |
| } |
| echo $this->get_origvars_html($this->get_sfn_cgi_vars()); |
| echo $this->get_origvars_html($this->qfn); |
| echo $this->htmlHiddenSys('cur_tab', $this->dhtml['prefix'].'tab'.$this->cur_tab); |
| echo $this->htmlHiddenSys('qfn', $this->qfn); |
| echo $this->htmlHiddenSys('rec', $this->copy_operation() ? '' : $this->rec); |
| echo $this->htmlHiddenSys('fm', $this->fm); |
| echo $this->htmlHiddenSys('fl', $this->fl); |
| $this->display_record_buttons('up'); |
| if ($this->tabs_enabled()) { |
| echo '<div id="'.$this->dhtml['prefix'].'tab0">',"\n"; |
| } |
| echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n"; |
| if ($this->add_operation()) { |
| $this->display_add_record(); |
| } else { |
| $this->display_copy_change_delete_record(); |
| } |
| echo '</table>',"\n"; |
| if ($this->tabs_enabled()) { |
| echo '</div>',"\n"; |
| } |
| $this->display_record_buttons('down'); |
| |
| $this->form_end(); |
| } /* }}} */ |
| |
| /* |
| * Action functions |
| */ |
| |
| function do_add_record() /* {{{ */ |
| { |
| // Preparing query |
| $query = ''; |
| $key_col_val = ''; |
| $newvals = array(); |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| if ($this->processed($k)) { |
| $fd = $this->fds[$k]; |
| if ($this->readonly($k)) { |
| $fn = (string) @$this->fdd[$k]['default']; |
| } else { |
| $fn = $this->get_data_cgi_var($fd); |
| } |
| if ($fd == $this->key) { |
| $key_col_val = $fn; |
| } |
| $newvals[$fd] = is_array($fn) ? join(',',$fn) : $fn; |
| } |
| } |
| // Creating array of changed keys ($changed) |
| $changed = array_keys($newvals); |
| // Before trigger, newvals can be efectively changed |
| if ($this->exec_triggers('insert', 'before', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| // Real query (no additional query in this method) |
| foreach ($newvals as $fd => $val) { |
| if ($fd == '') continue; |
| if ($this->col_has_sqlw($this->fdn[$fd])) { |
| $val_as = addslashes($val); |
| $val_qas = '"'.addslashes($val).'"'; |
| $value = $this->substituteVars( |
| $this->fdd[$this->fdn[$fd]]['sqlw'], array( |
| 'val_qas' => $val_qas, |
| 'val_as' => $val_as, |
| 'val' => $val |
| )); |
| } else { |
| $value = "'".addslashes($val)."'"; |
| } |
| if ($query == '') { |
| $query = 'INSERT INTO `'.$this->tb.'` (`'.$fd.'`'; // ) |
| $query2 = ') VALUES ('.$value.''; |
| } else { |
| $query .= ', `'.$fd.'`'; |
| $query2 .= ', '.$value.''; |
| } |
| } |
| $query .= $query2.')'; |
| $res = $this->myquery($query, __LINE__); |
| $this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record added']; |
| if (! $res) { |
| return false; |
| } |
| $this->rec = mysql_insert_id($this->dbh); |
| // Notify list |
| if (@$this->notify['insert'] || @$this->notify['all']) { |
| $this->email_notify(false, $newvals); |
| } |
| // Note change in log table |
| if ($this->logtable) { |
| $query = sprintf('INSERT INTO %s' |
| .' (updated, user, host, operation, tab, rowkey, col, oldval, newval)' |
| .' VALUES (NOW(), "%s", "%s", "insert", "%s", "%s", "", "", "%s")', |
| $this->logtable, addslashes($this->get_server_var('REMOTE_USER')), |
| addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb), |
| addslashes($key_col_val), addslashes(serialize($newvals))); |
| $this->myquery($query, __LINE__); |
| } |
| // After trigger |
| if ($this->exec_triggers('insert', 'after', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| return true; |
| } /* }}} */ |
| |
| function do_change_record() /* {{{ */ |
| { |
| // Preparing queries |
| $query_real = ''; |
| $query_oldrec = ''; |
| $newvals = array(); |
| $oldvals = array(); |
| $changed = array(); |
| // Prepare query to retrieve oldvals |
| for ($k = 0; $k < $this->num_fds; $k++) { |
| if ($this->processed($k) && !$this->readonly($k)) { |
| $fd = $this->fds[$k]; |
| $fn = $this->get_data_cgi_var($fd); |
| $newvals[$this->fds[$k]] = is_array($fn) ? join(',',$fn) : $fn; |
| if ($query_oldrec == '') { |
| $query_oldrec = 'SELECT '.$fd; |
| } else { |
| $query_oldrec .= ','.$fd; |
| } |
| } |
| } |
| $where_part = " WHERE (".$this->key.'='.$this->key_delim.$this->rec.$this->key_delim.')'; |
| $query_newrec = $query_oldrec.' FROM ' . $this->tb; |
| $query_oldrec .= ' FROM ' . $this->tb . $where_part; |
| // Additional query (must go before real query) |
| $res = $this->myquery($query_oldrec, __LINE__); |
| $oldvals = @mysql_fetch_array($res, MYSQL_ASSOC); |
| @mysql_free_result($res); |
| // Creating array of changed keys ($changed) |
| foreach ($newvals as $fd => $value) { |
| if ($value != $oldvals[$fd]) |
| $changed[] = $fd; |
| } |
| // Before trigger |
| if ($this->exec_triggers('update', 'before', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| // Build the real query respecting changes to the newvals array |
| foreach ($newvals as $fd => $val) { |
| if ($fd == '') continue; |
| if ($this->col_has_sqlw($this->fdn[$fd])) { |
| $val_as = addslashes($val); |
| $val_qas = '"'.addslashes($val).'"'; |
| $value = $this->substituteVars( |
| $this->fdd[$this->fdn[$fd]]['sqlw'], array( |
| 'val_qas' => $val_qas, |
| 'val_as' => $val_as, |
| 'val' => $val |
| )); |
| } else { |
| $value = "'".addslashes($val)."'"; |
| } |
| if ($query_real == '') { |
| $query_real = 'UPDATE '.$this->tb.' SET '.$fd.'='.$value; |
| } else { |
| $query_real .= ','.$fd.'='.$value; |
| } |
| } |
| $query_real .= $where_part; |
| // Real query |
| $res = $this->myquery($query_real, __LINE__); |
| $this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record changed']; |
| if (! $res) { |
| return false; |
| } |
| // Another additional query (must go after real query) |
| if (in_array($this->key, $changed)) { |
| $this->rec = $newvals[$this->key]; // key has changed |
| } |
| $query_newrec .= ' WHERE ('.$this->key.'='.$this->key_delim.$this->rec.$this->key_delim.')'; |
| $res = $this->myquery($query_newrec, __LINE__); |
| $newvals = @mysql_fetch_array($res, MYSQL_ASSOC); |
| @mysql_free_result($res); |
| // Creating array of changed keys ($changed) |
| $changed = array(); |
| foreach ($newvals as $fd => $value) { |
| if ($value != $oldvals[$fd]) |
| $changed[] = $fd; |
| } |
| // Notify list |
| if (@$this->notify['update'] || @$this->notify['all']) { |
| if (count($changed) > 0) { |
| $this->email_notify($oldvals, $newvals); |
| } |
| } |
| // Note change in log table |
| if ($this->logtable) { |
| foreach ($changed as $key) { |
| $qry = sprintf('INSERT INTO %s' |
| .' (updated, user, host, operation, tab, rowkey, col, oldval, newval)' |
| .' VALUES (NOW(), "%s", "%s", "update", "%s", "%s", "%s", "%s", "%s")', |
| $this->logtable, addslashes($this->get_server_var('REMOTE_USER')), |
| addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb), |
| addslashes($this->rec), addslashes($key), |
| addslashes($oldvals[$key]), addslashes($newvals[$key])); |
| $this->myquery($qry, __LINE__); |
| } |
| } |
| // After trigger |
| if ($this->exec_triggers('update', 'after', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| return true; |
| } /* }}} */ |
| |
| function do_delete_record() /* {{{ */ |
| { |
| // Additional query |
| $query = 'SELECT * FROM '.$this->tb.' WHERE ('.$this->key.' = ' |
| .$this->key_delim.$this->rec.$this->key_delim.')'; // ) |
| $res = $this->myquery($query, __LINE__); |
| $oldvals = @mysql_fetch_array($res, MYSQL_ASSOC); |
| @mysql_free_result($res); |
| // Creating array of changed keys ($changed) |
| $changed = array_keys($oldvals); |
| $newvals = array(); |
| // Before trigger |
| if ($this->exec_triggers('delete', 'before', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| // Real query |
| $query = 'DELETE FROM '.$this->tb.' WHERE ('.$this->key.' = ' |
| .$this->key_delim.$this->rec.$this->key_delim.')'; // ) |
| $res = $this->myquery($query, __LINE__); |
| $this->message = @mysql_affected_rows($this->dbh).' '.$this->labels['record deleted']; |
| if (! $res) { |
| return false; |
| } |
| // Notify list |
| if (@$this->notify['delete'] || @$this->notify['all']) { |
| $this->email_notify($oldvals, false); |
| } |
| // Note change in log table |
| if ($this->logtable) { |
| $query = sprintf('INSERT INTO %s' |
| .' (updated, user, host, operation, tab, rowkey, col, oldval, newval)' |
| .' VALUES (NOW(), "%s", "%s", "delete", "%s", "%s", "%s", "%s", "")', |
| $this->logtable, addslashes($this->get_server_var('REMOTE_USER')), |
| addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb), |
| addslashes($this->rec), addslashes($key), addslashes(serialize($oldvals))); |
| $this->myquery($query, __LINE__); |
| } |
| // After trigger |
| if ($this->exec_triggers('delete', 'after', $oldvals, $changed, $newvals) == false) { |
| return false; |
| } |
| return true; |
| } /* }}} */ |
| |
| function email_notify($old_vals, $new_vals) /* {{{ */ |
| { |
| if (! function_exists('mail')) { |
| return false; |
| } |
| if ($old_vals != false && $new_vals != false) { |
| $action = 'update'; |
| $subject = 'Record updated in'; |
| $body = 'An item with '.$this->fdd[$this->key]['name'].' = ' |
| .$this->key_delim.$this->rec.$this->key_delim .' was updated in'; |
| $vals = $new_vals; |
| } elseif ($new_vals != false) { |
| $action = 'insert'; |
| $subject = 'Record added to'; |
| $body = 'A new item was added into'; |
| $vals = $new_vals; |
| } elseif ($old_vals != false) { |
| $action = 'delete'; |
| $subject = 'Record deleted from'; |
| $body = 'An item was deleted from'; |
| $vals = $old_vals; |
| } else { |
| return false; |
| } |
| $addr = $this->get_server_var('REMOTE_ADDR'); |
| $user = $this->get_server_var('REMOTE_USER'); |
| $body = 'This notification e-mail was automatically generated by phpMyEdit.'."\n\n".$body; |
| $body .= ' table '.$this->tb.' in MySQL database '.$this->db.' on '.$this->page_name; |
| $body .= ' by '.($user == '' ? 'unknown user' : "user $user").' from '.$addr; |
| $body .= ' at '.date('d/M/Y H:i').' with the following fields:'."\n\n"; |
| $i = 1; |
| foreach ($vals as $k => $text) { |
| $name = isset($this->fdd[$k]['name~']) |
| ? $this->fdd[$k]['name~'] : $this->fdd[$k]['name']; |
| if ($action == 'update') { |
| if ($old_vals[$k] == $new_vals[$k]) { |
| continue; |
| } |
| $body .= sprintf("[%02s] %s (%s)\n WAS: %s\n IS: %s\n", |
| $i, $name, $k, $old_vals[$k], $new_vals[$k]); |
| } else { |
| $body .= sprintf('[%02s] %s (%s): %s'."\n", $i, $name, $k, $text); |
| } |
| $i++; |
| } |
| $body .= "\n--\r\n"; // \r is needed for signature separating |
| $body .= "phpMyEdit\ninstant MySQL table editor and code generator\n"; |
| $body .= "http://platon.sk/projects/phpMyEdit/\n\n"; |
| $subject = @$this->notify['prefix'].$subject.' '.$this->dbp.$this->tb; |
| $subject = trim($subject); // just for sure |
| $wrap_w = intval(@$this->notify['wrap']); |
| $wrap_w > 0 || $wrap_w = 72; |
| $from = (string) @$this->notify['from']; |
| $from != '' || $from = 'webmaster@'.strtolower($this->get_server_var('SERVER_NAME')); |
| $headers = 'From: '.$from."\n".'X-Mailer: PHP/'.phpversion().' (phpMyEdit)'; |
| $body = wordwrap($body, $wrap_w, "\n", 1); |
| $emails = (array) $this->notify[$action] + (array) $this->notify['all']; |
| foreach ($emails as $email) { |
| if (! empty($email)) { |
| mail(trim($email), $subject, $body, $headers); |
| } |
| } |
| return true; |
| } /* }}} */ |
| |
| /* |
| * Apply triggers function |
| * Run a (set of) trigger(s). $trigger can be an Array or a filename |
| * Break and return false as soon as a trigger return false |
| * we need a reference on $newvals to be able to change value before insert/update |
| */ |
| function exec_triggers($op, $step, $oldvals, &$changed, &$newvals) /* {{{ */ |
| { |
| if (! isset($this->triggers[$op][$step])) { |
| return true; |
| } |
| $ret = true; |
| $trig = $this->triggers[$op][$step]; |
| if (is_array($trig)) { |
| ksort($trig); |
| for ($t = reset($trig); $t !== false && $ret != false; $t = next($trig)) { |
| $ret = include($t); |
| } |
| } else { |
| $ret = include($trig); |
| } |
| return $ret; |
| } /* }}} */ |
| |
| function exec_triggers_simple($op, $step) /* {{{ */ |
| { |
| $oldvals = $newvals = $changed = array(); |
| return $this->exec_triggers($op, $step, $oldvals, $changed, $newvals); |
| } /* }}} */ |
| |
| /* |
| * Recreate functions |
| */ |
| function recreate_fdd($default_page_type = 'L') /* {{{ */ |
| { |
| // TODO: one level deeper browsing |
| $this->page_type = $default_page_type; |
| $this->filter_operation() && $this->page_type = 'F'; |
| $this->view_operation() && $this->page_type = 'V'; |
| if ($this->add_operation() |
| || $this->saveadd == $this->labels['Save'] |
| || $this->moreadd == $this->labels['More']) { |
| $this->page_type = 'A'; |
| } |
| if ($this->change_operation() |
| || $this->savechange == $this->labels['Save'] |
| || $this->morechange == $this->labels['Apply']) { |
| $this->page_type = 'C'; |
| } |
| if ($this->copy_operation() || $this->savecopy == $this->labels['Save']) { |
| $this->page_type = 'P'; |
| } |
| if ($this->delete_operation() || $this->savedelete == $this->labels['Delete']) { |
| $this->page_type = 'D'; |
| } |
| // Restore backups (if exists) |
| foreach (array_keys($this->fdd) as $column) { |
| foreach (array_keys($this->fdd[$column]) as $col_option) { |
| if ($col_option[strlen($col_option) - 1] != '~') |
| continue; |
| |
| $this->fdd[$column][substr($col_option, 0, strlen($col_option) - 1)] |
| = $this->fdd[$column][$col_option]; |
| unset($this->fdd[$column][$col_option]); |
| } |
| } |
| foreach (array_keys($this->fdd) as $column) { |
| foreach (array_keys($this->fdd[$column]) as $col_option) { |
| if (! strchr($col_option, '|')) { |
| continue; |
| } |
| $col_ar = explode('|', $col_option, 2); |
| if (! stristr($col_ar[1], $this->page_type)) { |
| continue; |
| } |
| // Make field backups |
| $this->fdd[$column][$col_ar[0] .'~'] = $this->fdd[$column][$col_ar[0]]; |
| $this->fdd[$column][$col_option.'~'] = $this->fdd[$column][$col_option]; |
| // Set particular field |
| $this->fdd[$column][$col_ar[0]] = $this->fdd[$column][$col_option]; |
| unset($this->fdd[$column][$col_option]); |
| } |
| } |
| } /* }}} */ |
| |
| function recreate_displayed() /* {{{ */ |
| { |
| $field_num = 0; |
| $num_fields_displayed = 0; |
| $this->fds = array(); |
| $this->fdn = array(); |
| $this->displayed = array(); |
| $this->guidance = false; |
| foreach (array_keys($this->fdd) as $key) { |
| if (preg_match('/^\d+$/', $key)) { // skipping numeric keys |
| continue; |
| } |
| $this->fds[$field_num] = $key; |
| $this->fdn[$key] = $field_num; |
| /* We must use here displayed() function, because displayed[] array |
| is not created yet. We will simultaneously create that array as well. */ |
| if ($this->displayed[$field_num] = $this->displayed($field_num)) { |
| $num_fields_displayed++; |
| } |
| if (is_array(@$this->fdd[$key]['values']) && ! isset($this->fdd[$key]['values']['table'])) { |
| foreach ($this->fdd[$key]['values'] as $val) { |
| $this->fdd[$key]['values2'][$val] = $val; |
| } |
| unset($this->fdd[$key]['values']); |
| } |
| isset($this->fdd[$key]['help']) && $this->guidance = true; |
| $this->fdd[$field_num] = $this->fdd[$key]; |
| $field_num++; |
| } |
| $this->num_fds = $field_num; |
| $this->num_fields_displayed = $num_fields_displayed; |
| $this->key_num = array_search($this->key, $this->fds); |
| /* Adds first displayed column into sorting fields by replacing last |
| array entry. Also remove duplicite values and change column names to |
| their particular field numbers. |
| |
| Note that entries like [0]=>'9' [1]=>'-9' are correct and they will |
| have desirable sorting behaviour. So there is no need to remove them. |
| */ |
| $this->sfn = array_unique($this->sfn); |
| $check_ar = array(); |
| foreach ($this->sfn as $key => $val) { |
| if (preg_match('/^[-]?\d+$/', $val)) { // skipping numeric keys |
| $val = abs($val); |
| if (in_array($val, $check_ar) || $this->password($val)) { |
| unset($this->sfn[$key]); |
| } else { |
| $check_ar[] = $val; |
| } |
| continue; |
| } |
| if ($val[0] == '-') { |
| $val = substr($val, 1); |
| $minus = '-'; |
| } else { |
| $minus = ''; |
| } |
| if (($val = array_search($val, $this->fds)) === false || $this->password($val)) { |
| unset($this->sfn[$key]); |
| } else { |
| $val = intval($val); |
| if (in_array($val, $check_ar)) { |
| unset($this->sfn[$key]); |
| } else { |
| $this->sfn[$key] = $minus.$val; |
| $check_ar[] = $val; |
| } |
| } |
| } |
| $this->sfn = array_unique($this->sfn); |
| return true; |
| } /* }}} */ |
| |
| function backward_compatibility() /* {{{ */ |
| { |
| foreach (array_keys($this->fdd) as $column) { |
| // move ['required'] to ['js']['required'] |
| if (! isset($this->fdd[$column]['js']['required']) && isset($this->fdd[$column]['required'])) { |
| $this->fdd[$column]['js']['required'] = $this->fdd[$column]['required']; |
| } |
| // move 'HWR' flags from ['options'] into ['input'] |
| if (isset($this->fdd[$column]['options'])) { |
| stristr($this->fdd[$column]['options'], 'H') && $this->fdd[$column]['input'] .= 'H'; |
| stristr($this->fdd[$column]['options'], 'W') && $this->fdd[$column]['input'] .= 'W'; |
| stristr($this->fdd[$column]['options'], 'R') && $this->fdd[$column]['input'] .= 'R'; |
| } |
| } |
| } /* }}} */ |
| |
| /* |
| * Error handling function |
| */ |
| function error($message, $additional_info = '') /* {{{ */ |
| { |
| echo '<h1>phpMyEdit error: ',htmlspecialchars($message),'</h1>',"\n"; |
| if ($additional_info != '') { |
| echo '<hr />',htmlspecialchars($additional_info); |
| } |
| return false; |
| } /* }}} */ |
| |
| /* |
| * Database connection function |
| */ |
| function connect() /* {{{ */ |
| { |
| if (isset($this->dbh)) { |
| return true; |
| } |
| if (!isset($this->db)) { |
| $this->error('no database defined'); |
| return false; |
| } |
| if (!isset ($this->tb)) { |
| $this->error('no table defined'); |
| return false; |
| } |
| $this->dbh = @ini_get('allow_persistent') |
| ? @mysql_pconnect($this->hn, $this->un, $this->pw) |
| : @mysql_connect($this->hn, $this->un, $this->pw); |
| if (!$this->dbh) { |
| $this->error('could not connect to MySQL'); |
| return false; |
| } |
| return true; |
| } /* }}} */ |
| |
| /* |
| * Database disconnection function |
| */ |
| function disconnect() /* {{{ */ |
| { |
| if ($this->close_dbh) { |
| @mysql_close($this->dbh); |
| $this->dbh = null; |
| } |
| } /* }}} */ |
| |
| /* |
| * The workhorse |
| */ |
| function execute() /* {{{ */ |
| { |
| // DEBUG - uncomment to enable |
| /* |
| //phpinfo(); |
| $this->print_get_vars(); |
| $this->print_post_vars(); |
| $this->print_vars(); |
| echo "<pre>query opts:\n"; |
| echo print_r($this->query_opts); |
| echo "</pre>\n"; |
| echo "<pre>get vars:\n"; |
| echo print_r($this->get_opts); |
| echo "</pre>\n"; |
| */ |
| |
| // Let's do explicit quoting - it's safer |
| set_magic_quotes_runtime(0); |
| // Checking if language file inclusion was successful |
| if (! is_array($this->labels)) { |
| $this->error('could not locate language files', 'searched path: '.$this->dir['lang']); |
| return false; |
| } |
| // Database connection |
| if ($this->connect() == false) { |
| return false; |
| } |
| |
| /* |
| * ====================================================================== |
| * Pass 3: process any updates generated if the user has selected |
| * a save or cancel button during Pass 2 |
| * ====================================================================== |
| */ |
| // Cancel button - Cancel Triggers |
| if ($this->add_canceled() || $this->copy_canceled()) { |
| $this->exec_triggers_simple('insert', 'cancel'); |
| } |
| if ($this->view_canceled()) { |
| $this->exec_triggers_simple('select', 'cancel'); |
| } |
| if ($this->change_canceled()) { |
| $this->exec_triggers_simple('update', 'cancel'); |
| } |
| if ($this->delete_canceled()) { |
| $this->exec_triggers_simple('delete', 'cancel'); |
| } |
| // Save/More Button - database operations |
| if ($this->saveadd == $this->labels['Save'] || $this->savecopy == $this->labels['Save']) { |
| $this->add_enabled() && $this->do_add_record(); |
| unset($this->saveadd); |
| unset($this->savecopy); |
| $this->recreate_fdd(); |
| } |
| elseif ($this->moreadd == $this->labels['More']) { |
| $this->add_enabled() && $this->do_add_record(); |
| $this->operation = $this->labels['Add']; // to force add operation |
| $this->recreate_fdd(); |
| $this->recreate_displayed(); |
| $this->backward_compatibility(); |
| } |
| elseif ($this->savechange == $this->labels['Save']) { |
| $this->change_enabled() && $this->do_change_record(); |
| unset($this->savechange); |
| $this->recreate_fdd(); |
| } |
| elseif ($this->morechange == $this->labels['Apply']) { |
| $this->change_enabled() && $this->do_change_record(); |
| $this->operation = $this->labels['Change']; // to force change operation |
| $this->recreate_fdd(); |
| $this->recreate_displayed(); |
| $this->backward_compatibility(); |
| } |
| elseif ($this->savedelete == $this->labels['Delete']) { |
| $this->delete_enabled() && $this->do_delete_record(); |
| unset($this->savedelete); |
| $this->recreate_fdd(); |
| } |
| |
| /* |
| * ====================================================================== |
| * Pass 2: display an input/edit/confirmation screen if the user has |
| * selected an editing button on Pass 1 through this page |
| * ====================================================================== |
| */ |
| if ($this->add_operation() |
| || $this->change_operation() || $this->delete_operation() |
| || $this->view_operation() || $this->copy_operation()) { |
| $this->display_record(); |
| } |
| |
| /* |
| * ====================================================================== |
| * Pass 1 and Pass 3: display the MySQL table in a scrolling window on |
| * the screen (skip this step in 'Add More' mode) |
| * ====================================================================== |
| */ |
| else { |
| $this->list_table(); |
| } |
| |
| $this->disconnect(); |
| if ($this->display['time'] && $this->timer != null) { |
| echo $this->timer->end(),' miliseconds'; |
| } |
| } /* }}} */ |
| |
| /* |
| * Class constructor |
| */ |
| function phpMyEdit($opts) /* {{{ */ |
| { |
| // Set desirable error reporting level |
| $error_reporting = error_reporting(E_ALL & ~E_NOTICE); |
| // Database handle variables |
| if (isset($opts['dbh'])) { |
| $this->close_dbh = false; |
| $this->dbh = $opts['dbh']; |
| $this->dbp = ''; |
| } else { |
| $this->close_dbh = true; |
| $this->dbh = null; |
| $this->dbp = $opts['db'].'.'; |
| $this->hn = $opts['hn']; |
| $this->un = $opts['un']; |
| $this->pw = $opts['pw']; |
| $this->db = $opts['db']; |
| } |
| $this->tb = $opts['tb']; |
| // Other variables |
| $this->key = $opts['key']; |
| $this->key_type = $opts['key_type']; |
| $this->inc = $opts['inc']; |
| $this->options = $opts['options']; |
| $this->fdd = $opts['fdd']; |
| $this->multiple = intval($opts['multiple']); |
| $this->multiple <= 0 && $this->multiple = 2; |
| $this->filters = @$opts['filters']; |
| $this->triggers = @$opts['triggers']; |
| $this->notify = @$opts['notify']; |
| $this->logtable = @$opts['logtable']; |
| $this->page_name = @$opts['page_name']; |
| if (! isset($this->page_name)) { |
| $this->page_name = basename($this->get_server_var('PHP_SELF')); |
| isset($this->page_name) || $this->page_name = $this->tb; |
| } |
| $this->display['query'] = @$opts['display']['query']; |
| $this->display['sort'] = @$opts['display']['sort']; |
| $this->display['time'] = @$opts['display']['time']; |
| if ($this->display['time']) { |
| $this->timer = new phpMyEdit_timer(); |
| } |
| $this->display['tabs'] = isset($opts['display']['tabs']) |
| ? $opts['display']['tabs'] : true; |
| $this->display['form'] = isset($opts['display']['form']) |
| ? $opts['display']['form'] : true; |
| $this->display['num_records'] = isset($opts['display']['num_records']) |
| ? $opts['display']['num_records'] : true; |
| $this->display['num_pages'] = isset($opts['display']['num_pages']) |
| ? $opts['display']['num_pages'] : true; |
| // Creating directory variables |
| $this->dir['root'] = dirname(realpath(__FILE__)) |
| . (strlen(dirname(realpath(__FILE__))) > 0 ? '/' : ''); |
| $this->dir['lang'] = $this->dir['root'].'lang/'; |
| // Creating URL variables |
| $this->url['images'] = 'images/'; |
| isset($opts['url']['images']) && $this->url['images'] = $opts['url']['images']; |
| // CSS classes policy |
| $this->css = @$opts['css']; |
| !isset($this->css['separator']) && $this->css['separator'] = '-'; |
| !isset($this->css['prefix']) && $this->css['prefix'] = 'pme'; |
| !isset($this->css['page_type']) && $this->css['page_type'] = false; |
| !isset($this->css['position']) && $this->css['position'] = false; |
| !isset($this->css['divider']) && $this->css['divider'] = 2; |
| $this->css['divider'] = intval(@$this->css['divider']); |
| // JS overall configuration |
| $this->js = @$opts['js']; |
| !isset($this->js['prefix']) && $this->js['prefix'] = 'PME_js_'; |
| // DHTML overall configuration |
| $this->dhtml = @$opts['dhtml']; |
| !isset($this->dhtml['prefix']) && $this->dhtml['prefix'] = 'PME_dhtml_'; |
| // Navigation |
| $this->navigation = @$opts['navigation']; |
| if (! $this->nav_buttons() && ! $this->nav_text_links() && ! $this->nav_graphic_links()) { |
| $this->navigation .= 'B'; // buttons are default |
| } |
| if (! $this->nav_up() && ! $this->nav_down()) { |
| $this->navigation .= 'D'; // down position is default |
| } |
| $this->buttons = $opts['buttons']; |
| // Language labels (must go after navigation) |
| $this->labels = $this->make_language_labels(isset($opts['language']) |
| ? $opts['language'] : $this->get_server_var('HTTP_ACCEPT_LANGUAGE')); |
| // CGI variables |
| $this->cgi = @$opts['cgi']; |
| $this->cgi['persist'] = ''; |
| if (@is_array($opts['cgi']['persist'])) { |
| foreach ($opts['cgi']['persist'] as $key => $val) { |
| if (is_array($val)) { |
| foreach($val as $key2 => $val2) { |
| $this->cgi['persist'] .= '&'.rawurlencode($key) |
| .'['.rawurlencode($key2).']='.rawurlencode($val2); |
| } |
| } else { |
| $this->cgi['persist'] .= '&'.rawurlencode($key).'='.rawurlencode($val); |
| } |
| } |
| } |
| foreach (array('operation', 'sys', 'data') as $type) { |
| if (! isset($this->cgi['prefix'][$type])) { |
| $this->cgi['prefix'][$type] = $this->get_default_cgi_prefix($type); |
| } |
| } |
| // Sorting variables |
| $this->sfn = $this->get_sys_cgi_var('sfn'); |
| isset($this->sfn) || $this->sfn = array(); |
| is_array($this->sfn) || $this->sfn = array($this->sfn); |
| isset($opts['sort_field']) || $opts['sort_field'] = array(); |
| is_array($opts['sort_field']) || $opts['sort_field'] = array($opts['sort_field']); |
| $this->sfn = array_merge($this->sfn, $opts['sort_field']); |
| // Form variables all around |
| $this->fl = intval($this->get_sys_cgi_var('fl')); |
| $this->fm = intval($this->get_sys_cgi_var('fm')); |
| // $old_page = ceil($this->fm / abs($this->inc)) + 1; |
| $this->qfn = $this->get_sys_cgi_var('qfn'); |
| $this->sw = $this->get_sys_cgi_var('sw'); |
| $this->rec = $this->get_sys_cgi_var('rec', ''); |
| $this->navop = $this->get_sys_cgi_var('navop'); |
| $navfmup = $this->get_sys_cgi_var('navfmup'); |
| $navfmdown = $this->get_sys_cgi_var('navfmdown'); |
| $navpnup = $this->get_sys_cgi_var('navpnup'); |
| $navpndown = $this->get_sys_cgi_var('navpndown'); |
| if($navfmdown!=NULL && $navfmdown != $this->fm) $this->navfm = $navfmdown; |
| elseif($navfmup!=NULL && $navfmup != $this->fm) $this->navfm = $navfmup; |
| elseif($navpndown!=NULL && ($navpndown-1)*$this->inc != $this->fm) $this->navfm = ($navpndown-1)*$this->inc; |
| elseif($navpnup!=NULL && ($navpnup-1)*$this->inc != $this->fm) $this->navfm = ($navpnup-1)*$this->inc; |
| else $this->navfm = $this->fm; |
| $this->operation = $this->get_sys_cgi_var('operation'); |
| $oper_prefix_len = strlen($this->cgi['prefix']['operation']); |
| if (! strncmp($this->cgi['prefix']['operation'], $this->operation, $oper_prefix_len)) { |
| $this->operation = $this->labels[substr($this->operation, $oper_prefix_len)]; |
| } |
| $this->saveadd = $this->get_sys_cgi_var('saveadd'); |
| $this->moreadd = $this->get_sys_cgi_var('moreadd'); |
| $this->canceladd = $this->get_sys_cgi_var('canceladd'); |
| $this->savechange = $this->get_sys_cgi_var('savechange'); |
| $this->morechange = $this->get_sys_cgi_var('morechange'); |
| $this->cancelchange = $this->get_sys_cgi_var('cancelchange'); |
| $this->savecopy = $this->get_sys_cgi_var('savecopy'); |
| $this->cancelcopy = $this->get_sys_cgi_var('cancelcopy'); |
| $this->savedelete = $this->get_sys_cgi_var('savedelete'); |
| $this->canceldelete = $this->get_sys_cgi_var('canceldelete'); |
| $this->cancelview = $this->get_sys_cgi_var('cancelview'); |
| // Filter setting |
| if (isset($this->sw)) { |
| $this->sw == $this->labels['Search'] && $this->fl = 1; |
| $this->sw == $this->labels['Hide'] && $this->fl = 0; |
| //$this->sw == $this->labels['Clear'] && $this->fl = 0; |
| } |
| // TAB names |
| $this->tabs = array(); |
| // Setting key_delim according to key_type |
| if ($this->key_type == 'real') { |
| /* If 'real' key_type does not work, |
| try change MySQL datatype from float to double */ |
| $this->rec = doubleval($this->rec); |
| $this->key_delim = ''; |
| } elseif ($this->key_type == 'int') { |
| $this->rec = intval($this->rec); |
| $this->key_delim = ''; |
| } else { |
| $this->key_delim = '"'; |
| // $this->rec remains unmodified |
| } |
| // Specific $fdd modifications depending on performed action |
| $this->recreate_fdd(); |
| // Extract SQL Field Names and number of fields |
| $this->recreate_displayed(); |
| // Issue backward compatibility |
| $this->backward_compatibility(); |
| // Gathering query options |
| $this->gather_query_opts(); |
| // Call to action |
| !isset($opts['execute']) && $opts['execute'] = 1; |
| $opts['execute'] && $this->execute(); |
| // Restore original error reporting level |
| error_reporting($error_reporting); |
| } /* }}} */ |
| |
| } |
| |
| /* Modeline for ViM {{{ |
| * vim:set ts=4: |
| * vim600:fdm=marker fdl=0 fdc=0: |
| * }}} */ |
| |
| ?> |