$x = DB_DataObject::factory('core_company');
$x->comptype= 'OWNER';
$x->find(true);
-
+
if (!empty($q['query']['company_project_id'])) {
$add = '';
if (!empty($q['query']['company_include_self'])) {
if (!empty($q['query']['company_not_self'])) {
$add = " AND {$tn}.id != {$x->id}";
}
+
$pids = array();
$pid = $q['query']['company_project_id'];
if (strpos($pid, ',')) {
$this->whereAddIn('comptype', explode(',', $q['query']['comptype']), 'string');
}
-
+ /*if (!empty($q['query']['deleted_by'])) {
+ $deleted_by = $this->escape($q['query']['deleted_by']);
+ $this->whereAdd("deleted_by = '$deleted_by'");
+ }*/
// depricated - should be moved to module specific (texon afair)
if (!empty($q['query']['province'])) {
) as comptype_display_name
");
- if(!empty($q['search']['name'])){
- $s = $this->escape($q['search']['name']);
+ if(!empty($q['query']['name'])){
+ $s = $this->escape($q['query']['name']);
$this->whereAdd("
{$tn}.name LIKE '%$s%'
");
function beforeDelete($req, $roo)
{
+
// should check for members....
if(!empty($this->is_system) &&
($old->code != $this->code || $old->name != $this->name)
}
}
function onDelete($req, $roo)
- {
+ {
+
$img = DB_DataObject::factory('Images');
$img->ontable = $this->tableName();
$img->onid = $this->id;
if (!empty($q['query']['empty_etype'])) {
$this->whereAdd("core_enum.etype = ''");
}
+
+ if(!empty($q['query']['name'])){
+ $search_name = $this->escape($q['query']['name']);
+ $this->whereAdd("
+ core_enum.name LIKE '%$search_name%'
+ ");
+ }
// this should be handled by roo... using '!name[0]' ....
if(!empty($q['!name'])){