public function listLUByWordForm($wordform)
{
$criteria = $this->getCriteria();
$criteria->select('lexeme.lexemeentries.lemma.lus.idLU');
$criteria->where("upper(form) = upper('{$wordform}')");
$lus = $criteria->asQuery()->chunkResult('idLU', 'idLU');
if (count($lus) > 0) {
$lu = new LU();
$criteria = $lu->getCriteria()->select("idLU, concat(frame.entries.name,'.',name) as fullName");
Base::relation($criteria, 'lu', 'frame', 'rel_evokes');
Base::entryLanguage($criteria, 'frame');
$criteria->where("idLU", "IN", $lus);
$criteria->where("lemma.idLanguage", "=", "frame.entries.idLanguage");
return $criteria->asQuery()->chunkResult('idLU', 'fullName');
} else {
return new \stdClass();
}
}
