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