public function listFE() { $fe = new FrameElement(); $criteria = $fe->getCriteria()->select('idFrameElement, entry, entries.name as name, typeinstance.entry as coreType, color.rgbFg, color.rgbBg, ' . 'typeinstance.idTypeInstance as idCoreType, color.idColor'); Base::entryLanguage($criteria); Base::relation($criteria, 'frameelement', 'frame', 'rel_elementof'); Base::relation($criteria, 'frameelement', 'typeinstance', 'rel_hastype'); $criteria->where("frame.idFrame = {$this->idFrame}"); $criteria->orderBy('typeinstance.idTypeInstance, entries.name'); return $criteria; }
public function listTemplatedFEs($idFETemplate) { $frameElement = new FrameElement(); $criteria = $frameElement->getCriteria()->select('fe1.idFrameElement, fe1.entries.name as name, fe1.entries.description as description')->orderBy('fe1.entries.name'); Base::entryLanguage($criteria, 'frameelement'); Base::relation($criteria, 'frameelement fe1', 'frameelement fe2', 'rel_hastemplate'); $criteria->where("fe2.idFrameElement = {$idFETemplate}"); return $criteria; }