3 require_once 'Pman.php';
5 class Pman_Core_DatabaseColumns extends Pman {
10 parent::getAuth(); // load company!
11 $au = $this->getAuthUser();
14 $this->jerror("LOGIN-NOAUTH", "Not authenticated", array('authFailure' => true));
16 if (!$au->pid() ) { // not set up yet..
17 $this->jerror("LOGIN-NOAUTH", "Not authenticated", array('authFailure' => true));
21 $this->authUser = $au;
25 function get($table, $opts = Array()) {
26 $d = DB_DAtaObject::Factory($table);
27 if (method_exists($d, 'availableColumns')) {
28 $cols = $d->availableColumns();
32 //echo '<PRE>';print_r($re);
38 $schemas = array($table => $d->table());
40 foreach($cols as $name=>$table_col) {
41 list($tbl, $col) = explode('.', $table_col);
42 if (!isset($schemas[$tbl])) {
43 $schemas[$tbl] = DB_DataObject::Factory($tbl)->table();
45 $types[$name] = $schemas[$tbl][$col];
46 $tables[$name] = $tbl;
49 foreach($re['join_names'] as $c=>$f) {
57 foreach($cols as $c=>$f) {
61 'type' => isset($types[$c]) ? $this->typeToName($types[$c]) : -1,
62 'table' => isset($tables[$c]) ? $tables[$c] : "",
70 function typeToName($t)
73 case ($t & 64): return 'text';
74 case ($t & 32): return 'text';
75 case ($t & 4 && $t & 8): return 'datetime';
76 case ($t & 4): return 'date';
77 case ($t & 8): return 'time';
78 case ($t & 16): return 'bool';
79 case ($t & 2): return 'varchar';
80 case ($t & 1): return 'number';