* @version 1.1 * @package tableeditor */ // Version 2006-04-21 // Version 2006-05-04 // Version 2006-05-07 // Version 2006-06-08 - add filtering capabilities to the display // Version 2006-06-16 - add file uploads setUploadPath() and fieldname='filename' // Version 2006-07-21 - add ability to autodetect options for enum() fields, and show them as a '; // check for any defaults if (count($this->fieldDefaults)) { foreach ($this->fieldDefaults as $f => $n) $editdata[$f] = $n; } } else if ($action == 'edit') { echo '

' . i18n('Edit %1', array($this->recordType)) . '

'; echo ''; echo ""; if ($this->classname) $data = new $this->classname($_GET['edit']); if (method_exists($data, 'tableEditorLoad')) { $editdata = $data->tableEditorLoad(); } else { $editdata = $this->defaultLoad(); } } echo ''; echo ''; foreach ($this->editfields as $f => $n) { $pos = strpos($n, '|'); $n2 = ''; if ($pos != false) { $n2 = i18n(substr($n, $pos + 1)) . ' '; $n = substr($n, 0, $pos); } echo ''; } echo ''; echo '

' . i18n($n) . "

$n2"; /* * If we know the input type, assume the user knows what they are doing, else, * try to query it from the databse */ if (isset($this->fieldInputType[$f])) { $inputtype = $this->fieldInputType[$f]; $inputmaxlen = 0; // FIXME $inputsize = 0; // FIXME } else { list($inputtype, $inputmaxlen, $inputsize) = $this->getFieldType($f); } switch ($inputtype) { case 'text': if ($this->fieldInputOptions[$f]) echo 'fieldInputOptions[$f] . " id=\"$f\" name=\"$f\" value=\"" . htmlspecialchars($editdata[$f]) . '"/>'; else echo "'; break; case 'textarea': $maxlen = ($inputmaxlen > 0) ? " onkeypress=\"return do_maxlength(this, $inputmaxlen);\" " : ''; if ($this->fieldInputOptions[$f]) echo "'; else echo "'; break; case 'select': if ($this->fieldInputOptions[$f]) echo ''; echo '\n"; foreach ($this->fieldOptions[$f] as $opt) { if (is_array($opt)) { if ("{$opt['key']}" == "{$editdata[$f]}") $sel = 'selected="selected"'; else $sel = ''; echo "\n"; } else { if ("{$opt}" == "{$editdata[$f]}") $sel = 'selected="selected"'; else $sel = ''; echo "\n"; } } echo ''; break; case 'enum': break; case 'select_or_text': $optq = $pdo->prepare("SELECT DISTINCT($f) AS $f FROM `{$this->table}` ORDER BY $f"); $optq->execute(); if ($this->fieldInputOptions[$f]) echo ''; echo '\n"; if ($this->fieldOptions[$f]) { foreach ($this->fieldOptions[$f] as $opt) { if ($opt == $editdata[$f]) $sel = 'selected="selected"'; else $sel = ''; echo "\n"; } echo ''; } // print_r($this->fieldOptions[$f]); while ($opt = $optq->fetch(PDO::FETCH_OBJ)) { if (is_array($this->fieldOptions[$f]) && in_array($opt->$f, $this->fieldOptions[$f])) continue; if ($opt->$f == $editdata[$f]) $sel = 'selected="selected"'; else $sel = ''; echo "\n"; } echo ''; echo ' or '; // only show the input half-sized because its beside the select box which is already taking up space. $inputsize = round($inputsize / 2); // input always starts emptpy as well, because we already have it selected in the list if ($this->fieldInputOptions[$f]) echo 'fieldInputOptions[$f] . ' id="' . $f . '_text" name="' . $f . '_text" value="" />'; else echo "'; break; case 'multicheck': $ks = array_keys($this->fieldOptions[$f]); foreach ($ks as $k) { $ch = ''; if (is_array($editdata[$f])) { if (array_key_exists($k, $editdata[$f])) { $ch = ' checked=checked '; } } echo " {$this->fieldOptions[$f][$k]}
"; } echo ""; break; case 'date': case 'datetime': $a = preg_split('/[- :]/', $editdata[$f]); if ($inputtype == 'date') { list($yy, $mm, $dd) = $a; $w = 10; } else { list($yy, $mm, $dd, $hh, $mi, $ss) = $a; $w = 15; } // if we put a small width here, then it prevents it from expanding to whatever width it feels like. echo ""; echo ''; if ($inputtype == 'date') { echo ''; echo '

'; $this->month_selector($f . '_month', $mm); echo '

'; $this->day_selector($f . '_day', $dd); echo '

'; $this->year_selector($f . '_year', $yy); echo '

'; echo ""; break; } /* Else, fall through, with hh, mi, ss already set */ case 'time': if ($inputtype == 'time') { list($hh, $mi, $ss) = explode(':', $editdata[$f]); echo ''; echo ''; } /* Common code for time, and datetime */ echo ''; echo '

'; $this->hour_selector($f . '_hour', $hh, false, '12hr'); echo '

'; $this->minute_selector($f . '_minute', $mi); echo '

'; echo ""; break; case 'file': if ($editdata[$f]) { if (file_exists($this->uploadPath . '/' . $editdata[$f])) { // only show a link to the file if the upload path is inside the document root if (strstr(realpath($this->uploadPath), $_SERVER['DOCUMENT_ROOT'])) { echo "uploadPath}/{$editdata[$f]}\">{$editdata[$f]}"; } else { echo $editdata[$f]; } echo ' (' . filesize($this->uploadPath . '/' . $editdata[$f]) . " bytes) delete
"; } else { echo $editdata[$f] . ' (does not exist)
'; } } echo 'fieldInputOptions[$f] . " id=\"$f\" name=\"$f\" />"; break; default: echo "'; } echo '

'; echo '

'; if ($action == 'add') echo ''; else if ($action == 'edit') echo ''; echo ''; echo '

'; echo "'; echo '

'; echo '

'; } else if (get_value_from_array($_GET, 'TableEditorAction') == 'export') { // fixme: how to do an export? we cant send headers because its possible that output has already started! } else { $this->displayTable(); } } function defaultGetList() { $sel = array(); $from = array(); $where = array(); foreach ($this->listfields as $f => $n) $sel[] = "`$f`"; $from[] = "`{$this->table}`"; if (count($this->additionalListTables)) { foreach ($this->additionalListTables as $t) { $from[] = "$t "; } } if (count($this->fieldFilterList)) { foreach ($this->fieldFilterList as $k => $v) { $where[] = ($v == false) ? $k : "`$k`='$v'"; } } return array($sel, $from, $where); } function displayTable() { global $icon_path; global $icon_extension; global $editdata; global $pdo; $query = "SELECT SQL_CALC_FOUND_ROWS {$this->primaryKey}"; if (is_callable(array($this->classname, 'tableEditorGetList'))) { list($sel, $from, $where) = call_user_func(array($this->classname, 'tableEditorGetList'), $this); } else { list($sel, $from, $where) = $this->defaultGetList(); } foreach ($sel as $s) $query .= ", $s"; $query .= ' FROM '; foreach ($from as $f) $query .= "$f "; $query .= ' WHERE 1 '; if (is_array($where)) { foreach ($where as $w) $query .= "AND $w "; } if ($this->sortField()) $query .= ' ORDER BY ' . $this->sortField() . ''; if ($this->rowsPerPage > 0) { // first, we treat page 1 as the first page, but really, "row 0" is the first page, so we need // to be careful. // LIMIT offset,number $offset = ($this->activePage - 1) * $this->rowsPerPage; // just to make sure nothing funky is goin on. if ($offset < 0) $offset = 0; $query .= " LIMIT $offset,$this->rowsPerPage"; } if ($this->allowAdding) { echo "" . i18n('Add new %1', array($this->recordType)) . '

'; } if ($this->DEBUG) echo $query; echo $query; $q = $pdo->prepare($query); $q->execute(); if ($q == false) { echo "Sorry, DB query failed:

$query

"; echo 'Error: ' . $pdo->errorInfo(); exit; } // put in some paganation stuff here. $foundrowsq = $pdo->prepare('SELECT FOUND_ROWS() AS f'); $foundrowsq->execute(); $foundrowsr = $foundrowsq->fetch(PDO::FETCH_OBJ); $foundrows = $foundrowsr->f; if ($foundrows > $this->rowsPerPage) { $numpages = ceil($foundrows / $this->rowsPerPage); if ($this->activePage > 1) { $prevpage = $this->activePage - 1; echo "< Prev"; } else echo '< Prev'; echo ' '; if ($numpages < 10) { // if there's less than 10 pages, lets show links for all the pages for ($x = 1; $x <= $numpages; $x++) { echo ' '; if ($x == $this->activePage) echo "$x"; else echo "$x"; echo ' '; } } else { // if we have more than 10 pages, lets show the previous 5 ..currentpage.. next 5 // if there's less than 10 pages, lets show links for all the pages $start = $this->activePage - 4; $end = $this->activePage + 4; if ($start < 1) { $end += abs(1 - $start); $start = 1; } if ($end > $numpages) { $start -= abs($numpages - $end); $end = $numpages; } if ($start > 1) { echo ' '; echo "1"; echo ' '; echo '...'; } for ($x = $start; $x <= $end; $x++) { echo ' '; if ($x == $this->activePage) echo "$x"; else echo "$x"; echo ' '; } if ($end < $numpages) { echo '...'; echo ' '; echo "$numpages"; echo ' '; } } echo ' '; if ($this->activePage < $numpages) { $nextpage = $this->activePage + 1; echo "Next >"; } else echo 'Next >'; } // else // echo "no need to paganate, foundrows=$foundrows, rowsPerPage=".$this->rowsPerPage; echo " (Total: $foundrows)\n"; if ($q->rowCount()) { echo ''; echo ''; foreach ($this->listfields as $f => $n) { if ($this->sortField() == $f) echo ''; else echo "'; } echo ''; echo ''; while ($r = $q->fetch(PDO::FETCH_OBJ)) { echo ''; foreach ($this->listfields as $f => $n) { // figure out what kind of input this should be $typeq = $pdo->prepare("SHOW COLUMNS FROM `{$this->table}` LIKE '$f'"); $typeq->execute(); $typer = $typeq->fetCh(PDO::FETCH_OBJ); if ($typer->Type == 'time') echo ''; else if ($typer->Type == 'date') echo ''; else if ($typer->Type == 'datetime') echo ''; else if (substr($f, 0, 8) == 'filename' && $this->uploadPath) { echo ''; } else if (substr($f, 0, 7) == 'website') { echo ''; } else { if ($this->fieldOptions[$f]) { if (is_array($this->fieldOptions[$f][0])) { // if it is an aray, then we have a key=> and val=> so we need // to lookup the key and display the val $TE_Found_Field = false; foreach ($this->fieldOptions[$f] as $i => $o) { if ($o['key'] == $r->$f) { echo ""; $TE_Found_Field = true; break; } } if (!$TE_Found_Field) { echo ''; } } else { // if its not an array, then each element is simply a data value anyways, so we can just show the value echo ""; } } else { echo ""; } } } echo ''; echo ''; } echo '

' . i18n($n) . '	" . i18n($n) . '	' . i18n('Actions') . '
' . $this->format_time($r->$f) . '	' . $this->format_date($r->$f) . '	' . $this->format_datetime($r->$f) . '	'; if ($this->downloadLink) { $pk = $this->primaryKey; echo "downloadLink}?{$pk}={$r->$pk}\">{$r->$f}"; } else { // only show a link to the file if the upload path is inside the document root if (strstr(realpath($this->uploadPath), $_SERVER['DOCUMENT_ROOT']) && file_exists($this->uploadPath . '/' . $editdata[$f])) { echo "uploadPath}/{$r->$f}\">{$r->$f}"; } else { echo $r->$f; } } echo '	'; echo "$f}\" target=\"_blank\">{$r->$f}"; echo '	{$o['val']}		{$r->$f}	{$r->$f}	'; $pk = $this->primaryKey; // custom action buttons go first if (count($this->actionButtons)) { foreach ($this->actionButtons as $button) { echo "$pk . "\">"; echo ' '; } } // now the default action buttons that you cant get rid of :) echo '$pk . "\">"; echo ' '; if (isset($this->deleteTitle)) { $title = $this->deleteTitle; } else { $title = 'Delete this ' . $this->recordType; } echo "recordType)) . "')\" href=\"{$_SERVER['PHP_SELF']}?TableEditorAction=delete&delete=" . $r->$pk . "\">"; echo '

'; } echo '
'; } function month_selector($name, $selected = '') { echo "\n"; } function year_selector($name, $selected = '') { $now = date('Y'); if ($this->yearSelectRangeMin) $start = $this->yearSelectRangeMin; else $start = $now - 2; if ($this->yearSelectRangeMax) $end = $this->yearSelectRangeMax; else $end = $now + 3; echo "\n"; } function day_selector($name, $selected = '') { echo "\n"; } function hour_selector($name, $selected = '', $disabled = false) { echo "\n"; } function minute_selector($name, $selected = '', $disabled = false) { if ($selected == '') $selected = -1; for ($x = 0; $x < 60; $x++) $mins[] = sprintf('%02d', $x); // $mins=array("00","15","30","45"); echo "\n"; } function format_date($d) { if (!$d) return; list($y, $m, $d) = explode('-', $d); $t = mktime(0, 0, 0, $m, $d, $y); return date($this->dateformat, $t); } function format_time($t) { if (!$t) return; if ($this->timeformat == '12hrs') { list($hh, $mm, $ss) = explode(':', $t); // hack to get rid of leading "0" and turn it into a number $hh++; $hh--; if ($hh == 0) $ret = "12:$mm AM"; else if ($hh < 12) $ret = "$hh:$mm AM"; else if ($hh == 12) $ret = "12:$mm PM"; else $ret = ($hh - 12) . ":$mm PM"; } else if ($this->timeformat == '24hrs') { $ret = substr($t, 0, -3); } return $ret; } function format_datetime($d) { list($d, $t) = explode(' ', $d); $ret = $this->format_date($d) . ' ' . $this->format_time($t); return $ret; } }