/**
* @param $body Html body of mail
* @return Gpf_Data_RecordSet
*/
protected function getIncludedFilesRecordset($body)
{
$fileIds = $this->includedImageFileIds;
if (count($fileIds) == 0) {
return new Gpf_Data_RecordSet();
}
$sql = new Gpf_SqlBuilder_SelectBuilder();
$sql->select->addAll(Gpf_Db_Table_Files::getInstance());
$sql->from->add(Gpf_Db_Table_Files::getName());
$sql->where->add(Gpf_Db_Table_Files::ID, 'IN', $fileIds);
try {
return $sql->getAllRows();
} catch (Gpf_DbEngine_NoRowException $e) {
return new Gpf_Data_RecordSet();
}
}
function init()
{
$this->setTable(Gpf_Db_Table_Files::getInstance());
parent::init();
}
/**
* @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());
}
