DataObjects/core.sql

[Pman.Core] / DataObjects / Companies.php

diff --git a/DataObjects/Companies.php b/DataObjects/Companies.php
index b727d31..0764d35 100644 (file)
--- a/DataObjects/Companies.php
+++ b/DataObjects/Companies.php
@@ -70,16 +70,16 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
             $this->whereAdd("Companies.id IN (
                 SELECT distinct(company_id) FROM ProjectDirectory where project_id IN ($pids)
             ) $add" );
-            
-           
-            
+             
         }
         if (!empty($q['query']['comptype'])) {
            
             $this->whereAddIn('comptype', explode(',', $q['query']['comptype']), 'string');
             
         }
-         
+        
+        // depricated - should be moved to module specific (texon afair)
+        
          if (!empty($q['query']['province'])) {
              $prov = $this->escape($q['query']['province']);
             $this->whereAdd("province LIKE '$prov%'");
@@ -262,12 +262,31 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
     function logoImageToHTML($size)
     {
         $i = DB_DataObject::factory('Images');
-        if (!$this->logo_id || $i->get($this->logo_id)) {
+        if (!$this->logo_id || !$i->get($this->logo_id)) {
             return '';
         }
         return $i->toHTML($size);
         
     }
+     function firstImage($filter='image/%')
+    {
+        $i = DB_DataObject::factory('Images');
+        //DB_DataObject::debugLevel(1);
+        $im = $i->gather($this, $filter);
+        if (empty($im)) {
+            return false;
+        }
+        return $im[0];
+    }
+    
+    function firstImageTag($size =-1, $base="/Images/Thumb", $filter='image/%')
+    {
+        $fm = $this->firstImage($filter);
+         if (empty($fm)) {
+            return '';
+        }
+        return $fm->toHTML($size, $base);
+    }