/** * @return Gpf_DbEngine_Row_Collection<Gpf_Db_File> */ public function getAttachements() { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->addAll(Gpf_Db_Table_Files::getInstance(), 'f'); $select->from->add(Gpf_Db_Table_MailAttachments::getName(), 'ma'); $select->from->addInnerJoin(Gpf_Db_Table_Files::getName(), 'f', 'ma.' . Gpf_Db_Table_MailAttachments::FILE_ID . ' = f.' . Gpf_Db_Table_Files::ID); $select->where->add("ma." . Gpf_Db_Table_Mails::ID, "=", $this->getId()); $file = new Gpf_Db_File(); return $file->loadCollectionFromRecordset($select->getAllRows()); }