X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_enum.php;h=3deca2711921c226cb9566f339aa3fbe2039b7ae;hb=525e6bb56ef8023085498f2def3f8fb187a451e2;hp=6943a0ff7ea14150382df52f4f14990563640497;hpb=e8138336a5eaa7e9094a827339f2760e3277e7cd;p=Pman.Core diff --git a/DataObjects/Core_enum.php b/DataObjects/Core_enum.php index 6943a0ff..3deca271 100644 --- a/DataObjects/Core_enum.php +++ b/DataObjects/Core_enum.php @@ -21,7 +21,7 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject /* the code above is auto generated do not remove the tag below */ ###END_AUTOCODE - function applyFilters($q, $au) + function applyFilters($q, $au, $roo) { // DB_DataObject::debugLevel(1); @@ -57,8 +57,18 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject core_enum.display_name LIKE '%{$name}%' "); } + if(!empty($q['query']['search_begins'])) { + $name = $this->escape($q['query']['search_begins']); + // ilike on postgres?!? + $this->whereAdd(" + core_enum.name LIKE '{$name}%' + OR + core_enum.display_name LIKE '{$name}%' + "); + } + if (isset($q['_etypes'])) { - $this->whereAddIn('core_enu.etype', explode(',', $q['_etypes']), 'string'); + $this->whereAddIn('core_enum.etype', explode(',', $q['_etypes']), 'string'); } } @@ -136,9 +146,10 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject // check if record exists? if(isset($request['etype']) && !($old->etype == $request['etype'] && $old->name == $request['name'])){ $x->whereAdd("etype = '{$this->escape($request['etype'])}' AND name = '{$this->escape($request['name'])}'"); + $x->whereAdd("id != ".((int) $this->id)); $x->find(true); if($x->count() > 0){ - $roo->jerr('record already exists'); + $roo->jerr('a duplicate record already exists'); } } } @@ -160,12 +171,13 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject } } - function onInsert($req) + function onInsert($req, $roo) { $x = $this->factory($this->tableName()); $x->query("SELECT core_enum_seqmax_update('". $this->escape($this->etype) ."')"); // no idea why need to do this!!?? } + function onUpdate($old, $req) { $x = $this->factory($this->tableName());