PHP Base::entryLanguage方法代码示例

 public function listByFilter($filter)
 {
     $criteria = $this->getCriteria()->select('idFrame, entry, active, idEntity, entries.name as name')->orderBy('entries.name');
     Base::entryLanguage($criteria);
     if ($filter->idFrame) {
         $criteria->where("idFrame = {$filter->idFrame}");
     }
     if ($filter->frame) {
         $criteria->where("entries.name LIKE '{$filter->frame}%'");
     }
     if ($filter->lu) {
         $criteria->distinct(true);
         $criteria->where("lus.name LIKE '{$filter->lu}%'");
     }
     if ($filter->idLU) {
         if (is_array($filter->idLU)) {
             $criteria->where("lus.idLU", "IN", $filter->idLU);
         } else {
             $criteria->where("lus.idLU = {$filter->idLU}");
         }
     }
     if ($filter->fe) {
         $criteria->distinct(true);
         $criteria->associationAlias("fes.entries", "feEntries");
         Base::entryLanguage($criteria, "feEntries.");
         $criteria->where("feEntries.name LIKE '{$filter->fe}%'");
     }
     return $criteria;
 }

 public function listForEditor($idEntityCxn)
 {
     $criteria = $this->getCriteria()->select('idEntity,entries.name as name')->orderBy('entries.name');
     Base::entryLanguage($criteria);
     Base::relation($criteria, 'constructionelement', 'construction', 'rel_elementof');
     $criteria->where("construction.idEntity = {$idEntityCxn}");
     return $criteria;
 }

 public function listAnnotationStatus($filter)
 {
     $criteria = $this->getCriteria()->select('idTypeInstance as idAnnotationStatus, entry, entries.name as name, idColor, color.name as colorName, color.rgbFg, color.rgbBg')->orderBy('entry');
     Base::entryLanguage($criteria);
     $criteria->where("entry like 'ast_%'");
     if ($filter->entry) {
         $criteria->where("entry LIKE '{$filter->entry}%'");
     }
     return $criteria;
 }

 public function listByCorpus($idCorpus)
 {
     $criteria = $this->getCriteria()->select('idDocument, entry, entries.name as name, count(paragraphs.sentences.idSentence) as quant')->orderBy('entries.name');
     $criteria->setAssociationType('paragraphs.sentences', 'left');
     $criteria->setAssociationType('paragraphs', 'left');
     Base::entryLanguage($criteria);
     $criteria->where("idCorpus = {$idCorpus}");
     $criteria->groupBy("idDocument, entry, entries.name");
     return $criteria;
 }

 public function listCE()
 {
     $ce = new ConstructionElement();
     $criteria = $ce->getCriteria()->select('idConstructionElement, entry, entries.name as name, color.rgbFg, color.rgbBg, color.idColor');
     Base::entryLanguage($criteria);
     Base::relation($criteria, 'constructionelement', 'construction', 'rel_elementof');
     $criteria->where("construction.idConstruction = {$this->getId()}");
     $criteria->orderBy('entries.name');
     return $criteria;
 }

 public function getInstantiationType($entry = '')
 {
     $criteria = $this->getCriteria();
     $criteria->select("typeinstances.idTypeInstance as idInstantiationType,  typeinstances.entries.name as instantiationType");
     $criteria->where("entry = 'typ_instantiationtype'");
     if ($entry != '') {
         $criteria->where("typeinstances.entry = '{$entry}'");
     }
     Base::entryLanguage($criteria, 'typeinstances');
     return $criteria;
 }

 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();
     }
 }

 public function listByFilter($filter)
 {
     $criteria = $this->getCriteria()->select('idCorpus, entry, entries.name as name')->orderBy('entries.name');
     Base::entryLanguage($criteria);
     if ($filter->idCorpus) {
         $criteria->where("idCorpus = '{$filter->idCorpus}'");
     }
     if ($filter->corpus) {
         $criteria->where("upper(entries.name) LIKE upper('%{$filter->corpus}%')");
     }
     if ($filter->entry) {
         $criteria->where("upper(entry) LIKE upper('%{$filter->entry}%')");
     }
     if ($filter->document) {
         Base::entryLanguage($criteria, 'documents');
         $criteria->where("upper(documents.entries.name) LIKE upper('%{$filter->document}%')");
     }
     return $criteria;
 }

 public function listByGroup()
 {
     $criteria = $this->getCriteria()->select('idLayerType, entries.name name')->orderBy('idLayerGroup, entries.name');
     Base::entryLanguage($criteria);
     return $criteria;
 }

 public function listCoreForEditor($idEntityFrame)
 {
     $criteria = $this->getCriteria()->select('idEntity,entries.name as name')->orderBy('entries.name');
     Base::entryLanguage($criteria);
     Base::relation($criteria, 'frameelement', 'typeinstance', 'rel_hastype');
     Base::relation($criteria, 'frameelement', 'frame', 'rel_elementof');
     $criteria->where("typeinstance.entry = 'cty_core'");
     $criteria->where("frame.idEntity = {$idEntityFrame}");
     return $criteria;
 }

 public function getLayers($idSentence)
 {
     $criteria = $this->getCriteria();
     $criteria->select('layers.idLayer, layers.layertype.entries.name as name, idAnnotationSet');
     $criteria->where("idSentence = {$idSentence}");
     if (!\Manager::checkAccess('MASTER', A_EXECUTE)) {
         $criteria->where("idAnnotationSet = {$this->getId()}");
     }
     Base::entryLanguage($criteria, 'layers.layertype');
     return $criteria->asQuery()->getResult();
 }

 public function getStats()
 {
     $criteria = $this->getCriteria()->select('annotationsets.annotationStatus.entry, annotationsets.annotationStatus.entries.name, count(*) as quant')->where("idSubCorpus = {$this->getId()}")->groupBy('annotationsets.annotationStatus.entry', 'annotationsets.annotationStatus.entries.name');
     Base::entryLanguage($criteria, 'annotationsets.annotationStatus');
     $result = (object) $criteria->asQuery()->getResult();
     return $result;
 }

 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;
 }

 public function listAll()
 {
     $criteria = $this->getCriteria()->select('idDomain, entries.name as name')->orderBy('entries.name');
     Base::entryLanguage($criteria);
     return $criteria;
 }

 public function listForConstraint($array)
 {
     $idLanguage = \Manager::getSession()->idLanguage;
     $criteria = $this->getCriteria()->select("idLU as del, idLU, concat(frame.entries.name,'.',name) as fullname")->orderBy('frame.entries.name,name');
     $criteria->where("idLU", "IN", $array);
     Base::relation($criteria, 'lu', 'frame', 'rel_evokes');
     Base::entryLanguage($criteria, 'frame');
     $criteria->where("lemma.idLanguage = {$idLanguage}");
     return $criteria;
 }