X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DatabaseColumns.php;h=fd674a3082a9ec51abda4197ca25a4504c698110;hp=78c5e3b986f00ffa3bd1360945ea56e90ba5d45d;hb=refs%2Fheads%2Fwip_alan_T5884_add_photo_to_report;hpb=ce9e7045dc2021a5d7e21cc5e805637a2f88a3ab

diff --git a/DatabaseColumns.php b/DatabaseColumns.php
index 78c5e3b9..fd674a30 100644
--- a/DatabaseColumns.php
+++ b/DatabaseColumns.php
@@ -1,7 +1,86 @@
 <?php
 
+require_once 'Pman.php';
+
 class Pman_Core_DatabaseColumns extends Pman {
     
     
+    function getAuth()
+    {
+        parent::getAuth(); // load company!
+        $au = $this->getAuthUser();
+       
+        if (!$au) {  
+            $this->jerr("Not authenticated", array('authFailure' => true));
+        }
+        if (!$au->pid()   ) { // not set up yet..
+            $this->jerr("Not authenticated", array('authFailure' => true));
+        }
+        
+        
+        $this->authUser = $au;
+        return true;
+    }
+    
+    function get($table, $opts = Array()) {
+        $d = DB_DAtaObject::Factory($table);
+        if (method_exists($d, 'availableColumns')) {
+            $cols = $d->availableColumns();
+        } else {
+            
+            $re = $d->autoJoin();
+            //echo '<PRE>';print_r($re);
+            $cols = $re['cols'] ;
+            
+            
+            $types = array();
+            $tables = array();
+            $schemas = array($table => $d->table());
+            
+            foreach($cols as $name=>$table_col) {
+                list($tbl, $col) = explode('.', $table_col);
+                if (!isset($schemas[$tbl])) {
+                    $schemas[$tbl] = DB_DataObject::Factory($tbl)->table();
+                }
+                $types[$name] = $schemas[$tbl][$col];
+                $tables[$name] = $tbl;
+            }
+             
+            foreach($re['join_names'] as $c=>$f) {
+                $cols[$c] = $f;
+            }
+            
+        }
+        
+        
+        
+        foreach($cols as $c=>$f) {
+            $ret[]  = array(
+                'name' => $c,
+                'val' => $f,
+                '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 '??';
+        
+    }
+}