public function getTitle($idLanguage = '') { $criteria = $this->getCriteria()->select('lu.name luName, name, lu.idLu')->orderBy('name'); Base::relation($criteria, 'lu', 'subcorpus', 'rel_hassubcorpus'); $criteria->where("idSubCorpus = {$this->idSubCorpus}"); $result = $criteria->asQuery()->getResult(); $frame = new Frame(); $criteriaFrame = $frame->getCriteria()->select('frame.entries.name as name'); Base::Relation($criteriaFrame, 'lu', 'frame', 'rel_evokes'); Base::entryLanguage($criteriaFrame); $criteriaFrame->where("lu.idLu = '{$result[0]['idLu']}'"); $resultFrame = $criteriaFrame->asQuery()->getResult(); return $resultFrame[0]['name'] . '.' . $result[0]['luName'] . ' [' . $result[0]['name'] . ']'; }
public function getBaseFrame() { // if template was created from a frame, this frame is the "base frame" $frame = new Frame(); $criteria = $frame->getCriteria()->select('idFrame, entries.name as name, entries.description as description')->orderBy('entries.name'); Base::relation($criteria, 'template', 'frame', 'rel_createdfrom'); $criteria->where("template.idEntity = {$this->getIdEntity()}"); Base::entryLanguage($criteria); return $criteria; }