<?php
/**
- * Table Definition for core company
+ * Table Definition for core enum - it's used in pulldowns or simple option lists.
*/
require_once 'DB/DataObject.php';
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_enum.etype', explode(',', $q['_etypes']), 'string');
}
if(empty($req['etype'])){
if($x->get('name', $req['name'])){
- $roo->jerr('name is exsiting');
+ $roo->jerr('name already exists');
}
}else{
$x->whereAdd("etype = '{$this->escape($req['etype'])}' AND name = '{$this->escape($req['name'])}'");
- $x->count();
- print_R($x);exit;
+ $x->find(true);
if($x->count() > 0){
- $roo->jerr('is exsiting');
+ $roo->jerr('name already exists');
}
}
}