$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%'");
return $au->hasPerm("Core.Companies", $lvl);
}
- function logoImageTag($size)
+ function logoImageToHTML($size)
{
-
+ $i = DB_DataObject::factory('Images');
+ 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);
}
+ function toRooSingleArray($authUser, $request)
+ {
+ $ret = $this->toArray();
+ // DB_DataObject::debugLevel(1);
+ // get the comptype display
+ $e = DB_DataObject::Factory('core_enum');
+ $e->etype = 'COMPTYPE';
+ $e->name = $this->comptype;
+ $ret['comptype_display'] = $ret['comptype'];
+ if ($e->find(true) && !empty($e->name_display)) {
+ $ret['comptype_display'] = $e->name_display;
+ }
+
+
+ return $ret;
+ }
}