/** * Return all mail attachments for given mail id * * @param int $mailId * @return Gpf_Data_RecordSet */ public static function getMailAttachments($mailId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add('f.*'); $select->select->add('ma.is_included_image', 'is_included_image'); $select->from->add(Gpf_Db_Table_MailAttachments::getName(), 'ma'); $select->from->addInnerJoin(Gpf_Db_Table_Files::getName(), 'f', 'f.fileid=ma.fileid'); $select->where->add('mailid', '=', $mailId); return $select->getAllRows(); }
/** * @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()); }