';
//$html.=$this->input('table', $class, 'hidden');
@@ -249,7 +261,7 @@ EOF;
$name="values[$class][".$column['Field'].'][]';
$val = $update ? $current[$column['Field']] : false;
switch(true) {
- case preg_match('/auto_increment/', $column['Extra']):
+ case (preg_match('/auto_increment/', $column['Extra']) || in_array($column['Field'], $hidecols)):
if(!$val) $val = '';
$html.=$this->input($name, $val, 'hidden');
$html.=$val.'(AUTO)';
@@ -329,8 +341,7 @@ class Sklad_DB extends PDO {
if($search) {
$search = $this->quote($search);
if(!isset($search_fields[$class])) {
- trigger_error("Ve tride $class zatim vyhledavat nemozno :-(");
- die();
+ $this->post_redirect_get($class, "Ve tride $class zatim vyhledavat nemozno :-(");
}
$where[0] = 'FALSE ';
foreach($search_fields[$class] as $column) $where[0] .= "OR $column REGEXP $search ";
@@ -383,7 +394,8 @@ class Sklad_DB extends PDO {
if(!preg_match('/'.$suffix_id.'$/', $column['Field'])) continue;
$table=preg_replace('/'.$suffix_id.'$/','',$column['Field']);
- $sql = "SELECT $table$suffix_id, $table$suffix_name FROM $table;"; //TODO History
+ $history = $this->contains_history($table) ? ' WHERE '.$table.'_valid_till=0' : '';
+ $sql = "SELECT $table$suffix_id, $table$suffix_name FROM $table$history;";
$result = $this->safe_query($sql, false);
if(!$result) continue;
$result = $result->fetchAll(PDO::FETCH_ASSOC);
@@ -483,7 +495,7 @@ class Sklad_DB extends PDO {
}
function delete($table, $id, $suffix_id='_id') {
- if($this->contains_history($table)) die(trigger_error("V tabulce $table jentak neco mazat nebudes chlapecku :-P")); //TODO post redirect get
+ if($this->contains_history($table)) return false;
$key = $this->escape($table.$suffix_id);
$table = $this->escape($table);
$id = $this->quote($id);
@@ -491,6 +503,16 @@ class Sklad_DB extends PDO {
}
}
+/**
+* Trida poskytuje high-level rozhrani k databazi skladu
+*
+* @package Sklad_DB_Abstract
+* @author Tomas Mudrunka
+*/
+class Sklad_DB_Abstract extends Sklad_DB {
+ //TODO Code
+}
+
/**
* Trida implementuje uzivatelske rozhrani skladu
*
@@ -559,7 +581,6 @@ class Sklad_UI {
$html.=$this->render_listing_navigation($class, '*', $limit, $offset);
}
if($edit) {
- $html.='
TODO UPDATE FORM!
'; //TODO: Asi uz je hotovy...
$html.= $this->render_form_edit($class, $id);
$action = $_SERVER['SCRIPT_NAME']."/$class/$id/delete";
$html.= "