$types = array();
+ $tables = array();
$schemas = array($table => $d->table());
foreach($cols as $name=>$table_col) {
if (!isset($schemas[$tbl])) {
$schemas[$tbl] = DB_DataObject::Factory($tbl)->table();
}
- $types[$name] = $schemas[$tbl][$table_col];
-
-
+ $types[$name] = $schemas[$tbl][$col];
+ $tables[$name] = $tbl;
}
foreach($re['join_names'] as $c=>$f) {
$ret[] = array(
'name' => $c,
'val' => $f,
- 'type' => isset($types[$c]) ? $types[$c] : -1,
+ 'type' => isset($types[$c]) ? $this->typeToName($types[$c]) : -1,
+ 'table' => isset($tables[$c]) ? $tables[$c] : "",
);
}
$this->jdata($ret);
}
-}
\ No newline at end of file
+
+ function typeToName($t)
+ {
+ switch(true) {
+ case ($t & 64): return 'text';
+ case ($t & 32): return 'text';
+ case ($t & 4 && $t & 8): return 'datetime';
+ case ($t & 4): return 'date';
+ case ($t & 8): return 'time';
+ case ($t & 16): return 'bool';
+ case ($t & 2): return 'varchar';
+ case ($t & 1): return 'number';
+
+ }
+ return '??';
+
+ }
+}